{/loop}
</select>
{else}
<select style="font-size: 14px;width:100%;height:30px; color:#2a2a2a; margin-top:10px; margin-left:-5px;" id="tarveldate" name="tarveldate">
<option>暂无价格信息</option>
</select>
{/if}
</div>
</div>
<div class="order-m">
<form action="{$cmsurl}order/create" method="post" name="form1" id="form1">
<input type="hidden" name="id" id="id" value="{$row['id']}">
<input type="hidden" id="ordertype" name="ordertype" value="1" />
<input type="hidden" id="dateid" name="dateid" value="<?php
echo Common::myDate('Y-m-d', $suit[0]['price_arr'][0]['dayid']);
?>
" />
<input type="hidden" id="suitid" name="suitid" value="{$suit[0]['id']}" />
<h3>预定人数{$suit[0]['dingjin']}</h3>
<ul>
<li id="manli">
<label>成人：</label>
<span>
<span class="order-btn minus minus-active" id="plus"></span>
<input type="text" id="dingnum" min="1" max="100" class="order-txt-n" name="dingnum" value="1" />
<input type="hidden" id="price" name="price" value="{intval($suit[0]['price_arr'][0]['adultprice'])}" />
<span class="order-btn plus plus-active" id="minus"></span>
</span>
<span class="order-jg">成人价<em>¥</em><em id="dismanprice">{intval($suit[0]['price_arr'][0]['adultprice'])}</em></span>
</li>
public function action_view()
{
$id = $this->params['id'];
$info = ORM::factory('question', $id)->as_array();
$info['productname'] = $info['questype'] == 0 ? ORM::factory('question')->getProductName($info['productid'], $info['typeid']) : $info['title'];
$info['addtime'] = Common::myDate('Y-m-d', $info['addtime']);
$this->assign('info', $info);
$this->display('stourtravel/question/show');
}
public function action_genexcel()
{
$typeid = $this->params['typeid'];
$timetype = $this->params['timetype'];
$starttime = strtotime(Arr::get($_GET, 'starttime'));
$endtime = strtotime(Arr::get($_GET, 'endtime'));
$status = $_GET['status'];
switch ($timetype) {
case 1:
$time_arr = $this->getTimeRange(1);
break;
case 2:
$time_arr = $this->getTimeRange(2);
break;
case 3:
$time_arr = $this->getTimeRange(3);
break;
case 5:
$time_arr = $this->getTimeRange(5);
break;
case 6:
$time_arr = array($starttime, $endtime);
break;
}
$stime = date('Y-m-d', $time_arr[0]);
$etime = date('Y-m-d', $time_arr[1]);
$w = "addtime>={$time_arr['0']} and addtime<={$time_arr['1']} and typeid='{$typeid}'";
if ($status !== null && $status !== '') {
$w .= " and status={$status}";
}
$arr = ORM::factory('member_order')->where($w)->get_all();
$table = "<table><tr>";
$table .= "<td>订单号</td>";
$table .= "<td>产品名称</td>";
$table .= "<td>预订日期</td>";
$table .= "<td>使用日期</td>";
$table .= "<td>成人数量</td>";
$table .= "<td>成人价格</td>";
if ($typeid == 1) {
$table .= "<td>儿童数量</td>";
$table .= "<td>儿童价格</td>";
$table .= "<td>老人数量</td>";
$table .= "<td>老人价格</td>";
$table .= "<td>保险</td>";
}
$table .= "<td>应付总额</td>";
$table .= "<td>交易状态</td>";
$table .= "<td>预订人</td>";
$table .= "<td>联系电话</td>";
$table .= "<td>使用日期</td>";
$table .= "</tr>";
foreach ($arr as $row) {
$order = $row;
$price = 0;
$insurancePrice = 0;
if ($order['typeid'] != 2) {
$price = intval($order['dingnum']) * $order['price'] + intval($order['childnum']) * $order['childprice'] + intval($order['oldnum']) * $order['oldprice'];
if (!empty($order['usejifen']) && !empty($order['jifentprice'])) {
$price = $price - intval($order['jifentprice']);
//减去积分抵现的价格.
}
} else {
$orderlist = ORM::factory('member_order')->where('pid', '=', $row['id'])->get_all();
$price = 0;
$totalnum = 0;
foreach ($orderlist as $subrow) {
$price += intval($subrow['dingnum']) * intval($subrow['price']);
$totalnum += $subrow['dingnum'];
}
}
if ($order['typeid'] == 1) {
$insInfo = ORM::factory('insurance_booking')->where("bookordersn", '=', $order['ordersn'])->find()->as_array();
if ($insInfo['payprice']) {
$price += $insInfo['payprice'];
$insurancePrice = $insInfo['payprice'];
}
}
$childOrderLabel = $row['pid'] == 0 ? '' : "[子订单]";
$table .= "<tr>";
$table .= "<td>" . $childOrderLabel . "{$row['ordersn']}</td>";
$table .= "<td>{$row['productname']}</td>";
$table .= "<td>" . Common::myDate('Y-m-d H:i:s', $row['addtime']) . "</td>";
$table .= "<td>{$row['usedate']}</td>";
$table .= "<td>{$row['dingnum']}</td>";
$table .= "<td>{$row['price']}</td>";
if ($typeid == 1) {
$table .= "<td>{$row['childnum']}</td>";
$table .= "<td>{$row['childprice']}</td>";
$table .= "<td>{$row['oldnum']}</td>";
$table .= "<td>{$row['oldprice']}</td>";
$table .= "<td>{$insurancePrice}</td>";
}
$table .= "<td>{$price}</td>";
$table .= "<td>" . Model_Member_Order::getStatusName($row['status']) . "</td>";
$table .= "<td>{$row['linkman']}</td>";
$table .= "<td>{$row['linktel']}</td>";
$table .= "<td>{$row['usedate']}</td>";
$table .= "</tr>";
}
$table .= "</table>";
$filename = date('Ymdhis');
header('Pragma:public');
header('Expires:0');
header('Content-Type:charset=utf-8');
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Content-Type:application/force-download');
header('Content-Type:application/vnd.ms-excel');
header('Content-Type:application/octet-stream');
header('Content-Type:application/download');
header('Content-Disposition:attachment;filename=' . $filename . ".xls");
header('Content-Transfer-Encoding:binary');
//define("FILETYPE","xls");
//header("Content-type:application/vnd.ms-excel");
//header('Content-type: charset=GBK');
//header('Pragma: no-cache');
//header('Expires: 0');
//header("Content-Disposition:filename=".$info['name'].".xls");
//$str = iconv("UTF-8//IGNORE","GBK//IGNORE",$str);
if (empty($arr)) {
echo iconv('utf-8', 'gbk', $table);
} else {
echo $table;
}
exit;
}
public function action_index()
{
$action = $this->params['action'];
if (empty($action)) {
$this->display('stourtravel/tools/visit_list');
} else {
if ($action == 'read') {
$start = Arr::get($_GET, 'start');
$limit = Arr::get($_GET, 'limit');
$keyword = Arr::get($_GET, 'keyword');
$sttime = ARR::get($_GET, 'sttime');
$engine = ARR::get($_GET, 'searchengine');
$order = 'order by a.access_time desc';
$w = "where a.id is not null";
if (!empty($keyword)) {
$w .= " and a.keywords like '%{$keyword}%'";
}
if (!empty($sttime)) {
$sttime = strtotime($sttime);
$w .= " and a.access_time >= {$sttime} ";
}
if (!empty($ettime)) {
$ettime = strtotime($ettime);
$w .= " and a.access_time <= {$sttime} ";
}
if (!empty($engine)) {
$w .= " and a.searchengine = '{$engine}'";
}
$sql = "select a.* from sline_stats as a {$w} {$order} limit {$start},{$limit}";
$totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_stats a {$w} ")->execute()->as_array();
$list = DB::query(Database::SELECT, $sql)->execute()->as_array();
$new_list = array();
foreach ($list as $k => $v) {
$v['access_time'] = Common::myDate('Y-m-d H:i:s', $v['access_time']);
$v['searchengine'] = $this->getSearchEngine($v['searchengine']);
$new_list[] = $v;
}
$result['total'] = $totalcount_arr[0]['num'];
$result['lists'] = $new_list;
$result['success'] = true;
echo json_encode($result);
} else {
if ($action == 'save') {
} else {
if ($action == 'delete') {
$rawdata = file_get_contents('php://input');
$data = json_decode($rawdata);
$id = $data->id;
if (is_numeric($id)) {
$model = ORM::factory('stats', $id);
$model->delete();
}
} else {
if ($action == 'update') {
$id = Arr::get($_POST, 'id');
$field = Arr::get($_POST, 'field');
$val = Arr::get($_POST, 'val');
if (is_numeric($id)) {
$model = ORM::factory('stats')->where('id', '=', $id)->find();
}
if ($model->id) {
$model->{$field} = $val;
$model->update();
if ($model->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
}
}
}
}
}
}
public static function rewriteVersion($ver, $beta, $pubdate)
{
$file = Kohana::find_file('data', 'version');
@chmod($file, 0777);
if (!is_writeable($file)) {
echo "版本文件'{$file}'不支持写入，无法更新系统！";
exit;
}
$versiontype = $beta == 1 ? '测试版' : '正式版';
$pubdate = Common::myDate('Y-m-d', strtotime($pubdate));
$fp = fopen($file, 'w');
flock($fp, 3);
fwrite($fp, "<" . "?php\r\n");
fwrite($fp, "\$pcode = 'stourwebcms';\r\n");
fwrite($fp, "\$cVersion ='" . $ver . "';\r\n");
fwrite($fp, "\$versiontype ='" . $versiontype . "';\r\n");
fwrite($fp, "\$pubdate ='" . $pubdate . "';\r\n");
fwrite($fp, "?" . ">");
fclose($fp);
}
public function action_ajax_upgrade()
{
$out = array();
if (!$this->checkdir()) {
$out['status'] = 0;
$out['msg'] = '没有权限操作,请打开网站目录写权限';
//目录无写权限
echo json_encode($out);
exit;
}
if (!$this->checkLicense()) {
$out['status'] = 0;
$out['msg'] = '序列号验证失败,请检查序列号';
//序列号错误
$out['type'] = 'license_err';
echo json_encode($out);
exit;
}
$model = new Model_Upgrade3();
$info = $model->getNewVersion();
if ($info['Success'] == 1) {
if (!empty($info['Data'])) {
include PUBLICPATH . '/vendor/httpdown.class.php';
include PUBLICPATH . '/vendor/pclzip.lib.php';
$versionlist = array_reverse($info['Data']);
$unzippath = BASEPATH;
//解压路径
$savepath = APPPATH . "/data/patch/";
//更新包存储路径
$ver = $versionlist[0];
$downloadurl = $ver['Url'];
$filename = $savepath . $ver['Name'] . '.zip';
$htd = new HttpDown();
//实例化下载类
$htd->OpenUrl($downloadurl);
$ok = $htd->SaveToBin($filename);
if ($ok) {
$archive = new PclZip($filename);
$extractResult = $archive->extract(PCLZIP_OPT_PATH, $unzippath, PCLZIP_CB_PRE_EXTRACT, 'preExtractCallBack', PCLZIP_OPT_REPLACE_NEWER);
if ($extractResult == 0 || $this->exists_extract_error($extractResult)) {
//die("Error : ".$archive->errorInfo(true));
$out['status'] = 0;
$out['msg'] = '升级文件解压失败,请检查目录及子目录是否有写权限';
//目录无写权限
echo json_encode($out);
exit;
} else {
@unlink($filename);
}
//数据库升级
if (file_exists(BASEPATH . '/sql.php')) {
$sqlfile = BASEPATH . '/sql.php';
$url = $GLOBALS['cfg_basehost'] . '/sql.php';
$flag = Common::http($url);
if (strlen($flag) > 3) {
$out['status'] = 0;
$out['msg'] = '数据库升级失败,请检查' . $flag;
//数据库升级有错误,执行失败
echo json_encode($out);
exit;
} else {
@unlink($sqlfile);
}
}
//反馈版本信息
$regstatus = $model->regUpgradeStatus($downloadurl);
//版本包升级成功
if ($regstatus['Success'] == 1) {
//写版本
$pubdate = Common::myDate('Y-m-d', strtotime($ver['ReleaseDate']));
$version = $ver['Version'];
$model->rewriteVersion($version, 0, $pubdate);
//@unlink($filename);
$out['status'] = 1;
$out['currentversion'] = '思途CMS' . $ver['Version'];
echo json_encode($out);
exit;
} else {
$out['status'] = 0;
$out['msg'] = '更新服务器登记版本失败!';
echo json_encode($out);
exit;
}
} else {
$out['status'] = 0;
$out['msg'] = '下载升级包失败!';
echo json_encode($out);
exit;
}
} else {
$out['status'] = 0;
$out['msg'] = '此版本为官方内测版本,不能升级!';
echo json_encode($out);
exit;
}
} else {
$out['status'] = 0;
$out['msg'] = '获取新版本信息失败!';
echo json_encode($out);
exit;
}
}
public function action_article()
{
$action = $this->params['action'];
if (empty($action)) {
$this->assign('kindmenu', Common::getConfig('menu_sub.articlekind'));
//分类设置项
$this->display('stourtravel/article/list');
} else {
if ($action == 'read') {
$start = Arr::get($_GET, 'start');
$limit = Arr::get($_GET, 'limit');
$keyword = Arr::get($_GET, 'keyword');
$kindid = Arr::get($_GET, 'kindid');
$attrid = Arr::get($_GET, 'attrid');
$webid = Arr::get($_GET, 'webid');
$webid = $webid == "" ? -1 : $webid;
$keyword = Common::getKeyword($keyword);
$sort = json_decode(Arr::get($_GET, 'sort'), true);
$order = 'order by a.modtime desc';
$specOrders = array('attrid', 'kindlist', 'iconlist', 'themelist');
if ($sort[0]['property']) {
if ($sort[0]['property'] == 'displayorder') {
$prefix = '';
} else {
if ($sort[0]['property'] == 'ishidden') {
$prefix = 'a.';
} else {
if ($sort[0]['property'] == 'templet') {
$prefix = 'a.';
} else {
if ($sort[0]['property'] == 'modtime') {
$prefix = 'a.';
} else {
if (in_array($sort[0]['property'], $specOrders)) {
$prefix = 'order_';
}
}
}
}
}
$order = 'order by ' . $prefix . $sort[0]['property'] . ' ' . $sort[0]['direction'] . ',a.modtime desc';
}
$w = "a.id is not null";
$w .= empty($keyword) ? '' : " and a.title like '%{$keyword}%'";
$w .= empty($kindid) ? '' : " and find_in_set({$kindid},a.kindlist)";
$w .= empty($attrid) ? '' : " and find_in_set({$attrid},a.attrid)";
$w .= $webid == '-1' ? '' : " and a.webid={$webid}";
if (empty($kindid)) {
$sql = "select a.id,a.aid,a.title,a.attrid,a.kindlist,a.webid,a.addtime,a.ishidden,a.themelist,a.iconlist,if(length(ifnull(a.attrid,''))=0,0,1) as order_attrid,if(length(ifnull(a.kindlist,''))=0,0,1) as order_kindlist,if(length(ifnull(a.iconlist,''))=0,0,1) as order_iconlist,if(length(ifnull(a.themelist,''))=0,0,1) as order_themelist,\nb.isjian,ifnull(b.displayorder,999999) as displayorder,b.isding,a.modtime,a.templet from sline_article as a left join sline_allorderlist b on (a.id=b.aid and b.typeid=4) where {$w} {$order} limit {$start},{$limit}";
} else {
$sql = "select a.id,a.aid,a.title,a.attrid,a.kindlist,a.webid,a.addtime,a.ishidden,a.themelist,a.iconlist,if(length(ifnull(a.attrid,''))=0,0,1) as order_attrid,if(length(ifnull(a.kindlist,''))=0,0,1) as order_kindlist,if(length(ifnull(a.iconlist,''))=0,0,1) as order_iconlist,if(length(ifnull(a.themelist,''))=0,0,1) as order_themelist,b.isjian,b.displayorder,b.isding,a.modtime,a.templet from sline_article as a left join sline_kindorderlist as b on (b.classid={$kindid} and a.id=b.aid and b.typeid=4) where {$w} {$order} limit {$start},{$limit}";
}
$totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_article a where {$w}")->execute()->as_array();
$list = DB::query(Database::SELECT, $sql)->execute()->as_array();
$new_list = array();
foreach ($list as $k => $v) {
$v['kindname'] = Model_Destinations::getKindnameList($v['kindlist']);
$v['attrname'] = Model_Article_Attr::getAttrnameList($v['attrid']);
$v['modtime'] = Common::myDate('Y-m-d', $v['modtime']);
$v['url'] = Common::getBaseUrl($v['webid']) . '/raiders/show_' . $v['aid'] . '.html';
$new_list[] = $v;
}
$result['total'] = $totalcount_arr[0]['num'];
$result['lists'] = $new_list;
$result['success'] = true;
echo json_encode($result);
} else {
if ($action == 'save') {
} else {
if ($action == 'delete') {
$rawdata = file_get_contents('php://input');
$data = json_decode($rawdata);
$id = $data->id;
if (is_numeric($id)) {
$model = ORM::factory('article', $id);
$model->deleteClear();
}
} else {
if ($action == 'update') {
$id = Arr::get($_POST, 'id');
$field = Arr::get($_POST, 'field');
$val = Arr::get($_POST, 'val');
$kindid = Arr::get($_POST, 'kindid');
if ($field == 'displayorder') {
$displayorder = empty($val) ? 9999 : $val;
if (is_numeric($id)) {
if (empty($kindid)) {
$order = ORM::factory('allorderlist');
$order_mod = $order->where("aid='{$id}' and typeid=4 and webid=0")->find();
if ($order_mod->id) {
$order_mod->displayorder = $displayorder;
} else {
$order_mod->displayorder = $displayorder;
$order_mod->aid = $id;
$order_mod->webid = 0;
$order_mod->typeid = 4;
}
$order_mod->save();
if ($order_mod->saved()) {
echo 'ok';
} else {
echo 'no';
}
} else {
Common::debug('here');
$kindorder = ORM::factory('kindorderlist');
$kindorder_mod = $kindorder->where("aid='{$id}' and typeid=4 and classid={$kindid}")->find();
if ($kindorder_mod->id) {
$kindorder_mod->displayorder = $displayorder;
} else {
$kindorder_mod->displayorder = $displayorder;
$kindorder_mod->aid = $id;
$kindorder_mod->classid = $kindid;
$kindorder_mod->typeid = 4;
}
$kindorder_mod->save();
if ($kindorder->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
}
} else {
if (is_numeric($id)) {
$model = ORM::factory('article', $id);
}
if ($model->id) {
$model->{$field} = $val;
if ($field == 'kindlist') {
$model->{$field} = implode(',', Model_Destinations::getParentsStr($val));
} else {
if ($field == 'attrid') {
$model->{$field} = implode(',', Model_Attrlist::getParentsStr($val, 4));
}
}
$model->save();
if ($model->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
}
}
}
}
}
}
}
public function action_index()
{
$action = $this->params['action'];
if (empty($action)) {
$this->display('stourtravel/member/list');
} else {
if ($action == 'read') {
$start = Arr::get($_GET, 'start');
$limit = Arr::get($_GET, 'limit');
$keyword = Arr::get($_GET, 'keyword');
$order = 'order by a.jointime desc';
if (!empty($keyword)) {
$w = "where (a.nickname like '%{$keyword}%' or a.email like '%{$keyword}%' or a.mobile like '%{$keyword}%')";
}
$sql = "select a.* from sline_member as a {$w} {$order} limit {$start},{$limit}";
//echo $sql;
$totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_member a ")->execute()->as_array();
$list = DB::query(Database::SELECT, $sql)->execute()->as_array();
$new_list = array();
foreach ($list as $k => $v) {
$v['logintime'] = Common::myDate('Y-m-d', $v['logintime']);
$v['id'] = $v['mid'];
$new_list[] = $v;
}
$result['total'] = $totalcount_arr[0]['num'];
$result['lists'] = $new_list;
$result['success'] = true;
echo json_encode($result);
} else {
if ($action == 'save') {
} else {
if ($action == 'delete') {
$rawdata = file_get_contents('php://input');
$data = json_decode($rawdata);
$id = $data->id;
if (is_numeric($id)) {
$model = ORM::factory('member', $id);
$model->delete();
}
} else {
if ($action == 'update') {
$id = Arr::get($_POST, 'id');
$field = Arr::get($_POST, 'field');
$val = Arr::get($_POST, 'val');
if (is_numeric($id)) {
$model = ORM::factory('member')->where('mid', '=', $id)->find();
}
if ($model->mid) {
$model->{$field} = $val;
$model->update();
if ($model->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
}
}
}
}
}
}
/**
* 生成格式化的数据
* 用于日历中进行呈现
* @param $arr
*/
public function getSuitPriceArr($year, $month, $suitid, $typeid)
{
$start = strtotime("{$year}-{$month}-1");
$end = strtotime("{$year}-{$month}-31");
$table = self::$priceTableArr[$typeid];
$arr = ORM::factory($table)->where('suitid', '=', $suitid)->and_where('day', '>=', $start)->and_where('day', '<=', $end)->get_all();
$price = array();
foreach ($arr as $row) {
if ($row) {
$day = $row['day'];
$price[$day]['date'] = Common::myDate('Y-m-d', $row['day']);
$price[$day]['basicprice'] = isset($row['adultbasicprice']) ? $row['adultbasicprice'] : $row['basicprice'];
$price[$day]['profit'] = isset($row['adultprofit']) ? $row['adultprofit'] : $row['profit'];
$price[$day]['price'] = isset($row['adultprice']) ? $row['adultprice'] : $row['price'];
$price[$day]['child_basicprice'] = isset($row['childbasicprice']) ? $row['childbasicprice'] : 0;
$price[$day]['child_profit'] = isset($row['childprofit']) ? $row['childprofit'] : 0;
$price[$day]['child_price'] = isset($row['childprice']) ? $row['childprice'] : 0;
$price[$day]['old_basicprice'] = isset($row['oldbasicprice']) ? $row['oldbasicprice'] : 0;
$price[$day]['old_profit'] = isset($row['oldprofit']) ? $row['oldprofit'] : 0;
$price[$day]['old_price'] = isset($row['oldprice']) ? $row['oldprice'] : 0;
$price[$day]['suitid'] = $suitid;
$price[$day]['number'] = $row['number'];
//库存
$price[$day]['description'] = $row['description'];
//描述
if ($typeid == 1) {
$price[$day]['roombalance'] = $row['roombalance'];
}
}
}
return $price;
}
public function action_index()
{
$action = $this->params['action'];
$typeid = $this->typeid;
if (empty($action)) {
$this->assign('kindmenu', self::$kind);
//分类设置项
$this->display('stourtravel/tongyong/list');
} else {
if ($action == 'read') {
$start = Arr::get($_GET, 'start');
$limit = Arr::get($_GET, 'limit');
$keyword = Arr::get($_GET, 'keyword');
$kindid = Arr::get($_GET, 'kindid');
$attrid = Arr::get($_GET, 'attrid');
$webid = Arr::get($_GET, 'webid');
$webid = empty($webid) ? 0 : $webid;
$keyword = Common::getKeyword($keyword);
$sort = json_decode(Arr::get($_GET, 'sort'), true);
$order = 'order by a.modtime desc';
$specOrders = array('attrid', 'kindlist', 'iconlist', 'themelist');
if ($sort[0]['property']) {
if ($sort[0]['property'] == 'displayorder') {
$prefix = 'b.';
} else {
if ($sort[0]['property'] == 'ishidden') {
$prefix = 'a.';
} else {
if ($sort[0]['property'] == 'addtime') {
$prefix = 'a.';
} else {
if (in_array($sort[0]['property'], $specOrders)) {
$prefix = 'order_';
}
}
}
}
$order = 'order by ' . $prefix . $sort[0]['property'] . ' ' . $sort[0]['direction'] . ',a.modtime desc';
}
$w = "a.typeid='{$typeid}'";
$w .= empty($keyword) ? '' : " and a.title like '%{$keyword}%'";
$w .= empty($kindid) ? '' : " and find_in_set({$kindid},a.kindlist)";
$w .= empty($attrid) ? '' : " and find_in_set({$attrid},a.attrid)";
$w .= $webid == '-1' ? '' : " and a.webid={$webid}";
if (empty($kindid)) {
$sql = "select a.*,b.displayorder,if(length(ifnull(a.attrid,''))=0,0,1) as order_attrid,if(length(ifnull(a.kindlist,''))=0,0,1) as order_kindlist,if(length(ifnull(a.iconlist,''))=0,0,1) as order_iconlist,if(length(ifnull(a.themelist,''))=0,0,1) as order_themelist from sline_model_archive as a left join sline_allorderlist b on (a.id=b.aid and b.typeid='{$typeid}') where {$w} {$order}";
} else {
$sql = "select a.*,b.displayorder,if(length(ifnull(a.attrid,''))=0,0,1) as order_attrid,if(length(ifnull(a.kindlist,''))=0,0,1) as order_kindlist,if(length(ifnull(a.iconlist,''))=0,0,1) as order_iconlist,if(length(ifnull(a.themelist,''))=0,0,1) as order_themelist from sline_model_archive as a left join sline_kindorderlist as b on (b.classid={$kindid} and a.id=b.aid and b.typeid='{$typeid}') where {$w} {$order} ";
}
$total = DB::query(1, $sql)->execute();
$sql .= " limit {$start},{$limit}";
$list = DB::query(1, $sql)->execute()->as_array();
$new_list = array();
$moduleinfo = Model_Model::getModuleInfo($typeid);
foreach ($list as $k => $v) {
$v['kindname'] = Model_Destinations::getKindnameList($v['kindlist']);
$v['attrname'] = Model_Article_Attr::getAttrnameList($v['attrid']);
$v['modtime'] = Common::myDate('Y-m-d', $v['modtime']);
$v['modulepinyin'] = $moduleinfo['pinyin'];
$iconname = Model_Icon::getIconName($v['iconlist']);
$name = '';
foreach ($iconname as $icon) {
if (!empty($icon)) {
$name .= '<span style="color:red">[' . $icon . ']</span>';
}
}
$v['iconname'] = $name;
$v['series'] = Common::getSeries($v['id'], $typeid);
//编号
//供应商信息
$supplier = ORM::factory('supplier')->where("id='{$v['supplierlist']}'")->find()->as_array();
$v['suppliername'] = $supplier['suppliername'];
$v['linkman'] = $supplier['linkman'];
$v['mobile'] = $supplier['mobile'];
$v['address'] = $supplier['address'];
$v['qq'] = $supplier['qq'];
//套餐信息
$homes = ORM::factory('model_suit')->where("productid", '=', $v['id'])->get_all();
//读取套餐
if (!empty($homes)) {
$v['tr_class'] = 'parent-product-tr';
}
$new_list[] = $v;
foreach ($homes as $key => $val) {
$val['title'] = $val['suitname'];
$val['suitid'] = $val['id'];
$val['id'] = 'suit_' . $val['id'];
$val['productid'] = $val['productid'];
$val['sellprice'] = $val['sellprice'];
$val['ourprice'] = $val['ourprice'];
if ($key != count($homes) - 1) {
$val['tr_class'] = 'suit-tr';
}
$new_list[] = $val;
}
}
$result['total'] = $total->count();
$result['lists'] = $new_list;
$result['success'] = true;
echo json_encode($result);
} else {
if ($action == 'save') {
} else {
if ($action == 'delete') {
$rawdata = file_get_contents('php://input');
$data = json_decode($rawdata);
$id = $data->id;
if (is_numeric($id)) {
$model = ORM::factory('model_archive', $id);
$model->delete();
} else {
if (strpos($id, 'suit') !== FALSE) {
$suitid = substr($id, strpos($id, '_') + 1);
$suit = ORM::factory('model_suit', $suitid);
$suit->delete();
}
}
} else {
if ($action == 'update') {
$id = Arr::get($_POST, 'id');
$field = Arr::get($_POST, 'field');
$val = Arr::get($_POST, 'val');
$kindid = Arr::get($_POST, 'kindid');
if ($field == 'displayorder') {
$displayorder = empty($val) ? 9999 : $val;
if (is_numeric($id)) {
if (empty($kindid)) {
$order = ORM::factory('allorderlist');
$order_mod = $order->where("aid='{$id}' and typeid='{$typeid}' and webid=0")->find();
if ($order_mod->id) {
$order_mod->displayorder = $displayorder;
} else {
$order_mod->displayorder = $displayorder;
$order_mod->aid = $id;
$order_mod->webid = 0;
$order_mod->typeid = $typeid;
}
$order_mod->save();
if ($order_mod->saved()) {
echo 'ok';
} else {
echo 'no';
}
} else {
$kindorder = ORM::factory('kindorderlist');
$kindorder_mod = $kindorder->where("aid='{$id}' and typeid={$typeid} and classid={$kindid}")->find();
if ($kindorder_mod->id) {
$kindorder_mod->displayorder = $displayorder;
} else {
$kindorder_mod->displayorder = $displayorder;
$kindorder_mod->aid = $id;
$kindorder_mod->classid = $kindid;
$kindorder_mod->typeid = $typeid;
}
$kindorder_mod->save();
if ($kindorder->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
} else {
if (strpos($id, 'suit') !== FALSE) {
$suitid = substr($id, strpos($id, '_') + 1);
$suit = ORM::factory('model_suit', $suitid);
$suit->displayorder = $displayorder;
if ($suit->id) {
$suit->save();
if ($suit->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
}
}
} else {
if (is_numeric($id)) {
$model = ORM::factory('model_archive', $id);
} else {
if (strpos($id, 'suit') !== FALSE) {
$suitid = substr($id, strpos($id, '_') + 1);
$model = ORM::factory('model_suit', $suitid);
}
}
if ($model->id) {
$model->{$field} = $val;
if ($field == 'kindlist') {
$model->{$field} = implode(',', Model_Destinations::getParentsStr($val));
} else {
if ($field == 'attrid') {
$model->{$field} = implode(',', Model_Attrlist::getParentsStr($val, $typeid));
}
}
$model->save();
if ($model->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
}
}
}
}
}
}
}
public function action_list()
{
$action = $this->params['action'];
if (empty($action)) {
$posArr = $this->geneHtmlPosarr();
$this->assign('posArr', $posArr);
$kindlist = json_encode(ORM::factory('help_kind')->where("webid=0")->get_all());
$this->assign('kindmenu', Common::getConfig('menu_sub.helpkind'));
//分类设置项
$this->assign('kindlist', $kindlist);
$this->display('stourtravel/help/list');
} else {
if ($action == 'read') {
$start = Arr::get($_GET, 'start');
$limit = Arr::get($_GET, 'limit');
$keyword = Arr::get($_GET, 'keyword');
$kindid = Arr::get($_GET, 'kindid');
$sort = json_decode(Arr::get($_GET, 'sort'), true);
if ($sort[0]['property']) {
//print_r($sort[0]->property);
if ($sort[0]['property'] == 'displayorder') {
$order = 'order by displayorder ' . $sort[0]['direction'];
} else {
if ($sort[0]['property'] == 'modtime') {
$order = 'order by modtime ' . $sort[0]['direction'];
}
}
} else {
$order = 'order by modtime desc';
}
$w = "id is not null";
$w .= empty($keyword) ? '' : " and title like '%{$keyword}%'";
$w .= empty($kindid) ? '' : " and kindid={$kindid}";
$sql = "select *,ifnull(displayorder,9999) as displayorder from sline_help where {$w} {$order} limit {$start},{$limit} ";
$totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_help where {$w}")->execute()->as_array();
$list = DB::query(Database::SELECT, $sql)->execute()->as_array();
foreach ($list as $k => $v) {
$list[$k]['modtime'] = Common::myDate('Y-m-d', $list[$k]['modtime']);
}
$result['total'] = $totalcount_arr[0]['num'];
$result['lists'] = $list;
$result['success'] = true;
echo json_encode($result);
} else {
if ($action == 'save') {
} else {
if ($action == 'delete') {
$rawdata = file_get_contents('php://input');
$data = json_decode($rawdata);
$id = $data->id;
if (is_numeric($id)) {
$model = ORM::factory('help', $id);
$model->deleteClear();
}
} else {
if ($action == 'update') {
$id = Arr::get($_POST, 'id');
$field = Arr::get($_POST, 'field');
$val = Arr::get($_POST, 'val');
$model = ORM::factory('help', $id);
$model->{$field} = $val;
$model->save();
if ($model->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
}
}
}
}
}
public function action_index()
{
$action = $this->params['action'];
$typeid = 11;
if (empty($action)) {
$this->assign('kindmenu', Common::getConfig('menu_sub.jiebankind'));
//分类设置项
$this->display('stourtravel/jieban/list');
} else {
if ($action == 'read') {
$start = Arr::get($_GET, 'start');
$limit = Arr::get($_GET, 'limit');
$kindid = Arr::get($_GET, 'kindid');
$attrid = Arr::get($_GET, 'attrid');
$sort = json_decode(Arr::get($_GET, 'sort'), true);
$order = 'order by a.addtime desc';
$specOrders = array('attrid', 'kindlist', 'iconlist', 'themelist');
if ($sort[0]['property']) {
if ($sort[0]['property'] == 'displayorder') {
$prefix = '';
} else {
if ($sort[0]['property'] == 'ishidden') {
$prefix = 'a.';
} else {
if (in_array($sort[0]['property'], $specOrders)) {
$prefix = 'order_';
}
}
}
$order = 'order by ' . $prefix . $sort[0]['property'] . ' ' . $sort[0]['direction'] . ',a.addtime desc';
}
$w = "a.id is not null";
$w .= empty($kindid) ? '' : " and find_in_set({$kindid},a.kindlist)";
$w .= empty($attrid) ? '' : " and find_in_set({$attrid},a.attrid)";
$sql = "select a.*,if(length(ifnull(a.attrid,''))=0,0,1) as order_attrid,if(length(ifnull(a.kindlist,''))=0,0,1) as order_kindlist,if(length(ifnull(a.iconlist,''))=0,0,1) as order_iconlist,ifnull(b.displayorder,9999) as displayorder from sline_jieban as a left join sline_allorderlist b on (a.id=b.aid and b.typeid={$typeid}) where {$w} {$order} limit {$start},{$limit}";
$totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_jieban a where {$w}")->execute()->as_array();
$list = DB::query(Database::SELECT, $sql)->execute()->as_array();
$new_list = array();
foreach ($list as $k => $v) {
$v['kindname'] = Model_Destinations::getKindnameList($v['kindlist']);
$v['attrname'] = Model_Jieban_Attr::getAttrnameList($v['attrid']);
$v['title'] = Model_Jieban::genTitle($v, $v['day']);
$memberinfo = ORM::factory('member', $v['memberid'])->as_array();
$v['membername'] = $memberinfo['nickname'];
$v['membermobile'] = $memberinfo['mobile'];
$v['joinnum'] = Model_Jieban::getJoinNum($v['id']);
$iconname = Model_Icon::getIconName($v['iconlist']);
$name = '';
foreach ($iconname as $icon) {
if (!empty($icon)) {
$name .= '<span style="color:red">[' . $icon . ']</span>';
}
}
$v['iconname'] = $name;
$v['series'] = Common::getSeries($v['id'], $typeid);
//编号
$v['addtime'] = Common::myDate('Y-m-d', $v['addtime']);
$new_list[] = $v;
}
$result['total'] = $totalcount_arr[0]['num'];
$result['lists'] = $new_list;
$result['success'] = true;
echo json_encode($result);
} else {
if ($action == 'save') {
} else {
if ($action == 'delete') {
$rawdata = file_get_contents('php://input');
$data = json_decode($rawdata);
$id = $data->id;
if (is_numeric($id)) {
$model = ORM::factory('jieban', $id);
$model->delete();
}
} else {
if ($action == 'update') {
$id = Arr::get($_POST, 'id');
$field = Arr::get($_POST, 'field');
$val = Arr::get($_POST, 'val');
$kindid = Arr::get($_POST, 'kindid');
if ($field == 'displayorder') {
$displayorder = empty($val) ? 9999 : $val;
if (is_numeric($id)) {
if (empty($kindid)) {
$order = ORM::factory('allorderlist');
$order_mod = $order->where("aid='{$id}' and typeid={$typeid} and webid=0")->find();
if ($order_mod->id) {
$order_mod->displayorder = $displayorder;
} else {
$order_mod->displayorder = $displayorder;
$order_mod->aid = $id;
$order_mod->webid = 0;
$order_mod->typeid = 11;
}
$order_mod->save();
if ($order_mod->saved()) {
echo 'ok';
} else {
echo 'no';
}
} else {
}
}
} else {
if (is_numeric($id)) {
$model = ORM::factory('jieban', $id);
}
if ($model->id) {
$model->{$field} = $val;
if ($field == 'kindlist') {
$model->{$field} = implode(',', Model_Destinations::getParentsStr($val));
} else {
if ($field == 'attrid') {
$model->{$field} = implode(',', Model_Attrlist::getParentsStr($val, 11));
}
}
$model->save();
if ($model->saved()) {
echo 'ok';
} else {
echo 'no';
}
}
}
}
}
}
}
}
}
