include("../php_scripts/connect_database.php");
include("../php_scripts/calendar_data.php");
include("php_scripts/kpi_kpi_form.php");
//หาไอดีผู้ประเมิน
$cmd ="SELECT b.PER_NAME,b.PER_SURNAME,b.PER_CARDNO,a.PER_ID_REVIEW,b.PER_ID
FROM PER_KPI_FORM a, PER_PERSONAL b where
a.PER_ID_REVIEW = b.PER_ID and a.PER_ID_REVIEW = $SESS_PER_ID";
$db_dpis->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);
?>
$OPTIONAL_TITLE="".(($HIDE_HEADER)?"ข้อมูลkpi รายบุคคล":"") ; if ($UPD) $OPTIONAL_TITLE.=" > แก้ไขข้อมูล"; elseif ($VIEW) $OPTIONAL_TITLE.=" > ดูข้อมูล"; include("current_location.html"); ?> |