} elseif ($person['STATUS'] == 2) {
$status = "เสียชีวิตแล้ว";
} else {
$status = "";
}
$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $count++);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $person["TITLE_NAME"]);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $person["PERSONNAME_NAME"]);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $person["PERSONNAME_SURNAME"]);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, $person["GENERATION_TYPE"]);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $i, $person["GENERATION_NAME"]);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $i, $person["CHINANAME_NAME"]);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $i, $person["CHINANAME_PINYIN"]);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $i, $person["CHINANAME_TH"]);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $i, $person["GENDER_NAME"]);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $i, display_birthday($person["BIRTHDAY"]));
$objPHPExcel->getActiveSheet()->setCellValue('L' . $i, $status);
//------ที่อยู่-------//
$addrs = mysql_query("SELECT * FROM address " . "LEFT JOIN addresslist ON address.ID = addresslist.ADDRESSLIST_ADDRESS_ID " . "WHERE addresslist.ADDRESSLIST_OWNER_ID = {$id} AND addresslist.ADDRESSLIST_TYPE_ID = 1 AND addresslist.ADDRESSLIST_THRU_DATE='' " . "ORDER BY addresslist.ADDRESSLIST_FROM_DATE LIMIT 1");
$addr = mysql_fetch_assoc($addrs);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $i, $addr["ADDRESS_NUM"]);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $i, $addr["ADDRESS_MOO"]);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $i, $addr["ADDRESS_VILLAGE"]);
$objPHPExcel->getActiveSheet()->setCellValue('P' . $i, $addr["ADDRESS_ALLEY"]);
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $i, $addr["ADDRESS_ROAD"]);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $i, get_district_string($addr["ADDRESS_DISTRICT_ID"]));
$objPHPExcel->getActiveSheet()->setCellValue('S' . $i, get_amphur_string($addr["ADDRESS_AMPHUR_ID"]));
$objPHPExcel->getActiveSheet()->setCellValue('T' . $i, get_province_string($addr["ADDRESS_PROVINCE_ID"]));
$objPHPExcel->getActiveSheet()->setCellValue('U' . $i, $addr["ADDRESS_ZIPCODE"]);
//----เบอร์โทรศัพท์----//
$tels = mysql_query("SELECT * FROM contact WHERE CONTACT_OWNER_ID = {$id} AND CONTACT_TYPE_ID = 1 AND CONTACT_THRU_DATE='' ORDER BY CONTACT_FROM_DATE LIMIT 1");
?>
</div>
<div class="col-xs-1">
<?php
if ($person["GENDER_ID"] == 1) {
echo "ช";
} else {
if ($person["GENDER_ID"] == 2) {
echo "ญ";
}
}
?>
</div>
<div class="col-xs-2">
<?php
echo display_birthday($person['BIRTHDAY']);
?>
</div>
<div class="col-xs-1">
<?php
echo cal_age($person['BIRTHDAY']);
?>
</div>
<div class="col-xs-2">
<?php
if ($person["MARITALSTATUS_ID"] == 1) {
echo "โสด";
} else {
if ($person["MARITALSTATUS_ID"] == 2) {
echo "แต่งานแล้ว";
} else {
