protected function import_parties()
{
$start_time = time();
$soparty = rental_soparty::get_instance();
$parties = array();
//Check to see if there is any parties in the database. If so, do not store these
//... double checking to ensure that the user has not logged out and in again during import
$alreay_imported_parties = false;
$number_of_parties = $soparty->get_number_of_parties();
if ($number_of_parties > 0) {
return;
}
$datalines = $this->getcsvdata($this->path . "/u_PersonForetak.csv", true);
$this->messages[] = "Read 'u_PersonForetak.csv' file in " . (time() - $start_time) . " seconds";
$this->messages[] = "'u_PersonForetak.csv' contained " . count($datalines) . " lines";
$counter = 1;
// Loop through each line of the file, parsing CSV data to a php array
foreach ($datalines as $data) {
if (count($data) <= 30) {
continue;
}
// Create a new rental party we can fill with info from this line from the file
$party = new rental_party();
$identifier = $this->decode($data[24]);
//cPersonForetaknr
//Removed whitespace characters
$identifier = str_replace(' ', '', '' . $identifier);
// Default information
$party->set_address_1($this->decode($data[3]));
//cAdresse1
$party->set_address_2($this->decode($data[4]));
//cAdresse2
$party->set_postal_code($this->decode($data[5]));
//cPostnr
$party->set_mobile_phone($this->decode($data[7]));
//cMobil
$party->set_phone($this->decode($data[8]));
//cTelefon
$party->set_fax($this->decode($data[9]));
//cTelefaks
$party->set_title($this->decode($data[12]));
//cArbeidstittel
$party->set_email($this->decode($data[25]));
//cEpost
$party->set_company_name($this->decode($data[10]));
//cArbeidsgiver
$party->set_department($this->decode($data[11]));
//cAvdeling
$party->set_account_number($this->decode($data[14]));
//cBankkontonr
$party->set_reskontro($this->decode($data[23]));
//cReskontronr
$party->set_comment($this->decode($data[26]));
//cMerknad
// Insert contract person in comment if present
$contact_person = $this->decode($data[6]);
if (isset($contact_person)) {
$party->set_comment($party->get_comment() . "\n\nKontaktperson: " . $contact_person);
//cKontaktPerson
}
$valid_identifier = false;
switch (strlen('' . $identifier)) {
case 4:
// Intern organisasjonstilknytning
//Should be four number or on the form 'KFxx'
if (is_numeric($identifier) || substr($identifier, 0, 2) == 'KF' && is_numeric(substr($identifier, 2, 2))) {
$party->set_company_name($this->decode($data[2]));
//cForetaksnavn
$party->set_first_name(null);
$party->set_last_name(null);
// Get location ID
$locations = $GLOBALS['phpgw']->locations;
$subs = $locations->get_subs_from_pattern('rental', '.ORG.BK.__.' . $identifier);
//cPersonForetaknr
if (count($subs) > 0) {
$party->set_location_id($subs[0]['location_id']);
} else {
$this->warnings[] = "Party with valid identifier ({$identifier}) not found in internal organisation tree. Company name({$party->get_company_name()})";
}
$valid_identifier = true;
}
break;
case 5:
//Internal, Should be a result unit on the form 'Rxxxx'
if (substr($identifier, 0, 1) == 'R' && is_numeric(substr($identifier, 1, 4))) {
$identifier = substr($identifier, 1, 4);
$party->set_company_name($this->decode($data[2]));
//cForetaksnavn
$party->set_first_name(null);
$party->set_last_name(null);
// Get location ID
$locations = $GLOBALS['phpgw']->locations;
$subs = $locations->get_subs_from_pattern('rental', '.ORG.BK.__.' . $identifier);
//cPersonForetaknr
if (count($subs) > 0) {
$party->set_location_id($subs[0]['location_id']);
} else {
$this->warnings[] = "Party with valid identifier ({$identifier}- original R{$identifier}) not found in internal organisation tree. Company name({$party->get_company_name()})";
}
$valid_identifier = true;
}
break;
case 6:
// Foretak (agresso-id)
// Foretak (agresso-id)
case 9:
// Foretak (org.nr)
if (is_numeric($identifier)) {
$party->set_company_name($this->decode($data[2]));
//cForetaksnavn
$party->set_first_name(null);
$party->set_last_name(null);
$valid_identifier = true;
}
break;
case 11:
// Personnr
if (is_numeric($identifier)) {
if (!$this->is_null($data[0])) {
$party->set_first_name($this->decode($data[0]));
//cFornavn
$party->set_last_name($this->decode($data[1]));
//cEtternavn
} else {
$company_name = explode(' ', $this->decode($data[2]), 2);
//cForetaksnavn
$party->set_first_name($company_name[0]);
//cFornavn
$party->set_last_name($company_name[1]);
//cEtternavn
}
$valid_identifier = true;
}
break;
}
if (!$valid_identifier) {
$party->set_first_name($this->decode($data[0]));
//cFornavn
$party->set_last_name($this->decode($data[1]));
//cEtternavn
$party->set_company_name($this->decode($data[2]));
//cForetaksnavn
$party->set_is_inactive(true);
$this->warnings[] = "Party with unknown 'cPersonForetaknr' format ({$identifier}). First name ({$party->get_first_name()}). Last name({$party->get_last_name()}). Company name({$party->get_company_name()}) Setting as inactive.";
}
// Fødselsnr/Foretaksnr/AgressoID
$party->set_identifier($identifier);
// Store party and log message
if ($soparty->store($party)) {
// Add party to collection of parties keyed by its facilit ID so we can refer to it later.
$facilit_id = $data[17];
//nPersonForetakId
$parties[$facilit_id] = $party->get_id();
$this->messages[] = "Successfully added party " . $party->get_name() . " (" . $party->get_id() . ")";
} else {
$this->errors[] = "Failed to store party " . $party->get_name();
}
}
$this->messages[] = "Successfully imported " . count($parties) . " contract parties. (" . (time() - $start_time) . " seconds).";
//Clean up
//unset();
return $parties;
}
/**
* Public method. Called when user wants to edit a contract party.
* @param HTTP::id the party ID
*/
public function edit()
{
$GLOBALS['phpgw_info']['flags']['app_header'] .= '::' . lang('edit');
// Get the contract part id
$party_id = (int) phpgw::get_var('id');
// Retrieve the party object or create a new one if correct permissions
if ($this->isExecutiveOfficer() || $this->isAdministrator()) {
if (isset($party_id) && $party_id > 0) {
$party = rental_soparty::get_instance()->get_single($party_id);
} else {
$party = new rental_party();
}
} else {
$this->render('permission_denied.php', array('error' => lang('permission_denied_edit')));
}
if (isset($_POST['save_party'])) {
if (isset($party)) {
// ... set all parameters
$party->set_identifier(phpgw::get_var('identifier'));
$party->set_first_name(phpgw::get_var('firstname'));
$party->set_last_name(phpgw::get_var('lastname'));
$party->set_title(phpgw::get_var('title'));
$party->set_company_name(phpgw::get_var('company_name'));
$party->set_department(phpgw::get_var('department'));
$party->set_address_1(phpgw::get_var('address1'));
$party->set_address_2(phpgw::get_var('address2'));
$party->set_postal_code(phpgw::get_var('postal_code'));
$party->set_place(phpgw::get_var('place'));
$party->set_phone(phpgw::get_var('phone'));
$party->set_mobile_phone(phpgw::get_var('mobile_phone'));
$party->set_fax(phpgw::get_var('fax'));
$party->set_email(phpgw::get_var('email'));
$party->set_url(phpgw::get_var('url'));
$party->set_account_number(phpgw::get_var('account_number'));
$party->set_reskontro(phpgw::get_var('reskontro'));
$party->set_is_inactive(phpgw::get_var('is_inactive') == 'on' ? true : false);
$party->set_comment(phpgw::get_var('comment'));
//$party->set_location_id(phpgw::get_var('location_id'));
$party->set_org_enhet_id(phpgw::get_var('org_enhet_id'));
$party->set_unit_leader(phpgw::get_var('unit_leader'));
if (rental_soparty::get_instance()->store($party)) {
$message = lang('messages_saved_form');
} else {
$error = lang('messages_form_error');
}
}
}
$config = CreateObject('phpgwapi.config', 'rental');
$config->read();
return $this->render('party.php', array('party' => $party, 'editable' => true, 'message' => isset($message) ? $message : phpgw::get_var('message'), 'error' => isset($error) ? $error : phpgw::get_var('error'), 'cancel_link' => self::link(array('menuaction' => 'rental.uiparty.index', 'populate_form' => 'yes')), 'use_fellesdata' => $config->config_data['use_fellesdata']));
}
