$end_data = $_GET['end_data'];
$search_type = $_GET['search_type'];
$year = $_GET['year'];
include '../helper/db_connect.php';
include '../helper/helper.php';
connect_database();
// if ($search_type == 1) {
// $query = "SELECT REGISTER_OWNER_ID FROM register "
// . "LEFT JOIN personname ON register.REGISTER_OWNER_ID = personname.PERSONNAME_OWNER_ID "
// . "WHERE (REGISTER_NUMBER BETWEEN $start_data AND $end_data) AND REGISTER_FROM_DATE LIKE '%$year%' ORDER BY PERSONNAME_NAME";
// } else {
// $query = "SELECT register.REGISTER_OWNER_ID FROM register "
// . "LEFT JOIN personname ON register.REGISTER_OWNER_ID = personname.PERSONNAME_OWNER_ID "
// . "WHERE (personname.PERSONNAME_NAME BETWEEN '$start_data' AND '$end_data') AND register.REGISTER_FROM_DATE LIKE '%$year%' ORDER BY PERSONNAME_NAME";
// }
$query = search_between_data($start_data, $end_data, $search_type);
?>
<div class="row">
<div class="col-xs-1">
ID
</div>
<div class="col-xs-3">
ชื่อ-นามสกุล
</div>
<div class="col-xs-2">
ชื่อจีน
</div>
<div class="col-xs-1">
เพศ
</div>
<div class="col-xs-2">
<div class= "bs-component" name="print" style="margin-left: 20px;">
<?php
// $id = $_GET['id'];
$start_data = $_GET['start_data'];
$end_data = $_GET['end_data'];
$search_type = $_GET['search_type'];
$numprint = $_GET['num_print'];
include '../helper/db_connect.php';
include '../helper/helper.php';
connect_database();
// if($search_type == 1){
// $query = "SELECT ID FROM person WHERE (REGISTER_NUMBER BETWEEN $start_data AND $end_data) AND REGISTER_THRU_DATE = ''";
// }else{
// $query = "SELECT PERSONNAME_OWNER_ID FROM personname WHERE PERSONNAME_NAME BETWEEN '$start_data' AND '$end_data'";
// }
$persons = mysql_query(search_between_data($start_data, $end_data, $search_type));
$count = 0;
while ($person = mysql_fetch_row($persons)) {
for ($i = 0; $i < $numprint; $i++) {
$id = $person[0];
$person_name = get_person_name_string($id) . ' ' . get_person_surname_string($id);
$homeAddrs = get_person_all_address($id, 1);
$checkHome = mysql_fetch_assoc(get_person_all_address($id, 1));
if ($checkHome) {
$homeAddr = mysql_fetch_assoc($homeAddrs);
} else {
$homeAddr = give_addr();
}
if ($count % 3 == 0) {
?>
<div class="row">
<!--<a class="btn btn-material-indigo" role="button" style="margin-top: -10px" onClick="javascript:window.open('../../print/all_report.php', '', 'nenuber=no,toorlbar=no,location=no,scrollbars=no, status=no,resizable=no,width=800,height=650,top=0,left=150 ')">พิมพ์ทั้งหมด</a>-->
</div>
<div class="col-xs-2">
<a class="btn btn-material-red" role="button" style="margin-top: -10px" onClick="javascript:window.location.assign('print.php')">ย้อนกลับ</a>
</div>
</div>
</form>
</div>
<?php
if (isset($_GET['search'])) {
$start_data = $_GET['start_data'];
$end_data = $_GET['end_data'];
$search_type = $_GET['option'];
// $numprint = $_GET['numprint'];
// $year = $_GET['year'];
$check = mysql_fetch_assoc(mysql_query(search_between_data($start_data, $end_data, $search_type)));
if (!$check) {
echo "<script type='text/javascript'>";
echo "alert('ไม่พบข้อมูลที่ท่านค้นหา');";
echo "</script>";
} else {
?>
<script type='text/javascript'>
javascript:window.open('../../print/report.php?start_data=<?php
echo $start_data;
?>
&end_data=<?php
echo $end_data;
?>
&search_type=<?php
echo $search_type;
