Simple client gets logs lists from MySQL db
- Clone the repo
- Run the
/api/smsedge.sql
script - Open localhost:9000 server in /api dir
npm install && npm start
will open a browser at localhost:3000- Enjoy browsing
At the bottom of the /api/smsedge.sql
you can find a SP called sp_move_bunch_logs
, it accepts a Y-m-d
date and moves safely bunch of rows to a new send_log_aggregated
table with aggregated log_created_aggregated
column
- PHP 7.1
- MySQL 5.7
- Node.js 6+ (tested on 10)