"; //print_r($_REQUEST); //include("inc/session.php"); include("inc/connection.php"); ?> Direktori Pegawai

 

Carian Direktori

Nama Pegawai

:

Seksyen/Bahagian

 :
0) array_push($newParams, $param); } } if (count($newParams) != 0) { $prm_old = "&" . implode("&", $newParams); } } $postString = ""; //while(list($key, $val) = each($HTTP_POST_VARS)) { while(list($key, $val) = each($_POST)) { $key = stripslashes($key); $val = stripslashes($val); $key = urlencode($key); $val = urlencode($val); if (strlen(trim($postString))>0) $postString .= "&"; $postString .= "$key=$val"; } if (strlen(trim($postString))>0) $prm_old .= "&".$postString; // condition $where_sql = ""; if (strlen(trim($in_search))>0 ) { $where_sql .= " and ( ( UPPER(fd_nama) like '%".str_replace("'", "''",strtoupper(trim($in_search)))."%' ) or ( UPPER(fd_tel) like '%".str_replace("'", "''",strtoupper(trim($in_search)))."%' ) or ( UPPER(fd_emel) like '%".str_replace("'", "''",strtoupper(trim($in_search)))."%' ) or ( UPPER(fd_jawatan) like '%".str_replace("'", "''",strtoupper(trim($in_search)))."%' ) ) "; } if ($in_department == "all" ) { $where_sql .= "order by case when fd_jabatan = 'BHEUU' Then fd_gred else '' end desc, case when fd_jabatan = 'BBG' Then fd_gred else '' end desc, case when fd_jabatan = 'JIM' Then fd_gred end desc "; } else if ($in_department == "bheuu" ) { $where_sql .= " and fd_jabatan= 'BHEUU' order by fd_gred desc "; } else if ($in_department == "bbg" ) { $where_sql .= " and fd_jabatan= 'BBG' order by fd_gred desc "; } else if ($in_department == "jim" ) { $where_sql .= " and fd_jabatan= 'JIM' order by fd_gred desc "; } //order by fd_nama asc else { if (strlen(trim($in_department))>0 ) { $where_sql .= " and UPPER(fd_seksyen)= '$in_department' order by fd_seksyen,fd_gred desc "; } } /*and fd_seksyen = '$in_department' order by fd_seksyen,fd_nama asc */ //echo "
bug where_sql = [$where_sql]"; // count all record $sql = "select count(*) as JUMREK FROM tb_staff where 1=1 " .$where_sql; //echo "
bug sql=[$sql]"; $result= mysql_query($sql) or mim_errdb(__FILE__,__LINE__,mysql_error($conn)); $row_all_rec = mysql_fetch_assoc ( $result ); //$nums_all_rec = mysql_num_rows($result); $nums_all_rec = $row_all_rec['JUMREK']; /* $sql = "select * FROM tb_staff where 1=1 " .$where_sql; echo "
bug sql=[$sql]"; $sql .= " limit $limit , $per_page "; //echo "
bug sql=[$sql]"; $sql_query_rs= mysql_query($sql) or mim_errdb(__FILE__,__LINE__,mysql_error($conn)); while ($sqlrs2 = mysql_fetch_array($sql_query_rs)) { $show_jabatan =$sqlrs2['fd_jabatan']; $show_seksyen =$sqlrs2['fd_seksyen']; } */ //echo "
bug nums_all_rec = $nums_all_rec "; //-- kira ms if (!$per_page) $per_page = 14;//12;//12; //echo "
bug per_page=[$per_page]"; if (!$page) $page = 1; //echo "
bug page=[$page]"; $prev_page = $page - 1; //echo "
bug prev_page=[$prev_page]"; $next_page = $page + 1; //echo "
bug next_page=[$next_page]"; $page_start = ($per_page * $page) - $per_page; //echo "
bug page_start=[$page_start]"; if ($nums_all_rec <= $per_page) { $num_pages = 1; } else if (($nums_all_rec % $per_page) == 0) { $num_pages = ($nums_all_rec / $per_page); } else { $num_pages = ($nums_all_rec / $per_page) + 1; } $num_pages = (int) $num_pages; //echo "
bug num_pages=[$num_pages]"; if (($page > $num_pages) || ($page < 0)) { echo ""; echo "You have specified an invalid page number"; echo ""; } $rr_s = ($page-1)*$per_page + 1; //echo "
bug rr_s=[$rr_s]"; if ( ( $rr_s + $per_page ) <= $nums_all_rec ) $rr_e = ($rr_s + $per_page) - 1; else $rr_e = $nums_all_rec; // jika tiada rekod if ($nums_all_rec==0) { $num_pages=0; $page=0; $rr_s = 0; } $limit = $rr_s -1; $max_pages = ceil ( $nums_all_rec / $per_page ); ?>
  Halaman rekod. Dipamirkan -. Halaman: // Previous if ($prev_page) { $param = "$PHP_SELF?page=$prev_page&per_page=$per_page".$prm_old; echo "<Prev "; } // senaraikan page - current page = bold & under $pg_window_sz = 3 ; if ( ($page-$pg_window_sz)>1 ) echo ".. "; for ($i = 1; $i <= $num_pages; $i++) { $param = "$PHP_SELF?&page=$i&per_page=$per_page".$prm_old; //-- hadkan senarai page.num. 5 page sebelum dan selepas if ( ($i>=$page-$pg_window_sz) && ($i<=$page+$pg_window_sz) ) { if ($i != $page) { echo "$i "; } else { echo "$i "; } } } if ( ($page+$pg_window_sz)<$num_pages ) echo ".. "; // Next if ($page != $num_pages) { $param = "$PHP_SELF?page=$next_page&per_page=$per_page".$prm_old; echo "Next>"; } ?>

"; //echo "
"; $sql = "select * FROM tb_staff where 1=1 and fd_kodseksyen = '16' order by fd_gred desc "; //echo "
bug sql=[$sql]"; $sql .= " limit $limit , $per_page "; //echo "
bug sql=[$sql]"; $result= mysql_query($sql) or mim_errdb(__FILE__,__LINE__,mysql_error($conn)); while ($sqlrs2 = mysql_fetch_array($result)){ $nama =$sqlrs2['fd_nama']; $jawatan =$sqlrs2['fd_jawatan']; $emel =$sqlrs2['fd_emel']; $tel =$sqlrs2['fd_tel']; $jabatan =$sqlrs2['fd_jabatan']; $seksyen =$sqlrs2['fd_seksyen']; } //echo "

"; //echo "".$seksyen.""; echo ""; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // dptkan rekod2 yg akan dipamirkan dlm current page $sql = "select * FROM tb_staff where 1=1 " .$where_sql; //echo "
bug sql=[$sql]"; $sql .= " limit $limit , $per_page "; //echo "
bug sql=[$sql]"; $result= mysql_query($sql) or mim_errdb(__FILE__,__LINE__,mysql_error($conn)); /* //buang rekod yg dihadapan, untuk pergi ke rec.no. yg dikehendaki for ($buang=1; $buang<=$rr_s-1; $buang++) mysql_fetch_assoc($result); */ $recno = $rr_s; $i=0; while ($sqlrs2 = mysql_fetch_array($result)){ $i=$recno-$rr_s; $nama =$sqlrs2['fd_nama']; $jawatan =$sqlrs2['fd_jawatan']; $emel =$sqlrs2['fd_emel']; $tel =$sqlrs2['fd_tel']; $jabatan =$sqlrs2['fd_jabatan']; $seksyen =$sqlrs2['fd_seksyen']; $emel = str_replace("@bheuu.gov.my", "", $emel); if($xx%2==0) $bg="#C2D1E0"; // $bg="#f4f4FF"; else $bg="#FFFFFF"; echo ""; //echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; $recno++; } echo "
Bil Nama Pegawai Jawatan Emel@bheuu.gov.my No Telefon Jabatan - Seksyen
$xx.".($recno).". ".$nama."".$jawatan."".$emel."".$tel."".$seksyen."".$jabatan." / ".$seksyen."
"; //echo "".$jabatan." / ".$seksyen.""; } // End ButtonCari mysql_close($link); ?>