include_once("incConn.php");
session_start();
$conn = mysql_connect($server, $db_user, $db_pass) or die ("�������ö�Դ��Ͱҹ��������");
mysql_select_db( $database, $conn ) or die ( "�������ö�Դ��Ͱҹ������ $database ��" );
$timecheck = date("d/m/Y");
if (isset($_SESSION["Logon"])) {
$strSQL = "SELECT * FROM tbuser WHERE UserID='".$_SESSION["UserID"]."'";
$charset = "SET NAMES 'tis620' ";
mysql_query($charset);
$result = mysql_query( $strSQL, $conn );
$total = mysql_num_rows($result);
if($total!=0){
while ( $array = mysql_fetch_array( $result ) ){
$UsernameDB = $array['UserName'];
$UserPasswordDB = $array['UserPassword'];
$UserFullName = $array['UserFullname'];
$UserDivision = $array['UserDivision'];
}
}
}
?>
require("icc-header.php"); ?>
|
$docid = $_GET['docid'];
$strSQL = "SELECT * FROM tbdoc WHERE DocID='".$docid."'";
$charset = "SET NAMES 'tis620' ";
mysql_query($charset);
$result = mysql_query( $strSQL, $conn );
$total = mysql_num_rows($result);
if($total!=0){
while ( $array = mysql_fetch_array( $result ) ){
$DocID = $array['DocID'];
$DocStartDate = $array['DocStartDate'];
$DocStopDate = $array['DocStopDate'];
$DocAddTime = $array['DocAddTime'];
$DocTopic = $array['DocTopic'];
$DocDetail = $array['DocDetail'];
$DocURL = $array['DocURL'];
$DocCoverURL = $array['DocCoverURL'];
$DocUserID = $array['DocUserID'];
$DocStatusUpdateIcon = $array['DocStatusUpdateIcon'];
$DocStatusUpdateIcon_AddTime = $array['DocStatusUpdateIcon_AddTime'];
$Doc_img0 = $array['Doc_Img0'];
$Doc_img1 = $array['Doc_Img1'];
$Doc_img2 = $array['Doc_Img2'];
$Doc_img3 = $array['Doc_Img3'];
$date_array = explode("/",$DocStopDate);
$date_array1 = explode("/",$timecheck);
$var_year = intval($date_array[2]) - 543;
$var_month = intval($date_array[1]);
$var_day = intval($date_array[0]);
$var_year1 = $date_array1[2];
$var_month1 = $date_array1[1];
$var_day1 = $date_array1[0];
$var_timestamp = mktime(0,0,0,$var_month,$var_day,$var_year);
$var_timestamp1 = mktime(0,0,0,$var_month1,$var_day1,$var_year1);
$date_array2 = explode("/",substr($DocAddTime,0,10));
$var_day2 = intval($date_array2[0])+2;
$var_year2 = $date_array2[2];
$var_month2 = $date_array2[1];
$var_timestamp2 = mktime(0,0,0,$var_month2,$var_day2,$var_year2);
$date_array3 = explode("/",substr($DocStatusUpdateIcon_AddTime,0,10));
$var_day3 = intval($date_array3[0])+2;
$var_year3 = $date_array3[2];
$var_month3 = $date_array3[1];
$var_timestamp3 = mktime(0,0,0,$var_month3,$var_day3,$var_year3);
//if($var_timestamp1 < $var_timestamp) {
// echo $var_timestamp1." | ".$var_timestamp;
?>
 |
|
 |
|

echo " ".$DocTopic."";
if($var_timestamp1 < $var_timestamp2) {
echo "  ";
}
if(($DocStatusUpdateIcon=="1")&&($var_timestamp1 < $var_timestamp3)){
echo "  ";
}
?>
|
echo $DocDetail;
?>
|
if($Doc_img0!="") {
?>

} else {
?>
}
?>
|
if($Doc_img1!="") {
?>

} else {
?>
}
?>
|
if($Doc_img2!="") {
?>

} else {
?>
}
?>
|
if($Doc_img3!="") {
?>

} else {
?>
}
?>
|
|
by
$strSQL = "SELECT * FROM tbuser WHERE UserID=".$DocUserID;
$charset = "SET NAMES 'tis620' ";
mysql_query($charset);
$resultdoc = mysql_query( $strSQL, $conn );
while ($row = mysql_fetch_row($resultdoc)) {
$UserFullname = $row[3];
echo $UserFullname;
}
?>
[
echo $DocStartDate;
?>
]
if (isset($_SESSION["Logon"])) {
?>
| edit | del |
}
?>
|
|
back |
|
|
 |
|
 |
|
}
}
?>
|
|
|
require("icc-footer.php"); ?>