seafood/app/Order.php

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2017/12/5
 * Time: 15:07
 */

namespace App;
use Illuminate\Database\Eloquent\Model;
use PHPExcel;
use PHPExcel_Writer_Excel2007;

class Order extends Model
{
    public $timestamps = false;
    protected $table = "order";
   
   	public static function olist(){
   		$result = Order::orderBy('id', 'desc')->get();
   		return json_decode(json_encode($result),true);
   	}

    /**
     * @param old_skus 只用于更新订单，计算sku变化
     * @param new_skus 
     * @param flag 1；录入，加占库存 -1：到卖家或删除，减占库存
     */
    public static function diffSkuToRedis($old_skus, $new_skus, $flag=1){
        $new_arr = array();
        foreach($new_skus as $k=>$v){
            if($flag == 1){
              $new_arr[$v['sku_id']] = $v['num'];
            }elseif($flag == -1){
              $new_arr[$v['sku_id']] = 0-$v['num'];
            }
        }

        if(!empty($old_skus)){
          $old_arr = array();
          foreach($old_skus as $k=>$v){
              $old_arr[$v['sku_id']] = $v['num'];
          }
  
          $res_arr = array();
          foreach($new_arr as $sku_id=>$num){
              if(isset($old_arr[$sku_id])){
                  if($old_arr[$sku_id] != $num){
                      $diff_num = $num - $old_arr[$sku_id];
                      unset($old_arr[$sku_id]);
                  }else{
                      unset($old_arr[$sku_id]);
                      continue;
                  }             
              }else{
                  $diff_num = $num;
              }
              $res_arr[$sku_id] = $diff_num;
          }

          if(!empty($old_arr)){
              foreach($old_arr as $k=>&$old_num){
                  $old_num = 0 - $old_num;
              }
              $res_arr = $res_arr + $old_arr;
          }
        }else{
          $res_arr = $new_arr;
        }
        $redis_table = config('constants.SKU_QUANTITY_TABLE');
        foreach($res_arr as $key => $val){
            //redis 存货号
            $code = GoodsSkus::where('id', $key)->pluck('code');
            $sku_redis_val = RedisModel::hGet($redis_table, $code);
            $sku_up_val = $sku_redis_val>0 ? ($sku_redis_val + $val) : $val;
            RedisModel::hSet($redis_table, $code, $sku_up_val);
        }
    }

    /**
     * 添加订单
     */
   	public static function mjOrderAdd($orderList){
   		$orderList["method"] = "maijiayun.order.add";
      //status格式
      $staus_arr = array(
        0 => '待付款',
        1 => '已付款待审核',
        2 => '已审核待发货',
        3 => '已发货',
      );
      $orderList['status'] = $staus_arr[$orderList['status']];
   		$result = self::mjApi($orderList);
   		return $result;
   	}

    /**
     * 更新订单
     */
    public static function mjOrderUpdate($orderList){
      $orderList["method"] = "maijiayun.order.update";
      $staus_arr = array(
        0 => '待付款',
        1 => '已付款待审核',
        2 => '已审核待发货',
        3 => '已发货',
        4 => '已取消',
      );
      $orderList['status'] = $staus_arr[$orderList['status']];
      $result = self::mjApi($orderList);
      return $result;
    }

    /**
     * 取消订单
     */
    public static function mjOrderDel($orderList){
      $orderList["method"] = "maijiayun.order.update"; 
      $orderList['status'] = '已取消';
      $result = self::mjApi($orderList);
      return $result;
    }
    

    /**
     * 获取订单
     */
    public static function mjOrderGet($order){
      $order["method"] = "maijiayun.order.get";
      $result = self::mjApi($order);
      return $result;
    }

    /**
     * 添加Erp商品
     */
    public static function mjErpGoodsAdd($goods){
      $goods["method"] = "maijiayun.goods.sku.add";
      $result = self::mjApi($goods);
      return $result;
    }

    /**
     * 添加商品
     */
    public static function mjGoodsAdd($goods){
      $goods["method"] = "maijiayun.eshop.goods.add";
      $result = self::mjApi($goods);
      return $result;
    }
  
    /**
     * 更新商品
     */
    public static function mjGoodsUpdate($goods){
      $goods["method"] = "maijiayun.eshop.goods.update";
      $result = self::mjApi($goods);
      return $result;
    }
    
    /**
     * 更新erp商品
     */
    public static function mjErpGoodsUpdate($goods){
      $goods["method"] = "maijiayun.goods.update";
      $result = self::mjApi($goods);
      return $result;
    }

    /**
     * 批量添加sku
     */
    public static function mjBatchSkuAdd($sku){
      $sku["method"] = "maijiayun.eshop.sku.batchAdd"; //批量添加
      //$sku["method"] = "maijiayun.eshop.sku.add";
      $result = self::mjApi($sku);
      return $result;
    }

    /**
     * 添加单个sku
     */
    public static function mjSkuAdd($sku){
      $sku["method"] = "maijiayun.eshop.sku.add";
      $result = self::mjApi($sku);
      return $result;
    }

    /**
     * 修改Erp sku
     */
    public static function mjErpSkuUpdate($sku){
      $sku["method"] = "maijiayun.goods.sku.update"; 
      $result = self::mjApi($sku);
      return $result;
    }

    /**
     * 修改shop sku
     */
    public static function mjSkuUpdate($sku){
      $sku["method"] = "maijiayun.eshop.sku.update"; 
      $result = self::mjApi($sku);
      return $result;
    }

    /**
     * 获取 sku 库存
     */
    public static function mjWarehouseSkuGet($sku){
      $sku["method"] = "maijiayun.warehouse.sku.list"; 
      $result = self::mjApi($sku);
      return $result;
    }

   	public static function mjApi($params = array()){  		
      $accessKey = "B1E69297B5DA44DAB35099A5F28F41D9"; //erp 生成的 accessKey
      $accessSecret = "4sN2LbylhOglelMP";
//   		$accessKey = "F82A757089D84F89B1782EDC3A4DA82A"; //erp 生成的 accessKey
//        $accessSecret = "wB2ueW8eQOHXNWcN";
	    $params["timestamp"] = time()."000";
	    $params["version"] = "v1";
	    $reqparams = $params;
	    ksort($reqparams);
	    $sign = "";
	    foreach($reqparams as $k=>$val){
	    if(is_array($val)){
	    $val = json_encode($val,320);
	    }
	    $sign.=$k.$val;
	    }
	    $params["accessKey"] = $accessKey;
	    $params["token"] = strtoupper(sha1($accessKey.$sign.$accessSecret));
	    $param = json_encode($params);

	    $ch = curl_init();
	    $headers = array("Content-type:application/json;charset='utf-8'","Accept:application/json", "Cache-Control: no-cache", "Pragma: no-cache");
	    curl_setopt($ch, CURLOPT_URL, "https://api.erp.maijiayun.cn"); //api 地址
	    curl_setopt($ch, CURLOPT_POST, 1); 
	    curl_setopt($ch, CURLOPT_TIMEOUT, 5); 
	    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); 
	    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); 
	    curl_setopt($ch, CURLOPT_POSTFIELDS, $param); 
	    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
	    $response = curl_exec($ch); 
	    curl_close($ch);
	    $response = json_decode($response, true);
      Log::errorLog($params,['mjApi_response'=>$response],"order/mjApi",1,'');
	    if (!$response || !is_array($response)) { 
	        return false;
	    }
	    if (!array_key_exists("isOk", $response)) { 
	        return false;
	    } elseif( $response['isOk'] == false){
//	        dd($response);
          Log::errorLog($params,['mjApi_response'=>$response],"order/mjApi",0,'');
          return false;
      } else {
	        return $response;
	    }
	}

	# 生成外部订单号
	public static function createOuterCode(){
        $prefix = config('constants.ORDER_PREFIX');
		$order_sn = $prefix.rand(100, 9999). substr(time(), 5, 5). rand(10, 9999);
		return $order_sn;
	} 

	/**
     * 导出excel
     * @param $data
     * @param string 
     */
    public static function export_excel($data, $filename = '未命名.xlsx', $indexKey, $title) {

        if( !is_array($indexKey)) return false;            
        $header_arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M', 'N','O','P','Q','R','S','T','U','V','W','X','Y','Z');  
        //初始化PHPExcel()  
        $objPHPExcel = new PHPExcel();            
        $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);    
            
        //接下来就是写数据到表格里面去  
        $objActSheet = $objPHPExcel->getActiveSheet();  
        foreach($title as $k=>$item){
            $objActSheet->setCellValue($header_arr[$k].'1',$item);
        }
        $startRow = 2;  
        foreach ($data as $row) {  
            foreach ($indexKey as $key => $value){  
                //这里是设置单元格的内容  
                $objActSheet->setCellValue($header_arr[$key].$startRow,$row[$value]);  
            }  
            $startRow++;  
        } 

        header("Pragma: public");  
        header("Expires: 0");  
        header("Cache-Control:must-revalidate, post-check=0, pre-check=0");  
        header("Content-Type:application/force-download");  
        header("Content-Type:application/vnd.ms-execl");  
        header("Content-Type:application/octet-stream");  
        header("Content-Type:application/download");;  
        header('Content-Disposition:attachment;filename='.$filename.'');  
        header("Content-Transfer-Encoding:binary");  
        $objWriter->save('php://output');  
        exit();
    }
}