function populate(int $contract_id, &$contract)
{
if ($contract == null) {
$contract_id = (int) $contract_id;
$contract = new rental_contract($contract_id);
$contract->set_contract_date(new rental_contract_date($this->unmarshal($this->db->f('date_start'), 'int'), $this->unmarshal($this->db->f('date_end'), 'int')));
$contract->set_billing_start_date($this->unmarshal($this->db->f('billing_start'), 'int'));
$contract->set_billing_end_date($this->unmarshal($this->db->f('billing_end'), 'int'));
$contract->set_old_contract_id($this->unmarshal($this->db->f('old_contract_id'), 'string'));
$contract->set_contract_type_title($this->unmarshal($this->db->f('title'), 'string'));
$contract->set_comment($this->unmarshal($this->db->f('comment'), 'string'));
$contract->set_last_edited_by_current_user($this->unmarshal($this->db->f('edited_on'), 'int'));
$contract->set_location_id($this->unmarshal($this->db->f('location_id'), 'int'));
$contract->set_last_updated($this->unmarshal($this->db->f('last_updated'), 'int'));
$contract->set_service_id($this->unmarshal($this->db->f('service_id'), 'string'));
$contract->set_responsibility_id($this->unmarshal($this->db->f('responsibility_id'), 'string'));
$contract->set_reference($this->unmarshal($this->db->f('reference'), 'string'));
$contract->set_invoice_header($this->unmarshal($this->db->f('invoice_header'), 'string'));
$contract->set_account_in($this->unmarshal($this->db->f('account_in'), 'string'));
$contract->set_account_out($this->unmarshal($this->db->f('account_out'), 'string'));
$contract->set_project_id($this->unmarshal($this->db->f('project_id'), 'string'));
$contract->set_executive_officer_id($this->unmarshal($this->db->f('executive_officer'), 'int'));
$contract->set_term_id($this->unmarshal($this->db->f('term_id'), 'int'));
$contract->set_term_id_title($this->unmarshal($this->db->f('term_title'), 'string'));
$contract->set_security_type($this->unmarshal($this->db->f('security_type'), 'int'));
$contract->set_security_amount($this->unmarshal($this->db->f('security_amount'), 'string'));
$contract->set_due_date($this->unmarshal($this->db->f('due_date'), 'int'));
$contract->set_contract_type_id($this->unmarshal($this->db->f('contract_type_id'), int));
$contract->set_rented_area($this->unmarshal($this->db->f('rented_area'), 'float'));
$contract->set_adjustable($this->unmarshal($this->db->f('adjustable'), 'bool'));
$contract->set_adjustment_interval($this->unmarshal($this->db->f('adjustment_interval'), 'int'));
$contract->set_adjustment_share($this->unmarshal($this->db->f('adjustment_share'), 'int'));
$contract->set_adjustment_year($this->unmarshal($this->db->f('adjustment_year'), 'int'));
$contract->set_publish_comment($this->unmarshal($this->db->f('publish_comment'), 'bool'));
$contract->set_notify_before($this->unmarshal($this->db->f('notify_before'), 'int'));
$contract->set_notify_before_due_date($this->unmarshal($this->db->f('notify_before_due_date'), 'int'));
$contract->set_notify_after_termination_date($this->unmarshal($this->db->f('notify_after_termination_date'), 'int'));
}
$timestamp_end = $this->unmarshal($this->db->f('timestamp_end'), 'int');
$billing_deleted = $this->unmarshal($this->db->f('deleted'), 'bool');
if ($timestamp_end && !$billing_deleted) {
$contract->add_bill_timestamp($timestamp_end);
}
$total_price = $this->unmarshal($this->db->f('total_price'), 'int');
if ($total_price) {
$contract->set_total_price($total_price);
}
$party_id = $this->unmarshal($this->db->f('party_id', true), 'int');
if ($party_id) {
$party = new rental_party($party_id);
$party->set_first_name($this->unmarshal($this->db->f('first_name', true), 'string'));
$party->set_last_name($this->unmarshal($this->db->f('last_name', true), 'string'));
$party->set_company_name($this->unmarshal($this->db->f('company_name', true), 'string'));
$party->set_department($this->unmarshal($this->db->f('department', true), 'string'));
$party->set_org_enhet_id($this->unmarshal($this->db->f('org_enhet_id'), 'int'));
$is_payer = $this->unmarshal($this->db->f('is_payer', true), 'bool');
if ($is_payer) {
$contract->set_payer_id($party_id);
}
$contract->add_party($party);
}
$composite_id = $this->unmarshal($this->db->f('composite_id', true), 'int');
if ($composite_id) {
$composite = new rental_composite($composite_id);
$composite->set_name($this->unmarshal($this->db->f('composite_name', true), 'string'));
$contract->add_composite($composite);
}
return $contract;
}
/**
* Edit a contract
*/
public function edit()
{
$GLOBALS['phpgw_info']['flags']['app_header'] .= '::' . lang('edit');
$contract_id = (int) phpgw::get_var('id');
$location_id = (int) phpgw::get_var('location_id');
$update_price_items = false;
$message = null;
$error = null;
$add_default_price_items = false;
if (isset($_POST['save_contract'])) {
if (isset($contract_id) && $contract_id > 0) {
$contract = rental_socontract::get_instance()->get_single($contract_id);
if (!$contract->has_permission(PHPGW_ACL_EDIT)) {
unset($contract);
$this->render('permission_denied.php', array('error' => lang('permission_denied_edit_contract')));
}
} else {
if (isset($location_id) && ($this->isExecutiveOfficer() || $this->isAdministrator())) {
$contract = new rental_contract();
$fields = rental_socontract::get_instance()->get_fields_of_responsibility();
$contract->set_location_id($location_id);
$contract->set_contract_type_title($fields[$location_id]);
$add_default_price_items = true;
}
}
$date_start = strtotime(phpgw::get_var('date_start_hidden'));
$date_end = strtotime(phpgw::get_var('date_end_hidden'));
if (isset($contract)) {
$contract->set_contract_date(new rental_contract_date($date_start, $date_end));
$contract->set_security_type(phpgw::get_var('security_type'));
$contract->set_security_amount(phpgw::get_var('security_amount'));
$contract->set_executive_officer_id(phpgw::get_var('executive_officer'));
$contract->set_comment(phpgw::get_var('comment'));
if (isset($location_id) && $location_id > 0) {
$contract->set_location_id($location_id);
// only present when new contract
}
$contract->set_term_id(phpgw::get_var('billing_term'));
$contract->set_billing_start_date(strtotime(phpgw::get_var('billing_start_date_hidden')));
$contract->set_service_id(phpgw::get_var('service_id'));
$contract->set_responsibility_id(phpgw::get_var('responsibility_id'));
$contract->set_reference(phpgw::get_var('reference'));
$contract->set_invoice_header(phpgw::get_var('invoice_header'));
$contract->set_account_in(phpgw::get_var('account_in'));
/*
if($contract->get_contract_type_id() != phpgw::get_var('contract_type'))
{
// New contract type id set, retrieve correct account out
$type_id = phpgw::get_var('contract_type');
if(isset($type_id) && $type_is != ''){
$account = rental_socontract::get_instance()->get_contract_type_account($type_id);
$contract->set_account_out($account);
}
else
{
$contract->set_account_out(phpgw::get_var('account_out'));
}
}
else
{*/
$contract->set_account_out(phpgw::get_var('account_out'));
//}
$contract->set_project_id(phpgw::get_var('project_id'));
$contract->set_due_date(strtotime(phpgw::get_var('due_date_hidden')));
$contract->set_contract_type_id(phpgw::get_var('contract_type'));
$old_rented_area = $contract->get_rented_area();
$new_rented_area = phpgw::get_var('rented_area');
$new_rented_area = str_replace(',', '.', $new_rented_area);
$validated_numeric = false;
if (!isset($new_rented_area) || $new_rented_area == '') {
$new_rented_area = 0;
}
if ($old_rented_area != $new_rented_area) {
$update_price_items = true;
}
$contract->set_rented_area($new_rented_area);
$contract->set_adjustment_interval(phpgw::get_var('adjustment_interval'));
$contract->set_adjustment_share(phpgw::get_var('adjustment_share'));
$contract->set_adjustable(phpgw::get_var('adjustable') == 'on' ? true : false);
$contract->set_publish_comment(phpgw::get_var('publish_comment') == 'on' ? true : false);
$validated_numeric = $contract->validate_numeric();
if ($validated_numeric) {
$so_contract = rental_socontract::get_instance();
$db_contract = $so_contract->get_db();
$db_contract->transaction_begin();
if ($so_contract->store($contract)) {
if ($update_price_items) {
$success = $so_contract->update_price_items($contract->get_id(), $new_rented_area);
if ($success) {
$db_contract->transaction_commit();
$message = lang('messages_saved_form');
$contract_id = $contract->get_id();
} else {
$db_contract->transaction_abort();
$error = lang('messages_form_error');
}
} else {
if ($add_default_price_items) {
$so_price_item = rental_soprice_item::get_instance();
//get default price items for location_id
$default_price_items = $so_contract->get_default_price_items($contract->get_location_id());
//add price_items to contract
foreach ($default_price_items as $price_item_id) {
$so_price_item->add_price_item($contract->get_id(), $price_item_id);
}
$db_contract->transaction_commit();
$message = lang('messages_saved_form');
$contract_id = $contract->get_id();
} else {
$db_contract->transaction_commit();
$message = lang('messages_saved_form');
$contract_id = $contract->get_id();
}
}
} else {
$db_contract->transaction_abort();
$error = lang('messages_form_error');
}
} else {
$error = $contract->get_validation_errors();
return $this->viewedit(true, $contract_id, $contract, $location_id, $notification, $message, $error);
}
}
$GLOBALS['phpgw']->redirect_link('/index.php', array('menuaction' => 'rental.uicontract.edit', 'id' => $contract->get_id(), 'message' => $message, 'error' => $error));
} else {
if (isset($_POST['add_notification'])) {
$contract = rental_socontract::get_instance()->get_single($contract_id);
if ($contract->has_permission(PHPGW_ACL_EDIT)) {
$account_id = phpgw::get_var('notification_target');
$location_id = phpgw::get_var('notification_location');
$date = phpgw::get_var('date_notification_hidden');
if ($date) {
$date = strtotime($date);
}
$notification = new rental_notification(-1, $account_id, $location_id, $contract_id, $date, phpgw::get_var('notification_message'), phpgw::get_var('notification_recurrence'));
if (rental_sonotification::get_instance()->store($notification)) {
$message = lang('messages_saved_form');
$notification = null;
// We don't want to display the date/message when it was sucessfully stored.
} else {
$error = lang('messages_form_error');
}
} else {
$error = lang('permission_denied_edit_contract');
}
}
}
return $this->viewedit(true, $contract_id, null, $location_id, $notification, $message, $error);
}
/**
* Step 4: import the contracts from the file 'u_Kontrakt.csv'
* @param $composites array mapping facilit ids and protico ids for composites
* @param $rentalobject_to_contract array mapping composites and contracts
* @param $parties array mapping party ids
* @param $default_values the default accounts and project numbers
* @return array of contracts
*/
protected function import_contracts($composites, $rentalobject_to_contract, $parties, $default_values)
{
$start_time = time();
$socontract = rental_socontract::get_instance();
$contracts = array();
$datalines = $this->getcsvdata($this->path . "/u_Kontrakt.csv");
$this->messages[] = "Read 'u_Kontrakt.csv' file in " . (time() - $start_time) . " seconds";
$this->messages[] = "'u_Kontrakt.csv' contained " . count($datalines) . " lines";
// Old->new ID mapping
$contract_types = array(2 => 2, 3 => 1, 4 => 8, 5 => 4, 12 => 6, 13 => 7, 14 => 8, 15 => 3, 17 => NULL, 18 => 8, 19 => 8);
foreach ($datalines as $data) {
// Skip this contract if its data is incomplete
if (count($data) <= 27) {
continue;
}
// Create a new contract object
$contract = new rental_contract();
//Set the contract dates
$date_start = is_numeric(strtotime($this->decode($data[3]))) ? strtotime($this->decode($data[3])) : null;
$date_end = is_numeric(strtotime($this->decode($data[4]))) ? strtotime($this->decode($data[4])) : null;
$contract->set_contract_date(new rental_contract_date($date_start, $date_end));
// Set the old contract identifier
$contract->set_old_contract_id($this->decode($data[5]));
//cKontraktnr
// Set the contract biling term
$term = $data[10];
//nTermin
switch ($term) {
case 1:
// Monthly
$contract->set_term_id(1);
break;
case 2:
// Quarterly
$contract->set_term_id(4);
break;
case 4:
// Half-year
$contract->set_term_id(3);
break;
case 5:
// Yearly
$contract->set_term_id(2);
break;
}
// Report non-conforming price periods
$price_period = $data[14];
//nPrisPeriode (4=month, 8=year)
if ($price_period == 4) {
// The price period is month. We ignore this but print a warning.
$this->warnings[] = "Price period of contract " . $contract->get_old_contract_id() . " is month. Ignored.";
//echo "<br/>Price period of contract " . $contract->get_old_contract_id() . " is month. Ignored.";
} elseif ($price_period == 5) {
// The price period is 5, which is unknown. We ignore this but print a warning.
$this->warnings[] = "Price period of contract " . $contract->get_old_contract_id() . " is unknown (value: 5). Ignored.";
//echo "<br/>Price period of contract " . $contract->get_old_contract_id() . " is unknown (value: 5). Ignored.";
}
$contract_status = $data[6];
if ($contract_status == 3) {
// Report contracts under dismissal. Send warning if contract status is '3' (Under avslutning)
$this->warnings[] = "Status of contract " . $contract->get_old_contract_id() . " is '" . lang('contract_under_dismissal') . "'";
} else {
if ($contract_status == 1) {
// Report contracts under plannning. Send warning if contract status is '1' (Under planlegging)
$this->warnings[] = "Status of contract " . $contract->get_old_contract_id() . " is 'Under planlegging'";
} else {
if ($contract_status == 2) {
//Test: if the contract is running; is import date within the contract period
if ($date_start != null && time() < $date_start) {
$this->warnings[] = "Status of contract " . $contract->get_old_contract_id() . " is 'Løpende' but the start date is in the future.";
} else {
if ($date_end != null && time() > $date_end) {
$this->warnings[] = "Status of contract " . $contract->get_old_contract_id() . " is 'Løpende' but the end date is in the past.";
}
}
} else {
if ($contract_status == 4) {
if ($date_end == null || time() < $date_end) {
$this->warnings[] = "Status of contract " . $contract->get_old_contract_id() . " is 'Avsluttet' but the end date not set or in the future.";
}
}
}
}
}
// Set the billing start date for the contract
$billing_start_date = is_numeric(strtotime($this->decode($data[16]))) ? strtotime($this->decode($data[16])) : null;
$contract->set_billing_start_date($billing_start_date);
// Deres ref.
$contract->set_invoice_header($this->decode($data[17]));
//cFakturaRef
$contract->set_comment($this->decode($data[18]));
//cMerknad
$contract->set_contract_type_id($contract_types[$this->decode($data[1])]);
//
// Set the location identifier (responsibiity area)
$contract->set_location_id($this->location_id);
// Get the composite identifier for the composite included in this contract
$composite_id = $composites[$rentalobject_to_contract[$data[0]]];
// Retrieve the title for the responsibility area we are importing (to hande the respoonsibility areas differently)
$title = $socontract->get_responsibility_title($this->location_id);
// For external contract types the rented area resides on the composite ...
if ($title == 'contract_type_eksternleie') {
if ($composite_id) {
$socomposite = rental_socomposite::get_instance();
$contract->set_rented_area($socomposite->get_area($composite_id));
}
} else {
if ($title == 'contract_type_innleie') {
$rented_area_on_contract = $this->decode($data[21]);
if (isset($rented_area_on_contract) && $rented_area_on_contract > 0) {
$contract->set_rented_area($rented_area_on_contract);
} else {
if ($composite_id) {
$socomposite = rental_socomposite::get_instance();
$contract->set_rented_area($socomposite->get_area($composite_id));
}
}
} else {
// ... and for others contract types the rented area resides on the contract
$contract->set_rented_area($this->decode($data[21]));
}
}
// Retrieve default values for accounts and project numbers
if ($title == 'contract_type_eksternleie') {
$type_id = $contract->get_contract_type_id();
if (!in_array($type_id, array(6, 7, 8))) {
$contract->set_contract_type_id(8);
}
} else {
if ($title == 'contract_type_internleie') {
//Set default account in/out and project numbers for internal contracts
$contract->set_account_in($default_values['account_in']);
$contract->set_account_out($default_values['account_out']);
$contract->set_project_id($default_values['project_number']);
// Ansvar/Tjenestested: F.eks: 080400.13000
$ansvar_tjeneste = $this->decode($data[26]);
//cSikkerhetsTekst
$ansvar_tjeneste_components = explode(".", $ansvar_tjeneste);
if (count($ansvar_tjeneste_components) == 2) {
$contract->set_responsibility_id($ansvar_tjeneste_components[0]);
$contract->set_service_id($ansvar_tjeneste_components[1]);
} else {
$this->warnings[] = "The contract (internal) " . $contract->get_old_contract_id() . " lacks service and responsibility ids";
}
}
}
// Store contract
if ($socontract->store($contract)) {
// Map contract ids in Facilit and PE contract id (should be the same)
$contracts[$data[0]] = $contract->get_id();
// Check if this contract has a composite and if so add rental composite to contract
if (!$this->is_null($rentalobject_to_contract[$data[0]]) && !$this->is_null($composite_id)) {
$socontract->add_composite($contract->get_id(), $composite_id);
}
// Check if this contract has a contract part and if so add party to contract
if (!$this->is_null($data[2])) {
//nPersonForetakId
$party_id = $parties[$this->decode($data[2])];
$socontract->add_party($contract->get_id(), $party_id);
// Set this party to be the contract invoice recipient
$socontract->set_payer($contract->get_id(), $party_id);
}
$this->messages[] = "Successfully added contract (" . $contract->get_id() . "/" . $contract->get_old_contract_id() . ")";
} else {
$this->errors[] = "Failed to store contract " . $this->decode($data[5]);
}
}
$this->messages[] = "Successfully imported " . count($contracts) . " contracts. (" . (time() - $start_time) . " seconds)";
return $contracts;
}
/**
* Create a new contract tied to the composite provided in the composite_id parameter
*/
public function add_from_composite()
{
$contract = new rental_contract();
$contract->set_location_id(phpgw::get_var('responsibility_id'));
$contract->set_account_in(rental_socontract::get_instance()->get_default_account($contract->get_location_id(), true));
$contract->set_account_out(rental_socontract::get_instance()->get_default_account($contract->get_location_id(), false));
$contract->set_executive_officer_id($GLOBALS['phpgw_info']['user']['account_id']);
$config = CreateObject('phpgwapi.config', 'rental');
$config->read();
$default_billing_term = $config->config_data['default_billing_term'];
$contract->set_term_id($default_billing_term);
$units = rental_socomposite::get_instance()->get_single(phpgw::get_var('id'))->get_units();
$location_code = $units[0]->get_location()->get_location_code();
$args = array('acl_location' => '.contract', 'location_code' => $location_code, 'contract' => &$contract);
$hook_helper = CreateObject('rental.hook_helper');
$hook_helper->add_contract_from_composite($args);
// _debug_array($contract); die();
if ($contract->has_permission(PHPGW_ACL_EDIT)) {
$so_contract = rental_socontract::get_instance();
$db_contract = $so_contract->get_db();
$db_contract->transaction_begin();
if ($so_contract->store($contract)) {
// Add standard price items to contract
if ($contract->get_location_id() && ($this->isExecutiveOfficer() || $this->isAdministrator())) {
$so_price_item = rental_soprice_item::get_instance();
//get default price items for location_id
$default_price_items = $so_contract->get_default_price_items($contract->get_location_id());
foreach ($default_price_items as $price_item_id) {
$so_price_item->add_price_item($contract->get_id(), $price_item_id);
}
}
// Add that composite to the new contract
$success = $so_contract->add_composite($contract->get_id(), phpgw::get_var('id'));
if ($success) {
$db_contract->transaction_commit();
$comp_name = rental_socomposite::get_instance()->get_single(phpgw::get_var('id'))->get_name();
$message = lang('messages_new_contract_from_composite') . ' ' . $comp_name;
$GLOBALS['phpgw']->redirect_link('/index.php', array('menuaction' => 'rental.uicontract.edit', 'id' => $contract->get_id(), 'message' => $message));
} else {
$db_contract->transaction_abort();
$GLOBALS['phpgw']->redirect_link('/index.php', array('menuaction' => 'rental.uicontract.edit', 'id' => $contract->get_id(), 'message' => lang('messages_form_error')));
}
} else {
$db_contract->transaction_abort();
$GLOBALS['phpgw']->redirect_link('/index.php', array('menuaction' => 'rental.uicontract.edit', 'id' => $contract->get_id(), 'message' => lang('messages_form_error')));
}
}
// If no executive officer
$this->render('permission_denied.php', array('error' => lang('permission_denied_new_contract')));
}
