 |
|
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$Certnum = "QA-20-0387"; //QA-20-0868 "QA-20-0387"
//$Certnum = $_POST['certnum'];
$sql = "{call rpt_tpp_QcCertificateIN_Report(?)}";
$params = array(
array($Certnum, SQLSRV_PARAM_IN)
);
$query = sqlsrv_query($conn, $sql, $params);
while($result = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC))
{
// Require composer autoload ท่อนนี้จะเอาไปออก pdf
require_once __DIR__ . '/vendor/autoload.php';
// Create an instance of the class:
$mpdf = new \Mpdf\Mpdf([
'default_font_size' => 16,
'default_font' =>'sarabun',
'mode' => 'utf-8',
'format' => 'A4-L'
]
);
$Customer ='<div style="position:absolute;top:150px;left:207px;">'.$result["Customer"].'</div>';
//ติดปัญหาครับ อยากให้ระบบตรวจสอบว่าถ้ามีค่า 0 ให้พิมพ์ Wait ถ้ามีค่าให้พิมพ์ออกมาปกติ
if (in_array(0($Con_C)){
$MaxCon_C = '<div style="font-size:16px;position:absolute;top:415px;left:360px;">Wait</div>';
$Con_C ='<div style="font-size:16px;position:absolute;top:405px;left:360px;">Wait</div>';
} else {
$MaxCon_C ='<div style="font-size:16px;position:absolute;top:415px;left:360px;">max</div>';
$Con_C ='<div style="font-size:16px;position:absolute;top:405px;left:360px;">'.number_format($result["Con_C"],3).'</div>';
}
$mpdf->SetDocTemplate('cert.pdf',true);
$mpdf->WriteHTML($Customer);
$mpdf->WriteHTML($Con_C);
$mpdf->WriteHTML($MaxCon_C);
$mpdf->Output();
}
sqlsrv_close($conn);
?>
Tag : PHP, Ms SQL Server 2012, HTML, Apache
|
|
 |
 |
 |
 |
Date :
2021-01-08 13:31:56 |
By :
2007513406127110 |
View :
1380 |
Reply :
9 |
|
 |
 |
 |
 |
|
|
|
 |