112 lines
3.8 KiB
PHP
112 lines
3.8 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers;
|
|
|
|
use Illuminate\Support\Facades\Validator;
|
|
use Illuminate\Http\Request;
|
|
use Illuminate\Http\Response;
|
|
|
|
use App\Models\Post;
|
|
use App\Models\Store;
|
|
|
|
class PostsController extends Controller
|
|
{
|
|
public function getFields(Request $request, $post) {
|
|
// Retrieve the post by the 'body' column (UUID)
|
|
$post = Post::where('body', $post)->first();
|
|
|
|
// If the post is not found, return a 404 response
|
|
if (!$post) {
|
|
return response()->json(['message' => 'Post not found'], Response::HTTP_NOT_FOUND);
|
|
}
|
|
|
|
// Retrieve all stores associated with this post
|
|
$stores = $post->stores;
|
|
|
|
// Prepare the response data
|
|
$fields = $stores->map(function ($store) {
|
|
return [
|
|
'key' => $store->key,
|
|
'values' => $store->values,
|
|
'created' => $store->created_at,
|
|
'updated' => $store->updated_at
|
|
];
|
|
});
|
|
|
|
// Return the JSON response with the fields
|
|
return response()->json(['fields' => $fields], Response::HTTP_OK);
|
|
}
|
|
|
|
public function storePost(Request $request) {
|
|
// Validate the request body
|
|
$request->validate([
|
|
'body' => 'required|uuid', // Ensure the body is a valid UUID
|
|
]);
|
|
|
|
// Check if a post with the same UUID already exists
|
|
$existingPost = Post::where('body', $request->body)->first();
|
|
|
|
if ($existingPost) {
|
|
// Return a 409 Conflict response if the post already exists
|
|
return response()->json(['message' => 'Post with this UUID already exists'], Response::HTTP_CONFLICT);
|
|
}
|
|
|
|
// Create a new post
|
|
$post = Post::create([
|
|
'body' => $request->body,
|
|
]);
|
|
|
|
// Return a 201 Created response with the created post
|
|
return response()->json(['message' => 'Post created successfully', 'post' => $post], Response::HTTP_CREATED);
|
|
}
|
|
|
|
public function deletePost($post) {
|
|
// Retrieve the post by the 'body' column (UUID)
|
|
$post = Post::where('body', $post)->first();
|
|
|
|
// If the post is not found, return a 404 response
|
|
if (!$post) {
|
|
return response()->json(['message' => 'Post not found'], Response::HTTP_NOT_FOUND);
|
|
}
|
|
|
|
// Delete the post
|
|
$post->delete();
|
|
|
|
// Return a 200 OK response with a success message
|
|
return response()->json(['message' => 'Post deleted successfully'], Response::HTTP_OK);
|
|
}
|
|
|
|
public function createOrUpdatePostStore(Request $request) {
|
|
// Validate the input
|
|
$validator = Validator::make($request->all(), [
|
|
'body' => 'required|uuid', // Ensure body is a valid UUID
|
|
'key' => 'required|string|max:255', // Ensure key is a string
|
|
'value' => 'required|json', // Ensure value is a valid JSON string
|
|
]);
|
|
|
|
// If validation fails, return a 422 response with errors
|
|
if ($validator->fails()) {
|
|
return response()->json(['errors' => $validator->errors()], Response::HTTP_UNPROCESSABLE_ENTITY);
|
|
}
|
|
|
|
// Retrieve or create the post
|
|
$post = Post::firstOrCreate(
|
|
['body' => $request->body], // Search by body (UUID)
|
|
['body' => $request->body] // Create data if not exists
|
|
);
|
|
|
|
// Retrieve or create the store
|
|
$store = Store::updateOrCreate(
|
|
['post_id' => $post->id, 'key' => $request->key], // Search by post_id and key
|
|
['values' => $request->value] // Create or update data
|
|
);
|
|
|
|
// Return a success response
|
|
return response()->json([
|
|
'message' => 'Post and store processed successfully',
|
|
'post' => $post,
|
|
'store' => $store,
|
|
], Response::HTTP_OK);
|
|
}
|
|
}
|