is returned with an info message.
*
* @param integer $object_id Contact ID.
* @return string HTML that can be used to render the Subscriptions Table.
*/
private function generate_subscriptions_tab_html( $object_id = -1 ) {
$subscriptions = array();
if ( zeroBSCRM_getClientPortalUserID( $object_id ) > 0 ) {
// Retrieve any subs against the main email or aliases.
$subscriptions = $this->get_contact_subscriptions( $object_id );
}
if ( count( $subscriptions ) === 0 ) {
return '
' . __( 'This contact does not have any WooCommerce Subscriptions yet.', 'zero-bs-crm' ) . '
';
}
$html = '';
$html .= '
';
$html .= '
';
$html .= '';
$html .= '| ' . __( 'Subscription', 'zero-bs-crm' ) . ' | ';
$html .= '' . __( 'Status', 'zero-bs-crm' ) . ' | ';
$html .= '' . __( 'Amount', 'zero-bs-crm' ) . ' | ';
$html .= '' . __( 'Start', 'zero-bs-crm' ) . ' | ';
$html .= '' . __( 'Renews', 'zero-bs-crm' ) . ' | ';
$html .= '
';
$html .= '';
foreach ( $subscriptions as $order_id ) {
$order = wc_get_order( $order_id );
$status = $order->get_status();
$date_created = $order->get_date_created();
$date_renew = $order->get_date( 'next_payment_date' );
$price = $order->get_formatted_order_total();
$name = '';
$sub_link = admin_url( "post.php?post={$order_id}&action=edit" );
$created = jpcrm_uts_to_date_str( strtotime( $date_created ) );
$next = jpcrm_uts_to_date_str( strtotime( $date_renew ) );
$html .= '';
$html .= '| ' . $name . __( ' Subscription #', 'zero-bs-crm' ) . $order_id . ' | ';
$html .= '' . $status . ' | ';
$html .= '' . $price . ' | ';
$html .= '' . $created . ' | ';
$html .= '' . $next . ' | ';
$html .= '
';
}
$html .= '';
$html .= '
';
$html .= '
';
return $html;
}
/**
* Generate HTML for memberships contact vitals tab
*/
private function generate_memberships_tab_html( $object_id = -1 ) {
$data = $this->get_contact_memberships( $object_id );
if ( $data['message'] === 'notfound' || count( $data['memberships'] ) <= 0 ) {
return '
' . __( 'This contact does not have any WooCommerce Memberships yet.', 'zero-bs-crm' ) . '
';
}
$memberships = $data['memberships'];
$html = '';
$html .= '
';
$html .= '
';
$html .= '';
$html .= '| ' . __( 'Membership', 'zero-bs-crm' ) . ' | ';
$html .= '' . __( 'Status', 'zero-bs-crm' ) . ' | ';
$html .= '' . __( 'Name', 'zero-bs-crm' ) . ' | ';
$html .= '' . __( 'Start', 'zero-bs-crm' ) . ' | ';
$html .= '' . __( 'Expires', 'zero-bs-crm' ) . ' | ';
$html .= '
';
$html .= '';
foreach ( $memberships as $membership ) {
// populate fields
$member_id = $membership->id;
$status = $this->display_membership_status( $membership->get_status() );
$name = $membership->plan->name;
$date_expires = $membership->get_end_date( 'Y-m-d H:i:s' );
$date_created = $membership->get_start_date();
$created = jpcrm_uts_to_date_str( strtotime( $date_created ) );
if ( empty( $date_expires ) ) {
$expires = __( 'Never', 'zero-bs-crm' );
} else {
$expires = jpcrm_uts_to_date_str( strtotime( $date_expires ) );
}
$membership_link = admin_url( 'post.php?post=' . $membership->id . '&action=edit' );
$html .= '';
$html .= '| ' . sprintf( __( ' Membership #%s', 'zero-bs-crm' ), $member_id ) . ' | ';
$html .= '' . $status . ' | ';
$html .= '' . $name . ' | ';
$html .= '' . $created . ' | ';
$html .= '' . $expires . ' | ';
$html .= '
';
}
$html .= '';
$html .= '
';
$html .= '
';
return $html;
}
/**
* Helper to display membership statuses
*/
private function display_membership_status( $status = '' ){
$woocommerce_statuses = array(
'wcm-active' => __('active', 'zero-bs-crm'),
'wcm-complimentary' => __('complimentary', 'zero-bs-crm'),
'wcm-pending' => __('pending', 'zero-bs-crm'),
'wcm-delayed' => __('delayed', 'zero-bs-crm'),
'wcm-pending-cancelletion' => __('pending cancellation', 'zero-bs-crm'),
'wcm-paused' => __('paused', 'zero-bs-crm'),
'wcm-expired' => __('expired', 'zero-bs-crm'),
'wcm-cancelled' => __('cancelled', 'zero-bs-crm')
);
$display_status = $status;
if ( array_key_exists( $status, $woocommerce_statuses ) ){
$display_status = $woocommerce_statuses[$status];
}
return $display_status;
}
/**
* Retrieves memberships for a contact
*/
private function get_contact_memberships( $object_id = -1 ){
$wp_id = zeroBS_getCustomerWPID( $object_id );
if ( $wp_id > 0 ){
return array(
'message' => 'success',
'memberships' => wc_memberships_get_user_memberships( $wp_id )
);
} else {
return array(
'message' => 'notfound',
'memberships' => array()
);
}
}
/**
* Retrieves any Woo Subscriptions against a contact
*
* @param int $object_id Contact ID.
*/
private function get_contact_subscriptions( $object_id = -1 ) {
$all_sub_statuses = array_keys( wcs_get_subscription_statuses() );
$subscription_ids = array();
if ( $object_id > 0 ) {
// 1 - get the subscription IDs for the attached wp user
$user_id = zeroBS_getCustomerWPID( $object_id );
if ( $user_id > 0 ) {
$args = array(
'customer_id' => $user_id,
'status' => $all_sub_statuses,
'type' => 'shop_subscription',
'return' => 'ids',
);
$subscription_ids = wc_get_orders( $args );
}
// 2 - find subs for all emails (inc aliases)
global $zbs;
$emails = $zbs->DAL->contacts->getContactEmails( $object_id ); // phpcs:ignore WordPress.NamingConventions.ValidVariableName.UsedPropertyNotSnakeCase
if ( is_array( $emails ) ) {
foreach ( $emails as $email ) {
if ( empty( $email ) ) {
continue;
}
$args = array(
'billing_email' => $email,
'status' => $all_sub_statuses,
'type' => 'shop_subscription',
'return' => 'ids',
);
$subscription_ids_by_email = wc_get_orders( $args );
$subscription_ids = array_merge( $subscription_ids, $subscription_ids_by_email );
}
}
// 3 - remove any duplicate IDs between array_1 and array_2
$subscription_ids = array_unique( $subscription_ids, SORT_REGULAR );
}
return $subscription_ids;
}
}