/** * @see ViewQuickcreate::display() */ public function display() { $userPref = $GLOBALS['current_user']->getPreference('email_link_type'); $defaultPref = $GLOBALS['sugar_config']['email_default_client']; if ($userPref != '') { $client = $userPref; } else { $client = $defaultPref; } if ($client == 'sugar') { $eUi = new EmailUI(); if (!empty($this->bean->id) && !in_array($this->bean->object_name, array('EmailMan'))) { $fullComposeUrl = "index.php?module=Emails&action=Compose&parent_id={$this->bean->id}&parent_type={$this->bean->module_dir}"; $composeData = array('parent_id' => $this->bean->id, 'parent_type' => $this->bean->module_dir); } else { $fullComposeUrl = "index.php?module=Emails&action=Compose"; $composeData = array('parent_id' => '', 'parent_type' => ''); } $j_quickComposeOptions = $eUi->generateComposePackageForQuickCreate($composeData, $fullComposeUrl); $json_obj = getJSONobj(); $opts = $json_obj->decode($j_quickComposeOptions); $opts['menu_id'] = 'dccontent'; $ss = new Sugar_Smarty(); $ss->assign('json_output', $json_obj->encode($opts)); $ss->display('modules/Emails/templates/dceMenuQuickCreate.tpl'); } else { $emailAddress = ''; if (!empty($this->bean->id) && !in_array($this->bean->object_name, array('EmailMan')) && !is_null($this->bean->emailAddress)) { $emailAddress = $this->bean->emailAddress->getPrimaryAddress($this->bean); } echo "<script>document.location.href='mailto:{$emailAddress}';lastLoadedMenu=undefined;DCMenu.closeOverlay();</script>"; die; } }
function display() { $db = DBManagerFactory::getInstance(); /* <<<<<<< HEAD $sql = "SELECT p.id,p.first_name,p.last_name,p.dob FROM reg_patient p WHERE p.id not in (SELECT distinct pe.reg_patient_reg_encounterreg_patient_ida FROM `reg_patient_reg_encounter_c` pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND e.next_pmp_review_due_c is not null) ORDER By p.last_name, p.first_name"; ======= */ $sql = "SELECT p.id,p.first_name,p.last_name,p.dob, rec.mrn_c AS mrn,(SELECT p1b.name provname FROM reg_provider p1b,reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = p.id AND p2b.deleted =0)provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c = p.id WHERE p.id not in (SELECT distinct pe.reg_patient_reg_encounterreg_patient_ida FROM `reg_patient_reg_encounter_c` pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND e.last_pmp_review_done_c is not null) ORDER By p.last_name, p.first_name"; // >>>>>>> 3097a71433de82fec730df252659026274347e46 $resultb = $db->query($sql, true); $final = array(); while ($row = $db->fetchByAssoc($resultb)) { $final[] = $row; } $sql1 = "SELECT p.id, rec.mrn_c AS mrn,(SELECT p1b.name provname FROM reg_provider p1b,reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = p.id AND p2b.deleted =0)provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c = p.id WHERE p.id not in (SELECT distinct pe.reg_patient_reg_encounterreg_patient_ida FROM `reg_patient_reg_encounter_c` pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND e.last_pmp_review_done_c is not null) GROUP BY provname ORDER By p.last_name, p.first_name"; $resultb1 = $db->query($sql1, true); $final1 = array(); while ($row1 = $db->fetchByAssoc($resultb1)) { $final1[] = $row1; } $sugarSmarty = new Sugar_Smarty(); $sugarSmarty->assign("data", $final); $sugarSmarty->assign("data1", $final1); $sugarSmarty->assign("title", "Patients who do not have PMP"); $sugarSmarty->display('custom/modules/REG_Patient/tpls/Report1REG_Patient.tpl'); // parent::display(); }
function display() { global $mod_strings, $app_strings; require_once 'include/connectors/utils/ConnectorUtils.php'; require_once 'include/connectors/sources/SourceFactory.php'; $sugar_smarty = new Sugar_Smarty(); $sugar_smarty->assign('mod', $mod_strings); $sugar_smarty->assign('APP', $app_strings); $connectors = ConnectorUtils::getConnectors(true); $required_fields = array(); //Get required fields for first connector only foreach ($connectors as $id => $entry) { $s = SourceFactory::getSource($id); $connector_strings = ConnectorUtils::getConnectorStrings($id); $fields = $s->getRequiredConfigFields(); foreach ($fields as $field_id) { $label = isset($connector_strings[$field_id]) ? $connector_strings[$field_id] : $field_id; $required_fields[$id][$field_id] = $label; } break; } $sugar_smarty->assign('SOURCES', $connectors); $sugar_smarty->assign('REQUIRED_FIELDS', $required_fields); echo get_module_title('Connectors', $mod_strings['LBL_MODIFY_PROPERTIES_PAGE_TITLE'], true); $sugar_smarty->display('modules/Connectors/tpls/modify_properties.tpl'); }
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,location_c 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']); $smarty->assign("pid", $_REQUEST['patid']); } //echo 'request'.$_REQUEST['patid']; //else return false; //param not found //var_dump($risk); //print "<pre>"; //print_r($risk); $smarty->assign("myrisk", $risk); global $current_user; $smarty->assign("myuser", $current_user); $smarty->assign("test", "test"); $smarty->display('custom/modules/REG_Patient/tpls/RiskEvaluationREG_Patient.tpl'); }
function display() { global $app_strings, $current_user, $mod_strings, $app_list_strings; $smarty = new Sugar_Smarty(); require_once 'include/JSON.php'; //Load the field list from the target module $selected_lang = $_SESSION['authenticated_user_language']; $vardef = array(); //Copy app strings $my_list_strings = array_merge($app_list_strings); $child = $_REQUEST['field']; //if we are using ModuleBuilder then process the following if (!empty($_REQUEST['package']) && $_REQUEST['package'] != 'studio') { require_once 'modules/ModuleBuilder/MB/ModuleBuilder.php'; $mb = new ModuleBuilder(); $this->module = $mb->getPackageModule($_REQUEST['package'], $_REQUEST['view_module']); $vardef = $this->module->getVardefs(); $this->module->mblanguage->generateAppStrings(false); $my_list_strings = array_merge($my_list_strings, $this->module->mblanguage->appListStrings[$selected_lang . '.lang.php']); } else { $vardef = BeanFactory::getBean($_REQUEST['view_module'])->field_defs; } foreach ($my_list_strings as $key => $value) { if (!is_array($value)) { unset($my_list_strings[$key]); } } $parents = $this->getParentDDs($vardef, $child, $my_list_strings); $visibility_grid = !empty($vardef[$child]['visibility_grid']) ? $vardef[$child]['visibility_grid'] : array(); $smarty->assign('app_strings', $app_strings); $smarty->assign('mod', $mod_strings); $smarty->assign('parents', JSON::encode($parents)); $smarty->assign('visibility_grid', JSON::encode($visibility_grid)); $smarty->display('modules/ExpressionEngine/tpls/ddEditor.tpl'); }
function display() { global $app_strings, $current_user, $mod_strings, $theme; if (is_dir("themes/{$theme}/ext/resources/css")) { $cssDir = opendir("themes/{$theme}/ext/resources/css"); } $smarty = new Sugar_Smarty(); $type = !empty($_REQUEST['type']) ? $_REQUEST['type'] : 'main'; $mbt = false; $admin = false; $mb = strtolower($type); $smarty->assign('TYPE', $type); $smarty->assign('app_strings', $app_strings); $smarty->assign('mod', $mod_strings); //Replaced by javascript function "setMode" switch ($type) { case 'studio': //$smarty->assign('ONLOAD','ModuleBuilder.getContent("module=ModuleBuilder&action=wizard")'); require_once 'modules/ModuleBuilder/Module/StudioTree.php'; $mbt = new StudioTree(); break; case 'mb': //$smarty->assign('ONLOAD','ModuleBuilder.getContent("module=ModuleBuilder&action=package&package=")'); require_once 'modules/ModuleBuilder/MB/MBPackageTree.php'; $mbt = new MBPackageTree(); break; case 'dropdowns': // $admin = is_admin($current_user); require_once 'modules/ModuleBuilder/Module/DropDownTree.php'; $mbt = new DropDownTree(); break; default: //$smarty->assign('ONLOAD','ModuleBuilder.getContent("module=ModuleBuilder&action=home")'); require_once 'modules/ModuleBuilder/Module/MainTree.php'; $mbt = new MainTree(); } $smarty->assign('TEST_STUDIO', displayStudioForCurrentUser()); $smarty->assign('ADMIN', is_admin($current_user)); $smarty->display('modules/ModuleBuilder/tpls/includes.tpl'); if ($mbt) { $smarty->assign('TREE', $mbt->fetch()); $smarty->assign('TREElabel', $mbt->getName()); } $userPref = $current_user->getPreference('mb_assist', 'Assistant'); if (!$userPref) { $userPref = "na"; } $smarty->assign('userPref', $userPref); /////////////////////////////////// require_once 'include/SugarTinyMCE.php'; $tiny = new SugarTinyMCE(); $tiny->defaultConfig['width'] = 300; $tiny->defaultConfig['height'] = 300; $tiny->buttonConfig = "code,separator,bold,italic,underline,strikethrough,separator,justifyleft,justifycenter,justifyright,\n\t justifyfull,separator,forecolor,backcolor,\n\t "; $tiny->buttonConfig2 = "pastetext,pasteword,fontselect,fontsizeselect,"; $tiny->buttonConfig3 = ""; $ed = $tiny->getInstance(); $smarty->assign("tiny", $ed); $smarty->display('modules/ModuleBuilder/tpls/index.tpl'); }
function display() { $template = new Sugar_Smarty(); $template->assign('subpanel_tabs', $this->tabs); $template->assign('subpanel_tabs_count', count($this->tabs)); $template->assign('jscallback', $this->jscallback); $template->assign('subpanel_current_key', $this->current_key); return $template->display('include/tabs.tpl'); }
function display() { global $mod_strings, $app_strings; echo get_module_title('Connectors', $mod_strings['LBL_ADMINISTRATION_MAIN'], true); $sugar_smarty = new Sugar_Smarty(); $sugar_smarty->assign('mod', $mod_strings); $sugar_smarty->assign('app', $app_strings); $sugar_smarty->assign('IMG', 'themes/default/images/'); $sugar_smarty->display('modules/Connectors/tpls/administration.tpl'); }
function display() { require_once "include/Expressions/Dependency.php"; require_once "include/TemplateHandler/TemplateHandler.php"; $th = new TemplateHandler(); $depScript = $th->createDependencyJavascript(array('phone_office' => array('calculated' => true, "formula" => 'add(strlen($name), $employees)', "enforced" => true)), array(), "EditView"); $smarty = new Sugar_Smarty(); $smarty->assign("dependencies", $depScript); $smarty->display('modules/ExpressionEngine/tpls/cfTest.tpl'); }
function display() { global $app_strings, $current_user, $mod_strings, $theme, $beanList, $beanFiles; $smarty = new Sugar_Smarty(); $json = new JSON(); require_once 'include/JSON.php'; //Load the field list from the target module if (!empty($_REQUEST['targetModule']) && $_REQUEST['targetModule'] != 'undefined') { $module = $_REQUEST['targetModule']; if (isset($_REQUEST['package']) && $_REQUEST['package'] != 'studio' && $_REQUEST['package'] != '') { //Get the MB Parsers require_once 'modules/ModuleBuilder/MB/MBPackage.php'; $pak = new MBPackage($_REQUEST['package']); $defs = $pak->modules[$module]->getVardefs(); $fields = FormulaHelper::cleanFields(array_merge($pak->modules[$module]->getLinkFields(), $defs['fields'])); } else { $seed = BeanFactory::getBean($module); $fields = FormulaHelper::cleanFields($seed->field_defs); } $smarty->assign('Field_Array', $json->encode($fields)); } else { $fields = array(array('income', 'number'), array('employed', 'boolean'), array('first_name', 'string'), array('last_name', 'string')); $smarty->assign('Field_Array', $json->encode($fields)); } if (!empty($_REQUEST['targetField'])) { $smarty->assign("target", $_REQUEST['targetField']); } if (isset($_REQUEST['returnType'])) { $smarty->assign("returnType", $_REQUEST['returnType']); } //Assign any requested Javascript event actions foreach (array('onSave', 'onLoad', 'onClose') as $e) { if (!empty($_REQUEST[$e])) { $smarty->assign($e, html_entity_decode($_REQUEST[$e], ENT_QUOTES)); } else { $smarty->assign($e, 'function(){}'); } } //Check if we need to load Ext ourselves if (!isset($_REQUEST['loadExt']) || $_REQUEST['loadExt'] && $_REQUEST['loadExt'] != "false") { $smarty->assign('loadExt', true); } else { $smarty->assign('loadExt', false); } if (!empty($_REQUEST['formula'])) { $smarty->assign('formula', $json->decode(htmlspecialchars_decode($_REQUEST['formula']))); } if (isset($_REQUEST['returnType'])) { $smarty->assign('returnType', $_REQUEST['returnType']); } $smarty->assign('app_strings', $app_strings); $smarty->assign('mod', $mod_strings); $smarty->display('modules/ExpressionEngine/tpls/formulaBuilder.tpl'); }
function display() { global $app_strings, $current_user, $mod_strings, $theme; if (is_dir("themes/{$theme}/ext/resources/css")) { $cssDir = opendir("themes/{$theme}/ext/resources/css"); } $smarty = new Sugar_Smarty(); $type = !empty($_REQUEST['type']) ? $_REQUEST['type'] : 'main'; $mbt = false; $admin = false; $mb = strtolower($type); $smarty->assign('TYPE', $type); $smarty->assign('app_strings', $app_strings); $smarty->assign('mod', $mod_strings); //Replaced by javascript function "setMode" switch ($type) { case 'studio': //$smarty->assign('ONLOAD','ModuleBuilder.getContent("module=ModuleBuilder&action=wizard")'); require_once 'modules/ModuleBuilder/Module/StudioTree.php'; $mbt = new StudioTree(); break; case 'mb': //$smarty->assign('ONLOAD','ModuleBuilder.getContent("module=ModuleBuilder&action=package&package=")'); require_once 'modules/ModuleBuilder/MB/MBPackageTree.php'; $mbt = new MBPackageTree(); break; case 'sugarportal': require_once 'modules/ModuleBuilder/Module/SugarPortalTree.php'; $mbt = new SugarPortalTree(); break; case 'dropdowns': // $admin = is_admin($current_user); require_once 'modules/ModuleBuilder/Module/DropDownTree.php'; $mbt = new DropDownTree(); break; default: //$smarty->assign('ONLOAD','ModuleBuilder.getContent("module=ModuleBuilder&action=home")'); require_once 'modules/ModuleBuilder/Module/MainTree.php'; $mbt = new MainTree(); } $smarty->assign('TEST_STUDIO', displayStudioForCurrentUser()); $smarty->assign('ADMIN', is_admin($current_user)); $smarty->display('modules/ModuleBuilder/tpls/includes.tpl'); if ($mbt) { $smarty->assign('TREE', $mbt->fetch()); $smarty->assign('TREElabel', $mbt->getName()); } $userPref = $current_user->getPreference('mb_assist', 'Assistant'); if (!$userPref) { $userPref = "na"; } $smarty->assign('userPref', $userPref); $smarty->display('modules/ModuleBuilder/tpls/index.tpl'); }
function display() { require_once 'include/connectors/utils/ConnectorUtils.php'; require_once 'include/connectors/sources/SourceFactory.php'; global $mod_strings, $app_strings; $sugar_smarty = new Sugar_Smarty(); $sugar_smarty->assign('mod', $mod_strings); $sugar_smarty->assign('APP', $app_strings); $connectors = ConnectorUtils::getConnectors(true); $sugar_smarty->assign('SOURCES', $connectors); echo get_module_title('Connectors', $mod_strings['LBL_MODIFY_MAPPING_PAGE_TITLE'], true); $sugar_smarty->display('modules/Connectors/tpls/modify_mapping.tpl'); }
function display() { echo "TESTING ONLY"; $pm = new PatientMedList('123'); $pm->GetMedsDB(); echo "there"; $sugarSmarty = new Sugar_Smarty(); $sugarSmarty->assign("duration", $duration); $sugarSmarty->assign("med", $pm->medlist); $sugarSmarty->assign("patid", $pm->patid); $sugarSmarty->assign("title", "Test med"); $sugarSmarty->display('custom/modules/REG_Patient/tpls/testmed.tpl'); // parent::display(); }
function display() { //$provlist = Array(); $smarty = new Sugar_Smarty(); //parent::display(); $db = DBManagerFactory::getInstance(); $queryprov = "SELECT p1b.id provid, p1b.name provname from reg_provider p1b ORDER BY provname"; $sql = $db->query($queryprov); while (($a = $db->fetchByAssoc($sql)) != null) { $provlist[] = array("provid" => $a["provid"], "provname" => $a["provname"]); } echo "here"; $smarty->assign("provlist", $provlist); $smarty->display('custom/modules/REG_Patient/tpls/ReportMain.tpl'); }
function display() { $smarty = new Sugar_Smarty(); parent::display(); $db = DBManagerFactory::getInstance(); //$myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn, tab4.id patid, tab5.location_c location, tab5.active_c active, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab3.last_uts_c,"%m/%d/%Y") uts1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) last_uts , ( SELECT DATE_FORMAT(tab3.next_uts_due_c,"%m/%d/%Y") uts11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) uts , (SELECT DATE_FORMAT(tab3.next_pcp_visit_c,"%m/%d/%Y") pcp11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) next_pcp, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname, ( SELECT risklvl_c risk1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) risk FROM reg_patient tab4, reg_patient_cstm tab5, reg_patient_reg_encounter_c tab1, ( SELECT max( date_modified ) dat, reg_patient_reg_encounterreg_patient_ida pat FROM reg_patient_reg_encounter_c GROUP BY reg_patient_reg_encounterreg_patient_ida) tab2, reg_encounter_cstm tab3 WHERE tab5.id_c = tab4.id AND tab1.date_modified = tab2.dat AND tab1.reg_patient_reg_encounterreg_patient_ida = tab2.pat AND tab3.id_c = tab1.reg_patient_reg_encounterreg_encounter_idb AND tab4.id = tab2.pat'; $myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn, tab4.id patid, tab5.location_c location, tab5.active_c active, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab3.last_uts_c,"%m/%d/%Y") uts1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) last_uts , ( SELECT DATE_FORMAT(tab3.next_uts_due_c,"%m/%d/%Y") uts11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) uts , (SELECT DATE_FORMAT(tab3.next_pcp_visit_c,"%m/%d/%Y") pcp11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) next_pcp, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname, ( SELECT risklvl_c risk1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) risk FROM reg_patient tab4, reg_patient_cstm tab5 WHERE tab5.id_c = tab4.id '; $result = $db->query($myquery); $mydata = null; while ($row = $db->fetchRow($result)) { $mydata[] = $row; } global $cal_strings, $current_language; $cal_strings = return_module_language($current_language, 'Calendar'); if (empty($_REQUEST['view'])) { $_REQUEST['view'] = SugarConfig::getInstance()->get('calendar.default_view', 'week'); } $cal = new Calendar($_REQUEST['view']); if (in_array($cal->view, array('day', 'week', 'month'))) { $cal->add_activities($GLOBALS['current_user']); } else { if ($cal->view == 'shared') { $cal->init_shared(); global $shared_user; $shared_user = new User(); foreach ($cal->shared_ids as $member) { $shared_user->retrieve($member); $cal->add_activities($shared_user); } } } if (in_array($cal->view, array("day", "week", "month", "shared"))) { $cal->load_activities(); } if (!empty($_REQUEST['print']) && $_REQUEST['print'] == 'true') { $cal->setPrint(true); } $display = new CalendarDisplay($cal); $smarty->assign("mydata", $mydata); echo "<table><tr><td>"; $smarty->display($this->lv->tpl); echo "</td>"; echo "<td style='width:100%;vertical-align:top'>"; $caltest = new caltest(); $caltest->test(); echo "</td></tr></table>"; }
function display() { $db = DBManagerFactory::getInstance(); $sql = "SELECT pc.mrn_c pmrn, p.id patid, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname, last_name,first_name FROM reg_patient p, reg_patient_cstm pc WHERE p.id=pc.id_c "; $resultb = $db->query($sql, true); $final = array(); while ($row = $db->fetchByAssoc($resultb)) { $final[] = $row; } $sugarSmarty = new Sugar_Smarty(); //$sugarSmarty->assign("duration",$duration); $sugarSmarty->assign("mydata", $final); $sugarSmarty->assign("title", "UTS Entry"); $snip = new REG_PatientViewTestMed(); //echo $snip->snippy(); $sugarSmarty->assign("snippet", $snip->snippet()); $sugarSmarty->display('custom/modules/REG_Patient/tpls/utsentryREG_Patient.tpl'); // parent::display(); }
function display() { $smarty = new Sugar_Smarty(); parent::display(); $db = DBManagerFactory::getInstance(); $restrict_query = ""; global $current_user; //var_dump(get_defined_vars()); //if(isset($current_user) AND $current_user->check_role_membership('WASSER_PATIENTS')) { echo "This user is in role"; $location_query = " AND location_c IN ('BMC_WALLEY') ";} //elseif (isset($current_user) AND $current_user->check_role_membership('ALL_PATIENTS')) { echo "Super user"; $location_query = " ";} //else { echo "This user is not in role"; $location_query = " AND location_c NOT IN ('BMC_WALLEY') ";} if (isset($current_user) and $current_user->check_role_membership('PRESCRIBER_ONLY')) { $provider = GetProviders(); //echo "GOT providers"; $restrict_query = " AND provpat.reg_provider_reg_patientreg_provider_ida IN (" . $provider . ") "; } if (isset($current_user) and $current_user->check_role_membership('MULTI_LOCATION')) { $location = GetLocations(); $restrict_query = " AND tab5.location_c IN ({$location}) "; } if (isset($current_user) and $current_user->check_role_membership('ALL_LOCATIONS')) { $restrict_query = " "; } echo "restrict is " . $restrict_query . "<<<<"; //$myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn, tab4.id patid, tab5.location_c location, tab5.active_c active, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab3.last_uts_c,"%m/%d/%Y") uts1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) last_uts , ( SELECT DATE_FORMAT(tab3.next_uts_due_c,"%m/%d/%Y") uts11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) uts , (SELECT DATE_FORMAT(tab3.next_pcp_visit_c,"%m/%d/%Y") pcp11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) next_pcp, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname, ( SELECT risklvl_c risk1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) risk FROM reg_patient tab4, reg_patient_cstm tab5, reg_patient_reg_encounter_c tab1, ( SELECT max( date_modified ) dat, reg_patient_reg_encounterreg_patient_ida pat FROM reg_patient_reg_encounter_c GROUP BY reg_patient_reg_encounterreg_patient_ida) tab2, reg_encounter_cstm tab3 WHERE tab5.id_c = tab4.id AND tab1.date_modified = tab2.dat AND tab1.reg_patient_reg_encounterreg_patient_ida = tab2.pat AND tab3.id_c = tab1.reg_patient_reg_encounterreg_encounter_idb AND tab4.id = tab2.pat'; // <<<<<<< HEAD //02/25//$myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn, tab4.id patid, tab5.location_c location, tab5.active_c active, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab3.last_uts_c,"%m/%d/%Y") uts1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) last_uts , ( SELECT DATE_FORMAT(tab3.next_uts_due_c,"%m/%d/%Y") uts11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) uts , (SELECT DATE_FORMAT(tab3.next_pcp_visit_c,"%m/%d/%Y") pcp11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) next_pcp, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid AND p2b.deleted = 0) provname, ( SELECT risklvl_c risk1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) risk FROM reg_patient tab4, reg_patient_cstm tab5 WHERE tab5.id_c = tab4.id '; $myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, DATE_FORMAT(tab4.dob,"%m/%d/%Y") dob, tab4.primary_address_postalcode zip, tab5.mrn_c mrn, tab5.audit_flag_c audit_flag, tab5.reg_patient_status_c status, tab4.id patid, tab5.location_c location, tab5.active_c active, DATE_FORMAT(tab5.pmp_date_c,"%m/%d/%Y") pmp_date, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) LIMIT 1 ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(MAX(tabuts.test_date),"%m/%d/%Y") uts1 FROM reg_patient_uts_import tabuts where tabuts.patient_mrn = mrn ) last_uts, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid AND p2b.deleted = 0) provname, ( SELECT finalscore from reg_patient_risk where pid = tab4.id LIMIT 1 ) risk FROM reg_patient tab4, reg_patient_cstm tab5, reg_provider_reg_patient_c provpat WHERE tab5.id_c = tab4.id AND provpat.reg_provider_reg_patientreg_patient_idb = tab4.id ' . $restrict_query; // ======= /* $myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn, tab4.id patid, tab5.location_c location, tab5.active_c active, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,"%m/%d/%Y") ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab3.last_uts_c,"%m/%d/%Y") uts1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) last_uts , ( SELECT DATE_FORMAT(tab3.next_uts_due_c,"%m/%d/%Y") uts11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) uts , (SELECT DATE_FORMAT(tab3.next_pcp_visit_c,"%m/%d/%Y") pcp11 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) next_pcp, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname, ( SELECT finalscore risk1 FROM reg_patient_risk where pid = patid ) risk FROM reg_patient tab4, reg_patient_cstm tab5 WHERE tab5.id_c = tab4.id '; */ // >>>>>>> 3097a71433de82fec730df252659026274347e46 $start = microtime(true); $result = $db->query($myquery); $mydata = null; while ($row = $db->fetchRow($result)) { $mydata[] = $row; } $smarty->assign("mydata", $mydata); $smarty->display($this->lv->tpl); printf("Total time cached query: %.6fs\n", microtime(true) - $start); }
/** * display * Override the display method to support customization for the buttons that display * a popup and allow you to copy the account's address into the selected contacts. * The custom_code_billing and custom_code_shipping Smarty variables are found in * include/SugarFields/Fields/Address/DetailView.tpl (default). If it's a English U.S. * locale then it'll use file include/SugarFields/Fields/Address/en_us.DetailView.tpl. */ function display() { global $app_strings, $app_list_strings; global $mod_strings; $this->dv->ss->assign('RESPONSES', $this->bean->get_responses()); parent::display(); $smarty = new Sugar_Smarty(); $smarty->assign('APP', $app_strings); $smarty->assign('MOD', $mod_strings); $smarty->assign('RECORD', $this->bean->id); $popup_request_data = array('call_back_function' => 'set_return', 'form_name' => 'xeBayMessageReply', 'field_to_name_array' => array('description' => 'response')); $json = getJSONobj(); $smarty->assign('ENCODED_TEMPLATES_POPUP_REQUEST_DATA', $json->encode($popup_request_data)); $smarty->assign("TEMPLATE_SELECT", SugarThemeRegistry::current()->getImage('id-ff-select', '', null, null, '.png', $mod_strings['LBL_SELECT'])); $smarty->assign("TEMPLATE_CLEAR", SugarThemeRegistry::current()->getImage('id-ff-clear', '', null, null, '.gif', $mod_strings['LBL_ID_FF_CLEAR'])); $smarty->assign('SALUTATION', str_replace("\n", "<br>", $this->bean->get_salutation())); $smarty->assign('RESPONSE', $this->bean->get_template()); $smarty->assign('SIGNATURE', str_replace("\n", "<br>", $this->bean->get_signature())); $smarty->display("modules/xeBayMessages/tpls/reply.tpl"); $this->bean->read_status_update($this->bean->id, true); }
function display() { $db = DBManagerFactory::getInstance(); $sql = "SELECT p.id patid,p.first_name,p.last_name,p.dob, rec.mrn_c as mrn, ( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink, ( SELECT DATE_FORMAT(tab3.next_rx_refill_due_c,'%m/%d/%Y') ref1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) refill, ( SELECT DATE_FORMAT(tab4.next_pill_ct_c,'%m/%d/%Y') ref1 FROM reg_encounter_cstm tab4 where tab4.id_c = enclink ) next_pill_count, ( SELECT risklvl_c risk1 FROM reg_encounter_cstm tab3 where tab3.id_c = enclink ) risk,(SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c=p.id WHERE p.id not in (SELECT distinct pe.reg_patient_reg_encounterreg_patient_ida FROM `reg_patient_reg_encounter_c` pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND (next_pill_ct_c is not null)) ORDER BY p.last_name, p.first_name"; $resultb = $db->query($sql, true); $final = array(); while ($row = $db->fetchByAssoc($resultb)) { $final[] = $row; } $sql1 = "SELECT p.id patid,( SELECT tab1.reg_patient_reg_encounterreg_encounter_idb enclink FROM reg_patient_reg_encounter_c tab1 WHERE tab1.reg_patient_reg_encounterreg_patient_ida = patid AND tab1.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = patid) ) enclink,(SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c=p.id WHERE p.id not in (SELECT distinct pe.reg_patient_reg_encounterreg_patient_ida FROM `reg_patient_reg_encounter_c` pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND (next_pill_ct_c is not null)) GROUP BY provname ORDER BY p.last_name, p.first_name"; $resultb1 = $db->query($sql1, true); $final1 = array(); while ($row1 = $db->fetchByAssoc($resultb1)) { $final1[] = $row1; } $sugarSmarty = new Sugar_Smarty(); $sugarSmarty->assign("data", $final); $sugarSmarty->assign("data1", $final1); $sugarSmarty->assign("title", "Patients who not have Next Pill Count"); $sugarSmarty->display('custom/modules/REG_Patient/tpls/Report5REG_Patient.tpl'); // parent::display(); }
function display() { $db = DBManagerFactory::getInstance(); $sql = "SELECT tab4.first_name fname, tab4.last_name lname, tab5.mrn_c mrn,tab5.date_inactive_c as date_inactive, tab4.id patid, tab5.location_c location, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname FROM reg_patient tab4, reg_patient_cstm tab5 WHERE tab5.id_c = tab4.id AND (tab5.active_c!=1 OR tab5.active_c is NULL) ORDER BY tab4.last_name, tab4.first_name"; $resultb = $db->query($sql, true); $final = array(); while ($row = $db->fetchByAssoc($resultb)) { $final[] = $row; } $sql1 = "SELECT tab4.id patid,(SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname FROM reg_patient tab4, reg_patient_cstm tab5 WHERE tab5.id_c = tab4.id AND (tab5.active_c!=1 OR tab5.active_c is NULL) GROUP BY provname ORDER BY tab4.last_name, tab4.first_name"; $resultb1 = $db->query($sql1, true); $final1 = array(); while ($row1 = $db->fetchByAssoc($resultb1)) { $final1[] = $row1; } $sugarSmarty = new Sugar_Smarty(); $sugarSmarty->assign("data", $final); $sugarSmarty->assign("data1", $final1); $sugarSmarty->assign("title", "Patients who are Inactive"); $sugarSmarty->display('custom/modules/REG_Patient/tpls/Report4REG_Patient.tpl'); // parent::display(); }
function display() { $db = DBManagerFactory::getInstance(); $sql = "SELECT p.id,p.first_name,p.last_name,p.dob,e.id_c, max(e.last_pmp_review_done_c) as last_pmp_review, rec.mrn_c AS mrn,(SELECT p1b.name provname FROM reg_provider p1b,reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = p.id AND p2b.deleted =0)provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c = p.id,`reg_patient_reg_encounter_c` pe,reg_encounter_cstm e WHERE p.id=pe.reg_patient_reg_encounterreg_patient_ida AND pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND e.last_pmp_review_done_c is not null group by p.id ORDER By p.last_name, p.first_name"; $resultb = $db->query($sql, true); $final = array(); while ($row = $db->fetchByAssoc($resultb)) { $final[] = $row; } $sql1 = "SELECT p.id,e.id_c, rec.mrn_c AS mrn,(SELECT p1b.name provname FROM reg_provider p1b,reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = p.id AND p2b.deleted =0)provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c = p.id,`reg_patient_reg_encounter_c` pe,reg_encounter_cstm e WHERE p.id=pe.reg_patient_reg_encounterreg_patient_ida AND pe.reg_patient_reg_encounterreg_encounter_idb=e.id_c AND e.last_pmp_review_done_c is not null group by provname ORDER By p.last_name, p.first_name"; $resultb1 = $db->query($sql1, true); $final1 = array(); while ($row1 = $db->fetchByAssoc($resultb1)) { $final1[] = $row1; } $sugarSmarty = new Sugar_Smarty(); $sugarSmarty->assign("data", $final); $sugarSmarty->assign("data1", $final1); $sugarSmarty->assign("title", "Patients with last PMP"); $sugarSmarty->display('custom/modules/REG_Patient/tpls/Report2REG_Patient.tpl'); // parent::display(); }
function display() { $smarty = new Sugar_Smarty(); parent::display(); $db = DBManagerFactory::getInstance(); $myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab1.date_modified, tab3.next_rx_refill_due_c refill, tab2.pat patid, tab5.mrn_c mrn FROM reg_patient_reg_encounter_c tab1, ( SELECT max( date_modified ) dat, reg_patient_reg_encounterreg_patient_ida pat FROM reg_patient_reg_encounter_c GROUP BY reg_patient_reg_encounterreg_patient_ida) tab2, reg_encounter_cstm tab3, reg_patient tab4, reg_patient_cstm tab5 WHERE tab1.date_modified = tab2.dat AND tab1.reg_patient_reg_encounterreg_patient_ida = tab2.pat AND tab3.id_c = tab1.reg_patient_reg_encounterreg_encounter_idb AND tab4.id = tab2.pat AND tab5.id_c = tab4.id UNION SELECT tab4a.first_name fname, tab4a.last_name lname, null datemod, null refill, tab4a.id patid, tab5a.mrn_c mrn FROM reg_patient tab4a , reg_patient_cstm tab5a where tab4a.id not in (select reg_patient_reg_encounterreg_patient_ida pat FROM reg_patient_reg_encounter_c )and tab4a.id = tab5a.id_c ORDER BY refill DESC'; if ($_POST['mysort'] == 'week') { $myquery = 'SELECT tab4.first_name fname, tab4.last_name lname, tab1.date_modified, tab3.next_rx_refill_due_c refill, tab2.pat patid, tab5.mrn_c mrn FROM reg_patient_reg_encounter_c tab1, ( SELECT max( date_modified ) dat, reg_patient_reg_encounterreg_patient_ida pat FROM reg_patient_reg_encounter_c GROUP BY reg_patient_reg_encounterreg_patient_ida) tab2, reg_encounter_cstm tab3, reg_patient tab4, reg_patient_cstm tab5 WHERE tab1.date_modified = tab2.dat AND tab1.reg_patient_reg_encounterreg_patient_ida = tab2.pat AND tab3.id_c = tab1.reg_patient_reg_encounterreg_encounter_idb AND tab4.id = tab2.pat AND tab5.id_c = tab4.id AND tab3.next_rx_refill_due_c BETWEEN NOW() AND DATE_ADD(NOW(), INTERVAL 7 DAY) '; } $result = $db->query($myquery); while ($row = $db->fetchRow($result)) { $mydata[] = $row; } $smarty->assign("mydata", $mydata); $db1 = DBManagerFactory::getInstance(); $provquery = 'SELECT p1b.name provname from reg_provider p1b'; $resultprov = $db1->query($provquery); while ($provrow = $db1->fetchRow($resultprov)) { $provdata[] = $provrow; } $smarty->assign("provdata", $provdata); $smarty->display($this->lv->tpl); }
function display() { $db = DBManagerFactory::getInstance(); $sql = "SELECT * FROM (SELECT p.id, p.first_name, p.last_name, p.dob, rec.mrn_c AS mrn, (SELECT p1b.name provname FROM reg_provider p1b,reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = p.id AND p2b.deleted =0)provname, (SELECT e.narcotic_contract_in_chart_c FROM reg_patient_reg_encounter_c pe, reg_encounter_cstm e WHERE pe.reg_patient_reg_encounterreg_encounter_idb = e.id_c AND pe.date_modified = (SELECT max( date_modified ) dat FROM reg_patient_reg_encounter_c enc1 WHERE enc1.reg_patient_reg_encounterreg_patient_ida = p.id ))narc FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c = p.id ORDER BY provname, p.last_name, p.first_name)rep WHERE NARC <> '1' || NARC IS NULL"; $resultb = $db->query($sql, true); $final = array(); while ($row = $db->fetchByAssoc($resultb)) { $final[] = $row; } $db = DBManagerFactory::getInstance(); $sql1 = "SELECT * FROM (SELECT p.id, (SELECT p1b.name provname FROM reg_provider p1b,reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = p.id AND p2b.deleted =0)provname FROM reg_patient p LEFT JOIN reg_patient_cstm rec ON rec.id_c = p.id ORDER BY provname, p.last_name, p.first_name)rep GROUP BY provname"; $resultb1 = $db->query($sql1, true); $provname = array(); while ($row1 = $db->fetchByAssoc($resultb1)) { $provname[] = $row1; } $sugarSmarty = new Sugar_Smarty(); $sugarSmarty->assign("data", $final); $sugarSmarty->assign("data1", $provname); $sugarSmarty->assign("title", "Patients who do not have TX Contracts"); $sugarSmarty->display('custom/modules/REG_Patient/tpls/Report3REG_Patient.tpl'); // parent::display(); }
function display() { $db = DBManagerFactory::getInstance(); if (isset($_POST['duration']) && $_POST['duration'] != "") { $duration = $_POST['duration']; } else { $duration = 1; } if ($duration == 1) { $where_duration = " AND test_date= SUBDATE(CURDATE(),1)"; } else { if ($duration == 2) { $where_duration = " AND test_date between (CURRENT_DATE() - INTERVAL 1 WEEK) AND CURRENT_DATE() "; } else { if ($duration == 3) { $where_duration = " AND test_date between (CURRENT_DATE() - INTERVAL 1 MONTH) AND CURRENT_DATE() "; } else { if ($duration == 4) { $where_duration = " "; } } } } $sql = "SELECT DISTINCT DATE_FORMAT(test_date,'%m/%d/%Y') thisdate1, test_date thisdate, patient_mrn pmrn,p.id patid, ( SELECT DISTINCT test_results_code FROM reg_patient_uts_import WHERE patient_mrn = pmrn AND test_date = thisdate AND test_type = 'OXYCODONE' AND test_results_code <> 'PEN' limit 1) oxy,( SELECT DISTINCT test_results_code FROM reg_patient_uts_import WHERE patient_mrn = pmrn AND test_date = thisdate AND test_type = 'OPIATE URINE' AND test_results_code <> 'PEN' limit 1) opiate,( SELECT DISTINCT test_results_code FROM reg_patient_uts_import WHERE patient_mrn = pmrn AND test_date = thisdate AND test_type = 'METHADONE' AND test_results_code <> 'PEN' limit 1) methadone,( SELECT DISTINCT test_results_code FROM reg_patient_uts_import WHERE patient_mrn = pmrn AND test_date = thisdate AND test_type = 'COCAIN METAB' AND test_results_code <> 'PEN' limit 1) cocaine,( SELECT DISTINCT test_results_code FROM reg_patient_uts_import WHERE patient_mrn = pmrn AND test_date = thisdate AND test_type = 'BUPRENO UR' AND test_results_code <> 'PEN' limit 1) bupreno,( SELECT DISTINCT test_results_code FROM reg_patient_uts_import WHERE patient_mrn = pmrn AND test_date = thisdate AND test_type = 'BENZODIAZ UR' AND test_results_code <> 'PEN' limit 1) benzo,( SELECT DISTINCT test_results_code FROM reg_patient_uts_import WHERE patient_mrn = pmrn AND test_date = thisdate AND test_type = 'BARBITURA UR' AND test_results_code <> 'PEN' limit 1) barbi,( SELECT DISTINCT test_results_code FROM reg_patient_uts_import WHERE patient_mrn = pmrn AND test_date = thisdate AND test_type = 'AMPHETAMI UR' AND test_results_code <> 'PEN' limit 1) amph, (SELECT p1b.name provname from reg_provider p1b, reg_provider_reg_patient_c p2b WHERE p2b.reg_provider_reg_patientreg_provider_ida = p1b.id AND p2b.reg_provider_reg_patientreg_patient_idb = patid) provname, last_name,first_name FROM reg_patient_uts_import uts, reg_patient p, reg_patient_cstm pc WHERE p.id=pc.id_c AND pc.mrn_c=uts.patient_mrn {$where_duration} ORDER BY test_date DESC"; $resultb = $db->query($sql, true); $final = array(); while ($row = $db->fetchByAssoc($resultb)) { $final[] = $row; } $sugarSmarty = new Sugar_Smarty(); $sugarSmarty->assign("duration", $duration); $sugarSmarty->assign("mydata", $final); $sugarSmarty->assign("title", "UTS Report"); $sugarSmarty->display('custom/modules/REG_Patient/tpls/ReportutsREG_Patient.tpl'); // parent::display(); }
function display() { $provid = '0'; $provname = ""; //var_dump($_GET); if (isset($_GET['provid']) && !empty($_GET['provid'])) { $provid = $_GET['provid']; } $datalist = array(); $smarty = new Sugar_Smarty(); //parent::display(); $db = DBManagerFactory::getInstance(); $queryprov = "select prov.name provname, p1.last_name lname, p1.first_name, p1c.mrn_c, p1.phone_home, r.finalscore, r.ortsum ortsum, r.short_opioid, prov.name, r.medd, r.short_opioid sop, r.long_opioid lop \n\t\tFROM reg_provider prov, reg_provider_reg_patient_c provpat, \n\t\treg_patient p1, reg_patient_cstm p1c, reg_patient_risk r\n\t\tWHERE prov.id = '{$provid}' AND\n\t\tprov.id = provpat.reg_provider_reg_patientreg_provider_ida AND\n\t\tp1.id = provpat.reg_provider_reg_patientreg_patient_idb AND\n\t\tp1.id = p1c.id_c AND p1c.active_c = '1' AND\n\t\tp1.id = r.pid AND r.medd in ('0-3', '4-7', 'gt7')\n\t\tORDER BY r.medd, p1.last_name, p1.first_name"; $sql = $db->query($queryprov); while (($a = $db->fetchByAssoc($sql)) != null) { $provname = $a["provname"]; $datalist[] = array("lname" => $a["lname"], "fname" => $a["first_name"], "mrn" => $a["mrn_c"], "phone" => $a["phone_home"], "ncm" => $a["finalscore"], "medd" => $a["medd"], "ortsum" => $a["ortsum"], "lop" => $a["lop"], "sop" => $a["sop"]); } //echo "here with provid " . $provid; //echo "<p>".$queryprov."</p>"; $smarty->assign("datalist", $datalist); $smarty->assign("provname", $provname); $smarty->display('custom/modules/REG_Patient/tpls/ReportMedd.tpl'); }
$res = $db->query($query); while ($row = $db->fetchByAssoc($res)) { $values[$row['name']] = $row['aclaccess']; $ids[$row['name']] = $row['id']; } $i = 0; $acl_fields = array(); foreach ($focus->field_name_map as $field) { $lbl = $field['vname']; if (!empty($lbl) && !ereg("subpanel", $field['name'])) { $acl_fields[$i]['field'] = $field['name']; $acl_fields[$i]['label'] = translate($lbl, $category); $acl_fields[$i]['inputname'] = 'new_' . $field['name']; $acl_fields[$i]['prevname'] = 'prev_' . $field['name']; $acl_fields[$i]['idname'] = 'id_' . $field['name']; $acl_fields[$i]['value'] = $values[$field['name']]; $acl_fields[$i]['id'] = $ids[$field['name']]; } $i++; } } $smarty->assign('roles_list', $app_list_strings['roles_list']); $smarty->assign('moduleList', $app_list_strings['moduleList']); $smarty->assign('role', $_REQUEST['role']); $smarty->assign('roleName', $app_list_strings['roles_list'][$_REQUEST['role']]); $smarty->assign('category', $_REQUEST['category']); $smarty->assign('moduleName', $app_list_strings['moduleList'][$_REQUEST['category']]); $smarty->assign('fields_access_list', $app_list_strings['fields_access_list']); $smarty->assign('acl_fields', $acl_fields); $smarty->display("modules/acl_fields/templates/EditAclFields.tpl.html");
if (!array_key_exists('aod', $cfg->config)) { $cfg->config['aod'] = array('enable_aod' => ''); } if (isset($_REQUEST['do']) && $_REQUEST['do'] == 'save') { $cfg->config['aod']['enable_aod'] = !empty($_REQUEST['enable_aod']); $cfg->saveConfig(); header('Location: index.php?module=Administration&action=index'); exit; } $sugar_smarty->assign('MOD', $mod_strings); $sugar_smarty->assign('APP', $app_strings); $sugar_smarty->assign('APP_LIST', $app_list_strings); $sugar_smarty->assign('LANGUAGES', get_languages()); $sugar_smarty->assign("JAVASCRIPT", get_set_focus_js()); $sugar_smarty->assign('config', $cfg->config['aod']); $sugar_smarty->assign('error', $errors); $buttons = <<<EOQ <input title="{$app_strings['LBL_SAVE_BUTTON_TITLE']}" accessKey="{$app_strings['LBL_SAVE_BUTTON_KEY']}" class="button primary" type="submit" name="save" onclick="return check_form('ConfigureSettings');" value=" {$app_strings['LBL_SAVE_BUTTON_LABEL']} " > <input title="{$mod_strings['LBL_CANCEL_BUTTON_TITLE']}" onclick="document.location.href='index.php?module=Administration&action=index'" class="button" type="button" name="cancel" value=" {$app_strings['LBL_CANCEL_BUTTON_LABEL']} " > EOQ; $sugar_smarty->assign("BUTTONS", $buttons); $sugar_smarty->display('custom/modules/Administration/AODAdmin.tpl'); $javascript = new javascript(); $javascript->setFormName('ConfigureSettings'); echo $javascript->getScript();
$sugar_smarty->assign("MANUALFIXFILES", implode("\n", $rlf->manualFixFiles)); $sugar_smarty->assign("MODIFIEDFILES", implode("\n", $rlf->modifiedFiles)); $sugar_smarty->assign("INDEXCHANGES", implode("\n", $rlf->indexChanges)); $sugar_smarty->assign("REMOVEDFILES", implode("\n", $rlf->removedFiles)); $sugar_smarty->assign("REMOVEDMODULES", implode("\n", $rlf->removedModules)); $sugar_smarty->display("custom/modules/Administration/fixLanguageFilesResult.tpl"); unlink("custom/fixLanguageFiles_Progress.php"); } else { $title = getClassicModuleTitle("Administration", array("<a href='index.php?module=Administration&action=index'>{$mod_strings['LBL_MODULE_NAME']}</a>", translate('LBL_FIXLANGUAGEFILES')), false); global $currentModule; $GLOBALS['log']->info("Administration: fixLanguageFiles"); $sugar_smarty = new Sugar_Smarty(); $sugar_smarty->assign("MOD", $mod_strings); $sugar_smarty->assign("APP", $app_strings); $sugar_smarty->assign("TITLE", $title); $sugar_smarty->display("custom/modules/Administration/fixLanguageFiles.tpl"); } class fixLanguageFiles { const TYPE_EMPTY = 0; const TYPE_DYNAMIC = 1; const TYPE_STATIC = 2; const TYPE_UNREADABLE = 3; const TYPE_UNWRITABLE = 4; const TYPE_SYNTAXERROR = 5; const SEV_HIGH = 2; const SEV_MEDIUM = 1; const SEV_LOW = 0; public $customLanguageFileList = array(); public $customOtherFileList = array(); public $customListNames = array();
$buttons = array(); $buttons[] = array('text' => $GLOBALS['mod_strings']['LBL_BTN_SAVEPUBLISH'], 'actionScript' => "onclick='studiotabs.generateForm(\"edittabs\");document.edittabs.submit()'"); $html = ""; foreach ($buttons as $button) { $html .= "<td><input type='button' valign='center' class='button' style='cursor:pointer' onmousedown='this.className=\"buttonOn\";return false;' onmouseup='this.className=\"button\"' onmouseout='this.className=\"button\"' {$button['actionScript']} value = '{$button['text']}' ></td>"; } $smarty->assign('buttons', $html); $smarty->assign('title', $title); $smarty->assign('dropdown_lang', $selected_lang); $editImage = SugarThemeRegistry::current()->getImage('edit_inline', '', null, null, '.gif', $mod_strings['LBL_EDIT']); $smarty->assign('editImage', $editImage); $deleteImage = SugarThemeRegistry::current()->getImage('delete_inline', '', null, null, '.gif', $mod_strings['LBL_MB_DELETE']); $recycleImage = SugarThemeRegistry::current()->getImage('icon_Delete', '', 48, 48, '.gif', $mod_strings['LBL_MB_DELETE']); $smarty->assign('deleteImage', $deleteImage); $smarty->assign('recycleImage', $recycleImage); //#30205 global $sugar_config; if (isset($sugar_config['other_group_tab_displayed'])) { if ($sugar_config['other_group_tab_displayed']) { $value = 'checked'; } else { $value = null; } $smarty->assign('other_group_tab_displayed', $value); } else { $smarty->assign('other_group_tab_displayed', 'checked'); } $smarty->assign('tabGroupSelected_lang', $tabGroupSelected_lang); $smarty->assign('available_languages', get_languages()); $smarty->display("modules/Studio/TabGroups/EditViewTabs.tpl");
function cleanAllBeans() { } //// END UTILITIES /////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////// //// PAGE OUTPUT if (isset($runSilent) && $runSilent == true) { // if called from Scheduler cleanAllBeans(); } else { $hide = array('Activities', 'Home', 'iFrames', 'Calendar', 'Dashboard'); sort($moduleList); $options = array(); $options[] = $app_strings['LBL_NONE']; $options['all'] = "--{$app_strings['LBL_TABGROUP_ALL']}--"; foreach ($moduleList as $module) { if (!in_array($module, $hide)) { $options[$module] = $module; } } $options = get_select_options_with_id($options, ''); $beanDropDown = "<select onchange='SUGAR.Administration.RepairXSS.refreshEstimate(this);' id='repairXssDropdown'>{$options}</select>"; echo getClassicModuleTitle('Administration', array($mod_strings['LBL_REPAIRXSS_TITLE']), false); echo "<script>var done = '{$mod_strings['LBL_DONE']}';</script>"; $smarty = new Sugar_Smarty(); $smarty->assign("mod", $mod_strings); $smarty->assign("beanDropDown", $beanDropDown); $smarty->display("modules/Administration/templates/RepairXSS.tpl"); } // end else