( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`plan_id` IN ( 6, 39, 40, 41, 51, 45, 31, 42, 43, 44, 52 ) AND date_add(sub.`expiry_date`, INTERVAL 8 DAY) <= date_add(NOW(), INTERVAL 1 DAY) AND sub.`autorecurring_type` = 0 ) >= 1
AND ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`plan_id` IN ( 6, 39, 40, 41, 51, 45, 31, 42, 43, 44, 52 ) AND (sub.`autorecurring_type` = 2 OR sub.`autorecurring_type` = 1)) = 0
AND ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`plan_id` IN ( 6, 39, 40, 41, 51, 45, 31, 42, 43, 44, 52 ) AND date_add(sub.`expiry_date`, INTERVAL 8 DAY) > date_add(NOW(), INTERVAL 1 DAY) ) = 0
AND ( SELECT COUNT(*) FROM `#__cbsubs_payments` AS a WHERE a.`for_user_id` = u.`id` AND a.`time_created` > date_sub(NOW(), INTERVAL 366 DAY) AND a.`payment_status` = 'Pending' ) = 0
AND (ue.`cb_crmstate` IN (0, 1, 4, 8) OR ue.`cb_crmstate` IS NULL))
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
DATE_ADD( sub.`expiry_date`, INTERVAL 7 DAY ) >= NOW()
Please Log in to join the conversation.
Please Log in to join the conversation.
Nothing was changed on our end in regards to dispute handling. If it was a dispute notification it will put the subscription in a reversed status. If it was a failed payment notification then it will fail the renewal and simply expire.Also we have noticed that the last failed payment did not reverse the payment but only unsubscribed the subscription. Previously the payment was also reversed and indicated as this on CBSubs. Did you change something or did STRIPE change something ?
Please Log in to join the conversation.