/** * 发红包:发货时发红包 * @param int $order_id 订单号 * @return bool */ function send_order_bonus($order_id) { /* 取得订单应该发放的红包 */ $bonus_list = order_bonus($order_id); /* 如果有红包,统计并发送 */ if ($bonus_list) { /* 用户信息 */ $sql = "SELECT u.user_id, u.user_name, u.mobile_phone " . "FROM " . $GLOBALS['ecs']->table('order_info') . " AS o, " . $GLOBALS['ecs']->table('users') . " AS u " . "WHERE o.order_id = '{$order_id}' " . "AND o.user_id = u.user_id "; $user = $GLOBALS['db']->getRow($sql); /* 统计 */ $count = 0; $money = ''; foreach ($bonus_list as $bonus) { $count += $bonus['number']; $money .= price_format($bonus['type_money']) . ' [' . $bonus['number'] . '], '; $add_time = time(); $expire_time = min($bonus['use_end_date'], $add_time + $bonus['use_time_limit']); /* 修改用户红包 */ $sql = "INSERT INTO " . $GLOBALS['ecs']->table('user_bonus') . " (bonus_type_id, user_id,amount,add_time,expire_time,from_order_id) " . "VALUES('{$bonus['type_id']}','{$user['user_id']}','{$bonus['type_money']}','{$add_time}','{$expire_time}','{$order_id}')"; for ($i = 0; $i < $bonus['number']; $i++) { $GLOBALS['db']->query($sql); } } /* 如果有红包,发送邮件 */ /* if ($count > 0) { $tpl = get_mail_template('send_bonus'); $GLOBALS['smarty']->assign('user_name', $user['user_name']); $GLOBALS['smarty']->assign('count', $count); $GLOBALS['smarty']->assign('money', $money); $GLOBALS['smarty']->assign('shop_name', $GLOBALS['_CFG']['shop_name']); $GLOBALS['smarty']->assign('send_date', local_date($GLOBALS['_CFG']['date_format'])); $GLOBALS['smarty']->assign('sent_date', local_date($GLOBALS['_CFG']['date_format'])); $content = $GLOBALS['smarty']->fetch('str:' . $tpl['template_content']); send_mail($user['user_name'], $user['email'], $tpl['template_subject'], $content, $tpl['is_html']); }*/ } return true; }
/** * 返回订单发放的红包 * @param int $order_id 订单id */ function return_order_bonus($order_id) { /* 取得订单应该发放的红包 */ $bonus_list = order_bonus($order_id); /* 删除 */ if ($bonus_list) { /* 取得订单信息 */ $order = order_info($order_id); $user_id = $order['user_id']; foreach ($bonus_list as $bonus) { $sql = "DELETE FROM " . $GLOBALS['ecs']->table('user_bonus') . " WHERE bonus_type_id = '{$bonus['type_id']}' " . "AND user_id = '{$user_id}' " . "AND order_id = '0' LIMIT " . $bonus['number']; $GLOBALS['db']->query($sql); } } }
$smarty->assign('bonus_money', $row['type_money']); $smarty->assign('use_start_date', local_date("Y-m-d", $row['use_start_date'])); $smarty->assign('use_end_date', local_date("Y-m-d", $row['use_end_date'])); $smarty->assign('status', 3); $smarty->display('share_bonus.dwt'); exit; } } } $order_id = isset($_REQUEST['order_id']) ? trim($_REQUEST['order_id']) : 0; if (empty($order_id)) { echo 'order_id参数错误'; exit; } $arr = array(); $bonus_list = order_bonus($order_id); $bonus_list1 = array(); $bonus_list2 = array(); foreach ($bonus_list as $bonus) { if ($bonus['is_share'] == 0) { $bonus['use_start_date'] = local_date("Y-m-d", $bonus['use_start_date']); $bonus['use_end_date'] = local_date("Y-m-d", $bonus['use_end_date']); $bonus_list1[] = $bonus; } elseif ($bonus['is_share'] == 1) { //好友券 //$bonus_list2[]=$bonus; } } $sql = "select * from " . $hhs->table('send_bonus_type') . " where send_order_id=" . $order_id; $send_bonus = $db->getRow($sql); $smarty->assign('bonus_list1', $bonus_list1);