$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;
<?php /** * Created by PhpStorm. * User: KeenSting * Date: 2015/10/22 * Time: 16:32 */ require_once '../include/school_handler.php'; echo 'sadasd'; echo 'ok'; $list = school_handler::through_area_get_school('江西'); echo '66'; print_r($list);
/** *获得自身的注册数和认证数&订单数,如果我是主管,将学校列表写入session */ protected function get_self_counter() { $local = new medoo(); $db = new maindb(); $register = $db->count('p_user', '*', array('invite' => $_SESSION['userinfo']['ekey'])); $authority = $db->count('p_user', '*', array('AND' => array('invite' => $_SESSION['userinfo']['ekey'], 'auth' => 1))); $orders = $local->count('orders', '*', array('ekey' => $_SESSION['userinfo']['ekey'])); unset($db); unset($local); if ($_SESSION['userinfo']['auth'] == 1) { //主管,写入学校列表 $_SESSION['school'] = school_handler::through_area_get_school($_SESSION['userinfo']['province']); } $_SESSION['userinfo']['register'] = $register; $_SESSION['userinfo']['authority'] = $authority; $_SESSION['userinfo']['orders'] = $orders; }