@@ -1,267 +1,267 @@ |
||
| 1 | 1 | <?php |
| 2 | - /** |
|
| 3 | - * TNH Framework |
|
| 4 | - * |
|
| 5 | - * A simple PHP framework using HMVC architecture |
|
| 6 | - * |
|
| 7 | - * This content is released under the GNU GPL License (GPL) |
|
| 8 | - * |
|
| 9 | - * Copyright (C) 2017 Tony NGUEREZA |
|
| 10 | - * |
|
| 11 | - * This program is free software; you can redistribute it and/or |
|
| 12 | - * modify it under the terms of the GNU General Public License |
|
| 13 | - * as published by the Free Software Foundation; either version 3 |
|
| 14 | - * of the License, or (at your option) any later version. |
|
| 15 | - * |
|
| 16 | - * This program is distributed in the hope that it will be useful, |
|
| 17 | - * but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 18 | - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 19 | - * GNU General Public License for more details. |
|
| 20 | - * |
|
| 21 | - * You should have received a copy of the GNU General Public License |
|
| 22 | - * along with this program; if not, write to the Free Software |
|
| 23 | - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
|
| 24 | - */ |
|
| 2 | + /** |
|
| 3 | + * TNH Framework |
|
| 4 | + * |
|
| 5 | + * A simple PHP framework using HMVC architecture |
|
| 6 | + * |
|
| 7 | + * This content is released under the GNU GPL License (GPL) |
|
| 8 | + * |
|
| 9 | + * Copyright (C) 2017 Tony NGUEREZA |
|
| 10 | + * |
|
| 11 | + * This program is free software; you can redistribute it and/or |
|
| 12 | + * modify it under the terms of the GNU General Public License |
|
| 13 | + * as published by the Free Software Foundation; either version 3 |
|
| 14 | + * of the License, or (at your option) any later version. |
|
| 15 | + * |
|
| 16 | + * This program is distributed in the hope that it will be useful, |
|
| 17 | + * but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 18 | + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 19 | + * GNU General Public License for more details. |
|
| 20 | + * |
|
| 21 | + * You should have received a copy of the GNU General Public License |
|
| 22 | + * along with this program; if not, write to the Free Software |
|
| 23 | + * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
|
| 24 | + */ |
|
| 25 | 25 | |
| 26 | - /** |
|
| 27 | - * the directory separator, under windows it is \ and unix, linux / |
|
| 28 | - */ |
|
| 29 | - define('DS', DIRECTORY_SEPARATOR); |
|
| 26 | + /** |
|
| 27 | + * the directory separator, under windows it is \ and unix, linux / |
|
| 28 | + */ |
|
| 29 | + define('DS', DIRECTORY_SEPARATOR); |
|
| 30 | 30 | |
| 31 | - /** |
|
| 32 | - * The root directory of the application. |
|
| 33 | - * |
|
| 34 | - * you can place this directory outside of your web directory, for example "/home/your_app", etc. |
|
| 35 | - */ |
|
| 36 | - define('ROOT_PATH', dirname(realpath(__FILE__)) . DS); |
|
| 31 | + /** |
|
| 32 | + * The root directory of the application. |
|
| 33 | + * |
|
| 34 | + * you can place this directory outside of your web directory, for example "/home/your_app", etc. |
|
| 35 | + */ |
|
| 36 | + define('ROOT_PATH', dirname(realpath(__FILE__)) . DS); |
|
| 37 | 37 | |
| 38 | - /** |
|
| 39 | - * The path to the directory. |
|
| 40 | - * |
|
| 41 | - * That contains your static files (javascript, css, images, etc.) |
|
| 42 | - * Note: the path must be relative to the file index.php (the front-end controller). |
|
| 43 | - */ |
|
| 44 | - define('ASSETS_PATH', 'assets/'); |
|
| 38 | + /** |
|
| 39 | + * The path to the directory. |
|
| 40 | + * |
|
| 41 | + * That contains your static files (javascript, css, images, etc.) |
|
| 42 | + * Note: the path must be relative to the file index.php (the front-end controller). |
|
| 43 | + */ |
|
| 44 | + define('ASSETS_PATH', 'assets/'); |
|
| 45 | 45 | |
| 46 | - /** |
|
| 47 | - * The path to the directory of your cache files. |
|
| 48 | - * |
|
| 49 | - * This feature is available currently for database and views. |
|
| 50 | - */ |
|
| 51 | - define('CACHE_PATH', ROOT_PATH . 'cache' . DS); |
|
| 46 | + /** |
|
| 47 | + * The path to the directory of your cache files. |
|
| 48 | + * |
|
| 49 | + * This feature is available currently for database and views. |
|
| 50 | + */ |
|
| 51 | + define('CACHE_PATH', ROOT_PATH . 'cache' . DS); |
|
| 52 | 52 | |
| 53 | - /** |
|
| 54 | - * The path to the application directory. |
|
| 55 | - * |
|
| 56 | - * It contains your most often used files that is to say which contains your files of the application, |
|
| 57 | - * in MVC architecture (controllers, models, views). |
|
| 58 | - */ |
|
| 59 | - define('APPS_PATH', ROOT_PATH . 'classes' . DS); |
|
| 53 | + /** |
|
| 54 | + * The path to the application directory. |
|
| 55 | + * |
|
| 56 | + * It contains your most often used files that is to say which contains your files of the application, |
|
| 57 | + * in MVC architecture (controllers, models, views). |
|
| 58 | + */ |
|
| 59 | + define('APPS_PATH', ROOT_PATH . 'classes' . DS); |
|
| 60 | 60 | |
| 61 | - /** |
|
| 62 | - * The path to the controller directory of your application. |
|
| 63 | - * |
|
| 64 | - * If you already know the MVC architecture you know what a controller means; |
|
| 65 | - * it is he who makes the business logic of your application in general. |
|
| 66 | - */ |
|
| 67 | - define('APPS_CONTROLLER_PATH', APPS_PATH . 'controllers' . DS); |
|
| 61 | + /** |
|
| 62 | + * The path to the controller directory of your application. |
|
| 63 | + * |
|
| 64 | + * If you already know the MVC architecture you know what a controller means; |
|
| 65 | + * it is he who makes the business logic of your application in general. |
|
| 66 | + */ |
|
| 67 | + define('APPS_CONTROLLER_PATH', APPS_PATH . 'controllers' . DS); |
|
| 68 | 68 | |
| 69 | - /** |
|
| 70 | - * The path to the directory of your model classes of your application. |
|
| 71 | - * |
|
| 72 | - * If you already know the MVC architecture you know what a model means; |
|
| 73 | - * it's the one who interacts with the database, in one word persistent data from your application. |
|
| 74 | - */ |
|
| 75 | - define('APPS_MODEL_PATH', APPS_PATH . 'models' . DS); |
|
| 69 | + /** |
|
| 70 | + * The path to the directory of your model classes of your application. |
|
| 71 | + * |
|
| 72 | + * If you already know the MVC architecture you know what a model means; |
|
| 73 | + * it's the one who interacts with the database, in one word persistent data from your application. |
|
| 74 | + */ |
|
| 75 | + define('APPS_MODEL_PATH', APPS_PATH . 'models' . DS); |
|
| 76 | 76 | |
| 77 | - /** |
|
| 78 | - * The path to the directory of your views. |
|
| 79 | - * |
|
| 80 | - * If you already know the MVC architecture you know what a view means, |
|
| 81 | - * a view is just a user interface (html page, form, etc.) that is to say |
|
| 82 | - * everything displayed in the browser interface, etc. |
|
| 83 | - */ |
|
| 84 | - define('APPS_VIEWS_PATH', APPS_PATH . 'views' . DS); |
|
| 77 | + /** |
|
| 78 | + * The path to the directory of your views. |
|
| 79 | + * |
|
| 80 | + * If you already know the MVC architecture you know what a view means, |
|
| 81 | + * a view is just a user interface (html page, form, etc.) that is to say |
|
| 82 | + * everything displayed in the browser interface, etc. |
|
| 83 | + */ |
|
| 84 | + define('APPS_VIEWS_PATH', APPS_PATH . 'views' . DS); |
|
| 85 | 85 | |
| 86 | - /** |
|
| 87 | - * The path to the configuration directory. |
|
| 88 | - * |
|
| 89 | - * That contains most of the configuration files for your |
|
| 90 | - * application (database, class loading file, functions, etc.) |
|
| 91 | - */ |
|
| 92 | - define('CONFIG_PATH', ROOT_PATH . 'config' . DS); |
|
| 86 | + /** |
|
| 87 | + * The path to the configuration directory. |
|
| 88 | + * |
|
| 89 | + * That contains most of the configuration files for your |
|
| 90 | + * application (database, class loading file, functions, etc.) |
|
| 91 | + */ |
|
| 92 | + define('CONFIG_PATH', ROOT_PATH . 'config' . DS); |
|
| 93 | 93 | |
| 94 | - /** |
|
| 95 | - * The core directory |
|
| 96 | - * |
|
| 97 | - * It is recommended to put this folder out of the web directory of your server and |
|
| 98 | - * you should not change its content because in case of update you could lose the modified files. |
|
| 99 | - */ |
|
| 100 | - define('CORE_PATH', ROOT_PATH . 'core' . DS); |
|
| 94 | + /** |
|
| 95 | + * The core directory |
|
| 96 | + * |
|
| 97 | + * It is recommended to put this folder out of the web directory of your server and |
|
| 98 | + * you should not change its content because in case of update you could lose the modified files. |
|
| 99 | + */ |
|
| 100 | + define('CORE_PATH', ROOT_PATH . 'core' . DS); |
|
| 101 | 101 | |
| 102 | - /** |
|
| 103 | - * The path to the directory of core classes that used by the system. |
|
| 104 | - * |
|
| 105 | - * It contains PHP classes that are used by the framework internally. |
|
| 106 | - */ |
|
| 107 | - define('CORE_CLASSES_PATH', CORE_PATH . 'classes' . DS); |
|
| 102 | + /** |
|
| 103 | + * The path to the directory of core classes that used by the system. |
|
| 104 | + * |
|
| 105 | + * It contains PHP classes that are used by the framework internally. |
|
| 106 | + */ |
|
| 107 | + define('CORE_CLASSES_PATH', CORE_PATH . 'classes' . DS); |
|
| 108 | 108 | |
| 109 | - /** |
|
| 110 | - * The path to the directory of core classes for the cache used by the system. |
|
| 111 | - * |
|
| 112 | - * It contains PHP classes for the cache drivers. |
|
| 113 | - */ |
|
| 114 | - define('CORE_CLASSES_CACHE_PATH', CORE_CLASSES_PATH . 'cache' . DS); |
|
| 109 | + /** |
|
| 110 | + * The path to the directory of core classes for the cache used by the system. |
|
| 111 | + * |
|
| 112 | + * It contains PHP classes for the cache drivers. |
|
| 113 | + */ |
|
| 114 | + define('CORE_CLASSES_CACHE_PATH', CORE_CLASSES_PATH . 'cache' . DS); |
|
| 115 | 115 | |
| 116 | 116 | /** |
| 117 | - * The path to the directory of core classes for the database used by the system. |
|
| 118 | - * |
|
| 119 | - * It contains PHP classes for the database library, drivers, etc. |
|
| 120 | - */ |
|
| 121 | - define('CORE_CLASSES_DATABASE_PATH', CORE_CLASSES_PATH . 'database' . DS); |
|
| 117 | + * The path to the directory of core classes for the database used by the system. |
|
| 118 | + * |
|
| 119 | + * It contains PHP classes for the database library, drivers, etc. |
|
| 120 | + */ |
|
| 121 | + define('CORE_CLASSES_DATABASE_PATH', CORE_CLASSES_PATH . 'database' . DS); |
|
| 122 | 122 | |
| 123 | - /** |
|
| 124 | - * The path to the directory of core classes for the model used by the system. |
|
| 125 | - * |
|
| 126 | - * It contains PHP classes for the models. |
|
| 127 | - */ |
|
| 128 | - define('CORE_CLASSES_MODEL_PATH', CORE_CLASSES_PATH . 'model' . DS); |
|
| 123 | + /** |
|
| 124 | + * The path to the directory of core classes for the model used by the system. |
|
| 125 | + * |
|
| 126 | + * It contains PHP classes for the models. |
|
| 127 | + */ |
|
| 128 | + define('CORE_CLASSES_MODEL_PATH', CORE_CLASSES_PATH . 'model' . DS); |
|
| 129 | 129 | |
| 130 | - /** |
|
| 131 | - * The path to the directory of functions or helper systems. |
|
| 132 | - * |
|
| 133 | - * It contains PHP functions that perform a particular task: character string processing, URL, etc. |
|
| 134 | - */ |
|
| 135 | - define('CORE_FUNCTIONS_PATH', CORE_PATH . 'functions' . DS); |
|
| 130 | + /** |
|
| 131 | + * The path to the directory of functions or helper systems. |
|
| 132 | + * |
|
| 133 | + * It contains PHP functions that perform a particular task: character string processing, URL, etc. |
|
| 134 | + */ |
|
| 135 | + define('CORE_FUNCTIONS_PATH', CORE_PATH . 'functions' . DS); |
|
| 136 | 136 | |
| 137 | - /** |
|
| 138 | - * The path to the core directory of languages files. |
|
| 139 | - * |
|
| 140 | - */ |
|
| 141 | - define('CORE_LANG_PATH', CORE_PATH . 'lang' . DS); |
|
| 137 | + /** |
|
| 138 | + * The path to the core directory of languages files. |
|
| 139 | + * |
|
| 140 | + */ |
|
| 141 | + define('CORE_LANG_PATH', CORE_PATH . 'lang' . DS); |
|
| 142 | 142 | |
| 143 | - /** |
|
| 144 | - * The path to the system library directory. |
|
| 145 | - * |
|
| 146 | - * Which contains the libraries most often used in your web application, as for the |
|
| 147 | - * core directory it is advisable to put it out of the root directory of your application. |
|
| 148 | - */ |
|
| 149 | - define('CORE_LIBRARY_PATH', CORE_PATH . 'libraries' . DS); |
|
| 143 | + /** |
|
| 144 | + * The path to the system library directory. |
|
| 145 | + * |
|
| 146 | + * Which contains the libraries most often used in your web application, as for the |
|
| 147 | + * core directory it is advisable to put it out of the root directory of your application. |
|
| 148 | + */ |
|
| 149 | + define('CORE_LIBRARY_PATH', CORE_PATH . 'libraries' . DS); |
|
| 150 | 150 | |
| 151 | - /** |
|
| 152 | - * The path to the system view directory. |
|
| 153 | - * |
|
| 154 | - * That contains the views used for the system, such as error messages, and so on. |
|
| 155 | - */ |
|
| 156 | - define('CORE_VIEWS_PATH', CORE_PATH . 'views' . DS); |
|
| 151 | + /** |
|
| 152 | + * The path to the system view directory. |
|
| 153 | + * |
|
| 154 | + * That contains the views used for the system, such as error messages, and so on. |
|
| 155 | + */ |
|
| 156 | + define('CORE_VIEWS_PATH', CORE_PATH . 'views' . DS); |
|
| 157 | 157 | |
| 158 | - /** |
|
| 159 | - * The path to the directory of your PHP personal functions or helper. |
|
| 160 | - * |
|
| 161 | - * It contains your PHP functions that perform a particular task: utilities, etc. |
|
| 162 | - * Note: Do not put your personal functions or helpers in the system functions directory, |
|
| 163 | - * because if you update the system you may lose them. |
|
| 164 | - */ |
|
| 165 | - define('FUNCTIONS_PATH', ROOT_PATH . 'functions' . DS); |
|
| 158 | + /** |
|
| 159 | + * The path to the directory of your PHP personal functions or helper. |
|
| 160 | + * |
|
| 161 | + * It contains your PHP functions that perform a particular task: utilities, etc. |
|
| 162 | + * Note: Do not put your personal functions or helpers in the system functions directory, |
|
| 163 | + * because if you update the system you may lose them. |
|
| 164 | + */ |
|
| 165 | + define('FUNCTIONS_PATH', ROOT_PATH . 'functions' . DS); |
|
| 166 | 166 | |
| 167 | - /** |
|
| 168 | - * The path to the app directory of personal language. |
|
| 169 | - * |
|
| 170 | - * This feature is not yet available. |
|
| 171 | - * You can help us do this if you are nice or wish to see the developed framework. |
|
| 172 | - */ |
|
| 173 | - define('APP_LANG_PATH', ROOT_PATH . 'lang' . DS); |
|
| 167 | + /** |
|
| 168 | + * The path to the app directory of personal language. |
|
| 169 | + * |
|
| 170 | + * This feature is not yet available. |
|
| 171 | + * You can help us do this if you are nice or wish to see the developed framework. |
|
| 172 | + */ |
|
| 173 | + define('APP_LANG_PATH', ROOT_PATH . 'lang' . DS); |
|
| 174 | 174 | |
| 175 | - /** |
|
| 176 | - * The path to the directory of your personal libraries |
|
| 177 | - * |
|
| 178 | - * It contains your PHP classes, package, etc. |
|
| 179 | - * Note: you should not put your personal libraries in the system library directory, |
|
| 180 | - * because it is recalled in case of updating the system you might have surprises. |
|
| 181 | - */ |
|
| 182 | - define('LIBRARY_PATH', ROOT_PATH . 'libraries' . DS); |
|
| 175 | + /** |
|
| 176 | + * The path to the directory of your personal libraries |
|
| 177 | + * |
|
| 178 | + * It contains your PHP classes, package, etc. |
|
| 179 | + * Note: you should not put your personal libraries in the system library directory, |
|
| 180 | + * because it is recalled in case of updating the system you might have surprises. |
|
| 181 | + */ |
|
| 182 | + define('LIBRARY_PATH', ROOT_PATH . 'libraries' . DS); |
|
| 183 | 183 | |
| 184 | - /** |
|
| 185 | - * The path to the directory that contains the log files. |
|
| 186 | - * |
|
| 187 | - * Note: This directory must be available in writing and if possible must have as owner the user who launches your web server, |
|
| 188 | - * under unix or linux most often with the apache web server it is "www-data" or "httpd" even "nobody" for more |
|
| 189 | - * details see the documentation of your web server. |
|
| 190 | - * Example for Unix or linux with apache web server: |
|
| 191 | - * # chmod -R 700 /path/to/your/logs/directory/ |
|
| 192 | - * # chown -R www-data:www-data /path/to/your/logs/directory/ |
|
| 193 | - */ |
|
| 194 | - define('LOGS_PATH', ROOT_PATH . 'logs' . DS); |
|
| 184 | + /** |
|
| 185 | + * The path to the directory that contains the log files. |
|
| 186 | + * |
|
| 187 | + * Note: This directory must be available in writing and if possible must have as owner the user who launches your web server, |
|
| 188 | + * under unix or linux most often with the apache web server it is "www-data" or "httpd" even "nobody" for more |
|
| 189 | + * details see the documentation of your web server. |
|
| 190 | + * Example for Unix or linux with apache web server: |
|
| 191 | + * # chmod -R 700 /path/to/your/logs/directory/ |
|
| 192 | + * # chown -R www-data:www-data /path/to/your/logs/directory/ |
|
| 193 | + */ |
|
| 194 | + define('LOGS_PATH', ROOT_PATH . 'logs' . DS); |
|
| 195 | 195 | |
| 196 | - /** |
|
| 197 | - * The path to the modules directory. |
|
| 198 | - * |
|
| 199 | - * It contains your modules used files (config, controllers, libraries, etc.) that is to say which contains your files of the modules, |
|
| 200 | - * in HMVC architecture (hierichical, controllers, models, views). |
|
| 201 | - */ |
|
| 202 | - define('MODULE_PATH', ROOT_PATH . 'modules' . DS); |
|
| 196 | + /** |
|
| 197 | + * The path to the modules directory. |
|
| 198 | + * |
|
| 199 | + * It contains your modules used files (config, controllers, libraries, etc.) that is to say which contains your files of the modules, |
|
| 200 | + * in HMVC architecture (hierichical, controllers, models, views). |
|
| 201 | + */ |
|
| 202 | + define('MODULE_PATH', ROOT_PATH . 'modules' . DS); |
|
| 203 | 203 | |
| 204 | - /** |
|
| 205 | - * The path to the directory of sources external to your application. |
|
| 206 | - * |
|
| 207 | - * If you have already used "composer" you know what that means. |
|
| 208 | - */ |
|
| 209 | - define('VENDOR_PATH', ROOT_PATH . 'vendor' . DS); |
|
| 204 | + /** |
|
| 205 | + * The path to the directory of sources external to your application. |
|
| 206 | + * |
|
| 207 | + * If you have already used "composer" you know what that means. |
|
| 208 | + */ |
|
| 209 | + define('VENDOR_PATH', ROOT_PATH . 'vendor' . DS); |
|
| 210 | 210 | |
| 211 | - /** |
|
| 212 | - * The front controller of your application. |
|
| 213 | - * |
|
| 214 | - * "index.php" it is through this file that all the requests come, there is a possibility to hidden it in the url of |
|
| 215 | - * your application by using the rewrite module URL of your web server . |
|
| 216 | - * For example, under apache web server, there is a configuration example file that is located at the root |
|
| 217 | - * of your framework folder : "htaccess.txt" rename it to ".htaccess". |
|
| 218 | - */ |
|
| 219 | - define('SELF', pathinfo(__FILE__, PATHINFO_BASENAME)); |
|
| 211 | + /** |
|
| 212 | + * The front controller of your application. |
|
| 213 | + * |
|
| 214 | + * "index.php" it is through this file that all the requests come, there is a possibility to hidden it in the url of |
|
| 215 | + * your application by using the rewrite module URL of your web server . |
|
| 216 | + * For example, under apache web server, there is a configuration example file that is located at the root |
|
| 217 | + * of your framework folder : "htaccess.txt" rename it to ".htaccess". |
|
| 218 | + */ |
|
| 219 | + define('SELF', pathinfo(__FILE__, PATHINFO_BASENAME)); |
|
| 220 | 220 | |
| 221 | - /** |
|
| 222 | - * Check if user run the application under CLI |
|
| 223 | - */ |
|
| 224 | - define('IS_CLI', stripos('cli', php_sapi_name()) !== false); |
|
| 221 | + /** |
|
| 222 | + * Check if user run the application under CLI |
|
| 223 | + */ |
|
| 224 | + define('IS_CLI', stripos('cli', php_sapi_name()) !== false); |
|
| 225 | 225 | |
| 226 | - /** |
|
| 227 | - * The environment of your application (production, test, development). |
|
| 228 | - * |
|
| 229 | - * if your application is still in development you use the value "development" |
|
| 230 | - * so you will have the display of the error messages, etc. |
|
| 231 | - * Once you finish the development of your application that is to put it online |
|
| 232 | - * you change this value to "production" or "testing", in this case there will be deactivation of error messages, |
|
| 233 | - * the loading of the system, will be fast. |
|
| 234 | - */ |
|
| 235 | - define('ENVIRONMENT', 'development'); |
|
| 226 | + /** |
|
| 227 | + * The environment of your application (production, test, development). |
|
| 228 | + * |
|
| 229 | + * if your application is still in development you use the value "development" |
|
| 230 | + * so you will have the display of the error messages, etc. |
|
| 231 | + * Once you finish the development of your application that is to put it online |
|
| 232 | + * you change this value to "production" or "testing", in this case there will be deactivation of error messages, |
|
| 233 | + * the loading of the system, will be fast. |
|
| 234 | + */ |
|
| 235 | + define('ENVIRONMENT', 'development'); |
|
| 236 | 236 | |
| 237 | - /* ---------------------------------------------------------------------------------- */ |
|
| 238 | - /////////////////////////////////////////////////////////////////////////////////////// |
|
| 239 | - /******************** DO NOT CHANGE THE LINES BELOW *********************************/ |
|
| 240 | - ///////////////////////////////////////////////////////////////////////////////////// |
|
| 237 | + /* ---------------------------------------------------------------------------------- */ |
|
| 238 | + /////////////////////////////////////////////////////////////////////////////////////// |
|
| 239 | + /******************** DO NOT CHANGE THE LINES BELOW *********************************/ |
|
| 240 | + ///////////////////////////////////////////////////////////////////////////////////// |
|
| 241 | 241 | |
| 242 | - switch (ENVIRONMENT) { |
|
| 243 | - case 'development': |
|
| 244 | - error_reporting(-1); |
|
| 245 | - ini_set('display_errors', 1); |
|
| 246 | - break; |
|
| 247 | - case 'testing': |
|
| 248 | - case 'production': |
|
| 249 | - ini_set('display_errors', 0); |
|
| 250 | - if (version_compare(PHP_VERSION, '5.3', '>=')) { |
|
| 251 | - error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT & ~E_USER_NOTICE & ~E_USER_DEPRECATED); |
|
| 252 | - } |
|
| 253 | - else { |
|
| 254 | - error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_USER_NOTICE); |
|
| 255 | - } |
|
| 256 | - break; |
|
| 257 | - default: |
|
| 258 | - header('HTTP/1.1 503 Service Unavailable.', TRUE, 503); |
|
| 259 | - echo 'The application environment is not set correctly.'; |
|
| 260 | - exit(1); |
|
| 261 | - } |
|
| 242 | + switch (ENVIRONMENT) { |
|
| 243 | + case 'development': |
|
| 244 | + error_reporting(-1); |
|
| 245 | + ini_set('display_errors', 1); |
|
| 246 | + break; |
|
| 247 | + case 'testing': |
|
| 248 | + case 'production': |
|
| 249 | + ini_set('display_errors', 0); |
|
| 250 | + if (version_compare(PHP_VERSION, '5.3', '>=')) { |
|
| 251 | + error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT & ~E_USER_NOTICE & ~E_USER_DEPRECATED); |
|
| 252 | + } |
|
| 253 | + else { |
|
| 254 | + error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_USER_NOTICE); |
|
| 255 | + } |
|
| 256 | + break; |
|
| 257 | + default: |
|
| 258 | + header('HTTP/1.1 503 Service Unavailable.', TRUE, 503); |
|
| 259 | + echo 'The application environment is not set correctly.'; |
|
| 260 | + exit(1); |
|
| 261 | + } |
|
| 262 | 262 | |
| 263 | - /** |
|
| 264 | - * let's go. |
|
| 265 | - * Everything is OK now we launch our application. |
|
| 266 | - */ |
|
| 267 | - require_once CORE_PATH . 'bootstrap.php'; |
|
| 268 | 263 | \ No newline at end of file |
| 264 | + /** |
|
| 265 | + * let's go. |
|
| 266 | + * Everything is OK now we launch our application. |
|
| 267 | + */ |
|
| 268 | + require_once CORE_PATH . 'bootstrap.php'; |
|
| 269 | 269 | \ No newline at end of file |
@@ -249,8 +249,7 @@ |
||
| 249 | 249 | ini_set('display_errors', 0); |
| 250 | 250 | if (version_compare(PHP_VERSION, '5.3', '>=')) { |
| 251 | 251 | error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT & ~E_USER_NOTICE & ~E_USER_DEPRECATED); |
| 252 | - } |
|
| 253 | - else { |
|
| 252 | + } else { |
|
| 254 | 253 | error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_USER_NOTICE); |
| 255 | 254 | } |
| 256 | 255 | break; |
@@ -22,251 +22,251 @@ |
||
| 22 | 22 | * You should have received a copy of the GNU General Public License |
| 23 | 23 | * along with this program; if not, write to the Free Software |
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | - */ |
|
| 25 | + */ |
|
| 26 | 26 | |
| 27 | - class Module extends BaseStaticClass { |
|
| 27 | + class Module extends BaseStaticClass { |
|
| 28 | 28 | |
| 29 | - /** |
|
| 30 | - * list of loaded module |
|
| 31 | - * @var array |
|
| 32 | - */ |
|
| 33 | - private static $list = array(); |
|
| 29 | + /** |
|
| 30 | + * list of loaded module |
|
| 31 | + * @var array |
|
| 32 | + */ |
|
| 33 | + private static $list = array(); |
|
| 34 | 34 | |
| 35 | - /** |
|
| 36 | - * Initialise the module list by scanning the directory MODULE_PATH |
|
| 37 | - */ |
|
| 38 | - public function init(){ |
|
| 39 | - $logger = self::getLogger(); |
|
| 40 | - $logger->debug('Check if the application contains the modules ...'); |
|
| 41 | - $moduleDir = opendir(MODULE_PATH); |
|
| 42 | - if (is_resource($moduleDir)){ |
|
| 43 | - while(($module = readdir($moduleDir)) !== false){ |
|
| 44 | - if (preg_match('/^([a-z0-9-_]+)$/i', $module) && is_dir(MODULE_PATH . $module)){ |
|
| 45 | - self::$list[] = $module; |
|
| 46 | - } else{ |
|
| 47 | - $logger->info('Skipping [' .$module. '], may be this is not a directory or does not exists or is invalid name'); |
|
| 48 | - } |
|
| 49 | - } |
|
| 50 | - closedir($moduleDir); |
|
| 51 | - } |
|
| 52 | - ksort(self::$list); |
|
| 35 | + /** |
|
| 36 | + * Initialise the module list by scanning the directory MODULE_PATH |
|
| 37 | + */ |
|
| 38 | + public function init(){ |
|
| 39 | + $logger = self::getLogger(); |
|
| 40 | + $logger->debug('Check if the application contains the modules ...'); |
|
| 41 | + $moduleDir = opendir(MODULE_PATH); |
|
| 42 | + if (is_resource($moduleDir)){ |
|
| 43 | + while(($module = readdir($moduleDir)) !== false){ |
|
| 44 | + if (preg_match('/^([a-z0-9-_]+)$/i', $module) && is_dir(MODULE_PATH . $module)){ |
|
| 45 | + self::$list[] = $module; |
|
| 46 | + } else{ |
|
| 47 | + $logger->info('Skipping [' .$module. '], may be this is not a directory or does not exists or is invalid name'); |
|
| 48 | + } |
|
| 49 | + } |
|
| 50 | + closedir($moduleDir); |
|
| 51 | + } |
|
| 52 | + ksort(self::$list); |
|
| 53 | 53 | |
| 54 | - if (! empty(self::$list)){ |
|
| 55 | - $logger->info('The application contains the module below [' . implode(', ', self::getModuleList()) . ']'); |
|
| 56 | - } |
|
| 57 | - } |
|
| 54 | + if (! empty(self::$list)){ |
|
| 55 | + $logger->info('The application contains the module below [' . implode(', ', self::getModuleList()) . ']'); |
|
| 56 | + } |
|
| 57 | + } |
|
| 58 | 58 | |
| 59 | 59 | |
| 60 | - /** |
|
| 61 | - * Add new module in the list |
|
| 62 | - * @param string $name the name of the module |
|
| 63 | - * |
|
| 64 | - * @return object the current instance |
|
| 65 | - */ |
|
| 66 | - public function add($name) { |
|
| 67 | - self::$list[] = $name; |
|
| 68 | - return $this; |
|
| 69 | - } |
|
| 60 | + /** |
|
| 61 | + * Add new module in the list |
|
| 62 | + * @param string $name the name of the module |
|
| 63 | + * |
|
| 64 | + * @return object the current instance |
|
| 65 | + */ |
|
| 66 | + public function add($name) { |
|
| 67 | + self::$list[] = $name; |
|
| 68 | + return $this; |
|
| 69 | + } |
|
| 70 | 70 | |
| 71 | - /** |
|
| 72 | - * Get the list of the custom autoload configuration from module if exists |
|
| 73 | - * @return array|boolean the autoload configurations list or false if no module contains the autoload configuration values |
|
| 74 | - */ |
|
| 75 | - public static function getModulesAutoloadConfig() { |
|
| 76 | - $logger = self::getLogger(); |
|
| 77 | - if (empty(self::$list)) { |
|
| 78 | - $logger->info('No module was loaded skipping.'); |
|
| 79 | - return false; |
|
| 80 | - } |
|
| 81 | - $autoloads = array(); |
|
| 82 | - $autoloads['libraries'] = array(); |
|
| 83 | - $autoloads['config'] = array(); |
|
| 84 | - $autoloads['models'] = array(); |
|
| 85 | - $autoloads['functions'] = array(); |
|
| 86 | - $autoloads['languages'] = array(); |
|
| 71 | + /** |
|
| 72 | + * Get the list of the custom autoload configuration from module if exists |
|
| 73 | + * @return array|boolean the autoload configurations list or false if no module contains the autoload configuration values |
|
| 74 | + */ |
|
| 75 | + public static function getModulesAutoloadConfig() { |
|
| 76 | + $logger = self::getLogger(); |
|
| 77 | + if (empty(self::$list)) { |
|
| 78 | + $logger->info('No module was loaded skipping.'); |
|
| 79 | + return false; |
|
| 80 | + } |
|
| 81 | + $autoloads = array(); |
|
| 82 | + $autoloads['libraries'] = array(); |
|
| 83 | + $autoloads['config'] = array(); |
|
| 84 | + $autoloads['models'] = array(); |
|
| 85 | + $autoloads['functions'] = array(); |
|
| 86 | + $autoloads['languages'] = array(); |
|
| 87 | 87 | |
| 88 | - foreach (self::$list as $module) { |
|
| 89 | - $file = MODULE_PATH . $module . DS . 'config' . DS . 'autoload.php'; |
|
| 90 | - if (file_exists($file)) { |
|
| 91 | - $autoload = array(); |
|
| 92 | - require_once $file; |
|
| 93 | - if (!empty($autoload) && is_array($autoload)) { |
|
| 94 | - $autoloads = array_merge_recursive($autoloads, $autoload); |
|
| 95 | - unset($autoload); |
|
| 96 | - } |
|
| 97 | - } |
|
| 98 | - } |
|
| 99 | - return $autoloads; |
|
| 100 | - } |
|
| 88 | + foreach (self::$list as $module) { |
|
| 89 | + $file = MODULE_PATH . $module . DS . 'config' . DS . 'autoload.php'; |
|
| 90 | + if (file_exists($file)) { |
|
| 91 | + $autoload = array(); |
|
| 92 | + require_once $file; |
|
| 93 | + if (!empty($autoload) && is_array($autoload)) { |
|
| 94 | + $autoloads = array_merge_recursive($autoloads, $autoload); |
|
| 95 | + unset($autoload); |
|
| 96 | + } |
|
| 97 | + } |
|
| 98 | + } |
|
| 99 | + return $autoloads; |
|
| 100 | + } |
|
| 101 | 101 | |
| 102 | - /** |
|
| 103 | - * Get the list of the custom routes configuration from module if exists |
|
| 104 | - * @return array|boolean the routes list or false if no module contains the routes configuration |
|
| 105 | - */ |
|
| 106 | - public static function getModulesRoutesConfig() { |
|
| 107 | - $logger = self::getLogger(); |
|
| 108 | - if (empty(self::$list)) { |
|
| 109 | - $logger->info('No module was loaded skipping.'); |
|
| 110 | - return false; |
|
| 111 | - } |
|
| 112 | - $routes = array(); |
|
| 113 | - foreach (self::$list as $module) { |
|
| 114 | - $file = MODULE_PATH . $module . DS . 'config' . DS . 'routes.php'; |
|
| 115 | - if (file_exists($file)) { |
|
| 116 | - $route = array(); |
|
| 117 | - require_once $file; |
|
| 118 | - if (!empty($route) && is_array($route)) { |
|
| 119 | - $routes = array_merge($routes, $route); |
|
| 120 | - unset($route); |
|
| 121 | - } |
|
| 122 | - } |
|
| 123 | - } |
|
| 124 | - return $routes; |
|
| 125 | - } |
|
| 102 | + /** |
|
| 103 | + * Get the list of the custom routes configuration from module if exists |
|
| 104 | + * @return array|boolean the routes list or false if no module contains the routes configuration |
|
| 105 | + */ |
|
| 106 | + public static function getModulesRoutesConfig() { |
|
| 107 | + $logger = self::getLogger(); |
|
| 108 | + if (empty(self::$list)) { |
|
| 109 | + $logger->info('No module was loaded skipping.'); |
|
| 110 | + return false; |
|
| 111 | + } |
|
| 112 | + $routes = array(); |
|
| 113 | + foreach (self::$list as $module) { |
|
| 114 | + $file = MODULE_PATH . $module . DS . 'config' . DS . 'routes.php'; |
|
| 115 | + if (file_exists($file)) { |
|
| 116 | + $route = array(); |
|
| 117 | + require_once $file; |
|
| 118 | + if (!empty($route) && is_array($route)) { |
|
| 119 | + $routes = array_merge($routes, $route); |
|
| 120 | + unset($route); |
|
| 121 | + } |
|
| 122 | + } |
|
| 123 | + } |
|
| 124 | + return $routes; |
|
| 125 | + } |
|
| 126 | 126 | |
| 127 | 127 | |
| 128 | - /** |
|
| 129 | - * Check if in module list can have this controller |
|
| 130 | - * @see Module::findClassInModuleFullFilePath |
|
| 131 | - * @return boolean|string false or null if no module have this controller, path the full path of the controller |
|
| 132 | - */ |
|
| 133 | - public static function findControllerFullPath($class, $module = null) { |
|
| 134 | - return self::findClassInModuleFullFilePath($class, $module, 'controllers'); |
|
| 135 | - } |
|
| 128 | + /** |
|
| 129 | + * Check if in module list can have this controller |
|
| 130 | + * @see Module::findClassInModuleFullFilePath |
|
| 131 | + * @return boolean|string false or null if no module have this controller, path the full path of the controller |
|
| 132 | + */ |
|
| 133 | + public static function findControllerFullPath($class, $module = null) { |
|
| 134 | + return self::findClassInModuleFullFilePath($class, $module, 'controllers'); |
|
| 135 | + } |
|
| 136 | 136 | |
| 137 | - /** |
|
| 138 | - * Check if in module list can have this model |
|
| 139 | - * @see Module::findClassInModuleFullFilePath |
|
| 140 | - * @return boolean|string false or null if no module have this model, return the full path of this model |
|
| 141 | - */ |
|
| 142 | - public static function findModelFullPath($class, $module = null) { |
|
| 143 | - return self::findClassInModuleFullFilePath($class, $module, 'models'); |
|
| 144 | - } |
|
| 137 | + /** |
|
| 138 | + * Check if in module list can have this model |
|
| 139 | + * @see Module::findClassInModuleFullFilePath |
|
| 140 | + * @return boolean|string false or null if no module have this model, return the full path of this model |
|
| 141 | + */ |
|
| 142 | + public static function findModelFullPath($class, $module = null) { |
|
| 143 | + return self::findClassInModuleFullFilePath($class, $module, 'models'); |
|
| 144 | + } |
|
| 145 | 145 | |
| 146 | - /** |
|
| 147 | - * Check if in module list can have this library |
|
| 148 | - * @see Module::findClassInModuleFullFilePath |
|
| 149 | - * @return boolean|string false or null if no module have this library, return the full path of this library |
|
| 150 | - */ |
|
| 151 | - public static function findLibraryFullPath($class, $module = null) { |
|
| 152 | - return self::findClassInModuleFullFilePath($class, $module, 'libraries'); |
|
| 153 | - } |
|
| 146 | + /** |
|
| 147 | + * Check if in module list can have this library |
|
| 148 | + * @see Module::findClassInModuleFullFilePath |
|
| 149 | + * @return boolean|string false or null if no module have this library, return the full path of this library |
|
| 150 | + */ |
|
| 151 | + public static function findLibraryFullPath($class, $module = null) { |
|
| 152 | + return self::findClassInModuleFullFilePath($class, $module, 'libraries'); |
|
| 153 | + } |
|
| 154 | 154 | |
| 155 | 155 | |
| 156 | - /** |
|
| 157 | - * Check if in module list can have this config |
|
| 158 | - * @see Module::findNonClassInModuleFullFilePath |
|
| 159 | - * @return boolean|string false or null if no module have this configuration, return the full path of this configuration |
|
| 160 | - */ |
|
| 161 | - public static function findConfigFullPath($configuration, $module = null) { |
|
| 162 | - return self::findNonClassInModuleFullFilePath($configuration, $module, 'config'); |
|
| 163 | - } |
|
| 156 | + /** |
|
| 157 | + * Check if in module list can have this config |
|
| 158 | + * @see Module::findNonClassInModuleFullFilePath |
|
| 159 | + * @return boolean|string false or null if no module have this configuration, return the full path of this configuration |
|
| 160 | + */ |
|
| 161 | + public static function findConfigFullPath($configuration, $module = null) { |
|
| 162 | + return self::findNonClassInModuleFullFilePath($configuration, $module, 'config'); |
|
| 163 | + } |
|
| 164 | 164 | |
| 165 | - /** |
|
| 166 | - * Check if in module list can have this helper |
|
| 167 | - * @see Module::findNonClassInModuleFullFilePath |
|
| 168 | - * @return boolean|string false or null if no module have this helper, return the full path of this helper |
|
| 169 | - */ |
|
| 170 | - public static function findFunctionFullPath($helper, $module = null) { |
|
| 171 | - return self::findNonClassInModuleFullFilePath($helper, $module, 'functions'); |
|
| 172 | - } |
|
| 165 | + /** |
|
| 166 | + * Check if in module list can have this helper |
|
| 167 | + * @see Module::findNonClassInModuleFullFilePath |
|
| 168 | + * @return boolean|string false or null if no module have this helper, return the full path of this helper |
|
| 169 | + */ |
|
| 170 | + public static function findFunctionFullPath($helper, $module = null) { |
|
| 171 | + return self::findNonClassInModuleFullFilePath($helper, $module, 'functions'); |
|
| 172 | + } |
|
| 173 | 173 | |
| 174 | - /** |
|
| 175 | - * Check if in module list can have this view |
|
| 176 | - * @see Module::findNonClassInModuleFullFilePath |
|
| 177 | - * @return boolean|string false or null if no module have this view, path the full path of the view |
|
| 178 | - */ |
|
| 179 | - public static function findViewFullPath($view, $module = null) { |
|
| 180 | - return self::findNonClassInModuleFullFilePath($view, $module, 'views'); |
|
| 181 | - } |
|
| 174 | + /** |
|
| 175 | + * Check if in module list can have this view |
|
| 176 | + * @see Module::findNonClassInModuleFullFilePath |
|
| 177 | + * @return boolean|string false or null if no module have this view, path the full path of the view |
|
| 178 | + */ |
|
| 179 | + public static function findViewFullPath($view, $module = null) { |
|
| 180 | + return self::findNonClassInModuleFullFilePath($view, $module, 'views'); |
|
| 181 | + } |
|
| 182 | 182 | |
| 183 | - /** |
|
| 184 | - * Check if in module list can have this language |
|
| 185 | - * @see Module::findNonClassInModuleFullFilePath |
|
| 186 | - * @return boolean|string false or null if no module have this language, return the full path of this language |
|
| 187 | - */ |
|
| 188 | - public static function findLanguageFullPath($language, $appLang, $module = null) { |
|
| 189 | - return self::findNonClassInModuleFullFilePath($language, $module, 'lang', $appLang); |
|
| 190 | - } |
|
| 183 | + /** |
|
| 184 | + * Check if in module list can have this language |
|
| 185 | + * @see Module::findNonClassInModuleFullFilePath |
|
| 186 | + * @return boolean|string false or null if no module have this language, return the full path of this language |
|
| 187 | + */ |
|
| 188 | + public static function findLanguageFullPath($language, $appLang, $module = null) { |
|
| 189 | + return self::findNonClassInModuleFullFilePath($language, $module, 'lang', $appLang); |
|
| 190 | + } |
|
| 191 | 191 | |
| 192 | - /** |
|
| 193 | - * Get the list of module loaded |
|
| 194 | - * @return array the module list |
|
| 195 | - */ |
|
| 196 | - public static function getModuleList() { |
|
| 197 | - return self::$list; |
|
| 198 | - } |
|
| 192 | + /** |
|
| 193 | + * Get the list of module loaded |
|
| 194 | + * @return array the module list |
|
| 195 | + */ |
|
| 196 | + public static function getModuleList() { |
|
| 197 | + return self::$list; |
|
| 198 | + } |
|
| 199 | 199 | |
| 200 | - /** |
|
| 201 | - * Check if the application has an module |
|
| 202 | - * @return boolean |
|
| 203 | - */ |
|
| 204 | - public static function hasModule() { |
|
| 205 | - return !empty(self::$list); |
|
| 206 | - } |
|
| 200 | + /** |
|
| 201 | + * Check if the application has an module |
|
| 202 | + * @return boolean |
|
| 203 | + */ |
|
| 204 | + public static function hasModule() { |
|
| 205 | + return !empty(self::$list); |
|
| 206 | + } |
|
| 207 | 207 | |
| 208 | - /** |
|
| 209 | - * Check if in module list can have the model, controller, library |
|
| 210 | - * @param string $class the class name of library, model, controller |
|
| 211 | - * @param string $module the module name |
|
| 212 | - * @param string $type the name of the type "controllers", "libraries", "models" |
|
| 213 | - * @return boolean|string false or null if no module |
|
| 214 | - * have this class, return the full path of the class |
|
| 215 | - */ |
|
| 216 | - protected static function findClassInModuleFullFilePath($class, $module, $type) { |
|
| 217 | - $logger = self::getLogger(); |
|
| 218 | - $class = str_ireplace('.php', '', $class); |
|
| 219 | - $class = ucfirst($class); |
|
| 220 | - $classFile = $class . '.php'; |
|
| 221 | - $logger->debug('Checking the class [' . $class . '] in module [' . $module . '] for [' . $type . '] ...'); |
|
| 222 | - $filePath = MODULE_PATH . $module . DS . $type . DS . $classFile; |
|
| 223 | - if (file_exists($filePath)) { |
|
| 224 | - $logger->info('Found class [' . $class . '] in module [' . $module . '] for [' . $type . '] the file path is [' . $filePath . ']'); |
|
| 225 | - return $filePath; |
|
| 226 | - } |
|
| 227 | - $logger->info('Class [' . $class . '] does not exist in the module [' . $module . '] for [' . $type . ']'); |
|
| 228 | - return false; |
|
| 229 | - } |
|
| 208 | + /** |
|
| 209 | + * Check if in module list can have the model, controller, library |
|
| 210 | + * @param string $class the class name of library, model, controller |
|
| 211 | + * @param string $module the module name |
|
| 212 | + * @param string $type the name of the type "controllers", "libraries", "models" |
|
| 213 | + * @return boolean|string false or null if no module |
|
| 214 | + * have this class, return the full path of the class |
|
| 215 | + */ |
|
| 216 | + protected static function findClassInModuleFullFilePath($class, $module, $type) { |
|
| 217 | + $logger = self::getLogger(); |
|
| 218 | + $class = str_ireplace('.php', '', $class); |
|
| 219 | + $class = ucfirst($class); |
|
| 220 | + $classFile = $class . '.php'; |
|
| 221 | + $logger->debug('Checking the class [' . $class . '] in module [' . $module . '] for [' . $type . '] ...'); |
|
| 222 | + $filePath = MODULE_PATH . $module . DS . $type . DS . $classFile; |
|
| 223 | + if (file_exists($filePath)) { |
|
| 224 | + $logger->info('Found class [' . $class . '] in module [' . $module . '] for [' . $type . '] the file path is [' . $filePath . ']'); |
|
| 225 | + return $filePath; |
|
| 226 | + } |
|
| 227 | + $logger->info('Class [' . $class . '] does not exist in the module [' . $module . '] for [' . $type . ']'); |
|
| 228 | + return false; |
|
| 229 | + } |
|
| 230 | 230 | |
| 231 | - /** |
|
| 232 | - * Check if in module list can have the config, view, helper, language |
|
| 233 | - * @param string $name the name of config, view, helper, language |
|
| 234 | - * @param string $module the module name |
|
| 235 | - * @param string $type the name of the type "config", "functions", "views", "lang" |
|
| 236 | - * @param string|null $appLang the application language. This is use only when $type = "lang" |
|
| 237 | - * @return boolean|string false or null if no module |
|
| 238 | - * have this resource, return the full path of the resource |
|
| 239 | - */ |
|
| 240 | - protected static function findNonClassInModuleFullFilePath($name, $module, $type, $appLang = null) { |
|
| 241 | - $logger = self::getLogger(); |
|
| 242 | - $name = str_ireplace('.php', '', $name); |
|
| 243 | - $file = $name . '.php'; |
|
| 244 | - $filePath = MODULE_PATH . $module . DS . $type . DS . $file; |
|
| 245 | - switch ($type) { |
|
| 246 | - case 'functions': |
|
| 247 | - $name = str_ireplace('function_', '', $name); |
|
| 248 | - $file = 'function_' . $name . '.php'; |
|
| 249 | - $filePath = MODULE_PATH . $module . DS . $type . DS . $file; |
|
| 250 | - break; |
|
| 251 | - case 'views': |
|
| 252 | - $name = trim($name, '/\\'); |
|
| 253 | - $name = str_ireplace('/', DS, $name); |
|
| 254 | - $file = $name . '.php'; |
|
| 255 | - $filePath = MODULE_PATH . $module . DS . $type . DS . $file; |
|
| 256 | - break; |
|
| 257 | - case 'lang': |
|
| 258 | - $name = str_ireplace('lang_', '', $name); |
|
| 259 | - $file = 'lang_' . $name . '.php'; |
|
| 260 | - $filePath = MODULE_PATH . $module . DS . $type . DS . $appLang . DS . $file; |
|
| 261 | - break; |
|
| 262 | - } |
|
| 263 | - $logger->debug('Checking resource [' . $name . '] in module [' . $module . '] for [' . $type . '] ...'); |
|
| 264 | - if (file_exists($filePath)) { |
|
| 265 | - $logger->info('Found resource [' . $name . '] in module [' . $module . '] for [' . $type . '] the file path is [' . $filePath . ']'); |
|
| 266 | - return $filePath; |
|
| 267 | - } |
|
| 268 | - $logger->info('Resource [' . $name . '] does not exist in the module [' . $module . '] for [' . $type . ']'); |
|
| 269 | - return false; |
|
| 270 | - } |
|
| 231 | + /** |
|
| 232 | + * Check if in module list can have the config, view, helper, language |
|
| 233 | + * @param string $name the name of config, view, helper, language |
|
| 234 | + * @param string $module the module name |
|
| 235 | + * @param string $type the name of the type "config", "functions", "views", "lang" |
|
| 236 | + * @param string|null $appLang the application language. This is use only when $type = "lang" |
|
| 237 | + * @return boolean|string false or null if no module |
|
| 238 | + * have this resource, return the full path of the resource |
|
| 239 | + */ |
|
| 240 | + protected static function findNonClassInModuleFullFilePath($name, $module, $type, $appLang = null) { |
|
| 241 | + $logger = self::getLogger(); |
|
| 242 | + $name = str_ireplace('.php', '', $name); |
|
| 243 | + $file = $name . '.php'; |
|
| 244 | + $filePath = MODULE_PATH . $module . DS . $type . DS . $file; |
|
| 245 | + switch ($type) { |
|
| 246 | + case 'functions': |
|
| 247 | + $name = str_ireplace('function_', '', $name); |
|
| 248 | + $file = 'function_' . $name . '.php'; |
|
| 249 | + $filePath = MODULE_PATH . $module . DS . $type . DS . $file; |
|
| 250 | + break; |
|
| 251 | + case 'views': |
|
| 252 | + $name = trim($name, '/\\'); |
|
| 253 | + $name = str_ireplace('/', DS, $name); |
|
| 254 | + $file = $name . '.php'; |
|
| 255 | + $filePath = MODULE_PATH . $module . DS . $type . DS . $file; |
|
| 256 | + break; |
|
| 257 | + case 'lang': |
|
| 258 | + $name = str_ireplace('lang_', '', $name); |
|
| 259 | + $file = 'lang_' . $name . '.php'; |
|
| 260 | + $filePath = MODULE_PATH . $module . DS . $type . DS . $appLang . DS . $file; |
|
| 261 | + break; |
|
| 262 | + } |
|
| 263 | + $logger->debug('Checking resource [' . $name . '] in module [' . $module . '] for [' . $type . '] ...'); |
|
| 264 | + if (file_exists($filePath)) { |
|
| 265 | + $logger->info('Found resource [' . $name . '] in module [' . $module . '] for [' . $type . '] the file path is [' . $filePath . ']'); |
|
| 266 | + return $filePath; |
|
| 267 | + } |
|
| 268 | + $logger->info('Resource [' . $name . '] does not exist in the module [' . $module . '] for [' . $type . ']'); |
|
| 269 | + return false; |
|
| 270 | + } |
|
| 271 | 271 | |
| 272 | - } |
|
| 272 | + } |
|
@@ -35,23 +35,23 @@ |
||
| 35 | 35 | /** |
| 36 | 36 | * Initialise the module list by scanning the directory MODULE_PATH |
| 37 | 37 | */ |
| 38 | - public function init(){ |
|
| 38 | + public function init() { |
|
| 39 | 39 | $logger = self::getLogger(); |
| 40 | 40 | $logger->debug('Check if the application contains the modules ...'); |
| 41 | 41 | $moduleDir = opendir(MODULE_PATH); |
| 42 | - if (is_resource($moduleDir)){ |
|
| 43 | - while(($module = readdir($moduleDir)) !== false){ |
|
| 44 | - if (preg_match('/^([a-z0-9-_]+)$/i', $module) && is_dir(MODULE_PATH . $module)){ |
|
| 42 | + if (is_resource($moduleDir)) { |
|
| 43 | + while (($module = readdir($moduleDir)) !== false) { |
|
| 44 | + if (preg_match('/^([a-z0-9-_]+)$/i', $module) && is_dir(MODULE_PATH . $module)) { |
|
| 45 | 45 | self::$list[] = $module; |
| 46 | - } else{ |
|
| 47 | - $logger->info('Skipping [' .$module. '], may be this is not a directory or does not exists or is invalid name'); |
|
| 46 | + } else { |
|
| 47 | + $logger->info('Skipping [' . $module . '], may be this is not a directory or does not exists or is invalid name'); |
|
| 48 | 48 | } |
| 49 | 49 | } |
| 50 | 50 | closedir($moduleDir); |
| 51 | 51 | } |
| 52 | 52 | ksort(self::$list); |
| 53 | 53 | |
| 54 | - if (! empty(self::$list)){ |
|
| 54 | + if (!empty(self::$list)) { |
|
| 55 | 55 | $logger->info('The application contains the module below [' . implode(', ', self::getModuleList()) . ']'); |
| 56 | 56 | } |
| 57 | 57 | } |
@@ -1,63 +1,63 @@ |
||
| 1 | 1 | <?php |
| 2 | - defined('ROOT_PATH') or exit('Access denied'); |
|
| 3 | - /** |
|
| 4 | - * TNH Framework |
|
| 5 | - * |
|
| 6 | - * A simple PHP framework using HMVC architecture |
|
| 7 | - * |
|
| 8 | - * This content is released under the GNU GPL License (GPL) |
|
| 9 | - * |
|
| 10 | - * Copyright (C) 2017 Tony NGUEREZA |
|
| 11 | - * |
|
| 12 | - * This program is free software; you can redistribute it and/or |
|
| 13 | - * modify it under the terms of the GNU General Public License |
|
| 14 | - * as published by the Free Software Foundation; either version 3 |
|
| 15 | - * of the License, or (at your option) any later version. |
|
| 16 | - * |
|
| 17 | - * This program is distributed in the hope that it will be useful, |
|
| 18 | - * but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 19 | - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 20 | - * GNU General Public License for more details. |
|
| 21 | - * |
|
| 22 | - * You should have received a copy of the GNU General Public License |
|
| 23 | - * along with this program; if not, write to the Free Software |
|
| 24 | - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
|
| 25 | - */ |
|
| 2 | + defined('ROOT_PATH') or exit('Access denied'); |
|
| 3 | + /** |
|
| 4 | + * TNH Framework |
|
| 5 | + * |
|
| 6 | + * A simple PHP framework using HMVC architecture |
|
| 7 | + * |
|
| 8 | + * This content is released under the GNU GPL License (GPL) |
|
| 9 | + * |
|
| 10 | + * Copyright (C) 2017 Tony NGUEREZA |
|
| 11 | + * |
|
| 12 | + * This program is free software; you can redistribute it and/or |
|
| 13 | + * modify it under the terms of the GNU General Public License |
|
| 14 | + * as published by the Free Software Foundation; either version 3 |
|
| 15 | + * of the License, or (at your option) any later version. |
|
| 16 | + * |
|
| 17 | + * This program is distributed in the hope that it will be useful, |
|
| 18 | + * but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 19 | + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 20 | + * GNU General Public License for more details. |
|
| 21 | + * |
|
| 22 | + * You should have received a copy of the GNU General Public License |
|
| 23 | + * along with this program; if not, write to the Free Software |
|
| 24 | + * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
|
| 25 | + */ |
|
| 26 | 26 | |
| 27 | - /** |
|
| 28 | - * This class represent the event detail to dispatch to correspond listener |
|
| 29 | - */ |
|
| 30 | - class EventInfo { |
|
| 27 | + /** |
|
| 28 | + * This class represent the event detail to dispatch to correspond listener |
|
| 29 | + */ |
|
| 30 | + class EventInfo { |
|
| 31 | 31 | |
| 32 | - /** |
|
| 33 | - * The event name |
|
| 34 | - * @var string |
|
| 35 | - */ |
|
| 36 | - public $name; |
|
| 32 | + /** |
|
| 33 | + * The event name |
|
| 34 | + * @var string |
|
| 35 | + */ |
|
| 36 | + public $name; |
|
| 37 | 37 | |
| 38 | - /** |
|
| 39 | - * The event data to send to the listeners |
|
| 40 | - * @var mixed |
|
| 41 | - */ |
|
| 42 | - public $payload; |
|
| 38 | + /** |
|
| 39 | + * The event data to send to the listeners |
|
| 40 | + * @var mixed |
|
| 41 | + */ |
|
| 42 | + public $payload; |
|
| 43 | 43 | |
| 44 | - /** |
|
| 45 | - * If the listeners need return the event after treatment or not, false means no need |
|
| 46 | - * return true need return the event. |
|
| 47 | - * @var boolean |
|
| 48 | - */ |
|
| 49 | - public $returnBack; |
|
| 44 | + /** |
|
| 45 | + * If the listeners need return the event after treatment or not, false means no need |
|
| 46 | + * return true need return the event. |
|
| 47 | + * @var boolean |
|
| 48 | + */ |
|
| 49 | + public $returnBack; |
|
| 50 | 50 | |
| 51 | - /** |
|
| 52 | - * This variable indicates if need stop the event propagation |
|
| 53 | - * @var boolean |
|
| 54 | - */ |
|
| 55 | - public $stop; |
|
| 51 | + /** |
|
| 52 | + * This variable indicates if need stop the event propagation |
|
| 53 | + * @var boolean |
|
| 54 | + */ |
|
| 55 | + public $stop; |
|
| 56 | 56 | |
| 57 | - public function __construct($name, $payload = array(), $returnBack = false, $stop = false) { |
|
| 58 | - $this->name = $name; |
|
| 59 | - $this->payload = $payload; |
|
| 60 | - $this->returnBack = $returnBack; |
|
| 61 | - $this->stop = $stop; |
|
| 62 | - } |
|
| 63 | - } |
|
| 57 | + public function __construct($name, $payload = array(), $returnBack = false, $stop = false) { |
|
| 58 | + $this->name = $name; |
|
| 59 | + $this->payload = $payload; |
|
| 60 | + $this->returnBack = $returnBack; |
|
| 61 | + $this->stop = $stop; |
|
| 62 | + } |
|
| 63 | + } |
|
@@ -1,135 +1,135 @@ |
||
| 1 | 1 | <?php |
| 2 | - defined('ROOT_PATH') or exit('Access denied'); |
|
| 3 | - /** |
|
| 4 | - * TNH Framework |
|
| 5 | - * |
|
| 6 | - * A simple PHP framework using HMVC architecture |
|
| 7 | - * |
|
| 8 | - * This content is released under the GNU GPL License (GPL) |
|
| 9 | - * |
|
| 10 | - * Copyright (C) 2017 Tony NGUEREZA |
|
| 11 | - * |
|
| 12 | - * This program is free software; you can redistribute it and/or |
|
| 13 | - * modify it under the terms of the GNU General Public License |
|
| 14 | - * as published by the Free Software Foundation; either version 3 |
|
| 15 | - * of the License, or (at your option) any later version. |
|
| 16 | - * |
|
| 17 | - * This program is distributed in the hope that it will be useful, |
|
| 18 | - * but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 19 | - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 20 | - * GNU General Public License for more details. |
|
| 21 | - * |
|
| 22 | - * You should have received a copy of the GNU General Public License |
|
| 23 | - * along with this program; if not, write to the Free Software |
|
| 24 | - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
|
| 25 | - */ |
|
| 2 | + defined('ROOT_PATH') or exit('Access denied'); |
|
| 3 | + /** |
|
| 4 | + * TNH Framework |
|
| 5 | + * |
|
| 6 | + * A simple PHP framework using HMVC architecture |
|
| 7 | + * |
|
| 8 | + * This content is released under the GNU GPL License (GPL) |
|
| 9 | + * |
|
| 10 | + * Copyright (C) 2017 Tony NGUEREZA |
|
| 11 | + * |
|
| 12 | + * This program is free software; you can redistribute it and/or |
|
| 13 | + * modify it under the terms of the GNU General Public License |
|
| 14 | + * as published by the Free Software Foundation; either version 3 |
|
| 15 | + * of the License, or (at your option) any later version. |
|
| 16 | + * |
|
| 17 | + * This program is distributed in the hope that it will be useful, |
|
| 18 | + * but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 19 | + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 20 | + * GNU General Public License for more details. |
|
| 21 | + * |
|
| 22 | + * You should have received a copy of the GNU General Public License |
|
| 23 | + * along with this program; if not, write to the Free Software |
|
| 24 | + * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
|
| 25 | + */ |
|
| 26 | 26 | |
| 27 | - class Security extends BaseStaticClass { |
|
| 27 | + class Security extends BaseStaticClass { |
|
| 28 | 28 | |
| 29 | - /** |
|
| 30 | - * This method is used to generate the CSRF token |
|
| 31 | - * @return string the generated CSRF token |
|
| 32 | - */ |
|
| 33 | - public static function generateCSRF() { |
|
| 34 | - $logger = self::getLogger(); |
|
| 35 | - $logger->debug('Generation of CSRF ...'); |
|
| 29 | + /** |
|
| 30 | + * This method is used to generate the CSRF token |
|
| 31 | + * @return string the generated CSRF token |
|
| 32 | + */ |
|
| 33 | + public static function generateCSRF() { |
|
| 34 | + $logger = self::getLogger(); |
|
| 35 | + $logger->debug('Generation of CSRF ...'); |
|
| 36 | 36 | |
| 37 | - $key = get_config('csrf_key', 'csrf_key'); |
|
| 38 | - $expire = get_config('csrf_expire', 60); |
|
| 39 | - $keyExpire = 'csrf_expire'; |
|
| 40 | - $currentTime = time(); |
|
| 41 | - if(Session::exists($key) && Session::exists($keyExpire) && Session::get($keyExpire) > $currentTime){ |
|
| 42 | - $logger->info('The CSRF token not yet expire just return it'); |
|
| 43 | - return Session::get($key); |
|
| 44 | - } else{ |
|
| 45 | - $newTime = $currentTime + $expire; |
|
| 46 | - $token = sha1(uniqid()) . sha1(uniqid()); |
|
| 47 | - $logger->info('The CSRF informations are listed below: key [' .$key. '], key expire [' .$keyExpire. '], expire time [' .$expire. '], token [' .$token. ']'); |
|
| 48 | - Session::set($keyExpire, $newTime); |
|
| 49 | - Session::set($key, $token); |
|
| 50 | - return Session::get($key); |
|
| 51 | - } |
|
| 52 | - } |
|
| 37 | + $key = get_config('csrf_key', 'csrf_key'); |
|
| 38 | + $expire = get_config('csrf_expire', 60); |
|
| 39 | + $keyExpire = 'csrf_expire'; |
|
| 40 | + $currentTime = time(); |
|
| 41 | + if(Session::exists($key) && Session::exists($keyExpire) && Session::get($keyExpire) > $currentTime){ |
|
| 42 | + $logger->info('The CSRF token not yet expire just return it'); |
|
| 43 | + return Session::get($key); |
|
| 44 | + } else{ |
|
| 45 | + $newTime = $currentTime + $expire; |
|
| 46 | + $token = sha1(uniqid()) . sha1(uniqid()); |
|
| 47 | + $logger->info('The CSRF informations are listed below: key [' .$key. '], key expire [' .$keyExpire. '], expire time [' .$expire. '], token [' .$token. ']'); |
|
| 48 | + Session::set($keyExpire, $newTime); |
|
| 49 | + Session::set($key, $token); |
|
| 50 | + return Session::get($key); |
|
| 51 | + } |
|
| 52 | + } |
|
| 53 | 53 | |
| 54 | - /** |
|
| 55 | - * This method is used to check the CSRF if is valid, not yet expire, etc. |
|
| 56 | - * @return boolean true if valid, false if not valid |
|
| 57 | - */ |
|
| 58 | - public static function validateCSRF() { |
|
| 59 | - $logger = self::getLogger(); |
|
| 60 | - $logger->debug('Validation of CSRF ...'); |
|
| 54 | + /** |
|
| 55 | + * This method is used to check the CSRF if is valid, not yet expire, etc. |
|
| 56 | + * @return boolean true if valid, false if not valid |
|
| 57 | + */ |
|
| 58 | + public static function validateCSRF() { |
|
| 59 | + $logger = self::getLogger(); |
|
| 60 | + $logger->debug('Validation of CSRF ...'); |
|
| 61 | 61 | |
| 62 | - $key = get_config('csrf_key', 'csrf_key'); |
|
| 63 | - $expire = get_config('csrf_expire', 60); |
|
| 64 | - $keyExpire = 'csrf_expire'; |
|
| 65 | - $currentTime = time(); |
|
| 66 | - $logger->info('The CSRF informations are listed below: key [' . $key . '], key expire [' . $keyExpire . '], expire time [' . $expire . ']'); |
|
| 67 | - if (!Session::exists($key) || Session::get($keyExpire) <= $currentTime) { |
|
| 68 | - $logger->warning('The CSRF session data is not valide'); |
|
| 69 | - return false; |
|
| 70 | - } |
|
| 71 | - //perform form data |
|
| 72 | - //need use request->query() for best retrieve |
|
| 73 | - //super instance |
|
| 74 | - $obj = & get_instance(); |
|
| 75 | - $token = $obj->request->query($key); |
|
| 76 | - if (!$token || $token !== Session::get($key) || Session::get($keyExpire) <= $currentTime) { |
|
| 77 | - $logger->warning('The CSRF data [' . $token . '] is not valide may be attacker do his job'); |
|
| 78 | - return false; |
|
| 79 | - } |
|
| 80 | - $logger->info('The CSRF data [' . $token . '] is valide the form data is safe continue'); |
|
| 81 | - //remove the token from session |
|
| 82 | - Session::clear($key); |
|
| 83 | - Session::clear($keyExpire); |
|
| 84 | - return true; |
|
| 85 | - } |
|
| 62 | + $key = get_config('csrf_key', 'csrf_key'); |
|
| 63 | + $expire = get_config('csrf_expire', 60); |
|
| 64 | + $keyExpire = 'csrf_expire'; |
|
| 65 | + $currentTime = time(); |
|
| 66 | + $logger->info('The CSRF informations are listed below: key [' . $key . '], key expire [' . $keyExpire . '], expire time [' . $expire . ']'); |
|
| 67 | + if (!Session::exists($key) || Session::get($keyExpire) <= $currentTime) { |
|
| 68 | + $logger->warning('The CSRF session data is not valide'); |
|
| 69 | + return false; |
|
| 70 | + } |
|
| 71 | + //perform form data |
|
| 72 | + //need use request->query() for best retrieve |
|
| 73 | + //super instance |
|
| 74 | + $obj = & get_instance(); |
|
| 75 | + $token = $obj->request->query($key); |
|
| 76 | + if (!$token || $token !== Session::get($key) || Session::get($keyExpire) <= $currentTime) { |
|
| 77 | + $logger->warning('The CSRF data [' . $token . '] is not valide may be attacker do his job'); |
|
| 78 | + return false; |
|
| 79 | + } |
|
| 80 | + $logger->info('The CSRF data [' . $token . '] is valide the form data is safe continue'); |
|
| 81 | + //remove the token from session |
|
| 82 | + Session::clear($key); |
|
| 83 | + Session::clear($keyExpire); |
|
| 84 | + return true; |
|
| 85 | + } |
|
| 86 | 86 | |
| 87 | - /** |
|
| 88 | - * This method is used to check the whitelist IP address access |
|
| 89 | - */ |
|
| 90 | - public static function checkWhiteListIpAccess(){ |
|
| 91 | - $logger = self::getLogger(); |
|
| 92 | - $logger->debug('Validation of the IP address access ...'); |
|
| 93 | - $logger->debug('Check if whitelist IP access is enabled in the configuration ...'); |
|
| 94 | - $isEnable = get_config('white_list_ip_enable', false); |
|
| 95 | - if($isEnable){ |
|
| 96 | - $logger->info('Whitelist IP access is enabled in the configuration'); |
|
| 97 | - $list = get_config('white_list_ip_addresses', array()); |
|
| 98 | - if(! empty($list)){ |
|
| 99 | - //Can't use Loader::functions() at this time because teh "Loader" library is loader after the security prossessing |
|
| 100 | - require_once CORE_FUNCTIONS_PATH . 'function_user_agent.php'; |
|
| 101 | - $ip = get_ip(); |
|
| 102 | - if((count($list) == 1 && $list[0] == '*') || in_array($ip, $list)){ |
|
| 103 | - $logger->info('IP address ' . $ip . ' allowed using the wildcard "*" or the full IP'); |
|
| 104 | - //wildcard to access all ip address |
|
| 105 | - return; |
|
| 106 | - } else{ |
|
| 107 | - // go through all whitelisted ips |
|
| 108 | - foreach ($list as $ipaddr) { |
|
| 109 | - // find the wild card * in whitelisted ip (f.e. find position in "127.0.*" or "127*") |
|
| 110 | - $wildcardPosition = strpos($ipaddr, '*'); |
|
| 111 | - if ($wildcardPosition === false) { |
|
| 112 | - // no wild card in whitelisted ip --continue searching |
|
| 113 | - continue; |
|
| 114 | - } |
|
| 115 | - // cut ip at the position where we got the wild card on the whitelisted ip |
|
| 116 | - // and add the wold card to get the same pattern |
|
| 117 | - if (substr($ip, 0, $wildcardPosition) . '*' === $ipaddr) { |
|
| 118 | - // f.e. we got |
|
| 119 | - // ip "127.0.0.1" |
|
| 120 | - // whitelisted ip "127.0.*" |
|
| 121 | - // then we compared "127.0.*" with "127.0.*" |
|
| 122 | - // return success |
|
| 123 | - $logger->info('IP address ' . $ip . ' allowed using the wildcard like "x.x.x.*"'); |
|
| 124 | - return; |
|
| 125 | - } |
|
| 126 | - } |
|
| 127 | - $logger->warning('IP address ' . $ip . ' is not allowed to access to this application'); |
|
| 128 | - show_error('Access to this application is not allowed'); |
|
| 129 | - } |
|
| 130 | - } |
|
| 131 | - } else{ |
|
| 132 | - $logger->info('Whitelist IP access is not enabled in the configuration, ignore checking'); |
|
| 133 | - } |
|
| 134 | - } |
|
| 135 | - } |
|
| 87 | + /** |
|
| 88 | + * This method is used to check the whitelist IP address access |
|
| 89 | + */ |
|
| 90 | + public static function checkWhiteListIpAccess(){ |
|
| 91 | + $logger = self::getLogger(); |
|
| 92 | + $logger->debug('Validation of the IP address access ...'); |
|
| 93 | + $logger->debug('Check if whitelist IP access is enabled in the configuration ...'); |
|
| 94 | + $isEnable = get_config('white_list_ip_enable', false); |
|
| 95 | + if($isEnable){ |
|
| 96 | + $logger->info('Whitelist IP access is enabled in the configuration'); |
|
| 97 | + $list = get_config('white_list_ip_addresses', array()); |
|
| 98 | + if(! empty($list)){ |
|
| 99 | + //Can't use Loader::functions() at this time because teh "Loader" library is loader after the security prossessing |
|
| 100 | + require_once CORE_FUNCTIONS_PATH . 'function_user_agent.php'; |
|
| 101 | + $ip = get_ip(); |
|
| 102 | + if((count($list) == 1 && $list[0] == '*') || in_array($ip, $list)){ |
|
| 103 | + $logger->info('IP address ' . $ip . ' allowed using the wildcard "*" or the full IP'); |
|
| 104 | + //wildcard to access all ip address |
|
| 105 | + return; |
|
| 106 | + } else{ |
|
| 107 | + // go through all whitelisted ips |
|
| 108 | + foreach ($list as $ipaddr) { |
|
| 109 | + // find the wild card * in whitelisted ip (f.e. find position in "127.0.*" or "127*") |
|
| 110 | + $wildcardPosition = strpos($ipaddr, '*'); |
|
| 111 | + if ($wildcardPosition === false) { |
|
| 112 | + // no wild card in whitelisted ip --continue searching |
|
| 113 | + continue; |
|
| 114 | + } |
|
| 115 | + // cut ip at the position where we got the wild card on the whitelisted ip |
|
| 116 | + // and add the wold card to get the same pattern |
|
| 117 | + if (substr($ip, 0, $wildcardPosition) . '*' === $ipaddr) { |
|
| 118 | + // f.e. we got |
|
| 119 | + // ip "127.0.0.1" |
|
| 120 | + // whitelisted ip "127.0.*" |
|
| 121 | + // then we compared "127.0.*" with "127.0.*" |
|
| 122 | + // return success |
|
| 123 | + $logger->info('IP address ' . $ip . ' allowed using the wildcard like "x.x.x.*"'); |
|
| 124 | + return; |
|
| 125 | + } |
|
| 126 | + } |
|
| 127 | + $logger->warning('IP address ' . $ip . ' is not allowed to access to this application'); |
|
| 128 | + show_error('Access to this application is not allowed'); |
|
| 129 | + } |
|
| 130 | + } |
|
| 131 | + } else{ |
|
| 132 | + $logger->info('Whitelist IP access is not enabled in the configuration, ignore checking'); |
|
| 133 | + } |
|
| 134 | + } |
|
| 135 | + } |
|
@@ -38,13 +38,13 @@ discard block |
||
| 38 | 38 | $expire = get_config('csrf_expire', 60); |
| 39 | 39 | $keyExpire = 'csrf_expire'; |
| 40 | 40 | $currentTime = time(); |
| 41 | - if(Session::exists($key) && Session::exists($keyExpire) && Session::get($keyExpire) > $currentTime){ |
|
| 41 | + if (Session::exists($key) && Session::exists($keyExpire) && Session::get($keyExpire) > $currentTime) { |
|
| 42 | 42 | $logger->info('The CSRF token not yet expire just return it'); |
| 43 | 43 | return Session::get($key); |
| 44 | - } else{ |
|
| 44 | + } else { |
|
| 45 | 45 | $newTime = $currentTime + $expire; |
| 46 | 46 | $token = sha1(uniqid()) . sha1(uniqid()); |
| 47 | - $logger->info('The CSRF informations are listed below: key [' .$key. '], key expire [' .$keyExpire. '], expire time [' .$expire. '], token [' .$token. ']'); |
|
| 47 | + $logger->info('The CSRF informations are listed below: key [' . $key . '], key expire [' . $keyExpire . '], expire time [' . $expire . '], token [' . $token . ']'); |
|
| 48 | 48 | Session::set($keyExpire, $newTime); |
| 49 | 49 | Session::set($key, $token); |
| 50 | 50 | return Session::get($key); |
@@ -87,23 +87,23 @@ discard block |
||
| 87 | 87 | /** |
| 88 | 88 | * This method is used to check the whitelist IP address access |
| 89 | 89 | */ |
| 90 | - public static function checkWhiteListIpAccess(){ |
|
| 90 | + public static function checkWhiteListIpAccess() { |
|
| 91 | 91 | $logger = self::getLogger(); |
| 92 | 92 | $logger->debug('Validation of the IP address access ...'); |
| 93 | 93 | $logger->debug('Check if whitelist IP access is enabled in the configuration ...'); |
| 94 | 94 | $isEnable = get_config('white_list_ip_enable', false); |
| 95 | - if($isEnable){ |
|
| 95 | + if ($isEnable) { |
|
| 96 | 96 | $logger->info('Whitelist IP access is enabled in the configuration'); |
| 97 | 97 | $list = get_config('white_list_ip_addresses', array()); |
| 98 | - if(! empty($list)){ |
|
| 98 | + if (!empty($list)) { |
|
| 99 | 99 | //Can't use Loader::functions() at this time because teh "Loader" library is loader after the security prossessing |
| 100 | 100 | require_once CORE_FUNCTIONS_PATH . 'function_user_agent.php'; |
| 101 | 101 | $ip = get_ip(); |
| 102 | - if((count($list) == 1 && $list[0] == '*') || in_array($ip, $list)){ |
|
| 102 | + if ((count($list) == 1 && $list[0] == '*') || in_array($ip, $list)) { |
|
| 103 | 103 | $logger->info('IP address ' . $ip . ' allowed using the wildcard "*" or the full IP'); |
| 104 | 104 | //wildcard to access all ip address |
| 105 | 105 | return; |
| 106 | - } else{ |
|
| 106 | + } else { |
|
| 107 | 107 | // go through all whitelisted ips |
| 108 | 108 | foreach ($list as $ipaddr) { |
| 109 | 109 | // find the wild card * in whitelisted ip (f.e. find position in "127.0.*" or "127*") |
@@ -128,7 +128,7 @@ discard block |
||
| 128 | 128 | show_error('Access to this application is not allowed'); |
| 129 | 129 | } |
| 130 | 130 | } |
| 131 | - } else{ |
|
| 131 | + } else { |
|
| 132 | 132 | $logger->info('Whitelist IP access is not enabled in the configuration, ignore checking'); |
| 133 | 133 | } |
| 134 | 134 | } |
@@ -24,13 +24,13 @@ discard block |
||
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | 25 | */ |
| 26 | 26 | |
| 27 | - class DatabaseQueryResult{ |
|
| 27 | + class DatabaseQueryResult { |
|
| 28 | 28 | |
| 29 | 29 | /** |
| 30 | 30 | * The database query result |
| 31 | 31 | * @var mixed |
| 32 | 32 | */ |
| 33 | - private $result = null; |
|
| 33 | + private $result = null; |
|
| 34 | 34 | |
| 35 | 35 | |
| 36 | 36 | /** |
@@ -56,7 +56,7 @@ discard block |
||
| 56 | 56 | * |
| 57 | 57 | * @return mixed |
| 58 | 58 | */ |
| 59 | - public function getResult(){ |
|
| 59 | + public function getResult() { |
|
| 60 | 60 | return $this->result; |
| 61 | 61 | } |
| 62 | 62 | |
@@ -66,7 +66,7 @@ discard block |
||
| 66 | 66 | * |
| 67 | 67 | * @return object DatabaseQueryResult |
| 68 | 68 | */ |
| 69 | - public function setResult($result){ |
|
| 69 | + public function setResult($result) { |
|
| 70 | 70 | $this->result = $result; |
| 71 | 71 | return $this; |
| 72 | 72 | } |
@@ -76,7 +76,7 @@ discard block |
||
| 76 | 76 | * |
| 77 | 77 | * @return int |
| 78 | 78 | */ |
| 79 | - public function getNumRows(){ |
|
| 79 | + public function getNumRows() { |
|
| 80 | 80 | return $this->numRows; |
| 81 | 81 | } |
| 82 | 82 | |
@@ -86,7 +86,7 @@ discard block |
||
| 86 | 86 | * |
| 87 | 87 | * @return object DatabaseQueryResult |
| 88 | 88 | */ |
| 89 | - public function setNumRows($numRows){ |
|
| 89 | + public function setNumRows($numRows) { |
|
| 90 | 90 | $this->numRows = $numRows; |
| 91 | 91 | return $this; |
| 92 | 92 | } |
@@ -216,19 +216,19 @@ discard block |
||
| 216 | 216 | * @return object the current DatabaseQueryBuilder instance |
| 217 | 217 | */ |
| 218 | 218 | public function join($table, $field1 = null, $op = null, $field2 = null, $type = ''){ |
| 219 | - $on = $field1; |
|
| 220 | - $table = $this->getPrefix() . $table; |
|
| 221 | - if (! is_null($op)){ |
|
| 219 | + $on = $field1; |
|
| 220 | + $table = $this->getPrefix() . $table; |
|
| 221 | + if (! is_null($op)){ |
|
| 222 | 222 | $on = (! in_array($op, $this->operatorList) |
| 223 | - ? ($this->getPrefix() . $field1 . ' = ' . $this->getPrefix() . $op) |
|
| 224 | - : ($this->getPrefix() . $field1 . ' ' . $op . ' ' . $this->getPrefix() . $field2)); |
|
| 225 | - } |
|
| 226 | - if (empty($this->join)){ |
|
| 223 | + ? ($this->getPrefix() . $field1 . ' = ' . $this->getPrefix() . $op) |
|
| 224 | + : ($this->getPrefix() . $field1 . ' ' . $op . ' ' . $this->getPrefix() . $field2)); |
|
| 225 | + } |
|
| 226 | + if (empty($this->join)){ |
|
| 227 | 227 | $this->join = ' ' . $type . 'JOIN' . ' ' . $table . ' ON ' . $on; |
| 228 | - } else{ |
|
| 228 | + } else{ |
|
| 229 | 229 | $this->join = $this->join . ' ' . $type . 'JOIN' . ' ' . $table . ' ON ' . $on; |
| 230 | - } |
|
| 231 | - return $this; |
|
| 230 | + } |
|
| 231 | + return $this; |
|
| 232 | 232 | } |
| 233 | 233 | |
| 234 | 234 | /** |
@@ -330,18 +330,18 @@ discard block |
||
| 330 | 330 | * @return object the current DatabaseQueryBuilder instance |
| 331 | 331 | */ |
| 332 | 332 | public function where($where, $op = null, $val = null, $type = '', $andOr = 'AND', $escape = true){ |
| 333 | - $whereStr = ''; |
|
| 334 | - if (is_array($where)){ |
|
| 333 | + $whereStr = ''; |
|
| 334 | + if (is_array($where)){ |
|
| 335 | 335 | $whereStr = $this->getWhereStrIfIsArray($where, $type, $andOr, $escape); |
| 336 | - } else{ |
|
| 336 | + } else{ |
|
| 337 | 337 | if (is_array($op)){ |
| 338 | - $whereStr = $this->getWhereStrIfOperatorIsArray($where, $op, $type, $escape); |
|
| 338 | + $whereStr = $this->getWhereStrIfOperatorIsArray($where, $op, $type, $escape); |
|
| 339 | 339 | } else { |
| 340 | - $whereStr = $this->getWhereStrForOperator($where, $op, $val, $type, $escape); |
|
| 340 | + $whereStr = $this->getWhereStrForOperator($where, $op, $val, $type, $escape); |
|
| 341 | 341 | } |
| 342 | - } |
|
| 343 | - $this->setWhereStr($whereStr, $andOr); |
|
| 344 | - return $this; |
|
| 342 | + } |
|
| 343 | + $this->setWhereStr($whereStr, $andOr); |
|
| 344 | + return $this; |
|
| 345 | 345 | } |
| 346 | 346 | |
| 347 | 347 | /** |
@@ -578,15 +578,15 @@ discard block |
||
| 578 | 578 | * @return object the current DatabaseQueryBuilder instance |
| 579 | 579 | */ |
| 580 | 580 | public function limit($limit, $limitEnd = null){ |
| 581 | - if (empty($limit)){ |
|
| 581 | + if (empty($limit)){ |
|
| 582 | 582 | $limit = 0; |
| 583 | - } |
|
| 584 | - if (! is_null($limitEnd)){ |
|
| 583 | + } |
|
| 584 | + if (! is_null($limitEnd)){ |
|
| 585 | 585 | $this->limit = $limit . ', ' . $limitEnd; |
| 586 | - } else{ |
|
| 586 | + } else{ |
|
| 587 | 587 | $this->limit = $limit; |
| 588 | - } |
|
| 589 | - return $this; |
|
| 588 | + } |
|
| 589 | + return $this; |
|
| 590 | 590 | } |
| 591 | 591 | |
| 592 | 592 | /** |
@@ -596,14 +596,14 @@ discard block |
||
| 596 | 596 | * @return object the current DatabaseQueryBuilder instance |
| 597 | 597 | */ |
| 598 | 598 | public function orderBy($orderBy, $orderDir = ' ASC'){ |
| 599 | - if (stristr($orderBy, ' ') || $orderBy == 'rand()'){ |
|
| 599 | + if (stristr($orderBy, ' ') || $orderBy == 'rand()'){ |
|
| 600 | 600 | $this->orderBy = empty($this->orderBy) ? $orderBy : $this->orderBy . ', ' . $orderBy; |
| 601 | - } else{ |
|
| 601 | + } else{ |
|
| 602 | 602 | $this->orderBy = empty($this->orderBy) |
| 603 | - ? ($orderBy . ' ' . strtoupper($orderDir)) |
|
| 604 | - : $this->orderBy . ', ' . $orderBy . ' ' . strtoupper($orderDir); |
|
| 605 | - } |
|
| 606 | - return $this; |
|
| 603 | + ? ($orderBy . ' ' . strtoupper($orderDir)) |
|
| 604 | + : $this->orderBy . ', ' . $orderBy . ' ' . strtoupper($orderDir); |
|
| 605 | + } |
|
| 606 | + return $this; |
|
| 607 | 607 | } |
| 608 | 608 | |
| 609 | 609 | /** |
@@ -612,12 +612,12 @@ discard block |
||
| 612 | 612 | * @return object the current DatabaseQueryBuilder instance |
| 613 | 613 | */ |
| 614 | 614 | public function groupBy($field){ |
| 615 | - if (is_array($field)){ |
|
| 615 | + if (is_array($field)){ |
|
| 616 | 616 | $this->groupBy = implode(', ', $field); |
| 617 | - } else{ |
|
| 617 | + } else{ |
|
| 618 | 618 | $this->groupBy = $field; |
| 619 | - } |
|
| 620 | - return $this; |
|
| 619 | + } |
|
| 620 | + return $this; |
|
| 621 | 621 | } |
| 622 | 622 | |
| 623 | 623 | /** |
@@ -629,20 +629,20 @@ discard block |
||
| 629 | 629 | * @return object the current DatabaseQueryBuilder instance |
| 630 | 630 | */ |
| 631 | 631 | public function having($field, $op = null, $val = null, $escape = true){ |
| 632 | - if (is_array($op)){ |
|
| 632 | + if (is_array($op)){ |
|
| 633 | 633 | $this->having = $this->getHavingStrIfOperatorIsArray($field, $op, $escape); |
| 634 | - } else if (! in_array($op, $this->operatorList)){ |
|
| 634 | + } else if (! in_array($op, $this->operatorList)){ |
|
| 635 | 635 | if (is_null($op)){ |
| 636 | - $op = ''; |
|
| 636 | + $op = ''; |
|
| 637 | 637 | } |
| 638 | 638 | $this->having = $field . ' > ' . ($this->escape($op, $escape)); |
| 639 | - } else{ |
|
| 639 | + } else{ |
|
| 640 | 640 | if (is_null($val)){ |
| 641 | - $val = ''; |
|
| 641 | + $val = ''; |
|
| 642 | 642 | } |
| 643 | 643 | $this->having = $field . ' ' . $op . ' ' . ($this->escape($val, $escape)); |
| 644 | - } |
|
| 645 | - return $this; |
|
| 644 | + } |
|
| 645 | + return $this; |
|
| 646 | 646 | } |
| 647 | 647 | |
| 648 | 648 | /** |
@@ -23,94 +23,94 @@ discard block |
||
| 23 | 23 | * along with this program; if not, write to the Free Software |
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | 25 | */ |
| 26 | - class DatabaseQueryBuilder{ |
|
| 26 | + class DatabaseQueryBuilder { |
|
| 27 | 27 | /** |
| 28 | 28 | * The SQL SELECT statment |
| 29 | 29 | * @var string |
| 30 | 30 | */ |
| 31 | - private $select = '*'; |
|
| 31 | + private $select = '*'; |
|
| 32 | 32 | |
| 33 | 33 | /** |
| 34 | 34 | * The SQL FROM statment |
| 35 | 35 | * @var string |
| 36 | 36 | */ |
| 37 | - private $from = null; |
|
| 37 | + private $from = null; |
|
| 38 | 38 | |
| 39 | 39 | /** |
| 40 | 40 | * The SQL WHERE statment |
| 41 | 41 | * @var string |
| 42 | 42 | */ |
| 43 | - private $where = null; |
|
| 43 | + private $where = null; |
|
| 44 | 44 | |
| 45 | 45 | /** |
| 46 | 46 | * The SQL LIMIT statment |
| 47 | 47 | * @var string |
| 48 | 48 | */ |
| 49 | - private $limit = null; |
|
| 49 | + private $limit = null; |
|
| 50 | 50 | |
| 51 | 51 | /** |
| 52 | 52 | * The SQL JOIN statment |
| 53 | 53 | * @var string |
| 54 | 54 | */ |
| 55 | - private $join = null; |
|
| 55 | + private $join = null; |
|
| 56 | 56 | |
| 57 | 57 | /** |
| 58 | 58 | * The SQL ORDER BY statment |
| 59 | 59 | * @var string |
| 60 | 60 | */ |
| 61 | - private $orderBy = null; |
|
| 61 | + private $orderBy = null; |
|
| 62 | 62 | |
| 63 | 63 | /** |
| 64 | 64 | * The SQL GROUP BY statment |
| 65 | 65 | * @var string |
| 66 | 66 | */ |
| 67 | - private $groupBy = null; |
|
| 67 | + private $groupBy = null; |
|
| 68 | 68 | |
| 69 | 69 | /** |
| 70 | 70 | * The SQL HAVING statment |
| 71 | 71 | * @var string |
| 72 | 72 | */ |
| 73 | - private $having = null; |
|
| 73 | + private $having = null; |
|
| 74 | 74 | |
| 75 | 75 | /** |
| 76 | 76 | * The full SQL query statment after build for each command |
| 77 | 77 | * @var string |
| 78 | 78 | */ |
| 79 | - private $query = null; |
|
| 79 | + private $query = null; |
|
| 80 | 80 | |
| 81 | 81 | /** |
| 82 | 82 | * The list of SQL valid operators |
| 83 | 83 | * @var array |
| 84 | 84 | */ |
| 85 | - private $operatorList = array('=','!=','<','>','<=','>=','<>'); |
|
| 85 | + private $operatorList = array('=', '!=', '<', '>', '<=', '>=', '<>'); |
|
| 86 | 86 | |
| 87 | 87 | |
| 88 | 88 | /** |
| 89 | 89 | * The prefix used in each database table |
| 90 | 90 | * @var string |
| 91 | 91 | */ |
| 92 | - private $prefix = null; |
|
| 92 | + private $prefix = null; |
|
| 93 | 93 | |
| 94 | 94 | |
| 95 | 95 | /** |
| 96 | 96 | * The PDO instance |
| 97 | 97 | * @var object |
| 98 | 98 | */ |
| 99 | - private $pdo = null; |
|
| 99 | + private $pdo = null; |
|
| 100 | 100 | |
| 101 | 101 | /** |
| 102 | 102 | * The database driver name used |
| 103 | 103 | * @var string |
| 104 | 104 | */ |
| 105 | - private $driver = null; |
|
| 105 | + private $driver = null; |
|
| 106 | 106 | |
| 107 | 107 | |
| 108 | 108 | /** |
| 109 | 109 | * Construct new DatabaseQueryBuilder |
| 110 | 110 | * @param object $pdo the PDO object |
| 111 | 111 | */ |
| 112 | - public function __construct(PDO $pdo = null){ |
|
| 113 | - if (is_object($pdo)){ |
|
| 112 | + public function __construct(PDO $pdo = null) { |
|
| 113 | + if (is_object($pdo)) { |
|
| 114 | 114 | $this->setPdo($pdo); |
| 115 | 115 | } |
| 116 | 116 | } |
@@ -120,10 +120,10 @@ discard block |
||
| 120 | 120 | * @param string|array $table the table name or array of table list |
| 121 | 121 | * @return object the current DatabaseQueryBuilder instance |
| 122 | 122 | */ |
| 123 | - public function from($table){ |
|
| 124 | - if (is_array($table)){ |
|
| 123 | + public function from($table) { |
|
| 124 | + if (is_array($table)) { |
|
| 125 | 125 | $froms = ''; |
| 126 | - foreach($table as $key){ |
|
| 126 | + foreach ($table as $key) { |
|
| 127 | 127 | $froms .= $this->getPrefix() . $key . ', '; |
| 128 | 128 | } |
| 129 | 129 | $this->from = rtrim($froms, ', '); |
@@ -138,7 +138,7 @@ discard block |
||
| 138 | 138 | * @param string|array $fields the field name or array of field list |
| 139 | 139 | * @return object the current DatabaseQueryBuilder instance |
| 140 | 140 | */ |
| 141 | - public function select($fields){ |
|
| 141 | + public function select($fields) { |
|
| 142 | 142 | $select = (is_array($fields) ? implode(', ', $fields) : $fields); |
| 143 | 143 | $this->select = (($this->select == '*' || empty($this->select)) ? $select : $this->select . ', ' . $select); |
| 144 | 144 | return $this; |
@@ -149,7 +149,7 @@ discard block |
||
| 149 | 149 | * @param string $field the field name to distinct |
| 150 | 150 | * @return object the current DatabaseQueryBuilder instance |
| 151 | 151 | */ |
| 152 | - public function distinct($field){ |
|
| 152 | + public function distinct($field) { |
|
| 153 | 153 | $distinct = ' DISTINCT ' . $field; |
| 154 | 154 | $this->select = (($this->select == '*' || empty($this->select)) ? $distinct : $this->select . ', ' . $distinct); |
| 155 | 155 | return $this; |
@@ -161,7 +161,7 @@ discard block |
||
| 161 | 161 | * @param string $name if is not null represent the alias used for this field in the result |
| 162 | 162 | * @return object the current DatabaseQueryBuilder instance |
| 163 | 163 | */ |
| 164 | - public function count($field = '*', $name = null){ |
|
| 164 | + public function count($field = '*', $name = null) { |
|
| 165 | 165 | return $this->select_min_max_sum_count_avg('COUNT', $field, $name); |
| 166 | 166 | } |
| 167 | 167 | |
@@ -171,7 +171,7 @@ discard block |
||
| 171 | 171 | * @param string $name if is not null represent the alias used for this field in the result |
| 172 | 172 | * @return object the current DatabaseQueryBuilder instance |
| 173 | 173 | */ |
| 174 | - public function min($field, $name = null){ |
|
| 174 | + public function min($field, $name = null) { |
|
| 175 | 175 | return $this->select_min_max_sum_count_avg('MIN', $field, $name); |
| 176 | 176 | } |
| 177 | 177 | |
@@ -181,7 +181,7 @@ discard block |
||
| 181 | 181 | * @param string $name if is not null represent the alias used for this field in the result |
| 182 | 182 | * @return object the current DatabaseQueryBuilder instance |
| 183 | 183 | */ |
| 184 | - public function max($field, $name = null){ |
|
| 184 | + public function max($field, $name = null) { |
|
| 185 | 185 | return $this->select_min_max_sum_count_avg('MAX', $field, $name); |
| 186 | 186 | } |
| 187 | 187 | |
@@ -191,7 +191,7 @@ discard block |
||
| 191 | 191 | * @param string $name if is not null represent the alias used for this field in the result |
| 192 | 192 | * @return object the current DatabaseQueryBuilder instance |
| 193 | 193 | */ |
| 194 | - public function sum($field, $name = null){ |
|
| 194 | + public function sum($field, $name = null) { |
|
| 195 | 195 | return $this->select_min_max_sum_count_avg('SUM', $field, $name); |
| 196 | 196 | } |
| 197 | 197 | |
@@ -201,7 +201,7 @@ discard block |
||
| 201 | 201 | * @param string $name if is not null represent the alias used for this field in the result |
| 202 | 202 | * @return object the current DatabaseQueryBuilder instance |
| 203 | 203 | */ |
| 204 | - public function avg($field, $name = null){ |
|
| 204 | + public function avg($field, $name = null) { |
|
| 205 | 205 | return $this->select_min_max_sum_count_avg('AVG', $field, $name); |
| 206 | 206 | } |
| 207 | 207 | |
@@ -215,17 +215,17 @@ discard block |
||
| 215 | 215 | * @param string $type the type of join (INNER, LEFT, RIGHT) |
| 216 | 216 | * @return object the current DatabaseQueryBuilder instance |
| 217 | 217 | */ |
| 218 | - public function join($table, $field1 = null, $op = null, $field2 = null, $type = ''){ |
|
| 218 | + public function join($table, $field1 = null, $op = null, $field2 = null, $type = '') { |
|
| 219 | 219 | $on = $field1; |
| 220 | 220 | $table = $this->getPrefix() . $table; |
| 221 | - if (! is_null($op)){ |
|
| 222 | - $on = (! in_array($op, $this->operatorList) |
|
| 221 | + if (!is_null($op)) { |
|
| 222 | + $on = (!in_array($op, $this->operatorList) |
|
| 223 | 223 | ? ($this->getPrefix() . $field1 . ' = ' . $this->getPrefix() . $op) |
| 224 | 224 | : ($this->getPrefix() . $field1 . ' ' . $op . ' ' . $this->getPrefix() . $field2)); |
| 225 | 225 | } |
| 226 | - if (empty($this->join)){ |
|
| 226 | + if (empty($this->join)) { |
|
| 227 | 227 | $this->join = ' ' . $type . 'JOIN' . ' ' . $table . ' ON ' . $on; |
| 228 | - } else{ |
|
| 228 | + } else { |
|
| 229 | 229 | $this->join = $this->join . ' ' . $type . 'JOIN' . ' ' . $table . ' ON ' . $on; |
| 230 | 230 | } |
| 231 | 231 | return $this; |
@@ -236,7 +236,7 @@ discard block |
||
| 236 | 236 | * @see DatabaseQueryBuilder::join() |
| 237 | 237 | * @return object the current DatabaseQueryBuilder instance |
| 238 | 238 | */ |
| 239 | - public function innerJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 239 | + public function innerJoin($table, $field1, $op = null, $field2 = '') { |
|
| 240 | 240 | return $this->join($table, $field1, $op, $field2, 'INNER '); |
| 241 | 241 | } |
| 242 | 242 | |
@@ -245,7 +245,7 @@ discard block |
||
| 245 | 245 | * @see DatabaseQueryBuilder::join() |
| 246 | 246 | * @return object the current DatabaseQueryBuilder instance |
| 247 | 247 | */ |
| 248 | - public function leftJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 248 | + public function leftJoin($table, $field1, $op = null, $field2 = '') { |
|
| 249 | 249 | return $this->join($table, $field1, $op, $field2, 'LEFT '); |
| 250 | 250 | } |
| 251 | 251 | |
@@ -254,7 +254,7 @@ discard block |
||
| 254 | 254 | * @see DatabaseQueryBuilder::join() |
| 255 | 255 | * @return object the current DatabaseQueryBuilder instance |
| 256 | 256 | */ |
| 257 | - public function rightJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 257 | + public function rightJoin($table, $field1, $op = null, $field2 = '') { |
|
| 258 | 258 | return $this->join($table, $field1, $op, $field2, 'RIGHT '); |
| 259 | 259 | } |
| 260 | 260 | |
@@ -263,7 +263,7 @@ discard block |
||
| 263 | 263 | * @see DatabaseQueryBuilder::join() |
| 264 | 264 | * @return object the current DatabaseQueryBuilder instance |
| 265 | 265 | */ |
| 266 | - public function fullOuterJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 266 | + public function fullOuterJoin($table, $field1, $op = null, $field2 = '') { |
|
| 267 | 267 | return $this->join($table, $field1, $op, $field2, 'FULL OUTER '); |
| 268 | 268 | } |
| 269 | 269 | |
@@ -272,7 +272,7 @@ discard block |
||
| 272 | 272 | * @see DatabaseQueryBuilder::join() |
| 273 | 273 | * @return object the current DatabaseQueryBuilder instance |
| 274 | 274 | */ |
| 275 | - public function leftOuterJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 275 | + public function leftOuterJoin($table, $field1, $op = null, $field2 = '') { |
|
| 276 | 276 | return $this->join($table, $field1, $op, $field2, 'LEFT OUTER '); |
| 277 | 277 | } |
| 278 | 278 | |
@@ -281,7 +281,7 @@ discard block |
||
| 281 | 281 | * @see DatabaseQueryBuilder::join() |
| 282 | 282 | * @return object the current DatabaseQueryBuilder instance |
| 283 | 283 | */ |
| 284 | - public function rightOuterJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 284 | + public function rightOuterJoin($table, $field1, $op = null, $field2 = '') { |
|
| 285 | 285 | return $this->join($table, $field1, $op, $field2, 'RIGHT OUTER '); |
| 286 | 286 | } |
| 287 | 287 | |
@@ -291,13 +291,13 @@ discard block |
||
| 291 | 291 | * @param string $andOr the separator type used 'AND', 'OR', etc. |
| 292 | 292 | * @return object the current DatabaseQueryBuilder instance |
| 293 | 293 | */ |
| 294 | - public function whereIsNull($field, $andOr = 'AND'){ |
|
| 295 | - if (is_array($field)){ |
|
| 296 | - foreach($field as $f){ |
|
| 294 | + public function whereIsNull($field, $andOr = 'AND') { |
|
| 295 | + if (is_array($field)) { |
|
| 296 | + foreach ($field as $f) { |
|
| 297 | 297 | $this->whereIsNull($f, $andOr); |
| 298 | 298 | } |
| 299 | 299 | } else { |
| 300 | - $this->setWhereStr($field.' IS NULL ', $andOr); |
|
| 300 | + $this->setWhereStr($field . ' IS NULL ', $andOr); |
|
| 301 | 301 | } |
| 302 | 302 | return $this; |
| 303 | 303 | } |
@@ -308,13 +308,13 @@ discard block |
||
| 308 | 308 | * @param string $andOr the separator type used 'AND', 'OR', etc. |
| 309 | 309 | * @return object the current DatabaseQueryBuilder instance |
| 310 | 310 | */ |
| 311 | - public function whereIsNotNull($field, $andOr = 'AND'){ |
|
| 312 | - if (is_array($field)){ |
|
| 313 | - foreach($field as $f){ |
|
| 311 | + public function whereIsNotNull($field, $andOr = 'AND') { |
|
| 312 | + if (is_array($field)) { |
|
| 313 | + foreach ($field as $f) { |
|
| 314 | 314 | $this->whereIsNotNull($f, $andOr); |
| 315 | 315 | } |
| 316 | 316 | } else { |
| 317 | - $this->setWhereStr($field.' IS NOT NULL ', $andOr); |
|
| 317 | + $this->setWhereStr($field . ' IS NOT NULL ', $andOr); |
|
| 318 | 318 | } |
| 319 | 319 | return $this; |
| 320 | 320 | } |
@@ -329,12 +329,12 @@ discard block |
||
| 329 | 329 | * @param boolean $escape whether to escape or not the $val |
| 330 | 330 | * @return object the current DatabaseQueryBuilder instance |
| 331 | 331 | */ |
| 332 | - public function where($where, $op = null, $val = null, $type = '', $andOr = 'AND', $escape = true){ |
|
| 332 | + public function where($where, $op = null, $val = null, $type = '', $andOr = 'AND', $escape = true) { |
|
| 333 | 333 | $whereStr = ''; |
| 334 | - if (is_array($where)){ |
|
| 334 | + if (is_array($where)) { |
|
| 335 | 335 | $whereStr = $this->getWhereStrIfIsArray($where, $type, $andOr, $escape); |
| 336 | - } else{ |
|
| 337 | - if (is_array($op)){ |
|
| 336 | + } else { |
|
| 337 | + if (is_array($op)) { |
|
| 338 | 338 | $whereStr = $this->getWhereStrIfOperatorIsArray($where, $op, $type, $escape); |
| 339 | 339 | } else { |
| 340 | 340 | $whereStr = $this->getWhereStrForOperator($where, $op, $val, $type, $escape); |
@@ -349,7 +349,7 @@ discard block |
||
| 349 | 349 | * @see DatabaseQueryBuilder::where() |
| 350 | 350 | * @return object the current DatabaseQueryBuilder instance |
| 351 | 351 | */ |
| 352 | - public function orWhere($where, $op = null, $val = null, $escape = true){ |
|
| 352 | + public function orWhere($where, $op = null, $val = null, $escape = true) { |
|
| 353 | 353 | return $this->where($where, $op, $val, '', 'OR', $escape); |
| 354 | 354 | } |
| 355 | 355 | |
@@ -359,7 +359,7 @@ discard block |
||
| 359 | 359 | * @see DatabaseQueryBuilder::where() |
| 360 | 360 | * @return object the current DatabaseQueryBuilder instance |
| 361 | 361 | */ |
| 362 | - public function notWhere($where, $op = null, $val = null, $escape = true){ |
|
| 362 | + public function notWhere($where, $op = null, $val = null, $escape = true) { |
|
| 363 | 363 | return $this->where($where, $op, $val, 'NOT ', 'AND', $escape); |
| 364 | 364 | } |
| 365 | 365 | |
@@ -368,7 +368,7 @@ discard block |
||
| 368 | 368 | * @see DatabaseQueryBuilder::where() |
| 369 | 369 | * @return object the current DatabaseQueryBuilder instance |
| 370 | 370 | */ |
| 371 | - public function orNotWhere($where, $op = null, $val = null, $escape = true){ |
|
| 371 | + public function orNotWhere($where, $op = null, $val = null, $escape = true) { |
|
| 372 | 372 | return $this->where($where, $op, $val, 'NOT ', 'OR', $escape); |
| 373 | 373 | } |
| 374 | 374 | |
@@ -378,11 +378,11 @@ discard block |
||
| 378 | 378 | * @param string $andOr the multiple conditions separator (AND, OR, etc.) |
| 379 | 379 | * @return object the current DatabaseQueryBuilder instance |
| 380 | 380 | */ |
| 381 | - public function groupStart($type = '', $andOr = ' AND'){ |
|
| 382 | - if (empty($this->where)){ |
|
| 381 | + public function groupStart($type = '', $andOr = ' AND') { |
|
| 382 | + if (empty($this->where)) { |
|
| 383 | 383 | $this->where = $type . ' ('; |
| 384 | 384 | } else { |
| 385 | - if (substr(trim($this->where), -1) == '('){ |
|
| 385 | + if (substr(trim($this->where), -1) == '(') { |
|
| 386 | 386 | $this->where .= $type . ' ('; |
| 387 | 387 | } else { |
| 388 | 388 | $this->where .= $andOr . ' ' . $type . ' ('; |
@@ -396,7 +396,7 @@ discard block |
||
| 396 | 396 | * @see DatabaseQueryBuilder::groupStart() |
| 397 | 397 | * @return object the current DatabaseQueryBuilder instance |
| 398 | 398 | */ |
| 399 | - public function notGroupStart(){ |
|
| 399 | + public function notGroupStart() { |
|
| 400 | 400 | return $this->groupStart('NOT'); |
| 401 | 401 | } |
| 402 | 402 | |
@@ -405,7 +405,7 @@ discard block |
||
| 405 | 405 | * @see DatabaseQueryBuilder::groupStart() |
| 406 | 406 | * @return object the current DatabaseQueryBuilder instance |
| 407 | 407 | */ |
| 408 | - public function orGroupStart(){ |
|
| 408 | + public function orGroupStart() { |
|
| 409 | 409 | return $this->groupStart('', ' OR'); |
| 410 | 410 | } |
| 411 | 411 | |
@@ -414,7 +414,7 @@ discard block |
||
| 414 | 414 | * @see DatabaseQueryBuilder::groupStart() |
| 415 | 415 | * @return object the current DatabaseQueryBuilder instance |
| 416 | 416 | */ |
| 417 | - public function orNotGroupStart(){ |
|
| 417 | + public function orNotGroupStart() { |
|
| 418 | 418 | return $this->groupStart('NOT', ' OR'); |
| 419 | 419 | } |
| 420 | 420 | |
@@ -422,7 +422,7 @@ discard block |
||
| 422 | 422 | * Close the parenthesis for the grouped SQL |
| 423 | 423 | * @return object the current DatabaseQueryBuilder instance |
| 424 | 424 | */ |
| 425 | - public function groupEnd(){ |
|
| 425 | + public function groupEnd() { |
|
| 426 | 426 | $this->where .= ')'; |
| 427 | 427 | return $this; |
| 428 | 428 | } |
@@ -436,10 +436,10 @@ discard block |
||
| 436 | 436 | * @param boolean $escape whether to escape or not the values |
| 437 | 437 | * @return object the current DatabaseQueryBuilder instance |
| 438 | 438 | */ |
| 439 | - public function in($field, array $keys, $type = '', $andOr = 'AND', $escape = true){ |
|
| 439 | + public function in($field, array $keys, $type = '', $andOr = 'AND', $escape = true) { |
|
| 440 | 440 | $_keys = array(); |
| 441 | - foreach ($keys as $k => $v){ |
|
| 442 | - if (is_null($v)){ |
|
| 441 | + foreach ($keys as $k => $v) { |
|
| 442 | + if (is_null($v)) { |
|
| 443 | 443 | $v = ''; |
| 444 | 444 | } |
| 445 | 445 | $_keys[] = (is_numeric($v) ? $v : $this->escape($v, $escape)); |
@@ -455,7 +455,7 @@ discard block |
||
| 455 | 455 | * @see DatabaseQueryBuilder::in() |
| 456 | 456 | * @return object the current DatabaseQueryBuilder instance |
| 457 | 457 | */ |
| 458 | - public function notIn($field, array $keys, $escape = true){ |
|
| 458 | + public function notIn($field, array $keys, $escape = true) { |
|
| 459 | 459 | return $this->in($field, $keys, 'NOT ', 'AND', $escape); |
| 460 | 460 | } |
| 461 | 461 | |
@@ -464,7 +464,7 @@ discard block |
||
| 464 | 464 | * @see DatabaseQueryBuilder::in() |
| 465 | 465 | * @return object the current DatabaseQueryBuilder instance |
| 466 | 466 | */ |
| 467 | - public function orIn($field, array $keys, $escape = true){ |
|
| 467 | + public function orIn($field, array $keys, $escape = true) { |
|
| 468 | 468 | return $this->in($field, $keys, '', 'OR', $escape); |
| 469 | 469 | } |
| 470 | 470 | |
@@ -473,7 +473,7 @@ discard block |
||
| 473 | 473 | * @see DatabaseQueryBuilder::in() |
| 474 | 474 | * @return object the current DatabaseQueryBuilder instance |
| 475 | 475 | */ |
| 476 | - public function orNotIn($field, array $keys, $escape = true){ |
|
| 476 | + public function orNotIn($field, array $keys, $escape = true) { |
|
| 477 | 477 | return $this->in($field, $keys, 'NOT ', 'OR', $escape); |
| 478 | 478 | } |
| 479 | 479 | |
@@ -487,11 +487,11 @@ discard block |
||
| 487 | 487 | * @param boolean $escape whether to escape or not the values |
| 488 | 488 | * @return object the current DatabaseQueryBuilder instance |
| 489 | 489 | */ |
| 490 | - public function between($field, $value1, $value2, $type = '', $andOr = 'AND', $escape = true){ |
|
| 491 | - if (is_null($value1)){ |
|
| 490 | + public function between($field, $value1, $value2, $type = '', $andOr = 'AND', $escape = true) { |
|
| 491 | + if (is_null($value1)) { |
|
| 492 | 492 | $value1 = ''; |
| 493 | 493 | } |
| 494 | - if (is_null($value2)){ |
|
| 494 | + if (is_null($value2)) { |
|
| 495 | 495 | $value2 = ''; |
| 496 | 496 | } |
| 497 | 497 | $whereStr = $field . ' ' . $type . ' BETWEEN ' . $this->escape($value1, $escape) . ' AND ' . $this->escape($value2, $escape); |
@@ -504,7 +504,7 @@ discard block |
||
| 504 | 504 | * @see DatabaseQueryBuilder::between() |
| 505 | 505 | * @return object the current DatabaseQueryBuilder instance |
| 506 | 506 | */ |
| 507 | - public function notBetween($field, $value1, $value2, $escape = true){ |
|
| 507 | + public function notBetween($field, $value1, $value2, $escape = true) { |
|
| 508 | 508 | return $this->between($field, $value1, $value2, 'NOT ', 'AND', $escape); |
| 509 | 509 | } |
| 510 | 510 | |
@@ -513,7 +513,7 @@ discard block |
||
| 513 | 513 | * @see DatabaseQueryBuilder::between() |
| 514 | 514 | * @return object the current DatabaseQueryBuilder instance |
| 515 | 515 | */ |
| 516 | - public function orBetween($field, $value1, $value2, $escape = true){ |
|
| 516 | + public function orBetween($field, $value1, $value2, $escape = true) { |
|
| 517 | 517 | return $this->between($field, $value1, $value2, '', 'OR', $escape); |
| 518 | 518 | } |
| 519 | 519 | |
@@ -522,7 +522,7 @@ discard block |
||
| 522 | 522 | * @see DatabaseQueryBuilder::between() |
| 523 | 523 | * @return object the current DatabaseQueryBuilder instance |
| 524 | 524 | */ |
| 525 | - public function orNotBetween($field, $value1, $value2, $escape = true){ |
|
| 525 | + public function orNotBetween($field, $value1, $value2, $escape = true) { |
|
| 526 | 526 | return $this->between($field, $value1, $value2, 'NOT ', 'OR', $escape); |
| 527 | 527 | } |
| 528 | 528 | |
@@ -535,8 +535,8 @@ discard block |
||
| 535 | 535 | * @param boolean $escape whether to escape or not the values |
| 536 | 536 | * @return object the current DatabaseQueryBuilder instance |
| 537 | 537 | */ |
| 538 | - public function like($field, $data, $type = '', $andOr = 'AND', $escape = true){ |
|
| 539 | - if (empty($data)){ |
|
| 538 | + public function like($field, $data, $type = '', $andOr = 'AND', $escape = true) { |
|
| 539 | + if (empty($data)) { |
|
| 540 | 540 | $data = ''; |
| 541 | 541 | } |
| 542 | 542 | $this->setWhereStr($field . ' ' . $type . ' LIKE ' . ($this->escape($data, $escape)), $andOr); |
@@ -548,7 +548,7 @@ discard block |
||
| 548 | 548 | * @see DatabaseQueryBuilder::like() |
| 549 | 549 | * @return object the current DatabaseQueryBuilder instance |
| 550 | 550 | */ |
| 551 | - public function orLike($field, $data, $escape = true){ |
|
| 551 | + public function orLike($field, $data, $escape = true) { |
|
| 552 | 552 | return $this->like($field, $data, '', 'OR', $escape); |
| 553 | 553 | } |
| 554 | 554 | |
@@ -557,7 +557,7 @@ discard block |
||
| 557 | 557 | * @see DatabaseQueryBuilder::like() |
| 558 | 558 | * @return object the current DatabaseQueryBuilder instance |
| 559 | 559 | */ |
| 560 | - public function notLike($field, $data, $escape = true){ |
|
| 560 | + public function notLike($field, $data, $escape = true) { |
|
| 561 | 561 | return $this->like($field, $data, 'NOT ', 'AND', $escape); |
| 562 | 562 | } |
| 563 | 563 | |
@@ -566,7 +566,7 @@ discard block |
||
| 566 | 566 | * @see DatabaseQueryBuilder::like() |
| 567 | 567 | * @return object the current DatabaseQueryBuilder instance |
| 568 | 568 | */ |
| 569 | - public function orNotLike($field, $data, $escape = true){ |
|
| 569 | + public function orNotLike($field, $data, $escape = true) { |
|
| 570 | 570 | return $this->like($field, $data, 'NOT ', 'OR', $escape); |
| 571 | 571 | } |
| 572 | 572 | |
@@ -577,13 +577,13 @@ discard block |
||
| 577 | 577 | * @param int $limitEnd the limit count |
| 578 | 578 | * @return object the current DatabaseQueryBuilder instance |
| 579 | 579 | */ |
| 580 | - public function limit($limit, $limitEnd = null){ |
|
| 581 | - if (empty($limit)){ |
|
| 580 | + public function limit($limit, $limitEnd = null) { |
|
| 581 | + if (empty($limit)) { |
|
| 582 | 582 | $limit = 0; |
| 583 | 583 | } |
| 584 | - if (! is_null($limitEnd)){ |
|
| 584 | + if (!is_null($limitEnd)) { |
|
| 585 | 585 | $this->limit = $limit . ', ' . $limitEnd; |
| 586 | - } else{ |
|
| 586 | + } else { |
|
| 587 | 587 | $this->limit = $limit; |
| 588 | 588 | } |
| 589 | 589 | return $this; |
@@ -595,10 +595,10 @@ discard block |
||
| 595 | 595 | * @param string $orderDir the order direction (ASC or DESC) |
| 596 | 596 | * @return object the current DatabaseQueryBuilder instance |
| 597 | 597 | */ |
| 598 | - public function orderBy($orderBy, $orderDir = ' ASC'){ |
|
| 599 | - if (stristr($orderBy, ' ') || $orderBy == 'rand()'){ |
|
| 598 | + public function orderBy($orderBy, $orderDir = ' ASC') { |
|
| 599 | + if (stristr($orderBy, ' ') || $orderBy == 'rand()') { |
|
| 600 | 600 | $this->orderBy = empty($this->orderBy) ? $orderBy : $this->orderBy . ', ' . $orderBy; |
| 601 | - } else{ |
|
| 601 | + } else { |
|
| 602 | 602 | $this->orderBy = empty($this->orderBy) |
| 603 | 603 | ? ($orderBy . ' ' . strtoupper($orderDir)) |
| 604 | 604 | : $this->orderBy . ', ' . $orderBy . ' ' . strtoupper($orderDir); |
@@ -611,10 +611,10 @@ discard block |
||
| 611 | 611 | * @param string|array $field the field name used or array of field list |
| 612 | 612 | * @return object the current DatabaseQueryBuilder instance |
| 613 | 613 | */ |
| 614 | - public function groupBy($field){ |
|
| 615 | - if (is_array($field)){ |
|
| 614 | + public function groupBy($field) { |
|
| 615 | + if (is_array($field)) { |
|
| 616 | 616 | $this->groupBy = implode(', ', $field); |
| 617 | - } else{ |
|
| 617 | + } else { |
|
| 618 | 618 | $this->groupBy = $field; |
| 619 | 619 | } |
| 620 | 620 | return $this; |
@@ -628,16 +628,16 @@ discard block |
||
| 628 | 628 | * @param boolean $escape whether to escape or not the values |
| 629 | 629 | * @return object the current DatabaseQueryBuilder instance |
| 630 | 630 | */ |
| 631 | - public function having($field, $op = null, $val = null, $escape = true){ |
|
| 632 | - if (is_array($op)){ |
|
| 631 | + public function having($field, $op = null, $val = null, $escape = true) { |
|
| 632 | + if (is_array($op)) { |
|
| 633 | 633 | $this->having = $this->getHavingStrIfOperatorIsArray($field, $op, $escape); |
| 634 | - } else if (! in_array($op, $this->operatorList)){ |
|
| 635 | - if (is_null($op)){ |
|
| 634 | + } else if (!in_array($op, $this->operatorList)) { |
|
| 635 | + if (is_null($op)) { |
|
| 636 | 636 | $op = ''; |
| 637 | 637 | } |
| 638 | 638 | $this->having = $field . ' > ' . ($this->escape($op, $escape)); |
| 639 | - } else{ |
|
| 640 | - if (is_null($val)){ |
|
| 639 | + } else { |
|
| 640 | + if (is_null($val)) { |
|
| 641 | 641 | $val = ''; |
| 642 | 642 | } |
| 643 | 643 | $this->having = $field . ' ' . $op . ' ' . ($this->escape($val, $escape)); |
@@ -651,7 +651,7 @@ discard block |
||
| 651 | 651 | * @param boolean $escape whether to escape or not the values |
| 652 | 652 | * @return object the current DatabaseQueryBuilder instance |
| 653 | 653 | */ |
| 654 | - public function insert($data = array(), $escape = true){ |
|
| 654 | + public function insert($data = array(), $escape = true) { |
|
| 655 | 655 | $columns = array_keys($data); |
| 656 | 656 | $column = implode(', ', $columns); |
| 657 | 657 | $val = implode(', ', ($escape ? array_map(array($this, 'escape'), $data) : $data)); |
@@ -666,22 +666,22 @@ discard block |
||
| 666 | 666 | * @param boolean $escape whether to escape or not the values |
| 667 | 667 | * @return object the current DatabaseQueryBuilder instance |
| 668 | 668 | */ |
| 669 | - public function update($data = array(), $escape = true){ |
|
| 669 | + public function update($data = array(), $escape = true) { |
|
| 670 | 670 | $query = 'UPDATE ' . $this->from . ' SET '; |
| 671 | 671 | $values = array(); |
| 672 | - foreach ($data as $column => $val){ |
|
| 672 | + foreach ($data as $column => $val) { |
|
| 673 | 673 | $values[] = $column . ' = ' . ($this->escape($val, $escape)); |
| 674 | 674 | } |
| 675 | 675 | $query .= implode(', ', $values); |
| 676 | - if (! empty($this->where)){ |
|
| 676 | + if (!empty($this->where)) { |
|
| 677 | 677 | $query .= ' WHERE ' . $this->where; |
| 678 | 678 | } |
| 679 | 679 | |
| 680 | - if (! empty($this->orderBy)){ |
|
| 680 | + if (!empty($this->orderBy)) { |
|
| 681 | 681 | $query .= ' ORDER BY ' . $this->orderBy; |
| 682 | 682 | } |
| 683 | 683 | |
| 684 | - if (! empty($this->limit)){ |
|
| 684 | + if (!empty($this->limit)) { |
|
| 685 | 685 | $query .= ' LIMIT ' . $this->limit; |
| 686 | 686 | } |
| 687 | 687 | $this->query = $query; |
@@ -692,22 +692,22 @@ discard block |
||
| 692 | 692 | * Delete the record in database |
| 693 | 693 | * @return object the current DatabaseQueryBuilder instance |
| 694 | 694 | */ |
| 695 | - public function delete(){ |
|
| 695 | + public function delete() { |
|
| 696 | 696 | $query = 'DELETE FROM ' . $this->from; |
| 697 | 697 | $isTruncate = $query; |
| 698 | - if (! empty($this->where)){ |
|
| 698 | + if (!empty($this->where)) { |
|
| 699 | 699 | $query .= ' WHERE ' . $this->where; |
| 700 | 700 | } |
| 701 | 701 | |
| 702 | - if (! empty($this->orderBy)){ |
|
| 702 | + if (!empty($this->orderBy)) { |
|
| 703 | 703 | $query .= ' ORDER BY ' . $this->orderBy; |
| 704 | 704 | } |
| 705 | 705 | |
| 706 | - if (! empty($this->limit)){ |
|
| 706 | + if (!empty($this->limit)) { |
|
| 707 | 707 | $query .= ' LIMIT ' . $this->limit; |
| 708 | 708 | } |
| 709 | 709 | |
| 710 | - if ($isTruncate == $query && $this->driver != 'sqlite'){ |
|
| 710 | + if ($isTruncate == $query && $this->driver != 'sqlite') { |
|
| 711 | 711 | $query = 'TRUNCATE TABLE ' . $this->from; |
| 712 | 712 | } |
| 713 | 713 | $this->query = $query; |
@@ -720,9 +720,9 @@ discard block |
||
| 720 | 720 | * @param boolean $escaped whether we can do escape of not |
| 721 | 721 | * @return mixed the data after escaped or the same data if not |
| 722 | 722 | */ |
| 723 | - public function escape($data, $escaped = true){ |
|
| 723 | + public function escape($data, $escaped = true) { |
|
| 724 | 724 | $data = trim($data); |
| 725 | - if($escaped){ |
|
| 725 | + if ($escaped) { |
|
| 726 | 726 | return $this->pdo->quote($data); |
| 727 | 727 | } |
| 728 | 728 | return $data; |
@@ -733,31 +733,31 @@ discard block |
||
| 733 | 733 | * Return the current SQL query string |
| 734 | 734 | * @return string |
| 735 | 735 | */ |
| 736 | - public function getQuery(){ |
|
| 736 | + public function getQuery() { |
|
| 737 | 737 | //INSERT, UPDATE, DELETE already set it, if is the SELECT we need set it now |
| 738 | - if(empty($this->query)){ |
|
| 738 | + if (empty($this->query)) { |
|
| 739 | 739 | $query = 'SELECT ' . $this->select . ' FROM ' . $this->from; |
| 740 | - if (! empty($this->join)){ |
|
| 740 | + if (!empty($this->join)) { |
|
| 741 | 741 | $query .= $this->join; |
| 742 | 742 | } |
| 743 | 743 | |
| 744 | - if (! empty($this->where)){ |
|
| 744 | + if (!empty($this->where)) { |
|
| 745 | 745 | $query .= ' WHERE ' . $this->where; |
| 746 | 746 | } |
| 747 | 747 | |
| 748 | - if (! empty($this->groupBy)){ |
|
| 748 | + if (!empty($this->groupBy)) { |
|
| 749 | 749 | $query .= ' GROUP BY ' . $this->groupBy; |
| 750 | 750 | } |
| 751 | 751 | |
| 752 | - if (! empty($this->having)){ |
|
| 752 | + if (!empty($this->having)) { |
|
| 753 | 753 | $query .= ' HAVING ' . $this->having; |
| 754 | 754 | } |
| 755 | 755 | |
| 756 | - if (! empty($this->orderBy)){ |
|
| 756 | + if (!empty($this->orderBy)) { |
|
| 757 | 757 | $query .= ' ORDER BY ' . $this->orderBy; |
| 758 | 758 | } |
| 759 | 759 | |
| 760 | - if (! empty($this->limit)){ |
|
| 760 | + if (!empty($this->limit)) { |
|
| 761 | 761 | $query .= ' LIMIT ' . $this->limit; |
| 762 | 762 | } |
| 763 | 763 | $this->query = $query; |
@@ -770,7 +770,7 @@ discard block |
||
| 770 | 770 | * Return the PDO instance |
| 771 | 771 | * @return object |
| 772 | 772 | */ |
| 773 | - public function getPdo(){ |
|
| 773 | + public function getPdo() { |
|
| 774 | 774 | return $this->pdo; |
| 775 | 775 | } |
| 776 | 776 | |
@@ -779,7 +779,7 @@ discard block |
||
| 779 | 779 | * @param PDO $pdo the pdo object |
| 780 | 780 | * @return object DatabaseQueryBuilder |
| 781 | 781 | */ |
| 782 | - public function setPdo(PDO $pdo = null){ |
|
| 782 | + public function setPdo(PDO $pdo = null) { |
|
| 783 | 783 | $this->pdo = $pdo; |
| 784 | 784 | return $this; |
| 785 | 785 | } |
@@ -788,7 +788,7 @@ discard block |
||
| 788 | 788 | * Return the database table prefix |
| 789 | 789 | * @return string |
| 790 | 790 | */ |
| 791 | - public function getPrefix(){ |
|
| 791 | + public function getPrefix() { |
|
| 792 | 792 | return $this->prefix; |
| 793 | 793 | } |
| 794 | 794 | |
@@ -797,7 +797,7 @@ discard block |
||
| 797 | 797 | * @param string $prefix the new prefix |
| 798 | 798 | * @return object DatabaseQueryBuilder |
| 799 | 799 | */ |
| 800 | - public function setPrefix($prefix){ |
|
| 800 | + public function setPrefix($prefix) { |
|
| 801 | 801 | $this->prefix = $prefix; |
| 802 | 802 | return $this; |
| 803 | 803 | } |
@@ -806,7 +806,7 @@ discard block |
||
| 806 | 806 | * Return the database driver |
| 807 | 807 | * @return string |
| 808 | 808 | */ |
| 809 | - public function getDriver(){ |
|
| 809 | + public function getDriver() { |
|
| 810 | 810 | return $this->driver; |
| 811 | 811 | } |
| 812 | 812 | |
@@ -815,7 +815,7 @@ discard block |
||
| 815 | 815 | * @param string $driver the new driver |
| 816 | 816 | * @return object DatabaseQueryBuilder |
| 817 | 817 | */ |
| 818 | - public function setDriver($driver){ |
|
| 818 | + public function setDriver($driver) { |
|
| 819 | 819 | $this->driver = $driver; |
| 820 | 820 | return $this; |
| 821 | 821 | } |
@@ -824,7 +824,7 @@ discard block |
||
| 824 | 824 | * Reset the DatabaseQueryBuilder class attributs to the initial values before each query. |
| 825 | 825 | * @return object the current DatabaseQueryBuilder instance |
| 826 | 826 | */ |
| 827 | - public function reset(){ |
|
| 827 | + public function reset() { |
|
| 828 | 828 | $this->select = '*'; |
| 829 | 829 | $this->from = null; |
| 830 | 830 | $this->where = null; |
@@ -843,12 +843,12 @@ discard block |
||
| 843 | 843 | * |
| 844 | 844 | * @return string |
| 845 | 845 | */ |
| 846 | - protected function getHavingStrIfOperatorIsArray($field, $op = null, $escape = true){ |
|
| 846 | + protected function getHavingStrIfOperatorIsArray($field, $op = null, $escape = true) { |
|
| 847 | 847 | $x = explode('?', $field); |
| 848 | 848 | $w = ''; |
| 849 | - foreach($x as $k => $v){ |
|
| 850 | - if (!empty($v)){ |
|
| 851 | - if (! isset($op[$k])){ |
|
| 849 | + foreach ($x as $k => $v) { |
|
| 850 | + if (!empty($v)) { |
|
| 851 | + if (!isset($op[$k])) { |
|
| 852 | 852 | $op[$k] = ''; |
| 853 | 853 | } |
| 854 | 854 | $w .= $v . (isset($op[$k]) ? $this->escape($op[$k], $escape) : ''); |
@@ -864,15 +864,15 @@ discard block |
||
| 864 | 864 | * |
| 865 | 865 | * @return string |
| 866 | 866 | */ |
| 867 | - protected function getWhereStrIfIsArray(array $where, $type = '', $andOr = 'AND', $escape = true){ |
|
| 867 | + protected function getWhereStrIfIsArray(array $where, $type = '', $andOr = 'AND', $escape = true) { |
|
| 868 | 868 | $_where = array(); |
| 869 | - foreach ($where as $column => $data){ |
|
| 870 | - if (is_null($data)){ |
|
| 869 | + foreach ($where as $column => $data) { |
|
| 870 | + if (is_null($data)) { |
|
| 871 | 871 | $data = ''; |
| 872 | 872 | } |
| 873 | 873 | $_where[] = $type . $column . ' = ' . ($this->escape($data, $escape)); |
| 874 | 874 | } |
| 875 | - $where = implode(' '.$andOr.' ', $_where); |
|
| 875 | + $where = implode(' ' . $andOr . ' ', $_where); |
|
| 876 | 876 | return $where; |
| 877 | 877 | } |
| 878 | 878 | |
@@ -882,12 +882,12 @@ discard block |
||
| 882 | 882 | * |
| 883 | 883 | * @return string |
| 884 | 884 | */ |
| 885 | - protected function getWhereStrIfOperatorIsArray($where, array $op, $type = '', $escape = true){ |
|
| 885 | + protected function getWhereStrIfOperatorIsArray($where, array $op, $type = '', $escape = true) { |
|
| 886 | 886 | $x = explode('?', $where); |
| 887 | 887 | $w = ''; |
| 888 | - foreach($x as $k => $v){ |
|
| 889 | - if (! empty($v)){ |
|
| 890 | - if (isset($op[$k]) && is_null($op[$k])){ |
|
| 888 | + foreach ($x as $k => $v) { |
|
| 889 | + if (!empty($v)) { |
|
| 890 | + if (isset($op[$k]) && is_null($op[$k])) { |
|
| 891 | 891 | $op[$k] = ''; |
| 892 | 892 | } |
| 893 | 893 | $w .= $type . $v . (isset($op[$k]) ? ($this->escape($op[$k], $escape)) : ''); |
@@ -902,15 +902,15 @@ discard block |
||
| 902 | 902 | * |
| 903 | 903 | * @return string |
| 904 | 904 | */ |
| 905 | - protected function getWhereStrForOperator($where, $op = null, $val = null, $type = '', $escape = true){ |
|
| 905 | + protected function getWhereStrForOperator($where, $op = null, $val = null, $type = '', $escape = true) { |
|
| 906 | 906 | $w = ''; |
| 907 | - if (! in_array((string)$op, $this->operatorList)){ |
|
| 908 | - if (is_null($op)){ |
|
| 907 | + if (!in_array((string) $op, $this->operatorList)) { |
|
| 908 | + if (is_null($op)) { |
|
| 909 | 909 | $op = ''; |
| 910 | 910 | } |
| 911 | 911 | $w = $type . $where . ' = ' . ($this->escape($op, $escape)); |
| 912 | 912 | } else { |
| 913 | - if (is_null($val)){ |
|
| 913 | + if (is_null($val)) { |
|
| 914 | 914 | $val = ''; |
| 915 | 915 | } |
| 916 | 916 | $w = $type . $where . $op . ($this->escape($val, $escape)); |
@@ -923,14 +923,14 @@ discard block |
||
| 923 | 923 | * @param string $whereStr the WHERE clause string |
| 924 | 924 | * @param string $andOr the separator type used 'AND', 'OR', etc. |
| 925 | 925 | */ |
| 926 | - protected function setWhereStr($whereStr, $andOr = 'AND'){ |
|
| 927 | - if (empty($this->where)){ |
|
| 926 | + protected function setWhereStr($whereStr, $andOr = 'AND') { |
|
| 927 | + if (empty($this->where)) { |
|
| 928 | 928 | $this->where = $whereStr; |
| 929 | 929 | } else { |
| 930 | - if (substr(trim($this->where), -1) == '('){ |
|
| 930 | + if (substr(trim($this->where), -1) == '(') { |
|
| 931 | 931 | $this->where = $this->where . ' ' . $whereStr; |
| 932 | 932 | } else { |
| 933 | - $this->where = $this->where . ' '.$andOr.' ' . $whereStr; |
|
| 933 | + $this->where = $this->where . ' ' . $andOr . ' ' . $whereStr; |
|
| 934 | 934 | } |
| 935 | 935 | } |
| 936 | 936 | } |
@@ -946,7 +946,7 @@ discard block |
||
| 946 | 946 | * @see DatabaseQueryBuilder::avg |
| 947 | 947 | * @return object |
| 948 | 948 | */ |
| 949 | - protected function select_min_max_sum_count_avg($clause, $field, $name = null){ |
|
| 949 | + protected function select_min_max_sum_count_avg($clause, $field, $name = null) { |
|
| 950 | 950 | $clause = strtoupper($clause); |
| 951 | 951 | $func = $clause . '(' . $field . ')' . (!is_null($name) ? ' AS ' . $name : ''); |
| 952 | 952 | $this->select = ($this->select == '*' ? $func : $this->select . ', ' . $func); |
@@ -128,97 +128,97 @@ discard block |
||
| 128 | 128 | $responseTime = $this->benchmarkInstance->elapsedTime( |
| 129 | 129 | 'DATABASE_QUERY_START(' . $benchmarkMarkerKey . ')', |
| 130 | 130 | 'DATABASE_QUERY_END(' . $benchmarkMarkerKey . ')' |
| 131 | - ); |
|
| 132 | - //TODO use the configuration value for the high response time currently is 1 second |
|
| 131 | + ); |
|
| 132 | + //TODO use the configuration value for the high response time currently is 1 second |
|
| 133 | 133 | if ($responseTime >= 1 ){ |
| 134 | 134 | $this->logger->warning( |
| 135 | 135 | 'High response time while processing database query [' . $this->query . ']. |
| 136 | 136 | The response time is [' .$responseTime. '] sec.' |
| 137 | - ); |
|
| 137 | + ); |
|
| 138 | 138 | } |
| 139 | 139 | |
| 140 | 140 | if ($this->pdoStatment !== false){ |
| 141 | - $isSqlSELECTQuery = stristr($this->query, 'SELECT') !== false; |
|
| 142 | - if($isSqlSELECTQuery){ |
|
| 143 | - $this->setResultForSelect(); |
|
| 144 | - } else{ |
|
| 145 | - $this->setResultForNonSelect(); |
|
| 146 | - } |
|
| 147 | - return $this->queryResult; |
|
| 141 | + $isSqlSELECTQuery = stristr($this->query, 'SELECT') !== false; |
|
| 142 | + if($isSqlSELECTQuery){ |
|
| 143 | + $this->setResultForSelect(); |
|
| 144 | + } else{ |
|
| 145 | + $this->setResultForNonSelect(); |
|
| 146 | + } |
|
| 147 | + return $this->queryResult; |
|
| 148 | 148 | } |
| 149 | 149 | $this->setQueryRunnerError(); |
| 150 | 150 | } |
| 151 | 151 | |
| 152 | - /** |
|
| 153 | - * Return the result for SELECT query |
|
| 154 | - * @see DatabaseQueryRunner::execute |
|
| 155 | - */ |
|
| 152 | + /** |
|
| 153 | + * Return the result for SELECT query |
|
| 154 | + * @see DatabaseQueryRunner::execute |
|
| 155 | + */ |
|
| 156 | 156 | protected function setResultForSelect(){ |
| 157 | - //if need return all result like list of record |
|
| 158 | - $result = null; |
|
| 159 | - $numRows = 0; |
|
| 160 | - $fetchMode = PDO::FETCH_OBJ; |
|
| 161 | - if($this->returnAsArray){ |
|
| 157 | + //if need return all result like list of record |
|
| 158 | + $result = null; |
|
| 159 | + $numRows = 0; |
|
| 160 | + $fetchMode = PDO::FETCH_OBJ; |
|
| 161 | + if($this->returnAsArray){ |
|
| 162 | 162 | $fetchMode = PDO::FETCH_ASSOC; |
| 163 | - } |
|
| 164 | - if ($this->returnAsList){ |
|
| 165 | - $result = $this->pdoStatment->fetchAll($fetchMode); |
|
| 166 | - } else{ |
|
| 167 | - $result = $this->pdoStatment->fetch($fetchMode); |
|
| 168 | - } |
|
| 169 | - //Sqlite and pgsql always return 0 when using rowCount() |
|
| 170 | - if (in_array($this->driver, array('sqlite', 'pgsql'))){ |
|
| 163 | + } |
|
| 164 | + if ($this->returnAsList){ |
|
| 165 | + $result = $this->pdoStatment->fetchAll($fetchMode); |
|
| 166 | + } else{ |
|
| 167 | + $result = $this->pdoStatment->fetch($fetchMode); |
|
| 168 | + } |
|
| 169 | + //Sqlite and pgsql always return 0 when using rowCount() |
|
| 170 | + if (in_array($this->driver, array('sqlite', 'pgsql'))){ |
|
| 171 | 171 | $numRows = count($result); |
| 172 | - } else{ |
|
| 172 | + } else{ |
|
| 173 | 173 | $numRows = $this->pdoStatment->rowCount(); |
| 174 | - } |
|
| 175 | - if(! is_object($this->queryResult)){ |
|
| 176 | - $this->queryResult = & class_loader('DatabaseQueryResult', 'classes/database'); |
|
| 177 | - } |
|
| 178 | - $this->queryResult->setResult($result); |
|
| 179 | - $this->queryResult->setNumRows($numRows); |
|
| 174 | + } |
|
| 175 | + if(! is_object($this->queryResult)){ |
|
| 176 | + $this->queryResult = & class_loader('DatabaseQueryResult', 'classes/database'); |
|
| 177 | + } |
|
| 178 | + $this->queryResult->setResult($result); |
|
| 179 | + $this->queryResult->setNumRows($numRows); |
|
| 180 | 180 | } |
| 181 | 181 | |
| 182 | 182 | /** |
| 183 | - * Return the result for non SELECT query |
|
| 184 | - * @see DatabaseQueryRunner::execute |
|
| 185 | - */ |
|
| 183 | + * Return the result for non SELECT query |
|
| 184 | + * @see DatabaseQueryRunner::execute |
|
| 185 | + */ |
|
| 186 | 186 | protected function setResultForNonSelect(){ |
| 187 | - //Sqlite and pgsql always return 0 when using rowCount() |
|
| 188 | - $result = false; |
|
| 189 | - $numRows = 0; |
|
| 190 | - if (in_array($this->driver, array('sqlite', 'pgsql'))){ |
|
| 187 | + //Sqlite and pgsql always return 0 when using rowCount() |
|
| 188 | + $result = false; |
|
| 189 | + $numRows = 0; |
|
| 190 | + if (in_array($this->driver, array('sqlite', 'pgsql'))){ |
|
| 191 | 191 | $result = true; //to test the result for the query like UPDATE, INSERT, DELETE |
| 192 | 192 | $numRows = 1; //TODO use the correct method to get the exact affected row |
| 193 | - } else{ |
|
| 194 | - //to test the result for the query like UPDATE, INSERT, DELETE |
|
| 195 | - $result = $this->pdoStatment->rowCount() >= 0; |
|
| 196 | - $numRows = $this->pdoStatment->rowCount(); |
|
| 197 | - } |
|
| 198 | - if(! is_object($this->queryResult)){ |
|
| 199 | - $this->queryResult = & class_loader('DatabaseQueryResult', 'classes/database'); |
|
| 200 | - } |
|
| 201 | - $this->queryResult->setResult($result); |
|
| 202 | - $this->queryResult->setNumRows($numRows); |
|
| 193 | + } else{ |
|
| 194 | + //to test the result for the query like UPDATE, INSERT, DELETE |
|
| 195 | + $result = $this->pdoStatment->rowCount() >= 0; |
|
| 196 | + $numRows = $this->pdoStatment->rowCount(); |
|
| 197 | + } |
|
| 198 | + if(! is_object($this->queryResult)){ |
|
| 199 | + $this->queryResult = & class_loader('DatabaseQueryResult', 'classes/database'); |
|
| 200 | + } |
|
| 201 | + $this->queryResult->setResult($result); |
|
| 202 | + $this->queryResult->setNumRows($numRows); |
|
| 203 | 203 | } |
| 204 | 204 | |
| 205 | 205 | |
| 206 | - /** |
|
| 206 | + /** |
|
| 207 | 207 | * Return the benchmark instance |
| 208 | 208 | * @return Benchmark |
| 209 | 209 | */ |
| 210 | 210 | public function getBenchmark() { |
| 211 | - return $this->benchmarkInstance; |
|
| 211 | + return $this->benchmarkInstance; |
|
| 212 | 212 | } |
| 213 | 213 | |
| 214 | 214 | /** |
| 215 | 215 | * Set the benchmark instance |
| 216 | 216 | * @param Benchmark $benchmark the benchmark object |
| 217 | - * @return object DatabaseQueryRunner |
|
| 217 | + * @return object DatabaseQueryRunner |
|
| 218 | 218 | */ |
| 219 | 219 | public function setBenchmark($benchmark) { |
| 220 | - $this->benchmarkInstance = $benchmark; |
|
| 221 | - return $this; |
|
| 220 | + $this->benchmarkInstance = $benchmark; |
|
| 221 | + return $this; |
|
| 222 | 222 | } |
| 223 | 223 | |
| 224 | 224 | /** |
@@ -348,18 +348,18 @@ discard block |
||
| 348 | 348 | * @param object $logger the Log instance if not null |
| 349 | 349 | */ |
| 350 | 350 | protected function setLoggerFromParamOrCreateNewInstance(Log $logger = null){ |
| 351 | - if ($logger !== null){ |
|
| 351 | + if ($logger !== null){ |
|
| 352 | 352 | $this->logger = $logger; |
| 353 | - } else{ |
|
| 354 | - $this->logger =& class_loader('Log', 'classes'); |
|
| 355 | - $this->logger->setLogger('Library::DatabaseQueryRunner'); |
|
| 356 | - } |
|
| 353 | + } else{ |
|
| 354 | + $this->logger =& class_loader('Log', 'classes'); |
|
| 355 | + $this->logger->setLogger('Library::DatabaseQueryRunner'); |
|
| 356 | + } |
|
| 357 | 357 | } |
| 358 | 358 | |
| 359 | 359 | |
| 360 | 360 | /** |
| 361 | - * Reset the instance before run each query |
|
| 362 | - */ |
|
| 361 | + * Reset the instance before run each query |
|
| 362 | + */ |
|
| 363 | 363 | private function reset() { |
| 364 | 364 | $this->error = null; |
| 365 | 365 | $this->pdoStatment = null; |
@@ -23,14 +23,14 @@ discard block |
||
| 23 | 23 | * along with this program; if not, write to the Free Software |
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | 25 | */ |
| 26 | - class DatabaseQueryRunner extends BaseClass{ |
|
| 26 | + class DatabaseQueryRunner extends BaseClass { |
|
| 27 | 27 | |
| 28 | 28 | |
| 29 | 29 | /** |
| 30 | 30 | * The last query result |
| 31 | 31 | * @var object |
| 32 | 32 | */ |
| 33 | - private $queryResult = null; |
|
| 33 | + private $queryResult = null; |
|
| 34 | 34 | |
| 35 | 35 | /** |
| 36 | 36 | * The benchmark instance |
@@ -42,45 +42,45 @@ discard block |
||
| 42 | 42 | * The SQL query statment to execute |
| 43 | 43 | * @var string |
| 44 | 44 | */ |
| 45 | - private $query = null; |
|
| 45 | + private $query = null; |
|
| 46 | 46 | |
| 47 | 47 | /** |
| 48 | 48 | * Indicate if we need return result as list (boolean) |
| 49 | 49 | * or the data used to replace the placeholder (array) |
| 50 | 50 | * @var array|boolean |
| 51 | 51 | */ |
| 52 | - private $returnAsList = true; |
|
| 52 | + private $returnAsList = true; |
|
| 53 | 53 | |
| 54 | 54 | |
| 55 | 55 | /** |
| 56 | 56 | * Indicate if we need return result as array or not |
| 57 | 57 | * @var boolean |
| 58 | 58 | */ |
| 59 | - private $returnAsArray = true; |
|
| 59 | + private $returnAsArray = true; |
|
| 60 | 60 | |
| 61 | 61 | /** |
| 62 | 62 | * The last PDOStatment instance |
| 63 | 63 | * @var object |
| 64 | 64 | */ |
| 65 | - private $pdoStatment = null; |
|
| 65 | + private $pdoStatment = null; |
|
| 66 | 66 | |
| 67 | 67 | /** |
| 68 | 68 | * The error returned for the last query |
| 69 | 69 | * @var string |
| 70 | 70 | */ |
| 71 | - private $error = null; |
|
| 71 | + private $error = null; |
|
| 72 | 72 | |
| 73 | 73 | /** |
| 74 | 74 | * The PDO instance |
| 75 | 75 | * @var object |
| 76 | 76 | */ |
| 77 | - private $pdo = null; |
|
| 77 | + private $pdo = null; |
|
| 78 | 78 | |
| 79 | 79 | /** |
| 80 | 80 | * The database driver name used |
| 81 | 81 | * @var string |
| 82 | 82 | */ |
| 83 | - private $driver = null; |
|
| 83 | + private $driver = null; |
|
| 84 | 84 | |
| 85 | 85 | |
| 86 | 86 | |
@@ -91,9 +91,9 @@ discard block |
||
| 91 | 91 | * @param boolean $returnAsList if need return as list or just one row |
| 92 | 92 | * @param boolean $returnAsArray whether to return the result as array or not |
| 93 | 93 | */ |
| 94 | - public function __construct(PDO $pdo = null, $query = null, $returnAsList = true, $returnAsArray = false){ |
|
| 94 | + public function __construct(PDO $pdo = null, $query = null, $returnAsList = true, $returnAsArray = false) { |
|
| 95 | 95 | parent::__construct(); |
| 96 | - if (is_object($pdo)){ |
|
| 96 | + if (is_object($pdo)) { |
|
| 97 | 97 | $this->pdo = $pdo; |
| 98 | 98 | } |
| 99 | 99 | $this->query = $query; |
@@ -108,13 +108,13 @@ discard block |
||
| 108 | 108 | * |
| 109 | 109 | * @return object|void |
| 110 | 110 | */ |
| 111 | - public function execute(){ |
|
| 111 | + public function execute() { |
|
| 112 | 112 | //reset instance |
| 113 | 113 | $this->reset(); |
| 114 | 114 | |
| 115 | 115 | //for database query execution time |
| 116 | 116 | $benchmarkMarkerKey = $this->getBenchmarkKey(); |
| 117 | - if (! is_object($this->benchmarkInstance)){ |
|
| 117 | + if (!is_object($this->benchmarkInstance)) { |
|
| 118 | 118 | $this->benchmarkInstance = & class_loader('Benchmark'); |
| 119 | 119 | } |
| 120 | 120 | |
@@ -130,18 +130,18 @@ discard block |
||
| 130 | 130 | 'DATABASE_QUERY_END(' . $benchmarkMarkerKey . ')' |
| 131 | 131 | ); |
| 132 | 132 | //TODO use the configuration value for the high response time currently is 1 second |
| 133 | - if ($responseTime >= 1 ){ |
|
| 133 | + if ($responseTime >= 1) { |
|
| 134 | 134 | $this->logger->warning( |
| 135 | 135 | 'High response time while processing database query [' . $this->query . ']. |
| 136 | - The response time is [' .$responseTime. '] sec.' |
|
| 136 | + The response time is [' .$responseTime . '] sec.' |
|
| 137 | 137 | ); |
| 138 | 138 | } |
| 139 | 139 | |
| 140 | - if ($this->pdoStatment !== false){ |
|
| 140 | + if ($this->pdoStatment !== false) { |
|
| 141 | 141 | $isSqlSELECTQuery = stristr($this->query, 'SELECT') !== false; |
| 142 | - if($isSqlSELECTQuery){ |
|
| 142 | + if ($isSqlSELECTQuery) { |
|
| 143 | 143 | $this->setResultForSelect(); |
| 144 | - } else{ |
|
| 144 | + } else { |
|
| 145 | 145 | $this->setResultForNonSelect(); |
| 146 | 146 | } |
| 147 | 147 | return $this->queryResult; |
@@ -153,26 +153,26 @@ discard block |
||
| 153 | 153 | * Return the result for SELECT query |
| 154 | 154 | * @see DatabaseQueryRunner::execute |
| 155 | 155 | */ |
| 156 | - protected function setResultForSelect(){ |
|
| 156 | + protected function setResultForSelect() { |
|
| 157 | 157 | //if need return all result like list of record |
| 158 | 158 | $result = null; |
| 159 | 159 | $numRows = 0; |
| 160 | 160 | $fetchMode = PDO::FETCH_OBJ; |
| 161 | - if($this->returnAsArray){ |
|
| 161 | + if ($this->returnAsArray) { |
|
| 162 | 162 | $fetchMode = PDO::FETCH_ASSOC; |
| 163 | 163 | } |
| 164 | - if ($this->returnAsList){ |
|
| 164 | + if ($this->returnAsList) { |
|
| 165 | 165 | $result = $this->pdoStatment->fetchAll($fetchMode); |
| 166 | - } else{ |
|
| 166 | + } else { |
|
| 167 | 167 | $result = $this->pdoStatment->fetch($fetchMode); |
| 168 | 168 | } |
| 169 | 169 | //Sqlite and pgsql always return 0 when using rowCount() |
| 170 | - if (in_array($this->driver, array('sqlite', 'pgsql'))){ |
|
| 170 | + if (in_array($this->driver, array('sqlite', 'pgsql'))) { |
|
| 171 | 171 | $numRows = count($result); |
| 172 | - } else{ |
|
| 172 | + } else { |
|
| 173 | 173 | $numRows = $this->pdoStatment->rowCount(); |
| 174 | 174 | } |
| 175 | - if(! is_object($this->queryResult)){ |
|
| 175 | + if (!is_object($this->queryResult)) { |
|
| 176 | 176 | $this->queryResult = & class_loader('DatabaseQueryResult', 'classes/database'); |
| 177 | 177 | } |
| 178 | 178 | $this->queryResult->setResult($result); |
@@ -183,19 +183,19 @@ discard block |
||
| 183 | 183 | * Return the result for non SELECT query |
| 184 | 184 | * @see DatabaseQueryRunner::execute |
| 185 | 185 | */ |
| 186 | - protected function setResultForNonSelect(){ |
|
| 186 | + protected function setResultForNonSelect() { |
|
| 187 | 187 | //Sqlite and pgsql always return 0 when using rowCount() |
| 188 | 188 | $result = false; |
| 189 | 189 | $numRows = 0; |
| 190 | - if (in_array($this->driver, array('sqlite', 'pgsql'))){ |
|
| 190 | + if (in_array($this->driver, array('sqlite', 'pgsql'))) { |
|
| 191 | 191 | $result = true; //to test the result for the query like UPDATE, INSERT, DELETE |
| 192 | 192 | $numRows = 1; //TODO use the correct method to get the exact affected row |
| 193 | - } else{ |
|
| 193 | + } else { |
|
| 194 | 194 | //to test the result for the query like UPDATE, INSERT, DELETE |
| 195 | 195 | $result = $this->pdoStatment->rowCount() >= 0; |
| 196 | 196 | $numRows = $this->pdoStatment->rowCount(); |
| 197 | 197 | } |
| 198 | - if(! is_object($this->queryResult)){ |
|
| 198 | + if (!is_object($this->queryResult)) { |
|
| 199 | 199 | $this->queryResult = & class_loader('DatabaseQueryResult', 'classes/database'); |
| 200 | 200 | } |
| 201 | 201 | $this->queryResult->setResult($result); |
@@ -226,7 +226,7 @@ discard block |
||
| 226 | 226 | * |
| 227 | 227 | * @return object DatabaseQueryResult |
| 228 | 228 | */ |
| 229 | - public function getQueryResult(){ |
|
| 229 | + public function getQueryResult() { |
|
| 230 | 230 | return $this->queryResult; |
| 231 | 231 | } |
| 232 | 232 | |
@@ -236,7 +236,7 @@ discard block |
||
| 236 | 236 | * |
| 237 | 237 | * @return object DatabaseQueryRunner |
| 238 | 238 | */ |
| 239 | - public function setQueryResult(DatabaseQueryResult $queryResult){ |
|
| 239 | + public function setQueryResult(DatabaseQueryResult $queryResult) { |
|
| 240 | 240 | $this->queryResult = $queryResult; |
| 241 | 241 | return $this; |
| 242 | 242 | } |
@@ -245,7 +245,7 @@ discard block |
||
| 245 | 245 | * Return the current query SQL string |
| 246 | 246 | * @return string |
| 247 | 247 | */ |
| 248 | - public function getQuery(){ |
|
| 248 | + public function getQuery() { |
|
| 249 | 249 | return $this->query; |
| 250 | 250 | } |
| 251 | 251 | |
@@ -254,7 +254,7 @@ discard block |
||
| 254 | 254 | * @param string $query the SQL query to set |
| 255 | 255 | * @return object DatabaseQueryRunner |
| 256 | 256 | */ |
| 257 | - public function setQuery($query){ |
|
| 257 | + public function setQuery($query) { |
|
| 258 | 258 | $this->query = $query; |
| 259 | 259 | return $this; |
| 260 | 260 | } |
@@ -264,7 +264,7 @@ discard block |
||
| 264 | 264 | * @param boolean $returnType |
| 265 | 265 | * @return object DatabaseQueryRunner |
| 266 | 266 | */ |
| 267 | - public function setReturnType($returnType){ |
|
| 267 | + public function setReturnType($returnType) { |
|
| 268 | 268 | $this->returnAsList = $returnType; |
| 269 | 269 | return $this; |
| 270 | 270 | } |
@@ -274,7 +274,7 @@ discard block |
||
| 274 | 274 | * @param boolean $status the status if true will return as array |
| 275 | 275 | * @return object DatabaseQueryRunner |
| 276 | 276 | */ |
| 277 | - public function setReturnAsArray($status = true){ |
|
| 277 | + public function setReturnAsArray($status = true) { |
|
| 278 | 278 | $this->returnAsArray = $status; |
| 279 | 279 | return $this; |
| 280 | 280 | } |
@@ -283,7 +283,7 @@ discard block |
||
| 283 | 283 | * Return the error for last query execution |
| 284 | 284 | * @return string |
| 285 | 285 | */ |
| 286 | - public function getQueryError(){ |
|
| 286 | + public function getQueryError() { |
|
| 287 | 287 | return $this->error; |
| 288 | 288 | } |
| 289 | 289 | |
@@ -291,7 +291,7 @@ discard block |
||
| 291 | 291 | * Return the PDO instance |
| 292 | 292 | * @return object |
| 293 | 293 | */ |
| 294 | - public function getPdo(){ |
|
| 294 | + public function getPdo() { |
|
| 295 | 295 | return $this->pdo; |
| 296 | 296 | } |
| 297 | 297 | |
@@ -300,7 +300,7 @@ discard block |
||
| 300 | 300 | * @param PDO $pdo the pdo object |
| 301 | 301 | * @return object DatabaseQueryRunner |
| 302 | 302 | */ |
| 303 | - public function setPdo(PDO $pdo = null){ |
|
| 303 | + public function setPdo(PDO $pdo = null) { |
|
| 304 | 304 | $this->pdo = $pdo; |
| 305 | 305 | return $this; |
| 306 | 306 | } |
@@ -309,7 +309,7 @@ discard block |
||
| 309 | 309 | * Return the database driver |
| 310 | 310 | * @return string |
| 311 | 311 | */ |
| 312 | - public function getDriver(){ |
|
| 312 | + public function getDriver() { |
|
| 313 | 313 | return $this->driver; |
| 314 | 314 | } |
| 315 | 315 | |
@@ -318,7 +318,7 @@ discard block |
||
| 318 | 318 | * @param string $driver the new driver |
| 319 | 319 | * @return object DatabaseQueryRunner |
| 320 | 320 | */ |
| 321 | - public function setDriver($driver){ |
|
| 321 | + public function setDriver($driver) { |
|
| 322 | 322 | $this->driver = $driver; |
| 323 | 323 | return $this; |
| 324 | 324 | } |
@@ -328,14 +328,14 @@ discard block |
||
| 328 | 328 | * |
| 329 | 329 | * @return string |
| 330 | 330 | */ |
| 331 | - protected function getBenchmarkKey(){ |
|
| 331 | + protected function getBenchmarkKey() { |
|
| 332 | 332 | return md5($this->query . $this->returnAsList . $this->returnAsArray); |
| 333 | 333 | } |
| 334 | 334 | |
| 335 | 335 | /** |
| 336 | 336 | * Set error for database query execution |
| 337 | 337 | */ |
| 338 | - protected function setQueryRunnerError(){ |
|
| 338 | + protected function setQueryRunnerError() { |
|
| 339 | 339 | $error = $this->pdo->errorInfo(); |
| 340 | 340 | $this->error = isset($error[2]) ? $error[2] : ''; |
| 341 | 341 | $this->logger->error('The database query execution got an error: ' . stringfy_vars($error)); |
@@ -347,11 +347,11 @@ discard block |
||
| 347 | 347 | * Set the Log instance using argument or create new instance |
| 348 | 348 | * @param object $logger the Log instance if not null |
| 349 | 349 | */ |
| 350 | - protected function setLoggerFromParamOrCreateNewInstance(Log $logger = null){ |
|
| 351 | - if ($logger !== null){ |
|
| 350 | + protected function setLoggerFromParamOrCreateNewInstance(Log $logger = null) { |
|
| 351 | + if ($logger !== null) { |
|
| 352 | 352 | $this->logger = $logger; |
| 353 | - } else{ |
|
| 354 | - $this->logger =& class_loader('Log', 'classes'); |
|
| 353 | + } else { |
|
| 354 | + $this->logger = & class_loader('Log', 'classes'); |
|
| 355 | 355 | $this->logger->setLogger('Library::DatabaseQueryRunner'); |
| 356 | 356 | } |
| 357 | 357 | } |
@@ -149,13 +149,13 @@ |
||
| 149 | 149 | $this->updateQueryBuilderAndRunnerProperties(); |
| 150 | 150 | |
| 151 | 151 | return is_object($this->pdo); |
| 152 | - } catch (PDOException $e){ |
|
| 152 | + } catch (PDOException $e){ |
|
| 153 | 153 | $this->logger->fatal($e->getMessage()); |
| 154 | 154 | show_error('Cannot connect to Database.'); |
| 155 | 155 | return false; |
| 156 | - } |
|
| 157 | - } |
|
| 158 | - return false; |
|
| 156 | + } |
|
| 157 | + } |
|
| 158 | + return false; |
|
| 159 | 159 | } |
| 160 | 160 | |
| 161 | 161 | |
@@ -603,17 +603,17 @@ |
||
| 603 | 603 | return null; |
| 604 | 604 | } |
| 605 | 605 | switch ($driver) { |
| 606 | - case 'mysql': |
|
| 607 | - case 'pgsql': |
|
| 608 | - $port = ''; |
|
| 609 | - if (! empty($config['port'])) { |
|
| 610 | - $port = 'port=' . $config['port'] . ';'; |
|
| 611 | - } |
|
| 612 | - $dsn = $driver . ':host=' . $config['hostname'] . ';' . $port . 'dbname=' . $config['database']; |
|
| 613 | - break; |
|
| 614 | - case 'sqlite': |
|
| 615 | - $dsn = 'sqlite:' . $config['database']; |
|
| 616 | - break; |
|
| 606 | + case 'mysql': |
|
| 607 | + case 'pgsql': |
|
| 608 | + $port = ''; |
|
| 609 | + if (! empty($config['port'])) { |
|
| 610 | + $port = 'port=' . $config['port'] . ';'; |
|
| 611 | + } |
|
| 612 | + $dsn = $driver . ':host=' . $config['hostname'] . ';' . $port . 'dbname=' . $config['database']; |
|
| 613 | + break; |
|
| 614 | + case 'sqlite': |
|
| 615 | + $dsn = 'sqlite:' . $config['database']; |
|
| 616 | + break; |
|
| 617 | 617 | case 'oracle': |
| 618 | 618 | $port = ''; |
| 619 | 619 | if (! empty($config['port'])) { |
@@ -23,92 +23,92 @@ discard block |
||
| 23 | 23 | * along with this program; if not, write to the Free Software |
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | 25 | */ |
| 26 | - class Database extends BaseClass{ |
|
| 26 | + class Database extends BaseClass { |
|
| 27 | 27 | |
| 28 | 28 | /** |
| 29 | 29 | * The PDO instance |
| 30 | 30 | * @var object |
| 31 | 31 | */ |
| 32 | - private $pdo = null; |
|
| 32 | + private $pdo = null; |
|
| 33 | 33 | |
| 34 | 34 | /** |
| 35 | 35 | * The database name used for the application |
| 36 | 36 | * @var string |
| 37 | 37 | */ |
| 38 | - private $databaseName = null; |
|
| 38 | + private $databaseName = null; |
|
| 39 | 39 | |
| 40 | 40 | /** |
| 41 | 41 | * The number of rows returned by the last query |
| 42 | 42 | * @var int |
| 43 | 43 | */ |
| 44 | - private $numRows = 0; |
|
| 44 | + private $numRows = 0; |
|
| 45 | 45 | |
| 46 | 46 | /** |
| 47 | 47 | * The last insert id for the primary key column that have auto increment or sequence |
| 48 | 48 | * @var mixed |
| 49 | 49 | */ |
| 50 | - private $insertId = null; |
|
| 50 | + private $insertId = null; |
|
| 51 | 51 | |
| 52 | 52 | /** |
| 53 | 53 | * The full SQL query statment after build for each command |
| 54 | 54 | * @var string |
| 55 | 55 | */ |
| 56 | - private $query = null; |
|
| 56 | + private $query = null; |
|
| 57 | 57 | |
| 58 | 58 | /** |
| 59 | 59 | * The result returned for the last query |
| 60 | 60 | * @var mixed |
| 61 | 61 | */ |
| 62 | - private $result = array(); |
|
| 62 | + private $result = array(); |
|
| 63 | 63 | |
| 64 | 64 | /** |
| 65 | 65 | * The cache default time to live in second. 0 means no need to use the cache feature |
| 66 | 66 | * @var int |
| 67 | 67 | */ |
| 68 | - private $cacheTtl = 0; |
|
| 68 | + private $cacheTtl = 0; |
|
| 69 | 69 | |
| 70 | 70 | /** |
| 71 | 71 | * The cache current time to live. 0 means no need to use the cache feature |
| 72 | 72 | * @var int |
| 73 | 73 | */ |
| 74 | - private $temporaryCacheTtl = 0; |
|
| 74 | + private $temporaryCacheTtl = 0; |
|
| 75 | 75 | |
| 76 | 76 | /** |
| 77 | 77 | * The number of executed query for the current request |
| 78 | 78 | * @var int |
| 79 | 79 | */ |
| 80 | - private $queryCount = 0; |
|
| 80 | + private $queryCount = 0; |
|
| 81 | 81 | |
| 82 | 82 | /** |
| 83 | 83 | * The default data to be used in the statments query INSERT, UPDATE |
| 84 | 84 | * @var array |
| 85 | 85 | */ |
| 86 | - private $data = array(); |
|
| 86 | + private $data = array(); |
|
| 87 | 87 | |
| 88 | 88 | /** |
| 89 | 89 | * The database configuration |
| 90 | 90 | * @var array |
| 91 | 91 | */ |
| 92 | - private $config = array(); |
|
| 92 | + private $config = array(); |
|
| 93 | 93 | |
| 94 | 94 | /** |
| 95 | 95 | * The cache instance |
| 96 | 96 | * @var object |
| 97 | 97 | */ |
| 98 | - private $cacheInstance = null; |
|
| 98 | + private $cacheInstance = null; |
|
| 99 | 99 | |
| 100 | 100 | |
| 101 | 101 | /** |
| 102 | 102 | * The DatabaseQueryBuilder instance |
| 103 | 103 | * @var object |
| 104 | 104 | */ |
| 105 | - protected $queryBuilder = null; |
|
| 105 | + protected $queryBuilder = null; |
|
| 106 | 106 | |
| 107 | 107 | /** |
| 108 | 108 | * The DatabaseQueryRunner instance |
| 109 | 109 | * @var object |
| 110 | 110 | */ |
| 111 | - protected $queryRunner = null; |
|
| 111 | + protected $queryRunner = null; |
|
| 112 | 112 | |
| 113 | 113 | |
| 114 | 114 | /** |
@@ -136,10 +136,10 @@ discard block |
||
| 136 | 136 | * This is used to connect to database |
| 137 | 137 | * @return bool |
| 138 | 138 | */ |
| 139 | - public function connect(){ |
|
| 139 | + public function connect() { |
|
| 140 | 140 | $config = $this->getDatabaseConfiguration(); |
| 141 | - if (! empty($config)){ |
|
| 142 | - try{ |
|
| 141 | + if (!empty($config)) { |
|
| 142 | + try { |
|
| 143 | 143 | $this->pdo = new PDO($this->getDsnValueFromConfig(), $config['username'], $config['password']); |
| 144 | 144 | $this->pdo->exec("SET NAMES '" . $config['charset'] . "' COLLATE '" . $config['collation'] . "'"); |
| 145 | 145 | $this->pdo->exec("SET CHARACTER SET '" . $config['charset'] . "'"); |
@@ -149,7 +149,7 @@ discard block |
||
| 149 | 149 | $this->updateQueryBuilderAndRunnerProperties(); |
| 150 | 150 | |
| 151 | 151 | return is_object($this->pdo); |
| 152 | - } catch (PDOException $e){ |
|
| 152 | + } catch (PDOException $e) { |
|
| 153 | 153 | $this->logger->fatal($e->getMessage()); |
| 154 | 154 | show_error('Cannot connect to Database.'); |
| 155 | 155 | return false; |
@@ -163,7 +163,7 @@ discard block |
||
| 163 | 163 | * Return the number of rows returned by the current query |
| 164 | 164 | * @return int |
| 165 | 165 | */ |
| 166 | - public function numRows(){ |
|
| 166 | + public function numRows() { |
|
| 167 | 167 | return $this->numRows; |
| 168 | 168 | } |
| 169 | 169 | |
@@ -171,7 +171,7 @@ discard block |
||
| 171 | 171 | * Return the last insert id value |
| 172 | 172 | * @return mixed |
| 173 | 173 | */ |
| 174 | - public function insertId(){ |
|
| 174 | + public function insertId() { |
|
| 175 | 175 | return $this->insertId; |
| 176 | 176 | } |
| 177 | 177 | |
@@ -182,10 +182,10 @@ discard block |
||
| 182 | 182 | * If is string will determine the result type "array" or "object" |
| 183 | 183 | * @return mixed the query SQL string or the record result |
| 184 | 184 | */ |
| 185 | - public function get($returnSQLQueryOrResultType = false){ |
|
| 185 | + public function get($returnSQLQueryOrResultType = false) { |
|
| 186 | 186 | $this->queryBuilder->limit(1); |
| 187 | 187 | $query = $this->getAll(true); |
| 188 | - if ($returnSQLQueryOrResultType === true){ |
|
| 188 | + if ($returnSQLQueryOrResultType === true) { |
|
| 189 | 189 | return $query; |
| 190 | 190 | } else { |
| 191 | 191 | return $this->query($query, false, $returnSQLQueryOrResultType == 'array'); |
@@ -198,9 +198,9 @@ discard block |
||
| 198 | 198 | * If is string will determine the result type "array" or "object" |
| 199 | 199 | * @return mixed the query SQL string or the record result |
| 200 | 200 | */ |
| 201 | - public function getAll($returnSQLQueryOrResultType = false){ |
|
| 201 | + public function getAll($returnSQLQueryOrResultType = false) { |
|
| 202 | 202 | $query = $this->queryBuilder->getQuery(); |
| 203 | - if ($returnSQLQueryOrResultType === true){ |
|
| 203 | + if ($returnSQLQueryOrResultType === true) { |
|
| 204 | 204 | return $query; |
| 205 | 205 | } |
| 206 | 206 | return $this->query($query, true, $returnSQLQueryOrResultType == 'array'); |
@@ -212,18 +212,18 @@ discard block |
||
| 212 | 212 | * @param boolean $escape whether to escape or not the values |
| 213 | 213 | * @return mixed the insert id of the new record or null |
| 214 | 214 | */ |
| 215 | - public function insert($data = array(), $escape = true){ |
|
| 216 | - if (empty($data) && ! empty($this->data)){ |
|
| 215 | + public function insert($data = array(), $escape = true) { |
|
| 216 | + if (empty($data) && !empty($this->data)) { |
|
| 217 | 217 | //as when using $this->setData() may be the data already escaped |
| 218 | 218 | $escape = false; |
| 219 | 219 | $data = $this->data; |
| 220 | 220 | } |
| 221 | 221 | $query = $this->queryBuilder->insert($data, $escape)->getQuery(); |
| 222 | 222 | $result = $this->query($query); |
| 223 | - if ($result){ |
|
| 223 | + if ($result) { |
|
| 224 | 224 | $this->insertId = $this->pdo->lastInsertId(); |
| 225 | 225 | //if the table doesn't have the auto increment field or sequence, the value of 0 will be returned |
| 226 | - return ! ($this->insertId) ? true : $this->insertId; |
|
| 226 | + return !($this->insertId) ? true : $this->insertId; |
|
| 227 | 227 | } |
| 228 | 228 | return false; |
| 229 | 229 | } |
@@ -234,8 +234,8 @@ discard block |
||
| 234 | 234 | * @param boolean $escape whether to escape or not the values |
| 235 | 235 | * @return mixed the update status |
| 236 | 236 | */ |
| 237 | - public function update($data = array(), $escape = true){ |
|
| 238 | - if (empty($data) && ! empty($this->data)){ |
|
| 237 | + public function update($data = array(), $escape = true) { |
|
| 238 | + if (empty($data) && !empty($this->data)) { |
|
| 239 | 239 | //as when using $this->setData() may be the data already escaped |
| 240 | 240 | $escape = false; |
| 241 | 241 | $data = $this->data; |
@@ -248,7 +248,7 @@ discard block |
||
| 248 | 248 | * Delete the record in database |
| 249 | 249 | * @return mixed the delete status |
| 250 | 250 | */ |
| 251 | - public function delete(){ |
|
| 251 | + public function delete() { |
|
| 252 | 252 | $query = $this->queryBuilder->delete()->getQuery(); |
| 253 | 253 | return $this->query($query); |
| 254 | 254 | } |
@@ -258,7 +258,7 @@ discard block |
||
| 258 | 258 | * @param integer $ttl the cache time to live in second |
| 259 | 259 | * @return object the current Database instance |
| 260 | 260 | */ |
| 261 | - public function setCache($ttl = 0){ |
|
| 261 | + public function setCache($ttl = 0) { |
|
| 262 | 262 | $this->cacheTtl = $ttl; |
| 263 | 263 | $this->temporaryCacheTtl = $ttl; |
| 264 | 264 | return $this; |
@@ -269,7 +269,7 @@ discard block |
||
| 269 | 269 | * @param integer $ttl the cache time to live in second |
| 270 | 270 | * @return object the current Database instance |
| 271 | 271 | */ |
| 272 | - public function cached($ttl = 0){ |
|
| 272 | + public function cached($ttl = 0) { |
|
| 273 | 273 | $this->temporaryCacheTtl = $ttl; |
| 274 | 274 | return $this; |
| 275 | 275 | } |
@@ -281,9 +281,9 @@ discard block |
||
| 281 | 281 | * @return mixed the data after escaped or the same data if no |
| 282 | 282 | * need escaped |
| 283 | 283 | */ |
| 284 | - public function escape($data, $escaped = true){ |
|
| 284 | + public function escape($data, $escaped = true) { |
|
| 285 | 285 | $data = trim($data); |
| 286 | - if($escaped){ |
|
| 286 | + if ($escaped) { |
|
| 287 | 287 | return $this->pdo->quote($data); |
| 288 | 288 | } |
| 289 | 289 | return $data; |
@@ -293,7 +293,7 @@ discard block |
||
| 293 | 293 | * Return the number query executed count for the current request |
| 294 | 294 | * @return int |
| 295 | 295 | */ |
| 296 | - public function queryCount(){ |
|
| 296 | + public function queryCount() { |
|
| 297 | 297 | return $this->queryCount; |
| 298 | 298 | } |
| 299 | 299 | |
@@ -301,7 +301,7 @@ discard block |
||
| 301 | 301 | * Return the current query SQL string |
| 302 | 302 | * @return string |
| 303 | 303 | */ |
| 304 | - public function getQuery(){ |
|
| 304 | + public function getQuery() { |
|
| 305 | 305 | return $this->query; |
| 306 | 306 | } |
| 307 | 307 | |
@@ -309,7 +309,7 @@ discard block |
||
| 309 | 309 | * Return the application database name |
| 310 | 310 | * @return string |
| 311 | 311 | */ |
| 312 | - public function getDatabaseName(){ |
|
| 312 | + public function getDatabaseName() { |
|
| 313 | 313 | return $this->databaseName; |
| 314 | 314 | } |
| 315 | 315 | |
@@ -317,7 +317,7 @@ discard block |
||
| 317 | 317 | * Return the PDO instance |
| 318 | 318 | * @return object |
| 319 | 319 | */ |
| 320 | - public function getPdo(){ |
|
| 320 | + public function getPdo() { |
|
| 321 | 321 | return $this->pdo; |
| 322 | 322 | } |
| 323 | 323 | |
@@ -326,7 +326,7 @@ discard block |
||
| 326 | 326 | * @param object $pdo the pdo object |
| 327 | 327 | * @return object Database |
| 328 | 328 | */ |
| 329 | - public function setPdo(PDO $pdo){ |
|
| 329 | + public function setPdo(PDO $pdo) { |
|
| 330 | 330 | $this->pdo = $pdo; |
| 331 | 331 | return $this; |
| 332 | 332 | } |
@@ -335,7 +335,7 @@ discard block |
||
| 335 | 335 | * Return the cache instance |
| 336 | 336 | * @return CacheInterface |
| 337 | 337 | */ |
| 338 | - public function getCacheInstance(){ |
|
| 338 | + public function getCacheInstance() { |
|
| 339 | 339 | return $this->cacheInstance; |
| 340 | 340 | } |
| 341 | 341 | |
@@ -344,7 +344,7 @@ discard block |
||
| 344 | 344 | * @param CacheInterface $cache the cache object |
| 345 | 345 | * @return object Database |
| 346 | 346 | */ |
| 347 | - public function setCacheInstance($cache){ |
|
| 347 | + public function setCacheInstance($cache) { |
|
| 348 | 348 | $this->cacheInstance = $cache; |
| 349 | 349 | return $this; |
| 350 | 350 | } |
@@ -354,7 +354,7 @@ discard block |
||
| 354 | 354 | * Return the DatabaseQueryBuilder instance |
| 355 | 355 | * @return object DatabaseQueryBuilder |
| 356 | 356 | */ |
| 357 | - public function getQueryBuilder(){ |
|
| 357 | + public function getQueryBuilder() { |
|
| 358 | 358 | return $this->queryBuilder; |
| 359 | 359 | } |
| 360 | 360 | |
@@ -362,7 +362,7 @@ discard block |
||
| 362 | 362 | * Set the DatabaseQueryBuilder instance |
| 363 | 363 | * @param object DatabaseQueryBuilder $queryBuilder the DatabaseQueryBuilder object |
| 364 | 364 | */ |
| 365 | - public function setQueryBuilder(DatabaseQueryBuilder $queryBuilder){ |
|
| 365 | + public function setQueryBuilder(DatabaseQueryBuilder $queryBuilder) { |
|
| 366 | 366 | $this->queryBuilder = $queryBuilder; |
| 367 | 367 | return $this; |
| 368 | 368 | } |
@@ -371,7 +371,7 @@ discard block |
||
| 371 | 371 | * Return the DatabaseQueryRunner instance |
| 372 | 372 | * @return object DatabaseQueryRunner |
| 373 | 373 | */ |
| 374 | - public function getQueryRunner(){ |
|
| 374 | + public function getQueryRunner() { |
|
| 375 | 375 | return $this->queryRunner; |
| 376 | 376 | } |
| 377 | 377 | |
@@ -379,7 +379,7 @@ discard block |
||
| 379 | 379 | * Set the DatabaseQueryRunner instance |
| 380 | 380 | * @param object DatabaseQueryRunner $queryRunner the DatabaseQueryRunner object |
| 381 | 381 | */ |
| 382 | - public function setQueryRunner(DatabaseQueryRunner $queryRunner){ |
|
| 382 | + public function setQueryRunner(DatabaseQueryRunner $queryRunner) { |
|
| 383 | 383 | $this->queryRunner = $queryRunner; |
| 384 | 384 | return $this; |
| 385 | 385 | } |
@@ -388,7 +388,7 @@ discard block |
||
| 388 | 388 | * Return the data to be used for insert, update, etc. |
| 389 | 389 | * @return array |
| 390 | 390 | */ |
| 391 | - public function getData(){ |
|
| 391 | + public function getData() { |
|
| 392 | 392 | return $this->data; |
| 393 | 393 | } |
| 394 | 394 | |
@@ -399,9 +399,9 @@ discard block |
||
| 399 | 399 | * @param boolean $escape whether to escape or not the $value |
| 400 | 400 | * @return object the current Database instance |
| 401 | 401 | */ |
| 402 | - public function setData($key, $value = null, $escape = true){ |
|
| 403 | - if (is_array($key)){ |
|
| 404 | - foreach($key as $k => $v){ |
|
| 402 | + public function setData($key, $value = null, $escape = true) { |
|
| 403 | + if (is_array($key)) { |
|
| 404 | + foreach ($key as $k => $v) { |
|
| 405 | 405 | $this->setData($k, $v, $escape); |
| 406 | 406 | } |
| 407 | 407 | } else { |
@@ -417,7 +417,7 @@ discard block |
||
| 417 | 417 | * @param boolean $returnAsArray return the result as array or not |
| 418 | 418 | * @return mixed the query result |
| 419 | 419 | */ |
| 420 | - public function query($query, $returnAsList = true, $returnAsArray = false){ |
|
| 420 | + public function query($query, $returnAsList = true, $returnAsArray = false) { |
|
| 421 | 421 | $this->reset(); |
| 422 | 422 | $this->query = preg_replace('/\s\s+|\t\t+/', ' ', trim($query)); |
| 423 | 423 | //If is the SELECT query |
@@ -438,12 +438,12 @@ discard block |
||
| 438 | 438 | //if can use cache feature for this query |
| 439 | 439 | $dbCacheStatus = $cacheEnable && $cacheExpire > 0; |
| 440 | 440 | |
| 441 | - if ($dbCacheStatus && $isSqlSELECTQuery){ |
|
| 441 | + if ($dbCacheStatus && $isSqlSELECTQuery) { |
|
| 442 | 442 | $this->logger->info('The cache is enabled for this query, try to get result from cache'); |
| 443 | 443 | $cacheContent = $this->getCacheContentForQuery($query, $returnAsList, $returnAsArray); |
| 444 | 444 | } |
| 445 | 445 | |
| 446 | - if (!$cacheContent){ |
|
| 446 | + if (!$cacheContent) { |
|
| 447 | 447 | //count the number of query execution to server |
| 448 | 448 | $this->queryCount++; |
| 449 | 449 | |
@@ -452,19 +452,19 @@ discard block |
||
| 452 | 452 | ->setReturnAsArray($returnAsArray) |
| 453 | 453 | ->execute(); |
| 454 | 454 | |
| 455 | - if (!is_object($queryResult)){ |
|
| 455 | + if (!is_object($queryResult)) { |
|
| 456 | 456 | $this->result = false; |
| 457 | 457 | $this->numRows = 0; |
| 458 | 458 | return $this->result; |
| 459 | 459 | } |
| 460 | 460 | $this->result = $queryResult->getResult(); |
| 461 | 461 | $this->numRows = $queryResult->getNumRows(); |
| 462 | - if ($isSqlSELECTQuery && $dbCacheStatus){ |
|
| 462 | + if ($isSqlSELECTQuery && $dbCacheStatus) { |
|
| 463 | 463 | $key = $this->getCacheKeyForQuery($this->query, $returnAsList, $returnAsArray); |
| 464 | 464 | $this->setCacheContentForQuery($this->query, $key, $this->result, $cacheExpire); |
| 465 | 465 | } |
| 466 | - } else if ($isSqlSELECTQuery){ |
|
| 467 | - $this->logger->info('The result for query [' .$this->query. '] already cached use it'); |
|
| 466 | + } else if ($isSqlSELECTQuery) { |
|
| 467 | + $this->logger->info('The result for query [' . $this->query . '] already cached use it'); |
|
| 468 | 468 | $this->result = $cacheContent; |
| 469 | 469 | $this->numRows = count($this->result); |
| 470 | 470 | } |
@@ -478,9 +478,9 @@ discard block |
||
| 478 | 478 | * @param boolean $autoConnect whether to connect to database after set the configuration |
| 479 | 479 | * @return object Database |
| 480 | 480 | */ |
| 481 | - public function setDatabaseConfiguration(array $overwriteConfig = array(), $useConfigFile = true, $autoConnect = false){ |
|
| 481 | + public function setDatabaseConfiguration(array $overwriteConfig = array(), $useConfigFile = true, $autoConnect = false) { |
|
| 482 | 482 | $db = array(); |
| 483 | - if ($useConfigFile && file_exists(CONFIG_PATH . 'database.php')){ |
|
| 483 | + if ($useConfigFile && file_exists(CONFIG_PATH . 'database.php')) { |
|
| 484 | 484 | //here don't use require_once because somewhere user can create database instance directly |
| 485 | 485 | require CONFIG_PATH . 'database.php'; |
| 486 | 486 | } |
@@ -495,7 +495,7 @@ discard block |
||
| 495 | 495 | //determine the port using the hostname like localhost:3307 |
| 496 | 496 | //hostname will be "localhost", and port "3307" |
| 497 | 497 | $p = explode(':', $config['hostname']); |
| 498 | - if (count($p) >= 2){ |
|
| 498 | + if (count($p) >= 2) { |
|
| 499 | 499 | $config['hostname'] = $p[0]; |
| 500 | 500 | $config['port'] = $p[1]; |
| 501 | 501 | } |
@@ -509,7 +509,7 @@ discard block |
||
| 509 | 509 | array('password' => string_hidden($this->config['password'])) |
| 510 | 510 | )) |
| 511 | 511 | ); |
| 512 | - if($autoConnect){ |
|
| 512 | + if ($autoConnect) { |
|
| 513 | 513 | //Now connect to the database |
| 514 | 514 | $this->connect(); |
| 515 | 515 | } |
@@ -520,14 +520,14 @@ discard block |
||
| 520 | 520 | * Return the database configuration |
| 521 | 521 | * @return array |
| 522 | 522 | */ |
| 523 | - public function getDatabaseConfiguration(){ |
|
| 523 | + public function getDatabaseConfiguration() { |
|
| 524 | 524 | return $this->config; |
| 525 | 525 | } |
| 526 | 526 | |
| 527 | 527 | /** |
| 528 | 528 | * Close the connexion |
| 529 | 529 | */ |
| 530 | - public function close(){ |
|
| 530 | + public function close() { |
|
| 531 | 531 | $this->pdo = null; |
| 532 | 532 | } |
| 533 | 533 | |
@@ -535,7 +535,7 @@ discard block |
||
| 535 | 535 | * Return the database default configuration |
| 536 | 536 | * @return array |
| 537 | 537 | */ |
| 538 | - protected function getDatabaseDefaultConfiguration(){ |
|
| 538 | + protected function getDatabaseDefaultConfiguration() { |
|
| 539 | 539 | return array( |
| 540 | 540 | 'driver' => '', |
| 541 | 541 | 'username' => '', |
@@ -553,16 +553,16 @@ discard block |
||
| 553 | 553 | * Update the DatabaseQueryBuilder and DatabaseQueryRunner properties |
| 554 | 554 | * @return void |
| 555 | 555 | */ |
| 556 | - protected function updateQueryBuilderAndRunnerProperties(){ |
|
| 556 | + protected function updateQueryBuilderAndRunnerProperties() { |
|
| 557 | 557 | //update queryBuilder with some properties needed |
| 558 | - if (is_object($this->queryBuilder)){ |
|
| 558 | + if (is_object($this->queryBuilder)) { |
|
| 559 | 559 | $this->queryBuilder->setDriver($this->config['driver']) |
| 560 | 560 | ->setPrefix($this->config['prefix']) |
| 561 | 561 | ->setPdo($this->pdo); |
| 562 | 562 | } |
| 563 | 563 | |
| 564 | 564 | //update queryRunner with some properties needed |
| 565 | - if (is_object($this->queryRunner)){ |
|
| 565 | + if (is_object($this->queryRunner)) { |
|
| 566 | 566 | $this->queryRunner->setDriver($this->config['driver']) |
| 567 | 567 | ->setPdo($this->pdo); |
| 568 | 568 | } |
@@ -573,10 +573,10 @@ discard block |
||
| 573 | 573 | * This method is used to get the PDO DSN string using the configured driver |
| 574 | 574 | * @return string|null the DSN string or null if can not find it |
| 575 | 575 | */ |
| 576 | - protected function getDsnValueFromConfig(){ |
|
| 576 | + protected function getDsnValueFromConfig() { |
|
| 577 | 577 | $dsn = null; |
| 578 | 578 | $config = $this->getDatabaseConfiguration(); |
| 579 | - if (! empty($config)){ |
|
| 579 | + if (!empty($config)) { |
|
| 580 | 580 | $driver = $config['driver']; |
| 581 | 581 | $driverDsnMap = array( |
| 582 | 582 | 'mysql' => $this->getDsnValueForDriver('mysql'), |
@@ -584,7 +584,7 @@ discard block |
||
| 584 | 584 | 'sqlite' => $this->getDsnValueForDriver('sqlite'), |
| 585 | 585 | 'oracle' => $this->getDsnValueForDriver('oracle') |
| 586 | 586 | ); |
| 587 | - if (isset($driverDsnMap[$driver])){ |
|
| 587 | + if (isset($driverDsnMap[$driver])) { |
|
| 588 | 588 | $dsn = $driverDsnMap[$driver]; |
| 589 | 589 | } |
| 590 | 590 | } |
@@ -596,17 +596,17 @@ discard block |
||
| 596 | 596 | * @param string $driver the driver name |
| 597 | 597 | * @return string|null the dsn name |
| 598 | 598 | */ |
| 599 | - protected function getDsnValueForDriver($driver){ |
|
| 599 | + protected function getDsnValueForDriver($driver) { |
|
| 600 | 600 | $dsn = ''; |
| 601 | 601 | $config = $this->getDatabaseConfiguration(); |
| 602 | - if (empty($config)){ |
|
| 602 | + if (empty($config)) { |
|
| 603 | 603 | return null; |
| 604 | 604 | } |
| 605 | 605 | switch ($driver) { |
| 606 | 606 | case 'mysql': |
| 607 | 607 | case 'pgsql': |
| 608 | 608 | $port = ''; |
| 609 | - if (! empty($config['port'])) { |
|
| 609 | + if (!empty($config['port'])) { |
|
| 610 | 610 | $port = 'port=' . $config['port'] . ';'; |
| 611 | 611 | } |
| 612 | 612 | $dsn = $driver . ':host=' . $config['hostname'] . ';' . $port . 'dbname=' . $config['database']; |
@@ -616,10 +616,10 @@ discard block |
||
| 616 | 616 | break; |
| 617 | 617 | case 'oracle': |
| 618 | 618 | $port = ''; |
| 619 | - if (! empty($config['port'])) { |
|
| 619 | + if (!empty($config['port'])) { |
|
| 620 | 620 | $port = ':' . $config['port']; |
| 621 | 621 | } |
| 622 | - $dsn = 'oci:dbname=' . $config['hostname'] . $port . '/' . $config['database']; |
|
| 622 | + $dsn = 'oci:dbname=' . $config['hostname'] . $port . '/' . $config['database']; |
|
| 623 | 623 | break; |
| 624 | 624 | } |
| 625 | 625 | return $dsn; |
@@ -631,9 +631,9 @@ discard block |
||
| 631 | 631 | * |
| 632 | 632 | * @return mixed |
| 633 | 633 | */ |
| 634 | - protected function getCacheContentForQuery($query, $returnAsList, $returnAsArray){ |
|
| 634 | + protected function getCacheContentForQuery($query, $returnAsList, $returnAsArray) { |
|
| 635 | 635 | $cacheKey = $this->getCacheKeyForQuery($query, $returnAsList, $returnAsArray); |
| 636 | - if (! is_object($this->cacheInstance)){ |
|
| 636 | + if (!is_object($this->cacheInstance)) { |
|
| 637 | 637 | //can not call method with reference in argument |
| 638 | 638 | //like $this->setCacheInstance(& get_instance()->cache); |
| 639 | 639 | //use temporary variable |
@@ -650,9 +650,9 @@ discard block |
||
| 650 | 650 | * @param mixed $result the query result to save |
| 651 | 651 | * @param int $expire the cache TTL |
| 652 | 652 | */ |
| 653 | - protected function setCacheContentForQuery($query, $key, $result, $expire){ |
|
| 654 | - $this->logger->info('Save the result for query [' .$query. '] into cache for future use'); |
|
| 655 | - if (! is_object($this->cacheInstance)){ |
|
| 653 | + protected function setCacheContentForQuery($query, $key, $result, $expire) { |
|
| 654 | + $this->logger->info('Save the result for query [' . $query . '] into cache for future use'); |
|
| 655 | + if (!is_object($this->cacheInstance)) { |
|
| 656 | 656 | //can not call method with reference in argument |
| 657 | 657 | //like $this->setCacheInstance(& get_instance()->cache); |
| 658 | 658 | //use temporary variable |
@@ -669,7 +669,7 @@ discard block |
||
| 669 | 669 | * |
| 670 | 670 | * @return string |
| 671 | 671 | */ |
| 672 | - protected function getCacheKeyForQuery($query, $returnAsList, $returnAsArray){ |
|
| 672 | + protected function getCacheKeyForQuery($query, $returnAsList, $returnAsArray) { |
|
| 673 | 673 | return md5($query . $returnAsList . $returnAsArray); |
| 674 | 674 | } |
| 675 | 675 | |
@@ -677,7 +677,7 @@ discard block |
||
| 677 | 677 | /** |
| 678 | 678 | * Reset the database class attributs to the initail values before each query. |
| 679 | 679 | */ |
| 680 | - private function reset(){ |
|
| 680 | + private function reset() { |
|
| 681 | 681 | //query builder reset |
| 682 | 682 | $this->queryBuilder->reset(); |
| 683 | 683 | $this->numRows = 0; |
@@ -690,7 +690,7 @@ discard block |
||
| 690 | 690 | /** |
| 691 | 691 | * The class destructor |
| 692 | 692 | */ |
| 693 | - public function __destruct(){ |
|
| 693 | + public function __destruct() { |
|
| 694 | 694 | $this->pdo = null; |
| 695 | 695 | } |
| 696 | 696 | |
@@ -1,147 +1,147 @@ |
||
| 1 | 1 | <?php |
| 2 | - defined('ROOT_PATH') or exit('Access denied'); |
|
| 3 | - /** |
|
| 4 | - * TNH Framework |
|
| 5 | - * |
|
| 6 | - * A simple PHP framework using HMVC architecture |
|
| 7 | - * |
|
| 8 | - * This content is released under the GNU GPL License (GPL) |
|
| 9 | - * |
|
| 10 | - * Copyright (C) 2017 Tony NGUEREZA |
|
| 11 | - * |
|
| 12 | - * This program is free software; you can redistribute it and/or |
|
| 13 | - * modify it under the terms of the GNU General Public License |
|
| 14 | - * as published by the Free Software Foundation; either version 3 |
|
| 15 | - * of the License, or (at your option) any later version. |
|
| 16 | - * |
|
| 17 | - * This program is distributed in the hope that it will be useful, |
|
| 18 | - * but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 19 | - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 20 | - * GNU General Public License for more details. |
|
| 21 | - * |
|
| 22 | - * You should have received a copy of the GNU General Public License |
|
| 23 | - * along with this program; if not, write to the Free Software |
|
| 24 | - * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
|
| 25 | - */ |
|
| 26 | - class Session extends BaseStaticClass { |
|
| 2 | + defined('ROOT_PATH') or exit('Access denied'); |
|
| 3 | + /** |
|
| 4 | + * TNH Framework |
|
| 5 | + * |
|
| 6 | + * A simple PHP framework using HMVC architecture |
|
| 7 | + * |
|
| 8 | + * This content is released under the GNU GPL License (GPL) |
|
| 9 | + * |
|
| 10 | + * Copyright (C) 2017 Tony NGUEREZA |
|
| 11 | + * |
|
| 12 | + * This program is free software; you can redistribute it and/or |
|
| 13 | + * modify it under the terms of the GNU General Public License |
|
| 14 | + * as published by the Free Software Foundation; either version 3 |
|
| 15 | + * of the License, or (at your option) any later version. |
|
| 16 | + * |
|
| 17 | + * This program is distributed in the hope that it will be useful, |
|
| 18 | + * but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
| 19 | + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
| 20 | + * GNU General Public License for more details. |
|
| 21 | + * |
|
| 22 | + * You should have received a copy of the GNU General Public License |
|
| 23 | + * along with this program; if not, write to the Free Software |
|
| 24 | + * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
|
| 25 | + */ |
|
| 26 | + class Session extends BaseStaticClass { |
|
| 27 | 27 | |
| 28 | - /** |
|
| 29 | - * The session flash key to use |
|
| 30 | - * @const |
|
| 31 | - */ |
|
| 32 | - const SESSION_FLASH_KEY = 'session_flash'; |
|
| 28 | + /** |
|
| 29 | + * The session flash key to use |
|
| 30 | + * @const |
|
| 31 | + */ |
|
| 32 | + const SESSION_FLASH_KEY = 'session_flash'; |
|
| 33 | 33 | |
| 34 | - /** |
|
| 35 | - * Get the session item value |
|
| 36 | - * @param string $item the session item name to get |
|
| 37 | - * @param mixed $default the default value to use if can not find the session item in the list |
|
| 38 | - * @return mixed the session value if exist or the default value |
|
| 39 | - */ |
|
| 40 | - public static function get($item, $default = null) { |
|
| 41 | - $logger = self::getLogger(); |
|
| 42 | - $logger->debug('Getting session data for item [' . $item . '] ...'); |
|
| 43 | - if (array_key_exists($item, $_SESSION)) { |
|
| 44 | - $logger->info('Found session data for item [' . $item . '] the vaue is : [' . stringfy_vars($_SESSION[$item]) . ']'); |
|
| 45 | - return $_SESSION[$item]; |
|
| 46 | - } |
|
| 47 | - $logger->warning('Cannot find session item [' . $item . '] using the default value [' . $default . ']'); |
|
| 48 | - return $default; |
|
| 49 | - } |
|
| 34 | + /** |
|
| 35 | + * Get the session item value |
|
| 36 | + * @param string $item the session item name to get |
|
| 37 | + * @param mixed $default the default value to use if can not find the session item in the list |
|
| 38 | + * @return mixed the session value if exist or the default value |
|
| 39 | + */ |
|
| 40 | + public static function get($item, $default = null) { |
|
| 41 | + $logger = self::getLogger(); |
|
| 42 | + $logger->debug('Getting session data for item [' . $item . '] ...'); |
|
| 43 | + if (array_key_exists($item, $_SESSION)) { |
|
| 44 | + $logger->info('Found session data for item [' . $item . '] the vaue is : [' . stringfy_vars($_SESSION[$item]) . ']'); |
|
| 45 | + return $_SESSION[$item]; |
|
| 46 | + } |
|
| 47 | + $logger->warning('Cannot find session item [' . $item . '] using the default value [' . $default . ']'); |
|
| 48 | + return $default; |
|
| 49 | + } |
|
| 50 | 50 | |
| 51 | - /** |
|
| 52 | - * Set the session item value |
|
| 53 | - * @param string $item the session item name to set |
|
| 54 | - * @param mixed $value the session item value |
|
| 55 | - */ |
|
| 56 | - public static function set($item, $value) { |
|
| 57 | - $logger = self::getLogger(); |
|
| 58 | - $logger->debug('Setting session data for item [' . $item . '], value [' . stringfy_vars($value) . ']'); |
|
| 59 | - $_SESSION[$item] = $value; |
|
| 60 | - } |
|
| 51 | + /** |
|
| 52 | + * Set the session item value |
|
| 53 | + * @param string $item the session item name to set |
|
| 54 | + * @param mixed $value the session item value |
|
| 55 | + */ |
|
| 56 | + public static function set($item, $value) { |
|
| 57 | + $logger = self::getLogger(); |
|
| 58 | + $logger->debug('Setting session data for item [' . $item . '], value [' . stringfy_vars($value) . ']'); |
|
| 59 | + $_SESSION[$item] = $value; |
|
| 60 | + } |
|
| 61 | 61 | |
| 62 | - /** |
|
| 63 | - * Get the session flash item value |
|
| 64 | - * @param string $item the session flash item name to get |
|
| 65 | - * @param mixed $default the default value to use if can not find the session flash item in the list |
|
| 66 | - * @return mixed the session flash value if exist or the default value |
|
| 67 | - */ |
|
| 68 | - public static function getFlash($item, $default = null){ |
|
| 69 | - $logger = self::getLogger(); |
|
| 70 | - $key = self::SESSION_FLASH_KEY.'_'.$item; |
|
| 71 | - $return = array_key_exists($key, $_SESSION) ? |
|
| 72 | - ($_SESSION[$key]) : $default; |
|
| 73 | - if(array_key_exists($key, $_SESSION)){ |
|
| 74 | - unset($_SESSION[$key]); |
|
| 75 | - } else{ |
|
| 76 | - $logger->warning('Cannot find session flash item ['. $key .'] using the default value ['. $default .']'); |
|
| 77 | - } |
|
| 78 | - return $return; |
|
| 79 | - } |
|
| 62 | + /** |
|
| 63 | + * Get the session flash item value |
|
| 64 | + * @param string $item the session flash item name to get |
|
| 65 | + * @param mixed $default the default value to use if can not find the session flash item in the list |
|
| 66 | + * @return mixed the session flash value if exist or the default value |
|
| 67 | + */ |
|
| 68 | + public static function getFlash($item, $default = null){ |
|
| 69 | + $logger = self::getLogger(); |
|
| 70 | + $key = self::SESSION_FLASH_KEY.'_'.$item; |
|
| 71 | + $return = array_key_exists($key, $_SESSION) ? |
|
| 72 | + ($_SESSION[$key]) : $default; |
|
| 73 | + if(array_key_exists($key, $_SESSION)){ |
|
| 74 | + unset($_SESSION[$key]); |
|
| 75 | + } else{ |
|
| 76 | + $logger->warning('Cannot find session flash item ['. $key .'] using the default value ['. $default .']'); |
|
| 77 | + } |
|
| 78 | + return $return; |
|
| 79 | + } |
|
| 80 | 80 | |
| 81 | - /** |
|
| 82 | - * Check whether the given session flash item exists |
|
| 83 | - * @param string $item the session flash item name |
|
| 84 | - * @return boolean |
|
| 85 | - */ |
|
| 86 | - public static function hasFlash($item) { |
|
| 87 | - $key = self::SESSION_FLASH_KEY . '_' . $item; |
|
| 88 | - return array_key_exists($key, $_SESSION); |
|
| 89 | - } |
|
| 81 | + /** |
|
| 82 | + * Check whether the given session flash item exists |
|
| 83 | + * @param string $item the session flash item name |
|
| 84 | + * @return boolean |
|
| 85 | + */ |
|
| 86 | + public static function hasFlash($item) { |
|
| 87 | + $key = self::SESSION_FLASH_KEY . '_' . $item; |
|
| 88 | + return array_key_exists($key, $_SESSION); |
|
| 89 | + } |
|
| 90 | 90 | |
| 91 | - /** |
|
| 92 | - * Set the session flash item value |
|
| 93 | - * @param string $item the session flash item name to set |
|
| 94 | - * @param mixed $value the session flash item value |
|
| 95 | - */ |
|
| 96 | - public static function setFlash($item, $value) { |
|
| 97 | - $key = self::SESSION_FLASH_KEY . '_' . $item; |
|
| 98 | - $_SESSION[$key] = $value; |
|
| 99 | - } |
|
| 91 | + /** |
|
| 92 | + * Set the session flash item value |
|
| 93 | + * @param string $item the session flash item name to set |
|
| 94 | + * @param mixed $value the session flash item value |
|
| 95 | + */ |
|
| 96 | + public static function setFlash($item, $value) { |
|
| 97 | + $key = self::SESSION_FLASH_KEY . '_' . $item; |
|
| 98 | + $_SESSION[$key] = $value; |
|
| 99 | + } |
|
| 100 | 100 | |
| 101 | - /** |
|
| 102 | - * Clear the session item in the list |
|
| 103 | - * @param string $item the session item name to be deleted |
|
| 104 | - */ |
|
| 105 | - public static function clear($item){ |
|
| 106 | - $logger = self::getLogger(); |
|
| 107 | - if(array_key_exists($item, $_SESSION)){ |
|
| 108 | - $logger->info('Deleting of session for item ['.$item.' ]'); |
|
| 109 | - unset($_SESSION[$item]); |
|
| 110 | - } else{ |
|
| 111 | - $logger->warning('Session item ['.$item.'] to be deleted does not exists'); |
|
| 112 | - } |
|
| 113 | - } |
|
| 101 | + /** |
|
| 102 | + * Clear the session item in the list |
|
| 103 | + * @param string $item the session item name to be deleted |
|
| 104 | + */ |
|
| 105 | + public static function clear($item){ |
|
| 106 | + $logger = self::getLogger(); |
|
| 107 | + if(array_key_exists($item, $_SESSION)){ |
|
| 108 | + $logger->info('Deleting of session for item ['.$item.' ]'); |
|
| 109 | + unset($_SESSION[$item]); |
|
| 110 | + } else{ |
|
| 111 | + $logger->warning('Session item ['.$item.'] to be deleted does not exists'); |
|
| 112 | + } |
|
| 113 | + } |
|
| 114 | 114 | |
| 115 | - /** |
|
| 116 | - * Clear the session flash item in the list |
|
| 117 | - * @param string $item the session flash item name to be deleted |
|
| 118 | - */ |
|
| 119 | - public static function clearFlash($item){ |
|
| 120 | - $logger = self::getLogger(); |
|
| 121 | - $key = self::SESSION_FLASH_KEY.'_'.$item; |
|
| 122 | - if(array_key_exists($key, $_SESSION)){ |
|
| 123 | - $logger->info('Delete session flash for item ['.$item.']'); |
|
| 124 | - unset($_SESSION[$item]); |
|
| 125 | - } else{ |
|
| 126 | - $logger->warning('Dession flash item ['.$item.'] to be deleted does not exists'); |
|
| 127 | - } |
|
| 128 | - } |
|
| 115 | + /** |
|
| 116 | + * Clear the session flash item in the list |
|
| 117 | + * @param string $item the session flash item name to be deleted |
|
| 118 | + */ |
|
| 119 | + public static function clearFlash($item){ |
|
| 120 | + $logger = self::getLogger(); |
|
| 121 | + $key = self::SESSION_FLASH_KEY.'_'.$item; |
|
| 122 | + if(array_key_exists($key, $_SESSION)){ |
|
| 123 | + $logger->info('Delete session flash for item ['.$item.']'); |
|
| 124 | + unset($_SESSION[$item]); |
|
| 125 | + } else{ |
|
| 126 | + $logger->warning('Dession flash item ['.$item.'] to be deleted does not exists'); |
|
| 127 | + } |
|
| 128 | + } |
|
| 129 | 129 | |
| 130 | - /** |
|
| 131 | - * Check whether the given session item exists |
|
| 132 | - * @param string $item the session item name |
|
| 133 | - * @return boolean |
|
| 134 | - */ |
|
| 135 | - public static function exists($item) { |
|
| 136 | - return array_key_exists($item, $_SESSION); |
|
| 137 | - } |
|
| 130 | + /** |
|
| 131 | + * Check whether the given session item exists |
|
| 132 | + * @param string $item the session item name |
|
| 133 | + * @return boolean |
|
| 134 | + */ |
|
| 135 | + public static function exists($item) { |
|
| 136 | + return array_key_exists($item, $_SESSION); |
|
| 137 | + } |
|
| 138 | 138 | |
| 139 | - /** |
|
| 140 | - * Destroy all session data values |
|
| 141 | - */ |
|
| 142 | - public static function clearAll() { |
|
| 143 | - session_unset(); |
|
| 144 | - session_destroy(); |
|
| 145 | - } |
|
| 139 | + /** |
|
| 140 | + * Destroy all session data values |
|
| 141 | + */ |
|
| 142 | + public static function clearAll() { |
|
| 143 | + session_unset(); |
|
| 144 | + session_destroy(); |
|
| 145 | + } |
|
| 146 | 146 | |
| 147 | - } |
|
| 147 | + } |
|
@@ -65,15 +65,15 @@ discard block |
||
| 65 | 65 | * @param mixed $default the default value to use if can not find the session flash item in the list |
| 66 | 66 | * @return mixed the session flash value if exist or the default value |
| 67 | 67 | */ |
| 68 | - public static function getFlash($item, $default = null){ |
|
| 68 | + public static function getFlash($item, $default = null) { |
|
| 69 | 69 | $logger = self::getLogger(); |
| 70 | - $key = self::SESSION_FLASH_KEY.'_'.$item; |
|
| 70 | + $key = self::SESSION_FLASH_KEY . '_' . $item; |
|
| 71 | 71 | $return = array_key_exists($key, $_SESSION) ? |
| 72 | 72 | ($_SESSION[$key]) : $default; |
| 73 | - if(array_key_exists($key, $_SESSION)){ |
|
| 73 | + if (array_key_exists($key, $_SESSION)) { |
|
| 74 | 74 | unset($_SESSION[$key]); |
| 75 | - } else{ |
|
| 76 | - $logger->warning('Cannot find session flash item ['. $key .'] using the default value ['. $default .']'); |
|
| 75 | + } else { |
|
| 76 | + $logger->warning('Cannot find session flash item [' . $key . '] using the default value [' . $default . ']'); |
|
| 77 | 77 | } |
| 78 | 78 | return $return; |
| 79 | 79 | } |
@@ -102,13 +102,13 @@ discard block |
||
| 102 | 102 | * Clear the session item in the list |
| 103 | 103 | * @param string $item the session item name to be deleted |
| 104 | 104 | */ |
| 105 | - public static function clear($item){ |
|
| 105 | + public static function clear($item) { |
|
| 106 | 106 | $logger = self::getLogger(); |
| 107 | - if(array_key_exists($item, $_SESSION)){ |
|
| 108 | - $logger->info('Deleting of session for item ['.$item.' ]'); |
|
| 107 | + if (array_key_exists($item, $_SESSION)) { |
|
| 108 | + $logger->info('Deleting of session for item [' . $item . ' ]'); |
|
| 109 | 109 | unset($_SESSION[$item]); |
| 110 | - } else{ |
|
| 111 | - $logger->warning('Session item ['.$item.'] to be deleted does not exists'); |
|
| 110 | + } else { |
|
| 111 | + $logger->warning('Session item [' . $item . '] to be deleted does not exists'); |
|
| 112 | 112 | } |
| 113 | 113 | } |
| 114 | 114 | |
@@ -116,14 +116,14 @@ discard block |
||
| 116 | 116 | * Clear the session flash item in the list |
| 117 | 117 | * @param string $item the session flash item name to be deleted |
| 118 | 118 | */ |
| 119 | - public static function clearFlash($item){ |
|
| 119 | + public static function clearFlash($item) { |
|
| 120 | 120 | $logger = self::getLogger(); |
| 121 | - $key = self::SESSION_FLASH_KEY.'_'.$item; |
|
| 122 | - if(array_key_exists($key, $_SESSION)){ |
|
| 123 | - $logger->info('Delete session flash for item ['.$item.']'); |
|
| 121 | + $key = self::SESSION_FLASH_KEY . '_' . $item; |
|
| 122 | + if (array_key_exists($key, $_SESSION)) { |
|
| 123 | + $logger->info('Delete session flash for item [' . $item . ']'); |
|
| 124 | 124 | unset($_SESSION[$item]); |
| 125 | - } else{ |
|
| 126 | - $logger->warning('Dession flash item ['.$item.'] to be deleted does not exists'); |
|
| 125 | + } else { |
|
| 126 | + $logger->warning('Dession flash item [' . $item . '] to be deleted does not exists'); |
|
| 127 | 127 | } |
| 128 | 128 | } |
| 129 | 129 | |