laravel的orm操作

namespace App\model;
use support\Db;
use support\Model;
class DemoModel extends Model
{
    protected $table="demo";
    public function __construct(array $attributes = [])
        {
            $data_table = $this->getTable();
            $this->table = $data_table.date('Ym');
            $result = Db::schema()->hasTable($this->table);
            if (empty($result)) {
                Db::update('create table '  . $this->table . ' like ' .   $data_table);
            }
            parent::__construct($attributes);
        }
}

thinkphp的orm操作方法

namespace App\model;
use think\facade\Db;
use think\Model;
class DemoModel extends Model
{
    protected $table="demo";
    public function __construct(array $attributes = [])
        {
            $data_table = $this->getTable();
            $this->table = $data_table.date('Ym');
            $prefix = config('thinkorm.prefix')??'';
            $result = Db::query("SHOW TABLES LIKE '{$prefix}{$this->table}'");
            if (empty($result)) {
                Db::query('create table '  . $this->table . ' like ' .   $data_table);
            }
            parent::__construct($attributes);
        }
}

/**
 * 獲取分表數(shù)據(jù)
 * @param string $table_name 原始表名
 * @param array $where 條件
 * @param int $page 分頁
 * @param int $page_er 頁數(shù)數(shù)量
 * @param array $select 表字段
 * @param array $orderBy 排序
 * @return mixed
 */
function getSubTableData(string $table_name = "", $where = [], int $page = 0, int $page_er = 10, array $orderBy = ['id'=>'desc'],$select = ['*'])
{
    $offset = $page * $page_er;
    // 開始日期
    $start = Carbon::parse(date('Y-01-01'));
    // 結(jié)束日期
    $end = Carbon::now();
    // 查詢集合
    $queries = collect();
    //把最原始表單的數(shù)據(jù)加入
    if(Schema::hasTable($table_name)){
        $queries->push(
            DB::table($table_name)
                // 建議都用select查詢字段，SQL盡可能的優(yōu)化性能
                ->select($select)
                ->where($where)
        );
    }
    // 循環(huán)比較年月，添加每一張表的查詢
    for ($i = $start->copy(); $i->format('Y-m') <= $end->format('Y-m'); $i->addMonth()) {

        // 按日期循環(huán)組裝出表名
        $tableName = $table_name . "_{$i->format('Ym')}";
        // 檢查這個(gè)表是否存在
        if (Schema::hasTable($tableName)) {
            $queries->push(
                DB::table($tableName)
                    // 建議都用select查詢字段，SQL盡可能的優(yōu)化性能
                    ->select($select)
                    ->where($where)
            );
        }
    }
    $unionQuery = $queries->shift();
    // 循環(huán)剩下的表添加union
    $queries->each(function ($item, $key) use ($unionQuery) {
        $unionQuery->unionAll($item);
    });
    // 把用 unionAll鏈接起來的sql 組成一個(gè)表
    $model = DB::table($table_name)
        // 添加臨時(shí)表
        ->from(DB::raw("({$unionQuery->toSql()}) AS {$table_name}"))
        // 合并查詢條件
        ->mergeBindings($unionQuery);
    if ($orderBy) {
        foreach ($orderBy as $k=>$v){
            // 按時(shí)間倒序
            $model->orderBy($k, $v);
        }
    }
    $data['total'] = $model->count();
    $data['data'] = $model->limit($page_er)->offset($offset)->get()->toArray();
    return $data;
}