ThinkPHP's Use of One-to-One Associative Modeling (ORM)

<?php
/**
 * Created by PhpStorm
 * Author: fengzi
 * Date: 2023/12/19
 * Time: 14:50
 */

namespace app\common\model;

/**
 * :: User models
*/
class UserModel extends ComBaseModel
{
    protected $name='user';

    /**
     * The associated user extension table
     * The first parameter of hasOne is the name of the model class to be associated, the second parameter is the name of the foreign key of the association, and the third parameter is the name of the primary key of the current model (userModel)
     * @return \think\model\relation\HasOne
     * @Author: fengzi
     * @Date: 2024/6/27 17:38
*/
    public function userExtend()
    {
        return $this->hasOne(UserExtendModel::class,'user_id','id');
    }
}

<?php
/**
 * Created by PhpStorm
 * Author: fengzi
 * Date: 2023/12/19
 * Time: 14:50
 */

namespace app\common\model;

/**
 * :: User extension table
*/
class UserExtendModel extends ComBaseModel
{
    protected $name='user_extend';

    /**
     * Relative association of user models
     * The first parameter of belongsTo is the association model class name, the second parameter is the foreign key of the current model (UserExtendModel), and the third parameter is the primary key of the associated table.
     * @return \think\model\relation\BelongsTo
     * @Author: fengzi
     * @Date: 2024/6/27 17:41
*/
    public function user()
    {
        return $this->belongsTo(UserModel::class,'user_id','id');
    }
}

<?php
/**
 * Created by PhpStorm
 * Author: fengzi
 * Date: 2024/6/26
 * Time: 17:13
 */

namespace app\admin\controller\orm;

use app\common\model\UserModel;

class OrmController
{
    /**
     * @var UserModel|object|\think\App
     */
    private UserModel $userModel;

    public function __construct()
    {
        $this->userModel = app(UserModel::class);
    }

    public function index()
    {
        /**
         * with associative queries one-to-one
         * The value of the fourth joinType parameter of hasWhere: LEFT, RIGHT, or INNER.
         * user table to user_extend table using hasOne
         * Using hasWhere to query the user_extend table is equivalent to using the set of user_ids in the user_extend table that match the query criteria as the query criteria for the user table.
         * Because of the one-to-one association, when user_extend doesn't find the corresponding query data, the user table won't have any data either.
*/
        $lists = $this->userModel
            ->with(['user_extend'])
            ->hasWhere('userExtend', function ($query){
                $query->where('organize_id', 1);
            }, '*', 'LEFT')
            ->select()->toArray();

        // output printing
        dd($lists);
    }
}

public function index()
{
    // instantiated model
    $userModel = app(UserModel::class);

    /**
     * :: Joint table data and main table data are at the same level
*/
    $info = $userModel->withJoin(['user_extend'])->find(1);
    dump($info->toArray());

    /**
     * :: Linked table data is a child of the main table data, and the main/linked table data show a parent-child relationship
*/
    $info = $userModel->withJoin(['userExtend'])->find(1);

    dd($info->toArray());
}

public function index()
{
    // instantiated model
    $userModel = app(UserModel::class);

    /**
     * where(['organize_id'=>3])
     * The results can be queried based on the conditions
     *
     *
     * hasWhere('userExtend', function ($query){
     * $query->where('organize_id', 3);
     * }, '*', 'LEFT')
     * Can't get results, error "Illegal offset type".
*/
    $info = $userModel->withJoin(['user_extend'])
        ->where(['organize_id'=>3])
        /*->hasWhere('user_extend', function ($query){
            $query->where('organize_id', 3);
        })*/
        ->select();


    /*********** The following is the query when the primary/join table has the same field (same role_id field) ***********/


    // To filter the same fields in the main table (user table)
    $info = $userModel
        ->withJoin('userExtend')
        ->where(['mkl_user.role_id'=>2])
        ->select();

    // output printing
    dump($info->toArray());

    // To filter the same fields in a related table (user_extend table)
    $extendInfo = $userModel
        ->withJoin('userExtend')
        ->where(['userExtend.role_id'=>3])
        ->select();

    // output printing
    dd($extendInfo->toArray());
}

public function index()
{
    // Related queries
    $info = $this->userModel->with(['user_extend'])->find(1);

    // output printing
    dump($info->toArray());

    // Associated modifications: Mode I
    /*$userExtend = [
        'email' => '88888888@',
        'gender' => 1,
    ];
    $info->user_extend->save($userExtend);*/

    // Associated modifications: Mode II
    $info->userExtend->email = '88888888@';
    $info->userExtend->gender = 0;
    $info->userExtend->save();

    // Re-associate the query
    $newInfo = $this->userModel->with(['user_extend'])->find(1);

    // output printing
    dd($newInfo->toArray());
}

public function index()
{
    // instantiated model
    $userModel = app(UserModel::class);

    // Query data with user ID=1
    $info = $userModel->with(['userExtend'])->find(1);

    // Deleting Primary and Related Tables
    $del = $info->together(['userExtend'])->delete();
}

public function index()
{
    // instantiated model
    $userModel = app(UserModel::class);

    // Query data with user ID=1
    $info = $userModel->find(1);

    // Deleting Primary and Related Tables
    $del = $info->together(['userExtend'])->delete();

    // Output printing
    dd($del);
}

public function index()
{
    // instantiated model
    $userModel = app(UserModel::class);// Deleting Primary and Related Tables
    // Method 1
    $del = $userModel->find(1)->together(['userExtend'])->delete();
    // Mode 2
    $del = $userModel->with(['userExtend'])->find(1)->together(['userExtend'])->delete();
}

public function index()
{
    // instantiated model
    $userModel = app(UserModel::class);

    /**
     * withJoin(['user_extend'])together(['userExtend']) main table data deleted, join table data will not be deleted
     * withJoin(['user_extend'])together(['user_extend']) Main table data is deleted, join table data is not deleted.
     * withJoin(['userExtend'])together(['userExtend']) Main table data is deleted, join table data is deleted.
     * withJoin(['userExtend'])together(['user_extend']) Main table data is deleted, join table data is not deleted.
*/
    // Query data with user ID=1
    $info = $userModel->withJoin(['userExtend'])->find(1);
    // Deleting Primary and Related Tables
    $del = $info->together(['userExtend'])->delete();

/**
     * together(['user_extend']) main table data deleted, join table data will not be deleted
     * together(['userExtend']) main table data is deleted, join table data will not be deleted.
*/
    // Query data with user ID=1
    $info = $userModel->find(1);
    // Deleting Primary and Related Tables
    $del = $info->together(['userExtend'])->delete();
}