invisio v2.0

<?php

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

require('../fpdf/alphapdf.php');
include('../qrcodegenerate/qrlib.php');

$member_id = mysqli_real_escape_string($connection, $_GET['id']);

$codeContents = "https://efa-member.com/member/member_card?id=$member_id";
$tempDir = "temp_qr/";
$fileName = 'qr_efa.png';
$pngAbsoluteFilePath = $tempDir . $fileName;
if (file_exists($tempDir.$fileName)) {
    unlink($tempDir.$fileName);
}

// // generating
if (!file_exists($pngAbsoluteFilePath)) {
    QRcode::png($codeContents, $pngAbsoluteFilePath, QR_ECLEVEL_L, 15, 0);
}

$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";
        break;
    case '2':
        $table = "tbl_member_detail_company";
        break;
    case '3':
        $table = "tbl_member_detail_agency";
        break;
    case '4':
        $table = "tbl_member_detail_worker";
        break;
}

$register_type = "";
switch ($rowMember['register_type']) {
    case '1':
        // $register_type = "นายจ้าง";
        $register_type = "01";
        break;
    case '2':
        // $register_type = "บนจ.";
        $register_type = "02";
        break;
    case '3':
        // $register_type = "Agency.";
        $register_type = "03";
        break;
    case '4':
        // $register_type = "แรงงาน";
        $register_type = "04";
        break;
}

$sql_detail = "SELECT a.*, b.*  FROM tbl_member_detail a 
LEFT JOIN tbl_member_position b ON b.position_id = a.position
WHERE `member_id` = '$member_id'";
$res_detail = mysqli_query($connection, $sql_detail);
$row_detail = mysqli_fetch_assoc($res_detail);

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

$sqlPayment = "SELECT * FROM `tbl_member_payment` WHERE `member_id` = '$member_id'";
$rsPayment = mysqli_query($connection, $sqlPayment);
$rowPayment = mysqli_fetch_array($rsPayment);

if ($rowPayment['member_level'] == 'g9k1s') {
    $member_level = 'สมทบ - ทั่วไป';
} elseif ($rowPayment['member_level'] == 'kki22') {
    $member_level = 'วิสามัญ';
} elseif ($rowPayment['member_level'] == 'x9fkq') {
    $member_level = 'สามัญ.';
}

$sql_cer = "SELECT a.effective_date,b.* FROM tbl_certification_lot a 
LEFT JOIN tbl_certification_lot_member b ON b.certification_lot_id = a.certification_lot_id
WHERE b.member_id = '$member_id'";
$res_cer = mysqli_query($connection, $sql_cer);
$row_cer = mysqli_fetch_assoc($res_cer);

$pdf = new FPDF('L', 'mm', array(86, 55));

// $pdf = new FPDF();
$pdf->AliasNbPages();

$pdf->SetAutoPageBreak(false);
$pdf->AddFont('THSarabunNew', '', 'THSarabunNew.php');
$pdf->AddFont('THSarabunNew Bold', '', 'THSarabunNew Bold.php');
$pdf->AddFont('THSarabunNew BoldItalic', '', 'THSarabunNew BoldItalic.php');

$pdf->AddPage();
$pdf->SetFont('THSarabunNew Bold', '', 8);
$pdf->Image($rowPayment['member_level'] . '.png', 0, 0, 86, 55, 'PNG'); //LOGO

////ข้อมูลในบัตร/////
$pdf->SetFont('THSarabunNew Bold', '', 10);
$profile_image = '../main/upload/join/' . $row_detail['profile_image']; //รูป
$pdf->Image($profile_image, 7, 17, 20.25, 25.5);

$pdf->SetFont('THSarabunNew Bold', '', 14);
$pdf->SetXY(30, 16);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', 'สมาชิก : ' . $member_level), 0, 'C', 0);

$pdf->SetFont('THSarabunNew Bold', '', 16);
$pdf->SetXY(30, 22);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', $title_th . ' ' . $row_detail['member_name']), 0, 'C', 0);

$pdf->SetFont('THSarabunNew Bold', '', 10);
$pdf->SetXY(30, 28);
$pdf->Cell(0, 5, iconv('UTF-8', 'cp874',  $title_en . ' ' . $row_detail['member_name_en']), 0, 0, 'C');

$pdf->SetXY(30, 32);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', 'ตำแหน่ง : ' . $row_detail['position_name']), 0, 'C', 0);

$pdf->SetXY(30, 36);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', 'Position : ' . $row_detail['position_en']), 0, 'C', 0);

// $pdf->SetFont('THSarabunNew Bold', '', 5);
// $pdf->SetXY(3.5, 43);
// $pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', 'ลายมือชื่อ..........................................'), 0, 'L', 0);

// วันเกิด
// $pdf->SetXY(30, 26);
// $pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', 'วันเกิด : '), 0, 'L', 0);
// $pdf->SetXY(47, 26);
// $pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', date('d/m/Y', strtotime($row_detail['birth_date']))), 0, 'L', 0);

// ที่อยู่
// $card_district_id = $row_detail['card_district_id'];
// $sqlAddressCard = "SELECT `tbl_district`.`district_name_th` , `tbl_amphoe`.`amphoe_name_th` , `tbl_province`.`province_name_th` , `tbl_district`.`district_zipcode` FROM `tbl_district` 
// JOIN `tbl_amphoe` ON `tbl_amphoe`.`amphoe_id` = `tbl_district`.`ref_amphoe`
// JOIN `tbl_province` ON `tbl_province`.`province_id` = `tbl_amphoe`.`ref_province`
// WHERE `tbl_district`.`district_id` = '$card_district_id'";
// $rsAddressCard = mysqli_query($connection, $sqlAddressCard);
// $rowAddressCard = mysqli_fetch_array($rsAddressCard);
// $full_address = $row_detail['card_address'] . " ตำบล" . $rowAddressCard['district_name_th'] . " อำเภอ" . $rowAddressCard['amphoe_name_th'] . " จังหวัด" . $rowAddressCard['province_name_th'] . " " . $rowAddressCard['district_zipcode'];

// $pdf->SetXY(30, 30);
// $pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', 'ที่อยู่ : '), 0, 'L', 0);
// $pdf->SetXY(47, 31);
// $pdf->MultiCell(0, 3, iconv('UTF-8', 'cp874', $full_address), 0, 'L', 0);

$pdf->SetFont('THSarabunNew Bold', '', 6);
// วันที่ออกบัตร
$pdf->SetXY(18.2, 47);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', dateThai($rowMember['last_cer_date'])), 0, 'L', 0);
$pdf->SetXY(18.2, 49.2);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', dateEng($rowMember['last_cer_date'])), 0, 'L', 0);

$pdf->SetFont('THSarabunNew Bold', '', 6);
$pdf->SetXY(15.5, 42);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', $rowMember['member_code']), 0, 'L', 0);

$pdf->SetXY(0, 40.5);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', '(' . $register_type . ')'), 0, 'L', 0);

$pdf->SetFont('THSarabunNew Bold', '', 6);
// วันหมดอายุ
$pdf->SetXY(47, 47);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', dateThai(date('Y-m-d', strtotime('+1 year -1 day', strtotime($rowMember['last_cer_date']))))), 0, 'L', 0);
$pdf->SetXY(47, 49.2);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', dateEng(date('Y-m-d', strtotime('+1 year -1 day', strtotime($rowMember['last_cer_date']))))), 0, 'L', 0);

$pdf->AddPage();

$pdf->SetMargins(0, 0, 5);
$pdf->SetAutoPageBreak(false);

$pdf->Image('back.png', 0, 0, 85, 55, 'PNG'); //LOGO
$pdf->Image('temp_qr/qr_efa.png', 59.1, 13, 20, 20, 'PNG');

$pdf->SetXY(30, 7.5);
$pdf->MultiCell(0, 5, iconv('UTF-8', 'cp874', $rowMember['member_code']), 0, 'R', 0);

$pdf->Output();