Find Jobs
Hire Freelancers

MySQL - Restrict view results by date

$10-30 USD

Completed
Posted almost 6 years ago

$10-30 USD

Paid on delivery
I have a view that returns a list of all bus passengers that need to be picked up on a given day (monday - sunday). When a user is picked up, a record is written to a table named "trip_history". This table contains a date/timestamp for that ride. 2 rides are allowed per day/per rider - the ride to their destination and their ride home. I want to add functionality to this view to restrict that list to not show riders that have already been recorded in trip_history for the AM and PM trip. So, if the db view shows 3 riders available for pickup: Jim Jack Beth If I pick Jim up in the AM, I want the view to: 1. Check if the current system date/time is in the AM (time between 00:00:00 and 11:59:59) 2. Check the "trip_history" table to see if the latest (MAX) date/time for that rider occured between 00:00:00 and 11:59:59 of the current day If both conditions are true, view should now show the following: Jack Beth I want to repeat this process for the PM of the same day (time between 12:00:00 and 23:59:59) The goal is to not allow for two pickups to occur for the same passenger within the morning, and conversely in the evening. A dump of the tables is attached.
Project ID: 16995010

About the project

15 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi Dear, I can complete this job in a hour. I'm an expert in sql(MySQL, SQL Server) for 9+ years. I already thought how to implement this. thank you
$30 USD in 0 day
5.0 (2 reviews)
2.2
2.2
15 freelancers are bidding on average $35 USD for this job
User Avatar
Hello hiring member i am bhavika i have done this types job in my past so i can do it now so please give me chance to serve you thanks in advance :)
$30 USD in 0 day
5.0 (86 reviews)
6.0
6.0
User Avatar
Hello Sir, Hope you are doing great! I read your requirement about need of --------- developer and I want you to know that I have a decent experience in PHP, WordPress, Laravel, javascript, bootstrap, HTML and CSS with web crawling too. Our team consist of best startegic developers with strong background in developing online contents which include e-commerce sites, management system, biometric integrrations and other informational websites. 3 months free support is complementry, waiting for your positive response. Kind Regards, Jay
$20 USD in 3 days
5.0 (24 reviews)
4.9
4.9
User Avatar
I can do your MySQL task as per the description, please contact to discuss in detail and move further, thanks. Relevant Skills and Experience MySQL
$50 USD in 1 day
3.8 (55 reviews)
5.4
5.4
User Avatar
Dear Sir, I am an independent freelancer having experience of more than 8 years. I am highly experienced in php, html, css, javascript, jQuery, Ajax, Codeigniter, bootstrap etc. I believe the website has been developed in Codeigniter. I can fulfill your requirement with guarantee. No Advance payment required. Pay only after you are satisfied with the job. Please provide your details of the requirement. So that we can start the work without any delay. Anxiously waiting for your positive response. Thanks.
$20 USD in 1 day
4.8 (31 reviews)
4.6
4.6
User Avatar
Hey Sir, I am interested in your project.I am good with MySQL and I can help you with your project and I am ready to start the work right now, and will deliver with good result to you. please send me a message so that we can discuss more
$25 USD in 1 day
5.0 (20 reviews)
4.0
4.0
User Avatar
Hi, how are you today? I read your request and I understand the requirement. I can either modify the view or provide a query that will perform the filtering.
$40 USD in 1 day
4.9 (14 reviews)
4.0
4.0
User Avatar
Hi can we discuss and fix it
$35 USD in 3 days
4.7 (7 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
5.0 (3 reviews)
1.6
1.6
User Avatar
Hi, Hope you will be fine and doing well in your field. I read the job details and sure that I can help you in this task. I have experience in MS SQL Server. Waiting your response to work with professionals. Thanks and Regards, Mirza Fareed ud Din
$15 USD in 1 day
5.0 (2 reviews)
1.3
1.3
User Avatar
hello there, I am Raneem and it will be my pleasure to work with you. I have an outstanding experience in both frontend and backend development and a good knowledge of PHP so I can handle any website using this language. If you want I can share some links with you after getting my clients' approval. Thank you for your time and I wish we can work together. Regards, Raneem
$55 USD in 3 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Hello there. Thank you for your time to view my proposal. I have gone through your job posting and I am very much interested in the job with the requirements you have set. I believe I have the right set of skills to complete the job. Other than that, my experience in MySQL is an added advantage. If you wish to know more, feel free to visit my profile and contact me on Freelancer. I look forward to working with you. Thank you and have a nice day! Best regards, Keanyit
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
huntley, Canada
5.0
76
Payment method verified
Member since Aug 24, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.