I’ve a problem when sorts data from largest to smallest from table relations that do not necessarily have a relationship with PHP Laravel Eloquent. Table: items |—————————| | id | name | price | |—————————| | 1 | Samsung | 70.000 | | 2 | iPhone | 90.000 | | 3 | Nokia | 50.000 ..
Category : orm
I am trying to get the first transaction that was recorded close to a particular date using the Laravel 8 DB Facade. I have tried to use it in the following manner $lastest_transaction = DB::table($targetTable) ->where(‘date’, ‘<=’, date(‘F’)) ->where(‘id’, ‘=’, $client->id) ->where(‘branch’, ‘=’, session(‘branch’)) ->get(); but it’s not giving me the correct transaction. Sourc..
I have done much research about this but I can’t fetch the pivot table as I want. I want to just fetch the measurement value from the pivot table-like structure you can see. Please check my all details first then you know what I want to show. Model MeasurementPart.php public function customers(){ return $this->belongsToMany(Customer::class, ‘customer_measurements’, ..
I’ve been trying to get a variation of the Laravel Eloquent ‘has many through’ relation working. I have 3 models: Invoice, InvoiceLine and Order; I would like to retrieve a distinct set of all Orders of a given Invoice through its InvoiceLines. Invoice has 1 or more InvoiceLines; InvoiceLine has exactly 1 Invoice; InvoiceLine has ..
I have two migration tables and two models 1)User. 2)Subscription. in subscriptions Model i write one method called user() which has hasMany relationship and in Users model it will contain subscriptions() method which have belongs() relationship. in user table id acts as an primary key and in subscription table sub_id acts as a foriegn key,for ..
I would like to preface this by saying that I’m new to Laravel and Eloquent ORM. I’m currently using Laravel 5.8. I have a Model ReturnRequestthat has a ReturnRequestCustomer, a ReturnRequestShippingAddress, and a ReturnRequestAddress. The relations look like so: ReturnRequest class ReturnRequest { public function customer() { return $this->hasOne(ReturnRequestCustomer::class); } public function shippingAddress() { return ..
I’m trying to create a Request factory that will assign multiple random users for every individual Request instance that is created using said factory. using the method definition in the Factory I am able to assign a belongsTo, but it’s not clear to me how I can create a belongsToMany. This is my Request model: ..
When I call the findAll() function in the result I get all the relation so I need to select the same columns. In Laravel they are used with() to resolve problm so What is the equivalent of the Laravel function in spring boot Sourc..
in my Laravell Application, I need submodels of the base ORM model, for specific types of item in my DB which is specified in ‘type’ collum in DB in my base model, I use this override for function newFromBuilder //OVERIDES public function newFromBuilder($attributes = [], $connection = null) { $class = "AppModels" . ucfirst($attributes->type); if ..
I’m creating an API. In this repository there’s a method called show() where a contact is returned. The user must provide an ID of a contact and can provide an array of relationships to be loaded and an array of the contact’s attributes called fields. return $this->contacts::with($request->relationships)->findOrFail($request->id, $request->fields); But when $request->fields is provided all the ..
How do I order by more than one paramenter descending or ascending in Laravel/Eloquent. Example: I want to pass more than one parameter to sort the output data, for example, sort by ‘date’ AND ‘name’. Sourc..
let’s go to my problem. Suppose I have a table that is named Hero and now I want to get HeroId for the hero name batman(unique) for normal I will use a loop to check in the list hero if the hero that has a name is Batman so I got it. But with this ..
Hello my all benefactors ! I have been faced serious issue on Laravel and stocked for few days. First of all, i want to insert request data to DB before API request. After request and got a response object, then i want to insert response data to DB. HOWEVER, issue has appeared with asynchronous queue. ..
We have two entities using InheritanceType("SINGLE_TABLE"). The parent class that defines the DiscriminatorMap is Note. The two children are Comment and Message. There are cases where we would like to copy a comment from a message. We wanted to indicate where this occurred so we added a column called copied_to_id. And every time we copy ..
I have a challenge in laravel polymorph many to many relationship. i am using this database architecture products id – integer name – string price – float articles id – integer title – string description – string tags id – integer name – string taggables tag_id – integer taggable_id – integer taggable_type – string how ..
I have DB with table items. I need result items by laravel ORM. Condition: select where col1 != col2 Sourc..
categories table 1 electronic gadget electronic-gadget 2 laptops laptops 3 mobile phone mobile-phone sub_categories table id category_id name slug 1 1 television television 1 3 mobile phone mobile-phone 1 2 radio product radio-product brands table id name slug 1 sony sony 2 samsung samsung 3 sony brand sony-brand 4 asus rob asus-rog products table id| ..
I’m a newbie in Laravel and I tried to connect two tables with SUM of one column along with other columns, But it’s returned an error and I don’t know how to fix that.. Please help me to resolve the issue. Any help is appreciated … $sinv =DB::table(‘salesinvoices’) ->leftJoin(‘customers’,’customers.id’,’=’,’salesinvoices.customer’) ->select(DB::raw(‘sum((salesinvoices.grand_total)-(salesinvoices.isslnrtn_amt)) as sumgrand’),’customers.short_name’) ->where(‘salesinvoices.is_deleted’,’0′) ->where(‘salesinvoices.is_returned’,’!=’,’1′) ->where(‘salesinvoices.paidstatus’,’!=’,’1′) ..
Tables: categories (id, name) complains (id, category_id, complain_text) replies (id, complain_id, reply_text); Relationship between tables: one category has many complains. one complain has one reply How can I use Eloquent ORM to SELECT category with complain that has no reply? Sourc..
I’m building a project with Laravel 8. I need to handle request parameter which contains page, limit, searchColumn, searchText, orderColumn and orderDirection. Sometimes I need to search in relations. I’ve built this system below but it doesn’t work on relationships. $query = (new Log())->newQuery(); $query->with(‘customer’, ‘domain’, ‘type’); if ($request->searchColumn != "" && $request->searchColumn != NULL) ..
Although code-based answers are much appreciated, but I’m interested in knowing the logic behind handling this, as it might happen again later. I’m working on an eCommerce project. Most products are variables. Imagine a shirt for example. A shirt can have 5 different sizes ( XS, S, M, ML, L ) and 3 colors ( ..
Laravel serialization documentation describes in detail how to get array / JSON representation of Eloquent models. However, it doesn’t currently say a word about reversing this: getting Eloquent models out of arrays / JSON. How do I do this? Thanks! Sourc..
i have an table of users and every user has a role and a ParentID i want to get an array on specifique order based on role and ParentID, the objectif of getting a specifique order is to create a tree view to visualisate all the users in a tree HTML view arborecence using vueJS ..
I have a multitenant application, below I have 2 connections defined, one is the default that is used by the application and the other is one that is used to access the central database while I am on the tenant connection. ‘mysql’ => [ ‘driver’ => ‘mysql’, ‘url’ => env(‘DATABASE_URL’), ‘host’ => env(‘DB_HOST’, ‘127.0.0.1’), ‘port’ ..
Hi guys please help solve this problem. Need to convert this query to Laravel ORM. $user = Auth::user(); $datas = DB::select(‘select * from kvits k left join (select o.kvit_id, sum(o.amount * o.price) as sum from operations o group by o.kvit_id) s on k.id = s.kvit_id left join users u on k.user_id = u.id left join ..
Web Development Company
Free Hosting Company
