/** * 会员帐号列表 */ public function indexAction() { $where = array('m_hid = ' . $this->model('mber')->quote($this->_master['u_hid'])); $mbers = array(); $pager = array(); $pager['qnty'] = (int) $this->input('qnty', 'numeric'); empty($pager['qnty']) and $pager['qnty'] = 25; $pager['qnty'] = min($pager['qnty'], 30); $pager['page'] = (int) $this->input('page', 'numeric'); empty($pager['page']) and $pager['page'] = 1; $query = array(); $query['qnty'] = $pager['qnty']; $query['name'] = $this->input('name'); $query['type'] = $this->input('type'); in_array($query['type'], array('uqid', 'uqno', 'idno', 'name', 'mail', 'call'), true) or $query['type'] = $query['name'] = null; $query['state'] = $this->input('state', 'array'); $query['state'] or $query['state'] = array(); $query['state'] = array_unique($query['state']); if (!empty($query['state'])) { $where[] = 'm_status IN (' . implode(',', array_map(array($this->model('mber'), 'quote'), $query['state'])) . ')'; } $query['types'] = $this->input('types', 'array'); $query['types'] or $query['types'] = array(); $query['types'] = array_unique($query['types']); if (!empty($query['types'])) { $where[] = 'm_type IN (' . implode(',', array_map(array($this->model('mber'), 'quote'), $query['types'])) . ')'; } if ($query['name'] != '' && $query['type'] != '') { if ($query['type'] == 'uqid') { $where[] = 'm_id = ' . $this->model('mber')->quote($query['name']); } if ($query['type'] == 'uqno') { $where[] = 'm_no = ' . $this->model('mber')->quote($query['name']); } if ($query['type'] == 'idno') { $where[] = 'm_idno = ' . $this->model('mber')->quote($query['name']); } else { if ($query['type'] == 'name') { $where[] = 'm_name = ' . $this->model('mber')->quote($query['name']); } else { if ($query['type'] == 'mail') { $where[] = 'm_email = ' . $this->model('mber')->quote($query['name']); } else { if ($query['type'] == 'call') { $where[] = 'm_phone = ' . $this->model('mber')->quote($query['name']); } } } } } $mbers = Zyon_Array::keyto($this->model('mber')->fetchAry($where, 'm_id DESC', array($pager['qnty'], $pager['qnty'] * ($pager['page'] - 1))), 'm_id'); empty($mbers) and $mbers = array(); $types = $this->model('mber')->getMberTypeAryByHid($this->_hostel['h_id']); $pager['list'] = count($mbers); $pager['args'] = $query; $this->view->pager = $pager; $this->view->query = $query; $this->view->mbers = $mbers; $this->view->types = $types; }
/** * 获取可用预订渠道列表 */ public function fetchAbledIndexAction() { if ($index = Zyon_Array::keyto($this->model('hotel.channel')->getUsableChannelAryByHid($this->_hostel['h_id']), 'hc_id')) { foreach ($index as $key => $val) { $index[$key] = $val['hc_name']; } $this->flash(1, array('context' => $index)); } $this->flash(1, array('context' => array())); }
/** * 更新预订状态的订单 */ public function doUpdateYD($order) { switch ($this->input('tab')) { case 'hfsx': if (!$this->hasUserPerm('/master/order/do-update-attr-yxhf')) { $this->flash(0, '没有更改该属性的权限'); } if ($this->model('order')->modOrder($order['o_id'], array('o_attr' => $this->model('order')->expr('o_attr ^ ' . ORDER_ATTR_YXHF)))) { $this->model('log.order')->addLog($this->model('log.order')->getNewUpdateLog($this->_master, $order, $this->model('order')->getOrder($order['o_id']), __('更改订单%s属性', getOrderAttrNameByCode(ORDER_ATTR_YXHF)))); $this->flash(1); } break; case 'jbxx': if ($order['o_memo'] === $this->input('memo')) { $this->flash(1); } if ($this->model('order')->modOrder($order['o_id'], array('o_memo' => $this->input('memo')))) { $this->model('log.order')->addLog($this->model('log.order')->getNewUpdateLog($this->_master, $order, $this->model('order')->getOrder($order['o_id']), __('基本信息'))); $this->flash(1); } break; case 'ffmx': if (!$this->hasUserPerm('/master/order/do-update-info-fxmx')) { $this->flash(0, '没有权限'); } $bdate = $this->input('bdate'); $bhour = $this->input('bhour', 'numeric'); $bminu = $this->input('bminu', 'numeric'); isset($bhour[1]) or $bhour = '0' . $bhour; isset($bminu[1]) or $bminu = '0' . $bminu; $edate = $this->input('edate'); $ehour = $this->input('ehour', 'numeric'); $eminu = $this->input('eminu', 'numeric'); isset($ehour[1]) or $ehour = '0' . $ehour; isset($eminu[1]) or $eminu = '0' . $eminu; if (!Zyon_Util::isDate($bdate) || !Zyon_Util::isDate($edate) || !Zyon_Util::isTime($bhour . ':' . $bminu) || !Zyon_Util::isTime($ehour . ':' . $eminu)) { $this->flash(0, '预订时间格式错误'); } $bdatm = strtotime($bdate); $edatm = strtotime($edate); $btime = $bdatm + Zyon_Util::timeToSecs($bhour . ':' . $bminu); $etime = $edatm + Zyon_Util::timeToSecs($ehour . ':' . $eminu); if ($edatm <= $bdatm) { $this->flash(0, '离店日期必须晚于入住日期'); } if ($edatm < strtotime(date('Y-m-d', $order['o_ctime']))) { $this->flash(0, '离店日期不能在订单创建日期之前'); } if (($edatm - $bdatm) / 86400 < $this->_hostel['h_order_minlens'] || ($edatm - $bdatm) / 86400 > $this->_hostel['h_order_maxlens']) { $this->flash(0, __('旅店仅支持天数介于 %d 到 %d 的订单', $this->_hostel['h_order_minlens'], $this->_hostel['h_order_maxlens'])); } for ($_btime = max($bdatm, strtotime(date('Y-m-d')) + 86400 * $this->_hostel['h_order_enddays']); $_btime < $etime; $_btime += 86400) { $this->flash(0, __('%s 超出旅店允许建立最多%d天内的订单规则', date('Y-m-d', $_btime), $this->_hostel['h_order_enddays'])); } $oroom = $this->loadUsableRoom($order['o_rid']); $flash = array(); if ($etime > $order['o_etime'] || $btime < $order['o_btime']) { if ($oroom['r_btime']) { $_r_btime = max($bdatm, $oroom['r_btime']); $_r_etime = min($edatm - 1, $oroom['r_etime']); while ($_r_btime < $_r_etime) { $flash[] = __('%s 该房间已被停用', date('Y-m-d', $_r_btime)); $_r_btime += 86400; } } $other = Zyon_Array::keyto($this->model('order')->getOrderAryByIds($this->model('order')->fetchIds(array('o_id <> ' . (int) $order['o_id'], 'o_hid = ' . (int) $order['o_hid'], 'o_rid = ' . (int) $order['o_rid'], 'o_status <> ' . (int) ORDER_STATUS_YQX, 'o_status <> ' . (int) ORDER_STATUS_YD, 'o_bdatm <= ' . (int) $edatm, 'o_edatm >= ' . (int) $bdatm))), 'o_id'); if (!empty($other)) { foreach ($other as $other) { if ($other['o_edatm'] == $bdatm && $other['o_etime'] > $btime) { $flash[] = __('%s 该房间已被其它订单占用', date('Y-m-d H:i', $btime)); } if ($other['o_bdatm'] == $edatm && $other['o_btime'] < $etime) { $flash[] = __('%s 该房间已被其它订单占用', date('Y-m-d H:i', $etime)); } $_o_btime = max($bdatm, $other['o_bdatm']); $_o_etime = min($edatm, $other['o_edatm']); while ($_o_btime < $_o_etime) { $flash[] = __('%s 该房间已被其它订单占用', date('Y-m-d', $_o_btime)); $_o_btime += 86400; } } unset($other); } } if (!empty($flash)) { $this->flash(0, array('content' => $flash)); } $price_array = $this->fetchOrderPrice($this->input('price', 'array'), $bdate, $edate); $brice_array = $this->fetchOrderPrice($this->input('brice', 'array'), $bdate, $edate); if (!$this->model('order')->chkCanUpdateOrder($this->_hostel, $oroom, $order, $btime, $etime)) { $this->flash(0, '无法更新订单至指定时间段'); } /** * 开启事务,更新订单 */ $this->model('order')->dbase()->beginTransaction(); try { $price = array_sum($price_array); $brice = array_sum($brice_array); if ((int) $order['o_brice'] !== $brice) { $bill_old = $this->loadUsableBill($order['o_bid']); if (!$this->model('bill')->modBill($order['o_bid'], array('b_cost' => $this->model('bill')->expr('b_cost + ' . ($brice - $order['o_brice']))))) { throw new exception('更新账单信息失败'); } if ($bill = $this->model('bill')->getBill($order['o_bid'])) { $this->model('log.bill')->addLog($this->model('log.bill')->getNewUpdateLog($this->_master, $bill_old, $bill, __('%d号订单房费 %d=>%d', $order['o_id'], $order['o_brice'] / 100, $brice / 100))); } } if (!$this->model('order')->modOrder($order['o_id'], array('o_btime' => $btime, 'o_etime' => $etime, 'o_price' => $price, 'o_brice' => $brice, 'o_prices' => json_encode($price_array), 'o_brices' => json_encode($brice_array)))) { throw new exception('更新房费明细失败'); } $this->model('order')->dbase()->commit(); $this->model('log.order')->addLog($this->model('log.order')->getNewUpdateLog($this->_master, $order, $this->model('order')->getOrder($order['o_id']), __("房费明细\n[预计入住 %s=>%s, 间夜 %d=>%d, 成交房费 %d=>%d, 账单房费 %d=>%d]", date('Y-m-d H:i', $order['o_btime']), date('Y-m-d H:i', $btime), ($order['o_edatm'] - $order['o_bdatm']) / 86400, ($edatm - $bdatm) / 86400, $order['o_price'] / 100, $price / 100, $order['o_brice'] / 100, $brice / 100))); } catch (Exception $e) { $this->model('order')->dbase()->rollBack(); $this->error($e); $this->flash(0); } $this->flash(1); break; case 'krxx': $gbker = $this->fetchOrderGuest($this->input('gbker', 'array'), HOTEL_GUEST_TYPE_BOOK); $glver = $this->fetchOrderGuest($this->input('glver', 'array'), HOTEL_GUEST_TYPE_LIVE); if ($this->model('order')->modOrder($order['o_id'], array_merge($gbker, $glver))) { $this->model('log.order')->addLog($this->model('log.order')->getNewUpdateGuestLog($this->_master, $order, $this->model('order')->getOrder($order['o_id']))); $this->flash(1); } break; default: $this->flash(0); break; } }
/** * fetchBillPaid * * @param string $input * @param int $total * @return array */ public function fetchBillPaid($input, &$total) { /** * 处理账单已收 */ $bill = $this->input($input, 'array'); if (empty($bill)) { $this->flash(0, '已收款项错误'); } empty($total) and $total = 0; $froms = Zyon_Array::keyto($this->model('hotel.payment')->getUsablePaymentAryByHid($this->_hostel['h_id']), 'hp_id'); empty($froms) and $froms = array(); foreach ($bill as $key => $val) { if (!is_array($val) || !isset($val['qnty']) || !is_string($val['qnty']) || trim($val['qnty']) == '') { unset($bill[$key]); continue; } if (!Zyon_Util::isUnsignedInt($val['from']) || !Zyon_Util::isMoneyFloat($val['qnty']) || $val['qnty'] < 0 || !Zyon_Util::isDate($val['date']) || !isset($val['memo']) || !is_string($val['memo'])) { $this->flash(0, '已收款项错误'); } if (!array_key_exists($val['from'], $froms)) { $this->flash(0, '已收款项渠道错误'); } $val['qnty'] = (empty($val['oper']) ? $val['qnty'] : -$val['qnty']) * 100; $val['memo'] = trim($val['memo']); if (mb_strlen($val['memo']) > 200) { $this->flash(0, '备注内容不能超过200个字符'); } $total += (int) $val['qnty']; if ($total >= 10000000) { $this->flash(0, '已收总金额超出系统限制,必须小于100000'); } if ($total <= -10000000) { $this->flash(0, '已收总金额超出系统限制,必须大于-100000'); } $bill[$key] = $this->model('bill.journal')->getNewJournal(0, $this->_hostel['h_id'], $this->_master['u_id'], $val['from'], $val['qnty'], strtotime($val['date']), $this->_master['u_realname'], $froms[$val['from']]['hp_name'], $val['memo']); } $total = (string) $total; if (empty($bill)) { $this->flash(0, '没有可用的已收款项记录'); } return array_values($bill); }
/** * 时间轴 */ public function indexAction() { $rosta = array('time' => time(), 'line' => array(), 'room' => array(), 'data' => array()); $date = $this->input('date'); $lgth = $this->input('lgth'); $skip = $this->input('skip'); $rids = $this->input('rids'); $time = strtotime(Zyon_Util::isDate($date) ? $date : ($date = date('Y-m-d', $rosta['time'] - 86400))); if (!Zyon_Util::isInt($lgth)) { $lgth = 8; } $lgth = (int) $lgth; if (abs($lgth) > 30 || abs($lgth) < 2) { $this->flash(0, '入住时间和离店时间间隔最少 2天,最长 30天'); } $lgth = $lgth > 0 ? $lgth - 1 : $lgth + 1; // 订单查询默认条件 $where = array('o_hid = ' . $this->model('order')->quote($this->_master['u_hid']), 'o_status <> ' . $this->model('order')->quote(ORDER_STATUS_YQX)); // 指定房间编号集合 if ($rids) { $rids = explode(',', $rids); if (empty($rids)) { $rooms = array(); } else { $rooms = Zyon_Array::keyto($this->model('room')->getRoomAryByIds($rids, $this->_master['u_hid']), 'r_id'); } } else { $rooms = Zyon_Array::keyto($this->model('room')->getRoomAryByHid($this->_master['u_hid']), 'r_id'); } if (!empty($rooms)) { foreach ($rooms as $key => &$room) { if ($room['r_attr'] & ROOM_ATTR_YCFT) { unset($rooms[$key]); } } unset($room); if (!empty($rooms)) { // 增加查询房间限定 $where[] = sprintf('o_rid IN (%s)', implode(',', array_keys($rooms))); } } // 取得上(下)一个有订单时间临界点 if (!empty($rooms) && $skip) { if ($lgth < 0) { $orders = $this->model('order')->fetch(array('where' => array_merge($where, array('o_etime < ' . $this->model('order')->quote($time))), 'order' => 'o_etime DESC', 'field' => 'o_edatm', 'limit' => 1)); if ($orders) { $time = (int) $orders[0]['o_edatm']; } } else { $orders = $this->model('order')->fetch(array('where' => array_merge($where, array('o_btime > ' . $this->model('order')->quote($time))), 'order' => 'o_btime ASC', 'field' => 'o_bdatm', 'limit' => 1)); if ($orders) { $time = (int) $orders[0]['o_bdatm']; } } } // 令 {$time} 为左值 if ($lgth < 0) { $time = $time + $lgth * 86400; $lgth = abs($lgth); } $btime = $time; $etime = $btime + $lgth * 86400 + 86399; $rosta['line'][] = $btime; $rosta['line'][] = $etime; if (!empty($rooms)) { $obnum = $this->model('order')->calNumAryByRidAryAndSta(array_keys($rooms), ORDER_STATUS_YD, $rosta['time'] - 86400 * 3); foreach ($rooms as &$room) { $rosta['data'][$room['r_id']] = array(); $rosta['room'][$room['r_id']] = array('rid' => $room['r_id'], 'sta' => $room['r_status'], 'rnm' => $this->view->escape($room['r_name']), 'ext' => array('rtp' => $this->view->escape($room['r_type']), 'rlo' => $this->view->escape($room['r_layout']), 'rze' => $this->view->escape($room['r_zone']), 'rvw' => $this->model('room')->getViewListByCode($room['r_view'])), 'ovt' => (int) $room['r_otime'], 'lvt' => (int) $room['r_btime'], 'rvt' => (int) $room['r_etime'], 'obn' => (int) (isset($obnum[$room['r_id']]) ? $obnum[$room['r_id']] : 0)); } unset($room); $orders = Zyon_Array::keyto($this->model('order')->fetchAry(array_merge($where, array('o_btime < ' . $this->model('order')->quote($etime), 'o_etime > ' . $this->model('order')->quote($btime))), 'o_id DESC'), 'o_id'); if (!empty($orders)) { $others = array(); $owhere = array(); foreach ($orders as &$order) { $rosta['data'][$order['o_rid']][$order['o_id']] = array('key' => $order['o_mtime'], 'oid' => $order['o_id'], 'bid' => $order['o_bid'], 'ats' => (int) $order['o_attr'], 'sta' => (int) $order['o_status'], 'lvt' => $order['o_btime'], 'rvt' => $order['o_etime'], 'act' => $this->model('order')->getUsableActions($order, $this->_hostel, false), 'gst' => array('bkg' => array(array('gnm' => $this->view->escape($order['o_gbker_name']), 'tel' => $this->view->escape($order['o_gbker_phone']))), 'lvg' => array(array('gnm' => $this->view->escape($order['o_glver_name']), 'tel' => $this->view->escape($order['o_glver_phone']))))); if ($order['o_memo'] == '') { $rosta['data'][$order['o_rid']][$order['o_id']]['tip'] = ''; } // 检测订单与房态的冲突 if ($order['o_btime'] <= $rooms[$order['o_rid']]['r_etime'] && $order['o_edatm'] > $rooms[$order['o_rid']]['r_btime']) { unset($rosta['data'][$order['o_rid']][$order['o_id']]['act'][ORDER_ACTION_BLDD]); unset($rosta['data'][$order['o_rid']][$order['o_id']]['act'][ORDER_ACTION_BLRZ]); } // 拆分占位和不占位订单 if ($order['o_status'] == ORDER_STATUS_YD) { $owhere = empty($owhere) ? array(min($order['o_btime'], $btime), max($order['o_etime'], $etime)) : array(min($order['o_btime'], $owhere[0]), max($order['o_etime'], $owhere[1])); } else { $others[$order['o_id']] = $order; unset($orders[$order['o_id']]); } } unset($order); // 获取扩展时间段的订单 if (!empty($owhere) && ($owhere[0] < $btime || $owhere[1] > $etime)) { $others += Zyon_Array::keyto($this->model('order')->fetch(array('where' => array_merge($where, array(sprintf('o_id NOT IN (%s)', implode(',', array_merge(array_keys($orders), array_keys($others)))), 'o_status <> ' . $this->model('order')->quote(ORDER_STATUS_YD), 'o_btime < ' . $this->model('order')->quote($owhere[1]), 'o_etime > ' . $this->model('order')->quote($owhere[0]))), 'field' => array('o_id', 'o_rid', 'o_btime', 'o_etime'))), 'o_id'); } // 检测不占位的订单冲突 foreach ($orders as &$order) { foreach ($others as &$other) { if ($other['o_rid'] === $order['o_rid'] && $other['o_btime'] < $order['o_etime'] && $other['o_etime'] > $order['o_btime']) { unset($rosta['data'][$order['o_rid']][$order['o_id']]['act'][ORDER_ACTION_BLDD]); unset($rosta['data'][$order['o_rid']][$order['o_id']]['act'][ORDER_ACTION_BLRZ]); break; } } unset($other); } unset($order, $orders, $others); } } if ($this->input('ct') === 'json') { $this->flash(1, array('context' => $rosta)); } $this->view->hotel = $this->_hostel; $this->view->rosta = $rosta; }
/** * 旅店房态 */ public function indexAction() { $this->checkHotelStat($hotel = $this->loadUsableHotel($this->input('hid'))); if ((!$this->_master || $this->_master['u_hid'] !== $hotel['h_id']) && !(SYSTEM_GROUPS_GSER & (int) $hotel['h_rosta_visible'])) { $this->flash(0, '旅店尚未开放该功能'); } $rosta = array('time' => time(), 'line' => array(), 'room' => array(), 'data' => array()); $date = $this->input('date'); $lgth = $this->input('lgth'); $time = strtotime(Zyon_Util::isDate($date) ? $date : ($date = date('Y-m-d', $rosta['time']))); if (!Zyon_Util::isInt($lgth)) { $lgth = 8; } $lgth = (int) $lgth; if (abs($lgth) > 30 || abs($lgth) < 2) { $this->flash(0, '入住时间和离店时间间隔最少 2天,最长 30天'); } $lgth = $lgth > 0 ? $lgth - 1 : $lgth + 1; // 令 {$time} 为左值 if ($lgth < 0) { $time = $time + $lgth * 86400; $lgth = abs($lgth); } $btime = $time; $etime = $btime + $lgth * 86400 + 86399; $rosta['line'][] = $btime; $rosta['line'][] = $etime; if ($btime > $rosta['time'] - 86400) { // 订单查询默认条件 $where = array('o_hid = ' . $this->model('order')->quote($hotel['h_id']), 'o_status <> ' . $this->model('order')->quote(ORDER_STATUS_YQX)); $rooms = Zyon_Array::keyto($this->model('room')->getRoomAryByHid($hotel['h_id']), 'r_id'); if (!empty($rooms)) { foreach ($rooms as $key => &$room) { if ($room['r_attr'] & ROOM_ATTR_YCFT) { unset($rooms[$key]); continue; } $rosta['data'][$room['r_id']] = array(); $rosta['rent'][$room['r_id']] = array(); $rosta['room'][$room['r_id']] = array('rid' => $room['r_id'], 'rnm' => $this->view->escape($room['r_name']), 'ext' => array('rtp' => $this->view->escape($room['r_type']), 'rlo' => $this->view->escape($room['r_layout']), 'rze' => $this->view->escape($room['r_zone']), 'rvw' => $this->model('room')->getViewListByCode($room['r_view']))); if ($btime < $room['r_otime']) { $_r_btime = $btime; $_r_otime = min($etime, $room['r_otime']); while ($_r_btime < $_r_otime) { $rosta['data'][$room['r_id']][($_r_btime - $btime) / 86400] = ROSTA_BL; $_r_btime += 86400; } } if ($room['r_btime']) { $_r_btime = max($btime, $room['r_btime']); $_r_etime = min($etime, $room['r_etime']); while ($_r_btime < $_r_etime) { $rosta['data'][$room['r_id']][($_r_btime - $btime) / 86400] = ROSTA_BL; $_r_btime += 86400; } } } unset($room); } if (!empty($rooms)) { // 增加查询房间限定 $where[] = sprintf('o_rid IN (%s)', implode(',', array_keys($rooms))); $orders = Zyon_Array::keyto($this->model('order')->getOrderAryByIds($this->model('order')->fetchIds(array_merge($where, array('o_bdatm < ' . $this->model('order')->quote($etime), 'o_edatm > ' . $this->model('order')->quote($btime))))), 'o_id'); if (!empty($orders)) { foreach ($orders as &$order) { switch ($order['o_status']) { case ORDER_STATUS_YD: $sta = ROSTA_YD; break; default: $sta = ROSTA_BL; break; } $_o_btime = max($btime, $order['o_bdatm']); $_o_etime = min($etime, $order['o_edatm']); while ($_o_btime < $_o_etime) { $key = ($_o_btime - $btime) / 86400; if (!isset($rosta['data'][$order['o_rid']][$key]) || $rosta['data'][$order['o_rid']][$key] !== ROSTA_BL) { $rosta['data'][$order['o_rid']][$key] = $sta; } $_o_btime += 86400; } } unset($order); } $prices = $this->model('room.price')->getPriceDotAryByHid($hotel['h_id'], $btime, $etime); if (!empty($prices)) { foreach ($prices as $rid => &$lst) { if (isset($rooms[$rid])) { foreach ($lst as $dtm => $val) { $val = (int) $val; if (($end = end($rosta['rent'][$rid])) !== false && $end === $val) { unset($rosta['rent'][$rid][$key = key($rosta['rent'][$rid])]); $key = explode(',', $key); $key[1] = ($dtm - $btime) / 86400; $rosta['rent'][$rid][implode(',', $key)] = $val; } else { $rosta['rent'][$rid][($dtm - $btime) / 86400] = $val; } } } } unset($lst); } // 合并相同状态的单元格,键 P 改为 L,R foreach ($rosta['data'] as $key => &$val) { $lst = array(); ksort($val, SORT_NUMERIC); $idx = -1; foreach ($val as $k => $v) { if ($k && isset($val[$k - 1]) && $val[$k - 1] === $v) { $lst[$idx][2] = $k; } else { ++$idx; $lst[] = array($v, $k); } } $rosta['data'][$key] = array(); foreach ($lst as $k => $v) { $rosta['data'][$key][isset($v[2]) ? $v[1] . ',' . $v[2] : $v[1]] = $v[0]; } } } } if ($this->input('ct') === 'json') { $this->flash(1, array('context' => $rosta)); } $this->view->hotel = $hotel; $this->view->rosta = $rosta; }
/** * 创建订单 */ public function doCreateAction() { if (!$this->getRequest()->isPost()) { $this->flash(0, '错误来源的表单提交'); } $captcha = new Geek_Captcha_Image('/hostel/order/do-create'); if (!$captcha->isValid($this->input('captcha'))) { $this->flash(0, '请填写正确的验证码'); } if (!Zyon_Util::isUnsignedInt($otime = $this->input('ctime')) || !is_array($order = $this->input('order', 'array')) || empty($order) || !is_array($orent = $this->input('price', 'array')) || empty($orent) || !is_array($gbker = $this->input('cuser', 'array')) || empty($gbker) || !is_array($glves = $this->input('guest', 'array')) || empty($glves) || ($count = count($order)) !== count($orent) || $count !== count($glves) || !isset($gbker['name']) || !isset($gbker['call']) || !isset($gbker['mail'])) { $this->flash(0, '提交订单的参数错误'); } $gbker = array('o_gbker_name' => $gbker['name'], 'o_gbker_email' => $gbker['mail'], 'o_gbker_phone' => $gbker['call']); if (!$this->model('order')->verify($gbker)) { $this->flash(0, '预订客人信息参数错误'); } $ctime = time(); $dtime = strtotime(date('Y-m-d', $ctime)); if ($ctime - $otime < 10 || $ctime - $otime > 1800 || $dtime !== strtotime(date('Y-m-d', $otime))) { $this->flash(0, '订单已失效,请刷新重试'); } $this->checkHotelStat($hotel = $this->loadUsableHotel($hid = $this->input('hid'))); if (!(SYSTEM_GROUPS_GSER & (int) $hotel['h_order_enabled'])) { $this->flash(0, '旅店尚未开放该功能'); } if ($count > static::ORDER_LIMIT) { $this->flash(0, __('单次预订不允许超过%d个房间', static::ORDER_LIMIT)); } $btmad = $hotel['h_checkin_time']; $etmad = $hotel['h_checkout_time']; $price_rules_conds = $other_order_conds = array(); foreach ($order as $rid => &$val) { if (!Zyon_Util::isUnsignedInt($rid) || !is_array($val) || !isset($val['date']) || !isset($val['lgth']) || !Zyon_Util::isDate($val['date']) || !Zyon_Util::isUnsignedInt($val['lgth']) || $val['lgth'] < 1 || !is_array($val['time']) || !isset($val['time'][0]) || !isset($val['time'][1]) || !Zyon_Util::isUnsignedInt($val['time'][0]) || !Zyon_Util::isUnsignedInt($val['time'][1]) || $val['time'][0] < $btmad || $val['time'][0] > 86399 || $val['time'][1] > $etmad || $val['time'][0] < 1) { $this->flash(0, '参数错误'); } if ($val['lgth'] < $hotel['h_order_minlens'] || $val['lgth'] > $hotel['h_order_maxlens']) { $this->flash(0, __('旅店仅支持创建天数介于 %d 到 %d 的订单', $hotel['h_order_minlens'], $hotel['h_order_maxlens'])); } $val['datm'] = strtotime($val['date']); if ($val['datm'] < $dtime) { $this->flash(0, '不支持创建今天之前的订单'); } $price_rules_conds[] = sprintf('(rp_rid = %d AND rp_btime <= %d AND rp_etime >= %d)', $rid, $val['datm'] + ($val['lgth'] - 1) * 86400, $val['datm']); $other_order_conds[] = sprintf('(o_rid = %d AND o_btime < %d AND o_etime > %d)', $rid, $val['datm'] + $val['lgth'] * 86400 + $val['time'][1], $val['datm'] + $val['time'][0]); } unset($val); $price_rules_conds = implode(' OR ', $price_rules_conds); $other_order_conds = implode(' OR ', $other_order_conds); $rooms = Zyon_Array::keyto($this->model('room')->getRoomAryByIds(array_keys($order)), 'r_id'); if (empty($rooms) || count($rooms) !== $count) { $this->flash(0, '找不到指定预订的房间'); } // 以下处理每个房间的启用日、停用段以及订单最长时间限制, // 整理入住客人信息 foreach ($rooms as $rid => &$val) { if ($val['r_hid'] !== $hotel['h_id']) { $this->flash(0, '找不到指定预订的房间'); } if ($val['r_attr'] & ROOM_ATTR_YCFT) { $this->flash(0, __('指定的房间 %s 不可预订', $val['r_name'])); } if (!isset($glves[$rid]) || !is_array($glves[$rid]) || !isset($glves[$rid]['name']) || !isset($glves[$rid]['mail']) || !isset($glves[$rid]['call'])) { $this->flash(0, '缺少入住客人信息'); } $glves[$rid] = array('o_glver_name' => $glves[$rid]['name'], 'o_glver_email' => $glves[$rid]['mail'], 'o_glver_phone' => $glves[$rid]['call']); if (!$this->model('order')->verify($glves[$rid])) { $this->flash(0, __('%s 房间的入住客人信息错误', $val['r_name'])); } $btime = $order[$rid]['datm']; $etime = $btime + $order[$rid]['lgth'] * 86400 - 1; for ($_btime = max($btime, $dtime + 86400 * $hotel['h_order_enddays']); $_btime < $etime; $_btime += 86400) { $this->flash(0, __('%s 的 %s 房间不可用', date('Y-m-d', $_btime), $val['r_name'])); } if ($val['r_btime']) { $_r_btime = max($btime, $val['r_btime']); $_r_etime = min($etime, $val['r_etime']); while ($_r_btime < $_r_etime) { $this->flash(0, __('%s 的 %s 房间不可用', date('Y-m-d', $_r_btime), $val['r_name'])); } } if ($btime < $val['r_otime']) { $this->flash(0, __('房间%s在%s之前尚未启用', $val['r_name'], date('Y-m-d', $val['r_otime']))); } } unset($val); // 以下检测旅店预订订单是否超出限制 if ($hotel['h_order_default_stacode'] == ORDER_STATUS_YD) { $oldes = $this->model('order')->calNumAryByRidAryAndSta(array_keys($order), ORDER_STATUS_YD, $ctime - getSysLimit('BOOKING_LIVE')); if (!empty($oldes)) { if ($count + array_sum($oldes) > getSysLimit('BOOKING_QNTY')) { $this->flash(0, '旅店预订订单数量已满'); } $per = getSysLimit('BOOKING_PERN'); foreach ($oldes as $rid => $num) { if (array_key_exists($rid, $order) && $num > $per - 1) { $this->flash(0, __('%s 房间预订订单数量已满', $rooms[$rid]['r_name'])); } } } } // 以下处理每个订单的冲突 $other = $this->model('order')->getOrderAryByIds($this->model('order')->fetchIds(array('o_hid = ' . $hotel['h_id'], 'o_status <> ' . $this->model('order')->quote(ORDER_STATUS_YQX), 'o_status <> ' . $this->model('order')->quote(ORDER_STATUS_YD), $other_order_conds), null, 1)); if (!is_array($other)) { $this->flash(0, '无法获取系统订单的信息'); } if (!empty($other)) { foreach ($other as &$val) { $rid = $val['o_rid']; $_o_btime = max($order[$rid]['datm'], $val['o_bdatm']); $_o_etime = min($order[$rid]['datm'] + $order[$rid]['lgth'] * 86400, $val['o_edatm']); while ($_o_btime < $_o_etime) { $this->flash(0, __('%s 的 %s 房间已被占用', date('Y-m-d', $_o_btime), $rooms[$rid]['r_name'])); } if ($val['o_bdatm'] == $order[$rid]['datm'] + $order[$rid]['lgth'] * 86400 && $order[$rid]['time'][1] > $val['o_btime'] - $val['o_bdatm']) { $this->flash(0, __('%s 的 %s 房间已被占用', date('Y-m-d', $val['o_bdatm']), $rooms[$rid]['r_name'])); } if ($val['o_edatm'] == $order[$rid]['datm'] && $order[$rid]['time'][0] < $val['o_etime'] - $val['o_edatm']) { $this->flash(0, __('%s 的 %s 房间已被占用', date('Y-m-d', $val['o_edatm']), $rooms[$rid]['r_name'])); } } unset($val); } unset($other); // 以下处理每个订单的房费 $basic = $this->model('room.price')->getBasicPriceByRids(array_keys($rooms)); if (!$basic || count($basic) !== $count) { $this->flash(0, '无法获取预订房间的房价'); } $rules = Zyon_Array::group($this->model('room.price')->getPriceAryByIds($this->model('room.price')->fetchIds(array('rp_hid = ' . $hotel['h_id'], $price_rules_conds))), 'rp_rid'); $price = array(); foreach (array_keys($basic) as $rid) { $price[$rid] = $this->model('room.price')->getPriceDotAry($basic[$rid], $order[$rid]['datm'], $order[$rid]['datm'] + $order[$rid]['lgth'] * 86400 - 1, isset($rules[$rid]) ? $rules[$rid] : array()); } unset($basic, $rules); // 以下校验提交订单时的房费和当前是否相同 if (count($price) !== count($orent)) { $this->flash(0, '订单价格错误'); } $obsum = 0; foreach ($price as $rid => &$val) { if (!isset($orent[$rid]) || count($val) !== count($orent[$rid])) { $this->flash(0, '订单价格错误'); } foreach ($val as $k => $v) { if (!isset($orent[$rid][$k])) { $this->flash(0, '订单价格错误'); } if ((string) ($v / 100) !== $orent[$rid][$k]) { $this->flash(0, '订单价格已失效,请刷新重试'); } $obsum += $v; } } unset($val); $sales = $this->model('user')->getUser($hotel['h_order_default_saleman']); if (!$sales) { $this->flash(0, '读取旅店销售人员信息失败'); } $otype = $this->model('hotel.typedef')->getTypedef($hotel['h_order_default_typedef']); if (!$otype) { $this->flash(0, '读取旅店预订类型信息失败'); } $cfrom = $this->model('hotel.channel')->getChannel($hotel['h_order_default_channel']); if (!$cfrom) { $this->flash(0, '读取旅店预订渠道信息失败'); } $osetm = $this->model('hotel.settlem')->getSettlem($hotel['h_obill_default_settlem']); if (!$osetm) { $this->flash(0, '读取旅店结算方式信息失败'); } $ltime = $hotel['h_attr'] & (int) HOTEL_ATTR_ZDGQ ? $ctime + $hotel['h_obill_keptime'] : null; /** * 开启事务,创建订单 */ $this->model('order')->dbase()->beginTransaction(); try { $bid = $this->model('bill')->addBill($this->model('bill')->getNewBill($hid, $osetm['hs_id'], $osetm['hs_name'], $obsum, 0, mb_substr($gbker['o_gbker_name'], 0, 10) . '-' . date('ymdHi', $ctime), $ltime)); if (!$bid) { throw new exception('创建订单相关账单信息失败'); } foreach ($order as $rid => $order) { $order = $this->model('order')->getNewOrder($rooms[$rid], $order['datm'] + $order['time'][0], $order['datm'] + 86400 * $order['lgth'] + $order['time'][1], json_encode($price[$rid]), json_encode($price[$rid]), $hotel['h_order_default_stacode']); $order['o_bid'] = $bid; $order['o_cid'] = $cfrom['hc_id']; $order['o_cnm'] = $cfrom['hc_name']; $order['o_tid'] = $otype['ht_id']; $order['o_tnm'] = $otype['ht_name']; $order['o_sid'] = $sales['u_id']; $order['o_snm'] = $sales['u_realname']; $order['o_attr'] = ORDER_ATTR_ZXDD; $order = array_merge($gbker, $glves[$rid], $order); $oid = $this->model('order')->addOrder($order); if (!$oid) { throw new exception('创建订单失败'); } if ($order = $this->model('order')->getOrder($oid)) { $this->model('log.order')->addLog($this->model('log.order')->getNewCreateByGserLog($gbker, $order)); } } if ($bill = $this->model('bill')->getBill($bid)) { $this->model('log.bill')->addLog($this->model('log.bill')->getNewCreateByGserLog($gbker, $bill)); } $this->model('order')->dbase()->commit(); $this->flash(1, array('forward' => "/hostel/rosta?hid={$hid}")); } catch (Exception $e) { $this->model('order')->dbase()->rollBack(); $this->error($e); } $this->flash(0); }
/** * 批量更新基础房价 */ public function doUpdateBasicPricesAction() { if ($this->cache()->load($hash = md5(__METHOD__ . '@' . $this->_hostel['h_id'] . '#'))) { $this->flash(0, '操作太过频繁,请稍侯再试!'); } $this->cache()->save(1, $hash, array(), 5); $price = $this->input('price'); if (!Zyon_Util::isMoneyFloat($price)) { $this->flash(0, '价格错误'); } if ($price < 0) { $this->flash(0, '价格不能小于0'); } $price = $price * 100; if ($price >= 10000000) { $this->flash(0, '价格超出系统限制范围,必须小于100000'); } $rids = $this->input('rids', 'array'); if (empty($rids)) { $this->flash(0, '没有选中任何房间'); } foreach ($rids as &$val) { if (!Zyon_Util::isUnsignedInt($val)) { $this->flash(0, '指定的房间列表错误'); } } unset($val); $count = count($rids); $rooms = Zyon_Array::keyto($this->model('room')->getRoomAryByIds($rids), 'r_id'); if (empty($rooms) || count($rooms) !== $count) { $this->flash(0, '指定的房间列表错误'); } foreach ($rooms as $rid => &$room) { if ($room['r_hid'] !== $this->_hostel['h_id']) { $this->flash(0, '指定的房间列表错误'); } if ($room['r_price'] === $price) { unset($rooms[$rid]); } } unset($room); $rids = array_keys($rooms); if (empty($rids)) { $this->flash(1); } if ($this->model('room')->modRoomByIds($rids, array('r_price' => $price))) { if ($newRooms = Zyon_Array::keyto($this->model('room')->getRoomAryByIds($rids), 'r_id')) { foreach ($rooms as &$room) { $this->model('log.room')->addLog($this->model('log.room')->getNewUpdateBasicPriceLog($this->_master, $room, $newRooms[$room['r_id']])); } unset($room); } $this->flash(1); } $this->flash(0); }
/** * getPriceDotAryByRid * * @param int $rid * @param int $btime * @param int $etime * @return array */ public function getPriceDotAryByRid($rid, $btime, $etime) { if (!is_numeric($basic = $this->getBasicPriceByRid($rid))) { return false; } return $this->getPriceDotAry($basic, $btime, $etime, Zyon_Array::keyto($this->getPriceAryByRidAndTimeLine($rid, $btime, $etime), 'rp_id')); }
/** * 结算报表 - 预订渠道对账明细 */ public function jsbbYdqddzmxAction() { if (!($date = $this->input('date', 'array'))) { $this->_forward('jsbb-ydqddzmx-form', 'stat', 'master'); return; } if (!isset($date[0]) || !isset($date[1]) || !Zyon_Util::isDate($date[0]) || !Zyon_Util::isDate($date[1])) { $this->flash(0, '查询的日期格式错误'); } $tmln = array(); $tmln[0] = strtotime($date[0]); $tmln[1] = strtotime($date[1]) + 86400; $lgth = ($tmln[1] - $tmln[0]) / 86400; if (!Zyon_Util::isUnsignedInt($lgth) || $lgth > 31 || $lgth < 1) { $this->flash(0, '选择的日期超出了可查询的范围'); } $tmln[1] -= 1; $cnid = $this->input('cnid'); $cnid == '' and $cnid = $this->_hostel['h_order_default_channel']; $cnls = Zyon_Array::keyto($this->model('hotel.channel')->getChannelAryByHid($this->_hostel['h_id']), 'hc_id'); empty($cnls) and $cnls = array(); if (!array_key_exists($cnid, $cnls)) { $this->flash(0, '找不到指定的预订渠道'); } $time = time(); $ydqd = $this->model('order')->fetchAry(array('o_hid = ' . (int) $this->_hostel['h_id'], 'o_cid = ' . (int) $cnid, 'o_etime >= ' . (int) $tmln[0], 'o_etime <= ' . (int) $tmln[1], 'o_status = ' . (int) ORDER_STATUS_YJS)); $this->view->time = $time; $this->view->tmln = $tmln; $this->view->cnid = $cnid; $this->view->cnls = $cnls; $this->view->ydqd = $ydqd; }