public function getlist()
{
$where = " 1";
$page = 1;
$size = 15;
if (!empty($_GET)) {
if ($_GET['page'] != "") {
$page = $_GET['page'];
}
if ($_GET['start_time'] != "" && $_GET['start_time'] != "开始日期") {
$where .= " and time >= '" . $_GET['start_time'] . "'";
}
if ($_GET['end_time'] != "" && $_GET['end_time'] != "截止日期") {
$where .= " and time <= '" . $_GET['end_time'] . " 23:59:59'";
}
if ($_GET['uid'] != "") {
$where .= " and uid = {$_GET['uid']}";
}
if ($_GET['size'] != "") {
$size = $_GET['size'];
}
}
$reOb = new ReserveModel();
$num = $reOb->getCount($where);
//var_dump($num);
import("ORG.Util.Page1");
$pageOb = new Page($page, $size, $num);
//var_dump($pageOb);
$start = $pageOb->getStartStr();
$reArr = $reOb->getList($where, $start, $size);
//var_dump($reArr);echo $reOb->getLastSql();
$pageStr = $pageOb->getPageStr1(1);
$mOb = M("member");
foreach ($reArr as $k => $v) {
$mArr = $mOb->where("id={$reArr[$k]['uid']}")->select();
//var_dump($mArr);
unset($reArr[$k]['uid']);
$reArr[$k]['tel'] = $mArr[0]['tel'];
}
//var_dump($reArr);
$arr = array('page' => $pageStr, 'data' => $reArr);
//var_dump($data);
$data = json_encode($arr);
echo $data;
}
function reserve()
{
//var_dump($_COOKIE['userinfo']);die();
if (!empty($_COOKIE['userinfo'])) {
//读出用户信息
$userArr = unserialize($_COOKIE['userinfo']);
//var_dump($userArr);die();
//查看预定信息
$rOb = new ReserveModel();
$reserveNum = $rOb->getReserveCount();
//var_dump($reserveNum);die();
if ($reserveNum < 1000) {
$rArr = $rOb->getReserve("uid = {$userArr['uid']}");
//echo $rOb->getLastSql();var_dump($rArr);die();
if ($rArr != null) {
$this->assign("jumpUrl", "index.php?m=Reserve&a=introduce");
$this->assign("waitSeconds", "3");
$this->error();
} else {
//得到验证码
$yzm = "123456";
//发送邮件
import("ORG.Util.Phpmailer");
$mail = new PHPMailer();
$mail->CharSet = "UTF-8";
$mail->Encoding = "base64";
// $mail->SMTPDebug=true ;
$mail->IsSMTP();
// 启用SMTP
$mail->SMTPSecure = "ssl";
$mail->Host = "smtp.qq.com";
//SMTP服务器
$mail->Port = 465;
$mail->SMTPAuth = true;
//开启SMTP认证
$mail->Username = "******";
// SMTP用户名
$mail->Password = "******";
// SMTP密码
$mail->From = "*****@*****.**";
//发件人地址
$mail->FromName = "黑米科技";
//发件人
$mail->AddAddress($userArr['email']);
$mail->AddReplyTo("*****@*****.**", "reply");
//回复地址
$mail->WordWrap = 50;
//设置每行字符长度
$mail->IsHTML();
// 是否HTML格式邮件
$mail->Subject = "黑米预定成功提示";
//邮件主题
$mail->Body = "您已成功预定黑米手机，验证码为{$yzm},我们会在正式发售前再次提醒您！";
//邮件内容
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
//邮件正文不支持HTML的备用显示
if ($mail->Send()) {
$this->assign("jumpUrl", "index.php?m=Reserve&a=introduce");
$this->assign("waitSeconds", "3");
$this->success();
} else {
$this->assign("jumpUrl", "index.php?m=Reserve&a=introduce");
$this->assign("waitSeconds", "3");
$this->error();
}
//写进预定表
$arr = array('uid' => $userArr['uid'], 'yzm' => $yzm, 'time' => date("Y-m-d H:i:s"));
$rOb->addReserve($arr);
}
} else {
//提示预定已满
}
} else {
header("location:/index.php?m=Member&a=login");
}
}
