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

banner slider

<div style="width: 746px; border: 1px solid #459b06; height: 250px;"> <script type="text/javascript" src="http://code.jquery.com/jquery-1.4.2.min.js"></script> <script type="text/javascript">// <![CDATA[ function rotateBanners(elem) { var active = $(elem+" img.active"); var next = active.next(); if (next.length == 0) next = $(elem+" img:first"); active.removeClass("active").fadeOut(200); next.addClass("active").fadeIn(200); } function prepareRotator(elem) { $(elem+" img").fadeOut(0); $(elem+" img:first").fadeIn(0).addClass("active"); } function startRotator(elem) { prepareRotator(elem); setInterval("rotateBanners('"+elem+"')", 2500); } // ]]></script> <script type="text/javascript">// <![CDATA[ $(window).load(function() { startRotator("#rotator"); }) // ]]></script> <div id="rotator"> <img style="position: absolute;" src="{{media url="wysiwyg/banner1.gif"}}" alt="" /> <img style="position: absolute;" src="{{media url="wysiwyg/banner2.gif"}}" alt="" /> <img style="position: absolute;" src="{{media url="wysiwyg/banner3.gif"}}" alt="" /> <img style="position: absolute;" src="{{media url="wysiwyg/banner4.gif"}}" alt="" /></div> </div>

magento insert and update and delet and all querys

It is very easy to select, insert, delete and update the record in magento site. following functions are helpful in magento site for database queries. You can also use this function outside magento environment with the help pf include “Mage.php” file form “app” folder like.
This is very simple to get data from database of magento site to frontend of magento site or another sites

1. require_once '../../app/Mage.php';
2. Mage::app('default');

Select query to get the value form table

1. $connection = Mage::getSingleton('core/resource')
2. ->getConnection('core_read');
3. $select = $connection->select()
4. ->from('tablename', array('*')) // select * from tablename or use array('id','name') selected values
5. ->where('id=?',1)               // where id =1
6. ->group('name');         // group by name
7. $rowsArray = $connection->fetchAll($select); // return all rows
8. $rowArray =$connection->fetchRow($select);   //return row

insert query

1. $connection = Mage::getSingleton('core/resource')
2. ->getConnection('core_write');
3. $connection->beginTransaction();
4. $fields = array();
5. $fields['name']= 'test';
6. $fields['age']='25';
7. $connection->insert('tablename', $fields);
8. $connection->commit();

update query

1. $connection = Mage::getSingleton('core/resource')
2. ->getConnection('core_write');
3. $connection->beginTransaction();
4. $fields = array();
5. $fields['name'] = 'jony';
6. $where = $connection->quoteInto('id =?', '1');
7. $connection->update('tablename', $fields, $where);
8. $connection->commit();

delete query

1. $condition = array($connection->quoteInto('id=?', '1'));
2. $connection->delete('tablename', $condition);

magento file uploading error http error

i analyses that media folder should me right-able i mean permission should be 7777

and other think is .htaccess permission


############################################
## adjust memory limit

#    php_value memory_limit 64M
    php_value memory_limit 256M
    php_value max_execution_time 18000


###############R A V I ###################
#php_value upload_max_filesize 712M
php_value post_max_size 712M

php_value upload_max_filesize 712M
php_value max_execution_time 2000
php_value max_input_time 2000
php_value memory_limit 512M
###############P U N I T ###################

Phone SMS: Hasna jamara kisi ko gawara nahi hota,Har musafir ...

Phone SMS: Hasna jamara kisi ko gawara nahi hota,Har musafir ...: Hasna jamara kisi ko gawara nahi hota, Har musafir zindagi ka sahara nahi hota, Milte hain bahot insaan is tanha is zindagi mein, ...

Phone SMS: Milta nahi hai pyaar aasani se zindagi me,Mera nas...

Phone SMS: Milta nahi hai pyaar aasani se zindagi me,Mera nas...: Milta nahi hai pyaar aasani se zindagi me, Mera nasib bhi kabhi khola tha khuda ne, Par ab to dil mein Patjhad hi hain, Fir bhi a...