Management FLOAT & INT value

[cobalt74]

• [x] Add constant FLOAT (NUMERIC) & INT
• [x] Display cell value - Localisation decimal symbol
• [x] Display cell value - Localisation thousands separator
• [x] Recover cell value - Localisation decimal symbol
• [x] Edit Cell value - Localisation decimal symbol
• [x] Search value - Localisation decimal symbol
• [x] QuickSearch value - Localisation decimal symbol
• [x] Making selectable number of decimal for display
• [x] Add text in json
• [x] Edit line recover value - Localisation decimal symbol
• [x] Error message for edit cell (INT, FLOAT)
• [x] For all update mode : Replace localized thousand symbol by nothing

changes related

• [x] Update column of lisha_language (varchar(1)) for accept space char

Bugs

• [x] Not Display 0,00 when value is null
• [x] Refresh lost float specifique lisha configuration

[chezbas]

Update cell mode doesn't check control on INT type

Unit test case: Define a column with INT feature add a new row ( control ok ) Try to update straight on cell ==> update done Expected results : Error message

[cobalt74]

@chezbas est ce que tu peux ajouter à la table lisha_language

• le champ : number_of_decimal INT(2) - défaut 2 ?

[chezbas]

Ok, c’est fait J’ai supprimé la table lisha_text et activé l'utilisation des fichiers xxx.json j’ai renommé la table lisha_language en lisha_i18n Bref.. have fun Le 5 nov. 2013 à 22:40, Cobalt74 notifications@github.com a écrit :

@chezbas est ce que tu peux ajouter à la table lisha_language

le champ : number_of_decimal INT(2) ? — Reply to this email directly or view it on GitHub.

[cobalt74]

Pour récapituler, il faut :

• changer les main_configuration.php de tous les projets

define("__LISHA_TABLE_LOCALIZATION__","lisha_i18n");    // Localization information

Pour le raccourcis de la doc ?

[chezbas]

Cell update Test case : On a FLOAT column type $obj_lisha_tran>define_column("transaction.my_numeric",'my_numeric','MyNum',FLOAT,WRAP,LEFT); $obj_lisha_tran->define_attribute('__column_number_of_decimal', 7,'my_numeric');

Input value "123" and validate Input value "a" straight in cell and validate

Result recorded is 0

Expected results : Error message as in line update that said : You have to input a numeric value !! Escape key exit cells update mode and return to display

[chezbas]

Have to enable NULL feature on numeric column if you want to display blank

[chezbas]

Row update input NULL value rise a unexpected message error

[chezbas]

Display bug: Test case on e dit line mode : choose a line with decimal value data recover in input field is not localized Here below an example

[cobalt74]

ouep je sais !! :) il reste ça : Edit line recover value - Localisation decimal symbol

[cobalt74]

faudra faire des fonctions dans chaque classe BDD pour être plus propre.

[chezbas]

Yes sir, A clean pass to do for a lot of things ;)

[chezbas]

Have a bug

Test case Edit line mode with numeric column Clear content and check update box Press enter to record modification rise an error

Error_log file side rise a notice on query error UPDATE transaction SET my_numeric = WHERE (index = "3")