Пример #1
0
 public function __construct($id)
 {
     $this->db = new DBService();
     $result = $this->db->query("SELECT reportName, reportDatabaseName FROM Report WHERE reportID = '{$id}' LIMIT 1")->fetchRow(MYSQLI_ASSOC);
     $this->id = $id;
     $this->name = $result['reportName'];
     $this->dbname = $result['reportDatabaseName'];
     ReportNotes::init($this->dbname);
     if (isset($_REQUEST['titleID']) && $_REQUEST['titleID'] !== null && $_REQUEST['titleID'] !== '') {
         $this->titleID = $_REQUEST['titleID'];
         FormInputs::addVisible('titleID', $this->titleID);
     }
     if (isset($_REQUEST['sortColumn'])) {
         $this->sortData['column'] = $_REQUEST['sortColumn'];
     }
     if (isset($_REQUEST['sortOrder'])) {
         $this->sortData['order'] = $_REQUEST['sortOrder'];
     }
     FormInputs::addVisible('reportID', $this->id);
     FormInputs::addHidden('useHidden', 1);
     FormInputs::addHidden('sortColumn', $this->sortData['column']);
     FormInputs::addHidden('sortOrder', $this->sortData['order']);
     Config::init();
     if (Config::$settings->baseURL) {
         if (strpos(Config::$settings->baseURL, '?') > 0) {
             $this->baseURL = Config::$settings->baseURL . '&';
         } else {
             $this->baseURL = Config::$settings->baseURL . '?';
         }
     }
 }
Пример #2
0
 public function process()
 {
     if ($this->value !== null && trim("{$this->value}") !== '') {
         $this->value = strtoupper($this->value);
         Parameter::$report->addWhere[$this->addWhereNum] .= " AND " . preg_replace('/PARM/', $this->value, $this->addWhereClause);
         FormInputs::addVisible("prm_{$this->id}", $this->value);
         Parameter::$display .= $this->description();
     }
 }
Пример #3
0
 public function process()
 {
     if ($this->value !== null) {
         Parameter::$report->addWhere[0] = '';
         // changed from $add_where. Assumed mistake.
         ReportTable::$maxRows = $this->value;
         FormInputs::addVisible("prm_{$this->id}", $this->value);
         Parameter::$display .= $this->description();
     }
 }
Пример #4
0
 public function process()
 {
     if ($this->value !== null) {
         Parameter::$report->addWhere[$this->addWhereNum] .= " AND {$this->addWhereClause}";
         Parameter::$report->applyDateRange($this->value);
         FormInputs::addVisible("prm_{$this->id}", $this->encode($this->value));
         $this->value = $this->value['m0'] . '/' . $this->value['y0'] . '-' . $this->value['m1'] . '/' . $this->value['y1'];
         Parameter::$display .= $this->description();
     }
 }
Пример #5
0
 public function process()
 {
     if ($this->value === 'on' || $this->value === 'Y') {
         FormInputs::addVisible("prm_{$this->id}", 'Y');
         Parameter::$display .= $this->description();
         if ($flag = $this->flagName()) {
             Parameter::$report->{$flag} = true;
         }
     }
 }
Пример #6
0
 public function process()
 {
     if ($this->value !== null) {
         Parameter::$report->addWhere[$this->addWhereNum] .= " AND " . preg_replace('/PARM/', $this->value, $this->addWhereClause);
         FormInputs::addVisible("prm_{$this->id}", $this->value);
         Parameter::$display .= $this->description();
     } else {
         if (!$this->requiredInd) {
             Parameter::$display .= "<b>{$this->prompt}:</b> all<br/>";
         }
     }
 }
Пример #7
0
        header("Content-Type: application/force-download");
        header("Content-Type: application/octet-stream");
        header("Content-Type: application/download");
        header("Content-Transfer-Encoding: binary");
        header("Content-type: application/vnd.ms-excel;");
        header("Content-Disposition: attachment; filename='" . strtr($report->name, ' ', '_') . "'");
        echo "<html><head></head><body>";
    }
}
/////////////////////////////////////header (end)//////////////////
echo "<center>\n    <table class='noborder' style='width: 780px;'>\n    <tr>\n    <td class='noborder' align=center colspan='2'>\n    <table class='noborder' style='text-align: left;'>";
////////////////////logo/splash and param list (start)//////////////////
echo "<tr>";
if ($outputType === 'web') {
    echo "<td class='head report-head-img-box' align=left valign='top'><a href='index.php'><img class='report-head-img' src='images/transparent.gif' alt=''/></a></td>\n            <td class='noborder report-head-info-box' align=left valign='bottom'>\n            <table class='noborder'>\n            <tr valign='bottom'>\n            <td class='head' style='padding: 5px; vertical-align: bottom;'>\n            <form name='viewreport' method='post' action='report.php", FormInputs::getVisible(), "'>", FormInputs::getHidden();
    echo "<font size='+1'>", $report->name, "</font>&nbsp;<a href=\"javascript:showPopup('report','", $report->id, "');\"\n        title='Click to show information about this report'\n        style='border: none'><img src='images/help.gif'\n        style='border: none' alt='help'/></a><br/>", Parameter::$display, "<a href=\"index.php", FormInputs::getVisible(), "\">Modify Parameters</a>&nbsp; <a href='index.php'>Create New Report</a> <br/>";
    $html = array('xls', 'print');
    for ($i = 0; $i < 2; $i++) {
        echo "<a href=\"javascript:viewReportOutput('{$html[$i]}');\"\n            style=\"border: none\"><img border='0'\n            src=\"images/", $html[$i], $i ? 'er' : '', ".gif\" alt='", $html[$i], $i ? 'er' : '', "'/></a> ";
    }
    echo "<br/></form></td>\n        <td class='head' align=right valign='top'>&nbsp;</td></tr>\n        </table></td>";
} else {
    echo "<td class='head'><font size='+1'>", $report->name, "</font><br/>", Parameter::$display, "<br/></td>";
}
echo "</tr>";
////////////////////////logo/splash and param list (end)/////////////////
///////////////////////////report tables (start)///////////////////////
$textAdd = $report->id === '1' || $report->id === '2' ? 'By Month and Resource' : '';
for ($irep = 0; $irep < 2; $irep++) {
    if ($irep === 1) {
        $textAdd = "from an Archive {$textAdd}";
Пример #8
0
                                                        &nbsp;
                                                        <a href="javascript:showPopup('report','<?php 
    echo $report->id;
    ?>
');" title='<?php 
    echo _("Click to show information about this report");
    ?>
' style='border: none'>
                                                            <img src='images/help.gif' style='border: none' alt='help'/>
                                                        </a>
                                                        <br/>
                                                        <?php 
    echo Parameter::$display;
    ?>
                                                        <a href="index.php<?php 
    echo FormInputs::getVisible();
    ?>
">
                                                            <?php 
    echo _("Modify Parameters");
    ?>
                                                        </a>
                                                        &nbsp;
                                                        <a href='index.php'>
                                                            <?php 
    echo _("Create New Report");
    ?>
                                                        </a>
                                                        <br/>
                                                        <a href="javascript:viewReportOutput('xls');" style="boarder: none">
                                                            <img boarder='0' src="images/xls.gif" alt="xls" />
Пример #9
0
 public static function addHidden($name, $val)
 {
     FormInputs::validate($name, $val);
     FormInputs::$hidden[] = "{$name}\" value=\"{$val}";
 }