<?php include "./classes/functions.php"; $con = new functions(); session_start(); date_default_timezone_set("Asia/Kolkata"); // echo "<pre>"; // print_r($_REQUEST); // exit; /******** Fetch Cart Products *****/ $sql_prod = "SELECT ID, PRODUCT_CODE AS ITEM_CODE, DESCRIPTION, ATTRIBUTE18 as PRODUCT_APPLICATION, ATTRIBUTE17 as PRODUCT_GROUP FROM xxdkapps_unsegregated_products as up WHERE DESCRIPTION = '" . $_REQUEST['prod_desc'] . "'"; $result_prod = $con->data_select($sql_prod); $result_prod[0]['CUSTOMER_NUMBER'] = $_SESSION['cust_id']; $result_prod[0]['QUANTITY'] = trim(substr($_REQUEST['qty'], 0, -3)); $result_prod[0]['PACKAGING_SIZE'] = trim(substr($_REQUEST['pkg_size'], 0, -10)); $result_prod[0]['AVAILABLE_PRICE'] = trim(substr($_REQUEST['price'], 0, -4)); $result_prod[0]['REMARK'] = $_REQUEST['remark']; /******** Order Form Data Fields *****/ $ORDER_WEB_ID = 0; $PO = $_REQUEST['po_no']; $CUSTOMER_NUMBER = $_SESSION['cust_id']; $CUSTOMER_ACCOUNT_NUMBER = ""; $SOLD_TO = $_REQUEST['sold_to']; $SOLD_TO_ID = $_REQUEST['sold_to_id']; $SHIP_TO = $_REQUEST['ship_to']; $SHIP_TO_ID = $_REQUEST['ship_to_id']; $UPLOAD_TYPE = "ORDER"; $CONTACT_PERSON = $_REQUEST['cont_per']; $DELIVERY_DATE = $_REQUEST['del_date']; $ORDERED_FROM = "PORTAL"; $STATUS = "ENTRY";
<?php ob_start(); include '../classes/functions.php'; date_default_timezone_set("Asia/Kolkata"); $date4 = date('Y-m-d H:i:s'); $con = new functions(); $date = $con->get_datetime_html(); $date1 = date('Y-m-d\\T00:00:00', strtotime("-1 days")); session_start(); $entity_id = $_SESSION['entity_id']; //$query="SELECT consignment_details.consignment_id, consignment_details.cust_po_number, consignment_details.shipment_terms,consignment_details.commercial_invoice,consignment_details.port_of_discharge,consignment_details.item_description,consignment_details.ordered_quantity,consignment_details.order_quantity_uom, consignment_details.shipment_value,consignment_details.sailing_date,consignment_details.agent,consignment_details.require_date,consignment_details.remark,consignment_details.status, consignment_update.arrival_date FROM consignment_update INNER JOIN consignment_details ON consignment_update.consignment_id=consignment_details.consignment_id WHERE created_date between '".date('Y-m-d\ 00:00:00',strtotime("-1 days"))."' and '".date('Y-m-d H:i:s')."'"; $query = "SELECT * FROM consignment_details WHERE org_id in(" . $entity_id . ") and dispatch_date between '" . date('Y-m-d\\ 00:00:00', strtotime("-1 days")) . "' and '" . date('Y-m-d H:i:s') . "'"; $result = $con->data_select($query); //customer get in select box $query_user = ""; if ($entity_id == "") { $query_user = "******"; $result1 = $con->data_select($query_user); $customer_options = "<option value ='0'>Select Cutomer</option>"; foreach ($result1 as $key => $val) { $customer_options .= "<option value ='" . $result1[$key]['customer_num'] . "'>" . $result1[$key]['customer_num'] . "</option>"; } } else { $query_user = "******" . $entity_id . ")"; $result1 = $con->data_select($query_user); $customer_options = "<option value ='0'>Select Cutomer</option>"; foreach ($result1 as $key => $val) { $customer_options .= "<option value ='" . $result1[$key]['customer_num'] . "'>" . $result1[$key]['customer_num'] . "</option>"; } }
include "classes/functions.php"; $con = new functions(); $id = $_REQUEST['id']; if (isset($_POST['submit'])) { $id = $_POST['id']; $name = $_POST['name']; $phone = $_POST['phone']; $address = $_POST['address']; $email = $_POST['email']; $qryUpt = "UPDATE `customer_po` SET `name` = '{$name}', `phone` = '{$phone}', `address`='{$address}', `email`='{$email}' WHERE `sn`={$id}"; mysql_query($qryUpt) or die(mysql_error()); header("location:index.php"); } $qryMem = "SELECT * FROM `customer_po` WHERE `ID`='{$id}'"; $mem = $con->data_select($qryMem); ?> <form method="post" action="editdata.php" role="form"> <div class="modal-body"> <div class="form-group"> <label for="name">ID <input type="text" id="id" name="id" value="<?php echo $mem[0]['ID']; ?> " readonly="true"/> </label> </div> <div class="form-group"> <label for="name">Name <input type="text" id="name" name="name" value="<?php echo $mem[0]['PO_NUMBER'];
<?php include "classes/functions.php"; $con = new functions(); $id = $_REQUEST['id']; $qryMem = "SELECT * FROM `customer_po` WHERE `ID`='{$id}'"; $mem = $con->data_select($qryMem); $cust_id = $mem[0]['CUSTOMER_NUMBER']; //Fetching Sold_To droupdown values $sql_sold_to = "SELECT distinct SITE_USE_ID as ID, PRIMARY_FLAG,\n CONCAT_WS(',',ADDRESS1,ADDRESS2, ADDRESS3,ADDRESS4,CITY,COUNTRY) AS SHIP_ADDRESS \n FROM xxdkapps_customer_master WHERE BUSINESS_CODE ='BILL_TO'\n and CUSTOMER_NUMBER = " . $cust_id . "\n and ACCOUNT_STATUS='A'\n order by PRIMARY_FLAG DESC"; $result_sold_to = $con->data_select($sql_sold_to); //Fetching Ship_To droupdown values $sql_ship_to = "SELECT distinct SITE_USE_ID as ID, PRIMARY_FLAG,\n CONCAT_WS(',',ADDRESS1,ADDRESS2 , ADDRESS3,ADDRESS4,CITY, COUNTRY) AS SHIP_ADDRESS \n FROM xxdkapps_customer_master WHERE BUSINESS_CODE ='SHIP_TO'\n and CUSTOMER_NUMBER = " . $cust_id . "\n and ACCOUNT_STATUS='A'\n order by PRIMARY_FLAG DESC"; $result_ship_to = $con->data_select($sql_ship_to); //Fetching Payment Terms droupdown values $sql_payment_terms = "SELECT TERM_ID, DESCRIPTION FROM xxdkapps_payment_terms"; $result_payment_terms = $con->data_select($sql_payment_terms); ?> <form> <div class="modal-body"> <div class="row"> <div class="form-group col-xs-12 col-sm-12 col-md-6 col-lg-6"> <input type="hidden" id="po_id" value="<?php echo $id; ?> "/> <label for="admin_po_number">PO# Number : </label> <input type="text" id="admin_po_number" class="form-control" name="admin_po_number" value="<?php echo $mem[0]['PO_NUMBER']; ?> "/>
<?php ob_start(); include 'admin_sidebar_header.php'; include '../classes/functions.php'; $con = new functions(); date_default_timezone_set("Asia/Kolkata"); $date4 = date('Y-m-d H:i:s'); $query_tracking_url = "SELECT * FROM tracking_url WHERE id=1"; $result_tracking_url = $con->data_select($query_tracking_url); /*echo "<pre>"; print_r($result_tracking_url[0]['tracking_url']); exit;*/ ?> <!-- page content --> <div class="right_col" role="main"> <div class="clearfix"></div> <div class="row"> <div class="col-md-12 col-sm-12 col-xs-12"> <div class="row"> <div class="col-md-12"> <div class="x_panel"> <div class="x_title"> <h2>Tracking Url</h2> <div class="col-md-12"> <div class="x_panel"> <div class="col-md-12"> <form> <input type="text" value="<?php echo $result_tracking_url[0]['tracking_url'];
<?php include "classes/functions.php"; session_start(); $cust_id = $_SESSION['cust_id']; $con = new functions(); //Fetch Quations History $sql_quote = "SELECT cq.ID, cq.PRODUCT_CODE, cq.PACKAGING_SIZE, cq.QUANTITY, cq.FILE_NAME, cq.AVAILABLE_PRICE, cq.REQUESTED_PRICE, cq.REMARK, cq.FILE_NAME, cq.STATUS, up.DESCRIPTION FROM customer_quotations as cq, xxdkapps_unsegregated_products as up WHERE cq.PRODUCT_CODE = up.PRODUCT_CODE ORDER BY cq.ID DESC"; $result_quote_history = $con->data_select($sql_quote); if ($result_quote_history != "no") { $html_data = ""; ?> <div class="container table-responsive animated fadeIn quote-history-div"> <table id="cart_table" class="table table-bordered table-striped"> <thead> <tr class="headings"> <th>PRODUCT NAME</th> <th>AVAILABLE PRICE (PER KG)</th> <th>REQUESTED PRICE (PER KG)</th> <th>FILE_NAME</th> <th>STATUS</th> <th>Edit</th> </tr> </thead> <tbody id="quote_history_table"> <?php foreach ($result_quote_history as $key => $value) { $html_data .= '<tr class="item"> <td> ' . $value['DESCRIPTION'] . ' </td>
<?php ob_start(); include 'admin_sidebar_header.php'; include '../classes/functions.php'; session_start(); $con = new functions(); $user_name = $_SESSION['user_name']; if ($user_name != "") { $query = "SELECT user_registration.user_id, user_registration.first_name,user_registration.last_name,user_registration.user_name,user_registration.address,user_registration.type,user_registration.status, entity.entity_name\n\tFROM entity\n\tINNER JOIN user_registration\n\tON entity.entity_id=user_registration.entity_id;"; $result = $con->data_select($query); $query = "SELECT entity_id, entity_name FROM entity"; $result1 = $con->data_select($query); $options = ""; foreach ($result1 as $key => $val) { $options .= "<option value=" . $result1[$key]['entity_id'] . ">" . $result1[$key]['entity_name'] . "</option>"; } $query = "SELECT role_id, role_name FROM user_role"; $result_role = $con->data_select($query); $role_options = ""; $role_array = array(); foreach ($result_role as $key => $val) { $role_options .= "<option value=" . $result_role[$key]['role_id'] . ">" . $result_role[$key]['role_name'] . "</option>"; $role_array[$result_role[$key]['role_id']] = $result_role[$key]['role_name']; } } else { header('Location:admin_login.php'); } ?> <script type="text/javascript"> function showdocument(user_id)
<?php include 'classes/functions.php'; $con = new functions(); session_start(); if (isset($_POST['submit'])) { $user_name = $_POST['username']; $password = $_POST['password']; $qry = "SELECT * FROM user_registration WHERE email_id='{$user_name}' AND password='******'"; echo $qry; exit; $result = $con->data_select($qry); // echo $result[0]['role_id']; if ($result != "no") { if ($result[0]['role_id'] == 2) { $_SESSION['user_id'] = $result[0]['user_id']; $_SESSION['email_id'] = $user_name; $_SESSION['first_name'] = $result[0]['first_name']; $_SESSION['role_id'] = $result[0]['role_id']; $_SESSION['entity_id'] = $result[0]['entity_id']; header('Location: customer_dashboard.php'); } elseif ($result[0]['role_id'] == 4) { $_SESSION['user_id'] = $result[0]['user_id']; $_SESSION['email_id'] = $user_name; $_SESSION['role_id'] = $result[0]['role_id']; $_SESSION['first_name'] = $result[0]['first_name']; $_SESSION['entity_id'] = $result[0]['entity_id']; header('Location: user_dashboard.php'); } elseif ($result[0]['role_id'] == 3) { $_SESSION['user_id'] = $result[0]['user_id']; $_SESSION['email_id'] = $user_name;
<?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);
<?php //ob_start(); include '../classes/functions.php'; $con = new functions(); $_SESSION['success'] = "no"; $query = "SELECT * FROM org_map"; $result1 = $con->data_select($query); $options = ""; foreach ($result1 as $key => $val) { $options .= "<option value=" . $result1[$key]['org_id'] . ">" . $result1[$key]['name'] . "</option>"; } if (isset($_POST['add'])) { $user_name = $_POST['username']; $password = $_POST['password']; $first_name = $_POST['firstname']; $last_name = $_POST['lastname']; $address = $_POST['address']; $entity_id = $_POST['entity_id']; $role_user = $_POST['role_user']; $entity = implode(",", $entity_id); $sql = "INSERT INTO user_registration(first_name, last_name, email_id, password, address, role_id, entity_id)\n\t\t\t\t VALUES ('{$first_name}','{$last_name}','{$user_name}','{$password}','{$address}','{$role_user}','{$entity}')"; $result = $con->data_insert($sql); if ($result > 0) { $_SESSION['success'] = "Data has been Added!!!!!"; header('Location:create_user.php'); } else { $_SESSION['success'] = "no"; } } include 'admin_sidebar_header.php';
if (isset($_POST) && isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') { //Get page number from Ajax POST if (isset($_POST["page"])) { $page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH); //filter number if (!is_numeric($page_number)) { die('Invalid page number!'); } //incase of invalid page number } else { $page_number = 1; //if there's no page number, set it to 1 } if (isset($_REQUEST['search_category']) && $_REQUEST['search_category'] == "5") { $sql = "SELECT op.ORDER_ID, op.PRODUCT_CODE, op.PACKAGE_QTY, op.QUANTITY, op.UNIT_PRICE, op.OSTATUS, op.REMARKS, up.DESCRIPTION, ofd.ID, ofd.ORACLE_ORDER, ofd.ORDER_WEB_ID, (DATE_FORMAT( ofd.ORDER_DATE, '%d/%m/%Y' )) AS ORDER_DATE, ofd.CUSTOMER_NUMBER, ofd.PO, ofd.DELIVERY_DATE, ofd.CONTACT_PERSON, ofd.COMMENTS, ofd.FREIGHT_TERMS, ofd.VESSEL, ofd.ATTRIBUTE12, cm.SITE_USE_ID, CONCAT_WS(',',cm.ADDRESS1,cm.ADDRESS2, cm.ADDRESS3,cm.ADDRESS4,cm.CITY,cm.COUNTRY) AS SHIP_ADDRESS FROM order_form_details as ofd, order_products as op, xxdkapps_unsegregated_products as up, xxdkapps_customer_master as cm WHERE ofd.CUSTOMER_NUMBER= " . $cust_id . " and ofd.ORACLE_ORDER = " . $_REQUEST['search_value'] . " and op.PRODUCT_CODE = up.PRODUCT_CODE and op.ORDER_ID = ofd.ID and ofd.SHIP_TO = cm.SITE_USE_ID"; $result = $con->data_select($sql); $sql_sold_to = "SELECT distinct SITE_USE_ID as ID, PRIMARY_FLAG, CONCAT_WS(',',ADDRESS1,ADDRESS2, ADDRESS3,ADDRESS4,CITY,COUNTRY) AS SHIP_ADDRESS FROM xxdkapps_customer_master WHERE BUSINESS_CODE ='BILL_TO' and CUSTOMER_NUMBER = " . $cust_id . " and ACCOUNT_STATUS='A' order by PRIMARY_FLAG DESC"; $sold_to = $con->data_select($sql_sold_to); } else { if (isset($_REQUEST['search_category']) && $_REQUEST['search_category'] == "6") { $sql = "SELECT op.ORDER_ID, op.PRODUCT_CODE, op.PACKAGE_QTY, op.QUANTITY, op.UNIT_PRICE, op.OSTATUS, op.REMARKS, up.DESCRIPTION, ofd.ID, ofd.ORACLE_ORDER, ofd.ORDER_WEB_ID, (DATE_FORMAT( ofd.ORDER_DATE, '%d/%m/%Y' )) AS ORDER_DATE, ofd.CUSTOMER_NUMBER, ofd.PO, ofd.DELIVERY_DATE, ofd.CONTACT_PERSON, ofd.COMMENTS, ofd.FREIGHT_TERMS, ofd.VESSEL, ofd.ATTRIBUTE12, cm.SITE_USE_ID, CONCAT_WS(',',cm.ADDRESS1,cm.ADDRESS2, cm.ADDRESS3,cm.ADDRESS4,cm.CITY,cm.COUNTRY) AS SHIP_ADDRESS FROM order_form_details as ofd, order_products as op, xxdkapps_unsegregated_products as up, xxdkapps_customer_master as cm WHERE ofd.CUSTOMER_NUMBER= " . $cust_id . " and ofd.ORDER_WEB_ID = '" . $_REQUEST['search_value'] . "' and op.PRODUCT_CODE = up.PRODUCT_CODE and op.ORDER_ID = ofd.ID and ofd.SHIP_TO = cm.SITE_USE_ID"; $result = $con->data_select($sql); $sql_sold_to = "SELECT distinct SITE_USE_ID as ID, PRIMARY_FLAG, CONCAT_WS(',',ADDRESS1,ADDRESS2, ADDRESS3,ADDRESS4,CITY,COUNTRY) AS SHIP_ADDRESS FROM xxdkapps_customer_master WHERE BUSINESS_CODE ='BILL_TO' and CUSTOMER_NUMBER = " . $cust_id . " and ACCOUNT_STATUS='A' order by PRIMARY_FLAG DESC"; $sold_to = $con->data_select($sql_sold_to); } else { if (isset($_REQUEST['search_value']) && isset($_REQUEST['search_cat'])) { if ($_REQUEST['search_cat'] == 1) { $sql1 = "SELECT op.ORDER_ID FROM order_form_details as ofd, order_products as op, xxdkapps_unsegregated_products as up, xxdkapps_customer_master as cm WHERE ofd.CUSTOMER_NUMBER= " . $cust_id . " and op.PRODUCT_CODE = up.PRODUCT_CODE and op.ORDER_ID = ofd.ID and ofd.SHIP_TO = cm.SITE_USE_ID and op.PRODUCT_CODE LIKE '" . $_REQUEST['search_value'] . "%' ORDER BY ofd.ORDER_DATE DESC"; } else { if ($_REQUEST['search_cat'] == 2) { $sql1 = "SELECT op.ORDER_ID FROM order_form_details as ofd, order_products as op, xxdkapps_unsegregated_products as up, xxdkapps_customer_master as cm WHERE ofd.CUSTOMER_NUMBER= " . $cust_id . " and op.PRODUCT_CODE = up.PRODUCT_CODE and op.ORDER_ID = ofd.ID and ofd.SHIP_TO = cm.SITE_USE_ID and up.DESCRIPTION LIKE '" . $_REQUEST['search_value'] . "%' ORDER BY ofd.ORDER_DATE DESC";
<?php ob_start(); include '../classes/functions.php'; $con = new functions(); $con = new functions(); session_start(); $user_id = $_SESSION['user_id']; $first_name = $_SESSION['first_name']; if ($user_id != "") { $result = $con->data_select("SELECT assign_id, user_id, consignment_id, orign_location, destination_location, picup_date_time, status FROM assign_consignment WHERE user_id=" . $user_id); } include 'user_sidebar_header.php'; ?> <!-- page content --> <div class="right_col" role="main"> <div class=""> <div class="clearfix"></div> <div class="row"> <div class="col-md-12 col-sm-12 col-xs-12"> <div class="x_panel"> <div class="x_title"> <h2 style="color:#060;">Assign Container</h2> <div class="clearfix"></div>
include_once "../class/functions.php"; $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 {
<?php ob_start(); include '../classes/functions.php'; date_default_timezone_set("Asia/Kolkata"); $date4 = date('Y-m-d H:i:s'); $con = new functions(); session_start(); $date = $con->get_datetime_html(); $date1 = date('Y-m-d\\T00:00:00', strtotime("-1 days")); $customer_num = $_SESSION['cust_id']; //Get all existing Orders $query = "SELECT * FROM consignment_details WHERE customer_num=" . $customer_num; $result = $con->data_select($query); // Check count of orders for dashboard $query_booked = "SELECT count(order_status) from consignment_details WHERE order_status='BOOKED' and customer_num=" . $customer_num; $result_booked = $con->data_select($query_booked); $query_despatch = "SELECT count(order_status) from consignment_details WHERE order_status='DESPATCH' and customer_num=" . $customer_num; $result_despatch = $con->data_select($query_despatch); $query_closed = "SELECT count(order_status) from consignment_details WHERE order_status='CLOSED' and customer_num=" . $customer_num; $result_closed = $con->data_select($query_closed); $query_intransit = "SELECT count(order_status) from consignment_details WHERE order_status='IN TRANSIT' and customer_num=" . $customer_num; $result_intransit = $con->data_select($query_intransit); $query_outfor_delivery = "SELECT count(order_status) from consignment_details WHERE order_status='OUT FOR DELIVERY' and customer_num=" . $customer_num; $result_outfor_delivery = $con->data_select($query_outfor_delivery); $query_arrive_port = "SELECT count(order_status) from consignment_details WHERE order_status='ARRIVED AT PORT' and customer_num=" . $customer_num; $result_arive_port = $con->data_select($query_arrive_port); $query_custom = "SELECT count(order_status) from consignment_details WHERE order_status='UNDER CUSTOM ClEARENCE' and customer_num=" . $customer_num; $result_custom = $con->data_select($query_custom); ?> <!-- page content -->
<?php ob_start(); include '../classes/functions.php'; $con = new functions(); $result = $con->data_select("SELECT dispatch_id, transaction_number, start_address, destination, status FROM dspatch_details"); include 'user_sidebar_header.php'; ?> <script> function selectDispatch(dispatchId) { $.ajax({ type:"POST", url:"logistics/action_ajax.php", data:"dispatch_id="+dispatchId+"&action=selectDispatch", dataType:"JSON", success: function(data) { //alert(data[0].dispatch_id); if(data == "no record found") { alert("no record found"); } $("#dispatchId").val(data[0].dispatch_id); /*$("#firstname1").val(data[0].First_name); $("#mobile1").val(data[0].Mobile); $("#age1").val(data[0].Age); $("#cliniclocation").val(data[0].Clinic_location);*/
<?php include '../class/functions.php'; $con = new functions(); //session_start(); $date = $con->get_datetime(); $sql = "SELECT `title`,`start`,`end` FROM `calender_events` WHERE `status` = 1"; $data = $con->data_select($sql); echo json_encode($data); //print_r($data ); exit;
<?php include "classes/functions.php"; session_start(); $cust_id = $_SESSION['cust_id']; $con = new functions(); //Fetching Sold_To droupdown values $sql_sold_to = "SELECT distinct SITE_USE_ID as ID, PRIMARY_FLAG,\n\t\t CONCAT_WS(',',ADDRESS1,ADDRESS2, ADDRESS3,ADDRESS4,CITY,COUNTRY) AS SHIP_ADDRESS\t\t \n\t\t FROM xxdkapps_customer_master WHERE BUSINESS_CODE ='BILL_TO'\n\t\t and CUSTOMER_NUMBER = " . $cust_id . "\n\t\t and ACCOUNT_STATUS='A'\n\t\t order by PRIMARY_FLAG DESC"; $result_sold_to = $con->data_select($sql_sold_to); //Fetching Ship_To droupdown values $sql_ship_to = "SELECT distinct SITE_USE_ID as ID, PRIMARY_FLAG,\n\t\t CONCAT_WS(',',ADDRESS1,ADDRESS2 , ADDRESS3,ADDRESS4,CITY, COUNTRY) AS SHIP_ADDRESS\t\t \n\t\t FROM xxdkapps_customer_master WHERE BUSINESS_CODE ='SHIP_TO'\n\t\t and CUSTOMER_NUMBER = " . $cust_id . "\n\t\t and ACCOUNT_STATUS='A'\n\t\t order by PRIMARY_FLAG DESC"; $result_ship_to = $con->data_select($sql_ship_to); //Fetching Payment Terms droupdown values $sql_payment_terms = "SELECT TERM_ID, DESCRIPTION FROM xxdkapps_payment_terms"; $result_payment_terms = $con->data_select($sql_payment_terms); //Fetch Cart Products $sql_prod = "SELECT up.ID, up.PRODUCT_CODE AS ITEM_CODE, up.DESCRIPTION, up.ATTRIBUTE18 as PRODUCT_APPLICATION, up.ATTRIBUTE17 as PRODUCT_GROUP, cc.CUSTOMER_NUMBER, cc.QUANTITY, cc.PACKAGING_SIZE, cc.AVAILABLE_PRICE, cc.REMARK FROM customer_cart as cc, xxdkapps_unsegregated_products as up WHERE cc.CUSTOMER_NUMBER= '" . $_SESSION['cust_id'] . "' and cc.PRODUCT_CODE = up.PRODUCT_CODE"; $result_prod = $con->data_select($sql_prod); ?> <div class="container"> <div class="col-md-6 col-xs-6 col-lg-6 col-sm-6 animated fadeInUp"> <form id="checkout_data"> <div class="form-group"> <label for="PO_number">#PO<sup class="required_field">*</sup> : </label> <input class="form-control" type="text" name="PO_number" id="PO_number" placeholder="#PO" required> </div> <div class="form-group"> <label for="sold_to">Sold To<sup class="required_field">*</sup> : </label> <select class="form-control" id="sold_to"> <option value="0">Choose One</option>
<?php error_reporting(E_ALL); ini_set('display_errors', 'On'); include '../classes/functions.php'; $con = new functions(); //$getdata_mysql="SELECT id, DELIVERY_DETAIL_ID FROM logistic_view ORDER BY id ASC LIMIT 1"; $getdata_mysql = "SELECT * FROM logistic_view WHERE DELIVERY_DETAIL_ID = ( SELECT MAX( DELIVERY_DETAIL_ID ) \nFROM logistic_view )"; $result_mysql = $con->data_select($getdata_mysql); //$logistic_view_data= array(); if ($result_mysql != 'no') { $DELIVERY_DETAIL_ID = $result_mysql[0]['DELIVERY_DETAIL_ID']; $conn = oci_connect('apps', 'apps', '172.25.25.112:1531/TEST'); if (!$conn) { $e = oci_error(); trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR); } $stid3 = oci_parse($conn, "SELECT CUST_PO_NUMBER,CUSTOMER_NUM,FREIGHT_TERMS_CODE,ORG_ID,TO_CHAR(\n\t\tREQUIRE_DATE_DESTINATION,'YYYY-MM-DD:HH24:MI:SS') as REQUIRE_DATE_DESTINATION,\n\t SHIPPED_QUANTITY,DELIVERY_ID,DESCRIPTION,INVOICE_NUMBER,PORT_OF_DISCHARGE,SHIPPING_STATUS,\n\t SHIPPING_VALUE_INR,ORDER_STATUS, \n\t DELIVERY_DETAIL_ID,\n\t TO_CHAR(HEADER_LUD,'YYYY-MM-DD:HH24:MI:SS') as HEADER_LUD,\n\t TO_CHAR(LINE_LUD,'YYYY-MM-DD:HH24:MI:SS') as LINE_LUD,\n\t TO_CHAR(WSH_LUD,'YYYY-MM-DD:HH24:MI:SS') as WSH_LUD,\n\t TO_CHAR(WDD_LUD,'YYYY-MM-DD:HH24:MI:SS') as WDD_LUD ,\n\t TO_CHAR(WND_LUD,'YYYY-MM-DD:HH24:MI:SS') as WND_LUD , \n\t TO_CHAR(EMP_LUD,'YYYY-MM-DD:HH24:MI:SS') as EMP_LUD,\n\t TO_CHAR(EML_LUD,'YYYY-MM-DD:HH24:MI:SS') as EML_LUD,\n\t TO_CHAR(JAI_LUD,'YYYY-MM-DD:HH24:MI:SS') as JAI_LUD,\n\t REF_INV,SHIPPING_VALUE,CURRENCY,TO_CHAR(DISPATCH_DATE,'YYYY-MM-DD:HH24:MI:SS') as DISPATCH_DATE\n\t FROM xxdk_order_ems_portal WHERE DELIVERY_DETAIL_ID > '" . $result_mysql[0]['DELIVERY_DETAIL_ID'] . "'"); $r = oci_execute($stid3); $data = array(); $i = 0; while ($row = oci_fetch_assoc($stid3)) { $data[$i] = $row; $i++; } /*echo "<pre>"; print_r($data); exit;*/ foreach ($data as $key => $value) { $order_status = ""; if ($data[$key]['ORDER_STATUS'] == "CLOSED") {
foreach ($group as $key => $value) { if ($group[$key]['name'] != "") { $options .= "<option value='" . $group[$key]['mail'] . "-" . $group[$key]['user_name'] . "'>" . $group[$key]['name'] . "</option>"; } } //echo "<pre>"; //$group = array_unique($group); // print_r($options); //echo json_encode($group); } else { echo "LDAP bind failed..."; } } ldap_close($ldapconn); $query = "SELECT * FROM user_registration"; $result = $con->data_select($query); $query1 = "SELECT * FROM org_map"; $result2 = $con->data_select($query1); /*echo"<pre>"; print_r($result2); exit;*/ $entity = ""; foreach ($result2 as $key => $value) { $entity .= "<input type='checkbox' id='entities' name='entities[]' value='" . $result2[$key]['org_id'] . "'/> " . $result2[$key]['name'] . "<br>"; } ?> <!-- page content --> <div class="right_col" role="main">
<?php include "classes/functions.php"; include "classes/paginate_function.php"; session_start(); $con = new functions(); $cust_id = $_SESSION['cust_id']; /******** Global Search Query ***********/ if (isset($_REQUEST['search_category']) && $_REQUEST['search_category'] == "1") { $sql = "SELECT DISTINCT PRODUCT_CODE,DESCRIPTION FROM xxdkapps_unsegregated_products WHERE PRODUCT_CODE LIKE '" . $_REQUEST['auto_search_value'] . "%' order by PRODUCT_CODE"; $result = $con->data_select($sql); $data = array(); if ($result == 'no') { array_push($data, 'No Data'); echo json_encode($data); } else { echo json_encode($result); } exit; } if (isset($_REQUEST['search_category']) && $_REQUEST['search_category'] == "2") { $sql = "SELECT DISTINCT DESCRIPTION FROM xxdkapps_unsegregated_products WHERE DESCRIPTION LIKE '" . $_REQUEST['auto_search_value'] . "%' order by DESCRIPTION"; $result = $con->data_select($sql); $data = array(); if ($result == 'no') { array_push($data, 'No Data'); } else { foreach ($result as $key => $value) { array_push($data, $result[$key]['DESCRIPTION']); } }
<?php include "./classes/functions.php"; $con = new functions(); session_start(); if (isset($_REQUEST['action']) && $_REQUEST['action'] == "Login") { $sql = "SELECT * FROM login_master WHERE CUSTOMER_NUMBER = " . $_REQUEST['cust_id'] . " AND PASSWORD = '******'cust_pass']) . "'"; $result = $con->data_select($sql); if ($result != "no") { $sql_query = "SELECT * FROM user_registration WHERE email_id='" . $_REQUEST['cust_id'] . "'"; $result1 = $con->data_select($sql_query); if ($_REQUEST['cust_id'] != 1111) { if ($result1 != "no") { $_SESSION["entity_id"] = $result1[0]['entity_id']; } } $_SESSION["role_id"] = $result1[0]['role_id']; $_SESSION["cust_id"] = $_REQUEST['cust_id']; $_SESSION["cust_email"] = $result[0]['EMAIL']; echo "Success"; } else { 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'];
<?php include "classes/functions.php"; session_start(); $cust_id = $_SESSION['cust_id']; $con = new functions(); $sql_PO = "SELECT cp.ID, cp.PO_NUMBER, cp.SHIP_TO, cp.SOLD_TO, cp.CONTACT_PERSON, cp.DELIVERY_DATE, cp.FREIGHT_TERM, cp.FREIGHT_CHARGES, cp.VESSAL_NAME, cp.PAYMENT_TERM, cp.FILE_NAME, cp.COMMENT, cp.STATUS, CONCAT_WS(',',cm.ADDRESS1,cm.ADDRESS2 , cm.ADDRESS3,cm.ADDRESS4,cm.CITY, cm.COUNTRY) AS SHIP_ADDRESS FROM customer_po as cp, xxdkapps_customer_master as cm WHERE cp.SHIP_TO = cm.SITE_USE_ID and cm.BUSINESS_CODE = 'SHIP_TO' ORDER BY cp.ID DESC"; $result_po_history = $con->data_select($sql_PO); if ($result_po_history != "no") { $html_data = ""; ?> <div class="container table-responsive animated bounceInRight po-history-div"> <table id="cart_table" class="table table-bordered table-striped"> <thead> <tr class="headings"> <th>PO# NUMBER</th> <th>SHIP ADDRESS</th> <th>FILE</th> <th>COMMENT</th> <th>STATUS</th> <th>ACTION</th> </tr> </thead> <tbody id="po_history_table"> <?php foreach ($result_po_history as $key => $value) { $html_data .= '<tr class="item"> <td>' . $value['PO_NUMBER'] . '</td> <td>' . $value['SHIP_ADDRESS'] . '</td> <td><a href="uploadedPO/' . $value['FILE_NAME'] . '" target="_blank">' . $value['FILE_NAME'] . '</a></td> <td>' . $value['COMMENT'] . '</td>