+//-----------------------------------------------------------------------------
+function check_overdue($row)
+{
+ return (!$row["closed"]
+ && date_diff(Today(), sql2date($row["required_by"]), "d") > 0);
+}
+
+function view_link($dummy, $order_no)
+{
+ return get_trans_view_str(systypes::work_order(), $order_no);
+}
+
+function view_stock($row)
+{
+ return view_stock_status($row["stock_id"], $row["description"], false);
+}
+
+function wo_type_name($dummy, $type)
+{
+ return wo_types::name($type);
+}
+
+function edit_link($row)
+{
+ return $row['closed'] ? '<i>'._('Closed').'</i>' :
+ pager_link(_("Edit"),
+ "/manufacturing/work_order_entry.php?trans_no=" . $row["id"], ICON_EDIT);
+}
+
+function release_link($row)
+{
+ return $row["closed"] ? '' :
+ ($row["released"]==0 ?
+ pager_link(_('Release'),
+ "/manufacturing/work_order_release.php?trans_no=" . $row["id"])
+ :
+ pager_link(_('Issue'),
+ "/manufacturing/work_order_issue.php?trans_no=" .$row["id"]));
+}
+
+function produce_link($row)
+{
+ return $row["closed"] || !$row["released"] ? '' :
+ pager_link(_('Produce'),
+ "/manufacturing/work_order_add_finished.php?trans_no=" .$row["id"]);
+}
+
+function costs_link($row)
+{
+/*
+ return $row["closed"] || !$row["released"] ? '' :
+ pager_link(_('Costs'),
+ "/gl/gl_bank.php?NewPayment=1&PayType="
+ .payment_person_types::WorkOrder(). "&PayPerson=" .$row["id"]);
+*/
+ return $row["closed"] || !$row["released"] ? '' :
+ pager_link(_('Costs'),
+ "/manufacturing/work_order_costs.php?trans_no=" .$row["id"]);
+}
+
+function view_gl_link($row)
+{
+ if ($row['closed'] == 0)
+ return '';
+ return get_gl_view_str(systypes::work_order(), $row['id']);
+}
+
+function dec_amount($row, $amount)
+{
+ return number_format2($amount, $row['decimals']);
+}
+
+$sql = "SELECT
+ workorder.id,
+ workorder.wo_ref,
+ workorder.type,
+ location.location_name,
+ item.description,
+ workorder.units_reqd,
+ workorder.units_issued,
+ workorder.date_,
+ workorder.required_by,
+ workorder.released_date,
+ workorder.closed,
+ workorder.released,
+ workorder.stock_id,
+ unit.decimals
+ FROM ".TB_PREF."workorders as workorder,"
+ .TB_PREF."stock_master as item,"
+ .TB_PREF."item_units as unit,"
+ .TB_PREF."locations as location
+ WHERE workorder.stock_id=item.stock_id
+ AND workorder.loc_code=location.loc_code
+ AND item.units=unit.abbr";