if ($xianzhong == "五险") { $xz = "and shebao.xianzhong='五险' "; } //echo"$_SESSION[fac]";//从common.php传过来,只显示登录人所在工厂的数据,如果登录人所在工厂为空,显示全部数据 if (@$_SESSION[fac] != null) { $ft = "and yuangong.gongzuodidian='{$_SESSION['fac']}' and yuangong.shifouzaizhi='是' "; } $sql2 = "SELECT yuangong.yuangongID,shebao.shebaoID,shebao.ygongID,yuangong.number,yuangong.name,shebao.jishu,shebao.bili,shebao.xianzhong,shebao.shebao,shebao.beizhu FROM yuangong left join shebao ON yuangong.yuangongID=shebao.ygongID WHERE(1=1) "; //日期是字符串类型,所以要加引号 $s = "and yuangong.shifouzaizhi='是'"; $sql2 .= @$nb; $sql2 .= @$nm; $sql2 .= @$ft; $sql2 .= @$xz; $sql2 .= @$s; $mydb = new MyDBCX(); //创建数据库操作类MyDB的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 40); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; if ($number != null) { $nb = "and yuangong.number={$number} "; } if ($name != null) { $nm = "and yuangong.name='{$name}' ";
if($zhuchang=="是"){ $zc="and yuangong.shifouzhuchang='是' ";} if($zhuchang=="否"){ $zc="and yuangong.shifouzhuchang='否' ";} $sql2="select number,name,yuangongID,fadingcq,fadingjb,zhoumojb,guodingdx,hunjia,chanjia,sangjia,bingjia,pingshiqj,zhoumoqj,quanqin,dizeng,peixun,jintie,hongbao,fazhan,gaowen,gongshang,shuidian,channengbt,zuidibt,zhuanghuo,xiehuo,zahuo,yichang,chanlianggongzi,zhilianggongzi From yuangong left join kaoqin_view on yuangongID=kaoqin_view.ygongID left join chanliang_view ON yuangongID=chanliang_view.ygongID left join zhiliang_view ON yuangongID=zhiliang_view.ygongID where (1=1)"; $s="and shifouzaizhi='是' "; $sql2.=@$rq; $sql2.=@$nb; $sql2.=@$nm; $sql2.=@$ft; $sql2.=@$zc; $sql2.=@$s; $mydb=new MyDBCX();//创建数据库操作类MyDBCX的对象 $total=$mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage=new Page($total,$current_page,500); //通过获取的值创建分页类Page的对象 $pageInfo=$fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset=$pageInfo["row_offset"]; $num=$pageInfo["row_num"]; //if(($qishirq!=null)and($zhongzhirq!=null)){ // $rq="and ((chanliang.riqi between ('$qishirq') and ('$zhongzhirq')) or chanliang.riqi is null) and yuangong.shifouzaizhi='是' ";} if($number!=null){ $nb="and yuangong.number=$number and yuangong.shifouzaizhi='是' ";} if($name!=null){ $nm="and yuangong.name='$name' and yuangong.shifouzaizhi='是' ";}
} if ($zhuchang == "是") { $zc = "and yuangong.shifouzhuchang='是' "; } if ($zhuchang == "否") { $zc = "and yuangong.shifouzhuchang='否' "; } $sql2 = "select number,name,yuangongID,fadingcq,fadingjb,zhoumojb,guodingdx,hunjia,chanjia,sangjia,bingjia,pingshiqj,zhoumoqj,quanqin,dizeng,peixun,jintie,hongbao,fazhan,gaowen,gongshang,shuidian,channengbt,zuidibt,zhuanghuo,xiehuo,zahuo,yichang,chanlianggongzi,zhilianggongzi From yuangong left join kaoqin_view on yuangongID=kaoqin_view.ygongID left join chanliang_view ON yuangongID=chanliang_view.ygongID left join zhiliang_view ON yuangongID=zhiliang_view.ygongID where (1=1)"; $s = "and shifouzaizhi='是' "; $sql2 .= @$rq; $sql2 .= @$nb; $sql2 .= @$nm; $sql2 .= @$ft; $sql2 .= @$zc; $sql2 .= @$s; $mydb = new MyDBCX(); //创建数据库操作类MyDBCX的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 500); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; //if(($qishirq!=null)and($zhongzhirq!=null)){ // $rq="and ((chanliang.riqi between ('$qishirq') and ('$zhongzhirq')) or chanliang.riqi is null) and yuangong.shifouzaizhi='是' ";} if ($number != null) { $nb = "and yuangong.number={$number} and yuangong.shifouzaizhi='是' "; }
if ($factory == "bohan") { $ft = "and yuangong.gongzuodidian='博涵' "; } //echo"$_SESSION[fac]";//从common.php传过来,只显示登录人所在工厂的数据,如果登录人所在工厂为空,显示全部数据 if (@$_SESSION[fac] != null) { $ft = "and yuangong.gongzuodidian='{$_SESSION['fac']}' and yuangong.shifouzaizhi='是' "; } $sql2 = "SELECT yuangong.yuangongID,yuangong.gongzuodidian,chanliang.chanliangID,chanliang.ygongID,yuangong.number,yuangong.name,chanliang.riqi,chanliang.gongxu,chanliang.chanliang,chanliang.channengbt,chanliang.zhuanghuo,chanliang.xiehuo,chanliang.zahuo,chanliang.yichang,chanliang.chanlianggongzi FROM yuangong left join chanliang ON yuangong.yuangongID=chanliang.ygongID WHERE(1=1) "; //日期是字符串类型,所以要加引号 $s = "and yuangong.shifouzaizhi='是'"; $sql2 .= @$rq; $sql2 .= @$nb; $sql2 .= @$nm; $sql2 .= @$ft; $sql2 .= @$s; $mydb = new MyDBCX(); //创建数据库操作类MyDB的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 20); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; if ($qishirq != null and $zhongzhirq != null) { $rq = "and ((chanliang.riqi between ('{$qishirq}') and ('{$zhongzhirq}')) or chanliang.riqi is null) and yuangong.shifouzaizhi='是' "; } if ($number != null) { $nb = "and yuangong.number={$number} and yuangong.shifouzaizhi='是' ";
$arr = array(); while ($row = $result->fetch_assoc()) { $arr[] = $row; } $result->close(); $mysqli->close(); $tpl->assign("permissionx", $arr); $tpl->assign("permissionn", "权限名"); $tpl->assign("permissionc", "权限代码"); /*在GET方法中获取用户提交的页面索引数字。默认第一页,页面索引$current_page值为1*/ $current_page = isset($_GET['page']) ? intval($_GET['page']) : 1; /* 通过is_cached()方法判断指定的页面是否已经被缓存,如果是则不再执行数据库操作 */ if (!$tpl->isCached("default/role.tpl", $current_page)) { $sql2 = "SELECT * from role WHERE(1=1) "; //日期是字符串类型,所以要加引号 $mydb = new MyDBCX(); //创建数据库操作类MyDB的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 40); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; $sql2 = "SELECT * from role WHERE(1=1) "; //日期是字符串类型,所以要加引号 $s = "order by rolecode DESC"; $sql2 .= @$s; $role = $mydb->getPageRows($sql2);
$arr = array(); while ($row = $result->fetch_assoc()) { $arr[] = $row; } $result->close(); $mysqli->close(); $tpl->assign("permissionx", $arr); $tpl->assign("permissionn", "权限名"); $tpl->assign("permissionc", "权限代码"); /*在GET方法中获取用户提交的页面索引数字。默认第一页,页面索引$current_page值为1*/ $current_page = isset($_GET['page']) ? intval($_GET['page']) : 1; /* 通过is_cached()方法判断指定的页面是否已经被缓存,如果是则不再执行数据库操作 */ if (!$tpl->isCached("default/admin.tpl", $current_page)) { $sql2 = "SELECT * from admin WHERE(1=1) "; //日期是字符串类型,所以要加引号 $mydb = new MyDBCX(); //创建数据库操作类MyDB的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 40); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; $sql2 = "SELECT * from admin WHERE(1=1) "; //日期是字符串类型,所以要加引号 $s = "order by adminid DESC"; $sql2 .= @$s; $admin = $mydb->getPageRows($sql2);
if ($zaizhi == "否") { $zz = "and shifouzaizhi='否' "; } //echo"$_SESSION[fac]";//从common.php传过来,只显示登录人所在工厂的数据,如果登录人所在工厂为空,显示全部数据 if (@$_SESSION[fac] != null) { $ft = "and yuangong.gongzuodidian='{$_SESSION['fac']}' and yuangong.shifouzaizhi='是' "; } $sql2 = "SELECT yuangongID,number,name,sex,birthday,age,idno,cell,tel,email,marriage,hometown,livesite,zhiwu,ruzhiriqi,hetongqixian,gongzuodidian,shifouzhuchang,shifouzaizhi,lizhiriqi,feature,memo FROM yuangong WHERE(1=1) "; //日期是字符串类型,所以要加引号 " $sql2 .= @$rq; $sql2 .= @$nb; $sql2 .= @$nm; $sql2 .= @$ft; $sql2 .= @$zc; $sql2 .= @$zz; $mydb = new MyDBCX(); //创建数据库操作类MyDB的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 20); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; if ($ruzhirq1 != null and $ruzhirq2 != null) { $rq = "and (ruzhiriqi between ('{$ruzhirq1}') and ('{$ruzhirq2}')) "; } //日期是字符串类型,所以要加引号 if ($number != null) {
$arr = array(); while ($row = $result->fetch_assoc()) { $arr[] = $row; } $result->close(); $mysqli->close(); $tpl->assign("permissionx", $arr); $tpl->assign("permissionn", "权限名"); $tpl->assign("permissionc", "权限代码"); /*在GET方法中获取用户提交的页面索引数字。默认第一页,页面索引$current_page值为1*/ $current_page = isset($_GET['page']) ? intval($_GET['page']) : 1; /* 通过is_cached()方法判断指定的页面是否已经被缓存,如果是则不再执行数据库操作 */ if (!$tpl->isCached("default/permission.tpl", $current_page)) { $sql2 = "SELECT * from permission WHERE(1=1) "; //日期是字符串类型,所以要加引号 $mydb = new MyDBCX(); //创建数据库操作类MyDB的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 40); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; $sql2 = "SELECT * from permission WHERE(1=1) "; //日期是字符串类型,所以要加引号 $s = "order by permissioncode DESC"; $sql2 .= @$s; $permission = $mydb->getPageRows($sql2);
$arr = array(); while ($row = $result->fetch_assoc()) { $arr[] = $row; } $result->close(); $mysqli->close(); $tpl->assign("permissionx", $arr); $tpl->assign("permissionn", "权限名"); $tpl->assign("permissionc", "权限代码"); /*在GET方法中获取用户提交的页面索引数字。默认第一页,页面索引$current_page值为1*/ $current_page = isset($_GET['page']) ? intval($_GET['page']) : 1; /* 通过is_cached()方法判断指定的页面是否已经被缓存,如果是则不再执行数据库操作 */ if (!$tpl->isCached("default/kaoqinxiaoshi.tpl", $current_page)) { $sql2 = "SELECT * from user WHERE(1=1) "; //日期是字符串类型,所以要加引号 $mydb = new MyDBCX(); //创建数据库操作类MyDB的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 40); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; $sql2 = "SELECT * from user WHERE(1=1) "; //日期是字符串类型,所以要加引号 $s = "order by userid DESC"; $sql2 .= @$s; $user = $mydb->getPageRows($sql2);
//包含分页类Page所在的文件 require "class/MyDBCX.class.php"; //包含数据库读取类所在的文件 /*在GET方法中获取用户提交的页面索引数字。默认第一页,页面索引$current_page值为1*/ $current_page = isset($_GET['page']) ? intval($_GET['page']) : 1; /* 通过is_cached()方法判断指定的页面是否已经被缓存,如果是则不再执行数据库操作 */ if (!$tpl->isCached("default/kaoqinxiaoshi.tpl", $current_page)) { $ft = "and (gongchang='罗麦' or gongchang='博涵')"; //echo"$_SESSION[fac]";//从common.php传过来,只显示登录人所在工厂的数据,如果登录人所在工厂为空,显示全部数据 if (@$_SESSION[fac] != null) { $ft = "and gongchang='{$_SESSION['fac']}'"; } $sql2 = "SELECT * from xiaoshi WHERE(1=1) "; //日期是字符串类型,所以要加引号 $sql2 .= @$ft; $mydb = new MyDBCX(); //创建数据库操作类MyDB的对象 $total = $mydb->getRowTotal($sql2); //调用MyDB类的方法返回数据表记录总数 $fpage = new Page($total, $current_page, 40); //通过获取的值创建分页类Page的对象 $pageInfo = $fpage->getPageInfo(); //获取和当前页面有关的所有信息数组 /* 通过调用MyDB中的方法,获取当前页面所需要的所有记录的数据数组 */ $offset = $pageInfo["row_offset"]; $num = $pageInfo["row_num"]; $ft = "and (gongchang='罗麦' or gongchang='博涵')"; //echo"$_SESSION[fac]";//从common.php传过来,只显示登录人所在工厂的数据,如果登录人所在工厂为空,显示全部数据 if (@$_SESSION[fac] != null) { $ft = "and gongchang='{$_SESSION['fac']}'"; }