当前路径：manage/yinzhang_self.php
<?php
include("../db.php");
include("../checklogin.php");
if(!islogin()){
header('location:../index.php');
}
$mid=$_COOKIE['id'];
switch ($_GET['action']) {
case 'list':
$pindex = max(1, intval($_GET['page']));
$psize = $_GET['limit'];
$danwei=$_GET['danwei'];
$jingban=$_GET['jingban'];
$leixing=$_GET['leixing'];
$sbianhao=$_GET['sbianhao'];
$sql="SELECT * FROM ".$db->tablename('vyinzhang') ." WHERE jingbanid='$mid'";//当前登录用户申请的单子
if($danwei!=''){
$sql=$sql." and danwei LIKE '%$danwei%'";
}
if($jingban!=''){
$sql=$sql." and jingban LIKE '%$jingban%'";
}
if($leixing!=''){
$sql=$sql." and leixing LIKE '%$leixing%'";
}
if($sbianhao!=''){
$sql=$sql." and sbianhao LIKE '%$sbianhao%'";
}
$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':
$danweiid=$_POST['danweiid'];
$jingshouid=$_POST['jingshouid'];
$shijian=$_POST['shijian'];
$shiyou=$_POST['shiyou'];
$leixingid=$_POST['leixingid'];
$fenshu=$_POST['fenshu'];
$shiyongdate=$_POST['shiyongdate'];
$shenpiid=$_POST['shenpiid'];
$jingbanid=$_POST['jingbanid'];
$bianhao=$_POST['bianhao'];
$beizhu=$_POST['beizhu'];
$data=compact('danweiid','jingshouid','shijian','shiyou','leixingid','fenshu','shiyongdate','jingbanid','beizhu');
$db->insert('yinzhang',$data);//查询获取数组
$arr=['isOk'=>1,'message'=>'添加成功'];
exit(json_encode($arr));
break;
case 'editsave':
$id=$_POST['id'];
$danweiid=$_POST['danweiid'];
$jingshouid=$_POST['jingshouid'];
$shijian=$_POST['shijian'];
$shiyou=$_POST['shiyou'];
$leixingid=$_POST['leixingid'];
$fenshu=$_POST['fenshu'];
$shiyongdate=$_POST['shiyongdate'];
$shenpiid=$_POST['shenpiid'];
$jingbanid=$_POST['jingbanid'];
$bianhao=$_POST['bianhao'];
$beizhu=$_POST['beizhu'];
$data=compact('danweiid','jingshouid','shijian','shiyou','leixingid','fenshu','shiyongdate','jingbanid','beizhu');
$db->update('yinzhang',$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('yinzhang',['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="styleshee...
完整源码文件，请先购买后再查看
相关源码
- JAVA+SPRINGBOOT心灵心理健康平台(心灵治愈交流平台)(含论文)源码2023-09-27
- JAVA+SPRINGBOOT+VUE工厂车间管理系统(含论文)源码2023-09-27
- JAVA_SSM+VUE校园二手物品交易平台(含论文)源码2023-09-27
- JAVA+SSM医院住院管理系统(含论文)源码2023-09-27
- JAVA VUE SSM教材管理系统(含论文、PPT)课程设计2023-09-27
- 基于SPRINGBOOT 旅游共享平台 + 论文2023-09-26
关于我们 | 顾问团队 | 发展历程 | 联系我们 | 源码上传
联系电话(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号