public function userListDownloadAction()
{
//检查权限
$PermissionCheck = $this->manager->checkMenuPermission("UserListDownload");
if ($PermissionCheck['return']) {
$SexList = $this->oUser->getSexList();
$AuthStatusList = $this->oUser->getAuthStatus();
$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['PageSize'] = 500;
$oExcel = new Third_Excel();
$FileName = $this->manager->name() . '用户列表';
$oExcel->download($FileName)->addSheet('用户');
//标题栏
$title = array("用户ID", "微信openId", "姓名", "昵称", "性别", "出生年月", "实名认证状态");
$oExcel->addRows(array($title));
$Count = 1;
$params['Page'] = 1;
do {
$UserList = $this->oUser->getUserLst($params);
$Count = count($UserList['UserList']);
foreach ($UserList['UserList'] as $UserId => $UserInfo) {
//生成单行数据
$t = array();
$t['user_id'] = $UserInfo['user_id'];
$t['open_wx_id'] = $UserInfo['wx_open_id'];
$t['open_wx_id'] = $UserInfo['wx_open_id'];
$t['name'] = $UserInfo['name'];
$t['nick_name'] = $UserInfo['nick_name'];
$t['sex'] = isset($SexList[$UserInfo['sex']]) ? $SexList[$UserInfo['sex']] : "保密";
$t['AuthStatus'] = isset($AuthStatusList[$UserInfo['auth_state']]) ? $AuthStatusList[$UserInfo['auth_state']] : "未知";
$oExcel->addRows(array($t));
unset($t);
}
$params['Page']++;
$oExcel->closeSheet()->close();
} while ($Count > 0);
} 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 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 downloadPackCodeAction()
{
//检查当前页面权限
$sign = '?ctl=config/product/pack&ac=gen.pack.code.log';
$this->manager->checkMenuPermission($sign, Widget_Manager::MENU_PURVIEW_SELECT);
//页面输入变量
$GenId = intval($this->request->GenId);
$permitted_app = $this->permitted_app;
//初始化合作商列表
$permitted_partner = array();
//初始化服务器列表
$permitted_server = array();
$AreaList = $this->AreaList;
//获取当前地区列表
$AreaList = $this->oArea->getAbroad(0, $AreaList);
//生成允许的地区id数组
if ($app_type > 0) {
//筛选是否平台产品
$permitted_app = $this->oApp->getApp(0, $permitted_app);
}
if ($AppId > 0) {
//获取可查看的权限总表
$permitted_partner = $this->oPermission->getPartner($this->manager->data_groups, 0, 'PartnerId,name,AreaId');
//根据合作方式筛选
$permitted_partner = $this->oPartnerApp->getPermittedPartnerByPartnerType(0, $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, '');
$PackCodeList = $this->oProductPack->GetPackCodeByGenId($GenId, $oWherePartnerPermission);
if (is_array($PackCodeList)) {
$GenInfo = $this->oProductPack->GetGenPackCodeLogById($GenId);
$AppName = $permitted_app[$GenInfo['AppId']]['name'];
$ManagerName = $this->manager->name;
$FileName = $GenId . "-" . $AppName . "-" . $ManagerName . "-" . date("YmdHis", time());
$oExcel = new Third_Excel();
$oExcel->download($FileName)->addSheet('礼包码');
foreach ($PackCodeList as $key => $value) {
$t = array();
//生成单行数据
$t['Code'] = $value['ProductPackCode'];
if ($value['UsedUser']) {
$UserInfo = $this->oUser->getUserById($value['UsedUser']);
$t['Used'] = "已使用";
$t['UserName'] = $UserInfo['UserName'];
$Used++;
} else {
$t['Used'] = "未使用";
$t['UserName'] = "";
}
if ($value['AsignUser']) {
$UserInfo = $this->oUser->getUserById($value['AsignUser']);
$t['Asigned'] = "已分配";
$t['AsignUserName'] = $UserInfo['UserName'];
$Asigned++;
} else {
$t['Used'] = "未分配";
$t['AsignUserName'] = "";
}
$oExcel->addRows(array($t));
}
unset($t);
$t['Used'] = "已使用：" . $Used;
$t['Asigned'] = "已分配：" . $Asigned;
$oExcel->addRows(array($t));
//结束excel
$oExcel->closeSheet()->close();
}
}
