include("../php_scripts/connect_database.php");
include("php_scripts/session_start.php");
include("php_scripts/function_share.php");
include("php_scripts/function_list.php");
include("php_scripts/load_per_control.php");
$db_dpis1 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd);
$db_dpis2 = new connect_dpis($dpisdb_host, $dpisdb_name, $dpisdb_user, $dpisdb_pwd);
switch($CTRL_TYPE){
case 2 :
$PV_CODE = $PROVINCE_CODE;
$PV_NAME = $PROVINCE_NAME;
break;
case 3 :
$ORG_ID_M1 = $MINISTRY_ID;
$ORG_NAME_M1 = $MINISTRY_NAME;
break;
case 4 :
$ORG_ID_M1 = $MINISTRY_ID;
$ORG_NAME_M1 = $MINISTRY_NAME;
$ORG_ID_M2 = $DEPARTMENT_ID;
$ORG_NAME_2 = $DEPARTMENT_NAME;
break;
} // end switch case
switch($SESS_USERGROUP_LEVEL){
case 2 :
$PV_CODE = $PROVINCE_CODE;
$PV_NAME = $PROVINCE_NAME;
break;
case 3 :
$ORG_ID_M1 = $MINISTRY_ID;
$ORG_NAME_M1 = $MINISTRY_NAME;
break;
case 4 :
$ORG_ID_M1 = $MINISTRY_ID;
$ORG_NAME_M1 = $MINISTRY_NAME;
$ORG_ID_M2 = $DEPARTMENT_ID;
$ORG_NAME_2 = $DEPARTMENT_NAME;
break;
case 5 :
$ORG_ID_M1 = $MINISTRY_ID;
$ORG_NAME_M1 = $MINISTRY_NAME;
$ORG_ID_M2 = $DEPARTMENT_ID;
$ORG_NAME_2 = $DEPARTMENT_NAME;
$ORG_ID_M3 = $ORG_ID;
$ORG_NAME_3 = $ORG_NAME;
break;
case 6 :
$ORG_ID_M1 = $MINISTRY_ID;
$ORG_NAME_M1 = $MINISTRY_NAME;
$ORG_ID_M2 = $DEPARTMENT_ID;
$ORG_NAME_2 = $DEPARTMENT_NAME;
$ORG_ID_M3 = $ORG_ID;
$ORG_NAME_3 = $ORG_NAME;
$ORG_ID_M4 = $ORG_ID_1;
$ORG_NAME_4 = $ORG_NAME_1;
break;
} // end switch case
if(!isset($show_topic)) $show_topic = 1;
if( !$current_page ) $current_page = 1;
if(!$data_per_page) $data_per_page = 30;
$start_record = ($current_page - 1) * $data_per_page;
if(!$PER_TYPE_SEARCH) $PER_TYPE_SEARCH = 1;
if(!$PER_TYPE) $PER_TYPE=1;
$UPDATE_DATE = date("Y-m-d H:i:s");
if($show_topic==1){ // data_promote_e_p_inquire_search.html [ ค้นหาข้อมูล ]
if ($PER_TYPE_SEARCH == 1) {
$field = "PRO_DATE as PDATE, POS_ID as PID";
$table = "PER_PROMOTE_P";
$cmd_position = " select POS_NO as PNO,POS_NO_NAME as PNONAME, a.PL_CODE as PCODE,PL_NAME as PNAME from PER_POSITION a, PER_LINE b
where a.PL_CODE=b.PL_CODE and POS_ID=";
$field_limit_data = "(PRO_DATE + POS_ID + PER_ID)";
$orderby = "PRO_DATE, POS_ID";
if (trim($POS_POEM_ID_SEARCH)) $arr_search_condition[] = "(POS_ID = $POS_POEM_ID_SEARCH)";
} elseif ($PER_TYPE_SEARCH == 2) {
$field = "PRO_DATE as PDATE, POEM_ID as PID";
$table = "PER_PROMOTE_E";
$cmd_position = " select POEM_NO as PNO, POEM_NO_NAME as PNONAME, a.PN_CODE as PCODE, PN_NAME as PNAME from PER_POS_EMP a, PER_POS_NAME b
where a.PN_CODE=b.PN_CODE and POEM_ID=";
$field_limit_data = "(PRO_DATE + POEM_ID + PER_ID)";
$orderby = "PRO_DATE, POEM_ID";
if (trim($POS_POEM_ID_SEARCH)) $arr_search_condition[] = "(POEM_ID = $POS_POEM_ID_SEARCH)";
} elseif ($PER_TYPE_SEARCH == 3) {
$field = "PRO_DATE as PDATE, POEMS_ID as PID";
$table = "PER_PROMOTE_E";
$cmd_position = " select POEMS_NO as PNO,POEMS_NO_NAME as PNONAME, a.EP_CODE as PCODE,EP_NAME as PNAME from PER_POS_EMPSER a, PER_EMPSER_POS_NAME b
where a.EP_CODE=b.EP_CODE and POEM_ID=";
$field_limit_data = "(PRO_DATE + POEMS_ID + PER_ID)";
$orderby = "PRO_DATE, POEM_ID";
if (trim($POS_POEM_ID_SEARCH)) $arr_search_condition[] = "(POEMS_ID = $POS_POEM_ID_SEARCH)";
} elseif ($PER_TYPE_SEARCH == 4) {
$field = "PRO_DATE as PDATE, POT_ID as PID";
$table = "PER_PROMOTE_E";
$cmd_position = "select POT_NO as PNO,POT_NO_NAME as PNONAME, a.TP_CODE as PCODE,TP_NAME as PNAME from PER_POS_TEMP a, PER_TEMP_POS_NAME b
where a.TP_CODE=b.TP_CODE and POT_ID=";
$field_limit_data = "(PRO_DATE + POT_ID + PER_ID)";
$orderby = "PRO_DATE, POT_ID";
if (trim($POS_POEM_ID_SEARCH)) $arr_search_condition[] = "(POT_ID = $POS_POEM_ID_SEARCH)";
}
if (trim($PRO_DATE_START)) {
$temp = explode("/", $PRO_DATE_START);
$temp_date = ($temp[2] - 543) ."-". $temp[1] ."-". $temp[0];
$arr_search_condition[] = "(PRO_DATE > '$temp_date')";
}
if (trim($PRO_DATE_END)) {
$temp = explode("/", $PRO_DATE_END);
$temp_date = ($temp[2] - 543) ."-". $temp[1] ."-". $temp[0];
$arr_search_condition[] = "(PRO_DATE < '$temp_date')";
}
if($DEPARTMENT_ID){
$arr_search_condition[] = "(DEPARTMENT_ID=$DEPARTMENT_ID)";
}elseif($MINISTRY_ID){
$cmd = " select ORG_ID from PER_ORG where ORG_ID_REF=$MINISTRY_ID ";
$db_dpis->send_cmd($cmd);
while($data=$db_dpis->get_array()) $arr_org[] = $data[ORG_ID];
$arr_search_condition[] = "(DEPARTMENT_ID in (". implode(",", $arr_org) ."))";
}elseif($PV_CODE){
$cmd = " select distinct ORG_ID_REF from PER_ORG where OL_CODE='03' and PV_CODE='$PV_CODE' ";
$db_dpis->send_cmd($cmd);
while($data = $db_dpis->get_array()) $arr_org[] = $data[ORG_ID_REF];
$arr_search_condition[] = "(DEPARTMENT_ID in (". implode(",", $arr_org) ."))";
} // end if
$search_condition = "";
if ($arr_search_condition) $search_condition = "where " . implode(" and ", $arr_search_condition);
$cmd =" select distinct $field from $table $search_condition ";
$count_data = $db_dpis->send_cmd($cmd);
//echo "%%%%".$cmd;
//$db_dpis->show_error();
$total_page = ceil( $count_data / $data_per_page );
$page_link = create_link_page($total_page, $current_page);
$limit_data = "";
if($command=="CANCEL"){
//เคลียร์ค่าเมื่อกดแท็บ เพิ่ม ใหม่
$PRO_DATE="";
$POS_POEM_NO="";
$POS_POEM_NO_NAME="";
$POS_POEM_NAME="";
$PL_PN_NAME="";
$PL_PN_CODE="";
$LEVEL_START=0;
$LEVEL_END=0;
$EN_NAME="";
$EN_CODE="";
$YEAR_START="";
$YEAR_END="";
$SAL_START="";
$SAL_END="";
}
}else if($show_topic==2){
// กรณีที่เป็นการค้นหาข้อมูลที่ส่งมาจาก tab1 หรือ data_promote_e_p_quality (p0309 เดิม)
if ($firstfrom=="data_promote_e_p_quality" && $POS_POEM_ID && $PRO_DATE && $table_select && $command && $PER_TYPE) {
echo "";
}
include("php_scripts/data_promote_e_p_inquire.php");
// echo ">>>POS_POEM_NO=$POS_POEM_NO, POS_POEM_NAME=$POS_POEM_NAME, PRO_DATE=$PRO_DATE, table_select=$table_select, command=$command, PER_TYPE=$PER_TYPE, firstfrom=$firstfrom, DEPARTMENT_ID=$DEPARTMENT_ID
";
// ==================== select จากเงื่อนไขสำหรับผู้ที่มีคุณสมบัติได้เลื่อนระดับ ======================
if ($command == "SEARCH") {
include("php_scripts/data_promote_e_p_inquire_query_search.php");
}
// ==================== select จากข้อมูลที่บันทึกไว้ใน PER_PROMOTE..... =====================
if ($command == "SELECT") {
include("php_scripts/data_promote_e_p_inquire_query_select.php");
}
// echo "data_promote_e_p_inquire.html :: command=$command || table=$table || PER_TYPE=$PER_TYPE || UPD=$UPD
cmd_save=$cmd_save
";
} // end show_topic
// echo "$show_topic // data_promote_e_p_inquire.html :: command=$command || table=$table || PER_TYPE=$PER_TYPE || UPD=$UPD
cmd_save=$cmd_save
";
?>
=$webpage_title?> - =$MENU_TITLE_LV0?> - =$MENU_TITLE_LV1?>}?>
if (!$HEAD_HIDE) { ?>
|
if ($UPD) $OPTIONAL_TITLE.=" > แก้ไขข้อมูล"; elseif ($VIEW) $OPTIONAL_TITLE.=" > ดูข้อมูล";
include("current_location.html");
?> |
} ?>
|
|
include("jqModalDialog.html");
?>