array(4) {
["hasError"]=>
bool(false)
["ResponseObj"]=>
array(1) {
["Items"]=>
array(4) {
[0]=>
array(41) {
["row_num"]=>
string(1) "1"
["uid"]=>
string(5) "11722"
["master_id"]=>
string(3) "388"
["locale"]=>
string(2) "en"
["ranking"]=>
string(1) "1"
["display_date"]=>
string(19) "2019-10-08 00:00:00"
["store"]=>
string(3) "tst"
["title"]=>
string(16) "SOGO Weekly News"
["event_period"]=>
string(16) "11/12-17/12/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(88) "/uploads/images/mainsite/event%26promotion/original_image/20191210/111219_TST_SN_376.jpg"
["thumb_alt"]=>
string(16) "SOGO Weekly News"
["index_image"]=>
string(72) "/uploads/images/mainsite/event%26promotion/theme201911/Sogo_News_TST.jpg"
["index_alt"]=>
string(16) "SOGO Weekly News"
["link"]=>
string(0) ""
["popup_type"]=>
string(1) "1"
["happening_end_date"]=>
string(19) "2019-12-31 00:00:00"
["extracted_pdf"]=>
string(1) "0"
["version"]=>
string(2) "11"
["created_by"]=>
string(2) "19"
["created_date"]=>
string(19) "2019-10-08 15:28:29"
["created_ip"]=>
string(15) "220.241.212.216"
["modified_by"]=>
string(2) "19"
["modified_date"]=>
string(19) "2019-12-10 16:21:28"
["modified_ip"]=>
string(15) "220.241.212.216"
["approved_by"]=>
NULL
["approved_date"]=>
NULL
["approved_ip"]=>
NULL
["submitted_by"]=>
string(2) "20"
["submitted_date"]=>
string(19) "2019-12-10 22:01:52"
["submitted_ip"]=>
string(12) "112.118.3.92"
["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) "11212"
["master_id"]=>
string(2) "65"
["locale"]=>
string(2) "en"
["ranking"]=>
string(1) "1"
["display_date"]=>
string(19) "2019-05-26 00:00:00"
["store"]=>
string(3) "tst"
["title"]=>
string(17) "SOGO Rewards Days"
["event_period"]=>
string(14) "27/9-6/10/2019"
["template"]=>
string(1) "2"
["description"]=>
string(743) "Please click HERE for details of SOGO Rewards Days.
From 27/9 until 6/10, SOGO Rewards members can enjoy below privileges:
- Earn up to 20X points upon purchase
- Enjoy over 400 brands’ exclusive offers
- Redeem selected product in special price upon accumulated purchase of every $1,500 on the same day
- On 28/9, 29/9, 5/10 & 6/10, join lucky draw game once for a chance to win $10,000 Japan travel voucher or other prizes upon purchase of every $800 on the same day
Trade Promotion Competition License No.: 52631, 52632
"
["pdf"]=>
string(0) ""
["url_name"]=>
string(0) ""
["happening"]=>
string(1) "1"
["highlight"]=>
string(1) "1"
["show_at_index"]=>
string(1) "0"
["thumbnail"]=>
string(111) "/uploads/images/mainsite/event%26promotion/original_image/20190924/sogo%20rewards%20day%20small%20final-376.jpg"
["thumb_alt"]=>
string(17) "SOGO Rewards Days"
["index_image"]=>
string(110) "/uploads/images/mainsite/event%26promotion/original_image/20190924/sogo%20rewards%20day%20small%20final-02.jpg"
["index_alt"]=>
string(17) "SOGO Rewards Days"
["link"]=>
string(26) "https://sogohkcampaign.com"
["popup_type"]=>
string(1) "1"
["happening_end_date"]=>
string(19) "2029-06-01 00:00:00"
["extracted_pdf"]=>
string(1) "0"
["version"]=>
string(3) "302"
["created_by"]=>
string(1) "1"
["created_date"]=>
string(19) "2014-12-16 17:26:26"
["created_ip"]=>
string(9) "127.0.0.1"
["modified_by"]=>
string(1) "1"
["modified_date"]=>
string(19) "2019-09-26 20:27:48"
["modified_ip"]=>
string(15) "220.241.212.216"
["approved_by"]=>
NULL
["approved_date"]=>
NULL
["approved_ip"]=>
NULL
["submitted_by"]=>
string(1) "1"
["submitted_date"]=>
string(19) "2019-09-26 20:28:30"
["submitted_ip"]=>
string(15) "220.241.212.216"
["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) "11353"
["master_id"]=>
string(3) "385"
["locale"]=>
string(2) "en"
["ranking"]=>
string(1) "4"
["display_date"]=>
string(19) "2019-10-04 00:00:00"
["store"]=>
string(3) "tst"
["title"]=>
string(12) "Live In Pink"
["event_period"]=>
string(15) "7/10-29/10/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(119) "/uploads/images/mainsite/event%26promotion/original_image/20191008/071019_WholeStore_Live%20in%20Pink_web_thumbnail.jpg"
["thumb_alt"]=>
string(0) ""
["index_image"]=>
string(114) "/uploads/images/mainsite/event%26promotion/original_image/20191008/071019_Live%20in%20Pink_web%20icon_314x188p.jpg"
["index_alt"]=>
string(0) ""
["link"]=>
string(0) ""
["popup_type"]=>
string(1) "1"
["happening_end_date"]=>
string(19) "2019-10-30 00:00:00"
["extracted_pdf"]=>
string(1) "0"
["version"]=>
string(1) "4"
["created_by"]=>
string(2) "19"
["created_date"]=>
string(19) "2019-10-04 11:25:11"
["created_ip"]=>
string(15) "220.241.212.216"
["modified_by"]=>
string(2) "19"
["modified_date"]=>
string(19) "2019-10-08 16:15:02"
["modified_ip"]=>
string(15) "220.241.212.216"
["approved_by"]=>
NULL
["approved_date"]=>
NULL
["approved_ip"]=>
NULL
["submitted_by"]=>
string(2) "20"
["submitted_date"]=>
string(19) "2019-10-08 16:30:02"
["submitted_ip"]=>
string(15) "220.241.212.216"
["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) "11242"
["master_id"]=>
string(3) "377"
["locale"]=>
string(2) "en"
["ranking"]=>
string(1) "4"
["display_date"]=>
string(19) "2019-09-03 00:00:00"
["store"]=>
string(3) "tst"
["title"]=>
string(44) "Autumn Surprise Grand Lucky Game Winner List"
["event_period"]=>
string(13) "4/9-26/9/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(122) "/uploads/images/mainsite/event%26promotion/original_image/20190930/Autumn%20Surprise%20Winner%20List%20thumbnail-01-01.jpg"
["thumb_alt"]=>
string(0) ""
["index_image"]=>
string(123) "/uploads/images/mainsite/event%26promotion/original_image/20190930/Autumn%20Surprise%20Winner%20List%20thumbnail-314-02.jpg"
["index_alt"]=>
string(0) ""
["link"]=>
string(0) ""
["popup_type"]=>
string(1) "1"
["happening_end_date"]=>
string(19) "2019-11-05 00:00:00"
["extracted_pdf"]=>
string(1) "0"
["version"]=>
string(1) "7"
["created_by"]=>
string(2) "19"
["created_date"]=>
string(19) "2019-08-30 12:37:42"
["created_ip"]=>
string(15) "220.241.212.216"
["modified_by"]=>
string(2) "19"
["modified_date"]=>
string(19) "2019-10-03 18:11:02"
["modified_ip"]=>
string(15) "220.241.212.216"
["approved_by"]=>
NULL
["approved_date"]=>
NULL
["approved_ip"]=>
NULL
["submitted_by"]=>
string(2) "20"
["submitted_date"]=>
string(19) "2019-10-04 09:41:51"
["submitted_ip"]=>
string(15) "220.241.212.216"
["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) "en"
}
[1]=>
array(2) {
["name"]=>
string(6) ":store"
["value"]=>
string(3) "tst"
}
[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)
}
}
}