<?php
//定義資料庫的資料
define(dburl,"localhost");
define(dbusername,"請用你自己的資料庫帳號");
define(dbpassword,"請用你自己的資料庫密碼");
define(dbname,"資料庫名稱");
 
class users {
	//取得所有資料庫內的使用者帳號密碼
	public function getUsers(){
		$db = new mysqli(dburl,dbusername,dbpassword,dbname);
		$query = "select * from users";
		$result = $db->query($query);
		$db->close();
		return $result;
	}
	//檢查帳號密碼是否正確
	public function checkUser($dataObject){
		$account = $dataObject["account"];
		$password = $dataObject["password"];
		$db = new mysqli(dburl,dbusername,dbpassword,dbname);
		$query = "select * from users where account = '$account' and password = '$password'";
		$result = $db->query($query);
		$db->close();
		if($result->num_rows > 0){
			//如果資料庫有回傳資料表示這個帳戶與密碼通過資料庫驗證
			return true;
		}else{
			//沒有資料當然代表這是不合法的帳號與密碼
			return false;
		}
	}
	//新增使用者帳號與密碼
	public function insertUser($dataObject){
		$account = $dataObject["account"];
		$password = $dataObject["password"];
		$db = new mysqli(dburl,dbusername,dbpassword,dbname);
		$query = "insert into users (account,password) values ('$account','$password')";
		$db->query($query);
		$db->close();
		return true;
	}
	//利用AJAX方式檢查使用者帳號是否重複
	public function checkUserAjax($dataObject){
		$account = $dataObject["account"];
		$db = new mysqli(dburl,dbusername,dbpassword,dbname);
		$query = "select * from users where account = '$account'";
		$result = $db->query($query);
		$db->close();
		if($result->num_rows > 0){
			//如果資料庫有回傳資料就把按鈕關閉
			return false;
		}else{
			//都沒找到資料才打開
			return true;
		}
	}
	//刪除使用者帳號與密碼
	public function delUser($dataObject){
		$account = $dataObject["account"];
		$db = new mysqli(dburl,dbusername,dbpassword,dbname);
		$query = "delete from users where account='$account'";
		$db->query($query);
		$db->close();
		return true;
	}
}
 
?>

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical" fontSize="14" creationComplete="init()">
	<mx:Script>
		<![CDATA[
			import mx.rpc.events.ResultEvent;
			import mx.controls.Alert;
			[Bindable]
			private var checkCode:String;
			[Bindable]
			private var regCheckCode:String;
			//初始化->把可以登入的使用者資料拿回來
			//並且產生兩組驗證碼->簡易防止機器人行為
			private function init():void{
				this.usersRemoting.getUsers();
				this.checkCode = this.createCode();
				this.regCheckCode = this.createCode();
			}
			//產生驗證碼
			private function createCode():String{
				var code:String = "";
				for(var i:int=0;i<4;i++){
					code += (int)(Math.random()*10);
				}
				return code;
			}
			//刪除帳號
			private function delHandler():void{
				if(this.userDG.selectedIndex == -1){
					Alert.show("尚未選取使用者","警告");
				}else{
					var obj:Object = new Object();
					obj.account = this.userDG.selectedItem.account;
					this.usersRemoting.delUser(obj);
				}
			}
			//新增使用者
			private function regUserHandler():void{
				if(this.regAccount.text =="" || this.regPassword.text =="" || this.regCode.text==""){
					Alert.show("你有欄位尚未填寫","錯誤");
				}else{
					if(this.regCode.text != this.regCheckCode){
						Alert.show("驗證碼錯誤","錯誤");
					}else{
						var obj:Object = new Object();
						obj.account = this.regAccount.text;
						obj.password = this.regPassword.text;
						this.usersRemoting.insertUser(obj);
					}
				}
			}
			//新增使用者成功
			private function insertUserResult():void{
				this.usersRemoting.getUsers();
				this.regAccount.text = "";
				this.regPassword.text = "";
				this.regCode.text = "";
				this.regCheckCode = this.createCode();
				Alert.show("新增資料成功","訊息");
			}
			//利用 AJAX 的方式檢查帳號是否存在
			//->叫做 AJAX 有點白癡，因為整個 FLEX 都是 AJAX 阿....
			private function regAccountAjax():void{
				var obj:Object = new Object();
				obj.account = this.regAccount.text;
				this.usersRemoting.checkUserAjax(obj);
			}
			//如果帳號沒人用過才把新增的按鈕打開
			private function checkUserAjaxResult(event:ResultEvent):void{
				this.regUserBtn.enabled = event.result;
			}
			//檢驗帳號登入成功與否
			private function checkUserHandler():void{
				if(this.loginAccount.text =="" || this.loginPassword.text =="" || this.loginCode.text==""){
					Alert.show("你有欄位尚未填寫","錯誤");
				}else{
					if(this.loginCode.text != this.checkCode){
						Alert.show("驗證碼錯誤","錯誤");
					}else{
						var obj:Object = new Object();
						obj.account = this.loginAccount.text;
						obj.password = this.loginPassword.text;
						this.usersRemoting.checkUser(obj);
					}
				}
			}
			//顯示後端驗證的結果
			private function checkUserResult(event:ResultEvent):void{
				if(event.result){
					//重新建立驗整碼
					this.loginCode.text = "";
					this.checkCode = this.createCode();
					Alert.show("您輸入資料為\n\n帳號:"+this.loginAccount.text+"\n密碼:"+this.loginPassword.text,"使用者密碼驗證成功");
				}else{
					Alert.show("您輸入的帳號或密碼錯誤，請重新再試","錯誤!");
				}
			}
		]]>
	</mx:Script>
	<mx:HBox width="620">
		<mx:VBox width="50%">
			<mx:Panel width="300" height="250" layout="vertical" title="使用者登入">
				<mx:Form width="100%" height="100%">
					<mx:FormItem label="帳號">
						<mx:TextInput id="loginAccount" maxChars="8" restrict="a-zA-Z0-9"/>
					</mx:FormItem>
					<mx:FormItem label="密碼">
						<mx:TextInput id="loginPassword" maxChars="8" restrict="a-zA-Z0-9"/>
					</mx:FormItem>
					<mx:FormItem label="驗證碼">
						<mx:Label text="{this.checkCode}"/>
						<mx:TextInput id="loginCode" maxChars="4" restrict="0-9"/>
					</mx:FormItem>
					<mx:FormItem>
						<mx:Button label="送出" click="checkUserHandler()"/>
					</mx:FormItem>
				</mx:Form>
			</mx:Panel>
			<mx:Panel width="300" height="250" layout="vertical" title="新增使用者">
				<mx:Form width="100%" height="100%">
					<mx:FormItem label="帳號">
						<mx:TextInput id="regAccount" change="regAccountAjax()" maxChars="8" restrict="a-zA-Z0-9"/>
					</mx:FormItem>
					<mx:FormItem label="密碼">
						<mx:TextInput id="regPassword" maxChars="8" restrict="a-zA-Z0-9"/>
					</mx:FormItem>
					<mx:FormItem label="驗證碼">
						<mx:Label text="{this.regCheckCode}"/>
						<mx:TextInput id="regCode" maxChars="4" restrict="0-9"/>
					</mx:FormItem>
					<mx:FormItem>
						<mx:Button id="regUserBtn" label="新增" click="regUserHandler()" enabled="false"/>
					</mx:FormItem>
				</mx:Form>
			</mx:Panel>
		</mx:VBox>
		<mx:Panel width="300" height="100%" layout="vertical" title="目前資料庫內可登入的帳號與密碼">
			<mx:Button label="刪除" click="this.delHandler()"/>
			<mx:DataGrid id="userDG" width="100%" height="100%" dataProvider="{this.usersRemoting.getUsers.lastResult}">
				<mx:columns>
					<mx:DataGridColumn headerText="帳號" dataField="account"/>
					<mx:DataGridColumn headerText="密碼" dataField="password"/>
				</mx:columns>
			</mx:DataGrid>
		</mx:Panel>
	</mx:HBox>
	<mx:RemoteObject id="usersRemoting" destination="amfphp" source="app.users">
		<mx:method name="getUsers"/>
		<mx:method name="delUser" result="this.usersRemoting.getUsers();Alert.show('刪除成功','訊息');"/>
		<mx:method name="insertUser" result="insertUserResult()"/>
		<mx:method name="checkUserAjax" result="checkUserAjaxResult(event)"/>
		<mx:method name="checkUser" result="checkUserResult(event)"/>
	</mx:RemoteObject>
</mx:Application>