API tools faq
paste
Guest User

Untitled

a guest
Oct 16th, 2018
131
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 17.80 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. page_protect();
  3. if(!checkL2()) {
  4. header("Location: page.php?page=login");
  5. exit();
  6. }
  7.  
  8. ?>
  9. <h3>Edit A Pickup\Delivery QLD</h3>
  10. <h2>
  11. <?php
  12. $lefttitle = "Edit a Pickup QLD";
  13.  
  14. ?>
  15.  
  16. <?php
  17.  
  18.     if (isset($_POST['submit'])) {
  19.    
  20.     $Seqno2 = $_POST["seqno2"];
  21.     $Status2 = $_POST["status2"];
  22.    
  23.     $data_source ='vshopqld';
  24.     $user = 'vshoptest';
  25.     $password = 'lifesgreat';
  26.    
  27.     $conn = odbc_connect($data_source,$user,$password);
  28.  
  29.         $sql = "UPDATE VN_PICKUP SET status = '$Status2' where seqno = '$Seqno2'";
  30.  
  31.     $rs = odbc_exec($conn,$sql) or die("Sorry, Couldn't execut query");
  32.  
  33.     odbc_close($conn);
  34.  
  35.     }
  36. ?>
  37.  
  38. <?php
  39.                    
  40.     $countrows = 0;
  41.     $rownum = 0;
  42.     $showheader = 0;
  43.    
  44.     $data_source ='vshopqld';
  45.     $user = 'vshoptest';
  46.     $password = 'lifesgreat';
  47.    
  48.    
  49.     $conn = odbc_connect($data_source,$user,$password);
  50.        
  51.         $sql3 = "SELECT VN_PICKUP.customer_id, VN_PICKUP.seqno, VN_PICKUP.system_date_time, VN_PICKUP.requested_pickup_date_time, VN_PICKUP.contact, VN_PICKUP.pickup_instructions, VN_PICKUP.container_type1, VN_PICKUP.container_lbs1, VN_PICKUP.status, VN_PICKUP.pickup_delivery, CUSTOMER.customer_id, CUSTOMER.cu_name  FROM VN_PICKUP INNER JOIN CUSTOMER ON VN_PICKUP.customer_id = CUSTOMER.customer_id where VN_PICKUP.pickup_delivery = 'p' order by VN_PICKUP.status desc, VN_PICKUP.requested_pickup_date_time desc";
  52.            
  53.         $stmt3 = odbc_exec($conn,$sql3);
  54.  
  55.    
  56.     odbc_fetch_row($stmt3, 0);
  57.     WHILE (odbc_fetch_row($stmt3)) {
  58.  
  59.  
  60.     if ($showheader == 0) {
  61.     echo "<b class=link2>Pickups for HTA. Click on a pickup request for more information.</b><br><br>";
  62.    
  63.     echo "<table cellspacing=0 cellpadding=3>";
  64.     echo "<tr bgcolor=#047178><td align=left valign=top width=150><font color=#ffffff><b>Company</b></font></td><td align=left valign=top width=100><font color=#ffffff><b>Pickup Date</b></font></td><td align=left valign=top width=120><font color=#ffffff><b>Requested By</b></font></td><td align=left valign=top width=150><font color=#ffffff><b>Item Description</b></font></td><td align=left valign=top width=70><font color=#ffffff><b>Weight</b></font></td><td align=right valign=top width=80><font color=#ffffff><b>Status</b></font></td><td align=right valign=top width=80><font color=#ffffff><b>Save</b></font></td></tr>";
  65.     $showheader = 1;
  66.     }
  67.  
  68.  
  69.       $countrows = $countrows + 1;
  70.      
  71.       $Request_Date = odbc_result($stmt3,'requested_pickup_date_time');
  72.       $Contact = odbc_result($stmt3,'contact');
  73.       $Conttype1 = odbc_result($stmt3,'container_type1');
  74.       $Contweight1 = odbc_result($stmt3,'container_lbs1');
  75.       $Statuscode = odbc_result($stmt3,'status');
  76.       $Seqno = odbc_result($stmt3,'seqno');
  77.       $Custname = odbc_result($stmt3,'cu_name');
  78.       $custID = odbc_result($stmt3, 'customer_id');
  79.       $Pickupdelivery2 = odbc_result($stmt3, 'pickup_delivery');
  80.  
  81.       $Pickupdelivery2trimmed = trim($Pickupdelivery2);
  82.       $Statustrimmed = trim($Statuscode);
  83.      
  84.       $year = substr($Request_Date,0,4);
  85.       $month = substr($Request_Date,5,2);
  86.       $day = substr($Request_Date,8,2);
  87.  
  88.            
  89.             if ($countrows < '21') {
  90.            
  91.                
  92.             if ($rownum == "1" ) {
  93.             $bgcolor = "#EEEEEE";
  94.             $rownum = "0";
  95.             } else {
  96.             $bgcolor = "#b4ebee";
  97.             $rownum = "1";
  98.             }
  99.  
  100.                
  101.             echo "<tr bgcolor='" . $bgcolor . "'><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Custname . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $day . "/" . $month . "/" . $year . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Contact . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Conttype1 . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Contweight1 . "</a></td><td align=right valign=middle><font color=black>";
  102.             echo "<form method=post action=''>";
  103.             echo "<select name=status2>";
  104.             if ($Statustrimmed == "c") {
  105.                 echo "<option value='c' selected='selected'>Closed</option>";
  106.                 echo "<option value='o'>Open</option>";
  107.             } else if ($Statustrimmed == "o") {
  108.                 echo "<option value='c'>Closed</option>";
  109.                 echo "<option value='o' selected='selected'>Open</option>";
  110.             }
  111.                
  112.             echo "</td><td align=right valign=middle><font color=black>";
  113.             echo "<input type=hidden value='$Seqno' name='seqno2'>";
  114.             echo "<input type='submit' value='Save' name='submit'>";
  115.             echo "</form>";
  116.             echo"</td></tr>";
  117.            
  118.            
  119.             } else {
  120.                
  121.                
  122.                 odbc_close($conn);
  123.             }
  124.    
  125.                
  126.       }
  127.  
  128.       echo "</table>";
  129.       echo "<br />";
  130.       echo "<table cellspacing=0 cellpadding=3 wight=670>";          
  131.       echo "<tr><td align=right width=670></td></tr>";
  132.       echo "</table>";
  133.    
  134.     ?>
  135.  
  136. <?php
  137.                    
  138.     $countrows = 0;
  139.     $rownum = 0;
  140.     $showheader = 0;
  141.    
  142.     $data_source ='vshopqld';
  143.     $user = 'vshoptest';
  144.     $password = 'lifesgreat';
  145.    
  146.    
  147.     $conn = odbc_connect($data_source,$user,$password);
  148.        
  149.         $sql4 = "SELECT VN_PICKUP.customer_id, VN_PICKUP.seqno, VN_PICKUP.system_date_time, VN_PICKUP.requested_pickup_date_time, VN_PICKUP.contact, VN_PICKUP.pickup_instructions, VN_PICKUP.container_type1, VN_PICKUP.container_lbs1, VN_PICKUP.status, VN_PICKUP.pickup_delivery, CUSTOMER.customer_id, CUSTOMER.cu_name  FROM VN_PICKUP INNER JOIN CUSTOMER ON VN_PICKUP.customer_id = CUSTOMER.customer_id where VN_PICKUP.pickup_delivery = 'd' order by VN_PICKUP.status desc, VN_PICKUP.requested_pickup_date_time desc";
  150.            
  151.         $stmt4 = odbc_exec($conn,$sql4);
  152.  
  153.    
  154.     odbc_fetch_row($stmt4, 0);
  155.     WHILE (odbc_fetch_row($stmt4)) {
  156.  
  157.  
  158.     if ($showheader == 0) {
  159.     echo "<b class=link2>Deliveries for HTA. Click on a delivery request for more information.</b><br><br>";
  160.     echo "<table cellspacing=0 cellpadding=3>";
  161.     echo "<tr bgcolor=#047178><td align=left valign=top width=150><font color=#ffffff><b>Company</b></font></td><td align=left valign=top width=100><font color=#ffffff><b>Pickup Date</b></font></td><td align=left valign=top width=120><font color=#ffffff><b>Requested By</b></font></td><td align=left valign=top width=150><font color=#ffffff><b>Item Description</b></font></td><td align=left valign=top width=70><font color=#ffffff><b>Weight</b></font></td><td align=right valign=top width=80><font color=#ffffff><b>Status</b></font></td><td align=right valign=top width=80><font color=#ffffff><b>Save</b></font></td></tr>";
  162.     $showheader = 1;
  163.     }
  164.  
  165.  
  166.       $countrows = $countrows + 1;
  167.      
  168.           $Request_Date = odbc_result($stmt4,'requested_pickup_date_time');
  169.       $Contact = odbc_result($stmt4,'contact');
  170.           $Conttype1 = odbc_result($stmt4,'container_type1');
  171.       $Contweight1 = odbc_result($stmt4,'container_lbs1');
  172.       $Statuscode = odbc_result($stmt4,'status');
  173.           $Seqno = odbc_result($stmt4,'seqno');
  174.       $Custname = odbc_result($stmt4,'cu_name');
  175.       $custID = odbc_result($stmt4, 'customer_id');
  176.       $Pickupdelivery2 = odbc_result($stmt4, 'pickup_delivery');
  177.  
  178.       $Pickupdelivery2trimmed = trim($Pickupdelivery2);
  179.       $Statustrimmed = trim($Statuscode);
  180.      
  181.       $year = substr($Request_Date,0,4);
  182.       $month = substr($Request_Date,5,2);
  183.       $day = substr($Request_Date,8,2);
  184.  
  185.            
  186.            
  187.             if ($countrows < '21') {
  188.            
  189.                
  190.             if ($rownum == "1" ) {
  191.             $bgcolor = "#EEEEEE";
  192.             $rownum = "0";
  193.             } else {
  194.             $bgcolor = "#b4ebee";
  195.             $rownum = "1";
  196.             }
  197.  
  198.                
  199.             echo "<tr bgcolor='" . $bgcolor . "'><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Custname . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $day . "/" . $month . "/" . $year . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Contact . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Conttype1 . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Contweight1 . "</a></td><td align=right valign=middle><font color=black>";
  200.             echo "<form method=post action=''>";
  201.             echo "<select name=status2>";
  202.             if ($Statustrimmed == "c") {
  203.                 echo "<option value='c' selected='selected'>Closed</option>";
  204.                 echo "<option value='o'>Open</option>";
  205.             } else if ($Statustrimmed == "o") {
  206.                 echo "<option value='c'>Closed</option>";
  207.                 echo "<option value='o' selected='selected'>Open</option>";
  208.             }
  209.                
  210.             echo "</td><td align=right valign=middle><font color=black>";
  211.             echo "<input type=hidden value='$Seqno' name='seqno2'>";
  212.             echo "<input type='submit' value='Save' name='submit'>";
  213.             echo "</form>";
  214.             echo"</td></tr>";
  215.            
  216.            
  217.             } else {
  218.                
  219.                
  220.                 odbc_close($conn);
  221.             }
  222.    
  223.                
  224.       }
  225.  
  226.       echo "</table>";
  227.       echo "<br />";
  228.       echo "<table cellspacing=0 cellpadding=3 wight=670>";          
  229.       echo "<tr><td align=right width=670></td></tr>";
  230.       echo "</table>";
  231.    
  232.     ?>
  233.        
  234.  
  235.  
  236. <?php
  237.                    
  238.     $countrows = 0;
  239.     $rownum = 0;
  240.     $showheader = 0;
  241.    
  242.     $data_source ='vshopqld';
  243.     $user = 'vshoptest';
  244.     $password = 'lifesgreat';
  245.    
  246.    
  247.     $conn = odbc_connect($data_source,$user,$password);
  248.        
  249.         $sql3 = "SELECT VN_PICKUP.customer_id, VN_PICKUP.seqno, VN_PICKUP.system_date_time, VN_PICKUP.requested_pickup_date_time, VN_PICKUP.contact, VN_PICKUP.pickup_instructions, VN_PICKUP.container_type1, VN_PICKUP.container_lbs1, VN_PICKUP.status, VN_PICKUP.pickup_delivery, VN_PICKUP.company_name FROM VN_PICKUP where VN_PICKUP.pickup_delivery = 'p' and VN_PICKUP.customer_id = 'NC' order by VN_PICKUP.status desc, VN_PICKUP.requested_pickup_date_time desc";
  250.            
  251.         $stmt3 = odbc_exec($conn,$sql3);
  252.  
  253.    
  254.     odbc_fetch_row($stmt3, 0);
  255.     WHILE (odbc_fetch_row($stmt3)) {
  256.  
  257.  
  258.     if ($showheader == 0) {
  259.     echo "<br><b class=link1>Non-Customer Pickups for HTA. Click on a pickup request for more information.</b><br><br>";
  260.    
  261.     echo "<table cellspacing=0 cellpadding=3>";
  262.     echo "<tr bgcolor=#047178><td align=left valign=top width=150><font color=#ffffff><b>Company</b></font></td><td align=left valign=top width=100><font color=#ffffff><b>Pickup Date</b></font></td><td align=left valign=top width=120><font color=#ffffff><b>Requested By</b></font></td><td align=left valign=top width=150><font color=#ffffff><b>Item Description</b></font></td><td align=left valign=top width=70><font color=#ffffff><b>Weight</b></font></td><td align=right valign=top width=80><font color=#ffffff><b>Status</b></font></td><td align=right valign=top width=80><font color=#ffffff><b>Save</b></font></td></tr>";
  263.     $showheader = 1;
  264.     }
  265.  
  266.  
  267.       $countrows = $countrows + 1;
  268.      
  269.           $Request_Date = odbc_result($stmt3,'requested_pickup_date_time');
  270.       $Contact = odbc_result($stmt3,'contact');
  271.           $Conttype1 = odbc_result($stmt3,'container_type1');
  272.       $Contweight1 = odbc_result($stmt3,'container_lbs1');
  273.       $Statuscode = odbc_result($stmt3,'status');
  274.           $Seqno = odbc_result($stmt3,'seqno');
  275.       $Custname = odbc_result($stmt3,'company_name');
  276.       $custID = odbc_result($stmt3, 'customer_id');
  277.       $Pickupdelivery2 = odbc_result($stmt3, 'pickup_delivery');
  278.  
  279.       $Pickupdelivery2trimmed = trim($Pickupdelivery2);
  280.       $Statustrimmed = trim($Statuscode);
  281.      
  282.       $year = substr($Request_Date,0,4);
  283.       $month = substr($Request_Date,5,2);
  284.       $day = substr($Request_Date,8,2);
  285.  
  286.            
  287.             if ($countrows < '21') {
  288.            
  289.                
  290.             if ($rownum == "1" ) {
  291.             $bgcolor = "#EEEEEE";
  292.             $rownum = "0";
  293.             } else {
  294.             $bgcolor = "#b4ebee";
  295.             $rownum = "1";
  296.             }
  297.  
  298.                
  299.             echo "<tr bgcolor='" . $bgcolor . "'><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Custname . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $day . "/" . $month . "/" . $year . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Contact . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Conttype1 . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Contweight1 . "</a></td><td align=right valign=middle><font color=black>";
  300.             echo "<form method=post action=''>";
  301.             echo "<select name=status2>";
  302.             if ($Statustrimmed == "c") {
  303.                 echo "<option value='c' selected='selected'>Closed</option>";
  304.                 echo "<option value='o'>Open</option>";
  305.             } else if ($Statustrimmed == "o") {
  306.                 echo "<option value='c'>Closed</option>";
  307.                 echo "<option value='o' selected='selected'>Open</option>";
  308.             }
  309.                
  310.             echo "</td><td align=right valign=middle><font color=black>";
  311.             echo "<input type=hidden value='$Seqno' name='seqno2'>";
  312.             echo "<input type='submit' value='Save' name='submit'>";
  313.             echo "</form>";
  314.             echo"</td></tr>";
  315.            
  316.            
  317.             } else {
  318.                
  319.                
  320.                 odbc_close($conn);
  321.             }
  322.    
  323.                
  324.       }
  325.  
  326.       echo "</table>";
  327.       echo "<br />";
  328.       echo "<table cellspacing=0 cellpadding=3 wight=670>";          
  329.       echo "<tr><td align=right width=670></td></tr>";
  330.       echo "</table>";
  331.    
  332.     ?>
  333.  
  334. <?php
  335.                    
  336.     $countrows = 0;
  337.     $rownum = 0;
  338.     $showheader = 0;
  339.    
  340.     $data_source ='vshopqld';
  341.     $user = 'vshoptest';
  342.     $password = 'lifesgreat';
  343.    
  344.    
  345.     $conn = odbc_connect($data_source,$user,$password);
  346.        
  347.         $sql3 = "SELECT VN_PICKUP.customer_id, VN_PICKUP.seqno, VN_PICKUP.system_date_time, VN_PICKUP.requested_pickup_date_time, VN_PICKUP.contact, VN_PICKUP.pickup_instructions, VN_PICKUP.container_type1, VN_PICKUP.container_lbs1, VN_PICKUP.status, VN_PICKUP.pickup_delivery, VN_PICKUP.company_name FROM VN_PICKUP where VN_PICKUP.pickup_delivery = 'd' and VN_PICKUP.customer_id = 'NC' order by VN_PICKUP.status desc, VN_PICKUP.requested_pickup_date_time desc";
  348.            
  349.         $stmt3 = odbc_exec($conn,$sql3);
  350.  
  351.    
  352.     odbc_fetch_row($stmt3, 0);
  353.     WHILE (odbc_fetch_row($stmt3)) {
  354.  
  355.  
  356.     if ($showheader == 0) {
  357.     echo "<b class=link1>Non-Customer Deliveries for HTA. Click on a delivery request for more information.</b></span><br><br>";
  358.    
  359.     echo "<table cellspacing=0 cellpadding=3>";
  360.     echo "<tr bgcolor=#047178><td align=left valign=top width=150><font color=#ffffff><b>Company</b></font></td><td align=left valign=top width=100><font color=#ffffff><b>Pickup Date</b></font></td><td align=left valign=top width=120><font color=#ffffff><b>Requested By</b></font></td><td align=left valign=top width=150><font color=#ffffff><b>Item Description</b></font></td><td align=left valign=top width=70><font color=#ffffff><b>Weight</b></font></td><td align=right valign=top width=80><font color=#ffffff><b>Status</b></font></td><td align=right valign=top width=80><font color=#ffffff><b>Save</b></font></td></tr>";
  361.     $showheader = 1;
  362.     }
  363.  
  364.  
  365.       $countrows = $countrows + 1;
  366.      
  367.           $Request_Date = odbc_result($stmt3,'requested_pickup_date_time');
  368.       $Contact = odbc_result($stmt3,'contact');
  369.           $Conttype1 = odbc_result($stmt3,'container_type1');
  370.       $Contweight1 = odbc_result($stmt3,'container_lbs1');
  371.       $Statuscode = odbc_result($stmt3,'status');
  372.           $Seqno = odbc_result($stmt3,'seqno');
  373.       $Custname = odbc_result($stmt3,'company_name');
  374.       $custID = odbc_result($stmt3, 'customer_id');
  375.       $Pickupdelivery2 = odbc_result($stmt3, 'pickup_delivery');
  376.  
  377.       $Pickupdelivery2trimmed = trim($Pickupdelivery2);
  378.       $Statustrimmed = trim($Statuscode);
  379.      
  380.       $year = substr($Request_Date,0,4);
  381.       $month = substr($Request_Date,5,2);
  382.       $day = substr($Request_Date,8,2);
  383.  
  384.            
  385.             if ($countrows < '21') {
  386.            
  387.                
  388.             if ($rownum == "1" ) {
  389.             $bgcolor = "#EEEEEE";
  390.             $rownum = "0";
  391.             } else {
  392.             $bgcolor = "#b4ebee";
  393.             $rownum = "1";
  394.             }
  395.  
  396.                
  397.             echo "<tr bgcolor='" . $bgcolor . "'><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Custname . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $day . "/" . $month . "/" . $year . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Contact . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Conttype1 . "</a></td><td align=left valign=middle><font color=black><a href=page.php?page=viewpickups2&seqno=" . $Seqno . "&custid=" . $custID . ">" . $Contweight1 . "</a></td><td align=right valign=middle><font color=black>";
  398.             echo "<form method=post action=''>";
  399.             echo "<select name=status2>";
  400.             if ($Statustrimmed == "c") {
  401.                 echo "<option value='c' selected='selected'>Closed</option>";
  402.                 echo "<option value='o'>Open</option>";
  403.             } else if ($Statustrimmed == "o") {
  404.                 echo "<option value='c'>Closed</option>";
  405.                 echo "<option value='o' selected='selected'>Open</option>";
  406.             }
  407.                
  408.             echo "</td><td align=right valign=middle><font color=black>";
  409.             echo "<input type=hidden value='$Seqno' name='seqno2'>";
  410.             echo "<input type='submit' value='Save' name='submit'>";
  411.             echo "</form>";
  412.             echo"</td></tr>";
  413.            
  414.            
  415.             } else {
  416.                
  417.                
  418.                 odbc_close($conn);
  419.                 echo "Nothing found";
  420.             }
  421.    
  422.                
  423.       }
  424.  
  425.       echo "</table>";
  426.       echo "<br />";
  427.       echo "<table cellspacing=0 cellpadding=3 wight=670>";          
  428.       echo "<tr><td align=right width=670></td></tr>";
  429.       echo "</table>";
  430.    
  431.     ?>
  432.                
  433. </h2>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!