bugphpGroupWare - Bugs: bug #3379, Incorrect table names used in...

 
 

You are not allowed to post comments on this tracker with your current authentification level.

bug #3379: Incorrect table names used in bookkeeping

Submitted by:  Kai Hofmann <powerstat>
Submitted on:  Tue 29 Apr 2003 09:12:11 AM UTC  
 
Item Group: SVN trunk (dev code)Category: bookkeeping
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: NoneOpen/Closed: Open
Component Version: NoneOperating System: None
Reproducibility: NonePlanned Release: 0.9.18.000
Fixed Release: 

Tue 29 Apr 2003 11:25:47 PM UTC, comment #1:

This app is currently unmaintained

Dave Hall <skwashd>
Project Administrator
Tue 29 Apr 2003 09:12:11 AM UTC, 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

Kai Hofmann <powerstat>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 2 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 15 Jul 2004 10:58:36 PM UTCskwashdPlanned ReleaseNone=>0.9.18.000
Wed 30 Apr 2003 12:28:43 AM UTCskwashdSummaryOld and Wromng db table names in the code=>

Back to the top


Powered by Savane 3.1-cleanup