/aoliz/core/api/productline/1.0/api_b2b_1_0_productline.php

<?php

include_once(CORE_DIR.'/api/shop_api_object.php');

class api_b2b_1_0_productline extends shop_api_object {

    var $app_error=array(

            'member has not sell permission'=>array('no'=>'b_productline_001','debug'=>'','level'=>'warning','info'=>'???????','desc'=>'','debug'=>''),

            'member has not product line'=>array('no'=>'b_productline_002','debug'=>'','level'=>'warning','info'=>'?????????','desc'=>'','debug'=>''),

            'serivce data error'=>array('no'=>'b_productline_003','debug'=>'','level'=>'warning','info'=>'??????','desc'=>'','debug'=>''),

            'member has not set sell permission'=>array('no'=>'b_productline_004','debug'=>'','level'=>'warning','info'=>'??????????','desc'=>'','debug'=>'')



    );



    function getColumns(){

        $columns=array(

            'pline_id'=>array('type'=>'int'),

            'pline_name'=>array('type'=>'string'),

            'custom_name'=>array('type'=>'string'),

            'disabled'=>array('type'=>'string'),

            'cat_id'=>array('type'=>'int'),

            'brand_id'=>array('type'=>'int'),

            'last_modify'=>array('type'=>'int')     

        );

        return $columns;

    }

    

    /**

     * ????????

     *

     * @param array $data 

     *

     * @return ??????

     */

    function search_product_line($data){

        $data['disabled'] = 'false'; 

        $data['orderby'] = 'pline_id'; 

        $where = $this->before_filter($data);

        $result = $this->db->selectrow('select count(*) as all_counts from sdb_product_line where '.implode(' and ',$where));

        $result['last_modify_st_time'] = $data['last_modify_st_time'];

        $result['last_modify_en_time'] = $data['last_modify_en_time'];        

        $where =$this->_filter($data);

        $data_info = $this->db->select('select '.implode(',',$data['columns']).' from sdb_product_line'.$where);

        $result['counts'] = count($data_info);  

        $result['data_info'] = $data_info;

        $this->api_response('true',false,$result);

    }

    

    /**

     * ???????????

     *

     * @param array $data 

     *

     * @return ?????????

     */

    function search_product_line_dealer($data){

        $data['orderby'] = 'member_id'; 

        $where = $this->before_filter($data);

        $result = $this->db->selectrow('select count(*) as all_counts from sdb_pline_to_dealer where '.implode(' and ',$where));

        $where =$this->_filter($data);

        $pline_to_dealer_list = $this->db->select('select member_id,pline_id,last_modify from sdb_pline_to_dealer'.$where);

     

        if($pline_to_dealer_list){

            $arr_certificate_id = array();

            

            foreach($pline_to_dealer_list as $k=>$pline_to_dealer){

                if(!isset($arr_certificate_id[$pline_to_dealer['member_id']])){

                    $member = $this->db->selectrow('select certificate_id from sdb_members where member_id='.$pline_to_dealer['member_id']); 

                    $arr_certificate_id[$pline_to_dealer['member_id']] = $member['certificate_id'];

                    $dealer_id = $member['certificate_id'];

                }else{

                    $dealer_id = $arr_certificate_id[$pline_to_dealer['member_id']];

                }

                $pline_to_dealer_list[$k]['dealer_id'] = $dealer_id;

                unset($pline_to_dealer_list[$k]['member_id']);

            }

        }

        

        $data_info = $pline_to_dealer_list;

        

        $result['counts'] = count($data_info);

        $result['data_info'] = $data_info;

        $this->api_response('true',false,$result);

    }

    

    function before_filter($filter){

        $where = array(1);

        if(isset($filter['last_modify_st_time'])){

            $where[]='last_modify >='.intval($filter['last_modify_st_time']);

        }

        if(isset($filter['last_modify_en_time'])){

            $where[]='last_modify <'.intval($filter['last_modify_en_time']);

        }

        if(isset($filter['disabled'])){

            $where[]='disabled="'.$filter['disabled'].'"';

        }

        

        return $where;

    }

     

    function _filter($filter){

        $where = $this->before_filter($filter);

        

        return parent::_filter($where,$filter);

    }

    

    function getPlineListByMember($nMId){

        return $this->db->select('SELECT member_id,pline_id,last_modify FROM sdb_pline_to_dealer WHERE member_id = '.$nMId);

    }

    

    function getInfo($pline_id){

       return $this->db->selectRow("SELECT * FROM sdb_product_line WHERE pline_id=".intval($pline_id));

    }

    

    /**

     * ?????????

     *

     * @param array $member 

     * @param array $arr_goods 

     *

     * @return ?????????

     */

    function checkDealerPurview($member='',$arr_goods){

        if(!is_array($arr_goods) || count($arr_goods)<0)return false;

        

        $dealer_purview = $member['dealer_purview'];

        $arr_dealer_purview = array(0,1,2,3);

        if(!empty($member) && in_array($dealer_purview,$arr_dealer_purview)){

           $member_id = $member['member_id'];

           $member_lv_id =  $member['member_lv_id'];

           switch($dealer_purview){

                 case 0://??1,2,3??????????????

                      $this->api_response('fail','data fail',$result,'??????????');             

                 break;

                 case 1://????? 

                      $this->api_response('fail','data fail',$result,'???????');          

                 break;

                 case 2://???? 

                    

                 break;

                 case 3://?????

                     $objPline = &$this->system->loadModel('trading/pline');

                     $objMemberPline = &$this->system->loadModel('member/memberpline');

                     $objGoods = &$this->system->loadModel('trading/goods');

                     $objProductCat = &$this->system->loadModel('goods/productCat');

                     $member_line_list = $objMemberPline->getPlineListByMember($member_id);

                     if($member_line_list){

                         $is_dealer_cat = array();

                         foreach($member_line_list as $pline){

                             $pline_info = $objPline->getInfo($pline['pline_id']);

                             

                             //????????????????????ID?????ID???

                             if($pline_info['cat_id'] != -1 && !in_array($pline_info['cat_id'],$is_dealer_cat)){

                                $arr_sub_cat_id = $objProductCat->getSubCatId($pline_info['cat_id']);

                                if(!empty($arr_sub_cat_id)){

                                   $arr_sub_cat_id[] = $pline_info['cat_id'];

                                   $is_dealer_cat = array_merge($is_dealer_cat,$arr_sub_cat_id);

                                }else{

                                   $is_dealer_cat[] = $pline_info['cat_id'];

                                }

                             }

                             

                             foreach($arr_goods as $k=>$goods){

                                 if(isset($goods['is_dealer']) && $goods['is_dealer']){continue;}//????????,?????

                                 //???????????ID???ID

                                

                                 if(!isset($goods['cat_id']) || (!isset($goods['brand_id']) && !is_null($goods['brand_id'])) ){

                                     $goods = $objGoods->getFieldById($goods['goods_id']);

                                 }

                                

                                 if($pline_info['cat_id'] == -1 && $pline_info['brand_id'] == -1){

                                   //????????????????????,???

                                    $arr_goods[$k]['is_dealer'] = true;

                                 }else if($pline_info['cat_id'] == -1 && $pline_info['brand_id'] == $goods['brand_id']){

                                   //????????????,????????ID????,???(??????ID?NULL,????????)

                                    $arr_goods[$k]['is_dealer'] = true;

                                 }else if($pline_info['brand_id'] == -1 && in_array($goods['cat_id'],$is_dealer_cat)){

                                   //????????????,????????ID????,???(??????ID?NULL,????????)

                                    $arr_goods[$k]['is_dealer'] = true;

                                 }else if(in_array($goods['cat_id'],$is_dealer_cat) && $pline_info['brand_id'] == $goods['brand_id']){ 

                                   //???????????????ID???,????????ID????,???

                                    $arr_goods[$k]['is_dealer'] = true;

                                 }else{

                                   //????????

                                    $arr_goods[$k]['is_dealer'] = false;

                                 }                  

                             }                                     

                         }

                         

                         foreach($arr_goods as $k=>$goods){

                              if(!$arr_goods[$k]['is_dealer']){

                                  $this->api_response('fail','data fail',$result,'???????');          

                              }

                         }         

                     }else{//???????????,????????,???????

                        $this->api_response('fail','data fail',$result,'?????????');          

                     }

                 break;

                 default:

                       $this->api_response('fail','data fail',$result,'???????');          

           }

           

        }else{

            $this->api_response('fail','data fail',$result,'??????');          

        }

    }







}