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($factory=="罗麦"){
$ft="and yuangong.gongzuodidian='罗麦' and yuangong.shifouzaizhi='是' ";}
}
//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 ($factory == "luomai") {
