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;
}
