def get_advanced_phone_search_val(self, params):
model = self.session.query(AssetPhoneInfoModel)
if judge_key_not_null(params, "store_state"):
model = model.filter(AssetPhoneInfoModel.store_state_id == params['store_state'])
if judge_key_not_null(params, "device_state"):
model = model.filter(AssetPhoneInfoModel.device_state_id == params['device_state'])
if judge_key_not_null(params, "store_place"):
model = model.filter(AssetPhoneInfoModel.store_place_id == params['store_place'])
if judge_key_not_null(params, "in_out_reason"):
model = model.filter(AssetPhoneInfoModel.in_out_reason_id == params['in_out_reason'])
if judge_key_not_null(params, "asset_type"):
model = model.filter(AssetPhoneInfoModel.asset_type_id == params['asset_type'])
if judge_key_not_null(params, "date_from1"):
model = model.filter(AssetPhoneInfoModel.up_time >= params['date_from1'])
if judge_key_not_null(params, "date_to1"):
model = model.filter(AssetPhoneInfoModel.up_time <= params['date_to1'])
if judge_key_not_null(params, "date_from2"):
model = model.filter(AssetPhoneInfoModel.update_time >= params['date_from2'])
if judge_key_not_null(params, "date_to2"):
model = model.filter(AssetPhoneInfoModel.update_time <= params['date_to2'])
if judge_key_not_null(params, "asset_id_list"):
model = model.filter(AssetPhoneInfoModel.phone_no.in_(params["asset_id_list"]))
return model
def get_advanced_consume_search_val(self, params):
print params['model_list']
model = self.session.query(AssetConsumeInfoModel)
if judge_key_not_null(params, "store_state"):
model = model.filter(AssetConsumeInfoModel.store_state_id == params['store_state'])
if judge_key_not_null(params, "device_state"):
model = model.filter(AssetConsumeInfoModel.device_state_id == params['device_state'])
if judge_key_not_null(params, "store_place"):
model = model.filter(AssetConsumeInfoModel.store_place_id == params['store_place'])
if judge_key_not_null(params, "in_out_reason"):
model = model.filter(AssetConsumeInfoModel.in_out_reason_id == params['in_out_reason'])
if judge_key_not_null(params, "asset_type"):
model = model.filter(AssetConsumeInfoModel.asset_type_id == params['asset_type'])
if judge_key_not_null(params, "date_from1"):
model = model.filter(AssetConsumeInfoModel.up_time >= params['date_from1'])
if judge_key_not_null(params, "date_to1"):
model = model.filter(AssetConsumeInfoModel.up_time <= params['date_to1'])
if judge_key_not_null(params, "date_from2"):
model = model.filter(AssetConsumeInfoModel.update_time >= params['date_from2'])
if judge_key_not_null(params, "date_to2"):
model = model.filter(AssetConsumeInfoModel.update_time <= params['date_to2'])
# if params['oper_name'] != "":
# model = model.filter(AssetConsumeInfoModel.asset_id.in_(params["asset_id_list"]))
return model
