Monday, November 11, 2013

how to add new field of product in virtuemart add to cart for virtuemart_order_items and insert the new filed

Hello guys i did the custom process please follow these step

Steps 1-> create your new field on virtuemart_order_items from phpmyadmin
Steps-2>D:\xampp\htdocs\canvasink\administrator\components\com_virtuemart\tables\order_items.php

add your new field property like

var $product_customimage = NULL;


Steps-3>D:\xampp\htdocs\canvasink\administrator\components\com_virtuemart\models\orders.php
line no 1077

put your field like:
$_orderItems->product_customimage='your value';


Steps 4->D:\xampp\htdocs\canvasink\administrator\components\com_virtuemart\models\orders.php
line 200 put you filed name to select statement for retrive
like ::
$q = 'SELECT virtuemart_order_item_id, product_quantity, order_item_name,product_customimage,
    order_item_sku, i.virtuemart_product_id, product_item_price,
    product_final_price, product_basePriceWithTax, product_discountedPriceWithoutTax, product_priceWithoutTax, product_subtotal_with_tax, product_subtotal_discount, product_tax, product_attribute, order_status, p.product_available_date, p.product_availability,
    intnotes, virtuemart_category_id
   FROM (#__virtuemart_order_items i
   LEFT JOIN #__virtuemart_products p
   ON p.virtuemart_product_id = i.virtuemart_product_id)
                        LEFT JOIN #__virtuemart_product_categories c
                        ON p.virtuemart_product_id = c.virtuemart_product_id
   WHERE `virtuemart_order_id`="'.$virtuemart_order_id.'" group by `virtuemart_order_item_id`';

No comments:

Post a Comment