php业务员查报表,PHP+CSS实现打印简单数据报表功能

刺骨的言语ヽ痛彻心扉 2023-01-16 03:23 93阅读 0赞

，表名：rec 字段：

rec\_id,rec\_po,rec\_part,rec\_plant,rec\_vendor,rec\_pur\_um,rec\_req\_date,rec\_req\_qty,rec\_rec\_qty,rec\_iqc\_date,rec\_notes

以下为引用的内容：

Daily Report

body \{

margin: 9px;

padding: 0;

color: black;

text-decoration: none;

font-size: 10pt;

font-family: "Courier New";

input \{

font-family: Arial;

th \{

font-weight: normal;

border-bottom: 1px solid black;

td \{

font-size: 9pt;

font-family: "Courier New";

td.pod \{

font-size: 11pt;

font-family: "Courier New";

th.pod \{

font-size: 11pt;

font-family: "Courier New";

td.endline \{

border-top: 1px solid black;

.left \{

text-align: left;

.right \{

text-align: right;

.center \{

text-align: center;

.top \{

vertical-align: top;

@media print \{

.noprint \{ display: none; \}

define ("SP10" ,'          ');

global re;

function db\_link()

access\_id = "root";

access\_pwd = "831025";

db\_name = "inv";

@ db = mysql\_connect('localhost', access\_id, access\_pwd) or

die("Could not connect to database. Please contact with IT supporting team ASAP.");

mysql\_query("SET NAMES 'GBK'");

mysql\_select\_db(db\_name);

return db;

link=db\_link();

<table> 
 <tbody> 
  <tr> 
   <td>Program : </td> 
   <td>bom_report.php</td> 
   <td>&lt;?php echo SP10;?&gt;</td> 
   <td>Date/Time : </td> 
   <td>&lt;?php echo date("Y-m-d").'/'.date("H:i:s");?&gt;</td> 
  </tr> 
  <tr> 
   <td> Plant : </td> 
   <td>SJ01</td> 
   <td>&lt;?php echo SP10;?&gt;</td> 
   <td> User Name : </td> 
   <td>liuxueping</td> 
  </tr> 
  <tr> 
   <td> Receiving Date : </td> 
   <td>&lt;?php echo date("Y-m-d").'/'.date("H:i:s");?&gt;</td> 
   <td>&lt;?php echo SP10;?&gt;</td> 
   <td> Page : </td> 
   <td>1</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <th> No. </th> 
   <th> Vendor </th> 
   <th> Part </th> 
   <th> Description </th> 
   <th> UM </th> 
   <th> Require Date </th> 
   <th> Require Qty </th> 
   <th> Deliver Qty </th> 
   <th> Receive Qty </th> 
   <th> IQC </th> 
   <th> Remark </th> 
  </tr> 
 </tbody> 
</table>

rec\_sql = "SELECT \* FROM rec WHERE rec\_plant = 'SJ01' ORDER BY rec\_id DESC";

rec\_res = mysql\_query(rec\_sql);

rec\_num = mysql\_num\_rows(rec\_res);

if(rec\_num>0)\{

for (i = 0; i < rec\_num; i++)\{

re++;

rec\_row = mysql\_fetch\_array(rec\_res);

part\_sql = "SELECT pt\_desc FROM part WHERE pt\_part='".rec\_row\['rec\_part'\]."' ";

part\_res = mysql\_query(part\_sql);

part\_row = mysql\_fetch\_array(part\_res);

echo'

'.(i+1).''.rec\_row\['rec\_vendor'\].''.rec\_row\['rec\_part'\].''.part\_row\['pt\_desc'\].''.rec\_row\['rec\_pur\_um'\].''.substr(rec\_row\['rec\_req\_date'\], 0, 10).''.number\_format(rec\_row\['rec\_req\_qty'\], 2).''.number\_format(rec\_row\['rec\_rec\_qty'\],2).''.number\_format(rec\_row\['rec\_rec\_qty'\],2).''.substr(rec\_row\['rec\_iqc\_date'\], 0 ,10).''.rec\_row\['rec\_notes'\].'';

//每页只打印10条记录，如果记录数是10的倍数后，显示'\*\*\*End of Report\*\*\*'并开始打印下一页

if(re%10 == 0 and re != rec\_num)\{

echo'

\*\*\* End of Report \*\*\* ';

//下一页开始打印

echo '

<table> 
 <tbody> 
  <tr> 
   <td>Program : </td> 
   <td>bom_pro.php</td> 
   <td>'.SP10.'</td> 
   <td>Date/Time : </td> 
   <td>'.date("Y-m-d").'/'.date("H:i:s").'</td> 
  </tr> 
  <tr> 
   <td> Plant : </td> 
   <td>SJ01</td> 
   <td>'.SP10.'</td> 
   <td> User Name : </td> 
   <td>lucas</td> 
  </tr> 
  <tr> 
   <td> Receiving Date : </td> 
   <td>'.date('Y-m-d').'</td> 
   <td>'.SP10.'</td> 
   <td> Page : </td> 
   <td>';echo re/10+1;echo'</td> 
  </tr> 
  <tr> 
   <td>&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

echo'

\*\*\* End of Report \*\*\* ';

else\{

echo'

exit;