function sendsms_pricecut($goods_id) { include_once '../send.php'; $min_price_arr = get_min_price($goods_id); if ($min_price_arr['goods_name'] != '') { $min_price = $min_price_arr['min_price']; $goods_name = $min_price_arr['goods_name']; $goods_url = build_uri('goods', array('gid' => $goods_id), $goods_name); $goods_url = $GLOBALS['ecs']->url() . $goods_url; $sql = "select pricecut_id, mobile,email from " . $GLOBALS['ecs']->table('pricecut') . " where goods_id='{$goods_id}' and price >= '{$min_price}' and status=0 "; $list = $GLOBALS['db']->getAll($sql); if ($list) { for ($i = 0; $i < count($list); $i++) { if ($list[$i]['email'] != '') { $content1 = '您关注的商品 ' . $goods_name . ' 已经降价,您可点击下面链接直接进入商品页面浏览或购买!<br><a href="' . $goods_url . '">' . $goods_url . '</a>'; send_mail($_CFG['shop_name'], $list[$i]['email'], '您关注的商品' . $goods_name . '已经降价', $content1, 1); } //开启降价给客户发短信 if ($GLOBALS['_CFG']['sms_pricecut'] == 1) { //降价通知短信内容 $pricecut_content = sprintf($GLOBALS['_CFG']['sms_pricecut_tpl'], $goods_name, $goods_url, $GLOBALS['_CFG']['sms_sign']); if ($list[$i]['mobile'] != '') { $res = sendSMS($list[$i]['mobile'], $pricecut_content); if ($res == true) { $sql = "UPDATE " . $GLOBALS['ecs']->table('pricecut') . " SET status = 2 WHERE pricecut_id = '" . $list[$i]['pricecut_id'] . "'"; $GLOBALS['db']->query($sql); } else { $sql = "UPDATE " . $GLOBALS['ecs']->table('pricecut') . " SET status = 1 WHERE pricecut_id = '" . $list[$i]['pricecut_id'] . "'"; $GLOBALS['db']->query($sql); } } } } } } }
if ($_REQUEST['step'] == 'update_group_cart') { $result = array('error' => 0, 'message' => '', 'content' => '', 'goods_id' => ''); $rec_id = intval($_REQUEST['rec_id']); $number = intval($_REQUEST['number']); $goods_id = intval($_REQUEST['goods_id']); $result['suppid'] = intval($_REQUEST['suppid']); $result['rec_id'] = $rec_id; $result['number'] = $number; $goods_number = $GLOBALS['db']->getOne("select goods_number from " . $GLOBALS['ecs']->table('goods') . " where goods_id='{$goods_id}'"); if ($number > $goods_number) { $result['error'] = 1; $result['content'] = '对不起,您选择的数量超出库存您最多可购买' . $goods_number . "件"; $result['number'] = $GLOBALS['db']->getOne("select goods_number from " . $GLOBALS['ecs']->table('cart') . " where rec_id = '{$rec_id}'"); die($json->encode($result)); } $min_price = get_min_price($goods_id, $number, $rec_id); //取得当前用户该商品的最小单价 //file_put_contents('./567.txt',$min_price); $sql = "UPDATE " . $GLOBALS['ecs']->table('cart') . " SET goods_number = '{$number}',goods_price = '{$min_price}' WHERE rec_id = {$rec_id}"; $GLOBALS['db']->query($sql); /* 取得商品列表,计算合计 */ $cart_goods = get_cart_goods(); $result['min_price'] = $min_price; //折扣活动 $result['your_discount'] = ''; $discount = compute_discount($result['suppid']); if (is_array($discount)) { $favour_name = empty($discount['name']) ? '' : join(',', $discount['name']); $result['your_discount'] = sprintf($_LANG['your_discount'], $favour_name, price_format($discount['discount'])); } $subtotal = $GLOBALS['db']->getONE("select goods_price * goods_number AS subtotal from " . $GLOBALS['ecs']->table('cart') . " where rec_id = {$rec_id}");
function sendsms_pricecut($goods_id) { $min_price_arr = get_min_price($goods_id); $min_price = $min_price_arr['min_price']; $goods_name = $min_price_arr['goods_name']; $goods_url = build_uri('goods', array('gid' => $goods_id), $goods_name); $goods_url = $GLOBALS['ecs']->url() . $goods_url; $sql = "select pricecut_id, mobile,email from " . $GLOBALS['ecs']->table('pricecut') . " where goods_id='{$goods_id}' and price >= '{$min_price}' and status=0 "; $res = $GLOBALS['db']->query($sql); while ($row = $GLOBALS['db']->fetchRow($res)) { if ($row['email']) { $content1 = '您关注的商品 ' . $goods_name . ' 已经降价,您可点击下面链接直接进入商品页面浏览或购买!<br><a href="' . $goods_url . '">' . $goods_url . '</a>'; send_mail($_CFG['shop_name'], $row['email'], '您关注的商品' . $goods_name . '已经降价', $content1, 1); } if ($row['mobile']) { $client = new nusoap_client('http://106.ihuyi.com/webservice/sms.php?WSDL', 'wsdl'); $client->soap_defencoding = 'UTF-8'; $client->decode_utf8 = false; $client->xml_encoding = 'UTF-8'; $parameters = array('account' => 'cf_fight', 'password' => 'fight123', 'content' => '您的验证码是:6754。请不要把验证码泄露给其他人。', 'mobile' => $row['mobile']); $sendstatus = $client->call('Submit', $parameters); if ($sendstatus['SubmitResult']['code'] == '2') { $pricecut_status = 2; } else { $pricecut_status = 1; } $GLOBALS['db']->query("update " . $GLOBALS['ecs']->table('pricecut') . " set status='{$pricecut_status}' where pricecut_id='{$row['pricecut_id']}' "); } } }
/** * 获取通知列表 * @access public * @return void */ function get_pricecut_list() { $result = get_filter(); if ($result === false) { /* 查询条件 */ $filter['status'] = $_REQUEST['status'] != '-1' ? intval($_REQUEST['status']) : '-1'; $filter['mobile'] = !empty($_REQUEST['mobile']) ? trim($_REQUEST['mobile']) : ''; $where = " where 1 "; $where .= $filter['status'] != '-1' ? " AND p.status='{$filter['status']}' " : ""; $where .= !empty($filter['mobile']) ? " AND p.mobile='{$filter['mobile']}' " : ""; $sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('pricecut') . " AS p {$where} "; $filter['record_count'] = $GLOBALS['db']->getOne($sql); /* 分页大小 */ $filter = page_and_size($filter); $sql = "SELECT p.*, g.goods_name FROM " . $GLOBALS['ecs']->table('pricecut') . " AS p " . " left join " . $GLOBALS['ecs']->table('goods') . " AS g on p.goods_id=g.goods_id {$where}" . " ORDER BY p.status asc , p.pricecut_id desc"; set_filter($filter, $sql); } else { $sql = $result['sql']; $filter = $result['filter']; } $arr = array(); $res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']); while ($row = $GLOBALS['db']->fetchRow($res)) { $row['notice_status'] = $GLOBALS['notice_status'][$row['status']]; $row['add_time'] = local_date('Y-m-d H:i:s', $row['add_time']); $row['min_price'] = get_min_price($row['goods_id']); $row['min_price_format'] = price_format($row['min_price']); $row['price_format'] = price_format($row['price']); $arr[] = $row; } $arr = array('item' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']); return $arr; }