Query to count all participants of each registration type is not working

I want to have a table in the view that shows all the registration types associated with a conference, the price of each one and the number of registrations sold of each registration type. For example if the conference with id "1" has two registration types with this columns: rtype1 (name), 0.00$ (price), 20 (capacity) rtype2 (name), 5.00$ (price), 10 (capacity) An

adamjhn's avatar
adamjhn's avatar adamjhnEloquent
4

How to achieve this complex query? (get the email of all users that did a registration in a specific conference and this registration has 1 or more participants associated with a specific registration type)

I have this query below to get the email of all users that have a registration in a specific conference. $users = User::whereHas('registrations', function ($query) use($conferenceID) { $query->where('conference_id', '=', $$conferenceID); })->get(); And dd($users) shows array:2 [▼ 0 => "....mail.com" 1 => "....mail.com"]. So its working fine.

adamjhn's avatar
adamjhn's avatar CronixEloquent
11

query to to get the email of all users that did a registration in a specific conference is not working

I want to do a query using eloquent that gets the email of all users that did a registration in a specific conference. The email is stored in the users table. The registrations table has the column "user_that_did_the_registration", this column has the id of the user that did the registration. So I have this code below but "$usersEmail[] = $user->email;" s

adamjhn's avatar
adamjhn's avatar _Artak_Laravel
3

No query results for model [App\SubmitApplication] unapproved

I am following the forum series from Jeffrey and decided to change things up a little and make my own project out of it. I have changed plenty things, such as routes and I am using tags instead of channels. requisitions.blade.php <form class="btn-group" action="{{ route('requisitions.unapproved', ['id' => $submitapplication->id]) }}" method="po

mozew's avatar
mozew's avatar SnapeyLaravel
6

Use eloquent relationships from query result

Hi, I have set up all the relationships for my tables in each of the Models. I can get the required information in my views if I use: // In ProjectController $projects = Project::all(); Then in my view, I can call the following and it all works as expected: // In projects View @foreach($projects as $project) <tr> <td&

michael@cronin.software's avatar
michael@cronin.software's avatar SnapeyEloquent
1

toSql() returning "incorrect" query

Hello I have the following code: public function activeCoupons() { return $this->coupons()->active(); } public function coupons() { return $this->hasManyThrough(Coupon::class, Saving::class); } If I dd($this->coupons()->active()->toSql()); the query I get starts like this: select * from `coupons` inner join `savings` ...

symos's avatar
symos's avatar symosEloquent
2

How to execute multiple query in laravel ? (create myslq event, insert and update at one query)

Anybody can help me? I try to create myslq event, insert and update at one query, I using DB::raw, but I dont know how to execute it? this is my code.. how to solve that? thanks.. My code: https://gist.github.com/wahyuadepratama/32c48635e99785b4a0fe46801a1b564e

wahyuadepratama's avatar
wahyuadepratama's avatar wahyuadepr...Laravel
4

@foreach loops more times than the query answers

Hi, just getting started and the first view is making me have second thoughts about Laravel... I have a query which returns three rows (I echoed the sql and run it my self) but when I do a @foreach on the result it loops far too many times (22!) And I can't use the loop variable for showing the result, when I try I get an "Undefined property" error no matter what I wr

kejpa's avatar
kejpa's avatar CronixGeneral
10

Howw to show query results in a pdf file? (show each list item in a page of the pdf)

I have this query: public function getRegistrationInfo($regID){ $registration = Registration::with('conference',Conference.registrationTypes','Conference.registrationTypes.participants') ->where('id',$regID)->first(); return view('pdf.registration',compact('registration')); } And in the view "pdf.registration" I have this to

adamjhn's avatar
adamjhn's avatar bobbybouwm...Laravel
7

How to achieve this context? (single query, multiple queries?)

I want to have a query using laravel that allows to get the details about a registration. I have this route: Route::get('/conference/{id}/{slug?}/registration/{regID}/info', [ 'uses' => 'RegistrationController@getRegistrationInfo', 'as' =>'conferences.registrationInfo' ]); When the user accesses this route I want to show the details of that specific registrati

adamjhn's avatar
adamjhn's avatar CronixEloquent
3

hi all,please convert the give raw query to laravel EOLQUENT

plase convert the given rawsql query to laravel eloquent $students=DB::select('select s.id,count(se.id) as month,(select count(id) from student_enrollment_units_new where student_id=s.id and date between CURDATE() - INTERVAL 7 DAY AND CURDATE() and status="enrolled") as week from students as s left outer join student_enrollment_units_new as se on (s.id=se.student_id)

Venkatakrishnai's avatar
Venkatakrishnai's avatar mballaagEloquent
1

Change query prameters based on user input

The query string I am dealing with is /table?id=1&year=2018&month=6. I have a search component with three dropdown fields; id, year and month along with submit button. On the same page, I have a table below the search component. For instance, if use selects; id = 2, year= 2015 and month=5 and hit submit, I want the URL to change to /table?id=2&year=2015&month=5.

dleroari's avatar
dleroari's avatar dleroariLaravel
2

Converting MySQL Query to Eloquent

SELECT * FROM queue_log WHERE date_time IN ( SELECT MAX(date_time) FROM queue_log GROUP BY callid ) AND event = 'CALLBACK' How would I convert the above MySQL raw query to a nice Eloquent query?

nick.a's avatar
nick.a's avatar NicholasEloquent
12

How to order Eloquent query by `belongsToMany` relationship column?

I have a model Event with the following relationship: public function labels() { return $this->belongsToMany(EventLabel::class, 'event_event_labels'); } I would like to retrieve all events ordered by a property priority on the EventLabel model. The thing is that some events do not have corresponding labels. Therefore, I want these events to be placed at the end

FerdinandFrank's avatar
FerdinandFrank's avatar ThisIsEpicEloquent
3

How to insert result from a query into another table ?

Hi Guys, I have the following query DB::table('product_sales') ->join('product_views', 'product_sales.session', '=','product_views.session') ->select('product_views.reference_id AS prod_view_id', 'product_sales.reference_id AS prod_bought_id', 'product_sales.session') ->take($num) ->get(); returning a json collection like the one bellow [ { "prod_view_id":

kuruyiva's avatar
kuruyiva's avatar kuruyivaEloquent
2

sql query not working with DB::select

The following query is working fine in phpmyadmin (sql) select id ,fname , last_order_date , created_at, 'masterdealers' as Source, null as type, (select id as uuid from uuids WHERE userable_type LIKE '____m%' AND userable_id = masterdealers.id) as uuid FROM masterdealers UNION ALL select id ,fname,last_order_date , created_at, 'dealers' as Source , null as type,(select id as u

hassanraza504's avatar
hassanraza504's avatar bobbybouwm...Laravel
6

convert simple mysql query into eloquent query with relation ship

SELECT * FROM `order_status_details` WHERE id IN(select max(id) from order_status_details group by `order_detail_id`) and order_id=210 i Want to add above query into this OrderStatusDetail::with(['orderStatus'=>function($query){ $query->select('id','name'); },'orders','orderDetails','orders.pickup'])->where('order_id',210)->whereIn(&qu

yusuf128's avatar
yusuf128's avatar yusuf128Laravel
2

Prevent users from accessing high-sensitive data by simply changing query string

I am dealing with this app that provides the teacher the ability to manage students within a class project. I was thinking making this public, so that teachers all around the world can use it. One of my main concerns is related to separation of these teachers. For instance, if I create a sign-in/sign-up page, how would I separate the teachers along with their students in terms

dleroari's avatar
dleroari's avatar RobstarTips
3

Laravel Query Builder error column not found with joins and parameter grouping

Have a set of queries I would like to convert from raw to query builder but having issues when using parameter grouping: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.trail_ends_at' in 'where clause' (SQL: select campaigns.* from users inner join campaigns on users.id = campaigns.user_id inner join subscriptions on users.id = subscriptions.user_id where (users.t

nhaley's avatar
nhaley's avatar sinov8Eloquent
4

5 records in query, 1st should be Featured article, reset should be looped through in blade

in eloquent i'm running this query, $news = Post::where('status','=',1) ->orderBy('id', 'Desc') ->limit(5) ->get(); the query is getting last 5 records from news table? the issue i'm facing is in blade? the first record of the query should be featured news where in blade i'm using bootstrap to get a big image covering half of the row (col-md-6) and the res

nhayder's avatar
nhayder's avatar CronixEloquent
4

Why 'id' is necessary in this query?

I have this query below to get the conference associated with the Registration. Do you know why 'id' is necessary? Is because is the primary key of the conferences table and the foreign key in the registrations table? Even that in the registrations table this foreign key has the name "conference_id" and not just "id". $registration = Registration::with([

adamjhn's avatar
adamjhn's avatar adamjhnLaravel
3

Eloquent Query

Hi all, I have a difficult situation to convert classical query to Eloquent query. If someone could look a little bit much appreciate. I have 3 models Post, GroupTag and TagCode models with GroupTag->hasMany(TagCode) posts table | id | tag|views| | ----| ---- |-------| |1|ABX|10| |2|BCY|10| |3|ABCDE|10| |4|BCE|10| group_tags Table | id | name| | ----| ---- | |1|group_A|

floflo's avatar
floflo's avatar flofloEloquent
0

Need help with query

I have a model Project, The model has the relationship belongsTo User. (The creator of the project) But also has another relationship hasMany User. (The creator can invite other users to the project) So I want to make a query to return all projects that the auth user create and also the ones that the auth has been invited. public function scopeSearch($query, $search) {

socieboy's avatar
socieboy's avatar arukompEloquent
1

How to use Laravel Collection groupBy along with Query Pagination? Ask Question

I love using Laravel's groupBy function https://laravel.com/docs/5.6/collections#method-groupby However, I cannot use it with paginate(x) function since it return a limited number of results. Groupby of SQL Query and Laravel Collections's GroupBy is totally different. If I use groupby in my query it doesn't give me what I want. For instance I just want to type and I got all I w

SNaRe's avatar
SNaRe's avatar SNaReLaravel
0

Need a little help with a query involving withCount

Doing a search query right now and I am trying to get the count of the hires of the profile that owns the project. $query = Project::with('profile'); $query->with(['profile' => function ($q) { $q->withCount('hires', function ($qr) { $qr->where('hires_count', '=', '0');

Reprise's avatar
Reprise's avatar staudenmei...Eloquent
3

One controller for different roles and query

Hello to all, I am new in laravel and I still have many doubts. I present you my problem. I'm building an app for the management of condominiums, the peculiarity and that each user will have different queries and if necessary different permissions (policy). I'll give you a small example for what I mean by query + different views for each user: the 'condominium' can read the ta

clusteCode's avatar
clusteCode's avatar clusteCodeLaravel
5

issue with query building - Property [..] does not exist on this collection instance.

Hi all, I am trying to build an app forv university students. My idea is to retrieve data from the database, where for each student should be displayed courses depending on which semester the student is. In other words if student A is in second semester and let's say the course Databases is being held only in second semester, for student A I should have on the page only Databas

idodeva's avatar
idodeva's avatar idodevaEloquent
0

Laravel global query scope's withoutGlobalScope() not returning desired records

I have a global query scope called ArchiveScope that mimics the similar functionality of Soft Deletion. The apply method of that scope looks like this: public function apply(Builder $builder, Model $model) { $builder->where('archived_at', '=', NULL); } So when I use MyModel::all(), it returns all the rows that do not have a timestamp (i.e. NULL). But whe

tanmay_das's avatar
tanmay_das's avatar bobbybouwm...Laravel
5

Getting all table rows as a query builder?

I know about ModelName::all(), but that returns a collection. I need to have all of the results returned as a query builder, but can't for the life of me find out how, other than to write something like: ModelName::where('id', '>=' 0); Is this the appropriate way to go about it? EDIT for clarity: Essentially I'm not sure I knew what I was asking. The end result was a needed

FrenchFryNinja's avatar
FrenchFryNinja's avatar tykusEloquent
3

Query join error

I have this query $duration = 1; $rooms = Room::Available($start,$end) ->where('pax', '=', $data['pax']) ->where('location','=',$data['location']) // Search in base alla sede ->join('prices',function ($join){ $join->on('rooms.id','=','prices.room_id') ->where('prices.duration', '=', $duration); })-&

palla451's avatar
palla451's avatar palla451Laravel
2

I am trying to pass multiple query for execution for which i don't want data from 1st query to execute if the last query is having issues.How to achieve this.

$user = Gateway::user()->storeDoctorUser(\Input::all(), 'doctor'); $address = Gateway::address()->storeDoctorAddress(\Input::all(), $user->id); $doctors = Gateway::doctor()->storeDoctorData(\Input::all(), $user->id,$address->id); As stated above how to solve this issue.If somehow the doctor query is failing then also user and address are working ,which should

gaan10's avatar
gaan10's avatar gaan10Laravel
3

Two dates on 2 fields query

Hello, I need to write query for following situation: I have two columns in reservation table, 'checkin' and 'checkout' (dates both). When new reservation is being made, in request that I receive there is two parameters $from and $to (also dates). I need to check if there is existing reservation between this $from and $to dates in my database(between checkin and checkout). simp

armingdev's avatar
armingdev's avatar LinuXEloquent
3

Convert MySQL query in Eloquent query.

Hi all, I'm trying to convert a MySQL query to an Eloquent query but I can't find the right answer. select number,DATE(start),sum(duration),count(*),SUM(if(duration = 0, 1, 0)) AS comments from histories group by number,DATE(start); Really appreciate any ideas.

floflo's avatar
floflo's avatar CronixEloquent
2

How I can query data from four tables?

I have four tables. And I need to run almost identical queries. Like this: $model1 = Model1::selectRaw('table1.*, MAX(max_rating) as maxAverageRating') ->orderBy('max_rating', 'desc') ->groupBy('id') ->first(); $model2 = Model2::selectRaw('table2.*, MAX(max_rating) as maxAverageRating') ->orderBy('max_rating', 'desc') ->groupBy('id') ->

nchornii's avatar
nchornii's avatar jlrdwEloquent
3

Search on result of other query | return collection

I made a searchbar in which the customer wants to search their relations and contacts (the contacts are linked to that company by CONTACTID in both tables) so if someone provides input, I query via async. However, I can't wrap my head around this. As soon as someone provides input, I need to search relations table and contacts table - simultaniously. I want to just provide the

Galavant's avatar
Galavant's avatar GalavantEloquent
1

Simple Eloquent Query

Hi, The below query works, but it's two queries instead of being one. Could anyone help me tidy this query up please? $page = Page::select('id')->where('uri', Request::segment(1))->first(); $section = PageSection::select('content')->where('name', $name)->where('page_id', $page->id)->first(); I have created a relationship in my Page model which hasMany PageSe

MoFish's avatar
MoFish's avatar MoFishLaravel
2

Guidance for implementing search query

Apologies in advance as I'm probably missing some basic knowledge due to my patchwork Laravel education... So I'm creating a training website and am trying to implement a way for admins to search for grade results by user first and last names. I have a standard 'users' table and a 'grades' table. Right now I can display all grades pretty easily: user model: public function grad

bertmi01's avatar
bertmi01's avatar bertmi01Laravel
3

Raw query

I have a polymorphic relation. Class Reply public function replyable() { return $this->morphTo(); } Which belongs to User and Trainer. When I fetch replies I want an authenticated user's reply placed first. So, if an auth user is a trainer, trainer's reply should be first and an auth user is a normal user, user's reply should be first. This is what I got for now. publi

kenny11's avatar
kenny11's avatar kenny11Eloquent
0

Eloquent standalone, unable to query with count and groupBy

Hello, I'm new with eloquent, working as it, standalone :) it works pretty good with simple query, but I'm unable to make just a count(*) with groupBy... Here is the code: class Btc extends Illuminate\Database\Eloquent\Model {     static function getNb(int $mid, array $btc = [], array $etat = []) {         $req = Btc::select('btc_mid', 'btc_type', Btc::raw('COUNT(*) as btc_nb'

pifou's avatar
pifou's avatar DirkZzEloquent
3

How can i submit form keeping existing query string intact in url in laravel

Hi, I have a URL something like this : foo?country=usa&state=ny and in foo I have a form which gives me values of firstname & lastname and few more with a submit button. But when i click submit it gives foo?firstname=john&lastname=doe And the other query i.e country and state get disappear or in other word i am losing them. Can anyone please tell me how can i peserv

ajitdas's avatar
ajitdas's avatar SnapeyLaravel
7

Breaking down Eloquent query

Hello there, The following query works great. $query = \DB::table('users')->join('posts', 'users.id','=','posts.user_id')->select('post_id','title')->get(); But I want to add a condition like; $query = \DB::table('users')->join('posts', 'users.id','=','posts.user_id'); if($filter){ $query->where('title','like','%title%'); } $query->get(); I know there is muc

cevizmx's avatar
cevizmx's avatar SnapeyEloquent
4

Error when trying to join two tables in Laravel 5.2, for a search query

What I'm trying to do is, put together a search query by joining two tables together. I have a very simple fictional Real Estate site, where a user can search for listings using multiple options, such as searching by city. The way I have it set up is I have a City model and table, which contains a list of cities and a Listing model, controller, and table. The city table is set

Jinjoe's avatar
Jinjoe's avatar JinjoeLaravel
2

Query like whereIn() in array column

Hello! Can't find in the documentation a way to search for a specific value in a table calumn. Take for example a Real Estate website: A house has a table 'features' that is casted as an array. So the features are stored like this: ["pool", "garden", "air_conditioner"]. If i want to query all the properties that has pool feature, i would like to ma

bufferoverflow's avatar
bufferoverflow's avatar xxRockOnxxLaravel
6

Laravel join tables query

Hi How can we build query in laravel for the below SELECT routes.id, src.title, dest.title, groups.title FROM routes INNER JOIN locations as src ON (src.id = routes.src) INNER JOIN locations as dest ON (dest.id = routes.dest) INNER JOIN groups ON (groups.id = routes.groups) order by routes.id tables depots(id, title) groups(id, title) routes(id, origin, destination, group_id)

rajaduraioec's avatar
rajaduraioec's avatar amirhazzGeneral
1

Update dateTime column with Query Builder

if it's possible to update DateTime-columns with Query Builder. here is my query $data = Attendance::where('status', '0') ->update(array('status' => '1')) ->update(array('datetime' => format("Y-m-d H:i:s",$datetime)));

Sabbir345's avatar
Sabbir345's avatar SubrangLaravel
27

Looking for ideas on how to write a multisearch query in a more effcient manner using Laravel 5.2

So I have a fiction Real estate website, with a multi-option search function. A user can search using a variety of filters such as City, Min price, Max Price etc. It works just fine, but I can't help but think that there could be a more efficient way, to write this. The way I have it setup is, I use if/else statements to determine what options have been chosen. For example, if

Jinjoe's avatar
Jinjoe's avatar JinjoeLaravel
0

Laravel query builder join where

Hi, I've got this query: $query = QueryBuilder::for(Advertisement::class) ->with('locations'); The locations method on Advertisement looks like this: public function locations() { return $this->belongsToMany(Location::class, 'advertisement_locations', 'advertisement_id', 'location_id'); } So a advertisements belongsToMany locations in between is a pivot

Lars-Janssen's avatar
Lars-Janssen's avatar VilfagoLaravel
1

Check a single item within a query scope

Hi there, I am using a scopeRegion function to filter on items belonging to the current localization region like de, gb, us, .... The scope looks like this: public function scopeRegion($query, $locale = null) { $locale = ($locale) ?? LaravelLocalization::getCurrentLocale(); $q = clone $query; $localeRegion = $q->where('regions->' . $locale, t

dillscher's avatar
dillscher's avatar addorangeEloquent
2

Need to use count in laravel query builder

Hello. I wanna to biuld db query, https://paste.laravel.io/15eebfc7-8e0b-4c49-a363-55f40c736729 and I need also to show count('some_number') . Retrying here: $db->query() ->from('mytable') ->where([['year', '>', 12]]) ->get(['age', 'gender', 'some_number']); And I need to group by count(some_number), it should looks something like that $db->query() ->from(

BigSpender's avatar
BigSpender's avatar jcphpdevGeneral
2

Get Accurate Query Execution Time

Hi, Good day, I am trying to fetch all of the queries being ran on every request with they're execution time. It works on the AppServiceProvider.php using DB::listen. Apparently, the variable $time doesn't seem to match the execution time it provides when I run the query on my database, the one being provided by the DB::listen seems to be longer than what I have on my database

taishi's avatar
taishi's avatar 36864Eloquent
5