yii2-netdisk/models/DownloadLogs.php

139 lines
3.7 KiB
PHP
Raw Permalink Normal View History

<?php
namespace app\models;
use yii\data\ActiveDataProvider;
use yii\db\ActiveQuery;
use yii\db\ActiveRecord;
/**
* This is the model class for table "download_logs".
*
* @property int $id 日志id
* @property int|null $user_id 用户id,未登录时NULL
* @property int|null $share_id 分享id
* @property string|null $access_time 访问时间
* @property string|null $ip_address ip地址
* @property string|null $user_agent UA
*
* @property Share $share
* @property User $user
*/
class DownloadLogs extends ActiveRecord
{
/**
* {@inheritdoc}
*/
public static function tableName(): string
{
return 'download_logs';
}
/**
* {@inheritdoc}
*/
public function rules(): array
{
return [
[['user_id', 'share_id'], 'integer'],
[['access_time'], 'safe'],
[['ip_address'], 'string', 'max' => 45],
[['user_agent'], 'string', 'max' => 255],
[['user_id'], 'exist', 'skipOnError' => true, 'targetClass' => User::class, 'targetAttribute' => ['user_id' => 'id']],
[['share_id'], 'exist', 'skipOnError' => true, 'targetClass' => Share::class, 'targetAttribute' => ['share_id' => 'share_id']],
];
}
/**
* {@inheritdoc}
*/
public function attributeLabels(): array
{
return [
'id' => '日志id',
'user_id' => '用户id,未登录时NULL',
'share_id' => '分享id',
'access_time' => '访问时间',
'ip_address' => 'ip地址',
'user_agent' => 'UA',
];
}
/**
* Gets query for [[Share]].
*
* @return ActiveQuery
*/
public function getShare(): ActiveQuery
{
return $this->hasOne(Share::class, ['share_id' => 'share_id']);
}
/**
* Gets query for [[User]].
*
* @return ActiveQuery
*/
public function getUser(): ActiveQuery
{
return $this->hasOne(User::class, ['id' => 'user_id']);
}
/**
* @param int|null $userId
* @param int $share_id
* @param string $ipAddress
* @param string $userAgent
* @return void
*/
public static function addLog(int|null $userId, int $share_id, string $ipAddress, string $userAgent): void
{
$log = new self();
$log->user_id = $userId??null;
$log->share_id = $share_id;
$log->ip_address = $ipAddress;
$log->access_time = date('Y-m-d H:i:s'); // 使用当前时间作为登录时间
$log->user_agent = strlen($userAgent) > 250 ? substr($userAgent, 0, 250) : $userAgent;
$log->save();
}
public function search($params): ActiveDataProvider
{
$query = DownloadLogs::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider([
'query' => $query,
'sort' => [
'defaultOrder' => [
'id' => SORT_DESC, // 默认按照 'id' 倒序排序
]
],
]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere([
'id' => $this->id,
'user_id' => $this->user_id,
'share_id' => $this->share_id,
'access_time' => $this->access_time,
]);
$query->andFilterWhere(['like', 'ip_address', $this->ip_address])
->andFilterWhere(['like', 'user_agent', $this->user_agent]);
return $dataProvider;
}
}