Ralat pangkalan data WordPress: [Table 'wakafperak.aibim_project' doesn't exist]SELECT project_id, project_code, project_name, project_desc, project_problem_statement, project_mechanism, project_impact, 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
SILA PILIH PROJEK WAKAF.
| NAMA PROJEK | BANK | NEGERI | SASARAN KUTIPAN(RM) | JUMLAH KUTIPAN(RM) | NILAI WAKAF(RM) |
|---|
-Nilai minimum setiap project adalah RM 10.00
-Jumlah keseluruhan tidak boleh melebihi RM 30,000.00
-Setiap transaksi akan dicaj sebanyak RM 0.50
