/** * 取得跟商品关联的礼包列表 * * @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 ''; }