Beispiel #1
0
 public function addUpdateAction()
 {
     if ($this->isPost()) {
         return;
     }
     $ver = CommonUtil::getComParam(FRequest::getInt("ver"), 0);
     if ($ver == 0) {
         $this->error("ver 版本错误");
         return;
     }
     $table = new FTable("app_version_config");
     $app_data = $table->where(array("ver" => $ver))->find();
     $summary_arr = explode("\n", $app_data["summary"]);
     $app_data["summary"] = $summary_arr;
     $table2 = new FTable("app_version");
     $update_data = $table2->where(array("ver" => $ver))->order(array("tm" => "desc"))->select();
     $this->assign("update_data", $update_data);
     $this->assign("app_version", $app_data);
     $spmList = Service_Edit::getAllSpm();
     $this->assign('spmarr', json_encode($spmList));
     $c_names = Service_Edit::getSpmMap($spmList);
     $this->assign('spmList', $c_names);
     $this->display("add_version");
 }
Beispiel #2
0
 /**
  * 按时间地区在线人数
  */
 public function zaixianAction()
 {
     $c_uid = CommonUtil::getDefStr(FRequest::getString('c_uid'), "");
     $c_sid = CommonUtil::getDefStr(FRequest::getString('c_sid'), "");
     $stats_date = FRequest::getString('stats_date');
     $province = FRequest::getString('province');
     $user_type = CommonUtil::getComParam(FRequest::getInt('user_type'), -1);
     $this->assign('sc_uid', $c_uid);
     $this->assign('sc_sid', $c_sid);
     $this->assign('stats_date', $stats_date);
     $this->assign('province', $province);
     $this->assign('user_type', $user_type);
     $table = new FTable("user_province_area");
     $user_province = $table->groupBy("province")->order(array("id" => "asc"))->select();
     $this->assign('user_province', $user_province);
     $data = array();
     $data_1 = array();
     $data_2 = array();
     $where = array("s.key" => "on_top_users");
     if ($c_uid != "") {
         $where["channel"] = $c_uid;
     }
     if ($c_sid != "") {
         $where["sub_channel"] = $c_sid;
     }
     if ($province) {
         $where["province"] = $province;
     }
     if ($user_type >= 0) {
         // $where["user_type"] = $user_type;
     }
     if ($stats_date && $stats_date != "") {
         $where["tm"] = array('like' => $stats_date);
         $where["s.interval"] = "hour";
     } else {
         $where["s.interval"] = "day";
     }
     $fields = array("s.tm", "s.key", "s.gender", "sum(s.value) as sum");
     $table2 = new FTable("Stat", "s", FDB::$DB_MUMU_STAT);
     $total_rs = $table2->fields($fields)->where($where)->groupBy("s.tm")->order(array("s.tm" => "desc"))->select();
     $total = count($total_rs);
     $kaishi_time = $total_rs[30][tm];
     $jieshu_time = $total_rs[0][tm];
     /* if ($total>30) {
            $jieshu_time=$total_rs[29][tm];
        } else {
            $jieshu_time=$total_rs[$total-1][tm];
        }*/
     // echo($kaishi_time.$jieshu_time);
     if ($total > 0) {
         $query_str = " s.tm >= '" . $kaishi_time . "' and  s.tm <= '" . $jieshu_time . "'   ";
         $where["str"] = $query_str;
     }
     $table = new FTable("Stat", "s", FDB::$DB_MUMU_STAT);
     $Stat = $table->fields($fields)->where($where)->groupBy("s.tm,s.key,s.gender")->order(array("s.tm" => "desc"))->select();
     $Stats = array();
     foreach ($Stat as &$s) {
         $sub_arr = array();
         $s["tm"] = $s["tm"];
         if (array_key_exists($s["tm"], $Stats)) {
             $sub_arr = $Stats[$s["tm"]];
         }
         array_push($sub_arr, $s);
         $Stats[$s["tm"]] = $sub_arr;
     }
     $Stats2 = array();
     foreach ($Stats as &$s) {
         $sub_arr = array("tm" => "");
         foreach ($s as &$s_x) {
             $sub_arr["tm"] = $s_x["tm"];
             $stats_key = $s_x["key"] . "_" . $s_x["gender"];
             $sub_arr[$stats_key] = $s_x["sum"];
         }
         $data[$sub_arr["tm"]] = $sub_arr["tm"];
         if ($sub_arr["on_top_users_1"]) {
             $data_1[$sub_arr["tm"]] = $sub_arr["on_top_users_1"];
         } else {
             $data_1[$sub_arr["tm"]] = 0;
         }
         if ($sub_arr["on_top_users_2"]) {
             $data_2[$sub_arr["tm"]] = $sub_arr["on_top_users_2"];
         } else {
             $data_2[$sub_arr["tm"]] = 0;
         }
         array_push($Stats2, $sub_arr);
     }
     $data1 = array();
     $i = 0;
     foreach ($data as $d) {
         if ($stats_date && $stats_date != "") {
             $data1[$i] = substr(substr($d, 0, 13), -2);
         } else {
             $data1[$i] = substr($d, 0, 10);
         }
         $i++;
     }
     $data1_1 = array();
     $i = 0;
     foreach ($data_1 as $d) {
         $data1_1[$i] = $d;
         $i++;
     }
     $data1_2 = array();
     $i = 0;
     foreach ($data_2 as $d) {
         $data1_2[$i] = $d;
         $i++;
     }
     $spmList = Service_Edit::getAllSpm();
     $this->assign('spmarr', json_encode($spmList));
     $c_names = Service_Edit::getSpmMap($spmList);
     $this->assign('spmList', $c_names);
     $this->assign("data_1", json_encode(array_reverse($data1_1)));
     $this->assign("data_2", json_encode(array_reverse($data1_2)));
     $this->assign("data", json_encode(array_reverse($data1)));
     $this->display('admin/user_spread_zaixian');
 }
Beispiel #3
0
 /**
  * 用户地区分部或者年龄分部
  */
 public function ageSpreadAction()
 {
     $c_uid = CommonUtil::getDefStr(FRequest::getString('c_uid'), "");
     $c_sid = CommonUtil::getDefStr(FRequest::getString('c_sid'), "");
     $stats_date = FRequest::getString('stats_date');
     $this->assign('sc_uid', $c_uid);
     $this->assign('sc_sid', $c_sid);
     $this->assign('stats_date', $stats_date);
     $where = array("um.uid" => array("gt" => 5000000));
     if ($c_uid != "") {
         $where["um.channel_uid"] = $c_uid;
     }
     if ($c_sid != "") {
         $where["um.channel_sid"] = $c_sid;
     }
     if ($stats_date) {
         $stm = date("Y-m-d 00:00:00", strtotime($stats_date));
         // 昨天凌晨
         $etm = date("Y-m-d 00:00:00", strtotime($stats_date . "+1 day"));
         $where["str"] = " um.reg_time > '" . $stm . "' and um.reg_time < '" . $etm . "'";
     }
     // 查询用户省份数据
     $user_table = new FTable("user_main", "um");
     $data = $user_table->fields(array("(YEAR(curdate())-YEAR(ud.birthday)) as age", "um.gender", "count(*) as num"))->leftJoin("user_detail", "ud", "um.uid = ud.uid")->groupBy("um.gender,YEAR(ud.birthday)")->where($where)->select();
     // echo(json_encode($data));
     $user_table2 = new FTable("user_main", "um");
     $data2 = $user_table2->fields(array("(YEAR(curdate())-YEAR(ud.birthday)) as age", "count(*) as num"))->leftJoin("user_detail", "ud", "um.uid = ud.uid")->groupBy("YEAR(ud.birthday)")->where($where)->order(array("num" => "desc"))->limit(30)->select();
     $rs = array("default" => array("1" => 0, "2" => 0));
     $p_arr = array();
     foreach ($data2 as $ages) {
         $age = $ages["age"];
         if (!$age || empty($age)) {
             $age = "缺省";
         }
         array_push($p_arr, $age);
     }
     foreach ($data as $d) {
         $rm = array("1" => 0, "2" => 0);
         $age = $d["age"];
         if (!$age || empty($age)) {
             $age = "缺省";
         }
         $gender = $d["gender"];
         if (array_key_exists($age, $rs)) {
             $rm = $rs[$age];
         }
         $rm[$gender] += $d["num"];
         $rs[$age] = $rm;
     }
     $data_1 = array();
     $data_2 = array();
     foreach ($p_arr as $p) {
         $d = $rs[$p];
         $d_1 = 0;
         $d_2 = 0;
         if ($d && $d["1"]) {
             $d_1 = $d["1"];
         }
         if ($d && $d["2"]) {
             $d_2 = $d["2"];
         }
         $data_1[count($data_1)] = $d_1;
         $data_2[count($data_2)] = $d_2;
     }
     $spmList = Service_Edit::getAllSpm();
     $this->assign('spmarr', json_encode($spmList));
     $c_names = Service_Edit::getSpmMap($spmList);
     $this->assign('spmList', $c_names);
     $this->assign("data_1", json_encode($data_1));
     $this->assign("data_2", json_encode($data_2));
     $this->assign("ages", json_encode($p_arr));
     $this->display('admin/user_age_spread');
 }
Beispiel #4
0
 /**
  * 主报表查询
  */
 public function reportAction()
 {
     //global $_F;
     //$_F["debug"] = true;
     $page_size = 30;
     $page = max(1, FRequest::getInt('page'));
     $c_uid = CommonUtil::getDefStr(FRequest::getString('c_uid'), "");
     $user_gender = CommonUtil::getComParam(FRequest::getInt('user_gender'), -1);
     $stats_date = FRequest::getString('stats_date');
     $stats_key = FRequest::getString('stats_key');
     $province = FRequest::getString('province');
     $ver = FRequest::getString('ver');
     $table = new FTable("user_province_area");
     $user_province = $table->groupBy("province")->order(array("id" => "asc"))->select();
     $this->assign('user_province', $user_province);
     $this->assign('province', $province);
     $this->assign('ver', $ver);
     if (!$stats_key) {
         $stats_key = "online_award_users";
         // $stats_key="on_top_users";
         //            $this->showMessage("查询留存不能为空",error,"/admin/ReportLiucun/default");
         //
         //        return;
         //            exit;
     }
     $where = array("s.interval" => "day");
     if ($c_uid != "") {
         $where["channel"] = $c_uid;
     }
     if ($user_gender >= 0) {
         $where["gender"] = $user_gender;
     }
     if ($province) {
         $where["province"] = $province;
     }
     if ($ver) {
         $where["ver"] = $ver;
     }
     $stats_key0 = $stats_key . "_lc_0";
     $stats_key1 = $stats_key . "_lc_1";
     $stats_key2 = $stats_key . "_lc_2";
     $stats_key3 = $stats_key . "_lc_3";
     $stats_key4 = $stats_key . "_lc_4";
     $stats_key5 = $stats_key . "_lc_5";
     $stats_key6 = $stats_key . "_lc_6";
     $stats_key7 = $stats_key . "_lc_7";
     $stats_key15 = $stats_key . "_lc_15";
     $stats_key30 = $stats_key . "_lc_30";
     $stats_key_array = array("'register'", "'" . $stats_key0 . "'", "'" . $stats_key1 . "'", "'" . $stats_key2 . "'", "'" . $stats_key3 . "'", "'" . $stats_key4 . "'", "'" . $stats_key5 . "'", "'" . $stats_key6 . "'", "'" . $stats_key7 . "'", "'" . $stats_key15 . "'", "'" . $stats_key30 . "'");
     $fields = array("s.tm", "s.key", "sum(s.value) as sum");
     //echo(json_encode($stats_key_array));
     $where["s.key"] = array('in' => $stats_key_array);
     $datetime_riqi_qiantian = date("Y-m-d", time() - 86400);
     $query_str = " s.tm <= '" . $datetime_riqi_qiantian . " 00:00:00'  ";
     $where["str"] = $query_str;
     $table2 = new FTable("Stat", "s", FDB::$DB_MUMU_STAT);
     $total_rs = $table2->fields($fields)->where($where)->groupBy("s.tm")->order(array("s.tm" => "desc"))->select();
     //echo(json_encode($where));
     $total = count($total_rs);
     $jieshu_time = $total_rs[$page_size * $page - $page_size][tm];
     if ($page_size * $page > $total) {
         $kaishi_time = $total_rs[$total - 1][tm];
     } else {
         $kaishi_time = $total_rs[$page_size * $page - 1][tm];
     }
     //echo($kaishi_time.$jieshu_time);
     if ($total > 0) {
         $query_str = " s.tm >= '" . $kaishi_time . "' and  s.tm <= '" . $jieshu_time . "'   ";
         $where["str"] = $query_str;
     }
     $table = new FTable("Stat", "s", FDB::$DB_MUMU_STAT);
     $Stat = $table->fields($fields)->where($where)->groupBy("s.tm,s.key")->order(array("s.tm" => "desc"))->select();
     $Stats = array();
     foreach ($Stat as &$s) {
         $sub_arr = array();
         $s["tm"] = substr($s["tm"], 0, 10);
         if (array_key_exists($s["tm"], $Stats)) {
             $sub_arr = $Stats[$s["tm"]];
         }
         array_push($sub_arr, $s);
         $Stats[$s["tm"]] = $sub_arr;
         //            $where["s.tm"] = $s["tm"];
         //            $where["s.key"] = "register";
         //            $table = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data = $table->fields(array("sum(s.value) as sum" )) ->where($where)->find();
         //            $s["register"] = $data["sum"];
         //
         //
         //            if ($stats_key) { $where["s.key"] = $stats_key1;  }
         //         $table1 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data1 = $table1->fields(array("sum(s.value) as sum" )) ->where($where)->find();
         //            $s["stats_key1"] = $data1["sum"];
         //            if ($stats_key) { $where["s.key"] = $stats_key2;  }
         //            $table2 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data2 = $table2->fields(array("sum(s.value) as sum" )) ->where($where)->find();
         //            $s["stats_key2"] = $data2["sum"];
         //            if ($stats_key) { $where["s.key"] = $stats_key3;  }
         //            $table3 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data3 = $table3->fields(array("sum(s.value) as sum")) ->where($where)->find();
         //            $s["stats_key3"] = $data3["sum"];
         //            if ($stats_key) { $where["s.key"] = $stats_key4;  }
         //            $table4 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data4 = $table4->fields(array("sum(s.value) as sum")) ->where($where)->find();
         //            $s["stats_key4"] = $data4["sum"];
         //            if ($stats_key) { $where["s.key"] = $stats_key5;  }
         //            $table5 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data5 = $table5->fields(array("sum(s.value) as sum")) ->where($where)->find();
         //            $s["stats_key5"] = $data5["sum"];
         //            if ($stats_key) { $where["s.key"] = $stats_key6;  }
         //            $table6 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data6 = $table6->fields(array("sum(s.value) as sum")) ->where($where)->find();
         //            $s["stats_key6"] = $data6["sum"];
         //            if ($stats_key) { $where["s.key"] = $stats_key7;  }
         //            $table7 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data7 = $table7->fields(array("sum(s.value) as sum")) ->where($where)->find();
         //            $s["stats_key7"] = $data7["sum"];
         //            if ($stats_key) { $where["s.key"] = $stats_key15;  }
         //            $table15 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data15 = $table15->fields(array("sum(s.value) as sum")) ->where($where)->find();
         //            $s["stats_key15"] = $data15["sum"];
         //            if ($stats_key) { $where["s.key"] = $stats_key30;  }
         //            $table30 = new FTable("Stat","s",FDB::$DB_MUMU_STAT);
         //            $data30 = $table30->fields(array("sum(s.value) as sum")) ->where($where)->find();
         //            $s["stats_key30"] = $data30["sum"];
         //$s["stats_date"] = substr($s["tm"],0,10);
     }
     /*print_r($Stats);*/
     $Stats2 = array();
     foreach ($Stats as &$s) {
         $sub_arr = array("tm" => "", "register" => 0, $stats_key0 => 0, $stats_key1 => 0, $stats_key2 => 0, $stats_key3 => 0, $stats_key4 => 0, $stats_key5 => 0, $stats_key6 => 0, $stats_key7 => 0, $stats_key15 => 0, $stats_key30 => 0);
         foreach ($s as &$s_x) {
             $sub_arr["tm"] = $s_x["tm"];
             if ($s_x["key"] == "register") {
                 $sub_arr["register"] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key0) {
                 $sub_arr[$stats_key0] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key1) {
                 $sub_arr[$stats_key1] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key2) {
                 $sub_arr[$stats_key2] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key3) {
                 $sub_arr[$stats_key3] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key4) {
                 $sub_arr[$stats_key4] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key5) {
                 $sub_arr[$stats_key5] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key6) {
                 $sub_arr[$stats_key6] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key7) {
                 $sub_arr[$stats_key7] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key15) {
                 $sub_arr[$stats_key15] = $s_x["sum"];
             }
             if ($s_x["key"] == $stats_key30) {
                 $sub_arr[$stats_key30] = $s_x["sum"];
             }
         }
         array_push($Stats2, $sub_arr);
     }
     //echo(json_encode($Stats2));
     // $total = count($Stats);
     $page_info = FPager::getPagerInfo($total, $page, $page_size);
     $spmList = Service_Edit::getAllSpm();
     $this->assign('spmarr', json_encode($spmList));
     $c_names = Service_Edit::getSpmMap($spmList);
     $this->assign('spmList', $c_names);
     $this->assign('page_info', $page_info);
     $this->assign('Stat', $Stats2);
     $this->assign('stats_key', $stats_key);
     $this->assign('sc_uid', $c_uid);
     $this->assign('user_gender', $user_gender);
     $this->assign('stats_date', $stats_date);
     $this->assign('stats_key0', $stats_key0);
     $this->assign('stats_key1', $stats_key1);
     $this->assign('stats_key2', $stats_key2);
     $this->assign('stats_key3', $stats_key3);
     $this->assign('stats_key4', $stats_key4);
     $this->assign('stats_key5', $stats_key5);
     $this->assign('stats_key6', $stats_key6);
     $this->assign('stats_key7', $stats_key7);
     $this->assign('stats_key15', $stats_key15);
     $this->assign('stats_key30', $stats_key30);
     $this->display('admin/stats_liucun');
 }