"; $db_dpis2 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd); $db_dpis3 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd); $per_list = explode(",",$SELECTED_PER_ID); $PER_ID = $per_list[0]; $search_condition = ""; // $arr_search_condition[] = "(a.PER_TYPE in (". implode(", ", $search_per_type) ."))"; $arr_search_condition[] = "(a.PER_TYPE in ($search_per_type))"; $MINISTRY_NAME = ""; if($MINISTRY_ID){ $cmd = " select ORG_NAME from PER_ORG where ORG_ID = $MINISTRY_ID "; $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $MINISTRY_NAME = trim($data[ORG_NAME]); } $DEPARTMENT_NAME = ""; if($DEPARTMENT_ID){ $cmd = " select ORG_NAME from PER_ORG where ORG_ID = $DEPARTMENT_ID "; $db_dpis->send_cmd($cmd); $data = $db_dpis->get_array(); $DEPARTMENT_NAME = trim($data[ORG_NAME]); } if($DEPARTMENT_ID){ $arr_search_condition[] = "(a.DEPARTMENT_ID = $DEPARTMENT_ID)"; } elseif($MINISTRY_ID){ unset($arr_department); $cmd = " select ORG_ID from PER_ORG where ORG_ID_REF=$MINISTRY_ID and OL_CODE='02' "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_department[] = $data[ORG_ID]; $arr_search_condition[] = "(a.DEPARTMENT_ID in (". implode(",", $arr_department) ."))"; } elseif($PROVINCE_CODE){ $cmd = " select ORG_ID from PER_ORG where PV_CODE='$PROVINCE_CODE' and OL_CODE='02' "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_department[] = $data[ORG_ID]; $arr_search_condition[] = "(a.DEPARTMENT_ID in (". implode(",", $arr_department) ."))"; } // end if // if(!trim($select_org_structure)){ if(trim($search_org_id)) $arr_search_condition[] = "(c.ORG_ID = $search_org_id or d.ORG_ID = $search_org_id)"; if(trim($search_org_id_1)) $arr_search_condition[] = "(c.ORG_ID_1 = $search_org_id_1 or d.ORG_ID_1 = $search_org_id_1)"; if(trim($search_org_id_2)) $arr_search_condition[] = "(c.ORG_ID_2 = $search_org_id_2 or d.ORG_ID_2 = $search_org_id_2)"; // } if($list_type == "SELECT"){ // if($SELECTED_PER_ID) { $arr_search_condition[] = "(a.PER_ID in ($SELECTED_PER_ID))"; } if($PER_ID) { $arr_search_condition[] = "(a.PER_ID = $PER_ID)"; } }elseif($list_type == "CONDITION"){ if(trim($search_pos_no)) $arr_search_condition[] = "(trim(c.POS_NO)='$search_pos_no' or trim(d.POEM_NO)='$search_pos_no' or trim(e.POEMS_NO)='$search_pos_no')"; if(trim($search_name)) $arr_search_condition[] = "(a.PER_NAME like '$search_name%')"; if(trim($search_surname)) $arr_search_condition[] = "(a.PER_SURNAME like '$search_surname%')"; if(trim($search_min_level)){ if($DPISDB=="odbc") $arr_search_condition[] = "(trim(a.LEVEL_NO) >= '". str_pad($search_min_level, 2, "0", STR_PAD_LEFT) ."')"; if($DPISDB=="oci8") $arr_search_condition[] = "(trim(a.LEVEL_NO) >= '". str_pad($search_min_level, 2, "0", STR_PAD_LEFT) ."')"; if($DPISDB=="mysql") $arr_search_condition[] = "(trim(a.LEVEL_NO) >= '". str_pad($search_min_level, 2, "0", STR_PAD_LEFT) ."')"; } if(trim($search_max_level)){ if($DPISDB=="odbc") $arr_search_condition[] = "(trim(a.LEVEL_NO) <= '". str_pad($search_max_level, 2, "0", STR_PAD_LEFT) ."')"; if($DPISDB=="oci8") $arr_search_condition[] = "(trim(a.LEVEL_NO) <= '". str_pad($search_max_level, 2, "0", STR_PAD_LEFT) ."')"; if($DPISDB=="mysql") $arr_search_condition[] = "(trim(a.LEVEL_NO) <= '". str_pad($search_max_level, 2, "0", STR_PAD_LEFT) ."')"; } $arr_search_condition[] = "(a.PER_STATUS in (". implode(",", $search_per_status) ."))"; }else if($list_type == "ELECTRONICS"){ //ก.พ.7 อิเล็กทรอนิกส์ // if(trim($SELECTED_PER_ID)){ $arr_search_condition[] = "(a.PER_ID in ($SELECTED_PER_ID))"; } if($PER_ID) { $arr_search_condition[] = "(a.PER_ID = $PER_ID)"; } } // end if if(count($arr_search_condition)) $search_condition = " where ". implode(" and ", $arr_search_condition); ?>

"; $count_data = $db_dpis->send_cmd($cmd); // $db_dpis->show_error(); if($count_data > 0){ $data_count = 0; while($data = $db_dpis->get_array()){ $data_count++; $PER_ID = $data[PER_ID]; $PER_TYPE = $data[PER_TYPE]; if($PER_TYPE==1){ $POS_ID = $data[POS_ID]; $POS_NO = trim($data[POS_NO_NAME]).trim($data[POS_NO]); $PL_CODE = trim($data[PL_CODE]); $PT_CODE = trim($data[PT_CODE]); $ORG_ID = $data[ORG_ID]; $ORG_ID_1 = $data[ORG_ID_1]; $ORG_ID_2 = $data[ORG_ID_2]; $cmd = " select PL_NAME from PER_LINE where trim(PL_CODE) = '$PL_CODE' "; $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); $PL_NAME = trim($data2[PL_NAME]); $cmd = " select PT_NAME from PER_TYPE where trim(PT_CODE) = '$PT_CODE' "; $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); $PT_NAME = trim($data2[PT_NAME]); }elseif($PER_TYPE==2){ $POS_ID = $data[POEM_ID]; $POS_NO = trim($data[POEM_NO_NAME]).trim($data[POEM_NO]); $PL_CODE = trim($data[EMP_PL_CODE]); $ORG_ID = $data[EMP_ORG_ID]; $ORG_ID_1 = $data[EMP_ORG_ID_1]; $ORG_ID_2 = $data[EMP_ORG_ID_2]; $cmd = " select PN_NAME from PER_POS_NAME where trim(PN_CODE) = '$PL_CODE' "; $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); $PL_NAME = trim($data2[PN_NAME]); }elseif($PER_TYPE==3){ $POS_ID = $data[POEMS_ID]; $POS_NO = trim($data[POEMS_NO_NAME]).trim($data[POEMS_NO]); $PL_CODE = trim($data[EMPSER_PL_CODE]); $ORG_ID = $data[EMPSER_ORG_ID]; $ORG_ID_1 = $data[EMPSER_ORG_ID_1]; $ORG_ID_2 = $data[EMPSER_ORG_ID_2]; $cmd = " select EP_NAME from PER_EMPSER_POS_NAME where trim(EP_CODE) = '$PL_CODE' "; $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); $PL_NAME = trim($data2[EP_NAME]); } // ข้อมูลประเภทข้าราชการ $OT_CODE = trim($data[OT_CODE]); $cmd = " select OT_NAME from PER_OFF_TYPE where trim(OT_CODE)='$OT_CODE' "; $db_dpis2->send_cmd($cmd); $data_dpis2 = $db_dpis2->get_array(); $OT_NAME = trim($data_dpis2[OT_NAME]); $ORG_NAME = ""; if($ORG_ID){ $cmd = " select ORG_NAME from PER_ORG where ORG_ID = $ORG_ID "; $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); $ORG_NAME = trim($data2[ORG_NAME]); } $ORG_NAME_1 = ""; if($ORG_ID_1){ $cmd = " select ORG_NAME from PER_ORG where ORG_ID = $ORG_ID_1 "; $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); $ORG_NAME_1 = trim($data2[ORG_NAME]); } $ORG_NAME_2 = ""; if($ORG_ID_2){ $cmd = " select ORG_NAME from PER_ORG where ORG_ID = $ORG_ID_2 "; $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); $ORG_NAME_2 = trim($data2[ORG_NAME]); } $LEVEL_NO = trim($data[LEVEL_NO]); $FULL_LEVEL_NAME = trim($data[LEVEL_NAME]); $PN_NAME = trim($data[PN_NAME]); $PER_NAME = trim($data[PER_NAME]); $PER_SURNAME = trim($data[PER_SURNAME]); $FULLNAME = ($PN_NAME)."$PER_NAME $PER_SURNAME"; $PER_CARDNO = $data[PER_CARDNO]; $img_file = ""; if($PER_CARDNO && file_exists($IMG_PATH.$PER_CARDNO.".jpg")) $img_file = $IMG_PATH.$PER_CARDNO.".jpg"; $PER_BIRTHDATE = show_date_format($data[PER_BIRTHDATE], 3); $PER_RETIREDATE = show_date_format($data[PER_RETIREDATE], 3); $PER_SALARY = $data[PER_SALARY]; $PER_MGTSALARY = $data[PER_MGTSALARY]; //วันบรรจุ $PER_STARTDATE = show_date_format($data[PER_STARTDATE], 3); //วันที่เข้าส่วนราชการ $PER_OCCUPYDATE = show_date_format($data[PER_OCCUPYDATE], 3); ?> ใบต่อ ของ [] send_cmd($cmd); // $db_dpis2->show_error(); if($count_positionhis){ $positionhis_count = 0; while($data2 = $db_dpis2->get_array()){ $positionhis_count++; $POH_EFFECTIVEDATE = trim(substr($data2[POH_EFFECTIVEDATE],0,10)); $POH_EFFECTIVEDATE = ($POH_EFFECTIVEDATE?$POH_EFFECTIVEDATE:"-"); $LEVEL_NO = trim($data2[LEVEL_NO]); $POSITION_LEVEL = trim($data2[POSITION_LEVEL]); if ($POSITION_LEVEL=="ชำนาญการพิเศษ") { $POSITION_LEVEL = "ชำนาญการ"."\n"."พิเศษ"; // $testpos = str_replace("\n"," ",$POSITION_LEVEL); // echo "POSITION_LEVEL=$testpos "; } $POH_SEQ_NO = trim($data2[POH_SEQ_NO]); // if( ("$PM_CODE $PL_NAME $LEVEL_NO $POH_POS_NO") != (trim($data2[PM_CODE])." ".trim($data2[PL_NAME])." ".$LEVEL_NO." ".trim($data2[POH_POS_NO]))){ $PL_NAME = trim($data2[PL_NAME]); $LEVEL_NAME = trim(str_replace("ระดับ","",$data2[LEVEL_NAME])); $PT_CODE = trim($data2[PT_CODE]); $PT_NAME = trim($data2[PT_NAME]); $PM_CODE = trim($data2[PM_CODE]); $PM_NAME = trim($data2[PM_NAME]); $POH_PL_NAME = trim($data2[POH_PL_NAME]); $arr_temp = ""; if (strlen($POH_PL_NAME) > 50) { $arr_temp = explode(" ", $POH_PL_NAME); if ((strlen($arr_temp[0])+strlen($arr_temp[1])+strlen($arr_temp[2])) < 50) $POH_PL_NAME = $arr_temp[0]." ".$arr_temp[1]." ".$arr_temp[2]."\n".$arr_temp[3]." ".$arr_temp[4]." ".$arr_temp[5]." ".$arr_temp[6]." ".$arr_temp[7]; elseif ((strlen($arr_temp[0])+strlen($arr_temp[1])) < 50) $POH_PL_NAME = $arr_temp[0]." ".$arr_temp[1]."\n".$arr_temp[2]." ".$arr_temp[3]." ".$arr_temp[4]." ".$arr_temp[5]." ".$arr_temp[6]." ".$arr_temp[7]; else $POH_PL_NAME = $arr_temp[0]."\n".$arr_temp[1]." ".$arr_temp[2]." ".$arr_temp[3]." ".$arr_temp[4]." ".$arr_temp[5]." ".$arr_temp[6]." ".$arr_temp[7]; } $POH_ORG = trim($data2[POH_ORG]); $arr_temp = ""; if (strlen($POH_ORG) > 50) { $arr_temp = explode(" ", $POH_ORG); $POH_ORG = $arr_temp[0]."\n".$arr_temp[1]." ".$arr_temp[2]." ".$arr_temp[3]." ".$arr_temp[4]." ".$arr_temp[5]; } $TMP_PL_NAME = $POH_PL_NAME."\n".$POH_ORG; //if($PM_CODE && $PM_CODE!="9999") $TMP_PL_NAME = $PM_NAME." ($TMP_PL_NAME)"; // } $TMP_PL_NAME = (trim($TMP_PL_NAME)?trim($TMP_PL_NAME):"-"); $POH_POS_NO = trim($data2[POH_POS_NO_NAME]).trim($data2[POH_POS_NO]); $POH_POS_NO = ($POH_POS_NO?$POH_POS_NO:"-"); $POH_SALARY = number_format($data2[POH_SALARY], ","); $POH_SALARY = ($POH_SALARY?$POH_SALARY:"-"); $POH_DOCNO = (trim($data2[POH_DOCNO]))? $data2[POH_DOCNO] : "-" ; $MOV_CODE = trim($data2[MOV_CODE]); if(trim($data2[POH_DOCNO])){ $POH_DOCDATE = "ลว. ".show_date_format($data2[POH_DOCDATE], 2); $USRNAME = ""; if($data2[UPDATE_USER]){ //ดึงชื่อจาก ตาราง user_detail ของ mysql $cmd1 ="select fullname from user_detail where id=$data2[UPDATE_USER]"; $db->send_cmd($cmd1); //$db->show_error(); $datausr = $db->get_array(); $datausr = array_change_key_case($datausr, CASE_LOWER); $USRNAME = $datausr[fullname]; } if (strpos($data2[POH_DOCNO],"คส.") !== false) $POH_DOCNO = $data2[POH_DOCNO]."\n".$POH_DOCDATE."\n".$USRNAME; else $POH_DOCNO = "คส. ".$data2[POH_DOCNO]."\n".$POH_DOCDATE."\n".$USRNAME; } // end if(trim($data2[POH_DOCNO])) //หาประเภทการเคลื่อนไหวของประวัติการดำรงตำแหน่งข้าราชการ $cmd = " select MOV_NAME from PER_MOVMENT pcd where MOV_CODE='$MOV_CODE' "; $db_dpis3->send_cmd($cmd); //echo " $cmd "; //$db_dpis3->show_error(); $data3 = $db_dpis3->get_array(); $MOV_NAME = $data3[MOV_NAME]; //เก็บลง array ของ POSTION HIS $ARR_POSITIONHIS[$PER_ID][] = array( 'DATE'=>$POH_EFFECTIVEDATE, 'SEQ'=>$POH_SEQ_NO, 'MOVE'=>$MOV_NAME, 'POS_NAME'=>$TMP_PL_NAME, 'POS_NO'=>$POH_POS_NO, 'LEVEL'=>$POSITION_LEVEL, 'SALARY'=>$POH_SALARY, 'DOC_NO'=>$POH_DOCNO ); $ARR_POSCHECK[$PER_ID][DOC_NO][] = $data2[POH_DOCNO]; $ARR_POSCHECK[$PER_ID][DOC_DATE][] = $data2[POH_DOCDATE]; $ARR_POSCHECK[$PER_ID][MOVE_CODE][] = $MOV_CODE; } // end while } //end if //######################## //ประวัติการเลื่อนขั้นเงินเดือน //######################## if($DPISDB=="odbc"){ $cmd = " select LEFT(b.SAH_EFFECTIVEDATE,10) as SAH_EFFECTIVEDATE, c.MOV_NAME, b.SAH_SALARY, b.SAH_DOCNO, b.SAH_DOCDATE,b.UPDATE_USER, b.SAH_SEQ_NO, b.LEVEL_NO, b.SAH_POSITION, b.SAH_ORG, b.SM_CODE, b.SAH_POS_NO_NAME, b.SAH_PAY_NO, b.SAH_REMARK from PER_SALARYHIS b inner join PER_MOVMENT c on b.MOV_CODE=c.MOV_CODE where b.PER_ID=$PER_ID and b.MOV_CODE!='1901' order by b.SAH_SALARY asc, b.SAH_EFFECTIVEDATE asc "; }elseif($DPISDB=="oci8"){ $cmd = " select SUBSTR(b.SAH_EFFECTIVEDATE,1,10) as SAH_EFFECTIVEDATE, c.MOV_NAME, b.SAH_SALARY, b.SAH_DOCNO, b.SAH_DOCDATE,b.UPDATE_USER, b.SAH_SEQ_NO, b.LEVEL_NO, b.SAH_POSITION, b.SAH_ORG, b.SM_CODE, b.SAH_POS_NO_NAME, b.SAH_PAY_NO, b.SAH_REMARK from PER_SALARYHIS b, PER_MOVMENT c where b.PER_ID=$PER_ID and b.MOV_CODE=c.MOV_CODE and b.MOV_CODE!='1901' order by b.SAH_SALARY asc, b.SAH_EFFECTIVEDATE asc "; } elseif($DPISDB=="mysql"){ $cmd = " select LEFT(b.SAH_EFFECTIVEDATE,10) as SAH_EFFECTIVEDATE, c.MOV_NAME, b.SAH_SALARY, b.SAH_DOCNO, b.SAH_DOCDATE,b.UPDATE_USER, b.SAH_SEQ_NO, b.LEVEL_NO, b.SAH_POSITION, b.SAH_ORG, b.SM_CODE, b.SAH_POS_NO_NAME, b.SAH_PAY_NO, b.SAH_REMARK from PER_SALARYHIS b inner join PER_MOVMENT c on b.MOV_CODE=c.MOV_CODE where b.PER_ID=$PER_ID and b.MOV_CODE!='1901' order by b.SAH_SALARY asc, b.SAH_EFFECTIVEDATE asc "; } // end if $count_salaryhis = $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); //echo " $cmd "; if($count_salaryhis){ $salaryhis_count = 0; while($data2 = $db_dpis2->get_array()){ $salaryhis_count++; $SAH_EFFECTIVEDATE = trim($data2[SAH_EFFECTIVEDATE]); $SAH_EFFECTIVEDATE_MAX = $SAH_EFFECTIVEDATE . "23:59:59"; $SAH_EFFECTIVEDATE = ($SAH_EFFECTIVEDATE?$SAH_EFFECTIVEDATE:"-"); $MOV_NAME = trim($data2[MOV_NAME]); $MOV_NAME = (trim($MOV_NAME)?trim($MOV_NAME):""); $SAH_SALARY = number_format($data2[SAH_SALARY], ","); $SAH_SALARY = ($SAH_SALARY?$SAH_SALARY:"-"); $SAH_SEQ_NO = $data2[SAH_SEQ_NO]; $LEVEL_NO = $data2[LEVEL_NO]; $SAH_POSITION = $data2[SAH_POSITION]; $SAH_ORG = $data2[SAH_ORG]; $SM_CODE = $data2[SM_CODE]; $SAH_REMARK = $data2[SAH_REMARK]; $SAH_PAY_NO = trim($data2[SAH_POS_NO_NAME]).trim($data2[SAH_PAY_NO]); $cmd = " select SM_NAME, SM_FACTOR from PER_SALARY_MOVMENT where SM_CODE='$SM_CODE' "; $db_dpis3->send_cmd($cmd); $data3 = $db_dpis3->get_array(); $SM_NAME = $data3[SM_NAME]; $SM_FACTOR = $data3[SM_FACTOR] + 0; // if ($SM_NAME && $SM_FACTOR != 0) $MOV_NAME .= " ($SM_NAME)"; if ($SM_NAME) $MOV_NAME .= " ($SM_NAME)"; $ARR_POSCHECK[$PER_ID][DOC_NO][] = $data2[POH_DOCNO]; $ARR_POSCHECK[$PER_ID][DOC_DATE][] = $POH_DOCDATE; $ARR_POSCHECK[$PER_ID][MOVE_CODE][] = $MOV_CODE; if(trim($data2[SAH_DOCNO])){ $SAH_DOCDATE = "ลว. ".show_date_format($data2[SAH_DOCDATE], 2); $USRNAME = ""; if($data2[UPDATE_USER]){ //ดึงชื่อจาก ตาราง user_detail ของ mysql $cmd1 ="select fullname from user_detail where id=$data2[UPDATE_USER]"; $db->send_cmd($cmd1); // $db->show_error(); $datausr = $db->get_array(); $datausr = array_change_key_case($datausr, CASE_LOWER); $USRNAME = $datausr[fullname]; } if (strpos($data2[SAH_DOCNO],"คส.") !== false) $SAH_DOCNO = $data2[SAH_DOCNO]."\n".$SAH_DOCDATE."\n".$USRNAME; else $SAH_DOCNO = "คส. ".$data2[SAH_DOCNO]."\n".$SAH_DOCDATE."\n".$USRNAME; } // end if(trim($data2[SAH_DOCNO])) $cmd = " select POSITION_LEVEL from PER_LEVEL where LEVEL_NO='$LEVEL_NO' "; $db_dpis3->send_cmd($cmd); //echo " $cmd "; //$db_dpis3->show_error(); $data3 = $db_dpis3->get_array(); $POSITION_LEVEL = $data3[POSITION_LEVEL]; if ($POSITION_LEVEL=="ชำนาญการพิเศษ") { $POSITION_LEVEL = "ชำนาญการ"."\n"."พิเศษ"; $testpos = str_replace("\n"," ",$POSITION_LEVEL); // echo "POSITION_LEVEL=$testpos "; } $TMP_PL_NAME = trim($MOVE_NAME); $flag_dup = false; $key = array_search($data2[SAH_DOCNO], $ARR_POSCHECK[$PER_ID][DOC_NO]); if ($key !== false) { // ถ้ามี DOC_NO เหมือนกัน if ($ARR_POSCHECK[$PER_ID][DOC_DATE][$key] == $data2[SAH_DOCDATE]) { // และถ้ามี doc_date เหมือนกัน // if ($ARR_POSCHECK[$PER_ID][MOVE_CODE][$key] == "") { // และถ้ามี move_code= $flag_dup = true; if (!$ARR_POSITIONHIS[$PER_ID][$key][SEQ]) $ARR_POSITIONHIS[$PER_ID][$key][SEQ] = $SAH_SEQ_NO; if (!$ARR_POSITIONHIS[$PER_ID][$key][MOVE]) $ARR_POSITIONHIS[$PER_ID][$key][MOVE] = $MOV_NAME; if (!$ARR_POSITIONHIS[$PER_ID][$key][POS_NAME]) $ARR_POSITIONHIS[$PER_ID][$key][POS_NAME] = $TMP_PL_NAME; if (!$ARR_POSITIONHIS[$PER_ID][$key][POS_NO]) $ARR_POSITIONHIS[$PER_ID][$key][POS_NO] = $SAH_PAY_NO; if (!$ARR_POSITIONHIS[$PER_ID][$key][LEVEL]) $ARR_POSITIONHIS[$PER_ID][$key][LEVEL] = $POSITION_LEVEL; if (!$ARR_POSITIONHIS[$PER_ID][$key][SALARY]) $ARR_POSITIONHIS[$PER_ID][$key][SALARY] = $SAH_SALARY; // } // end if check movecode } // end if check doc_date } // end if check doc_no if (!$flag_dup) { // ถ้าไม่ซ้ำ //เก็บลง array ของ SALARYHIS $ARR_SALARYHIS[$PER_ID][] = array( 'DATE'=>$SAH_EFFECTIVEDATE, 'SEQ'=>$SAH_SEQ_NO, 'MOVE'=>$MOV_NAME, 'POS_NAME'=>$TMP_PL_NAME, 'POS_NO'=>$SAH_PAY_NO, 'LEVEL'=>$POSITION_LEVEL, 'SALARY'=>$SAH_SALARY, 'DOC_NO'=>$SAH_DOCNO, 'SAH_REMARK'=>$SAH_REMARK ); } // end if !$flag_dup } // end while }// end if ($count_salaryhis) //###################################### //รวมประวัติการดำรงตำแหน่ง + การเลื่อนขั้นเงินเดือน //###################################### //array_multisort($ARR_POSITIONHIS[$PER_ID], SORT_ASC, $ARR_SALARYHIS[$PER_ID], SORT_ASC); $ARRAY_POH_SAH[$PER_ID] = array_merge_recursive($ARR_POSITIONHIS[$PER_ID] , $ARR_SALARYHIS[$PER_ID]); unset($ARR_POSITIONHIS); unset($ARR_SALARYHIS); // เรียงข้อมูล ตามวันที่ / เงินเดือน น้อยไปมาก for($in=0; $in < count($ARRAY_POH_SAH[$PER_ID]);$in++){ //เก็บค่าวันที่ $DATE_HIS[] = array('DATE'=>$ARRAY_POH_SAH[$PER_ID][$in]['DATE'], 'SEQ'=>$ARRAY_POH_SAH[$PER_ID][$in]['SEQ'], 'MOVE'=>$ARRAY_POH_SAH[$PER_ID][$in]['MOVE'], 'POS_NAME'=>$ARRAY_POH_SAH[$PER_ID][$in]['POS_NAME'], 'POS_NO'=>$ARRAY_POH_SAH[$PER_ID][$in]['POS_NO'], 'LEVEL'=>$ARRAY_POH_SAH[$PER_ID][$in]['LEVEL'], 'SALARY'=>$ARRAY_POH_SAH[$PER_ID][$in]['SALARY'], 'DOC_NO'=>$ARRAY_POH_SAH[$PER_ID][$in]['DOC_NO'], 'SAH_REMARK'=>$ARRAY_POH_SAH[$PER_ID][$in]['SAH_REMARK']); } // end for unset($ARRAY_POH_SAH); sort($DATE_HIS); foreach ($DATE_HIS as $key => $value) { //กรณีที่วันที่เดียวกัน แต่ต้องเอาเงินเดือนน้อยกว่าแสดงก่อน $DATE[$key] = $value['DATE']; $SEQ[$key] = $value['SEQ']; $MOVE[$key] = $value['MOVE']; $POS_NAME[$key] = $value['POS_NAME']; $POS_NO[$key] = $value['POS_NO']; $LEVEL[$key] = $value['LEVEL']; $SALARY[$key] = $value['SALARY']; $DOC_NO[$key] = $value['DOC_NO']; $SAH_REMARK[$key] = $value['SAH_REMARK']; } // end foreach array_multisort($DATE, SORT_ASC, $SALARY, SORT_ASC, $DATE_HIS); $POH_SAH_HIS[$PER_ID]=$DATE_HIS; unset($DATE_HIS); ###IN CASE POSITIONHIS ####### ///////////////////////////////////////////////////////////////// //ส่วนแสดงเนื้อหา หลังจากจัดเรียงข้อมูลแล้ว if(is_array($POH_SAH_HIS) && !empty($POH_SAH_HIS)){ $count_positionhis=count($POH_SAH_HIS[$PER_ID]); $reccnt=0; for($in=0; $in < $count_positionhis; $in++){ $DATE_POH_SAH = show_date_format($POH_SAH_HIS[$PER_ID][$in]['DATE'], 3); //หาระดับตำแหน่ง (1,2,3,4,5,6,7,8,9); $cmd = "select LEVEL_NAME from PER_LEVEL where LEVEL_NO='".$POH_SAH_HIS[$PER_ID][$in]['LEVEL']."' order by LEVEL_NO"; // echo "$cmd "; $db_dpis2->send_cmd($cmd); // $db_dpis2->show_error(); $data2 = $db_dpis2->get_array(); $LEVEL_NAME1 = trim($data2[LEVEL_NAME]); $arr_temp = explode(" ", $LEVEL_NAME1); //หาชื่อตำแหน่งประเภท $POSITION_TYPE=""; if(strstr($LEVEL_NAME1, 'ประเภท') == TRUE) { $POSITION_TYPE = str_replace("ประเภท", "", $arr_temp[0]); }elseif(strstr($LEVEL_NAME1, 'กลุ่มงาน') == TRUE) { $POSITION_TYPE = str_replace("กลุ่มงาน", "", $arr_temp[0]); }else{ if($arr_temp[0] != 'ระดับ'){ $POSITION_TYPE = $arr_temp[0]; } } //หาชื่อระดับตำแหน่ง $LEVEL_NAME1 =""; if(strstr($arr_temp[1], 'ระดับ') == TRUE) { $LEVEL_NAME1 = str_replace("ระดับ", "", $arr_temp[1]); }else{ $LEVEL_NAME1 = level_no_format($arr_temp[1]); } //กำหนดชื่อตำแหน่ง ----------------------- if(trim($POH_SAH_HIS[$PER_ID][$in]['POS_NAME'])){ //สำหรับการเคลื่อนไหวของ ตน. $f_pos_color = "blue"; $POH_SAH_HIS[$PER_ID][$in]['POS_NAME'] = $POH_SAH_HIS[$PER_ID][$in]['POS_NAME']." ".$LEVEL_NAME1; }else if(trim($POH_SAH_HIS[$PER_ID][$in]['MOVE'])){ //สำหรับการเลื่อนขั้นเงินเดือน $f_pos_color = "black"; $POH_SAH_HIS[$PER_ID][$in]['POS_NAME'] = $POH_SAH_HIS[$PER_ID][$in]['MOVE']; if($POH_SAH_HIS[$PER_ID][$in]['SAH_REMARK']){ $POH_SAH_HIS[$PER_ID][$in]['POS_NAME'] = $POH_SAH_HIS[$PER_ID][$in]['MOVE']." (".$POH_SAH_HIS[$PER_ID][$in]['SAH_REMARK'].")"; } } if ($in % 2 == 0) echo ""; else echo ""; //แสดง รายการที่ $recno = $in+1; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } // end for loop $in } // end if(is_array($POH_SAH_HIS) && !empty($POH_SAH_HIS)) } // end while }else{ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } // end if ?> เลือก วันที่ ตำแหน่ง ระดับ เลขที่เอกสาร  $recno ".($DATE_POH_SAH?$DATE_POH_SAH:"")." ".($POH_SAH_HIS[$PER_ID][$in]['POS_NAME']? $POH_SAH_HIS[$PER_ID][$in]['POS_NAME']:"")." ".($POH_SAH_HIS[$PER_ID][$in]['POS_NO']?$POH_SAH_HIS[$PER_ID][$in]['POS_NO']:"")." ".($POH_SAH_HIS[$PER_ID][$in]['LEVEL'] ? $POH_SAH_HIS[$PER_ID][$in]['LEVEL'] : "")." ".($POH_SAH_HIS[$PER_ID][$in]['SALARY']?$POH_SAH_HIS[$PER_ID][$in]['SALARY']:"")." ".($POH_SAH_HIS[$PER_ID][$in]['DOC_NO'] ? $POH_SAH_HIS[$PER_ID][$in]['DOC_NO'] : "")." ไม่มีข้อมูล