Exemplo n.º 1
0
 /**
  * Build the sql query.
  *
  * @since 1.0
  *
  * @return string
  */
 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 (($activation = $this->parse_activation()) !== null) {
         $where->qAnd($activation);
     }
     if (($release = $this->parse_release()) !== null) {
         $where->qAnd($release);
     }
     if (($update_date = $this->parse_update_date()) !== null) {
         $where->qAnd($update_date);
     }
     $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
  */
 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 (($key = $this->parse_key()) !== null) {
         $where->qAnd($key);
     }
     if (($location = $this->parse_location()) !== null) {
         $where->qAnd($location);
     }
     if (($location_search = $this->parse_location_search()) !== null) {
         $where->qAnd($location_search);
     }
     if (($status = $this->parse_status()) !== null) {
         $where->qAnd($status);
     }
     if (($activation = $this->parse_activation()) !== null) {
         $where->qAnd($activation);
     }
     if (($deactivation = $this->parse_deactivation()) !== null) {
         $where->qAnd($deactivation);
     }
     if (($release = $this->parse_release()) !== null) {
         $where->qAnd($release);
     }
     $order = $this->parse_order();
     $limit = $this->parse_pagination();
     $builder->append($select)->append($from);
     if (($join = $this->parse_join()) !== null) {
         $builder->append($join);
     }
     $builder->append($where);
     $builder->append($order);
     if ($limit !== null) {
         $builder->append($limit);
     }
     return $builder->build();
 }
Exemplo n.º 3
0
 /**
  * Build the sql query.
  *
  * @since 1.0
  *
  * @return string
  */
 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 (($product = $this->parse_product()) !== null) {
         $where->qAnd($product);
     }
     if (($download = $this->parse_download()) !== null) {
         $where->qAnd($download);
     }
     if (($status = $this->parse_status()) !== null) {
         $where->qAnd($status);
     }
     if (($type = $this->parse_type()) !== null) {
         $where->qAnd($type);
     }
     if (($version = $this->parse_version()) !== null) {
         $where->qAnd($version);
     }
     if (($version_search = $this->parse_version_search()) !== null) {
         $where->qAnd($version_search);
     }
     if (($changelog_search = $this->parse_changelog_search()) !== null) {
         $where->qAnd($changelog_search);
     }
     if (($start_date = $this->parse_start_date()) !== null) {
         $where->qAnd($start_date);
     }
     $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();
 }
Exemplo n.º 4
0
 /**
  * Build the sql query.
  *
  * @since 1.0
  *
  * @return string
  */
 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 (($transaction = $this->parse_transaction()) !== null) {
         $where->qAnd($transaction);
     }
     if (($key_like = $this->parse_key_like()) !== null) {
         $where->qAnd($key_like);
     }
     if (($product = $this->parse_product()) !== null) {
         $where->qAnd($product);
     }
     if (($customer = $this->parse_customer()) !== null) {
         $where->qAnd($customer);
     }
     if (($max = $this->parse_max()) !== null) {
         $where->qAnd($max);
     }
     if (($status = $this->parse_status()) !== null) {
         $where->qAnd($status);
     }
     if (($expires = $this->parse_expires()) !== null) {
         $where->qAnd($expires);
     }
     $order = $this->parse_order();
     $limit = $this->parse_pagination();
     $builder->append($select)->append($from);
     $search = $this->parse_customer_search();
     if ($search !== null) {
         $builder->append($search);
     }
     $builder->append($where);
     $builder->append($order);
     if ($limit !== null) {
         $builder->append($limit);
     }
     return $builder->build();
 }