Query params in vuejs

I'm confused about how to implement query params and how to react to them. I want to set up a vuejs route like this: { path: '/home/video/usertype?=usertypehere', name: 'videochat', component: VideoChat }, and then when the page is loaded, grab the user type in the view and make changes to it based on the URL. I have 2 questions I need help with please: A: Is th

MattB's avatar
MattB's avatar piljac1Vue
4

How to speed up this eloquent query in Laravel 5.2?

$countLeaseCommercial = DB::table('listings') ->join('properties', function ($join) { $join->on('listings.property_id', '=', 'properties.id') ->where('properties.type', '=', 'Commercial') ->where('listings.status', '=', 'Leased') ->where('listings.user_id', '=', $this->user

joshsalway's avatar
joshsalway's avatar Tray2Code Review
2

Insert records from different tables with one query

I want to use the bennefit of factories, I'm improving the performance of my tests, today I have more the 400 tests, I need to refresh the database before each test, but also need 3 records from 3 different tables on each test (not all, but most) I want to transform this code $this->empresa = factory(Empresa::class)->create([ 'codigoempresa' => 1 ]); $pessoa = fact

spacedog4's avatar
spacedog4's avatar spacedog4Testing
4

How to refactor below query ?

I am having so difficult time in developing an optimized query for the below code: $categories = Category::with(['videos' => function($q) { return $q->active(); } , 'videos.translations'])->latest('id')->limit(config('app.latest_limit'))->where('status_id', Status::Active)->get(); in my category and videos table i have below code:

princeoo7's avatar
princeoo7's avatar princeoo7Laravel
2

Query not meeting requirement

My Query is like below $addressess = Address::where('first_name', 'LIKE', $request->letter.'%')->where('user_id', Auth::id())->get(); My Table is like below My result is like below Why I am not getting all the records of user_id 1 ? I am getting 1 record less.

afoysal's avatar
afoysal's avatar MarianoMor...Laravel
5

Fetch null values in Laravel Query

In my Laravel application if I use below query I am getting all values including null values. Address::query(); But if I use below Query I am getting values from first_name starts with certain character and other columns value is not null. Address::where('first_name', 'LIKE', $request->letter.'%')->get(); I would like to fetch values from first_name column start

afoysal's avatar
afoysal's avatar SnapeyLaravel
1

How to use (COUNT) in a database query

I am trying to replicate this postgres query: select category, COUNT(category) from auctionschedule where scheduled_for >= now() group by (category); I was attempting this, but I get an error "Call to a member function groupBy() on int" $date = new \DateTime(); $date->getTimestamp(); $number_of_auctions_of_each_category = Auctionschedu

scottsuhy's avatar
scottsuhy's avatar jlrdwEloquent
3

Query and filter tips?

Hi, everyone, currently I'm using if condition on request to check for specific query param and filter it in eloquent query builder. I think you can imagine my problem! Is there a simple way to handle all of this?

GTHell's avatar
GTHell's avatar GTHellLaravel
6

How to get department head in query

I have three tables in mysql database: hr_employees, appraisal_goals and hr_departments hr_departments have these fields: 'id', 'dept_name', 'dept_head' SELECT DISTINCT e.employee_code, concat(e.first_name,' ',e.last_name) Fullname, e.email, CASE WHEN a.line_manager_mid_year_approved = 0 THEN "DRAFT" WHEN a.line_manager_mid_year_appro

noblemfd's avatar
noblemfd's avatar aurawindsu...General
3

How to drop database name in Eloquent Model Query?

Hey all, I am cant get my eloquent queries to work with in memory sqlite unit tests, how can I drop the db name from all model queries? For Example Item::whereId(1)->toSql() returns "select * from ":memory:"."items" where "id" = ?" I want to drop the ":memory:". part because it breaks the query. DB::table('items')->whereId

xgrave's avatar
xgrave's avatar xgraveEloquent
2

Search multiple models based on one query from a model's scoped Search

I'm trying to implement a string search for one table that is daisy chained to other tables. It should be able to get any value if it exists from any of those tables. I have a customer, invoice, order models/tables. Customer has a fk inside of Invoice and Invoice has a fk inside of Order. So they all have a one-to-many relationship going down the list. For example I search for

PersonalHomePage's avatar
PersonalHomePage's avatar PersonalHo...Laravel
0

How to write MYSQL Left Join Query as Laravel Query

I have this MYSQL Query that is working fine SELECT e.id, e.employee_code, concat(e.first_name,' ',e.last_name) Fullname, e.email, e.department_id, CASE WHEN a.line_manager_mid_year_approved = 0 THEN "DRAFT" WHEN a.line_manager_mid_year_approved = 1 THEN "AWAITING APPROVAL" WHEN a.line_manager_mid_year_approved = 2 THEN "NOT APPROVED"

noblemfd's avatar
noblemfd's avatar jlrdwLaravel
3

How to use count of relations where building a query?

I have this query [for datatable] $records = Customer::select('id', 'name', 'surname', 'email', 'phone') ->where(function($query) use ($searchValue) { $query->where('name', 'like', '%' .$searchValue . '%') ->orWhere('surname', 'like', '%' .$searchValue . '%') ->orWhere('email', 'like', '%' .$searchV

realtebo's avatar
realtebo's avatar realteboEloquent
2

How to Apply left join in Laravel Query

In my Laravel-5.8, I have these models: hr_employees hr_departments hr_results class HrEmployee extends Model { protected $table = 'hr_employees'; protected $primaryKey = 'id'; protected $fillable = [ 'id', 'hr_status', 'company_id', 'email', 'type_code', 'first_name', '

noblemfd's avatar
noblemfd's avatar vincent150...Laravel
1

How to query users company id on event?

I have a company owner role for users. I want to display the companies users events/appointments to the company owner role. Events can have a user_id, and then another type of event has many users for the event. How can I make this concept in eloquent: if (Auth::user()->hasRole('company')) { $company = DB::select('select * from companies where user_id = ?', [Auth

Adgower's avatar
Adgower's avatar AdgowerEloquent
2

Randomly happening Query Exception

Hello everyone, Recently, I have faced a weird problem. I am building a SPA application. Sometimes, query exception happens for specific endpoint just by reloading. In the handler.php else if($exception instanceof QueryException){ $exception = FlattenException::create($exception); return response()->prettyApi([

nnnayeem's avatar
nnnayeem's avatar nnnayeemLaravel
0

How to query Search with related model.

Hello everyone. I have a search box where the user will enter the business name and a dropdown where the user will select the state/province as shown in the dropdown. The business model has a relationship with the Province model. How I can do a search based on province only. if user leaves a search bar empty and only select province I want to show all the businesses based on st

maaz's avatar
maaz's avatar MichalOrav...Laravel
10

[Sanity Check] Eloquent Query on each login

Hello guys, Will you please do a sanity check for me on the below approach. In essence, I have a 3 step form, I want to direct the user back to the relevant step if they abandoned it and logged in again later. Is there a way to see what this SQL query looks like in the backend, I like the simplicity, but I suspect this loads the entire business object /* * On each logi

ErikThiart's avatar
ErikThiart's avatar ErikThiartEloquent
5

hide buttons based on query string

I'm building a small forum app with Laravel and Vue and currently i'm adding filter buttons to fetch threads based on the filter button. For example, in a Vue component, i have the following button, which essentially makes a get request to the back-end and fetches the threads created by the authenticated user <a href="/threads?myThreads=1"> My Threads </a&g

orest's avatar
orest's avatar SnapeyCode Review
5

MySQL query to eloquent

I would like to display a players current score as well as how many points they have gained within a selected time frame. I have 2 tables skills table +----+---------+---------------------+ | id | name | created_at | +----+---------+---------------------+ | 1 | skill 1 | 2020-06-05 00:00:00 | | 2 | skill 2 | 2020-06-05 00:00:00 | | 3 | skill 3 | 2020-06-05 00:00:

Dawson's avatar
Dawson's avatar DawsonEloquent
0

Make Filter Search for Query Builder

I have a code like this. *** DB::raw("(SELECT TAPET_NAME FROM MA_TAPE_TYPE WHERE TAPET_CODE = a.MATERIAL_TYPE) as media_type"), DB::raw("(SELECT TAPEF_NAME FROM MA_TAPE_FORMAT WHERE TAPEF_CODE = a.MATERIAL_FORMAT) as media_format"), DB::raw("CASE WHEN a.iden_flag = 'P' THEN b.epi_title WHEN a.iden_flag = 'C' THEN b.prod_version_name W

Lia97's avatar
Lia97's avatar Lia97Laravel
0

How to query popular Posts/Category in laravel ?

How to Query popular categories using the eloquent model. I have a category model and showing popular categories on view. Do i need to created most_viewed or something like that column inside my model ? note: I want to show only 4 categories. Ask for code if you need Thankyou :)

maaz's avatar
maaz's avatar maazLaravel
7

Query result from two tables into one collection

Hello, I try to have the result of two queries in one collection. $creations = Drawing::where('published', 1)->orderBy('creation_date', 'desc')->limit(4)->get(); return view('accueil', compact('creations')); $creations = Animations::where('published', 1)->orderBy('creation_date', 'desc')->limit(4)->get(); return view('accueil', compact('creations')); Of cour

vincent15000's avatar
vincent15000's avatar vincent150...Eloquent
3

Query Builder: multiple joins based on array

Hi everyone, according to the official documentation I have to write something like this when I want to join multiple tables: $items = DB::table ( $table ) -> leftJoin ($jointable1', $key1, '=', $joinkey1) -> leftJoin ($jointable2', $key2, '=', $joinkey2) -> leftJoin ($jointable3', $key3, '=', $joinkey3) -> leftJoin ($jointable4', $key4, '=', $joinkey4) Is i

jank's avatar
jank's avatar bugsyshaLaravel
6

Where Query - using calculated date value from record in the DB

I need to run a query where the date matches a calculated value. The scenario is as below $now = CarbonImmutable::now(); $tests = Test::active()->whereDate('start_date', '=', $now->subDays('DB_COLUMN_VAL')); How would I go about this? Thanks in advance

jjmu15's avatar
jjmu15's avatar jjmu15Laravel
24

Getting SQL query in a variable

$products = Vacancy::statusId($request->query('status')) ->sellerId($request->query('seller')) ->categoryId($request->query('category')) ->locationId($selectedLocationId) ->get(); I can see in the debugbar on my local pc that a query is executed e.g. SELECT * FROM products WHERE status_id=2 AND seller

appyapp's avatar
appyapp's avatar priyavarsh...Eloquent
8

High line Query Search Result Text

Hello, When i input any keyword and search , I just want to high line or blold or something, for those match query result text. protected function keyword() { $query = request()->input('keyword'); return $this->builder->where('title', 'LIKE', "%$query%"); } Thanks

Naysoewin's avatar
Naysoewin's avatar MichalOrav...Laravel
3

Oracle Update Query Not Responding

We have an Oracle based legacy Operations Software that we are interfacing with to set some custom local information. I have this method public function update_pricing($pn) { try { $pn = preg_replace('/[^\w\d]/', '', $pn); $part = DB::connection('oracle')->select('SELECT PNM.PNM_AUTO_KEY, PRN.CATEGORY_CODE FROM PARTS_MAST

jgravois's avatar
jgravois's avatar Tray2Laravel
1

Laravel select onchange update request query parameter

I have a list of users which I am using filters to filter certain parameters of the user which appends the URL using request(). My current filters are all anchors, so I am using the HREF attribute to update the url like so: Filter By Full Time < a href="{{route('users.index', array_merge(request()->query(), ['work_type' => 'full_time'])) }}" class="list

brianrevie's avatar
brianrevie's avatar brianrevieLaravel
2

Running a query multiple times inside foreach loop and storing the results in an array.

Hello Everyone, I have encountered a strange problem. I am trying to run a query multiple times with foreach loop and storing the results in an array to use later for some calculations. Below is the detail: This works $test = DB::table('appcal') ->select('monthyear','appdate') ->whereDate('appdate','>=', '2018-04-01')

ramniksingh's avatar
ramniksingh's avatar jlrdwLaravel
5

Laravel Query not returning correct information

Hi all, hopefully somebody can tell me what I've done wrong. Just an FYI before I start, I know this is messy and there are better ways to do it, I'm just not at the "better way" level just get I'm still learning! I have a parts table with different parts in it. In one of my questions I am telling the query to show the parts based of a matching ID (this part works fin

RobHowdle's avatar
RobHowdle's avatar RobHowdleLaravel
4

Laravel Query Duplicates record twice

I am using Laravel-5.8 for this Query: $published_goalss = DB::table('hr_employees AS e') ->join('hr_employees AS em','em.employee_code','=','e.line_manager_id') ->join('hr_departments AS d','e.department_id','=','d.id') ->join('hr_employees AS eh','eh.employee_code','=','d.dept_head') ->join('hr_em

noblemfd's avatar
noblemfd's avatar bobbybouwm...Laravel
1

How to Convert MYSQL Qury with self join to Laravel Eloquent Query

I have this MYSQL Query which has self joins: SELECT e.id as id, e.employee_code as staff_id, e.hr_status, CONCAT(e.first_name, ' ', e.last_name) AS 'direct_report', e.user_id, e.company_id, e.email as official_email, CASE WHEN e.gender_code = 0 THEN "Female" ELSE "Male" END AS gender, em.employee_code as manager

noblemfd's avatar
noblemfd's avatar obetLaravel
5

Multiple routes in web.php or query string?

Hi! I have 15-20 pdf:s that the user can choose to print. What would be the best way to show the pdf the user chose? At the moment I use a query string with the name of the function inside the controller and route to pdfController@index. Is this the best way? (I have the drawback that the controller is really long and with lots of functions) Or would it be better to have multip

TobiasS's avatar
TobiasS's avatar bobbybouwm...Laravel
3

Laravel query builder

Hi, currently I have a query that queried out the results of top 10 screen visited, and the results is such as below screens | visits Home | 100 Dashboard | 25 Products | 30 ... Is there any way that I can get a new row that is for Others which is the count of all visits for the page that is not in the top 10? screens | visits Home

rezuankassim's avatar
rezuankassim's avatar bobbybouwm...Laravel
1

How to convert MYSQL Query to Laravel Eloquent Query

I have this query in MYSQL: select hr_employees.id, hr_employees.company_id, hr_employees.department_id, hr_employees.employee_code, hr_employees.first_name, hr_employees.last_name, hr_employees.hr_status, hr_departments.dept_code, hr_departments.dept_name, approval_awaiting.appraisal_identity_id, approval_awaiting.is_approved FROM hr_employees LEFT JOIN approval_awaiting ON

noblemfd's avatar
noblemfd's avatar jlrdwLaravel
1

Adding whereIn to orWhere functions in database query

I am struggling to add a whereIn to a more complex query: $events = Toolplan::query() ->select('id', 'eventId', 'resourceId', 'title', 'start', 'end') ->where(function ($query) use ($start, $end) { $query->whereDate('start', '>=', $start)->whereDate('end', '<=', $end); }) ->orWhere(function ($query) use ($st

Loomix's avatar
Loomix's avatar guybrush_t...Laravel
5

filter records via query where date is greater than some date

Hi, I have been trying this and searching for solution: $qry = DB::table('appcal') ->select('monthyear','appdate') ->whereDate('appdate','>=', '2018-04-01') ->get(); It does not work & gives me no records at all ( even the query shows nothing without even giving any error). But when I use the below i

ramniksingh's avatar
ramniksingh's avatar ramniksing...Eloquent
32

Using Global Variable in Eloquent Model Query

Hi. I am trying to use a variable where is outside of model query inside it as following codes but it doesn't work. Normally I can use it inside function by making global.. public function setPriority ($id) { $affectingJob = Job::find($id); $machine_id = 1; $affectedJobQueue = Job::where([['state_id', 1],['user_id', Auth::user()->parent_user_id]])-&g

mecjos's avatar
mecjos's avatar mecjosLaravel
4

Getting the URL Query string and using in an API call

Greetings! I'm developing a simple application to list products with Laravel and Vue. When I access /products my Vue component list all avaliable products. <template> <div class="products-list"> <ul> <li v-for="(product, index) in products">{{ product.name }}</li> </ul> </div> <

pedroroccon's avatar
pedroroccon's avatar pedrorocco...Vue
2

3 Model Query Assistance

I need help getting this query built. For some reason, i am having difficulty and could use your assistance, please. 3 models = Product, Doc, Doctype I need something along this: select * products where docs.config_catalog_filter == current with doctype->slug = mtype and return the document MY DB products: id name description short slug type published docs: id

madsynn's avatar
madsynn's avatar madsynnLaravel
0

with() query method return null

I have a post that post belongs to a user. now I want to get a post with the associate user. but don't want to get all the user column. so in the query->select('*') it will get me all the field. but if I pass any column name in the query->select('user_column_name') of the user it always return null; $posts = Post::find(1); $posts()->with(['user' => function ($query)

kundefine's avatar
kundefine's avatar kundefineLaravel
2

ORA-01789: query block has incorrect number of result columns ?

I have a coding like this. There are two queries and I want to use Union. But I get an error "ORA-01789: query block has incorrect number of result columns". Is there any wrong with my syntax or how? public function index() { $medias = DB::connection('oracle') ->table('ARCHIVE_LOG_SHEET_HDR AS a') ->

Lia97's avatar
Lia97's avatar Tray2Laravel
8

How this query works for Eloquent

I have a query like this. How should I convert it into a eloquent or query builder SELECT x.MATERIAL_ID, (SELECT TAPET_NAME FROM MA_TAPE_TYPE WHERE TAPET_CODE = x.MATERIAL_TYPE) as media_type, (SELECT TAPEF_NAME FROM MA_TAPE_FORMAT WHERE TAPEF_CODE = x.MATERIAL_FORMAT) as media_format, STOCK_MATERIAL_EPI.HOUSE_NO, x.TXN_DATE, STOCK_MATERIAL_EPI.PROGRAM_NAME, CASE WHEN x.iden_fl

Lia97's avatar
Lia97's avatar a4ashrafEloquent
1

How to convert this Query into Laravel Eloquent or Query Builder way?

Can you help me. This is my query. I was confused, had to change. Very confusing for me. Subquery is so much as well as many conditions. Makes me confused how to convert to eloquent SELECT x.MATERIAL_ID, (SELECT TAPET_NAME FROM MA_TAPE_TYPE WHERE TAPET_CODE = x.MATERIAL_TYPE) as media_type, (SELECT TAPEF_NAME FROM MA_TAPE_FORMAT WHERE TAPEF_CODE = x.MATERIAL_FORMAT) as media_fo

Lia97's avatar
Lia97's avatar jlrdwLaravel
2

How to convert this Raw query into Laravel Eloquent way?

I'm confused, how to change this query to Eloquent. Can you help me. This is my raw query.

Lia97's avatar
Lia97's avatar MichalOrav...Eloquent
5

Query Enhancement

Auction::where('id', $auctionId) ->with(['round','bids','order.entity','order.vehicle.vehicle_make','order.vehicle.vehicle_model','auctionActions']) ->withCount('bids') ->first(); This is my query I would like it to be one single query to the database instead of sending like 9 queries to the database how I can reach that ? thanks in advance

ahmedali32's avatar
ahmedali32's avatar MichalOrav...Eloquent
3

conver to database query builder

any help, change a given eloquent query to database query $exchangeRate = Currency::where('currencyType', 'USD')->firstOrFail()->exchangeRate; // change $organizations to database query $organizations = Organization::withCount(['rooms','confrences'])->with(['typeOfOrganization','user']) ->where('approved', 1)->when(request('type_of_organization'), function($qu

Aronaman's avatar
Aronaman's avatar MichalOrav...Laravel
7

How to write complex inner join on Query builder?

I am trying to write this on query builder but I have no idea, someone know if this is possible ? SELECT * FROM attendances a INNER JOIN remunerations rr ON rr.id = ( SELECT id FROM temporaryTable LIMIT 1) The whole problematic is a

Lonw's avatar
Lonw's avatar LonwEloquent
4

How to query result form given time range with MYSQL

I want to filter teams date where given time matches with team match time we are using IST timezone on frontend and UTC for MYSQL side create table teams ( team_name varchar(255), match_start_time time, match_end_time time ); insert into teams values ("a", "18:30", "18:29"), ("b", "18:30", "18:29"), (&q

ni31593's avatar
ni31593's avatar frankieleeGeneral
4