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

[nomail]

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

date: 2004/06/30 13:24:55;  author: sigurdne;  state: Exp;  lines: +4 -3

Log Message:
no message
=====================================================================
Index: property/inc/class.sos_agreement.inc.php
diff -u property/inc/class.sos_agreement.inc.php:1.7 
property/inc/class.sos_agreement.inc.php:1.8
--- property/inc/class.sos_agreement.inc.php:1.7        Mon Jun 28 10:49:44 2004
+++ property/inc/class.sos_agreement.inc.php    Wed Jun 30 13:24:55 2004
@@ -545,6 +545,7 @@
                                        $s_agreement['cat_id']                  
= $this->db->f('category');
                                        $s_agreement['start_date']              
= $this->db->f('start_date');
                                        $s_agreement['end_date']                
= $this->db->f('end_date');
+                                       $s_agreement['termination_date']= 
$this->db->f('termination_date');
                                        $s_agreement['vendor_id']               
= $this->db->f('vendor_id');
                                        $s_agreement['b_account_id']    = 
$this->db->f('account_id');
                                        $s_agreement['name']                    
= stripslashes($this->db->f('name'));
@@ -651,9 +652,9 @@
                        $this->db->transaction_begin();
                //      $id = $this->bocommon->next_id($table);
                        $id = $this->bocommon->increment_id('workorder');
-                       $this->db->query("INSERT INTO $table 
(id,name,descr,entry_date,category,member_of,start_date,end_date,vendor_id,account_id,user_id
 $cols) "
+                       $this->db->query("INSERT INTO $table 
(id,name,descr,entry_date,category,member_of,start_date,end_date,termination_date,vendor_id,account_id,user_id
 $cols) "
                                . "VALUES ($id,'" . $s_agreement['name'] ."','" 
. $s_agreement['descr'] ."','" . time() . "','" . $s_agreement['cat_id'] . 
"','" . $s_agreement['member_of']
-                               . "','" . $s_agreement['start_date'] . "','" . 
$s_agreement['end_date']
+                               . "','" . $s_agreement['start_date'] . "','" . 
$s_agreement['end_date'] . "','" . $s_agreement['termination_date']
                                . "','" . $s_agreement['vendor_id'] . "','" . 
$s_agreement['b_account_id']
                                . "','" . $this->account . "' $vals)");
 
@@ -791,7 +792,7 @@
                        }
 
                        $this->db->query("UPDATE $table set entry_date='" . 
time() . "', category='"
-                                                       . $values['cat_id'] . 
"', member_of='" . $values['member_of'] . "', start_date=" . 
intval($values['start_date']) . ", end_date=" . intval($values['end_date']) . 
", account_id=" . intval($values['b_account_id']) . "$value_set WHERE id=" . 
intval($values['s_agreement_id']));
+                                                       . $values['cat_id'] . 
"', member_of='" . $values['member_of'] . "', start_date=" . 
intval($values['start_date']) . ", end_date=" . intval($values['end_date']) . 
", termination_date=" . intval($values['termination_date']) . ", account_id=" . 
intval($values['b_account_id']) . "$value_set WHERE id=" . 
intval($values['s_agreement_id']));
 
                        $this->db->query("UPDATE fm_s_agreement_pricing set 
date=" . intval($values['start_date']) . " WHERE id=1 AND agreement_id= " . 
intval($values['s_agreement_id']));