private function Send($to, $arr, $templeteId)
{
global $CONFIG;
if ($CONFIG['solution_configuration'] == "debug") {
return true;
}
//return true;
$this->resetSDK();
$result = $this->rest->sendTemplateSMS($to, $arr, $templeteId);
if ($result->statusCode != 0) {
$str = "error code :" . $result->statusCode . " ";
$str .= "error msg :" . $result->statusMsg . " ";
$res = outResult($result->statusCode, $result->statusMsg);
outputXml($res);
logger_mgr::logError("sms :{$str}");
//echo $str;
//TODO 添加错误处理逻辑
return false;
} else {
$str = "Sendind TemplateSMS success! ";
// 获取返回信息
$smsmessage = $result->TemplateSMS;
$str .= "dateCreated:" . $smsmessage->dateCreated . " ";
$str .= "smsMessageSid:" . $smsmessage->smsMessageSid . "";
//TODO 添加成功处理逻辑
logger_mgr::logInfo("sms :{$str}");
//echo $str;
return true;
}
return false;
}
protected function outResult($result,$outType='',$out=true)
{
if(!$outType)
{
$outType = $this->DEFAULT_OUT_TYPE;
}
outResult($result,$outType,$out);
}
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 setNoticeRead($doctor_id, $id)
{
if ($doctor_id == "") {
return outResult(-1, "doctor_id can not be null");
}
if ($id == "") {
return outResult(-1, "id can not be null");
}
$sql = "select * from tb_notice_doctor where notice_id={$id} and doctor_id={$doctor_id} ";
$query = $this->dbmgr->query($sql);
$result = $this->dbmgr->fetch_array_all($query);
if (count($result) == 0) {
$sql = "insert into tb_notice_doctor (doctor_id,notice_id,haveread) values ({$doctor_id},{$id},'Y') ";
$query = $this->dbmgr->query($sql);
}
return outResult(0, "success");
}
function out($data=array(),$code=0,$msg='',$type=0,$outType='',$out=true)
{
if(!$outType)
{
$outType = I('request.t',C('DEFAULT_RESPONSE_TYPE'),'trim');
}
$result = array();
if($code != 0)
{
$result = errorByCode($code,$msg,$type);
$result[C('RESPONSE_KEY_DATA')] = $data;
}
else
{
$result = successByData($data);
}
outResult($result,$outType,$out);
}
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;
}
/**
* execute sql statement
* @param string $sql: sql statement
* @param string $type: default '', option: CACHE | UNBUFFERED
* @param int $expires: Cache lifetime, second for unit
* @param string $dbname: db name
* @return resource
*/
function query($sql)
{
global $CONFIG;
if (!($query = @sqlsrv_query($this->conn, $sql))) {
logger_mgr::logError("sql error :{$sql}");
if ($this->in_trans) {
$this->rollback_trans();
}
if ($CONFIG['solution_configuration'] == "debug") {
$res = outResult(-1435, "Sql Error:" . $sql);
outputXml($res);
} else {
$res = outResult(-1435, "Sql Error");
outputXml($res);
}
$this->halt($msg, $sql);
}
logger_mgr::logDebug("sql :{$sql}");
$this->querynum++;
return $query;
}
function MsgError($msg)
{
outResult(false, $msg);
}
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);
}
