public function one()
{
if (empty($this->user_session)) {
$referer = url('cart:one');
redirect(url('account:login', array('referer' => $referer)));
exit;
}
// 查出购物车里的产品
$cart_list = D('')->field('c.pigcms_id, c.store_id, c.product_id, c.pro_num, c.pro_price, c.sku_id, c.sku_data, p.name, p.image')->table(array('Product' => 'p', 'User_cart' => 'c'))->where("`p`.`product_id` = `c`.`product_id` AND c.uid = '" . $this->user_session['uid'] . "'")->select();
if (empty($cart_list)) {
//pigcms_tips('你的购物为空', '');
}
// 对产品按商铺进行分组
$cart_store_list = array();
$stort_id_list = array();
$total = 0;
$total_money = 0;
foreach ($cart_list as $cart) {
$cart['sku_data'] = unserialize($cart['sku_data']);
$cart['image'] = getAttachmentUrl($cart['image']);
$cart_store_list[$cart['store_id']][] = $cart;
$stort_id_list[$cart['store_id']] = $cart['store_id'];
$total += $cart['pro_num'];
$total_money += $cart['pro_num'] * $cart['pro_price'];
}
$store_name_list = M('Store')->getStoreName($stort_id_list);
$this->assign('cart_store_list', $cart_store_list);
$this->assign('store_name_list', $store_name_list);
$this->assign('total', $total);
$this->assign('total_money', $total_money);
$this->assign('step', 'one');
$this->display();
}
public function getProducts($order_id)
{
$products = $this->db->query("SELECT p.product_id,p.name,p.image,op.pro_num,op.pro_price,op.sku_id,op.sku_data,op.comment,op.is_packaged,op.in_package_status,op.is_fx,op.original_product_id,op.is_present FROM " . option('system.DB_PREFIX') . "order_product op, " . option('system.DB_PREFIX') . "product p WHERE op.product_id = p.product_id AND op.order_id = '" . $order_id . "'");
foreach ($products as &$value) {
$value['image'] = getAttachmentUrl($value['image']);
}
return $products;
}
public function getFxProducts($order_id)
{
$products = $this->db->query("SELECT p.product_id,p.name,fop.cost_price,p.image,fop.quantity,fop.price,fop.sku_id,fop.sku_data,fop.comment FROM " . option('system.DB_PREFIX') . "fx_order_product fop, " . option('system.DB_PREFIX') . "product p WHERE fop.product_id = p.product_id AND fop.fx_order_id = '" . $order_id . "'");
foreach ($products as &$tmp) {
$tmp['image'] = getAttachmentUrl($tmp['image']);
}
return $products;
}
/**
* @desc 获取商品图片
* @param $product_id
*/
public function getImages($product_id, $is_wap = false)
{
$images = $this->db->field('`image`')->where(array('product_id' => $product_id))->order('sort ASC')->select();
foreach ($images as &$value) {
$value['image'] = getAttachmentUrl($value['image']);
}
return $images;
}
/**
* 根据活动ID查寻出所有相关产品
*/
public function getProductListByRid($rid)
{
$db_prefix = option('system.DB_PREFIX');
$sql = "SELECT p.* FROM `" . $db_prefix . "reward_product` AS rp LEFT JOIN `" . $db_prefix . "product` AS p ON `rp`.`product_id` = `p`.`product_id` WHERE `rp`.`rid` = '" . $rid . "'";
$product_list = $this->db->query($sql);
foreach ($product_list as &$product) {
$product['image'] = getAttachmentUrl($product['image']);
}
return $product_list;
}
/**
* 根据赠品ID查寻出所有相关产品
*/
public function getProductListByPid($pid)
{
$db_prefix = option('system.DB_PREFIX');
$sql = "SELECT p.product_id, p.name, p.quantity, p.price, p.original_price, p.image, p.has_property FROM `" . $db_prefix . "present_product` AS pp LEFT JOIN `" . $db_prefix . "product` AS p ON `PP`.`product_id` = `p`.`product_id` WHERE `pp`.`pid` = '" . $pid . "' AND p.status = '1' AND p.quantity > 0";
$product_list = $this->db->query($sql);
foreach ($product_list as &$product) {
$product['image'] = getAttachmentUrl($product['image']);
}
return $product_list;
}
public function get_slider_by_key($cat_key, $limit = 6)
{
if (empty($cat_key)) {
return false;
}
$adver_list = $this->db->table('Slider as s')->join('Slider_category sc On s.cat_id = sc.cat_id')->where('sc.cat_key=\'' . $cat_key . '\' and s.status=\'1\'')->limit($limit)->select();
$adverlist = array();
foreach ($adver_list as $key => $value) {
$adver_list[$key]['pic'] = getAttachmentUrl($value['pic']);
}
return $adver_list;
}
/**
* 根据条件获到评论列表
* 当limit与offset都为0时，表示不行限制
* 当is_attachment为真时，需要查寻评论的图片列表,以及评论会员基本信息
*/
public function getSimpleList($limit = 0, $offset = 0, $order_by = '')
{
if (empty($order_by)) {
$order_by = "ca.id desc";
}
$where = "c.status=1 and c.has_image=1 and c.delete_flg=0 and c.type='PRODUCT'";
$group = 'c.relation_id';
$comment_list = $this->db->table("Comment as c")->join('Comment_attachment as ca ON ca.cid=c.id', 'LEFT')->where($where)->group($group)->limit($offset . ',' . $limit)->field("c.*,ca.file,ca.width,ca.height,c.relation_id")->select();
foreach ($comment_list as $k => $tmp) {
$comment_list[$k]['file'] = getAttachmentUrl($tmp['file']);
$comment_list[$k]['ilink'] = url_rewrite('goods:index', array('id' => $tmp['relation_id'])) . "#product_comment_image";
}
return $comment_list;
}
public function getList($where)
{
$user_list = $this->where($where)->select();
$return_user_list = array();
foreach ($user_list as $tmp) {
if ($tmp['avatar']) {
$tmp['avatar'] = getAttachmentUrl($tmp['avatar']);
} else {
$tmp['avatar'] = getAttachmentUrl('images/touxiang.png', false);
}
$return_user_list[$tmp['uid']] = $tmp;
}
return $return_user_list;
}
/**
* 根据优惠券商品 查找对应产品信息列表
* @param $where is string
* @param $orderbyfield 排序字段
* @param $orderbymethod 排序方式 ASC DESC
* @param $offset
* @param $limit
* @return array
*/
public function getSellingCouponProduct($where, $order_by_field, $order_by_method, $offset, $limit)
{
if (!empty($order_by_field) && !empty($order_by_method)) {
$order = $order_by_field . ' ' . strtoupper($order_by_method);
} else {
//默认排序
$order = 'p.sort DESC, p.product_id DESC';
}
$where = $where . " and p.status=1";
$products = $this->db->table("Coupon_to_product as cp")->join('Product as p ON cp.product_id=p.product_id', 'LEFT')->where($where)->order($order)->limit($offset . ',' . $limit)->field("p.*,cp.coupon_id")->select();
foreach ($products as &$tmp) {
$tmp['image'] = getAttachmentUrl($tmp['image']);
$tmp['link'] = url_rewrite('goods:index', array('id' => $tmp['product_id']));
}
return $products;
}
public function getAllCategory($where = array())
{
$category_list = $this->db->where($where)->order('`parent_id` ASC,`order_by` DESC,`cat_id` ASC')->select();
$new_category_list = array();
foreach ($category_list as $value) {
if ($value['cat_pic']) {
$value['cat_pic'] = getAttachmentUrl($value['cat_pic']);
}
if (empty($value['parent_id'])) {
$new_category_list[$value['cat_id']] = $value;
} else {
$new_category_list[$value['parent_id']]['cat_list'][] = $value;
}
}
return $new_category_list;
}
public function get_adver_by_key($cat_key, $limit = 3)
{
$database_adver_category = D('Adver_category');
$condition_adver_category['cat_key'] = $cat_key;
$now_adver_category = $database_adver_category->field('`cat_id`')->where($condition_adver_category)->find();
if ($now_adver_category) {
$condition_adver['cat_id'] = $now_adver_category['cat_id'];
$condition_adver['status'] = '1';
$adver_list = $this->field(true)->where($condition_adver)->order('`id` DESC')->limit($limit)->select();
foreach ($adver_list as $key => $value) {
$adver_list[$key]['pic'] = getAttachmentUrl($value['pic']);
}
return $adver_list;
} else {
return false;
}
}
public function getListByStoreId($store_id)
{
$condition = array('store_id' => $store_id, 'status' => 1);
switch ($_POST['type']) {
case 'list_image':
$condition['type'] = 0;
break;
case 'list_upload_image':
$condition['type'] = 0;
$condition['from'] = 0;
break;
case 'list_import_image':
$condition['type'] = 0;
$condition['from'] = 1;
break;
case 'list_collect_image':
$condition['type'] = 0;
$condition['from'] = 2;
break;
case 'list_voice':
$condition['type'] = 1;
break;
case 'list_upload_voice':
$condition['type'] = 1;
$condition['from'] = 0;
break;
case 'list_collect_voice':
$condition['type'] = 1;
$condition['from'] = 1;
break;
}
if ($_POST['txt']) {
$condition['name'] = array('like', '%' . $_POST['txt'] . '%');
}
$attachment_count = $this->db->where($condition)->count('pigcms_id');
import('source.class.user_page');
$p = new Page($attachment_count, 10);
$attachment_list = $this->db->where($condition)->order('`pigcms_id` DESC')->limit($p->firstRow . ',' . $p->listRows)->select();
foreach ($attachment_list as &$value) {
$value['file'] = getAttachmentUrl($value['file']);
}
$return['attachment_list'] = $attachment_list;
$return['page'] = $p->show();
return $return;
}
public function getListByIDList($physical_id_list)
{
if (empty($physical_id_list) || !is_array($physical_id_list)) {
return array();
}
//$store_physical_list = $this->db->where(array('pigcms_id' => array('in', $physical_id_list)))->select();
$store_physical_list = D('')->field("`s`.`buyer_selffetch_name`, `sp`.*")->table(array('Store' => 's', 'Store_physical' => 'sp'))->where("`s`.`store_id` = `sp`.`store_id` AND `sp`.`pigcms_id` in (" . join(',', $physical_id_list) . ")")->select();
import('source.class.area');
$area_class = new area();
$return_data = array();
foreach ($store_physical_list as $value) {
$value['images_arr'] = explode(',', $value['images']);
foreach ($value['images_arr'] as &$image_value) {
$image_value = getAttachmentUrl($image_value);
}
$value['province_txt'] = $area_class->get_name($value['province']);
$value['city_txt'] = $area_class->get_name($value['city']);
$value['county_txt'] = $area_class->get_name($value['county']);
$return_data[$value['pigcms_id']] = $value;
}
return $return_data;
}
private function special_keyword($key, $data = array())
{
$return = array();
if ($key == '附近团购' || $key == '附近订餐') {
$dateline = time() - 3600 * 2;
if ($_lat = D("User__lat")->field(true)->where("`open_id`='{$data['FromUserName']}' AND `dateline`>'{$dateline}'")->find()) {
import('@.ORG.lat');
$lat_class = new lat();
$location2 = $lat_class->gpsToBaidu($_lat['lat'], $_lat['']);
//转换腾讯坐标到百度坐标
$x = $location2['lat'];
$y = $location2['lng'];
if ($key == '附近订餐') {
$meals = D("Merchant_store")->field("*, ROUND(6378.138 * 2 * ASIN(SQRT(POW(SIN(({$x}*PI()/180-`lat`*PI()/180)/2),2)+COS({$x}*PI()/180)*COS(`lat`*PI()/180)*POW(SIN(({$y}*PI()/180-``*PI()/180)/2),2)))*1000) AS juli")->where('`have_meal`=1')->order("juli ASC")->limit("0, 10")->select();
$store_image_class = new store_image();
foreach ($meals as $meal) {
$images = $store_image_class->get_allImage_by_path($meal['pic_info']);
$meal['image'] = $images ? array_shift($images) : '';
$len = $meal['juli'] >= 1000 ? number_format($meal['juli'] / 1000, 1) . '千米' : $meal['juli'] . '米';
$return[] = array($meal['name'] . "[{$meal['adress']}]约{$len}", $meal['txt_info'], $meal['image'], $this->config['site_url'] . "/wap.php?g=Wap&c=Meal&a=menu&mer_id={$meal['mer_id']}&store_id={$meal['store_id']}");
}
} else {
$meals = D("Merchant_store")->field("*, ROUND(6378.138 * 2 * ASIN(SQRT(POW(SIN(({$x}*PI()/180-`lat`*PI()/180)/2),2)+COS({$x}*PI()/180)*COS(`lat`*PI()/180)*POW(SIN(({$y}*PI()/180-``*PI()/180)/2),2)))*1000) AS juli")->where('`have_group`=1')->order("juli ASC")->limit("0, 10")->select();
$store_image_class = new store_image();
foreach ($meals as $meal) {
$images = $store_image_class->get_allImage_by_path($meal['pic_info']);
$meal['image'] = $images ? array_shift($images) : '';
$len = $meal['juli'] >= 1000 ? number_format($meal['juli'] / 1000, 1) . '千米' : $meal['juli'] . '米';
$return[] = array($meal['name'] . "[{$meal['adress']}]约{$len}", $meal['txt_info'], $meal['image'], $this->config['site_url'] . "/wap.php?g=Wap&c=Group&a=shop&store_id={$meal['store_id']}");
}
}
}
if ($return) {
return array($return, 'news');
} else {
return array("主人【小猪猪】已经接收到你的指令请发送您的地理位置(对话框右下角点击＋号，然后点击“位置”)给我哈", 'text');
}
}
if ($key == '交友') {
$return[] = array("交友约会", "结交一些朋友吃喝玩乐", $this->config['site_url'] . '/static/images/jiaoyou.jpg', $this->config['site_url'] . "/wap.php?c=Invitation&a=datelist");
return array($return, 'news');
}
$platform = D("Platform")->field(true)->where(array('key' => $key))->find();
if ($platform) {
$return[] = array($platform['title'], $platform['info'], getAttachmentUrl($platform['pic']), $platform['url']);
} else {
$keys = D("Keywords")->field(true)->where(array('keyword' => $key))->order('id DESC')->limit('0,9')->select();
$lotteryids = $mealids = $groupids = array();
foreach ($keys as $k) {
if ($k['third_type'] == 'group') {
$groupids[] = $k['third_id'];
} elseif ($k['third_type'] == 'Merchant_store') {
$mealids[] = $k['third_id'];
} elseif ($k['third_type'] == 'lottery') {
$lotteryids[] = $k['third_id'];
}
}
if ($groupids) {
$list = D("Group")->field(true)->where(array('group_id' => array('in', $groupids)))->select();
$group_image_class = new group_image();
foreach ($list as $li) {
$image = $group_image_class->get_image_by_path($li['pic'], 's');
$return[] = array($li['s_name'], $li['name'], $image, $this->config['site_url'] . "/wap.php?g=Wap&c=Group&a=detail&group_id={$li['group_id']}");
}
}
if ($mealids) {
$list = D("Merchant_store")->field(true)->where(array('store_id' => array('in', $mealids)))->select();
$store_image_class = new store_image();
foreach ($list as $now_store) {
$images = $store_image_class->get_allImage_by_path($now_store['pic_info']);
$now_store['image'] = $images ? array_shift($images) : '';
if ($now_store['have_meal']) {
$return[] = array($now_store['name'], $now_store['txt_info'], $now_store['image'], $this->config['site_url'] . "/wap.php?g=Wap&c=Meal&a=menu&mer_id={$now_store['mer_id']}&store_id={$now_store['store_id']}");
} else {
$return[] = array($now_store['name'], $now_store['txt_info'], $now_store['image'], $this->config['site_url'] . "/wap.php?g=Wap&c=Group&a=shop&store_id={$now_store['store_id']}");
}
}
}
if ($lotteryids) {
$lotterys = D("Lottery")->field(true)->where(array('id' => array('in', $lotteryids), 'statdate' => array('lt', time()), 'enddate' => array('gt', time())))->select();
foreach ($lotterys as $lottery) {
switch ($lottery['type']) {
case 1:
$return[] = array('[活动]' . $lottery['title'], $lottery['info'], $this->config['site_url'] . $lottery['starpicurl'], $this->config['site_url'] . "/wap.php?c=Lottery&a=index&token={$lottery['token']}&id={$lottery['id']}");
break;
case 2:
$return[] = array('[活动]' . $lottery['title'], $lottery['info'], $this->config['site_url'] . $lottery['starpicurl'], $this->config['site_url'] . "/wap.php?c=Guajiang&a=index&token={$lottery['token']}&id={$lottery['id']}");
break;
case 3:
$return[] = array('[活动]' . $lottery['title'], $lottery['info'], $this->config['site_url'] . $lottery['starpicurl'], $this->config['site_url'] . "/wap.php?c=Coupon&a=index&token={$lottery['token']}&id={$lottery['id']}");
break;
case 4:
$return[] = array('[活动]' . $lottery['title'], $lottery['info'], $this->config['site_url'] . $lottery['starpicurl'], $this->config['site_url'] . "/wap.php?c=LuckyFruit&a=index&token={$lottery['token']}&id={$lottery['id']}");
break;
case 5:
$return[] = array('[活动]' . $lottery['title'], $lottery['info'], $this->config['site_url'] . $lottery['starpicurl'], $this->config['site_url'] . "/wap.php?c=GoldenEgg&a=index&token={$lottery['token']}&id={$lottery['id']}");
break;
}
}
}
}
if ($return) {
return array($return, 'news');
}
return array('亲，暂时没有找到与“' . $key . '”相关的内容！请更换内容。', 'text');
}
public function getImgList()
{
$database_attachment = D('Attachment');
$condition_attachment['store_id'] = $this->store_session['store_id'];
$condition_attachment['status'] = '1';
$condition_attachment['type'] = '0';
$count = $database_attachment->where($condition_attachment)->count('pigcms_id');
import('user_page');
$p = new Page($count, 27);
$image_list = $database_attachment->field('`pigcms_id`,`name`,`file`,`size`,`width`,`height`')->where($condition_attachment)->order('`pigcms_id` DESC')->limit($p->firstRow . ',' . $p->listRows)->select();
foreach ($image_list as &$value) {
$value['file'] = getAttachmentUrl($value['file']);
}
$err_msg['image_list'] = $image_list;
$err_msg['page_bar'] = $p->show();
$err_msg['count'] = $count;
json_return(0, $err_msg);
}
/**
* @desc 获取单个品牌信息
* @param $where
* @param string $fields
*/
public function get($where, $fields = '*')
{
$brand = $this->db->field($fields)->where($where)->find();
$brand['pic'] = getAttachmentUrl($brand['pic']);
return $brand;
}
public function supplierFxProducts($where, $offset = 0, $limit = 0)
{
if ($limit > 0) {
$products = $this->db->where($where)->order('is_recommend DESC, product_id DESC')->order('product_id DESC')->limit($offset . ',' . $limit)->select();
} else {
$products = $this->db->where($where)->order('is_recommend DESC, product_id DESC')->order('product_id DESC')->select();
}
foreach ($products as &$product) {
$product['image'] = getAttachmentUrl($product['image']);
}
return $products;
}
?>
/static/js/fastclick.js"></script>
<script src="<?php
echo $config['site_url'];
?>
/static/js/jquery.min.js"></script>
<script src="<?php
echo TPL_URL;
?>
index_style/js/base.js"></script>
</head>
<body style="padding-bottom:70px;">
<div class="wx_wrap">
<div class="my_head">
<img src="<?php
echo getAttachmentUrl('images/default_ucenter.jpg', false);
?>
" style="width:100%;max-height:220px;display:block;margin:auto;"/>
<!-- S 账户信息 -->
<a class="my_user">
<h5>尊敬的 <?php
echo $wap_user['nickname'];
?>
，<?php
echo $time_tip;
?>
</h5>
</a>
<!-- E 账户信息 -->
</div>
<!-- S 入口菜单 -->
function display_upload($apli, $post_id, $Mmod)
{
$att_size = '';
$att_type = '';
$att_name = '';
$att_url = '';
$att_link = '';
$attachments = '';
$att_icon = '';
$num_cells = 5;
$att = getAttachments($apli, $post_id, 0, $Mmod);
if (is_array($att)) {
$att_count = count($att);
// $attachments = "\n<table id=\"ooo\" class=\"fo-post-mes\" border=\"0\" cellpadding=\"2\" cellspacing=\"1\" width=\"100%\">\n<tr>";
$attachments = '
<div class="list-group">
<div class="list-group-item">
<img class="smil" src="themes/npds-boost/images/forum/subject/1F4CE.png" border="0" alt="icon_post" />
<span class="text-muted">' . upload_translate("Pièces jointes") . '</span>
<span class="label label-default label-pill pull-right">' . $att_count . '</span>
</div>';
$ncell = 0;
for ($i = 0; $i < $att_count; $i++) {
$att_id = $att[$i]["att_id"];
$att_name = $att[$i]["att_name"];
$att_path = $att[$i]["att_path"];
$att_type = $att[$i]["att_type"];
$att_size = (int) $att[$i]["att_size"];
$compteur = $att[$i]["compteur"];
$visible = $att[$i]["visible"];
$att_inline = $att[$i]["inline"];
if (!$visible) {
$marqueurV = "@";
} else {
$marqueurV = "";
}
$att_link = getAttachmentUrl($apli, $post_id, $att_id, "{$att_path}/{$att_id}.{$apli}." . $marqueurV . "{$att_name}", $att_type, $att_size, $att_inline, $compteur, $visible, $Mmod);
// check for full row
if (++$ncell > $num_cells) {
// $attachments .= "</tr>\n<tr>";
$ncell = 1;
}
if (getAttDisplayMode($att_type, $att_inline) != ATT_DSP_LINK) {
if ($ncell > 1) {
while ($ncell++ <= $num_cells) {
// $attachments .= "<td> </td>";
$attachments .= "</tr>\n<tr>";
}
}
$ncell = $num_cells + 1;
// $td = "<td colspan=\"".$num_cells."\">";
} else {
// $td = "<td>";
}
// $attachments .= $td.$att_link."</td>";
$attachments .= $att_link;
$att_list[$att_id] = $att_name;
}
// $attachments .= "</tr></table>";
$attachments .= '</div>';
return $attachments;
}
}
public function index()
{
$product_model = M('Product');
$this->product = $product_model->get(array('product_id' => $this->id, 'status' => 1));
if (empty($this->product) || $this->product['status'] != 1) {
pigcms_tips('未找到相应产品', 'none');
}
$this->product['wx_image'] = option('config.site_url') . '/source/qrcode.php?type=good&id=' . $this->product['product_id'];
$is_preview = $_GET['is_preview'];
if (!is_mobile() && $this->user_session && $this->product['uid'] == $this->user_session['uid']) {
$this->assign('is_preview', $is_preview);
}
// 猜你喜欢，抽取方法为同类型的热销产品
$condition_arr = array();
//$condition_arr['category_id'] = $this->product['category_id'];
$condition_arr['status'] = 1;
$condition_arr['product_id'] = array('!=', $this->product['product_id']);
$condition_arr['store_id'] = $this->product['store_id'];
$similar_product_list = $product_model->getSelling($condition_arr, 'sort', 'desc', 0, 6);
//->where($condition_arr)->order('sort desc')->limit('0, 6')->select();
// 本店铺热卖产品，抽取方法本店铺同类型热买
//$hot_product_list = $product_model->getSelling($condition_arr, 'sales', 'desc', 0, 6);
// 检查商品库存情况
$product_sku_list = array();
$property_new_list = array();
if ($this->product['has_property']) {
//$product_sku_list = D('Product_sku')->field('`sku_id`, `properties`, `quantity`, `price`')->where(array('product_id' => $this->id, 'quantity'=>array('!=', '0')))->order('`sku_id` ASC')->select();
$product_sku_list = D('Product_sku')->field('`sku_id`, `properties`, `quantity`, `price`')->where(array('product_id' => $this->id))->order('`sku_id` ASC')->select();
$sku_price_arr = $sku_property_arr = array();
foreach ($product_sku_list as $value) {
$sku_price_arr[] = $value['price'];
$sku_property_arr[$value['properties']] = true;
}
$property_list = D('')->field('`pp`.`pid`,`pp`.`name`')->table(array('Product_to_property' => 'ptp', 'Product_property' => 'pp'))->where("`ptp`.`product_id`='" . $this->id . "' AND `pp`.`pid`=`ptp`.`pid`")->order('`ptp`.`pigcms_id` ASC')->select();
if (!empty($property_list)) {
$property_value_list = D('')->field('`ppv`.`vid`,`ppv`.`value`,`ppv`.`pid`, `ppv`.`image`')->table(array('Product_to_property_value' => 'ptpv', 'Product_property_value' => 'ppv'))->where("`ptpv`.`product_id`='" . $this->id . "' AND `ppv`.`vid`=`ptpv`.`vid`")->order('`ptpv`.`pigcms_id` ASC')->select();
if (!empty($property_value_list)) {
foreach ($property_value_list as $value) {
$propertyValueList[$value['pid']][] = array('vid' => $value['vid'], 'value' => $value['value'], 'image' => getAttachmentUrl($value['image']));
}
foreach ($property_list as $value) {
$property_new_list[] = array('pid' => $value['pid'], 'name' => $value['name'], 'image' => getAttachmentUrl($value['image']), 'values' => $propertyValueList[$value['pid']]);
}
if (count($property_new_list) == 1) {
foreach ($property_new_list[0]['values'] as $key => $value) {
$tmpKey = $property_new_list[0]['pid'] . ':' . $value['vid'];
if (empty($sku_property_arr[$tmpKey])) {
unset($property_new_list[0]['values'][$key]);
}
}
}
$returnArr['sku_list'] = $product_sku_list;
$returnArr['property_list'] = $property_new_list;
}
}
}
// 抽出店铺
$store = M('Store')->getStore($this->product['store_id']);
if (empty($store) || $store['status'] != 1) {
pigcms_tips('未找到相应的店铺或已关闭', 'none');
}
$store_contact = array();
if ($this->product['supplier_id']) {
$store_contact = M('Store_contact')->get($this->product['supplier_id']);
} else {
$store_contact = M('Store_contact')->get($this->product['store_id']);
}
// 设置浏览记录，只记录产品的product_id,只记录最近5条记录
$history_product_list = $_COOKIE['history_product_list'];
if (empty($history_product_list)) {
setcookie('history_product_list', $this->id, $_SERVER['REQUEST_TIME'] + 86400 * 365, '/');
} else {
$tmp_product_list = explode(',', $history_product_list);
array_unshift($tmp_product_list, $this->id);
$tmp_product_list = array_slice($tmp_product_list, 0, 6);
$tmp_product_list = array_unique($tmp_product_list);
$tmp_product_list = array_slice($tmp_product_list, 0, 5);
$product_id_str = join(',', $tmp_product_list);
setcookie('history_product_list', $product_id_str, $_SERVER['REQUEST_TIME'] + 86400 * 365, '/');
}
// 更改浏览次数
M('Product')->analytics(array('product_id' => $this->id));
// 主营分类
$sale_category = M('Store')->getSaleCategory($this->product['store_id'], $this->product['uid']);
// 检查是否已经收藏
$user_collect = array('click' => 'userCollect', 'title' => '收藏');
if (!empty($this->user_session)) {
$collect = D('User_collect')->where(array('type' => 1, 'user_id' => $this->user_session['uid'], 'dataid' => $this->id))->find();
if (!empty($collect)) {
$user_collect = array('click' => 'cancelCollect', 'title' => '取消收藏');
}
}
// 查看本产品是否参与活动
$reward = '';
if ($this->product['source_product_id'] == 0) {
$reward = M('Reward')->getRewardByProduct($this->product);
}
// 查找产品的图片
$product_image_list = M('Product_image')->getImages($this->id);
// 查找评论TAG数量
$where = array();
$where['type'] = 'PRODUCT';
$where['relation_id'] = $this->id;
$comment_tag_count_list = M('Comment_tag')->getCountList($where);
// 评论满意，一般，不满意数量，以及满意百分比
$comment_type_count = M('Comment')->getCountList($where);
$satisfaction_pre = '100%';
if ($comment_type_count['total'] > 0) {
$satisfaction_pre = round($comment_type_count['t3'] / $comment_type_count['total'] * 100) . '%';
}
$comment_type_count['satisfaction_pre'] = $satisfaction_pre;
// 查找系统评论TAG
$product_category_tag_list = array();
$product_category = M('Product_category')->getCategory($this->product['category_id']);
if (!empty($product_category['tag_str'])) {
$where = array();
$where['id'] = array('in', explode(',', $product_category['tag_str']));
$product_category_tag_list = M('System_tag')->geNameList($where);
}
// 店铺信息下面的评论
$where = array();
$where = array();
$where['type'] = 'PRODUCT';
$where['relation_id'] = $this->id;
$where['status'] = 1;
$where['delete_flg'] = 0;
$comment_list = M('Comment')->getSimiplyList($where);
// 最新动态
$sns_list = M('Financial_record')->sns();
$this->assign('imUrl', getImUrl($_SESSION['user']['uid'], $store['store_id']));
$this->assign('product', $this->product);
$this->assign('product_image_list', $product_image_list);
$this->assign('similar_product_list', $similar_product_list);
$this->assign('comment_type_count', $comment_type_count);
$this->assign('comment_tag_count_list', $comment_tag_count_list);
$this->assign('product_category_tag_list', $product_category_tag_list);
$this->assign('store', $store);
$this->assign('store_contact', $store_contact);
$this->assign('property_list', $property_new_list);
$this->assign('product_sku_list', $product_sku_list);
$this->assign('sale_category', $sale_category);
$this->assign('user_collect', $user_collect);
$this->assign('reward', $reward);
$this->assign('sns_list', $sns_list);
$this->assign('comment_list', $comment_list);
$this->display();
}
public function attention_store()
{
if (empty($this->user_session)) {
$referer = url('account:collect_store');
redirect(url('account:login', array('referer' => $referer)));
exit;
}
// 基本参数设定
$page = max(1, $_GET['page']);
$limit = 10;
$count = D('')->table(array('User_attention' => 'ua', 'Store' => 's'))->where("`ua`.`data_type` = '2' AND `ua`.`user_id` = '" . $this->user_session['uid'] . "' AND `ua`.`data_id` = `s`.`store_id`")->count("`ua`.`id`");
$store_list = array();
$pages = '';
if ($count > 0) {
$total_pages = ceil($count / $limit);
$page = min($page, $total_pages);
$offset = ($page - 1) * $limit;
$product_model = M('Product');
$store_list = D('')->table(array('User_attention' => 'ua', 'Store' => 's'))->where("`ua`.`data_type` = '2' AND `ua`.`user_id` = '" . $this->user_session['uid'] . "' AND `ua`.`data_id` = `s`.`store_id`")->order("`ua`.`id` DESC")->limit($offset . ',' . $limit)->select();
foreach ($store_list as &$store) {
if (empty($store['logo'])) {
$store['logo'] = getAttachmentUrl('images/default_shop_2.jpg', false);
} else {
$store['logo'] = getAttachmentUrl($store['logo']);
}
//每个店铺获取 10个热销商品 10个新品
// 店铺热销个产品
$store['hot_list'] = $product_model->getSelling(array('store_id' => $store['store_id'], 'status' => 1), 'sales', 'desc', 0, 9);
$store['hot_list_count'] = count($store['hot_list']);
/*新品*/
$store['news_list'] = $product_model->getSelling(array('store_id' => $store['store_id'], 'status' => 1), '', '', 0, 9);
$store['news_list_count'] = count($store['news_list']);
// 评论满意，一般，不满意数量，以及满意百分比
$where = array();
$where['type'] = 'STORE';
$where['relation_id'] = $store['store_id'];
$comment_type_count = M('Comment')->getCountList($where);
$satisfaction_pre = '100%';
if ($comment_type_count['total'] > 0) {
$satisfaction_pre = round($comment_type_count['t3'] / $comment_type_count['total'] * 100) . '%';
}
$store['satisfaction_pre'] = $satisfaction_pre;
$store['imUrl'] = getImUrl($_SESSION['user']['uid'], $store['store_id']);
}
// 分页
import('source.class.user_page');
$user_page = new Page($count, $limit, $page);
$pages = $user_page->show();
}
$this->assign('store_list', $store_list);
$this->assign('pages', $pages);
$this->display();
}
public function getOneTreeCategory($category_id)
{
$new_category_list = array();
$category_id = sprintf("%02d", $category_id);
$category_list = $this->db->where("find_in_set('" . $category_id . "',cat_path)")->order('`cat_fid` ASC,`cat_sort` DESC,`cat_id` ASC')->select();
foreach ($category_list as $value) {
if ($value['cat_pic']) {
$value['cat_pic'] = getAttachmentUrl($value['cat_pic']);
}
if ($value['cat_pc_pic']) {
$value['cat_pc_pic'] = getAttachmentUrl($value['cat_pc_pic']);
}
if (empty($value['cat_fid'])) {
$new_category_list[$value['cat_id']] = $value;
$arrs[$value['cat_id']] = $value;
} else {
$new_category_list[$value['cat_fid']]['cat_list'][] = $value;
}
}
return $new_category_list;
}
private function _goods_content()
{
$product = M('Product');
$store = M('Store');
$user_address = M('User_address');
$product_count = $product->fxProductCount(array('store_id' => $this->store_session['store_id'], 'supplier_id' => array('>', 0), 'status' => array('<', 2)));
import('source.class.user_page');
$page = new Page($product_count, 15);
$tmp_products = $product->fxProducts($this->store_session['store_id'], $page->firstRow, $page->listRows);
$products = array();
foreach ($tmp_products as $tmp_product) {
$supplier = $store->getStore($tmp_product['supplier_id']);
if (!empty($tmp_product['delivery_address_id'])) {
import('source.class.area');
$address = $user_address->getAddress($tmp_product['delivery_address_id']);
$address_obj = new area();
$province = $address_obj->get_name($address['province']);
$city = $address_obj->get_name($address['city']);
$area = $address_obj->get_name($address['area']);
$delivery_address = $province . ' ' . $city . ' ' . $area . ' ' . $address['address'];
} else {
$delivery_address = '使用买家收货地址';
}
$source_product = $product->get(array('product_id' => $tmp_product['source_product_id']), 'cost_price');
$products[] = array('store_id' => $tmp_product['store_id'], 'product_id' => $tmp_product['product_id'], 'name' => $tmp_product['name'], 'image' => getAttachmentUrl($tmp_product['image']), 'cost_price' => $source_product['cost_price'], 'supplier' => $supplier['name'], 'delivery_address' => $delivery_address, 'delivery_address_id' => $tmp_product['delivery_address_id'], 'is_fx_setting' => $tmp_product['is_fx_setting']);
}
$this->assign('products', $products);
$this->assign('page', $page->show());
}
$data['size'] = $uploadList[0]['size'];
$data['add_time'] = $_SERVER['REQUEST_TIME'];
$data['ip'] = get_client_ip(1);
$data['agent'] = $_SERVER['HTTP_USER_AGENT'];
if ($type == 0) {
list($data['width'], $data['height']) = getimagesize('../upload/' . $rand_num . $uploadList[0]['savename']);
}
$pigcms_id = M('Attachment_user')->add($data);
if (!$pigcms_id) {
unlink($upload_dir . $uploadList[0]['name']);
json_return(1002, '图片上传失败1');
exit;
} else {
$attachment_upload_type = option('config.attachment_upload_type');
// 上传到又拍云服务器
if ($attachment_upload_type == '1') {
import('source.class.upload.upyunUser');
upyunUser::upload('../upload/' . $rand_num . $uploadList[0]['savename'], '/' . $rand_num . $uploadList[0]['savename']);
}
json_return(0, array('id' => $pigcms_id, 'file' => getAttachmentUrl($rand_num . $uploadList[0]['savename'])));
exit;
}
} else {
json_return(1002, '图片上传失败2');
exit;
}
} else {
json_return(1002, '图片上传失败3');
exit;
}
echo ob_get_clean();
<div class="order_dec">店铺:<a href="###"><span>钱来小铺</span></a></div>
</dt> -->
<?php
$product_name_list = array();
foreach ($order['proList'] as $product) {
$product_name_list[$product['product_id']] = $product['name'];
$total_price += $product['pro_num'] * $product['pro_price'];
?>
<dd class="clearfix">
<div class="product_1 clearfix">
<div class="order_product_img">
<a href="<?php
echo url_rewrite('goods:index', array('id' => $product['product_id']));
?>
"><img src="<?php
echo getAttachmentUrl($product['image']);
?>
"></a>
</div>
<div class="order_product_txt">
<div class="order_product_txt_name"><a href="<?php
echo url_rewrite('goods:index', array('id' => $product['product_id']));
?>
"><?php
echo htmlspecialchars($product['name']);
?>
</a></div>
<?php
if (is_array($product['sku_data_arr'])) {
?>
<div class="order_product_txt_dec clearfix">
$brand[$key]['url'] = 'home.php?id=' . $value['store_id'];
if (empty($value['logo'])) {
$brand[$key]['logo'] = getAttachmentUrl('images/default_shop_2.jpg', false);
} else {
$brand[$key]['logo'] = getAttachmentUrl($value['logo']);
}
}
//首页推荐商品
$product_list = M('Product')->getSelling('quantity>0 AND status=1 AND is_recommend = 1', '', '', 0, 4);
//D('Product')->where('quantity>0 AND status=1 AND is_recommend = 1')->limit('4')->select();
//首页推荐活动
$active_list = D('Activity_recommend')->order("is_rec desc,ucount desc")->limit(4)->select();
$activity = M('activity');
foreach ($active_list as $k => $value) {
$active_list[$k]["url"] = $activity->createUrl($value, $value['model'], '1');
$active_list[$k]["image"] = getAttachmentUrl($value['image']);
}
} else {
if (empty($config['platform_mall_index_page'])) {
pigcms_tips('请管理员在管理后台【系统设置】=》【站点配置】=》【平台商城配置】选取微页面', 'none');
}
//首页的微杂志
$homePage = D('Wei_page')->where(array('page_id' => $config['platform_mall_index_page']))->find();
if (empty($homePage)) {
pigcms_tips('您访问的店铺没有首页', 'none');
}
}
$imUrl = getImUrl($_SESSION['wap_user']['uid'], $store_id);
$is_have_activity = option('config.is_have_activity');
//分享配置 start
$share_conf = array('title' => option('config.site_name'), 'desc' => str_replace(array("\r", "\n"), array('', ''), option('config.seo_description')), 'link' => option('config.wap_site_url'), 'imgUrl' => option('config.site_logo'), 'type' => '', 'dataUrl' => '');
public function sellers($where, $offset = 0, $limit = 0)
{
$sql = "SELECT *,s.status,s.drp_profit as profit FROM " . option('system.DB_PREFIX') . "store s, " . option('system.DB_PREFIX') . 'store_supplier ss WHERE s.store_id = ss.seller_id';
if (!empty($where)) {
foreach ($where as $key => $value) {
if (is_array($value)) {
if (array_key_exists('like', $value)) {
$sql .= " AND " . $key . " like '" . $value['like'] . "'";
} else {
if (array_key_exists('in', $value)) {
$sql .= " AND " . $key . " in (" . implode(',', $value['like']) . ")";
}
}
} else {
$sql .= " AND " . $key . "=" . $value;
}
}
}
$sql .= ' ORDER BY s.status ASC,s.drp_approve ASC,s.store_id DESC';
if ($limit) {
$sql .= ' LIMIT ' . $offset . ',' . $limit;
}
$sellers = $this->db->query($sql);
foreach ($sellers as &$tmp) {
$tmp['logo'] = getAttachmentUrl($tmp['logo']);
}
return $sellers;
}
public function storeContactList($store_id_arr)
{
if (empty($store_id_arr) || !is_array($store_id_arr)) {
return array();
}
$store_contact_list = D('')->table(array('Store' => 's', 'Store_contact' => 'sc'))->where("`s`.`store_id` IN (" . join(',', $store_id_arr) . ") AND `s`.`store_id` = `sc`.`store_id`")->field(`sc.*, s.name`)->select();
import('area');
$areaClass = new area();
$return_data = array();
foreach ($store_contact_list as $value) {
$value['province_txt'] = $areaClass->get_name($value['province']);
$value['city_txt'] = $areaClass->get_name($value['city']);
$value['county_txt'] = $areaClass->get_name($value['county']);
$value['logo'] = getAttachmentUrl($value['logo']);
$return_data[$value['store_id']] = $value;
}
return $return_data;
}
}
}
$cartList[$key]['buy_quantity'] = $quantity;
} else {
$cartList[$key]['buy_quantity'] = 0;
}
$cartList[$key]['sku_num'] = 0;
if ($value['sku_id'] && $value['quantity'] && $value['status'] == 1) {
$nowSku = $database_product_sku->field('`quantity`')->where(array('sku_id' => $value['sku_id']))->find();
$cartList[$key]['sku_num'] = $nowSku['quantity'];
} else {
if ($value['quantity']) {
$cartList[$key]['sku_num'] = $value['quantity'];
}
}
$cartList[$key]['image'] = getAttachmentUrl($value['image']);
}
//分享配置 start
$share_conf = array('title' => $now_store['name'], 'desc' => str_replace(array("\r", "\n"), array('', ''), $now_store['intro']), 'link' => $now_store['url'], 'imgUrl' => $now_store['logo'], 'type' => '', 'dataUrl' => '');
import('WechatShare');
$share = new WechatShare();
$shareData = $share->getSgin($share_conf);
//分享配置 end
include display('cart');
} else {
if ($action == 'quantity') {
if (empty($_POST['id'])) {
json_return(1, '数据异常');
}
if (!empty($_POST['skuId'])) {
$condition_product_sku['sku_id'] = $_POST['skuId'];
