Php mail script get offen error for special caractor we get solutions

php subject missing special character missing solved

$subject = "=?ISO-8859-15?Q?".imap_8bit("Deine Buchung für die Allgäuer Berufsoffensive")."?=";

Magento Mask product set attribute value

select * from eav_attribute where entity_type_id = 4 and attribute_code = 'status' # ---> note the ID UPDATE catalog_product_entity_int SET value = 1 WHERE attribute_id = $id

States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

INSERT INTO `directory_country_region` VALUES
(NULL , "IN", "Andaman Nicobar","Andaman Nicobar"),
(NULL , "IN", "Andhra Pradesh","Andhra Pradesh"),
(NULL , "IN", "Arunachal Pradesh","Arunachal Pradesh"),
(NULL , "IN", "Assam","Assam"),
(NULL , "IN", "Bihar","Bihar"),
(NULL , "IN", "Chandigarh","Chandigarh"),
(NULL , "IN", "Chhattisgarh","Chhattisgarh"),
(NULL , "IN", "Dadra Nagar Haveli","Dadra Nagar Haveli"),
(NULL , "IN", "Daman Diu","Daman Diu"),
(NULL , "IN", "Delhi","Delhi"),
(NULL , "IN", "Goa","Goa"),
(NULL , "IN", "Gujarat","Gujarat"),
(NULL , "IN", "Haryana","Haryana"),
(NULL , "IN", "Himachal Pradesh","Himachal Pradesh"),
(NULL , "IN", "Jammu Kashmir","Jammu Kashmir"),
(NULL , "IN", "Jharkhand","Jharkhand"),
(NULL , "IN", "Karnataka","Karnataka"),
(NULL , "IN", "Kerala","Kerala"),
(NULL , "IN", "Lakshadweep","Lakshadweep"),
(NULL , "IN", "Madhya Pradesh","Madhya Pradesh"),
(NULL , "IN", "Maharashtra","Maharashtra"),
(NULL , "IN", "Manipur","Manipur"),
(NULL , "IN", "Meghalaya","Meghalaya"),
(NULL , "IN", "Mizoram","Mizoram"),
(NULL , "IN", "Nagaland","Nagaland"),
(NULL , "IN", "Orissa","Orissa"),
(NULL , "IN", "Pondicherry","Pondicherry"),
(NULL , "IN", "Punjab","Punjab"),
(NULL , "IN", "Rajasthan","Rajasthan"),
(NULL , "IN", "Sikkim","Sikkim"),
(NULL , "IN", "Tamil Nadu","Tamil Nadu"),
(NULL , "IN", "Tripura","Tripura"),
(NULL , "IN", "Uttar Pradesh","Uttar Pradesh"),
(NULL , "IN", "Uttaranchal","Uttaranchal"),
(NULL , "IN", "West Bengal","West Bengal");

INSERT INTO `directory_country_region_name` (`locale` ,`region_id` ,`name` ) SELECT 'en_US', tmp.region_id, tmp.default_name FROM `directory_country_region` AS tmp WHERE tmp.country_id='IN';

magento log clear query

ruppee simbale code

Export MySQL to CSV (php script)

<?php
/* vars for export */
// database record to be exported
$db_record = 'XXXXXXXXX';
// optional where query
$where = 'WHERE 1 ORDER BY 1';
// filename for export
$csv_filename = 'db_export_'.$db_record.'_'.date('Y-m-d').'.csv';
 
// database variables
$hostname = "localhost";
$user = "XXXXXXXXX";
$password = "XXXXXXXXX";
$database = "XXXXXXXXX";
 
// Database connecten voor alle services
mysql_connect($hostname, $user, $password)
or die('Could not connect: ' . mysql_error());
mysql_select_db($database)
or die ('Could not select database ' . mysql_error());
 
// create empty variable to be filled with export data
$csv_export = '';
 
// query to get data from database
$query = mysql_query("SELECT * FROM ".$db_record." ".$where);
$field = mysql_num_fields($query);
 
// create line with field names
for($i = 0; $i < $field; $i++) {
$csv_export.= mysql_field_name($query,$i).';';
}
// newline (seems to work both on Linux & Windows servers)
$csv_export.= '
';
 
// loop through database query and fill export variable
while($row = mysql_fetch_array($query)) {
// create line with field values
for($i = 0; $i < $field; $i++) {
$csv_export.= '"'.$row[mysql_field_name($query,$i)].'";';
} 
$csv_export.= '
'; 
}
 
// Export the data and prompt a csv file for download
header("Content-type: text/x-csv");
header("Content-Disposition: attachment; filename=".$csv_filename."");
echo($csv_export);
?>

Magento tranjectional mail with variable by template id

<?php
// Transactional Email Template's ID
        $templateId = 5;

// Set sender information
        $senderName = 'Kraftbuy';
        $senderEmail = $email_general;
        $sender = array('name' => "admin",
                    'email' => "admin@gmail.com");

// Set recepient information
        $recepientEmail = $email;
        $recepientName = $Name_of_Contact_Person_for;

// Get Store ID
        $store = Mage::app()->getStore()->getId();

//Set variables that can be used in email template you can assign this variable in tranjectional mail {{var ustomerName}}

$vars = array('customerName' => 'puneet kumar',
                  'customerEmail' => 'puneetk00@gmail.com');

$translate  = Mage::getSingleton('core/translate');

// Send Transactional Email
        Mage::getModel('core/email_template')
      ->addBcc($senderEmail)
            ->sendTransactional($templateId, $sender, $recepientEmail, $recepientName, $vars, $storeId);

$translate->setTranslateInline(true);

Magento Group product configrable product assign prices

Looks like you are using SCP or the SimpleConfigurable products extension. That is known to cause issues. Please try the following:

comment out lines 104-106 of /skin/frontend/base/default/js/scp_product_extension.js. However this may affect how SCP operates.
so this code:

Product.Config.prototype.updateFormProductId = function(productId){
if (!productId)
{ return false; }
var currentAction = $('product_addtocart_form').action;
newcurrentAction = currentAction.sub(/product\/\d+\//, 'product/' + productId + '/');
$('product_addtocart_form').action = newcurrentAction;
$('product_addtocart_form').product.value = productId;
};

looks like this:

Product.Config.prototype.updateFormProductId = function(productId){
if (!productId) { return false; }
var currentAction = $('product_addtocart_form').action;
//newcurrentAction = currentAction.sub(/product\/\d+\//, 'product/' + productId + '/');
//$('product_addtocart_form').action = newcurrentAction;
//$('product_addtocart_form').product.value = productId;
};

How to remove decimal price in magento

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);

}

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

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

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

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 “<strong>Training Location:</strong> “.$_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

Mysql trigger query

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));
    }

}

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 ?

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 ) {}
  }

how to add new filter magento admin order filter by country

magento admin order filter by country

please give me php code for magento

C:\xampp\htdocs\m\app\code\local\Pkmodule\Reward\Block\Adminhtml\Reward\Grid.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 ?

magento php code for discount whithout coupone code

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

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

below code for simple cms page

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

and this below code is for php file

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

below code for simple cms page

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

and this below code is for

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

below code for simple cms page

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

and this below code is for php file

<?php 
  echo $this->getLayout()->createBlock('core/template')->setTemplate('goodtest/test.phtml')->toHtml();
?>

Pk Magento 2

Php mail script get offen error for special caractor we get solutions

Magento Mask product set attribute value

Magento Mask product set attribute value

select * from eav_attribute where entity_type_id = 4 and attribute_code = 'status' # ---> note the ID UPDATE catalog_product_entity_int SET value = 1 WHERE attribute_id = $id

States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

magento log clear query

ruppee simbale code

Export MySQL to CSV (php script)

Magento tranjectional mail with variable by template id

Magento Group product configrable product assign prices

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?

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

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

Magento 2 all types

Popular Posts

Posts