PHP BaseController::updateFileUpload方法代码示例

 public function updateSupportingDocument()
 {
     $doc_upload = parent::updateFileUpload('old_doc_upload', 'doc_upload', 'lib_supporting_docs');
     //Multiple selection
     //End Multiple selection
     $id = Input::get('id');
     DB::table('lib_suporting_docs')->where('id', $id)->update(array('doc_title' => Input::get('doc_title'), 'doc_authors' => Input::get('doc_authors'), 'doc_type' => Input::get('doc_type'), 'doc_subject' => Input::get('doc_subject'), 'doc_tags' => Input::get('doc_tags'), 'doc_series' => Input::get('doc_series'), 'doc_edition' => Input::get('doc_edition'), 'doc_part' => Input::get('doc_part'), 'doc_volume' => Input::get('doc_volume'), 'doc_amendment' => Input::get('doc_amendment'), 'doc_published_year' => Input::get('doc_published_year'), 'doc_isbn' => Input::get('doc_isbn'), 'doc_upload' => $doc_upload, 'doc_url' => Input::get('doc_url'), 'doc_status' => Input::get('doc_status'), 'row_updator' => Auth::user()->getName(), 'soft_delete' => 0, 'updated_at' => time()));
     return Redirect::back()->with('message', 'Supporting Docs Updated ');
 }

 public function updateLegalOpinion()
 {
     DB::table('edp_legal_opinion')->where('id', Input::get('id'))->update(array('legal_openion' => Input::get('legal_openion'), 'row_updator' => Auth::user()->getName(), 'updater_emp_id' => Auth::user()->getId(), 'updated_at' => date('Y-m-d H:i:s')));
     //document update
     //mother id
     $motherId = Input::get('id');
     $document = parent::updateFileUpload('old_doc', 'doc', 'documents');
     //update to document table
     DB::table('documents')->where('table_name', 'edp_legal_opinion')->where('mother_id', $motherId)->update(array('calling_id' => $document, 'updated_at' => date('Y-m-d H:i:s')));
     return Redirect::back()->with('message', 'Leagal Opinion Updated !');
 }

 public function updateOrgComplexityReview()
 {
     $file = parent::updateFileUpload('old_organogram_upload', 'organogram_upload', 'org_organogram');
     $id = Input::get('id');
     DB::table('org_complexity_reviews')->where('id', $id)->update(array('active' => Input::get('active'), 'org_review_date' => Input::get('org_review_date'), 'org_review_month' => Input::get('org_review_month'), 'org_review_year' => Input::get('org_review_year'), 'purpose_of_review' => Input::get('purpose_of_review'), 'total_employees' => Input::get('total_employees'), 'total_flt_ops_employees' => Input::get('total_flt_ops_employees'), 'total_pilots' => Input::get('total_pilots'), 'total_check_airmen' => Input::get('total_check_airmen'), 'total_flight_attendants' => Input::get('total_flight_attendants'), 'total_aircraft_dispatchers' => Input::get('total_aircraft_dispatchers'), 'flight_followers' => Input::get('flight_followers'), 'total_load_controllers' => Input::get('total_load_controllers'), 'total_maint_employees' => Input::get('total_maint_employees'), 'total_av_maint_technicians' => Input::get('total_av_maint_technicians'), 'total_av_repair_specialists' => Input::get('total_av_repair_specialists'), 'total_quality_assurance' => Input::get('total_quality_assurance'), 'organogram_upload' => $file, 'note' => Input::get('note'), 'row_updator' => Auth::user()->getName(), 'soft_delete' => 0, 'updated_at' => time()));
     /*Tracking quary*/
     $callTrackingFunction = $this->updateTracking('org_complexity_reviews', Input::get('org_number'));
     /*End Tracking quary*/
     return Redirect::back()->with('message', 'Data Updated !!');
 }

 public function updateAnswre()
 {
     $id = Input::get('id');
     $file = parent::updateFileUpload('old_file', 'file', 'helpFaq');
     DB::table('help_faq_ans')->where('id', $id)->update(array('ans' => Input::get('ans'), 'file' => $file, 'row_updator' => Auth::user()->getName(), 'updated_at' => date('Y-m-d H:i:s')));
     return Redirect::back()->with('message', 'Answer Updated');
 }

 public function editEquipmentReview()
 {
     $equip_upload = parent::updateFileUpload('old_equip_upload', 'equip_upload', 'air_equip_upload');
     $id = Input::get('id');
     DB::table('aircraft_equipment_review_info')->where('id', '=', $id)->update(array('review_date' => Input::get('review_date'), 'review_month' => Input::get('review_month'), 'review_year' => Input::get('review_year'), 'review_active' => Input::get('review_active'), 'purpose_of_review' => Input::get('purpose_of_review'), 'location' => Input::get('location'), 'airframe_hours' => Input::get('airframe_hours'), 'engine1_hours' => Input::get('engine1_hours'), 'engine2_hours' => Input::get('engine2_hours'), 'engine1_TSO' => Input::get('engine1_TSO'), 'engine2_TSO' => Input::get('engine2_TSO'), 'engine1_MMS' => Input::get('engine1_MMS'), 'engine2_MMS' => Input::get('engine2_MMS'), 'prop_rotor1_MMS' => Input::get('prop_rotor1_MMS'), 'prop_rotor2_MMS' => Input::get('prop_rotor2_MMS'), 'governor1_MMS' => Input::get('governor1_MMS'), 'governor2_MMS' => Input::get('governor2_MMS'), 'nav1_MMS' => Input::get('nav1_MMS'), 'nav2_MMS' => Input::get('nav2_MMS'), 'gps_mm' => Input::get('gps_mm'), 'adf_mm' => Input::get('adf_mm'), 'ils_mm' => Input::get('ils_mm'), 'vnav_mm' => Input::get('vnav_mm'), 'comm1_mm' => Input::get('comm1_mm'), 'comm2_mm' => Input::get('comm2_mm'), 'lr_comm_mm' => Input::get('lr_comm_mm'), 'tcas_mm' => Input::get('tcas_mm'), 'transponder_mm' => Input::get('transponder_mm'), 'transponder_mode' => Input::get('transponder_mode'), 'fdr_mm' => Input::get('fdr_mm'), 'fdr_mode' => Input::get('fdr_mode'), 'fdr_pinger_type' => Input::get('fdr_pinger_type'), 'cvr_mm' => Input::get('cvr_mm'), 'elt_mm' => Input::get('elt_mm'), 'note' => Input::get('note'), 'equip_upload' => $equip_upload, 'approve' => '0', 'warning' => '0', 'updated_at' => date('Y-m-d H:i:s')));
     return Redirect::back()->with('message', 'Successfully Updated!!');
 }

 public function updateMyProfile()
 {
     //$validator = Validator::make(Input::all(), User::$rule_changePass);
     $photo_upload = parent::updateFileUpload('old_photo', 'photo', 'userPhoto');
     $id = Input::get('id');
     //if ($validator->passes()) {
     DB::table('users')->where('id', $id)->update(array('name' => Input::get('name'), 'email' => Input::get('email'), 'photo' => $photo_upload));
     /*}
     		else{
     			return Redirect::to('settings')->with('error', 'The following errors occurred')->withErrors($validator)->withInput();
     		}*/
     return Redirect::back()->with('message', 'Profile Updated!!');
 }

 public function updateCorrectiveAction()
 {
     $corrective_action_file = parent::updateFileUpload('old_corrective_action_file', 'corrective_action_file', 'sc_corrective_action_file');
     $id = Input::get('id');
     $update = DB::table('sc_corrective_action')->where('id', '=', $id)->update(array('currective_action' => Input::get('currective_action'), 'revived_date' => Input::get('revived_date'), 'revived_month' => Input::get('revived_month'), 'revived_year' => Input::get('revived_year'), 'concern_authority_officer' => Input::get('concern_authority_officer'), 'regulation_mitigation' => Input::get('regulation_mitigation'), 'regulation_mitigation_date' => Input::get('regulation_mitigation_date'), 'regulation_mitigation_month' => Input::get('regulation_mitigation_month'), 'regulation_mitigation_year' => Input::get('regulation_mitigation_year'), 'corrective_action_file' => $corrective_action_file, 'row_updator' => Auth::user()->getName(), 'updated_at' => time()));
     if ($update) {
         //return Redirect::back()->with('message', 'Successfully Updated!!');
         return Redirect::to(URL::previous() . "#correctiveAction")->with('message', 'Successfully Updated!!');
     }
     //return Redirect::back()->with('message', 'Not Updated!!');
     return Redirect::to(URL::previous() . "#correctiveAction")->with('message', 'Not Updated!!');
 }

 public function updateAccademic()
 {
     $id = Input::get('id');
     $certificate = parent::updateFileUpload('old_certificate', 'certificate', 'employee');
     DB::table('qualification_edu_accademic')->where('id', $id)->update(array('level' => Input::get('level'), 'name_of_degree' => Input::get('name_of_degree'), 'discipline' => Input::get('discipline'), 'specialization' => Input::get('specialization'), 'institute' => Input::get('institute'), 'pussing_year' => Input::get('pussing_year'), 'standard' => Input::get('standard'), 'grade_division' => Input::get('grade_division'), 'certificate' => $certificate, 'out_of' => Input::get('out_of', false), 'verify' => '0', 'updated_at' => date('Y-m-d H:i:s')));
     return Redirect::back()->with('message', 'Successfully Updated!!');
 }

 public function updateTrainingDetails()
 {
     $file = parent::updateFileUpload('old_file', 'file', 'pelTrainingDetails');
     DB::table('pel_training_details')->where('id', Input::get('id'))->update(array('name_of_the_course' => Input::get('name_of_the_course'), 'name_of_the_institute' => Input::get('name_of_the_institute'), 'start_date' => Input::get('start_date'), 'start_month' => Input::get('start_month'), 'start_year' => Input::get('start_year'), 'end_date' => Input::get('end_date'), 'end_month' => Input::get('end_month'), 'end_year' => Input::get('end_year'), 'certificate_issue_date' => Input::get('certificate_issue_date'), 'certificate_issue_month' => Input::get('certificate_issue_month'), 'certificate_issue_year' => Input::get('certificate_issue_year'), 'expiration_date' => Input::get('expiration_date'), 'expiration_month' => Input::get('expiration_month'), 'expiration_year' => Input::get('expiration_year'), 'duration' => Input::get('duration'), 'approved_by' => Input::get('approved_by'), 'file' => $file, 'row_updator' => Auth::user()->getName(), 'updated_at' => date('Y-m-d H:i:s')));
     return Redirect::back()->with('message', 'Training Details Updated!!');
 }

 public function updateAction()
 {
     //$file=parent::fileUpload('file','voluntaryReporting');
     $file = parent::updateFileUpload('old_file', 'file', 'voluntaryReporting');
     $id = Input::get('id');
     $pageId = $id;
     DB::table('voluntary_reporting_action')->where('id', $id)->update(array('action_details' => Input::get('action_details'), 'file' => $file, 'row_updator' => Auth::user()->getName(), 'updated_at' => date('Y-m-d H:i:s')));
     return Redirect::to(URL::previous() . "#{$pageId}")->with('message', 'Action Updated!!');
 }

 public function editUpdateFormalOjtStatus()
 {
     $id = Input::get('id');
     $pageId = Input::get('pageId');
     $certificate = parent::updateFileUpload('old_certificate', 'certificate', 'itsOjt');
     //$certificate=parent::fileUpload('certificate','itsOjt');
     //$doc_upload=parent::updateFileUpload('old_doc_upload','doc_upload','lib_supporting_docs');
     $start_date = Input::get('start_date') . ' ' . Input::get('start_month') . ' ' . Input::get('start_year');
     $timestamp = strtotime($start_date);
     $start_date = date('Y-m-d', $timestamp);
     $completion_date = Input::get('completion_date') . ' ' . Input::get('completion_month') . ' ' . Input::get('completion_year');
     $timestamp = strtotime($completion_date);
     $completion_date = date('Y-m-d', $timestamp);
     $validity_date = Input::get('validity_date') . ' ' . Input::get('validity_month') . ' ' . Input::get('validity_year');
     $timestamp = strtotime($validity_date);
     $validity_date = date('Y-m-d', $timestamp);
     DB::table('itsojt_formal_ojt_course_status')->where('id', $id)->update(array('instructor' => Input::get('instructor'), 'supervisor' => Input::get('supervisor'), 'manager' => Input::get('manager'), 'start_date' => $start_date, 'completion_date' => $completion_date, 'validity_date' => $validity_date, 'certificate' => $certificate, 'completion_status' => Input::get('completion_status'), 'notes' => Input::get('notes'), 'row_updator' => Auth::user()->getName(), 'updated_at' => date('Y-m-d H:i:s')));
     return Redirect::to(URL::previous() . "#{$pageId}");
 }

 public function updateFinding()
 {
     $id = Input::get('id');
     $target_date = Input::get('date') . ' ' . Input::get('month') . ' ' . Input::get('year');
     $strtotime = strtotime($target_date);
     $target_date = date('Y-m-d', $strtotime);
     $upload_file = parent::updateFileUpload('upload_file_old', 'upload_file', 'sia_finding');
     DB::table('sia_findings')->where('id', $id)->update(array('sia_number' => Input::get('sia_number'), 'title' => Input::get('title'), 'finding' => Input::get('finding'), 'target_date' => $target_date, 'corrective_action_plan' => Input::get('corrective_action_plan'), 'upload_file' => $upload_file, 'row_updator' => Auth::User()->getName(), 'updated_at' => date('Y-m-d H:i:s')));
     return Redirect::back()->with('message', 'Finding Updated!');
     //return Redirect::to(URL::previous() . "#Findings")->with('message', 'Finding Updated!');
 }