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')); }