96 lines
3.0 KiB
TypeScript
96 lines
3.0 KiB
TypeScript
import { addDays, format } from "date-fns";
|
|
import { formatInTimeZone } from "date-fns-tz";
|
|
import { eq } from "drizzle-orm";
|
|
import { db } from "../../../../database/dbclient.js";
|
|
import { settings } from "../../../../database/schema/settings.js";
|
|
import { tryCatch } from "../../../globalUtils/tryCatch.js";
|
|
import { query } from "../../sqlServer/prodSqlServer.js";
|
|
import { deliveryByDateRange } from "../../sqlServer/querys/dataMart/deleveryByDateRange.js";
|
|
|
|
export const getDeliveryByDateRange = async (data: any | null) => {
|
|
// const { data: plantToken, error: plantError } = await tryCatch(
|
|
// db.select().from(settings).where(eq(settings.name, "plantToken"))
|
|
// );
|
|
// if (plantError) {
|
|
// return {
|
|
// success: false,
|
|
// message: "Error getting Settings",
|
|
// data: plantError,
|
|
// };
|
|
// }
|
|
let deliverys: any = [];
|
|
|
|
let updatedQuery = deliveryByDateRange;
|
|
|
|
// start days can be sent over
|
|
if (data?.start) {
|
|
updatedQuery = updatedQuery.replaceAll("[startDate]", data.start[0]);
|
|
} else {
|
|
updatedQuery = updatedQuery.replaceAll("[startDate]", "1990-1-1");
|
|
}
|
|
|
|
// end days can be sent over
|
|
if (data?.end) {
|
|
updatedQuery = updatedQuery.replaceAll("[endDate]", data.end[0]);
|
|
} else {
|
|
const defaultEndDate = format(addDays(new Date(Date.now()), 5), "yyyy-M-d");
|
|
updatedQuery = updatedQuery.replaceAll("[endDate]", defaultEndDate);
|
|
}
|
|
|
|
try {
|
|
const res: any = await query(updatedQuery, "Get Delivery by date range");
|
|
deliverys = res.data;
|
|
//console.log(res.data);
|
|
} catch (error) {
|
|
console.log(error);
|
|
return {
|
|
success: false,
|
|
message: "All Deliveries within the range.",
|
|
data: error,
|
|
};
|
|
}
|
|
|
|
// if (!data) {
|
|
// deliverys = deliverys.splice(1000, 0);
|
|
// }
|
|
// add plant token in
|
|
// const pOrders = deliverys.map((item: any) => {
|
|
// // const dateCon = new Date(item.loadingDate).toLocaleString("en-US", {
|
|
// // month: "numeric",
|
|
// // day: "numeric",
|
|
// // year: "numeric",
|
|
// // hour: "2-digit",
|
|
// // minute: "2-digit",
|
|
// // hour12: false,
|
|
// // });
|
|
|
|
// //const dateCon = new Date(item.loadingDate).toISOString().replace("T", " ").split(".")[0];
|
|
// const dateCon = new Date(item.loadingDate).toISOString().split("T")[0];
|
|
// //const delDate = new Date(item.deliveryDate).toISOString().replace("T", " ").split(".")[0];
|
|
// const delDate = new Date(item.deliveryDate).toISOString().split("T")[0];
|
|
// return {
|
|
// plantToken: plantToken[0].value,
|
|
// ...item,
|
|
// loadingDate: dateCon,
|
|
// deliveryDate: delDate,
|
|
// };
|
|
// });
|
|
return {
|
|
success: true,
|
|
message: "Current open orders",
|
|
data: deliverys.map((i: any) => {
|
|
const orderDate = new Date(i.OrderDate);
|
|
const delDate = new Date(i.DeliveryDate);
|
|
const loadDate = new Date(i.LoadingDate);
|
|
|
|
return {
|
|
...i,
|
|
OrderDate: format(orderDate, "yyyy-MM-dd HH:mm"),
|
|
DeliveryDate: format(delDate, "yyyy-MM-dd HH:mm"),
|
|
LoadingDate: format(loadDate, "yyyy-MM-dd HH:mm"),
|
|
dbDate: i.DeliveryDate,
|
|
};
|
|
}),
|
|
};
|
|
};
|