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); } }