vendredi 27 octobre 2017

append data with query result set

I want to append the data with select query output

$project_code=DB::table('project')->where('customer_code',$customer_name)->whereRaw("owner in (select a.user_name from users a left join users b on a.manager=b.firstname where a.user_name='$user_name' or a.manager = '$first_name' or b.manager ='$first_name')")->pluck('name','code')->all();

From the above result set I want to add the value no_client in name and 0 in code in laravel 5.3



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire