From 2ae0f9c04d24c7d24d72e73e64935981748ab97b Mon Sep 17 00:00:00 2001
From: Bobby <bobbyskhs@gmail.com>
Date: Wed, 4 May 2022 03:27:47 -0400
Subject: all transactions

---
 interface/controllers/transactions.controller.js | 65 ++++++++++++++++++++++++
 1 file changed, 65 insertions(+)
 create mode 100644 interface/controllers/transactions.controller.js

(limited to 'interface/controllers/transactions.controller.js')

diff --git a/interface/controllers/transactions.controller.js b/interface/controllers/transactions.controller.js
new file mode 100644
index 0000000..2627a0f
--- /dev/null
+++ b/interface/controllers/transactions.controller.js
@@ -0,0 +1,65 @@
+const {QueryTypes} = require('sequelize');
+const { sequelize } = require("../models");
+
+const getAgricultureTransactions = (limit, offset) => {
+    const query = `SELECT * FROM getAggricultureDetails() limit ${limit} offset ${offset};`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getAgricultureTransactionsCount = () => {
+    const query = `SELECT count(*) as count FROM getAggricultureDetails();`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getHospitalTransactions = (limit, offset) => {
+    const query = `SELECT * FROM getHospitalDetails() limit ${limit} offset ${offset};`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getHospitalTransactionsCount = () => {
+    const query = `SELECT count(*) as count FROM getHospitalDetails();`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getLPGTransactions = (limit, offset) => {
+    const query = `SELECT * FROM getLPGDetails() limit ${limit} offset ${offset};`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getLPGTransactionsCount = () => {
+    const query = `SELECT count(*) as count FROM getLPGDetails();`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getNREGSTransactions = (limit, offset) => {
+    const query = `SELECT * FROM getNREGSDetails() limit ${limit} offset ${offset};`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getNREGSTransactionsCount = () => {
+    const query = `SELECT count(*) as count FROM getNREGSDetails();`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getPensionTransactions = (limit, offset) => {
+    const query = `SELECT * FROM getPensionDetails() limit ${limit} offset ${offset};`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+const getPensionTransactionsCount = () => {
+    const query = `SELECT count(*) as count FROM getPensionDetails();`;
+    return sequelize.query(query, { type: QueryTypes.SELECT })
+}
+
+module.exports = {
+    getAgricultureTransactions,
+    getAgricultureTransactionsCount,
+    getHospitalTransactions,
+    getHospitalTransactionsCount,
+    getLPGTransactions,
+    getLPGTransactionsCount,
+    getNREGSTransactions,
+    getNREGSTransactionsCount,
+    getPensionTransactions,
+    getPensionTransactionsCount
+}
-- 
cgit v1.2.3