$(document).ready(function(){
$("#table_local").dataTable({
"bSort":true,
"bAutoWidth": false,
"bFilter":true,
"bInfo":true,
"bJQueryUI":false,
//配合使用 全都是true的时候开启
"bLengthChange":true,
"bPaginate":true,
//配合使用
"bScrollInfinite": true,
"bScrollCollapse": true,
"sScrollY": "",
//配合使用
"sScrollX": "100%",//disabled or 100% 其实只要不是空,就算是123也会出现效果
"sScrollXInner": "100%",
//保存客户端信息在cookie里,了解
"bStateSave":true,
//这个为选择每页的条目数,当使用一个二维数组时,二维层面只能有两个元素,第一个为显示每页条目数的选项,第二个是关于这些选项的解释
//"aLengthMenu":[5,10,20,50,100],
//"aLengthMenu":[[10, 25, 30, -1],[10, 25, "三十", "All"]],
"iCookieDuration":10,
//默认分页条数
//iDisplayStart 从第几行开始显示数据
"iDisplayLength":34,
//'full_numbers' or 'two_button', default 'two_button' 用于指定分页器风格
//"sPaginationType":'two_button',
//第0列降序排列
"aaSorting": [[0,"desc"]],
//隐藏某些列
/* "aoColumnDefs": [{" bSearchable": false, "bVisible": false, "aTargets": [ 2 ]},{ "bVisible": false, "aTargets": [ 3 ] }], */
// language: {
// lengthMenu: '' + '1' + '10' + '20' + '30' + '40' + '50' + '条记录',//左上角的分页大小显示。
// search: '搜索:',//右上角的搜索文本,可以写html标签
// paginate: {//分页的样式内容。
// previous: "上一页",
// next: "下",
// first: "第一",
// last: "最后"
// },
// zeroRecords: "没有内容",//table tbody内容为空时,tbody的内容。
//下面三者构成了总体的左下角的内容。
// info: "总共_PAGES_ 页,显示第_START_ 到第 _END_ ,筛选之后得到 _TOTAL_ 条,初始_MAX_ 条 ",//左下角的信息显示,大写的词为关键字。
// infoEmpty: "0条记录",//筛选为空时左下角的显示。
// infoFiltered: ""//筛选之后的左下角筛选提示,
// },
});
});
echo iconv("gb2312","UTF-8"," 绩效转移单查询") ?>
echo iconv("gb2312","UTF-8","申请单号") ?> echo iconv("gb2312","UTF-8","申请人") ?> echo iconv("gb2312","UTF-8","申请部门") ?> echo iconv("gb2312","UTF-8","申请日期") ?> echo iconv("gb2312","UTF-8","转出单位") ?> echo iconv("gb2312","UTF-8","转移科目") ?> echo iconv("gb2312","UTF-8","申请金额") ?> echo iconv("gb2312","UTF-8","承认金额") ?> echo iconv("gb2312","UTF-8","签核者") ?>
require_once('/php/public/opendb.inc');
require_once('/php/public/openmydb.inc');
require("/php/public/power.inc");
$sql="select distinct a.exp_no,a.create_user,name(a.create_user),a.create_date,a.dept_no,a.acc_name,tot_amt1,tot_amt2,b.flow_code,a.form_key
from exp_main a,flow b
where a.form_key=b.form_key order by a.exp_no desc"; #echo "$sql";
$stmt=$dbh->prepare("$sql");
$stmt->execute() || die("error");
$i=0;
while(list($exp_no,$exp_man,$exp_man_name,$create_date,$dept_no,$acc_name,$tot_amt1,$tot_amt2,$flow_code,$form_key)=$stmt->fetch()){
list($flow_code)=field("select flow_code from it.flow where form_key=$form_key");
$current_user2='';
if($flow_code=='Z')
$current_user2=iconv("gb2312","UTF-8","结案");
elseif($flow_code=='C')
{
$child_sql="select form_key from workflow_subflow where parent_key='$form_key' and reply_flag='N'";
$chis=$dbh->prepare("$child_sql");
$chis->execute()|| die("chile_err");
for($j=0;list($child_key)=$chis->fetch();$j++)
{
#if($form_key=='100001245685'){ echo "$child_key,$current_user2".'
';}
list($current_user1)=fields("select distinct current_user from it.subflow where form_key='$child_key'");
$current_n[$j]=iconv("gb2312","UTF-8",name($current_user1));
$current_user2=$current_user2."($current_user1)".$current_n[$j];
}
$current_user2=iconv("gb2312","UTF-8",'会签中').$current_user2;
}
else
{
list($current_user1,$current_user1name)=fields("select current_user,name(current_user) from it.subflow where form_key=$form_key");
$current_user2="($current_user1)".iconv("gb2312","UTF-8",$current_user1name);
}
$sel="select get_depart_name(get_depart('$exp_man')),get_depart('$exp_man') from dual";
$stc=$dbh->prepare("$sel");
$stc->execute()||die("申请人部门 error");
list($depart_name,$getdepart)=$stc->fetch();
$str1="select acc_depart_name from acc_gl_depart where acc_depart_no='$dept_no'";
list($dep_name)=fields("$str1");
$acc_name=iconv("gb2312","UTF-8",$acc_name);
echo "
$exp_no$exp_man-".iconv("gb2312","UTF-8",$exp_man_name)."$getdepart-".iconv("gb2312","UTF-8",$depart_name)."$create_date$dept_no-".iconv("gb2312","UTF-8",$dep_name)."$acc_name$tot_amt1$tot_amt2 $current_user2";echo "
";$i=$i+1;
}
?>