def get_finance_all_county(city_id=None): """ 通过城市ID获取县区的数据 参数 ---- city_id : int 城市ID 返回值 ------ result_list : list 所有县区的数据的数组 """ city_id = common_utils.to_int(city_id) county_list = list_objs(model=ModelName.T_BASE_COUNTY, is_enable=1, is_show=1, city_id=city_id) if not county_list: return None result_list = [] for county in county_list: county_info = place_utils.get_county_by_id(county_id=county.county_id) if county_info: result_list.append(county_info) return result_list
def county_name(county_id): ''' 县区名字 ''' if not county_id: return "" county = place_utils.get_county_by_id( county_id=county_id ) if not county: return "" return county['county_name']
def get_dealer_id_list_by_county(county_id=None, car_brand_id=None, car_series_id=None): """ 根据县区ID查找 """ county_id = common_utils.to_int(county_id) car_brand_id = common_utils.to_int(car_brand_id) car_series_id = common_utils.to_int(car_series_id) dealer_sql_template = ''' SELECT id FROM t_base_dealer WHERE is_enable=1 AND is_frozen=0 {% if county_id %} AND county_id={{county_id}} {% endif %} {% if car_series_id %} AND car_series_ids like '%,{{car_series_id}},%' {% elif car_brand_id %} AND cbb_car_brand_code like '%,{{car_brand_id}},%' {% endif %} ''' param = { 'county_id': county_id, 'car_brand_id': car_brand_id, 'car_series_id': car_series_id, } dealer_sql = Template(dealer_sql_template).render(param) cursor = connection().cursor() cursor.execute(dealer_sql) dealer_list = dictfetchall(cursor) if not dealer_list: # 根据城市ID查找 county_info = place_utils.get_county_by_id(county_id=county_id) if not county_info: return None city_id = county_info['city_id'] return get_dealer_id_list_by_city(city_id=city_id, car_brand_id=car_brand_id, car_series_id=car_series_id) dealer_id_list = [] for tmp_dealer in dealer_list: dealer_id_list.append(tmp_dealer['id']) return dealer_id_list
def get_finance_dealer_county(city_id=None): """ 通过城市ID获取所有包含经销商的县区的数据 参数 ---- city_id : int 城市ID 返回值 ------ result_list : list 所有县区的数据的数组 """ city_id = common_utils.to_int(city_id) dealer_id_list = dealer_utils.get_dealer_id_list(city_id=city_id) if not dealer_id_list: return None dealer_sql_template = ''' SELECT DISTINCT county_id FROM t_base_dealer WHERE is_enable=1 AND is_frozen=0 AND id in ({{dealer_id_list}}) ORDER BY county_id ''' param = { 'dealer_id_list': common_utils.int_list_to_str(dealer_id_list), } dealer_sql = Template(dealer_sql_template).render(param) cursor = connection().cursor() cursor.execute(dealer_sql, param) dealers = dictfetchall(cursor) if not dealers: return None result_list = [] for dealer in dealers: county_info = place_utils.get_county_by_id( county_id=dealer['county_id']) if county_info: result_list.append(county_info) return result_list
def get_place_county_by_id(county_id=None): """ 根据县区ID获取县区基本数据 参数 ---- city_id : int 县区ID 返回值 ------ result_dict : dict 县区基本数据 """ county_id = common_utils.to_int(county_id) county = place_utils.get_county_by_id(county_id=county_id) return county
def get_finance_province_city_county(province_id=None, city_id=None, county_id=None): """ 根据城市ID或者县区ID返回省和城市信息 province_id, city_id, county_id都是可选,最少有一个 参数 ---- province_id : int, 可选 省ID city_id : int, 可选 城市ID county_id : int, 可选 县区ID 返回值 ------ result_dict : dict 返回省或者城市信息 """ city_id = common_utils.to_int(city_id) county_id = common_utils.to_int(county_id) province_id = common_utils.to_int(province_id) result_dict = {} if county_id: county_info = place_utils.get_county_by_id(county_id=county_id) if not county_info: return None city_id = county_info['city_id'] result_dict['county'] = county_info if city_id: city_info = place_utils.get_city_by_id(city_id=city_id) if not city_info: return None province_id = city_info['province_id'] result_dict['city'] = city_info if province_id: province_info = place_utils.get_province_by_id(province_id=province_id) if not province_info: return None result_dict['province'] = province_info return result_dict