后台一些修改方法记录

将cms后台root用户的密码重置未root123..

mysql -uroot -proot;
use biglove;update admin set password='203aeace9b9ed0b1a79ae1641d556b29' where id=1;

测试或pre环境退款 #id的值是订单号对应的id值

MariaDB [dajx-api]>use dajx-api; select * from  `order` where id ='634';
MariaDB [dajx-api]> update `order` set `status_money`=2 where id=634;
MariaDB [dajx-api]> update `order` set status_staff=0 where id='634';

测试环境统一数据库账号密码

mysql -uroot -proot;
grant all privileges on *.* to root@'%' identified by 'root';

佣金记录清理

黄东芳 15082580009
何达芳 13348870322
张曼   15108205872
罗江英 15708476800
郭玉琼 18384713319
杨碧英 15282353036
邓雪桂 18215681486
谢兴明 17723446021

UPDATE `dajx-api`.staff SET balance=0 WHERE tel IN(15082580009 ,13348870322 ,15108205872,15708476800 ,18384713319,15282353036 ,18215681486 ,17723446021  );
delete from `dajx-api`.staff_wallet_logs where staff_id in (select id FROM `dajx-api`.staff  WHERE tel IN(15082580009 ,13348870322 ,15108205872,15708476800 ,18384713319,15282353036 ,18215681486 ,17723446021  ));
delete from `dajx-api`.staff_reward where staff_id in (select id FROM `dajx-api`.staff  WHERE tel IN(15082580009 ,13348870322 ,15108205872,15708476800 ,18384713319,15282353036 ,18215681486 ,17723446021  ));