$benificary_declaration = $_REQUEST['benificary_declaration']; $certificate_quantity = $_REQUEST['certificate_quantity']; $query = "SELECT * FROM document_detatils WHERE consignment_id=" . $consigment_id; $result = $con->data_select($query); if ($result != "no") { $arr = array('bill_of_laden' => $bill_of_laden, 'packing_list' => $packing_list, 'certificate_of_analysis' => $certificate_of_analysis, 'certificate_of_origin' => $certificate_of_origin, 'gsp' => $gsp, 'haz_declaraition' => $haz_declaraition, 'non_hAZ_declaraition' => $non_hAZ_declaraition, 'msds' => $msds, 'heat_treatment_certification' => $heat_treatment_certification, 'benificary_declaration' => $benificary_declaration, 'certificate_quantity' => $certificate_quantity); $json_data = json_encode($arr); if (is_uploaded_file($_FILES['document']['tmp_name'])) { $sourcePath = $_FILES['document']['tmp_name']; $document_name = pathinfo($_FILES['document']['name']); $extension = $document_name['extension']; if ($document_type == "Shipping Documents") { if ($result[0]['shipping_document'] > 0) { $shipping_document = $result[0]['shipping_document']; $query = "UPDATE document_detatils SET service_provider='{$service_provider}',shipping_document_details='{$json_data}', shipping_document='{$shipping_document}', shipping_document_update='{$date}' WHERE consignment_id=" . $consigment_id; $result = $con->data_update($query); if ($result > 0) { $targetPath = "../uploaded/" . $shipping_document; //echo "success"; } } else { $shipping_document = $consigment_id . "shipping_document" . "." . $extension; $query = "UPDATE document_detatils SET service_provider='{$service_provider}',shipping_document_details='{$json_data}', shipping_document='{$shipping_document}', shipping_document_update='{$date}' WHERE consignment_id=" . $consigment_id; $result = $con->data_update($query); if ($result > 0) { $targetPath = "../uploaded/" . $shipping_document; //echo "success"; } } } elseif ($document_type == "Commercial Invoice") { if ($result[0]['commercial_invoice'] > 0) {
echo "Invalied CUSTOMER_NUMBER or PASSWORD"; } } if (isset($_REQUEST['action']) && $_REQUEST['action'] == "Logout") { session_destroy(); session_unset(); header('Location: index.php'); } if (isset($_REQUEST['action']) && $_REQUEST['action'] == "F-Vertical") { $sql = "SELECT FAVOURITE_VERTICAL FROM login_master WHERE CUSTOMER_NUMBER = " . $_SESSION['cust_id']; $result = $con->data_select($sql); echo $result[0]['FAVOURITE_VERTICAL']; } if (isset($_REQUEST['action']) && $_REQUEST['action'] == "updatefcat") { $sql = "UPDATE login_master SET FAVOURITE_VERTICAL = '" . $_REQUEST['cat_name'] . "' WHERE CUSTOMER_NUMBER = " . $_SESSION['cust_id']; $result = $con->data_update($sql); echo "Success"; } if (isset($_REQUEST['action']) && $_REQUEST['action'] == "cartonload") { $sql = "SELECT COUNT(*) FROM customer_cart WHERE CUSTOMER_NUMBER = '" . $_SESSION['cust_id'] . "'"; $result = $con->data_select($sql); $_SESSION["cart_count"] = $result[0]['COUNT(*)']; echo $_SESSION['cart_count']; } if (isset($_REQUEST['action']) && $_REQUEST['action'] == "insertcart") { $prod_code = $_REQUEST['prod_code']; $prod_desc = $_REQUEST['prod_desc']; $remark = $_REQUEST['remark']; $qty = $_REQUEST['qty']; $pkgsize = $_REQUEST['pkgsize']; $cust_id = $_SESSION['cust_id'];
<?php include '../classes/functions.php'; $con = new functions(); session_start(); date_default_timezone_set("Asia/Kolkata"); $date4 = date('Y-m-d H:i:s'); $role_id = $_SESSION['role_id']; if ($_REQUEST['action'] == "insertupdateconsignment") { $query = "UPDATE consignment_details SET consignment_address='" . $_REQUEST['consignment_address'] . "',mode_of_shipment='" . $_REQUEST['mode_of_shipment'] . "',vessel_name='" . $_REQUEST['vessel_name'] . "',etd_date='" . $_REQUEST['etd_date'] . "',container_number='" . $_REQUEST['container_name'] . "',shipped_on_board='" . $_REQUEST['shipped_on_board'] . "',transhipment_port='" . $_REQUEST['transhipment_port'] . "',transhipment_vessel_name='" . $_REQUEST['transhipment_vessel_name'] . "',eta_date='" . $_REQUEST['eta_date'] . "',arrival_date='" . $_REQUEST['arrival_date'] . "',custom_clearance_date='" . $_REQUEST['custom_clearance_date'] . "',custom_clearance='" . $_REQUEST['custom_clearance'] . "',delivered_cutomer_loaction='" . $_REQUEST['delivered_cutomer_loaction'] . "',remark='" . $_REQUEST['remark'] . "' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result0 = $con->data_update($query); if ($result0 > 0) { //$query="SELECT consigneement_addrss, mode_of_shipment, vessel_name, etd_date, container_number, shipped_on_board, transhipment_port, transhipment_vessel_name, eta_date, arrival_date, custom_clearance_date, custom_clearance, delivered_cutomer_loaction, remark, consignment_id FROM consignment_update WHERE consignment_id=".$_REQUEST['consignment_id']; $query = "SELECT consignment_address, mode_of_shipment, vessel_name, etd_date, container_number, shipped_on_board, transhipment_port, transhipment_vessel_name, eta_date, arrival_date, custom_clearance_date, custom_clearance, delivered_cutomer_loaction, remark, consignment_id FROM consignment_details WHERE consignment_id=" . $_REQUEST['consignment_id']; $result = $con->data_select($query); $edt_date = $result[0]['etd_date']; if ($edt_date > $date4) { $query = "UPDATE consignment_details SET order_status='IN TRANSIT' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result1 = $con->data_update($query); if ($result[0]['arrival_date'] > 0) { $query = "UPDATE consignment_details SET order_status='ARRIVED AT PORT' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result2 = $con->data_update($query); if ($result[0]['custom_clearance'] == "yes") { $query = "UPDATE consignment_details SET order_status='UNDER CUSTOM ClEARENCE' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result3 = $con->data_update($query); if ($result[0]['custom_clearance_date'] > 0) { $query = "UPDATE consignment_details SET order_status='OUT FOR DELIVERY' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result4 = $con->data_update($query); if ($result[0]['delivered_cutomer_loaction'] > 0) { $query = "UPDATE consignment_details SET order_status='CLOSED' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result5 = $con->data_update($query);