<?php

class PjlZsjm extends PjlBase
{
    /**
     * @param $data array 元数据
     * @param $zslId int 主键
     * @param $part array 零件
     * @param $brand  array 品牌
     * @return array
     */
    public function adds($data,$zslId,$part,$brand,$city)
    {
        if($zslId > 0){
            $this->PjlDb->Begin();
            if(!empty($city)){
                $this->del("zs_zhaoshang_city",sprintf(' and zc_zsl_id=%d',$zslId));
                foreach ($city as &$value){
                    $temp = $value;
                    $value = [];
                    $value['zc_pc_id'] = $temp;
                    $value['zc_zsl_id'] = $zslId;
                }
                $city = array_reverse($city);
                $this->PjlDb->Insert('zs_zhaoshang_city',$city);
            }
            if(!empty($part)){
                $this->del("zs_zhaoshang_part",sprintf(" and zp_zsl_id=%d",$zslId));
                foreach ($part as &$value){
                    $temp = $value;
                    $value = [];
                    $value['zp_part'] = $temp;
                    $value['zp_zsl_id'] = $zslId;
                }
                $part = array_reverse($part);
                $this->PjlDb->Insert('zs_zhaoshang_part',$part);
            }

            if(!empty($brand)){
                $this->del("zs_zhaoshang_brand",sprintf(" and zb_zsl_id=%d",$zslId));
                foreach ($brand as &$value){
                    $temp = $value;
                    $value = [];
                    $value['zb_brand_id'] = $temp;
                    $value['zb_zsl_id'] = $zslId;
                }
                $brand = array_reverse($brand);
                $this->PjlDb->Insert("zs_zhaoshang_brand",$brand);
            }
            $result = $this->set("zs_zhaoshang_list",$data,sprintf(" and zsl_id=%d",$zslId));
            $this->PjlDb->End();
            return $result;
        }else{
            $this->PjlDb->Begin();
            $result = $this->add("zs_zhaoshang_list",$data);
            $zslId = $result['data'];
            if(!empty($city)){
                $this->del("zs_zhaoshang_city",sprintf(' and zc_zsl_id=%d',$zslId));
                foreach ($city as &$value){
                    $temp = $value;
                    $value = [];
                    $value['zc_pc_id'] = $temp;
                    $value['zc_zsl_id'] = $zslId;
                }
                $city = array_reverse($city);
                $this->PjlDb->Insert('zs_zhaoshang_city',$city);
            }
            if(!empty($part)){
                $this->del("zs_zhaoshang_part",sprintf(" and zp_zsl_id=%d",$zslId));
                foreach ($part as &$value){
                    $temp = $value;
                    $value = [];
                    $value['zp_part'] = $temp;
                    $value['zp_zsl_id'] = $zslId;
                }
                $part = array_reverse($part);
                $this->PjlDb->Insert('zs_zhaoshang_part',$part);
            }

            if(!empty($brand)){
                $this->del("zs_zhaoshang_brand",sprintf(" and zb_zsl_id=%d",$zslId));
                foreach ($brand as &$value){
                    $temp = $value;
                    $value = [];
                    $value['zb_brand_id'] = $temp;
                    $value['zb_zsl_id'] = $zslId;
                }
                $brand = array_reverse($brand);
                $this->PjlDb->Insert("zs_zhaoshang_brand",$brand);
            }
            $this->PjlDb->End();
            return $result;
        }
    }
}