1<?php 2 3 4include('includes/session.php'); 5 6$Title = _('Search All Sales Orders'); 7 8include('includes/header.php'); 9 10echo '<p class="page_title_text"><img src="'.$RootPath.'/css/'.$Theme.'/images/magnifier.png" title="' . _('Search') . '" alt="" /> 11 ' . ' ' . _('Search Sales Orders') . '</p>'; 12 13echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '" method="post">'; 14echo '<div>'; 15echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; 16 17if (isset($_POST['completed'])) { 18 $Completed="=1"; 19 $ShowChecked="checked='checked'"; 20} else { 21 $Completed=">=0"; 22 $ShowChecked=''; 23} 24 25if (isset($_GET['SelectedStockItem'])){ 26 $SelectedStockItem = $_GET['SelectedStockItem']; 27} elseif (isset($_POST['SelectedStockItem'])){ 28 $SelectedStockItem = $_POST['SelectedStockItem']; 29} 30if (isset($_GET['OrderNumber'])){ 31 $OrderNumber = filter_number_format($_GET['OrderNumber']); 32} elseif (isset($_POST['OrderNumber'])){ 33 $OrderNumber = filter_number_format($_POST['OrderNumber']); 34} 35if (isset($_GET['CustomerRef'])){ 36 $CustomerRef = $_GET['CustomerRef']; 37 $CustomerGet = 1; 38} elseif (isset($_POST['CustomerRef'])){ 39 $CustomerRef = $_POST['CustomerRef']; 40} 41if (isset($_GET['SelectedCustomer'])){ 42 $SelectedCustomer = $_GET['SelectedCustomer']; 43} elseif (isset($_POST['SelectedCustomer'])){ 44 $SelectedCustomer = $_POST['SelectedCustomer']; 45} 46 47if ($CustomerLogin==1){ 48 $SelectedCustomer = $_SESSION['CustomerID']; 49} 50 51if (isset($SelectedStockItem) AND $SelectedStockItem==''){ 52 unset($SelectedStockItem); 53} 54if (isset($OrderNumber) AND $OrderNumber==''){ 55 unset($OrderNumber); 56} 57if (isset($CustomerRef) AND $CustomerRef==''){ 58 unset($CustomerRef); 59} 60if (isset($SelectedCustomer) AND $SelectedCustomer==''){ 61 unset($SelectedCustomer); 62} 63if (isset($_POST['ResetPart'])) { 64 unset($SelectedStockItem); 65} 66 67if (isset($OrderNumber)) { 68 echo '<p class="page_title_text"><img src="'.$RootPath.'/css/'.$Theme.'/images/sales.png" title="' . _('Sales Order') . '" alt="" /> 69 ' . ' ' . _('Order Number') . ' - ' . $OrderNumber . '</p>'; 70 if (mb_strlen($_SESSION['UserBranch'])>1){ 71 echo _('For customer') . ': ' . $SelectedCustomer; 72 echo '<input type="hidden" name="SelectedCustomer" value="' . $SelectedCustomer .'" />'; 73 } 74} elseif (isset($CustomerRef)) { 75 echo _('Customer Ref') . ' - ' . $CustomerRef; 76 if (mb_strlen($_SESSION['UserBranch'])>1){ 77 echo ' ' . _('and for customer') . ': ' . $SelectedCustomer .' ' . _('and') . ' '; 78 echo '<input type="hidden" name="SelectedCustomer" value="' .$SelectedCustomer .'" />'; 79 } 80} else { 81 if (isset($SelectedCustomer)) { 82 echo _('For customer') . ': ' . $SelectedCustomer .' ' . _('and') . ' '; 83 echo '<input type="hidden" name="SelectedCustomer" value="'.$SelectedCustomer.'" />'; 84 } 85 86 if (isset($SelectedStockItem)) { 87 88 $PartString = _('for the part') . ': <b>' . $SelectedStockItem . '</b> ' . _('and') . ' ' . 89 '<input type="hidden" name="SelectedStockItem" value="'.$SelectedStockItem.'" />'; 90 91 } 92} 93 94if (isset($_POST['SearchParts']) AND $_POST['SearchParts']!=''){ 95 96 if ($_POST['Keywords']!='' AND $_POST['StockCode']!='') { 97 echo _('Stock description keywords have been used in preference to the Stock code extract entered'); 98 } 99 if ($_POST['Keywords']!='') { 100 //insert wildcard characters in spaces 101 $SearchString = '%' . str_replace(' ', '%', $_POST['Keywords']) . '%'; 102 103 if (isset($_POST['completed'])) { 104 $SQL = "SELECT stockmaster.stockid, 105 stockmaster.description, 106 stockmaster.decimalplaces, 107 SUM(locstock.quantity) AS qoh, 108 SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo, 109 stockmaster.units, 110 SUM(salesorderdetails.quantity - salesorderdetails.qtyinvoiced) AS qdem 111 FROM (((stockmaster LEFT JOIN salesorderdetails on stockmaster.stockid = salesorderdetails.stkcode) 112 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid) 113 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 114 WHERE salesorderdetails.completed =1 115 AND stockmaster.description " . LIKE . " '" . $SearchString. "' 116 AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 117 GROUP BY stockmaster.stockid, 118 stockmaster.description, 119 stockmaster.decimalplaces, 120 stockmaster.units 121 ORDER BY stockmaster.stockid"; 122 } else { 123 $SQL = "SELECT stockmaster.stockid, 124 stockmaster.description, 125 stockmaster.decimalplaces, 126 SUM(locstock.quantity) AS qoh, 127 SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo, 128 stockmaster.units, 129 SUM(salesorderdetails.quantity - salesorderdetails.qtyinvoiced) AS qdem 130 FROM (((stockmaster LEFT JOIN salesorderdetails on stockmaster.stockid = salesorderdetails.stkcode) 131 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid) 132 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 133 WHERE stockmaster.description " . LIKE . " '" . $SearchString. "' 134 AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 135 GROUP BY stockmaster.stockid, 136 stockmaster.description, 137 stockmaster.decimalplaces, 138 stockmaster.units 139 ORDER BY stockmaster.stockid"; 140 } 141 142 } elseif ($_POST['StockCode']!=''){ 143 144 if (isset($_POST['completed'])) { 145 $SQL = "SELECT stockmaster.stockid, 146 stockmaster.description, 147 stockmaster.decimalplaces, 148 SUM(locstock.quantity) AS qoh, 149 SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo, 150 SUM(salesorderdetails.quantity - salesorderdetails.qtyinvoiced) AS qdem, 151 stockmaster.units 152 FROM (((stockmaster LEFT JOIN salesorderdetails on stockmaster.stockid = salesorderdetails.stkcode) 153 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid) 154 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 155 WHERE salesorderdetails.completed =1 156 AND stockmaster.stockid " . LIKE . " '%" . $_POST['StockCode'] . "%' 157 AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 158 GROUP BY stockmaster.stockid, 159 stockmaster.description, 160 stockmaster.decimalplaces, 161 stockmaster.units 162 ORDER BY stockmaster.stockid"; 163 } else { 164 $SQL = "SELECT stockmaster.stockid, 165 stockmaster.description, 166 stockmaster.decimalplaces, 167 SUM(locstock.quantity) AS qoh, 168 SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo, 169 SUM(salesorderdetails.quantity - salesorderdetails.qtyinvoiced) AS qdem, 170 stockmaster.units 171 FROM (((stockmaster LEFT JOIN salesorderdetails on stockmaster.stockid = salesorderdetails.stkcode) 172 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid) 173 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 174 WHERE stockmaster.stockid " . LIKE . " '%" . $_POST['StockCode'] . "%' 175 AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 176 GROUP BY stockmaster.stockid, 177 stockmaster.description, 178 stockmaster.decimalplaces, 179 stockmaster.units 180 ORDER BY stockmaster.stockid"; 181 } 182 183 } elseif ($_POST['StockCode']=='' AND $_POST['Keywords']=='' AND $_POST['StockCat']!='') { 184 185 if (isset($_POST['completed'])) { 186 $SQL = "SELECT stockmaster.stockid, 187 stockmaster.description, 188 stockmaster.decimalplaces, 189 SUM(locstock.quantity) AS qoh, 190 SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo, 191 SUM(salesorderdetails.quantity - salesorderdetails.qtyinvoiced) AS qdem, 192 stockmaster.units 193 FROM (((stockmaster LEFT JOIN salesorderdetails on stockmaster.stockid = salesorderdetails.stkcode) 194 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid) 195 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 196 WHERE salesorderdetails.completed=1 197 AND stockmaster.categoryid='" . $_POST['StockCat'] . "' 198 GROUP BY stockmaster.stockid, 199 stockmaster.description, 200 stockmaster.decimalplaces, 201 stockmaster.units 202 ORDER BY stockmaster.stockid"; 203 } else { 204 $SQL = "SELECT stockmaster.stockid, 205 stockmaster.description, 206 stockmaster.decimalplaces, 207 SUM(locstock.quantity) AS qoh, 208 SUM(purchorderdetails.quantityord-purchorderdetails.quantityrecd) AS qoo, 209 SUM(salesorderdetails.quantity - salesorderdetails.qtyinvoiced) AS qdem, 210 stockmaster.units 211 FROM (((stockmaster LEFT JOIN salesorderdetails on stockmaster.stockid = salesorderdetails.stkcode) 212 LEFT JOIN locstock ON stockmaster.stockid=locstock.stockid) 213 LEFT JOIN purchorderdetails on stockmaster.stockid = purchorderdetails.itemcode) 214 WHERE stockmaster.categoryid='" . $_POST['StockCat'] . "' 215 GROUP BY stockmaster.stockid, 216 stockmaster.description, 217 stockmaster.decimalplaces, 218 stockmaster.units 219 ORDER BY stockmaster.stockid"; 220 } 221 } 222 223 if (mb_strlen($SQL)<2){ 224 prnMsg(_('No selections have been made to search for parts') . ' - ' . _('choose a stock category or enter some characters of the code or description then try again'),'warn'); 225 } else { 226 227 $ErrMsg = _('No stock items were returned by the SQL because'); 228 $DbgMsg = _('The SQL used to retrieve the searched parts was'); 229 $StockItemsResult = DB_query($SQL,$ErrMsg,$DbgMsg); 230 231 if (DB_num_rows($StockItemsResult)==1){ 232 $myrow = DB_fetch_row($StockItemsResult); 233 $SelectedStockItem = $myrow[0]; 234 $_POST['SearchOrders']='True'; 235 unset($StockItemsResult); 236 echo '<br />' . _('For the part') . ': ' . $SelectedStockItem . ' ' . _('and') . ' <input type="hidden" name="SelectedStockItem" value="' . $SelectedStockItem . '" />'; 237 } 238 } 239} else if ((isset($_POST['SearchOrders']) AND Is_Date($_POST['OrdersAfterDate'])==1) OR (isset($CustomerGet))) { 240 241 //figure out the SQL required from the inputs available 242 if (isset($OrderNumber)) { 243 $SQL = "SELECT salesorders.orderno, 244 debtorsmaster.name, 245 custbranch.brname, 246 salesorders.customerref, 247 salesorders.orddate, 248 salesorders.deliverydate, 249 salesorders.deliverto, 250 currencies.decimalplaces AS currdecimalplaces, SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 251 FROM salesorders INNER JOIN salesorderdetails 252 ON salesorders.orderno = salesorderdetails.orderno 253 INNER JOIN debtorsmaster 254 ON salesorders.debtorno = debtorsmaster.debtorno 255 INNER JOIN custbranch 256 ON salesorders.branchcode = custbranch.branchcode 257 AND salesorders.debtorno = custbranch.debtorno 258 INNER JOIN currencies 259 ON debtorsmaster.currcode = currencies.currabrev 260 WHERE salesorders.orderno='". $OrderNumber ."' 261 AND salesorders.quotation=0 262 AND salesorderdetails.completed " . $Completed; 263 } elseif (isset($CustomerRef)) { 264 if (isset($SelectedCustomer)) { 265 $SQL = "SELECT salesorders.orderno, 266 debtorsmaster.name, 267 currencies.decimalplaces AS currdecimalplaces, 268 custbranch.brname, 269 salesorders.customerref, 270 salesorders.orddate, 271 salesorders.deliverydate, 272 salesorders.deliverto, SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 273 FROM salesorders INNER JOIN salesorderdetails 274 ON salesorders.orderno = salesorderdetails.orderno 275 INNER JOIN debtorsmaster 276 ON salesorders.debtorno = debtorsmaster.debtorno 277 INNER JOIN custbranch 278 ON salesorders.branchcode = custbranch.branchcode 279 AND salesorders.debtorno = custbranch.debtorno 280 INNER JOIN currencies 281 ON debtorsmaster.currcode = currencies.currabrev 282 WHERE salesorders.debtorno='" . $SelectedCustomer ."' 283 AND salesorders.customerref like '%". $CustomerRef."%' 284 AND salesorders.quotation=0 285 AND salesorderdetails.completed".$Completed; 286 } else { //customer not selected 287 $SQL = "SELECT salesorders.orderno, 288 debtorsmaster.name, 289 currencies.decimalplaces AS currdecimalplaces, 290 custbranch.brname, 291 salesorders.customerref, 292 salesorders.orddate, 293 salesorders.deliverydate, 294 salesorders.deliverto, SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 295 FROM salesorders INNER JOIN salesorderdetails 296 ON salesorders.orderno = salesorderdetails.orderno 297 INNER JOIN debtorsmaster 298 ON salesorders.debtorno = debtorsmaster.debtorno 299 INNER JOIN custbranch 300 ON salesorders.branchcode = custbranch.branchcode 301 AND salesorders.debtorno = custbranch.debtorno 302 INNER JOIN currencies 303 ON debtorsmaster.currcode = currencies.currabrev 304 WHERE salesorders.customerref " . LIKE . " '%". $CustomerRef . "%' 305 AND salesorders.quotation=0 306 AND salesorderdetails.completed" . $Completed; 307 } 308 309 } else { 310 $DateAfterCriteria = FormatDateforSQL($_POST['OrdersAfterDate']); 311 312 if (isset($SelectedCustomer) AND !isset($OrderNumber) AND !isset($CustomerRef)) { 313 314 if (isset($SelectedStockItem)) { 315 $SQL = "SELECT salesorders.orderno, 316 debtorsmaster.name, 317 currencies.decimalplaces AS currdecimalplaces, 318 custbranch.brname, 319 salesorders.customerref, 320 salesorders.orddate, 321 salesorders.deliverydate, 322 salesorders.deliverto, SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 323 FROM salesorders INNER JOIN salesorderdetails 324 ON salesorders.orderno = salesorderdetails.orderno 325 INNER JOIN debtorsmaster 326 ON salesorders.debtorno = debtorsmaster.debtorno 327 INNER JOIN custbranch 328 ON salesorders.branchcode = custbranch.branchcode 329 AND salesorders.debtorno = custbranch.debtorno 330 INNER JOIN currencies 331 ON debtorsmaster.currcode = currencies.currabrev 332 WHERE salesorderdetails.stkcode='". $SelectedStockItem ."' 333 AND salesorders.debtorno='" . $SelectedCustomer ."' 334 AND salesorders.orddate >= '" . $DateAfterCriteria ."' 335 AND salesorders.quotation=0 336 AND salesorderdetails.completed".$Completed; 337 } else { 338 $SQL = "SELECT salesorders.orderno, 339 debtorsmaster.name, 340 currencies.decimalplaces AS currdecimalplaces, 341 custbranch.brname, 342 salesorders.customerref, 343 salesorders.orddate, 344 salesorders.deliverto, 345 salesorders.deliverydate, SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 346 FROM salesorders INNER JOIN salesorderdetails 347 ON salesorders.orderno = salesorderdetails.orderno 348 INNER JOIN debtorsmaster 349 ON salesorders.debtorno = debtorsmaster.debtorno 350 INNER JOIN custbranch 351 ON salesorders.branchcode = custbranch.branchcode 352 AND salesorders.debtorno = custbranch.debtorno 353 INNER JOIN currencies 354 ON debtorsmaster.currcode = currencies.currabrev 355 WHERE salesorders.debtorno='" . $SelectedCustomer . "' 356 AND salesorders.orddate >= '" . $DateAfterCriteria . "' 357 AND salesorders.quotation=0 358 AND salesorderdetails.completed".$Completed; 359 } 360 } else { //no customer selected 361 if (isset($SelectedStockItem)) { 362 $SQL = "SELECT salesorders.orderno, 363 debtorsmaster.name, 364 currencies.decimalplaces AS currdecimalplaces, 365 custbranch.brname, 366 salesorders.customerref, 367 salesorders.orddate, 368 salesorders.deliverto, 369 salesorders.deliverydate, SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 370 FROM salesorders INNER JOIN salesorderdetails 371 ON salesorders.orderno = salesorderdetails.orderno 372 INNER JOIN debtorsmaster 373 ON salesorders.debtorno = debtorsmaster.debtorno 374 INNER JOIN custbranch 375 ON salesorders.branchcode = custbranch.branchcode 376 AND salesorders.debtorno = custbranch.debtorno 377 INNER JOIN currencies 378 ON debtorsmaster.currcode = currencies.currabrev 379 WHERE salesorderdetails.stkcode='". $SelectedStockItem ."' 380 AND salesorders.orddate >= '" . $DateAfterCriteria . "' 381 AND salesorders.quotation=0 382 AND salesorderdetails.completed".$Completed; 383 } else { 384 $SQL = "SELECT salesorders.orderno, 385 debtorsmaster.name, 386 currencies.decimalplaces AS currdecimalplaces, 387 custbranch.brname, 388 salesorders.customerref, 389 salesorders.orddate, 390 salesorders.deliverto, 391 salesorders.deliverydate, SUM(salesorderdetails.unitprice*salesorderdetails.quantity*(1-salesorderdetails.discountpercent)) AS ordervalue 392 FROM salesorders INNER JOIN salesorderdetails 393 ON salesorders.orderno = salesorderdetails.orderno 394 INNER JOIN debtorsmaster 395 ON salesorders.debtorno = debtorsmaster.debtorno 396 INNER JOIN custbranch 397 ON salesorders.branchcode = custbranch.branchcode 398 AND salesorders.debtorno = custbranch.debtorno 399 INNER JOIN currencies 400 ON debtorsmaster.currcode = currencies.currabrev 401 WHERE salesorders.orddate >= '".$DateAfterCriteria . "' 402 AND salesorders.quotation=0 403 AND salesorderdetails.completed".$Completed; 404 } 405 } //end selected customer 406 } //end not order number selected 407 408 if ($_SESSION['SalesmanLogin'] != '') { 409 $SQL .= " AND salesorders.salesperson='" . $_SESSION['SalesmanLogin'] . "'"; 410 } 411 $SQL .= " GROUP BY salesorders.orderno, 412 debtorsmaster.name, 413 currencies.decimalplaces, 414 custbranch.brname, 415 salesorders.customerref, 416 salesorders.orddate, 417 salesorders.deliverydate, 418 salesorders.deliverto 419 ORDER BY salesorders.orderno"; 420 421 $SalesOrdersResult = DB_query($SQL); 422 423 if (DB_error_no() !=0) { 424 prnMsg( _('No orders were returned by the SQL because') . ' ' . DB_error_msg(), 'info'); 425 echo '<br /> ' . $SQL; 426 } 427 428}//end of which button clicked options 429 430if (!isset($_POST['OrdersAfterDate']) OR $_POST['OrdersAfterDate'] == '' OR ! Is_Date($_POST['OrdersAfterDate'])){ 431 $_POST['OrdersAfterDate'] = Date($_SESSION['DefaultDateFormat'],Mktime(0,0,0,Date('m')-2,Date('d'),Date('Y'))); 432} 433echo '<table class="selection">'; 434 435if (isset($PartString)) { 436 echo '<tr><td>' . $PartString . '</td>'; 437} else { 438 echo '<tr><td></td>'; 439} 440if (!isset($_POST['OrderNumber'])){ 441 $_POST['OrderNumber']=''; 442} 443echo '<td>' . _('Order Number') . ':</td> 444 <td><input type="text" name="OrderNumber" maxlength="8" size="9" value ="' . $_POST['OrderNumber'] . '" /></td> 445 <td>' . _('for all orders placed after') . ': </td> 446 <td><input type="text" class="date" name="OrdersAfterDate" maxlength="10" size="11" value="' . $_POST['OrdersAfterDate'] . '" /></td> 447 <td><input type="submit" name="SearchOrders" value="' . _('Search Orders') . '" /></td> 448 </tr>'; 449echo '<tr> 450 <td></td> 451 <td>' . _('Customer Ref') . ':</td><td><input type="text" name="CustomerRef" maxlength="8" size="9" /></td> 452 <td></td> 453 <td colspan="2"><input type="checkbox" ' . $ShowChecked . ' name="completed" />' . _('Show Completed orders only') . '</td></tr>'; 454 455echo '</table>'; 456 457if (!isset($SelectedStockItem)) { 458 $result1 = DB_query("SELECT categoryid, 459 categorydescription 460 FROM stockcategory 461 ORDER BY categorydescription"); 462 463 echo '<br />'; 464 echo '<div class="page_help_text">' . _('To search for sales orders for a specific part use the part selection facilities below') . '</div>'; 465 echo '<br /> 466 <table class="selection">'; 467 echo '<tr><td>' . _('Select a stock category') . ':'; 468 echo '<select name="StockCat">'; 469 470 while ($myrow1 = DB_fetch_array($result1)) { 471 if (isset($_POST['StockCat']) AND $myrow1['categoryid'] == $_POST['StockCat']){ 472 echo '<option selected="selected" value="' . $myrow1['categoryid'] . '">' . $myrow1['categorydescription'] . '</option>'; 473 } else { 474 echo '<option value="'. $myrow1['categoryid'] . '">' . $myrow1['categorydescription'] . '</option>'; 475 } 476 } 477 478 echo '</select></td> 479 <td>' . _('Enter text extracts in the description') . ':</td> 480 <td><input type="text" name="Keywords" size="20" maxlength="25" /></td> 481 </tr> 482 <tr> 483 <td></td> 484 <td><b> ' ._('OR') . ' </b>' . _('Enter extract of the Stock Code') . ':</td> 485 <td><input type="text" name="StockCode" size="15" maxlength="18" /></td> 486 </tr> 487 <tr><td colspan="4"><div class="centre"><input type="submit" name="SearchParts" value="' . _('Search Parts Now') . '" />'; 488 489 if (count($_SESSION['AllowedPageSecurityTokens'])>1){ 490 echo '<input type="submit" name="ResetPart" value="' . _('Show All') . '" /></div>'; 491 } 492 echo '</td> 493 </tr> 494 </table>'; 495 496} 497 498If (isset($StockItemsResult)) { 499 500 echo '<br /> 501 <table cellpadding="2" class="selection">'; 502 503 $TableHeadings = '<tr> 504 <th>' . _('Code') . '</th> 505 <th>' . _('Description') . '</th> 506 <th>' . _('On Hand') . '</th> 507 <th>' . _('Purchase Orders') . '</th> 508 <th>' . _('Sales Orders') . '</th> 509 <th>' . _('Units') . '</th> 510 </tr>'; 511 512 echo $TableHeadings; 513 514 $j = 1; 515 516 while ($myrow=DB_fetch_array($StockItemsResult)) { 517 518 printf('<tr class="striped_row"> 519 <td><input type="submit" name="SelectedStockItem" value="%s" /></td> 520 <td>%s</td> 521 <td class="number">%s</td> 522 <td class="number">%s</td> 523 <td class="number">%s</td> 524 <td>%s</td></tr>', 525 $myrow['stockid'], 526 $myrow['description'], 527 locale_number_format($myrow['qoh'],$myrow['decimalplaces']), 528 locale_number_format($myrow['qoo'],$myrow['decimalplaces']), 529 locale_number_format($myrow['qdem'],$myrow['decimalplaces']), 530 $myrow['units']); 531 532//end of page full new headings if 533 } 534//end of while loop 535 536 echo '</table>'; 537 538} 539//end if stock search results to show 540 541If (isset($SalesOrdersResult)) { 542 if (DB_num_rows($SalesOrdersResult) == 1) { 543 if (!isset($OrderNumber)) { 544 $ordrow = DB_fetch_array($SalesOrdersResult); 545 $OrderNumber = $ordrow['orderno']; 546 } 547 echo '<meta http-equiv="refresh" content="0; url=' . $RootPath . '/OrderDetails.php?OrderNumber=' . $OrderNumber. '">'; 548 exit; 549 } 550 551/*show a table of the orders returned by the SQL */ 552 553 echo '<br /><table cellpadding="2" width="90%" class="selection">'; 554 555 $tableheader = '<tr><th>' . _('Order') . ' #</th> 556 <th>' . _('Customer') . '</th> 557 <th>' . _('Branch') . '</th> 558 <th>' . _('Cust Order') . ' #</th> 559 <th>' . _('Order Date') . '</th> 560 <th>' . _('Req Del Date') . '</th> 561 <th>' . _('Delivery To') . '</th> 562 <th>' . _('Order Total') . '</th> 563 </tr>'; 564 565 echo $tableheader; 566 567 $j = 1; 568 569 while ($myrow=DB_fetch_array($SalesOrdersResult)) { 570 571 $ViewPage = $RootPath . '/OrderDetails.php?OrderNumber=' . $myrow['orderno']; 572 $FormatedDelDate = ConvertSQLDate($myrow['deliverydate']); 573 $FormatedOrderDate = ConvertSQLDate($myrow['orddate']); 574 $FormatedOrderValue = locale_number_format($myrow['ordervalue'],$myrow['currdecimalplaces']); 575 576 printf('<tr class="striped_row"> 577 <td><a href="%s">%s</a></td> 578 <td>%s</td> 579 <td>%s</td> 580 <td>%s</td> 581 <td>%s</td> 582 <td>%s</td> 583 <td>%s</td> 584 <td class="number">%s</td> 585 </tr>', 586 $ViewPage, 587 $myrow['orderno'], 588 $myrow['name'], 589 $myrow['brname'], 590 $myrow['customerref'], 591 $FormatedOrderDate, 592 $FormatedDelDate, 593 $myrow['deliverto'], 594 $FormatedOrderValue); 595 596//end of page full new headings if 597 } 598//end of while loop 599 600 echo '</table>'; 601} 602 603echo '</div> 604 </form>'; 605include('includes/footer.php'); 606 607?> 608
