<!DOCTYPE html PUBLIC “-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN” “http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd”>
\n<html xmlns=”http:\/\/www.w3.org\/1999\/xhtml”>
\n<head>
\n<title>Daily Report <\/title>
\n<style rel=”stylesheet” type=”text\/css” media=”all” \/>
\nbody {
\nmargin: 9px;
\npadding: 0;
\ncolor: black;
\ntext-decoration: none;
\nfont-size: 10pt;
\nfont-family: “Courier New”;
\n}<\/p>\n
input {
\nfont-family: Arial;
\n}<\/p>\n
th {
\nfont-weight: normal;
\nborder-bottom: 1px solid black;
\n}<\/p>\n
td {
\nfont-size: 9pt;
\nfont-family: “Courier New”;
\n}<\/p>\n
td.pod {
\nfont-size: 11pt;
\nfont-family: “Courier New”;
\n}<\/p>\n
th.pod {
\nfont-size: 11pt;
\nfont-family: “Courier New”;
\n}<\/p>\n
td.endline {
\nborder-top: 1px solid black;
\n}<\/p>\n
.left {
\ntext-align: left;
\n}<\/p>\n
.right {
\ntext-align: right;
\n}<\/p>\n
.center {
\ntext-align: center;
\n}<\/p>\n
.top {
\nvertical-align: top;
\n}<\/p>\n
@media print {
\n.noprint { display: none; }
\n}
\n<\/style>
\n<\/head>
\n<body><\/p>\n
<?php<\/p>\n
define (“SP10” ,\u2019 \u2019);
\nglobal re;
\nfunction db_link()
\n{
\naccess_id = “root”;
\naccess_pwd = “831025”;
\ndb_name = “inv”;
\n@ db = mysql_connect(\u2019localhost\u2019, access_id, access_pwd) or
\ndie(“Could not connect to database. Please contact with IT supporting team ASAP.”);
\nmysql_query(“SET NAMES \u2019GBK\u2019”);
\nmysql_select_db(db_name);
\nreturn db;
\n}
\nlink=db_link();
\n?><\/p>\n
<table cellpadding=”2″ cellspacing=”3″>
\n<tr>
\n<td>Program : <\/td>
\n<td>bom_report.php<\/td>
\n<td><?php echo SP10;?><\/td>
\n<td>Date\/Time : <\/td>
\n<td><?php echo date(“Y-m-d”).\u2019\/\u2019.date(“H:i:s”);?><\/td>
\n<\/tr>
\n<tr>
\n<td> Plant : <\/td>
\n<td>SJ01<\/td>
\n<td><?php echo SP10;?><\/td>
\n<td> User Name : <\/td>
\n<td>liuxueping<\/td>
\n<\/tr>
\n<tr>
\n<td> Receiving Date : <\/td>
\n<td><?php echo date(“Y-m-d”).\u2019\/\u2019.date(“H:i:s”);?><\/td>
\n<td><?php echo SP10;?><\/td>
\n<td> Page : <\/td>
\n<td>1<\/td>
\n<\/tr>
\n<tr><td> <\/td><\/tr>
\n<table><\/p>\n
<table cellpadding=”2″ cellspacing=”3″>
\n<tr>
\n<th > No. <\/th>
\n<th > Vendor <\/th>
\n<th > Part <\/th>
\n<th > Description <\/th>
\n<th > UM <\/th>
\n<th > Require Date <\/th>
\n<th > Require Qty <\/th>
\n<th > Deliver Qty <\/th>
\n<th > Receive Qty <\/th>
\n<th > IQC <\/th>
\n<th > Remark <\/th>
\n<\/tr>
\n<?php<\/p>\n
rec_sql = “SELECT * FROM rec WHERE rec_plant = \u2019SJ01\u2019 ORDER BY rec_id DESC”;
\nrec_res = mysql_query(rec_sql);
\nrec_num = mysql_num_rows(rec_res);<\/p>\n
if(rec_num>0){
\nfor (i = 0; i < rec_num; i++){
\nre++;
\nrec_row = mysql_fetch_array(rec_res);<\/p>\n
part_sql = “SELECT pt_desc FROM part WHERE pt_part=\u2019”.rec_row[\u2019rec_part\u2019].”\u2019 “;
\npart_res = mysql_query(part_sql);
\npart_row = mysql_fetch_array(part_res);<\/p>\n
echo\u2019<tr>
\n<td>\u2019.(i+1).\u2019<\/td>
\n<td>\u2019.rec_row[\u2019rec_vendor\u2019].\u2019<\/td>
\n<td>\u2019.rec_row[\u2019rec_part\u2019].\u2019<\/td>
\n<td>\u2019.part_row[\u2019pt_desc\u2019].\u2019<\/td>
\n<td>\u2019.rec_row[\u2019rec_pur_um\u2019].\u2019<\/td>
\n<td>\u2019.substr(rec_row[\u2019rec_req_date\u2019], 0, 10).\u2019<\/td>
\n<td>\u2019.number_format(rec_row[\u2019rec_req_qty\u2019], 2).\u2019<\/td>
\n<td>\u2019.number_format(rec_row[\u2019rec_rec_qty\u2019],2).\u2019<\/td>
\n<td>\u2019.number_format(rec_row[\u2019rec_rec_qty\u2019],2).\u2019<\/td>
\n<td>\u2019.substr(rec_row[\u2019rec_iqc_date\u2019], 0 ,10).\u2019<\/td>
\n<td>\u2019.rec_row[\u2019rec_notes\u2019].\u2019<\/td>
\n<\/tr>\u2019;<\/p>\n
\/\/\u6bcf\u9875\u53ea\u6253\u537010\u6761\u8bb0\u5f55\uff0c\u5982\u679c\u8bb0\u5f55\u6570\u662f10\u7684\u500d\u6570\u540e\uff0c\u663e\u793a\u2019***End of Report***\u2019\u5e76\u5f00\u59cb\u6253\u5370\u4e0b\u4e00\u9875
\nif(re%10 == 0 and re != rec_num){
\necho\u2019
\n<tr>
\n<td colspan=”11″> *** End of Report *** <\/td>
\n<\/tr>
\n<\/table>\u2019;
\n\/\/\u4e0b\u4e00\u9875\u5f00\u59cb\u6253\u5370
\necho \u2019
\n<p style=”page-break-before:always;”> <\/p>
\n<table cellpadding=”2″ cellspacing=”3″>
\n<tr>
\n<td>Program : <\/td><td>bom_pro.php<\/td><td>\u2019.SP10.\u2019<\/td><td>Date\/Time : <\/td><td>\u2019.date(“Y-m-d”).\u2019\/\u2019.date(“H:i:s”).\u2019<\/td>
\n<\/tr>
\n<tr>
\n<td> Plant : <\/td><td>SJ01<\/td><td>\u2019.SP10.\u2019<\/td><td> User Name : <\/td><td>lucas<\/td>
\n<\/tr>
\n<tr>
\n<td> Receiving Date : <\/td><td>\u2019.date(\u2019Y-m-d\u2019).\u2019<\/td><td>\u2019.SP10.\u2019<\/td><td> Page : <\/td><td>\u2019;echo re\/10+1;echo\u2019<\/td>
\n<\/tr>
\n<tr>
\n<td> <\/td>
\n<\/tr>
\n<\/table>
\n<table cellpadding=”2″ cellspacing=”3″>
\n<tr>
\n<th > No. <\/th>
\n<th > Vendor <\/th>
\n<th > Part <\/th>
\n<th > Description <\/th>
\n<th > UM <\/th>
\n<th > Require Date <\/th>
\n<th > Require Qty <\/th>
\n<th > Deliver Qty <\/th>
\n<th > Receive Qty <\/th>
\n<th > IQC <\/th>
\n<th > Remark <\/th>
\n<\/tr>\u2019;
\n}
\n}<\/p>\n
echo\u2019
\n<tr>
\n<td colspan=”11″> *** End of Report *** <\/td>
\n<\/tr>
\n<tr>
\n<td>
\n<input type=”button” name=”print” value=”Print” onclick=”window.print()”>
\n<\/td>
\n<td colspan=”11″>
\n<input type=”button” name=”close” value=”Close Window” onclick=”window.close()”>
\n<\/td>
\n<\/tr>
\n<\/table>\u2019;
\n}
\nelse{
\necho\u2019<script>alert(“Have no records!”)\u2019;
\nexit;
\n}
\n?><\/p>\n","protected":false},"excerpt":{"rendered":"
<!DOCTYPE html PUBLIC “-\/...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-178","post","type-post","status-publish","format-standard","hentry","category-phpjsshell"],"_links":{"self":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=178"}],"version-history":[{"count":4,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions"}],"predecessor-version":[{"id":181,"href":"https:\/\/www.01xj.net\/index.php?rest_route=\/wp\/v2\/posts\/178\/revisions\/181"}],"wp:attachment":[{"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.01xj.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}