/**
* 发红包：发货时发红包
* @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);
