public function Edit() { $AgentPriceModule = new AgentPriceModule(); if ($this->_POST) { //提交修改 $AgentPriceID = _intval($this->_POST['AgentPriceID']); $Data['LevelID'] = trim($this->_POST['LevelID']); $Data['ProjectID'] = trim($this->_POST['ProjectID']); $Data['AgenDiscount'] = trim($this->_POST['AgenDiscount']); $Data['Remarks'] = trim($this->_POST['Remarks']); $Data['AddTime'] = time(); $Page = _intval($this->_POST['Page']); if (!$Data['LevelID'] || !$Data['ProjectID'] || !$Data['AgenDiscount']) { $this->__Message('信息填写不完整!'); } if ($AgentPriceModule->UpdateArrayByKeyID($Data, $AgentPriceID)) { $this->__Message('修改成功!', UrlRewriteSimple($this->MyModule, 'Lists', true) . '&Page=' . $Page, '继续操作'); } else { $this->__Message('修改失败,请再一次尝试!'); } } if ($this->_GET) { //获取用户信息 $this->AgentPriceID = _intval($this->_GET['AgentPriceID']); $this->Page = _intval($this->_GET['Page']); $AgentPriceInfo = $AgentPriceModule->GetOneInfoByKeyID($this->AgentPriceID); $this->AgentPriceInfo = $AgentPriceInfo; $ProjectModule = new ProjectModule(); $this->ProjectLists = $ProjectModule->GetProjectLists(); include 'Include/LevelArray.php'; $this->LevelArray = $LevelArray; } }
public function AddAccount() { if ($this->_POST) { //提交添加 $Post['ProjectID'] = _intval($this->_POST['ProjectID']); $Post['AgentID'] = _intval($this->_POST['AgentID']); $Remarks = trim($this->_POST['Remarks']); $JinE = trim($this->_POST['JinE']); $Page = _intval($this->_POST['Page']); if ($JinE < 1 || $Post['ProjectID'] == 0 || $Post['AgentID'] == 0) { $this->__Message('信息填写错误!'); } $AgentAccountModule = new AgentAccountModule(); $AgentAccountInfo = $AgentAccountModule->GetOneInfoByArrayKeys($Post); if (empty($AgentAccountInfo)) { //添加数据表 $Post['Remarks'] = $Remarks; $Post['Total'] = $JinE; $Post['Balance'] = $JinE; $IsOk = $AgentAccountModule->InsertArray($Post); } else { //更新数据表 $UpdateInfo['Remarks'] = $Remarks; $UpdateInfo['Total'] = $AgentAccountInfo['Total'] + $JinE; $UpdateInfo['Balance'] = $AgentAccountInfo['Balance'] + $JinE; $IsOk = $AgentAccountModule->UpdateArrayByArrayKeys($UpdateInfo, $Post); } if ($IsOk) { $AddOrderIsOk = $this->AddOrder($Post['AgentID'], $Post['ProjectID'], $JinE + $AgentAccountInfo['Balance'], $JinE); if ($AddOrderIsOk == 0) { $this->__Message('入账成功,记录操作失败!', UrlRewriteSimple($this->MyModule, 'Lists', true) . '&Page=' . $Page, '继续操作'); } $this->__Message('入账成功!', UrlRewriteSimple($this->MyModule, 'Lists', true) . '&Page=' . $Page, '继续操作'); } else { $this->__Message('入账失败,请再一次尝试!'); } } else { $AgentID = trim($this->_GET['AgentID']); $AgentModule = new AgentModule(); $this->AgentInfo = $AgentModule->GetOneInfoByKeyID($AgentID); //print_r($this->AgentInfo);exit; include 'Include/LevelArray.php'; $ProjectModule = new ProjectModule(); $this->ProjectLists = $ProjectModule->GetProjectLists(); } }
public function GetProjectID($projectname = '') { $ProjectModule = new ProjectModule(); $MysqlWhere = " where {$ProjectModule->ProjectName}='{$projectname}'"; $ProjectList = $ProjectModule->GetProjectLists($MysqlWhere); $FengxinID = $ProjectList[0]['ProjectID']; return $FengxinID; }
public function Lists() { $MysqlWhere = ' where 1'; $Page = intval($this->_GET['Page']); $Page = $Page ? $Page : 1; $ProjectModule = new ProjectModule(); $ProjectListsNum = $ProjectModule->GetProjectListsNum($MysqlWhere); $Rscount = $ProjectListsNum['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'] = $ProjectModule->GetProjectLists($MysqlWhere, $Offset, $Data['PageSize']); MultiPage($Data, 10); $this->Data = $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; }