Non-Tariff Barriers :: Complaints

Complaint

Complaint number: NTB-000-006
NTB Type: 7.3. Corruption
Complaint: Multiple Police Checkpoints and harassment in the northern section of the Tema – Paga Corridor . Multiple complaints received from drivers especially from Techiman, Tamale and Babato. The police demand money from the drivers before releasing them though all their documentation are in order. This delays the drivers for very long hours.
Progress update note: Police contacted via phone to deal with specific reported cases. Meeting formally requested with the IGP to work together on a strategic solution to the problem.

Progress :
20th March . Initial meeting held with Ghana Police Service . As other stakeholders have requested for meetings on the same issue, a multi stakeholder meeting will be planned shortly.

Progress :
28th March. A multi stakeholder meeting was held with the police service to review the problem of harassment at multiple police checkpoints along the corridor. Stakeholders included BA, National Facilitation Committee Secretariat, Ghana Ports and Harbors Authority, Trade Hub Network, Burkina Shippers Council, Ghana Shippers Authority. Police Service acknowledged the gravity of the problem and called for an action plan to resolve harassment issue.

Progress :
8th April 2015 . Meeting held to review the multi stakeholder action plan. Actions planned include Corridor Monitoring, Sensitization and Publicity (Stickers and Billboards to publicize Police Service Help lines), Press Release from Ghana Police Service to prohibit stopping of transit vehicles along the corridors, Police Service to issue Directive to enforce wearing of ID by all Police Officers on Duty, design of a compliance document to ensure all truck and cargo requirements are met on departure from Tema Port , caravan on the Kumasi-Paga section of the corridor, meeting with Regional Police Commanders, etc. A follow up meeting is planned within a month.
Policy or regulatory NTB: No
Location: Ghana: Tamale South (Check Points (Road))
Reporting Country: Ghana
Reporting Town
Date of incident: 2014-11-19
Status: In process
Product Description
Product Originating Country
Total value: 0
Date reported: 2014-11-24 13:07
Modified: 2014-11-24 13:10

Borderless Alliance West Africa
Tel: +233 302 762696
E-mail: info@borderlesswa.com
Website: http://borderlesswa.com

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgentd87ede2a7a28973d7f81f4e32c0b97da
  time1713619820
  timeout10
  languageen
====
Request
+ –
Request

Cake Params
- controllercomplaints
- actionview
- uniqueNumberNTB-000-006
- named(empty)
- pass
  id54731176-567c-47ed-8d39-5146c5bdc882
- plugin(null)
- url
  exthtml
  urlcomplaint/NTB-000-006
- form(empty)
- useJsonNative(true)
- isAjax(false)
$_GET
- urlcomplaint/NTB-000-006
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys
  0uniqueNumber
- options(empty)
- defaults
  controllercomplaints
  actionview
  plugin(null)
- template/complaint/:uniqueNumber
- _greedy(false)
- _compiledRoute#^/complaint/(?:([^/]+))[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Complaint`.`id`, `Complaint`.`unique_number`, `Complaint`.`user_id`, `Complaint`.`user_details`, `Complaint`.`user_email`, `Complaint`.`complaint`, `Complaint`.`original_complaint`, `Complaint`.`country_id`, `Complaint`.`town_id`, `Complaint`.`imposing_region_id`, `Complaint`.`reporting_country_id`, `Complaint`.`reporting_region_id`, `Complaint`.`location_type_id`, `Complaint`.`location_id`, `Complaint`.`location_other`, `Complaint`.`date_of_incident`, `Complaint`.`ntb_type_id`, `Complaint`.`ntb_type_other`, `Complaint`.`ntm_code_id`, `Complaint`.`status_id`, `Complaint`.`product_description`, `Complaint`.`country_origin_id`, `Complaint`.`currency_id`, `Complaint`.`value`, `Complaint`.`original_locale`, `Complaint`.`is_spam`, `Complaint`.`resolved_date`, `Complaint`.`created`, `Complaint`.`created_by`, `Complaint`.`modified`, `Complaint`.`modified_by`, `Complaint`.`progress_update`, `Complaint`.`offline`, `Complaint`.`offline_comment`, `Complaint`.`policy`, `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member`, `Town`.`id`, `Town`.`country_id`, `Town`.`name`, `ImposingRegion`.`id`, `ImposingRegion`.`name`, `ReportingCountry`.`id`, `ReportingCountry`.`name`, `ReportingCountry`.`short_name`, `ReportingCountry`.`fre_name`, `ReportingCountry`.`fre_short_name`, `ReportingCountry`.`por_name`, `ReportingCountry`.`por_short_name`, `ReportingCountry`.`currency`, `ReportingCountry`.`member`, `ReportingRegion`.`id`, `ReportingRegion`.`name`, `Currency`.`id`, `Currency`.`name`, `Currency`.`short_name`, `Currency`.`fre_name`, `Currency`.`fre_short_name`, `Currency`.`por_name`, `Currency`.`por_short_name`, `Currency`.`currency`, `Currency`.`member`, `Location`.`id`, `Location`.`name`, `Location`.`location_type_id`, `Location`.`country_id`, `NtbType`.`id`, `NtbType`.`name`, `NtbType`.`short_name`, `NtbType`.`description`, `NtbType`.`parent_id`, `NtbType`.`heading_number`, `NtbType`.`allow`, `NtbType`.`link_id`, `NtbType`.`ntm_code_id`, `NtbType`.`position`, (CONCAT(`NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, '.0. ', '. '), `NtbType`.`name`)) AS `NtbType__headingName`, (CONCAT(IF(`NtbType`.`parent_id` is null, 'Category ', ''), `NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, ': ', '. '), `NtbType`.`name`)) AS `NtbType__fullName`, `NtmCode`.`id`, `NtmCode`.`level`, `NtmCode`.`code`, `NtmCode`.`description`, `NtmCode`.`parent_id`, `OriginatingCountry`.`id`, `OriginatingCountry`.`name`, `OriginatingCountry`.`short_name`, `OriginatingCountry`.`fre_name`, `OriginatingCountry`.`fre_short_name`, `OriginatingCountry`.`por_name`, `OriginatingCountry`.`por_short_name`, `OriginatingCountry`.`currency`, `OriginatingCountry`.`member`, `LocationType`.`id`, `LocationType`.`name`, `LocationType`.`order`, `LocationType`.`select_box`, `Status`.`id`, `Status`.`name`, `Status`.`order`, `Status`.`default`, `Status`.`rejected`, `Status`.`resolved`, `Status`.`nonactionable`, `ResolutionComment`.`id`, `ResolutionComment`.`complaint_id`, `ResolutionComment`.`user_id`, `ResolutionComment`.`comment`, `ResolutionComment`.`resolution`, `ResolutionComment`.`created`, `ResolutionComment`.`modified` FROM `complaints` AS `Complaint` LEFT JOIN `users` AS `User` ON (`Complaint`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Complaint`.`country_id` = `Country`.`id`) LEFT JOIN `towns` AS `Town` ON (`Complaint`.`town_id` = `Town`.`id`) LEFT JOIN `regions` AS `ImposingRegion` ON (`Complaint`.`imposing_region_id` = `ImposingRegion`.`id`) LEFT JOIN `countries` AS `ReportingCountry` ON (`Complaint`.`reporting_country_id` = `ReportingCountry`.`id`) LEFT JOIN `regions` AS `ReportingRegion` ON (`Complaint`.`reporting_region_id` = `ReportingRegion`.`id`) LEFT JOIN `countries` AS `Currency` ON (`Complaint`.`currency_id` = `Currency`.`id`) LEFT JOIN `locations` AS `Location` ON (`Complaint`.`location_id` = `Location`.`id`) LEFT JOIN `ntb_types` AS `NtbType` ON (`Complaint`.`ntb_type_id` = `NtbType`.`id`) LEFT JOIN `ntm_codes` AS `NtmCode` ON (`Complaint`.`ntm_code_id` = `NtmCode`.`id`) LEFT JOIN `countries` AS `OriginatingCountry` ON (`Complaint`.`country_origin_id` = `OriginatingCountry`.`id`) LEFT JOIN `location_types` AS `LocationType` ON (`Complaint`.`location_type_id` = `LocationType`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Complaint`.`status_id` = `Status`.`id`) LEFT JOIN `comments` AS `ResolutionComment` ON (`ResolutionComment`.`complaint_id` = `Complaint`.`id` AND `ResolutionComment`.`resolution` = 1) WHERE `Complaint`.`id` = '54731176-567c-47ed-8d39-5146c5bdc882' ORDER BY `Complaint`.`modified` DESC LIMIT 1	1	1	2	maybe slow
SELECT `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member` FROM `countries` AS `Country` WHERE `Country`.`id` = 'GH'	1	1	0
SELECT `ReportingCountry`.`id`, `ReportingCountry`.`name`, `ReportingCountry`.`short_name`, `ReportingCountry`.`fre_name`, `ReportingCountry`.`fre_short_name`, `ReportingCountry`.`por_name`, `ReportingCountry`.`por_short_name`, `ReportingCountry`.`currency`, `ReportingCountry`.`member` FROM `countries` AS `ReportingCountry` WHERE `ReportingCountry`.`id` = 'GH'	1	1	0
SELECT `Location`.`id`, `Location`.`name`, `Location`.`location_type_id`, `Location`.`country_id` FROM `locations` AS `Location` WHERE `Location`.`id` = '54731103-b688-4036-ae53-5064c5bdc882'	1	1	0
SELECT `NtbType`.`id`, `NtbType`.`name`, `NtbType`.`short_name`, `NtbType`.`description`, `NtbType`.`parent_id`, `NtbType`.`heading_number`, `NtbType`.`allow`, `NtbType`.`link_id`, `NtbType`.`ntm_code_id`, `NtbType`.`position`, (CONCAT(`NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, '.0. ', '. '), `NtbType`.`name`)) AS `NtbType__headingName`, (CONCAT(IF(`NtbType`.`parent_id` is null, 'Category ', ''), `NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, ': ', '. '), `NtbType`.`name`)) AS `NtbType__fullName` FROM `ntb_types` AS `NtbType` WHERE `NtbType`.`id` = 'd68338b6-a31d-11e0-af43-000c292ff614'	1	1	0
SELECT `LocationType`.`id`, `LocationType`.`name`, `LocationType`.`order`, `LocationType`.`select_box` FROM `location_types` AS `LocationType` WHERE `LocationType`.`id` = '4ca358ef-d3a4-4128-a5ba-1c4dc0a80305'	1	1	0
SELECT `Status`.`id`, `Status`.`name`, `Status`.`order`, `Status`.`default`, `Status`.`rejected`, `Status`.`resolved`, `Status`.`nonactionable` FROM `statuses` AS `Status` WHERE `Status`.`id` = '4cc5a0de-c93c-40d5-86de-45b4c0a80305'	1	1	0
SELECT `ResolutionComment`.`id`, `ResolutionComment`.`complaint_id`, `ResolutionComment`.`user_id`, `ResolutionComment`.`comment`, `ResolutionComment`.`resolution`, `ResolutionComment`.`created`, `ResolutionComment`.`modified` FROM `comments` AS `ResolutionComment` WHERE `ResolutionComment`.`complaint_id` = '54731176-567c-47ed-8d39-5146c5bdc882' AND `ResolutionComment`.`resolution` = 1	0	0	0
SELECT `ComplaintsLocale`.`trans_id`, `ComplaintsLocale`.`id`, `ComplaintsLocale`.`complaint`, `ComplaintsLocale`.`locale` FROM `complaints_locales` AS `ComplaintsLocale` WHERE `ComplaintsLocale`.`id` = ('54731176-567c-47ed-8d39-5146c5bdc882')	2	2	0
SELECT `Comment`.`id`, `Comment`.`complaint_id`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`resolution`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`resolution` = 0 AND `Comment`.`complaint_id` = ('54731176-567c-47ed-8d39-5146c5bdc882')	8	8	0
SELECT `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name` FROM `users` AS `User` WHERE `User`.`id` = '5a7084c2-9e58-429d-809c-f72ac5bdc882'	1	1	0
SELECT `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name` FROM `users` AS `User` WHERE `User`.`id` = '5a7087c0-5418-49e0-8f10-f89fc5bdc882'	1	1	0
SELECT `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name` FROM `users` AS `User` WHERE `User`.`id` = '5a70861d-b6d8-4cd5-9a02-f6c7c5bdc882'	1	1	0
SELECT `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name` FROM `users` AS `User` WHERE `User`.`id` = '59831f6f-40e4-40e1-88c0-449dc5bdc882'	1	1	0
SELECT `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name` FROM `users` AS `User` WHERE `User`.`id` = '5a708738-57b0-44d5-8bc5-f16fc5bdc882'	1	1	0
SELECT `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name` FROM `users` AS `User` WHERE `User`.`id` = '58c92486-caec-4165-a8e7-48c9c5bdc882'	1	1	0
SELECT `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name` FROM `users` AS `User` WHERE `User`.`id` = '5979d046-52fc-4603-93e6-4657c5bdc882'	1	1	0
SELECT `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name` FROM `users` AS `User` WHERE `User`.`id` = '5a708809-91e4-4589-8449-fa50c5bdc882'	1	1	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_key` = '5a718d60-86f0-4fcc-ad05-4adfc5bdc882' AND `Attachment`.`class` = 'Comment'	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_key` = '5a718fbc-599c-4924-bb20-4395c5bdc882' AND `Attachment`.`class` = 'Comment'	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_key` = '5a71908a-c71c-41fc-8c7c-4b15c5bdc882' AND `Attachment`.`class` = 'Comment'	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_key` = '5a719501-d650-4020-a23e-4a3ac5bdc882' AND `Attachment`.`class` = 'Comment'	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_key` = '5a71982c-b6a4-48ad-8ce4-42bdc5bdc882' AND `Attachment`.`class` = 'Comment'	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_key` = '5a71a263-a9ac-442c-a7b2-496bc5bdc882' AND `Attachment`.`class` = 'Comment'	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_key` = '5a71a277-5a70-4f04-af89-4dd8c5bdc882' AND `Attachment`.`class` = 'Comment'	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_key` = '5a71eee5-7910-4a9e-b5b3-44ebc5bdc882' AND `Attachment`.`class` = 'Comment'	0	0	0
SELECT `Sms`.`id`, `Sms`.`number`, `Sms`.`user_id`, `Sms`.`complaint_id`, `Sms`.`message`, `Sms`.`incoming`, `Sms`.`read`, `Sms`.`response`, `Sms`.`language`, `Sms`.`parent_id`, `Sms`.`thread_closed`, `Sms`.`created`, `Sms`.`modified` FROM `sms` AS `Sms` WHERE `Sms`.`parent_id` IS NULL AND `Sms`.`complaint_id` = ('54731176-567c-47ed-8d39-5146c5bdc882')	0	0	0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`class` = 'Complaint' AND `Attachment`.`foreign_key` = ('54731176-567c-47ed-8d39-5146c5bdc882')	0	0	0
SELECT `TariffCode`.`id`, `TariffCode`.`heading`, `TariffCode`.`description`, `TariffCode`.`parent_id`, `TariffCode`.`lft`, `TariffCode`.`rght`, (concat(`TariffCode`.`heading`, ": ", `TariffCode`.`description`)) AS `TariffCode__name`, `ComplaintsTariffCode`.`id`, `ComplaintsTariffCode`.`complaint_id`, `ComplaintsTariffCode`.`tariff_code_id` FROM `tariff_codes` AS `TariffCode` JOIN `complaints_tariff_codes` AS `ComplaintsTariffCode` ON (`ComplaintsTariffCode`.`complaint_id` = '54731176-567c-47ed-8d39-5146c5bdc882' AND `ComplaintsTariffCode`.`tariff_code_id` = `TariffCode`.`id`)	0	0	0
SELECT `Region`.`id`, `Region`.`name`, `ComplaintsRegion`.`id`, `ComplaintsRegion`.`complaint_id`, `ComplaintsRegion`.`region_id` FROM `regions` AS `Region` JOIN `complaints_regions` AS `ComplaintsRegion` ON (`ComplaintsRegion`.`complaint_id` = '54731176-567c-47ed-8d39-5146c5bdc882' AND `ComplaintsRegion`.`region_id` = `Region`.`id`)	2	2	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id`, `FocalPoint`.`national_address`, `FocalPoint`.`national_contact_number`, `FocalPoint`.`national_email_address`, `FocalPoint`.`private_address`, `FocalPoint`.`private_contact_number`, `FocalPoint`.`private_email_address`, `ComplaintsFocalPoint`.`id`, `ComplaintsFocalPoint`.`complaint_id`, `ComplaintsFocalPoint`.`focal_point_id` FROM `focal_points` AS `FocalPoint` JOIN `complaints_focal_points` AS `ComplaintsFocalPoint` ON (`ComplaintsFocalPoint`.`complaint_id` = '54731176-567c-47ed-8d39-5146c5bdc882' AND `ComplaintsFocalPoint`.`focal_point_id` = `FocalPoint`.`id`)	2	2	0
SELECT `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member` FROM `countries` AS `Country` WHERE `Country`.`id` = 'BF'	1	1	0
SELECT `NtbType`.`id`, `NtbType`.`name`, `NtbType`.`short_name`, `NtbType`.`description`, `NtbType`.`parent_id`, `NtbType`.`heading_number`, `NtbType`.`allow`, `NtbType`.`link_id`, `NtbType`.`ntm_code_id`, `NtbType`.`position`, (CONCAT(`NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, '.0. ', '. '), `NtbType`.`name`)) AS `NtbType__headingName`, (CONCAT(IF(`NtbType`.`parent_id` is null, 'Category ', ''), `NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, ': ', '. '), `NtbType`.`name`)) AS `NtbType__fullName` FROM `ntb_types` AS `NtbType` WHERE `NtbType`.`allow` = 1 ORDER BY `NtbType`.`position` ASC	77	77	0
SELECT `Status`.`id`, `Status`.`name` FROM `statuses` AS `Status` WHERE 1 = 1 ORDER BY `Status`.`order` ASC	7	7	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

+ –

Memory

Peak Memory Use 14.10 MB

Message	Memory use
Component initialization	10.19 MB
Controller action start	10.24 MB
Controller render start	11.24 MB
View render complete	12.54 MB

Timers

Total Request Time: 348 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	135.12
Component initialization and startup	1.84
Controller action	76.47
» Complaint->find()	56.55
» NtbType->find()	7.88
» NtbType->find() #2	8.05
» Status->find()	0.72
Render Controller Action	35.71
» Rendering View	32.89
» » Rendering APP/views/complaints/view.ctp	14.30
» » » Rendering APP/views/elements/complaints/detail.ctp	1.64
» » » Rendering APP/views/elements/complaints/more_info.ctp	0.31
» » Rendering APP/views/layouts/default.ctp	18.23
» » » Rendering APP/views/elements/dock_menu.ctp	0.37
» » » Rendering APP/views/elements/ntbbanner.ctp	7.89
» » » » Rendering APP/views/elements/login_banner.ctp	5.21
» » » » » Rendering APP/views/elements/login.ctp	4.74
» » » Rendering APP/views/elements/ntbmenu.ctp	8.05
» » » Rendering APP/views/elements/ntbfooter.ctp	0.11

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- localeeng
- complaint
  Complaint
  id54731176-567c-47ed-8d39-5146c5bdc882
  unique_number6
  user_id
  user_detailsDrivers carrying transit goods from Ghana to Burkina Faso are always stopped at the police barrier in Tamale. The police demand money from the drivers before releasing them though all their documentation is in order. This delays the drivers for very long hours.
  user_emailinfo@borderlesswa.com
  complaintMultiple Police Checkpoints and harassment in the northern section of the Tema – Paga Corridor . Multiple complaints received from drivers especially from Techiman, Tamale and Babato. The police demand money from the drivers before releasing them though all their documentation are in order. This delays the drivers for very long hours.
  original_complaintDrivers carrying transit goods from Ghana to Burkina Faso are always stopped at the police barrier in Tamale. The police demand money from the drivers before releasing them though all their documentation is in order. This delays the drivers for very long hours.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idGH
  reporting_region_id
  location_type_id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  location_id54731103-b688-4036-ae53-5064c5bdc882
  location_other
  date_of_incident2014-11-19
  ntb_type_idd68338b6-a31d-11e0-af43-000c292ff614
  ntb_type_other
  ntm_code_id(null)
  status_id4cc5a0de-c93c-40d5-86de-45b4c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date(null)
  created2014-11-24 13:07:34
  created_by54196720-44a0-41b7-8c28-0b21c0a8e186
  modified2014-11-24 13:10:05
  modified_by5a7084c2-9e58-429d-809c-f72ac5bdc882
  progress_updatePolice contacted via phone to deal with specific reported cases. Meeting formally requested with the IGP to work together on a strategic solution to the problem. Progress : 20th March . Initial meeting held with Ghana Police Service . As other stakeholders have requested for meetings on the same issue, a multi stakeholder meeting will be planned shortly. Progress : 28th March. A multi stakeholder meeting was held with the police service to review the problem of harassment at multiple police checkpoints along the corridor. Stakeholders included BA, National Facilitation Committee Secretariat, Ghana Ports and Harbors Authority, Trade Hub Network, Burkina Shippers Council, Ghana Shippers Authority. Police Service acknowledged the gravity of the problem and called for an action plan to resolve harassment issue. Progress : 8th April 2015 . Meeting held to review the multi stakeholder action plan. Actions planned include Corridor Monitoring, Sensitization and Publicity (Stickers and Billboards to publicize Police Service Help lines), Press Release from Ghana Police Service to prohibit stopping of transit vehicles along the corridors, Police Service to issue Directive to enforce wearing of ID by all Police Officers on Duty, design of a compliance document to ensure all truck and cargo requirements are met on departure from Tema Port , caravan on the Kumasi-Paga section of the corridor, meeting with Regional Police Commanders, etc. A follow up meeting is planned within a month.
  offline0
  offline_comment
  policy0
  complaint_languageMultiple Police Checkpoints and harassment in the northern section of the Tema – Paga Corridor . Multiple complaints received from drivers especially from Techiman, Tamale and Babato. The police demand money from the drivers before releasing them though all their documentation are in order. This delays the drivers for very long hours.
  User
  id(null)
  email(null)
  email_authenticated(null)
  email_token(null)
  email_token_expires(null)
  passwd(null)
  password_token(null)
  first_name(null)
  last_name(null)
  gender(null)
  country_id(null)
  telephone_number(null)
  cellphone_number(null)
  fax_number(null)
  sector_id(null)
  sector_other(null)
  locale(null)
  active(null)
  role_id(null)
  login_count(null)
  last_login(null)
  created(null)
  modified(null)
  name(null)
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  Town
  id(null)
  country_id(null)
  name(null)
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ReportingRegion
  id(null)
  name(null)
  Currency
  id(null)
  name(null)
  short_name(null)
  fre_name(null)
  fre_short_name(null)
  por_name(null)
  por_short_name(null)
  currency(null)
  member(null)
  Location
  id54731103-b688-4036-ae53-5064c5bdc882
  nameTamale South
  location_type_id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  country_idGH
  NtbType
  idd68338b6-a31d-11e0-af43-000c292ff614
  name7.3. Corruption
  short_nameCorruption
  description
  parent_id4d4805e3-c914-4902-a2c3-4be142c5ea45
  heading_number7.3
  allow1
  link_id
  ntm_code_id(null)
  position72
  headingName7.3. Corruption
  fullName7.3. Corruption
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  OriginatingCountry
  id(null)
  name(null)
  short_name(null)
  fre_name(null)
  fre_short_name(null)
  por_name(null)
  por_short_name(null)
  currency(null)
  member(null)
  LocationType
  id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  nameCheck Points (Road)
  order1
  select_box1
  Status
  id4cc5a0de-c93c-40d5-86de-45b4c0a80305
  nameIn process
  order4
  default0
  rejected0
  resolved0
  nonactionable0
  ResolutionComment
  id(null)
  complaint_id(null)
  user_id(null)
  comment(null)
  resolution(null)
  created(null)
  modified(null)
  ComplaintsLocale
  0
  trans_id3
  id54731176-567c-47ed-8d39-5146c5bdc882
  complaintMultiple Police Checkpoints and harassment in the northern section of the Tema – Paga Corridor . Multiple complaints received from drivers especially from Techiman, Tamale and Babato. The police demand money from the drivers before releasing them though all their documentation are in order. This delays the drivers for very long hours.
  localefre
  1
  trans_id4
  id54731176-567c-47ed-8d39-5146c5bdc882
  complaint
  localepor
  Comment
  0
  id5a718d60-86f0-4fcc-ad05-4adfc5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  user_id5a7084c2-9e58-429d-809c-f72ac5bdc882
  commentPour le moment rien à signaler au fur et à mesure nous vous tiendrons informer de tout nouveau fait
  resolution0
  created2018-01-31 11:33:20
  modified2018-01-31 11:33:20
  User
  id5a7084c2-9e58-429d-809c-f72ac5bdc882
  emailsawadogoali20032001@yahoo.fr
  email_authenticated1
  email_token
  email_token_expires2018-02-02 11:26:34
  passwd54decdcff9c31ee1c7619a2d817b8b450d8072ecc3ad9aef643ffba1b65f8704
  password_token5a718bca-e338-4e31-bb52-f9e9c5bdc882
  first_nameAli
  last_nameSawadogo
  genderM
  country_idBF
  telephone_number226 70 26 37 65
  cellphone_number
  fax_number
  sector_id2817a98c-3d76-11e4-931c-000c292ff614
  sector_other
  localeeng
  active1
  role_id4cbeb08b-8cb8-454e-9ea3-2dccc0a80305
  login_count3
  last_login2018-06-27 13:07:18
  created2018-01-30 16:44:18
  modified2018-01-30 16:44:18
  nameAli Sawadogo
  Attachment(empty)
  1
  id5a718fbc-599c-4924-bb20-4395c5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  user_id5a7087c0-5418-49e0-8f10-f89fc5bdc882
  commentRien à signaler pour l'instant, nous restons en contact.
  resolution0
  created2018-01-31 11:43:24
  modified2018-01-31 11:43:24
  User
  id5a7087c0-5418-49e0-8f10-f89fc5bdc882
  emailstephane.zombre@cotecna.bf
  email_authenticated1
  email_token
  email_token_expires2018-02-02 10:53:32
  passwd7dd601448de55f2af0c8e5853da18b13ebf2794e84c972f4c3fcce41fdd59b49
  password_token(null)
  first_nameStephane
  last_nameZOMBRE
  genderM
  country_idBF
  telephone_number226 70 28 79 52
  cellphone_number
  fax_number
  sector_id2817a98c-3d76-11e4-931c-000c292ff614
  sector_other
  localeeng
  active1
  role_id4cbeb08b-8cb8-454e-9ea3-2dccc0a80305
  login_count13
  last_login2018-03-26 13:49:02
  created2018-01-30 16:57:04
  modified2018-01-31 10:57:25
  nameStephane ZOMBRE
  Attachment(empty)
  2
  id5a71908a-c71c-41fc-8c7c-4b15c5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  user_id5a70861d-b6d8-4cd5-9a02-f6c7c5bdc882
  commentBien reçu. Nous restons à l'écoute
  resolution0
  created2018-01-31 11:46:50
  modified2018-01-31 11:46:50
  User
  id5a70861d-b6d8-4cd5-9a02-f6c7c5bdc882
  emailkjtyadega@gmail.com
  email_authenticated1
  email_token
  email_token_expires2018-02-02 11:40:06
  passwd529008e7bc873c3825b4155de4f4ac484943d52b6ab76813d266bba975a81f42
  password_token(null)
  first_nameToussaint
  last_nameKAMGABEGA
  genderM
  country_idBF
  telephone_number226 70 25 74 87
  cellphone_number
  fax_number
  sector_id2817a98c-3d76-11e4-931c-000c292ff614
  sector_other
  localeeng
  active1
  role_id4cbeb08b-8cb8-454e-9ea3-2dccc0a80305
  login_count6
  last_login2018-06-27 15:52:18
  created2018-01-30 16:50:05
  modified2018-01-31 11:42:36
  nameToussaint KAMGABEGA
  Attachment(empty)
  3
  id5a719501-d650-4020-a23e-4a3ac5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentLa plainte est reçue. Nous sommes à l'écoute. En cas d'une progression, veuillez nous tenir au courant
  resolution0
  created2018-01-31 12:05:53
  modified2018-01-31 12:05:53
  User
  id59831f6f-40e4-40e1-88c0-449dc5bdc882
  emailgershonewman@gmail.com
  email_authenticated1
  email_token59831f6f-1c28-456e-ba3a-496dc5bdc882
  email_token_expires2018-10-04 10:06:17
  passwdfe8f0176fe2bf9548bdfa3d2d11f2c715833610ff3920b886fe9df75bb97ebc8
  password_token(null)
  first_nameGershon Kokou
  last_nameAGBEVE
  genderM
  country_idGH
  telephone_number0547 38 38 75
  cellphone_number0547 38 38 75
  fax_number
  sector_id28182330-3d76-11e4-931c-000c292ff614
  sector_other
  localeeng
  active1
  role_id4cbeb077-ff6c-4c21-b9e3-2bdbc0a80305
  login_count650
  last_login2024-04-08 15:52:09
  created2017-08-03 15:04:47
  modified2018-10-02 10:09:04
  nameGershon Kokou AGBEVE
  Attachment(empty)
  4
  id5a71982c-b6a4-48ad-8ce4-42bdc5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  user_id5a708738-57b0-44d5-8bc5-f16fc5bdc882
  commentBien reçu
  resolution0
  created2018-01-31 12:19:24
  modified2018-01-31 12:19:24
  User
  id5a708738-57b0-44d5-8bc5-f16fc5bdc882
  emailsulej_oued@yahoo.fr
  email_authenticated1
  email_token
  email_token_expires(null)
  passwd54decdcff9c31ee1c7619a2d817b8b450d8072ecc3ad9aef643ffba1b65f8704
  password_token(null)
  first_nameSouleymane
  last_nameOUEDRAOGO
  genderM
  country_idBF
  telephone_number226 78 05 27 30
  cellphone_number
  fax_number
  sector_id2817a98c-3d76-11e4-931c-000c292ff614
  sector_other
  localeeng
  active1
  role_id4cbeb08b-8cb8-454e-9ea3-2dccc0a80305
  login_count2
  last_login2018-01-31 12:19:24
  created2018-01-30 16:54:48
  modified2018-01-30 16:54:48
  nameSouleymane OUEDRAOGO
  Attachment(empty)
  5
  id5a71a263-a9ac-442c-a7b2-496bc5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  user_id58c92486-caec-4165-a8e7-48c9c5bdc882
  commentMerci de nous tenir au courant.
  resolution0
  created2018-01-31 13:02:59
  modified2018-01-31 13:02:59
  User
  id58c92486-caec-4165-a8e7-48c9c5bdc882
  emailbationo.rakissiwinde@cbc.bf
  email_authenticated1
  email_token58c92486-3280-4c19-b8ce-4b48c5bdc882
  email_token_expires2020-01-19 19:18:13
  passwd886d96e8aec1e1d469d56425e260faf8f63684d60d1f45b826fc24b9b3a5b3a2
  password_token5e21ec55-782c-418e-bed2-d283c5bdc882
  first_nameBATIONO
  last_nameRakissiwindé
  genderM
  country_idBF
  telephone_number00233303202392
  cellphone_number00233263080374
  fax_number
  sector_id28182330-3d76-11e4-931c-000c292ff614
  sector_other
  localeeng
  active1
  role_id4cbeb08b-8cb8-454e-9ea3-2dccc0a80305
  login_count147
  last_login2021-06-10 17:29:14
  created2017-03-15 13:24:54
  modified2017-09-04 14:22:24
  nameBATIONO Rakissiwindé
  Attachment(empty)
  6
  id5a71a277-5a70-4f04-af89-4dd8c5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  user_id5979d046-52fc-4603-93e6-4657c5bdc882
  commentPlainte bien reçue
  resolution0
  created2018-01-31 13:03:19
  modified2018-01-31 13:03:19
  User
  id5979d046-52fc-4603-93e6-4657c5bdc882
  emailcofenabvi_ao@yahoo.fr
  email_authenticated1
  email_token5979d046-f630-4465-a7bc-4dd8c5bdc882
  email_token_expires2017-08-03 13:36:38
  passwdd27c93d02660bd314b5ddea9ea47ed5e0603ba4ebeebeb2204ae3a8d2dd57444
  password_token
  first_nameTimbila Thomas
  last_nameSAWADOGO
  genderM
  country_idBF
  telephone_number+22670205237
  cellphone_number+22667903595
  fax_number
  sector_id2818367c-3d76-11e4-931c-000c292ff614
  sector_other
  localeeng
  active1
  role_id4cbeb08b-8cb8-454e-9ea3-2dccc0a80305
  login_count2
  last_login2018-02-26 17:32:57
  created2017-07-27 13:36:38
  modified2017-07-27 14:15:20
  nameTimbila Thomas SAWADOGO
  Attachment(empty)
  7
  id5a71eee5-7910-4a9e-b5b3-44ebc5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  user_id5a708809-91e4-4589-8449-fa50c5bdc882
  commentbonjour à tous, plainte bien reçu.
  resolution0
  created2018-01-31 18:29:25
  modified2018-01-31 18:29:25
  User
  id5a708809-91e4-4589-8449-fa50c5bdc882
  emailadeline.zomawalbeogo@cotecna.bf
  email_authenticated1
  email_token
  email_token_expires2018-02-02 18:24:07
  passwd85e93362028dcb12005fee3d39c6b9f18170b35353a8cfbdbee182569c881db4
  password_token(null)
  first_nameAdeline
  last_nameKABORE
  genderM
  country_idBF
  telephone_number226 70 20 64 56
  cellphone_number
  fax_number
  sector_id2817a98c-3d76-11e4-931c-000c292ff614
  sector_other
  localeeng
  active1
  role_id4cbeb08b-8cb8-454e-9ea3-2dccc0a80305
  login_count6
  last_login2018-01-31 18:27:49
  created2018-01-30 16:58:17
  modified2018-01-31 18:24:53
  nameAdeline KABORE
  Attachment(empty)
  Sms(empty)
  Attachment(empty)
  TariffCode(empty)
  Region
  0
  id08391dd0-3d26-11e4-916c-0800200c9a66
  nameECOWAS
  ComplaintsRegion
  id54731176-812c-462d-8f6e-5146c5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  region_id08391dd0-3d26-11e4-916c-0800200c9a66
  1
  id08391dd0-3d26-11e4-916c-0800201c9a66
  nameUEMOA
  ComplaintsRegion
  id54731176-925c-4833-84d2-5146c5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  region_id08391dd0-3d26-11e4-916c-0800201c9a66
  FocalPoint
  0
  id5417da69-13d8-49d0-ad22-3ac9c0a80305
  country_idGH
  national_address
  national_contact_number
  national_email_address
  private_address
  private_contact_number
  private_email_address
  ComplaintsFocalPoint
  id54731176-e88c-4411-83f8-5146c5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  focal_point_id5417da69-13d8-49d0-ad22-3ac9c0a80305
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  1
  id5418fa29-b610-4f6a-bb28-0612c0a8e186
  country_idBF
  national_address
  national_contact_number
  national_email_address
  private_address
  private_contact_number
  private_email_address
  ComplaintsFocalPoint
  id54731176-d7c0-433a-8ad5-5146c5bdc882
  complaint_id54731176-567c-47ed-8d39-5146c5bdc882
  focal_point_id5418fa29-b610-4f6a-bb28-0612c0a8e186
  Country
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
- ntbTypes
  Category 1. Government participation in trade & restrictive practices tolerated by governments
  4e09b8bd-a198-4b79-a9e5-103ec0a803051.1. Export subsidies
  4e09b8d1-1fec-47ef-920c-0f53c0a803051.2. Government monopoly in export/import
  4e0c68dc-5dcc-48dd-b6f3-6f9ac0a803051.3. State subsidies, procurement, trading, state ownership
  d67edb0e-a31d-11e0-af43-000c292ff6141.4. Preference given to domestic bidders/suppliers
  d67f1ce0-a31d-11e0-af43-000c292ff6141.5. Requirement for counter trade
  d67f2f64-a31d-11e0-af43-000c292ff6141.6. Domestic assistance programmes for companies
  d67f409e-a31d-11e0-af43-000c292ff6141.7. Discriminatory or flawed government procurement policies
  d67f5336-a31d-11e0-af43-000c292ff6141.8. Import bans
  d67f645c-a31d-11e0-af43-000c292ff6141.9. Determination of eligibility of an exporting country by the importing country
  d67f765e-a31d-11e0-af43-000c292ff6141.10. Determination of eligibility of an exporting establishment (firm, company) by the importing country
  d67f886a-a31d-11e0-af43-000c292ff6141.11. Occupational safety and health regulation
  d67f9ac6-a31d-11e0-af43-000c292ff6141.12. Multiplicity and Controls of Foreign exchange market
  d67faca0-a31d-11e0-af43-000c292ff6141.13. "Buy national" policy
  d67fbe7a-a31d-11e0-af43-000c292ff6141.14. Lack of coordination between government institutions
  d67fcfd2-a31d-11e0-af43-000c292ff6141.15. Other
  Category 2. Customs and administrative entry procedures
  d67fe0da-a31d-11e0-af43-000c292ff6142.1. Government imposing antidumping duties
  d67ff28c-a31d-11e0-af43-000c292ff6142.2. Arbitrary customs classification
  d6800362-a31d-11e0-af43-000c292ff6142.3. Issues related to the rules of origin
  d68015a0-a31d-11e0-af43-000c292ff6142.4. Import licensing
  d6802680-a31d-11e0-af43-000c292ff6142.5. Decreed customs surcharges
  d6803846-a31d-11e0-af43-000c292ff6142.6. Additional taxes and other charges
  d6804962-a31d-11e0-af43-000c292ff6142.7. International taxes and charges levied on imports and other tariff measures
  d6805b28-a31d-11e0-af43-000c292ff6142.8. Lengthy and costly customs clearance procedures
  d6806c12-a31d-11e0-af43-000c292ff6142.9. Issues related to transit fees
  d6807ed2-a31d-11e0-af43-000c292ff6142.10. Inadequate or unreasonable customs procedures and charges
  d6808fee-a31d-11e0-af43-000c292ff6142.11. Lack of control in Customs infrastructure
  d680a0c4-a31d-11e0-af43-000c292ff6142.12. Lack of capacity of Customs officers
  d680b2d0-a31d-11e0-af43-000c292ff6142.13. Issues related to Pre-Shipment Inspections
  d680c3e2-a31d-11e0-af43-000c292ff6142.14. Other
  4d480568-810c-43b9-8f97-7ce442c5ea45Category 3. Technical barriers to trade (TBT)
  4d480586-bc1c-4f01-b5e3-2e1442c5ea45Category 4. Sanitary & phyto-sanitary (SPS) measures
  Category 5. Specific limitations
  d681956a-a31d-11e0-af43-000c292ff6145.1. Quantitative restrictions
  d681a65e-a31d-11e0-af43-000c292ff6145.2. Exchange controls
  d681b82e-a31d-11e0-af43-000c292ff6145.3. Export taxes
  d681c922-a31d-11e0-af43-000c292ff6145.4. Quotas
  d681da02-a31d-11e0-af43-000c292ff6145.5. Import licensing requirements
  d681ec2c-a31d-11e0-af43-000c292ff6145.6. Proportion restrictions of foreign to domestic goods (local content requirement)
  d681fd3e-a31d-11e0-af43-000c292ff6145.7. Minimum import price limits
  d6820f18-a31d-11e0-af43-000c292ff6145.8. Embargoes
  d682205c-a31d-11e0-af43-000c292ff6145.9. Non-automatic licensing
  d6823254-a31d-11e0-af43-000c292ff6145.10. Prohibitions
  d68243c0-a31d-11e0-af43-000c292ff6145.11. Quantitative safeguard measures
  d68255d6-a31d-11e0-af43-000c292ff6145.12. Export restraint arrangements
  d68266fc-a31d-11e0-af43-000c292ff6145.13. Other quantity control measures
  d682785e-a31d-11e0-af43-000c292ff6145.14. Restrictive licenses
  d6828a60-a31d-11e0-af43-000c292ff6145.15. Other
  Category 6. Charges on imports
  d6829b5e-a31d-11e0-af43-000c292ff6146.1. Prior import deposits and subsidies
  d682ad1a-a31d-11e0-af43-000c292ff6146.2. Administrative fees
  d682be86-a31d-11e0-af43-000c292ff6146.3. Special supplementary duties
  d682d088-a31d-11e0-af43-000c292ff6146.4. Import credit discriminations
  d682e1cc-a31d-11e0-af43-000c292ff6146.5. Variable levies
  d682f3a6-a31d-11e0-af43-000c292ff6146.6. Border taxes
  d68304c2-a31d-11e0-af43-000c292ff6146.7. Other
  Category 7. Other procedural problems
  d683170a-a31d-11e0-af43-000c292ff6147.1. Arbitrariness
  d68327ea-a31d-11e0-af43-000c292ff6147.2. Discrimination
  d68338b6-a31d-11e0-af43-000c292ff6147.3. Corruption
  d6834a68-a31d-11e0-af43-000c292ff6147.4. Costly procedures
  d6835b66-a31d-11e0-af43-000c292ff6147.5. Lengthy procedures
  d6836d2c-a31d-11e0-af43-000c292ff6147.6. Lack of information on procedures (or changes thereof)
  d6837e48-a31d-11e0-af43-000c292ff6147.7. Complex variety of documentation required
  d683902c-a31d-11e0-af43-000c292ff6147.8. Consular and Immigration Issues
  d683a134-a31d-11e0-af43-000c292ff6147.9. Inadequate trade related infrastructure
  d683c1aa-a31d-11e0-af43-000c292ff6147.10. Other
  Category 8. Transport, Clearing and Forwarding
  134ae3f8-9813-11e1-be2a-00e08128b0718.1. Government Policy and regulations
  13746138-9813-11e1-be2a-00e08128b0718.2. Administrative (Border Operating Hours, delays at border posts, etc.)
  139dea58-9813-11e1-be2a-00e08128b0718.3. Immigration requirements (Visa, travel permit)
  13c9ccfe-9813-11e1-be2a-00e08128b0718.4. Transport related corruption
  13f328f6-9813-11e1-be2a-00e08128b0718.5. Infrastructure (Air, Port, Rail, Road, Border Posts,)
  141e6da4-9813-11e1-be2a-00e08128b0718.6. Vehicle standards
  d683b2f0-a31d-11e0-af43-000c292ff6148.7. Costly Road user charges /fees
  3746f9d4-98f6-11e1-be2a-00e08128b0718.8. Issues related to transit
  otherOther
- statuses
  4cc5a0be-045c-4434-a342-43b5c0a80305New (Not reviewed)
  4cc5a0cb-edc4-4985-80f5-43b5c0a80305New
  4cc5a0d7-d800-431b-8087-45b5c0a80305Complaint registered with REC
  4cc5a0de-c93c-40d5-86de-45b4c0a80305In process
  4cc5a0e4-33ec-4f36-a85c-4278c0a80305Resolved
  4cc5a0f0-4218-4545-8158-4343c0a80305Rejected
  eedcc546-eebf-102e-b869-00e08128b071Non-actionable
- currentUser(null)
- defaultLanguageEnglish
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0simpleGraph
  1htmlToolbar
  2toolbar
  3number
  4filter
  5text
  6time
  7form
  8session
  9html
====

Non-Tariff Barriers

Reporting, Monitoring and Eliminating Mechanism

Complaint

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables