예제 #1
0
 /**
  *
  * @param Database_Query_Builder_Select $query
  */
 public function apply_ordering(&$query)
 {
     $this->orderby = Arr::get($_GET, 'orderby', '');
     $this->orderdir = Arr::get($_GET, 'orderdir') == 'desc' ? 'desc' : 'asc';
     if (!in_array($this->orderby, array_keys($this->get_columns()))) {
         $this->orderby = $this->get_title_column()->get_name();
     }
     if ($this->get_column($this->orderby)->is_foreign_key()) {
         $fk1_alias = 'o1';
         $fk1_table = $this->get_column($this->orderby)->get_referenced_table();
         $query->join(array($fk1_table->get_name(), $fk1_alias), 'LEFT OUTER');
         $query->on($this->get_name() . '.' . $this->orderby, '=', "{$fk1_alias}.id");
         $orderby = $fk1_alias . '.' . $fk1_table->get_title_column()->get_name();
         if ($fk1_table->get_title_column()->is_foreign_key()) {
             $fk2_alias = 'o2';
             $fk2_table = $fk1_table->get_title_column()->get_referenced_table();
             $query->join(array($fk2_table->get_name(), $fk2_alias), 'LEFT OUTER');
             $query->on($fk1_alias . '.' . $fk1_table->get_title_column()->get_name(), '=', "{$fk2_alias}.id");
             $orderby = $fk2_alias . '.' . $fk2_table->get_title_column()->get_name();
         }
         $query->order_by($orderby, $this->orderdir);
     } else {
         $query->order_by($this->get_name() . '.' . $this->orderby, $this->orderdir);
     }
 }
예제 #2
0
파일: Select.php 프로젝트: Konro1/pms
 public function on($c1, $op, $c2)
 {
     if (!$this->_last_join) {
         throw new Kohana_Exception('You must specifiy a JOIN first!');
     }
     return parent::on($c1, $op, $c2);
 }
예제 #3
0
 /**
  * Adds "ON ..." conditions for the last created JOIN statement.
  *
  * @param   mixed   $c1 column name or array($column, $alias) or object
  * @param   string  $op logic operator
  * @param   mixed   $c2 column name or array($column, $alias) or object
  * @return Jelly_Builder
  */
 public function on($c1, $op, $c2)
 {
     return parent::on($this->_field_alias($c1), $op, $this->_field_alias($c2));
 }