<?php
// 1. 從數據庫查詢訂單數據
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("連接數據庫失敗: " . $conn->connect_error);
}
$sql = "SELECT * FROM orders";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
// 2. 構建發(fā)貨單內容
$orderNumber = $row['order_number'];
$customerName = $row['customer_name'];
$shippingAddress = $row['shipping_address'];
// 其他字段根據需要自行添加
$invoiceContent = "<h1>發(fā)貨單</h1>";
$invoiceContent .= "<p>訂單號：" . $orderNumber . "</p >";
$invoiceContent .= "<p>收貨人姓名：" . $customerName . "</p >";
$invoiceContent .= "<p>收貨地址：" . $shippingAddress . "</p >";
// 其他字段也可以在此處添加到發(fā)貨單內容中
// 3. 打印發(fā)貨單
$printerDevice = "TP874VHH172"; // 打印機設備名稱
$printerHandle = printer_open($printerDevice);
if (!$printerHandle) {
echo "無法打開打印機，請檢查打印機驅動程序是否正確安裝。";
exit;
}
$printerStatus = printer_status($printerHandle);
if ($printerStatus['status'] == PRINTER_STATUS_ERROR) {
echo "打印機錯誤，請檢查打印機是否正常工作。";
exit;
}
// 設置打印機參數，如紙張類型、對齊方式等
printer_set_option($printerHandle, PRINTER_MODE, "RAW");
printer_set_option($printerHandle, PRINTER_TEXT_ALIGN, PRINTER_TA_LEFT);
// 開始打印
printer_start_doc($printerHandle, "發(fā)貨單");
printer_start_page($printerHandle);
printer_set_option($printerHandle, PRINTER_PAPER_FORMAT, PRINTER_FORMAT_CUSTOM);
printer_set_option($printerHandle, PRINTER_PAPER_WIDTH, 80); // 假設紙張寬度為80字符
printer_write($printerHandle, $invoiceContent);
printer_end_page($printerHandle);
printer_end_doc($printerHandle);
printer_close($printerHandle);
// 4. 將發(fā)貨單保存為文件并發(fā)送到指定位置
$fileLocation = "path/to/save/invoice_" . $orderNumber . ".pdf";
$pdf = new TCPDF(); // 假設您已經安裝了TCPDF庫
$pdf->AddPage();
$pdf->writeHTML($invoiceContent);
$pdf->Output($fileLocation, 'F');
// 發(fā)送到指定位置（假設通過電子郵件發(fā)送）
$recipientEmail = "[email protected]";
$subject = "發(fā)貨單";
$message = "請查收附件中的發(fā)貨單。";
$attachment = $fileLocation;
$headers = "From: [email protected]\r\n";
$headers .= "Reply-To: [email protected]\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"boundary\"\r\n";
$fileContent = file_get_contents($attachment);
$fileType = mime_content_type($attachment);
$fileName = basename($attachment);
$message .= "--boundary\r\n";
$message .= "Content-Type: " . $fileType . "; name=\"" . $fileName . "\"\r\n";
$message .= "Content-Transfer-Encoding: base64\r\n";
$message .= "Content-Disposition: attachment; filename=\"" . $fileName . "\"\r\n\r\n";
$message .= chunk_split(base64_encode($fileContent)) . "\r\n";
$message .= "--boundary--";
mail($recipientEmail, $subject, $message, $headers);
}
} else {
echo "沒有找到訂單數據。";
}
$conn->close();
?>
怎么用我也不會。有會的來教一下。媽的二開的跑路了，工程爛尾了
