include("../php_scripts/connect_database.php"); include("../php_scripts/calendar_data.php"); include("php_scripts/personal_kpi.php"); if ($SESS_ORG_STRUCTURE==0 || $SESS_ORG_STRUCTURE==1) $select_org_structure = $SESS_ORG_STRUCTURE; if($SESS_PER_TYPE!=0) { $search_per_type = (isset($search_per_type))? $search_per_type : $SESS_PER_TYPE; } $search_per_type = (isset($search_per_type))? $search_per_type : 1; if ($command == "SEARCHALL") $search_kf_cycle = ""; elseif (!$search_kf_cycle) { $search_kf_cycle = $KPI_CYCLE; if (!$search_kf_cycle) if (substr($UPDATE_DATE,5,2) > "09" || substr($UPDATE_DATE,5,2) < "04") $search_kf_cycle = 1; elseif (substr($UPDATE_DATE,5,2) > "03" && substr($UPDATE_DATE,5,2) < "10") $search_kf_cycle = 2; } 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]"; } 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") { if ($search_per_type==1 || $search_per_type==5) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POS_NO_NAME $SortType[$order_by], iif(isnull(POS_NO),0,POS_NO) $SortType[$order_by]"; elseif ($search_per_type==2) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POEM_NO_NAME $SortType[$order_by], iif(isnull(POEM_NO),0,POEM_NO) $SortType[$order_by]"; elseif ($search_per_type==3) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POEMS_NO_NAME $SortType[$order_by], iif(isnull(POEMS_NO),0,POEMS_NO) $SortType[$order_by]"; elseif ($search_per_type==4) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POT_NO_NAME $SortType[$order_by], iif(isnull(POT_NO),0,POT_NO) $SortType[$order_by]"; }elseif($DPISDB=="oci8"){ if ($search_per_type==1 || $search_per_type==5) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POS_NO_NAME $SortType[$order_by], to_number(replace(POS_NO,'-','')) $SortType[$order_by]"; elseif ($search_per_type==2) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POEM_NO_NAME $SortType[$order_by], to_number(replace(POEM_NO,'-','')) $SortType[$order_by]"; elseif ($search_per_type==3) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POEMS_NO_NAME $SortType[$order_by], to_number(replace(POEMS_NO,'-','')) $SortType[$order_by]"; elseif ($search_per_type==4) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POT_NO_NAME $SortType[$order_by], to_number(replace(POT_NO,'-','')) $SortType[$order_by]"; }elseif($DPISDB=="mysql"){ if ($search_per_type==1 || $search_per_type==5) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POS_NO_NAME $SortType[$order_by], POS_NO+0 $SortType[$order_by]"; elseif ($search_per_type==2) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POEM_NO_NAME $SortType[$order_by], POEM_NO+0 $SortType[$order_by]"; elseif ($search_per_type==3) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POEMS_NO_NAME $SortType[$order_by], POEMS_NO+0 $SortType[$order_by]"; elseif ($search_per_type==4) $order_str = "a.DEPARTMENT_ID $SortType[$order_by]".$org_cond.", POT_NO_NAME $SortType[$order_by], POT_NO+0 $SortType[$order_by]"; } } elseif($order_by==3){ if ($search_per_type==1 || $search_per_type==5) $order_str = "c.ORG_ID $SortType[$order_by]"; elseif ($search_per_type==2) $order_str = "d.ORG_ID $SortType[$order_by]"; elseif ($search_per_type==3) $order_str = "e.ORG_ID $SortType[$order_by]"; elseif ($search_per_type==4) $order_str = "g.ORG_ID $SortType[$order_by]"; } elseif($order_by==4) { $order_str = "TOTAL_SCORE $SortType[$order_by]"; } ?>
if ($UPD) $OPTIONAL_TITLE=" > แก้ไขข้อมูล"; elseif ($VIEW) $OPTIONAL_TITLE=" > ดูข้อมูล"; include("current_location.html"); ?> |