PHP BaseController::years_from方法代码示例

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

 /**
  * Store a newly created resource in storage.
  *
  * @return Response
  */
 public function singleReport($id)
 {
     $reportInfo = DB::table('voluntary_reporting')->where('soft_delete', '<>', '1')->where('id', $id)->get();
     $reportAction = DB::table('voluntary_reporting_action')->where('soft_delete', '<>', '1')->where('report_id', $id)->get();
     $approvalInfo = DB::table('voluntary_reporting_approval')->where('soft_delete', '<>', '1')->where('report_id', $id)->orderBy('id', 'desc')->get();
     return View::make('voluntaryReporting.singleReport')->with('PageName', 'Single Report')->with('active', 'voluntary_reporting')->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years_from())->with('reportInfo', $reportInfo)->with('reportAction', $reportAction)->with('reportId', $id)->with('approvalInfo', $approvalInfo);
 }

 public function viewUsers()
 {
     $users = DB::table('users')->orderBy('emp_id')->get();
     $modules = DB::table('module_user_permission')->where('soft_delete', '<>', '1')->orderBy('module_name')->get();
     $select[''] = 'Select Module';
     $moduleNames = DB::table('module_names')->where('soft_delete', '<>', '1')->orderBy('module_name')->lists('module_name');
     $moduleNames = array_merge($select, $moduleNames);
     return View::make('settings/viewUsers')->with('PageName', 'View Users')->with('active', 'settings')->with('dates', parent::dates())->with('toDay', date("d F Y"))->with('months', parent::months())->with('year', parent::years_from())->with('personnel', parent::getPersonnelInfo())->with('organizations', $this->organizations())->with('users', $users)->with('modules', $modules)->with('moduleNames', $moduleNames);
 }

 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 listView()
 {
     $today = date("d F Y");
     $dates = parent::dates();
     $months = parent::months();
     $years = parent::years_from();
     //query
     $queryAll = DB::table('document_controllers')->orderBy('id', 'desc')->get();
     $queryActive = DB::table('document_controllers')->where('active', 'Yes')->orderBy('id', 'desc')->get();
     $queryInactive = DB::table('document_controllers')->where('active', 'No')->orderBy('id', 'desc')->get();
     return View::make('documentControl/listView')->with('PageName', 'Document List')->with('dates', $dates)->with('toDay', $today)->with('months', $months)->with('year', $years)->with('infos', $queryAll)->with('actives', $queryActive)->with('inactives', $queryInactive)->with('personnel', parent::getPersonnelInfo());
 }

 public function issuedList()
 {
     //return 'Hello';
     $today = date("d F Y");
     $dates = parent::dates();
     $months = parent::months();
     $years = parent::years_from();
     $id = Auth::user()->emp_id();
     //query for getting list sorted by Corrective Status
     $displayQuery = DB::table('admin_trackings')->where('initial_risk', '!=', 'R-Resolved')->where('initial_risk', '!=', 'X-Cancelled')->orderBy('id', 'desc')->get();
     //print_r($displayQuery);
     return View::make('adminTracking/issuedListl')->with('PageName', 'Admin Tracking List')->with('sl', '0')->with('dates', $dates)->with('toDay', $today)->with('months', $months)->with('year', $years)->with('infos', $displayQuery)->with('personnel', parent::getPersonnelInfo());
 }

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