static function processQuery($query, $queryParams) 
    {
        $search = Util::get($queryParams, 'search', '1=1');
        $searchSql = "WHERE $search";

        $order = Util::get($queryParams, 'order', '');
        $orderSql = ! empty($order) ? "ORDER BY $order" : "";
            
        $start = (int) Util::get($queryParams, 'start', 0) + 1;
        $length = (int) Util::get($queryParams, 'length', -1);
        $end = $start + $length;
        $limitSearchSql = $searchSql . ($length > -1 ? " AND rownum < $end" : "");
        // Oracle version >= 12
        // $limit =  $length > -1 ? 
        //     "OFFSET $start ROWS FETCH NEXT $length ROWS ONLY" : ""; 

        $filterQuery = "SELECT count(*) FROM ($query) tmp $searchSql";
        $totalQuery = "SELECT count(*) FROM ($query) tmp";
        $processedQuery = "select * from (select a.*, rownum as rnum 
            from (select * from ($query) $orderSql) a $limitSearchSql ) tmp 
            where rnum >= $start";
        // echo "query=" . $processedQuery . '<br>';
        return [$processedQuery, $totalQuery, $filterQuery];
    }
static function processQuery($query, $queryParams) 
    {
        $search = Util::get($queryParams, 'search', '1=1');
        $searchSql = "WHERE $search";

        $order = Util::get($queryParams, 'order', '');
        $orderSql = ! empty($order) ? "ORDER BY $order" : "";
            
        $start = (int) Util::get($queryParams, 'start', 0) + 1;
        $length = (int) Util::get($queryParams, 'length', -1);
        $end = $start + $length;
        $limitSearchSql = $searchSql . ($length > -1 ? " AND rownum < $end" : "");
        // Oracle version >= 12
        // $limit =  $length > -1 ? 
        //     "OFFSET $start ROWS FETCH NEXT $length ROWS ONLY" : ""; 

        $filterQuery = "SELECT count(*) FROM ($query) tmp $searchSql";
        $totalQuery = "SELECT count(*) FROM ($query) tmp";
        $processedQuery = "select * from (select a.*, rownum as rnum 
            from (select * from ($query) $orderSql) a $limitSearchSql ) tmp 
            where rnum >= $start";
        // echo "query=" . $processedQuery . '<br>';
        return [$processedQuery, $totalQuery, $filterQuery];
    }
static function processQuery ( $ query , $ queryParams ) { $ search = Util :: get ( $ queryParams , 'search' , '1=1' ) ; $ searchSql = "WHERE $search" ; $ order = Util :: get ( $ queryParams , 'order' , '' ) ; $ orderSql = ! empty ( $ order ) ? "ORDER BY $order" : "" ; $ start = ( int ) Util :: get ( $ queryParams , 'start' , 0 ) + 1 ; $ length = ( int ) Util :: get ( $ queryParams , 'length' , - 1 ) ; $ end = $ start + $ length ; $ limitSearchSql = $ searchSql . ( $ length > - 1 ? " AND rownum < $end" : "" ) ; // Oracle version >= 12 // $limit =  $length > -1 ?  //     "OFFSET $start ROWS FETCH NEXT $length ROWS ONLY" : "";  $ filterQuery = "SELECT count(*) FROM ($query) tmp $searchSql" ; $ totalQuery = "SELECT count(*) FROM ($query) tmp" ; $ processedQuery = "select * from (select a.*, rownum as rnum 
            from (select * from ($query) $orderSql) a $limitSearchSql ) tmp 
            where rnum >= $start" ; // echo "query=" . $processedQuery . '<br>'; return [ $ processedQuery , $ totalQuery , $ filterQuery ] ; }
Process query to additional condition

@param string $query       The SQL query statement
@param array  $queryParams The parameters of SQL query

@return array Information of additional condition
Process query to additional condition