Example #1
0
 /**
  *	Description...
  *
  *	@return void
  **/
 public function setBlankQuery(RM_Db_Query $query, $aliases = NULL, $reset = FALSE)
 {
     $this->_blankQuery = clone $query;
     if ($reset) {
         $this->_blankQuery->what()->reset();
     }
     $this->_aliases = is_null($aliases) ? NULL : $aliases;
 }
Example #2
0
 /**
  * Add field to search query
  *
  * @param 		RM_Db_Query			query
  * @param 		string				entity
  * @param 		string				field_name
  * @return		void
  **/
 protected function _addFieldToQuery(RM_Db_Query $query, $entity, $field_name)
 {
     $entity_fields = $this->_mapper->fields($entity);
     $query->what(M('Db')->field($entity, $entity_fields[$field_name]) . ' AS ' . $entity . '_' . $field_name);
 }
Example #3
0
 protected function _addDependenceOfBricksToQuery(RM_Db_Query $q, array $brickList)
 {
     $nameList = array();
     foreach ($brickList as $brick) {
         if (!isNull($brick)) {
             $nameList[] = $brick->getBrickSystemName();
         }
     }
     if ($nameList) {
         $q->join('v', 'LEFT JOIN ' . $this->table('dependency') . ' dep on dep.value_id=v.id and dep.brick_code in (' . sqlBinds($nameList) . ')', $nameList);
         $q->what('dep.brick_code');
         $q->where('dep.value_id is null');
     }
 }