Subversion Repositories SmartDukaan

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

        public function main() {
                $params = array(
                        'fields' => array('_id','brand','source_product_name'),
                        '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']);
                }
                $this->updateclicks($map);
        }

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