<?php 
class Login{
    function save($type,$where_data,$remember,$utility,$db){
		
       $query_all_info = "SELECT e.id, e.asa_id,e.`employee_id`, e.`first_name`, e.`middle_name`, e.`last_name`, concat(e.`first_name`, ' ', e.`last_name`) AS full_name, ext.suffix_name ,e.`date_of_birth`, ag.gender_name,ag.id AS gender_id, e.`photo`,  DATE_FORMAT(e.date_registered, '%M %d, %Y - %h:%i:%s %p') as date_registered, ea.username,ea.employee_role_id ,ec.email_address,ec.email_address_2,ec.contact_number,ec.contact_number_2,ec.fax,ec.business,ec.residential,ec.landline,ec.address,st.provDesc,st.provCode as state_id,ac.citymunDesc,ac.id as city_id,ec.postal,ed.department_name,ed.id as department, ep.position_name,ep.id as position, sc.code as company_code,sc.name as company_name,sd.code as dealer_code,sd.name as dealer_name,sd.id as dealer,sc.id as company  FROM `employee` e
			INNER JOIN employee_account ea 
			ON e.employee_id = ea.employee_id  
			INNER JOIN employee_contact ec
			ON e.employee_id = ec.employee_id
			INNER JOIN all_suffix ext 
			ON e.suffix_id = ext.id
			INNER JOIN all_gender ag 
			ON e.gender_id = ag.id
			INNER JOIN source_company_dealer  cdi
			ON e.company_dealer_id = cdi.id
            INNER JOIN source_company sc
            ON cdi.company_id = sc.id
            INNER JOIN source_dealer sd
            ON cdi.dealer_id = sd.id
			INNER JOIN employee_department ed
			ON e.department_id = ed.id
			INNER JOIN employee_position ep 
			ON e.position_id = ep.id
			LEFT OUTER JOIN all_state st
			on ec.provCode  = st.provCode
			LEFT OUTER JOIN all_city ac
			ON ec.city_id=ac.id where 1 $where_data ";
			// echo $query_all_info;exit();
			$employee_info = $db -> return_result($query_all_info);
			foreach($employee_info as $data){
				$_SESSION['user'] = $data;
				// $_SESSION['user']['id'] = $data['id'];
				// $_SESSION['user']['asa_id'] = $data['asa_id'];
				// $_SESSION['user']['employee_id']  =  $data['employee_id'];
				// $_SESSION['user']['first_name']  =  $data['first_name'];
				// $_SESSION['user']['middle_name']  =  $data['middle_name'];
				// $_SESSION['user']['last_name']  =  $data['last_name'];
				// $_SESSION['user']['suffix_name']  =  $data['suffix_name'];
				// $_SESSION['user']['date_of_birth']  =  $data['date_of_birth'];
				// $_SESSION['user']['gender_name']  =  $data['gender_name'];
				// $_SESSION['user']['gender_id']  =  $data['gender_id'];
				// $_SESSION['user']['photo']  =  $data['photo'];
				// $_SESSION['user']['date_registered']  =  $data['date_registered'];
				// $_SESSION['user']['username']  =  $data['username'];
				// $_SESSION['user']['employee_role_id']  =  $data['employee_role_id'];
				// $_SESSION['user']['email_address']  =  $data['email_address'];
				// $_SESSION['user']['email_address_2']  =  $data['email_address_2'];
				// $_SESSION['user']['contact_number']  =  $data['contact_number'];
				// $_SESSION['user']['contact_number_2']  =  $data['contact_number_2'];
				// $_SESSION['user']['fax']  =  $data['fax'];
				// $_SESSION['user']['business']  =  $data['business'];
				// $_SESSION['user']['residential']  =  $data['residential'];
				// $_SESSION['user']['landline']  =  $data['landline'];
				// $_SESSION['user']['address']  =  $data['address'];
				// $_SESSION['user']['state_id']  = $data['state_id'];
				// $_SESSION['user']['city_id']  =  $data['city_id'];
				// $_SESSION['user']['postal']  =  $data['postal'];
				// $_SESSION['user']['department_name']  =  $data['department_name'];
				// $_SESSION['user']['department']  =  $data['department'];
				// $_SESSION['user']['position']  =  $data['position'];
				// $_SESSION['user']['position_name']  =  $data['position_name'];
				// $_SESSION['user']['company_name']  =  $data['company_name'];
				// $_SESSION['user']['dealer_name']  =  $data['dealer_name'];
				// $_SESSION['user']['company_code']  =  $data['company_code'];
				// $_SESSION['user']['dealer_code']  =  $data['dealer_code'];
				// $_SESSION['user']['company']  =  $data['company'];
				// $_SESSION['user']['dealer']  =  $data['dealer']; 
				
				$_SESSION['user']['state']  =  $data['provDesc'];
				$_SESSION['user']['city']  =  $data['citymunDesc'];

				$suffix = "";
				if($_SESSION['user']['suffix_name'] != 'None'){ 
					$suffix = $_SESSION['user']['suffix_name']; 
				} 
				
				$_SESSION['user']['employee_fullname'] =  $_SESSION['user']['first_name'].' '.$_SESSION['user']['middle_name'].' '.$_SESSION['user']['last_name'].' '.$suffix; 
				
				$my_ip_address = $db->getClientIP();
				$my_token = $db->select("SELECT UUID()");
				$db->sql_query("UPDATE `employee_account` SET ip_address='$my_ip_address',`token`='$my_token',`token_expiration`= CURRENT_DATE + INTERVAL 1 DAY WHERE `employee_id` = '".$_SESSION['user']['employee_id']."'");
				$_SESSION['user']['login_token']  =  $my_token;

				if($remember){
					setcookie("employee_master_id", trim($db -> cipher($data['id'],true)), time() + (86400 * 365), "/"); // 86400 = 1 day
				}

				 //means from destroyed session
				if(file_exists('app/employee/class_login.php')){
						header('Location: '.$_SERVER['REQUEST_URI']); 
						exit;
				}else{
						if(!file_exists('../../dist/img/thumbnail/')) {
						mkdir('../../dist/img/thumbnail/', 0777, true);
				}

					$utility->make_thumb('../../dist/img/'.$data['photo'], '../../dist/img/thumbnail/'.$data['photo'], 150);
				}


			}
			 
 
    }

	 
}  
?>