42 lines
1.2 KiB
PHP
42 lines
1.2 KiB
PHP
<?php
|
|
require_once("config/db.php");
|
|
mysqli_report(MYSQLI_REPORT_OFF);
|
|
|
|
$hn = "0005969";
|
|
$nn = "690619000132"; // 690619000132
|
|
$vn1 = $nn; // Assuming vn1 is nn for testing
|
|
|
|
echo "TESTING VN: $vn1\n";
|
|
|
|
// Test opitemrece
|
|
$sql = "select count(*) as cc from opitemrece where vn='$vn1'";
|
|
$res = mysqli_query($conn1, $sql);
|
|
$row = mysqli_fetch_assoc($res);
|
|
echo "opitemrece (vn='$vn1'): " . $row['cc'] . " rows\n";
|
|
|
|
// Test opitemrece with AN
|
|
$sql = "select count(*) as cc from opitemrece where an='$vn1'";
|
|
$res = mysqli_query($conn1, $sql);
|
|
$row = mysqli_fetch_assoc($res);
|
|
echo "opitemrece (an='$vn1'): " . $row['cc'] . " rows\n";
|
|
|
|
// Test lab_head
|
|
$sql = "select count(*) as cc from lab_head where vn='$vn1'";
|
|
$res = mysqli_query($conn1, $sql);
|
|
$row = mysqli_fetch_assoc($res);
|
|
echo "lab_head (vn='$vn1'): " . $row['cc'] . " rows\n";
|
|
|
|
// Test xray_report
|
|
$sql = "select count(*) as cc from xray_report where vn='$vn1' or an='$vn1'";
|
|
$res = mysqli_query($conn1, $sql);
|
|
$row = mysqli_fetch_assoc($res);
|
|
echo "xray_report: " . $row['cc'] . " rows\n";
|
|
|
|
// Test ovst
|
|
$sql = "select an, vn from ovst where vn='$vn1' or an='$vn1'";
|
|
$res = mysqli_query($conn1, $sql);
|
|
while($row = mysqli_fetch_assoc($res)){
|
|
echo "ovst match: vn=" . $row['vn'] . ", an=" . $row['an'] . "\n";
|
|
}
|
|
?>
|