}
set_time_limit(0);
include "../config/config.php";
include "../function/function.php";
//require("../gobal/gobal_var.php");
$age = $_GET['age'];
$id = $_GET['id'];
$hospcode = $_GET['hospcode'];
$vhid = $_GET['vhid'];
$strExcelFileName = "60up_disab_indiv_export_excel.xls";
header("Content-Type: application/x-msexcel; name=\"{$strExcelFileName}\"");
header("Content-Disposition: inline; filename=\"{$strExcelFileName}\"");
header("Pragma:no-cache");
$db = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
$db->Query("select * from z42_disab_t where HOSPCODE={$hospcode} and VHID={$vhid} and age>=60 ORDER BY HOSPCODE,CID");
$num = $db->Numrow();
?>
<html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x="urn:schemas-microsoft-com:office:excel"xmlns="http://www.w3.org/TR/REC-html40">
<!doctype html>
<html>
<head>
<meta charset="utf-8">
</head>
<body>
<?php
//select name report
$i = 1;
$dbrpt = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
//
if ($user == '@admin') {
$_SESSION['login_admin'] = $user;
?>
<script language="javascript">
window.location.href = "backend/index-admin.php"
</script>
<?php
} else {
//
if (isset($user) and isset($pass)) {
$index = "index.php";
$dbsms = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
$dbsms->Query("select * from z42_sys_member where username='******' AND password='******' AND status='yes'");
$dbarr = $dbsms->Fetch_array();
$num_rows = $dbsms->Numrow();
$row = $dbsms->Fetch_row();
//$user_acc=$dbarr['ACCESS_BOX'];
$user_id = $dbarr['id'];
//$ubid=$dbarr['BOX_ID'];
if ($num_rows == 1) {
//insert log
$dbsms->Query("insert into z42_log_login(user,date_time,date_login) \t\t value('{$user}','{$sdate}','{$sdate}')");
//
$dbsms->Query("update z42_sys_member set lastlogin='******' where id='" . $user_id . "'");
//user status
$_SESSION['login_true'] = $user_id;
?>
<script langquage='javascript'>
window.location="index.php";
</script>
