| Line 6... |
Line 6... |
| 6 |
public $uses = array('MasterData','Click');
|
6 |
public $uses = array('MasterData','Click');
|
| 7 |
var $map = array();
|
7 |
var $map = array();
|
| 8 |
|
8 |
|
| 9 |
public function main() {
|
9 |
public function main() {
|
| 10 |
$params = array(
|
10 |
$params = array(
|
| 11 |
'fields' => array('_id','brand','source_product_name'),
|
11 |
'fields' => array('_id','brand','source_product_name','category_id'),
|
| 12 |
'conditions' => array('source_id' => array('$ne' => 0)),
|
12 |
'conditions' => array('source_id' => array('$ne' => 0)),
|
| 13 |
'order' => array('_id' => 1),
|
13 |
'order' => array('_id' => 1),
|
| 14 |
// 'limit' => 100,
|
14 |
// 'limit' => 100,
|
| 15 |
);
|
15 |
);
|
| 16 |
$masterdata = $this->MasterData->find('all', $params);
|
16 |
$masterdata = $this->MasterData->find('all', $params);
|
| 17 |
|
17 |
|
| 18 |
foreach ($masterdata as $key => $value) {
|
18 |
foreach ($masterdata as $key => $value) {
|
| 19 |
$map[$value['MasterData']['id']] = array('name'=>$value['MasterData']['source_product_name'],'brand'=>$value['MasterData']['brand']);
|
19 |
$map[$value['MasterData']['id']] = array('name'=>$value['MasterData']['source_product_name'],'brand'=>$value['MasterData']['brand'],'category_id'=>$value['MasterData']['category_id']);
|
| 20 |
}
|
20 |
}
|
| 21 |
$this->updateclicks($map);
|
21 |
$this->updateclicks($map);
|
| 22 |
}
|
22 |
}
|
| 23 |
|
23 |
|
| 24 |
public function updateclicks($map) {
|
24 |
public function updateclicks($map) {
|
| Line 31... |
Line 31... |
| 31 |
);
|
31 |
);
|
| 32 |
$clicks = $this->Click->find('all', $params);
|
32 |
$clicks = $this->Click->find('all', $params);
|
| 33 |
//$this->out(print_r($clicks,1));
|
33 |
//$this->out(print_r($clicks,1));
|
| 34 |
if(!empty($clicks)) {
|
34 |
if(!empty($clicks)) {
|
| 35 |
foreach ($clicks as $key => $value) {
|
35 |
foreach ($clicks as $key => $value) {
|
| 36 |
$sql = "UPDATE clicks SET brand = '".$map[$value['Click']['store_product_id']]['brand']."' , product_name = '".addslashes($map[$value['Click']['store_product_id']]['name'])."' WHERE id = ".$value['Click']['id'];
|
36 |
$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'];
|
| 37 |
//$this->out(print_r($sql,1));
|
37 |
//$this->out(print_r($sql,1));
|
| 38 |
$this->Click->query($sql);
|
38 |
$this->Click->query($sql);
|
| 39 |
}
|
39 |
}
|
| 40 |
}
|
40 |
}
|
| 41 |
}
|
41 |
}
|