--
-- Host: localhost    Database: automated_system_db
-- ------------------------------------------------------


--
-- Table structure for table `alembic_version`
--

CREATE TABLE `alembic_version` (
  `version_num` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`version_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `alembic_version`
--

INSERT INTO `alembic_version` VALUES ('cc5669644462');

--
-- Table structure for table `contracts`
--

CREATE TABLE `contracts` (
  `id` varchar(36) COLLATE utf8mb4_general_ci NOT NULL,
  `project_title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `contract_number` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `party_b_full_name_with_title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `party_b_address` text COLLATE utf8mb4_general_ci,
  `party_b_phone` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `party_b_email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `agreement_start_date` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `agreement_end_date` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_fee_usd` decimal(10,2) DEFAULT NULL,
  `gross_amount_usd` decimal(10,2) DEFAULT NULL,
  `tax_percentage` decimal(5,2) DEFAULT NULL,
  `payment_gross` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `payment_net` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `workshop_description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `party_a_signature_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `party_b_signature_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `party_b_position` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_fee_words` text COLLATE utf8mb4_general_ci,
  `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deliverables` text COLLATE utf8mb4_general_ci,
  `output_description` text COLLATE utf8mb4_general_ci,
  `custom_article_sentences` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `payment_installments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  `user_id` int NOT NULL,
  `focal_person_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `party_a_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `deduct_tax_code` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `vat_organization_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `contracts_chk_1` CHECK (json_valid(`focal_person_info`)),
  CONSTRAINT `contracts_chk_2` CHECK (json_valid(`party_a_info`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contracts`
--

INSERT INTO `contracts` VALUES ('07299214-1f54-49e7-9999-e5c5863ee20b','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-007','Ms. CHAB Charyna','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+855 67408241','charyna.chab@student.passerellesnumeriques.org','2025-10-07','2025-11-09',1200.00,1200.00,0.00,'$1200.00 USD','$1200.00 USD','','Mr. SOEUNG Saroeun','Ms. CHAB Charyna','Freelance Consultant','One Thousand Two Hundred US Dollars only','','Sign Agreement \r\nSubmit the draft outline \r\nSubmit the draft budget analysis to be submitted to NGOF \r\nSubmit the well  written and comprehensive analysis report based on the outcomes of the analysis. \r\nPresent analysis report in a multi-stakeholder workshop. \r\nSubmit invoice and receipt of the servic; Sign Agreement \r\nSubmit the draft outline \r\nSubmit the draft budget analysis to be submitted to NGOF \r\nSubmit the well  written and comprehensive analysis report based on the outcomes of the analysis. \r\nPresent analysis report in a multi-stakeholder workshop. \r\nSubmit invoice and receipt of the servic','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (50%)\", \"deliverables\": \"Sign Agreement \\r\\nSubmit the draft outline \\r\\nSubmit the draft budget analysis to be submitted to NGOF \\r\\nSubmit the well  written and comprehensive analysis report based on the outcomes of the analysis. \\r\\nPresent analysis report in a multi-stakeholder workshop. \\r\\nSubmit invoice and receipt of the servic\", \"dueDate\": \"2025-10-07\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (50%)\", \"deliverables\": \"Sign Agreement \\r\\nSubmit the draft outline \\r\\nSubmit the draft budget analysis to be submitted to NGOF \\r\\nSubmit the well  written and comprehensive analysis report based on the outcomes of the analysis. \\r\\nPresent analysis report in a multi-stakeholder workshop. \\r\\nSubmit invoice and receipt of the servic\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-07 10:00:58','2025-12-12 08:27:55',41,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}, {\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','K002-100054102','The NGO Forum on Cambodia'),('087cb47d-2258-433f-a40c-32dc4e477346','Assessment for 6 CSO Networks + Research on Green PFM, Tax Equity, Investment Climate, Procurement Transparency (SCOPE-PFM)','NGOF/2026-006','Dr. Tapas R.Dash','#6,street312, Phnom Penh, Cambodia','+855 12 260 642','trdash321@gmail.com','2026-04-20','2026-06-19',12500.00,12500.00,10.00,'$12500.00 USD','$11250.00 USD','','Mr. SOEUNG Saroeun','Dr. Tapas R.Dash','Freelance Consultant','Twelve Thousand Five Hundred US Dollars only','','PHASE 1: Research Planning & Data Collection\r\nDeliverables 1-3 | Due: May 11, 2026 \r\n\r\nDeliverable 1: Consultant Onboarding\r\nTasks: Sign contract, kickoff meeting with NGOF/BWG, review background docs.\r\nResponsible: Consultant | Support/Review: NGOF Secretariat | Due: Apr 24\r\n\r\nDeliverable 2: Analysis Outline\r\nTasks: Detailed methodology for needs assessment, research plans for 4 themes, workplan, risk log, partner consultation schedule.\r\nResponsible: Consultant | Support/Review: NGOF & BWG | Due: Apr 29 \r\n\r\nDeliverable 3: Partner Data Collection\r\nTasks: Surveys/interviews to ≥8 reps from 6 networks, 1 virtual + 1 in-person meeting/workshop.\r\nResponsible: Consultant | Support/Review: BWG | Due: May 11 \r\n\r\nPayment Trigger: Approval of Analysis Outline + completion of all Phase 1 consultations; PHASE 2: Draft Analysis & Feedback \r\nDeliverables 4-5 | Due: May 21, 2026 | 7 Working Days\r\n\r\nDeliverable 4: 1st Draft Report\r\nTasks: Needs assessment section (gaps/capacities), draft chapters on 4 themes with prelim data/analysis, visuals, exec summary.\r\nResponsible: Consultant | Support/Review: NGOF | Due: May 17 \r\n\r\nDeliverable 5: Findings Presentation & 2nd Draft\r\nTasks: PPT (20 slides) for feedback session, incorporate comments from NGOF/partners.\r\nResponsible: Consultant | Support/Review: NGOF & Partners | Due: May 21 \r\n\r\nPayment Trigger: NGOF approval of 2nd Draft Report + PPT presentation; PHASE 3: Final Outputs & Dissemination \r\nDeliverables 6-8 | Due: June 19, 2026 \r\n\r\nDeliverable 6: FINAL 15-20 Page Report + 4 Policy Briefs\r\nTasks: Polish full report with policy recs/annexes, translate 5-page exec summary to Khmer, finalize 4 theme-specific policy briefs (5-8pp each).\r\nResponsible: Consultant | Support/Review: NGOF | Due: May 30 \r\nDeliverable 7: Multi-Stakeholder Workshop Presentation\r\nTasks: Deliver 1-day workshop, facilitate discussions/Q&A (NGOF covers venue/attendees).\r\nResponsible: Consultant | Support/Review: NGOF & BWG | Due: June 6 \r\n\r\nDeliverable 8: Assignment Finalization (incl. Advocacy Toolkit)\r\nTasks: Handover raw data, editable files, CSO advocacy toolkit (checklists/scorecards), final invoice/report.\r\nResponsible: Consultant | Support/Review: NGOF | Due: June 19 \r\n\r\nPayment Trigger: Final approval of all deliverables + workshop completion','This consultancy, spanning April 20 to June 19, 2026 (20 working days) with a total value of US$12,500, will deliver comprehensive research and capacity-building outputs to empower six key CSO networks—Budget Working Group (BWG), Anti-Corruption Working Group (ACWG), Access to Information (A2I), Women for All (W4All), Social Protection for All (SP4AL), and I-SAF—in advancing evidence-based advocacy on public financial management (PFM) in Cambodia.  The primary output is a 15-20 page Research Needs Assessment Report, featuring a detailed gap analysis and capacity matrix mapping knowledge priorities across the six networks. This will draw from 20+ consultations, including surveys, semi-structured interviews, and two workshops (one virtual, one in-person in Phnom Penh), culminating in 5-10 actionable recommendations to guide future joint research agendas.  Complementing this, the consultancy produces four thematic Policy Briefs (5-8 pages each, with infographics and executive summaries in Khmer/English). The Green PFM brief analyzes climate expenditure tagging (e.g., flood resilience budgets amid $100M+ annual damages). The Tax Equity/Justice brief employs incidence modeling to address regressive structures (tax-to-GDP ~15%). The Investment Climate brief scrutinizes FDI transparency and opaque incentives prone to elite capture. The Public Procurement brief develops a risk framework for mega-infrastructure projects, incorporating ≥8 interviews and 1-2 case studies per theme.  To operationalize findings, an Advocacy Toolkit will provide practical CSO tools, including checklists and scorecards for monitoring green budgets, tax progressivity, investment incentives, and procurement transparency. These user-friendly resources integrate gender and climate lenses for inclusive application.  Finally, dissemination includes a 20-slide PowerPoint presentation and facilitation support for a 1-day multi-stakeholder workshop (logistics covered by NGOF), plus full handover of raw data, editable files, and Khmer summaries. These outputs align with SDGs 10, 13, and 16, Cambodia\'s PFM Reform Roadmap (2024-2028), and Rectangular Strategy Phase IV, equipping CSOs for impactful 2026 budget advocacy.','{}','[{\"description\": \"Installment #1 (40%)\", \"deliverables\": \"PHASE 1: Research Planning & Data Collection\\r\\nDeliverables 1-3 | Due: May 11, 2026 \\r\\n\\r\\nDeliverable 1: Consultant Onboarding\\r\\nTasks: Sign contract, kickoff meeting with NGOF/BWG, review background docs.\\r\\nResponsible: Consultant | Support/Review: NGOF Secretariat | Due: Apr 24\\r\\n\\r\\nDeliverable 2: Analysis Outline\\r\\nTasks: Detailed methodology for needs assessment, research plans for 4 themes, workplan, risk log, partner consultation schedule.\\r\\nResponsible: Consultant | Support/Review: NGOF & BWG | Due: Apr 29 \\r\\n\\r\\nDeliverable 3: Partner Data Collection\\r\\nTasks: Surveys/interviews to \\u22658 reps from 6 networks, 1 virtual + 1 in-person meeting/workshop.\\r\\nResponsible: Consultant | Support/Review: BWG | Due: May 11 \\r\\n\\r\\nPayment Trigger: Approval of Analysis Outline + completion of all Phase 1 consultations\", \"dueDate\": \"2026-05-11\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"PHASE 2: Draft Analysis & Feedback \\r\\nDeliverables 4-5 | Due: May 21, 2026 | 7 Working Days\\r\\n\\r\\nDeliverable 4: 1st Draft Report\\r\\nTasks: Needs assessment section (gaps/capacities), draft chapters on 4 themes with prelim data/analysis, visuals, exec summary.\\r\\nResponsible: Consultant | Support/Review: NGOF | Due: May 17 \\r\\n\\r\\nDeliverable 5: Findings Presentation & 2nd Draft\\r\\nTasks: PPT (20 slides) for feedback session, incorporate comments from NGOF/partners.\\r\\nResponsible: Consultant | Support/Review: NGOF & Partners | Due: May 21 \\r\\n\\r\\nPayment Trigger: NGOF approval of 2nd Draft Report + PPT presentation\", \"dueDate\": \"2026-05-21\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (30%)\", \"deliverables\": \"PHASE 3: Final Outputs & Dissemination \\r\\nDeliverables 6-8 | Due: June 19, 2026 \\r\\n\\r\\nDeliverable 6: FINAL 15-20 Page Report + 4 Policy Briefs\\r\\nTasks: Polish full report with policy recs/annexes, translate 5-page exec summary to Khmer, finalize 4 theme-specific policy briefs (5-8pp each).\\r\\nResponsible: Consultant | Support/Review: NGOF | Due: May 30 \\r\\nDeliverable 7: Multi-Stakeholder Workshop Presentation\\r\\nTasks: Deliver 1-day workshop, facilitate discussions/Q&A (NGOF covers venue/attendees).\\r\\nResponsible: Consultant | Support/Review: NGOF & BWG | Due: June 6 \\r\\n\\r\\nDeliverable 8: Assignment Finalization (incl. Advocacy Toolkit)\\r\\nTasks: Handover raw data, editable files, CSO advocacy toolkit (checklists/scorecards), final invoice/report.\\r\\nResponsible: Consultant | Support/Review: NGOF | Due: June 19 \\r\\n\\r\\nPayment Trigger: Final approval of all deliverables + workshop completion\", \"dueDate\": \"2026-06-19\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-04-09 03:58:18',NULL,14,'[{\"name\": \"Tola Chhay\", \"position\": \"Project Coordinator\", \"phone\": \"+855 122 702 44\", \"email\": \"tola@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('0a34d733-495c-41d6-bcad-9cc276bffd15','Consultant for \"Toxic Rivers\" Documentary Production and Mekong Advocacy','NGOF/2026-003','Tom Fawthrop','','(+855)14800803','Tomfawthrop@gmail.com','2026-03-18','2026-04-10',700.00,700.00,15.00,'$700.00 USD','$595.00 USD','','Mr. SOEUNG Saroeun','Tom Fawthrop','Director of Eureka Film','Seven Hundred US Dollars only','','- Formal signing of the agreement between the NGO Forum and the Consultant, including the finalized project budget.\r\n- Delivery of the comprehensive project concept focusing on Mekong mining pollution and transboundary governance.\r\n- Delivery of the complete investigative video document (Master Copy, e.g., Full HD 1080p, MP4 format) to ensure you receive a file suitable for professional screenings).\r\n- Usage Rights (Clarification): While the consultant agreed to share copyright for \"educational purposes,\" specify if this includes posting on social media (Facebook/YouTube) or showing it at public forums.\r\n- Submission of a final invoice and receipt of the service.','Investigative documentary and advocacy materials documenting the environmental impact of cross-border mining on the Mekong River, including public awareness screenings and civil society engagement platforms','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"- Formal signing of the agreement between the NGO Forum and the Consultant, including the finalized project budget.\\r\\n- Delivery of the comprehensive project concept focusing on Mekong mining pollution and transboundary governance.\\r\\n- Delivery of the complete investigative video document (Master Copy, e.g., Full HD 1080p, MP4 format) to ensure you receive a file suitable for professional screenings).\\r\\n- Usage Rights (Clarification): While the consultant agreed to share copyright for \\\"educational purposes,\\\" specify if this includes posting on social media (Facebook/YouTube) or showing it at public forums.\\r\\n- Submission of a final invoice and receipt of the service.\", \"dueDate\": \"2026-03-27\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-03-18 08:49:37',NULL,16,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('12eea846-aae9-4368-a938-8205673eda08','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-016','Mr. Kin Doung','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','kin.doung@student.passerellesnumeriques.org','2025-11-10','2025-12-07',1200.00,1200.00,10.00,'$1200.00 USD','$1080.00 USD','','Mr. SOEUNG Saroeun','Mr. Kin Doung','Freelance Consultant','One Thousand Two Hundred US Dollars only','','- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\r\n- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service; - Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\r\n- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service; - Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\r\n- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (30%)\", \"deliverables\": \"- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\\r\\n- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\", \"dueDate\": \"2025-12-01\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\\r\\n- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\", \"dueDate\": \"2025-12-01\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (40%)\", \"deliverables\": \"- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\\r\\n- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\", \"dueDate\": \"2026-01-01\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-11-10 00:30:53','2025-12-12 08:27:40',69,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('156ed08b-bdf6-490b-9eec-924b9cc97565','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-013','Mr. Chhea Chhouy','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+855 67408241','chhea.chhouy@student.passerellesnumeriques.org','2025-10-10','2025-11-09',1225.00,1225.00,0.00,'$1225.00 USD','$1225.00 USD','','Mr. SOEUNG Saroeun','Mr. Chhea Chhouy','Freelance Consultant','One Thousand Two Hundred Twenty Five US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (50%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-10\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (50%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"Passerelles Numeriques Cambodia\"}]','2025-10-10 07:41:31','2025-12-12 08:27:35',69,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}, {\"name\": \"Mr. SOM Chettana\", \"position\": \"Finance Operation Manager\", \"phone\": \"076 754 8888\", \"email\": \"chettana@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}, {\"organization\": \"Passerelles Numeriques Cambodia\", \"short_name\": \"PNC\", \"name\": \"Mr. Heng HeangBunna\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"06 March 2015\"}]','K002-100054102','The NGO Forum on Cambodia'),('257d55d6-aba2-43fe-85c2-ba1f92fffa3a','Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','NGOF/2025-012','Mr. Heng Dara','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+855 67408241','heng.dara@gmail.com','2025-10-09','2025-11-09',1250.00,1250.00,15.00,'$1250.00 USD','$1062.50 USD','','Mr. SOEUNG Saroeun','Mr. Heng Dara','Freelance Consultant','One Thousand Two Hundred Fifty US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-09 04:00:20','2025-12-12 08:27:49',43,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','',''),('38d30f57-ad5a-412c-9fb9-6cb235fc6ea8','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-004','Mr. Heng Dara','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','heng.dara@gmail.com','2025-12-01','2026-01-01',2500.00,2500.00,10.00,'$2500.00 USD','$2250.00 USD','','Mr. SOEUNG Saroeun','Mr. Heng Dara','Freelance Consultant','Two Thousand Five Hundred US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{\"14\": \"I want to add more for the article 14.\"}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2026-01-01\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-12-15 00:50:19',NULL,6,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}, {\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('42c79f53-be6c-4470-9ea0-05024d8c5abe','Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','NGOF/2025-002','Ms. SOTH Channavy','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','soth.channavy@gmail.com','2025-10-07','2025-11-09',1250.00,1250.00,10.00,'$1250.00 USD','$1125.00 USD','','Mr. SOEUNG Saroeun','Ms. SOTH Channavy','Freelance Consultant','One Thousand Two Hundred Fifty US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (70%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-30\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-07 00:44:37','2025-12-12 09:20:23',69,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('45882072-d357-4154-a8ee-c845def15856','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-003','Ms. AN Vannak','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+855 67408241','an.vannak@gmail.com','2025-10-07','2025-11-09',2500.00,2500.00,0.00,'$2500.00 USD','$2500.00 USD','','Mr. SOEUNG Saroeun','Ms. AN Vannak','Freelance Consultant','Two Thousand Five Hundred US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (40%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-07\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-19\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-07 00:47:00','2025-12-12 08:35:58',69,'[{\"name\": \"Mr. CHAN Vicheth\", \"position\": \"RITI Program Manager\", \"phone\": \"012 953 650\", \"email\": \"vicheth@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','K002-100054102','The NGO Forum on Cambodia'),('4abf109b-784e-43ce-84e8-40c1caab0fdc','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-015','Mr. Sokchea Boy','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','sochea.boy@student.passerellesnumeriques.org','2025-10-17','2025-11-09',1225.00,1225.00,10.00,'$1225.00 USD','$1102.50 USD','','Mr. SOEUNG Saroeun','Mr. Sokchea Boy','Freelance Consultant','One Thousand Two Hundred Twenty Five US Dollars only','','- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\r\n- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\\r\\n- Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-17 09:26:51','2025-12-12 08:27:45',76,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','',''),('5191004d-699c-435c-80cb-b5dd85226747','Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','NGOF/2025-014','Mr. Kin Doung','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','kin.doung@gmail.com','2025-10-10','2025-11-09',3500.00,3500.00,0.00,'$3500.00 USD','$3500.00 USD','','Mr. SOEUNG Saroeun','Mr. Kin Doung','Freelance Consultant','Three Thousand Five Hundred US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-10 06:21:36','2025-10-10 13:55:16',42,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}, {\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','K002-100054102','The NGO Forum on Cambodia'),('5692d227-d305-4ca6-a646-1e9c8d64bcd1','Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','NGOF/2025-014','Mr. Kin Doung','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','kin.doung@gmail.com','2025-10-17','2025-11-09',1225.00,1225.00,15.00,'$1225.00 USD','$1041.25 USD','','Mr. SOEUNG Saroeun','Mr. Kin Doung','Freelance Consultant','One Thousand Two Hundred Twenty Five US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-17 09:01:32','2025-11-10 07:29:24',69,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('58be417f-589d-47bf-b99e-556b2e342f4e','Finance','NGOF/2026-001','Mr. Khiev Kanal','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','012 387 971','khiev.kanal@gamil.com','2026-01-07','2026-01-30',1000.00,1000.00,15.00,'$1000.00 USD','$850.00 USD','','Mr. SOEUNG Saroeun','Mr. Khiev Kanal','Freelance Consultant','One Thousand US Dollars only','','yfjygf; kedoqawhid','Finance','{\"1\": \"elkfhla\"}','[{\"description\": \"Installment #1 (50%)\", \"deliverables\": \"yfjygf\", \"dueDate\": \"2026-01-14\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (50%)\", \"deliverables\": \"kedoqawhid\", \"dueDate\": \"2026-01-14\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-01-09 08:53:27',NULL,6,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','',''),('5adc61ca-a158-4a45-9022-6e5bab2e50af','Bank Policy Assesment using the Fair Finance Guide International (FFGI) Methodology','NGOF/2025-002','Mr. Heng Dara','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','013 456 982','heng.dara@gmail.com','2025-12-01','2026-01-01',1250.00,1250.00,0.00,'$1250.00 USD','$1250.00 USD','','Mr. SOEUNG Saroeun','Mr. Heng Dara','Freelance Consultant','One Thousand Two Hundred Fifty US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2026-01-01\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-12-12 02:36:27',NULL,1,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}, {\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','K002-100054102','Passerelles Numeriques Cambodia'),('6172338f-0cf2-4b3d-936e-649b80d3a034','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-013','Mr. Chhea Chhouy','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+855 67408241','chhea.chhouy@student.passerellesnumeriques.org','2025-10-10','2025-11-09',1225.00,1225.00,15.00,'$1225.00 USD','$1041.25 USD','','Mr. SOEUNG Saroeun','Mr. Chhea Chhouy','Freelance Consultant','One Thousand Two Hundred Twenty Five US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-10 06:20:40','2025-10-10 13:55:22',42,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('717bc7d6-d045-4d8a-9093-f7e37be16046','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-005','Mr. Chhea Chhouy','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+855 67408241','chhea.chhouy@student.passerellesnumeriques.org','2025-10-07','2025-11-09',1225.00,1225.00,15.00,'$1225.00 USD','$1041.25 USD','','Mr. SOEUNG Saroeun','Mr. Chhea Chhouy','Freelance Consultant','One Thousand Two Hundred Twenty Five US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-07\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-26\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (40%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"Cooperation Committee for Cambodia\"}]','2025-10-07 03:03:40','2025-10-09 13:41:15',69,'[{\"name\": \"Mr. SOM Chettana\", \"position\": \"Finance Operation Manager\", \"phone\": \"076 754 8888\", \"email\": \"chettana@ngoforum.org.kh\"}, {\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\"}, {\"organization\": \"Cooperation Committee for Cambodia\", \"name\": \"Ms. SIN Putheary\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\"}]','',''),('7b0c47ec-7db1-4d5f-b410-f5d2397cdc15','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-001','Mr. SEAN Bunrith','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','Seanbunrith@gmail.com','2025-10-07','2025-11-09',2500.00,2500.00,15.00,'$2500.00 USD','$2125.00 USD','','Mr. SOEUNG Saroeun','Mr. SEAN Bunrith','Freelance Consultant','Two Thousand Five Hundred US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\n Submit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\n Submit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-07 00:41:35','2025-12-12 09:20:27',69,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('92bc29ed-07a9-44eb-be41-6206e1e78b00','National Budget Trends & Ministries Expenditure Review (Budget Law 2027 Advocacy)_ (SCOPE-PFM)','NGOF/2026-007','Mr. CHAN Sophal','House 32/3, Borey Penh Huot the Star Light, Street 1966, Sangkat Phnom Penh Thmey, Khan Sen Sok, 12101, Phnom Penh, Cambodia','+855 12 979 298','sophal@cps.org.kh','2026-04-20','2026-06-30',8500.00,8500.00,10.00,'$8500.00 USD','$7650.00 USD','','Mr. SOEUNG Saroeun','Mr. CHAN Sophal','Freelance Consultant','Eight Thousand Five Hundred US Dollars only','','PHASE 1: Planning & Analysis \r\n\r\nDeliverables 1-4 | Due: May 17, 2026 | 11 Working Days\r\n\r\nDeliverable 1: Consultant Onboarding\r\nTasks: Sign contract, kickoff meeting with NGOF/BWG, review background docs.\r\nResponsible: Consultant. Support/Review: NGOF Secretariat. Due: Apr 24. Days: N/A.\r\n\r\nDeliverable 2: Analysis Outline\r\nTasks: Develop detailed methodology for needs assessment, outline research plans for 4 themes, workplan, risk log, partner consultation schedule.\r\nResponsible: Consultant. Support/Review: NGOF & BWG. Due: Apr 29. Days: 3.\r\n\r\nDeliverable 3: Partner Data Collection\r\nTasks: Administer surveys/interviews to ≥8 reps from 6 networks, conduct 1 virtual and 1 in-person meeting/workshop.\r\nResponsible: Consultant. Support/Review: BWG. Due: May 9. Days: 3.\r\n\r\nDeliverable 4: 1st Draft Report\r\nTasks: Needs assessment section (gaps/capacities), draft chapters on 4 themes with prelim data/analysis, visuals, exec summary.\r\nResponsible: Consultant. Support/Review: NGOF. Due: May 17. Days: 5.\r\n\r\nPayment Trigger: NGOF approval of 1st Draft Report + completion of all data collection; PHASE 2: Finalization & Dissemination \r\n\r\nDeliverables 5-8 | Due: June 19, 2026 | 9 Working Days\r\n\r\nDeliverable 5: Findings Presentation & 2nd Draft\r\nTasks: Prepare PPT (20 slides) for feedback session, incorporate comments from NGOF/partners.\r\nResponsible: Consultant. Support/Review: NGOF & Partners. Due: May 21. Days: 2.\r\n\r\nDeliverable 6: FINAL 15-20 Page Report + 4 Policy Briefs\r\nTasks: Polish full report with policy recs/annexes, translate 5-page exec summary to Khmer, finalize 4 theme-specific policy briefs (5-8pp each).\r\nResponsible: Consultant. Support/Review: NGOF. Due: May 30. Days: 5.\r\n\r\nDeliverable 7: Multi-Stakeholder Workshop Presentation\r\nTasks: Deliver 1-day workshop, facilitate discussions/Q&A (NGOF covers venue/attendees).\r\nResponsible: Consultant. Support/Review: NGOF & BWG. Due: June 6. Days: 1.\r\n\r\nDeliverable 8: Assignment Finalization (incl. Advocacy Toolkit)\r\nTasks: Handover raw data, editable files, CSO advocacy toolkit (checklists/scorecards), final invoice/report.\r\nResponsible: Consultant. Support/Review: NGOF. Due: June 19. Days: 1.\r\n\r\nPayment Trigger: Final NGOF approval of all deliverables + workshop completion','Budget Analysis Consultant/Firm (National Budget Trends & Ministries Expenditure Review): This consultancy, running from April 20 to June 30, 2026 (20 working days) with a total budget of US$8,500, delivers evidence-based budget analysis to support BWG/NGOF advocacy for Budget Law 2027. Focusing on Cambodia\'s 2020-2024 Budget Laws and Settlements, it examines macro/sectoral trends and key ministries\' expenditure plans through economic classification, highlighting fiscal space for priority sectors like agriculture, climate resilience, WASH, education, social protection, and health.  The centerpiece output is a comprehensive 15-20 page analysis report in Khmer (with 2-3 page English executive summary), structured as: (i) introduction/methodology; (ii) key findings with charts/tables on revenue/expenditure trends; (iii) alignment with laws/strategies (e.g., Rectangular Strategy Phase IV, MAFF reports); (iv) targeted recommendations for Budget Law 2027; and (v) annexes (data tables). This CSO Position Paper emphasizes expenditure efficiency and allocation priorities, informed by data from MEF, Open Development Cambodia (ODC), and BWG consultations.  Supporting deliverables include an Analysis Outline (methodology/workplan), verified budget data collection (5-year Laws/Settlements), iterative drafts with BWG feedback, and a Findings Presentation for multi-stakeholder workshops. NGOF provides logistical support for consultations, ensuring triangulation of macro analysis (US$3,500), BWG coordination (US$2,000), and ministries expenditure review (US$3,000).  These outputs strengthen CSO technical capacity in PFM, promote citizen participation, and equip policymakers with actionable insights for transparent, accountable budgeting aligned with Cambodia\'s PFM reform agenda.','{}','[{\"description\": \"Installment #1 (50%)\", \"deliverables\": \"PHASE 1: Planning & Analysis \\r\\n\\r\\nDeliverables 1-4 | Due: May 17, 2026 | 11 Working Days\\r\\n\\r\\nDeliverable 1: Consultant Onboarding\\r\\nTasks: Sign contract, kickoff meeting with NGOF/BWG, review background docs.\\r\\nResponsible: Consultant. Support/Review: NGOF Secretariat. Due: Apr 24. Days: N/A.\\r\\n\\r\\nDeliverable 2: Analysis Outline\\r\\nTasks: Develop detailed methodology for needs assessment, outline research plans for 4 themes, workplan, risk log, partner consultation schedule.\\r\\nResponsible: Consultant. Support/Review: NGOF & BWG. Due: Apr 29. Days: 3.\\r\\n\\r\\nDeliverable 3: Partner Data Collection\\r\\nTasks: Administer surveys/interviews to \\u22658 reps from 6 networks, conduct 1 virtual and 1 in-person meeting/workshop.\\r\\nResponsible: Consultant. Support/Review: BWG. Due: May 9. Days: 3.\\r\\n\\r\\nDeliverable 4: 1st Draft Report\\r\\nTasks: Needs assessment section (gaps/capacities), draft chapters on 4 themes with prelim data/analysis, visuals, exec summary.\\r\\nResponsible: Consultant. Support/Review: NGOF. Due: May 17. Days: 5.\\r\\n\\r\\nPayment Trigger: NGOF approval of 1st Draft Report + completion of all data collection\", \"dueDate\": \"2026-04-17\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (50%)\", \"deliverables\": \"PHASE 2: Finalization & Dissemination \\r\\n\\r\\nDeliverables 5-8 | Due: June 19, 2026 | 9 Working Days\\r\\n\\r\\nDeliverable 5: Findings Presentation & 2nd Draft\\r\\nTasks: Prepare PPT (20 slides) for feedback session, incorporate comments from NGOF/partners.\\r\\nResponsible: Consultant. Support/Review: NGOF & Partners. Due: May 21. Days: 2.\\r\\n\\r\\nDeliverable 6: FINAL 15-20 Page Report + 4 Policy Briefs\\r\\nTasks: Polish full report with policy recs/annexes, translate 5-page exec summary to Khmer, finalize 4 theme-specific policy briefs (5-8pp each).\\r\\nResponsible: Consultant. Support/Review: NGOF. Due: May 30. Days: 5.\\r\\n\\r\\nDeliverable 7: Multi-Stakeholder Workshop Presentation\\r\\nTasks: Deliver 1-day workshop, facilitate discussions/Q&A (NGOF covers venue/attendees).\\r\\nResponsible: Consultant. Support/Review: NGOF & BWG. Due: June 6. Days: 1.\\r\\n\\r\\nDeliverable 8: Assignment Finalization (incl. Advocacy Toolkit)\\r\\nTasks: Handover raw data, editable files, CSO advocacy toolkit (checklists/scorecards), final invoice/report.\\r\\nResponsible: Consultant. Support/Review: NGOF. Due: June 19. Days: 1.\\r\\n\\r\\nPayment Trigger: Final NGOF approval of all deliverables + workshop completion\", \"dueDate\": \"2026-06-19\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-04-09 04:16:39',NULL,14,'[{\"name\": \"Ms. Chhay Tola\", \"position\": \"Project Coordinator\", \"phone\": \"+855 122 702 44\", \"email\": \"tola@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('a2a69d38-0299-4ce7-b562-3437a691e086','Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','NGOF/2025-016','Mr. Kin Doung','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','kin.doung@gmail.com','2025-10-21','2025-11-09',1255.00,1255.00,15.00,'$1255.00 USD','$1066.75 USD','','Mr. SOEUNG Saroeun','Mr. Kin Doung','Freelance Consultant','One Thousand Two Hundred Fifty Five US Dollars only','','Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\r\nSign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\\r\\nSign Agreement - Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF - Submit the well-written and comprehensive analysis report based on the outcomes of the analysis. - Present analysis report in a multi-stakeholder workshop. - Submit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-21 04:47:50','2025-11-10 07:29:30',69,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}, {\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('a6f73a2b-1f0f-494c-a8e1-338e80bcd130','Conduct a Research of Review Environmental and Social Impact Assessment (RESIA) on Chinese Investment in Cambodia','NGOF/2026-002','Dr. Sam Chanthy','House 520B, St. Monyreth, Sangkat Stueng Meanchey, Khan Meanchey, Phnom Penh, Cambodia','011931982/081955050','samchanthy@gmail.com','2026-03-20','2026-07-10',9000.00,9000.00,15.00,'$9000.00 USD','$7650.00 USD','','Mr. SOEUNG Saroeun','Dr. Sam Chanthy','Freeland Consultant','Nine Thousand US Dollars only','','- Submit Inception report with methodology, budget, and workplan\r\n- Presentation of methodology, work plan, timeline, and proposed budget of the research\r\n- Process mission letter and make appointment with key stakeholders\r\n- Consult with stakeholders to enhance the ESIA methodology, ensuring it addresses community concerns, investor requirements, and regulatory frameworks; - Data collection (household survey, KIIs, FGDs)\r\n- Data cleaning, data analysis, and report writing\r\n- Submit a draft ESIA report (English)\r\n- Presentation preliminary findings for getting feedback from NGOF, Give to Nature, and donor; - Submit a final ESIA report incorporating feedback (English)\r\n- Submit executive summary, conclusions, and recommendations (Khmer and English)\r\n- Submit Policy brief (Khmer and English)\r\n- Presentation of findings at dissemination workshop','Conduct an independent ESIA of selected Chinese investment projects, including the Techo Funan Canal compensation context, to inform advocacy, policy engagement, and stakeholder dialogue.','{}','[{\"description\": \"Installment #1 (40%)\", \"deliverables\": \"- Submit Inception report with methodology, budget, and workplan\\r\\n- Presentation of methodology, work plan, timeline, and proposed budget of the research\\r\\n- Process mission letter and make appointment with key stakeholders\\r\\n- Consult with stakeholders to enhance the ESIA methodology, ensuring it addresses community concerns, investor requirements, and regulatory frameworks\", \"dueDate\": \"2026-04-03\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"- Data collection (household survey, KIIs, FGDs)\\r\\n- Data cleaning, data analysis, and report writing\\r\\n- Submit a draft ESIA report (English)\\r\\n- Presentation preliminary findings for getting feedback from NGOF, Give to Nature, and donor\", \"dueDate\": \"2026-05-29\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (30%)\", \"deliverables\": \"- Submit a final ESIA report incorporating feedback (English)\\r\\n- Submit executive summary, conclusions, and recommendations (Khmer and English)\\r\\n- Submit Policy brief (Khmer and English)\\r\\n- Presentation of findings at dissemination workshop\", \"dueDate\": \"2026-07-10\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-03-18 06:13:32',NULL,4,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('a70f1e1b-dd3b-4977-9599-79b20da9b59c','Production of 2020-2026 Citizen Climate Budget Booklets _ SCOPE-PFM','NGOF/2026-005','Mr. CHAN Sophal','House 32/3, Borey Penh Huot the Star Light, Street 1966, Sangkat Phnom Penh Thmey, Khan Sen Sok, 12101, Phnom Penh, Cambodia','+855 12 979 298','sophal@cps.org.kh','2026-04-10','2026-06-10',5000.00,5000.00,10.00,'$5000.00 USD','$4500.00 USD','','Mr. SOEUNG Saroeun','Mr. CHAN Sophal','Freelance Consultant','Five Thousand US Dollars only','','PHASE 1: Research & Analysis \r\nDeliverables 1-3 | Due: May 6, 2026 | 10 Working Days\r\nThe Inception Package includes methodology, stakeholder map, and workplan.\r\nResponsible: Consultant. Review: NGOF. Due: Apr 20 (3 days).\r\n\r\nThe Desk Review Report covers tagged budget matrix and gap analysis.\r\nResponsible: Consultant. Review: BWG. Due: Apr 27 (3 days).\r\n\r\nThe Consultation Report includes transcripts and feedback synthesis.\r\nResponsible: Consultant. Review: Partners. Due: May 6 (4 days).\r\n\r\nPayment Trigger: NGOF/BWG approval of all Phase 1 deliverables (Inception + Desk Review + Consultation Reports); PHASE 2: Production & Dissemination\r\nDeliverables 4-8 | Due: June 10, 2026 | 10 Working Days\r\n\r\nThe Draft CCB + Brief features 15pp draft, 4pp brief, and visuals.\r\nResponsible: Consultant. Review: MoE. Due: May 12 (4 days).\r\n\r\nThe Revised CCB incorporates feedback.\r\nResponsible: Consultant. Review: NGOF. Due: May 20 (2 days).\r\n\r\nThe Final CCB Booklet provides Khmer/English files and dissemination toolkit.\r\nResponsible: Consultant. Review: NGOF. Due: May 25 (2 days).\r\n\r\nWorkshop Support includes PPT and facilitation materials.\r\nResponsible: Consultant. Review: NGOF. Due: May 28 (1 day).\r\n\r\nThe Closure Package contains raw data, editable files, and final report.\r\nResponsible: Consultant. Review: NGOF. Due: June 10 (1 day).\r\n\r\nPayment Trigger: Final NGOF approval of all deliverables + workshop materials completed','NGOF is implementing the “Strengthening Civic Engagement and Oversight in Public Financial Management (SCOPE-PFM)” project and requires services for the production of 2020-2026 Citizen Climate Budget (CCB) booklets, including desk review, stakeholder consultations, bilingual materials, infographics, and a policy brief, as detailed in the Terms of Reference (TOR). The Consultant has the qualifications to perform these services.','{}','[{\"description\": \"Installment #1 (50%)\", \"deliverables\": \"PHASE 1: Research & Analysis \\r\\nDeliverables 1-3 | Due: May 6, 2026 | 10 Working Days\\r\\nThe Inception Package includes methodology, stakeholder map, and workplan.\\r\\nResponsible: Consultant. Review: NGOF. Due: Apr 20 (3 days).\\r\\n\\r\\nThe Desk Review Report covers tagged budget matrix and gap analysis.\\r\\nResponsible: Consultant. Review: BWG. Due: Apr 27 (3 days).\\r\\n\\r\\nThe Consultation Report includes transcripts and feedback synthesis.\\r\\nResponsible: Consultant. Review: Partners. Due: May 6 (4 days).\\r\\n\\r\\nPayment Trigger: NGOF/BWG approval of all Phase 1 deliverables (Inception + Desk Review + Consultation Reports)\", \"dueDate\": \"2026-05-06\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (50%)\", \"deliverables\": \"PHASE 2: Production & Dissemination\\r\\nDeliverables 4-8 | Due: June 10, 2026 | 10 Working Days\\r\\n\\r\\nThe Draft CCB + Brief features 15pp draft, 4pp brief, and visuals.\\r\\nResponsible: Consultant. Review: MoE. Due: May 12 (4 days).\\r\\n\\r\\nThe Revised CCB incorporates feedback.\\r\\nResponsible: Consultant. Review: NGOF. Due: May 20 (2 days).\\r\\n\\r\\nThe Final CCB Booklet provides Khmer/English files and dissemination toolkit.\\r\\nResponsible: Consultant. Review: NGOF. Due: May 25 (2 days).\\r\\n\\r\\nWorkshop Support includes PPT and facilitation materials.\\r\\nResponsible: Consultant. Review: NGOF. Due: May 28 (1 day).\\r\\n\\r\\nThe Closure Package contains raw data, editable files, and final report.\\r\\nResponsible: Consultant. Review: NGOF. Due: June 10 (1 day).\\r\\n\\r\\nPayment Trigger: Final NGOF approval of all deliverables + workshop materials completed\", \"dueDate\": \"2026-06-10\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-04-09 03:16:40',NULL,14,'[{\"name\": \"Tola Chhay\", \"position\": \"Project Coordinator\", \"phone\": \"+855 122 702 44\", \"email\": \"tola@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('c2c5efdd-8603-4381-be92-29a44aa16b1c','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-009','Mr. SEAN Bunrith','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','Seanbunrith@gmail.com','2025-10-08','2025-11-09',3350.00,3350.00,15.00,'$3350.00 USD','$2847.50 USD','','Mr. SOEUNG Saroeun','Mr. SEAN Bunrith','Freelance Consultant','Three Thousand Three Hundred Fifty US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.','Budget analysis for MAFF for the NGOF','{\"16\": \"I want to add more for the article 16.\"}','[{\"description\": \"Installment #1 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-08\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-25\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (40%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-08 00:44:29','2025-10-10 13:55:38',43,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}, {\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('cb04ad4f-102c-4ed4-9ef6-a9bb451667e1','Conduct research on locally available natural resources around Marine Fisheries Management Area (MSMA) to support and enhance local food processing','NGOF/2026-004','Dr. Nguon Samnang','Graduate School, Royal University of Agriculture (RUA), P.O. Box 2696, Chamkar Daung, 12501 Dangkor, Phnom Penh, Cambodia','012 310 346','sam@rua.edu.kh','2026-03-27','2026-06-30',3500.00,3500.00,15.00,'$3500.00 USD','$2975.00 USD','','Mr. SOEUNG Saroeun','Dr. Nguon Samnang','Center Director of ECOLAND research center','Three Thousand Five Hundred US Dollars only','','Submit an inception Report: Including detailed workplan, methodology, data collection tools, and timeline (1-3 pages only)\r\nPresent about methodology and workplan and get feedback from NGOF\r\nDesign questionnaire; Data collection (FGDs, KIIs, Online survey) with targeted groups\r\nData entry, data cleaning, and data analysis\r\nSubmit a draft report in English\r\nPresent preliminary finding and get feedback from the NGOF; Submit a final report of research in Khmer and English version','Community multi-stakeholders led initiative','{}','[{\"description\": \"Installment #1 (40%)\", \"deliverables\": \"Submit an inception Report: Including detailed workplan, methodology, data collection tools, and timeline (1-3 pages only)\\r\\nPresent about methodology and workplan and get feedback from NGOF\\r\\nDesign questionnaire\", \"dueDate\": \"2026-04-10\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (35%)\", \"deliverables\": \"Data collection (FGDs, KIIs, Online survey) with targeted groups\\r\\nData entry, data cleaning, and data analysis\\r\\nSubmit a draft report in English\\r\\nPresent preliminary finding and get feedback from the NGOF\", \"dueDate\": \"2026-05-29\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (25%)\", \"deliverables\": \"Submit a final report of research in Khmer and English version\", \"dueDate\": \"2026-06-12\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-03-23 07:06:37',NULL,4,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('d1e20d93-5eb4-4f1a-b844-fadc2236c40a','Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','NGOF/2025-011','Ms. CHAB Charyna','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+855 67408241','charyna.chab@student.passerellesnumeriques.org','2025-10-09','2025-11-09',1225.00,1225.00,0.00,'$1225.00 USD','$1225.00 USD','','Mr. SOEUNG Saroeun','Ms. CHAB Charyna','Freelance Consultant','One Thousand Two Hundred Twenty Five US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-09\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-26\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (40%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"Cooperation Committee for Cambodia\"}]','2025-10-09 03:26:18','2025-10-10 13:55:28',69,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}, {\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}, {\"organization\": \"Cooperation Committee for Cambodia\", \"short_name\": \"CCC\", \"name\": \"Ms. SIN Putheary\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#406 \\u179f\\u1787\\u178e\", \"registration_date\": \"06 June 2017\"}]','K002-100054102','The NGO Forum on Cambodia'),('d6510e67-0a78-4cdb-9fe1-10ddc06d3f3c','tfhdf','NGOF/2026-002','Mr. Heng Dara','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','heng.dara@gmail.com','2026-01-07','2026-01-23',1500.00,1500.00,10.00,'$1500.00 USD','$1350.00 USD','','Mr. SOEUNG Saroeun','Mr. Heng Dara','Freelance Consultant','One Thousand Five Hundred US Dollars only','','kgkj','jgk','{\"1\": \"hi\"}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"kgkj\", \"dueDate\": \"2026-01-14\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-01-09 09:31:51','2026-03-17 02:53:15',7,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','',''),('d6d7d9b7-e37f-4cc6-b3af-c9491130f64f','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-010','Mr. SEAN Bunrith','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','Seanbunrith@gmail.com','2025-10-09','2025-11-09',1250.00,1250.00,0.00,'$1250.00 USD','$1250.00 USD','','Mr. SOEUNG Saroeun','Mr. SEAN Bunrith','Freelance Consultant','One Thousand Two Hundred Fifty US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-09\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-26\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (40%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"Cooperation Committee for Cambodia\"}]','2025-10-09 02:09:43','2025-10-10 13:55:35',69,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}, {\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}, {\"organization\": \"Cooperation Committee for Cambodia\", \"short_name\": \"CCC\", \"name\": \"Ms. SIN Putheary\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','K002-100054102','The NGO Forum on Cambodia'),('decb7841-b071-4740-98ba-86c885ff2c46','Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','NGOF/2025-017','Mr. Darin Hoy','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+855 67408241','darin.hoy@student.passerellesnumeriques.org','2025-11-11','2025-12-07',1500.00,1500.00,15.00,'$1500.00 USD','$1275.00 USD','','Mr. SOEUNG Saroeun','Mr. Darin Hoy','Freelance Consultant','One Thousand Five Hundred US Dollars only','','Sign Agreement \r\n Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF \r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis. \r\n Present analysis report in a multi-stakeholder workshop. \r\nSubmit invoice and receipt of the service\r\n Sign Agreement - Submit the draft outline \r\nSubmit the draft budget analysis to be submitted to NGOF \r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop. \r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement \\r\\n Submit the draft outline - Submit the draft budget analysis to be submitted to NGOF \\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis. \\r\\n Present analysis report in a multi-stakeholder workshop. \\r\\nSubmit invoice and receipt of the service\\r\\n Sign Agreement - Submit the draft outline \\r\\nSubmit the draft budget analysis to be submitted to NGOF \\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop. \\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-12-07\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-11-11 06:43:56','2025-11-27 14:17:49',69,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]',NULL,NULL),('e06fe057-972c-4dc8-a5db-aeecd13ac20f','Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','NGOF/2025-003','Mr. Khiev Kanal','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','012 387 971','khiev.kanal@gamil.com','2025-12-02','2026-01-02',2535.00,2535.00,15.00,'$2535.00 USD','$2154.75 USD','','Mr. SOEUNG Saroeun','Mr. Khiev Kanal','Freelance Consultant','Two Thousand Five Hundred Thirty Five US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2026-01-02\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-12-12 02:53:21',NULL,1,'[{\"name\": \"Mr. SOM Chettana\", \"position\": \"MACOR Program Manager\", \"phone\": \"076 754 8888\", \"email\": \"chettana@ngoforum.org.kh\"}, {\"name\": \"Mr. CHAN Vicheth\", \"position\": \"RITI Program Manager\", \"phone\": \"012 953 650\", \"email\": \"vicheth@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','',''),('e094a1ce-8c6f-4963-9c44-57481c6bbc65','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-004','Mr. Kin Doung','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','kin.doung@gmail.com','2025-10-07','2025-11-09',3255.00,3255.00,0.00,'$3255.00 USD','$3255.00 USD','','Mr. SOEUNG Saroeun','Mr. Kin Doung','Freelance Consultant','Three Thousand Two Hundred Fifty Five US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-07\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-26\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (40%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-07 00:50:26','2025-12-12 08:35:51',69,'[{\"name\": \"Mr. SOM Chettana\", \"position\": \"Finance Operation Manager\", \"phone\": \"076 754 8888\", \"email\": \"chettana@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','K002-100054102','The NGO Forum on Cambodia'),('e32e750c-80c1-432b-a536-91dd70a572a0','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-006','Mr. Kin Doung','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','kin.doung@gmail.com','2025-10-07','2025-11-09',1235.00,1235.00,15.00,'$1235.00 USD','$1049.75 USD','','Mr. SOEUNG Saroeun','Mr. Kin Doung','Freelance Consultant','One Thousand Two Hundred Thirty Five US Dollars only','','Sign Agreement \r\nSubmit the draft outline - Submit the draft budget analysis to be submitted to NGOF \r\nSubmit the well\r\nwritten and comprehensive analysis report based on the outcomes of the analysis. \r\nPresent analysis report in a multi-stakeholder workshop. \r\nSubmit invoice and receipt of the service; Sign Agreement \r\nSubmit the draft outline - Submit the draft budget analysis to be submitted to NGOF \r\nSubmit the well\r\nwritten and comprehensive analysis report based on the outcomes of the analysis. \r\nPresent analysis report in a multi-stakeholder workshop. \r\nSubmit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (50%)\", \"deliverables\": \"Sign Agreement \\r\\nSubmit the draft outline - Submit the draft budget analysis to be submitted to NGOF \\r\\nSubmit the well\\r\\nwritten and comprehensive analysis report based on the outcomes of the analysis. \\r\\nPresent analysis report in a multi-stakeholder workshop. \\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-10-07\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (50%)\", \"deliverables\": \"Sign Agreement \\r\\nSubmit the draft outline - Submit the draft budget analysis to be submitted to NGOF \\r\\nSubmit the well\\r\\nwritten and comprehensive analysis report based on the outcomes of the analysis. \\r\\nPresent analysis report in a multi-stakeholder workshop. \\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-11-09\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-10-07 07:24:54','2025-10-09 13:41:21',69,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}, {\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\"}]','',''),('eb0b4988-3d1e-4bd0-ae51-557ceac28952','Test from IT','NGOF/2026-003','Mr. Heng Dara','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','+85567408241','heng.dara@gmail.com','2026-01-15','2027-01-15',1000.00,1000.00,15.00,'$1000.00 USD','$850.00 USD','','Mr. SOEUNG Saroeun','Mr. Heng Dara','Freelance Consultant','One Thousand US Dollars only','','This is a testing system','this is the testing form','{}','[{\"description\": \"Installment #1 (100%)\", \"deliverables\": \"This is a testing system\", \"dueDate\": \"2027-01-15\", \"organization\": \"The NGO Forum on Cambodia\"}]','2026-01-15 06:35:11','2026-03-17 02:53:09',6,'[{\"name\": \"Ms. OUM Somaly\", \"position\": \"SACHAS Program Manager\", \"phone\": \"081 647 963\", \"email\": \"somaly@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','',''),('f136d57b-715c-4e8c-b64e-4f18bc2a30ba','Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','NGOF/2025-001','Mr. SEAN Bunrith','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','012 845 091','Seanbunrith@gmail.com','2025-12-01','2026-01-01',2500.00,2500.00,15.00,'$2500.00 USD','$2125.00 USD','','Mr. SOEUNG Saroeun','Mr. SEAN Bunrith','Freelance Consultant','Two Thousand Five Hundred US Dollars only','','Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\nSubmit invoice and receipt of the service; Sign Agreement\r\nSubmit the draft outline\r\nSubmit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.; Submit the draft budget analysis to be submitted to NGOF\r\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\r\nPresent analysis report in a multi-stakeholder workshop.\r\n Submit invoice and receipt of the service','Budget analysis for MAFF for the NGOF','{}','[{\"description\": \"Installment #1 (40%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\nSubmit invoice and receipt of the service\", \"dueDate\": \"2025-12-12\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #2 (30%)\", \"deliverables\": \"Sign Agreement\\r\\nSubmit the draft outline\\r\\nSubmit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\", \"dueDate\": \"2025-12-22\", \"organization\": \"The NGO Forum on Cambodia\"}, {\"description\": \"Installment #3 (30%)\", \"deliverables\": \"Submit the draft budget analysis to be submitted to NGOF\\r\\nSubmit the well-written and comprehensive analysis report based on the outcomes of the analysis.\\r\\nPresent analysis report in a multi-stakeholder workshop.\\r\\n Submit invoice and receipt of the service\", \"dueDate\": \"2026-01-01\", \"organization\": \"The NGO Forum on Cambodia\"}]','2025-12-12 02:31:52',NULL,1,'[{\"name\": \"Mr. MAR Sophal\", \"position\": \"PALI Program Manager\", \"phone\": \"012 845 091\", \"email\": \"sophal@ngoforum.org.kh\"}]','[{\"organization\": \"The NGO Forum on Cambodia\", \"short_name\": \"NGOF\", \"name\": \"Mr. SOEUNG Saroeun\", \"position\": \"Executive Director\", \"address\": \"#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia\", \"registration_number\": \"#304 \\u179f\\u1787\\u178e\", \"registration_date\": \"07 March 2012\"}]','','');

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `department`
--

INSERT INTO `department` VALUES (1,'PALI Program Manager','Policy research, advocacy, legal influence, secretariat for BWG & RCC','2025-08-19 07:44:24','2025-10-20 05:54:28'),(2,'SACHAS Program Manager ','Community transformation, capacity building, secretariat for NRLG & NECAW','2025-08-19 07:45:03','2025-10-20 05:54:13'),(3,'RITI Program Manager','Institutional resilience, governance, fundraising, secretariat for GGEDSI','2025-08-19 07:45:13','2025-10-20 05:53:52'),(4,'MACOR Program Manager','Organizational transparency, accountability, and sustainable operations','2025-08-19 07:45:26','2025-10-20 05:53:44'),(5,'Senior Management Team','The manage of all the departments','2025-08-19 07:48:16','2025-08-19 07:48:16');

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` varchar(36) COLLATE utf8mb4_general_ci NOT NULL,
  `contract_no` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `contract_type` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `organization_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT 'The NGO Forum on Cambodia',
  `representative_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT 'Mr. Soeung Saroeun',
  `representative_title` varchar(100) COLLATE utf8mb4_general_ci DEFAULT 'Executive Director',
  `organization_address` text COLLATE utf8mb4_general_ci,
  `organization_tel` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '023 214 429',
  `organization_fax` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '023 994 063',
  `organization_email` varchar(150) COLLATE utf8mb4_general_ci DEFAULT 'info@ngoforum.org.kh',
  `employee_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `employee_address` text COLLATE utf8mb4_general_ci,
  `employee_tel` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '',
  `employee_email` varchar(150) COLLATE utf8mb4_general_ci DEFAULT '',
  `position_title` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `working_hours` varchar(255) COLLATE utf8mb4_general_ci DEFAULT 'Monday to Friday: 08:00am-12:00pm and 01:30pm-05:00pm',
  `salary_amount` decimal(10,2) DEFAULT '0.00',
  `salary_grade` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '',
  `salary_amount_words` varchar(500) COLLATE utf8mb4_general_ci DEFAULT '',
  `medical_allowance` decimal(10,2) DEFAULT '150.00',
  `child_education_allowance` decimal(10,2) DEFAULT '60.00',
  `delivery_benefit` decimal(10,2) DEFAULT '200.00',
  `delivery_benefit_miscarriage` decimal(10,2) DEFAULT '200.00',
  `death_benefit` decimal(10,2) DEFAULT '200.00',
  `severance_percentage` decimal(5,2) DEFAULT '8.33',
  `thirteenth_month_salary` tinyint(1) DEFAULT '1',
  `employer_signature_name` varchar(150) COLLATE utf8mb4_general_ci DEFAULT 'Mr. Soeung Saroeun',
  `employee_signature_name` varchar(150) COLLATE utf8mb4_general_ci DEFAULT '',
  `employer_signature_date` date DEFAULT NULL,
  `employee_signature_date` date DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_general_ci DEFAULT 'active',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` VALUES ('19f6da01-8603-4a29-873a-14c59aff5d05','NGOF-UDC/001','Undefined Duration Contract (UDC)','The NGO Forum on Cambodia','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat Toul Tompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','Mr. Som Chettana','271\r\nPhnom Penh','013234535','som@ngoforum.org.kh','Finance and Operations Manager','2025-02-01',NULL,'Monday to Friday: 08:00am-12:00pm and 01:30pm-05:00pm',1200.00,'G4/L5','One Thousand Two Hundred US Dollars only',150.00,60.00,200.00,200.00,200.00,8.33,1,'Mr. Soeung Saroeun','Mr. Som Chettana','2025-02-01','2025-02-01','active','2025-10-22 09:49:57','2025-12-12 01:52:27','2025-12-12 01:52:27'),('206b974d-b1bd-47a1-9043-ec30792d751c','NGOF-UDC/001','Undefined Duration Contract (UDC)','The NGO Forum on Cambodia','Mr. Soeung Saroeun','Executive Director','#9-11 Street 476, Toul Tompong, P.O. Box 2295, Phnom Penh 3, Cambodia.','023 214 429','023 994 063','info@ngoforum.org.kh','Ms. Oum Somaly','#9-11 Street 476, Toul Tompong, P.O. Box 2295, Phnom Penh 3, Cambodia.','012 345 768','somaly@ngoforum.org.kh','Solidarity Action for Community Harmonization and Sustainability','2025-01-01',NULL,'Monday to Friday: 08:00am-12:00pm and 01:30pm-05:00pm',1500.00,'G4/L5','One Thousand Five Hundred US Dollars only',150.00,60.00,200.00,200.00,200.00,8.33,1,'Mr. Soeung Saroeun','Ms. Oum Somaly','2025-01-01','2025-01-01','active','2025-11-11 06:57:11','2025-12-12 01:52:23','2025-12-12 01:52:23'),('4f3df702-5cfa-4c0f-a01d-b39dfd7aaba4','NGOF-FDC/001','Fixed Duration Contract (FDC)','The NGO Forum on Cambodia','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat Toul Tompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','Mongkol','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','081647963','somaly@ngoforum.org.kh','PA','2026-01-01','2026-01-31','Monday to Friday: 08:00am-12:00pm and 01:30pm-05:00pm',800.00,'G4/L5','Eight Hundred US Dollars only',150.00,60.00,200.00,200.00,200.00,8.33,1,'Mr. Soeung Saroeun','Mongkol','2026-01-01','2026-01-01','active','2026-01-09 09:58:49','2026-01-09 09:58:49',NULL),('602803d2-bff3-41be-a8e9-433c1b2bd8a5','NGOF-FDC/001','Fixed Duration Contract (FDC)','The NGO Forum on Cambodia','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat Toul Tompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','Mr. Chan Vicheth','#155, St.113, Sangkat Boeung Keng Kang III, Khan Boeung Keng Kang, Phnom Penh.','012 953 650','vichethchan@gmail.com','Capacity Development Specialist','2025-01-01','2026-01-01','Monday to Friday: 08:00am-12:00pm and 01:30pm-05:00pm',1225.00,'G4/L5','One Thousand Two Hundred Twenty-five US Dollars only',150.00,60.00,200.00,200.00,200.00,8.33,1,'Mr. Soeung Saroeun','Mr. Chan Vicheth','2025-01-01','2025-01-01','active','2025-10-22 08:34:12','2025-12-12 01:52:30','2025-12-12 01:52:30'),('8b068368-a365-4678-8a69-0dd05413870c','NGOF-UDC/001','Undefined Duration Contract (UDC)','The NGO Forum on Cambodia','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat Toul Tompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','Mr. Chhea Chhouy','271\r\nPhnom Penh','067408241','chhea.chhouy@student.passerellesnumeriques.org','IT Programming Intern','2025-11-05',NULL,'Monday to Friday: 08:00am-12:00pm and 01:30pm-05:00pm',1250.00,'G4/L5','One Thousand Two Hundred Fifty US Dollars only',150.00,60.00,200.00,200.00,200.00,8.33,0,'Mr. Soeung Saroeun','Mr. Chhea Chhouy','2025-11-05','2025-11-05','active','2025-11-26 01:31:53','2025-12-12 01:52:18','2025-12-12 01:52:18'),('a5e508da-762e-4cf0-a88b-5f23fab428ba','NGOF-FDC/001','Fixed Duration Contract (FDC)','The NGO Forum on Cambodia','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat Toul Tompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','Mr. Kin Doung','271\r\nPhnom Penh','067408241','kin.doung@student.passerellesnumeriques.org','IT Programming Intern','2025-11-01','2026-11-01','Monday to Friday: 08:00am-12:00pm and 01:30pm-05:00pm',1500.00,'G4/L5','One Thousand Five Hundred US Dollars only',150.00,60.00,200.00,200.00,200.00,8.33,1,'Mr. Soeung Saroeun','Mr. Kin Doung','2025-11-01','2025-11-01','active','2025-11-26 01:33:00','2025-12-12 01:52:14','2025-12-12 01:52:14');

--
-- Table structure for table `interns`
--

CREATE TABLE `interns` (
  `id` varchar(36) COLLATE utf8mb4_general_ci NOT NULL,
  `intern_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `intern_role` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `intern_address` text COLLATE utf8mb4_general_ci,
  `intern_phone` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `intern_email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `start_date` date NOT NULL,
  `duration` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `end_date` date NOT NULL,
  `working_hours` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowance_amount` decimal(10,2) DEFAULT NULL,
  `has_nssf` tinyint(1) DEFAULT NULL,
  `supervisor_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `employer_representative_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employer_representative_title` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employer_address` text COLLATE utf8mb4_general_ci,
  `employer_phone` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employer_fax` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employer_email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `interns_chk_1` CHECK (json_valid(`supervisor_info`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interns`
--

INSERT INTO `interns` VALUES ('22245edc-3aca-4cb7-80c6-02ae30a9da9e','Mr. MangSeu Sork','IT-Intern','271 Phnom Penh','+85567408241','mangeseu.sork@student.passerellesnumeriques.org','2025-08-05','6','2026-02-05','8:00am – 5:00pm, Monday to Friday',150.00,1,'{\"title\": \"RITI Program Manager\", \"name\": \"Mr. CHAN Vicheth\"}','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat ToulTompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','2025-10-24 02:43:14',NULL),('31e99418-9195-4556-ac41-69c2a5a3655d','Mr. Chhea Chhouy','IT-Intern','BP 511, Phum Tropeang Chhuk (Borey Sorla) Sangtak, Street 371, Phnom Penh','+85567408241','chhea.chhouy@student.passerellesnumeriques.org','2025-08-05','6','2026-02-05','8:00am – 5:00pm, Monday to Friday',150.00,1,'{\"title\": \"MACOR Program Manager\", \"name\": \"Mr. SOM Chettana\"}','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat ToulTompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','2025-10-24 02:43:14',NULL),('4172cbcd-6e98-427b-8bfc-946b1fbd8ef6','Mongkol','PA','#9-11, Street 476, Sangkat Tuol Tumpoung I, Phnom Penh, Cambodia','','somaly@ngoforum.org.kh','2026-01-07','3','2026-04-07','8:00am – 5:00pm, Monday to Friday',250.00,1,'{\"title\": \"RITI Program Manager\", \"name\": \"Mr. CHAN Vicheth\"}','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat ToulTompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','2026-01-09 10:05:08',NULL),('97183329-cde2-40a2-9a36-f12f65351044','Ms. Dorn Sochea','Finance and Administrative Intern','BP 511, Phum Tropeang Chhuk (Borey Sorla) Sangtak, Street 371, Phnom Penh','+85567408241','socheadorn@gmail.com','2025-08-18','3','2025-11-18','8:00am – 5:00pm, Monday to Friday',150.00,1,'{\"title\": \"MACOR Program Manager\", \"name\": \"Mr. SOM Chettana\"}','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat ToulTompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','2025-10-24 02:43:14',NULL),('ad77f660-1439-4ab2-8af6-6e64cffc089e','Mr. Oeun Romas','PILI-intern','BP 511, Phum Tropeang Chhuk (Borey Sorla) Sangtak, Street 371, Phnom Penh','+85567408241','oeun.romas@gmail.com','2025-09-10','6','2026-03-10','8:00am – 5:00pm, Monday to Friday',200.00,1,'{\"title\": \"PALI Program Manager\", \"name\": \"Mr. MAR Sophal\"}','Mr. Soeung Saroeun','Executive Director','#9-11, St. 476, Sangkat ToulTompong I, Khan Chamka Morn, Phnom Penh, Cambodia','023 214 429','023 994 063','info@ngoforum.org.kh','2025-10-24 02:43:14',NULL);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `creator_id` int NOT NULL,
  `recipient_id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `message` text COLLATE utf8mb4_general_ci NOT NULL,
  `is_read` tinyint(1) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `related_contract_id` varchar(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `related_contract_id` (`related_contract_id`),
  KEY `ix_notifications_creator_id` (`creator_id`),
  KEY `ix_notifications_recipient_id` (`recipient_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` VALUES (99,1,1,'New Contract Created: Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','Contract NGOF/2025-001 created by RIDD Chansoksreynich',1,'2025-12-12 02:31:52','f136d57b-715c-4e8c-b64e-4f18bc2a30ba'),(100,1,1,'New Contract Created: Bank Policy Assesment using the Fair Finance Guide International (FFGI) Methodology','Contract NGOF/2025-002 created by RIDD Chansoksreynich',1,'2025-12-12 02:36:27','5adc61ca-a158-4a45-9022-6e5bab2e50af'),(101,1,1,'New Contract Created: Consultant for producing the video documentary to promote piloting SNR guideline in Ratanakiri Province.','Contract NGOF/2025-003 created by RIDD Chansoksreynich',1,'2025-12-12 02:53:21','e06fe057-972c-4dc8-a5db-aeecd13ac20f'),(102,6,1,'New Contract Created: Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','Contract NGOF/2025-004 created by KONG Sereymongkol',1,'2025-12-15 00:50:19','38d30f57-ad5a-412c-9fb9-6cb235fc6ea8'),(103,6,1,'Contract Updated: Consultant for the Development of Budget Analysis on Reviewing the MAFF’s Budget Allocation Trend','Contract NGOF/2025-004 updated by KONG Sereymongkol',1,'2025-12-15 00:51:15','38d30f57-ad5a-412c-9fb9-6cb235fc6ea8'),(104,6,1,'New Contract Created: Finance','Contract NGOF/2026-001 created by KONG Sereymongkol',1,'2026-01-09 08:53:27','58be417f-589d-47bf-b99e-556b2e342f4e'),(105,7,1,'New Contract Created: tfhdf','Contract NGOF/2026-002 created by CHHOUY Chhea',1,'2026-01-09 09:31:51','d6510e67-0a78-4cdb-9fe1-10ddc06d3f3c'),(106,6,1,'New Contract Created: Test from IT','Contract NGOF/2026-003 created by KONG Sereymongkol',1,'2026-01-15 06:35:11','eb0b4988-3d1e-4bd0-ae51-557ceac28952'),(107,4,1,'New Contract Created: Conduct a Research of Environmental and Social Impact Assessment (ESIA) on Chinese Investment in Cambodia','Contract NGOF/2026-002 created by  OUM Somaly',1,'2026-03-18 06:13:32','a6f73a2b-1f0f-494c-a8e1-338e80bcd130'),(108,1,1,'Contract Updated: Conduct a Research of Review Environmental and Social Impact Assessment (RESIA) on Chinese Investment in Cambodia','Contract NGOF/2026-002 updated by Administrator',1,'2026-03-18 06:35:21','a6f73a2b-1f0f-494c-a8e1-338e80bcd130'),(109,1,1,'Contract Updated: Conduct a Research of Review Environmental and Social Impact Assessment (RESIA) on Chinese Investment in Cambodia','Contract NGOF/2026-002 updated by Administrator',1,'2026-03-18 06:37:09','a6f73a2b-1f0f-494c-a8e1-338e80bcd130'),(110,16,1,'New Contract Created: Consultant for \"Toxic Rivers\" Documentary Production and Mekong Advocacy','Contract NGOF/2026-003 created by RUN Sothy',1,'2026-03-18 08:49:37','0a34d733-495c-41d6-bcad-9cc276bffd15'),(111,16,1,'Contract Updated: Consultant for \"Toxic Rivers\" Documentary Production and Mekong Advocacy','Contract NGOF/2026-003 updated by RUN Sothy',1,'2026-03-18 09:05:35','0a34d733-495c-41d6-bcad-9cc276bffd15'),(112,16,1,'Contract Updated: Consultant for \"Toxic Rivers\" Documentary Production and Mekong Advocacy','Contract NGOF/2026-003 updated by RUN Sothy',1,'2026-03-18 09:07:16','0a34d733-495c-41d6-bcad-9cc276bffd15'),(113,16,1,'Contract Updated: Consultant for \"Toxic Rivers\" Documentary Production and Mekong Advocacy','Contract NGOF/2026-003 updated by RUN Sothy',1,'2026-03-18 09:26:07','0a34d733-495c-41d6-bcad-9cc276bffd15'),(114,4,1,'New Contract Created: Community multi-stakeholders led initiative','Contract NGOF/2026-004 created by  OUM Somaly',1,'2026-03-23 07:06:37','cb04ad4f-102c-4ed4-9ef6-a9bb451667e1'),(115,4,1,'Contract Updated: Conduct research on locally available natural resources around Marine Fisheries Management Area (MSMA) to support and enhance local food processing','Contract NGOF/2026-004 updated by  OUM Somaly',1,'2026-03-23 07:49:01','cb04ad4f-102c-4ed4-9ef6-a9bb451667e1'),(116,16,1,'Contract Updated: Consultant for \"Toxic Rivers\" Documentary Production and Mekong Advocacy','Contract NGOF/2026-003 updated by RUN Sothy',1,'2026-03-26 04:36:22','0a34d733-495c-41d6-bcad-9cc276bffd15'),(117,14,1,'New Contract Created: Strengthening Civic Engagement and Oversight in Public Financial Management (SCOPE-PFM)','Contract NGOF/2026-005 created by Chhay Tola',1,'2026-04-09 03:16:40','a70f1e1b-dd3b-4977-9599-79b20da9b59c'),(118,14,1,'New Contract Created: Strengthening Civic Engagement and Oversight in Public Financial Management (SCOPE-PFM)','Contract NGOF/2026-006 created by Chhay Tola',1,'2026-04-09 03:58:18','087cb47d-2258-433f-a40c-32dc4e477346'),(119,14,1,'New Contract Created: Strengthening Civic Engagement and Oversight in Public Financial Management (SCOPE-PFM)','Contract NGOF/2026-007 created by Chhay Tola',1,'2026-04-09 04:16:39','92bc29ed-07a9-44eb-be41-6206e1e78b00'),(120,14,1,'Contract Updated: Strengthening Civic Engagement and Oversight in Public Financial Management (SCOPE-PFM)','Contract NGOF/2026-005 updated by Chhay Tola',1,'2026-04-09 04:32:23','a70f1e1b-dd3b-4977-9599-79b20da9b59c'),(121,14,1,'Contract Updated: Strengthening Civic Engagement and Oversight in Public Financial Management (SCOPE-PFM)','Contract NGOF/2026-007 updated by Chhay Tola',1,'2026-04-09 04:35:00','92bc29ed-07a9-44eb-be41-6206e1e78b00'),(122,14,1,'Contract Updated: Strengthening Civic Engagement and Oversight in Public Financial Management (SCOPE-PFM)','Contract NGOF/2026-005 updated by Chhay Tola',1,'2026-04-09 04:38:17','a70f1e1b-dd3b-4977-9599-79b20da9b59c'),(123,14,1,'Contract Updated: Production of 2020-2026 Citizen Climate Budget Booklets _ SCOPE-PFM','Contract NGOF/2026-005 updated by Chhay Tola',1,'2026-04-09 07:22:50','a70f1e1b-dd3b-4977-9599-79b20da9b59c'),(124,14,1,'Contract Updated: Production of 2020-2026 Citizen Climate Budget Booklets _ SCOPE-PFM','Contract NGOF/2026-005 updated by Chhay Tola',1,'2026-04-09 07:26:15','a70f1e1b-dd3b-4977-9599-79b20da9b59c'),(125,14,1,'Contract Updated: Assessment for 6 CSO Networks + Research on Green PFM, Tax Equity, Investment Climate, Procurement Transparency (SCOPE-PFM)','Contract NGOF/2026-006 updated by Chhay Tola',1,'2026-04-09 08:48:55','087cb47d-2258-433f-a40c-32dc4e477346'),(126,14,1,'Contract Updated: Production of 2020-2026 Citizen Climate Budget Booklets _ SCOPE-PFM','Contract NGOF/2026-005 updated by Chhay Tola',1,'2026-04-09 08:57:31','a70f1e1b-dd3b-4977-9599-79b20da9b59c'),(127,14,1,'Contract Updated: National Budget Trends & Ministries Expenditure Review (Budget Law 2027 Advocacy)_ (SCOPE-PFM)','Contract NGOF/2026-007 updated by Chhay Tola',1,'2026-04-09 09:06:18','92bc29ed-07a9-44eb-be41-6206e1e78b00');

--
-- Table structure for table `permission`
--

CREATE TABLE `permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permission`
--

INSERT INTO `permission` VALUES (15,'add_user','This permission and add user','2025-09-03 04:03:16','2025-09-03 04:03:16'),(16,'view_profile','This permission can view profile ','2025-09-03 04:03:44','2025-09-03 04:03:44'),(17,'view','This permission can only view','2025-09-03 04:04:02','2025-09-03 04:04:02'),(18,'manage the consultant contract','This permission can manage the consultant contract.','2025-09-03 04:04:53','2025-09-03 04:04:53'),(19,'crud_department all','This permission can crud the department.','2025-09-03 04:05:27','2025-09-03 04:05:27'),(20,'crud_all_user ','This permission can crud all users in system','2025-09-03 04:06:06','2025-09-03 04:06:06'),(21,'crud_role','This permission can crud role all system ','2025-09-03 04:06:38','2025-09-03 04:06:38'),(22,'view_dashboard page','This permission can view dashboard page','2025-09-03 04:07:14','2025-09-03 04:07:14'),(23,'view_summary report','This permission can view summary report.','2025-09-03 04:08:14','2025-09-03 04:08:14'),(24,'Admin','','2026-01-15 03:17:27','2026-01-15 03:17:27'),(25,'PM_Edit_Contract','PM can edit existing contract','2026-03-18 06:22:35','2026-03-18 06:22:35');

--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role`
--

INSERT INTO `role` VALUES (5,'Admin','I want to manage this system.','2025-08-19 07:26:47','2025-08-19 07:26:47'),(6,'Manager','I want to add more user in this system.','2025-08-19 07:27:42','2025-08-19 07:27:42'),(7,'Employee','I am a staff in your company.','2025-08-19 07:28:28','2025-08-19 07:28:28'),(8,'Executive Directive','I want to used this system.','2025-08-19 07:30:02','2025-08-19 09:15:29'),(9,'PM Edit Contract','set all Manager can edit contract','2026-03-18 06:19:54','2026-03-18 06:19:54');

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `role_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`role_id`,`permission_id`),
  KEY `permission_id` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role_permissions`
--

INSERT INTO `role_permissions` VALUES (5,15),(6,15),(8,15),(9,15),(5,16),(6,16),(7,16),(9,16),(5,17),(6,17),(7,17),(9,17),(5,18),(6,18),(7,18),(8,18),(9,18),(5,19),(5,20),(8,20),(5,21),(9,21),(5,22),(8,22),(5,23),(8,23),(5,24),(6,25);

--
-- Table structure for table `uploaded_docx`
--

CREATE TABLE `uploaded_docx` (
  `id` int NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `uploaded_at` datetime NOT NULL,
  `uploaded_by` varchar(120) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_uploaded_docx_uploaded_at` (`uploaded_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `uploaded_docx`
--


--
-- Table structure for table `uploaded_employee`
--

CREATE TABLE `uploaded_employee` (
  `id` int NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `uploaded_at` datetime NOT NULL,
  `uploaded_by` varchar(120) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_uploaded_employee_uploaded_at` (`uploaded_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `uploaded_employee`
--


--
-- Table structure for table `uploaded_intern`
--

CREATE TABLE `uploaded_intern` (
  `id` int NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `uploaded_at` datetime NOT NULL,
  `uploaded_by` varchar(120) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_uploaded_intern_uploaded_at` (`uploaded_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `uploaded_intern`
--



