/**
  * Get a static reference to the storage object associated with this model object
  *
  * @return the storage object
  */
 public static function get_so()
 {
     if (self::$so == null) {
         self::$so = CreateObject('rental.soparty');
     }
     return self::$so;
 }
 public function remove_party(rental_party $party_to_remove)
 {
     unset($this->parties[$party_to_remove]);
     $so = self::get_so();
     $so->remove_party($this->get_id(), $party_to_remove->get_id());
 }
 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;
 }
 protected function populate(int $party_id, &$party)
 {
     if ($party == null) {
         $party = new rental_party((int) $party_id);
         $party->set_account_number($this->unmarshal($this->db->f('account_number'), 'string'));
         $party->set_address_1($this->unmarshal($this->db->f('address_1'), 'string'));
         $party->set_address_2($this->unmarshal($this->db->f('address_2'), 'string'));
         $party->set_comment($this->unmarshal($this->db->f('comment'), 'string'));
         $party->set_company_name($this->unmarshal($this->db->f('company_name'), 'string'));
         $party->set_department($this->unmarshal($this->db->f('department'), 'string'));
         $party->set_email($this->unmarshal($this->db->f('email'), 'string'));
         $party->set_fax($this->unmarshal($this->db->f('fax'), 'string'));
         $party->set_first_name($this->unmarshal($this->db->f('first_name'), 'string'));
         $party->set_is_inactive($this->unmarshal($this->db->f('is_inactive'), 'bool'));
         $party->set_last_name($this->unmarshal($this->db->f('last_name'), 'string'));
         $party->set_location_id($this->unmarshal($this->db->f('org_location_id'), 'int'));
         $party->set_identifier($this->unmarshal($this->db->f('identifier'), 'string'));
         $party->set_mobile_phone($this->unmarshal($this->db->f('mobile_phone'), 'string'));
         $party->set_place($this->unmarshal($this->db->f('place'), 'string'));
         $party->set_postal_code($this->unmarshal($this->db->f('postal_code'), 'string'));
         $party->set_reskontro($this->unmarshal($this->db->f('reskontro'), 'string'));
         $party->set_title($this->unmarshal($this->db->f('title'), 'string'));
         $party->set_url($this->unmarshal($this->db->f('url'), 'string'));
         $party->set_org_enhet_id($this->unmarshal($this->db->f('org_enhet_id'), 'string'));
         $party->set_unit_leader($this->unmarshal($this->db->f('unit_leader'), 'string'));
         $sync_message = $party->set_sync_data(array('responsibility_id' => $this->unmarshal($this->db->f('responsibility_id'), 'string'), 'org_enhet_id' => $this->unmarshal($this->db->f('org_enhet_id'), 'string'), 'result_unit_number' => $this->unmarshal($this->db->f('result_unit_number'), 'string')));
         if (isset($sync_message) && $sync_message != '') {
             $party->add_sync_problem($sync_message);
         }
     }
     return $party;
 }
 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;
 }
Beispiel #6
0
$sql_contracts = "SELECT contract_id from rental_invoice, rental_billing where rental_invoice.billing_id = rental_billing.id and rental_billing.id = {$billing_id}";
$this->db->query($sql_contracts, __LINE__, __FILE__);
while ($this->db->next_record()) {
    $contract_ids[] = $this->unmarshal($this->db->f('contract_id'), 'int');
}
foreach ($contract_ids as $contract_id) {
    $sql_parties = "select rental_party.* ";
    $sql_parties .= "from rental_party, rental_contract_party, rental_contract ";
    $sql_parties .= "where rental_contract_party.contract_id = rental_contract.id ";
    $sql_parties .= "and rental_contract_party.is_payer ";
    $sql_parties .= "and rental_party.id = rental_contract_party.party_id ";
    $sql_parties .= "and rental_contract.id = {$contract_id}";
    $this->db->query($sql_parties, __LINE__, __FILE__);
    while ($this->db->next_record()) {
        //generate party-objects
        $party = new rental_party($this->unmarshal($this->db->f('id'), 'string'));
        $party->set_account_number($this->unmarshal($this->db->f('account_number'), 'string'));
        $party->set_address_1($this->unmarshal($this->db->f('address_1'), 'string'));
        $party->set_address_2($this->unmarshal($this->db->f('address_2'), 'string'));
        $party->set_comment($this->unmarshal($this->db->f('comment'), 'string'));
        $party->set_company_name($this->unmarshal($this->db->f('company_name'), 'string'));
        $party->set_department($this->unmarshal($this->db->f('department'), 'string'));
        $party->set_email($this->unmarshal($this->db->f('email'), 'string'));
        $party->set_fax($this->unmarshal($this->db->f('fax'), 'string'));
        $party->set_first_name($this->unmarshal($this->db->f('first_name'), 'string'));
        $party->set_is_inactive($this->unmarshal($this->db->f('is_inactive'), 'bool'));
        $party->set_last_name($this->unmarshal($this->db->f('last_name'), 'string'));
        $party->set_location_id($this->unmarshal($this->db->f('org_location_id'), 'int'));
        $party->set_identifier($this->unmarshal($this->db->f('identifier'), 'string'));
        $party->set_mobile_phone($this->unmarshal($this->db->f('mobile_phone'), 'string'));
        $party->set_place($this->unmarshal($this->db->f('place'), 'string'));
 /**
  * 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']));
 }
 protected function populate(int $invoice_id, &$invoice)
 {
     if ($invoice == null) {
         $invoice = new rental_invoice($this->db->f('id', true), $this->db->f('billing_id', true), $this->db->f('contract_id', true), $this->db->f('timestamp_created', true), $this->db->f('timestamp_start', true), $this->db->f('timestamp_end', true), $this->db->f('total_sum', true), $this->db->f('total_area', true), $this->db->f('header', true), $this->db->f('account_in', true), $this->db->f('account_out', true), $this->db->f('service_id', true), $this->db->f('responsibility_id', true), $this->db->f('project_id', true));
         $invoice->set_party_id($this->unmarshal($this->db->f('party_id'), 'int'));
         $invoice->set_project_id($this->unmarshal($this->db->f('project_id'), 'string'));
         $invoice->set_old_contract_id($this->unmarshal($this->db->f('old_contract_id'), 'string'));
         $invoice->set_term_id($this->unmarshal($this->db->f('term_id'), 'int'));
         $invoice->set_month($this->unmarshal($this->db->f('month'), 'int'));
         $invoice->set_billing_title($this->unmarshal($this->db->f('billing_title'), 'string'));
         $invoice->set_serial_number($this->unmarshal($this->db->f('serial_number'), 'int'));
         $invoice->set_reference($this->unmarshal($this->db->f('reference'), 'string'));
         $party = new rental_party($this->unmarshal($this->db->f('party_id'), 'int'));
         $party->set_account_number($this->unmarshal($this->db->f('party_account_number'), 'string'));
         $party->set_address_1($this->unmarshal($this->db->f('party_address_1'), 'string'));
         $party->set_address_2($this->unmarshal($this->db->f('party_address_2'), 'string'));
         $party->set_comment($this->unmarshal($this->db->f('party_comment'), 'string'));
         $party->set_company_name($this->unmarshal($this->db->f('party_company_name'), 'string'));
         $party->set_department($this->unmarshal($this->db->f('party_department'), 'string'));
         $party->set_email($this->unmarshal($this->db->f('party_email'), 'string'));
         $party->set_fax($this->unmarshal($this->db->f('party_fax'), 'string'));
         $party->set_first_name($this->unmarshal($this->db->f('party_first_name'), 'string'));
         $party->set_is_inactive($this->unmarshal($this->db->f('party_in_active'), 'bool'));
         $party->set_last_name($this->unmarshal($this->db->f('party_last_name'), 'string'));
         $party->set_location_id($this->unmarshal($this->db->f('party_org_location_id'), 'int'));
         $party->set_identifier($this->unmarshal($this->db->f('party_identifier'), 'string'));
         $party->set_mobile_phone($this->unmarshal($this->db->f('party_mobile_phone'), 'string'));
         $party->set_place($this->unmarshal($this->db->f('party_place'), 'string'));
         $party->set_postal_code($this->unmarshal($this->db->f('party_postal_code'), 'string'));
         $party->set_reskontro($this->unmarshal($this->db->f('party_reskontro'), 'string'));
         $party->set_title($this->unmarshal($this->db->f('party_title'), 'string'));
         $party->set_url($this->unmarshal($this->db->f('party_url'), 'string'));
         $invoice->set_party($party);
         if ($invoice->get_term_id() == 2) {
             // yearly
             $invoice->set_term_label(lang('annually'));
         } else {
             if ($invoice->get_term_id() == 3) {
                 // half year
                 if ($invoice->get_month() == 6) {
                     $invoice->set_term_label(lang('first_half'));
                 } else {
                     $invoice->set_term_label(lang('second_half'));
                 }
             } else {
                 if ($invoice->get_term_id() == 4) {
                     // quarterly
                     if ($invoice->get_month() == 3) {
                         $invoice->set_term_label(lang('first_quarter'));
                     } else {
                         if ($invoice->get_month() == 6) {
                             $invoice->set_term_label(lang('second_quarter'));
                         } else {
                             if ($invoice->get_month() == 9) {
                                 $invoice->set_term_label(lang('third_quarter'));
                             } else {
                                 $invoice->set_term_label(lang('fourth_quarter'));
                             }
                         }
                     }
                 } else {
                     $invoice->set_term_label(lang('month ' . $invoice->get_month() . ' capitalized'));
                 }
             }
         }
     }
     $invoice->add_composite_name($this->unmarshal($this->db->f('composite_name'), 'string'));
     return $invoice;
 }