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);
- require_once("dbcontroller.php");
- $db_handle = new DBController();
- if (isset($_GET['pageno'])) {
- $pageno = $_GET['pageno'];
- } else {
- $pageno = 1;
- }
- ?>
- <!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 class="tablinks" onclick="openTab(event, 'LeadManager')" id="<?php if($logintype=='1'){echo"defaultOpen";}?>">ORDERS</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" >
- <input type="file" name="file" id="file" class="ajax-action-file">
- <button type="submit" id="submit" name="Import" class="ajax-assign-button" data-loading-text="Loading...">Import CSV</button>
- </form>
- </div>
- <div style="clear:both;"></div>
- <!-- Assign Orders -->
- <!-- Conformed Order From Pending To conformed -->
- <?PHP }?>
- <div style="clear:both;"></div>
- <?php
- $userToSearch='';
- /* if($logintype=="2"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%'";
- }
- else
- {
- $userToSearch = "WHERE conformed_by LIKE '%%' OR conformed_by IS NULL";
- }*/
- $sqlresultdoorder = "SELECT * from do_order";
- $resultdoorder = $db_handle->runSelectQuery($sqlresultdoorder);
- $numrows =count($resultdoorder);
- $rows_per_page = 20;
- $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);
- ?>
- <!-- madhu please check from below code -->
- <?php
- $tabindex=1;
- function checkecomstatus($orderid)
- {
- $data['username']='outthinking781346';
- $data['password']='ouhk78epe34csmed46d';
- $data['awb']=$orderid;
- $url = 'https://plapi.ecomexpress.in/track_me/api/mawbd/?awb=awbnumber&order='.$orderid.'&username=outthinking781346&password=ouhk78epe34csmed46d';
- $ch = curl_init();
- curl_setopt($ch, CURLOPT_URL,$url);
- curl_setopt($ch, CURLOPT_POST, true);
- curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
- curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
- curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
- curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
- $output = curl_exec ($ch);
- curl_close($ch);
- $res = explode("\n",$output);
- if ( ! isset($res[13]))
- {
- $res[13] = null;
- }
- $status = str_replace('</field>.','',$res[13]);
- $statusfinal = str_replace('<field type="CharField" name="status">','',$status);
- if($statusfinal!='')
- {
- $sqlecom = "UPDATE do_order set in_transit='".$statusfinal.".',tconformed_by='Ecom' where order_id=".$orderid;
- $db_handleecom = new DBController();
- $resultecom = $db_handleecom->executeUpdate($sqlecom);
- }
- return $statusfinal;
- }
- ?>
- <p><button type= "button" id="show_status" >Show Status</button></p>
- <table class="tbl-qa" border="1">
- <thead>
- <tr>
- <th class="table-header">ID</th>
- <th class="table-header">ORDERID</th>
- <th class="table-header">Status</th>
- </tr>
- </thead>
- <tbody id="table-body">
- <?php
- if(!empty($orderrecords))
- {
- foreach($orderrecords as $k=>$v)
- {?>
- <tr class="table-row" id="table-row-<?php echo $orderrecords[$k]["id"]; ?>" tabindex="<?php echo $tabindex;?>">
- <td>
- <input type="checkbox" name="assigneeid" class="assigneeid-order" value="<?php echo $orderrecords[$k]["order_id"]; ?>">
- </td>
- <td><?php echo $orderrecords[$k]["order_id"]; ?></td>
- <td id="<?php echo $orderrecords[$k]["order_id"];?>"></td>
- </tr>
- <?php
- $tabindex++;
- }
- }?>
- </tbody>
- </table>
- <input type="hidden" name="ordercheckallIDs" id="ordercheckallIDs" value="<?php echo $ordercheckall;?>"/>
- <!-- madhu please check from until here -->
- <div class="pagination">
- <?php if ($pageno == 1) {
- echo " <span class='firstspan'>FIRST</span>";
- } else {
- echo " <span class='firstpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=1'>FIRST</a></span> ";
- $prevpage = $pageno-1;
- echo " <span class='prvpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=$prevpage'>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']}?wtype=".$wtype."&pageno=$nextpage'>NEXT</a></span> ";
- echo " <span class='lastpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=$lastpage'>LAST</a></span> ";
- }
- echo " ( Page $pageno of $lastpage ) ";
- ?>
- </div>
- </div>
- <div id="Graphice" class="tabcontent">
- <input type="hidden" name="gorderids" id="gorderids" value=""/>
- <h3>Graphice</h3>
- <?php if($logintype=="2" && $userdepart=="1"){?>
- <div class="orderconform">
- <form name="gconformedform" id="gconformedform" method="post" enctype="multipart/form-data" action="conformedOrders.php" >
- <input type="hidden" name="gconformorderid" id="gconformorderid" value=""/>
- <input type="hidden" name="columnName" id="columnName" value="image_ready"/>
- <input type="button" class="ajax-assign-button" id="conformed" value="Conform" onclick="conformorder('gorderids','gconformorderid','gconformedform');"/>
- </form>
- </div>
- <?php
- }
- if($logintype=="2")
- {
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND status='Conformed' AND (image_ready IS NULL OR image_ready='')";
- }
- else
- {
- $userToSearch = "WHERE conformed_by LIKE '%%' AND status='Conformed' AND (image_ready IS NULL OR image_ready='')";
- }
- $sqlgrapicsresult = "SELECT * from do_order ".$userToSearch. " ORDER BY id DESC ".$limit;
- $grapicsrecords = $db_handle->runSelectQuery($sqlgrapicsresult);
- ?>
- <table class="tbl-qa" border="1">
- <thead>
- <tr>
- <th class="table-header">ID</th>
- <th class="table-header">ORDERID</th>
- <th class="table-header">ORDER DATE</th>
- <th class="table-header">ASSIGN</th>
- <th class="table-header">STATUS</th>
- <th class="table-header">IMAGE READY</th>
- </tr>
- </thead>
- <tbody id="table-body">
- <?php
- $gtabindex=1;
- if(!empty($grapicsrecords))
- {
- foreach($grapicsrecords as $g=>$v1)
- {?>
- <tr>
- <td><input type="checkbox" onclick="graphicsorderids('<?php echo $grapicsrecords[$g]["order_id"]?>');" name="gorderid" id="gorderid-<?php echo $grapicsrecords[$g]["order_id"]; ?>" value="<?php echo $grapicsrecords[$g]["order_id"]; ?>"></td>
- <td><?php echo $grapicsrecords[$g]["order_id"]; ?></td>
- <td><?php echo $grapicsrecords[$g]["order_date"]; ?></td>
- <td><?php echo $grapicsrecords[$g]["conformed_by"]; ?></td>
- <td><?php echo $grapicsrecords[$g]["status"]; ?></td>
- <td contenteditable="true" <?php if($logintype=="2" && $userdepart=="1"){?>onClick="saveToDatabase('Conformed','image_ready','<?php echo $grapicsrecords[$g]["id"]; ?>')" <?php }?>><?php echo $grapicsrecords[$g]["image_ready"]; ?></td>
- </tr>
- <?php $gtabindex++;
- }
- }
- ?>
- </tbody>
- </table>
- </div>
- <div id="Printing" class="tabcontent">
- <input type="hidden" name="porderids" id="porderids" value=""/>
- <h3>Printing</h3>
- <?php if($logintype=="2" && $userdepart=="2"){?>
- <div class="orderconform">
- <form name="pconformedform" id="pconformedform" method="post" enctype="multipart/form-data" action="conformedOrders.php" >
- <input type="hidden" name="pconformorderid" id="pconformorderid" value=""/>
- <input type="hidden" name="columnName" id="columnName" value="ready_to_print"/>
- <input type="button" class="ajax-assign-button" id="conformed" value="Conform" onclick="conformorder('porderids','pconformorderid','pconformedform');"/>
- </form>
- </div>
- <?php
- }
- if($logintype=="2")
- {
- $printToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND image_ready='Conformed' AND (ready_to_print IS NULL OR ready_to_print='')";
- }
- else
- {
- $printToSearch = "WHERE conformed_by LIKE '%%' AND image_ready='Conformed' AND (ready_to_print IS NULL OR ready_to_print='')";
- }
- $sqlprintsresult = "SELECT * from do_order ".$printToSearch. " ORDER BY id DESC ".$limit;
- $printsrecords = $db_handle->runSelectQuery($sqlprintsresult);
- ?>
- <table class="tbl-qa" border="1">
- <thead>
- <tr>
- <th class="table-header">ID</th>
- <th class="table-header">ORDERID</th>
- <th class="table-header">ORDER DATE</th>
- <th class="table-header">ASSIGN</th>
- <th class="table-header">STATUS</th>
- <th class="table-header">READY TO PRINT</th>
- </tr>
- </thead>
- <tbody id="table-body">
- <?php
- $ptabindex=1;
- if(!empty($printsrecords))
- {
- foreach($printsrecords as $p=>$v1)
- {?>
- <tr>
- <td><input type="checkbox" onclick="printsids('<?php echo $printsrecords[$p]["order_id"]?>');" name="porderid" id="porderid-<?php echo $printsrecords[$p]["order_id"]; ?>" value="<?php echo $printsrecords[$p]["order_id"]; ?>"></td>
- <td><?php echo $printsrecords[$p]["order_id"]; ?></td>
- <td><?php echo $printsrecords[$p]["order_date"]; ?></td>
- <td><?php echo $printsrecords[$p]["conformed_by"]; ?></td>
- <td><?php echo $printsrecords[$p]["status"]; ?></td>
- <td contenteditable="true" <?php if($logintype=="2" && $userdepart=="2"){?>onClick="saveToDatabase('Conformed','ready_to_print','<?php echo $printsrecords[$p]["id"]; ?>')" <?php }?>><?php echo $printsrecords[$p]["ready_to_print"]; ?></td>
- </tr>
- <?php $ptabindex++;
- }
- }
- ?>
- </tbody>
- </table>
- </div>
- <div id="Packing" class="tabcontent">
- <h3>Packing</h3>
- <input type="hidden" name="pacorderids" id="pacorderids" value=""/>
- <?php if($logintype=="2" && $userdepart=="3"){?>
- <div class="orderconform">
- <form name="pacconformedform" id="pacconformedform" method="post" enctype="multipart/form-data" action="conformedOrders.php" >
- <input type="hidden" name="pacconformorderid" id="pacconformorderid" value=""/>
- <input type="hidden" name="columnName" id="columnName" value="ready_to_packaging"/>
- <input type="button" class="ajax-assign-button" id="conformed" value="Conform" onclick="conformorder('pacorderids','pacconformorderid','pacconformedform');"/>
- </form>
- </div>
- <?php
- }
- if($logintype=="2")
- {
- $packingToSearch = "WHERE conformed_by LIKE '%".$loginuser."%' AND ready_to_print='Conformed' AND (ready_to_packaging IS NULL OR ready_to_packaging='')";
- }
- else
- {
- $packingToSearch = "WHERE conformed_by LIKE '%%' AND ready_to_print='Conformed' AND (ready_to_packaging IS NULL OR ready_to_packaging='')";
- }
- $sqlpackingsresult = "SELECT * from do_order ".$packingToSearch. " ORDER BY id DESC ".$limit;
- $packingsrecords = $db_handle->runSelectQuery($sqlpackingsresult);
- ?>
- <table class="tbl-qa" border="1">
- <thead>
- <tr>
- <th class="table-header">ID</th>
- <th class="table-header">ORDERID</th>
- <th class="table-header">ORDER DATE</th>
- <th class="table-header">ASSIGN</th>
- <th class="table-header">STATUS</th>
- <th class="table-header">READY TO PRINT</th>
- </tr>
- </thead>
- <tbody id="table-body">
- <?php
- $pactabindex=1;
- if(!empty($packingsrecords))
- {
- foreach($packingsrecords as $pac=>$v1)
- {?>
- <tr>
- <td><input type="checkbox" onclick="packingsids('<?php echo $packingsrecords[$pac]["order_id"]?>');" name="pacorderid" id="pacorderid-<?php echo $packingsrecords[$pac]["order_id"]; ?>" value="<?php echo $packingsrecords[$pac]["order_id"]; ?>"></td>
- <td><?php echo $packingsrecords[$pac]["order_id"]; ?></td>
- <td><?php echo $packingsrecords[$pac]["order_date"]; ?></td>
- <td><?php echo $packingsrecords[$pac]["conformed_by"]; ?></td>
- <td><?php echo $packingsrecords[$pac]["status"]; ?></td>
- <td contenteditable="true" <?php if($logintype=="2" && $userdepart=="3"){?>onClick="saveToDatabase('Conformed','ready_to_packaging','<?php echo $packingsrecords[$pac]["id"]; ?>')" <?php }?>><?php echo $packingsrecords[$pac]["ready_to_packaging"]; ?></td>
- </tr>
- <?php $pactabindex++;
- }
- }
- ?>
- </tbody>
- </table>
- </div>
- <!-- my code -->
- <div id="ReadytoDispatch" class="tabcontent">
- <h3><?php echo $usertype;?></h3>
- <input type="hidden" name="orderids" id="orderids" value=""/>
- <?php if($logintype!="2"){?>
- <!-- Import Order -->
- <!-- Assign Orders -->
- <div class="orderassign" style="float: left;">
- <!-- Move to InTransit for Non ecom orders -->
- <input type="button" class="ajax-assign-button" id="assign" value="" onclick="assignorder();"/>
- </div>
- <!-- Conformed Order From Pending To conformed -->
- <div class="orderconform">
- </div>
- <?PHP }?>
- <div style="clear:both;"></div>
- <?php
- $userToSearch='';
- /* if($logintype=="2"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%'";
- }
- else
- {
- $userToSearch = "WHERE conformed_by LIKE '%%' OR conformed_by IS NULL";
- }*/
- $sqlresultdoorder = "SELECT * from do_order";
- $resultdoorder = $db_handle->runSelectQuery($sqlresultdoorder);
- $numrows =count($resultdoorder);
- $rows_per_page = 20;
- $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);
- ?>
- <table class="tbl-qa" border="1">
- <thead>
- <tr>
- <th class="table-header">ID</th>
- <th class="table-header">ORDERID</th>
- <th class="table-header">ORDER DATE</th>
- <th class="table-header">PAYMENT TYPE</th>
- <th class="table-header">CUSTOMER NAME</th>
- <th class="table-header">CONTACT NO</th>
- <th class="table-header">ADDRESS</th>
- </tr>
- </thead>
- <tbody id="table-body">
- <?php
- $tabindex=1;
- if(!empty($orderrecords))
- {
- foreach($orderrecords as $k=>$v)
- {?>
- <tr class="table-row" id="table-row-<?php echo $orderrecords[$k]["id"]; ?>" tabindex="<?php echo $tabindex;?>">
- <td><input onclick="assignorderids('<?php echo $orderrecords[$k]["order_id"]; ?>')" type="checkbox" name="assigneeid" id="assigneeid-<?php echo $orderrecords[$k]["order_id"]; ?>" value="<?php echo $orderrecords[$k]["order_id"]; ?>"></td>
- <td><?php echo $orderrecords[$k]["order_id"]; ?></td>
- <td><?php if($orderrecords[$k]["order_date"]==''){ ?><input type="date" name="order_date" onchange="handler(event,'order_date','<?php echo $orderrecords[$k]["id"]; ?>')"><?php }else{ echo $orderrecords[$k]["order_date"];}?></td>
- <td <?php if($logintype!="2"){?>contenteditable="true" onBlur="saveToDatabase(this,'payment_type','<?php echo $orderrecords[$k]["id"]; ?>')" "<?php }?>><?php echo $orderrecords[$k]["payment_type"]; ?></td>
- <td <?php if($logintype!="2"){?>contenteditable="true" onBlur="saveToDatabase(this,'customer_name','<?php echo $orderrecords[$k]["id"]; ?>')"<?php }?>><?php echo $orderrecords[$k]["customer_name"]; ?></td>
- <td <?php if($logintype!="2"){?>contenteditable="true" onBlur="saveToDatabase(this,'phone_number','<?php echo $orderrecords[$k]["id"]; ?>')"<?php }?>><?php echo $orderrecords[$k]["phone_number"]; ?></td>
- <td <?php if($logintype!="2"){?>contenteditable="true" onBlur="saveToDatabase(this,'address','<?php echo $orderrecords[$k]["id"]; ?>')" <?php }?>><?php echo $orderrecords[$k]["address"]; ?></td>
- </tr>
- <?php
- $tabindex++;
- }
- }?>
- </tbody>
- </table>
- <div class="pagination">
- <?php if ($pageno == 1) {
- echo " <span class='firstspan'>FIRST</span>";
- } else {
- echo " <span class='firstpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=1'>FIRST</a></span> ";
- $prevpage = $pageno-1;
- echo " <span class='prvpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=$prevpage'>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']}?wtype=".$wtype."&pageno=$nextpage'>NEXT</a></span> ";
- echo " <span class='lastpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=$lastpage'>LAST</a></span> ";
- }
- echo " ( Page $pageno of $lastpage ) ";
- ?>
- </div>
- </div>
- <!-- my code end -->
- <!-- my code 2-->
- <div id="Intransit" class="tabcontent">
- <h3><?php echo $usertype;?></h3>
- <input type="hidden" name="orderids" id="orderids" value=""/>
- <?php if($logintype!="2"){?>
- <!-- Import Order -->
- <!-- Assign Orders -->
- <div class="orderassign" style="float: left;">
- <!-- Call Api -->
- <input type="button" class="ajax-assign-button" id="assign" value="" onclick="assignorder();"/>
- </div>
- <!-- Conformed Order From Pending To conformed -->
- <div class="orderconform">
- </div>
- <?PHP }?>
- <div style="clear:both;"></div>
- <?php
- $userToSearch='';
- /* if($logintype=="2"){
- $userToSearch = "WHERE conformed_by LIKE '%".$loginuser."%'";
- }
- else
- {
- $userToSearch = "WHERE conformed_by LIKE '%%' OR conformed_by IS NULL";
- }*/
- $sqlresultdoorder = "SELECT * from do_order";
- $resultdoorder = $db_handle->runSelectQuery($sqlresultdoorder);
- $numrows =count($resultdoorder);
- $rows_per_page = 20;
- $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);
- ?>
- <div class="pagination">
- <?php if ($pageno == 1) {
- echo " <span class='firstspan'>FIRST</span>";
- } else {
- echo " <span class='firstpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=1'>FIRST</a></span> ";
- $prevpage = $pageno-1;
- echo " <span class='prvpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=$prevpage'>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']}?wtype=".$wtype."&pageno=$nextpage'>NEXT</a></span> ";
- echo " <span class='lastpage'><a href='{$_SERVER['PHP_SELF']}?wtype=".$wtype."&pageno=$lastpage'>LAST</a></span> ";
- }
- echo " ( Page $pageno of $lastpage ) ";
- ?>
- </div>
- </div>
- <!-- my code end -->
- </div>
- <div style="clear:both;"></div>
- <?php include "Footer.php"; ?>
- </div>
- <script type="text/javascript">
- //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");
- }
- });
- //
- });
- });
- $('#show_status').click(function(){
- var selected = [];
- $('.assigneeid-order:checked').each(function() {
- selected.push($(this).val());
- });
- 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) {
- $("#"+index+"").html(val);
- });
- }
- });
- });
- </script>
- </body>
- </html>
- </html>
Add Comment
Please, Sign In to add comment