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)