[Phpgroupware-cvs] property/inc/class.sos_agreement.inc.php, 1.6

[nomail]

Update of /property/inc
Modified Files:
        Branch: 
          class.sos_agreement.inc.php

date: 2004/06/23 20:04:59;  author: sigurdne;  state: Exp;  lines: +22 -0

Log Message:
no message
=====================================================================
Index: property/inc/class.sos_agreement.inc.php
diff -u property/inc/class.sos_agreement.inc.php:1.5 
property/inc/class.sos_agreement.inc.php:1.6
--- property/inc/class.sos_agreement.inc.php:1.5        Sat Jun 19 15:03:46 2004
+++ property/inc/class.sos_agreement.inc.php    Wed Jun 23 20:04:59 2004
@@ -47,6 +47,21 @@
                        return $categories;
                }
 
+               function select_vendor_list()
+               {
+                       $table = 'fm_s_agreement';
+                       $this->db->query("SELECT vendor_id,org_name FROM $table 
$this->join fm_vendor on fm_s_agreement.vendor_id=fm_vendor.id ORDER BY 
org_name ");
+
+                       $i = 0;
+                       while ($this->db->next_record())
+                       {
+                               $vendor[$i]['id']                               
= $this->db->f('vendor_id');
+                               $vendor[$i]['name']                             
= stripslashes($this->db->f('org_name'));
+                               $i++;
+                       }
+                       return $vendor;
+               }
+
                function read($data)
                {
                        if(is_array($data))
@@ -57,6 +72,7 @@
                                $sort                   = 
(isset($data['sort'])?$data['sort']:'DESC');
                                $order                  = 
(isset($data['order'])?$data['order']:'');
                                $cat_id                 = 
(isset($data['cat_id'])?$data['cat_id']:'');
+                               $vendor_id              = 
(isset($data['vendor_id'])?$data['vendor_id']:'');
                                $allrows                = 
(isset($data['allrows'])?$data['allrows']:'');
                                $member_id              = 
(isset($data['member_id'])?$data['member_id']:0);
                                $s_agreement_id = 
(isset($data['s_agreement_id'])?$data['s_agreement_id']:'');
@@ -265,6 +281,12 @@
                                $where= 'AND';
                        }
 
+                       if ($vendor_id)
+                       {
+                               $filtermethod .= " $where 
$entity_table.vendor_id='$vendor_id' ";
+                               $where= 'AND';
+                       }
+
                        if ($member_id>0)
                        {
                                $filtermethod .= " $where 
$entity_table.member_of LIKE '%,$member_id,%' ";