/**
*获得统计表部分数据
*/
protected function get_all_data()
{
$medoo = new medoo();
$db = new maindb();
$counter = array();
if ($_SESSION['userinfo']['auth'] == 0) {
$register_all = $db->count('p_user', array('uid'), array('uid[>]' => 0));
$authority_all = $db->count('p_user', array('auth'), array('auth' => 1));
$register_invite = $db->count('p_user', array('invite'), array('invite[!]' => ''));
$authority_invite = $db->count('p_user', '*', array('AND' => array('invite[!]' => '', 'auth' => 1)));
$counter = array('register_all' => $register_all, 'authority_all' => $authority_all, 'register_invite' => $register_invite, 'authority_invite' => $authority_invite, 'register_nature' => $register_all - $register_invite, 'authority_nature' => $authority_all - $authority_invite);
} elseif ($_SESSION['userinfo']['auth'] == 1) {
$counter = school_handler::manager_area_data_load($_SESSION['userinfo']['province']);
} elseif ($_SESSION['userinfo']['auth'] == 2) {
$counter = array('register_all' => 0, 'authority_all' => 0, 'register_invite' => 0, 'authority_invite' => 0, 'register_nature' => 0, 'authority_nature' => 0);
}
$this->assign('counter', $counter);
//todo 根据身份推送不同的信息列表
//list数据获取
if ($_SESSION['userinfo']['auth'] == 0) {
//管理员推送所有数据
$num = $medoo->count('ambassador', '*', array('auth[>]' => 0));
$list = $medoo->select('ambassador', '*', array('auth[>]' => 0, 'LIMIT' => 20));
} elseif ($_SESSION['userinfo']['auth'] == 1) {
//省级主管，推送区域内数据
$num = $medoo->count('ambassador', '*', array('AND' => array('province' => $_SESSION['userinfo']['province'], 'auth' => 2)));
$list = $medoo->select('ambassador', '*', array('AND' => array('province' => $_SESSION['userinfo']['province'], 'auth' => 2), 'LIMIT' => 20));
} elseif ($_SESSION['userinfo']['auth'] == 2) {
$num = 1;
$list = array();
}
unset($medoo);
unset($db);
$this->data_package($list, $num);
//填充欠缺数据，推送到前端
// $db=new maindb();
// $re=$db->select('p_user','*',array(
// 'invite'=>$_SESSION['userinfo']['ekey'],
// 'LIMIT'=>1,
// ));
}
$end = gmmktime(0, 0, 0, $arr[0], $arr[1], $arr[2]);
}
$couter_data = array();
//地区统计信息
$area = '';
//管理员
if ($_SESSION['userinfo']['auth'] == 0) {
$area = $_POST['name'];
//获取该区域下的所有用户
$list = $local->select('ambassador', array('name', 'ekey', 'province', 'school', 'auth', 'level', 'b_value'), array('AND' => array('province' => $area, 'auth[>]' => 0)));
$couter_data = school_handler::manager_area_data_load($area, $start, $end);
} elseif ($_SESSION['userinfo']['auth'] == 1) {
$area = $_SESSION['userinfo']['province'];
//获取该区域下的所有用户
$list = $local->select('ambassador', array('name', 'ekey', 'province', 'school', 'auth', 'level'), array('AND' => array('province' => $area, 'auth' => 2)));
$couter_data = school_handler::manager_area_data_load($area, $start, $end);
}
//填充信息
foreach ($list as &$v) {
//订单数
$ord = $local->count('orders', '*', array('AND' => array('ekey' => $v['ekey'], 'u_time[>]' => $start, 'u_time[<]' => $end)));
$v['ord'] = $ord;
//注册数
$reg = $remote->count('p_user', '*', array('AND' => array('invite' => $v['ekey'], 'reg_time[>]' => $start, 'reg_time[<]' => $end)));
$v['reg'] = $reg;
//认证数
$aut = $remote->count('p_user', '*', array('AND' => array('invite' => $v['ekey'], 'auth_time[>]' => $start, 'auth' => 1, 'auth_time[<]' => $end)));
$v['aut'] = $aut;
}
echo json_encode(array('list' => $list, 'counter' => $couter_data, 'area' => $area));
exit;
