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; } ?>