$charttitle = "最近{$days}天增长趋势图"; for ($i = $days; $i >= 0; $i--) { $time = date("Y-m-d", strtotime("-" . $i . " day")); $condition = " and uniacid=:uniacid and {$timefield}>=:starttime and {$timefield}<=:endtime"; $params = array(':uniacid' => $_W['uniacid'], ':starttime' => strtotime("{$time} 00:00:00"), ':endtime' => strtotime("{$time} 23:59:59")); $datas[] = array('date' => $time, 'mcount' => pdo_fetchcolumn("select count(*) from " . tablename('ewei_shop_member') . " where isagent=0 {$condition}", $params), 'acount' => pdo_fetchcolumn("select count(*) from " . tablename('ewei_shop_member') . " where isagent=1 {$condition}", $params)); } } else { if (!empty($year) && !empty($month)) { $charttitle = "{$year}年{$month}月增长趋势图"; $lastday = get_last_day($year, $month); for ($d = 1; $d <= $lastday; $d++) { $condition = " and uniacid=:uniacid and {$timefield}>=:starttime and {$timefield}<=:endtime"; $params = array(':uniacid' => $_W['uniacid'], ':starttime' => strtotime("{$year}-{$month}-{$d} 00:00:00"), ':endtime' => strtotime("{$year}-{$month}-{$d} 23:59:59")); $datas[] = array('date' => "{$d}日", 'mcount' => pdo_fetchcolumn("select count(*) from " . tablename('ewei_shop_member') . " where isagent=0 {$condition}", $params), 'acount' => pdo_fetchcolumn("select count(*) from " . tablename('ewei_shop_member') . " where isagent=1 {$condition}", $params)); } } else { if (!empty($year)) { $charttitle = "{$year}年增长趋势图"; foreach ($months as $m) { $lastday = get_last_day($year, $m['data']); $condition = " and uniacid=:uniacid and {$timefield}>=:starttime and {$timefield}<=:endtime"; $params = array(':uniacid' => $_W['uniacid'], ':starttime' => strtotime("{$year}-{$m['data']}-01 00:00:00"), ':endtime' => strtotime("{$year}-{$m['data']}-{$lastday} 23:59:59")); $datas[] = array('date' => $m['data'] . "月", 'mcount' => pdo_fetchcolumn("select count(*) from " . tablename('ewei_shop_member') . " where isagent=0 {$condition}", $params), 'acount' => pdo_fetchcolumn("select count(*) from " . tablename('ewei_shop_member') . " where isagent=1 {$condition}", $params)); } } } } load()->func('tpl'); include $this->template('web/statistics/member_increase'); exit;
} else { if (!empty($year) && !empty($month)) { $lastday = get_last_day($year, $month); for ($d = 1; $d <= $lastday; $d++) { $dr = array('data' => $d, 'count' => pdo_fetchcolumn("SELECT ifnull({$countfield},0) as cnt FROM " . tablename('ewei_shop_order') . " WHERE uniacid=:uniacid and status>=1 and createtime >=:starttime and createtime <=:endtime", array(':uniacid' => $_W['uniacid'], ':starttime' => strtotime("{$year}-{$month}-{$d} 00:00:00"), ':endtime' => strtotime("{$year}-{$month}-{$d} 23:59:59")))); $totalcount += $dr['count']; if ($dr['count'] > $maxcount) { $maxcount = $dr['count']; $maxcount_date = "{$year}年{$month}月{$d}日"; } $list[] = $dr; } } else { if (!empty($year)) { foreach ($months as $m) { $lastday = get_last_day($year, $m); $dr = array('data' => $m['data'], 'count' => pdo_fetchcolumn("SELECT ifnull({$countfield},0) as cnt FROM " . tablename('ewei_shop_order') . " WHERE uniacid=:uniacid and status>=1 and createtime >=:starttime and createtime <=:endtime", array(':uniacid' => $_W['uniacid'], ':starttime' => strtotime("{$year}-{$m['data']}-01 00:00:00"), ':endtime' => strtotime("{$year}-{$m['data']}-{$lastday} 23:59:59")))); $totalcount += $dr['count']; if ($dr['count'] > $maxcount) { $maxcount = $dr['count']; $maxcount_date = "{$year}年{$m['data']}月"; } $list[] = $dr; } } } } foreach ($list as $key => &$row) { $list[$key]['percent'] = number_format($row['count'] / (empty($totalcount) ? 1 : $totalcount) * 100, 2); } unset($row);
<?php if (!defined('IN_IA')) { exit('Access Denied'); } global $_W, $_GPC; //check_shop_auth('http://120.26.212.219/api.php'); $operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display'; if ($operation == 'days') { $year = intval($_GPC['year']); $month = intval($_GPC['month']); die(get_last_day($year, $month)); }