X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fcustomer_allocation_inquiry.php;h=5630f04d20facd74821acb5918f19a9266f9c6ff;hb=9481e23e6d03f39f7d9e745f86bd1be5f703b96d;hp=07aad1e3d7b04eb02bf8fe13d9b83f12bf93a9a1;hpb=431531eebf3ba494002cfbf7ea36f9e82d4975c0;p=fa-stable.git diff --git a/sales/inquiry/customer_allocation_inquiry.php b/sales/inquiry/customer_allocation_inquiry.php index 07aad1e3..5630f04d 100644 --- a/sales/inquiry/customer_allocation_inquiry.php +++ b/sales/inquiry/customer_allocation_inquiry.php @@ -1,18 +1,28 @@ . +***********************************************************************/ +$page_security = 'SA_SALESALLOC'; +$path_to_root = "../.."; +include($path_to_root . "/includes/db_pager.inc"); 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) +if ($SysPrefs->use_popup_windows) $js .= get_js_open_window(900, 500); -if ($use_date_picker) +if (user_use_date_picker()) $js .= get_js_date_picker(); -page(_("Customer Allocation Inquiry"), false, false, "", $js); +page(_($help_context = "Customer Allocation Inquiry"), false, false, "", $js); if (isset($_GET['customer_id'])) { @@ -24,190 +34,141 @@ if (isset($_GET['customer_id'])) if (!isset($_POST['customer_id'])) $_POST['customer_id'] = get_global_customer(); -start_form(false, true); +start_form(); -start_table("class='tablestyle_noborder'"); +start_table(TABLESTYLE_NOBORDER); start_row(); customer_list_cells(_("Select a customer: "), 'customer_id', $_POST['customer_id'], true); -date_cells(_("from:"), 'TransAfterDate', null, -30); -date_cells(_("to:"), 'TransToDate', null, 1); +date_cells(_("from:"), 'TransAfterDate', '', null, -user_transaction_days()); +date_cells(_("to:"), 'TransToDate', '', null, 1); cust_allocations_list_cells(_("Type:"), 'filterType', null); check_cells(" " . _("show settled:"), 'showSettled', null); -submit_cells('Refresh Inquiry', _("Search")); +submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), 'default'); set_global_customer($_POST['customer_id']); end_row(); end_table(); -end_form(); - //------------------------------------------------------------------------------------------------ - -function get_transactions() +function check_overdue($row) { - $data_after = date2sql($_POST['TransAfterDate']); - $date_to = date2sql($_POST['TransToDate']); - - $sql = "SELECT ".TB_PREF."debtor_trans.*, - ".TB_PREF."debtors_master.name AS CustName, ".TB_PREF."debtors_master.curr_code AS CustCurrCode, - (".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_discount) - AS TotalAmount, - ".TB_PREF."debtor_trans.alloc AS Allocated, - ((".TB_PREF."debtor_trans.type = 10) - AND ".TB_PREF."debtor_trans.due_date < '" . date2sql(Today()) . "') AS OverDue - FROM ".TB_PREF."debtor_trans, ".TB_PREF."debtors_master - WHERE ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."debtor_trans.debtor_no - AND (".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_discount != 0) - AND ".TB_PREF."debtor_trans.tran_date >= '$data_after' - AND ".TB_PREF."debtor_trans.tran_date <= '$date_to'"; - - if ($_POST['customer_id'] != reserved_words::get_all()) - $sql .= " AND ".TB_PREF."debtor_trans.debtor_no = '" . $_POST['customer_id'] . "'"; - - if (isset($_POST['filterType']) && $_POST['filterType'] != reserved_words::get_all()) - { - if ($_POST['filterType'] == '1' || $_POST['filterType'] == '2') - { - $sql .= " AND ".TB_PREF."debtor_trans.type = 10 "; - } - elseif ($_POST['filterType'] == '3') - { - $sql .= " AND ".TB_PREF."debtor_trans.type = " . systypes::cust_payment(); - } - elseif ($_POST['filterType'] == '4') - { - $sql .= " AND ".TB_PREF."debtor_trans.type = 11 "; - } - - if ($_POST['filterType'] == '2') - { - $today = date2sql(Today()); - $sql .= " AND ".TB_PREF."debtor_trans.due_date < '$today' - AND (round(abs(".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_discount) - ".TB_PREF."debtor_trans.alloc,6) > 0) "; - } - } - - if (!check_value('showSettled')) - { - $sql .= " AND (round(abs(".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + ".TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_discount) - ".TB_PREF."debtor_trans.alloc,6) != 0) "; - } - - $sql .= " ORDER BY ".TB_PREF."debtor_trans.tran_date"; - - return db_query($sql,"No transactions were returned"); + return ($row['OverDue'] == 1 + && (abs($row["TotalAmount"]) - $row["Allocated"] != 0)); } -//------------------------------------------------------------------------------------------------ - -$result = get_transactions(); - -if (db_num_rows($result) == 0) +function order_link($row) { - display_note(_("The selected customer has no transactions for the given dates."), 1, 1); - end_page(); - exit; + return $row['order_']>0 ? + get_customer_trans_view_str(ST_SALESORDER, $row['order_']) + : ""; } -//------------------------------------------------------------------------------------------------ - -start_table("$table_style width='80%'"); - -if ($_POST['customer_id'] == reserved_words::get_all()) - $th = array(_("Type"), _("Number"), _("Reference"), _("Order"), _("Date"), _("Due Date"), - _("Customer"), _("Currency"), _("Debit"), _("Credit"), _("Allocated"), _("Balance"), ""); -else - $th = array(_("Type"), _("Number"), _("Reference"), _("Order"), _("Date"), _("Due Date"), - _("Debit"), _("Credit"), _("Allocated"), _("Balance"), ""); - -table_header($th); - - -$j = 1; -$k = 0; //row colour counter -$over_due = false; -while ($myrow = db_fetch($result)) +function systype_name($dummy, $type) { + global $systypes_array; - if ($myrow['OverDue'] == 1 && (abs($myrow["TotalAmount"]) - $myrow["Allocated"] != 0)) - { - start_row("class='overduebg'"); - $over_due = true; - } - else - alt_table_row_color($k); - - $date = sql2date($myrow["tran_date"]); + return $systypes_array[$type]; +} - if ($myrow["order_"] > 0) - $preview_order_str = get_customer_trans_view_str(systypes::sales_order(), $myrow["order_"]); - else - $preview_order_str = ""; +function view_link($trans) +{ + return get_trans_view_str($trans["type"], $trans["trans_no"]); +} - $allocations_str = ""; +function due_date($row) +{ + return $row["type"] == ST_SALESINVOICE ? $row["due_date"] : ''; +} - $allocations = "" . _("Allocation") . ""; +function fmt_balance($row) +{ + return ($row["type"] == ST_JOURNAL && $row["TotalAmount"] < 0 ? -$row["TotalAmount"] : $row["TotalAmount"]) - $row["Allocated"]; +} - $due_date_str = ""; +function alloc_link($row) +{ + $link = + pager_link(_("Allocation"), + "/sales/allocations/customer_allocate.php?trans_no=" . $row["trans_no"] + ."&trans_type=" . $row["type"]."&debtor_no=" . $row["debtor_no"], ICON_ALLOC); - if ($myrow["type"] == 10) - $due_date_str = sql2date($myrow["due_date"]); - elseif ($myrow["type"] == 11 && $myrow['TotalAmount'] < 0) + if ($row["type"] == ST_CUSTCREDIT && $row['TotalAmount'] > 0) { /*its a credit note which could have an allocation */ - $allocations_str = $allocations; - - } - elseif ($myrow["type"] == systypes::cust_payment() && - ($myrow['TotalAmount'] + $myrow['Allocated']) < 0) + return $link; + } elseif ($row["type"] == ST_JOURNAL && $row['TotalAmount'] < 0) + { + return $link; + } elseif (($row["type"] == ST_CUSTPAYMENT || $row["type"] == ST_BANKDEPOSIT) && + (floatcmp($row['TotalAmount'], $row['Allocated']) >= 0)) { /*its a receipt which could have an allocation*/ - $allocations_str = $allocations; - - } - elseif ($myrow["type"] == systypes::cust_payment() && $myrow['TotalAmount'] > 0) + return $link; + } + elseif ($row["type"] == ST_CUSTPAYMENT && $row['TotalAmount'] <= 0) { /*its a negative receipt */ - } + return ''; + } elseif (($row["type"] == ST_SALESINVOICE && ($row['TotalAmount'] - $row['Allocated']) > 0) || $row["type"] == ST_BANKPAYMENT) + return pager_link(_("Payment"), + "/sales/customer_payments.php?customer_id=".$row["debtor_no"]."&SInvoice=" . $row["trans_no"], ICON_MONEY); - label_cell(systypes::name($myrow["type"])); +} - label_cell(get_customer_trans_view_str($myrow["type"], $myrow["trans_no"])); - label_cell($myrow["reference"]); - label_cell($preview_order_str); - label_cell(sql2date($myrow["tran_date"]), "nowrap"); - label_cell($due_date_str, "nowrap"); - if ($_POST['customer_id'] == reserved_words::get_all()) - { - label_cell($myrow["CustName"]); - label_cell($myrow["CustCurrCode"]); - } - display_debit_or_credit_cells($myrow["TotalAmount"]); - amount_cell(abs($myrow["Allocated"])); - amount_cell(abs($myrow["TotalAmount"]) - $myrow["Allocated"]); - label_cell($allocations_str); +function fmt_debit($row) +{ + $value = + $row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT ? + -$row["TotalAmount"] : $row["TotalAmount"]; + return $value>=0 ? price_format($value) : ''; + +} +function fmt_credit($row) +{ + $value = + !($row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT) ? + -$row["TotalAmount"] : $row["TotalAmount"]; + return $value>0 ? price_format($value) : ''; +} +//------------------------------------------------------------------------------------------------ - end_row(); +$sql = get_sql_for_customer_allocation_inquiry(get_post('TransAfterDate'), get_post('TransToDate'), + get_post('customer_id'), get_post('filterType'), check_value('showSettled')); - $j++; - If ($j == 12) - { - $j = 1; - table_header($th); - } -//end of page full new headings if +//------------------------------------------------------------------------------------------------ +$cols = array( + _("Type") => array('fun'=>'systype_name'), + _("#") => array('fun'=>'view_link', 'align'=>'right'), + _("Reference"), + _("Order") => array('fun'=>'order_link', 'ord'=>'', 'align'=>'right'), + _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'asc'), + _("Due Date") => array('type'=>'date', 'fun'=>'due_date'), + _("Customer") => array('name' =>'name', 'ord'=>'asc'), + _("Currency") => array('align'=>'center'), + _("Debit") => array('align'=>'right','fun'=>'fmt_debit'), + _("Credit") => array('align'=>'right','insert'=>true, 'fun'=>'fmt_credit'), + _("Allocated") => 'amount', + _("Balance") => array('type'=>'amount', 'insert'=>true, 'fun'=>'fmt_balance'), + array('insert'=>true, 'fun'=>'alloc_link') + ); + +if ($_POST['customer_id'] != ALL_TEXT) { + $cols[_("Customer")] = 'skip'; + $cols[_("Currency")] = 'skip'; } -//end of while loop -end_table(1); -if ($over_due) - display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'"); - -end_page(); +$table =& new_db_pager('doc_tbl', $sql, $cols); +$table->set_marker('check_overdue', _("Marked items are overdue.")); + +$table->width = "80%"; + +display_db_pager($table); -?> +end_form(); +end_page();