tp 用户登录日志记录

创建时间：2017-05-18 投稿人：浏览次数：1506

<?php
// +----------------------------------------------------------------------
// | PHP@妖孽 [三十年河东三十年河西,莫欺少年穷.!]
// +----------------------------------------------------------------------
// | Copyright (c) 2014 http://www.yaonies.com All rights reserved.
// +----------------------------------------------------------------------
// | Author: PHP@妖孽 <msj@yaonies.com>
// +----------------------------------------------------------------------
/**
+------------------------------------------------------------------------------
* 基于用户的操作记录验证类
+------------------------------------------------------------------------------
* @category ORG
* @package ORG
* @subpackage Msj
* @author PHP@妖孽 <msj@yaonies.com>
* @version 1.0
+------------------------------------------------------------------------------
*/
// 配置文件增加设置
// "OPERATION_ON"=>true,// 开启用户记录日志
// "OPERATION_MEMBER"=>"learn_member",
// "OPERATION_TYPE"=>"web",//分别为web,interface也就是网站,和接口
// "OPERATION_MEMBER_ID"=>"member_id", //如果后台就取session,如果接口就直接取get,post请求的值
/*
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `msj_operation_log` (
`operation_log` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT "操作记录主键",
`operation_uid` mediumint(4) NOT NULL DEFAULT "0" COMMENT "操作人/如果是接口返回-1暂不记录接口请求人",
`operation_node` char(50) COLLATE utf8_bin NOT NULL DEFAULT "" COMMENT "操作节点",
`operation_ip` mediumtext COLLATE utf8_bin NOT NULL COMMENT "记录操作IP,省市,等信息",
`operation_time` int(10) NOT NULL DEFAULT "0" COMMENT "操作时间",
PRIMARY KEY (`operation_log`),
KEY `index_uid_node` (`operation_uid`,`operation_node`,`operation_log`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT="@author PHP@妖孽 @since 2014-5-4"
*/
class Operation {
private $operation_on;//操作记录开关
public $error;//错误信息
/**
* @todo 验证是否开启记录
*/
public function __construct(){
$this->operation_on = C("OPERATION_ON");
if($this->operation_on === false){
return false;
}
}
/**
* @todo获取客户端IP地址
* @param integer $type 返回类型 0 返回IP地址 1 返回IPV4地址数字
* @return mixed
*/
private function getClientIp($type=0){
$type = $type ? 1 : 0;
static $ip = NULL;
if ($ip !== NULL) return $ip[$type];
if (isset($_SERVER["HTTP_X_FORWARDED_FOR"])) {
$arr = explode(",", $_SERVER["HTTP_X_FORWARDED_FOR"]);
$pos = array_search("unknown",$arr);
if(false !== $pos) unset($arr[$pos]);
$ip = trim($arr[0]);
}elseif (isset($_SERVER["HTTP_CLIENT_IP"])) {
$ip = $_SERVER["HTTP_CLIENT_IP"];
}elseif (isset($_SERVER["REMOTE_ADDR"])) {
$ip = $_SERVER["REMOTE_ADDR"];
}
// IP地址合法验证
$long = sprintf("%u",ip2long($ip));
$ip = $long ? array($ip, $long) : array("0.0.0.0", 0);
return $ip[$type];
}
/**
* @todo 检测表是否存在,如果不存在则创建新表
*/
static public function checkTableIsExist(){
$db = Db::getInstance(C("RBAC_DB_DSN"));
$table_prefix = C("DB_PREFIX");
$sql = "CREATE TABLE IF NOT EXISTS `{$table_prefix}msj_operation_log` (
`operation_log` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT "操作记录主键",
`operation_uid` mediumint(4) NOT NULL DEFAULT "0" COMMENT "操作人/如果是接口返回-1暂不记录接口请求人",
`operation_node` char(50) COLLATE utf8_bin NOT NULL DEFAULT "" COMMENT "操作节点",
`operation_ip` mediumtext COLLATE utf8_bin NOT NULL COMMENT "记录操作IP,省市,等信息",
`operation_time` int(10) NOT NULL DEFAULT "0" COMMENT "操作时间",
PRIMARY KEY (`operation_log`),
KEY `index_uid_node` (`operation_uid`,`operation_node`,`operation_log`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT="@author PHP@妖孽 @since 2014-5-4"";
$db->execute($sql);
}
/**
* @todo 写入操作日志
*/
public function writeLog(){
(defined("NOW_TIME"))?$time = NOW_TIME: $time=time();
switch (C("OPERATION_TYPE")){
case "web":
$uid = session(C("OPERATION_MEMBER_ID"));
$uid = ($uid)?$uid:0;
break;
case "interface"://预留
$uid = -1;//接口的操作日志暂时不记录操作人
break;
default:
$uid = -2;
break;
}
$db_name =C("DB_NAME") ;
$table_prefix = C("DB_PREFIX");
import("@.ORG.Msj.IpLocation");// 导入IpLocation类
$Ip = new IpLocation(); // 实例化类
$ip_info = $Ip->getlocation($this->getClientIp()); // 获取某个IP地址所在的位置
$ip_info["country"] = iconv("gbk", "utf-8", $ip_info["country"]);
$db = Db::getInstance(C("RBAC_DB_DSN"));
$sql = "INSERT INTO `{$db_name}`.`{$table_prefix}msj_operation_log` (`operation_uid`, `operation_node`, `operation_ip`, `operation_time`) VALUES ("".$uid."","".$_SERVER["REQUEST_URI"]."","".serialize($ip_info)."","".$time."");";
if($db->execute($sql) === false ){
//插入失败写日志
Log::write("uid:{$uid},"."node:".$_SERVER["REQUEST_URI"].",operation_ip:".serialize($ip_info).",time:".date("Y-m-d H:i:s",$time));
}
}
/**
* @todo 查询操作日志
* @param array $map 目前只支持用户id的查询.
*/
public function logList($map=array()){
$db = Db::getInstance(C("RBAC_DB_DSN"));
$member_table_name = C("OPERATION_MEMBER");
$operation_table_name =C("DB_PREFIX")."msj_operation_log";
$member_id = implode(",",$map);
$sql = "(SELECT
msj_operation_log.operation_log AS operation_log,
msj_operation_log.operation_uid AS operation_uid,
msj_operation_log.operation_node AS operation_node,
msj_operation_log.operation_ip AS operation_ip,
msj_operation_log.operation_time AS operation_time,
Member.member_name AS member_name
FROM
{$operation_table_name} msj_operation_log
JOIN {$member_table_name} Member
ON msj_operation_log.operation_uid = Member.member_id
WHERE (`member_id` IN("{$member_id}")))";
$log_list = $db->query($sql);
$Ip = new IpLocation(); // 实例化类
$ip_info = $Ip->getlocation($this->getClientIp()); // 获取某个IP地址所在的位置
if(!empty($log_list)){
foreach($log_list as $key=>$val){
$log_list[$key]["operation_time"] = date("Y-m-d H:i:s",$val["operation_time"]);
$info = unserialize($val["operation_ip"]);
$log_list[$key]["operation_ip"] = "地区:".$info["area"].",城市:".$info["country"].",IP:".$info["ip"];
}
return $log_list;
}else{
return false;
}
}
public function __destruct(){
$this->operation_on=false;
$this->error ="";
}
}
//查list;
import("@.ORG.Msj.Operation");
$operation_obj = new Operation();
$log_list = $operation_obj->logList(array("member_id"=>2086));
//记录日志
$operation_obj->writeLog();

声明：该文观点仅代表作者本人，入门客AI创业平台信息发布平台仅提供信息存储空间服务，如有疑问请联系rumenke@qq.com。

上一篇： thinkphp(tp)框架封装一个自己写的方法到类里面.可以在其他控制器里面调用
下一篇：没有了

热门文章: php 遍历foreach 遍历一个二维...; php 将某个数组里的字符串...; php 二维数组下,循环拼接字...; thinkphp 里jq处理二维数组遍...; php 二维数组转一维，其中...; thinkphp 查询数据库数据根据...; thinkphp如何来判断访客为手...; php账号唯一登录思路; php excel下载模板方法2,放exce...; php 下载excel模板方法1

最新文章: thinkphp(tp)框架封装一个自己...; php 下载excel模板方法1; php excel下载模板方法2,放exce...; php账号唯一登录思路; thinkphp如何来判断访客为手...; thinkphp 查询数据库数据根据...; php 二维数组转一维，其中...; thinkphp 里jq处理二维数组遍...; php 二维数组下,循环拼接字...; php 将某个数组里的字符串...