protected function populate(int $price_item_id, &$price_item)
{
if ($price_item == null) {
$price_item = new rental_price_item($this->unmarshal($this->db->f('id'), 'int'));
$price_item->set_title($this->unmarshal($this->db->f('title'), 'string'));
$price_item->set_agresso_id($this->unmarshal($this->db->f('agresso_id'), 'string'));
$price_item->set_is_area($this->unmarshal($this->db->f('is_area'), 'bool'));
$price_item->set_is_inactive($this->unmarshal($this->db->f('is_inactive'), 'bool'));
$price_item->set_is_adjustable($this->unmarshal($this->db->f('is_adjustable'), 'bool'));
$price_item->set_standard($this->unmarshal($this->db->f('standard'), 'bool'));
$price_item->set_price($this->unmarshal($this->db->f('price'), 'float'));
$price_item->set_responsibility_id($this->unmarshal($this->db->f('responsibility_id', true), 'int'));
$price_item->set_responsibility_title($this->unmarshal($this->db->f('resp_title', true), 'string'));
$price_type_id = (int) $this->db->f('type');
$price_item->set_price_type_id($price_type_id);
$price_item->set_price_type_title($price_type_id);
}
return $price_item;
}
public function adjust_contracts($adjustments)
{
/*
* gather all adjustable contracts with
* interval = adjustment interval and this year = last adjusted + interval
* or
* last adjusted is null / 0 (use contract start year)
* adjust each contract's price items according to adjustment info (percent, adjustment_percent)
* Run as transaction
* update adjustment -> set is_executed to true
* update price book elements according to type if interval=1
*/
$current_year = (int) date('Y');
//var_dump("innicontr");
foreach ($adjustments as $adjustment) {
//gather all adjustable contracts
$adjustable_contracts = "SELECT id, adjustment_share, date_start, adjustment_year FROM rental_contract ";
$adjustable_contracts .= "WHERE location_id = '{$adjustment->get_responsibility_id()}' AND adjustable ";
$adjustable_contracts .= "AND adjustment_interval = {$adjustment->get_interval()} ";
$adjustable_contracts .= "AND (((adjustment_year + {$adjustment->get_interval()}) <= {$adjustment->get_year()})";
$adjustable_contracts .= " OR ";
$adjustable_contracts .= "(";
if ($adjustment->is_extra_adjustment()) {
$adjustable_contracts .= "adjustment_year = {$adjustment->get_year()}";
$adjustable_contracts .= " OR ";
}
$adjustable_contracts .= "(adjustment_year IS NULL OR adjustment_year = 0)";
$adjustable_contracts .= "))";
//var_dump($adjustable_contracts);
//die();
$result = $this->db->query($adjustable_contracts);
while ($this->db->next_record()) {
$contract_id = $this->unmarshal($this->db->f('id', true), 'int');
$adjustment_share = $this->unmarshal($this->db->f('adjustment_share', true), 'int');
$date_start = $this->unmarshal($this->db->f('date_start', true), 'int');
$adj_year = $this->unmarshal($this->db->f('adjustment_year', true), 'int');
$start_year = date('Y', $date_start);
$contract = rental_socontract::get_instance()->get_single($contract_id);
$firstJanAdjYear = mktime(0, 0, 0, 1, 1, $adjustment->get_year());
if ($contract->is_active($firstJanAdjYear) && ($adj_year != null && $adj_year > 0 || ($adj_year == null || $adj_year == 0) && $start_year + $adjustment->get_interval() <= $adjustment->get_year())) {
//update adjustment_year on contract
rental_socontract::get_instance()->update_adjustment_year($contract_id, $adjustment->get_year());
//gather price items to be adjusted
$contract_price_items = rental_socontract_price_item::get_instance()->get(null, null, null, null, null, null, array('contract_id' => $contract_id));
foreach ($contract_price_items as $cpi) {
//update price according to adjustment info
$cpi_old_price = $cpi->get_price();
$cpi_adjustment = $cpi_old_price * ($adjustment->get_percent() / 100) * ($adjustment_share / 100);
$cpi_new_price = $cpi_old_price + $cpi_adjustment;
$cpi->set_price($cpi_new_price);
rental_socontract_price_item::get_instance()->store($cpi);
}
}
}
//TODO: update price book
if ($adjustment->get_interval() == 1) {
$adjustable_price_items = "SELECT * FROM rental_price_item WHERE responsibility_id = {$adjustment->get_responsibility_id()} AND is_adjustable";
$result = $this->db->query($adjustable_price_items);
$price_items = array();
while ($this->db->next_record()) {
$price_item = new rental_price_item($this->unmarshal($this->db->f('id'), 'int'));
$price_item->set_title($this->unmarshal($this->db->f('title'), 'string'));
$price_item->set_agresso_id($this->unmarshal($this->db->f('agresso_id'), 'string'));
$price_item->set_is_area($this->unmarshal($this->db->f('is_area'), 'bool'));
$price_item->set_is_inactive($this->unmarshal($this->db->f('is_inactive'), 'bool'));
$price_item->set_is_adjustable($this->unmarshal($this->db->f('is_adjustable'), 'bool'));
$price_item->set_price($this->unmarshal($this->db->f('price'), 'float'));
$price_item->set_responsibility_id($this->unmarshal($this->db->f('responsibility_id', true), 'int'));
$price_item->set_responsibility_title($this->unmarshal($this->db->f('resp_title', true), 'string'));
$price_items[] = $price_item;
}
foreach ($price_items as $pi) {
$pi_old_price = $pi->get_price();
$pi_adjustment = $pi_old_price * ($adjustment->get_percent() / 100);
$pi_new_price = $pi_old_price + $pi_adjustment;
$pi->set_price($pi_new_price);
rental_soprice_item::get_instance()->store($pi);
}
}
$adjustment->set_is_executed(true);
$this->update($adjustment);
//notify all users with write access on the field of responsibility
$location_id = $adjustment->get_responsibility_id();
if ($location_id) {
$location_names = $GLOBALS['phpgw']->locations->get_name($location_id);
if ($location_names['appname'] == $GLOBALS['phpgw_info']['flags']['currentapp']) {
$responsible_accounts = $GLOBALS['phpgw']->acl->get_user_list_right(PHPGW_ACL_EDIT, $location_names['location']);
foreach ($responsible_accounts as $ra) {
$account_ids[] = $ra['account_id'];
}
}
}
$location_label = rental_socontract::get_instance()->get_responsibility_title($location_id);
$adj_interval = $adjustment->get_interval();
$day = date("Y-m-d", strtotime('now'));
$ts_today = strtotime($day);
//notify each unique account
foreach ($account_ids as $account_id) {
if ($account_id && $account_id > 0) {
$notification = new rental_notification(0, $account_id, 0, null, $ts_today, $location_label . '_' . $adj_interval, null, null, null, null);
rental_soworkbench_notification::get_instance()->store($notification);
}
}
}
return true;
}
