1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
...
<mx:Script>
<![CDATA[
[Bindable]
public var tb_individual:Array = new Array();
public function listIndividual(utilisateur:String,de:String,a:String):void {
var utilisateur:String;
var de:String;
var a:String;
var query:SQLStatement = new SQLStatement();
query.sqlConnection = sqlConnection;
query.text = "SELECT date,prix FROM transactions " +
"WHERE coiffeur = '"+utilisateur+"' AND date > '"+de+"' AND date < '"+a+"' ORDER BY DATE ASC";
tb_individual = query.getResult().data;
}
]]>
</mx:Script>
<mx:ComboBox x="83" y="3" width="135" height="22" prompt="- UTILISATEUR -" dataProvider="{tb_utilisateurs}" labelField="initiales" id="rap_ind_utilisateur" selectedIndex="-1"/>
<mx:Label x="10" y="35" text="de :" width="40" height="18" textAlign="right"/>
<mx:Label x="210" y="35" text="à :" width="40" height="18" textAlign="right"/>
<mx:Label x="16" y="5" text="Employé :" width="70" height="18"/>
<mx:DateField x="58" y="33" id="rap_ind_de"
dayNames="{dayNames}" firstDayOfWeek="1"
formatString="DD.MM.YYYY" yearNavigationEnabled="true"
monthNames="{monthNames}" textAlign="center" showToday="false"/>
<mx:DateField x="257" y="33" showToday="true" id="rap_ind_a"
dayNames="{dayNames}" firstDayOfWeek="1"
formatString="DD.MM.YYYY" yearNavigationEnabled="true"
monthNames="{monthNames}" textAlign="center"/>
<mx:Button x="131" y="66" label="Chercher" width="100" click="listIndividual(rap_ind_utilisateur.text,rap_ind_de.text,rap_ind_a.text)"/>
<mx:DataGrid x="16" y="96" width="329" height="135" dataProvider="{tb_individual}">
<mx:columns>
<mx:DataGridColumn headerText="Date" dataField="date"/>
<mx:DataGridColumn headerText="Montant" dataField="prix"/>
</mx:columns>
</mx:DataGrid>
... |
