Форум Сайтостроение Веб-строительство

id=*+1 авто распечатка обновление Пожалуйста помогите

K9
На сайте с 09.02.2009
Offline
0
KASPER1989
711

Помогите пожалуйста.

Есть пхп страничка в которую нада вписать авто обновление приплюсовывание в строку адресса ид тоесть

/admin/invoice.php?oID=1 обновляется страница каждые 2 минуты как только в базе запалняется таблица под id=1 страница отправляется на распечатку на принтер и обновляется с приплюсовыванием id тоесть будет уже ссылка /admin/invoice.php?oID=2 с пустыми палями... опять обнавляется как только таблица запалняется, печать опять +1 к ид ...

Я просто не знаю какие команды в пхп помогите разобратся я думаю что это достаточно просто...

K9
На сайте с 09.02.2009
Offline
0
KASPER1989
#1 

<?php



  require('includes/application_top.php');



  $customer_number_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". tep_db_input(tep_db_prepare_input($_GET['order_id'])) . "'");

  $customer_number = tep_db_fetch_array($customer_number_query);

/*

  if ($customer_number['customers_id'] != $customer_id) {

    tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));

  }

*/  

  $payment_info_query = tep_db_query("select payment_info from " . TABLE_ORDERS . " where orders_id = '". tep_db_input(tep_db_prepare_input($_GET['order_id'])) . "'");

  $payment_info = tep_db_fetch_array($payment_info_query);

  $payment_info = $payment_info['payment_info'];



//  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_INVOICE);



  require(DIR_WS_CLASSES . 'currencies.php');

  $currencies = new currencies();



  $oID = tep_db_prepare_input($_GET['oID']);

  $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'");



  include(DIR_WS_CLASSES . 'order.php');

  $order = new order($oID);



?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE_PRINT_ORDER . $oID; ?></title>

<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="print.css">

</head>

<body marginwidth="10" marginheight="10" topmargin="10" bottommargin="10" leftmargin="10" rightmargin="10">





<!-- body_text //-->

<table width="600" border="0" align="center" cellpadding="2" cellspacing="0">

  <tr> 

    <td align="center" class="main"><table align="center" width="100%" border="0" cellspacing="0" cellpadding="5">

      <tr> 

        <td valign="top" align="left" class="main"><script language="JavaScript">

  if (window.print) {

    document.write('<a href="javascript:;" onClick="javascript:window.print()" onMouseOut=document.imprim.src="<?php echo (DIR_WS_IMAGES . 'printimage.gif'); ?>" onMouseOver=document.imprim.src="<?php echo (DIR_WS_IMAGES . 'printimage_over.gif'); ?>"><img src="<?php echo (DIR_WS_IMAGES . 'printimage.gif'); ?>" width="43" height="28" align="absbottom" border="0" name="imprim">' + '<?php echo IMAGE_BUTTON_PRINT; ?></a></center>');

  }

  else document.write ('<h2><?php echo IMAGE_BUTTON_PRINT; ?></h2>')

        </script></td>

        <td align="right" valign="bottom" class="main"><p align="right" class="main"><a href="javascript:window.close();"><img src='images/close_window.jpg' border=0></a></p></td>

      </tr>

    </table></td>

  </tr>

  <tr align="left"> 

    <td class="titleHeading"><?php echo tep_draw_separator('pixel_trans.gif', '1', '25'); ?></td>

  </tr>

  <tr> 

    <td><table border="0" align="center" width="100%" cellspacing="0" cellpadding="0">

      <tr> 

        <td><table border="0" align="center" width="75%" cellspacing="0" cellpadding="0">

          <tr> 

            <td class="pageHeading"><?php echo nl2br(STORE_NAME_ADDRESS); ?></td>

            <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . STORE_LOGO, STORE_NAME); ?></td>

          </tr>

          <tr align="left"> 

            <td colspan="2" class="titleHeading"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

          </tr>

          <tr> 

            <td colspan="2" align="center" class="titleHeading"><b><?php echo TITLE_PRINT_ORDER  . $oID; ?>, <?php echo TEXT_DATE; ?><?php echo tep_date_short($order->info['date_purchased']); ?></b></td>

          </tr>

          <tr align="left"> 

            <td colspan="2" class="titleHeading"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

          </tr>

        </table></td>

      </tr>

    </table></td>

  </tr>

  <tr> 

    <td align="center"><table align="center" width="100%" border="0" cellspacing="0" cellpadding="2">

      <tr> 

        <td align="center" valign="top"><table align="center" width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor=#000000>

          <tr> 

            <td align="center" valign="top"><table align="center" width="100%" border="0" cellspacing="0" cellpadding="2">

              <tr class="dataTableHeadingRow"> 

                <td class="dataTableHeadingContent"><b><?php echo ENTRY_SOLD_TO; ?></b></td>

              </tr>

              <tr class="dataTableRow"> 

                <td class="dataTableContent"><?php echo tep_address_format($order->customer['format_id'], $order->billing, 1, '&nbsp;', '<br>'); ?></td>

              </tr>

            </table></td>

          </tr>

        </table></td>

        <td align="center" valign="top"><table align="center" width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor=#000000>

          <tr> 

            <td align="center" valign="top"><table align="center" width="100%" border="0" cellspacing="0" cellpadding="2">

              <tr class="dataTableHeadingRow"> 

                <td class="dataTableHeadingContent"><b><?php echo ENTRY_SHIP_TO; ?></b></td>

              </tr>

              <tr class="dataTableRow"> 

                <td class="dataTableContent"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '&nbsp;', '<br>'); ?></td>

              </tr>

            </table></td>

          </tr>

        </table></td>

      </tr>

    </table></td>

  </tr>

  <tr>

    <td align="left" class="main"><table width="100%" border="0" cellspacing="0" cellpadding="2">

              <tr>

                <td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b>&nbsp;&nbsp;<?php echo $order->customer['telephone']; ?></td>

              </tr>

			                <tr>

                <td class="main"><b><?php echo ENTRY_FAX_NUMBER; ?></b>&nbsp;&nbsp;<?php echo $order->customer['fax']; ?></td>

              </tr>

              <tr>

                <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b>&nbsp;&nbsp;<?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td>

              </tr>

  <tr> 

    <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

  </tr>  

      <tr> 

        <td  class="main"><?php echo '<b>' . ENTRY_PAYMENT_METHOD . '</b> ' . $order->info['payment_method']; ?></td>

      </tr>

      <tr> 

        <td  class="main"><?php echo $payment_info; ?></td>

      </tr>

    </table></td>

  </tr>

  <tr> 

    <td><table border="0" width="100%" cellspacing="0" cellpadding="1" bgcolor=#000000>

      <tr>

        <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

          <tr class="dataTableHeadingRow"> 

            <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>

            <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

            <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>

            <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>

          </tr>

        <?php

    for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {

      echo '      <tr class="dataTableRow">' . "\n" .

           '        <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . '&nbsp;x</td>' . "\n" .

           '        <td class="dataTableContent" valign="top" align="left">' . $order->products[$i]['name'] . '<br>';



    if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {

      for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {

        echo '<nobr><small>&nbsp;<i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i><br></small></nobr>';

      }

    }



      echo '        </td>' . "\n" .

           '        <td class="dataTableContent" valign="top" align="center">' . $order->products[$i]['model'] . '</td>' . "\n";

echo           '        <td class="dataTableContent" align="center" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

           '        <td class="dataTableContent" align="center" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax'], true) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n";

      echo '      </tr>' . "\n";

    }

?>

        </table></td>

      </tr>

    </table></td>

  </tr>

  <tr>

    <td align="right" colspan="7"><table border="0" cellspacing="0" cellpadding="2">

      <tr>

        <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

              <?php

  for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {

    echo '          <tr>' . "\n" .

         '            <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" .

         '            <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" .

         '          </tr>' . "\n";

  }

?>

        </table></td>

      </tr>

    </table></td>

  </tr>

<tr>

<td align="right" class="dataTableContent">

<br>

<br>

<br>

<?php echo TEXT_GET_ORDER ?>

<br>

<?php echo TEXT_NO_PRETENSION ?>

<br>

<br>

__________________________

<br>

<?php echo TEXT_SIGNATURE ?>

<br>

</td>

</tr>  

</table>

<!-- body_text_eof //-->

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Авторизуйтесь или зарегистрируйтесь, чтобы оставить комментарий