I have joined 2 databases, what i want is to get the total value/sum of these 2 multiplied column: Example on the database: Price Quantity 100 1 110 2 120 3 in my query in laravel- i got the total,…
I have a problem in getting some data in my database. It returns HTML data. {data: '<!DOCTYPE html>n<html lang="en">n <head>n …>n x3Cscript src="/js/app.js">x3C/script>n</html>n', status: 200, statusText: 'OK', headers: AxiosHeaders, config: {…},…} And I am only requesting an authenticated user's username.…
I'm trying to run "php artisan migrate" in docker app container bash, after successfully installing mysql, nginx, php and etc. containers. But this error comes up : SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = code_clan…
I want this output id jml total 1 1000 1000 1 100 1100 2 400 400 2 300 700 but when i try my output is id jml total 1 1000 1000 1 100 100 2 400 400 2 300…
I'm using Laravel with docker and am new to installing redis. I've added redis locally via brew, and have it started up with redis-server. It's reporting initialized and ready to accept connections via tcp. In Docker Compose, I've associated port…
I have one to many relations In my User Model public function user_balances(){ return $this->hasMany(UserBalances::class); } In my User Balances Model public function user(){ return $this->belongsTo(UserBalances::class); } So every time I want to retrieve the last record of user balance,…
Hello i am facing an issue in filament v3.I am making an order form using repeater in which there is relation with product table. The thing i want to do is by selecting product in select the other fields that…
I have made an API and a trait with a function to handle responses. namespace AppTraits; use AppModelsUser; use AppModelsDiseases; use AppModelsExaminations; use AppModelsRec_Doc; use AppHttpResourcesfailter; trait ApiTraits { public function apiGet($id = null, $table) { if ($table::find($id)) { $status…
I have a table for the invoice and it has the primary key which is id, and for invoice details the foreign key is invoice_id. What I want is during saving the primary key on the invoice, it would also…
Im new to Laravel Packpack. My issue is I have filters using this code $this->crud->addFilter( ['name' => 'created_at', 'type' => 'date_range', 'label' => 'Bid Date'], false, function ($value) { $dates = json_decode($value); $this->crud->addClause('where', 'created_at', '>=', $dates->from); $this->crud->addClause('where', 'created_at', '<=', $dates->to…