seafood/app/Http/Controllers/Admin/GoodsControl...

<?php
/**
 * Created by Sublime.
 * User: hao
 * Date: 19/08/30
 * Time: 上午11:20
 */
namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Log;
use App\Goods;
use App\GoodsSkus;
use App\Order;
use App\Oplog;
use App\Services\OssServices as oss;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

use PHPExcel_Reader_Excel2007;
use PHPExcel_Reader_Excel5;
use PHPExcel_Reader_CSV;

class GoodsController extends Controller
{
	public function index(Request $request){
        $page = (int)$request->input('page');
        $pageSize = 20;
        if($page<=0){
            $page = 1;
        }

        $offset = ($page-1) * $pageSize;
        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $name = $request->input('name');
        $cate_name = trim($request->input('cate_name'));

        $count = Goods::where(function($query) use($name, $stime, $etime, $cate_name){
            if($name) $query->where('name', 'like', '%'.$name.'%');
            if($cate_name) $query->where('goodsCategoryName', '=', $cate_name);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
        })->count();
        if ($count > 1) {
            // 总页数
            $pages = ceil($count/$pageSize);
        }else{
            // 总页数
            $pages = 1;
        }

        $result = Goods::where(function($query) use($name, $stime, $etime, $cate_name){
            if($name) $query->where('name', 'like', '%'.$name.'%');
            if($cate_name) $query->where('goodsCategoryName', '=', $cate_name);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
        })->orderBy('id', 'desc')->offset($offset)->limit($pageSize)->get();
        $result = json_decode(json_encode($result),true);

        foreach($result as $k=>&$v){
            # 获取sku
            $skuList = GoodsSkus::where('goodsCode', $v['id'])->where('is_del', 0)->get();
            foreach($skuList as $k=>&$item){
                $item->quantity = GoodsSkus::actualQuantity($item->id);
            }
            $v['sku_list'] = $skuList;            
        }

        //获取分类
        $cates = DB::table('categorys')->lists('name', 'id');
        return view('goods/index', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,          
            'stime'             =>$stime,
            'etime'             =>$etime,
            'name'              =>$name,
            'cate_name'         =>$cate_name,
            'cates'             =>$cates,
            ]);
    }

    /**
     * 添加商品
     * @return \Illuminate\View\View
     */
    public function create(Request $request)
    {
        //获取分类
        $cates = DB::table('categorys')->lists('name', 'id');
        return view('goods/create', ['cates'=>$cates]);
    }
    /**
     * 分组管理-进行添加操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function store(Request $request)
    {       
        $cateVali = '';
        $goodsCategoryName = trim($request->input('goodsCategoryName'));
        $goodsCategoryName2 = trim($request->input('goodsCategoryName2'));
        if( empty($goodsCategoryName) && empty($goodsCategoryName2) ){
            $cateVali = 'required';
        }

        $this->validate($request, [  
            'name'           => 'required|unique:goods',   
            'productCode'           => 'required|unique:goods,productCode,1,is_del',     
            'sku'           => 'required',     
            'goodsCategoryName2'           => $cateVali,     
        ], [                                                              
            'name.required'           => '商品名不能为空',
            'name.unique'           => '该商品已存在',
            'productCode.required'           => '商品货号不能为空',          
            'productCode.unique'           => '该商品货号已经存在',          
            'sku.required'    => '必须添加商品规格',    
            'goodsCategoryName2.required' => '商品分类必填',     
        ]);

        //数据库-新增数据
        $goods = array();       
        $goods['name'] = trim($request->input('name')); 
        $goods['description'] = trim($request->input('description'));  //非必填
        $goods['eshopCode'] = config('constants.ESHOP_CODE'); 
        $goods['productCode'] = trim($request->input('productCode')); 

        DB::beginTransaction();
        try{
            if( !empty($goodsCategoryName2) ){
                //增加分类
                $cates = array();
                $cates['name'] = $goodsCategoryName2;
                DB::table('categorys')->insert($cates);
                $goodsCategoryName = $goodsCategoryName2;
            }
            $goods['goodsCategoryName'] = $goodsCategoryName; 

            //图片上传 阿里云oss       
            if ($request->hasFile('img') && $request->file('img')->isValid()) {
                $file = $request->file('img');
                $ossClient=new oss();
                // 上传阿里云
                $file = $ossClient->upload($file->getClientOriginalExtension(), $file->getRealPath(), 'upload/seafoodPic'.date("Y-m-d",time()).'/'.date('His'));
                $img=$file['oss-request-url'];
                $goods['picUrl']=str_replace("kx-youhuiquan.oss-cn-beijing.aliyuncs.com","imgs.726p.com",$img);
            }
            if( !isset($goods['picUrl']) ) $goods['picUrl'] = 'http://imgs.726p.com/tbk/upload/seafoodPic2019-10-14/151513/kx-5da4208175314.jpg'; 
            
            $res = DB::table('goods')->insertGetId($goods); 
            if($res){
                //卖家云必要参数拼接转化
                $mjArr = $goods;
                $mjArr['outerCode'] = $res;

                //sku
                $sku = $request->input('sku');
                if(!empty($sku)){
                    foreach($sku as $key=>$item){
                        $sku_data = explode('@@', $item);  
                        if(!$sku_data[2]) $sku_data[2] = null;                      
                        if(!$sku_data[3]) $sku_data[3] = null;                                            
                        $sku_insert_data = $mjArr['skuList'][$key] = ['propsName'=>$sku_data[0], 'price'=>$sku_data[1], 'tagPrice'=>$sku_data[2], 'referenceCost'=>$sku_data[3], 'is_weigh'=>$sku_data[4], 'createTime'=>date('Y-m-d H:i:s'), 'modifyTime'=>date('Y-m-d H:i:s')];
                        $skuProductCode = $goods['productCode'].'-0'.($key+1);
                        $sku_insert_data['code'] = $mjArr['skuList'][$key]['skuProductCode'] = $skuProductCode;
                        $sku_insert_data['goodsCode'] = $res;
                        $sku_insert_data['eshopCode'] = config('constants.ESHOP_CODE');

                        $sku_ids = DB::table('goods_skus')->insertGetId($sku_insert_data);
                        $mjArr['skuList'][$key]['outerCode'] = $sku_ids;
                    }
                }

                //对接卖家云
                //1.erp添加
                $erpArr = array();
                $erpArr['goodsCode'] = $goods['productCode']; //商品货号
                $erpArr['goodsName'] = $goods['name'];
                $erpArr['goodsCategoryName'] = $goods['goodsCategoryName'];
                $erpArr['picUrl'] = $goods['picUrl'];
                foreach($mjArr['skuList'] as $k=>&$v){
                    $erpArr['code'] = $v['skuProductCode'];                   
                    $is_weigh = $v['is_weigh'];
                    $erpArr['propsName'] = $is_weigh==1 ? $v['propsName'].'【按半斤称重】' : $v['propsName'];
                    $erpArr['price'] = $v['price'] = $is_weigh==1 ? round( $v['price']/2, 2 ) : $v['price'];
                    $erpArr['tagPrice'] = $is_weigh==1 ? round( $v['tagPrice']/2, 2 ) : $v['tagPrice'];
                    $erpArr['referenceCost'] = $is_weigh==1 ? round( $v['referenceCost']/2, 2 ) : $v['referenceCost']; 

                    $erp = Order::mjErpGoodsAdd($erpArr);
                    if($erp == false){
                        throw new Exception("添加erp商品失败，对接卖家云出错");                                              
                    }
                    unset($mjArr['skuList'][$k]['tagPrice']);
                    unset($mjArr['skuList'][$k]['referenceCost']);
                    unset($mjArr['skuList'][$k]['is_weigh']);

                    //更新erp信息到sku
                    $params = array();
                    $params['erpSkuId'] = $erp['skuId'];
                    $params['erpGoodsId'] = $erp['goodsId'];
                    $uperp = DB::table('goods_skus')->where('id', $v['outerCode'])->update($params);
                }
                //2.商品同步
                $mj = Order::mjGoodsAdd($mjArr);              
                if($mj == false){
                    throw new Exception("添加店铺商品失败，对接卖家云出错");
                }
                /* 同步卖家云商品code等信息 */
                $mjGood = array();
                $mjGood['code'] = $mj['goods']['code'];
                Goods::where('id', $res)->update($mjGood);
                /* end */
                #记录操作日志
                $self_id = session('admin_id');
                $self_name = session('real_name');
                $context = "新增商品数据";
                $type = 0; 
                $tables = 'goods,goods_skus';
                $data_id = $res;
                Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            } 
            DB::commit();

        }catch (Exception $e){
            Log::errorLog($request,['error'=>$e->getMessage()],"goods/store",0,'');
            DB::rollback();
            return redirect('/admin/goods/index')->with('info', $e->getMessage());
        }
        return redirect('/admin/goods/index')->with('info', '添加成功'); 
       
    }

    /**
     * 分组管理-编辑分组界面
     * @param $id
     * @return \Illuminate\View\View
     */
    public function edit($id,Request $request)
    {
        
        $data = Goods::where('id', $id)->first();
        $sku =  GoodsSkus::where('goodsCode', $id)->where('is_del', 0)->get();
        return view('goods/edit', [         
            'goods' => $data,
            'sku_list' => $sku,
            'id' => $id,
        ]);

    }

    /**
     * 分组管理-进行编辑操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function update(Request $request)
    {    
        $id = (int)$request->input('id');
        $this->validate($request, [  
            'id'             => 'required',
            'name'           => 'required',   
            //'productCode'           => 'required|unique:goods,productCode,'.$id.',id',     
        ], [       
            'id'             => '非法操作',                                                       
            'name.required'           => '商品名不能为空',
            //'productCode.required'           => '商品货号不能为空',                                                                        
        ]);

        $del_sku_ids = trim($request->input('del_sku_ids'),',');
        $sku = $request->input('sku');
        //数据库-修改数据
        $goods = array();       
        $goods['name'] = trim($request->input('name')); 
        $goods['description'] = trim($request->input('description'));  //非必填
        //$goods['productCode'] = trim($request->input('productCode'));  
        //$goods['goodsCategoryName'] = trim($request->input('goodsCategoryName'));  
        //图片上传 阿里云oss       
        if ($request->hasFile('img') && $request->file('img')->isValid()) {
            $file = $request->file('img');
            $ossClient=new oss();
            // 上传阿里云
            $file = $ossClient->upload($file->getClientOriginalExtension(), $file->getRealPath(), 'upload/seafoodPic'.date("Y-m-d",time()).'/'.date('His'));
            $img=$file['oss-request-url'];
            $goods['picUrl']=str_replace("kx-youhuiquan.oss-cn-beijing.aliyuncs.com","imgs.726p.com",$img);
        } 

        DB::beginTransaction();
        try{
            $res = DB::table('goods')->where('id', $id)->update($goods); 
            if($res){
                //卖家云必要参数拼接转化
                $mjArr = array();
                $mjArr['eshopCode'] = config('constants.ESHOP_CODE');
                $mjArr['outerCode'] = $id;
                $mjArr['name'] = $goods['name'];
                $mjArr['description'] = $goods['description'];
                $mj = Order::mjGoodsUpdate($mjArr);

                
                //更新erp
                $erpArr = array();
                $goodsId = GoodsSkus::where('goodsCode', $id)->where('erpGoodsId','>',0)->first();
                if(!empty($goodsId)){
                    $erpArr['goodsId'] = $goodsId->erpGoodsId;
                    $erpArr['goodsName'] = $goods['name'];
                    $mj = Order::mjErpGoodsUpdate($erpArr);
                }
                

                #记录操作日志
                $self_id = session('admin_id');
                $self_name = session('real_name');
                $context = "修改商品数据";
                $type = 0; 
                $tables = 'goods,goods_skus';
                $data_id = $id;
                Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);

            }else{
                DB::rollback();
                return redirect('/admin/goods/index')->with('info', '未做任何修改');
            } 

            DB::commit();

        }catch (Exception $e){
            DB::rollback();
            Log::errorLog($request,['error'=>$e->getMessage()],"goods/update",0,'');
        }
      
        return redirect('/admin/goods/index')->with('info', '更新成功');       
    }

    /**
     * 下架操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function delete($id)
    {
        $goods = Goods::find($id);
        $goods->is_del = 1;
        if ($goods ->save()){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');            
            $context = "下架商品";
            $type = 0; 
            $tables = 'goods';
            $data_id = $id;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            exit('1');
        }
        exit('0');
    }

    /**
     * 上架操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function up($id)
    {
        $goods = Goods::find($id);
        $goods->is_del = 0;
        if ($goods ->save()){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');            
            $context = "上架商品";
            $type = 0; 
            $tables = 'goods';
            $data_id = $id;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            exit('1');
        }
        exit('0');
    }

    /**
     * 搜索商品
     */
    public function searchSkus(Request $request){
        $name = trim($request->input('name'));
        $result = Goods::select('gs.id as sku_id', 'goods.id as goods_id', 'goods.name', 'gs.propsName', 'gs.price', 'gs.is_weigh', 'gs.quantity', 'gs.is_white')->leftJoin('goods_skus as gs', 'gs.goodsCode', '=', 'goods.id')->where('goods.name', 'like', '%'.$name.'%')->where('goods.is_del', 0)->where('gs.is_del', 0)->orderBy('goods.id', 'desc')->get();
        $result = json_decode(json_encode($result), true);
        foreach($result as $k=>&$v){
            //计算实际库存 -还未到卖家云的量
            $v['quantity'] = GoodsSkus::actualQuantity($v['sku_id']);
        }

        if(empty($result)) exit('0');
        exit(json_encode($result));
    }

    /**
     * 单个商品sku列表
     */
    public function skuList(Request $request){
        $goods_id = $request->input('goods_id');
        $result = GoodsSkus::where('goodsCode', $goods_id)->orderBy('id', 'desc')->get();
        foreach($result as $k=>&$item){           
            $item->quantity = GoodsSkus::actualQuantity($item->id);
        }
        return view('/goods/skulist', ['result'=>$result, 'goods_id' => $goods_id]);
    }

    /**
     * @return \Illuminate\View\View
     */
    public function skuCreate(Request $request)
    {
        $goods_id = $request->input('goods_id');
        return view('goods/skucreate', ['goods_id'=>$goods_id]);
    }

    /**
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function skuStore(Request $request)
    {
        $this->validate($request, [
            'propsName' => 'required',
            'price' => 'required',
        ], [
            'propsName.required' => '规格不能为空',
            'price.required' => '价格不能为空',
        ]);
        $goods_id = (int)$request->input('goods_id');
        $data = array();
        $data['goodsCode'] = $goods_id;
        $data['eshopCode'] = config('constants.ESHOP_CODE');
        $data['propsName'] = $request->input('propsName');
        $data['price'] = $request->input('price');
        $data['tagPrice'] = $request->input('tagPrice');
        $data['referenceCost'] = $request->input('referenceCost');
        $data['is_weigh'] = (int)$request->input('is_weigh');

        //获取code
        //获取最大skucode
        $lastSku = DB::table('goods_skus')->select('code', 'erpGoodsId', 'eshopCode', 'goodsCode')->where('goodsCode', $goods_id)->orderBy('id', 'desc')->first();
       
        $code_arr = explode('-', $lastSku->code);
        $code_auto_num = (int)$code_arr[1];
        $pro_code = $code_arr[0];

        $data['code'] = $pro_code. '-0'. ($code_auto_num+1);

        DB::beginTransaction();
        try{
            $res = DB::table('goods_skus')->insertGetId($data);

            if($res){
                //增加erp sku
                $erpArr = array();
                $erpArr['goodsId'] = $lastSku->erpGoodsId; //erp商品id
                $erpArr['code'] = $data['code'];               
                if($data['is_weigh'] == 1){
                    $erpArr['propsName'] = $data['propsName'].'【按半斤称重】';
                    $erpArr['price'] = round( $data['price']/2, 2 );
                    $erpArr['tagPrice'] = round( $data['tagPrice']/2, 2 );
                    $erpArr['referenceCost'] = round( $data['referenceCost']/2, 2 );
                }else{
                    $erpArr['propsName'] = $data['propsName'];
                    $erpArr['price'] = $data['price'];
                    $erpArr['tagPrice'] = $data['tagPrice'];
                    $erpArr['referenceCost'] = $data['referenceCost'];
                }
                $erp = Order::mjErpGoodsAdd($erpArr);
                if( $erp == false ){
                    throw new Exception("erpSku同步到卖家云失败");
                }

                //更新erp信息到sku
                $params = array();
                $params['erpSkuId'] = $erp['skuId'];
                $params['erpGoodsId'] = $erp['goodsId'];
                $uperp = DB::table('goods_skus')->where('id', $res)->update($params);

                //增加shop sku
                $shopArr = array();
                $shopArr['outerCode'] = $res;
                $shopArr['eshopCode'] = $lastSku->eshopCode;
                $shopArr['goodsCode'] = $lastSku->goodsCode;
                $shopArr['propsName'] = $data['propsName'];
                $shopArr['price'] = $erpArr['price'];
                $shopArr['skuProductCode'] = $data['code'];
                $shopArr['createTime'] = date('Y-m-d H:i:s');
                $shopArr['modifyTime'] = $shopArr['createTime'];

                $sku_add = Order::mjSkuAdd($shopArr);
                if( $sku_add == false ){
                    throw new Exception("店铺商品Sku同步到卖家云失败");
                }

            }

            DB::commit();
        }catch (Exception $e){
            DB::rollback();
            Log::errorLog($request,['error'=>$e->getMessage()],"sku/store",0,'');
            return redirect('/admin/goods/skulist?goods_id='.$goods_id)->with('info', $e->getMessage());
        }

        return redirect('/admin/goods/skulist?goods_id='.$goods_id)->with('info', '添加成功');
    }

    /**
     * @param $id
     * @return \Illuminate\View\View
     */
    public function skuEdit($id, Request $request)
    {
        $sku = DB::table('goods_skus')->where('id', $id)->first();
        $sku = json_decode(json_encode($sku),true);
        return view('goods/skuedit', ['sku' => $sku, 'goods_id' => $sku['goodsCode']]);
    }

    /**
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function skuUpdate(Request $request)
    {
        $this->validate($request, [
            'propsName' => 'required',
            'price' => 'required',
        ], [
            'propsName.required' => '规格不能为空',
            'price.required' => '价格不能为空',
        ]);
        $id = (int)$request->input('id');
        $goods_id = (int)$request->input('goods_id');
        $data = array();
        $data['propsName'] = $request->input('propsName');
        $data['price'] = $request->input('price');
        $data['tagPrice'] = $request->input('tagPrice');
        $data['referenceCost'] = $request->input('referenceCost');       
        $data['is_weigh'] = (int)$request->input('is_weigh');
       
        DB::beginTransaction();
        try{
            $res = DB::table('goods_skus')->where('id', $id)->update($data);

            if($res){
                # erp sku更新
                $sku = DB::table('goods_skus')->where('id', $id)->first();
                $erpArr = array();
                $erpArr['skuId'] = $sku->erpSkuId;               
                if($data['is_weigh'] == 1){
                    $erpArr['propsName'] = str_replace('【按半斤称重】', '', $sku->propsName).'【按半斤称重】';
                    $erpArr['price'] = round( $sku->price/2, 2 );
                    $erpArr['tagPrice'] = round( $sku->tagPrice/2, 2 );
                    $erpArr['referenceCost'] = round( $sku->referenceCost/2, 2 );
                }else{
                    $erpArr['propsName'] = str_replace('【按半斤称重】', '', $sku->propsName);
                    $erpArr['price'] = $sku->price;
                    $erpArr['tagPrice'] = $sku->tagPrice;
                    $erpArr['referenceCost'] = $sku->referenceCost;
                }
                
                $erp_up = Order::mjErpSkuUpdate($erpArr);
                if( $erp_up == false ){
                    throw new Exception("erpSku更新同步到卖家云失败");
                }

                # eshop sku更新
                $shopArr = array();
                $shopArr['eshopCode'] = $sku->eshopCode;
                $shopArr['goodsCode'] = $sku->goodsCode;
                $shopArr['outerCode'] = $sku->id;
                $shopArr['propsName'] = $sku->propsName;
                $shopArr['price'] = $erpArr['price'];

                $sku_up = Order::mjSkuUpdate($shopArr);
                if( $sku_up == false ){
                    throw new Exception("店铺商品Sku更新同步到卖家云失败");
                }
            }

            DB::commit();
        }catch (Exception $e){
            DB::rollback();
            Log::errorLog($request,['error'=>$e->getMessage()],"sku/update",0,'');
            return redirect('/admin/goods/skulist?goods_id='.$goods_id)->with('info', $e->getMessage());
        }
            
        return redirect('/admin/goods/skulist?goods_id='.$goods_id)->with('info', '修改成功');
    }

    /**
     * 进行下架操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function skuDel($id)
    {
        $goods = GoodsSkus::find($id);
        $goods->is_del = 1;
        if ($goods ->save()){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');            
            $context = "下架sku";
            $type = 0; 
            $tables = 'goods_skus';
            $data_id = $id;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            exit('1');
        }
        exit('0');
    }

    /**
     * 进行上架操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function skuUp($id)
    {
        $goods = GoodsSkus::find($id);
        $goods->is_del = 0;
        if ($goods ->save()){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');            
            $context = "上架sku";
            $type = 0; 
            $tables = 'goods_skus';
            $data_id = $id;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            exit('1');
        }
        exit('0');
    } 

}