Remove weekly report jobmain

1 files changed, 0 insertions, 56 deletions

diff --git a/src/db/payments.rs b/src/db/payments.rs
index c3013d2..23b4d2f 100644
--- a/src/db/payments.rs
+++ b/src/db/payments.rs
@@ -7,7 +7,6 @@ use tokio_rusqlite::{
 use crate::db::utils;
 use crate::model::frequency::Frequency;
 use crate::model::payment;
-use crate::model::report::Report;
 use crate::queries;
 use crate::utils::text;
 
@@ -567,58 +566,3 @@ pub async fn create_monthly_payments(conn: &Connection) {
         Err(err) => log::error!("Error creating monthly payments: {:?}", err),
     }
 }
-
-pub async fn last_week(conn: &Connection) -> Vec<Report> {
-    let query = r#"
-        SELECT
-            strftime('%d/%m/%Y', payments.date) AS date,
-            (payments.name || ' (' || users.name || ')') AS name,
-            payments.cost AS amount,
-            (CASE
-                WHEN payments.deleted_at IS NOT NULL
-                THEN 'Deleted'
-                WHEN
-                    payments.updated_at IS NOT NULL
-                    AND payments.created_at < date('now', 'weekday 0', '-13 days')
-                THEN 'Updated'
-                ELSE 'Created'
-            END) AS action
-        FROM payments
-        INNER JOIN users
-        ON payments.user_id = users.id
-        WHERE
-            payments.frequency = 'Punctual'
-            AND (
-                (
-                    payments.created_at >= date('now', 'weekday 0', '-13 days')
-                    AND payments.created_at < date('now', 'weekday 0', '-6 days')
-                ) OR (
-                    payments.updated_at >= date('now', 'weekday 0', '-13 days')
-                    AND payments.updated_at < date('now', 'weekday 0', '-6 days')
-                ) OR (
-                    payments.deleted_at >= date('now', 'weekday 0', '-13 days')
-                    AND payments.deleted_at < date('now', 'weekday 0', '-6 days')
-                )
-            )
-        ORDER BY payments.date
-    "#;
-
-    let res = conn
-        .call(move |conn| {
-            let mut stmt = conn.prepare(query)?;
-            let xs = stmt
-                .query_map([], utils::row_to_report)?
-                .collect::<Result<Vec<Report>, _>>()?;
-
-            Ok(xs)
-        })
-        .await;
-
-    match res {
-        Ok(payments) => payments,
-        Err(err) => {
-            log::error!("Error listing payments for report: {:?}", err);
-            vec![]
-        }
-    }
-}