[Added more provisioning logic
Adrian Georgescu <ag@ag-projects.com>**20070830165459] hunk ./cdrlib_ser.phtml 4274
-
hunk ./cdrlib_ser.phtml 4313
-            and traced_user = ''";
+            and traced_user = '' order by id asc";
hunk ./provisioning_logic.phtml 138
-		$this->getAllowedDomains();
hunk ./provisioning_logic.phtml 314
-        // Insert credetials
-        $this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
-        $result     = $this->SOAPEngine->soapclient->getDomains();
-
-        if (PEAR::isError($result)) {
-            $error_msg  = $result->getMessage();
-            $error_fault= $result->getFault();
-            $error_code = $result->getCode();
-            printf ("<p><font color=red>Error: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
-            return false;
-        } else {
-            $this->allowedDomains=$result;
-        }
hunk ./provisioning_logic.phtml 336
+        $this->getAllowedDomains();
hunk ./provisioning_logic.phtml 406
+                <td><b>Action</b></td>
hunk ./provisioning_logic.phtml 442
+
+        			$_url = $this->url.sprintf("&service=%s&action=Delete&number_filter=%s&tld_filter=%s",
+                    urlencode($this->SOAPEngine->service),
+                    urlencode($number->id->number),
+                    urlencode($number->id->tld)
+                    );
+
+                    if ($_REQUEST['action'] == 'Delete' &&
+                        $_REQUEST['number_filter'] == $number->id->number &&
+                        $_REQUEST['tld_filter'] == $number->id->tld) {
+                		$_url .= "&confirm=1";
+                        $actionText = "<font color=red>Confirm</font>";
+                    } else {
+                        $actionText = "Delete";
+                    }
+
hunk ./provisioning_logic.phtml 470
+                            <td><a href=%s>%s</a></td>
hunk ./provisioning_logic.phtml 482
-                            $number->info
+                            $number->info,
+                            $_url,
+                            $actionText
hunk ./provisioning_logic.phtml 531
-        printf (" E.164 number: <input type=text size=10 name=number_filter value='%s'>",$this->filters['number']);
-        printf (" TLD: <input type=text size=10 name=tld_filter value='%s'>",$this->filters['tld']);
+        printf (" E.164 number: <input type=text size=15 name=number_filter value='%s'>",$this->filters['number']);
+        printf (" TLD:");
+        if ($this->allowedDomains) {
+            $selected_tld[$this->filters['tld_filter']]='selected';
+            printf ("<select name=tld_filter>
+            <option>");
+
+            foreach ($this->allowedDomains as $_tld) {
+                printf ("<option value='$_tld' %s>$_tld",$selected_tld[$_tld]);
+            }
+
+            printf ("</select");
+        } else {
+            printf ("<input type=text size=10 name=tld_filter value='%s'>",$this->filters['tld']);
+        }
+
hunk ./provisioning_logic.phtml 552
+    function deleteRecord() {
+        if (!$_REQUEST['confirm']) {
+        	print "<p><font color=red>Please press on Confirm to confirm the delete. </font>";
+            return 1;
+        }
+
+        if (!strlen($this->filters['number']) || !strlen($this->filters['tld'])) {
+            print "<p><font color=red>Error: missing ENUM number or TLD </font>";
+            return 0;
+        }
+
+        $this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
+
+        $enum_id=array('number'=>$this->filters['number'],
+                       'tld'=>$this->filters['tld']);
+        $result     = $this->SOAPEngine->soapclient->deleteNumber($enum_id);
+
+        if (PEAR::isError($result)) {
+            $error_msg  = $result->getMessage();
+            $error_fault= $result->getFault();
+            $error_code = $result->getCode();
+            printf ("<p><font color=red>Error: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
+            return false;
+        } else {
+           printf ("<p><font color=green>ENUM number %s hinder %s as been deleted. </font> ",$this->filters['number'],$this->filters['tld']);
+           unset($this->filters);
+           return 1;
+        }
+    }
+
+    function showAddForm() {
+        print "
+        <p>
+        <table border=0 class=border width=100%>
+        <tr>
+            ";
+            printf ("<form method=post name=addform action=%s>",$_SERVER['PHP_SELF']);
+            print "
+        	<td align=left>
+            ";
+
+            print "
+            <input type=submit name=action value=Add>
+            ";
+            printf (" Number: +<input type=text size=15 name=number>");
+            printf (" Top level domain:");
+            if (is_array($this->allowedDomains)) {
+            	print "<select name=tld>";
+                foreach ($this->allowedDomains as $_tld) {
+                    print "<option value=$_tld>$_tld\n";
+                }
+                print "</select>";
+            } else {
+                print "<input type=text size=15 name=tld>";
+            }
+	        printf (" Service: <input type=text size=5 name=type value='Sip'>");
+    	    printf (" Map to: <input type=text size=25 name=mapto>");
+
+            printf (" TTL: <input type=text size=5 name=ttl value=3600>");
+            printf (" Owner: <input type=text size=5 name=owner>");
+
+            print "
+	        </td>
+        	<td align=right>
+            ";
+            print "
+	        </td>
+            ";
+
+            $this->printHiddenFormElements();
+
+            print "
+            </form>
+        </tr>
+        </table>
+        ";
+    }
+    function getAllowedDomains() {
+        // Insert credetials
+        $this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
+
+        // Call function
+        $result     = $this->SOAPEngine->soapclient->getRanges();
+
+        if (PEAR::isError($result)) {
+            $error_msg  = $result->getMessage();
+            $error_fault= $result->getFault();
+            $error_code = $result->getCode();
+            printf ("<p><font color=red>Error: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
+            return false;
+        } else {
+            foreach($result as $range) {
+            	if (in_array($range->id->tld,$this->allowedDomains)) continue;
+            	$this->allowedDomains[]=$range->id->tld;
+            }
+        }
+    }
+
+    function addRecord() {
+    	$tld    = trim($_REQUEST['tld']);
+        $number = trim($_REQUEST['number']);
+
+		if (!strlen($tld) || !strlen($number)) {
+            printf ("<p><font color=red>Error: Missing TLD or number. </font>");
+            return false;
+        }
+
+		if (!trim($_REQUEST['ttl'])) {
+            $ttl=3600;
+        } else {
+            $ttl=intval(trim($_REQUEST['ttl']));
+        }
+
+        $enum_id=array('number' => $number,
+                       'tld'    => $tld);
+
+        $this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
+        $result     = $this->SOAPEngine->soapclient->getNumber($enum_id);
+
+                        if (PEAR::isError($result)) {
+                            $error_msg=$result->getMessage();
+                            $error_fault=$result->getFault();
+                            $error_code=$result->getCode();
+    
+                            if ($error_fault->detail->exception->errorcode == "3002") {
+                                // addNumber()
+                                $enum_number=array('id'    => $enum_id,
+                                                   'owner' => intval(trim($_REQUEST['owner'])),
+                                                   'mappings' => array(array('type'=>trim($_REQUEST['type']),
+                                                                             'mapto'=>trim($_REQUEST['mapto']),
+                                                                             'ttl'=>intval(trim($_REQUEST['ttl']))
+                                                                            )
+                                                                       )
+                                                   );
+
+        						$this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
+        						$result     = $this->SOAPEngine->soapclient->addNumber($enum_number);
+
+                                if (PEAR::isError($result)) {
+                                    $error_msg=$result->getMessage();
+                                    $error_fault=$result->getFault();
+                                    $error_code=$result->getCode();
+                            		printf ("<p><font color=red>Error1: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
+                                    return false;
+                                } else {
+                                    dprint("SOAP addNumber() OK");
+                                }
+    
+                            } else {
+                                // other error is not allowed
+                            	printf ("<p><font color=red>Error: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
+                                return false;
+                            }
+                        } else {
+                            // the number exists and we make an update
+                            printf ("<p><font color=red>Error: The number already exists</font>");
+                            return 1;
+                        }
+    }
+
hunk ./provisioning_logic.phtml 722
-        $this->filters   = array('number'       => trim($_REQUEST['number_filter']),
-                                 'tld'          => trim($_REQUEST['tld_filter']),
-                                 'type'         => trim($_REQUEST['type_filter']),
-                                 'mapto'        => trim($_REQUEST['mapto_filter']),
-                                 'owner'        => trim($_REQUEST['owner_filter'])
+        $this->filters   = array('prefix'       => trim($_REQUEST['prefix_filter']),
+                                 'tld'          => trim($_REQUEST['tld_filter'])
hunk ./provisioning_logic.phtml 747
-			$this->rows = $result->total;
+			$this->rows = count($result);
hunk ./provisioning_logic.phtml 763
-                <td><b>DNS name</b></td>
hunk ./provisioning_logic.phtml 769
+                <td><b>Action</b></td>
hunk ./provisioning_logic.phtml 787
-                    if (!$result->numbers[$i]) break;
-    
-                    $number = $result->numbers[$i];
+                    $range = $result[$i];
hunk ./provisioning_logic.phtml 800
-                    $j=1;
-                    foreach ($number->mappings as $_mapping) {
-                        if ($j==1) {
+        			$_url = $this->url.sprintf("&service=%s&action=Delete&prefix_filter=%s&tld_filter=%s",
+                    urlencode($this->SOAPEngine->service),
+                    urlencode($range->id->prefix),
+                    urlencode($range->id->tld)
+                    );
+
+                    if ($_REQUEST['action'] == 'Delete' &&
+                        $_REQUEST['prefix_filter'] == $range->id->prefix &&
+                        $_REQUEST['tld_filter'] == $range->id->tld) {
+                		$_url .= "&confirm=1";
+                        $actionText = "<font color=red>Confirm</font>";
+                    } else {
+                        $actionText = "Delete";
+                    }
hunk ./provisioning_logic.phtml 825
-                            <td>%s</td>
+                    		<td><a href=%s>%s</a></td>
hunk ./provisioning_logic.phtml 829
-                            $number->id->number,
-                            $number->id->tld,
-                            $this->tel2enum($number->id->number,$number->id->tld),
-                            ucfirst($_mapping->type),
-                            $_mapping->mapto,
-                            $_mapping->ttl,
-                            $_mapping->priority,
-                            $number->owner,
-                            $number->info
-                            );
-                        } else {
-                            printf("
-                            <tr bgcolor=%s>
-                            <td></td>
-                            <td></td>
-                            <td></td>
-                            <td></td>
-                            <td>%s</td>
-                            <td>%s</td>
-                            <td>%s</td>
-                            <td>%s</td>
-                            <td></td>
-                            <td></td>
-                            </tr>",
-                            $bgcolor,
-                            ucfirst($_mapping->type),
-                            $_mapping->mapto,
-                            $_mapping->ttl,
-                            $_mapping->priority
+                            $range->id->prefix,
+                            $range->id->tld,
+                            $range->ttl,
+                            $range->minDigits,
+                            $range->maxDigits,
+                            $range->used,
+                            $range->owner,
+                            $range->info,
+                            $_url,
+                            $actionText
hunk ./provisioning_logic.phtml 841
-                        }
-                        $j++;
-                    }
-
hunk ./provisioning_logic.phtml 859
-    function showSeachFormCustom() {
+    function deleteRecord() {
+        if (!$_REQUEST['confirm']) {
+        	print "<p><font color=red>Please press on Confirm to confirm the delete. </font>";
+            return 1;
+        }
+
+        if (!strlen($this->filters['prefix']) || !strlen($this->filters['tld'])) {
+            print "<p><font color=red>Error: missing ENUM range id </font>";
+            return 0;
+        }
+
+        $this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
hunk ./provisioning_logic.phtml 872
+        $rangeId=array('prefix'=>$this->filters['prefix'],
+                       'tld'=>$this->filters['tld']);
+        $result     = $this->SOAPEngine->soapclient->deleteRange($rangeId);
+
+        if (PEAR::isError($result)) {
+            $error_msg  = $result->getMessage();
+            $error_fault= $result->getFault();
+            $error_code = $result->getCode();
+            printf ("<p><font color=red>Error: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
+            return false;
+        } else {
+           printf ("<p><font color=green>ENUM range %s under %s has been deleted. </font> ",$this->filters['prefix'],$this->filters['tld']);
+           unset($this->filters);
+           return 1;
+        }
hunk ./provisioning_logic.phtml 889
+    function showAddForm() {
+        print "
+        <p>
+        <table border=0 class=border width=100%>
+        <tr>
+            ";
+            printf ("<form method=post name=addform action=%s>",$_SERVER['PHP_SELF']);
+            print "
+        	<td align=left>
+            ";
+
+            print "
+            <input type=submit name=action value=Add>
+            ";
+            printf (" Prefix: +<input type=text size=5 name=prefix>");
+            printf (" Top level domain: <input type=text size=15 name=tld>");
+            printf (" TTL: <input type=text size=5 name=ttl value=3600>");
+            printf (" Min Digits: <input type=text size=3 name=minDigits value=11>");
+            printf (" Max Digits: <input type=text size=3 name=maxDigits value=11>");
+            printf (" Owner: <input type=text size=10 name=owner>");
+
+            print "
+	        </td>
+        	<td align=right>
+            ";
+            print "
+	        </td>
+            ";
+
+            $this->printHiddenFormElements();
+
+            print "
+            </form>
+        </tr>
+        </table>
+        ";
+    }
+
+    function addRecord() {
+    	$tld    = trim($_REQUEST['tld']);
+        $prefix = trim($_REQUEST['prefix']);
+
+		if (!strlen($tld) || !strlen($prefix)) {
+            printf ("<p><font color=red>Error: Missing TLD or prefix. </font>");
+            return false;
+        }
+
+		if (!trim($_REQUEST['ttl'])) {
+            $ttl=3600;
+        } else {
+            $ttl=intval(trim($_REQUEST['ttl']));
+        }
+        $range=array(
+                     'id'         => array('prefix' => $prefix,
+                                           'tld'    => $tld),
+                     'ttl'        => $ttl,
+                     'minDigits'  => intval(trim($_REQUEST['minDigits'])),
+                     'maxDigits'  => intval(trim($_REQUEST['maxDigits'])),
+                     'owner'      => intval($_REQUEST['owner'])
+        			);
+
+        $this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
+
+        $result     = $this->SOAPEngine->soapclient->addRange($range);
+
+        if (PEAR::isError($result)) {
+            $error_msg  = $result->getMessage();
+            $error_fault= $result->getFault();
+            $error_code = $result->getCode();
+            printf ("<p><font color=red>Error: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
+            return false;
+        } else {
+           printf ("<p><font color=green>Range %s under %s has been added. </font>",$prefix,$tld);
+           return 1;
+        }
+    }
+
+    function showSeachFormCustom() {
+		/*
+        printf (" Prefix: <input type=text size=10 name=prefix_filter value='%s'>",$this->filters['prefix']);
+        printf (" TLD: <input type=text size=15 name=tld_filter value='%s'>",$this->filters['tld']);
+        printf (" Owner: <input type=text size=15 name=owner_filter value='%s'>",$this->filters['owner']);
+        */
+    }
hunk ./provisioning_logic.phtml 2232
-                <td><b>Caller Id</b></td>
+                <td><b>PSTN CLI</b></td>
+                <td><b>Quota</b></td>
hunk ./provisioning_logic.phtml 2313
+                    <td>%s</td>
hunk ./provisioning_logic.phtml 2327
+                    $account->quota,
hunk ./provisioning_logic.phtml 2548
+    function getAllowedDomains() {
+        // Insert credetials
+        $this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
+        $result     = $this->SOAPEngine->soapclient->getDomains();
+
+        if (PEAR::isError($result)) {
+            $error_msg  = $result->getMessage();
+            $error_fault= $result->getFault();
+            $error_code = $result->getCode();
+            printf ("<p><font color=red>Error: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
+            return false;
+        } else {
+            $this->allowedDomains=$result;
+        }
+    }
+
hunk ./provisioning_logic.phtml 2893
+    function getAllowedDomains() {
+        // Insert credetials
+        $this->SOAPEngine->soapclient->addHeader($this->SOAPEngine->SoapAuth);
+        $result     = $this->SOAPEngine->soapclient->getDomains();
+
+        if (PEAR::isError($result)) {
+            $error_msg  = $result->getMessage();
+            $error_fault= $result->getFault();
+            $error_code = $result->getCode();
+            printf ("<p><font color=red>Error: %s (%s): %s</font>",$error_msg, $error_fault->detail->exception->errorcode,$error_fault->detail->exception->errorstring);
+            return false;
+        } else {
+            $this->allowedDomains=$result;
+        }
+    }
+
hunk ./provisioning_logic.phtml 3163
-                <td><b>SIP domain</b></td>
+                <td><b>Domain</b></td>
+                <td><b>Reseller</b></td>
hunk ./provisioning_logic.phtml 3212
+                    <td>%s</td>
hunk ./provisioning_logic.phtml 3218
+                    $reseller,