invisio v2.0

<?php

use function PHPSTORM_META\type;

session_start();
include('../../../config/main_function.php');
$secure = "cAh3DrJACzw4RbU";
$connection = connectDB($secure);

$sql_system = "SELECT * FROM tbl_system_setting WHERE setting_id = '1'";
$rs_system = mysqli_query($connection, $sql_system);
$row_system = mysqli_fetch_array($rs_system);

$key = $row_system['secure_text'];
$pointer = $row_system['secure_pointer'];

$search = mysqli_real_escape_string($connection, $_POST['search']);
$date_start = date_picker(mysqli_real_escape_string($connection, $_POST['date_start']));
$date_end = date_picker(mysqli_real_escape_string($connection, $_POST['date_end']));
$member_id = mysqli_real_escape_string($connection, $_POST['member_id']);
$temp_id = explode(".", $member_id);
$ref_member_id = bigsara_decode($temp_id[0], $temp_id[1]);

$sql_member = "SELECT rhead.*
,rdetail.*
,mem.register_level
,mem.register_type
,memd.title_name
,memd.company_name
,memd.company_phone
,memd.company_email
,rhead.receipt_id
,rhead.create_datetime
FROM tbl_receipt_head rhead
LEFT JOIN tbl_receipt_detail rdetail ON rdetail.receipt_id = rhead.receipt_id
LEFT JOIN tbl_member mem ON mem.member_id = rhead.member_id
LEFT JOIN tbl_member_detail memd ON memd.member_id = rhead.member_id
WHERE mem.ref_member_id = '$ref_member_id' AND rhead.create_datetime BETWEEN '$date_start 00:00:00' AND '$date_end 23:59:59'
ORDER BY rhead.receipt_no DESC
";
$rs_member = mysqli_query($connection, $sql_member) or die($connection->error);

?>
<style>

</style>
<div class="table-responsive">
    <table class="table table-striped dataTables-example table-bordered">
        <thead>
            <tr>
                <th class="w-auto">วันที่ออก</th>
                <th class="w-auto">เลขที่</th>
                <th class="w-auto">ลูกค้า</th>
                
                <th class="w-auto">ยอดรวมสุทธิ</th>
                <th style="width: 10%;"></th>
            </tr>
        </thead>
        <tbody>
            <?php $i = 1;
            while ($row_member = mysqli_fetch_assoc($rs_member)) {

$register_type = $row_member['register_type'];

if ($register_type == 1) {
                    $register_type = 'นายจ้าง';
                } elseif ($register_type == 2) {
                    $register_type = 'บนจ.';
                } elseif ($register_type == 3) {
                    $register_type = 'Agency';
                } elseif ($register_type == 4) {
                    $register_type = 'แรงงาน';
                }

$register_level = $row_member['register_level'];

if ($register_level == 'g9k1s') {
                    $register_level = 'ทั่วไป';
                } elseif ($register_level == 'kki22') {
                    $register_level = 'วิสามัญ';
                } elseif ($register_level == 'x9fkq') {
                    $register_level = 'สามัญ.';
                }

$temp_title = explode(" ", getTitle_name($row_member['title_name']));
                $title_th = $temp_title[0];
                $title_en = $temp_title[2];

$member_id_temp = bigsara_encode($row_member['member_id'], $row_member['secure_text'], $row_member['secure_pointer']);
                $member_id = $member_id_temp . "." . $row_member['secure_text'];

?>
                <tr>
                    <td>
                        <?php echo date("d/m/Y", strtotime($row_member['receipt_date'])); ?>
                    </td>
                    <td>
                        <a href="account_receipt_view?re=<?php echo $row_member['receipt_id']; ?>"><?php echo $row_member['receipt_no']; ?></a>
                    </td>
                    <td>

<a href="member_detail?id=<?php echo $member_id ?>&type=<?php echo $row_member['register_type'] ?>&level=<?php echo $row_member['register_level'] ?>" target="_blank">
                            <?php echo ($row_member['customer_name'] != "") ? $title_th . " " . $row_member['customer_name'] : $title_en . " " . $row_member['customer_name_en'] ?>
                        </a>
                        <br>
                        <?php echo $row_member['company_name'] ?> <br>
                        โทร : <?php echo $row_member['company_phone']; ?><br>
                        Email : <?php echo $row_member['company_email']; ?><br>
                        
                    </td>

<td>
                        <?php echo number_format($row_member['total_amount'], 2) ?>
                    </td>
                    <td>
                        
                        <button class="btn btn-info btn-sm w-100" onclick="ModalPrint('<?php echo $row_member['receipt_id']; ?>')">พิมพ์</button>
                        
                    </td>
                </tr>
            <?php $i++;
            } ?>
        </tbody>
    </table>
</div>