PHP invoice::get_invoice_statii Examples

Example #1

File: invoice.php Project: cjbayliss/alloc

                alloc_redirect($TPL["url_alloc_invoice"] . "invoiceID=" . $invoiceID);
            }
        }
    }
}
if ($invoiceID && $invoiceItemIDs) {
    $currency = $invoice->get_value("currencyTypeID");
    $q = prepare("SELECT SUM(IF((iiTax IS NULL OR iiTax = 0) AND value,\n                          (value/100+1) * iiAmount * pow(10,-currencyType.numberToBasic),\n                          iiAmount * pow(10,-currencyType.numberToBasic)\n                      )) as sum_iiAmount\n                  FROM invoiceItem \n             LEFT JOIN invoice on invoiceItem.invoiceID = invoice.invoiceID\n             LEFT JOIN currencyType on invoice.currencyTypeID = currencyType.currencyTypeID\n             LEFT JOIN config ON config.name = 'taxPercent'\n                 WHERE invoiceItem.invoiceID = %d", $invoiceID);
    $db->query($q);
    $db->next_record() and $TPL["invoiceTotal"] = page::money($currency, $db->f("sum_iiAmount"), "%S%m %c");
    $q = prepare("SELECT sum(amount * pow(10,-currencyType.numberToBasic)) as sum_transaction_amount\n                  FROM transaction \n             LEFT JOIN currencyType on transaction.currencyTypeID = currencyType.currencyTypeID\n                 WHERE status = 'approved' \n                   AND invoiceItemID in (%s)", $invoiceItemIDs);
    $db->query($q);
    $db->next_record() and $TPL["invoiceTotalPaid"] = page::money($currency, $db->f("sum_transaction_amount"), "%S%m %c");
}
$invoice->set_values();
$statii = invoice::get_invoice_statii();
foreach ($statii as $s => $label) {
    unset($pre, $suf);
    // prefix and suffix
    $status = $invoice->get_value("invoiceStatus");
    if (!$invoice->get_id()) {
        $status = "create";
    }
    if ($s == $status) {
        $pre = "<b>";
        $suf = "</b>";
    }
    $TPL["invoice_status_label"] .= $sep . $pre . $label . $suf;
    $sep = "&nbsp;&nbsp;|&nbsp;&nbsp;";
}
# if ($invoice->get_id() && is_dir(ATTACHMENTS_DIR."invoice".DIRECTORY_SEPARATOR.$invoice->get_id())) {

Example #2

File: invoice.inc.php Project: cjbayliss/alloc

 function load_invoice_filter($_FORM)
 {
     global $TPL;
     // Load up the forms action url
     $rtn["url_form_action"] = $_FORM["url_form_action"];
     $statii = invoice::get_invoice_statii();
     unset($statii["create"]);
     $rtn["statusOptions"] = page::select_options($statii, $_FORM["invoiceStatus"]);
     $statii_payment = invoice::get_invoice_statii_payment();
     $rtn["statusPaymentOptions"] = page::select_options($statii_payment, $_FORM["invoiceStatusPayment"]);
     $rtn["status"] = $_FORM["status"];
     $rtn["dateOne"] = $_FORM["dateOne"];
     $rtn["dateTwo"] = $_FORM["dateTwo"];
     $rtn["invoiceID"] = $_FORM["invoiceID"];
     $rtn["invoiceName"] = $_FORM["invoiceName"];
     $rtn["invoiceNum"] = $_FORM["invoiceNum"];
     $rtn["invoiceItemID"] = $_FORM["invoiceItemID"];
     $options["clientStatus"] = "Current";
     $options["return"] = "dropdown_options";
     $ops = client::get_list($options);
     $ops = array_kv($ops, "clientID", "clientName");
     $rtn["clientOptions"] = page::select_options($ops, $_FORM["clientID"]);
     // Get
     $rtn["FORM"] = "FORM=" . urlencode(serialize($_FORM));
     return $rtn;
 }