[Phpgroupware-cvs] tts index.php,1.51

[fipsfuchs]

Update of tts

Modified Files:
     Branch: MAIN
            index.php lines: +27 -49

Log Message:
adodb fixes

====================================================
Index: tts/index.php
diff -u tts/index.php:1.50 tts/index.php:1.51
--- tts/index.php:1.50  Tue Dec 14 21:47:20 2004
+++ tts/index.php       Tue Jan 11 14:59:43 2005
@@ -160,16 +160,25 @@
        }
        $GLOBALS['phpgw']->template->set_var('tts_head_subject', 
$GLOBALS['phpgw']->nextmatchs->show_sort_order($sort,'ticket_subject',$order,'/tts/index.php',lang('Subject')));

-       if ($GLOBALS['phpgw']->db->num_rows() == 0)
+       // read the tickets
+       $sql = 'SELECT * FROM phpgw_tts_tickets '.
+              'LEFT JOIN phpgw_tts_views ON (phpgw_tts_tickets.ticket_id = 
phpgw_tts_views.view_id AND phpgw_tts_views.view_account_id = 
'.$GLOBALS['phpgw_info']['user']['account_id'].') '.
+              'WHERE '.$filterstring.$sortmethod;
+       //echo $sql;
+       $rs = $GLOBALS['phpgw']->db->adodb->Execute($sql);
+       $alltickets = $rs->GetArray();
+
+       $GLOBALS['phpgw']->template->set_var('tts_numfound',lang('Tickets found 
%1',count($alltickets)));
+
+       if (!count($alltickets))
        {
                $GLOBALS['phpgw']->template->set_var('rows', 
'<p><center>'.lang('No tickets found').'</center>');
        }
        else
        {
-               while ($GLOBALS['phpgw']->db->next_record())
+               for($i = 0; $i < count($alltickets); $i++)
                {
-                       $priority = $GLOBALS['phpgw']->db->f('ticket_priority');
-                       switch ($priority)
+                       switch ($alltickets[$i]['ticket_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;
@@ -183,8 +192,7 @@
                                case 10: $tr_color = 
$GLOBALS['phpgw_info']['theme']['bg10']; $prio = '10'; break;
                                default: $tr_color = 
$GLOBALS['phpgw_info']['theme']['bg_color']; $prio = '-';
                        }
-
-                       if ($filter!="viewopen" && 
$GLOBALS['phpgw']->db->f('t_timestamp_closed'))
+                       if ($filter != 'viewopen' && 
$alltickets[$i]['t_timestamp_closed'])
                        {
                                $tr_color = 
$GLOBALS['phpgw_info']['theme']['th_bg']; /*"#CCCCCC";*/
                        }
@@ -193,75 +201,45 @@
                                . "' and view_account_id='" . 
$GLOBALS['phpgw_info']['user']['account_id'] . "'",__LINE__,__FILE__);
                        $db2->next_record();

-                       if ($db2->f(0))
+                       if (!$alltickets[$i]['view_time'])
                        {
-                               $ticket_read = True;
+                               
$GLOBALS['phpgw']->template->set_var('row_status','&nbsp;');
                        }
                        else
                        {
-                               $ticket_read = False;
-                       }
-
-                       $GLOBALS['phpgw']->template->set_var('tts_row_color', 
$tr_color );
-                       
$GLOBALS['phpgw']->template->set_var('tts_ticketdetails_link', 
$GLOBALS['phpgw']->link('/tts/viewticket_details.php','ticket_id=' . 
$GLOBALS['phpgw']->db->f('ticket_id')));
-
-                       $GLOBALS['phpgw']->template->set_var('row_ticket_id', 
$GLOBALS['phpgw']->db->f('ticket_id'));
-                       $GLOBALS['phpgw']->template->set_var('ticket_link', 
$GLOBALS['phpgw']->link('/tts/viewticket_details.php','ticket_id=' . 
$GLOBALS['phpgw']->db->f('ticket_id')));
-
-                       if (! $ticket_read)
-                       {
                                
$GLOBALS['phpgw']->template->set_var('row_status','<img 
src="'.$GLOBALS['phpgw']->common->image('tts','updated').'">');
                        }
-                       else
-                       {
-                               
$GLOBALS['phpgw']->template->set_var('row_status','&nbsp;');
-                       }
-
-                       $priostr = '';

-                       while ($priority > 0)
-                       {
-                               $priostr = $priostr . "||";
-                               $priority--;
-                       }
-                       
$GLOBALS['phpgw']->template->set_var('tts_t_priostr',$priostr);
+                       $GLOBALS['phpgw']->template->set_var('row_ticket_id', 
$alltickets[$i]['ticket_id']);
+                       $GLOBALS['phpgw']->template->set_var('ticket_link',   
$GLOBALS['phpgw']->link('/tts/viewticket_details.php','ticket_id=' . 
$alltickets[$i]['ticket_id']));

-                       $cat_name   = 
$GLOBALS['phpgw']->categories->id2name($GLOBALS['phpgw']->db->f('ticket_category'));
+                       $cat_name = 
$GLOBALS['phpgw']->categories->id2name($alltickets[$i]['ticket_category']);
                        
$GLOBALS['phpgw']->template->set_var('row_category',$cat_name);

-                       $group_name = 
$GLOBALS['phpgw']->accounts->id2name($GLOBALS['phpgw']->db->f('ticket_group'));
+                       $group_name = 
$GLOBALS['phpgw']->accounts->id2name($alltickets[$i]['ticket_group']);
                        $group_name = ($group_name ? $group_name : '--');
                        
$GLOBALS['phpgw']->template->set_var('row_group',$group_name);

-                       
$GLOBALS['phpgw']->template->set_var('tts_t_assignedto', 
$GLOBALS['phpgw']->db->f('ticket_assignedto')?$GLOBALS['phpgw']->accounts->id2name($GLOBALS['phpgw']->db->f('ticket_assignedto')):lang('None'));
-                       
$GLOBALS['phpgw']->template->set_var('tts_t_user',$GLOBALS['phpgw']->accounts->id2name($GLOBALS['phpgw']->db->f('ticket_owner')));
+                       
$GLOBALS['phpgw']->template->set_var('tts_t_assignedto', 
$alltickets[$i]['ticket_assignedto'] ? 
$GLOBALS['phpgw']->accounts->id2name($alltickets[$i]['ticket_assignedto']) : 
lang('None'));
+                       $GLOBALS['phpgw']->template->set_var('tts_t_user', 
$GLOBALS['phpgw']->accounts->id2name($alltickets[$i]['ticket_owner']));

-                       $history_values = 
$GLOBALS['phpgw']->historylog->return_array(array(),array('O'),'history_timestamp','ASC',$GLOBALS['phpgw']->db->f('ticket_id'));
+                       $history_values = 
$GLOBALS['phpgw']->historylog->return_array(array(),array('O'),'history_timestamp','ASC',$alltickets[$i]['ticket_id']);
                        
$GLOBALS['phpgw']->template->set_var('tts_t_timestampopened',$GLOBALS['phpgw']->common->show_date($history_values[0]['datetime']
 - ((60*60) * 
$GLOBALS['phpgw_info']['user']['preferences']['common']['tz_offset']),
                                                                                
                                          
$GLOBALS['phpgw_info']['user']['preferences']['common']['dateformat']
                                                                                
                                         ));

-                       if ($GLOBALS['phpgw']->db->f('ticket_status') == 'X')
+                       if ($alltickets[$i]['ticket_status'] == 'X')
                        {
-                               $history_values = 
$GLOBALS['phpgw']->historylog->return_array(array(),array('X'),'history_timestamp','DESC',$GLOBALS['phpgw']->db->f('ticket_id'));
+                               $history_values = 
$GLOBALS['phpgw']->historylog->return_array(array(),array('X'),'history_timestamp','DESC',$alltickets[$i]['ticket_id']);
                                
$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_info']['user']['preferences']['common']['dateformat']
                                                                                
                                                 ));
                        }
                        elseif ($filter != 'viewopen' && $filter != 'search')
                        {
-//                             if 
($GLOBALS['phpgw']->db->f('ticket_assignedto') != -1)
-//                             {
-//                                     $assigned_to = lang('Not assigned');
-//                             }
-//                             else
-//                             {
-//                                     $assigned_to = 
$GLOBALS['phpgw']->accounts->id2name($GLOBALS['phpgw']->db->f('ticket_assignedto'));
-//                             }
-//                             
$GLOBALS['phpgw']->template->set_var('tts_t_timestampclosed',$assigned_to);
                                
$GLOBALS['phpgw']->template->set_var('tts_t_timestampclosed',lang('Open'));
                        }
-                       $GLOBALS['phpgw']->template->set_var('tts_t_subject', 
htmlspecialchars(stripslashes($GLOBALS['phpgw']->db->f('ticket_subject'))));
+                       $GLOBALS['phpgw']->template->set_var('tts_t_subject', 
htmlspecialchars(stripslashes($alltickets[$i]['ticket_subject'])));
                        $GLOBALS['phpgw']->template->set_var('tts_t_prio', 
$prio);

                        
$GLOBALS['phpgw']->template->parse('rows','tts_row',True);