Invision Power Services, Inc. * @copyright (c) Invision Power Services, Inc. * @license https://www.invisioncommunity.com/legal/standards/ * @package Invision Community * @subpackage Nexus * @since 01 Apr 2014 */ namespace IPS\nexus\tasks; /* To prevent PHP errors (extending class does not exist) revealing path */ use DateInterval; use DomainException; use Exception; use IPS\DateTime; use IPS\Db; use IPS\Email; use IPS\Math\Number; use IPS\nexus\Customer; use IPS\nexus\Customer\BillingAgreement; use IPS\nexus\Invoice; use IPS\nexus\Invoice\Item\Renewal; use IPS\nexus\Money; use IPS\nexus\Purchase; use IPS\Patterns\ActiveRecordIterator; use IPS\Settings; use IPS\Task; use OutOfRangeException; use function count; use function defined; use function in_array; if ( !defined( '\IPS\SUITE_UNIQUE_KEY' ) ) { header( ( $_SERVER['SERVER_PROTOCOL'] ?? 'HTTP/1.0' ) . ' 403 Forbidden' ); exit; } /** * Send Invoice Warnings Task */ class sendInvoiceWarnings extends Task { /** * Execute * * If ran successfully, should return anything worth logging. Only log something * worth mentioning (don't log "task ran successfully"). Return NULL (actual NULL, not '' or 0) to not log (which will be most cases). * If an error occurs which means the task could not finish running, throw an \IPS\Task\Exception - do not log an error as a normal log. * Tasks should execute within the time of a normal HTTP request. * * @return string|null Message to log or NULL * @throws Task\Exception */ public function execute() : string|null { if ( Settings::i()->cm_invoice_warning ) { $normalCutoff = DateTime::create()->add( new DateInterval( 'PT' . Settings::i()->cm_invoice_generate . 'H' ) )->add( new DateInterval( 'PT' . Settings::i()->cm_invoice_warning . 'H' ) )->getTimestamp(); $billingAgreementCutoff = DateTime::create()->add( new DateInterval( 'PT' . Settings::i()->cm_invoice_warning . 'H' ) )->getTimestamp(); $select = Db::i()->select( '*', 'nexus_purchases', array( 'ps_renewals>0 AND ps_invoice_pending=0 AND ps_invoice_warning_sent=0 AND ps_active=1 AND ps_expire>0 AND ( ( ps_billing_agreement IS NULL AND ps_expirebilling_agreement AND !$purchase->billing_agreement->canceled ) ? $purchase->billing_agreement->id : 0; if ( $purchase->onExpireWarning() ) { $purchase->invoice_warning_sent = 1; $purchase->save(); } else { $groupedPurchases[ $purchase->member->member_id ][ $agreementId ][ $purchase->renewal_currency ][ $purchase->id ] = $purchase; } } /* Loop */ foreach ( $groupedPurchases as $memberId => $_groupedPurchases ) { $member = Customer::load( $memberId ); foreach ( $_groupedPurchases as $billingAgreementId => $__groupedPurchases ) { foreach ( $__groupedPurchases as $currency => $purchases ) { $email = NULL; /* Create a temporary invoice (we're not going to save this) so that we know what the charges will be */ $invoice = new Invoice; $invoice->currency = $currency; foreach ( $purchases as $purchase ) { $invoice->addItem( Renewal::create( $purchase ) ); } $invoice->setDefaultTitle(); /* If there is a billing agreement - send an email about that */ $billingAgreement = NULL; if ( $billingAgreementId ) { try { $billingAgreement = BillingAgreement::load( $billingAgreementId ); if ( $billingAgreement->status() == $billingAgreement::STATUS_CANCELED ) { /* BA is cancelled, don't include it in the email */ $billingAgreement = NULL; } } catch ( OutOfRangeException|DomainException ) { } /* Billing agreement may have been cancelled, but not yet marked cancelled */ } if ( $billingAgreement ) { $paymentDate = DateTime::create()->add( new DateInterval( 'PT' . Settings::i()->cm_invoice_warning . 'H' ) )->localeDate( $member ); $email = Email::buildFromTemplate( 'nexus', 'invoiceWarning', array( array(), NULL, $billingAgreement, $invoice, $invoice->summary(), $paymentDate ), Email::TYPE_TRANSACTIONAL ); } /* Otherwise check account credit and cards */ else { $cards = array(); foreach ( new ActiveRecordIterator( Db::i()->select( '*', 'nexus_customer_cards', array( 'card_member=?', $member->member_id ) ), 'IPS\nexus\Customer\CreditCard' ) as $card ) { try { $cardDetails = $card->card; // We're just checking this doesn't throw an exception $cards[] = $card; } catch ( Exception ) { } } $credits = $member->cm_credits; $credit = isset( $credits[ $currency ] ) ? $credits[ $currency ]->amount : ( new Number( '0' ) ); if ( count( $cards ) or $credit->isGreaterThanZero() ) { $paymentDate = DateTime::create()->add( new DateInterval( 'PT' . Settings::i()->cm_invoice_warning . 'H' ) )->localeDate( $member ); $email = Email::buildFromTemplate( 'nexus', 'invoiceWarning', array( $cards, isset( $credits[ $currency ] ) ? $credits[ $currency ] : ( new Money( 0, $currency ) ), NULL, $invoice, $invoice->summary(), $paymentDate ), Email::TYPE_TRANSACTIONAL ); } } /* Send the email */ if ( $email ) { $email->send( $member, array_map( function( $contact ) { return $contact->alt_id->email; }, iterator_to_array( $member->alternativeContacts( array( 'billing=1' ) ) ) ), ( ( in_array( 'invoice_warn', explode( ',', Settings::i()->nexus_notify_copy_types ) ) AND Settings::i()->nexus_notify_copy_email ) ? explode( ',', Settings::i()->nexus_notify_copy_email ) : array() ) ); } /* Update Purchases */ Db::i()->update( 'nexus_purchases', array( 'ps_invoice_warning_sent' => 1 ), Db::i()->in( 'ps_id', array_keys( $purchases ) ) ); } } } } return null; } /** * Cleanup * * If your task takes longer than 15 minutes to run, this method * will be called before execute(). Use it to clean up anything which * may not have been done * * @return void */ public function cleanup() : void { } }