function prepareTaskRow($r, $lists)
{
$lang = Lang::instance();
$dueA = prepare_duedate($r['duedate']);
$formatCreatedInline = $formatCompletedInline = Config::get('dateformatshort');
if (date('Y') != date('Y', $r['d_created'])) {
$formatCreatedInline = Config::get('dateformat2');
}
if ($r['d_completed'] && date('Y') != date('Y', $r['d_completed'])) {
$formatCompletedInline = Config::get('dateformat2');
}
$dCreated = timestampToDatetime($r['d_created']);
$dCompleted = $r['d_completed'] ? timestampToDatetime($r['d_completed']) : '';
return array('id' => $r['id'], 'title' => escapeTags($r['title']), 'listId' => $r['list_id'], 'listName' => $lists['list'][$r['list_id']]['name'], 'date' => htmlarray($dCreated), 'dateInt' => (int) $r['d_created'], 'dateInline' => htmlarray(formatTime($formatCreatedInline, $r['d_created'])), 'dateInlineTitle' => htmlarray(sprintf($lang->get('taskdate_inline_created'), $dCreated)), 'dateEditedInt' => (int) $r['d_edited'], 'dateCompleted' => htmlarray($dCompleted), 'dateCompletedInline' => $r['d_completed'] ? htmlarray(formatTime($formatCompletedInline, $r['d_completed'])) : '', 'dateCompletedInlineTitle' => htmlarray(sprintf($lang->get('taskdate_inline_completed'), $dCompleted)), 'compl' => (int) $r['compl'], 'prio' => $r['prio'], 'note' => nl2br(escapeTags($r['note'])), 'noteText' => (string) $r['note'], 'ow' => (int) $r['ow'], 'tags' => htmlarray($r['tags']), 'tags_ids' => htmlarray($r['tags_ids']), 'duedate' => $dueA['formatted'], 'dueClass' => $dueA['class'], 'dueStr' => htmlarray($r['compl'] && $dueA['timestamp'] ? formatTime($formatCompletedInline, $dueA['timestamp']) : $dueA['str']), 'dueInt' => date2int($r['duedate']), 'dueTitle' => htmlarray(sprintf($lang->get('taskdate_inline_duedate'), $dueA['formatted'])));
}
function navigator_group_edit()
{
$id = $this->input->post("id");
$status = $this->input->post('status');
$name_lang_1 = mysql_real_escape_string($this->input->post("name_lang_1"));
$description_lang_1 = mysql_real_escape_string($this->input->post("description_lang_1"));
$name_lang_2 = mysql_real_escape_string($this->input->post("name_lang_2"));
$description_lang_2 = mysql_real_escape_string($this->input->post("description_lang_2"));
$time = timestampToDatetime(time());
$data = array('navigator_name_lang1' => $name_lang_1, 'navigator_description_lang1' => $description_lang_1, 'navigator_name_lang2' => $name_lang_2, 'navigator_description_lang2' => $description_lang_2, 'navigator_status' => $status, 'navigator_update_time' => $time);
$this->db->where("navigator_id", $id);
$this->db->update("pors_navigator_position", $data);
$data = array('layout' => 'top', 'icon' => 'fa-angellist', 'timeout' => '5000', 'message' => 'แก้ไขเมนูเรียบร้อยแล้ว', 'type' => 'success', 'theme' => 'bootstrapTheme');
$this->session->set_flashdata('result', $data);
redirect("pors/navigator");
}
function getNotificationListFromDB()
{
global $db;
$current_user_id = (int) $_SESSION['userid'];
if ($current_user_id > 0) {
$q = $db->dq("SELECT * FROM {$db->prefix}notifications WHERE shown = 0 AND user_id = " . $current_user_id . " ORDER BY created DESC");
while ($r = $q->fetch_assoc()) {
if ((int) $r['creator_user_id'] > 0) {
$user_name = $db->sq("SELECT username FROM {$db->prefix}users WHERE id=" . $r['creator_user_id']);
} else {
$user_name = '';
}
?>
<tr class="notification_row" id="notification_row_<?php
echo $r['id'];
?>
">
<td valign="left" class="col_created"><?php
echo timestampToDatetime(strtotime($r['created']));
?>
</td>
<td valign="left" class="col_user"><?php
echo $user_name;
?>
</td>
<td valign="left" class="col_desc"><?php
echo $r['text'];
?>
</td>
<td>
<a href="#markread" rel="<?php
echo $r['id'];
?>
" class="markread"></a>
</td>
</tr>
<?php
}
}
}
if ($r['prio'] > 0) {
$r['prio'] = '+' . $r['prio'];
}
$a = array();
if ($r['prio']) {
$a[] = $lang->get('priority') . ": {$r['prio']}";
}
if ($r['duedate'] != '') {
$ad = explode('-', $r['duedate']);
$a[] = $lang->get('due') . ": " . formatDate3(Config::get('dateformat'), (int) $ad[0], (int) $ad[1], (int) $ad[2], $lang);
}
if ($r['tags'] != '') {
$a[] = $lang->get('tags') . ": " . str_replace(',', ', ', $r['tags']);
}
if ($r['compl']) {
$a[] = $lang->get('taskdate_completed') . ": " . timestampToDatetime($r['d_completed']);
}
$r['title'] = strip_tags($r['title']);
$r['note'] = escapeTags($r['note']);
$r['_descr'] = nl2br($r['note']) . ($a && $r['note'] != '' ? "<br/><br/>" : "") . implode("<br/>", htmlarray($a));
$data[] = $r;
}
printRss($listData, $data);
function printRss($listData, $data)
{
$link = get_mttinfo('url') . "?list=" . $listData['id'];
$buildDate = gmdate('r');
$s = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<rss version=\"2.0\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\">\n<channel>\n" . "<title>{$listData['_feed_title']}</title>\n<link>{$link}</link>\n<description>{$listData['_feed_descr']}</description>\n" . "<lastBuildDate>{$buildDate}</lastBuildDate>\n\n";
foreach ($data as $v) {
$d = gmdate('r', $v[$listData['_uid_field']]);
$guid = $listData['id'] . '-' . $v['id'] . '-' . $v[$listData['_uid_field']];
function prepareTaskRow($r)
{
$lang = Lang::instance();
$dueA = prepare_duedate($r['duedate']);
$formatCreatedInline = $formatCompletedInline = Config::get('dateformatshort');
if (date('Y') != date('Y', $r['d_created'])) {
$formatCreatedInline = Config::get('dateformat2');
}
if ($r['d_completed'] && date('Y') != date('Y', $r['d_completed'])) {
$formatCompletedInline = Config::get('dateformat2');
}
$dCreated = timestampToDatetime($r['d_created']);
$dCompleted = $r['d_completed'] ? timestampToDatetime($r['d_completed']) : '';
$db = DBConnection::instance();
$current_user_id = (int) $_SESSION['userid'];
$notification_id = (int) $db->sq("SELECT id FROM {$db->prefix}notification_listeners WHERE type = 'list' AND value = " . $r['id'] . " AND user_id=" . $current_user_id);
$progress = '';
$progress_current = '';
$progress_total = '';
if (!empty($r['duration'])) {
$progress = ceil(TimeTracker::getTaskTotal($r['id']) * 100 / ($r['duration'] * 60));
$progress_current = TimeTracker::getTaskTotal($r['id']) / 60;
$progress_total = $r['duration'];
}
return array('id' => $r['id'], 'title' => escapeTags($r['title']), 'listId' => $r['list_id'], 'date' => htmlarray($dCreated), 'dateInt' => (int) $r['d_created'], 'dateInline' => htmlarray(formatTime($formatCreatedInline, $r['d_created'])), 'dateInlineTitle' => htmlarray(sprintf($lang->get('taskdate_inline_created'), $dCreated)), 'dateEditedInt' => (int) $r['d_edited'], 'dateCompleted' => htmlarray($dCompleted), 'dateCompletedInline' => $r['d_completed'] ? htmlarray(formatTime($formatCompletedInline, $r['d_completed'])) : '', 'dateCompletedInlineTitle' => htmlarray(sprintf($lang->get('taskdate_inline_completed'), $dCompleted)), 'compl' => (int) $r['compl'], 'notification' => $notification_id > 0 ? 1 : 0, 'prio' => $r['prio'], 'note' => nl2br(escapeTags($r['note'])), 'noteText' => (string) $r['note'], 'ow' => (int) $r['ow'], 'tags' => htmlarray($r['tags']), 'tags_ids' => htmlarray($r['tags_ids']), 'duedate' => $dueA['formatted'], 'dueClass' => $dueA['class'], 'dueStr' => htmlarray($r['compl'] && $dueA['timestamp'] ? formatTime($formatCompletedInline, $dueA['timestamp']) : $dueA['str']), 'dueInt' => date2int($r['duedate']), 'dueTitle' => htmlarray(sprintf($lang->get('taskdate_inline_duedate'), $dueA['formatted'])), 'duration' => empty($r['duration']) ? '' : $r['duration'], 'progress' => $progress, 'progress_current' => $progress_current, 'progress_total' => $progress_total, 'comments' => getTaskComments($r['id']));
}
function prepareTaskRow($r)
{
$lang = Lang::instance();
$dueA = prepare_duedate($r['duedate']);
$c_date = prepare_duedate($r['c_date']);
//$reminderformat = Config::get('dateformat2');
//$reminderdate = formatTime($reminderformat, $r['r_date']);
//From query
//'reminderdate' => $reminderdate,
//'reminderemail' => $r['r_email'],
//'remindernote' => $r['r_note'],
$formatCreatedInline = $formatCompletedInline = Config::get('dateformatshort');
if (date('Y') != date('Y', $r['d_created'])) {
$formatCreatedInline = Config::get('dateformat2');
}
if ($r['d_completed'] && date('Y') != date('Y', $r['d_completed'])) {
$formatCompletedInline = Config::get('dateformat2');
}
$dCreated = timestampToDatetime($r['d_created']);
$dCompleted = $r['d_completed'] ? timestampToDatetime($r['d_completed']) : '';
$return = array('id' => $r['id'], 'title' => escapeTags($r['title']), 'listId' => $r['list_id'], 'date' => htmlarray($dCreated), 'dateInt' => (int) $r['d_created'], 'dateInline' => htmlarray(formatTime($formatCreatedInline, $r['d_created'])), 'dateInlineTitle' => htmlarray(sprintf($lang->get('taskdate_inline_created'), $dCreated)), 'dateEditedInt' => (int) $r['d_edited'], 'dateCompleted' => htmlarray($dCompleted), 'dateCompletedInline' => $r['d_completed'] ? htmlarray(formatTime($formatCompletedInline, $r['d_completed'])) : '', 'dateCompletedInlineTitle' => htmlarray(sprintf($lang->get('taskdate_inline_completed'), $dCompleted)), 'compl' => (int) $r['compl'], 'prio' => $r['prio'], 'contact' => $r['c_contact'], 'contactdate' => $c_date['formatted'], 'contacttype' => $r['c_type'], 'note' => nl2br(escapeTags($r['note'])), 'noteText' => (string) $r['note'], 'ow' => (int) $r['ow'], 'tags' => htmlarray($r['tags']), 'tags_ids' => htmlarray($r['tags_ids']), 'duedate' => $dueA['formatted'], 'dueClass' => $dueA['class'], 'dueStr' => htmlarray($r['compl'] && $dueA['timestamp'] ? formatTime($formatCompletedInline, $dueA['timestamp']) : $dueA['str']), 'dueInt' => date2int($r['duedate']), 'dueTitle' => htmlarray(sprintf($lang->get('taskdate_inline_duedate'), $dueA['formatted'])));
return $return;
}
