"; if ($f_checked == 1) { // เข้าทำงานเฉพาะ เมื่อมีการ check เลือกพนักงาน if (strlen($SELECTED_LIST) > 3000) { // echo ">3000 ..$SELECTED_LIST
"; $_SESSION['SESS_SELECTED_LIST'] = $SELECTED_LIST; } else { $_SESSION['SESS_SELECTED_LIST'] = ""; } } // echo "isSubmit2Parent=$isSubmit2Parent, selected=$sess_selected_name ($SELECTED_LIST)
"; if ($isSubmit2Parent=="1") { $isSubmit2Parent = ""; // $_SESSION['$sess_selected_name'] = $SELECTED_LIST; $_SESSION['SESS_SELECTED_LIST'] = $SELECTED_LIST; $sess_selected_name = "<***".$sess_selected_name."***>"; ?> "; if ($sess_selected_name=="<***session***>") { $SELECTED_LIST = $_SESSION['SESS_SELECTED_LIST']; // echo "SESSION==>".$SELECTED_LIST."
"; } if ($SELECTED_LIST) { // กรณีกด x ถ้ามีค่าค้างอยู่ก็ให้เข้า function isSubmit2Parent $isSubmit2Parent = "1"; } if(trim($search_group)) $arr_search_condition[] = "(name_th like '%$search_group%')"; if(trim($search_name)) $arr_search_condition[] = "(fullname like '%$search_name%')"; if(trim($search_address)) $arr_search_condition[] = "(address like '%$search_address%')"; $search_condition = ""; if(count($arr_search_condition)) $search_condition = " where " . implode(" and ", $arr_search_condition); //หาชื่อผู้ที่มีในระบบการ login $cmd1 ="select username, d.id, titlename, fullname, name_th, address from user_detail d inner join user_group g on g.id = d.group_id $search_condition order by g.group_seq_no, g.name_th, d.fullname "; $count_data=$db->send_cmd($cmd1); // $count_data = 5000; //echo $cmd1; //$db->show_error(); if (!$ALL_PER_LIST && $count_data) { $ARR_ALL_PER = (array) null; $ARR_ALL_GRP= (array) null; $data_count=0; while($datausr = $db->get_array()) { $data_count++; if ($data_count > 5000) break; $datausr = array_change_key_case($datausr, CASE_LOWER); $ARR_ALL_PER[] = $datausr[id]; $ARR_ALL_GRP[] = $datausr[name_th]; } // end while $ALL_PER_LIST = implode(",",$ARR_ALL_PER); $ALL_GRP_LIST = implode(",",$ARR_ALL_GRP); } // end if (!$ALL_PER_LIST && $count_data) function check_full_group_php($per_id){ global $ALL_PER_LIST, $ALL_GRP_LIST, $SELECTED_LIST; // echo "per_id=$per_id
"; $arr_per = explode(",", $ALL_PER_LIST); $arr_grp = explode(",", $ALL_GRP_LIST); $arr_selected = explode(",", $SELECTED_LIST); // หา index เริ่มต้นของ กลุ่ม/PER_ID ที่ต้องการ $target_per_idx = array_search($per_id, $arr_per); $target_grp_idx = array_search($arr_grp[$target_per_idx], $arr_grp); // หา index ตัวแรกของกลุ่มนี้ $target_firstper_idx = array_search($arr_per[$target_grp_idx], $arr_per); // หา per_id แรก ตาม index แรกของกลุ่ม $target_idx = $target_firstper_idx; // $target_idx = $target_per_idx; $chk_grp = $arr_grp[$target_idx]; $cnt_full=0; $cnt_exist=0; while ($chk_grp == $arr_grp[$target_idx]) { // echo "per_id=$per_id, grp[$target_idx]=".$arr_grp[$target_idx]."
"; $c = array_search($arr_per[$target_idx], $arr_selected); if ($c !== false) $cnt_exist++; // นับเฉพาะที่เลือกไว้ $cnt_full++; // นับทั้งหมด $target_idx++; } return ($cnt_full==$cnt_exist); } // end function count_grp ?> รายชื่อผู้ใช้งาน
 
กลุ่มผู้ใช้งาน :     
 :  สังกัด : 
<?=$CLOSE_WINDOW_TITLE?> 
พบรายชื่อผู้ใช้งาน ทั้งสิ้น ราย
1)? ($current_page * $data_per_page) : $data_per_page; $cmd1 ="select * from ( select rownum rnum, q1.* from ( select username, d.id, titlename, fullname, name_th, address from user_detail d,user_group g where g.id=d.group_id $search_condition order by g.group_seq_no, g.name_th, d.fullname ) q1 ) where rnum between $rec_start and $rec_end "; } // echo $cmd1; $count_page_data = $db->send_cmd($cmd1); // $db->show_error(); if($count_page_data){ ?> get_array()) : $data_count++; if($data_count > $data_per_page) break; $datausr = array_change_key_case($datausr, CASE_LOWER); $TMP_PER_ID = $datausr[id]; $TMP_PER_FULLNAME=$datausr[titlename] . $datausr[fullname]; $TMP_ADDRESS=$datausr[address]; $TMP_PER_GROUPNAME = $datausr[name_th]; $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; $returnValue = "$TMP_PER_ID<::>$TMP_PER_FULLNAME"; $checked = ""; // echo "if(in_array($TMP_PER_ID, $ARR_SELECTED))=".in_array($TMP_PER_ID, $ARR_SELECTED)."
"; if(in_array($TMP_PER_ID, $ARR_SELECTED)){ $count_selected++; $checked = "checked"; } // end if $disabled = ""; if(in_array($TMP_PER_ID, $ARR_EXCEPT)) $disabled = "disabled"; // echo "if($CUR_GROUPNAME != $TMP_PER_GROUPNAME)
"; if($CUR_GROUPNAME != $TMP_PER_GROUPNAME) { $TMP_PER_FULLNAME = $TMP_PER_GROUPNAME; $CUR_GROUPNAME = $TMP_PER_GROUPNAME; $checked_grp = ""; if (check_full_group_php($TMP_PER_ID)) $checked_grp = "checked"; ?> > "; ?> > >
สังกัด
>    
  >  
  >  
1) : ?>