src/LogQuery.php
protected function build_sql() {

		$builder = new Builder();

		$select = $this->parse_select();
		$from   = new From( $this->table->get_table_name( $GLOBALS['wpdb'] ), 'q' );

		$where = new Where( 1, true, 1 );

		if ( ( $message = $this->parse_message() ) !== null ) {
			$where->qAnd( $message );
		}

		if ( ( $level = $this->parse_level() ) !== null ) {
			$where->qAnd( $level );
		}

		if ( ( $user = $this->parse_user() ) !== null ) {
			$where->qAnd( $user );
		}

		if ( ( $group = $this->parse_group() ) !== null ) {
			$where->qAnd( $group );
		}

		if ( ( $time = $this->parse_time() ) !== null ) {
			$where->qAnd( $time );
		}

		$order = $this->parse_order();
		$limit = $this->parse_pagination();

		$builder->append( $select )->append( $from );

		$builder->append( $where );
		$builder->append( $order );

		if ( $limit !== null ) {
			$builder->append( $limit );
		}

		return $builder->build();
	}
protected function build_sql() {

		$builder = new Builder();

		$select = $this->parse_select();
		$from   = new From( $this->table->get_table_name( $GLOBALS['wpdb'] ), 'q' );

		$where = new Where( 1, true, 1 );

		if ( ( $message = $this->parse_message() ) !== null ) {
			$where->qAnd( $message );
		}

		if ( ( $level = $this->parse_level() ) !== null ) {
			$where->qAnd( $level );
		}

		if ( ( $user = $this->parse_user() ) !== null ) {
			$where->qAnd( $user );
		}

		if ( ( $group = $this->parse_group() ) !== null ) {
			$where->qAnd( $group );
		}

		if ( ( $time = $this->parse_time() ) !== null ) {
			$where->qAnd( $time );
		}

		$order = $this->parse_order();
		$limit = $this->parse_pagination();

		$builder->append( $select )->append( $from );

		$builder->append( $where );
		$builder->append( $order );

		if ( $limit !== null ) {
			$builder->append( $limit );
		}

		return $builder->build();
	}
protected function build_sql ( ) { $ builder = new Builder ( ) ; $ select = $ this -> parse_select ( ) ; $ from = new From ( $ this -> table -> get_table_name ( $ GLOBALS [ 'wpdb' ] ) , 'q' ) ; $ where = new Where ( 1 , true , 1 ) ; if ( ( $ message = $ this -> parse_message ( ) ) !== null ) { $ where -> qAnd ( $ message ) ; } if ( ( $ level = $ this -> parse_level ( ) ) !== null ) { $ where -> qAnd ( $ level ) ; } if ( ( $ user = $ this -> parse_user ( ) ) !== null ) { $ where -> qAnd ( $ user ) ; } if ( ( $ group = $ this -> parse_group ( ) ) !== null ) { $ where -> qAnd ( $ group ) ; } if ( ( $ time = $ this -> parse_time ( ) ) !== null ) { $ where -> qAnd ( $ time ) ; } $ order = $ this -> parse_order ( ) ; $ limit = $ this -> parse_pagination ( ) ; $ builder -> append ( $ select ) -> append ( $ from ) ; $ builder -> append ( $ where ) ; $ builder -> append ( $ order ) ; if ( $ limit !== null ) { $ builder -> append ( $ limit ) ; } return $ builder -> build ( ) ; }
Build the sql query.

@since 1.0

@return string
Build the sql query .