| Line 722... |
Line 722... |
| 722 |
$options['conditions'] = array('status'=>1, 'activated'=>0, 'not'=> array('mobile_number'=>null));
|
722 |
$options['conditions'] = array('status'=>1, 'activated'=>0, 'not'=> array('mobile_number'=>null));
|
| 723 |
$options['limit']=10;
|
723 |
$options['limit']=10;
|
| 724 |
}
|
724 |
}
|
| 725 |
// $db = ConnectionManager::getDataSource("default"); // name of your database connection
|
725 |
// $db = ConnectionManager::getDataSource("default"); // name of your database connection
|
| 726 |
// $last_act = $db->fetchAll("SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ");
|
726 |
// $last_act = $db->fetchAll("SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ");
|
| 727 |
$sql = "SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ";
|
727 |
//$sql = "SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ";
|
| 728 |
$last_act = $this->User->query($sql);
|
728 |
//$last_act = $this->User->query($sql);
|
| 729 |
// debug($last_act);
|
729 |
// debug($last_act);
|
| 730 |
$last_act_user_id = array();
|
730 |
//$last_act_user_id = array();
|
| 731 |
$last_activated = array();
|
731 |
//$last_activated = array();
|
| 732 |
foreach ($last_act as $key => $row) {
|
732 |
//foreach ($last_act as $key => $row) {
|
| 733 |
// echo $key;
|
733 |
// echo $key;
|
| 734 |
foreach ($row as $key => $value) {
|
734 |
// foreach ($row as $key => $value) {
|
| 735 |
$last_activated['visited'] = $value['visited'];
|
735 |
// $last_activated['visited'] = $value['visited'];
|
| 736 |
$last_act_user_id[$value['user_id']] = $last_activated['visited'];
|
736 |
// $last_act_user_id[$value['user_id']] = $last_activated['visited'];
|
| 737 |
}
|
737 |
// }
|
| 738 |
}
|
738 |
//}
|
| 739 |
// debug($last_act_user_id);
|
739 |
// debug($last_act_user_id);
|
| 740 |
$this->set(compact('last_act_user_id'));
|
740 |
//$this->set(compact('last_act_user_id'));
|
| 741 |
$options['fields'] = array('id','email','first_name','referrer','utm_source','utm_medium','utm_term','utm_campaign','mobile_number','activated','User.created','Appacl.access', 'User.status');
|
741 |
$options['fields'] = array('id','email','first_name','referrer','utm_source','utm_medium','utm_term','utm_campaign','mobile_number','activated','User.created','Appacl.access', 'User.status');
|
| 742 |
$options['joins'] = array(
|
742 |
$options['joins'] = array(
|
| 743 |
/*array('table' => 'useractive',
|
743 |
/*array('table' => 'useractive',
|
| 744 |
'alias' => 'Useractive',
|
744 |
'alias' => 'Useractive',
|
| 745 |
'type' => 'LEFT',
|
745 |
'type' => 'LEFT',
|
| Line 757... |
Line 757... |
| 757 |
);
|
757 |
);
|
| 758 |
$this->Paginator->settings = $options;
|
758 |
$this->Paginator->settings = $options;
|
| 759 |
$users = $this->Paginator->paginate();
|
759 |
$users = $this->Paginator->paginate();
|
| 760 |
foreach ($users as $key => $value) {
|
760 |
foreach ($users as $key => $value) {
|
| 761 |
$userId = $value['User']['id'];
|
761 |
$userId = $value['User']['id'];
|
| 762 |
$quer= "select r.retailer_id,a.name from retailerlinks r join agents a on r.agent_id=a.id where user_id=$userId";
|
762 |
$quer= "select r.retailer_id,a.name, ud. from retailerlinks r join agents a on r.agent_id=a.id left join user_docs ud on u.id=ud.user_id where user_id=$userId";
|
| 763 |
$res = $this->User->query($quer);
|
763 |
$res = $this->User->query($quer);
|
| 764 |
/*$last_act= "select last_active from useractive where user_id=$userId";
|
764 |
/*$last_act= "select last_active from useractive where user_id=$userId";
|
| 765 |
$res_last = $this->User->query($last_act);*/
|
765 |
$res_last = $this->User->query($last_act);*/
|
| 766 |
if(empty($res)){
|
766 |
if(empty($res)){
|
| 767 |
$users[$key]['User']['retailer_id']="";
|
767 |
$users[$key]['User']['retailer_id']="";
|
| 768 |
$users[$key]['User']['agent_name']="";
|
768 |
$users[$key]['User']['agent_name']="";
|
| 769 |
}else{
|
769 |
}else{
|
| 770 |
$users[$key]['User']['retailer_id']=$res[0]['r']['retailer_id'];
|
770 |
$users[$key]['User']['retailer_id']=$res[0]['r']['retailer_id'];
|
| 771 |
$users[$key]['User']['agent_name']=$res[0]['a']['name'];
|
771 |
$users[$key]['User']['agent_name']=$res[0]['a']['name'];
|
| 772 |
}
|
772 |
}
|
| 773 |
/*if(empty($res_last)){
|
- |
|
| 774 |
$users[$key]['User']['last_active']="";
|
- |
|
| 775 |
}else{
|
- |
|
| 776 |
$users[$key]['User']['last_active']=$res_last[0]['useractive']['last_active'];
|
- |
|
| 777 |
}*/
|
- |
|
| 778 |
|
- |
|
| 779 |
}
|
773 |
}
|
| 780 |
|
774 |
|
| 781 |
$this->set(compact('users'));
|
775 |
$this->set(compact('users'));
|
| 782 |
}
|
776 |
}
|
| 783 |
|
777 |
|
| Line 1595... |
Line 1589... |
| 1595 |
public function getlost(){
|
1589 |
public function getlost(){
|
| 1596 |
|
1590 |
|
| 1597 |
}
|
1591 |
}
|
| 1598 |
|
1592 |
|
| 1599 |
function saveToDocs($userId, $storeImg, $supportDocImg) {
|
1593 |
function saveToDocs($userId, $storeImg, $supportDocImg) {
|
| 1600 |
$storeDoc = '/RetailerDocs/'.$userId.'storeImg';
|
1594 |
$storeDoc = '/RetailerDocs/'.$userId.'storeImg.jpg';
|
| 1601 |
$supportDoc = '/RetailerDocs/'.$userId.'supportImg';
|
1595 |
$supportDoc = '/RetailerDocs/'.$userId.'supportImg.jpg';
|
| 1602 |
|
1596 |
|
| 1603 |
$storeImgUploaded = file_put_contents($storeDoc, base64_decode($storeImg));
|
1597 |
$storeImgUploaded = file_put_contents($storeDoc, base64_decode($storeImg));
|
| 1604 |
$supportDocUploaded = file_put_contents($supportDoc, base64_decode($supportDocImg));
|
1598 |
$supportDocUploaded = file_put_contents($supportDoc, base64_decode($supportDocImg));
|
| 1605 |
|
1599 |
|
| 1606 |
if($storeImgUploaded && $supportDocUploaded) {
|
1600 |
if($storeImgUploaded && $supportDocUploaded) {
|
| Line 1609... |
Line 1603... |
| 1609 |
} else {
|
1603 |
} else {
|
| 1610 |
return false;
|
1604 |
return false;
|
| 1611 |
}
|
1605 |
}
|
| 1612 |
|
1606 |
|
| 1613 |
}
|
1607 |
}
|
| - |
|
1608 |
|
| - |
|
1609 |
function privacyPolicy(){
|
| - |
|
1610 |
|
| - |
|
1611 |
}
|
| 1614 |
}
|
1612 |
}
|
| 1615 |
|
1613 |
|