function fn_gift_certificates_quickbooks_export_order($order, $order_products, $spl, &$export) { $order_date = fn_date_format($order['timestamp'], "%m/%d/%Y"); $trns_class = Registry::get('addons.quickbooks.trns_class'); if (!empty($order['gift_certificates'])) { foreach ($order['gift_certificates'] as $gift) { // Check wether gift certificate is taxable $taxable = !empty($gift['tax_value']) ? 'Y' : 'N'; $export[] = sprintf($spl, $order_date, Registry::get('addons.quickbooks.accnt_product'), fn_quickbooks_escape_field($order['b_lastname']), fn_quickbooks_escape_field($order['b_firstname']), $trns_class, -$gift['amount'], $order['order_id'], 'GIFT CERTIFICATE:', $gift['gift_cert_code'], $gift['amount'], -1, 'GIFT CERTIFICATE', $taxable, ''); } } if (!empty($order['use_gift_certificates'])) { foreach ($order['use_gift_certificates'] as $code => $use_gift) { $export[] = sprintf($spl, $order_date, Registry::get('addons.quickbooks.accnt_discount'), fn_quickbooks_escape_field($order['b_lastname']), fn_quickbooks_escape_field($order['b_firstname']), Registry::get('addons.quickbooks.trns_class'), $use_gift['cost'], $order['order_id'], 'GIFT CERTIFICATE:', $code, -$use_gift['cost'], -1, 'GIFT CERTIFICATE', 'N', ''); } } }
function fn_quickbooks_export_payments($orders, &$export) { $exists_order_complete = false; $payments = array(); $payments[] = "!TRNS\tTRNSTYPE\tDATE\tACCNT\tNAME\tAMOUNT\tPAYMETH\tDOCNUM"; $payments[] = "!SPL\tTRNSTYPE\tDATE\tACCNT\tNAME\tAMOUNT\tDOCNUM"; $payments[] = "!ENDTRNS\t"; $trns = "TRNS\tPAYMENT\t%s\tUndeposited Funds\t\"%s, %s\"\t%01.2f\t%s\t%d"; $spl = "SPL\tPAYMENT\t%s\tAccounts Receivable\t\"%s, %s\"\t%01.2f\t%d"; foreach ($orders as $order) { if (in_array($order['status'], fn_get_order_paid_statuses())) { $order_date = fn_date_format($order['timestamp'], "%m/%d/%Y"); $payments[] = sprintf($trns, $order_date, fn_quickbooks_escape_field($order['b_lastname']), fn_quickbooks_escape_field($order['b_firstname']), $order['total'], $order['payment_method']['payment'], $order['order_id']); $payments[] = sprintf($spl, $order_date, fn_quickbooks_escape_field($order['b_lastname']), fn_quickbooks_escape_field($order['b_firstname']), -$order['total'], $order['order_id']); $payments[] = "ENDTRNS\t"; $exists_order_complete = true; } } if ($exists_order_complete) { $payments[] = ''; $export = array_merge($export, $payments); } return true; }