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>