Welcome to https://moneypenny.com

Installation

• npm install --legacy-peer-deps

Configure nginx (Not for production)

Proxy server setup for api in localhost

• Open /awzy-cms/nginx/conf/nginx.conf to change proxy_pass settings in line
• Update package.json - Change/Add proxy: http://localhost:5001

Windows

• complete the setup in nginx.conf file
• Open nginx folder and run nginx.exe
• To stop / reload server - Open task manager to delete your nginx instance and run nginx.exe to restart

MAC

• Check you have installed nginx (Homebrew)
• Run "vim /usr/local/etc/nginx/nginx.conf" in terminal
• :wq command to save and exit
• Copy /awzy-cms/nginx/conf/nginx.conf content with neccessary setup and paste it in "/usr/local/etc/nginx/nginx.conf" In terminal run,
• sudo brew services start nginx (Start nginx)
• sudo brew services restart nginx (Restart nginx)
• sudo brew services stop nginx (Stop nginx)

If port 5001 is blocked, follow below, else skip this step

• Update .env file - Change REACT_APP_LOCALHOST_BASE_URL to http://localhost:5002/moneyPlanner/services
• Dont forget to update package.json proxy property
• In line 11 Change listen 5001 to 5002
• Restart nginx
• Browse awzy in http://localhost:5002, as you have changed the port settings to 5002

Localhost mysql setGlobal (If required):

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

DEV run

-- npm start

Prerequisites

• Node version: V14.17.2
• npm version: V6.14.15
• react-router-dom: V5.1.2
• Codeigniter - V2
• PhP - V7.3 (Please dont upgrade as PhP8 does not support mysqli_query)

Build process:

• run "npm run build" in your root folder
• Dont forget to commit and push the entire files (including build folder) to repo

Cpanel deployment process:

• Open Git version control in cPanel
• Click Manage on "moneyPlanner"
• Click "Pull or Deploy"
• Click "Update from Remote" and "Deploy HEAD Commit"
• You are done.

Optimisations to handle

Cron update logics for Subscribers MySql table

Options	When
Big data (Hadoop and HD insights)	10 Million + Transactions
Cloud (GCP / Azure / AWS) Logic Apps	10 Million + Transactions
MySql (SP) with Cron.php (Cost effective) with table partition based on date	Below 1 Million Transaction

Solution Implemented

• MySql (Stored Procedure) called in loop of Cron.php as effective async call with 100 batches per loop
• Update table (Account table) fields with utilized count
• Insert data based on above field count
• Else force logout and redirect to payment page (with appropriate plan selection and pricing)

Good Luck

Author: Bharani Palani | tp.bharani@gmail.com | https://bharani.tech