Subversion Repositories SmartDukaan

	public function admin_productviews_report($product=null) {	

		set_time_limit(180);

		$this->loadModel('UserUrl');

		$this->loadModel('MasterData');

		$date = $this->request->query('date');

		if($product==null || $product=='search'){	

			if(!empty($date)){

				$sql = "SELECT DATE( created ) date, count(id) AS count,count(distinct user_id) as countUserId, SUBSTRING_INDEX( url,  '/', -1 )  AS skuBundleId FROM  `user_urls` WHERE date(created) = '$date' AND url LIKE '%store_products/view%' GROUP BY url ORDER BY count DESC ";				

			} else{

				$sql = "SELECT DATE( created ) date, count(id) AS count,count(distinct user_id) as countUserId, SUBSTRING_INDEX( url,  '/', -1 )  AS skuBundleId FROM  `user_urls` WHERE date(created) = curdate() AND url LIKE '%store_products/view%' group by url ORDER BY count DESC ";

			}

			$clicks_count = $this->UserUrl->query($sql);

			$this->set(compact('clicks_count'));

		} else{

			$sql = "SELECT DATE( created ) date, count(id) AS count,count(distinct user_id) as countUserId, SUBSTRING_INDEX( url,  '/', -1 ) AS skuBundleId FROM  `user_urls` WHERE SUBSTRING_INDEX( url,  '/', -1 ) = $product group by date(created) ORDER BY id DESC ";

			$product_count = $this->UserUrl->query($sql);

			$this->set(compact('product_count','product'));

		}	

		$params = array(

			'fields' => array('skuBundleId','brand','source_product_name'),

			'conditions' => array('source_id' => array('$ne' => 0)),

			'order' => array('_id' => 1),

		);

		$masterdata = $this->MasterData->find('all', $params);

		foreach ($masterdata as $key => $value) {

			$map[$value['MasterData']['skuBundleId']] = array('name'=>$value['MasterData']['source_product_name'],'brand'=>$value['MasterData']['brand']);

		}

		$this->set(compact('map'));

	}