PHP BaseController::years方法代码示例

 public function singleOrganization($orgNum)
 {
     $organizations = DB::table('users')->lists('organization');
     $orgPrimary = DB::table('org_primary')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_business_name = DB::table('org_business_name')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_certificates = DB::table('org_certificates')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_base_location = DB::table('org_base_location')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_management_contacts = DB::table('org_management_contacts')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_caa_contacts = DB::table('org_caa_contacts')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_exemptions_divinations = DB::table('org_exemptions_divinations')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_aircraft_listings = DB::table('org_aircraft_listings')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_policy_menual_approvals = DB::table('org_policy_menual_approvals')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_complexity_reviews = DB::table('org_complexity_reviews')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_aerial_work_approvals = DB::table('org_aerial_work_approvals')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_non_certificated_operations = DB::table('org_non_certificated_operations')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_flight_operation_approvals = DB::table('org_flight_operation_approvals')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_fleet_operation_approvals = DB::table('org_fleet_operation_approvals')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_fleet_maintanance_approvals = DB::table('org_fleet_maintanance_approvals')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_airport_auth = DB::table('org_airport_auth')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_leasing_arrangment = DB::table('org_leasing_arrangment')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->get();
     $org_contracted_services = DB::table('org_contracted_services')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_amo_approvals = DB::table('org_amo_approvals')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_ato_approvals = DB::table('org_ato_approvals')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_aoc_approvals_areas = DB::table('org_aoc_approvals_areas')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_aoc_approval_routes = DB::table('org_aoc_approval_routes')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_aoc_maintenance_arrangement = DB::table('org_aoc_maintenance_arrangement')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_aoc_training_arrangement = DB::table('org_aoc_training_arrangement')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_approval_simulators = DB::table('org_approval_simulators')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_financial_status = DB::table('org_financial_status')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_operations_specifications = DB::table('org_operations_specifications')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_aoc_certificate = DB::table('org_aoc_certificate')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     $org_docs = DB::table('org_document_list')->where('org_number', '=', $orgNum)->where('soft_delete', '<>', '1')->orderBy('id', 'desc')->get();
     return View::make('organization.singleOrg')->with('PageName', 'Single Organization')->with('active', 'organization')->with('orgPrimary', $orgPrimary)->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years())->with('years_from', parent::years_from())->with('org_business_name', $org_business_name)->with('org_certificates', $org_certificates)->with('org_base_location', $org_base_location)->with('org_management_contacts', $org_management_contacts)->with('org_caa_contacts', $org_caa_contacts)->with('org_exemptions_divinations', $org_exemptions_divinations)->with('org_aircraft_listings', $org_aircraft_listings)->with('org_policy_menual_approvals', $org_policy_menual_approvals)->with('org_complexity_reviews', $org_complexity_reviews)->with('org_aerial_work_approvals', $org_aerial_work_approvals)->with('org_non_certificated_operations', $org_non_certificated_operations)->with('org_flight_operation_approvals', $org_flight_operation_approvals)->with('org_fleet_operation_approvals', $org_fleet_operation_approvals)->with('org_fleet_maintanance_approvals', $org_fleet_maintanance_approvals)->with('org_airport_auth', $org_airport_auth)->with('org_leasing_arrangment', $org_leasing_arrangment)->with('org_leasing_arrangment', $org_leasing_arrangment)->with('org_contracted_services', $org_contracted_services)->with('org_amo_approvals', $org_amo_approvals)->with('org_ato_approvals', $org_ato_approvals)->with('org_aoc_approvals_areas', $org_aoc_approvals_areas)->with('org_aoc_approval_routes', $org_aoc_approval_routes)->with('org_aoc_maintenance_arrangement', $org_aoc_maintenance_arrangement)->with('org_aoc_training_arrangement', $org_aoc_training_arrangement)->with('org_approval_simulators', $org_approval_simulators)->with('org_financial_status', $org_financial_status)->with('org_operations_specifications', $org_operations_specifications)->with('org_aoc_certificate', $org_aoc_certificate)->with('org_docs', $org_docs)->with('organizations', $organizations);
 }

 public function singleEdp($edpNumber)
 {
     $edpDetails = DB::table('edp_primary')->where('edp_number', $edpNumber)->where('soft_delete', '<>', '1')->get();
     $approvalInfos = DB::table('edp_approval')->where('edp_number', $edpNumber)->get();
     $legalOpinions = DB::table('edp_legal_opinion')->where('edp_number', $edpNumber)->get();
     $undefineSurveillance = array('70000' . time() => '70000-' . time() . ' if Unbdefine Program');
     $toDayProgram = DB::table('sia_program')->lists('sia_number');
     $toDayProgram = array_merge($undefineSurveillance, $toDayProgram);
     return View::make('edp.singleEpd')->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('PageName', 'Single EDP')->with('active', 'sia')->with('edpDetails', $edpDetails)->with('edpNumber', $edpNumber)->with('approvalInfos', $approvalInfos)->with('legalOpinions', $legalOpinions)->with('toDayProgram', $toDayProgram);
 }

 public function summary()
 {
     $primaryInfo = $this->aircraftPrimaryInfo();
     return View::make('aircraft.summary')->with('PageName', 'Aircraft Central Search')->with('active', 'aircraft')->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years())->with('primaryInfo', $primaryInfo);
 }

 public function publicView()
 {
     $allDocs = DB::table('lib_suporting_docs')->where('soft_delete', '<>', '1')->where('doc_status', '=', 'Public')->orderBy('doc_type')->get();
     $docTypes = DB::table('lib_suporting_docs_type')->where('soft_delete', '<>', '1')->lists('doc_type');
     return View::make('library.supportingDocuments.viewPublic')->with('PageName', 'Private Supporting View ')->with('active', 'e_library')->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('allDocs', $allDocs)->with('docTypes', $docTypes);
 }

 public function followUp($sc_num)
 {
     $folloUpInfos = DB::table('sc_follow_up')->where('safety_issue_number', '=', $sc_num)->get();
     return View::make('safetyConcerns.follow-up')->with('PageName', 'Single Inspection')->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('sc_num', $sc_num)->with('folloUpInfos', $folloUpInfos);
 }

 public function comp_view_per()
 {
     $id = Auth::user()->emp_id();
     $query1 = DB::table('qualification_personal')->where('emp_id', '=', $id)->get();
     $query2 = DB::table('qualification_edu_accademic')->where('emp_id', '=', $id)->get();
     $query3 = DB::table('qualification_edu_thesis')->where('emp_id', '=', $id)->get();
     $query4 = DB::table('qualification_emplyment')->where('emp_id', '=', $id)->get();
     $query5 = DB::table('qualification_pro_degree')->where('emp_id', '=', $id)->get();
     $query6 = DB::table('qualification_training_ojt')->where('emp_id', '=', $id)->get();
     $query7 = DB::table('qualification_language')->where('emp_id', '=', $id)->get();
     $query8 = DB::table('qualification_technical_licence')->where('emp_id', '=', $id)->get();
     $query9 = DB::table('qualification_aircraft')->where('emp_id', '=', $id)->get();
     $query10 = DB::table('qualification_reference')->where('emp_id', '=', $id)->get();
     $query11 = DB::table('qualification_employee_verification')->where('emp_id', '=', $id)->get();
     $query12 = DB::table('qualification_others_publication')->where('emp_id', '=', $id)->get();
     $query13 = DB::table('qualification_others_membership')->where('emp_id', '=', $id)->get();
     return View::make('qualification/comp_view')->with('PageName', 'Comprehensive View')->with('active', 'employee')->with('personnel', parent::getPersonnelInfo())->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years())->with('years_from', parent::years_from())->with('sl1', '0')->with('sl2', '0')->with('sl3', '0')->with('sl4', '0')->with('sl5', '0')->with('sl6', '0')->with('sl7', '0')->with('sl8', '0')->with('sl9', '0')->with('sl10', '0')->with('sl11', '0')->with('sl12', '0')->with('ev', '0')->with('personnel', $query1)->with('accademic', $query2)->with('thesis', $query3)->with('emplyment', $query4)->with('pro_degree', $query5)->with('training_ojt', $query6)->with('language', $query7)->with('technical_licence', $query8)->with('aircraft', $query9)->with('reference', $query10)->with('verification', $query11)->with('publication', $query12)->with('membership', $query13);
 }

 public function reportByModuel($moduleName)
 {
     return View::make('report.report')->with('PageName', 'Report')->with('active', $moduleName)->with('module', $moduleName)->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('from', '1 January ' . date('Y'))->with('to', date('d F Y'))->with('from_Date', '1')->with('fromMonth', 'January')->with('fromYear', date('Y'))->with('to_Date', date('d'))->with('toMonth', date('F'))->with('toYear', date('Y'))->with('fromDate', date('Y') . '-01-01')->with('toDate', date('Y-m-d'));
 }

 public function eventDetails($certificateId, $eventId)
 {
     $recors = DB::table('certi_event_timeline')->where('certificate_id', $certificateId)->where('event_id', $eventId)->orderBy('id', 'desc')->get();
     $eventStatus = DB::table('certi_event_status')->where('certificate_id', $certificateId)->where('event_id', $eventId)->first();
     return View::make('certification.singleEvent')->with('PageName', 'Single Event')->with('active', 'service_provider_certification')->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years())->with('certificateId', $certificateId)->with('eventId', $eventId)->with('eventStatus', $eventStatus)->with('recors', $recors);
 }

 public function atcLogDetails()
 {
     return View::make('pel.atcLogDetails')->with('PageName', 'ATC Log Details')->with('active', 'personnel_licensing')->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years())->with('atcLogs', '');
 }

 public function newActionEnrty()
 {
     return View::make('surveillance.newActionEnrty')->with('PageName', 'New Action Entry')->with('dates', parent::dates())->with('toDay', date("d F Y"))->with('months', parent::months())->with('years_from', parent::years_from())->with('years', parent::years());
 }

 public function itsRecords()
 {
     $id = Auth::user()->emp_id();
     $emp_tracker = DB::table('itsojt_trainee')->where('employee_id', $id)->pluck('emp_tracker');
     $itsAssignedFormal = DB::table('itsojt_assign_course_ojt')->where('emp_tracker', $emp_tracker)->where('soft_delete', '<>', '1')->select('itscn', 'emp_tracker')->get();
     //$itsAssignedFormal=array_unique($itsAssignedFormal);
     return View::make('itsOjt/itsRecords')->with('PageName', 'Individual ITS Records')->with('active', 'its')->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years())->with('itsAssignedFormal', $itsAssignedFormal);
 }

 public function correctiveAction($sia_number, $id = '')
 {
     $findings = DB::table('sia_findings')->where('soft_delete', '<>', '1')->where('sia_number', $sia_number)->get();
     $correctiveActions = DB::table('sia_corrective_action')->where('soft_delete', '<>', '1')->where('sia_number', '=', $sia_number)->get();
     return View::make('surveillance.correctiveAction')->with('PageName', 'SIA Corrective Action')->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('correctiveActions', $correctiveActions)->with('findings', $findings)->with('jump_to', $id);
 }

 public function newPQ()
 {
     return View::make('usoapCma.newPQ')->with('PageName', 'New PQ')->with('active', 'usoap_cma')->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years());
 }