Perhaps this will be useful for others.

I needed to be able to convert decimal number to and from the 'local' format. By adding the below methods to my app_model, it is possible to silently convert decimal numbers as they come out of the database to be local format, and vice versa to save. In the code below it is converting numbers of the format 999.999,99 to be 999999.99 - which otherwise would be saved by MySql as 999.99 as the rest of the number is ignored.

1. <?php
2. class AppModel extends
3. Model
4. {
5. // Cheat for UTF-8
6. function __construct()
7. {
8. parent::__construct();
10. $this->execute("Set NAMES 'UTF8'");
11. }
12. function afterFind($results)
13. {
14. foreach
15. ($results as $id=>$objectResult)
16. {
17. foreach ($objectResult as $class=>$fields)
19. {
20. if ($this->name==$class)
21. {
23. $classObject = $this;
24. }
25. else
27. {
28. $classObject = new $class;
29. }
31. foreach($classObject->_tableInfo->value as $fieldDetails)
32. {
34. $fieldName = $fieldDetails['name'];
35. $fieldType = $fieldDetails['type'];
37. if ($fieldType == "float")
38. {
40. if (isset($results[$id][$class][$fieldName]))
41. {
43. $results[$id][$class][$fieldName] = number_format($results[$id][$class][$fieldName], 2, ',', '.');
45. }
46. }
47. }
48. }
49. }
50. return $results;
51. }
52. function
53. beforeSave()
54. {
55. foreach ($this->data as $class=>$fields)
56. {
57. if
58. ($this->name==$class)
59. {
60. $classObject = $this;
62. }
63. else
64. {
65. $classObject = new $class;
67. }
68. foreach($classObject->_tableInfo->value as $fieldDetails)
69. {
71. $fieldName = $fieldDetails['name'];
72. $fieldType = $fieldDetails['type'];
74. if ($fieldType == "float")
75. {
76. if
77. (isset($this->data[$class][$fieldName]))
78. {
80. $this->data[$class][$fieldName] = str_replace(array(".", ","), array("", "."), $this->data[$class][$fieldName]);
82. }
83. }
84. }
85. }
86. return true;
87. }
88. }
89. ?>