public function index()
{
$username = I('username');
$city_id = I('city');
$province_id = I('provinces');
$tdesc = I('tdesc');
/*$where = array(
'user_type'=>array('eq',30)
);*/
if (!empty($username)) {
$where['c.mobile'] = array('like', '%' . $username . '%');
}
if (!empty($city_id)) {
$where['a.city_id'] = array('eq', $city_id);
}
$where['agent_type'] = array('in', '31,32,33');
$table = M('agent')->alias('a')->field('(select count(shop_id) from ' . C("DB_PREFIX") . 'shop where province_id = a.province_id and city_id = a.city_id and case when a.district_id <= 0 then a.city_id > 0 else district_id = a.district_id end and case when a.town_id <= 0 then a.city_id > 0 else town_id = a.town_id end) as num
,(select count(shop_id) from ' . C("DB_PREFIX") . 'shop where refer_user_id = a.user_id) as num_t
,(select sum(level1_agent_price) from ' . C("DB_PREFIX") . 'order where level1_agent_share_user_id = a.user_id) as level1_agent_price
,(select sum(level2_agent_price) from ' . C("DB_PREFIX") . 'order where level2_agent_share_user_id = a.user_id) as level2_agent_price
,(select sum(level2_agent_price) from ' . C("DB_PREFIX") . 'order where level3_agent_share_user_id = a.user_id) as level3_agent_price
,a.user_id,c.username,c.mobile,c.true_name,a.create_time,a.agent_status,b.city_name')->join('left join ' . C("DB_PREFIX") . 'city as b on a.city_id = b.city_id')->join('left join ' . C("DB_PREFIX") . 'user as c on a.user_id = c.user_id')->order('(select count(shop_id) from ' . C("DB_PREFIX") . 'shop where province_id = a.province_id and city_id = a.city_id and case when a.district_id <= 0 then a.city_id > 0 else district_id = a.district_id end and case when a.town_id <= 0 then a.city_id > 0 else town_id = a.town_id end) ' . $tdesc . ',a.create_time desc');
$list = select_table($table, $where, I('pageNumber'));
//print_r($table);
$item['total'] = M('agent')->where(array('agent_type' => array('in', '31,32,33')))->count();
//总数
$item['date'] = M('agent')->where(array('agent_type' => array('in', '31,32,33'), 'create_time' => array('BETWEEN', array(date('Y-m-d', time()) . ' 00:00:00', date('Y-m-d', time()) . ' 23:59:59'))))->count();
//每日新增
$week = dateweek(time());
$item['week'] = M('agent')->where(array('agent_type' => array('in', '31,32,33'), 'create_time' => array('BETWEEN', array(date('Y-m-d H:i:s', $week['start']), date('Y-m-d H:i:s', $week['end'])))))->count();
//本周新增
$item['month'] = M('agent')->where(array('agent_type' => array('in', '31,32,33'), 'create_time' => array('BETWEEN', array(date('Y-m', time()) . '-01 00:00:00', date('Y-m', time()) . '-31 23:59:59'))))->count();
//本月新增
$level1_agent_price = 0;
$level2_agent_price = 0;
$level3_agent_price = 0;
foreach ($list['data'] as $key => $val) {
$list['data'][$key]['num'] = $val['num'] + $val['num_t'];
$level1_agent_price += $val['level1_agent_price'];
$level2_agent_price += $val['level2_agent_price'];
$level3_agent_price += $val['level3_agent_price'];
}
$this->assign('city_id', $city_id);
$this->assign('province_id', $province_id);
$this->assign('list', $list);
$this->assign('item', $item);
$this->assign('level1_agent_price', $level1_agent_price);
$this->assign('level2_agent_price', $level2_agent_price);
$this->assign('level3_agent_price', $level3_agent_price);
$this->display();
}
public function index()
{
$username = I('username');
$area = I('area');
$tdesc = I('tdesc');
$where = array('agent_type' => array('eq', 20));
if (!empty($username)) {
$where['mobile'] = array('like', '%' . $username . '%');
}
if (!empty($area)) {
$where['a.city_id'] = array('eq', $area);
}
$table = M('agent')->alias('a')->field('
(select count(shop_id) from ' . C("DB_PREFIX") . 'shop where shop_serve_user_id = a.user_id or refer_user_id = a.user_id) as num
,(select sum(shop_serve_share_price) from ' . C("DB_PREFIX") . 'order where shop_serve_share_user_id = a.user_id) as shop_serve_share_price
,(select sum(shop_ref_share_price) from ' . C("DB_PREFIX") . 'order where shop_ref_share_user_id = a.user_id) as shop_ref_share_price
,(select sum(user_ref_share_price) from ' . C("DB_PREFIX") . 'order where user_ref_share_user_id = a.user_id) as user_ref_share_price
,a.user_id,f.username,f.mobile,f.true_name,a.create_time,a.agent_status
')->join('left join ' . C("DB_PREFIX") . 'city as b on a.city_id = b.city_id')->join('left join ' . C("DB_PREFIX") . 'district as c on a.district_id = c.district_id')->join('left join ' . C("DB_PREFIX") . 'town as d on a.town_id = d.town_id')->join('left join ' . C("DB_PREFIX") . 'user as f on f.user_id = a.user_id')->order('(select count(shop_id) from ' . C("DB_PREFIX") . 'shop where shop_serve_user_id = a.user_id) ' . $tdesc . ',a.create_time desc');
$list = select_table($table, $where, I('pageNumber'));
//print_r($table);
$item['total'] = M('agent')->where(array('agent_type' => array('eq', 20)))->count();
//总数
$item['date'] = M('agent')->where(array('agent_type' => array('eq', 20), 'create_time' => array('BETWEEN', array(date('Y-m-d', time()) . ' 00:00:00', date('Y-m-d', time()) . ' 23:59:59'))))->count();
//每日新增
$week = dateweek(time());
$item['week'] = M('agent')->where(array('agent_type' => array('eq', 20), 'create_time' => array('BETWEEN', array(date('Y-m-d H:i:s', $week['start']), date('Y-m-d H:i:s', $week['end'])))))->count();
//本周新增
$item['month'] = M('agent')->where(array('agent_type' => array('eq', 20), 'create_time' => array('BETWEEN', array(date('Y-m', time()) . '-01 00:00:00', date('Y-m', time()) . '-31 23:59:59'))))->count();
//本月新增
$shop_serve_share_price = 0;
$shop_ref_share_price = 0;
$user_ref_share_price = 0;
foreach ($list['data'] as $key => $val) {
$shop_serve_share_price += $val['shop_serve_share_price'];
$shop_ref_share_price += $val['shop_ref_share_price'];
$user_ref_share_price += $val['user_ref_share_price'];
}
$this->assign('area', M('city')->select());
$this->assign('list', $list);
$this->assign('item', $item);
$this->assign('shop_serve_share_price', $shop_serve_share_price);
$this->assign('shop_ref_share_price', $shop_ref_share_price);
$this->assign('user_ref_share_price', $user_ref_share_price);
$this->display();
}
public function index()
{
$username = I('username');
$city_id = I('city');
$province_id = I('provinces');
$tdesc = I('tdesc');
/*$where = array(
'user_type'=>array('eq',30)
);*/
if (!empty($username)) {
$where['c.mobile'] = array('like', '%' . $username . '%');
}
if (!empty($city_id)) {
$where['a.city_id'] = array('eq', $city_id);
}
$where['agent_type'] = array('eq', 50);
$table = M('agent')->alias('a')->field('
a.shop_num
,(select sum(operator_share_price) from ' . C("DB_PREFIX") . 'order where operator_share_user_id = a.user_id) as operator_share_price
,a.user_id,c.username,c.mobile,c.true_name,a.create_time,a.agent_status,b.city_name')->join('left join ' . C("DB_PREFIX") . 'city as b on a.city_id = b.city_id')->join('left join ' . C("DB_PREFIX") . 'user as c on a.user_id = c.user_id')->order('a.shop_num ' . $tdesc . ',a.create_time desc');
$list = select_table($table, $where, I('pageNumber'));
//print_r($table);
$item['total'] = M('agent')->where(array('agent_type' => array('eq', 50)))->count();
//总数
$item['date'] = M('agent')->where(array('agent_type' => array('eq', 50), 'create_time' => array('BETWEEN', array(date('Y-m-d', time()) . ' 00:00:00', date('Y-m-d', time()) . ' 23:59:59'))))->count();
//每日新增
$week = dateweek(time());
$item['week'] = M('agent')->where(array('agent_type' => array('eq', 50), 'create_time' => array('BETWEEN', array(date('Y-m-d H:i:s', $week['start']), date('Y-m-d H:i:s', $week['end'])))))->count();
//本周新增
$item['month'] = M('agent')->where(array('agent_type' => array('eq', 50), 'create_time' => array('BETWEEN', array(date('Y-m', time()) . '-01 00:00:00', date('Y-m', time()) . '-31 23:59:59'))))->count();
//本月新增
$operator_share_price = 0;
foreach ($list['data'] as $key => $val) {
$operator_share_price += $val['operator_share_price'];
}
//print_r($list['data']);
$this->assign('city_id', $city_id);
$this->assign('province_id', $province_id);
$this->assign('list', $list);
$this->assign('item', $item);
$this->assign('operator_share_price', $operator_share_price);
$this->display();
}
$selected['time'][6] = 'selected="selected"';
break;
case 7:
/* Last week */
list($date_from, $date_to) = dateweek(-1);
$selected['time'][7] = 'selected="selected"';
break;
case 8:
/* This business week */
list($date_from, $date_to) = dateweek(0, 1);
$date_to = date('Y-m-d');
$selected['time'][8] = 'selected="selected"';
break;
case 9:
/* Last business week */
list($date_from, $date_to) = dateweek(-1, 1);
$selected['time'][9] = 'selected="selected"';
break;
case 10:
/* This year */
$date_from = date('Y') . '-01-01';
$date_to = date('Y-m-d');
$selected['time'][10] = 'selected="selected"';
break;
case 11:
/* Last year */
$date_from = date('Y') - 1 . '-01-01';
$date_to = date('Y') - 1 . '-12-31';
$selected['time'][11] = 'selected="selected"';
break;
case 12:
