/**
* 报表管理首页
*/
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);
}