Viewing file: TrainingShow.php (12.44 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
";
echo " กรุณาทำการ Login ก่อน ";
echo "";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../includes/Function.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = "project_type_tb";
$myTable3 = "projectstdplan_tb";
$myTalbleOrder = "Orderlist";
$myTableField1 = "Orderlist";
$myTableField2 = "Project_plan";
$myTableField3 = "Faculty_code";
$query = " SELECT * FROM $myTable2 Where Budget_Year='$Budget_Year' and Flag='Y' ";
$result0 = $dbObj->execQuery($query);
$rs0 = $dbObj->fetchArray($result0);
/** Paging */
$page = $_GET['page'];
if( $page == "" ) { $page = 1; }
/** จำนวนข้อมูล ต่อ 1 หน้า */
$perpage = $_REQUEST['perpage'];
if( $perpage == "" ) { $perpage = 20; }
/** Searching */
$keyword = trim( $_REQUEST['keyword'] );
$selectType = $_REQUEST['selectType'];
/* Parameters **/
$params = "Budget_Year=$Budget_Year&Flag=$Flag";
/** Config Paging */
if($perpage == "") $limit = $_Config_limit;
else $limit = $perpage;
$scroll = $_Config_scroll;
/** ตั้งค่า Default สำหรับการทำ Order By */
if( $OrderBy == "" ) { $OrderBy = $myTalbleOrder; }
if( !isset($_GET['ASCDESC']) ) { $ASCDESC = "ASC"; }
if( $_GET['ASCDESC'] == "ASC" ) { $ASCDESC = "DESC"; }
elseif( $_GET['ASCDESC'] == "DESC" ) { $ASCDESC = "ASC"; }
/** Query เพื่อหา Numrows ก่อน */
if( $keyword != "" ){
$query = "SELECT * FROM project_type_tb LEFT JOIN faculty_tb ON project_type_tb.Faculty_code = faculty_tb.Faculty_code LEFT JOIN money_source_tb ON project_type_tb.MoneyS_C = money_source_tb.MoneyS_C WHERE Budget_Year = '$Budget_Year' AND Flag = 'Y' and (Orderlist LIKE '%$keyword%' OR Project_plan LIKE '%$keyword%') ORDER BY Orderlist";
}
else {
$query = "SELECT * FROM project_type_tb LEFT JOIN faculty_tb ON project_type_tb.Faculty_code = faculty_tb.Faculty_code LEFT JOIN money_source_tb ON project_type_tb.MoneyS_C = money_source_tb.MoneyS_C WHERE Budget_Year='$Budget_Year' AND Flag='Y' ORDER BY Orderlist";
}
$result = $dbObj->execQuery($query);
$numrows = $dbObj->_numrows;
/** Paging */
$display = (!isset ($_GET['page'])) ? 1 : $_GET['page'];
$start = ( ($display * $limit) - $limit );
/** Paging */
$query .= " LIMIT $start, $limit ";
$result = $dbObj->execQuery($query);
} # else
?>
ข้อมูลฝ่ายบริหาร : รายงานบุคลากร - จำนวนครุภัณฑ์ จำแนกตามรายหน่วยงาน - ข้อมูลครุภัณฑ์หน่วยงาน
|