112:"ExplicitChatIdProvider" 113:I[903690,["$49","$4a","$4b","$4c","$4d","$4e","$4f","$50","$51","$52","$53","$54","$55","$56","$57","$58","$59","$5a","$5b","$5c","$5d","$5e","$5f","$60","$61","$62","$63","$64","$65","$66","$67","$68","$69","$6a","$6b","$6c","$6d","$6e","$6f","$70","$71","$72","$73","$74","$75","$76","$77","$78","$79","$7a","$8c","$8d","$7c","$85","$7f","$7e","$8e","$80","$8f","$90","$91","$7d","$92","$87","$8a","$84","$83","$88","$89","$93","$94","$86","$95","$82"],"$112"] 114:I[838238,["$49","$4a","$4b","$4c","$4d","$4e","$4f","$50","$51","$52","$53","$54","$55","$56","$57","$58","$59","$5a","$5b","$5c","$5d","$5e","$5f","$60","$61","$62","$63","$64","$65","$66","$67","$68","$69","$6a","$6b","$6c","$6d","$6e","$6f","$70","$71","$72","$73","$74","$75","$76","$77","$78","$79","$7a","$8c","$8d","$7c","$85","$7f","$7e","$8e","$80","$8f","$90","$91","$7d","$92","$87","$8a","$84","$83","$88","$89","$93","$94","$86","$95","$82"],"SWRDataProvider"] 116:[] 117:[["b_MKE1kCmDS9l",null],["b_4DaKhOObGK8",null],["b_Jam6BYuCRk5",null]] 118:[["b_MKE1kCmDS9l",{"templateVersionId":null,"templateCanonId":null}],["b_4DaKhOObGK8",{"templateVersionId":null,"templateCanonId":null}],["b_Jam6BYuCRk5",{"templateVersionId":null,"templateCanonId":null}]] 119:[["b_fpJslz5Ay91","$D2025-06-14T04:58:26.916Z"],["b_yumDxLYjs9I","$D2025-06-14T04:59:32.910Z"],["b_i6Q55mVIuPc","$D2025-06-14T09:30:35.627Z"],["b_vdegGFtqoOA","$D2025-06-14T09:35:45.617Z"],["b_tcQWK5suC78","$D2025-06-14T09:37:54.797Z"],["b_VT4aOKTEJCj","$D2025-06-14T09:40:04.804Z"],["b_SCxMbblZypb","$D2025-06-14T09:41:46.423Z"],["b_qBdHuyDsc1V","$D2025-06-14T09:46:37.949Z"],["b_VdlZjZzVRwu","$D2025-06-14T09:49:16.333Z"],["b_ZfD5OPJdY29","$D2025-06-14T09:53:00.975Z"],["b_0PRSApBXhuH","$D2025-06-14T09:55:27.246Z"],["b_sdYV24iX4CB","$D2025-06-14T09:56:26.649Z"],["b_VOR2hPABQXx","$D2025-06-14T09:57:17.560Z"],["b_Ij47STgwjyl","$D2025-06-14T10:05:42.940Z"],["b_dtvBI2PiElU","$D2025-06-14T10:10:46.000Z"],["b_k6HykSGNdNd","$D2025-06-14T10:12:05.829Z"],["b_r0E9el0PjiB","$D2025-06-14T10:12:58.744Z"],["b_8yR2eocqp0E","$D2025-06-14T10:25:57.696Z"],["b_dvU7TO2IXXj","$D2025-06-14T10:29:59.102Z"],["b_Wift0B2YQ4z","$D2025-06-14T10:41:23.645Z"],["b_NTTUYcgrfka","$D2025-06-14T10:51:47.738Z"],["b_2FUd6a1do0K","$D2025-06-14T11:00:12.342Z"],["b_quo8RJ6BaGq","$D2025-06-14T11:11:25.525Z"],["b_iHWuXbuaI51","$D2025-06-14T11:45:25.776Z"],["b_cb9PoRsi9l3","$D2025-06-14T11:58:15.332Z"],["b_tU8Gok4h7yb","$D2025-06-14T12:04:36.889Z"],["b_kDLfZ5XPfKK","$D2025-06-14T12:08:17.870Z"],["b_2liEbigseXv","$D2025-06-14T12:12:04.372Z"],["b_KyrkDIOhQfg","$D2025-06-15T08:27:51.674Z"],["b_VRfenYP2LCR","$D2025-06-15T08:29:01.055Z"],["b_x738XfseVad","$D2025-06-15T12:29:20.734Z"],["b_Z8cNbI8N5Qf","$D2025-06-15T12:33:29.079Z"],["b_An1sNB8IvXZ","$D2025-06-15T12:40:54.284Z"],["b_eJe9twvpbpZ","$D2025-06-15T13:31:59.177Z"],["b_6J1y07Hw5Vf","$D2025-06-15T13:33:31.782Z"],["b_EiTlWN0m2Pq","$D2025-06-15T13:50:22.400Z"],["b_I1j7XWeIbhh","$D2025-06-15T13:51:34.349Z"],["b_3IOyzfoH13h","$D2025-06-15T13:51:48.581Z"],["b_yFUeEFucy1r","$D2025-06-15T14:00:51.564Z"],["b_k7KEptDo2zy","$D2025-06-15T14:14:17.894Z"],["b_eWYHnRb404R","$D2025-06-15T14:17:28.919Z"],["b_HKfOBx31ddA","$D2025-06-15T14:19:18.575Z"],["b_L9ZQRGKlJ5p","$D2025-06-15T14:21:59.820Z"],["b_oqCfB7D56V4","$D2025-06-15T14:24:42.221Z"],["b_PzZpyVLjCba","$D2025-06-15T14:37:30.673Z"],["b_MskSslRbTm2","$D2025-06-15T14:42:38.069Z"],["b_JiJJgibAwgF","$D2025-06-15T14:44:07.455Z"],["b_JwhtEVy2dqC","$D2025-06-15T14:45:05.040Z"],["b_oCmW3FrI8tx","$D2025-06-15T14:46:03.300Z"],["b_2Zaa9jb7SE4","$D2025-06-15T14:48:05.018Z"],["b_AW7Dj1Mw0qw","$D2025-06-15T14:57:46.665Z"],["b_WIQj41Hfr4v","$D2025-06-15T15:08:32.088Z"],["b_gpmhhc3zBTn","$D2025-06-15T15:12:06.666Z"],["b_Xm3QHC6fy5M","$D2025-06-15T15:14:27.766Z"],["b_esbMDS0oMYL","$D2025-06-15T15:24:34.671Z"],["b_pvxmSz2Uedb","$D2025-06-15T15:29:48.034Z"],["b_yTtzvfupVVC","$D2025-06-15T15:32:42.883Z"],["b_fP6GAEiGXP4","$D2025-06-15T23:59:20.732Z"],["b_pUuQLI1uwVs","$D2025-06-16T00:09:38.358Z"],["b_xTG5wQ0gL7e","$D2025-06-16T00:13:39.777Z"],["b_K3Ke8s1VsEb","$D2025-06-16T00:19:20.509Z"],["b_IxfTTzHzCDi","$D2025-06-16T00:24:08.102Z"],["b_yQbWd4TKvnA","$D2025-06-16T00:33:06.144Z"],["b_1xttAf4GHaY","$D2025-06-16T02:42:26.927Z"],["b_GWdXGc1LZqo","$D2025-06-16T02:43:11.299Z"],["b_UQq4Sd1gZmr","$D2025-06-16T02:59:54.671Z"],["b_LR4KDXtTulP","$D2025-06-16T03:13:47.308Z"],["b_12TGa9RweBf","$D2025-06-16T03:47:49.791Z"],["b_5I7si5HPDh7","$D2025-06-16T04:02:23.267Z"],["b_YKlqaYuhSED","$D2025-06-16T04:17:43.975Z"],["b_VJFENkhn39G","$D2025-06-16T04:36:25.094Z"],["b_D8YI81GkD1Z","$D2025-06-16T04:44:51.394Z"],["b_YYIVMv0kPaw","$D2025-06-16T04:47:53.257Z"],["b_fbeU2FJVLfN","$D2025-06-16T04:55:52.512Z"],["b_hIRqMmZjVRs","$D2025-06-16T05:00:14.299Z"],["b_TV9tfQE4JRT","$D2025-06-16T05:14:14.871Z"],["b_MNIEuBnAIRt","$D2025-06-16T05:17:13.983Z"],["b_NVQ5oFoCyvo","$D2025-06-16T05:32:35.408Z"],["b_z1hJIKAtaXb","$D2025-06-16T05:45:44.821Z"],["b_i4s9AQgPmHI","$D2025-06-16T05:52:07.060Z"],["b_bdTA3TVlFQl","$D2025-06-16T06:07:50.729Z"],["b_qzu1drSzLRI","$D2025-06-16T06:18:56.246Z"],["b_KVhACmdXG7K","$D2025-06-16T06:36:41.165Z"],["b_KmtkYVkNVql","$D2025-06-16T06:39:34.605Z"],["b_Fx9ym6lsOnG","$D2025-06-16T06:50:20.396Z"],["b_rDurCzqKWmd","$D2025-06-16T07:10:47.018Z"],["b_iOXcTbwXOm3","$D2025-06-16T07:17:06.123Z"],["b_VKmVhJXJohH","$D2025-06-16T07:26:56.414Z"],["b_6mhqd2aTw6W","$D2025-06-16T07:32:55.988Z"],["b_CFadEoXywVS","$D2025-06-16T07:36:55.930Z"],["b_hqrbo02DP4O","$D2025-06-16T08:02:30.804Z"],["b_xt55PdvSYUI","$D2025-06-16T08:53:34.390Z"],["b_UZoLrTRwhnA","$D2025-06-16T09:13:59.231Z"],["b_jJYTw30CO6G","$D2025-06-16T09:16:19.192Z"],["b_5VQ7dnmsQGp","$D2025-06-16T09:19:04.546Z"],["b_FkLQlc9f2bL","$D2025-06-16T09:22:15.342Z"],["b_hDUGLrQwqc9","$D2025-06-16T09:27:02.265Z"],["b_uLMSw3iaN0C","$D2025-06-16T09:31:45.356Z"],["b_hJ6FlFnSenO","$D2025-06-16T09:34:57.638Z"],["b_njl5XRgKcpu","$D2025-06-16T09:37:02.936Z"],["b_o4OKAZpYckG","$D2025-06-16T09:37:49.166Z"],["b_CIZ5h1E20fg","$D2025-06-16T09:40:28.410Z"],["b_LJcTICzCf6x","$D2025-06-16T09:42:42.582Z"],["b_v16nSy1KrU3","$D2025-06-16T09:44:06.830Z"],["b_dOfI96dEOei","$D2025-06-16T09:46:35.568Z"],["b_i144syBtW2P","$D2025-06-16T09:50:46.692Z"],["b_eXfanSQtUhY","$D2025-06-17T04:49:27.713Z"],["b_eK9CIpexH8a","$D2025-06-17T04:50:49.003Z"],["b_RVaWQeOCJPc","$D2025-06-17T05:06:03.912Z"],["b_MSnU2Pt4kyj","$D2025-06-17T05:11:50.178Z"],["b_SYS7HVoePOP","$D2025-06-17T05:29:47.379Z"],["b_It1kNvVakqm","$D2025-06-17T05:33:30.294Z"],["b_M5qegddKqdH","$D2025-06-17T05:44:29.116Z"],["b_8OV51oVwUWg","$D2025-06-17T05:56:52.460Z"],["b_el0P0KnlZzG","$D2025-06-17T06:01:19.831Z"],["b_yeDIAXe4Shb","$D2025-06-17T06:02:31.866Z"],["b_exE6hHVkccE","$D2025-06-17T06:09:07.328Z"],["b_kPu1umOw9AA","$D2025-06-17T06:13:25.777Z"],["b_GUoWxR894j2","$D2025-06-17T06:39:48.899Z"],["b_XENZUyUpTRo","$D2025-06-17T06:48:28.684Z"],["b_H2QHmyuJiR4","$D2025-06-17T07:05:58.573Z"],["b_xMxDcm4hQga","$D2025-06-17T07:12:11.977Z"],["b_0AdCZ6sSVfU","$D2025-06-17T07:21:06.698Z"],["b_D4iSVIpXYCJ","$D2025-06-17T07:31:21.161Z"],["b_7itbqN1VVEj","$D2025-06-17T07:39:20.128Z"],["b_WiVEGlNwRDD","$D2025-06-17T07:39:59.692Z"],["b_22U246dJRHl","$D2025-06-17T07:43:52.333Z"],["b_nYMBHnJ4O6C","$D2025-06-17T07:45:53.046Z"],["b_n3YfF5BrzNK","$D2025-06-17T08:12:35.683Z"],["b_SOuJDa5l1bT","$D2025-06-18T00:55:45.680Z"],["b_hWm3GuNm4qZ","$D2025-06-18T01:02:38.830Z"],["b_oHmug9lWtIN","$D2025-06-18T01:07:17.397Z"],["b_xWPNnkmJ2DI","$D2025-06-19T04:34:26.774Z"],["b_ePBDTlaF72j","$D2025-06-19T04:47:14.007Z"],["b_KbBbi3c1iqR","$D2025-06-19T04:47:21.860Z"],["b_5kicfwrS0HU","$D2025-06-19T04:50:08.674Z"],["b_O7SVZ0eQmGu","$D2025-06-19T04:55:08.007Z"],["b_genWlaMxrGA","$D2025-06-19T05:05:04.222Z"],["b_DUBY2uiIhGx","$D2025-06-19T05:27:25.833Z"],["b_ToJevexp9TM","$D2025-06-19T05:40:57.470Z"],["b_YIQree7lC8z","$D2025-06-19T05:52:38.590Z"],["b_laUqemN9W1Q","$D2025-06-19T06:00:06.789Z"],["b_QmiWTNdvxqO","$D2025-06-19T06:07:01.517Z"],["b_7cdK3Mv5XFJ","$D2025-06-19T06:17:13.928Z"],["b_hnpAdlw2h3I","$D2025-06-19T06:31:21.177Z"],["b_s7JEQa9asdi","$D2025-06-19T07:18:50.984Z"],["b_W1Pi6faXmTC","$D2025-06-19T07:35:45.107Z"],["b_FMTNKJI8eGt","$D2025-06-19T07:42:37.513Z"],["b_OvoEizsscoc","$D2025-06-19T08:00:39.230Z"],["b_zuGSrplTycs","$D2025-06-19T08:17:55.889Z"],["b_DJnAq0nlXQJ","$D2025-06-19T08:21:49.918Z"],["b_sdmAnzROScd","$D2025-06-19T13:12:20.849Z"],["b_nFuqIRoU1YG","$D2025-06-19T13:14:27.140Z"],["b_FlCk8RIl86O","$D2025-06-19T13:17:42.628Z"],["b_2oSh9NOBKdh","$D2025-06-19T13:22:38.957Z"],["b_0eimJoZyMBh","$D2025-06-19T13:25:59.713Z"],["b_ygZisUu238m","$D2025-06-19T13:33:55.281Z"],["b_ZW4q1nhRRGC","$D2025-06-19T13:40:09.751Z"],["b_G8QCVtuhRkX","$D2025-06-19T13:42:56.114Z"],["b_LRs51KoQ6Wa","$D2025-06-19T13:45:40.663Z"],["b_IMZ2tZ200UK","$D2025-06-19T13:51:12.406Z"],["b_BcF5VXljF2Z","$D2025-06-19T13:55:43.435Z"],["b_4PFBga29eh9","$D2025-06-19T13:57:30.557Z"],["b_Dd6LQOWpo6S","$D2025-06-19T14:03:06.786Z"],["b_8hhhzh5tKmm","$D2025-06-19T14:07:26.504Z"],["b_R7NzTJqkbdB","$D2025-06-19T14:12:28.130Z"],["b_L0bJqEE8Bzu","$D2025-06-19T14:22:07.672Z"],["b_pppWzh5mlUK","$D2025-06-19T14:31:49.355Z"],["b_5mTBHl1zvAd","$D2025-06-19T14:42:53.149Z"],["b_kvL8it2n7W6","$D2025-06-19T14:58:30.828Z"],["b_f0SsQPRNpLm","$D2025-06-19T15:04:50.490Z"],["b_uk9Ka0APxx6","$D2025-06-19T15:19:51.569Z"],["b_lwPS3R29tue","$D2025-06-19T15:28:06.764Z"],["b_1ekdNSObM4X","$D2025-06-19T15:32:24.612Z"],["b_tPTgRB7pCTx","$D2025-06-19T15:41:27.380Z"],["b_LXlsKUMSIIp","$D2025-06-19T15:47:11.177Z"],["b_j6nxHB5cTLJ","$D2025-06-20T00:10:08.589Z"],["b_Wiz0Rs2mkIz","$D2025-06-20T00:14:03.370Z"],["b_xiOzKmmNtpm","$D2025-06-20T00:22:14.020Z"],["b_sw9OkVh2cpm","$D2025-06-20T02:31:57.363Z"],["b_2LasBZ8pniT","$D2025-06-20T02:36:23.417Z"],["b_UsVThwZzyiR","$D2025-06-20T02:38:30.556Z"],["b_n1rvHTzYYuv","$D2025-06-20T02:44:46.723Z"],["b_I46WxTJuUiy","$D2025-06-20T02:51:32.778Z"],["b_yALWdNanzwj","$D2025-06-20T03:19:34.369Z"],["b_JOppKQjWgxz","$D2025-06-20T03:28:23.355Z"],["b_tsjHIZkRZyE","$D2025-06-20T03:51:11.272Z"],["b_DF2zT3beOL3","$D2025-06-20T03:52:52.256Z"],["b_raO40YumGD2","$D2025-06-20T03:56:59.289Z"],["b_uMGMxnaaqMo","$D2025-06-20T03:58:26.662Z"],["b_A1feF7xkOUI","$D2025-06-20T03:59:54.959Z"],["b_rZkiJsd4aup","$D2025-06-20T04:00:05.570Z"],["b_ZskbGCSWOp6","$D2025-06-20T04:11:15.121Z"],["b_drj1BXMQFZV","$D2025-06-20T04:14:16.772Z"],["b_I4xgWQ18Jrl","$D2025-06-20T04:24:01.620Z"],["b_eVCrl93wo8D","$D2025-06-20T04:33:46.554Z"],["b_zB19DeSuhm1","$D2025-06-20T04:40:33.611Z"],["b_6R96RPCQtZv","$D2025-06-20T04:48:12.650Z"],["b_VLodkqGtozi","$D2025-06-20T04:56:42.863Z"],["b_O3z6P9kR9o1","$D2025-06-20T05:23:44.610Z"],["b_mH2q2kAA3G3","$D2025-06-20T05:33:54.824Z"],["b_Yu8MbDrBWcL","$D2025-06-20T05:43:36.582Z"],["b_V55ZLWPPJgy","$D2025-06-20T05:56:25.546Z"],["b_T9WbYEqoKMp","$D2025-06-20T06:09:04.876Z"],["b_Gy7LEioIvcX","$D2025-06-20T06:14:17.762Z"],["b_tr05cXqTejG","$D2025-06-20T07:05:56.332Z"],["b_SQLcSR6PAmU","$D2025-06-20T07:18:36.370Z"],["b_KSJZhsAyCSf","$D2025-06-20T07:38:56.247Z"],["b_McgXFxaLdc3","$D2025-06-20T07:52:34.675Z"],["b_SQLI8oj8UGU","$D2025-06-20T08:05:16.258Z"],["b_FU6ygdAYaPG","$D2025-06-20T08:14:52.569Z"],["b_LitPmBPse6h","$D2025-06-20T08:17:58.117Z"],["b_ugF7OA5tqsA","$D2025-06-20T08:23:55.581Z"],["b_vToVPreM0zJ","$D2025-06-20T08:26:30.853Z"],["b_dbNkaXAy5ld","$D2025-06-20T08:27:27.768Z"],["b_7DH2lGzZO7H","$D2025-06-20T08:28:34.855Z"],["b_L1iXlEGAOni","$D2025-06-20T08:29:41.147Z"],["b_UlfcMm9s2JQ","$D2025-06-20T08:31:21.755Z"],["b_ElbfFrrZeGx","$D2025-06-20T08:53:57.652Z"],["b_cvJgy8pi36k","$D2025-06-20T08:58:30.242Z"],["b_B2E1euru2kW","$D2025-06-20T09:08:14.606Z"],["b_MKE1kCmDS9l","$D2025-06-20T09:11:41.794Z"],["b_4DaKhOObGK8","$D2025-06-20T09:14:53.748Z"],["b_iJ2dr0Vbokw","$D2025-06-20T09:58:13.144Z"],["b_Jam6BYuCRk5","$D2025-06-20T10:09:19.136Z"]] 11a:[["b_MKE1kCmDS9l",false],["b_4DaKhOObGK8",false],["b_Jam6BYuCRk5",false]] 11b:[["b_MKE1kCmDS9l","$undefined"],["b_4DaKhOObGK8",{"git":{"ref":"main","sha":"e5eeb8ae42f5c162fd72024148bcd7490b18141a","type":"github","repoId":0,"repoName":"cnoflowapp","ownerName":"tmeta22","commitMessage":"fix: correct syntax errors in performance-utils.ts\n\nFix malformed backslashes, function syntax, and TypeScript formatting."},"deploymentId":"dpl_AN4PKvxLwsUzhY7uiQop6mCHxRkE"}],["b_Jam6BYuCRk5","$undefined"]] 11c:[["b_MKE1kCmDS9l",null],["b_4DaKhOObGK8",null],["b_Jam6BYuCRk5",null]] 11d:[["b_MKE1kCmDS9l",true],["b_4DaKhOObGK8",true],["b_Jam6BYuCRk5",true]] 11e:[["b_MKE1kCmDS9l",true],["b_4DaKhOObGK8",true],["b_Jam6BYuCRk5",true]] 11f:[] 120:T1de414,[V0_FILE]plaintext:file=".gitignore" isMerged="true" # See https://help.github.com/articles/ignoring-files/ for more about ignoring files. # dependencies /node_modules # next.js /.next/ /out/ # production /build # debug npm-debug.log* yarn-debug.log* yarn-error.log* .pnpm-debug.log* # env files .env* # vercel .vercel # typescript *.tsbuildinfo next-env.d.ts [V0_FILE]markdown:file="README.md" isMerged="true" # CNO System *Automatically synced with your [v0.dev](https://v0.dev) deployments* [![Deployed on Vercel](https://img.shields.io/badge/Deployed%20on-Vercel-black?style=for-the-badge&logo=vercel)](https://vercel.com/metathebs-projects/v0-next-js-project-requirements) [![Built with v0](https://img.shields.io/badge/Built%20with-v0.dev-black?style=for-the-badge)](https://v0.dev/chat/projects/ejCmoEuNkJs) ## Overview This repository will stay in sync with your deployed chats on [v0.dev](https://v0.dev). Any changes you make to your deployed app will be automatically pushed to this repository from [v0.dev](https://v0.dev). ## Deployment Your project is live at: **[https://vercel.com/metathebs-projects/v0-next-js-project-requirements](https://vercel.com/metathebs-projects/v0-next-js-project-requirements)** ## Build your app Continue building your app on: **[https://v0.dev/chat/projects/ejCmoEuNkJs](https://v0.dev/chat/projects/ejCmoEuNkJs)** ## How It Works 1. Create and modify your project using [v0.dev](https://v0.dev) 2. Deploy your chats from the v0 interface 3. Changes are automatically pushed to this repository 4. Vercel deploys the latest version from this repository [V0_FILE]typescriptreact:file="app/(dashboard)/admin/backups/page.tsx" isMerged="true" "use client" import { useState, useEffect } from "react" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Button } from "@/components/ui/button" import { Badge } from "@/components/ui/badge" import { Table, TableBody, TableCell, TableHead, TableHeader, TableRow } from "@/components/ui/table" import { Alert, AlertDescription } from "@/components/ui/alert" import { Tabs, TabsContent, TabsList, TabsTrigger } from "@/components/ui/tabs" import { Progress } from "@/components/ui/progress" import { Download, Trash2, RefreshCw, Database, CheckCircle, XCircle, Clock, AlertTriangle, Shield, Calendar, HardDrive, } from "lucide-react" import { toast } from "sonner" import { useAuth } from "@/lib/auth-context" import { useRouter } from "next/navigation" interface BackupRecord { id: string timestamp: string timestampFormatted: string size: number sizeFormatted: string tables: string[] record_count: number status: "completed" | "failed" | "in_progress" error?: string backup_type: string created_by: string } interface BackupStatistics { totalBackups: number successfulBackups: number failedBackups: number averageSize: string lastBackup: string totalSize: string recentBackups: Array<{ status: string timestamp: string }> } export default function BackupsPage() { const [backups, setBackups] = useState([]) const [statistics, setStatistics] = useState(null) const [loading, setLoading] = useState(true) const [creating, setCreating] = useState(false) const [initializing, setInitializing] = useState(false) const { user } = useAuth() const router = useRouter() useEffect(() => { if (!user || user.role !== "admin") { router.push("/dashboard") } }, [user, router]) useEffect(() => { if (user && user.role === "admin") { loadBackups() loadStatistics() } }, [user]) const loadBackups = async () => { try { const response = await fetch("/api/backup?action=history") const data = await response.json() if (data.success) { setBackups(data.backups) } else { toast.error("Failed to load backups") } } catch (error) { toast.error("Error loading backups") } finally { setLoading(false) } } const loadStatistics = async () => { try { const response = await fetch("/api/backup?action=statistics") const data = await response.json() if (data.success) { setStatistics(data.statistics) } } catch (error) { console.error("Error loading statistics:", error) } } const initializeBackupSystem = async () => { setInitializing(true) try { const response = await fetch("/api/backup", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ action: "initialize" }), }) const data = await response.json() if (data.success) { toast.success("Backup system initialized successfully") loadBackups() loadStatistics() } else { toast.error("Failed to initialize backup system") } } catch (error) { toast.error("Error initializing backup system") } finally { setInitializing(false) } } const createBackup = async () => { setCreating(true) try { const response = await fetch("/api/backup", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ action: "create", createdBy: "admin", }), }) const data = await response.json() if (data.success) { toast.success("Backup created successfully") loadBackups() loadStatistics() } else { toast.error("Failed to create backup") } } catch (error) { toast.error("Error creating backup") } finally { setCreating(false) } } const downloadBackup = async (backupId: string) => { try { const response = await fetch(`/api/backup/download/${backupId}`) if (response.ok) { const blob = await response.blob() const url = window.URL.createObjectURL(blob) const a = document.createElement("a") a.href = url a.download = `backup_${backupId}.json` document.body.appendChild(a) a.click() window.URL.revokeObjectURL(url) document.body.removeChild(a) toast.success("Backup downloaded successfully") } else { toast.error("Failed to download backup") } } catch (error) { toast.error("Error downloading backup") } } const deleteBackup = async (backupId: string) => { if (!confirm("Are you sure you want to delete this backup?")) return try { const response = await fetch(`/api/backup/${backupId}`, { method: "DELETE", }) const data = await response.json() if (data.success) { toast.success("Backup deleted successfully") loadBackups() loadStatistics() } else { toast.error("Failed to delete backup") } } catch (error) { toast.error("Error deleting backup") } } const cleanupOldBackups = async () => { if (!confirm("This will delete backups older than 30 days. Continue?")) return try { const response = await fetch("/api/backup?action=cleanup&retention=30") const data = await response.json() if (data.success) { toast.success(`Cleaned up ${data.deletedCount} old backups`) loadBackups() loadStatistics() } else { toast.error("Failed to cleanup old backups") } } catch (error) { toast.error("Error cleaning up backups") } } const getStatusIcon = (status: string) => { switch (status) { case "completed": return case "failed": return case "in_progress": return default: return } } const getStatusBadge = (status: string) => { const variants = { completed: "default", failed: "destructive", in_progress: "secondary", } as const return {status.replace("_", " ")} } if (!user || user.role !== "admin") { return (

Access denied. Admin privileges required.

) } if (loading) { return (

) } return (

Database Backups

Manage and monitor your database backups

Overview Backup History Settings {statistics && (

Total Backups

{statistics.totalBackups}

{statistics.successfulBackups} successful

Success Rate

{statistics.totalBackups > 0 ? Math.round((statistics.successfulBackups / statistics.totalBackups) * 100) : 0} %

0 ? (statistics.successfulBackups / statistics.totalBackups) * 100 : 0 } className="mt-2" /> Total Size

{statistics.totalSize}

Avg: {statistics.averageSize}

Last Backup

{statistics.lastBackup}

{statistics.failedBackups} failed total

)} Recent Backup Activity Latest backup operations and their status {statistics?.recentBackups && statistics.recentBackups.length > 0 ? (

{statistics.recentBackups.map((backup, index) => (

{getStatusIcon(backup.status)} {backup.timestamp}

{getStatusBadge(backup.status)}

))}

) : (

No recent backup activity

)} Backup History All database backups with download and management options {backups.length > 0 ? ( Status Timestamp Size Tables Records Created By Actions {backups.map((backup) => (

{getStatusIcon(backup.status)} {getStatusBadge(backup.status)}

{backup.timestampFormatted} {backup.sizeFormatted} {backup.tables?.length || 0} {backup.record_count?.toLocaleString() || 0} {backup.created_by}

{backup.status === "completed" && ( )}

))}

) : (

No backups found

)} Backup Settings Configure backup retention and cleanup policies Backup Recommendations:

• Create daily backups for production systems
• Store backups in multiple locations
• Test backup restoration regularly
• Keep at least 30 days of backup history

) } [V0_FILE]typescriptreact:file="app/(dashboard)/admin/database/page.tsx" isMerged="true" "use client" import { useState, useEffect } from "react" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Button } from "@/components/ui/button" import { Badge } from "@/components/ui/badge" import { Alert, AlertDescription } from "@/components/ui/alert" import { Separator } from "@/components/ui/separator" import { Database, RefreshCw, CheckCircle, XCircle, AlertTriangle, Wifi, WifiOff, Server, Key } from "lucide-react" import { toast } from "sonner" interface DatabaseDiagnostics { hasValidUrl: boolean urlSource: string connectionTest: boolean error?: string timestamp: string availableUrls: Record } interface ConnectionTest { success: boolean message: string details?: { timestamp?: string version?: string testResult?: number error?: string } } export default function DatabasePage() { const [diagnostics, setDiagnostics] = useState(null) const [connectionTest, setConnectionTest] = useState(null) const [loading, setLoading] = useState(true) const [reconnecting, setReconnecting] = useState(false) useEffect(() => { loadDiagnostics() }, []) const loadDiagnostics = async () => { try { setLoading(true) const response = await fetch("/api/database/diagnostics") const data = await response.json() if (data.success) { setDiagnostics(data.diagnostics) setConnectionTest(data.connectionTest) } else { toast.error("Failed to load database diagnostics") } } catch (error) { toast.error("Error loading diagnostics") console.error("Error:", error) } finally { setLoading(false) } } const reconnectDatabase = async () => { try { setReconnecting(true) const response = await fetch("/api/database/diagnostics", { method: "POST", }) const data = await response.json() if (data.success) { toast.success("Database reconnected successfully!") setDiagnostics(data.diagnostics) setConnectionTest(data.connectionTest) } else { toast.error("Failed to reconnect to database") } } catch (error) { toast.error("Error reconnecting to database") console.error("Error:", error) } finally { setReconnecting(false) } } const getConnectionStatus = () => { if (!diagnostics || !connectionTest) return "unknown" if (diagnostics.hasValidUrl && connectionTest.success) return "connected" if (diagnostics.hasValidUrl && !connectionTest.success) return "url_valid_connection_failed" return "disconnected" } const getStatusIcon = (status: string) => { switch (status) { case "connected": return case "url_valid_connection_failed": return case "disconnected": return default: return } } const getStatusBadge = (status: string) => { switch (status) { case "connected": return Connected case "url_valid_connection_failed": return URL Valid, Connection Failed case "disconnected": return Disconnected default: return Unknown } } if (loading) { return (

) } const status = getConnectionStatus() return (

Database Connection

Monitor and manage your database connection

{/* Connection Status Overview */} {getStatusIcon(status)} Connection Status Current database connection status and details

Status: {getStatusBadge(status)}

{diagnostics && ( <>

URL Source: {diagnostics.urlSource}

Last Check: {new Date(diagnostics.timestamp).toLocaleString()}

)} {connectionTest?.details && ( <>

Connection Details:

{connectionTest.details.version && (

Database Version: {connectionTest.details.version}

)} {connectionTest.details.timestamp && (

Server Time: {new Date(connectionTest.details.timestamp).toLocaleString()}

)}

)} {/* Error Details */} {(diagnostics?.error || connectionTest?.details?.error) && ( Connection Error:
{diagnostics?.error || connectionTest?.details?.error} )} {/* Available URLs */} {diagnostics?.availableUrls && Object.keys(diagnostics.availableUrls).length > 0 && ( Available Database URLs Environment variables containing database connection strings

{Object.entries(diagnostics.availableUrls).map(([key, value]) => (

{key}

{key === diagnostics.urlSource && ( Active )} {value.replace(/:\/\/([^:]+):([^@]+)@/, "://***:***@").substring(0, 50)}...

))}

)} {/* Connection Instructions */} Troubleshooting Steps to resolve connection issues

Common Solutions:

• Check if your database service is running
• Verify environment variables are set correctly
• Ensure your IP is whitelisted (for cloud databases)
• Check if SSL/TLS settings are correct
• Verify database credentials and permissions

{status === "disconnected" && ( No database connection available.
The application is running in mock mode. Please check your environment variables and click "Reconnect" to restore database functionality. )}

) } [V0_FILE]typescriptreact:file="app/(dashboard)/admin/neon-connect/page.tsx" isMerged="true" "use client" import { useState } from "react" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Button } from "@/components/ui/button" import { Badge } from "@/components/ui/badge" import { Alert, AlertDescription } from "@/components/ui/alert" import { Database, RefreshCw, CheckCircle, XCircle, AlertTriangle } from "lucide-react" import { toast } from "sonner" interface ConnectionResult { source: string status: "success" | "failed" | "missing" message: string details?: { database?: string version?: string timestamp?: string test?: number } url_preview?: string } export default function NeonConnectPage() { const [results, setResults] = useState([]) const [loading, setLoading] = useState(false) const [lastTest, setLastTest] = useState(null) const testNeonConnection = async () => { try { setLoading(true) setResults([]) const response = await fetch("/api/database/neon-connect", { method: "POST", }) const data = await response.json() if (data.success) { toast.success("Successfully connected to Neon database!") } else { toast.error("Failed to connect to Neon database") } setResults(data.results || []) setLastTest(data.timestamp) } catch (error) { toast.error("Error testing Neon connection") console.error("Error:", error) } finally { setLoading(false) } } const getStatusIcon = (status: string) => { switch (status) { case "success": return case "failed": return case "missing": return default: return } } const getStatusBadge = (status: string) => { switch (status) { case "success": return Connected case "failed": return Failed case "missing": return Missing default: return Unknown } } return (

🦓 Neon Yellow Zebra Connection

Test connection to your Neon database

{lastTest && ( Last test: {new Date(lastTest).toLocaleString()} )} {results.length > 0 && (

Connection Test Results

{results.map((result, index) => (

{getStatusIcon(result.status)} {result.source}

{getStatusBadge(result.status)} {result.url_preview && ( {result.url_preview} )}

{result.message}

{result.details && (

Connection Details:

{result.details.database && (

Database: {result.details.database}

)} {result.details.version && (

Version: {result.details.version}

)} {result.details.timestamp && (

Server Time: {new Date(result.details.timestamp).toLocaleString()}

)} {result.details.test && (

Test Query: {result.details.test}

)}

))}

)} Environment Variables Check Make sure these environment variables are set in your deployment

DATABASE_URL

NEON_DATABASE_URL

POSTGRES_URL

POSTGRES_PRISMA_URL

POSTGRES_URL_NON_POOLING

) } [V0_FILE]typescriptreact:file="app/(dashboard)/calendar/page.tsx" isMerged="true" "use client" import type React from "react" import { useState, useEffect } from "react" import { CalendarIcon, Clock, MapPin, Users, Plus, Edit, Trash2, CheckCircle } from "lucide-react" import { Card, CardContent, CardDescription, CardHeader, CardTitle } from "@/components/ui/card" import { Badge } from "@/components/ui/badge" import { Button } from "@/components/ui/button" import { Dialog, DialogContent, DialogHeader, DialogTitle, DialogTrigger } from "@/components/ui/dialog" import { Input } from "@/components/ui/input" import { Label } from "@/components/ui/label" import { Textarea } from "@/components/ui/textarea" import { Select, SelectContent, SelectItem, SelectTrigger, SelectValue } from "@/components/ui/select" import { useToast } from "@/hooks/use-toast" import { useAuth } from "@/lib/auth-context" import { BackButton } from "@/components/back-button" interface CalendarEvent { id: number title: string description?: string date: string time?: string event_type: string personnel_required?: string is_done?: boolean completed_at?: string created_by: string created_at: string } function getEventTypeColor(type: string) { switch (type.toLowerCase()) { case "meeting": return "bg-blue-100 text-blue-800 dark:bg-blue-900 dark:text-blue-200" case "deadline": return "bg-red-100 text-red-800 dark:bg-red-900 dark:text-red-200" case "milestone": return "bg-green-100 text-green-800 dark:bg-green-900 dark:text-green-200" case "reminder": return "bg-yellow-100 text-yellow-800 dark:bg-yellow-900 dark:text-yellow-200" default: return "bg-gray-100 text-gray-800 dark:bg-gray-800 dark:text-gray-200" } } function formatDate(dateString: string) { const date = new Date(dateString) return date.toLocaleDateString("en-US", { weekday: "long", year: "numeric", month: "long", day: "numeric", }) } export default function CalendarPage() { const [events, setEvents] = useState([]) const [isDialogOpen, setIsDialogOpen] = useState(false) const [isEditDialogOpen, setIsEditDialogOpen] = useState(false) const [selectedEvent, setSelectedEvent] = useState(null) const [loading, setLoading] = useState(true) const [formData, setFormData] = useState({ title: "", description: "", date: "", time: "", event_type: "meeting", personnel_required: "", }) const { user } = useAuth() const { toast } = useToast() const isAdmin = user?.role === "admin" useEffect(() => { loadEvents() }, []) const loadEvents = async () => { try { setLoading(true) const response = await fetch("/api/calendar") if (!response.ok) { throw new Error("Failed to fetch calendar events") } const data = await response.json() setEvents(Array.isArray(data) ? data : []) } catch (error) { console.error("Failed to load calendar events:", error) toast({ title: "Error", description: "Failed to load calendar events", variant: "destructive", }) } finally { setLoading(false) } } const handleSubmit = async (e: React.FormEvent) => { e.preventDefault() if (!formData.title || !formData.date) { toast({ title: "Error", description: "Title and date are required", variant: "destructive", }) return } try { const response = await fetch("/api/calendar", { method: "POST", headers: { "Content-Type": "application/json", }, body: JSON.stringify({ ...formData, created_by: user?.username || "system", }), }) if (!response.ok) { throw new Error("Failed to create event") } setIsDialogOpen(false) setFormData({ title: "", description: "", date: "", time: "", event_type: "meeting", personnel_required: "", }) loadEvents() toast({ title: "Success", description: "Event created successfully", }) } catch (error) { console.error("Failed to create event:", error) toast({ title: "Error", description: "Failed to create event", variant: "destructive", }) } } const handleEditEvent = (event: CalendarEvent) => { setSelectedEvent(event) setFormData({ title: event.title, description: event.description || "", date: event.date, time: event.time || "", event_type: event.event_type || "meeting", personnel_required: event.personnel_required || "", }) setIsEditDialogOpen(true) } const handleEditSubmit = async (e: React.FormEvent) => { e.preventDefault() if (!selectedEvent || !formData.title || !formData.date) { toast({ title: "Error", description: "Title and date are required", variant: "destructive", }) return } try { const response = await fetch(`/api/calendar/${selectedEvent.id}`, { method: "PUT", headers: { "Content-Type": "application/json", }, body: JSON.stringify(formData), }) if (!response.ok) { throw new Error("Failed to update event") } setIsEditDialogOpen(false) setSelectedEvent(null) setFormData({ title: "", description: "", date: "", time: "", event_type: "meeting", personnel_required: "", }) loadEvents() toast({ title: "Success", description: "Event updated successfully", }) } catch (error) { console.error("Failed to update event:", error) toast({ title: "Error", description: "Failed to update event", variant: "destructive", }) } } const handleMarkAsDone = async (id: number) => { try { const response = await fetch(`/api/calendar/${id}/complete`, { method: "PUT", headers: { "Content-Type": "application/json", }, }) if (!response.ok) { throw new Error("Failed to mark event as done") } loadEvents() toast({ title: "Success", description: "Event marked as completed", }) } catch (error) { console.error("Failed to mark event as done:", error) toast({ title: "Error", description: "Failed to mark event as done", variant: "destructive", }) } } const handleDeleteEvent = async (id: number) => { if (!isAdmin) { toast({ title: "Access Denied", description: "Only administrators can delete events", variant: "destructive", }) return } if (!confirm("Are you sure you want to delete this event?")) { return } try { const response = await fetch(`/api/calendar/${id}`, { method: "DELETE", }) if (!response.ok) { throw new Error("Failed to delete event") } loadEvents() toast({ title: "Success", description: "Event deleted successfully", }) } catch (error) { console.error("Failed to delete event:", error) toast({ title: "Error", description: "Failed to delete event", variant: "destructive", }) } } // Group events by month const eventsByMonth: Record = {} events.forEach((event: CalendarEvent) => { const date = new Date(event.date) const monthYear = date.toLocaleDateString("en-US", { month: "long", year: "numeric" }) if (!eventsByMonth[monthYear]) { eventsByMonth[monthYear] = [] } eventsByMonth[monthYear].push(event) }) if (loading) { return (

Calendar

{[...Array(6)].map((_, i) => (

))}

) } return (

Calendar

{isAdmin && (