File: //home/cafsindia/cloud_cafsinfotech_in/application/models/Formula_model.php
<?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){
if($trans['inc_period'] == 1){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime('+3 months',$date_1));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 2){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime('+6 months',$date_1));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 3){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 6){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 12){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_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;
}
if((int)$trans["role"] === 2){
if($trans['inc_period'] == 1){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime('+3 months',$date_1));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 2){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime('+6 months',$date_1));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 3){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 6){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 12){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_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;
}
if((int)$trans["role"] === 3){
if($trans['inc_period'] == 1){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime('+3 months',$date_1));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 2){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime('+6 months',$date_1));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 3){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 6){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 12){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_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;
}
if((int)$trans["role"] === 4){
if($trans['inc_period'] == 1){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime('+3 months',$date_1));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 2){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime('+6 months',$date_1));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 3){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 6){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_2;
}
if($trans['inc_period'] == 12){
$date_1 = date('y-m-d',strtotime($trans['date_of_joining']));
$date_2 = date('d-m-y',strtotime("+".$trans['inc_period']." months",strtotime($date_1)));
$trans['incdate']= $date_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_array[$employee_code] = $trans;
}
return $trans_array;
}
}
?>