;"> = '$temp_start' and COM_DATE <= '$temp_end')"; } elseif(trim($search_comdate_start) && !trim($search_comdate_end)) { $temp_start = (substr($search_comdate_start, 6, 4) - 543) ."-". substr($search_comdate_start, 3, 2) ."-". substr($search_comdate_start, 0, 2); $arr_search_condition[] = "(COM_DATE >= '$temp_start')"; } elseif(!trim($search_comdate_start) && trim($search_comdate_end)) { $temp_end = (substr($search_comdate_end, 6, 4) - 543) ."-". substr($search_comdate_end, 3, 2) ."-". substr($search_comdate_end, 0, 2); $arr_search_condition[] = "(COM_DATE <= '$temp_end')"; } $search_condition_bkk_department = ""; if ($BKK_FLAG==1){ $search_condition_bkk_department = " or a.DEPARTMENT_ID IS NULL"; } if($search_department_id){ $arr_search_condition[] = "(a.DEPARTMENT_ID = $search_department_id)"; }elseif($search_ministry_id){ $cmd = " select ORG_ID from PER_ORG where ORG_ID_REF=$search_ministry_id "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_org[] = $data[ORG_ID]; $arr_search_condition[] = "(a.DEPARTMENT_ID in (". implode(",", $arr_org) .") $search_condition_bkk_department )"; }elseif($PV_CODE){ $cmd = " select distinct ORG_ID_REF from PER_ORG where OL_CODE='03' and PV_CODE='$PV_CODE' "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_org[] = $data[ORG_ID_REF]; $arr_search_condition[] = "(a.DEPARTMENT_ID in (". implode(",", $arr_org) .") $search_condition_bkk_department )"; } // end if $search_condition = ""; if(count($arr_search_condition)) $search_condition = " and " . implode(" and ", $arr_search_condition); if ($COM_SITE == "personal_workflow" && $SESS_USERGROUP_LEVEL < 5) { // เรียกจาก personal_workflow และ ส่วนกลางเป็นผู้เรียกดู if ($ORG_ID && $ORG_ID!="NULL") { // มี ORG_ID $search_org = "and ORG_ID = $ORG_ID and COM_STATUS='S'"; } else { $search_org = "and ORG_ID > 0 and COM_STATUS='S'"; } } else if ($COM_SITE != "personal_workflow" && $SESS_USERGROUP_LEVEL < 5) { // เรียกจากโปรแกรมอื่น ๆ ส่วนกลางเป็นผู้เรียกดู if ($ORG_ID && $ORG_ID!="NULL") { // มี ORG_ID $search_org = "and ORG_ID = $ORG_ID and COM_STATUS='S'"; } elseif ($search_org_id && $search_org_id!="NULL") { $search_org = "and ORG_ID=$search_org_id"; } else { if($command=="SEARCH"){ $search_org = ""; // เพื่อให้ขึ้นทั้งที่ใส่สำนักกองมา และไม่ใส่มา // $search_org = "and (ORG_ID=0 or ORG_ID is NULL or (ORG_ID >0 and COM_STATUS='S'))"; }else{ //แสดงทั้งหมด command=="" $search_org = ""; } } } else { // เรียกดู ข้อมูลตาม ที่เลือก if ($ORG_ID && $ORG_ID!="NULL") { // มี ORG_ID $search_org = "and ORG_ID=$ORG_ID"; } elseif ($search_org_id && $search_org_id!="NULL") { $search_org = "and ORG_ID=$search_org_id"; } else { $search_org = "and (ORG_ID=0 or ORG_ID is NULL or (ORG_ID >0 and COM_STATUS='S'))"; } } if ($COM_TYPE_NM=="เลื่อนเงินเดือน") { $search_com_type="and a.COM_TYPE <> '5240' and a.COM_TYPE <> '9999'"; } elseif ($COM_TYPE_NM=="ปรับอัตราเงินเดือนใหม่") { $search_com_type="and a.COM_TYPE in ('5240','9999')"; } elseif ($search_com_type) { $search_com_type="and a.COM_TYPE='$search_com_type'"; } else { $search_com_type=""; } $cmd = " select COM_ID from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE $search_condition $search_org $search_com_type "; //echo "=> $cmd"; $count_data_dtl = $db_dpis->send_cmd($cmd); $total_page = ceil( $count_data_dtl / $data_per_page ); $page_link_dtl = create_link_page_data($total_page, $current_page,'form0'); ?>

:   :   :       :  >  :   :  >    :  >     :  $value){ ?> >

 

พบทั้งสิ้น รายการ

1){ $limit_data = " and COM_ID not in (select top $start_record COM_ID from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE order by COM_DATE) "; } // end if $cmd = " select top $data_per_page COM_ID, COM_NO, a.COM_NAME, COM_DATE, a.COM_TYPE, COM_CONFIRM, COM_STATUS, ORG_ID, COM_PER_TYPE from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE $search_condition $search_org $search_com_type $limit_data order by $order_str "; }elseif($DPISDB=="oci8"){ $rec_start = (($current_page-1) * $data_per_page) + 1; $rec_end = ($current_page > 1)? ($current_page * $data_per_page) : $data_per_page; $cmd = "select * from ( select rownum rnum, q1.* from ( select COM_ID, COM_NO, a.COM_NAME, COM_DATE, a.COM_TYPE, COM_CONFIRM, COM_STATUS, ORG_ID, COM_PER_TYPE from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE $search_condition $search_org $search_com_type order by $order_str ) q1 ) where rnum between $rec_start and $rec_end "; }elseif($DPISDB=="mysql"){ $cmd = " select COM_ID, COM_NO, a.COM_NAME, COM_DATE, a.COM_TYPE, COM_CONFIRM, COM_STATUS, ORG_ID, COM_PER_TYPE from PER_COMMAND a, PER_COMTYPE b where COM_GROUP in ($COM_GROUP_IN) and a.COM_TYPE=b.COM_TYPE $search_condition $search_org $search_com_type order by $order_str $limit_data "; } // end if $count_page_data = $db_dpis->send_cmd($cmd); // echo "($search_org_id || $ORG_ID ) $SESS_USERGROUP_LEVEL >>> $count_page_data ->".$cmd."
"; // echo "$cmd"; // $db_dpis->show_error(); if ($count_page_data) { ?> = 5) { ?> get_array()) { $data_count++; $data_num++; if($data_count > $data_per_page) break; $TMP_COM_ID = $data[COM_ID]; $current_list .= ((trim($current_list))?",":"") . $TMP_COM_ID; $TMP_COM_NO = trim($data[COM_NO]); $TMP_COM_NAME = trim($data[COM_NAME]); $TMP_COM_DATE = show_date_format($data[COM_DATE], 1); $TMP_COM_CONFIRM = trim($data[COM_CONFIRM]); $TMP_COM_STATUS = trim($data[COM_STATUS]); $TMP_ORG_ID = $data[ORG_ID]; if ($TMP_ORG_ID > 0) { $cmd = "select ORG_NAME from PER_ORG where ORG_ID=$TMP_ORG_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_ORG_NAME = trim($data2[ORG_NAME]); } else { $TMP_ORG_NAME = ""; } $TMP_COM_PER_TYPE = $data[COM_PER_TYPE]; $TMP_COM_TYPE = trim($data[COM_TYPE]); $TMP_COM_TYPE_NAME = ""; $cmd = "select COM_DESC from PER_COMTYPE where COM_TYPE='$TMP_COM_TYPE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_COM_TYPE_NAME = trim($data2[COM_DESC]); $cmd = "select count(COM_ID) as COUNT_COMDTL from PER_COMDTL where COM_ID=$TMP_COM_ID "; $count_comdtl = $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_COUNT_COMDTL = trim($data2[COUNT_COMDTL]); $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($COM_ID==$TMP_COM_ID){ $class = "table_body_over"; $onmouse_event = ""; } // end if ?> > "; //นับจำนวนไฟล์ทั้งหมดใน folder $numfiles=0; if ($dh = opendir($FILE_PATH)) { while (($file = readdir($dh)) !== false) { //---อ่านไฟล์ทั้งหมดมาจาก folder ($FILE_PATH) นั้น if ($file != "." && $file != "..") { $numfiles++; } // end if } // while loop readdir closedir($dh); } // end if // echo "numfiles=$numfiles
"; ?> = 5 && $TMP_COM_STATUS=="S"))) { echo ""; } else { ?> = 5 && $TMP_COM_STATUS=="S"))) { echo ""; } else {?>

()

= 5 && $TMP_COM_STATUS=="S") { ?> = 5) { ?>

">

">

-

">

-

">

1) : ?>  

"> send_cmd($cmd); //$db_dpis->show_error(); $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page_data($total_page, $current_page,'form11'); } $limit_data = ""; ?>

*  :  *  :   :   *  :  $value){ ?>> เงื่อนไข :  >  ใช้ในการปรับอัตราเงินเดือน % ตามมติ ครม.ที่มีผล >  >  ใช้ในการปรับตามคุณวุฒิ ชดเชยให้ข้าราชการที่บรรจุก่อนวันที่ 1 ม.ค. 2555 >  ใช้ในการปรับอัตราเงินเดือนข้าราชการ วันที่ 1 ธ.ค. 2557 (ระดับปฏิบัติงาน ชำนาญงาน ปฏิบัติการ ชำนาญการ และผู้ที่ได้รับเงินตอบแทนพิเศษทุกระดับตำแหน่ง) และการปรับอัตราค่าจ้างลูกจ้างประจำ *  :  " style="width:80%" class="textbox" >  :  >  :  " style="width:100%" class="textbox" > *  :   :  ><?=$COM_NOTE?>  :  send_cmd($cmd); while($data = $db_dpis->get_array()){ $TMP_LEVEL_NO = $data[LEVEL_NO]; $TMP_LEVEL_NAME = $data[LEVEL_NAME]; if (in_array($TMP_LEVEL_NO, $COM_LEVEL_NO)) $selected_str = "selected"; else $selected_str = ""; ?> >     :   :  = 5 && $COM_STATUS != "S"))){?> ');" value="" title="ลบบัญชีแนบท้ายคำสั่ง"> ');"> = 5 && $COM_STATUS != "S") { ?>   = 5 && $COM_STATUS=="S") { ?>

   

:      :

>เลขอารบิค >เลขไทย $value){ ?> > พบข้อมูลทั้งสิ้น รายการ  : >  >  "> >พิมพ์เลขที่บัตรต่อจากชื่อ

บัญชีเงินเดือนไม่ถูกต้อง (ต้องใช้บัญชี ๖ มิ.ย. ๒๕๕๔ โดยเข้าไปที่เมนู M0401 บัญชีอัตราเงินเดือน แล้วกดปุ่ม ปรับบัญชีข้าราชการ ๖ มิ.ย. ๒๕๕๔)

$tmp2 "; }elseif($DPISDB=="mysql"){ $cmd = " select a.PER_ID, b.PN_CODE, PER_NAME, PER_SURNAME, CMD_POSITION, CMD_ORG2, CMD_ORG3, a.CMD_LEVEL, a.CMD_OLD_SALARY, a.CMD_SALARY, CMD_SEQ, CMD_NOTE1, PER_STATUS, b.MOV_CODE from PER_COMDTL a inner join PER_PERSONAL b on (a.PER_ID=b.PER_ID) left join $position_table c on ($position_join) left join PER_ORG d on (c.ORG_ID=d.ORG_ID) left join PER_ORG e on (c.ORG_ID_1=e.ORG_ID) where a.COM_ID=$COM_ID $search_condition_dtl order by d.ORG_SEQ_NO, e.ORG_SEQ_NO, a.CMD_POS_NO_NAME, a.CMD_POS_NO, PER_NAME, PER_SURNAME "; } // end if $count_page_data = $db_dpis->send_cmd($cmd); //echo "$cmd
"; //$db_dpis->show_error(); } if ($count_page_data) { ?> get_array()) { $data_count++; $data_num++; if($data_count > $data_per_page) break; $TMP_PER_ID= $data[PER_ID]; $current_list .= ((trim($current_list))?",":"") . $TMP_PER_ID; $TMP_CMD_SEQ = $data[CMD_SEQ]; $TMP_PER_NAME = $data[PER_NAME] ." ". $data[PER_SURNAME]; $TMP_PER_STATUS = $data[PER_STATUS]; $TMP_MOV_CODE = $data[MOV_CODE]; if($DPISDB=="mysql"){ $temp_pos = explode("|", trim($data[CMD_POSITION])); }else{ $temp_pos = explode("\|", trim($data[CMD_POSITION])); } $TMP_PL_NAME = $temp_pos[0]; $TMP_PM_NAME = $temp_pos[1]; $TMP_CMD_LEVEL = trim($data[CMD_LEVEL]); $cmd = " select LEVEL_NAME, POSITION_LEVEL from PER_LEVEL where LEVEL_NO='$TMP_CMD_LEVEL' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_LEVEL_NAME = $data2[LEVEL_NAME]; $POSITION_LEVEL = $data2[POSITION_LEVEL]; if (!$POSITION_LEVEL) $POSITION_LEVEL = $TMP_LEVEL_NAME; $TMP_POSITION = pl_name_format($TMP_PL_NAME, $TMP_PM_NAME, $TMP_PT_NAME, $TMP_CMD_LEVEL, 2); $TMP_DEPARTMENT = (trim($data[CMD_ORG2]))? $data[CMD_ORG2] : "-" ; $TMP_ORG = (trim($data[CMD_ORG3]))? $data[CMD_ORG3] : "-" ; $TMP_OLD_SALARY = number_format($data[CMD_OLD_SALARY],2); $TMP_SALARY = number_format($data[CMD_SALARY],2); $TMP_CMD_NOTE1 = $data[CMD_NOTE1]; $TMP_EXTRA_SALARY = ""; if ($TMP_CMD_NOTE1) { $TMP_OLD_SALARY = "*".$TMP_OLD_SALARY; $arr_temp = explode("เงินตอบแทนพิเศษ ", $TMP_CMD_NOTE1); if ($arr_temp[1] > "0.00") $TMP_EXTRA_SALARY = $arr_temp[1]; else $TMP_OLD_SALARY = "**".$TMP_OLD_SALARY; } $PN_CODE = trim($data[PN_CODE]); $cmd = " select PN_NAME from PER_PRENAME where PN_CODE='$PN_CODE' "; $db_dpis1->send_cmd($cmd); $data1 = $db_dpis1->get_array(); $PN_NAME = trim($data1[PN_NAME]); $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($PER_ID==$TMP_PER_ID){ $class = "table_body_over"; $onmouse_event = ""; } // end if $curstyle=""; if($TMP_PER_STATUS == 2){ //พ้นจากส่วนราชการ if(trim($curstyle)) $curstyle .= ";"; $cmd = " select MOV_SUB_TYPE from PER_MOVMENT where MOV_CODE='$TMP_MOV_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $MOV_SUB_TYPE = $data2[MOV_SUB_TYPE]; if ($MOV_SUB_TYPE=="91") $curstyle.="color:#800080"; else $curstyle.="color:#FF0000"; } // end if ?> > = 5)) { echo ""; } else { ?> = 5)) { echo ""; } else {?>

(เดิม)

ค่าตอบแทนพิเศษ

(ใหม่)

">

-

">

-

">

1) : ?>