$ex = explode('-', $begin);
$y = $ex[2] - 543;
$m = $ex[1];
$d = $ex[0];
return $y . '-' . $m . '-' . $d;
} else {
return '';
}
}
public function check_query($str)
{
return mysql_query($str) or die("Can 't connect MYSQL SERVER!!");
}
}
//http://127.0.0.1/report_pdf/appendix_report/query_case3.php?begin=03-11-2542&end=07-11-2557
$esn = new query3();
$begin = trim($_GET['begin']);
$end = trim($_GET['end']);
$b_conv = $esn->date_eng_format($begin);
$e_conv = $esn->date_eng_format($end);
$b = $esn->date_eng_format($begin);
$e = $esn->date_eng_format($end);
##------------------ giveinformation ---------------
$tb1_ = " `06_giveinformation`";
$i = 1;
$arr_give = array('- What \'s your disease?', '- What \'s treatment?', '- How to manage the side effect?', '- Bring medication to each visit?', '- How to correct be havior?', '- Ohter');
$givearr = array();
$result_give_yes = array();
$result_give_no = array();
while ($i <= 5) {
$g = '`GiveInformation' . $i . '`';
{
return mysql_query($str) or die("Can 't connect MYSQL SERVER!!");
}
public function query_tb($hn, $fname, $wr)
{
/*
SELECT HN, count( `GiveInformation1` )
FROM `06_giveinformation`
WHERE `HN` = 'AA0096'
GROUP BY `GiveInformation1`
HAVING `GiveInformation1` = 'Y'
*/
return $this->str_ = " SELECT {$fname}\n FROM `06_giveinformation`\n WHERE `HN` = '{$hn}' \n AND `{$fname}` = 'Y' " . $wr;
}
}
$esn = new query3();
$begin = trim($_REQUEST['begin']);
$end = trim($_REQUEST['end']);
$b_conv = $esn->date_eng_format($begin);
$e_conv = $esn->date_eng_format($end);
#$hn=trim($_REQUEST["hn"]); //ของเดิม
$hn = trim($_REQUEST["HN"]);
//echo "<br>";
$fname = "GiveInformation1";
$result_give_yes[] = array();
if (strlen($hn) == 6) {
$z = 1;
while ($z <= 5) {
$fname = "GiveInformation" . $z;
//AND `MonitoringDate` BETWEEN ' $b_conv' AND '$e_conv' ";
$wr = " AND `MonitoringDate` BETWEEN ' {$b_conv}' AND '{$e_conv}' ";
SELECT DISTINCT (
HN
)
FROM `06_giveinformation`
LIMIT 0 , 30
*/
/*
return $this->str_ = " SELECT $fname
FROM `06_giveinformation`
WHERE `HN` = '$hn'
AND `$fname` = 'Y' ; ";
*/
return $this->str_ = " SELECT \n DISTINCT ( HN )\n FROM " . $fname;
}
}
$esn = new query3();
$result_give_yes[] = array();
$begin = trim($_REQUEST['begin']);
$end = trim($_REQUEST['end']);
$b_conv = $esn->date_eng_format($begin);
$e_conv = $esn->date_eng_format($end);
$tb = "`06_giveinformation`";
$field_name = "GiveInformation1";
$fname = $tb . " WHERE `MonitoringDate` BETWEEN ' {$b_conv}' AND '{$e_conv}' AND ";
# WHERE `MonitoringDate` BETWEEN ' $b_conv' AND '$e_conv'
// echo $esn->query_tb($fname);
$z = 1;
while ($z <= 5) {
$fname_ = " GiveInformation" . $z . " ='Y' ;";
#echo $strQue_= $esn->query_tb($hn,$fname);
$strQue_ = $esn->query_tb($fname . $fname_);
