Example #1
0
 /**
  * 新增店铺
  */
 public function newstoreOp()
 {
     //导出excel连接地址
     $actionurl = 'index.php?act=stat_store&op=newstore';
     $where = array();
     //所属店铺分类
     $search_sclass = intval($_REQUEST['search_sclass']);
     if ($search_sclass > 0) {
         $where['sc_id'] = $search_sclass;
         $actionurl .= "&search_sclass={$search_sclass}";
     }
     $field = ' count(*) as allnum ';
     if (!$_REQUEST['search_type']) {
         $_REQUEST['search_type'] = 'day';
     }
     //初始化时间
     //天
     if (!$_REQUEST['search_time']) {
         $_REQUEST['search_time'] = date('Y-m-d', time() - 86400);
     }
     $search_time = strtotime($_REQUEST['search_time']);
     //搜索的时间
     Tpl::output('search_time', $_REQUEST['search_time']);
     //周
     if (!$_REQUEST['search_time_year']) {
         $_REQUEST['search_time_year'] = date('Y', time());
     }
     if (!$_REQUEST['search_time_month']) {
         $_REQUEST['search_time_month'] = date('m', time());
     }
     if (!$_REQUEST['search_time_week']) {
         $_REQUEST['search_time_week'] = implode('|', uk86_getWeek_SdateAndEdate(time()));
     }
     $current_year = $_REQUEST['search_time_year'];
     $current_month = $_REQUEST['search_time_month'];
     $current_week = $_REQUEST['search_time_week'];
     $year_arr = uk86_getSystemYearArr();
     $month_arr = uk86_getSystemMonthArr();
     $week_arr = uk86_getMonthWeekArr($current_year, $current_month);
     Tpl::output('current_year', $current_year);
     Tpl::output('current_month', $current_month);
     Tpl::output('current_week', $current_week);
     Tpl::output('year_arr', $year_arr);
     Tpl::output('month_arr', $month_arr);
     Tpl::output('week_arr', $week_arr);
     $model = Model('stat');
     $statlist = array();
     //统计数据列表
     if ($_REQUEST['search_type'] == 'day') {
         //构造横轴数据
         for ($i = 0; $i < 24; $i++) {
             //统计图数据
             $curr_arr[$i] = 0;
             //今天
             $up_arr[$i] = 0;
             //昨天
             //统计表数据
             $uplist_arr[$i]['timetext'] = $i;
             $currlist_arr[$i]['timetext'] = $i;
             //方便搜索会员列表,计算开始时间和结束时间
             $currlist_arr[$i]['stime'] = $search_time + $i * 3600;
             $currlist_arr[$i]['etime'] = $currlist_arr[$i]['stime'] + 3600;
             $uplist_arr[$i]['val'] = 0;
             $currlist_arr[$i]['val'] = 0;
             //横轴
             $stat_arr['xAxis']['categories'][] = "{$i}";
         }
         $stime = $search_time - 86400;
         //昨天0点
         $etime = $search_time + 86400 - 1;
         //今天24点
         $today_day = @date('d', $search_time);
         //今天日期
         $yesterday_day = @date('d', $stime);
         //昨天日期
         $where['store_time'] = array('between', array($stime, $etime));
         $field .= ' ,DAY(FROM_UNIXTIME(store_time)) as dayval,HOUR(FROM_UNIXTIME(store_time)) as hourval ';
         $memberlist = $model->getNewStoreStatList($where, $field, 0, '', 0, 'dayval,hourval');
         if ($memberlist) {
             foreach ($memberlist as $k => $v) {
                 if ($today_day == $v['dayval']) {
                     $curr_arr[$v['hourval']] = intval($v['allnum']);
                     $currlist_arr[$v['hourval']]['val'] = intval($v['allnum']);
                 }
                 if ($yesterday_day == $v['dayval']) {
                     $up_arr[$v['hourval']] = intval($v['allnum']);
                     $uplist_arr[$v['hourval']]['val'] = intval($v['allnum']);
                 }
             }
         }
         $stat_arr['series'][0]['name'] = '昨天';
         $stat_arr['series'][0]['data'] = array_values($up_arr);
         $stat_arr['series'][1]['name'] = '今天';
         $stat_arr['series'][1]['data'] = array_values($curr_arr);
         //统计数据标题
         $statlist['headertitle'] = array('小时', '昨天', '今天', '同比');
         Tpl::output('actionurl', $actionurl . '&search_type=day&search_time=' . date('Y-m-d', $search_time));
     }
     if ($_REQUEST['search_type'] == 'week') {
         $current_weekarr = explode('|', $current_week);
         $stime = strtotime($current_weekarr[0]) - 86400 * 7;
         $etime = strtotime($current_weekarr[1]) + 86400 - 1;
         $up_week = @date('W', $stime);
         //上周
         $curr_week = @date('W', $etime);
         //本周
         //构造横轴数据
         for ($i = 1; $i <= 7; $i++) {
             //统计图数据
             $up_arr[$i] = 0;
             $curr_arr[$i] = 0;
             $tmp_weekarr = uk86_getSystemWeekArr();
             //统计表数据
             $uplist_arr[$i]['timetext'] = $tmp_weekarr[$i];
             $currlist_arr[$i]['timetext'] = $tmp_weekarr[$i];
             //方便搜索会员列表,计算开始时间和结束时间
             $currlist_arr[$i]['stime'] = strtotime($current_weekarr[0]) + ($i - 1) * 86400;
             $currlist_arr[$i]['etime'] = $currlist_arr[$i]['stime'] + 86400 - 1;
             $uplist_arr[$i]['val'] = 0;
             $currlist_arr[$i]['val'] = 0;
             //横轴
             $stat_arr['xAxis']['categories'][] = $tmp_weekarr[$i];
             unset($tmp_weekarr);
         }
         $where['store_time'] = array('between', array($stime, $etime));
         $field .= ',WEEKOFYEAR(FROM_UNIXTIME(store_time)) as weekval,WEEKDAY(FROM_UNIXTIME(store_time))+1 as dayofweekval ';
         $memberlist = $model->getNewStoreStatList($where, $field, 0, '', 0, 'weekval,dayofweekval');
         if ($memberlist) {
             foreach ($memberlist as $k => $v) {
                 if ($up_week == $v['weekval']) {
                     $up_arr[$v['dayofweekval']] = intval($v['allnum']);
                     $uplist_arr[$v['dayofweekval']]['val'] = intval($v['allnum']);
                 }
                 if ($curr_week == $v['weekval']) {
                     $curr_arr[$v['dayofweekval']] = intval($v['allnum']);
                     $currlist_arr[$v['dayofweekval']]['val'] = intval($v['allnum']);
                 }
             }
         }
         $stat_arr['series'][0]['name'] = '上周';
         $stat_arr['series'][0]['data'] = array_values($up_arr);
         $stat_arr['series'][1]['name'] = '本周';
         $stat_arr['series'][1]['data'] = array_values($curr_arr);
         //统计数据标题
         $statlist['headertitle'] = array('星期', '上周', '本周', '同比');
         Tpl::output('actionurl', $actionurl . '&search_type=week&search_time_year=' . $current_year . '&search_time_month=' . $current_month . '&search_time_week=' . $current_week);
     }
     if ($_REQUEST['search_type'] == 'month') {
         $stime = strtotime($current_year . '-' . $current_month . "-01 -1 month");
         $etime = uk86_getMonthLastDay($current_year, $current_month) + 86400 - 1;
         $up_month = date('m', $stime);
         $curr_month = date('m', $etime);
         //计算横轴的最大量(由于每个月的天数不同)
         $up_dayofmonth = date('t', $stime);
         $curr_dayofmonth = date('t', $etime);
         $x_max = $up_dayofmonth > $curr_dayofmonth ? $up_dayofmonth : $curr_dayofmonth;
         //构造横轴数据
         for ($i = 1; $i <= $x_max; $i++) {
             //统计图数据
             $up_arr[$i] = 0;
             $curr_arr[$i] = 0;
             //统计表数据
             $uplist_arr[$i]['timetext'] = $i;
             $currlist_arr[$i]['timetext'] = $i;
             //方便搜索会员列表,计算开始时间和结束时间
             $currlist_arr[$i]['stime'] = strtotime($current_year . '-' . $current_month . "-01") + ($i - 1) * 86400;
             $currlist_arr[$i]['etime'] = $currlist_arr[$i]['stime'] + 86400 - 1;
             $uplist_arr[$i]['val'] = 0;
             $currlist_arr[$i]['val'] = 0;
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
         }
         $where['store_time'] = array('between', array($stime, $etime));
         $field .= ',MONTH(FROM_UNIXTIME(store_time)) as monthval,day(FROM_UNIXTIME(store_time)) as dayval ';
         $memberlist = $model->getNewStoreStatList($where, $field, 0, '', 0, 'monthval,dayval');
         if ($memberlist) {
             foreach ($memberlist as $k => $v) {
                 if ($up_month == $v['monthval']) {
                     $up_arr[$v['dayval']] = intval($v['allnum']);
                     $uplist_arr[$v['dayval']]['val'] = intval($v['allnum']);
                 }
                 if ($curr_month == $v['monthval']) {
                     $curr_arr[$v['dayval']] = intval($v['allnum']);
                     $currlist_arr[$v['dayval']]['val'] = intval($v['allnum']);
                 }
             }
         }
         $stat_arr['series'][0]['name'] = '上月';
         $stat_arr['series'][0]['data'] = array_values($up_arr);
         $stat_arr['series'][1]['name'] = '本月';
         $stat_arr['series'][1]['data'] = array_values($curr_arr);
         //统计数据标题
         $statlist['headertitle'] = array('日期', '上月', '本月', '同比');
         Tpl::output('actionurl', $actionurl . '&search_type=month&search_time_year=' . $current_year . '&search_time_month=' . $current_month);
     }
     //计算同比
     foreach ((array) $currlist_arr as $k => $v) {
         $tmp = array();
         $tmp['seartime'] = $v['stime'] . '|' . $v['etime'];
         $tmp['timetext'] = $v['timetext'];
         $tmp['currentdata'] = $v['val'];
         $tmp['updata'] = $uplist_arr[$k]['val'];
         $tmp['tbrate'] = uk86_getTb($tmp['updata'], $tmp['currentdata']);
         $statlist['data'][] = $tmp;
     }
     //导出Excel
     if ($_GET['exporttype'] == 'excel') {
         //导出Excel
         uk86_import('libraries.uk86excel');
         $excel_obj = new Uk86Excel();
         $excel_data = array();
         //设置样式
         $excel_obj->uk86_setStyle(array('id' => 's_title', 'Font' => array('FontName' => '宋体', 'Size' => '12', 'Bold' => '1')));
         //header
         foreach ($statlist['headertitle'] as $v) {
             $excel_data[0][] = array('styleid' => 's_title', 'data' => $v);
         }
         //data
         foreach ($statlist['data'] as $k => $v) {
             $excel_data[$k + 1][] = array('data' => $v['timetext']);
             $excel_data[$k + 1][] = array('format' => 'Number', 'data' => $v['updata']);
             $excel_data[$k + 1][] = array('format' => 'Number', 'data' => $v['currentdata']);
             $excel_data[$k + 1][] = array('data' => $v['tbrate']);
         }
         $excel_data = $excel_obj->uk86_charset($excel_data, CHARSET);
         $excel_obj->uk86_addArray($excel_data);
         $excel_obj->uk86_addWorksheet($excel_obj->uk86_charset('新增店铺统计', CHARSET));
         $excel_obj->uk86_generateXML($excel_obj->uk86_charset('新增店铺统计', CHARSET) . date('Y-m-d-H', time()));
         exit;
     } else {
         //得到统计图数据
         $stat_arr['title'] = '新增店铺统计';
         $stat_arr['yAxis'] = '新增店铺数';
         $stat_json = uk86_getStatData_LineLabels($stat_arr);
         Tpl::output('stat_json', $stat_json);
         Tpl::output('statlist', $statlist);
         Tpl::output('top_link', $this->sublink($this->links, 'newstore'));
         Tpl::showpage('stat.newstore');
     }
 }
Example #2
0
 /**
  * 预存款统计
  */
 public function predepositOp()
 {
     $where = array();
     if (trim($_GET['pd_type']) == 'cash_pay') {
         $field = 'sum(lg_freeze_amount) as allnum';
     } else {
         $field = 'sum(lg_av_amount) as allnum';
     }
     if (!$_REQUEST['search_type']) {
         $_REQUEST['search_type'] = 'day';
     }
     $where['lg_type'] = trim($_GET['pd_type']) == '' ? 'recharge' : trim($_GET['pd_type']);
     //初始化时间
     //天
     if (!$_REQUEST['search_time']) {
         $_REQUEST['search_time'] = date('Y-m-d', time() - 86400);
     }
     $search_time = strtotime($_REQUEST['search_time']);
     //搜索的时间
     Tpl::output('search_time', $_REQUEST['search_time']);
     //周
     if (!$_REQUEST['search_time_year']) {
         $_REQUEST['search_time_year'] = date('Y', time());
     }
     if (!$_REQUEST['search_time_month']) {
         $_REQUEST['search_time_month'] = date('m', time());
     }
     if (!$_REQUEST['search_time_week']) {
         $_REQUEST['search_time_week'] = implode('|', uk86_getWeek_SdateAndEdate(time()));
     }
     $current_year = $_REQUEST['search_time_year'];
     $current_month = $_REQUEST['search_time_month'];
     $current_week = $_REQUEST['search_time_week'];
     $year_arr = uk86_getSystemYearArr();
     $month_arr = uk86_getSystemMonthArr();
     $week_arr = uk86_getMonthWeekArr($current_year, $current_month);
     Tpl::output('current_year', $current_year);
     Tpl::output('current_month', $current_month);
     Tpl::output('current_week', $current_week);
     Tpl::output('year_arr', $year_arr);
     Tpl::output('month_arr', $month_arr);
     Tpl::output('week_arr', $week_arr);
     $model = Model('stat');
     $statlist = array();
     //统计数据列表
     if ($_REQUEST['search_type'] == 'day') {
         //构造横轴数据
         for ($i = 0; $i < 24; $i++) {
             //统计图数据
             $curr_arr[$i] = 0;
             //今天
             $up_arr[$i] = 0;
             //昨天
             //统计表数据
             $uplist_arr[$i]['timetext'] = $i;
             $currlist_arr[$i]['timetext'] = $i;
             $uplist_arr[$i]['val'] = 0;
             $currlist_arr[$i]['val'] = 0;
             //横轴
             $stat_arr['xAxis']['categories'][] = "{$i}";
         }
         $stime = $search_time - 86400;
         //昨天0点
         $etime = $search_time + 86400 - 1;
         //今天24点
         $today_day = @date('d', $search_time);
         //今天日期
         $yesterday_day = @date('d', $stime);
         //昨天日期
         $where['lg_add_time'] = array('between', array($stime, $etime));
         $field .= ' ,DAY(FROM_UNIXTIME(lg_add_time)) as dayval,HOUR(FROM_UNIXTIME(lg_add_time)) as hourval ';
         $memberlist = $model->getPredepositInfo($where, $field, 0, '', 0, 'dayval,hourval');
         if ($memberlist) {
             foreach ($memberlist as $k => $v) {
                 if ($today_day == $v['dayval']) {
                     $curr_arr[$v['hourval']] = abs($v['allnum']);
                     $currlist_arr[$v['hourval']]['val'] = abs($v['allnum']);
                 }
                 if ($yesterday_day == $v['dayval']) {
                     $up_arr[$v['hourval']] = abs($v['allnum']);
                     $uplist_arr[$v['hourval']]['val'] = abs($v['allnum']);
                 }
             }
         }
         $stat_arr['series'][0]['name'] = '昨天';
         $stat_arr['series'][0]['data'] = array_values($up_arr);
         $stat_arr['series'][1]['name'] = '今天';
         $stat_arr['series'][1]['data'] = array_values($curr_arr);
         //统计数据标题
         $statlist['headertitle'] = array('小时', '昨天', '今天', '同比');
         Tpl::output('actionurl', 'index.php?act=stat_trade&op=predeposit&search_type=day&search_time=' . date('Y-m-d', $search_time));
     }
     if ($_REQUEST['search_type'] == 'week') {
         $current_weekarr = explode('|', $current_week);
         $stime = strtotime($current_weekarr[0]) - 86400 * 7;
         $etime = strtotime($current_weekarr[1]) + 86400 - 1;
         $up_week = @date('W', $stime);
         //上周
         $curr_week = @date('W', $etime);
         //本周
         //构造横轴数据
         for ($i = 1; $i <= 7; $i++) {
             //统计图数据
             $up_arr[$i] = 0;
             $curr_arr[$i] = 0;
             $tmp_weekarr = uk86_getSystemWeekArr();
             //统计表数据
             $uplist_arr[$i]['timetext'] = $tmp_weekarr[$i];
             $currlist_arr[$i]['timetext'] = $tmp_weekarr[$i];
             $uplist_arr[$i]['val'] = 0;
             $currlist_arr[$i]['val'] = 0;
             //横轴
             $stat_arr['xAxis']['categories'][] = $tmp_weekarr[$i];
             unset($tmp_weekarr);
         }
         $where['lg_add_time'] = array('between', array($stime, $etime));
         $field .= ',WEEKOFYEAR(FROM_UNIXTIME(lg_add_time)) as weekval,WEEKDAY(FROM_UNIXTIME(lg_add_time))+1 as dayofweekval ';
         $memberlist = $model->getPredepositInfo($where, $field, 0, '', 0, 'weekval,dayofweekval');
         if ($memberlist) {
             foreach ($memberlist as $k => $v) {
                 if ($up_week == $v['weekval']) {
                     $up_arr[$v['dayofweekval']] = abs($v['allnum']);
                     $uplist_arr[$v['dayofweekval']]['val'] = abs($v['allnum']);
                 }
                 if ($curr_week == $v['weekval']) {
                     $curr_arr[$v['dayofweekval']] = abs($v['allnum']);
                     $currlist_arr[$v['dayofweekval']]['val'] = abs($v['allnum']);
                 }
             }
         }
         $stat_arr['series'][0]['name'] = '上周';
         $stat_arr['series'][0]['data'] = array_values($up_arr);
         $stat_arr['series'][1]['name'] = '本周';
         $stat_arr['series'][1]['data'] = array_values($curr_arr);
         //统计数据标题
         $statlist['headertitle'] = array('星期', '上周', '本周', '同比');
         Tpl::output('actionurl', 'index.php?act=stat_trade&op=predeposit&search_type=week&search_time_year=' . $current_year . '&search_time_month=' . $current_month . '&search_time_week=' . $current_week);
     }
     if ($_REQUEST['search_type'] == 'month') {
         $stime = strtotime($current_year . '-' . $current_month . "-01 -1 month");
         $etime = uk86_getMonthLastDay($current_year, $current_month) + 86400 - 1;
         $up_month = date('m', $stime);
         $curr_month = date('m', $etime);
         //计算横轴的最大量(由于每个月的天数不同)
         $up_dayofmonth = date('t', $stime);
         $curr_dayofmonth = date('t', $etime);
         $x_max = $up_dayofmonth > $curr_dayofmonth ? $up_dayofmonth : $curr_dayofmonth;
         //构造横轴数据
         for ($i = 1; $i <= $x_max; $i++) {
             //统计图数据
             $up_arr[$i] = 0;
             $curr_arr[$i] = 0;
             //统计表数据
             $uplist_arr[$i]['timetext'] = $i;
             $currlist_arr[$i]['timetext'] = $i;
             $uplist_arr[$i]['val'] = 0;
             $currlist_arr[$i]['val'] = 0;
             //横轴
             $stat_arr['xAxis']['categories'][] = $i;
         }
         $where['lg_add_time'] = array('between', array($stime, $etime));
         $field .= ',MONTH(FROM_UNIXTIME(lg_add_time)) as monthval,day(FROM_UNIXTIME(lg_add_time)) as dayval ';
         $memberlist = $model->getPredepositInfo($where, $field, 0, '', 0, 'monthval,dayval');
         if ($memberlist) {
             foreach ($memberlist as $k => $v) {
                 if ($up_month == $v['monthval']) {
                     $up_arr[$v['dayval']] = abs($v['allnum']);
                     $uplist_arr[$v['dayval']]['val'] = abs($v['allnum']);
                 }
                 if ($curr_month == $v['monthval']) {
                     $curr_arr[$v['dayval']] = abs($v['allnum']);
                     $currlist_arr[$v['dayval']]['val'] = abs($v['allnum']);
                 }
             }
         }
         $stat_arr['series'][0]['name'] = '上月';
         $stat_arr['series'][0]['data'] = array_values($up_arr);
         $stat_arr['series'][1]['name'] = '本月';
         $stat_arr['series'][1]['data'] = array_values($curr_arr);
         //统计数据标题
         $statlist['headertitle'] = array('日期', '上月', '本月', '同比');
         Tpl::output('actionurl', 'index.php?act=stat_trade&op=predeposit&search_type=month&search_time_year=' . $current_year . '&search_time_month=' . $current_month);
     }
     //计算同比
     foreach ((array) $currlist_arr as $k => $v) {
         $tmp = array();
         $tmp['timetext'] = $v['timetext'];
         $tmp['currentdata'] = $v['val'];
         $tmp['updata'] = $uplist_arr[$k]['val'];
         $tmp['tbrate'] = uk86_getTb($tmp['updata'], $tmp['currentdata']);
         $statlist['data'][] = $tmp;
     }
     //导出Excel
     if ($_GET['exporttype'] == 'excel') {
         //获取数据
         $log_list = $model->getPredepositInfo($where, '*', '');
         //导出Excel
         uk86_import('libraries.uk86excel');
         $excel_obj = new Uk86Excel();
         $excel_data = array();
         //设置样式
         $excel_obj->uk86_setStyle(array('id' => 's_title', 'Font' => array('FontName' => '宋体', 'Size' => '12', 'Bold' => '1')));
         //header
         $excel_data[0][] = array('styleid' => 's_title', 'data' => '会员名称');
         $excel_data[0][] = array('styleid' => 's_title', 'data' => '创建时间');
         $excel_data[0][] = array('styleid' => 's_title', 'data' => '可用金额(元)');
         $excel_data[0][] = array('styleid' => 's_title', 'data' => '冻结金额(元)');
         $excel_data[0][] = array('styleid' => 's_title', 'data' => '管理员名称');
         $excel_data[0][] = array('styleid' => 's_title', 'data' => '类型');
         $excel_data[0][] = array('styleid' => 's_title', 'data' => '描述');
         //data
         foreach ($log_list as $k => $v) {
             $excel_data[$k + 1][] = array('data' => $v['lg_member_name']);
             $excel_data[$k + 1][] = array('data' => date('Y-m-d H:i:s', $v['lg_add_time']));
             $excel_data[$k + 1][] = array('data' => $v['lg_av_amount']);
             $excel_data[$k + 1][] = array('data' => $v['lg_freeze_amount']);
             $excel_data[$k + 1][] = array('data' => $v['lg_admin_name']);
             switch ($v['lg_type']) {
                 case 'recharge':
                     $excel_data[$k + 1][] = array('data' => '充值');
                     break;
                 case 'order_pay':
                     $excel_data[$k + 1][] = array('data' => '消费');
                     break;
                 case 'cash_pay':
                     $excel_data[$k + 1][] = array('data' => '提现');
                     break;
                 case 'refund':
                     $excel_data[$k + 1][] = array('data' => '退款');
                     break;
             }
             $excel_data[$k + 1][] = array('data' => $v['lg_desc']);
         }
         $excel_data = $excel_obj->uk86_charset($excel_data, CHARSET);
         $excel_obj->uk86_addArray($excel_data);
         $excel_obj->uk86_addWorksheet($excel_obj->uk86_charset('预存款统计', CHARSET));
         $excel_obj->uk86_generateXML($excel_obj->uk86_charset('预存款统计', CHARSET) . date('Y-m-d-H', time()));
         exit;
     } else {
         $log_list = $model->getPredepositInfo($where, '*', 15);
         Tpl::output('log_list', $log_list);
         Tpl::output('show_page', $model->showpage());
         //总数统计部分
         $recharge_amount = $model->getPredepositInfo(array('lg_type' => 'recharge', 'lg_add_time' => array('between', array($stime, $etime))), 'sum(lg_av_amount) as allnum');
         $order_amount = $model->getPredepositInfo(array('lg_type' => 'order_pay', 'lg_add_time' => array('between', array($stime, $etime))), 'sum(lg_av_amount) as allnum');
         $cash_amount = $model->getPredepositInfo(array('lg_type' => 'cash_pay', 'lg_add_time' => array('between', array($stime, $etime))), 'sum(lg_freeze_amount) as allnum');
         Tpl::output('stat_array', array('recharge_amount' => $recharge_amount[0]['allnum'], 'order_amount' => abs($order_amount[0]['allnum']), 'cash_amount' => abs($cash_amount[0]['allnum'])));
         $user_amount = $model->getPredepositInfo(true, 'distinct lg_member_id');
         Tpl::output('user_amount', count($user_amount));
         $usable_amount = $model->getPredepositInfo(true, 'sum(lg_av_amount+lg_freeze_amount) as allnum');
         Tpl::output('usable_amount', $usable_amount[0]['allnum']);
         //得到统计图数据
         $stat_arr['title'] = '预存款统计';
         $stat_arr['yAxis'] = '金额';
         $stat_json = uk86_getStatData_LineLabels($stat_arr);
         Tpl::output('stat_json', $stat_json);
         Tpl::output('statlist', $statlist);
         Tpl::output('top_link', $this->sublink($this->links, 'predeposit'));
         Tpl::showpage('stat.predeposit');
     }
 }