<?php 
include('includes/config/config.php');
include ('includes/functions.php');
include ('log_entry.php');
error_log ( "Start Printing Request Attributes" );
$requestStr="";
foreach ( $_REQUEST as $key => $value ) {
    $requestStr.=$key . " : " . $value . "\n";
    error_log ( $key . " : " . $value . "<br />\r\n" );
}
error_log ( "End Printing Request Attributes" );
save_log($requestStr,'Report Master','SAVE','save_report_master.php');
$report_id = $_POST['report_id'];
$report_code =$_POST['report_code'];
$report_name = $_POST['report_name'];
$report_type = $_POST['report_type'];
$report_url = $_POST['report_url'];
$fun_name = $_POST['fun_name'];


// error_log("report_id: ".$report_id."report_code: ".$report_code."report_name: ".$report_name."report_type: ".$report_type);

if(!empty($report_id)){
    $query = "update  report_master set report_code = '$report_code', report_name = '$report_name', report_type = '$report_type', report_url = '$report_url',fun_name = '$fun_name',modified_by = '".$_SESSION['user_id']."' where report_id = '".$report_id."'";
}
else {
    $query = "insert into  report_master(report_code, report_name, report_type,report_url,fun_name, modified_by)
		  values ('$report_code', '$report_name', '$report_type','$report_url','$fun_name','".$_SESSION['user_id']."' ); ";
    
}
error_log($query);
if (!$result = @mysqli_query($conn,$query)) {
    exit(mysqli_error($conn));
}
else{
    
    
    $query = "select max(report_id) report_id from report_master  ";
    if (!$result = @mysqli_query($conn,$query)) {
        exit(mysqli_error($conn));
    }
    if(mysqli_num_rows($result) > 0) {
        while ($row = @mysqli_fetch_assoc($result)) {
            
            $id_max = $row['report_id'];
        }
    }
    
    
    $query = "select * from report_master where report_id='".$id_max."'";
    //echo  $query;
    if (!$result = @mysqli_query($conn,$query)) {
        exit(mysqli_error($conn));
    }
    if(mysqli_num_rows($result) > 0) {
        while ($row = @mysqli_fetch_assoc($result)) {
            
            $data=$row;
        }
    }
    
    
}
if($data==null)
{
    $data['status'] = 200;
    $data['message'] = "Data not found!";
}
echo json_encode($data);
?>