<?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 = [];
        if(!empty($cate_ids)){
            foreach ($cate_ids as $cate_id){
                $data[] = [
                    'product_id' => $product_id,
                    'cate_id' => $cate_id,
                    'created_at'=>date('Y-m-d H:i:s'),
                    'updated_at'=>date('Y-m-d H:i:s')
                ];
            }
            self::insert($data);
        }
        return true;
    }
}