public static function Calculation($users,$projects,$storage,$active_to,$tiers_str,$client_id,$active_from='') {
$css = ClientServiceSettings::model()->findByPk($client_id);
if ($css->CheckMinMax($users,$projects,$storage)) {
$tiers_str_before = $css->Service_Level_ID;
$tiers_arr_before = explode(',',$tiers_str_before);
//we need to divide inputted settings into base and additional
$base_level_settings_before = ClientServiceSettings::getBaseTierValues($tiers_arr_before);
$base_level_settings_after = ClientServiceSettings::getBaseTierValues(explode(',',$tiers_str));
$levels_check_sum_before = ClientServiceSettings::getLevelsCheckSum($tiers_arr_before);
$levels_check_sum_after = ClientServiceSettings::getLevelsCheckSum(explode(',',$tiers_str));
$count_sum_before = $css->Additional_Users + $css->Additional_Projects + $css->Additional_Storage + $base_level_settings_before['Users_Count'] + $base_level_settings_before['Projects_Count'] + $base_level_settings_before['Storage_Count'] + $levels_check_sum_before;
$count_sum_after = $users + $projects + $storage + $levels_check_sum_after;// + $base_level_settings_after['Users_Count'] + $base_level_settings_after['Projects_Count'] + $base_level_settings_after['Storage_Count'];
$service_level_grown =($count_sum_after > $count_sum_before) ? 1 : 0;
$active_to_date_changed = (strtotime($css->Active_To)< strtotime($active_to)) ? 1 : 0;
$service_level_grown = $active_to_date_changed ? 1 : $service_level_grown;
$base_fee_after = ClientServiceSettings::CalculateBaseFee(explode(',',$tiers_str));
//extra(additional)
$add_users = intval($users) - $base_level_settings_after['Users_Count'];//- $css->Additional_Users ;
$add_users = ( $add_users > 0 ) ? $add_users : 0;
$add_projects = $projects - $base_level_settings_after['Projects_Count'];//-$css->Additional_Projects ;
$add_projects = ( $add_projects > 0 ) ? $add_projects : 0;
$add_storage = $storage - $base_level_settings_after['Storage_Count'];//-$css->Additional_Storage ;
$add_storage = ( $add_storage > 0 ) ? $add_storage : 0;
$add_fee = $add_users * $base_level_settings_after['Max_Add_User_Fee'] + $add_projects * $base_level_settings_after['Max_Add_Project_Fee'] + $add_storage * $base_level_settings_after['Max_Add_Storage_Fee'];
$new_monthly_price = $base_fee_after + $add_fee;
$old_add_fee = $css->Additional_Users * $base_level_settings_after['Max_Add_User_Fee'] + $css->Additional_Projects * $base_level_settings_after['Max_Add_Project_Fee'] + $css->Additional_Storage * $base_level_settings_after['Max_Add_Storage_Fee'];
$add_fee_changed = $old_add_fee -$add_fee;
$old_monthly_price = $css->Fee;
//1) If active_to changed, we need to calculate how many months(periods)
$periods_for_current = Helper::calculatePeriodsBetweenDates(date('m/d/Y',strtotime($css->Active_To)),$active_to);
$periods_for_added = Helper::calculatePeriodsBetweenDates(date('m/d/Y'),$active_to);
//2) Multiply changes on the amount of periods
$changed_fee = round(floatval($new_monthly_price) - floatval($old_monthly_price),2)*$periods_for_added;
$changed_fee = ($changed_fee > 0) ? $changed_fee : 0;
//for cases when period changed and additional settings changed
if (!$active_from && $active_to_date_changed) {
$changed_fee = $changed_fee + $new_monthly_price*$periods_for_current;
}
return array(
'new_monthly_price'=>$new_monthly_price,
'changed_fee'=>$changed_fee,
'periods'=>$periods,
'service_level_grown'=>$service_level_grown,
'add_users'=>$add_users,
'add_projects'=>$add_projects,
'add_storage'=>$add_storage,
);
} else {
return false;
}
}
'items'=> $items,
'level_ids'=>$level_ids,
'summary_sl_settings'=>$summary_sl_settings
));
?></td>
<td id="set_count_users"><?php echo $summary_sl_settings['Users_Count'];?></td>
<td id="set_count_projects"><?php echo $summary_sl_settings['Projects_Count'];?></td>
<td id="set_count_storage"><?php echo $summary_sl_settings['Storage_Count'];?></td>
<td id="set_base_fee"><?php echo number_format($summary_sl_settings['Base_Fee'], 2);?></td>
</tr>
<tr>
<td>Added</td>
<?php
$tiers_str = $summary_sl_settings['Tiers_Str'];
$base_level_settings = ClientServiceSettings::getBaseTierValues(explode(',',$tiers_str));
?>
<td><?php echo CHtml::activeTextField($settings, "Additional_Users", array(
'class' => 'input_in_grid qty_cell',
'disabled' =>(Yii::app()->user->id=='db_admin') ? false : true,
'style'=>'background:'.(Yii::app()->user->id=='db_admin' ? 'white' : ''),
'data-fee' => $base_level_settings['Max_Add_User_Fee'],
'maxlength'=>3
));?></td>
<td><?php echo CHtml::activeTextField($settings, "Additional_Projects", array(
'class' => 'input_in_grid qty_cell',
'disabled' =>(Yii::app()->user->id=='db_admin') ? false : true,
'style'=>'background:'.(Yii::app()->user->id=='db_admin' ? 'white' : ''),
'data-fee' => $base_level_settings['Max_Add_Project_Fee'],
'maxlength'=>3
));?></td>
/**
* Add client Payment, apply new settings and update 'Active To' date
* @param $clientID
* @param $amount
* @param $date
*/
public static function addClientPayment($clientID, $amount, $date, $monthly_payment,$paydoc_number='auto')
{
$client = Clients::model()->with('service_settings', 'pending_service_settings','company.adreses')->findByPk($clientID);
//$user = Users::model()->with('person')->findByPk(Yii::app()->user->userID);
//$uid = UsersClientList::model()->findByAttributes(array('Client_ID'=>$clientID))->User_ID;
$user = Users::model()->with('person')->findByPk(Yii::app()->user->userID);
$sumToPay=$amount;
//$sum_settings = ServiceLevelSettings::getSummarySettings($clientID);
if ($client && $amount > 0 && preg_match('/^\d{4}\-\d{2}\-\d{2}$/', $date)) {
$pendingSettings = $client->pending_service_settings;
$currentSettings = $client->service_settings;
$dcss = DelayedClientServiceSettings::model()->findByPk(Yii::app()->user->clientID);
if($dcss) {$dcss->delete();}
$sum_settings = ClientServiceSettings::getBaseTierValues(explode(',',$pendingSettings->Service_Level_ID));
//variables for email notification, not for logic
$settingsBefore = "Level : ".$currentSettings->Service_Level_ID." Users:".$currentSettings->Additional_Users." Projects:".$currentSettings->Additional_Projects." Storage : ". $currentSettings->Additional_Storage;
$dateBefore=date_format(date_create($currentSettings->Active_To),'Y-m-d');
$tierNameBefore=ServiceLevelSettings::model()->findByPk($currentSettings->Service_Level_ID)->Tier_Name;
$settings_are_delayed = $pendingSettings->Pending_Active_From=='0000-00-00' ? 0 : 1;
// begin transaction
$transaction = Yii::app()->db->beginTransaction();
try {
$payment = new ServicePayments();
$payment->Client_ID = $clientID;
$payment->Payment_Date = $date;
$payment->Payment_Amount = $amount;
$payment->Payment_Amount = $paydoc_number;
if ($payment->validate()) {
// save payment
$payment->save();
//echo "Payment validated and saved\n";
$dateFrom = $currentSettings->Active_To;
if ($dateFrom < date('Y-m-d')) {
$dateFrom = date('Y-m-d');
}
// apply new settings if necessary
if ($pendingSettings && $amount >= $pendingSettings->Fee_To_Upgrade && !$monthly_payment && !$settings_are_delayed) {
$currentSettings->Service_Level_ID = $pendingSettings->Service_Level_ID;
$currentSettings->Additional_Users = $pendingSettings->Additional_Users-$sum_settings['Users_Count'];
$currentSettings->Additional_Projects = $pendingSettings->Additional_Projects;//-$sum_settings['Projects_Count'];
$currentSettings->Additional_Storage = $pendingSettings->Additional_Storage;//-$sum_settings['Storage_Count'];
$currentSettings->Active_To = $pendingSettings->Pending_Active_To;
$currentSettings->Fee = $pendingSettings->Fee;
$currentSettings->save();
$user_client_settings = $client->service_settings;
$user_tier_settings = TiersSettings::agregateTiersSettings($user_client_settings->Service_Level_ID);
Yii::app()->user->setState('tier_settings', $user_tier_settings);
// $amount -= $pendingSettings->getCurrentAmountToUpgrade($dateFrom);
$pendingSettings->delete();
}
if ($pendingSettings && $amount >= $pendingSettings->Fee_To_Upgrade && !$monthly_payment && $settings_are_delayed) {
///
DelayedClientServiceSettings::createDelayedFromPending($pendingSettings,$clientID,$sum_settings['Users_Count'],
$sum_settings['Projects_Count'],$sum_settings['Storage_Count']
);
/* $dcss->Additional_Users = $pendingSettings->Additional_Users-$sum_settings['Users_Count'];
$dcss->Additional_Projects = $pendingSettings->Additional_Projects-$sum_settings['Projects_Count'];
$dcss->Additional_Storage = $pendingSettings->Additional_Storage-$sum_settings['Storage_Count'];*/
}
// update Active_To date
if ( $monthly_payment) {
/*$addDays = ceil($amount/($currentSettings->Fee/self::DEFAULT_DAYS_IN_MONTH));
$dateOb = date_create($dateFrom);
date_add($dateOb, date_interval_create_from_date_string($addDays . ' days'));
$activeTo = date_format($dateOb, 'Y-m-d');*/
$number_of_periods = floor($amount/$currentSettings->Fee);
$activeTo = strtotime(date("m/d/Y", strtotime($dateFrom)) . " +".$number_of_periods." month");
$currentSettings->Active_To = date('Y-m-d',$activeTo);
$currentSettings->save();
if ( $pendingSettings ) {
//we need to update active_to date in the pending settings.
$pendingSettings->Pending_Active_To = date('Y-m-d',$activeTo);
$pendingSettings->save();
}
}
$transaction->commit();
//variables for email notification, not for logic
$email=$user->person->Email;
$settingsAfter = "Level : ".$currentSettings->Service_Level_ID." Users:".$currentSettings->Additional_Users." Projects:".$currentSettings->Additional_Projects." Storage : ". $currentSettings->Additional_Storage;
$dateAfter=date_format(date_create($currentSettings->Active_To),'Y-m-d');
$tierNameAfter=ServiceLevelSettings::model()->findByPk($currentSettings->Service_Level_ID)->Tier_Name;
$company_name=$client->company->Company_Name;
Mail::notifyAdminAboutStripePaymentExecuted($email,$company_name,$settingsBefore,$settingsAfter,$tierNameBefore,$tierNameAfter,$dateBefore,$dateAfter,$sumToPay);
} else { Yii::app()->user->setFlash('error', "ServicePayments validation error!"); }
} catch(Exception $e) {
$transaction->rollback();
}
}
}
