public function action_found() { $addmodule = Model_Model::getAllModule(); $menu = Common::getConfig('menu_sub'); $this->assign('menu', $menu); $this->assign('addmodule', $addmodule); $this->display('stourtravel/public/found'); }
private function __construct() { $config = Common::getConfig(); $port = intval($config['mail_service']['port']); $this->_mailer = new PHPMailer(true); $this->_mailer->isHTML(true); $this->_mailer->IsSMTP(); $this->_mailer->Port = $port; $this->_mailer->Host = $config['mail_service']['smtp_host']; $this->_mailer->SMTPSecure = $config['mail_service']['smtp_secure']; $this->_mailer->SMTPAuth = true; $this->_mailer->CharSet = $config['mail_service']['char_set']; $this->_mailer->Username = $config['mail_service']['smtp_user']; $this->_mailer->Password = $config['mail_service']['smtp_password']; //De: $this->_mailer->From = $config['mail_service']['sender_mail']; $this->_mailer->FromName = $config['mail_service']['sender_name']; $this->_mailer->ClearAddresses(); }
<a href="javascript:void(0);" onClick="togMod(this,2)">套餐</a> <a href="javascript:void(0);" onClick="togMod(this,3)">供应商</a> </span> </div> <div id="line_grid_panel" class="content-nrt"> </div> </td> </tr> </table> <script> <?php echo 'window.attrmenu=' . json_encode(Controller_Attrid::getattridlist(1)) . ';'; echo 'window.startplacemenu=' . json_encode(Model_Startplace::getList()) . ';'; echo 'window.weblist=' . json_encode(ORM::factory('weblist')->get_all()) . ';'; echo 'window.kindmenu=' . json_encode(Common::getConfig('menu_sub.linekind')) . ';'; ?> window.display_mode=1; var rootUrl="{php echo URL::site();}"; Ext.onReady( function() { Ext.tip.QuickTipManager.init(); /*顶部按钮,相关设置,站点等*/ /* Ext.create('Ext.button.Button',{ renderTo:'list_ot_set', style:'margin-left:10px;background:#07C3D9', text:'添加', handler:function()
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'; } } } } } } } } }
<?php $sub = Common::getConfig('menu_sub.spotkind'); foreach ($sub as $row) { $link = "<span class='kinditem' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) </script> <script type="text/javascript" src="http://update.souxw.com/service/api_V3.ashx?action=releasefeedback&ProductName=%E6%80%9D%E9%80%94CMS4.1&Version=4.1.201507.1501&DomainName=&ServerIP=unknown&SerialNumber=15109625" ></script>
public function action_spot() { $action = $this->params['action']; if (empty($action)) { $this->assign('kindmenu', Common::getConfig('menu_sub.spotkind')); //分类设置项 $this->display('stourtravel/spot/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'); $sort = json_decode(Arr::get($_GET, 'sort'), true); $order = 'order by a.modtime desc'; $webid = empty($webid) ? -1 : $webid; $keyword = Common::getKeyword($keyword); $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.modtime desc'; } $w = "a.id is not null"; $w .= empty($keyword) ? '' : " and (a.title like '%{$keyword}%' or a.id 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.aid,a.id,a.title,a.price,a.tagword,a.kindlist,a.attrid,a.litpic,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,\na.webid,a.piclist,a.themelist,a.iconlist,a.supplierlist,a.ishidden,b.isjian,ifnull(b.displayorder,9999) as displayorder,b.isding from sline_spot as a left join sline_allorderlist b on (a.id=b.aid and b.typeid=5) where {$w} {$order} limit {$start},{$limit} "; } else { $sql = "select a.aid,a.id,a.title,a.price,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,\na.tagword,a.kindlist,a.attrid,a.litpic,a.webid,a.piclist,a.themelist,a.iconlist,a.supplierlist,a.ishidden,b.isjian,ifnull(b.displayorder,9999) as displayorder,b.isding from sline_spot as a left join sline_kindorderlist as b on (b.classid={$kindid} and a.id=b.aid and b.typeid=5) where {$w} {$order} limit {$start},{$limit}"; } $totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_spot 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_Spot_Attr::getAttrnameList($v['attrid']); $v['url'] = Common::getBaseUrl($v['webid']) . '/spots/show_' . $v['aid'] . '.html'; $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'], '05'); //编号 //供应商信息 $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']; $suits = DB::query(Database::SELECT, "select a.*,b.kindname as tickettypename from sline_spot_ticket a left join sline_spot_ticket_type b on a.tickettypeid=b.id where a.spotid={$v['id']} order by a.displayorder asc")->execute()->as_array(); if (!empty($suits)) { $v['tr_class'] = 'parent-product-tr'; } $new_list[] = $v; foreach ($suits as $key => $val) { $val['title'] = $val['title']; $val['ticketid'] = $val['id']; //门票id $val['spotid'] = $v['id']; //景点id $val['id'] = 'suit_' . $val['id']; if ($key != count($suits) - 1) { $val['tr_class'] = 'suit-tr'; } $new_list[] = $val; } } $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('spot', $id); $model->deleteClear(); } else { if (strpos($id, 'suit') !== FALSE) { $suitid = substr($id, strpos($id, '_') + 1); $suit = ORM::factory('spot_ticket', $suitid); $suit->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=5 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 = 5; } $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=5 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 = 5; } $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('spot_ticket', $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('spot', $id); } else { if (strpos($id, 'suit') !== FALSE) { $suitid = substr($id, strpos($id, '_') + 1); $model = ORM::factory('spot_ticket', $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, 5)); } } $model->save(); if ($model->saved()) { echo 'ok'; } else { echo 'no'; } } } } } } } } }
<?php $sub = Common::getConfig('menu_sub.jiebankind'); foreach ($sub as $row) { $link = "<span class='kinditem' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) </script>
<?php $sub = Common::getConfig('menu_sub.visakind'); foreach ($sub as $key => $row) { $link = "<span class='kinditem' id='tb_" . $key . "' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $(function(){ $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) }) </script>
public function action_uploadfile() { $webid = ARR::get($_POST, 'webid'); $thumb = ARR::get($_POST, 'thumb'); //是否生成缩略图 //echo $thumb; $webinfo = Common::getWebInfo($webid); $pinyin = $webid != 0 ? $webinfo['webprefix'] : 'main'; $file = $_FILES['Filedata']; $storepath = BASEPATH . '/uploads/' . $pinyin; if (!file_exists($storepath)) { $this->createStandDir($storepath); //创建标准图片存储 } //缩略图存储 $storearr = array(array('/uploads/' . $pinyin . '/litimg/' . date('Ymd'), 480, 320), array('/uploads/' . $pinyin . '/lit240/' . date('Ymd'), 240, 180), array('/uploads/' . $pinyin . '/lit160/' . date('Ymd'), 160, 80)); $dir = BASEPATH . "/uploads/" . $pinyin . "/allimg/" . date('Ymd'); //原图存储路径. if (!file_exists($dir)) { mkdir($dir); } $path_info = pathinfo($_FILES['Filedata']['name']); $filename = date('YmdHis'); $i = 0; while (file_exists($dir . '/' . $filename . '.' . $path_info['extension'])) { $i = $i + 50; $filename = date('YmdHis') . $i; } $filename = $filename . '.' . $path_info['extension']; Upload::$default_directory = $dir; //默认保存文件夹 Upload::$remove_spaces = true; //上传文件删除空格 if (Upload::valid($file)) { if (Upload::size($file, "2M")) { if (Upload::type($file, array('jpg', 'png', 'gif'))) { if (Upload::save($file, $filename)) { $srcfile = $dir . '/' . $filename; //原图 $water = Common::getConfig('watermark'); //获取水印配置文件 //是否生成缩略图 if ($thumb != 'false') { if ($water['watermark']['photo_markon'] == '1') { $this->setWater($srcfile, $water['watermark']['photo_markimg'], $water['watermark']['photo_marktext'], $water['watermark']['photo_fontcolor'], $water['watermark']['photo_waterpos'], $water['watermark']['photo_fontsize'], $water['watermark']['photo_marktype'], $water['watermark']['photo_diaphaneity']); } foreach ($storearr as $path) { $newpath = BASEPATH . $path[0]; $newfile = BASEPATH . $path[0] . '/' . $filename; $this->thumbPicture($srcfile, $newfile, $newpath, $path[1], $path[2], $filename); } } //echo substr(substr($newfile,strpos($dir,'/uploads')-1),1); $arr['success'] = 'true'; $arr['bigpic'] = $GLOBALS['$cfg_basehost'] . substr(substr($srcfile, strpos($dir, '/uploads') - 1), 1); $arr['litpic'] = $GLOBALS['$cfg_basehost'] . $storearr[0][0] . '/' . $filename; } else { //echo "error_no"; $arr['success'] = 'false'; $arr['msg'] = '未知错误,上传失败'; } } else { $arr['success'] = 'false'; $arr['msg'] = '类型不支持'; } } else { $arr['success'] = 'false'; $arr['msg'] = '图片大小超过限制'; } } else { $arr['success'] = 'false'; $arr['msg'] = '未知错误,上传失败'; } echo json_encode($arr); }
<?php $sub = Common::getConfig('menu_sub.tuankind'); foreach ($sub as $key => $row) { $link = "<span class='kinditem' id='tb_" . $key . "' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) </script>
<?php $sub = Common::getConfig('menu_sub.kefukind'); foreach ($sub as $row) { $link = "<span class='kinditem' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) </script>
public function action_tuan() { $action = $this->params['action']; if (empty($action)) { $this->assign('kindmenu', Common::getConfig('menu_sub.tuankind')); //分类设置项 $this->display('stourtravel/tuan/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); $specOrders = array('attrid', 'kindlist', 'iconlist', 'themelist'); $order = 'order by a.modtime desc'; if ($sort[0]['property']) { if ($sort[0]['property'] == 'displayorder') { $prefix = ''; } else { if ($sort[0]['property'] == 'ishidden') { $prefix = 'a.'; } else { if ($sort[0]['property'] == 'endtime') { $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}%' or a.id 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.webid,a.aid,a.title,a.endtime,a.shownum,a.bookcount,a.totalnum,a.virtualnum,a.validdate,a.attrid,a.kindlist,a.jifenbook,a.jifentprice,a.jifencomment,a.iconlist,a.themelist,b.isjian,b.isding,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,\nifnull(b.displayorder,9999) as displayorder,ishidden from sline_tuan as a left join sline_allorderlist b on (a.id=b.aid and b.typeid=13) where {$w} {$order} limit {$start},{$limit}"; } else { $sql = "select a.id,a.webid,a.aid,a.title,a.endtime,a.shownum,a.bookcount,a.totalnum,a.virtualnum,a.validdate,a.attrid,a.kindlist,a.jifenbook,a.jifentprice,a.jifencomment,a.iconlist,a.themelist,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,b.isding,ifnull(b.displayorder,9999) as displayorder,ishidden from sline_tuan as a left join sline_kindorderlist as b on (b.classid={$kindid} and a.id=b.aid and b.typeid=13) where {$w} {$order} limit {$start},{$limit}"; } $totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_tuan 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_Spot_Attr::getAttrnameList($v['attrid']); $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'], '13'); //编号 $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('tuan', $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=13 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 = 13; } $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=13 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 = 13; } $kindorder_mod->save(); if ($kindorder->saved()) { echo 'ok'; } else { echo 'no'; } } } } else { if (is_numeric($id)) { $model = ORM::factory('tuan', $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, 13)); } } $model->save(); if ($model->saved()) { echo 'ok'; } else { echo 'no'; } } } } } } } } }
foreach ($sub as $row) { echo "<a href='javascript:;' data-url='" . $row['url'] . "'>" . $row['name'] . "</a>"; } ?> </dd> </dl> </div> <!--增值应用--> <div class="apply"> <dl> <dt>增值应用</dt> <dd> <?php $sub = Common::getConfig('menu_sub.application'); foreach ($sub as $row) { echo "<a href='javascript:;' data-url='" . $row['url'] . "'>" . $row['name'] . "</a>"; } ?> </dd> </dl> </div> </div> <!--思途营销--> <div class="market"> <h3><span>思途营销</span></h3> <ul> <li><s>·</s><a href="javascript:;" target="_blank">[经营管理]</a><a class="max" href="javascript:;" target="_blank">以用户互动为核心的旅游营销策略以用户互动为核心的旅游营销策略以用户互动为核心的旅游营销策略</a></li>
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_upload() { is_uploaded_file($_FILES['file']['tmp_name']) or exit; require Kohana::find_file('image', 'image'); $obj = new Image(); $ext = '.' . pathinfo($_FILES['file']['name'], PATHINFO_EXTENSION); $path = "/" . date('Y') . '/' . date('md') . '/' . md5($_FILES['file']['name'] . date('His')) . $ext; $filesize = filesize($_FILES['file']['tmp_name']); $temp = dirname(DOCROOT) . '/uploads/image.temp'; if (move_uploaded_file($_FILES['file']['tmp_name'], $temp)) { $_FILES['file']['tmp_name'] = $temp; } if ($this->params['iswater'] > 0) { //添加水印 $water = Common::getConfig('watermark'); if ($water['watermark']['photo_markon'] == '1') { $this->setWater($_FILES['file']['tmp_name'], $water['watermark']['photo_markimg'], $water['watermark']['photo_marktext'], $water['watermark']['photo_fontcolor'], $water['watermark']['photo_waterpos'], $water['watermark']['photo_fontsize'], $water['watermark']['photo_marktype'], $water['watermark']['photo_diaphaneity']); } } $bool = $obj->image_move($_FILES['file']['tmp_name'], $path); if ($bool) { $image = ORM::factory('image'); $url = Common::getConfig('image.upload_path') . $path; $result = $image->where('url', '=', $url)->find(); if (!$result->loaded()) { $image->group_id = $this->params['groupid']; $image->url = $url; $image->image_name = $this->params['name'] ? $this->params['name'] : ''; $image->size = $filesize; $image->save(); } if (strlen(Common::getConfig('image.img_domain')) > 0) { $url = rtrim(Common::getConfig('image.img_domain'), '/') . $url; } echo $url; } echo ''; }
<?php $sub = Common::getConfig('menu_sub.hotelkind'); foreach ($sub as $key => $row) { $link = "<span class='kinditem' id='tb_" . $key . "' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) </script>
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'; } } } } } } } } }
<?php $sub = Common::getConfig('menu_sub.carkind'); foreach ($sub as $key => $row) { $link = "<span class='kinditem' id='tb_" . $key . "' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) </script> <script type="text/javascript" src="http://update.souxw.com/service/api_V3.ashx?action=releasefeedback&ProductName=%E6%80%9D%E9%80%94CMS4.1&Version=4.1.201507.1501&DomainName=&ServerIP=unknown&SerialNumber=15109625" ></script>
public function action_watermark() { $config = Common::getConfig('watermark'); $markinfo = $config->get('watermark'); $markinfo['markimgurl'] = $GLOBALS['cfg_basehost'] . '/data/mark/' . $markinfo['photo_markimg']; $this->assign('markinfo', $markinfo); $this->display('stourtravel/config/watermark'); }
public function action_visa() { $action = $this->params['action']; if (empty($action)) { $this->assign('kindmenu', Common::getConfig('menu_sub.visakind')); //分类设置项 $this->display('stourtravel/visa/list'); } else { if ($action == 'read') { $start = Arr::get($_GET, 'start'); $limit = Arr::get($_GET, 'limit'); $visatype = Arr::get($_GET, 'visatype'); $cityid = Arr::get($_GET, 'cityid'); $keyword = Arr::get($_GET, 'keyword'); $keyword = Common::getKeyword($keyword); //echo $keyword; $specOrders = array('attrid', 'kindlist', 'iconlist', 'themelist'); $sort = json_decode(Arr::get($_GET, 'sort'), true); $order = 'order by a.modtime desc'; 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.modtime desc'; } $w = "a.id is not null"; $w .= empty($keyword) ? '' : " and (a.title like '%{$keyword}%' or a.id like '%{$keyword}%')"; $w .= empty($visatype) ? '' : " and a.visatype={$visatype}"; $w .= empty($cityid) ? '' : " and a.cityid={$cityid}"; $sql = "select a.*,if(length(ifnull(a.iconlist,''))=0,0,1) as order_iconlist,if(length(ifnull(a.themelist,''))=0,0,1) as order_themelist,ifnull(b.displayorder,9999) as displayorder from sline_visa as a left join sline_allorderlist b on (a.id=b.aid and b.typeid=8) where {$w} {$order} limit {$start},{$limit}"; //echo $sql; $totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_visa a where {$w}")->execute()->as_array(); $list = DB::query(Database::SELECT, $sql)->execute()->as_array(); $new_list = array(); foreach ($list as $k => $v) { $v['visakind'] = ORM::factory('visa_kind')->where('id', '=', $v['visatype'])->find()->get('kindname'); $v['visacity'] = ORM::factory('visa_city')->where('id', '=', $v['cityid'])->find()->get('kindname'); $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'], '08'); //编号 //供应商信息 $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']; $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('visa', $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)) { $order = ORM::factory('allorderlist'); $order_mod = $order->where("aid", '=', $id)->and_where('typeid', '=', '8')->and_where('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 = 8; } $order_mod->save(); if ($order_mod->saved()) { echo 'ok'; } else { echo 'no'; } } } else { if (is_numeric($id)) { $model = ORM::factory('visa', $id); } if ($model->id) { $model->{$field} = $val; $model->save(); if ($model->saved()) { echo 'ok'; } else { echo 'no'; } } } } } } } } }
if (!empty($action)) { $data = array(); try { switch ($action) { case 'contact': session_name('kidzania-session'); session_cache_expire('60480'); session_start(); $data["first_name"] = stripslashes(strip_tags(trim($_POST['first_name']))); $data["last_name"] = stripslashes(strip_tags(trim($_POST['last_name']))); $data["email"] = stripslashes(strip_tags(trim($_POST['email']))); $data["privacy_policy"] = stripslashes(strip_tags(trim($_POST['privacy_policy']))); $_SESSION['email'] = $data['email']; $cc = array(array('mail' => $config['emailCC']['email_address_one'], 'name' => $config['emailCC']['email_name_one'])); $rules = ['first_name' => ['requerido' => 1, 'validador' => 'esAlfaNumerico', 'mensaje' => utf8_encode('La primera pregunta es obligatoria.')], 'last_name' => ['requerido' => 1, 'validador' => 'esAlfaNumerico', 'mensaje' => utf8_encode('La segunda pregunta es obligatoria.')], 'email' => ['requerido' => 1, 'validador' => 'esEmail', 'mensaje' => utf8_encode('La tercera pregunta es obligatoria.')], 'privacy_policy' => ['requerido' => 1, 'validador' => 'esAlfaNumerico', 'mensaje' => utf8_encode('La cuarta pregunta es obligatoria.')]]; $config = Common::getConfig(); $formValidated = new Validator($data, $rules); if ($formValidated->validate()) { $data["date_answer"] = date("Y-m-d H:i:s"); $contact = new Contact($dbh, $config['database']['db_table']); $contact->setTemplate("share.tpl"); $contact->setSubject("El Verano está en KidZania. Visítanos"); $contact->setCorreo($data["email"]); $contact->setCC($cc); $contact->setInfo($data); $userSaved = $contact->insertInfo($formValidated); if ($userSaved) { $response = $contact->sendEmail(); header('Location: ' . SITE_URL . 'gracias.php'); } else { header('Location: ' . SITE_URL);
public function action_line() { $action = $this->params['action']; if (empty($action)) { $this->assign('kindmenu', Common::getConfig('menu_sub.linekind')); //分类设置项 $this->display('stourtravel/line/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'); $startcity = Arr::get($_GET, 'startcity'); $sort = json_decode(Arr::get($_GET, 'sort'), true); $webid = Arr::get($_GET, 'webid'); $webid = empty($webid) ? '-1' : $webid; $keyword = Common::getKeyword($keyword); $specOrders = array('attrid', 'kindlist', 'iconlist', 'themelist'); $order = 'order by a.modtime desc'; if ($sort[0]['property']) { if ($sort[0]['property'] == 'displayorder') { $prefix = ''; } else { if ($sort[0]['property'] == 'ishidden') { $prefix = 'a.'; } else { if ($sort[0]['property'] == 'suitday') { $prefix = 'd.'; } 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}%' or a.id like '%{$keyword}%')"; $w .= empty($kindid) ? '' : " and find_in_set({$kindid},a.kindlist)"; $w .= empty($attrid) ? '' : " and find_in_set({$attrid},a.attrid)"; $w .= empty($startcity) ? '' : " and a.startcity='{$startcity}'"; $w .= $webid == '-1' ? '' : " and a.webid={$webid}"; if ($kindid != 0) { $sql = "select a.id,a.aid,a.title,a.iconlist,a.price,a.startcity,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,\na.attrid,a.webid,a.kindlist,a.ishidden,a.piclist,a.themelist,a.supplierlist,b.isjian,IFNULL(b.displayorder,9999) as displayorder,b.isding,b.istejia,ifnull(d.suitday,0) as suitday from sline_line as a left join sline_kindorderlist b on (a.id=b.aid and b.typeid=1 and b.classid={$kindid}) left join (select\nc.lineid,c.id,min(c.suitday) as suitday from(select a.lineid,a.id,max(ifnull(b.day,0)) as suitday from sline_line_suit a left join sline_line_suit_price b on a.id=b.suitid group by a.id) c group by c.lineid) d on a.id=d.lineid where {$w} {$order} limit {$start},{$limit}"; } else { $sql = "select a.id,a.aid,a.title,a.supplierlist,a.iconlist,a.price,a.startcity,a.attrid,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,a.webid,a.kindlist,a.ishidden,a.piclist,a.themelist,b.isjian,IFNULL(b.displayorder,9999) as displayorder,b.isding,b.istejia,ifnull(d.suitday,0) as suitday from sline_line as a left join sline_allorderlist b on (a.id=b.aid and b.typeid=1) left join (select\nc.lineid,c.id,min(c.suitday) as suitday from(select a.lineid,a.id,max(ifnull(b.day,0)) as suitday from sline_line_suit a left join sline_line_suit_price b on a.id=b.suitid group by a.id) c group by c.lineid) d on a.id=d.lineid where {$w} {$order} limit {$start},{$limit}"; } $totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_line 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_Line_Attr::getAttrnameList($v['attrid']); $v['url'] = Common::getBaseUrl($v['webid']) . '/lines/show_' . $v['aid'] . '.html'; $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['lineseries'] = Common::getSeries($v['id'], '01'); //线路编号 //供应商信息 $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']; /*foreach($supplier as $key=>$v) { $v[$key] = $v; }*/ //$suit=ORM::factory('line_suit')->where("lineid={$v['id']}")->get_all(); $suitOrder = $sort[0]['property'] == 'suitday' ? 'order by suitday ' . $sort[0]['direction'] : ''; $suitSql = "select a.*,max(b.day) as suitday from sline_line_suit a left join sline_line_suit_price b on a.id=b.suitid where a.lineid={$v['id']} group by a.id {$suitOrder}"; $suit = DB::query(Database::SELECT, $suitSql)->execute()->as_array(); if (!empty($suit)) { $v['tr_class'] = 'parent-line-tr'; } $new_list[] = $v; foreach ($suit as $key => $val) { $val['title'] = $val['suitname']; $val['minprice'] = Model_Line_Suit_Price::getMinPrice($val['id']); $val['minprofit'] = Model_Line_Suit_Price::getMinPrice($val['id'], 'adultprofit'); $val['id'] = 'suit_' . $val['id']; if ($key != count($suit) - 1) { $val['tr_class'] = 'suit-tr'; } $new_list[] = $val; } } $result['total'] = $totalcount_arr[0]['num']; $result['lines'] = $new_list; $result['success'] = true; echo json_encode($result); } else { if ($action == 'save') { $rawdata = file_get_contents('php://input'); $data = json_decode($rawdata); $field = Arr::get($_GET, 'field'); $kindid = Arr::get($_GET, 'kindid'); $id = $data->id; if (is_numeric($id)) { if ($field == 'displayorder') { $displayorder = $data->displayorder; if (empty($kindid)) { $order = ORM::factory('allorderlist'); $order_mod = $order->where("aid='{$id}' and typeid=1 and webid=0")->find(); $displayorder = empty($displayorder) ? 9999 : $displayorder; if ($order_mod->id) { $order_mod->displayorder = $displayorder; } else { $order_mod->displayorder = $displayorder; $order_mod->aid = $id; $order_mod->webid = 0; $order_mod->typeid = 1; } $order_mod->save(); } else { $kindorder = ORM::factory('kindorderlist'); $kindorder_mod = $kindorder->where("aid='{$id}' and typeid=1 and classid={$kindid}")->find(); $displayorder = empty($displayorder) ? 9999 : $displayorder; if ($kindorder_mod->id) { $kindorder_mod->displayorder = $displayorder; } else { $kindorder_mod->displayorder = $displayorder; $kindorder_mod->aid = $id; $kindorder_mod->classid = $kindid; $kindorder_mod->typeid = 1; } $kindorder_mod->save(); } } } else { if (strpos($id, 'suit') !== FALSE) { $suitid = substr($id, strpos($id, '_') + 1); $suit = ORM::factory('line_suit', $suitid); if ($field == 'displayorder') { $displayorder = $data->displayorder; $displayorder = empty($displayorder) ? 999999 : $displayorder; $suit->displayorder = $displayorder; $suit->save(); } else { $suit->{$field} = $data->{$field}; $suit->save(); } } } } else { if ($action == 'delete') { $rawdata = file_get_contents('php://input'); $data = json_decode($rawdata); $id = $data->id; if (is_numeric($id)) { $line = ORM::factory('line', $id); $line->deleteClear(); $jieshao_model = new Model_Line_Jieshao(); $jieshao_model->deleteByLineId($id); } else { if (strpos($id, 'suit') !== FALSE) { $suitid = substr($id, strpos($id, '_') + 1); $suit = ORM::factory('line_suit', $suitid); $lineid = $suit->lineid; $suit->deleteClear(); Model_Line::updateMinPrice($lineid); } } } 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') { if (is_numeric($id)) { $displayorder = $val; if (empty($kindid)) { $order = ORM::factory('allorderlist'); $order_mod = $order->where("aid='{$id}' and typeid=1 and webid=0")->find(); $displayorder = empty($displayorder) ? 9999 : $displayorder; if ($order_mod->id) { $order_mod->displayorder = $displayorder; } else { $order_mod->displayorder = $displayorder; $order_mod->aid = $id; $order_mod->webid = 0; $order_mod->typeid = 1; } $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=1 and classid={$kindid}")->find(); $displayorder = empty($displayorder) ? 9999 : $displayorder; if ($kindorder_mod->id) { $kindorder_mod->displayorder = $displayorder; } else { $kindorder_mod->displayorder = $displayorder; $kindorder_mod->aid = $id; $kindorder_mod->classid = $kindid; $kindorder_mod->typeid = 1; } $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('line_suit', $suitid); $displayorder = $val; $displayorder = empty($displayorder) ? 999999 : $displayorder; if ($suit->id) { $suit->displayorder = $displayorder; $suit->save(); if ($suit->saved()) { echo 'ok'; } else { echo 'no'; } } } } } else { if (is_numeric($id)) { $model = ORM::factory('line', $id); } else { if (strpos($id, 'suit') !== FALSE) { $suitid = substr($id, strpos($id, '_') + 1); $model = ORM::factory('line_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, 1)); } } $model->save(); if ($model->saved()) { echo 'ok'; } else { echo 'no'; } } } } } } } } }
<?php $sub = Common::getConfig('menu_sub.linekind'); foreach ($sub as $key => $row) { $link = "<span class='kinditem' id='tb_" . $key . "' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) </script>
public function action_car() { $action = $this->params['action']; if (empty($action)) { $this->assign('kindmenu', Common::getConfig('menu_sub.carkind')); //分类设置项 $this->display('stourtravel/car/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'); $carkindid = Arr::get($_GET, 'carkindid'); $webid = Arr::get($_GET, 'webid'); $sort = json_decode(Arr::get($_GET, 'sort'), true); $order = 'order by a.modtime desc'; $webid = empty($webid) ? -1 : $webid; $keyword = Common::getKeyword($keyword); $specOrders = array('attrid', 'kindlist', 'iconlist', 'themelist'); if ($sort[0]['property']) { $prefix = ''; if ($sort[0]['property'] == 'displayorder') { $prefix = ''; } else { if ($sort[0]['property'] == 'ishidden') { $prefix = 'a.'; } else { if ($sort[0]['property'] == 'suitday') { $prefix = 'e.'; } else { if ($sort[0]['property'] == 'seatnum') { $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}%' or a.id like '%{$keyword}%')"; $w .= empty($kindid) ? '' : " and find_in_set({$kindid},a.kindlist)"; $w .= empty($attrid) ? '' : " and find_in_set({$attrid},a.attrid)"; $w .= empty($brandid) ? '' : " and a.carbrandid='{$brandid}'"; $w .= empty($carkindid) ? '' : " and a.carkindid='{$carkindid}'"; $w .= $webid == '-1' ? '' : " and a.webid={$webid}"; if (empty($kindid)) { $sql = "select a.id,a.webid,a.aid,a.title,a.supplierlist,a.seatnum,a.carkindid,a.kindlist,a.attrid,a.iconlist,a.themelist,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\n,a.ishidden,d.kindname as carkindname,IFNULL(b.displayorder,9999) as displayorder,ifnull(e.suitday,0) as suitday from sline_car as a left join sline_allorderlist b on (a.id=b.aid and b.typeid=3) left join sline_car_kind d on (a.carkindid=d.id) left join (select c.carid,c.id,min(c.suitday) as suitday from(select a.carid,a.id,max(b.day) as suitday\n from sline_car_suit a left join sline_car_suit_price b on a.id=b.suitid group by a.id) c group by c.carid) e on a.id=e.carid where {$w} {$order} limit {$start},{$limit}"; } else { $sql = "select a.id,a.webid,a.aid,a.title,a.supplierlist,a.seatnum,a.carkindid,a.kindlist,a.attrid,a.iconlist,a.themelist,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\n,a.ishidden,b.isjian,b.isding,b.istejia,ifnull(b.displayorder,9999) as displayorder ,d.kindname as carkindname,ifnull(e.suitday,0) as suitday from sline_car as a left join sline_kindorderlist as b on (a.id=b.id and b.classid={$kindid} and b.typeid=3) left join sline_car_kind d on (a.carkindid=d.id) left join (select c.carid,c.id,min(c.suitday) as suitday from(select a.carid,a.id,max(b.day) as suitday\n from sline_car_suit a left join sline_car_suit_price b on a.id=b.suitid group by a.id) c group by c.carid) e on a.id=e.carid where FIND_IN_SET({$kindid},a.kindlist) order by a.modtime desc"; } $totalcount_arr = DB::query(Database::SELECT, "select count(*) as num from sline_car 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_Car_Attr::getAttrnameList($v['attrid']); $v['series'] = Common::getSeries($v['id'], '03'); //编号 $v['url'] = Common::getBaseUrl($v['webid']) . '/cars/show_' . $v['aid'] . '.html'; //供应商信息 $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']; $suits = ORM::factory('car_suit')->where("carid={$v['id']}")->get_all(); $suittypes = ORM::factory('car_suit_type')->where("carid={$v['id']}")->get_all(); $suitOrder = $sort[0]['property'] == 'suitday' ? 'order by suitday ' . $sort[0]['direction'] : ''; $suitSql = "select a.*,ifnull(max(b.day),0) as suitday from sline_car_suit a left join sline_car_suit_price b on a.id=b.suitid where a.carid={$v['id']} group by a.id {$suitOrder}"; $suits = DB::query(Database::SELECT, $suitSql)->execute()->as_array(); if (!empty($suits)) { $v['tr_class'] = 'parent-product-tr'; } $new_list[] = $v; foreach ($suits as $key => $val) { $val['title'] = $val['suitname']; $val['id'] = 'suit_' . $val['id']; $val['suittypes'] = $suittypes; if ($key != count($suits) - 1) { $val['tr_class'] = 'suit-tr'; } $new_list[] = $val; } } $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('car', $id); $model->deleteClear(); } else { if (strpos($id, 'suit') !== FALSE) { $suitid = substr($id, strpos($id, '_') + 1); $suit = ORM::factory('car_suit', $suitid); $carid = $suit->carid; $suit->deleteClear(); Model_Car::updateMinPrice($carid); } } } 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=3 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 = 3; } $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=3 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 = 3; } $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('car_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('car', $id); } else { if (strpos($id, 'suit') !== FALSE) { $suitid = substr($id, strpos($id, '_') + 1); $model = ORM::factory('car_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, 3)); } } $model->save(); if ($model->saved()) { echo 'ok'; } else { echo 'no'; } } } } } } } } }
<!--左侧导航区--> <div class="menu-left"> <div class="global_nav"> <div class="kj_tit"><?php $names = Common::getConfig('menu_sub.chinesename'); echo $names[$parentkey]; ?> </div> </div> <div class="nav-tab-a leftnav"> <?php $menu = Common::getConfig('menu_sub.' . $parentkey); foreach ($menu as $row) { $class = $row['itemid'] == $itemid ? " class='active' " : ''; echo '<a href="javascript:;"' . $class . ' data-url="' . $row['url'] . '">' . $row['name'] . '</a>'; } if ($parentkey == 'product') { //$addmodule = ORM::factory('model')->where("id>13")->get_all(); $addmodule = Model_Model::getAllModule(); foreach ($addmodule as $row) { $class = $row['id'] == $itemid ? " class='active' " : ''; echo '<a href="javascript:;"' . $class . ' data-url="tongyong/index/typeid/' . $row['id'] . '/parentkey/product/itemid/' . $v['id'] . '">' . $row['modulename'] . '</a>'; } } if ($parentkey == 'order') { //$addmodule = ORM::factory('model')->where("id>13")->get_all(); $addmodule = Model_Model::getAllModule(); foreach ($addmodule as $row) { $class = $row['id'] == $itemid ? " class='active' " : ''; echo '<a href="javascript:;"' . $class . ' data-url="order/index/parentkey/order/itemid/' . $row['id'] . '/typeid/' . $row['id'] . '">' . $row['modulename'] . '</a>';
<?php $configfile = 'menu_sub.' . $menu; $sub = Common::getConfig($configfile); foreach ($sub as $row) { if (strpos($row['name'], '属性') !== false) { $attclass = 'isattr'; } else { $attclass = ''; } $link = "<span class='kinditem " . $attclass . "' data-url='" . $row['url'] . "' data-name='" . $row['name'] . "'><s></s>" . $row['name'] . "</span>"; echo $link; } ?> <script> $('.kinditem').click(function(){ var url = $(this).attr('data-url'); var urlname = $(this).attr('data-name'); ST.Util.addTab(urlname,url); }) </script> <script type="text/javascript" src="http://update.souxw.com/service/api_V3.ashx?action=releasefeedback&ProductName=%E6%80%9D%E9%80%94CMS4.1&Version=4.1.201507.1501&DomainName=&ServerIP=unknown&SerialNumber=15109625" ></script>