MODPATH/database/classes/kohana/database/pdo.php [ 185 ]
180 // This benchmark is worthless
181 Profiler::delete($benchmark);
182 }
183
184 // Convert the exception in a database exception
185 throw new Database_Exception(':error [ :query ]',
186 array(
187 ':error' => $e->getMessage(),
188 ':query' => $sql
189 ),
190 $e->getCode());
-
MODPATH/database/classes/kohana/database/query.php [ 275 ] » Kohana_Database_PDO->query(arguments)
0
integer 1
1
string(295) "SELECT a.* FROM sline_line_suit_price a INNER JOIN (SELECT `day`,min(adultprice) adultprice FROM sline_line_suit_price WHERE lin …"
2
bool FALSE
3
array(0)
270 return new Database_Result_Cached($result, $sql, $as_object, $object_params); 271 } 272 } 273 274 // Execute the query 275 $result = $db->query($this->_type, $sql, $as_object, $object_params); 276 277 if (isset($cache_key) AND $this->_lifetime > 0) 278 { 279 // Cache the result array 280 Kohana::cache($cache_key, $result->as_array(), $this->_lifetime);
-
DOCROOT/plugins/line/classes/model/line.php [ 694 ] » Kohana_Database_Query->execute()
689 $time=strtotime(date('Y-m-d',strtotime("+{$line_info['linebefore']} days"))); 690 } 691 $lineid = intval($lineid); 692 //$sql = "SELECT * FROM `sline_line_suit_price` WHERE lineid='$lineid' AND `day`>{$time} ORDER BY `day` ASC limit 0,6"; 693 $sql="SELECT a.* FROM sline_line_suit_price a INNER JOIN (SELECT `day`,min(adultprice) adultprice FROM sline_line_suit_price WHERE lineid='{$lineid}' and supplier_channel_id=1 AND `day`>={$time} GROUP BY `day` ) b ON a.day = b.day AND a.adultprice = b.adultprice AND lineid='{$lineid}' ORDER BY a.day limit 0,6"; 694 $arr = DB::query(1, $sql)->execute()->as_array(); 695 $monthprice = array(); 696 foreach ($arr as $row) 697 { 698 $key = date('m-d', $row['day']); 699 $row['adultprice'] = Currency_Tool::price($row['adultprice']);
-
DOCROOT/plugins/line/classes/model/line.php [ 657 ] » Model_Line::get_month_price_list(arguments)
0
integer 420
1
array(75) ( "id" => string(3) "420" "webid" => string(1) "0" "aid" => string(3) "417" "title" => string(92) "【遇见最美希腊】雅典上团六日游:雅典+圣托里尼+梅黛奥拉天空之城" "seotitle" => string(0) "" "startcity" => string(0) "" "overcity" => NULL "linedate" => NULL "price" => string(6) "688.00" "price_date" => string(10) "1710777600" "lineday" => string(1) "6" "linenight" => string(1) "5" "litpic" => string(55) "/uploads/2022/0315/85d91c850a461ab5bb704b0bf7078028.png" "product_video" => NULL "linedoc" => string(2) "N;" "tagword" => string(0) "" "keyword" => string(0) "" "jieshao" => string(31) "<a href="" target="_blank"></a>" "biaozhun" => string(20118) "<p style="padding: 0px 0px 10px; margin-top: 0px; margin-bottom: 0px; position: relative; min-height: 20px; font-family: Arial, …" "beizu" => string(30231) "<p microsoft="" max-width:="" white-space:="" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: no …" "payment" => string(4575) "<p microsoft="" max-width:="" white-space:="" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: no …" "feeinclude" => string(2969) "<p style="text-align: center;"><strong style="font-weight: bold;">费用包含</strong></p><p style="line-height: normal;">(1) 往返旅游 …" "features" => string(0) "" "description" => string(0) "" "shownum" => string(3) "937" "seatleft" => NULL "storeprice" => string(3) "688" "transport" => string(0) "" "linebefore" => string(1) "3" "addtime" => string(10) "1679329242" "modtime" => string(10) "1710261799" "reserved1" => string(667) "<p>上团地点 Athens 雅典, 上团时间:09:00上团地点:宪法广场</p><p microsoft="" max-width:="" white-space:="" style="margin-top: 0px; margin-bottom: 0 …" "reserved2" => string(0) "" "reserved3" => string(0) "" "color" => string(0) "" "childrule" => string(0) "" "kindlist" => string(6) "166,37" "themelist" => NULL "attrid" => string(20) "2,7,3,45,15,19,51,52" "satisfyscore" => string(3) "100" "bookcount" => string(1) "0" "ishidden" => string(1) "0" "isstyle" => string(1) "2" "sellpoint" => string(119) "1004:【含往返游轮船票 体验爱琴海】欧洲星级酒店标准双人间(含早餐),中文领队+自助游" "piclist" => string(343) "/uploads/2022/0315/85d91c850a461ab5bb704b0bf7078028.png||1451440150-2,/uploads/2019/0715/481b93651610687118d78ccdfe378c9b.jpg||1 …" "distance" => NULL "zijiaseat" => NULL "zijiaprice" => NULL "zijiacar" => NULL "showrepast" => string(1) "1" "paytype" => string(1) "1" "templet" => string(13) "line_show.htm" "iconlist" => array(2) ( 0 => array(3) ( "kind" => string(9) "跟团游" "picurl" => string(21) "/uploads/icon/gty.png" "litpic" => string(43) "https://www.yoyoer.com/uploads/icon/gty.png" ) 1 => array(3) ( "kind" => string(9) "海岛游" "picurl" => string(21) "/uploads/icon/hdy.png" "litpic" => string(43) "https://www.yoyoer.com/uploads/icon/hdy.png" ) ) "supplierlist" => string(1) "3" "insuranceids" => string(0) "" "sourcelineid" => NULL "islinebefore" => string(1) "0" "recommendnum" => string(1) "0" "adminid" => string(1) "9" "finaldestid" => string(3) "166" "jifenbook_id" => string(1) "0" "jifentprice_id" => string(1) "0" "redirect_url" => string(0) "" "status" => string(1) "3" "refuse_msg" => string(0) "" "showhotel" => string(1) "1" "showtran" => string(1) "1" "contractid" => string(1) "0" "wap_templet" => string(0) "" "together_ids" => string(0) "" "together_time" => string(1) "0" "sellnum" => string(1) "1" "attrlist" => array(4) ( 0 => array(1) ( "attrname" => string(9) "大巴团" ) 1 => array(1) ( "attrname" => string(12) "四至八日" ) 2 => array(1) ( "attrname" => string(6) "雅典" ) 3 => array(1) ( "attrname" => string(12) "普通线路" ) ) "commentnum" => integer 0 "url" => string(42) "https://www.yoyoer.com/lines/show_417.html" )
652 //处理出发日期列表和出发日期下拉选择 653 654 public static function get_startdate($row) 655 { 656 $today = time(); 657 $montharr = self::get_month_price_list($row['id'],$row); 658 $monthstr = ''; 659 $curday = (int)date('d', $today); 660 if (empty($montharr)) 661 { 662
-
DOCROOT/plugins/line/classes/model/line.php [ 403 ] » Model_Line::get_startdate(arguments)
0
array(75) ( "id" => string(3) "420" "webid" => string(1) "0" "aid" => string(3) "417" "title" => string(92) "【遇见最美希腊】雅典上团六日游:雅典+圣托里尼+梅黛奥拉天空之城" "seotitle" => string(0) "" "startcity" => string(0) "" "overcity" => NULL "linedate" => NULL "price" => string(6) "688.00" "price_date" => string(10) "1710777600" "lineday" => string(1) "6" "linenight" => string(1) "5" "litpic" => string(55) "/uploads/2022/0315/85d91c850a461ab5bb704b0bf7078028.png" "product_video" => NULL "linedoc" => string(2) "N;" "tagword" => string(0) "" "keyword" => string(0) "" "jieshao" => string(31) "<a href="" target="_blank"></a>" "biaozhun" => string(20118) "<p style="padding: 0px 0px 10px; margin-top: 0px; margin-bottom: 0px; position: relative; min-height: 20px; font-family: Arial, …" "beizu" => string(30231) "<p microsoft="" max-width:="" white-space:="" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: no …" "payment" => string(4575) "<p microsoft="" max-width:="" white-space:="" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: no …" "feeinclude" => string(2969) "<p style="text-align: center;"><strong style="font-weight: bold;">费用包含</strong></p><p style="line-height: normal;">(1) 往返旅游 …" "features" => string(0) "" "description" => string(0) "" "shownum" => string(3) "937" "seatleft" => NULL "storeprice" => string(3) "688" "transport" => string(0) "" "linebefore" => string(1) "3" "addtime" => string(10) "1679329242" "modtime" => string(10) "1710261799" "reserved1" => string(667) "<p>上团地点 Athens 雅典, 上团时间:09:00上团地点:宪法广场</p><p microsoft="" max-width:="" white-space:="" style="margin-top: 0px; margin-bottom: 0 …" "reserved2" => string(0) "" "reserved3" => string(0) "" "color" => string(0) "" "childrule" => string(0) "" "kindlist" => string(6) "166,37" "themelist" => NULL "attrid" => string(20) "2,7,3,45,15,19,51,52" "satisfyscore" => string(3) "100" "bookcount" => string(1) "0" "ishidden" => string(1) "0" "isstyle" => string(1) "2" "sellpoint" => string(119) "1004:【含往返游轮船票 体验爱琴海】欧洲星级酒店标准双人间(含早餐),中文领队+自助游" "piclist" => string(343) "/uploads/2022/0315/85d91c850a461ab5bb704b0bf7078028.png||1451440150-2,/uploads/2019/0715/481b93651610687118d78ccdfe378c9b.jpg||1 …" "distance" => NULL "zijiaseat" => NULL "zijiaprice" => NULL "zijiacar" => NULL "showrepast" => string(1) "1" "paytype" => string(1) "1" "templet" => string(13) "line_show.htm" "iconlist" => array(2) ( 0 => array(3) ( "kind" => string(9) "跟团游" "picurl" => string(21) "/uploads/icon/gty.png" "litpic" => string(43) "https://www.yoyoer.com/uploads/icon/gty.png" ) 1 => array(3) ( "kind" => string(9) "海岛游" "picurl" => string(21) "/uploads/icon/hdy.png" "litpic" => string(43) "https://www.yoyoer.com/uploads/icon/hdy.png" ) ) "supplierlist" => string(1) "3" "insuranceids" => string(0) "" "sourcelineid" => NULL "islinebefore" => string(1) "0" "recommendnum" => string(1) "0" "adminid" => string(1) "9" "finaldestid" => string(3) "166" "jifenbook_id" => string(1) "0" "jifentprice_id" => string(1) "0" "redirect_url" => string(0) "" "status" => string(1) "3" "refuse_msg" => string(0) "" "showhotel" => string(1) "1" "showtran" => string(1) "1" "contractid" => string(1) "0" "wap_templet" => string(0) "" "together_ids" => string(0) "" "together_time" => string(1) "0" "sellnum" => string(1) "1" "attrlist" => array(4) ( 0 => array(1) ( "attrname" => string(9) "大巴团" ) 1 => array(1) ( "attrname" => string(12) "四至八日" ) 2 => array(1) ( "attrname" => string(6) "雅典" ) 3 => array(1) ( "attrname" => string(12) "普通线路" ) ) "commentnum" => integer 0 "url" => string(42) "https://www.yoyoer.com/lines/show_417.html" )
398 $v['commentnum'] = Model_Comment::get_comment_num($v['id'], 1); //评论次数 399 //$v['sellnum'] = Model_Member_Order::get_sell_num($v['id'], 1) + intval($v['bookcount']); //销售数量 400 $v['url'] = Common::get_web_url($v['webid']) . "/lines/show_{$v['aid']}.html"; 401 //$v['litpic'] = Common::img($v['litpic']); 402 $v['iconlist'] = Product::get_ico_list($v['iconlist']); 403 $v['startdate'] = Model_Line::get_startdate($v); 404 $v['score'] = St_Functions::get_satisfy(self::$_typeid, $v['id'], $v['satisfyscore']); 405 if(Model_Supplier::display_is_open()&&$v['supplierlist']) 406 { 407 $v['suppliername'] = Arr::get(Model_Supplier::get_supplier_info($v['supplierlist'],array('suppliername')),'suppliername'); 408 }
-
DOCROOT/plugins/line/classes/controller/pc/line.php [ 93 ] » Model_Line::search_result(arguments)
0
array(11) ( "controller" => string(4) "line" "action" => string(4) "list" "destpy" => string(5) "nanou" "dayid" => integer 0 "priceid" => integer 0 "sorttype" => integer 0 "displaytype" => integer 0 "startcityid" => integer 0 "attrid" => integer 0 "p" => integer 0 "channel_name" => string(9) "大巴游" )
1
string(0) ""
2
integer 0
3
integer 12
88 'attrid' => $attrId, 89 'p' => $p, 90 'channel_name' => $channel_name 91 ); 92 93 $out = Model_Line::search_result($route_array, $keyword, $p, $pagesize); 94 $pager = Pagination::factory( 95 array( 96 'current_page' => array('source' => 'route', 'key' => 'p'), 97 'view' => 'default/pagination/search', 98 'total_items' => $out['total'],
-
{PHP internal call} » Controller_Pc_Line->action_list()
-
SYSPATH/classes/kohana/request/client/internal.php [ 116 ] » ReflectionMethod->invoke(arguments)
0
object Controller_Pc_Line(9)
{ private _typeid => integer 1 private _cache_key => string(35) "https://www.yoyoer.com/lines/nanou/" private channelname => string(9) "大巴游" protected cmsurl => string(1) "/" protected platform_no => integer 5 public _data => array(4) ( "cmsurl" => string(1) "/" "webname" => string(12) "游游旅行" "typeid" => integer 1 "channelname" => string(9) "大巴游" ) public params => array(1) ( "" => integer 0 ) public request => object Request(20)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5)
public response => object Response(5){ protected _callback => NULL protected _uri => string(108) "lines/(<destpy>)(<sign>)(-<dayid>)(-<priceid>)(-<sorttype>)(-<displaytype>)(-<startcityid>)(-<attrid>)(-<p>)" protected _regex => array(9) ( "destpy" => string(12) "[0-9a-zA-Z]+" "sign" => string(3) "\/?" "dayid" => string(6) "[0-9]+" "priceid" => string(6) "[0-9]+" "sorttype" => string(6) "[0-9]+" "displaytype" => string(4) "[^-]" "startcityid" => string(6) "[0-9]+" "attrid" => string(7) "[0-9_]+" "p" => string(6) "[0-9]+" ) protected _defaults => array(3) ( "directory" => string(2) "pc" "controller" => string(4) "line" "action" => string(4) "list" ) protected _route_regex => string(233) "#^lines/(?:(?P<destpy>[0-9a-zA-Z]+))?(?:(?P<sign>\/?))?(?:-(?P<dayid>[0-9]+))?(?:-(?P<priceid>[0-9]+))?(?:-(?P<sorttype>[0-9]+)) …" }
protected _routes => array(0) protected _response => object Response(5){ protected _status => integer 200 protected _header => object HTTP_Header(0)
protected _header => object HTTP_Header(0){ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }{ }
protected _body => NULL protected _directory => string(2) "pc" protected _controller => string(4) "line" protected _action => string(4) "list" protected _uri => string(11) "lines/nanou" protected _external => bool FALSE protected _params => array(2) ( "destpy" => string(5) "nanou" "sign" => string(0) "" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(2){ protected _previous_environment => NULL protected _cache => NULL }
}{ protected _status => integer 200 protected _header => object HTTP_Header(0)
}{ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }111 throw new HTTP_Exception_404('The requested URL :uri was not found on this server.', 112 array(':uri' => $request->uri())); 113 } 114 115 $method = $class->getMethod('action_'.$action); 116 $method->invoke($controller); 117 118 // Execute the "after action" method 119 $class->getMethod('after')->invoke($controller); 120 } 121 catch (Exception $e)
-
SYSPATH/classes/kohana/request/client.php [ 64 ] » Kohana_Request_Client_Internal->execute_request(arguments)
0
object Request(20)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5)
{ protected _callback => NULL protected _uri => string(108) "lines/(<destpy>)(<sign>)(-<dayid>)(-<priceid>)(-<sorttype>)(-<displaytype>)(-<startcityid>)(-<attrid>)(-<p>)" protected _regex => array(9) ( "destpy" => string(12) "[0-9a-zA-Z]+" "sign" => string(3) "\/?" "dayid" => string(6) "[0-9]+" "priceid" => string(6) "[0-9]+" "sorttype" => string(6) "[0-9]+" "displaytype" => string(4) "[^-]" "startcityid" => string(6) "[0-9]+" "attrid" => string(7) "[0-9_]+" "p" => string(6) "[0-9]+" ) protected _defaults => array(3) ( "directory" => string(2) "pc" "controller" => string(4) "line" "action" => string(4) "list" ) protected _route_regex => string(233) "#^lines/(?:(?P<destpy>[0-9a-zA-Z]+))?(?:(?P<sign>\/?))?(?:-(?P<dayid>[0-9]+))?(?:-(?P<priceid>[0-9]+))?(?:-(?P<sorttype>[0-9]+)) …" }
protected _routes => array(0) protected _response => object Response(5){ protected _status => integer 200 protected _header => object HTTP_Header(0)
protected _header => object HTTP_Header(0){ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }{ }
protected _body => NULL protected _directory => string(2) "pc" protected _controller => string(4) "line" protected _action => string(4) "list" protected _uri => string(11) "lines/nanou" protected _external => bool FALSE protected _params => array(2) ( "destpy" => string(5) "nanou" "sign" => string(0) "" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(2){ protected _previous_environment => NULL protected _cache => NULL }
}59 public function execute(Request $request) 60 { 61 if ($this->_cache instanceof HTTP_Cache) 62 return $this->_cache->execute($this, $request); 63 64 return $this->execute_request($request); 65 } 66 67 /** 68 * Processes the request passed to it and returns the response from 69 * the URI resource identified.
-
SYSPATH/classes/kohana/request.php [ 1160 ] » Kohana_Request_Client->execute(arguments)
0
object Request(20)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5)
{ protected _callback => NULL protected _uri => string(108) "lines/(<destpy>)(<sign>)(-<dayid>)(-<priceid>)(-<sorttype>)(-<displaytype>)(-<startcityid>)(-<attrid>)(-<p>)" protected _regex => array(9) ( "destpy" => string(12) "[0-9a-zA-Z]+" "sign" => string(3) "\/?" "dayid" => string(6) "[0-9]+" "priceid" => string(6) "[0-9]+" "sorttype" => string(6) "[0-9]+" "displaytype" => string(4) "[^-]" "startcityid" => string(6) "[0-9]+" "attrid" => string(7) "[0-9_]+" "p" => string(6) "[0-9]+" ) protected _defaults => array(3) ( "directory" => string(2) "pc" "controller" => string(4) "line" "action" => string(4) "list" ) protected _route_regex => string(233) "#^lines/(?:(?P<destpy>[0-9a-zA-Z]+))?(?:(?P<sign>\/?))?(?:-(?P<dayid>[0-9]+))?(?:-(?P<priceid>[0-9]+))?(?:-(?P<sorttype>[0-9]+)) …" }
protected _routes => array(0) protected _response => object Response(5){ protected _status => integer 200 protected _header => object HTTP_Header(0)
protected _header => object HTTP_Header(0){ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }{ }
protected _body => NULL protected _directory => string(2) "pc" protected _controller => string(4) "line" protected _action => string(4) "list" protected _uri => string(11) "lines/nanou" protected _external => bool FALSE protected _params => array(2) ( "destpy" => string(5) "nanou" "sign" => string(0) "" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(2){ protected _previous_environment => NULL protected _cache => NULL }
}1155 throw new Request_Exception('Unable to execute :uri without a Kohana_Request_Client', array( 1156 ':uri' => $this->_uri, 1157 )); 1158 } 1159 1160 return $this->_client->execute($this); 1161 } 1162 1163 /** 1164 * Returns whether this request is the initial request Kohana received. 1165 * Can be used to test for sub requests.
-
DOCROOT/index.php [ 129 ] » Kohana_Request->execute()
124 require APPPATH.'bootstrap'.EXT; 125 126 127 if ( ! defined('SUPPRESS_REQUEST')) { 128 echo Request::factory() 129 ->execute() 130 ->send_headers(true) 131 ->body(); 132 }