Mysql query how to match column key and value

Asked Mar 26 '20 at 05:39

Active Mar 26 '20 at 06:24

Viewed 148 times

I have query with this

->leftjoin(
    DB::raw("(
        SELECT transactable_id AS invoice_id, transactions.payment_method_id, payment_methods.name AS payment_method, SUM(transactables.amount) AS trans_amount
        FROM transactions
        join payment_methods on payment_methods.id = transactions.payment_method_id
        join transactables on transactables.transaction_id = transactions.id
        and transactions.deleted_at is null
        and transactables.deleted_at is null
        and transactable_type = 'Sale'
        GROUP BY transactable_id

    ) AS trx"), 'trx.invoice_id', '=', 'sales.id', 'GROUP BY trx.invoice_id')
->addSelect(DB::raw('IFNULL(trans_amount , 0.00 ) AS trans_amount'),DB::raw('trx.payment_method'))

Return result from the select like

+"trans_amount": "200.00"
+"payment_method": "Cash"

How to form the data base on the value like

+"Cash": "200.00"

edited Mar 26 '20 at 06:12

Akina

39,301
5
14
25

asked Mar 26 '20 at 05:39

pajin

Not simply done, me thinks. https://vitobotta.com/2015/12/10/mysql-dynamic-column-name/ How might your results vary? Where is your table schema? – mickmackusa Mar 26 '20 at 06:21
mysql questions are best accompanied with a db-fiddle demo link. – mickmackusa Mar 26 '20 at 06:30

Mysql query how to match column key and value

0 Answers0