function get_group_price($unionid)
{
$unionid = explode('、', $unionid);
$total = "";
foreach ($unionid as $val) {
$id = $val;
$total += get_good_price($id);
}
return $total;
}
public function getPriceByuid()
{
$user = D("member");
$uid = $user->uid();
//数量为0，价钱为0
if ($this->getCnt() == 0) {
return 0;
}
$price = 0.0;
$data = M("shopcart")->where("uid='{$uid}'")->select();
foreach ($data as $k => $val) {
$id = $val['goodid'];
$price = get_good_price($id);
$total += $val['num'] * $price;
}
return sprintf("%01.2f", $total);
}
public function getPriceByuid()
{
$user = D("member");
$uid = $user->uid();
$map["uid"] = $uid;
//数量为0，价钱为0
if ($this->getCnt() == 0) {
return 0;
} else {
$total = 0.0;
$data = $this->where($map)->select();
foreach ($data as $k => $val) {
$id = $val['goodid'];
$price = get_good_price($id);
$total += $val['num'] * $price;
}
}
return sprintf("%01.2f", $total);
}
public function cancel()
{
$this->meta_title = '取消订单';
/* 左侧菜单 */
$menu = R('index/menulist');
$this->assign('categoryq', $menu);
/* 购物车调用*/
$cart = R("shopcart/usercart");
$this->assign('usercart', $cart);
if (!session('user_auth')) {
$usercart = $_SESSION['cart'];
$this->assign('usercart', $usercart);
}
/* 底部分类调用*/
$menulist = R('Service/AllMenu');
$this->assign('footermenu', $menulist);
/* 热词调用*/
$hotsearch = R("Index/getHotsearch");
$this->assign('hotsearch', $hotsearch);
if (IS_POST) {
$id = I('post.id');
//获取orderid
$order = M("order");
$status = $order->where("orderid='{$id}'")->getField("status");
$num = $order->where("orderid='{$id}'")->getField("ispay");
$shopid = $order->where("orderid='{$id}'")->getField("id");
$data = $order->where("id='{$shopid}'")->select();
foreach ($data as $k => $val) {
$goodid = $val['goodid'];
$price = get_good_price($goodid);
/*取消的商品总额*/
$cash += $val['num'] * $price;
/*退货中的商品件数*/
$num += $val['num'];
/*退货中的商品种类数*/
$count += 1;
}
//订单已提交或未支付直接取消
if ($num == -1 && $status == 1 || $num == 1 && $status == -1) {
//设置订单取消
//保存数据到取消表中后台调用
$cancel = D("cancel");
$cancel->create();
$cancel->create_time = NOW_TIME;
$cancel->status = 3;
$cancel->orderid = $id;
$cancel->cash = $cash;
//取消的金额
$cancel->num = $num;
//取消的数量
$cancel->count = $count;
//取消的种类
$cancel->info = "自助取消";
$cancel->add();
//设置订单为订单已取消
$data = array('status' => '6', 'backinfo' => '订单已关闭');
//更新订单列表订单状态为已取消，清空取消订单操作
if ($order->where("orderid='{$id}'")->setField($data)) {
$this->success('申请成功，订单已取消', U("center/index"));
} else {
$this->error('申请失败，请重试');
}
} else {
$cancel = D("cancel");
$cancel->create();
$cancel->time = NOW_TIME;
$cancel->status = 1;
$cancel->orderid = $id;
$cancel->cash = $cash;
//取消的金额
$cancel->num = $num;
//取消的数量
$cancel->count = $count;
//取消的种类
$cancel->add();
$data = array('status' => '4');
//设置订单状态为已提交，发货等状态不变
if ($order->where("orderid='{$id}'")->setField($data)) {
$this->success('申请成功', U("center/allorder"));
} else {
$this->error('申请失败，请重试');
}
}
} else {
$id = I('get.id');
//获取orderid
$msg = "申请取消订单:";
$order = M("order");
$detail = $order->where("orderid='{$id}'")->select();
$num = $order->where("orderid='{$id}'")->getField("status");
if ($num == "1") {
$paynum = $order->where("orderid='{$id}'")->getField("ispay");
if ($paynum == "1") {
$info = "当前订单状态为未完成支付";
}
if (!$paynum) {
$info = "当前订单已提交等待发货中";
}
}
if ($num == "2") {
$info = "当前提交的订单已发货,需审核通过后取消";
}
$list = M("shoplist");
foreach ($detail as $n => $val) {
$detail[$n]['id'] = $list->where('orderid=\'' . $val['id'] . '\'')->select();
}
$this->assign('info', $info);
$this->assign('detaillist', $detail);
$this->assign('id', $id);
$this->assign('msg', $msg);
$this->display();
$this->meta_title = '取消订单';
}
}
}
}
} else {
echo "";
}
?>
</ul>
</div>
<div class="salesrank">
<h5><span>最近浏览</span></h5>
<ul><?php
if (is_array($recent)) {
$i = 0;
$__LIST__ = $recent;
if (count($__LIST__) == 0) {
echo "";
} else {
foreach ($__LIST__ as $key => $vo) {
$mod = $i % 2;
++$i;
?>
<li><a class="picture" href="<?php
echo U('Article/detail?id=' . $vo['page']);
?>
"><img src="<?php
echo get_cover(get_cover_id($vo["page"]), 'path');
?>
" ></a>
<a class="title" href="<?php
echo U('Article/detail?id=' . $vo['page']);
public function index()
{
if (!is_login()) {
$this->error("您还没有登陆", U("User/login"));
}
$this->meta_title = '取消订单';
if (IS_POST) {
$id = I('post.id', '', 'strip_tags');
//获取orderid
$id = safe_replace($id);
//过滤
$order = M("order");
$status = $order->where("orderid='{$id}'")->getField("status");
$num = $order->where("orderid='{$id}'")->getField("ispay");
$shopid = $order->where("orderid='{$id}'")->getField("id");
$data = $order->where("id='{$shopid}'")->select();
foreach ($data as $k => $val) {
$goodid = $val['goodid'];
$price = get_good_price($goodid);
/*取消的商品总额*/
$cash += $val['num'] * $price;
/*退货中的商品件数*/
$num += $val['num'];
/*退货中的商品种类数*/
$count += 1;
}
//订单已提交或未支付直接取消
if ($num == -1 && $status == 1 || $num == 1 && $status == -1) {
//设置订单取消
//保存数据到取消表中后台调用
$cancel = D("cancel");
$cancel->create();
$cancel->create_time = NOW_TIME;
$cancel->status = 3;
$cancel->orderid = $id;
$cancel->cash = $cash;
//取消的金额
$cancel->num = $num;
//取消的数量
$cancel->count = $count;
//取消的种类
$cancel->info = "自助取消";
$cancel->add();
addUserLog('取消订单', $uid);
//设置订单为订单已取消
$data = array('status' => '6', 'backinfo' => '订单已关闭');
//更新订单列表订单状态为已取消，清空取消订单操作
if ($order->where("orderid='{$id}'")->setField($data)) {
$this->success('申请成功，订单已取消', U("center/index"));
} else {
$this->error('申请失败，请重试');
}
} else {
$cancel = D("cancel");
$cancel->create();
$cancel->time = NOW_TIME;
$cancel->status = 1;
$cancel->orderid = $id;
$cancel->cash = $cash;
//取消的金额
$cancel->num = $num;
//取消的数量
$cancel->count = $count;
//取消的种类
$cancel->add();
addUserLog('申请取消订单', $uid);
$data = array('status' => '4');
//设置订单状态为已提交，发货等状态不变
if ($order->where("orderid='{$id}'")->setField($data)) {
$this->success('申请成功', U("center/allorder"));
} else {
$this->error('申请失败，请重试');
}
}
} else {
$id = I('get.id', '', 'strip_tags');
//获取orderid
$msg = "申请取消订单:";
$id = safe_replace($id);
//过滤
$order = M("order");
$detail = $order->where("orderid='{$id}'")->select();
$num = $order->where("orderid='{$id}'")->getField("status");
if ($num == "1") {
$paynum = $order->where("orderid='{$id}'")->getField("ispay");
if ($paynum == "1") {
$info = "当前订单状态为未完成支付";
}
if (!$paynum) {
$info = "当前订单已提交等待发货中";
}
}
if ($num == "2") {
$info = "当前提交的订单已发货,需审核通过后取消";
}
$list = M("shoplist");
foreach ($detail as $n => $val) {
$detail[$n]['id'] = $list->where('orderid=\'' . $val['id'] . '\'')->select();
}
$this->assign('info', $info);
$this->assign('detaillist', $detail);
$this->assign('id', $id);
$this->assign('msg', $msg);
$this->display();
$this->meta_title = '取消订单';
}
}
public function Addgood($a, $b)
{
$Tuanid = $a;
$good = $b;
$array = explode(',', $good);
$User = M("Tuanid");
if ($User->where("Tuanpid='{$Tuanid}'")->select()) {
$User->where("Tuanpid='{$Tuanid}'")->delete();
//商品列表如果存在则删除，重新循环遍历
for ($i = 0; $i < count($array); $i++) {
$goodid = $array[$i];
$data["goodid"] = $goodid;
$data["price"] = get_good_tuanprice($goodid);
$data["view"] = get_good_view($goodid);
$data["salenumber"] = get_sales($goodid);
$data["tuanpid"] = $Tuanid;
$data["create_time"] = time();
// 设置用户的创建时间
$User->add($data);
}
} else {
//商品列表不存在，遍历添加
for ($i = 0; $i < count($array); $i++) {
$goodid = $array[$i];
$data["goodid"] = $goodid;
$data["Tuanpid"] = $Tuanid;
$data["price"] = get_good_price($goodid);
$data["view"] = get_good_view($goodid);
$data["salenumber"] = get_sales($goodid);
$data["create_time"] = time();
// 设置用户的创建时间
$User->add($data);
}
}
}
</a>
</div>
</div>
<div class="name"><a href="<?php
echo U('Article/detail?id=' . $article['id']);
?>
" benlai-source="1" benlai-location="13-1" target="_blank" title="<?php
echo $article["title"];
?>
"><?php
echo get_good_shorttitle($article["id"]);
?>
</a></div>
<div class="price">
<font>￥</font><span><?php
echo get_good_price($article["id"]);
?>
</span>
<span style="color: #999999; font-size: 12px; font-weight: 400; margin-left: 3px; text-decoration: line-through"><?php
echo get_good_yprice($article["id"]);
?>
</span>
</div>
</li><?php
}
}
} else {
echo "";
}
?>
function get_discount_Byid($id)
{
$groupbuying = M("document_limitbuying");
$map['id'] = $id;
$info = $groupbuying->where($map)->find();
$price = get_good_price($id);
$discount = $price * 10 / $info['market_price'];
return sprintf("%1\$.1f", $discount);
}
public function getPricetotal($id)
{
$data = M("shoplist")->where("orderid='{$id}'")->select();
foreach ($data as $k => $val) {
$goodid = $val['goodid'];
$price = get_good_price($goodid);
$total += $val['num'] * $price;
}
return sprintf("%01.2f", $total);
}
public function month()
{
$month = date('Y年m月', NOW_TIME);
/*格式时间戳为 201410*/
$this->assign('month', $month);
//date('w',$time); 取到的是星期几 0-6
//date('W',$time); 取到的是本年度的第几周 1-53
// php获取本月起始时间戳和结束时间戳
$beginThismonth = mktime(0, 0, 0, date('m'), 1, date('Y'));
$endThismonth = mktime(23, 59, 59, date('m'), date('t'), date('Y'));
$this->meta_title = '管理首页';
$title = "本月数据统计 ";
$q = date('YmdHis', $beginThismonth);
/*本月一零点格式时间戳为20141020000000*/
$b = date('YmdHis', $endThismonth);
/*本月末格式时间戳为201410270000000*/
/*本月销量统计*/
$order = M("order")->where("total!=''")->select();
foreach ($order as $n => $val) {
$time = $val['create_time'];
$a = date('YmdHis', $time);
/*格式时间戳为 20141020000*/
if ($b > $a && $a > $q) {
//本月
/*商品销售额*/
$salesmoney += $val['total'];
/*运费*/
$trans += $val['shipprice'];
/*总销售额*/
$total += $val['pricetotal'];
$id = $val['id'];
$list = M("shoplist")->where("orderid='{$id}'")->select();
foreach ($list as $k => $vo) {
/*退货中的商品id*/
$goodid = $vo['goodid'];
$price = get_good_price($goodid);
/*销售的商品件数*/
$salenum += $vo['num'];
/*销售的商品种类数*/
$salecount += 1;
}
}
}
$this->assign('salecount', $salecount);
$this->assign('salenum', $salenum);
$this->assign('total', $total);
/**
* 本月退货金额、种类、数量计算
*/
$data = M("backlist")->where("status='1'")->select();
foreach ($data as $n => $val) {
/*格式时间戳为 201410240000*/
$dtime = $val['create_time'];
$d = date('YmdHis', $dtime);
if ($b > $d && $d > $q) {
//当天
/*退货中的商品id*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
/*退货中的商品总额*/
$back += $val['num'] * $price;
/*退货中的商品件数*/
$backnum += $val['num'];
/*退货中的商品种类数*/
$backcount += 1;
}
}
$this->assign('back', $back);
$this->assign('backcount', $backcount);
$this->assign('backnum', $backnum);
/**
* 本月换货金额、种类、数量计算
*/
$data = M("exchange")->where("status='1'")->select();
foreach ($data as $k => $vo) {
$qtime = $vo['create_time'];
$f = date('YmdHis', $qtime);
if ($b > $f && $f > $q) {
/*换货中的商品总额*/
$goodid = $vo['goodid'];
$price = get_good_price($goodid);
$change += $vo['num'] * $price;
/*换货中的商品件数*/
$changenum += $vo['num'];
/*换货中的商品种类数*/
$changecount += 1;
}
}
$this->assign('change', $change);
$this->assign('changecount', $changecount);
$this->assign('changenum', $changenum);
/**
* 本月申请取消订单金额、种类、数量计算
*/
$cdata = M("cancel")->where("status='1'")->select();
foreach ($cdata as $k => $val) {
/*格式时间戳为 20141024*/
$cantime = $val['create_time'];
$s = date('YmdHis', $cantime);
if ($b > $s && $s > $q) {
//当天
/*取消订单的商品总额*/
$cancel += $val['cash'];
/*取消订单的商品件数*/
$cancelnum += $val['num'];
/*取消订单的商品种类数*/
$cancelcount += $val['count'];
}
}
$this->assign('cancel', $cancel);
$this->assign('cancelcount', $cancelcount);
$this->assign('cancelnum', $cancelnum);
/*比率统计*/
$percent_a = $total / ($total + $back + $change + $cancel);
$percent_b = $back / ($total + $back + $change + $cancel);
$percent_c = $change / ($total + $back + $change + $cancel);
$percent_d = $cancel / ($total + $back + $change + $cancel);
$this->assign('a', $percent_a);
$this->assign('b', $percent_b);
$this->assign('c', $percent_c);
$this->assign('d', $percent_d);
/*利润*/
$profits = $total - $back - $change - $cancel;
$this->assign('profits', $profits);
/*保存数据到数据库*/
$turnover = M("turnover");
$data["sales"] = $total;
$data["back"] = $back;
$data["change"] = $change;
$data["cancel"] = $cancel;
$data["profits"] = $profits;
$user = session('user_auth');
$data["uid"] = $user["uid"];
$t = date('Ym', NOW_TIME);
/*格式时间戳为 201410*/
$data["info"] = $t;
$sqtime = $turnover->where("status='3'")->order("id desc")->limit(1)->getField("create_time");
/*格式时间戳为 20141024*/
$r = date('Ym', $sqtime);
/*格式时间戳为 20141024*/
if ($t == $r) {
/*当天已统计过数据，保存，创建时间不变，更新时间变化*/
$data["update_time"] = NOW_TIME;
$turnover->where("create_time='{$sqtime}' and status='3'")->save($data);
} else {
/*未统计过数据，新增*/
$data["status"] = '3';
$data["create_time"] = NOW_TIME;
$data["update_time"] = NOW_TIME;
$turnover->add($data);
}
$this->assign('title', $title);
$this->display();
}
<td><A href="<?php
echo U('Home:Article/detail?id=' . $vo['goodid']);
?>
" > <img src="<?php
echo get_cover(get_cover_id($info["goodid"]), 'path');
?>
" width="40" height="40"/><?php
echo get_good_name($info["goodid"]);
?>
</A></td>
<td align="center"> <span class="weight"><?php
echo get_weight($info["goodid"]);
?>
</span>g</td>
<td align="center"><?php
echo get_good_price($info["goodid"]);
?>
</td>
<td align="center"><?php
echo $info["num"];
?>
</td>
</tr>
</tbody></table> <BR/>
<div style="color:red">
<p style="text-align:right;color:red;width:100%">小计：<?php
echo $info["total"];
?>
元 </p>
<p style="text-align:right;color:red;width:100%">申请时间：<?php
public function change()
{
if (IS_POST) {
$id = I('post.id');
//获取id
$num = I('post.num');
//获取num
$change = D("change");
$change->create();
$change->create_time = NOW_TIME;
$change->total = $num * get_good_price(I('post.goodid'));
$change->status = 1;
$change->add();
//更改商品的售后信息
$data['status'] = -4;
$shop = M("shoplist");
if ($shop->where("id='{$id}'")->save($data)) {
$this->success('申请成功');
} else {
$this->error('申请失败，或重复操作');
}
} else {
$id = I('get.id');
//获取id
$msg = "Tips，提交换货单";
$detail = M("shoplist")->find($id);
//获取购物清单
$this->assign('info', $detail);
$this->assign('msg', $msg);
$this->display();
}
}
/**
* 添加商品 添加商品 未用到
* param int $id 商品主键
* int $num 购物数量
*/
public function addgood($id)
{
$tag = $_POST['tag'];
$num = 1;
$id = $_POST['id'];
$price = get_good_price($id);
if (!isset($_SESSION['cart'])) {
$_SESSION['cart'] = array();
}
$item = array();
//如果该商品已存在则直接加其数量
if (isset($_SESSION['cart'][$id])) {
$_SESSION['cart'][$id]['num'] += $num;
$item['id'] = $id;
$item['price'] = $price;
$item['num'] = $_SESSION['cart'][$id]['num'];
$_SESSION['cart'][$id] = $item;
$exsit = "1";
} else {
$item['id'] = $id;
$item['price'] = $price;
$item['num'] = $num;
$_SESSION['cart'][$id] = $item;
$exsit = "0";
}
$data['status'] = 1;
$data['price'] = get_good_price($id);
$coverid = get_cover_id($id);
$data['src'] = get_good_img($coverid);
$data['title'] = get_good_name($id);
$data['exsit'] = $exsit;
$data['num'] = $item['num'];
$data['msg'] = '添加成功';
$this->ajaxReturn($data);
}
<td><A href="<?php
echo U('Home/Article/detail?id=' . $vo['goodid']);
?>
" > <img src="<?php
echo get_cover(get_cover_id($vo["goodid"]), 'path');
?>
" width="40" height="40"/><?php
echo get_good_name($vo["goodid"]);
?>
</A></td>
<td align="center"> <span class="weight"><?php
echo get_weight($vo["goodid"]);
?>
</span>g</td>
<td align="center"><?php
echo get_good_price($vo["goodid"]);
?>
</td>
<td align="center"><?php
echo $vo["num"];
?>
</td>
</tr><?php
}
}
} else {
echo "";
}
?>
</tbody></table> <BR/>
public function detail()
{
/**
*接收数据并统计
* @return none
*/
$day = I('get.day');
if ($day) {
/***按天数统计 */
$a = date('Ymd', $day);
/*格式时间戳为 20141024*/
$this->meta_title = date('Y年m月d日', $day) . '的数据统计';
$title = date('Y年m月d日', $day) . '的数据统计';
/*销售统计*/
$order = M("order")->where("total!=''")->select();
foreach ($order as $n => $val) {
$time = $val['ptime'];
$b = date('Ymd', $time);
if ($a == $b) {
//当月
/*商品销售额*/
$salesmoney += $val['total'];
/*运费*/
$trans += $val['shipprice'];
/*总销售额*/
$total += $val['pricetotal'];
$id = $val['id'];
$list = M("shoplist")->where("orderid='{$id}'")->select();
foreach ($list as $k => $vo) {
/*退货中的商品id*/
$goodid = $vo['goodid'];
$price = get_good_price($goodid);
/*销售的商品件数*/
$salenum += $vo['num'];
/*销售的商品种类数*/
$salecount += 1;
}
}
}
$this->assign('salecount', $salecount);
$this->assign('salenum', $salenum);
$this->assign('trans', $trans);
$this->assign('salesmoney', $salesmoney);
$this->assign('total', $total);
/**
* 当天退货金额、种类、数量计算
*/
$data = M("backlist")->where("status='1'")->select();
foreach ($data as $k => $val) {
/*格式时间戳为 20141024*/
$time = $val['create_time'];
$d = date('Ymd', $time);
if ($a == $d) {
//当天
/*退货中的商品id*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
/*退货中的商品总额*/
$back += $val['num'] * $price;
/*退货中的商品件数*/
$backnum += $val['num'];
/*退货中的商品种类数*/
$backcount += 1;
}
}
$this->assign('back', $back);
$this->assign('backcount', $backcount);
$this->assign('backnum', $backnum);
/**
* 当天换货金额、种类、数量计算
*/
$data = M("change")->where("status='1'")->select();
foreach ($data as $k => $val) {
$time = $val['create_time'];
$f = date('Ymd', $time);
if ($a == $f) {
//当天
/*换货中的商品总额*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
$change += $val['num'] * $price;
/*换货中的商品件数*/
$changenum += $val['num'];
/*换货中的商品种类数*/
$changecount += 1;
}
}
$this->assign('change', $change);
$this->assign('changecount', $changecount);
$this->assign('changenum', $changenum);
/**
* 当天申请取消订单金额、种类、数量计算
*/
$cdata = M("cancel")->where("status='1'")->select();
foreach ($cdata as $k => $val) {
/*格式时间戳为 20141024*/
$stime = $val['create_time'];
$s = date('Ymd', $stime);
if ($a == $s) {
//当天
/*取消订单的商品总额*/
$cancel += $val['cash'];
/*取消订单的商品件数*/
$cancelnum += $val['num'];
/*取消订单的商品种类数*/
$cancelcount += $val['count'];
}
}
$this->assign('cancel', $cancel);
$this->assign('cancelcount', $cancelcount);
$this->assign('cancelnum', $cancelnum);
/*比率统计*/
$percent_a = $total / ($total + $back + $change + $cancel);
$percent_b = $back / ($total + $back + $change + $cancel);
$percent_c = $change / ($total + $back + $change + $cancel);
$percent_d = $cancel / ($total + $back + $change + $cancel);
$this->assign('a', $percent_a);
$this->assign('b', $percent_b);
$this->assign('c', $percent_c);
$this->assign('d', $percent_d);
/*利润*/
$profits = $total - $back - $change - $cancel;
$this->assign('profits', $profits);
$this->assign('title', $title);
}
//天数统计完毕
$week = I('get.week');
if ($week) {
/***按周数统计 */
$w = date('W', $week);
/*格式时间戳为本年度周数*/
$y = date('Y', $week);
$this->meta_title = $y . "年度第" . date('W', $week) . '周的数据统计';
$title = $y . "年度第" . date('W', $week) . '周的数据统计';
/*销售统计*/
$order = M("order")->where("total!=''")->select();
foreach ($order as $n => $val) {
$time = $val['ptime'];
$b = date('W', $time);
if ($w == $b) {
//
/*商品销售额*/
$salesmoney += $val['total'];
/*运费*/
$trans += $val['shipprice'];
/*总销售额*/
$total += $val['pricetotal'];
$id = $val['id'];
$list = M("shoplist")->where("orderid='{$id}'")->select();
foreach ($list as $k => $vo) {
/*退货中的商品id*/
$goodid = $vo['goodid'];
$price = get_good_price($goodid);
/*销售的商品件数*/
$salenum += $vo['num'];
/*销售的商品种类数*/
$salecount += 1;
}
}
}
$this->assign('salecount', $salecount);
$this->assign('salenum', $salenum);
$this->assign('trans', $trans);
$this->assign('salesmoney', $salesmoney);
$this->assign('total', $total);
/**
* 当周退货金额、种类、数量计算
*/
$data = M("backlist")->where("status='1'")->select();
foreach ($data as $k => $val) {
/*格式时间戳为 20141024*/
$time = $val['create_time'];
$d = date('W', $time);
if ($w == $d) {
//当天周
/*退货中的商品id*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
/*退货中的商品总额*/
$back += $val['num'] * $price;
/*退货中的商品件数*/
$backnum += $val['num'];
/*退货中的商品种类数*/
$backcount += 1;
}
}
$this->assign('back', $back);
$this->assign('backcount', $backcount);
$this->assign('backnum', $backnum);
/**
* 当周换货金额、种类、数量计算
*/
$data = M("change")->where("status='1'")->select();
foreach ($data as $k => $val) {
$time = $val['create_time'];
$f = date('W', $time);
if ($w == $f) {
//同周
/*换货中的商品总额*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
$change += $val['num'] * $price;
/*换货中的商品件数*/
$changenum += $val['num'];
/*换货中的商品种类数*/
$changecount += 1;
}
}
$this->assign('change', $change);
$this->assign('changecount', $changecount);
$this->assign('changenum', $changenum);
/**
* 本周申请取消订单金额、种类、数量计算
*/
$cdata = M("cancel")->where("status='1'")->select();
foreach ($cdata as $k => $val) {
/*格式时间戳为 20141024*/
$setime = $val['create_time'];
$se = date('W', $setime);
if ($w == $se) {
//当天
/*取消订单的商品总额*/
$cancel += $val['cash'];
/*取消订单的商品件数*/
$cancelnum += $val['num'];
/*取消订单的商品种类数*/
$cancelcount += $val['count'];
}
}
$this->assign('cancel', $cancel);
$this->assign('cancelcount', $cancelcount);
$this->assign('cancelnum', $cancelnum);
/*比率统计*/
$percent_a = $total / ($total + $back + $change + $cancel);
$percent_b = $back / ($total + $back + $change + $cancel);
$percent_c = $change / ($total + $back + $change + $cancel);
$percent_d = $cancel / ($total + $back + $change + $cancel);
$this->assign('a', $percent_a);
$this->assign('b', $percent_b);
$this->assign('c', $percent_c);
$this->assign('d', $percent_d);
/*利润*/
$profits = $total - $back - $change - $cancel;
$this->assign('profits', $profits);
$this->assign('title', $title);
}
//周数统计完毕
//月份统计完毕
$month = I('get.month');
if ($month) {
/***按月统计 */
$m = date('Ym', $month);
/*格式时间戳为 201410*/
$this->meta_title = date('Y年m月', $month) . '的数据统计';
$title = date('Y年m月', $month) . '的数据统计';
/*销售统计*/
$order = M("order")->where("total!=''")->select();
foreach ($order as $n => $val) {
$time = $val['ptime'];
$b = date('Ym', $time);
if ($m == $b) {
//
/*商品销售额*/
$salesmoney += $val['total'];
/*运费*/
$trans += $val['shipprice'];
/*总销售额*/
$total += $val['pricetotal'];
$id = $val['id'];
$list = M("shoplist")->where("orderid='{$id}'")->select();
foreach ($list as $k => $vo) {
/*退货中的商品id*/
$goodid = $vo['goodid'];
$price = get_good_price($goodid);
/*销售的商品件数*/
$salenum += $vo['num'];
/*销售的商品种类数*/
$salecount += 1;
}
}
}
$this->assign('salecount', $salecount);
$this->assign('salenum', $salenum);
$this->assign('trans', $trans);
$this->assign('salesmoney', $salesmoney);
$this->assign('total', $total);
/**
* 当月退货金额、种类、数量计算
*/
$data = M("backlist")->where("status='1'")->select();
foreach ($data as $k => $val) {
/*格式时间戳为 20141024*/
$time = $val['create_time'];
$d = date('Ym', $time);
if ($m == $d) {
//当天
/*退货中的商品id*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
/*退货中的商品总额*/
$back += $val['num'] * $price;
/*退货中的商品件数*/
$backnum += $val['num'];
/*退货中的商品种类数*/
$backcount += 1;
}
}
$this->assign('back', $back);
$this->assign('backcount', $backcount);
$this->assign('backnum', $backnum);
/**
* 当月换货金额、种类、数量计算
*/
$data = M("change")->where("status='1'")->select();
foreach ($data as $k => $val) {
$time = $val['create_time'];
$f = date('Ym', $time);
if ($m == $f) {
//同月
/*换货中的商品总额*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
$change += $val['num'] * $price;
/*换货中的商品件数*/
$changenum += $val['num'];
/*换货中的商品种类数*/
$changecount += 1;
}
}
$this->assign('change', $change);
$this->assign('changecount', $changecount);
$this->assign('changenum', $changenum);
/**
* 本周申请取消订单金额、种类、数量计算
*/
$cdata = M("cancel")->where("status='1'")->select();
foreach ($cdata as $k => $val) {
/*格式时间戳为 20141024*/
$sytime = $val['create_time'];
$sy = date('Ym', $sytime);
if ($m == $sy) {
//当天
/*取消订单的商品总额*/
$cancel += $val['cash'];
/*取消订单的商品件数*/
$cancelnum += $val['num'];
/*取消订单的商品种类数*/
$cancelcount += $val['count'];
}
}
$this->assign('cancel', $cancel);
$this->assign('cancelcount', $cancelcount);
$this->assign('cancelnum', $cancelnum);
/*比率统计*/
$percent_a = $total / ($total + $back + $change + $cancel);
$percent_b = $back / ($total + $back + $change + $cancel);
$percent_c = $change / ($total + $back + $change + $cancel);
$percent_d = $cancel / ($total + $back + $change + $cancel);
$this->assign('a', $percent_a);
$this->assign('b', $percent_b);
$this->assign('c', $percent_c);
$this->assign('d', $percent_d);
/*利润*/
$profits = $total - $back - $change - $cancel;
$this->assign('profits', $profits);
$this->assign('title', $title);
}
//周数统计完毕
$this->display();
}
public function addgood($id)
{
$tag = htmlspecialchars($_POST['tag']);
$num = 1;
$id = htmlspecialchars($_POST['id']);
$price = get_good_price($id);
if (!isset($_SESSION['cart'])) {
$_SESSION['cart'] = array();
}
$item = array();
//如果该商品已存在则直接加其数量
if (isset($_SESSION['cart'][$id])) {
$_SESSION['cart'][$id]['num'] += $num;
$item['id'] = $id;
$item['price'] = $price;
$item['num'] = $_SESSION['cart'][$id]['num'];
$_SESSION['cart'][$id] = $item;
$exsit = "1";
} else {
$item['id'] = $id;
$item['price'] = $price;
$item['num'] = $num;
$_SESSION['cart'][$id] = $item;
$exsit = "0";
}
$data['status'] = 1;
$data['price'] = get_good_price($id);
$coverid = get_cover_id($id);
$data['src'] = get_good_img($coverid);
$data['title'] = get_good_name($id);
//登录用户，处理详情页ajaxt提交的数据保存到数据库
if (is_login()) {
$table = D("shopcart");
$data['goodid'] = $id;
$data['num'] = $num;
$member = D("member");
$uid = $member->uid();
$data['uid'] = $uid;
$pnum = M("shopcart")->where("goodid='{$id}'and uid='{$uid}'")->getField("num");
if ($pnum) {
$exsit = "1";
$data['num'] = $pnum + $num;
$table->where("goodid='{$id}'and uid='{$uid}'")->save($data);
} else {
$data['num'] = $num;
$table->add($data);
$exsit = "0";
}
$data['sql'] = 'sql';
$data['num'] = M("shopcart")->where("goodid='{$id}'and uid='{$uid}'")->getField("num");
$data['msg'] = '添加成功';
$data['exsit'] = $exsit;
$this->ajaxReturn($data);
} else {
$data['exsit'] = $exsit;
$data['num'] = $item['num'];
$data['msg'] = '添加成功';
$this->ajaxReturn($data);
}
}
public function detailByMonth($month)
{
$m = date('Ym', $month);
/*格式时间戳为 201410*/
$this->meta_title = date('Y年m月', $month) . '的数据统计';
$title = date('Y年m月', $month) . '的数据统计';
/*销售统计*/
$field = 'id,orderid,tag,pricetotal,create_time,status,ispay,total,shipprice';
$order = M("order")->where("total!=''")->field($field)->select();
$salesmoney = $trans = $total = $salenum = $salecount = 0;
foreach ($order as $n => $val) {
$time = $val['create_time'];
$b = date('Ym', $time);
if ($m == $b) {
//
/*商品销售额*/
$salesmoney += $val['total'];
/*运费*/
$trans += $val['shipprice'];
/*总销售额*/
$total += $val['pricetotal'];
$id = $val['id'];
$field = 'id,goodid,num,orderid,uid,status,create_time,price,total,sort,tag,parameters';
$list = M("shoplist")->field($field)->where("orderid='{$id}'")->select();
foreach ($list as $k => $vo) {
/*退货中的商品id*/
$goodid = $vo['goodid'];
$price = $vo['price'];
/*销售的商品件数*/
$salenum += $vo['num'];
/*销售的商品种类数*/
$salecount += 1;
}
}
}
$this->assign('salecount', $salecount);
$this->assign('salenum', $salenum);
$this->assign('trans', $trans);
$this->assign('salesmoney', $salesmoney);
$this->assign('total', $total);
/**
* 当月退货金额、种类、数量计算
*/
$back = $backnum = $backcount = 0;
$field = 'id,goodid,num,tool,toolid,status,create_time,info,total,shopid';
$data = M("backlist")->field($field)->where("status='1'")->select();
foreach ($data as $k => $val) {
/*格式时间戳为 20141024*/
$time = $val['create_time'];
$d = date('Ym', $time);
if ($m == $d) {
//当天
/*退货中的商品id*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
/*退货中的商品总额*/
$back += $val['num'] * $price;
/*退货中的商品件数*/
$backnum += $val['num'];
/*退货中的商品种类数*/
$backcount += 1;
}
}
$this->assign('back', $back);
$this->assign('backcount', $backcount);
$this->assign('backnum', $backnum);
/**
* 当月换货金额、种类、数量计算
*/
$field = 'id,goodid,num,tool,toolid,uid,status,create_time,info,total,shopid';
$change = $changenum = $changecount = 0;
$data = M("change")->where("status='1'")->field($field)->select();
foreach ($data as $k => $val) {
$time = $val['create_time'];
$f = date('Ym', $time);
if ($m == $f) {
//同月
/*换货中的商品总额*/
$goodid = $val['goodid'];
$price = get_good_price($goodid);
$change += $val['num'] * $price;
/*换货中的商品件数*/
$changenum += $val['num'];
/*换货中的商品种类数*/
$changecount += 1;
}
}
$this->assign('change', $change);
$this->assign('changecount', $changecount);
$this->assign('changenum', $changenum);
/**
* 本周申请取消订单金额、种类、数量计算
*/
$field = 'id,goodid,num,orderid,create_time,shopid,status,cash,count';
$cancel = $cancelnum = $cancelcount = 0;
$cdata = M("cancel")->where("status='1'")->field($field)->select();
foreach ($cdata as $k => $val) {
/*格式时间戳为 20141024*/
$sytime = $val['create_time'];
$sy = date('Ym', $sytime);
if ($m == $sy) {
//当天
/*取消订单的商品总额*/
$cancel += $val['cash'];
/*取消订单的商品件数*/
$cancelnum += $val['num'];
/*取消订单的商品种类数*/
$cancelcount += $val['count'];
}
}
$this->assign('cancel', $cancel);
$this->assign('cancelcount', $cancelcount);
$this->assign('cancelnum', $cancelnum);
/*比率统计*/
$percent_a = $total / ($total + $back + $change + $cancel);
$percent_b = $back / ($total + $back + $change + $cancel);
$percent_c = $change / ($total + $back + $change + $cancel);
$percent_d = $cancel / ($total + $back + $change + $cancel);
$this->assign('a', $percent_a);
$this->assign('b', $percent_b);
$this->assign('c', $percent_c);
$this->assign('d', $percent_d);
/*利润*/
$profits = $total - $back - $change - $cancel;
$this->assign('profits', $profits);
$this->assign('title', $title);
}
