I'm working on a Laravel project where I need to calculate an estimated_value for each record in my SalesLead model by multiplying the probability and value columns. I want to filter records based on this computed column. I used a…
I have the following table. I am actually designing a simple chat, so, we have the user_id (the person who sends the message) and user_id_to (the person who receives the message). id user_id user_id_to message send_date 1 1 2 test…
I have a model named Document, Document has a status field where the possible values are, let's say dummy_data ['done', 'failed', 'sent', ....]. I want to get all documents where status='done' if they are present in DB OR all documents…
I want to get each employees task count in a month and integrate into bar chart,i managed to get total count of tasks based in a month i am confused how to do that user based,let's say i have 10…
I'm using laravel with query builder. Is there a way to transform a query builder result into json respecting the child elements and not creating a parse manually ? I mean, transform this: id customer product_id product 1 Will 1…
I have the following query params in string format $query = '->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'), request('endTime')])'; How do i pass it to the eloquent? Am trying to achieve something like this InboundMessage::query()->{$query}; Am getting the error below Property [->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'),…
I was maintaining a stock inventory system while selling a product available stock will be reduced based on oldest purchased means which product purchased first will be sold out first. I take the sales quantity with following lines: $product_id =…
I have a query like this SELECT ruangans.nama_ruangan, beds.id AS idBed, beds.nomor_bed, pasiens.nama, pasiens.status FROM `beds` JOIN ruangans ON beds.id_ruangan = ruangans.id LEFT JOIN pasiens ON beds.id = pasiens.id_bed WHERE pasiens.status != 'Sudah Rawat Inap' OR pasiens.status IS NULL; I'm…
I need a querybuilder query that calculates how many different people the user is messaging without counting the repetitive data. database photo Example: conver_user_id = 165, conver_user_seller_id = 156 conver_user_id = 165, conver_user_seller_id = 156 conver_user_id = 165, conver_user_seller_id =…
I need to find all results that include this substring (note the leading zero): $code = '02549'; Nomenclature::where('code', 'like', '%' . $code . '%')->get(); With such a builder, I get the correct request: select * from `nomenclatures` where `code` like…