Viewing file: ExcelAccTypeName.php (5.29 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 */
$myTable = "accessories_tb";
$myTable1 ="accessories_type_tb";
$myTablePK = "code";
$myTalbleOrder = "Date_buy";
$myTableField1 = "Acc_code";
$myTableField2 = "Acc_name";
$myTableField3 = "Date_buy";
$query = " SELECT * FROM $myTable WHERE Acc_type_code ='$Acc_type_code' Order By Date_buy ASC ";
$result = $dbObj->execQuery($query);
} # else
?>
=$_Config_sitename;?>
No |
รหัส |
ชื่ออุปกรณ์ / ยี่ห้อ |
ปีที่ซื้อ |
วันหมดอายุ |
ราคา (บาท) |
fetchArray($result) ) {
if( $keyword != "" ) {
$Acc_code = eregi_replace( $keyword, "\\0", $rs['Acc_code'] );
$Acc_name = eregi_replace( $keyword, "\\0", $rs['Acc_name'] );
} else {
$Acc_code = $rs['Acc_code'];
$Acc_name = $rs['Acc_name'];
}
$bgColor = ( $bgColor == "#FFFFFF" ) ? "#F9FBFB" : "#FFFFFF";
?>
=$no;?> |
=$Acc_code;?>
=$Acc_name;?>
|
|
execQuery($query);
$rss = $dbObj->fetchArray($result1);
$sday = $rs['Date_buy'];
$yearthai = explode( "-", $sday );
$day = intval( $yearthai[2] );
$month = intval( $yearthai[1] );
$year = intval( $yearthai[0] )+ $rss ['Year'];
$m = getThaiSubMonth( $month );
echo $day ." ". $m ." ". $year;
?>
|
|
freeresult($result1);
?>
|
execQuery($query6);
$rs6 = $dbObj->fetchArray($result6);
$dbObj->freeresult($rs6);
echo "". number_format($rs6['Sum'],2,'.',',') ."";
?>
|
freeresult($result);
$dbObj->freeresult($result0);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |