<?php
|
|
|
|
class crm_org_kh_controller extends adminCommon
|
{
|
|
function set_search()
|
{
|
|
$cacheM = $this->MODEL('cache');
|
$crmCache = $cacheM->GetCache(array('crm'));
|
$this->yunset(array('cache' => $crmCache, 'crmClassName' => $crmCache['crmclass_name'], 'crmStatus' => $crmCache['crmdata']['client_status'], 'crmType' => $crmCache['crmdata']['client_type']));
|
|
$yyzz = array('1' => '已认证', '2' => '待审核', '3' => '未通过', '4' => '待认证');
|
|
$ratingM = $this->MODEL('rating');
|
$ratingArr = $ratingM->getList(array('category' => '1', 'orderby' => 'sort'), array('field' => '`id`,`name`'));
|
$vipEtime = array('1' => '三天内', '2' => '七天内', '3' => '一月内', '4' => '已到期');
|
$orders = array('1' => '客户ID', '2' => '登录日期', '3' => 'VIP到期时间', '4' => '跟进时间');
|
$lastFtime = array('1' => '从未跟进', '2' => '今天', '3' => '三天未跟进', '4' => '七天未跟进', '5' => '一月未跟进', '6' => '一百天未跟进');
|
$nextFtime = array('1' => '今天', '2' => '明天', '3' => '三天内', '4' => '七天内', '5' => '一月内');
|
$this->yunset(array('yyzzStatus' => $yyzz, 'ratingArr' => $ratingArr, 'vipEtime' => $vipEtime, 'orders' => $orders, 'lastFtime' => $lastFtime, 'nextFtime' => $nextFtime));
|
|
$this->yunset('todayStart', strtotime('today'));
|
}
|
|
function index_action()
|
{
|
|
$this->set_search();
|
|
$AdminM = $this->MODEL('admin');
|
$adminUserInfo = $AdminM->getAdminUser(array('uid' => $_SESSION['auid']), array('field' => 'org,power,spower'));
|
|
$Company = $this->MODEL('company');
|
$userInfoM = $this->MODEL('userinfo');
|
$crmM = $this->MODEL('crm');
|
|
if (isset($adminUserInfo) && $adminUserInfo['org'] > 0) {
|
|
$orgInfo = $crmM->getOrgInfo(array('id' => $adminUserInfo['org']));
|
|
$oIds = $orgIds = $orgIdss = $orgIdsss = array();
|
|
if ($adminUserInfo['power'] == '1') { // 同级部门权限
|
|
$oList = $crmM->getOrgList(array('level' => $orgInfo['level']));
|
foreach ($oList as $k => $v) {
|
$orgIds[] = $v['id'];
|
}
|
}
|
|
if ($adminUserInfo['power'] == '1') { // 子部门权限
|
if ($orgInfo['level'] == '1') {
|
|
$orgList = $crmM->getOrgList(array('fid' => $adminUserInfo['org']));
|
foreach ($orgList as $ok => $ov) {
|
$orgIdss[] = $ov['id'];
|
}
|
|
$orgLists = $crmM->getOrgList(array('fid' => array('in', pylode(',', $orgIdss))));
|
|
foreach ($orgLists as $ook => $oov) {
|
$orgIdsss[] = $oov['id'];
|
}
|
|
} elseif ($orgInfo['level'] == '2') {
|
|
$orgList = $crmM->getOrgList(array('fid' => $adminUserInfo['org']));
|
foreach ($orgList as $ok => $ov) {
|
|
$orgIdss[] = $ov['id'];
|
}
|
}
|
}
|
|
$oIds = array_merge($orgIds, $orgIdss, $orgIdsss);
|
|
$adminUserList = $AdminM->getList(array('uid' => array('<>', $_SESSION['auid']), 'org' => array('in', pylode(',', $oIds))), array('field' => '`uid`,`name`,`username`'));
|
foreach ($adminUserList as $v) {
|
$uids[] = $v['uid'];
|
}
|
$this->yunset('adminUserList', $adminUserList);
|
}
|
|
if (isset($_GET['kh'])){
|
|
if ($_GET['kh'] == 1){
|
|
$where['isfollow'] = 1;
|
|
} elseif ($_GET['kh'] == 2){
|
|
$where['isfollow'] = 1;
|
$where['f_time'] = array('>=', strtotime(date('Y-m-d')));
|
} elseif ($_GET['kh'] == 3){
|
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['f_time'][] = array('>', 0);
|
$where['f_time'][] = array('<', strtotime('-30 days'));
|
$where['PHPYUNBTWEND_A'] = '';
|
} elseif ($_GET['kh'] == 4){
|
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['isfollow'] = array('=', '0', 'OR');
|
$where['f_time'] = array('=', '', 'OR');
|
$where['PHPYUNBTWEND_A'] = '';
|
} elseif ($_GET['kh'] == 5){
|
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['vipetime'][] = array('>', time(), 'AND');
|
$where['vipetime'][] = array('<', strtotime('+15 days'), 'AND');
|
$where['PHPYUNBTWEND_A'] = '';
|
} elseif ($_GET['kh'] == 6){
|
|
$where['login_date'] = array('>=', strtotime(date('Y-m-d')));
|
$_GET['loginStart'] = date('Y-m-d');
|
}
|
|
$urlarr['kh'] = $_GET['kh'];
|
}
|
|
if (!empty($_GET['crmType'])) {
|
|
$crmType = intval($_GET['crmType']);
|
$where['crm_type'] = $crmType;
|
$urlarr['crmType'] = $crmType;
|
}
|
|
if (!empty($_GET['crm_status'])) {
|
|
$crm_status = intval($_GET['crm_status']);
|
$where['crm_status'] = $crm_status;
|
$urlarr['crm_status'] = $crm_status;
|
}
|
|
if (!empty($_GET['yyzz_status'])) {
|
|
$yyzz_status = intval($_GET['yyzz_status']);
|
|
if ($yyzz_status == 1) {
|
|
$where['yyzz_status'] = $yyzz_status;
|
} else {
|
|
$certWhere = array();
|
|
if ($yyzz_status == 2) {
|
|
$certWhere = array('type' => 3, 'status' => 0);
|
} elseif ($yyzz_status == 3) {
|
|
$certWhere = array('type' => 3, 'status' => 3);
|
}elseif ($yyzz_status == 4) {
|
|
$certWhere = array('type' => 3);
|
}
|
|
$certList = $Company->getCertList($certWhere, array('field' => '`uid`'));
|
$uidArrA = array();
|
foreach ($certList as $cv) {
|
|
$uidArrA[] = $cv['uid'];
|
}
|
|
if ($yyzz_status == 4){
|
|
$where['uid'] = array('notin', pylode(',', $uidArrA));
|
}else{
|
|
$where['uid'] = array('in', pylode(',', $uidArrA));
|
}
|
}
|
|
$urlarr['yyzz_status'] = $yyzz_status;
|
}
|
|
if (!empty($_GET['rating'])) {
|
|
$rating = intval($_GET['rating']);
|
$where['rating'] = $rating;
|
$urlarr['rating'] = $rating;
|
}
|
|
if (!empty($_GET['regStart']) || !empty($_GET['regEnd'])) {
|
|
$regStart = strtotime($_GET['regStart']);
|
$regEnd = strtotime($_GET['regEnd']);
|
|
$mWhere['PHPYUNBTWSTART_A'] = '';
|
$mWhere['reg_date'][] = array('>', $regStart, 'AND');
|
$mWhere['reg_date'][] = array('<', $regEnd, 'AND');
|
$mWhere['PHPYUNBTWEND_A'] = '';
|
$memberList = $userInfoM->getList($mWhere, array('field' => 'uid'));
|
|
$uidArrB = array();
|
foreach ($memberList as $mv) {
|
$uidArrB[] = $mv['uid'];
|
}
|
$where['uid'] = array('in', pylode(',', $uidArrB));
|
|
$urlarr['regStart'] = $_GET['regStart'];
|
$urlarr['regEnd'] = $_GET['regEnd'];
|
}
|
|
if (!empty($_GET['ordertype'])) {
|
|
$orderType = intval($_GET['ordertype']);
|
$order = '';
|
|
if ($orderType == 1) {
|
|
$order = 'uid';
|
} else if ($orderType == 2) {
|
|
$order = 'login_date';
|
} else if ($orderType == 3) {
|
|
$order = 'vipetime';
|
} else if ($orderType == 4) {
|
|
$order = 'f_time';
|
} else if ($orderType == 5) {
|
|
$order = 'crm_time';
|
}
|
|
$urlarr['ordertype'] = $orderType;
|
$where['orderby'] = $order.',desc';
|
}else{
|
|
$where['orderby'] = 'login_date,desc';
|
}
|
|
if (!empty($_GET['lastFtime'])) {
|
|
$lastFtime = intval($_GET['lastFtime']);
|
if ($lastFtime == 1) {
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['isfollow'] = array('=', '0', 'OR');
|
$where['f_time'] = array('=', '', 'OR');
|
$where['PHPYUNBTWEND_A'] = '';
|
} elseif ($lastFtime == 2) {
|
|
$where['f_time'] = array('>', strtotime(date('Y-m-d')));
|
} elseif ($lastFtime == 3){
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['f_time'][] = array('>', 0);
|
$where['f_time'][] = array('<', strtotime('-3 days'));
|
$where['PHPYUNBTWEND_A'] = '';
|
}elseif ($lastFtime == 4){
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['f_time'][] = array('>', 0);
|
$where['f_time'][] = array('<', strtotime('-7 days'));
|
$where['PHPYUNBTWEND_A'] = '';
|
}elseif ($lastFtime == 5){
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['f_time'][] = array('>', 0);
|
$where['f_time'][] = array('<', strtotime('-30 days'));
|
$where['PHPYUNBTWEND_A'] = '';
|
}elseif ($lastFtime == 6){
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['f_time'][] = array('>', 0);
|
$where['f_time'][] = array('<', strtotime('-100 days'));
|
$where['PHPYUNBTWEND_A'] = '';
|
}else{
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['f_time'][] = array('isnull', '', '');
|
$where['f_time'][] = array('<', strtotime('-'.$_GET['lastFtime'].' days'), 'OR');
|
$where['PHPYUNBTWEND_A'] = '';
|
}
|
|
$urlarr['lastFtime'] = $lastFtime;
|
}
|
|
if (!empty($_GET['nextFtime'])) {
|
|
$nextFtime = intval($_GET['nextFtime']);
|
$taskWhere = array();
|
if ($nextFtime == 1) {
|
|
$taskWhere['PHPYUNBTWSTART_A'] = '';
|
$taskWhere['stime'][] = array('>', strtotime(date('Y-m-d')));
|
$taskWhere['stime'][] = array('<', strtotime(date('Y-m-d 23:59:59')));
|
$taskWhere['PHPYUNBTWEND_A'] = '';
|
} elseif ($nextFtime == 2) {
|
|
$taskWhere['PHPYUNBTWSTART_A'] = '';
|
$taskWhere['stime'][] = array('>', strtotime(date('Y-m-d 23:59:59')));
|
$taskWhere['stime'][] = array('<', strtotime(date('Y-m-d 23:59:59')) + 86400);
|
$taskWhere['PHPYUNBTWEND_A'] = '';
|
} elseif ($nextFtime == 3) {
|
|
$taskWhere['PHPYUNBTWSTART_A'] = '';
|
$taskWhere['stime'][] = array('>', time());
|
$taskWhere['stime'][] = array('<', strtotime('+3 day'));
|
$taskWhere['PHPYUNBTWEND_A'] = '';
|
} elseif ($nextFtime == 4) {
|
|
$taskWhere['PHPYUNBTWSTART_A'] = '';
|
$taskWhere['stime'][] = array('>', time());
|
$taskWhere['stime'][] = array('<', strtotime('+1 week'));
|
$taskWhere['PHPYUNBTWEND_A'] = '';
|
} elseif ($nextFtime == 5) {
|
|
$taskWhere['PHPYUNBTWSTART_A'] = '';
|
$taskWhere['stime'][] = array('>', time());
|
$taskWhere['stime'][] = array('<', strtotime('+1 month'));
|
$taskWhere['PHPYUNBTWEND_A'] = '';
|
}
|
|
$taskWhere['uid'] = $_SESSION['auid'];
|
$taskList = $crmM->getTaskList($taskWhere, array('field' => '`comid`'));
|
$uidArrN = array();
|
foreach ($taskList as $tv) {
|
$uidArrN[] = $tv['comid'];
|
}
|
$where['uid'] = array('in', pylode(',', $uidArrN));
|
}
|
|
if (!empty($_GET['vipetime'])) {
|
|
$etime = intval($_GET['vipetime']);
|
|
if ($etime == 4) {
|
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['vipetime'][] = array('<', strtotime(date('Y-m-d')), 'AND');
|
$where['vipetime'][] = array('>', '0', 'AND');
|
$where['PHPYUNBTWEND_A'] = '';
|
} else {
|
|
if ($etime == 1) {
|
|
$num = '+3 day';
|
} else if ($etime == 2) {
|
|
$num = '+7 day';
|
} elseif ($etime == 3) {
|
|
$num = '+1 month';
|
}
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['vipetime'][] = array('>', time(), 'AND');
|
$where['vipetime'][] = array('<', strtotime($num), 'AND');
|
$where['PHPYUNBTWEND_A'] = '';
|
}
|
$urlarr['vipetime'] = $etime;
|
}
|
|
if (!empty($_GET['loginStart']) || !empty($_GET['loginEnd'])) {
|
|
$loginStart = strtotime($_GET['loginStart']);
|
$loginEnd = strtotime($_GET['loginEnd']) + 86400;
|
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['login_date'][] = array('>', $loginStart, 'AND');
|
$where['login_date'][] = array('<', $loginEnd, 'AND');
|
$where['PHPYUNBTWEND_A'] = '';
|
|
$urlarr['regStart'] = $_GET['regStart'];
|
$urlarr['regEnd'] = $_GET['regEnd'];
|
}
|
|
if (isset($_GET['crm_uid']) && $_GET['crm_uid'] > 0){
|
|
$where['crm_uid'] = $_GET['crm_uid'];
|
$urlarr['crm_uid'] = $_GET['crm_uid'];
|
}else{
|
|
$where['PHPYUNBTWSTART_A'] = '';
|
$where['crm_uid'][] = array('<>', 0, 'AND');
|
$where['crm_uid'][] = array('in', pylode(',', $uids), 'AND');
|
$where['PHPYUNBTWEND_A'] = '';
|
}
|
|
if ($_GET['keyword']) {
|
|
$keywordStr = trim($_GET['keyword']);
|
$typeStr = intval($_GET['crm_type']);
|
|
if (!empty($keywordStr)) {
|
if ($typeStr == 1) {
|
|
$where['name'] = array('like', $keywordStr);
|
} else if ($typeStr == 2) {
|
|
$where['linkman'] = array('like', $keywordStr);
|
} else if ($typeStr == 3) {
|
|
$where['linktel'] = $keywordStr;
|
} else if ($typeStr == 4) {
|
|
$where['uid'] = $keywordStr;
|
}
|
}
|
$urlarr['crm_type'] = $typeStr;
|
$urlarr['keyword'] = $keywordStr;
|
}
|
$urlarr = $_GET;
|
$urlarr['page'] = '{{page}}';
|
$pageurl = Url($_GET['m'], $urlarr, 'admin');
|
$pageM = $this->MODEL('page');
|
$pages = $pageM->pageList('company', $where, $pageurl, $_GET['page']);
|
if ($pages['total'] > 0) {
|
if ($_GET['order']) {
|
if ($_GET['t']) {
|
|
$where['orderby'] = $_GET['t'] . ',' . $_GET['order'];
|
$urlarr['t'] = $_GET['t'];
|
} else {
|
|
$where['orderby'] = 'login_date, desc';
|
}
|
$urlarr['order'] = $_GET['order'];
|
} else if (isset($order)) {
|
|
$where['orderby'] = $order . ',' . $_GET['order'];
|
}
|
$where['limit'] = $pages['limit'];
|
$comList = $Company->getList($where, array('utype' => 'crm'));
|
|
foreach ($comList['list'] as $key => $val){
|
$comList['list'][$key]['wxBindmsg'] = $this->wxBindState($val);
|
}
|
|
$this->yunset('rows', $comList['list']);
|
}
|
$this->yuntpl(array('admin/crm_org_kh'));
|
}
|
}
|
|
?>
|
