foreach ($bundle_results as $rownum => $access_tag) { $bundles[$access_tag['short_name']] = $access_tag['short_name']; } } //output header row $header_row = array_merge($user_fields, $bundles); fputcsv($outstream, $header_row, ',', '"'); if (isset($_GET["membership_id"]) || $export_type == "cancellation") { $sql = "SELECT u.id, u.user_email, mmu.status, mmu.first_name, mmu.last_name "; $sql .= "FROM " . $wpdb->users . " u, " . MM_TABLE_USER_DATA . " mmu WHERE (mmu.wp_user_id = u.ID) "; if ($export_type == 'cancellation') { $sql .= " AND ((mmu.status = %d) OR (mmu.status = %d))"; $results = $wpdb->get_results($wpdb->prepare($sql, MM_Status::$PAUSED, MM_Status::$CANCELED), ARRAY_A); } else { $sql .= " AND (mmu.membership_level_id = %d) AND ((mmu.status = %d) OR (mmu.status = %d) OR (mmu.status = %d) OR (mmu.status = %d))"; $results = $wpdb->get_results($wpdb->prepare($sql, $membership->getId(), MM_Status::$ACTIVE, MM_Status::$PENDING_CANCELLATION, MM_Status::$LOCKED, MM_Status::$OVERDUE), ARRAY_A); } } else { if (isset($_GET["bundle_id"])) { $sql = "SELECT u.id, u.user_email, mmu.status, mmu.first_name, mmu.last_name " . "FROM {$wpdb->users} u LEFT JOIN " . MM_TABLE_USER_DATA . " mmu ON (mmu.wp_user_id = u.ID) " . "LEFT JOIN " . MM_TABLE_APPLIED_BUNDLES . " apb ON ((apb.access_type='" . MM_AppliedBundle::$ACCESS_TYPE_USER . "') AND (apb.access_type_id = u.ID)) " . "WHERE (apb.bundle_id = %d) "; if ($export_type == 'canceled_bundles') { $sql .= " AND ((apb.status = %d) OR (apb.status = %d))"; $results = $wpdb->get_results($wpdb->prepare($sql, $_GET["bundle_id"], MM_Status::$PAUSED, MM_Status::$CANCELED), ARRAY_A); } else { $sql .= " AND ((mmu.status = %d) OR (mmu.status = %d) OR (mmu.status = %d) OR (mmu.status = %d))"; $results = $wpdb->get_results($wpdb->prepare($sql, $_GET["bundle_id"], MM_Status::$ACTIVE, MM_Status::$LOCKED, MM_Status::$PENDING_CANCELLATION, MM_Status::$OVERDUE), ARRAY_A); } } else { exit; } }
?> </span> <textarea id="mm-description" name='description' style="width:100%; font-size: 11px"><?php echo $membership->getDescription(); ?> </textarea> </div> <div id="mm-paid-membership-settings" style="margin-top:5px; <?php if ($membership->isFree()) { echo "display:none;"; } ?> "> <?php $productsList = MM_HtmlUtils::getMembershipProducts($membership->getId(), $membership->getProductIds()); if (!empty($productsList)) { ?> <span style="font-size:11px;"> Products<?php echo MM_Utils::getInfoIcon("Paid membership levels can have multiple products associated with them which allows you to offer different pricing for the same membership. Select one or more products below to associate with this membership level."); ?> </span> <select id="mm-products[]" multiple style='width: 100%;' size='6' onchange='mmjs.filterRegistrationProducts()'> <?php echo $productsList; ?> </select> <br/> <span style="font-size:11px">