本文整理汇总了PHP中Nette\Database\Table\Selection::getSqlBuilder方法的典型用法代码示例。如果您正苦于以下问题：PHP Selection::getSqlBuilder方法的具体用法？PHP Selection::getSqlBuilder怎么用？PHP Selection::getSqlBuilder使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Nette\Database\Table\Selection的用法示例。
在下文中一共展示了Selection::getSqlBuilder方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: sort
/**
* Order data
* @param array $sorting
* @return self
*/
public function sort(array $sorting)
{
if ($sorting) {
$this->data_source->getSqlBuilder()->setOrder([], []);
foreach ($sorting as $column => $sort) {
$this->data_source->order("{$column} {$sort}");
}
} else {
/**
* Has the statement already a order by clause?
*/
if (!$this->data_source->getSqlBuilder()->getOrder()) {
$this->data_source->order($this->primary_key);
}
}
return $this;
}示例2: sort
/**
* Sort data
* @param Sorting $sorting
* @return static
*/
public function sort(Sorting $sorting)
{
if (is_callable($sorting->getSortCallback())) {
call_user_func($sorting->getSortCallback(), $this->data_source, $sorting->getSort());
return $this;
}
$sort = $sorting->getSort();
if (!empty($sort)) {
$this->data_source->getSqlBuilder()->setOrder([], []);
foreach ($sort as $column => $order) {
$this->data_source->order("{$column} {$order}");
}
} else {
/**
* Has the statement already a order by clause?
*/
if (!$this->data_source->getSqlBuilder()->getOrder()) {
$this->data_source->order($this->primary_key);
}
}
return $this;
}