mashangyoujiu/Application/Retail/Controller/DeleteDataController.class.php

<?php

namespace Retail\Controller;

use Think\Controller;

//[1.3.9]
class DeleteDataController extends BaseController
{
    //首页展示
    public function index()
    {
        $this->display();
    }

    public function deleteSellData()
    {
        $user = session('ls_userinfo');
        $merchantid = $user['merchantid'];
        $password = I('post.password');
        $vipData = I('post.vip');
        $xcxData = I('post.xcx');
        $storeData = I('post.store');
        $goodsData = I('post.goods');
        $res['post'] = $_POST;
        $res['user'] = $user;
        if (empty($merchantid) || empty($password) || (empty($vipData) && empty($xcxData) && empty($storeData) && empty($goodsData))) {
            $res['status'] = 0;
            $res['msg'] = '请选择删除的数据';
            $this->ajaxReturn($res);
        }
        if ($password != $_SESSION['identifying_codes']) {
            $res['status'] = 0;
            $res['msg'] = '验证码不正确';
            $this->ajaxReturn($res);
            exit;
        }
        /*  $CryptrModel = new \Addons\Api\Crypto ();
          $orignPwd = $CryptrModel->encrypt($password, date('YmdHis', $user['addtime']));
          if ($orignPwd != $user['password']) {
              $res['status'] = 0;
              $res['msg'] = '密码不正确';
              $this->ajaxReturn($res);
          }*/
        $map['merchantid'] = $merchantid;
        $map_1['merchant_id'] = $merchantid;
        if (!empty($vipData)) {
            $vipList = M('retail_vip')->where($map)->getField('id', true);
            if (!empty($vipList)) {
                M('retail_vip')->where($map)->delete();                         //删除会员
                M('recharge_order')->where($map)->delete();                     //删除会员充值记录
                M('retail_viprecharge')->where($map)->delete();                 //会员充值记录
                M('vip_recharge')->where($map)->save(array('num' => 0));          //会员充值档次充值次数
                M('retail_xcxvip')->where($map_1)->save(array('vid', ''));     //删除小程序绑定的会员
                $vipMap['vid'] = array('in', $vipList);
                M('retail_integral_order')->where($vipMap)->delete();           //删除会员积分记录
                M('vip_signin')->where($vipMap)->delete();                      //删除会员签到记录
                M('reward_record')->where($map)->delete();                      //删除会员红包记录
                M('turntable_use')->where($map)->delete();                      //删除会员大转盘记录
                M('retail_score_mall_exchange')->where($map)->delete();         //删除会员积分商城兑换记录
                M('gift_card_record')->where(array('recharge_vid' => array('in', $vipList)))->delete();//删除礼品卡领取记录
                $billIds = M('retail_bill_order')->where(array('vid' => array('in', $vipList)))->getField('id', true);
                $billIds = implode(',', $billIds);
                M('retail_bill_order')->where(array('vid' => array('in', $vipList)))->delete();//删除bill表记录
                M('retail_sell')->where(array('bill_id' => array('in', $billIds)))->delete();                     //删除sell表记录
                M('retail_pay_order')->where($vipMap)->delete();                //删除pay_order表记录
                M('retail_vipmcoupon')->where($vipMap)->delete();               //删除优惠券领取记录
                M('retail_membereditcord')->where(array('vip_id' => array('in', $vipList)))->delete();//删除变更记录
            }
        }
        if (!empty($xcxData)) {
            $xcxUser = M('retail_xcxvip')->where($map_1)->getField('id', true);
            if (!empty($xcxUser)) {
                M('retail_xcxvip')->where($map_1)->delete();                      //删除小程序用户
                $xcxMap['uid'] = array('in', $xcxUser);
                M('retail_address')->where($xcxMap)->delete();                  //删除小程序用户收货地址
                M('retail_bill_order')->where($xcxMap)->delete();                     //删除bill表记录
                M('retail_sell')->where($xcxMap)->delete();                     //删除sell表记录
                M('retail_collect')->where($xcxMap)->delete();                  //删除收藏
                M('retail_coupon_logs')->where($xcxMap)->delete();              //删除小程序优惠券
                M('retail_evalute')->where($xcxMap)->delete();                  //删除评价记录
                M('retail_shopping')->where($xcxMap)->delete();                 //删除购物车记录
                M('gift_card_record')->where($map)->delete();                   //删除礼品卡充值记录
            }
        }
        if (!empty($storeData)) {
            if (in_array('store', $storeData)) {
                $map_1['type'] = 2;                                               //店内
                M('retail_bill_order')->where($map_1)->delete();
            }
            if (in_array('online', $storeData)) {
                $map_1['type'] = 1;                                               //商城
                M('retail_bill_order')->where($map_1)->delete();
            }
            unset($map_1['type']);
//            if (in_array('group', $storeData)) {
//                M('retail_group_order')->where($map)->delete();                 //删除拼团订单记录
//            }
//            if (in_array('secKill', $storeData)) {
//                M('retail_seckill_order')->where($map)->delete();               //删除秒杀订单记录
//            }
            if (in_array('sell', $storeData)) {
                M('retail_sell')->where($map_1)->delete();                        //删除销售明细
            }
            if (in_array('stock', $storeData)) {
                M('retail_store_stock_out_goods')->where($map_1)->delete();               //删除出入库明细
                M('retail_store_stock_out_order')->where($map_1)->delete();               //删除出入库明细
                M('retail_store_warehousing_record')->where($map_1)->delete();               //删除出入库明细
                M('retail_store_warehouse_goods')->where($map_1)->delete();               //删除出入库明细
                M('retail_quantity_logs')->where($map)->delete();               //删除出入库明细
            }
            if (in_array('order_da', $storeData)) {
                M('retail_da_order')->where($map_1)->delete();                   //删除达达订单
            }
            if (in_array('order_uu', $storeData)) {
                M('retail_uu_order')->where($map)->delete();                  //删除UU订单
            }
        }
        if (!empty($goodsData)) {
            if (in_array('merchant', $goodsData)) {
                M('retail_mgoods')->where($map)->delete();
                M('retail_sku_mgoods')->where($map)->delete();
                M('retail_sale_goods')->where(array('merchant_id' => $merchantid))->delete();
            }
            if (in_array('store', $goodsData)) {
                M('retail_goods')->where($map_1)->delete();
                M('retail_host')->where($map)->delete();
                M('retail_sku_goods')->where($map_1)->delete();
                M('retail_store_sale_goods')->where(array('merchant_id' => $merchantid))->delete();
                M('retail_seckill_order')->where($map)->delete();               //删除秒杀订单记录
                M('retail_group_order')->where($map)->delete();                 //删除拼团订单记录
                M('retail_quantity_logs')->where($map)->delete();               //删除销售明细
                M('retail_sell')->where($map_1)->delete();                        //删除销售明细
            }
        }
        $res['status'] = 1;
        $res['msg'] = '清除成功';
        $this->ajaxReturn($res);
    }

    //验证码
    public function verification()
    {
        session('identifying_codes', null);
        $user = session('ls_userinfo');
        $merchantid = $user['merchantid'];
        $phone = $user['mobile'];
        $alidayu = A('Api/Alidayu');
        $sendshortinfo = M('retail_smsset')->where(array('merchantid' => $merchantid))->find();
        $result = $alidayu->Send($phone, $merchantid);
        if ($result['Message'] == 'OK') {
            $data['status'] = 1;
            $data['msg'] = "验证码发送成功";
        } else {
            $data['status'] = 0;
            $data['msg'] = $result['Message'] ? $result['Message'] : "验证码发送次数上限";
        }
        $this->ajaxReturn($data);
    }
}