/** * 报表管理首页 */ function index() { //查询条件 //专营店筛选 $area = $this->input->get('area'); $this->viewData['area'] = $area; $region = $this->input->get('region'); $this->viewData['region'] = $region; $province = $this->input->get('province'); $this->viewData['province'] = $province; $city = $this->input->get('city'); $this->viewData['city'] = $city; $storeId = $this->input->get('storeId'); $this->viewData['storeId'] = $storeId; $keyword = $this->input->get('keyword'); $this->viewData['keyword'] = $keyword; //年份 $year = $this->input->get('year'); $year || ($year = $this->config->item('nowYear')); $this->viewData['year'] = $year; //时间单位 $timeUnit = (int) $this->input->get('timeUnit'); $timeUnit || ($timeUnit = $this->timeUnitModel->getNowTimeUnit()); $this->viewData['timeUnit'] = $timeUnit; //数据类型 $type = (int) $this->input->get('type'); if (isset($_GET['submit']) && $_GET['submit'] == 'export') { isset($this->typeList[$type]) || showError('请选择正确的报表类型'); //条件参数 $params = array('area' => $area, 'region' => $region, 'province' => $province, 'city' => $city, 'storeId' => $storeId, 'keyword' => $keyword, 'year' => $year, 'timeUnit' => $timeUnit); //导出文件名 $fileName = $this->typeList[$type] . '-' . $year . '年'; if ($timeUnit) { $timeUnitList = $this->timeUnitModel->getCacheData('timeUnitList'); isset($timeUnitList[$year][$timeUnit]) && ($fileName .= '-' . $timeUnitList[$year][$timeUnit]); } //设置excel文件下载头 setExcelDownHeader($fileName); switch ($type) { case 1: //专营店反馈报表 $this->getStoreProExcel($params); break; case 2: //专营店反馈明细报表 $this->getStoreProDetailExcel($params); break; } } else { //面包屑 $this->viewData['breadcrumb'][] = array('url' => printUrl('Report', 'index'), 'title' => '报表管理'); $this->load->view('Report/index', $this->viewData); } }
/** * 报表管理首页 */ function index() { //查询条件 //专营店筛选 $area = $this->input->get('area'); $this->viewData['area'] = $area; $region = $this->input->get('region'); $this->viewData['region'] = $region; $spsarea = $this->input->get('spsarea'); $this->viewData['spsarea'] = $spsarea; $province = $this->input->get('province'); $this->viewData['province'] = $province; $city = $this->input->get('city'); $this->viewData['city'] = $city; $storeId = $this->input->get('storeId'); $this->viewData['storeId'] = $storeId; $keyword = $this->input->get('keyword'); $this->viewData['keyword'] = $keyword; //年份 $year = $this->input->get('year'); $year || ($year = $this->config->item('nowYear')); $this->viewData['year'] = $year; //时间单位 $timeUnit = (int) $this->input->get('timeUnit'); $timeUnit || ($timeUnit = $this->timeUnitModel->getNowTimeUnit()); $this->viewData['timeUnit'] = $timeUnit; //是否为补报 $isBubao = (int) $this->input->get('isBubao'); //基金类型 $fundType = (int) $this->input->get('fundType'); //报表类型 $reportType = (int) $this->input->get('reportType'); if (isset($_GET['submit']) && $_GET['submit'] == 'export') { isset($this->reportList[$fundType][$reportType]) || showError('请选择正确的报表类型'); //条件参数 $params = array('area' => $area, 'region' => $region, 'spsarea' => $spsarea, 'province' => $province, 'city' => $city, 'storeId' => $storeId, 'keyword' => $keyword, 'year' => $year, 'timeUnit' => $timeUnit, 'isBubao' => $isBubao); //导出文件名 $fileName = $this->fundList[$fundType] . '-' . $this->reportList[$fundType][$reportType] . '-' . $year . '年'; if ($timeUnit) { $timeUnitList = $this->timeUnitModel->getCacheData('timeUnitList'); isset($timeUnitList[$year][$timeUnit]) && ($fileName .= '-' . $timeUnitList[$year][$timeUnit]); } //设置excel文件下载头 setExcelDownHeader($fileName); switch ($fundType) { case 1: //专营店营销基金 $this->getCommonExcel($reportType, $params); break; case 2: //区域营销基金 $this->getAreaExcel($reportType, $params); break; case 3: //车展基金 $this->getCarExcel($reportType, $params); break; case 4: //巡展基金 $this->getXunExcel($reportType, $params); break; case 5: //专项基金 $this->getSpecialExcel($reportType, $params); break; } } else { //面包屑 $this->viewData['breadcrumb'][] = array('url' => printUrl('Report', 'index'), 'title' => '报表管理'); $this->load->view('Report/index', $this->viewData); } }
/** * 汇总表明细 */ function adminDetail() { if ($this->user['userRole'] == 1) { showError('您无权限进入此页面'); } //查询条件 $where = array(); //年 $this->viewData['year'] = $this->input->get('year'); $this->viewData['year'] || ($this->viewData['year'] = $this->config->item('nowYear')); $where['year'] = $this->viewData['year']; //时间单位 $this->viewData['timeUnit'] = (int) $this->input->get('timeUnit'); $this->viewData['timeUnit'] || ($this->viewData['timeUnit'] = $this->timeUnitModel->getNowTimeUnit()); $where['timeUnit'] = $this->viewData['timeUnit']; //系统配置 $this->viewData['yearList'] = $this->timeUnitModel->getCacheData('yearList'); $timeUnitList = $this->timeUnitModel->getCacheData('timeUnitList'); $this->viewData['timeUnitList'] = $timeUnitList[$this->viewData['year']]; //基金类型 $fundType = (int) $this->input->get('fundType'); $fundType || ($fundType = 1); $this->viewData['fundType'] = $fundType; //载入模型 $this->load->model('sellpointModel'); //地区 $area = $this->input->get('area'); $area = urldecode($area); $this->viewData['area'] = $area; //大区 $region = $this->input->get('region'); $region = urldecode($region); $this->viewData['region'] = $region; //小区 $spsarea = $this->input->get('spsarea'); $spsarea = urldecode($spsarea); $this->viewData['spsarea'] = $spsarea; //关键字 $keyword = $this->input->get('keyword'); $this->viewData['keyword'] = $keyword; //查找对应地区列表 $placeStoreList = $this->sellpointModel->searchStore($area, $region, $spsarea, '', '', 0, $keyword); $placeStoreIds = array_keys($placeStoreList); //权限内专营店列表 $viewStoreIds = $this->userLib->getViewStoreIds(); if ($viewStoreIds == '*') { $where['storeId'] = array('in', $placeStoreIds); } else { $where['storeId'] = array('in', array_intersect($viewStoreIds, $placeStoreIds)); } //查找符合条件的主线流程数据 if ($fundType == 1) { //专营店营销基金 $this->load->model('commonProcessModel'); $procList = $this->commonProcessModel->getList($where); } elseif ($fundType == 2) { //区域营销基金 $this->load->model('areaProcessModel'); $procList = $this->areaProcessModel->getList($where); } elseif ($fundType == 3) { //车展基金 $this->load->model('carProcessModel'); $procList = $this->carProcessModel->getList($where); } elseif ($fundType == 4) { //巡展基金 $this->load->model('xunProcessModel'); $procList = $this->xunProcessModel->getList($where); } elseif ($fundType == 5) { //专项基金 $this->load->model('specialProcessModel'); $procList = $this->specialProcessModel->getList($where); } $this->viewData['procList'] = $procList; //所有专营店数据 $this->viewData['allStoreList'] = $placeStoreList; //面包屑 $this->viewData['breadcrumb'][] = array('url' => printUrl('Main', 'adminTotal', array('year' => $this->viewData['year'], 'timeUnit' => $this->viewData['timeUnit'], 'fundType' => $this->viewData['fundType'])), 'title' => '费用总控表'); $this->viewData['breadcrumb'][] = array('url' => printUrl('Main', 'adminList', array('year' => $this->viewData['year'], 'timeUnit' => $this->viewData['timeUnit'], 'fundType' => $this->viewData['fundType'])), 'title' => '费用明细'); //提交类型 $subType = $this->input->get('subType'); $subType || ($subType = 'query'); $this->viewData['subType'] = $subType; if ($subType == 'query') { $this->load->view('Main/adminDetail', $this->viewData); } elseif ($subType == 'export') { //基金类型名称 $fundTypeName = isset($this->fundType[$fundType]) ? $this->fundType[$fundType] : ''; $fileName = $fundTypeName . '费用明细总控表'; $area && ($fileName .= $area . '区-'); $region && ($fileName .= $region . '-'); $spsarea && ($fileName .= $spsarea . '-'); $fileName .= $this->viewData['yearList'][$this->viewData['year']]; $fileName .= '-' . $this->viewData['timeUnitList'][$this->viewData['timeUnit']]; //设置excel文件下载头 setExcelDownHeader($fileName); if ($fundType == 1) { //专营店营销基金 $content = $this->load->view('Main/part/commonDetailTable', $this->viewData, true); } elseif ($fundType == 2) { //区域营销基金 $content = $this->load->view('Main/part/areaDetailTable', $this->viewData, true); } elseif ($fundType == 3) { //车展基金 $content = $this->load->view('Main/part/carDetailTable', $this->viewData, true); } elseif ($fundType == 4) { //巡展基金 $content = $this->load->view('Main/part/xunDetailTable', $this->viewData, true); } elseif ($fundType == 5) { //专项基金 $content = $this->load->view('Main/part/specialDetailTable', $this->viewData, true); } echo @ereg_replace("<a [^>]*>|<\\/a>", "", $content); } }
/** * 汇总表明细 */ function adminDetail() { if ($this->user['userRole'] == 1) { showError('您无权限进入此页面'); } //查询条件 $where = array(); //年 $this->viewData['year'] = $this->input->get('year'); $this->viewData['year'] || ($this->viewData['year'] = $this->config->item('nowYear')); $where['year'] = $this->viewData['year']; //时间单位 $this->viewData['timeUnit'] = (int) $this->input->get('timeUnit'); $this->viewData['timeUnit'] || ($this->viewData['timeUnit'] = $this->timeUnitModel->getNowTimeUnit()); $where['timeUnit'] = $this->viewData['timeUnit']; //系统配置 $this->viewData['yearList'] = $this->timeUnitModel->getCacheData('yearList'); $timeUnitList = $this->timeUnitModel->getCacheData('timeUnitList'); $this->viewData['timeUnitList'] = $timeUnitList[$this->viewData['year']]; //基金类型 $fundType = (int) $this->input->get('fundType'); $fundType || ($fundType = 1); $this->viewData['fundType'] = $fundType; $fundTypeName = isset($this->fundType[$fundType]) ? $this->fundType[$fundType] : ''; //载入模型 $this->load->model('sellpointModel'); //地区 $area = $this->input->get('area'); $area = urldecode($area); $this->viewData['area'] = $area; //大区 $region = $this->input->get('region'); $region = urldecode($region); $this->viewData['region'] = $region; //小区 $spsarea = $this->input->get('spsarea'); $spsarea = urldecode($spsarea); $this->viewData['spsarea'] = $spsarea; //关键字 $keyword = $this->input->get('keyword'); $keyword = urldecode($keyword); $this->viewData['keyword'] = $keyword; //查找对应地区列表 $placeStoreList = $this->sellpointModel->searchStore($area, $region, $spsarea, '', '', 0, $keyword); $placeStoreIds = array_keys($placeStoreList); //权限内专营店列表 $viewStoreIds = $this->userLib->getViewStoreIds(); if ($viewStoreIds == '*') { $where['storeId'] = array('in', $placeStoreIds); } else { $where['storeId'] = array('in', array_intersect($viewStoreIds, $placeStoreIds)); } //查找符合条件的主线流程数据 if ($fundType == 1) { $this->load->model('singleProcessModel'); $procList = $this->singleProcessModel->getList($where); //天网行动 /* $this->load->model('singleNetModel'); $netList = $this->singleNetModel->getListByProcId(array('procId'=>array('in', array_keys($procList)))); foreach ($procList as $k => $v){ //天网行动双月额度 $procList[$k]['netBudgetApply'] = isset($netList[$v['id']]) ? $netList[$v['id']]['budgetApply'] : 0; $procList[$k]['netSettleApply'] = isset($netList[$v['id']]) ? $netList[$v['id']]['settleApply'] : 0; //天网行动可结算金额 $procList[$k]['netCanSettleMoney'] = isset($netList[$v['id']]) ? $netList[$v['id']]['canSettleMoney'] : 0; } */ } elseif ($fundType == 3) { //城市基金 $this->load->model('cityProcessModel'); $procList = $this->cityProcessModel->getList($where); } elseif ($fundType == 4) { //车展基金 $this->load->model('carProcessModel'); $procList = $this->carProcessModel->getList($where); } elseif ($fundType == 2) { //巡展基金 $this->load->model('xunProcessModel'); $procList = $this->xunProcessModel->getList($where); } elseif ($fundType == 5) { //固定传播基金 unset($where['timeUnit']); $this->load->model('spreadProcessModel'); $procList = $this->spreadProcessModel->getNewListByStoreId($where); //获取有效的扣罚列表 $timeUnitList = $this->spreadProcessModel->getLostMoneyTimeUnitList($procList); $this->viewData['timeUnitList'] = $timeUnitList; } elseif ($fundType == 6) { //专项单店基金 $this->load->model('specialProcessModel'); $procList = $this->specialProcessModel->getList($where); } elseif ($fundType == 7) { //专项城市基金 $this->load->model('specityProcessModel'); $procList = $this->specityProcessModel->getList($where); } $this->viewData['procList'] = $procList; //所有专营店数据 $this->viewData['allStoreList'] = $placeStoreList; //面包屑 $this->viewData['breadcrumb'][] = array('url' => printUrl('Main', 'adminTotal', array('year' => $this->viewData['year'], 'timeUnit' => $this->viewData['timeUnit'], 'fundType' => $this->viewData['fundType'])), 'title' => $fundTypeName . '费用总控表'); $this->viewData['breadcrumb'][] = array('url' => printUrl('Main', 'adminList', array('year' => $this->viewData['year'], 'timeUnit' => $this->viewData['timeUnit'], 'fundType' => $this->viewData['fundType'])), 'title' => '费用明细'); //提交类型 $subType = $this->input->get('subType'); $subType || ($subType = 'query'); $this->viewData['subType'] = $subType; if ($subType == 'query') { $this->load->view('Main/adminDetail', $this->viewData); } elseif ($subType == 'export') { $fileName = ''; if ($fundType == 1) { //单店 $fileName = '单店基金'; $content = $this->load->view('Main/part/singleDetailTable', $this->viewData, true); } elseif ($fundType == 3) { //城市基金 $fileName = '城市基金'; $content = $this->load->view('Main/part/cityDetailTable', $this->viewData, true); } elseif ($fundType == 4) { //车展基金 $fileName = '车展基金'; $content = $this->load->view('Main/part/carDetailTable', $this->viewData, true); } elseif ($fundType == 2) { //巡展基金 $fileName = '巡展基金'; $content = $this->load->view('Main/part/xunDetailTable', $this->viewData, true); } elseif ($fundType == 5) { //固定传播基金 $fileName = '固定传播基金'; $content = $this->load->view('Main/part/spreadDetailTable', $this->viewData, true); } elseif ($fundType == 6) { //专项单店基金 $fileName = '专项单店基金'; $content = $this->load->view('Main/part/specialDetailTable', $this->viewData, true); } elseif ($fundType == 7) { //专项城市基金 $fileName = '专项城市基金'; $content = $this->load->view('Main/part/specityDetailTable', $this->viewData, true); } $fileName .= '费用明细总控表'; $area && ($fileName .= $area . '区-'); $region && ($fileName .= $region . '-'); $spsarea && ($fileName .= $spsarea . '-'); $fileName .= $this->viewData['yearList'][$this->viewData['year']]; if ($fundType != 5) { $fileName .= '-' . $this->viewData['timeUnitList'][$this->viewData['timeUnit']]; } //设置excel文件下载头 setExcelDownHeader($fileName); echo @ereg_replace("<a [^>]*>|<\\/a>", "", $content); } }
/** * 报表管理首页 */ function index() { //查询条件 //专营店筛选 $area = $this->input->get('area'); $this->viewData['area'] = $area; $region = $this->input->get('region'); $this->viewData['region'] = $region; $province = $this->input->get('province'); $this->viewData['province'] = $province; $city = $this->input->get('city'); $this->viewData['city'] = $city; $storeId = $this->input->get('storeId'); $this->viewData['storeId'] = $storeId; $keyword = $this->input->get('keyword'); $this->viewData['keyword'] = $keyword; //年份 $year = $this->input->get('year'); $year || ($year = $this->config->item('nowYear')); $this->viewData['year'] = $year; //时间单位 $timeUnit = (int) $this->input->get('timeUnit'); $timeUnit || ($timeUnit = $this->timeUnitModel->getNowTimeUnit()); $this->viewData['timeUnit'] = $timeUnit; //是否为补报 $isBubao = (int) $this->input->get('isBubao'); //基金类型 $fundType = (int) $this->input->get('fundType'); //报表类型 $reportType = (int) $this->input->get('reportType'); if (isset($_GET['submit']) && $_GET['submit'] == 'export') { isset($this->reportList[$fundType][$reportType]) || showError('请选择正确的报表类型'); if ($fundType == 2 && $timeUnit == 1 && !in_array($reportType, array(1, 2, 3))) { showError('1-2月不存在此报表类型'); } //条件参数 $params = array('area' => $area, 'region' => $region, 'province' => $province, 'city' => $city, 'storeId' => $storeId, 'keyword' => $keyword, 'year' => $year, 'timeUnit' => $timeUnit, 'isBubao' => $isBubao); //导出文件名 $fileName = $this->fundList[$fundType] . '-' . $this->reportList[$fundType][$reportType] . '-' . $year . '年'; //固定传播基金报表名称特殊处理 if ($fundType != 5) { if ($timeUnit) { $timeUnitList = $this->timeUnitModel->getCacheData('timeUnitList'); isset($timeUnitList[$year][$timeUnit]) && ($fileName .= '-' . $timeUnitList[$year][$timeUnit]); } $fileName .= '-' . ($isBubao == 1 ? '补报' : '普通申报'); } //设置excel文件下载头 setExcelDownHeader($fileName); switch ($fundType) { case 1: //单店基金 $this->getSingleExcel($reportType, $params); break; case 2: //城市提升基金 if ($timeUnit == 1) { //1-2月 $this->getCitySimpleExcel($reportType, $params); } else { //3-12月 $this->getCityExcel($reportType, $params); } break; case 3: //车展基金 $this->getCarshowExcel($reportType, $params); break; case 4: //巡展基金 $this->getXunExcel($reportType, $params); break; case 5: //固定传播基金 $this->getSpreadExcel($reportType, $params); break; case 6: //专项单店基金 $this->getSpecialExcel($reportType, $params); break; case 7: //专项城市基金 $this->getSpecityExcel($reportType, $params); break; } } else { //面包屑 $this->viewData['breadcrumb'][] = array('url' => printUrl('Report', 'index'), 'title' => '报表管理'); $this->load->view('Report/index', $this->viewData); } }
/** * 查询出项目可结算金额错误 */ function netList() { $timeUnit = 5; $timeUnitStr = '9-10'; $this->viewData['timeUnitStr'] = $timeUnitStr; $query = $this->db->query('SELECT b.year,b.timeUnit,a.* FROM rmp2015_new2_SNet a JOIN rmp2015_new2_SingleProcess b ON a.procId=b.id WHERE b.timeUnit=' . $timeUnit . ' ORDER BY a.storeId ASC;'); $list = $query->result_array(); $sellpointIds = array(); $validIds = array(); foreach ($list as $v) { $validIds[] = $v['id']; in_array($v['storeId'], $sellpointIds) || ($sellpointIds[] = (int) $v['storeId']); } $this->load->model('singleNetModel'); $this->viewData['list'] = $this->singleNetModel->getNewList(array('id' => array('in', $validIds))); $this->load->model('sellpointModel'); $this->viewData['allStoreList'] = $this->sellpointModel->getNewList(array('SellPointID' => array('in', $sellpointIds))); $fileName = $timeUnitStr . '月天网行动列表'; //设置excel文件下载头 setExcelDownHeader($fileName); $this->load->view('Admin/netList', $this->viewData); }