/**
* 获取高级查询的排序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;
}
