Ankündigung

Einklappen
Keine Ankündigung bisher.

lastschriftverfahren ohne fax?

Einklappen
X
 
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

    lastschriftverfahren ohne fax?

    hallo. kenne von oscommerce ein ziemlich cooles lastschriftverfahren. gibt es für zen cart eine variante, wo der kunde seinen daten online eingibt und das ganze wird dann per email übersendet?

    #2
    hi

    haste nen link zu diesem modul

    Kommentar


      #3
      hallo hugo,

      hier ist die contribution:

      Kommentar


        #4
        Hallo hat schon jemand das modul umgeschrieben ich habe mich schon versucht doch habe ich leider noch nicht zum laufen gebracht warscheinlich habe ich in der classes noch fehler beim umschreiben.

        wenn Jemand beim umschreiben helfen würde fände ich das spitze

        Gruß Christian

        Kommentar


          #5
          Habe gerade das mächtige lastschriftmodul von osc umgeschrieben geht auch alles soweit habe aber noch den fehler das ich es in der admin/orders.php noch nicht aus lesen kann.

          Code:
          <?php
              }
              // begin modification for german banktransfer
          	$germanbt_query = $db->Execute("select * from " . TABLE_GERMANBT . " where orders_id ='" . zen_db_input($HTTP_GET_VARS['oID']) . "'");
          //    $germanbt_query = tep_db_query("select * from " . TABLE_GERMANBT . " where orders_id = '" . tep_db_input($HTTP_GET_VARS['oID']) . "'");
                if ($germanbt_query->RecordCount() < 0) {
          //    if (tep_db_num_rows($germanbt_query) != 0) {
                    $germanbt = $db->Execute($germanbt_query);
          ?>
          denke das problem liegt bei dem if ($germanbt_query->RecordCount() < 0) {

          doch ich find den fehler gerade nicht jemand ne idee

          Gruß Christian

          Kommentar


            #6
            zen_db_input != tep_db_input

            Kommentar


              #7
              Steh gerde ganz neben mir! Was meinst du? hier noch mal der code

              Code:
                  // begin modification for german banktransfer
              	$germanbt_query = $db->Execute("select * from " . TABLE_GERMANBT . " where orders_id ='" . zen_db_input($HTTP_GET_VARS['oID']) . "'");
                    if ($germanbt_query->RecordCount() < 0) {
                        $germanbt = $db->Execute($germanbt_query);

              Kommentar


                #8
                Code:
                <?php
                 // begin modification for german banktransfer
                $sql = "select * from " . TABLE_GERMANBT . " where orders_id ='" . zen_db_input($HTTP_GET_VARS['oID']) . "'";
                $res = $db -> Execute($sql);
                while(!$res -> EOF){
                    /**
                     * tu was mit mir
                     */
                     $res -> MoveNext();
                     }
                ?>

                Kommentar


                  #9
                  Die daten werden leider immer noch nicht angezeigt hier der ganzer code! wenn du noch mal schauen könntest!?

                  Code:
                  <?php 
                   // begin modification for german banktransfer 
                  $sql = "select * from " . TABLE_GERMANBT . " where orders_id ='" . zen_db_input($HTTP_GET_VARS['oID']) . "'"; 
                  $res = $db -> Execute($sql); 
                  while(!$res -> EOF){ 
                      /** 
                       * tu was mit mir 
                       */ 
                       $res -> MoveNext(); 
                       } 
                  ?>
                            <tr>
                              <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                            </tr>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_NAME; ?></td>
                              <td class="main"><?php echo $germanbt['banktransfer_bankname']; ?></td>
                            </tr>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_BLZ; ?></td>
                              <td class="main"><?php echo $germanbt['banktransfer_blz']; ?></td>
                            </tr>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_NUMBER; ?></td>
                              <td class="main"><?php echo $germanbt['banktransfer_number']; ?></td>
                            </tr>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_OWNER; ?></td>
                              <td class="main"><?php echo $germanbt['banktransfer_owner']; ?></td>
                            </tr>
                  <?php
                        if ($germanbt['banktransfer_status'] == 0) {
                  ?>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_STATUS; ?></td>
                              <td class="main"><?php echo "OK"; ?></td>
                            </tr>
                  <?php
                        } else {
                  ?>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_STATUS; ?></td>
                              <td class="main"><?php echo $germanbt['banktransfer_status']; ?></td>
                            </tr>
                  <?php
                          switch ($germanbt['banktransfer_status']) {
                            case 1: $error_val = TEXT_GERMANBT_ERROR_1; break;
                            case 2: $error_val = TEXT_GERMANBT_ERROR_2; break;
                            case 3: $error_val = TEXT_GERMANBT_ERROR_3; break;
                            case 4: $error_val = TEXT_GERMANBT_ERROR_4; break;
                            case 5: $error_val = TEXT_GERMANBT_ERROR_5; break;
                            case 8: $error_val = TEXT_GERMANBT_ERROR_8; break;
                            case 9: $error_val = TEXT_GERMANBT_ERROR_9; break;
                          }
                  ?>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_ERRORCODE; ?></td>
                              <td class="main"><?php echo $error_val; ?></td>
                            </tr>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_PRZ; ?></td>
                              <td class="main"><?php echo $germanbt['banktransfer_prz']; ?></td>
                            </tr>
                  <?php
                        }
                      }
                      if ($germanbt['banktransfer_fax']) {
                  ?>
                            <tr>
                              <td class="main"><?php echo TEXT_GERMANBT_FAX; ?></td>
                              <td class="main"><?php echo $germanbt['banktransfer_fax']; ?></td>
                            </tr>
                  <?php
                      }
                      // end modification for german banktransfer
                  ?>
                  denn ich denke das modul interresiert viele da man es ab der x bestellung freisachalten kan per fax bestätigen oder auch nicht und eine prüfung der bankdaten über file oder db

                  Kommentar


                    #10
                    Hi
                    Code:
                    <?php
                     require('includes/application_top.php');
                    /**
                     * lass uns das wiederkehrende in ne function packen
                     */
                    function makeTRTD($name, $value){
                         $tmpCont = '<tr>
                                <td class="main">' . $name . '</td>
                                <td class="main">' . $value . '</td>
                              </tr>';
                         return $tmpCont;
                         }
                     // begin modification for german banktransfer
                    $sql = "select * from " . TABLE_GERMANBT . " where orders_id ='" . zen_db_input($_GET['oID']) . "'";
                    # $sql = "select * from " . TABLE_ORDERS . " where orders_id ='" . zen_db_input($_GET['oID']) . "'";
                    $germanbt = $db -> Execute($sql);
                    $content = '';
                    while(!$germanbt -> EOF){
                        /**
                         * tu was mit mir
                         */
                        
                         $content .= '<tr>
                                <td colspan="2">' . zen_draw_separator('pixel_trans.gif', '1', '10') . '</td>
                              </tr>' .
                         makeTRTD(TEXT_GERMANBT_NAME, $germanbt -> fields['banktransfer_bankname']) .
                         makeTRTD(TEXT_GERMANBT_BLZ, $germanbt -> fields['banktransfer_blz']) .
                         makeTRTD(TEXT_GERMANBT_NUMBER, $germanbt -> fields['banktransfer_number']) .
                         makeTRTD(TEXT_GERMANBT_OWNER, $germanbt -> fields['banktransfer_owner']);
                        
                         if ($germanbt['banktransfer_status'] == 0){
                             $content .= makeTRTD(TEXT_GERMANBT_STATUS, 'OK');
                             }else{
                             $content .= makeTRTD(TEXT_GERMANBT_STATUS, $germanbt -> fields['banktransfer_status']);
                             }
                        
                         switch ($germanbt -> fields['banktransfer_status']){
                         case 1: $error_val = TEXT_GERMANBT_ERROR_1;
                             break;
                         case 2: $error_val = TEXT_GERMANBT_ERROR_2;
                             break;
                         case 3: $error_val = TEXT_GERMANBT_ERROR_3;
                             break;
                         case 4: $error_val = TEXT_GERMANBT_ERROR_4;
                             break;
                         case 5: $error_val = TEXT_GERMANBT_ERROR_5;
                             break;
                         case 8: $error_val = TEXT_GERMANBT_ERROR_8;
                             break;
                         case 9: $error_val = TEXT_GERMANBT_ERROR_9;
                             break;
                             }
                         $content .= makeTRTD(TEXT_GERMANBT_ERRORCODE, $error_val);
                         $content .= makeTRTD(TEXT_GERMANBT_PRZ, $germanbt -> fields['banktransfer_prz']);
                        
                         if ($germanbt -> fields['banktransfer_fax']){
                         $content .= makeTRTD(TEXT_GERMANBT_FAX, $germanbt -> fields['banktransfer_fax']);
                         }
                     $germanbt -> MoveNext();
                    }
                     echo $content ;
                     # echo '<table border="1">' . $content . '</table>';
                    ?>
                    anmerkung:
                    die schlechteste eigenschaft von ZEN ist m.a. ist dieses öde mischen von logik & content; das macht zb das debuggen zur echten qual; sowie auch das endlose "requiren" von irgendwelchen files; nie weiss mensch wo die variablen herkommen

                    Kommentar


                      #11
                      Wenn ich es so nehme bekomme ich
                      Code:
                      Parse error: parse error, unexpected $ in C:\Programme\xampp\htdocs\web1\html\admin\orders.php on line 906
                      [code:1:3e088f5161]<?php
                      //
                      // +----------------------------------------------------------------------+
                      // |zen-cart Open Source E-commerce |
                      // +----------------------------------------------------------------------+
                      // | Copyright (c) 2003 The zen-cart developers |
                      // | |
                      // | http://www.zen-cart.com/index.php |
                      // | |
                      // | Portions Copyright (c) 2003 osCommerce |
                      // +----------------------------------------------------------------------+
                      // | This source file is subject to version 2.0 of the GPL license, |
                      // | that is bundled with this package in the file LICENSE, and is |
                      // | available through the world-wide-web at the following url: |
                      // | http://www.zen-cart.com/license/2_0.txt. |
                      // | If you did not receive a copy of the zen-cart license and are unable |
                      // | to obtain it through the world-wide-web, please send a note to |
                      // | license@zen-cart.com so we can mail you a copy immediately. |
                      // +----------------------------------------------------------------------+
                      // $Id: orders.php 1830 2005-08-10 21:15:39Z ajeh $
                      //

                      require('includes/application_top.php');

                      require(DIR_WS_CLASSES . 'currencies.php');
                      $currencies = new currencies();

                      $orders_statuses = array();
                      $orders_status_array = array();
                      $orders_status = $db->Execute("select orders_status_id, orders_status_name
                      from " . TABLE_ORDERS_STATUS . "
                      where language_id = '" . (int)$_SESSION['languages_id'] . "'");


                      while (!$orders_status->EOF) {
                      $orders_statuses[] = array('id' => $orders_status->fields['orders_status_id'],
                      'text' => $orders_status->fields['orders_status_name'] . ' [' . $orders_status->fields['orders_status_id'] . ']');
                      $orders_status_array[$orders_status->fields['orders_status_id']] = $orders_status->fields['orders_status_name'];
                      $orders_status->MoveNext();
                      }

                      $action = (isset($_GET['action']) ? $_GET['action'] : '');

                      if (zen_not_null($action)) {
                      switch ($action) {
                      case 'edit':
                      // reset single download to on
                      if ($_GET['download_reset_on'] > 0) {
                      // adjust download_maxdays based on current date
                      $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
                      date_purchased from " . TABLE_ORDERS . "
                      where orders_id = '" . $_GET['oID'] . "'");
                      $zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;

                      $update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='" . $zc_max_days . "', download_count='" . DOWNLOAD_MAX_COUNT . "' where orders_id='" . $_GET['oID'] . "' and orders_products_download_id='" . $_GET['download_reset_on'] . "'";
                      $db->Execute($update_downloads_query);
                      unset($_GET['download_reset_on']);

                      $messageStack->add_session(SUCCESS_ORDER_UPDATED_DOWNLOAD_ON, 'success');
                      zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', 'NONSSL'));
                      }
                      // reset single download to off
                      if ($_GET['download_reset_off'] > 0) {
                      // adjust download_maxdays based on current date
                      $update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='0', download_count='0' where orders_id='" . $_GET['oID'] . "' and orders_products_download_id='" . $_GET['download_reset_off'] . "'";
                      unset($_GET['download_reset_off']);
                      $db->Execute($update_downloads_query);

                      $messageStack->add_session(SUCCESS_ORDER_UPDATED_DOWNLOAD_OFF, 'success');
                      zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', 'NONSSL'));
                      }
                      break;
                      case 'update_order':
                      // demo active test
                      if (zen_admin_demo()) {
                      $_GET['action']= '';
                      $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
                      zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', 'NONSSL'));
                      }
                      $oID = zen_db_prepare_input($_GET['oID']);
                      $status = zen_db_prepare_input($_POST['status']);
                      $track_id1 = zen_db_prepare_input($_POST['track_id1']);
                      $track_id2 = zen_db_prepare_input($_POST['track_id2']);
                      $track_id3 = zen_db_prepare_input($_POST['track_id3']);
                      $comments = zen_db_prepare_input($_POST['comments']);

                      $order_updated = false;
                      $check_status = $db->Execute("select customers_name, customers_email_address, orders_status,
                      date_purchased from " . TABLE_ORDERS . "
                      where orders_id = '" . (int)$oID . "'");

                      if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
                      $db->Execute("update " . TABLE_ORDERS . "
                      set orders_status = '" . zen_db_input($status) . "', last_modified = now()
                      where orders_id = '" . (int)$oID . "'");

                      $customer_notified = '0';
                      if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {
                      $notify_comments = '';
                      if (isset($_POST['notify_comments']) && ($_POST['notify_comments'] == 'on') ) {
                      if (zen_not_null($comments)) {
                      $notify_comments = EMAIL_TEXT_COMMENTS_UPDATE . $comments . "\n\n";
                      }
                      if (zen_not_null($track_id1)) { $notify_comments .= "Ihre " . CARRIER_NAME_1 . " Paketschein Nr. ist " . $track_id1 . "\nSie können Ihr Paket verfolgen unter " . CARRIER_LINK_1 . $track_id1 . "\n\n"; }
                      if (zen_not_null($track_id2)) { $notify_comments .= "Ihre " . CARRIER_NAME_2 . " Paketschein Nr. ist " . $track_id2 . "\nSie können Ihr Paket verfolgen unter " . CARRIER_LINK_2 . $track_id2 . "\n\n"; }
                      if (zen_not_null($track_id3)) { $notify_comments .= "Ihre " . CARRIER_NAME_3 . " Paketschein Nr. ist " . $track_id3 . "\nSie können Ihr Paket verfolgen unter " . CARRIER_LINK_3 . $track_id3 . "\n\n"; }
                      }


                      //send emails
                      $message = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" .
                      EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
                      EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HIS TORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
                      EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
                      strip_tags($notify_comments) .
                      EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
                      EMAIL_TEXT_STATUS_PLEASE_REPLY;

                      $html_msg['EMAIL_CUSTOMERS_NAME'] = $check_status->fields['customers_name'];
                      $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
                      $html_msg['EMAIL_TEXT_INVOICE_URL'] = ''.str_replace(':','',EMAIL_TEXT_INVOICE_URL).'';
                      $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
                      $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = $notify_comments;
                      $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
                      $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
                      $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
                      $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

                      zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');

                      $customer_notified = '1';
                      //send extra emails
                      if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
                      zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
                      }
                      }

                      $db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
                      (orders_id, orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, comments)
                      values ('" . (int)$oID . "',
                      '" . zen_db_input($status) . "',
                      now(),
                      '" . zen_db_input($customer_notified) . "',
                      '" . zen_db_input($track_id1) . "',
                      '" . zen_db_input($track_id2) . "',
                      '" . zen_db_input($track_id3) . "',
                      '" . zen_db_input($comments) . "')");

                      $order_updated = true;
                      }

                      if ($order_updated == true) {
                      if ($status == DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) {
                      // adjust download_maxdays based on current date
                      $zc_max_days = date_diff($check_status->fields['date_purchased'], date('Y-m-d H:i:s', time())) + DOWNLOAD_MAX_DAYS;

                      $update_downloads_query = "update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays='" . $zc_max_days . "', download_count='" . DOWNLOAD_MAX_COUNT . "' where orders_id='" . (int)$oID . "'";
                      $db->Execute($update_downloads_query);
                      }
                      $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
                      } else {
                      $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
                      }

                      zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('action')) . 'action=edit', 'NONSSL'));
                      break;
                      case 'deleteconfirm':
                      // demo active test
                      if (zen_admin_demo()) {
                      $_GET['action']= '';
                      $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
                      zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')), 'NONSSL'));
                      }
                      $oID = zen_db_prepare_input($_GET['oID']);

                      zen_remove_order($oID, $_POST['restock']);
                      // begin modification for german banktransfer
                      $db->Execute("DELETE FROM " . TABLE_GERMANBT . " WHERE orders_id = '" . (int)$oID . "'");
                      // end modification for german banktransfer
                      zen_redirect(zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')), 'NONSSL'));
                      break;
                      }
                      }

                      if (($action == 'edit') && isset($_GET['oID'])) {
                      $oID = zen_db_prepare_input($_GET['oID']);

                      $orders = $db->Execute("select orders_id from " . TABLE_ORDERS . "
                      where orders_id = '" . (int)$oID . "'");

                      $order_exists = true;
                      if ($orders->RecordCount() <= 0) {
                      $order_exists = false;
                      $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');
                      }
                      }

                      include(DIR_WS_CLASSES . 'order.php');
                      ?>
                      <!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; ?></title>
                      <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
                      <link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
                      <script language="javascript" src="includes/menu.js"></script>
                      <script language="javascript" src="includes/general.js"></script>
                      <script type="text/javascript">
                      <!--
                      function init()
                      {
                      cssjsmenu('navbar');
                      if (document.getElementById)
                      {
                      var kill = document.getElementById('hoverJS');
                      kill.disabled = true;
                      }
                      }
                      // -->
                      </script>
                      </head>
                      <body onload="init()">

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



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


                      <?php if (empty($action)) { ?>

                      <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                      <tr>
                      <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
                      <tr><?php echo zen_draw_form('search', FILENAME_ORDERS, '', 'get', '', true); ?>
                      <td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
                      <td colspan="2" class="smallText" align="right">
                      <?php
                      // show reset search
                      if ((isset($_GET['search']) && zen_not_null($_GET['search'])) or $_GET['cID'] !='') {
                      echo '' . zen_image_button('button_reset.gif', IMAGE_RESET) . '
                      ';
                      }
                      ?>
                      <?php
                      echo HEADING_TITLE_SEARCH_DETAIL . ' ' . zen_draw_input_field('search');
                      if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
                      $keywords = zen_db_input(zen_db_prepare_input($_GET['search']));
                      echo '<br/ >' . TEXT_INFO_SEARCH_DETAIL_FILTER . $keywords;
                      }
                      ?>
                      </td>
                      </form></tr>
                      </table></td>
                      </tr>

                      <?php } ?>


                      <?php
                      if (($action == 'edit') && ($order_exists == true)) {
                      $order = new order($oID);
                      if ($order->info['payment_module_code']) {
                      if (file_exists(DIR_FS_CATALOG_MODULES . 'payment/' . $order->info['payment_module_code'] . '.php')) {
                      require(DIR_FS_CATALOG_MODULES . 'payment/' . $order->info['payment_module_code'] . '.php');
                      require(DIR_FS_CATALOG_LANGUAGES . $_SESSION['language'] . '/modules/payment/' . $order->info['payment_module_code'] . '.php');
                      $module = new $order->info['payment_module_code'];
                      // echo $module->admin_notification($oID);
                      }
                      }
                      ?>
                      <tr>
                      <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
                      <tr>
                      <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
                      <td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
                      <td class="pageHeading" align="right"><?php echo '' . zen_image_button('button_back.gif', IMAGE_BACK) . ''; ?></td>
                      </tr>
                      </table></td>
                      </tr>
                      <tr>
                      <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
                      <tr>
                      <td colspan="3"><?php echo zen_draw_separator(); ?></td>
                      </tr>
                      <tr>
                      <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
                      <tr>
                      <td class="main" valign="top"><?php echo ENTRY_CUSTOMER; ?></td>
                      <td class="main"><?php echo zen_address_format($order->customer['format_id'], $order->customer, 1, '', '
                      '); ?></td>
                      </tr>
                      <tr>
                      <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
                      <td class="main"><?php echo $order->customer['telephone']; ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_EMAIL_ADDRESS; ?></td>
                      <td class="main"><?php echo '' . $order->customer['email_address'] . ''; ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo TEXT_INFO_IP_ADDRESS; ?></td>
                      <td class="main"><?php echo $order->info['ip_address']; ?></td>
                      </tr>
                      </table></td>
                      <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
                      <tr>
                      <td class="main" valign="top"><?php echo ENTRY_SHIPPING_ADDRESS; ?></td>
                      <td class="main"><?php echo zen_address_format($order->delivery['format_id'], $order->delivery, 1, '', '
                      '); ?></td>
                      </tr>
                      </table></td>
                      <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
                      <tr>
                      <td class="main" valign="top"><?php echo ENTRY_BILLING_ADDRESS; ?></td>
                      <td class="main"><?php echo zen_address_format($order->billing['format_id'], $order->billing, 1, '', '
                      '); ?></td>
                      </tr>
                      </table></td>
                      </tr>
                      </table></td>
                      </tr>
                      <tr>
                      <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_ORDER_ID . $oID; ?></td>
                      </tr>
                      <tr>
                      <td><table border="0" cellspacing="0" cellpadding="2">
                      <tr>
                      <td class="main"><?php echo ENTRY_DATE_PURCHASED; ?></td>
                      <td class="main"><?php echo zen_date_long($order->info['date_purchased']); ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_PAYMENT_METHOD; ?></td>
                      <td class="main"><?php echo $order->info['payment_method']; ?></td>
                      </tr>
                      <?php
                      if (zen_not_null($order->info['cc_type']) || zen_not_null($order->info['cc_owner']) || zen_not_null($order->info['cc_number'])) {
                      ?>
                      <tr>
                      <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>
                      <td class="main"><?php echo $order->info['cc_type']; ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>
                      <td class="main"><?php echo $order->info['cc_owner']; ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>
                      <td class="main"><?php echo $order->info['cc_number']; ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_CREDIT_CARD_CVV; ?></td>
                      <td class="main"><?php echo $order->info['cc_cvv']; ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>
                      <td class="main"><?php echo $order->info['cc_expires']; ?></td>
                      </tr>

                      <?php
                      require('includes/application_top.php');
                      /**
                      * lass uns das wiederkehrende in ne function packen
                      */
                      function makeTRTD($name, $value){
                      $tmpCont = '<tr>
                      <td class="main">' . $name . '</td>
                      <td class="main">' . $value . '</td>
                      </tr>';
                      return $tmpCont;
                      }
                      // begin modification for german banktransfer
                      $sql = "select * from " . TABLE_GERMANBT . " where orders_id ='" . zen_db_input($_GET['oID']) . "'";
                      # $sql = "select * from " . TABLE_ORDERS . " where orders_id ='" . zen_db_input($_GET['oID']) . "'";
                      $germanbt = $db -> Execute($sql);
                      $content = '';
                      while(!$germanbt -> EOF){
                      /**
                      * tu was mit mir
                      */

                      $content .= '<tr>
                      <td colspan="2">' . zen_draw_separator('pixel_trans.gif', '1', '10') . '</td>
                      </tr>' .
                      makeTRTD(TEXT_GERMANBT_NAME, $germanbt -> fields['banktransfer_bankname']) .
                      makeTRTD(TEXT_GERMANBT_BLZ, $germanbt -> fields['banktransfer_blz']) .
                      makeTRTD(TEXT_GERMANBT_NUMBER, $germanbt -> fields['banktransfer_number']) .
                      makeTRTD(TEXT_GERMANBT_OWNER, $germanbt -> fields['banktransfer_owner']);

                      if ($germanbt['banktransfer_status'] == 0){
                      $content .= makeTRTD(TEXT_GERMANBT_STATUS, 'OK');
                      }else{
                      $content .= makeTRTD(TEXT_GERMANBT_STATUS, $germanbt -> fields['banktransfer_status']);
                      }

                      switch ($germanbt -> fields['banktransfer_status']){
                      case 1: $error_val = TEXT_GERMANBT_ERROR_1;
                      break;
                      case 2: $error_val = TEXT_GERMANBT_ERROR_2;
                      break;
                      case 3: $error_val = TEXT_GERMANBT_ERROR_3;
                      break;
                      case 4: $error_val = TEXT_GERMANBT_ERROR_4;
                      break;
                      case 5: $error_val = TEXT_GERMANBT_ERROR_5;
                      break;
                      case 8: $error_val = TEXT_GERMANBT_ERROR_8;
                      break;
                      case 9: $error_val = TEXT_GERMANBT_ERROR_9;
                      break;
                      }
                      $content .= makeTRTD(TEXT_GERMANBT_ERRORCODE, $error_val);
                      $content .= makeTRTD(TEXT_GERMANBT_PRZ, $germanbt -> fields['banktransfer_prz']);

                      if ($germanbt -> fields['banktransfer_fax']){
                      $content .= makeTRTD(TEXT_GERMANBT_FAX, $germanbt -> fields['banktransfer_fax']);
                      }
                      $germanbt -> MoveNext();
                      }
                      echo $content ;
                      # echo '<table border="1">' . $content . '</table>';
                      ?>
                      </table></td>
                      </tr>
                      <?php
                      if (method_exists($module, 'admin_notification')) {
                      ?>
                      <tr>
                      <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                      </tr>
                      <tr>
                      <?php echo $module->admin_notification($oID); ?>
                      </tr>
                      <tr>
                      <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                      </tr>
                      <?php
                      }
                      ?>
                      <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"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>
                      <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>
                      <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>
                      <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>
                      <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>
                      <td class="dataTableHeadingContent" align="right"><?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'] . 'x</td>' . "\n" .
                      ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];

                      if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {
                      for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {
                      echo '
                      <nobr> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
                      if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
                      if ($order->products[$i]['attributes'][$j]['product_attribute_is_free'] == '1' and $order->products[$i]['product_is_free'] == '1') echo TEXT_INFO_ATTRIBUTE_FREE;
                      echo '
                      </nobr>';
                      }
                      }

                      echo ' </td>' . "\n" .
                      ' <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .
                      ' <td class="dataTableContent" align="right" valign="top">' . zen_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .
                      ' <td class="dataTableContent" align="right" valign="top">' .
                      $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) .
                      ($order->products[$i]['onetime_charges'] != 0 ? '
                      ' . $currencies->format($order->products[$i]['onetime_charges'], true, $order->info['currency'], $order->info['currency_value']) : '') .
                      '
                      </td>' . "\n" .
                      ' <td class="dataTableContent" align="right" valign="top">' .
                      $currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) .
                      ($order->products[$i]['onetime_charges'] != 0 ? '
                      ' . $currencies->format(zen_add_tax($order->products[$i]['onetime_charges'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) : '') .
                      '
                      </td>' . "\n" .
                      ' <td class="dataTableContent" align="right" valign="top">' .
                      $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) .
                      ($order->products[$i]['onetime_charges'] != 0 ? '
                      ' . $currencies->format($order->products[$i]['onetime_charges'], true, $order->info['currency'], $order->info['currency_value']) : '') .
                      '
                      </td>' . "\n" .
                      ' <td class="dataTableContent" align="right" valign="top">' .
                      $currencies->format(zen_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) .
                      ($order->products[$i]['onetime_charges'] != 0 ? '
                      ' . $currencies->format(zen_add_tax($order->products[$i]['onetime_charges'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) : '') .
                      '
                      </td>' . "\n";
                      echo ' </tr>' . "\n";
                      }
                      ?>
                      <tr>
                      <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">
                      <?php
                      for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
                      echo ' <tr>' . "\n" .
                      ' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
                      ' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
                      ' </tr>' . "\n";
                      }
                      ?>
                      </table></td>
                      </tr>
                      </table></td>
                      </tr>

                      <?php
                      // show downloads
                      require(DIR_WS_MODULES . 'orders_download.php');
                      ?>

                      <tr>
                      <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                      </tr>
                      <tr>
                      <td class="main"><table border="1" cellspacing="0" cellpadding="5">
                      <tr>
                      <td class="smallText" align="center"><?php echo TABLE_HEADING_DATE_ADDED; ?></td>
                      <td class="smallText" align="center"><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></td>
                      <td class="smallText" align="center"><?php echo TABLE_HEADING_STATUS; ?></td>
                      <td class="smallText" align="center">Paketschein Nr.</td>
                      <td class="smallText" align="center">Kommentare</td>
                      </tr>
                      <?php
                      $orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, comments
                      from " . TABLE_ORDERS_STATUS_HISTORY . "
                      where orders_id = '" . zen_db_input($oID) . "'
                      order by date_added");

                      if ($orders_history->RecordCount() > 0) {
                      while (!$orders_history->EOF) {
                      echo ' <tr>' . "\n" .
                      ' <td class="smallText" align="center">' . zen_datetime_short($orders_history->fields['date_added']) . '</td>' . "\n" .
                      ' <td class="smallText" align="center">';
                      if ($orders_history->fields['customer_notified'] == '1') {
                      echo zen_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n";
                      } else {
                      echo zen_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";
                      }
                      echo ' <td class="smallText">' . $orders_status_array[$orders_history->fields['orders_status_id']] . '</td>' . "\n";
                      $display_track_id = '';
                      $display_track_id .= (empty($orders_history->fields['track_id1']) ? '' : CARRIER_NAME_1 . ":' . nl2br(zen_output_string_protected($orders_history->fields['track_id1'])) . "
                      " );
                      $display_track_id .= (empty($orders_history->fields['track_id2']) ? '' : CARRIER_NAME_2 . ":' . nl2br(zen_output_string_protected($orders_history->fields['track_id2'])) . "
                      " );
                      $display_track_id .= (empty($orders_history->fields['track_id3']) ? '' : CARRIER_NAME_3 . ":' . nl2br(zen_output_string_protected($orders_history->fields['track_id3'])) . "
                      " );
                      echo ' <td class="smallText">' . $display_track_id . '</td>' . "\n";

                      echo ' <td class="smallText">' . nl2br(zen_db_output($orders_history->fields['comments'])) . '</td>' . "\n" .
                      ' </tr>' . "\n";
                      $orders_history->MoveNext();
                      }
                      } else {
                      echo ' <tr>' . "\n" .
                      ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .
                      ' </tr>' . "\n";
                      }
                      ?>
                      </table></td>
                      </tr>
                      <tr>
                      <td class="main">
                      <?php echo TABLE_HEADING_COMMENTS; ?></td>
                      </tr>
                      <tr>
                      <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
                      </tr>
                      <tr><?php echo zen_draw_form('status', FILENAME_ORDERS, zen_get_all_get_params(array('action')) . 'action=update_order', 'post', '', true); ?>
                      <table border="0" cellspacing="0" cellpadding="3">
                      <tr>
                      <td>
                      <table border="1" cellspacing="0" cellpadding="3">
                      <tr>
                      <td>
                      Paketdienst</td>
                      <td class="main">
                      Paketschein Nr.</td>
                      </tr>
                      <tr>
                      <td><?php echo CARRIER_NAME_1; ?></td><td valign="top"><?php echo zen_draw_input_field('track_id1', ''); ?></td>
                      </tr>
                      <tr>
                      <td><?php echo CARRIER_NAME_2; ?></td><td valign="top"><?php echo zen_draw_input_field('track_id2', ''); ?></td>
                      </tr>
                      <tr>
                      <td><?php echo CARRIER_NAME_3; ?></td><td valign="top"><?php echo zen_draw_input_field('track_id3', ''); ?></td>
                      </tr>
                      </table>
                      </td>
                      <td>
                      <table border="1" cellspacing="0" cellpadding="3">
                      <tr>
                      <td class="main">
                      <?php echo TABLE_HEADING_COMMENTS; ?></td>
                      </tr>
                      <tr>
                      <td valign="top"><?php echo zen_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>
                      </tr>
                      </table>
                      </td>
                      </tr>
                      </table>
                      </tr>
                      <tr>
                      <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
                      </tr>
                      <tr>
                      <td><table border="0" cellspacing="0" cellpadding="2">
                      <tr>
                      <td><table border="0" cellspacing="0" cellpadding="2">
                      <tr>
                      <td class="main"><?php echo ENTRY_STATUS; ?> <?php echo zen_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>
                      </tr>
                      <tr>
                      <td><?php include ("comment_bar.php"); ?></td>
                      </tr>
                      <tr>
                      <td class="main"><?php echo ENTRY_NOTIFY_CUSTOMER; ?> <?php echo zen_draw_checkbox_field('notify', '', true); ?><?php echo ENTRY_NOTIFY_COMMENTS; ?> <?php echo zen_draw_checkbox_field('notify_comments', '', true); ?></td>
                      </tr>
                      </table></td>
                      <td valign="top"><?php echo zen_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>
                      </tr>
                      </table></td>
                      </form></tr>
                      <tr>
                      <td colspan="2" align="right"><?php echo '' . zen_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . ' ' . zen_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . ' ' . zen_image_button('button_back.gif', IMAGE_BACK) . ''; ?></td>
                      </tr>
                      <?php
                      // check if order has open gv
                      $gv_check = $db->Execute("select order_id, unique_id
                      from " . TABLE_COUPON_GV_QUEUE ."
                      where order_id = '" . $_GET['oID'] . "' and release_flag='N' limit 1");
                      if ($gv_check->RecordCount() > 0) {
                      $goto_gv = '' . zen_image_button('button_gift_queue.gif',IMAGE_GIF T_QUEUE) . '';
                      echo ' <tr><td align="right"><table width="225"><tr>';
                      echo ' <td align="center">';
                      echo $goto_gv . '';
                      echo ' </td>';
                      echo ' </tr></table></td></tr>';
                      }
                      ?>
                      <?php
                      } else {
                      ?>
                      <tr>
                      <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
                      <tr>
                      <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
                      <td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
                      <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">
                      <tr><?php echo zen_draw_form('orders', FILENAME_ORDERS, '', 'get', '', true); ?>
                      <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . zen_draw_input_field('oID', '', 'size="12"') . zen_draw_hidden_field('action', 'edit'); ?></td>
                      </form></tr>
                      <tr><?php echo zen_draw_form('status', FILENAME_ORDERS, '', 'get', '', true); ?>
                      <td class="smallText" align="right">
                      <?php
                      echo HEADING_TITLE_STATUS . ' ' . zen_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), $_GET['status'], 'onChange="this.form.submit();"');
                      echo zen_hide_session_id();
                      ?>
                      </td>
                      </form></tr>
                      </table></td>
                      </tr>
                      </table></td>
                      </tr>
                      <tr>
                      <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
                      <tr>
                      <td class="smallText"><?php echo TEXT_LEGEND . ' ' . zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10) . ' ' . TEXT_BILLING_SHIPPING_MISMATCH; ?>
                      </td>
                      <tr>
                      <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                      <tr class="dataTableHeadingRow">
                      <?php
                      // Sort Listing
                      switch ($_GET['list_order']) {
                      case "id-asc":
                      $disp_order = "c.customers_id";
                      break;
                      case "firstname":
                      $disp_order = "c.customers_firstname";
                      break;
                      case "firstname-desc":
                      $disp_order = "c.customers_firstname DESC";
                      break;
                      case "lastname":
                      $disp_order = "c.customers_lastname, c.customers_firstname";
                      break;
                      case "lastname-desc":
                      $disp_order = "c.customers_lastname DESC, c.customers_firstname";
                      break;
                      case "company":
                      $disp_order = "a.entry_company";
                      break;
                      case "company-desc":
                      $disp_order = "a.entry_company DESC";
                      break;
                      default:
                      $disp_order = "c.customers_id DESC";
                      }
                      ?>
                      <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_ORDERS_ID; ?></td>
                      <td class="dataTableHeadingContent" align="left" width="50"><?php echo TABLE_HEADING_PAYMENT_METHOD; ?></td>
                      <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
                      <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
                      <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
                      <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
                      <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?></td>
                      </tr>

                      <?php
                      // create search filter
                      $search = '';
                      if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
                      $keywords = zen_db_input(zen_db_prepare_input($_GET['search']));
                      $search = " and (o.customers_city like '%" . $keywords . "%' or o.customers_postcode like '%" . $keywords . "%' or o.date_purchased like '%" . $keywords . "%' or o.billing_name like '%" . $keywords . "%' or o.billing_company like '%" . $keywords . "%' or o.billing_street_address like '%" . $keywords . "%' or o.delivery_city like '%" . $keywords . "%' or o.delivery_postcode like '%" . $keywords . "%' or o.delivery_name like '%" . $keywords . "%' or o.delivery_company like '%" . $keywords . "%' or o.delivery_street_address like '%" . $keywords . "%' or o.billing_city like '%" . $keywords . "%' or o.billing_postcode like '%" . $keywords . "%' or o.customers_email_address like '%" . $keywords . "%' or o.customers_name like '%" . $keywords . "%' or o.customers_company like '%" . $keywords . "%' or o.customers_street_address like '%" . $keywords . "%' or o.customers_telephone like '%" . $keywords . "%' or o.ip_address like '%" . $keywords . "%')";
                      }
                      ?>
                      <?php
                      $new_fields = ", o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address ";
                      if (isset($_GET['cID'])) {
                      $cID = zen_db_prepare_input($_GET['cID']);
                      $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total" . $new_fields . " from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$_SESSION['languages_id'] . "' and ot.class = 'ot_total' order by orders_id DESC";
                      } elseif ($_GET['status'] != '') {
                      $status = zen_db_prepare_input($_GET['status']);
                      $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total" . $new_fields . " from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$_SESSION['languages_id'] . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' " . $search . " order by o.orders_id DESC";
                      } else {
                      $orders_query_raw = "select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total" . $new_fields . " from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$_SESSION['languages_id'] . "' and ot.class = 'ot_total' " . $search . " order by o.orders_id DESC";
                      }

                      // Split Page
                      // reset page when page is unknown
                      if (($_GET['page'] == '' or $_GET['page'] <= 1) and $_GET['oID'] != '') {
                      $check_page = $db->Execute($orders_query_raw);
                      $check_count=1;
                      if ($check_page->RecordCount() > MAX_DISPLAY_SEARCH_RESULTS_ORDERS) {
                      while (!$check_page->EOF) {
                      if ($check_page->fields['orders_id'] == $_GET['oID']) {
                      break;
                      }
                      $check_count++;
                      $check_page->MoveNext();
                      }
                      $_GET['page'] = round((($check_count/MAX_DISPLAY_SEARCH_RESULTS_ORDERS)+(fmod_round($ch eck_count,MAX_DISPLAY_SEARCH_RESULTS_ORDERS) !=0 ? .5 : 0)),0);
                      } else {
                      $_GET['page'] = 1;
                      }
                      }

                      // $orders_query_numrows = '';
                      $orders_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS_ORDERS, $orders_query_raw, $orders_query_numrows);
                      $orders = $db->Execute($orders_query_raw);
                      while (!$orders->EOF) {
                      if ((!isset($_GET['oID']) || (isset($_GET['oID']) && ($_GET['oID'] == $orders->fields['orders_id']))) && !isset($oInfo)) {
                      $oInfo = new objectInfo($orders->fields);
                      }

                      if (isset($oInfo) && is_object($oInfo) && ($orders->fields['orders_id'] == $oInfo->orders_id)) {
                      echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit', 'NONSSL') . '\'">' . "\n";
                      } else {
                      echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID')) . 'oID=' . $orders->fields['orders_id'], 'NONSSL') . '\'">' . "\n";
                      }

                      $show_difference = '';
                      if (($orders->fields['delivery_name'] != $orders->fields['billing_name'] and $orders->fields['delivery_name'] != '')) {
                      $show_difference = zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10) . '';
                      }
                      if (($orders->fields['delivery_street_address'] != $orders->fields['billing_street_address'] and $orders->fields['delivery_street_address'] != '')) {
                      $show_difference = zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10) . '';
                      }
                      $show_payment_type = $orders->fields['payment_module_code'] . '
                      ' . $orders->fields['shipping_module_code'];
                      ?>
                      <td class="dataTableContent" align="right"><?php echo $show_difference . $orders->fields['orders_id']; ?></td>
                      <td class="dataTableContent" align="left" width="50"><?php echo $show_payment_type; ?></td>
                      <td class="dataTableContent"><?php echo '' . zen_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW . ' ' . TABLE_HEADING_CUSTOMERS) . '' . $orders->fields['customers_name'] . ($orders->fields['customers_company'] != '' ? '
                      ' . $orders->fields['customers_company'] : ''); ?></td>
                      <td class="dataTableContent" align="right"><?php echo strip_tags($orders->fields['order_total']); ?></td>
                      <td class="dataTableContent" align="center"><?php echo zen_datetime_short($orders->fields['date_purchased']); ?></td>
                      <td class="dataTableContent" align="right"><?php echo $orders->fields['orders_status_name']; ?></td>

                      <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders->fields['orders_id'] == $oInfo->orders_id)) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ''; } ?></td>
                      </tr>
                      <?php
                      $orders->MoveNext();
                      }
                      ?>
                      <tr>
                      <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                      <tr>
                      <td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_ORDERS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>
                      <td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_ORDERS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'oID', 'action'))); ?></td>
                      </tr>
                      <?php
                      if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
                      ?>
                      <tr>
                      <td class="smallText" align="right" colspan="2">
                      <?php
                      echo '' . zen_image_button('button_reset.gif', IMAGE_RESET) . '';
                      if (isset($_GET['search']) && zen_not_null($_GET['search'])) {
                      $keywords = zen_db_input(zen_db_prepare_input($_GET['search']));
                      echo '<br/ >' . TEXT_INFO_SEARCH_DETAIL_FILTER . $keywords;
                      }
                      ?>
                      </td>
                      </tr>
                      <?php
                      }
                      ?>
                      </table></td>
                      </tr>
                      </table></td>
                      <?php
                      $heading = array();
                      $contents = array();

                      switch ($action) {
                      case 'delete':
                      $heading[] = array('text' => '' . TEXT_INFO_HEADING_DELETE_ORDER . '');

                      $contents = array('form' => zen_draw_form('orders', FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=deleteconfirm', 'post', '', true));
                      // $contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '

                      ' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '');
                      $contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '

                      ' . ENTRY_ORDER_ID . $oInfo->orders_id . '
                      ' . $oInfo->order_total . '
                      ' . $oInfo->customers_name . ($oInfo->customers_company != '' ? '
                      ' . $oInfo->customers_company : '') . '
                      ');
                      $contents[] = array('text' => '
                      ' . zen_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);
                      $contents[] = array('align' => 'center', 'text' => '
                      ' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . zen_href_link(FILENAME_ORDERS, zen_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id, 'NONSSL') . '">' . zen_imag

                      Kommentar


                        #12
                        ok der fehler lag an einem fehlenden "}) am ende des banktrans doch wird es immer noch nicht angezeigt

                        Kommentar


                          #13
                          mein code funktioniert grundsätzlich ==> http://all.ar-pub.com/kzen/dengg/t1.php?oID=1

                          Kommentar


                            #14
                            Werde heute nochmal das Lastschriftmodule welches ich am Wochenende umgeschrieben habe testen, welches oben gelinkt ist. Mit folgenden optionen ab der x-ten bestellung freizuschalten geht mit oder ohne fax bestätigung ist, direkte bankdaten eingabe vergleich der eingegebenen daten mit BLZ datei oder datenbank.
                            Wenn jemand das modul testen möchte so bitte Melden damit solche fehler wie bei den versand modulen oder bestellung auf rechnung ab X-ter Bestellung nicht mehr passieren! Da ich leider zum testen wenig zeit habe.

                            Gruß Christian

                            Kommentar


                              #15
                              So funktioniert alles ohne probleme nur ein porb gibtd ds noch auf der bestätigungsseite werden die bankdaten erst beim nochmaligen aktualisieren angezeigt! hat jemand ne idee woran es liegen könnte?

                              Gruß Christian

                              Code:
                                  function confirmation() {
                                    global $_POST, $db, $gbt_array, $gbt_number, $checkout_form_action, $checkout_form_submit;
                              
                                    if (!$_POST['banktransfer_owner'] == '') {
                                      $confirmation = array('title' => $this->title,
                                                            'fields' => array(array('title' => MODULE_PAYMENT_GERMANBT_TEXT_BANK_OWNER,
                                                                                    'field' => $gbt_array["bt_owner"]),
                                                                              array('title' => MODULE_PAYMENT_GERMANBT_TEXT_BANK_BLZ,
                                                                                    'field' => $gbt_array["bt_blz"]),
                                                                              array('title' => MODULE_PAYMENT_GERMANBT_TEXT_BANK_NUMBER,
                                                                                    'field' => $gbt_number),
                                                                              array('title' => MODULE_PAYMENT_GERMANBT_TEXT_BANK_NAME,
                                                                                    'field' => $gbt_array["bt_bankname"])
                                                                              ));
                                    }
                                    if ($gbt_array["bt_fax"] == true) {
                                      $confirmation = array('fields' => array(array('title' => MODULE_PAYMENT_GERMANBT_TEXT_BANK_FAX)));
                                    }
                                    return $confirmation;
                                  }
                              code der dafür zuständig sein sollte

                              Kommentar

                              Info zu diesem Forenarchiv:
                              Mit Release von 1.5.7 wurde die deutsche Zen Cart Version auf eine reine DIY-Lösung umgestellt.
                              Für einen Support via Forum stehen keine personellen und zeitlichen Ressourcen mehr zur Verfügung.
                              Dieses Supportforum bleibt im Nur-Lesen-Modus als Wissensarchiv noch online verfügbar.
                              PM Funktionalität, Registrierung und Posten neuer Beiträge sind deaktiviert.
                              Zugriff auf Anhänge in den Postings ist auch ohne Registrierung/Einloggen möglich.
                              FAQ und Downloadbereich des Forums wurden in die neue umfangreiche Knowledgebase auf der zen-cart-pro.at Website übernommen.

                              Das Development der deutschen Zen Cart Version geht wie bisher auf Github weiter.
                              Wir werden auch weiterhin neue Versionen bereitstellen und die Onlinedokumentation/Knowledgebase aktualisieren.
                              Fehler in der Software können auf Github als Issues gemeldet werden.
                              Follow us
                              aktuelle version
                              Zen Cart 1.5.7h deutsch
                              vom 15.04.2024
                              [Download]
                              Lädt...
                              X