public function doMobileorderlist() { global $_GPC, $_W; $weid = $this->_weid; $this->check_login(); $memberid = $this->_user_info['id']; if (empty($memberid)) { $url = $this->createMobileUrl('index'); header("Location: {$url}"); } $ac = $_GPC['ac']; if ($ac == "getDate") { $pindex = max(1, intval($_GPC['page'])); $psize = 10; $sql = "SELECT o.*, h.title "; $where = " FROM " . tablename('hotel2_order') . " AS o"; $where .= " LEFT JOIN " . tablename('hotel2') . " AS h ON o.hotelid = h.id"; $where .= " WHERE 1 = 1"; $where .= " AND o.memberid = {$memberid}"; $where .= " AND o.weid = {$weid}"; $count_sql = "SELECT COUNT(o.id) " . $where; $sql .= $where; $sql .= " ORDER BY o.id DESC"; if ($pindex > 0) { // 需要分页 $start = ($pindex - 1) * $psize; $sql .= " LIMIT {$start},{$psize}"; } $list = pdo_fetchall($sql); $total = pdo_fetchcolumn($count_sql); $page_array = get_page_array($total, $pindex, $psize); $data = array(); $data['result'] = 1; ob_start(); include $this->template('order_crumb'); $data['code'] = ob_get_contents(); ob_clean(); $data['total'] = $total; $data['isshow'] = $page_array['isshow']; if ($page_array['isshow'] == 1) { $data['nindex'] = $page_array['nindex']; } die(json_encode($data)); } else { include $this->template('orderlist'); } }
public function doMobileorderlist() { global $_GPC, $_W; $weid = $_W['uniacid']; $openid = $_W['fans']['from_user']; checkauth(); //订单提交用户登录验证 $ac = $_GPC['ac']; // var_dump($openid); //die(); if ($ac == "getDate") { $pindex = max(1, intval($_GPC['page'])); $psize = 5; $sql = 'SELECT * FROM ' . tablename('fb_order') . ' WHERE `weid`=:weid AND `openid`=:openid'; //查询订单 $params = array(':weid' => $weid, ':openid' => $openid); $where = " FROM " . tablename('fb_order') . "WHERE `weid`=:weid AND `openid`=:openid "; $count_sql = "SELECT COUNT(" . tablename('fb_order') . ".id)" . $where; //查询订单第一列 if ($pindex > 0) { // 需要分页 $start = ($pindex - 1) * $psize; $sql .= " LIMIT {$start},{$psize}"; } $list = pdo_fetchall($sql, $params); //var_dump($list);die(); $total = pdo_fetchcolumn($count_sql, $params); $page_array = get_page_array($total, $pindex, $psize); $data = array(); $data['result'] = 1; ob_start(); include $this->template('order_crumb'); $data['code'] = ob_get_contents(); ob_clean(); $data['total'] = $total; $data['isshow'] = $page_array['isshow']; if ($page_array['isshow'] == 1) { $data['nindex'] = $page_array['nindex']; } die(json_encode($data)); } else { include $this->template('orderlist'); } }
/** * 考试进行中 */ public function doMobileStart() { global $_GPC, $_W; $this->check_member(); $weid = $_W['uniacid']; $pindex = max(1, intval($_GPC['page'])); $psize = 1; $paperid = intval($_GPC['paperid']); $recordid = intval($_GPC['recordid']); $types_config = $this->_types_config; $answer_array = $this->_answer_array; if (empty($paperid) || empty($recordid)) { echo "传递参数错误"; exit; } $record_info = $this->getRecordInfo($recordid); //该试卷已经完成,不能再继续了 if ($record_info['did'] == 1) { echo "该试卷已经完成,不能再继续了"; exit; } $member_info = $this->getMemberInfo(); //提交答案 if (checksubmit('submit')) { $data = array(); $data['result'] = 1; $count_flag = intval($_GPC['count_flag']); $questionid = intval($_GPC['questionid']); $now_page = intval($_GPC['now_page']); $btime = intval($_GPC['btime']); $type = intval($_GPC['type']); $items = ""; $answer = ""; $now_time = time(); //试题类型 switch ($type) { case 1: //判断题 $answer = $_GPC['answer1']; break; case 2: //单选题 $answer = $_GPC['answer2']; break; case 3: //多选题 $arr = $_GPC['answer3']; if (empty($arr)) { $answer = ''; } else { $answer = implode("", $arr); } break; } //判断答案是否正确 $now_question_info = get_one_question($questionid); if (empty($answer)) { $isright = 0; } else { if ($now_question_info['answer'] == $answer) { $isright = 1; } else { $isright = 0; } } //判断用户是否回答过 $params = array(); $params[':weid'] = $weid; $params[':paperid'] = $paperid; $params[':memberid'] = $member_info['id']; $params[':recordid'] = $recordid; $params[':questionid'] = $questionid; $item = get_one_member_question($params); //要添加或者更新的数据 $array = array(); $array['isright'] = $isright; $array['answer'] = $answer; $array['type'] = $type; $array['pageid'] = $now_page; if ($item) { //已经回答过 pdo_update('ewei_exam_paper_member_data', $array, array('id' => $item['id'])); if ($isright == 1 && $item['isright'] == 0) { //多少人正确+1 $this->updateQuestionMemberNum($questionid, 2); } } else { //还没有回答过 $array['weid'] = $weid; $array['paperid'] = $paperid; $array['memberid'] = $member_info['id']; $array['recordid'] = $recordid; $array['questionid'] = $questionid; $array['createtime'] = $now_time; pdo_insert('ewei_exam_paper_member_data', $array); if ($isright) { //多少人做过,正确+1 $this->updateQuestionMemberNum($questionid, 3); } else { //多少人做过+1 $this->updateQuestionMemberNum($questionid, 1); } } //统计该用户当前试卷的做题情况 if ($count_flag) { $paper_info = $this->getPaperInfo($paperid); $total = $paper_info['total']; $now_total = get_count_one_paper_record($params); if ($now_total == $total) { $msg = "共" . $total . "题,您已全部做完"; } else { $msg = "共" . $total . "题,您做了" . $now_total . "题,还剩" . ($total - $now_total) . "题未做"; } $data['count_msg'] = $msg; } die(json_encode($data)); } else { $question_item = get_paper_question_list($paperid); $total = count($question_item); $ac = $_GPC['ac']; //获取题目信息 if ($ac == "getDate") { $data = array(); $data['result'] = 1; if ($pindex > $total) { $data['result'] = 0; $data['error'] = "抱歉,题数参数错误"; echo 12345; exit; die(json_encode($data)); } $question_info = $question_item[$pindex - 1]; if (!$question_info) { $data['result'] = 0; $data['error'] = "抱歉,试题错误"; die(json_encode($data)); } //判断用户是否回答过 $params = array(); $params[':weid'] = $weid; $params[':paperid'] = $paperid; $params[':memberid'] = $member_info['id']; $params[':recordid'] = $recordid; $params[':questionid'] = $question_info['id']; $item = get_one_member_question($params); if ($item) { //已经回答过 $is_has = 1; } else { //还没有回答过 $is_has = 0; } $page_array = get_page_array($total, $pindex, $psize); ob_start(); include $this->template('question_form'); $data['code'] = ob_get_contents(); ob_clean(); $data['total'] = $total; $data['isshow'] = $page_array['isshow']; if ($page_array['isshow'] == 1) { $data['nindex'] = $page_array['nindex']; } die(json_encode($data)); } else { if ($ac == "close_exam") { $paper_info = $this->getPaperInfo($paperid); $now_question = $this->getRecordQuestion($paper_info, $recordid); //结束本次考试记录 $data = array(); $data['score'] = $now_question['score']; $data['did'] = 1; pdo_update('ewei_exam_paper_member_record', $data, array('id' => $recordid)); //计算平均分和用时 $sql = "SELECT AVG(score) as avg_score, AVG(times) as avg_times FROM " . tablename('ewei_exam_paper_member_record'); $sql .= " WHERE paperid = :paperid AND weid = :weid AND did = 1"; $question_item = pdo_fetch($sql, array(':paperid' => $paperid, ':weid' => $weid)); $avg_score = round($question_item['avg_score'], 2); $avg_times = $question_item['avg_times']; //更新到试卷信息表中 $data = array(); $data['avscore'] = $avg_score; $data['avtimes'] = $avg_times; pdo_update('ewei_exam_paper', $data, array('id' => $paperid)); $url = $this->createMobileUrl('score', array('paperid' => $paperid, 'recordid' => $recordid)); die(json_encode(array("result" => 1, "url" => $url))); } else { if ($ac == "update_countdown") { $paper_info = $this->getPaperInfo($paperid); if ($record_info['countdown'] > 0) { $countdown = intval($_GPC['total_time']); //更新考试剩余时间 $data = array(); $data['countdown'] = $countdown; $data['times'] = $paper_info['times'] * 60 - $countdown; pdo_update('ewei_exam_paper_member_record', $data, array('id' => $recordid)); } else { $data['times'] = $paper_info['times'] * 60; pdo_update('ewei_exam_paper_member_record', $data, array('id' => $recordid)); } } else { $paper_info = $this->getPaperInfo($paperid); include $this->template('question'); } } } } }
public function doReserve() { global $_GPC, $_W; $weid = $_W['weid']; $op = $_GPC['op']; if ($op == 'edit') { $id = intval($_GPC['id']); if (!empty($id)) { $params = array(); $params[':weid'] = $weid; $params[':id'] = $id; $sql = "SELECT p.courseid, p.msg, p.username, p.mobile, p.email, p.status as reserve_stauts, p.createtime as reserve_createtime, c.*"; $sql .= " FROM " . tablename('ewei_exam_course_reserve') . " AS p"; $sql .= " LEFT JOIN " . tablename('ewei_exam_course') . " AS c ON p.courseid = c.id"; $sql .= " WHERE 1 = 1"; $sql .= " AND p.weid = :weid"; $sql .= " AND p.id = :id"; $item = pdo_fetch($sql, $params); if (empty($item)) { message('抱歉,订单不存在或是已经删除!', '', 'error'); } } else { message('抱歉,参数错误!', '', 'error'); } if (checksubmit('submit')) { $old_status = $_GPC['oldstatus']; $data = array('status' => $_GPC['status'], 'msg' => $_GPC['msg'], 'mngtime' => time()); //订单确认 if ($data['status'] == 1 && $old_status != 1) { pdo_query("update " . tablename('ewei_exam_course') . " set fansnum = fansnum + 1 where id=:id", array(":id" => $item['courseid'])); } //订单取消 if ($old_status == 1 && $data['status'] != 1) { if ($item['fansnum'] > 0) { pdo_query("update " . tablename('ewei_exam_course') . " set fansnum = fansnum - 1 where id=:id", array(":id" => $item['courseid'])); } } pdo_update('ewei_exam_course_reserve', $data, array('id' => $id)); message('订单信息处理完成!', $this->createWebUrl('reserve'), 'success'); } include $this->template('reserve_form'); } else { if ($op == 'delete') { $id = intval($_GPC['id']); $item = pdo_fetch("SELECT id FROM " . tablename('ewei_exam_course_reserve') . " WHERE id = :id LIMIT 1", array(':id' => $id)); if (empty($item)) { message('抱歉,订单不存在或是已经删除!', '', 'error'); } pdo_delete('ewei_exam_course_reserve', array('id' => $id)); message('删除成功!', referer(), 'success'); } else { if ($op == 'deleteall') { foreach ($_GPC['idArr'] as $k => $id) { $id = intval($id); pdo_delete('ewei_exam_course_reserve', array('id' => $id)); } //$this->message('订单删除成功!', '', 0); exit; } else { $pindex = max(1, intval($_GPC['page'])); $psize = 10; $title = $_GPC['title']; $username = $_GPC['username']; $mobile = $_GPC['mobile']; $ordersn = $_GPC['ordersn']; $status = $_GPC['status']; $ctype = $_GPC['ctype']; $params = array(); $params[':weid'] = $weid; $sql = "SELECT p.*, c.title, c.coursetime, c.ctype"; $count_sql = "SELECT COUNT(p.id)"; $where = ''; $where .= " FROM " . tablename('ewei_exam_course_reserve') . " AS p"; $where .= " LEFT JOIN " . tablename('ewei_exam_course') . " AS c ON p.courseid = c.id"; $where .= " WHERE 1 = 1"; $where .= " AND p.weid = :weid"; if (!empty($title)) { $where .= ' AND c.title LIKE :title'; $params[':title'] = "%{$title}%"; } if (!empty($username)) { $where .= ' AND p.username LIKE :username'; $params[':username'] = "******"; } if (!empty($mobile)) { $where .= ' AND p.mobile LIKE :mobile'; $params[':mobile'] = "%{$mobile}%"; } if (!empty($ordersn)) { $where .= ' AND p.ordersn LIKE :ordersn'; $params[':ordersn'] = "%{$ordersn}%"; } if ($status != '') { $where .= " and p.status=" . intval($status); } if ($ctype != '') { $where .= " and c.ctype=" . intval($ctype); } $sql .= $where; $sql .= " ORDER BY id DESC"; if ($pindex > 0) { // 需要分页 $start = ($pindex - 1) * $psize; $sql .= " LIMIT {$start},{$psize}"; } $count_sql .= $where; $list = pdo_fetchall($sql, $params); $total = pdo_fetchcolumn($count_sql, $params); $page_array = get_page_array($total, $pindex, $psize); //print_r($ctype);exit; // // // $roomtitle = $_GPC['roomtitle']; // $hoteltitle = $_GPC['hoteltitle']; // $condition = ''; // $params = array(); // if (!empty($hoteltitle)) { // $condition .= ' AND h.title LIKE :hoteltitle'; // $params[':hoteltitle'] = "%{$hoteltitle}%"; // } // if (!empty($roomtitle)) { // $condition .= ' AND r.title LIKE :roomtitle'; // $params[':roomtitle'] = "%{$roomtitle}%"; // } // // if (!empty($realname)) { // $condition .= ' AND o.name LIKE :realname'; // $params[':realname'] = "%{$realname}%"; // } // if (!empty($mobile)) { // $condition .= ' AND o.mobile LIKE :mobile'; // $params[':mobile'] = "%{$mobile}%"; // } // if(!empty($hotelid)){ // $condition.=" and o.hotelid=".$hotelid; // } // if(!empty($roomid)){ // $condition.=" and o.roomid=".$roomid; // } // // $pindex = max(1, intval($_GPC['page'])); // $psize = 20; // $list = pdo_fetchall("SELECT o.*,h.title as hoteltitle,r.title as roomtitle FROM " . tablename('hotel2_order') . " o left join " . tablename('hotel2') . // "h on o.hotelid=h.id left join ".tablename("hotel2_room")." r on r.id = o.roomid WHERE o.weid = '{$_W['weid']}' $condition ORDER BY o.id DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize,$params); // $total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('hotel2_order') . " o left join " . tablename('hotel2') . // "h on o.hotelid=h.id left join ".tablename("hotel2_room")." r on r.id = o.roomid WHERE o.weid = '{$_W['weid']}' $condition",$params); //$pager = pagination($total, $pindex, $psize); include $this->template('order'); } } } }