public function secondqrequestupdatenav(Request $request)
{
$request_q = DB::connection('sqlsrv')->select(DB::raw("SELECT id,style,color,size,status FROM secondq_requests"));
//dd($request_q);
foreach ($request_q as $row) {
$id = $row->id;
$style = $row->style;
$color = $row->color;
$size = $row->size;
$status = $row->status;
if ($status == "pending") {
//dd($id." ".$po." ".$size);
$po = DB::connection('sqlsrv3')->select(DB::raw("SELECT [Item No_]\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Color]\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[TG]\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Materiale] as materiale\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Description Model] as des\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[TG2] as tg2\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Commersial Color code] as ccc\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Color decstionption] as cd\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t ,[Barcode] as barcode\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM [Gordon_LIVE].[dbo].[GORDON\$Barocde Table Quality]\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE [Item No_] = '" . $style . "' \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tAND [Color] = '" . $color . "' \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \tAND [TG] = '" . $size . "'"));
$materiale = $po['0']->materiale;
$desc = $po['0']->des;
$tg2 = $po['0']->tg2;
$ccc = $po['0']->ccc;
$cd = $po['0']->cd;
$barcode = $po['0']->barcode;
$update = SecondQRequest::findOrFail($id);
$update->materiale = $materiale;
$update->desc = $desc;
$update->tg2 = $tg2;
$update->ccc = $ccc;
$update->cd = $cd;
$update->barcode = $barcode;
$update->save();
}
}
return Redirect::to('/secondqrequesttable');
}
