1 //批量修改email重复
2 public function getEmail()
3 {
4 $this->model = app::get('shop')->model('manage');
5 //总条数
6 $count = count($this->model->getList('id', [ 'status' => 1, 'type' => 0]));
7
8 $limit = 0;
9 $num = $count / 5;//循环多少次
10 for ($i = 1; $i <= $num; $i++) {
11 $sql = "select * from shop_manage where type = 0 AND status = 1 order by id limit {$limit},5";
12 $list = app::get('base')->database()->fetchAll($sql);
13
14 foreach ($list as $k => $v) {16 $email = $v['email'];
17
18 $user_id = $v['user_id'];
19
20
21 $email = $user_id . '_cfq_' . $email;
22
23 $result=$this->model->update(['email'=>$email],['user_id'=>$user_id]);
24
25 }
26
27
28
29 $limit += 5;
30 }
31 $message = "处理成功!";
32 return $this->splash('success', null, $message);
33
34 }
