<?php

namespace App\Models\Product;


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

class KeywordRelated extends Base
{

    //设置关联表名
    protected $table = 'gl_product_keyword_related';

    const CREATED_AT = null;
    const UPDATED_AT = null;

    //连接数据库
    protected $connection = 'custom_mysql';
    /**
     * 关联产品关键词
     * @param $product_id
     * @param $keyword_ids
     * @author zbj
     * @date 2023/5/4
     */
    public static function saveRelated($product_id, $keyword_ids)
    {
        if(!is_array($keyword_ids)){
            $keyword_ids = array_filter(Arr::splitFilterToArray($keyword_ids), 'intval');
        }
        //先删除
        self::where('product_id', $product_id)->delete();

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