/** * 获取高级查询的排序SQL * @param advanceQuerySorts 排序列表 * @return 条件SQL * @throws Exception */ static function getAdvanceQuerySortSql($advanceQuerySorts) { // 定义条件SQL $sortSql = ""; if ($advanceQuerySorts != null && count($advanceQuerySorts) > 0) { // 加入前置的and参数 $sortSql .= " order by "; foreach ($advanceQuerySorts as $advanceQuerySort) { // 获取参数:field-字段名 logic-排序逻辑 $field = $advanceQuerySort["field"]; $logic = $advanceQuerySort["logic"]; // 拼接SQL $sortSql .= QueryUtils::getSingleAdvanceQuerySortSql($field, $logic); } $sortSql = substr($sortSql, 0, strlen($sortSql) - 3); } // 返回条件SQL return $sortSql; }