Java Code Examples for com.ims.query.builder.client.exceptions.QueryBuilderClientException

private byte[] prepairPrintCorrespondenceDoc()
{

	// get saved document from local context
	CorrespondenceDetailsVo voCorrespondenceDetails = form.getLocalContext().getcorrespondenceDetails();

	byte[] resultPdf;
	resultPdf = null;
	try
	{
		resultPdf = buildDocumentPDF(voCorrespondenceDetails);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Report Generation Failed for the following reason(s): " + e.getMessage());
		return null;
	}

	return resultPdf;
}
 

private void previewLetter()
{
	// get saved document from local context
	CorrespondenceDetailsVo voCorrespondenceDetails = form.getLocalContext().getcorrespondenceDetails();

	byte[] resultPdf;
	resultPdf = null;
	try
	{
		resultPdf = buildDocumentPDF(voCorrespondenceDetails);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Report Generation Failed for the following reason(s): " + e.getMessage());
		return;
	}

	if (null != resultPdf)
		voCorrespondenceDetails.getCurrentDocument().setContent(new String(resultPdf));

	if (!saveDocumentDetails(voCorrespondenceDetails))
		return;

	engine.open(form.getForms().Correspondence.ProcessReport);
}
 

private void previewLetter()
{
	// get saved document from local context
	CorrespondenceDetailsVo voCorrespondenceDetails = form.getLocalContext().getcorrespondenceDetails();

	byte[] resultPdf;
	resultPdf = null;
	try
	{
		resultPdf = buildDocumentPDF(voCorrespondenceDetails);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Report Generation Failed for the following reason(s): " + e.getMessage());
		return;
	}

	if (null != resultPdf)
		voCorrespondenceDetails.getCurrentDocument().setContent(new String(resultPdf));

	if (!saveDocumentDetails(voCorrespondenceDetails))
		return;

	previewDoc();
}
 

private byte[] prepairPrintCorrespondenceDoc()
{

	// get saved document from local context
	CorrespondenceDetailsVo voCorrespondenceDetails = form.getLocalContext().getcorrespondenceDetails();

	byte[] resultPdf;
	resultPdf = null;
	try
	{
		resultPdf = buildDocumentPDF(voCorrespondenceDetails);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Report Generation Failed for the following reason(s): " + e.getMessage());
		return null;
	}

	return resultPdf;
}
 

/**
 * Function used to print document to printer (uses QueryBuilderClient but bypasses query server)
 * @param printerName
 */
private void printDocument(String printerName)
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	
	try
	{
		client.printReport(readFile(form.getLocalContext().getFilePath()), urlReportServer, printerName, 1);
		
		engine.showMessage("Document printed to: " + printerName); //WDEV-15422
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Could not print document.");
		e.printStackTrace();
	}
}
 

private void loadPrinterList()
{
	form.cmbPrint().clear();		
	QueryBuilderClient qbc = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	try
	{
		PrinterAvailableCollection printers = qbc.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());
		String[] printersColl = new String[printers.size()];

		for (int i = 0; i < printers.size(); i++)
		{
			form.cmbPrint().newRow(printers.get(i).getName(), printers.get(i).getName());
			printersColl[i] = printers.get(i).getName();
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers list: " + e.toString());
		return;
	}
}
 

@Override
protected void onBtnPrintClick() throws PresentationLogicException
{
	if(form.cmbPrint().getValue() == null)
	{
		engine.showMessage("Please select a printer.");
		return;
	}
	
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	QueryBuilderClient cl = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	
	try
	{
		cl.printReport(readFile(form.getLocalContext().getICPReport()), urlReportServer, form.cmbPrint().getValue(), 1);
	}
	catch (QueryBuilderClientException e)
	{
		e.printStackTrace();
	}
	
	engine.showMessage("The report has been sent to printer '" + form.cmbPrint().getValue() + "'.");
}
 

private void loadPrinterList()
{
	form.cmbPrintTo().clear();

	QueryBuilderClient qbc = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	try
	{
		PrinterAvailableCollection printers = qbc.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());

		String[] printersColl = new String[printers.size()];

		for (int i = 0; i < printers.size(); i++)
		{
			form.cmbPrintTo().newRow(printers.get(i).getName(), printers.get(i).getName());
			printersColl[i] = printers.get(i).getName();
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers list: " + e.toString());
	}
}
 

private void loadPrinterList()
{
	form.cmbPrint().clear();		
	QueryBuilderClient qbc = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	try
	{
		PrinterAvailableCollection printers = qbc.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());
		String[] printersColl = new String[printers.size()];

		for (int i = 0; i < printers.size(); i++)
		{
			form.cmbPrint().newRow(printers.get(i).getName(), printers.get(i).getName());
			printersColl[i] = printers.get(i).getName();
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers list: " + e.toString());
		return;
	}
}
 

protected void onBtnViewClick() throws PresentationLogicException
{
	PrintAgentDocumentsVo doc = form.grdDocuments().getValue();

	if(doc == null)
	{
		engine.showMessage("Please select a document to view !");
		return;
	}

	QueryBuilderClient qb = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());
	
	try
	{
		byte[] pdf = qb.convertReport(ConfigFlag.GEN.REPORT_SERVER_URL.getValue(), doc.getDocument().getBytes(), QueryBuilderClient.PDF, "", 1);
		String url = qb.prepareReportForViewing(pdf, "PDF"); 
		
		engine.openUrl(url);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error viewing document: " + e.toString());
		return;
	}
}
 

private void processPhlebotomyReport(QueryBuilderClient client,String urlReportServer, String repXml, String templXml, PhlebotomyRoundVo round) 
{			
	client.getSeeds().clear();
	client.addSeed(new SeedValue("PhlebotomyRound_id", round.getID_PhlebotomyRound(), Integer.class));
	client.addSeed(new SeedValue("Patient_id", null, Integer.class));
	
	try
	{					
		client.printReport(repXml, templXml, urlReportServer,form.qmbPrinter().getValue(), 1);
		
	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error building the report: " + e1.toString());
		return;
	}						
	
}
 

private void processLabelsPrintedFromOrderReport(QueryBuilderClient client,String urlReportServer, String repXml2, String templXml2,OrderSpecimenLiteVo specimen) 
{
					
	client.getSeeds().clear();
	client.addSeed(new SeedValue("OrderSpecimen_id", specimen.getID_OrderSpecimen(), Integer.class));				
	
	try
	{					
		client.printReport(repXml2, templXml2, urlReportServer, form.qmbPrinterLabels().getValue(), 1);

	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error building the report: " + e1.toString());
		return;
	}						
		
}
 

private byte[] processResultSummaryReport(QueryBuilderClient client, String urlReportServer, String repXml2, String templXml2,int inv_id,int page_start)
{
	byte[] doc = null;
	
	client.getSeeds().clear();
	client.addSeed(new SeedValue("OrderInvestigation_id",inv_id , java.lang.Integer.class));
	client.addSeed(new SeedValue("PAGE_START", page_start, java.lang.Integer.class));
	
	try
	{					
		doc = client.buildReport(repXml2, templXml2, urlReportServer, QueryBuilderClient.PDF, "", 1);

	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error building the report: " + e1.toString());
		return null;
	}
			
	return doc;	
}
 

private void previewLetter()
{
	// get saved document from local context
	CorrespondenceDetailsVo voCorrespondenceDetails = form.getLocalContext().getcorrespondenceDetails();

	byte[] resultPdf;
	resultPdf = null;
	try
	{
		resultPdf = buildDocumentPDF(voCorrespondenceDetails);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Report Generation Failed for the following reason(s): " + e.getMessage());
		return;
	}

	if (null != resultPdf)
		voCorrespondenceDetails.getCurrentDocument().setContent(new String(resultPdf));

	if (!saveDocumentDetails(voCorrespondenceDetails))
		return;

	engine.open(form.getForms().Correspondence.ProcessReport);
}
 

private byte[] prepairPrintCorrespondenceDoc()
{

	// get saved document from local context
	CorrespondenceDetailsVo voCorrespondenceDetails = form.getLocalContext().getcorrespondenceDetails();

	byte[] resultPdf;
	resultPdf = null;
	try
	{
		resultPdf = buildDocumentPDF(voCorrespondenceDetails);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Report Generation Failed for the following reason(s): " + e.getMessage());
		return null;
	}

	return resultPdf;
}
 

/**
 * Function used to print document to printer (uses QueryBuilderClient but bypasses query server)
 * @param printerName
 */
private void printDocument(String printerName)
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	
	try
	{
		client.printReport(readFile(form.getLocalContext().getFilePath()), urlReportServer, printerName, 1);
		
		engine.showMessage("Document printed to: " + printerName); //WDEV-15422
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Could not print document.");
		e.printStackTrace();
	}
}
 

/**
 * Function used to print document to printer (uses QueryBuilderClient but bypasses query server)
 * @param printerName
 */
private void printDocument(String printerName)
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	
	try
	{
		client.printReport(readFile(form.getLocalContext().getFilePath()), urlReportServer, printerName, 1);
		
		engine.showMessage("Document printed to: " + printerName); //WDEV-15422
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Could not print document.");
		e.printStackTrace();
	}
}
 

private void loadPrinterList()
{
	form.cmbPrinter().clear();		
	QueryBuilderClient qbc = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	try
	{
		PrinterAvailableCollection printers = qbc.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());
		String[] printersColl = new String[printers.size()];

		for (int i = 0; i < printers.size(); i++)
		{
			form.cmbPrinter().newRow(printers.get(i).getName(), printers.get(i).getName());
			printersColl[i] = printers.get(i).getName();
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers list: " + e.toString());
		return;
	}
}
 

@Override
protected void onBtnPrintClick() throws PresentationLogicException
{
	if(form.cmbPrint().getValue() == null)
	{
		engine.showMessage("Please select a printer.");
		return;
	}
	
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	QueryBuilderClient cl = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	
	try
	{
		cl.printReport(readFile(form.getLocalContext().getICPReport()), urlReportServer, form.cmbPrint().getValue(), 1);
	}
	catch (QueryBuilderClientException e)
	{
		e.printStackTrace();
	}
	
	engine.showMessage("The report has been sent to printer '" + form.cmbPrint().getValue() + "'.");
}
 

private void loadPrinterList()
{
	form.cmbPrint().clear();		
	QueryBuilderClient qbc = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	try
	{
		PrinterAvailableCollection printers = qbc.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());
		String[] printersColl = new String[printers.size()];

		for (int i = 0; i < printers.size(); i++)
		{
			form.cmbPrint().newRow(printers.get(i).getName(), printers.get(i).getName());
			printersColl[i] = printers.get(i).getName();
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers list: " + e.toString());
		return;
	}
}
 

private void loadPrinterList()
{
	form.cmbPrint().clear();		
	QueryBuilderClient qbc = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	try
	{
		PrinterAvailableCollection printers = qbc.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());
		String[] printersColl = new String[printers.size()];

		for (int i = 0; i < printers.size(); i++)
		{
			form.cmbPrint().newRow(printers.get(i).getName(), printers.get(i).getName());
			printersColl[i] = printers.get(i).getName();
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers list: " + e.toString());
		return;
	}
}
 

protected void onBtnViewClick() throws PresentationLogicException
{
	PrintAgentDocumentsVo doc = form.grdDocuments().getValue();

	if(doc == null)
	{
		engine.showMessage("Please select a document to view !");
		return;
	}

	QueryBuilderClient qb = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());
	
	try
	{
		byte[] pdf = qb.convertReport(ConfigFlag.GEN.REPORT_SERVER_URL.getValue(), doc.getDocument().getBytes(), QueryBuilderClient.PDF, "", 1);
		String url = qb.prepareReportForViewing(pdf, "PDF"); 
		
		engine.openUrl(url);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error viewing document: " + e.toString());
		return;
	}
}
 

private void processLabelsPrintedFromOrderReport(QueryBuilderClient client,String urlReportServer, String repXml2, String templXml2,OrderSpecimenLiteVo specimen) 
{
					
	client.getSeeds().clear();
	client.addSeed(new SeedValue("OrderSpecimen_id", specimen.getID_OrderSpecimen(), Integer.class));				
	
	try
	{					
		client.printReport(repXml2, templXml2, urlReportServer, form.qmbPrinterLabels().getValue(), 1);

	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error building the report: " + e1.toString());
		return;
	}						
		
}
 

private byte[] processResultSummaryReport(QueryBuilderClient client, String urlReportServer, String repXml2, String templXml2,int inv_id,int page_start)
{
	byte[] doc = null;
	
	client.getSeeds().clear();
	client.addSeed(new SeedValue("OrderInvestigation_id",inv_id , java.lang.Integer.class));
	client.addSeed(new SeedValue("PAGE_START", page_start, java.lang.Integer.class));
	
	try
	{					
		doc = client.buildReport(repXml2, templXml2, urlReportServer, QueryBuilderClient.PDF, "", 1);

	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error building the report: " + e1.toString());
		return null;
	}
			
	return doc;	
}
 

private void previewLetter()
{
	// get saved document from local context
	CorrespondenceDetailsVo voCorrespondenceDetails = form.getLocalContext().getcorrespondenceDetails();

	byte[] resultPdf;
	resultPdf = null;
	try
	{
		resultPdf = buildDocumentPDF(voCorrespondenceDetails);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Report Generation Failed for the following reason(s): " + e.getMessage());
		return;
	}

	if (null != resultPdf)
		voCorrespondenceDetails.getCurrentDocument().setContent(new String(resultPdf));

	if (!saveDocumentDetails(voCorrespondenceDetails))
		return;

	previewDoc();
}
 

private void processPhlebotomyReport(QueryBuilderClient client,String urlReportServer, String repXml, String templXml, PhlebotomyRoundVo round) 
{			
	client.getSeeds().clear();
	client.addSeed(new SeedValue("PhlebotomyRound_id", round.getID_PhlebotomyRound(), Integer.class));
	client.addSeed(new SeedValue("Patient_id", null, Integer.class));
	
	try
	{					
		client.printReport(repXml, templXml, urlReportServer,form.qmbPrinter().getValue(), 1);
		
	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error building the report: " + e1.toString());
		return;
	}						
	
}
 

private void loadPrinterList()
{
	form.cmbPrint().clear();		
	QueryBuilderClient qbc = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	try
	{
		PrinterAvailableCollection printers = qbc.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());
		String[] printersColl = new String[printers.size()];

		for (int i = 0; i < printers.size(); i++)
		{
			form.cmbPrint().newRow(printers.get(i).getName(), printers.get(i).getName());
			printersColl[i] = printers.get(i).getName();
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers list: " + e.toString());
		return;
	}
}
 

/**
 * 
 */
private byte[] buildDocumentPDF(CorrespondenceDetailsVo voCorrespondenceDetails) throws QueryBuilderClientException
{
	Integer iDocId;
	iDocId = voCorrespondenceDetails.getID_CorrespondenceDetails();

	form.getGlobalContext().Correspondence.setDocDetailIdReportSeed(iDocId);
	// generate the document for viewing
	form.getGlobalContext().Core.setReportID(form.getGlobalContext().Correspondence.getReportTemplate().getReport().getID_ReportBo());
	form.getGlobalContext().Core.setTemplateID(form.getGlobalContext().Correspondence.getReportTemplate().getID_TemplateBo());

	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	String[] obj = null;
	try
	{
		obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());
	}
	catch (DomainInterfaceException e)
	{
		engine.showMessage("I could not get the report and template !");
		return null;
	}

	if (obj == null || obj.length == 0)
	{
		engine.showMessage("I could not get the report and template !");
		return null;
	}

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	if (form.getGlobalContext().Correspondence.getDocDetailIdReportSeedIsNotNull())
		client.addSeed(new SeedValue("CorrespondenceDetails_id", form.getGlobalContext().Correspondence.getDocDetailIdReportSeed(), Integer.class));

	return client.buildReport(obj[0], obj[1], urlReportServer, QueryBuilderClient.FP3, "", 1);

}
 

protected void onFormOpen(Object[] args) throws ims.framework.exceptions.FormOpenException
{ 
	//list available printers
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();		
	QueryBuilderClient client = new QueryBuilderClient(urlReportServer,engine.getSessionId());
	
	if(args.length >0)
	{
	Integer numberOfPrints = (Integer) args[0];
	// sets Number of prints to the number of addressees
	form.intHeaded().setValue(numberOfPrints);
	form.intStandard().setValue(numberOfPrints);
	}
	else
	{
		form.intHeaded().setValue(new Integer(1));
		form.intStandard().setValue(new Integer(1));
	}
	
	
	try
	{
		PrinterAvailableCollection printersColl = client.listPrinters(urlReportServer);
		if (printersColl != null)
		{
			for(int i=0;i<printersColl.size();i++)
			{
				form.cmbHeadedPaper().newRow(printersColl.get(i).getName(),printersColl.get(i).getName());
				form.cmbStandard().newRow(printersColl.get(i).getName(),printersColl.get(i).getName());
			}				
		}			
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage(e.getMessage());
		form.setMode(FormMode.VIEW);
	}

}
 

/**
 * 
 */
private byte[] buildDocumentPDF(CorrespondenceDetailsVo voCorrespondenceDetails) throws QueryBuilderClientException
{
	Integer iDocId;
	iDocId = voCorrespondenceDetails.getID_CorrespondenceDetails();

	form.getGlobalContext().Correspondence.setDocDetailIdReportSeed(iDocId);
	// generate the document for viewing
	form.getGlobalContext().Core.setReportID(form.getGlobalContext().Correspondence.getReportTemplate().getReport().getID_ReportBo());
	form.getGlobalContext().Core.setTemplateID(form.getGlobalContext().Correspondence.getReportTemplate().getID_TemplateBo());

	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	String[] obj = null;
	try
	{
		obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());
	}
	catch (DomainInterfaceException e)
	{
		engine.showMessage("I could not get the report and template !");
		return null;
	}

	if (obj == null || obj.length == 0)
	{
		engine.showMessage("I could not get the report and template !");
		return null;
	}

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	if (form.getGlobalContext().Correspondence.getDocDetailIdReportSeedIsNotNull())
		client.addSeed(new SeedValue("CorrespondenceDetails_id", form.getGlobalContext().Correspondence.getDocDetailIdReportSeed(), Integer.class));

	return client.buildReport(obj[0], obj[1], urlReportServer, QueryBuilderClient.FP3, "", 1);

}
 

private String getIFrameCode() throws DomainInterfaceException
{
	StringBuffer sb = new StringBuffer(1000);
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	String[] obj = null;

	obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());

	if (obj == null || obj.length == 0)
	{
		engine.showMessage("I could not get the report and template !");
		return sb.toString();
	}

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	// get report seed name
	if (form.getGlobalContext().Correspondence.getDocDetailIdReportSeedIsNotNull())
		client.addSeed(new SeedValue("DocumentDetails_id", form.getGlobalContext().Correspondence.getDocDetailIdReportSeed(), Integer.class));

	String result = "";

	try
	{
		result = client.buildReportAsUrlInlineFrame(obj[0], obj[1], urlReportServer, "PDF", "", 1);
		sb.append(result);

	}
	catch (QueryBuilderClientException e1)
	{
		return e1.toString();
	}

	return sb.toString();
}
 

private String getIFrameCode() throws DomainInterfaceException
{
	StringBuffer sb = new StringBuffer(1000);
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	
	String[] obj = null;
	
	obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());

	if(obj == null || obj.length == 0)
	{
		engine.showMessage("I could not get the report and template !");
		return sb.toString();
	}
	
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer,engine.getSessionId());
			
	//get report seed name
	if (form.getGlobalContext().Correspondence.getDocDetailIdReportSeedIsNotNull())
		client.addSeed(new SeedValue("DocumentDetails_id",form.getGlobalContext().Correspondence.getDocDetailIdReportSeed(),Integer.class));
	
	String result = "";
	
	try
	{
		result = client.buildReportAsUrlInlineFrame(obj[0], obj[1], urlReportServer, "PDF", "",1);
		sb.append(result);
		
	} catch (QueryBuilderClientException e1)
	{
		return e1.toString();
	} 
	
	return sb.toString();
}
 

private void printReport()
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer =ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	String[] obj = null;
	try
	{
		obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());
	}
	catch (DomainInterfaceException e)
	{
		engine.showMessage("Error retrieving report template !\r\n" + e.getMessage());
		return;
	}

	if (obj == null || obj.length == 0)
	{
		engine.showMessage("I could not get the report and template !");
		return;
	}

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	client.addSeed(new SeedValue("CarePlan_id", form.getLocalContext().getCarePlan().getID_CarePlan(), Integer.class));

	String resultUrl = "";

	try
	{
		resultUrl = client.buildReportAsUrl(obj[0], obj[1], urlReportServer, QueryBuilderClient.PDF, "", 1);
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return;
	}

	engine.openUrl(resultUrl);
}
 

private void printReport()
{
	if(form.layerControl1().movement().comboAllMovements().getValue() == null)
	{
		engine.showMessage("No Movement Record Selected");
		return;
	}
	
	
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	String[] obj = null;
	obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());
	
	if(obj == null || obj.length == 0)
	{
		engine.showMessage("Failed to retrieve the report and template !");
		return;
	}
	
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	
	client.addSeed(new SeedValue("PatientMovementHandling_id", form.layerControl1().movement().comboAllMovements().getValue().getID_Assessment(), Integer.class));
	client.addSeed(new SeedValue("PATIDTYPE", new Integer(PatIdType.CHARTNUM.getID()), Integer.class));
	
	String resultUrl = "";
	try
	{
		resultUrl = client.buildReportAsUrl(obj[0], obj[1], urlReportServer, QueryBuilderClient.PDF, "", 1);		
	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return;
	}
	
	engine.openUrl(resultUrl);
}
 

private String createReport(TemplateForPatientDocumentVo repTemplate, PatientDocumentVo doc) 
{
	if(repTemplate == null)
		return null;
	
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	ReportTemplateVo template = domain.getTemplate(repTemplate);

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	ReportSeedParsedVoCollection seeds = getSeedsFromReport(template.getReport().getReportXml());

	addSeedsForTemplate(client, seeds, doc);
	
	if(!addValueForNonMandatorySeeds(client, seeds))//	WDEV-14299
		return null;
	
	String [] errors = checkForSeeds(seeds, client);
	
	if(errors != null && errors.length > 0)
	{
		engine.showErrors(errors);
		return null;
	}
	
	String fileName;
	try
	{
		fileName = client.buildReportAndUpload(getWorkAreaPath(), template.getReport().getReportXml(), template.getTemplateXml(), urlReportServer, QueryBuilderClient.RTF, "", 1, false); //WDEV-13366
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return null;
	}

	return fileName;
}
 

/**
* builds and Assessment report
*/
@Deprecated
public void buildAssessmentReport(ims.vo.ValueObjectRef refVo)
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	
	String obj[] = domain.getReportAndTemplate(refVo);
	
	if(obj == null)
	{
		engine.showMessage("I could not get the report and template linked to this assessment !");
		return;
	}
	
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	client.addSeed(new SeedValue("CareContext_id", form.getGlobalContext().Core.getCurrentCareContextIsNotNull() ? form.getGlobalContext().Core.getCurrentCareContext().getID_CareContext() : null, Integer.class));
	client.addSeed(new SeedValue("ClinicalContact_id", form.getGlobalContext().Core.getCurrentClinicalContactIsNotNull() ? form.getGlobalContext().Core.getCurrentClinicalContact().getID_ClinicalContact() : null, Integer.class));
	
	String resultUrl = "";
	try
	{
		resultUrl = client.buildReportAsUrlInlineFrame(obj[0], obj[1], urlReportServer, QueryBuilderClient.HTML, "", 1);
	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return;
	}
	
	form.htmView().setHTML(resultUrl);
}
 

public void buildAssessmentReport(PatientAssessmentRefVo patientAssessmentRef)
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	
	String obj[] = domain.getReportAndTemplate(patientAssessmentRef);
	
	if (obj == null || obj.length < 2 || obj[0] == null || obj[1] == null)
	{
		engine.showMessage("I could not get the report and template linked to this assessment !");
		return;
	}
	
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	// WDEV-13300
	// PatientAssessment reports in new version use PatientAssessment_ID, but some old versions use a combination of
	// CareContext_id and ClinicalContact_id - so we need to set all tree as seeds. Reports are ignoring the extra & unused seeds
	client.addSeed(new SeedValue("PatientAssessment_id", patientAssessmentRef.getID_PatientAssessment(), Integer.class));
	client.addSeed(new SeedValue("CareContext_id", form.getGlobalContext().Core.getCurrentCareContextIsNotNull() ? form.getGlobalContext().Core.getCurrentCareContext().getID_CareContext() : null, Integer.class));
	client.addSeed(new SeedValue("ClinicalContact_id", form.getGlobalContext().Core.getCurrentClinicalContactIsNotNull() ? form.getGlobalContext().Core.getCurrentClinicalContact().getID_ClinicalContact() : null, Integer.class));
	
	String resultUrl = "";
	try
	{
		resultUrl = client.buildReportAsUrlInlineFrame(obj[0], obj[1], urlReportServer, QueryBuilderClient.HTML, "", 1);
	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return;
	}
	
	form.htmView().setHTML(resultUrl);
}
 

private String createReport(PatientShort patient, CareContextMinVo carecontext,PatientDocumentVo doc, PatientDocumentErrorVoCollection errors)
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	ReportTemplateVo template = domain.getTemplate((TemplateForPatientDocumentVo) form.lyrLetterCreate().tabTemplate().dyngrdReports().getValue());

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	ReportSeedParsedVoCollection seeds = getSeedsFromReport(template.getReport().getReportXml());

	addSeedsForTemplate(client, seeds, patient, carecontext,doc);
	
	if(!addValueForNonMandatorySeeds(client, seeds))//	WDEV-14299
	{
		errors.add(createError(patient, carecontext, "Could not be created"));
		return null;
	}
	
	String [] errorsSeed = checkForSeeds(seeds, client);
	
	if(errorsSeed != null && errorsSeed.length > 0)
	{
		errors.add(createError(patient, carecontext, "Could not be created"));
		return null;
	}
	
	String fileName;
	try
	{
		fileName = client.buildReportAndUpload(getWorkAreaPath(), template.getReport().getReportXml(), template.getTemplateXml(), urlReportServer, QueryBuilderClient.RTF, "", 1, false);//WDEV-13366
	}
	catch (QueryBuilderClientException e1)
	{
		errors.add(createError(patient, carecontext, "Could not be created"));
		e1.printStackTrace();
		return null;
	}

	return fileName;
}
 

private void open()
{

	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	Object[] obj = domain.getSystemReportAndTemplate(new Integer(325));

	if (obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return;
	}

	if (obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return;
	}

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	client.addSeed(new SeedValue("NeedsAssessment_id", form.getGlobalContext().Core.getNeedsAssessmentId(), Integer.class));

	String resultUrl = "";
	try
	{
		resultUrl = client.buildReportAsUrlInlineFrame((String) obj[0], (String) obj[1], urlReportServer, "PDF", "", 1);
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return;
	}

	form.htmViewer().setHTML(resultUrl);
}
 

private void printSelectedAdviceLeaflets()
{
	try
	{
		// Get selected advice leaflets
		AdviceLeafletConfigDisplayVoCollection selectedAdviceLeaflets = new AdviceLeafletConfigDisplayVoCollection();

		for (int i = 0; i < form.grdAdviceLeflet().getRows().size(); i++)
		{
			grdAdviceLefletRow adviceRow = form.grdAdviceLeflet().getRows().get(i);

			if (adviceRow.getColSelect())	selectedAdviceLeaflets.add(adviceRow.getValue());
		}

		// For each selected advice leaflet
		for (AdviceLeafletConfigDisplayVo adviceLeaflet : selectedAdviceLeaflets)
		{
			// Get Report and Template from database
			String report[] = domain.getReportAndTemplate(adviceLeaflet.getTemplate());

			// Check for valid report and template
			if (report == null)
			{
				engine.showMessage("No report found for selected advice leaflet");
				return;
			}

			// Create a query builder client instance
			QueryBuilderClient client = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

			// Attempt to build report and print it to printer
			String printerName = form.getGlobalContext().Admin.getSelectedPrinter() != null ? form.getGlobalContext().Admin.getSelectedPrinter().getIPrinterName() : null;
			client.buildReport(report[0], report[1], ConfigFlag.GEN.REPORT_SERVER_URL.getValue(), "PDF", printerName, 1);
		}
	}
	catch (QueryBuilderClientException exception)
	{
		exception.printStackTrace();
	}
}
 

protected void onGrdAuditSelectionChanged() throws PresentationLogicException
{
	form.ctnDetails().htmDetails().setHTML("");
	String fullClassName = getFullBoName(form.grdAudit().getValue().getClassName());
	
	if(fullClassName == null)
	{
		form.ctnDetails().htmDetails().setHTML("<BR><BR><BR><CENTER><STRONG>No template was linked to '" + form.grdAudit().getValue().getClassName() + "' business object !</STRONG></CENTER>");
	}
	else
	{
		ReportTemplateVo template = domain.getLinkedTemplate(fullClassName);
		
		String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
		String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

		QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

		client.addSeed(new SeedValue("ID", form.grdAudit().getValue().getClassIdentifier(), Integer.class));
		
		String resultUrl = "";
		try
		{
			resultUrl = client.buildReportAsUrlInlineFrame(template.getReport().getReportXml(), template.getTemplateXml(), urlReportServer, QueryBuilderClient.HTML, "", 1);
		} 
		catch (QueryBuilderClientException e1)
		{
			engine.showMessage("Error creating report: " + e1.getMessage());
			return;
		}
		
		form.ctnDetails().htmDetails().setHTML(resultUrl);
	}
}
 

protected void onFormOpen() throws ims.framework.exceptions.FormOpenException
{
	form.cmbFrequency().newRow(daily, daily);
	form.cmbFrequency().newRow(weekly, weekly);
	form.cmbFrequency().newRow(monthly, monthly);
	form.cmbFrequency().newRow(periodically, periodically);

	QueryBuilderClient qbc = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	try
	{
		PrinterAvailableCollection printers = qbc.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());

		String[] printersColl = new String[printers.size()];

		for (int i = 0; i < printers.size(); i++)
		{
			form.grdReportsToPrint().ColumnPrintToComboBox().newRow(printers.get(i).getName(), printers.get(i).getName());
			printersColl[i] = printers.get(i).getName();
		}

		form.getLocalContext().setAvailablePrinters(printersColl);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers list: " + e.toString());
	}

	open();
}
 

protected void onFormOpen() throws ims.framework.exceptions.FormOpenException
{
	form.cmbExport().newRow(QueryBuilderClient.PDF, QueryBuilderClient.PDF);
	form.cmbExport().newRow(QueryBuilderClient.CSV, QueryBuilderClient.CSV);
	form.cmbExport().newRow(QueryBuilderClient.HTML, QueryBuilderClient.HTML);
	form.cmbExport().newRow(QueryBuilderClient.RTF, QueryBuilderClient.RTF);
	form.cmbExport().newRow(QueryBuilderClient.JPEG, QueryBuilderClient.JPEG);
	
	QueryBuilderClient qb = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	PrinterAvailableCollection list = null;
	try
	{
		list = qb.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());
		
		for(int i = 0; i < list.size(); i++)
		{
			form.cmbPrinter().newRow(list.get(i).getName(), list.get(i).getName());
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers from report server: " + e.toString());
	}
	
	Date now = new Date();
	now.addDay(-7);
	Time t = new Time(0,0,0);
	
	form.dtimStart().setValue(new DateTime(now, t));
	form.dtimEnd().setValue(new DateTime());
	searchDocuments(true);
}
 

protected void onBtnPrintClick() throws ims.framework.exceptions.PresentationLogicException
{
	PrintAgentDocumentsVo doc = form.grdDocuments().getValue();
	if(doc == null)
	{
		engine.showMessage("Please select a document to print !");
		return;
	}

	String printer = form.cmbPrinter().getValue();
	if(printer == null || printer.length() == 0)
	{
		engine.showMessage("Please select a printer !");
		return;
	}
	
	QueryBuilderClient qb = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());
	
	try
	{
		qb.printReport(doc.getDocument().getBytes(), ConfigFlag.GEN.REPORT_SERVER_URL.getValue(), printer, 1);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error printing document: " + e.toString());
		return;
	}
}
 

@Override
protected void onBtnPrintResultClick() throws PresentationLogicException
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	//we need a better way to do this
	Object[] obj = domain.getSystemReportAndTemplate(new Integer(75));
	
	if(obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return;
	}
	
	if(obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return;
	}
	
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	
	client.addSeed(new SeedValue("OrderInvestigation_id",  form.getLocalContext().getOrderInv().getBoId(), Integer.class));
	
	String resultUrl = "";
	try
	{
		resultUrl = client.buildReportAsUrl((String)obj[0], (String)obj[1], urlReportServer, "PDF", "", 1);
	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return;
	}
	
	engine.openUrl(resultUrl);
}
 

private String buildReport()
{
	CareContextShortVo currentCareContext = form.getGlobalContext().Core.getCurrentCareContext();
	Object[] obj = null;
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	String url = "";

	Integer reportID = 163;
	obj = domain.getSystemReportAndTemplate(reportID);
	client.addSeed(new SeedValue("CARE_CONTEXT", currentCareContext.getID_CareContext(), Integer.class));

	if (obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return "";
	}

	if (obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return "";
	}

	try
	{
		url = client.buildReportAsUrl((String) obj[0], (String) obj[1], urlReportServer, "PDF", "", 1);
		if (url != null)
		{
			engine.openUrl(url);
		}
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return "";
	}
	return "";
}
 

private String buildReport()
{
	CareContextShortVo currentCareContext = form.getGlobalContext().Core.getCurrentCareContext();
	Object[] obj = null;
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	String url = "";

	Integer reportID = 247;
	obj = domain.getSystemReportAndTemplate(reportID);
	client.addSeed(new SeedValue("CARE_CONTEXT", currentCareContext.getID_CareContext(), Integer.class));

	if (obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return "";
	}

	if (obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return "";
	}

	try
	{
		url = client.buildReportAsUrl((String) obj[0], (String) obj[1], urlReportServer, "PDF", "", 1);
		if (url != null)
		{
			engine.openUrl(url);
		}
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return "";
	}
	return "";
}
 

private void printReport()
{
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	String[] obj = null;

	obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());

	if (obj == null || obj.length == 0)
	{
		engine.showMessage("Failed to retrieve the report and template !");
		return;
	}

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	client.addSeed(new SeedValue("Discharge_id", form.getLocalContext().getDischargeToUpdate() != null ? form.getLocalContext().getDischargeToUpdate().getID_Discharge() : null, Integer.class));
	client.addSeed(new SeedValue("PATIDTYPE", new Integer(PatIdType.CHARTNUM.getID()), Integer.class));

	String resultUrl = "";
	try
	{
		resultUrl = client.buildReportAsUrl(obj[0], obj[1], urlReportServer, QueryBuilderClient.PDF, "", 1);
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return;
	}

	engine.openUrl(resultUrl);
}
 

private String buildReport()
{		
	CareContextShortVo currentCareContext = form.getGlobalContext().Core.getCurrentCareContext();
	Object[] obj = null;
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	String url = "";
	
	Integer reportID = 247;
	obj = domain.getSystemReportAndTemplate(reportID);
	client.addSeed(new SeedValue("CARE_CONTEXT",  currentCareContext.getID_CareContext(), Integer.class));
	
	if(obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return "";
	}
	
	if(obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return "";
	}
			
	try
	{
		url = client.buildReportAsUrlInlineFrame((String)obj[0], (String)obj[1], urlReportServer, "PDF", "", 1);
		if (url != null)
		{
			return url;
		}
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return "";
	}
			
	return "";
}
 

private String buildReport()
{		
	CareContextShortVo currentCareContext = form.getGlobalContext().Core.getCurrentCareContext();
	Object[] obj = null;
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	String url = "";
	
	Integer reportID = 217;
	obj = domain.getSystemReportAndTemplate(reportID);
	client.addSeed(new SeedValue("CareContext_id",  currentCareContext.getID_CareContext(), Integer.class));
	
	if(obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return "";
	}
	
	if(obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return "";
	}
			
	try
	{
		url = client.buildReportAsUrlInlineFrame((String)obj[0], (String)obj[1], urlReportServer, "PDF", "", 1);
		if (url != null)
		{
			return url;
		}
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return "";
	}
			
	return "";
}
 

private String buildReport()
{		
	CareContextShortVo currentCareContext = form.getGlobalContext().Core.getCurrentCareContext();
	Object[] obj = null;
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	String url = "";
	
	Integer reportID = 163;
	obj = domain.getSystemReportAndTemplate(reportID);
	client.addSeed(new SeedValue("CARE_CONTEXT",  currentCareContext.getID_CareContext(), Integer.class));
	
	if(obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return "";
	}
	
	if(obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return "";
	}
			
	try
	{
		url = client.buildReportAsUrlInlineFrame((String)obj[0], (String)obj[1], urlReportServer, "PDF", "", 1);
		if (url != null)
		{
			return url;
		}
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return "";
	}
			
	return "";
}
 

private void printReport()
{
	if(form.layerControl1().movement().comboAllMovements().getValue() == null)
	{
		engine.showMessage("No Movement Record Selected");
		return;
	}
	
	
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	String[] obj = null;
	obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());
	
	if(obj == null || obj.length == 0)
	{
		engine.showMessage("Failed to retrieve the report and template !");
		return;
	}
	
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	
	client.addSeed(new SeedValue("PatientMovementHandling_id", form.layerControl1().movement().comboAllMovements().getValue().getID_Assessment(), Integer.class));
	client.addSeed(new SeedValue("PATIDTYPE", new Integer(PatIdType.CHARTNUM.getID()), Integer.class));
	
	String resultUrl = "";
	try
	{
		resultUrl = client.buildReportAsUrl(obj[0], obj[1], urlReportServer, QueryBuilderClient.PDF, "", 1);		
	} 
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return;
	}
	
	engine.openUrl(resultUrl);
}
 

/**
 * 
 */
private byte[] buildDocumentPDF(CorrespondenceDetailsVo voCorrespondenceDetails) throws QueryBuilderClientException
{
	Integer iDocId;
	iDocId = voCorrespondenceDetails.getID_CorrespondenceDetails();

	form.getGlobalContext().Correspondence.setDocDetailIdReportSeed(iDocId);
	// generate the document for viewing
	form.getGlobalContext().Core.setReportID(form.getGlobalContext().Correspondence.getReportTemplate().getReport().getID_ReportBo());
	form.getGlobalContext().Core.setTemplateID(form.getGlobalContext().Correspondence.getReportTemplate().getID_TemplateBo());

	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	String[] obj = null;
	try
	{
		obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());
	}
	catch (DomainInterfaceException e)
	{
		engine.showMessage("I could not get the report and template !");
		return null;
	}

	if (obj == null || obj.length == 0)
	{
		engine.showMessage("I could not get the report and template !");
		return null;
	}

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	if (form.getGlobalContext().Correspondence.getDocDetailIdReportSeedIsNotNull())
		client.addSeed(new SeedValue("CorrespondenceDetails_id", form.getGlobalContext().Correspondence.getDocDetailIdReportSeed(), Integer.class));

	return client.buildReport(obj[0], obj[1], urlReportServer, QueryBuilderClient.FP3, "", 1);

}
 

protected void onBtnPrintClick() throws ims.framework.exceptions.PresentationLogicException
{
	PrintAgentDocumentsVo doc = form.grdDocuments().getValue();
	if(doc == null)
	{
		engine.showMessage("Please select a document to print !");
		return;
	}

	String printer = form.cmbPrinter().getValue();
	if(printer == null || printer.length() == 0)
	{
		engine.showMessage("Please select a printer !");
		return;
	}
	
	QueryBuilderClient qb = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());
	
	try
	{
		qb.printReport(doc.getDocument().getBytes(), ConfigFlag.GEN.REPORT_SERVER_URL.getValue(), printer, 1);
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error printing document: " + e.toString());
		return;
	}
}
 

private void printSelectedAdviceLeaflets()
{
	try
	{
		// Get selected advice leaflets
		AdviceLeafletConfigDisplayVoCollection selectedAdviceLeaflets = new AdviceLeafletConfigDisplayVoCollection();

		for (int i = 0; i < form.grdAdviceLeflet().getRows().size(); i++)
		{
			grdAdviceLefletRow adviceRow = form.grdAdviceLeflet().getRows().get(i);

			if (adviceRow.getColSelect())	selectedAdviceLeaflets.add(adviceRow.getValue());
		}

		// For each selected advice leaflet
		for (AdviceLeafletConfigDisplayVo adviceLeaflet : selectedAdviceLeaflets)
		{
			// Get Report and Template from database
			String report[] = domain.getReportAndTemplate(adviceLeaflet.getTemplate());

			// Check for valid report and template
			if (report == null)
			{
				engine.showMessage("No report found for selected advice leaflet");
				return;
			}

			// Create a query builder client instance
			QueryBuilderClient client = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

			// Attempt to build report and print it to printer
			String printerName = form.getGlobalContext().Admin.getSelectedPrinter() != null ? form.getGlobalContext().Admin.getSelectedPrinter().getIPrinterName() : null;
			client.buildReport(report[0], report[1], ConfigFlag.GEN.REPORT_SERVER_URL.getValue(), "PDF", printerName, 1);
		}
	}
	catch (QueryBuilderClientException exception)
	{
		exception.printStackTrace();
	}
}
 

private String buildReport()
{		
	CareContextShortVo currentCareContext = form.getGlobalContext().Core.getCurrentCareContext();
	Object[] obj = null;
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	String url = "";
	
	Integer reportID = 247;
	obj = domain.getSystemReportAndTemplate(reportID);
	client.addSeed(new SeedValue("CARE_CONTEXT",  currentCareContext.getID_CareContext(), Integer.class));
	
	if(obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return "";
	}
	
	if(obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return "";
	}
			
	try
	{
		url = client.buildReportAsUrlInlineFrame((String)obj[0], (String)obj[1], urlReportServer, "PDF", "", 1);
		if (url != null)
		{
			return url;
		}
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return "";
	}
			
	return "";
}
 

private String getIFrameCode() throws DomainInterfaceException
{
	StringBuffer sb = new StringBuffer(1000);
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();
	
	String[] obj = null;
	
	obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());

	if(obj == null || obj.length == 0)
	{
		engine.showMessage("I could not get the report and template !");
		return sb.toString();
	}
	
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer,engine.getSessionId());
			
	//get report seed name
	if (form.getGlobalContext().Correspondence.getDocDetailIdReportSeedIsNotNull())
		client.addSeed(new SeedValue("DocumentDetails_id",form.getGlobalContext().Correspondence.getDocDetailIdReportSeed(),Integer.class));
	
	String result = "";
	
	try
	{
		result = client.buildReportAsUrlInlineFrame(obj[0], obj[1], urlReportServer, "PDF", "",1);
		sb.append(result);
		
	} catch (QueryBuilderClientException e1)
	{
		return e1.toString();
	} 
	
	return sb.toString();
}
 

private String buildReport()
{		
	CareContextShortVo currentCareContext = form.getGlobalContext().Core.getCurrentCareContext();
	Object[] obj = null;
	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());
	String url = "";
	
	Integer reportID = 217;
	obj = domain.getSystemReportAndTemplate(reportID);
	client.addSeed(new SeedValue("CareContext_id",  currentCareContext.getID_CareContext(), Integer.class));
	
	if(obj == null || obj.length < 2)
	{
		engine.showMessage("I could not get the report and template !");
		return "";
	}
	
	if(obj[0] == null || obj[1] == null)
	{
		engine.showMessage("The report has not been deployed !");
		return "";
	}
			
	try
	{
		url = client.buildReportAsUrlInlineFrame((String)obj[0], (String)obj[1], urlReportServer, "PDF", "", 1);
		if (url != null)
		{
			return url;
		}
	}
	catch (QueryBuilderClientException e1)
	{
		engine.showMessage("Error creating report: " + e1.getMessage());
		return "";
	}
			
	return "";
}
 

private String getIFrameCode() throws DomainInterfaceException
{
	StringBuffer sb = new StringBuffer(1000);
	String urlQueryServer = ConfigFlag.GEN.QUERY_SERVER_URL.getValue();
	String urlReportServer = ConfigFlag.GEN.REPORT_SERVER_URL.getValue();

	String[] obj = null;

	obj = domain.getReportAndTemplate(form.getGlobalContext().Core.getReportID(), form.getGlobalContext().Core.getTemplateID());

	if (obj == null || obj.length == 0)
	{
		engine.showMessage("I could not get the report and template !");
		return sb.toString();
	}

	QueryBuilderClient client = new QueryBuilderClient(urlQueryServer, engine.getSessionId());

	// get report seed name
	if (form.getGlobalContext().Correspondence.getDocDetailIdReportSeedIsNotNull())
		client.addSeed(new SeedValue("DocumentDetails_id", form.getGlobalContext().Correspondence.getDocDetailIdReportSeed(), Integer.class));

	String result = "";

	try
	{
		result = client.buildReportAsUrlInlineFrame(obj[0], obj[1], urlReportServer, "PDF", "", 1);
		sb.append(result);

	}
	catch (QueryBuilderClientException e1)
	{
		return e1.toString();
	}

	return sb.toString();
}
 

protected void onFormOpen() throws ims.framework.exceptions.FormOpenException
{
	form.cmbExport().newRow(QueryBuilderClient.PDF, QueryBuilderClient.PDF);
	form.cmbExport().newRow(QueryBuilderClient.CSV, QueryBuilderClient.CSV);
	form.cmbExport().newRow(QueryBuilderClient.HTML, QueryBuilderClient.HTML);
	form.cmbExport().newRow(QueryBuilderClient.RTF, QueryBuilderClient.RTF);
	form.cmbExport().newRow(QueryBuilderClient.JPEG, QueryBuilderClient.JPEG);
	
	QueryBuilderClient qb = new QueryBuilderClient(ConfigFlag.GEN.QUERY_SERVER_URL.getValue(), engine.getSessionId());

	PrinterAvailableCollection list = null;
	try
	{
		list = qb.listPrinters(ConfigFlag.GEN.REPORT_SERVER_URL.getValue());
		
		for(int i = 0; i < list.size(); i++)
		{
			form.cmbPrinter().newRow(list.get(i).getName(), list.get(i).getName());
		}
	}
	catch (QueryBuilderClientException e)
	{
		engine.showMessage("Error getting the printers from report server: " + e.toString());
	}
	
	Date now = new Date();
	now.addDay(-7);
	Time t = new Time(0,0,0);
	
	form.dtimStart().setValue(new DateTime(now, t));
	form.dtimEnd().setValue(new DateTime());
	searchDocuments(true);
}