$CURR_DATE = date('Y-m-d H:i:s'); $sql_order_form_insert = "INSERT INTO order_form_details (ID, PO, CUSTOMER_NUMBER,ORDER_DATE, SOLD_TO, SHIP_TO, CONTACT_PERSON, DELIVERY_DATE, ORDERED_FROM, ORDER_WEB_ID, UPLOAD_TYPE, TRANSACTIONAL_CURR_CODE, ORDER_TYPE, SALESREP_ID, ORG_ID, PRICE_LIST_ID, SHIP_FROM_ORG_ID, SOLD_TO_ORG_ID, CREATED_BY, PAYMENT_TERM_ID, INVOICE_TO_ORG_ID, VESSEL, COMMENTS, ATTRIBUTE12, FREIGHT_TERMS, FREIGHT_VALUE, DAY_SEQUENCE) \n\t\tVALUES (NULL, '{$PO}', {$CUSTOMER_NUMBER} , '{$CURR_DATE}', {$SOLD_TO_ID}, {$SHIP_TO_ID}, '{$CONTACT_PERSON}', '{$DELIVERY_DATE}', 'PORTAL', '{$ORDER_WEB_ID}', 'ORDER', '{$TRANSACTIONAL_CURR_CODE}', {$ORDER_TYPE}, {$SALESREP_ID}, {$ORG_ID}, {$DEFAULTPRICELIST}, {$DEFAULT_WAREHOUSE}, {$SOLD_TO_ORG_ID}, {$CREATED_BY}, {$PAYMENT_TERM_ID}, {$INVOICE_TO_ORG_ID}, '{$VESSEL}', '{$COMMENTS}', '{$ATTRIBUTE12}', '{$FREIGHT_TERMS}', '{$FREIGHT_VALUE}', {$LAST_ID}\t)"; $lastInsertId = $con->data_insert_return_id($sql_order_form_insert); foreach ($prodArr as $id => $pC) { $pcl = $prodDetArr[$pC]['price_list_id']; $pkcd = $prodDetArr[$pC]['pack_code']; $icd = $prodDetArr[$pC]['item_code']; $ivd = $prodDetArr[$pC]['inventory_id']; $pksz = $prodDetArr[$pC]['pack']; $qty = $prodDetArr[$pC]['quantity']; $uom = $prodDetArr[$pC]['uom']; $up = $prodDetArr[$pC]['AVAILABLE_PRICE']; $oid = $prodDetArr[$pC]['org_id']; $rmk = $prodDetArr[$pC]['remarks']; $tot = $up * $qty; $sql_order_products_insert = "INSERT INTO order_products (ID, ORDER_ID, PRICE_LIST_ID, PRODUCT_CODE, PACKAGE_CODE, ITEM_CODE, INVENTORY_ITEM_ID, PACKAGE_QTY, PRODUCT_TOTAL, QUANTITY, UOM, UNIT_PRICE,\tORG_ID, REMARKS) \n\t\t\tVALUES (NULL, {$lastInsertId}, {$pcl} , {$pC}, '{$pkcd}', '{$icd}', {$ivd}, '{$pksz}', '{$tot}', '{$qty}', '{$uom}', {$up}, {$oid}, '{$rmk}') "; $result = $con->data_insert_return_id($sql_order_products_insert); } } } /******** Remove Products From Cart *****/ $sql_empty_cart = "DELETE FROM customer_cart WHERE CUSTOMER_NUMBER =" . $CUSTOMER_NUMBER; $result = $con->data_delete($sql_empty_cart); $_SESSION['cart_count'] = "0"; /******** Send mail to customer, sales person and customer service *****/ ?> <div class="container"> <div class="row animated fadeInRight"> <h1>Thanks for Buying with DorfKetal.</h1> </div> </div>
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") { $prod_code = $_REQUEST['prod_code']; $remark = $_REQUEST['remark']; $qty = $_REQUEST['qty']; $pkgsize = $_REQUEST['pkgsize']; $cust_id = $_SESSION['cust_id']; $sql = "UPDATE customer_cart SET QUANTITY = '" . $qty . "', PACKAGING_SIZE ='" . $pkgsize . "', REMARK = '" . $remark . "' WHERE CUSTOMER_NUMBER = " . $_SESSION['cust_id'] . " AND PRODUCT_CODE = " . $prod_code; $result = $con->data_update($sql); echo "success"; } if (isset($_REQUEST['action']) && $_REQUEST['action'] == "getcatapplication") { $cat_name = $_REQUEST['cat_name'];
exit; } exit; } if ($_REQUEST['action'] == "insertassignconsignment") { $query = "INSERT INTO assign_consignment(user_id, consignment_id, orign_location, destination_location, status) VALUES \n\t(" . $_REQUEST['user_id'] . "," . $_REQUEST['consigmant_id'] . ",'" . $_REQUEST['orign_location'] . "','" . $_REQUEST['destination_location'] . "','" . $_REQUEST['status'] . "')"; $result = $con->data_insert($query); if ($result > 0) { echo "success"; exit; } } if ($_REQUEST['action'] == "deleteDocument") { if ($_REQUEST['document_type'] == 's') { $query = "UPDATE document_detatils SET shipping_document='', shipping_document_update='' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result = $con->data_delete($query); if ($result > 0) { echo "success"; } } if ($_REQUEST['document_type'] == 'c') { $query = "UPDATE document_detatils SET commercial_invoice='', commercial_invoice_update='' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result = $con->data_delete($query); if ($result > 0) { echo "success"; } } if ($_REQUEST['document_type'] == 'i') { $query = "UPDATE document_detatils SET india_commercial_invoice='', india_commercial_invoice_update='' WHERE consignment_id=" . $_REQUEST['consignment_id']; $result = $con->data_delete($query); if ($result > 0) {