File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/employee/update_employee_profile.php

Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $return_arr["status"]=0; $return_arr["message"]=" No Action."; $employee_id = $_SESSION['user']['employee_id']; $utility = new Utility(); // echo $_FILES['upload_picture']['name']; return; if(isset( $_POST['contactno2'], $_POST['fax'], $_POST['business'], $_POST['residential'], $_POST['landline'], $_POST['email2'], $_POST['address'], $_POST['state'], $_POST['city'], $_POST['postal'], )){ //check if theres selected pcture //if exist reduce size and rename base on timestamp //else use default photo name // $post_previous_photo = $db -> escape(trim($_POST['original-photo'])); $post_contactno2 = $db -> escape(trim($_POST['contactno2'])); $post_fax = $db -> escape(trim($_POST['fax'])); $post_business = $db -> escape(trim($_POST['business'])); $post_residential = $db -> escape(trim($_POST['residential'])); $post_landline = $db -> escape(trim($_POST['landline'])); $post_email2 = $db -> escape(trim($_POST['email2'])); $post_address = $db -> escape(trim(strtoupper($_POST['address']))); $post_state = $db -> escape(trim($_POST['state'])); $post_city = $db -> escape(trim($_POST['city'])); $post_postal = $db -> escape(trim($_POST['postal'])); $post_department = (isset($_POST['department'])) ? $db -> escape(trim($_POST['department'])) : '0' ; $post_position = (isset($_POST['position'])) ? $db -> escape(trim($_POST['position'])) : '0' ; $post_company = $db -> escape(trim($_POST['company'])); $post_dealer = $db -> escape(trim($_POST['dealer'])); $post_gender_id = $db -> escape(trim($_POST['gender'])); $post_date_of_birth = $db -> escape(trim($_POST['birthday'])); if(isNotEmpty($_FILES['upload_picture']['name'])){ // Getting file name $filename = $_FILES['upload_picture']['name']; $maxsize = 6097152; if($_FILES['upload_picture']['size'] >= $maxsize \|\| $_FILES['upload_picture']['size'] == 0 ){ $return_arr["status"]=0; $return_arr["message"]=" Image file too large. Image must less than 2 megabytes."; echo json_encode($return_arr); return; } $quality = 60; if($_FILES['upload_picture']['size'] >= $maxsize/2){ $quality = 30; } // Valid extension $valid_ext = array('png','jpeg','jpg'); // file extension $file_extension = pathinfo($filename, PATHINFO_EXTENSION); $file_extension = strtolower($file_extension); $RandomAccountNumber = uniqid(); $post_picture = $RandomAccountNumber.'.'.$file_extension; // Location $location = "../../dist/img/".$post_picture; // Check extension if(in_array($file_extension,$valid_ext)){ // Compress Image compressImage($_FILES['upload_picture']['tmp_name'],$location,$quality); }else{ $return_arr["status"]=0; $return_arr["message"]=" Invalid file type."; } }else{ $post_picture = $_SESSION['user']['photo']; } $query_employee_contact_info = "UPDATE `employee_contact` SET `email_address_2`='$post_email2', `contact_number_2`='$post_contactno2', `fax`='$post_fax', `business`='$post_business', `residential`='$post_residential', `landline`='$post_landline', `address`='$post_address', `provCode`='$post_state ', `city_id`='$post_city', `postal`='$post_postal' WHERE employee_id = '$employee_id'"; $company_dealer_id = 0; $get_company_dealer_id_query = $db -> sql_query("SELECT id FROM `source_company_dealer` WHERE `company_id` = '$post_company' and `dealer_id` = '$post_dealer' and type= '1' LIMIT 1"); while($row1 = $get_company_dealer_id_query->fetch_assoc()) { $company_dealer_id = $row1['id']; } $query_personal_info = "UPDATE `employee` SET company_dealer_id = '$company_dealer_id', `department_id`='$post_department' , `position_id`='$post_position', gender_id = '$post_gender_id', date_of_birth = '$post_date_of_birth' WHERE employee_id = '$employee_id'"; $db -> sql_query($query_personal_info); $db -> sql_query($query_employee_contact_info); $db -> sql_query("UPDATE `employee` SET `photo`='$post_picture' WHERE `employee_id` = '$employee_id'"); //IF EMPLOYEE ID CHANGE, CHANGE ALSO ALL CONNECTED EMPLOYEE ID // $return_arr["photo"]= $post_picture; $_SESSION['user']['email_address_2'] = $post_email2; $_SESSION['user']['contact_number_2'] = $post_contactno2; $_SESSION['user']['fax'] = $post_fax; $_SESSION['user']['business'] = $post_business; $_SESSION['user']['residential'] = $post_residential; $_SESSION['user']['landline'] = $post_landline; $_SESSION['user']['address'] = $post_address; $_SESSION['user']['state_id'] = $post_state; $_SESSION['user']['city_id'] = $post_city; $_SESSION['user']['state'] = $db -> select("SELECT `provDesc` FROM `all_state` WHERE provCode = '$post_state' "); $_SESSION['user']['city'] = $db -> select("SELECT `citymunDesc` FROM `all_city` WHERE id = '$post_city' "); $_SESSION['user']['postal'] = $post_postal; $_SESSION['user']['photo'] = $post_picture; $_SESSION['user']['department'] = $post_department; $_SESSION['user']['position'] = $post_position; $_SESSION['user']['department_name'] = $db -> select("SELECT `department_name` FROM `employee_department` WHERE id = '$post_department' "); $_SESSION['user']['position_name']= $db -> select("SELECT `position_name` FROM `employee_position` WHERE id = '$post_position' "); $_SESSION['user']['company'] =$post_company; $_SESSION['user']['dealer'] =$post_dealer; $_SESSION['user']['company_name'] = $db -> select("SELECT `name` FROM `source_company` WHERE id = '$post_company' "); $_SESSION['user']['dealer_name'] = $db -> select("SELECT `name` FROM `source_dealer` WHERE id = '$post_dealer' "); $_SESSION['user']['company_code'] = $db -> select("SELECT `code` FROM `source_company` WHERE id = '$post_company' "); $_SESSION['user']['dealer_code'] = $db -> select("SELECT `code` FROM `source_dealer` WHERE id = '$post_dealer' "); $_SESSION['user']['gender_name'] = $db -> select("SELECT `gender_name` FROM `all_gender` WHERE id = '$post_gender_id' "); $_SESSION['user']['gender_id'] = $post_gender_id; $_SESSION['user']['date_of_birth'] = $post_date_of_birth; if(isNotEmpty($_FILES['upload_picture']['name'])){ $utility->make_thumb('../../dist/img/'.$post_picture, '../../dist/img/thumbnail/'.$post_picture, 150); } $return_arr["status"]=1; $return_arr["company_code"]=$_SESSION['user']['company_code']; $return_arr["dealer_code"]=$_SESSION['user']['dealer_code']; $return_arr["gender"]=$_SESSION['user']['gender_name']; $return_arr["dob"]= $_SESSION['user']['date_of_birth']; $return_arr["message"]=" Account successfully updated."; }else{ $return_arr["status"]=0; $return_arr["message"]=" Invalid Request. Please try again."; } // Compress image function compressImage($source, $destination, $quality) { $info = getimagesize($source); if ($info['mime'] == 'image/jpeg') $image = imagecreatefromjpeg($source); elseif ($info['mime'] == 'image/jpg') $image = imagecreatefromgif($source); elseif ($info['mime'] == 'image/png') $image = imagecreatefrompng($source); imagejpeg($image, $destination, $quality); } function isNotEmpty($data){ return preg_match('/\S/', $data); } echo json_encode($return_arr); ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.05 | proxy | phpinfo | Settings