1:全局分表模型定义
<?php
/**
* AdvPut.php
* 全局模型操作
* Created on 2023/6/13 17:21
* Create by xyz
*/
namespace app\common\model;
use think\facade\Env;
use think\Model;
use think\facade\Db;
class BackCommonModel extends Model
{
//分表新表表名
protected string $tableNew = '';
//分表参照表表名
protected string $tableOld = '';
//分表类型:years:年月,specific_date:年月日,year:年,month:月,day:日,delivery:数字取模分表
protected string $tableType = '';
//分表自增id`在这里插入代码片`
protected int $autoIncrement = 1;
//表前缀
// protected $prefix = '';
protected static function init()
{
}
/**
* Created by
* User: xyz
* Date: 2024/2/23
* Time: 17:26
* Brief: 简介
* docs: 自定义模型分表初始方法
* @param int $delivery_number 分表取模数
* @param int $delivery_multiple 分表取模倍数
*/
public function __comInit(int $delivery_number = 0, int $delivery_multiple = 0)
{
//创建分表初始化验证
$this->prefix = Env::get('database.PREFIX', 'tslu_');
// if (!empty($this->prefix) && !empty($this->tableType)) {
if (!empty($this->tableType)) {
//分表尾缀方式
$suffixAll = [
'year' => date("Y"),
'month' => date("m"),
'day' => date("d"),
'years' => date("Y_m"),
'specific_date' => date("Y_m_d"),
'delivery' => 0,
];
//数字取模分表计算
if ($this->tableType == 'delivery' && $delivery_number > 0 && $delivery_multiple > 0) {
$suffixAll['delivery'] = ceil($delivery_number / $delivery_multiple);
}
//验证分表后缀是否存在
if (isset($suffixAll[$this->tableType]) && !empty($suffixAll[$this->tableType])) {
//参照表表名
$this->tableOld = $this->name;
//分表新表表名
$this->tableNew = $this->name . '_' . $suffixAll[$this->tableType];
//验证分表是否存在
$this->gainTable();
}
}
}
/**
* Created by
* User: xyz
* Date: 2024/2/19
* Time: 9:41
* Brief: 简介
* docs: 验证分表是否存在,不存在就创建新表
*/
public function gainTable()
{
//获取参照表是否存在
$tableOld = Db::query("SHOW TABLES LIKE '$this->prefix$this->tableOld'");
//获取新表是否存在
$isTable = Db::query("SHOW TABLES LIKE '$this->prefix$this->tableNew'");
if (!empty($tableOld) && empty($isTable) && !empty($this->tableNew)) {
//创建表
$this->createTable();
}
}
/**
* Created by
* User: xyz
* Date: 2024/2/19
* Time: 9:42
* Brief: 简介
* docs: 分表不存在,进行复制主表,创建分表表
* @return mixed
*/
protected function createTable(): mixed
{
//获取建表语句
$result = Db::query("SHOW CREATE TABLE $this->prefix$this->tableOld");
$sql = array_pop($result[0]);
$sql = preg_replace(
['/CREATE TABLE `(\w+)`/', '/AUTO_INCREMENT=(\d+)/'],
["CREATE TABLE `$this->prefix$this->tableNew`", "AUTO_INCREMENT=$this->autoIncrement"],
$sql
);
//创建新表
return Db::execute($sql);
}
}
2:子类继承父类全局模型
<?php
namespace app\admin\model\xxx;
use app\common\model\BackCommonModel;
use think\db\exception\DbException;
use think\facade\Db;
use think\Model;
use think\Paginator;
class Axx extends BackCommonModel
{
// 开启自动写入时间戳字段
protected $autoWriteTimestamp = 'int';
protected $connection = 'mysql';
protected $name = 'xxxx';
// 定义时间戳字段名
protected $createTime = 'create_time';
protected $updateTime = 'update_time';
protected int $autoIncrement = 1;//自增id
//分表类型:years:年月,specific_date:年月日,year:年,month:月,day:日,delivery:数字取模分表
protected string $tableType = 'delivery';
//分表取模数
public static int $deliveryNumber = 0;
//分表取模倍数
public static int $deliveryMultiple = 0;
/**
* Created by
* User: xyz
* Date: 2024/2/23
* Time: 17:44
* Brief: 简介
* docs: 模型初始化
*/
protected static function init()
{
(new Axx())->comInit();
parent::init();
}
/**
* Created by
* User: xyz
* Date: 2024/2/23
* Time: 17:43
* Brief: 简介
* docs: 模型初始化,调用父级自定义魔术方法
*/
public function comInit()
{
parent::__comInit(self::$deliveryNumber, self::$deliveryMultiple);
}
}
3:业务层引用模型
<?php
/**
* UserService.php
* 文件描述
* Created on 2023/6/5 11:41
* Create by xyz
*/
namespace app\admin\service\xxxService;
use app\admin\model\powers\Axx;
use app\common\service\CommonService;
use fast\Random;
use think\facade\Config;
use think\Exception;
use think\facade\Log;
class xxxService extends CommonService
{
/**
* Created by
* User: xyz
* Date: 2023/10/11
* Time: 15:18
* Brief: 简介
* docs: 用户登录
* @param array $param
* @return array
* @throws Exception
* @throws \RedisException
*/
public function userLogin(array $param): array
{
try {
//定义分表取模数
PowersAdmin::$deliveryNumber = 1;
//定义分表取模倍数
PowersAdmin::$deliveryMultiple = 50;
//获取用户信息
$userInfo = PowersAdmin::where('xxxx',$param['xxx'])->find();
} catch (Exception $e) {
Log::error('用户登录错误' . $e->getMessage());
throw new Exception($e->getMessage());
}
}
}
以上就是tp6,tp8的模型分表全部方法啦,只是一个简单的demo,大家可以自己完善更好的。