StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>After few days ago, i'm hard-working and know that: - Override app/code/core/Mage/Checkout/Model/Cart.php and edit function like that:</p> <pre><code> public function updateItems($data) { Mage::dispatchEvent('checkout_cart_update_items_before', array('cart'=>$this, 'info'=>$data)); foreach ($data as $itemId => $itemInfo) { $item = $this->getQuote()->getItemById($itemId); if (!$item) { continue; } if (!empty($itemInfo['remove']) || (isset($itemInfo['qty']) && $itemInfo['qty']=='0')) { $this->removeItem($itemId); continue; } $qty = isset($itemInfo['qty']) ? (float) $itemInfo['qty'] : false; if ($qty > 0) { $item->setQty($qty); } /* Start: Custom code added for license start date */ if(!empty($itemInfo['license_start_date'])) { $write = Mage::getSingleton('core/resource')->getConnection('core_write'); # make the frame_queue active $query = "UPDATE `sales_flat_quote_item` SET license_start_date = '".$itemInfo['license_start_date']."' where item_id = $itemId"; $write->query($query); $item->setLicense_start_date($itemInfo['license_start_date']); } /* End: Custom code added for licensee start date */ } Mage::dispatchEvent('checkout_cart_update_items_after', array('cart'=>$this, 'info'=>$data)); return $this; } </code></pre> <p>and copy app/code/core/Mage/Adminhtml/Block/Sales/Order/Items/Abstract.php to local (app/code/local/Mage/Adminhtml/Block/Sales/Order/Items/Abstract.php) and add this function:</p> <pre><code>public function getLicense_start_date($item) { $itemId = $item->getId(); $write = Mage::getSingleton('core/resource')->getConnection('core_write'); $query = "SELECT q.* FROM `sales_flat_order_item` o LEFT JOIN `sales_flat_quote_item` q on o.quote_item_id = q.item_id WHERE o.item_id = $itemId"; # For older versions of Magento /* $query = "SELECT q.* FROM `sales_order_entity_int` o LEFT JOIN `sales_flat_quote_item` q on o.value = q.entity_id WHERE o.entity_id = $itemId AND o.attribute_id = 343"; */ $res = $write->query($query); while ($row = $res->fetch() ) { if(key_exists('itemcomment',$row)) { echo nl2br($row['itemcomment']); } } } </code></pre> <p>To add the license time column to the items edit the .phtml file below: app/design/adminhtml/default/default/template/sales/order/view/items.phtml (you can add you theme in adminhtml to edit)</p> <p>Adding header for items to make it look like below:</p> <pre><code><tr class="headings"> <th><?php echo $this->helper('sales')->__('Product') ?></th> <th><?php echo $this->helper('sales')->__('Licens Time') ?></th> <th><?php echo $this->helper('sales')->__('Item Status') ?></th> </code></pre> <p>And adding Column with comments. app/design/adminhtml/default/default/template/sales/order/view/items/renderer/default.phtml Add a column for item comments juts before status columns to make it look a like below.</p> <pre><code><td><?php echo $this->getLicense_start_date($_item) ?></td>  <td class="a-center"><?php echo $_item->getStatus() ?></td> </code></pre> <p>Note that: In your theme, for the file: template/checkout/cart.phtml Add the new heading along with other heading for cart items and in the file: template/checkout/cart/item/default.phtml use datepicker to selected date with code like below:</p> <pre><code><td class="a-center"> <input type="text" name="cart[<?php echo $_item->getId() ?>][license_start_date]" rows="3" cols="20"><?php echo $_item->getLicense_start_date() ?></input> </td> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload