9c5d2c2ecf04f2fe633b4685ce4e401a88427759
[mailer.git] / inc / modules / admin / what-list_task.php
1 <?php
2 /************************************************************************
3  * MXChange v0.2.1                                    Start: 08/03/2004 *
4  * ================                             Last change: 08/07/2004 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : what-list_task.php                               *
8  * -------------------------------------------------------------------- *
9  * Short description : List all tasks                                   *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Alle Aufgaben auflisten                          *
12  * -------------------------------------------------------------------- *
13  *                                                                      *
14  * -------------------------------------------------------------------- *
15  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
16  * For more information visit: http://www.mxchange.org                  *
17  *                                                                      *
18  * This program is free software; you can redistribute it and/or modify *
19  * it under the terms of the GNU General Public License as published by *
20  * the Free Software Foundation; either version 2 of the License, or    *
21  * (at your option) any later version.                                  *
22  *                                                                      *
23  * This program is distributed in the hope that it will be useful,      *
24  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
26  * GNU General Public License for more details.                         *
27  *                                                                      *
28  * You should have received a copy of the GNU General Public License    *
29  * along with this program; if not, write to the Free Software          *
30  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
31  * MA  02110-1301  USA                                                  *
32  ************************************************************************/
33
34 // Some security stuff...
35 if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
36         $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
37         require($INC);
38 } elseif (!EXT_IS_ACTIVE("task")) {
39         ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "task");
40         return;
41 }
42
43 // Add description as navigation point
44 ADD_DESCR("admin", __FILE__);
45
46 $whereStatement = "";
47 if (empty($_GET['type'])) $_GET['type'] = "your";
48
49 switch ($_GET['type'])
50 {
51 case "your": // List only your own open (new) tasks
52         $whereStatement = "assigned_admin='".GET_CURRENT_ADMIN_ID()."' AND status='NEW' AND task_type != 'EXTENSION_UPDATE'";
53         break;
54
55 case "updates": // List only updates assigned to you
56         $whereStatement = "assigned_admin=".GET_CURRENT_ADMIN_ID()." AND status='NEW' AND task_type = 'EXTENSION_UPDATE'";
57         break;
58
59 case "solved": // List only solved tasks assigned to you
60         $whereStatement = "assigned_admin=".GET_CURRENT_ADMIN_ID()." AND status='SOLVED'";
61         break;
62
63 case "unassigned": // List unassigned (but not deleted) tasks
64         $whereStatement = "assigned_admin='0' AND status != 'DELETED'";
65         break;
66
67 case "deleted": // List all deleted
68         $whereStatement = "status='DELETED'";
69         break;
70
71 case "closed": // List all closed
72         $whereStatement = "assigned_admin=".GET_CURRENT_ADMIN_ID()." AND status='CLOSED'";
73         break;
74
75 default: // Unknown type
76         DEBUG_LOG(__FILE__, __LINE__, sprintf("Unknown task type %s detected.", $_GET['type']));
77         LOAD_TEMPLATE("admin_settings_saved", false, TASK_ADMIN_UNKNOWN_MODE_1.$_GET['type'].TASK_ADMIN_UNKNOWN_MODE_2);
78         break;
79 }
80
81 if (!empty($whereStatement))
82 {
83         $SEL = 0;
84         if (isset($_POST['task'])) $SEL = SELECTION_COUNT($_POST['task']);
85         if ((isset($_POST['assign'])) && ($SEL > 0)) {
86                 // Assign / do tasks
87                 require_once(PATH."inc/modules/admin/overview-inc.php");
88                 if (empty($dmy)) $dmy = "";
89                 OUTPUT_SELECTED_TASKS($_POST, $dmy);
90         } else {
91                 // Start listing tasks matching selected filter
92                 $result_tasks = SQL_QUERY("SELECT id, assigned_admin, userid, task_type, subject, text, task_created
93 FROM "._MYSQL_PREFIX."_task_system
94 WHERE ".$whereStatement."
95 ORDER BY userid DESC, task_type DESC, subject, task_created DESC", __FILE__, __LINE__);
96                 if (($SEL > 0) && (!IS_DEMO())) {
97                         // Only unassign / delete tasks when there are selected tasks posted
98                         if (isset($_POST['unassign'])) {
99                                 // Unassign from tasks
100                                 foreach ($_POST['task'] as $id => $sel) {
101                                         $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_task_system SET assigned_admin=0 WHERE id=%s AND assigned_admin=%s LIMIT 1",
102                                          array(bigintval($id), GET_CURRENT_ADMIN_ID()), __FILE__, __LINE__);
103                                 }
104                         } elseif (isset($_POST['del'])) {
105                                 // Delete tasks
106                                 foreach ($_POST['task'] as $id => $sel) {
107                                         if ($_GET['type'] == "deleted") {
108                                                 // Delete task immediately
109                                                 $result = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_task_system WHERE id=%s LIMIT 1",
110                                                  array(bigintval($id)),__FILE__, __LINE__);
111                                         } else {
112                                                 // Mark task as to be deleted (purged by autppurge extension)
113                                                 ADMIN_DELETE_TASK($id);
114                                         }
115                                 }
116                         }
117
118                         // Update query
119                         $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, task_created DESC", __FILE__, __LINE__);
120                 }
121
122                 // There are uncompleted jobs!
123                 $type = constant('ADMIN_OVERVIEW_TASK_'.strtoupper($_GET['type']).'_TYPE');
124                 LOAD_TEMPLATE("admin_overview_header_task", false, array(
125                         'message' => $type,
126                         'type'    => $_GET['type']
127                 ));
128                 $SW = 2;
129                 while (list($id, $admin, $uid, $type, $subj, $text, $created) = SQL_FETCHROW($result_tasks))
130                 {
131                         $infos = "---";
132                         if ($admin == "0")
133                         {
134                                 // No admin currently is assigned
135                                 $admin = "<FONT class=\"admin_note\">".ADMIN_NO_ADMIN_ASSIGNED."</FONT>";
136                         }
137                          else
138                         {
139                                 // Load admin's data
140                                 $login = GET_ADMIN_LOGIN($admin);
141                                 if ($login != "***")
142                                 {
143                                         // Admin found
144                                         $admin = "<A href=\"".URL."/modules.php?module=admin&amp;what=admins_contct&amp;admin=".$admin."\">".$login."</A>";
145                                 }
146                                  else
147                                 {
148                                         // Maybe deleted?
149                                         $admin = "<FONT class=\"admin_note\">".ADMIN_ID_404_1.$admin.ADMIN_ID_404_2."</FONT>";
150                                 }
151                         }
152
153                         // Get admin task
154                         $type_out = constant('ADMIN_TASK_IS_'.strtoupper($type).'');
155
156                         $type2 = substr($text, 0, strpos($text, ":"));
157                         // Generate infos
158                         switch ($type)
159                         {
160                         case "EXTENSION":
161                         case "EXTENSION_UPDATE":
162                                 $infos = substr($subj, 1, strpos($subj, ":") - 1);
163                                 break;
164                         }
165
166                         // Member assigned with task?
167                         if ($uid > 0) {
168                                 // Member found otherwise it's a system task
169                                 $uid = ADMIN_USER_PROFILE_LINK($uid);
170                         } else {
171                                 // Is a system task!
172                                 $uid = "<I>".ADMIN_IS_SYSTEM_TASK."</I>";
173                         }
174
175                         // Prepare content
176                         $content = array(
177                                 'sw'      => $SW,
178                                 'id'      => $id,
179                                 'admin'   => $admin,
180                                 'infos'   => $infos,
181                                 'uid'     => $uid,
182                                 'type'    => $type_out,
183                                 'created' => MAKE_DATETIME($created, "2")
184                         );
185
186                         // Do we have an extension task?
187                         if (($type == "EXTENSION") && (GET_EXT_VERSION($infos) == "")) {
188                                 // Load extension row template
189                                 LOAD_TEMPLATE("admin_list_task_ext_rows", false, $content);
190                         } else {
191                                 // Load default row template
192                                 LOAD_TEMPLATE("admin_list_task_rows", false, $content);
193                         }
194
195                         // Switch colors
196                         $SW = 3 - $SW;
197                 }
198
199                 // Free memory
200                 SQL_FREERESULT($result_tasks);
201
202                 // Load footer template
203                 if ($_GET['type'] == "deleted")
204                 {
205                         // Delete now button
206                         LOAD_TEMPLATE("admin_overview_footer_task");
207                 }
208                  else
209                 {
210                         // Normal footer
211                         LOAD_TEMPLATE("admin_overview_footer");
212                 }
213         }
214 }
215 //
216 ?>