/dports/www/tikiwiki/tiki-21.2/lib/core/TikiDb/ |
H A D | Table.php | 151 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 D | LeaveEntitlementDao.php | 176 $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 D | CustomRouteLib.php | 104 * @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 D | parse_clause.c | 2637 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 D | parse_clause.c | 2637 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 D | parse_clause.c | 2637 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 D | parse_clause.c | 2637 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 D | parse_clause.c | 2637 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 D | parse_clause.c | 2637 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 D | parse_clause.c | 2637 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 D | parse_clause.c | 2663 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 D | parse_clause.c | 2663 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 D | parse_clause.c | 2663 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 D | parse_clause.c | 2663 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 D | parse_clause.c | 2663 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 D | parse_clause.c | 2663 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 D | parse_clause.c | 2645 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 D | parse_clause.c | 2663 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 D | parse_clause.c | 2645 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 D | parse_clause.c | 2597 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 D | parse_clause.c | 2597 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 D | parse_clause.c | 2597 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 D | parse_clause.c | 2645 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 D | parse_clause.c | 2645 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 D | parse_clause.c | 2597 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 …]
|