public function getAllQuestionByUser($value, $what)
    {
        $result = [];

        $sqlBuilder = new module_report_sql($this->app, $this);

        $filter = $sqlBuilder->getFilters()->getReportFilter();
        $params = array_merge([':main_value' => $value], $filter['params']);

        $sql = "
            SELECT DATE_FORMAT(log_search.date,'%Y-%m-%d %H:%i:%S') AS date ,
            log_search.search ,log_search.results
            FROM (log_search)
                INNER JOIN log FORCE INDEX (date_site) ON (log.id = log_search.log_id)
                INNER JOIN log_colls FORCE INDEX (couple) ON (log.id = log_colls.log_id)
            WHERE (" . $filter['sql'] . ")
            AND log.`" . $what . "` = :main_value
            ORDER BY date ";

        $stmt = $sqlBuilder->getConnBas()->prepare($sql);
        $stmt->execute($params);
        $sqlBuilder->setTotalrows($stmt->rowCount());
        $stmt->closeCursor();

        $sql .= $sqlBuilder->getFilters()->getLimitFilter();

        $stmt = $sqlBuilder->getConnBas()->prepare($sql);
        $stmt->execute($params);
        $rs = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $stmt->closeCursor();

        $this->setChamp($rs);
        $this->initDefaultConfigColumn($this->champ);
        $i = 0;

        foreach ($rs as $row) {
            foreach ($this->champ as $value) {
                $result[$i][$value] = $row[$value];
            }
            $i++;
        }

        $this->title = $this->app->trans('report:: questions');
        $this->setResult($result);

        return $this->result;
    }
public function getAllQuestionByUser($value, $what)
    {
        $result = [];

        $sqlBuilder = new module_report_sql($this->app, $this);

        $filter = $sqlBuilder->getFilters()->getReportFilter();
        $params = array_merge([':main_value' => $value], $filter['params']);

        $sql = "
            SELECT DATE_FORMAT(log_search.date,'%Y-%m-%d %H:%i:%S') AS date ,
            log_search.search ,log_search.results
            FROM (log_search)
                INNER JOIN log FORCE INDEX (date_site) ON (log.id = log_search.log_id)
                INNER JOIN log_colls FORCE INDEX (couple) ON (log.id = log_colls.log_id)
            WHERE (" . $filter['sql'] . ")
            AND log.`" . $what . "` = :main_value
            ORDER BY date ";

        $stmt = $sqlBuilder->getConnBas()->prepare($sql);
        $stmt->execute($params);
        $sqlBuilder->setTotalrows($stmt->rowCount());
        $stmt->closeCursor();

        $sql .= $sqlBuilder->getFilters()->getLimitFilter();

        $stmt = $sqlBuilder->getConnBas()->prepare($sql);
        $stmt->execute($params);
        $rs = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $stmt->closeCursor();

        $this->setChamp($rs);
        $this->initDefaultConfigColumn($this->champ);
        $i = 0;

        foreach ($rs as $row) {
            foreach ($this->champ as $value) {
                $result[$i][$value] = $row[$value];
            }
            $i++;
        }

        $this->title = $this->app->trans('report:: questions');
        $this->setResult($result);

        return $this->result;
    }
public function getAllQuestionByUser ( $ value , $ what ) { $ result = [ ] ; $ sqlBuilder = new module_report_sql ( $ this -> app , $ this ) ; $ filter = $ sqlBuilder -> getFilters ( ) -> getReportFilter ( ) ; $ params = array_merge ( [ ':main_value' => $ value ] , $ filter [ 'params' ] ) ; $ sql = "
            SELECT DATE_FORMAT(log_search.date,'%Y-%m-%d %H:%i:%S') AS date ,
            log_search.search ,log_search.results
            FROM (log_search)
                INNER JOIN log FORCE INDEX (date_site) ON (log.id = log_search.log_id)
                INNER JOIN log_colls FORCE INDEX (couple) ON (log.id = log_colls.log_id)
            WHERE (" . $ filter [ 'sql' ] . ")
            AND log.`" . $ what . "` = :main_value
            ORDER BY date " ; $ stmt = $ sqlBuilder -> getConnBas ( ) -> prepare ( $ sql ) ; $ stmt -> execute ( $ params ) ; $ sqlBuilder -> setTotalrows ( $ stmt -> rowCount ( ) ) ; $ stmt -> closeCursor ( ) ; $ sql .= $ sqlBuilder -> getFilters ( ) -> getLimitFilter ( ) ; $ stmt = $ sqlBuilder -> getConnBas ( ) -> prepare ( $ sql ) ; $ stmt -> execute ( $ params ) ; $ rs = $ stmt -> fetchAll ( PDO :: FETCH_ASSOC ) ; $ stmt -> closeCursor ( ) ; $ this -> setChamp ( $ rs ) ; $ this -> initDefaultConfigColumn ( $ this -> champ ) ; $ i = 0 ; foreach ( $ rs as $ row ) { foreach ( $ this -> champ as $ value ) { $ result [ $ i ] [ $ value ] = $ row [ $ value ] ; } $ i ++ ; } $ this -> title = $ this -> app -> trans ( 'report:: questions' ) ; $ this -> setResult ( $ result ) ; return $ this -> result ; }
Get all questions by user

@param string $value
@param string $what
Get all questions by user