mercredi 6 octobre 2021

how to convert sql query in laravel query?

Iknow this question is not asked well manner so i am sorry i have sql query this one

`SELECT
    c.*
FROM
    merchantlink m,
    company c,
    merchantlinkrelation mlr
WHERE
    (m.initiator_user_id = c.owner_user_id AND
     m.responder_user_id = 86 AND
     mlr.ptype='dealer')
     OR
    (m.initiator_user_id = 86 AND
     m.responder_user_id = c.owner_user_id AND
     mlr.ptype = 'dealer')
     OR
    (m.initiator_user_id = c.owner_user_id AND
     c.owner_user_id=86 AND
     mlr.ptype='dealer')
GROUP BY
    c.id;`

i wnat to convert it in php laravel query form so tried this query

$twowaycompany = DB::table('company')
            ->join('merchantlink','merchantlink.responder_user_id', 'company.owner_user_id')
            ->orWhere('merchantlink.initiator_user_id', 86)
            ->join('merchantlink','merchantlink.initiator_user_id', 'company.owner_user_id')
            ->orWhere('merchantlink.responder_user_id', 86)
            ->pluck('name')->toArray();

but i dont know sql and even i am not understanding how i convert it can some one help just convert sql query to laravel query?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire