TerraTechSummaryDialog.tsx 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
  1. "use client";
  2. import { useEffect, useState } from "react";
  3. import {
  4. Dialog,
  5. DialogContent,
  6. DialogHeader,
  7. DialogTitle,
  8. } from "@/components/ui/dialog";
  9. import {
  10. Table,
  11. TableBody,
  12. TableCell,
  13. TableHead,
  14. TableHeader,
  15. TableRow,
  16. } from "@/components/ui/table";
  17. import { Badge } from "@/components/ui/badge";
  18. import { getTerraTechFacilitySummary, TerraTechSummaryRow } from "@/app/actions/imports";
  19. import { Fuel, AlertTriangle } from "lucide-react";
  20. interface TerraTechSummaryDialogProps {
  21. open: boolean;
  22. onOpenChange: (open: boolean) => void;
  23. importId: number;
  24. }
  25. interface SummaryData {
  26. importId: number;
  27. importName: string;
  28. layoutName: string;
  29. rows: TerraTechSummaryRow[];
  30. }
  31. export function TerraTechSummaryDialog({ open, onOpenChange, importId }: TerraTechSummaryDialogProps) {
  32. const [loading, setLoading] = useState(false);
  33. const [error, setError] = useState<string | null>(null);
  34. const [summaryData, setSummaryData] = useState<SummaryData | null>(null);
  35. useEffect(() => {
  36. if (open && importId) {
  37. loadSummary();
  38. }
  39. // eslint-disable-next-line react-hooks/exhaustive-deps
  40. }, [open, importId]);
  41. async function loadSummary() {
  42. setLoading(true);
  43. setError(null);
  44. try {
  45. const result = await getTerraTechFacilitySummary(importId);
  46. if (result.success && result.data) {
  47. setSummaryData(result.data);
  48. } else {
  49. setError(result.error || 'Failed to load summary');
  50. }
  51. } catch {
  52. setError('An unexpected error occurred');
  53. } finally {
  54. setLoading(false);
  55. }
  56. }
  57. function formatNumber(value: number | string | null | undefined, decimals: number = 2): string {
  58. if (value === null || value === undefined) return '-';
  59. const num = typeof value === 'string' ? parseFloat(value) : value;
  60. if (isNaN(num)) return '-';
  61. return num.toLocaleString('en-US', { minimumFractionDigits: decimals, maximumFractionDigits: decimals });
  62. }
  63. function formatPercent(value: number | string | null | undefined): string {
  64. if (value === null || value === undefined) return '-';
  65. const num = typeof value === 'string' ? parseFloat(value) : value;
  66. if (isNaN(num)) return '-';
  67. return `${num.toFixed(1)}%`;
  68. }
  69. return (
  70. <Dialog open={open} onOpenChange={onOpenChange}>
  71. <DialogContent className="max-w-[95vw] max-h-[90vh] dark:bg-gray-800 dark:border-gray-700">
  72. <DialogHeader>
  73. <DialogTitle className="flex items-center gap-2 text-gray-900 dark:text-white">
  74. <div className="bg-amber-500 w-8 h-8 rounded-full flex items-center justify-center text-white">
  75. <Fuel className="w-4 h-4" />
  76. </div>
  77. Facility Summary
  78. {summaryData && (
  79. <Badge variant="outline" className="ml-2">
  80. {summaryData.importName}
  81. </Badge>
  82. )}
  83. </DialogTitle>
  84. </DialogHeader>
  85. {loading && (
  86. <div className="flex justify-center py-12">
  87. <div className="animate-spin rounded-full h-8 w-8 border-b-2 border-amber-500"></div>
  88. </div>
  89. )}
  90. {error && (
  91. <div className="flex flex-col items-center justify-center py-12 text-red-500">
  92. <AlertTriangle className="h-8 w-8 mb-2" />
  93. <p>{error}</p>
  94. </div>
  95. )}
  96. {!loading && !error && summaryData && (
  97. <div className="h-[70vh] overflow-auto">
  98. <div className="pr-4">
  99. <div className="mb-4 text-sm text-gray-600 dark:text-gray-300">
  100. Total records: <strong>{summaryData.rows.length}</strong>
  101. </div>
  102. <Table>
  103. <TableHeader>
  104. <TableRow className="dark:border-gray-700">
  105. <TableHead className="sticky left-0 bg-white dark:bg-gray-800 z-10">Well Name</TableHead>
  106. <TableHead>CorpID</TableHead>
  107. <TableHead>Facility ID</TableHead>
  108. <TableHead className="text-right">Gas</TableHead>
  109. <TableHead className="text-right">Oil</TableHead>
  110. <TableHead className="text-right">Water</TableHead>
  111. <TableHead>State</TableHead>
  112. <TableHead>County</TableHead>
  113. <TableHead className="text-right">Days Q1</TableHead>
  114. <TableHead className="text-right">Days Q2</TableHead>
  115. <TableHead className="text-right">Days Q3</TableHead>
  116. <TableHead className="text-right">Days Q4</TableHead>
  117. <TableHead className="text-right">Q1 %</TableHead>
  118. <TableHead className="text-right">Q2 %</TableHead>
  119. <TableHead className="text-right">Q3 %</TableHead>
  120. <TableHead className="text-right">Q4 %</TableHead>
  121. <TableHead className="text-right">Gas-corr</TableHead>
  122. <TableHead className="text-right">Oil-corr</TableHead>
  123. <TableHead className="text-right">Water-corr</TableHead>
  124. <TableHead>Missing Facility ID</TableHead>
  125. <TableHead>Missing County</TableHead>
  126. </TableRow>
  127. </TableHeader>
  128. <TableBody>
  129. {summaryData.rows.length === 0 ? (
  130. <TableRow>
  131. <TableCell colSpan={21} className="h-24 text-center">
  132. No summary data available for this import.
  133. </TableCell>
  134. </TableRow>
  135. ) : (
  136. summaryData.rows.map((row, index) => (
  137. <TableRow key={index} className="dark:border-gray-700">
  138. <TableCell className="sticky left-0 bg-white dark:bg-gray-800 font-medium">
  139. {row.wellName || '-'}
  140. </TableCell>
  141. <TableCell>{row.corpId || '-'}</TableCell>
  142. <TableCell>
  143. {row.facilityId || (
  144. <span className="text-amber-500">-</span>
  145. )}
  146. </TableCell>
  147. <TableCell className="text-right">{formatNumber(row.gas)}</TableCell>
  148. <TableCell className="text-right">{formatNumber(row.oil)}</TableCell>
  149. <TableCell className="text-right">{formatNumber(row.water)}</TableCell>
  150. <TableCell>{row.state || '-'}</TableCell>
  151. <TableCell>
  152. {row.county || (
  153. <span className="text-amber-500">-</span>
  154. )}
  155. </TableCell>
  156. <TableCell className="text-right">{formatNumber(row.daysQ1, 0)}</TableCell>
  157. <TableCell className="text-right">{formatNumber(row.daysQ2, 0)}</TableCell>
  158. <TableCell className="text-right">{formatNumber(row.daysQ3, 0)}</TableCell>
  159. <TableCell className="text-right">{formatNumber(row.daysQ4, 0)}</TableCell>
  160. <TableCell className="text-right">{formatPercent(row.daysQ1Pct)}</TableCell>
  161. <TableCell className="text-right">{formatPercent(row.daysQ2Pct)}</TableCell>
  162. <TableCell className="text-right">{formatPercent(row.daysQ3Pct)}</TableCell>
  163. <TableCell className="text-right">{formatPercent(row.daysQ4Pct)}</TableCell>
  164. <TableCell className="text-right">{formatNumber(row.gasCorr)}</TableCell>
  165. <TableCell className="text-right">{formatNumber(row.oilCorr)}</TableCell>
  166. <TableCell className="text-right">{formatNumber(row.waterCorr)}</TableCell>
  167. <TableCell>
  168. {row.isMissingFacilityId && (
  169. <Badge variant="destructive" className="text-xs">Yes</Badge>
  170. )}
  171. </TableCell>
  172. <TableCell>
  173. {row.isMissingCounty && (
  174. <Badge variant="destructive" className="text-xs">Yes</Badge>
  175. )}
  176. </TableCell>
  177. </TableRow>
  178. ))
  179. )}
  180. </TableBody>
  181. </Table>
  182. </div>
  183. </div>
  184. )}
  185. </DialogContent>
  186. </Dialog>
  187. );
  188. }