/**
* 取得跟商品关联的礼包列表
*
* @param string $goods_id
* 商品编号
*
* @return 礼包列表
*/
function get_package_goods_list($goods_id)
{
$now = gmtime();
$sql = "SELECT pg.goods_id, ga.act_id, ga.act_name, ga.act_desc, ga.goods_name, ga.start_time,\n\t\t\t\t\t ga.end_time, ga.is_finished, ga.ext_info\n\t\t\t\tFROM " . $this->pre . "goods_activity AS ga, " . $this->pre . "package_goods AS pg\n\t\t\t\tWHERE pg.package_id = ga.act_id\n\t\t\t\tAND ga.start_time <= '" . $now . "'\n\t\t\t\tAND ga.end_time >= '" . $now . "'\n\t\t\t\tAND pg.goods_id = " . $goods_id . "\n\t\t\t\tGROUP BY ga.act_id\n\t\t\t\tORDER BY ga.act_id ";
$res = $this->query($sql);
foreach ($res as $tempkey => $value) {
$subtotal = 0;
$row = unserialize($value['ext_info']);
unset($value['ext_info']);
if ($row) {
foreach ($row as $key => $val) {
$res[$tempkey][$key] = $val;
}
}
$sql = "SELECT pg.package_id, pg.goods_id, pg.goods_number, pg.admin_id, p.goods_attr, g.goods_sn, g.goods_name, g.market_price, g.goods_thumb, IFNULL(mp.user_price, g.shop_price * '{$_SESSION['discount']}') AS rank_price\n\t\t\t\t\tFROM " . $this->pre . "package_goods AS pg\n\t\t\t\t\t\tLEFT JOIN " . $this->pre . "goods AS g\n\t\t\t\t\t\t\tON g.goods_id = pg.goods_id\n\t\t\t\t\t\tLEFT JOIN " . $this->pre . "products AS p\n\t\t\t\t\t\t\tON p.product_id = pg.product_id\n\t\t\t\t\t\tLEFT JOIN " . $this->pre . "member_price AS mp\n\t\t\t\t\t\t\tON mp.goods_id = g.goods_id AND mp.user_rank = '{$_SESSION['user_rank']}'\n\t\t\t\t\tWHERE pg.package_id = " . $value['act_id'] . "\n\t\t\t\t\tORDER BY pg.package_id, pg.goods_id";
$goods_res = $this->query($sql);
foreach ($goods_res as $key => $val) {
$goods_id_array[] = $val['goods_id'];
$goods_res[$key]['goods_thumb'] = get_image_path($val['goods_id'], $val['goods_thumb'], true);
$goods_res[$key]['market_price'] = price_format($val['market_price']);
$goods_res[$key]['rank_price'] = price_format($val['rank_price']);
$subtotal += $val['rank_price'] * $val['goods_number'];
}
/* 取商品属性 */
$sql = "SELECT ga.goods_attr_id, ga.attr_value\n\t\t\t\t\tFROM " . $this->pre . "goods_attr AS ga, " . ECTouch::ecs()->table('attribute') . " AS a\n\t\t\t\t\tWHERE a.attr_id = ga.attr_id\n\t\t\t\t\tAND a.attr_type = 1\n\t\t\t\t\tAND " . db_create_in($goods_id_array, 'goods_id');
$result_goods_attr = $this->query($sql);
$_goods_attr = array();
foreach ($result_goods_attr as $value) {
$_goods_attr[$value['goods_attr_id']] = $value['attr_value'];
}
/* 处理货品 */
$format = '[%s]';
foreach ($goods_res as $key => $val) {
if ($val['goods_attr'] != '') {
$goods_attr_array = explode('|', $val['goods_attr']);
$goods_attr = array();
foreach ($goods_attr_array as $_attr) {
$goods_attr[] = $_goods_attr[$_attr];
}
$goods_res[$key]['goods_attr_str'] = sprintf($format, implode('，', $goods_attr));
}
}
$res[$tempkey]['goods_list'] = $goods_res;
$res[$tempkey]['subtotal'] = price_format($subtotal);
$res[$tempkey]['saving'] = price_format($subtotal - $res[$tempkey]['package_price']);
$res[$tempkey]['package_price'] = price_format($res[$tempkey]['package_price']);
}
return $res;
}
<?php
/**
* 微信支付告警通知
*/
define('IN_ECTOUCH', true);
// require(dirname(__FILE__) . '/../include/init.php');
//接收数据
$postStr = $GLOBALS['HTTP_RAW_POST_DATA'];
if (!empty($postStr)) {
//转换数据
$postData = (array) simplexml_load_string($postStr, 'SimpleXMLElement', LIBXML_NOCDATA);
//插入留言表
$sql = "INSERT INTO " . ECTouch::ecs()->table('feedback') . "(msg_title, msg_content, msg_time)" . " VALUES ('告警通知', 'ErrorType：{$postData['ErrorType']} " . "\n\r" . " 错误描述：{$postData['Description']} " . "\n\r" . " 错误详情：{$postData['AlarmContent']}', '" . gmtime() . "')";
ECTouch::db()->query($sql);
echo 'success';
} else {
echo '';
}
