case 'subject_desc': $order_by = MessageService::SUBJECT; $order_type = "DESC"; break; default: $order_by = MessageService::DATE; $order_type = "DESC"; break; } //Creo il MessageService e prendo i messaggi $ms = new MessageService($currentUser['id']); $messages = $ms->getFolder($folder, $page, $order_type, $order_by); //Array contenente i dati del json $array = array(); //Creo i dati della paginazione $pag = new Pagination($ms->getFolderCountMessages($folder), MessageService::MESSAGE_FOR_PAGE, $page); $array['pagination'] = $pag->getNavigator("default.html", "javascript:Messages.goToPage(#PAGE#);"); $array['messages'] = array(); foreach ($messages as $m) { $date = DateUtils::GetNice($m['date_tm']); $q = DB::FindOne("SELECT user FROM users WHERE id = " . $m[$to_field] . " LIMIT 1"); $to_from = $m->isMultiple() && $folder == MessageService::SENT ? 'Tutti i membri' : $q['user']; $delete_restore = ''; if ($folder == MessageService::INBOX) { $delete_restore = 'C'; } else { if ($folder == MessageService::DELETED) { $delete_restore = 'R'; } } $array['messages'][] = array("date" => $date, "to_from" => $to_from, "delete_restore" => $delete_restore, "id" => $m['id'], "subject" => $m->getRaw('subject'), "viewed" => $m['viewed'] == 1, "important" => $m['important'] == 1);