include("inc/db.php");
$n=intval(trim($_POST['datenum']));
if($_POST['lang']=="1"){
session_start();
$code = $_POST["authcode"];
if( $code == "" || $code != $HTTP_SESSION_VARS["authcode_session"])
{
echo "";
echo "";
exit();
}
$meetingroom=& $_POST;
while (list($key, $value) = each($meetingroom)) {
$meetingroom[$key]=trim($value);
}
$meetingroom['purpose']=intval($meetingroom['purpose']);
$meetingroom['lang']=intval($meetingroom['lang']);
for($i=1;$i<=$n;$i++){
$meetingroom['usedate'.$i]=$meetingroom['year'.$i]."|".$meetingroom['month'.$i]."|".$meetingroom['date'.$i]."|".$meetingroom['hours'.$i]."|".$meetingroom['minutes'.$i]."|".$meetingroom['houre'.$i]."|".$meetingroom['minutee'.$i];
if($meetingroom['year'.$i]=="2008"&&$meetingroom['month'.$i]=="1"&&$meetingroom['date'.$i]=="1"){
$meetingroom['usedate'.$i]="";
}
}
$sql_check="select * from meetingroom order by id desc limit 1";
$query_check=mysql_query($sql_check,$conn) or die("error".mysql_error());
$num_check=mysql_num_rows($query_check);
$result_check=mysql_fetch_assoc($query_check);
$check_flag=0;
if($num_check==0){
$check_flag=1;
}else{
foreach($result_check as $key=>$value){
if(addslashes($result_check[$key])!=$meetingroom[$key]&&$key!='id'&&$key!='regdate'&&$key!='insdate'){
$check_flag=1;
break;
}
}
}
if($check_flag==0){
echo "";
echo "";
exit();
}else{
$sql_add = "insert into meetingroom (mbscid,company_c,company_e,company_p,company_o,personnum,contact_person,contact_tel,contact_mobile,contact_fax,contact_email,usedate1,usedate2,usedate3,usedate4,usedate5,usedate6,usedate7,usedate8,usedate9,usedate10,purpose,other,following,lang,regdate) values('{$meetingroom['mbscid']}','{$meetingroom['company_c']}','{$meetingroom['company_e']}','{$meetingroom['company_p']}','{$meetingroom['company_o']}','{$meetingroom['personnum']}','{$meetingroom['contact_person']}','{$meetingroom['contact_tel']}','{$meetingroom['contact_mobile']}','{$meetingroom['contact_fax']}','{$meetingroom['contact_email']}','{$meetingroom['usedate1']}','{$meetingroom['usedate2']}','{$meetingroom['usedate3']}','{$meetingroom['usedate4']}','{$meetingroom['usedate5']}','{$meetingroom['usedate6']}','{$meetingroom['usedate7']}','{$meetingroom['usedate8']}','{$meetingroom['usedate9']}','{$meetingroom['usedate10']}',{$meetingroom['purpose']},'{$meetingroom['other']}',0,{$meetingroom['lang']},now())";
$query_add=mysql_query($sql_add,$conn) or die("error".mysql_error());
$sql_log = "insert into formlog (formbel) values(2)";
$query_log=mysql_query($sql_log,$conn) or die("error".mysql_error());
ini_set("SMTP","smtp.macau.ctm.net");
$send_email = $meetingroom['contact_email'];
$send_subject = "=?utf-8?B?".base64_encode('Form application alert')."?=";
$send_headers = "MIME-Version: 1.0\r\n";
$send_headers .= "Content-type: text/html; charset=utf-8\r\n";
$send_headers .= "From: ".$send_email;
//$send_to="lei@microchina.com";
$send_to="mbsc@ipim.gov.mo,fmak@ipim.gov.mo,chan@ipim.gov.mo,twh@ipim.gov.mo";
$send_html="Note:
There is a new application form( Meeting Room Reservation Form - Chinese ) has been submitted, please check it in time!
".date("Y-m-d H:i");
if(mail($send_to, $send_subject, $send_html, $send_headers))
{ }
else {
echo "Email Error!";
}
ini_restore("SMTP");
ini_set("SMTP","smtp.macau.ctm.net");
$send_email2 = "mbsc@ipim.gov.mo";
$send_subject2 = "=?utf-8?B?".base64_encode('MBSC Auto-reply')."?=";
$send_headers2 = "MIME-Version: 1.0\r\n";
$send_headers2 .= "Content-type: text/html; charset=utf-8\r\n";
$send_headers2 .= "From: ".$send_email;
//$send_to2="lei@microchina.com";
$send_to2=$meetingroom['contact_email'];
$send_html2=$meetingroom['contact_person']."
先生/小姐 台啟
多謝使用澳門商務促進中心為您提供之服務。本中心已收到閣下於".date("Y年m月d日H時i分")."遞交之申請 (洽談室預留表格),並將會跟進處理。
如有任何查詢,煩請聯絡本中心﹙電話﹕+853 28728212、傳真﹕+853 28727123 或電郵﹕mbsc@ipim.gov.mo﹚。
";
if(mail($send_to2, $send_subject2, $send_html2, $send_headers2))
{ }
else {
echo "Email Error!";
}
ini_restore("SMTP");
echo "
登記成功!";
echo "返回";
exit();
}
}
?>
|
||
|
||