public VaccineManufacturerBatchVoCollection listBatchVaccine(
String batchNumber, VaccineLiteVo vaccine) throws DomainInterfaceException {
if (batchNumber == null)
throw new DomainInterfaceException(
"Can not search for batch vaccines after an empty batch number");
if (vaccine == null)
throw new DomainInterfaceException(
"Can not search for batch vaccines with no selected vaccine");
DomainFactory factory = getDomainFactory();
String query =
"from VaccineManufacturerBatch as vmb where vmb.vaccine.id = :ID and UPPER(vmb.batchNumber) like :BATCHNUMBER and vmb.status.id = -617";
ArrayList<String> markers = new ArrayList<String>();
markers.add("ID");
markers.add("BATCHNUMBER");
ArrayList<Object> values = new ArrayList<Object>();
values.add(vaccine.getID_Vaccine());
values.add("%" + batchNumber.toUpperCase() + "%");
return VaccineManufacturerBatchVoAssembler
.createVaccineManufacturerBatchVoCollectionFromVaccineManufacturerBatch(
factory.find(query, markers, values));
}
public VaccineManufacturerBatchVo getBatchVaccine(String batchName)
throws DomainInterfaceException {
if (batchName == null) return null;
DomainFactory factory = getDomainFactory();
String query =
"from VaccineManufacturerBatch as vmb where UPPER(vmb.batchNumber) = :BATCHNUMBER";
ArrayList<String> markers = new ArrayList<String>();
markers.add("BATCHNUMBER");
ArrayList<Object> values = new ArrayList<Object>();
values.add(batchName.toUpperCase());
List results = factory.find(query, markers, values);
if (results == null || results.size() == 0) return null;
return VaccineManufacturerBatchVoAssembler.create((VaccineManufacturerBatch) (results.get(0)));
}