[x] The select2 field for CompanyID by default is blank. can choose to fill it or not.
[x] After key-in all details, the total sum of fees is saved to TotalFee column in BannerApplication table. The calculation formula is: if(ExtraFee==null) BannerCode.PeriodFee BannerObject.BSize BannerObject.BQuantity, else BannerCode.PeriodFee BannerObject.BSize BannerObject.BQuantity + ExtraFee * BQuantity.
[x] The Reference number is saved in ReferenceNo column with the format CurrentYear/BA/NEW/BannerApplicationID with 6 leading zero
[x] Put comment section below the Required Documents list, following the ManagePremiseApplication as example
[ ] After clicking on submit button, the AppStatusID changes to 6 and the application appears in Director's list of BannerApplication
[ ] The Director can edit, comment and select a dropdown for Approve/Revert Back to Clerk. Selecting Approve and submit will change AppStatusID = 9, and the current date is saved in DateApproved column, while selecting Revert to Clerk and submit will change AppStatusID = 3. After submitting, the application appears at Clerk's list.
[ ] The clerk will click button to generate Letter of Acceptance only if it is Approved and print it and give to public to sign. After the public sign. the Clerk will click a button 'Public Accept & Sign'.
[ ] Clicking on button 'Public Accept & Sign' will add entry into PaymentDue table. Save the BannerApplication Reference number into PaymentFor column. DueDate column is CurrentDate + 1 month. BilledBy column is the clerk Users.FullName. The AppStatusID changes to 12.
[ ] After Desk Officer received payment from public, they will click on 'Paid' button in ManageBannerApplication page. This will add entry into Payment Received table and the entry in PaymentDue.BillStatus changes to 1. The AppStatusID changes to 13 and the current date is saved in DatePaid column. The current date + 1 year is saved in column ExpireDate. The LicenseStatus is set to 'Lulus'. The Reference number is saved in ReferenceNo column with the format CurrentYear/BA/Available ID (with 6 leading zero)
[ ] The Clerk, Supervisor or Director can now go to ManageBannerApplication page and click on 'Print License' button to generate the PDF. The AppStatusID changes to 14.
[ ] Clicking on the 'Complete' button changes the AppStatusID to 15.