array(4) {
["hasError"]=>
bool(false)
["ResponseObj"]=>
array(1) {
["Items"]=>
array(4) {
[0]=>
array(41) {
["row_num"]=>
string(1) "1"
["uid"]=>
string(5) "10526"
["master_id"]=>
string(2) "16"
["locale"]=>
string(2) "tc"
["ranking"]=>
string(1) "1"
["display_date"]=>
string(19) "2019-05-28 00:00:00"
["store"]=>
string(3) "cwb"
["title"]=>
string(16) "SOGO Weekly News"
["event_period"]=>
string(14) "12/6-18/6/2019"
["template"]=>
string(1) "1"
["description"]=>
string(0) ""
["pdf"]=>
string(0) ""
["url_name"]=>
string(0) ""
["happening"]=>
string(1) "1"
["highlight"]=>
string(1) "1"
["show_at_index"]=>
string(1) "1"
["thumbnail"]=>
string(85) "/uploads/images/mainsite/event%26promotion/original_image/20190612/120619_CWB_376.jpg"
["thumb_alt"]=>
string(16) "SOGO Weekly News"
["index_image"]=>
string(69) "/uploads/images/mainsite/event%26promotion/theme20195/NEW%20CWBsn.jpg"
["index_alt"]=>
string(16) "SOGO Weekly News"
["link"]=>
string(0) ""
["popup_type"]=>
string(1) "1"
["happening_end_date"]=>
string(19) "2029-06-05 00:00:00"
["extracted_pdf"]=>
string(1) "0"
["version"]=>
string(3) "355"
["created_by"]=>
string(1) "1"
["created_date"]=>
string(19) "2014-05-09 13:18:34"
["created_ip"]=>
string(14) "192.168.176.57"
["modified_by"]=>
string(2) "19"
["modified_date"]=>
string(19) "2019-06-11 16:04:18"
["modified_ip"]=>
string(15) "220.241.212.211"
["approved_by"]=>
NULL
["approved_date"]=>
NULL
["approved_ip"]=>
NULL
["submitted_by"]=>
string(2) "20"
["submitted_date"]=>
string(19) "2019-06-11 21:57:57"
["submitted_ip"]=>
string(12) "1.36.186.151"
["commited"]=>
string(1) "1"
["approval_status"]=>
string(1) "3"
["active"]=>
string(1) "1"
["deleted"]=>
string(1) "0"
}
[1]=>
array(41) {
["row_num"]=>
string(1) "2"
["uid"]=>
string(5) "10478"
["master_id"]=>
string(3) "151"
["locale"]=>
string(2) "tc"
["ranking"]=>
string(1) "4"
["display_date"]=>
string(19) "2019-06-04 00:00:00"
["store"]=>
string(3) "cwb"
["title"]=>
string(40) "陶藝精神-日本與香港陶藝展覽"
["event_period"]=>
string(13) "5/6-18/6/2019"
["template"]=>
string(1) "1"
["description"]=>
string(0) ""
["pdf"]=>
string(42) "/uploads/files/Pdf/e-book/201811yayoib.pdf"
["url_name"]=>
string(11) "201811yayoi"
["happening"]=>
string(1) "1"
["highlight"]=>
string(1) "1"
["show_at_index"]=>
string(1) "1"
["thumbnail"]=>
string(96) "/uploads/images/mainsite/event%26promotion/original_image/20190605/20190605_16F_thumbnail376.jpg"
["thumb_alt"]=>
string(0) ""
["index_image"]=>
string(65) "/uploads/images/mainsite/event%26promotion/theme20195/16F_new.jpg"
["index_alt"]=>
string(0) ""
["link"]=>
string(43) "https://www.sogo.com.hk/edm/201811yayoi.pdf"
["popup_type"]=>
string(1) "1"
["happening_end_date"]=>
string(19) "2019-06-19 00:00:00"
["extracted_pdf"]=>
string(1) "0"
["version"]=>
string(3) "201"
["created_by"]=>
string(1) "1"
["created_date"]=>
string(19) "2015-11-17 16:24:38"
["created_ip"]=>
string(9) "127.0.0.1"
["modified_by"]=>
string(2) "19"
["modified_date"]=>
string(19) "2019-06-03 10:59:43"
["modified_ip"]=>
string(15) "220.241.212.211"
["approved_by"]=>
NULL
["approved_date"]=>
NULL
["approved_ip"]=>
NULL
["submitted_by"]=>
string(2) "20"
["submitted_date"]=>
string(19) "2019-06-04 22:00:24"
["submitted_ip"]=>
string(12) "1.36.186.151"
["commited"]=>
string(1) "1"
["approval_status"]=>
string(1) "3"
["active"]=>
string(1) "1"
["deleted"]=>
string(1) "0"
}
[2]=>
array(41) {
["row_num"]=>
string(1) "3"
["uid"]=>
string(5) "10529"
["master_id"]=>
string(1) "4"
["locale"]=>
string(2) "tc"
["ranking"]=>
string(1) "5"
["display_date"]=>
string(19) "2019-06-11 00:00:00"
["store"]=>
string(3) "cwb"
["title"]=>
string(27) "夏日名牌女士服飾展"
["event_period"]=>
string(15) "12/6 -17/6/2019"
["template"]=>
string(1) "1"
["description"]=>
string(0) ""
["pdf"]=>
string(0) ""
["url_name"]=>
string(0) ""
["happening"]=>
string(1) "1"
["highlight"]=>
string(1) "1"
["show_at_index"]=>
string(1) "1"
["thumbnail"]=>
string(92) "/uploads/images/mainsite/event%26promotion/original_image/20190612/120619_21F_376x356(1).jpg"
["thumb_alt"]=>
string(19) "21/F崇光宴會廳"
["index_image"]=>
string(61) "/uploads/images/mainsite/event%26promotion/theme20195/21F.jpg"
["index_alt"]=>
string(19) "21/F崇光宴會廳"
["link"]=>
string(68) "http://www.sogo.com.hk/cwb/en/thankfulweek/site/index.php?section=54"
["popup_type"]=>
string(1) "2"
["happening_end_date"]=>
string(19) "2019-06-18 00:00:00"
["extracted_pdf"]=>
string(1) "0"
["version"]=>
string(3) "319"
["created_by"]=>
string(1) "1"
["created_date"]=>
string(19) "2014-05-07 14:59:32"
["created_ip"]=>
string(9) "127.0.0.1"
["modified_by"]=>
string(2) "19"
["modified_date"]=>
string(19) "2019-06-11 16:05:21"
["modified_ip"]=>
string(15) "220.241.212.211"
["approved_by"]=>
NULL
["approved_date"]=>
NULL
["approved_ip"]=>
NULL
["submitted_by"]=>
string(2) "20"
["submitted_date"]=>
string(19) "2019-06-11 21:57:57"
["submitted_ip"]=>
string(12) "1.36.186.151"
["commited"]=>
string(1) "1"
["approval_status"]=>
string(1) "3"
["active"]=>
string(1) "1"
["deleted"]=>
string(1) "0"
}
[3]=>
array(41) {
["row_num"]=>
string(1) "4"
["uid"]=>
string(5) "10493"
["master_id"]=>
string(1) "3"
["locale"]=>
string(2) "tc"
["ranking"]=>
string(1) "6"
["display_date"]=>
string(19) "2019-05-29 00:00:00"
["store"]=>
string(3) "cwb"
["title"]=>
string(15) "亞洲美食節"
["event_period"]=>
string(13) "5/6-18/6/2019"
["template"]=>
string(1) "1"
["description"]=>
string(0) ""
["pdf"]=>
string(45) "/uploads/files/Pdf/e-book/b2cnyhpbl20171_.pdf"
["url_name"]=>
string(14) "b2cnyhpbl20171"
["happening"]=>
string(1) "1"
["highlight"]=>
string(1) "1"
["show_at_index"]=>
string(1) "1"
["thumbnail"]=>
string(90) "/uploads/images/mainsite/event%26promotion/original_image/20190605/290519_B2_thumbnail.jpg"
["thumb_alt"]=>
string(14) "B2/F Food Fair"
["index_image"]=>
string(71) "/uploads/images/mainsite/event%26promotion/theme20195/NEW-Freshmark.jpg"
["index_alt"]=>
string(22) "B2/F崇光超市通訊"
["link"]=>
string(45) "https://www.sogo.com.hk/edm/b2cnybl201812.pdf"
["popup_type"]=>
string(1) "1"
["happening_end_date"]=>
string(19) "2019-06-19 00:00:00"
["extracted_pdf"]=>
string(1) "0"
["version"]=>
string(3) "266"
["created_by"]=>
string(1) "1"
["created_date"]=>
string(19) "2014-05-07 14:58:11"
["created_ip"]=>
string(9) "127.0.0.1"
["modified_by"]=>
string(2) "19"
["modified_date"]=>
string(19) "2019-06-04 15:23:26"
["modified_ip"]=>
string(15) "220.241.212.211"
["approved_by"]=>
NULL
["approved_date"]=>
NULL
["approved_ip"]=>
NULL
["submitted_by"]=>
string(2) "20"
["submitted_date"]=>
string(19) "2019-06-04 22:00:30"
["submitted_ip"]=>
string(12) "1.36.186.151"
["commited"]=>
string(1) "1"
["approval_status"]=>
string(1) "3"
["active"]=>
string(1) "1"
["deleted"]=>
string(1) "0"
}
}
}
["sql"]=>
string(836) "
SELECT * FROM (
SELECT
@row:=@row+1 as row_num, promotion.*
FROM ms_promotion_master promotion
INNER JOIN (
SELECT master_id, max(version) currentVersion, commited FROM ms_promotion_master
WHERE commited = 1
GROUP BY master_id
) versioning ON
versioning.master_id = promotion.master_id
AND versioning.currentVersion = promotion.version
INNER JOIN (select @row:=0)r
WHERE
promotion.locale = :LOCALE AND
promotion.active = 1 AND
promotion.deleted = 0
AND promotion.store = :store AND
promotion.display_date <= NOW() AND
highlight = :HIGHLIGHT AND
template <> :TEMPLATE
ORDER BY ranking ASC, display_date DESC
) RS
WHERE row_num BETWEEN :START_RECORD AND :END_RECORD
ORDER BY row_num ASC
"
["dbParam"]=>
array(6) {
[0]=>
array(2) {
["name"]=>
string(7) ":LOCALE"
["value"]=>
string(2) "tc"
}
[1]=>
array(2) {
["name"]=>
string(6) ":store"
["value"]=>
string(3) "cwb"
}
[2]=>
array(2) {
["name"]=>
string(10) ":HIGHLIGHT"
["value"]=>
int(1)
}
[3]=>
array(2) {
["name"]=>
string(9) ":TEMPLATE"
["value"]=>
int(4)
}
[4]=>
array(2) {
["name"]=>
string(13) ":START_RECORD"
["value"]=>
int(1)
}
[5]=>
array(2) {
["name"]=>
string(11) ":END_RECORD"
["value"]=>
int(4)
}
}
}
.jpg)
