I have a column called Class ID and I am trying to sort this column. It seems to ignore the numbers. I assume because they are strings. Currently, it looks like this: NewSyn - 1 OBSSt NewSyn - 1 OBSSt…
I have a table called sales with the following columns. transaction_id transaction_refund_id price id transaction_id transaction_refund_id price 1 tr_001 0 5 2 tr_002 tr_001 5 3 tr_003 tr_003 5 I want to query the sales table and join the records…
i was try to get environment variabel, to get APP_URL from .env, but always return null, but when use random string it show, so this because .env value can't retrieve class Attachment extends Model { public function getUrlAttribute() { return…
Let's say I have a MySQL table called points with 4 columns (id, user_id, point, date). And, let's consider these dummy rows for better understanding. id user_id point date 1 1 2 2000-01-01 2 1 3 2000-01-01 3 2 5…
I have two tables tasks and task_hours, And I'm using one to many relationship in task model.(task can have many hours logs). And displaying task data at frontend in table (datatable) using with relationships to task_hours (as per query below).…
I'm trying to save the data from the form. However, there is no record when I check the database side. I'm using Laravel 10 and mySQL v5.7. **Controller **store() public function store(Request $request) { $personnelRegistry = null; $personnerlRegistryId = (int)$request->input('personnelRegistryId',…
I have three models: Vehicle, LiveData, and Place. In my Vehicle model, I currently have a relationship between Vehicle and LiveData that gets the latest LiveData for a vehicle: public function latestPosition(): HasOne { return $this->hasOne(LiveData::class)->latestOfMany(); } Now in my…
I wonder if is there any method in Laravel that check if column_id is not null and contains a valid id, then bring the relation if It is ? so for example: instead of doing this: if ($order->billing_address_id && $billingAddress…
I have a model Facility that has rates (tariffs). The Rate model has a relationship to a RateType. The RateType has a column weight. I want to sort the Facility's rates based on those weights. I would like to always…
I'm trying to select a specific column from a relationship. F.x User::with(array('phone' => function($q) { $q->where('ext', "!=" 42); }))->select('id', 'number'); Here i ONLY want to select the user ID, and the number for the phone. How can i do that?…