<?php
session_start();
//$date = date("Y-m-d");
    $s1='ชบ.';     
	$s2 = $_POST['Docid'];
	$docid=$s1."".$s2;

	
echo $_POST['user'].'<br>'; 
/*echo $docid.'<br>';
echo $submit2.'<br>';
echo $date.'<br>';*/
$ig='ทอสอบ';
	
    $serverName = "localhost"; //serverName\instanceName
	$connectionInfo = array( "Database"=>"APsystemBX65", "UID"=>"root", "PWD"=>"123456",
	"CharacterSet" => "UTF-8");
	$conn = sqlsrv_connect( $serverName, $connectionInfo);
	// echo 'oo'.$conn.'<br>';
	if( $conn ) {
	        
				//Update Serial no
							
			$sql="INSERT INTO dbo.FactCheckDoc(PRID,WHDocNote,UserName,WHDocDate)
						VALUES ('".$docid."','".$_POST['status']."','".$_POST['user']."','".$_POST['date']."')";
						echo $sql.'<br>';
						$result = sqlsrv_query($conn,$sql);
						echo 'oo'.$result.'<br>';
						
			$sql1 = "update dbo.FactProductIN set WHDocDate='".$_POST["date"]."',WHDocNote='".$_POST["status"]."'
						 where PRID='$docid'" ;
				echo $sql1.'<br>';		
				
				$result1 = sqlsrv_query($conn,$sql1);
				echo 'oo'.$result1.'<br>';
				/*if($result0 === false ){
					echo "<script language=\"JavaScript\">alert('ไม่สามารถแก้ไข');
					window.location='javascript:history.back()';</script>";	 
				}else{
			
				sqlsrv_free_stmt($result0);
					echo "<script language=\"JavaScript\">alert('บันทึกเพิ่มข้อมูลเรียบร้อย');
					window.location='check.php?&Docid=".$s2."';</script>";	
				}*/
	}

				
		
?>