public function getReminderAll($user_id)
{
global $CONFIG;
$Array = array();
$arr = array();
$arr["name"] = "未读通知";
$user_id = parameter_filter($user_id);
$sql = "select top 3 id,title as first,\n case notice_type when 'I' then '重要' else '一般' end as second,publish_date as third \n from v_notice_doctor where doctor_id={$user_id} and haveread='N'\norder by publish_date desc ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
$arr["result"] = $result;
$arr["first"] = "标题";
$arr["second"] = "重要性";
$arr["third"] = "发布日期";
$arr["count"] = count($result);
$arr["link"] = $CONFIG['rootpath'] . "/Info/notice.php#";
$Array[] = $arr;
$arr = array();
$arr["name"] = "未回复评价";
$user_id = parameter_filter($user_id);
$sql = "select top 3 id,order_no as first,\n comment as second,comment_date as third \n from v_order_full \n where doctor_id={$user_id} and isnull(reply,'')='' and hascomment='Y' and status='F'\norder by comment_date desc ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
$arr["result"] = $result;
$arr["first"] = "订单编号";
$arr["second"] = "评价";
$arr["third"] = "评价日期";
$arr["count"] = count($result);
$arr["link"] = $CONFIG['rootpath'] . "/Order/ordercomment.php#";
$Array[] = $arr;
return $Array;
}
public function getContent($code)
{
$code = parameter_filter($code);
$sql = "select content from tb_general where code='{$code}' ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array($query);
return $result[0];
}
public function getGeneralContext($code)
{
$code = parameter_filter($code);
$sql = "select * from tb_general where index_key='{$code}' ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array($query);
return $result["content"];
}
public function Save($dbMgr, $request, $sysuser)
{
$remark = parameter_filter($request["remark"]);
$id = $request["primary_id"];
$sql = "update tb_order set remark='{$remark}' where id={$id} ";
$query = $dbMgr->query($sql);
return "right" . $id;
}
public function getContent($id)
{
$id = parameter_filter($id);
$sql = "select * from tb_news where id='{$id}' ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
return $result[0];
}
public function Save($dbMgr, $request, $sysuser)
{
$reply = parameter_filter($request["reply"]);
$id = $request["primary_id"];
$sql = "update tb_order_comment set reply='{$reply}',reply_date=getdate() where order_id={$id} ";
$query = $dbMgr->query($sql);
return "right" . $id;
}
public function getOrder($id)
{
$id = parameter_filter($id);
$sql = "select * from tb_order where id={$id}";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array($query);
return $result;
}
public function updateMeetingInfo($id, $ret)
{
$meeting_id = parameter_filter($ret["id"]);
$meeting_number = parameter_filter($ret["number"]);
$meeting_organizerJoinUrl = parameter_filter($ret["organizerJoinUrl"]);
$meeting_organizerToken = parameter_filter($ret["organizerToken"]);
$meeting_panelistJoinUrl = parameter_filter($ret["panelistJoinUrl"]);
$meeting_panelistToken = parameter_filter($ret["panelistToken"]);
$sql = "update tb_order set meeting_id='{$meeting_id}'\n\t\t,meeting_number='{$meeting_number}'\n\t\t,meeting_organizerJoinUrl='{$meeting_organizerJoinUrl}'\n\t\t,meeting_organizerToken='{$meeting_organizerToken}'\n\t\t,meeting_panelistJoinUrl='{$meeting_panelistJoinUrl}'\n\t\t,meeting_panelistToken='{$meeting_panelistToken}' where id={$id}";
$query = $this->dbmgr->query($sql);
}
public function getBannerList($lastupdate_time)
{
$lastupdate_time = parameter_filter($lastupdate_time);
$sql = "select id,code,title,link,pic,status from tb_banner where 1=1 ";
if ($lastupdate_time != "") {
$sql .= " and updated_date>'{$lastupdate_time}' ";
}
//echo $sql;
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
return $result;
}
public function Save($dbMgr, $request, $sysuser)
{
$remark = parameter_filter($request["remark"]);
$status = parameter_filter($request["status"]);
if ($status == 'T') {
return "你不能把状态改为<订单创建>";
}
$id = $request["primary_id"];
$sql = "update tb_order set remark='{$remark}',status='{$status}' where id={$id} ";
$query = $dbMgr->query($sql);
return "right" . $id;
}
public function changsePassword($doctor_id, $current_password, $new_password)
{
$new_password = parameter_filter($new_password);
$doctor = $this->getDoctor($doctor_id);
if (md5($current_password) != $doctor["password"]) {
return "原密码错误";
}
$new_password = md5($new_password);
$new_password = parameter_filter($new_password);
$sql = "update tb_doctor set password='******',updated_user=-1,updated_date=" . $this->dbmgr->getDate() . " where id={$doctor_id}";
$query = $this->dbmgr->query($sql);
return "SUCCESS";
}
public function Save($dbMgr, $request, $sysuser)
{
global $SysLang;
if ($request["primary_id"] == "") {
$code = $request["license"];
$code = parameter_filter($code);
$sql = "select * from tb_doctor where license='{$code}' ";
$query = $dbMgr->query($sql);
$userRows = $dbMgr->fetch_array_all($query);
if (count($userRows) > 0) {
return $SysLang["doctor"]["codehasbeenused"];
}
}
return parent::Save($dbMgr, $request, $sysuser);
}
public function Save($dbMgr, $request, $sysuser)
{
global $SysLang;
if ($request["primary_id"] == "") {
$key = $request["key"];
$loginname = parameter_filter($key);
$sql = "select * from tb_general where `index_key`='{$key}' ";
$query = $dbMgr->query($sql);
$userRows = $dbMgr->fetch_array_all($query);
if (count($userRows) > 0) {
return $SysLang["general"]["keyduplicate"];
}
}
return parent::Save($dbMgr, $request, $sysuser);
}
public function Save($dbMgr, $request, $sysuser)
{
global $SysLang;
if ($request["primary_id"] == "") {
$login_id = $request["login_id"];
$loginname = parameter_filter($login_id);
$sql = "select * from tb_user where login_id='{$login_id}' ";
$query = $dbMgr->query($sql);
$userRows = $dbMgr->fetch_array_all($query);
if (count($userRows) > 0) {
return $SysLang["user"]["loginnameduplicate"];
}
}
return parent::Save($dbMgr, $request, $sysuser);
}
public function getDepartmentList($hospital_id, $search)
{
$hospital_id = parameter_filter($hospital_id);
$arrcol = array();
$arrcol[] = "d.name";
$arrcol[] = "c.name";
$arrcol[] = "s.name";
$arrcol[] = "cat.name";
$arrcol[] = "dc.name";
$searchsql = splitCodition($arrcol, $search);
$sql = "select distinct d.id, d.college_id,d.name from \ntb_hospital h\ninner join rc_hospital_college rc_hc on h.id=rc_hc.pid\ninner join tb_college c on rc_hc.fid=c.id and c.status='A'\ninner join tb_department d on c.id=d.college_id and d.status='A'\ninner join rc_department_subcategory rc_ds on d.id=rc_ds.pid \ninner join tb_subcategory s on rc_ds.fid=s.id\ninner join tb_category cat on s.category_id=cat.id\ninner join tb_doctor dc on h.id=dc.hospital_id and dc.status='A'\nwhere h.status='A' and h.id={$hospital_id}\nand {$searchsql}\norder by c.seq ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
return $result;
}
public function voteNews($news_id)
{
$news_id = parameter_filter($news_id);
if ($news_id == "") {
return outResult(-1, "news_id can not be null");
}
$sql = "select 1\n\t\tfrom tb_news_statistic where news_id={$news_id}";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
if (count($result) == 0) {
$sql = "insert into tb_news_statistic (news_id) values ({$news_id})";
$this->dbmgr->query($sql);
}
$sql = "update tb_news_statistic set upvote=" . $this->dbmgr->getIsNull("upvote", 0) . "+1 where news_id={$news_id}";
$this->dbmgr->query($sql);
return outResult(0, "success");
}
public function Save($dbMgr, $request, $sysuser)
{
global $SysLang;
$id = 0;
if ($request["primary_id"] != "") {
$id = $request["primary_id"];
}
$doctor_id = $request["doctor_id"];
$office_id = $request["office_id"];
$id = parameter_filter($id);
$doctor_id = parameter_filter($doctor_id);
$office_id = parameter_filter($office_id);
$sql = "select * from dr_tb_office_openhour where doctor_id={$doctor_id} and office_id={$office_id} and id<>{$id} ";
$query = $dbMgr->query($sql);
$userRows = $dbMgr->fetch_array_all($query);
if (count($userRows) > 0) {
return $SysLang["doctor"]["duplicatedoctoroffice"];
}
return parent::Save($dbMgr, $request, $sysuser);
}
public function getDoctorReserve($doctor_id, $first_day)
{
$first_day = parameter_filter($first_day);
$doctor_id = parameter_filter($doctor_id);
$sql = "select d.duty_mon_m,d.duty_mon_a, \nd.duty_tue_m,d.duty_tue_a, \nd.duty_wed_m,d.duty_wed_a,\nd.duty_thu_m,d.duty_thu_a, \nd.duty_fri_m,d.duty_fri_a, \nd.duty_sat_m,d.duty_sat_a,\nd.duty_sun_m,d.duty_sun_a,\ndr.mon_m,dr.mon_a, DATE_ADD('{$first_day}',INTERVAL 0 DAY) mon_date,\ndr.tue_m,dr.tue_a, DATE_ADD('{$first_day}',INTERVAL 1 DAY) tue_date, \ndr.wed_m,dr.wed_a, DATE_ADD('{$first_day}',INTERVAL 2 DAY) wed_date,\ndr.thu_m,dr.thu_a, DATE_ADD('{$first_day}',INTERVAL 3 DAY) thu_date, \ndr.fri_m,dr.fri_a, DATE_ADD('{$first_day}',INTERVAL 4 DAY) fri_date, \ndr.sat_m,dr.sat_a, DATE_ADD('{$first_day}',INTERVAL 5 DAY) sat_date,\ndr.sun_m,dr.sun_a, DATE_ADD('{$first_day}',INTERVAL 6 DAY) sun_date from tb_doctor d\nleft join tb_doctor_reserve dr on d.id=dr.doctor_id and dr.first_day='{$first_day}'\nwhere id={$doctor_id} and status='A'\n";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array($query);
$vacations = $this->getVacation($doctor_id, $first_day);
$t_arr = array();
$t_arr[] = "m";
$t_arr[] = "a";
$d_arr = array();
$d_arr[] = "mon";
$d_arr[] = "tue";
$d_arr[] = "wed";
$d_arr[] = "thu";
$d_arr[] = "fri";
$d_arr[] = "sat";
$d_arr[] = "sun";
$ret = array();
foreach ($t_arr as $t) {
$tac = array();
foreach ($d_arr as $val) {
$arr = array();
$arr["dut"] = $result["duty_" . $val . "_{$t}"] + 0;
$arr["use"] = $result[$val . "_{$t}"] + 0;
$arr["day"] = $result[$val . "_date"];
if (date("Y-m-d") < date("Y-m-d", strtotime($arr["day"]))) {
$arr["active"] = "Y";
}
if ($this->inSchedule($vacations, $arr["day"], "vacation")) {
$arr["onvacation"] = "Y";
}
$arr["tac"] = $t;
$tac[] = $arr;
}
$ret[] = $tac;
}
//print_r($ret);
return $ret;
}
public function Save($dbMgr, $request, $sysuser)
{
global $SysLangConfig;
//print_r($request);
$sql = "";
$dbMgr->begin_trans();
$haveMutilLang = false;
if ($request["primary_id"] == "") {
$id = $dbMgr->getNewId($this->XmlData["tablename"]);
$haveMutilLang = false;
$sql = "insert into " . $this->XmlData["tablename"] . " (id";
$fields = $this->XmlData["fields"]["field"];
foreach ($fields as $value) {
if ($value["ismutillang"] == "1") {
$haveMutilLang = true;
continue;
}
if ($value["type"] == "grid") {
continue;
}
$sql = $sql . "," . $value["key"] . "";
}
$sql = $sql . ",created_date,created_user,updated_date,updated_user ) values (";
$sql = $sql . $id;
foreach ($fields as $value) {
if ($value["type"] == "grid" || $value["ismutillang"]) {
continue;
}
if ($value["type"] == "password") {
$sql = $sql . ",'" . md5($request[$value["key"]]) . "'";
} else {
$sql = $sql . ",'" . parameter_filter($request[$value["key"]]) . "'";
}
}
$sql = $sql . "," . $dbMgr->getDate() . ",{$sysuser}," . $dbMgr->getDate() . ",{$sysuser} )";
$query = $dbMgr->query($sql);
} else {
$haveMutilLang = false;
$id = $request["primary_id"];
$sql = "update " . $this->XmlData["tablename"] . " set updated_date=" . $dbMgr->getDate() . ",updated_user={$sysuser}";
$fields = $this->XmlData["fields"]["field"];
foreach ($fields as $value) {
if ($value["ismutillang"] == "1") {
$haveMutilLang = true;
continue;
}
if ($value["type"] == "grid" || $value["type"] == "password") {
continue;
}
$sql = $sql . ", " . $value["key"] . "='" . parameter_filter($request[$value["key"]]) . "'";
}
$sql = $sql . " where id={$id}";
$query = $dbMgr->query($sql);
foreach ($fields as $value) {
if ($value["type"] == "password") {
$sql = "update " . $this->XmlData["tablename"] . " set ";
$sql = $sql . " " . $value["key"] . "='" . md5($request[$value["key"]]) . "'";
$sql = $sql . " where id={$id} and " . $value["key"] . "<>'" . parameter_filter($request[$value["key"]]) . "'";
$query = $dbMgr->query($sql);
}
}
if ($haveMutilLang) {
foreach ($SysLangConfig["langs"]["lang"] as $lang) {
$sql = "update " . $this->XmlData["tablename"] . "_lang set lang='" . $lang["code"] . "'";
foreach ($fields as $value) {
if ($value["ismutillang"] == "1") {
$sql = $sql . ", " . $value["key"] . "='" . parameter_filter($request[$value["key"] . "_" . $lang["code"]]) . "'";
}
}
$sql = $sql . " where oid={$id} and lang='" . $lang["code"] . "'";
$query = $dbMgr->query($sql);
}
}
}
if ($haveMutilLang) {
$sql = "delete from " . $this->XmlData["tablename"] . "_lang where oid={$id} ";
$query = $dbMgr->query($sql);
foreach ($SysLangConfig["langs"]["lang"] as $lang) {
$sql = "insert into " . $this->XmlData["tablename"] . "_lang (oid,lang";
$fields = $this->XmlData["fields"]["field"];
foreach ($fields as $value) {
if ($value["ismutillang"] == "1") {
$sql = $sql . "," . $value["key"] . "";
}
}
$sql = $sql . " ) values ( {$id} ,'" . $lang["code"] . "' ";
foreach ($fields as $value) {
if ($value["ismutillang"] == "1") {
$sql = $sql . ",'" . parameter_filter($request[$value["key"] . "_" . $lang["code"]]) . "'";
}
}
$sql = $sql . " )";
$query = $dbMgr->query($sql);
}
}
$dbMgr->commit_trans();
return "right" . $id;
}
public function getMeeting($member_id, $date)
{
$member_id = parameter_filter($member_id);
$date = parameter_filter($date);
$sql = "select o.*,c.sexual,c.status case_status from tb_order o\ninner join tb_member_case c on o.case_id=c.id\nwhere o.member_id={$member_id} \nand o.meeting_date='{$date}'\norder by o.meeting_time ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
for ($i = 0; $i < count($result); $i++) {
$meeting_time_start = explode("-", $result[$i]["meeting_time"]);
$meeting_time_start = $meeting_time_start[0];
$result[$i]["meeting_time_start"] = $meeting_time_start;
}
return $result;
}
public function getDoctorWorktime($doctor_id, $date)
{
if ($doctor_id == "") {
return outResult(-1, "doctor_id can not be null");
}
$workday_arr = array();
$doctor_id = parameter_filter($doctor_id);
$sql = "select worktime from tb_doctor where id={$doctor_id} ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array($query);
if ($date != "") {
$date = parameter_filter($date);
//F:fail,D:delete,C:cancel
$sql = "select order_time from tb_order o\n\t\t\tinner join tb_order_videochat ov on o.id=ov.order_id\n\t\t\t where doctor_id={$doctor_id} and order_date='{$date}' and status<>'F' and status<>'D' and status<>'C' ";
$query = $this->dbmgr->query($sql);
$ordertime = $this->dbmgr->fetch_array_all($query);
}
$numberOfWeek = date('w', strtotime($date));
if ($numberOfWeek == 0) {
$numberOfWeek = 7;
}
$worktime_schedule = explode("\n", $result[0]);
$ret = array();
foreach ($worktime_schedule as $value) {
$value = trim(" " . $value);
if ($value != "" && $value[0] == "#") {
if (is_int(intval($value[1])) && ($value[1] <= 7 && $value[1] >= 1)) {
$acce = array();
$acce[0] = 0;
$acce["day"] = $value[1];
$workday_arr[$value[1]] = $acce;
if ($value[1] == $numberOfWeek) {
$dayworktime_arr = explode("->", $value);
$dayworktime = $dayworktime_arr[1];
$invalworktime_arr = explode(",", $dayworktime);
foreach ($invalworktime_arr as $intval) {
$intval = trim($intval);
$fromto = explode("-", $intval);
$from = $fromto[0];
$to = $fromto[1];
$arr = $this->getFromToArray($from, $to, $ordertime);
$ret = array_merge($ret, $arr);
}
}
}
}
}
if ($date != "") {
return $ret;
} else {
return $workday_arr;
}
}
public function getOrder($order_id, $member_id)
{
if ($order_id == "") {
return outResult(-1, "order_id can not be null");
}
if ($member_id == "") {
return outResult(-2, "member_id can not be null");
}
$order_id = parameter_filter($order_id);
$member_id = parameter_filter($member_id);
$sql = "select * from (\n( select v.*,v1.doctor_id tag from v_order v\ninner join tb_order_videochat v1 on v.id=v1.order_id and v.act='VC')\n union ( select v.*,v1.doctor_id tag from v_order v\ninner join tb_order_charchat v1 on v.id=v1.order_id and v.act='CC')\n) v1 where status<>'D' and id={$order_id} and member_id={$member_id} ";
//echo $sql;
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
return $result;
}
private function sendNotice($title, $context, $send_type, $specify_id)
{
$id = $this->dbmgr->getNewId("tb_notice");
$publish_date = date('Y-m-d H:i:s', time());
$id = parameter_filter($id);
$title = parameter_filter($title);
$context = parameter_filter($context);
$doctor_id = parameter_filter($doctor_id);
$member_id = parameter_filter($member_id);
$send_type = parameter_filter($send_type);
$sql = "insert into tb_notice (id,created_date,created_user,updated_date,updated_user,\n\t\ttitle,publish_date,notice_type,context,remarks,status,specify_id,sent_type)\n\t\tvalues ({$id}," . $this->dbmgr->getDate() . ",-1," . $this->dbmgr->getDate() . ",-1,\n\t\t'{$title}','{$publish_date}','M','{$context}','系统自动发送','A',{$specify_id},'{$send_type}')";
$query = $this->dbmgr->query($sql);
}
public function updateVacation($doctor_id, $year, $month, $days)
{
$doctor_id = parameter_filter($doctor_id);
$this->dbmgr->begin_trans();
$days = explode(",", $days);
foreach ($days as $day) {
if (trim($day) != "") {
$date = "{$year}-{$month}-{$day}";
$date = parameter_filter($date);
$sql = "select 1 from tb_doctor_vacation where doctor_id={$doctor_id} and vacation='{$date}'";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
if (count($result) > 0) {
$sql = "delete from tb_doctor_vacation where doctor_id={$doctor_id} and vacation='{$date}'";
$query = $this->dbmgr->query($sql);
} else {
$sql = "insert into tb_doctor_vacation (doctor_id,vacation) values ({$doctor_id},'{$date}')";
$this->dbmgr->query($sql);
}
}
}
$this->dbmgr->commit_trans();
return "RIGHT";
}
function splitCodition($cols, $keyword)
{
$ret = "(1=2 ";
$condition = explode(" ", $keyword);
foreach ($cols as $col) {
foreach ($condition as $v) {
$ret = $ret . " or {$col} like '%" . parameter_filter($v) . "%' \n\t\t\t";
}
}
$ret .= " )";
return $ret;
}
public function upHospitalCount($id)
{
$id = parameter_filter($id);
$sql = "update tb_hospital set count=ifnull(count,10000)+1 where id={$id}";
$query = $this->dbmgr->query($sql);
}
public function registerMember($mobile, $verifycode, $password, $name)
{
if ($mobile == "") {
return outResult(-1, "mobile can not be null");
}
if ($verifycode == "") {
return outResult(-11, "verify code can not be null");
}
if ($password == "") {
return outResult(-12, "password can not be null");
}
$mobile = parameter_filter($mobile);
$sql = "select count(1) from tb_member where mobile='{$mobile}' ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array($query);
if ($result[0] > 0) {
return outResult(-2, "mobile has been used");
}
global $smsMgr;
$lastsent_verifycode = $smsMgr->getLastSent($mobile, "G");
if ($verifycode != $lastsent_verifycode["code"]) {
return outResult(-3, "verify code is incorrect");
}
$id = $this->dbmgr->getNewId("tb_member");
$sql = "insert into tb_member (id,mobile,password,name,status,created_date,created_user,updated_date,updated_user) values\n\t\t({$id},'{$mobile}','{$password}','{$name}','A'," . $this->dbmgr->getDate() . ",-1," . $this->dbmgr->getDate() . ",-1)";
$query = $this->dbmgr->query($sql);
return outResult(0, "register success", $id);
}
public function createCase($member_id, $doctor_id, $file_id, $request)
{
$id = $this->dbmgr->getNewId("tb_member_case");
$apply_hospital = parameter_filter($request["apply_hospital"]);
$apply_date = parameter_filter($request["apply_date"]);
$name = parameter_filter($request["name"]);
$sexual = parameter_filter($request["sexual"]);
$age = parameter_filter($request["age"]);
$category = parameter_filter($request["category"]);
$way = parameter_filter($request["way"]);
$urgent = parameter_filter($request["urgent"]);
$necessary = parameter_filter($request["necessary"]);
$meeting_date = parameter_filter($request["meeting_date"]);
$first_result = parameter_filter($request["first_result"]);
$acresult = parameter_filter($request["result"]);
$checking = parameter_filter($request["checking"]);
$solution = parameter_filter($request["solution"]);
$caution = parameter_filter($request["caution"]);
$signature = parameter_filter($request["signature"]);
$status = parameter_filter($request["status"]);
$summary = parameter_filter($request["summary"]);
$contact = parameter_filter($request["contact"]);
$apply_department = parameter_filter($request["apply_department"]);
$apply_doctor = parameter_filter($request["apply_doctor"]);
$apply_history = parameter_filter($request["apply_history"]);
$apply_situation = parameter_filter($request["apply_situation"]);
$apply_report = parameter_filter($request["apply_report"]);
$apply_procedure = parameter_filter($request["apply_procedure"]);
$apply_first_result = parameter_filter($request["apply_first_result"]);
$contact_tel = parameter_filter($request["contact_tel"]);
$contact_address = parameter_filter($request["contact_address"]);
$hospital = parameter_filter($request["hospital"]);
$department = parameter_filter($request["department"]);
$tel = parameter_filter($request["tel"]);
$tac = parameter_filter($request["tac"]);
$meeting_date_mon = getmon(strtotime($meeting_date));
$dayshort = getDayShortName($meeting_date);
$dayshorttac = $dayshort . "_" . $tac;
$sql = "select d.duty_{$dayshorttac} duty,ifnull(dr.{$dayshorttac},0) `use` from tb_doctor d\nleft join tb_doctor_reserve dr on d.id=dr.doctor_id and dr.first_day='{$meeting_date_mon}'\nwhere d.id={$doctor_id} ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array($query);
if ($result["duty"] <= $result["use"]) {
return "FULLRESERVE";
}
$meetweek = getmonsun(strtotime($meeting_date));
$mon = $meetweek["mon_str_t"];
$sun = $meetweek["sun_str_t"];
$sql = "select * from tb_order\nwhere status='T' and meeting_date>='{$mon} 0:0:0' and meeting_date<='{$sun} 23:59:59'";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
if (count($result) > 0) {
return "RESERVEINWEEK";
}
$sql = "INSERT INTO `tb_member_case`\n(`id`,\n`member_id`,`file_id`,`title`,`doctor_id`,`apply_hospital`,`apply_date`,\n`name`,`sexual`,`age`,`category`,`way`,`urgent`,`necessary`,`meeting_date`,\n`first_result`,`position`,`result`,`checking`,`solution`,`caution`,`signature`,`status`,`created_date`,\n`updated_date`,`summary`,`contact`,`apply_department`,`apply_doctor`,`apply_history`,`apply_situation`,\n`apply_report`,`apply_procedure`,`apply_first_result`,`contact_tel`,`contact_address`,`hospital`,`department`,`tel`)\nVALUES\n({$id},\n{$member_id},{$file_id},'申请单{$meeting_date}',{$doctor_id},'{$apply_hospital}',\n'{$apply_date}','{$name}','{$sexual}','{$age}','{$category}','{$way}','{$urgent}','{$necessary}',\n'{$meeting_date}','{$first_result}','{$position}','{$acresult}','{$checking}','{$solution}','{$caution}','{$signature}','T',\nnow(),now(),'{$summary}','{$contact}','{$apply_department}','{$apply_doctor}','{$apply_history}',\n'{$apply_situation}','{$apply_report}','{$apply_procedure}','{$apply_first_result}',\n'{$contact_tel}','{$contact_address}','{$hospital}','{$department}','{$tel}');\n";
$this->dbmgr->begin_trans();
$this->dbmgr->query($sql);
$uploadfiles = explode("<||>", $request["uploadfiles"]);
$attid = $this->dbmgr->getNewId("tb_member_case_attachment");
foreach ($uploadfiles as $value) {
if ($value != "") {
$uploadfile = explode("<~>", $value);
$filesavename = parameter_filter($uploadfile[0]);
$filename = parameter_filter($uploadfile[1]);
$sql = "insert into tb_member_case_attachment (id,case_id,filesavename,filename)\n\t\t\t\tvalues ({$attid},{$id},'{$filesavename}','{$filename}')";
$this->dbmgr->query($sql);
$attid++;
}
}
$case_id = $id;
$sql = "select 1 from tb_doctor_reserve where doctor_id={$doctor_id} and first_day='{$meeting_date_mon}'";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
if (count($result) > 0) {
$sql = "insert into tb_doctor_reserve (doctor_id,first_day) values ({$doctor},'{$meeting_date_mon}')";
$this->dbmgr->query($sql);
}
$sql = "select price from tb_doctor where id={$doctor_id} ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array($query);
$price = $result["price"];
$id = $this->dbmgr->getNewId("tb_order");
$order_no = $this->genOrderNo("PT");
$sql = "insert into tb_order \n\t\t(id,case_id,price,submit_date,meeting_date,tac,status,\n\t\tcreated_date,created_user,updated_date,updated_user,\n\t\torder_no,doctor_id) values \n\t\t({$id},{$case_id},{$price},now(),'{$meeting_date}','{$tac}','T',\n\t\tnow(),1,now(),1,\n\t\t'{$order_no}',{$doctor_id} )";
$this->dbmgr->query($sql);
$sql = "update tb_doctor_reserve set {$dayshorttac}=ifnull({$dayshorttac},0)+1 \n\t\twhere doctor_id={$doctor_id} and first_day='{$meeting_date_mon}' ";
$this->dbmgr->query($sql);
$this->dbmgr->commit_trans();
return "RIGHT" . $id;
}
private function PerpareSendWithVerifyCode($mobile, $type, $templeteId)
{
$lstrs = $this->getLastSent($mobile, $type);
if ($lstrs["id"] == "") {
$verifycode = $this->genVerifyCode(6, "NUMBER");
} else {
if ($lstrs["lastsent"] < 1) {
return;
}
$verifycode = $lstrs["code"];
}
$arr = array($verifycode, $this->timeout);
$result = $this->Send($mobile, $arr, $templeteId);
if ($result) {
$mobile = parameter_filter($mobile);
$verifycode = parameter_filter($verifycode);
$verifycode = parameter_filter($verifycode);
$templeteId = parameter_filter($templeteId);
if ($lstrs["id"] == "") {
$sql = "insert into tb_sms_code (mobile,code,type,created_time,lastsent_time,templete_id)\n\t\t\t\tvalues ('{$mobile}','{$verifycode}','{$type}',getdate(),getdate(),'{$templeteId}')";
} else {
$id = $lstrs["id"];
$sql = "update tb_sms_code set lastsent_time=getdate() where id={$id} ";
}
$query = $this->dbmgr->query($sql);
}
}
public function resetPassword($user_id, $password, $sysUser_id)
{
$password = parameter_filter($password);
$sql = "update tb_user set password='******',updated_user={$sysUser_id},updated_date=" . $dbMgr->getDate() . " where user_id={$user_id}";
$query = $this->dbmgr->query($sql);
}
