There is no problem not worth solving, and no technology not worth learning!

In Laravel 6, set the self-association with the same model

表存在 2 个字段:original_theme_id、theme_id,字段 original_theme_id 的值源自于表中的另一条记录的 theme_id

1. There are 2 fields in the table: original_theme_id, theme_id, the value of the field original_theme_id is derived from the theme_id of another record in the table. as shown in Figure 1

表存在 2 个字段:original_theme_id、theme_id,字段 original_theme_id 的值源自于表中的另一条记录的 theme_id
Figure 1

2. Set a one-to-one reverse association in the model. The code is implemented as follows


    /**
     * 获取此主题安装所属原始的主题安装
     * @return BelongsTo
     */
    public function originalThemeInstallation()
    {
        return $this->belongsTo('Modules\ThemeStoreDB\Entities\ThemeInstallation', 'original_theme_id', 'theme_id');
    }


3. Get the code implementation of the associated attribute, the generated sql


        $themeInstallation = ThemeInstallation::find(345);
        print_r($themeInstallation->originalThemeInstallation);
        exit;



select
  *
from
  `theme_installation`
where
  `theme_installation`.`theme_id` = '96b1c8b9-5b18-4760-9e26-50ab009ac011'
  and `theme_installation`.`deleted_at` is null
limit
  1


4. Print the results, in line with expectations


Modules\ThemeStoreDB\Entities\ThemeInstallation Object
(
    [table:protected] => theme_installation
    [attributes:protected] => Array
        (
            [id] => 35
            [theme_store_theme_id] => 21
            [original_theme_id] => 
            [theme_id] => 96b1c8b9-5b18-4760-9e26-50ab009ac011
            [original_wp_theme_id] => 0
            [wp_theme_id] => 6
            [theme_name] => brooklyn
            [theme_custom_name] => brooklyn 6 2
            [type] => 1
            [role] => unpublished
            [processing] => 0
            [processing_failed] => 0
            [created_at] => 2022-07-04 02:53:29
            [updated_at] => 2022-12-09 03:04:36
            [deleted_at] => 
        )

)



PHP / Laravel / Yii2 Legacy Project Maintenance & Long-Term Technical Support

If your PHP / Laravel / Yii2 project is already in production but needs bug fixing, API troubleshooting, performance optimization, developer handover support, or long-term maintenance, feel free to contact me for remote technical support.

Ideal For:
✅ PHP legacy systems without active maintenance
✅ Laravel / Yii2 project bug fixes
✅ Admin panel feature iterations
✅ RESTful API troubleshooting
✅ MySQL / Redis / Nginx performance issues
✅ Long-term remote part-time maintenance

We can start with a small task:
✅ Production error troubleshooting
✅ API issue analysis
✅ Slow query and performance bottleneck diagnosis
✅ Initial code structure review
✅ Deployment environment and log inspection

If you would like to discuss your project, please contact me and mention: PHP Maintenance Consultation.

Contact Me:
Telegram: @shuijingwan
WeChat: 13980074657
Email: shuijingwanwq@gmail.com

评论

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.