invisio v2.0

<?php
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);

$secure_text = $row_system['secure_text'];

$register_type = mysqli_real_escape_string($connection, $_POST['register_type']);

$temp_id = mysqli_real_escape_string($connection, $_POST['member_id']);
$temp_member_id = explode(".", $temp_id);
$member_id = bigsara_decode($temp_member_id[0], $temp_member_id[1]);

$sql_member = "SELECT * FROM tbl_member WHERE member_id = '$member_id'";
$res_member = mysqli_query($connection, $sql_member);
$row_member = mysqli_fetch_assoc($res_member);

$sql_join = "SELECT * FROM tbl_member_detail_worker WHERE member_id = '$member_id';";
$rs_join = mysqli_query($connection, $sql_join);
$row_join = mysqli_fetch_array($rs_join);

$sql_payment = "SELECT * FROM tbl_member_payment WHERE member_id = '$member_id';";
$rs_payment = mysqli_query($connection, $sql_payment);
$row_payment = mysqli_fetch_array($rs_payment);

function zipCode($connection, $zipcode)
{
    $arr = [];
    $province = "";
    $amphoe = "";
    $district = "";
    $sql_distirct1 = "SELECT * FROM tbl_district  WHERE district_id = '$zipcode' ";
    $rs_distirct1 = mysqli_query($connection, $sql_distirct1);
    $row_distirct1 = mysqli_fetch_array($rs_distirct1);
    if ($row_distirct1) {
        $sql_amphoe = "SELECT * FROM tbl_amphoe WHERE amphoe_id = '" . $row_distirct1['ref_amphoe'] . "';";
        $rs_amphoe = mysqli_query($connection, $sql_amphoe);
        $row_amphoe = mysqli_fetch_array($rs_amphoe);
        if ($row_amphoe) {
            $amphoe = $row_amphoe['amphoe_name_th'];

$sql_province = "SELECT * FROM tbl_province WHERE province_id  = '" . $row_amphoe['ref_province'] . "';";
            $rs_province = mysqli_query($connection, $sql_province);
            $row_province = mysqli_fetch_array($rs_province);
            if ($row_province) {
                $province = $row_province['province_name_th'];
            }
        }
    }

$arr['province'] = $province;
    $arr['amphoe'] = $amphoe;
    $arr['district'] = $row_distirct1['district_zipcode'];
    return $arr;
}

$register_level = mysqli_real_escape_string($connection, $_POST['register_level']);

if ($register_level == 'g9k1s') {
    $level = 1;
} else if ($register_level == 'kki22') {
    $level = 2;
} else if ($register_level == 'x9fkq') {
    $level = 3;
}

?>
<form id="form_submit" method="POST" enctype="multipart/form-data">
    <div class="container mb-5 px-0">
        <div class="ibox">
            <div class="ibox-content">
                <input type="hidden" class="form-control" id="member_id" name="member_id" value="<?php echo $member_id ?>">
                <input type="hidden" class="form-control" id="register_type" name="register_type" value="<?php echo $register_type; ?>">
                <input type="hidden" class="form-control" id="register_level" name="register_level" value="<?php echo $register_level; ?>">
                <label for=""><b>1.ข้อมูลสมัครสมาชิก</b></label>
                <div class="row mb-2">
                    <div class="col-lg-5 col-12 mb-2">
                        <b>Username</b>
                        <input type="text" class="form-control" id="username" name="username" value="<?php echo $row_member['username']; ?>">
                    </div>
                    <div class="col-lg-5 col-12 mb-2">
                        <b>Password</b>
                        <input type="text" class="form-control" id="password" name="password" value="">
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-2 col-12 mb-2">
                        <b>คำนำหน้านาม<span class="text-danger">*</span></b><br>
                        <select name="title_name" id="title_name" class="form-select w-100">
                            <option value="1" <?php echo ($row_join['title_name'] == 1 ? 'selected' : '') ?>>นาย ( Mr. )</option>
                            <option value="2" <?php echo ($row_join['title_name'] == 2 ? 'selected' : '') ?>>นางสาว ( Miss )</option>
                            <option value="3" <?php echo ($row_join['title_name'] == 3 ? 'selected' : '') ?>>นาง ( Mrs. )</option>
                            <option value="4" <?php echo ($row_join['title_name'] == 4 ? 'selected' : '') ?>>อื่นๆ</option>
                        </select>
                    </div>
                    <div class="col-lg-5 col-12 mb-2">
                        <b>ชื่อ - นามสกุล <span class="text-danger">*</span></b>
                        <input type="text" class="form-control" id="member_name" name="member_name" value="<?php echo bigsara_decode($row_join['member_name'], $secure_text); ?>">
                    </div>
                    <div class="col-lg-5 col-12 mb-2">
                        <b>ชื่อ - นามสกุลภาษาอังกฤษ</b>
                        <input type="text" class="form-control" id="member_name_en" name="member_name_en" value="<?php echo bigsara_decode($row_join['member_name_en'], $secure_text); ?>">
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-3 col-12 mb-2">
                        <b>สัญชาติ<span class="text-danger">*</span></b>
                        <select name="country" id="country" class="form-select w-100">
                            <option value="<?php echo $row_join['race'] ?>" selected><?php echo $row_join['race'] ?></option>
                            <?php
                            $sql_country = "SELECT * FROM tbl_country";
                            $res_country = mysqli_query($connection, $sql_country);
                            while ($row_country = mysqli_fetch_assoc($res_country)) {
                            ?>
                                <option value="<?php echo $row_country['ct_code']; ?>" <?php echo ($row_join['race'] == $row_country['ct_code'] ? 'selected' : '') ?>><?php echo $row_country['ct_nameTHA']; ?></option>
                            <?php
                            }
                            ?>
                        </select>
                    </div>

<div class="col-lg-4 col-12 mb-2">
                        <b>วันเดือนปี เกิด <small class="text-danger">( วัน/เดือน/ปี พ.ศ. )</small><span class="text-danger">*</span></b>
                        <input type="text" id="birth_date" name="birth_date" class="form-control" data-mask="99/99/9999" placeholder="" onchange="checkDate('birth_date');" value="<?php echo date('d/m/Y', strtotime($row_join['birth_date'] + 543)) ?>">
                    </div>

<div class="col-lg-4 col-12 mb-2">
                        <b>รูปถ่ายใบสมัคร ไม่เกิน 6 เดือน <small class="text-danger">(ขนาดรูปที่แนะนำ 1200x900 px)</small></b>
                        <input type="hidden" id="profile_img" name="profile_img" value="<?php echo $row_join['profile_image']; ?>">
                        <div class="row ml-1">
                            <div class="col-md-10 col-9 show_upload_image mt-1" hidden>
                                <div class="row">
                                    <div class="col-md-5 ml-4"><span style="color: green;"><b>แนบรูปภาพแล้ว</b></span></div>
                                    <div class="col-md-1 col-1">
                                        <a href="javascript:void(0);" onclick="change_image();"><i class="fa fa-search"></i></a>
                                    </div>
                                    <div class=" col-md-1 col-1">
                                        <a href="javascript:void(0);" onclick="remove_image();"><i class="fa fa-close"></i></a>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-10 col-9 custom-file">
                                <div class="">
                                    <input id="profile_image" name="profile_image" type="file" class="custom-file-input" accept="image/png, image/gif, image/jpeg" onchange="readURL01(this);">
                                    <label for="profile_image" class="custom-file-label"><i class="fa fa-search"></i> </label>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-2">
                    <div class="col-lg-4 col-12 mb-2">
                        <b>หนังสือเดินทาง </b>
                        <input type="text" class="form-control" id="passport_no" name="passport_no" maxlength="13" value="<?php echo bigsara_decode($row_join['passport_no'], $secure_text); ?>">
                        <span class="text-danger" id="passport_no_ch" hidden> (กรุณากรอกข้อมูลให้ครบ 13 หลัก) </span>
                    </div>
                    <div class="col-lg-4 col-12 mb-2">
                        <b>หมดอายุวันที่ <small class="text-danger">( วัน/เดือน/ปี พ.ศ. )</small></b>
                        <input type="text" id="passport_expire_date" name="passport_expire_date" class="form-control" data-mask="99/99/9999" placeholder="" onchange="checkDate('passport_expire_date');" value="<?php echo date('d/m/', strtotime($row_join['passport_expire_date'])) . date('Y', strtotime($row_join['passport_expire_date'] + 543)) ?>">
                    </div>
                </div>

<div class="row mb-2">
                    <div class="col-lg-4 col-12 mb-2">
                        <b>เลขบัตรประจำตัว / ใบอนุญาตทำงาน<span class="text-danger">*</span></b>
                        <input type="text" class="form-control" id="citizen_no" name="citizen_no" value="<?php echo bigsara_decode($row_join['citizen_no'], $secure_text); ?>">
                    </div>
                    <!-- <div class="col-lg-4 col-12 mb-2">
                        <b>วันที่ออกบัตร <small class="text-danger">( วัน/เดือน/ปี พ.ศ. )</small> <span class="text-danger">*</span></b>
                        <input type="text" id="card_register_date" name="card_register_date" class="form-control" data-mask="99/99/9999" placeholder="" onchange="checkDate('card_register_date');">

</div> -->
                    <div class="col-lg-4 col-12 mb-2">
                        <b>หมดอายุวันที่ <small class="text-danger">( วัน/เดือน/ปี พ.ศ. )</small> <span class="text-danger">*</span></b>
                        <input type="text" id="card_expire_date" name="card_expire_date" class="form-control" data-mask="99/99/9999" placeholder="" onchange="checkDate('card_expire_date');" value="<?php echo date('d/m/', strtotime($row_join['card_expire_date'])) . date('Y', strtotime($row_join['card_expire_date'] + 543))  ?>">

</div>

</div>
                <div class="row mb-2">
                    <div class="col-lg-4 col-12 mb-2">
                        <b>การอนุญาตเข้าเมือง / Visa No.<span class="text-danger">*</span></b>
                        <input type="text" class="form-control" id="visa_no" name="visa_no" value="<?php echo bigsara_decode($row_join['visa_no'], $secure_text); ?>">
                    </div>
                    <!-- <div class="col-lg-4 col-12 mb-2">
                        <b>วันที่ออกบัตร <small class="text-danger">( วัน/เดือน/ปี พ.ศ. )</small> <span class="text-danger">*</span></b>
                        <input type="text" id="card_register_date" name="card_register_date" class="form-control" data-mask="99/99/9999" placeholder="" onchange="checkDate('card_register_date');">

</div> -->
                    <div class="col-lg-4 col-12 mb-2">
                        <b>หมดอายุวันที่ <small class="text-danger">( วัน/เดือน/ปี พ.ศ. )</small> <span class="text-danger">*</span></b>
                        <input type="text" id="visa_expire_date" name="visa_expire_date" class="form-control" data-mask="99/99/9999" placeholder="" onchange="checkDate('visa_expire_date');" value="<?php echo date('d/m/', strtotime($row_join['visa_expire_date'])) . date('Y', strtotime($row_join['visa_expire_date'] + 543)) ?>">

</div>

</div>
                <div class="row mb-2">
                    <div class="col-lg-12 col-12 mb-2">
                        <b>ที่อยู่ / ที่พักอาศัย ในไทย</b> <span class="text-danger">*</span>
                        <input type="text" class="form-control" id="card_address" name="card_address" onchange="change_address(this.value)" placeholder="เลขที่ หมู่ ซอย ถนน" value="<?php echo $row_join['card_address']; ?>">
                    </div>

</div>
                <div class="row mb-2">
                    <?php
                    $postcode = zipCode($connection, $row_join['card_district_id']);
                    ?>
                    <div class="col-lg-3 col-12 mb-2">
                        <b> รหัสไปรษณีย์ <span class="text-danger">*</span></b>
                        <input type="text" class="form-control" id="postcode" name="postcode" onchange="selectPostCode(this.value)" value="<?php echo ($postcode['district'] != '') ? $postcode['district'] : ''; ?>" maxlength="10" onkeypress="return chkNumber(event)">
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>ตำบล</b>
                        <br><span id="show_district1">
                            <?php if (!empty($row_join['card_district_id'])) { ?>
                                <select id="card_district_id" name="card_district_id" class="form-control">
                                    <?php
                                    $sql_distirct1 = "SELECT * FROM tbl_district  WHERE district_zipcode = '{$postcode['district']}'";
                                    $rs_distirct1 = mysqli_query($connection, $sql_distirct1);
                                    $check = mysqli_num_rows($rs_distirct1);

foreach ($rs_distirct1 as $key => $item) {
                                    ?>
                                        <option value="<?php echo $item['district_id'] ?>" <?php if ($item['district_id'] == $row_join['card_district_id']) {
                                                                                                echo "selected";
                                                                                            } ?>><?php echo $item['district_name_th'] ?></option>
                                    <?php
                                    }

?>
                                </select>
                            <?php } ?>
                        </span>
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>อำเภอ</b>
                        <br><span id="show_ampoe1"><?php echo $postcode['amphoe']; ?></span>
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>จังหวัด</b>
                        <br><span id="show_province1"><?php echo $postcode['province']; ?></span>
                    </div>
                </div>

<div class="row mb-2">
                    <div class="col-lg-4 col-12 mb-2">
                        <b>เบอร์โทรติดต่อ</b>
                        <input type="text" class="form-control" id="phone" name="phone" value="<?php echo bigsara_decode($row_join['phone'], $secure_text); ?>">
                    </div>
                    <div class="col-lg-8 col-12 mb-2">
                        <b>อีเมล</b>
                        <input type="text" class="form-control" id="email" name="email" value="<?php echo bigsara_decode($row_join['email'], $secure_text); ?>">
                    </div>
                </div>

<label for="" class="mt-3"><b>2.ข้อมูลการทำงาน</b></label>
                <div class="row mb-2">
                    <div class="col-lg-8 col-12 mb-2">
                        <b>ชื่อสถานที่ทำงาน</b>
                        <input type="text" class="form-control" id="company_name" name="company_name" value="<?php echo $row_join['company_name'] ?>">
                    </div>
                    <div class="col-lg-4 col-12 mb-2">
                        <b>เลขที่ประจำตัวผู้เสียภาษี</b>
                        <input type="text" class="form-control" id="company_tax_no" name="company_tax_no" value="<?php echo $row_join['company_tax_no'] ?>" onkeypress="return chkNumber(event)" maxlength="13">
                        <span class="text-danger" id="company_tax_ch" hidden> (กรุณากรอกข้อมูลให้ครบ 13 หลัก) </span>
                    </div>

</div>
                <div class="row mb-2">

<div class="col-lg-4 col-12 mb-2">
                        <b>ตำแหน่งงาน</b>
                        <input type="text" class="form-control" id="position" name="position" value="<?php echo $row_join['position']; ?>">
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-6 col-12 mb-2">
                        
                        <input type="checkbox" id="checkboxaddress" name="checkboxaddress" onchange="selectCheckbox();">
                        <span>&nbsp;&nbsp;ใช้ที่อยู่ เดียวกับที่อยู่ตามบัตรประจำตัวประชาชน</span>
                        
                    </div>
                </div>

<div class="row mb-2">
                    <div class="col-lg-12 col-12 mb-2">
                        <b>ที่อยู่บริษัท</b> <span class="text-danger">*</span>
                        <input type="text" class="form-control" id="company_address" name="company_address" placeholder="เลขที่ หมู่ ซอย ถนน" value="<?php echo $row_join['company_address'] ?>">
                    </div>
                </div>

<div class="row mb-2">
                    <?php
                    $postcode2 = zipCode($connection, $row_join['company_district_id']);
                    ?>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>รหัสไปรษณีย์ <span class="text-danger">*</span></b>
                        <input type="text" class="form-control" id="zipcode" name="zipcode" onchange="selectZipCode(this.value)" value="<?php echo $postcode2['district']; ?>" maxlength="10" onkeypress="return chkNumber(event)">
                    </div>

<div class="col-lg-3 col-12 mb-2">
                        <b>ตำบล</b>
                        <br><span id="show_district2">
                            <?php if (!empty($row_join['company_district_id'])) { ?>
                                <select id="company_district_id" name="company_district_id" class="form-control">
                                    <?php
                                    $postcode2 = zipCode($connection, $row_join['company_district_id']);

$sql_distirct1 = "SELECT * FROM tbl_district  WHERE district_zipcode = '" . $postcode2['district'] . "'";
                                    $rs_distirct1 = mysqli_query($connection, $sql_distirct1);
                                    ?>

<option value=""></option>
                                    <?php
                                    foreach ($rs_distirct1 as $key => $item) {
                                    ?>
                                        <option value="<?php echo $item['district_id'] ?>" <?php if ($item['district_id'] == $row_join['company_district_id']) {
                                                                                                echo "selected";
                                                                                            } ?>><?php echo $item['district_name_th'] ?></option>
                                    <?php
                                    }

?>
                                </select>
                            <?php } ?>
                        </span>
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>อำเภอ</b>
                        <br><span id="show_ampoe2"><?php echo $postcode2['amphoe'] ?></span>
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>จังหวัด</b>
                        <br><span id="show_province2"><?php echo $postcode2['province'] ?></span>
                    </div>
                </div>

<div class="row mb-2">
                    <div class="col-lg-4 col-12 mb-2">
                        <b>เบอร์โทรติดต่อ</b>
                        <input type="text" class="form-control" id="company_phone" name="company_phone" value="<?php echo bigsara_decode($row_join['company_phone'], $secure_text); ?>">
                    </div>
                    <div class="col-lg-8 col-12 mb-2">
                        <b>อีเมล</b>
                        <input type="text" class="form-control" id="company_email" name="company_email" value="<?php echo bigsara_decode($row_join['company_email'], $secure_text); ?>">
                    </div>
                </div>

<label for="" class="mt-3"><b>3.ที่อยู่ในการออกใบเสร็จรับเงิน</b></label>
                <div class="row">
                    <div class="col-lg-3 col-12 mb-2">
                        
                        <input type="checkbox" id="selectcardaddress" name="selectaddress" onchange="selectCardAddress();">
                        <span>&nbsp;&nbsp;ใช้ที่อยู่เดียวกับผู้สมัคร</span>
                        
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        
                        <input type="checkbox" id="selectaddress" name="selectaddress" onchange="selectAddress();">
                        <span>&nbsp;&nbsp;ใช้ที่อยู่เดียวสถานประกอบการ</span>
                        
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-8 col-12 mb-2">
                        <b>ชื่อสำหรับออกใบเสร็จ/ใบกำกับภาษี</b>
                        <input type="text" class="form-control" id="invoice_name" name="invoice_name" value="<?php echo $row_payment['invoice_name']; ?>">
                    </div>
                    <div class="col-lg-4 col-12 mb-2">
                        <b>เลขประจำตัวผู้เสียภาษี</b>
                        <input type="text" class="form-control" id="invoice_tax" name="invoice_tax" onkeypress="return chkNumber(event)" maxlength="13" value="<?php echo $row_payment['invoice_taxnumber']; ?>">
                        <span class="text-danger" id="invoice_tax_ch" hidden> (กรุณากรอกข้อมูลให้ครบ 13 หลัก) </span>
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-12 col-12 mb-2">
                        <b>ที่อยู่</b>
                        <input type="text" class="form-control" id="invoice_address" name="invoice_address" placeholder="เลขที่ หมู่ ซอย ถนน" value="<?php echo $row_payment['invoice_address']; ?>">
                    </div>
                </div>

<div class="row mb-2">
                    <?php
                    $postcode3 = zipCode($connection, $row_payment['invoice_district']);
                    ?>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>รหัสไปรษณีย์</b>
                        <input type="text" class="form-control" id="zipcode2" name="zipcode2" onchange="selectZipCode2(this.value)" value="<?php echo ($postcode3['district'] != '') ? $postcode3['district'] : ''; ?>" maxlength="10" onkeypress="return chkNumber(event)">
                        <input type="hidden" id="invoice_district" name="invoice_district" value="<?php echo $row_payment['invoice_district'] ?>">

</div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>ตำบล</b>
                        <br><span id="show_district3">
                            <select id="invoice_district" name="invoice_district" class="form-control">
                                <?php
                                $postcode3 = zipCode($connection, $row_payment['invoice_district']);

$sql_distirct2 = "SELECT * FROM tbl_district  WHERE district_zipcode = '" . $postcode3['district'] . "'";
                                $rs_distirct2 = mysqli_query($connection, $sql_distirct2);
                                ?>

<?php
                                foreach ($rs_distirct2 as $key => $item) {
                                ?>
                                    <option value="<?php echo $item['district_id'] ?>" <?php if ($item['district_id'] == $row_payment['invoice_district']) {
                                                                                            echo "selected";
                                                                                        } ?>><?php echo $item['district_name_th'] ?></option>
                                <?php
                                }

?>
                            </select>
                        </span>
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>อำเภอ</b>
                        <br><span id="show_ampoe3"><?php echo $postcode3['amphoe'] ?></span>
                    </div>
                    <div class="col-lg-3 col-12 mb-2">
                        <b>จังหวัด</b>
                        <br><span id="show_province3"><?php echo $postcode3['province'] ?></span>
                    </div>
                </div>
                <div class="row mb-2">
                    <div class="col-lg-4 col-12 mb-2">
                        <b>เบอร์โทรติดต่อ</b>
                        <input type="text" class="form-control" id="invoice_phone" name="invoice_phone" value="<?php echo $row_payment['invoice_phone']; ?>">
                    </div>
                    <div class="col-lg-8 col-12 mb-2">
                        <b>อีเมล</b>
                        <input type="text" class="form-control" id="invoice_email" name="invoice_email" value="<?php echo $row_payment['invoice_email']; ?>">
                    </div>
                </div>

<div class="row mb-2 mt-3">
                    <div class="col-md-12"><b>4.เอกสารประกอบการสมัคร</b> <span class="text-danger"> ( แนบได้เฉพาะไฟล์นามสกุล .jpg , .jpeg , .png ) </span></div>
                </div>

<?php

$sql = "SELECT * FROM tbl_register_document WHERE member_type = '" . $register_type . "' ORDER BY list_order ASC";
                $rs = mysqli_query($connection, $sql);
                if ($rs) {
                    $i = 1;
                    foreach ($rs as $key => $document) {
                ?>
                        <div class="row mb-3">
                            <div class="col-md-2">
                                <b><?php echo $document['doc_name'] ?> <span class="text-danger">*</span></b>
                            </div>
                            <div class="col-6">
                                <input type="hidden" id="doc_file_<?= $i ?>" name="doc_file_<?= $i ?>" value="<?php echo $row_join['document_file' . $i] ?>">
                                <div class="image-upload_<?= $i ?>">
                                    <input type="file" id="document_file_<?= $i ?>" name="document_file[]" value="<?php echo $row_join['document_file' . $i] ?>" onchange="ImageReadURL(this,value,'<?= $i ?>');" multiple>
                                    <input type="hidden" id="document_location" name="document_location[]" value="<?= $i ?>">
                                </div>
                                <div class="col-md-10 col-9 show_upload_<?= $i ?> mt-1" hidden>
                                    <div class="row">
                                        <div class="col-md-5 ml-4"><span style="color: green;"><b>แนบรูปภาพแล้ว</b></span></div>
                                        <div class="col-md-1 col-1">
                                            <a href="javascript:void(0);" onclick="ViewImage('<?= $i ?>');"><i class="fa fa-search"></i></a>
                                        </div>
                                        <div class=" col-md-1 col-1">
                                            <a href="javascript:void(0);" onclick="RemoveImage('<?= $i ?>');"><i class="fa fa-close"></i></a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="modal fade" id="myModal_<?= $i ?>" tabindex="-1" role="dialog" aria-hidden="true">
                            <div class="modal-dialog modal-xxl modal-dialog-centered">
                                <div class="modal-content animated fadeIn">
                                    <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">
                                        <div class="row">
                                            <div class="col-lg-12 mb-2">
                                                <div class="form-group">
                                                    <img id="example_image_<?= $i ?>" src="" style="width:100%;">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="modal-footer">
                                        <button type="button" class="btn btn-danger" data-dismiss="modal"><i class="fa fa-times"></i>&nbsp;ปิด</button>
                                    </div>
                                </div>
                            </div>
                        </div>

<?php
                        $i++;
                    }
                }
                $row = mysqli_fetch_array($rs);
                ?>
                <input type="hidden" id="doc_count" value="<?php echo $i ?>">
                <!-- 
                <input type="hidden" name="sig_validate" id="sig_validate" value="<?php echo $row_join['member_signature'] ?>">
                <div class="show_sig" hidden>
                    <label for=""><b>ลายเซ็น</b></label>
                    <img src="upload/join/signature/<?php echo $row_join['member_signature'] ?>" alt="">
                    <a style="color: red;" onclick="SigPad(0)">แก้ไขลายเซ็น </a>
                </div>

<div class="row mb-2 mt-3">
                    <div class="col-md-12">
                        <button type="button" class="btn btn-block btn-success" id="save_data" onclick="check_add();">บันทึก</button>
                    </div>
                </div>
            </div>
        </div>
    </div>
</form>
<script>
    $(document).ready(function() {

var profile_image = $("#profile_img").val();
        readURL01(profile_image);

var doc_count = $("#doc_count").val();
        console.log(doc_count);
        for (let i = 1; i < doc_count; i++) {
            var doc_file = $("#doc_file_" + i).val();
            if (doc_file != '') {
                ImageReadURL(1, doc_file, i)
            }
        }
        $('.form-select').select2();
        Signature()
        SigPad($("#sig_validate").val())

});

function SigPad(sig) {

if (sig != '0') {
            $('.show_sig').attr('hidden', false);
            $('.sig_pad').attr('hidden', true);
        } else {
            $('.show_sig').attr('hidden', true);
            $('.sig_pad').attr('hidden', false);
        }
    }

function readURL01(input) {
        if (input == '') {
            $('.show_upload_image').attr('hidden', true);
            $('.custom-file').attr('hidden', false);

} else {
            if (input.files && input.files[0]) {
                var reader = new FileReader();
                reader.onload = function(e) {
                    $('#example_image').attr('src', e.target.result);
                }
                reader.readAsDataURL(input.files[0]);
                $('.show_upload_image').attr('hidden', false);
                $('.custom-file').attr('hidden', true);
            } else {
                //var profile_image = $("#profile_img").val();
                $('#example_image').attr('src', '../main/upload/join/' + input);
                $('.show_upload_image').attr('hidden', false);
                $('.custom-file').attr('hidden', true);
            }
        }

}

function ViewImage(position) {
        $('#myModal_' + position).modal('show');
    }

function ImageReadURL(input, value, show_position) {

if (input == 1 && value != '') {
            let path = "../main/upload/join/file/" + value
            console.log(path);
            console.log("SSR");
            $(".image-upload_" + show_position).attr('hidden', true);
            $(".show_upload_" + show_position).attr('hidden', false);
            $("#example_image_" + show_position).attr('src', path);

} else {
            let fty = ["jpg", "jpeg", "png"];
            let permiss = 0;
            let file_type = value.split('.');
            file_type = file_type[file_type.length - 1];
            if (jQuery.inArray(file_type, fty) !== -1) {
                let reader = new FileReader();
                reader.onload = function(e) {
                    $(".image-upload_" + show_position).attr('hidden', true);
                    $(".show_upload_" + show_position).attr('hidden', false);
                    $("#example_image_" + show_position).attr('src', e.target.result);
                }
                reader.readAsDataURL(input.files[0]);
            } else if (value == "") {
                $(show_position).attr('src', '');
                $(input).val("");
            } else {
                swal({
                    title: 'เกิดข้อผิดพลาด',
                    text: 'อัพโหลดได้เฉพาะไฟล์นามสกุล (.jpg .jpeg .png) เท่านั้น!',
                    type: 'warning',
                    showConfirmButton: false,
                    timer: 1500
                });
                $(input).val("");
                return false;
            }
        }
    }

function remove_image() {
        $('#example_image').attr('src', null);
        $('.show_upload_image').attr('hidden', true);
        $('.custom-file').attr('hidden', false);
        var inputElement = document.getElementById('profile_image');
        if (inputElement.files.length > 0) {
            // ลบไฟล์ที่ถูกเลือกอยู่
            inputElement.value = null;
        }
    }

function RemoveImage(position) {
        $('#example_image_' + position).attr('src', null);
        $('.show_upload_' + position).attr('hidden', true);
        $('.image-upload_' + position).attr('hidden', false);
        var inputElement = document.getElementById('document_file_' + position);
        if (inputElement.files.length > 0) {
            // ลบไฟล์ที่ถูกเลือกอยู่
            inputElement.value = null;
        }
    }

function ChectAccept() {

if ($('#accept1').is(':checked') && $('#accept2').is(':checked')) {
            $('#submit_button').attr('disabled', false);
            $('#save_data').attr('disabled', true);

// Signature()
            // SigPad($("#sig_validate").val())

} else {
            $('#submit_button').attr('disabled', true);
            $('#save_data').attr('disabled', false);

}

function check_add() {

var formData = new FormData($("#form_submit")[0]);

var sig_validate = $("#sig_validate").val()
        if (sig_validate == 1) {
            var canvas = document.getElementById('sign-pad');
            var img_data = canvas.toDataURL(); // Convert canvas content to base64 image data
            formData.append('signature', img_data);

}

const queryString = window.location.search;
        const urlParams = new URLSearchParams(queryString);
        const member_id = urlParams.get('id')
        const member_type = urlParams.get('type')
        const member_level = urlParams.get('level')

$.ajax({
            type: 'POST',
            url: 'ajax/join/update_worker.php',
            data: formData,
            processData: false,
            contentType: false,
            dataType: 'json',
            beforeSend: function() {
                swal({
                    title: "กำลังทำการบันทึก",
                    text: "กรุณารอสักครู่",
                    imageUrl: "ajax-loader.gif",
                    showConfirmButton: false,
                    allowOutsideClick: false
                });
            },
            error: function(data) {
                swal({
                    title: "เกิดข้อผิดพลาด",
                    text: "ไม่สามารถบันทึกรายการได้ กรุณาแจ้งทีมงาน",
                    type: "error",
                });
            },
            success: function(data) {
                if (data.status == 200) {
                    swal({
                        title: data.message,
                        type: "success"
                    }, function() {
                        swal.close();

location.href = "member_detail?id=" + member_id + "&type=" + member_type + "&level=" + member_level + ""

});
                } else if (data.status == 500) {
                    swal({
                        title: "คำเตือน",
                        text: data.message,
                        type: "error"
                    });
                }
            }
        })

}

function districtChange() {
        var checkboxaddress = document.getElementById("checkboxaddress");
        if (checkboxaddress.checked == true) {
            var select = document.getElementById("card_district_id");
            var selectedOption = select.options[select.selectedIndex].text;
            $('#show_district2').html(selectedOption);
        }
    }

//// ใช่ทึอยู่เดียวกับบัตร ข้อ 2
    function selectCheckbox() {
        var checkboxaddress = document.getElementById("checkboxaddress");
        var postcode = $('#postcode').val();
        if (checkboxaddress.checked == true) {
            $('#zipcode').attr('disabled', true);

$('#zipcode').val(postcode);
            $('#show_ampoe2').html($('#show_ampoe1').html());
            $('#show_province2').html($('#show_province1').html());
            $('#company_address').val($('#card_address').val());
            $('#comp_phone').val($('#phone').val());
            $('#comp_fax').val($('#fax').val());
            $('#comp_email').val($('#email').val());

var select = document.getElementById("card_district_id");
            var selectedOption = select.options[select.selectedIndex].text;
            $('#show_district2').html(selectedOption);

} else {
            $('#zipcode').attr('disabled', false);
            $('#zipcode').val(null);
            $('#company_address').val(null);
            $('#show_ampoe2').html("กรุณากรอกรหัส ปณ.");
            $('#show_province2').html("กรุณากรอกรหัส ปณ.");
            $('#show_district2').html("กรุณากรอกรหัส ปณ.");
        }
    }

function selectCardAddress() {
        var selectcardaddress = document.getElementById("selectcardaddress");
        var postcode = $('#postcode').val();
        if (selectcardaddress.checked == true) {
            $('#zipcode2').attr('disabled', true);

$('#zipcode2').val(postcode);
            $('#show_ampoe3').html($('#show_ampoe1').html());
            $('#show_province3').html($('#show_province1').html());
            $('#invoice_address').val($('#card_address').val());
            $('#invoice_phone').val($('#phone').val());
            $('#invoice_email').val($('#email').val());
            $('#invoice_name').val($('#member_name').val());
            $('#invoice_tax').val($('#citizen_no').val());
            $('#invoice_district').val($('#card_district_id').val());
            $('#selectaddress').prop("checked", false);
            var select = document.getElementById("card_district_id");
            var selectedOption = select.options[select.selectedIndex].text;
            $('#show_district3').html(selectedOption);

} else {
            $('#zipcode2').attr('disabled', false);
            $('#zipcode2').val(null);
            $('#invoice_name').val(null);
            $('#invoice_address').val(null);
            $('#invoice_tax').val(null);
            $('#invoice_phone').val(null);
            $('#invoice_email').val(null);
            $('#show_ampoe3').html("กรุณากรอกรหัส ปณ.");
            $('#show_province3').html("กรุณากรอกรหัส ปณ.");
            $('#show_district3').html("กรุณากรอกรหัส ปณ.");
            $('#invoice_district').val(null);
        }
    }

function selectAddress() {
        var selectaddress = document.getElementById("selectaddress");
        var zipcode = $('#zipcode').val();
        if (selectaddress.checked == true) {
            $('#zipcode2').attr('disabled', true);

$('#zipcode2').val(zipcode);
            $('#show_ampoe3').html($('#show_ampoe2').html());
            $('#show_province3').html($('#show_province2').html());
            $('#invoice_name').val($('#company_name').val());
            $('#invoice_tax').val($('#company_tax_no').val());
            $('#invoice_address').val($('#company_address').val());
            $('#invoice_phone').val($('#company_phone').val());
            $('#invoice_email').val($('#company_email').val());

$('#selectcardaddress').prop("checked", false);
            if (zipcode != null) {
                var select = document.getElementById("company_district_id");
                $('#invoice_district').val($('#company_district_id').val());
                if (select == null) {
                    var select = document.getElementById("card_district_id");
                    $('#invoice_district').val($('#card_district_id').val());
                }
            }
            var selectedOption = select.options[select.selectedIndex].text;
            $('#show_district3').html(selectedOption);

function change_address() {
        var card_address = $('#card_address').val();
        var checkboxaddress = document.getElementById("checkboxaddress");
        if (checkboxaddress.checked == true) {
            $('#company_address').val($('#card_address').val());
        }
    }

function selectPostCode() {
        var postcode = $('#postcode').val();
        var checkboxaddress = document.getElementById("checkboxaddress");
        $.ajax({
            type: "GET",
            data: {
                postcode: postcode,
                nameform: 'card_district_id',
                namefn: "card"
            },
            dataType: 'json',
            url: "ajax/join/getpostcode.php",
            success: function(response) {
                if (response.status == 200) {
                    $('#show_district1').html(response.data.district);
                    $('#show_ampoe1').html(response.data.amphoe);
                    $('#show_province1').html(response.data.province);
                    if (checkboxaddress.checked == true) {
                        $('#zipcode').attr('disabled', true);

$('#zipcode').val(postcode);
                        $('#show_ampoe2').html($('#show_ampoe1').html());
                        $('#show_province2').html($('#show_province1').html());
                        // $('#show_district2').html($('#show_district1').html());