Example #1
0
        </tr>
<?php 
        if ($pInfo->products_date_available > date('Y-m-d')) {
            ?>
      <tr>
        <td align="center" class="smallText"><?php 
            echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, oos_date_long($pInfo->products_date_available));
            ?>
</td>
      </tr>
<?php 
        } else {
            ?>
      <tr>
        <td align="center" class="smallText"><?php 
            echo sprintf(TEXT_PRODUCT_DATE_ADDED, oos_date_long($pInfo->products_date_added));
            ?>
</td>
      </tr>
<?php 
        }
        ?>
      <tr>
        <td><?php 
        echo oos_draw_separator('trans.gif', '1', '10');
        ?>
</td>
      </tr>
<?php 
    }
    if (isset($_GET['read']) && $_GET['read'] == 'only') {
Example #2
0
    $reviews_split = new splitPageResults($nCurrentPageNumber, MAX_DISPLAY_NEW_REVIEWS, $reviews_result_raw, $reviews_numrows);
    $reviews_result = $dbconn->Execute($reviews_result_raw);

    $aReviews = array();
    while ($reviews = $reviews_result->fields)
    {
        $aReviews[] = array('id' => $reviews['reviews_id'],
                            'products_id' => $reviews['products_id'],
                            'reviews_id' => $reviews['reviews_id'],
                            'products_name' => $reviews['products_name'],
                            'products_image' => $reviews['products_image'],
                            'authors_name' => $reviews['customers_name'],
                            'review' => htmlspecialchars(substr($reviews['reviews_text'], 0, 250)) . '..',
                            'rating' => $reviews['reviews_rating'],
                            'word_count' => oosWordCount($reviews['reviews_text'], ' '),
                            'date_added' => oos_date_long($reviews['date_added']));
        $reviews_result->MoveNext();
    }

    // links breadcrumb
    $oBreadcrumb->add($aLang['navbar_title']);

    $oos_pagetitle = $oBreadcrumb->trail_title(' &raquo; ');
    $oos_pagetitle .= '&raquo;' . OOS_META_TITLE;

    // assign Smarty variables;
    $oSmarty->assign(
        array(
              'pagetitle'         => htmlspecialchars($oos_pagetitle),
              'meta_description'  => htmlspecialchars($oos_meta_description),
              'meta_keywords'     => htmlspecialchars($oos_meta_keywords),
Example #3
0
 }
 $UpdateOrders .= " where orders_id = '" . oos_db_input($oID) . "';";
 $dbconn->Execute($UpdateOrders);
 $order_updated = true;
 $check_status_result = $dbconn->Execute("select customers_name, customers_email_address, orders_status, date_purchased from " . $oostable['orders'] . " where orders_id = '" . (int) $oID . "'");
 $check_status = $check_status_result->fields;
 // Update Status History & Email Customer if Necessary
 if ($order->info['orders_status'] != $status) {
     // Notify Customer
     $customer_notified = '0';
     if (isset($_POST['notify']) && $_POST['notify'] == 'on') {
         $notify_comments = '';
         if (isset($_POST['notify_comments']) && $_POST['notify_comments'] == 'on') {
             $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";
         }
         $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . oos_catalog_link($aFilename['catalog_account_history_info'], 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . oos_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
         oos_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
         $customer_notified = '1';
     }
     // "Status History" table has gone through a few
     // different changes, so here are different versions of
     // the status update.
     // NOTE: Theoretically, there shouldn't be a
     //       orders_status field in the ORDERS table. It
     //       should really just use the latest value from
     //       this status history table.
     if ($CommentsWithStatus) {
         $dbconn->Execute("insert into " . $oostable['orders_status_history'] . "\n        (orders_id, orders_status_id, date_added, customer_notified, comments)\n        values ('" . oos_db_input($oID) . "', '" . oos_db_input($status) . "', '" . date("Y-m-d H:i:s", time()) . "', " . oos_db_input($customer_notified) . ", '" . oos_db_input($comments) . "')");
     } else {
         if ($OldNewStatusValues) {
             $dbconn->Execute("insert into " . $oostable['orders_status_history'] . "\n          (orders_id, new_value, old_value, date_added, customer_notified)\n          values ('" . oos_db_input($oID) . "', '" . oos_db_input($status) . "', '" . $order->info['orders_status'] . "', '" . date("Y-m-d H:i:s", time()) . "', " . oos_db_input($customer_notified) . ")");
Example #4
0
      </tr>
</table>

          </td>
        </tr>
<?php
      if ($pInfo->products_date_available > date('Y-m-d')) {
?>
      <tr>
        <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, oos_date_long($pInfo->products_date_available)); ?></td>
      </tr>
<?php
      } else {
?>
      <tr>
        <td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_ADDED, oos_date_long($pInfo->products_date_added)); ?></td>
      </tr>
<?php
      }
?>
      <tr>
        <td><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
      </tr>
<?php
    }
    if (isset($_GET['read']) && ($_GET['read'] == 'only')) {
      if (isset($_GET['origin'])) {
        $pos_params = strpos($_GET['origin'], '?', 0);
        if ($pos_params != false) {
          $back_url = substr($_GET['origin'], 0, $pos_params);
          $back_url_params = substr($_GET['origin'], $pos_params + 1);
        ?>
                    <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'">
<?php 
        switch ($srView) {
            case '3':
                ?>
                      <td class="dataTableContent" align="right"><?php 
                echo oos_date_long(date("Y-m-d\\ H:i:s", $sr->showDate)) . " - " . oos_date_short(date("Y-m-d\\ H:i:s", $sr->showDateEnd));
                ?>
</td>
<?php 
                break;
            case '4':
                ?>
                      <td class="dataTableContent" align="right"><?php 
                echo oos_date_long(date("Y-m-d\\ H:i:s", $sr->showDate));
                ?>
</td>
<?php 
                break;
            default:
                ?>
                      <td class="dataTableContent" align="right"><?php 
                echo oos_date_short(date("Y-m-d\\ H:i:s", $sr->showDate)) . " - " . oos_date_short(date("Y-m-d\\ H:i:s", $sr->showDateEnd));
                ?>
</td>
<?php 
        }
        ?>
                      <td class="dataTableContent" align="right"><?php 
        echo $info[0]['order'];
while ($sr->actDate < $sr->endDate) {
  $info = $sr->getNext();
  $last = count($info) - 1;
  if ($srExp < 2) {
?>
                    <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'">
<?php
    switch ($srView) {
      case '3':
?>
                      <td class="dataTableContent" align="right"><?php echo oos_date_long(date("Y-m-d\ H:i:s", $sr->showDate)) . " - " . oos_date_short(date("Y-m-d\ H:i:s", $sr->showDateEnd)); ?></td>
<?php
        break;
      case '4':
?>
                      <td class="dataTableContent" align="right"><?php echo oos_date_long(date("Y-m-d\ H:i:s", $sr->showDate)); ?></td>
<?php
        break;
      default;
?>
                      <td class="dataTableContent" align="right"><?php echo oos_date_short(date("Y-m-d\ H:i:s", $sr->showDate)) . " - " . oos_date_short(date("Y-m-d\ H:i:s", $sr->showDateEnd)); ?></td>
<?php
    }
?>
                      <td class="dataTableContent" align="right"><?php echo $info[0]['order']; ?></td>
                      <td class="dataTableContent" align="right"><?php echo $info[$last - 1]['totitem']; ?></td>
                      <td class="dataTableContent" align="right"><?php echo $currencies->format($info[$last - 1]['totsum']);?></td>
                      <td class="dataTableContent" align="right"><?php echo $currencies->format($info[0]['shipping']);?></td>
                    </tr>
<?php
  } else {
Example #7
0
    require 'includes/info_message.php';
    require 'includes/oos_blocks.php';
}
if (USE_CACHE == '1' && !SID) {
    $oSmarty->caching = 2;
    $oSmarty->cache_lifetime = 2 * 24 * 3600;
}
if (!$oSmarty->is_cached($aOption['template_main'], $contents_cache_id)) {
    require 'includes/languages/' . $sLanguage . '/reviews_reviews.php';
    $reviewstable = $oostable['reviews'];
    $productstable = $oostable['products'];
    $reviews_descriptiontable = $oostable['reviews_description'];
    $products_descriptiontable = $oostable['products_description'];
    $reviews_result_raw = "SELECT r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products_id,\n                                  pd.products_name, p.products_image, r.customers_name\n                           FROM {$reviewstable} r,{$reviews_descriptiontable} rd,\n                                {$productstable} p, {$products_descriptiontable} pd\n                           WHERE p.products_status >= '1'\n                             AND p.products_id = r.products_id\n                             AND r.reviews_id = rd.reviews_id\n                             AND p.products_id = pd.products_id\n                             AND pd.products_languages_id = '" . intval($nLanguageID) . "'\n                             AND rd.reviews_languages_id = '" . intval($nLanguageID) . "'\n                           ORDER BY r.reviews_id DESC";
    $reviews_split = new splitPageResults($_GET['page'], MAX_DISPLAY_NEW_REVIEWS, $reviews_result_raw, $reviews_numrows);
    $reviews_result = $dbconn->Execute($reviews_result_raw);
    $aReviews = array();
    while ($reviews = $reviews_result->fields) {
        $aReviews[] = array('id' => $reviews['reviews_id'], 'products_id' => $reviews['products_id'], 'reviews_id' => $reviews['reviews_id'], 'products_name' => $reviews['products_name'], 'products_image' => $reviews['products_image'], 'authors_name' => $reviews['customers_name'], 'review' => htmlspecialchars(substr($reviews['reviews_text'], 0, 250)) . '..', 'rating' => $reviews['reviews_rating'], 'word_count' => oosWordCount($reviews['reviews_text'], ' '), 'date_added' => oos_date_long($reviews['date_added']));
        $reviews_result->MoveNext();
    }
    // links breadcrumb
    $oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aModules['reviews'], $aFilename['reviews_reviews']));
    $oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'specials.gif', 'oos_page_split' => $reviews_split->display_count($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, $_GET['page'], $aLang['text_display_number_of_reviews']), 'oos_display_links' => $reviews_split->display_links($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', 'info'))), 'oos_page_numrows' => $reviews_numrows, 'oos_reviews_array' => $aReviews));
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';