public function edit() { $id = I('id'); $admin = M('admin'); $data = $admin->find($id); $address = $data['address']; $arr = explode("#", $address); $data['address'] = $arr[3]; $a = array($arr[0], $arr[1], $arr[2]); $city = Area::city($a); $this->assign("city", $city); $this->assign('admin', $data); $this->display(); }
public function address() { //地址列表显示 $useraddress = M("useraddress"); $id = session('uid'); $data = $useraddress->where("user_id={$id}")->select(); $this->assign("useraddress", $data); foreach ($data as $k => &$v) { $v[$v['id']] = str_replace('#', '', $v['address']); //完整地址 $v['last'] = explode('#', $v['address'])[3]; } $this->assign("address", $data); //三级连动地址 $city = Area::city(); $this->assign("city", $city); $this->display(); }
public function index() { //判断用户是否登录 if (empty($_SESSION['user'])) { $this->redirect('Login/index'); } //判断是否有收货地址 $addr = M('address'); $res = $addr->where('uid=' . $_SESSION['user'][0]['id'])->select(); if (!empty($res)) { $this->redirect('Order/buy'); } //地区显示 $Area = array("请选择", "请选择", "请选择"); $city = Area::city($Area); $this->assign("city", $city); $this->display('city'); }
public function order() { $user_id = session('uid'); //根据user_id 查询出地址 $useraddress = M('useraddress'); //主地址 $main_add = $useraddress->where("user_id={$user_id} AND ismain=2")->find(); $adds = $useraddress->where("user_id={$user_id} AND ismain=1")->select(); //========将session中的值分配到订单页========== $order = session('order'); $this->assign('orders', $order); //dump($order); //exit; //==========地址三级连动================= $city = Area::city(); $this->assign("city", $city); $this->assign('main_add', $main_add); $this->assign('adds', $adds); $this->display(); }
public function collect() { //SEO $ident = "collect"; $idents = $this->seo($ident); $this->assign('productactive', 'active'); $this->assign("title", $idents['title']); $this->assign("keywords", $idents['keywords']); $this->assign("description", $idents['description']); $buy_now = I('get.buy'); $user_id = $_SESSION['user']['userid']; if ($user_id == "") { $this->redirect("Login/login"); } else { $user_confirmation = $_SESSION['user']['userconfirmation']; if (!$user_confirmation) { $this->error('购买前,请先补全个人信息!', U('MobileMember/information'), 3); exit; } //物流信息 $shipping = M("shippings"); $ship_company = M("shipping_company"); $ships = $shipping->order('is_default desc')->select(); foreach ($ships as &$v1) { $v1['cname'] = $ship_company->field("cname")->where("id = " . $v1['sid'])->find(); } // dump($ships); // die; $this->assign("ships", $ships); //收货地址 //$user_id = $_SESSION['user']['userid']; $user = $_SESSION['user']['username']; $add = M("user_address"); $address = $add->where("user_id = " . $user_id)->order('is_default desc')->select(); if ($buy_now == 'now') { $cart = $_SESSION['order']; $this->assign('buy_now', $buy_now); } else { $cart = isset($_COOKIE['cart']) ? unserialize($_COOKIE['cart']) : array(); } // 循环每一个商品取出详情信息 $db = M("product"); $list = M("products_attr"); $_cart = array(); $sum = ""; $num = ""; foreach ($cart as $k => $v) { $_attr = explode('-', $k); $_cart[$k]['id'] = $_attr[0]; $_cart[$k]['versionId'] = $_attr[1]; $_cart[$k]['colorId'] = $_attr[2]; $img = $db->field("list_image,pro_name,promote_price,is_ship,is_promote,unit,unit_weight,weight_unit")->where(array('id' => $_cart[$k]['id']))->find(); $_cart[$k]['img'] = $img['list_image']; $_cart[$k]['pro_name'] = $img['pro_name']; $_cart[$k]['is_ship'] = $img['is_ship']; $_cart[$k]['unit'] = $img['unit']; $_cart[$k]['weight_unit'] = $img['weight_unit']; if ($_cart[$k]['is_ship']) { $_cart[$k]['unit_weight'] = 0; } else { $_cart[$k]['unit_weight'] = $img['unit_weight']; } if ($_cart[$k]['weight_unit'] == "克") { $weightper = $_cart[$k]['unit_weight'] / 1000; } elseif ($_cart[$k]['weight_unit'] == "千克") { $weightper = $_cart[$k]['unit_weight']; } $_cart[$k]['promote_price'] = $img['promote_price']; $_cart[$k]['color'] = $list->field('prop_name,prop_price')->where(array('id' => $_cart[$k]['colorId']))->find(); $_cart[$k]['version'] = $list->field('prop_name,prop_price')->where(array('id' => $_cart[$k]['versionId']))->find(); //取库存 $ModelNum = M('productnum'); $attrls = array(); $attrls = array($_cart[$k]['colorId'], $_cart[$k]['versionId']); sort($attrls); $attrls = implode('|', $attrls); $map['product_id'] = $_cart[$k]['id']; $map['product_attr'] = $attrls; $_cart[$k]['num'] = $ModelNum->where($map)->getfield('product_number'); $_cart[$k]['price'] = $_cart[$k]['promote_price'] + $_cart[$k]['color']['prop_price'] + $_cart[$k]['version']['prop_price']; $_cart[$k]['ordernum'] = $v; //取出促销信息 if ($img['is_promote']) { $ProModel = M('promote'); $_cart[$k]['promote'] = $ProModel->where(array('product_id' => $_cart[$k]['id']))->find(); if ($_cart[$k]['promote']['status'] == 1) { $_cart[$k]['price'] = $_cart[$k]['price'] * ($promote['rate'] / 100); } if ($_cart[$k]['promote']['status'] == 2) { if ($_SESSION['user']['userlevel']) { $MemRate = M('members_rate'); $Memrate = $MemRate->where(array('product_id' => $_cart[$k]['id'], 'level_id' => $_SESSION['user']['userlevel']))->getField('rate'); $promote['rate'] = $Memrate; $_cart[$k]['price'] = $_cart[$k]['price'] * ($promote['rate'] / 100); } } if ($_cart[$k]['promote']['status'] == 3) { $giftId = $ProModel->where(array('product_id' => $_cart[$k]['id']))->getField('gifts'); $_cart[$k]['promote']['gift'] = $db->field('list_image,id,pro_name,market_price')->where(array('id' => $giftId))->find(); } if ($_cart[$k]['promote']['status'] == 4) { $gift = $ProModel->field('condition,gifts')->where(array('product_id' => $_cart[$k]['id']))->find(); if ($_cart[$k]['ordernum'] >= $gift['condition']) { $_cart[$k]['promote']['gift'] = $db->field('list_image,id,pro_name,market_price')->where(array('id' => $gift['gifts']))->find(); } } if ($_cart[$k]['promote']['status'] == 5) { $qiang = $ProModel->field('id,status,start_time,end_time,rate')->where(array('product_id' => $_cart[$k]['id']))->find(); $now = time(); if ($qiang['start_time'] <= $now and $qiang['end_time'] > $now) { $_cart[$k]['price'] = $_cart[$k]['price'] * ($qiang['rate'] / 100); } } } $sum += $_cart[$k]['price'] * $_cart[$k]['ordernum']; $num += $_cart[$k]['ordernum']; $weight += $weightper * $_cart[$k]['ordernum']; } // dump($_cart); // die; $this->assign('weight', $weight); $this->assign("num", $num); $this->assign("sum", $sum); $this->assign("goods", $_cart); $this->assign("address", $address); //三级联动 $city = array("--请选择省--", "--市--", "--区县--"); $c = Area::city($city); // dump($c); // die; $this->assign("city", $c); $this->display(); } }
public function addressGet() { $id = $_POST['id']; $db = M('user_address'); $row = $db->where("id = {$id}")->find(); $province = $row['province']; $city = $row['city']; $area = $row['area']; $city = array($province, $city, $area); $c = Area::city($city); $this->assign("o", $c); $this->ajaxReturn($row); $this->display('address'); }
public function index() { //==========地址三级连动================= $city = Area::city(); $this->assign("city", $city); //=============根据商品 id 获取商品评价====== $goods = M('goods'); //作为测试 假设商品id=1 $goods_id = I('id'); // $goodsreviews = M('goodsreviews'); //===========将浏览次浏览记录添加到浏览历史开始================= $histories = M('histories'); $his['goods_id'] = $goods_id; $his['user_id'] = session('uid'); $his['addtime'] = time(); //dump($his); $data = $histories->where("goods_id={$his['goods_id']}")->find(); if (!$data) { if ($histories->create($his)) { $histories->add(); } } //===========将浏览次浏览记录添加到浏览历史结束================= $users = M('users'); $attr = M('attr'); $attrvalue = M('attrvalue'); //==========获取商品的详细信息============ $goods_info = $goods->find($goods_id); //根据商品的id获取属性id,进而获取属性值 $attr_ids = $attr->where("goods_id={$goods_id}")->select(); $attrvalue_id = ""; //定义一个变量,用户存放属性值id $stock = 0; //定义一个变量,用户存放总库存 foreach ($attr_ids as $attr_id) { $attrvalue_id .= $attr_id['attrvalue_id'] . ","; $stock += $attr_id['stock']; } $attrvalue_id = rtrim($attrvalue_id, ","); //获取商品分类级别栏 $type_id = $goods_info['type_id']; //所属类别ID $typeData = getData('type'); $typeIds = getParentId($typeData, $type_id); $typeIds = explode(',', $typeIds); //组合数组 foreach ($typeData as $v) { $typeInfo[$v['id']] = $v['name']; //遍历得到一维数组,下标为类ID,值为类名称 } //获取颜色 $c['attrname'] = array('EQ', "颜色"); $c['id'] = array("IN", $attrvalue_id); $at_value['color'] = $attrvalue->where($c)->select(); //获取尺寸 $s['attrname'] = array('EQ', "尺码"); $s['id'] = array("IN", $attrvalue_id); $at_value['size'] = $attrvalue->where($s)->select(); //dump($at_value); //exit; //=================获取全部评价数,好,中,差======== $al['goods_id'] = array('EQ', $goods_id); $al['state'] = array('EQ', "1"); $count['all'] = $goodsreviews->where($al)->count(); $wl['goods_id'] = array('EQ', $goods_id); $wl['star'] = array('EQ', "5"); $count['w'] = $goodsreviews->where($wl)->count(); $ml['goods_id'] = array('EQ', $goods_id); $ml['star'] = array('IN', "3,4"); $count['m'] = $goodsreviews->where($ml)->count(); $bl['goods_id'] = array('EQ', $goods_id); $bl['star'] = array('IN', "1,2"); $count['b'] = $goodsreviews->where($bl)->count(); //====好,中差评率=== $rate['w'] = ceil($count['w'] / $count['all'] * 100); $rate['m'] = floor($count['m'] / $count['all'] * 100); $rate['b'] = floor($count['b'] / $count['all'] * 100); //=======================获取商品全部评价============================================ $page_count = $goodsreviews->where($al)->count(); $Page = new \Think\Page($page_count, 10); $all_show = $Page->show(); $all_data = $goodsreviews->where($al)->limit($Page->firstRow . ',' . $Page->listRows)->select(); // dump($all_data); // exit; //获取到评论人的 id ,在根据id 获取到====(会员名)===(会员等级)===== $reviewsreply = M('reviewsreply'); foreach ($all_data as $all) { //将评论信息存储到以评论id为名字的数组中,下标为'review' , $a[$all['id']]['review'] = $all; //获取评论人的id,进而获取详细信息,并将获取的信息储存到 $a[$all['id']]['user'] $user_id = $all['user_id']; $a[$all['id']]['user'] = $users->where("id={$user_id}")->find(); //评论id = $all['id'] ,利用其查询出对应的回复 $a[$all['id']]['reviewsreply'] = $reviewsreply->where("reviews_id={$all['id']}")->order('addtime desc')->limit("5")->select(); $a[$all['id']]['count'] = $reviewsreply->where("reviews_id={$all['id']}")->order('addtime desc')->count(); } //=======================获取商品好评============================================ $all_data = $goodsreviews->where($wl)->select(); //获取到评论人的 id ,在根据id 获取到====(会员名)===(会员等级)===== $reviewsreply = M('reviewsreply'); foreach ($all_data as $all) { //将评论信息存储到以评论id为名字的数组中,下标为'review' , $w[$all['id']]['review'] = $all; //获取评论人的id,进而获取详细信息,并将获取的信息储存到 $a[$all['id']]['user'] $user_id = $all['user_id']; $w[$all['id']]['user'] = $users->find($user_id); //评论id = $all['id'] ,利用其查询出对应的回复 $w[$all['id']]['reviewsreply'] = $reviewsreply->where("reviews_id={$all['id']}")->order('addtime desc')->limit("5")->select(); $w[$all['id']]['count'] = $reviewsreply->where("reviews_id={$all['id']}")->order('addtime desc')->count(); } //=======================获取商品中评============================================ $all_data = $goodsreviews->where($ml)->select(); //获取到评论人的 id ,在根据id 获取到====(会员名)===(会员等级)===== $reviewsreply = M('reviewsreply'); foreach ($all_data as $all) { //将评论信息存储到以评论id为名字的数组中,下标为'review' , $m[$all['id']]['review'] = $all; //获取评论人的id,进而获取详细信息,并将获取的信息储存到 $a[$all['id']]['user'] $user_id = $all['user_id']; $m[$all['id']]['user'] = $users->find($user_id); //评论id = $all['id'] ,利用其查询出对应的回复 $m[$all['id']]['reviewsreply'] = $reviewsreply->where("reviews_id={$all['id']}")->order('addtime desc')->limit("5")->select(); $m[$all['id']]['count'] = $reviewsreply->where("reviews_id={$all['id']}")->order('addtime desc')->count(); } //=======================获取商品差评============================================ $all_data = $goodsreviews->where($bl)->select(); //获取到评论人的 id ,在根据id 获取到====(会员名)===(会员等级)===== $reviewsreply = M('reviewsreply'); foreach ($all_data as $all) { //将评论信息存储到以评论id为名字的数组中,下标为'review' , $b[$all['id']]['review'] = $all; //获取评论人的id,进而获取详细信息,并将获取的信息储存到 $a[$all['id']]['user'] $user_id = $all['user_id']; $b[$all['id']]['user'] = $users->find($user_id); //评论id = $all['id'] ,利用其查询出对应的回复 $b[$all['id']]['reviewsreply'] = $reviewsreply->where("reviews_id={$all['id']}")->order('addtime desc')->limit("5")->select(); $b[$all['id']]['count'] = $reviewsreply->where("reviews_id={$all['id']}")->order('addtime desc')->count(); } $best_data = $goods->where("ishot=2 AND state = 2")->limit('10')->order('addtime')->select(); //热销商品 $this->assign('typeIds', $typeIds); //所属类前辈类ID数组(一维) $this->assign('typeInfo', $typeInfo); //类信息数组(一维) $this->assign('type_id', $type_id); //所属类ID $this->assign('best_goods', $best_data); $this->assign('histories', $hot_data); $this->assign("count", $count); //评论数 $this->assign("rate", $rate); //好评率 $this->assign("goods_info", $goods_info); //商品信息 $this->assign("a", $a); //$a 全部评级 $this->assign("w", $w); //$w 好评 $this->assign("m", $m); //$m 中评 $this->assign("b", $b); //$b 差评 $this->assign("all_page", $all_show); //评论分页 $this->assign("at_color", $at_value['color']); //商颜色属性值 $this->assign("at_size", $at_value['size']); //商品尺寸属性值 //$this -> assign("stock",$stock); //商品库存量 $this->display(); }
public function add() { $city = Area::city(); $this->assign("city", $city); $this->display(); }
public function applyProcess() { //SEO $ident = "service"; $idents = $this->seo($ident); $this->assign("title", $idents['title']); $this->assign("keywords", $idents['keywords']); $this->assign("description", $idents['description']); $pro_attr = M("products_attr"); $product = M("product"); $order_product = M("order_products"); $order = M("orders"); $product_id = $_GET['id']; $order_id = $_GET['ids']; $map['order_id'] = $map2['a.id'] = array("eq", $order_id); $user_id = $_SESSION['user']['userid']; $map['user_id'] = $map2['a.user_id'] = array("eq", $user_id); $map['product_id'] = $map2['b.product_id'] = array("eq", $product_id); //判断是否存在订单 $orders = $order->alias('a')->join('LEFT JOIN im_order_products b ON a.id = b.order_id')->where($map2)->find(); if (!$orders) { $this->error('订单不存在请检查!'); exit; } //查找商品是否有赠品 $zp = $pro_attr->field("prop_value")->where("pro_id = " . $product_id . " AND prop_id =3")->find(); if ($zp) { $list = $product->field("pro_name")->where("id IN (" . $zp['prop_value'] . ")")->select(); $this->assign("zplist", $list); } //查找商品的购买数量 $number = $order_product->field("product_number")->where($map)->find(); $this->assign("number", $number); //查找商品的信息 $pro = $product->field("id,pro_name,pro_subname,list_image")->where("id = " . $product_id)->find(); $this->assign("product", $pro); //查找收货人的信息 $addr = $order->field(shipping_addr_id)->where("id = " . $order_id)->find(); $user_addr = M("user_address"); $address = $user_addr->where("id = " . $addr['shipping_addr_id'])->find(); $city = array($address['province'], $address['city'], $address['area']); $c = Area::city($city); $this->assign("city", $c); $this->assign("order_id", $order_id); $this->assign("address", $address); $this->display(); }
public function addressMod() { if (empty($_SESSION['user'])) { $this->redirect('Login/index'); } $uid = $_SESSION['user'][0]['id']; $u['uid'] = $uid; $address = M("address"); $id = I('id'); $data = $address->where($u)->where('id=' . $id)->find(); //dump($data); $addr = $data['addr']; $res = explode('|', $addr); $pro = $res[0]; $cit = $res[1]; $cou = $res[2]; $add = $res[3]; $c = array("{$pro}", "{$cit}", "{$cou}"); $city = Area::city($c); $this->assign("city", $city); //dump($c); $this->assign('add', $res[3]); //dump($res); $this->assign('address', $data); $this->display(); }
/** * 会员基本资料修改 * @date 2015-01-18 * @return void */ public function userEdit() { $getUserId = I('get.id'); $modelUserInfo = M(); $userInfoRes = $modelUserInfo->table('__USERS__ AS u, __USER_INFO__ AS i')->where("u.id = i.user_id AND u.id='{$getUserId}'")->find(); if (!empty($userInfoRes['province'])) { $city = array($userInfoRes['province'], $userInfoRes['city'], $userInfoRes['area']); } else { $city = array('选择省', '选择市', '选择县'); } $c = Area::city($city); $this->assign('user', $userInfoRes); $this->assign("city", $c); $this->display('user_edit'); }