Employee.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Employee extends MY_Controller {

	public function index(){
		$data['employee_type'] = getrow('tbl_employee_type');
		$this->load_page('index',$data);
	}

	public function employee_list($tbl_type=""){
		$limit = $this->input->post('length');
		$offset = $this->input->post('start');
		$search = $this->input->post('search');
		$order = $this->input->post('order');
		$draw = $this->input->post('draw');
		if ($tbl_type == 1) {
			$column_order = array('profile_picture','first_name','middle_name','last_name','email_address','license_number','status');
		}else{
			$column_order = array('profile_picture','first_name','middle_name','last_name','status');
		}

		$join = array(
			'tbl_employee_type' => 'tbl_employee_type.id = tbl_employee.employee_type'
		);
		$select = "tbl_employee.employee_id,tbl_employee.first_name,profile_picture,tbl_employee.middle_name,tbl_employee.last_name,license_number,tbl_employee.email_address,tbl_employee.status,tbl_employee_type.employee_type";
		$where = array('tbl_employee.employee_type' => $tbl_type);
		$group = array();
		$list = datatables('tbl_employee',$column_order, $select, $where, $join, $limit, $offset ,$search, $order, $group);
		$output = array(
				"draw" => $draw,
				"recordsTotal" => $list['count_all'],
				"recordsFiltered" => $list['count'],
				"data" => $list['data']
		);
		echo json_encode($output);
	}

	public function submitEmployee(){
		$employee_type = post('employee_type');
		$first_name = post('first_name');
		$middle_name = post('middle_name');
		$last_name = post('last_name');
		$email_address = post('email_address');
		$contact_number = post('contact_number');
		$license = post('license_number');
		$address = post('address');
		$birthdate = post('birthdate');
		$gender = post('gender');
		$SSS = post('SSS');
		$TIN = post('TIN');
		$PhilHealth = post('PhilHealth');
		$data1 = post('imagebase64');

		list($type, $data1) = explode(';', $data1);
		list(, $data1)      = explode(',', $data1);
		$data5 = base64_decode($data1);
		$imgname = "image64".md5(rand()).".png";
		$test = file_put_contents("assets/images/profile_picture/$imgname", $data5);

		$data = array(
			'employee_type' => $employee_type,
			'first_name' => $first_name,
			'middle_name' => $middle_name,
			'last_name' => $last_name,
			'email_address' => $email_address,
			'contact_number' => $contact_number,
			'license_number' => $license,
			'address' => $address,
			'date_of_birth' => $birthdate,
			'gender' => $gender,
			'sss' => $SSS,
			'tin' => $TIN,
			'philhealth' => $PhilHealth,
			'profile_picture' => $imgname,
		);

		if(insert('tbl_employee',$data)){
			response('success','success','Successfully added new employee');
		} else {
			response('error','danger','Something went wrong');
		}
	}

	public function update_employee_status(){
		$employee_id = post('employee_id');
		$status = post('status');
		if(update('tbl_employee',array('status' => $status),array('employee_id' => $employee_id))){
			response('success','success','Successfully updated employee status');
		} else {
			response('error','danger','Something went wrong');
		}
	}

	public function update_employee_details(){
		$employee_type = post('view_employee_type');
		$first_name = post('view_first_name');
		$middle_name = post('view_middle_name');
		$last_name = post('view_last_name');
		$email_address = post('view_email_address');
		$contact_number = post('view_contact_number');
		$license = post('view_license_number');
		$address = post('view_address');
		$birthdate = post('view_birthdate');
		$gender = post('view_gender');
		$SSS = post('view_SSS');
		$TIN = post('view_TIN');
		$PhilHealth = post('view_PhilHealth');

		$data1 = post('view_imagebase64');
		$orig_photo = post('orig_photo');

		$data2 = post('view_license_img');
		$orig_photo2 = post('view_license_orig');

		if (file_exists($orig_photo)) {

		}else{
			unlink($orig_photo);
		}

		if (file_exists($orig_photo2)) {
 		    unlink($orig_photo2);
		}else{

		}

		list($type, $data1) = explode(';', $data1);
		list(, $data1)      = explode(',', $data1);
		$data5 = base64_decode($data1);
		$imgname = "image64".md5(rand()).".png";
		$test = file_put_contents("assets/images/profile_picture/$imgname", $data5);
		move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)

		$data = array(
			'employee_type' => $employee_type,
			'first_name' => $first_name,
			'middle_name' => $middle_name,
			'last_name' => $last_name,
			'email_address' => $email_address,
			'contact_number' => $contact_number,
			'license_number' => $license,
			'address' => $address,
			'date_of_birth' => $birthdate,
			'gender' => $gender,
			'sss' => $SSS,
			'tin' => $TIN,
			'philhealth' => $PhilHealth,
		);
		if(update('tbl_employee',$data,array('employee_id' => post('employee_id')))){
			response('success','success','Successfully updated employee');
		} else {
			response('error','warning','No changes made');
		}
	}

	public function get_employee_details(){
		$parameters['where'] = array('employee_id' => post('employee_id'));
		$parameters['join'] = array(
			'tbl_employee_type' => 'tbl_employee_type.id = tbl_employee.employee_type'
		);
		json(getrow('tbl_employee',$parameters,'row'));
	}
}