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