Re: Direct access to orders and items
 

im not sure, its a simple expansion of the built in search function. i dont have 4.1 though.

Re: Direct access to orders and items
 

Works perfectly in 4.1.4 - thanks.

I have removed the "Submit" buttons though as I usually just press the enter key (also means that less space is taken on the page).

My code is:

<form action="order.php">
Order No.<input type="text" name="orderid" onclick="find">
</form>

<form action="product_modify.php">
Prod. ID<input type="text" name="productid" onclick="find">
</form>

Re: Direct access to orders and items
 

And you can put the code into admin/menu_admin.tpl for 4.1.x users.

Re: Direct access to orders and items
 

4.1.8

I put Audioline's handy mod into one of the standard menu boxes as follows:

1. Create new file admin/quick_find.tpl
2. INSERT
after
(or wherever you like)

3. Create a new language variable lbl.quick_find with whatever name you choose. (eg "Quick Find")

Attachment 534

Thanks Audioline.

Re: Direct access to orders and items
 

To have this in the header bar you just make these simple changes. I put this in my header bar since I already have to scroll up & down for the left menu. It has enough in it right now.

In admin_head.tpl change this code:

To this code:

Here is a picture:
http://www.tnpaintballers.com/images/xcart_mods/admin_header_bar_mod.jpg

Re: Direct access to orders and items
 

I think I found a fix!

This coding isn't the best, but it works so far. I tested it very little, so there might be some bugs. You can now search with SKU's or the productid.

If you pull up an item in your database viewing it as a customer would you see something like this in the URL: product.php?productid=16134, but the SKU you assigned this product would be SKU1234 or just 1234.

With the way this Direct access to orders worked initially is that you had to enter that longer 16134 as in the example above. If you needed to edit an item on your site you wouldn't know that number, but you would know the SKU number you assigned the item.

With this mod I have posted below you can select whether you want to search by your SKU number or that longer number which is the productid for the database.

For you advance users this allows you to search by either the productid = PID or productcode = SKU.

First thing is add these to input fields to the form to search for products Also change the name of the input box from productid to search_id


In this file /include/product_modify.tpl add this code

Right below this code
This will work with girlsbits version that uses the onclick function.
http://www.tnpaintballers.com/images/xcart_mods/admin_header_bar_mod_2.jpg

Re: Direct access to orders and items
 

Sweet ... Nice addition ..

Re: Direct access to orders and items
 

You will need to add this IF statement to hide these boxes if the admin isn't logged in. If not then anybody that gets to your Admin panel will see these input boxes.

Add this right before the opening <form> line of each form.


Add this right after the closing </form> line of each form.


If you just want to copy & past then replace each form of the previous code I gave with this:

This is the Order Search form


This is the Product Search form

Re: Direct access to orders and items
 

Hi,

I've implemented this mod with little hiccup... the order bit works but not the product bit. When I enter in my sku, my url gets translated to:-
https://www.womansworld.com.au/dev/xcart/admin/product_modify.php?search_id=D1429&search_types=1

I can see the url is wrong and the word admin should be the word provider. My code in include/product_modify.php is this:-

ini_set("memory_limit", "32M");

function get_productid($product_code) {
$category_query = db_query("SELECT productid FROM xcart_products WHERE productcode = '" . (int)$product_code . "'");
$category = mysql_fetch_array($category_query, MYSQL_ASSOC);

return $category['productid'];
}
if ($HTTP_POST_VARS['search_types'] == 1){
?>
<script type="text/javascript" language="JavaScript"><!--
setTimeout('Redirect()',500);
function Redirect()
{
location.href = '../provider/product_modify.php?productid=<?PHP echo get_productid($HTTP_POST_VARS['search_id']) ?>';
}
// --></script>
<?PHP
}elseif ($HTTP_POST_VARS['search_types'] == 2){
?>
<script type="text/javascript" language="JavaScript"><!--
setTimeout('Redirect()',500);
function Redirect()
{
location.href = '../provider/product_modify.php?productid=<?PHP echo $HTTP_POST_VARS['search_id'] ?>';
}
// --></script>
<?PHP
}

The code in my admin_head.tpl for the order bit is:-
{if $login ne ''}
<form action="product_modify.php"> Item ID:<input type="text" name="search_id"><input type="submit" value="find">
<input type="radio" id="search_types" name="search_types" value="1" checked="checked" />{$lng.lbl_sku}
<input type="radio" id="search_types" name="search_types" value="2" />PID
</form>
{/if}

I am not sure why I am getting a different url and how to fix it?

Re: Direct access to orders and items
 

Hi,

I finally got my code to work. :D I had <input type="submit" value="find"> in the wrong spot in head_admin.tpl. However if anyone is interested, I had to remove the reference to (int) in the product_modify.php file. For me it was not appending the productid to the url so it couldn't find the product. My php select statement looks like this now:-

$category_query = db_query("SELECT productid FROM xcart_products WHERE productcode = '" . $product_code . "'");