@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | 25 | */ |
| 26 | 26 | |
| 27 | - class Response{ |
|
| 27 | + class Response { |
|
| 28 | 28 | |
| 29 | 29 | /** |
| 30 | 30 | * The list of request header to send with response |
@@ -65,9 +65,9 @@ discard block |
||
| 65 | 65 | /** |
| 66 | 66 | * Construct new response instance |
| 67 | 67 | */ |
| 68 | - public function __construct(){ |
|
| 69 | - $this->_currentUrl = (! empty($_SERVER['REQUEST_URI']) ? $_SERVER['REQUEST_URI'] : '' ) |
|
| 70 | - . (! empty($_SERVER['QUERY_STRING']) ? ('?' . $_SERVER['QUERY_STRING']) : '' ); |
|
| 68 | + public function __construct() { |
|
| 69 | + $this->_currentUrl = (!empty($_SERVER['REQUEST_URI']) ? $_SERVER['REQUEST_URI'] : '') |
|
| 70 | + . (!empty($_SERVER['QUERY_STRING']) ? ('?' . $_SERVER['QUERY_STRING']) : ''); |
|
| 71 | 71 | |
| 72 | 72 | $this->_currentUrlCacheKey = md5($this->_currentUrl); |
| 73 | 73 | |
@@ -82,9 +82,9 @@ discard block |
||
| 82 | 82 | * Get the logger singleton instance |
| 83 | 83 | * @return Log the logger instance |
| 84 | 84 | */ |
| 85 | - private static function getLogger(){ |
|
| 86 | - if(self::$logger == null){ |
|
| 87 | - self::$logger[0] =& class_loader('Log', 'classes'); |
|
| 85 | + private static function getLogger() { |
|
| 86 | + if (self::$logger == null) { |
|
| 87 | + self::$logger[0] = & class_loader('Log', 'classes'); |
|
| 88 | 88 | self::$logger[0]->setLogger('Library::Response'); |
| 89 | 89 | } |
| 90 | 90 | return self::$logger[0]; |
@@ -95,12 +95,12 @@ discard block |
||
| 95 | 95 | * @param integer $httpCode the HTTP status code |
| 96 | 96 | * @param array $headers the additional headers to add to the existing headers list |
| 97 | 97 | */ |
| 98 | - public static function sendHeaders($httpCode = 200, array $headers = array()){ |
|
| 98 | + public static function sendHeaders($httpCode = 200, array $headers = array()) { |
|
| 99 | 99 | set_http_status_header($httpCode); |
| 100 | 100 | self::setHeaders($headers); |
| 101 | - if(! headers_sent()){ |
|
| 102 | - foreach(self::getHeaders() as $key => $value){ |
|
| 103 | - header($key .': '.$value); |
|
| 101 | + if (!headers_sent()) { |
|
| 102 | + foreach (self::getHeaders() as $key => $value) { |
|
| 103 | + header($key . ': ' . $value); |
|
| 104 | 104 | } |
| 105 | 105 | } |
| 106 | 106 | } |
@@ -109,7 +109,7 @@ discard block |
||
| 109 | 109 | * Get the list of the headers |
| 110 | 110 | * @return array the headers list |
| 111 | 111 | */ |
| 112 | - public static function getHeaders(){ |
|
| 112 | + public static function getHeaders() { |
|
| 113 | 113 | return self::$headers; |
| 114 | 114 | } |
| 115 | 115 | |
@@ -118,7 +118,7 @@ discard block |
||
| 118 | 118 | * @param string $name the header name |
| 119 | 119 | * @return string the header value |
| 120 | 120 | */ |
| 121 | - public static function getHeader($name){ |
|
| 121 | + public static function getHeader($name) { |
|
| 122 | 122 | return array_key_exists($name, self::$headers) ? self::$headers[$name] : null; |
| 123 | 123 | } |
| 124 | 124 | |
@@ -128,7 +128,7 @@ discard block |
||
| 128 | 128 | * @param string $name the header name |
| 129 | 129 | * @param string $value the header value to be set |
| 130 | 130 | */ |
| 131 | - public static function setHeader($name, $value){ |
|
| 131 | + public static function setHeader($name, $value) { |
|
| 132 | 132 | self::$headers[$name] = $value; |
| 133 | 133 | } |
| 134 | 134 | |
@@ -137,7 +137,7 @@ discard block |
||
| 137 | 137 | * @param array $headers the list of the headers to set. |
| 138 | 138 | * Note: this will merge with the existing headers |
| 139 | 139 | */ |
| 140 | - public static function setHeaders(array $headers){ |
|
| 140 | + public static function setHeaders(array $headers) { |
|
| 141 | 141 | self::$headers = array_merge(self::getHeaders(), $headers); |
| 142 | 142 | } |
| 143 | 143 | |
@@ -145,17 +145,17 @@ discard block |
||
| 145 | 145 | * Redirect user in the specified page |
| 146 | 146 | * @param string $path the URL or URI to be redirect to |
| 147 | 147 | */ |
| 148 | - public static function redirect($path = ''){ |
|
| 148 | + public static function redirect($path = '') { |
|
| 149 | 149 | $logger = self::getLogger(); |
| 150 | 150 | $url = Url::site_url($path); |
| 151 | - $logger->info('Redirect to URL [' .$url. ']'); |
|
| 152 | - if(! headers_sent()){ |
|
| 153 | - header('Location: '.$url); |
|
| 151 | + $logger->info('Redirect to URL [' . $url . ']'); |
|
| 152 | + if (!headers_sent()) { |
|
| 153 | + header('Location: ' . $url); |
|
| 154 | 154 | exit; |
| 155 | 155 | } |
| 156 | - else{ |
|
| 156 | + else { |
|
| 157 | 157 | echo '<script> |
| 158 | - location.href = "'.$url.'"; |
|
| 158 | + location.href = "'.$url . '"; |
|
| 159 | 159 | </script>'; |
| 160 | 160 | } |
| 161 | 161 | } |
@@ -168,10 +168,10 @@ discard block |
||
| 168 | 168 | * @return void|string if $return is true will return the view content otherwise |
| 169 | 169 | * will display the view content. |
| 170 | 170 | */ |
| 171 | - public function render($view, $data = null, $return = false){ |
|
| 171 | + public function render($view, $data = null, $return = false) { |
|
| 172 | 172 | $logger = self::getLogger(); |
| 173 | 173 | //convert data to an array |
| 174 | - $data = ! is_array($data) ? (array) $data : $data; |
|
| 174 | + $data = !is_array($data) ? (array) $data : $data; |
|
| 175 | 175 | $view = str_ireplace('.php', '', $view); |
| 176 | 176 | $view = trim($view, '/\\'); |
| 177 | 177 | $viewFile = $view . '.php'; |
@@ -180,42 +180,42 @@ discard block |
||
| 180 | 180 | //super instance |
| 181 | 181 | $obj = & get_instance(); |
| 182 | 182 | |
| 183 | - if(Module::hasModule()){ |
|
| 183 | + if (Module::hasModule()) { |
|
| 184 | 184 | //check in module first |
| 185 | 185 | $logger->debug('Checking the view [' . $view . '] from module list ...'); |
| 186 | 186 | $mod = null; |
| 187 | 187 | //check if the request class contains module name |
| 188 | - if(strpos($view, '/') !== false){ |
|
| 188 | + if (strpos($view, '/') !== false) { |
|
| 189 | 189 | $viewPath = explode('/', $view); |
| 190 | - if(isset($viewPath[0]) && in_array($viewPath[0], Module::getModuleList())){ |
|
| 190 | + if (isset($viewPath[0]) && in_array($viewPath[0], Module::getModuleList())) { |
|
| 191 | 191 | $mod = $viewPath[0]; |
| 192 | 192 | array_shift($viewPath); |
| 193 | 193 | $view = implode('/', $viewPath); |
| 194 | 194 | $viewFile = $view . '.php'; |
| 195 | 195 | } |
| 196 | 196 | } |
| 197 | - if(! $mod && !empty($obj->moduleName)){ |
|
| 197 | + if (!$mod && !empty($obj->moduleName)) { |
|
| 198 | 198 | $mod = $obj->moduleName; |
| 199 | 199 | } |
| 200 | - if($mod){ |
|
| 200 | + if ($mod) { |
|
| 201 | 201 | $moduleViewPath = Module::findViewFullPath($view, $mod); |
| 202 | - if($moduleViewPath){ |
|
| 202 | + if ($moduleViewPath) { |
|
| 203 | 203 | $path = $moduleViewPath; |
| 204 | - $logger->info('Found view [' . $view . '] in module [' .$mod. '], the file path is [' .$moduleViewPath. '] we will used it'); |
|
| 204 | + $logger->info('Found view [' . $view . '] in module [' . $mod . '], the file path is [' . $moduleViewPath . '] we will used it'); |
|
| 205 | 205 | } |
| 206 | - else{ |
|
| 207 | - $logger->info('Cannot find view [' . $view . '] in module [' .$mod. '] using the default location'); |
|
| 206 | + else { |
|
| 207 | + $logger->info('Cannot find view [' . $view . '] in module [' . $mod . '] using the default location'); |
|
| 208 | 208 | } |
| 209 | 209 | } |
| 210 | - else{ |
|
| 210 | + else { |
|
| 211 | 211 | $logger->info('The current request does not use module using the default location.'); |
| 212 | 212 | } |
| 213 | 213 | } |
| 214 | 214 | $logger->info('The view file path to be loaded is [' . $path . ']'); |
| 215 | 215 | $found = false; |
| 216 | - if(file_exists($path)){ |
|
| 217 | - foreach(get_object_vars($obj) as $key => $value){ |
|
| 218 | - if(! isset($this->{$key})){ |
|
| 216 | + if (file_exists($path)) { |
|
| 217 | + foreach (get_object_vars($obj) as $key => $value) { |
|
| 218 | + if (!isset($this->{$key})) { |
|
| 219 | 219 | $this->{$key} = & $obj->{$key}; |
| 220 | 220 | } |
| 221 | 221 | } |
@@ -224,44 +224,44 @@ discard block |
||
| 224 | 224 | //need use require() instead of require_once because can load this view many time |
| 225 | 225 | require $path; |
| 226 | 226 | $content = ob_get_clean(); |
| 227 | - if($return){ |
|
| 227 | + if ($return) { |
|
| 228 | 228 | return $content; |
| 229 | 229 | } |
| 230 | 230 | $this->_pageRender .= $content; |
| 231 | 231 | $found = true; |
| 232 | 232 | } |
| 233 | - if(! $found){ |
|
| 234 | - show_error('Unable to find view [' .$view . ']'); |
|
| 233 | + if (!$found) { |
|
| 234 | + show_error('Unable to find view [' . $view . ']'); |
|
| 235 | 235 | } |
| 236 | 236 | } |
| 237 | 237 | |
| 238 | 238 | /** |
| 239 | 239 | * Send the final page output to user |
| 240 | 240 | */ |
| 241 | - public function renderFinalPage(){ |
|
| 241 | + public function renderFinalPage() { |
|
| 242 | 242 | $logger = self::getLogger(); |
| 243 | 243 | $obj = & get_instance(); |
| 244 | 244 | $cachePageStatus = get_config('cache_enable', false) && !empty($obj->view_cache_enable); |
| 245 | 245 | $dispatcher = $obj->eventdispatcher; |
| 246 | 246 | $content = $this->_pageRender; |
| 247 | - if(! $content){ |
|
| 247 | + if (!$content) { |
|
| 248 | 248 | $logger->warning('The final view content is empty.'); |
| 249 | 249 | return; |
| 250 | 250 | } |
| 251 | 251 | //dispatch |
| 252 | 252 | $event = $dispatcher->dispatch(new EventInfo('FINAL_VIEW_READY', $content, true)); |
| 253 | - $content = ! empty($event->payload) ? $event->payload : null; |
|
| 254 | - if(empty($content)){ |
|
| 253 | + $content = !empty($event->payload) ? $event->payload : null; |
|
| 254 | + if (empty($content)) { |
|
| 255 | 255 | $logger->warning('The view content is empty after dispatch to event listeners.'); |
| 256 | 256 | } |
| 257 | 257 | |
| 258 | 258 | //check whether need save the page into cache. |
| 259 | - if($cachePageStatus){ |
|
| 259 | + if ($cachePageStatus) { |
|
| 260 | 260 | //current page URL |
| 261 | 261 | $url = $this->_currentUrl; |
| 262 | 262 | //Cache view Time to live in second |
| 263 | 263 | $viewCacheTtl = get_config('cache_ttl'); |
| 264 | - if (!empty($obj->view_cache_ttl)){ |
|
| 264 | + if (!empty($obj->view_cache_ttl)) { |
|
| 265 | 265 | $viewCacheTtl = $obj->view_cache_ttl; |
| 266 | 266 | } |
| 267 | 267 | //the cache handler instance |
@@ -274,14 +274,14 @@ discard block |
||
| 274 | 274 | |
| 275 | 275 | //get the cache information to prepare header to send to browser |
| 276 | 276 | $cacheInfo = $cacheInstance->getInfo($cacheKey); |
| 277 | - if($cacheInfo){ |
|
| 277 | + if ($cacheInfo) { |
|
| 278 | 278 | $lastModified = $cacheInfo['mtime']; |
| 279 | 279 | $expire = $cacheInfo['expire']; |
| 280 | 280 | $maxAge = $expire - time(); |
| 281 | 281 | self::setHeader('Pragma', 'public'); |
| 282 | 282 | self::setHeader('Cache-Control', 'max-age=' . $maxAge . ', public'); |
| 283 | - self::setHeader('Expires', gmdate('D, d M Y H:i:s', $expire).' GMT'); |
|
| 284 | - self::setHeader('Last-modified', gmdate('D, d M Y H:i:s', $lastModified).' GMT'); |
|
| 283 | + self::setHeader('Expires', gmdate('D, d M Y H:i:s', $expire) . ' GMT'); |
|
| 284 | + self::setHeader('Last-modified', gmdate('D, d M Y H:i:s', $lastModified) . ' GMT'); |
|
| 285 | 285 | } |
| 286 | 286 | } |
| 287 | 287 | |
@@ -293,7 +293,7 @@ discard block |
||
| 293 | 293 | |
| 294 | 294 | //compress the output if is available |
| 295 | 295 | $type = null; |
| 296 | - if (self::$_canCompressOutput){ |
|
| 296 | + if (self::$_canCompressOutput) { |
|
| 297 | 297 | $type = 'ob_gzhandler'; |
| 298 | 298 | } |
| 299 | 299 | ob_start($type); |
@@ -305,7 +305,7 @@ discard block |
||
| 305 | 305 | /** |
| 306 | 306 | * Send the final page output to user if is cached |
| 307 | 307 | */ |
| 308 | - public function renderFinalPageFromCache(&$cache){ |
|
| 308 | + public function renderFinalPageFromCache(&$cache) { |
|
| 309 | 309 | $logger = self::getLogger(); |
| 310 | 310 | $url = $this->_currentUrl; |
| 311 | 311 | //the current page cache key for identification |
@@ -314,25 +314,25 @@ discard block |
||
| 314 | 314 | $logger->debug('Checking if the page content for the URL [' . $url . '] is cached ...'); |
| 315 | 315 | //get the cache information to prepare header to send to browser |
| 316 | 316 | $cacheInfo = $cache->getInfo($pageCacheKey); |
| 317 | - if($cacheInfo){ |
|
| 317 | + if ($cacheInfo) { |
|
| 318 | 318 | $lastModified = $cacheInfo['mtime']; |
| 319 | 319 | $expire = $cacheInfo['expire']; |
| 320 | 320 | $maxAge = $expire - $_SERVER['REQUEST_TIME']; |
| 321 | 321 | self::setHeader('Pragma', 'public'); |
| 322 | 322 | self::setHeader('Cache-Control', 'max-age=' . $maxAge . ', public'); |
| 323 | - self::setHeader('Expires', gmdate('D, d M Y H:i:s', $expire).' GMT'); |
|
| 324 | - self::setHeader('Last-modified', gmdate('D, d M Y H:i:s', $lastModified).' GMT'); |
|
| 325 | - if (isset($_SERVER['HTTP_IF_MODIFIED_SINCE']) && $lastModified <= strtotime($_SERVER['HTTP_IF_MODIFIED_SINCE'])){ |
|
| 323 | + self::setHeader('Expires', gmdate('D, d M Y H:i:s', $expire) . ' GMT'); |
|
| 324 | + self::setHeader('Last-modified', gmdate('D, d M Y H:i:s', $lastModified) . ' GMT'); |
|
| 325 | + if (isset($_SERVER['HTTP_IF_MODIFIED_SINCE']) && $lastModified <= strtotime($_SERVER['HTTP_IF_MODIFIED_SINCE'])) { |
|
| 326 | 326 | $logger->info('The cache page content is not yet expire for the URL [' . $url . '] send 304 header to browser'); |
| 327 | 327 | self::sendHeaders(304); |
| 328 | 328 | return; |
| 329 | 329 | } |
| 330 | - else{ |
|
| 330 | + else { |
|
| 331 | 331 | $logger->info('The cache page content is expired or the browser don\'t send the HTTP_IF_MODIFIED_SINCE header for the URL [' . $url . '] send cache headers to tell the browser'); |
| 332 | 332 | self::sendHeaders(200); |
| 333 | 333 | //get the cache content |
| 334 | 334 | $content = $cache->get($pageCacheKey); |
| 335 | - if($content){ |
|
| 335 | + if ($content) { |
|
| 336 | 336 | $logger->info('The page content for the URL [' . $url . '] already cached just display it'); |
| 337 | 337 | //load benchmark class |
| 338 | 338 | $benchmark = & class_loader('Benchmark'); |
@@ -345,17 +345,17 @@ discard block |
||
| 345 | 345 | |
| 346 | 346 | ///display the final output |
| 347 | 347 | //compress the output if is available |
| 348 | - if (self::$_canCompressOutput){ |
|
| 348 | + if (self::$_canCompressOutput) { |
|
| 349 | 349 | ob_start('ob_gzhandler'); |
| 350 | 350 | } |
| 351 | - else{ |
|
| 351 | + else { |
|
| 352 | 352 | ob_start(); |
| 353 | 353 | } |
| 354 | 354 | echo $content; |
| 355 | 355 | ob_end_flush(); |
| 356 | 356 | return; |
| 357 | 357 | } |
| 358 | - else{ |
|
| 358 | + else { |
|
| 359 | 359 | $logger->info('The page cache content for the URL [' . $url . '] is not valid may be already expired'); |
| 360 | 360 | $cache->delete($pageCacheKey); |
| 361 | 361 | } |
@@ -367,7 +367,7 @@ discard block |
||
| 367 | 367 | * Get the final page to be rendered |
| 368 | 368 | * @return string |
| 369 | 369 | */ |
| 370 | - public function getFinalPageRendered(){ |
|
| 370 | + public function getFinalPageRendered() { |
|
| 371 | 371 | return $this->_pageRender; |
| 372 | 372 | } |
| 373 | 373 | |
@@ -375,14 +375,14 @@ discard block |
||
| 375 | 375 | * Send the HTTP 404 error if can not found the |
| 376 | 376 | * routing information for the current request |
| 377 | 377 | */ |
| 378 | - public static function send404(){ |
|
| 378 | + public static function send404() { |
|
| 379 | 379 | /********* for logs **************/ |
| 380 | 380 | //can't use $obj = & get_instance() here because the global super object will be available until |
| 381 | 381 | //the main controller is loaded even for Loader::library('xxxx'); |
| 382 | 382 | $logger = self::getLogger(); |
| 383 | - $request =& class_loader('Request', 'classes'); |
|
| 384 | - $userAgent =& class_loader('Browser'); |
|
| 385 | - $browser = $userAgent->getPlatform().', '.$userAgent->getBrowser().' '.$userAgent->getVersion(); |
|
| 383 | + $request = & class_loader('Request', 'classes'); |
|
| 384 | + $userAgent = & class_loader('Browser'); |
|
| 385 | + $browser = $userAgent->getPlatform() . ', ' . $userAgent->getBrowser() . ' ' . $userAgent->getVersion(); |
|
| 386 | 386 | |
| 387 | 387 | //here can't use Loader::functions just include the helper manually |
| 388 | 388 | require_once CORE_FUNCTIONS_PATH . 'function_user_agent.php'; |
@@ -392,12 +392,12 @@ discard block |
||
| 392 | 392 | $logger->error($str); |
| 393 | 393 | /***********************************/ |
| 394 | 394 | $path = CORE_VIEWS_PATH . '404.php'; |
| 395 | - if(file_exists($path)){ |
|
| 395 | + if (file_exists($path)) { |
|
| 396 | 396 | //compress the output if is available |
| 397 | - if (self::$_canCompressOutput){ |
|
| 397 | + if (self::$_canCompressOutput) { |
|
| 398 | 398 | ob_start('ob_gzhandler'); |
| 399 | 399 | } |
| 400 | - else{ |
|
| 400 | + else { |
|
| 401 | 401 | ob_start(); |
| 402 | 402 | } |
| 403 | 403 | require_once $path; |
@@ -405,8 +405,8 @@ discard block |
||
| 405 | 405 | self::sendHeaders(404); |
| 406 | 406 | echo $output; |
| 407 | 407 | } |
| 408 | - else{ |
|
| 409 | - show_error('The 404 view [' .$path. '] does not exist'); |
|
| 408 | + else { |
|
| 409 | + show_error('The 404 view [' . $path . '] does not exist'); |
|
| 410 | 410 | } |
| 411 | 411 | } |
| 412 | 412 | |
@@ -414,14 +414,14 @@ discard block |
||
| 414 | 414 | * Display the error to user |
| 415 | 415 | * @param array $data the error information |
| 416 | 416 | */ |
| 417 | - public static function sendError(array $data = array()){ |
|
| 417 | + public static function sendError(array $data = array()) { |
|
| 418 | 418 | $path = CORE_VIEWS_PATH . 'errors.php'; |
| 419 | - if(file_exists($path)){ |
|
| 419 | + if (file_exists($path)) { |
|
| 420 | 420 | //compress the output if exists |
| 421 | - if (self::$_canCompressOutput){ |
|
| 421 | + if (self::$_canCompressOutput) { |
|
| 422 | 422 | ob_start('ob_gzhandler'); |
| 423 | 423 | } |
| 424 | - else{ |
|
| 424 | + else { |
|
| 425 | 425 | ob_start(); |
| 426 | 426 | } |
| 427 | 427 | extract($data); |
@@ -430,7 +430,7 @@ discard block |
||
| 430 | 430 | self::sendHeaders(503); |
| 431 | 431 | echo $output; |
| 432 | 432 | } |
| 433 | - else{ |
|
| 433 | + else { |
|
| 434 | 434 | //can't use show_error() at this time because some dependencies not yet loaded and to prevent loop |
| 435 | 435 | set_http_status_header(503); |
| 436 | 436 | echo 'The error view [' . $path . '] does not exist'; |
@@ -23,110 +23,110 @@ 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{ |
|
| 26 | + class Database { |
|
| 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 error returned for the last query |
| 60 | 60 | * @var string |
| 61 | 61 | */ |
| 62 | - private $error = null; |
|
| 62 | + private $error = null; |
|
| 63 | 63 | |
| 64 | 64 | /** |
| 65 | 65 | * The result returned for the last query |
| 66 | 66 | * @var mixed |
| 67 | 67 | */ |
| 68 | - private $result = array(); |
|
| 68 | + private $result = array(); |
|
| 69 | 69 | |
| 70 | 70 | /** |
| 71 | 71 | * The cache default time to live in second. 0 means no need to use the cache feature |
| 72 | 72 | * @var int |
| 73 | 73 | */ |
| 74 | - private $cacheTtl = 0; |
|
| 74 | + private $cacheTtl = 0; |
|
| 75 | 75 | |
| 76 | 76 | /** |
| 77 | 77 | * The cache current time to live. 0 means no need to use the cache feature |
| 78 | 78 | * @var int |
| 79 | 79 | */ |
| 80 | - private $temporaryCacheTtl = 0; |
|
| 80 | + private $temporaryCacheTtl = 0; |
|
| 81 | 81 | |
| 82 | 82 | /** |
| 83 | 83 | * The number of executed query for the current request |
| 84 | 84 | * @var int |
| 85 | 85 | */ |
| 86 | - private $queryCount = 0; |
|
| 86 | + private $queryCount = 0; |
|
| 87 | 87 | |
| 88 | 88 | /** |
| 89 | 89 | * The default data to be used in the statments query INSERT, UPDATE |
| 90 | 90 | * @var array |
| 91 | 91 | */ |
| 92 | - private $data = array(); |
|
| 92 | + private $data = array(); |
|
| 93 | 93 | |
| 94 | 94 | /** |
| 95 | 95 | * The database configuration |
| 96 | 96 | * @var array |
| 97 | 97 | */ |
| 98 | - private $config = array(); |
|
| 98 | + private $config = array(); |
|
| 99 | 99 | |
| 100 | 100 | /** |
| 101 | 101 | * The logger instance |
| 102 | 102 | * @var object |
| 103 | 103 | */ |
| 104 | - private $logger = null; |
|
| 104 | + private $logger = null; |
|
| 105 | 105 | |
| 106 | 106 | /** |
| 107 | 107 | * The cache instance |
| 108 | 108 | * @var object |
| 109 | 109 | */ |
| 110 | - private $cacheInstance = null; |
|
| 110 | + private $cacheInstance = null; |
|
| 111 | 111 | |
| 112 | 112 | /** |
| 113 | 113 | * The benchmark instance |
| 114 | 114 | * @var object |
| 115 | 115 | */ |
| 116 | - private $benchmarkInstance = null; |
|
| 116 | + private $benchmarkInstance = null; |
|
| 117 | 117 | |
| 118 | 118 | /** |
| 119 | 119 | * The DatabaseQueryBuilder instance |
| 120 | 120 | * @var object |
| 121 | 121 | */ |
| 122 | - private $queryBuilder = null; |
|
| 122 | + private $queryBuilder = null; |
|
| 123 | 123 | |
| 124 | 124 | |
| 125 | 125 | /** |
| 126 | 126 | * Construct new database |
| 127 | 127 | * @param array $overwriteConfig the config to overwrite with the config set in database.php |
| 128 | 128 | */ |
| 129 | - public function __construct($overwriteConfig = array()){ |
|
| 129 | + public function __construct($overwriteConfig = array()) { |
|
| 130 | 130 | //Set Log instance to use |
| 131 | 131 | $this->setLoggerFromParamOrCreateNewInstance(null); |
| 132 | 132 | |
@@ -144,23 +144,23 @@ discard block |
||
| 144 | 144 | * This is used to connect to database |
| 145 | 145 | * @return bool |
| 146 | 146 | */ |
| 147 | - public function connect(){ |
|
| 147 | + public function connect() { |
|
| 148 | 148 | $config = $this->getDatabaseConfiguration(); |
| 149 | - if (! empty($config)){ |
|
| 150 | - try{ |
|
| 149 | + if (!empty($config)) { |
|
| 150 | + try { |
|
| 151 | 151 | $this->pdo = new PDO($this->getDsnFromDriver(), $config['username'], $config['password']); |
| 152 | 152 | $this->pdo->exec("SET NAMES '" . $config['charset'] . "' COLLATE '" . $config['collation'] . "'"); |
| 153 | 153 | $this->pdo->exec("SET CHARACTER SET '" . $config['charset'] . "'"); |
| 154 | 154 | $this->pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ); |
| 155 | 155 | return true; |
| 156 | 156 | } |
| 157 | - catch (PDOException $e){ |
|
| 157 | + catch (PDOException $e) { |
|
| 158 | 158 | $this->logger->fatal($e->getMessage()); |
| 159 | 159 | show_error('Cannot connect to Database.'); |
| 160 | 160 | return false; |
| 161 | 161 | } |
| 162 | 162 | } |
| 163 | - else{ |
|
| 163 | + else { |
|
| 164 | 164 | show_error('Database configuration is not set.'); |
| 165 | 165 | return false; |
| 166 | 166 | } |
@@ -171,7 +171,7 @@ discard block |
||
| 171 | 171 | * Return the number of rows returned by the current query |
| 172 | 172 | * @return int |
| 173 | 173 | */ |
| 174 | - public function numRows(){ |
|
| 174 | + public function numRows() { |
|
| 175 | 175 | return $this->numRows; |
| 176 | 176 | } |
| 177 | 177 | |
@@ -179,15 +179,15 @@ discard block |
||
| 179 | 179 | * Return the last insert id value |
| 180 | 180 | * @return mixed |
| 181 | 181 | */ |
| 182 | - public function insertId(){ |
|
| 182 | + public function insertId() { |
|
| 183 | 183 | return $this->insertId; |
| 184 | 184 | } |
| 185 | 185 | |
| 186 | 186 | /** |
| 187 | 187 | * Show an error got from the current query (SQL command synthax error, database driver returned error, etc.) |
| 188 | 188 | */ |
| 189 | - public function error(){ |
|
| 190 | - if ($this->error){ |
|
| 189 | + public function error() { |
|
| 190 | + if ($this->error) { |
|
| 191 | 191 | show_error('Query: "' . $this->query . '" Error: ' . $this->error, 'Database Error'); |
| 192 | 192 | } |
| 193 | 193 | } |
@@ -198,13 +198,13 @@ 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 get($returnSQLQueryOrResultType = false){ |
|
| 201 | + public function get($returnSQLQueryOrResultType = false) { |
|
| 202 | 202 | $this->getQueryBuilder()->limit(1); |
| 203 | 203 | $query = $this->getAll(true); |
| 204 | - if ($returnSQLQueryOrResultType === true){ |
|
| 204 | + if ($returnSQLQueryOrResultType === true) { |
|
| 205 | 205 | return $query; |
| 206 | 206 | } |
| 207 | - else{ |
|
| 207 | + else { |
|
| 208 | 208 | return $this->query($query, false, $returnSQLQueryOrResultType == 'array'); |
| 209 | 209 | } |
| 210 | 210 | } |
@@ -215,9 +215,9 @@ discard block |
||
| 215 | 215 | * If is string will determine the result type "array" or "object" |
| 216 | 216 | * @return mixed the query SQL string or the record result |
| 217 | 217 | */ |
| 218 | - public function getAll($returnSQLQueryOrResultType = false){ |
|
| 218 | + public function getAll($returnSQLQueryOrResultType = false) { |
|
| 219 | 219 | $query = $this->getQueryBuilder()->getQuery(); |
| 220 | - if ($returnSQLQueryOrResultType === true){ |
|
| 220 | + if ($returnSQLQueryOrResultType === true) { |
|
| 221 | 221 | return $query; |
| 222 | 222 | } |
| 223 | 223 | return $this->query($query, true, $returnSQLQueryOrResultType == 'array'); |
@@ -229,18 +229,18 @@ discard block |
||
| 229 | 229 | * @param boolean $escape whether to escape or not the values |
| 230 | 230 | * @return mixed the insert id of the new record or null |
| 231 | 231 | */ |
| 232 | - public function insert($data = array(), $escape = true){ |
|
| 233 | - if (empty($data) && $this->getData()){ |
|
| 232 | + public function insert($data = array(), $escape = true) { |
|
| 233 | + if (empty($data) && $this->getData()) { |
|
| 234 | 234 | //as when using $this->setData() may be the data already escaped |
| 235 | 235 | $escape = false; |
| 236 | 236 | $data = $this->getData(); |
| 237 | 237 | } |
| 238 | 238 | $query = $this->getQueryBuilder()->insert($data, $escape)->getQuery(); |
| 239 | 239 | $result = $this->query($query); |
| 240 | - if ($result){ |
|
| 240 | + if ($result) { |
|
| 241 | 241 | $this->insertId = $this->pdo->lastInsertId(); |
| 242 | 242 | //if the table doesn't have the auto increment field or sequence, the value of 0 will be returned |
| 243 | - return ! $this->insertId() ? true : $this->insertId(); |
|
| 243 | + return !$this->insertId() ? true : $this->insertId(); |
|
| 244 | 244 | } |
| 245 | 245 | return false; |
| 246 | 246 | } |
@@ -251,8 +251,8 @@ discard block |
||
| 251 | 251 | * @param boolean $escape whether to escape or not the values |
| 252 | 252 | * @return mixed the update status |
| 253 | 253 | */ |
| 254 | - public function update($data = array(), $escape = true){ |
|
| 255 | - if (empty($data) && $this->getData()){ |
|
| 254 | + public function update($data = array(), $escape = true) { |
|
| 255 | + if (empty($data) && $this->getData()) { |
|
| 256 | 256 | //as when using $this->setData() may be the data already escaped |
| 257 | 257 | $escape = false; |
| 258 | 258 | $data = $this->getData(); |
@@ -265,7 +265,7 @@ discard block |
||
| 265 | 265 | * Delete the record in database |
| 266 | 266 | * @return mixed the delete status |
| 267 | 267 | */ |
| 268 | - public function delete(){ |
|
| 268 | + public function delete() { |
|
| 269 | 269 | $query = $this->getQueryBuilder()->delete()->getQuery(); |
| 270 | 270 | return $this->query($query); |
| 271 | 271 | } |
@@ -275,8 +275,8 @@ discard block |
||
| 275 | 275 | * @param integer $ttl the cache time to live in second |
| 276 | 276 | * @return object the current Database instance |
| 277 | 277 | */ |
| 278 | - public function setCache($ttl = 0){ |
|
| 279 | - if ($ttl > 0){ |
|
| 278 | + public function setCache($ttl = 0) { |
|
| 279 | + if ($ttl > 0) { |
|
| 280 | 280 | $this->cacheTtl = $ttl; |
| 281 | 281 | $this->temporaryCacheTtl = $ttl; |
| 282 | 282 | } |
@@ -288,8 +288,8 @@ discard block |
||
| 288 | 288 | * @param integer $ttl the cache time to live in second |
| 289 | 289 | * @return object the current Database instance |
| 290 | 290 | */ |
| 291 | - public function cached($ttl = 0){ |
|
| 292 | - if ($ttl > 0){ |
|
| 291 | + public function cached($ttl = 0) { |
|
| 292 | + if ($ttl > 0) { |
|
| 293 | 293 | $this->temporaryCacheTtl = $ttl; |
| 294 | 294 | } |
| 295 | 295 | return $this; |
@@ -301,7 +301,7 @@ discard block |
||
| 301 | 301 | * @param boolean $escaped whether we can do escape of not |
| 302 | 302 | * @return mixed the data after escaped or the same data if not |
| 303 | 303 | */ |
| 304 | - public function escape($data, $escaped = true){ |
|
| 304 | + public function escape($data, $escaped = true) { |
|
| 305 | 305 | return $escaped ? |
| 306 | 306 | $this->getPdo()->quote(trim($data)) |
| 307 | 307 | : $data; |
@@ -311,7 +311,7 @@ discard block |
||
| 311 | 311 | * Return the number query executed count for the current request |
| 312 | 312 | * @return int |
| 313 | 313 | */ |
| 314 | - public function queryCount(){ |
|
| 314 | + public function queryCount() { |
|
| 315 | 315 | return $this->queryCount; |
| 316 | 316 | } |
| 317 | 317 | |
@@ -319,7 +319,7 @@ discard block |
||
| 319 | 319 | * Return the current query SQL string |
| 320 | 320 | * @return string |
| 321 | 321 | */ |
| 322 | - public function getQuery(){ |
|
| 322 | + public function getQuery() { |
|
| 323 | 323 | return $this->query; |
| 324 | 324 | } |
| 325 | 325 | |
@@ -327,7 +327,7 @@ discard block |
||
| 327 | 327 | * Return the application database name |
| 328 | 328 | * @return string |
| 329 | 329 | */ |
| 330 | - public function getDatabaseName(){ |
|
| 330 | + public function getDatabaseName() { |
|
| 331 | 331 | return $this->databaseName; |
| 332 | 332 | } |
| 333 | 333 | |
@@ -335,7 +335,7 @@ discard block |
||
| 335 | 335 | * Return the PDO instance |
| 336 | 336 | * @return object |
| 337 | 337 | */ |
| 338 | - public function getPdo(){ |
|
| 338 | + public function getPdo() { |
|
| 339 | 339 | return $this->pdo; |
| 340 | 340 | } |
| 341 | 341 | |
@@ -344,7 +344,7 @@ discard block |
||
| 344 | 344 | * @param object $pdo the pdo object |
| 345 | 345 | * @return object Database |
| 346 | 346 | */ |
| 347 | - public function setPdo(PDO $pdo){ |
|
| 347 | + public function setPdo(PDO $pdo) { |
|
| 348 | 348 | $this->pdo = $pdo; |
| 349 | 349 | return $this; |
| 350 | 350 | } |
@@ -354,7 +354,7 @@ discard block |
||
| 354 | 354 | * Return the Log instance |
| 355 | 355 | * @return Log |
| 356 | 356 | */ |
| 357 | - public function getLogger(){ |
|
| 357 | + public function getLogger() { |
|
| 358 | 358 | return $this->logger; |
| 359 | 359 | } |
| 360 | 360 | |
@@ -363,7 +363,7 @@ discard block |
||
| 363 | 363 | * @param Log $logger the log object |
| 364 | 364 | * @return object Database |
| 365 | 365 | */ |
| 366 | - public function setLogger($logger){ |
|
| 366 | + public function setLogger($logger) { |
|
| 367 | 367 | $this->logger = $logger; |
| 368 | 368 | return $this; |
| 369 | 369 | } |
@@ -372,7 +372,7 @@ discard block |
||
| 372 | 372 | * Return the cache instance |
| 373 | 373 | * @return CacheInterface |
| 374 | 374 | */ |
| 375 | - public function getCacheInstance(){ |
|
| 375 | + public function getCacheInstance() { |
|
| 376 | 376 | return $this->cacheInstance; |
| 377 | 377 | } |
| 378 | 378 | |
@@ -381,7 +381,7 @@ discard block |
||
| 381 | 381 | * @param CacheInterface $cache the cache object |
| 382 | 382 | * @return object Database |
| 383 | 383 | */ |
| 384 | - public function setCacheInstance($cache){ |
|
| 384 | + public function setCacheInstance($cache) { |
|
| 385 | 385 | $this->cacheInstance = $cache; |
| 386 | 386 | return $this; |
| 387 | 387 | } |
@@ -390,7 +390,7 @@ discard block |
||
| 390 | 390 | * Return the benchmark instance |
| 391 | 391 | * @return Benchmark |
| 392 | 392 | */ |
| 393 | - public function getBenchmark(){ |
|
| 393 | + public function getBenchmark() { |
|
| 394 | 394 | return $this->benchmarkInstance; |
| 395 | 395 | } |
| 396 | 396 | |
@@ -399,7 +399,7 @@ discard block |
||
| 399 | 399 | * @param Benchmark $benchmark the benchmark object |
| 400 | 400 | * @return object Database |
| 401 | 401 | */ |
| 402 | - public function setBenchmark($benchmark){ |
|
| 402 | + public function setBenchmark($benchmark) { |
|
| 403 | 403 | $this->benchmarkInstance = $benchmark; |
| 404 | 404 | return $this; |
| 405 | 405 | } |
@@ -409,7 +409,7 @@ discard block |
||
| 409 | 409 | * Return the DatabaseQueryBuilder instance |
| 410 | 410 | * @return object DatabaseQueryBuilder |
| 411 | 411 | */ |
| 412 | - public function getQueryBuilder(){ |
|
| 412 | + public function getQueryBuilder() { |
|
| 413 | 413 | return $this->queryBuilder; |
| 414 | 414 | } |
| 415 | 415 | |
@@ -417,7 +417,7 @@ discard block |
||
| 417 | 417 | * Set the DatabaseQueryBuilder instance |
| 418 | 418 | * @param object DatabaseQueryBuilder $queryBuilder the DatabaseQueryBuilder object |
| 419 | 419 | */ |
| 420 | - public function setQueryBuilder(DatabaseQueryBuilder $queryBuilder){ |
|
| 420 | + public function setQueryBuilder(DatabaseQueryBuilder $queryBuilder) { |
|
| 421 | 421 | $this->queryBuilder = $queryBuilder; |
| 422 | 422 | return $this; |
| 423 | 423 | } |
@@ -426,7 +426,7 @@ discard block |
||
| 426 | 426 | * Return the data to be used for insert, update, etc. |
| 427 | 427 | * @return array |
| 428 | 428 | */ |
| 429 | - public function getData(){ |
|
| 429 | + public function getData() { |
|
| 430 | 430 | return $this->data; |
| 431 | 431 | } |
| 432 | 432 | |
@@ -437,9 +437,9 @@ discard block |
||
| 437 | 437 | * @param boolean $escape whether to escape or not the $value |
| 438 | 438 | * @return object the current Database instance |
| 439 | 439 | */ |
| 440 | - public function setData($key, $value = null, $escape = true){ |
|
| 441 | - if(is_array($key)){ |
|
| 442 | - foreach($key as $k => $v){ |
|
| 440 | + public function setData($key, $value = null, $escape = true) { |
|
| 441 | + if (is_array($key)) { |
|
| 442 | + foreach ($key as $k => $v) { |
|
| 443 | 443 | $this->setData($k, $v, $escape); |
| 444 | 444 | } |
| 445 | 445 | } else { |
@@ -456,7 +456,7 @@ discard block |
||
| 456 | 456 | * @param boolean $array return the result as array |
| 457 | 457 | * @return mixed the query result |
| 458 | 458 | */ |
| 459 | - public function query($query, $all = true, $array = false){ |
|
| 459 | + public function query($query, $all = true, $array = false) { |
|
| 460 | 460 | $this->reset(); |
| 461 | 461 | $query = $this->getPreparedQuery($query, $all); |
| 462 | 462 | $this->query = preg_replace('/\s\s+|\t\t+/', ' ', trim($query)); |
@@ -464,9 +464,9 @@ discard block |
||
| 464 | 464 | $isSqlSELECTQuery = stristr($this->query, 'SELECT') !== false; |
| 465 | 465 | |
| 466 | 466 | $this->logger->info( |
| 467 | - 'Execute SQL query ['.$this->query.'], return type: ' |
|
| 468 | - . ($array?'ARRAY':'OBJECT') .', return as list: ' |
|
| 469 | - . (is_bool($all) && $all ? 'YES':'NO') |
|
| 467 | + 'Execute SQL query [' . $this->query . '], return type: ' |
|
| 468 | + . ($array ? 'ARRAY' : 'OBJECT') . ', return as list: ' |
|
| 469 | + . (is_bool($all) && $all ? 'YES' : 'NO') |
|
| 470 | 470 | ); |
| 471 | 471 | //cache expire time |
| 472 | 472 | $cacheExpire = $this->temporaryCacheTtl; |
@@ -483,15 +483,15 @@ discard block |
||
| 483 | 483 | //if can use cache feature for this query |
| 484 | 484 | $dbCacheStatus = $cacheEnable && $cacheExpire > 0; |
| 485 | 485 | |
| 486 | - if ($dbCacheStatus && $isSqlSELECTQuery){ |
|
| 486 | + if ($dbCacheStatus && $isSqlSELECTQuery) { |
|
| 487 | 487 | $this->logger->info('The cache is enabled for this query, try to get result from cache'); |
| 488 | 488 | $cacheContent = $this->getCacheContentForQuery($query, $all, $array); |
| 489 | 489 | } |
| 490 | 490 | |
| 491 | - if ( !$cacheContent){ |
|
| 491 | + if (!$cacheContent) { |
|
| 492 | 492 | $sqlQuery = $this->runSqlQuery($query, $all, $array); |
| 493 | - if (is_object($sqlQuery)){ |
|
| 494 | - if ($isSqlSELECTQuery){ |
|
| 493 | + if (is_object($sqlQuery)) { |
|
| 494 | + if ($isSqlSELECTQuery) { |
|
| 495 | 495 | $this->setQueryResultForSelect($sqlQuery, $all, $array); |
| 496 | 496 | $this->setCacheContentForQuery( |
| 497 | 497 | $this->query, |
@@ -500,15 +500,15 @@ discard block |
||
| 500 | 500 | $dbCacheStatus && $isSqlSELECTQuery, |
| 501 | 501 | $cacheExpire |
| 502 | 502 | ); |
| 503 | - if (! $this->result){ |
|
| 503 | + if (!$this->result) { |
|
| 504 | 504 | $this->logger->info('No result where found for the query [' . $query . ']'); |
| 505 | 505 | } |
| 506 | 506 | } else { |
| 507 | 507 | $this->setQueryResultForNonSelect($sqlQuery); |
| 508 | 508 | } |
| 509 | 509 | } |
| 510 | - } else if ($isSqlSELECTQuery){ |
|
| 511 | - $this->logger->info('The result for query [' .$this->query. '] already cached use it'); |
|
| 510 | + } else if ($isSqlSELECTQuery) { |
|
| 511 | + $this->logger->info('The result for query [' . $this->query . '] already cached use it'); |
|
| 512 | 512 | $this->result = $cacheContent; |
| 513 | 513 | $this->numRows = count($this->result); |
| 514 | 514 | } |
@@ -521,11 +521,11 @@ discard block |
||
| 521 | 521 | * |
| 522 | 522 | * @return object|void |
| 523 | 523 | */ |
| 524 | - public function runSqlQuery($query, $all, $array){ |
|
| 524 | + public function runSqlQuery($query, $all, $array) { |
|
| 525 | 525 | //for database query execution time |
| 526 | 526 | $benchmarkMarkerKey = $this->getCacheBenchmarkKeyForQuery($query, $all, $array); |
| 527 | 527 | $benchmarkInstance = $this->getBenchmark(); |
| 528 | - if (! is_object($benchmarkInstance)){ |
|
| 528 | + if (!is_object($benchmarkInstance)) { |
|
| 529 | 529 | $obj = & get_instance(); |
| 530 | 530 | $benchmarkInstance = $obj->benchmark; |
| 531 | 531 | $this->setBenchmark($benchmarkInstance); |
@@ -538,13 +538,13 @@ discard block |
||
| 538 | 538 | //get response time for this query |
| 539 | 539 | $responseTime = $benchmarkInstance->elapsedTime('DATABASE_QUERY_START(' . $benchmarkMarkerKey . ')', 'DATABASE_QUERY_END(' . $benchmarkMarkerKey . ')'); |
| 540 | 540 | //TODO use the configuration value for the high response time currently is 1 second |
| 541 | - if ($responseTime >= 1 ){ |
|
| 542 | - $this->logger->warning('High response time while processing database query [' .$query. ']. The response time is [' .$responseTime. '] sec.'); |
|
| 541 | + if ($responseTime >= 1) { |
|
| 542 | + $this->logger->warning('High response time while processing database query [' . $query . ']. The response time is [' . $responseTime . '] sec.'); |
|
| 543 | 543 | } |
| 544 | 544 | //count the number of query execution to server |
| 545 | 545 | $this->queryCount++; |
| 546 | 546 | |
| 547 | - if ($sqlQuery !== false){ |
|
| 547 | + if ($sqlQuery !== false) { |
|
| 548 | 548 | return $sqlQuery; |
| 549 | 549 | } |
| 550 | 550 | $this->setQueryError(); |
@@ -555,7 +555,7 @@ discard block |
||
| 555 | 555 | * Return the database configuration |
| 556 | 556 | * @return array |
| 557 | 557 | */ |
| 558 | - public function getDatabaseConfiguration(){ |
|
| 558 | + public function getDatabaseConfiguration() { |
|
| 559 | 559 | return $this->config; |
| 560 | 560 | } |
| 561 | 561 | |
@@ -565,9 +565,9 @@ discard block |
||
| 565 | 565 | * @param boolean $useConfigFile whether to use database configuration file |
| 566 | 566 | * @return object Database |
| 567 | 567 | */ |
| 568 | - public function setDatabaseConfiguration(array $overwriteConfig = array(), $useConfigFile = true){ |
|
| 568 | + public function setDatabaseConfiguration(array $overwriteConfig = array(), $useConfigFile = true) { |
|
| 569 | 569 | $db = array(); |
| 570 | - if ($useConfigFile && file_exists(CONFIG_PATH . 'database.php')){ |
|
| 570 | + if ($useConfigFile && file_exists(CONFIG_PATH . 'database.php')) { |
|
| 571 | 571 | //here don't use require_once because somewhere user can create database instance directly |
| 572 | 572 | require CONFIG_PATH . 'database.php'; |
| 573 | 573 | } |
@@ -592,7 +592,7 @@ discard block |
||
| 592 | 592 | //determine the port using the hostname like localhost:3307 |
| 593 | 593 | //hostname will be "localhost", and port "3307" |
| 594 | 594 | $p = explode(':', $config['hostname']); |
| 595 | - if (count($p) >= 2){ |
|
| 595 | + if (count($p) >= 2) { |
|
| 596 | 596 | $config['hostname'] = $p[0]; |
| 597 | 597 | $config['port'] = $p[1]; |
| 598 | 598 | } |
@@ -611,7 +611,7 @@ discard block |
||
| 611 | 611 | $this->connect(); |
| 612 | 612 | |
| 613 | 613 | //update queryBuilder with some properties needed |
| 614 | - if(is_object($this->getQueryBuilder())){ |
|
| 614 | + if (is_object($this->getQueryBuilder())) { |
|
| 615 | 615 | $this->getQueryBuilder()->setDriver($config['driver']); |
| 616 | 616 | $this->getQueryBuilder()->setPrefix($config['prefix']); |
| 617 | 617 | $this->getQueryBuilder()->setPdo($this->getPdo()); |
@@ -623,19 +623,19 @@ discard block |
||
| 623 | 623 | * Set the result for SELECT query using PDOStatment |
| 624 | 624 | * @see Database::query |
| 625 | 625 | */ |
| 626 | - protected function setQueryResultForSelect($pdoStatment, $all, $array){ |
|
| 626 | + protected function setQueryResultForSelect($pdoStatment, $all, $array) { |
|
| 627 | 627 | //if need return all result like list of record |
| 628 | - if (is_bool($all) && $all){ |
|
| 628 | + if (is_bool($all) && $all) { |
|
| 629 | 629 | $this->result = ($array === false) ? $pdoStatment->fetchAll(PDO::FETCH_OBJ) : $pdoStatment->fetchAll(PDO::FETCH_ASSOC); |
| 630 | 630 | } |
| 631 | - else{ |
|
| 631 | + else { |
|
| 632 | 632 | $this->result = ($array === false) ? $pdoStatment->fetch(PDO::FETCH_OBJ) : $pdoStatment->fetch(PDO::FETCH_ASSOC); |
| 633 | 633 | } |
| 634 | 634 | //Sqlite and pgsql always return 0 when using rowCount() |
| 635 | - if (in_array($this->config['driver'], array('sqlite', 'pgsql'))){ |
|
| 635 | + if (in_array($this->config['driver'], array('sqlite', 'pgsql'))) { |
|
| 636 | 636 | $this->numRows = count($this->result); |
| 637 | 637 | } |
| 638 | - else{ |
|
| 638 | + else { |
|
| 639 | 639 | $this->numRows = $pdoStatment->rowCount(); |
| 640 | 640 | } |
| 641 | 641 | } |
@@ -644,13 +644,13 @@ discard block |
||
| 644 | 644 | * Set the result for other command than SELECT query using PDOStatment |
| 645 | 645 | * @see Database::query |
| 646 | 646 | */ |
| 647 | - protected function setQueryResultForNonSelect($pdoStatment){ |
|
| 647 | + protected function setQueryResultForNonSelect($pdoStatment) { |
|
| 648 | 648 | //Sqlite and pgsql always return 0 when using rowCount() |
| 649 | - if (in_array($this->config['driver'], array('sqlite', 'pgsql'))){ |
|
| 649 | + if (in_array($this->config['driver'], array('sqlite', 'pgsql'))) { |
|
| 650 | 650 | $this->result = true; //to test the result for the query like UPDATE, INSERT, DELETE |
| 651 | 651 | $this->numRows = 1; //TODO use the correct method to get the exact affected row |
| 652 | 652 | } |
| 653 | - else{ |
|
| 653 | + else { |
|
| 654 | 654 | $this->result = $pdoStatment->rowCount() >= 0; //to test the result for the query like UPDATE, INSERT, DELETE |
| 655 | 655 | $this->numRows = $pdoStatment->rowCount(); |
| 656 | 656 | } |
@@ -662,9 +662,9 @@ discard block |
||
| 662 | 662 | * This method is used to get the PDO DSN string using the configured driver |
| 663 | 663 | * @return string the DSN string |
| 664 | 664 | */ |
| 665 | - protected function getDsnFromDriver(){ |
|
| 665 | + protected function getDsnFromDriver() { |
|
| 666 | 666 | $config = $this->getDatabaseConfiguration(); |
| 667 | - if (! empty($config)){ |
|
| 667 | + if (!empty($config)) { |
|
| 668 | 668 | $driver = $config['driver']; |
| 669 | 669 | $driverDsnMap = array( |
| 670 | 670 | 'mysql' => 'mysql:host=' . $config['hostname'] . ';' |
@@ -689,12 +689,12 @@ discard block |
||
| 689 | 689 | * |
| 690 | 690 | * @return string |
| 691 | 691 | */ |
| 692 | - protected function getPreparedQuery($query, $data){ |
|
| 693 | - if (is_array($data)){ |
|
| 692 | + protected function getPreparedQuery($query, $data) { |
|
| 693 | + if (is_array($data)) { |
|
| 694 | 694 | $x = explode('?', $query); |
| 695 | 695 | $q = ''; |
| 696 | - foreach($x as $k => $v){ |
|
| 697 | - if (! empty($v)){ |
|
| 696 | + foreach ($x as $k => $v) { |
|
| 697 | + if (!empty($v)) { |
|
| 698 | 698 | $q .= $v . (isset($data[$k]) ? $this->escape($data[$k]) : ''); |
| 699 | 699 | } |
| 700 | 700 | } |
@@ -709,9 +709,9 @@ discard block |
||
| 709 | 709 | * |
| 710 | 710 | * @return mixed |
| 711 | 711 | */ |
| 712 | - protected function getCacheContentForQuery($query, $all, $array){ |
|
| 712 | + protected function getCacheContentForQuery($query, $all, $array) { |
|
| 713 | 713 | $cacheKey = $this->getCacheBenchmarkKeyForQuery($query, $all, $array); |
| 714 | - if (! is_object($this->getCacheInstance())){ |
|
| 714 | + if (!is_object($this->getCacheInstance())) { |
|
| 715 | 715 | //can not call method with reference in argument |
| 716 | 716 | //like $this->setCacheInstance(& get_instance()->cache); |
| 717 | 717 | //use temporary variable |
@@ -729,10 +729,10 @@ discard block |
||
| 729 | 729 | * @param boolean $status whether can save the query result into cache |
| 730 | 730 | * @param int $expire the cache TTL |
| 731 | 731 | */ |
| 732 | - protected function setCacheContentForQuery($query, $key, $result, $status, $expire){ |
|
| 733 | - if ($status){ |
|
| 734 | - $this->logger->info('Save the result for query [' .$query. '] into cache for future use'); |
|
| 735 | - if (! is_object($this->getCacheInstance())){ |
|
| 732 | + protected function setCacheContentForQuery($query, $key, $result, $status, $expire) { |
|
| 733 | + if ($status) { |
|
| 734 | + $this->logger->info('Save the result for query [' . $query . '] into cache for future use'); |
|
| 735 | + if (!is_object($this->getCacheInstance())) { |
|
| 736 | 736 | //can not call method with reference in argument |
| 737 | 737 | //like $this->setCacheInstance(& get_instance()->cache); |
| 738 | 738 | //use temporary variable |
@@ -747,7 +747,7 @@ discard block |
||
| 747 | 747 | /** |
| 748 | 748 | * Set error for database query execution |
| 749 | 749 | */ |
| 750 | - protected function setQueryError(){ |
|
| 750 | + protected function setQueryError() { |
|
| 751 | 751 | $error = $this->pdo->errorInfo(); |
| 752 | 752 | $this->error = isset($error[2]) ? $error[2] : ''; |
| 753 | 753 | $this->logger->error('The database query execution got error: ' . stringfy_vars($error)); |
@@ -761,8 +761,8 @@ discard block |
||
| 761 | 761 | * |
| 762 | 762 | * @return string |
| 763 | 763 | */ |
| 764 | - protected function getCacheBenchmarkKeyForQuery($query, $all, $array){ |
|
| 765 | - if (is_array($all)){ |
|
| 764 | + protected function getCacheBenchmarkKeyForQuery($query, $all, $array) { |
|
| 765 | + if (is_array($all)) { |
|
| 766 | 766 | $all = 'array'; |
| 767 | 767 | } |
| 768 | 768 | return md5($query . $all . $array); |
@@ -772,12 +772,12 @@ discard block |
||
| 772 | 772 | * Set the Log instance using argument or create new instance |
| 773 | 773 | * @param object $logger the Log instance if not null |
| 774 | 774 | */ |
| 775 | - protected function setLoggerFromParamOrCreateNewInstance(Log $logger = null){ |
|
| 776 | - if ($logger !== null){ |
|
| 775 | + protected function setLoggerFromParamOrCreateNewInstance(Log $logger = null) { |
|
| 776 | + if ($logger !== null) { |
|
| 777 | 777 | $this->setLogger($logger); |
| 778 | 778 | } |
| 779 | - else{ |
|
| 780 | - $this->logger =& class_loader('Log', 'classes'); |
|
| 779 | + else { |
|
| 780 | + $this->logger = & class_loader('Log', 'classes'); |
|
| 781 | 781 | $this->logger->setLogger('Library::Database'); |
| 782 | 782 | } |
| 783 | 783 | } |
@@ -786,19 +786,19 @@ discard block |
||
| 786 | 786 | * Set the DatabaseQueryBuilder instance using argument or create new instance |
| 787 | 787 | * @param object $queryBuilder the DatabaseQueryBuilder instance if not null |
| 788 | 788 | */ |
| 789 | - protected function setQueryBuilderFromParamOrCreateNewInstance(DatabaseQueryBuilder $queryBuilder = null){ |
|
| 790 | - if ($queryBuilder !== null){ |
|
| 789 | + protected function setQueryBuilderFromParamOrCreateNewInstance(DatabaseQueryBuilder $queryBuilder = null) { |
|
| 790 | + if ($queryBuilder !== null) { |
|
| 791 | 791 | $this->setQueryBuilder($queryBuilder); |
| 792 | 792 | } |
| 793 | - else{ |
|
| 794 | - $this->queryBuilder =& class_loader('DatabaseQueryBuilder', 'classes'); |
|
| 793 | + else { |
|
| 794 | + $this->queryBuilder = & class_loader('DatabaseQueryBuilder', 'classes'); |
|
| 795 | 795 | } |
| 796 | 796 | } |
| 797 | 797 | |
| 798 | 798 | /** |
| 799 | 799 | * Reset the database class attributs to the initail values before each query. |
| 800 | 800 | */ |
| 801 | - private function reset(){ |
|
| 801 | + private function reset() { |
|
| 802 | 802 | //query builder reset |
| 803 | 803 | $this->getQueryBuilder()->reset(); |
| 804 | 804 | $this->numRows = 0; |
@@ -812,7 +812,7 @@ discard block |
||
| 812 | 812 | /** |
| 813 | 813 | * The class destructor |
| 814 | 814 | */ |
| 815 | - public function __destruct(){ |
|
| 815 | + public function __destruct() { |
|
| 816 | 816 | $this->pdo = null; |
| 817 | 817 | } |
| 818 | 818 | |
@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | 25 | */ |
| 26 | 26 | |
| 27 | - class Html{ |
|
| 27 | + class Html { |
|
| 28 | 28 | |
| 29 | 29 | /** |
| 30 | 30 | * Generate the html anchor link |
@@ -35,21 +35,21 @@ discard block |
||
| 35 | 35 | * |
| 36 | 36 | * @return string|void the anchor link generated html if $return is true or display it if not |
| 37 | 37 | */ |
| 38 | - public static function a($link = '', $anchor = null, array $attributes = array(), $return = true){ |
|
| 39 | - if(! is_url($link)){ |
|
| 38 | + public static function a($link = '', $anchor = null, array $attributes = array(), $return = true) { |
|
| 39 | + if (!is_url($link)) { |
|
| 40 | 40 | $link = Url::site_url($link); |
| 41 | 41 | } |
| 42 | - if(! $anchor){ |
|
| 42 | + if (!$anchor) { |
|
| 43 | 43 | $anchor = $link; |
| 44 | 44 | } |
| 45 | 45 | $str = null; |
| 46 | - $str .= '<a href = "'.$link.'"'; |
|
| 46 | + $str .= '<a href = "' . $link . '"'; |
|
| 47 | 47 | $str .= attributes_to_string($attributes); |
| 48 | 48 | $str .= '>'; |
| 49 | 49 | $str .= $anchor; |
| 50 | 50 | $str .= '</a>'; |
| 51 | 51 | |
| 52 | - if($return){ |
|
| 52 | + if ($return) { |
|
| 53 | 53 | return $str; |
| 54 | 54 | } |
| 55 | 55 | echo $str; |
@@ -64,18 +64,18 @@ discard block |
||
| 64 | 64 | * |
| 65 | 65 | * @return string|void the generated html for mailto link if $return is true or display it if not |
| 66 | 66 | */ |
| 67 | - public static function mailto($link, $anchor = null, array $attributes = array(), $return = true){ |
|
| 68 | - if(! $anchor){ |
|
| 67 | + public static function mailto($link, $anchor = null, array $attributes = array(), $return = true) { |
|
| 68 | + if (!$anchor) { |
|
| 69 | 69 | $anchor = $link; |
| 70 | 70 | } |
| 71 | 71 | $str = null; |
| 72 | - $str .= '<a href = "mailto:'.$link.'"'; |
|
| 72 | + $str .= '<a href = "mailto:' . $link . '"'; |
|
| 73 | 73 | $str .= attributes_to_string($attributes); |
| 74 | 74 | $str .= '>'; |
| 75 | 75 | $str .= $anchor; |
| 76 | 76 | $str .= '</a>'; |
| 77 | 77 | |
| 78 | - if($return){ |
|
| 78 | + if ($return) { |
|
| 79 | 79 | return $str; |
| 80 | 80 | } |
| 81 | 81 | echo $str; |
@@ -88,14 +88,14 @@ discard block |
||
| 88 | 88 | * |
| 89 | 89 | * @return string|void the generated "br" html if $return is true or display it if not |
| 90 | 90 | */ |
| 91 | - public static function br($nb = 1, $return = true){ |
|
| 91 | + public static function br($nb = 1, $return = true) { |
|
| 92 | 92 | $nb = (int) $nb; |
| 93 | 93 | $str = null; |
| 94 | 94 | for ($i = 1; $i <= $nb; $i++) { |
| 95 | 95 | $str .= '<br />'; |
| 96 | 96 | } |
| 97 | 97 | |
| 98 | - if($return){ |
|
| 98 | + if ($return) { |
|
| 99 | 99 | return $str; |
| 100 | 100 | } |
| 101 | 101 | echo $str; |
@@ -109,13 +109,13 @@ discard block |
||
| 109 | 109 | * |
| 110 | 110 | * @return string|void the generated "hr" html if $return is true or display it if not. |
| 111 | 111 | */ |
| 112 | - public static function hr($nb = 1, array $attributes = array(), $return = true){ |
|
| 112 | + public static function hr($nb = 1, array $attributes = array(), $return = true) { |
|
| 113 | 113 | $nb = (int) $nb; |
| 114 | 114 | $str = null; |
| 115 | 115 | for ($i = 1; $i <= $nb; $i++) { |
| 116 | - $str .= '<hr' .attributes_to_string($attributes). ' />'; |
|
| 116 | + $str .= '<hr' . attributes_to_string($attributes) . ' />'; |
|
| 117 | 117 | } |
| 118 | - if($return){ |
|
| 118 | + if ($return) { |
|
| 119 | 119 | return $str; |
| 120 | 120 | } |
| 121 | 121 | echo $str; |
@@ -131,17 +131,17 @@ discard block |
||
| 131 | 131 | * |
| 132 | 132 | * @return string|void the generated header html if $return is true or display it if not. |
| 133 | 133 | */ |
| 134 | - public static function head($type = 1, $text = null, $nb = 1, array $attributes = array(), $return = true){ |
|
| 134 | + public static function head($type = 1, $text = null, $nb = 1, array $attributes = array(), $return = true) { |
|
| 135 | 135 | $nb = (int) $nb; |
| 136 | 136 | $type = (int) $type; |
| 137 | - if($type <= 0 || $type > 6){ |
|
| 137 | + if ($type <= 0 || $type > 6) { |
|
| 138 | 138 | $type = 1; |
| 139 | 139 | } |
| 140 | 140 | $str = null; |
| 141 | 141 | for ($i = 1; $i <= $nb; $i++) { |
| 142 | - $str .= '<h' . $type . attributes_to_string($attributes). '>' .$text. '</h' . $type . '>'; |
|
| 142 | + $str .= '<h' . $type . attributes_to_string($attributes) . '>' . $text . '</h' . $type . '>'; |
|
| 143 | 143 | } |
| 144 | - if($return){ |
|
| 144 | + if ($return) { |
|
| 145 | 145 | return $str; |
| 146 | 146 | } |
| 147 | 147 | echo $str; |
@@ -156,15 +156,15 @@ discard block |
||
| 156 | 156 | * |
| 157 | 157 | * @return string|void the generated "ul" html if $return is true or display it if not. |
| 158 | 158 | */ |
| 159 | - public static function ul($data = array(), $attributes = array(), $return = true){ |
|
| 159 | + public static function ul($data = array(), $attributes = array(), $return = true) { |
|
| 160 | 160 | $data = (array) $data; |
| 161 | 161 | $str = null; |
| 162 | - $str .= '<ul' . (! empty($attributes['ul']) ? attributes_to_string($attributes['ul']):'') . '>'; |
|
| 162 | + $str .= '<ul' . (!empty($attributes['ul']) ? attributes_to_string($attributes['ul']) : '') . '>'; |
|
| 163 | 163 | foreach ($data as $row) { |
| 164 | - $str .= '<li' . (! empty($attributes['li']) ? attributes_to_string($attributes['li']):'') .'>' .$row. '</li>'; |
|
| 164 | + $str .= '<li' . (!empty($attributes['li']) ? attributes_to_string($attributes['li']) : '') . '>' . $row . '</li>'; |
|
| 165 | 165 | } |
| 166 | 166 | $str .= '</ul>'; |
| 167 | - if($return){ |
|
| 167 | + if ($return) { |
|
| 168 | 168 | return $str; |
| 169 | 169 | } |
| 170 | 170 | echo $str; |
@@ -178,15 +178,15 @@ discard block |
||
| 178 | 178 | * @param boolean $return whether need return the generated html or just display it directly |
| 179 | 179 | * @return string|void the generated "ol" html if $return is true or display it if not. |
| 180 | 180 | */ |
| 181 | - public static function ol($data = array(), $attributes = array(), $return = true){ |
|
| 181 | + public static function ol($data = array(), $attributes = array(), $return = true) { |
|
| 182 | 182 | $data = (array) $data; |
| 183 | 183 | $str = null; |
| 184 | - $str .= '<ol' . (!empty($attributes['ol']) ? attributes_to_string($attributes['ol']):'') . '>'; |
|
| 184 | + $str .= '<ol' . (!empty($attributes['ol']) ? attributes_to_string($attributes['ol']) : '') . '>'; |
|
| 185 | 185 | foreach ($data as $row) { |
| 186 | - $str .= '<li' . (!empty($attributes['li']) ? attributes_to_string($attributes['li']):'') .'>' .$row. '</li>'; |
|
| 186 | + $str .= '<li' . (!empty($attributes['li']) ? attributes_to_string($attributes['li']) : '') . '>' . $row . '</li>'; |
|
| 187 | 187 | } |
| 188 | 188 | $str .= '</ol>'; |
| 189 | - if($return){ |
|
| 189 | + if ($return) { |
|
| 190 | 190 | return $str; |
| 191 | 191 | } |
| 192 | 192 | echo $str; |
@@ -204,46 +204,46 @@ discard block |
||
| 204 | 204 | * @param boolean $return whether need return the generated html or just display it directly |
| 205 | 205 | * @return string|void the generated "table" html if $return is true or display it if not. |
| 206 | 206 | */ |
| 207 | - public static function table($headers = array(), $body = array(), $attributes = array(), $use_footer = false, $return = true){ |
|
| 207 | + public static function table($headers = array(), $body = array(), $attributes = array(), $use_footer = false, $return = true) { |
|
| 208 | 208 | $headers = (array) $headers; |
| 209 | 209 | $body = (array) $body; |
| 210 | 210 | $str = null; |
| 211 | - $str .= '<table' . (! empty($attributes['table']) ? attributes_to_string($attributes['table']):'') . '>'; |
|
| 212 | - if(! empty($headers)){ |
|
| 213 | - $str .= '<thead' . (! empty($attributes['thead']) ? attributes_to_string($attributes['thead']):'') .'>'; |
|
| 214 | - $str .= '<tr' . (! empty($attributes['thead_tr']) ? attributes_to_string($attributes['thead_tr']):'') .'>'; |
|
| 211 | + $str .= '<table' . (!empty($attributes['table']) ? attributes_to_string($attributes['table']) : '') . '>'; |
|
| 212 | + if (!empty($headers)) { |
|
| 213 | + $str .= '<thead' . (!empty($attributes['thead']) ? attributes_to_string($attributes['thead']) : '') . '>'; |
|
| 214 | + $str .= '<tr' . (!empty($attributes['thead_tr']) ? attributes_to_string($attributes['thead_tr']) : '') . '>'; |
|
| 215 | 215 | foreach ($headers as $value) { |
| 216 | - $str .= '<th' . (! empty($attributes['thead_th']) ? attributes_to_string($attributes['thead_th']):'') .'>' .$value. '</th>'; |
|
| 216 | + $str .= '<th' . (!empty($attributes['thead_th']) ? attributes_to_string($attributes['thead_th']) : '') . '>' . $value . '</th>'; |
|
| 217 | 217 | } |
| 218 | 218 | $str .= '</tr>'; |
| 219 | 219 | $str .= '</thead>'; |
| 220 | 220 | } |
| 221 | - else{ |
|
| 221 | + else { |
|
| 222 | 222 | //no need check for footer |
| 223 | 223 | $use_footer = false; |
| 224 | 224 | } |
| 225 | - $str .= '<tbody' . (! empty($attributes['tbody']) ? attributes_to_string($attributes['tbody']):'') .'>'; |
|
| 225 | + $str .= '<tbody' . (!empty($attributes['tbody']) ? attributes_to_string($attributes['tbody']) : '') . '>'; |
|
| 226 | 226 | foreach ($body as $row) { |
| 227 | - if(is_array($row)){ |
|
| 228 | - $str .= '<tr' . (! empty($attributes['tbody_tr']) ? attributes_to_string($attributes['tbody_tr']):'') .'>'; |
|
| 227 | + if (is_array($row)) { |
|
| 228 | + $str .= '<tr' . (!empty($attributes['tbody_tr']) ? attributes_to_string($attributes['tbody_tr']) : '') . '>'; |
|
| 229 | 229 | foreach ($row as $value) { |
| 230 | - $str .= '<td' . (! empty($attributes['tbody_td']) ? attributes_to_string($attributes['tbody_td']):'') .'>' .$value. '</td>'; |
|
| 230 | + $str .= '<td' . (!empty($attributes['tbody_td']) ? attributes_to_string($attributes['tbody_td']) : '') . '>' . $value . '</td>'; |
|
| 231 | 231 | } |
| 232 | 232 | $str .= '</tr>'; |
| 233 | 233 | } |
| 234 | 234 | } |
| 235 | 235 | $str .= '</tbody>'; |
| 236 | - if($use_footer){ |
|
| 237 | - $str .= '<tfoot' . (! empty($attributes['tfoot']) ? attributes_to_string($attributes['tfoot']):'') .'>'; |
|
| 238 | - $str .= '<tr' . (! empty($attributes['tfoot_tr']) ? attributes_to_string($attributes['tfoot_tr']):'') .'>'; |
|
| 236 | + if ($use_footer) { |
|
| 237 | + $str .= '<tfoot' . (!empty($attributes['tfoot']) ? attributes_to_string($attributes['tfoot']) : '') . '>'; |
|
| 238 | + $str .= '<tr' . (!empty($attributes['tfoot_tr']) ? attributes_to_string($attributes['tfoot_tr']) : '') . '>'; |
|
| 239 | 239 | foreach ($headers as $value) { |
| 240 | - $str .= '<th' . (! empty($attributes['tfoot_th']) ? attributes_to_string($attributes['tfoot_th']):'') .'>' .$value. '</th>'; |
|
| 240 | + $str .= '<th' . (!empty($attributes['tfoot_th']) ? attributes_to_string($attributes['tfoot_th']) : '') . '>' . $value . '</th>'; |
|
| 241 | 241 | } |
| 242 | 242 | $str .= '</tr>'; |
| 243 | 243 | $str .= '</tfoot>'; |
| 244 | 244 | } |
| 245 | 245 | $str .= '</table>'; |
| 246 | - if($return){ |
|
| 246 | + if ($return) { |
|
| 247 | 247 | return $str; |
| 248 | 248 | } |
| 249 | 249 | echo $str; |
@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | 25 | */ |
| 26 | 26 | |
| 27 | - class Module{ |
|
| 27 | + class Module { |
|
| 28 | 28 | |
| 29 | 29 | /** |
| 30 | 30 | * list of loaded module |
@@ -42,9 +42,9 @@ discard block |
||
| 42 | 42 | * The signleton of the logger |
| 43 | 43 | * @return Object the Log instance |
| 44 | 44 | */ |
| 45 | - private static function getLogger(){ |
|
| 46 | - if(self::$logger == null){ |
|
| 47 | - self::$logger[0] =& class_loader('Log', 'classes'); |
|
| 45 | + private static function getLogger() { |
|
| 46 | + if (self::$logger == null) { |
|
| 47 | + self::$logger[0] = & class_loader('Log', 'classes'); |
|
| 48 | 48 | self::$logger[0]->setLogger('Library::Module'); |
| 49 | 49 | } |
| 50 | 50 | return self::$logger[0]; |
@@ -53,24 +53,24 @@ discard block |
||
| 53 | 53 | /** |
| 54 | 54 | * Initialise the module list by scanning the directory MODULE_PATH |
| 55 | 55 | */ |
| 56 | - public function init(){ |
|
| 56 | + public function init() { |
|
| 57 | 57 | $logger = self::getLogger(); |
| 58 | 58 | $logger->debug('Check if the application contains the modules ...'); |
| 59 | 59 | $moduleDir = opendir(MODULE_PATH); |
| 60 | - if(is_resource($moduleDir)){ |
|
| 61 | - while(($module = readdir($moduleDir)) !== false){ |
|
| 62 | - if(preg_match('/^([a-z0-9-_]+)$/i', $module) && is_dir(MODULE_PATH . $module)){ |
|
| 60 | + if (is_resource($moduleDir)) { |
|
| 61 | + while (($module = readdir($moduleDir)) !== false) { |
|
| 62 | + if (preg_match('/^([a-z0-9-_]+)$/i', $module) && is_dir(MODULE_PATH . $module)) { |
|
| 63 | 63 | self::$list[] = $module; |
| 64 | 64 | } |
| 65 | - else{ |
|
| 66 | - $logger->info('Skipping [' .$module. '], may be this is not a directory or does not exists or is invalid name'); |
|
| 65 | + else { |
|
| 66 | + $logger->info('Skipping [' . $module . '], may be this is not a directory or does not exists or is invalid name'); |
|
| 67 | 67 | } |
| 68 | 68 | } |
| 69 | 69 | closedir($moduleDir); |
| 70 | 70 | } |
| 71 | 71 | ksort(self::$list); |
| 72 | 72 | |
| 73 | - if(self::hasModule()){ |
|
| 73 | + if (self::hasModule()) { |
|
| 74 | 74 | $logger->info('The application contains the module below [' . implode(', ', self::getModuleList()) . ']'); |
| 75 | 75 | } |
| 76 | 76 | } |
@@ -79,9 +79,9 @@ discard block |
||
| 79 | 79 | * Get the list of the custom autoload configuration from module if exists |
| 80 | 80 | * @return array|boolean the autoload configurations list or false if no module contains the autoload configuration values |
| 81 | 81 | */ |
| 82 | - public static function getModulesAutoloadConfig(){ |
|
| 82 | + public static function getModulesAutoloadConfig() { |
|
| 83 | 83 | $logger = self::getLogger(); |
| 84 | - if(! self::hasModule()){ |
|
| 84 | + if (!self::hasModule()) { |
|
| 85 | 85 | $logger->info('No module was loaded skipping.'); |
| 86 | 86 | return false; |
| 87 | 87 | } |
@@ -94,10 +94,10 @@ discard block |
||
| 94 | 94 | |
| 95 | 95 | foreach (self::$list as $module) { |
| 96 | 96 | $file = MODULE_PATH . $module . DS . 'config' . DS . 'autoload.php'; |
| 97 | - if(file_exists($file)){ |
|
| 97 | + if (file_exists($file)) { |
|
| 98 | 98 | $autoload = array(); |
| 99 | 99 | require_once $file; |
| 100 | - if(! empty($autoload) && is_array($autoload)){ |
|
| 100 | + if (!empty($autoload) && is_array($autoload)) { |
|
| 101 | 101 | $autoloads = array_merge_recursive($autoloads, $autoload); |
| 102 | 102 | unset($autoload); |
| 103 | 103 | } |
@@ -110,19 +110,19 @@ discard block |
||
| 110 | 110 | * Get the list of the custom routes configuration from module if exists |
| 111 | 111 | * @return array|boolean the routes list or false if no module contains the routes configuration |
| 112 | 112 | */ |
| 113 | - public static function getModulesRoutes(){ |
|
| 113 | + public static function getModulesRoutes() { |
|
| 114 | 114 | $logger = self::getLogger(); |
| 115 | - if(! self::hasModule()){ |
|
| 115 | + if (!self::hasModule()) { |
|
| 116 | 116 | $logger->info('No module was loaded skipping.'); |
| 117 | 117 | return false; |
| 118 | 118 | } |
| 119 | 119 | $routes = array(); |
| 120 | 120 | foreach (self::$list as $module) { |
| 121 | 121 | $file = MODULE_PATH . $module . DS . 'config' . DS . 'routes.php'; |
| 122 | - if(file_exists($file)){ |
|
| 122 | + if (file_exists($file)) { |
|
| 123 | 123 | $route = array(); |
| 124 | 124 | require_once $file; |
| 125 | - if(! empty($route) && is_array($route)){ |
|
| 125 | + if (!empty($route) && is_array($route)) { |
|
| 126 | 126 | $routes = array_merge($routes, $route); |
| 127 | 127 | unset($route); |
| 128 | 128 | } |
@@ -138,23 +138,23 @@ discard block |
||
| 138 | 138 | * @param string $module the module name |
| 139 | 139 | * @return boolean|string false or null if no module have this controller, path the full path of the controller |
| 140 | 140 | */ |
| 141 | - public static function findControllerFullPath($class, $module = null){ |
|
| 141 | + public static function findControllerFullPath($class, $module = null) { |
|
| 142 | 142 | $logger = self::getLogger(); |
| 143 | - if(! self::hasModule()){ |
|
| 143 | + if (!self::hasModule()) { |
|
| 144 | 144 | $logger->info('No module was loaded skiping.'); |
| 145 | 145 | return false; |
| 146 | 146 | } |
| 147 | 147 | $class = str_ireplace('.php', '', $class); |
| 148 | 148 | $class = ucfirst($class); |
| 149 | - $classFile = $class.'.php'; |
|
| 150 | - $logger->debug('Checking the controller [' . $class . '] in module [' .$module. '] ...'); |
|
| 149 | + $classFile = $class . '.php'; |
|
| 150 | + $logger->debug('Checking the controller [' . $class . '] in module [' . $module . '] ...'); |
|
| 151 | 151 | $filePath = MODULE_PATH . $module . DS . 'controllers' . DS . $classFile; |
| 152 | - if(file_exists($filePath)){ |
|
| 153 | - $logger->info('Found controller [' . $class . '] in module [' .$module. '], the file path is [' .$filePath. ']'); |
|
| 152 | + if (file_exists($filePath)) { |
|
| 153 | + $logger->info('Found controller [' . $class . '] in module [' . $module . '], the file path is [' . $filePath . ']'); |
|
| 154 | 154 | return $filePath; |
| 155 | 155 | } |
| 156 | - else{ |
|
| 157 | - $logger->info('Controller [' . $class . '] does not exist in the module [' .$module. ']'); |
|
| 156 | + else { |
|
| 157 | + $logger->info('Controller [' . $class . '] does not exist in the module [' . $module . ']'); |
|
| 158 | 158 | return false; |
| 159 | 159 | } |
| 160 | 160 | } |
@@ -165,23 +165,23 @@ discard block |
||
| 165 | 165 | * @param string $module the module name |
| 166 | 166 | * @return boolean|string false or null if no module have this model, return the full path of this model |
| 167 | 167 | */ |
| 168 | - public static function findModelFullPath($class, $module = null){ |
|
| 168 | + public static function findModelFullPath($class, $module = null) { |
|
| 169 | 169 | $logger = self::getLogger(); |
| 170 | - if(! self::hasModule()){ |
|
| 170 | + if (!self::hasModule()) { |
|
| 171 | 171 | $logger->info('No module was loaded skiping.'); |
| 172 | 172 | return false; |
| 173 | 173 | } |
| 174 | 174 | $class = str_ireplace('.php', '', $class); |
| 175 | 175 | $class = ucfirst($class); |
| 176 | - $classFile = $class.'.php'; |
|
| 177 | - $logger->debug('Checking model [' . $class . '] in module [' .$module. '] ...'); |
|
| 176 | + $classFile = $class . '.php'; |
|
| 177 | + $logger->debug('Checking model [' . $class . '] in module [' . $module . '] ...'); |
|
| 178 | 178 | $filePath = MODULE_PATH . $module . DS . 'models' . DS . $classFile; |
| 179 | - if(file_exists($filePath)){ |
|
| 180 | - $logger->info('Found model [' . $class . '] in module [' .$module. '], the file path is [' .$filePath. ']'); |
|
| 179 | + if (file_exists($filePath)) { |
|
| 180 | + $logger->info('Found model [' . $class . '] in module [' . $module . '], the file path is [' . $filePath . ']'); |
|
| 181 | 181 | return $filePath; |
| 182 | 182 | } |
| 183 | - else{ |
|
| 184 | - $logger->info('Model [' . $class . '] does not exist in the module [' .$module. ']'); |
|
| 183 | + else { |
|
| 184 | + $logger->info('Model [' . $class . '] does not exist in the module [' . $module . ']'); |
|
| 185 | 185 | return false; |
| 186 | 186 | } |
| 187 | 187 | } |
@@ -192,22 +192,22 @@ discard block |
||
| 192 | 192 | * @param string $module the module name |
| 193 | 193 | * @return boolean|string false or null if no module have this configuration, return the full path of this configuration |
| 194 | 194 | */ |
| 195 | - public static function findConfigFullPath($configuration, $module = null){ |
|
| 195 | + public static function findConfigFullPath($configuration, $module = null) { |
|
| 196 | 196 | $logger = self::getLogger(); |
| 197 | - if(! self::hasModule()){ |
|
| 197 | + if (!self::hasModule()) { |
|
| 198 | 198 | $logger->info('No module was loaded skiping.'); |
| 199 | 199 | return false; |
| 200 | 200 | } |
| 201 | 201 | $configuration = str_ireplace('.php', '', $configuration); |
| 202 | - $file = $configuration.'.php'; |
|
| 203 | - $logger->debug('Checking configuration [' . $configuration . '] in module [' .$module. '] ...'); |
|
| 202 | + $file = $configuration . '.php'; |
|
| 203 | + $logger->debug('Checking configuration [' . $configuration . '] in module [' . $module . '] ...'); |
|
| 204 | 204 | $filePath = MODULE_PATH . $module . DS . 'config' . DS . $file; |
| 205 | - if(file_exists($filePath)){ |
|
| 206 | - $logger->info('Found configuration [' . $configuration . '] in module [' .$module. '], the file path is [' .$filePath. ']'); |
|
| 205 | + if (file_exists($filePath)) { |
|
| 206 | + $logger->info('Found configuration [' . $configuration . '] in module [' . $module . '], the file path is [' . $filePath . ']'); |
|
| 207 | 207 | return $filePath; |
| 208 | 208 | } |
| 209 | - else{ |
|
| 210 | - $logger->info('Configuration [' . $configuration . '] does not exist in the module [' .$module. ']'); |
|
| 209 | + else { |
|
| 210 | + $logger->info('Configuration [' . $configuration . '] does not exist in the module [' . $module . ']'); |
|
| 211 | 211 | return false; |
| 212 | 212 | } |
| 213 | 213 | } |
@@ -218,23 +218,23 @@ discard block |
||
| 218 | 218 | * @param string $module the module name |
| 219 | 219 | * @return boolean|string false or null if no module have this helper, return the full path of this helper |
| 220 | 220 | */ |
| 221 | - public static function findFunctionFullPath($helper, $module = null){ |
|
| 221 | + public static function findFunctionFullPath($helper, $module = null) { |
|
| 222 | 222 | $logger = self::getLogger(); |
| 223 | - if(! self::hasModule()){ |
|
| 223 | + if (!self::hasModule()) { |
|
| 224 | 224 | $logger->info('No module was loaded skiping.'); |
| 225 | 225 | return false; |
| 226 | 226 | } |
| 227 | 227 | $helper = str_ireplace('.php', '', $helper); |
| 228 | 228 | $helper = str_ireplace('function_', '', $helper); |
| 229 | - $file = 'function_'.$helper.'.php'; |
|
| 230 | - $logger->debug('Checking helper [' . $helper . '] in module [' .$module. '] ...'); |
|
| 229 | + $file = 'function_' . $helper . '.php'; |
|
| 230 | + $logger->debug('Checking helper [' . $helper . '] in module [' . $module . '] ...'); |
|
| 231 | 231 | $filePath = MODULE_PATH . $module . DS . 'functions' . DS . $file; |
| 232 | - if(file_exists($filePath)){ |
|
| 233 | - $logger->info('Found helper [' . $helper . '] in module [' .$module. '], the file path is [' .$filePath. ']'); |
|
| 232 | + if (file_exists($filePath)) { |
|
| 233 | + $logger->info('Found helper [' . $helper . '] in module [' . $module . '], the file path is [' . $filePath . ']'); |
|
| 234 | 234 | return $filePath; |
| 235 | 235 | } |
| 236 | - else{ |
|
| 237 | - $logger->info('Helper [' . $helper . '] does not exist in the module [' .$module. ']'); |
|
| 236 | + else { |
|
| 237 | + $logger->info('Helper [' . $helper . '] does not exist in the module [' . $module . ']'); |
|
| 238 | 238 | return false; |
| 239 | 239 | } |
| 240 | 240 | } |
@@ -246,22 +246,22 @@ discard block |
||
| 246 | 246 | * @param string $module the module name |
| 247 | 247 | * @return boolean|string false or null if no module have this library, return the full path of this library |
| 248 | 248 | */ |
| 249 | - public static function findLibraryFullPath($class, $module = null){ |
|
| 249 | + public static function findLibraryFullPath($class, $module = null) { |
|
| 250 | 250 | $logger = self::getLogger(); |
| 251 | - if(! self::hasModule()){ |
|
| 251 | + if (!self::hasModule()) { |
|
| 252 | 252 | $logger->info('No module was loaded skiping.'); |
| 253 | 253 | return false; |
| 254 | 254 | } |
| 255 | 255 | $class = str_ireplace('.php', '', $class); |
| 256 | - $file = $class.'.php'; |
|
| 257 | - $logger->debug('Checking library [' . $class . '] in module [' .$module. '] ...'); |
|
| 256 | + $file = $class . '.php'; |
|
| 257 | + $logger->debug('Checking library [' . $class . '] in module [' . $module . '] ...'); |
|
| 258 | 258 | $filePath = MODULE_PATH . $module . DS . 'libraries' . DS . $file; |
| 259 | - if(file_exists($filePath)){ |
|
| 260 | - $logger->info('Found library [' . $class . '] in module [' .$module. '], the file path is [' .$filePath. ']'); |
|
| 259 | + if (file_exists($filePath)) { |
|
| 260 | + $logger->info('Found library [' . $class . '] in module [' . $module . '], the file path is [' . $filePath . ']'); |
|
| 261 | 261 | return $filePath; |
| 262 | 262 | } |
| 263 | - else{ |
|
| 264 | - $logger->info('Library [' . $class . '] does not exist in the module [' .$module. ']'); |
|
| 263 | + else { |
|
| 264 | + $logger->info('Library [' . $class . '] does not exist in the module [' . $module . ']'); |
|
| 265 | 265 | return false; |
| 266 | 266 | } |
| 267 | 267 | } |
@@ -273,9 +273,9 @@ discard block |
||
| 273 | 273 | * @param string $module the module name to check |
| 274 | 274 | * @return boolean|string false or null if no module have this view, path the full path of the view |
| 275 | 275 | */ |
| 276 | - public static function findViewFullPath($view, $module = null){ |
|
| 276 | + public static function findViewFullPath($view, $module = null) { |
|
| 277 | 277 | $logger = self::getLogger(); |
| 278 | - if(! self::hasModule()){ |
|
| 278 | + if (!self::hasModule()) { |
|
| 279 | 279 | $logger->info('No module was loaded skiping.'); |
| 280 | 280 | return false; |
| 281 | 281 | } |
@@ -283,14 +283,14 @@ discard block |
||
| 283 | 283 | $view = trim($view, '/\\'); |
| 284 | 284 | $view = str_ireplace('/', DS, $view); |
| 285 | 285 | $viewFile = $view . '.php'; |
| 286 | - $logger->debug('Checking view [' . $view . '] in module [' .$module. '] ...'); |
|
| 286 | + $logger->debug('Checking view [' . $view . '] in module [' . $module . '] ...'); |
|
| 287 | 287 | $filePath = MODULE_PATH . $module . DS . 'views' . DS . $viewFile; |
| 288 | - if(file_exists($filePath)){ |
|
| 289 | - $logger->info('Found view [' . $view . '] in module [' .$module. '], the file path is [' .$filePath. ']'); |
|
| 288 | + if (file_exists($filePath)) { |
|
| 289 | + $logger->info('Found view [' . $view . '] in module [' . $module . '], the file path is [' . $filePath . ']'); |
|
| 290 | 290 | return $filePath; |
| 291 | 291 | } |
| 292 | - else{ |
|
| 293 | - $logger->info('View [' . $view . '] does not exist in the module [' .$module. ']'); |
|
| 292 | + else { |
|
| 293 | + $logger->info('View [' . $view . '] does not exist in the module [' . $module . ']'); |
|
| 294 | 294 | return false; |
| 295 | 295 | } |
| 296 | 296 | } |
@@ -302,23 +302,23 @@ discard block |
||
| 302 | 302 | * @param string $appLang the application language like 'en', 'fr' |
| 303 | 303 | * @return boolean|string false or null if no module have this language, return the full path of this language |
| 304 | 304 | */ |
| 305 | - public static function findLanguageFullPath($language, $module = null, $appLang){ |
|
| 305 | + public static function findLanguageFullPath($language, $module = null, $appLang) { |
|
| 306 | 306 | $logger = self::getLogger(); |
| 307 | - if(! self::hasModule()){ |
|
| 307 | + if (!self::hasModule()) { |
|
| 308 | 308 | $logger->info('No module was loaded skiping.'); |
| 309 | 309 | return false; |
| 310 | 310 | } |
| 311 | 311 | $language = str_ireplace('.php', '', $language); |
| 312 | 312 | $language = str_ireplace('lang_', '', $language); |
| 313 | - $file = 'lang_'.$language.'.php'; |
|
| 314 | - $logger->debug('Checking language [' . $language . '] in module [' .$module. '] ...'); |
|
| 313 | + $file = 'lang_' . $language . '.php'; |
|
| 314 | + $logger->debug('Checking language [' . $language . '] in module [' . $module . '] ...'); |
|
| 315 | 315 | $filePath = MODULE_PATH . $module . DS . 'lang' . DS . $appLang . DS . $file; |
| 316 | - if(file_exists($filePath)){ |
|
| 317 | - $logger->info('Found language [' . $language . '] in module [' .$module. '], the file path is [' .$filePath. ']'); |
|
| 316 | + if (file_exists($filePath)) { |
|
| 317 | + $logger->info('Found language [' . $language . '] in module [' . $module . '], the file path is [' . $filePath . ']'); |
|
| 318 | 318 | return $filePath; |
| 319 | 319 | } |
| 320 | - else{ |
|
| 321 | - $logger->info('Language [' . $language . '] does not exist in the module [' .$module. ']'); |
|
| 320 | + else { |
|
| 321 | + $logger->info('Language [' . $language . '] does not exist in the module [' . $module . ']'); |
|
| 322 | 322 | return false; |
| 323 | 323 | } |
| 324 | 324 | } |
@@ -327,7 +327,7 @@ discard block |
||
| 327 | 327 | * Get the list of module loaded |
| 328 | 328 | * @return array the module list |
| 329 | 329 | */ |
| 330 | - public static function getModuleList(){ |
|
| 330 | + public static function getModuleList() { |
|
| 331 | 331 | return self::$list; |
| 332 | 332 | } |
| 333 | 333 | |
@@ -335,7 +335,7 @@ discard block |
||
| 335 | 335 | * Check if the application has an module |
| 336 | 336 | * @return boolean |
| 337 | 337 | */ |
| 338 | - public static function hasModule(){ |
|
| 338 | + public static function hasModule() { |
|
| 339 | 339 | return !empty(self::$list); |
| 340 | 340 | } |
| 341 | 341 | |
@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
| 25 | 25 | */ |
| 26 | 26 | |
| 27 | - class Pagination{ |
|
| 27 | + class Pagination { |
|
| 28 | 28 | |
| 29 | 29 | /** |
| 30 | 30 | * The list of loaded config |
@@ -36,15 +36,15 @@ discard block |
||
| 36 | 36 | * Create an instance of pagination |
| 37 | 37 | * @param array $overwriteConfig the list of configuration to overwrite the defined configuration in config_pagination.php |
| 38 | 38 | */ |
| 39 | - public function __construct($overwriteConfig = array()){ |
|
| 40 | - if(file_exists(CONFIG_PATH . 'config_pagination.php')){ |
|
| 39 | + public function __construct($overwriteConfig = array()) { |
|
| 40 | + if (file_exists(CONFIG_PATH . 'config_pagination.php')) { |
|
| 41 | 41 | $config = array(); |
| 42 | 42 | require_once CONFIG_PATH . 'config_pagination.php'; |
| 43 | - if(empty($config) || ! is_array($config)){ |
|
| 43 | + if (empty($config) || !is_array($config)) { |
|
| 44 | 44 | show_error('No configuration found in ' . CONFIG_PATH . 'config_pagination.php'); |
| 45 | 45 | } |
| 46 | - else{ |
|
| 47 | - if(! empty($overwriteConfig)){ |
|
| 46 | + else { |
|
| 47 | + if (!empty($overwriteConfig)) { |
|
| 48 | 48 | $config = array_merge($config, $overwriteConfig); |
| 49 | 49 | } |
| 50 | 50 | $this->config = $config; |
@@ -53,7 +53,7 @@ discard block |
||
| 53 | 53 | unset($config); |
| 54 | 54 | } |
| 55 | 55 | } |
| 56 | - else{ |
|
| 56 | + else { |
|
| 57 | 57 | show_error('Unable to find the pagination configuration file'); |
| 58 | 58 | } |
| 59 | 59 | } |
@@ -64,8 +64,8 @@ discard block |
||
| 64 | 64 | * config_pagination.php |
| 65 | 65 | * @param array $config the configuration to set |
| 66 | 66 | */ |
| 67 | - public function setConfig(array $config = array()){ |
|
| 68 | - if(! empty($config)){ |
|
| 67 | + public function setConfig(array $config = array()) { |
|
| 68 | + if (!empty($config)) { |
|
| 69 | 69 | $this->config = array_merge($this->config, $config); |
| 70 | 70 | Config::setAll($config); |
| 71 | 71 | } |
@@ -77,26 +77,26 @@ discard block |
||
| 77 | 77 | * @param int $currentPageNumber the current page number |
| 78 | 78 | * @return string the pagination link |
| 79 | 79 | */ |
| 80 | - public function getLink($totalRows, $currentPageNumber){ |
|
| 80 | + public function getLink($totalRows, $currentPageNumber) { |
|
| 81 | 81 | $pageQueryName = $this->config['page_query_string_name']; |
| 82 | 82 | $numberOfLink = $this->config['nb_link']; |
| 83 | 83 | $numberOfRowPerPage = $this->config['pagination_per_page']; |
| 84 | 84 | $queryString = Url::queryString(); |
| 85 | 85 | $currentUrl = Url::current(); |
| 86 | - if($queryString == ''){ |
|
| 86 | + if ($queryString == '') { |
|
| 87 | 87 | $query = '?' . $pageQueryName . '='; |
| 88 | 88 | } |
| 89 | - else{ |
|
| 89 | + else { |
|
| 90 | 90 | $tab = explode($pageQueryName . '=', $queryString); |
| 91 | 91 | $nb = count($tab); |
| 92 | - if($nb == 1){ |
|
| 92 | + if ($nb == 1) { |
|
| 93 | 93 | $query = '?' . $queryString . '&' . $pageQueryName . '='; |
| 94 | 94 | } |
| 95 | - else{ |
|
| 96 | - if($tab[0] == ''){ |
|
| 95 | + else { |
|
| 96 | + if ($tab[0] == '') { |
|
| 97 | 97 | $query = '?' . $pageQueryName . '='; |
| 98 | 98 | } |
| 99 | - else{ |
|
| 99 | + else { |
|
| 100 | 100 | $query = '?' . $tab[0] . '' . $pageQueryName . '='; |
| 101 | 101 | } |
| 102 | 102 | } |
@@ -106,67 +106,67 @@ discard block |
||
| 106 | 106 | $navbar = ''; |
| 107 | 107 | $numberOfPage = ceil($totalRows / $numberOfRowPerPage); |
| 108 | 108 | $currentPageNumber = (int) $currentPageNumber; |
| 109 | - if($currentPageNumber <= 0){ |
|
| 109 | + if ($currentPageNumber <= 0) { |
|
| 110 | 110 | $currentPageNumber = 1; |
| 111 | 111 | } |
| 112 | - if($numberOfPage <= 1 || $numberOfLink <= 0 || $numberOfRowPerPage <= 0 || !is_numeric($numberOfLink) || !is_numeric($numberOfRowPerPage) |
|
| 113 | - ){ |
|
| 112 | + if ($numberOfPage <= 1 || $numberOfLink <= 0 || $numberOfRowPerPage <= 0 || !is_numeric($numberOfLink) || !is_numeric($numberOfRowPerPage) |
|
| 113 | + ) { |
|
| 114 | 114 | return $navbar; |
| 115 | 115 | } |
| 116 | - if($numberOfLink % 2 == 0){ |
|
| 116 | + if ($numberOfLink % 2 == 0) { |
|
| 117 | 117 | $start = $currentPageNumber - ($numberOfLink / 2) + 1; |
| 118 | 118 | $end = $currentPageNumber + ($numberOfLink / 2); |
| 119 | 119 | } |
| 120 | - else{ |
|
| 120 | + else { |
|
| 121 | 121 | $start = $currentPageNumber - floor($numberOfLink / 2); |
| 122 | 122 | $end = $currentPageNumber + floor($numberOfLink / 2); |
| 123 | 123 | } |
| 124 | - if($start <= 1){ |
|
| 124 | + if ($start <= 1) { |
|
| 125 | 125 | $begin = 1; |
| 126 | 126 | $end = $numberOfLink; |
| 127 | 127 | } |
| 128 | - else if($start > 1 && $end < $numberOfPage){ |
|
| 128 | + else if ($start > 1 && $end < $numberOfPage) { |
|
| 129 | 129 | $begin = $start; |
| 130 | 130 | $end = $end; |
| 131 | 131 | } |
| 132 | - else{ |
|
| 132 | + else { |
|
| 133 | 133 | $begin = ($numberOfPage - $numberOfLink) + 1; |
| 134 | 134 | $end = $numberOfPage; |
| 135 | 135 | } |
| 136 | - if($numberOfPage <= $numberOfLink){ |
|
| 136 | + if ($numberOfPage <= $numberOfLink) { |
|
| 137 | 137 | $begin = 1; |
| 138 | 138 | $end = $numberOfPage; |
| 139 | 139 | } |
| 140 | - if($currentPageNumber == 1){ |
|
| 141 | - for($i = $begin; $i <= $end; $i++){ |
|
| 142 | - if($i == $currentPageNumber){ |
|
| 140 | + if ($currentPageNumber == 1) { |
|
| 141 | + for ($i = $begin; $i <= $end; $i++) { |
|
| 142 | + if ($i == $currentPageNumber) { |
|
| 143 | 143 | $navbar .= $this->config['active_link_open'] . $currentPageNumber . $this->config['active_link_close']; |
| 144 | 144 | } |
| 145 | - else{ |
|
| 145 | + else { |
|
| 146 | 146 | $navbar .= $this->config['digit_open'] . '<a href="' . $query . $i . '" ' . attributes_to_string($this->config['attributes']) . '>' . $i . '</a>' . $this->config['digit_close']; |
| 147 | 147 | } |
| 148 | 148 | } |
| 149 | 149 | $navbar .= $this->config['next_open'] . '<a href="' . $query . ($currentPageNumber + 1) . '">' . $this->config['next_text'] . '</a>' . $this->config['next_close']; |
| 150 | 150 | } |
| 151 | - else if($currentPageNumber > 1 && $currentPageNumber < $numberOfPage){ |
|
| 151 | + else if ($currentPageNumber > 1 && $currentPageNumber < $numberOfPage) { |
|
| 152 | 152 | $navbar .= $this->config['previous_open'] . '<a href="' . $query . ($currentPageNumber - 1) . '">' . $this->config['previous_text'] . '</a>' . $this->config['previous_close']; |
| 153 | - for($i = $begin; $i <= $end; $i++){ |
|
| 154 | - if($i == $currentPageNumber){ |
|
| 153 | + for ($i = $begin; $i <= $end; $i++) { |
|
| 154 | + if ($i == $currentPageNumber) { |
|
| 155 | 155 | $navbar .= $this->config['active_link_open'] . $currentPageNumber . $this->config['active_link_close']; |
| 156 | 156 | } |
| 157 | - else{ |
|
| 158 | - $navbar .= $this->config['digit_open'] . '<a href="' . $query . $i . '"' . attributes_to_string($this->config['attributes']) . '>' . $i .'</a>' . $this->config['digit_close']; |
|
| 157 | + else { |
|
| 158 | + $navbar .= $this->config['digit_open'] . '<a href="' . $query . $i . '"' . attributes_to_string($this->config['attributes']) . '>' . $i . '</a>' . $this->config['digit_close']; |
|
| 159 | 159 | } |
| 160 | 160 | } |
| 161 | - $navbar .= $this->config['next_open']."<a href='$query".($currentPageNumber + 1)."'>".$this->config['next_text']."</a>".$this->config['next_close']; |
|
| 161 | + $navbar .= $this->config['next_open'] . "<a href='$query" . ($currentPageNumber + 1) . "'>" . $this->config['next_text'] . "</a>" . $this->config['next_close']; |
|
| 162 | 162 | } |
| 163 | - else if($currentPageNumber == $numberOfPage){ |
|
| 163 | + else if ($currentPageNumber == $numberOfPage) { |
|
| 164 | 164 | $navbar .= $this->config['previous_open'] . '<a href="' . $query . ($currentPageNumber - 1) . '">' . $this->config['previous_text'] . '</a>' . $this->config['previous_close']; |
| 165 | - for($i = $begin; $i <= $end; $i++){ |
|
| 166 | - if($i == $currentPageNumber){ |
|
| 165 | + for ($i = $begin; $i <= $end; $i++) { |
|
| 166 | + if ($i == $currentPageNumber) { |
|
| 167 | 167 | $navbar .= $this->config['active_link_open'] . $currentPageNumber . $this->config['active_link_close']; |
| 168 | 168 | } |
| 169 | - else{ |
|
| 169 | + else { |
|
| 170 | 170 | $navbar .= $this->config['digit_open'] . '<a href="' . $query . $i . '"' . attributes_to_string($this->config['attributes']) . '>' . $i . '</a>' . $this->config['digit_close']; |
| 171 | 171 | } |
| 172 | 172 | } |
@@ -25,13 +25,13 @@ discard block |
||
| 25 | 25 | */ |
| 26 | 26 | |
| 27 | 27 | |
| 28 | - class FormValidation{ |
|
| 28 | + class FormValidation { |
|
| 29 | 29 | |
| 30 | 30 | /** |
| 31 | 31 | * The form validation status |
| 32 | 32 | * @var boolean |
| 33 | 33 | */ |
| 34 | - protected $_success = false; |
|
| 34 | + protected $_success = false; |
|
| 35 | 35 | |
| 36 | 36 | /** |
| 37 | 37 | * The list of errors messages |
@@ -40,31 +40,31 @@ discard block |
||
| 40 | 40 | protected $_errorsMessages = array(); |
| 41 | 41 | |
| 42 | 42 | // Array of rule sets, fieldName => PIPE seperated ruleString |
| 43 | - protected $_rules = array(); |
|
| 43 | + protected $_rules = array(); |
|
| 44 | 44 | |
| 45 | 45 | // Array of errors, niceName => Error Message |
| 46 | - protected $_errors = array(); |
|
| 46 | + protected $_errors = array(); |
|
| 47 | 47 | |
| 48 | 48 | // Array of post Key => Nice name labels |
| 49 | - protected $_labels = array(); |
|
| 49 | + protected $_labels = array(); |
|
| 50 | 50 | |
| 51 | 51 | /** |
| 52 | 52 | * The errors delimiters |
| 53 | 53 | * @var array |
| 54 | 54 | */ |
| 55 | - protected $_allErrorsDelimiter = array('<div class="error">', '</div>'); |
|
| 55 | + protected $_allErrorsDelimiter = array('<div class="error">', '</div>'); |
|
| 56 | 56 | |
| 57 | 57 | /** |
| 58 | 58 | * The each error delimiter |
| 59 | 59 | * @var array |
| 60 | 60 | */ |
| 61 | - protected $_eachErrorDelimiter = array('<p class="error">', '</p>'); |
|
| 61 | + protected $_eachErrorDelimiter = array('<p class="error">', '</p>'); |
|
| 62 | 62 | |
| 63 | 63 | /** |
| 64 | 64 | * Indicated if need force the validation to be failed |
| 65 | 65 | * @var boolean |
| 66 | 66 | */ |
| 67 | - protected $_forceFail = false; |
|
| 67 | + protected $_forceFail = false; |
|
| 68 | 68 | |
| 69 | 69 | /** |
| 70 | 70 | * The list of the error messages overrides by the original |
@@ -98,13 +98,13 @@ discard block |
||
| 98 | 98 | * @return void |
| 99 | 99 | */ |
| 100 | 100 | public function __construct() { |
| 101 | - $this->logger =& class_loader('Log', 'classes'); |
|
| 101 | + $this->logger = & class_loader('Log', 'classes'); |
|
| 102 | 102 | $this->logger->setLogger('Library::FormValidation'); |
| 103 | 103 | |
| 104 | 104 | //Load form validation language message |
| 105 | 105 | Loader::lang('form_validation'); |
| 106 | 106 | $obj = & get_instance(); |
| 107 | - $this->_errorsMessages = array( |
|
| 107 | + $this->_errorsMessages = array( |
|
| 108 | 108 | 'required' => $obj->lang->get('fv_required'), |
| 109 | 109 | 'min_length' => $obj->lang->get('fv_min_length'), |
| 110 | 110 | 'max_length' => $obj->lang->get('fv_max_length'), |
@@ -141,7 +141,7 @@ discard block |
||
| 141 | 141 | $this->_success = false; |
| 142 | 142 | $this->_forceFail = false; |
| 143 | 143 | $this->data = array(); |
| 144 | - $this->enableCsrfCheck = false; |
|
| 144 | + $this->enableCsrfCheck = false; |
|
| 145 | 145 | } |
| 146 | 146 | |
| 147 | 147 | /** |
@@ -150,7 +150,7 @@ discard block |
||
| 150 | 150 | * |
| 151 | 151 | * @return FormValidation Current instance of object. |
| 152 | 152 | */ |
| 153 | - public function setData(array $data){ |
|
| 153 | + public function setData(array $data) { |
|
| 154 | 154 | $this->logger->debug('Setting the form validation data, the values are: ' . stringfy_vars($data)); |
| 155 | 155 | $this->data = $data; |
| 156 | 156 | return $this; |
@@ -160,7 +160,7 @@ discard block |
||
| 160 | 160 | * Get the form validation data |
| 161 | 161 | * @return array the form validation data to be validated |
| 162 | 162 | */ |
| 163 | - public function getData(){ |
|
| 163 | + public function getData() { |
|
| 164 | 164 | return $this->data; |
| 165 | 165 | } |
| 166 | 166 | |
@@ -169,7 +169,7 @@ discard block |
||
| 169 | 169 | * |
| 170 | 170 | * @return string the function name |
| 171 | 171 | */ |
| 172 | - protected function _toCallCase($funcName, $prefix='_validate') { |
|
| 172 | + protected function _toCallCase($funcName, $prefix = '_validate') { |
|
| 173 | 173 | $funcName = strtolower($funcName); |
| 174 | 174 | $finalFuncName = $prefix; |
| 175 | 175 | foreach (explode('_', $funcName) as $funcNamePart) { |
@@ -193,7 +193,7 @@ discard block |
||
| 193 | 193 | * @return boolean Whether or not the form has been submitted or the data is available for validation. |
| 194 | 194 | */ |
| 195 | 195 | public function canDoValidation() { |
| 196 | - return get_instance()->request->method() === 'POST' || ! empty($this->data); |
|
| 196 | + return get_instance()->request->method() === 'POST' || !empty($this->data); |
|
| 197 | 197 | } |
| 198 | 198 | |
| 199 | 199 | /** |
@@ -213,14 +213,14 @@ discard block |
||
| 213 | 213 | * Validate the CSRF |
| 214 | 214 | * @return void |
| 215 | 215 | */ |
| 216 | - protected function validateCSRF(){ |
|
| 217 | - if(get_instance()->request->method() == 'POST' || $this->enableCsrfCheck){ |
|
| 216 | + protected function validateCSRF() { |
|
| 217 | + if (get_instance()->request->method() == 'POST' || $this->enableCsrfCheck) { |
|
| 218 | 218 | $this->logger->debug('Check if CSRF is enabled in configuration'); |
| 219 | 219 | //first check for CSRF |
| 220 | - if ((get_config('csrf_enable', false) || $this->enableCsrfCheck) && ! Security::validateCSRF()){ |
|
| 220 | + if ((get_config('csrf_enable', false) || $this->enableCsrfCheck) && !Security::validateCSRF()) { |
|
| 221 | 221 | show_error('Invalide data, Cross Site Request Forgery do his job, the data to validate is corrupted.'); |
| 222 | 222 | } |
| 223 | - else{ |
|
| 223 | + else { |
|
| 224 | 224 | $this->logger->info('CSRF is not enabled in configuration or not set manully, no need to check it'); |
| 225 | 225 | } |
| 226 | 226 | } |
@@ -237,10 +237,10 @@ discard block |
||
| 237 | 237 | $this->_forceFail = false; |
| 238 | 238 | |
| 239 | 239 | foreach ($this->getData() as $inputName => $inputVal) { |
| 240 | - if(is_array($this->data[$inputName])){ |
|
| 240 | + if (is_array($this->data[$inputName])) { |
|
| 241 | 241 | $this->data[$inputName] = array_map('trim', $this->data[$inputName]); |
| 242 | 242 | } |
| 243 | - else{ |
|
| 243 | + else { |
|
| 244 | 244 | $this->data[$inputName] = trim($this->data[$inputName]); |
| 245 | 245 | } |
| 246 | 246 | |
@@ -267,7 +267,7 @@ discard block |
||
| 267 | 267 | public function setRule($inputField, $inputLabel, $ruleSets) { |
| 268 | 268 | $this->_rules[$inputField] = $ruleSets; |
| 269 | 269 | $this->_labels[$inputField] = $inputLabel; |
| 270 | - $this->logger->info('Set the field rule: name [' .$inputField. '], label [' .$inputLabel. '], rules [' .$ruleSets. ']'); |
|
| 270 | + $this->logger->info('Set the field rule: name [' . $inputField . '], label [' . $inputLabel . '], rules [' . $ruleSets . ']'); |
|
| 271 | 271 | return $this; |
| 272 | 272 | } |
| 273 | 273 | |
@@ -431,7 +431,7 @@ discard block |
||
| 431 | 431 | } |
| 432 | 432 | $errorOutput .= $errorsEnd; |
| 433 | 433 | echo ($echo) ? $errorOutput : ''; |
| 434 | - return (! $echo) ? $errorOutput : null; |
|
| 434 | + return (!$echo) ? $errorOutput : null; |
|
| 435 | 435 | } |
| 436 | 436 | |
| 437 | 437 | /** |
@@ -456,25 +456,25 @@ discard block |
||
| 456 | 456 | /* |
| 457 | 457 | //////////////// hack for regex rule that can contain "|" |
| 458 | 458 | */ |
| 459 | - if(strpos($ruleString, 'regex') !== false){ |
|
| 459 | + if (strpos($ruleString, 'regex') !== false) { |
|
| 460 | 460 | $regexRule = array(); |
| 461 | 461 | $rule = '#regex\[\/(.*)\/([a-zA-Z0-9]?)\]#'; |
| 462 | 462 | preg_match($rule, $ruleString, $regexRule); |
| 463 | 463 | $ruleStringTemp = preg_replace($rule, '', $ruleString); |
| 464 | - if(!empty($regexRule[0])){ |
|
| 464 | + if (!empty($regexRule[0])) { |
|
| 465 | 465 | $ruleSets[] = $regexRule[0]; |
| 466 | 466 | } |
| 467 | 467 | $ruleStringRegex = explode('|', $ruleStringTemp); |
| 468 | 468 | foreach ($ruleStringRegex as $rule) { |
| 469 | 469 | $rule = trim($rule); |
| 470 | - if($rule){ |
|
| 470 | + if ($rule) { |
|
| 471 | 471 | $ruleSets[] = $rule; |
| 472 | 472 | } |
| 473 | 473 | } |
| 474 | 474 | |
| 475 | 475 | } |
| 476 | 476 | /***********************************/ |
| 477 | - else{ |
|
| 477 | + else { |
|
| 478 | 478 | if (strpos($ruleString, '|') !== FALSE) { |
| 479 | 479 | $ruleSets = explode('|', $ruleString); |
| 480 | 480 | } else { |
@@ -506,7 +506,7 @@ discard block |
||
| 506 | 506 | * @return void |
| 507 | 507 | */ |
| 508 | 508 | protected function _validateRule($inputName, $inputVal, $ruleName) { |
| 509 | - $this->logger->debug('Rule validation of field [' .$inputName. '], value [' .$inputVal. '], rule [' .$ruleName. ']'); |
|
| 509 | + $this->logger->debug('Rule validation of field [' . $inputName . '], value [' . $inputVal . '], rule [' . $ruleName . ']'); |
|
| 510 | 510 | // Array to store args |
| 511 | 511 | $ruleArgs = array(); |
| 512 | 512 | |
@@ -551,7 +551,7 @@ discard block |
||
| 551 | 551 | $key = $i - 1; |
| 552 | 552 | $rulePhrase = str_replace('%' . $i, $replacements[$key], $rulePhrase); |
| 553 | 553 | } |
| 554 | - if (! array_key_exists($inputName, $this->_errors)) { |
|
| 554 | + if (!array_key_exists($inputName, $this->_errors)) { |
|
| 555 | 555 | $this->_errors[$inputName] = $rulePhrase; |
| 556 | 556 | } |
| 557 | 557 | } |
@@ -603,13 +603,13 @@ discard block |
||
| 603 | 603 | */ |
| 604 | 604 | protected function _validateRequired($inputName, $ruleName, array $ruleArgs) { |
| 605 | 605 | $inputVal = $this->post($inputName); |
| 606 | - if(array_key_exists(1, $ruleArgs) && function_exists($ruleArgs[1])) { |
|
| 606 | + if (array_key_exists(1, $ruleArgs) && function_exists($ruleArgs[1])) { |
|
| 607 | 607 | $callbackReturn = $this->_runEmptyCallback($ruleArgs[1]); |
| 608 | 608 | if ($inputVal == '' && $callbackReturn == true) { |
| 609 | 609 | $this->_setError($inputName, $ruleName, $this->_getLabel($inputName)); |
| 610 | 610 | } |
| 611 | 611 | } |
| 612 | - else if($inputVal == '') { |
|
| 612 | + else if ($inputVal == '') { |
|
| 613 | 613 | $this->_setError($inputName, $ruleName, $this->_getLabel($inputName)); |
| 614 | 614 | } |
| 615 | 615 | } |
@@ -635,7 +635,7 @@ discard block |
||
| 635 | 635 | protected function _validateCallback($inputName, $ruleName, array $ruleArgs) { |
| 636 | 636 | if (function_exists($ruleArgs[1]) && !empty($this->data[$inputName])) { |
| 637 | 637 | $result = $this->_runCallback($this->data[$inputName], $ruleArgs[1]); |
| 638 | - if(! $result){ |
|
| 638 | + if (!$result) { |
|
| 639 | 639 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName))); |
| 640 | 640 | } |
| 641 | 641 | } |
@@ -669,7 +669,7 @@ discard block |
||
| 669 | 669 | continue; |
| 670 | 670 | } |
| 671 | 671 | } |
| 672 | - else{ |
|
| 672 | + else { |
|
| 673 | 673 | if ($inputVal == $doNotEqual) { |
| 674 | 674 | $this->_setError($inputName, $ruleName . ',string', array($this->_getLabel($inputName), $doNotEqual)); |
| 675 | 675 | continue; |
@@ -699,8 +699,8 @@ discard block |
||
| 699 | 699 | */ |
| 700 | 700 | protected function _validateValidEmail($inputName, $ruleName, array $ruleArgs) { |
| 701 | 701 | $inputVal = $this->post($inputName); |
| 702 | - if (! preg_match("/^([\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+\.)*[\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+@((((([a-z0-9]{1}[a-z0-9\-]{0,62}[a-z0-9]{1})|[a-z])\.)+[a-z]{2,6})|(\d{1,3}\.){3}\d{1,3}(\:\d{1,5})?)$/i", $inputVal)) { |
|
| 703 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 702 | + if (!preg_match("/^([\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+\.)*[\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+@((((([a-z0-9]{1}[a-z0-9\-]{0,62}[a-z0-9]{1})|[a-z])\.)+[a-z]{2,6})|(\d{1,3}\.){3}\d{1,3}(\:\d{1,5})?)$/i", $inputVal)) { |
|
| 703 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 704 | 704 | return; |
| 705 | 705 | } |
| 706 | 706 | $this->_setError($inputName, $ruleName, $this->_getLabel($inputName)); |
@@ -716,7 +716,7 @@ discard block |
||
| 716 | 716 | protected function _validateExactLength($inputName, $ruleName, array $ruleArgs) { |
| 717 | 717 | $inputVal = $this->post($inputName); |
| 718 | 718 | if (strlen($inputVal) != $ruleArgs[1]) { // $ruleArgs[0] is [length] $rulesArgs[1] is just length |
| 719 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 719 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 720 | 720 | return; |
| 721 | 721 | } |
| 722 | 722 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName), $this->_getLabel($ruleArgs[1]))); |
@@ -732,7 +732,7 @@ discard block |
||
| 732 | 732 | protected function _validateMaxLength($inputName, $ruleName, array $ruleArgs) { |
| 733 | 733 | $inputVal = $this->post($inputName); |
| 734 | 734 | if (strlen($inputVal) > $ruleArgs[1]) { // $ruleArgs[0] is [length] $rulesArgs[1] is just length |
| 735 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 735 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 736 | 736 | return; |
| 737 | 737 | } |
| 738 | 738 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName), $this->_getLabel($ruleArgs[1]))); |
@@ -748,7 +748,7 @@ discard block |
||
| 748 | 748 | protected function _validateMinLength($inputName, $ruleName, array $ruleArgs) { |
| 749 | 749 | $inputVal = $this->post($inputName); |
| 750 | 750 | if (strlen($inputVal) < $ruleArgs[1]) { // $ruleArgs[0] is [length] $rulesArgs[1] is just length |
| 751 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 751 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 752 | 752 | return; |
| 753 | 753 | } |
| 754 | 754 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName), $this->_getLabel($ruleArgs[1]))); |
@@ -764,7 +764,7 @@ discard block |
||
| 764 | 764 | protected function _validateLessThan($inputName, $ruleName, array $ruleArgs) { |
| 765 | 765 | $inputVal = $this->post($inputName); |
| 766 | 766 | if ($inputVal >= $ruleArgs[1]) { |
| 767 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 767 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 768 | 768 | return; |
| 769 | 769 | } |
| 770 | 770 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName), $this->_getLabel($ruleArgs[1]))); |
@@ -780,7 +780,7 @@ discard block |
||
| 780 | 780 | protected function _validateGreaterThan($inputName, $ruleName, array $ruleArgs) { |
| 781 | 781 | $inputVal = $this->post($inputName); |
| 782 | 782 | if ($inputVal <= $ruleArgs[1]) { |
| 783 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 783 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 784 | 784 | return; |
| 785 | 785 | } |
| 786 | 786 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName), $this->_getLabel($ruleArgs[1]))); |
@@ -795,8 +795,8 @@ discard block |
||
| 795 | 795 | */ |
| 796 | 796 | protected function _validateNumeric($inputName, $ruleName, array $ruleArgs) { |
| 797 | 797 | $inputVal = $this->post($inputName); |
| 798 | - if (! is_numeric($inputVal)) { |
|
| 799 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 798 | + if (!is_numeric($inputVal)) { |
|
| 799 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 800 | 800 | return; |
| 801 | 801 | } |
| 802 | 802 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName))); |
@@ -812,7 +812,7 @@ discard block |
||
| 812 | 812 | protected function _validateExists($inputName, $ruleName, array $ruleArgs) { |
| 813 | 813 | $inputVal = $this->post($inputName); |
| 814 | 814 | $obj = & get_instance(); |
| 815 | - if(! isset($obj->database)){ |
|
| 815 | + if (!isset($obj->database)) { |
|
| 816 | 816 | return; |
| 817 | 817 | } |
| 818 | 818 | list($table, $column) = explode('.', $ruleArgs[1]); |
@@ -821,7 +821,7 @@ discard block |
||
| 821 | 821 | ->get(); |
| 822 | 822 | $nb = $obj->database->numRows(); |
| 823 | 823 | if ($nb == 0) { |
| 824 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 824 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 825 | 825 | return; |
| 826 | 826 | } |
| 827 | 827 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName))); |
@@ -837,7 +837,7 @@ discard block |
||
| 837 | 837 | protected function _validateIsUnique($inputName, $ruleName, array $ruleArgs) { |
| 838 | 838 | $inputVal = $this->post($inputName); |
| 839 | 839 | $obj = & get_instance(); |
| 840 | - if(! isset($obj->database)){ |
|
| 840 | + if (!isset($obj->database)) { |
|
| 841 | 841 | return; |
| 842 | 842 | } |
| 843 | 843 | list($table, $column) = explode('.', $ruleArgs[1]); |
@@ -846,7 +846,7 @@ discard block |
||
| 846 | 846 | ->get(); |
| 847 | 847 | $nb = $obj->database->numRows(); |
| 848 | 848 | if ($nb != 0) { |
| 849 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 849 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 850 | 850 | return; |
| 851 | 851 | } |
| 852 | 852 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName))); |
@@ -862,11 +862,11 @@ discard block |
||
| 862 | 862 | protected function _validateIsUniqueUpdate($inputName, $ruleName, array $ruleArgs) { |
| 863 | 863 | $inputVal = $this->post($inputName); |
| 864 | 864 | $obj = & get_instance(); |
| 865 | - if(! isset($obj->database)){ |
|
| 865 | + if (!isset($obj->database)) { |
|
| 866 | 866 | return; |
| 867 | 867 | } |
| 868 | 868 | $data = explode(',', $ruleArgs[1]); |
| 869 | - if(count($data) < 2){ |
|
| 869 | + if (count($data) < 2) { |
|
| 870 | 870 | return; |
| 871 | 871 | } |
| 872 | 872 | list($table, $column) = explode('.', $data[0]); |
@@ -877,7 +877,7 @@ discard block |
||
| 877 | 877 | ->get(); |
| 878 | 878 | $nb = $obj->database->numRows(); |
| 879 | 879 | if ($nb != 0) { |
| 880 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 880 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 881 | 881 | return; |
| 882 | 882 | } |
| 883 | 883 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName))); |
@@ -894,8 +894,8 @@ discard block |
||
| 894 | 894 | $inputVal = $this->post($inputName); |
| 895 | 895 | $list = explode(',', $ruleArgs[1]); |
| 896 | 896 | $list = array_map('trim', $list); |
| 897 | - if (! in_array($inputVal, $list)) { |
|
| 898 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 897 | + if (!in_array($inputVal, $list)) { |
|
| 898 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 899 | 899 | return; |
| 900 | 900 | } |
| 901 | 901 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName), $this->_getLabel($ruleArgs[1]))); |
@@ -911,8 +911,8 @@ discard block |
||
| 911 | 911 | protected function _validateRegex($inputName, $ruleName, array $ruleArgs) { |
| 912 | 912 | $inputVal = $this->post($inputName); |
| 913 | 913 | $regex = $ruleArgs[1]; |
| 914 | - if (! preg_match($regex, $inputVal)) { |
|
| 915 | - if (! $this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 914 | + if (!preg_match($regex, $inputVal)) { |
|
| 915 | + if (!$this->_fieldIsRequired($inputName) && empty($this->data[$inputName])) { |
|
| 916 | 916 | return; |
| 917 | 917 | } |
| 918 | 918 | $this->_setError($inputName, $ruleName, array($this->_getLabel($inputName))); |
@@ -37,7 +37,7 @@ discard block |
||
| 37 | 37 | * @package FileUpload |
| 38 | 38 | * @version 1.5 |
| 39 | 39 | */ |
| 40 | - class Upload{ |
|
| 40 | + class Upload { |
|
| 41 | 41 | |
| 42 | 42 | /** |
| 43 | 43 | * Version |
@@ -69,7 +69,7 @@ discard block |
||
| 69 | 69 | * @version 1.0 |
| 70 | 70 | * @var array |
| 71 | 71 | */ |
| 72 | - private $file_array = array(); |
|
| 72 | + private $file_array = array(); |
|
| 73 | 73 | |
| 74 | 74 | /** |
| 75 | 75 | * If the file you are trying to upload already exists it will |
@@ -119,7 +119,7 @@ discard block |
||
| 119 | 119 | * @version 1.0 |
| 120 | 120 | * @var float |
| 121 | 121 | */ |
| 122 | - private $max_file_size= 0.0; |
|
| 122 | + private $max_file_size = 0.0; |
|
| 123 | 123 | |
| 124 | 124 | /** |
| 125 | 125 | * List of allowed mime types |
@@ -217,12 +217,12 @@ discard block |
||
| 217 | 217 | * @return object |
| 218 | 218 | * @method object __construct |
| 219 | 219 | */ |
| 220 | - public function __construct(){ |
|
| 221 | - $this->logger =& class_loader('Log', 'classes'); |
|
| 220 | + public function __construct() { |
|
| 221 | + $this->logger = & class_loader('Log', 'classes'); |
|
| 222 | 222 | $this->logger->setLogger('Library::Upload'); |
| 223 | 223 | |
| 224 | 224 | Loader::lang('file_upload'); |
| 225 | - $obj =& get_instance(); |
|
| 225 | + $obj = & get_instance(); |
|
| 226 | 226 | |
| 227 | 227 | $this->error_messages = array( |
| 228 | 228 | 'upload_err_ini_size' => $obj->lang->get('fu_upload_err_ini_size'), |
@@ -239,15 +239,15 @@ discard block |
||
| 239 | 239 | ); |
| 240 | 240 | |
| 241 | 241 | $this->file = array( |
| 242 | - 'status' => false, // True: success upload |
|
| 243 | - 'mime' => '', // Empty string |
|
| 244 | - 'filename' => '', // Empty string |
|
| 245 | - 'original' => '', // Empty string |
|
| 246 | - 'size' => 0, // 0 Bytes |
|
| 247 | - 'sizeFormated' => '0B', // 0 Bytes |
|
| 248 | - 'destination' => './', // Default: ./ |
|
| 249 | - 'allowed_mime_types' => array(), // Allowed mime types |
|
| 250 | - 'error' => null, // File error |
|
| 242 | + 'status' => false, // True: success upload |
|
| 243 | + 'mime' => '', // Empty string |
|
| 244 | + 'filename' => '', // Empty string |
|
| 245 | + 'original' => '', // Empty string |
|
| 246 | + 'size' => 0, // 0 Bytes |
|
| 247 | + 'sizeFormated' => '0B', // 0 Bytes |
|
| 248 | + 'destination' => './', // Default: ./ |
|
| 249 | + 'allowed_mime_types' => array(), // Allowed mime types |
|
| 250 | + 'error' => null, // File error |
|
| 251 | 251 | ); |
| 252 | 252 | |
| 253 | 253 | // Change dir to current dir |
@@ -257,7 +257,7 @@ discard block |
||
| 257 | 257 | if (isset($_FILES) && is_array($_FILES)) { |
| 258 | 258 | $this->file_array = $_FILES; |
| 259 | 259 | } |
| 260 | - $this->logger->info('The upload file information are : ' .stringfy_vars($this->file_array)); |
|
| 260 | + $this->logger->info('The upload file information are : ' . stringfy_vars($this->file_array)); |
|
| 261 | 261 | } |
| 262 | 262 | /** |
| 263 | 263 | * Set input. |
@@ -273,7 +273,7 @@ discard block |
||
| 273 | 273 | */ |
| 274 | 274 | public function setInput($input) |
| 275 | 275 | { |
| 276 | - if (!empty($input) && (is_string($input) || is_numeric($input) )) { |
|
| 276 | + if (!empty($input) && (is_string($input) || is_numeric($input))) { |
|
| 277 | 277 | $this->input = $input; |
| 278 | 278 | } |
| 279 | 279 | return $this; |
@@ -309,7 +309,7 @@ discard block |
||
| 309 | 309 | */ |
| 310 | 310 | public function setAutoFilename() |
| 311 | 311 | { |
| 312 | - $this->filename = sha1(mt_rand(1, 9999).uniqid()); |
|
| 312 | + $this->filename = sha1(mt_rand(1, 9999) . uniqid()); |
|
| 313 | 313 | $this->filename .= time(); |
| 314 | 314 | return $this; |
| 315 | 315 | } |
@@ -330,7 +330,7 @@ discard block |
||
| 330 | 330 | $php_size = $this->sizeInBytes((int) ini_get('upload_max_filesize')); |
| 331 | 331 | // Calculate difference |
| 332 | 332 | if ($php_size < $file_size) { |
| 333 | - $this->logger->warning('The upload max file size you set [' .$file_size. '] is greather than the PHP configuration for upload max file size [' .$php_size. ']'); |
|
| 333 | + $this->logger->warning('The upload max file size you set [' . $file_size . '] is greather than the PHP configuration for upload max file size [' . $php_size . ']'); |
|
| 334 | 334 | } |
| 335 | 335 | $this->max_file_size = $file_size; |
| 336 | 336 | } |
@@ -348,7 +348,7 @@ discard block |
||
| 348 | 348 | public function setAllowedMimeTypes(array $mimes) |
| 349 | 349 | { |
| 350 | 350 | if (count($mimes) > 0) { |
| 351 | - array_map(array($this , 'setAllowMimeType'), $mimes); |
|
| 351 | + array_map(array($this, 'setAllowMimeType'), $mimes); |
|
| 352 | 352 | } |
| 353 | 353 | return $this; |
| 354 | 354 | } |
@@ -413,7 +413,7 @@ discard block |
||
| 413 | 413 | { |
| 414 | 414 | if (!empty($name) && is_string($name)) { |
| 415 | 415 | if (array_key_exists($name, $this->mime_helping)) { |
| 416 | - return $this->setAllowedMimeTypes($this->mime_helping[ $name ]); |
|
| 416 | + return $this->setAllowedMimeTypes($this->mime_helping[$name]); |
|
| 417 | 417 | } |
| 418 | 418 | } |
| 419 | 419 | return $this; |
@@ -432,8 +432,8 @@ discard block |
||
| 432 | 432 | */ |
| 433 | 433 | public function setUploadFunction($function) |
| 434 | 434 | { |
| 435 | - if (!empty($function) && (is_array($function) || is_string($function) )) { |
|
| 436 | - if (is_callable( $function)) { |
|
| 435 | + if (!empty($function) && (is_array($function) || is_string($function))) { |
|
| 436 | + if (is_callable($function)) { |
|
| 437 | 437 | $this->upload_function = $function; |
| 438 | 438 | } |
| 439 | 439 | } |
@@ -478,8 +478,8 @@ discard block |
||
| 478 | 478 | $this->destination_directory = $destination_directory; |
| 479 | 479 | chdir($destination_directory); |
| 480 | 480 | } |
| 481 | - else{ |
|
| 482 | - $this->logger->warning('Can not create the upload directory [' .$destination_directory. ']'); |
|
| 481 | + else { |
|
| 482 | + $this->logger->warning('Can not create the upload directory [' . $destination_directory . ']'); |
|
| 483 | 483 | } |
| 484 | 484 | } |
| 485 | 485 | } |
@@ -529,7 +529,7 @@ discard block |
||
| 529 | 529 | public function isFilename($filename) |
| 530 | 530 | { |
| 531 | 531 | $filename = basename($filename); |
| 532 | - return (!empty($filename) && (is_string( $filename) || is_numeric($filename))); |
|
| 532 | + return (!empty($filename) && (is_string($filename) || is_numeric($filename))); |
|
| 533 | 533 | } |
| 534 | 534 | /** |
| 535 | 535 | * Validate mime type with allowed mime types, |
@@ -571,11 +571,11 @@ discard block |
||
| 571 | 571 | */ |
| 572 | 572 | public function isDirpath($path) |
| 573 | 573 | { |
| 574 | - if (!empty( $path) && (is_string( $path) || is_numeric($path) )) { |
|
| 574 | + if (!empty($path) && (is_string($path) || is_numeric($path))) { |
|
| 575 | 575 | if (DIRECTORY_SEPARATOR == '/') { |
| 576 | - return (preg_match( '/^[^*?"<>|:]*$/' , $path) == 1 ); |
|
| 576 | + return (preg_match('/^[^*?"<>|:]*$/', $path) == 1); |
|
| 577 | 577 | } else { |
| 578 | - return (preg_match( "/^[^*?\"<>|:]*$/" , substr($path,2) ) == 1); |
|
| 578 | + return (preg_match("/^[^*?\"<>|:]*$/", substr($path, 2)) == 1); |
|
| 579 | 579 | } |
| 580 | 580 | } |
| 581 | 581 | return false; |
@@ -603,7 +603,7 @@ discard block |
||
| 603 | 603 | */ |
| 604 | 604 | public function getInfo() |
| 605 | 605 | { |
| 606 | - return (object)$this->file; |
|
| 606 | + return (object) $this->file; |
|
| 607 | 607 | } |
| 608 | 608 | |
| 609 | 609 | |
@@ -611,7 +611,7 @@ discard block |
||
| 611 | 611 | * Check if the file is uploaded |
| 612 | 612 | * @return boolean |
| 613 | 613 | */ |
| 614 | - public function isUploaded(){ |
|
| 614 | + public function isUploaded() { |
|
| 615 | 615 | return isset($this->file_array[$this->input]) |
| 616 | 616 | && is_uploaded_file($this->file_array[$this->input]['tmp_name']); |
| 617 | 617 | } |
@@ -625,13 +625,13 @@ discard block |
||
| 625 | 625 | * @return boolean |
| 626 | 626 | * @method boolean save |
| 627 | 627 | */ |
| 628 | - public function save(){ |
|
| 628 | + public function save() { |
|
| 629 | 629 | if (count($this->file_array) > 0 && array_key_exists($this->input, $this->file_array)) { |
| 630 | 630 | // set original filename if not have a new name |
| 631 | 631 | if (empty($this->filename)) { |
| 632 | 632 | $this->filename = $this->file_array[$this->input]['name']; |
| 633 | 633 | } |
| 634 | - else{ |
|
| 634 | + else { |
|
| 635 | 635 | // Replace %s for extension in filename |
| 636 | 636 | // Before: /[\w\d]*(.[\d\w]+)$/i |
| 637 | 637 | // After: /^[\s[:alnum:]\-\_\.]*\.([\d\w]+)$/iu |
@@ -655,10 +655,10 @@ discard block |
||
| 655 | 655 | $this->file['filename'] = $this->filename; |
| 656 | 656 | $this->file['error'] = $this->file_array[$this->input]['error']; |
| 657 | 657 | |
| 658 | - $this->logger->info('The upload file information to process is : ' .stringfy_vars($this->file)); |
|
| 658 | + $this->logger->info('The upload file information to process is : ' . stringfy_vars($this->file)); |
|
| 659 | 659 | |
| 660 | 660 | $error = $this->uploadHasError(); |
| 661 | - if($error){ |
|
| 661 | + if ($error) { |
|
| 662 | 662 | return false; |
| 663 | 663 | } |
| 664 | 664 | // Execute input callback |
@@ -692,10 +692,10 @@ discard block |
||
| 692 | 692 | */ |
| 693 | 693 | public function sizeFormat($size, $precision = 2) |
| 694 | 694 | { |
| 695 | - if($size > 0){ |
|
| 695 | + if ($size > 0) { |
|
| 696 | 696 | $base = log($size) / log(1024); |
| 697 | 697 | $suffixes = array('B', 'K', 'M', 'G', 'T'); |
| 698 | - return round(pow(1024, $base - floor($base)), $precision) . ( isset($suffixes[floor($base)]) ? $suffixes[floor($base)] : ''); |
|
| 698 | + return round(pow(1024, $base - floor($base)), $precision) . (isset($suffixes[floor($base)]) ? $suffixes[floor($base)] : ''); |
|
| 699 | 699 | } |
| 700 | 700 | return null; |
| 701 | 701 | } |
@@ -719,14 +719,14 @@ discard block |
||
| 719 | 719 | if (array_key_exists('unit', $matches)) { |
| 720 | 720 | $unit = strtoupper($matches['unit']); |
| 721 | 721 | } |
| 722 | - return (floatval($matches['size']) * pow(1024, $units[$unit]) ) ; |
|
| 722 | + return (floatval($matches['size']) * pow(1024, $units[$unit])); |
|
| 723 | 723 | } |
| 724 | 724 | |
| 725 | 725 | /** |
| 726 | 726 | * Get the upload error message |
| 727 | 727 | * @return string |
| 728 | 728 | */ |
| 729 | - public function getError(){ |
|
| 729 | + public function getError() { |
|
| 730 | 730 | return $this->error; |
| 731 | 731 | } |
| 732 | 732 | |
@@ -734,7 +734,7 @@ discard block |
||
| 734 | 734 | * Set the upload error message |
| 735 | 735 | * @param string $message the upload error message to set |
| 736 | 736 | */ |
| 737 | - public function setError($message){ |
|
| 737 | + public function setError($message) { |
|
| 738 | 738 | $this->logger->info('The file upload got error : ' . $message); |
| 739 | 739 | $this->error = $message; |
| 740 | 740 | } |
@@ -744,9 +744,9 @@ discard block |
||
| 744 | 744 | * @param string $type the type of callback "input" or "output" |
| 745 | 745 | * @return void |
| 746 | 746 | */ |
| 747 | - protected function runCallback($type){ |
|
| 748 | - if (!empty( $this->callbacks[$type])) { |
|
| 749 | - call_user_func($this->callbacks[$type], (object)$this->file); |
|
| 747 | + protected function runCallback($type) { |
|
| 748 | + if (!empty($this->callbacks[$type])) { |
|
| 749 | + call_user_func($this->callbacks[$type], (object) $this->file); |
|
| 750 | 750 | } |
| 751 | 751 | } |
| 752 | 752 | |
@@ -754,21 +754,21 @@ discard block |
||
| 754 | 754 | * Check if file upload has error |
| 755 | 755 | * @return boolean |
| 756 | 756 | */ |
| 757 | - protected function uploadHasError(){ |
|
| 757 | + protected function uploadHasError() { |
|
| 758 | 758 | //check if file upload is allowed in the configuration |
| 759 | - if(! ini_get('file_uploads')){ |
|
| 759 | + if (!ini_get('file_uploads')) { |
|
| 760 | 760 | $this->setError($this->error_messages['file_uploads']); |
| 761 | 761 | return true; |
| 762 | 762 | } |
| 763 | 763 | |
| 764 | 764 | //check for php upload error |
| 765 | - if(is_numeric($this->file['error']) && $this->file['error'] > 0){ |
|
| 765 | + if (is_numeric($this->file['error']) && $this->file['error'] > 0) { |
|
| 766 | 766 | $this->setError($this->getPhpUploadErrorMessageByCode($this->file['error'])); |
| 767 | 767 | return true; |
| 768 | 768 | } |
| 769 | 769 | |
| 770 | 770 | //check for mime type |
| 771 | - if (! $this->checkMimeType($this->file['mime'])) { |
|
| 771 | + if (!$this->checkMimeType($this->file['mime'])) { |
|
| 772 | 772 | $this->setError($this->error_messages['accept_file_types']); |
| 773 | 773 | return true; |
| 774 | 774 | } |
@@ -792,7 +792,7 @@ discard block |
||
| 792 | 792 | * @param int $code the error code |
| 793 | 793 | * @return string the error message |
| 794 | 794 | */ |
| 795 | - private function getPhpUploadErrorMessageByCode($code){ |
|
| 795 | + private function getPhpUploadErrorMessageByCode($code) { |
|
| 796 | 796 | $codeMessageMaps = array( |
| 797 | 797 | 1 => $this->error_messages['upload_err_ini_size'], |
| 798 | 798 | 2 => $this->error_messages['upload_err_form_size'], |
@@ -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 | /** |
@@ -45,7 +45,7 @@ discard block |
||
| 45 | 45 | * @param mixed $result the query result |
| 46 | 46 | * @param int $numRows the number of rows returned by the query |
| 47 | 47 | */ |
| 48 | - public function __construct($result = null, $numRows = 0){ |
|
| 48 | + public function __construct($result = null, $numRows = 0) { |
|
| 49 | 49 | $this->result = $result; |
| 50 | 50 | $this->numRows = $numRows; |
| 51 | 51 | } |
@@ -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 | } |
@@ -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,18 +215,18 @@ 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 | 228 | } |
| 229 | - else{ |
|
| 229 | + else { |
|
| 230 | 230 | $this->join = $this->join . ' ' . $type . 'JOIN' . ' ' . $table . ' ON ' . $on; |
| 231 | 231 | } |
| 232 | 232 | return $this; |
@@ -237,7 +237,7 @@ discard block |
||
| 237 | 237 | * @see DatabaseQueryBuilder::join() |
| 238 | 238 | * @return object the current DatabaseQueryBuilder instance |
| 239 | 239 | */ |
| 240 | - public function innerJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 240 | + public function innerJoin($table, $field1, $op = null, $field2 = '') { |
|
| 241 | 241 | return $this->join($table, $field1, $op, $field2, 'INNER '); |
| 242 | 242 | } |
| 243 | 243 | |
@@ -246,7 +246,7 @@ discard block |
||
| 246 | 246 | * @see DatabaseQueryBuilder::join() |
| 247 | 247 | * @return object the current DatabaseQueryBuilder instance |
| 248 | 248 | */ |
| 249 | - public function leftJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 249 | + public function leftJoin($table, $field1, $op = null, $field2 = '') { |
|
| 250 | 250 | return $this->join($table, $field1, $op, $field2, 'LEFT '); |
| 251 | 251 | } |
| 252 | 252 | |
@@ -255,7 +255,7 @@ discard block |
||
| 255 | 255 | * @see DatabaseQueryBuilder::join() |
| 256 | 256 | * @return object the current DatabaseQueryBuilder instance |
| 257 | 257 | */ |
| 258 | - public function rightJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 258 | + public function rightJoin($table, $field1, $op = null, $field2 = '') { |
|
| 259 | 259 | return $this->join($table, $field1, $op, $field2, 'RIGHT '); |
| 260 | 260 | } |
| 261 | 261 | |
@@ -264,7 +264,7 @@ discard block |
||
| 264 | 264 | * @see DatabaseQueryBuilder::join() |
| 265 | 265 | * @return object the current DatabaseQueryBuilder instance |
| 266 | 266 | */ |
| 267 | - public function fullOuterJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 267 | + public function fullOuterJoin($table, $field1, $op = null, $field2 = '') { |
|
| 268 | 268 | return $this->join($table, $field1, $op, $field2, 'FULL OUTER '); |
| 269 | 269 | } |
| 270 | 270 | |
@@ -273,7 +273,7 @@ discard block |
||
| 273 | 273 | * @see DatabaseQueryBuilder::join() |
| 274 | 274 | * @return object the current DatabaseQueryBuilder instance |
| 275 | 275 | */ |
| 276 | - public function leftOuterJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 276 | + public function leftOuterJoin($table, $field1, $op = null, $field2 = '') { |
|
| 277 | 277 | return $this->join($table, $field1, $op, $field2, 'LEFT OUTER '); |
| 278 | 278 | } |
| 279 | 279 | |
@@ -282,7 +282,7 @@ discard block |
||
| 282 | 282 | * @see DatabaseQueryBuilder::join() |
| 283 | 283 | * @return object the current DatabaseQueryBuilder instance |
| 284 | 284 | */ |
| 285 | - public function rightOuterJoin($table, $field1, $op = null, $field2 = ''){ |
|
| 285 | + public function rightOuterJoin($table, $field1, $op = null, $field2 = '') { |
|
| 286 | 286 | return $this->join($table, $field1, $op, $field2, 'RIGHT OUTER '); |
| 287 | 287 | } |
| 288 | 288 | |
@@ -292,13 +292,13 @@ discard block |
||
| 292 | 292 | * @param string $andOr the separator type used 'AND', 'OR', etc. |
| 293 | 293 | * @return object the current DatabaseQueryBuilder instance |
| 294 | 294 | */ |
| 295 | - public function whereIsNull($field, $andOr = 'AND'){ |
|
| 296 | - if (is_array($field)){ |
|
| 297 | - foreach($field as $f){ |
|
| 295 | + public function whereIsNull($field, $andOr = 'AND') { |
|
| 296 | + if (is_array($field)) { |
|
| 297 | + foreach ($field as $f) { |
|
| 298 | 298 | $this->whereIsNull($f, $andOr); |
| 299 | 299 | } |
| 300 | 300 | } else { |
| 301 | - $this->setWhereStr($field.' IS NULL ', $andOr); |
|
| 301 | + $this->setWhereStr($field . ' IS NULL ', $andOr); |
|
| 302 | 302 | } |
| 303 | 303 | return $this; |
| 304 | 304 | } |
@@ -309,13 +309,13 @@ discard block |
||
| 309 | 309 | * @param string $andOr the separator type used 'AND', 'OR', etc. |
| 310 | 310 | * @return object the current DatabaseQueryBuilder instance |
| 311 | 311 | */ |
| 312 | - public function whereIsNotNull($field, $andOr = 'AND'){ |
|
| 313 | - if (is_array($field)){ |
|
| 314 | - foreach($field as $f){ |
|
| 312 | + public function whereIsNotNull($field, $andOr = 'AND') { |
|
| 313 | + if (is_array($field)) { |
|
| 314 | + foreach ($field as $f) { |
|
| 315 | 315 | $this->whereIsNotNull($f, $andOr); |
| 316 | 316 | } |
| 317 | 317 | } else { |
| 318 | - $this->setWhereStr($field.' IS NOT NULL ', $andOr); |
|
| 318 | + $this->setWhereStr($field . ' IS NOT NULL ', $andOr); |
|
| 319 | 319 | } |
| 320 | 320 | return $this; |
| 321 | 321 | } |
@@ -330,13 +330,13 @@ discard block |
||
| 330 | 330 | * @param boolean $escape whether to escape or not the $val |
| 331 | 331 | * @return object the current DatabaseQueryBuilder instance |
| 332 | 332 | */ |
| 333 | - public function where($where, $op = null, $val = null, $type = '', $andOr = 'AND', $escape = true){ |
|
| 333 | + public function where($where, $op = null, $val = null, $type = '', $andOr = 'AND', $escape = true) { |
|
| 334 | 334 | $whereStr = ''; |
| 335 | - if (is_array($where)){ |
|
| 335 | + if (is_array($where)) { |
|
| 336 | 336 | $whereStr = $this->getWhereStrIfIsArray($where, $type, $andOr, $escape); |
| 337 | 337 | } |
| 338 | - else{ |
|
| 339 | - if (is_array($op)){ |
|
| 338 | + else { |
|
| 339 | + if (is_array($op)) { |
|
| 340 | 340 | $whereStr = $this->getWhereStrIfOperatorIsArray($where, $op, $type, $escape); |
| 341 | 341 | } else { |
| 342 | 342 | $whereStr = $this->getWhereStrForOperator($where, $op, $val, $type, $escape = true); |
@@ -351,7 +351,7 @@ discard block |
||
| 351 | 351 | * @see DatabaseQueryBuilder::where() |
| 352 | 352 | * @return object the current DatabaseQueryBuilder instance |
| 353 | 353 | */ |
| 354 | - public function orWhere($where, $op = null, $val = null, $escape = true){ |
|
| 354 | + public function orWhere($where, $op = null, $val = null, $escape = true) { |
|
| 355 | 355 | return $this->where($where, $op, $val, '', 'OR', $escape); |
| 356 | 356 | } |
| 357 | 357 | |
@@ -361,7 +361,7 @@ discard block |
||
| 361 | 361 | * @see DatabaseQueryBuilder::where() |
| 362 | 362 | * @return object the current DatabaseQueryBuilder instance |
| 363 | 363 | */ |
| 364 | - public function notWhere($where, $op = null, $val = null, $escape = true){ |
|
| 364 | + public function notWhere($where, $op = null, $val = null, $escape = true) { |
|
| 365 | 365 | return $this->where($where, $op, $val, 'NOT ', 'AND', $escape); |
| 366 | 366 | } |
| 367 | 367 | |
@@ -370,7 +370,7 @@ discard block |
||
| 370 | 370 | * @see DatabaseQueryBuilder::where() |
| 371 | 371 | * @return object the current DatabaseQueryBuilder instance |
| 372 | 372 | */ |
| 373 | - public function orNotWhere($where, $op = null, $val = null, $escape = true){ |
|
| 373 | + public function orNotWhere($where, $op = null, $val = null, $escape = true) { |
|
| 374 | 374 | return $this->where($where, $op, $val, 'NOT ', 'OR', $escape); |
| 375 | 375 | } |
| 376 | 376 | |
@@ -380,11 +380,11 @@ discard block |
||
| 380 | 380 | * @param string $andOr the multiple conditions separator (AND, OR, etc.) |
| 381 | 381 | * @return object the current DatabaseQueryBuilder instance |
| 382 | 382 | */ |
| 383 | - public function groupStart($type = '', $andOr = ' AND'){ |
|
| 384 | - if (empty($this->where)){ |
|
| 383 | + public function groupStart($type = '', $andOr = ' AND') { |
|
| 384 | + if (empty($this->where)) { |
|
| 385 | 385 | $this->where = $type . ' ('; |
| 386 | 386 | } else { |
| 387 | - if (substr(trim($this->where), -1) == '('){ |
|
| 387 | + if (substr(trim($this->where), -1) == '(') { |
|
| 388 | 388 | $this->where .= $type . ' ('; |
| 389 | 389 | } else { |
| 390 | 390 | $this->where .= $andOr . ' ' . $type . ' ('; |
@@ -398,7 +398,7 @@ discard block |
||
| 398 | 398 | * @see DatabaseQueryBuilder::groupStart() |
| 399 | 399 | * @return object the current DatabaseQueryBuilder instance |
| 400 | 400 | */ |
| 401 | - public function notGroupStart(){ |
|
| 401 | + public function notGroupStart() { |
|
| 402 | 402 | return $this->groupStart('NOT'); |
| 403 | 403 | } |
| 404 | 404 | |
@@ -407,7 +407,7 @@ discard block |
||
| 407 | 407 | * @see DatabaseQueryBuilder::groupStart() |
| 408 | 408 | * @return object the current DatabaseQueryBuilder instance |
| 409 | 409 | */ |
| 410 | - public function orGroupStart(){ |
|
| 410 | + public function orGroupStart() { |
|
| 411 | 411 | return $this->groupStart('', ' OR'); |
| 412 | 412 | } |
| 413 | 413 | |
@@ -416,7 +416,7 @@ discard block |
||
| 416 | 416 | * @see DatabaseQueryBuilder::groupStart() |
| 417 | 417 | * @return object the current DatabaseQueryBuilder instance |
| 418 | 418 | */ |
| 419 | - public function orNotGroupStart(){ |
|
| 419 | + public function orNotGroupStart() { |
|
| 420 | 420 | return $this->groupStart('NOT', ' OR'); |
| 421 | 421 | } |
| 422 | 422 | |
@@ -424,7 +424,7 @@ discard block |
||
| 424 | 424 | * Close the parenthesis for the grouped SQL |
| 425 | 425 | * @return object the current DatabaseQueryBuilder instance |
| 426 | 426 | */ |
| 427 | - public function groupEnd(){ |
|
| 427 | + public function groupEnd() { |
|
| 428 | 428 | $this->where .= ')'; |
| 429 | 429 | return $this; |
| 430 | 430 | } |
@@ -438,10 +438,10 @@ discard block |
||
| 438 | 438 | * @param boolean $escape whether to escape or not the values |
| 439 | 439 | * @return object the current DatabaseQueryBuilder instance |
| 440 | 440 | */ |
| 441 | - public function in($field, array $keys, $type = '', $andOr = 'AND', $escape = true){ |
|
| 441 | + public function in($field, array $keys, $type = '', $andOr = 'AND', $escape = true) { |
|
| 442 | 442 | $_keys = array(); |
| 443 | - foreach ($keys as $k => $v){ |
|
| 444 | - if (is_null($v)){ |
|
| 443 | + foreach ($keys as $k => $v) { |
|
| 444 | + if (is_null($v)) { |
|
| 445 | 445 | $v = ''; |
| 446 | 446 | } |
| 447 | 447 | $_keys[] = (is_numeric($v) ? $v : $this->escape($v, $escape)); |
@@ -457,7 +457,7 @@ discard block |
||
| 457 | 457 | * @see DatabaseQueryBuilder::in() |
| 458 | 458 | * @return object the current DatabaseQueryBuilder instance |
| 459 | 459 | */ |
| 460 | - public function notIn($field, array $keys, $escape = true){ |
|
| 460 | + public function notIn($field, array $keys, $escape = true) { |
|
| 461 | 461 | return $this->in($field, $keys, 'NOT ', 'AND', $escape); |
| 462 | 462 | } |
| 463 | 463 | |
@@ -466,7 +466,7 @@ discard block |
||
| 466 | 466 | * @see DatabaseQueryBuilder::in() |
| 467 | 467 | * @return object the current DatabaseQueryBuilder instance |
| 468 | 468 | */ |
| 469 | - public function orIn($field, array $keys, $escape = true){ |
|
| 469 | + public function orIn($field, array $keys, $escape = true) { |
|
| 470 | 470 | return $this->in($field, $keys, '', 'OR', $escape); |
| 471 | 471 | } |
| 472 | 472 | |
@@ -475,7 +475,7 @@ discard block |
||
| 475 | 475 | * @see DatabaseQueryBuilder::in() |
| 476 | 476 | * @return object the current DatabaseQueryBuilder instance |
| 477 | 477 | */ |
| 478 | - public function orNotIn($field, array $keys, $escape = true){ |
|
| 478 | + public function orNotIn($field, array $keys, $escape = true) { |
|
| 479 | 479 | return $this->in($field, $keys, 'NOT ', 'OR', $escape); |
| 480 | 480 | } |
| 481 | 481 | |
@@ -489,11 +489,11 @@ discard block |
||
| 489 | 489 | * @param boolean $escape whether to escape or not the values |
| 490 | 490 | * @return object the current DatabaseQueryBuilder instance |
| 491 | 491 | */ |
| 492 | - public function between($field, $value1, $value2, $type = '', $andOr = 'AND', $escape = true){ |
|
| 493 | - if (is_null($value1)){ |
|
| 492 | + public function between($field, $value1, $value2, $type = '', $andOr = 'AND', $escape = true) { |
|
| 493 | + if (is_null($value1)) { |
|
| 494 | 494 | $value1 = ''; |
| 495 | 495 | } |
| 496 | - if (is_null($value2)){ |
|
| 496 | + if (is_null($value2)) { |
|
| 497 | 497 | $value2 = ''; |
| 498 | 498 | } |
| 499 | 499 | $whereStr = $field . ' ' . $type . ' BETWEEN ' . $this->escape($value1, $escape) . ' AND ' . $this->escape($value2, $escape); |
@@ -506,7 +506,7 @@ discard block |
||
| 506 | 506 | * @see DatabaseQueryBuilder::between() |
| 507 | 507 | * @return object the current DatabaseQueryBuilder instance |
| 508 | 508 | */ |
| 509 | - public function notBetween($field, $value1, $value2, $escape = true){ |
|
| 509 | + public function notBetween($field, $value1, $value2, $escape = true) { |
|
| 510 | 510 | return $this->between($field, $value1, $value2, 'NOT ', 'AND', $escape); |
| 511 | 511 | } |
| 512 | 512 | |
@@ -515,7 +515,7 @@ discard block |
||
| 515 | 515 | * @see DatabaseQueryBuilder::between() |
| 516 | 516 | * @return object the current DatabaseQueryBuilder instance |
| 517 | 517 | */ |
| 518 | - public function orBetween($field, $value1, $value2, $escape = true){ |
|
| 518 | + public function orBetween($field, $value1, $value2, $escape = true) { |
|
| 519 | 519 | return $this->between($field, $value1, $value2, '', 'OR', $escape); |
| 520 | 520 | } |
| 521 | 521 | |
@@ -524,7 +524,7 @@ discard block |
||
| 524 | 524 | * @see DatabaseQueryBuilder::between() |
| 525 | 525 | * @return object the current DatabaseQueryBuilder instance |
| 526 | 526 | */ |
| 527 | - public function orNotBetween($field, $value1, $value2, $escape = true){ |
|
| 527 | + public function orNotBetween($field, $value1, $value2, $escape = true) { |
|
| 528 | 528 | return $this->between($field, $value1, $value2, 'NOT ', 'OR', $escape); |
| 529 | 529 | } |
| 530 | 530 | |
@@ -537,8 +537,8 @@ discard block |
||
| 537 | 537 | * @param boolean $escape whether to escape or not the values |
| 538 | 538 | * @return object the current DatabaseQueryBuilder instance |
| 539 | 539 | */ |
| 540 | - public function like($field, $data, $type = '', $andOr = 'AND', $escape = true){ |
|
| 541 | - if (empty($data)){ |
|
| 540 | + public function like($field, $data, $type = '', $andOr = 'AND', $escape = true) { |
|
| 541 | + if (empty($data)) { |
|
| 542 | 542 | $data = ''; |
| 543 | 543 | } |
| 544 | 544 | $this->setWhereStr($field . ' ' . $type . ' LIKE ' . ($this->escape($data, $escape)), $andOr); |
@@ -550,7 +550,7 @@ discard block |
||
| 550 | 550 | * @see DatabaseQueryBuilder::like() |
| 551 | 551 | * @return object the current DatabaseQueryBuilder instance |
| 552 | 552 | */ |
| 553 | - public function orLike($field, $data, $escape = true){ |
|
| 553 | + public function orLike($field, $data, $escape = true) { |
|
| 554 | 554 | return $this->like($field, $data, '', 'OR', $escape); |
| 555 | 555 | } |
| 556 | 556 | |
@@ -559,7 +559,7 @@ discard block |
||
| 559 | 559 | * @see DatabaseQueryBuilder::like() |
| 560 | 560 | * @return object the current DatabaseQueryBuilder instance |
| 561 | 561 | */ |
| 562 | - public function notLike($field, $data, $escape = true){ |
|
| 562 | + public function notLike($field, $data, $escape = true) { |
|
| 563 | 563 | return $this->like($field, $data, 'NOT ', 'AND', $escape); |
| 564 | 564 | } |
| 565 | 565 | |
@@ -568,7 +568,7 @@ discard block |
||
| 568 | 568 | * @see DatabaseQueryBuilder::like() |
| 569 | 569 | * @return object the current DatabaseQueryBuilder instance |
| 570 | 570 | */ |
| 571 | - public function orNotLike($field, $data, $escape = true){ |
|
| 571 | + public function orNotLike($field, $data, $escape = true) { |
|
| 572 | 572 | return $this->like($field, $data, 'NOT ', 'OR', $escape); |
| 573 | 573 | } |
| 574 | 574 | |
@@ -579,14 +579,14 @@ discard block |
||
| 579 | 579 | * @param int $limitEnd the limit count |
| 580 | 580 | * @return object the current DatabaseQueryBuilder instance |
| 581 | 581 | */ |
| 582 | - public function limit($limit, $limitEnd = null){ |
|
| 583 | - if (empty($limit)){ |
|
| 582 | + public function limit($limit, $limitEnd = null) { |
|
| 583 | + if (empty($limit)) { |
|
| 584 | 584 | $limit = 0; |
| 585 | 585 | } |
| 586 | - if (! is_null($limitEnd)){ |
|
| 586 | + if (!is_null($limitEnd)) { |
|
| 587 | 587 | $this->limit = $limit . ', ' . $limitEnd; |
| 588 | 588 | } |
| 589 | - else{ |
|
| 589 | + else { |
|
| 590 | 590 | $this->limit = $limit; |
| 591 | 591 | } |
| 592 | 592 | return $this; |
@@ -598,11 +598,11 @@ discard block |
||
| 598 | 598 | * @param string $orderDir the order direction (ASC or DESC) |
| 599 | 599 | * @return object the current DatabaseQueryBuilder instance |
| 600 | 600 | */ |
| 601 | - public function orderBy($orderBy, $orderDir = ' ASC'){ |
|
| 602 | - if (stristr($orderBy, ' ') || $orderBy == 'rand()'){ |
|
| 601 | + public function orderBy($orderBy, $orderDir = ' ASC') { |
|
| 602 | + if (stristr($orderBy, ' ') || $orderBy == 'rand()') { |
|
| 603 | 603 | $this->orderBy = empty($this->orderBy) ? $orderBy : $this->orderBy . ', ' . $orderBy; |
| 604 | 604 | } |
| 605 | - else{ |
|
| 605 | + else { |
|
| 606 | 606 | $this->orderBy = empty($this->orderBy) |
| 607 | 607 | ? ($orderBy . ' ' . strtoupper($orderDir)) |
| 608 | 608 | : $this->orderBy . ', ' . $orderBy . ' ' . strtoupper($orderDir); |
@@ -615,11 +615,11 @@ discard block |
||
| 615 | 615 | * @param string|array $field the field name used or array of field list |
| 616 | 616 | * @return object the current DatabaseQueryBuilder instance |
| 617 | 617 | */ |
| 618 | - public function groupBy($field){ |
|
| 619 | - if (is_array($field)){ |
|
| 618 | + public function groupBy($field) { |
|
| 619 | + if (is_array($field)) { |
|
| 620 | 620 | $this->groupBy = implode(', ', $field); |
| 621 | 621 | } |
| 622 | - else{ |
|
| 622 | + else { |
|
| 623 | 623 | $this->groupBy = $field; |
| 624 | 624 | } |
| 625 | 625 | return $this; |
@@ -633,18 +633,18 @@ discard block |
||
| 633 | 633 | * @param boolean $escape whether to escape or not the values |
| 634 | 634 | * @return object the current DatabaseQueryBuilder instance |
| 635 | 635 | */ |
| 636 | - public function having($field, $op = null, $val = null, $escape = true){ |
|
| 637 | - if (is_array($op)){ |
|
| 636 | + public function having($field, $op = null, $val = null, $escape = true) { |
|
| 637 | + if (is_array($op)) { |
|
| 638 | 638 | $this->having = $this->getHavingStrIfOperatorIsArray($field, $op, $escape); |
| 639 | 639 | } |
| 640 | - else if (! in_array($op, $this->operatorList)){ |
|
| 641 | - if (is_null($op)){ |
|
| 640 | + else if (!in_array($op, $this->operatorList)) { |
|
| 641 | + if (is_null($op)) { |
|
| 642 | 642 | $op = ''; |
| 643 | 643 | } |
| 644 | 644 | $this->having = $field . ' > ' . ($this->escape($op, $escape)); |
| 645 | 645 | } |
| 646 | - else{ |
|
| 647 | - if (is_null($val)){ |
|
| 646 | + else { |
|
| 647 | + if (is_null($val)) { |
|
| 648 | 648 | $val = ''; |
| 649 | 649 | } |
| 650 | 650 | $this->having = $field . ' ' . $op . ' ' . ($this->escape($val, $escape)); |
@@ -658,7 +658,7 @@ discard block |
||
| 658 | 658 | * @param boolean $escape whether to escape or not the values |
| 659 | 659 | * @return object the current DatabaseQueryBuilder instance |
| 660 | 660 | */ |
| 661 | - public function insert($data = array(), $escape = true){ |
|
| 661 | + public function insert($data = array(), $escape = true) { |
|
| 662 | 662 | $columns = array_keys($data); |
| 663 | 663 | $column = implode(', ', $columns); |
| 664 | 664 | $val = implode(', ', ($escape ? array_map(array($this, 'escape'), $data) : $data)); |
@@ -673,22 +673,22 @@ discard block |
||
| 673 | 673 | * @param boolean $escape whether to escape or not the values |
| 674 | 674 | * @return object the current DatabaseQueryBuilder instance |
| 675 | 675 | */ |
| 676 | - public function update($data = array(), $escape = true){ |
|
| 676 | + public function update($data = array(), $escape = true) { |
|
| 677 | 677 | $query = 'UPDATE ' . $this->from . ' SET '; |
| 678 | 678 | $values = array(); |
| 679 | - foreach ($data as $column => $val){ |
|
| 679 | + foreach ($data as $column => $val) { |
|
| 680 | 680 | $values[] = $column . ' = ' . ($this->escape($val, $escape)); |
| 681 | 681 | } |
| 682 | 682 | $query .= implode(', ', $values); |
| 683 | - if (! empty($this->where)){ |
|
| 683 | + if (!empty($this->where)) { |
|
| 684 | 684 | $query .= ' WHERE ' . $this->where; |
| 685 | 685 | } |
| 686 | 686 | |
| 687 | - if (! empty($this->orderBy)){ |
|
| 687 | + if (!empty($this->orderBy)) { |
|
| 688 | 688 | $query .= ' ORDER BY ' . $this->orderBy; |
| 689 | 689 | } |
| 690 | 690 | |
| 691 | - if (! empty($this->limit)){ |
|
| 691 | + if (!empty($this->limit)) { |
|
| 692 | 692 | $query .= ' LIMIT ' . $this->limit; |
| 693 | 693 | } |
| 694 | 694 | $this->query = $query; |
@@ -699,22 +699,22 @@ discard block |
||
| 699 | 699 | * Delete the record in database |
| 700 | 700 | * @return object the current DatabaseQueryBuilder instance |
| 701 | 701 | */ |
| 702 | - public function delete(){ |
|
| 702 | + public function delete() { |
|
| 703 | 703 | $query = 'DELETE FROM ' . $this->from; |
| 704 | 704 | $isTruncate = $query; |
| 705 | - if (! empty($this->where)){ |
|
| 705 | + if (!empty($this->where)) { |
|
| 706 | 706 | $query .= ' WHERE ' . $this->where; |
| 707 | 707 | } |
| 708 | 708 | |
| 709 | - if (! empty($this->orderBy)){ |
|
| 709 | + if (!empty($this->orderBy)) { |
|
| 710 | 710 | $query .= ' ORDER BY ' . $this->orderBy; |
| 711 | 711 | } |
| 712 | 712 | |
| 713 | - if (! empty($this->limit)){ |
|
| 713 | + if (!empty($this->limit)) { |
|
| 714 | 714 | $query .= ' LIMIT ' . $this->limit; |
| 715 | 715 | } |
| 716 | 716 | |
| 717 | - if ($isTruncate == $query && $this->driver != 'sqlite'){ |
|
| 717 | + if ($isTruncate == $query && $this->driver != 'sqlite') { |
|
| 718 | 718 | $query = 'TRUNCATE TABLE ' . $this->from; |
| 719 | 719 | } |
| 720 | 720 | $this->query = $query; |
@@ -727,7 +727,7 @@ discard block |
||
| 727 | 727 | * @param boolean $escaped whether we can do escape of not |
| 728 | 728 | * @return mixed the data after escaped or the same data if not |
| 729 | 729 | */ |
| 730 | - public function escape($data, $escaped = true){ |
|
| 730 | + public function escape($data, $escaped = true) { |
|
| 731 | 731 | return $escaped |
| 732 | 732 | ? $this->getPdo()->quote(trim($data)) |
| 733 | 733 | : $data; |
@@ -738,31 +738,31 @@ discard block |
||
| 738 | 738 | * Return the current SQL query string |
| 739 | 739 | * @return string |
| 740 | 740 | */ |
| 741 | - public function getQuery(){ |
|
| 741 | + public function getQuery() { |
|
| 742 | 742 | //INSERT, UPDATE, DELETE already set it, if is the SELECT we need set it now |
| 743 | - if(empty($this->query)){ |
|
| 743 | + if (empty($this->query)) { |
|
| 744 | 744 | $query = 'SELECT ' . $this->select . ' FROM ' . $this->from; |
| 745 | - if (! empty($this->join)){ |
|
| 745 | + if (!empty($this->join)) { |
|
| 746 | 746 | $query .= $this->join; |
| 747 | 747 | } |
| 748 | 748 | |
| 749 | - if (! empty($this->where)){ |
|
| 749 | + if (!empty($this->where)) { |
|
| 750 | 750 | $query .= ' WHERE ' . $this->where; |
| 751 | 751 | } |
| 752 | 752 | |
| 753 | - if (! empty($this->groupBy)){ |
|
| 753 | + if (!empty($this->groupBy)) { |
|
| 754 | 754 | $query .= ' GROUP BY ' . $this->groupBy; |
| 755 | 755 | } |
| 756 | 756 | |
| 757 | - if (! empty($this->having)){ |
|
| 757 | + if (!empty($this->having)) { |
|
| 758 | 758 | $query .= ' HAVING ' . $this->having; |
| 759 | 759 | } |
| 760 | 760 | |
| 761 | - if (! empty($this->orderBy)){ |
|
| 761 | + if (!empty($this->orderBy)) { |
|
| 762 | 762 | $query .= ' ORDER BY ' . $this->orderBy; |
| 763 | 763 | } |
| 764 | 764 | |
| 765 | - if (! empty($this->limit)){ |
|
| 765 | + if (!empty($this->limit)) { |
|
| 766 | 766 | $query .= ' LIMIT ' . $this->limit; |
| 767 | 767 | } |
| 768 | 768 | $this->query = $query; |
@@ -775,7 +775,7 @@ discard block |
||
| 775 | 775 | * Return the PDO instance |
| 776 | 776 | * @return object |
| 777 | 777 | */ |
| 778 | - public function getPdo(){ |
|
| 778 | + public function getPdo() { |
|
| 779 | 779 | return $this->pdo; |
| 780 | 780 | } |
| 781 | 781 | |
@@ -784,7 +784,7 @@ discard block |
||
| 784 | 784 | * @param PDO $pdo the pdo object |
| 785 | 785 | * @return object DatabaseQueryBuilder |
| 786 | 786 | */ |
| 787 | - public function setPdo(PDO $pdo = null){ |
|
| 787 | + public function setPdo(PDO $pdo = null) { |
|
| 788 | 788 | $this->pdo = $pdo; |
| 789 | 789 | return $this; |
| 790 | 790 | } |
@@ -793,7 +793,7 @@ discard block |
||
| 793 | 793 | * Return the database table prefix |
| 794 | 794 | * @return string |
| 795 | 795 | */ |
| 796 | - public function getPrefix(){ |
|
| 796 | + public function getPrefix() { |
|
| 797 | 797 | return $this->prefix; |
| 798 | 798 | } |
| 799 | 799 | |
@@ -802,7 +802,7 @@ discard block |
||
| 802 | 802 | * @param string $prefix the new prefix |
| 803 | 803 | * @return object DatabaseQueryBuilder |
| 804 | 804 | */ |
| 805 | - public function setPrefix($prefix){ |
|
| 805 | + public function setPrefix($prefix) { |
|
| 806 | 806 | $this->prefix = $prefix; |
| 807 | 807 | return $this; |
| 808 | 808 | } |
@@ -811,7 +811,7 @@ discard block |
||
| 811 | 811 | * Return the database driver |
| 812 | 812 | * @return string |
| 813 | 813 | */ |
| 814 | - public function getDriver(){ |
|
| 814 | + public function getDriver() { |
|
| 815 | 815 | return $this->driver; |
| 816 | 816 | } |
| 817 | 817 | |
@@ -820,7 +820,7 @@ discard block |
||
| 820 | 820 | * @param string $driver the new driver |
| 821 | 821 | * @return object DatabaseQueryBuilder |
| 822 | 822 | */ |
| 823 | - public function setDriver($driver){ |
|
| 823 | + public function setDriver($driver) { |
|
| 824 | 824 | $this->driver = $driver; |
| 825 | 825 | return $this; |
| 826 | 826 | } |
@@ -829,7 +829,7 @@ discard block |
||
| 829 | 829 | * Reset the DatabaseQueryBuilder class attributs to the initial values before each query. |
| 830 | 830 | * @return object the current DatabaseQueryBuilder instance |
| 831 | 831 | */ |
| 832 | - public function reset(){ |
|
| 832 | + public function reset() { |
|
| 833 | 833 | $this->select = '*'; |
| 834 | 834 | $this->from = null; |
| 835 | 835 | $this->where = null; |
@@ -848,12 +848,12 @@ discard block |
||
| 848 | 848 | * |
| 849 | 849 | * @return string |
| 850 | 850 | */ |
| 851 | - protected function getHavingStrIfOperatorIsArray($field, $op = null, $escape = true){ |
|
| 851 | + protected function getHavingStrIfOperatorIsArray($field, $op = null, $escape = true) { |
|
| 852 | 852 | $x = explode('?', $field); |
| 853 | 853 | $w = ''; |
| 854 | - foreach($x as $k => $v){ |
|
| 855 | - if (!empty($v)){ |
|
| 856 | - if (! isset($op[$k])){ |
|
| 854 | + foreach ($x as $k => $v) { |
|
| 855 | + if (!empty($v)) { |
|
| 856 | + if (!isset($op[$k])) { |
|
| 857 | 857 | $op[$k] = ''; |
| 858 | 858 | } |
| 859 | 859 | $w .= $v . (isset($op[$k]) ? $this->escape($op[$k], $escape) : ''); |
@@ -869,15 +869,15 @@ discard block |
||
| 869 | 869 | * |
| 870 | 870 | * @return string |
| 871 | 871 | */ |
| 872 | - protected function getWhereStrIfIsArray(array $where, $type = '', $andOr = 'AND', $escape = true){ |
|
| 872 | + protected function getWhereStrIfIsArray(array $where, $type = '', $andOr = 'AND', $escape = true) { |
|
| 873 | 873 | $_where = array(); |
| 874 | - foreach ($where as $column => $data){ |
|
| 875 | - if (is_null($data)){ |
|
| 874 | + foreach ($where as $column => $data) { |
|
| 875 | + if (is_null($data)) { |
|
| 876 | 876 | $data = ''; |
| 877 | 877 | } |
| 878 | 878 | $_where[] = $type . $column . ' = ' . ($this->escape($data, $escape)); |
| 879 | 879 | } |
| 880 | - $where = implode(' '.$andOr.' ', $_where); |
|
| 880 | + $where = implode(' ' . $andOr . ' ', $_where); |
|
| 881 | 881 | return $where; |
| 882 | 882 | } |
| 883 | 883 | |
@@ -887,12 +887,12 @@ discard block |
||
| 887 | 887 | * |
| 888 | 888 | * @return string |
| 889 | 889 | */ |
| 890 | - protected function getWhereStrIfOperatorIsArray($where, array $op, $type = '', $escape = true){ |
|
| 890 | + protected function getWhereStrIfOperatorIsArray($where, array $op, $type = '', $escape = true) { |
|
| 891 | 891 | $x = explode('?', $where); |
| 892 | 892 | $w = ''; |
| 893 | - foreach($x as $k => $v){ |
|
| 894 | - if (! empty($v)){ |
|
| 895 | - if (isset($op[$k]) && is_null($op[$k])){ |
|
| 893 | + foreach ($x as $k => $v) { |
|
| 894 | + if (!empty($v)) { |
|
| 895 | + if (isset($op[$k]) && is_null($op[$k])) { |
|
| 896 | 896 | $op[$k] = ''; |
| 897 | 897 | } |
| 898 | 898 | $w .= $type . $v . (isset($op[$k]) ? ($this->escape($op[$k], $escape)) : ''); |
@@ -907,15 +907,15 @@ discard block |
||
| 907 | 907 | * |
| 908 | 908 | * @return string |
| 909 | 909 | */ |
| 910 | - protected function getWhereStrForOperator($where, $op = null, $val = null, $type = '', $escape = true){ |
|
| 910 | + protected function getWhereStrForOperator($where, $op = null, $val = null, $type = '', $escape = true) { |
|
| 911 | 911 | $w = ''; |
| 912 | - if (! in_array((string)$op, $this->operatorList)){ |
|
| 913 | - if (is_null($op)){ |
|
| 912 | + if (!in_array((string) $op, $this->operatorList)) { |
|
| 913 | + if (is_null($op)) { |
|
| 914 | 914 | $op = ''; |
| 915 | 915 | } |
| 916 | 916 | $w = $type . $where . ' = ' . ($this->escape($op, $escape)); |
| 917 | 917 | } else { |
| 918 | - if (is_null($val)){ |
|
| 918 | + if (is_null($val)) { |
|
| 919 | 919 | $val = ''; |
| 920 | 920 | } |
| 921 | 921 | $w = $type . $where . $op . ($this->escape($val, $escape)); |
@@ -928,14 +928,14 @@ discard block |
||
| 928 | 928 | * @param string $whereStr the WHERE clause string |
| 929 | 929 | * @param string $andOr the separator type used 'AND', 'OR', etc. |
| 930 | 930 | */ |
| 931 | - protected function setWhereStr($whereStr, $andOr = 'AND'){ |
|
| 932 | - if (empty($this->where)){ |
|
| 931 | + protected function setWhereStr($whereStr, $andOr = 'AND') { |
|
| 932 | + if (empty($this->where)) { |
|
| 933 | 933 | $this->where = $whereStr; |
| 934 | 934 | } else { |
| 935 | - if (substr(trim($this->where), -1) == '('){ |
|
| 935 | + if (substr(trim($this->where), -1) == '(') { |
|
| 936 | 936 | $this->where = $this->where . ' ' . $whereStr; |
| 937 | 937 | } else { |
| 938 | - $this->where = $this->where . ' '.$andOr.' ' . $whereStr; |
|
| 938 | + $this->where = $this->where . ' ' . $andOr . ' ' . $whereStr; |
|
| 939 | 939 | } |
| 940 | 940 | } |
| 941 | 941 | } |
@@ -951,7 +951,7 @@ discard block |
||
| 951 | 951 | * @see DatabaseQueryBuilder::avg |
| 952 | 952 | * @return object |
| 953 | 953 | */ |
| 954 | - protected function select_min_max_sum_count_avg($clause, $field, $name = null){ |
|
| 954 | + protected function select_min_max_sum_count_avg($clause, $field, $name = null) { |
|
| 955 | 955 | $clause = strtoupper($clause); |
| 956 | 956 | $func = $clause . '(' . $field . ')' . (!is_null($name) ? ' AS ' . $name : ''); |
| 957 | 957 | $this->select = ($this->select == '*' ? $func : $this->select . ', ' . $func); |