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

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

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

TRUNCATE dataflow_batch_export; TRUNCATE dataflow_batch_import; TRUNCATE log_customer; TRUNCATE log_quote; TRUNCATE log_summary; TRUNCATE log_summary_type; TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE log_visitor_online; TRUNCATE report_viewed_product_index; TRUNCATE report_compared_product_index; TRUNCATE report_event; TRUNCATE index_event;

ruppee simbale code

<div> <span class="WebRupee">₹</span> 500</div>

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

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

CREATE TRIGGER format_stage_name BEFORE INSERT ON osg_seminarman_application FOR EACH ROW BEGIN set NEW.full_name = CONCAT(NEW.first_name, ' ', NEW.last_name) ;

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 order viedw how to add new filster coloume ?

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