[pavant]

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

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

insert the following line

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

After this code:

<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:

<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:

$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:

$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 :

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

Insert:

# 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.