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 nonStandardIssuedList() { $id = Auth::user()->emp_id(); //query for getting list sorted by Corrective Status /*$displayQuery=DB::table('sc_safety_concern') ->orderBy('id', 'desc') ->get();*/ $displayQuery = DB::table('sc_safety_concern')->leftJoin('sc_primary_inspection', 'sc_safety_concern.inspection_number', '=', 'sc_primary_inspection.inspection_number')->where('sc_safety_concern.type_of_concern', '=', 'Non-Standard Issue')->get(); //print_r($query); return View::make('safetyConcerns/nonStandardIssuedList')->with('PageName', 'Non Standard Issued List')->with('active', 'sia')->with('sl', '0')->with('dates', parent::dates())->with('toDay', date("d F Y"))->with('months', parent::months())->with('year', parent::years_from())->with('infos', $displayQuery)->with('personnel', parent::getPersonnelInfo()); }
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 aircraftSingle($mm, $msn) { $primaryData = DB::table('aircraft_primary_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $tcData = DB::table('aircraft_tc_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $stcData = DB::table('aircraft_stc_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $exemptionData = DB::table('aircraft_exemption_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $registrationData = DB::table('aircraft_registration_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $airworthinessData = DB::table('aircraft_airworthiness_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $approvalData = DB::table('aircraft_caa_approval_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $ownerData = DB::table('aircraft_owner_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $lesseeData = DB::table('aircraft_lessee_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $insurerData = DB::table('aircraft_insurer_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $equipmentData = DB::table('aircraft_equipment_review_info')->where('aircraft_MM', '=', $mm)->where('aircraft_MSN', '=', $msn)->where('soft_delete', '=', '0')->get(); $organizations = DB::table('users')->lists('organization'); $select = array('' => '--Select--'); $inspectors = DB::table('users')->where('role', '=', 'Inspector')->lists('name', 'name'); $inspectors = array_merge($select, $inspectors); return View::make('aircraft/aircraft-single')->with('PageName', 'Aircraft Info.')->with('active', 'aircraft')->with('personnel', parent::getPersonnelInfo())->with('dates', parent::dates())->with('months', parent::months())->with('years', parent::years())->with('primaryData', $primaryData)->with('tcData', $tcData)->with('stcData', $stcData)->with('exemptionData', $exemptionData)->with('registrationData', $registrationData)->with('airworthinessData', $airworthinessData)->with('approvalData', $approvalData)->with('ownerData', $ownerData)->with('lesseeData', $lesseeData)->with('insurerData', $insurerData)->with('equipmentData', $equipmentData)->with('organizations', $organizations)->with('inspectors', $inspectors)->with('ND', 0); }
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 index() { return View::make('dashboard')->with('PageName', 'Dashboard')->with('active', 'dashboard')->with('personnel', parent::getPersonnelInfo()); }