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)
