January 2016 – Ansyori's Blog

Published January 29, 2016

Magento : Change Shipping Price After Save Shipping Method

it took couple days to figure this ‘shit’ out i assume you already understand how to create custom shipping method extension, for example on your…

Continue reading Magento : Change Shipping Price After Save Shipping Method

Comments closed

Published January 21, 2016

Simple PHP Script to List & Kill Current Mysql Process

here we go

<?php

@mysql_connect("you-db-host","username","password");


if(isset($_GET['kill'])):

mysql_unbuffered_query('kill '.$_GET['kill']);

echo '<h1>Process Id : '.$_GET['kill'].' has been terminated</h1>';

endif;



$sql = 'show full processlist';
		
		echo '
		<style>
		table {
			margin: 1em 20px 0 0; 
			width: calc(100% - 40px);
			margin: 20px;
		}
		td, thead th {
			background: #fff;
		}	
		</style>
		<table  border="1" cellspacing="1" cellpadding="3">
		  <thead>
			<tr>
			  <th title="">No</th>
			  <th title="">Id</th>
			  <th title="">User</th>
			  <th title="">Host</th>
			  <th title="">db</th>
			  <th title="">Command</th>
			  <th title="">Time</th>
			  <th title="">State</th>
			  <th title="">Info</th>
			</tr>
		  </thead>
		  <tbody>'
		;
		
		$q = mysql_query("SHOW FULL PROCESSLIST");
		
		$no = 1;

		while ($rs = mysql_fetch_assoc($q)) {
		echo '    
			<tr>
			  <td>'.$no++.'</td>
			  <td><a href="?kill='.$rs['Id'].'">'.$rs['Id'].'<?php ?></td>
			  <td>'.$rs['User'].'</td>
			  <td>'.$rs['Host'].'</td>
			  <td>'.$rs['db'].'</td>
			  <td>'.$rs['Command'].'</td>
			  <td>'.$rs['Time'].'</td>
			  <td>'.$rs['State'].'</td>
			  <td><em>'.$rs['Info'].'</em></td>
			</tr>';
		};	
		echo '
			
			
		  </tbody>
		</table>
		</body>
		</html>

		';
?>

<?php

@mysql_connect("you-db-host","username","password");

if(isset($_GET['kill'])):

mysql_unbuffered_query('kill '.$_GET['kill']);

echo '<h1>Process Id : '.$_GET['kill'].' has been terminated</h1>';

endif;

$sql = 'show full processlist';

echo '

<style>

table {

margin: 1em 20px 0 0;

width: calc(100% - 40px);

margin: 20px;

}

td, thead th {

background: #fff;

}

</style>

<thead>

<tr>

<th title="">Command</th>

<th title="">State</th>

</tr>

</thead>

<tbody>'

;

$q = mysql_query("SHOW FULL PROCESSLIST");

$no = 1;

while ($rs = mysql_fetch_assoc($q)) {

echo '

<tr>

<td>'.$rs['Command'].'</td>

<td>'.$rs['State'].'</td>

</tr>';

};

echo '

</tbody>

</table>

</body>

</html>

Continue reading Simple PHP Script to List & Kill Current Mysql Process

Comments closed

Published January 12, 2016

Magento : Get product collection has tier price only

here my script get product collection who has tier price only!!!!!!!!!!!!!!!!!! of course also in stock :p

$prefix = Mage::getConfig()->getTablePrefix();

$sql = 'select distinct  entity_id from '.$prefix.'catalog_product_entity_tier_price';
		
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$results = $readConnection->fetchCol($sql);
		
/* base collection */
		
$mod = Mage::getModel('catalog/product')
		      ->getCollection()
		      ->addAttributeToFilter('entity_id',array('in'=>$results))
				
				;
$mod->joinField('is_in_stock', 'cataloginventory/stock_item', 'is_in_stock', 'product_id=entity_id', '{{table}}.stock_id=1', 'left');
$mod->addAttributeToFilter('is_in_stock', array('eq' => 1));
		
print_r($mod->getData());

$prefix = Mage::getConfig()->getTablePrefix();

$sql = 'select distinct entity_id from '.$prefix.'catalog_product_entity_tier_price';

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

$readConnection = $resource->getConnection('core_read');

$results = $readConnection->fetchCol($sql);

/* base collection */

$mod = Mage::getModel('catalog/product')

->getCollection()

->addAttributeToFilter('entity_id',array('in'=>$results))

;

$mod->joinField('is_in_stock', 'cataloginventory/stock_item', 'is_in_stock', 'product_id=entity_id', '{{table}}.stock_id=1', 'left');

$mod->addAttributeToFilter('is_in_stock', array('eq' => 1));

print_r($mod->getData());

Continue reading Magento : Get product collection has tier price only

Comments closed

Published January 12, 2016

Filter Payment & Shipping Method on Checkout Page

To filter Payment Method Options we can use observer, i assume you have knowledge of Magento module development, anyway let’s begin on config.xml, register an event…

Continue reading Filter Payment & Shipping Method on Checkout Page

Comments closed

M	T	W	T	F	S	S
« Dec				Feb »
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

Month: January 2016

Magento : Change Shipping Price After Save Shipping Method

Simple PHP Script to List & Kill Current Mysql Process

Magento : Get product collection has tier price only

Filter Payment & Shipping Method on Checkout Page