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 ($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 ($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']}'";
}
