<?php
|
|
class statis_controller extends siteadmin_controller{
|
|
//图表类型 bar 柱形图，line折线图，pie饼形图
|
private $chartType = 'line';
|
|
//收支总计页面
|
public function index_action(){
|
|
$StatisM = $this->MODEL('statis');
|
|
$CompanyorderM = $this->MODEL('companyorder');
|
|
$PackM = $this->MODEL('pack');
|
|
if(isset($_GET['radio_time'])){
|
|
$this->yunset('radio_time', $_GET['radio_time']);
|
|
}
|
|
//查询报表数据
|
$time_begin = isset($_GET['time_begin']) ? $_GET['time_begin'] : date('Y-m-d 00:00:00', strtotime('-30 day'));
|
|
$time_end = isset($_GET['time_end']) ? $_GET['time_end'] :date('Y-m-d H:i:s');
|
|
$this->yunset('defaultTimeBegin', $time_begin);
|
|
$this->yunset('defaultTimeEnd', $time_end);
|
|
$isAllTime = isset($_GET['isAllTime']) ? $_GET['isAllTime'] : 0;
|
|
//查询30条内的信息，展示到页面第一屏
|
if($isAllTime != 1){
|
$timeBegin = strtotime($time_begin);
|
}else{
|
$timeBegin = strtotime(date('Y-m-d 00:00:00', strtotime('-30 year')));
|
}
|
$timeEnd = strtotime($time_end);
|
|
list($in, $out, $net_income) = $StatisM->getStatisTotal($timeBegin, $timeEnd );
|
|
$data [] = array('time' => '近30', 'in' => $in, 'out' => $out, 'net_income' => $net_income);
|
|
$this->yunset('data', $data);
|
|
//如果不是查询全部数据，组织查询的开始、结束时间
|
if($isAllTime != 1){
|
|
$timeBegin = strtotime($time_begin);
|
|
$timeEnd = strtotime($time_end);
|
|
$dateBegin = date('Y-m-d', $timeBegin);
|
|
$dateEnd = date('Y-m-d', $timeEnd);
|
|
$title = "收支统计 - {$dateBegin}~{$dateEnd}";
|
|
}else{
|
$title = "收支统计 - 全部数据";
|
}
|
|
//收支总计 查询：in毛收入，out支出/提现，net_income净收入
|
|
$names = array();//横坐标名称（时间日期）
|
|
$values = array();//纵坐标的值
|
|
$dataGroupNames = array();//柱行代表数据的名称
|
|
//毛收入
|
$comwhere['order_state'] = 2;
|
|
if($isAllTime != 1){
|
|
$comwhere['order_time'][] = array('>=', $timeBegin);
|
|
$comwhere['order_time'][] = array('<=', $timeEnd,'AND');
|
|
}
|
|
$comwhere['groupby'] = 'date';
|
|
$comwhere['orderby'] = array('date,asc');
|
|
$comfield = "sum(order_price) as `num`, from_unixtime(order_time,'%Y-%m-%d') as `date`";
|
|
$row = $CompanyorderM->getList($comwhere,array('field'=>$comfield));
|
|
$totalIn = 0;//收入总计
|
if(count($row) < 1){
|
|
$in = array('names' => array(), 'values' => array());
|
|
}else{
|
|
$inNames = array();
|
|
$inValues = array();
|
foreach($row as $r){
|
|
$inNames [] = $r['date'];
|
|
$inValues [] = $r['num'];
|
|
$totalIn += $r['num'];
|
}
|
|
$in = array('names' => $inNames, 'values' => $inValues);
|
|
}
|
|
//支出/提现
|
$memwhere['order_state'] = 1;
|
|
if($isAllTime != 1){
|
|
$memwhere['time'][] = array('>=', $timeBegin);
|
|
$memwhere['time'][] = array('<=', $timeEnd,'AND');
|
|
}
|
|
$memwhere['groupby'] = 'date';
|
|
$memwhere['orderby'] = 'date';
|
|
|
$memfield = "sum(order_price) as num, from_unixtime(`time`,'%Y-%m-%d') as `date`";
|
|
$mrow = $PackM->getList($memwhere,array('field'=>$memfield));
|
|
$totalOut = 0;
|
|
if(count($mrow) < 1){
|
$out = array('names' => array(), 'values' => array());
|
}
|
else{
|
|
$outNames = array();
|
|
$outValues = array();
|
|
foreach($mrow as $r){
|
|
$outNames [] = $r['date'];
|
|
$outValues [] = $r['num'];
|
|
$totalOut += $r['num'];
|
|
}
|
|
$out = array('names' => $outNames, 'values' => $outValues);
|
|
}
|
|
//净收入 综合names、values
|
$names = array_merge($in['names'], $out['names']);
|
|
$names = array_unique($names);
|
|
usort($names,'t_sort');
|
|
$inValues = array();
|
|
$outValues = array();
|
|
$inK = 0;
|
|
$outK = 0;
|
|
foreach($names as $n){
|
if(in_array($n, $in['names'])){
|
|
$inValues [] = $in['values'][$inK];
|
|
$inK ++;
|
|
}else{
|
|
$inValues [] = 0;
|
|
}
|
|
if(in_array($n, $out['names'])){
|
|
$outValues [] = $out['values'][$outK];
|
|
$outK ++;
|
|
}else{
|
$outValues [] = 0;
|
}
|
|
$netIncomeValues [] = end($inValues) - end($outValues);
|
}
|
|
$in['values'] = $inValues;
|
|
$out['values'] = $outValues;
|
|
$dataGroupNames [] = '毛收入';
|
|
$dataGroupNames [] = '支出/提现';
|
|
$dataGroupNames [] = '净收入';
|
|
$values[] = array('name' => '毛收入','type' => $this->chartType,'data' => $in['values']);
|
|
$values[] = array('name' => '支出/提现','type' => $this->chartType,'data' => $out['values']);
|
|
$values[] = array('name' => '净收入','type' => $this->chartType,'data' => $netIncomeValues);
|
|
$data = array('title' => $title,'names' => $names, 'values' => $values, 'dataGroupNames' => $dataGroupNames);
|
|
$this->yunset($data);
|
|
$this->yunset(array('totalIn'=> $totalIn, 'totalOut' => $totalOut, 'totalNetIncome' => $totalIn - $totalOut));
|
|
$this->siteadmin_tpl(array('statis'));
|
|
}
|
|
}
|
?>
|
