tutorials:zencartmods:invoice_sorter.html
Differences
This shows you the differences between two versions of the page.
|
tutorials:zencartmods:invoice_sorter.html [2011/07/07 19:14] daigo |
tutorials:zencartmods:invoice_sorter.html [2016/01/28 18:05] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{:tutorials:zencartmods:sorter.png?200|}} | ||
| - | If you have a large inventory of items, sorting items on the invoice can make things easier to find. | ||
| - | |||
| - | |||
| - | ==== DB Mod ==== | ||
| - | |||
| - | goes without saying at this point, but do a db backup before you do anything to the db. | ||
| - | |||
| - | <code sql> | ||
| - | CREATE TABLE `shipping_sort` ( | ||
| - | `shipping_sort_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , | ||
| - | `products_id` INT NOT NULL , | ||
| - | `sort_order` INT NOT NULL DEFAULT '0' | ||
| - | ) | ||
| - | </code> | ||
| - | |||
| - | ==== Make a Helper File ==== | ||
| - | |||
| - | [[http://ladyada.net/wiki/tutorials/zencartmods/tariffhelper.html|Make an admin page]] that will help you populate this table with sort orders! | ||
| - | |||
| - | |||
| - | Theres a lot of ways you could do this - here's our file that uses some quick and dirty javascript to make things click and draggable. | ||
| - | |||
| - | {{:tutorials:zencartmods:shipping_sort.php.zip|}} | ||
| - | |||
| - | ==== PHP Mod ==== | ||
| - | |||
| - | Find line 115-121 of **admin/includes/classes/order.php** | ||
| - | |||
| - | <code php> | ||
| - | $orders_products = $db->Execute("select orders_products_id, products_id, products_name, products_model, | ||
| - | products_price, products_tax, products_quantity, | ||
| - | final_price, onetime_charges, | ||
| - | product_is_free | ||
| - | from " . TABLE_ORDERS_PRODUCTS . " | ||
| - | where orders_id = '" . (int)$order_id . "' | ||
| - | order by orders_products_id"); | ||
| - | </code> | ||
| - | |||
| - | and replace it with | ||
| - | |||
| - | <code php> | ||
| - | $orders_products = $db->Execute("select op.orders_products_id, op.products_id, products_name, products_model, | ||
| - | products_price, products_tax, products_quantity, | ||
| - | final_price, onetime_charges, | ||
| - | product_is_free, ss.sort_order | ||
| - | from " . TABLE_ORDERS_PRODUCTS . " op left join shipping_sort ss on ss.products_id = op.products_id | ||
| - | where orders_id = '" . (int)$order_id . "' | ||
| - | order by sort_order"); | ||
| - | </code> | ||
/home/ladyada/public_html/wiki/data/pages/tutorials/zencartmods/invoice_sorter.html.txt · Last modified: 2016/01/28 18:05 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
