public function getCalulatequestion() { $asset = array(); $asset = AssetRegister::find(Input::get('node_fmeca')); $step1 = DB::Select(DB::raw("\n\t\t\tselect c.name,c.id from asset_complex_detail ac,complex c\n\t\t\twhere ac.node = " . $asset->complex_node . "\n\t\t\tand ac.complex_id = c.id\n\t\t\tand ac.type = 5"))[0]; $r = 0; $od = 0; $rs = 0; if ($step1->id == 1 || $step1->id == 2) { $r = 100 / 4; } elseif ($step1->id == 3) { $r = 100 / 5; } $od = Input::get('occ_id') * Input::get('detection_id'); if ($od <= $r) { $rs = 1; } elseif ($od <= $r * 2) { $rs = 2; } elseif ($od <= $r * 3) { $rs = 3; } elseif ($od <= $r * 4) { $rs = 4; } elseif ($od <= $r * 5) { $rs = 5; } $step2 = DB::Select(DB::raw("\n\t\t\t\t\tSELECT * FROM asset_complex_detail\n\t\t\t\t\tWHERE active = 1 AND type = 5\n\t\t\t\t\tAND node = " . $asset->complex_node . "\n\t\t\t\t\tAND rows = " . Input::get('serv_id') . "\n\t\t\t\t\tAND columns = " . $rs))[0]; echo $step2->question; }