AEFIS by Age group
| Age group | AEFISs |
|---|---|
| adolescent | 150 |
| adult | 4478 |
| child | 1257 |
| elderly | 161 |
| infant | 303 |
| unknown | 321 |
-
- History
- Session
-
Request +
Request
Cake Params
- plugin(null)
- controllerreports
- actionaefis_by_age
- named(empty)
- pass(empty)
- isAjax(false)
Post data
No post data.
Query string
No querystring data.
Cookie
To view Cookies, add CookieComponent to Controller
Current Route
- keys(array)
- 0controller
- 1action
- options(array)
- defaultRoute(true)
- defaults(array)
- plugin(null)
- template/:controller/:action/*
==== -
Sql Log +
Sql Logs
default
Total Time: 309 ms
Total Queries: 2 queriesQuery Affected Num. rows Took (ms) Actions SELECT ((case when age_months > 0 and age_months < 1 then 'neonate' when age_months < 13 then 'infant' when age_months > 13 then 'child' when year(now()) - right(date_of_birth, 4) between 0 and 1 then 'infant' when year(now()) - right(date_of_birth, 4) between 1 and 10 then 'child' when year(now()) - right(date_of_birth, 4) between 18 and 65 then 'adult' when year(now()) - right(date_of_birth, 4) between 10 and 18 then 'adolescent' when year(now()) - right(date_of_birth, 4) between 65 and 155 then 'elderly' else 'unknown' end)) as ager, COUNT(*) as cnt FROM `pvers`.`aefis` AS `Aefi` WHERE `Aefi`.`submitted` IN (1, 2) AND `Aefi`.`copied` != 1 GROUP BY ((case when age_months > 0 and age_months < 1 then 'neonate' when age_months < 13 then 'infant' when age_months > 13 then 'child' when year(now()) - right(date_of_birth, 4) between 0 and 1 then 'infant' when year(now()) - right(date_of_birth, 4) between 1 and 10 then 'child' when year(now()) - right(date_of_birth, 4) between 18 and 65 then 'adult' when year(now()) - right(date_of_birth, 4) between 10 and 18 then 'adolescent' when year(now()) - right(date_of_birth, 4) between 65 and 155 then 'elderly' else 'unknown' end)) HAVING COUNT(*) > 0 6 6 308 maybe slow SELECT `County`.`id`, `County`.`county_name` FROM `pvers`.`counties` AS `County` WHERE 1 = 1 ORDER BY `County`.`county_name` ASC 58 58 1 Query Explain:
==== -
Timer +
Memory
Peak Memory Use 5.67 MB
Message Memory use Component initialization 2.51 MB Controller action start 2.95 MB Controller render start 3.66 MB View render complete 4.10 MB Timers
Total Request Time: 407 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 16.37 Event: Controller.initialize 2.87 Event: Controller.startup 1.26 Controller action 327.86 Event: Controller.beforeRender 14.83 » Processing toolbar data 14.59 Rendering View 20.44 » Event: View.beforeRender 0.07 » Rendering APP/View/Reports/aefis_by_age.ctp 1.25 » Rendering APP/View/Reports/reports.ctp 14.84 » » Rendering APP/View/Elements/menus/report_public_sidebar.ctp 12.19 » Event: View.afterRender 0.05 » Event: View.beforeLayout 0.05 » Rendering APP/View/Layouts/default.ctp 2.77 Event: View.afterLayout 0.00 ==== - Log
-
Variables +
View Variables
- _serializedata
- data(array)
- 0(array)
- 0(array)
- ageradolescent
- cnt150
- 0(array)
- 1(array)
- 0(array)
- ageradult
- cnt4478
- 0(array)
- 2(array)
- 0(array)
- agerchild
- cnt1257
- 0(array)
- 3(array)
- 0(array)
- agerelderly
- cnt161
- 0(array)
- 4(array)
- 0(array)
- agerinfant
- cnt303
- 0(array)
- 5(array)
- 0(array)
- agerunknown
- cnt321
- 0(array)
- 0(array)
- counties(array)
- 58(null)
- 57(null)
- 56(null)
- 55(null)
- 54(null)
- 53(null)
- 52(null)
- 51(null)
- 50(null)
- 49(null)
- 48(null)
- 30Baringo
- 36Bomet
- 39Bungoma
- 40Busia
- 28Elgeyo/Marakwet
- 14Embu
- 7Garissa
- 43Homa Bay
- 11Isiolo
- 34Kajiado
- 37Kakamega
- 35Kericho
- 22Kiambu
- 3Kilifi
- 20Kirinyaga
- 45Kisii
- 42Kisumu
- 15Kitui
- 2Kwale
- 31Laikipia
- 5Lamu
- 16Machakos
- 17Makueni
- 9Mandera
- 10Marsabit
- 12Meru
- 44Migori
- 1Mombasa
- 21Murang'a
- 47Nairobi County
- 32Nakuru
- 29Nandi
- 33Narok
- 46Nyamira
- 18Nyandarua
- 19Nyeri
- 25Samburu
- 41Siaya
- 6Taita Taveta
- 4Tana River
- 13Tharaka Nithi
- 26Trans Nzoia
- 23Turkana
- 27Uasin Gishu
- 38Vihiga
- 8Wajir
- 24West Pokot
- is_mobile(false)
- root/
- redirdefault
- $request->data(empty)
- $this->validationErrors(array)
- Permission(empty)
- Aro(empty)
- Aco(empty)
- Sadr(empty)
- Aefi(empty)
- County(empty)
- Loaded Helpers(array)
- 0Html
- 1Form
- 2Session
- 3Number
- 4SimpleGraph
- 5DebugTimer
- 6Toolbar
- 7Flash
- 8HtmlToolbar
==== -
Environment +
App Constants
Constant Value CONFIG '/var/www/html/pvers/app/Config/' MEDIA '/var/www/html/pvers/app/webroot/media/' MEDIA_STATIC '/var/www/html/pvers/app/webroot/media/static/' MEDIA_FILTER '/var/www/html/pvers/app/webroot/media/filter/' MEDIA_TRANSFER '/var/www/html/pvers/app/webroot/media/transfer/' MEDIA_UPLOAD_TMP_DIR '/tmp' MEDIA_URL 'media/' MEDIA_STATIC_URL 'media/static/' MEDIA_FILTER_URL 'media/filter/' MEDIA_TRANSFER_URL 'media/transfer/' HTTP_HOST 'pv.pharmacyboardkenya.org' HTTP_BASE 'http://pv.pharmacyboardkenya.org' HTTP_SELF '/app/webroot/index.php' HTTP_URI '/reports/aefis_by_age' CHOWN_PUBLIC (int) 504 LF '' NL '' CR '' TB '' BR '
'WINDOWS false FORMAT_DB_DATETIME 'Y-m-d H:i:s' FORMAT_DB_DATE 'Y-m-d' FORMAT_DB_TIME 'H:i:s' DEFAULT_DATETIME '0000-00-00 00:00:00' DEFAULT_DATE '0000-00-00' DEFAULT_TIME '00:00:00' FILES '/var/www/html/pvers/app/files/' LOCALE '/var/www/html/pvers/app/locale/' CLASS_USER 'User' VALID_ALPHA '/^[a-zA-Z]+$/' VALID_ALPHA_UNDERSCORES '/^[a-zA-Z_]+$/' VALID_ALPHA_MINUS_UNDERSCORES '/^[a-zA-Z_-]+$/' VALID_ALPHA_WHITESPACES '/^[a-zA-Z ]+$/' VALID_ALPHANUMERIC_UNDERSCORES '/^[\da-zA-Z_]+$/' VALID_ALPHANUMERIC_MINUS_UNDERSCORES '/^[\da-zA-Z_-]+$/' VALID_ALPHANUMERIC_WHITESPACES '/^[\da-zA-Z ]+$/' VALID_ALPHANUMERIC_WHITESPACES_UNDERSCORES '/^[\da-zA-Z _]+$/' VALID_NUMERIC_UNDERSCORES '/^[\d_]+$/' VALID_NUMERIC_WHITESPACES '/^[\d ]+$/' VALID_NUMERIC_WHITESPACES_UNDERSCORES '/^[\d _]+$/' VALID_INTEGERS '/^[\d]+$/' FORMAT_NICE_YMDHMS 'd.m.Y, H:i:s' FORMAT_NICE_YMDHM 'd.m.Y, H:i' FORMAT_NICE_YM 'm.Y' FORMAT_NICE_YMD 'd.m.Y' FORMAT_NICE_MD 'd.m.' FORMAT_NICE_D 'd' FORMAT_NICE_W_NUM 'w' FORMAT_NICE_W_ABBR 'D' FORMAT_NICE_W_FULL 'l' FORMAT_NICE_M 'm' FORMAT_NICE_M_ABBR 'M' FORMAT_NICE_M_FULL 'F' FORMAT_NICE_Y_ABBR 'y' FORMAT_NICE_Y 'Y' FORMAT_NICE_HM 'H:i' FORMAT_NICE_HMS 'H:i:s' FORMAT_LOCAL_WA_YMDHMS '%a, %d.%m.%Y, %H:%M:%S' FORMAT_LOCAL_WF_YMDHMS '%A, %d.%m.%Y, %H:%M:%S' FORMAT_LOCAL_WA_YMDHM '%a, %d.%m.%Y, %H:%M' FORMAT_LOCAL_WF_YMDHM '%A, %d.%m.%Y, %H:%M' FORMAT_LOCAL_YMDHMS '%d.%m.%Y, %H:%M:%S' FORMAT_LOCAL_YMDHM '%d.%m.%Y, %H:%M' FORMAT_LOCAL_YMD '%d.%m.%Y' FORMAT_LOCAL_MD '%d.%m.' FORMAT_LOCAL_D '%d' FORMAT_LOCAL_W_NUM '%w' FORMAT_LOCAL_W_ABBR '%a' FORMAT_LOCAL_W_FULL '%A' FORMAT_LOCAL_M '%m' FORMAT_LOCAL_M_ABBR '%b' FORMAT_LOCAL_M_FULL '%B' FORMAT_LOCAL_Y_ABBR '%y' FORMAT_LOCAL_YMS_ABBR '%d.%m.%y' FORMAT_LOCAL_Y '%Y' FORMAT_LOCAL_H '%H' FORMAT_LOCAL_S '%S' FORMAT_LOCAL_HM '%H:%M' FORMAT_LOCAL_HMS '%H:%M:%S' CHAR_LESS '<' CHAR_GREATER '>' CHAR_QUOTE '"' CHAR_APOSTROPHE ''' CHAR_ARROWS '»' CHAR_ARROWS_R '»' CHAR_ARROWS_L '«' CHAR_AVERAGE 'Ø' CHAR_INFIN '∞' CHAR_MILL '‰' CHAR_PLUSMN '±' CHAR_HELLIP '…' CHAR_CIRCA '≈' CHAR_CHECKBOX_EMPTY '☐]' CHAR_CHECKBOX_MAKRED '☑' CHAR_CHECKMARK '✓' CHAR_CHECKMARK_BOLD '✔' CHAR_BALLOT '✗' CHAR_BALLOT_BOLD '✘' CHAR_ABOUT '≈' CHAR_RPIME '′' CHAR_DOUBLE_RPIME '″' CakePHP Constants
Constant Value APP '/var/www/html/pvers/app/' APP_DIR 'app' APPLIBS '/var/www/html/pvers/app/Lib/' CACHE '/var/www/html/pvers/app/tmp/cache/' CAKE '/var/www/html/pvers/lib/Cake/' CAKE_CORE_INCLUDE_PATH '/var/www/html/pvers/lib' CORE_PATH '/var/www/html/pvers/lib/' CAKE_VERSION '2.10.20' CSS '/var/www/html/pvers/app/webroot/css/' CSS_URL 'css/' DS '/' FULL_BASE_URL 'https://pv.pharmacyboardkenya.org' IMAGES '/var/www/html/pvers/app/webroot/img/' IMAGES_URL 'img/' JS '/var/www/html/pvers/app/webroot/js/' JS_URL 'js/' LOGS '/var/www/html/pvers/app/tmp/logs/' ROOT '/var/www/html/pvers' TESTS '/var/www/html/pvers/app/Test/' TMP '/var/www/html/pvers/app/tmp/' VENDORS '/var/www/html/pvers/vendors/' WEBROOT_DIR 'webroot' WWW_ROOT '/var/www/html/pvers/app/webroot/' PHP Environment
Environment Variable Value Php Version '5.6.40-81+ubuntu20.04.1+deb.sury.org+1' Redirect Redirect Https 'on' Redirect Redirect Ssl Tls Sni 'pv.pharmacyboardkenya.org' Redirect Redirect Status '200' Redirect Http Authorization '' Redirect Https 'on' Redirect Ssl Tls Sni 'pv.pharmacyboardkenya.org' Redirect Status '200' Http Authorization '' Https 'on' Ssl Tls Sni 'pv.pharmacyboardkenya.org' Http Accept '*/*' Http User Agent 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' Http Accept Encoding 'gzip, br, zstd, deflate' Http Host 'pv.pharmacyboardkenya.org' Path '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin' Server Signature 'Apache/2.4.41 (Ubuntu) Server at pv.pharmacyboardkenya.org Port 443 ' Server Software 'Apache/2.4.41 (Ubuntu)' Server Name 'pv.pharmacyboardkenya.org' Server Addr '192.168.10.21' Server Port '443' Remote Addr '216.73.216.37' Document Root '/var/www/html/pvers' Request Scheme 'https' Context Prefix '' Context Document Root '/var/www/html/pvers' Server Admin 'webmaster@localhost' Script Filename '/var/www/html/pvers/app/webroot/index.php' Remote Port '40773' Redirect Url '/app/webroot/reports/aefis_by_age' Gateway Interface 'CGI/1.1' Server Protocol 'HTTP/1.1' Request Method 'GET' Query String '' Request Uri '/reports/aefis_by_age' Script Name '/app/webroot/index.php' Php Self '/app/webroot/index.php' Request Time Float (float) 1768750137.943 Request Time (int) 1768750137 ==== -
Include +
Included Files
Include Paths
- 0/var/www/html/pvers/app/Plugin/Media/Lib/mm/src
- 1/var/www/html/pvers/lib
- 3/usr/share/php
- 4-> /var/www/html/pvers/lib/Cake/
Included Files
- core(array)
- Behavior(array)
- 0CORE/Model/Behavior/TreeBehavior.php
- 1CORE/Model/Behavior/ContainableBehavior.php
- Cache(array)
- 0CORE/Cache/Cache.php
- 1CORE/Cache/Engine/FileEngine.php
- 2CORE/Cache/CacheEngine.php
- Component(array)
- 0CORE/Controller/Component/AclComponent.php
- 1CORE/Controller/Component/Acl/DbAcl.php
- 2CORE/Controller/Component/Acl/AclInterface.php
- 3CORE/Controller/Component/RequestHandlerComponent.php
- 4CORE/Controller/Component/SessionComponent.php
- 5CORE/Controller/Component/FlashComponent.php
- 6CORE/Controller/Component/AuthComponent.php
- 7CORE/Controller/Component/Auth/FormAuthenticate.php
- 8CORE/Controller/Component/Auth/BaseAuthenticate.php
- Config(array)
- 0CORE/Config/routes.php
- 1CORE/Config/config.php
- Controller(array)
- 0CORE/Controller/Controller.php
- 1CORE/Controller/ComponentCollection.php
- 2CORE/Controller/Component.php
- Datasource(array)
- 0CORE/Model/Datasource/CakeSession.php
- 1CORE/Model/Datasource/Database/Mysql.php
- 2CORE/Model/Datasource/DboSource.php
- 3CORE/Model/Datasource/DataSource.php
- Error(array)
- 0CORE/Error/exceptions.php
- 1CORE/Error/ErrorHandler.php
- I18n(array)
- 0CORE/I18n/I18n.php
- 1CORE/I18n/L10n.php
- Log(array)
- 0CORE/Log/CakeLog.php
- 1CORE/Log/LogEngineCollection.php
- 2CORE/Log/Engine/FileLog.php
- 3CORE/Log/Engine/BaseLog.php
- 4CORE/Log/CakeLogInterface.php
- Model(array)
- 0CORE/Model/Permission.php
- 1CORE/Model/Model.php
- 2CORE/Model/BehaviorCollection.php
- 3CORE/Model/Aro.php
- 4CORE/Model/AclNode.php
- 5CORE/Model/Aco.php
- 6CORE/Model/ModelBehavior.php
- 7CORE/Model/ConnectionManager.php
- Network(array)
- 0CORE/Network/CakeRequest.php
- 1CORE/Network/CakeResponse.php
- Other(array)
- 0CORE/bootstrap.php
- 1CORE/basics.php
- 2CORE/Core/App.php
- 3CORE/Core/Configure.php
- 4CORE/Core/CakePlugin.php
- 5CORE/Event/CakeEventListener.php
- 6CORE/Event/CakeEvent.php
- 7CORE/Event/CakeEventManager.php
- 8CORE/Core/CakeObject.php
- Routing(array)
- 0CORE/Routing/Dispatcher.php
- 1CORE/Routing/Filter/AssetDispatcher.php
- 2CORE/Routing/DispatcherFilter.php
- 3CORE/Routing/Filter/CacheDispatcher.php
- 4CORE/Routing/Router.php
- 5CORE/Routing/Route/CakeRoute.php
- 6CORE/Routing/Route/PluginShortRoute.php
- Utility(array)
- 0CORE/Utility/Hash.php
- 1CORE/Utility/Inflector.php
- 2CORE/Utility/ObjectCollection.php
- 3CORE/Utility/Debugger.php
- 4CORE/Utility/CakeText.php
- 5CORE/Utility/ClassRegistry.php
- View(array)
- 0CORE/View/HelperCollection.php
- Behavior(array)
- app(array)
- Config(array)
- 0APP/Config/core.php
- 1APP/Config/bootstrap.php
- 2APP/Config/routes.php
- 3APP/Config/database.php
- Controller(array)
- 0APP/Controller/ReportsController.php
- 1APP/Controller/AppController.php
- Model(array)
- 0APP/Model/AppModel.php
- 1APP/Model/Sadr.php
- 2APP/Model/Aefi.php
- 3APP/Model/County.php
- Other(array)
- 0APP/webroot/index.php
- Config(array)
- plugins(array)
- CakePdf(array)
- Config(array)
- 0CakePdf/Config/bootstrap.php
- 1CakePdf/Config/routes.php
- Config(array)
- DebugKit(array)
- Component(array)
- 0DebugKit/Controller/Component/ToolbarComponent.php
- Plugin(array)
- 0DebugKit/Lib/DebugMemory.php
- 1DebugKit/Lib/Panel/HistoryPanel.php
- 2DebugKit/Lib/DebugPanel.php
- 3DebugKit/Lib/Panel/SessionPanel.php
- 4DebugKit/Lib/Panel/RequestPanel.php
- 5DebugKit/Lib/Panel/SqlLogPanel.php
- 6DebugKit/Lib/Panel/TimerPanel.php
- 7DebugKit/Lib/Panel/LogPanel.php
- 8DebugKit/Lib/Log/Engine/DebugKitLog.php
- 9DebugKit/Lib/Panel/VariablesPanel.php
- 10DebugKit/Lib/Panel/EnvironmentPanel.php
- 11DebugKit/Lib/Panel/IncludePanel.php
- 12DebugKit/Lib/DebugTimer.php
- Component(array)
- Media(array)
- Config(array)
- 0Media/Config/bootstrap.php
- Plugin(array)
- 0Media/Lib/mm/src/Mime/Type.php
- 1Media/Lib/mm/src/Mime/Type/Magic/Adapter/Fileinfo.php
- 2Media/Lib/mm/src/Mime/Type/Magic/Adapter.php
- 3Media/Lib/mm/src/Mime/Type/Glob/Adapter/Memory.php
- 4Media/Lib/mm/src/Mime/Type/Glob/Adapter.php
- 5Media/Lib/mm/src/Media/Process.php
- 6Media/Lib/mm/src/Media/Info.php
- Config(array)
- Search(array)
- Component(array)
- 0Search/Controller/Component/PrgComponent.php
- Behavior(array)
- 0Search/Model/Behavior/SearchableBehavior.php
- Component(array)
- Shim(array)
- Config(array)
- 0Shim/Config/bootstrap.php
- Config(array)
- Tools(array)
- Config(array)
- 0Tools/Config/bootstrap.php
- Config(array)
- CakePdf(array)
====