function um_manual_promotevip($user_id, $user_name, $to, $type = 1, $endTime)
{
date_default_timezone_set('Asia/Shanghai');
$admin_email = get_bloginfo('admin_email');
$blogname = get_bloginfo('name');
global $wpdb;
$prefix = $wpdb->prefix;
$table = $prefix . 'um_vip_users';
$userInfo = $wpdb->get_row("select * from " . $table . " where user_id=" . $user_id);
if (!$userInfo) {
$wpdb->query("INSERT INTO {$table} (user_id,user_type,startTime,endTime) VALUES ('{$user_id}', '{$type}', NOW(),'{$endTime}')");
} else {
if (strtotime($endTime) > strtotime($userInfo->endTime) && time() > strtotime($userInfo->endTime)) {
$wpdb->query("UPDATE {$table} SET user_type='{$type}', startTime=NOW(), endTime='{$endTime}' WHERE user_id='{$user_id}'");
} elseif (strtotime($endTime) > strtotime($userInfo->endTime) && time() <= strtotime($userInfo->endTime)) {
$wpdb->query("UPDATE {$table} SET user_type='{$type}', endTime='{$endTime}' WHERE user_id='{$user_id}'");
}
}
//email
$vip = $wpdb->get_row("select * from " . $table . " where user_id=" . $user_id);
$content = '<p>系统管理员已为您成功开通或续费了会员，以下为当前会员信息，如有任何疑问，请及时联系我们（Email:<a href="mailto:' . $admin_email . '" target="_blank">' . $admin_email . '</a>）。</p><div style="background-color:#fefcc9; padding:10px 15px; border:1px solid #f7dfa4; font-size: 12px;line-height:160%;">会员状态：' . output_order_vipType($vip->user_type) . '<br>开通时间：' . $vip->startTime . '<br>到期时间：' . $vip->endTime . '</div>';
$html = store_email_template_wrap($user_name, $content);
$wp_email = 'no-reply@' . preg_replace('#^www\\.#', '', strtolower($_SERVER['SERVER_NAME']));
$title = '会员状态变更提醒';
$fr = "From: \"" . $blogname . "\" <{$wp_email}>";
$headers = "{$fr}\nContent-Type: text/html; charset=" . get_option('blog_charset') . "\n";
wp_mail($to, $title, $html, $headers);
}
?>
<tr>
<td><?php
echo $vip_order['order_id'];
?>
</td>
<td><?php
echo $vip_order['order_success_time'];
?>
</td>
<td><?php
echo $vip_order['order_total_price'];
?>
</td>
<td><?php
echo output_order_vipType($vip_order['product_id'] * -1);
?>
</td>
<td><?php
echo output_order_status($vip_order['order_status']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
