invisio v2.0

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

$member_id = mysqli_real_escape_string($connection, $_POST['member_id']);
$register_type = mysqli_real_escape_string($connection, $_POST['register_type']);
$register_level = mysqli_real_escape_string($connection, $_POST['register_level']);
if ($register_level == 'g9k1s') {
    $level = '1';
} elseif ($register_level == 'kki22') {
    $level = '2';
} elseif ($register_level == 'x9fkq') {
    $level = '3';
}

$table_detail = "";
if ($register_type == 1) {
    $table_detail = "tbl_member_detail_employer";
} // ทั่วไป 
else if ($register_type == 2) {
    $table_detail = "tbl_member_detail_company";
} // สมาชิกสามัญ
else if ($register_type == 3) {
    $table_detail = "tbl_member_detail_agency";
} // วิสมาชิกสามัญ
else if ($register_type == 4) {
    $table_detail = "tbl_member_detail_worker";
} // กิติมาศักดิ์

// $sql_doc = "SELECT * FROM $table_detail WHERE member_id = '$member_id'";
// // $sql_doc = "SELECT * FROM tbl_member_document WHERE member_id = '$member_id' ORDER BY document_list_order ASC";
// $res_doc = mysqli_query($connection, $sql_doc);
// $row_doc = mysqli_fetch_assoc($res_doc);

$sql_doc = "SELECT * FROM tbl_member_document WHERE member_id = '$member_id' ORDER BY document_list_order ASC";
// $sql_doc = "SELECT * FROM tbl_member_document WHERE member_id = '$member_id' ORDER BY document_list_order ASC";
$res_doc = mysqli_query($connection, $sql_doc);
$num_list = mysqli_num_rows($rs);

$sql = "SELECT * FROM tbl_register_document WHERE register_type = '$level' AND member_type = '$register_type' ORDER BY list_order ASC";
$rs = mysqli_query($connection, $sql);
$num_list = mysqli_num_rows($rs);

?>
<div class="modal-header">
    <h4 class="modal-title">สถานะเอกสาร</h4>
    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
</div>
<div class="modal-body">

<?php while ($row_doc = mysqli_fetch_assoc($res_doc)) {

$file_type = explode('.', $row_doc['document_file_name']);
            if (strtolower($file_type[1]) == 'pdf') {
        ?>
                <div class="mb-2" style="position:relative; width:200px">
                    <button type="button" class="btn btn-danger btn-sm text-white" onclick="DeleteApp('<?php echo $row_doc['document_id']; ?>')" style="position:absolute; top:0; right:0;">X</button>
                    <a href="../../../main/upload/join/file/<?php echo $row_doc['document_file_name']; ?>" target="_blank">
                        <img src="../../../main/upload/join/file/pdf_icon.jpg" alt="" width="200px">
                    </a>
                </div>
            <?php } else { ?>
                <div class="mb-2" style="position:relative; width:200px">
                    <button type="button" class="btn btn-danger btn-sm text-white" onclick="DeleteApp('<?php echo $row_doc['document_id']; ?>')" style="position:absolute; top:0; right:0;">X</button>
                    <a href="../../../main/upload/join/file/<?php echo $row_doc['document_file_name']; ?>" target="_blank">
                        <img src="../../../main/upload/join/file/<?php echo $row_doc['document_file_name']; ?>" alt="" width="200px">
                    </a>
                </div>
        <?php }
        } ?>

<div class="btn badge-warning btn-xs p-1 mb-2 w-100" onclick="AddDocument('<?php echo $member_id ?>','<?php echo $register_type ?>','<?php echo $_POST['register_level'] ?>')">แนบเอกสารเพิ่มเติม</div>

</form>

<form action="" id="update_document" method="POST" enctype="multipart/form-data">
        <input type="hidden" name="member_id" value="<?php echo $_POST['member_id'] ?>">
        <input type="hidden" name="register_type" value="<?php echo $_POST['register_type'] ?>">
        <div class="mb-2">
            <label for="">สถานะเอกสาร</label><br>
            <select name="approve_status" id="approve_status" class="form-select  form-select-solid" style="width: 100%;">
                <option value="1">ตรวจเอกสารแล้ว</option>
                <option value="9">รอแก้ไข</option>
                
            </select>
        </div>
        <!-- <div>
            <label for="">แนบไฟล์เพิ่มเติม</label>
            <input type="file" name="document_file[]" id="image_file" class="form-control" multiple>

</div> -->
        <div class="mb-2">
            <label for="">หมายเหตุ</label>
            <textarea name="doc_remark" id="doc_remark" cols="30" rows="5" class="form-control"></textarea>
        </div>
    </form>
</div>
<div class="modal-footer">
    <button type="button" class="btn btn-primary" onclick="UpdateDocument()"><i class="fa fa-check"></i>&nbsp;บันทึก</button>
    <button type="button" class="btn btn-white" data-dismiss="modal">ปิด</button>
</div>
<script>
    $(document).ready(function() {
        $(".form-select").select2();
    });
</script>