連動選單

html

  $select_uint_form="
     單位：".get_units_select_option($unit)."";

  $select_user_form="
     使用者：";

javascript

ajax.php

include_once "header.php";
$op=(empty($_REQUEST['op']))?"main":$_REQUEST['op'];
$unit=intval($_REQUEST['unit']);

switch($op){
  //
 case "get_user":
    echo get_user_form_unit($unit);
    //echo json_encode(array("prod_sort"=>$main['prod_sort'],"total"=>$main['total']));
 break;
  
  //預設動作
  default:
  $main="";
  break;
}
#################################################################################
# 以單位取得使用者的選單
#
#
#
#
#
################################################################################
function get_user_form_unit($unit_sn){
  global $xoopsDB;
  $sql="select a.* ,b.`name`,b.`uname` from  ".$xoopsDB->prefix("ugm_apply_users")." as a left join ".$xoopsDB->prefix("users")." as b on a.`uid`=b.`uid` where a.`unit_sn`='{$unit_sn}' ";
  $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
  $main="全部";
  while($all=$xoopsDB->fetchArray($result)){
   foreach($all as $k=>$v){
     $$k=$v;
   }
   $uid_name=$name?$name:$uname;
   $main.="{$uid_name}";
  }
  return $main;
}

涷結窗格

  $main=$jquery_path.ugm_javascript(1)."
  <link href='class/ScrollTable/superTables.css' rel='Stylesheet' type='text/css' />
  <script type='text/javascript' src='class/ScrollTable/superTables.js'></script>
  <style>
  .fakeContainer {
      margin: 20px;
      padding: 0px;
      border: none;
      width: 95%;
      height: 300px;
      overflow: hidden;
  }
  </style> 
  <div class='fakeContainer'>
  <table id='ugm_tb' border='0' cellspacing='3' cellpadding='3'>
    <tr><th>標題</th>{$main_head}</tr>
    {$main_body}
  
  </table>
  </div>
  <script type='text/javascript'>
  (function() {
      new superTable('ugm_tb', {
          cssSkin : 'sSky', //颜色方案
          fixedCols : 1 //固定几列
      });
  })();
  </script>
  ";
  # 這裡若用「%」設寬度且標題過長，則垂直捲軸失效
  $main=$select_form.ugm_div($xoopsModuleConfig['statements_title']." - {$year} 年 {$month} 月份 各單位領用消耗品統計表",$main,"","width:95%;");
  return $main;

 

TCPDF分頁2

<?php

$page_count=28;//每頁筆數
while($all=$xoopsDB->fetchArray($result)){
 
  $i=0;
  
  $array=取得列表陣列函數;# 將資料整合成陣列
  
  $count=count(陣列);
  
  foreach($array as $key=>$value){
    if($i==0 or $i%($page_count)==0){
      $pdf->AddPage(); //新增頁面
      # ------- 每頁標題 ---------------------
      $main="";
    }
    foreach($value as $k1=>$v1){
      $$k1=$v1;    
    }
    # ------- body ---------------------------
    $main.="身體檔";
    $i++;
  
    if($i==$count){ 
     $main.="本期結餘"+"頁尾"; 
     $pdf->writeHTML($main, true, false, false, false, '');
    }elseif($i%($page_count)==0){
      #換頁
     $main.="頁尾"; 
     $pdf->writeHTML($main, true, false, false, false, ''); 
    }
  } 
}
// -----------------------------------------------------------------------------
$pdf->Output("pdf_commodity_in_out_{$year}-{$month}.pdf", 'I');


?>

TCPDF分頁

$page=1;
$row=1;
$page_count=20;//每頁筆數
$total         //總筆數

while($all=$xoopsDB->fetchArray($result)){

  # -------- 頁首 -------------------------------------------------------
  if($row==1 or ($row%(($page-1)*$page_count+1)==0 and $row>$page_count)){ 
    $pdf->AddPage(); //新增頁面
    $main="<table><tr><th></th></tr>";
  }
  #----------body ----------------------
   $main.="<tr><td></td></tr>"; 
  #--------- 頁尾 ------------------------
  if($row==$total or $row%($page_count)==0){
   $main.="</table>";
   $pdf->writeHTML($main, true, false, false, false, '');
   $page++; #頁數
   $main="";#內容
  }
  $row++;
}