MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
-$page_security = 2;
-$path_to_root="..";
+$page_security = 'SA_MANUFTRANSVIEW';
+$path_to_root = "..";
include($path_to_root . "/includes/db_pager.inc");
include_once($path_to_root . "/includes/session.inc");
function check_overdue($row)
{
return (!$row["closed"]
- && date_diff(Today(), sql2date($row["required_by"]), "d") > 0);
+ && date_diff2(Today(), sql2date($row["required_by"]), "d") > 0);
}
function view_link($dummy, $order_no)
{
- return get_trans_view_str(systypes::work_order(), $order_no);
+ return get_trans_view_str(ST_WORKORDER, $order_no);
}
function view_stock($row)
function wo_type_name($dummy, $type)
{
- return wo_types::name($type);
+ global $wo_types_array;
+
+ return $wo_types_array[$type];
}
function edit_link($row)
return $row["closed"] || !$row["released"] ? '' :
pager_link(_('Costs'),
"/gl/gl_bank.php?NewPayment=1&PayType="
- .payment_person_types::WorkOrder(). "&PayPerson=" .$row["id"]);
+ .PT_WORKORDER. "&PayPerson=" .$row["id"]);
*/
return $row["closed"] || !$row["released"] ? '' :
pager_link(_('Costs'),
{
if ($row['closed'] == 0)
return '';
- return get_gl_view_str(systypes::work_order(), $row['id']);
+ return get_gl_view_str(ST_WORKORDER, $row['id']);
}
function dec_amount($row, $amount)
if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items)
{
- $sql .= " AND workorder.loc_code='" . $_POST['StockLocation'] . "' ";
+ $sql .= " AND workorder.loc_code=".db_escape($_POST['StockLocation']);
}
if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
{
- $sql .= " AND workorder.wo_ref LIKE '%". $_POST['OrderNumber'] . "%'";
+ $sql .= " AND workorder.wo_ref LIKE ".db_escape('%'.$_POST['OrderNumber'].'%');
}
if (isset($_POST['SelectedStockItem']) && $_POST['SelectedStockItem'] != $all_items)
{
- $sql .= " AND workorder.stock_id='". $_POST['SelectedStockItem'] . "'";
+ $sql .= " AND workorder.stock_id=".db_escape($_POST['SelectedStockItem']);
}
if (check_value('OverdueOnly'))
$table =& new_db_pager('orders_tbl', $sql, $cols);
$table->set_marker('check_overdue', _("Marked orders are overdue."));
-if (get_post('SearchOrders')) {
- $table->set_sql($sql);
- $table->set_columns($cols);
-}
$table->width = "90%";
start_form();