Below are the requirements:
(1) Run Analysis - The JSP programs should allow a user to select and run a SQL statement with a time period option. Then retrieve the records. The records are then shown in a table, a bar chart and a line chart. The attached picture is the expected result. The charts should be created on the fly by using any jQuery library.
(2) Manage Analysis - The JSP programs should allow a user to add, edit, delete SQL statements that are shown in (1). The SQL statements should be stored in a separate table in the SQLite database.
(3) Import data - everyday, many new files (0 to thousands files) with the same CSV format are created in a directory by other programs. Each file contains 0 to thousands of line (each line is a record). The JSP program should:
a.) When a user imports files, records of the new files will be stored into the SQLite database.
b.) If a user tries to import a file more than once on the same day, there is no record to be stored into the SQLite database because the records have already been imported. Please do not use SQL to restrict the import. Should use JSP. This is because contents of records may be identical.
c.) If a user has not imported files for some time, the JSP program should be able to import all the files that are not imported yet.
d.) If there is no database available, the JSP program will create the database.
(4) Submit data – The JSP program should email (SMTP with and without SSL) and upload records (HTTP and HTTPS) retrieved from running SQL statements to an email address and to another URL address. A user will preview the records before emailing and uploading the results. The user has the choice not to email and upload one or more particular records.
(5) Move data - as number of files will keep increasing, the JSP program should move the files to other directories for backup and easy management purpose every month. The naming conventions of the backup directories should be “<MONTH>-<YEAR>”, like “07-2011”. The SQLite database file should be backuped every month and store under the backup directories.
(6) Settings – The JSP program should allow a user to edit the parameters of the programs. The parameters are stored in a table in the SQLlite database. The parameters are:
a.) database path - the full path of the SQLite database
b.) directory (as described in 3) - where the new files are stored.
c.) email (as described in 4)
d.) URL (as described in 4)
e.) backup directory (as described in 5) - where the backup directories are.
Milestones will be created for:
a.) 25% of the payment - Successful demonstration on developer’s or employer’s Jetty server for (1), (2), and (3).
b.) 25% of the payment - Successful demonstration on developer’s or employer’s Jetty server for (4), (5), and (6).
c.) 50% of the payment - Delivery of the WAR file and all source code.
ALL RIGHTS CREATED AND DEVELOPED UNDER THIS PROJECT BELONG TO THE EMPLOYER. THE DEVELOPER AGREES TO TRANSFER AND ASSIGN ALL RIGHTS IN THIS PROJECT TO THE EMPLOYER. THE DEVELOPER AGREES TO WAIVE MORAL RIGHTS.
Please do not bid unless you understand fully about the requirements. Please feel free to message me if you have any questions.
Bu iş için 14 freelancer ortalamada $2997 teklif veriyor
Dear Sir/Madam I have gone through the requirement. And I am having 3 yrs of java j2ee development exp and i am SCWCD certified. Looking for your Positive response. Thanks and Regards
We would love to work for you and believe we will be able to deliver as per your requirement and expectations. Eagerly looking forward to do business with you. Please visit PM for details about us.
i have an expert team to develop this kind of work .. so lets start our project sir ?? i am waiting for your positive response ... please check PM for your more benefit sir ...