app-api/app/Http/Controllers/OutGoodsController.php

<?php

namespace App\Http\Controllers;

use App\Models\Goods;
use App\Models\GoodSpec;
use App\Models\GoodSku;
use App\Models\OutGoods;
use App\Models\User;
use App\Models\GoodSkuTotal;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;

class OutGoodsController extends Controller{
    //获取下级代理
    public function getLowerLevelList(Request $request){
        $agent_id=Auth::user()->id;
        $search_name=$request->input('search_name');
        $page_index=$request->input('page_index');
        $page_size=$request->input('page_size');
        $num=$page_size*($page_index-1);
        $data=User::leftJoin('out_goods as og','users.id','og.user_id')
            ->where('users.agent_id',$agent_id)
            ->whereNull('users.deleted_at')
            ->where('users.status',0)->where('users.freeze_status',0)
            ->whereIn('users.cert_status',[3,6])->where('users.service_status',0)->where('users.in_group',1)
            ->select('users.id','users.nickname','users.mobile','users.level','users.headimgurl',DB::raw("sum(ifNull(og.num,0)) as num"));
        if($search_name){
            $data->where(function($query)use($search_name){
                $query->where('users.mobile','like','%'.$search_name.'%');
            });
        }
        $data->orderBy('num','desc')->orderBy('id','desc');
        $count=$data->count();
        $list=$data->skip($num)->take($page_size)
            ->get();
        return $this->success_list($list,'',$count);
    }

    //提交进货记录
    public function submitOutGoodsInfo(Request $request){
        $data['agent_id']=Auth::user()->id;
        $data['user_id']=$request->input('user_id');
        $data['num']=$request->input('num');
        $data['account']=$request->input('account');
        $data['sale_data']=json_encode($request->input('sale_data'));
        $data['amount_img']=json_encode($request->input('amount_img'));
        $res=OutGoods::create($data);
        if($res){
            return $this->success([]);
        }
        return $this->error();
    }

    //修改进货记录
    public function updateOutGoodsInfo(Request $request){
        $id=$request->input('id');
        $data['num']=$request->input('num');
        $data['account']=$request->input('account');
        $data['sale_data']=json_encode($request->input('sale_data'));
        $data['amount_img']=json_encode($request->input('amount_img'));
        $res=OutGoods::where('id',$id)->update($data);
        if($res){
            return $this->success([]);
        }
        return $this->error();
    }

    //删除进货记录
    public function deleteOutGoodsInfo(Request $request){
        $id=$request->input('id');
        $res=OutGoods::where('id',$id)->delete();
        if($res){
            return $this->success([]);
        }
        return $this->error();
    }

    //获取进货记录
    public function getOutGoodsInfo(Request $request){
        $id=$request->input('id');
        $res=OutGoods::with(['user:id,nickname,mobile,headimgurl,level','agent:id,nickname,mobile,headimgurl'])
            ->where('id',$id)->first();
        if($res){
            return $this->success($res);
        }
        return $this->error();
    }

    //获取代理进货记录
    public function getOutGoods(Request $request){
        $user_id=$request->input('user_id');
        $info=User::leftJoin('out_goods as og','users.id','og.user_id')
            ->where('users.id',$user_id)
            ->select('users.id','users.nickname','users.mobile','users.level','users.headimgurl',
                DB::raw("sum(ifNull(og.num,0)) as num"),DB::raw("sum(ifNull(og.account,0)) as account"))
            ->with(['out_goods'])
            ->first();
        return $this->success($info);
    }



}