<?php
// get these values from your DB.
require_once('config.php');
$error_message;
$valid = true;

/* Begin the transaction. */
if ( sqlsrv_begin_transaction( $conn ) === false ) {
     die( print_r( sqlsrv_errors(), true ));
}



$site_cd = $_REQUEST['site_cd'];
$wko_det_assign_to=$_REQUEST['wko_det_assign_to'];



$sql="SELECT	prm_ast.site_cd,
				prm_ast.prm_ast_wo_no,
				prm_ast.prm_ast_grp_cd,
				ast_mst.ast_mst_asset_no,
				ast_mst.ast_mst_asset_shortdesc,
				ast_mst.ast_mst_asset_type,
				ast_mst.ast_mst_asset_status,
				ast_mst.ast_mst_work_area,    
				ast_mst.ast_mst_asset_locn,   
				ast_mst.ast_mst_cost_center
		FROM 	wko_mst (NOLOCK), 
				wko_det (NOLOCK), 
				wrk_sts (NOLOCK),
				prm_ast (NOLOCK),
				ast_mst (NOLOCK)
		WHERE wko_mst.site_cd = wko_det.site_cd
		AND		prm_ast.site_cd = ast_mst.site_cd
		AND		wko_mst.site_cd = prm_ast.site_cd
		AND		wko_mst.rowid = wko_det.mst_rowid
		AND		wko_mst.site_cd = wrk_sts.site_cd
		AND		prm_ast.prm_ast_asset_no = ast_mst.ast_mst_asset_no
		AND		wko_mst.wko_mst_status = wrk_sts.wrk_sts_status
		AND		wko_mst.wko_mst_wo_no = prm_ast_wo_no
		AND		prm_ast.site_cd = '".$site_cd."'
		AND		wko_mst_type = 'G'
		AND		wko_det_assign_to = '".$wko_det_assign_to."'
		AND		wrk_sts_typ_cd = 'OPEN'";
		
$stmt = sqlsrv_query( $conn, $sql);

if( !$stmt ) {
     $error_message = "Error selecting table (prm_ast)";
	 returnError($error_message);
     die( print_r( sqlsrv_errors(), true));
	 
}
$json = array();
do {
     while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {	
	 		
		$json[] = $row;
	
     }
} while ( sqlsrv_next_result($stmt) );







if( $stmt ) {
		 sqlsrv_commit( $conn );
		 sqlsrv_close( $conn);	
		 returnData($json);	
	} else {
		 sqlsrv_rollback( $conn );
		 $error_message = "Transaction rolled back.<br />";
		 returnError($error_message);
	} 



function returnData($json){
	 $json1 = json_encode($json);
	 //echo$json;	 
	 if(empty(json_decode($json1,1))) {
     $returnData = array(	 
	'status' => 'SUCCESS',
	'message' => 'No Records found ',	
	'data' => $json);
}else{
	$returnData = array(
	'status' => 'SUCCESS',
	'message' => 'Successfully',	
	'data' => $json);
} 	
	
	echo json_encode($returnData);
}

function returnError($error_message){
	$json = array();
	
	$returnData = array(
	'status' => 'ERROR',
	'message' => $error_message,
	'data' => $json);
	
	echo json_encode($returnData);
	exit();
		
}
	

 
?>