send_cmd($cmd); $data = $db_dpis->get_array(); $PER_ID_REVIEW_CH = $data[PER_ID_REVIEW]; $cmd = " select PG_EVALUATE from PER_PERFORMANCE_GOALS where KF_ID=$KF_ID "; $db_dpis->send_cmd($cmd); $data_eva = $db_dpis->get_array(); $pg_evaluate_chk = $data_eva[PG_EVALUATE]; //ค่าของผู้ประเมินเริ่มให้คะเเนน //==================================================== //เพิ่มฟิวล์ วันที่ติกให้เห็นคะเเนน $cmdChk =" SELECT COUNT(COLUMN_NAME) AS CNT FROM USER_TAB_COLS WHERE TABLE_NAME = 'PER_KPI_FORM'AND UPPER(COLUMN_NAME)IN('SCORE_STATUS_DATE')"; $db_dpis1->send_cmd($cmdChk); $dataChk = $db_dpis1->get_array(); if($dataChk[CNT]=="0"){ $cmdA = "ALTER TABLE PER_KPI_FORM ADD SCORE_STATUS_DATE VARCHAR2(19)"; $db_dpis1->send_cmd($cmdA); $cmdA = "COMMIT"; $db_dpis1->send_cmd($cmdA); } //เพิ่มฟิวล์ วันที่ยอมรับคะเเนน $cmdChk =" SELECT COUNT(COLUMN_NAME) AS CNT FROM USER_TAB_COLS WHERE TABLE_NAME = 'PER_KPI_FORM'AND UPPER(COLUMN_NAME)IN('ACCEPT_DATE')"; $db_dpis1->send_cmd($cmdChk); $dataChk = $db_dpis1->get_array(); if($dataChk[CNT]=="0"){ $cmdA = "ALTER TABLE PER_KPI_FORM ADD ACCEPT_DATE VARCHAR2(19)"; $db_dpis1->send_cmd($cmdA); $cmdA = "COMMIT"; $db_dpis1->send_cmd($cmdA); } //เพิ่มฟิวล์วันที่เเสดงความคิดเห็นผู้บังคับบันชาเหนือขึ่นไป $cmdChk =" SELECT COUNT(COLUMN_NAME) AS CNT FROM USER_TAB_COLS WHERE TABLE_NAME = 'PER_KPI_FORM'AND UPPER(COLUMN_NAME)IN('DATE_REVIEW1')"; $db_dpis1->send_cmd($cmdChk); $dataChk = $db_dpis1->get_array(); if($dataChk[CNT]=="0"){ $cmdA = "ALTER TABLE PER_KPI_FORM ADD DATE_REVIEW1 VARCHAR2(19)"; $db_dpis1->send_cmd($cmdA); $cmdA = "COMMIT"; $db_dpis1->send_cmd($cmdA); } //เพิ่มฟิวล์วันที่เเสดงความคิดเห็นผู้บังคับบันชาเหนือขึ่นไป 1 ขั้น $cmdChk =" SELECT COUNT(COLUMN_NAME) AS CNT FROM USER_TAB_COLS WHERE TABLE_NAME = 'PER_KPI_FORM'AND UPPER(COLUMN_NAME)IN('DATE_REVIEW2')"; $db_dpis1->send_cmd($cmdChk); $dataChk = $db_dpis1->get_array(); if($dataChk[CNT]=="0"){ $cmdA = "ALTER TABLE PER_KPI_FORM ADD DATE_REVIEW2 VARCHAR2(19)"; $db_dpis1->send_cmd($cmdA); $cmdA = "COMMIT"; $db_dpis1->send_cmd($cmdA); } //ผลงานองค์ประกอบอื่นๆ $cmdChk =" SELECT COUNT(COLUMN_NAME) AS CNT FROM USER_TAB_COLS WHERE TABLE_NAME = 'PER_KPI_FORM'AND UPPER(COLUMN_NAME)IN('OTH_DESC')"; $db_dpis1->send_cmd($cmdChk); $dataChk = $db_dpis1->get_array(); if($dataChk[CNT]=="0"){ $cmdA = "ALTER TABLE PER_KPI_FORM ADD OTH_DESC VARCHAR2(255)"; $db_dpis1->send_cmd($cmdA); $cmdA = "COMMIT"; $db_dpis1->send_cmd($cmdA); } //====================================================================== if(!$sort_by) $sort_by=2; $sort_type = (isset($sort_type))? $sort_type : "1:asc"; $arrSort=explode(":",$sort_type); $SortType[$arrSort[0]] =$arrSort[1]; if(!$order_by) $order_by=2; if($order_by==1){ $order_str = "PER_NAME $SortType[$order_by], PER_SURNAME $SortType[$order_by], KF_START_DATE $SortType[$order_by], KF_CYCLE $SortType[$order_by]"; }elseif($order_by==2) { $org_cond = ""; if ($POSITION_NO_CHAR=="Y") $org_cond = ", h.ORG_SEQ_NO $SortType[$order_by], h.ORG_CODE $SortType[$order_by]"; if($DPISDB=="odbc") { $order_str = "b.PER_TYPE $SortType[$order_by], a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POS_NO_NAME $SortType[$order_by], iif(isnull(POS_NO),0,CLng(POS_NO)) $SortType[$order_by], iif(isnull(POEM_NO),0,CLng(POEM_NO)) $SortType[$order_by], iif(isnull(POEMS_NO),0,CLng(POEMS_NO)) $SortType[$order_by], iif(isnull(POT_NO),0,CLng(POT_NO)) $SortType[$order_by], KF_START_DATE $SortType[$order_by], KF_CYCLE $SortType[$order_by]"; }elseif($DPISDB=="oci8"){ $order_str = "PER_TYPE $SortType[$order_by], DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POS_NO_NAME $SortType[$order_by], to_number(replace(POS_NO,'-','')) $SortType[$order_by], to_number(replace(POEM_NO,'-','')) $SortType[$order_by], to_number(replace(POEMS_NO,'-','')) $SortType[$order_by], to_number(replace(POT_NO,'-','')) $SortType[$order_by], KF_START_DATE $SortType[$order_by], KF_CYCLE $SortType[$order_by]"; }elseif($DPISDB=="mysql"){ $order_str = "b.PER_TYPE $SortType[$order_by], a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POS_NO_NAME $SortType[$order_by], POS_NO+0 $SortType[$order_by], POEM_NO+0 $SortType[$order_by], POEMS_NO+0 $SortType[$order_by], POT_NO+0 $SortType[$order_by], KF_START_DATE $SortType[$order_by], KF_CYCLE $SortType[$order_by]"; } } elseif($order_by==3){ $order_str = "PER_TYPE $SortType[$order_by], LEVEL_SEQ_NO $SortType[$order_by]"; } elseif($order_by==4) { $order_str = "PER_TYPE $SortType[$order_by], ORG_ID $SortType[$order_by], ORG_ID $SortType[$order_by], ORG_ID $SortType[$order_by], ORG_ID $SortType[$order_by]"; } elseif($order_by==5){ $order_str = "PER_TYPE $SortType[$order_by], TOTAL_SCORE $SortType[$order_by]"; } if(($SESS_GROUPCODE == "BUREAU" || substr($SESS_GROUPCODE, 0, 7) == "BUREAU_" ) || $SESS_USERGROUP==3 && trim($SESS_PER_ID)){ $arr_search_condition[] = "(a.PER_ID=$SESS_PER_ID or a.PER_ID_REVIEW=$SESS_PER_ID or a.PER_ID_REVIEW0=$SESS_PER_ID or a.PER_ID_REVIEW1=$SESS_PER_ID or a.PER_ID_REVIEW2=$SESS_PER_ID )"; }else{ // end if // if($_REQUEST[PER_ID] && !trim($SESS_PER_ID)){ $PER_ID=$_REQUEST[PER_ID]; } // if($PER_ID) $arr_search_condition[] = "(a.PER_ID='$PER_ID')"; } if($search_org_id){ if($search_org_structure==0) $arr_search_condition[] = "(a.ORG_ID_SALARY=$search_org_id)"; if($search_org_structure==1) $arr_search_condition[] = "(a.ORG_ID_ASS=$search_org_id)"; }elseif($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) ."))"; } // end if if(trim($search_kf_year)){ if($DPISDB=="odbc"){ $arr_search_condition[] = "(LEFT(a.KF_START_DATE, 10) >= '". ($search_kf_year - 543 - 1)."-10-01')"; $arr_search_condition[] = "(LEFT(a.KF_END_DATE, 10) < '". ($search_kf_year - 543)."-10-01')"; }elseif($DPISDB=="oci8"){ $arr_search_condition[] = "(SUBSTR(a.KF_START_DATE, 1, 10) >= '". ($search_kf_year - 543 - 1)."-10-01')"; $arr_search_condition[] = "(SUBSTR(a.KF_END_DATE, 1, 10) < '". ($search_kf_year - 543)."-10-01')"; }elseif($DPISDB=="mysql"){ $arr_search_condition[] = "(LEFT(a.KF_START_DATE, 10) >= '". ($search_kf_year - 543 - 1)."-10-01')"; $arr_search_condition[] = "(LEFT(a.KF_END_DATE, 10) < '". ($search_kf_year - 543)."-10-01')"; } // end if } // end if if(!$search_kpi_per_type && $SESS_PER_TYPE!=0) $search_kpi_per_type=$SESS_PER_TYPE; if($search_kpi_per_type > 0) $arr_search_condition[] = "(b.PER_TYPE = $search_kpi_per_type)"; // if(!$search_kpi_per_type) $search_kpi_per_type=$SESS_PER_TYPE; // if($search_kpi_per_type >= 0) $arr_search_condition[] = "(b.PER_TYPE = $search_kpi_per_type)"; 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(!is_array($search_kf_cycle)) { $search_kf_cycle[0] = $KF_CYCLE;} //ให้ติ๊กตาม c06 $arr_search_condition[] = "(a.KF_CYCLE in (". implode(",", $search_kf_cycle) ."))"; $search_condition = ""; if(count($arr_search_condition)) $search_condition = " and " . implode(" and ", $arr_search_condition); // echo "1..command=$command, PER_ID=$PER_ID, search_kf_year=$search_kf_year, search_per_name=$search_per_name, search_per_surname=$search_per_surname, search_kpi_per_type=$search_kpi_per_type
"; // echo "2..command=$command, PER_ID=$PER_ID, search_kf_year=$search_kf_year, search_per_name=$search_per_name, search_per_surname=$search_per_surname, search_kpi_per_type=$search_kpi_per_type
"; if ($SESS_ORG_STRUCTURE==0 || $SESS_ORG_STRUCTURE==1) $search_org_structure = $SESS_ORG_STRUCTURE; $db_dpis1 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd, $dpisdb_port); $db_dpis3 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd); ?> <?=$webpage_title?> - <?=$MENU_TITLE_LV0?><?if($MENU_ID_LV1){?> - <?=$MENU_TITLE_LV1?><?}?>
   
ข้อมูล
*  :  *  : 
*  :  >    >  ถึง  > *  :  >   
  >    >  ถึง  >
* ชื่อผู้รับการประเมิน :  "; if(!trim($PER_ID) && $SESS_PER_ID){ $PER_ID=$SESS_PER_ID; } ?>  : 
 :   : 
 :   :  >
ชื่อผู้ให้ข้อมูล : 

 : 
 :   : 
ชื่อผู้บังคับบัญชา/ผู้ประเมิน :   : 
 :   : 
ชื่อผู้บังคับบัญชาเหนือขึ้นไป :   : 
 :   : 
ชื่อผู้บังคับบัญชาเหนือขึ้นไปอีกชั้นหนึ่ง :   : 
 :   : 
    ');" value=""> <?=$DEL_TITLE?>');">    <?=$DETAIL_TITLE?>            <?=$CLEAR_TITLE?>   


 
คัดลอก
 จาก :  >  คัดลอกไป :  >
 จาก :  >   >  คัดลอกไป :  >   >

 :   : 
    onClick="form1.search_org_id.value='';form1.search_org_name.value='';">  onClick="form1.search_org_id.value='';form1.search_org_name.value='';">
 :   :  > >
 :   : 
 :  ผลการประเมิน ตั้งแต่ :    ถึง  
อนุญาตให้เห็นคะแนน  :  รับทราบในการประเมินคะแนน  : 
= $str_score"; }else{ if($str_score==0 && $end_score != 0){ $str_scorew = "and a.TOTAL_SCORE <= $end_score"; }else{ $str_scorew = " and a.TOTAL_SCORE BETWEEN $str_score AND $end_score "; } } } $cmd =" select count(a.KF_ID) as count_data from PER_KPI_FORM a, PER_PERSONAL b where a.PER_ID=b.PER_ID $search_condition $score_kfw $score_acceptw $str_scorew"; $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 + $PER_ID = $SESS_PER_ID + $SESS_USERID : $cmd"; ?>
พบข้อมูลทั้งสิ้น รายการ
1){ if($DPISDB=="odbc"){ $cmd = " select top $start_record a.KF_ID from ( ( ( ( ( ( PER_KPI_FORM 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 (a.LEVEL_NO=f.LEVEL_NO) ) left join PER_POS_TEMP g on (b.POT_ID=g.POT_ID) ) left join PER_ORG h on (a.ORG_ID=h.ORG_ID) $search_condition order by $order_str "; $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_exclude[] = $data[KF_ID]; $limit_data = " and a.KF_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"){ if(count($arr_search_condition)) $search_condition = " where " . implode(" and ", $arr_search_condition); $cmd = " select top $data_per_page a.KF_ID, a.KF_END_DATE, a.KF_CYCLE, b.PN_CODE, b.PER_NAME, b.PER_SURNAME, a.SUM_KPI, a.SUM_COMPETENCE, a.SUM_OTHER, a.PER_ID, a.PER_ID_REVIEW, a.PER_ID_REVIEW0, a.PER_ID_REVIEW1, a.PER_ID_REVIEW2, CHIEF_PER_ID, FRIEND_FLAG, TOTAL_SCORE, a.ORG_ID_KPI, a.ORG_ID, a.LEVEL_NO, b.PER_TYPE, b.POS_ID, b.POEM_ID, b.POEMS_ID, b.POT_ID, b.PER_CARDNO, a.KF_SCORE_STATUS, a.DEPARTMENT_ID from ( ( ( ( ( ( PER_KPI_FORM 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 (a.LEVEL_NO=f.LEVEL_NO) ) left join PER_POS_TEMP g on (b.POT_ID=g.POT_ID) ) left join PER_ORG h on (a.ORG_ID=h.ORG_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.KF_ID, a.KF_END_DATE, a.KF_CYCLE, b.PN_CODE, b.PER_NAME, b.PER_SURNAME, a.SUM_KPI, a.SUM_COMPETENCE, a.SUM_OTHER, a.PER_ID, a.PER_ID_REVIEW, a.PER_ID_REVIEW0, a.PER_ID_REVIEW1, a.PER_ID_REVIEW2, CHIEF_PER_ID, FRIEND_FLAG, TOTAL_SCORE, a.ORG_ID_KPI, a.ORG_ID, a.LEVEL_NO, b.PER_TYPE, b.POS_ID, b.POEM_ID, b.POEMS_ID, b.POT_ID, b.PER_CARDNO, a.KF_SCORE_STATUS, a.DEPARTMENT_ID, a.ACCEPT_FLAG from PER_KPI_FORM a, PER_PERSONAL b, PER_POSITION c, PER_POS_EMP d, PER_POS_EMPSER e, PER_LEVEL f, PER_POS_TEMP g, PER_ORG h 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 a.LEVEL_NO=f.LEVEL_NO(+) and b.POT_ID=g.POT_ID(+) and a.ORG_ID=h.ORG_ID(+) $search_condition $NO_ID $score_kfw $score_acceptw $str_scorew order by $order_str ) temp1 where rownum <= $max_rownum ) temp2 where rnum between $min_rownum and $max_rownum "; }elseif($DPISDB=="mysql"){ if(count($arr_search_condition)) $search_condition = " where " . implode(" and ", $arr_search_condition); $cmd = " select a.KF_ID, a.KF_END_DATE, a.KF_CYCLE, b.PN_CODE, b.PER_NAME, b.PER_SURNAME, a.SUM_KPI, a.SUM_COMPETENCE, a.SUM_OTHER, a.PER_ID, a.PER_ID_REVIEW, a.PER_ID_REVIEW0, a.PER_ID_REVIEW1, a.PER_ID_REVIEW2, CHIEF_PER_ID, FRIEND_FLAG, TOTAL_SCORE, a.ORG_ID_KPI, a.ORG_ID, a.LEVEL_NO, b.PER_TYPE, b.POS_ID, b.POEM_ID, b.POEMS_ID, b.POT_ID, b.PER_CARDNO, a.KF_SCORE_STATUS, a.DEPARTMENT_ID from ( ( ( ( ( ( PER_KPI_FORM 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 (a.LEVEL_NO=f.LEVEL_NO) ) left join PER_POS_TEMP g on (b.POT_ID=g.POT_ID) ) left join PER_ORG h on (a.ORG_ID=h.ORG_ID) $search_condition order by $order_str $limit_data "; } // end if $count_page_data = $db_dpis->send_cmd($cmd)+0; // echo '
'.$cmd;
	//echo "
$command :: $cmd $count_page_data
"; //$db_dpis->show_error(); ?> ".$cmd; $count_page_data2 = $db_dpis3->send_cmd($cmd); //echo"
".$cmd;
    $db_dpis3->send_cmd($cmd);            
   while ($data = $db_dpis3->get_array()) {
		$data_count++;
		if($data_count > $data_per_page) break;
		$TMP_KF_ID = $data[KF_ID];
		$current_list .= ((trim($current_list))?",":"") . $TMP_KF_ID;
                if(trim($data[KF_SCORE_STATUS])==1){
                    $val_disabled_list_kf_id .= ((trim($val_disabled_list_kf_id))?",":"") . $TMP_KF_ID;
                }
		$KF_END_DATE = substr($data[KF_END_DATE], 0, 10);
		$KF_YEAR = substr($KF_END_DATE, 0, 4) + 543;
		$KF_CYCLE = $data[KF_CYCLE] + 0;
		$PN_CODE = $data[PN_CODE];
		$SELF_PER_ID = $data[PER_ID];
		$CHIEF_PER_ID = $data[CHIEF_PER_ID]; 	// รหัสหัวหน้า
		$FRIEND_FLAG = $data[FRIEND_FLAG];
		$TOTAL_SCORE = $data[TOTAL_SCORE];
		$ORG_ID_KPI = $data[ORG_ID_KPI];
		$TMP_ORG_ID = $data[ORG_ID];
		$PER_KPI_CARDNO = trim($data[PER_CARDNO]);
		$TMP_DEPARTMENT_ID = $data[DEPARTMENT_ID];

// หา status ของรายการประเมิน (=1 ประเมินเสร็จแล้ว) ของตัวเอง
		if ($SCOMPETENCY[$PER_ID_DEPARTMENT_ID]=="Y") {
			$cmd = " select KF_ID, CF_PER_ID, CF_STATUS from PER_COMPETENCY_FORM where KF_ID = $TMP_KF_ID and CF_PER_ID = $SELF_PER_ID ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$COMPETENCY_STATUS = $data2[CF_STATUS];
	
	// หา status ของรายการประเมิน (=1 ประเมินเสร็จแล้ว) ของผู้บังคับบัญชา
			$cmd = " select KF_ID, CF_PER_ID, CF_STATUS from PER_COMPETENCY_FORM where KF_ID = $TMP_KF_ID and CF_PER_ID = $CHIEF_PER_ID ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$CHIEF_STATUS = $data2[CF_STATUS];
		}

		$TMP_ORG_NAME = "";
		if ($TMP_ORG_ID) {
			$cmd = " select ORG_NAME from PER_ORG where ORG_ID = $TMP_ORG_ID ";
			if($SESS_ORG_STRUCTURE==1) {
				$cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			}
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$TMP_ORG_NAME = trim($data2[ORG_NAME]);
			if ($TMP_ORG_NAME=="-") $TMP_ORG_NAME = "";
		}

// ข้อมูลลูกน้อง
	    $ARR_SUB_PER_ID = $SUB_PER_ID = "";
		$cmd = " select PER_ID from PER_KPI_FORM a where CHIEF_PER_ID=$SELF_PER_ID $search_condition ";
		$db_dpis2->send_cmd($cmd);
		while ($data2 = $db_dpis2->get_array()) {
			$ARR_SUB_PER_ID[] = $data2[PER_ID];
		}
		if ($ARR_SUB_PER_ID) $SUB_PER_ID = implode(',',$ARR_SUB_PER_ID);

// ช้อมูลเพื่อน	ผู้ร่วมงาน
		if ($FRIEND_FLAG=="Y") {
		    $ARR_FRIEND_PER_ID = $FRIEND_PER_ID = "";
//			$cmd = " select PER_ID from PER_KPI_FORM where ORG_ID_KPI=$ORG_ID_KPI ";
			$cmd = " select b.ORG_ID, ORG_ID_1, ORG_ID_2 from PER_PERSONAL a, PER_POSITION b 
							where a.POS_ID=b.POS_ID and a.PER_ID=$SELF_PER_ID and a.PER_STATUS=1 ";
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$ORG_ID = $data2[ORG_ID];
			$ORG_ID_1 = $data2[ORG_ID_1];
			$ORG_ID_2 = $data2[ORG_ID_2];
			$where = "";
			if ($CHIEF_PER_ID) $where = "(and a.PER_ID <> $CHIEF_PER_ID)";

			if ($ORG_ID_2) 
				$cmd = " select PER_ID from PER_PERSONAL a, PER_POSITION b 
								where a.POS_ID=b.POS_ID and a.PER_ID <> $SELF_PER_ID $where and 
								b.ORG_ID=$ORG_ID and ORG_ID_1=$ORG_ID_1 and ORG_ID_2=$ORG_ID_2 and a.PER_STATUS=1 ";  
			elseif ($ORG_ID_1) 
				$cmd = " select PER_ID from PER_PERSONAL a, PER_POSITION b 
								where a.POS_ID=b.POS_ID and a.PER_ID <> $SELF_PER_ID $where and 
								b.ORG_ID=$ORG_ID and ORG_ID_1=$ORG_ID_1 and a.PER_STATUS=1 ";  
			else
				$cmd = " select PER_ID from PER_PERSONAL a, PER_POSITION b 
								where a.POS_ID=b.POS_ID and a.PER_ID <> $SELF_PER_ID $where and 
								b.ORG_ID=$ORG_ID and ORG_ID_1 is NULL and a.PER_STATUS=1 ";  
			$db_dpis2->send_cmd($cmd);
			while ($data2 = $db_dpis2->get_array()) {
				$ARR_FRIEND_PER_ID[] = $data2[PER_ID];
			}
			if ($ARR_FRIEND_PER_ID) $FRIEND_PER_ID = implode(',',$ARR_FRIEND_PER_ID);
			if (!$FRIEND_PER_ID) {
				$FRIEND_FLAG="";
			}
		}
		
		$TMP_PER_NAME = trim($data[PER_NAME]);
		$TMP_PER_SURNAME = trim($data[PER_SURNAME]);
		$KF_SCORE_STATUS = trim($data[KF_SCORE_STATUS]);
		$TMP_PER_ID_REVIEW = $data[PER_ID_REVIEW];
		$TMP_PER_ID_REVIEW0 = $data[PER_ID_REVIEW0];
		$TMP_PER_ID_REVIEW1 = $data[PER_ID_REVIEW1];
		$TMP_PER_ID_REVIEW2 = $data[PER_ID_REVIEW2];
                
                $chk_display=0;/*<<< Release 5.2.1.5 กรณีที่ผู้ประเมินให้คะแนนแล้ว ถือว่าสิ้นสุดจะไม่ให้แก้ไขส่วนอื่นๆ*/
		if ($KF_SCORE_STATUS==1 || $KPI_SCORE_CONFIRM!=1 || $SESS_USERGROUP == 1 || $TMP_PER_ID_REVIEW==$SESS_PER_ID || 
			$TMP_PER_ID_REVIEW0==$SESS_PER_ID || $TMP_PER_ID_REVIEW1==$SESS_PER_ID || $TMP_PER_ID_REVIEW2==$SESS_PER_ID) {
			if ($TOTAL_SCORE)
				$RESULT = number_format($TOTAL_SCORE, 2);
			else
				$RESULT = number_format(($data[SUM_KPI] + $data[SUM_COMPETENCE] + $data[SUM_OTHER]), 2);
                    $chk_display=1;/*<<< Release 5.2.1.5*/
		} else $RESULT = "***";
		
		$cmd = " select PN_NAME from PER_PRENAME where PN_CODE='$PN_CODE' ";
		$db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$TMP_PN_NAME = $data2[PN_NAME];
		
		$PER_FULLNAME = $TMP_PN_NAME . $TMP_PER_NAME . " " . $TMP_PER_SURNAME;
		
		$LEVEL_NO = trim($data[LEVEL_NO]);
		$PER_TYPE = $data[PER_TYPE];
		$POS_ID = $data[POS_ID];
		$POEM_ID = $data[POEM_ID];
		$POEMS_ID = $data[POEMS_ID];
		$POT_ID = $data[POT_ID];
                
                $ACCEPT_FLAG = $data[ACCEPT_FLAG]; /*Release 5.2.1.8*/
		
		$cmd = " select LEVEL_NAME, POSITION_LEVEL	from PER_LEVEL where LEVEL_NO='$LEVEL_NO' ";
		$db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$LEVEL_NAME = trim($data2[LEVEL_NAME]);
		$POSITION_LEVEL = $data2[POSITION_LEVEL];
		if (!$POSITION_LEVEL) $POSITION_LEVEL = $LEVEL_NAME;

		if($PER_TYPE == 1){
			$cmd = " select 	POS_NO, POS_NO_NAME, a.ORG_ID, d.ORG_NAME, b.PL_NAME, a.PT_CODE 
							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 ";
			if($SESS_ORG_STRUCTURE==1) {
				$cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			}
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$POS_NO = $data2[POS_NO];
			$POS_NO_NAME = $data2[POS_NO_NAME];
//			$TMP_PL_NAME = trim($data2[PL_NAME])?($data2[PL_NAME] . $POSITION_LEVEL . ((trim($data2[PT_NAME]) != "ทั่วไป" && $LEVEL_NO >= 6)?"$data2[PT_NAME]":"")):" ".$LEVEL_NAME;
			$TMP_PL_NAME = trim($data2[PL_NAME])?($data2[PL_NAME] . $POSITION_LEVEL):" ".$LEVEL_NAME;
		}elseif($PER_TYPE == 2){
			$cmd = " select	pp.POEM_NO,pp.POEM_NO_NAME, pl.PN_NAME, po.ORG_NAME    
							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  ";
			if($SESS_ORG_STRUCTURE==1) {
				$cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			}
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$POS_NO = trim($data2[POEM_NO]);
			$POS_NO_NAME =  trim($data2[POEM_NO_NAME]);
			$PL_NAME = trim($data2[PN_NAME]);
			$TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : "";	
		}elseif($PER_TYPE == 3){
			$cmd = " select	pp.POEMS_NO, pp.POEMS_NO_NAME, pl.EP_NAME, po.ORG_NAME   
							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  ";
			if($SESS_ORG_STRUCTURE==1) {
				$cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			}
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$POS_NO = trim($data2[POEMS_NO]);
			$POS_NO_NAME = trim($data2[POEMS_NO_NAME]);
			$PL_NAME = trim($data2[EP_NAME]);
			$TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : "";	
		}elseif($PER_TYPE == 4){
			$cmd = " select	pp.POT_NO,pp.POT_NO_NAME, pl.TP_NAME, po.ORG_NAME    
							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  ";
			if($SESS_ORG_STRUCTURE==1) {
				$cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd);
			}
			$db_dpis2->send_cmd($cmd);
			$data2 = $db_dpis2->get_array();
			$POS_NO = trim($data2[POT_NO]);
			$POS_NO_NAME = trim($data2[POT_NO_NAME]);
			$PL_NAME = trim($data2[TP_NAME]);
			$TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : "";	
		} // end if
		
		unset($ARR_USER_AUTH);
		if(trim($data[PER_ID])) $ARR_USER_AUTH[] = $data[PER_ID];
		if(trim($data[PER_ID_REVIEW])) $ARR_USER_AUTH[] = $data[PER_ID_REVIEW];
		if(trim($data[PER_ID_REVIEW0])) $ARR_USER_AUTH[] = $data[PER_ID_REVIEW0];
		if(trim($data[PER_ID_REVIEW1])) $ARR_USER_AUTH[] = $data[PER_ID_REVIEW1];
		if(trim($data[PER_ID_REVIEW2])) $ARR_USER_AUTH[] = $data[PER_ID_REVIEW2];
		
		$cmd = "select count(KF_ID) as COUNT_KF_ID from PER_PERFORMANCE_GOALS where KF_ID=$TMP_KF_ID ";
		$count_comdtl = $db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$TMP_COUNT_KF_ID = trim($data2[COUNT_KF_ID]);

		$cmd = " select count(*) as COUNT_1 from PER_KPI_COMPETENCE a, PER_COMPETENCE b 
						where a.CP_CODE = b.CP_CODE and b.DEPARTMENT_ID=$TMP_DEPARTMENT_ID and KF_ID=$TMP_KF_ID and CP_MODEL=1 ";
		$db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$COUNT_1 = $data2[COUNT_1]+0;

		$cmd = " select count(*) as COUNT_2 from PER_KPI_COMPETENCE a, PER_COMPETENCE b 
						where a.CP_CODE = b.CP_CODE and b.DEPARTMENT_ID=$TMP_DEPARTMENT_ID and KF_ID=$TMP_KF_ID and CP_MODEL=2 ";
		$db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$COUNT_2 = $data2[COUNT_2]+0;

		$cmd = " select count(*) as COUNT_3 from PER_KPI_COMPETENCE a, PER_COMPETENCE b 
						where a.CP_CODE = b.CP_CODE and b.DEPARTMENT_ID=$TMP_DEPARTMENT_ID and KF_ID=$TMP_KF_ID and CP_MODEL=3 ";
		$db_dpis2->send_cmd($cmd);
		$data2 = $db_dpis2->get_array();
		$COUNT_3 = $data2[COUNT_3]+0;

		$class = "table_body";
		$onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" ";
		if($KF_ID==$TMP_KF_ID){ 
			$class = "table_body_over";
			$onmouse_event = "";
		} // end if	

?>
> = "2557" && $KF_CYCLE >= "1"){ // ปี 2557 ครั้งที่ 1 เป็นต้นไป เปลี่ยนที่เก็บ folder ต่อท้ายด้วย ปีงบประมาณ.ครั้งที่ $FILE_PATH = "../attachments/".$PER_KPI_CARDNO."/PER_ATTACHMENT/KPI".$KF_CYCLE."_".$KF_YEAR."/"; $FILE_PATH_GET = "KPI".$KF_CYCLE."_".$KF_YEAR; }else{ // (ยังเป็น folder เดียวกันหมด ไฟล์เก็บที่เดียวกันหมด ไม่ได้แยก ปี และ รอบไว้***) ปีงบประมาณก่อนหน้า 2557 ครั้งที่ 1 ที่ผ่านมา ยังเป็น folder ชื่อเดียวกัน ทุกปีเก็บไว้ที่เดียวกันหมด $FILE_PATH = "../attachments/".$PER_KPI_CARDNO."/PER_ATTACHMENT/70/"; $FILE_PATH_GET = "70"; } ?> = "2557" && $KF_CYCLE >= "1"){ // ปี 2557 ครั้งที่ 1 เป็นต้นไป เปลี่ยนที่เก็บ folder ต่อท้ายด้วย ปีงบประมาณ.ครั้งที่ $FILE_PATH = "../attachments/".$PER_KPI_CARDNO."/PER_ATTACHMENT/KPI".$KF_CYCLE."_".$KF_YEAR."/"; $FILE_PATH_GET = "KPI".$KF_CYCLE."_".$KF_YEAR; }else{ // (ยังเป็น folder เดียวกันหมด ไฟล์เก็บที่เดียวกันหมด ไม่ได้แยก ปี และ รอบไว้***) ปีงบประมาณก่อนหน้า 2557 ครั้งที่ 1 ที่ผ่านมา ยังเป็น folder ชื่อเดียวกัน ทุกปีเก็บไว้ที่เดียวกันหมด $FILE_PATH = "../attachments/".$PER_KPI_CARDNO."/PER_ATTACHMENT/70/"; $FILE_PATH_GET = "70"; } ?> get_array()) { $data_count++; if($data_count > $data_per_page) break; $TMP_KF_ID = $data[KF_ID]; $current_list .= ((trim($current_list))?",":"") . $TMP_KF_ID; if(trim($data[KF_SCORE_STATUS])==1){ $val_disabled_list_kf_id .= ((trim($val_disabled_list_kf_id))?",":"") . $TMP_KF_ID; } $KF_END_DATE = substr($data[KF_END_DATE], 0, 10); $KF_YEAR = substr($KF_END_DATE, 0, 4) + 543; $KF_CYCLE = $data[KF_CYCLE] + 0; $PN_CODE = $data[PN_CODE]; $SELF_PER_ID = $data[PER_ID]; $CHIEF_PER_ID = $data[CHIEF_PER_ID]; // รหัสหัวหน้า $FRIEND_FLAG = $data[FRIEND_FLAG]; $TOTAL_SCORE = $data[TOTAL_SCORE]; $ORG_ID_KPI = $data[ORG_ID_KPI]; $TMP_ORG_ID = $data[ORG_ID]; $PER_KPI_CARDNO = trim($data[PER_CARDNO]); $TMP_DEPARTMENT_ID = $data[DEPARTMENT_ID]; // หา status ของรายการประเมิน (=1 ประเมินเสร็จแล้ว) ของตัวเอง if ($SCOMPETENCY[$PER_ID_DEPARTMENT_ID]=="Y") { $cmd = " select KF_ID, CF_PER_ID, CF_STATUS from PER_COMPETENCY_FORM where KF_ID = $TMP_KF_ID and CF_PER_ID = $SELF_PER_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $COMPETENCY_STATUS = $data2[CF_STATUS]; // หา status ของรายการประเมิน (=1 ประเมินเสร็จแล้ว) ของผู้บังคับบัญชา $cmd = " select KF_ID, CF_PER_ID, CF_STATUS from PER_COMPETENCY_FORM where KF_ID = $TMP_KF_ID and CF_PER_ID = $CHIEF_PER_ID "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $CHIEF_STATUS = $data2[CF_STATUS]; } $TMP_ORG_NAME = ""; if ($TMP_ORG_ID) { $cmd = " select ORG_NAME from PER_ORG where ORG_ID = $TMP_ORG_ID "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd); } $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_ORG_NAME = trim($data2[ORG_NAME]); if ($TMP_ORG_NAME=="-") $TMP_ORG_NAME = ""; } // ข้อมูลลูกน้อง $ARR_SUB_PER_ID = $SUB_PER_ID = ""; $cmd = " select PER_ID from PER_KPI_FORM a where CHIEF_PER_ID=$SELF_PER_ID $search_condition "; $db_dpis2->send_cmd($cmd); while ($data2 = $db_dpis2->get_array()) { $ARR_SUB_PER_ID[] = $data2[PER_ID]; } if ($ARR_SUB_PER_ID) $SUB_PER_ID = implode(',',$ARR_SUB_PER_ID); // ช้อมูลเพื่อน ผู้ร่วมงาน if ($FRIEND_FLAG=="Y") { $ARR_FRIEND_PER_ID = $FRIEND_PER_ID = ""; // $cmd = " select PER_ID from PER_KPI_FORM where ORG_ID_KPI=$ORG_ID_KPI "; $cmd = " select b.ORG_ID, ORG_ID_1, ORG_ID_2 from PER_PERSONAL a, PER_POSITION b where a.POS_ID=b.POS_ID and a.PER_ID=$SELF_PER_ID and a.PER_STATUS=1 "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $ORG_ID = $data2[ORG_ID]; $ORG_ID_1 = $data2[ORG_ID_1]; $ORG_ID_2 = $data2[ORG_ID_2]; $where = ""; if ($CHIEF_PER_ID) $where = "(and a.PER_ID <> $CHIEF_PER_ID)"; if ($ORG_ID_2) $cmd = " select PER_ID from PER_PERSONAL a, PER_POSITION b where a.POS_ID=b.POS_ID and a.PER_ID <> $SELF_PER_ID $where and b.ORG_ID=$ORG_ID and ORG_ID_1=$ORG_ID_1 and ORG_ID_2=$ORG_ID_2 and a.PER_STATUS=1 "; elseif ($ORG_ID_1) $cmd = " select PER_ID from PER_PERSONAL a, PER_POSITION b where a.POS_ID=b.POS_ID and a.PER_ID <> $SELF_PER_ID $where and b.ORG_ID=$ORG_ID and ORG_ID_1=$ORG_ID_1 and a.PER_STATUS=1 "; else $cmd = " select PER_ID from PER_PERSONAL a, PER_POSITION b where a.POS_ID=b.POS_ID and a.PER_ID <> $SELF_PER_ID $where and b.ORG_ID=$ORG_ID and ORG_ID_1 is NULL and a.PER_STATUS=1 "; $db_dpis2->send_cmd($cmd); while ($data2 = $db_dpis2->get_array()) { $ARR_FRIEND_PER_ID[] = $data2[PER_ID]; } if ($ARR_FRIEND_PER_ID) $FRIEND_PER_ID = implode(',',$ARR_FRIEND_PER_ID); if (!$FRIEND_PER_ID) { $FRIEND_FLAG=""; } } $TMP_PER_NAME = trim($data[PER_NAME]); $TMP_PER_SURNAME = trim($data[PER_SURNAME]); $KF_SCORE_STATUS = trim($data[KF_SCORE_STATUS]); $TMP_PER_ID_REVIEW = $data[PER_ID_REVIEW]; $TMP_PER_ID_REVIEW0 = $data[PER_ID_REVIEW0]; $TMP_PER_ID_REVIEW1 = $data[PER_ID_REVIEW1]; $TMP_PER_ID_REVIEW2 = $data[PER_ID_REVIEW2]; $chk_display=0;/*<<< Release 5.2.1.5 กรณีที่ผู้ประเมินให้คะแนนแล้ว ถือว่าสิ้นสุดจะไม่ให้แก้ไขส่วนอื่นๆ*/ if ($KF_SCORE_STATUS==1 || $KPI_SCORE_CONFIRM!=1 || $SESS_USERGROUP == 1 || $TMP_PER_ID_REVIEW==$SESS_PER_ID || $TMP_PER_ID_REVIEW0==$SESS_PER_ID || $TMP_PER_ID_REVIEW1==$SESS_PER_ID || $TMP_PER_ID_REVIEW2==$SESS_PER_ID) { if ($TOTAL_SCORE) $RESULT = number_format($TOTAL_SCORE, 2); else $RESULT = number_format(($data[SUM_KPI] + $data[SUM_COMPETENCE] + $data[SUM_OTHER]), 2); $chk_display=1;/*<<< Release 5.2.1.5*/ } else $RESULT = "***"; $cmd = " select PN_NAME from PER_PRENAME where PN_CODE='$PN_CODE' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_PN_NAME = $data2[PN_NAME]; $PER_FULLNAME = $TMP_PN_NAME . $TMP_PER_NAME . " " . $TMP_PER_SURNAME; $LEVEL_NO = trim($data[LEVEL_NO]); $PER_TYPE = $data[PER_TYPE]; $POS_ID = $data[POS_ID]; $POEM_ID = $data[POEM_ID]; $POEMS_ID = $data[POEMS_ID]; $POT_ID = $data[POT_ID]; $ACCEPT_FLAG = $data[ACCEPT_FLAG]; /*Release 5.2.1.8*/ $cmd = " select LEVEL_NAME, POSITION_LEVEL from PER_LEVEL where LEVEL_NO='$LEVEL_NO' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $LEVEL_NAME = trim($data2[LEVEL_NAME]); $POSITION_LEVEL = $data2[POSITION_LEVEL]; if (!$POSITION_LEVEL) $POSITION_LEVEL = $LEVEL_NAME; if($PER_TYPE == 1){ $cmd = " select POS_NO, POS_NO_NAME, a.ORG_ID, d.ORG_NAME, b.PL_NAME, a.PT_CODE 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 "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd); } $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $POS_NO = $data2[POS_NO]; $POS_NO_NAME = $data2[POS_NO_NAME]; // $TMP_PL_NAME = trim($data2[PL_NAME])?($data2[PL_NAME] . $POSITION_LEVEL . ((trim($data2[PT_NAME]) != "ทั่วไป" && $LEVEL_NO >= 6)?"$data2[PT_NAME]":"")):" ".$LEVEL_NAME; $TMP_PL_NAME = trim($data2[PL_NAME])?($data2[PL_NAME] . $POSITION_LEVEL):" ".$LEVEL_NAME; }elseif($PER_TYPE == 2){ $cmd = " select pp.POEM_NO,pp.POEM_NO_NAME, pl.PN_NAME, po.ORG_NAME 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 "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd); } $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $POS_NO = trim($data2[POEM_NO]); $POS_NO_NAME = trim($data2[POEM_NO_NAME]); $PL_NAME = trim($data2[PN_NAME]); $TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : ""; }elseif($PER_TYPE == 3){ $cmd = " select pp.POEMS_NO, pp.POEMS_NO_NAME, pl.EP_NAME, po.ORG_NAME 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 "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd); } $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $POS_NO = trim($data2[POEMS_NO]); $POS_NO_NAME = trim($data2[POEMS_NO_NAME]); $PL_NAME = trim($data2[EP_NAME]); $TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : ""; }elseif($PER_TYPE == 4){ $cmd = " select pp.POT_NO,pp.POT_NO_NAME, pl.TP_NAME, po.ORG_NAME 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 "; if($SESS_ORG_STRUCTURE==1) { $cmd = str_replace("PER_ORG", "PER_ORG_ASS", $cmd); } $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $POS_NO = trim($data2[POT_NO]); $POS_NO_NAME = trim($data2[POT_NO_NAME]); $PL_NAME = trim($data2[TP_NAME]); $TMP_PL_NAME = (trim($PL_NAME))? "$PL_NAME $LEVEL_NAME" : ""; } // end if unset($ARR_USER_AUTH); if(trim($data[PER_ID])) $ARR_USER_AUTH[] = $data[PER_ID]; if(trim($data[PER_ID_REVIEW])) $ARR_USER_AUTH[] = $data[PER_ID_REVIEW]; if(trim($data[PER_ID_REVIEW0])) $ARR_USER_AUTH[] = $data[PER_ID_REVIEW0]; if(trim($data[PER_ID_REVIEW1])) $ARR_USER_AUTH[] = $data[PER_ID_REVIEW1]; if(trim($data[PER_ID_REVIEW2])) $ARR_USER_AUTH[] = $data[PER_ID_REVIEW2]; $cmd = "select count(KF_ID) as COUNT_KF_ID from PER_PERFORMANCE_GOALS where KF_ID=$TMP_KF_ID "; $count_comdtl = $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $TMP_COUNT_KF_ID = trim($data2[COUNT_KF_ID]); $cmd = " select count(*) as COUNT_1 from PER_KPI_COMPETENCE a, PER_COMPETENCE b where a.CP_CODE = b.CP_CODE and b.DEPARTMENT_ID=$TMP_DEPARTMENT_ID and KF_ID=$TMP_KF_ID and CP_MODEL=1 "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $COUNT_1 = $data2[COUNT_1]+0; $cmd = " select count(*) as COUNT_2 from PER_KPI_COMPETENCE a, PER_COMPETENCE b where a.CP_CODE = b.CP_CODE and b.DEPARTMENT_ID=$TMP_DEPARTMENT_ID and KF_ID=$TMP_KF_ID and CP_MODEL=2 "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $COUNT_2 = $data2[COUNT_2]+0; $cmd = " select count(*) as COUNT_3 from PER_KPI_COMPETENCE a, PER_COMPETENCE b where a.CP_CODE = b.CP_CODE and b.DEPARTMENT_ID=$TMP_DEPARTMENT_ID and KF_ID=$TMP_KF_ID and CP_MODEL=3 "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $COUNT_3 = $data2[COUNT_3]+0; $class = "table_body"; $onmouse_event = " onMouseOver=\"this.className='table_body_over';\" onMouseOut=\"this.className='table_body';\" "; if($KF_ID==$TMP_KF_ID){ $class = "table_body_over"; $onmouse_event = ""; } // end if ?> > = "2557" && $KF_CYCLE >= "1"){ // ปี 2557 ครั้งที่ 1 เป็นต้นไป เปลี่ยนที่เก็บ folder ต่อท้ายด้วย ปีงบประมาณ.ครั้งที่ $FILE_PATH = "../attachments/".$PER_KPI_CARDNO."/PER_ATTACHMENT/KPI".$KF_CYCLE."_".$KF_YEAR."/"; $FILE_PATH_GET = "KPI".$KF_CYCLE."_".$KF_YEAR; }else{ // (ยังเป็น folder เดียวกันหมด ไฟล์เก็บที่เดียวกันหมด ไม่ได้แยก ปี และ รอบไว้***) ปีงบประมาณก่อนหน้า 2557 ครั้งที่ 1 ที่ผ่านมา ยังเป็น folder ชื่อเดียวกัน ทุกปีเก็บไว้ที่เดียวกันหมด $FILE_PATH = "../attachments/".$PER_KPI_CARDNO."/PER_ATTACHMENT/70/"; $FILE_PATH_GET = "70"; } ?> = "2557" && $KF_CYCLE >= "1"){ // ปี 2557 ครั้งที่ 1 เป็นต้นไป เปลี่ยนที่เก็บ folder ต่อท้ายด้วย ปีงบประมาณ.ครั้งที่ $FILE_PATH = "../attachments/".$PER_KPI_CARDNO."/PER_ATTACHMENT/KPI".$KF_CYCLE."_".$KF_YEAR."/"; $FILE_PATH_GET = "KPI".$KF_CYCLE."_".$KF_YEAR; }else{ // (ยังเป็น folder เดียวกันหมด ไฟล์เก็บที่เดียวกันหมด ไม่ได้แยก ปี และ รอบไว้***) ปีงบประมาณก่อนหน้า 2557 ครั้งที่ 1 ที่ผ่านมา ยังเป็น folder ชื่อเดียวกัน ทุกปีเก็บไว้ที่เดียวกันหมด $FILE_PATH = "../attachments/".$PER_KPI_CARDNO."/PER_ATTACHMENT/70/"; $FILE_PATH_GET = "70"; } ?>
ประเมินสมรรถนะ รายงาน ชื่อผู้รับการประเมิน ผลการประเมิน อนุญาตให้เห็นคะแนน รับทราบในการประเมินคะแนน จำนวนสมรรถนะ จำนวนไฟล์
        > >   ไม่รับทราบ';} if($ACCEPT_FLAG==1){echo 'รับทราบ';} }else{ ?> *** ไม่รับทราบ';} if($ACCEPT_FLAG==1){echo 'รับทราบ';} }?>   ">ดูรายละเอียดการประเมินผลการปฏิบัติงาน () ">ดูข้อมูลการประเมินผลการปฏิบัติงาน   ">แก้ไขการประเมินผลการปฏิบัติงาน  ">ลบการประเมินผลการปฏิบัติงาน   ">พิมพ์แบบสรุปการประเมินผลการปฏิบัติราชการ (PDF)   ">พิมพ์แบบสรุปการประเมินผลการปฏิบัติราชการ (RTF)   "><?=$ALT_LOAD_TITLE?>   "><?=$ALT_LOAD_TITLE?>   "><?=$ALT_LOAD_TITLE?>   "><?=$ALT_LOAD_TITLE?>   ">
1"; $cstat=""; ?> "; $cstat=""; ?> 2         > > >   ไม่รับทราบ';} if($ACCEPT_FLAG==1){echo 'รับทราบ';} }else{ ?> *** ไม่รับทราบ';} if($ACCEPT_FLAG==1){echo 'รับทราบ';} }?>   ">ดูรายละเอียดการประเมินผลการปฏิบัติงาน () ">ดูข้อมูลการประเมินผลการปฏิบัติงาน   ">แก้ไขการประเมินผลการปฏิบัติงาน  ">ลบการประเมินผลการปฏิบัติงาน   ">พิมพ์แบบสรุปการประเมินผลการปฏิบัติราชการ (PDF)   ">พิมพ์แบบสรุปการประเมินผลการปฏิบัติราชการ (RTF)   "><?=$ALT_LOAD_TITLE?>   "><?=$ALT_LOAD_TITLE?>   "><?=$ALT_LOAD_TITLE?>   "><?=$ALT_LOAD_TITLE?>   ">
1) : ?>