Subversion Repositories SmartDukaan

<?php
ini_set('display_errors', '0');     # don't show any errors...
error_reporting(E_ALL ^ E_STRICT);  # ...but do log them

class ClickInfoShell extends AppShell {
        public $uses = array('MasterData','Click');
        var $map = array();

        public function main() {
                $params = array(
                        'fields' => array('_id','brand','source_product_name','category_id'),
                        'conditions' => array('source_id' => array('$ne' => 0)),
                        'order' => array('_id' => 1),
                        // 'limit' => 100,
                );
                $masterdata = $this->MasterData->find('all', $params);

                foreach ($masterdata as $key => $value) {
                        $map[$value['MasterData']['id']] = array('name'=>$value['MasterData']['source_product_name'],'brand'=>$value['MasterData']['brand'],'category_id'=>$value['MasterData']['category_id']);
                }
                $this->updateclicks($map);
        }

        public function updateclicks($map) {
                $limit = 500;
                $params = array(
                        'fields' => array('id','store_product_id'),
                        'conditions' => array('extras NOT LIKE' => '%notification%','brand'=>null,'store_product_id !='=>0),
                        'order' => array('id' => 'desc'),
                        'limit' => $limit,
                );
                $clicks = $this->Click->find('all', $params);
                //$this->out(print_r($clicks,1));
                if(!empty($clicks)) {
                        foreach ($clicks as $key => $value) {
                                $sql = "UPDATE clicks SET brand = '".$map[$value['Click']['store_product_id']]['brand']."' , product_name = '".addslashes($map[$value['Click']['store_product_id']]['name'])."', category_id='".$map[$value['Click']['store_product_id']]['category_id']."' WHERE id = ".$value['Click']['id'];
                                //$this->out(print_r($sql,1));
                                $this->Click->query($sql);
                        }
                }                       
        }
}