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") {