function display() { /* get sort order from session */ //session_start(); // Make a reference to the current session object,set order //$_SESSION['regnamesort']= 'test' ; Set a value in a session variable //$GLOBALS['log']->fatal('start display'); //var_dump($this->bean); $smarty = new Sugar_Smarty(); //parent::display(); $db = DBManagerFactory::getInstance(); $myquery = "SELECT tab4a.first_name fname, tab4a.last_name lname, tab5a.mrn_c mrn, tab4a.gender gender, tab5a.location_c location FROM reg_patient tab4a , reg_patient_cstm tab5a WHERE tab4a.id = tab5a.id_c AND tab4a.id = '" . $_REQUEST['patid'] . "'"; $result = $db->query($myquery); $patdata = null; $row = $db->fetchRow($result); $smarty->assign("patdata", $row); $risk = new RiskEvaluation(); //when week filter need to add week interval //get patient risk if exists //if ($_POST['mysort'] == 'week') if (!empty($_REQUEST['patid'])) { $risk->getRisk($_REQUEST['patid']); $risk->getComm($_REQUEST['patid']); $smarty->assign("pid", $_REQUEST['patid']); } //echo 'request'.$_REQUEST['patid']; //else return false; //param not found //var_dump($risk); $smarty->assign("myrisk", $risk); //$smarty->assign("mycomm", $risk); global $current_user; $smarty->assign("myuser", $current_user); $smarty->display('custom/modules/REG_Patient/tpls/CommScoreREG_Patient.tpl'); }