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); }