Non-Tariff Barriers :: Complaints

Complaint number	NTB Type Category 1. Government participation in trade & restrictive practices tolerated by governments 1.1. Export subsidies 1.2. Government monopoly in export/import 1.3. State subsidies, procurement, trading, state ownership 1.4. Preference given to domestic bidders/suppliers 1.5. Requirement for counter trade 1.6. Domestic assistance programmes for companies 1.7. Discriminatory or flawed government procurement policies 1.8. Import bans 1.9. Determination of eligibility of an exporting country by the importing country 1.10. Determination of eligibility of an exporting establishment (firm, company) by the importing country 1.11. Occupational safety and health regulation 1.12. Multiplicity and Controls of Foreign exchange market 1.13. "Buy national" policy 1.14. Lack of coordination between government institutions 1.15. Other Category 2. Customs and administrative entry procedures 2.1. Government imposing antidumping duties 2.2. Arbitrary customs classification 2.3. Issues related to the rules of origin 2.4. Import licensing 2.5. Decreed customs surcharges 2.6. Additional taxes and other charges 2.7. International taxes and charges levied on imports and other tariff measures 2.8. Lengthy and costly customs clearance procedures 2.9. Issues related to transit fees 2.10. Inadequate or unreasonable customs procedures and charges 2.11. Lack of control in Customs infrastructure 2.12. Lack of capacity of Customs officers 2.13. Issues related to Pre-Shipment Inspections 2.14. Other Category 3. Technical barriers to trade (TBT) Category 4. Sanitary & phyto-sanitary (SPS) measures Category 5. Specific limitations 5.1. Quantitative restrictions 5.2. Exchange controls 5.3. Export taxes 5.4. Quotas 5.5. Import licensing requirements 5.6. Proportion restrictions of foreign to domestic goods (local content requirement) 5.7. Minimum import price limits 5.8. Embargoes 5.9. Non-automatic licensing 5.10. Prohibitions 5.11. Quantitative safeguard measures 5.12. Export restraint arrangements 5.13. Other quantity control measures 5.14. Restrictive licenses 5.15. Other Category 6. Charges on imports 6.1. Prior import deposits and subsidies 6.2. Administrative fees 6.3. Special supplementary duties 6.4. Import credit discriminations 6.5. Variable levies 6.6. Border taxes 6.7. Other Category 7. Other procedural problems 7.1. Arbitrariness 7.2. Discrimination 7.3. Corruption 7.4. Costly procedures 7.5. Lengthy procedures 7.6. Lack of information on procedures (or changes thereof) 7.7. Complex variety of documentation required 7.8. Consular and Immigration Issues 7.9. Inadequate trade related infrastructure 7.10. Other Category 8. Transport, Clearing and Forwarding 8.1. Government Policy and regulations 8.2. Administrative (Border Operating Hours, delays at border posts, etc.) 8.3. Immigration requirements (Visa, travel permit) 8.4. Transport related corruption 8.5. Infrastructure (Air, Port, Rail, Road, Border Posts,) 8.6. Vehicle standards 8.7. Costly Road user charges /fees 8.8. Issues related to transit Other Policy or Regulatory NTB Not a policy or regulatory NTB Check allUncheck all	Date of incident	Location ECOWAS Benin Burkina Faso Côte d'Ivoire Ghana Nigeria Senegal Togo ECOWAS UEMOA	Reporting country or region ECOWAS Benin Burkina Faso Côte d'Ivoire Ghana Nigeria Senegal Togo ECOWAS UEMOA	Status	Actions
NTB-000-417	Misunderstanding between driver and Officer	2023-07-13	Ghana: Entrance Tamale Police barrier (BF to GH)	Burkina Faso	Resolved 2023-07-13	View
Complaint:	The driver's Carte grise was exchanged with another at the entrance of Walewale without his knowledge. At this barrier, the mistake was noticed by the Police. The driver tried to explain to the officers in vain. So he reported to GSA.
Resolution status note:	The driver was released few minutes after this conversation
NTB-000-418	Immigration Officers requesting drivers to pay GH 10.00	2023-09-13	Ghana: Immigration Techiman toll boot	Burkina Faso	Resolved 2023-09-13	View
Complaint:	Immigration Officers at Techiman toll boot stopped four (4) trucks and asked them to pay GH 10.00 each. When the drivers said they did not have money, the Officers demanded that the drivers' mated provide their ID cards. After providing the ID cards, the Officers claimed that the ID cards should have been stamped by their officials at the border.
Resolution status note:	Few minutes after this intervention, the drivers were released.
NTB-000-419	8.8. Issues related to transit	2023-09-23	Ghana: Walewale Police	Burkina Faso	Resolved 2023-09-23	View
Complaint:	The Police requested the driver to GH 5.00 without any explanation
Resolution status note:	After this interaction, the driver was released.
NTB-000-420	Extortion of money by Police	2023-09-24	Ghana: Pong Tamale	Burkina Faso	Resolved 2023-09-24	View
Complaint:	The Police stopped the driver and requested that he pays GH 10.00 because according to the police the driver's carte grise is not authentic. The driver reported to GSA.
Resolution status note:	After this intervention the Police took GSA staff's number and released the driver.
NTB-000-421	Unnecessary delay and attempt of extortion	2023-10-19	Ghana: MTTD Kumasi (town)	Burkina Faso	Resolved 2023-10-19	View
Complaint:	Police stopped the driver and claimed to have received a signal from his colleagues that the driver drove through the red light. The driver agued that he never did and suggested a check from the monitor conected to the camera.
Resolution status note:	While GSA staff was uploading the complaint unto the platform, the driver called to report that the officers asked him to pay money and go but he told them until the truth is disclosed he wouldn't pay anything. Upon hearing this the Police released the driver.
NTB-000-423	Police verbal and physical harassments (handcuffing of driver)	2023-10-24	Ghana: Police barrier, few km to Nasia (GH - GH)	Burkina Faso	Resolved 2023-10-24	View
Complaint:	The Police stopped the driver checked his papers and proceeded to check inside the truck. Upon finding scissors in the truck, the Police handcuffed the driver against a tree. This is because the officer claimed he suspected that the driver uses the scissors to cut indian herb.
Resolution status note:	The driver was released after GSA intervention
NTB-000-424	Unnecessary delay, Police seized driver's papers for more than an hour without any reason	2023-10-31	Ghana: Sogakope Police	Togo	Resolved 2023-10-31	View
Complaint:	The Police stopped the driver and proceeded with checks on the truck and papers. They took the papers and left the driver in Sogakope town without giving any clue as to where they were going.
Resolution status note:	We are once again calling on the Police Administration to assist in the facilitation of Transit Trade in Ghana by desisting from harassing and extorting money from transit drivers.
NTB-000-425	Customs Officers demandind for money	2023-11-04	Ghana: Customs Navrongo	Burkina Faso	Resolved 2023-11-04	View
Complaint:	The driver coming from Burkina Faso was asked by Customs at Navrongo to pay money.
Resolution status note:	The driver was released
NTB-000-427	Extortion by Customs	2023-11-30	Ghana: Nsutem Customs Checkpoint	Burkina Faso	Resolved 2023-11-30	View
Complaint:	Nsutem Customs officers stopped about forty (40) tankers and insisted that they pay GH 5.00 each. Since the drivers were not willing to pay the requested amount, the drivers' papers were seized from 6am till after 8am when the drivers reported to GSA.
Resolution status note:	The drivers were released by the intervention of GSA through their contact person at the Customs Office.
NTB-000-431	Police Extortion of money	2024-03-15	Ghana: Police checkpoint before Nasia (GH-BF)	Burkina Faso	Resolved 2024-03-15	View
Complaint:	The Police stopped the driver, took his papers and claimed the driver's Carte Grise and Permis International are fake. The Police later on requested driver to pay GH 100.00, amount which was reduced to GH 50.00
Resolution status note:	After this explanation, the driver was released without paying any money.

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

Cake Params
- controllercomplaints
- actionindex
- named
  page19
  sortdate_of_incident
  directionasc
  resolved1
- pass(empty)
- resolved1
- plugin(null)
- url
  exthtml
  urlresolved_complaints/page:19/sort:date_of_incident/direction:asc
- form(empty)
- useJsonNative(true)
- isAjax(false)
- paging
  Complaint
  page19
  current10
  count370
  prevPage(true)
  nextPage(false)
  pageCount19
  defaults
  limit20
  step1
  order
  Complaint.unique_numberdesc
  conditions
  Status.default0
  Status.rejected0
  Status.resolved1
  Status.nonactionable0
  contain
  0Country
  1ImposingRegion
  2LocationType
  3Location
  4NtbType
  5NtmCode
  6ReportingCountry
  7ReportingRegion
  8Status
  9TariffCode
  10ComplaintsLocale
  11ResolutionComment
  options
  page19
  limit20
  order
  Complaint.date_of_incidentasc
  conditions
  Status.default0
  Status.rejected0
  Status.resolved1
  Status.nonactionable0
  contain
  0Country
  1ImposingRegion
  2LocationType
  3Location
  4NtbType
  5NtmCode
  6ReportingCountry
  7ReportingRegion
  8Status
  9TariffCode
  10ComplaintsLocale
  11ResolutionComment
$_GET
- urlresolved_complaints/page:19/sort:date_of_incident/direction:asc
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options
  named
  resolved1
- defaults
  controllercomplaints
  actionindex
  resolved1
  plugin(null)
- template/resolved_complaints/*
- _greedy(true)
- _compiledRoute#^/resolved_complaints(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
  typecontent_type
  methodrequest_method
  serverserver_name
====

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `aros`	7	7	1	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
SHOW FULL COLUMNS FROM `acos`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `aros_acos`	9	9	1	maybe slow
SHOW FULL COLUMNS FROM `complaints`	35	35	1
SHOW FULL COLUMNS FROM `users`	23	23	1
SHOW FULL COLUMNS FROM `countries`	9	9	1	maybe slow
SHOW FULL COLUMNS FROM `focal_points`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `regions`	2	2	1	maybe slow
SHOW FULL COLUMNS FROM `complaints_regions`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `regions_users`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `focal_points_regions`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `focal_points_users`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `complaints_focal_points`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `towns`	3	3	1	maybe slow
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
SHOW FULL COLUMNS FROM `sectors`	2	2	1	maybe slow
SHOW FULL COLUMNS FROM `sectors_locales`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `roles`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `comments`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `attachments`	8	8	1	maybe slow
SHOW FULL COLUMNS FROM `location_types`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `locations`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `location_types_locales`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `ntb_types`	10	10	1	maybe slow
SHOW FULL COLUMNS FROM `ntb_types_locales`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `statuses`	7	7	1	maybe slow
SHOW FULL COLUMNS FROM `statuses_locales`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `ntm_codes`	5	5	1	maybe slow
SHOW FULL COLUMNS FROM `complaints_locales`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `sms`	13	13	1	maybe slow
SHOW FULL COLUMNS FROM `tariff_codes`	6	6	1	maybe slow
SHOW FULL COLUMNS FROM `complaints_tariff_codes`	3	3	1	maybe slow
SHOW FULL COLUMNS FROM `tariff_codes_locales`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `emails`	4	4	1	maybe slow
SELECT COUNT(*) AS `count` FROM `complaints` AS `Complaint` LEFT JOIN `countries` AS `Country` ON (`Complaint`.`country_id` = `Country`.`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 `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 `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 `Status`.`default` = 0 AND `Status`.`rejected` = 0 AND `Status`.`resolved` = 1 AND `Status`.`nonactionable` = 0	1	1	0
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`, `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`, `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`, `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`, `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 `countries` AS `Country` ON (`Complaint`.`country_id` = `Country`.`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 `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 `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 `Status`.`default` = 0 AND `Status`.`rejected` = 0 AND `Status`.`resolved` = 1 AND `Status`.`nonactionable` = 0 ORDER BY `Complaint`.`date_of_incident` asc LIMIT 360, 20	10	10	0
SELECT `ComplaintsLocale`.`trans_id`, `ComplaintsLocale`.`id`, `ComplaintsLocale`.`complaint`, `ComplaintsLocale`.`locale` FROM `complaints_locales` AS `ComplaintsLocale` WHERE `ComplaintsLocale`.`id` IN ('64afe97b-d8bc-4e77-b2d3-aac2c5bdc882', '6501cb0c-bcd0-43bd-91ee-cd23c5bdc882', '6513e03b-b094-4e31-ae24-0823c5bdc882', '6513e3bb-d770-4a01-bb73-1fedc5bdc882', '653137b3-9d30-4aee-85d3-4f23c5bdc882', '6537b9b6-0ecc-4fdc-8e07-9762c5bdc882', '6540f859-3574-4586-93c2-fea4c5bdc882', '6548a158-9e88-45f6-8dab-2540c5bdc882', '6568598b-f2cc-485e-98f9-0772c5bdc882', '65f44839-f390-4482-9980-3860c5bdc882')	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` IN ('64afe97b-d8bc-4e77-b2d3-aac2c5bdc882', '6501cb0c-bcd0-43bd-91ee-cd23c5bdc882', '6513e03b-b094-4e31-ae24-0823c5bdc882', '6513e3bb-d770-4a01-bb73-1fedc5bdc882', '653137b3-9d30-4aee-85d3-4f23c5bdc882', '6537b9b6-0ecc-4fdc-8e07-9762c5bdc882', '6540f859-3574-4586-93c2-fea4c5bdc882', '6548a158-9e88-45f6-8dab-2540c5bdc882', '6568598b-f2cc-485e-98f9-0772c5bdc882', '65f44839-f390-4482-9980-3860c5bdc882') AND `ComplaintsTariffCode`.`tariff_code_id` = `TariffCode`.`id`)	0	0	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`, `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `countries` AS `Country` LEFT JOIN `focal_points` AS `FocalPoint` ON (`FocalPoint`.`country_id` = `Country`.`id`) WHERE `Country`.`member` = 1 ORDER BY `name` ASC	15	15	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'BJ'	1	1	0
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da7b-3aac-4895-879c-3ac9c0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`)	1	1	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'BF'	1	1	0
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5418fa29-b610-4f6a-bb28-0612c0a8e186' AND `FocalPointsRegion`.`region_id` = `Region`.`id`)	1	1	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'CV'	0	0	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'CI'	1	1	0
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da84-7460-4ef7-9eb6-39fac0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`)	1	1	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'GM'	0	0	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'GH'	1	1	0
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da69-13d8-49d0-ad22-3ac9c0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`)	1	1	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'GN'	0	0	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'GW'	0	0	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'LR'	0	0	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'ML'	0	0	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'NE'	0	0	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'NG'	1	1	0
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da8c-b374-4d89-96a0-39f9c0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`)	1	1	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'SN'	1	1	0
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5418fa08-f9f0-4b67-9e2d-0545c0a8e186' AND `FocalPointsRegion`.`region_id` = `Region`.`id`)	1	1	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'SL'	0	0	0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id` FROM `focal_points` AS `FocalPoint` WHERE `FocalPoint`.`country_id` = 'TG'	1	1	0
SELECT `Region`.`name`, `FocalPointsRegion`.`id`, `FocalPointsRegion`.`focal_point_id`, `FocalPointsRegion`.`region_id` FROM `regions` AS `Region` JOIN `focal_points_regions` AS `FocalPointsRegion` ON (`FocalPointsRegion`.`focal_point_id` = '5417da95-21e4-4eff-8899-39f8c0a80305' AND `FocalPointsRegion`.`region_id` = `Region`.`id`)	1	1	0
SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE 1 = 1	2	2	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 `Status`.`default` = 0 AND `Status`.`rejected` = 0 ORDER BY `Status`.`order` ASC	5	5	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 16.06 MB

Message	Memory use
Component initialization	10.20 MB
Controller action start	10.26 MB
Controller render start	11.31 MB
View render complete	13.16 MB

Timers

Total Request Time: 424 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	256.99
Component initialization and startup	1.43
Controller action	37.84
» Complaint->find()	4.54
» Complaint->find() #2	14.28
» Country->find()	4.05
» Region->find()	0.21
» NtbType->find()	3.67
» NtbType->find() #2	3.77
» Status->find()	0.41
» Status->find() #2	0.26
Render Controller Action	52.23
» Rendering View	50.44
» » Rendering APP/views/complaints/index.ctp	40.07
» » » Rendering CORE/plugins/octoplus/views/elements/paging.ctp	3.19
» » Rendering APP/views/layouts/default.ctp	10.18
» » » Rendering APP/views/elements/dock_menu.ctp	0.21
» » » Rendering APP/views/elements/ntbbanner.ctp	4.29
» » » » Rendering APP/views/elements/login_banner.ctp	2.83
» » » » » Rendering APP/views/elements/login.ctp	2.56
» » » Rendering APP/views/elements/ntbmenu.ctp	4.57
» » » Rendering APP/views/elements/ntbfooter.ctp	0.07

====

Log
+ –

Logs

====
Variables
+ –
View Variables
- localeeng
- countries
  ECOWAS
  BJBenin
  BFBurkina Faso
  CICôte d'Ivoire
  GHGhana
  NGNigeria
  SNSenegal
  TGTogo
- 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
  policyPolicy or Regulatory NTB
  notPolicyNot a policy or regulatory NTB
- statuses
  4cc5a0cb-edc4-4985-80f5-43b5c0a80305New
  4cc5a0d7-d800-431b-8087-45b5c0a80305Complaint registered with REC
  4cc5a0de-c93c-40d5-86de-45b4c0a80305In process
  4cc5a0e4-33ec-4f36-a85c-4278c0a80305Resolved
  eedcc546-eebf-102e-b869-00e08128b071Non-actionable
- regions
  08391dd0-3d26-11e4-916c-0800200c9a66ECOWAS
  08391dd0-3d26-11e4-916c-0800201c9a66UEMOA
- allStatuses
  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
- complaints
  0
  Complaint
  id64afe97b-d8bc-4e77-b2d3-aac2c5bdc882
  unique_number417
  user_id(null)
  user_detailsChabane Koanda Truck: 11 JH 3348/11LL7180 Tel: 0550709451
  user_emailgershonewman@gmail.com
  complaintThe driver's Carte grise was exchanged with another at the entrance of Walewale without his knowledge. At this barrier, the mistake was noticed by the Police. The driver tried to explain to the officers in vain. So he reported to GSA.
  original_complaintThe driver's Carte grise was exchanged with another at the entrance of Walewale without his knowledge. At this barrier, the mistake was noticed by the Police. The driver tried to explain to the officers in vain. So he reported to GSA.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca35901-cc64-46fe-bc12-1e79c0a80305
  location_id(null)
  location_otherEntrance Tamale Police barrier (BF to GH)
  date_of_incident2023-07-13
  ntb_type_idother
  ntb_type_otherMisunderstanding between driver and Officer
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-07-13
  created2023-07-13 14:09:31
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-07-13 14:09:31
  modified_by
  progress_update(null)
  offline0
  offline_commentDrivers are cautioned to always check their whenever the receive them from the officers.
  policy0
  complaint_languageThe driver's Carte grise was exchanged with another at the entrance of Walewale without his knowledge. At this barrier, the mistake was noticed by the Police. The driver tried to explain to the officers in vain. So he reported to GSA.
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca35901-cc64-46fe-bc12-1e79c0a80305
  nameOther
  order100
  select_box0
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id64afe97b-abe8-4b6a-b2fa-aac2c5bdc882
  complaint_id64afe97b-d8bc-4e77-b2d3-aac2c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentThe driver was released few minutes after this conversation
  resolution1
  created2023-07-13 14:09:31
  modified2023-07-13 14:09:31
  ComplaintsLocale(empty)
  TariffCode(empty)
  1
  Complaint
  id6501cb0c-bcd0-43bd-91ee-cd23c5bdc882
  unique_number418
  user_id(null)
  user_detailsKaboré Moussa Truck: 11 JM 0264 Tel:0261571761
  user_emailgershonewman@gmail.com
  complaintImmigration Officers at Techiman toll boot stopped four (4) trucks and asked them to pay GH 10.00 each. When the drivers said they did not have money, the Officers demanded that the drivers' mated provide their ID cards. After providing the ID cards, the Officers claimed that the ID cards should have been stamped by their officials at the border.
  original_complaintImmigration Officers at Techiman toll boot stopped four (4) trucks and asked them to pay GH 10.00 each. When the drivers said they did not have money, the Officers demanded that the drivers' mated provide their ID cards. After providing the ID cards, the Officers claimed that the ID cards should have been stamped by their officials at the border.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca35901-cc64-46fe-bc12-1e79c0a80305
  location_id(null)
  location_otherImmigration Techiman toll boot
  date_of_incident2023-09-13
  ntb_type_idother
  ntb_type_otherImmigration Officers requesting drivers to pay GH 10.00
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-09-13
  created2023-09-13 16:45:32
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-09-13 16:45:32
  modified_by
  progress_update(null)
  offline0
  offline_commentThis is not a practice on any corridor in the sub-region
  policy0
  complaint_languageImmigration Officers at Techiman toll boot stopped four (4) trucks and asked them to pay GH 10.00 each. When the drivers said they did not have money, the Officers demanded that the drivers' mated provide their ID cards. After providing the ID cards, the Officers claimed that the ID cards should have been stamped by their officials at the border.
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca35901-cc64-46fe-bc12-1e79c0a80305
  nameOther
  order100
  select_box0
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id6501cb0c-71b0-4475-828d-cd23c5bdc882
  complaint_id6501cb0c-bcd0-43bd-91ee-cd23c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentFew minutes after this intervention, the drivers were released.
  resolution1
  created2023-09-13 16:45:32
  modified2023-09-13 16:45:32
  ComplaintsLocale(empty)
  TariffCode(empty)
  2
  Complaint
  id6513e03b-b094-4e31-ae24-0823c5bdc882
  unique_number419
  user_id(null)
  user_detailsKaboré Moussa Tel: 0530677853
  user_emailgershonewman@gmail.com
  complaintThe Police requested the driver to GH 5.00 without any explanation
  original_complaintThe Police requested the driver to GH 5.00 without any explanation
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  location_id(null)
  location_otherWalewale Police
  date_of_incident2023-09-23
  ntb_type_id3746f9d4-98f6-11e1-be2a-00e08128b071
  ntb_type_otherExtortion of money by the Police
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-09-23
  created2023-09-27 09:56:43
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-09-27 09:56:43
  modified_by
  progress_update(null)
  offline0
  offline_comment
  policy0
  complaint_languageThe Police requested the driver to GH 5.00 without any explanation
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id3746f9d4-98f6-11e1-be2a-00e08128b071
  name8.8. Issues related to transit
  short_nameIssues related to transit
  description
  parent_id4fa77314-d5b4-4f30-8fc8-43da42c5ea45
  heading_number8.8
  allow1
  link_id
  ntm_code_id(null)
  position89
  headingName8.8. Issues related to transit
  fullName8.8. Issues related to transit
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  nameCheck Points (Road)
  order1
  select_box1
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id6513e03b-ed9c-48a7-9639-0823c5bdc882
  complaint_id6513e03b-b094-4e31-ae24-0823c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentAfter this interaction, the driver was released.
  resolution1
  created2023-09-27 09:56:43
  modified2023-09-27 09:56:43
  ComplaintsLocale(empty)
  TariffCode(empty)
  3
  Complaint
  id6513e3bb-d770-4a01-bb73-1fedc5bdc882
  unique_number420
  user_id(null)
  user_detailsIdrisa Ouédraogo Truck: 11 KL 8838 Tel: 0262276778
  user_emailgershonewman@gmail.com
  complaintThe Police stopped the driver and requested that he pays GH 10.00 because according to the police the driver's carte grise is not authentic. The driver reported to GSA.
  original_complaintThe Police stopped the driver and requested that he pays GH 10.00 because according to the police the driver's carte grise is not authentic. The driver reported to GSA.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca35901-cc64-46fe-bc12-1e79c0a80305
  location_id(null)
  location_otherPong Tamale
  date_of_incident2023-09-24
  ntb_type_idother
  ntb_type_otherExtortion of money by Police
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-09-24
  created2023-09-27 10:11:39
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-09-27 10:11:39
  modified_by
  progress_update(null)
  offline0
  offline_comment
  policy0
  complaint_languageThe Police stopped the driver and requested that he pays GH 10.00 because according to the police the driver's carte grise is not authentic. The driver reported to GSA.
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca35901-cc64-46fe-bc12-1e79c0a80305
  nameOther
  order100
  select_box0
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id6513e3bb-2914-497a-8944-1fedc5bdc882
  complaint_id6513e3bb-d770-4a01-bb73-1fedc5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentAfter this intervention the Police took GSA staff's number and released the driver.
  resolution1
  created2023-09-27 10:11:39
  modified2023-09-27 10:11:39
  ComplaintsLocale(empty)
  TariffCode(empty)
  4
  Complaint
  id653137b3-9d30-4aee-85d3-4f23c5bdc882
  unique_number421
  user_id(null)
  user_detailsOuedraogo Issa 1048 E203 Tel: 0595034888
  user_emailgershonewman@gmail.com
  complaintPolice stopped the driver and claimed to have received a signal from his colleagues that the driver drove through the red light. The driver agued that he never did and suggested a check from the monitor conected to the camera.
  original_complaintPolice stopped the driver and claimed to have received a signal from his colleagues that the driver drove through the red light. The driver agued that he never did and suggested a check from the monitor conected to the camera.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca35901-cc64-46fe-bc12-1e79c0a80305
  location_id(null)
  location_otherMTTD Kumasi (town)
  date_of_incident2023-10-19
  ntb_type_idother
  ntb_type_otherUnnecessary delay and attempt of extortion
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-10-19
  created2023-10-19 16:05:39
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-10-19 16:05:39
  modified_by
  progress_update(null)
  offline0
  offline_comment
  policy0
  complaint_languagePolice stopped the driver and claimed to have received a signal from his colleagues that the driver drove through the red light. The driver agued that he never did and suggested a check from the monitor conected to the camera.
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca35901-cc64-46fe-bc12-1e79c0a80305
  nameOther
  order100
  select_box0
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id653137b3-d4a8-42a5-a283-4f23c5bdc882
  complaint_id653137b3-9d30-4aee-85d3-4f23c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentWhile GSA staff was uploading the complaint unto the platform, the driver called to report that the officers asked him to pay money and go but he told them until the truth is disclosed he wouldn't pay anything. Upon hearing this the Police released the driver.
  resolution1
  created2023-10-19 16:05:39
  modified2023-10-19 16:05:39
  ComplaintsLocale(empty)
  TariffCode(empty)
  5
  Complaint
  id6537b9b6-0ecc-4fdc-8e07-9762c5bdc882
  unique_number423
  user_id(null)
  user_detailsAbdoul-Rachid Kinda Truck: 11 LP 5591 BF Tel: 0269665347
  user_emailgershonewman@gmail.com
  complaintThe Police stopped the driver checked his papers and proceeded to check inside the truck. Upon finding scissors in the truck, the Police handcuffed the driver against a tree. This is because the officer claimed he suspected that the driver uses the scissors to cut indian herb.
  original_complaintThe Police stopped the driver checked his papers and proceeded to check inside the truck. Upon finding scissors in the truck, the Police handcuffed the driver against a tree. This is because the officer claimed he suspected that the driver uses the scissors to cut indian herb.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca35901-cc64-46fe-bc12-1e79c0a80305
  location_id(null)
  location_otherPolice barrier, few km to Nasia (GH - GH)
  date_of_incident2023-10-24
  ntb_type_idother
  ntb_type_otherPolice verbal and physical harassments (handcuffing of driver)
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-10-24
  created2023-10-24 14:33:58
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-10-24 14:33:58
  modified_by
  progress_update(null)
  offline0
  offline_comment
  policy0
  complaint_languageThe Police stopped the driver checked his papers and proceeded to check inside the truck. Upon finding scissors in the truck, the Police handcuffed the driver against a tree. This is because the officer claimed he suspected that the driver uses the scissors to cut indian herb.
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca35901-cc64-46fe-bc12-1e79c0a80305
  nameOther
  order100
  select_box0
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id6537b9b6-7ccc-4b42-8153-9762c5bdc882
  complaint_id6537b9b6-0ecc-4fdc-8e07-9762c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentThe driver was released after GSA intervention
  resolution1
  created2023-10-24 14:33:58
  modified2023-10-24 14:33:58
  ComplaintsLocale(empty)
  TariffCode(empty)
  6
  Complaint
  id6540f859-3574-4586-93c2-fea4c5bdc882
  unique_number424
  user_id(null)
  user_detailsKabré Mahama Truck: 0845 F1 03 BF Tel: 0269677168
  user_emailgershonewman@gmail.com
  complaintThe Police stopped the driver and proceeded with checks on the truck and papers. They took the papers and left the driver in Sogakope town without giving any clue as to where they were going.
  original_complaintThe Police stopped the driver and proceeded with checks on the truck and papers. They took the papers and left the driver in Sogakope town without giving any clue as to where they were going.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idTG
  reporting_region_id
  location_type_id4ca35901-cc64-46fe-bc12-1e79c0a80305
  location_id(null)
  location_otherSogakope Police
  date_of_incident2023-10-31
  ntb_type_idother
  ntb_type_otherUnnecessary delay, Police seized driver's papers for more than an hour without any reason
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-10-31
  created2023-10-31 14:51:37
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-10-31 14:51:37
  modified_by
  progress_update(null)
  offline0
  offline_comment
  policy0
  complaint_languageThe Police stopped the driver and proceeded with checks on the truck and papers. They took the papers and left the driver in Sogakope town without giving any clue as to where they were going.
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idTG
  nameTogo
  short_name
  fre_nameTogo
  fre_short_name
  por_nameTogo
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca35901-cc64-46fe-bc12-1e79c0a80305
  nameOther
  order100
  select_box0
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id6540f859-b3e4-43d0-a66f-fea4c5bdc882
  complaint_id6540f859-3574-4586-93c2-fea4c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentWe are once again calling on the Police Administration to assist in the facilitation of Transit Trade in Ghana by desisting from harassing and extorting money from transit drivers.
  resolution1
  created2023-10-31 14:51:37
  modified2023-10-31 14:51:37
  ComplaintsLocale(empty)
  TariffCode(empty)
  7
  Complaint
  id6548a158-9e88-45f6-8dab-2540c5bdc882
  unique_number425
  user_id(null)
  user_detailsIsaac Bawa Truck: GM 6341-14 Tel: 0245139303
  user_emailgershonewman@gmail.com
  complaintThe driver coming from Burkina Faso was asked by Customs at Navrongo to pay money.
  original_complaintThe driver coming from Burkina Faso was asked by Customs at Navrongo to pay money.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  location_id(null)
  location_otherCustoms Navrongo
  date_of_incident2023-11-04
  ntb_type_idother
  ntb_type_otherCustoms Officers demandind for money
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-11-04
  created2023-11-06 10:18:32
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-11-06 10:18:32
  modified_by
  progress_update(null)
  offline0
  offline_comment
  policy0
  complaint_languageThe driver coming from Burkina Faso was asked by Customs at Navrongo to pay money.
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  nameCheck Points (Road)
  order1
  select_box1
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id6548a158-2ebc-4b35-9371-2540c5bdc882
  complaint_id6548a158-9e88-45f6-8dab-2540c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentThe driver was released
  resolution1
  created2023-11-06 10:18:32
  modified2023-11-06 10:18:32
  ComplaintsLocale(empty)
  TariffCode(empty)
  8
  Complaint
  id6568598b-f2cc-485e-98f9-0772c5bdc882
  unique_number427
  user_id(null)
  user_detailsNakorba Ismael Tel: 0277545889 Truck: 4354 E3 03
  user_emailgershonewman@gmail.com
  complaintNsutem Customs officers stopped about forty (40) tankers and insisted that they pay GH 5.00 each. Since the drivers were not willing to pay the requested amount, the drivers' papers were seized from 6am till after 8am when the drivers reported to GSA.
  original_complaintNsutem Customs officers stopped about forty (40) tankers and insisted that they pay GH 5.00 each. Since the drivers were not willing to pay the requested amount, the drivers' papers were seized from 6am till after 8am when the drivers reported to GSA.
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  location_id(null)
  location_otherNsutem Customs Checkpoint
  date_of_incident2023-11-30
  ntb_type_idother
  ntb_type_otherExtortion by Customs
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2023-11-30
  created2023-11-30 11:44:43
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2023-11-30 11:44:43
  modified_by
  progress_update(null)
  offline0
  offline_comment
  policy0
  complaint_languageNsutem Customs officers stopped about forty (40) tankers and insisted that they pay GH 5.00 each. Since the drivers were not willing to pay the requested amount, the drivers' papers were seized from 6am till after 8am when the drivers reported to GSA.
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca358ef-d3a4-4128-a5ba-1c4dc0a80305
  nameCheck Points (Road)
  order1
  select_box1
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id6568598b-f518-4f20-bfec-0772c5bdc882
  complaint_id6568598b-f2cc-485e-98f9-0772c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentThe drivers were released by the intervention of GSA through their contact person at the Customs Office.
  resolution1
  created2023-11-30 11:44:43
  modified2023-11-30 11:44:43
  ComplaintsLocale(empty)
  TariffCode(empty)
  9
  Complaint
  id65f44839-f390-4482-9980-3860c5bdc882
  unique_number431
  user_id(null)
  user_detailsHamed Ouedraogo Truck: 7017 f7 03 Tel: 0534864971
  user_emailgershonewman@gmail.com
  complaintThe Police stopped the driver, took his papers and claimed the driver's Carte Grise and Permis International are fake. The Police later on requested driver to pay GH 100.00, amount which was reduced to GH 50.00
  original_complaintThe Police stopped the driver, took his papers and claimed the driver's Carte Grise and Permis International are fake. The Police later on requested driver to pay GH 100.00, amount which was reduced to GH 50.00
  country_idGH
  town_id
  imposing_region_id
  reporting_country_idBF
  reporting_region_id
  location_type_id4ca35901-cc64-46fe-bc12-1e79c0a80305
  location_id(null)
  location_otherPolice checkpoint before Nasia (GH-BF)
  date_of_incident2024-03-15
  ntb_type_idother
  ntb_type_otherPolice Extortion of money
  ntm_code_id(null)
  status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  product_description
  country_origin_id
  currency_id
  value(null)
  original_localeeng
  is_spam0
  resolved_date2024-03-15
  created2024-03-15 15:08:09
  created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
  modified2024-03-15 15:08:09
  modified_by
  progress_update(null)
  offline0
  offline_comment
  policy0
  complaint_languageThe Police stopped the driver, took his papers and claimed the driver's Carte Grise and Permis International are fake. The Police later on requested driver to pay GH 100.00, amount which was reduced to GH 50.00
  Country
  idGH
  nameGhana
  short_name
  fre_nameGhana
  fre_short_name
  por_nameGana
  por_short_name
  currencyCedi
  member1
  ImposingRegion
  id(null)
  name(null)
  ReportingCountry
  idBF
  nameBurkina Faso
  short_name
  fre_nameBurkina Faso
  fre_short_name
  por_nameBurkina Faso
  por_short_name
  currency
  member1
  ReportingRegion
  id(null)
  name(null)
  Location
  id(null)
  name(null)
  location_type_id(null)
  country_id(null)
  NtbType
  id(null)
  name(null)
  short_name(null)
  description(null)
  parent_id(null)
  heading_number(null)
  allow(null)
  link_id(null)
  ntm_code_id(null)
  position(null)
  headingName(null)
  fullName(null)
  NtmCode
  id(null)
  level(null)
  code(null)
  description(null)
  parent_id(null)
  LocationType
  id4ca35901-cc64-46fe-bc12-1e79c0a80305
  nameOther
  order100
  select_box0
  Status
  id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
  nameResolved
  order5
  default0
  rejected0
  resolved1
  nonactionable0
  ResolutionComment
  id65f44839-a204-4e4a-b5f2-3860c5bdc882
  complaint_id65f44839-f390-4482-9980-3860c5bdc882
  user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
  commentAfter this explanation, the driver was released without paying any money.
  resolution1
  created2024-03-15 15:08:09
  modified2024-03-15 15:08:09
  ComplaintsLocale(empty)
  TariffCode(empty)
- currentUser(null)
- defaultLanguageEnglish
- $this->data
  Complaint(empty)
- $this->validationErrors(empty)
- Loaded Helpers
  0jqueryEngine
  1js
  2paginator
  3simpleGraph
  4htmlToolbar
  5toolbar
  6number
  7filter
  8text
  9time
  10form
  11session
  12html
====

Non-Tariff Barriers

Reporting, Monitoring and Eliminating Mechanism

All resolved complaints

default

Query Explain:

Memory

Timers

Non-Tariff Barriers

Reporting, Monitoring and Eliminating Mechanism

All resolved complaints

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

View Variables