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

[nomail]

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

date: 2004/06/19 22:47:31;  author: ceb;  state: Exp;  lines: +46 -1

Log Message:
update
=====================================================================
Index: projects/inc/class.soconfig.inc.php
diff -u projects/inc/class.soconfig.inc.php:1.16 
projects/inc/class.soconfig.inc.php:1.17
--- projects/inc/class.soconfig.inc.php:1.16    Thu Jun  3 13:38:59 2004
+++ projects/inc/class.soconfig.inc.php Sat Jun 19 22:47:31 2004
@@ -515,6 +515,7 @@
                                case 'role':            $p_table = 
'phpgw_p_roles'; $p_column = 'role_id'; break;
                                case 'emp_role':
                                case 'accounting':      $p_table = 
'phpgw_p_projectmembers'; $p_column = 'id'; break;
+                               case 'charge':          $p_table = 
'phpgw_p_surcharges'; $p_column = 'charge_id'; break;
                        }
 
                        $this->db->query("DELETE from $p_table where 
$p_column=" . $pa_id,__LINE__,__FILE__);
@@ -686,5 +687,49 @@
                        $this->db->next_record();
                        return $this->db->f(0);
                }
+
+               function list_surcharges($charge_id = 0)
+               {
+                       $charge_id = intval($charge_id);
+
+                       if($charge_id > 0)
+                       {
+                               $select = ' where charge_id=' . $charge_id;
+                       }
+                       else
+                       {
+                               $select = ' order by charge_name asc';
+                       }
+
+                       $this->db->query('SELECT * from phpgw_p_surcharges' . 
$select,__LINE__,__FILE__);
+
+                       while($this->db->next_record())
+                       {
+                               $charges[] = array
+                               (
+                                       'charge_id'                     => 
$this->db->f('charge_id'),
+                                       'charge_name'           => 
$this->db->f('charge_name'),
+                                       'charge_percent'        => 
$this->db->f('charge_percent')
+                               );
+                       }
+                       return $charges;
+               }
+
+               function save_surcharge($values)
+               {
+                       $values['charge_id']            = 
intval($values['charge_id']);
+                       $values['charge_percent']       = 
$values['charge_percent'] + 0.0;
+
+                       if($values['charge_id'] > 0)
+                       {
+                               $this->db->query('UPDATE phpgw_p_surcharges set 
charge_name=' . "'" . $values['charge_name'] . "', charge_percent=" . 
$values['charge_percent']
+                                                               . ' where 
charge_id=' . $values['charge_id'],__LINE__,__FILE__);
+                       }
+                       else
+                       {
+                               $this->db->query('INSERT into 
phpgw_p_surcharges (charge_name,charge_percent) values(' . "'" . 
$values['charge_name'] . "',"
+                                                               . 
$values['charge_percent'] . ')',__LINE__,__FILE__);
+                       }
+               }
        }
 ?>