1. LAC DB connected successfully!

=================Entry Start From Here ============

SELECT * FROM gpay_webhooks WHERE disputed = '0' AND status = '0' AND cron_status = '0' AND purchase_type = '0' AND created >= NOW() - INTERVAL 30 DAY ORDER BY id DESC LIMIT 20



======================= I am in subscription Renew ==================

Webhook tbl Record Id is => 5596 and order_id is => 7687 and GPA ID is => GPA.3318-7430-8652-80716..2

select package_id from tbl_customer_subscriptions where order_id='7687' order by id desc limit 1

Google\Service\AndroidPublisher\SubscriptionPurchase Object
(
    [internal_gapi_mappings:protected] => Array
        (
        )

    [modelData:protected] => Array
        (
        )

    [processed:protected] => Array
        (
        )

    [acknowledgementState] => 1
    [autoRenewing] => 1
    [autoResumeTimeMillis] => 
    [cancelReason] => 
    [cancelSurveyResultType:protected] => Google\Service\AndroidPublisher\SubscriptionCancelSurveyResult
    [cancelSurveyResultDataType:protected] => 
    [countryCode] => US
    [developerPayload] => 
    [emailAddress] => 
    [expiryTimeMillis] => 1824324355274
    [externalAccountId] => 
    [familyName] => 
    [givenName] => 
    [introductoryPriceInfoType:protected] => Google\Service\AndroidPublisher\IntroductoryPriceInfo
    [introductoryPriceInfoDataType:protected] => 
    [kind] => androidpublisher#subscriptionPurchase
    [linkedPurchaseToken] => 
    [obfuscatedExternalAccountId] => 
    [obfuscatedExternalProfileId] => 
    [orderId] => GPA.3318-7430-8652-80716..2
    [paymentState] => 1
    [priceAmountMicros] => 19990000
    [priceChangeType:protected] => Google\Service\AndroidPublisher\SubscriptionPriceChange
    [priceChangeDataType:protected] => 
    [priceCurrencyCode] => USD
    [profileId] => 
    [profileName] => 
    [promotionCode] => 
    [promotionType] => 
    [purchaseType] => 
    [startTimeMillis] => 1727124413611
    [userCancellationTimeMillis] => 
)

Deprecated: substr(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/html/webhook_lac/Lac-ack-google-pubsub.php on line 186
CUSTOMER GOOGLE =
CUSTOMER WEBHOOK = 38685
GPAY GOOGLE = GPA.3318-7430-8652-80716..2
GPAY WEBHHOK = GPA.3318-7430-8652-80716..2
ORDER GOOGLE =
ORDER WEBHOOK = 7687

Google Amount = 19.99