F
Filament•9mo ago
Wbzy

How to show Count relationship in table?

What im trying to do: i want to make a report for mutation that happen in the products based on monthly filter. the model is product has many transaction and transaction has one transaction details. the stock in and out is in the transaction details. what i did: because its based on monthly filter so i think i would choose the transactions. this is my base query. 
Transaction::query()->with(['product', 'transactionDetail'])->whereHas('transactionDetail')
Transaction::query()->with(['product', 'transactionDetail'])->whereHas('transactionDetail')
my issue is: how to show the product name, and then total stock in from the transaction details and total stock out. i wont to see all the transaction just the product name and the total of mutation.
No description
3 Replies
toeknee
toeknee•9mo ago
Add a relationship that does it? So build relationships that will return the in and another for out then you can just pass in ->count()
Wbzy
Wbzy•9mo ago
oke i found the solution using 
->defaultGroup('category')
->groupsOnly();
->defaultGroup('category')
->groupsOnly();
Wbzy
Wbzy•9mo ago
but some how the column doesnt look good
No description
Want results from more Discord servers?
Add your server
More Posts
Access model $record issue in Select (pluck)I am trying the following: I want to select only the related recipe stages according to the recipe_iColumn headers using SplitThe column headers are gone when using `Split` view. I am using `Split` because I want to show some Execute php code when clicking on link in custom columnI have a custom column: ````CopyUrlColumn::make('linkedin_url')->sortable()->searchable()``` This cCustom page in resourceI want to create a custom page in my resource.I cant figure out how to call it from my list page in CheckboxList - set description from relationship recordHi all Is there a way to set the CheckboxList item descriptions from the record when using a relatiArray of custom colors (badge)I'm confused on how to use colors() instead of color() for badge. The case is i want my badge color Run a function after a table is loaded.I want to run a function after the ListResource page is loaded like an SQL query that markAsRead. ArHow implement a filter in a filament resource that uses the attribute of a HasOne relationshipHello everyone. I have a question, how can I implement a filter in a filament resource that uses the