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`';
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