Lengkap

Import CSV file to generate reports online system

Summary of project:

Must make use of PHP and mySQL to create system. The admin will load csv files for a specific date range and the data will then be visible for the user to view stats based on that imported CSV for the period. There is no fancy design for this, is purely a reporting system. We will just have the client logo at the top op all pages.

There will be 2 sections to this project:

Section 1: Admin section

Section 2: Client Side

Section 1 Admin:

Once logged in there needs to be the following menu:

Import Current Month || Archive Import || Suppliers

IMPORT CURRENT MONTH

Here we will have an upload field where the CSV file will be selected, and the date range of the CSV file must also be set here from Start Date to End Date. Once file is imported, it must just say file imported successfully or if there was an error state the error.

ARCHIVE IMPORT

Once a month is complete, we must be able to import a CSV file and select the month this report is linked to. So if I do this today, I will select from dropdown APRIL 2018 as I cannot do it for a month in progress, only once a month is completed. Again once file is imported, it must just say file imported successfully or if there was an error state the error.

SUPPLIER

Under supplier we will list all the users and have 3 options here:

New | Edit | Delete

Edit just changes the details and Delete well is just delete user

When adding a new user we will ask the following:

Name | Surname | Email Address | Contact Number | Username | Password | Client ID

That is all the admin section must do - There is NO reporting in admin section

//////////////////////////////////////////////////////////////////////////////////////////////////////////////

Section 2: Client Side

Landing page will have a login box. You cannot register from the front, can only happen in the admin section. Only option we have here is FORGOT password - and you will enter your email address and get an email with your password. You cannot reset your password, must be done manually by admin in top section.

Once logged in we have a menu with following:

Current Month | Previous Months

CURRENT MONTH

When I click on this page it will show me a report as per attachment called [login to view URL] The info for this report will be from the CSV imported. The header of the page will be "Sales Report for start date - End Date" At the bottom I need a button called "Export to PDF"

PREVIOUS MONTHS

On this page we will have a dropdown where we can select previous month uploads, again we will not be able to show the current month, as this ONLY shows the completed [login to view URL] I select a month, I will see the same format report as on the Current MONTH, just for the entire previous month selected. Again option to export to PDF.

MORE ABOUT THE CSV FILE.:

I have uploaded the CSV file we will be importing. We will only be using the columns mentioned below.

Column T: is the UNIQUE client ID which we will know what info to show for this user. So when we filter the imports we will ONLY show the data for this specific user where his Client ID is on.

Column B: Is the product Name

Column C: Qty Sold

Column P: Cost Price of Item

Column Q: Selling Price

The profit will be worked out with Column Q minus Column P multiply Column C or in words: Selling Price - Cost Price x Qty Sold

Kemahiran: MySQL, PHP, Kejuruteraan Perisian

Lihat lagi: sql 2005 express import csv file, import csv file sql, import csv file sql table, import csv file sql express 2005, sql express 2005 import csv file, import csv file sql server 2005 database, vb6 mssql import csv file, import csv file database dts, import csv file sql database express, aspnet import csv file sql server, script import csv file database, import csv file sql 2005 using wizard, import csv file sql server 2005

Tentang Majikan:
( 103 ulasan ) Johannesburg, South Africa

ID Projek: #16979657

Dianugerahkan kepada:

trustus

We have a team of Skilled PHP professionals with expertise in Laravel, Codeigniter, Magento, WordPress and other open source packages. We would like to work on this project as we creates lots of this kind of applica Lagi

R1555 ZAR dalam 5 hari
(157 Ulasan)
8.1

8 pekerja bebas membida secara purata R1441 untuk pekerjaan ini

R2200 ZAR dalam 3 hari
(89 Ulasan)
5.9
CodeRaiser

Hello. I have 10+ years experience in website building. Will complete requested job with much attention to details and logic. No additional payments required. My bid is final price for what you have requested. No prepa Lagi

R3288 ZAR dalam 5 hari
(45 Ulasan)
4.9
spearheadtechno

My name is param.I have experienced in developing and implementing interactive websites for recently 5+ years. I am Innovative in technology. Able to complete tasks efficiently and providing services unless clients ar Lagi

R1000 ZAR dalam 3 hari
(5 Ulasan)
3.6
tahirkhan14

I'm a web and app developer with 7 years experience in PHP, MySQL, CSS3, HTML5,android and WordPress, WP plugins, and 3rd party API shopping engines, etc. you can check my recent work in wordpress here: Lagi

R1088 ZAR dalam 3 hari
(1 Ulasan)
1.8
R1088 ZAR dalam 3 hari
(0 Ulasan)
0.0
techdesignz2

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Lagi

R1068 ZAR dalam 7 hari
(0 Ulasan)
0.0
ajitmakawana143

Hello, I have read your post.I know you'll probably get a bunch of lowball bids. Message me for more discussion. Thank You.

R240 ZAR dalam 2 hari
(0 Ulasan)
0.0