public function Add() { if ($this->_POST) { //提交添加 $CustomersProjectID = _intval($this->_POST['CustomersProjectID']); $Data['ProjectID'] = trim($this->_POST['ProjectID']); $ProjectPropertyID = $this->_POST['ProjectPropertyID']; $PropertyPropertyIDString = ''; foreach ($ProjectPropertyID as $Value) { $PropertyPropertyIDString .= ',' . $Value; } $Data['ProjectPropertyID'] = substr($PropertyPropertyIDString, 1); $Data['StartTime'] = trim($this->_POST['StartTime']); $Data['EndTime'] = trim($this->_POST['EndTime']); $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['CustomersID'] = _intval($this->_POST['CustomersID']); $Data['MoreTime'] = trim($this->_POST['MoreTime']); $Data['OpenLinks'] = trim($this->_POST['OpenLinks']); $Data['WeiXinName'] = trim($this->_POST['WeiXinName']); $Data['WeiXinID'] = trim($this->_POST['WeiXinID']); $Data['WeiXinNO'] = trim($this->_POST['WeiXinNO']); if ($Data['ProjectID'] == '' || $Data['ProjectPropertyID'] == '' || $Data['StartTime'] == '' || $Data['EndTime'] == '') { $this->__Message('信息填写不完整!'); } $CustProModule = new CustProModule(); if ($CustomersProjectID > 0) { if ($CustProModule->UpdateArrayByKeyID($Data, $CustomersProjectID)) { $this->ToAddFengXin($Data); $this->__Message('编辑属性成功!', UrlRewriteSimple('CustPro', 'Lists', true) . '&CustomersID=' . $Data['CustomersID'], '继续操作'); } else { $this->__Message('编辑属性失败,请再一次尝试!'); } } else { if ($CustProModule->InsertArray($Data)) { $this->__Message('开通产品成功!', UrlRewriteSimple('CustPro', 'Lists', true) . '&CustomersID=' . $Data['CustomersID'], '继续操作'); } else { $this->__Message('开通产品失败,请再一次尝试!'); } } } }
public function UpdateGBPenCustomersProject($PostInfo = array(), $CustomersProjectID = 0) { if (!$CustomersProjectID) { return 0; } $this->__LoadModules('/modules/class.CustProModule.php'); $CustProModule = new CustProModule(); $UpdateInfo['UpdateTime'] = date("Y-m-d H:i:s"); $UpdateInfo['Remark'] = $PostInfo['cus_remark']; $UpdateInfo['ProjectID'] = $this->ProjectID; $UpdateInfo['ProjectPropertyID'] = $this->ProjectPropertyID; $UpdateInfo['StartTime'] = $PostInfo['cus_addtime']; $UpdateInfo['EndTime'] = $PostInfo['cus_endtime']; if ($CustProModule->UpdateArrayByKeyID($UpdateInfo, $CustomersProjectID)) { return 1; } else { return 0; } }
public function FinalRenewals() { $CustomersProjectID = intval($this->_POST['CustoProID']); $Year = $this->_POST['ryear']; $Across = $this->_POST['across']; $Page = _intval($this->_GET['Page']); $LogsFunction = new LogsFunction(); $CustProModule = new CustProModule(); $where = "where CustomersProjectID={$CustomersProjectID} and AgentID={$_SESSION['AgentID']}"; $CustProInfo = $CustProModule->GetInfoByWhere($where); $time = date('H:i:s'); $NewEndTime = $Year . ' ' . $time; if (empty($CustProInfo)) { JsMessage('数据错误或者非法操作!', UrlRewriteSimple('FengXin', 'Customer', true) . '&Page=' . $Page, '继续操作'); } else { $Version = $CustProInfo['GongNeng']; $PropertyModule = new PropertyModule(); $PropertyInfo = $PropertyModule->GetOneInfoByKeyID($Version); $MarketPrice = $PropertyInfo['MarketPrice']; //获取当前代理的等级 $AgentModule = new AgentModule(); $Agentinfo = $AgentModule->GetOneInfoByKeyID($_SESSION['AgentID']); $LevelID['AgentPriceID'] = $Agentinfo['FengXinAgentPriceID']; //获取该等级的折扣 $AgentPriceModule = new AgentPriceModule(); $AgentPriceinfo = $AgentPriceModule->GetOneInfoByArrayKeys($LevelID); $AgenDiscount = $AgentPriceinfo['AgenDiscount']; $CustomersModule = new CustomersModule(); $CustomersInfo = $CustomersModule->GetOneInfoByKeyID($CustProInfo['CustomersID']); $CustomersID = $CustomersInfo['CustomersID']; $OldEndTime = date('Y-m-d', strtotime($CustProInfo['EndTime'])); $cost = 0; $description = ''; $sql_version = ''; if (strtotime($Year) > strtotime($OldEndTime)) { $sql_version = "update tb_customers_project set EndTime ='{$NewEndTime}' where CustomersProjectID={$CustomersProjectID}"; $update1 = $CustProModule->UpdateArrayByKeyID($update1, $CustomersProjectID); $versioncost = (strtotime($Year) - strtotime($OldEndTime)) / (3600 * 24) * $MarketPrice * $AgenDiscount / 365; $cost += $versioncost; $description .= '版本约消费¥' . round($versioncost); } $CustFuwuModule = new CustFuwuModule(); $mysqlwhere = "where CustomersProjectID={$CustomersProjectID}"; $CustFuwuInfo = $CustFuwuModule->GetAll($mysqlwhere); $FuwuModule = new FuwuModule(); foreach ($CustFuwuInfo as $v) { $FuwuEndTime = date('Y-m-d', strtotime($v['EndTime'])); $FuwuInfo = $FuwuModule->GetOneInfoByKeyID($v['FuWuID']); $FuWuPrice = $FuwuInfo['FuWuPrice']; $FuWuName = $FuwuInfo['FuWuName']; $filter['FuWuID'] = intval($v['FuWuID']); $filter['CustomersProjectID'] = $CustomersProjectID; if (strtotime($FuwuEndTime) < strtotime(date('Y-m-d'))) { $FuwuEndTime = date('Y-m-d'); } if (in_array($v['FuWuID'], $Across)) { if (strtotime($Year) > strtotime($FuwuEndTime)) { $sqlfuwu[$FuWuName] = "update tbl_customers_fuwu set EndTime ='{$NewEndTime}' where FuWuID={$v['FuWuID']} and CustomersProjectID={$CustomersProjectID}"; $fuwucost = (strtotime($Year) - strtotime($FuwuEndTime)) / (3600 * 24) * $FuWuPrice * $AgenDiscount / 365; $cost += $fuwucost; $description .= ',' . $FuWuName . '约消费¥' . round($fuwucost); } } else { $array_search = array($FuWuName => $FuwuInfo['EndTime']); $seletname = 'upselect' . $v['FuWuID']; $selectEndTime = $this->_POST["{$seletname}"]; if (strtotime($selectEndTime) > strtotime($FuwuEndTime)) { $update3['EndTime'] = $selectEndTime . ' ' . $time; $sqlfuwu[$FuWuName] = "update tbl_customers_fuwu set EndTime ='{$update3['EndTime']}' where FuWuID={$v['FuWuID']} and CustomersProjectID={$CustomersProjectID}"; $fuwucost = (strtotime($selectEndTime) - strtotime($FuwuEndTime)) / (3600 * 24) * $FuWuPrice * $AgenDiscount / 365; $cost += $fuwucost; $description .= ',' . $FuWuName . '约消费¥' . round($fuwucost); } } } $cost = round($cost); $description .= ',合计消费¥' . $cost; //代理扣款 $AgentAccountModule = new AgentAccountModule(); $ProjectId = FENGXIN_ID; $sqlwhere = "where Agentid={$_SESSION['AgentID']} and ProjectID={$ProjectId}"; $AgentAccountInfo = $AgentAccountModule->GetLists($sqlwhere); if ($AgentAccountInfo[0]['Balance'] < $cost) { JsMessage('余额不足!', UrlRewriteSimple('FengXin', 'Customer', true) . '&Page=' . $Page, '继续操作'); } else { $sql = "update {$AgentAccountModule->TableName} set Balance=Balance-{$cost} where Agentid={$_SESSION['AgentID']} and ProjectID={$ProjectId}"; $b = $AgentAccountModule->Update($sql); if ($b) { if ($sql_version == '' || mysql_query($sql_version)) { } else { $description .= '(版本已扣款未延期到' . $Year . ',此次续费需手动操作!)'; } foreach ($sqlfuwu as $k => $s) { if (mysql_query($s)) { } else { $description .= '(' . $array_search[$k] . '已扣款未延期到,此次续费需手动操作!)'; } } $OrderModule = new OrderModule(); $OrderDescriptionModule = new OrderDescriptionModule(); $Description['Description'] = $CustomersInfo['CompanyName'] . '本次续费' . $description; $OrderDescriptionModule->InsertArray($Description); $DescriptionID = mysql_insert_id(); $Order['OrderNO'] = GetOrderNO(); $Order['AgentID'] = $_SESSION['AgentID']; $Order['CustomersID'] = $CustomersID; $Order['AddTime'] = date('Y-m-d') . ' ' . $time; $Order['FromIP'] = GetIP(); $Order['ProjectID'] = $ProjectId; $Order['DescriptionID'] = $DescriptionID; $Order['Type'] = 0; $Order['Amount'] = $cost; $OrderModule->InsertArray($Order); $LogsFunction->logsinfile('109', 1, $CustomersID, '', $Order['OrderNO']); $Sync = $this->ToFengXinEditInfo($CustomersProjectID); if ($Sync) { $LogsFunction->logsinfile('109', 5, $CustomersID, $Description['Description'], $Order['OrderNO']); } else { $LogsFunction->logsinfile('109', 6, $CustomersID, $Description['Description'], $Order['OrderNO']); } JsMessage('续费成功!', UrlRewriteSimple('FengXin', 'Customer', true) . '&Page=' . $Page, '继续操作'); } else { JsMessage('续费异常!', UrlRewriteSimple('FengXin', 'Customer', true) . '&Page=' . $Page, '继续操作'); } } } }
public function gedit() { $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']; $id = $this->_POST['pid']; $public['private'] = $AgentApiInfo['private']; $verify = $this->verify($public, $token); if ($verify && $id != '') { $edit['FengXinUserName'] = $this->_POST['username']; $edit['WeiXinName'] = $this->_POST['weixinname']; $edit['WeiXinID'] = $this->_POST['weixinid']; $edit['WeiXinNO'] = $this->_POST['weixnno']; $edit['Remark'] = $this->_POST['remark']; $edit['status'] = $this->_POST['status']; $CustProModule = new CustProModule(); if ($CustProModule->UpdateArrayByKeyID($edit, $id)) { die(jsonp(array('0', '修改成功'), 'JSONP')); } else { die(jsonp(array('1001', '数据提供错误'), 'JSONP')); } } else { die(jsonp(array('1001', '数据提供错误'), 'JSONP')); } }