package { import fl.data.DataProvider; import fl.controls.dataGridClasses.DataGridColumn; import fl.controls.DataGrid; import flash.display.Sprite; import flash.text.TextFormat; import flash.text.TextField; import flash.display.Shape; import flash.events.Event; import flash.net.URLLoader; import flash.net.URLRequest; import flash.events.MouseEvent; import flash.display.DisplayObject; //import flash.net.URLRequest; //import flash.net.URLLoader; import flash.net.URLVariables; import flash.net.URLLoaderDataFormat; import flash.net.URLRequestMethod; /*import flash.text.TextField; import flash.utils.Timer; import flash.events.MouseEvent; import flash.events.TimerEvent; import flash.events.Event; import flash.display.Loader; import flash.net.URLRequest; import flash.net.URLLoader; import flash.net.URLVariables; import flash.net.URLLoaderDataFormat; import flash.net.URLRequestMethod; import flash.events.IEventDispatcher; import flash.events.IOErrorEvent; import flash.events.HTTPStatusEvent; import flash.events.SecurityErrorEvent;*/ public class Hlavmen extends Sprite { public var jmdatab:String="odatavlak"; public var myGrid:DataGrid=new DataGrid(); public var myGrid_1:DataGrid=new DataGrid(); public var myGrid_2:DataGrid=new DataGrid(); public var podklad:Shape=new Shape ; public var kontejner1:Sprite=new Sprite ; public var kontejner2:Sprite=new Sprite ; public var kontejner3:Sprite=new Sprite ; public var tlac_1:tlac=new tlac ; public var tlac_2:tlac=new tlac ; public var lloader:URLLoader=new URLLoader ; public var loader:URLLoader=new URLLoader ; public var amyDP:DataProvider; public var amyDP2:DataProvider; public var polelok:Array=new Array ; public var kde:Array=new Array(); public var akde:Array=new Array(); //public static var _stage; public var tex1:TextField=new TextField ; public var tex2:TextField=new TextField ; public var server:String="http://www.fotokomfort.cz/"; public function Hlavmen():void { tex1.x=320; tex1.y=10; tex1.text="menu"; tex1.height=250; tex1.width=500; tex1.background=true; tex1.wordWrap=true; tex2.x=-50; tex2.y=-80; tex2.text="menu"; tex2.height=40; tex2.width=1200; tex2.background=true; tex2.wordWrap=true; podklad.graphics.beginFill(0x777777,1); podklad.graphics.drawRect(10,10,500,350); podklad.graphics.endFill(); myGrid.move(0,0); myGrid.setSize(140, 100); myGrid.name="gr0"; myGrid_1.move(145,0); myGrid_1.setSize(140, 100); myGrid_1.name="gr1"; myGrid_2.move(10,100); myGrid_2.setSize(600, 100); myGrid_2.name="gr2"; tlac_1.x=20; tlac_1.y=25; tlac_2.x=60; tlac_2.y=25; tlac_1.addEventListener(MouseEvent.MOUSE_DOWN,fnastav); tlac_2.addEventListener(MouseEvent.MOUSE_DOWN,fdotaz); var gr1:DataGridColumn=new DataGridColumn("id"); var gr2:DataGridColumn=new DataGridColumn("st"); var gr3:DataGridColumn=new DataGridColumn("dat"); var gr4:DataGridColumn=new DataGridColumn("cis"); var gr5:DataGridColumn=new DataGridColumn("od"); var gr6:DataGridColumn=new DataGridColumn("pr"); var gr7:DataGridColumn=new DataGridColumn("z"); var gr8:DataGridColumn=new DataGridColumn("na"); var gr9:DataGridColumn=new DataGridColumn("po"); var gr10:DataGridColumn=new DataGridColumn("tum"); var gr11:DataGridColumn=new DataGridColumn("smer"); var gr12:DataGridColumn=new DataGridColumn("lok"); myGrid_2.addColumn(gr1); myGrid_2.addColumn(gr2); myGrid_2.addColumn(gr3); myGrid_2.addColumn(gr4); myGrid_2.addColumn(gr5); myGrid_2.addColumn(gr6); myGrid_2.addColumn(gr7); myGrid_2.addColumn(gr8); myGrid_2.addColumn(gr9); myGrid_2.addColumn(gr10); myGrid_2.addColumn(gr11); myGrid_2.addColumn(gr12); myGrid_2.rowHeight=18; myGrid_2.rowCount=20; myGrid_2.allowMultipleSelection=true; var col_img:DataGridColumn=new DataGridColumn("Available"); //var col_img_1:DataGridColumn=new DataGridColumn("Available"); myGrid.addColumn(col_img); myGrid_1.addColumn(col_img); //col_img.cellRenderer=loaderCellRenderer; //col_img_1.cellRenderer=tlac_1; //loaderCellRenderer._stage = myGrid_1; col_img.width=18; //col_img.x=-10; //col_img_1.width=20; var col_desc:DataGridColumn=new DataGridColumn("Name"); myGrid.addColumn(col_desc); myGrid_1.addColumn(col_desc); var textFormat1:TextFormat = new TextFormat(); textFormat1.size=12; textFormat1.color=0x333333; textFormat1.bold=true; textFormat1.font="Arial"; //myGrid.setStyle("headerTextFormat", textFormat1); myGrid_1.setStyle("headerTextFormat", textFormat1); //myGrid_2.setStyle("headerTextFormat", textFormat1); var textFormat2:TextFormat = new TextFormat(); textFormat2.size=14; //textFormat2.bold=true; textFormat2.font="Verdana"; myGrid.setRendererStyle("textFormat", textFormat2); myGrid_1.setRendererStyle("textFormat", textFormat2); //myGrid_2.setRendererStyle("textFormat", textFormat2) myGrid.rowHeight=18; myGrid_1.rowHeight=18; myGrid.showHeaders=false; myGrid_1.showHeaders=false; myGrid.rowCount=20; myGrid_1.rowCount=20; myGrid_1.allowMultipleSelection=true; addChild(kontejner1); kontejner2.scaleX=0.5; kontejner2.scaleY=0.5; kontejner3.scaleX=0.5; kontejner3.scaleY=0.5; kontejner2.x=15; kontejner2.y=40; kontejner1.addChild(podklad); kontejner1.addChild(tlac_1); kontejner1.addChild(tlac_2); kontejner1.addChild(kontejner2); kontejner1.addChild(kontejner3); kontejner2.addChild(myGrid); kontejner2.addChild(myGrid_1); kontejner3.addChild(myGrid_2); kontejner2.addChild(tex1); kontejner2.addChild(tex2); //fgrid(); //fnaxml(); } function fdotaz(e:MouseEvent):void { var pare:Object=parent; var napisstr:String=jmdatab; //var napisstr:String="SELECT * FROM kdatavlak"; tex1.text=napisstr; var url:String=server+"dotaz.php"; var request:URLRequest=new URLRequest(url); var variables:URLVariables=new URLVariables ; var lloader:URLLoader=new URLLoader ; lloader.dataFormat=URLLoaderDataFormat.VARIABLES; request.method=URLRequestMethod.POST; request.data=variables; variables.dot=napisstr; var whe:String=kde.join(); var awhe:String=akde.join(); trace("posli "+whe); variables.wh=whe; variables.awh=awhe; variables.ode=pare.hlab.calendar.vyber.od.text; variables.doe=pare.hlab.calendar.vyber.doo.text; variables.tv=pare.hlab.calendar.tlaci.log.text; variables.tv1=pare.hlab.calendar.tlaci1.log.text; //var lloader:URLLoader=new URLLoader ; lloader.load(request); //lloader.addEventListener(Event.COMPLETE, lloaderCompleteHandler); lloader.addEventListener(Event.COMPLETE,komdotaz); } public function komdotaz(event:Event):void { var loader2:URLLoader=URLLoader(event.target); var variables2:URLVariables=new URLVariables(loader2.data); tex1.text=variables2.odpoved5; tex2.text="SELECT * FROM "+variables2.odpoved6; var bazpole:Array=variables2.odpoved5.split("\n"); var bbazpole:Array=new Array(); var cbazpole:Array=new Array(); for (var spot:int=0; spot11) { var loko:String=""; for (var pot:int=12; pot