[Care2002-developers] SVN 6774 and another bug found

2010-09-21 Thread Ap.Muthu
function formatDate2STD is defined in line 136 of /include/core/inc_date_format_functions.php It is referred to as formatDate2Std in 17 files. and as formatDate2STD in 43 files. In 2 files it is referred to as both. Corrected all to formatDate2STD as defined in the function declaration, and

[Care2002-developers] DB data change - SVN 6775

2010-09-21 Thread Ap.Muthu
table: care_config_global person_foto_path must NOT end in a slash news_foto_path MUSTend in a slash news uses class image person photo uses include/core/inc_photo_filename_resolve.php SQL update: UPDATE `care_config_global` SET `value`='uploads/photos/registration' WHERE

Re: [Care2002-developers] DB data change - SVN 6775

2010-09-21 Thread Robert Meggle
Hi Muthu, Thanks, it's working! Robert Am Dienstag, den 21.09.2010, 21:36 +0530 schrieb Ap.Muthu: table: care_config_global person_foto_path must NOT end in a slash news_foto_path MUSTend in a slash news uses class image person photo uses include/core/inc_photo_filename_resolve.php

Re: [Care2002-developers] SVN 6774 and another bug found

2010-09-21 Thread Robert Meggle
Hi Muthu, it is strange. I will do a frehs install as well and let us hunt that bug. That is really strange. During that hunting season my question about the fields on admission process are not discussed. Currently there are the fields Diagnosis, Referred by, Therapy and Referrer notes

[Care2002-developers] Kudos Muthu , Robert Gjergj

2010-09-21 Thread Frank Tilugulilwa
You guys are doing great job now - Frank Tz -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing.

Re: [Care2002-developers] Kudos Muthu , Robert Gjergj

2010-09-21 Thread Ap.Muthu
Hi Frank, This is the only version I depend on. So you are in good hands! Regards, Ap.Muthu On Tue, 2010-09-21 at 19:37 +0200, Robert Meggle wrote: Thanks Frank, it is my first time i am downloading the source code from care2x.org and install without thinking at all :-) and yet it

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Ap.Muthu
Hi Robert, What is the purpose of the status field being normal for certain values in the table: care_config_global ? In the code for saving to theinsurance table, the check is that if the insurance number is non empty and the insurance company is non epty only then will the insurance data be

Re: [Care2002-developers] Kudos Muthu , Robert Gjergj

2010-09-21 Thread Robert Meggle
Am Dienstag, den 21.09.2010, 20:55 +0300 schrieb Frank Tilugulilwa: On Tue, 2010-09-21 at 19:37 +0200, Robert Meggle wrote: Did you know that there is an existing Swahili language pack in it? Infact this is one of things that amazed me today, i same my Swahili language working. Might

Re: [Care2002-developers] Kudos Muthu , Robert Gjergj

2010-09-21 Thread Robert Meggle
Hi Frank, Gjergj and me started to review the code month ago. First we created an branch named gettext, with the simple idea to move the current language files to that kind of managing the multi language management. Then we (mostly Gjergj) sorted out a lot of bugs and multiple use of files.

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Tim Schofield
Hi Robert, Have you looked at how the insurances work in the care2utu branch? Tim On 21 September 2010 19:41, Robert Meggle robert.meg...@care2x.org wrote: Hi Muthu, In fact you got the point I complain. Is there really a need for such insurance things? Insurances are always handled in a

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Robert Meggle
Hi Muthu, We are now on the level where all had started of care2x nearly 10 years ago. Since that time that peace of code had not been touched. But you're right, the _ will be escaped by MySQL and the interesting thing is that somehow it had been worked now since years. Another aspect,

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Robert Meggle
Hi Tim, I think you can smell my idea :D Robert Am Dienstag, den 21.09.2010, 19:49 +0100 schrieb Tim Schofield: Hi Robert, Have you looked at how the insurances work in the care2utu branch? Tim On 21 September 2010 19:41, Robert Meggle robert.meg...@care2x.org wrote: Hi Muthu,

Re: [Care2002-developers] SVN 6774 and another bug found

2010-09-21 Thread Ap.Muthu
Hi Robert, Just did a fresh install of SVN 6782 and all went well. Till this add first person bug is fixed, the sequence of adding the first person would be: Add first person without insurance and no picture. Then search for the person and insert picture and insurance data and update.

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Gjergj Sheldija
Hi Robert, you are so right about the $$ a lot of modules uses it, prescription, lab requests, depot... it's really a dark chapter.. gj. On 2010-09-21 8:49.MD, Robert Meggle wrote: Hi Muthu, We are now on the level where all had started of care2x nearly 10 years ago. Since that time that

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Ap.Muthu
$$ - Mostly used as LD_var for translating strings and possibly field names A data dictionary is what is needed. I will now try to make some (non)sense out of an entity relationship diagram for care2x. The unusual naming conventions for naming fields have got me dizzy. Since we are all using

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Robert Meggle
Well, if the version table is been used somewhere, I have not seen it over the years. About the version numbering as comments. I would like to move that topic when we killed all relevant bugs out and place a (c) setting in each file. We have to do it, care2x was pirated and sold in the past many

[Care2002-developers] ERD

2010-09-21 Thread Ap.Muthu
CaseSTUDIO 2.3 - CharonWare ERD Well, if the version table is been used somewhere, I have not seen it over the years. About the version numbering as comments. I would like to move that topic when we killed all relevant bugs out and place a (c) setting in each file. We have to do it,

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Gjergj Sheldija - AcmeTECH
in the gettext branch i started renaming table fields from german to english and doing some cleanups.. the idea of using a data dictionary may be appealing at first, but when you start noticing all the small differences between hospitals and countries, you resolve to using a lot of config

Re: [Care2002-developers] another file movement

2010-09-21 Thread Robert Meggle
Hi Gjergj, Yes, that would be perfect. As long there is no module handling by PEAR (or something) we should have some ideas here. Well, I might have. The table for version could dominate to execute an sql query called by index.php on start - and after execute the sql-update query comming along

Re: [Care2002-developers] revision 6779

2010-09-21 Thread Robert Meggle
Hi Gjergj and Muthu, Sorry, I started the discussion about good/bad coding style. I don't know why but a lot of the care2x sources seem wired to be and just wanted to get your guys opinion. I do not want to go through each section / philosophy that i disagree which. Maybe even on LD var's it

Re: [Care2002-developers] another file movement

2010-09-21 Thread Gjergj Sheldija - AcmeTECH
Hi Robert, i thought of something more simple in the admin ui. a check for updates button.. and have on the care2x.org site a simple script to reply to call from the sw. the only thing that might cause problems is that we have a mix of writable files inside cache, uploads and such mixed with

Re: [Care2002-developers] another file movement

2010-09-21 Thread Gjergj Sheldija - AcmeTECH
obviously yes gj. On 2010-09-21 9:58.MD, Tim Schofield wrote: Shouldn't the user have a choice about updating, and so would need to know what the update contained? Tim On 21 September 2010 20:50, Gjergj Sheldija - AcmeTECH gjergj.sheld...@gmail.com wrote: Hi Robert, i thought of

Re: [Care2002-developers] another file movement

2010-09-21 Thread Tim Schofield
Then you run the problem of how to deal with the next update that the user might want :-) Tim On 21 September 2010 21:00, Gjergj Sheldija - AcmeTECH gjergj.sheld...@gmail.com wrote:  obviously yes gj. On 2010-09-21 9:58.MD, Tim Schofield wrote: Shouldn't the user have a choice about

Re: [Care2002-developers] another file movement

2010-09-21 Thread Ap.Muthu
Wordpress has some nice code for admin updation. obviously yes gj. On 2010-09-21 9:58.MD, Tim Schofield wrote: Shouldn't the user have a choice about updating, and so would need to know what the update contained? Tim On 21 September 2010 20:50, Gjergj Sheldija - AcmeTECH

[Care2002-developers] ERD - throws up anomaly

2010-09-21 Thread Ap.Muthu
Rough cut of ERD shows only 2 relationships. The code does not respect the relationships however. table care_user_roles Primary Key 'id' is an INT Foreign Key 'user_role' in table care_users is a Tiny INT If the numebr of anticipated roles is going to be 256 then a TinyINT would suffice.

Re: [Care2002-developers] ERD - throws up anomaly

2010-09-21 Thread Ap.Muthu
Made it both INT(4) ALTER TABLE `care_users` CHANGE `user_role` `user_role` INT(4) DEFAULT '0' NOT NULL; ALTER TABLE `care_user_roles` CHANGE `id` `id` INT(4) NOT NULL AUTO_INCREMENT; ALTER TABLE `care2x`.`care_yellow_paper` DROP KEY `nr`; SVN 6783 fixed. FK relationships avoided as we need

[Care2002-developers] EDR Part 1

2010-09-21 Thread Ap.Muthu
Attached is Part 1 of the ERD. It is huge. Will accomodate groups as possible. All the 24 care_type_* tables can be strung together to form one table. Regards, Ap.Muthu attachment: ERD-svn-6682-part1.png-- Start

[Care2002-developers] ERD Part II

2010-09-21 Thread Ap.Muthu
Attached is Part 2 of the ERD. All the 24 care_type_* tables can be strung together to form one table. They are listed now - Ap.Muthu -- Start uncovering the many advantages of virtual appliances and start using