public function singleProgram($sia_number)
{
$programDetails = DB::table('sia_program')->where('soft_delete', '<>', '1')->where('sia_number', $sia_number)->get();
$actionDetails = DB::table('sia_action')->where('soft_delete', '<>', '1')->where('sia_number', $sia_number)->get();
$safetyCons = DB::table('sc_safety_concern')->where('soft_delete', '<>', '1')->where('sia_number', $sia_number)->get();
$edps = DB::table('edp_primary')->where('soft_delete', '<>', '1')->where('sia_number', $sia_number)->get();
$approvalInfo = DB::table('sia_approval')->where('soft_delete', '<>', '1')->where('sia_number', $sia_number)->get();
$inspectors = CommonFunction::InspectorListWithID();
$organizations = CommonFunction::organizations();
$findings = DB::table('sia_findings')->where('soft_delete', '<>', '1')->where('sia_number', $sia_number)->get();
$sms = DB::table('sia_sms')->where('soft_delete', '<>', '1')->where('sia_number', $sia_number)->get();
return View::make('surveillance.singleProgram')->with('PageName', 'Single Program')->with('active', 'sia')->with('dates', parent::dates())->with('toDay', date("d F Y"))->with('months', parent::months())->with('years_from', parent::years_from())->with('years', parent::years())->with('sia_number', $sia_number)->with('programDetails', $programDetails)->with('actionDetails', $actionDetails)->with('safetyCons', $safetyCons)->with('approvalInfo', $approvalInfo)->with('edps', $edps)->with('inspectors', $inspectors)->with('organizations', $organizations)->with('findings', $findings)->with('sms', $sms);
}
