$selected_customer = -1;
//-----------------------------------------------------------------------------------
-/*
-$action = $_SERVER['PHP_SELF'];
-
-if ($_POST['order_view_mode']=='OutstandingOnly')
-{
- $action .= "?OutstandingOnly=" . $_POST['order_view_mode']$_PO;
-}
-elseif ($_POST['order_view_mode']=='InvoiceTemplates')
+// Ajax updates
+//
+if (get_post('SearchOrders'))
{
- $action .= "?InvoiceTemplates=" . $_POST['InvoiceTemplates'];
-}
-elseif ($_POST['order_view_mode']=='DeliveryTemplates')
+ $Ajax->activate('orders_tbl');
+} elseif (get_post('_OrderNumber_changed'))
{
- $action .= "?DeliveryTemplates=" . $_POST['InvoiceTemplates'];
+ $disable = get_post('OrderNumber') !== '';
+
+ if ($_POST['order_view_mode']!='DeliveryTemplates'
+ && $_POST['order_view_mode']!='InvoiceTemplates') {
+ $Ajax->addDisable(true, 'OrdersAfterDate', $disable);
+ $Ajax->addDisable(true, 'OrdersToDate', $disable);
+ }
+ $Ajax->addDisable(true, 'StockLocation', $disable);
+ $Ajax->addDisable(true, '_SelectStockFromList_edit', $disable);
+ $Ajax->addDisable(true, 'SelectStockFromList', $disable);
+
+ if ($disable) {
+ $Ajax->addFocus(true, 'OrderNumber');
+ } else
+ $Ajax->addFocus(true, 'OrdersAfterDate');
+
+ $Ajax->activate('orders_tbl');
}
-*/
+
start_form(false, false, $_SERVER['PHP_SELF'] .SID);
start_table("class='tablestyle_noborder'");
start_row();
-ref_cells(_("#:"), 'OrderNumber');
+ref_cells(_("#:"), 'OrderNumber', '',null, '', true);
if ($_POST['order_view_mode'] != 'DeliveryTemplates' && $_POST['order_view_mode'] != 'InvoiceTemplates')
{
date_cells(_("from:"), 'OrdersAfterDate', '', null, -30);
stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
-submit_cells('SearchOrders', _("Search"));
+submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true);
hidden('order_view_mode', $_POST['order_view_mode']);
unset($selected_stock_item);
}
-//---------------------------------------------------------------------------------------------
-if (isset($_POST['ChangeTmpl']) && $_POST['ChangeTmpl'] != 0)
+function change_tpl_flag($id)
{
- $sql = "UPDATE ".TB_PREF."sales_orders SET type = !type WHERE order_no=".$_POST['ChangeTmpl'];
+ global $Ajax;
+
+ $sql = "UPDATE ".TB_PREF."sales_orders SET type = !type WHERE order_no=$id";
db_query($sql, "Can't change sales order type");
+ $Ajax->activate('orders_tbl');
}
//---------------------------------------------------------------------------------------------
+$id = find_submit('_chgtpl');
+if ($id != -1)
+ change_tpl_flag($id);
+
+//---------------------------------------------------------------------------------------------
$sql = "SELECT ".TB_PREF."sales_orders.order_no, ".TB_PREF."debtors_master.curr_code, ".TB_PREF."debtors_master.name, ".TB_PREF."cust_branch.br_name,
".TB_PREF."sales_orders.ord_date, ".TB_PREF."sales_orders.deliver_to, ".TB_PREF."sales_orders.delivery_date,
//figure out the sql required from the inputs available
if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
{
- $sql .= " AND ".TB_PREF."sales_orders.order_no LIKE '%". $_POST['OrderNumber'] ."' GROUP BY ".TB_PREF."sales_orders.order_no";
+// if ($_POST['OrderNumber'] != '*') // TODO paged table
+ $sql .= " AND ".TB_PREF."sales_orders.order_no LIKE '%". $_POST['OrderNumber'] ."'";
+ $sql .= " GROUP BY ".TB_PREF."sales_orders.order_no";
}
else
{
".TB_PREF."sales_orders.customer_ref, ".TB_PREF."sales_orders.ord_date, ".TB_PREF."sales_orders.deliver_to";
} //end not order number selected
-
$result = db_query($sql,"No orders were returned");
-
//-----------------------------------------------------------------------------------
-
if ($result)
{
print_hidden_script(30);
+ start_form();
/*show a table of the orders returned by the sql */
+ div_start('orders_tbl');
start_table("$table_style colspan=6 width=95%");
$th = array(_("Order #"), _("Customer"), _("Branch"), _("Cust Order #"), _("Order Date"),
}
table_header($th);
- start_form();
$j = 1;
$k = 0; //row colour counter
$overdue_items = false;
while ($myrow = db_fetch($result))
{
-
$view_page = get_customer_trans_view_str(systypes::sales_order(), $myrow["order_no"]);
$formated_del_date = sql2date($myrow["delivery_date"]);
$formated_order_date = sql2date($myrow["ord_date"]);
+ if (isset($_POST['Update']) &&
+ check_value( "chgtpl".$myrow["order_no"]) != $myrow["type"]) {
+ change_tpl_flag($myrow["order_no"]);
+ $myrow['type'] = !$myrow['type'];
+ }
// $not_closed = $myrow['type'] && ($myrow["TotDelivered"] < $myrow["TotQuantity"]);
// if overdue orders, then highlight as so
}
else
{
- echo "<td><input ".($myrow["type"]==1 ? 'checked' : '')." type='checkbox' name='chgtpl" .$myrow["order_no"]. "' value='1'
- onclick='this.form.ChangeTmpl.value= this.name.substr(6);
- this.form.submit();' ></td>";
+ check_cells( null, "chgtpl" .$myrow["order_no"], $myrow["type"], true,
+ _('Set this order as a template for direct deliveries/invoices'));
$modify_page = $path_to_root . "/sales/sales_order_entry.php?" . SID . "ModifyOrderNumber=" . $myrow["order_no"];
label_cell("<a href='$modify_page'>" . _("Edit") . "</a>");
end_row();;
$j++;
- If ($j == 12)
+ if ($j == 12)
{
$j = 1;
table_header($th);
//end of page full new headings if
}
//end of while loop
- hidden('ChangeTmpl', 0);
- end_form();
end_table();
if ($overdue_items)
display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'");
+ else
+ echo '<br>';
+ div_end();
+ submit_center('Update', _("Update"), true, '', null);
+ end_form();
}
echo "<br>";
-
end_page();
?>
\ No newline at end of file