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…
Comments closed
Published January 29, 2016
Month: January 2016
Published January 21, 2016
Simple PHP Script to List & Kill Current Mysql Process
here we go
|
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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 |
<?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> '; ?> |
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
$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()); |
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…
Comments closed