예제 #1
0
파일: ListView.php 프로젝트: hardikk/HNH
$focus->del_create_def_folder($focus->query);
$dbQuery = "select * from vtiger_attachmentsfolder";
$result = $adb->pquery($dbQuery, array());
$foldercount = $adb->num_rows($result);
$folders = array();
$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 . "." : '';