query("costs", "INSERT INTO `costs`(`name`, `jc_number`, `date_time_created`, `status`, `user_id`, `job_card_account_id`,`include_vat`) VALUES ('$name','$jc_number','$order_date','1',{$_SESSION['user_id']},'$job_card_account_id','{$_POST['include_vat']}')");
$index = 0;
$order_items_array = [];
while ($index < $_POST['counter']) {
if (strlen($_POST['item_description' . $index]) >= 1) {
$description = $_POST['item_description' . $index];
$quantity = $_POST['quantity' . $index];
$cost_price = $_POST['cost_price' . $index];
$db->query("cost_items", "INSERT INTO `cost_items`(`name`, `quantity`, `purchase_price_ex`, `cost_id`, `user_id_created`) VALUES ('$description','$quantity','$cost_price','$cost_id','{$_SESSION['user_id']}')");
}
$index++;
}
if ($job_card_account_id != 0) {
$call = new call_functions();
$tool_res = $db->query("job_card_accounts", "SELECT * FROM `job_card_accounts` WHERE `record_id` = '$job_card_account_id'");
$tool = $tool_res->fetch_assoc();
if ((strpos($tool['name'], "ST-") !== false || strpos($tool['name'], "TA-") !== false) && count($order_items_array) > 0 && strlen($tool['name']) > 0) {
$call->send_for_email(['chanay@midrandac.co.za'], ['Chanay'], "Tool Account Order : " . $tool['name'], "
Tool Account Order : " . $tool['name'] . "
PO Number : " . $_POST['po_number'] . "
JC Number : " . $_POST['jc_number'] . "
Supplier : " . $call->get_supplier_name($supplier_id) . "
Order Date : " . $_POST['order_date'] . "
Ordered For : " . $_POST['ordered_for'] . "
| Item | Quantity | Cost Price | " . implode("", $order_items_array) . "
");
}
}
echo "";