<?
	include("../init.inc.php"); 
	
	if (!class_exists('RobotAway')) {
		require_once("rw.inc.php");
	}
	    
	$handler = Load_App( 'actnews' );
    
	isset($_POST['aclass']) ? '' : $_POST['aclass'] = null;
	isset($_POST['actSn']) ? '' : $_POST['actSn'] = null;
	isset($_POST['Sn']) ? '' : $_POST['Sn'] = null;
	
	$SiteURL = SiteURL();
	
	$option = $handler->Get_Option( $_POST['aclass'] ) ;//選項
	$workshop = $handler->Get_Workshop( $_POST['actSn'] ) ;//報名細項 項目
	$wkoption = $workshop->Get_Option() ;//報名細項 選項
    $signup = $handler->Get_Signup( $_POST['Sn'] ) ;//報名表	
    $result = $handler->Get_Result( $_POST['Sn'] ) ;//報名表填答	
	$cont = $handler->Get_Cont( $_POST['Sn'] ) ;	//投稿


	//報名表 填寫
	if( $_POST['action'] == 'addsignitem' ) {	
	
		//防止灌水
		$RA = new RobotAway($_SESSION['EncodeKey'],'CheckKey');
		if ( !$RA->Verify() ) error_display( T_('請從報名註冊頁面註冊。') ) ;
		
		$_SESSION['EncodeKey'] = '';
		
		$show = $signup->Get_Datas( '', "ASn = '$_POST[Sn]' and Email = '$_POST[Email]'" );	
		if ($show) error_display( T_('此Email信箱已存在，請另填新的Email信箱。') ) ;
		
		$validators[] = new ValidateRequired( $_POST['Identity'] , T_('身份判別') );
		$validators[] = new ValidateRequired( $_POST['Name'] , T_('姓名') );
		$validators[] = new ValidateRequired( $_POST['Unit'] , T_('單位') );
		$validators[] = new ValidateRequired( $_POST['actnews_signup_class'] , T_('職稱') );
		$validators[] = new ValidateRequired( $_POST['TEL'] , T_('聯絡電話') );
		$validators[] = new ValidateRequired( $_POST['Email'] , T_('e-mail信箱') );
		
		if ( $_POST['Identity'] == 'C'){
			$validators[] = new ValidateRequired( $_POST['Password'] , T_('密碼') );
			$_SESSION['actnews'] = $_POST['Email']; //投稿者帳號
			$_SESSION['actnewsSn'] = $_POST['Sn'];
		}
		
	    ValidateData( $validators );
		
		//報名表
		
		if ( $_POST['action'] == 'addsignitem' ) {
		
			$sn = $signup->Create_PRI();
			
		}else if ( $_POST['action'] == 'editsignitem' ) {
		
			$sn = $_POST['editsignSn'];
		}		
		
		$signup->Update_Data( $sn , 'ASn' , $_POST['Sn'] ) ;
		$signup->Update_Data( $sn , 'Identity' , $_POST['Identity'] ) ;
		$signup->Update_Data( $sn , 'Name' , $_POST['Name'] ) ;
		$signup->Update_Data( $sn , 'Unit' , $_POST['Unit'] ) ;
		$signup->Update_Data( $sn , 'actnews_signup_class' , $_POST['actnews_signup_class'] ) ;
		$signup->Update_Data( $sn , 'Other' , $_POST['Other'] ) ;
		$signup->Update_Data( $sn , 'TEL' , $_POST['TEL'] ) ;
		$signup->Update_Data( $sn , 'Mobile' , $_POST['Mobile'] ) ;
		$signup->Update_Data( $sn , 'FAX' , $_POST['FAX'] ) ;
		$signup->Update_Data( $sn , 'Address' , $_POST['Address'] ) ;
		$signup->Update_Data( $sn , 'Email' , $_POST['Email'] ) ;
		$signup->Update_Data( $sn , 'Note' , $_POST['Note'] ) ;
		$signup->Update_Data( $sn , 'Password' , md5( $_POST['Password'] ) ) ;
		$signup->Update_Data( $sn , 'CTime' , now() ) ;
		
		//報名表細項
	
		$wkarrs = $workshop->Get_Datas( 'ListOrder', "AID='$_POST[Sn]'"); //項目
		foreach( $wkarrs as $wkarr ) {
			
			$ai = 0;
			$wkparrs = $wkoption->Get_Datas( 'ListOrder', "MID = '$wkarr[Sn]'" ); //選項
			foreach( $wkparrs as $wkparr ) {
				
				$answer = "Q$wkarr[Sn]";
				$other = "other$wkarr[Sn]";				
				
				if ( $_POST[$answer][$ai] ){
					
					$baseTable = $result->Table[0];
					$maxKey = $_DB->get_var("select MAX(Sn) from $baseTable");		
					$newKey = $maxKey + 1;	
					
					$_DB->query("INSERT INTO ".$result->Table[0]." (Sn, UID, ASn, QSn, OSn, Other) VALUES ('$newKey', '$sn', '$_POST[Sn]', '$wkarr[Sn]', '". $_POST[$answer][$ai] ."', '". $_POST[$other][$_POST[$answer][$ai]] ."' )");
				}
				
				$ai = $ai + 1;
			}
		}

		$title = $handler->Get_Data( $_POST['Sn'] );	
/*		
		//寄送給投稿者
		$SendSubject = $_SITE['site_name']." - ". $title['ActName'] .T_("報名成功!!");
		$SendSubject = "=?UTF-8?B?".base64_encode($SendSubject)."?=";
		include( 'actnews_mail.php' );
		$Headers = $_SITE['site_name'];
		$Headers = "=?UTF-8?B?".base64_encode($Headers)."?=";
		$SendHeaders  = "Mime-Version: 1.0";
		$SendHeaders  = "From: \"$Headers\" <$title[ServiceMail]>\n";
		$SendHeaders .= "Reply-To: $title[ServiceMail]\n";
		$SendHeaders .= "Content-Type: text/html; charset=utf-8";
		mail("$_POST[Email]", "$SendSubject", "$SendMsg", "$SendHeaders");

		if ( $_POST['Name']['zh-tw'] ){ $name = $_POST['Name']['zh-tw'];}
		else $name = $_POST['Name']['en'];
		//寄送到服務信箱
		$SendSubject = $_SITE['site_name']." - ". $title['ActName'] .T_("報名者"). $name .T_("資料!!");
		$SendSubject = "=?UTF-8?B?".base64_encode($SendSubject)."?=";
		include( 'actnews_mail2.php' );
		$Headers = $_SITE['site_name'];
		$Headers = "=?UTF-8?B?".base64_encode($Headers)."?=";
		$SendHeaders  = "Mime-Version: 1.0";
		$SendHeaders  = "From: \"".$Headers."\" <$title[ServiceMail]>\n";
		$SendHeaders .= "Reply-To: $title[ServiceMail]\n";
		$SendHeaders .= "Content-Type: text/html; charset=utf-8";	
		mail("$title[ServiceMail]", "$SendSubject", "$SendMsg", "$SendHeaders");
*/

		//寄送給投稿者
		if ( $_POST['Name']['zh-tw'] ){ $name = $_POST['Name']['zh-tw'];}
		else $name = $_POST['Name']['en'];
		
		$mail = & new RSS_Mail();
		$mail->IsHTML( 'true' );
		$mail->Subject = $_SITE['site_name']." - ". $title['ActName'] .T_("報名者"). $name .T_("資料!!");
		
		include( 'actnews_mail.php' );
		$mail->Body = $SendMsg;
		$mail->AddAddress( $_POST['Email'] );	
		$mail->Send();	

		//寄送到服務信箱

		$mail2 = & new RSS_Mail();
		$mail2->IsHTML( 'true' );
		$mail2->Subject = $_SITE['site_name']." - ". $title['ActName'] .T_("報名成功!!");	
		
		include( 'actnews_mail2.php' );
		$mail2->Body = $SendMsg;
		$mail2->AddAddress( $title['ServiceMail'] );	
		//$mail2->AddAddress( $_SITE['email'] );	
		$mail2->Send();	

		header("Location:actnews.php?action=signok&Sn=$_POST[Sn]&USn=$sn");
		exit;
	}
	
	//報名表 修改
	if( $_POST['action'] == 'editsignitem' ) {
		
		$validators[] = new ValidateRequired( $_POST['Identity'] , T_('身份判別') );
		$validators[] = new ValidateRequired( $_POST['Name'] , T_('姓名') );
		$validators[] = new ValidateRequired( $_POST['Unit'] , T_('單位') );
		$validators[] = new ValidateRequired( $_POST['actnews_signup_class'] , T_('職稱') );
		$validators[] = new ValidateRequired( $_POST['TEL'] , T_('聯絡電話') );
		$validators[] = new ValidateRequired( $_POST['Email'] , T_('e-mail信箱') );
		
	    ValidateData( $validators );
		
		$sn = $_POST['editsignSn'];
		
		$signup->Update_Data( $sn , 'ASn' , $_POST['Sn'] ) ;
		$signup->Update_Data( $sn , 'Identity' , $_POST['Identity'] ) ;
		$signup->Update_Data( $sn , 'Name' , $_POST['Name'] ) ;
		$signup->Update_Data( $sn , 'Unit' , $_POST['Unit'] ) ;
		$signup->Update_Data( $sn , 'actnews_signup_class' , $_POST['actnews_signup_class'] ) ;
		$signup->Update_Data( $sn , 'Other' , $_POST['Other'] ) ;
		$signup->Update_Data( $sn , 'TEL' , $_POST['TEL'] ) ;
		$signup->Update_Data( $sn , 'Mobile' , $_POST['Mobile'] ) ;
		$signup->Update_Data( $sn , 'FAX' , $_POST['FAX'] ) ;
		$signup->Update_Data( $sn , 'Address' , $_POST['Address'] ) ;
		$signup->Update_Data( $sn , 'Email' , $_POST['Email'] ) ;
		$signup->Update_Data( $sn , 'Note' , $_POST['Note'] ) ;		
		
		if ( $_POST['Identity'] == 'C' and $_POST['Password'] )
		$signup->Update_Data( $sn , 'Password' , md5( $_POST['Password'] ) ) ;

		if ( $_POST['sno'] ) $sno = "&sno=$_POST[sno]"; else $sno = '';
		if ( $_POST['no'] ) $no = "&no=$_POST[no]"; else $no = '';
		if ( $_POST['key'] ) $key = "&key=$_POST[key]"; else $key = '';
		
		header("Location:actnews_signup.admin.php?Sn=$_POST[Sn]&USn=$sn&action=view$sno$no$key");
		exit;
	}
	
	// 投稿檔案 新增 & 修改
	elseif( $_POST['action'] == 'addcontitem' or $_POST['action'] == 'editcontitem' ) {
		
		//$validators[] = new ValidateRequired( $_POST['File_Title'] , T_('檔案名稱'));
		$validators[] = new ValidateUpload( $_POST['Filename'] , T_('檔案') );
	    ValidateData( $validators );
		
		$show = $signup->Get_Data2( "ASn = '$_POST[Sn]' and Email = '$_SESSION[actnews]'" ); //UID
		
		if ( $_POST['action'] == 'addcontitem' ) {
		
			$sn = $cont->Create_PRI();
			
		}else if ( $_POST['action'] == 'editcontitem' ) {
		
			$sn = $_POST['editSn'];
		}
		
		$cont->Update_Data( $sn , 'ASn' , $_POST['Sn'] ) ;
		$cont->Update_Data( $sn , 'File_Title' , $_POST['File_Title'] ) ;
		$cont->Update_File( $sn , 'Filename' , $_FILES['Filename'] , $_POST['Opt_Filename'] ) ;
		$cont->Update_Data( $sn , 'UploadDate' , now() ) ;
		$cont->Update_Data( $sn , 'UID' , $show['Sn'] ) ;
		
		header("Location:actnews_user.php?Sn=$_POST[Sn]&action=list");
		exit;
	}
	
	// 密碼 修改
	if( $_POST['action'] == 'editpw' ) {
		
		$validators[] = new ValidateRequired( $_POST['act_pw'] , T_('新密碼') );
		$validators[] = new ValidateRequired( $_POST['act_cpw'] , T_('確認密碼') );
		
	    ValidateData( $validators );
		
		if ( $_POST['act_pw'] != $_POST['act_cpw'] )
			error_display( T_('確認密碼有誤，請重新輸入!!') ) ;
		
		$newpw2 = MD5( $_POST['act_pw'] );
		$_DB->query("update actnews_signup set Password = '$newpw2' where Email = '$_SESSION[actnews]'");

		
		header("Location:actnews_user.php?Sn=$_POST[Sn]&action=list");
		exit;
	}
		
	// 刪除 投稿檔案
	elseif( !empty( $_GET['delcontSn'] ) ) {   
		
		$cont->Delete_File( $_GET['delcontSn'] , 'Filename' );
		$cont->Delete_Data( $_GET['delcontSn'] );				
		
		header("Location:actnews_user.php?Sn=$_GET[Sn]&action=list");
		exit;
	}


?>