点击回首页
我的浏览记录 | | 帮助?
当前位置:
首页>> 企业应用>> 新翔网络OA系统V1.0>> 源文件浏览
[商业版 200RMB] WebForm,下载次数:1 次 | 关键字: PHP MYSQL OA 办公 网络办公

源码截图

源码目录树

;
当前路径:manage/renwu_faqi.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'];
	$slaiyuanid=$_GET['slaiyuanid'];
	$sfasongid=$_GET['sfasongid'];
	$sjieshouid=$_GET['sjieshouid'];
	$sfenleiid=$_GET['sfenleiid'];
	$schengduid=$_GET['schengduid'];
	$szerenid=$_GET['szerenid'];
	$szhuangtai=$_GET['szhuangtai'];
	$sqixian1=$_GET['sqixian1'];
	$sqixian2=$_GET['sqixian2'];
	$sql="SELECT *  FROM ".$db->tablename('vrenwu') ." WHERE id>0";
	if($slaiyuanid!=''){
	$sql=$sql." and laiyuanid = '$slaiyuanid'";
	}
	if($sfasongid!=''){
	$sql=$sql." and fasongid = '$sfasongid'";
	}
	if($sjieshouid!=''){
	$sql=$sql." and jieshou like '%$sjieshouid%'";
	}
	if($sfenleiid!=''){
	$sql=$sql." and fenleiid = '$sfenleiid'";
	}
	if($schengduid!=''){
	$sql=$sql." and chengduid = '$schengduid'";
	}
	if($szerenid!=''){
	$sql=$sql." and zerenid = '$szerenid'";
	}
	if($szhuangtai!=''){
	$sql=$sql." and zhuangtai = '$szhuangtai'";
	}
	if($sqixian1!=''&&$sqixian2!=''){
		$sql=$sql." and qixian between '$sqixian1' and '$sqixian2'";
	}
	$sql=$sql."  ORDER BY id asc LIMIT ".($pindex - 1) * $psize.','.$psize;
    $list =$db->fetchall($sql);
    $total =count($list);
    $arr = [
        'msg' => "查询成功",
        'code' => 0,
        'data' => $list,
        'count' => $total
    ];
    exit(json_encode($arr));
		break;
	case 'addsave':
	    $shijian=$_POST['shijian'];
	    $laiyuanid=$_POST['laiyuanid'];
	    $fasongid=$_POST['fasongid'];
	    $jieshouid=$_POST['jieshouid'];
	    $fenleiid=$_POST['fenleiid'];
	    $zerenid=$_POST['zerenid'];
	    $qixian=$_POST['qixian'];
	    $chengduid=$_POST['chengduid'];
	    $neirong=$_POST['neirong'];
	    $zhuangtai=$_POST['zhuangtai'];
	    $jieguo=$_POST['jieguo'];
	    $wancheng=$_POST['wancheng'];
	    $weizhiid=$_POST['weizhiid'];
	    $beizhu=$_POST['beizhu'];
		$data=compact('shijian','laiyuanid','fasongid','jieshouid','fenleiid','zerenid','qixian','chengduid','neirong','zhuangtai','jieguo','wancheng','weizhiid','beizhu');
		$db->insert('renwu',$data);//查询获取数组
		$arr=['isOk'=>1,'message'=>'添加成功'];
        exit(json_encode($arr));
		break;	
	case 'editsave':
	    $id=$_POST['id'];
	    $shijian=$_POST['shijian'];
	    $laiyuanid=$_POST['laiyuanid'];
	    $fasongid=$_POST['fasongid'];
	    $jieshouid=$_POST['jieshouid'];
	    $fenleiid=$_POST['fenleiid'];
	    $zerenid=$_POST['zerenid'];
	    $qixian=$_POST['qixian'];
	    $chengduid=$_POST['chengduid'];
	    $neirong=$_POST['neirong'];
	    $zhuangtai=$_POST['zhuangtai'];
	    $jieguo=$_POST['jieguo'];
	    $wancheng=$_POST['wancheng'];
	    $weizhiid=$_POST['weizhiid'];
	    $beizhu=$_POST['beizhu'];
		$data=compact('shijian','laiyuanid','fasongid','jieshouid','fenleiid','zerenid','qixian','chengduid','neirong','zhuangtai','jieguo','wancheng','weizhiid','beizhu');
		$db->update('renwu',$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('renwu',['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-label">任务来源</label>
      <div class="layui-input-inline">
        <select name="slaiyuanid" id="slaiyuanid">
      </select>
      </div>
    </div>
     <div class="layui-inline">
      <label class="layui-form-label">发送人</label>
       <div class="layui-input-inline">
           <select name="sfasongid" id="sfasongid">
          </select>
      </div>
    </div>
    <div class="layui-inline">
      <label class="layui-form-label">接收人</label>
       <div class="layui-input-inline">
          <select name="sjieshouid" id="sjieshouid">
          </select>
       </div>
    </div>
    <div class="layui-inline">
      <label class="layui-form-label">任务类型</label>
      <div class="layui-input-inline">
        <select name="sfenleiid" id="sfenleiid">
          </select>
     ...
完整源码文件,请先购买后再查看
关于我们 | 顾问团队 | 发展历程 | 联系我们 | 源码上传
联系电话(Tel):4008-010-151(免长途)
地址:北京市海淀区大恒科技大厦五层 邮编:100080
Floor 5th,Daheng Building,Zhongguancun,Beijing,China,100080
51Aspx.com 版权所有 CopyRight © 2006-2022. 京ICP备09089570号 | 京公网安备11010702000869号