public function Edit()
{
if ($this->_POST) {
$KeyID = _intval($this->_POST['KeyID']);
$Data['ProjectName'] = trim($this->_POST['ProjectName']);
$Data['OnlineTime'] = trim($this->_POST['OnlineTime']);
$Data['Remark'] = addslashes($this->_POST['Remark']);
$Data['UpdateTime'] = date("Y-m-d H:i:s");
$ProjectModule = new ProjectModule();
if ($ProjectModule->UpdateArrayByKeyID($Data, $KeyID)) {
$this->__Message('修改产品成功!', UrlRewriteSimple('Project', 'Lists', true), '继续操作');
} else {
$this->__Message('修改产品失败,请再一次尝试!');
}
}
if ($this->_GET) {
$KeyID = _intval($this->_GET['KeyID']);
$ProjectModule = new ProjectModule();
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($KeyID);
$this->ProjectInfo = $ProjectInfo;
}
}
public function Lists()
{
if ($this->_GET) {
$ProjectID = _intval($this->_GET['ProjectID']);
$this->ProjectID = $ProjectID;
$PropertyModule = new PropertyModule();
$ProjectModule = new ProjectModule();
//产品下属性列表
if ($ProjectID == 1) {
$ModelClass = new ModelClassModule();
$ModelClassLists = $ModelClass->GetListsAll();
$this->ModelClassLists = $ModelClassLists;
$this->Data = array_merge($PropertyModule->GetAllModelLists(), $PropertyModule->GetAllModelLists('tb_model_packages'));
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($ProjectID);
$this->ProjectInfo = $ProjectInfo;
$NO = $this->_GET['NO'];
if ($NO) {
$Model = $PropertyModule->GetOneInfoByNO($NO);
if (!$Model) {
$Model = $PropertyModule->GetOneInfoByNO($NO, 'PackagesNum', 'tb_model_packages');
}
$this->Model = $Model;
}
if ($this->_GET['State']) {
$this->State = $this->_GET['State'];
} else {
$this->State = 0;
}
} else {
$MysqlWhere = ' where ProjectID=' . $ProjectID . ' and ProjectPropertyParentID=0';
$Data = $PropertyModule->GetProjectPropertyLists($MysqlWhere, 0, 100);
foreach ($Data as $Key => $Value) {
$MysqlWhereTwo = ' where ProjectPropertyParentID=' . $Value['ProjectPropertyID'];
$Data[$Key]['Two'] = $PropertyModule->GetProjectPropertyLists($MysqlWhereTwo, 0, 100);
}
$this->Data = $Data;
//一级产品属性
$ParentMysqlWhere = ' where ProjectID=' . $ProjectID . ' and ProjectPropertyParentID=0';
$ParentData = $PropertyModule->GetProjectPropertyLists($ParentMysqlWhere, 0, 100);
$this->ParentData = $ParentData;
//产品信息
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($ProjectID);
$this->ProjectInfo = $ProjectInfo;
//产品属性信息
$ProjectPropertyID = _intval($this->_GET['ProjectPropertyID']);
if ($ProjectPropertyID > 0) {
$ProjectPropertyInfo = $PropertyModule->GetOneInfoByKeyID($ProjectPropertyID);
$this->MyFuWuString = ',' . $ProjectPropertyInfo['MyFuWu'] . ',';
$this->OtherFuWuString = ',' . $ProjectPropertyInfo['OtherFuWu'] . ',';
$this->ProjectPropertyInfo = $ProjectPropertyInfo;
}
//服务
$FuWuModule = new FuWuModule();
$this->FuWuList = $FuWuModule->SelectLists();
}
}
}
public function Lists()
{
include 'Include/LevelArray.php';
$MysqlWhere = ' where 1';
$Page = intval($this->_GET['Page']);
$Page = $Page ? $Page : 1;
$AgentPriceModule = new AgentPriceModule();
$ListsNum = $AgentPriceModule->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'] = $AgentPriceModule->GetLists($MysqlWhere, $Offset, $Data['PageSize']);
$ProjectModule = new ProjectModule();
foreach ($Data['Data'] as $Key => $Value) {
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($Value['ProjectID']);
$Data['Data'][$Key]['ProjectName'] = $ProjectInfo['ProjectName'];
$Data['Data'][$Key]['LevelName'] = GetNameByID($Value['LevelID']);
}
MultiPage($Data, 10);
$this->Data = $Data;
}
}
public function AddOrder($AgentID = 0, $ProjectID = 0, $Balance = 0, $JinE = 0)
{
if ($ProjectID == 0 || $JinE == 0) {
return 0;
}
//求产品详情
$ProjectModule = new ProjectModule();
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($ProjectID);
//入账记录
$InsertInfo['Description'] = '线下入账' . $JinE . '元用于购买' . $ProjectInfo['ProjectName'] . '，' . $ProjectInfo['ProjectName'] . '可用余额为' . $Balance . '。';
$OrderDescriptionModule = new OrderDescriptionModule();
$InsertOrderInfo['DescriptionID'] = $OrderDescriptionModule->InsertArray($InsertInfo, true);
if ($InsertOrderInfo['DescriptionID'] > 0) {
$OrderModule = new OrderModule();
$InsertOrderInfo['OrderNO'] = GetOrderNO();
$InsertOrderInfo['AgentID'] = $AgentID;
$InsertOrderInfo['ProjectID'] = $ProjectID;
$InsertOrderInfo['Amount'] = $JinE;
$InsertOrderInfo['AddTime'] = date("Y-m-d H:i:s");
$InsertOrderInfo['FromIP'] = GetIP();
$InsertOrderInfo['Remarks'] = '';
$InsertOrderInfo['Type'] = 1;
$AllIsOk = $OrderModule->InsertArray($InsertOrderInfo);
if ($AllIsOk) {
return 1;
} else {
return 0;
}
}
return 0;
}
public function Info()
{
$this->OrderID = _intval($this->_GET['OrderID']);
$this->Page = _intval($this->_GET['Page']);
$OrderModule = new OrderModule();
$OrderInfo = $OrderModule->GetOneInfoByKeyID($this->OrderID);
$AgentModule = new AgentModule();
$AgentInfo = $AgentModule->GetOneInfoByKeyID($OrderInfo['AgentID']);
$OrderInfo['AgentUserName'] = $AgentInfo['UserName'];
$ProjectModule = new ProjectModule();
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($OrderInfo['ProjectID']);
$OrderInfo['ProjectName'] = $ProjectInfo['ProjectName'];
$OrderDescriptionModule = new OrderDescriptionModule();
$OrderDescriptionInfo = $OrderDescriptionModule->GetOneInfoByKeyID($OrderInfo['DescriptionID']);
$OrderInfo['Description'] = $OrderDescriptionInfo['Description'];
if ($OrderInfo['Type'] == 1) {
$OrderInfo['TypeName'] = '入账';
} else {
$OrderInfo['TypeName'] = '消费';
}
$this->OrderInfo = $OrderInfo;
}
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 GetNamebyProjectID($id = '')
{
$ProjectModule = new ProjectModule();
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($id);
return $ProjectInfo['ProjectName'];
}
