当前位置: 首页>>代码示例>>PHP>>正文


PHP fORMDatabase::createOrderByClause方法代码示例

本文整理汇总了PHP中fORMDatabase::createOrderByClause方法的典型用法代码示例。如果您正苦于以下问题:PHP fORMDatabase::createOrderByClause方法的具体用法?PHP fORMDatabase::createOrderByClause怎么用?PHP fORMDatabase::createOrderByClause使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在fORMDatabase的用法示例。


在下文中一共展示了fORMDatabase::createOrderByClause方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: prebuild

 /** 
  * Builds the related records for all records in this set in one DB query
  *  
  * @param  string $related_class  This should be the name of a related class
  * @param  string $route          This should be a column name or a join table name and is only required when there are multiple routes to a related table. If there are multiple routes and this is not specified, an fProgrammerException will be thrown.
  * @return fRecordSet  The record set object, to allow for method chaining
  */
 private function prebuild($related_class, $route = NULL)
 {
     if (!$this->records) {
         return $this;
     }
     $this->validateSingleClass('prebuild');
     // If there are no primary keys we can just exit
     if (!array_merge($this->getPrimaryKeys())) {
         return $this;
     }
     $related_table = fORM::tablize($related_class);
     $table = fORM::tablize($this->class);
     $route = fORMSchema::getRouteName($table, $related_table, $route, '*-to-many');
     $relationship = fORMSchema::getRoute($table, $related_table, $route, '*-to-many');
     $table_with_route = $route ? $table . '{' . $route . '}' : $table;
     // Build the query out
     $where_sql = $this->constructWhereClause($route);
     $order_by_sql = $this->constructOrderByClause($route);
     if ($related_order_bys = fORMRelated::getOrderBys($this->class, $related_class, $route)) {
         $order_by_sql .= ', ' . fORMDatabase::createOrderByClause($related_table, $related_order_bys);
     }
     $new_sql = 'SELECT ' . $related_table . '.*';
     // If we are going through a join table we need the related primary key for matching
     if (isset($relationship['join_table'])) {
         $new_sql .= ", " . $table_with_route . '.' . $relationship['column'];
     }
     $new_sql .= ' FROM :from_clause ';
     $new_sql .= ' WHERE ' . $where_sql;
     $new_sql .= ' :group_by_clause ';
     $new_sql .= ' ORDER BY ' . $order_by_sql;
     $new_sql = fORMDatabase::insertFromAndGroupByClauses($related_table, $new_sql);
     // Add the joining column to the group by
     if (strpos($new_sql, 'GROUP BY') !== FALSE) {
         $new_sql = str_replace(' ORDER BY', ', ' . $table . '.' . $relationship['column'] . ' ORDER BY', $new_sql);
     }
     // Run the query and inject the results into the records
     $result = fORMDatabase::retrieve()->translatedQuery($new_sql);
     $total_records = sizeof($this->records);
     for ($i = 0; $i < $total_records; $i++) {
         // Get the record we are injecting into
         $record = $this->records[$i];
         $keys = array();
         // If we are going through a join table, keep track of the record by the value in the join table
         if (isset($relationship['join_table'])) {
             try {
                 $current_row = $result->current();
                 $keys[$relationship['column']] = $current_row[$relationship['column']];
             } catch (fExpectedException $e) {
             }
             // If it is a straight join, keep track of the value by the related column value
         } else {
             $method = 'get' . fGrammar::camelize($relationship['related_column'], TRUE);
             $keys[$relationship['related_column']] = $record->{$method}();
         }
         // Loop through and find each row for the current record
         $rows = array();
         try {
             while (!array_diff_assoc($keys, $result->current())) {
                 $row = $result->fetchRow();
                 // If we are going through a join table we need to remove the related primary key that was used for matching
                 if (isset($relationship['join_table'])) {
                     unset($row[$relationship['column']]);
                 }
                 $rows[] = $row;
             }
         } catch (fExpectedException $e) {
         }
         // Set up the result object for the new record set
         $set = new fRecordSet($related_class, new ArrayIterator($rows));
         // Inject the new record set into the record
         $method = 'inject' . fGrammar::pluralize($related_class);
         $record->{$method}($set, $route);
     }
     return $this;
 }
开发者ID:jsuarez,项目名称:MyDesign,代码行数:82,代码来源:fRecordSet.php


注:本文中的fORMDatabase::createOrderByClause方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。