Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_errors', 1);
- ini_set('display_startup_errors', 1);
- error_reporting(E_ALL);
- //mysqli_report(MYSQLI_REPORT_ALL & ~MYSQLI_REPORT_INDEX);
- require_once("dbcontroller.php");
- $db_handle = new DBController();
- if (isset($_GET['pageno'])) {
- $pageno = $_GET['pageno'];
- } else {
- $pageno = 1;
- }
- $mysqli = new mysqli('localhost', 'root', '', '');
- $connect = mysqli_connect('localhost', 'root', '', '');
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <title>Main Order Details</title>
- <link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon"/>
- <link rel="icon" href="images/favicon.ico" type="image/x-icon"/>
- <link href="SpryAssets/style.css" rel="stylesheet" type="text/css" />
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
- <link href="SpryAssets/Tab.css" rel="stylesheet" type="text/css" />
- <script src="SpryAssets/jquery-2.1.1.min.js" type="text/javascript"></script>
- <script src="SpryAssets/jquery-ui.min.js"></script>
- <link href="SpryAssets/jquery.dataTables.min.css" rel="stylesheet" type="text/css" />
- <link rel="shortcut icon" href="images/2DO_1.png" type="image/x-icon">
- <link href="SpryAssets/jquery-ui.css" rel="stylesheet" type="text/css" />
- </head>
- <body>
- <div id="wrapper">
- <?php include "Header.php";?>
- <?php
- $sqluser = "SELECT * from admin_master where UserName!='".$loginuser."' AND TYPE !=0" ;
- $userresult = $db_handle->runSelectQuery($sqluser);
- //print_r($userresult);die;
- $numrowsuser =count($userresult);
- ?>
- <div id="ordercontent">
- <div class="tab" >
- <button><a href = "dashboard.php">Orders</a></button>
- <button><a href = "delivered.php">Delivered</a></button>
- <button><a href = "cancelled.php">Cancel</a></button>
- <button><a href = "ecallpage.php">ECall</a></button>
- <button><a href = "edcallpage.php">EDCall</a></button>
- <button class="tablinks active" onclick="openTab(event, 'LeadManager')" id="<?php if($logintype=='0'){echo"defaultOpen";}?>"><a href = "sentpage.php">Sent</a></button>
- <button><a href = "holdpage.php">Hold</a></button>
- <button><a href = "search.php">Search</a></button>
- </div>
- <!-- Tab content -->
- <div id="AllTeam" >
- <?php if($logintype=="2" && ($userdepart=="1" || $userdepart=="2" || $userdepart=="3" || $userdepart=="4")){?>
- <input type="text" name="tag" id="focus" placeholder="Use handheld RFID scanner"/>
- <?php }?>
- </div>
- <div id="LeadManager" class="tabcontent">
- <h3><?php echo $usertype;?></h3>
- <input type="hidden" name="orderids" id="orderids" value=""/>
- <?php if($logintype!="2"){?>
- <!-- Import Order -->
- <div class="importorder">
- <form name="importorderform" id="importorderform" method="post" enctype="multipart/form-data" action="importOrder.php" >
- </form>
- </div>
- <div style="clear:both;"></div>
- <?PHP }?>
- <div style="clear:both;"></div>
- <!-- order per page -->
- <!-- order per page end-->
- <div style="clear:both;"></div>
- <?php
- $userToSearch='';
- $searchValue='';
- $ordercheckall='';
- $rowNumber="";
- // if(isset($_GET['searchOrder']) && $_GET['searchOrder']!='')
- if(isset($_GET['searchOrder']) && $_GET['searchOrder']!='')
- {
- $searchValue=$_GET['searchOrder'];
- //if($_POST['searchOrder']=='all'){$loginuser='';}
- if($logintype==2)
- {
- if($_GET['searchOrder']=='all'){
- $userToSearch = "WHERE (conformed_by LIKE '%".$loginuser."%' OR conformed_by IS NULL) AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- else if($_GET['searchOrder']=='assigned'){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- else if($_GET['searchOrder']=="unassigned"){
- $userToSearch = "WHERE conformed_by IS NULL AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- else if($_GET['searchOrder']=='hold'){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND status='Hold'";
- }
- else if($_GET['searchOrder']=='cancel'){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND status='Canceled'";
- }
- else if($_GET['searchOrder']=="PPD"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND payment_type NOT IN ('Cash on delivery')";
- }
- else if($_GET['searchOrder']=="COD"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND payment_type IN ('Cash on delivery')";
- }
- else if($_GET['searchOrder']=="Wholesale"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND customer_group=2";
- }
- else if($_GET['searchOrder']=="Local"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND customer_group!=2 AND store_id=1";
- }
- else if($_GET['searchOrder']=="Foreign"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND store_id=2";
- }
- else if($_GET['searchOrder']=="High"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND priority LIKE '%High%'";
- }
- else if($_GET['searchOrder']=="Medium"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND priority LIKE '%Medium%'";
- }
- else if($_GET['searchOrder']=="Low"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND priority LIKE '%Low%'";
- }
- else
- {
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- }
- else
- {
- if($_GET['searchOrder']=='all'){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- else if($_GET['searchOrder']=='assigned'){
- $userToSearch = "WHERE (conformed_by IS NOT NULL OR conformed_by!='') AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- else if($_GET['searchOrder']=="unassigned"){
- $userToSearch = "WHERE conformed_by IS NULL AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- else if($_GET['searchOrder']=='hold'){
- $userToSearch = "WHERE (conformed_by IS NOT NULL OR conformed_by!='') AND status='Hold'";
- }
- else if($_GET['searchOrder']=='cancel'){
- $userToSearch = "WHERE (conformed_by IS NOT NULL OR conformed_by!='') AND status='Canceled'";
- }
- else if($_GET['searchOrder']=="PPD"){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND payment_type NOT IN ('Cash on delivery')";
- }
- else if($_GET['searchOrder']=="COD"){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND payment_type IN ('Cash on delivery')";
- }
- else if($_GET['searchOrder']=="Wholesale"){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND customer_group=2";
- }
- else if($_GET['searchOrder']=="Local"){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND customer_group!=2 AND store_id=1";
- }
- else if($_GET['searchOrder']=="Foreign"){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND store_id=2";
- }
- else if($_GET['searchOrder']=="High"){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND priority LIKE '%High%'";
- }
- else if($_GET['searchOrder']=="Medium"){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND priority LIKE '%Medium%'";
- }
- else if($_GET['searchOrder']=="Low"){
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND priority LIKE '%Low%'";
- }
- else
- {
- $userToSearch = "WHERE conformed_by LIKE '%".$_GET['searchOrder']."%' AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- }
- }
- else if(isset($_POST['orderbyid']) && $_POST['orderbyid']!='')
- {
- $userToSearch = "WHERE order_id in (".$_POST['orderbyid'].")";
- }
- else
- {
- if($logintype==2 && $userdepart==0)
- {
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND (status!='Conformed' AND status!='Hold' AND status!='Canceled')";
- }
- else
- {
- $userToSearch = "WHERE (conformed_by LIKE '%%' OR conformed_by IS NULL) AND status NOT IN ('Conformed','Hold','Canceled')";
- }
- }
- // Display table rows
- $sqlresultdoorder = "SELECT * from do_order";
- $resultdoorder = $db_handle->runSelectQuery($sqlresultdoorder);
- $numrows =count($resultdoorder);
- //$counter = --$numrows;
- $rows_per_page = 100000;
- $lastpage= ceil($numrows/$rows_per_page);
- $pageno = (int)$pageno;
- if ($pageno > $lastpage) {
- $pageno = $lastpage;
- } // if
- if ($pageno < 1) {
- $pageno = 1;
- }
- $limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
- $sqlresult = "SELECT * from do_order ORDER BY id DESC ".$limit;
- $orderrecords = $db_handle->runSelectQuery($sqlresult);
- // Display table rows end
- // date search
- $query = "SELECT * FROM do_order ORDER BY order_id desc";
- $result = mysqli_query($connect, $query);
- //date search end
- ?>
- <div class="col-md-3">
- <input type="text" name="from_date" id="from_date" class="form-control" placeholder="From Date" />
- </div>
- <div class="col-md-3">
- <input type="text" name="to_date" id="to_date" class="form-control" placeholder="To Date" />
- </div>
- <div class="col-md-5">
- <input type="button" name="filter" id="filter" value="Filter" class="btn btn-info" />
- </div>
- <div style="clear:both"></div>
- <br />
- <!--
- <div class="serchorderbyid">
- <form name="serchorderbyidform" id="serchorderbyidform" method="post" enctype="multipart/form-data" action="" >
- Order ID (101,102,103): <input type="text" name="orderbyid" id="orderbyid" value=""/>
- <input type="button" class="ajax-assign-button" id="OrderById" value="OrderById" onclick="searchorderbyid()"/>
- <a href="dashboard2.php"><input type="button" class="ajax-assign-button" id="resetFilter" value="Reset"/></a>
- </form>
- </div>
- -->
- <?php
- $tabindex=1;
- ?>
- <?php
- ?>
- <!-- export -->
- <div class="serchorderbyid">
- <form name="serchorderbyidform" id="serchorderbyidform" method="post" enctype="multipart/form-data" action="" >
- <input type="button" class="ajax-assign-button" id="csvfile" value="Export" onclick="exportorders();" />
- <button type= "button" id="show_status" class="ajax-assign-button">Show Status</button>
- <button type= "button" id="cancel" class="ajax-assign-button">Cancel</button>
- <button type= "button" id="orderstab" class="ajax-assign-button">Orderstab</button>
- </form>
- </div>
- <!-- export -->
- <br/>
- <div id="order_table">
- <table class="tbl-qa" border="1" id="content-table">
- <thead>
- <tr>
- <th></th>
- <th class="table-header">AWB</th>
- <th class="table-header">ORDERID</th>
- <th class="table-header">Sent</th>
- <th class="table-header">Last Update Date</th>
- <th class="table-header">Attempted</th>
- <th class="table-header"><div style="width: 50px" >
- <select id="my_select" onchange="send_option();">
- <option value="all">Status</option>
- <?php
- $query = "SELECT DISTINCT in_transit FROM do_order";
- $result = mysqli_query ($mysqli, $query);
- while ( $row = mysqli_fetch_array($result) )
- echo "<option value='" . $row['in_transit'] . "'>" . $row['in_transit'] . "</option>";
- ?>
- </select>
- </div></th>
- <th class="table-header">
- <select id="my_select1" onchange="send_option();">
- <option value="all">Tracking Status</option>
- <?php
- $query = "SELECT DISTINCT tracking FROM do_order";
- $result = mysqli_query ($mysqli, $query);
- while ( $row = mysqli_fetch_array($result) )
- echo "<option value='" . $row['tracking'] . "'>" . $row['tracking'] . "</option>";
- ?>
- </select>
- </th>
- <th class="table-header">
- <select id="my_select3" onchange="send_option();">
- <option value="all">Reason code</option>
- <?php
- $query = "SELECT DISTINCT reason1 FROM do_order";
- $result = mysqli_query ($mysqli, $query);
- while ( $row = mysqli_fetch_array($result) )
- echo "<option value='" . $row['reason1'] . "'>" . $row['reason1'] . "</option>";
- ?>
- </select>
- </th>
- <th class="table-header">
- <select id="my_select2" onchange="send_option();">
- <option value="all">NOA</option>
- <?php
- $query = "SELECT DISTINCT no_of_attempts FROM do_order";
- $result = mysqli_query ($mysqli, $query);
- while ( $row = mysqli_fetch_array($result) )
- echo "<option value='" . $row['no_of_attempts'] . "'>" . $row['no_of_attempts'] . "</option>";
- ?>
- </select>
- </th>
- <th class="table-header">My Name</th>
- <th class="table-header">Final comments</th>
- <th class="table-header">Consignee</th>
- <th class="table-header">Uploaded</th>
- <th class="table-header">Updated</th>
- <th class="table-header">tab</th>
- <th class="table-header">Telecomments</th>
- </tr>
- </thead>
- <tbody id="table-body">
- <?php
- $theBigQuery = "SELECT * FROM do_order WHERE 1";
- if (isset($_POST['my_option']) && $_POST['my_option'] != ""){
- if($_POST['my_option'] == "all"){
- } else {
- $theBigQuery .= " AND in_transit like '" . $_POST["my_option"] . "'";
- }
- echo "<script type='text/javascript'>function changeOption(){document.getElementById('my_select').value='".$_POST['my_option']."';} changeOption();</script>";
- }
- if (isset($_POST['my_option1']) && $_POST['my_option1'] != ""){
- if($_POST['my_option1'] == "all"){
- } else {
- $theBigQuery .= " AND tracking like '" . $_POST["my_option1"] . "'";
- }
- echo "<script type='text/javascript'>function changeOption1(){document.getElementById('my_select1').value='".$_POST['my_option1']."';} changeOption1();</script>";
- }
- if (isset($_POST['my_option2']) && $_POST['my_option2'] != ""){
- if($_POST['my_option2'] == "all"){
- } else {
- $theBigQuery .= " AND no_of_attempts like '" . $_POST["my_option2"] . "'";
- }
- echo "<script type='text/javascript'>function changeOption2(){document.getElementById('my_select2').value='".$_POST['my_option2']."';} changeOption2();</script>";
- }
- if (isset($_POST['my_option3']) && $_POST['my_option3'] != ""){
- if($_POST['my_option3'] == "all"){
- } else {
- $theBigQuery .= " AND reason1 like '" . $_POST["my_option3"] . "'";
- }
- echo "<script type='text/javascript'>function changeOption3(){document.getElementById('my_select3').value='".$_POST['my_option3']."';} changeOption3();</script>";
- }
- $theBigQuery .= " ORDER BY id DESC";
- $orderrecords = $db_handle->runSelectQuery($theBigQuery);
- if(!empty($orderrecords))
- {
- foreach($orderrecords as $k=>$v)
- {
- $hide='';
- if ($v['in_transit'] == "Delivered / Closed")
- {
- $hide .= 'style="display: none;"';
- }
- if ($v['reattempt']!== "sent" || $v['reattempt']="")
- {
- $hide .= 'style="display: none;"';
- }
- ?>
- <tr <?php echo $hide;?> class="table-row" id="table-row-<?php echo $orderrecords[$k]["id"]; ?>" tabindex="<?php echo $tabindex;?>">
- <td> <input type="checkbox" id="assigneeid-<?php echo $orderrecords[$k]["tracking_id"]; ?>" onclick="assignorderids('<?php echo $orderrecords[$k]["tracking_id"]; ?>')" name="checkassigneeid" class="assigneeid-order" value="<?php echo $orderrecords[$k]["tracking_id"]; ?>"> </td>
- <td><?php echo $orderrecords[$k]["tracking_id"]; ?></td>
- <td><?php echo $orderrecords[$k]["order_id"]; ?></td>
- <td><?php echo $orderrecords[$k]["sent_date"]; ?></td>
- <td id="<?php echo $orderrecords[$k]["tracking_id"];?>lud">
- <?php echo $orderrecords[$k]["lud"]; ?>
- </td>
- <td>
- <?php
- $orderrecords[$k]["sent_date"]= strtotime($orderrecords[$k]["sent_date"]);
- $orderrecords[$k]["lud"]= strtotime($orderrecords[$k]["lud"]);
- if ($orderrecords[$k]["lud"] < $orderrecords[$k]["sent_date"])
- {
- $sqlecom = 'UPDATE table SET attempted = "attempted"
- WHERE id = ' . $orderrecords[$k]['id'];
- $db_handleecom = new DBController();
- $resultecom = $db_handleecom->executeUpdate($sqlecom);
- //echo "attempted";
- }
- echo $orderrecords[$k]["attempted"];
- ?>
- </td>
- <td id="<?php echo $orderrecords[$k]["tracking_id"];?>">
- <?php echo $orderrecords[$k]["in_transit"]; ?>
- </td>
- <td id="<?php echo $orderrecords[$k]["tracking_id"];?>tracking">
- <?php echo $orderrecords[$k]["tracking"]; ?>
- </td>
- <td id="<?php echo $orderrecords[$k]["tracking_id"];?>reason1">
- <?php echo $orderrecords[$k]["reason1"]; ?>
- </td>
- <td class="id"><?php echo $orderrecords[$k]["no_of_attempts"]; ?></td>
- <td <?php if($userdepart==0 ){?>contenteditable="true" onBlur="saveToDatabase(this,'name','<?php echo $orderrecords[$k]["id"]; ?>')"<?php }?>><?php echo substr($orderrecords[$k]["name"],0,75); ?></td>
- <td <?php if($userdepart==0 ){?>contenteditable="true" onBlur="saveToDatabase(this,'comments','<?php echo $orderrecords[$k]["id"]; ?>')"<?php }?>><?php echo substr($orderrecords[$k]["comments"],0,99999); ?></td>
- <td><?php echo $orderrecords[$k]["consignee"]; ?></td>
- <td><?php echo $orderrecords[$k]["uploaded_date"]; ?></td>
- <td><?php echo $orderrecords[$k]["updated_date"]; ?></td>
- <td><?php echo $orderrecords[$k]["reattempt"]; ?></td>
- <td><?php echo $orderrecords[$k]["telecomments"]; ?></td>
- </tr>
- <?php
- $tabindex++;
- }
- }?>
- </tbody>
- </table>
- </div>
- <form method="post" action"dashboard.php" style="display:none" id="my_form">
- <input type="text" id="my_option" name="my_option"/>
- <input type="text" id="my_option1" name="my_option1"/>
- <input type="text" id="my_option2" name="my_option2"/>
- <input type="text" id="my_option3" name="my_option3"/>
- </form>
- <input type="hidden" name="ordercheckallIDs" id="ordercheckallIDs" value="<?php echo $ordercheckall;?>"/>
- <div class="pagination">
- <?php
- $sordersearch='';
- if($searchValue!='')
- {
- $sordersearch="&searchOrder=".$searchValue;
- }
- ?>
- <?php if ($pageno == 1) {
- echo " <span class='firstspan'>FIRST</span>";
- } else {
- echo " <span class='firstpage'><a href='{$_SERVER['PHP_SELF']}?pageno=1&limitperpage=$rows_per_page$sordersearch'>FIRST</a></span> ";
- $prevpage = $pageno-1;
- echo " <span class='prvpage'><a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage&limitperpage=$rows_per_page$sordersearch'>PREV</a></span> ";
- }
- if ($pageno == $lastpage) {
- echo " <span class='nextlastpage'>LAST</span> ";
- } else {
- $nextpage = $pageno+1;
- echo " <span class='nextpage'><a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage&limitperpage=$rows_per_page$sordersearch'>NEXT</a></span> ";
- echo " <span class='lastpage'><a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage&limitperpage=$rows_per_page$sordersearch'>LAST</a></span> ";
- }
- echo " ( Page $pageno of $lastpage ) ";
- ?>
- </div>
- </div>
- </div>
- <div style="clear:both;"></div>
- <?php include "Footer.php"; ?>
- </div>
- <script type="text/javascript">
- // Date search
- $(document).ready(function(){
- $.datepicker.setDefaults({
- dateFormat: 'yy-mm-dd'
- });
- $(function(){
- $("#from_date").datepicker();
- $("#to_date").datepicker();
- });
- $('#filter').click(function(){
- var from_date = $('#from_date').val();
- var to_date = $('#to_date').val();
- if(from_date != '' && to_date != '')
- {
- $.ajax({
- url:"filter.php",
- method:"POST",
- data:{from_date:from_date, to_date:to_date},
- success:function(data)
- {
- $('#order_table').html(data);
- }
- });
- }
- else
- {
- alert("Please Select Date");
- }
- });
- });
- // date search end
- //document.getElementById("defaultOpen").click();
- function openTab(evt,tabname)
- {
- // Declare all variables
- var i, tabcontent, tablinks;
- // Get all elements with class="tabcontent" and hide them
- tabcontent = document.getElementsByClassName("tabcontent");
- for (i = 0; i < tabcontent.length; i++) {
- tabcontent[i].style.display = "none";
- }
- // Get all elements with class="tablinks" and remove the class "active"
- tablinks = document.getElementsByClassName("tablinks");
- for (i = 0; i < tablinks.length; i++) {
- tablinks[i].className = tablinks[i].className.replace(" active", "");
- }
- // Show the current tab, and add an "active" class to the button that opened the tab
- document.getElementById(tabname).style.display = "block";
- evt.currentTarget.className += " active";
- }
- function assignallorderids()
- {
- var checkstatus=$("#checkall").is(":checked");
- if(checkstatus==true)
- {
- var id=document.getElementById("ordercheckallIDs").value;
- document.getElementById("orderids").value=id;
- $("input:checkbox[name='checkassigneeid']").prop('checked',true);
- }
- else
- {
- $("input:checkbox[name='checkassigneeid']").prop('checked',false);
- document.getElementById("orderids").value='';
- }
- }
- function assignorderids(oid)
- {
- var checkstatus=$("#assigneeid-"+oid).is(":checked");
- var morderId =document.getElementById("orderids").value;
- if(checkstatus==false)
- {
- var arrayorder = JSON.parse("[" + morderId + "]");
- document.getElementById("orderids").value='';
- for (var i = 0; i < arrayorder.length; i++) {
- var orderstatusValue=arrayorder[i];
- if(orderstatusValue!=oid){
- if (document.getElementById("orderids").value=='')
- {
- document.getElementById("orderids").value=orderstatusValue;
- }
- else
- {
- var newvalue=document.getElementById("orderids").value;
- document.getElementById("orderids").value=newvalue+","+orderstatusValue;
- }
- }
- }
- }
- else
- {
- if(morderId=='')
- {
- document.getElementById("orderids").value=oid;
- }
- else
- {
- document.getElementById("orderids").value=morderId+","+oid;
- }
- }
- }
- function graphicsorderids(goid)
- {
- var checkstatus=$("#gorderid-"+goid).is(":checked");
- var gmorderId =document.getElementById("gorderids").value;
- if(checkstatus==false)
- {
- var garrayorder = JSON.parse("[" + gmorderId + "]");
- document.getElementById("gorderids").value='';
- for (var i = 0; i < garrayorder.length; i++) {
- var gorderstatusValue=garrayorder[i];
- if(gorderstatusValue!=goid){
- if (document.getElementById("gorderids").value=='')
- {
- document.getElementById("gorderids").value=gorderstatusValue;
- }
- else
- {
- var gnewvalue=document.getElementById("gorderids").value;
- document.getElementById("gorderids").value=gnewvalue+","+gorderstatusValue;
- }
- }
- }
- }
- else
- {
- if(gmorderId=='')
- {
- document.getElementById("gorderids").value=goid;
- }
- else
- {
- document.getElementById("gorderids").value=gmorderId+","+goid;
- }
- }
- }
- function packingsids(pacoid)
- {
- var checkstatus=$("#pacorderid-"+pacoid).is(":checked");
- var pacmorderId =document.getElementById("pacorderids").value;
- if(checkstatus==false)
- {
- var pacarrayorder = JSON.parse("[" + pacmorderId + "]");
- document.getElementById("pacorderids").value='';
- for (var i = 0; i < pacarrayorder.length; i++) {
- var pacorderstatusValue=pacarrayorder[i];
- if(pacorderstatusValue!=pacoid){
- if (document.getElementById("pacorderids").value=='')
- {
- document.getElementById("pacorderids").value=pacorderstatusValue;
- }
- else
- {
- var pacnewvalue=document.getElementById("pacorderids").value;
- document.getElementById("pacorderids").value=pacnewvalue+","+pacorderstatusValue;
- }
- }
- }
- }
- else
- {
- if(pacmorderId=='')
- {
- document.getElementById("pacorderids").value=pacoid;
- }
- else
- {
- document.getElementById("pacorderids").value=pacmorderId+","+pacoid;
- }
- }
- }
- function dispatchsids(dpoid)
- {
- var checkstatus=$("#dporderid-"+dpoid).is(":checked");
- var dpmorderId =document.getElementById("dporderids").value;
- if(checkstatus==false)
- {
- var dparrayorder = JSON.parse("[" + dpmorderId + "]");
- document.getElementById("dporderids").value='';
- for (var i = 0; i < dparrayorder.length; i++) {
- var dporderstatusValue=dparrayorder[i];
- if(dporderstatusValue!=dpoid){
- if (document.getElementById("dporderids").value=='')
- {
- document.getElementById("dporderids").value=dporderstatusValue;
- }
- else
- {
- var dpnewvalue=document.getElementById("dporderids").value;
- document.getElementById("dporderids").value=dpnewvalue+","+dporderstatusValue;
- }
- }
- }
- }
- else
- {
- if(dpmorderId=='')
- {
- document.getElementById("dporderids").value=dpoid;
- }
- else
- {
- document.getElementById("dporderids").value=dpmorderId+","+dpoid;
- }
- }
- }
- function printsids(poid)
- {
- var checkstatus=$("#porderid-"+poid).is(":checked");
- var pmorderId =document.getElementById("porderids").value;
- if(checkstatus==false)
- {
- var parrayorder = JSON.parse("[" + pmorderId + "]");
- document.getElementById("porderids").value='';
- for (var i = 0; i < parrayorder.length; i++) {
- var porderstatusValue=parrayorder[i];
- if(porderstatusValue!=poid){
- if (document.getElementById("porderids").value=='')
- {
- document.getElementById("porderids").value=porderstatusValue;
- }
- else
- {
- var pnewvalue=document.getElementById("porderids").value;
- document.getElementById("porderids").value=pnewvalue+","+porderstatusValue;
- }
- }
- }
- }
- else
- {
- if(pmorderId=='')
- {
- document.getElementById("porderids").value=poid;
- }
- else
- {
- document.getElementById("porderids").value=pmorderId+","+poid;
- }
- }
- }
- function assignorder()
- {
- var assignee=$("#assignee option:selected" ).val();
- var orderids=document.getElementById("orderids").value;
- document.getElementById("assignedid").value=orderids;
- var orderId=document.getElementById("assignedid").value;
- if(assignee == '0'){alert("Please Select Name To Assign.");}
- else{if(orderId ==''){alert("Please Checked Order To Assign.");}}
- if(assignee != '0' && orderId!=''){
- $("#assigneeform").submit();
- }
- }
- function conformorder(id,neworderids,formname)
- {
- var orderids=document.getElementById(id).value;
- if(orderids!='')
- {
- document.getElementById(neworderids).value=orderids;
- }
- if(orderids=='')
- {
- alert("Please Checked Order To Conformed.");
- }
- else
- {
- $("#"+formname).submit();
- }
- }
- function insertToDatabase(editableObj,column) {
- $.ajax({
- url: "insertOrder.php",
- type: "POST",
- data:'column='+column+'&editval='+$(editableObj).text(),
- success: function(data){
- $(editableObj).css("background","#FDFDFD");
- location.reload();
- }
- });
- }
- function saveToDatabase(editableObj,column,id) {
- if(column=="image_ready" || column=="ready_to_print" || column=="ready_to_packaging" || column=="ready_to_dispatch"){cvalue=editableObj;}else{var cvalue=$(editableObj).text();}
- $.ajax({
- url: "editOrder.php",
- type: "POST",
- data:'column='+column+'&editval='+cvalue+'&id='+id,
- success: function(data){
- $(editableObj).css("background","#dddddd");
- if(column=="image_ready" || column=="ready_to_print" || column=="ready_to_packaging" || column=="ready_to_dispatch"){location.reload();}
- }
- });
- }
- function handler(e,column,id){
- editableObj=e.target.value;
- $.ajax({
- url: "editOrder.php",
- type: "POST",
- data:'column='+column+'&editval='+editableObj+'&id='+id,
- success: function(data){
- $(editableObj).css("background","#dddddd");
- location.reload();
- }
- });
- }
- //add new row
- function createNew() {
- $("#add-more").hide();
- var data = '<tr class="table-row" id="new_row_ajax">' +
- '<td contenteditable="false" id="txt_id"></td>' +
- '<td contenteditable="true" id="txt_order_id" onBlur="insertToDatabase(this,\'order_id\')" ></td>'+
- '<td contenteditable="true" id="txt_order_date"></td>'+
- '<td contenteditable="true" id="txt_payment_type" ></td>'+
- '<td contenteditable="true" id="txt_conformed_by" ></td>'+
- '<td contenteditable="true" id="txt_status" ></td>' +
- '<td contenteditable="true" id="txt_customer_name"></td>' +
- '<td contenteditable="true" id="txt_phone_number"></td>' +
- '<td contenteditable="true" id="txt_address"></td>' +
- '<td contenteditable="false" id="txt_image_ready"></td>' +
- '<td contenteditable="false" id="txt_ready_to_print"></td>' +
- '<td contenteditable="false" id="txt_ready_to_packaging"></td>' +
- '<td contenteditable="false" id="txt_ready_to_dispatch"></td>' +
- '</tr>';
- $("#table-body").prepend(data);
- }
- $(document).ready(function () {
- $("#fromdate").datepicker();
- $('#todate').datepicker();
- $("#importorder").click(function() {
- var todate = $("#todate").val();
- var fromdate = $("#fromdate").val();
- var selectedfromtime = $("#formtime option:selected").val();
- var selectedtotime = $("#totime option:selected").val();
- if (fromdate === "") {
- alert("Please select departing and returning dates.");
- } else {
- $("#toorderdate").val(todate);
- $("#fromorderdate").val(fromdate);
- $("#directorderform").submit();
- }
- });
- $("#focus").select();
- //setTimeout(selectBarcode(),1000);
- $('input[name="tag"]').change(function()
- {
- txt = $("#focus").val();//alert('You have changed the input'+txt);
- $.ajax({
- url: "scanupdates.php",
- type: "POST",
- data:'order_id='+txt+'&wtype='+<?php echo $userdepart?>+'&uname='+'<?php echo $loginuser?>',
- success: function(data){
- alert(data);
- if(data=="")
- {
- alert(data);
- }
- location.reload();
- // $(editableObj).css("background","#FDFDFD");
- }
- });
- //
- });
- });
- // Orders per page
- /*
- function loadPage()
- {
- var limitval=$("#pagination option:selected" ).val();
- var searchordevalue="<?php echo $searchValue?>";
- if(searchordevalue!='')
- {
- window.location = "../Admin/dashboard2.php?limitperpage="+limitval+"&searchOrder="+searchordevalue;
- }
- else
- {
- window.location = "../Admin/dashboard2.php?limitperpage="+limitval;
- }
- */
- // Orders per page end
- //show status
- $('#show_status').click(function(){
- var selected = [];
- $('.assigneeid-order:checked').each(function() {
- selected.push($(this).val());
- $('.assigneeid-order').prop('checked', false);
- });
- var jsonString = JSON.stringify(selected);
- $.ajax({
- type: "POST",
- url: "api.php",
- data: {data : jsonString},
- success: function(response){
- response = $.parseJSON(response);
- $.each(response, function(index, val) {
- //console.log(index, val);
- //console.log("#"+index+"lud", val.lud);
- $("#"+index+"").html(val);
- $("#"+index+"").html(val.status);
- $("#"+index+"lud").html(val.lud);
- $("#"+index+"tracking").html(val.tracking);
- $("#"+index+"reason1").html(val.reason1);
- });
- }
- });
- });
- //show status end
- // Reattempt
- $('#reattempt').click(function(){
- var selected = [];
- $('.assigneeid-order:checked').each(function() {
- selected.push($(this).val());
- $('.assigneeid-order').prop('checked', false);
- });
- var jsonString = JSON.stringify(selected);
- $.ajax({
- type: "POST",
- url: "reattempt.php",
- data: {data : jsonString},
- success: function(response){
- response = $.parseJSON(response);
- $.each(response, function(index, val) {
- $("#"+index+"reattempt").html(val.reattempt);
- });
- }
- });
- });
- //Reattempt end
- // Cancel
- $('#cancel').click(function(){
- var selected = [];
- $('.assigneeid-order:checked').each(function() {
- selected.push($(this).val());
- $('.assigneeid-order').prop('checked', false);
- });
- var jsonString = JSON.stringify(selected);
- $.ajax({
- type: "POST",
- url: "cancel.php",
- data: {data : jsonString},
- success: function(response){
- response = $.parseJSON(response);
- $.each(response, function(index, val) {
- $("#"+index+"cancel").html(val.cancel);
- });
- }
- });
- });
- //cancel end
- // ecall
- $('#ecall').click(function(){
- var selected = [];
- $('.assigneeid-order:checked').each(function() {
- selected.push($(this).val());
- $('.assigneeid-order').prop('checked', false);
- });
- var jsonString = JSON.stringify(selected);
- $.ajax({
- type: "POST",
- url: "ecall.php",
- data: {data : jsonString},
- success: function(response){
- response = $.parseJSON(response);
- $.each(response, function(index, val) {
- $("#"+index+"ecall").html(val.ecall);
- });
- }
- });
- });
- //ecall end
- // edcall
- $('#edcall').click(function(){
- var selected = [];
- $('.assigneeid-order:checked').each(function() {
- selected.push($(this).val());
- $('.assigneeid-order').prop('checked', false);
- });
- var jsonString = JSON.stringify(selected);
- $.ajax({
- type: "POST",
- url: "edcall.php",
- data: {data : jsonString},
- success: function(response){
- response = $.parseJSON(response);
- $.each(response, function(index, val) {
- $("#"+index+"edcall").html(val.edcall);
- });
- }
- });
- });
- //edcall end
- // sent
- $('#sent').click(function(){
- var selected = [];
- $('.assigneeid-order:checked').each(function() {
- selected.push($(this).val());
- $('.assigneeid-order').prop('checked', false);
- });
- var jsonString = JSON.stringify(selected);
- $.ajax({
- type: "POST",
- url: "sent.php",
- data: {data : jsonString},
- success: function(response){
- response = $.parseJSON(response);
- $.each(response, function(index, val) {
- $("#"+index+"sent").html(val.sent);
- });
- }
- });
- });
- //sent end
- // orders
- $('#orderstab').click(function(){
- var selected = [];
- $('.assigneeid-order:checked').each(function() {
- selected.push($(this).val());
- $('.assigneeid-order').prop('checked', false);
- });
- var jsonString = JSON.stringify(selected);
- $.ajax({
- type: "POST",
- url: "orderstab.php",
- data: {data : jsonString},
- success: function(response){
- response = $.parseJSON(response);
- $.each(response, function(index, val) {
- $("#"+index+"orderstab").html(val.orderstab);
- });
- }
- });
- });
- //orders end
- // open orders tab by default
- document.getElementsByClassName('tablinks active')[0].click()
- // open orders tab by default end
- //Search by order id
- function searchorderbyid()
- {
- var orderId=document.getElementById("orderbyid").value;
- if(orderId ==''){alert("Please Enter order id to search.");}
- else{$("#serchorderbyidform").submit();}
- }
- //Search by order id end
- //export
- function exportorders()
- {
- var sqlorderresult="<?php echo $userToSearch;?>";
- var d = new Date();
- var yyyy = d.getFullYear().toString();
- var mm = (d.getMonth()+1).toString(); // getMonth() is zero-based
- var dd = d.getDate().toString();
- var hh = d.getHours().toString();
- var min = d.getMinutes().toString();
- var sec = d.getSeconds().toString();
- fulldate=yyyy+"-"+mm+"-"+dd+"-"+hh+"-"+min+"-"+sec;
- var orderId=document.getElementById("orderids").value;
- $.ajax({
- url: "exportOrderCsv.php",
- type: "POST",
- data:'exportorders='+sqlorderresult+'&department=customercare&orderId='+orderId,
- success: function(data){
- var pom = document.createElement('a');
- var csvContent=data; //here we load our csv data
- var blob = new Blob([csvContent],{type: 'text/csv;charset=utf-8;'});
- var url = URL.createObjectURL(blob);
- pom.href = url;
- pom.setAttribute('download', fulldate+'.csv');
- pom.click();
- }
- });
- }
- //export end
- // SENDS SELECTED OPTION TO RETRIEVE DATA TO FILL TABLE.
- function send_option () {
- var sel = document.getElementById( "my_select" );
- var txt = document.getElementById( "my_option" );
- txt.value = sel.options[ sel.selectedIndex ].value;
- var sel1 = document.getElementById( "my_select1" );
- var txt1 = document.getElementById( "my_option1" );
- txt1.value = sel1.options[ sel1.selectedIndex ].value;
- var sel2 = document.getElementById( "my_select2" );
- var txt2 = document.getElementById( "my_option2" );
- txt2.value = sel2.options[ sel2.selectedIndex ].value;
- var sel3 = document.getElementById( "my_select3" );
- var txt3 = document.getElementById( "my_option3" );
- txt3.value = sel3.options[ sel3.selectedIndex ].value;
- var frm = document.getElementById( "my_form" );
- frm.submit();
- }
- </script>
- </body>
- </html>
- </html>
- <style>
- .button1 { font-size : 20px; }
- #my_select
- {
- width:70px;
- }
- #my_select option{
- width:70px;
- }
- #my_select1
- {
- width:70px;
- }
- #my_select1 option{
- width:70px;
- }
- #my_select3
- {
- width:70px;
- }
- #my_select3 option{
- width:70px;
- }
- table {
- counter-reset: rowNumber;
- }
- table tr {
- counter-increment: rowNumber;
- }
- table tr td:first-child::before {
- content: counter(rowNumber);
- min-width: 1em;
- margin-right: 0.5em;
- }
- </style>
Add Comment
Please, Sign In to add comment