<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" creationPolicy="all" creationComplete="this.onCreationComplete()" viewSourceURL="srcview/index.html">
	
	<mx:Script>
		<![CDATA[
			import mx.binding.utils.BindingUtils;
			import mx.managers.CursorManager;
			import mx.core.ScrollPolicy;
			import flash.utils.describeType;
			import mx.controls.dataGridClasses.DataGridColumn;
			import com.orsomethinglikethat.flex.filemaker.command.FindCommand;
			import com.orsomethinglikethat.flex.filemaker.request.ComparisonOperator;
			import com.orsomethinglikethat.flex.filemaker.request.FileMakerResultEvent;
			import com.orsomethinglikethat.flex.filemaker.FileMakerResultHandler;
			import com.orsomethinglikethat.flex.filemaker.Record;
			import mx.controls.Alert;
			import com.orsomethinglikethat.flex.filemaker.FileMaker;
			
			private var fm:FileMaker = null;
			private var commands:Array = null;
			[Bindable]
			private var showFindParameters:Boolean = false;
			

			private function onCommandChange():void
			{
				this.showFindParameters = this.cboCommands.selectedIndex != -1 && this.cboCommands.selectedItem.data == this.find;
			}
			
			private function onCreationComplete():void
			{
				this.commands = 			[ 
					{label:"FindAny", data:this.findAny }, 
					{label:"Find", data:this.find}, 
					{label:"FindAll", data:this.findAll} ];
					
				this.cboCommands.dataProvider = this.commands;
			}
			
			private function currentFileMaker():FileMaker
			{
				if( this.fm == null )
				{
					this.fm = new FileMaker( this.serverURL.text, this.database.text, this.user.text, this.password.text );
				}
				
				return this.fm;
			}
			
			private function execute():void
			{
				if( this.cboCommands.selectedItem != null )
				{
					this.resultGrid.dataProvider = null;
					this.enabled = false;
					CursorManager.setBusyCursor();
					(this.cboCommands.selectedItem.data as Function).call( this );
				}
			}
			
			private function findAny():void
			{
				this.currentFileMaker().newFindAnyCommand( this.layoutName.text ).execute( gridResultHandler, null );
			}
			
			private function findAll():void
			{
				this.currentFileMaker().newFindAllCommand( this.layoutName.text ).execute( gridResultHandler, null );
			}
			
			private function find():void
			{
				var find:FindCommand = this.currentFileMaker().newFindCommand( this.layoutName.text );
				find.addFindCriterion( this.fieldName.text, this.value.text, this.findOp.selectedItem as ComparisonOperator );
				find.execute( gridResultHandler, null );
			}
			
			public function gridResultHandler( event:FileMakerResultEvent ):void
			{
				if( event.records.length > 0 )
				{
					this.resultCount.text = event.records.length.toString();
					
					var newCols:Array = new Array();
					var rec:Record = event.records[0];
					var col:DataGridColumn;
					for each ( var p:String in rec.fields )
					{
						col =  new DataGridColumn( p );
						col.resizable = true;
						newCols.push( col );
					}
					
					this.resultGrid.columns = newCols;
				}
				
				this.resultGrid.dataProvider = event.records;
				CursorManager.removeBusyCursor();
				this.enabled = true;
			}
			
			private function isFindPanelEnabled():Boolean
			{
				return this.cboCommands.selectedItem != null && this.cboCommands.selectedItem == this.find;
			}
			
		]]>
	</mx:Script>
	
	<mx:Panel layout="absolute" title="Flex4FileMaker Configuration" top="10" height="119" right="10" left="10">
		<mx:Label x="10" y="10" text="FM Server URL"/>
		<mx:TextInput x="103" y="8" width="272" id="serverURL"/>
		<mx:TextInput x="103" y="38" width="272" id="database"/>
		<mx:Label x="10" y="40" text="Database"/>
		<mx:TextInput x="495" y="10" id="user"/>
		<mx:TextInput x="495" y="40" id="password"/>
		<mx:Label x="402" y="12" text="User"/>
		<mx:Label x="402" y="38" text="Password"/>
	</mx:Panel>
	<mx:Panel layout="absolute" left="10" right="10" bottom="10" top="137" title="Flex4FileMaker Query" horizontalScrollPolicy="auto">
		<mx:TextInput x="103" y="10" id="layoutName"/>
		<mx:Label x="10" y="12" text="Layout" width="47"/>
		<mx:DataGrid id="resultGrid" columnWidth="100" horizontalScrollPolicy="{ScrollPolicy.AUTO}" left="10" right="10" top="176" bottom="20" />
		<mx:ComboBox x="103" y="40" id="cboCommands" change="{this.onCommandChange()}"></mx:ComboBox>
		<mx:Label x="10" y="42" text="Command"/>
		<mx:Button label="Execute" width="110" click="{this.execute()}" right="10" top="146" height="22"/>
		<mx:Label width="106" id="resultCount" top="148" left="105"/>
		<mx:Label text="Records Found" top="148" left="10"/>
		<mx:Panel width="326" height="117" layout="absolute" title="Find Parameter" enabled="{this.showFindParameters}" top="10" x="301">
			<mx:ComboBox x="114" y="36" id="findOp" width="70" dataProvider="{ComparisonOperator.operators}"></mx:ComboBox>
			<mx:Label x="10" y="10" text="fieldName"/>
			<mx:Label x="192" y="10" text="value"/>
			<mx:TextInput x="10" y="36" id="fieldName" width="96"/>
			<mx:TextInput x="192" y="36" id="value" width="96"/>
			<mx:Label x="114" y="10" text="op"/>
		</mx:Panel>
	</mx:Panel>

	
</mx:Application>