Find Jobs
Hire Freelancers

Laravel ORM Pivot table SQL query

$10-30 USD

Closed
Posted almost 7 years ago

$10-30 USD

Paid on delivery
I require a query that retrieves data from three tables namely 1) module 2) Permission 3) module_permission The module_permission table is a pivot table that has a primary composite key (module_fk_id, permission_dk_id). Your task is to write a query to retrieve data from all three tables with the condition that if the permission doesn't exist in the module permission table then the virtual attribute status should be set to false. Otherwise the virtual attribute status should be set to true. The objective of this data retrieval is to be rendered on my angularjs U.I. The good news is that you do not need to render the data for me as I would handle that part. Your task is to handle the data retrieval. I require the use or Laravel ORM to achieve this retrieval. For instance use belongsToMany and so on. Also attached is the three table sample data and structure for your review. This task is a very simple task and requires only a minimum amount of time.
Project ID: 14658675

About the project

16 proposals
Remote project
Active 7 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
16 freelancers are bidding on average $48 USD for this job
User Avatar
I will write the query I have good knowledge of Database Relevant Skills and Experience Mysql Proposed Milestones $35 USD - query Only I have to write sql query ?
$35 USD in 1 day
5.0 (12 reviews)
5.9
5.9
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
4.8 (42 reviews)
5.0
5.0
User Avatar
Please review my profile. I have 7.5 years experience in SQL. Please let me know more details and when we will start. Sky pe jikenjd
$23 USD in 0 day
4.9 (6 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$66 USD in 1 day
5.0 (3 reviews)
2.6
2.6
User Avatar
Hi, I understood your requirements and deliver the mysql query with in 10-20 mins. with Regards, Naveen B.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will Deliver the query you are requesting withing a day. Relevant Skills and Experience I have over 3 years of writing SQL queries. Proposed Milestones $25 USD - Query delivery Additional Services Offered $50 USD - I also have experience with HTML5, JavaScript and jQuery Do you wish for data for all the fields from each table to be returned by the query?
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Sir/Ma'am, Great to see your valuable project posted here. With pleasure, we are submitting our bid on your shared scope of work. We are one of the pioneer IT Company in India with expertise in Website, Mobile Application, and Web Application Development. Awaiting your small chat for further discussion regarding your new scope of work so that we will suggest you or re-commanded you best solution for same. Thanking you in anticipation.
$32 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MALAYSIA
Petaling Jaya, Malaysia
4.9
40
Payment method verified
Member since Jun 29, 2010

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.