<?php
function __autoload($class_name)
{
include '../class/class.' . $class_name . '.php';
}
set_time_limit(0);
include "../config/config.php";
$ystr = $_GET['ystr'];
$yend = $_GET['yend'];
$dbchr = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
//new object
$dbchr->Query("\nSELECT \nAMPNAME,\nif(ROUND((sum(T_SUM)/sum(T_TARGET))*100,2) IS NULL,'0.00',ROUND((sum(T_SUM)/sum(T_TARGET))*100,2)) as RS,\nLEFT(T_DATE,4)+543 as TY\nFROM chart_ckd_ht_age_l65_stage3b\nWHERE T_DATE BETWEEN'" . $ystr . "' AND'" . $yend . "' AND AMPCODE<>'' \nGROUP BY AMPCODE ORDER BY ROUND((sum(T_SUM)/sum(T_TARGET))*100,2) DESC;\n");
while ($dbarr2 = $dbchr->Fetch_array()) {
$amp = $dbarr2['AMPNAME'];
$cc = $dbarr2['RS'];
$myurl2[] = "['{$amp}',{$cc}]";
}
// print_r($myurl);
$te2 = implode(",", $myurl2);
?>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"> <script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['อำเภอ','ร้อยละ'],
if ($m == 00) {
$b1 = $fyear - 543 - 3 . '-12-01';
$b2 = $fyear - 543 - 3 . '-12-31';
}
}
}
//
$dbrpt = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
//new object
?>
<div class="panel panel-info">
<div class="panel-heading">
<?php
//select name report
$dbrpt->Query("SELECT * FROM z42_sys_report WHERE id='{$id}' ORDER BY cat_id");
while ($arrrpt = $dbrpt->Fetch_array()) {
?>
<h4><?php
echo $arrrpt['report_name'];
?>
</h4>
<?php
}
if ($m == '') {
?>
<a href="javascript:history.go(-1)" class="btn btn-default btn-sm " role="button">Back</a>
<a href="../exportxls/child_develop_cid_export_excel.php?id=<?php
echo $id;
?>
&fyear=<?php
echo $arr_rs['M08'];
?>
</td>
<td align="center">
<?php
echo $arr_rs['M09'];
?>
</td>
</tr>
<div class="list-group">
<?php
$dbrpt_e = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
$dbrpt_e->Query("\n SELECT \n amp.AMP_NAME AS AMPNAME,\n left(areacode,4) as AMPCODE,\n sum(target) as Be,\n sum(result) as Ae,\n ROUND((sum(result)/sum(target))*100,2) as Pe,\n SUM(result10) as M10e,SUM(result11)AS M11e,SUM(result12)AS M12e,\n SUM(result09) as M09e,SUM(result08)AS M08e,SUM(result07)AS M07e,\n SUM(result06) as M06e,SUM(result05)AS M05e,SUM(result04)AS M04e,\n SUM(result03) as M03e,SUM(result02)AS M02e,SUM(result01)AS M01e\n FROM z42_anc12w_s_error \n LEFT OUTER JOIN z42_amp AS amp ON LEFT(z42_anc12w_s_error.areacode,4)=amp.AMP_CODE\n WHERE b_year BETWEEN '{$o_year}' AND '{$b_year}' AND date_com BETWEEN '{$ystr}' AND '{$yend}' \n AND LEFT(areacode,4)='{$ampcode}' \n\t");
$arr_e = $dbrpt_e->Fetch_array();
?>
<tr class="bg-danger">
<td align="center">
<a href="javascript:popup('#.php?ampcode=<?php
echo $arr_e['AMPCODE'];
?>
&id=<?php
echo $id;
?>
&b_year=<?php
echo $b_year;
?>
&ystr=<?php
echo $ystr;
"><?php
echo $arr_g['cat_name'];
?>
</a>
</h4>
</div>
<div id="<?php
echo $arr_g['accord'];
?>
" class="panel-collapse collapse">
<div class="panel-body" >
<?php
$dbreport = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
$dbreport->Query("SELECT * FROM z42_sys_report WHERE cat_id='{$catid}' ORDER BY cat_id");
while ($arrreport = $dbreport->Fetch_array()) {
?>
<li>
<a href="<?php
echo $arrreport['source_file'];
echo $arrreport['para_meter'];
?>
id=<?php
echo $arrreport['id'];
?>
&str_date=<?php
echo $str_date;
?>
&end_date=<?php
echo $end_date;
?>
$db->Query("SELECT * FROM z42_sys_member WHERE id='{$uid}'");
$arr = $db->Fetch_array();
$id = $arr[0];
$user_ = $arr[5];
if ($uid == $id && $user == $user_) {
$db->Query("UPDATE z42_sys_member SET password=MD5('" . $pass . "') WHERE id='" . $uid . "'");
echo "เปลี่ยนรหัสเรียบร้อย";
} else {
echo "ขออภัยไม่มี User ในระบบ";
}
$db->Close_conn();
} else {
//Update user
$db = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
$db->Query("SELECT * FROM z42_sys_member WHERE id='{$uid}'");
$arr = $db->Fetch_array();
$id = $arr[0];
$user_ = $arr[5];
if ($uid == $id && $ouser == $user_) {
$db->Query("UPDATE z42_sys_member SET username='******' WHERE id='" . $uid . "'");
echo "เปลี่ยน user เรียบร้อย";
} else {
echo "ขออภัยไม่มี User ในระบบ";
}
$db->Close_conn();
}
?>
</body>
</html>
<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);
$dbrpt->Query("SELECT * FROM z42_sys_report WHERE id='" . $id . "' ORDER BY source_table");
$arrrpt = $dbrpt->Fetch_array();
?>
<strong><?php
echo $arrrpt['report_name'];
?>
</strong>
<br>
<div id="SiXhEaD_Excel" align=center x:publishsource="Excel">
<table x:str border=1 cellpadding=0 width=100% style="border-collapse:collapse">
<tr>
<td width="94" height="30" align="center" valign="middle" ><strong>ลำดับ</strong></td>
<td width="94" height="30" align="center" valign="middle" ><strong>รหัสสถานพยาบาล</strong></td>
<td width="200" align="center" valign="middle" ><strong>รหัสสถานพยาบาล</strong></td>
<td width="181" align="center" valign="middle" ><strong>HPID</strong></td>
<td width="181" align="center" valign="middle" ><strong>CID</strong></td>
<td width="181" align="center" valign="middle" ><strong>คำนำหน้า</strong></td>
')">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<!---->
<!---->
<?php
$dbrg = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
$dbrg->Query("select sg.cat_name as ctname,sg.cat_id as ctid,COUNT(sr.cat_id) as cc\r\n\t\t\t\t\t\t\t\t from z42_sys_report_group as sg \r\n\t\t\t\t\t\t\t\t\tLEFT OUTER JOIN z42_sys_report as sr on sg.cat_id=sr.cat_id \r\n\t\t\t\t\t\t\t\t\twhere sr.cat_id='g5' and sr.active='1' order by sr.id");
$rgname = $dbrg->Fetch_array();
$dbrg->Close_Conn();
?>
<div class="col-lg-3 col-md-6">
<div class="panel panel-success">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-area-chart fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div><?php
echo $rgname['ctname'];
?>
</div>
<div class="huge"><?php
$sdate = date("Y-m-d H:i:s");
//
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";
<!-- Morris Charts CSS -->
<link href="../bower_components/morrisjs/morris.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href="../bower_components/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
</head>
<body>
<?php
$dt = date("Y-m-d H:i:s");
$dbc = new Database(DB_HOST_TK, DB_USER_TK, DB_PASS_TK, DB_NAME_TK);
//*** Select วันที่ในตาราง Counter ว่าปัจจุบันเก็บของวันที่เท่าไหร่ ***//
//*** ถ้าเป็นของเมื่อวานให้ทำการ Update Counter ไปยังตาราง daily และลบข้อมูล เพื่อเก็บของวันปัจจุบัน ***//
$dbc->Query(" SELECT DATE FROM counter LIMIT 0,1");
$objResult = $dbc->Fetch_array();
if ($objResult["DATE"] != date("Y-m-d")) {
//*** บันทึกข้อมูลของเมื่อวานไปยังตาราง daily ***//
$dbc->Query(" INSERT INTO daily (DATE,NUM) SELECT '" . date('Y-m-d', strtotime("-1 day")) . "',COUNT(*) AS intYesterday FROM counter WHERE 1 AND DATE = '" . date('Y-m-d', strtotime("-1 day")) . "'");
//*** ลบข้อมูลของเมื่อวานในตาราง counter ***//
$dbc->Query(" DELETE FROM counter WHERE DATE != '" . date("Y-m-d") . "' ");
}
//*** Insert Counter ปัจจุบัน ***//
#$dbc->Query(" INSERT INTO counter (DATE,IP) VALUES ('".date("Y-m-d")."','".$_SERVER["REMOTE_ADDR"]."') ");
$dbc->Query(" INSERT INTO counter (DATE,IP) VALUES ('" . date("Y-m-d") . "','" . $dt . "') ");
//******************** Get Counter ************************//
// Today //
$dbc->Query(" SELECT COUNT(DATE) AS CounterToday FROM counter WHERE DATE = '" . date("Y-m-d") . "' ");
$objResult = $dbc->Fetch_array();
$strToday = $objResult["CounterToday"];
// Yesterday //
