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

			}

		}			

	}

}