<?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 //