Find Jobs
Hire Freelancers

Import CSV file to generate reports online system

R210-1750 ZAR

已完成
已发布将近 6 年前

R210-1750 ZAR

货到付款
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
项目 ID: 16979657

关于此项目

7提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 application where admin can upload data and front end client can view it. We will provide you life time guarantee on our work / code. If you find any bug on our code in future, we will fix that quickly and without any cost. We are available from Monday To Friday, 9 hours a day. Our timezone is GMT+5.30. Please start communication to discuss. You will be able to directly communicate with our technical expert. By doing this work, we are interested in developing long term relationship by displaying our quality. Thanks for reading our proposal. Regards.
R1,555 ZAR 在5天之内
4.9 (167条评论)
8.1
8.1
7威客以平均价R1,494 ZAR来参与此工作竞价
用户头像
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 prepayment required Lets have a quick chat to clear details Talk soon Vlad
R3,288 ZAR 在5天之内
4.9 (45条评论)
4.9
4.9
用户头像
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 are not fully satisfied. Providing quality is my first priority. Technical Skills - HTML5 - CSS3 - Javascript - jQuery - PHP - Codeigniter Areas of Expertise - Advance programming and design skills - Web Content Management - Landing page development - Project Management - Bootstrap - Strong collaborative skills - Website Optimization - API Integration - Excellent Problem solving skills - Graphics Designing - Psd to HTML - Psd to wordpress. - Photoshop I am providing cost effective solutions to my global clients with accurate time and cost estimation commitment. I provide 24/7 online support for every project. Thank you & regards, Param
R1,000 ZAR 在3天之内
3.4 (5条评论)
3.6
3.6
用户头像
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 在2天之内
0.0 (0条评论)
0.0
0.0

关于客户

SOUTH AFRICA的国旗
Johannesburg, South Africa
5.0
104
付款方式已验证
会员自11月 15, 2006起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。