/** * display * */ function display() { parent::display(); global $current_user, $app_strings, $mod_strings; if (isset($this->bean->query_id) && !empty($this->bean->query_id)) { //CHECK FOR SUB-QUERIES $this->bean->check_interlock(); //OUTPUT THE DATASET $data_set = BeanFactory::getBean('CustomQueries', $this->bean->query_id); $QueryView = new ReportListView(); $QueryView->initNewXTemplate('modules/CustomQueries/QueryView.html', $mod_strings); $QueryView->setHeaderTitle($this->bean->name); //below: make sure to aquire the custom layout headers if available $QueryView->export_type = "Ent"; $QueryView->xTemplateAssign('EDIT_INLINE', SugarThemeRegistry::current()->getImage('edit_inline', 'align="absmiddle" border="0"', null, null, '.gif', $app_strings['LNK_EDIT'])); $QueryView->xTemplateAssign('LEFTARROW_INLINE', SugarThemeRegistry::current()->getImage('calendar_previous', 'align="absmiddle" border="0"', null, null, '.gif', $mod_strings['LBL_LEFT'])); $QueryView->xTemplateAssign('RIGHTARROW_INLINE', SugarThemeRegistry::current()->getImage('calendar_next', 'align="absmiddle" border="0"', null, null, '.gif', $mod_strings['LBL_RIGHT'])); $QueryView->setup($data_set, $this->bean, "main", "CUSTOMQUERY"); $query_results = $QueryView->processDataSet(); if ($query_results['result'] == "Error") { if (is_admin($current_user)) { echo "<font color=\"red\"><b>" . $query_results['result_msg'] . "" . $app_strings['ERROR_EXAMINE_MSG'] . "</font><BR>" . $query_results['msg'] . "</b>"; } else { echo "<font color=\"red\"><b>" . $query_results['result_msg'] . "</font></b><BR>"; } } //end if there is even a query for the data set } else { echo "<font color=\"red\"><b>" . $app_strings['NO_QUERY_SELECTED'] . "</font></b><BR>"; } }
public function set($list, $sort = null) { return parent::set($list, $sort); }
function process_interlock($list_array) { global $mod_strings; $sub_data_set = BeanFactory::getBean('DataSets', $this->sub_id); $sub_data_set->sub_query = true; //OUTPUT THE SUB-DATASET $data_set = BeanFactory::getBean('CustomQueries', $sub_data_set->query_id); $data_set->sub_query_array = $list_array; $SubView = new ReportListView(); $SubView->initNewXTemplate('modules/CustomQueries/QueryView.html', $mod_strings); $SubView->setDisplayHeaderAndFooter(false); $SubView->setup($data_set, $sub_data_set, "main", "CUSTOMQUERY", true); return $SubView->processDataSet(); //end function process_interlock }
echo "<tr><td>"; $header_xtpl->parse("main"); $header_xtpl->out("main"); echo "</td></tr>"; foreach ($data_set_list as $item => $data_object) { echo "<tr><td align=\"{$focus->report_align}\"> \n"; if ($data_object->prespace_y == "on") { echo "<p><p>"; } //CHECK FOR SUB-QUERIES $data_object->check_interlock(); //first check to see if the data format actually has a query_id for it if (!empty($data_object->query_id) && $data_object->query_id != "") { //OUTPUT THE DATASET $data_set = BeanFactory::getBean('CustomQueries', $data_object->query_id); $QueryView = new ReportListView(); //pass the previous width array if available if (isset($prev_width_array) && $prev_width_array != '') { $QueryView->prev_width_array = $prev_width_array; } $QueryView->initNewXTemplate('modules/CustomQueries/QueryView.html', $mod_strings); $QueryView->setDisplayHeaderAndFooter(false); $QueryView->setHeaderTitle($data_object->name); //below: make sure to aquire the custom layout headers if available $QueryView->export_type = "Ent"; $QueryView->final_report_view = true; $QueryView->setup($data_set, $data_object, "main", "CUSTOMQUERY"); $query_results = $QueryView->processDataSet(); //capture previous width array if necessary $prev_width_array = $QueryView->prev_width_array; if ($query_results['result'] == "Error") {
$ListView = new ListView(); $ListView->initNewXTemplate('modules/CustomQueries/ListView.html', $mod_strings); $ListView->xTemplateAssign("DELETE_INLINE_PNG", SugarThemeRegistry::current()->getImage('delete_inline', 'align="absmiddle" border="0"', null, null, '.gif', $app_strings['LNK_DELETE'])); $ListView->setHeaderTitle($mod_strings['LBL_LIST_FORM_TITLE'] . $header_text); $ListView->setHeaderText($button); //Temporary until we upgrade the export feature to multi $ListView->show_export_button = false; if (!is_admin($current_user)) { $ListView->show_select_menu = false; $ListView->show_delete_button = false; } $ListView->setQuery("", "", "name", "CUSTOMQUERY"); $ListView->processListView($focus, "main", "CUSTOMQUERY"); echo "<p>"; echo "<BR>"; $QueryView = new ReportListView(); $QueryView->initNewXTemplate('modules/CustomQueries/QueryView.html', $mod_strings); $QueryView->setHeaderTitle($mod_strings['LBL_QUERYRESULT']); $QueryView->setup($focus, "", "main", "CUSTOMQUERY"); $query_results = $QueryView->processDataSet(); if ($query_results['result'] == "Error") { echo "<font color=\"red\"><b>" . $query_results['result_msg'] . "" . $app_strings['ERROR_EXAMINE_MSG'] . "</font><BR>" . $query_results['msg'] . "</b>"; } if ($is_edit) { $edit_button = "<form name='EditView' method='POST' action='index.php'>\n"; $edit_button .= "<input type='hidden' name='module' value='CustomQueries'>\n"; $edit_button .= "<input type='hidden' name='record' value='{$focus->id}'>\n"; $edit_button .= "<input type='hidden' name='action'>\n"; $edit_button .= "<input type='hidden' name='edit'>\n"; $edit_button .= "<input type='hidden' name='isDuplicate'>\n"; $edit_button .= "<input type='hidden' name='return_module' value='CustomQueries'>\n";