include("../php_scripts/connect_database.php"); include("php_scripts/es_t0206_inout_list.php"); if(empty($SUBMITTED_DATE_SAVE)) { $SUBMITTED_DATE_SAVE = $temp_date[2]."/". $temp_date[1] ."/". ($temp_date[0] + 543); } if(empty($search_abs_approve)){ $search_abs_approve="0";} if(!$PER_TYPE){ $PER_TYPE=1; } if(empty($WC_CODE)){ $cmd = " select WC_CODE from PER_WORK_CYCLE where WC_START='0830' "; $db_dpis2->send_cmd($cmd); $data2 = $db_dpis2->get_array(); $WC_CODE= $data2[WC_CODE]; } if(!$sort_by) $sort_by=3; $sort_type = (isset($sort_type))? $sort_type : "3:desc"; $arrSort=explode(":",$sort_type); $SortType[$arrSort[0]] =$arrSort[1]; if(!$order_by) $order_by=3; //หาว่าอยู่กลุ่ม กจ. กรม หรือไม่-------------------------------- $cmd4 = " select b.CODE from user_detail a, user_group b where a.group_id=b.id AND a.ID=".$SESS_USERID; $db_dpis2->send_cmd($cmd4); $data4 = $db_dpis2->get_array(); if ($data4[CODE]) { $NAME_GROUP_HRD = $data4[CODE]; }else{ $NAME_GROUP_HRD = ""; } /*ดูสิทธิ์เป็นผู้ตรวจสอบการลาหรือไม่*/ if ( ($SESS_USERGROUP !=1 && $NAME_GROUP_HRD!='HRD') && count($SESS_AuditArray) == 0 ){ $PER_AUDIT_FLAG=0; }else if ( ($SESS_USERGROUP !=1 && $NAME_GROUP_HRD!='HRD') && count($SESS_AuditArray) > 0 ){ $PER_AUDIT_FLAG=1; } if($NAME_GROUP_HRD=="HRD" || $SESS_USERGROUP ==1){ if(!$Submit3 && !$image22){ $select_org_structure=1; } }else{ if ( ($SESS_USERGROUP !=1 && $NAME_GROUP_HRD!='HRD') && $PER_AUDIT_FLAG==1 ){ $select_org_structure=1; } } $search_condition =""; if ($SESS_USERGROUP !=1 && $NAME_GROUP_HRD!='HRD'){ if ( ($SESS_USERGROUP !=1 && $NAME_GROUP_HRD!='HRD') && $PER_AUDIT_FLAG==1 ){ $Consearch =""; $tCon="("; for ($i=0; $i < count($SESS_AuditArray); $i++) { if ($i>0) $tCon .= " or "; $tCon .= "(B.ORG_ID=" .$SESS_AuditArray[$i][0]; $tCon .= ")"; } $tCon .= ")"; $Consearch .= " or (".$tCon.") "; $search_condition .= " AND ( 1=1 AND A.PER_ID = $SESS_PER_ID or A.ALLOW_USER = $SESS_PER_ID or A.APPROVE_USER = $SESS_PER_ID or A.CREATE_USER=$SESS_USERID ".$Consearch.")"; }else{ if ($SESS_PER_ID ){ if($search_onlyme_flag==1){ $search_condition .= " AND (2=2 AND A.PER_ID = $SESS_PER_ID)"; }else{ $search_condition .= " AND (3=3 AND A.PER_ID = $SESS_PER_ID or A.ALLOW_USER = $SESS_PER_ID or A.APPROVE_USER = $SESS_PER_ID)"; } } } } if($SESS_USERGROUP==1 || $NAME_GROUP_HRD=='HRD'){ if($search_org_id){ if($select_org_structure==0) $search_condition .= " AND (D.ORG_ID=$search_org_id or E.ORG_ID=$search_org_id or F.ORG_ID=$search_org_id or G.ORG_ID=$search_org_id)"; if($select_org_structure==1) $search_condition .= " AND (B.ORG_ID=$search_org_id)"; }elseif($search_department_id){ $search_condition .= " AND (B.DEPARTMENT_ID = $search_department_id)"; }elseif($search_ministry_id){ $cmd = " select ORG_ID from PER_ORG where ORG_ID_REF=$search_ministry_id and OL_CODE='02' "; if($SESS_ORG_STRUCTURE==1){ $cmd = str_replace("PER_ORG","PER_ORG_ASS",$cmd); } $db_dpis->send_cmd($cmd); while($data = $db_dpis->get_array()) $arr_org[] = $data[ORG_ID]; $search_condition .= " AND (B.DEPARTMENT_ID in (". implode(",", $arr_org) ."))"; } // end if }else if($PER_AUDIT_FLAG==1){ if($search_org_id){ $search_condition .= " AND (B.ORG_ID=$search_org_id)"; } } if ($search_per_type !=0){ $search_condition .= " AND (A.PER_TYPE = $search_per_type)"; } if ($search_abs_startdate && $search_abs_enddate) { $temp_date = explode("/", $search_abs_startdate); $temp_start = ($temp_date[2] - 543) ."-". $temp_date[1] ."-". $temp_date[0]; $temp_date = explode("/", $search_abs_enddate); $temp_end = ($temp_date[2] - 543) ."-". $temp_date[1] ."-". $temp_date[0]; $search_condition .= " AND (A.REQUEST_DATE >= '$temp_start' and A.REQUEST_DATE <= '$temp_end')"; }else if ($search_abs_startdate && !$search_abs_enddate) { $temp_date = explode("/", $search_abs_startdate); $temp_start = ($temp_date[2] - 543) ."-". $temp_date[1] ."-". $temp_date[0]; $search_condition .= " AND (A.REQUEST_DATE = '$temp_start' )"; }else if (!$search_abs_startdate && $search_abs_enddate) { $temp_date = explode("/", $search_abs_enddate); $temp_end = ($temp_date[2] - 543) ."-". $temp_date[1] ."-". $temp_date[0]; $search_condition .= " AND (A.REQUEST_DATE = '$temp_end' )"; } if ($search_SUBMITTED_STARTDATE && $search_SUBMITTED_ENDDATE) { $temp_date = explode("/", $search_SUBMITTED_STARTDATE); $temp_start = ($temp_date[2] - 543) ."-". $temp_date[1] ."-". $temp_date[0]; $temp_date = explode("/", $search_SUBMITTED_ENDDATE); $temp_end = ($temp_date[2] - 543) ."-". $temp_date[1] ."-". $temp_date[0]; $search_condition .= " AND (A.SUBMITTED_DATE >= '$temp_start' and A.SUBMITTED_DATE <= '$temp_end')"; }else if ($search_SUBMITTED_STARTDATE && !$search_SUBMITTED_ENDDATE) { $temp_date = explode("/", $search_SUBMITTED_STARTDATE); $temp_start = ($temp_date[2] - 543) ."-". $temp_date[1] ."-". $temp_date[0]; $search_condition .= " AND (A.SUBMITTED_DATE = '$temp_start' )"; }else if (!$search_SUBMITTED_STARTDATE && $search_SUBMITTED_ENDDATE) { $temp_date = explode("/", $search_SUBMITTED_ENDDATE); $temp_end = ($temp_date[2] - 543) ."-". $temp_date[1] ."-". $temp_date[0]; $search_condition .= " AND (A.SUBMITTED_DATE = '$temp_end' )"; } if($search_abs_approve==0){ $search_condition .= " AND (A.APPROVE_FLAG = 0 or A.APPROVE_FLAG is null)"; } else if($search_abs_approve !=0 && $search_abs_approve !=4){ $search_condition .= " AND (A.APPROVE_FLAG =$search_abs_approve)"; } if($search_Request_Type !=0){ if($search_Request_Type ==1){ $search_condition .= " AND (A.MEETING_FLAG =1)"; }else if($search_Request_Type ==2){ $search_condition .= " AND (A.SCAN_FLAG =1)"; }else if($search_Request_Type ==3){ $search_condition .= " AND (A.OTH_FLAG =1)"; }else if($search_Request_Type ==4){ $search_condition .= " AND (A.REQUEST_NOTE =1)"; }else if($search_Request_Type ==5){ $search_condition .= " AND (A.REQ_TIME =1)"; } } if(trim($search_per_name)) $search_condition .= " AND (B.PER_NAME like '$search_per_name%')"; if(trim($search_per_surname)) $search_condition .= " AND (B.PER_SURNAME like '$search_per_surname%')"; $cmd =" SELECT A.REC_ID FROM TA_REQUESTTIME A,PER_PERSONAL B, PER_POSITION D, PER_POS_EMP E, PER_POS_EMPSER F, PER_POS_TEMP G WHERE A.PER_ID=B.PER_ID (+) AND B.POS_ID=D.POS_ID(+) AND B.POEM_ID=E.POEM_ID(+) AND B.POEMS_ID=F.POEMS_ID(+) AND B.POT_ID=G.POT_ID(+) $search_condition "; $count_data = $db_dpis->send_cmd($cmd); //$db_dpis->show_error(); $total_page = ceil( $count_data / $data_per_page ); $page_link = create_link_page($total_page, $current_page); $limit_data = ""; ?>
include("header_menu.html");?> |
if ($UPD) $OPTIONAL_TITLE=" > แก้ไขข้อมูล"; include("current_location.html"); ?> |