public function InsertGBPenCustomers($PostInfo)
{
$this->__LoadModules('/modules/class.CustomersModule.php');
$CustomersModule = new CustomersModule();
$InsertInfo['CompanyName'] = $PostInfo['cus_company'];
//查询公司名称是否存在
$CustomersInfo = $CustomersModule->GetOneInfoByArrayKeys(array('CompanyName' => $InsertInfo['CompanyName']));
if (!empty($CustomersInfo)) {
//公司名称存在就插入产品信息
$IsInsertGBPenCustomersProjectOk = $this->InsertGBPenCustomersProject($PostInfo, $CustomersInfo['CustomersID']);
} else {
//插入公司和产品信息
$CustomersID = $this->InsertCustomersInfo($PostInfo);
if ($CustomersID > 0) {
$IsInsertGBPenCustomersProjectOk = $this->InsertGBPenCustomersProject($PostInfo, $CustomersID);
}
}
if ($IsInsertGBPenCustomersProjectOk) {
return 1;
} else {
return 0;
}
}
public function Renewals()
{
$CustomersID = $this->_GET['ID'];
$CustomersModule = new CustomersModule();
$SearchArray['CustomersID'] = $CustomersID;
$SearchArray['AgentID'] = $_SESSION['AgentID'];
$CustomInfo = $CustomersModule->GetOneInfoByArrayKeys($SearchArray);
//dd($CustomInfo);
$CompanyName = $CustomInfo['CompanyName'];
//获取G宝盆项目id
$ProjectId = TONGYI_ID;
$QuerryArray['CustomersID'] = $CustomersID;
$QuerryArray['ProjectId'] = $ProjectId;
$QuerryArray['AgentID'] = $_SESSION['AgentID'];
$CustProModule = new CustProModule();
$CustProInfo = $CustProModule->GetOneInfoByArrayKeys($QuerryArray);
//dd($CustProInfo);
$CustomersProjectID = $CustProInfo['CustomersProjectID'];
$time = date('Y');
$LastTime = date('Y', strtotime($CustProInfo['EndTime'])) - $time;
//dd($i);
$CanAddTime = 10 - $LastTime;
$option = '';
$show = '';
if ($CanAddTime <= 0) {
$option .= '<option value="0">已达最高年限</option>';
} else {
$data = $this->GetRenewals($CustomersProjectID, 1);
$show = '<center>到期时间调整为<span class="red rendtime">' . $data['newEndTime'] . '</span></center>
<center class="Consumption">将消费金额：<span class="red font22">￥' . $data['StandardCost'] . '</span></center>';
for ($i; $i < $CanAddTime; $i++) {
$k = $i + 1;
$option .= '<option value="' . $k . '">' . $k . '年</option>';
}
}
$String = '<h1 class="Bombbox-top">
<span class="close"><img src="images/close.png" /></span>续费
</h1>
<div class="Bombbox-m">
<form name="form2" method="post" action="' . UrlRewriteSimple($this->MyModule, 'FinalRenewals', true) . '" id="form2">
<table width="100%" border="0">
<tr height="40">
<td>确定<b class="blue">' . $CompanyName . '</b> 续费
<input type="hidden" name="CustoProID" value="' . $CustProInfo['CustomersProjectID'] . '" />
<select name="ryear">
' . $option . '
</select> <br />
</td>
</tr>
<tr>
<td class="rshow">' . $show . '</td>
</tr>
<tr height="45">
<td align="center"><input name="" type="submit" value="确定"
class="btn-Determine" /> <input name="" type="button"
value="取消" class="btn-Cancel" /></td>
</tr>
</table>
</form>
</div>';
die($String);
}
public function AddCustomer()
{
if ($this->_POST) {
$LogsFunction = new LogsFunction();
$Data['CompanyName'] = trim($this->_POST['CompanyName']);
$CustomersModule = new CustomersModule();
$IsCompanyInfo = $CustomersModule->GetOneInfoByArrayKeys($Data);
if (!empty($IsCompanyInfo)) {
$LogsFunction->logsinfile('101', 2, $CustomersID);
JsMessage('该公司已经存在!');
}
$Data['CustomersName'] = trim($this->_POST['CustomersName']);
$Data['Area'] = trim($this->_POST['Area']);
$Data['Tel'] = trim($this->_POST['Tel']);
$Data['Fax'] = trim($this->_POST['Fax']);
$Data['Email'] = trim($this->_POST['Email']);
$Data['Address'] = trim($this->_POST['Address']);
$Data['Remark'] = addslashes($this->_POST['Remark']);
$Data['UpdateTime'] = date("Y-m-d H:i:s");
$Data['AddTime'] = date("Y-m-d H:i:s");
$Data['AgentID'] = $_SESSION['AgentID'];
if ($Data['Tel'] == '' || $Data['Email'] == '' || $Data['AgentID'] == '') {
JsMessage('信息填写不完整!');
}
if ($CustomersModule->InsertArray($Data)) {
$LogsFunction->logsinfile('101', 1, $CustomersID);
JsMessage('添加客户成功!', UrlRewriteSimple('Agent', 'Customer', true), '继续操作');
} else {
$LogsFunction->logsinfile('101', 0, $CustomersID);
JsMessage('添加客户失败,请再一次尝试!');
}
}
}
public function Seach()
{
$MysqlWhere = ' where 1';
$WhereGet = '';
$this->seachValue = trim($this->_GET['seachValue']);
//订单号
$OrderNO = trim($this->_GET['OrderNO']);
if ($OrderNO != 0) {
$MysqlWhere .= ' and OrderNO=\'' . $OrderNO . '\'';
$WhereGet .= '&OrderNO=' . $OrderNO;
$this->OrderNO = $OrderNO;
}
//入账/消费
$Type = $this->_GET['Type'];
if ($Type == '入账') {
$MysqlWhere .= ' and Type=1';
$WhereGet .= '&Type=' . $Type;
$this->Type = $Type;
}
if ($Type == '消费') {
$MysqlWhere .= ' and Type=0';
$WhereGet .= '&Type=' . $Type;
$this->Type = $Type;
}
//代理商
$AgentIDValue = trim($this->_GET['AgentIDValue']);
if ($AgentIDValue != '') {
$AgentModule = new AgentModule();
$AgentInfo = $AgentModule->GetOneInfoByArrayKeys(array('UserName' => $AgentIDValue));
$MysqlWhere .= ' and AgentID=' . $AgentInfo['AgentID'];
$WhereGet .= '&AgentIDValue=' . $AgentIDValue;
$this->AgentIDValue = $AgentIDValue;
}
//产品
$ProjectIDValue = trim($this->_GET['ProjectIDValue']);
if ($ProjectIDValue != '') {
$MysqlWhere .= ' and ProjectID=' . $ProjectIDValue;
$WhereGet .= '&ProjectIDValue=' . $ProjectIDValue;
$this->ProjectIDValue = $ProjectIDValue;
}
//客户企业名称
$CustomersIDValue = trim($this->_GET['CustomersIDValue']);
if ($CustomersIDValue != '') {
$CustomersModule = new CustomersModule();
$CustomersInfo = $CustomersModule->GetOneInfoByArrayKeys(array('CompanyName' => $CustomersIDValue));
$MysqlWhere .= ' and CustomersID=' . $CustomersInfo['CustomersID'];
$WhereGet .= '&CustomersIDValue=' . $CustomersIDValue;
$this->CustomersIDValue = $CustomersIDValue;
}
//下订单开始时间
$StartTime = trim($this->_GET['StartTime']);
$this->StartTime = $StartTime;
if ($StartTime != '') {
$StartTime = $StartTime . ' 00:00:00';
$MysqlWhere .= ' and AddTime>\'' . $StartTime . '\'';
$WhereGet .= '&StartTime=' . $StartTime;
}
//下订单结束时间
$EndTime = trim($this->_GET['EndTime']);
$this->EndTime = $EndTime;
if ($EndTime != '') {
$EndTime = $EndTime . ' 23:59:59';
$MysqlWhere .= ' and AddTime<\'' . $EndTime . '\'';
$WhereGet .= '&EndTime=' . $EndTime;
}
//最低交易金额
$MinAmount = trim($this->_GET['MinAmount']);
if ($MinAmount != '') {
$MysqlWhere .= ' and Amount>' . $MinAmount;
$WhereGet .= '&MinAmount=' . $MinAmount;
$this->MinAmount = $MinAmount;
}
//最高交易金额
$MaxAmount = trim($this->_GET['MaxAmount']);
if ($MaxAmount != '') {
$MysqlWhere .= ' and Amount<' . $MaxAmount;
$WhereGet .= '&MaxAmount=' . $MaxAmount;
$this->MaxAmount = $MaxAmount;
}
//客户端IP
$FromIP = trim($this->_GET['FromIP']);
if ($FromIP != '') {
$MysqlWhere .= ' and FromIP=\'' . $FromIP . '\'';
$WhereGet .= '&FromIP=' . $FromIP;
$this->FromIP = $FromIP;
}
$Page = intval($this->_GET['Page']);
$Page = $Page ? $Page : 1;
$OrderModule = new OrderModule();
$ListsNum = $OrderModule->GetListsNum($MysqlWhere);
$Rscount = $ListsNum['Num'];
$PageSize = 5000;
if ($WhereGet == '') {
$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'] = $OrderModule->GetLists($MysqlWhere, $Offset, $Data['PageSize']);
$AgentModule = new AgentModule();
$AgentAccountModule = new AgentAccountModule();
$ProjectModule = new ProjectModule();
$OrderDescriptionModule = new OrderDescriptionModule();
$RuZhangNum = 0;
$RuZhang = 0;
$XiaoFei = 0;
$XiaoFeiNum = 0;
foreach ($Data['Data'] as $Key => $Value) {
$Array['AgentID'] = $Value['AgentID'];
$AgentInfo = $AgentModule->GetOneInfoByKeyID($Array['AgentID']);
$Data['Data'][$Key]['UserName'] = $AgentInfo['UserName'];
$ProjectInfo = $ProjectModule->GetOneInfoByKeyID($Value['ProjectID']);
$Data['Data'][$Key]['ProjectName'] = $ProjectInfo['ProjectName'];
$AgentAccountInfo = $AgentAccountModule->GetLists('where AgentID=' . $Array['AgentID']);
$Num = count($AgentAccountInfo);
if ($Num == 0) {
$Data['Data'][$Key]['Total'] = '0';
$Data['Data'][$Key]['Balance'] = '0';
} else {
foreach ($AgentAccountInfo as $V) {
$Data['Data'][$Key]['Total'] += $V['Total'];
$Data['Data'][$Key]['Balance'] += $V['Balance'];
}
}
$OrderDescriptionInfo = $OrderDescriptionModule->GetOneInfoByKeyID($Value['DescriptionID']);
$Data['Data'][$Key]['Description'] = $OrderDescriptionInfo['Description'];
if ($Value['Type'] == 1) {
$Data['Data'][$Key]['TypeName'] = '入账';
$RuZhang += $Value['Amount'];
$RuZhangNum++;
} else {
$Data['Data'][$Key]['TypeName'] = '消费';
$XiaoFei += $Value['Amount'];
$XiaoFeiNum++;
}
}
$this->RuZhangNum = $RuZhangNum;
$this->RuZhang = $RuZhang;
$this->XiaoFei = $XiaoFei;
$this->XiaoFeiNum = $XiaoFeiNum;
MultiPage($Data, 10);
$this->Data = $Data;
$this->WhereGet = $WhereGet;
}
}
public function gcreate()
{
$public = array();
$AgentID = $this->_POST['agentid'];
$token = $this->_POST['_token'];
$timemap = $this->_POST['timemap'];
$public['AgentID'] = $AgentID;
$public['timemap'] = $timemap;
$AgentApiModule = new AgentApiModule();
$AgentApiInfo = $AgentApiModule->GetOneInfoByForID($AgentID);
if ($AgentID == '' || $token == '' || ($timemap = '' || empty($AgentApiInfo))) {
die(jsonp(array('0', '数据提供错误'), 'JSONP'));
}
$type = $this->_POST['type'];
$public['private'] = $AgentApiInfo['private'];
$verify = $this->verify($public, $token);
if ($verify) {
$username = $this->_POST['username'];
$company = $this->_POST['company'];
$realname = $this->_POST['realname'];
$phone = $this->_POST['phone'];
$fax = $this->_POST['fax'];
$email = $this->_POST['email'];
$address = $this->_POST['address'];
$weixinname = $this->_POST['weixinname'];
$weixinid = $this->_POST['weixinid'];
$weixnno = $this->_POST['weixnno'];
$remark = $this->_POST['remark'];
$CustomersModule = new CustomersModule();
$CustProModule = new CustProModule();
$where = "where CompanyName='{$company}'";
$num = $CustomersModule->GetListsNum($where);
if ($num['Num']) {
$where = "CompanyName='{$company}' and AgentID={$AgentID}";
if ($realname != '') {
$update['CustomersName'] = $realname;
}
if ($phone != '') {
$update['Tel'] = $phone;
}
if ($fax != '') {
$update['Fax'] = $fax;
}
if ($email != '') {
$update['Email'] = $email;
}
if ($address != '') {
$update['Addresss'] = $address;
}
$update['UpdateTime'] = date('Y-m-d');
if ($CustomersModule->UpdateWhere($update, $where)) {
$SelectID = $CustomersModule->GetOneInfoByArrayKeys();
$id = $SelectID['CustomersID'];
$message = '已更新' . $company . '公司的信息';
$show = array('err' => 0, 'msg' => $message);
} else {
$show = array('err' => 1001, 'msg' => '更新客户信息失败');
}
} else {
if ($company == '') {
$show = array('err' => 1001, 'msg' => '提供一个空的公司名，无法进行处理');
} else {
$insert = array('CompanyName' => $company, 'CustomersName' => $realname, 'Tel' => $phone, 'Fax' => $fax, 'Email' => $email, 'Address' => $address, 'AgentID' => $AgentID);
if ($CustomersModule->InsertArray($insert)) {
$id = mysql_insert_id();
$show = array('err' => 0, 'msg' => '成功添加一个新的风信客户记录');
} else {
$show = array('err' => 1001, 'msg' => '添加新的客户记录失败');
}
}
}
if ($domain != '') {
$gbaopen['AddTime'] = date('Y-m-d');
$gbaopen['StartTime'] = $fengxin['AddTime'];
$gbaopen['EndTime'] = date('Y-m-d', strtotime("{$fengxin['AddTime']} + 7 days"));
$gbaopen['CustomersID'] = $id;
$gbaopen['G_domain'] = $domain;
$fengxing['G_beian'] = $isbeian;
$fengxing['G_name'] = $username;
$CustProModule->InsertArray();
$show['msg'] = $show['msg'] + '，创建G宝盆账号成功';
}
} else {
$show = array('err' => 1001, 'msg' => '提供信息错误，无法进行处理');
}
print_r($show);
die(jsonp($show, 'JSONP'));
}