您的位置: 首页 > 会员中心 > 发票管理->

 
0)$wheres=" AND iAmount>0"; } if($Product!="") $wheres.=" AND Product='$Product'"; if($iActive!="") $wheres.=" AND iActive='$iActive'"; $wheres.=" AND iAmount>0"; if($order == ''){ $order = 'IDFinancial'; $desc = 1; } if($order != ''){ $orderby = $order; if($desc){ $orderby .= ' desc'; } } $date_number=(date('Y')-1)."-12"."-1"; // echo $date_number; // $time=time()-30*24*3600; // $date_number=date('y-m-d H:m:s',$time); if($id=='0'){ $sql="select count(*) from financial where UserName='$_SESSION[UserName_S]' and iAmount<0 and iActive=1 and invoice!=3 and (iPayType<5 or iPayType=-7)"; }else if($id=='1'){ $sql="select count(*) from financial where UserName='$_SESSION[UserName_S]' and iAmount<0 and iActive=1 and invoice!=1 and invoice!=3 and (iPayType<5 or iPayType=-7) and dtCreate>='".$date_number."'"; }else if($id=='2'){ $sql="select count(*) from financial where UserName='$_SESSION[UserName_S]' and iAmount<0 and iActive=1 and invoice=1 and invoice!=3 and (iPayType<5 or iPayType=-7)"; } $rs=$DB->query($sql); $pageSize=30; $totalRecord=$DB->result($rs,0,0); $totalPage=ceil($totalRecord/$pageSize); if(!$page)$page=1; $offset=($page-1)*$pageSize; /**充值的金额且已生效的才可以获取发票**/ if($id=='0'){//全部 $sql="select * from financial where UserName='$_SESSION[UserName_S]' and iAmount<0 and iActive=1 and invoice!=3 and (iPayType<5 or iPayType=-7) order by $orderby limit $offset,$pageSize"; }elseif($id=='1'){//未申请的 $sql="select * from financial where UserName='$_SESSION[UserName_S]' and iAmount<0 and iActive=1 and invoice!=3 and (iPayType<5 or iPayType=-7) and invoice!=1 and dtCreate>'".$date_number."' order by $orderby limit $offset,$pageSize"; }else if($id=='2'){//已申请的 已经不用了20110330 $sql="select * from financial where UserName='$_SESSION[UserName_S]' and iAmount<0 and iActive=1 and invoice!=3 and (iPayType<5 or iPayType=-7) and invoice=1 order by $orderby limit $offset,$pageSize"; } //echo $sql; $result=$DB->query($sql); $pageList=getPageList($_SERVER[PHP_SELF],"page","15",$totalPage,$page); ?>
类别:全部未申请已申请
注意:凡已汇款的客户请及时在汇款当期向我司申请发票,跨年度不再提供发票。请及时索取。
      快递方式3个工作日内寄出,请注意查收!
提示:点击标题可进行顺/倒排序