include("../php_scripts/connect_database.php"); //new class connect oci8 for row_back include("../php_scripts/connect_oci8_stand_alone.php"); include("php_scripts/alter_table.php"); if($db_type=="mysql") { include("php_scripts/alter_table_mysql.php"); } include("php_scripts/chk_alter_table.php"); /*Release 5.2.1.19*/ $isCloseOption = 0; /* 0=ปิด ,1=เปิด */ /*ตรวจสอบเรื่องกาติดตั้ง ความเชี่ยวชาญ*/ $CNT_SP=0; $cmdChk =" SELECT COUNT(*)AS CNT FROM user_tables WHERE UPPER(TABLE_NAME) = 'PER_SPECIAL_SKILLMIN' "; $db_dpis->send_cmd($cmdChk); $dataChk = $db_dpis->get_array(); if($dataChk[CNT]=="0"){ $CNT_SP += 1; }else{ $CNT_SP += 0; } $cmdChk =" SELECT COUNT(*)AS CNT FROM user_tables WHERE UPPER(TABLE_NAME) = 'PER_MAPPING_SKILLMIN' "; $db_dpis->send_cmd($cmdChk); $dataChk = $db_dpis->get_array(); if($dataChk[CNT]=="0"){ $CNT_SP += 1; }else{ $CNT_SP += 0; } $cmdChk = "SELECT COUNT(*)AS CNT FROM user_tables WHERE UPPER(TABLE_NAME) = 'PER_LEVELSKILL'"; $db_dpis->send_cmd($cmdChk); $dataChk = $db_dpis->get_array(); if($dataChk[CNT]=="0"){ $CNT_SP += 1; }else{ $CNT_SP += 0; } $cmdChk =" SELECT COUNT(COLUMN_NAME) AS CNT FROM USER_TAB_COLS WHERE TABLE_NAME = 'PER_SPECIAL_SKILLGRP' AND UPPER(COLUMN_NAME) IN('REF_CODE')"; $db_dpis->send_cmd($cmdChk); $dataChk = $db_dpis->get_array(); if($dataChk[CNT]=="0"){ $CNT_SP += 1; }else{ $CNT_SP += 0; } $cmdChk =" SELECT COUNT(COLUMN_NAME) AS CNT FROM USER_TAB_COLS WHERE TABLE_NAME = 'GMIS_GPIS' AND UPPER(COLUMN_NAME) IN('TEMPMPERSPSKILL1','TEMPSPERSPSKILL1','TEMPSKILLLEVEL1','TEMPPERSPSKILLDES1', 'TEMPMPERSPSKILL2','TEMPSPERSPSKILL2','TEMPSKILLLEVEL2','TEMPPERSPSKILLDES2', 'TEMPMPERSPSKILL3','TEMPSPERSPSKILL3','TEMPSKILLLEVEL3','TEMPPERSPSKILLDES3')"; $db_dpis->send_cmd($cmdChk); $dataChk = $db_dpis->get_array(); if($dataChk[CNT]=="0"){ $CNT_SP += 1; }else{ $CNT_SP += 0; } //$CNT_SP=1;// ลบก่อนส่ง $CNT_MENU=0; if($CNT_SP=="0"){ $sql="SELECT MENU_LABEL FROM BACKOFFICE_MENU_BAR_LV2 WHERE linkto_web ='master_table_special_skillmin.html?table=PER_SPECIAL_SKILLMIN'"; $count_menu= $db_dpis->send_cmd($sql); if(!$count_menu){ $CNT_MENU+=1; } $sql="SELECT MENU_LABEL FROM BACKOFFICE_MENU_BAR_LV2 WHERE linkto_web ='master_table.html?table=PER_LEVELSKILL'"; $count_menu= $db_dpis->send_cmd($sql); if(!$count_menu){ $CNT_MENU+=1; } } //$CNT_MENU=1;// ลบก่อนส่ง /**/ ?>
if ($UPD) $OPTIONAL_TITLE=" > แก้ไขข้อมูล"; elseif ($VIEW) $OPTIONAL_TITLE=" > ดูข้อมูล"; include("current_location.html"); ?> |