%s", + $this->SoapEngine->ports[$this->SoapEngine->port]['description'], + '%' + ); + + printf ("
+ "; + } + + function listRecords() { + + // Filter + $filter=array('username' => $this->filters['username'], + 'firstName' => $this->filters['firstName'], + 'lastName' => $this->filters['lastName'], + 'organization' => $this->filters['organization'], + 'tel' => $this->filters['tel'], + 'email' => $this->filters['email'], + 'web' => $this->filters['web'], + 'city' => $this->filters['city'], + 'country' => $this->filters['country'], + 'only_resellers' => $this->filters['only_resellers'], + 'customer' => intval($this->filters['customer']), + 'reseller' => intval($this->filters['reseller']) + ); + + //print_r($filter); + + // Range + $range=array('start' => intval($this->next), + 'count' => intval($this->maxrowsperpage) + ); + + // Order + if (!$this->sorting['sortBy']) $this->sorting['sortBy'] = 'changeDate'; + if (!$this->sorting['sortOrder']) $this->sorting['sortOrder'] = 'DESC'; + + $orderBy = array('attribute' => $this->sorting['sortBy'], + 'direction' => $this->sorting['sortOrder'] + ); + + // Compose query + $Query=array('filter' => $filter, + 'orderBy' => $orderBy, + 'range' => $range + ); + + $this->showSeachForm(); + + if ($this->showAddForm) { + $this->showAddForm(); + return true; + } + + // Insert credetials + $this->SoapEngine->soapclient->addHeader($this->SoapEngine->SoapAuth); + + // Call function + if ($this->adminonly && $this->filters['only_resellers']) { + $this->log_action('getResellers'); + $result = $this->SoapEngine->soapclient->getResellers($Query); + } else { + $this->log_action('getCustomers'); + $result = $this->SoapEngine->soapclient->getCustomers($Query); + } + + if ((new PEAR)->isError($result)) { + $error_msg = $result->getMessage(); + $error_fault= $result->getFault(); + $error_code = $result->getCode(); + $log=sprintf("SOAP request error from %s: %s (%s): %s",$this->SoapEngine->SOAPurl,$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring); + syslog(LOG_NOTICE, $log); + return false; + } else { + + $this->rows = $result->total; + + if ($this->rows && $_REQUEST['action'] != 'PerformActions' && $_REQUEST['action'] != 'Delete') { + $this->showActionsForm(); + } + + print " +| + | Id | +Impersonate | +Username | +Name | +Organization | +Country | +Phone number | +Change date | +Actions | +|
|---|---|---|---|---|---|---|---|---|---|---|
| %s | +%s.%s | +%s | +%s | +%s %s | +%s | +%s | +%s | +%s | +%s | +%s + ", + $index, + $_customer_url, + $customer->id, + $customer->reseller, + $customer->impersonate, + strip_tags($customer->username), + strip_tags($customer->firstName), + strip_tags($customer->lastName), + strip_tags($customer->organization), + strip_tags($customer->country), + strip_tags($customer->email), + strip_tags($customer->email), + $customer->tel, + $customer->changeDate, + $_url, + $actionText + ); + + $this->showExtraActions($customer); + print " | +
Please press on Confirm to confirm the delete. "; + return true; + } + + if ($dictionary['customer']) { + $customer=$dictionary['customer']; + } else { + $customer=$this->filters['customer']; + } + + if (!strlen($customer)) { + print "
Error: missing customer id. "; + return false; + } + + $function=array('commit' => array('name' => 'deleteAccount', + 'parameters' => array(intval($customer)), + 'logs' => array('success' => sprintf('Customer id %s has been deleted',$this->filters['customer']))) + ); + if ($this->SoapEngine->execute($function,$this->html)) { + unset($this->filters); + return true; + + } else { + return false; + } + + } + + function getRecord($id) { + + $this->SoapEngine->soapclient->addHeader($this->SoapEngine->SoapAuth); + $this->log_action('getAccount'); + $result = $this->SoapEngine->soapclient->getAccount(intval($id)); + + if ((new PEAR)->isError($result)) { + $error_msg = $result->getMessage(); + $error_fault= $result->getFault(); + $error_code = $result->getCode(); + $log=sprintf("SOAP request error from %s: %s (%s): %s",$this->SoapEngine->SOAPurl,$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring); + syslog(LOG_NOTICE, $log); + return false; + } else { + return $result; + } + } + + function showRecordHeader($customer) { + } + + function showRecordFooter($customer) { + } + + function showExtraActions($customer) { + } + + function showRecord($customer) { + //dprint_r($customer); + + $this->showRecordHeader($customer); + + print "
Updating customer ..."; + + if (!strlen($this->filters['customer'])) { + return false; + } + + if (!$customer=$this->getRecord($this->filters['customer'])) { + return false; + } + + if ($_REQUEST['notify']) { + + $customer_notify=array('firstName'=> $customer->firstName, + 'lastName' => $customer->lastName, + 'email' => $customer->email, + 'username' => $customer->username, + 'password' => $customer->password + ); + + if ($this->notify($customer_notify)) { + print "
"; + printf (_("The login account details have been sent to %s"), $customer->email); + return true; + } else { + print "
"; + printf (_("Error sending e-mail notification")); + return false; + } + } + + if (!$this->updateBefore($customer)) { + return false; + } + + $customer->credit = floatval($customer->credit); + $customer->balance = floatval($customer->balance); + + foreach ($customer->properties as $_property) { + $properties[]=$_property; + } + + if (is_array($properties)) { + $customer->properties=$properties; + } else { + $customer->properties=array(); + } + + $customer_old = $customer; + + // update properties + + foreach (array_keys($this->allProperties) as $item) { + $var_name = $item.'_form'; + + $updated_property=array(); + + foreach (array_keys($customer->properties) as $_key) { + $_property=$customer->properties[$_key]; + + if ($_property->name == $item) { + // update property + + if ($_property->permission == 'admin') { + if ($this->login_credentials['login_type'] == 'admin') { + $customer->properties[$_key]->value=trim($_REQUEST[$var_name]); + } else if ($this->login_credentials['login_type'] == 'reseller' && $this->allProperties[$item]['resellerMayManageForChildAccounts']) { + if ($customer->id != $customer->reseller) { + $customer->properties[$_key]->value=trim($_REQUEST[$var_name]); + } + } + } else if ($_property->permission == 'reseller') { + if ($this->login_credentials['login_type'] == 'admin' || $this->login_credentials['login_type'] == 'reseller') { + $customer->properties[$_key]->value=trim($_REQUEST[$var_name]); + } + } else { + $customer->properties[$_key]->value=trim($_REQUEST[$var_name]); + if ($_key == 'yubikey' && $_REQUEST[$var_name] != '') { + $customer->properties[$_key]->value = substr($customer->properties[$_key]->value,0,12); + } + } + + + $updated_property[$item]++; + + break; + } + } + + if (!$updated_property[$item] && strlen($_REQUEST[$var_name])) { + // add new property + + unset($var_value); + unset($_permission); + + if ($this->allProperties[$item]['permission'] == 'admin') { + $_permission = 'admin'; + + if ($this->login_credentials['login_type'] == 'admin') { + $var_value = trim($_REQUEST[$var_name]); + } else if ($this->login_credentials['login_type'] == 'reseller' && $this->allProperties[$item]['resellerMayManageForChildAccounts']) { + if ($customer->id != $customer->reseller) { + $var_value = trim($_REQUEST[$var_name]); + } + } + } else if ($this->allProperties[$item]['permission'] == 'reseller') { + $_permission = 'reseller'; + + if ($this->login_credentials['login_type'] == 'admin' || $this->login_credentials['login_type'] == 'reseller') { + $var_value = trim($_REQUEST[$var_name]); + } + } else { + $_permission = 'customer'; + $var_value = trim($_REQUEST[$var_name]); + } + + if (strlen($var_value)) { + if ($item == 'yubikey' ) { + $var_value = substr($var_value,0,12); + } + $customer->properties[] = array('name' => $item, + 'value' => $var_value, + 'category' => $this->allProperties[$item]['category'], + 'permission' => $this->allProperties[$item]['permission'] + ); + } + } + } + /* + print "
"; + print_r($customer->properties); + print ""; + */ + + foreach (array_keys($this->Fields) as $item) { + $var_name=$item.'_form'; + //printf ("
Copy customer ..."; + + if (!strlen($this->filters['customer'])) { + return false; + } + + if (!$_REQUEST['confirm']) { + print "
Please press on Copy again to confirm the copy"; + return true; + } + + if (!$customer=$this->getRecord($this->filters['customer'])) { + return false; + } + + $customer->credit = floatval($customer->credit); + $customer->balance = floatval($customer->balance); + + foreach ($customer->properties as $_property) { + $properties[]=$_property; + } + + if (is_array($properties)) { + $customer->properties=$properties; + } else { + $customer->properties=array(); + } + + // change username + $customer_new=$customer; + unset($customer_new->id); + + $j=1; + while ($j < 9) { + + $customer_new->username=$customer->username.$j; + + $function=array('commit' => array('name' => 'addAccount', + 'parameters' => array($customer_new), + 'logs' => array('success' => sprintf('Customer id %s has been copied',$customer->id))) + ); + + if ($this->SoapEngine->execute($function,$this->html)) { + // Reset filters to find the copy + $this->filters=array(); + $this->filters['username']=$customer_new->username; + + return true; + } else { + if ($this->SoapEngine->error_fault->detail->exception->errorcode != "5001") { + return false; + } + } + + $j++; + } + } + + function showAddForm($confirmPassword=false) { + + print "
"; + print _("Accounts are used for login and to assign ownership to data created in the platform. "); + printf ("
"; + print " +%s at %s as %s ", $this->soap_class, $this->SOAPurl, $this->SOAPurl, $this->soapUsername ); dprint($log); $this->SoapAuth = array('auth', $this->SOAPlogin , 'urn:AGProjects:NGNPro', 0, ''); $this->SoapAuthAdmin = array('auth', $this->SOAPloginAdmin , 'urn:AGProjects:NGNPro', 0, ''); // Instantiate the SOAP client if (!class_exists($this->soap_class)) return ; $this->soapclient = new $this->soap_class($this->SOAPurl); $this->soapclient->setOpt('curl', 'CURLOPT_SSL_VERIFYPEER', 0); $this->soapclient->setOpt('curl', 'CURLOPT_SSL_VERIFYHOST', 0); // set the timeout $this->soapclient->_options['timeout'] = $this->timeout; if ($this->customer_engine) { $this->SOAPloginCustomers = array( "username" => $this->soapEngines[$this->customer_engine]['username'], "password" => $this->soapEngines[$this->customer_engine]['password'], "admin" => true, "impersonate" => intval($this->reseller) ); $this->SoapAuthCustomers = array('auth', $this->SOAPloginCustomers , 'urn:AGProjects:NGNPro', 0, ''); $this->SOAPurlCustomers = $this->soapEngines[$this->customer_engine]['url']; $this->soapclientCustomers = new WebService_NGNPro_CustomerPort($this->SOAPurlCustomers); $this->soapclientCustomers->setOpt('curl', 'CURLOPT_SSL_VERIFYPEER', 0); $this->soapclientCustomers->setOpt('curl', 'CURLOPT_SSL_VERIFYHOST', 0); if (strlen($this->soapEngines[$this->customer_engine]['timeout'])) { $this->soapclientCustomers->_options['timeout'] = intval($this->soapEngines[$this->customer_engine]['timeout']); } else { $this->soapclientCustomers->_options['timeout'] = $this->timeout; } } if ($this->voicemail_engine) { $this->SOAPloginVoicemail = array( "username" => $this->soapEngines[$this->voicemail_engine]['username'], "password" => $this->soapEngines[$this->voicemail_engine]['password'], "admin" => true, "impersonate" => intval($this->reseller) ); $this->SoapAuthVoicemail = array('auth', $this->SOAPloginVoicemail , 'urn:AGProjects:NGNPro', 0, ''); $this->SOAPurlVoicemail = $this->soapEngines[$this->voicemail_engine]['url']; $this->soapclientVoicemail = new WebService_NGNPro_VoicemailPort($this->SOAPurlVoicemail); $this->soapclientVoicemail->setOpt('curl', 'CURLOPT_SSL_VERIFYPEER', 0); $this->soapclientVoicemail->setOpt('curl', 'CURLOPT_SSL_VERIFYHOST', 0); if (strlen($this->soapEngines[$this->voicemail_engine]['timeout'])) { $this->soapclientVoicemail->_options['timeout'] = intval($this->soapEngines[$this->voicemail_engine]['timeout']); } else { $this->soapclientVoicemail->_options['timeout'] = $this->timeout; } } } else { print "Error: No SOAP credentials defined."; } $this->url = $_SERVER['PHP_SELF']."?1=1"; foreach (array_keys($this->extraFormElements) as $element) { if (!strlen($this->extraFormElements[$element])) continue; $this->url .= sprintf( '&%s=%s', $element, urlencode($this->extraFormElements[$element]) ); } $this->support_email = $this->soapEngines[$this->soapEngine]['support_email']; $this->support_web = $this->soapEngines[$this->soapEngine]['support_web']; $this->welcome_message = $this->soapEngines[$this->soapEngine]['welcome_message']; } /** * returns a list of allowed engines based on a filter * the filter format is: * engine1:port1,port2 engine2 engine3:port1 */ public function getSoapEngineAllowed($soapEngines, $filter) { if (!$filter) { $soapEngines_checked = $soapEngines; } else { $_filter_els = explode(" ", $filter); foreach (array_keys($soapEngines) as $_engine) { foreach ($_filter_els as $_filter) { unset($_allowed_engine); $_allowed_ports = array(); list($_allowed_engine, $_allowed_ports_els) = explode(":", $_filter); if ($_allowed_ports_els) { $_allowed_ports = explode(",", $_allowed_ports_els); } if (count($_allowed_ports) == 0) { $_allowed_ports = array_keys($this->ports); } if ($_engine == $_allowed_engine) { $soapEngines_checked[$_engine] = $soapEngines[$_engine]; $this->allowedPorts[$_engine] = $_allowed_ports; continue; } } } } return $soapEngines_checked; } /** * $function = array( * 'commit' => array( * 'name' => 'addAccount', * 'parameters' => array( * $param1, * $param2 * ), * 'logs' => array( * 'success' => 'The function was a success', * 'failure' => 'The function has failed' * ) * ) * ); */ public function execute($function, $html = true, $adminonly = false) { if (!$function['commit']['name']) { if ($html) { print "Error: no function name supplied"; } else { print "Error: no function name supplied\n"; } return false; } if ($adminonly) { $this->soapclient->addHeader($this->SoapAuthAdmin); } else { $this->soapclient->addHeader($this->SoapAuth); } $result = call_user_func_array( array( $this->soapclient, $function['commit']['name'] ), $function['commit']['parameters'] ); if ((new PEAR)->isError($result)) { $this->error_msg = $result->getMessage(); $this->error_fault = $result->getFault(); $this->error_code = $result->getCode(); $this->exception = $this->error_fault->detail->exception; $log = sprintf( "SOAP request error from %s: %s (%s): %s", $this->SOAPurl, $this->error_msg, $this->error_fault->detail->exception->errorcode, $this->error_fault->detail->exception->errorstring ); syslog(LOG_NOTICE, $log); if ($html) { $log = sprintf( "SOAP query failed: %s (%s): %s", $this->error_msg, $this->error_fault->detail->exception->errorcode, $this->error_fault->detail->exception->errorstring ); print "$log"; } return false; } else { $this->result = $result; if ($function['commit']['logs']['success']) { if ($html) { printf( "
%s \n", htmlentities($function['commit']['logs']['success']) ); } } if (is_object($result) || strlen($result)) { return $result; } else { return true; } } } } class Records { public $maxrowsperpage = '20'; public $sip_settings_page = 'sip_settings.phtml'; public $allowedDomains = array(); public $selectionActive = false; public $selectionKeys = array(); public $resellers = array(); public $customers = array(); public $record_generator = false; public $customer_properties = array(); public $loginProperties = array(); public $errorMessage = ''; public $html = true; public $filters = array(); public $selectionActiveExceptions = array(); public function log_action($action = 'Unknown') { global $CDRTool; $location = "Unknown"; $_loc = geoip_record_by_name($_SERVER['REMOTE_ADDR']); if ($_loc['country_name']) { $location = $_loc['country_name']; } $log = sprintf( "CDRTool login username=%s, type=%s, impersonate=%s, IP=%s, location=%s, action=%s:%s, script=%s", $this->login_credentials['username'], $this->login_credentials['login_type'], $CDRTool['impersonate'], $_SERVER['REMOTE_ADDR'], $location, $this->SoapEngine->port, $action, $_SERVER['PHP_SELF'] ); syslog(LOG_NOTICE, $log); } public function soapHasError($result) { return (new PEAR)->isError($result); } public function checkLogSoapError($result, $syslog = false, $print = false) { if (!$this->soapHasError($result)) { return false; } $error_msg = $result->getMessage(); $error_fault= $result->getFault(); $error_code = $result->getCode(); if ($syslog) { $log = sprintf( "SOAP request error from %s: %s (%s): %s", $this->SoapEngine->SOAPurl, $error_msg, $error_fault->detail->exception->errorcode, $error_fault->detail->exception->errorstring ); syslog(LOG_NOTICE, $log); if ($print) { printf("
Error: $log"); } } else { printf( "Error: %s (%s): %s", $error_msg, $error_fault->detail->exception->errorcode, $error_fault->detail->exception->errorstring ); } return true; } public function buildUrl($data) { return sprintf( "%s&%s", $this->url, http_build_query($data) ); } public function __construct($SoapEngine) { $this->SoapEngine = $SoapEngine; $this->version = $this->SoapEngine->version; $this->login_credentials = $this->SoapEngine->login_credentials; $this->sorting['sortBy'] = trim($_REQUEST['sortBy']); $this->sorting['sortOrder'] = trim($_REQUEST['sortOrder']); $this->next = $_REQUEST['next']; $this->adminonly = $this->SoapEngine->adminonly; $this->reseller = $this->SoapEngine->reseller; $this->customer = $this->SoapEngine->customer; $this->impersonate = $this->SoapEngine->impersonate; $this->url = $this->SoapEngine->url; foreach (array_keys($this->filters) as $_filter) { if (strlen($this->filters[$_filter]) && !in_array($_filter, $this->selectionActiveExceptions)) { $this->selectionActive = true; break; } } if ($this->adminonly) { $this->url .= sprintf('&adminonly=%s', $this->adminonly); if ($this->login_credentials['reseller']) { $this->filters['reseller'] = $this->login_credentials['reseller']; } else { $this->filters['reseller'] = trim($_REQUEST['reseller_filter']); } } $this->filters['customer'] = trim($_REQUEST['customer_filter']); //$this->getResellers(); $this->getCustomers(); $this->getLoginAccount(); if (strlen($this->SoapEngine->sip_settings_page)) { $this->sip_settings_page = $this->SoapEngine->sip_settings_page; } if (strlen($this->SoapEngine->digest_settings_page)) { $this->digest_settings_page = $this->SoapEngine->digest_settings_page; } $this->support_email = $this->SoapEngine->support_email; $this->support_web = $this->SoapEngine->support_web; } function showEngineSelection() { $selected_soapEngine[$this->SoapEngine->service] =' selected'; $pstn_access = $this->getCustomerProperty('pstn_access'); printf(""); printf( "", $this->url ); } function showAfterEngineSelection() { } function showCustomerSelection() { $this->showCustomerForm(); } function showResellerSelection() { if ($this->adminonly) { $this->showResellerForm(); } else { printf("%s", $this->reseller); } } function showPagination($maxrows) { $url .= $this->url.'&'.$this->addFiltersToURL().sprintf( "&service=%s&sortBy=%s&sortOrder=%s", urlencode($this->SoapEngine->service), urlencode($this->sorting['sortBy']), urlencode($this->sorting['sortOrder']) ); print "
%s", $this->SoapEngine->ports[$this->SoapEngine->port]['description'] ); printf( "