def get_prov_model_place_num(self, params):
aio = AssetInfoChNameToId()
list = aio.get_asset_type_and_model_id(params)
asset_type_id = list[0]
model_id = list[1]
store_place_id = aio. \
get_store_place_id_by_ch_name(params['store_place'])
return AssetPhoneInfoDal().get_asset_type_model_place_num(
asset_type_id, model_id, store_place_id)
def store_new_add_phone_data(self, params):
data = {}
aio = AssetInfoChNameToId()
list = aio.get_asset_type_and_model_id(params)
data["asset_type_id"] = list[0]
data["model_id"] = list[1]
data["user_name"] = params["user_name"]
data["phone_num"] = int(params["phone_num1"]) + int(params["phone_num2"])
data["phone_num1"] = params["phone_num1"]
data["phone_num2"] = params["phone_num2"]
data["store_place_id"] = aio. \
get_store_place_id_by_ch_name(params['store_place'])
data["remark"] = params["remark"]
return AssetPhoneInfoDal().store_new_phone_data(data)
def get_prov_model_user_name_num(self, params):
aio = AssetInfoChNameToId()
list = aio.get_asset_type_and_model_id(params)
asset_type_id = list[0]
model_id = list[1]
print list
assetInfo = AssetConsumeInfoDal().get_asset_type_model_user_name_num(
asset_type_id, model_id, params["user_name"], 2)
print assetInfo
ret_params = {}
if assetInfo:
ret_params['in_num'] = str(assetInfo.in_num)
ret_params['user_name'] = assetInfo.user_name
return json.dumps(ret_params)
def get_prov_model_place_num(self, params):
aio = AssetInfoChNameToId()
list = aio.get_asset_type_and_model_id(params)
asset_type_id = list[0]
model_id = list[1]
store_place_id = aio. \
get_store_place_id_by_ch_name(params['store_place'])
assetInfo = AssetConsumeInfoDal().get_asset_type_model_place_num(
asset_type_id, model_id, store_place_id)
ret_params = {}
if assetInfo:
ret_params['in_num1'] = str(assetInfo.in_num)
ret_params['user_name'] = assetInfo.user_name
return json.dumps(ret_params)
def store_consume_old_data(self, data):
aci = AssetInfoChNameToId()
data['old_user_name'] = data['user_name_c']
data['user_name'] = data['c_user_name']
data['store_state'] = aci.\
get_store_state_id_by_ch_name(data['c_store_state'])
data['store_place'] = aci.\
get_store_place_id_by_ch_name(data['c_store_place'])
data['in_out_reason'] = aci.\
get_in_out_reason_id_by_ch_name(data['c_in_out_reason'])
data['device_state'] = aci.\
get_device_state_id_by_ch_name(data['c_device_state'])
data['remark'] = data['c_remark']
list = aci.get_asset_type_and_model_id(data)
data["asset_type"] = list[0]
data["model"] = list[1]
def store_out_add_consume_data(self, data, operator):
new_data = {}
for k, v in data.items():
new_data[k] = v
# self.construct_out_oper_data(new_data, operator)
aio = AssetInfoChNameToId()
list = aio.get_asset_type_and_model_id(new_data)
new_data["asset_type"] = list[0]
new_data["model"] = list[1]
new_data["store_place1"] = aio. \
get_store_place_id_by_ch_name(new_data['store_place1'])
new_data["store_place2"] = aio. \
get_store_place_id_by_ch_name(new_data['store_place2'])
new_data["store_state"] = aio. \
get_store_state_id_by_ch_name('在用')
new_data["device_state"] = aio. \
get_store_state_id_by_ch_name('可用')
new_data['in_out_reason'] = aio.\
get_in_out_reason_id_by_ch_name(data['in_out_reason'])
return AssetConsumeInfoDal().store_old_consume_data(new_data)
