invisio v2.0

<?php
header("X-Robots-Tag: noindex, nofollow", true);
// include('../../config/main_function.php');
// $secure = "Hd!6#2oye31AatrE23!aZ";
// include("../qrcodegenerate/qrlib.php");
// $connection = connectDB($secure);

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

require('fpdf/alphapdf.php');
require('fpdf/fpdf_merge.php');
require('fpdi2/src/autoload.php');

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

$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'];

$sqlMember = "SELECT * FROM `tbl_member` WHERE `member_id` = '$member_id'";
$rsMember = mysqli_query($connection, $sqlMember);
$rowMember = mysqli_fetch_array($rsMember);

switch ($rowMember['register_type']) {
    case '1':
        $table = "tbl_member_detail_employer";
        $formPrint = "applicationEmpolyer_all.php";
        // $formPrint = "applicationWorker.php";
        break;
    case '2':
        $table = "tbl_member_detail_company";
        $formPrint = "applicationCompany_all.php";
        break;
    case '3':
        $table = "tbl_member_detail_agency";
        $formPrint = "applicationAgency_all.php";
        break;
    case '4':
        $table = "tbl_member_detail_worker";
        $formPrint = "applicationWorker_all.php";
        break;
}

$sql = "SELECT * FROM tbl_member_detail WHERE `member_id` = '$member_id'";
$rs = mysqli_query($connection, $sql);
$row = mysqli_fetch_array($rs);

function monthTH($monthNo)
{
    switch ($monthNo) {
        case '01':
            $month = "มกราคม";
            break;
        case '02':
            $month = "กุมภาพันธ์";
            break;
        case '03':
            $month = "มีนาคม";
            break;
        case '04':
            $month = "เมษายน";
            break;
        case '05':
            $month = "พฤษภาคม";
            break;
        case '06':
            $month = "มิถุนายน";
            break;
        case '07':
            $month = "กรกฎาคม";
            break;
        case '08':
            $month = "สิงหาคม";
            break;
        case '09':
            $month = "กันยายน";
            break;
        case '10':
            $month = "ตุลาคม";
            break;
        case '11':
            $month = "พฤศจิกายน";
            break;
        case '12':
            $month = "ธันวาคม";
            break;
        default:
            $month = "";
            break;
    }
    return $month;
}

function getAge($birthday)
{
    $then = strtotime($birthday);
    return (floor((time() - $then) / 31556926));
}

include $formPrint;

// $document_import = $row['document_import'];
// if (!empty($document_import)) {
//     $merge = new FPDF_Merge();
//     $pdf->AddPage();
//     $merge->add("../upload/join/file/" . $document_import);
//     $merge->output();
// }