public function buildReport($tab = false, $groupby = false, $on = false)
    {
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);

        if (sizeof($this->report) > 0) {
            return $this->report;
        }

        $databox = $this->app->findDataboxById($this->sbas_id);
        $conn = $databox->get_connection();

// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);

        $this->buildReq($groupby, $on);

// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\nreq=%s\n\n", __FILE__, __LINE__, $this->req), FILE_APPEND);

        try {
            try {
                $stmt = $conn->prepare($this->req);
                $stmt->execute($this->params);
                $rs = $stmt->fetchAll(PDO::FETCH_ASSOC);
                $stmt->closeCursor();
            } catch (DBALException $e) {

                return;
            }

// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s) %s\n\n", __FILE__, __LINE__, get_class($this)), FILE_APPEND);

            //set request field
            $this->setChamp($rs);
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);
            //set display
            $this->setDisplay($tab, $groupby);
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);
            //construct results
            $this->buildResult($this->app, $rs);
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);
            //calculate prev and next page
            $this->calculatePages();
            //do we display navigator ?
            $this->setDisplayNav();
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);
            //assign all variables
            $this->setReport();

// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);

            return $this->report;
        } catch (\Exception $e) {
            echo $e->getMessage();
        }
    }
public function buildReport($tab = false, $groupby = false, $on = false)
    {
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);

        if (sizeof($this->report) > 0) {
            return $this->report;
        }

        $databox = $this->app->findDataboxById($this->sbas_id);
        $conn = $databox->get_connection();

// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);

        $this->buildReq($groupby, $on);

// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\nreq=%s\n\n", __FILE__, __LINE__, $this->req), FILE_APPEND);

        try {
            try {
                $stmt = $conn->prepare($this->req);
                $stmt->execute($this->params);
                $rs = $stmt->fetchAll(PDO::FETCH_ASSOC);
                $stmt->closeCursor();
            } catch (DBALException $e) {

                return;
            }

// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s) %s\n\n", __FILE__, __LINE__, get_class($this)), FILE_APPEND);

            //set request field
            $this->setChamp($rs);
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);
            //set display
            $this->setDisplay($tab, $groupby);
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);
            //construct results
            $this->buildResult($this->app, $rs);
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);
            //calculate prev and next page
            $this->calculatePages();
            //do we display navigator ?
            $this->setDisplayNav();
// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);
            //assign all variables
            $this->setReport();

// no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND);

            return $this->report;
        } catch (\Exception $e) {
            echo $e->getMessage();
        }
    }
public function buildReport ( $ tab = false , $ groupby = false , $ on = false ) { // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND); if ( sizeof ( $ this -> report ) > 0 ) { return $ this -> report ; } $ databox = $ this -> app -> findDataboxById ( $ this -> sbas_id ) ; $ conn = $ databox -> get_connection ( ) ; // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND); $ this -> buildReq ( $ groupby , $ on ) ; // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\nreq=%s\n\n", __FILE__, __LINE__, $this->req), FILE_APPEND); try { try { $ stmt = $ conn -> prepare ( $ this -> req ) ; $ stmt -> execute ( $ this -> params ) ; $ rs = $ stmt -> fetchAll ( PDO :: FETCH_ASSOC ) ; $ stmt -> closeCursor ( ) ; } catch ( DBALException $ e ) { return ; } // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s) %s\n\n", __FILE__, __LINE__, get_class($this)), FILE_APPEND); //set request field $ this -> setChamp ( $ rs ) ; // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND); //set display $ this -> setDisplay ( $ tab , $ groupby ) ; // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND); //construct results $ this -> buildResult ( $ this -> app , $ rs ) ; // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND); //calculate prev and next page $ this -> calculatePages ( ) ; //do we display navigator ? $ this -> setDisplayNav ( ) ; // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND); //assign all variables $ this -> setReport ( ) ; // no_file_put_contents("/tmp/report.txt", sprintf("%s (%s)\n\n", __FILE__, __LINE__), FILE_APPEND); return $ this -> report ; } catch ( \ Exception $ e ) { echo $ e -> getMessage ( ) ; } }
Build the final formated array which contains all the result,
we construct the html code from this array

@param array $tab     pass the configcolumn parameter to this tab
@param array $groupby
@param array $on

@return the formated array
Build the final formated array which contains all the result we construct the html code from this array