How to remove decimal price in magento

May 16, 2014/0 Comments/in Uncategorized /by puneetk00

Open code/core/Mage/Directory/Model/Currency.php
Find the following :-

public function format($price, $options=array(), $includeContainer = true, $addBrackets = false)

{

return $this->formatPrecision($price, 2, $options, $includeContainer, $addBrackets);

}

on line no 194

change this code to:-

public function format($price, $options=array(), $includeContainer = true, $addBrackets = false)

{

return $this->formatPrecision($price, 0, $options, $includeContainer, $addBrackets);

}

Puneet Kumar Magento Developer

magento how to add new attribute for all product manualy by php code

January 17, 2014/0 Comments/in Uncategorized /by puneetk00

magento how to add new attribute for all product manualy by php code

this below link given by Raghuvendera this is really help full

http://www.webcenter.co.in/how-to-add-custom-fields-for-order-line-items-in-magento

Puneet Kumar Magento Developer

How to add custom fields for Order Line Items with price in magento

January 15, 2014/0 Comments/in Uncategorized /by puneetk00

Work Flow to add custom Field to Order line Item
Use
this url to add to cart: Ex:
http://192.168.1.9/sspc_test/SSPC1900/checkout/cart/add/?product=196&qty=2&training_location=California
1. checkout_cart_item_default.phtml:::
Add the following below product name
<dl class=”item-options Kiran” id=”checkout_cart_item_default”>
<dt>Training Location</dt>
<dd><?php echo $_item->getTrainingLocation(); ?></dd>
</dl>
2. Table: sales_flat_quote_item
Add field: training_location
3. Product Detailed Page: Add training_location text field as input
4. Code -> Core -> Mage -> Sales -> Model -> Quote.php
Find: public function addItem(Mage_Sales_Model_Quote_Item $item)
Add: $item->setTrainingLocation($_REQUEST[‘training_location’]);
Befoe: $item->setQuote($this);
—————
5. Table: sales_flat_order_item
Add field: training_location
6. XML: code_core_mage_sales_etc_config.xml
ADD: <training_location><to_order_item>*</to_order_item></training_location>
Between: <sales_convert_quote_item> and </sales_convert_quote_item>
Also Add:
<training_location><to_quote_item>*</to_quote_item><to_invoice_item>*</to_invoice_item><to_shipment_item>*</to_shipment_item><to_cm_item>*</to_
cm_item></training_location>
Between: <sales_convert_order_item> and </sales_convert_order_item>
—— Show The Info In Various Locations ——
To show in admin orders area
7. app_design_adminHTML_default_default_template_sales_order_view_items_renderer_default.phtml
Add:
<?php if($_item->getTrainingLocation()): ?>
<?php echo “Training Location: “.$_item->getTrainingLocation(); ?>
<?php endif; ?>
Below: <?php echo $this->getColumnHtml($_item, ‘name’) ?>
8. To Show in Checkout/Order review Page
frontend_template_checkout_onepage_review_item.phtml
Add: <?php if ($_item->getTrainingLocation()):?>
<dl class=”item-options Kiran” id=”checkout_cart_item_default”>
<dt>Training Location</dt>
<dd><?php echo $_item->getTrainingLocation(); ?></dd>
</dl>
<?php endif; ?>
Below: <h3 class=”product-name”><?php echo $this->htmlEscape($this->getProductName()) ?></h3>
9. To show in Myorders view page
frontend_template_sales_order_items_renderer_default.phtml
Add: <?php if ($_item->getTrainingLocation()):?>
<dl class=”item-options Kiran” id=”checkout_cart_item_default”>
<dt>Training Location</dt>
<dd><?php echo $_item->getTrainingLocation(); ?></dd>
</dl>
<?php endif; ?>
Below: <h3 class=”product-name”><?php echo $this->htmlEscape($_item->getName()) ?></h3>
10.
######################################
Usefull Links:
http://www.magentocommerce.com/boards/viewthread/19344/
http://magentocoder.jigneshpatel.co.in/add-to-cart-with-custom-attributes-values/
Use like below in product view page
<input type=”text”title=”Qty” value=”My Test Location” maxlength=”12″ id=”training_location” name=”training_location”>

please let me know how can i add also price with this attribute thanx advance

Puneet Kumar Magento Developer

Mysql trigger query

January 15, 2014/0 Comments/in Mysql /by puneetk00

Puneet Kumar Magento Developer

Adding order item to orders grid in Magento

December 28, 2013/0 Comments/in Uncategorized /by puneetk00

Adding order item to orders grid in Magento

<?php /** * Magento * * NOTICE OF LICENSE * * This source file is subject to the Open Software License (OSL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to license@magentocommerce.com so we can send you a copy immediately. * * DISCLAIMER * * Do not edit or add to this file if you wish to upgrade Magento to newer * versions in the future. If you wish to customize Magento for your * needs please refer to http://www.magentocommerce.com for more information. * * @category Mage * @package Mage_Adminhtml * @copyright Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ /** * Adminhtml sales orders grid * * @category Mage * @package Mage_Adminhtml * @author Magento Core Team <core@magentocommerce.com> */ class Mage_Adminhtml_Block_Sales_Order_Grid extends Mage_Adminhtml_Block_Widget_Grid { public function __construct() { parent::__construct(); $this->setId(‘sales_order_grid’); $this->setUseAjax(true); $this->setDefaultSort(‘created_at’); $this->setDefaultDir(‘DESC’); $this->setSaveParametersInSession(true); } /** * Retrieve collection class * * @return string */ protected function _getCollectionClass() { return ‘sales/order_grid_collection’; } protected function _prepareCollection() { $userArray = Mage::getSingleton(‘admin/session’)->getData(); $user = Mage::getSingleton(‘admin/session’); $userId = $user->getUser()->getUserId(); $connection = Mage::getSingleton(‘core/resource’)->getConnection(‘core_read’); $sql = “Select * from sales_flat_order_grid as sss, junaidbhura_jbmarketplace_products as vitem, sales_flat_order_item as item WHERE vitem.product_id = item.product_id and sss.entity_id = item.order_id and vitem.user_id = $userId”; $rows = $connection->fetchAll($sql); //fetchRow($sql), fetchOne($sql),… //Zend_Debug::dump($rows); $pk = 0; foreach($rows as $value){ $pkorder[] = $rows[$pk][‘order_id’]; $pk++; } //print_r( $pkorder); //print_r($userId); //die; $collection = Mage::getResourceModel($this->_getCollectionClass()); if($userId == 1 ){ }else{ $collection->addFieldToFilter(‘entity_id’, array(‘in’ => array( $pkorder ))); } $this->setCollection($collection); return parent::_prepareCollection(); } protected function _prepareColumns() { $this->addColumn(‘real_order_id’, array( ‘header’=> Mage::helper(‘sales’)->__(‘Order #’), ‘width’ => ’80px’, ‘type’ => ‘text’, ‘index’ => ‘increment_id’, )); if (!Mage::app()->isSingleStoreMode()) { $this->addColumn(‘store_id’, array( ‘header’ => Mage::helper(‘sales’)->__(‘Purchased From (Store)’), ‘index’ => ‘store_id’, ‘type’ => ‘store’, ‘store_view’=> true, ‘display_deleted’ => true, )); } $this->addColumn(‘created_at’, array( ‘header’ => Mage::helper(‘sales’)->__(‘Purchased On’), ‘index’ => ‘created_at’, ‘type’ => ‘datetime’, ‘width’ => ‘100px’, )); $this->addColumn(‘billing_name’, array( ‘header’ => Mage::helper(‘sales’)->__(‘Bill to Name’), ‘index’ => ‘billing_name’, )); $this->addColumn(‘shipping_name’, array( ‘header’ => Mage::helper(‘sales’)->__(‘Ship to Name’), ‘index’ => ‘shipping_name’, )); $this->addColumn(‘base_grand_total’, array( ‘header’ => Mage::helper(‘sales’)->__(‘G.T. (Base)’), ‘index’ => ‘base_grand_total’, ‘type’ => ‘currency’, ‘currency’ => ‘base_currency_code’, )); $this->addColumn(‘grand_total’, array( ‘header’ => Mage::helper(‘sales’)->__(‘G.T. (Purchased)’), ‘index’ => ‘grand_total’, ‘type’ => ‘currency’, ‘currency’ => ‘order_currency_code’, )); $this->addColumn(‘status’, array( ‘header’ => Mage::helper(‘sales’)->__(‘Status’), ‘index’ => ‘status’, ‘type’ => ‘options’, ‘width’ => ’70px’, ‘options’ => Mage::getSingleton(‘sales/order_config’)->getStatuses(), )); if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/view’)) { $this->addColumn(‘action’, array( ‘header’ => Mage::helper(‘sales’)->__(‘Action’), ‘width’ => ’50px’, ‘type’ => ‘action’, ‘getter’ => ‘getId’, ‘actions’ => array( array( ‘caption’ => Mage::helper(‘sales’)->__(‘View’), ‘url’ => array(‘base’=>’*/sales_order/view’), ‘field’ => ‘order_id’ ) ), ‘filter’ => false, ‘sortable’ => false, ‘index’ => ‘stores’, ‘is_system’ => true, )); } $this->addRssList(‘rss/order/new’, Mage::helper(‘sales’)->__(‘New Order RSS’)); $this->addExportType(‘*/*/exportCsv’, Mage::helper(‘sales’)->__(‘CSV’)); $this->addExportType(‘*/*/exportExcel’, Mage::helper(‘sales’)->__(‘Excel XML’)); return parent::_prepareColumns(); } protected function _prepareMassaction() { $this->setMassactionIdField(‘entity_id’); $this->getMassactionBlock()->setFormFieldName(‘order_ids’); $this->getMassactionBlock()->setUseSelectAll(false); if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/cancel’)) { $this->getMassactionBlock()->addItem(‘cancel_order’, array( ‘label’=> Mage::helper(‘sales’)->__(‘Cancel’), ‘url’ => $this->getUrl(‘*/sales_order/massCancel’), )); } if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/hold’)) { $this->getMassactionBlock()->addItem(‘hold_order’, array( ‘label’=> Mage::helper(‘sales’)->__(‘Hold’), ‘url’ => $this->getUrl(‘*/sales_order/massHold’), )); } if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/unhold’)) { $this->getMassactionBlock()->addItem(‘unhold_order’, array( ‘label’=> Mage::helper(‘sales’)->__(‘Unhold’), ‘url’ => $this->getUrl(‘*/sales_order/massUnhold’), )); } $this->getMassactionBlock()->addItem(‘pdfinvoices_order’, array( ‘label’=> Mage::helper(‘sales’)->__(‘Print Invoices’), ‘url’ => $this->getUrl(‘*/sales_order/pdfinvoices’), )); $this->getMassactionBlock()->addItem(‘pdfshipments_order’, array( ‘label’=> Mage::helper(‘sales’)->__(‘Print Packingslips’), ‘url’ => $this->getUrl(‘*/sales_order/pdfshipments’), )); $this->getMassactionBlock()->addItem(‘pdfcreditmemos_order’, array( ‘label’=> Mage::helper(‘sales’)->__(‘Print Credit Memos’), ‘url’ => $this->getUrl(‘*/sales_order/pdfcreditmemos’), )); $this->getMassactionBlock()->addItem(‘pdfdocs_order’, array( ‘label’=> Mage::helper(‘sales’)->__(‘Print All’), ‘url’ => $this->getUrl(‘*/sales_order/pdfdocs’), )); $this->getMassactionBlock()->addItem(‘print_shipping_label’, array( ‘label’=> Mage::helper(‘sales’)->__(‘Print Shipping Labels’), ‘url’ => $this->getUrl(‘*/sales_order_shipment/massPrintShippingLabel’), )); return $this; } public function getRowUrl($row) { if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/view’)) { return $this->getUrl(‘*/sales_order/view’, array(‘order_id’ => $row->getId())); } return false; } public function getGridUrl() { return $this->getUrl(‘*/*/grid’, array(‘_current’=>true)); } }

Puneet Kumar Magento Developer

magento order viedw how to add new filster coloume ?

December 27, 2013/0 Comments/in Magento2 /by puneetk00

magento order viedw how to add new filster coloume ?

Puneet Kumar Magento Developer

Magento how to mail in magento php script

December 27, 2013/0 Comments/in Magento2 /by puneetk00

Magento how to mail in magento php script ?

try { /* Note: We get the processed email template and subject and send it manually to counter a problem of the transactional email not sending (for some weird reason!) i.e: $email_template->send( $to_email, $to_name, array( ‘order’ => $order, ‘store’ => Mage::app()->getStore(), ‘items_html’ => $email_html ) ); doesn’t work! */ $email_content = $email_template->getProcessedTemplate( array( ‘order’ => $order, ‘store’ => Mage::app()->getStore(), ‘items_html’ => $email_html ) ); $email_subject = $email_template->getProcessedTemplateSubject( array( ‘order’ => $order, ‘store’ => Mage::app()->getStore(), ‘items_html’ => $email_html ) ); $mail = Mage::getModel( ‘core/email’ ); $mail->setToName( $to_name ); $mail->setToEmail( $to_email ); $mail->setBody( $email_content ); $mail->setSubject( $email_subject ); $mail->setType( ‘html’ ); if ( Mage::getStoreConfig( ‘jbmarketplace/jbmarketplace/email_from_name’ ) != ” ) $mail->setFromName( Mage::getStoreConfig( ‘jbmarketplace/jbmarketplace/email_from_name’ ) ); if ( Mage::getStoreConfig( ‘jbmarketplace/jbmarketplace/email_from’ ) != ” ) $mail->setFromEmail( Mage::getStoreConfig( ‘jbmarketplace/jbmarketplace/email_from’ ) ); $mail->send(); } catch( Exception $e ) {} }

Puneet Kumar Magento Developer

how to add new filter magento admin order filter by country

December 27, 2013/0 Comments/in Uncategorized /by puneetk00

magento admin order filter by country

please give me php code for magento

C:xampphtdocsmappcodelocalPkmoduleRewardBlockAdminhtmlRewardGrid.php

<?php class Pkmodule_Reward_Block_Adminhtml_Reward_Grid extends Mage_Adminhtml_Block_Widget_Grid { public function __construct() { parent::__construct(); $this->setId(“rewardGrid”); $this->setDefaultSort(“id”); $this->setDefaultDir(“ASC”); $this->setSaveParametersInSession(true); } protected function _prepareCollection() { $collection = Mage::getModel(“reward/reward”)->getCollection(); $this->setCollection($collection); return parent::_prepareCollection(); } protected function _prepareColumns() { $groups = array(“value”,”puneet”,”kumar”); $this->addColumn(“id”, array( “header” => Mage::helper(“reward”)->__(“ID”), “align” =>”right”, “width” => “50px”, “type” => “number”, “index” => “id”, )); $this->addColumn(“name”, array( “header” => Mage::helper(“reward”)->__(“NAME”), “align” =>”left”, “width” => “50px”, “type” => “options”, ‘options’ => $groups, “index” => “name”, )); $this->addColumn(“order”, array( “header” => Mage::helper(“reward”)->__(“order”), “align” =>”left”, “width” => “50px”, “type” => “options”, ‘options’ => $groups, “index” => “order”, )); $this->addRssList(‘reward/adminhtml_rss_rss/reward’, Mage::helper(‘reward’)->__(‘RSS’)); $this->addExportType(‘*/*/exportCsv’, Mage::helper(‘sales’)->__(‘CSV’)); $this->addExportType(‘*/*/exportExcel’, Mage::helper(‘sales’)->__(‘Excel’)); return parent::_prepareColumns(); } public function getRowUrl($row) { return $this->getUrl(“*/*/edit”, array(“id” => $row->getId())); } protected function _prepareMassaction() { $this->setMassactionIdField(‘id’); $this->getMassactionBlock()->setFormFieldName(‘ids’); $this->getMassactionBlock()->setUseSelectAll(true); $this->getMassactionBlock()->addItem(‘remove_reward’, array( ‘label’=> Mage::helper(‘reward’)->__(‘Remove Reward’), ‘url’ => $this->getUrl(‘*/adminhtml_reward/massRemove’), ‘confirm’ => Mage::helper(‘reward’)->__(‘Are you sure?’) )); return $this; } }

magen i add new $this->addColumn for filter but value not showing ?

Puneet Kumar Magento Developer

magento php code for discount whithout coupone code

December 27, 2013/0 Comments/in Uncategorized /by puneetk00

i was try to many time to discount first time 20% any purchasing but i did not get any code for discount
please help me give me any idea how can i resolve this functionality without coupon code discount to customer

Puneet Kumar Magento Developer

How do i call .phtml block at specfic page in magento?

December 27, 2013/0 Comments/in Uncategorized /by puneetk00

below code for simple cms page

{{block type='core/template' name='Test' template='goodtest/test.phtml'}}

and this below code is for php file

Puneet Kumar Magento Developer

How to remove decimal price in magento

magento how to add new attribute for all product manualy by php code

How to add custom fields for Order Line Items with price in magento

Mysql trigger query

Adding order item to orders grid in Magento

Adding order item to orders grid in Magento

magento order viedw how to add new filster coloume ?

Magento how to mail in magento php script

Magento how to mail in magento php script ?

how to add new filter magento admin order filter by country

magen i add new $this->addColumn for filter but value not showing ?

magento php code for discount whithout coupone code

How do i call .phtml block at specfic page in magento?

Connect With Us

Contact

Product

Sitemap