Home
last modified time | relevance | path

Searched refs:orderClause (Results 1 – 25 of 716) sorted by relevance

12345678910>>...29

/dports/www/tikiwiki/tiki-21.2/lib/core/TikiDb/
H A DTable.php151 function fetchOne($field, array $conditions, $orderClause = null) argument
174 * @param null $orderClause
178 function fetchFullRow(array $conditions, $orderClause = null) argument
187 * @param null $orderClause
277 * @param null $orderClause
306 $query .= $this->buildOrderClause($orderClause);
532 private function buildOrderClause($orderClause) argument
534 if ($orderClause instanceof TikiDb_Expr) {
535 return ' ORDER BY ' . $orderClause->getQueryPart(null);
536 } elseif (is_array($orderClause) && ! empty($orderClause)) {
[all …]
/dports/www/orangehrm/orangehrm-4.9/symfony/plugins/orangehrmLeavePlugin/lib/dao/
H A DLeaveEntitlementDao.php176 $orderClause = '';
180 $orderClause = 'l.name ' . $order;
184 $orderClause = 'e.emp_lastname ' . $order . ', e.emp_firstname ' . $order;
187 $orderClause = $orderField . ' ' . $order;
188 $orderClause = trim($orderClause);
193 if (!empty($orderClause)) {
194 $orderClause .= ', le.id ASC';
197 $q->addOrderBy($orderClause);
494 $orderClause = $orderField . ' ' . $order;
495 $orderClause = trim($orderClause);
[all …]
/dports/www/tikiwiki/tiki-21.2/lib/core/CustomRoute/
H A DCustomRouteLib.php104 * @param array $orderClause
108 public function getRouteByType($type = [], $orderClause = [], $onlyActive = 1) argument
123 return $routeTable->fetchAll([], $conditions, -1, -1, $orderClause);
/dports/databases/postgresql11-client/postgresql-11.14/src/backend/parser/
H A Dparse_clause.c2637 List *orderClause; in transformWindowDefinitions() local
2673 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2674 windef->orderClause, in transformWindowDefinitions()
2682 orderClause, in transformWindowDefinitions()
2721 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2727 if (orderClause) in transformWindowDefinitions()
2729 wc->orderClause = orderClause; in transformWindowDefinitions()
2734 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2740 wc->orderClause = orderClause; in transformWindowDefinitions()
2779 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql11-docs/postgresql-11.14/src/backend/parser/
H A Dparse_clause.c2637 List *orderClause; in transformWindowDefinitions() local
2673 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2674 windef->orderClause, in transformWindowDefinitions()
2682 orderClause, in transformWindowDefinitions()
2721 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2727 if (orderClause) in transformWindowDefinitions()
2729 wc->orderClause = orderClause; in transformWindowDefinitions()
2734 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2740 wc->orderClause = orderClause; in transformWindowDefinitions()
2779 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql11-plperl/postgresql-11.14/src/backend/parser/
H A Dparse_clause.c2637 List *orderClause;
2673 orderClause = transformSortClause(pstate,
2674 windef->orderClause,
2682 orderClause,
2721 if (orderClause && refwc->orderClause)
2727 if (orderClause)
2729 wc->orderClause = orderClause;
2734 wc->orderClause = copyObject(refwc->orderClause);
2740 wc->orderClause = orderClause;
2779 if (list_length(wc->orderClause) != 1)
[all …]
/dports/databases/postgresql11-contrib/postgresql-11.14/src/backend/parser/
H A Dparse_clause.c2637 List *orderClause; in transformWindowDefinitions() local
2673 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2674 windef->orderClause, in transformWindowDefinitions()
2682 orderClause, in transformWindowDefinitions()
2721 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2727 if (orderClause) in transformWindowDefinitions()
2729 wc->orderClause = orderClause; in transformWindowDefinitions()
2734 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2740 wc->orderClause = orderClause; in transformWindowDefinitions()
2779 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql11-plpython/postgresql-11.14/src/backend/parser/
H A Dparse_clause.c2637 List *orderClause;
2673 orderClause = transformSortClause(pstate,
2674 windef->orderClause,
2682 orderClause,
2721 if (orderClause && refwc->orderClause)
2727 if (orderClause)
2729 wc->orderClause = orderClause;
2734 wc->orderClause = copyObject(refwc->orderClause);
2740 wc->orderClause = orderClause;
2779 if (list_length(wc->orderClause) != 1)
[all …]
/dports/databases/postgresql11-server/postgresql-11.14/src/backend/parser/
H A Dparse_clause.c2637 List *orderClause; in transformWindowDefinitions() local
2673 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2674 windef->orderClause, in transformWindowDefinitions()
2682 orderClause, in transformWindowDefinitions()
2721 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2727 if (orderClause) in transformWindowDefinitions()
2729 wc->orderClause = orderClause; in transformWindowDefinitions()
2734 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2740 wc->orderClause = orderClause; in transformWindowDefinitions()
2779 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/backend/parser/
H A Dparse_clause.c2637 List *orderClause; in transformWindowDefinitions() local
2673 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2674 windef->orderClause, in transformWindowDefinitions()
2682 orderClause, in transformWindowDefinitions()
2721 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2727 if (orderClause) in transformWindowDefinitions()
2729 wc->orderClause = orderClause; in transformWindowDefinitions()
2734 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2740 wc->orderClause = orderClause; in transformWindowDefinitions()
2779 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/backend/parser/
H A Dparse_clause.c2663 List *orderClause; in transformWindowDefinitions() local
2699 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2700 windef->orderClause, in transformWindowDefinitions()
2708 orderClause, in transformWindowDefinitions()
2747 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2753 if (orderClause) in transformWindowDefinitions()
2755 wc->orderClause = orderClause; in transformWindowDefinitions()
2760 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2766 wc->orderClause = orderClause; in transformWindowDefinitions()
2805 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql14-server/postgresql-14.1/src/backend/parser/
H A Dparse_clause.c2663 List *orderClause; in transformWindowDefinitions() local
2699 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2700 windef->orderClause, in transformWindowDefinitions()
2708 orderClause, in transformWindowDefinitions()
2747 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2753 if (orderClause) in transformWindowDefinitions()
2755 wc->orderClause = orderClause; in transformWindowDefinitions()
2760 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2766 wc->orderClause = orderClause; in transformWindowDefinitions()
2805 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql14-docs/postgresql-14.1/src/backend/parser/
H A Dparse_clause.c2663 List *orderClause; in transformWindowDefinitions() local
2699 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2700 windef->orderClause, in transformWindowDefinitions()
2708 orderClause, in transformWindowDefinitions()
2747 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2753 if (orderClause) in transformWindowDefinitions()
2755 wc->orderClause = orderClause; in transformWindowDefinitions()
2760 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2766 wc->orderClause = orderClause; in transformWindowDefinitions()
2805 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/backend/parser/
H A Dparse_clause.c2663 List *orderClause; in transformWindowDefinitions() local
2699 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2700 windef->orderClause, in transformWindowDefinitions()
2708 orderClause, in transformWindowDefinitions()
2747 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2753 if (orderClause) in transformWindowDefinitions()
2755 wc->orderClause = orderClause; in transformWindowDefinitions()
2760 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2766 wc->orderClause = orderClause; in transformWindowDefinitions()
2805 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/src/backend/parser/
H A Dparse_clause.c2663 List *orderClause; in transformWindowDefinitions() local
2699 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2700 windef->orderClause, in transformWindowDefinitions()
2708 orderClause, in transformWindowDefinitions()
2747 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2753 if (orderClause) in transformWindowDefinitions()
2755 wc->orderClause = orderClause; in transformWindowDefinitions()
2760 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2766 wc->orderClause = orderClause; in transformWindowDefinitions()
2805 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql14-client/postgresql-14.1/src/backend/parser/
H A Dparse_clause.c2663 List *orderClause; in transformWindowDefinitions() local
2699 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2700 windef->orderClause, in transformWindowDefinitions()
2708 orderClause, in transformWindowDefinitions()
2747 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2753 if (orderClause) in transformWindowDefinitions()
2755 wc->orderClause = orderClause; in transformWindowDefinitions()
2760 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2766 wc->orderClause = orderClause; in transformWindowDefinitions()
2805 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/backend/parser/
H A Dparse_clause.c2645 List *orderClause; in transformWindowDefinitions() local
2681 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2682 windef->orderClause, in transformWindowDefinitions()
2690 orderClause, in transformWindowDefinitions()
2729 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2735 if (orderClause) in transformWindowDefinitions()
2737 wc->orderClause = orderClause; in transformWindowDefinitions()
2742 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2748 wc->orderClause = orderClause; in transformWindowDefinitions()
2787 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql14-contrib/postgresql-14.1/src/backend/parser/
H A Dparse_clause.c2663 List *orderClause; in transformWindowDefinitions() local
2699 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2700 windef->orderClause, in transformWindowDefinitions()
2708 orderClause, in transformWindowDefinitions()
2747 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2753 if (orderClause) in transformWindowDefinitions()
2755 wc->orderClause = orderClause; in transformWindowDefinitions()
2760 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2766 wc->orderClause = orderClause; in transformWindowDefinitions()
2805 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql13-server/postgresql-13.5/src/backend/parser/
H A Dparse_clause.c2645 List *orderClause; in transformWindowDefinitions() local
2681 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2682 windef->orderClause, in transformWindowDefinitions()
2690 orderClause, in transformWindowDefinitions()
2729 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2735 if (orderClause) in transformWindowDefinitions()
2737 wc->orderClause = orderClause; in transformWindowDefinitions()
2742 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2748 wc->orderClause = orderClause; in transformWindowDefinitions()
2787 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql12-server/postgresql-12.9/src/backend/parser/
H A Dparse_clause.c2597 List *orderClause; in transformWindowDefinitions() local
2633 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2634 windef->orderClause, in transformWindowDefinitions()
2642 orderClause, in transformWindowDefinitions()
2681 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2687 if (orderClause) in transformWindowDefinitions()
2689 wc->orderClause = orderClause; in transformWindowDefinitions()
2694 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2700 wc->orderClause = orderClause; in transformWindowDefinitions()
2739 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql12-plperl/postgresql-12.9/src/backend/parser/
H A Dparse_clause.c2597 List *orderClause;
2633 orderClause = transformSortClause(pstate,
2634 windef->orderClause,
2642 orderClause,
2681 if (orderClause && refwc->orderClause)
2687 if (orderClause)
2689 wc->orderClause = orderClause;
2694 wc->orderClause = copyObject(refwc->orderClause);
2700 wc->orderClause = orderClause;
2739 if (list_length(wc->orderClause) != 1)
[all …]
/dports/databases/postgresql12-pltcl/postgresql-12.9/src/backend/parser/
H A Dparse_clause.c2597 List *orderClause; in transformWindowDefinitions() local
2633 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2634 windef->orderClause, in transformWindowDefinitions()
2642 orderClause, in transformWindowDefinitions()
2681 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2687 if (orderClause) in transformWindowDefinitions()
2689 wc->orderClause = orderClause; in transformWindowDefinitions()
2694 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2700 wc->orderClause = orderClause; in transformWindowDefinitions()
2739 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql13-contrib/postgresql-13.5/src/backend/parser/
H A Dparse_clause.c2645 List *orderClause; in transformWindowDefinitions() local
2681 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2682 windef->orderClause, in transformWindowDefinitions()
2690 orderClause, in transformWindowDefinitions()
2729 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2735 if (orderClause) in transformWindowDefinitions()
2737 wc->orderClause = orderClause; in transformWindowDefinitions()
2742 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2748 wc->orderClause = orderClause; in transformWindowDefinitions()
2787 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql13-docs/postgresql-13.5/src/backend/parser/
H A Dparse_clause.c2645 List *orderClause; in transformWindowDefinitions() local
2681 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2682 windef->orderClause, in transformWindowDefinitions()
2690 orderClause, in transformWindowDefinitions()
2729 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2735 if (orderClause) in transformWindowDefinitions()
2737 wc->orderClause = orderClause; in transformWindowDefinitions()
2742 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2748 wc->orderClause = orderClause; in transformWindowDefinitions()
2787 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]
/dports/databases/postgresql12-docs/postgresql-12.9/src/backend/parser/
H A Dparse_clause.c2597 List *orderClause; in transformWindowDefinitions() local
2633 orderClause = transformSortClause(pstate, in transformWindowDefinitions()
2634 windef->orderClause, in transformWindowDefinitions()
2642 orderClause, in transformWindowDefinitions()
2681 if (orderClause && refwc->orderClause) in transformWindowDefinitions()
2687 if (orderClause) in transformWindowDefinitions()
2689 wc->orderClause = orderClause; in transformWindowDefinitions()
2694 wc->orderClause = copyObject(refwc->orderClause); in transformWindowDefinitions()
2700 wc->orderClause = orderClause; in transformWindowDefinitions()
2739 if (list_length(wc->orderClause) != 1) in transformWindowDefinitions()
[all …]

12345678910>>...29