Single and multi file upload using jsp,json,jquery,mysql

Requirement

1. Front end page to upload one or more files with validation of listed file extentions.

Validation (Currently we are using this UI reference to upload files...[login to view URL])

A.) (File format- GIF, JPG, PNG, JPEG, PDF, WORD, EXCEL)

B.) If it's multiple file uploading restrict to 10 files only.

2. File and file metadata to be sent to backend.

A.) (Follow the same JSon, JSP method to save in the DB) DB structre.

B.) Store following details in the table

PRIMARY TABLE

CREATE TABLE `ib_buyer_rfq_document` (

`ID` int(11) NOT NULL,

`signup_id` int(11) NOT NULL,

`rfq_id` int(11) NOT NULL,

`created_date` varchar(12) NOT NULL)

SECONDARY TABLE

CREATE TABLE `ib_buyer_rfq_document`(

`ID` int(11) NOT NULL,

`rfq_id` int(11) NOT NULL,

`file_name` varchar(50) NOT NULL,

`file_type` varchar(10) DEFAULT NULL,

`filesize` varchar(20) NOT NULL,

`file_path` varchar(500) DEFAULT NULL,

`deleted_date` varchar(12) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

C.) Provide option in the code to set file path example for windows D:\supplier\ for linux we will change it to /usr/local/supplier/

D.) File uploaded should have following file name saved in the server for example if we upload [login to view URL] file name should be

[CURRENTDATE]_[CURRENTTIME]_[BROWSERLOCATION]_[FILENAME].PDF

NOTE: All files should be unique. Supplier will be main folder in side supplier every day new folder with current date got be created and files should get uploaded over there Eample

D:/supplier/11/05/2023

D:/customer/11/05/2023

backend page to accept and store these files on disk storage. Disk storage to have 2 different directories for supplier and customer.

Storing of file metadata in the DB. Masking of file name in storage.

3. Front end page to show thumbnail. on click of thumbnail show a preview.

A) THUMNAIL should have good clarity. Image preview shold have previous, next to navigate images.

B). IF pdf, word, excel provide download on click file should dowload.

C) This page will be in table format...

Add option to download file. Thumbnails to be only provided for image type of files.

Backend page to send file and thumbnail data to frontend when requested.

JavaScript Java MySQL PHP jQuery / Prototype

ID do Projeto: #36582056

Sobre o projeto