95 lines
2.6 KiB
TypeScript
95 lines
2.6 KiB
TypeScript
import {
|
|
NavigationProp,
|
|
useFocusEffect,
|
|
useNavigation,
|
|
} from "@react-navigation/native";
|
|
import { useCallback, useState } from "react";
|
|
import { FlatList, Image } from "react-native";
|
|
import { List } from "react-native-paper";
|
|
import { GraphsPageParams } from "./GraphsPage";
|
|
import { setRepo, settingsRepo } from "./db";
|
|
import DrawerHeader from "./DrawerHeader";
|
|
import GymSet from "./gym-set";
|
|
import Page from "./Page";
|
|
import Settings from "./settings";
|
|
|
|
export default function GraphsList() {
|
|
const [bests, setBests] = useState<GymSet[]>();
|
|
const [term, setTerm] = useState("");
|
|
const navigation = useNavigation<NavigationProp<GraphsPageParams>>();
|
|
const [settings, setSettings] = useState<Settings>();
|
|
|
|
useFocusEffect(
|
|
useCallback(() => {
|
|
settingsRepo.findOne({ where: {} }).then(setSettings);
|
|
}, [])
|
|
);
|
|
|
|
const refresh = useCallback(async (value: string) => {
|
|
const result = await setRepo
|
|
.createQueryBuilder("gym_set")
|
|
.select(["gym_set.name", "gym_set.reps", "gym_set.weight"])
|
|
.groupBy("gym_set.name")
|
|
.innerJoin(
|
|
(qb) =>
|
|
qb
|
|
.select(["gym_set2.name", "MAX(gym_set2.weight) AS max_weight"])
|
|
.from(GymSet, "gym_set2")
|
|
.where("gym_set2.name LIKE (:name)", { name: `%${value.trim()}%` })
|
|
.groupBy("gym_set2.name"),
|
|
"subquery",
|
|
"gym_set.name = subquery.gym_set2_name AND gym_set.weight = subquery.max_weight"
|
|
)
|
|
.getMany();
|
|
setBests(result);
|
|
}, []);
|
|
|
|
useFocusEffect(
|
|
useCallback(() => {
|
|
refresh(term);
|
|
}, [refresh, term])
|
|
);
|
|
|
|
const search = useCallback(
|
|
(value: string) => {
|
|
setTerm(value);
|
|
refresh(value);
|
|
},
|
|
[refresh]
|
|
);
|
|
|
|
const renderItem = ({ item }: { item: GymSet }) => (
|
|
<List.Item
|
|
key={item.name}
|
|
title={item.name}
|
|
description={`${item.reps} x ${item.weight}${item.unit || "kg"}`}
|
|
onPress={() => navigation.navigate("ViewGraph", { best: item })}
|
|
left={() =>
|
|
(settings.images && item.image && (
|
|
<Image
|
|
source={{ uri: item.image }}
|
|
style={{ height: 75, width: 75 }}
|
|
/>
|
|
)) ||
|
|
null
|
|
}
|
|
/>
|
|
);
|
|
|
|
return (
|
|
<>
|
|
<DrawerHeader name="Graphs" />
|
|
<Page term={term} search={search}>
|
|
{bests?.length === 0 ? (
|
|
<List.Item
|
|
title="No exercises yet"
|
|
description="Once sets have been added, this will highlight your personal bests."
|
|
/>
|
|
) : (
|
|
<FlatList style={{ flex: 1 }} renderItem={renderItem} data={bests} />
|
|
)}
|
|
</Page>
|
|
</>
|
|
);
|
|
}
|