<?php

namespace App\Models\Product;


use App\Helper\Arr;
use App\Models\Base;

class CategoryRelated extends Base
{

    //设置关联表名
    protected $table = 'gl_product_category_related';
    //连接数据库
    protected $connection = 'custom_mysql';

    const CREATED_AT = null;
    const UPDATED_AT = null;


    /**
     * 关联产品分类
     * @param $product_id
     * @param $cate_ids
     * @author zbj
     * @date 2023/4/21
     */
    public static function saveRelated($product_id, $cate_ids)
    {
        if(!is_array($cate_ids)){
            $cate_ids = array_filter(Arr::splitFilterToArray($cate_ids), 'intval');
        }
        //先删除
        self::where('product_id', $product_id)->delete();

        //批量保存
        $data = [];
        foreach ($cate_ids as $cate_id){
            $data[] = [
                'product_id' => $product_id,
                'cate_id' => $cate_id
            ];
        }
        self::insert($data);
    }
}