This shows you the differences between two versions of the page.
tutorials:zencartmods:invoice_sorter.html [2011/07/07 19:28] daigo |
tutorials:zencartmods:invoice_sorter.html [2016/01/28 18:05] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{:tutorials:zencartmods:sorter.jpg|}} | ||
- | {{:tutorials:zencartmods:sorter2.jpg|}} | ||
- | |||
- | |||
- | 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> |