Location: PHPKode > scripts > PHP DataGrid > docs/History of changes.txt
ÿþ======================================================================================

--- Version 4.2.8 --------------------------------------------------------------------

======================================================================================



1.  * Feature: [added] russian translation (ru_utf8). Provided by: Ivan Borzenkov <ivan1986@list.ru>

2.  * Feature: [added] French translation for JS AFV. Provided by: Abel MILCENT <abel.milcent@gmail.com>

3.  * Feature: [added] new attribute for images: "magnify"=>"true" - magnify image on museover event.

4.  * Feature: [added] new field tyoe in View Mode: linktodelete. Suggested by v.svetoslavov



1.  = Feature: [improved] removed unnecessary including some javascript files

2.  = Feature: [improved] changed default parameters in GetFieldProperty() method

3.  = Feature: [improved] changed empty date/datetime values in details mode on empty strings

4.  = Feature: [improved] changed draw_add_button_separately not documented property on

       "show_add_button"=>"inside|outside" attribute in SetModes()



1.  # Bug: [fixed] cashing files after downloading exporting file in FF and Opera

       suggested by ivan <ivan1986@list.ru> 

2.  # Bug: [fixed] on drawing foreign key dropdown box

3.  # Bug: [fixed] on drawing background for <TH>

4.  # Bug: [fixed] on drawing enum dropdown boxes in oracle (suggested by Sriharan)

5.  # Bug: [fixed] on drawing foreign key field in oracle (suggested by Sriharan)

6.  # Bug: [fixed] on getting remote file content

7.  # Bug: [fixed] on entering quotes is filtering fields

8.  # Bug: [fixed] F5 button refresh click

9.  # Bug: [fixed] Added JavaScript unicose simbols to alerts messages in language files

                   example of codes in languages/README.txt

10. # Bug: [fixed] Fixed errors on W3C validation (solution suggested by Vincent Cadet <vincent.cadet@teledisnet.be>)





======================================================================================

--- Version 4.2.7 --------------------------------------------------------------------

======================================================================================

1.  * Feature: [added] new language: russian (ru)

2.  * Feature: [added] new type for fields in view mode: enum

3.  * Feature: [added] new language: greek (gr). Provided by: tequilero@ath.forthnet.gr

4.  * Feature: [added] new non-documented property - "NoDataFoundText"

5.  * Feature: [added] new field type in view mode - "money" suggested by "drackor"

6.  * Feature: [added] new field type in add/edit modes: "type"=>"foreign_key" for foreign keys

7.  * Feature: [added] new attributes in filtering mode for dropdownlist: "show" and "condition"

         suggested by Fcallez

8.  * Feature: [added] new attribute sort_type="string|numeric" in view mode



1.  = Feature: [improved] ignore filter field if there was empty 'table' or 'field' attribute

2.  = Feature: [improved] in view mode in "case" attribute added new option "camel"

3.  = Feature: [improved] all method rewritten from aaBbbCcc() into AaaBbbCcc mode



1.  # Bug: [fixed] diactric chars error in IE for UTF-8 charset

2.  # Bug: [fixed] with readonly attribute for "image" and "file" fields

3.  # Bug: [fixed] for oracle in oci8.php - "Fatal error: Cannot use object of type DB_Error..."





======================================================================================

--- Version 4.2.6 --------------------------------------------------------------------

======================================================================================

1.  * Feature: [added] new language Romanian(ro/ro_utf8), provided by: Rotter Robert <demon83ft@gmail.com>

2.  * Feature: [added] new attribute "width" in filtering fields

3.  * Feature: [added] new method: allowExportingTypes();

4.  * Feature: [added] abbility to use in Filtering "," to make a search by some words

5.  * Feature: [added] new feature for textbox in filtering: AJAX autocomplete function

                       provided by Jordi Nin 





1.  # Bug: [fixed] syntax error in css classes

2.  # Bug: [fixed] in drawing tabular layout of filter drawing

3.  # Bug: [fixed] error on Upper/Camel case in "field_data" attribute for "link" fields

4.  # Bug: [fixed] in floatingToolTipsFieldExists() method

5.  # Bug: [fixed] with "Back" button, when it was not allowed

6.  # Bug: [fixed] with "Upload" link for images and files, when field defined as readonly.

7.  # Bug: [fixed] error with numRows() method for oracle

8.  # Bug: [fixed] in selectSqlItem() and executeSql()

9.  # Bug: [fixed] with on_js_event attribute







======================================================================================

--- Version 4.2.5 --------------------------------------------------------------------

======================================================================================

1.  * Feature: [added] non-documented feature - parameter true|false in bind() method: draw DataGrid or not

2.  * Feature: [added] new language (cz) - Czech

3.  * Feature: [added] new type "calendar" for filter fields

4.  * Feature: [added] new attribute "on_js_event" for filtering fields



1.  = Feature: [improved] removed refresh image in print view

2.  = Feature: [improved] added new filter operator type "%like%"

3.  = Feature: [improved] in simple calendar date starts from -65 years from now.

4.  = Feature: [improved] improved sequrity check for form sending values



1.  # Bug: [fixed] in DrawFiltering with selection of default option in dropdown listbox

2.  # Bug: [fixed] "condition" parameter in setTableEdit() wasn't work in Columnar layout

3.  # Bug: [fixed] case in default attribute for fields

4.  # Bug: [fixed] in export methods

5.  # Bug: [fixed] in case sensetivity for headers

6.  # Bug: [fixed] in details mode when no fields defined







======================================================================================

--- Version 4.2.4 --------------------------------------------------------------------

======================================================================================



1.  * Feature: [added] new css class "pink"

2.  * Feature: [added] sequrity check for add/edit/delete records if this options was not allowed

3.  * Feature: [added] abbility to change paging arrows by $paging_arrows = array()

4.  * Feature: [added] new non-documented method: getCurrentId()

5.  * Feature: [added] new non-documented property: mode_after_update

6.  * Feature: [added] new language Turkish (tr), provided by: Murat HALACOGLU <murat@halacoglu.com>



1.  = Feature: [improved] re-written with PHP 5

2.  = Feature: [improved] added checking of maximal page size for possible hack attack

3.  = Feature: [improved] css class "gray"

4.  = Feature: [improved] column headers separated from other GataGrid link by css class a_header

5.  = Feature: [improved] in addRow()added detecting of rid

6.  = Feature: [improved] language files

7.  = Feature: [improved] added alert if file or image was not uploaded before update



1.  # Bug: [fixed] changed href='#' on href='javascript:void(0);'

2.  # Bug: [fixed] in columns summarizing

3.  # Bug: [fixed] in bind() on tabular layout for edit mode

4.  # Bug: [fixed] column headers in tabular layout (edit mode)

5.  # Bug: [fixed] in creating this->HTTP_URL data member

6.  # Bug: [fixed] in radiobuttons_alignment for foreign keys

7.  # Bug: [fixed] in setUrlStringPaging()

8.  # Bug: [fixed] in getNextId() method

9.  # Bug: [fixed] in getting default property value for add mode

10. # Bug: [fixed] in $this->combineUrl() for primary key with leading zeros







======================================================================================

--- Version 4.2.3 --------------------------------------------------------------------

======================================================================================



1.  * Feature: [added] new option in debug mode: running time of the script

2.  * Feature: [added] simple primary key preliminary

3.  * Feature: [added] added new required filed type "u" - URL

4.  * Feature: [added] added new language - Arabic (ar)

        provided by: Abdelmonim Osman 

5.  * Feature: [added] new property in enum and foreign fields: "radiobuttons_alignment"=>"horizontal|vertical" 

6.  * Feature: [added] new field type "validator" with attribute "for_field"=>""

7.  * Feature: [added] new field attribute (not documented)

      "pre_addition" and "post_addition" in view mode for labels and in add/edit/details modes for textboxes

8.  * Feature: [added] new field attribute (not documented): "autocomplete"=>"on|off"

9.  * Feature: [added] securityCheck method to prevent hack attacks



1.  = Feature: [improved] german language file

2.  = Feature: [improved] debug mode: added POST and GET data displayed.

3.  = Feature: [improved] detecting error in setAutoColumnsInView/EditMode

4.  = Feature: [improved] refreh button shown only if there is a filtering allowed

5.  = Feature: [improved] reducing datagrid script running time by changing one stupid SQL SELECT statement

6.  = Feature: [improved] parameter "field_name" for foreign keys may accept values like: "field_name as my_field_name"

       provided by: Franklin Calle Zapata (fcallez@gmail.com)



1.  # Bug: [fixed] wrong field attribute syntax: "operator" instead of "show_operator"

2.  # Bug: [fixed] wrong comparison in drawRadioButtons() method

3.  # Bug: [fixed] wrong comparison in drawDropDownList() method

4.  # Bug: [fixed] wrong predefined css_class in writeCssClass() method()

5.  # Bug: [fixed] wrong error and warnings displaying

6.  # Bug: [fixed] wrong order in $fill_from_array for filter mode

7.  # Bug: [fixed] javascript error with resizable texareas

8.  # Bug: [fixed] javascript error with hiding loading images when two DataGrids on one page have a same prefix

9.  # Bug: [fixed] in displaying "enum" type in details mode

10. # Bug: [fixed] permissions for uploaded filed in add/edit mode (added 0644)

11  # Bug: [fixed] wrong selection of option in ddl for foreign key in add mode

12. # Bug: [fixed] with CR & LF signs in floating tooltips

14. # Bug: [fixed] double parameter in URL: "selSearchType"

15. # Bug: [fixed] in urlencoding while search

16. # Bug: [fixed] if sql statment was containing sign of new row

15. # Bug: [fixed] pagination error for MSSQL in setSqlByDbType() method

16. # Bug: [fixed] in GROUP BY clause for SELECT SQL statements



======================================================================================

--- Version 4.2.2 --------------------------------------------------------------------

======================================================================================



1.  * Feature: [added] new attributes for fields in view mode "tooltip" and "tooltip_type"

2.  * Feature: [added] export to PDF (Provided by zewa666@gmail.com)

3   * Feature: [added] new language (pb) Brazilian Portuguese. Provided by Julio Formiga (form1ga@yahoo.com.br) 

4.  * Feature: [added] new attributes for fields in view/add/edit/details modes "visible" 

5.  * Feature: [added] cool DHTML/JavaScript Calendar (by stephane.dekeyzer)

6.  * Feature: [added] new attributes for date/time fields in add/edit mode "calendar_type"=>"popup|floating" 

7.  * Feature: [added] new icon in Control Panel - Refresh Pages (Provided by stephane.dekeyzer)



1.  = Feature: [improved] fileAction() renamed in formAction() and placed in dg.js

2.  = Feature: [improved] language files

3.  = Feature: [improved] added security checking for arguments in download.php

4.  = Feature: [improved] css style outputted in separated *.css files

5.  = Feature: [improved] added [Clear] option for date/time field types



1.  # Bug: [fixed] first letter upper case for header names

2.  # Bug: [fixed] with LIMIT for Oracle and MSSQL in setSqlByDbType() method

3.  # Bug: [fixed] with "title" attribute in view mode for links and linkbuttons

4.  # Bug: [fixed] WYSIWYG doesn't work in Safari - added automatic detecting

                   and redefining textarea as simple type

5.  # Bug: [fixed] in delete operation in edit mode

6.  # Bug: [fixed] in listbox with multiple selection while uploading file or image

7.  # Bug: [fixed] in debug mode in selectSQL() and executeSql() methods

8.  # Bug: [fixed] sorting by date. Solution: using "sort_by" attribute, for sorting by needed field

9.  # Bug: [fixed] with strtolower function for non-english letters

10. # Bug: [fixed] missing id attribute in some fields

11. # Bug: [fixed] error in FireFox on pagination event when more then 1 datagrid displayed om the screen

12. # Bug: [fixed] error on filtering when more then 1 datagrid displayed om the screen

13. # Bug: [fixed] in Firefox popup for "time" type field doesn't work

14. # Bug: [fixed] for non-numeric primary keys in multirow view

15. # Bug: [fixed] in setAutoColumnsInView/EditMode

16. # Bug: [fixed] with definition of "resizable" attribute for textarea

17. # Bug: [fixed] in getLcaseFooByDbType() method for pgsql

18. # Bug: [fixed] FF error: delete button (image) in edit mode wrong alignment





======================================================================================

--- Version 4.2.1 --------------------------------------------------------------------

======================================================================================



1.  * Feature: [added] new field type - "time"

2.  * Feature: [added] new language: Bulgarian

3.  * Feature: [added] option: drawing add button separately (not documented)

4.  * Feature: [added] new req_type for checkboxes fields: "c" - checked

5.  * Feature: [added] non-documented: setHeadersInColumnarLayout();

6.  * Feature: [added] non-documented: setDgMessages();

7.  * Feature: [added] ability to write some fileds in "field"=>"f1, f2..." parameter of filtering field

8.  * Feature: [added] new parameters for "enum" type: "multiple" and "multiple_size"

9.  * Feature: [added] new layout type: customized (drawCustomized()) in view/details mode

10. * Feature: [added] new parameters for "link" type in view mode: "rel" and "title"

11. * Feature: [added] new option: show/hide search types dropdownbox



1.  = Feature: [improved] language translation: German, Netherlands

2.  = Feature: [improved] "image" size attributes: height and width

3.  = Feature: [improved] faster working in view and detail modes

          (removed unnecessary including form.scripts.js, resize.js (~60Kb))

4.  = Feature: [improved] faster working in add and edit modes

          (removed unnecessary including wysiwyg.js (~35Kb))

5.  = Feature: [improved] added errors handling for selectSqlItem/executeSql

6.  = Feature: [improved] function setBrowserDefinitions in separateed file in folder "functions/"



1.  # Bug: [fixed] wrong variable value while uploading

2.  # Bug: [fixed] when using GROUP BY in SELECT SQL statement

3.  # Bug: [fixed] in drawing foreign keys

4.  # Bug: [fixed] with processing datemdy type in calendar

5.  # Bug: [fixed] in "link" type with multiple parameters processing

6.  # Bug: [fixed] LIMIT (OFFSET) error for PostgreSql statements

7.  # Bug: [fixed] error with mysql_real_escape_string for different db types

8.  # Bug: [fixed] with alignment of images in view mode

9.  # Bug: [fixed] on Update with readonly fields





======================================================================================

--- Version 4.2.0 --------------------------------------------------------------------

======================================================================================



1.  * Feature: [added] new attribute "resizable" for textarea

2.  * Feature: [added] uploading images and files from remote hosting: "host"=>"remote"

3.  * Feature: [added] added new source format for "enum" field type:

         $fill_from_array = array("0"=>"No", "1"=>"Yes");

4.  * Feature: [added] added new source format for dropdownlist in filtering mode:

         $fill_from_array = array("0"=>"No", "1"=>"Yes");

5.  * Feature: [added] new not-documented method getNextId()

6.  * Feature: [added] new option (not documented): hide grid before serach

7.  * Feature: [added] new parameter: "unique_condition" in add/edit modes

8.  * Feature: [added] new method setJsErrorsDisplayStyle() and option to display

      all error together

9.  * Feature: [added] new option "textbox" in "view_type" for foreign keys

10. * Feature: [added] new field type in add/edit modes: "hidden"

11. * Feature: [added] new field type in add/edit/details modes: "delimiter"

12. * Feature: [added] new type "linktoedit" for view mode

13. * Feature: [added] display order of columns defined by user, not by order in SELECT SQL

14. * Feature: [added] new parameter "unique" for columns in edit mode

15. * Feature: [added] new parameters for type texarea: "rows"=>"7" and "cols"=>"50"

16. * Feature: [added] LIMIT/TOP/NUM_ROWS processing for different database types

17. * Feature: [added] new parameter: "on_js_event"=>"" for Add/Edit/View Modes

18. * Feature: [added] new type "link" for add/edit/details mode

19. * Feature: [added] using of some fields for default order in View Mode

20. * Feature: [added] warnings system

21. * Feature: [added] small image preview on uploading

22. * Feature: [added] new parameter for image type: "image_name"=>"Image_Name"

23. * Feature: [added] new parameters for foreign keys:

      "order_by_field"=>"Field_Name" and "order_type"=>"ASC|DESC"

24. * Feature: [added] in View and Edit/Details mode added new parameter for

      image type: image_width & image_height

25. * Feature: [added] new parameter "maxlength"=>>"..." for fields in Add/Edit modes

26. * Feature: [added] new format for "source"=>$fill_from_array parameter in

      filter mode 

27. * Feature: [added] new parameter for enum type: default value

28. * Feature: [added] Multi-row in details mode

29. * Feature: [added] new language - Chinese (provided by xukong)

30. * Feature: [added] new parameter - "on_js_event"=>"" for link type in View Mode

31. * Feature: [added] new language - Polish (provided by davie81)

32. * Feature: [added] auto columns generation by

      setAutoColumnsInViewMode() and setAutoColumnsInEditMode()

33. * Feature: [added] onSubmitMyCheck() JS function for specific checkings

34. * Feature: [added] Reset button in filtering mode

35. * Feature: [added] new parameter - {0...n} in the link type of view mode 

36. * Feature: [added] new parameter - condition in setTableEdit()

37. * Feature: [added] new method - setEditModeTableProperties()

38. * Feature: [added] new method - setDetailsModeTableProperties()

39. * Feature: [added] new type in view mode - barchart

40. * Feature: [added] executeSql() method

41. * Feature: [added] selectSqlItem() method

42. * Feature: [added] export in XML format

43. * Feature: [added] new parameter - readonly for fields in edit mode

44. * Feature: [added] new parameter - "default"=>"..." for fields in add mode

45. * Feature: [added] code checking if form.script.js exists





1.  = Feature: [improved] column sorting starts with ASC, date/time column - with DESC

2.  = Feature: [improved] reduced page's HTML output (~ upto 6%)

3.  = Feature: [improved] lang.php file splited in separate language files

4.  = Feature: [improved] myDate() method

5.  = Feature: [improved] language file - added Serbian

6.  = Feature: [improved] "enum" field type in "details" mode

7.  = Feature: [improved] uploading files                

8.  = Feature: [improved] ability to use virtual fields in "field_name" parameter for foreign keys

      ex.: "field_name"=>"CONCAT(name1, ', ', name2) as name3"

9.  = Feature: [improved] added maxlength properties for textarea type

10. = Feature: [improved] removed updating readonly fields

11. = Feature: [improved] including javasript files

12. = Feature: [improved] language file

13. = Feature: [improved] getVariable method()

14. = Feature: [improved] details/delete and multi-row columns have fixed width

15. = Feature: [improved] parameter "image_name" renamed in "file_name" for "image" and "file" types in add/edit/detail modes

16. = Feature: [improved] css classes naming and work

17. = Feature: [improved] encoding of data. Added collation parameter in setEncoding()

18. = Feature: [improved] debugger messaging system

19. = Feature: [improved] getting Primary Key and spliting strings in the code

20. = Feature: [improved] method getRequestVars() renamed in getVariable()

21. = Feature: [improved] downloading of export files 

22. = Feature: [improved] detecting field properties while auto code generation

23. = Feature: [improved] selecting and highlighting rows

24. = Feature: [improved] removed unnecessary sql statments on updating/deleting

25. = Feature: [improved] debugger messaging

26. = Feature: [improved] css <a> tag styling

27. = Feature: [improved] new format for parameter "max_file_size": 1024B|100K|10M|1G...

28. = Feature: [improved] colspan parameter in Search table

29. = Feature: [improved] translating into Netherlands

30. = Feature: [improved] messaging in AddRow/UpdateRow/DeleteRow methods

31. = Feature: [improved] view of datetime link & pop-up

32. = Feature: [improved] added headers to fields in exporting to *.csv

33. = Feature: [improved] translation in german

34. = Feature: [improved] added uploading option for image type in Add/Edit/Detail modes

     and new parameters: "width"=>"...", "height"=>"..." and "default"=>"..." in Add/View/Edit/Detail modes





1.  # Bug: [Fixed] wrong page size after clicking on 'Reset' button

2.  # Bug: [Fixed] unexpected "WHERE" in SELECT SQL statment when "HAVING" already included

3.  # Bug: [Fixed] unexpected "," in UPDATE SQL statment when only 1 field is updated

4.  # Bug: [Fixed] wrong "wrap" attribute implementation in drawTabular() method

5.  # Bug: [Fixed] "hidden" field displaing in details mode

6.  # Bug: [Fixed] with using WHERE in SELECT SQL statment in view mode

7.  # Bug: [Fixed] undefined index error in drawFiltering() method

8.  # Bug: [Fixed] wrong detection of "https:" in getProtocol() method

9.  # Bug: [Fixed] wrong placed ")"

10. # Bug: [Fixed] in filtering with 2 DG's on one page

11. # Bug: [Fixed] in "maxlength" property for textarea

12. # Bug: [Fixed] <!-- error in some browsers 

13. # Bug: [Fixed] wrong action onclick event when back button is image or button.

14. # Bug: [Fixed] missing unique prefixe for onSubmitMyCheck 

15. # Bug: [Fixed] language including error after search

16. # Bug: [Fixed] with &amp; (added new data member - $amp)

17. # Bug: [Fixed] checking of current mode in noDataFound() method

18. # Bug: [Fixed] in bottom paging turning off 

19. # Bug: [Fixed] showing calendar in add/edit modes when field is readonly

20. # Bug: [Fixed] the $directory wasn't added to the creation of export.csv and export.xml 

21. # Bug: [Fixed] saves data between pade reloads, while uploading files in add/edit modes

22. # Bug: [Fixed] error if missing "req_type" parameter in add/edit/detail modes

23. # Bug: [Fixed] small bug with multi-row in details mode with tabular layout

24. # Bug: [Fixed] small bug in title for textarea 

25. # Bug: [Fixed] small bug in setInterfaceLang()

26. # Bug: [Fixed] file uploading error in add mode

27. # Bug: [Fixed] wrong handling of "unique" parameter in add/edit mode

28. # Bug: [Fixed] highlighting small bug in view/details mode

29. # Bug: [Fixed] wrong fieldset width in view mode

30. # Bug: [Fixed] wrong ORDER BY parameter in SELECT SQL in add mode

31. # Bug: [Fixed] wrong alignment of foreign key output

32. # Bug: [Fixed] wrong displaying of datagrid in print preview in edit/detail modes

33. # Bug: [Fixed] css clas_a/class_a2 missed parameter

34. # Bug: [Fixed] missed unique prefix for cookie vars in hideUnHideFiltering() function

35. # Bug: [Fixed] unexpected 'http:'s in link type in view/detail modes

36. # Bug: [Fixed] small bug in setModes() function

37. # Bug: [Fixed] strtolower() small bug in some place

38. # Bug: [Fixed] wrong URL after the click on 'Reset' button 

39. # Bug: [Fixed] missing WHERE in SQL SELECT error 

40. # Bug: [Fixed] LCASE error for Oracle and MSSQL

41. # Bug: [Fixed] canceling of row highlighting, with click on delete button in IE

42. # Bug: [Fixed] wrong syntax with NUMROWS processing for Oracle

43. # Bug: [Fixed] syntax error in setSqlByDbType() and setSqlLimitByDbType() 

44. # Bug: [Fixed] FireFox error on carrying out multirow operations and pagging (&amp;)

45. # Bug: [Fixed] empty data error on required numeric fields while updating

46. # Bug: [Fixed] error on deleting last row from the last page

47. # Bug: [Fixed] error on wrong default order data (after updating)

48. # Bug: [Fixed] wrong "Search type:" displaying when only 1 field in filtering section

49. # Bug: [Fixed] single quotes error in drawForeignKeyInput() method

50. # Bug: [Fixed] FireFox updating error

51. # Bug: [Fixed] error while creating uploading directory, if it was not exist

52. # Bug: [Fixed] uploading 2 or more files

53. # Bug: [Fixed] problem with single quote (') by adding mysql_real_escape_string() and stripslashes()

54. # Bug: [Fixed] maxlength error (-1) in getFieldValueByType()

55. # Bug: [Fixed] wrong offset in columns_edit_mode array in drawForeignKeyInput()

56. # Bug: [Fixed] "alt" propertiey in <img> changed on "title" to show tooltips in FF

57. # Bug: [Fixed] tag <php error in lang.php file

58. # Bug: [Fixed] empty SELECT result if primary key was in non-numeric type

59. # Bug: [Fixed] unexpected column in add mode, if multirow option is allowed

60. # Bug: [Fixed] error while uploading & updating if unique prefix was more then 2 simbols

61. # Bug: [Fixed] blocked direct access to all folders by adding a blank index.html file

62. # Bug: [Fixed] checkbox shows only 1 or 0 in details mode (instead of 'Yes', 'No')

63. # Bug: [Fixed] showing wrong icons and checkboxes in print mode

64. # Bug: [Fixed] wrong offset of summarizing column

65. # Bug: [Fixed] default maxlength value error in edit mode

66. # Bug: [Fixed] colSpan='0' error in FireFox

67. # Bug: [Fixed] function lastSubStrOccurence() not handles correctly cases like: tblWhere, tblFrom etc.

68. # Bug: [Fixed] default paging didn't work - shows wrong number of row in first viewing

69. # Bug: [Fixed] error in details mode: undefined variable curr_url

70. # Bug: [Fixed] setLanguage error

71. # Bug: [Fixed] missing title parameter in drawModeButton() function in <IMG>

72. # Bug: [Fixed] unexpected field data while exporting to *.csv







======================================================================================

--- Version 4.1.0 --------------------------------------------------------------------

======================================================================================



1.  * Feature: [added] columns summarising

2.  * Feature: [added] multi-row operations (delete)

3.  * Feature: [added] type "file" in edit mode, that allows files uploading 

4.  * Feature: [added] option width for columns in setColumnsInViewMode() 

5.  * Feature: [added] scrolling option by: $dgrid->allowScrollingSettings(true);

6.  * Feature: [added] options LIKE% and %LIKE in filtering mode

7.  * Feature: [added] option "default_operator"=>"=|<|>|like|not like" in filtering mode

8.  * Feature: [added] columns summarization by option "summirize"=>true in add/edit mode

9.  * Feature: [added] checking for db connection (if(DB::isError($result_conn)){ die($result_conn->getMessage()); })

10. * Feature: [added] option {0} for link in setColumnsInViewMode() - see getting started for more information

11. * Feature: [added] hide/unhide option for filtering (search)

12. * Feature: [added] automatic detection of HTTPS protocol

13. * Feature: [added] text caption about required fields * in edit mode

14. * Feature: [added] new option for "enum" type in Add/Edit/Detais mode - fill from custom array

15. * Feature: [added] new field type "checkbox" in add/edit/details mode

16. * Feature: [added] rows hightlighting method

17. * Feature: [added] new languages: Català, Español, Hungarian, Swedish, Français,

            Italiano (provided by: Matteo Piotto piotto@gmail.com)

18. * Feature: [added] new documentation for Pear::DB examples in docs/pear/ folder

19. * Feature: [added] print mode css

20. * Feature: [added] changing column headers backgoung on mouseover

21. * Feature: [added] new datetime types for/add/edit/details modes: datedmy and datetimedmy

           (provided by Franklin Calle Zapata http:www.innovavirtual.org)





1.  = Feature: [improved] parameters for "link" type in setColumnsInViewMode() method: field_key, field_data

2.  = Feature: [improved] code in draw_filtering() method

3.  = Feature: [improved] javascript declaration syntax

4.  = Feature: [improved] paging algorithm

5.  = Feature: [improved] paging behaviour

6.  = Feature: [improved] displaying password in details mode

7.  = Feature: [improved] displaying image in details view

8.  = Feature: [improved] displaying "self" values in dropdownlist in filtering mode

9.  = Feature: [improved] in View Mode Settings in link type "prefix" changes on "href" with {0}

10. = Feature: [improved] calendar view improved

11. = Feature: [improved] drawRadioButtons & drawDropDownList functions

12. = Feature: [improved] in form.scripts.js (added new type Zip code)

13. = Feature: [improved] method setTitle() renamed into SetCaption()

14. = Feature: [improved] images for each embedded css style

           (provided by Stefan Nistelberger Stmk. Krankenanstaltengesellschaft m.b.H.)



1.  # Bug: [Fixed] unexpected slashes in setWYSIWYG() method

2.  # Bug: [Fixed] error when try to add new row with empty database

3.  # Bug: [Fixed] wrong viewing data if it has a single/double quotation mark

4.  # Bug: [Fixed] error when try to add new row with empty numeric fields

5.  # Bug: [Fixed] WYSIWYG editor blinking.

6.  # Bug: [Fixed] http port (was missing in some places in code).

7.  # Bug: [Fixed] double variables in url on after Update clicking.

8.  # Bug: [Fixed] wrong field offset in byFieldValue option.

9.  # Bug: [Fixed] wrong field offset in linktoview option. 

10. # Bug: [Fixed] in noDataFound() method when was no default css class. 

11. # Bug: [Fixed] in bind() method in Print modes after Add/Update/Delete operation. 

12. # Bug: [Fixed] passing wrong parameters for drawModeButton() method in Cancel Mode. 

13. # Bug: [Fixed] passing wrong parameters for drawModeButton() method in Add Mode. 

14. # Bug: [Fixed] in methods getFieldOffset() and  getFieldInfo() while sql error occured. 

15. # Bug: [Fixed] with WHERE word in SQL SELECT that has sub-SELECT queries. 

16. # Bug: [Fixed] with missing unique prefix in combine_url() method. 

17. # Bug: [Fixed] with definition css of class 'class_fieldset'. 

18. # Bug: [Fixed] was missing css style of <label> (added new css class "class_label"). 

19. # Bug: [Fixed] with css classes: class_a and class_a2.

20. # Bug: [Fixed] wrong placing of delete button in edit mode in FireFox







======================================================================================

--- Version 4.0.0 --------------------------------------------------------------------

======================================================================================



Additions:

=========

1.  * new option "condition" in setForeignKeysEdit() method

2.  * new option set/unset rows numeration in method allowPaging()

3.  * new option in filtering mode "comparison_type"=>"string|numeric|binary"

4.  * new option: default & custom field sorting

5.  * sorted column colored in dark

6.  * new option: force Upper or Lowercase (for text or other fileds)

7.  * new option: wrap/nowrap in each column

8.  * done css w3c validation (http:jigsaw.w3.org/css-validator/)

9.  * added full pathes for all directories

10. * added new type "enum"

11. * new option: width for editing fields

12. * added title with full text for reduced fields

13. * added multy-language interface

14. * added multy-database supporting 

15. * added multy-browsing supporting 

16. * added WYSIWYG editor for <textarea>'s

17. * new css style (default)



Improvements:

============

1. = adding a new row (now it not add new row automaticaly)

2. = in default ordering 

3. = alignment of images in edit mode

4. = in setUrlString() method

5. = in noDataFound() method

            

Bugs fixed:

==========

1.  # in css class "class_a"

2.  # in displaying of number of columns in tabular layout after addidng new row

3.  # in detecting 'blob' type of field

4.  # in draw_tabular drawing

5.  # lower case error in filtering

6.  # in numRows() function

7.  # rows count in tabilar layout in edit mode

8.  # in edit and add modes in tabular layout

9.  # in pop-up for for field with reduced length

10. # in returning value in getFieldOffset() method 







--------------------------------------------------------------------------------------

--- Version 3.2.3 --------------------------------------------------------------------

--------------------------------------------------------------------------------------



Additions:

=========

1. * new filtering options (> and < ). 

2. * Now it is possible to search by date, for ex.: Date > 2006-12-30

3. * new paging option - ability to set default page size

4. * new types of data: date & datetime 

         2006-12-30 or 2006-12-30 12:12:00

5. * .zip format for class archive is avaliable for downloading 

6. * added sorting indicators for columns (small ^ and v images)

7. * ability to add datagrid title - setTitle() function;

8. * new option "order"=>"ASC|DESC" for dropdown boxes in searching

9. * new option "align"="left|center|right" for fields in setColumnsInViewMode 

   (align for single column)



Improvements:

============

1. = filtering: types AND or OR are not shown, if there is only 1 field for searching

2. = $debug_mode = false; $messaging = true; 

       now in new DataGrid($debug_mode, $messaging), not in $dgrid->bind()

3. = Result: 1 of about 16 changed on Result: 1 of 16

4. = usage "dropdownlist" word instead of "combobox"



Bugs fixed:

==========

1. # debug mode was not work. now it's Ok.

2. # now date/datetime field my be any type - not only "rt" 

3. # bug if user add ; at end of SELECT query 

4. # filtering operator had wrong align in FireFox - fixed.

5. # fixed wrong alignment of legend frame in FireFox.

6. # fixed bug for page access with some variables 

   now you need write them in $dgrid->setHttpGetVars($http_get_vars);
Return current item: PHP DataGrid