if(!empty($_POST)){
// $name=$_POST['name'];
// $province= ($_POST['province']!='')?'@'.$_POST['province']:'';
// $phone=$_POST['phone'];
// $email=$_POST['email'];
// $comment=$_POST['comment'];
// $action=$_POST['action'];
foreach($_POST as $key => $value)
$_POST[$key]=htmlspecialchars($value,ENT_QUOTES); // 編碼特殊字元
$CaseNo=substr(md5(uniqid()),rand(0,10),rand(18,20)); // 18-20字元案件編號
$parent='null';
if(!empty($_POST["no"])){
$sql = "SELECT Serial from CCBU.dbo.TB_CtmrContact where No='".$_POST["no"]."'";
$Root = $mssql_conn->Execute($sql);
// $ro = $pdo -> query($sql);
// $Root = $ro->fetchObject();
$parent = $Root->fields["Serial"];
}
$IP = $_SERVER['REMOTE_ADDR'];
if (array_key_exists('HTTP_X_FORWARDED_FOR', $_SERVER)) {
$IP = array_pop(explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']));
}
$sql = "INSERT into CCBU.dbo.TB_CtmrContact (
Parent,
No,
Name,
Phone,
EMail,
Province,
Status,
Contents,
Created,
Source,
IP) values (
".$parent.",
'".$CaseNo."',
N'".$_POST['name']."',
'".$_POST['phone']."',
'".$_POST['email']."',
N'".$_POST['province']."',
0,
N'".htmlspecialchars($_POST['comment'],ENT_QUOTES)."',
getDate(),
'Portal',
'".$IP."' )";
$mssql_conn->Execute($sql);
// $pdo -> query($sql);
// print_r($sql);
echo "";
}
// if (false && $action=="add")
// {
// /* 收件人 */
// //$to = "will.su@wpgcnc.com";
// /* 主旨 */
// $subject = "[" . date("Y/m/j") . "] WPGCNC.COM 新留言通知";
// $sql_addlog = "INSERT INTO dbo.TB_MsgBoard(UserName,
// Phone,
// Mail,
// Suggestion,
// BTime,
// IP)
// VALUES (N'".$name.$province."',
// '".$phone."',
// '".$email."',
// N".$mssql_conn->qstr($comment, get_magic_quotes_gpc()).",
// getdate(),
// '".$_SERVER[REMOTE_ADDR]."')";
// $mssql_conn->Execute($sql_addlog);
// $sql = "SELECT Serial
// FORM dbo.TB_MsgBoard
// WHERE IP='".$_SERVER[REMOTE_ADDR]."'
// ORDER BY Serial desc";
// // $rs_serial = $mssql_conn->Execute($sql);
// // $sql_maillog = "INSERT INTO TB_MsgBoardMailLog(Serial,CrTime) VALUES ('".$rs_serial->fields[0]."',getdate())";
// // $mssql_conn->Execute($sql_maillog);
// $message = "
//
//
// |
//
//
//
//
//
//
//
//
// 姓名:" .$name.$province. " |
// 联系电话:" . $phone . " |
//
//
// 邮箱:" . $email . " |
//
//
// 意见和建议: |
//
//
// " . nl2br($comment) . " |
//
//
// |
//
//
//
// |
//
//
";
// $message.= "回覆连结 :
客户留言回覆";
// //用来判断开启mail
// $message.="
fields[0]."&MailType=SugMail\">";
// //echo $message;
// $to = $mail_cfg['service_contact.php']['to'];
// $bcc = $mail_cfg['service_contact.php']['bcc'];
// $TestTo = "freda.chang@wpi-group.com,stacy.hsu@wpi-group.com,youngsiang.wang@wpi-group.com";
// //echo '
', print_r($mail_cfg, true), '
';
// sendEmail($to,$bcc,'cnc_sys@channel.wpgcnc.com','世平伟业',$subject,$message,$TestTo);
// //sendEmail($to,$bcc,'youngsiang.wang@wpi-group.com','世平伟业',$subject,$message,$TestTo);
?>
// }
if(!empty($_GET["CaseNo"])){
$sql = "SELECT * from CCBU.dbo.TB_CtmrContact where No='".$_GET["CaseNo"]."'";
$parent = $mssql_conn->Execute($sql);
// $ro = $pdo -> query($sql);
// $parent = $ro -> fetchObject();
foreach($parent->fields as $k =>$v)
$parent->fields[$k] = htmlspecialchars_decode($v);
$Count = 0;
$History[$Count++] = $parent;
$ParentSerial = $parent -> fields["Parent"];
while(!empty($ParentSerial)){
$sql = "SELECT Created,Contents,ReplyMsg,ReplyTime,Parent from CCBU.dbo.TB_CtmrContact where Serial = ".$ParentSerial;
$Node = $mssql_conn->Execute($sql);
// $ro = $pdo -> query($sql);
// $Node = $ro -> fetchObject();
$History[$Count++] = $Node;
$ParentSerial = $Node -> fields["Parent"];
}
$History = array_reverse($History);
foreach($History as $row => $col){
foreach($col->fields as $colName => $value){
$History[$row]->fields[$colName] = htmlspecialchars_decode($value);
}
}
}
?>
公司 |
世平伟业(上海)有限公司 |
地址 |
上海市嘉定区金沙江西路1555弄37号D栋 |
全国服务热线 |
400-0805-699 |
若您有产品、销售相关或是其他疑问,请于下方留言,我们会尽快回覆。