include("../php_scripts/connect_database.php"); include("php_scripts/load_per_control.php"); $db_dpis2 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd); /* echo $CTRL_TYPE."||".$SESS_USERGROUP_LEVEL;*/ switch($CTRL_TYPE){ case 2 : $search_pv_code = $PROVINCE_CODE; $search_pv_name = $PROVINCE_NAME; $PROVINCE_CODE = $PROVINCE_CODE; $PROVINCE_NAME = $PROVINCE_NAME; break; case 3 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $MAIN_MINISTRY_ID = $MINISTRY_ID; $MAIN_MINISTRY_NAME = $MINISTRY_NAME; break; case 4 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $search_department_id = $DEPARTMENT_ID; $search_department_name = $DEPARTMENT_NAME; $MAIN_MINISTRY_ID = $MINISTRY_ID; $MAIN_MINISTRY_NAME = $MINISTRY_NAME; $MAIN_DEPARTMENT_ID = $DEPARTMENT_ID; $MAIN_DEPARTMENT_NAME = $DEPARTMENT_NAME; break; } // end switch case switch($SESS_USERGROUP_LEVEL){ case 2 : $search_pv_code = $PROVINCE_CODE; $search_pv_name = $PROVINCE_NAME; $PROVINCE_CODE = $PROVINCE_CODE; $PROVINCE_NAME = $PROVINCE_NAME; break; case 3 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $MAIN_MINISTRY_ID = $MINISTRY_ID; $MAIN_MINISTRY_NAME = $MINISTRY_NAME; break; case 4 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $search_department_id = $DEPARTMENT_ID; $search_department_name = $DEPARTMENT_NAME; $MAIN_MINISTRY_ID = $MINISTRY_ID; $MAIN_MINISTRY_NAME = $MINISTRY_NAME; $MAIN_DEPARTMENT_ID = $DEPARTMENT_ID; $MAIN_DEPARTMENT_NAME = $DEPARTMENT_NAME; break; case 5 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $search_department_id = $DEPARTMENT_ID; $search_department_name = $DEPARTMENT_NAME; $search_org_id = $ORG_ID; $search_org_name = $ORG_NAME; $MAIN_MINISTRY_ID = $MINISTRY_ID; $MAIN_MINISTRY_NAME = $MINISTRY_NAME; $MAIN_DEPARTMENT_ID = $DEPARTMENT_ID; $MAIN_DEPARTMENT_NAME = $DEPARTMENT_NAME; $MAIN_ORG_ID = $ORG_ID; $MAIN_ORG_NAME = $ORG_NAME; break; case 6 : $search_ministry_id = $MINISTRY_ID; $search_ministry_name = $MINISTRY_NAME; $search_department_id = $DEPARTMENT_ID; $search_department_name = $DEPARTMENT_NAME; $search_org_id = $ORG_ID; $search_org_name = $ORG_NAME; $search_org_id_1 = $ORG_ID_1; $search_org_name_1 = $ORG_NAME_1; $MAIN_MINISTRY_ID = $MINISTRY_ID; $MAIN_MINISTRY_NAME = $MINISTRY_NAME; $MAIN_DEPARTMENT_ID = $DEPARTMENT_ID; $MAIN_DEPARTMENT_NAME = $DEPARTMENT_NAME; $MAIN_ORG_ID = $ORG_ID; $MAIN_ORG_NAME = $ORG_NAME; break; } // end switch case /*ใบลา*/ $Stextyear = ($tmpyear-543)."-".substr("0".$tmpmonth,-2); $tmpdate = " AND '$Stextyear' between substr(abs.ABS_STARTDATE,1,7) AND substr(abs.ABS_ENDDATE,1,7) "; $cmdabs = " select count(abs.ABS_ID) as ANTABS from PER_ABSENT abs left join PER_PERSONAL a on(a.PER_ID=abs.PER_ID) where a.ORG_ID=$tmporg_id AND ((abs.APPROVE_FLAG = 0 or abs.APPROVE_FLAG is null) AND abs.CANCEL_FLAG=0 ) $tmpdate AND abs.PER_ID not in(select PER_ID from TA_SET_EXCEPTPER where END_DATE IS NULL AND CANCEL_FLAG=1)"; $db_dpis2->send_cmd($cmdabs); $dataabs = $db_dpis2->get_array(); $antabs = $dataabs[ANTABS]; /*คำร้อง*/ $cmdreq = " select count(abs.REC_ID) as ANTREG from TA_REQUESTTIME abs left join PER_PERSONAL a on(a.PER_ID=abs.PER_ID) where a.ORG_ID=$tmporg_id AND abs.APPROVE_FLAG=0 AND substr(abs.REQUEST_DATE,1,7)='$Stextyear' "; $db_dpis2->send_cmd($cmdreq); $datareq = $db_dpis2->get_array(); $antreq = $datareq[ANTREG]; ?>