require ('../db_connect_mes.php');
$t2=$_POST['t2'];
$t3=$_POST['t3'];
$t4=$_POST['t4'];
$t5=$_POST['t5'];
$t6=$_POST['t6'];
$t7=$_POST['t7'];
$t8=$_POST['t8'];
$t9=$_POST['t9'];
$t10=$_POST['t10'];
$t11=$_POST['t11'];
$D1=$_POST['D1'];
if($t2==""){$str2="1=1";} else {$str2="bm_name like '%$t2%'"; }
if($t3==""){$str3="1=1";} else {$str3="fbillno like '%$t3%'"; }
if($t4==""){$str4="1=1";} else {$str4="create_user like '%$t4%'"; }
if($t5==""){$str5="1=1";} else {$str5="emp_name like '%$t5%'"; }
if($t8==""){$str8="1=1";} else {$str8="jz_info like '%$t8%'"; }
if($t9==""){$str9="1=1";} else {$str9="fx_info like '%$t9%'"; }
if($t10==""){$str10="1=1";} else {$str10="emp_name1 like '%$t10%'"; }
if($t11==""){$str11="1=1";} else {$str11="cust_info like '%$t11%'"; }
if($D1=="" ){$str12="close_flag='1'"; $text='如下为--未关闭--的内容列表';} else {$str12="close_flag='$D1'"; if($D1=='1'){$text='如下为--未关闭--的内容列表';} if($D1=='2'){$text='如下为已关闭的内容列表';} }
if($D1=='3'){$str12="1=1"; $text='如下为所有(未关闭,已关闭)的内容列表';}
if ($t6 =="" && $t7 =="")
{
$str6="1=1";
}
elseif ($t6 !="" && $t7 =="")
{
$str6="Fdate='$t6'";
}
elseif ($t6 =="" && $t7 !="")
{
$str6="Fdate='$t7'";
}
elseif ($t6 !="" && $t7 !="")
{
$str6="Fdate>='$t6' and Fdate<='$t7'";
}
$str="$str2 and $str3 and $str4 and $str5 and $str6 and $str8 and $str9 and $str10 and $str11 and $str12";
?>
//sono 订单号,so_qty 订单数量,fmodel 规格型号,
mssql_query ( 'SET TEXTSIZE 2147483647' , $conn2 );
$query2 = "
select finterid as ID,fbillno '文件号/标题',create_user 创建人,
CONVERT(varchar,fdate,120) 创建日期,
CONVERT(varchar,fdate1,23) 完成日期,bm_name 部门, emp_name 责任人,emp_name1 知悉人,note 备注,datediff(day,fdate,update_date) 处理天数,
case when close_flag=1 then '未关闭'
when close_flag=2 then '已关闭'
end as 关闭状态,
cast(cust_info as text) as 异常描述,fx_info 原因分析,cl_info 处理结果,
plan_info 计划回复,zg_info 提出或责任主管意见,
jz_info 纠正措施,jl_info 经理意见,fz_info 副总以上意见,
CONVERT(varchar,update_date,120) 关闭日期,update_user 关闭人
from qt_ycfk where type=1 and $str order by finterid DESC";
//执行查询语句 and $strwhere $str
$rresult2 = mssql_query($query2,$conn2) or die("无法执行SQL:$query2");
//$page变量标示当前显示的页
$page2=$_GET[page2];
if(!isset($page2)) $page2=1;
if($page2==0) $page2=1;
//得到当前查询到的纪录数 $nNumRows
if(($nNumRows2= mssql_num_rows($rresult2))<=0)
{
echo "没有纪录";
exit;
};
//得到最大页码数MaxPage
//if($gPageSize=0) {$gPageSize2=1; }
$gPageSize2=100;
//echo "
";
//echo $nNumRows;
$MaxPage2 = (int)ceil($nNumRows2/$gPageSize2);
if((int)$page2 > $MaxPage2)
$page2=$maxPage2;
?>
黄山中显微电子有限公司---异常信息反馈信息查询
echo "$text ";
//显示表格头
for($iCnt2 = 0; $iCnt2 < mssql_num_fields($rresult2); $iCnt2++)
{
echo "".mssql_field_name($rresult2,$iCnt2)." | " ;
}
?>
//根据偏移量($page - 1)*$gPageSize,运用mssql_data_seek函数得到要显示的页面
if( mssql_data_seek($rresult2,($page2-1)*$gPageSize2) )
{
$i=0;
//循环显示当前纪录集
for($i;$i<$gPageSize2;$i++)
{
echo "";
//得到当前纪录,填充到数组$arr;
$arr2= mssql_fetch_row($rresult2);
if($arr2)
{
//循环显示当前纪录的所有字段值
for($nOffSet2 = 0;$nOffSet2 < count($arr2);$nOffSet2++)
{
echo "".$arr2[$nOffSet2]." | ";
}
}
echo "
";
}
}
mssql_free_result($rresult2);
// 关闭连接
mssql_close($conn2);
?>