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