Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Display all orders using a Specific Gift Certificate
 
Reply
   X-Cart forums > X-Cart 4 > Changing and adding new features
 
Thread Tools Search this Thread
  #1  
Old 08-05-2007, 07:06 PM
 
pavant pavant is offline
 

Advanced Member
  
Join Date: Oct 2004
Location: Chicago, Illinois
Posts: 84
 

Default Display all orders using a Specific Gift Certificate

We issue gift certificates for customer rewards so I wanted to be able to search for and display all orders that used a specific gift certificate for payment. Here are the mods I made to our 4.1.8 release of xcart gold:

In skin1/main/orders.tpl after

Quote:

['posted_data[orderid1]', '{$search_prefilled.orderid1}'],
['posted_data[orderid2]', '{$search_prefilled.orderid2}'],

insert the following line
Quote:

['posted_data[giftcertid]', '($search_prefilled.giftcertid)'],

After this code:
Quote:

<table cellpadding="0" cellspacing="0">
<tr>
<td><input type="text" size="10" maxlength="15" name="posted_data[total_min]" value="{if $search_prefilled eq ""}{$zero}{else}{$search_prefilled.total_min|forma tprice}{/if}" /></td>
<td>&nbsp;-&nbsp;</td>
<td><input type="text" size="10" maxlength="15" name="posted_data[total_max]" value="{$search_prefilled.total_max|formatprice}" /></td>
</tr>
</table>
</td>
</tr>

Insert the following:
Quote:

<tr>
<td class="FormButton" nowrap="nowrap">Gift Certificate Id:</td>
<td width="10">&nbsp;</td>
<td>
<input type="text" name="posted_data[giftcertid]" size="25" maxlength="30" value="{$search_prefilled.giftcertid}" />
</td>
</tr>

In include/orders.php make the following changes

Replace:
Quote:

$advanced_options = array("orderid1", "orderid2", "total_max", "payment_method", "shipping_method", "status", "provider", "features", "product_substring", "productcode", "productid", "price_max", "customer", "address_type", "phone", "email");

With this:
Quote:

$advanced_options = array("orderid1", "orderid2", "total_max", "giftcertid", "payment_method", "shipping_method", "status", "provider", "features", "product_substring", "productcode", "productid", "price_max", "customer", "address_type", "phone", "email");

After :
Quote:

if (!empty($data["total_max"]))
$search_condition .= " AND $sql_tbl[orders].total<='".doubleval($data["total_max"])."'";

Insert:
Quote:

# Search by Gift Certificate
if (!empty($data["giftcertid"]))
$search_condition .= " AND $sql_tbl[orders].giftcert_ids LIKE '%".$data["giftcertid"]."%'";


This search appears on the admin order search panel only. This code is provided to help other xcart users but I don't provide any support so use it at your own risk.
__________________
X-Cart Gold v 4.1.10
PHP 5.2.4
MySQL 5.0.45 standard
Apache/2.2.6
OS - Linux
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Changing and adding new features


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 06:21 AM.

   

 
X-Cart forums © 2001-2018