<?php
/************************************************************************
 * MXChange v0.2.1                                    Start: 08/03/2004 *
 * ================                             Last change: 08/07/2004 *
 *                                                                      *
 * -------------------------------------------------------------------- *
 * File              : what-list_task.php                               *
 * -------------------------------------------------------------------- *
 * Short description : List all tasks                                   *
 * -------------------------------------------------------------------- *
 * Kurzbeschreibung  : Alle Aufgaben auflisten                          *
 * -------------------------------------------------------------------- *
 * $Revision::                                                        $ *
 * $Date::                                                            $ *
 * $Tag:: 0.2.1-FINAL                                                 $ *
 * $Author::                                                          $ *
 * Needs to be in all Files and every File needs "svn propset           *
 * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
 * -------------------------------------------------------------------- *
 * Copyright (c) 2003 - 2009 by Roland Haeder                           *
 * For more information visit: http://www.mxchange.org                  *
 *                                                                      *
 * This program is free software; you can redistribute it and/or modify *
 * it under the terms of the GNU General Public License as published by *
 * the Free Software Foundation; either version 2 of the License, or    *
 * (at your option) any later version.                                  *
 *                                                                      *
 * This program is distributed in the hope that it will be useful,      *
 * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
 * GNU General Public License for more details.                         *
 *                                                                      *
 * You should have received a copy of the GNU General Public License    *
 * along with this program; if not, write to the Free Software          *
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
 * MA  02110-1301  USA                                                  *
 ************************************************************************/

// Some security stuff...
if ((!defined('__SECURITY')) || (!isAdmin())) {
	die();
} // END - if

// Add description as navigation point
addMenuDescription('admin', __FILE__);

if (!isExtensionActive('task')) {
	loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('task'));
	return;
} // END - if

$whereStatement = '';
if (!isGetRequestElementSet(('type'))) setRequestGetElement('type', 'your');

switch (getRequestElement('type')) {
	case 'your': // List only your own open (new) tasks
		$whereStatement = "`assigned_admin`='".getCurrentAdminId()."' AND `status`='NEW' AND `task_type` != 'EXTENSION_UPDATE'";
		break;

	case 'updates': // List only updates assigned to you
		$whereStatement = "`assigned_admin`=".getCurrentAdminId()." AND `status`='NEW' AND `task_type`='EXTENSION_UPDATE'";
		break;

	case 'solved': // List only solved tasks assigned to you
		$whereStatement = "`assigned_admin`=".getCurrentAdminId()." AND `status`='SOLVED'";
		break;

	case 'unassigned': // List unassigned (but not deleted) tasks
		$whereStatement = "`assigned_admin`=0 AND `status` != 'DELETED'";
		break;

	case 'deleted': // List all deleted
		$whereStatement = "`status`='DELETED'";
		break;

	case 'closed': // List all closed
		$whereStatement = "`assigned_admin`=".getCurrentAdminId()." AND `status`='CLOSED'";
		break;

	default: // Unknown type
		logDebugMessage(__FILE__, __LINE__, sprintf("Unknown task type %s detected.", getRequestElement('type')));
		loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_TASK_UNKNOWN_MODE'), getRequestElement('type')));
		break;
}

if (!empty($whereStatement)) {
	$SEL = '0';
	if (isPostRequestElementSet(('task'))) $SEL = countSelection(postRequestElement('task'));

	if ((isPostRequestElementSet(('assign'))) && ($SEL > 0)) {
		// Assign / do tasks
		loadIncludeOnce("inc/modules/admin/overview-inc.php");
		if (empty($dmy)) $dmy = '';
		outputSeletectedTasks(postRequestArray(), $dmy);
	} else {
		// Start listing tasks matching selected filter
		$result_tasks = SQL_QUERY('SELECT
	`id`, `assigned_admin`, `userid`, `task_type`, `subject`, `text`, `task_created`
FROM
	`{?_MYSQL_PREFIX?}_task_system`
WHERE
	'.$whereStatement.'
ORDER BY
	`userid` DESC,
	`task_type` DESC,
	`subject` ASC,
	`task_created` DESC',
			__FILE__, __LINE__);
		if (($SEL > 0) && (!isDemoModeActive())) {
			// Only unassign / delete tasks when there are selected tasks posted
			if (isPostRequestElementSet('unassign')) {
				// Unassign from tasks
				foreach (postRequestElement('task') as $id => $sel) {
					SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `assigned_admin`=0 WHERE `id`=%s AND `assigned_admin`=%s LIMIT 1",
						array(bigintval($id), getCurrentAdminId()), __FILE__, __LINE__);
				}
			} elseif (isPostRequestElementSet('del')) {
				// Delete tasks
				foreach (postRequestElement('task') as $id => $sel) {
					if (getRequestElement('type') == 'deleted') {
						// Delete task immediately
						SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_task_system` WHERE `id`=%s LIMIT 1",
							array(bigintval($id)),__FILE__, __LINE__);
					} else {
						// Mark task as to be deleted (purged by autopurge extension)
						adminDeleteTask($id);
					}
				}
			} else {
				// Unknown action performed
				debug_report_bug(sprintf("Unknown task action performed. data=<pre>%s</pre>", print_r(postRequestArray(), true)));
			}

			// Update query
			$result_tasks = SQL_QUERY('SELECT
	`id`, `assigned_admin`, `userid`, `task_type`, `subject`, `text`, `task_created`
FROM
	`{?_MYSQL_PREFIX?}_task_system`
WHERE
	'.$whereStatement.'
ORDER BY
	`subject` ASC,
	`task_created` DESC', __FILE__, __LINE__);
		}

		// There are uncompleted jobs!
		$type = getMessage('ADMIN_OVERVIEW_TASK_'.strtoupper(getRequestElement('type')).'_TYPE');
		// @TODO Rewrite these templates to one and add $OUT
		loadTemplate('admin_overview_header_task', false, array(
			'message' => $type,
			'type'    => getRequestElement('type')
		));
		$OUT = ''; $SW = 2;
		while ($content = SQL_FETCHARRAY($result_tasks)) {
			// Init infos
			$content['infos'] = '---';

			// Generate link
			$content['assigned_admin'] = generateAdminLink($content['assigned_admin']);

			// Get admin task
			$content['task_type_msg'] = getMessage('ADMIN_TASK_IS_'.strtoupper($content['task_type']).'');

			// Generate infos
			switch ($content['task_type']) {
				case 'EXTENSION':
				case 'EXTENSION_UPDATE':
					$content['infos'] = substr($content['subject'], 1, strpos($content['subject'], ':') - 1);
					break;
			} // END - switch

			// Member assigned with task?
			if ($content['userid'] > 0) {
				// Member found otherwise it's a system task
				$content['userid'] = generateUserProfileLink($content['userid']);
			} else {
				// Is a system task!
				$content['userid'] = '<em>{--ADMIN_IS_SYSTEM_TASK--}</em>';
			}

			// Prepare content
			// @TODO Rewritings: admin->assigned_admin,userid->userid,type->task_type_msg in template
			$content = merge_array($content, array(
				'sw'      => $SW,
				'admin'   => $content['assigned_admin'],
				'userid'  => $content['userid'],
				'type'    => $content['task_type_msg'],
				'created' => generateDateTime($content['task_created'], 2)
			));

			// Do we have an extension task?
			if (($content['task_type'] == 'EXTENSION') && (isExtensionNameValid($content['infos'])) && (!isExtensionInstalled($content['infos']))) {
				// Load extension row template
				// @TODO Rewrite this to $OUT .= ..., true, ...
				loadTemplate('admin_list_task_ext_rows', false, $content);
			} else {
				// Load default row template
				// @TODO Rewrite this to $OUT .= ..., true, ...
				loadTemplate('admin_list_task_rows', false, $content);
			}

			// Switch colors
			$SW = 3 - $SW;
		}

		// Free memory
		SQL_FREERESULT($result_tasks);

		// Load footer template
		if (getRequestElement('type') == 'deleted') {
			// Delete now button
			loadTemplate('admin_overview_footer_task');
		} else {
			// Normal footer
			loadTemplate('admin_overview_footer');
		}
	}
}

// [EOF]
?>