PHP PMProEmail::sendMembershipExpiringEmail方法代码示例

function pmpro_cron_expiration_warnings()
{
    global $wpdb;
    //make sure we only run once a day
    $today = date_i18n("Y-m-d 00:00:00", current_time("timestamp"));
    $pmpro_email_days_before_expiration = apply_filters("pmpro_email_days_before_expiration", 7);
    // Configure the interval to select records from
    $interval_start = $today;
    $interval_end = date_i18n('Y-m-d 00:00:00', strtotime("{$today} +{$pmpro_email_days_before_expiration} days", current_time('timestamp')));
    //look for memberships that are going to expire within one week (but we haven't emailed them within a week)
    $sqlQuery = $wpdb->prepare("SELECT DISTINCT\n  \t\t\t\tmu.user_id,\n  \t\t\t\tmu.membership_id,\n  \t\t\t\tmu.startdate,\n \t\t\t\tmu.enddate,\n \t\t\t\tum.meta_value AS notice \t\t\t  \n \t\t\tFROM {$wpdb->pmpro_memberships_users} AS mu\n \t\t\t  LEFT JOIN {$wpdb->usermeta} AS um ON um.user_id = mu.user_id\n            \tAND um.meta_key = %s\n\t\t\tWHERE ( um.meta_value IS NULL OR DATE_ADD(um.meta_value, INTERVAL %d DAY) < %s )  \n\t\t\t\tAND ( mu.status = 'active' )\t\t   \n \t\t\t    AND ( mu.enddate IS NOT NULL )\n \t\t\t    AND ( mu.enddate <> '0000-00-00 00:00:00' )\n \t\t\t    AND ( mu.enddate BETWEEN %s AND %s )\t\t  \n \t\t\t    AND ( mu.membership_id <> 0 OR mu.membership_id <> NULL )\n\t\t\tORDER BY mu.enddate\n\t\t\t", "pmpro_expiration_notice", $pmpro_email_days_before_expiration, $today, $interval_start, $interval_end);
    if (defined('PMPRO_CRON_LIMIT')) {
        $sqlQuery .= " LIMIT " . PMPRO_CRON_LIMIT;
    }
    $expiring_soon = $wpdb->get_results($sqlQuery);
    foreach ($expiring_soon as $e) {
        $send_email = apply_filters("pmpro_send_expiration_warning_email", true, $e->user_id);
        if ($send_email) {
            //send an email
            $pmproemail = new PMProEmail();
            $euser = get_userdata($e->user_id);
            $pmproemail->sendMembershipExpiringEmail($euser);
            if (current_user_can('manage_options')) {
                printf(__("Membership expiring email sent to %s. ", "pmpro"), $euser->user_email);
            } else {
                echo ". ";
            }
        }
        //delete all user meta for this key to prevent duplicate user meta rows
        delete_user_meta($e->user_id, "pmpro_expiration_notice");
        //update user meta so we don't email them again
        update_user_meta($e->user_id, "pmpro_expiration_notice", $today);
    }
}

function pmpro_cron_expiration_warnings()
{
    global $wpdb;
    //make sure we only run once a day
    $today = date("Y-m-d 00:00:00", current_time("timestamp"));
    $pmpro_email_days_before_expiration = apply_filters("pmpro_email_days_before_expiration", 7);
    //look for memberships that are going to expire within one week (but we haven't emailed them within a week)
    $sqlQuery = $wpdb->prepare("SELECT mu.user_id, mu.membership_id, mu.startdate, mu.enddate\n\t\t FROM {$wpdb->pmpro_memberships_users} AS mu\n         \tLEFT JOIN {$wpdb->usermeta} AS um ON um.user_id = mu.user_id AND um.meta_key = %s\n\t\t\tINNER JOIN {$wpdb->users} AS u ON u.ID = mu.user_id AND (\n\t\t\t\tmu.membership_id <> 0 OR\n\t\t\t\tmu.membership_id <> NULL OR\n\t\t\t\tmu.membership_id <> 'NULL'\n\t\t\t)\n\t\t WHERE mu.status = 'active'\n      \t \tAND mu.enddate IS NOT NULL\n\t\t\tAND mu.enddate <> ''\n\t\t\tAND mu.enddate <> '0000-00-00 00:00:00'\n\t\t\tAND DATE_SUB(mu.enddate, INTERVAL %d Day) <= %s\n\t\t\tAND (um.meta_value IS NULL OR DATE_ADD(um.meta_value, INTERVAL %d Day) <= %s)\n\t\tORDER BY mu.enddate", "pmpro_expiration_notice", $pmpro_email_days_before_expiration, $today, $pmpro_email_days_before_expiration, $today);
    if (defined('PMPRO_CRON_LIMIT')) {
        $sqlQuery .= " LIMIT " . PMPRO_CRON_LIMIT;
    }
    $expiring_soon = $wpdb->get_results($sqlQuery);
    foreach ($expiring_soon as $e) {
        $send_email = apply_filters("pmpro_send_expiration_warning_email", true, $e->user_id);
        if ($send_email) {
            //send an email
            $pmproemail = new PMProEmail();
            $euser = get_userdata($e->user_id);
            $pmproemail->sendMembershipExpiringEmail($euser);
            if (current_user_can('manage_options')) {
                printf(__("Membership expiring email sent to %s. ", "pmpro"), $euser->user_email);
            } else {
                echo ". ";
            }
        }
        //update user meta so we don't email them again
        update_user_meta($e->user_id, "pmpro_expiration_notice", $today);
    }
}

	function pmpro_cron_expiration_warnings()
	{	
		global $wpdb;
		
		//make sure we only run once a day
		$today = date("Y-m-d 00:00:00");
		
		$pmpro_email_days_before_expiration = apply_filters("pmpro_email_days_before_expiration", 7);
				
		//look for memberships that are going to expire within one week (but we haven't emailed them within a week)
		$sqlQuery = "SELECT mu.user_id, mu.membership_id, mu.startdate, mu.enddate FROM $wpdb->pmpro_memberships_users mu LEFT JOIN $wpdb->usermeta um ON um.user_id = mu.user_id AND um.meta_key = 'pmpro_expiration_notice' WHERE mu.status = 'active' AND mu.enddate IS NOT NULL AND mu.enddate <> '' AND mu.enddate <> '0000-00-00 00:00:00' AND DATE_SUB(mu.enddate, INTERVAL " . $pmpro_email_days_before_expiration . " Day) <= '" . $today . "' AND (um.meta_value IS NULL OR DATE_ADD(um.meta_value, INTERVAL " . $pmpro_email_days_before_expiration . " Day) <= '" . $today . "') ORDER BY mu.enddate";

		$expiring_soon = $wpdb->get_results($sqlQuery);
				
		foreach($expiring_soon as $e)
		{				
			$send_email = apply_filters("pmpro_send_expiration_warning_email", true, $e->user_id);
			if($send_email)
			{
				//send an email
				$pmproemail = new PMProEmail();
				$euser = get_userdata($e->user_id);		
				$pmproemail->sendMembershipExpiringEmail($euser);
				
				echo "Membership expiring email sent to " . $euser->user_email . ". ";
			}
				
			//update user meta so we don't email them again
			update_user_meta($euser->ID, "pmpro_expiration_notice", $today);
		}
	}