add_styles_page();
$db = new db_safeguard();
$calls = new call_functions();
if ($_POST['jc_number'] != '') {
if ($_POST['date_from'] == '' && $_POST['date_to'] == '') {
$disptach_res = $db->query("order_trans", "SELECT * FROM order_trans WHERE ((amount < 0) AND (job_card_no = '{$_POST['jc_number']}' AND user_id != 0 AND order_id = 0)) OR ((amount > 0) AND (job_card_no = '{$_POST['jc_number']}' AND user_id != 0 AND order_id = 0)) ORDER BY `record_id` DESC;");
} else {
$disptach_res = $db->query("order_trans", "SELECT * FROM order_trans WHERE ((date_time BETWEEN '{$_POST['date_from']} 00:00' AND '{$_POST['date_to']} 23:59' AND amount < 0) AND (job_card_no = '{$_POST['jc_number']}' AND user_id != 0 AND order_id = 0)) OR ((date_time BETWEEN '{$_POST['date_from']} 00:00' AND '{$_POST['date_to']} 23:59' AND amount > 0) AND (job_card_no = '{$_POST['jc_number']}' AND user_id != 0 AND order_id = 0)) ORDER BY `record_id` DESC;");
}
} else {
$disptach_res = $db->query("order_trans", "SELECT * FROM order_trans WHERE ((date_time BETWEEN '{$_POST['date_from']} 00:00' AND '{$_POST['date_to']} 23:59' AND amount < 0) AND (job_card_no != '' AND user_id != 0 AND order_id = 0)) OR ((date_time BETWEEN '{$_POST['date_from']} 00:00' AND '{$_POST['date_to']} 23:59' AND amount > 0) AND (job_card_no != '' AND user_id != 0 AND order_id = 0)) ORDER BY `record_id` DESC;");
}
?>
fetch_assoc()) {
$item_res = $db->query("stock", "SELECT * FROM stock WHERE record_id = {$disptach['stock_id']}");
$item = $item_res->fetch_assoc();
// check if job card is on project job card:
$job_card_project_res = $db->query("job_cards", "SELECT * FROM job_cards WHERE jc_number = '{$disptach['job_card_no']}'");
$job_card_tech_res = $db->query("job_cards_tech", "SELECT * FROM job_cards_tech WHERE jc_number ='{$disptach['job_card_no']}'");
$job_card_acc_res = $db->query("job_card_accounts", "SELECT * FROM job_card_accounts WHERE `name` = '{$disptach['job_card_no']}'");
if ($job_card_project_res->num_rows > 0) {
$job_card = $job_card_project_res->fetch_assoc();
$job_card_name = $job_card["project_name"];
} else if ($job_card_tech_res->num_rows > 0) {
$job_card = $job_card_tech_res->fetch_assoc();
$job_card_name = $job_card["company_name"];
} else if ($job_card_acc_res->num_rows > 0) {
$job_card = $job_card_acc_res->fetch_assoc();
$job_card_name = $job_card["description"];
} else {
$job_card_name = "N/A";
}
?>