how to execute query to laravel code

query like this

UPDATE items AS i   
INNER JOIN invoice_packages AS ip ON ip.id_invoice_package
INNER JOIN invoice_details AS id ON ip.inv_detail_id = id.id_inv_detail
INNER JOIN services AS s ON id.package_code = s.product_treatment_code
INNER JOIN service_details AS sd ON s.id = sd.service_id
SET i.begin_stock = (i.begin_stock - ip.used)
WHERE i.product_id IN (i.product_id,ip.used)

can give me example my query ? thanks

ahmeddabak

6 years ago

Best Answer

Level 47

 DB::table('items as i')->join('invoice_packages AS ip','ip.id_invoice_package','=','.....')
           // ...second join
            //..third join
        ->whereRaw('i.product_id IN (i.product_id,ip.used)')
        ->update([
            'i.begin_stock' => (i.begin_stock - ip.used)
        ]);

boill30

6 years ago

Level 1

thank you

Please or to participate in this conversation.