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

    <?php
define("ROOTPATH", "../");
include(ROOTPATH."includes/common.inc.php");
include("language/".$sLan.".php");
include("includes/hospital.inc.php");

$memberid=$_COOKIE["MEMBERID"];
$nowtime=time();
$act = $_POST['act'];

switch($act){

	//网上预约提交
	case "yyadd":
		
		$eid=htmlspecialchars($_REQUEST["eid"]);
		$catid=htmlspecialchars($_POST["catid"]);
		$name=htmlspecialchars($_POST["name"]);
		$yydate=htmlspecialchars($_POST["yydate"]);
		$yyweek=htmlspecialchars($_POST["yyweek"]);
		$aorp=htmlspecialchars($_POST["aorp"]);
		$yynums=htmlspecialchars($_POST["yynums"]);
		$pname=htmlspecialchars($_POST["pname"]);
		$psex=htmlspecialchars($_POST["psex"]);
		$pbirthday=htmlspecialchars($_POST["pbirthday"]);
		$pcardnum=htmlspecialchars($_POST["pcardnum"]);
		$paddr=htmlspecialchars($_POST["paddr"]);
		$cname=htmlspecialchars($_POST["cname"]);
		$ctel=htmlspecialchars($_POST["ctel"]);
		$ybnum=htmlspecialchars($_POST["ybnum"]);
		$txm=htmlspecialchars($_POST["txm"]);
		
		
		//判断该专家可预约人数是否已满（配合前面进行双重防错）
		$msql->query("select * from {P}_hospital_yyeinfo where eid='$eid' and yydate='$yydate'");
		if($msql->next_record()){
			$yyynumsam=$msql->f('yyynumsam');
			$yyynumspm=$msql->f('yyynumspm');
		}
		
		if($aorp=='am'){
			$yyynums=$yyynumsam;
			$yyynumsinfo="yyynumsam";
		}else{
			$yyynums=$yyynumspm;
			$yyynumsinfo="yyynumspm";
		}
		
		if($yyynums>=$yynums){
			echo $strHospitalNTC2;
			exit;
		}
		//判断结束
		
		//判断该会员在该时间对该专家是否已预约过
		$msql->query("select * from {P}_hospital_yyinfo where memberid='$memberid' and eid='$eid' and yydate='$yydate'");
		if($msql->next_record()){
			echo $strHospitalNTC3;
			exit;
		}
		//判断结束
		
		//接受数据判断
		if($pname==''){
			echo $strHospitalNTC4;
			exit;
		}
		
		if($pbirthday==''){
			echo $strHospitalNTC5;
			exit;
		}
		
		if($pcardnum==''){
			echo $strHospitalNTC6;
			exit;
		}
		
		if($paddr==''){
			echo $strHospitalNTC7;
			exit;
		}
		
		if($cname==''){
			echo $strHospitalNTC8;
			exit;
		}
		
		if($ctel==''){
			echo $strHospitalNTC9;
			exit;
		}
		//接受数据判断结束
		
		//生成流水线号
		$msql->query("select max(yyid) from {P}_hospital_yyinfo");
		if($msql->next_record()){
			$lastyyid=$msql->f('max(yyid)');
		}
		
		if($lastyyid==0 || $lastyyid==''){
			$newyyid=$yydate.'10001';
		}else{
			$lastyynum=substr($lastyyid,8);
			$newyynum=$lastyynum+1;
			$newyyid=$yydate.$newyynum;
		}
		
		//读取配置信息，判断是否需要电话确认
		$msql->query("select value from {P}_hospital_config where variable='MemberTelCheck'");
		if($msql->next_record()){
			$ifsure=$msql->f('value');
		}
		
		//读取科室类别
		$msql->query("select cat from {P}_hospital_cat where catid='$catid'");
			if($msql->next_record()){
			$cat=$msql->f('cat');
		}

		//入库
		$msql->query("insert into {P}_hospital_yyinfo set
			yyid='$newyyid',
			memberid='$memberid',
			eid='$eid',
			catid='$catid',
			cat='$cat',
			contype='hospital',
			name='$name',
			yydate='$yydate',
			yyweek='$yyweek',
			yyamorpm='$aorp',
			pname='$pname',
			psex='$psex',
			pbirthday='$pbirthday',
			pcardnum='$pcardnum',
			paddr='$paddr',
			cname='$cname',
			ctel='$ctel',
			ybnum='$ybnum',
			txm='$txm',
			dtime='$nowtime',
			ifsure='$ifsure'
		");
		
		//更新该专家可预约人数信息
		if($yyynums==0 || $yyynums==''){
			$msql->query("insert into {P}_hospital_yyeinfo set
				eid='$eid',
				catid='$catid',
				contype='hospital',
				name='$name',
				yydate='$yydate',
				yynums='$yynums',
				$yyynumsinfo='1'
			");
		}else{
			$msql->query("update {P}_hospital_yyeinfo set
				$yyynumsinfo='$yyynums'+1
			where eid='$eid' and yydate='$yydate'");
		}

		echo "OK";
		exit;

	break;


}
?>