..
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
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
}
|
|