本文整理汇总了PHP中get_customer_trans函数 的典型用法代码示例。如果您正苦于以下问题:PHP get_customer_trans函数的具体用法?PHP get_customer_trans怎么用?PHP get_customer_trans使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了get_customer_trans函数 的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: edit_link
function edit_link($row)
{
global $editors;
$ok = true;
if ($row['type'] == ST_SALESINVOICE) {
$myrow = get_customer_trans($row["type_no"], $row["type"]);
if ($myrow['alloc'] != 0 || get_voided_entry(ST_SALESINVOICE, $row["type_no"]) !== false) {
$ok = false;
}
}
return isset($editors[$row["type"]]) && !is_closed_trans($row["type"], $row["type_no"]) && $ok ? pager_link(_("Edit"), sprintf($editors[$row["type"]], $row["type_no"], $row["type"]), ICON_EDIT) : '';
}
开发者ID:knjy24, 项目名称:FrontAccounting, 代码行数:12, 代码来源:journal_inquiry.php
示例2: get_allocations_for_transaction
function get_allocations_for_transaction($type, $trans_no)
{
clear_allocations();
$debtor = get_customer_trans($trans_no, $type);
$_SESSION['alloc'] = new allocation($trans_no, $type, $debtor["debtor_no"], $debtor["DebtorName"], $debtor["Total"], sql2date($debtor["tran_date"]));
/* Now populate the array of possible (and previous actual) allocations for this customer */
/*First get the transactions that have outstanding balances ie Total-alloc >0 */
$trans_items = get_allocatable_to_cust_transactions($_SESSION['alloc']->person_id);
while ($myrow = db_fetch($trans_items)) {
$_SESSION['alloc']->add_item($myrow["type"], $myrow["trans_no"], sql2date($myrow["tran_date"]), sql2date($myrow["due_date"]), $myrow["Total"], $myrow["alloc"], 0);
// this allocation
}
/* Now get trans that might have previously been allocated to by this trans
NB existing entries where still some of the trans outstanding entered from
above logic will be overwritten with the prev alloc detail below */
$trans_items = get_allocatable_to_cust_transactions($_SESSION['alloc']->person_id, $trans_no, $type);
while ($myrow = db_fetch($trans_items)) {
$_SESSION['alloc']->add_or_update_item($myrow["type"], $myrow["trans_no"], sql2date($myrow["tran_date"]), sql2date($myrow["due_date"]), $myrow["Total"], $myrow["alloc"] - $myrow["amt"], $myrow["amt"]);
}
}
开发者ID:ravenii, 项目名称:guardocs, 代码行数:20, 代码来源:customer_allocate.php
示例3: print_invoices
function print_invoices()
{
global $path_to_root, $alternative_tax_include_on_docs, $suppress_tax_rates, $no_zero_lines_amount;
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$currency = $_POST['PARAM_2'];
$email = $_POST['PARAM_3'];
$pay_service = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$customer = $_POST['PARAM_6'];
$orientation = $_POST['PARAM_7'];
if (!$from || !$to) {
return;
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$fno = explode("-", $from);
$tno = explode("-", $to);
$from = min($fno[0], $tno[0]);
$to = max($fno[0], $tno[0]);
$cols = array(4, 40, 60, 100, 200, 250, 300, 320, 400, 450, 500);
// $headers in doctext.inc
$aligns = array('left', 'left', 'left', 'left', 'right', 'right', 'right', 'right', 'right', 'right', 'right');
//$params = array('comments' => $comments);
$cur = get_company_Pref('curr_default');
$company_data = get_company_prefs();
if ($email == 0) {
$rep = new FrontReport(_('INVOICE'), "InvoiceBulk", user_pagesize(), 9, $orientation);
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
for ($i = $from; $i <= $to; $i++) {
if (!exists_customer_trans(ST_SALESINVOICE, $i)) {
continue;
}
$sign = 1;
$myrow = get_customer_trans($i, ST_SALESINVOICE);
if ($customer && $myrow['debtor_no'] != $customer) {
continue;
}
$baccount = get_default_bank_account($myrow['curr_code']);
$params['bankaccount'] = $baccount['id'];
$branch = get_branch($myrow["branch_code"]);
$sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER);
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);
//$rep->title = _('INVOICE');
$rep->filename = "Invoice" . $myrow['reference'] . ".pdf";
}
$rep->SetHeaderType(0);
$rep->currency = $cur;
$rep->Font();
$rep->Info(null, $cols, null, $aligns);
//$contacts = get_branch_contacts($branch['branch_code'], 'invoice', $branch['debtor_no'], true);
//$baccount['payment_service'] = $pay_service;
$salesman = get_imc_code($branch['branch_code']);
$pay_term = get_payment_terms($myrow['payment_terms']);
$branch_data = get_branch_accounts($myrow['branch_code']);
$dt = get_discount($branch_data['sales_discount_account'], $myrow['type'], $myrow['trans_no']);
$invoice_no = get_custom_no($myrow['trans_no'], $myrow['type']);
$contact = getContactPerson($myrow['salesman'], $myrow['debtor_no'], $branch['branch_code']);
$rep->NewPage();
$result = get_customer_trans_details(ST_SALESINVOICE, $i);
$SubTotal = 0;
$rep->NewLine(8);
$rep->TextCol(2, 7, _("CHARGE INVOICE # " . $invoice_no));
$rep->TextCol(8, 9, $myrow['TranDate']);
$rep->NewLine();
$rep->TextCol(2, 7, $branch['br_name']);
if ($dt != 0) {
//$display_bulk_discount = (($sub_total - $myrow['Total']) / $sub_total) * 100;
$tot = $myrow['Total'] + $dt;
$dscnt = ($tot - $myrow['Total']) / $tot * 100;
//$dscnt = ($dt / $myrow['Total']) * 100;
$significant = strlen(substr(strrchr($dscnt, "."), 1));
if ($significant > 2) {
$rep->TextCol(7, 9, floor($dscnt) . "%");
} else {
$rep->TextCol(7, 9, $dscnt . "%");
}
}
$rep->NewLine();
$rep->TextCol(2, 7, $branch['branch_ref']);
$rep->TextCol(8, 9, $salesman);
$rep->NewLine();
$rep->TextCol(2, 6, $contact);
if ($pay_term['terms'] == 'Cash Only') {
$rep->TextCol(8, 9, $pay_term['terms']);
} else {
$rep->TextCol(7, 10, $pay_term['terms']);
}
$rep->NewLine();
$oldrow = $rep->row;
$newrow = $rep->row;
$rep->TextColLines(2, 6, $branch['br_address'], -2);
$rep->row = $oldrow;
$rep->NewLine(5);
$rep->Font('bold');
//.........这里部分代码省略.........
开发者ID:knjy24, 项目名称:FrontAccounting, 代码行数:101, 代码来源:rep107_old.php
示例4: page
<?php
$page_security = 1;
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
page(tr("View Customer Payment"), true);
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/sales/includes/sales_db.inc";
if (isset($_GET["trans_no"])) {
$trans_id = $_GET["trans_no"];
}
$receipt = get_customer_trans($trans_id, systypes::cust_payment());
display_heading(sprintf(tr("Customer Payment #%d"), $trans_id));
echo "<br>";
start_table("{$table_style} width=80%");
start_row();
label_cells(tr("From Customer"), $receipt['DebtorName'], "class='tableheader2'");
label_cells(tr("Into Bank Account"), $receipt['bank_account_name'], "class='tableheader2'");
label_cells(tr("Date of Deposit"), sql2date($receipt['tran_date']), "class='tableheader2'");
end_row();
start_row();
label_cells(tr("Payment Currency"), $receipt['curr_code'], "class='tableheader2'");
label_cells(tr("Amount"), price_format($receipt['ov_amount']), "class='tableheader2'");
label_cells(tr("Discount"), price_format($receipt['ov_discount']), "class='tableheader2'");
end_row();
start_row();
label_cells(tr("Payment Type"), $receipt['BankTransType'], "class='tableheader2'");
label_cells(tr("Reference"), $receipt['reference'], "class='tableheader2'", "colspan=4");
end_row();
comments_display_row(systypes::cust_payment(), $trans_id);
开发者ID:ravenii, 项目名称:guardocs, 代码行数:31, 代码来源:view_receipt.php
示例5: set_delivery_shipping_sum
function set_delivery_shipping_sum($delivery_notes)
{
$shipping = 0;
foreach ($delivery_notes as $delivery_num) {
$myrow = get_customer_trans($delivery_num, 13);
//$branch = get_branch($myrow["branch_code"]);
//$sales_order = get_sales_order_header($myrow["order_"]);
//$shipping += $sales_order['freight_cost'];
$shipping += $myrow['ov_freight'];
}
$_POST['ChargeFreightCost'] = price_format($shipping);
}
开发者ID:blestab, 项目名称:frontaccounting, 代码行数:12, 代码来源:customer_invoice.php
示例6: get_js_open_window
***********************************************************************/
$page_security = 'SA_SALESTRANSVIEW';
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/sales/includes/sales_db.inc";
$js = "";
if ($use_popup_windows) {
$js .= get_js_open_window(900, 600);
}
page(_($help_context = "View Customer Payment"), true, false, "", $js);
if (isset($_GET["trans_no"])) {
$trans_id = $_GET["trans_no"];
}
$receipt = get_customer_trans($trans_id, ST_CUSTPAYMENT);
display_heading(sprintf(_("Customer Payment #%d"), $trans_id));
echo "<br>";
start_table(TABLESTYLE, "width=80%");
start_row();
label_cells(_("From Customer"), $receipt['DebtorName'], "class='tableheader2'");
label_cells(_("Reference"), $receipt['reference'], "class='tableheader2'");
label_cells(_("Date of Deposit"), sql2date($receipt['tran_date']), "class='tableheader2'");
end_row();
start_row();
label_cells(_("Customer Currency"), $receipt['curr_code'], "class='tableheader2'");
label_cells(_("Amount"), price_format($receipt['Total'] - $receipt['ov_discount']), "class='tableheader2'");
label_cells(_("Discount"), price_format($receipt['ov_discount']), "class='tableheader2'");
end_row();
start_row();
label_cells(_("Into Bank Account"), $receipt['bank_account_name'] . ' [' . $receipt['bank_curr_code'] . ']', "class='tableheader2'");
开发者ID:nativebandung, 项目名称:frontaccounting, 代码行数:31, 代码来源:view_receipt.php
示例7: print_credits
function print_credits()
{
global $path_to_root, $alternative_tax_include_on_docs, $suppress_tax_rates;
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$currency = $_POST['PARAM_2'];
$email = $_POST['PARAM_3'];
$paylink = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$orientation = $_POST['PARAM_6'];
if (!$from || !$to) {
return;
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$fno = explode("-", $from);
$tno = explode("-", $to);
$from = min($fno[0], $tno[0]);
$to = max($fno[0], $tno[0]);
$cols = array(0, 10, 50, 100, 150, 200, 250, 300, 350, 380, 450, 480, 550, 600);
// $headers in doctext.inc
$aligns = array('center', 'left', 'left', 'left', 'left', 'left', 'left', 'left', 'right', 'right', 'right', 'right');
$params = array('comments' => $comments);
$cur = get_company_Pref('curr_default');
if ($email == 0) {
$rep = new FrontReport(_('CREDIT NOTE'), "InvoiceBulk", user_pagesize(), 9, $orientation);
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
for ($i = $from; $i <= $to; $i++) {
if (!exists_customer_trans(ST_CUSTCREDIT, $i)) {
continue;
}
$sign = -1;
$myrow = get_customer_trans($i, ST_CUSTCREDIT);
$baccount = get_default_bank_account($myrow['curr_code']);
$params['bankaccount'] = $baccount['id'];
$branch = get_branch($myrow["branch_code"]);
$branch['disable_branch'] = $paylink;
// helper
$sales_order = null;
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);
$rep->title = _('CREDIT NOTE');
$rep->filename = "CreditNote" . $myrow['reference'] . ".pdf";
}
$rep->SetHeaderType(0);
$rep->currency = $cur;
$rep->Font();
$rep->Info(null, $cols, null, $aligns);
//$contacts = get_branch_contacts($branch['branch_code'], 'invoice', $branch['debtor_no'], true);
//$rep->SetCommonData($myrow, $branch, $sales_order, $baccount, ST_CUSTCREDIT, $contacts);
$rep->NewPage();
$result = get_customer_trans_details(ST_CUSTCREDIT, $i);
$SubTotal = 0;
//$data = get_custom_no($from, ST_CUSTCREDIT);
$invoice_no = get_sales_invoice_no($myrow['order_'], ST_SALESINVOICE);
$imc = get_imc_name($branch['branch_code']);
$rep->NewLine(8);
$rep->TextCol(8, 10, "Date : " . $myrow['TranDate']);
$rep->NewLine(2);
$oldrow = $rep->row;
$rep->TextColLines(3, 12, "Client : " . $branch['br_name'], -2);
$newrow = $rep->row;
$rep->row = $oldrow;
$rep->NewLine(2);
$rep->TextCol(3, 5, "Invoice # : " . $invoice_no, -2);
$rep->TextCol(8, 10, "IMC: " . $imc, -2);
$rep->NewLine(2);
$rep->TextCol(3, 4, _("QTY"));
$rep->TextCol(5, 7, _("DESCRIPTION"));
$rep->TextCol(8, 9, _("PRICE"));
$rep->TextCol(9, 10, _("AMOUNT"));
$rep->NewLine(2);
while ($myrow2 = db_fetch($result)) {
if ($myrow2["quantity"] == 0) {
continue;
}
$Net = round2($sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec());
$SubTotal += $Net;
$DisplayPrice = number_format2($myrow2["unit_price"], $dec);
$DisplayQty = number_format2($sign * $myrow2["quantity"], get_qty_dec($myrow2['stock_id']));
$DisplayNet = number_format2($Net, $dec);
if ($myrow2["discount_percent"] == 0) {
$DisplayDiscount = "";
} else {
$DisplayDiscount = number_format2($myrow2["discount_percent"] * 100, user_percent_dec()) . "%";
}
//$rep->TextCol(4, 5, $myrow2['stock_id'], -2);
$oldrow = $rep->row;
$rep->TextColLines(4, 8, $myrow2['StockDescription'], -2);
$newrow = $rep->row;
$rep->row = $oldrow;
$rep->TextCol(3, 4, $DisplayQty . " " . $myrow2['units'], -2);
$rep->TextCol(8, 9, $DisplayPrice, -2);
$rep->TextCol(9, 10, $DisplayNet, -2);
$rep->row = $newrow;
//$rep->NewLine(1);
//.........这里部分代码省略.........
开发者ID:knjy24, 项目名称:FrontAccounting, 代码行数:101, 代码来源:rep116.php
示例8: create_cart
function create_cart($type, $trans_no)
{
global $Refs;
if (isset($_SESSION['pay_items'])) {
unset($_SESSION['pay_items']);
}
$cart = new items_cart($type);
$cart->order_id = $trans_no;
if ($trans_no) {
$bank_trans = db_fetch(get_bank_trans($type, $trans_no));
$_POST['bank_account'] = $bank_trans["bank_act"];
$_POST['PayType'] = $bank_trans["person_type_id"];
if ($bank_trans["person_type_id"] == PT_CUSTOMER) {
$trans = get_customer_trans($trans_no, $type);
$_POST['person_id'] = $trans["debtor_no"];
$_POST['PersonDetailID'] = $trans["branch_code"];
} elseif ($bank_trans["person_type_id"] == PT_SUPPLIER) {
$trans = get_supp_trans($trans_no, $type);
$_POST['person_id'] = $trans["supplier_id"];
} elseif ($bank_trans["person_type_id"] == PT_MISC) {
$_POST['person_id'] = $bank_trans["person_id"];
} elseif ($bank_trans["person_type_id"] == PT_QUICKENTRY) {
$_POST['person_id'] = $bank_trans["person_id"];
} else {
$_POST['person_id'] = $bank_trans["person_id"];
}
$cart->memo_ = get_comments_string($type, $trans_no);
$cart->tran_date = sql2date($bank_trans['trans_date']);
$cart->reference = $Refs->get($type, $trans_no);
$cart->original_amount = $bank_trans['amount'];
$result = get_gl_trans($type, $trans_no);
if ($result) {
while ($row = db_fetch($result)) {
if (is_bank_account($row['account'])) {
// date exchange rate is currenly not stored in bank transaction,
// so we have to restore it from original gl amounts
$ex_rate = $bank_trans['amount'] / $row['amount'];
} else {
$date = $row['tran_date'];
$cart->add_gl_item($row['account'], $row['dimension_id'], $row['dimension2_id'], $row['amount'], $row['memo_']);
}
}
}
// apply exchange rate
foreach ($cart->gl_items as $line_no => $line) {
$cart->gl_items[$line_no]->amount *= $ex_rate;
}
} else {
$cart->reference = $Refs->get_next($cart->trans_type);
$cart->tran_date = new_doc_date();
if (!is_date_in_fiscalyear($cart->tran_date)) {
$cart->tran_date = end_fiscalyear();
}
}
$_POST['memo_'] = $cart->memo_;
$_POST['ref'] = $cart->reference;
$_POST['date_'] = $cart->tran_date;
$_SESSION['pay_items'] =& $cart;
}
开发者ID:nativebandung, 项目名称:frontaccounting, 代码行数:59, 代码来源:gl_bank.php
示例9: get_js_open_window
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/sales/includes/sales_db.inc";
$js = "";
if ($use_popup_windows) {
$js .= get_js_open_window(900, 500);
}
page(_($help_context = "View Credit Note"), true, false, "", $js);
if (isset($_GET["trans_no"])) {
$trans_id = $_GET["trans_no"];
} elseif (isset($_POST["trans_no"])) {
$trans_id = $_POST["trans_no"];
}
$myrow = get_customer_trans($trans_id, ST_CUSTCREDIT);
$branch = get_branch($myrow["branch_code"]);
display_heading("<font color=red>" . sprintf(_("CREDIT NOTE #%d"), $trans_id) . "</font>");
echo "<br>";
start_table(TABLESTYLE2, "width='95%'");
echo "<tr valign=top><td>";
// outer table
/*Now the customer charged to details in a sub table*/
start_table(TABLESTYLE, "width='100%'");
$th = array(_("Customer"));
table_header($th);
label_row(null, $myrow["DebtorName"] . "<br>" . nl2br($myrow["address"]), "nowrap");
end_table();
/*end of the small table showing charge to account details */
echo "</td><td>";
// outer table
开发者ID:M-Shahbaz, 项目名称:FA, 代码行数:31, 代码来源:view_credit.php
示例10: get_js_open_window
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/sales/includes/sales_ui.inc";
include_once $path_to_root . "/sales/includes/sales_db.inc";
$js = "";
if ($use_popup_windows) {
$js .= get_js_open_window(900, 600);
}
page(_($help_context = "View Sales Dispatch"), true, false, "", $js);
if (isset($_GET["trans_no"])) {
$trans_id = $_GET["trans_no"];
} elseif (isset($_POST["trans_no"])) {
$trans_id = $_POST["trans_no"];
}
// 3 different queries to get the information - what a JOKE !!!!
$myrow = get_customer_trans($trans_id, ST_CUSTDELIVERY);
$branch = get_branch($myrow["branch_code"]);
$sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER);
display_heading(sprintf(_("DISPATCH NOTE #%d"), $trans_id));
echo "<br>";
start_table(TABLESTYLE2, "width='95%'");
echo "<tr valign=top><td>";
// outer table
/*Now the customer charged to details in a sub table*/
start_table(TABLESTYLE, "width='100%'");
$th = array(_("Charge To"));
table_header($th);
label_row(null, $myrow["DebtorName"] . "<br>" . nl2br($myrow["address"]), "nowrap");
end_table();
/*end of the small table showing charge to account details */
echo "</td><td>";
开发者ID:rolfity, 项目名称:FA, 代码行数:31, 代码来源:view_dispatch.php
示例11: get_js_open_window
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/sales/includes/sales_db.inc";
$js = "";
if ($use_popup_windows) {
$js .= get_js_open_window(900, 500);
}
page(tr("View Credit Note"), true, false, "", $js);
if (isset($_GET["trans_no"])) {
$trans_id = $_GET["trans_no"];
} elseif (isset($_POST["trans_no"])) {
$trans_id = $_POST["trans_no"];
}
$myrow = get_customer_trans($trans_id, 11);
$branch = get_branch($myrow["branch_code"]);
display_heading("<font color=red>" . sprintf(tr("CREDIT NOTE #%d"), $trans_id) . "</font>");
echo "<br>";
start_table("{$table_style2} width=95%");
echo "<tr valign=top><td>";
// outer table
/*Now the customer charged to details in a sub table*/
start_table("{$table_style} width=100%");
$th = array(tr("Customer"));
table_header($th);
label_row(null, $myrow["DebtorName"] . "<br>" . nl2br($myrow["address"]), "nowrap");
end_table();
/*end of the small table showing charge to account details */
echo "</td><td>";
// outer table
开发者ID:ravenii, 项目名称:guardocs, 代码行数:31, 代码来源:view_credit.php
示例12: print_invoices
function print_invoices()
{
global $path_to_root, $alternative_tax_include_on_docs, $suppress_tax_rates, $no_zero_lines_amount;
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$currency = $_POST['PARAM_2'];
$email = $_POST['PARAM_3'];
$pay_service = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$customer = $_POST['PARAM_6'];
$orientation = $_POST['PARAM_7'];
if (!$from || !$to) {
return;
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$fno = explode("-", $from);
$tno = explode("-", $to);
$from = min($fno[0], $tno[0]);
$to = max($fno[0], $tno[0]);
$cols = array(-15, 10, 30, 50, 80, 240, 300, 340, 360, 400);
// $headers in doctext.inc
$aligns = array('right', 'left', 'left', 'left', 'left', 'left', 'right', 'right', 'right', 'right');
$params = array('comments' => $comments);
$cur = get_company_Pref('curr_default');
if ($email == 0) {
$rep = new FrontReport(_('INVOICE'), "InvoiceBulk", user_pagesize(), 9, $orientation);
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
for ($i = $from; $i <= $to; $i++) {
if (!exists_customer_trans(ST_SALESINVOICE, $i)) {
continue;
}
$sign = 1;
$myrow = get_customer_trans($i, ST_SALESINVOICE);
if ($customer && $myrow['debtor_no'] != $customer) {
continue;
}
$baccount = get_default_bank_account($myrow['curr_code']);
$params['bankaccount'] = $baccount['id'];
$branch = get_branch($myrow["branch_code"]);
$salesm = get_salesman_name($branch['salesman']);
$sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER);
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);
$rep->title = _('INVOICE');
$rep->filename = "Invoice" . $myrow['reference'] . ".pdf";
}
$rep->SetHeaderType(0);
$rep->currency = $cur;
$rep->Font();
$rep->Info(null, $cols, null, $aligns);
$contacts = get_branch_contacts($branch['branch_code'], 'invoice', $branch['debtor_no'], true);
$baccount['payment_service'] = $pay_service;
$rep->SetCommonData($myrow, $branch, $sales_order, $baccount, ST_SALESINVOICE, $contacts);
$rep->NewPage();
$result = get_customer_trans_details(ST_SALESINVOICE, $i);
$SubTotal = 0;
$invoice_no = get_custom_no($myrow['trans_no'], ST_SALESINVOICE);
$rep->NewLine(5);
$rep->TextCol(2, 5, $branch['br_name']);
$rep->TextCol(7, 9, $myrow['TranDate']);
$rep->NewLine();
$rep->TextCol(2, 10, $branch['br_address']);
$rep->TextCol(7, 9, "SI - " . $invoice_no);
$rep->NewLine();
$rep->TextCol(0, 2, "Contact: ");
$rep->TextCol(2, 5, $contacts["name"] . $contacts["name2"]);
$rep->TextCol(6, 9, "IMC: " . $salesm);
$rep->NewLine();
$rep->TextCol(2, 5, "");
$rep->NewLine();
$rep->TextCol(2, 5, "");
$rep->NewLine(3);
//$rep->NewLine(2);
$ent = 0;
while ($myrow2 = db_fetch($result)) {
if ($myrow2["quantity"] == 0) {
continue;
}
$Net = round2($sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec());
$SubTotal += $Net;
$DisplayPrice = number_format2($myrow2["unit_price"], 2);
$DisplayQty = number_format2($sign * $myrow2["quantity"], get_qty_dec($myrow2['stock_id']));
$DisplayNet = number_format2($Net, 2);
if ($myrow2["discount_percent"] == 0) {
$DisplayDiscount = "";
} else {
$DisplayDiscount = number_format2($myrow2["discount_percent"] * 100, 2) . "%";
}
//$rep->TextCol(3, 4, $myrow2['stock_id'], -2);
$oldrow = $rep->row;
$rep->TextColLines(4, 6, $myrow2['StockDescription'], -2);
$newrow = $rep->row;
$rep->row = $oldrow;
$ent++;
if ($Net != 0.0 || !is_service($myrow2['mb_flag']) || !isset($no_zero_lines_amount) || $no_zero_lines_amount == 0) {
//.........这里部分代码省略.........
开发者ID:knjy24, 项目名称:FrontAccounting, 代码行数:101, 代码来源:rep1072.php
示例13: print_invoices
function print_invoices()
{
global $path_to_root, $alternative_tax_include_on_docs, $suppress_tax_rates, $no_zero_lines_amount;
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$currency = $_POST['PARAM_2'];
$email = $_POST['PARAM_3'];
$pay_service = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$customer = $_POST['PARAM_6'];
$orientation = $_POST['PARAM_7'];
if (!$from || !$to) {
return;
}
$orientation = $orientation ? 'L' : 'P';
$dec = user_price_dec();
$fno = explode("-", $from);
$tno = explode("-", $to);
$from = min($fno[0], $tno[0]);
$to = max($fno[0], $tno[0]);
$cols = array(-18, 40, 60, 100, 160, 200, 260, 360, 420, 450, 500);
// $headers in doctext.inc
$aligns = array('left', 'left', 'left', 'left', 'right', 'right', 'right', 'right', 'right', 'right', 'right');
//$params = array('comments' => $comments);
$cur = get_company_Pref('curr_default');
$company_data = get_company_prefs();
if ($email == 0) {
$rep = new FrontReport(_('INVOICE'), "InvoiceBulk", user_pagesize(), 9, $orientation);
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
for ($i = $from; $i <= $to; $i++) {
if (!exists_customer_trans(ST_SALESINVOICE, $i)) {
continue;
}
$sign = 1;
$myrow = get_customer_trans($i, ST_SALESINVOICE);
if ($customer && $myrow['debtor_no'] != $customer) {
continue;
}
$baccount = get_default_bank_account($myrow['curr_code']);
$params['bankaccount'] = $baccount['id'];
$branch = get_branch($myrow["branch_code"]);
$sales_order = get_sales_order_header($myrow["order_"], ST_SALESORDER);
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);
//$rep->title = _('INVOICE');
$rep->filename = "Invoice" . $myrow['reference'] . ".pdf";
}
$rep->SetHeaderType(0);
$rep->currency = $cur;
$rep->Font();
$rep->Info(null, $cols, null, $aligns);
$salesman = get_imc_code($branch['branch_code']);
$pay_term = get_payment_terms($myrow['payment_terms']);
$branch_data = get_branch_accounts($myrow['branch_code']);
$invoice_no = get_custom_no($myrow['trans_no'], $myrow['type']);
$contact = getContact($myrow['salesman'], $myrow['debtor_no'], $branch['branch_code']);
$cnumber = getContactNumber($myrow['salesman'], $myrow['debtor_no'], $branch['branch_code']);
$rep->NewPage();
$result = get_customer_trans_details(ST_SALESINVOICE, $i);
$SubTotal = 0;
$rep->NewLine(6);
$rep->TextCol(2, 7, $invoice_no);
$rep->TextCol(6, 8, $myrow['TranDate']);
$rep->NewLine();
$rep->TextCol(2, 7, $branch['br_name']);
$rep->TextCol(7, 8, $myrow['bulk_discount'] . "%");
$rep->NewLine();
$rep->TextCol(2, 7, $branch['branch_ref']);
$rep->TextCol(6, 8, $salesman);
$rep->NewLine();
$rep->TextCol(2, 6, $contact . " - " . $cnumber);
if ($pay_term['terms'] == 'C.O.D.' || $pay_term['Cash Only']) {
$rep->TextCol(7, 8, $pay_term['terms'], -2);
} else {
$oldrow = $rep->row;
$newrow = $rep->row;
$rep->TextColLines(7, 9, $pay_term['terms'], -2);
$newrow = $rep->row;
$rep->row = $oldrow;
}
$rep->NewLine();
$oldrow = $rep->row;
$newrow = $rep->row;
$rep->TextColLines(2, 6, $branch['br_address'], -2);
$rep->row = $oldrow;
$rep->NewLine(4);
$rep->Font();
while ($myrow2 = db_fetch($result)) {
if ($myrow2["quantity"] == 0) {
continue;
}
$Net = round2($sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec());
$Net2 = round2($sign * ($myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec());
$SubTotal += $Net;
$DisplayPrice = number_format2($myrow2["unit_price"], 2);
$DisplayQty = number_format2($sign * $myrow2["quantity"], get_qty_dec($myrow2['stock_id']));
//.........这里部分代码省略.........
开发者ID:knjy24, 项目名称:FrontAccounting, 代码行数:101, 代码来源:rep107.php
示例14: print_credits
function print_credits()
{
global $path_to_root, $alternative_tax_include_on_docs, $suppress_tax_rates;
include_once $path_to_root . "/reporting/includes/pdf_report.inc";
$from = $_POST['PARAM_0'];
$to = $_POST['PARAM_1'];
$currency = $_POST['PARAM_2'];
$email = $_POST['PARAM_3'];
$paylink = $_POST['PARAM_4'];
$comments = $_POST['PARAM_5'];
$orientation = $_POST['PARAM_6'];
if (!$from || !$to) {
return;
}
$orientation = $orientation ? 'L' : 'P';
$dec = 2;
$fno = explode("-", $from);
$tno = explode("-", $to);
$from = min($fno[0], $tno[0]);
$to = max($fno[0], $tno[0]);
$cols = array(-20, 15, 20, 100, 130, 200, 255, 285, 335, 385, 440, 480, 550, 600);
// $headers in doctext.inc
$aligns = array('left', 'left', 'left', 'left', 'left', 'left', 'left', 'right', 'right', 'right', 'right', 'right');
$params = array('comments' => $comments);
$cur = get_company_Pref('curr_default');
if ($email == 0) {
$rep = new FrontReport(_('CREDIT NOTE'), "InvoiceBulk", user_pagesize(), 9, $orientation);
}
if ($orientation == 'L') {
recalculate_cols($cols);
}
for ($i = $from; $i <= $to; $i++) {
if (!exists_customer_trans(ST_CUSTCREDIT, $i)) {
continue;
}
$sign = -1;
$myrow = get_customer_trans($i, ST_CUSTCREDIT);
$baccount = get_default_bank_account($myrow['curr_code']);
$params['bankaccount'] = $baccount['id'];
$branch = get_branch($myrow["branch_code"]);
$branch['disable_branch'] = $paylink;
// helper
$sales_order = null;
if ($email == 1) {
$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);
$rep->title = _('CREDIT NOTE');
$rep->filename = "CreditNote" . $myrow['reference'] . ".pdf";
}
$rep->SetHeaderType(0);
$rep->currency = $cur;
$rep->Font();
$rep->Info(null, $cols, null, $aligns);
//$contacts = get_branch_contacts($branch['branch_code'], 'invoice', $branch['debtor_no'], true);
//$rep->SetCommonData($myrow, $branch, $sales_order, $baccount, ST_CUSTCREDIT, $contacts);
$rep->NewPage();
$result = get_customer_trans_details(ST_CUSTCREDIT, $i);
$SubTotal = 0;
//$data = get_custom_no($from, ST_CUSTCREDIT);
$invoice_no = get_sales_invoice_no($myrow['order_'], ST_SALESINVOICE);
$credit_no = get_custom_no($myrow['trans_no'], ST_CUSTCREDIT);
$imc = get_imc_name($branch['branch_code']);
$rep->NewLine(9);
$rep->TextCol(6, 8, $myrow['TranDate']);
$rep->NewLine(1);
$oldrow = $rep->row;
$rep->TextColLines(0, 12, $branch['br_name'], -2);
$newrow = $rep->row;
$rep->row = $oldrow;
$rep->NewLine(3);
$rep->TextCol(0, 3, "Ref. Invoice # " . $invoice_no, -2);
$rep->TextCol(3, 5, "Credit#" . $credit_no, -2);
$rep->TextCol(5, 8, $imc, -2);
$rep->NewLine(2);
$rep->NewLine(2);
while ($myrow2 = db_fetch($result)) {
if ($myrow2["quantity"] == 0) {
continue;
}
$Net = round2($sign * ((1 - $myrow2["discount_percent"]) * $myrow2["unit_price"] * $myrow2["quantity"]), user_price_dec());
$SubTotal += $Net;
$DisplayPrice = number_format2($myrow2["unit_price"], $dec);
$DisplayQty = number_format2($sign * $myrow2["quantity"], get_qty_dec($myrow2['stock_id']));
$DisplayNet = number_format2($Net, $dec);
if ($myrow2["discount_percent"] == 0) {
$DisplayDiscount = "";
} else {
$DisplayDiscount = number_format2($myrow2["discount_percent"] * 100, user_percent_dec()) . "%";
}
//$rep->TextCol(4, 5, $myrow2['stock_id'], -2);
$oldrow = $rep->row;
$rep->TextColLines(2, 5, $myrow2['StockDescription'], -2);
$newrow = $rep->row;
$rep->row = $oldrow;
$rep->TextCol(0, 1, $DisplayQty . " " . $myrow2['units'], -2);
$rep->TextCol(6, 7, $DisplayPrice, -2);
$rep->TextCol(7, 8, $DisplayNet, -2);
$rep->row = $newrow;
//$rep->NewLine(1);
if ($rep->row < $rep->bottomMargin + 15 * $rep->lineHeight) {
$rep->NewPage();
//.........这里部分代码省略.........
开发者ID:knjy24, 项目名称:FrontAccounting, 代码行数:101, 代码来源:rep113.php
示例15: get_customer_trans
$_POST['HoldAccount'] = $myrow["dissallow_invoices"];
$_POST['pymt_discount'] = $myrow["pymt_discount"];
//Chaitanya : 13-OCT-2011 - To support Edit feature
//If page is called first time and New entry fetch the nex reference number
if (!$_SESSION['alloc']->trans_no && !isset($_POST['charge'])) {
$_POST['ref'] = $Refs->get_next(ST_CUSTPAYMENT);
}
}
//----------------------------------------------------------------------------------------------
$new = 1;
$old_ref = 0;
//Chaitanya : 13-OCT-2011 - To support Edit feature
if (isset($_GET['trans_no']) && $_GET['trans_no'] > 0) {
$_POST['trans_no'] = $_GET['trans_no'];
$new = 0;
$myrow = get_customer_trans($_POST['trans_no'], ST_CUSTPAYMENT);
$_POST['customer_id'] = $myrow["debtor_no"];
$_POST['customer_name'] = $myrow["DebtorName"];
$_POST['BranchID'] = $myrow["branch_code"];
$_POST['bank_account'] = $myrow["bank_act"];
$_POST['ref'] = $myrow["reference"];
$old_ref = $myrow["reference"];
//$_POST['charge'] = $myrow[""];
$_POST['DateBanked'] = sql2date($myrow['tran_date']);
$_POST["amount"] = price_format($myrow['Total'] - $myrow['ov_discount']);
$_POST["discount"] = price_format($myrow['ov_discount']);
$_POST["memo_"] = get_comments_string(ST_CUSTPAYMENT, $_POST['trans_no']);
if (!isset($_POST['charge'])) {
//Prepare allocation cart
if (isset($_POST['trans_no']) && $_POST['trans_no'] > 0) {
$_SESSION['alloc'] = new allocation(ST_CUSTPAYMENT, $_POST['trans_no']);
开发者ID:pthdnq, 项目名称:ivalley-svn, 代码行数:31, 代码来源:customer_payments.php
示例16: create_cart
function create_cart($type = 0, $trans_no = 0)
{
global $Refs;
if (isset($_SESSION['disbursement_items'])) {
unset($_SESSION['disbursement_items']);
}
$cart = new items_cart($type);
$cart->order_id = $trans_no;
if ($trans_no) {
$result = get_gl_trans($type, $trans_no);
$_POST['PayType'] = $res["person_type_id"];
if ($res["person_type_id"] == PT_CUSTOMER) {
$trans = get_customer_trans($trans_no, $type);
$_POST['person_id'] = $trans["debtor_no"];
$_POST['PersonDetailID'] = $trans["branch_code"];
} elseif ($res["person_type_id"] == PT_SUPPLIER) {
$trans = get_supp_trans($trans_no, $type);
$_POST['person_id'] = $trans["supplier_id"];
} elseif ($res["person_type_id"] == PT_MISC) {
$_POST['person_id'] = $res["person_id"];
} elseif ($res["person_type_id"] == PT_QUICKENTRY) {
$_POST['person_id'] = $res["person_id"];
} else {
$_POST['person_id'] = $res["person_id"];
}
if ($result) {
while ($row = db_fetch($result)) {
if ($row['amount'] == 0) {
continue;
}
$date = $row['tran_date'];
$cart->add_gl_item($row['account'], $row['dimension_id'], $row['dimension2_id'], $row['amount'], $row['memo_']);
}
}
$cart->memo_ = get_comments_string($type, $trans_no);
$cart->tran_date = sql2date($date);
if ($type == ST_DISBURSEMENT) {
$voucher_type = 'Check Voucher';
$cart->reference = $Refs->get(ST_DISBURSEMENT, $trans_no);
}
if ($type == ST_SUPPAYMENT) {
$cart->reference = $Refs->get_next(ST_DISBURSEMENT);
}
$_POST['ref_original'] = $cart->reference;
// Store for comparison when updating
} else {
$cart->reference = $Refs->get_next(ST_DISBURSEMENT);
$cart->tran_date = new_doc_date();
if (!is_date_in_fiscalyear($cart->tran_date)) {
$cart->tran_date = end_fiscalyear();
}
$_POST['ref_original'] = -1;
}
$_POST['memo_'] = $cart->memo_;
$_POST['ref'] = $cart->reference;
$_POST['date_'] = $cart->tran_date;
$_POST['cv_no'] = $cart->custom_no;
/**========MOODLEARNING=======*/
$_POST['address'] = $cart->address;
$_POST['check_num'] = $cart->check_num;
$_POST['PayType'] = $cart->person_id;
$_POST['person_id'] = $cart->person_detail_id;
$_POST['settled_amount'] = $cart->settled_amount;
$_SESSION['disbursement_items'] =& $cart;
}
开发者ID:knjy24, 项目名称:FrontAccounting, 代码行数:65, 代码来源:cash_disbursement.php
bradtraversy/iweather: Ionic 3 mobile weather app
阅读:1559| 2022-08-30
joaomh/curso-de-matlab
阅读:1135| 2022-08-17
魔兽世界怀旧服已经开启两个多月了,但作为一个猎人玩家,抓到“断牙”,已经成为了一
阅读:990| 2022-11-06
openshift/library-go: Helpers for going from apis and clients to useful runtime
阅读:552| 2022-08-15
rugk/mastodon-simplified-federation: Simplifies following and interacting with r
阅读:1064| 2022-08-17
Tangshitao/Dense-Scene-Matching: Learning Camera Localization via Dense Scene Ma
阅读:745| 2022-08-16
Online Fire Reporting System 1.0 is vulnerable to SQL Injection via the date par
阅读:1055| 2022-07-29
相信不少果粉在对自己的设备进行某些操作时,都会碰到Respring,但这个 Respring 到底
阅读:356| 2022-11-06
tortuvshin/ecommerce: Laravel open source e-commerce system.
阅读:814| 2022-08-13
lightningtgc/MProgress.js: Material Progress —Google Material Design Progress l
阅读:393| 2022-08-17
请发表评论