send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_org[] = $data[ORG_ID]; $arr_search_condition[] = "(b.DEPARTMENT_ID in (". implode(",", $arr_org) ."))"; } // end if if(trim($search_vc_year)) $arr_search_condition[] = "(a.VC_YEAR = '$search_vc_year')"; if(trim($search_per_name)) $arr_search_condition[] = "(b.PER_NAME like '$search_per_name%')"; if(trim($search_per_surname)) $arr_search_condition[] = "(b.PER_SURNAME like '$search_per_surname%')"; if(trim($search_per_type)) $arr_search_condition[] = "(b.PER_TYPE = $search_per_type)"; $search_condition = ""; if($DPISDB=="odbc"){ if(count($arr_search_condition)) $search_condition = " where " . implode(" and ", $arr_search_condition); } else { if(count($arr_search_condition)) $search_condition = " and " . implode(" and ", $arr_search_condition); } $cmd =" select count(a.PER_ID) as count_data from PER_VACATION a, PER_PERSONAL b, PER_POSITION c, PER_POS_EMP d, PER_POS_EMPSER e, PER_LEVEL f, PER_POS_TEMP g where a.PER_ID=b.PER_ID and b.POS_ID=c.POS_ID(+) and b.POEM_ID=d.POEM_ID(+) and b.POEMS_ID=e.POEMS_ID(+) and b.LEVEL_NO=f.LEVEL_NO(+) and b.POT_ID=g.POT_ID(+) $search_condition "; $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); $data = $db_dpis->get_array(); $data = array_change_key_case($data, CASE_LOWER); $count_data = $data[count_data]; // echo "$count_data - $cmd"; ?>
:
:
:
onClick="form1.search_org_id.value='';form1.search_org_name.value='';">
onClick="form1.search_org_id.value='';form1.search_org_name.value='';">
:
:
$value){ ?>
>
:
:
พบข้อมูลทั้งสิ้น รายการ
1){ if($DPISDB=="odbc"){ $cmd = " select top $start_record a.AS_ID from ( ( ( ( ( PER_VACATION a inner join PER_PERSONAL b on (a.PER_ID=b.PER_ID) ) left join PER_POSITION c on (b.POS_ID=c.POS_ID) ) left join PER_POS_EMP d on (b.POEM_ID=d.POEM_ID) ) left join PER_POS_EMPSER e on (b.POEMS_ID=e.POEMS_ID) ) left join PER_LEVEL f on (b.LEVEL_NO=f.LEVEL_NO) ) left join PER_POS_TEMP g on (b.POT_ID=g.POT_ID) $search_condition order by $order_str "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_exclude[] = $data[AS_ID]; $limit_data = " and a.AS_ID not in (". implode(", ", $arr_exclude) .")"; }elseif($DPISDB=="mysql"){ $limit_data = " limit " . (($current_page - 1) * $data_per_page) . ", " . $data_per_page; } // end if } // end if if($DPISDB=="odbc"){ $cmd = " select top $data_per_page a.VC_YEAR, a.PER_ID, a.VC_DAY, b.PN_CODE, b.PER_NAME, b.PER_SURNAME, b.ORG_ID as ORG_ID_ASS, b.PER_STATUS from ( ( ( ( ( PER_VACATION a left join PER_PERSONAL b on (a.PER_ID=b.PER_ID) ) left join PER_POSITION c on (b.POS_ID=c.POS_ID) ) left join PER_POS_EMP d on (b.POEM_ID=d.POEM_ID) ) left join PER_POS_EMPSER e on (b.POEMS_ID=e.POEMS_ID) ) left join PER_LEVEL f on (b.LEVEL_NO=f.LEVEL_NO) ) left join PER_POS_TEMP g on (b.POT_ID=g.POT_ID) $search_condition $limit_data order by $order_str "; }elseif($DPISDB=="oci8"){ $min_rownum = (($current_page - 1) * $data_per_page) + 1; $max_rownum = $current_page * $data_per_page; $cmd = "select temp2.* from ( select rownum as rnum, temp1.* from ( select a.VC_YEAR, a.PER_ID, a.VC_DAY, b.PN_CODE, b.PER_NAME, b.PER_SURNAME, b.ORG_ID as ORG_ID_ASS, b.PER_STATUS from PER_VACATION a, PER_PERSONAL b, PER_POSITION c, PER_POS_EMP d, PER_POS_EMPSER e, PER_LEVEL f, PER_POS_TEMP g where a.PER_ID=b.PER_ID and b.POS_ID=c.POS_ID(+) and b.POEM_ID=d.POEM_ID(+) and b.POEMS_ID=e.POEMS_ID(+) and b.LEVEL_NO=f.LEVEL_NO(+) and b.POT_ID=g.POT_ID(+) $search_condition order by $order_str ) temp1 where rownum <= $max_rownum ) temp2 where rnum between $min_rownum and $max_rownum "; }elseif($DPISDB=="mysql"){ $cmd = " select a.VC_YEAR, a.PER_ID, a.VC_DAY, b.PN_CODE, b.PER_NAME, b.PER_SURNAME, b.ORG_ID as ORG_ID_ASS, b.PER_STATUS from ( ( ( ( ( PER_VACATION a inner join PER_PERSONAL b on (a.PER_ID=b.PER_ID) ) left join PER_POSITION c on (b.POS_ID=c.POS_ID) ) left join PER_POS_EMP d on (b.POEM_ID=d.POEM_ID) ) left join PER_POS_EMPSER e on (b.POEMS_ID=e.POEMS_ID) ) left join PER_LEVEL f on (b.LEVEL_NO=f.LEVEL_NO) ) left join PER_POS_TEMP g on (b.POT_ID=g.POT_ID) $search_condition order by $order_str $limit_data "; } // end if $count_page_data = $db_dpis->send_cmd($cmd); // echo "$cmd"; // $db_dpis->show_error(); if ($count_page_data) { ?>
ตามกฎหมาย
ตามมอบหมายงาน
วันลาพักผ่อน
get_array()) { $data_count++; if($data_count > $data_per_page) break; $TMP_PER_ID = $data[PER_ID]; $current_list .= ((trim($current_list))?",":"") . $TMP_PER_ID; $VC_YEAR = $data[VC_YEAR]; $PER_ID = $data[PER_ID]; $PN_CODE = $data[PN_CODE]; $PER_NAME = trim($data[PER_NAME]); $PER_SURNAME = trim($data[PER_SURNAME]); $PER_STATUS = trim($data[PER_STATUS]); $VC_DAY = number_format($data[VC_DAY],1); $ORG_ID_ASS = $data[ORG_ID_ASS]; $cmd = " select PN_NAME from PER_PRENAME where PN_CODE='$PN_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $PN_NAME = $data2[PN_NAME]; $PER_FULLNAME = $PN_NAME . $PER_NAME . " " . $PER_SURNAME; $cmd = " select LEVEL_NO, PER_TYPE, POS_ID, POEM_ID, POEMS_ID, POT_ID from PER_PERSONAL where PER_ID=$PER_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $LEVEL_NO = trim($data2[LEVEL_NO]); $PER_TYPE = $data2[PER_TYPE]; $POS_ID = $data2[POS_ID]; $POEM_ID = $data2[POEM_ID]; $POEMS_ID = $data2[POEMS_ID]; $POT_ID = $data2[POT_ID]; $cmd = " select POSITION_LEVEL from PER_LEVEL where LEVEL_NO='$LEVEL_NO' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $LEVEL_NAME = trim($data2[POSITION_LEVEL]); if($PER_TYPE == 1){ $cmd = " select a.ORG_ID, d.ORG_NAME, b.PL_NAME, a.PT_CODE, POS_NO_NAME, POS_NO from PER_POSITION a, PER_LINE b, PER_ORG d where a.POS_ID=$POS_ID and a.PL_CODE=b.PL_CODE and a.ORG_ID=d.ORG_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_ORG_NAME = trim($data2[ORG_NAME]); $PL_NAME = trim($data2[PL_NAME])?($data2[PL_NAME] ."". level_no_format($LEVEL_NAME) . ((trim($data2[PT_NAME]) != "ทั่วไป" && $LEVEL_NO >= 6)?"$data2[PT_NAME]":"")):" ".level_no_format($LEVEL_NAME); $POS_NO_NAME = trim($data2[POS_NO_NAME]); if (substr($POS_NO_NAME,0,4)=="กปด.") $POS_NO = $POS_NO_NAME." ".trim($data2[POS_NO]); else $POS_NO = $POS_NO_NAME.trim($data2[POS_NO]); }elseif($PER_TYPE == 2){ $cmd = " select pl.PN_NAME, po.ORG_NAME, POEM_NO_NAME, POEM_NO from PER_POS_EMP pp, PER_POS_NAME pl, PER_ORG po where pp.POEM_ID=$POEM_ID and pp.ORG_ID=po.ORG_ID and pp.PN_CODE=pl.PN_CODE "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $PL_NAME = trim($data2[PN_NAME]); $TMP_ORG_NAME = trim($data2[ORG_NAME]); $PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : ""; $POS_NO = trim($data2[POEM_NO_NAME]).trim($data2[POEM_NO]); }elseif($PER_TYPE == 3){ $cmd = " select pl.EP_NAME, po.ORG_NAME, POEMS_NO_NAME, POEMS_NO from PER_POS_EMPSER pp, PER_EMPSER_POS_NAME pl, PER_ORG po where pp.POEMS_ID=$POEMS_ID and pp.ORG_ID=po.ORG_ID and pp.EP_CODE=pl.EP_CODE "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $PL_NAME = trim($data2[EP_NAME]); $TMP_ORG_NAME = trim($data2[ORG_NAME]); $PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : ""; $POS_NO = trim($data2[POEMS_NO_NAME]).trim($data2[POEMS_NO]); }elseif($PER_TYPE == 4){ $cmd = " select pl.TP_NAME, po.ORG_NAME, POT_NO_NAME, POT_NO from PER_POS_TEMP pp, PER_TEMP_POS_NAME pl, PER_ORG po where pp.POT_ID=$POT_ID and pp.ORG_ID=po.ORG_ID and pp.TP_CODE=pl.TP_CODE "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $PL_NAME = trim($data2[TP_NAME]); $TMP_ORG_NAME = trim($data2[ORG_NAME]); $PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : ""; $POS_NO = trim($data2[POT_NO_NAME]).trim($data2[POT_NO]); } // end if $cmd = " select ORG_NAME from PER_ORG_ASS where ORG_ID=$ORG_ID_ASS "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_ORG_NAME_ASS = trim($data2[ORG_NAME]); $UPDATE_USER = $data[UPDATE_USER]; $cmd ="select TITLENAME, FULLNAME from USER_DETAIL where id = $UPDATE_USER "; $db->send_cmd($cmd); $data2 = $db->get_array(); $SHOW_UPDATE_USER = trim($data2[TITLENAME]) . trim($data2[FULLNAME]); $SHOW_UPDATE_DATE = show_date_format($data[UPDATE_DATE], 1); unset($ARR_USER_AUTH); if(trim($data[PER_ID])) $ARR_USER_AUTH[] = $data[PER_ID]; $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($AS_ID==$TMP_PER_ID){ $class = "table_body_over"; $onmouse_event = ""; } // end if ?>
>
>
">
1) : ?>