✅ DB connected!!
🗑️ Older than 7 days records deleted successfully!
✅ Data inserted successfully! Rows inserted: 0
SELECT TP.recuring_inappplan_id, TCS.*, tmp.record_id
FROM tbl_customer_subscriptions AS TCS
JOIN tbl_packages AS TP ON TCS.package_id = TP.id
JOIN (
SELECT record_id
FROM temp_lac
WHERE processed_at IS NULL OR processed_at <= NOW() - INTERVAL 4 HOUR
ORDER BY record_id ASC
LIMIT 20
) AS tmp ON TCS.id = tmp.record_id
GROUP BY TCS.gateway_subscription_id
ORDER BY TCS.id DESC
Array
(
[recuring_inappplan_id] => com.maz.combo587.rec.1month.3.99usd
[id] => 11730
[app_id] => 5013
[order_id] => 12883
[mandate_id] =>
[merchant_id] =>
[mandate_token] =>
[payment_method_type] =>
[payer_vpa] =>
[txn_type] =>
[trans_id] => GPA.3346-1438-5911-78722
[pg_ref_id] => GPA.3346-1438-5911-78722
[device_id] => 1
[gateway_subscription_id] => GPA.3346-1438-5911-78722
[pg_payment_data] =>
[channel] =>
[package_id] => 228
[package_title] => Monthly
[package_code] =>
[package_type] => 0
[package_mode] => OTT
[price] => 3.99
[u_price] => 0.00
[basic_amount] => 0.00
[tax_amt] => 0
[subscriber_id] => 42450
[msisdn] =>
[role_type] => 0
[gateway_type] => 3
[pg_name] => google_inapp_purchase
[pg_mode] =>
[region_type] => 0
[local_user] => 0
[state_code] => 0
[period] => Month
[period_interval] => 1
[trial_period] =>
[trial_length] =>
[subscription_type] => 0
[output_video_limit] => 0
[additional_cost_per_unit] => 0
[no_videos] =>
[no_plays] =>
[status] => 7
[ack_status] => 0
[platform] => platform
[purchase_type] => PURCHASED
[extended_status] => 0
[start_date] => 2026-04-05 14:28:28
[end_date] => 2026-04-12 14:28:28
[autorenew] => 1
[currency_id] => 4
[currency] => USD
[u_currency] =>
[created] => 2026-04-05 14:27:51
[updated_at] => 2026-04-12 14:30:02
[is_cancelled] => 0
[cancelled_at] =>
[deactivation_type] =>
[deactivation_date] =>
[renewal_date] =>
[renewal_count] => 0
[mandate_revoke] => 0
[recurring] => 0
[purchase_token] => ppmjpdehmiccgnpghieakpno.AO-J1OxdkREHzrHP3b7kuUTYZUUK91pZdLo6eoJQwgvBk2CqPC9K-TY40ZHPQK0yxHlJGmNHBmw5QtbfT1gcH8leTn2CyBVRuQ
[package_name] =>
[email_sent] => 0
[back_dated] => 0
[record_id] => 11730
)
Checking: com.maz.combo587 | Product: com.maz.combo587.rec.1month.3.99usd | Token: ppmjpdehmiccgnpghieakpno.AO-J1OxdkREHzrHP3b7kuUTYZUUK91pZdLo6eoJQwgvBk2CqPC9K-TY40ZHPQK0yxHlJGmNHBmw5QtbfT1gcH8leTn2CyBVRuQ
Price : 3.99
priceCurrency : USD
Start Date: 2026-04-05 14:28:28
End Date: 2026-04-12 14:28:28
Original Order ID: GPA.3346-1438-5911-78722
Trimmed Order ID: GPA.3346-1438-5911-78722
================ Subscription Update or Skip ================
SELECT *
FROM tbl_customer_subscriptions
WHERE subscriber_id = '42450'
AND `status` IN ('2','3')
AND pg_name = 'google_inapp_purchase'
ORDER BY id DESC
LIMIT 1
Array
(
[recuring_inappplan_id] => com.maz.core.587.sub4
[id] => 10561
[app_id] => 5013
[order_id] => 6824
[mandate_id] =>
[merchant_id] =>
[mandate_token] =>
[payment_method_type] =>
[payer_vpa] =>
[txn_type] =>
[trans_id] => GPA.3320-5908-2292-59926
[pg_ref_id] => GPA.3320-5908-2292-59926
[device_id] => 0
[gateway_subscription_id] => GPA.3320-5908-2292-59926
[pg_payment_data] => {"acknowledgementState":1,"autoRenewing":true,"autoResumeTimeMillis":null,"cancelReason":null,"countryCode":"US","developerPayload":"","emailAddress":null,"expiryTimeMillis":"1776173113728","externalAccountId":null,"familyName":null,"givenName":null,"kind":"androidpublisher#subscriptionPurchase","linkedPurchaseToken":null,"obfuscatedExternalAccountId":null,"obfuscatedExternalProfileId":null,"orderId":"GPA.3320-5908-2292-59926..10","paymentState":1,"priceAmountMicros":"1990000","priceCurrencyCode":"USD","profileId":null,"profileName":null,"promotionCode":null,"promotionType":null,"purchaseType":null,"startTimeMillis":"1744637113728","userCancellationTimeMillis":null}
[channel] =>
[package_id] => 230
[package_title] => Annual
[package_code] =>
[package_type] => 3
[package_mode] => OTT
[price] => 19.99
[u_price] => 0.00
[basic_amount] => 0.00
[tax_amt] => 0
[subscriber_id] => 38244
[msisdn] =>
[role_type] => 2
[gateway_type] => 3
[pg_name] => google_inapp_purchase
[pg_mode] =>
[region_type] => 1
[local_user] => 1
[state_code] => 0
[period] => Year
[period_interval] => 1
[trial_period] =>
[trial_length] => 0
[subscription_type] => 0
[output_video_limit] => 0
[additional_cost_per_unit] => 0
[no_videos] => 0
[no_plays] => 0
[status] => 7
[ack_status] => 0
[platform] => cron
[purchase_type] => RENEWED
[extended_status] => 0
[start_date] => 2025-04-14 13:25:13
[end_date] => 2026-04-14 13:25:13
[autorenew] => 1
[currency_id] => 4
[currency] => USD
[u_currency] =>
[created] => 2026-03-26 09:26:53
[updated_at] => 2026-04-14 13:30:02
[is_cancelled] => 0
[cancelled_at] =>
[deactivation_type] =>
[deactivation_date] =>
[renewal_date] =>
[renewal_count] => 0
[mandate_revoke] => 0
[recurring] => 0
[purchase_token] => pjabahiocfmnblbbegddhbjl.AO-J1OzMRKs8ElAy5VeFkqpbE9-ZPNlPR6yFDiO2r4sH_tlOeaEMTxWHsJcf7XeD13Huil8OyqG5mxt7GfsKyIpZgm7g5q75Sg
[package_name] =>
[email_sent] => 0
[back_dated] => 1
[record_id] => 10561
)
Checking: com.maz.combo587 | Product: com.maz.core.587.sub4 | Token: pjabahiocfmnblbbegddhbjl.AO-J1OzMRKs8ElAy5VeFkqpbE9-ZPNlPR6yFDiO2r4sH_tlOeaEMTxWHsJcf7XeD13Huil8OyqG5mxt7GfsKyIpZgm7g5q75Sg
Price : 1.99
priceCurrency : USD
Start Date: 2025-04-14 13:25:13
End Date: 2026-05-14 13:25:13
Original Order ID: GPA.3320-5908-2292-59926..11
Trimmed Order ID: GPA.3320-5908-2292-59926
================ Subscription Update or Skip ================
SELECT *
FROM tbl_customer_subscriptions
WHERE subscriber_id = '38244'
AND `status` IN ('2','3')
AND pg_name = 'google_inapp_purchase'
ORDER BY id DESC
LIMIT 1
✅ No update needed, just mark processed_at in temp_lac.
UPDATE temp_lac
SET processed_at = NOW()
WHERE record_id = '10561'
✅ Script finished.