|
send_cmd($cmd);
// $db_dpis->show_error();
// echo "part1-$cmd-($count_data)
";
if (strlen($current_page_lvl) > 0) { // ตรวจสอบ current page จาก หน้าก่อนส่งเข้ามา
$arr_current_page = explode(",", $current_page_lvl);
}
$arr_current_page_new = (array) null;
for($i=0; $i < count($arr_org[id]); $i++) {
$class = "table_body_over";
$i_edit="";
// echo "arr_org [id] [$i] (".$arr_org[id][$i].")==ORG_ID ($ORG_ID)
";
if ($arr_current_page[$i])
$arr_current_page_new[] = $arr_current_page[$i];
else
$arr_current_page_new[] = "1";
if($arr_org[id][$i]==$ORG_ID && $count_data==0) {
$sel_org = "select_head_org(". $arr_org[id][$i] .");";
$class = "table_body";
$i_edit = " ![\"Edit](\"images/b_edit.png\") ![\"New](\"images/add_down_level_s.png\") ";
} elseif($arr_org[id][$i]==$ORG_ID) {
$sel_org = "";
if ($arr_org[id][$i]==1)
$i_edit = " ![\"Print](\"images/print01.gif\")
![\"แผนภูมิ](\"images/picture.gif\")
";
else
$i_edit = "
";
} else {
$sel_org = "select_head_org(". $arr_org[id][$i] .");";
}
?>
| |
";
?>
1)? ($current_page * $data_per_page) : $data_per_page;
$cmd = "select * from (
select rownum rnum, q1.* from (
select ORG_ID , ORG_NAME, ORG_ID_REF, ORG_ACTIVE
from $ORGTAB where ORG_ID_REF = $ORG_ID
order by ORG_ACTIVE DESC, ORG_SEQ_NO, ORG_CODE
) q1
) where rnum between $rec_start and $rec_end ";
}elseif($DPISDB=="mysql"){
$limit_data = " limit " . (($current_page - 1) * $data_per_page) . ", " . $data_per_page;
$cmd = " select ORG_ID , ORG_NAME, ORG_ID_REF, ORG_ACTIVE from $ORGTAB
where ORG_ID_REF = $ORG_ID
order by ORG_ACTIVE DESC, ORG_SEQ_NO, ORG_CODE
$limit_data
";
} // end if
$count_page_data = $db_dpis->send_cmd($cmd);
// $db_dpis->show_error();
// echo "part2-$cmd-($count_page_data)
";
// exit("me terminate");
if($count_page_data){
$tab .= " ";
echo "";
if($total_page > 1) :
echo "";
endif;
$current_list = "";
$data_count = 0;
while($data = $db_dpis->get_array()) {
if (($data[ORG_ID]!=$START_ORG_ID && $data[ORG_ID]!=0 && $data[ORG_ID]!=1) || $START_ORG_ID==$SESS_ORG_ID) { //---ไม่เอา parent
$data_count++;
if($data_count > $data_per_page) break;
$cmd = " select ORG_ID from $ORGTAB where ORG_ID_REF=". $data[ORG_ID];
// echo "$cmd
";
$count_sub_tree = $db_dpis2->send_cmd($cmd);
$class = "table_body";
if ($data[ORG_ID] == $sel_org_id) $class = "table_body_over";
$current_list .= ((trim($current_list))?",":"") . $data[ORG_ID];
$tclass = "table_body";
if(!$count_sub_tree) {
$icon_name = "";
$onClick = "";
} else {
$icon_name = "icon_plus.gif";
$onClick = "select_org(". $data[ORG_ID] .");";
if ($SEL_ORG_ID==$data[ORG_ID]) {
$icon_name = "icon_minus.gif";
$tclass = "table_body_over2";
} // end if
}
if ($data[ORG_ACTIVE]==0) {
$font_red1 = ""; $font_red2 = "";
} else {
$font_red1 = ""; $font_red2 = "";
}
echo "";
echo " $tab![](\"images/$icon_name\") ";
echo " ".$font_red1. $data[ORG_NAME] .$font_red2." ";
echo " ";
echo " ";
if ($MFA_FLAG==1 || $BKK_FLAG==1 || $RTF_FLAG==1) {
echo " ";
}
echo " ";
echo " | ";
} // end if ($data[ORG_ID]!=$START_ORG_ID)
} // end while
echo " ";
if($total_page > 1) :
echo "";
endif; echo " ";
} // end if($count_page_data)
} else {
echo "| ไม่พบข้อมูลโครงสร้างที่ต้องการ | ";
} // end if ($count_data)
?>
|