<?xml version="1.0" encoding="utf-8"?>

<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"

layout="absolute"

xmlns:salesforce="com.salesforce.*"

applicationComplete="login();" height="302"

width="675" borderColor="#FBFBFB" backgroundGradientAlphas="[1.0, 1.0]"

backgroundGradientColors="[#EBF2F3, #EBF2F3]"

name="SFQueryBuilder">

<mx:Script>

<![CDATA[

import mx.collections.ArrayCollection;

import com.salesforce.*;

import com.salesforce.results.QueryResult;

import com.salesforce.objects.LoginRequest;

import com.salesforce.objects.SObject;

import com.salesforce.AsyncResponder;

import flash.external.ExternalInterface;

import mx.utils.ObjectUtil;

import mx.controls.Alert;

import flash.events.Event;

[Bindable]

private var sfdc:Connection = new Connection();

private function login():void {

initVariables();

var lr:LoginRequest = new LoginRequest();

lr.server_url = Application.application.parameters.server_url;

lr.session_id = Application.application.parameters.session_id;

//test standalone

lr.username = 'klanguedoc@xxxxxxxxxxxxx';

lr.password = 'xxxxxxxxxxxxxxxxxxxxxxxxxxx';

lr.callback = new AsyncResponder(loadData, handleFault);

apex.login(lr);

}

// initializes the building id variable

private function initVariables():void {

var modelId:String = Application.application.parameters.modelId;

sfdc.protocol = "https";

sfdc.serverUrl = "https://na6.salesforce.com/services/Soap/u/14.0";

}

private function handleFault(fault:Object):void {

Alert.show(ObjectUtil.toString(fault));

}

private function accountId():String {

var accountid:String = new String(ExternalInterface.call("getAccountNo"));

return accountid;

}

private function accountName():String{

var accountName:String = new String(ExternalInterface.call("getAccountName"));

return accountName;

}

[Bindable]

private var ar:ArrayCollection = new ArrayCollection;

// Display a selected item's label field and index for change events.

private function changeEvt(event:Event):void {

apex.query("Select Name from Account where AccountNumber='"+

event.currentTarget.selectedItem +"'",new AsyncResponder(

function(qr:QueryResult):void {

if (qr.size > 0) {

for (var j:int=0;j<qr.records.length;j++ ) {

txtCustName.text= qr.records[j].Name;

}

}

},

handleFault));

}

private function loadData(lr:Object):void {

apex.query("Select AccountNumber From Account where AccountNumber !=null ", new AsyncResponder(

function(qr:QueryResult):void {

if (qr.size > 0) {

for (var j:int=0;j<qr.records.length;j++ ) {

ar.addItem(qr.records[j].AccountNumber);

}

}

},

handleFault)

);

}

]]>

</mx:Script>

<salesforce:Connection id="apex" />

<mx:Canvas width="671" height="282" borderStyle="none" top="10" left="2" borderColor="#FBFBFB">

<mx:Label x="10" y="99" text="Customer No:" id="custNo" enabled="true"/>

<mx:ComboBox x="100" y="97" id="cbCustNo" enabled="true"

text="{accountId()}"

dataProvider="{ar}"

change="{changeEvt(event)}"

/>

<mx:Label x="268" y="99" text="Customer Name:" id="custName" enabled="true"/>

<mx:Text width="285" id="txtCustName" enabled="true" x="376" y="99" text="{accountName()}"/>

<mx:ComboBox x="100" y="127" id="cbProductNo"

editable="false"

enabled="true"></mx:ComboBox>

<mx:Label x="10" y="129" text="Product No:" id="prodNo" enabled="true"/>

<mx:DateField x="100" y="175" width="176" cornerRadius="0" showToday="true" enabled="true" id="dtStartDate"/>

<mx:Label x="10" y="177" text="Start Date:" id="startDate" enabled="true"/>

<mx:Label x="284" y="177" text="End Date:" id="endDate" enabled="true"/>

<mx:DateField x="376" y="175" width="176" id="dtEndDate" showToday="true"/>

<mx:Label x="268" y="129" text="Product Name:" id="prodName" enabled="true"/>

<mx:Text x="376" y="129" width="285" id="txtProdName" />

</mx:Canvas>

</mx:Application>