当前路径：manage/tongxunlu.php
<?php
include("../db.php");
include("../checklogin.php");
if(!islogin()){
header('location:../index.php');
}
switch ($_GET['action']) {
case 'list':
$pindex = max(1, intval($_GET['page']));
$psize = $_GET['limit'];
$sgongsi=$_GET['sgongsi'];
$suserxm=$_GET['suserxm'];
$sfenji=$_GET['sfenji'];
$sxb=$_GET['sxb'];
$szhiwuid=$_GET['szhiwuid'];
$scard=$_GET['scard'];
$stel=$_GET['stel'];
$sql="SELECT * FROM ".$db->tablename('vtongxunlu') ." WHERE id>0";
if($sgongsi!=''){
$sql=$sql." and gongsi = '$sgongsi'";
}
if($suserxm!=''){
$sql=$sql." and (userxm like '%$suserxm%' or zhiwu like '%$suserxm%')";
}
if($sxb!=''){
$sql=$sql." and xb = '$sxb'";
}
if($sfenji!=''){
$sql=$sql." and fenji = '$sfenji'";
}
if($scard!=''){
$sql=$sql." and card like '%$scard%'";
}
if($stel!=''){
$sql=$sql." and tel like '%$stel%'";
}
$sql=$sql." ORDER BY id asc LIMIT ".($pindex - 1) * $psize.','.$psize;
$list =$db->fetchall($sql);
$total =count($list);
$arr = [
'msg' => '请求成功'.$sql,
'code' => 0,
'data' => $list,
'count' => $total
];
exit(json_encode($arr));
break;
case 'addsave':
$gongsi=$_POST['gongsi'];
$userxm=$_POST['userxm'];
$zhiwu=$_POST['zhiwu'];
$fenji=$_POST['fenji'];
$lianxiid=$_POST['lianxiid'];
$tel=$_POST['tel'];
$guhua=$_POST['guhua'];
$fax=$_POST['fax'];
$qq=$_POST['qq'];
$email=$_POST['email'];
$beizhu=$_POST['beizhu'];
/*$val=$db->exists('tongxunlu',['zhiwu'=>$zhiwu,'card'=>$card]);
if($val){
$arr= ['isOk'=>0,'message'=>'员工编号或身份证号和原有的一致'];
exit(json_encode($arr));
}*/
$data=compact('gongsi','userxm','zhiwu','fenji','lianxiid','tel','guhua','fax','qq','email','beizhu');
$db->insert('tongxunlu',$data);//查询获取数组
$arr=['isOk'=>1,'message'=>'添加成功'];
exit(json_encode($arr));
break;
case 'editsave':
$id=$_POST['id'];
$gongsi=$_POST['gongsi'];
$userxm=$_POST['userxm'];
$zhiwu=$_POST['zhiwu'];
$fenji=$_POST['fenji'];
$lianxiid=$_POST['lianxiid'];
$tel=$_POST['tel'];
$guhua=$_POST['guhua'];
$fax=$_POST['fax'];
$qq=$_POST['qq'];
$email=$_POST['email'];
$beizhu=$_POST['beizhu'];
$data=compact('gongsi','userxm','zhiwu','fenji','lianxiid','tel','guhua','fax','qq','email','beizhu');
$db->update('tongxunlu',$data,['id'=>$id]);//查询获取数组
$arr= ['isOk'=>1,'message'=>'修改成功'];
exit(json_encode($arr));
break;
case 'delall':
$id = $_POST['ids'];
$ids=explode(',',$id);//拆分为数组
if($id==''){
$arr=['isOk'=>0,'message'=>'删除记录不能为空'];
exit(json_encode($arr));
}
// $data = compact('id');//构造数组等同array("id"=>2)
$db->delete('tongxunlu',['Id'=>$ids]);
$arr= ['isOk'=>1,'message'=>'删除成功'];
exit(json_encode($arr));
break;
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Layui</title>
<meta name="renderer" content="webkit">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<link href="../static/layui/css/layui.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="layui-form" style="padding: 10px 0 0 10px" lay-filter="pwh">
<div class="layui-form-item">
<div class="layui-inline">
<label class="layui-form-la...
完整源码文件，请先购买后再查看
相关源码
- 通用后台管理系统2023-09-25
- ASPNET公交查询系统2023-09-21
- ASPＮET MVC婚纱宣传官网2023-09-21
- DSKMS在线培训开源视频管理系统 V3.1.22023-09-16
- 基于SPRINGBOOT医院管理系统2023-09-12
- ASP.NET的社区志愿服务平台2023-09-11
关于我们 | 顾问团队 | 发展历程 | 联系我们 | 源码上传
联系电话(Tel)：4008-010-151(免长途)
地址：北京市海淀区大恒科技大厦五层 邮编：100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2023. 京ICP备09089570号 | 京公网安备11010702000869号
联系电话(Tel)：4008-010-151(免长途)
地址：北京市海淀区大恒科技大厦五层 邮编：100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2023. 京ICP备09089570号 | 京公网安备11010702000869号