/** *获得统计表部分数据 */ 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;