www.gusucode.com > 2029网博士成品网站管理系统 PHP网站源码程序 > 2028/hospital/module/HospitalReserveDue.php

    <?php


function HospitalReserveDue(){

	global $msql,$fsql,$strAm,$strPm;
	global $strWeek1,$strWeek2,$strWeek3,$strWeek4,$strWeek5,$strWeek6,$strWeek7;


	$coltitle=$GLOBALS["PLUSVARS"]["coltitle"];
	$tempname=$GLOBALS["PLUSVARS"]["tempname"];

	$memberid=$_COOKIE["MEMBERID"];
	$step=$_REQUEST["step"];
	
	$nowtime=time();
	$nowdate=date("Ymd", $nowtime);


	//模板解释
	$Temp=LoadTemp($tempname);
	$TempArr=SplitTblTemp($Temp);

	$var=array(
		'coltitle' => $coltitle
	);
	
	$str=ShowTplTemp($TempArr["start"],$var);

	//预约记录查询
	$msql->query("select * from {P}_hospital_yyinfo where `memberid`='$memberid' and `yydate`<$nowdate order by dtime desc");
	while($msql->next_record()){
		$id=$msql->f('id');
		$yyid=$msql->f('yyid');
		$eid=$msql->f('eid');
		$catid=$msql->f('catid');
		$name=$msql->f('name');
		$yydate=$msql->f('yydate');
		$yyweek=$msql->f('yyweek');
		$yyamorpm=$msql->f('yyamorpm');
		$dtime=$msql->f('dtime');
		$ifsure=$msql->f('ifsure');

		$dtime=date("Y-m-d",$dtime);
		
		$yydateinfo=substr($yydate,0,4)."-".substr($yydate,4,2)."-".substr($yydate,6,2);
		
		//获取周信息
		switch($yyweek){
			case 0: $yyweekinfo=$strWeek7; break;
			case 1: $yyweekinfo=$strWeek1; break;
			case 2: $yyweekinfo=$strWeek2; break;
			case 3: $yyweekinfo=$strWeek3; break;
			case 4: $yyweekinfo=$strWeek4; break;
			case 5: $yyweekinfo=$strWeek5; break;
			case 6: $yyweekinfo=$strWeek6; break;
		}
		
		//判断上午或下午
		if($yyamorpm=="am"){
			$yyamorpminfo=$strAm;
		}elseif($yyamorpm=="pm"){
			$yyamorpminfo=$strPm;
		}
		
		//读取科室分类名称
		$fsql->query("select cat from {P}_hospital_cat where catid='$catid'");
		if($fsql->next_record()){
			$cat=$fsql->f('cat');
		}
		

		$var=array (
			'id' => $id,
			'yyid' => $yyid, 
			'eid' => $eid, 
			'catid' => $catid, 
			'cat' => $cat, 
			'name' => $name, 
			'yydateinfo' => $yydateinfo,
			'yyweekinfo' => $yyweekinfo,
			'yyamorpminfo' => $yyamorpminfo,
			'dtime' => $dtime
		);

		$str.=ShowTplTemp($TempArr["list"],$var);

	}

	$str.=$TempArr["end"];

	return $str;


}

?>