[Freeswitch-svn] [commit] r12608 - in freeswitch/trunk/scripts/contrib/swk: flex/amf-test1/src php/amfphp

15 Mar 2009

Author: silik0n
Date: Sun Mar 15 00:24:32 2009
New Revision: 12608

Log:
getting closer to something worth looking at DB is getting pretty close to being required (some functions will now fail if you dont have the DB setup)

Modified:
   freeswitch/trunk/scripts/contrib/swk/flex/amf-test1/src/main.mxml
   freeswitch/trunk/scripts/contrib/swk/php/amfphp/freeswitch.php

Modified: freeswitch/trunk/scripts/contrib/swk/flex/amf-test1/src/main.mxml
==============================================================================

--- freeswitch/trunk/scripts/contrib/swk/flex/amf-test1/src/main.mxml	(original)
+++ freeswitch/trunk/scripts/contrib/swk/flex/amf-test1/src/main.mxml	Sun Mar 15 00:24:32 2009
@@ -62,6 +62,45 @@
 					PopUpManager.createPopUp(this, statusForm, false);
 			}
 			
+			public function addDomainParam():void {
+				freeswitch.addDirDomainParam(gridDomainsDomain.selectedItem.uid, inputDomainParamName.text, inputDomainParamValue.text);
+				freeswitch.getDirDomain(gridDomainsDomain.selectedItem.uid);
+			}
+			
+			public function addDomainVar():void {
+				freeswitch.addDirDomainVar(gridDomainsDomain.selectedItem.uid, inputDomainVarName.text, inputDomainVarValue.text);
+				freeswitch.getDirDomain(gridDomainsDomain.selectedItem.uid);
+			}
+			
+			public function dgChangeDomainParam():void {
+				freeswitch.updateDirDomainParam(dgDomainParam.selectedItem.uid, dgDomainParam.selectedItem.name, dgDomainParam.value);
+				freeswitch.getDirDomain(gridDomainsDomain.selectedItem.uid);
+			}
+			
+			public function dgChangeDomainVars():void {
+				freeswitch.updateDirDomainVar(dgDomainVars.selectedItem.uid, dgDomainVars.selectedItem.name, dgDomainVars.value);
+				freeswitch.getDirDomain(gridDomainsDomain.selectedItem.uid);
+			}
+			
+			public function addDomainUserParam():void {
+				freeswitch.addDirDomainUserParam(gridDomainsDomain.selectedItem.uid, inputDomainParamName.text, inputDomainParamValue.text);
+				freeswitch.getDirDomain(gridDomainsDomain.selectedItem.uid);
+			}
+			
+			public function addDomainUserVar():void {
+				freeswitch.addDirDomainUserVar(gridDomainsDomain.selectedItem.uid, inputDomainVarName.text, inputDomainVarValue.text);
+				freeswitch.getDirDomain(gridDomainsDomain.selectedItem.uid);
+			}
+			
+			public function dgChangeDomainUserParam():void {
+				freeswitch.updateDirDomainUserParam(dgDomainParam.selectedItem.uid, dgDomainParam.selectedItem.name, dgDomainParam.value);
+				freeswitch.getDirDomain(gridDomainsDomain.selectedItem.uid);
+			}
+			
+			public function dgChangeDomainUserVars():void {
+				freeswitch.updateDirDomainUserParam(dgDomainVars.selectedItem.uid, dgDomainVars.selectedItem.name, dgDomainVars.value);
+				freeswitch.getDirDomain(gridDomainsDomain.selectedItem.uid);
+			}
 			           
         ]]>
     </mx:Script>
@@ -165,18 +204,32 @@
                 			<mx:Label text="Name:" horizontalCenter="-129" top="12"/>
                 			<mx:TextInput id="domainName" text="{gridDomainsDomain.selectedItem.name}" horizontalCenter="25" top="10"/>
                 			<mx:CheckBox label="Enabled" id="domainEnabled" enabled="{gridDomainsDomain.selectedItem.enabled}" right="10" top="8"/>
-                			<mx:DataGrid left="10" top="61" bottom="42" width="45%" dataProvider="{freeswitch.getDirDomain.lastResult.params}">
+                			<mx:DataGrid left="10" top="40" bottom="116" width="45%" dataProvider="{freeswitch.getDirDomain.lastResult.params}"
+                				itemEditEnd="dgChangeDomainParam();" editable="true" id="dgDomainParam">
                 				<mx:columns>
                 					<mx:DataGridColumn headerText="Parameter" dataField="name" width="120"/>
                 					<mx:DataGridColumn headerText="Value" dataField="value"/>
                 				</mx:columns>
                 			</mx:DataGrid>
-                			<mx:DataGrid right="10" top="61" bottom="42" width="45%" dataProvider="{freeswitch.getDirDomain.lastResult.variables}">
+                			<mx:DataGrid right="10" top="40" bottom="116" width="45%" dataProvider="{freeswitch.getDirDomain.lastResult.variables}" 
+                				itemEditEnd="dgChangeDomainVars();" editable="true" id="dgDomainVars">
                 				<mx:columns>
                 					<mx:DataGridColumn headerText="Variable" dataField="name" width="120"/>
                 					<mx:DataGridColumn headerText="Data" dataField="value"/>
                 				</mx:columns>
                 			</mx:DataGrid>
+                			<mx:Button label="Refresh Domain" bottom="10" horizontalCenter="-52"/>
+                			<mx:Button label="Add Parameter" left="149" bottom="40" click="addDomainParam()"/>
+                			<mx:Button label="Add Variable" bottom="40" right="168" width="99" click="addDomainVar()"/>
+                			<mx:Button label="Add Domain" bottom="10" horizontalCenter="63"/>
+                			<mx:Label text="Parameter" bottom="90" left="10"/>
+                			<mx:TextInput width="121" id="inputDomainParamName" bottom="70" left="10"/>
+                			<mx:TextInput width="272" id="inputDomainParamValue" bottom="70" left="139"/>
+                			<mx:Label text="Variable" bottom="90" right="361"/>
+                			<mx:TextInput width="121" id="inputDomainVarName" bottom="70" right="290"/>
+                			<mx:TextInput width="272" id="inputDomainVarValue" bottom="70" right="10"/>
+                			<mx:Label text="Data" bottom="90" right="251"/>
+                			<mx:Label text="Value" bottom="90" left="139"/>
 		                </mx:Canvas>
 		            </mx:HDividedBox>                
                 </mx:Canvas>
@@ -184,7 +237,8 @@
 	                <mx:HDividedBox x="0" y="0" width="100%" height="100%">
 		                <mx:Canvas width="20%" height="100%">
 		                    <mx:ComboBox id="userDomain" top="10" horizontalCenter="0" dataProvider="{freeswitch.getDirDomains.lastResult}" labelField="name"></mx:ComboBox>
-		                    <mx:DataGrid width="100%" horizontalCenter="0" top="40" bottom="70" dataProvider="{freeswitch.getDirUsers.lastResult}">
+		                    <mx:DataGrid id="dgDomainUsers" width="100%" horizontalCenter="0" top="40" bottom="70" dataProvider="{freeswitch.getDirUsers.lastResult}"
+		                    	click="freeswitch.getDirUser(dgDomainUsers.selectedItem.uid)">
 		                        <mx:columns>
 		                            <mx:DataGridColumn headerText="User" dataField="username" />
 		                        </mx:columns>
@@ -193,8 +247,37 @@
 		                    <mx:Button label="Refresh Domains" horizontalCenter="0" bottom="40" click="freeswitch.getDirDomains();"/>
 		                </mx:Canvas>
 		                <mx:Canvas width="80%" height="100%">
-		                	<mx:Form id="formUser" x="0" y="0" width="100%" height="100%">
-		                	</mx:Form>
+		                	<mx:Label text="UID:" horizontalCenter="-421" top="10"/>
+                			<mx:Label text="{dgDomainUsers.selectedItem.uid}" id="userUid" horizontalCenter="-339" top="10"/>
+                			<mx:Label text="Name:" horizontalCenter="-129" top="12"/>
+                			<mx:TextInput id="userName" text="{dgDomainUsers.selectedItem.username}" horizontalCenter="25" top="10"/>
+                			<mx:CheckBox label="Enabled" id="userEnabled" enabled="{dgDomainUsers.selectedItem.enabled}" right="10" top="8"/>
+                			<mx:DataGrid left="10" top="40" bottom="116" width="45%" dataProvider="{freeswitch.getDirUser.lastResult.params}"
+                				change="dgChangeDomainUserParam();" editable="true" id="dgDomainUserParam">
+                				<mx:columns>
+                					<mx:DataGridColumn headerText="Parameter" dataField="name" width="120"/>
+                					<mx:DataGridColumn headerText="Value" dataField="value"/>
+                				</mx:columns>
+                			</mx:DataGrid>
+                			<mx:DataGrid right="10" top="40" bottom="116" width="45%" dataProvider="{freeswitch.getDirUser.lastResult.variables}" 
+                				change="dgChangeDomainVars();" editable="true" id="dgDomainUserVars">
+                				<mx:columns>
+                					<mx:DataGridColumn headerText="Variable" dataField="name" width="120"/>
+                					<mx:DataGridColumn headerText="Data" dataField="value"/>
+                				</mx:columns>
+                			</mx:DataGrid>
+                			<mx:Button label="Refresh Domain" bottom="10" horizontalCenter="-52"/>
+                			<mx:Button label="Add Parameter" left="149" bottom="40" click="addDomainUserParam()"/>
+                			<mx:Button label="Add Variable" bottom="40" right="168" width="99" click="addDomainUserVar()"/>
+                			<mx:Button label="Add Domain" bottom="10" horizontalCenter="63"/>
+                			<mx:Label text="Parameter" bottom="90" left="10"/>
+                			<mx:TextInput width="121" id="inputDomainUserParamName" bottom="70" left="10"/>
+                			<mx:TextInput width="272" id="inputDomainUserParamValue" bottom="70" left="139"/>
+                			<mx:Label text="Variable" bottom="90" right="361"/>
+                			<mx:TextInput width="121" id="inputDomainUserVarName" bottom="70" right="290"/>
+                			<mx:TextInput width="272" id="inputDomainUserVarValue" bottom="70" right="10"/>
+                			<mx:Label text="Data" bottom="90" right="251"/>
+                			<mx:Label text="Value" bottom="90" left="139"/>
 		                </mx:Canvas>
 		            </mx:HDividedBox>
                 </mx:Canvas>
@@ -221,7 +304,7 @@
 		                			<mx:DataGridColumn headerText="Available to Join" dataField="col1"/>
 		                		</mx:columns>
 		                	</mx:DataGrid>
-		                	<mx:Button x="10" y="572" label="Refresh"/>
+		                	<mx:Button label="Refresh" left="10" bottom="40"/>
 		                </mx:Canvas>
 		            </mx:HDividedBox>
                 </mx:Canvas>

Modified: freeswitch/trunk/scripts/contrib/swk/php/amfphp/freeswitch.php
==============================================================================
--- freeswitch/trunk/scripts/contrib/swk/php/amfphp/freeswitch.php	(original)
+++ freeswitch/trunk/scripts/contrib/swk/php/amfphp/freeswitch.php	Sun Mar 15 00:24:32 2009
@@ -281,12 +281,19 @@
 		return $results;
 	}
 	
-	public function addDirDomain($domain_name){
+	public function getDirUser($user_uid){
+
 		$dbh = $this->getDbh();
 
-		$query = sprintf('insert into domains (name) values ("%s")', $domain_name);
+		$query = sprintf("select * from user_params where users_uid = $user_uid");
+		$stmt = $dbh->query($query);
+		$results['params'] = $stmt->fetchAll();
 
-		return $dbh->exec($query);
+		$query = sprintf("select * from user_variables where users_uid = $user_uid");
+		$stmt = $dbh->query($query);
+		$results['variables'] = $stmt->fetchAll();
+
+		return $results;
 	}
 
 	public function getDirUsers($domain_uid){
@@ -309,10 +316,35 @@
 		return $results;
 	}
 
-	
+	public function addDirDomain($domain_name){
+		$dbh = $this->getDbh();
+		$query = sprintf('insert into domains (name) values ("%s")', $domain_name);
+		return $dbh->exec($query);
+	}
 
-}
-/* For Emacs:
+	public function addDirDomainParam($domain_uid, $name, $value) {
+		$dbh = $this->getDbh();
+		$query = sprintf('insert into domain_params (domain_uid, name, value) values (%s, "%s", "%s")', $domain_uid, $name, $value);
+		return $dbh->exec($query);
+	}
+
+	public function addDirDomainVar($domain_uid, $name, $value) {
+		$dbh = $this->getDbh();
+		$query = sprintf('insert into domain_variables (domain_uid, name, value) values (%s, "%s", "%s")', $domain_uid, $name, $value);
+		return $dbh->exec($query);
+	}
+
+	public function updateDirDomainParam($param_uid, $name, $value) {
+		$dbh = $this->getDbh();
+		$query = sprintf('update domain_params set name = "%s", value = "%s" where uid=%s', $param_uid, $name, $value);
+		return $dbh->exec($query);
+	}
+
+	public function updateDirDomainVar($var_uid, $name, $value) {
+		$dbh = $this->getDbh();
+		$query = sprintf('update domain_variables set name = "%s", value = "%s" where uid=%s', $var_uid, $name, $value);
+		return $dbh->exec($query);
+	}
 
 }
 /* For Emacs:

    

[Freeswitch-svn] [commit] r12608 - in freeswitch/trunk/scripts/contrib/swk: flex/amf-test1/src php/amfphp

FreeSWITCH SVN