function xt_update_user_account_cost_counts($user_id, $cash = true, $jifen = true) { if ($cash) { $tixians = xt_total_tixian($user_id); xt_update_user_count($user_id, XT_USER_COUNT_CASH_COST, $tixians[0] + $tixians[1]); } if ($jifen) { $jifenOrder = xt_user_total_jifen_order($user_id); xt_update_user_count($user_id, XT_USER_COUNT_JIFEN_COST, $jifenOrder[0] + $jifenOrder[1]); } }
<div id="X_Account-Jifen"> <div class="row-fluid"> <?php $user = wp_get_current_user(); $jifen = xt_user_total_jifen($user->ID); $jifenOrder = $jifen > 0 ? xt_user_total_jifen_order($user->ID) : array(0, 0, 0); echo '<p style="padding:0 15px;font-size:14px;">您目前累计' . xt_jifenbao_text() . '<em style="color: #F90;font-style:normal;">' . $jifen . '</em>分,可用' . xt_jifenbao_text() . '<em style="color: #F90;font-style:normal;">' . ($jifen - $jifenOrder[0] - $jifenOrder[1]) . '</em>分。</p>'; ?> <script type="text/javascript"> var JIFEN = <?php echo $jifen - $jifenOrder[0] - $jifenOrder[1]; ?> ; </script> <ul class="span12 nav nav-pills" id="X_Account-Jifen-Type" style="margin-left:0px;"> <li class="active"><a href="javascript:;" class="xt-current" data-value="jifen"><?php echo xt_jifenbao_text(); ?> 记录<span></span></a></li> <li><a href="javascript:;" data-value="order">兑换记录<span></span></a></li> <li><a href="javascript:;" data-value="item">可兑换的商品<span></span></a></li> </ul> <div class="span12 xt-account-list" id="X_Account-Jifen-List" style="margin-left:0px;"> </div> </div> </div>
function xt_ajax_account_jifen_exchange() { $result = array('code' => 0, 'msg' => '', 'result' => array()); if (!isset($_POST['id']) || empty($_POST['id'])) { $result['code'] = 500; $result['msg'] = '未指定要兑换的商品'; exit(json_encode($result)); } $user = wp_get_current_user(); if ($user->exists()) { $jifen = xt_user_total_jifen($user->ID); $jifenOrder = $jifen > 0 ? xt_user_total_jifen_order($user->ID) : array(0, 0, 0); global $wpdb; $item = $wpdb->get_row('SELECT * FROM ' . XT_TABLE_USER_JIFEN_ITEM . ' WHERE id=' . (int) $_POST['id']); if (empty($item)) { $result['code'] = 500; $result['msg'] = '您要兑换的商品不存在'; } if ($item->stock - $item->buy_count <= 0) { $result['code'] = 500; $result['msg'] = '库存不足,无法兑换'; } if ($item->jifen > $jifen - $jifenOrder[0] - $jifenOrder[1]) { $result['code'] = 500; $result['msg'] = xt_jifenbao_text() . '不足,无法兑换'; } $count = $wpdb->get_var('SELECT COUNT(*) FROM ' . XT_TABLE_USER_JIFEN_ORDER . ' WHERE item_id=' . $item->id . ' AND user_id=' . $user->ID); if ($count >= $item->user_count) { $result['code'] = 500; $result['msg'] = '超出每人限兑数量'; } if ($result['code'] == 0) { if ($wpdb->insert(XT_TABLE_USER_JIFEN_ORDER, array('item_id' => $item->id, 'num' => 1, 'jifen' => $item->jifen, 'status' => 0, 'create_time' => current_time('mysql'), 'user_id' => $user->ID, 'user_name' => $user->user_login))) { $wpdb->update(XT_TABLE_USER_JIFEN_ITEM, array('buy_count' => $item->buy_count + 1), array('id' => $item->id)); } } } else { $result['code'] = 500; $result['msg'] = '未登录'; } exit(json_encode($result)); }