<?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>
