Exemplo n.º 1
0
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', '');
        }
    }
}
Exemplo n.º 2
0
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;
}