public function OrderCancel() { $admin_id = $_SESSION['id']; //当前登陆的管理员 $order_products = M('order_products'); $products = M('products'); $db = M('orders'); $id = $_POST['id']; //要操作的订单id //1.如果已经支付成功 且没发货 则将钱返还,物品入库,后将订单状态设为已取消0 $row = $db->where("id = {$id}")->find(); if (!empty($row)) { //数据库查询到订单信息 //查询买的商品id和数量 $order_prodects_list = $order_products->where("order_id = {$id}")->select(); if ($row['order_status'] == 0) { //订单是已经 取消状态 echo '订单已经是取消状态!'; } else { if ($row['order_status'] == 5) { //订单是 完成状态 echo '订单已经完成!无法取消'; } else { if ($row['order_status'] == 2) { //查询订单状态是 未发货 状态 if ($row['pay_status'] == 0) { //如果是未付款的订单 //入库 foreach ($order_prodects_list as $or) { //查询订单下所有的商品id和数量 $productsId = $or['product_id']; $productsNum = $or['product_number']; $products->where("id = {$productsId}")->setInc('stock_num', $productsNum); //入库 } $data['order_status'] = 0; $db->where("id = {$id}")->save($data); //订单状态设为取消状态 } else { if ($row['pay_status'] == 1) { //如果是支付的订单 $pay = $row['deail_price']; //获得所消费的金额 //返还的方法 debug 未实现 //入库 foreach ($order_prodects_list as $or) { //查询订单下所有的商品id和数量 $productsId = $or['product_id']; $productsNum = $or['product_number']; $result = $products->where("id = {$productsId}")->setInc('stock_num', $productsNum); //入库 } if ($result > 0) { $data['order_status'] = 0; $closeStatus = $db->where("id = {$id}")->save($data); //订单状态设为取消状态 if ($closeStatus > 0) { echo '订单取消成功!'; // 写入日志 $log = new \Admin\Controller\LogController(); $log->setLog('用户(UID:' . $admin_id . ')取消了id为' . $_POST['id'] . '的订单增'); } else { echo '订单取消失败!'; } } else { echo '订单取消失败!'; } } else { echo '订单取消失败!'; } } } else { if ($row['order_status'] == 1) { //未支付 //入库 foreach ($order_prodects_list as $or) { //查询订单下所有的商品id和数量 $productsId = $or['product_id']; $productsNum = $or['product_number']; $result = $products->where("id = {$productsId}")->setInc('stock_num', $productsNum); //入库 } if ($result > 0) { $data['order_status'] = 0; $closeStatus = $db->where("id = {$id}")->save($data); //订单状态设为取消状态 if ($closeStatus > 0) { echo '订单取消成功!'; // 写入日志 $log = new \Admin\Controller\LogController(); $log->setLog('用户(UID:' . $admin_id . ')取消了id为' . $_POST['id'] . '的订单增'); } else { echo '订单取消失败!'; } } else { echo '订单取消失败!'; } } else { if ($row['order_status'] == 3) { //已发货 echo '订单已发货,无法取消!'; } } } } } } }
/** * 单个删除模块 */ public function moduleDelete() { $id = I('get.id', 0); $Model = M('modules'); // 判断自己不能删除自己 $res1 = $Model->delete($id); if ($res1) { $objLog = new \Admin\Controller\LogController(); $objLog->setLog('权限模块(MODULE_ID:' . I('get.id') . ')删除成功'); $this->success('删除成功!'); } else { $this->error('删除失败!'); } }
public function doEditservicepolicy() { $id = I('post.id'); $db = M("policy"); if ($db->create()) { $rt = $db->save(); if ($rt) { $cLog = new \Admin\Controller\LogController(); $cLog->setLog('单页(法律声明)修改成功'); $this->success("修改成功", U("servicepolicy")); exit; } else { $this->error("修改失败", 'servicepolicy'); } } else { $this->error("修改失败", 'servicepolicy'); } }
/** * 更新角色授权 */ public function accessSelectHandle() { $arr = I('post.rule'); $where['id'] = I("post.groupID"); if ($arr == NULL) { $data['rules'] = ''; } else { $data['rules'] = implode(',', $arr); } $m = M('auth_group'); //更新,返回影响行数 $num = $m->where($where)->save($data); if ($num) { $setLog = new \Admin\Controller\LogController(); $setLog->setLog('角色权限(ROLE_ID: ' . I("post.groupID") . ')修改成功!'); $this->success('角色权限修改成功.' . I("post.groupID"), 'index'); exit; } $this->error('权限更新失败!', 'index'); }
/** * delSeo 删除Seo * @return void */ public function delSeo() { $id = $_GET['id']; $db = M("seo"); $ls = $db->where("id =" . $id)->delete(); if ($ls) { $cLog = new \Admin\Controller\LogController(); $cLog->setLog('SEO(SEO_ID:' . $id . ')删除成功'); $this->success($id . 'SEO删除成功'); exit; } else { $this->error('SEO删除失败'); } }
/** * 执行商品促销添加 */ public function doPromoteAdd() { $post = I('post.'); // dump($post); // die; $ModelPro = M('promote'); $ModelMem = M('members_rate'); $ModelPro->where(array('product_id' => $post['product_id']))->delete(); $ModelMem->where(array('product_id' => $post['product_id']))->delete(); $status = $post['status']; if ($status == 1) { $data['status'] = $status; $data['promote_num'] = $post['promotenum1']; $data['product_id'] = $post['product_id']; $data['rate'] = $post['rate1']; $res = $ModelPro->add($data); } elseif ($status == 2) { $data['status'] = $status; $data['product_id'] = $post['product_id']; foreach ($post['memberrate'] as $k => $v) { // 如果价格为空就跳过 if (trim($v) == '') { continue; } $data1['rate'] = $v; $data1['level_id'] = $k + 1; $data1['product_id'] = $data['product_id']; // 插入数据库 // dump($data1); // die; $ModelMem->add($data1); } $res = $ModelPro->add($data); } elseif ($status == 3) { $data['status'] = $status; $data['promote_num'] = $post['promotenum3']; $data['product_id'] = $post['product_id']; if (!$post['gifts']) { $this->error('商品赠品不能为空,添加失败!'); exit; } else { $data['gifts'] = implode(',', $post['gifts']); } $res = $ModelPro->add($data); } elseif ($status == 4) { $data['status'] = $status; $data['promote_num'] = $post['promotenum3']; $data['condition'] = $post['condition']; $data['product_id'] = $post['product_id']; $data['gifts'] = implode(',', $post['gifts']); $res = $ModelPro->add($data); } elseif ($status == 5) { $data['product_id'] = $post['product_id']; $data['status'] = $status; $data['promote_num'] = $post['promotenum4']; $data['rate'] = $post['rate2']; if ($post['start_time']) { $data['start_time'] = strtotime($post['start_time']); } else { $data['start_time'] = time(); } if (!$post['end_time']) { $this->error('截止时间不能为空,添加失败!'); exit; } else { $data['end_time'] = strtotime($post['end_time']); } $res = $ModelPro->add($data); } elseif ($status == 6) { $data['product_id'] = $post['product_id']; $data['status'] = $status; $data['rate'] = $post['rate']; if (!$post['comb']) { $this->error('套餐商品不能为空,添加失败!'); exit; } else { $data['combs'] = implode(',', $post['comb']); } $res = $ModelPro->add($data); } if ($res) { // 写入日志 $cLog = new \Admin\Controller\LogController(); $cLog->setLog('商品(PRO_ID:' . $data['product_id'] . ')促销更新成功'); $this->success('商品促销添加成功', 'productList'); exit; } else { $this->error('商品促销添加失败'); } }
/** * 单个删除用户 */ public function userDelete($id) { $userId = I('get.id', 0); $modelUsers = M('admin_users'); $modelInfo = M('admin_info'); $modelUserAccess = M('auth_group_access'); // 判断自己不能删除自己 $myId = I('session.id'); if ($myId == $userId) { $this->error('自己不能删除自己'); exit; } $res1 = $modelUsers->delete($userId); $res2 = $modelInfo->where("uid='{$userId}'")->delete(); $res3 = $modelUserAccess->where("uid='{$userId}'")->delete(); if ($res1 && $res2 && $res3) { $objLog = new \Admin\Controller\LogController(); $objLog->setLog('管理员用户(UID:' . I('get.id') . ')帐户删除成功'); $this->success('删除成功!'); } else { $this->error('删除失败!'); } }
/** * 执行博文修改 */ public function doEditBlog() { $getId = I('post.id'); $post = I('post.'); $post['title'] = trim($post['title']); if (empty($post['title'])) { $this->error('博文更改无效'); exit; } $post['create_time'] = time(); $modelBlog = M('blog'); $updateBlog = 0; if ($modelBlog->create($post)) { $updateBlog = $modelBlog->where(array('id' => $getId))->save(); } $data = array(); if ($post['imgs']) { $mAffectedRows = 0; foreach ($post['imgs'] as $k => $v) { $data[$k]['blog_id'] = $getId; $data[$k]['images'] = $v; } $modelImg = M('blog_album'); $modelImg->where(array('blog_id' => $getId))->delete(); $mAffectedRows = $modelImg->addAll($data); } else { $mAffectedRows = 1; } if ($post['video']) { $modelImg = M('blog_album'); $data['blog_id'] = $getId; $data['video'] = $post['video']; $mAffectedRows2 = $modelImg->where(array('blog_id' => $data['blog_id']))->save($data); } if ($mAffectedRows || $updateGoods || $mAffectedRows2) { // 写入日志 $cLog = new \Admin\Controller\LogController(); $cLog->setLog('首页博文(ID:' . $getId . ')修改成功'); $this->success('首页博文修改成功', 'blogList'); exit; } else { $this->error('博文修改失败'); } }