public function indexAction()
{
global $_F;
// $_F['debug'] = 1;
$page = max(1, FRequest::getInt('page'));
$spmT = new FTable('stats_spm');
$spmList = $spmT->order(array('id' => 'desc'))->page($page)->limit(20)->select();
$this->assign('page_info', $spmT->getPagerInfo());
$this->assign('spmList', $spmList);
$this->display('admin/spm-index');
}
public function appListAction()
{
$page = max(1, FRequest::getInt('page'));
$table = new FTable("app_version_config");
$app_data = $table->order(array("ver" => "desc"))->page($page)->limit(5)->select();
foreach ($app_data as &$app) {
$summary_arr = explode("\n", $app["summary"]);
$app["summary"] = $summary_arr;
}
$page_info = $table->getPagerInfo();
$this->assign("page_info", $page_info);
$this->assign("app_version", $app_data);
$this->display("app_version");
}
function listAction()
{
global $_F;
//$_F["debug"] = true;
$province = FRequest::getString('province');
$city = FRequest::getString('city');
$gender = CommonUtil::getComParam(FRequest::getInt('gender'), 2);
$age = FRequest::getInt('age');
$table = new FTable("user_province_area");
$provinces = $table->order(array("region_id" => "asc"))->select();
if ($province) {
$where = array("city" => $province);
$user_province = new FTable("user_province_area");
$user_provinces = $user_province->where($where)->find();
$stm_str = "-" . $age . " year";
$etm_str = "-" . ($age - 1) . " year";
$stm_birthday = date("Y-01-01 00:00:00", strtotime($stm_str));
$etm_birthday = date("Y-01-01 00:00:00", strtotime($etm_str));
$query_str = " ud.birthday >= '" . $stm_birthday . "' and ud.birthday < '" . $etm_birthday . "' ";
$user_table = new FTable("user_main", "um");
$user = $user_table->where(array("um.gender" => $gender, "str" => $query_str))->leftJoin("user_detail", "ud", "um.uid=ud.uid")->find();
$url = FConfig::get('global.service_mumu_url') . "/s/discovery/IAdjacent";
//$url = "http://yfservice.admin.docker:8081/s/discovery/IAdjacent";
//echo($url);
$post_data = array("lng" => $user_provinces['x'], "lat" => $user_provinces['y'], "cur" => 1, "refresh" => true, "ps" => 30, "uid" => $user["uid"]);
//$cookie = "sid=306123456;uid=5000513;key=306123456";
$cookie = "sid=" . FSession::get('sid') . ";uid=" . FSession::get('user_id') . ";key=" . FSession::get('sid');
$output = FHttp::doPost($url, $post_data, $cookie);
// print_r($output);
$output = json_decode($output);
$status = $output->status;
$users = $output->res;
$users = $users->users;
$users = $users->list;
if (count($users) <= 30) {
$post_data = array("lng" => $user_provinces['x'], "lat" => $user_provinces['y'], "cur" => 2, "refresh" => true, "ps" => 30, "uid" => $user["uid"]);
$output2 = FHttp::doPost($url, $post_data, $cookie);
$output2 = json_decode($output2);
$users2 = $output2->res;
$users2 = $users2->users;
$users2 = $users2->list;
}
$users = array_merge($users, $users2);
$ids = array();
foreach ($users as $u) {
array_push($ids, $u->uid);
}
if (count($ids) > 0) {
$users_table = new FTable("user_main", "um");
$u_arr = $users_table->fields(array("um.uid", "um.gender", "ud.localtag", "ud.birthday"))->where(array("um.uid" => array("in" => $ids)))->leftJoin("user_detail", "ud", "um.uid = ud.uid")->select();
}
$u_m = array();
foreach ($u_arr as $u) {
$u_m[$u["uid"]] = $u;
}
foreach ($users as &$u) {
$uid = $u->uid;
$r_u = $u_m[$uid];
$u->age = CommonUtil::birthdayToAge($r_u["birthday"]);
$u->tag = $r_u["localtag"];
$u->gender = $r_u["gender"];
}
$this->assign('users', $users);
$this->assign('status', $status);
$this->assign('province', $province);
$this->assign('city', $city);
$this->assign('age', $age);
}
$this->assign('gender', $gender);
$this->assign('provinces', $provinces);
$this->display('admin/user_avataradd_list');
}
/**
* 按省查询人数
*/
public function provinceAction()
{
//global $_F;
//$_F["debug"] = true;
$c_uid = CommonUtil::getDefStr(FRequest::getString('c_uid'), "");
$c_sid = CommonUtil::getDefStr(FRequest::getString('c_sid'), "");
$user_type = CommonUtil::getComParam(FRequest::getInt('user_type'), -1);
$stats_date = FRequest::getString('stats_date');
$sc_config = FRequest::getString('sc_config');
$this->assign('sc_uid', $c_uid);
$this->assign('sc_sid', $c_sid);
$this->assign('sc_config', $sc_config);
$this->assign('sc_config_1', $sc_config . "_1");
$this->assign('sc_config_2', $sc_config . "_2");
$where = array("s.interval" => "day");
if ($c_uid != "") {
$where["channel"] = $c_uid;
}
if ($c_sid != "") {
$where["sub_channel"] = $c_sid;
}
if ($sc_config != "") {
$where["s.key"] = $sc_config;
}
if ($user_type >= 0) {
// $where["user_type"] = $user_type;
}
if ($stats_date && $stats_date != "") {
$where["tm"] = $stats_date;
}
$table1 = new FTable("Config", "c", FDB::$DB_MUMU_STAT);
$Config = $table1->order(array("c.id" => "asc"))->select();
foreach ($Config as &$c) {
$c["id_1"] = $c["id"] . "_1";
$c["id_2"] = $c["id"] . "_2";
}
$fields = array("s.tm", "s.key", "s.province", "s.gender", "sum(s.value) as sum");
$table = new FTable("Stat", "s", FDB::$DB_MUMU_STAT);
$Stat = $table->fields($fields)->where($where)->groupBy("s.province,s.gender")->order(array("sum" => "desc"))->select();
$Stats = array();
foreach ($Stat as &$s) {
$sub_arr = array();
if (array_key_exists($s["province"], $Stats)) {
$sub_arr = $Stats[$s["province"]];
}
array_push($sub_arr, $s);
$Stats[$s["province"]] = $sub_arr;
}
$Stats2 = array();
foreach ($Stats as &$s) {
$sub_arr = array();
foreach ($s as &$s_x) {
$sub_arr["province"] = $s_x["province"];
$stats_key = $s_x["key"] . "_" . $s_x["gender"];
$sub_arr[$stats_key] = $s_x["sum"];
}
array_push($Stats2, $sub_arr);
}
//echo(json_encode($Stats2));
/*foreach($Stat as &$s){
$where["province"] = $s["province"];
$table2 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
$datas = $table2->fields(array(
"s.key",
"s.gender",
"sum(s.value) as sum"
)) ->where($where)->groupBy("s.gender")->select();
foreach($datas as &$data) {
$s[$data["key"]."_".$data["gender"]] = $data["sum"];
}
}*/
$spmList = Service_Edit::getAllSpm();
$this->assign('spmarr', json_encode($spmList));
$c_names = Service_Edit::getSpmMap($spmList);
$this->assign('spmList', $c_names);
$this->assign('Stat', $Stats2);
$this->assign('Config', $Config);
$this->assign('user_type', $user_type);
$this->assign('stats_date', $stats_date);
$this->display('admin/stats_wxw_province_detail');
// echo(json_encode($logList));
}
