better-staridc-MNBT
1<?php
2if($egn=='logsc') {
3 $id=$_POST['id'];
4 if($DB->query_prepare("DELETE FROM MN_log WHERE id=? limit 1", [$id]))json_exit('删除成功'); else json_exit('删除失败'.$DB->error());
5 return;
6}
7if($egn=='logscxz') {
8 $idsz=$_POST['idsz'];
9 preg_match_all("/[,]{1}/",$idsz,$arrNum);
10 $szgs=count($arrNum[0]);
11 $str_arr = explode(',',$idsz);
12 $er=0;
13 $scqke=0;
14 $scqkr=0;
15 for ($er=0;$er<$szgs;$er++) {
16 $id = $str_arr[$er];
17 if($DB->query_prepare("DELETE FROM MN_log WHERE id=? limit 1", [$id])) $scqke++; else $scqkr++;
18 }
19 json_exit($scqke, ['codr' => $scqkr]);
20 return;
21}
22if($egn=='listlog') {
23 $sorting=strtoupper(($_POST['sortOrder']??''))==='DESC'?'DESC':'ASC';
24 $paixu=preg_replace('/[^a-zA-Z0-9_]/','',$_POST['sort']??'id')?:'id';
25 $pagesize=intval($_POST['limit']);
26 $pageu=(intval($_POST['page'])-1) * $pagesize;
27 $where=json_decode($_POST['where'],true);
28 $pswhere='';
29 $param_arr=[];
30 if($where && $where['name']!=false && $where['type']!=false && $where['value']!=false){
31 if($where['type']!='1' && $where['type']!='2')exit(json_encode(['code'=>4,'msg'=>'搜索方式错误！']));
32 $zdm=['czuser','lx','lr','qk'];
33 if(!in_array($where['name'],$zdm))exit(json_encode(['code'=>4,'msg'=>'不存在的搜索字段！']));
34 $val=$where['value'];
35 $pswhere='and '.$where['name'].($where['type']=='1'?"=?":" LIKE ?");
36 $param_arr[]=$where['type']=='1'?$val:'%'.$val.'%';
37 }
38 $countdata=$DB->count_prepare("SELECT count(*) from MN_log WHERE 1 {$pswhere}", $param_arr);
39 $data=["total"=>$countdata];
40 $data["rows"]=$DB->get_all_prepare("SELECT * FROM MN_log WHERE 1 {$pswhere} order by $paixu $sorting limit $pageu,$pagesize", $param_arr);
41 exit(json_encode($data));
42 return;
43}
44if($egn=='logclear') {
45 if($DB->query_prepare("DELETE FROM MN_log"))json_exit('清空成功'); else json_exit('清空失败');
46 return;
47}
48return;