function testOverrideSearchFields() { $list = new ViewList(); $list->module = "Contacts"; $list->seed = new Contact(); $list->prepareSearchForm(); $this->assertTrue(isset($list->searchForm->searchFields['test'])); }
/** * @see SugarView::_getModuleTitleParams() */ protected function _getModuleTitleParams($browserTitle = false) { global $mod_strings; $params = parent::_getModuleTitleParams($browserTitle); $params[] = $mod_strings['LBL_NEWSLETTER_TITLE']; return $params; }
function display() { if (isset($_REQUEST['close_window'])) { echo "<script>window.close();</script>"; } parent::display(); }
/** * @see ViewList::preDisplay() */ public function preDisplay() { require_once 'modules/AOS_PDF_Templates/formLetter.php'; formLetter::LVPopupHtml('Accounts'); parent::preDisplay(); require_once "custom/include/metrix/loadDynamicLists.php"; //helper class to autopoluate the dropdowns require_once 'include/utils.php'; global $current_user, $app_list_strings; $list = new loadDynamicLists(); $dynamic_dd_fileds = array("pays_text_c" => array("tblname" => "ref_pays", "listname" => "pays_text_list", "field" => "nom", "tag" => "0"), "id_region_a_c" => array("tblname" => "ref_region", "listname" => "id_region_a_c_list", "field" => "nom", "tag" => "0")); foreach ($dynamic_dd_fileds as $k => $v) { unset($app_list_strings[$v['listname']]); $app_list_strings[$v['listname']] = $list->populate_list($v['tblname'], $v['field'], $v['tag']); } //echo "<pre>"; //var_dump($app_list_strings['id_region_a_c_list']); /* foreach($app_list_strings['id_region_a_c_list'] as $k=>$v){ echo "'".$k."'=>'".$v."',<br>"; }*/ //if the current user is not admin then hide the values of certain fields and make them non inline-editable if ($current_user->is_admin != 1) { echo "\n\n\t\t\t<script>\n\t\t\t\t\$('html').hide();\n\t\t\t\t\$(document).ready(\n\t\t\t\tfunction()\n\t\t\t\t{\n\n\t\t\t\tvar remove_fields = \t['coda_name_c','coda_sname_c','prive_c','id_etat_c','date_effectif_c','date_maj_c','commentaire2_c','code_hier_c','adhesion_c','sigle_c','historique','nb_etud_c','nb_ens_c','nb_cherch_c','rub_c','commentaire2_c','nb_etud_annee_obs_c','nb_ens_annee_obs_c','nb_cherch_annee_obs_c','chiffres_c'];//you can add the fields you want to hide here\n\n\n\t\t\t\t\$.each( remove_fields, function( key, value ) {\n\n\n\t\t\t\t\$('td[field= ' + value + ']').html( '' );\n\n\t\t\t\t\$('td[field=' + value + ']').removeAttr('field');\n\t\t\t\t});\n\n\t\t\t\t\$('html').show(250);\n\t\t\t\t}\n\t\t\t\t);\n\n\t\t\t</script>"; } $this->lv = new AccountsListViewSmarty(); }
/** * @see ViewList::preDisplay() */ public function preDisplay() { require_once 'modules/AOS_PDF_Templates/formLetter.php'; formLetter::LVPopupHtml('Leads'); parent::preDisplay(); $this->lv = new LeadsListViewSmarty(); }
/** * Overridden from ViewList prepareSearchForm so we can tack on some additional where clauses * */ function prepareSearchForm() { parent::prepareSearchForm(); require_once 'modules/Employees/EmployeesSearchForm.php'; $newForm = new EmployeesSearchForm($this->searchForm); $this->searchForm = $newForm; }
public function preDisplay() { require_once 'modules/AOS_PDF_Templates/formLetter.php'; formLetter::LVPopupHtml('Contacts'); parent::preDisplay(); $this->lv = new ContactsListViewSmarty(); /************************************************************/ //logic for the search dynamic dropdowns /************************************************************/ require_once "custom/include/metrix/loadDynamicLists.php"; //helper class to autopoluate the dropdowns require_once 'include/utils.php'; global $current_user, $app_list_strings; $list = new loadDynamicLists(); $dynamic_dd_fileds = array("country_c_basic" => array("tblname" => "ref_pays", "listname" => "country_list", "field" => "nom")); $list = new loadDynamicLists(); foreach ($dynamic_dd_fileds as $k => $v) { unset($app_list_strings[$v['listname']]); $app_list_strings[$v['listname']] = $list->populate_list($v['tblname'], $v['field']); } /************************************************************/ //end logic for the search dynamic dropdowns /************************************************************/ //if the current user is not admin then hide the values of certain fields and make them non inline-editable if ($current_user->is_admin != 1) { echo "\n\n\t\t\t<script>\n\t\t\t\t\$('html').hide();\n\t\t\t\t\$(document).ready(\n\t\t\t\tfunction()\n\t\t\t\t{\n\n\t\t\t\tvar remove_fields = \t['email1','phone_mobile','jjwg_maps_address_c','primary_address_postalcode','primary_address_state','primary_address_city','alt_address_city','primary_address_country','phone_work','phone_fax','description'];//you can add the fields you want to hide here\n\n\n\t\t\t\t\$.each( remove_fields, function( key, value ) {\n\n\n\t\t\t\t\$('td[field= ' + value + ']').html( '' );\n\n\t\t\t\t\$('td[field=' + value + ']').removeAttr('field');\n\t\t\t\t});\n\n\t\t\t\t\$('html').show(250);\n\t\t\t\t}\n\t\t\t\t);\n\n\t\t\t</script>"; } }
public function preDisplay() { echo '<script type="text/javascript" src="custom/include/js/jquery.js"></script>'; echo '<script type="text/javascript" src="modules/Tours/js/Sync.js"></script>'; parent::preDisplay(); $this->lv->actionsMenuExtraItems[] = $this->builMyMenuItem(); }
public function preDisplay() { parent::preDisplay(); $this->lv->actionsMenuExtraItems[] = $this->buildMyMenuItem(); // Bug: Missing "add to target list" entry in the action menu $this->lv->targetList = true; }
/** * @see SugarView::preDisplay() */ public function preDisplay() { global $mod_strings; $mod_strings['LBL_MODULE_TITLE'] = $mod_strings['LBL_NEWSLETTER_TITLE']; $mod_strings['LBL_LIST_FORM_TITLE'] = $mod_strings['LBL_NEWSLETTER_LIST_FORM_TITLE']; parent::preDisplay(); }
public function preDisplay() { //bug #46690: Developer Access to Users/Teams/Roles if (!$GLOBALS['current_user']->isAdminForModule('Users') && !$GLOBALS['current_user']->isDeveloperForModule('Users')) { sugar_die("Unauthorized access to administration."); } parent::preDisplay(); }
public function preDisplay() { parent::preDisplay(); $this->lv->quickViewLinks = false; $this->lv->export = false; $this->lv->mergeduplicates = 0; $this->lv->showMassupdateFields = false; }
/** * @see SugarView::process() */ public function process() { $this->options['show_all'] = false; $this->options['show_javascript'] = true; $this->options['show_footer'] = false; $this->options['show_header'] = false; parent::process(); }
public function display() { global $current_user; if (!$current_user->is_admin) { sugar_die(translate("LBL_MUST_BE_ADMIN")); } parent::display(); }
function listViewPrepare() { if (empty($_REQUEST['orderBy'])) { $_REQUEST['orderBy'] = 'date_start'; $_REQUEST['sortOrder'] = 'desc'; } parent::listViewPrepare(); }
function display() { global $mod_strings; $javascript = <<<EOF <script> </script> EOF; echo $javascript; parent::display(); }
public function preDisplay() { parent::preDisplay(); $this->lv->delete = false; $this->lv->export = false; $this->lv->multiSelect = false; $this->lv->mergeduplicates = false; $this->lv->showMassupdaeFields = false; $this->lv->show_action_dropdown = false; $this->lv->show_process = false; $this->lv->quickViewLinks = false; }
/** * Gets the WorkFlow module title. This is overridden to allow the addition * of the WorkFlow sunsetting messaging for 7.6.1 * * @param boolean $show_help Used to tell the parent whether to show additional links * @return string */ public function getModuleTitle($show_help = true) { // Get the current module title with all the cruft $title = parent::getModuleTitle(false); // Get rid of the closing clearing div for now $title = str_replace("</div></div>", '</div>', $title); // Manipulate the moduleTitle class $title = str_replace("class='moduleTitle'", "class='moduleTitle workflow-sunset-title'", $title); // Add in our sunset message and add back the closing clearing div that // was removed earlier $title .= '<span class="error workflow-sunset">' . translate('LBL_WORKFLOW_SUNSET_NOTICE', $this->module) . '</span></div>'; return $title; }
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() { $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); }
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 ProjectTaskViewList() { parent::ViewList(); }
public function preDisplay() { parent::preDisplay(); $this->lv->targetList = true; }
function ActivitiesViewList() { parent::ViewList(); }
function display() { global $mod_strings, $sugar_config; $bean = BeanFactory::getBean('xeBayAccounts'); $ebay_account_options = "<select name='ebay_account_name' id='ebay_account_name' title=''>"; $resp = $bean->get_list("", "ebay_auth_token<>''", 0, -1, -1, 0, false, array('name')); if ($resp['row_count'] > 0) { $ebay_account_options = "<select name='ebay_account_name' id='ebay_account_name' title=''>"; if ($resp['row_count'] > 1) { $ebay_account_options .= "<option value='All'>All</option>"; } foreach ($resp['list'] as &$account) { $name = $account->name; $ebay_account_options .= "<option value='{$name}'>{$name}</option>"; } } $ebay_account_options .= "</select>"; $express_carrier_options = get_select_options_with_id(getExpressCarrierDropDown(), isset($sugar_config['ebay_express_carrier']) ? $sugar_config['ebay_express_carrier'] : 'default'); $shortcuts_unhandled = <<<EOF <script> var OO = {}; OO.get = YAHOO.util.Dom.get; OO.importorderDialog = false;\t OO.toggle_importorder = function (){ \tvar sd = OO.get("importorder_dialog"); \tif(!OO.importorderDialog){\t \t\tOO.importorderDialog = new YAHOO.widget.Dialog("importorder_dialog",{ \t\t\t \tfixedcenter: true, \t\t\t \tdraggable: false, \t\t\t \tvisible : false, \t\t\t \tmodal : true, \t\t\t \tclose: true \t\t}); \t\tvar listeners = new YAHOO.util.KeyListener(document, { keys : 27 }, {fn: function() { OO.importorderDialog.cancel();} } ); \t\tOO.importorderDialog.cfg.queueProperty("keylisteners", listeners); \t} \tOO.importorderDialog.cancelEvent.subscribe(function(e, a, o){ \t\tOO.get("form_importorder").reset(); \t}); \tsd.style.display = "block";\t \tOO.importorderDialog.render(); \tOO.importorderDialog.show(); } OO.printallDialog = false;\t OO.toggle_printall = function (){ \tvar sd = OO.get("printall_dialog"); \tif(!OO.printallDialog){\t \t\tOO.printallDialog = new YAHOO.widget.Dialog("printall_dialog",{ \t\t\t \tfixedcenter: true, \t\t\t \tdraggable: false, \t\t\t \tvisible : false, \t\t\t \tmodal : true, \t\t\t \tclose: true \t\t}); \t\tvar listeners = new YAHOO.util.KeyListener(document, { keys : 27 }, {fn: function() { OO.printallDialog.cancel();} } ); \t\tOO.printallDialog.cfg.queueProperty("keylisteners", listeners); \t} \tOO.printallDialog.cancelEvent.subscribe(function(e, a, o){ \t\tOO.get("form_printall").reset(); \t}); \tsd.style.display = "block";\t \tOO.printallDialog.render(); \tOO.printallDialog.show(); } OO.exportallDialog = false;\t OO.toggle_exportall = function (){ \tvar sd = OO.get("exportall_dialog"); \tif(!OO.exportallDialog){\t \t\tOO.exportallDialog = new YAHOO.widget.Dialog("exportall_dialog",{ \t\t\t \tfixedcenter: true, \t\t\t \tdraggable: false, \t\t\t \tvisible : false, \t\t\t \tmodal : true, \t\t\t \tclose: true \t\t}); \t\tvar listeners = new YAHOO.util.KeyListener(document, { keys : 27 }, {fn: function() { OO.exportallDialog.cancel();} } ); \t\tOO.exportallDialog.cfg.queueProperty("keylisteners", listeners); \t} \tOO.exportallDialog.cancelEvent.subscribe(function(e, a, o){ \t\tOO.get("form_exportall").reset(); \t}); \tsd.style.display = "block";\t \tOO.exportallDialog.render(); \tOO.exportallDialog.show(); } OO.completeallDialog = false;\t OO.toggle_completeall = function (){ \tvar sd = OO.get("completeall_dialog"); \tif(!OO.completeallDialog){\t \t\tOO.completeallDialog = new YAHOO.widget.Dialog("completeall_dialog",{ \t\t\t \tfixedcenter: true, \t\t\t \tdraggable: false, \t\t\t \tvisible : false, \t\t\t \tmodal : true, \t\t\t \tclose: true \t\t}); \t\tvar listeners = new YAHOO.util.KeyListener(document, { keys : 27 }, {fn: function() { OO.completeallDialog.cancel();} } ); \t\tOO.completeallDialog.cfg.queueProperty("keylisteners", listeners); \t} \tOO.completeallDialog.cancelEvent.subscribe(function(e, a, o){ \t\tOO.get("form_completeall").reset(); \t}); \tsd.style.display = "block";\t \tOO.completeallDialog.render(); \tOO.completeallDialog.show(); } function automessage() { var href="index.php?module=xeBayOrders&action=automessage&eturn_module=xeBayOrders&return_action=index"; window.location.href=href; } </script> <div id="importorder_dialog" style="width: 450px; display: none;"> \t<div class="hd">{$mod_strings['LBL_IMPORT_TITLE']}</div> \t<div class="bd"> \t<form name="importorder" id="form_importorder" method="POST" action="index.php?module=xeBayOrders&action=importorder"> \t\t<table class='edit view tabForm'> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top" width="55%"> \t\t\t\t\t{$mod_strings['LBL_EBAY_ACCOUNT']} \t\t\t\t</td> \t\t\t\t<td width="45%">\t \t\t\t\t\t<input type="hidden" name="ebay_account_name" value="">{$ebay_account_options} \t\t\t\t</td> \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top"> \t\t\t\t\t{$mod_strings['LBL_NUMBER_OF_DAYS']} \t\t\t\t</td> \t\t\t\t<td>\t \t\t\t\t\t<input type="hidden" name="number_of_days" value=""> \t\t\t <select name='number_of_days' id='number_of_days' title=''> \t\t\t\t <option value='1'>1</option> \t\t\t\t <option value='2' selected>2</option> \t\t\t\t <option value='3'>3</option> \t\t\t\t <option value='5'>5</option> \t\t\t\t <option value='7'>7</option> \t\t\t\t <option value='15'>15</option> \t\t\t\t <option value='30'>30</option> \t\t\t\t <option value='90'>90</option> \t\t\t </select> \t\t\t\t</td> \t\t\t</tr> \t\t</table> \t</form> \t<div style="text-align: right;"> \t\t<button id="btn-save-importorderDialog" class="button" type="button" onclick="OO.get('form_importorder').submit()">{$mod_strings['LBL_APPLY_BUTTON']}</button> \t\t<button id="btn-cancel-importorderDialog" class="button" type="button" onclick="OO.importorderDialog.cancel()">{$mod_strings['LBL_CANCEL_BUTTON']}</button> \t</div> \t</div> </div> <div id="printall_dialog" style="width: 450px; display: none;"> \t<div class="hd">{$mod_strings['LBL_PRINTALL_TITLE']}</div> \t<div class="bd"> \t<form name="printall" id="form_printall" method="POST" action="index.php?module=xeBayOrders&action=printall"> \t\t<table class='edit view tabForm'> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top" width="55%"> \t\t\t\t\t{$mod_strings['LBL_STOCKOUT_CHECKED']} \t\t\t\t</td> \t\t\t\t<td width="45%">\t \t\t\t\t\t<input type="hidden" name="stockout_checked" value=""> \t\t\t\t\t<input type="checkbox" id="stockout_checked" name="stockout_checked" checked value="1" tabindex=""> \t\t\t\t</td> \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top"> \t\t\t\t\t{$mod_strings['LBL_AUTO_MERGE']} \t\t\t\t</td> \t\t\t\t<td>\t \t\t\t\t\t<input type="hidden" name="automerge" value=""> \t\t\t\t\t<input type="checkbox" id="automerge" name="automerge" checked value="1" tabindex=""> \t\t\t\t</td> \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top"> \t\t\t\t\t{$mod_strings['LBL_PRINTED_ORDER_INCLUDED']} \t\t\t\t</td> \t\t\t\t<td>\t \t\t\t\t\t<input type="hidden" name="printed_order_included" value=""> \t\t\t\t\t<input type="checkbox" id="printed_order_included" name="printed_order_included" value="1" tabindex=""> \t\t\t\t</td> \t\t\t</tr> \t\t</table> \t</form> \t<div style="text-align: right;"> \t\t<button id="btn-save-printallDialog" class="button" type="button" onclick="OO.get('form_printall').submit()">{$mod_strings['LBL_APPLY_BUTTON']}</button> \t\t<button id="btn-cancel-printallDialog" class="button" type="button" onclick="OO.printallDialog.cancel()">{$mod_strings['LBL_CANCEL_BUTTON']}</button> \t</div> \t</div> </div> <div id="exportall_dialog" style="width: 450px; display: none;"> \t<div class="hd">{$mod_strings['LBL_EXPORTALL_TITLE']}</div> \t<div class="bd"> \t<form name="exportall" id="form_exportall" method="POST" action="index.php?module=xeBayOrders&action=exportall"> \t\t<table class='edit view tabForm'> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top" width="55%"> \t\t\t\t\t{$mod_strings['LBL_STOCKOUT_CHECKED']} \t\t\t\t</td> \t\t\t\t<td width="45%">\t \t\t\t\t\t<input type="hidden" name="stockout_checked" value=""> \t\t\t\t\t<input type="checkbox" id="stockout_checked" name="stockout_checked" checked value="1" tabindex=""> \t\t\t\t</td> \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top"> \t\t\t\t\t{$mod_strings['LBL_AUTO_MERGE']} \t\t\t\t</td> \t\t\t\t<td>\t \t\t\t\t\t<input type="hidden" name="automerge" value=""> \t\t\t\t\t<input type="checkbox" id="automerge" name="automerge" checked value="1" tabindex=""> \t\t\t\t</td> \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top"> \t\t\t\t\t{$mod_strings['LBL_PRINTED_ORDER_INCLUDED']} \t\t\t\t</td> \t\t\t\t<td>\t \t\t\t\t\t<input type="hidden" name="printed_order_included" value=""> \t\t\t\t\t<input type="checkbox" id="printed_order_included" name="printed_order_included" checked value="1" tabindex=""> \t\t\t\t</td> \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top"> \t\t\t\t\t{$mod_strings['LBL_EXPRESS_CARRIER']} \t\t\t\t</td> \t\t\t\t<td>\t \t\t\t\t\t<input type='hidden' name='express_carrier' value='0'> \t\t\t\t\t<select name='express_carrier'>{$express_carrier_options}</select> \t\t\t\t</td> \t\t\t</tr> \t\t</table> \t</form> \t<div style="text-align: right;"> \t\t<button id="btn-save-exportallDialog" class="button" type="button" onclick="OO.get('form_exportall').submit()">{$mod_strings['LBL_APPLY_BUTTON']}</button> \t\t<button id="btn-cancel-exportallDialog" class="button" type="button" onclick="OO.exportallDialog.cancel()">{$mod_strings['LBL_CANCEL_BUTTON']}</button> \t</div> \t</div> </div> <div id="completeall_dialog" style="width: 450px; display: none;"> \t<div class="hd">{$mod_strings['LBL_COMPLETEALL_TITLE']}</div> \t<div class="bd"> \t<form name="completeall" id="form_completeall" method="POST" action="index.php?module=xeBayOrders&action=completeall"> \t\t<table class='edit view tabForm'> \t\t\t\t<tr> \t\t\t\t\t<td scope="row" valign="top" width="55%"> \t\t\t\t\t\t{$mod_strings['LBL_UNPRINTED_ORDER_INCLUDED']} \t\t\t\t\t</td> \t\t\t\t\t<td width="45%">\t \t\t\t\t\t\t<input type="hidden" name="unprinted_order_included" value=""> \t\t\t\t\t\t<input type="checkbox" id="unprinted_order_included" name="unprinted_order_included" checked value="1" tabindex=""> \t\t\t\t\t</td> \t\t\t\t</tr> \t\t</table> \t</form> \t<div style="text-align: right;"> \t\t<button id="btn-save-completeallDialog" class="button" type="button" onclick="OO.get('form_completeall').submit()">{$mod_strings['LBL_APPLY_BUTTON']}</button> \t\t<button id="btn-cancel-completeallDialog" class="button" type="button" onclick="OO.completeallDialog.cancel()">{$mod_strings['LBL_CANCEL_BUTTON']}</button> \t</div> \t</div> </div> <input title="{$mod_strings['LBL_IMPORT_TIPS']}" class="button" type="submit" name="button" value="{$mod_strings['LBL_IMPORT']}" id="import_order" onclick="OO.toggle_importorder()"> <input title="{$mod_strings['LBL_PRINT_TIPS']}" class="button" type="submit" name="button" value="{$mod_strings['LBL_PRINT_ALL']}" id="print_all" onclick="OO.toggle_printall()"> <input title="{$mod_strings['LBL_EXPORT_TIPS']}" class="button" type="submit" name="button" value="{$mod_strings['LBL_EXPORT_ALL']}" id="export_all" onclick="OO.toggle_exportall()"> <input title="{$mod_strings['LBL_COMPLERE_ALL_TIPS']}" class="button" type="submit" name="button" value="{$mod_strings['LBL_COMPLERE_ALL']}" id="complete_all" onclick="OO.toggle_completeall()"> <input title="{$mod_strings['LBL_AUTO_MESSAGE_TIPS']}" class="button" type="submit" name="button" value="{$mod_strings['LBL_AUTO_MESSAGE']}" id="auto_message" onclick="return automessage()"> <br/> <br/> EOF; $result = $GLOBALS['db']->query("SELECT count(*) c FROM xeBayOrders WHERE handled_status = 'unhandled' AND deleted = 0"); $assoc = $GLOBALS['db']->fetchByAssoc($result); $lbl_list_unhandled = $mod_strings['LNK_LIST_UNHANDLED'] . '(<span style="color:red">' . $assoc['c'] . '</span>)'; $result = $GLOBALS['db']->query("SELECT count(*) c FROM xeBayOrders WHERE handled_status = 'handled' AND deleted = 0"); $assoc = $GLOBALS['db']->fetchByAssoc($result); $lbl_list_handled = $mod_strings['LNK_LIST_HANDLED'] . '(<span style="color:red">' . $assoc['c'] . '</span>)'; $result = $GLOBALS['db']->query("SELECT count(*) c FROM xeBayOrders WHERE handled_status = 'suspended' AND deleted = 0"); $assoc = $GLOBALS['db']->fetchByAssoc($result); $lbl_list_suspended = $mod_strings['LNK_LIST_SUSPENDED'] . '(<span style="color:red">' . $assoc['c'] . '</span>)'; $result = $GLOBALS['db']->query("SELECT count(*) c FROM xeBayOrders WHERE handled_status = 'deleted' AND deleted = 0"); $assoc = $GLOBALS['db']->fetchByAssoc($result); $lbl_list_deleted = $mod_strings['LNK_LIST_DELETED'] . '(<span style="color:red">' . $assoc['c'] . '</span>)'; switch ($_REQUEST['handled_status_advanced'][0]) { case 'handled': $lbl_list_handled = "<b>{$lbl_list_handled}</b>"; break; case 'suspended': $lbl_list_suspended = "<b>{$lbl_list_suspended}</b>"; break; case 'deleted': $lbl_list_deleted = "<b>{$lbl_list_deleted}</b>"; break; case 'unhandled': $lbl_list_unhandled = "<b>{$lbl_list_unhandled}</b>"; break; default: break; } if (isset($this->options['show_title']) && $this->options['show_title']) { echo $shortcuts_unhandled; echo "{$lbl_list_unhandled} {$lbl_list_handled} {$lbl_list_suspended} {$lbl_list_deleted}<br/>"; } parent::display(); }
} $view_name = NULL; if (isset($_GET['vn']) && !is_proper_view_name($_GET['vn'])) { ?> <div class="ui-widget"> <div class="ui-state-default ui-corner-all" styledefault="padding: 0 .7em;"> <p><span class="ui-icon ui-icon-alert" style="float: left; margin-right: .3em;"></span> View names valid characters are 0-9, a-z, A-Z, -, _ and space. View has not been created.</p> </div> </div> <?php exit(0); } else { $view_name = $_GET['vn']; } $viewList = new ViewList(); $dwoo = new Dwoo($conf['dwoo_compiled_dir'], $conf['dwoo_cache_dir']); $tpl = new Dwoo_Template_File(template("view_content.tpl")); $data = new Dwoo_Data(); $size = isset($clustergraphsize) ? $clustergraphsize : 'default'; // set to 'default' to preserve old behavior if ($size == 'medium') { $size = 'default'; } $additional_host_img_css_classes = ""; if (isset($conf['zoom_support']) && $conf['zoom_support'] === true) { $additional_host_img_css_classes = "host_{$size}_zoomable"; } $data->assign("additional_host_img_css_classes", $additional_host_img_css_classes); $view_items = NULL; $view = $viewList->getView($view_name);
function process() { parent::process(); }
public function display() { parent::display(); }
function listViewPrepare() { $oldRequest = $_REQUEST; parent::listViewPrepare(); $_REQUEST = $oldRequest; }
function display() { global $mod_strings, $sugar_config; $bean = BeanFactory::getBean('xeBayAccounts'); $ebay_account_options = "<select name='ebay_account_name' id='ebay_account_name' title=''>"; $resp = $bean->get_list("", "ebay_auth_token<>''", 0, -1, -1, 0, false, array('name')); if ($resp['row_count'] > 0) { $ebay_account_options = "<select name='ebay_account_name' id='ebay_account_name' title=''>"; if ($resp['row_count'] > 1) { $ebay_account_options .= "<option value='All'>All</option>"; } foreach ($resp['list'] as &$account) { $name = $account->name; $ebay_account_options .= "<option value='{$name}'>{$name}</option>"; } } $ebay_account_options .= "</select>"; $shortcuts = <<<EOF <script> var OO = {}; OO.get = YAHOO.util.Dom.get; OO.checkDialog = false;\t OO.toggle_check = function (){ \tvar sd = OO.get("check_dialog"); \tif(!OO.checkDialog){\t \t\tOO.checkDialog = new YAHOO.widget.Dialog("check_dialog",{ \t\t\t \tfixedcenter: true, \t\t\t \tdraggable: false, \t\t\t \tvisible : false, \t\t\t \tmodal : true, \t\t\t \tclose: true \t\t}); \t\tvar listeners = new YAHOO.util.KeyListener(document, { keys : 27 }, {fn: function() { OO.checkDialog.cancel();} } ); \t\tOO.checkDialog.cfg.queueProperty("keylisteners", listeners); \t} \tOO.checkDialog.cancelEvent.subscribe(function(e, a, o){ \t\tOO.get("form_check").reset(); \t}); \tsd.style.display = "block";\t \tOO.checkDialog.render(); \tOO.checkDialog.show(); } </script> <div id="check_dialog" style="width: 450px; display: none;"> \t<div class="hd">{$mod_strings['LBL_CHECK_TITLE']}</div> \t<div class="bd"> \t<form name="check" id="form_check" method="POST" action="index.php?module=xeBayMessages&action=check"> \t\t<table class='edit view tabForm'> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top" width="55%"> \t\t\t\t\t{$mod_strings['LBL_EBAY_ACCOUNT']} \t\t\t\t</td> \t\t\t\t<td width="45%">\t \t\t\t\t\t<input type="hidden" name="ebay_account_name" value="">{$ebay_account_options} \t\t\t\t</td> \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top"> \t\t\t\t\t{$mod_strings['LBL_NUMBER_OF_DAYS']} \t\t\t\t</td> \t\t\t\t<td>\t \t\t\t\t\t<input type="hidden" name="number_of_days" value=""> \t\t\t <select name='number_of_days' id='number_of_days' title=''> \t\t\t\t <option value='1'>1</option> \t\t\t\t <option value='2' selected>2</option> \t\t\t\t <option value='3'>3</option> \t\t\t\t <option value='5'>5</option> \t\t\t\t <option value='7'>7</option> \t\t\t\t <option value='15'>15</option> \t\t\t\t <option value='30'>30</option> \t\t\t\t <option value='90'>90</option> \t\t\t </select> \t\t\t\t</td> \t\t\t</tr> \t\t\t<tr> \t\t\t\t<td scope="row" valign="top"> \t\t\t\t\t{$mod_strings['LBL_MESSAGE_STATUS']} \t\t\t\t</td> \t\t\t\t<td>\t \t\t\t\t\t<input type="hidden" name="message_status" value=""> \t\t\t <select name='message_status' id='message_status' title=''> \t\t\t\t <option value=''></option> \t\t\t\t <option value='Unanswered' selected>{$mod_strings['LBL_UNANSWERED']}</option> \t\t\t\t <option value='Answered'>{$mod_strings['LBL_ANSWERED']}</option> \t\t\t </select> \t\t\t\t</td> \t\t\t</tr> \t\t</table> \t</form> \t<div style="text-align: right;"> \t\t<button id="btn-save-checkDialog" class="button" type="button" onclick="OO.get('form_check').submit()">{$mod_strings['LBL_APPLY_BUTTON']}</button> \t\t<button id="btn-cancel-checkDialog" class="button" type="button" onclick="OO.checkDialog.cancel()">{$mod_strings['LBL_CANCEL_BUTTON']}</button> \t</div> \t</div> </div> <input title="{$mod_strings['LBL_CHECK_TIPS']}" class="button" type="submit" name="button" value="{$mod_strings['LBL_CHECK']}" id="check_btn" onclick="OO.toggle_check()"> <br/> <br/> EOF; echo $shortcuts; parent::display(); }