def get_asset_info_all(self, assetInfos, count):
aic = AssetInfoIdToChName()
ret = []
for assetInfo in assetInfos:
params = aic.get_asset_manager_show_info(assetInfo)
ret.append(params)
rets = {'data': ret, 'count': count}
return json.dumps(rets)
def get_asset_info_by_asset_id(self, asset_id):
assetInfo = AssetInfoDal().get_asset_info_by_id(asset_id)
if assetInfo is None:
return ''
aic = AssetInfoIdToChName()
ret = []
params = aic.get_detail_asset_info(assetInfo)
ret.append(params)
return json.dumps(ret)
def get_asset_phone_info_id_ch_name(self, assetPhoneInfo):
params = {}
if assetPhoneInfo is None:
return params
aic = AssetInfoIdToChName()
params = self.get_asset_phone_show_info(assetPhoneInfo)
params['in_out_reason'] = aic.get_in_out_reason_name_by_num(
assetPhoneInfo.in_out_reason_id)
params['remark'] = assetPhoneInfo.remark
params['up_time'] = trans_time(assetPhoneInfo.up_time)
params['create_time'] = trans_time(assetPhoneInfo.create_time)
params['update_time'] = trans_time(assetPhoneInfo.update_time)
return params
def get_asset_phone_show_info(self, assetInfo):
params = {}
if assetInfo is None:
return params
aic = AssetInfoIdToChName()
params['asset_type'] = aic.get_asset_type_name_by_num(assetInfo.asset_type_id)
params['phone_no'] = assetInfo.phone_no
params['store_state'] = aic.get_store_state_name_by_num(
assetInfo.store_state_id)
params['device_state'] = aic.get_device_state_name_by_num(
assetInfo.device_state_id)
params['user_name'] = assetInfo.user_name
params['store_place'] = aic.get_store_place_name_by_num(
assetInfo.store_place_id)
return params
def get_asset_consume_table_info(self, assetConsumeInfo):
params = {}
if assetConsumeInfo is None:
return params
params['id'] = assetConsumeInfo.id
aic = AssetInfoIdToChName()
params['asset_type'] = aic.get_asset_type_name_by_num(assetConsumeInfo.asset_type_id)
params['store_state'] = aic.get_store_state_name_by_num(
assetConsumeInfo.store_state_id)
params['store_place'] = aic.get_store_place_name_by_num(
assetConsumeInfo.store_place_id)
params['user_name'] = assetConsumeInfo.user_name
params['in_num'] = assetConsumeInfo.in_num
params['device_state'] = aic.get_device_state_name_by_num(assetConsumeInfo.device_state_id)
return params
def get_asset_consume_info_id_ch_name(self, assetConsumeInfo):
params = self.get_asset_consume_table_info(assetConsumeInfo)
aic = AssetInfoIdToChName()
params['model'] = aic.get_model_name_by_num(assetConsumeInfo.model_id)
params['provider'] = aic.get_prov_name_by_num(assetConsumeInfo.asset_type_id,
assetConsumeInfo.model_id)
params['in_out_reason'] = aic.get_in_out_reason_name_by_num(
assetConsumeInfo.in_out_reason_id)
params['user_name'] = assetConsumeInfo.user_name
params['remark'] = assetConsumeInfo.remark
params['create_time'] = trans_time(assetConsumeInfo.create_time)
params['update_time'] = trans_time(assetConsumeInfo.update_time)
params['up_time'] = trans_time(assetConsumeInfo.up_time)
params['out_num'] = assetConsumeInfo.out_num
params['consume_all'] = int(assetConsumeInfo.in_num) + int(assetConsumeInfo.out_num)
return params
def get_asset_info_three_info_by_id(self, asset_id):
asset_infos = AssetInfoDal().get_asset_info_first_by_id(asset_id)
aic = AssetInfoIdToChName()
params = []
for asset_info in asset_infos:
msg = (
asset_info.asset_id
+ "("
+ aic.get_asset_type_name_by_num(asset_info.asset_type_id)
+ "-"
+ aic.get_store_place_name_by_num(asset_info.store_place_id)
+ "-"
+ asset_info.user_name
+ ")"
)
params.append(msg)
return params
def get_export_excel_data(self, key):
if key != "":
# 传递过来的值包含=，是高级查询
if key.find("=") >= 0:
ais = AssetInfoService()
params = ais.get_data_by_split_web(key)
params = ais.get_advanced_web_params(params)
assetInfos = AssetInfoDal().get_advanced_search_val_all_datas(params)
# 一般查询
else:
rtx_id = get_actual_rtx_id(key)
assetInfos = AssetInfoDal().get_asset_info_excel_by_search_val_all(rtx_id)
else:
assetInfos = AssetInfoDal().get_asset_info_all()
ret = []
aoc = AssetInfoIdToChName()
for assetInfo in assetInfos:
params = aoc.get_excel_asset_info(assetInfo)
ret.append(params)
return ret
def construct_out_oper_data(self, new_data, operator):
assetInfo = AssetPhoneInfoDal().get_asset_phone_info_by_search_val_one(new_data['phone_no'])
aic = AssetInfoIdToChName()
params_o = {}
params_o['in_out_reason'] = aic.get_in_out_reason_name_by_num(
assetInfo.in_out_reason_id)
params_o['store_state'] = aic.get_store_state_name_by_num(
assetInfo.store_state_id)
params_o['device_state'] = aic.get_device_state_name_by_num(
assetInfo.device_state_id)
params_o['user_name'] = assetInfo.user_name
params_o['store_place'] = aic.get_store_place_name_by_num(
assetInfo.store_place_id)
params_o['phone_no'] = assetInfo.phone_no
params_o['asset_type'] = aic.get_asset_type_name_by_num(assetInfo.asset_type_id)
params_o['remark'] = assetInfo.remark
params_n = {}
params_n['store_place'] = new_data['store_place']
params_n['in_out_reason'] = new_data['in_out_reason']
params_n['store_state'] = '在用'
params_n['remark'] = new_data['remark']
oper_data = {}
oper_data['asset_id'] = params_o['phone_no']
oper_data['oper_type'] = '字段变更'
oper_data['operator'] = operator
oper_data['text'] = ''
aiu = AssetInfoUtils()
enlist = aiu.get_oper_phone_enlist()
e_len = len(enlist)
before_field = ''
after_field = ''
for i in range(e_len):
before_field += enlist[i] + ":" + params_o[enlist[i]] + ","
if params_n.has_key(enlist[i]):
after_field += enlist[i] + ":" + params_n[enlist[i]] + ","
else:
after_field += enlist[i] + ":" + params_o[enlist[i]] + ","
oper_data['before_field'] = before_field
oper_data['after_field'] = after_field
ais = AssetInfoService()
ais.save_oper_info(oper_data)
