public function actionCancel()
{
$success = BusinessShare::model()->deleteAll("ID=:id", array(":id" => Yii::app()->request->getParam("ID")));
if ($success == 1) {
$result['success'] = "共享状态删除成功!";
} else {
$result['errorMsg'] = "系统异常，共享状态删除失败!";
}
echo json_encode($result);
}
public function actionSharecontact()
{
$organID = Commonmodel::getOrganID();
$dealer = Dealer::model()->find('userID=:userid', array(':userid' => $organID));
$share = BusinessShare::model()->findAll('InitiatorID=:intorID and Status=2', array(':intorID' => $organID));
foreach ($share as $key => $value) {
$shareID .= ',' . $value['ShareID'];
}
$shareID = ltrim($shareID, ",");
//查出shareID
$sql = "select a.id,a.contact_user_id,a.customertype,\n\t\t a.cooperationtype,a.name,a.sex,\n\t\t a.companyname,a.phone,a.province,a.city,a.area,a.email,\n\t\t a.weixin,a.QQ,a.create_time,a.Status,a.jiapart_ID,a.update_time,\n\t\t (select b.category from tbl_customer_category b where a.customercategory=b.id and a.user_id={$organID}) as customercategory\n\t\t from tbl_business_contacts a where \n\t\t user_id='{$organID}' and Status=0 and a.contact_user_id in({$shareID})";
if ($_POST) {
$search['name'] = $_POST['name'];
$search['phone'] = $_POST['phone'];
$search['keyword'] = $_POST['keyword'];
if ($search) {
if ($search['name']) {
$sql .= " and name like'%{$search['name']}%'";
}
if ($search['phone']) {
$sql .= " and phone like '%{$search['phone']}%'";
}
if ($search['keyword']) {
$sql .= " and (companyname like '%{$search['keyword']}%') ";
}
}
}
$sql .= "order by create_time desc";
$criteria = new CDbCriteria();
$models = Yii::app()->db->createCommand($sql)->queryAll();
$count = count($models);
$pages = new CPagination($count);
$pages->pageSize = intval($_GET['rows']);
$pages->applylimit($criteria);
$models = Yii::app()->db->createCommand($sql . " LIMIT :offset,:limit");
$models->bindValue(':offset', $pages->currentPage * $pages->pageSize);
$models->bindValue(':limit', $pages->pageSize);
$models = $models->queryAll();
foreach ($models as $key => $value) {
$data[$key]['id'] = $value['id'];
$data[$key]['Initiator'] = F::msubstr($dealer['organName']);
$data[$key]['companyID'] = $value['contact_user_id'];
//$data[$key]['customertype'] = $value['customertype'];
$data[$key]['cooperationtype'] = $value['cooperationtype'];
$data[$key]['customercategory'] = $value['customercategory'];
$data[$key]['name'] = $value['name'];
$data[$key]['sex'] = $value['sex'];
$data[$key]['companyname2'] = F::msubstr($value['companyname']);
$data[$key]['companyname'] = $value['companyname'];
$data[$key]['phone'] = $value['phone'];
$data[$key]['province'] = $value['province'];
$data[$key]['city'] = $value['city'];
$data[$key]['area'] = $value['area'];
$data[$key]['address'] = F::msubstr(Area::getCity($value['province']) . Area::getCity($value['city']) . Area::getCity($value['area']));
$data[$key]['email'] = $value['email'];
$data[$key]['weixin'] = $value['weixin'];
$data[$key]['QQ'] = $value['QQ'];
$data[$key]['create_time'] = $value['create_time'];
$data[$key]['Status'] = $value['Status'];
$data[$key]['jiapart_ID'] = $value['jiapart_ID'];
$data[$key]['update_time'] = $value['update_time'];
//$data[$key]['checked']=true;
}
$rs = array('total' => $count, 'rows' => !empty($data) ? $data : array());
echo json_encode($rs);
}
