Care2007/modules/weberp/RecurringSalesOrders.php

   1 <?php
   2 /* $Revision: 1.9 $ */
   3 /* This is where the details specific to the recurring order are entered and the template committed to the database once the Process button is hit */
   4
   5 include('includes/DefineCartClass.php');
   6
   7 /* Session started in header.inc for password checking the session will contain the details of the order from the Cart class object. The details of the order come from SelectOrderItems.php */
   8
   9 $PageSecurity=1;
  10 include('includes/session.inc');
  11 $title = _('Recurring Orders');
  12 include('includes/header.inc');
  13
  14
  15 if ($_GET['NewRecurringOrder']=='Yes'){
  16         $NewRecurringOrder ='Yes';
  17 } elseif ($_POST['NewRecurringOrder']=='Yes'){
  18         $NewRecurringOrder ='Yes';
  19 } else {
  20         $NewRecurringOrder ='No';
  21         if (isset($_GET['ModifyRecurringSalesOrder'])){
  22
  23                 $_POST['ExistingRecurrOrderNo'] = $_GET['ModifyRecurringSalesOrder'];
  24
  25                 /*Need to read in the existing recurring order template */
  26
  27                 $_SESSION['Items'] = new cart;
  28
  29                 /*read in all the guff from the selected order into the Items cart  */
  30
  31                 $OrderHeaderSQL = 'SELECT recurringsalesorders.debtorno,
  32                                 debtorsmaster.name,
  33                                 recurringsalesorders.branchcode,
  34                                 recurringsalesorders.customerref,
  35                                 recurringsalesorders.comments,
  36                                 recurringsalesorders.orddate,
  37                                 recurringsalesorders.ordertype,
  38                                 salestypes.sales_type,
  39                                 recurringsalesorders.shipvia,
  40                                 recurringsalesorders.deliverto,
  41                                 recurringsalesorders.deladd1,
  42                                 recurringsalesorders.deladd2,
  43                                 recurringsalesorders.deladd3,
  44                                 recurringsalesorders.deladd4,
  45                                 recurringsalesorders.deladd5,
  46                                 recurringsalesorders.deladd6,
  47                                 recurringsalesorders.contactphone,
  48                                 recurringsalesorders.contactemail,
  49                                 recurringsalesorders.freightcost,
  50                                 debtorsmaster.currcode,
  51                                 recurringsalesorders.fromstkloc,
  52                                 recurringsalesorders.frequency,
  53                                 recurringsalesorders.stopdate,
  54                                 recurringsalesorders.lastrecurrence,
  55                                 recurringsalesorders.autoinvoice
  56                         FROM recurringsalesorders,
  57                                 debtorsmaster,
  58                                 salestypes
  59                         WHERE recurringsalesorders.ordertype=salestypes.typeabbrev
  60                         AND recurringsalesorders.debtorno = debtorsmaster.debtorno
  61                         AND recurringsalesorders.recurrorderno = ' . $_GET['ModifyRecurringSalesOrder'];
  62
  63                 $ErrMsg =  _('The order cannot be retrieved because');
  64                 $GetOrdHdrResult = DB_query($OrderHeaderSQL,$db,$ErrMsg);
  65
  66                 if (DB_num_rows($GetOrdHdrResult)==1) {
  67
  68                         $myrow = DB_fetch_array($GetOrdHdrResult);
  69
  70                         $_SESSION['Items']->DebtorNo = $myrow['debtorno'];
  71         /*CustomerID defined in header.inc */
  72                         $_SESSION['Items']->Branch = $myrow['branchcode'];
  73                         $_SESSION['Items']->CustomerName = $myrow['name'];
  74                         $_SESSION['Items']->CustRef = $myrow['customerref'];
  75                         $_SESSION['Items']->Comments = $myrow['comments'];
  76
  77                         $_SESSION['Items']->DefaultSalesType =$myrow['ordertype'];
  78                         $_SESSION['Items']->SalesTypeName =$myrow['sales_type'];
  79                         $_SESSION['Items']->DefaultCurrency = $myrow['currcode'];
  80                         $_SESSION['Items']->ShipVia = $myrow['shipvia'];
  81                         $BestShipper = $myrow['shipvia'];
  82                         $_SESSION['Items']->DeliverTo = $myrow['deliverto'];
  83                         $_SESSION['Items']->DeliveryDate = ConvertSQLDate($myrow['deliverydate']);
  84                         $_SESSION['Items']->BrAdd1 = $myrow['deladd1'];
  85                         $_SESSION['Items']->BrAdd2 = $myrow['deladd2'];
  86                         $_SESSION['Items']->BrAdd3 = $myrow['deladd3'];
  87                         $_SESSION['Items']->BrAdd4 = $myrow['deladd4'];
  88                         $_SESSION['Items']->BrAdd5 = $myrow['deladd5'];
  89                         $_SESSION['Items']->BrAdd6 = $myrow['deladd6'];
  90                         $_SESSION['Items']->PhoneNo = $myrow['contactphone'];
  91                         $_SESSION['Items']->Email = $myrow['contactemail'];
  92                         $_SESSION['Items']->Location = $myrow['fromstkloc'];
  93                         $_SESSION['Items']->Quotation = 0;
  94                         $FreightCost = $myrow['freightcost'];
  95                         $_SESSION['Items']->Orig_OrderDate = $myrow['orddate'];
  96                         $_POST['StopDate'] = ConvertSQLDate($myrow['stopdate']);
  97                         $_POST['StartDate'] = ConvertSQLDate($myrow['lastrecurrence']);
  98                         $_POST['Frequency'] = $myrow['frequency'];
  99                         $_POST['AutoInvoice'] = $myrow['autoinvoice'];
 100
 101         /*need to look up customer name from debtors master then populate the line items array with the sales order details records */
 102                         $LineItemsSQL = "SELECT recurrsalesorderdetails.stkcode,
 103                                         stockmaster.description,
 104                                         stockmaster.volume,
 105                                         stockmaster.kgs,
 106                                         stockmaster.units,
 107                                         recurrsalesorderdetails.unitprice,
 108                                         recurrsalesorderdetails.quantity,
 109                                         recurrsalesorderdetails.discountpercent,
 110                                         recurrsalesorderdetails.narrative,
 111                                         locstock.quantity as qohatloc,
 112                                         stockmaster.mbflag,
 113                                         stockmaster.discountcategory,
 114                                         stockmaster.decimalplaces
 115                                         FROM recurrsalesorderdetails INNER JOIN stockmaster
 116                                         ON recurrsalesorderdetails.stkcode = stockmaster.stockid
 117                                         INNER JOIN locstock ON locstock.stockid = stockmaster.stockid
 118                                         WHERE  locstock.loccode = '" . $myrow['fromstkloc'] . "'
 119                                         AND recurrsalesorderdetails.recurrorderno =" . $_GET['ModifyRecurringSalesOrder'];
 120
 121                         $ErrMsg = _('The line items of the order cannot be retrieved because');
 122                         $LineItemsResult = db_query($LineItemsSQL,$db,$ErrMsg);
 123                         if (db_num_rows($LineItemsResult)>0) {
 124
 125                                 while ($myrow=db_fetch_array($LineItemsResult)) {
 126                                         $_SESSION['Items']->add_to_cart($myrow['stkcode'],
 127                                                                 $myrow['quantity'],
 128                                                                 $myrow['description'],
 129                                                                 $myrow['unitprice'],
 130                                                                 $myrow['discountpercent'],
 131                                                                 $myrow['units'],
 132                                                                 $myrow['volume'],
 133                                                                 $myrow['kgs'],
 134                                                                 $myrow['qohatloc'],
 135                                                                 $myrow['mbflag'],
 136                                                                 '',
 137                                                                 0,
 138                                                                 $myrow['discountcategory'],
 139                                                                 0,      /*Controlled*/
 140                                                                 0,      /*Serialised */
 141                                                                 $myrow['decimalplaces'],
 142                                                                 $myrow['narrative']);
 143                                         /*Just populating with existing order - no DBUpdates */
 144
 145                                 } /* line items from sales order details */
 146                         } //end of checks on returned data set
 147                 }
 148         }
 149 }
 150
 151 if ((!isset($_SESSION['Items']) OR $_SESSION['Items']->ItemsOrdered == 0) AND $NewRecurringOrder=='Yes'){
 152         prnMsg(_('A new recurring order can only be created if an order template has already been created from the normal order entry screen') . '. ' . _('To enter an order template select sales order entry from the orders tab of the main menu'),'error');
 153         include('includes/footer.inc');
 154         exit;
 155 }
 156
 157
 158 if (isset($_POST['DeleteRecurringOrder'])){
 159         $sql = 'DELETE FROM recurrsalesorderdetails WHERE recurrorderno=' . $_POST['ExistingRecurrOrderNo'];
 160         $ErrMsg = _('Could not delete recurring sales order lines for the recurring order template') . ' ' . $_POST['ExistingRecurrOrderNo'];
 161         $result = DB_query($sql,$db,$ErrMsg);
 162
 163         $sql = 'DELETE FROM recurringsalesorders WHERE recurrorderno=' . $_POST['ExistingRecurrOrderNo'];
 164         $ErrMsg = _('Could not delete the recurring sales order template number') . ' ' . $_POST['ExistingRecurrOrderNo'];
 165         $result = DB_query($sql,$db,$ErrMsg);
 166
 167         prnMsg(_('Successfully deleted recurring sales order template number') . ' ' . $_POST['ExistingRecurrOrderNo'],'success');
 168
 169         echo "<P><A HREF='$rootpath/SelectRecurringSalesOrder.php?" . SID . "'>". _('Select A Recurring Sales Order Template') .'</A>';
 170
 171         unset($_SESSION['Items']->LineItems);
 172         unset($_SESSION['Items']);
 173         include('includes/footer.inc');
 174         exit;
 175 }
 176 If (isset($_POST['Process'])) {
 177         $InputErrors =0;
 178         If (!Is_Date($_POST['StartDate'])){
 179                 $InputErrors =1;
 180                 prnMsg(_('The last recurrance or start date of this recurring order must be a valid date in the format') . ' ' . $_SESSION['DefaultDateFormat'],'error');
 181         }
 182         If (!Is_Date($_POST['StopDate'])){
 183                 $InputErrors =1;
 184                 prnMsg(_('The end date of this recurring order must be a valid date in the format') . ' ' . $_SESSION['DefaultDateFormat'],'error');
 185         }
 186         If (Date1GreaterThanDate2 ($_POST['StartDate'],$_POST['StopDate'])){
 187                 $InputErrors =1;
 188                 prnMsg(_('The end date of this recurring order must be after the start date'),'error');
 189         }
 190         if (isset($_POST['MakeRecurringOrder']) AND $_POST['Quotation']==1){
 191                 $InputErrors =1;
 192                 prnMsg( _('A recurring order cannot be made from a quotation'),'error');
 193         }
 194
 195         if ($InputErrors == 0 ){  /*Error checks above all passed ok so lets go*/
 196
 197                 if ($NewRecurringOrder=='Yes'){
 198
 199                         /* finally write the recurring order header to the database and then the line details*/
 200
 201                         $DelDate = FormatDateforSQL($_SESSION['Items']->DeliveryDate);
 202
 203                         $HeaderSQL = "INSERT INTO recurringsalesorders (
 204                                         debtorno,
 205                                         branchcode,
 206                                         customerref,
 207                                         comments,
 208                                         orddate,
 209                                         ordertype,
 210                                         deliverto,
 211                                         deladd1,
 212                                         deladd2,
 213                                         deladd3,
 214                                         deladd4,
 215                                         deladd5,
 216                                         deladd6,
 217                                         contactphone,
 218                                         contactemail,
 219                                         freightcost,
 220                                         fromstkloc,
 221                                         shipvia,
 222                                         lastrecurrence,
 223                                         stopdate,
 224                                         frequency,
 225                                         autoinvoice)
 226                                 VALUES (
 227                                         '" . $_SESSION['Items']->DebtorNo . "',
 228                                         '" . $_SESSION['Items']->Branch . "',
 229                                         '". DB_escape_string($_SESSION['Items']->CustRef) ."',
 230                                         '". DB_escape_string($_SESSION['Items']->Comments) ."',
 231                                         '" . Date("Y-m-d H:i") . "',
 232                                         '" . $_SESSION['Items']->DefaultSalesType . "',
 233                                         '" . DB_escape_string($_SESSION['Items']->DeliverTo) . "',
 234                                         '" . DB_escape_string($_SESSION['Items']->BrAdd1) . "',
 235                                         '" . DB_escape_string($_SESSION['Items']->BrAdd2) . "',
 236                                         '" . DB_escape_string($_SESSION['Items']->BrAdd3) . "',
 237                                         '" . DB_escape_string($_SESSION['Items']->BrAdd4) . "',
 238                                         '" . DB_escape_string($_SESSION['Items']->BrAdd5) . "',
 239                                         '" . DB_escape_string($_SESSION['Items']->BrAdd6) . "',
 240                                         '" . DB_escape_string($_SESSION['Items']->PhoneNo) . "',
 241                                         '" . DB_escape_string($_SESSION['Items']->Email) . "',
 242                                         " . $_SESSION['Items']->FreightCost .",
 243                                         '" . $_SESSION['Items']->Location ."',
 244                                         '" . $_SESSION['Items']->ShipVia ."',
 245                                         '" . FormatDateforSQL($_POST['StartDate']) . "',
 246                                         '" . FormatDateforSQL($_POST['StopDate']) . "',
 247                                         " . $_POST['Frequency'] .',
 248                                         ' . $_POST['AutoInvoice'] . ')';
 249
 250                         $ErrMsg = _('The recurring order cannot be added because');
 251                         $InsertQryResult = DB_query($HeaderSQL,$db,$ErrMsg);
 252
 253                         $RecurrOrderNo = DB_Last_Insert_ID($db,'recurringsalesorders','recurrorderno');
 254                         $StartOf_LineItemsSQL = "INSERT INTO recurrsalesorderdetails (
 255                                                 recurrorderno,
 256                                                 stkcode,
 257                                                 unitprice,
 258                                                 quantity,
 259                                                 discountpercent,
 260                                                 narrative)
 261                                         VALUES (";
 262
 263                         foreach ($_SESSION['Items']->LineItems as $StockItem) {
 264
 265                                 $LineItemsSQL = $StartOf_LineItemsSQL .
 266                                         $RecurrOrderNo . ",
 267                                         '" . $StockItem->StockID . "',
 268                                         ". $StockItem->Price . ",
 269                                         " . $StockItem->Quantity . ",
 270                                         " . $StockItem->DiscountPercent . ",
 271                                         '" . DB_escape_string($StockItem->Narrative) . "'
 272                                 )";
 273                                 $Ins_LineItemResult = DB_query($LineItemsSQL,$db);
 274                         } /* inserted line items into sales order details */
 275
 276                         prnmsg(_('The new recurring order template has been added'),'success');
 277
 278                 } else { /* must be updating an existing recurring order */
 279                         $HeaderSQL = "UPDATE recurringsalesorders SET
 280                                                 stopdate =  '" . FormatDateforSQL($_POST['StopDate']) . "',
 281                                                 frequency = " . $_POST['Frequency'] . ",
 282                                                 autoinvoice = " . $_POST['AutoInvoice'] . '
 283                                         WHERE recurrorderno = ' . $_POST['ExistingRecurrOrderNo'];
 284
 285                         $ErrMsg = _('The recurring order cannot be updated because');
 286                         $UpdateQryResult = DB_query($HeaderSQL,$db,$ErrMsg);
 287                         prnmsg(_('The recurring order template has been updated'),'success');
 288                 }
 289
 290         echo "<P><A HREF='$rootpath/SelectOrderItems.php?" . SID . "&NewOrder=Yes'>". _('Enter New Sales Order') .'</A>';
 291
 292         echo "<P><A HREF='$rootpath/SelectRecurringSalesOrder.php?" . SID . "'>". _('Select A Recurring Sales Order Template') .'</A>';
 293
 294         unset($_SESSION['Items']->LineItems);
 295         unset($_SESSION['Items']);
 296         include('includes/footer.inc');
 297         exit;
 298
 299         }
 300 }
 301
 302 echo '<CENTER><FONT SIZE=4><B>'. _('Recurring Order for Customer') .' : ' . $_SESSION['Items']->CustomerName . '</B></FONT></CENTER>';
 303 echo "<FORM ACTION='" . $_SERVER['PHP_SELF'] . '?' . $SID . "' METHOD=POST>";
 304
 305
 306 echo "<CENTER>
 307 <TABLE CELLPADDING=2 COLSPAN=7 BORDER=1>
 308 <TR>
 309         <TD class='tableheader'>". _('Item Code') ."</TD>
 310         <TD class='tableheader'>". _('Item Description') ."</TD>
 311         <TD class='tableheader'>". _('Quantity') ."</TD>
 312         <TD class='tableheader'>". _('Unit') ."</TD>
 313         <TD class='tableheader'>". _('Price') ."</TD>
 314         <TD class='tableheader'>". _('Discount') ." %</TD>
 315         <TD class='tableheader'>". _('Total') ."</TD>
 316 </TR>";
 317
 318 $_SESSION['Items']->total = 0;
 319 $_SESSION['Items']->totalVolume = 0;
 320 $_SESSION['Items']->totalWeight = 0;
 321 $k = 0; //row colour counter
 322
 323 foreach ($_SESSION['Items']->LineItems as $StockItem) {
 324
 325         $LineTotal = $StockItem->Quantity * $StockItem->Price * (1 - $StockItem->DiscountPercent);
 326         $DisplayLineTotal = number_format($LineTotal,2);
 327         $DisplayPrice = number_format($StockItem->Price,2);
 328         $DisplayQuantity = number_format($StockItem->Quantity,$StockItem->DecimalPlaces);
 329         $DisplayDiscount = number_format(($StockItem->DiscountPercent * 100),2);
 330
 331
 332         if ($k==1){
 333                 echo "<tr bgcolor='#CCCCCC'>";
 334                 $k=0;
 335         } else {
 336                 echo "<tr bgcolor='#EEEEEE'>";
 337                 $k=1;
 338         }
 339
 340                 echo "<TD>$StockItem->StockID</TD>
 341                         <TD>$StockItem->ItemDescription</TD>
 342                         <TD ALIGN=RIGHT>$DisplayQuantity</TD>
 343                         <TD>$StockItem->Units</TD>
 344                         <TD ALIGN=RIGHT>$DisplayPrice</TD>
 345                         <TD ALIGN=RIGHT>$DisplayDiscount</TD>
 346                         <TD ALIGN=RIGHT>$DisplayLineTotal</TD>
 347                         </TR>";
 348
 349         $_SESSION['Items']->total = $_SESSION['Items']->total + $LineTotal;
 350         $_SESSION['Items']->totalVolume = $_SESSION['Items']->totalVolume + ($StockItem->Quantity * $StockItem->Volume);
 351         $_SESSION['Items']->totalWeight = $_SESSION['Items']->totalWeight + ($StockItem->Quantity * $StockItem->Weight);
 352 }
 353
 354 $DisplayTotal = number_format($_SESSION['Items']->total,2);
 355 echo "<TR>
 356         <TD COLSPAN=6 ALIGN=RIGHT><B>". _('TOTAL Excl Tax/Freight') ."</B></TD>
 357         <TD ALIGN=RIGHT>$DisplayTotal</TD>
 358 </TR></TABLE>";
 359
 360 echo '<TABLE><TR>
 361         <TD>'. _('Deliver To') .":</TD>
 362         <TD>" . $_SESSION['Items']->DeliverTo . "</TD></TR>";
 363
 364 echo '<TR>
 365         <TD>'. _('Deliver from the warehouse at') .":</TD>
 366         <TD>" . $_SESSION['Items']->Location . '</TD></TR>';
 367
 368 echo '<TR>
 369         <TD>'. _('Street') .":</TD>
 370         <TD>" . $_SESSION['Items']->BrAdd1 . "</TD></TR>";
 371
 372 echo "<TR>
 373         <TD>". _('Suburb') .":</TD>
 374         <TD>" . $_SESSION['Items']->BrAdd2 . "</TD></TR>";
 375
 376 echo '<TR>
 377         <TD>'. _('City') . '/' . _('Region') .':</TD>
 378         <TD>' . $_SESSION['Items']->BrAdd3 . '</TD></TR>';
 379
 380 echo '<TR>
 381         <TD>'. _('Post Code') .':</TD>
 382         <TD>' . $_SESSION['Items']->BrAdd4 . '</TD></TR>';
 383
 384 echo '<TR>
 385         <TD>'. _('Contact Phone Number') .':</TD>
 386         <TD>' . $_SESSION['Items']->PhoneNo . '</TD></TR>';
 387
 388 echo '<TR><TD>' . _('Contact Email') .':</TD>
 389         <TD>' . $_SESSION['Items']->Email . '</TD></TR>';
 390
 391 echo '<TR><TD>'. _('Customer Reference') .':</TD>
 392         <TD>' . $_SESSION['Items']->CustRef . '</TD></TR>';
 393
 394 echo '<TR>
 395         <TD>'. _('Comments') .':</TD>
 396         <TD>' . $_SESSION['Items']->Comments .'</TD></TR>';
 397
 398 if (!isset($_POST['StartDate'])){
 399         $_POST['StartDate'] = date($_SESSION['DefaultDateFormat']);
 400 }
 401
 402 if ($NewRecurringOrder=='Yes'){
 403         echo '<TR>
 404         <TD>'. _('Start Date') .':</TD>
 405         <TD><INPUT TYPE=TEXT NAME="StartDate" SIZE=11 MAXLENGTH=10 VALUE="' . $_POST['StartDate'] .'"</TD></TR>';
 406 } else {
 407         echo '<TR>
 408         <TD>'. _('Last Recurrence') . ':</TD>
 409         <TD>' . $_POST['StartDate'] . '</TD></TR>';
 410         echo '<INPUT TYPE=HIDDEN NAME="StartDate" VALUE="' . $_POST['StartDate'] . '">';
 411 }
 412
 413 if (!isset($_POST['StopDate'])){
 414    $_POST['StopDate'] = Date($_SESSION['DefaultDateFormat'], Mktime(0,0,0,Date('m'),Date('d')+1,Date('y')+1));
 415 }
 416
 417 echo '<TR>
 418         <TD>'. _('Finish Date') .':</TD>
 419         <TD><INPUT TYPE=TEXT NAME="StopDate" SIZE=11 MAXLENGTH=10 VALUE="' . $_POST['StopDate'] .'"</TD></TR>';
 420
 421 echo '<TR>
 422         <TD>'. _('Frequency of Recurrence') .':</TD>
 423         <TD><SELECT NAME="Frequency">';
 424
 425 if ($_POST['Frequency']==52){
 426         echo '<OPTION SELECTED VALUE=52>' . _('Weekly');
 427 } else {
 428         echo '<OPTION VALUE=52>' . _('Weekly');
 429 }
 430 if ($_POST['Frequency']==26){
 431         echo '<OPTION SELECTED VALUE=26>' . _('Fortnightly');
 432 } else {
 433         echo '<OPTION VALUE=26>' . _('Fortnightly');
 434 }
 435 if ($_POST['Frequency']==12){
 436         echo '<OPTION SELECTED VALUE=12>' . _('Monthly');
 437 } else {
 438         echo '<OPTION VALUE=12>' . _('Monthly');
 439 }
 440 if ($_POST['Frequency']==6){
 441         echo '<OPTION SELECTED VALUE=6>' . _('Bi-monthly');
 442 } else {
 443         echo '<OPTION VALUE=6>' . _('Bi-monthly');
 444 }
 445 if ($_POST['Frequency']==4){
 446         echo '<OPTION SELECTED VALUE=4>' . _('Quarterly');
 447 } else {
 448         echo '<OPTION VALUE=4>' . _('Quarterly');
 449 }
 450 if ($_POST['Frequency']==2){
 451         echo '<OPTION SELECTED VALUE=2>' . _('Bi-Annually');
 452 } else {
 453         echo '<OPTION VALUE=2>' . _('Bi-Annually');
 454 }
 455 if ($_POST['Frequency']==1){
 456         echo '<OPTION SELECTED VALUE=1>' . _('Annually');
 457 } else {
 458         echo '<OPTION VALUE=1>' . _('Annually');
 459 }
 460 echo '</SELECT></TD></TR>';
 461
 462
 463 if ($_SESSION['Items']->AllDummyLineItems()==true){
 464
 465         echo '<TR><TD>' . _('Invoice Automatically') . ':</TD>
 466                 <TD><SELECT NAME="AutoInvoice">';
 467         if ($_POST['AutoInvoice']==0){
 468                 echo '<OPTION SELECTED VALUE=0>' . _('No');
 469                 echo '<OPTION VALUE=1>' . _('Yes');
 470         } else {
 471                 echo '<OPTION VALUE=0>' . _('No');
 472                 echo '<OPTION SELECTED VALUE=1>' . _('Yes');
 473         }
 474         echo '</SELECT></TD></TR>';
 475 } else {
 476         echo '<INPUT TYPE=HIDDEN NAME="AutoInvoice" VALUE=0>';
 477 }
 478
 479 echo '</TABLE>';
 480
 481 echo '<BR>';
 482 if ($NewRecurringOrder=='Yes'){
 483         echo '<INPUT TYPE=HIDDEN NAME="NewRecurringOrder" VALUE="Yes">';
 484         echo "<INPUT TYPE=SUBMIT NAME='Process' VALUE='" . _('Create Reccurring Order') . "'>";
 485 } else {
 486         echo '<INPUT TYPE=HIDDEN NAME="NewRecurringOrder" VALUE="No">';
 487         echo '<INPUT TYPE=HIDDEN NAME="ExistingRecurrOrderNo" VALUE=' . $_POST['ExistingRecurrOrderNo'] . '>';
 488
 489         echo "<INPUT TYPE=SUBMIT NAME='Process' VALUE='" . _('Update Reccurring Order Details') . "'>";
 490         echo '<HR>';
 491         echo '<BR><BR><INPUT TYPE=SUBMIT NAME="DeleteRecurringOrder" VALUE="' . _('Delete Recurring Order') . ' ' . $_POST['ExistingRecurrOrderNo'] . '" onclick="return confirm(\'' . _('Are you sure you wish to delete this recurring order template?') . '\');">';
 492 }
 493
 494 echo '</FORM></CENTER>';
 495 include('includes/footer.inc');
 496 ?>