Home

trac 0.1 on Openbiz 2.2.3 dev version

Submitted by rocky on Fri, 02/22/2008 - 09:54.

0.1 version of ob-trac application is an basic issue tracking application. It mimics the issue tracing functions of trac (trac.edgewall.org). It is built on openbiz 2.2.3 dev version. It is released with GPL V3 license. It can be download from https://sourceforge.net/project/showfiles.php?group_id=64196&package_id=.... Screenshot can be seens at http://www.phpopenbiz.org/document/ss/trac_tickets.jpg

The new trac application is a real world application. It demonstrates

- how to show different types of UI with templates

- how to extend openbiz core class to handle special logic

The installation is same as install demoapp. Just web installer http://host/.../trac/index.php. The installer wizard will create a database with sample data.

What is on openbiz 2.2.3 dev version so far:

- support AJAX file upload. uploaded file is stored into sec_upload directory (in 2.2.2, only support upload file to a blob column in a table).

- clean up BizDataObj.php by moving page navigation functions to BizForm.

- Add ValueOnCreate, ValueOnUpdate attributes to BizField metadata. ValueOnCreate can set the value on record creation, ValueOnUpdate can set the value on record update. This finally solves the popular issue for table columns like time_created and time_updated.

 
#1Submitted by rocky on Sun, 02/24/2008 - 01:43.

Andrew, can't agree with you

Andrew, can't agree with you more. trac on openbiz (ob-trac) will

  • Provide an alternate issue tracking tool written in PHP. "trac" is written in Python - no easy to run trac on most hosted servers where PHP/Perl are installed, not Pyhton. Also "trac" is lack of user/access management which is critial to a issue tracking system. ob-trac will do better on it.
  • Help to openbiz project issue tracking. Current Openbiz (on Drupal 5) project issue management is ok, but should be easier and intuitive to use.
  • Show a real world demo of how to leverage of the power of openbiz framework. It also can help openbiz framework to improve.

You raised a good question on dataobject's ValueOnCreate. The difference between ValueOnCreate and DefaultValue is

  • DefaultValue is set on generating an empty new record
  • ValueOnCreate is set on "insert" the record into table.

Use the "time_created" (commonly used in many schema) as an example. At time-1, BizDataObj's NewRecord to get an empty record with default value set. Then user fill in all required values, then at time-2 BizDataobj's InsertRecord will insert this record into the table. If use DefaultValue for time_created column, the value saved in the column is time-1. If use ValueOnCreate for time_created column, the value saved in the column is time-2.

 
#2Submitted by andrewseagull on Sat, 02/23/2008 - 02:09.

Rocky, It'll

Rocky,

It'll be natural way to use here for OpenBiz bug tracking.

On another note, is there a difference between dataobject's ValueOnCreate and DefaultValue attributes?

-Andrew
#3Submitted by jgonzalez on Sat, 03/08/2008 - 00:33.

Andrew; ValueOnCreate is a

Andrew;

ValueOnCreate is a value that will be saved when the new physical record is written down to the db. The DefaultValue is just the initial value that the GUI will show to the user and it can be changed before the record is created.