X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fsales_orders_view.php;h=3873114bc167b3417216385d8c220791c744ddce;hb=refs%2Fremotes%2Fgithub%2Fmaster;hp=6a7186d952e2f716cdf245e877b1da17250751e9;hpb=f393f0b6e6dbd73b8371cc0ebf2d858b05592d30;p=fa-stable.git diff --git a/sales/inquiry/sales_orders_view.php b/sales/inquiry/sales_orders_view.php index 6a7186d9..3873114b 100644 --- a/sales/inquiry/sales_orders_view.php +++ b/sales/inquiry/sales_orders_view.php @@ -173,6 +173,21 @@ function tmpl_checkbox($row) . hidden('last['.$row['order_no'].']', $value, false); } +function unallocated_prepayments($row) +{ + + if ($row['ord_payments'] > 0) { + $pmts = get_payments_for($row['order_no'], $row['trans_type'], $row['debtor_no']); + + foreach($pmts as $pmt) + { + $list[] = get_trans_view_str($pmt['trans_type_from'], $pmt['trans_no_from'], get_reference($pmt['trans_type_from'], $pmt['trans_no_from'])); + } + return implode(',', $list); + } else + return ''; +} + function invoice_prep_link($row) { // invoicing should be available only for partially allocated orders @@ -217,11 +232,17 @@ start_table(TABLESTYLE_NOBORDER); start_row(); ref_cells(_("#:"), 'OrderNumber', '',null, '', true); ref_cells(_("Ref"), 'OrderReference', '',null, '', true); + +if ($show_dates) + yesno_list_cells('', 'by_delivery', null, ($trans_type==ST_SALESORDER ? _("Delivery date") : _("Valid until")).':', + ($trans_type==ST_SALESORDER ? _("Order date") : _("Quotation date")).':'); + if ($show_dates) { date_cells(_("from:"), 'OrdersAfterDate', '', null, -user_transaction_days()); date_cells(_("to:"), 'OrdersToDate', '', null, 1); } + locations_list_cells(_("Location:"), 'StockLocation', null, true, true); if($show_dates) { @@ -237,6 +258,10 @@ if (!$page_nested) customer_list_cells(_("Select a customer: "), 'customer_id', null, true, true); if ($trans_type == ST_SALESQUOTE) check_cells(_("Show All:"), 'show_all'); +if ($trans_type == ST_SALESORDER) + check_cells(_("Zero values"), 'show_voided'); +if ($show_dates && $trans_type == ST_SALESORDER) + check_cells(_("No auto"), 'no_auto'); submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default'); hidden('order_view_mode', $_POST['order_view_mode']); @@ -249,8 +274,8 @@ end_table(1); // Orders inquiry table // $sql = get_sql_for_sales_orders_view($trans_type, get_post('OrderNumber'), get_post('order_view_mode'), - get_post('SelectStockFromList'), get_post('OrdersAfterDate'), get_post('OrdersToDate'), get_post('OrderReference'), get_post('StockLocation'), - get_post('customer_id')); + get_post('SelectStockFromList'), get_post('OrdersAfterDate'), get_post('OrdersToDate'), get_post('OrderReference'), get_post('StockLocation'), get_post('customer_id'), check_value('show_voided'), + get_post('by_delivery'), get_post('no_auto')); if ($trans_type == ST_SALESORDER) $cols = array( @@ -297,7 +322,8 @@ if ($_POST['order_view_mode'] == 'OutstandingOnly') { ); } else if ($_POST['order_view_mode'] == 'PrepaidOrders') { array_append($cols, array( - array('insert'=>true, 'fun'=>'invoice_prep_link')) + _("New Payments") => array('insert'=>true, 'fun'=>'unallocated_prepayments'), + array('insert'=>true, 'fun'=>'invoice_prep_link')) ); } elseif ($trans_type == ST_SALESQUOTE) {