## 本地商品庫
>[info]功能：
1，顯示數據：通過 `yf_goods_shop_common`中間表 來查詢 `yf_goods_common` 商品數據表 顯示商品詳情
/*
*@desc 根據登錄賬號信息獲取數據列表
*
*/
public function scopeDefaultWhere($query)
{
parent::scopeDefaultWhere($query);
$wq = request_data('wq');
if($wq){
$query->whereHas("yf_goods_common",function($q) use($wq)
{
$q->where('common_code', 'like', "%".$wq."%");
});
$query->orWhereHas("yf_goods_common",function($q) use($wq)
{
$q->where('common_name', 'like', "%".$wq."%");
});
}
$in = \cs\login::login_user(1);
if($in){
$query->whereIn('shop_id',$in);
}
$cat_id = request_data('cat_id');
if($cat_id){
$query->whereHas("yf_goods_common",function($q) use($cat_id)
{
$ins = yf_goods_cat::ajax_list($cat_id)?:[];
$ins[] = (int)$cat_id;
$q->whereIn('cat_id',$ins );
});
}
$shop_id = request_data('shop_id');
if($shop_id){
$query->where('shop_id',$shop_id);
}
}
>[info]2，插入數據：新建商品 ，編輯數據：修改商品信息
/*
* @desc 保存表單數據
*
*/
static function saveForm(){
try{
DB::transaction(function()
{
$data = post_data();
if(!$data['shops']){
exit(json_encode(['status'=>0,'msg'=>__('所屬門店不能為空')]));
}
$cat_id = yf_goods_cat::where('cat_parent_id',$data['cat_id'])->first();
if($cat_id){
exit(json_encode(['status'=>0,'msg'=>__('請選擇該分類下的最后一級分類')]));
}
if($data['id']){
$models = new yf_goods_common;
$data['common_state'] = $data['common_state']?:2;
$data['common_invoices'] = $data['common_invoices']?:0;
$data['common_discounts'] = $data['common_discounts']?:0;
$model = self::find($data['id']);
if($model->yf_goods_common->common_state != $data['common_state']){
$data['common_sell_time'] = time();
}
$list = $models::where('common_code',$data['common_code'])->get()->toArray();
if($list){
foreach($list as $k=>$v){
$in[] = $v['id'];
}
$li = $model::whereIn('common_id',$in)->where('common_id','!=',$model->common_id)->get()->toArray();
if($li){
exit(json_encode(['status'=>0,'msg'=>__('該條形編碼已存在，不可重復')]));
}
}
unset($data['shops']);
unset($data['id']);
$models = $models::find($model->common_id);
$models->data($data)->save();
$del['shops'] = post_data('shops');
$model->where('common_id',post_data('common_id'))->delete();
foreach ($del['shops'] as $key => $value) {
$date['common_id'] = post_data('common_id');
$date['shop_id'] = $value;
$model->insert($date);
}
}else{
$list = yf_goods_common::where('common_code',$data['common_code'])->get()->toArray();
if($list){
foreach($list as $k=>$v){
$in[] = $v['id'];
}
$li = yf_goods_common::whereIn('common_id',$in)->first();
if($li){
exit(json_encode(['status'=>0,'msg'=>__('該條形編碼已存在，不可重復')]));
}
}
if($data['common_state'] == 1){
$data['common_sell_time'] = time();
}
$data['common_add_time'] = time();
$model = new yf_goods_common;
unset($data['shop_id']);
$model->data($data)->save();
$id = last_insert_id();
if($id){
$date['common_id'] = $id;
$dal['shops'] = post_data('shops');
$models = new self;
foreach ($dal['shops'] as $key => $value) {
$date['shop_id'] = $value;
$models->insert($date);
}
}
}
});
}catch(Exception $e){
return false;
}
return true;
}
>[info]3，刪除數據：刪除商品
/*
* @desc 刪除表單數據
*/
static function deleteForm($id){
$model = self::where('id',$id);
$model->delete();
}
>[info]4，通過`yf_goods_shop_common`關聯`yf_shop_base` 門店表 關聯商品隸屬哪家門店
/*
*獲取商品信息
*
*/
public function yf_goods_common(){
return $this->belongsTo('models\yf_goods_common','common_id');
}
/*
*獲取店鋪信息
*
*/
public function yf_shop_base(){
return $this->belongsTo('models\yf_shop_base','shop_id');
}
