WordPress database error: [Table 'wakafperak.aibim_project' doesn't exist]select project_id, project_code, project_name_en as project_name, project_desc_en as project_desc,
project_problem_statement_en as project_problem_statement, project_mechanism_en as project_mechanism,
project_impact_en as project_impact, project_member_en as project_member, project_bank,
project_main, project_target, project_duration,
project_status, project_status_publish, bank_name, main_state,
project_collection_close,
sum(transaction_amount) as raised_amount, project_progress,
(CASE WHEN project_target > COALESCE(sum( transaction_amount ), 0) THEN 'Aktif' ELSE 'SELESAI' END) AS target_status
from aibim_project
LEFT JOIN aibim_bank on project_bank = bank_id
LEFT JOIN aibim_main on project_main = main_id
LEFT JOIN aibim_transaction on transaction_project_link = project_id
WHERE project_status = 'Telah Aktif' AND project_status_publish = 'Telah Aktif'
GROUP BY project_id
HAVING target_status = 'AKTIF'
ORDER BY project_id DESC,project_name
PLEASE SELECT THE WAQF PROJECT.
| PROJECT TITLE | BANK | STATE | COLLECTION GOAL(RM) | RAISED AMOUNT(RM) | WAQF AMOUNT(RM) |
|---|
-Minimum amount of each project is RM 10.00
-The total amount should not exceed RM 30,000.00
-RM 0.50 will be charged per transaction
