add_styles_page(); $html->prevent_enter_script(); ?>
query("stock", "SELECT `description` FROM stock WHERE record_id = '{$stock_id}'"); $row = $res->fetch_assoc(); return $row['description']; } // echo $_GET['jobcard_number']; $transactions_amount_res = $db->query("order_trans", "SELECT * FROM order_trans WHERE job_card_no = '{$_GET['jobcard_number']}' AND order_id = 0"); if ($transactions_amount_res->num_rows < 1) { echo "NO ITEMS DISPTACHED UNDER THIS JOB CARD"; } else { $index = 0; echo "
"; echo "
"; echo "

STOCK

"; $get_dispatches_res = $db->query("order_trans", "SELECT DISTINCT stock_id FROM order_trans WHERE job_card_no = '{$_GET['jobcard_number']}' AND order_id = 0 AND units_stock_id = 0"); while ($get_dispatches_row = $get_dispatches_res->fetch_assoc()) { $index++; $get_dispatches_res2 = $db->query("order_trans", "SELECT SUM(amount) as total FROM order_trans WHERE job_card_no = '{$_GET['jobcard_number']}' AND stock_id = '{$get_dispatches_row['stock_id']}' AND order_id = 0"); $get_dispatches_row2 = $get_dispatches_res2->fetch_assoc(); if ($get_dispatches_row2['total'] == 0) { continue; } echo "
"; echo ""; echo " "; echo ""; echo ""; echo "
"; } echo "
"; echo "
"; echo "

UNITS

"; $get_dispatches_res = $db->query("order_trans", "SELECT DISTINCT units_stock_id,stock_id FROM order_trans WHERE job_card_no = '{$_GET['jobcard_number']}' AND order_id = 0 AND units_stock_id > 0"); while ($get_dispatches_row = $get_dispatches_res->fetch_assoc()) { // check total of units $amound_res = $db->query("order_trans", "SELECT SUM(amount) as total FROM order_trans WHERE units_stock_id = '{$get_dispatches_row['units_stock_id']}'"); $amount_row = $amound_res->fetch_assoc(); if ($amount_row['total'] > 0) { $index++; continue; } $index++; $get_dispatches_res2 = $db->query("units_stock", "SELECT * FROM units_stock WHERE record_id = '{$get_dispatches_row['units_stock_id']}'"); $get_dispatches_row2 = $get_dispatches_res2->fetch_assoc(); echo "
"; echo ""; echo ""; echo " "; echo " "; echo ""; echo "
"; } echo ""; echo ""; new signature("signature"); echo ""; echo "
"; } ?>