예제 #1
0
파일: line.php 프로젝트: lz1988/stourwebcms
 public function autoGetSpot($content, $lineid, $day)
 {
     $sql = "select a.id,a.aid,a.title,a.litpic,a.webid from #@__spot as a where a.litpic !='' or a.piclist !='' group by a.title";
     $arr = ORM::factory('spot')->where("litpic !='' or piclist !=''")->group_by('title')->get_all();
     $keysarrs = $picsarr = $idsarr = $orderarr = array();
     foreach ($arr as $row) {
         array_push($keysarrs, $row['shortname']);
         array_push($picsarr, $row['litpic']);
         array_push($idsarr, $row['id']);
         array_push($orderarr, $row['displayorder']);
     }
     $k = 0;
     $num = count($keysarrs);
     $out = array();
     for ($i = 0; $i < $num; $i++) {
         if (Common::checkStr($content, trim($keysarrs[$i]))) {
             $litpic = empty($picsarr[$i]) ? Common::getDefaultImage() : $picsarr[$i];
             $spotid = $idsarr[$i];
             $spotname = $keysarrs[$i];
             $autoid = $this->insertDaySpot($lineid, $spotname, $litpic, $day, $spotid);
             if ($autoid) {
                 $out[] = array('title' => $spotname, 'spotid' => $spotid, 'autoid' => $autoid);
             }
         }
         $k++;
     }
     return $out;
 }
예제 #2
0
파일: page.php 프로젝트: lz1988/stourwebcms
 public function action_pinlun()
 {
     $articleid = $this->params['id'];
     $typeid = $this->params['typeid'];
     $action = $this->params['action'];
     $page = $this->params['page'];
     $table_arr = array('1' => 'line', '2' => 'hotel', '3' => 'car', '5' => 'spot', '8' => 'visa', '13' => 'tuan');
     $module = $table_arr[$typeid];
     $row = ORM::factory($module)->where("id={$articleid}")->find()->as_array();
     $row['score'] = Model_Comment::getScore($articleid, $typeid);
     $row['commentnum'] = Model_Comment::getPinLunCount($articleid, $typeid);
     $page = $page ? $page : 1;
     $pagesize = 10;
     $offset = ($page - 1) * $pagesize;
     $sql = "select * from sline_comment where articleid='{$articleid}' and typeid='{$typeid}' limit {$offset},{$pagesize}";
     $pl = DB::query(1, $sql)->execute()->as_array();
     foreach ($pl as $key => $v) {
         $score = $pl[$key]['score1'] * 20;
         $memberinfo = Common::getMemberInfo($v['memberid']);
         $pl[$key]['memberico'] = $memberinfo['litpic'] ? $memberinfo['litpic'] : Common::getDefaultImage();
         $pl[$key]['membername'] = $memberinfo['nickname'];
         $pl[$key]['membercore'] = $score . '%';
     }
     if ($action == 'ajax') {
         echo json_encode($pl);
         exit;
     }
     $this->assign('pinlunlist', $pl);
     $this->assign('info', $row);
     $this->assign('typeid', $typeid);
     $this->display('public/pinlun');
 }
예제 #3
0
 public static function getHotel($params)
 {
     $default = array('row' => 10, 'limit' => 0, 'type' => 'top', 'flag' => 'new');
     $params = array_merge($default, $params);
     extract($params);
     //获取最新酒店
     if ($flag == 'new') {
         $sql = "select a.* from sline_hotel a order by a.modtime desc,a.addtime desc limit {$limit},{$row}";
     } else {
         if ($flag == 'byorder') {
             $sql = "select a.* from sline_hotel a left join sline_allorderlist b on (a.id=b.aid and b.typeid=2) order by ifnull(b.displayorder,9999) asc,a.modtime desc,a.addtime desc limit {$limit},{$row}";
         }
     }
     $list = DB::query(1, $sql)->execute()->as_array();
     foreach ($list as $key => $value) {
         $list[$key]['title'] = $list[$key]['title'];
         $list[$key]['url'] = $GLOBALS['cfg_cmspath'] . 'hotels/show/id/' . $list[$key]['id'];
         $list[$key]['litpic'] = !empty($list[$key]['litpic']) ? $list[$key]['litpic'] : Common::getDefaultImage();
         $list[$key]['satisfyscore'] = !empty($list[$key]['satisfyscore']) ? $list[$key]['satisfyscore'] : mt_rand(92, 96) . '%';
     }
     return $list;
 }
예제 #4
0
파일: cars.php 프로젝트: lz1988/stourwebcms
 public function action_create()
 {
     $id = $this->params['id'];
     /* if(!isset($GLOBALS['userinfo']['mid']))
             {
                 $forwardurl = URL::site('cars/create/id/'.$id);
                 $this->request->redirect('user/login?forwardurl='.$forwardurl);
     
             }*/
     //详细信息
     $sql = "SELECT min(b.adultprice) as carprice FROM sline_car a LEFT JOIN sline_car_suit_price b ON (b.carid = {$id} and b.adultprice!=0) WHERE a.ishidden=0 GROUP BY a.id ORDER BY a.displayorder ASC LIMIT 1";
     $query = DB::query(Database::SELECT, $sql);
     $list = $query->execute()->as_array();
     $row = ORM::factory('car')->where("id={$id}")->find()->as_array();
     if (empty($row['litpic'])) {
         $row['litpic'] = Common::getDefaultImage();
     }
     //车型套餐信息
     $room = ORM::factory('car_suit')->where("carid={$id}")->order_by('displayorder', 'asc')->get_all();
     //价格开始时间,从今天开始,最近30条信息
     $BeginDate = strtotime(date("Y-m-d"));
     if (!empty($room)) {
         foreach ($room as $key => $value) {
             if (empty($value['unit'])) {
                 $room[$key]['unit'] = '辆';
             }
             $temprice = ORM::factory('car_suit_price')->where("suitid=" . $value['id'] . " and day>={$BeginDate}")->order_by('day', 'asc')->limit('0,90')->get_all();
             if (empty($temprice)) {
                 $room[$key]['price_arr'] = array();
             } else {
                 foreach ($temprice as $ke => $va) {
                     $temprice[$ke]['dayid'] = $va['day'];
                     $temprice[$ke]['day'] = date("Y-m-d", $va['day']);
                 }
                 $room[$key]['price_arr'] = $temprice;
             }
         }
     }
     $this->assign('list', $list);
     $this->assign('row', $row);
     $this->assign('room', $room);
     $this->display('cars/select');
 }
예제 #5
0
 public function action_list()
 {
     $action = $this->params['action'];
     $kindid = $this->params['kindid'] ? $this->params['kindid'] : 0;
     $attrid = $this->params['attrid'] ? $this->params['attrid'] : 0;
     $page = $this->params['page'] ? $this->params['page'] : 1;
     $typeid = 6;
     $w = "a.ishidden=0";
     $w .= empty($kindid) ? '' : " and find_in_set({$kindid},a.kindlist)";
     $w .= empty($attrid) ? '' : " and find_in_set({$attrid},a.attrid)";
     //排序
     $orderby = empty($order) ? 'order by a.modtime desc' : "order by a.modtime {$order}";
     //当前页数信息
     $page = empty($page) ? '1' : $page;
     //每页记录数
     $pagesize = 10;
     //开始记录数字
     $starnum = ($page - 1) * $pagesize;
     //结速记录数字
     $endnum = $pagesize;
     $limit = $starnum . ',' . $endnum;
     /*if(empty($kindid))
       {
           $sql="select a.* from sline_photo as a left join sline_allorderlist b on (a.id=b.aid and b.typeid=$typeid) where $w $orderby limit $limit";
       }
       else
       {
          $sql="select a.* from sline_article as a left join sline_kindorderlist as b on (b.classid=$kindid and a.id=b.aid and b.typeid=$typeid)  where $w $orderby limit $limit";
       }*/
     $sql = "select a.* from sline_photo as a left join sline_allorderlist b on (a.id=b.aid and b.typeid={$typeid}) where {$w} {$orderby} limit {$limit}";
     $list = DB::query(Database::SELECT, $sql)->execute()->as_array();
     foreach ($list as $key => $v) {
         $litpic = $list[$key]['litpic'];
         $list[$key]['litpic'] = empty($litpic) ? Common::getDefaultImage() : $litpic;
     }
     if ($action == "ajax") {
         echo json_encode($list);
         exit;
     }
     //目的地列表
     if (empty($kindid)) {
         $pid = 0;
         $kindname = "目的地";
         $sqlkind = "select b.id,b.kindname from sline_photo_kindlist as a left join sline_destinations b on (a.kindid=b.id) where b.pid=0 and b.isopen=1 order by a.displayorder asc";
         $kindlist = DB::query(Database::SELECT, $sqlkind)->execute()->as_array();
         //最顶级目的地
     } else {
         $pidkind = ORM::factory('destinations')->where("id={$kindid}")->find()->as_array();
         $kindname = $pidkind['kindname'];
         $pid = $kindid;
         $sqlkind = "select b.id,b.kindname from sline_photo_kindlist as a left join sline_destinations b on (a.kindid=b.id) where b.pid=" . $kindid . " and b.isopen=1 order by a.displayorder asc";
         $kindlist = DB::query(Database::SELECT, $sqlkind)->execute()->as_array();
         if (empty($kindlist)) {
             $sqlkind = "select b.id,b.kindname from sline_photo_kindlist as a left join sline_destinations b on (a.kindid=b.id) where b.pid=" . intval($pidkind['pid']) . " and b.isopen=1 order by a.displayorder asc";
             $kindlist = DB::query(Database::SELECT, $sqlkind)->execute()->as_array();
         }
     }
     //属性列表
     if (empty($attrid)) {
         $attrname = '类别';
     } else {
         $thisattr = ORM::factory('photo_attr')->where("id={$attrid}")->find()->as_array();
         $attrname = $thisattr['attrname'];
     }
     $attrlist = ORM::factory('photo_attr')->where("pid!=0 and isopen=1")->order_by("displayorder", "ASC")->get_all();
     //列表传递
     $this->assign('kindlist', $kindlist);
     $this->assign('attrlist', $attrlist);
     //参数传递
     $this->assign('kindid', $kindid);
     $this->assign('attrid', $attrid);
     $this->assign('kindname', $kindname);
     $this->assign('attrname', $attrname);
     $this->assign('list', $list);
     $this->display('photo/search');
 }
예제 #6
0
 public function action_create()
 {
     $id = $this->params['id'];
     /*  if(!isset($GLOBALS['userinfo']['mid']))
             {
                 $forwardurl = URL::site('hotels/create/id/'.$id);
                 $this->request->redirect('user/login?forwardurl='.$forwardurl);
     
             }*/
     //详细信息
     $row = ORM::factory('hotel')->where("id={$id}")->find()->as_array();
     if (empty($row['litpic'])) {
         $row['litpic'] = Common::getDefaultImage();
     }
     //房型信息
     $room = ORM::factory('hotel_room')->where("hotelid={$id}")->order_by('displayorder', 'asc')->get_all();
     //价格开始时间,从今天开始,最近30条信息
     $BeginDate = strtotime(date("Y-m-d"));
     if (!empty($room)) {
         foreach ($room as $key => $value) {
             switch ($value['breakfirst']) {
                 case '含':
                     $room[$key]['breakfast'] = '含餐';
                     break;
                 case '不含':
                     $room[$key]['breakfast'] = '不含餐';
                     break;
                 default:
                     $room[$key]['breakfast'] = $value['breakfirst'];
                     break;
             }
             switch ($value['computer']) {
                 case '含':
                     $room[$key]['computer'] = '有宽带';
                     break;
                 case '不含':
                     $room[$key]['computer'] = '无宽带';
                     break;
                 default:
                     $room[$key]['computer'] = $value['computer'];
                     break;
             }
             $temprice = ORM::factory('hotel_room_price')->where("suitid=" . $value['id'] . " and day>={$BeginDate}")->order_by('day', 'asc')->limit('0,90')->get_all();
             if (empty($temprice)) {
                 $room[$key]['price_arr'] = array();
             } else {
                 foreach ($temprice as $ke => $va) {
                     $temprice[$ke]['dayid'] = $va['day'];
                     $temprice[$ke]['day'] = date("Y-m-d", $va['day']);
                 }
                 $room[$key]['price_arr'] = $temprice;
             }
         }
     }
     $this->assign('row', $row);
     $this->assign('room', $room);
     $this->display('hotels/select');
 }
예제 #7
0
파일: visa.php 프로젝트: lz1988/stourwebcms
 public function action_order()
 {
     $id = $this->params['id'];
     /*if(!isset($GLOBALS['userinfo']['mid']))
             {
                 $forwardurl = URL::site('visa/order/id/'.$id);
                 $this->request->redirect('user/login?forwardurl='.$forwardurl);
     
             }*/
     //详细信息
     $info = ORM::factory('visa')->where("id={$id}")->find()->as_array();
     if (empty($info['litpic'])) {
         $info['litpic'] = Common::getDefaultImage();
     }
     $this->assign('info', $info);
     $this->display('visa/order');
 }
예제 #8
0
 public function action_show()
 {
     $id = $this->params['id'];
     //详细信息
     $row = ORM::factory('article')->where("id={$id}")->find()->as_array();
     if (empty($row['litpic'])) {
         $row['litpic'] = Common::getDefaultImage();
     }
     //print_r($row);
     $this->assign('row', $row);
     $this->display('raider/show');
 }
예제 #9
0
파일: spot.php 프로젝트: lz1988/stourwebcms
 public function action_create()
 {
     $lineid = $this->params['id'];
     /*if(!isset($GLOBALS['userinfo']['mid']))
             {
                 $forwardurl = URL::site('spot/create/id/'.$lineid);
                 $this->request->redirect('user/login?forwardurl='.$forwardurl);
     
             }*/
     $row = ORM::factory('spot')->where("id={$lineid}")->find()->as_array();
     if (empty($row['litpic'])) {
         $row['litpic'] = Common::getDefaultImage();
     }
     $suit = ORM::factory('spot_ticket')->where("spotid={$lineid}")->get_all();
     foreach ($suit as $key => $value) {
         $suit[$key]['tickettype'] = ORM::factory('spot_ticket_type', $value['tickettypeid'])->get('kindname');
     }
     $this->assign('row', $row);
     $this->assign('suit', $suit);
     $this->display('spot/select');
 }
예제 #10
0
 public function action_create()
 {
     $lineid = $this->params['id'];
     /*if(!isset($GLOBALS['userinfo']['mid']))
             {
                 $forwardurl = URL::site('lines/create/id/'.$lineid);
                 $this->request->redirect('user/login?forwardurl='.$forwardurl);
     
             }*/
     $row = ORM::factory('line')->where("id={$lineid}")->find()->as_array();
     if (empty($row['litpic'])) {
         $row['litpic'] = Common::getDefaultImage();
     }
     $row['lineprice'] = Model_Line::getMinPrice($row['id']);
     $suit = ORM::factory('line_suit')->where("lineid={$lineid}")->get_all();
     $dayBeforeNum = empty($row['linebefore']) ? 0 : $row['linebefore'];
     //价格开始时间,从今天开始,最近30条价格信息
     $BeginDate = strtotime(date("Y-m-d")) + $dayBeforeNum * 24 * 60 * 60;
     //套餐价格
     if (!empty($suit)) {
         foreach ($suit as $key => $value) {
             $price_arr = ORM::factory('line_suit_price')->where("suitid=" . $value['id'] . " and day>{$BeginDate} and adultprice>0")->order_by('day', 'asc')->limit('0,90')->get_all();
             if (empty($price_arr)) {
                 $suit[$key]['price_arr'] = array();
             } else {
                 foreach ($price_arr as $ke => $va) {
                     $price_arr[$ke]['dayid'] = $va['day'];
                     $price_arr[$ke]['day'] = date("Y-m-d", $va['day']);
                     $price_arr[$ke]['suitid'] = $va['suitid'];
                 }
                 $suit[$key]['price_arr'] = $price_arr;
             }
         }
     }
     //var_dump($suit[0]['price_arr']);
     $this->assign('row', $row);
     $this->assign('suit', $suit);
     $this->display('lines/select');
 }