add published start filter

codercatdev · codercatdev · commit 6ef4eca0af54 · 2022-06-20T15:39:25.000-04:00
diff --git a/backend/firebase/functions/src/utilities/notion.server.ts b/backend/firebase/functions/src/utilities/notion.server.ts
@@ -109,6 +109,12 @@ export const getAuthorBySlugService = async ({
             equals: 'published',
           },
         },
+        {
+          property: 'start',
+          date: {
+            on_or_before: new Date().toISOString(),
+          },
+        },
       ],
     },
   });
@@ -342,6 +348,12 @@ export const queryByPublished = async (
           equals: 'published',
         },
       },
+      {
+        property: 'start',
+        date: {
+          on_or_before: new Date().toISOString(),
+        },
+      },
     ],
   };
 
@@ -490,6 +502,12 @@ export const queryNotionDbBySlug = async (
               equals: 'published',
             },
           },
+          {
+            property: 'start',
+            date: {
+              on_or_before: new Date().toISOString(),
+            },
+          },
         ],
       ],
     };
@@ -552,6 +570,12 @@ export const querySectionsByCourseId = async (
             },
           },
         },
+        {
+          property: 'start',
+          date: {
+            on_or_before: new Date().toISOString(),
+          },
+        },
       ],
     };
   }
diff --git a/frontend/main/src/services/notion.server.ts b/frontend/main/src/services/notion.server.ts
@@ -91,6 +91,12 @@ export const getAuthorBySlugService = async ({
             equals: 'published',
           },
         },
+        {
+          property: 'start',
+          date: {
+            on_or_before: new Date().toISOString(),
+          },
+        },
       ],
     },
   });
@@ -382,6 +388,12 @@ export const queryByPublished = async (
           equals: 'published',
         },
       },
+      {
+        property: 'start',
+        date: {
+          on_or_before: new Date().toISOString(),
+        },
+      },
     ],
   };
 
@@ -486,6 +498,12 @@ export const queryNotionDbBySlug = async (
               equals: 'published',
             },
           },
+          {
+            property: 'start',
+            date: {
+              on_or_before: new Date().toISOString(),
+            },
+          },
         ],
       ],
     };
@@ -585,6 +603,12 @@ export const querySectionsByCourseId = async (
             },
           },
         },
+        {
+          property: 'start',
+          date: {
+            on_or_before: new Date().toISOString(),
+          },
+        },
       ],
     };
   }
