Installation / Quick Start Guide

Product Release Information

Product:	Fast Order Search for CRELoaded 6.x
Release Number:	1.0.1
Release Date:	Sep 02, 2007
Customer Support:	For more information or support, please visit our website or contact us from the online form

Introduction

This document describes how to install and get started with Fast Order Search Module. This module allows user search orders by customer name, address, product name or even by order amount.

Features Fast Order Search Module:

Fully integrated into CRELoaded, provides fast order search feature in admin area
Supports multiple order search conditions, allow admin to locate an order by customer name, address, product name, or even by order amount

Note: there's no seperate PHP code come with this contribution, please follow installation instrution for installing this module.

Minimal System Requirements

System requirements are described in the release notes.

Installation

What other software must be installed first?

Before you can install this product, you must obtain access to a web server with the following:

PHP 4.x with:

GD Library
mCrypt
Register Globals set to On via httpd.conf, php.ini or .htaccess

The Apache Webserver
MySQL database
The Linux / Unix Operating System
CRE Loaded 6.15 or later

How do I install CRE Loaded : Fast Order Search Module?

Please follow these steps:

FTP the files to your catalog directory on the webserver.

Open admin/orders.php file, change:
<td align="right"><table border="0" cellspacing="3px" cellpadding="0"> <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get', '', 'SSL'); if (isset($_GET[tep_session_name()])) { echo tep_draw_hidden_field(tep_session_name(), $_GET[tep_session_name()]); } ?> <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?></td> </form></tr> <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get', '', 'SSL'); ?> <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); if (isset($_GET[tep_session_name()])) { echo tep_draw_hidden_field(tep_session_name(), $_GET[tep_session_name()]); } ?></td> </form></tr> </table></td>
to:
<td align="right"><table border="0" cellspacing="3px" cellpadding="0"> <tr> <td class="smallText" align="right"> <?php echo tep_draw_form('filter', FILENAME_ORDERS, '', 'get', '', $request_type) . HEADING_TITLE_SEARCH1; if (isset($_GET[tep_session_name()])) { echo tep_draw_hidden_field(tep_session_name(), $_GET[tep_session_name()]); } ?> </td> <td class="smallText" align="left"> <?php echo tep_draw_input_field('cName', '', 'size="12" style="width:150px" onblur="self.status=Math.random()" onkeyup="ajax_showOptions(this,\'' . (isset($_GET[tep_session_name()]) ? SID : '') . '&cName\',event)"') . '<div id="value_choices" class="autocomplete"></div>'; ?></td> <td class="smallText" align="right"> <?php echo HEADING_TITLE_SEARCH2; ?> </td> <td class="smallText" align="left"> <?php echo tep_draw_input_field('pName', '', 'size="12" style="width:150px" size="12" onblur="self.status=Math.random()" onkeyup="ajax_showOptions(this,\'' . (isset($_GET[tep_session_name()]) ? SID : '') . '&pName\',event)"'); ?></td> <td class="smallText" align="right"> <?php echo HEADING_TITLE_SEARCH; ?> </td> <td class="smallText" align="left"> <?php echo tep_draw_input_field('orderID', '', 'size="12" style="width:100%" onblur="self.status=Math.random()" onkeyup="ajax_showOptions(this,\'' . (isset($_GET[tep_session_name()]) ? SID : '') . '&oID\',event,4)"'); ?></td> <td class="smallText" align="left"><input type="button" onclick="checkform(this.form)" value="<?php echo HEADING_TEXT_RESET; ?>"></td></tr> <tr> <td class="smallText" align="right"> <?php echo HEADING_TITLE_SEARCH3; ?> </td> <td class="smallText" align="left"> <?php echo tep_draw_input_field('address', '', 'size="12" style="width:150px" onblur="self.status=Math.random()" onkeyup="ajax_showOptions(this,\'' . (isset($_GET[tep_session_name()]) ? SID : '') . '&address\',event)"'); ?></td> <td class="smallText" align="right"> <?php echo HEADING_TITLE_SEARCH4; ?> </td> <td class="smallText" align="left"> <?php echo tep_draw_input_field('phone', '', 'size="12" style="width:150px" onblur="self.status=Math.random()" onkeyup="ajax_showOptions(this,\'' . (isset($_GET[tep_session_name()]) ? SID : '') . '&phone\',event)"'); ?></td> <td class="smallText" align="right"> <?php echo HEADING_TITLE_STATUS; ?> </td> <td class="smallText" align="left"> <?php echo tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?> </td> <td class="smallText" align="left"><input type="submit" value="<?php echo HEADING_TEXT_SEARCH; ?>"></form></td></tr> </table></td>

Open admin/orders.php file, after:
<script language="javascript" src="includes/menu.js"></script> <script language="javascript" src="includes/general.js"></script>
add:
<script language="javascript" src="includes/javascript/ajax.js"></script> <script language="javascript" src="includes/javascript/ajax-dynamic-list.js"></script> <style type="text/css"> /* Big box with list of options */ #ajax_listOfOptions{ position:absolute; /* Never change this one */ /*width:175px; Width of box */ /*height:250px; Height of box */ overflow:auto; /* Scrolling features */ border:1px solid #317082; /* Dark green border */ background-color:#FFF; /* White background color */ text-align:left; font-size:11px; z-index:100; font-family: Courier New, Courier, mono; } #ajax_listOfOptions div{ /* General rule for both .optionDiv and .optionDivSelected */ margin:1px; padding:1px; cursor:pointer; font-size:11px; } #ajax_listOfOptions .optionDiv{ /* Div for each item in list */ } #ajax_listOfOptions .optionDivSelected{ /* Selected item in the list */ background-color:#317082; color:#FFF; } #ajax_listOfOptions_iframe{ background-color:#F00; position:absolute; z-index:5; } </style>

Open admin/orders.php file, after:
$action = (isset($_GET['action']) ? $_GET['action'] : '');
add:
$cName = str_replace(array('%', '_'), array('\%', '\_'), tep_db_input($_GET['cName'])); $pName = str_replace(array('%', '_'), array('\%', '\_'), tep_db_input($_GET['pName'])); $address = str_replace(array('%', '_'), array('\%', '\_'), tep_db_input($_GET['address'])); $phone = str_replace(array('%', '_'), array('\%', '\_'), tep_db_input($_GET['phone'])); $orderID = str_replace(array('%', '_'), array('\%', '\_'), tep_db_input($_GET['orderID']));

Open admin/orders.php file, change:
if (isset($_GET['cID'])) { $cID = tep_db_prepare_input($_GET['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and ot.orders_id = o.orders_id and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' and o.orders_type = 0 order by orders_id DESC"; } elseif (isset($_GET['status']) && (tep_not_null($_GET['status']))) { $status = tep_db_prepare_input($_GET['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and o.orders_type = 0 order by o.orders_id DESC"; } else { $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and o.orders_type = 0 " . $sortorder; }
to:
if (isset($_GET['cID'])) { $cID = tep_db_prepare_input($_GET['cID']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and ot.orders_id = o.orders_id and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; } else { if (isset($_GET['status']) && (tep_not_null($_GET['status']))) { $status = tep_db_prepare_input($_GET['status']); $orders_query_status_str = " and s.orders_status_id = '" . (int)$status . "'"; } else { $orders_query_status_str = ''; } $select = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total"; $from = " from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s"; $where = " where o.orders_status = s.orders_status_id and ot.orders_id = o.orders_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total'" . $orders_query_status_str; if (!empty($orderID)) { $where .= " and o.orders_id like '" . $orderID . "%'"; } if (!empty($cName)) { $where .= " and (o.customers_name like '" . $cName . "%' OR substring(o.customers_name, locate(' ', o.customers_name) + 1) like '" . $cName . "%' OR o.customers_email_address like '" . $cName . "%')"; } if (!empty($pName)) { $from .= ", " . TABLE_ORDERS_PRODUCTS . " op"; $where .= " and o.orders_id = op.orders_id and op.products_name like '%" . $pName . "%'"; } if (!empty($address)) { $where .= " and CONCAT(o.delivery_street_address, ' ', o.delivery_city, ' ', o.delivery_state) like '%" . $address . "%'"; } if (!empty($phone)) { $where .= " and REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(o.customers_telephone, '+', ''), '-', ''), '(', ''), ')', ''), ' ', ''), '.', '') like '%" . preg_replace('/[^0-9]/', '', $phone) . "%' "; } $orders_query_raw = $select . $from . $where . ' ' . $sortorder; }

Open admin/includes/languages/english/orders.php file, add:
define('HEADING_TITLE_SEARCH1', 'Customer Name or Email: '); define('HEADING_TITLE_SEARCH2', 'Product Name: '); define('HEADING_TITLE_SEARCH3', 'Address: '); define('HEADING_TITLE_SEARCH4', 'Phone Number: '); define('HEADING_TEXT_SEARCH', 'Search'); define('HEADING_TEXT_RESET', 'Reset');

How can I uninstall CRE Loaded : Add Navigation Link on Product Info Module?

Change all modified files back.

What if I encounter problems?

Please see the troubleshooting section in the FAQ.