<?php
class Formula_model extends CI_Model{
	public function import_formula($trans_array){ 
		foreach($trans_array as $trans){
			$employee_code = $trans["employee_code"];
			if((int)$trans["role"] === 1){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
			if((int)$trans["role"] === 2){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
			if((int)$trans["role"] === 3){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
			if((int)$trans["role"] === 4){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
			if((int)$trans["role"] === 5){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
			if((int)$trans["role"] === 6){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
			if((int)$trans["role"] === 7){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
			if((int)$trans["role"] === 8){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
			if((int)$trans["role"] === 9){
				$date_1 = new DateTime($trans['date_of_birth']);
$date_2 = new DateTime(date('Y-m-d') );
$differ = $date_2->diff($date_1);
$age    =  (string)$differ ->y;
$trans['emp_age']= $age;$trans['fg']= $trans['fb']+$trans['faa']+$trans['fbs']+$trans['fca']+$trans['fea']+$trans['fhra']+$trans['fla']+$trans['fma']+$trans['fsft']+$trans['fsa']+$trans['fwa'];
			}
		 $trans_array[$employee_code] = $trans;
		} 
		 
		return $trans_array;
	}
}
?>