game-sdk/simplewind/huo/model/log/EventLogModel.php

<?php
/**
 * EventLogModel.php UTF-8
 *
 *
 * @date    : 2018/4/24 17:31
 *
 * @license 这不是一个自由软件，未经授权不许任何使用和传播。
 * @author  : wuyonghong <wyh@huosdk.com>
 * @version : HUOSDK 8.0
 */
namespace huo\model\log;

use huo\model\common\CommonModel;

class EventLogModel extends CommonModel {
    protected $table_prefix = 'h_log_event_';

    public function insertLog($data, $replace = false, $get_last_insert_id = true) {
        $_data['agent_id'] = get_val($data, 'agent_id', 0);
        $_data['agent_game'] = get_val($data, 'agent_game', '');
        $_data['app_id'] = get_val($data, 'app_id', 0);
        $_data['device_id'] = get_val($data, 'device_id', '');
        $_data['idfv'] = get_val($data, 'idfv', '');
        $_data['mac'] = get_val($data, 'mac', '');
        $_data['ip'] = get_val($data, 'ip', '');
        $_data['brand'] = get_val($data, 'brand', '');
        $_data['model'] = get_val($data, 'model', '');
        $_data['os'] = get_val($data, 'os', '');
        $_data['os_version'] = get_val($data, 'os_version', '');
        $_data['screen'] = get_val($data, 'screen', '');
        $_data['net'] = get_val($data, 'net', '');
        $_data['imsi'] = get_val($data, 'imsi', '');
        $_data['longitude'] = get_val($data, 'longitude', '');
        $_data['latitude'] = get_val($data, 'latitude', '');
        $_data['userua'] = get_val($data, 'userua', '');
        $_data['from'] = get_val($data, 'from', 0);
        $_data['create_time'] = time();
        $_data['open_cnt'] = get_val($data, 'from', 0);
        $_data['event'] = get_val($data, 'event', '');
        $_data['status'] = get_val($data, 'status', '');
        $_data['context'] = get_val($data, 'context', '');
        $this->checkTable();

        return parent::insertLog($_data, $replace, $get_last_insert_id);
    }

    /**
     * 计算在哪张表
     *
     * @return \Think\Model
     */
    public function computeTable() {
        $_date = date('Ymd');
        $_table = $this->table_prefix.$_date;

        return $this->table($_table);
    }

    function checkTable() {
        $_date = date('Ymd');
        $this->table = $this->table_prefix.$_date;
        $_sql = "CREATE TABLE IF NOT EXISTS `$this->table` (";
        $_sql .= "  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',";
        $_sql .= "  `date` date NOT NULL  DEFAULT '$_date' COMMENT '日期',";
        $_sql .= "  `agent_id` int(11) NOT NULL DEFAULT '0' COMMENT '玩家归属的ch_id',";
        $_sql .= "  `agent_game` varchar(32) NOT NULL COMMENT '子渠道编号',";
        $_sql .= "  `app_id` int(11) NOT NULL DEFAULT '0' COMMENT '游戏id',";
        $_sql .= "  `device_id` varchar(64) NOT NULL DEFAULT '' COMMENT '手机设备码',";
        $_sql .= "  `idfv` varchar(64) NOT NULL DEFAULT '' COMMENT 'IOS idfv',";
        $_sql .= "  `mac` varchar(32) NOT NULL DEFAULT '' COMMENT '设备的mac',";
        $_sql .= "  `ip` varchar(32) NOT NULL DEFAULT '' COMMENT '设备网络IP地址',";
        $_sql .= "  `brand` varchar(16) NOT NULL DEFAULT '' COMMENT '设备品牌',";
        $_sql .= "  `model` varchar(16) NOT NULL DEFAULT '' COMMENT '机型',";
        $_sql .= "  `os` varchar(8) NOT NULL DEFAULT '' COMMENT '操作系统',";
        $_sql .= "  `os_version` varchar(16) NOT NULL DEFAULT '' COMMENT '操作系统版本',";
        $_sql .= "  `screen` varchar(16) NOT NULL DEFAULT '' COMMENT '分辨率',";
        $_sql .= "  `net` varchar(8) NOT NULL DEFAULT '' COMMENT '3G,4G,WIFI',";
        $_sql .= "  `imsi` varchar(16) NOT NULL DEFAULT '' COMMENT '设备的imsi',";
        $_sql .= "  `longitude` varchar(32) NOT NULL DEFAULT '' COMMENT '经度',";
        $_sql .= "  `latitude` varchar(32) NOT NULL DEFAULT '' COMMENT '纬度',";
        $_sql .= "  `userua` varchar(255) NOT NULL DEFAULT '' COMMENT '用户使用的移动终端的UA信息',";
        $_sql .= "  `from` smallint(4) NOT NULL DEFAULT '0' COMMENT '3 ANDROID、4 IOS、5 H5',";
        $_sql .= "  `create_time` bigint(20) NOT NULL DEFAULT '0' COMMENT '登录时间',";
        $_sql .= "  `open_cnt` int(11) NOT NULL DEFAULT '0' COMMENT '打开此应用次数',";
        $_sql .= "  `event` varchar(50) NOT NULL DEFAULT '' COMMENT '事件名称',";
        $_sql .= "  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '事件状态 2 成功 1 失败',";
        $_sql .= "  `context` longtext COMMENT '事件上下文',";
        $_sql .= "  PRIMARY KEY (`id`),";
        $_sql .= "  KEY `le_time_index` (`create_time`),";
        $_sql .= "  KEY `le_date_index` (`date`)";
        $_sql .= ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='事件LOG';";

        return $this->execute($_sql);
    }
}