Bulk Update Functionality for Zero-Fee Processing
Budget: ₹600 – ₹1,500 INR
Introduce bulk update functionality to apply zero processing fee for customers over a certain period.
UI changes
Maker checker radio button
Click on maker then upload button and download sample button
Click on checker list of upload file will be shown and upload is given
Maker will be able to upload Introduce bulk update features for zero processing fee by CIF ID from admin.
Validates user role — only Maker can upload.
Accepts a .txt file and saves it to the server.
Checks file content for malicious input.
Parses file line-by-line using | delimiter.
Validates each row and maps to a data model.
Logs invalid rows with detailed error messages.
Check in DB if disbursement status=1 then don't update the data and remove this from valid records, Save the cif with details in a txt file
Save audit trial data in database
Saves valid records to the database in temp table.
Generates and stores a CSV error log file if errors exist with reason.
Returns success or failure message to the view.
when user click on checker the list of upload will be shown
Validate user is checker and not same as maker and can upload in tbl_preapproved_loan2
Update column in tbl_preapproved_loan2
Delete the data from temp table
UI changes
Maker checker radio button
Click on maker then upload button and download sample button
Click on checker list of upload file will be shown and upload is given
Maker will be able to upload Introduce bulk update features for zero processing fee by CIF ID from admin.
Validates user role — only Maker can upload.
Accepts a .txt file and saves it to the server.
Checks file content for malicious input.
Parses file line-by-line using | delimiter.
Validates each row and maps to a data model.
Logs invalid rows with detailed error messages.
Check in DB if disbursement status=1 then don't update the data and remove this from valid records, Save the cif with details in a txt file
Save audit trial data in database
Saves valid records to the database in temp table.
Generates and stores a CSV error log file if errors exist with reason.
Returns success or failure message to the view.
when user click on checker the list of upload will be shown
Validate user is checker and not same as maker and can upload in tbl_preapproved_loan2
Update column in tbl_preapproved_loan2
Delete the data from temp table