function PF_orderemail($conn, $ordergroupid)
{
$XmlDoc = PF_LoadXmlDoc("Setup.xml");
$sSQLCmd = "select * from ordergroup where ordergroupid=" . PF_ReSqlCmd($ordergroupid, "N");
$row = PF_Get_rs($conn, $sSQLCmd);
if (mysql_num_rows($row) == 0) {
return false;
}
$rsodergroup = mysql_fetch_array($row);
$ordergroupnumber = $rsodergroup["ordergroupnumber"];
$id = PF_SearchXML($XmlDoc, "//參數設定檔/訂單處理情況/KIND/傳回值", "上稿編號", $rsodergroup["orderstatus"]);
if (isset($id) == false) {
return null;
}
//$ebody=PF_htmlbody($conn,$id);
$ebody = PF_ReadFile("email/orderemail.htm");
$mailtitle = PF_SearchXML($XmlDoc, "//參數設定檔/訂單處理情況/KIND/傳回值", "資料", $rsodergroup["orderstatus"]);
$paystatus = PF_SearchXML($XmlDoc, "//參數設定檔/付款方式/KIND/傳回值", "資料", $rsodergroup["paystatus"]);
$ebody = str_replace("[+paystatus+]", $paystatus, $ebody);
foreach ($rsodergroup as $_key => $_value) {
$ebody = str_replace("[+" . $_key . "+]", $_value, $ebody);
}
$orderbody = "<table border=0 cellpadding=1 cellspacing=1 width=\"100%\" align=\"center\" bordercolorlight=\"#666666\" bordercolordark=\"#FFFFFF\">";
$orderbody .= "<tr class=\"TitleBgcolor\">";
$orderbody .= "<td align=\"center\">商品分類</td>";
$orderbody .= "<td align=\"center\">產品名稱</td>";
$orderbody .= "<td align=\"center\">數量</td>";
$orderbody .= "<td align=\"center\">規格</td>";
$orderbody .= "<td align=\"center\">單價</td>";
$orderbody .= "<td align=\"center\">小計</td>";
$orderbody .= "<td align=\"center\">獲瓦數</td>";
$orderbody .= "</tr>";
$sSQLCmd = "select kindheadtitle,product.producttitle,productquality,productitemtitle,productprice,productbouns from orderdetail left join product on (orderdetail.productid=product.productid) left join kindhead on (product.kindheadid=kindhead.kindheadid) where ordergroupnumber=" . PF_ReSqlCmd($ordergroupnumber, "S");
$row = PF_Get_rs($conn, $sSQLCmd);
if (mysql_num_rows($row) > 0) {
while ($rs = mysql_fetch_array($row)) {
$j = $j + 1;
$bgclass = $j % 2 == 0 ? "DataBgcolor1" : "DataBgcolor2";
$orderbody .= "<tr class=\".{$bgclass}.\">";
$orderbody .= "<td align=right>" . $rs["kindheadtitle"] . " </td>";
$orderbody .= "<td align=right>" . $rs["producttitle"] . " </td>";
$orderbody .= "<td align=right>" . $rs["productquality"] . " </td>";
$orderbody .= "<td align=right>" . $rs["productitemtitle"] . " </td>";
$orderbody .= "<td align=right>" . $rs["productprice"] . " </td>";
$orderbody .= "<td align=right>" . PF_FN($rs["productquality"] * $rs["productprice"], 0) . " </td>";
$orderbody .= "<td align=right>" . $rs["productbouns"] . " </td>";
$orderbody .= "</tr>";
}
}
$orderbody .= "</table>";
$ebody = str_replace("[+paytxt+]", PF_ReadFile("email/paystatus" . $rsodergroup["paystatus"] . ".htm"), $ebody);
$ebody = str_replace("[+orderbody+]", $orderbody, $ebody);
$ebody = str_replace("[+FC_Section+]", FC_Section, $ebody);
$ebody = str_replace("[+FC_Portage+]", FC_Portage, $ebody);
$ebody = str_replace("[+FC_BankName+]", FC_BankName, $ebody);
$ebody = str_replace("[+FC_BankAccount+]", FC_BankAccount, $ebody);
$ebody = str_replace("[+FC_BankAccountName+]", FC_BankAccountName, $ebody);
$sSQLCmd = "select email from member where memberid=" . PF_ReSqlCmd($rsodergroup["memberid"], "N");
//echo $sSQLCmd;
$row = PF_Get_rs($conn, $sSQLCmd);
if (mysql_num_rows($row) > 0) {
$rs = mysql_fetch_array($row);
PF_SendEmail($rs["email"], FC_Email, FC_Company . "-" . $mailtitle . "[" . $ordergroupnumber . "]", FC_Company, FC_Email, $ebody, "");
}
}
<?php
include_once 'include/STANDARD.php';
PF_GETRequest();
$conn = PF_ConnString($DBString);
$XmlDoc = PF_LoadXmlDoc("Setup.xml");
$PAGE_NAME = "產品檢測報告查詢系統";
$Config['FC_WebTitle'] = $PAGE_NAME . " | " . $Config['FC_WebTitle'];
PJ_HTMLHead();
?>
<script language=JavaScript>
jQuery(document).ready(function () {
$('input:first').focus();
$('input').keyup(function(){
var inputs = $('input'); //先取得所有input元素
var maxlen = $(this).attr('maxlength'); //取得目前元素的maxlength
if( $(this).val().length == maxlen ){ //當滿足maxlength時...
inputs.eq( inputs.index($(this))+ 1 ).focus();
}
});
});
</script>
<link href="css/aacd.css" rel="stylesheet" type="text/css" />
</head>
