<?php
include_once(CORE_DIR.'/api/shop_api_object.php');
class api_b2b_1_0_region extends shop_api_object {
 
    function getColumns(){
      /*  $columns=array(
         'area_id'=>array('type'=>'int'),
         'name'=>array('type'=>'int'),
         'disabled'=>array('type'=>'int'),
         'ordernum'=>array('type'=>'string')
        );
        return $columns;*/
    }
    
    /**
     * 获取供应商配送地区信息
     *
     * @param array $data 
     *
     * @return 供应商配送地区信息
     */
    function search_sub_regions($data){
        $p_region_id = $data['p_region_id'];
        
        if($p_region_id == 0){
            $region_list = $this->db->select('select region_id,local_name,region_grade from sdb_regions where disabled="false" and p_region_id IS NULL');
        }else{
            $region_list = $this->db->select('select region_id,local_name,region_grade from sdb_regions where disabled="false" and p_region_id ='.$p_region_id);
        }
        
        foreach($region_list as $k=>$region){
            if($region['region_grade'] == 3){
                $region['is_node'] = 0;
            }else{
                $region['is_node'] = 1;
            }
            unset($region['region_grade']);
            $region_list[$k] = $region;
        }
        
        $result['data_info'] = $region_list;
     
        $this->api_response('true',false,$result);
    }
    
    /* 根据配送ID以及地区ID获取供应商配送信息
     *
     * @param array $data 
     *
     * @return 根据配送ID以及地区ID获取供应商配送信息
     */
    function search_dly_type_byid($data){
        //$dly_type = $this->db->selectrow('select '.implode(',',$data['columns']).' from sdb_dly_type where disabled = "false" and dt_id="'.$data['delivery_id'].'"');
        $dly_type_list = $this->_dltype_byarea($data['area_id']);
        
        if(!$dly_type_list){
            $this->api_response('fail','data fail',$result,'没有相对应的配送信息');
        }
        
        $dly_type = false;
        foreach($dly_type_list as $dly_type_row){
            if($dly_type_row['dt_id'] == $data['delivery_id']){
                $dly_type = $dly_type_row;
                break;
            }
        }
        
        if(!$dly_type){
            $this->api_response('fail','data fail',$result,'没有相对应的配送信息');
        }
        
        $result['data_info'] = $dly_type;
        $this->api_response('true',false,$result);
    }
    
    
    function search_dltype_byarea($data){ //根据配送地区取得配送方式列表
        $rs = $this->_dltype_byarea($data['area_id']);
        $result['data_info'] = $rs;
    
        $this->api_response('true',false,$result);
    }
    
    function _dltype_byarea($areaid){
        $rsall = array();
        
        $rs1 = $this->db->select('SELECT t.dt_id,t.dt_name, t.protect, t.detail ,a.config AS dt_config, t.minprice,t.protect_rate,a.expressions, a.has_cod AS pad, t.ordernum
        FROM sdb_dly_type t INNER JOIN sdb_dly_h_area a ON t.dt_id = a.dt_id 
        WHERE t.disabled = \'false\' AND t.dt_status = 1 AND a.areaid_group like \'%,'.intval($areaid).',%\' '.$where.' ORDER BY t.ordernum ASC , a.dha_id ASC'); 
        foreach( $rs1 as $val1) {
            if( !$rsall[$val1['dt_id']] )
                $rsall[$val1['dt_id']] = $val1;
        }
        $rs2 = $this->db->select('SELECT t.dt_id,t.dt_name, t.has_cod AS pad, t.protect, t.dt_config,
                            t.dt_expressions AS expressions ,t.detail,t.minprice,t.protect_rate, t.ordernum 
                            FROM sdb_dly_type t  WHERE t.disabled = \'false\' AND t.dt_status = 1  
                            AND ( dt_config LIKE \'%"setting";s:11:"setting_hda"%\' 
                            OR ( dt_config LIKE \'%"defAreaFee";i:1%\'  AND dt_config LIKE \'%"setting";s:11:"setting_sda"%\') ) '
                            .( $rsall?' AND t.dt_id NOT IN ( '.implode(',',array_keys($rsall)).' ) ':'' )
                            .$where.' ORDER BY t.ordernum');
        foreach( $rs2 as $val2) {
            $rsall[$val2['dt_id']] = $val2;
        }
        $rsall1 = array();
        foreach( $rsall as $rsv ){
            $rsall1[$rsv['ordernum']][] = $rsv;
        }
        ksort( $rsall1 );
        $rs = array();
        foreach( $rsall1 as $rsorderv ){
            foreach( $rsorderv as $rsallv ){
                $rs[] = $rsallv;
            }
        }
        
        return $rs;
    }
}