<?php
include_once(CORE_DIR.'/api/shop_api_object.php');
class api_b2b_1_0_product extends shop_api_object {
    var $api_type="native_api";
    var $max_number=200;
    var $app_error=array(
            'synchronization error no goods info'=>array('no'=>'b_product_001','debug'=>'','level'=>'warning','info'=>'同步订单商品数据不存在','desc'=>'','debug'=>''),
            'goods not exists'=>array('no'=>'b_product_002','debug'=>'','level'=>'warning','info'=>'订单商品不存在','desc'=>'','debug'=>''),
            'product not exists'=>array('no'=>'b_product_004','debug'=>'','level'=>'warning','info'=>'订单货品不存在','desc'=>'','debug'=>''),
            'goods can not publish'=>array('no'=>'b_product_005','debug'=>'','level'=>'warning','info'=>'订单商品未发布不能下单','desc'=>'','debug'=>''),
            'goods price is not equal to the suppliers price'=>array('no'=>'b_product_005','debug'=>'','level'=>'warning','info'=>'订单货品价格与供货商价格不一致','desc'=>'','debug'=>''),
            'goods have not bn'=>array('no'=>'b_product_006','debug'=>'','level'=>'warning','info'=>'订单货品无库存','desc'=>'','debug'=>''),
            'goods have not delieve bn'=>array('no'=>'b_product_007','debug'=>'','level'=>'warning','info'=>'订单货品没有可下单库存','desc'=>'','debug'=>'')
    );
    function getColumns(){
        $columns=array(
            'goods_id'=>array('type'=>'int'),
            'title'=>array('type'=>'string'),
            'bn'=>array('type'=>'int'),
            'price'=>array('type'=>'int'),
            'cost'=>array('type'=>'int'),
            'name'=>array('type'=>'string'),
            'weight'=>array('type'=>'int'),
            'unit'=>array('type'=>'string'),
            'store'=>array('type'=>'int'),
            'pdt_desc'=>array('type'=>'string'),
            'props'=>array('type'=>'string'),
            'last_modify'=>array('type'=>'int')
        );
        return $columns;
    }
   
     /**
     * 获取循单操作
     *
     * @param array $data 
     *
     * @return 循单操作
     */
    function search_product_by_bn($data){
        $result['alert_num'] = $this->system->getConf('system.product.alert.num');
        $products = array();
        $product_list = json_decode($data['bns']);
        $dealer_id = $data['dealer_id'];
        $arr_goods_list = array();  
        $obj_member = $this->load_api_instance('verify_member_valid','1.0');    
        $obj_member->verify_member_valid($dealer_id,$member);//根据经销商ID验证会员记录有效性
        
        foreach($product_list as $bn){
            $status = 'normal';
            if($product = $this->db->selectrow('select goods_id,price,store,freez from sdb_products where bn="'.$bn.'"')){
               if(!isset($arr_goods_list[$product['goods_id']])){
                  $goods = $this->db->selectrow('select goods_id,cat_id,brand_id,marketable,disabled from sdb_goods where goods_id='.$product['goods_id']);
                  if($goods){
                     $arr_goods_list[] = $goods;
                  }
                 
               }else{
                  $goods = $arr_goods_list[$product['goods_id']];
               }
               
               if(!$goods || $goods['disabled'] == 'true'){
                  $status = 'deleted';
               }
               
               if($goods['marketable'] == 'false'){
                  $status = 'shelves';
               }
               
               if(is_null($product['store'])){
                   $product['store'] = $product['store'];
               }else{
                   $product['store'] = $product['store'] - $product['freez'];
               }
              
               unset($product['freez']);
            }else{
              $status = 'deleted';
            } 
             
            if(isset($product['goods_id'])){
                unset($product['goods_id']);
            }
            $product['bn'] = $bn;
            $product['status'] = $status;
            $products[] = $product;        
        }    
    
        $obj_product_line = $this->load_api_instance('search_product_line','1.0');    
        $obj_product_line->checkDealerPurview($member,$arr_goods_list);//检查会员的代销权限
        
        $result['data_info'] = $products;
     
        $this->api_response('true',false,$result);
    }
    
    /**
     * 下采购单过滤无效的商品数据,并组织数据提供给order_item
     *
     * @param array $member 
     * @param array $arr_order_item 
     *
     * @return boolean
     */
    function filter_product_invalid($member,$arr_order_item,& $filter_order_item){
        if(is_array($arr_order_item) && count($arr_order_item)>0){
            safeVar($arr_order_item);
            $arr_goods = array();
            $is_buy = false;
            foreach($arr_order_item as $k=>$order_item){
                $product = $this->db->selectrow('select goods_id,product_id,store,freez,pdt_desc,name,weight,cost,price,disabled from sdb_products where bn="'.$order_item['supplier_bn'].'"'); 
                if(!$product){//验证订单货品是否存在
                    $this->api_response('fail','data fail',$result,'订单货品('.$order_item['supplier_bn'].')不存在');
                }
                
                if(!isset($arr_goods[$product['goods_id']])){
                    $goods = $this->db->selectrow('select goods_id,cat_id,brand_id,type_id,marketable,disabled from sdb_goods where goods_id='.intval($product['goods_id']));     
                    if(!$goods){//验证订单货品的商品是否存在
                        $this->api_response('fail','data fail',$result,'订单商品('.$product['goods_id'].')不存在');
                    }
                    $arr_goods[$product['goods_id']] = $goods;
                }
                
                if($arr_goods[$product['goods_id']]['marketable'] == 'false' || $arr_goods[$product['goods_id']]['disabled'] == 'true'){//验证订单商品是否发布
                    $this->api_response('fail','data fail',$result,'订单商品('.$product['goods_id'].')未发布不能下单');
                }
            
                if($product['disabled'] == 'true'){//验证订单货品是否发布
                     $this->api_response('fail','data fail',$result,'订单货品('.$order_item['supplier_bn'].')未发布不能下单');
                }
                
                if($product['price'] != $order_item['price']){//验证订单价格与供货商价格是否一致
                    $this->api_response('fail','data fail',$result,'订单货品('.$order_item['supplier_bn'].')供应商价格或者库存变动，请重新询价后下单');
                }
                
                $product['freez'] = !is_null($product['freez']) ? $product['freez'] :0;
                if($product['store'] === 0){//验证订单上货品是否有库存
                    //$this->api_response('fail','data fail',$result,'订单货品('.$order_item['supplier_bn'].')无库存');
                    continue;
                }
                
                if(!is_null($product['store'])){
                    if(($product['store'] - $product['freez']) <=0){//检查货品是否有可下单库存
                        //$this->api_response('fail','data fail',$result,'订单货品('.$order_item['supplier_bn'].')没有可下单库存');
                        continue;
                    }
                }
                
                if(!is_null($product['store'])  && ($order_item['nums'] > ($product['store'] - $product['freez'])) ){
                    $order_item['nums'] = $product['store'] - $product['freez'];//有多少库存就下多少库存
                }    
                
                $product = array_merge($product,$order_item);
                $product['type_id'] = $goods['type_id'];//商品类型ID
                $product['amount'] = $order_item['nums'] * $order_item['price'];//货品总价
                $product['amount_weight'] = $order_item['nums'] * $product['weight'];//货品总重
                $product['score'] = 0;//积分默认为0
                $product['bn'] = $order_item['supplier_bn'];//经销商货号
                $product['name'] = $product['pdt_desc'] ? $product['name'].'('.$product['pdt_desc'].')' : $product['name'];
                $is_buy = true;
                
                unset($product['store']);
                unset($product['freez']);
                
                $filter_order_item[$k] = $product;          
            }
        
            if(!$is_buy){
                $this->api_response('fail','data fail',$result,'供应商价格或者库存变动，请重新询价后下单');
            }
            
            $obj_product_line = $this->load_api_instance('search_product_line','1.0');    
            $obj_product_line->checkDealerPurview($member,$arr_goods);//检查会员的代销权限
        }else{
            $this->api_response('fail','data fail',$result,'同步订单商品数据不存在');
        }
    }
    
     /**
     * 冻结库存
     *
     * @param int $product_id 
     * @param int $store 
     *
     * @return 冻结库存
     */
    function update_product_store($bn,$store,$flag='freeze'){
        //safeVar($data);
         if($flag == 'freeze'){
             $this->db->exec('UPDATE sdb_products SET freez = freez + '.intval($store).' WHERE bn = "'.$bn.'"');
            $this->db->exec('UPDATE sdb_products SET freez = 0 WHERE bn = "'.$bn.'" AND freez IS NULL');
         }else{
             $product = $this->db->selectrow('select product_id,store,freez from sdb_products where bn="'.$bn.'"'); 
            if($product){
                $freez = $product['freez'];
                if($freez < $store){
                    $this->db->exec('UPDATE sdb_products SET freez = 0 WHERE bn = "'.$bn.'"');
                }else{
                    $this->db->exec('UPDATE sdb_products SET freez = freez - '.intval($store).' WHERE bn = "'.$bn.'"');
                }
            }
         }     
    }
    
     /**
     * 解冻冻结库存
     *
     * @param int $product_id 
     * @param int $store 
     *
     * @return 解冻冻结库存
     */
    function freeze_product_store($bn,$store){
        // $this->db->exec('UPDATE sdb_products SET freez = freez + '.intval($store).' WHERE bn = "'.$bn.'"');
    }
    
    /**
     * 更新货品字段
     *
     * @param int $product_id 
     * @param array $aData 
     *
     * @return 更新货品字段
     */
    function update_product($product_id,$aData){
        $rs = $this->db->exec("SELECT * FROM sdb_products WHERE product_id=".intval($product_id));
        $sSql = $this->db->getUpdateSQL($rs,$aData);
        $this->db->exec($sSql);
    }
    
    /**
     * 更新商品字段
     *
     * @param int $goods_id 
     * @param array $aData 
     *
     * @return 更新商品字段
     */
    function update_goods($goods_id,$aData){
        $rs = $this->db->exec("SELECT * FROM sdb_goods WHERE goods_id=".intval($goods_id));
        $sSql = $this->db->getUpdateSQL($rs,$aData);
        $this->db->exec($sSql);
    }
    
    /**
     * 根据订单商品对商品货品库存进行计算
     *
     * 
     * @param array $order_item_list 
     *
     * @return 根据订单商品对商品货品库存进行计算
     */
    function update_store_by_orderitem($order_item_list){
        $arr_goods_id = array();
        $arr_goods = array();
        foreach($order_item_list as $order_item){
            $products = $this->db->selectrow('select goods_id,store,freez from sdb_products where product_id='.intval($order_item['product_id']));    
             if(!$products){
                 continue;
             }
             
             $update_product_store = array();
             if(!is_null($products['store'])){
                if($products['store'] >= $order_item['nums']){
                   $update_product_store['store'] = $products['store'] - $order_item['nums'];//减去实际库存
                }else{
                   $update_product_store['store'] = 0;//订单货品数量买光了所有库存
                }
             }
             
             if(!is_null($products['freez'])){
                if($products['freez'] >= $order_item['nums']){
                   $update_product_store['freez'] = $products['freez'] - $order_item['nums'];//减去冻结库存
                }else{
                   $update_product_store['freez'] = 0;//订单货品数量买光了所有库存
                }
             }
             
             if(!empty($update_product_store)){
                $this->update_product($order_item['product_id'],$update_product_store);
             }
             
             //收集减少的商品库存
             if(isset($arr_goods_id[$products['goods_id']])){
                 $arr_goods_id[$products['goods_id']] += $order_item['nums'];
             }else{
                 $arr_goods_id[$products['goods_id']] = $order_item['nums'];
             }            
            
        }
        //整理商品库存
        if(!empty($arr_goods_id)){
            foreach($arr_goods_id as $goods_id=>$store){
                 $goods = $this->db->selectrow('select store from sdb_goods where goods_id='.intval($goods_id));
                 if(!$goods){
                     continue;
                 } 
                 
                 if(!is_null($goods['store'])){
                    if($goods['store'] > $store){
                       $update_goods_store['store'] = $goods['store'] - $store;
                    }else{
                       $update_goods_store['store'] = 0;
                    }
                    $this->update_goods($goods_id,$update_goods_store);
                 }
            }         
        }
        
        return true;    
    }
    


}