PROJECTGIVE COMPLETE PACKAGE v1.2 CONTENTS 1. public-website/ - public pages, member portal, community, Flutterwave and website admin. 2. management-portal-patch/ - isolated files to add to management.projectgive.com.ng. 3. database/ - membership workflow database tables. SAFE INSTALLATION ORDER 1. Back up the Management Portal files and MySQL database. 2. Upload the contents of public-website/ to the public website document root. 3. Copy public-website/app/config.example.php to app/config.php and enter database, app URL and Flutterwave values. 4. Import public-website/database/install.sql. 5. Import database/membership-workflow.sql. For an upgrade where membership_applications already exists, add the four v1.2 columns manually if missing: ended_by, welcome_email_sent_at, welcome_email_sent_by and their foreign keys. 6. Upload management-portal-patch/membership-applications.php into the Management Portal root. 7. Upload management-portal-patch/app/welcome.php into the Management Portal app/ directory. It may replace the same existing file because it is the matching welcome template. 8. Add a menu link in the existing Management Portal to /membership-applications.php. This is optional; notifications already link directly to the page. 9. Configure mail/SMTP in the existing private Management Portal configuration. 10. Test with a new application before opening the public form. WORKFLOW - A public application creates Management notifications and a Management group-chat system message. - A Management user opens the applicant details. - The user may assign/send it to another Management member, request information, approve or decline. - End Process & Create Member inserts the approved applicant into the existing members table and generates the next PG code. - Send Welcome Email becomes available only after the member has been created. - Every action is written to membership_application_actions. NO EXISTING MANAGEMENT PAGE OR DESIGN IS replaced by this package, except app/welcome.php where the same welcome-email helper is supplied for compatibility.