We have drivers who pick up medical specimens throughout the US.
They pick up at the same locations each day. It's called a route.
At the completion of their route, they must submit a picture or file copy of their route sheet that tells us what times they stopped at each clinic, and what they picked up there. Currently, they email them. It's very disorganized because they never use the correct email subject or filename, among other things. With your help, we aim to make this much more organized.
3 web pages with background database:
ADMIN "DRIVER USERS"
WEB PAGE #1
Admin adds drivers (users)
Form fields ask:
Email*
Last name*
First name*
Route 1* (max 10 characters, examples: LAX DAV 01, PHX DAV 02, CHI SPE 01)
Progenity (Yes checkbox)
Route 2
(max 10 characters, examples: LAX DAV 01, PHX DAV 02, CHI SPE 01)
Progenity (Yes checkbox)
Route 3
(max 10 characters, examples: LAX DAV 01, PHX DAV 02, CHI SPE 01)
Progenity (Yes checkbox)
DRIVER UPLOAD PAGE
WEB PAGE #2
Email* (should autofill next time)
Route name*
(if more than one route is entered for this driver, there should be radio buttons for which route he is submitting)
Piece Count (Progenity Checkboxes Only*)
(number, max 99)
Comments
(max 300 characters)
+ Upload Files button
(acceptable types: xls*, pdf, jpg, png)
WEB PAGE #2
This is our report page.
At the top of the page:
Date (default is today PST)
Progenity Count total (add all progenity counts for the date chosen)
Route Sheet Count total (successfully uploaded files)
Columns display:
Received (checkbox, see note1 below)
Customer (1st 3 digits of route name)
SubCust (2nd 3 digits of route name)
Route Name (Entire route name)
Driver (Last name, First name)
Progenity Count (if any)
We should have the ability to delete an upload record, in case the driver had to upload twice, or uploaded the wrong date, etc.
Note1: If a driver tries to upload a file, and it fails, then their upload should appear on the list, but NOT as received. If possible, the reason it was not received should be provided. Such as: upload interrupted, driver did not provide file, upload cancelled by driver
Note2: If not difficult or expensive, then a GPS location of the driver should be provided during upload and on the report (this can be a small link to a map or a current address column on the report). The driver should not be aware of this feature.
EMAILING
For now, this is only for dates Monday through Friday
At 21:30 PST, the system should email any driver who has not yet submitted a route sheet (once a driver performs their first upload, they should be added as a driver) for <date>
At 22:00 PST, the system should again email any driver who has not yet submitted a route sheet for <date>
At 22:30 PST, the system should again email any driver who has not yet submitted a route sheet for <date>
At 23:00 PST, the system should again email any driver who has not yet submitted a route sheet for <date>
At 23:30 PST, the system should again email any driver who has not yet submitted a route sheet for <date>
At 24:00 PST, the system should again email any driver who has not yet submitted a route sheet for <date>
and it should continue to email them every 30 minutes until it has been submitted.
I hope I have provided most of the information required. I am unsure of all the skills required.
PLEASE USE PM ONLY FOR SPECIFIC QUESTIONS.
Dear Employer.
I am a talented and experienced web developer.
I'll work on your project sincerely and finish them up to your expectation. I'll also finish them on time and service for you till you are satisfied.
Customer satisfaction is my main motto. Thanks for spending your valuable time on reading my bid.
Best regards.
We are a team of designers and developers with expertise and experience in Photoshop, HTML5, CSS3, PHP, AJAX, JQuery, XML, Wordpress, Bootstrap, CodeIgniter, Laravel, Google Map API and MySql. We have designed and coded many custom sites and applications of varied extents and complexity.
I have read through the requirements. While most of it is clear, the progenity part is not. Please explain. Also Note 1 and Note 2 does not seem possible / feasible. I think you should keep a password for driver login when he submits his report.
Please share a sample report so that I understand thoroughly the following:
Received (checkbox, see note1 below)
Customer (1st 3 digits of route name)
SubCust (2nd 3 digits of route name)
Route Name (Entire route name)
Progenity Count (if any)
Once I am clear on the entire requirement, I will be able to assess scope of work precisely. I will revise / confirm my bid accordingly. Detailed specifications and inputs will also help me to make an informed commitment and deliver as required.
I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project.
You are highly rated with many projects to your credit and I will consider it a privilege to offer my services to you. I look forward to this project as an opportunity to establish a long term association.
Hello,
I have exhaustive experience of more than 6 years with design and creation of software We are contemporary Website design and development company with a focus on user-centered design.
I am expert in PHP, wordpress, HTML5, XHTML, CSS, bootstrap, Javascript, Ajax, MySQL, MSSQL, and all standard database platforms.
I am waiting for your response.
Thanks & Regards
Ankit
Dear employer.
I have read your project description carefully.
I'm strong in php, mysql, cron jobs and google map api.
I can finish this within 4 days correctly.
Please contact me and start work.
Regards.
Hi,
Greetings!!
We can do this using PHP, mysql. I have 6+ years of experience in development.
⭐⭐Job Brief⭐⭐
Your requirements are simple. Please verify.
You have mentioned 3 pages. Actually, there should be at least 2 more page like Login Page & Driver Listing page.
Login PAGE :- If Admin login, the admin access pages like Drivers listing page, Add Driver page, Report page. If driver login, then driver access upload route sheet page.
WEB PAGE #1 (Add Driver Page)
->Email
->Last name
->First name
->Route 1* (max 10 characters)
->Progenity (checkbox)
note:- Route, Progenity fields pair will be upto 3
WEB PAGE #2 (DRIVER UPLOAD Route Sheet Page)
->Email
->Route name(routes added by admin)
->Piece Count (Progenity Checkboxes)
->Comments (max 300 characters)
->Upload Files button (acceptable types: xls*, pdf, jpg, png)
WEB PAGE #3 ( Report page for Admin)
At the top of the page:
->Date (today PST)
->Progenity Count total
->Route Sheet Count total
Columns display:
->Received (on condition)
->Customer (1st 3 digits of route)
->SubCust (2nd 3 digits of route)
->Route Name (route)
->Driver (Last name, First name)
->Progenity Count (if any)
->Action Column (for delete)⭐
⭐Extra Feature⭐
#GPS feature.
Comment:- We can integrate this feature later on.
#EMAILING Feature
System will send a email to each driver after every 30 min. who has not submitted route sheet for that date from Monday to Friday
Comment:- That will be done.
========
Eagerly waiting for your reply!!
Thanks
Hey,
I am having 10+ Years of experience in PHP/MYSQL
250+ Positive Reviews.
Over 90% Completion Rate.
5 Star Rating.
Looking for a long term relationship.
Hello, all items that you've mentioned will be successfulllyimplemented.
PHP Scripts which I wrote on Freelancer.com:
https://www.freelancer.com/projects/javascript/Google-app-Script-16324428/
https://www.freelancer.com/projects/php/Help-turn-Node-function-into/
https://www.freelancer.com/projects/php/Create-small-script-that-creates/
https://www.freelancer.com/projects/php/Consignment-Reports/
Hello
I worked 'upwork ' some time ago.
But my account was blocked without knowing the cause.
I want to complete my profile as soon as possible.
So I do not demand a lot of money.
I am having enough skill and experience to work your job.
I think you can understand my proposal.
Thank you so much for your interest.
Hi,
It is my great honor to work on your project. I have all skills and experience for which you are looking for.
Yes, I can do it.
My relevant skills for the project and expertise in the required skills makes me the right candidate to award the job.
Skills:-
Programming and Development
• CodeIgniter , Laravel
• PHP7,Cake PHP
• Wordpress theme and Plugin customization
• Js , Javascript
Web Designing and Frontend
• HTML5
• Bootstrap
• Graphic, Web Design
• Vectorization, illustrator
• Adobe Photoshop, Logo
Looking for reliable and quality resource. I am here for you. Focus on quality and finish the task on time is my top priority.
I am expecting a small chat session and finalize the details, please confirm your online availability.
Thanks
Sumit
Hi there,
i have gone through your complete project requirement and understood very well .
as per your requirement i will create it in custom php there will be admin panel and driver panel , user panel . admin panel manage by admin to add drivers, roots view reports etc. and driver panel for drivers they can upload their reports. and we will make it same as per your requirement.
i have 6 year experience in custom php ,website designing and other framework in php.
i had done this kind of job for medical representative to submit their daily sheets.
so i can easily handle this project and will complete it 100% satisfaction.
kindly drop me message to discuss more .
Hello,
I have read your requirements and it is not technically problematic.
If you believe me and give me this assignment, I assure you that you can build a project that is higher than the height you require.
Please read the feedback comments I've received from my past clients.
It will tell you about my working ability and style.
I'm very confident in the tasks you want to get done.
My special ability is to learn the stuff quickly and I'm good at problem-solving.
I would like to discuss more details as soon as possible and I will be available to start work immediately.
Thanks,
Yin
Hi,
Do you need a mobile app or a web site for the drivers and admin or both?
I am suggesting to build with. NET and SQL database.
You would also need SSL (https) for your site that would be additional one time cost.
Lastly, for a scheduled task to run, you will need appropriate hosting that supports scheduled tasks and allows higher SMTP relay as this job will send periodic emails to drivers.
Do you already have hosting or you plan to buy it.
Lets us discuss.
Awaiting your response.
Hi,
This project is quite interesting. Since it comprises various views and multiuser support, I would like to work in it since I have all of the required skills to get this done for you. Because on my solid experience in web development, I can assert that this project can be driven to success.
Since the system is intended to be designed and developed from scratch, solid knowledge of software architecture and systems design are required in order to deliver a software product that could be scaled, mantained and grow in complexity as the business does.
Thanks for the details and clarity in the description of your requirements. I hope we get in touch soon and get this done altogether.
Regards,
J.D.M.