public function indexAction() { //检查权限 $PermissionCheck = $this->manager->checkMenuPermission(0); if ($PermissionCheck['return']) { $SexList = $this->oUser->getSexList(); $AuthStatusList = $this->oUser->getAuthStatus(); $AuthIdTypesList = $this->oUser->getAuthIdType(); $params['Sex'] = isset($SexList[strtoupper(trim($this->request->Sex))]) ? substr(strtoupper(trim($this->request->Sex)), 0, 8) : ""; $params['Name'] = urldecode(trim($this->request->Name)) ? substr(urldecode(trim($this->request->Name)), 0, 8) : ""; $params['NickName'] = urldecode(trim($this->request->NickName)) ? substr(urldecode(trim($this->request->NickName)), 0, 8) : ""; $params['AuthStatus'] = isset($AuthStatusList[strtoupper(trim($this->request->AuthStatus))]) ? substr(strtoupper(trim($this->request->AuthStatus)), 0, 8) : ""; $params['Page'] = abs(intval($this->request->Page)) ? abs(intval($this->request->Page)) : 1; $params['PageSize'] = 5; $params['getCount'] = 1; $UserList = $this->oUser->getUserLst($params); //导出EXCEL链接 $export_var = "<a href =" . Base_Common::getUrl('', 'xrace/user', 'user.list.download', $params) . "><导出表格></a>"; //翻页参数 $page_url = Base_Common::getUrl('', 'xrace/user', 'index', $params) . "&Page=~page~"; $page_content = base_common::multi($UserList['UserCount'], $page_url, $params['Page'], $params['PageSize'], 10, $maxpage = 100, $prevWord = '上一页', $nextWord = '下一页'); foreach ($UserList['UserList'] as $UserId => $UserInfo) { echo $UserInfo['auth_state'] . "<br>"; $UserList['UserList'][$UserId]['sex'] = isset($SexList[$UserInfo['sex']]) ? $SexList[$UserInfo['sex']] : "保密"; $UserList['UserList'][$UserId]['AuthStatus'] = isset($AuthStatusList[$UserInfo['auth_state']]) ? $AuthStatusList[$UserInfo['auth_state']] : "未知"; $UserList['UserList'][$UserId]['AuthStatus'] = $UserInfo['auth_state'] == "AUTHED" && isset($AuthIdTypesList[strtoupper(trim($UserInfo['id_type']))]) ? $UserList['UserList'][$UserId]['AuthStatus'] . "/" . $AuthIdTypesList[strtoupper(trim($UserInfo['id_type']))] : $UserList['UserList'][$UserId]['AuthStatus']; $UserList['UserList'][$UserId]['Birthday'] = is_null($UserInfo['birth_day']) ? "未知" : $UserInfo['birth_day']; } include $this->tpl('Xrace_User_UserList'); } else { $home = $this->sign; include $this->tpl('403'); } }
public function sendUserResetPasswordMail($UserId, $UserMail) { $this->db->begin(); $UserInfo = $this->GetUserById($UserId); $AsignResetTime = time(); $ResetPasswordLog = array('UserId' => $UserId, 'PartnerId' => $UserInfo['PartnerId'], 'AsignResetTime' => $AsignResetTime, 'ResetStatus' => 0, 'ResetType' => 1); $ResetLog = $this->createResetPassword($ResetPasswordLog); if ($ResetLog) { $User = array('UserId' => $UserId, 'PartnerId' => $UserInfo['PartnerId'], 'EndTime' => $AsignResetTime + 86400, 'UserMail' => $UserMail, 'ResetId' => $ResetLog); $User['sign'] = base_common::check_sign($User, "resetpassword"); $ResetUrl = $this->config->passporturl . Base_Common::getUrl('', '', '', $User) . "&c=forgot_password&m=reset_by_email"; $UrlList = array('ResetUrl' => array('href' => $ResetUrl, 'txt' => $ResetUrl)); $MailContent = array('UserMail' => $UserMail, 'UserName' => $UserInfo['UserName'], 'UrlList' => $UrlList, 'title' => "用户密码找回"); $MailType = "ResetPassWord"; $oMail = new Lm_Mail(); $mail = $oMail->createMail($MailType, $UserId, $MailContent); if ($mail) { $this->db->commit(); return $ResetLog; } else { $this->db->rollBack(); return false; } } else { $this->db->rollBack(); return false; } }
public function authLogAction() { //检查权限 $PermissionCheck = $this->manager->checkMenuPermission(0); if ($PermissionCheck['return']) { //页面参数预处理 $params['StartDate'] = isset($this->request->StartDate) ? substr(strtoupper(trim($this->request->StartDate)), 0, 10) : date("Y-m-d", time()); $params['EndDate'] = isset($this->request->EndDate) ? substr(strtoupper(trim($this->request->EndDate)), 0, 10) : date("Y-m-d", time()); $params['AuthResult'] = isset($this->request->AuthResult) ? substr(strtoupper(trim($this->request->AuthResult)), 0, 8) : ""; $params['ManagerId'] = isset($this->request->ManagerId) ? intval($this->request->ManagerId) : 0; //分页参数 $params['Page'] = abs(intval($this->request->Page)) ? abs(intval($this->request->Page)) : 1; $params['PageSize'] = 2; //获取用户列表时需要获得记录总数 $params['getCount'] = 1; //获取实名认证记录的状态列表 $AuthLogIdStatusList = $this->oUser->getAuthLogStatusTypeList(); //获取所有管理员列表 $ManagerList = $this->manager->getAll('id,name'); //获取实名认证记录 $AuthLog = $this->oUser->getAuthLog($params); //导出EXCEL链接 $export_var = "<a href =" . Base_Common::getUrl('', 'xrace/user', 'auth.log.download', $params) . "><导出表格></a>"; //翻页参数 $page_url = Base_Common::getUrl('', 'xrace/user', 'auth.log', $params) . "&Page=~page~"; $page_content = base_common::multi($AuthLog['AuthLogCount'], $page_url, $params['Page'], $params['PageSize'], 10, $maxpage = 100, $prevWord = '上一页', $nextWord = '下一页'); //初始化一个空的用户数组 $UserList = array(); foreach ($AuthLog['AuthLog'] as $AuthId => $LogInfo) { //管理员账号 $AuthLog['AuthLog'][$AuthId]['ManagerName'] = isset($ManagerList[$LogInfo['op_uid']]) ? $ManagerList[$LogInfo['op_uid']]['name'] : "未知"; $AuthLog['AuthLog'][$AuthId]['AuthResultName'] = isset($AuthLogIdStatusList[$LogInfo['auth_result']]) ? $AuthLogIdStatusList[$LogInfo['auth_result']] : "未知"; // 如果管理员记录已经获取到 if (isset($UserList[$LogInfo['user_id']])) { $ManagerInfo = $UserList[$LogInfo['user_id']]; } else { $ManagerInfo = $this->oUser->getUserInfo($LogInfo['user_id'], "name"); } $AuthLog['AuthLog'][$AuthId]['UserName'] = $ManagerInfo['name']; //实名认证提交的照片 $AuthLog['AuthLog'][$AuthId]['submit_img1'] = isset($AuthLog['AuthLog'][$AuthId]['submit_img1']) ? urldecode($AuthLog['AuthLog'][$AuthId]['submit_img1']) : ""; $AuthLog['AuthLog'][$AuthId]['submit_img2'] = isset($AuthLog['AuthLog'][$AuthId]['submit_img2']) ? urldecode($AuthLog['AuthLog'][$AuthId]['submit_img2']) : ""; } //模板渲染 include $this->tpl('Xrace_User_AuthLog'); } else { $home = $this->sign; include $this->tpl('403'); } }
public function indexAction() { //检查权限 $PermissionCheck = $this->manager->checkMenuPermission(0); if ($PermissionCheck['return']) { $RootUrl = "http://" . $_SERVER['HTTP_HOST']; //赛事ID $RaceCatalogId = isset($this->request->RaceCatalogId) ? intval($this->request->RaceCatalogId) : 0; //赛事列表 $RaceCatalogArr = $this->oRace->getAllRaceCatalogList(); //赛事分站列表 $RaceStageArr = $this->oRace->getAllRaceStageList($RaceCatalogId); //赛事分组列表 $RaceGroupArr = $this->oRace->getAllRaceGroupList($RaceCatalogId, 'RaceGroupId,RaceGroupName'); //初始化一个空的赛事分站列表 $RaceStageList = array(); //循环赛事分站列表 foreach ($RaceStageArr as $key => $value) { $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key] = $value; //计算分站数量,用于页面跨行显示 $RaceStageList[$value['RaceCatalogId']]['RaceStageCount'] = isset($RaceStageList[$value['RaceCatalogId']]['RaceStageCount']) ? $RaceStageList[$value['RaceCatalogId']]['RaceStageCount'] + 1 : 1; $RaceStageList[$value['RaceCatalogId']]['RowCount'] = $RaceStageList[$value['RaceCatalogId']]['RaceStageCount'] + 1; //如果相关赛事ID有效 if (isset($RaceCatalogArr[$value['RaceCatalogId']])) { //获取赛事ID $RaceStageList[$value['RaceCatalogId']]['RaceCatalogName'] = isset($RaceStageList[$value['RaceCatalogId']]['RaceCatalogName']) ? $RaceStageList[$value['RaceCatalogId']]['RaceCatalogName'] : $RaceCatalogArr[$value['RaceCatalogId']]['RaceCatalogName']; //解包压缩数组 $value['comment'] = json_decode($value['comment'], true); $t = array(); //如果有已经选择的赛事组别 if (isset($value['comment']['SelectedRaceGroup']) && is_array($value['comment']['SelectedRaceGroup'])) { //循环各个组别 foreach ($value['comment']['SelectedRaceGroup'] as $k => $v) { //获取各个组别的比赛场次数量 $RaceCount = $this->oRace->getRaceCount($value['RaceStageId'], $v); //如果有配置比赛场次 if ($RaceCount > 0) { //添加场次数量 $Suffix = "(" . $RaceCount . ")"; } else { $Suffix = ""; } //如果赛事组别配置有效 if (isset($RaceGroupArr[$v])) { //生成到比赛详情页面的链接 $t[$k] = "<a href='" . Base_Common::getUrl('', 'xrace/race.stage', 'race.list', array('RaceStageId' => $value['RaceStageId'], 'RaceGroupId' => $v)) . "'>" . $RaceGroupArr[$v]['RaceGroupName'] . $Suffix . "</a>"; } } } //如果检查后有至少一个有效的赛事组别配置 if (count($t)) { //生成页面显示的数组 $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['SelectedGroupList'] = implode("/", $t); $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['GroupCount'] = count($t); $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['RowCount'] = $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['GroupCount'] + 1; } else { //生成默认的入口 $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['SelectedGroupList'] = "<a href='" . Base_Common::getUrl('', 'xrace/race.stage', 'race.list', array('RaceStageId' => $key)) . "'>尚未配置</a>"; $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['GroupCount'] = 0; $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['RowCount'] = 1; } } else { $RaceStageList[$value['RaceCatalogId']]['RaceCatalogName'] = "未定义"; } if (isset($value['comment']['RaceStageIconList']) && is_array($value['comment']['RaceStageIconList'])) { foreach ($value['comment']['RaceStageIconList'] as $k => $v) { $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['RaceStageIconList'] .= "<a href='" . $RootUrl . $v['RaceStageIcon_root'] . "' target='_blank'>图标" . $k . "</a>/"; } $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['RaceStageIconList'] = rtrim($RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['RaceStageIconList'], "/"); } else { $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['RaceStageIconList'] = '未上传'; } $RaceStageList[$value['RaceCatalogId']]['RaceStageList'][$key]['RaceStageStatus'] = $this->oRace->getRaceStageTimeStatus($key, 0); } //渲染模板 include $this->tpl('Xrace_Race_RaceStageList'); } else { $home = $this->sign; include $this->tpl('403'); } }
public function raceStageGroupSportsTypeAddAction() { //检查权限 $PermissionCheck = $this->manager->checkMenuPermission("RaceStageModify"); if ($PermissionCheck['return']) { $RaceStageId = intval($this->request->RaceStageId); $RaceGroupId = intval($this->request->RaceGroupId); $SportsTypeId = intval($this->request->SportsTypeId); $After = isset($this->request->After) ? intval($this->request->After) : 0; echo "After:" . $After; //获取当前分站信息 $oRaceStage = $this->oRace->getRaceStage($RaceStageId, '*'); //解包压缩数组 $oRaceStage['comment'] = json_decode($oRaceStage['comment'], true); //如果当前分站未配置了当前分组 if (!isset($oRaceStage['comment']['SelectedRaceGroup'][$RaceGroupId])) { //跳转到分站列表页面 $this->response->redirect($this->sign); } //获取赛事分组信息 $oRaceGroup = $this->oRace->getRaceGroup($RaceGroupId, '*'); //如果赛事分组尚未配置 if (!$oRaceGroup['RaceGroupId']) { //跳转到分站列表页面 $this->response->redirect($this->sign); } $this->oSports = new Xrace_Sports(); $oSportsType = $this->oSports->getSportsType($SportsTypeId, '*'); if (!isset($oSportsType['SportsTypeId'])) { $url = Base_Common::getUrl('', 'xrace/race.stage', 'race.stage.group.detail', array('RaceStageId' => $RaceStageId, 'RaceGroupId' => $RaceGroupId)); $this->response->redirect($url); } //获取分站分组配置详情 $RaceStageGroupInfo = $this->oRace->getRaceStageGroup($RaceStageId, $RaceGroupId); //默认开始时间 $StartTime = date("Y-m-d H:i:s", time() + 86400); //默认结束时间 $EndTime = date("Y-m-d H:i:s", time() + 86400 * 2); //如果尚未配置分站分组详情,则用默认空数组替代 if (!is_array($RaceStageGroupInfo)) { $RaceStageGroupInfo = array('PriceList' => 0, 'SingleUser' => 1, 'TeamUser' => 1, 'StartTime' => $StartTime, 'EndTime' => $EndTime, 'comment' => ""); $NewDetail = 1; } $RaceStageGroupInfo['comment'] = json_decode($RaceStageGroupInfo['comment'], true); $RaceStageGroupInfo['comment']['DetailList'] = isset($RaceStageGroupInfo['comment']['DetailList']) ? $RaceStageGroupInfo['comment']['DetailList'] : array(); ksort($RaceStageGroupInfo['comment']['DetailList']); //如果添加在某个元素之后 且 元素下标不越界 if ($After >= 0 && $After < count(count($RaceStageGroupInfo['comment']['DetailList']))) { //添加元素 $RaceStageGroupInfo['comment']['DetailList'] = Base_Common::array_insert($RaceStageGroupInfo['comment']['DetailList'], array('SportsTypeId' => $SportsTypeId), $After + 1); } else { //默认为在表尾部添加元素 $RaceStageGroupInfo['comment']['DetailList'][count($RaceStageGroupInfo['comment']['DetailList'])] = array('SportsTypeId' => $SportsTypeId); } //生成修改后的元素列表 $RaceStageGroupInfo['RaceStageId'] = $RaceStageId; $RaceStageGroupInfo['RaceGroupId'] = $RaceGroupId; $RaceStageGroupInfo['comment'] = json_encode($RaceStageGroupInfo['comment']); //如果认为需要新建数据 if (isset($NewDetail)) { //插入新的数据 $res = $this->oRace->insertRaceStageGroup($RaceStageGroupInfo); } else { //更新数据 $res = $this->oRace->updateRaceStageGroup($RaceStageId, $RaceGroupId, $RaceStageGroupInfo); } $url = Base_Common::getUrl('', 'xrace/race.stage', 'race.stage.group.detail', array('RaceStageId' => $RaceStageId, 'RaceGroupId' => $RaceGroupId)); $this->response->redirect($url); } else { $home = $this->sign; include $this->tpl('403'); } }
public function detailAction() { //检查权限 $this->manager->checkMenuPermission($this->sign, Widget_Manager::MENU_PURVIEW_UPDATE); $SourceProjectId = intval($this->request->SourceProjectId); $SourceProject = $this->oSourceProject->getRow($SourceProjectId, '*'); $SourceProjectDetail = $this->oSourceProject->getDetail($SourceProjectId); $SourceList = $this->oSource->getAll(); $SourceDetailList = $this->oSourceDetail->getAll(0); //下载参数 $export = $this->request->export ? intval($this->request->export) : 0; $links = 'http://passport.wjyx.com/?c=media&PageId=2'; foreach ($SourceProjectDetail as $key => $value) { $SourceProjectDetail[$key]['SourceName'] = $SourceList[$value['SourceId']]['name']; $SourceProjectDetail[$key]['SourceDetailName'] = $value['SourceDetail'] ? $SourceDetailList[$value['SourceDetail']]['name'] : "<font color = 'red'>全部</font>"; $SourceProjectDetail[$key]['SourceUrl'] = $links . "&UserSourceId=" . $value['SourceId'] . "&UserSourceDetail=" . $value['SourceDetail'] . "&UserSourceProjectId=" . $value['SourceProjectId']; //$SourceProjectDetail[$key]['SourceUrl'] = "&UserSourceId=".$value['SourceId']."UserSourceDetail".$value['SourceDetail']."UserSourceProjectId".$value['SourceProjectId']; // $SourceProjectDetail[$key]['SourceUrl'] = Base_Common::my_authcode($SourceProjectDetail[$key]['SourceUrl'],'','limaogame'); } $param['SourceProjectId'] = $SourceProjectId; $execlParam = $param + array("export" => 1); $export_var = "<a href =" . Base_Common::getUrl('', 'config/source/project', 'detail', $execlParam) . "><导出表格></a>"; if ($export == 1) { $oExcel = new Third_Excel(); $FileName = '广告位列表--' . $SourceProject['name']; //标题栏 $title = array("广告商", "广告位", "连接参数"); $oExcel->download($FileName)->addSheet('广告位列表'); $oExcel->addRows(array($title)); foreach ($SourceProjectDetail as $key => $sourceproject_detail) { //生成单行数据 $t['SourceName'] = $sourceproject_detail['SourceName']; $t['SourceDetailName'] = $sourceproject_detail['SourceDetailName']; $t['SourceUrl'] = $sourceproject_detail['SourceUrl']; $oExcel->addRows(array($t)); unset($t); } //结束excel $oExcel->closeSheet()->close(); } include $this->tpl('Config_Source_Project_Detail_list'); }
public function machineMapAction() { $sign = "?ctl=config/depot&ac=machine.map"; $this->manager->checkMenuPermission($this->sign, Widget_Manager::MENU_PURVIEW_SELECT); $export = $this->request->export ? intval($this->request->export) : 0; $DepotParame['export'] = 1; $DepotList = $this->oDepot->getAll(); //用于设置默认的页面参数 $DepotIdStr = Base_Common::getArrList($DepotList); $DepotArr = explode(",", $DepotIdStr); //页面参数 $DepotId = $this->request->DepotId ? $this->request->DepotId : $DepotArr[0]; $DepotX = $this->request->X; $DepotXList = $this->getDepotX($DepotId); $DepotName = $DepotList[$DepotId]['name']; if ($DepotId && $DepotX) { $DepotParame['DepotId'] = $DepotId; $DepotParame['X'] = $DepotX; $CageList = $this->oCage->getCageListParams($DepotId, $DepotX); $MachineFields = "MachineId,MachineCode,EstateCode,Position,Size,LocalIP,WebIP,Purpose,Flag"; foreach ($CageList as $CageId => $CageInfo) { $MachineList = $this->oMachine->getMachineByCageId($CageId, $MachineFields); $SizeList = array(); for ($i = 1; $i <= $CageInfo["Size"]; $i++) { $SizeList[$i] = 0; } foreach ($MachineList as $key => $MachineInfo) { $MachineInfo['LocalIP'] = long2ip($MachineInfo['LocalIP']); $MachineInfo['WebIP'] = long2ip($MachineInfo['WebIP']); $SizeList[$MachineInfo['Position']] = $MachineInfo; for ($i = $MachineInfo['Position']; $i <= $MachineInfo['Position'] + $MachineInfo['Size'] - 1; $i++) { if ($i > $MachineInfo['Position']) { unset($SizeList[$i]); } } ksort($SizeList); $CageList[$CageId]['SizeList'] = $SizeList; } } } $imgPath = __APP_ROOT_DIR__ . "admin/html/img/machine/"; //导出表格 $export_var = "<a href =" . Base_Common::getUrl('', 'config/depot', 'machine.map', $DepotParame) . "><导出表格></a>"; if ($export == 1) { /*header("Content-type:application/vnd.ms-excel;charset=UTF-8"); header("Content-Disposition:attachment;filename=test_data.xls"); foreach($CageList as $CageId=> $CageInfo) { echo "<table>"; echo "<tr><td>编号:{$CageInfo['CageCode']}</td></tr>"; echo "<tr><td>电量:{$CageInfo['Current']}A</td></tr>"; echo "<tr><td>实际电量:{$CageInfo['ActualCurrent']}A</td></tr>"; foreach($CageInfo['SizeList'] as $k=> $v) { if($v == 0) { echo "<tr><td></td></tr>"; }else{ if($v['Flag']==1) { echo "<tr><td><img title='内网IP:".$v['LocalIP']." 外网IP:".$v['WebIP']."' src='{$imgPath}server/server".$v['Size'].".png' style='height:".($v['Size']*15)."px' /></td></tr>"; }elseif($v['Flag']==2)//交换机 { echo "<tr><td><img title='内网IP:".$v['MachineCode']."外网IP:".$v['WebIP']."' src='{$imgPath}exchange/exchange".$v['Size'].".png' style='height:".($v['Size']*15)."px' /></td></tr>"; }elseif($v['Flag']==3)//防火墙 { echo "<tr><td><img title='内网IP:".$v['MachineCode']."外网IP:".$v['WebIP']."' src='{$imgPath}router/router".$v['Size'].".png' style='height:".($v['Size']*15)."px' /></td></tr>"; }elseif($v['Flag']==4)//路由器 { echo "<tr><td><img title='内网IP:".$v['MachineCode']."外网IP:".$v['WebIP']."' src='{$imgPath}router/router".$v['Size'].".png' style='height:".($v['Size']*15)."px' /></td></tr>"; } } } echo "</table>"; }*/ /*$FileName='机器列表图'; $oExcel = new Third_Excel(); $oExcel->download($FileName)->addSheet('机器列表图'); include $this->tpl('Config_Depot_MapList3');lll $oExcel->closeSheet()->close(); */ header("Content-type:application/vnd.ms-excel;charset=UTF-8"); header("Content-Disposition:attachment;filename=MachineMap.xls"); include $this->tpl('Config_Depot_MapExecl'); } else { include $this->tpl('Config_Depot_MapList'); } }
public function ipListAction() { //检查当前页面权限 $sign = '?ctl=config/machine&ac=ip.list'; $this->manager->checkMenuPermission($sign, Widget_Manager::MENU_PURVIEW_SELECT); $CageList = $this->CageList; $DepotId = $this->request->DepotId; $export = $this->request->export ? intval($this->request->export) : 0; $page = $this->request->page ? intval($this->request->page) : 1; $pageSize = $export ? 0 : 20; $DepotList = $this->DepotList; $ServerList = $this->ServerList; $PartnerList = $this->PartnerList; $param = array(); if ($DepotId) { $param['DepotId'] = $DepotId; $CageIdList = Base_Common::getArrList($CageList[$DepotId]); } $MachineList = $this->oMachine->getIpList($CageIdList, ($page - 1) * $pageSize, $pageSize); $MachineArr = $MachineList['MachineDetail']; foreach ($MachineArr as $MachineId => &$MachineInfo) { $MachineInfo['PartnerName'] = $PartnerList[$ServerList[$MachineInfo['ServerId']]['PartnerId']]['name']; $MachineInfo['LocalIP'] = long2ip($MachineInfo['LocalIP']); $MachineInfo['WebIP'] = long2ip($MachineInfo['WebIP']); $MachineInfo['Purpose'] = $MachineInfo['Purpose']; } //翻页 $pageParam = $param + array("export" => 0); $page_url = Base_Common::getUrl('', 'config/machine', 'ip.list', $pageParam) . "&page=~page~"; $page_content = base_common::multi($MachineList['MachineCount'], $page_url, $page, $pagesize, 10, $maxpage = 100, $prevWord = '上一页', $nextWord = '下一页'); //表格导出 $execlParam = $param + array("export" => 1); $export_var = "<a href =" . Base_Common::getUrl('', 'config/machine', 'ip.list', $execlParam) . "><导出表格></a>"; if ($export == 1) { $oExcel = new Third_Excel(); $FileName = 'IP地址信息'; $oExcel->download($FileName)->addSheet('IP地址信息'); //标题栏 $title = array("序列号", "资产编号", "内网IP", "外网IP", "项目", "用途"); $oExcel->addRows(array($title)); foreach ($MachineArr as $MachineCode => $MachineInfot) { //生成单行数据 $t = array(); $t['MachineCode'] = $MachineInfot['MachineCode']; $t['EstateCode'] = $MachineInfot['EstateCode']; $t['LocalIP'] = $MachineInfot['LocalIP']; $t['WebIP'] = $MachineInfot['WebIP']; $t['PartnerName'] = $MachineInfot['PartnerName']; $t['Purpose'] = $MachineInfot['Purpose']; $oExcel->addRows(array($t)); unset($t); } $oExcel->closeSheet()->close(); } include $this->tpl('Config_Machine_ipList'); }
public function genPackCodeLogAction() { set_time_limit(0); $pagesize = 10; //检查当前页面权限 $sign = '?ctl=config/product/pack&ac=gen.pack.code.log'; $this->manager->checkMenuPermission($sign, Widget_Manager::MENU_PURVIEW_SELECT); //页面输入变量 $AppId = intval($this->request->AppId); $PartnerId = intval($this->request->PartnerId); $GenNum = intval($this->request->GenNum) ? intval($this->request->GenNum) : 100; $AreaId = $this->request->AreaId ? intval($this->request->AreaId) : 0; $app_type = $this->request->app_type ? intval($this->request->app_type) : 0; $partner_type = $this->request->partner_type ? intval($this->request->partner_type) : 0; $is_abroad = $this->request->is_abroad ? intval($this->request->is_abroad) : 0; $page = intval(max($this->request->page, 1)); //时间范围初始化 $StartDate = $this->request->StartDate ? $this->request->StartDate : date("Y-m-01", time()); $EndDate = $this->request->EndDate ? $this->request->EndDate : date("Y-m-d", time()); $ProductPackArr = $this->oProductPack->getAll($AppId); $ProductPackId = $this->request->ProductPackId ? intval($this->request->ProductPackId) : 0; //初始化图表配置 $Input = array('AppId' => $AppId, 'PartnerId' => $PartnerId, 'is_abroad' => $is_abroad, 'AreaId' => $AreaId, 'app_type' => $app_type, 'partner_type' => $partner_type, 'ProductPackId' => $ProductPackId, 'export' => 1); //初始化游戏列表 $permitted_app = $this->permitted_app; //初始化合作商列表 $permitted_partner = array(); //初始化服务器列表 $permitted_server = array(); $AreaList = $this->AreaList; //获取当前地区列表 $AreaList = $this->oArea->getAbroad($is_abroad, $AreaList); //生成允许的地区id数组 if ($app_type > 0) { //筛选是否平台产品 $permitted_app = $this->oApp->getApp($app_type, $permitted_app); } if ($AppId > 0) { //获取可查看的权限总表 $permitted_partner = $this->oPermission->getPartner($this->manager->data_groups, $AppId, 'PartnerId,name,AreaId'); //根据合作方式筛选 $permitted_partner = $this->oPartnerApp->getPermittedPartnerByPartnerType($partner_type, $permitted_partner); //根据所在地区筛选 $permitted_partner = $this->oPartnerApp->getPermittedPartnerByPartnerArea($AreaList, $permitted_partner); } //获取用于查询的权限sql语句 $oWherePartnerPermission = $this->oPermission->getWherePermittedPartner($this->manager->data_groups, $AppId, $PartnerId, $app_type, $partner_type, $AreaList, $AreaId, $is_abroad, ''); $GenLog = $this->oProductPack->getGenLog(0, 0, $ProductPackId, 0, $oWherePartnerPermission, ($page - 1) * $pagesize, $pagesize); $page_url = Base_Common::getUrl('', 'config/product/pack', 'gen.pack.code.log', $Input) . "&page=~page~"; $page_content = base_common::multi($GenLog['GenLogCount'], $page_url, $page, $pagesize, 10, $maxpage = 100, $prevWord = '上一页', $nextWord = '下一页'); if (count($GenLog['GenLog'])) { foreach ($GenLog['GenLog'] as $GenId => $GenInfo) { $GenLog['GenLog'][$GenId]['AppName'] = $permitted_app[$GenInfo['AppId']]['name']; if (!isset($PartnerInfo[$GenInfo['PartnerId']])) { $PartnerInfo[$GenInfo['PartnerId']] = $this->oPartner->getRow($GenInfo['PartnerId']); } if (!isset($ManagerInfo[$GenInfo['ManagerId']])) { $ManagerInfo[$GenInfo['ManagerId']] = $this->manager->getRow($GenInfo['ManagerId']); } $GenLog['GenLog'][$GenId]['PartnerName'] = $PartnerInfo[$GenInfo['PartnerId']]['name']; $GenLog['GenLog'][$GenId]['ManagerName'] = $ManagerInfo[$GenInfo['ManagerId']]['name']; if (!isset($ProductPackList[$GenInfo['ProductPackId']])) { $ProductPackList[$GenInfo['ProductPackId']] = $this->oProductPack->getRow($GenInfo['ProductPackId']); $Comment = json_decode($ProductPackList[$GenInfo['ProductPackId']]['Comment'], true); if (is_array($Comment)) { unset($ProductList); unset($TypeList); unset($ProductInfo); foreach ($Comment as $Type => $TypeInfo) { foreach ($TypeInfo as $ProductId => $Count) { if (!isset($ProductInfo[$Type][$AppId][$ProductId])) { if ($Type == "hero") { $ProductInfo[$Type][$AppId][$ProductId] = $this->oHero->getRow($ProductId, $AppId, '*'); } elseif ($Type == "skin") { $ProductInfo[$Type][$AppId][$ProductId] = $this->oSkin->getRow($ProductId, $AppId, '*'); } elseif ($Type == "product") { $ProductInfo[$Type][$AppId][$ProductId] = $this->oProduct->getRow($ProductId, $AppId, '*'); } elseif ($Type == "money") { $ProductInfo[$Type][$AppId][$ProductId] = $this->oMoney->getRow($ProductId, $AppId, '*'); } elseif ($Type == "appcoin") { $AppInfo = $this->oApp->getRow($AppId); $Comment = json_decode($AppInfo['comment'], true); $ProductInfo[$Type][$AppId][$ProductId]['name'] = $Comment['coin_name']; } } $ProductList[$Type]['detail'][$ProductId] = $ProductInfo[$Type][$AppId][$ProductId]['name'] . "*" . $Count . "个"; } $TypeList[$Type] = implode(",", $ProductList[$Type]['detail']); } $ProductPackArr[$AppId][$GenInfo['ProductPackId']]['ProductListText'] = implode(",", $TypeList); } else { $ProductPackArr[$AppId][$GenInfo['ProductPackId']]['ProductListText'] = "无道具"; } } $GenLog['GenLog'][$GenId]['PackName'] = $ProductPackList[$GenInfo['ProductPackId']]['name']; $GenLog['GenLog'][$GenId]['ProductListText'] = $ProductPackArr[$GenInfo['AppId']][$GenInfo['ProductPackId']]['ProductListText']; $GenLog['GenLog'][$GenId]['ExportUrl'] = "<a href =" . Base_Common::getUrl('', 'config/product/pack', 'download.pack.code', array('export' => 1, 'GenId' => $GenId)) . "><导出礼包码></a>"; } } $page_title = "礼包码生成记录"; $page_form_action = $sign; //调取模板 include $this->tpl('Config_Product_Pack_GenLog'); }
public function productQueueSendDetailAction() { $oArea = new Config_Area(); $oPartnerApp = new Config_Partner_App(); $oServer = new Config_Server(); $oPermission = new Config_Permission(); $oUser = new Lm_User(); $ProductSendTypeArr = $this->config->ProductSendTypeArr; $ProductTypeArr = $this->config->ProductTypeArr; //获取用户可以查看的游戏列表 $permitted_app = $oPermission->getApp($this->manager->data_groups, 'AppId,name'); $AreaList = $oArea->getAll(); set_time_limit(0); $page = intval(max($this->request->page, 1)); //检查当前页面权限 $sign = '?ctl=config/product/product&ac=product.queue.send.detail'; $this->manager->checkMenuPermission($sign, Widget_Manager::MENU_PURVIEW_SELECT); //页面输入变量 $AppId = intval($this->request->AppId); $PartnerId = intval($this->request->PartnerId); $PassageId = intval($this->request->PassageId); $AreaId = intval($this->request->AreaId) ? intval($this->request->AreaId) : 0; $UserName = $this->request->UserName; $app_type = intval($this->request->app_type); $partner_type = intval($this->request->partner_type); $is_abroad = intval($this->request->is_abroad) ? intval($this->request->is_abroad) : 0; //页面输入变量 $ProductSendType = $this->request->ProductSendType; $ProductType = $this->request->ProductType; //是否导出当前页面表格 $export = $this->request->export ? intval($this->request->export) : 0; $pagesize = $export ? 0 : 20; //初始化图表配置 $Input = array('UserName' => urlencode($UserName), 'AppId' => $AppId, 'PartnerId' => $PartnerId, 'ServerId' => $ServerId, 'ProductSendType' => $ProductSendType, 'export' => 1); $export_var = "<a href =" . Base_Common::getUrl('', 'config/product/product', 'product.queue.send.detail', $Input) . "><导出表格></a>"; //初始化合作商列表 $permitted_partner = array(); //获取当前地区列表 $AreaList = $oArea->getAbroad($is_abroad, $AreaList); //生成允许的地区id数组 if ($app_type > 0) { //筛选是否平台产品 $permitted_app = $this->oApp->getApp($app_type, $permitted_app); } if ($AppId > 0) { //获取可查看的权限总表 $permitted_partner = $oPermission->getPartner($this->manager->data_groups, $AppId, 'PartnerId,name,AreaId'); //根据合作方式筛选 $permitted_partner = $oPartnerApp->getPermittedPartnerByPartnerType($partner_type, $permitted_partner); //根据所在地区筛选 $permitted_partner = $oPartnerApp->getPermittedPartnerByPartnerArea($AreaList, $permitted_partner); if ($PartnerId > 0) { //获取服务器列表 $permitted_server = $oPermission->getServer($this->manager->data_groups, $AppId, $PartnerId, 'ServerId,name'); } } if ($UserName) { $UserInfo = $oUser->getUserByName($UserName); if ($UserInfo['UserId']) { $UserId = $UserInfo['UserId']; } else { $UserId = -1; } } else { $UserId = 0; } $ProductSendQueueDetailArr = $this->oProduct->getProductSendQueueDetail($UserId, $ProductSendType, $ProductType, $ServerId, ($page - 1) * $pagesize, $pagesize); $UserInfoList = array(); if (is_array($ProductSendQueueDetailArr['ProductSendQueueDetail'])) { foreach ($ProductSendQueueDetailArr['ProductSendQueueDetail'] as $key => $value) { if ($value['UserId']) { if (!isset($UserInfoList[$value['UserId']])) { $UserInfo = $oUser->getUserById($value['UserId']); $UserInfoList[$value['UserId']] = $UserInfo; } } if (!isset($ServerInfo[$value['ServerId']])) { $ServerInfo[$value['ServerId']] = $oServer->getRow($value['ServerId']); } $Comment = json_decode($value['Comment'], true); $ProductSendQueueDetailArr['ProductSendQueueDetail'][$key]['UserName'] = $value['UserId'] ? $UserInfoList[$value['UserId']]['UserName'] : "******"; $ProductSendQueueDetailArr['ProductSendQueueDetail'][$key]['ProductSendTypeName'] = $ProductSendTypeArr[$value['SendType']]; $ProductSendQueueDetailArr['ProductSendQueueDetail'][$key]['ProductTypeName'] = $ProductTypeArr[$value['ProductType']]; $ProductSendQueueDetailArr['ProductSendQueueDetail'][$key]['ServerName'] = $ServerInfo[$value['ServerId']]['name']; } } $page_title = "道具发送队列详情"; $page_form_action = $sign; //调取模板 include $this->tpl('Config_Product_ProductSendQueueDetail'); }