Spaces:
Runtime error
Runtime error
File size: 4,338 Bytes
41de39d 2c97468 41de39d dc65a06 41de39d 5968265 41de39d 5968265 41de39d 5968265 41de39d d747060 41de39d 29c46e8 d747060 29c46e8 dc65a06 d747060 dc65a06 |
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 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 |
import { Request, Response } from 'express';
import Setting from '../models/settings';
import { Op, FindOptions } from 'sequelize';
import { logger } from '../utils/logger';
const buildSettingsWhereClause = (filter: Record<string, any>): any => {
const whereClause: any = {};
if (filter) {
if (filter.date) {
const date = new Date(filter.date);
if (!isNaN(date.getTime())) {
const startOfDay = new Date(date);
startOfDay.setHours(0, 0, 0, 0);
const endOfDay = new Date(date);
endOfDay.setHours(23, 59, 59, 999);
whereClause.created_at = {
[Op.gte]: startOfDay,
[Op.lte]: endOfDay
};
}
}
if (filter.updated_by) {
whereClause.updated_by = { [Op.eq]: filter.updated_by };
}
if (filter.created_before) {
const beforeDate = new Date(filter.created_before);
if (!isNaN(beforeDate.getTime())) {
whereClause.created_at = { ...whereClause.created_at, [Op.lte]: beforeDate };
}
}
if (filter.created_after) {
const afterDate = new Date(filter.created_after);
if (!isNaN(afterDate.getTime())) {
whereClause.created_at = { ...whereClause.created_at, [Op.gte]: afterDate };
}
}
}
return whereClause;
};
const getSettings = async (req: Request, res: Response) => {
try {
const { sort_by, sort_order, page, limit } = req.query;
const filter = req.query.filter as Record<string, any>;
const allowedSortColumns = ['id', 'updated_by', 'created_at'];
const whereClause = buildSettingsWhereClause(filter);
const currentPage = parseInt(page as string) || 1;
const pageSize = parseInt(limit as string) || 10;
const options: FindOptions = {
where: whereClause,
limit: pageSize,
offset: (currentPage - 1) * pageSize,
order: []
};
if (sort_by && allowedSortColumns.includes(sort_by as string)) {
options.order = [[sort_by as string, sort_order === 'desc' ? 'DESC' : 'ASC']];
} else {
options.order = [['id', 'ASC']];
}
const [settings, totalSettings] = await Promise.all([
Setting.findAll(options),
Setting.count({ where: whereClause }),
]);
const responseData = {
page: currentPage,
limit: pageSize,
total: totalSettings,
data: settings
};
return res.status(200).json(responseData);
}
catch (error) {
logger.error('Error fetching settings:');
logger.error(error);
return res.status(500).json({ error: 'Error fetching settings' });
}
}
const getSettingById = async (req: Request, res: Response) => {
try {
const { id } = req.params;
const setting = await Setting.findByPk(id);
if (!setting) {
return res.status(404).json({ error: 'Setting not found' });
}
return res.status(200).json(setting);
} catch (error) {
logger.error('Error fetching setting:');
logger.error(error);
return res.status(500).json({ error: 'Error fetching setting' });
}
}
const updateSettingById = async (req: Request, res: Response) => {
try {
const { id } = req.params;
const {setting_key, setting_value} = req.body;
const setting = await Setting.findByPk(id);
if (!setting) {
return res.status(404).json({ error: 'Setting not found' });
}
if(setting_key){
setting.setting_key = setting_key;
}
if(setting_value){
setting.setting_value = setting_value;
}
// TODO: to change it once we have authentication in place
setting.updated_by = 1;
await setting.save();
return res.status(200).json(setting);
}catch (error) {
logger.error('Error updating setting:');
logger.error(error);
return res.status(500).json({ error: 'Error updating setting' });
}
}
export { getSettings, getSettingById, updateSettingById }; |