Example #1
0
 public function actionContact()
 {
     $OrganID = Commonmodel::getOrganID();
     //获取共享关系表中机构ID
     $ids = $this->getShareids();
     //获取用户表中所有经销商ID
     $users = User::getDealerID();
     foreach ($users as $user) {
         $identity[] = $user['id'];
     }
     //获取不在共享关系表中的机构信息
     $criteria = new CDbCriteria();
     $criteria->addInCondition('t.contact_user_id', $identity);
     //业务联系人属于经销商
     $criteria->addCondition("t.user_id = {$OrganID}", "AND");
     //当前机构下
     $criteria->addCondition("t.Status = 0", "AND");
     //未删除
     $criteria->addNotInCondition('t.contact_user_id', $ids);
     //业务联系人不在确定共享关系中
     $criteria->order = "t.create_time desc";
     //以添加时间倒序
     //通过机构名称模糊检索
     if ($_GET['name']) {
         $criteria->addSearchCondition('t.companyname', $_GET['name'], "AND");
     }
     //分页
     $count = BusinessContacts::model()->count($criteria);
     $pages = new CPagination($count);
     $pages->pageSize = $_GET['rows'];
     $pages->applyLimit($criteria);
     $model = BusinessContacts::model()->findAll($criteria);
     foreach ($model as $key => $value) {
         $data[$key]['id'] = $value['id'];
         $data[$key]['name'] = F::msubstr($value['name']);
         $data[$key]['sex'] = $value['sex'];
         $data[$key]['jiapart_ID'] = $value['jiapart_ID'];
         $data[$key]['companyname'] = F::msubstr($value['companyname']);
         $data[$key]['phone'] = F::msubstr($value['phone']);
         $data[$key]['address'] = F::msubstr(Area::getCity($value['province']) . Area::getCity($value['city']) . Area::getCity($value['area']));
     }
     $rs = array('total' => $count, 'rows' => $data ? $data : array());
     echo json_encode($rs);
 }