1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / projects_ilium / application / controllers /
Filename : Company.php
back
<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Company extends CI_Controller
{
	public function __construct(){
        parent::__construct();
        $this->load->model('set_leave_category_model');
        $this->load->model('set_salary_earninings_model');
        $this->load->model('set_salary_deductions_model');
		$this->load->model('set_tax_category_model');
        $this->load->model('set_department_category_model');
		$this->load->model('set_unit_category_model');
		$this->load->model('set_payment_terms_model');
		$this->load->model('Set_incoterms_model');
		$this->load->model('Set_transport_model');
		$this->load->model('Set_currency_model');
        $this->load->model('set_designation_category_model');
        $this->load->model('set_shift_timing_model');
		$this->load->model('set_vat_model');
		$this->load->model('set_company_model');
		$this->load->model('set_financialyear_model');
		$this->load->model('set_leave_status_model');
		
		$isSessionAlive = $this->session->userdata('is_logged_in');
		if(!$isSessionAlive || $isSessionAlive==NULL){
			redirect('login');
		}
    }
	    
	public function index()
	{
		
		
	}

	public function setting(){
		$data['setting'] = 'menu';

		$data['content'] = "web/setting/setting";

		$this->load->view('web/template', $data);
	}

	public function tax_master_form(){
		$data['tax_master_form'] = 'menu';

		$data['content'] = "web/taxmaster/tax_master_form";

		$this->load->view('web/template', $data);
	}
	
	public function leave_category(){
		validation_privilege('leave_category','view');
		
		$data['options'] 				= validation_option('leave_category');
		//$data['get_year'] 	= $this->db->select('*')->where('status','0')->where('deleted',0)->get('financialyear')->result();
		//echo"<pre>";print_r($data['get_year']);exit;
		$data['leave_category'] 	    = 'menu';
		$data['content'] 				= "web/company/leave_category";
		$this->load->view('web/template', $data);
	}

	
	//Attendance Master - Leave Category
	public function submit_leave_category(){
		$row_id	 = $this->input->post('category_row_id');
		$data_arr = array(
			'category_year_id' 	=> $this->input->post('category_year_id'),
			'category_name' 	=> $this->input->post('category_name'),
			'category_value' 	=> $this->input->post('category_value'),
			'category_status' 	=> $this->input->post('category_status'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$data_arr['company_id'] = $this->session->userdata('user_company_id');
			
			$this->common_model->insert('tbl_attendance_leave_category',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Leave Category Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			
			$where = "id='".$row_id."'";
			$this->common_model->update('tbl_attendance_leave_category',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Leave Category Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_leave_category(){
		$data = $row = array();
		$memData 	= $this->set_leave_category_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			$action .= '<div class="btn-group" role="group">';
				$action .= '<div class="btn-group" role="group">';
					$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
					$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
						$action .= '<a class="dropdown-item editleave_data" href="javascript:void(0)" data-id="'.$member->id.'" data-year="'.$member->category_year_id.'" data-name="'.$member->category_name.'" data-value="'.$member->category_value.'" data-status="'.$member->category_status.'">Edit</a>';
						$action .= '<a class="dropdown-item leavedelete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
					$action .= '</div>';
				$action .= '</div>';
			$action .= '</div>';
			
			$category_status = ($member->category_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			$category_year	 = $member->startyear." - ".$member->endyear;
			
			$data[] = array($i, $category_year, $member->category_name, $member->category_value." Days", $category_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_leave_category_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_leave_category_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function delete_leave_category(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_attendance_leave_category',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Leave Category Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Leave Category Details',
			);
		}
		echo json_encode($output);
	}
	
	public function submit_leave_status(){
		$row_id	 = $this->input->post('leave_status_row_id');
		
		$data_arr = array(
			'leave_status_name' 	=> $this->input->post('leave_status_name'),
			'leave_status_type' 	=> $this->input->post('leave_status_type'),
			'leave_status_status' 	=> $this->input->post('leave_status_status'),
			'working_days' 	        => $this->input->post('working_days'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$data_arr['company_id'] = $this->session->userdata('user_company_id');
			
			$this->common_model->insert('tbl_attendance_leave_status',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Leave Status Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			
			$where = "id='".$row_id."'";
			$this->common_model->update('tbl_attendance_leave_status',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Leave Status Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_leave_status(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->set_leave_status_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			$action .= '<div class="btn-group" role="group">';
				$action .= '<div class="btn-group" role="group">';
					$action .= '<button id="btnStatusGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
					$action .= '<div class="dropdown-menu" aria-labelledby="btnStatusGroup'.$member->id.'">';
						$action .= '<a class="dropdown-item edit_leave_status_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->leave_status_name.'" data-type="'.$member->leave_status_type.'" data-status="'.$member->leave_status_status.'" data-working="'.$member->working_days.'">Edit</a>';
						$action .= '<a class="dropdown-item leavestatusdelete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
					$action .= '</div>';
				$action .= '</div>';
			$action .= '</div>';
			
			$leave_status_status = ($member->leave_status_status=='0')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			$leave_status_type	 = ($member->leave_status_type=="1")?"Paid":"Unpaid";
			
			$data[] = array($i, $member->leave_status_name, $leave_status_type, $leave_status_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_leave_status_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_leave_status_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function delete_leavestatus_data(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_attendance_leave_status',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Leave Status Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Leave Status Details',
			);
		}
		echo json_encode($output);
	}
	
	//Salary Master - Earninings
	public function salary_master(){
		validation_privilege('salary_master','view');
		
		$data['options'] 			= validation_option('salary_master');
		$data['tax_master_form'] 	= 'menu';
		$data['content'] 			= "web/setting/salary_master";
		$this->load->view('web/template', $data);
	}
	
	public function submit_salary_earninings(){
		$row_id	 = $this->input->post('earninings_row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
		    'company_id'            => $company_id,
			'earninings_name' 		=> $this->input->post('earninings_name'),
			'earninings_percent' 	=> $this->input->post('earninings_percent'),
			'earninings_status' 	=> $this->input->post('earninings_status'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_salary_earninings',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Earninings Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_salary_earninings',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Earninings Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_salary_earninings(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->set_salary_earninings_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('salary_master');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_earninings_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->earninings_name.'" data-percent="'.$member->earninings_percent.'" data-status="'.$member->earninings_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_earninings_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$earninings_status = ($member->earninings_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->earninings_name, $member->earninings_percent, $earninings_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_salary_earninings_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_salary_earninings_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function delete_salary_earninings(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_salary_earninings',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Earninings Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Earninings Details',
			);
		}
		echo json_encode($output);
	}
	
	//Salary Master - Deduction
	public function submit_salary_deductions(){
		$row_id	 = $this->input->post('deductions_row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
		    'company_id'            => $company_id,
			'deductions_name' 		=> $this->input->post('deductions_name'),
			'deductions_percent' 	=> $this->input->post('deductions_percent'),
			'deductions_status' 	=> $this->input->post('deductions_status'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_salary_deductions',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Deductions Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_salary_deductions',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Deductions Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_salary_deductions(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->set_salary_deductions_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('salary_master');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_deductions_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->deductions_name.'" data-percent="'.$member->deductions_percent.'" data-status="'.$member->deductions_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_deductions_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$deductions_status = ($member->deductions_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->deductions_name, $member->deductions_percent, $deductions_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_salary_deductions_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_salary_deductions_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function delete_salary_deductions(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_salary_deductions',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Deductions Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Deductions Details',
			);
		}
		echo json_encode($output);
	}
	
	public function designation_master(){
		validation_privilege('designation_master','view');
		
		$data['options'] 				= validation_option('designation_master');
		$data['designation_master'] 	= 'menu';
		$data['content'] 				= "web/company/designation_master";
		$this->load->view('web/template', $data);
	}
	
	public function submit_designation_category()
	{
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
		    'company_id'            => $company_id,
			'designation_name' 		=> $this->input->post('designation_name'),
			'designation_status' 	=> $this->input->post('designation_status'),
		);

		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_desigantion_category',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Designation Category Added Successfully',
				);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_desigantion_category',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Designation Category Updated Successfully',
			);
		}
		echo json_encode($output);
	}

	public function list_designation_category(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
		$_POST['company_id'] = $company_id;
		$memData 	= $this->set_designation_category_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('designation_master');
	
		foreach($memData as $member){
			$i++;

			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->designation_name.'" data-status="'.$member->designation_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$designation_status = ($member->designation_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->designation_name,$designation_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_designation_category_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_designation_category_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function delete_designation_category(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_desigantion_category',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Designation  Category Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Designation Category Details',
			);
		}
		echo json_encode($output);
	}
	
	public function department_master(){
		validation_privilege('department_master','view');
		
		$data['options'] 			= validation_option('department_master');
		$data['department_master'] 	= 'menu';
		$data['content'] 			= "web/company/department_master";
		$this->load->view('web/template', $data);
	}
	
	public function submit_department_category(){
		
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
		    'company_id'        => $company_id,
			'department_name' 	=> $this->input->post('department_name'),
			'department_status' => $this->input->post('department_status'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			
			$this->common_model->insert('tbl_department_category',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Department Category Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			
			$where = "id='$row_id'";
			$this->common_model->update('tbl_department_category',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Department Category Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	
	public function list_department_category(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
		$_POST['company_id'] = $company_id;
		$memData 	= $this->set_department_category_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('department_master');

		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->department_name.'" data-status="'.$member->department_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$department_status = ($member->department_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->department_name, $department_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_department_category_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_department_category_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}

	public function delete_department_category(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_department_category',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Leave Category Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Leave Category Details',
			);
		}
		echo json_encode($output);
	}
	
	
	public function shift_timing_master(){
		validation_privilege('shift_timing_master','view');
		
		$data['options'] 				= validation_option('shift_timing_master');
		$data['shift_timing_master'] 	= 'menu';
		$data['content'] 				= "web/setting/shift_timing_master";
		$this->load->view('web/template', $data);
	}
	
	public function submit_shift_timing_category(){
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
		    'company_id'        => $company_id,
			'shift_name' 	=> $this->input->post('shift_name'),
			'shift_in_time' 	=> $this->input->post('shift_in_time'),
			'shift_out_time' 	=> $this->input->post('shift_out_time'),
			'shift_status' => $this->input->post('shift_status'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_shift_timing_master',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Shift Timing Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_shift_timing_master',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Shift Timing Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_shift_timing_category(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->set_shift_timing_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('shift_timing_master');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->shift_name.'" data-in="'.$member->shift_in_time.'" data-out="'.$member->shift_out_time.'" data-status="'.$member->shift_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$shift_status = ($member->shift_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->shift_name,$member->shift_in_time,$member->shift_out_time, $shift_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_shift_timing_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_shift_timing_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}

	public function delete_shift_timing_category(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_shift_timing_master',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Shift Timing Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete Shift timing Details',
			);
		}
		echo json_encode($output);
	}

	public function vat_master(){
		validation_privilege('vat_master','view');
		
		$data['options'] 	= validation_option('vat_master');
		$data['vat_master'] = 'menu';
		$data['content'] 	= "web/vatmaster/vat_master";
		$this->load->view('web/template', $data);
	}
	
	public function submit_vat(){
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
		    'company_id'    => $company_id,
			'vat_code' 	    => $this->input->post('vat_code'),
			'percentage' 	=> $this->input->post('percentage'),
			'description' 	=> $this->input->post('description'),
			'vat_status'    => $this->input->post('vat_status'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_vat_master',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'VAT Category Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_vat_master',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'VAT Category Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function list_vat(){
		
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->set_vat_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('vat_master');
		
		foreach($memData as $member){
			$i++;

			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';	
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-code="'.$member->vat_code.'" data-percent="'.$member->percentage.'" data-descrip="'.$member->description.'" data-status="'.$member->vat_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$vat_status = ($member->vat_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->vat_code,$member->description,$member->percentage, $vat_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_vat_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_vat_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}

	public function delete_vat(){
		
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_vat_master',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'VAT Category Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Leave Category Details',
			);
		}
		echo json_encode($output);
	}
	
	// Financial Year
	public function financial_year_master(){
		validation_privilege('financial_year_master','view');
		
		$data['options'] 			= validation_option('financial_year_master');
		$data['financialyear']      = 'menu';
		$data['content']            = "web/company/financialyear";
		$this->load->view('web/template',$data);
	}
	
	public function list_financialyear(){
		$data       = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->set_financialyear_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('financial_year_master');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->yearid.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->yearid.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-yearid="'.$member->yearid.'" data-startyear="'.$member->startyear.'" data-endyear="'.$member->endyear.'" data-status="'.$member->status.'" data-startdate="'.date("d-m-Y",strtotime($member->startdate)).'" data-enddate="'.date("d-m-Y",strtotime($member->enddate)).'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-yearid="'.$member->yearid.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$data[] = array($i, $member->startyear, $member->endyear, $member->startdate, $member->enddate, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_financialyear_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_financialyear_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function submit_financial_year(){
		$this->form_validation->set_rules('financial_year_start_date', 'financial_year_start_date', 'trim|required');
        $this->form_validation->set_rules('financial_year_end_date', 'financial_year_end_date', 'trim|required');

        if ($this->form_validation->run() == FALSE){			
			validation_privilege('financial_year_master','view');
		
			$data['options'] 			= validation_option('financial_year_master');
			$data['financialyear']      = 'menu';
			$data['content']            = "web/company/financialyear";
			$company_id                 = get_customercompanyid();		
			$this->load->view('web/template',$data);
		}else{
			$data_arr['startyear'] 	= date("Y",strtotime(trim(strip_tags($this->input->post('financial_year_start_date')))));
			$data_arr['endyear'] 	= date("Y",strtotime(trim(strip_tags($this->input->post('financial_year_end_date')))));
			$data_arr['status'] 	= $this->input->post('financial_year_status');
			
			//$data_arr['status'] = 0;
			$yearid = trim(strip_tags($this->input->post('financial_year_row_id')));
			$exists = $this->common_model->get_record("financialyear","*",$data_arr);
				
			$data_arr['startdate'] = date("Y-m-d",strtotime(trim(strip_tags($this->input->post('financial_year_start_date')))));
			$data_arr['enddate'] = date("Y-m-d",strtotime(trim(strip_tags($this->input->post('financial_year_end_date')))));
		
		
			if(empty($exists) && !$yearid){
				$data_arr['company_id'] = $this->session->userdata('user_company_id');
				$data_arr['created_at'] = date('Y-m-d h:i:s');
				$data_arr['created_by'] = $this->session->userdata('user_id');
				
				$this->common_model->insert('financialyear',$data_arr);
				$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Financial Year Created Successfuly',
				);
			}elseif(!empty($exists) && $yearid){
				$data_arr['updated_at'] = date('Y-m-d h:i:s');
				$data_arr['updated_by'] = $this->session->userdata('user_id');
				
				$where['yearid'] = $yearid;
				$this->common_model->update('financialyear',$data_arr,$where);
				$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Financial Year Updated Successfuly',
				);
			}elseif(empty($exists) && $yearid){
				$where['yearid'] = $yearid;
				$this->common_model->update('financialyear',$data_arr,$where);
				$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Financial Year Updated Successfuly',
				);
			}else{
				$output = array(
					'status'	=> 'Error',
					'msg'		=> 'Financial Year already Exists',
				);
			}
		}
		echo json_encode($output);
	}
	
	public function delete_financialyear(){
		$yearid = $this->input->post('keys');
		
		$data_arr['status']     = 2;
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "yearid='$yearid'";
		$result = $this->common_model->update('financialyear',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Financial Year Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Financial Year Details',
			);
		}
		echo json_encode($output);
	}
	
	public function get_financial_year(){
		$where = array(
			"company_id" => $this->session->userdata('user_company_id'),
			"deleted"	 => '0',
		);
		$lists = list_financial_years_details("select",$where,"startyear","ASC");
		echo $lists;
	}
	
	public function get_yeardetails(){
		
		$values['yearid'] = trim(strip_tags($this->input->post('yearid')));			
		$exists = $this->common_model->get_record("financialyear","*",$values);
		$exists->startdate = date("d-m-Y",strtotime($exists->startdate));
		$exists->enddate = date("d-m-Y",strtotime($exists->enddate));
		echo json_encode($exists);
	}
	
	public function yearstatus($id){
		if($id){
			$changestatus = $this->common_model->get_record("financialyear","*",array("status != "=>2,'yearid'=>$id));
			if(count($changestatus)){
				$where['yearid'] = $id;
				if($changestatus->status == 0){
					$values['status'] = 1;
				}else{
					$values['status'] = 0;
				}
				
				$values['modifiedTime'] = date("Y-m-d H:i:s");
				$this->common_model->update_record("financialyear",$values,$where);
				$this->session->set_flashdata("financial_created","Financial Year Status Changed Successfuly");
			}
			redirect("company/financialyear");
		}else{
			redirect("company/financialyear");
		}
	}
	
	
	//Financial Year Master

	public function unit_master(){
		validation_privilege('unit_master','view');
		
		$data['options'] 		= validation_option('unit_master');
		$data['unit_master'] 	= 'menu';
		$data['content'] 		= "web/company/unit_master";
		$this->load->view('web/template', $data);
	}
	
	public function submit_unit_category(){
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
		    'company_id'    => $company_id,
			'unit_name' 	=> $this->input->post('unit_name'),
			'unit_status'   => $this->input->post('unit_status'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_unit_category',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Unit Category Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_unit_category',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Unit Category Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_unit_category(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_unit_category',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Unit Category Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unit to Delete the Leave Category Details',
			);
		}
		echo json_encode($output);
	}
	
	public function list_unit_category(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->set_unit_category_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('unit_master');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->unit_name.'" data-status="'.$member->unit_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$unit_status = ($member->unit_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->unit_name, $unit_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_unit_category_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_unit_category_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function payment_terms(){
		validation_privilege('payment_terms','view');
		
		$data['options'] 		= validation_option('payment_terms');
		$data['payment_terms'] 	= 'menu';
		$data['content'] 		= "web/company/payment_terms";
		$this->load->view('web/template', $data);
	}
	
	public function submit_payment_terms(){
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
		    'company_id'        => $company_id,
			'payment_terms' 	=> $this->input->post('payment_terms'),
			'terms_status'      => $this->input->post('terms_status'),
		);
		if(empty($row_id)){
			$data_arr['company_id'] = $this->session->userdata('user_company_id');
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_payment_terms',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Payment Terms Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_payment_terms',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Payment Terms Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_payment_terms(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_payment_terms',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Payment Terms Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Payment Terms to Delete the Leave Category Details',
			);
		}
		echo json_encode($output);
	}
	
	public function list_payment_terms(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->set_payment_terms_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('payment_terms');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->payment_terms.'" data-status="'.$member->terms_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$terms_status = ($member->terms_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->payment_terms, $terms_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_payment_terms_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_payment_terms_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function Incoterms(){
		validation_privilege('Incoterms','view');
		
		$data['options'] 	= validation_option('Incoterms');
		$data['incoterms'] 	= 'menu';
		$data['content'] 	= "web/company/incoterms";
		$this->load->view('web/template', $data);
	}
	
	public function list_Incoterms(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->Set_incoterms_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('Incoterms');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->incoterms.'" data-status="'.$member->incoterms_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$incoterms_status = ($member->incoterms_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->incoterms, $incoterms_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->Set_incoterms_model->countAll($_POST),
			"recordsFiltered" 	=> $this->Set_incoterms_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function submit_Incoterms(){
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
			'company_id'    => $company_id,
			'incoterms' 	=> $this->input->post('incoterms'),
			'incoterms_status' => $this->input->post('incoterms_status'),
		);
		if(empty($row_id)){
			$data_arr['company_id'] = $this->session->userdata('user_company_id');
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_incoterms',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Incoterms Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_incoterms',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Incoterms Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_Incoterms(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_incoterms',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Incoterms Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Incoterms Delete the Details',
			);
		}
		echo json_encode($output);
	}
	
	public function transport(){
		validation_privilege('transport','view');
		
		$data['options'] 	= validation_option('transport');
		$data['transport'] 	= 'menu';
		$data['content'] 	= "web/company/transport";
		$this->load->view('web/template', $data);
	}
	
	public function list_transport(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->Set_transport_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('transport');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-name="'.$member->transport_name.'" data-status="'.$member->transport_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$transport_status = ($member->transport_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->transport_name, $transport_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->Set_transport_model->countAll($_POST),
			"recordsFiltered" 	=> $this->Set_transport_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function submit_transport(){
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
			'company_id'    => $company_id,
			'transport_name' 	=> $this->input->post('transport_name'),
			'transport_status' => $this->input->post('transport_status'),
		);
		if(empty($row_id)){
			$data_arr['company_id'] = $this->session->userdata('user_company_id');
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_transport',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Transport Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_transport',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Transport Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_transport(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_transport',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Transport Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Transport Delete the Details',
			);
		}
		echo json_encode($output);
	}
	
	// Currency 
	public function currency(){
		validation_privilege('currency','view');
		
		$data['options'] 	= validation_option('currency');
		$data['currency'] 	= 'menu';
		$data['content'] 	= "web/company/currency";
		$this->load->view('web/template', $data);
	}
	
	public function list_currency(){
		$data = $row = array();
		$company_id  = get_customercompanyid();
        $_POST['company_id'] = $company_id;
		$memData 	= $this->Set_currency_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('currency');
		
		foreach($memData as $member){
			$i++;
			
			$action = '';
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->id.'">';	
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_data" href="javascript:void(0)" data-id="'.$member->id.'" data-country="'.$member->country.'" data-currencies_name="'.$member->currencies_name.'" data-exchange_rate="'.$member->exchange_rate.'" data-exchange_bahraini="'.$member->exchange_bahraini.'" data-bahraini_dinar="'.$member->bahraini_dinar.'" data-status="'.$member->currency_status.'">Edit</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_data" href="javascript:void(0)" data-id="'.$member->id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			$currency_status = ($member->currency_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->country,$member->currencies_name,$member->exchange_rate,$member->exchange_bahraini,$member->bahraini_dinar, $currency_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->Set_currency_model->countAll($_POST),
			"recordsFiltered" 	=> $this->Set_currency_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	public function submit_currency(){
		$row_id	 = $this->input->post('row_id');
		$company_id  = get_customercompanyid();
		$data_arr = array(
			'company_id'    => $company_id,
			'country' 	=> $this->input->post('country'),
			'currencies_name' 	=> $this->input->post('currencies_name'),
			'exchange_rate' => $this->input->post('exchange_rate'),
			'exchange_bahraini' => $this->input->post('exchange_bahraini'),
			'bahraini_dinar' 	=> $this->input->post('bahraini_dinar'),
			'currency_status' => $this->input->post('currency_status'),
		);
		if(empty($row_id)){
			$data_arr['company_id'] = $this->session->userdata('user_company_id');
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			$data_arr['created_by'] = $this->session->userdata('user_id');
			$this->common_model->insert('tbl_currency',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Currency Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			$data_arr['updated_by'] = $this->session->userdata('user_id');
			$where = "id='$row_id'";
			$this->common_model->update('tbl_currency',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Currency Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_currency(){
		$row_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where = "id='$row_id'";
		$result = $this->common_model->update('tbl_currency',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Currency Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Currency Delete the Details',
			);
		}
		echo json_encode($output);
	}
	
	// Tax
	public function tax_master()
	{
		$data['unit_master'] = 'menu';
		$data['content'] = "web/company/tax_master";
		$this->load->view('web/template', $data);
	}
	
	public function submit_tax_category(){
		$row_id	 = $this->input->post('row_id');
		
		$data_arr = array(
			'tax_name' 	=> $this->input->post('tax_name'),
			'tax_status' => $this->input->post('tax_status'),
		);
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			
			$this->common_model->insert('tbl_tax_category',$data_arr);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Tax Category Added Successfully',
			);
		}else{
			$data_arr['updated_at'] = date('Y-m-d h:i:s');
			
			$where = "id='$row_id'";
			$this->common_model->update('tbl_tax_category',$data_arr,$where);
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Tax Category Updated Successfully',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_tax_category(){
		$row_id = $this->input->post('keys');
		
		$where = "id='$row_id'";
		$result = $this->common_model->delete('tbl_tax_category',$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Tax Category Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Tax to Delete the Leave Category Details',
			);
		}
		echo json_encode($output);
	}
	
	public function list_tax_category(){
		$data = $row = array();
		$memData 	= $this->set_tax_category_model->getRows($_POST);
		$i 			= $_POST['start'];
		
		foreach($memData as $member){
			$i++;
			
			$action=	"<button type='button' class='btn btn-info btn-sm edit_data' data-id='".$member->id."' data-name='".$member->tax_name."' data-status='".$member->tax_status."'><i class='fa fa-edit'></i></button>&nbsp;&nbsp;";
			$action.=	"<button type='button' class='btn btn-danger btn-sm delete_data' data-id='".$member->id."'><i class='fa fa-trash'></i></button>";
			
			$tax_status = ($member->tax_status=='Active')?'<span class="badge badge-success">Active</span>':'<span class="badge badge-danger">Inactive</span>';
			
			$data[] = array($i, $member->tax_name, $tax_status, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_tax_category_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_tax_category_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	
	
	// Company Module
	public function company_list(){
		validation_privilege('company_list','view');
		
		$data['options'] 	= validation_option('company_list');
		$data['transport'] 	= 'menu';
		$data['content'] 	= "web/company/company_list";
		$this->load->view('web/template', $data);
	}
	
	public function list_company(){
		$data = $row = array();
		$memData 	= $this->set_company_model->getRows($_POST);
		$i 			= $_POST['start'];
		$options 	= validation_option('company_list');
		
		foreach($memData as $member){
			$i++;
			
			$link   = base_url(). COMPANY_LOGO .'/'.$member->logo;
			$action = '';
			
			if(($options->user_menu_add_edit==1) || ($options->user_menu_delete==1) || ($options->user_menu_download==1)){
				$action .= '<div class="btn-group" role="group">';
					$action .= '<div class="btn-group" role="group">';
						$action .= '<button id="btnGroup'.$member->company_id.'" type="button" class="btn btn-secondary btn-sm dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>';
						$action .= '<div class="dropdown-menu" aria-labelledby="btnGroup'.$member->company_id.'">';
							if($options->user_menu_add_edit==1){
								$action .= '<a class="dropdown-item edit_company" href="javascript:void(0)" data-company_id="'.$member->company_id.'">Edit</a>';
							}
							if($options->user_menu_download==1){
								$action .= '<a class="dropdown-item" href="'.$link.'" download="'.$link.'">Download</a>';
							}
							if($options->user_menu_delete==1){
								$action .= '<a class="dropdown-item delete_company" href="javascript:void(0)" data-company_id="'.$member->company_id.'">Delete</a>';
							}
						$action .= '</div>';
					$action .= '</div>';
				$action .= '</div>';
			}else{
				$action = "<p class='text-center'>-</p>";
			}
			
			
			$data[] = array($i, '<img src="' . $link . '" width="50" height="50">', $member->name, $member->email, $member->contact, $member->website, $member->currencyused, $member->vat, $action);
		}
		$output = array(
			"draw" 				=> $_POST['draw'],
			"recordsTotal" 		=> $this->set_company_model->countAll($_POST),
			"recordsFiltered" 	=> $this->set_company_model->countFiltered($_POST),
			"data" 				=> $data,
		);
		echo json_encode($output);
	}
	
	
	public function submit_company(){
		
		$company_id	 = $this->input->post('company_id');
		
		$data_arr = array(
			'name' 	=> $this->input->post('name'),
			'email' => $this->input->post('email'),
			'landline' => $this->input->post('landline'),
			'contact' => $this->input->post('contact'),
			'vat_percentage' => $this->input->post('vat_percentage'),
			'locality' => $this->input->post('locality'),
			'pincode' => $this->input->post('pincode'),
			'website' => $this->input->post('website'),
			'currency' => $this->input->post('currency'),
			'address' => $this->input->post('address'),
		);
		
		  $test_con = 0;
			$logo = "";
			if(isset($_FILES["logo"]["name"]) && !empty($_FILES["logo"]["name"])){
				$extension 	= pathinfo($_FILES["logo"]["name"], PATHINFO_EXTENSION);
				$filename 	= pathinfo($_FILES['logo']['name'], PATHINFO_FILENAME);
				
				$config['upload_path']    = COMPANY_LOGO;
				$config['allowed_types']  = 'jpg|jpeg|png|webp|JPG|JPEG|PNG|WEBP';
				$config['file_name']      = $filename.rand() . '_' . date('YmdHis') . "." . $extension;	
				$this->load->library('upload', $config);
				if(!$this->upload->do_upload('logo')){
					$test_con   = 1;
					$error      = $this->upload->display_errors();
				}else{
					$test_con   = 0;
					$data       = array('upload_data' => $this->upload->data());
					$data_arr['logo']   = $data['upload_data']['file_name'];
				}
			}
		
		if($test_con==0){
			if(empty($company_id)){
				$data_arr['created_at'] = date('Y-m-d h:i:s');
				$data_arr['created_by'] = $this->session->userdata('user_id');
				
				$this->common_model->insert('company',$data_arr);
				$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Company Added Successfully',
				);
			}else{
				$data_arr['updated_at'] = date('Y-m-d h:i:s');
				$data_arr['updated_by'] = $this->session->userdata('user_id');
				$where = "company_id='$company_id'";
				$this->common_model->update('company',$data_arr,$where);
				$output = array(
					'status'	=> 'Success',
					'msg'		=> 'Company Updated Successfully',
				);
			}
		}else{
			$output = array(
				'status'	=> 'Error',
				'msg'		=> $error,
			);
		}
		echo json_encode($output);
	}
	
	
	public function edit_company(){
		
		$company_id 	= $this->input->post('keys');
		$details 	= $this->db->select('*')->where('company_id',$company_id)->get('company')->row_array();
		if(!empty($details)){
			if(!empty($details['name'])){
				$details['name'] = $details['name'];
			}
			if(!empty($details['email'])){
				$details['email'] = $details['email'];
			}
			if(!empty($details['contact'])){
				$details['contact'] = $details['contact'];
			}
			if(!empty($details['landline'])){
				$details['landline'] = $details['landline'];
			}
			if(!empty($details['vat_percentage'])){
				$details['vat_percentage'] = $details['vat_percentage'];
			}
			if(!empty($details['locality'])){
				$details['locality'] = $details['locality'];
			}
			if(!empty($details['pincode'])){
				$details['pincode'] = $details['pincode'];
			}
			if(!empty($details['website'])){
				$details['website'] = $details['website'];
			}
			if(!empty($details['currency'])){
				$details['currency'] = $details['currency'];
			}
			if(!empty($details['address'])){
				$details['address'] = $details['address'];
			}
			if(!empty($details['logo'])){
				$link = base_url().COMPANY_LOGO.'/'.$details['logo'];
				$details['logo'] = '<a href="'.$link.'" download="'.$link.'"><i class="fa fa-download"></i> Download</a>';
			}
			
			$output = array(
				'status'	=> 'Success',
				'details'	=> $details,
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'info'		=> 'Invaild Records !!!',
			);
		}
		echo json_encode($output);
	}
	
	public function delete_company(){
		$company_id = $this->input->post('keys');
		
		$data_arr['deleted'] 	= 1;
		$data_arr['deleted_at'] = date('Y-m-d h:i:s');
		$data_arr['deleted_by'] = $this->session->userdata('user_id');
		
		$where  = "company_id='".$company_id."'";
		$result = $this->common_model->update('company',$data_arr,$where);
		
		if($result==true){
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Company Details Deleted Successfully',
			);
		}else{
			$output = array(
				'status'	=> 'Warning',
				'msg'		=> 'Unable to Delete the Company Details',
			);
		}
		echo json_encode($output);
	}

}