public function LogsLists() { $Page = intval($this->_GET['Page']); $Page = $Page ? $Page : 1; $Logs = new LogsModule(); $LogsFunction = new LogsFunction(); $CustomersModule = new CustomersModule(); $AgentModule = new AgentModule(); $AgentID = $this->_GET['AgentIDValue']; $CustomersID = $this->_GET['CustomersIDValue']; $OrderNO = $this->_GET['OrderNO']; $Time = $this->_GET['Time']; $FromIP = $this->_GET['FromIP']; $where = 'where 1'; $so = ''; if ($AgentID != NULL) { $AgentInfo = $AgentModule->GetLists("where UserName='******'"); $sql_AgentID = $AgentInfo[0]['AgentID']; $where .= " and AgentID='{$sql_AgentID}'"; $so .= '&AgentIDValue=' . $AgentID; } if ($CustomersID != NULL) { $CustomersInfo = $CustomersModule->GetLists("where CustomersName='{$CustomersID}'"); $sql_CustomersID = $CustomersInfo[0]['CustomersID']; $where .= " and CustomersID='{$sql_CustomersID}'"; $so .= '&CustomersIDValue=' . $CustomersID; } if ($OrderNO != NULL) { $where .= " and OrderNO='{$OrderNO}'"; $so .= '&OrderNO=' . $OrderNO; } if ($Time != NULL) { $str_Time = date('Y-m-d', strtotime($Time)); $time_array = explode('-', $str_Time); $where .= " and file='logs/{$time_array['0']}{$time_array['1']}/{$time_array['2']}.log'"; $so .= '&Time=' . $Time; } if ($FromIP != NULL) { $where .= " and ip='{$FromIP}'"; $so .= '&FromIP=' . $FromIP; } $ListsNum = $Logs->GetListsNum($where); $Rscount = $ListsNum['Num']; $PageSize = 15; 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']; } $List = $Logs->GetLists($where, $Offset, $Data['PageSize']); foreach ($List as $k => $v) { $Data['Data'][$k]['id'] = $v['id']; $Data['Data'][$k]['code'] = $LogsFunction->operate[$v['code']]; $Data['Data'][$k]['status'] = $LogsFunction->operate_status[$v['status']]; $Data['Data'][$k]['ip'] = $v['ip']; $Data['Data'][$k]['time'] = $v['time']; $Data['Data'][$k]['Remark'] = $v['Remark']; $Data['Data'][$k]['OrderNO'] = $v['OrderNO']; $CustomersInfo = $CustomersModule->GetOneInfoByKeyID($v['CustomersID']); $Data['Data'][$k]['CustomersName'] = $CustomersInfo['CustomersName']; $AgentInfo = $AgentModule->GetOneInfoByKeyID($v['AgentID']); $Data['Data'][$k]['AgentUserName'] = $AgentInfo['UserName']; } MultiPage($Data, 10); //dd($Data); $this->Data = $Data; $this->so = $so; } else { $Data['Data'][0]['id'] = '无数据结果'; $this->Data = $Data; } }
public function Lists() { $MysqlWhere = ' where 1'; $Page = intval($this->_GET['Page']); $Page = $Page ? $Page : 1; $CustomersModule = new CustomersModule(); $ListsNum = $CustomersModule->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'] = $CustomersModule->GetLists($MysqlWhere, $Offset, $Data['PageSize']); MultiPage($Data, 10); $this->Data = $Data; } }
function GetCompany() { $company = $this->_GET['string']; if ($company == '') { exit; } $CustomersModule = new CustomersModule(); $CustProModule = new CustProModule(); $MysqlWhere = " where CompanyName like '%{$company}%' and AgentID='{$_SESSION['AgentID']}'"; $CompanysList = $CustomersModule->GetLists($MysqlWhere, 0, 10); //获取G宝盆 项目id $ProjectId = TONGYI_ID; foreach ($CompanysList as $k => $v) { $where = "where CustomersID={$v['CustomersID']} and ProjectID={$ProjectId}"; $CustomList = $CustProModule->GetInfoByWhere($where); if (empty($CustomList)) { $list .= '<li>' . $v['CompanyName'] . '</li>'; } } echo $list; exit; }
public function Customer() { $this->MyAction = 'Customer'; $MysqlWhere = ' where AgentID=' . $_SESSION['AgentID']; $Page = intval($this->_GET['Page']); $Page = $Page ? $Page : 1; $FengxinID = $this->GetProjectID('风信'); $GbaopenID = $this->GetProjectID('聚宝盆'); $CustProModule = new CustProModule(); $CustomersModule = new CustomersModule(); $Searchtxt = $this->_POST['searchtxt']; if ($Searchtxt != '') { $MysqlWhere .= " and (CompanyName like '%{$Searchtxt}%' or CustomersName like '%{$Searchtxt}%')"; } $ListsNum = $CustomersModule->GetListsNum($MysqlWhere); $Rscount = $ListsNum['Num']; $PageSize = 20; 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'] = $CustomersModule->GetLists($MysqlWhere, $Offset, $Data['PageSize']); foreach ($Data['Data'] as $k => $v) { $where = "where ProjectID='{$FengxinID}' and AgentID={$_SESSION['AgentID']} and CustomersID={$v['CustomersID']}"; $IsFengxin = $CustProModule->GetInfoByWhere($where); if (!empty($IsFengxin)) { $Data['fengxin'][$v['CustomersID']] = 1; $Data['Data'][$k]['status'] = $IsFengxin['status']; } $where = "where ProjectID='{$GbaopenID}' and AgentID={$_SESSION['AgentID']} and CustomersID={$v['CustomersID']}"; $IsGbaopen = $CustProModule->GetInfoByWhere($where); if (!empty($IsGbaopen)) { $Data['gbaopen'][$v['CustomersID']] = 1; $Data['Data'][$k]['status'] = $IsGbaopen['status']; } } MultiPage($Data, 20); $this->Data = $Data; } }