def get_advanced_web_params(self, request_params): list = AssetInfoUtils().get_advanced_list() d_len = len(list) params = {} for i in range(d_len): params[list[i]] = request_params[list[i]] ait = AssetInfoChNameToId() if params["store_state"] != "": params["store_state"] = ait.get_store_state_id_by_ch_name(params["store_state"]) if params["device_state"] != "": params["device_state"] = ait.get_device_state_id_by_ch_name(params["device_state"]) if params["store_place"] != "": params["store_place"] = ait.get_store_place_id_by_ch_name(params["store_place"]) params["in_out_reason"] = "" if params["in_reason"] != "": params["in_out_reason"] = ait.get_in_out_reason_id_by_ch_name(params["in_reason"]) if params["out_reason"] != "": params["in_out_reason"] = ait.get_in_out_reason_id_by_ch_name(params["out_reason"]) if params["asset_type"] != "": params["asset_type"] = ait.get_id_by_at_asset_ch_name(params["asset_type"]) if params["provider"] != "": params["provider"] = ait.get_prov_id_by_atd_ch(params["asset_type"], params["provider"]) if params["model"] != "" and params["provider"] != "": params["model"] = ait.get_model_id_by_pd_ch(params["provider"], params["model"]) params["model_list"] = [] if params["provider"] != "": if params["model"] == "": params["model_list"] = ModelDal().get_model_list_by_prov_id(params["provider"]) if params["oper_name"] != "": params["asset_id_list"] = OperationInfoDal().get_asset_id_list_by_operator(params["oper_name"]) return params
def get_actual_num_data(self, data): aci = AssetInfoChNameToId() data['store_state'] = aci.\ get_store_state_id_by_ch_name('库存') data['store_place'] = aci.\ get_store_place_id_by_ch_name(data['store_place']) data['device_state'] = aci.\ get_device_state_id_by_ch_name('可用') data['asset_type'] = aci.get_id_by_at_asset_ch_name(data['asset_type']) return data
def get_model_by_prov(self, asset_type, provider): # 根据品牌得到所有的该品牌的型号 aoc = AssetInfoChNameToId() id = aoc.get_id_by_at_asset_ch_name(asset_type) prov_model = ProviderDal().get_prov_by_id_and_at(id, provider) modelList = ModelDal().get_model_by_prov_id(prov_model.id) models = [] for model in modelList: models.append(model.name) return models
def get_actual_prov_list(self, asset_type): aoc = AssetInfoChNameToId() id = aoc.get_id_by_at_asset_ch_name(asset_type) return self.get_prov_list_by_atd(id)
def get_prov_list_by_type(self, asset_type): aoc = AssetInfoChNameToId() id = aoc.get_id_by_at_asset_ch_name(asset_type) return ProviderDal().get_prov_by_asset_type(id)