Task ID ------- US731 Admin – Alert Messages – Reports and Tariff Changes Git Branch Name --------------- US731-admin-alert-messages-reports-and-tariff-changes File List --------- new file: app/Console/Commands/SendAlertMessage.php new file: app/Http/Controllers/AlertMsgConfigController.php new file: app/Models/AlertMsgConfig.php new file: app/Models/AlertMsgConfigUser.php new file: app/Models/EmailLog.php new file: app/Models/ReportList.php new file: app/Models/TariffList.php new file: app/Traits/AlertNotification.php new file: public/css/bootstrap-select.min.css new file: public/js/admin/alertMsgConfig.js new file: public/js/bootstrap-select.min.js new file: resources/lang/en/alertMsgConfiguration.php new file: resources/views/admin/alert_msg_config.blade.php new file: resources/views/email/alert-msg-report.blade.php new file: resources/views/email/tariff-change-notification.blade.php new file: sql/US731.sql modified: app/Console/Kernel.php modified: app/Helper/HelperMail.php modified: app/Http/Controllers/AdditionalTariffController.php modified: app/Http/Controllers/OvernightTariffController.php modified: app/Http/Controllers/ReportController.php modified: app/Http/Controllers/TariffController.php modified: app/Http/Controllers/TransactionController.php modified: app/Http/Middleware/AuthorisationAccess.php modified: app/Http/routes.php modified: app/Models/User.php modified: public/js/sps.js modified: resources/lang/en/menus.php modified: resources/views/admin/additional_tariff_report_pdf.blade.php modified: resources/views/default.blade.php Database changes ---------------- sql/US731.sql In case of new tariff addition to the system -------------------------------------------- 1. Insert tariff in the table `sps_tariff_list` After inserting tariff menu in table `sps_menu`, it is require to insert the same in table `sps_tariff_list`, `sps_menu`.`menu_item` = `sps_tariff_list`.`tariff_name` 2. Code In the respective controller file please add code in update method Please take reference of file - app/Http/Controllers/TariffController.php In case of new report addition to the system -------------------------------------------- 1. Insert report in the table `sps_reports_list` After inserting report menu in table `sps_menu`, it is require to insert the same in table `sps_reports_list`, `sps_menu`.`menu_item` = `sps_reports_list`.`report_name` 2. Code Code need to be added for respective report specifying route and parameters in file app/Console/Commands/SendAlertMessage.php in switch case Artisan Command (background process) ------------------------------------ php artisan sendalertmessage