function UpdateCustomer($dane)
{
if ($dane['invoice'] == '1') {
$dane['issue_invoice'] = 't';
} else {
$dane['issue_invoice'] = 'f';
}
$invoice = $dane['invoice'];
unset($dane['invoice']);
if (HiperusActions::ChangeCustomerData($dane)) {
usleep(500000);
$oldname = $this->DB->GetOne('SELECT name FROM hv_customers WHERE id=' . $dane['id'] . ' LIMIT 1 ;');
$dane = HiperusActions::GetCustomerData($dane['id']);
$dane['invoice'] = $invoice;
$this->DB->Execute('UPDATE hv_customers SET name=?, id_reseller=?, email=?, address=?, street_number=?, apartment_number=?, postcode=?, city=?, country=?, b_name=?,
b_address=?, b_street_number=?, b_apartment_number=?, b_postcode=?,b_city=?,b_country=?,b_nip=?,b_regon=?,ext_billing_id=?,issue_invoice=?,id_default_pricelist=?,
id_default_balance=?,payment_type=?,is_wlr=?,active=?,create_date=?, consent_data_processing=?,platform_user_add_stamp=?,open_registration=?,is_removed=? WHERE id=? ;', array(!empty($dane['name']) ? $dane['name'] : NULL, !empty($dane['id_reseller']) ? $dane['id_reseller'] : NULL, !empty($dane['email']) ? $dane['email'] : NULL, !empty($dane['address']) ? $dane['address'] : NULL, !empty($dane['street_number']) ? $dane['street_number'] : NULL, !empty($dane['apartment_number']) ? $dane['apartment_number'] : NULL, !empty($dane['postcode']) ? $dane['postcode'] : NULL, !empty($dane['city']) ? $dane['city'] : NULL, !empty($dane['country']) ? $dane['country'] : NULL, !empty($dane['b_name']) ? $dane['b_name'] : NULL, !empty($dane['b_address']) ? $dane['b_address'] : NULL, !empty($dane['b_street_number']) ? $dane['b_street_number'] : NULL, !empty($dane['b_apartment_number']) ? $dane['b_apartment_number'] : NULL, !empty($dane['b_postcode']) ? $dane['b_postcode'] : NULL, !empty($dane['b_city']) ? $dane['b_city'] : NULL, !empty($dane['b_country']) ? $dane['b_country'] : NULL, !empty($dane['b_nip']) ? $dane['b_nip'] : NULL, !empty($dane['b_regon']) ? $dane['b_regon'] : NULL, !empty($dane['ext_billing_id']) ? $dane['ext_billing_id'] : NULL, !empty($dane['issue_invoice']) ? $dane['issue_invoice'] : 'f', !empty($dane['id_default_pricelist']) ? $dane['id_default_pricelist'] : NULL, !empty($dane['id_default_balance']) ? $dane['id_default_balance'] : NULL, !empty($dane['payment_type']) ? $dane['payment_type'] : 'postpaid', !empty($dane['is_wlr']) ? $dane['is_wlr'] : 'f', !empty($dane['active']) ? $dane['active'] : 't', !empty($dane['create_date']) ? $dane['create_date'] : NULL, !empty($dane['consent_data_processing']) ? $dane['consent_data_processing'] : 'f', !empty($dane['platform_user_add_stamp']) ? $dane['platform_user_add_stamp'] : NULL, !empty($dane['open_registration']) ? $dane['open_registration'] : 'f', !empty($dane['is_removed']) ? $dane['is_removed'] : 'f', $dane['id']));
$this->DB->Execute('UPDATE hv_assign SET keytype=?, keyvalue=? WHERE customerid=? ;', array('issue_invoice', $invoice, $dane['id']));
if ($dane['name'] !== $oldname) {
$this->DB->Execute('UPDATE hv_billing SET customer_name=? WHERE customer_name=? ;', array($dane['name'], $oldname));
$this->DB->Execute('UPDATE hv_terminal SET customer_name=? WHERE customer_name=? ;', array($dane['name'], $oldname));
$this->DB->Execute('UPDATE hv_pstnusage SET customer_name=? WHERE customer_name=? ;', array($dane['name'], $oldname));
}
unset($oldname);
unset($dane);
return true;
} else {
return false;
}
}
public static function GetCustomerDataExtID($ext_billing_id)
{
$hlib = new HiperusLib();
$r = new stdClass();
$r->ext_billing_id = $ext_billing_id;
$response = $hlib->sendRequest("GetCustomerIDByExtBillingID", $r);
if (!$response->success) {
throw new Exception("Nie można pobrać danych klienta bazując na identyfikatorze z systemu zewnętrznego.\n" . $response->error_message);
}
$id_customer = $response->result_set[0]['id'];
return HiperusActions::GetCustomerData($id_customer);
}
