public function Recharge()
{
$this->MyAction = 'Recharge';
$Page = intval($this->_GET['Page']);
$type = $this->_GET['type'];
$Page = $Page ? $Page : 1;
$OrderModule = new OrderModule();
$OrderDescriptionModule = new OrderDescriptionModule();
$MysqlWhere = "where AgentID={$_SESSION['AgentID']} and Type=1";
$Searchtxt = $this->_POST['searchtxt'];
$FengxinID = FENGXIN_ID;
$GBaoPenID = GBAOPEN_ID;
if ($Searchtxt != '') {
$MysqlWhere .= " and OrderNO='{$Searchtxt}'";
}
if ($type == 'f') {
$MysqlWhere .= " and ProjectID='{$FengxinID}'";
} elseif ($type == 'g') {
$MysqlWhere .= " and ProjectID='{$GBaoPenID}'";
} else {
}
$OrderInfo = $OrderModule->GetLists($MysqlWhere);
$ListsNum = $OrderModule->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'] = $OrderModule->GetLists($MysqlWhere, $Offset, $Data['PageSize']);
//dd($Data);
foreach ($Data['Data'] as $k => $v) {
$Description = $OrderDescriptionModule->GetOneInfoByKeyID($v[DescriptionID]);
$Data['Data'][$k]['Description'] = $Description['Description'];
if ($v['ProjectID'] == $FengxinID) {
$Data['Data'][$k]['ProjectID'] = '风信';
}
if ($v['ProjectID'] == $GBaoPenID) {
$Data['Data'][$k]['ProjectID'] = 'G宝盆';
}
}
MultiPage($Data, 10);
$this->Data = $Data;
}
}
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;
}
}