array(4) {
  ["hasError"]=>
  bool(false)
  ["ResponseObj"]=>
  array(1) {
    ["Items"]=>
    array(4) {
      [0]=>
      array(41) {
        ["row_num"]=>
        string(1) "1"
        ["uid"]=>
        string(5) "11723"
        ["master_id"]=>
        string(3) "388"
        ["locale"]=>
        string(2) "tc"
        ["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) "11213"
        ["master_id"]=>
        string(2) "65"
        ["locale"]=>
        string(2) "tc"
        ["ranking"]=>
        string(1) "1"
        ["display_date"]=>
        string(19) "2019-05-26 00:00:00"
        ["store"]=>
        string(3) "tst"
        ["title"]=>
        string(22) "SOGO Rewards 會員日"
        ["event_period"]=>
        string(14) "27/9-6/10/2019"
        ["template"]=>
        string(1) "2"
        ["description"]=>
        string(744) "請按此瀏覽有關SOGO Rewards會員日活動及優惠詳情。
於27/9至6/10期間,會員可於SOGO Rewards會員日尊享有以下優惠: 推廣生意的競賽牌照號碼: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) "11354" ["master_id"]=> string(3) "385" ["locale"]=> string(2) "tc" ["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) "11243" ["master_id"]=> string(3) "377" ["locale"]=> string(2) "tc" ["ranking"]=> string(1) "4" ["display_date"]=> string(19) "2019-09-03 00:00:00" ["store"]=> string(3) "tst" ["title"]=> string(45) "秋日幸運大獎賞終極獎賞得獎名單" ["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) "tc" } [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) } } }
SOGO
Caring Company 2018/2019