1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
import { h, Component } from 'preact';
import { supabase } from '../services/supabase';
import { formatDate } from "../util";
import sanitizeHtml from 'sanitize-html';
import GuestbookForm from "./GuestbookForm.jsx";
class Guestbook extends Component {
state = {
message: null,
error: null,
page: 1,
};
fetchMessages = async (page) => {
const perPage = 10;
const start = (page - 1) * perPage;
const end = start + perPage - 1;
let { data: messages, error, count } = await supabase
.from('guestbook')
.select('*', { count: 'exact' })
.range(start, end)
.order('created_at', { ascending: false });
if (error) {
this.setState({ error: `Failed to fetch data: ${error.message}` });
console.error('Failed to fetch data:', error);
} else {
this.setState({
message: messages,
totalPages: Math.ceil(count / perPage)
});
}
}
refresh = async () => {
await this.fetchMessages(this.state.page);
}
async componentDidMount() {
await this.fetchMessages(this.state.page);
}
handleNext = async () => {
const nextPage = this.state.page + 1;
if (nextPage > this.state.totalPages) {
return;
}
this.setState({ page: nextPage });
await this.fetchMessages(nextPage);
}
handlePrevious = async () => {
const previousPage = this.state.page - 1;
this.setState({ page: previousPage });
await this.fetchMessages(previousPage);
}
render() {
const { message, error, page, totalPages } = this.state;
return (
<div>
<GuestbookForm onMessageSent={this.refresh} />
{error ? (
<p>{error}</p>
) : !message ? (
<p>Loading messages...</p>
) : (
<div class="grid">
{message.map((g) => (
<article class="card">
<h1>Message from: {g.name}</h1>
<small>{formatDate(g.created_at)}</small>
<div dangerouslySetInnerHTML={{__html: sanitizeHtml(g.message)}}/>
{g.website && <a href={g.website} target="_blank">Website</a>}
</article>
))}
</div>
)}
{page > 1 && <button class="button margin" onClick={this.handlePrevious}>Previous</button>}
{page < totalPages && <button class="button margin" onClick={this.handleNext}>Next</button>}
</div>
);
}
}
export default Guestbook;
|
