批量更新tp_users表中用户实名信息

批量更新tp_users表中用户实名信息

Administrator 44 2024-05-10

批量将tp_users表中，包含account字段的数据，设置为对应的值

提示语：以SQL语句格式显示

认证实名

UPDATE tp_users
SET
img_z = '#',
img_f = '#',
img_face = '#',
true_name = '刘',
card = '#'
WHERE account IN (
'H3956', 'E395677');

更改充值金额

UPDATE tp_users
SET
user_money = '12709.5'
WHERE account IN (
'h1131', 'h1134', 'h1137', 'j1131', 'j1134', 'j1137', 'k1131'
);

更改实际金额

 UPDATE tp_order
SET
sj_price = '13400'
WHERE order_sn IN ('order_sn1', 'order_sn2', 'order_sn3', ...);

更改至尊代理

UPDATE tp_users
SET agent_level_v1 = '3',
    agent_level = '3',
    agent_name = '3'
WHERE account IN (
    'h1121', 'h1122', 'h1123', 'h1124', 'h1125', 'h1126',
    'j1121', 'j1122', 'j1123', 'j1124', 'j1125', 'j1126',
    'k1121', 'k1122', 'k1123', 'k1124', 'k1125', 'k1126', 'k1127', 'k1128',
    'h1132', 'h1133', 'h1135', 'h1136',
    'j1132', 'j1133', 'j1135', 'j1136',
    'k1132', 'k1133', 'k1134', 'k1135', 'k1136'
);

更改IP地址

UPDATE tp_users
SET province_name = '江苏常州'
WHERE account IN (
'h1121', 'h1122', 'h1123', 'h1124', 'h1125', 'h1126', 'j1121', 'j1122', 'j1123', 'j1124', 'j1125', 'j1126', 'k1121', 'k1122', 'k1123', 'k1124', 'k1125', 'k1126', 'k1127', 'k1128', 'h1131', 'h1132', 'h1133', 'h1134', 'h1135', 'h1136', 'h1137', 'j1131', 'j1132', 'j1133', 'j1134', 'j1135', 'j1136', 'j1137', 'k1131', 'k1132', 'k1133', 'k1134', 'k1135', 'k1136', 'k1137'
);
UPDATE tp_order
SET province_name = '江苏常州'
WHERE order_sn IN (
    '202405281813228823',
    '202405281812271758',
    '202405281318352986'
);

批量所在地区

UPDATE tp_users

SET province_name_v1 = '江苏常州'

WHERE account IN (

'h1121', 'h1122', 'h1123', 'h1124', 'h1125', 'h1126', 'j1121', 'j1122', 'j1123', 'j1124', 'j1125', 'j1126', 'k1121', 'k1122', 'k1123', 'k1124', 'k1125', 'k1126', 'k1127', 'k1128', 'h1131', 'h1132', 'h1133', 'h1134', 'h1135', 'h1136', 'h1137', 'j1131', 'j1132', 'j1133', 'j1134', 'j1135', 'j1136', 'j1137', 'k1131', 'k1132', 'k1133', 'k1134', 'k1135', 'k1136', 'k1137'

);

批量更新会员列表是否至尊按钮

UPDATE tp_users
SET is_partner = '1'
WHERE account IN ('k1132', 'k1133', 'k1134', 'k1135', 'k1136'
);

批量服务中心1是2否

UPDATE tp_users
SET is_fwzx = '1'
WHERE account IN (
    'YB001', 'YA001', 'YA002', 'YA003', 'YC001', 'YE001', 'YE002', 'YE003', 'YD001', 'YD002', 'YH001', 'YH002', 'YH003', 'YF001', 'YF002', 'c13861018950'
);

用户IP接口：

解析地址：https://ipaddquery.api.bdymkt.com

替换下面的AppCode

https://apis.baidu.com/store/detail/e8ee92a9-107d-489c-9918-75301736e2c4

/application/home/controller/index.php

118行

        array_push($headers, "X-Bce-Signature:AppCode/" . "c33ca85c3f6e4a1a9a43c3e8e4d16738");

启用溯源记录

                        <h4>溯源记录</h4>
                        <table>
                            <thead>
                            <tr>
                                <th>姓名</th>
                                <th>账号</th>
                                <th>级别</th>
                                <!--<th>级别比例</th>-->
                                <!--<th>获得比例</th>-->
                                <!--<th>积分</th>-->
                                <!--<th>订单业绩</th>-->
                                <!--<th>支付时间</th>-->
                                <th>状态</th>

                // 验证成功提交表单
                if (data.status == 1) {
                    var html = '';
                    for (var i = 0; i < data.data.length; i++) {
                        html += '<tr><td class="text-center">' + data.data[i].true_name + '</td>' +
                            '<td class="text-center">' + data.data[i].account + '</td>' +
                            '<td class="text-center">' + data.data[i].level_name + '</td>' +
                            // '<td class="text-center">' + data.data[i].level_rate + '</td>' +
                            // '<td class="text-center">' + data.data[i].jc_level_rate + '</td>' +
                            // '<td class="text-center">' + data.data[i].box + '</td>' +
                            // '<td class="text-center">' + data.data[i].order_box + '</td>' +
                            // '<td class="text-center">' + data.data[i].create_time + '</td>'+
                            '<td class="text-center">' + data.data[i].status_name + '</td>'

                    }

导出积分字段box，若要展示积分box-1改回box