[Phpgroupware-cvs] projects/inc/class.soconfig.inc.php, 1.14

[nomail]

Update of /projects/inc
Modified Files:
        Branch: 
          class.soconfig.inc.php

date: 2004/05/02 00:11:55;  author: ceb;  state: Exp;  lines: +10 -4

Log Message:
update
=====================================================================
Index: projects/inc/class.soconfig.inc.php
diff -u projects/inc/class.soconfig.inc.php:1.13 
projects/inc/class.soconfig.inc.php:1.14
--- projects/inc/class.soconfig.inc.php:1.13    Thu Apr 29 15:53:38 2004
+++ projects/inc/class.soconfig.inc.php Sun May  2 00:11:55 2004
@@ -542,18 +542,24 @@
                        $start          = intval($values['start']);
                        $limit          = 
(isset($values['limit'])?$values['limit']:True);
                        $sort           = 
(isset($values['sort'])?$values['sort']:'ASC');
-                       $order          = 
(isset($values['order'])?$values['order']:'account_id');
+                       $order          = 
(isset($values['order'])?$values['order']:'sdate');
                        $query          = 
$this->db->db_addslashes($values['query']);
                        $account_id     = intval($values['account_id']);
+                       $id                     = intval($values['id']);
 
-                       $ordermethod = " order by $order $sort";
+                       $ordermethod = ' order by ' . 
($order!='account_id'?'account_id,' . $order:$order) . ' ' . $sort;
 
                        if($account_id > 0)
                        {
                                $acc_select = ' and account_id=' . $account_id;
                        }
 
-                       $sql = "SELECT * from phpgw_p_projectmembers WHERE 
type='accounting'";
+                       if($id > 0)
+                       {
+                               $id_select = ' and id !=' . $id;
+                       }
+
+                       $sql = "SELECT * from phpgw_p_projectmembers WHERE 
type='accounting'" . $id_select;
 
                        if($limit)
                        {