$cart_count = $_SESSION['cart_count']; $increment = 1; $sql1 = "SELECT CUSTOMER_NUMBER PRODUCT_CODE FROM customer_cart WHERE PRODUCT_CODE =" . $prod_code . " AND CUSTOMER_NUMBER=" . $cust_id; $result1 = $con->data_select($sql1); $sql2 = "SELECT ID, PACKAGING_CODE, OPERAND, ACCOUNT_NUMBER, PRODUCT_CODE FROM xxdkapps_price_list_master WHERE PACKAGING_CODE LIKE '%" . $pkgsize . "' AND ACCOUNT_NUMBER = '" . $cust_id . "' AND PRODUCT_CODE = '" . $prod_code . "' ORDER BY ID DESC LIMIT 1"; $result2 = $con->data_select($sql2); if ($result2 != "no") { $price = $result2[0]['OPERAND']; } else { $price = 0.0; } if ($result1 != "no") { echo "Product already in the Cart"; } else { $sql = "INSERT INTO customer_cart (CUSTOMER_NUMBER, PRODUCT_CODE, ITEM_DESCRIPTION, PACKAGING_SIZE, QUANTITY, AVAILABLE_PRICE, REMARK) VALUES ({$cust_id},{$prod_code},'{$prod_desc}','{$pkgsize}','{$qty}','{$price}','{$remark}')"; $result = $con->data_insert($sql); $_SESSION['cart_count'] = $cart_count + $increment; echo $_SESSION['cart_count']; } } if (isset($_REQUEST['action']) && $_REQUEST['action'] == "removecart") { $prod_code = $_REQUEST['prod_code']; $cust_id = $_SESSION['cust_id']; $cart_count = $_SESSION['cart_count']; $increment = 1; $sql = "DELETE FROM customer_cart WHERE PRODUCT_CODE =" . $prod_code . " AND CUSTOMER_NUMBER =" . $cust_id; $result = $con->data_delete($sql); $_SESSION['cart_count'] = $cart_count - $increment; echo $_SESSION['cart_count']; } if (isset($_REQUEST['action']) && $_REQUEST['action'] == "updatecart") {
$data[$i] = $row; $i++; } /*echo "<pre>"; print_r($data); exit;*/ foreach ($data as $key => $value) { $order_status = ""; if ($data[$key]['ORDER_STATUS'] == "CLOSED") { $order_status = "DESPATCH"; $sql = "INSERT INTO logistic_view(CUST_PO_NUMBER, CUSTOMER_NUM, ORG_ID, FREIGHT_TERMS_CODE, SHIPPED_QUANTITY, DELIVERY_ID, DESCRIPTION, INVOICE_NUMBER, PORT_OF_DISCHARGE, SHIPPING_STATUS, SHIPPING_VALUE_INR, ORDER_STATUS, DELIVERY_DETAIL_ID, REQUIRE_DATE_DESTINATION, HEADER_LUD, LINE_LUD, WSH_LUD, WDD_LUD, WND_LUD, EMP_LUD, EML_LUD, JAI_LUD,REF_INV,SHIPPING_VALUE,CURRENCY,DISPATCH_DATE) VALUES ('" . $data[$key]['CUST_PO_NUMBER'] . "','" . $data[$key]['CUSTOMER_NUM'] . "','" . $data[$key]['ORG_ID'] . "','" . $data[$key]['FREIGHT_TERMS_CODE'] . "','" . $data[$key]['SHIPPED_QUANTITY'] . "','" . $data[$key]['DELIVERY_ID'] . "','" . $data[$key]['DESCRIPTION'] . "','" . $data[$key]['INVOICE_NUMBER'] . "','" . $data[$key]['PORT_OF_DISCHARGE'] . "','" . $data[$key]['SHIPPING_STATUS'] . "','" . $data[$key]['SHIPPING_VALUE_INR'] . "','" . $order_status . "','" . $data[$key]['DELIVERY_DETAIL_ID'] . "','" . $data[$key]['REQUIRE_DATE_DESTINATION'] . "','" . $data[$key]['HEADER_LUD'] . "','" . $data[$key]['LINE_LUD'] . "','" . $data[$key]['WSH_LUD'] . "','" . $data[$key]['WDD_LUD'] . "','" . $data[$key]['WND_LUD'] . "','" . $data[$key]['EMP_LUD'] . "','" . $data[$key]['EML_LUD'] . "','" . $data[$key]['JAI_LUD'] . "','" . $data[$key]['REF_INV'] . "','" . $data[$key]['SHIPPING_VALUE'] . "','" . $data[$key]['CURRENCY'] . "','" . $data[$key]['DISPATCH_DATE'] . "')"; } else { $order_status = $data[$key]['ORDER_STATUS']; $sql = "INSERT INTO logistic_view(CUST_PO_NUMBER, CUSTOMER_NUM, ORG_ID, FREIGHT_TERMS_CODE, SHIPPED_QUANTITY, DELIVERY_ID, DESCRIPTION, INVOICE_NUMBER, PORT_OF_DISCHARGE, SHIPPING_STATUS, SHIPPING_VALUE_INR, ORDER_STATUS, DELIVERY_DETAIL_ID, REQUIRE_DATE_DESTINATION, HEADER_LUD, LINE_LUD, WSH_LUD, WDD_LUD, WND_LUD, EMP_LUD, EML_LUD, JAI_LUD,REF_INV,SHIPPING_VALUE,CURRENCY,DISPATCH_DATE) VALUES ('" . $data[$key]['CUST_PO_NUMBER'] . "','" . $data[$key]['CUSTOMER_NUM'] . "','" . $data[$key]['ORG_ID'] . "','" . $data[$key]['FREIGHT_TERMS_CODE'] . "','" . $data[$key]['SHIPPED_QUANTITY'] . "','" . $data[$key]['DELIVERY_ID'] . "','" . $data[$key]['DESCRIPTION'] . "','" . $data[$key]['INVOICE_NUMBER'] . "','" . $data[$key]['PORT_OF_DISCHARGE'] . "','" . $data[$key]['SHIPPING_STATUS'] . "','" . $data[$key]['SHIPPING_VALUE_INR'] . "','" . $order_status . "','" . $data[$key]['DELIVERY_DETAIL_ID'] . "','" . $data[$key]['REQUIRE_DATE_DESTINATION'] . "','" . $data[$key]['HEADER_LUD'] . "','" . $data[$key]['LINE_LUD'] . "','" . $data[$key]['WSH_LUD'] . "','" . $data[$key]['WDD_LUD'] . "','" . $data[$key]['WND_LUD'] . "','" . $data[$key]['EMP_LUD'] . "','" . $data[$key]['EML_LUD'] . "','" . $data[$key]['JAI_LUD'] . "','" . $data[$key]['REF_INV'] . "','" . $data[$key]['SHIPPING_VALUE'] . "','" . $data[$key]['CURRENCY'] . "','" . $data[$key]['DISPATCH_DATE'] . "')"; } $result = $con->data_insert($sql); } $getdata_mysql_consignment_details = "SELECT MAX(delivery_details_id) FROM consignment_details"; $result_mysql = $con->data_select($getdata_mysql_consignment_details); if ($result_mysql != "no") { $sql = "SELECT CUST_PO_NUMBER, CUSTOMER_NUM, ORG_ID, FREIGHT_TERMS_CODE, SHIPPED_QUANTITY, DELIVERY_ID, DESCRIPTION, INVOICE_NUMBER, PORT_OF_DISCHARGE, SHIPPING_STATUS, SHIPPING_VALUE_INR, ORDER_STATUS, SHIPPED_DATE, DELIVERY_DETAIL_ID, REQUIRE_DATE_DESTINATION, HEADER_LUD, LINE_LUD, WSH_LUD, WDD_LUD, WND_LUD, EMP_LUD, EML_LUD, JAI_LUD,REF_INV,SHIPPING_VALUE,CURRENCY,DISPATCH_DATE\n\t\t FROM logistic_view WHERE DELIVERY_DETAIL_ID > '" . $result_mysql[0]['MAX(delivery_details_id)'] . "'"; $result = $con->data_select($sql); if ($result != "no") { foreach ($result as $key => $value) { $sql_consignment_details = "INSERT INTO consignment_details(cust_po_number,customer_num,org_id,\n\t\t\t \tfreight_terms_code,shipped_quantity,delivery_id,item_description,commercial_invoice,\n\t\t\t \tport_of_discharge,shipping_status,shipping_value_inr,order_status,\n\t\t\t delivery_details_id,require_date,\n\t\t\t Header_lud,line_lud,wsh_lud,wdd_lud,wnd_lud,emp_lud,eml_lud,jai_lud,ref_inv,shipping_value,currency,dispatch_date)\n\t\t\t VALUES ('" . $result[$key]['CUST_PO_NUMBER'] . "','" . $result[$key]['CUSTOMER_NUM'] . "','" . $result[$key]['ORG_ID'] . "',\n\t\t\t \t'" . $result[$key]['FREIGHT_TERMS_CODE'] . "','" . $result[$key]['SHIPPED_QUANTITY'] . "','" . $result[$key]['DELIVERY_ID'] . "'\n\t\t\t \t,'" . $result[$key]['DESCRIPTION'] . "','" . $result[$key]['INVOICE_NUMBER'] . "','" . $result[$key]['PORT_OF_DISCHARGE'] . "',\n\t\t\t \t'" . $result[$key]['SHIPPING_STATUS'] . "','" . $result[$key]['SHIPPING_VALUE_INR'] . "','" . $result[$key]['ORDER_STATUS'] . "',\n\t\t\t \t'" . $result[$key]['DELIVERY_DETAIL_ID'] . "','" . $result[$key]['REQUIRE_DATE_DESTINATION'] . "',\n\t\t\t \t'" . $result[$key]['HEADER_LUD'] . "','" . $result[$key]['LINE_LUD'] . "','" . $result[$key]['WSH_LUD'] . "','" . $result[$key]['WDD_LUD'] . "','" . $result[$key]['WND_LUD'] . "',\n\t\t\t \t'" . $result[$key]['EMP_LUD'] . "','" . $result[$key]['EML_LUD'] . "','" . $result[$key]['JAI_LUD'] . "',\n\t\t\t \t'" . $result[$key]['REF_INV'] . "','" . $result[$key]['SHIPPING_VALUE'] . "','" . $result[$key]['CURRENCY'] . "','" . $result[$key]['DISPATCH_DATE'] . "')"; $result_consignment_details = $con->data_insert($sql_consignment_details); } } } else { $sql = "SELECT CUST_PO_NUMBER, CUSTOMER_NUM, ORG_ID, FREIGHT_TERMS_CODE, SHIPPED_QUANTITY, DELIVERY_ID, DESCRIPTION, INVOICE_NUMBER, PORT_OF_DISCHARGE, SHIPPING_STATUS, SHIPPING_VALUE_INR, ORDER_STATUS, SHIPPED_DATE, DELIVERY_DETAIL_ID, REQUIRE_DATE_DESTINATION, HEADER_LUD, LINE_LUD, WSH_LUD, WDD_LUD, WND_LUD, EMP_LUD, EML_LUD, JAI_LUD,REF_INV,SHIPPING_VALUE,CURRENCY,DISPATCH_DATE\n\t\t FROM logistic_view"; $result = $con->data_select($sql);
} $query = "SELECT user_id,user_name FROM user_registration"; $result1 = $con->data_select($query); $_SESSION['success'] = "no"; if (isset($_FILES) && !empty($_FILES)) { if (is_array($_FILES)) { if (is_uploaded_file($_FILES['containerdetails']['tmp_name'])) { $sourcePath = $_FILES['containerdetails']['tmp_name']; $user = "******"; $targetPath = "uploaded/container" . $user . ".csv"; $i = 0; if (move_uploaded_file($sourcePath, $targetPath)) { $file = fopen("uploaded/container" . $user . ".csv", "r"); while (($line = fgetcsv($file)) !== FALSE) { $sql_insert_product = "INSERT INTO consignment_details(customer_name, account_number, cust_po_number, order_number, ordered_item_id, item_description, unit_selling_price, order_quantity_uom, ordered_quantity, amount, request_date, schedule_ship_date, order_date) VALUES ('" . $line[0] . "','" . $line[1] . "','" . $line[2] . "','" . $line[3] . "','" . $line[4] . "','" . $line[5] . "'," . $line[6] . ",'" . $line[7] . "','" . $line[8] . "','" . $line[9] . "','" . $line[10] . "','" . $line[11] . "','" . $line[12] . "')"; $result2 = $con->data_insert($sql_insert_product); } if ($result2 > 0) { $_SESSION['success'] = "Data has been uploaded!!!!!!"; fclose($file); } } } } header("Location:container_details.php"); } include 'admin_sidebar_header.php'; ?> <!-- page content -->
$obj = new functions(); $roles[1] = "Admin"; $roles[2] = "Manager"; echo "kudnan"; exit; date_default_timezone_set('Asia/Kolkata'); $content = ""; if (isset($_REQUEST['action']) && $_REQUEST['action'] != "") { $user_info_all = explode(",", $_REQUEST['user']); $i = 1; foreach ($user_info_all as $key => $values) { $user_info = explode("-", $user_info_all[$key]); $sql_duplicate = "select name from user where name='" . $user_info[1] . "' and role !=3 "; $duplicate = $obj->data_select($sql_duplicate); if ($duplicate != "no") { continue; } else { $sql_insert = "insert into user(name,email,role,display_name) values ('" . $user_info[1] . "','" . $user_info[0] . "','" . $user_info[20] . "'," . $_REQUEST['role'] . ")"; $res = $obj->data_insert($sql_insert); $content .= "<tr><td>" . $i . "</td><td>" . $user_info[1] . "</td><td>" . $user_info[0] . "</td><td>" . $roles[$_REQUEST['role']] . "</td></tr>"; $i++; } } if ($content == "") { $content .= "NO Records has been Added!!!!"; } else { echo $content; } } else { echo "fail"; }