diff -aburN --exclude='CVS*' phpgroupware16/tts/admin.php phpgroupware/tts/admin.php --- phpgroupware16/tts/admin.php 2004-02-19 21:20:46.000000000 -0500 +++ phpgroupware/tts/admin.php 2003-12-22 10:38:49.000000000 -0500 @@ -9,7 +9,7 @@ * option) any later version. * \**************************************************************************/ - /* $Id: admin.php,v 1.2.2.1.4.2 2004/01/20 05:03:42 jengo Exp $ */ + /* $Id: admin.php,v 1.2.2.1 2002/01/25 22:00:52 jengo Exp $ */ $GLOBALS['phpgw_info']['flags'] = array( 'currentapp' => 'tts', diff -aburN --exclude='CVS*' phpgroupware16/tts/create_tables.mysql phpgroupware/tts/create_tables.mysql --- phpgroupware16/tts/create_tables.mysql 1969-12-31 19:00:00.000000000 -0500 +++ phpgroupware/tts/create_tables.mysql 2003-12-22 10:38:49.000000000 -0500 @@ -0,0 +1,26 @@ +create table ticket ( + t_id int not null auto_increment, + t_category varchar(40) not null, + t_detail text, + t_priority smallint, + t_user varchar(10) not null, + t_assignedto varchar(10) not null, + t_timestamp_opened int, + t_timestamp_closed int, + t_subject varchar(255), + t_department varchar(25), + t_watchers text, + primary key (t_id) +); + +create table category ( + c_id int not null auto_increment, + c_department varchar(25) not null, + c_name varchar(40) not null, + primary key (c_id) +); + +create table department ( + d_name varchar(25) not null, + primary key (d_name) +); \ No newline at end of file diff -aburN --exclude='CVS*' phpgroupware16/tts/create_tables.pgsql phpgroupware/tts/create_tables.pgsql --- phpgroupware16/tts/create_tables.pgsql 1969-12-31 19:00:00.000000000 -0500 +++ phpgroupware/tts/create_tables.pgsql 2003-12-22 10:38:49.000000000 -0500 @@ -0,0 +1,23 @@ +create table ticket ( + t_id serial, + t_category varchar(40) not null, + t_detail text, + t_priority smallint, + t_user varchar(10) not null, + t_assignedto varchar(10) not null, + t_timestamp_opened int, + t_timestamp_closed int, + t_subject varchar(255), + t_department varchar(25), + t_watchers text +); + +create table category ( + c_id serial, + c_department varchar(25) not null, + c_name varchar(40) not null +); + +create table department ( + d_name varchar(25) not null +); diff -aburN --exclude='CVS*' phpgroupware16/tts/doc/README phpgroupware/tts/doc/README --- phpgroupware16/tts/doc/README 2003-11-01 17:50:48.000000000 -0500 +++ phpgroupware/tts/doc/README 1969-12-31 19:00:00.000000000 -0500 @@ -1,22 +0,0 @@ -New functions for TroubleTicketSystem - -- Attachments -To add an attachment to a ticket, a group tts has to be created and every user, -who works with tts has to be in that group. - -- New field "Type" -If Setup works correctly, the subcategories needed schould be created. If not, -create a global (under admin->admin, not admin->tts) category called "tts" and -a subcategory called "type". Every -subcategory added under "type" will then appear in the field. - -- New field "Platform" -Same as "Type", with "platform" being a subcategory of "tts". - -- New field "Effort" -It's just a string ;-) - -- Auto-Filters -There are dropdown-boxes for "category", "assigned to", "created by" and "priority". -Choose any entry from the boxes and the list of tickets will be filtered. - diff -aburN --exclude='CVS*' phpgroupware16/tts/doc/README.NOW phpgroupware/tts/doc/README.NOW --- phpgroupware16/tts/doc/README.NOW 2003-11-01 17:50:48.000000000 -0500 +++ phpgroupware/tts/doc/README.NOW 1969-12-31 19:00:00.000000000 -0500 @@ -1,8 +0,0 @@ -TTS is undergoing some masive changes at the molment, I have changed the format at least 4 times now. -Everytime I do this, I have to create upgrades. Which is making things more difficault. As I make my way -through the code, I am coming up with new and better ways of handling the data. Until I have settled on a -format DO NOT run upgrades on it. DO NOT use it for production!!! You WILL loose data this way. I hope to -have everything settled in the next week. - -You have been warned. -Joseph Engo diff -aburN --exclude='CVS*' phpgroupware16/tts/droptables.sql phpgroupware/tts/droptables.sql --- phpgroupware16/tts/droptables.sql 1969-12-31 19:00:00.000000000 -0500 +++ phpgroupware/tts/droptables.sql 2003-12-22 10:38:49.000000000 -0500 @@ -0,0 +1,3 @@ +DROP table ticket; +DROP table category; +DROP table department; diff -aburN --exclude='CVS*' phpgroupware16/tts/inc/class.attachedFiles.inc.php phpgroupware/tts/inc/class.attachedFiles.inc.php --- phpgroupware16/tts/inc/class.attachedFiles.inc.php 2004-02-19 21:20:47.000000000 -0500 +++ phpgroupware/tts/inc/class.attachedFiles.inc.php 1969-12-31 19:00:00.000000000 -0500 @@ -1,70 +0,0 @@ - * - * Copyright (C) 2003 probusiness AG (Lars Piepho) * - * * - * -------------------------------------------- * - * 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. * - \**************************************************************************/ - - /* $Id: class.attachedFiles.inc.php,v 1.1.2.2 2004/01/20 05:03:42 jengo Exp $ */ - - - class attachedFiles - { - - var $public_functions = array( - 'show_file' => True - ); - var $file; - var $vfs; - - function attachedFiles() - { - $this->file = $_REQUEST['file']; - - $GLOBALS['phpgw_info']['flags'] = array - ( - 'currentapp' => 'tts', - 'noheader' => True, - 'nofooter' => True, - 'enable_vfs_class' => True, - 'enable_browser_class' => True - ); - - $this->vfs = CreateObject('phpgwapi.vfs'); - - } - - function show_file() - { - $ls_array = $this->vfs->ls(array ( - 'string' => $this->file, - 'relatives' => array (RELATIVE_ALL), - 'checksubdirs' => False, - 'nofiles' => True)); - - if ($ls_array[0]['mime_type']) - { - $mime_type = $ls_array[0]['mime_type']; - } - elseif ($GLOBALS['settings']['viewtextplain']) - { - $mime_type = 'text/plain'; - } - $filename = basename($this->file); - header('Content-type: ' . $mime_type); - header('Content-Disposition: attachment; filename=' . $filename); - echo $this->vfs->read (array ( - 'string' => $this->file, - 'relatives' => array (RELATIVE_NONE))); - $GLOBALS['phpgw']->common->phpgw_exit (); - } - - } -?> diff -aburN --exclude='CVS*' phpgroupware16/tts/inc/class.bo.inc.php phpgroupware/tts/inc/class.bo.inc.php --- phpgroupware16/tts/inc/class.bo.inc.php 2004-02-19 21:20:47.000000000 -0500 +++ phpgroupware/tts/inc/class.bo.inc.php 2003-12-22 10:38:48.000000000 -0500 @@ -428,9 +428,9 @@ $body .= 'TTS #'.$ticket_id."\n\n"; $body .= 'Subject: '.$this->db->f('t_subject')."\n\n"; $body .= 'Assigned To: '.$this->db->f('t_assignedto')."\n\n"; - $body .= 'Priority: ' . $this->db->f('t_priority') . "\n\n"; - $body .= 'Group: ' . $group."\n\n"; - $body .= 'Opened By: ' . $this->db->f('t_user')."\n"; + $body .= 'Priority: ".$this->db->f('t_priority')."\n\n"; + $body .= 'Group: ".$group."\n\n"; + $body .= 'Opened By: ".$this->db->f('t_user')."\n"; $body .= 'Date Opened: '.$GLOBALS['phpgw']->common->show_date($this->db->f('t_timestamp_opened'))."\n\n"; if($this->db->f('t_timestamp_closed')) { diff -aburN --exclude='CVS*' phpgroupware16/tts/inc/class.subcategories.inc.php phpgroupware/tts/inc/class.subcategories.inc.php --- phpgroupware16/tts/inc/class.subcategories.inc.php 2004-02-19 21:20:47.000000000 -0500 +++ phpgroupware/tts/inc/class.subcategories.inc.php 1969-12-31 19:00:00.000000000 -0500 @@ -1,110 +0,0 @@ - * - * and Bettina Gille [ceb@phpgroupware.org] * - * Subcategory manager * - * Copyright (C) 2000, 2001 Joseph Engo, Bettina Gille * - * Copyright (C) 2002, 2003 Bettina Gille * - * Copyright (C) 2003 probusiness AG (Lars Piepho) * - * ------------------------------------------------------------------------ * - * This library is part of the phpGroupWare API * - * http://www.phpgroupware.org * - * ------------------------------------------------------------------------ * - * This library is free software; you can redistribute it and/or modify it * - * under the terms of the GNU Lesser General Public License as published by * - * the Free Software Foundation; either version 2.1 of the License, * - * or any later version. * - * This library 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 Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public License * - * along with this library; if not, write to the Free Software Foundation, * - * Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * - \**************************************************************************/ - // $Id: class.subcategories.inc.php,v 1.1.2.2 2004/01/20 05:03:42 jengo Exp $ - // $Source: /cvsroot/phpgroupware/tts/inc/Attic/class.subcategories.inc.php,v $ - - require_once constant('PHPGW_INCLUDE_ROOT') . "/phpgwapi/inc/class.categories.inc.php"; - - /*! - @class subcategories - @abstract class adds ability for applications to make use of subcategories - @discussion examples can be found in notes app - */ - - class subcategories extends categories - { - var $platform_id = 0; - var $type_id = 0; - /*! - @function subcategories - @abstract constructor for subcategories class - @param $accountid account id - @param $app_name app name defaults to current app - */ - function subcategories($accountid = '',$app_name = '') - { - parent::categories($accountid,$app_name); - $this->platform_id = $this->getSubCatId('platform'); - $this->type_id = $this->getSubCatId('type'); - } - - /*! - @function filter - @abstract ? - @param $type string - @result string either subs or mains - */ - function filter($type) - { - $s = parent::filter($type); - switch ($type) - { - case 'appandplatform': $s = " OR (cat_appname='phpgw' AND cat_parent=" . $this->platform_id . ')'; break; - case 'appandtype': $s = " OR (cat_appname='phpgw' AND cat_parent=" . $this->type_id . ')'; break; - default: return False; - } - return $s; - } - - function getSubCatId($subcat_name) - { - $sql = "SELECT cat_id FROM phpgw_categories WHERE cat_name='tts' AND cat_appname='phpgw'"; - $this->db->query($sql,__LINE__,__FILE__); - if(!$this->db->num_rows()) - { - return 0; - } - $this->db->next_record(); - $tts_id = $this->db->f('cat_id'); - - - $sql = "SELECT cat_id FROM phpgw_categories WHERE cat_name='" . $this->db->db_addslashes($subcat_name) . "' " - ."AND cat_appname='phpgw' AND cat_parent=" . $tts_id; - $this->db->query($sql,__LINE__,__FILE__); - if(!$this->db->num_rows()) - { - return 0; - } - $this->db->next_record(); - return $this->db->f('cat_id'); - } - - - function getSubCatElementId($subcat_name,$subcatelement_name) - { - $cat_id = $this->getSubCatId($subcat_name); - $sql = "SELECT cat_id FROM phpgw_categories WHERE cat_parent=" . $cat_id . " AND cat_name='" . $subcatelement_name . "'"; - $this->db->query($sql,__LINE__,__FILE__); - if(!$this->db->num_rows()) - { - return 0; - } - $this->db->next_record(); - return $this->db->f('cat_id'); - } - - } -?> diff -aburN --exclude='CVS*' phpgroupware16/tts/inc/hook_home.inc.php phpgroupware/tts/inc/hook_home.inc.php --- phpgroupware16/tts/inc/hook_home.inc.php 2003-11-30 18:59:37.000000000 -0500 +++ phpgroupware/tts/inc/hook_home.inc.php 2003-12-22 10:38:48.000000000 -0500 @@ -9,7 +9,7 @@ * option) any later version. * \**************************************************************************/ - /* $Id: hook_home.inc.php,v 1.9.2.2.4.3 2003/11/30 23:59:37 skwashd Exp $ */ + /* $Id: hook_home.inc.php,v 1.9.2.2 2002/06/23 17:03:16 skeeter Exp $ */ $d1 = strtolower(substr($GLOBALS['phpgw_info']['server']['app_inc'],0,3)); if($d1 == 'htt' || $d1 == 'ftp' ) @@ -111,7 +111,7 @@ 'tertiary' => $GLOBALS['phpgw_info']['theme']['navbar_bg'], 'width' => '100%', 'outerborderwidth' => '0', - 'header_background_image' => $GLOBALS['phpgw']->common->image('phpgwapi', 'bg_filler', '.png', 'bg_filler', False) + 'header_background_image' => $GLOBALS['phpgw']->common->image('phpgwapi/templates/phpgw_website','bg_filler') ) ); diff -aburN --exclude='CVS*' phpgroupware16/tts/index.php phpgroupware/tts/index.php --- phpgroupware16/tts/index.php 2004-07-08 22:33:29.000000000 -0400 +++ phpgroupware/tts/index.php 2003-12-22 10:38:49.000000000 -0500 @@ -9,7 +9,7 @@ * option) any later version. * \**************************************************************************/ - /* $Id: index.php,v 1.43.2.7.2.2.2.5 2004/05/11 13:39:05 lpiepho Exp $ */ + /* $Id: index.php,v 1.43.2.7.2.2 2003/03/05 22:34:55 gugux Exp $ */ /* Note to self: ** Self ... heres the query to use when limiting access to entrys within a group @@ -40,8 +40,8 @@ $GLOBALS['phpgw']->template->set_block('index', 'tts_row', 'tts_row'); $GLOBALS['phpgw']->template->set_block('index', 'tts_col_ifviewall', 'tts_col_ifviewall'); $GLOBALS['phpgw']->template->set_block('index', 'tts_head_ifviewall', 'tts_head_ifviewall'); - $GLOBALS['phpgw']->template->set_block('index', 'tts_ticket_id_read', 'tts_ticket_id_read'); - $GLOBALS['phpgw']->template->set_block('index', 'tts_ticket_id_unread', 'tts_ticket_id_unread'); +// $GLOBALS['phpgw']->template->set_block('index', 'tts_ticket_id_read', 'tts_ticket_id_read'); +// $GLOBALS['phpgw']->template->set_block('index', 'tts_ticket_id_unread', 'tts_ticket_id_unread'); $GLOBALS['phpgw']->template->set_var('lang_appname', lang('Trouble Ticket System')); $GLOBALS['phpgw']->template->set_var('tts_newticket_link', $GLOBALS['phpgw']->link('/tts/newticket.php')); @@ -53,46 +53,20 @@ $GLOBALS['phpgw']->template->set_var('tts_head_status',''); $GLOBALS['phpgw']->template->set_var('tts_notickets',''); $GLOBALS['phpgw']->template->set_var('lang_category',lang('Category')); - $GLOBALS['phpgw']->template->set_var('tts_autofilter_link', $GLOBALS['phpgw']->link('/tts/index.php')); - $GLOBALS['phpgw']->template->set_var('lang_filter', lang('filter')); - // select what tickets to view - $filter = $_REQUEST['filter']; - $start = $_GET['start']; - $sort = $_GET['sort']; - $order = $_GET['order']; - $searchfilter = $_REQUEST['searchfilter']; + $filter = $HTTP_GET_VARS['filter']; + $start = $HTTP_GET_VARS['start']; + $sort = $HTTP_GET_VARS['sort']; + $order = $HTTP_GET_VARS['order']; if (!$filter) { $filter='viewopen'; } - - if ($filter == 'viewopen' || 'search') + if ($filter == 'viewopen') { - if($_POST['ticket']['filter_prio'] != "") - { - $filterstring = " and ticket_priority like ".$_POST['ticket']['filter_prio']; - } - - if($_POST['ticket']['filter_owner'] != "") - { - $filterstring1 = " and ticket_owner like '".$GLOBALS['phpgw']->accounts->name2id($_POST['ticket']['filter_owner'])."'"; - } - - if($_POST['ticket']['filter_assignedto'] != "") - { - $filterstring2 = " and ticket_assignedto like '".$GLOBALS['phpgw']->accounts->name2id($_POST['ticket']['filter_assignedto'])."'"; - } - - if($_POST['ticket']['filter_category'] != "") - { - $filterstring3 = " and ticket_category like '" . $GLOBALS['phpgw']->categories->name2id($_POST['ticket']['filter_category']) . "'"; - } - - $filtermethod = "where ticket_status='O'" . $filterstring . $filterstring1 . $filterstring2 . $filterstring3; - + $filtermethod = "where ticket_status='O'"; $GLOBALS['phpgw']->preferences->read_repository(); if ($GLOBALS['phpgw_info']['user']['preferences']['tts']['refreshinterval']) @@ -104,36 +78,9 @@ $GLOBALS['phpgw']->template->set_var('autorefresh',''); } } - - if ($filter == 'viewall') - { - - if($_POST['ticket']['filter_prio'] != "") - { - $filterstring = " and ticket_priority like ".$_POST['ticket']['filter_prio']; - } - - if($_POST['ticket']['filter_owner'] != "") - { - $filterstring1 = " and ticket_owner like '".$GLOBALS['phpgw']->accounts->name2id($_POST['ticket']['filter_owner'])."'"; - } - - if($_POST['ticket']['filter_assignedto'] != "") - { - $filterstring2 = " and ticket_assignedto like '".$GLOBALS['phpgw']->accounts->name2id($_POST['ticket']['filter_assignedto'])."'"; - } - - if($_POST['ticket']['filter_category'] != "") - { - $filterstring3 = " and ticket_category like '" . $GLOBALS['phpgw']->categories->name2id($_POST['ticket']['filter_category']) . "'"; - } - - $filtermethod = "where 1" . $filterstring . $filterstring1 . $filterstring2 . $filterstring3; - } - - if ($searchfilter != '') + if ($filter == 'search') { - $filtermethod = "where ticket_details like '%".addslashes($searchfilter)."%' or ticket_subject like '%".addslashes($searchfilter)."%'"; + $filtermethod = "where ticket_details like '%".addslashes($searchfilter)."%'"; $GLOBALS['phpgw']->template->set_var('tts_searchfilter',addslashes($searchfilter)); } @@ -157,39 +104,14 @@ $GLOBALS['phpgw']->template->set_var('tts_numtotal',lang('Tickets total %1',$numtotal)); $GLOBALS['phpgw']->template->set_var('tts_numopen',lang('Tickets open %1',$numopen)); - //Get filters to work -/* if($filter == 'viewopen') - { - if($_POST['ticket']['filter_prio'] != "") - { - $filterstring = " and ticket_priority like ".$_POST['ticket']['filter_prio']; - } - - if($_POST['ticket']['filter_owner'] != "") - { - $filterstring1 = " and ticket_owner like '".$GLOBALS['phpgw']->accounts->name2id($_POST['ticket']['filter_owner'])."'"; - } - - if($_POST['ticket']['filter_assignedto'] != "") - { - $filterstring2 = " and ticket_assignedto like '".$GLOBALS['phpgw']->accounts->name2id($_POST['ticket']['filter_assignedto'])."'"; - } - - if($_POST['ticket']['filter_category'] != "") - { - $filterstring3 = " and ticket_category like '" . $GLOBALS['phpgw']->categories->name2id($_POST['ticket']['filter_category']) . "'"; - } - - $filtermethod = "where 1=1" . $filterstring . $filterstring1 . $filterstring2 . $filterstring3; - } -*/ $db2 = $GLOBALS['phpgw']->db; $GLOBALS['phpgw']->db->query("select * from phpgw_tts_tickets $filtermethod $sortmethod",__LINE__,__FILE__); $numfound = $GLOBALS['phpgw']->db->num_rows(); - if ($filter != '' || $filter == 'viewopen') + if ($filter == 'search') { + $filtermethod = "where ticket_details like '%".addslashes($searchfilter)."%'"; $GLOBALS['phpgw']->template->set_var('tts_searchfilter',addslashes($searchfilter)); $GLOBALS['phpgw']->template->set_var('tts_numfound',lang('Tickets found %1',$numfound)); } @@ -199,7 +121,7 @@ $GLOBALS['phpgw']->template->set_var('tts_numfound',''); } - if ($filter != 'viewopen' && $filter != 'search') + if ($filter != 'viewopen') { $GLOBALS['phpgw']->template->set_var('tts_changeview_link', $GLOBALS['phpgw']->link('/tts/index.php')); $GLOBALS['phpgw']->template->set_var('tts_changeview', lang('View only open tickets')); @@ -226,7 +148,7 @@ // I am not sure how the sorting will work for this, if at all. (jengo) $GLOBALS['phpgw']->template->set_var('tts_head_dateopened',lang('Date opened')); // $GLOBALS['phpgw']->template->set_var('tts_head_dateopened', $GLOBALS['phpgw']->nextmatchs->show_sort_order($sort,'',$order,'/tts/index.php',lang('Date opened'))); - if ($filter != 'viewopen' && $filter != 'search') + if ($filter != 'viewopen') { $GLOBALS['phpgw']->template->set_var('tts_head_dateclosed', $GLOBALS['phpgw']->nextmatchs->show_sort_order($sort,'ticket_status',$order,'/tts/index.php',lang('Status/Date closed'))); $GLOBALS['phpgw']->template->parse('tts_head_status','tts_head_ifviewall',false); @@ -245,17 +167,17 @@ $priority = $GLOBALS['phpgw']->db->f('ticket_priority'); switch ($priority) { - case 1: $tr_color = $GLOBALS['phpgw_info']['theme']['bg01']; $prio = '1'; break; - case 2: $tr_color = $GLOBALS['phpgw_info']['theme']['bg02']; $prio = '2'; break; - case 3: $tr_color = $GLOBALS['phpgw_info']['theme']['bg03']; $prio = '3'; break; - case 4: $tr_color = $GLOBALS['phpgw_info']['theme']['bg04']; $prio = '4'; break; - case 5: $tr_color = $GLOBALS['phpgw_info']['theme']['bg05']; $prio = '5'; break; - case 6: $tr_color = $GLOBALS['phpgw_info']['theme']['bg06']; $prio = '6'; break; - case 7: $tr_color = $GLOBALS['phpgw_info']['theme']['bg07']; $prio = '7'; break; - case 8: $tr_color = $GLOBALS['phpgw_info']['theme']['bg08']; $prio = '8'; break; - case 9: $tr_color = $GLOBALS['phpgw_info']['theme']['bg09']; $prio = '9'; break; - case 10: $tr_color = $GLOBALS['phpgw_info']['theme']['bg10']; $prio = '10'; break; - default: $tr_color = $GLOBALS['phpgw_info']['theme']['bg_color']; $prio = '-'; + case 1: $tr_color = $GLOBALS['phpgw_info']['theme']['bg01']; break; + case 2: $tr_color = $GLOBALS['phpgw_info']['theme']['bg02']; break; + case 3: $tr_color = $GLOBALS['phpgw_info']['theme']['bg03']; break; + case 4: $tr_color = $GLOBALS['phpgw_info']['theme']['bg04']; break; + case 5: $tr_color = $GLOBALS['phpgw_info']['theme']['bg05']; break; + case 6: $tr_color = $GLOBALS['phpgw_info']['theme']['bg06']; break; + case 7: $tr_color = $GLOBALS['phpgw_info']['theme']['bg07']; break; + case 8: $tr_color = $GLOBALS['phpgw_info']['theme']['bg08']; break; + case 9: $tr_color = $GLOBALS['phpgw_info']['theme']['bg09']; break; + case 10: $tr_color = $GLOBALS['phpgw_info']['theme']['bg10']; break; + default: $tr_color = $GLOBALS['phpgw_info']['theme']['bg_color']; } if ($filter!="viewopen" && $GLOBALS['phpgw']->db->f('t_timestamp_closed')) @@ -283,7 +205,7 @@ if (! $ticket_read) { - $GLOBALS['phpgw']->template->set_var('row_status',''); + $GLOBALS['phpgw']->template->set_var('row_status',''); } else { @@ -291,13 +213,12 @@ } $priostr = ''; - while ($priority > 0) { $priostr = $priostr . "||"; $priority--; } - $GLOBALS['phpgw']->template->set_var('tts_t_priostr',$priostr); + $GLOBALS['phpgw']->template->set_var('tts_t_priostr',$priostr ); $cat_name = $GLOBALS['phpgw']->categories->id2name($GLOBALS['phpgw']->db->f('ticket_category')); $GLOBALS['phpgw']->template->set_var('row_category',$cat_name); @@ -318,7 +239,7 @@ $GLOBALS['phpgw']->template->set_var('tts_t_timestampclosed',$GLOBALS['phpgw']->common->show_date($history_values[0]['datetime'] - ((60*60) * $GLOBALS['phpgw_info']['user']['preferences']['common']['tz_offset']))); $GLOBALS['phpgw']->template->parse('tts_col_status','tts_col_ifviewall',False); } - elseif ($filter != 'viewopen' && $filter != 'search') + elseif ($filter != 'viewopen') { // if ($GLOBALS['phpgw']->db->f('ticket_assignedto') != -1) // { @@ -333,7 +254,6 @@ $GLOBALS['phpgw']->template->parse('tts_col_status','tts_col_ifviewall',False); } $GLOBALS['phpgw']->template->set_var('tts_t_subject', $GLOBALS['phpgw']->db->f('ticket_subject')); - $GLOBALS['phpgw']->template->set_var('tts_t_prio', $prio); $GLOBALS['phpgw']->template->parse('rows','tts_row',True); } @@ -346,120 +266,6 @@ $GLOBALS['phpgw']->template->set_var('tts_ticket_id_read',''); $GLOBALS['phpgw']->template->set_var('tts_ticket_id_unread',''); - //Create Autofilters - $GLOBALS['phpgw']->db->query("select count(*) from phpgw_tts_tickets"); - $GLOBALS['phpgw']->db->next_record(); - $exists = $GLOBALS['phpgw']->db->f('0'); - if ($exists != 0) - { - $GLOBALS['phpgw']->db->query("select distinct ticket_priority from phpgw_tts_tickets order by ticket_priority desc"); - $y=0; - while ($GLOBALS['phpgw']->db->next_record() != 0) - { - $dbvalue[$y] = $GLOBALS['phpgw']->db->f('0') ; - ++$y; - } - - unset($sel); - for($y-=1;$y>=0;--$y) - { - if($dbvalue[$y] == $_POST['ticket']['filter_prio']) - { - $selected = " selected"; - } - else - { - $selected = ""; - } - $sel .= '' ; - } - $GLOBALS['phpgw']->template->set_var('filter_prio',''); - - - $GLOBALS['phpgw']->db->query("select distinct ticket_owner from phpgw_tts_tickets order by ticket_owner desc"); - $y=0; - while ($GLOBALS['phpgw']->db->next_record() != 0) - { - $dbvalue[$y] = $GLOBALS['phpgw']->db->f('0') ; - $db2name[$y] = $GLOBALS['phpgw']->accounts->id2name($dbvalue[$y]); - ++$y; - } - - unset($sel); - natsort($db2name); - reset($db2name); - while(list($dummy,$entry) = each($db2name)) - { - if($entry == $_POST['ticket']['filter_owner']) - { - $selected = " selected"; - } - else - { - $selected = ""; - } - $sel .= '' ; - } - $GLOBALS['phpgw']->template->set_var('filter_owner',''); - - - $GLOBALS['phpgw']->db->query("select distinct ticket_assignedto from phpgw_tts_tickets order by ticket_assignedto desc"); - $y=0; - while ($GLOBALS['phpgw']->db->next_record() != 0) - { - $dbvalue[$y] = $GLOBALS['phpgw']->db->f('0') ; - $db2name[$y] = $GLOBALS['phpgw']->accounts->id2name($dbvalue[$y]); - ++$y; - } - - unset($sel); - natsort($db2name); - reset($db2name); - while(list($dummy,$entry) = each($db2name)) - { - if($entry == $_POST['ticket']['filter_assignedto']) - { - $selected = " selected"; - } - else - { - $selected = ""; - } - $sel .= '' ; - } - - $GLOBALS['phpgw']->template->set_var('filter_assignedto',''); - - - $GLOBALS['phpgw']->db->query("select distinct ticket_category from phpgw_tts_tickets order by ticket_category"); - $y=0; - unset($db2name); - while ($GLOBALS['phpgw']->db->next_record() != 0) - { - $dbvalue[$y] = $GLOBALS['phpgw']->db->f('0'); - $db2name[$y] = $GLOBALS['phpgw']->categories->id2name($dbvalue[$y]); - ++$y; - } - - unset($sel); - natsort($db2name); - reset($db2name); - while(list($dummy,$entry) = each($db2name)) - { - if($entry == $_POST['ticket']['filter_category']) - { - $selected = " selected"; - } - else - { - $selected = ""; - } - $sel .= '' ; - } - - $GLOBALS['phpgw']->template->set_var('filter_category',''); - } - $GLOBALS['phpgw']->template->pfp('out','index'); $GLOBALS['phpgw']->common->phpgw_footer(); diff -aburN --exclude='CVS*' phpgroupware16/tts/lang.sql phpgroupware/tts/lang.sql --- phpgroupware16/tts/lang.sql 1969-12-31 19:00:00.000000000 -0500 +++ phpgroupware/tts/lang.sql 2003-12-22 10:38:49.000000000 -0500 @@ -0,0 +1,257 @@ +DELETE FROM lang WHERE app_name='tts'; +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'additional notes','tts','br','Notas adicionais'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'additional notes','tts','cs','Dal poznmky'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'additional notes','tts','de','Zusätzliche Notizen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'additional notes','tts','en','Additional notes'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'additional notes','tts','fr','Notes supplémentaires'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'additional notes','tts','kr',' ߰'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'additional notes','tts','nl','Opmerkingen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'additional notes','tts','sp','Notas adicionales'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add new ticket','tts','br','Adicionar novo ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add new ticket','tts','cs','Pidej novou zprvu'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add new ticket','tts','de','Neues Ticket hinzufügen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add new ticket','tts','en','Add new ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add new ticket','tts','fr','Ajouter un nouveau ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add new ticket','tts','kr',' ۾߰'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add new ticket','tts','nl','Voeg nieuwe melding toe'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add new ticket','tts','sp','Agregar nuevo ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add ticket','tts','br','Criar ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add ticket','tts','cs','Pidat zprvu'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add ticket','tts','de','Ticket hinzufügen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add ticket','tts','en','Add ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add ticket','tts','fr','Ajouter un ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add ticket','tts','kr','۾ ߰'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add ticket','tts','nl','Voeg melding toe'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'add ticket','tts','sp','Agregar ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned from','tts','br','Atribuido de'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned from','tts','cs','Zadal'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned from','tts','de','Zugewiesen von'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned from','tts','en','Assigned from'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned from','tts','fr','Assigné par'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned from','tts','kr','۾'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned from','tts','nl','Toegewezen door'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned from','tts','sp','Asignado desde'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned to','tts','br','Atribuido a'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned to','tts','cs','Piazeno k'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned to','tts','de','Zugewiesen an'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned to','tts','en','Assigned to'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned to','tts','fr','Assigné à'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned to','tts','kr','Ҵ'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned to','tts','nl','Toegewezen aan'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assigned to','tts','sp','Asignado a'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assign to','tts','cs','Piadit k'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assign to','tts','de','Zuweisen an'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assign to','tts','en','Assign to'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assign to','tts','nl','Toewijzen aan'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'assign to','tts','sp','Asignar a'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'clear form','tts','br','Limpar formulario'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'clear form','tts','cs','Smazat formul'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'clear form','tts','de','Eingabe löschen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'clear form','tts','en','Clear form'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'clear form','tts','fr','Effacer le formulaire'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'clear form','tts','kr','ۼ'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'clear form','tts','nl','Formulier wissen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'clear form','tts','sp','Limpiar formulario'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close date','tts','br','Data fechamento'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close date','tts','cs','Datum uzaven'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close date','tts','de','Geschlossen am'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close date','tts','en','Close date'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close date','tts','fr','Date de fermeture'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close date','tts','kr',' ¥'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close date','tts','nl','Datum sluiting'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close date','tts','sp','Fecha cierre'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'closed','tts','br','Fechado'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'closed','tts','cs','Uzaven'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'closed','tts','de','Geschlossen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'closed','tts','en','Closed'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'closed','tts','fr','Fermé'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'closed','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'closed','tts','nl','Gesloten'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'closed','tts','sp','Cerrado'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close','tts','br','Feche'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close','tts','cs','Zavt'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close','tts','de','Schließen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close','tts','en','Close'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close','tts','fr','Fermer'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close','tts','nl','Sluiten'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'close','tts','sp','Cerrar'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'date opened','tts','br','Data abertura'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'date opened','tts','cs','Datum oteven'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'date opened','tts','de','Angelegt am'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'date opened','tts','en','Date opened'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'date opened','tts','fr','Date d\'ouverture'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'date opened','tts','kr','ۼ'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'date opened','tts','nl','Aanmaak datum'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'date opened','tts','sp','Fecha apertura'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'details','tts','br','Detalhes'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'details','tts','cs','Detaily'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'details','tts','de','Details'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'details','tts','en','Details'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'details','tts','fr','Détails'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'details','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'details','tts','nl','Details'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'details','tts','sp','Detalles'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'detail','tts','br','Detalhes'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'detail','tts','cs','Detail'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'detail','tts','de','Detail'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'detail','tts','en','Detail'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'detail','tts','fr','Détail'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'detail','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'detail','tts','nl','Detail'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'detail','tts','sp','Detalle'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'group','tts','br','Grupo'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'group','tts','cs','Skupina'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'group','tts','de','Gruppe'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'group','tts','en','Group'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'group','tts','fr','Groupe'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'group','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'group','tts','nl','Groep'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'group','tts','sp','Groupo'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'in progress','tts','br','Em progresso'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'in progress','tts','cs','Probh'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'in progress','tts','de','In Bearbeitung'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'in progress','tts','en','In progress'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'in progress','tts','fr','En cours'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'in progress','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'in progress','tts','nl','In uitvoering'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'in progress','tts','sp','En progreso'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'new ticket','tts','br','Novo ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'new ticket','tts','cs','Nov zprva'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'new ticket','tts','de','Neues Ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'new ticket','tts','en','New ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'new ticket','tts','fr','Nouveau ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'new ticket','tts','kr',' ۾'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'new ticket','tts','nl','Nieuwe melding'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'new ticket','tts','sp','Nuevo ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no subject','tts','br','Sem assunto'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no subject','tts','cs','dn pedmt'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no subject','tts','de','Kein Betreff'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no subject','tts','en','No subject'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no subject','tts','fr','Pas de sujet'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no subject','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no subject','tts','nl','Geen onderwerp'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no subject','tts','sp','Sin asunto'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no tickets found','tts','br','Nao foram encontrados tickets'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no tickets found','tts','cs','dn zprvy nenalezeny'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no tickets found','tts','de','Keine Tickets gefunden'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no tickets found','tts','en','No tickets found'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no tickets found','tts','fr','Aucun ticket trouvé'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no tickets found','tts','kr','۾ '); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no tickets found','tts','nl','Geen meldingen gevonden'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'no tickets found','tts','sp','No se encontraron tickets'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ok','tts','br','OK'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ok','tts','cs','OK'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ok','tts','de','OK'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ok','tts','en','OK'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ok','tts','fr','OK'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ok','tts','kr','Ȯ'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ok','tts','nl','OK'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ok','tts','sp','OK'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'open date','tts','br','Data abertura'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'open date','tts','cs','Datum oteven'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'open date','tts','de','Angelegt am'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'open date','tts','en','Open date'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'open date','tts','fr','Date d\'ouverture'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'open date','tts','kr',' ¥'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'open date','tts','nl','Datum opening'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'open date','tts','sp','Fecha apertura'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'opened by','tts','br','Aberto por'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'opened by','tts','cs','Otevel'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'opened by','tts','de','Angelegt von'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'opened by','tts','en','Opened by'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'opened by','tts','fr','Ouvert par'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'opened by','tts','kr','ۼ'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'opened by','tts','nl','Aangenomen door'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'opened by','tts','sp','Abierto por'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'priority','tts','br','Prioridade'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'priority','tts','cs','Priorita'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'priority','tts','de','Priorität'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'priority','tts','en','Priority'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'priority','tts','fr','Priorité'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'priority','tts','kr','߿䵵'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'priority','tts','nl','Prioriteit'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'priority','tts','sp','Prioridad'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'prio','tts','br','Prio'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'prio','tts','cs','Prio'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'prio','tts','de','Prio'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'prio','tts','en','Prio'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'prio','tts','fr','Prio'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'prio','tts','kr','߿䵵'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'prio','tts','nl','Prio'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'prio','tts','sp','Prioridad'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'reopen','tts','br','Reaberto'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'reopen','tts','cs','Znovu oteven'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'reopen','tts','de','Wieder öffnen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'reopen','tts','en','ReOpen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'reopen','tts','fr','ReOuvert'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'reopen','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'reopen','tts','nl','Heropenen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'reopen','tts','sp','ReAbierto'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'status/date closed','tts','br','Estado/Data fechado'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'status/date closed','tts','cs','Stav/Datum closed'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'status/date closed','tts','de','Status/Schließdatum'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'status/date closed','tts','en','Status/Date closed'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'status/date closed','tts','fr','Etat/Date de fermeture'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'status/date closed','tts','kr','Ȱ /¥'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'status/date closed','tts','nl','Status/Datum gesloten'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'status/date closed','tts','sp','Estado/Fecha cierre'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'subject','tts','br','Assunto'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'subject','tts','cs','Pedmt'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'subject','tts','de','Betreff'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'subject','tts','en','Subject'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'subject','tts','fr','Sujet'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'subject','tts','kr',''); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'subject','tts','nl','Onderwerp'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'subject','tts','sp','Asunto'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket assigned to x','tts','en','Ticket assigned to %1'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'tickets open x','tts','en','Tickets open %1'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'tickets total x','tts','en','Tickets total %1'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket','tts','br','Ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket','tts','cs','Zprva'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket','tts','de','Ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket','tts','en','Ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket','tts','fr','Ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket','tts','kr','۾'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket','tts','nl','Melding'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'ticket','tts','sp','Ticket'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket system','tts','br','Trouble Ticket System'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket system','tts','cs','Sledovn problm'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket system','tts','de','Trouble Ticket System'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket system','tts','en','Trouble Ticket System'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket system','tts','fr','Trouble Ticket System'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket system','tts','kr','Ʈ ý'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket system','tts','nl','Problemen Registratie Systeem'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket system','tts','sp','Trouble Ticket System'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'update','tts','br','Atualize'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'update','tts','cs','Obnovit'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'update','tts','de','Aktualisieren'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'update','tts','en','Update'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'update','tts','fr','Mettre à jour'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'update','tts','kr','Ʈ'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'update','tts','nl','Bijwerken'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'update','tts','sp','Actualizar'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view all tickets','tts','br','Visualizar todos tickets'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view all tickets','tts','cs','Uka vechny'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view all tickets','tts','de','Alle Tickets anzeigen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view all tickets','tts','en','View all tickets'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view all tickets','tts','fr','Voir tous les tickets'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view all tickets','tts','kr',' ۾'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view all tickets','tts','nl','Geef alle meldingen weer'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view all tickets','tts','sp','Ver todos los tickets'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view job detail','tts','br','Ver detalhes'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view job detail','tts','cs','ukzat detail kolu'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view job detail','tts','de','Details anzeigen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view job detail','tts','en','view job detail'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view job detail','tts','fr','voir le détail du travail'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view job detail','tts','kr','۾ 뺸'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view job detail','tts','nl','Details werkzaamheden weergeven'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view job detail','tts','sp','ver detalle del trabajo'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view only open tickets','tts','br','Ver todos tickets abertos'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view only open tickets','tts','cs','Uka jenom oteven zprvy'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view only open tickets','tts','de','Nur offene Tickets anzeigen'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view only open tickets','tts','en','View only open tickets'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view only open tickets','tts','fr','Voir uniquement les tickets ouverts'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view only open tickets','tts','kr','Ȱ ۾'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view only open tickets','tts','nl','Geef alleen openstaande meldingen weer'); +INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'view only open tickets','tts','sp','Ver solo los tickets abiertos'); diff -aburN --exclude='CVS*' phpgroupware16/tts/newticket.php phpgroupware/tts/newticket.php --- phpgroupware16/tts/newticket.php 2004-05-03 21:37:39.000000000 -0400 +++ phpgroupware/tts/newticket.php 2003-12-22 10:38:49.000000000 -0500 @@ -9,11 +9,11 @@ * option) any later version. * \**************************************************************************/ - // $Id: newticket.php,v 1.31.2.3.4.4 2004/04/20 12:52:17 lpiepho Exp $ + // $Id: newticket.php,v 1.31.2.3 2002/05/17 12:59:17 milosch Exp $ // $Source: /cvsroot/phpgroupware/tts/newticket.php,v $ - $submit = $_POST['submit']; - $cancel = $_POST['cancel']; + $submit = $HTTP_POST_VARS['submit']; + $cancel = $HTTP_POST_VARS['cancel']; if($submit || $cancel) { $GLOBALS['phpgw_info']['flags'] = array( @@ -26,7 +26,6 @@ $GLOBALS['phpgw_info']['flags']['enable_send_class'] = True; $GLOBALS['phpgw_info']['flags']['enable_config_class'] = True; $GLOBALS['phpgw_info']['flags']['enable_categories_class'] = True; - $GLOBALS['phpgw_info']['flags']['enable_vfs_class'] = True; include('../header.inc.php'); @@ -39,61 +38,17 @@ if($submit) { - //File-Upload - if ($HTTP_POST_FILES['attachment']['name'] != '') - { - $basedir = $GLOBALS['basedir'] . "/tts"; - //Check if home/groupdirectory exists. If not, we create it - if (!file_exists($basedir)) - { - $GLOBALS['phpgw']->vfs->override_acl = 1; - $GLOBALS['phpgw']->vfs->mkdir (array ( - 'string' => $basedir, - 'relatives' => array (RELATIVE_ALL))); - $GLOBALS['phpgw']->vfs->override_acl = 0; - } - - $GLOBALS['phpgw']->db->query("SELECT max(ticket_id) from phpgw_tts_tickets",__LINE__,__FILE__); - $GLOBALS['phpgw']->db->next_record(); - $tid = ($GLOBALS['phpgw']->db->f('max(ticket_id)')) + 1; - - //$tid = $ticket_id = $phpgw->db->get_last_insert_id('phpgw_tts_tickets','ticket_id'); - $attdir = $basedir . "/" . $tid; - - $GLOBALS['phpgw']->vfs->override_acl = 1; - $GLOBALS['phpgw']->vfs->mkdir (array ( - 'string' => $attdir, - 'relatives' => array (RELATIVE_ALL))); - $GLOBALS['phpgw']->vfs->override_acl = 0; - - $GLOBALS['phpgw']->vfs->override_acl = 1; - $GLOBALS['phpgw']->vfs->cp(array ( - 'from' => $HTTP_POST_FILES['attachment']['tmp_name'], - 'to' => $attdir . '/' . $HTTP_POST_FILES['attachment']['name'], - 'relatives' => array (RELATIVE_NONE|VFS_REAL, RELATIVE_ALL))); - $GLOBALS['phpgw']->vfs->override_acl = 0; - - $GLOBALS['phpgw']->db->query("SELECT max(file_id) from phpgw_vfs",__LINE__,__FILE__); - $GLOBALS['phpgw']->db->next_record(); - $file_id = $GLOBALS['phpgw']->db->f('max(file_id)'); - } - $GLOBALS['phpgw']->db->query("insert into phpgw_tts_tickets (ticket_group,ticket_priority,ticket_owner," . "ticket_assignedto,ticket_subject,ticket_category,ticket_billable_hours," - . "ticket_billable_rate,ticket_status,ticket_deadline,ticket_effort,ticket_type,ticket_platform,ticket_attachment,ticket_details) values ('" - . $_POST['ticket']['group'] . "','" - . $_POST['ticket']['priority'] . "','" + . "ticket_billable_rate,ticket_status,ticket_details) values ('" + . $ticket['group'] . "','" + . $ticket['priority'] . "','" . $GLOBALS['phpgw_info']['user']['account_id'] . "','" - . $_POST['ticket']['assignedto'] . "','" - . $_POST['ticket']['subject'] . "','" - . $_POST['ticket']['category'] . "','" - . $_POST['ticket']['billable_hours'] . "','" - . $_POST['ticket']['billable_rate'] . "','O','" - . $_POST['ticket']['deadline']['year'] . "-" . $_POST['ticket']['deadline']['month'] . "-" . $_POST['ticket']['deadline']['day'] . "','" - . $_POST['ticket']['effort'] . "','" - . ($_POST['ticket']['type'] ? $_POST['ticket']['type'] : 0) . "','" - . ($_POST['ticket']['platform'] ? $_POST['ticket']['platform'] : 0) . "','" - . ($file_id ? $file_id : 0). "','" + . $ticket['assignedto'] . "','" + . $ticket['subject'] . "','" + . $ticket['category'] . "','" + . $ticket['billable_hours'] . "','" + . $ticket['billable_rate'] . "','O','" . addslashes($ticket['details']) . "')",__LINE__,__FILE__); $ticket_id = $GLOBALS['phpgw']->db->get_last_insert_id('phpgw_tts_tickets','ticket_id'); @@ -117,8 +72,6 @@ if(!$submit) { $GLOBALS['phpgw']->preferences->read_repository(); - - /* if($GLOBALS['phpgw_info']['user']['preferences']['tts']['groupdefault']) { $entry_selected[$GLOBALS['phpgw_info']['user']['preferences']['tts']['groupdefault']] = ' selected'; @@ -133,7 +86,7 @@ { $priority_selected[$GLOBALS['phpgw_info']['user']['preferences']['tts']['prioritydefault']] = ' selected'; } - */ + $GLOBALS['phpgw']->template->set_file(array( 'newticket' => 'newticket.tpl' )); @@ -169,13 +122,6 @@ $GLOBALS['phpgw']->template->set_var('value_subject',$ticket['details']); $GLOBALS['phpgw']->template->set_var('value_billable_hours',($ticket['billable_hours']?$ticket['billable_hours']:'0.00')); $GLOBALS['phpgw']->template->set_var('value_billable_hours_rate',($ticket['billable_rate']?$ticket['billable_rate']:'0.00')); - $GLOBALS['phpgw']->template->set_var('currency',$GLOBALS['phpgw_info']['user']['preferences']['common']['currency']); - - $GLOBALS['phpgw']->template->set_var('lang_type',lang('Type')); - $GLOBALS['phpgw']->template->set_var('lang_deadline',lang('Deadline')); - $GLOBALS['phpgw']->template->set_var('lang_effort',lang('Effort')); - $GLOBALS['phpgw']->template->set_var('lang_platform',lang('Platform')); - $GLOBALS['phpgw']->template->set_var('lang_attachment',lang('Attachment')); unset($s); $groups = CreateObject('phpgwapi.accounts'); @@ -184,71 +130,26 @@ while(list($key,$entry) = each($group_list)) { - if($GLOBALS['phpgw_info']['user']['preferences']['tts']['groupdefault'] == $entry['account_id']) - { - $selected = 'selected'; - } - else - { - $selected = ''; - } - $s .= ''; + $GLOBALS['phpgw']->template->set_var('optionname', $entry['account_name']); + $GLOBALS['phpgw']->template->set_var('optionvalue', $entry['account_id']); + $GLOBALS['phpgw']->template->set_var('optionselected', $tag); + $GLOBALS['phpgw']->template->parse('options_group','options_select',true); } - $GLOBALS['phpgw']->template->set_var('options_group',$s); - $s = ''; + $s = ''; $GLOBALS['phpgw']->template->set_var('value_category',$s); unset($s); - for($i=1; $i<=31; $i++) - { - $i < 10 ? $y = '0' . $i : $y = $i; - $s .= ''; - } - $GLOBALS['phpgw']->template->set_var('option_day',''); - - unset($s); - for($i=1; $i<=12; $i++) - { - $i < 10 ? $y = '0' . $i : $y = $i; - $s .= ''; - } - $GLOBALS['phpgw']->template->set_var('option_month',''); - - unset($s); $accounts = $groups; $accounts->account_id = $group_id; $account_list = $accounts->get_list('accounts'); while(list($key,$entry) = each($account_list)) { - if($GLOBALS['phpgw_info']['user']['preferences']['tts']['assigntodefault'] == $entry['account_id']) - { - $account_selected = 'selected'; - } - else - { - $account_selected = ''; - } - $s .= ''; } $GLOBALS['phpgw']->template->set_var('value_assignedto',''); - //auswahlfelder type und platform - - - $platform = CreateObject('tts.subcategories',$GLOBALS['phpgw_info']['user']['account_id'],'tts'); - unset($s); - $s = ''; - $GLOBALS['phpgw']->template->set_var('value_platform',$s); - - - $type = CreateObject('tts.subcategories',$GLOBALS['phpgw_info']['user']['account_id'],'tts'); - unset($s); - $s = ''; - $GLOBALS['phpgw']->template->set_var('value_type',$s); - //$GLOBALS['phpgw']->template->set_var('tts_account_lid','0'); //$GLOBALS['phpgw']->template->set_var('tts_account_name',lang('None')); @@ -259,15 +160,7 @@ $priority_comment[10] = ' - '.lang('Highest'); for($i=1; $i<=10; $i++) { - if($GLOBALS['phpgw_info']['user']['preferences']['tts']['prioritydefault'] == $i) - { - $prio_selected = 'selected'; - } - else - { - $prio_selected = ''; - } - $priority_select .= ''; + $priority_select .= ''; } $GLOBALS['phpgw']->template->set_var('value_priority',''); diff -aburN --exclude='CVS*' phpgroupware16/tts/preferences.php phpgroupware/tts/preferences.php --- phpgroupware16/tts/preferences.php 1969-12-31 19:00:00.000000000 -0500 +++ phpgroupware/tts/preferences.php 2003-12-22 10:38:49.000000000 -0500 @@ -0,0 +1,182 @@ + 'tts', + 'noheader' => True, + 'nonavbar' => True, + 'noappheader' => True, + 'noappfooter' => True, + 'enable_contacts_class' => True, + 'enable_nextmatchs_class' => True + ); + + include('../header.inc.php'); + + $account_selected = array(); + $entry_selected = array(); + $priority_selected = array(); + + $phpgw->preferences->read_repository(); + + if ($submit) + { + $totalerrors = 0; + if (! $totalerrors) + { + + if ($mainscreen_show_new_updated) + { + $phpgw->preferences->delete('tts','mainscreen_show_new_updated'); + $phpgw->preferences->add('tts','mainscreen_show_new_updated'); + } + else + { + $phpgw->preferences->delete('tts','mainscreen_show_new_updated'); + } + + if ($groupdefault) + { + $phpgw->preferences->delete('tts','groupdefault'); + $phpgw->preferences->add('tts','groupdefault',$groupdefault); + } + else + { + $phpgw->preferences->delete('tts','groupdefault'); + } + + if ($assigntodefault) + { + $phpgw->preferences->delete('tts','assigntodefault'); + $phpgw->preferences->add('tts','assigntodefault',$assigntodefault); + } + else + { + $phpgw->preferences->delete('tts','assigntodefault'); + } + + if ($prioritydefault) + { + $phpgw->preferences->delete('tts','prioritydefault'); + $phpgw->preferences->add('tts','prioritydefault',$prioritydefault); + } + else + { + $phpgw->preferences->delete('tts','prioritydefault'); + } + + if ($refreshinterval) + { + $phpgw->preferences->delete('tts','refreshinterval'); + $phpgw->preferences->add('tts','refreshinterval',$refreshinterval); + } + else + { + $phpgw->preferences->delete('tts','refreshinterval'); + } + + $phpgw->preferences->save_repository(True); + Header('Location: ' . $phpgw->link('/preferences/index.php')); + } + } + + $phpgw->common->phpgw_header(); + echo parse_navbar(); + + if ($totalerrors) + { + echo '
+ {messages} -
+ | |||||
{lang_assignedto}: | {value_assignedto} | -{lang_category}: | -{value_category} | +{lang_billable_hours}: | +|
{lang_priority}: | {value_priority} | -{lang_effort}: | -+ | {lang_billable_hours_rate}: | +|
{lang_group}: | - | {lang_billable_hours}: {currency} | -+ | {lang_category}: | +{value_category} |
- | - - - | ||||
{lang_deadline}: | -. {option_month} . {option_day} | -{lang_billable_hours_rate}: {currency} | -- | ||
- | {lang_attachment} | -- | |||
{lang_subject}: | |||||
- {lang_details}: - - |
+
+ |||||
{lang_subject}: | |||||
+ | |||||
+ | |||||
{lang_details}: |
+ |||||
+ | - | + | + |
{lang_ttsprefs}:
+ +
{lang_show_new_updated} | ++ | |||
{lang_defaultgroup} | ++ + | +|||
{lang_defaultassignto} | ++ + | +|||
{lang_defaultpriority} | ++ + | +|||
{lang_refreshinterval} | ++ + | +|||
+ + | +