<?php
require_once 'config.php';
require_once '../codebase/dhtmlx/grid_connector.php';
$grid = new GridConnector($conn);
$grid->enable_log("log.txt", true);
$grid->render_complex_sql("SELECT `DicomWorklist`.* FROM DicomWorklist INNER JOIN DicomWorklistExclude ON `DicomWorklist`.`RequestedProcedureDescription` = `DicomWorklistExclude`.`RequestedProcedureDescription`", "StudyInstanceUID", "PatientName, PatientID, PatientDOB, PatientSex, RequestedProcedureDescription, CurrentPatientLocation, Modality");
<?php
require_once 'config.php';
require_once "../codebase/dhtmlx/grid_connector.php";
$conn = new GridConnector($conn);
$conn->enable_log("log.txt", true);
$conn->render_complex_sql("SELECT * FROM generators WHERE decommission_date IS NULL", "generator_id", "generator_id,batch_number ,supplier_name ,arrival_date ,arrival_username,decommission_date,decommission_username,return_date,qc_moly_status,qc_alum__status,qc_visual_status,site");
?>
