PHP Table::query方法代码示例

 /**
  * Move a node under the same parent node or under a new node.
  * New position of the node can be specified
  *
  * @param int $id ID of the node to move
  * @param int $parent_id ID of the (new) parent node
  * @param int $position New position of the node. Position is zero based.
  * @return boolean
  */
 public function moveNode($id, $parent_id, $position = null)
 {
     $primaryKey = $this->_table->schema()->primaryKey();
     $primaryKey = count($primaryKey) == 1 ? $primaryKey[0] : $primaryKey;
     $parent_id_fieldname = $this->config('model_parent_id_fieldname');
     $sort_fieldname = $this->config('model_sort_fieldname');
     $connection = $this->_table->connection();
     $connection->begin();
     $result = true;
     /*
      * Get moved node
      */
     $node = $this->_table->get($id);
     /*
      * Get current nodes positions of (new) siblings
      */
     $current_children = $this->_table->query()->where([$parent_id_fieldname => $parent_id])->order([$sort_fieldname => 'asc']);
     $new_sort_children = [];
     foreach ($current_children as $current_position => $current_child) {
         if ($current_child->{$primaryKey} != $id) {
             $new_sort_children[] = $current_child;
         }
     }
     /*
      * Default position is after all siblings
      */
     $position = isset($position) ? $position : $current_children->count();
     $position = $position >= 0 ? $position : 0;
     $position = $position <= count($new_sort_children) ? $position : count($new_sort_children);
     /*
      * Insert moved node at position
      */
     array_splice($new_sort_children, $position, 0, array($node));
     /*
      * If node has a new parent -> save it
      */
     if ($node->{$parent_id_fieldname} != $parent_id) {
         $query = $this->_table->query()->update()->set([$parent_id_fieldname => $parent_id])->where([$primaryKey => $id]);
         if (!$query->execute()) {
             $result = false;
         }
     }
     /*
      * Update positions
      */
     foreach ($new_sort_children as $index => $new_sort_child) {
         $query = $this->_table->query()->update()->set([$sort_fieldname => $index * 10])->where([$primaryKey => $new_sort_child->{$primaryKey}]);
         if (!$query->execute()) {
             $result = false;
         }
     }
     /***********/
     if ($result) {
         $connection->commit();
     } else {
         $connection->rollback();
     }
     return $result;
 }

 /**
  * Auxiliary function used to automatically alter the value of both the left and
  * right columns by a certain amount that match the passed conditions
  *
  * @param int $shift the value to use for operating the left and right columns
  * @param string $dir The operator to use for shifting the value (+/-)
  * @param string $conditions a SQL snipped to be used for comparing left or right
  * against it.
  * @param bool $mark whether to mark the updated values so that they can not be
  * modified by future calls to this function.
  * @return void
  */
 protected function _sync($shift, $dir, $conditions, $mark = false)
 {
     $config = $this->config();
     foreach ([$config['left'], $config['right']] as $field) {
         $query = $this->_scope($this->_table->query());
         $mark = $mark ? '*-1' : '';
         $template = sprintf('%s = (%s %s %s)%s', $field, $field, $dir, $shift, $mark);
         $query->update()->set($query->newExpr()->add($template));
         $query->where("{$field} {$conditions}");
         $query->execute();
     }
 }