public function Customer()
{
$this->MyAction = 'Customer';
$CustProModule = new CustProModule();
$CustomersModule = new CustomersModule();
$FuwuModule = new FuwuModule();
//获取风信项目id
$ProjectId = FENGXIN_ID;
$MysqlWhere = " where {$CustProModule->ProjectID}='{$ProjectId}' and AgentID=" . $_SESSION['AgentID'];
$Page = intval($this->_GET['Page']);
$Page = $Page ? $Page : 1;
$Searchtxt = $this->_POST['searchtxt'];
if ($Searchtxt != '') {
$MysqlWhere .= " and (WeiXinName like '%{$Searchtxt}%')";
}
$ListsNum = $CustProModule->GetListsNum($MysqlWhere);
$Rscount = $ListsNum['Num'];
$PageSize = 10;
if ($Rscount) {
$Data['RecordCount'] = $Rscount;
$Data['PageSize'] = $PageSize ? $PageSize : $Data['RecordCount'];
$Data['PageCount'] = ceil($Data['RecordCount'] / $PageSize);
$Data['Page'] = min($Page, $Data['PageCount']);
$Offset = ($Page - 1) * $Data['PageSize'];
if ($Page > $Data['PageCount']) {
$Page = $Data['PageCount'];
}
$Data['Data'] = $CustProModule->GetLists($MysqlWhere, $Offset, $Data['PageSize']);
foreach ($Data['Data'] as $Key => $Value) {
$CustomerInfo = $CustomersModule->GetOneInfoByKeyID($Value['CustomersID']);
$Data['Data'][$Key]['CompanyName'] = $CustomerInfo['CompanyName'];
$PropertyModule = new PropertyModule();
$PropertyInfo = $PropertyModule->GetOneInfoByKeyID($Value['GongNeng']);
$Data['Data'][$Key]['GongNeng'] = $PropertyInfo['ProjectPropertyName'];
$Data['Data'][$Key]['Fuwu'] = '';
$Fuwu = $this->GetFuwu($Value['CustomersProjectID']);
if (!empty($Fuwu['have'])) {
foreach ($Fuwu['have'] as $f) {
$FuwuInfo = $FuwuModule->GetOneInfoByKeyID($f);
$Data['Data'][$Key]['Fuwu'] .= ' ' . $FuwuInfo['FuWuName'];
}
} else {
$Data['Data'][$Key]['Fuwu'] .= '-- --';
}
$Data['Data'][$Key]['Fuwu'] .= '<button class="showfuwu button" value="' . $Value['CustomersProjectID'] . '"><img src="images/view-icon.png"></button>';
}
//dd($Data);
MultiPage($Data, 10);
$this->Data = $Data;
}
}
public function GetRenewals($CustomersProjectID = 0, $Year = 1)
{
//获取G宝盆项目id
$ProjectId = TONGYI_ID;
$CustProModule = new CustProModule();
$PropertyModule = new PropertyModule();
$AgentModule = new AgentModule();
$where = "Where CustomersProjectID={$CustomersProjectID} and AgentID={$_SESSION['AgentID']} and ProjectId={$ProjectId}";
$CustProInfo = $CustProModule->GetLists($where);
$EndTime = $CustProInfo[0]['EndTime'];
$GongNeng = $CustProInfo[0]['GongNeng'];
$NowTime = Date('Y');
if (Date('Y', $EndTime) - $NowTime > 10) {
die('达最高上限年限');
}
//获取当前代理的G宝盆等级
$Agentinfo = $AgentModule->GetOneInfoByKeyID($_SESSION['AgentID']);
$LevelID['AgentPriceID'] = $Agentinfo['GBaoPenAgentPriceID'];
//获取该等级的折扣
$AgentPriceModule = new AgentPriceModule();
$AgentPriceinfo = $AgentPriceModule->GetOneInfoByArrayKeys($LevelID);
$AgenDiscount = $AgentPriceinfo['AgenDiscount'];
//获取该功能的价格
$Propertyinfo = $PropertyModule->GetProjectPropertyLists("where ProjectID={$ProjectId} and ProjectPropertyID={$GongNeng}");
$MarketPrice = $Propertyinfo[0]['MarketPrice'];
$StandardCost = ceil($MarketPrice * $AgenDiscount * $Year);
$data['newEndTime'] = date('Y-m-d', strtotime("{$EndTime}+ {$Year} years"));
$data['StandardCost'] = $StandardCost;
$data['AgenDiscount'] = $AgentPriceinfo['AgenDiscount'];
return $data;
}
public function Lists()
{
$CustomersID = _intval($this->_GET['CustomersID']);
$MysqlWhere = ' where CustomersID=' . $CustomersID;
$Page = intval($this->_GET['Page']);
$Page = $Page ? $Page : 1;
$CustProModule = new CustProModule();
$ListsNum = $CustProModule->GetListsNum($MysqlWhere);
$Rscount = $ListsNum['Num'];
$PageSize = 10;
if ($Rscount) {
$Data['RecordCount'] = $Rscount;
$Data['PageSize'] = $PageSize ? $PageSize : $Data['RecordCount'];
$Data['PageCount'] = ceil($Data['RecordCount'] / $PageSize);
$Data['Page'] = min($Page, $Data['PageCount']);
$Offset = ($Page - 1) * $Data['PageSize'];
if ($Page > $Data['PageCount']) {
$Page = $Data['PageCount'];
}
$Data['Data'] = $CustProModule->GetLists($MysqlWhere, $Offset, $Data['PageSize']);
$ProjectModule = new ProjectModule();
$CustomersModule = new CustomersModule();
$PropertyModule = new PropertyModule();
foreach ($Data['Data'] as $Key => $Value) {
$CustomersInfo = $CustomersModule->GetOneInfoByKeyID($Value['CustomersID']);
$Data['Data'][$Key]['CompanyName'] = $CustomersInfo['CompanyName'];
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($Value['ProjectID']);
$Data['Data'][$Key]['ProjectName'] = $ProjectInfo['ProjectName'];
if ($Value['ProjectPropertyID'] != '') {
$Data['Data'][$Key]['ProjectPropertyArray'] = $PropertyModule->GetProjectPropertyLists(' where ProjectPropertyID in(' . $Value['ProjectPropertyID'] . ')', 0, 100);
}
}
MultiPage($Data, 10);
$this->Data = $Data;
}
//获取用户信息
$CustomersID = _intval($this->_GET['CustomersID']);
$CustomersModule = new CustomersModule();
$CustomersInfo = $CustomersModule->GetOneInfoByKeyID($CustomersID);
$this->CustomersInfo = $CustomersInfo;
//获取所有产品
$ProjectModule = new ProjectModule();
$ProjectLists = $ProjectModule->GetProjectLists('', 0, 100);
$this->ProjectLists = $ProjectLists;
//客戶产品信息
$CustomersProjectID = _intval($this->_GET['CustomersProjectID']);
if ($CustomersProjectID > 0) {
$CustProInfo = $CustProModule->GetOneInfoByKeyID($CustomersProjectID);
//产品下属性列表
$ProjectID = $CustProInfo['ProjectID'];
$PropertyModule = new PropertyModule();
$String = '';
$selected = '';
$MysqlWhere = ' where ProjectID=' . $ProjectID . ' and ProjectPropertyParentID=0';
$PropertyData = $PropertyModule->GetProjectPropertyLists($MysqlWhere, 0, 100);
foreach ($PropertyData as $Key => $Value) {
$String .= '<p>' . $Value['ProjectPropertyName'];
$String .= '<select name="ProjectPropertyID[]" id="ProjectPropertyID' . $Value['ProjectPropertyID'] . '">';
$MysqlWhereTwo = ' where ProjectPropertyParentID=' . $Value['ProjectPropertyID'];
$PropertyData[$Key]['Two'] = $PropertyModule->GetProjectPropertyLists($MysqlWhereTwo, 0, 100);
foreach ($PropertyData[$Key]['Two'] as $KeyTwo => $ValueTwo) {
$a = ',' . $CustProInfo['ProjectPropertyID'] . ',';
$b = ',' . $ValueTwo['ProjectPropertyID'] . ',';
if (strstr($a, $b)) {
$selected = 'selected="selected"';
}
$String .= '<option value="' . $ValueTwo['ProjectPropertyID'] . '" ' . $selected . '> ' . $ValueTwo['ProjectPropertyName'] . ' </option>';
unset($selected);
}
$String .= '</select>';
$String .= '</p>';
}
$CustProInfo['property'] = $String;
}
$this->CustomersProjectID = $CustomersProjectID;
$this->CustProInfo = $CustProInfo;
}
public function showList()
{
$public = $this->_POST['_code'];
$token = $this->_POST['_token'];
$From = $this->_POST['fistid'] ? $this->_POST['fistid'] : 0;
$Pagesize = $this->_POST['num'] ? $this->_POST['num'] + 1 : 11;
$AgentID = $this->verify($public, $token);
if ($AgentID) {
$CustomersModule = new CustomersModule();
$CustProModule = new CustProModule();
$where = "where AgentID={$AgentID}";
$CustProInfo = $CustProModule->GetLists($where, $From, $Pagesize);
foreach ($CustProInfo as $k => $v) {
$show[$k]['id'] = $v['CustomersProjectID'];
$show[$k]['project_name'] = $this->GetNamebyProjectID($v['ProjectID']);
$show[$k]['create_at'] = $v['AddTime'];
$show[$k]['begin_at'] = $v['StartTime'];
$show[$k]['end_at'] = $v['EndTime'];
$show[$k]['status'] = $v['status'];
$CustomerInfo = $CustomersModule->GetOneInfoByKeyID($v['CustomersID']);
$show[$k]['company'] = $CustomerInfo['CompanyName'];
$show[$k]['customer'] = $CustomerInfo['CustomersName'];
$show[$k]['phone'] = $CustomerInfo['Tel'];
$show[$k]['email'] = $CustomerInfo['Email'];
$show[$k]['Vesion'] = $v['GongNeng'];
$show[$k]['others'] = '';
}
} else {
$show = array(0);
}
die(jsonp($show, 'JSONP'));
}
