$emptyfolders = array();
if ($foldercount > 0) {
for ($i = 0; $i < $foldercount; $i++) {
$query = '';
$displayFolder = '';
$query = $focus->query;
$list_query = '';
$list_query = $focus->query;
$folder_id = $adb->query_result($result, $i, "folderid");
$query .= " and vtiger_notes.folderid = {$folder_id}";
$sorder = $focus->getSortOrderForFolder($folder_id);
if (!is_array($_SESSION['NOTES_FOLDER_SORT_ORDER'])) {
$_SESSION['NOTES_FOLDER_SORT_ORDER'] = array();
}
$_SESSION['NOTES_FOLDER_SORT_ORDER'][$folder_id] = $sorder;
$order_by = $focus->getOrderByForFolder($folder_id);
if (!is_array($_SESSION['NOTES_FOLDER_ORDER_BY'])) {
$_SESSION['NOTES_FOLDER_ORDER_BY'] = array();
}
$_SESSION['NOTES_FOLDER_ORDER_BY'][$folder_id] = $order_by;
if ($folder_id != $request_folderid) {
$start[$folder_id] = 1;
}
if (isset($order_by) && $order_by != '') {
$tablename = getTableNameForField('Documents', $order_by);
$tablename = $tablename != '' ? $tablename . "." : '';
if ($adb->dbType == "pgsql") {
$query .= ' GROUP BY ' . $tablename . $order_by;
$list_query .= ' GROUP BY ' . $tablename . $order_by;
$focus->additional_query .= ' GROUP BY ' . $tablename . $order_by;
}