示例#1
0
 } else {
     $primary_key_value = $manageData->getParam("id" . $table);
 }
 if (!empty($table) || !empty($savedquery)) {
     $form = new ReportForm($conx);
     $form->setUrlNext(urldecode($goto));
     $form->setEventControl($cfg_eventcontroler);
     if (!empty($registryname)) {
         $form->setRegistry($registryname);
     }
     if ($primarykey != "") {
         $form->squery = new sqlQuery($conx);
         $primarykey = stripslashes($primarykey);
         $form->squery->query("select * from " . $table . " where " . $primarykey);
         $form->setLogRun(true);
         $form->setDefault($table);
     } elseif (!empty($savedquery)) {
         $form->setSavedQuery($savedquery);
         $form->setQuery();
         $form->setDefault();
     } else {
         $form->setQuery($table, $primary_key_value, $primary_key_var);
         $form->setDefault($table);
     }
     if ($addrecord == "yes") {
         $form->setAddRecord();
     }
     $form->event->addEvent("mydb.addParamToDisplayNext", 500);
     $form->event->addParam("errorpage", $_SERVER['PHP_SELF']);
     $form->setForm();
     $form->execute();
示例#2
0
$field_month->listvalues = "01:02:03:04:05:06:07:08:09:10:11:12";
$field_month->listlabels = "January:February:March:April:May:June:July:August:September:October:November:December";
$field_month->label = "Month";
$field_month->default = "[expense_view_month]";
$reg_filter->addField($field_month);
$field_year = new strFBFieldTypeListBoxSmall("expense_view_year");
$field_year->listvalues = "2003:2006:2007:2008:2009";
$field_year->listlabels = "2003:2006:2007:2008:2009";
$field_year->label = "Year";
$field_year->default = "[expense_view_month]";
$reg_filter->addField($field_year);
$f_expense_filter->setRegistry($reg_filter);
$f_expense_filter->setValue("expense_view_month", $_SESSION['expense_view_month']);
$f_expense_filter->setValue("expense_view_year", $_SESSION['expense_view_year']);
// echo $f_expense_filter->getTable();
$f_expense_filter->setDefault();
$f_expense_filter->setEvent("accounting.expenses_filter_view_set_values");
$f_expense_filter->setNoData(true);
$f_expense_filter->execute();
?>

<?php 
$do_expense = new Expense($GLOBALS['conx']);
$do_expense->setViewTemplate("search_report");
$do_expense->setSavedQuery("expenses_search_display");
$do_expense->setRegistry("expense_view");
//$do_expense->get_expenses_search_display();
// $do_expense->prepareView();
// echo $do_expense->view->getNoData();
// $do_expense->view->setMaxRows(20);
// $do_expense->view->setQuery();