[Phpgroupware-tracker] [bugs #3379] Incorrect table names used in bookkeeping

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #3379] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Thu 07/15/2004 at 22:58 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
     Planned Release | None                      | 0.9.18.000







/**************************************************************************/
[bugs #3379] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=3379>
Project: phpGroupWare
Submitted by: Kai Hofmann
On: Tue 04/29/2003 at 09:12

Category:  bookkeeping
Item Group:  devel cvs
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  None
Assigned to:  None
Status:  Open
Component Version:  None
Platform Version:  None
Reproducibility:  None
Planned Release:  0.9.18.000
Fixed Release:  


Summary:  Incorrect table names used in bookkeeping

Original Submission:  Within this module there are a lot of "old" (?) table 
names that are not within the database - as it seems they all are
converted to short 1 or 2 character labels:


NO tables: phpgw_bk_categories, phpgw_bk_entries, phpgw_bk_acl, phpgw_bk_gu  
and maybe others!!!



 $phpgw->db->query("SELECT * FROM phpgw_bk_categories WHERE 
income_expense='$income_expense' order by $order");
./bookkeeping/categories.php

     $sql="insert into phpgw_bk_categories (description,income_expense) values 
('$description','$income_expense')";
./bookkeeping/category_add.php

      $sql="delete from phpgw_bk_categories where category_id=$category_id";
    $phpgw->db->query("select description from phpgw_bk_categories WHERE 
category_id='$category_id'");
./bookkeeping/category_delete.php

    $sql="update phpgw_bk_categories set description='$description' where 
category_id=$category_id";
    $sql="select description from phpgw_bk_categories where 
category_id=$category_id";
./bookkeeping/category_edit.php

    $sql="select category_id,description from phpgw_bk_categories where 
income_expense='$income_expense' order by description asc";
./bookkeeping/entry_add.php

                      "from phpgw_bk_entries e, phpgw_bk_categories c WHERE 
entry_id='$entry_id' AND e.category_id=c.category_id");
./bookkeeping/entry_delete.php

    $sql2="select category_id,description from phpgw_bk_categories where 
income_expense='$income_expense' order by description asc";
./bookkeeping/entry_edit.php

                    "from phpgw_bk_entries e, phpgw_bk_categories c WHERE 
entry_id='$entry_id' AND e.category_id=c.category_id");
./bookkeeping/entry_view.php

    $sql="select category_id,description from phpgw_bk_categories where 
income_expense='$income_expense' order by description asc";     
    $sql="select category_id,description from phpgw_bk_categories where 
income_expense='$income_expense' order by description asc"; 
./bookkeeping/statistics.php

      $sql2="select sum(e.amount) as amount, c.description as description from 
phpgw_bk_entries e, phpgw_bk_categories c ". 
./bookkeeping/reports/reports.php

                $sql = "SELECT module FROM phpgw_bk_acl WHERE bookkeeping_id='" 
. $phpgw_info['bookkeeping']['id'] . "' GROUP BY module";
                $sql = "SELECT a.bookkeeping_id FROM phpgw_bk_acl a, 
phpgw_bk_gu g WHERE a.group_id = g.group_id AND g.user_id='" . 
$phpgw_info['user']['id'] . "' GROUP BY a.module";
./bookkeeping/inc/class.bookkeeping.inc.php

                $sql = "SELECT a.bookkeeping_id FROM phpgw_bk_acl a, 
phpgw_bk_gu g WHERE a.group_id = g.group_id AND g.user_id='" . 
$phpgw_info['user']['id'] . "' GROUP BY a.module";
./bookkeeping/inc/class.bookkeeping.inc.php


Follow-up Comments
------------------


-------------------------------------------------------
Date: Tue 04/29/2003 at 23:25       By: skwashd
This app is currently unmaintained












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=3379>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/