IO-1559 Change File name as per Koyel

server/data/claimscorp.js

@@ -17,7 +17,7 @@ let Client = require("ssh2-sftp-client");
 const client = require("../graphql-client/graphql-client").client;
 const { sendServerEmail } = require("../email/sendemail");
 const CCDineroFormat = "0,0.00";
-const AhDateFormat = "MMDDYYYY";
+const AhDateFormat = "MM/DD/YYYY";
 
 const repairOpCodes = ["OP4", "OP9", "OP10"];
 const replaceOpCodes = ["OP2", "OP5", "OP11", "OP12"];
@@ -62,22 +62,24 @@ exports.default = async (req, res) => {
             start: start
               ? moment(start).startOf("day")
               : moment().subtract(5, "days").startOf("day"),
-            ...(end && { end: moment(end).startOf("day") }),
+            ...(end && { end: moment(end).endOf("day") }),
           }
         );
 
         const claimsCorpObject = {
-          ClaimsCorpExport: {
-            ShopID: bodyshops_by_pk.claimscorpid,
-            ShopName: bodyshops_by_pk.shopname,
-            RO: jobs.map((j) =>
-              CreateRepairOrderTag(
-                { ...j, bodyshop: bodyshops_by_pk },
-                function ({ job, error }) {
-                  erroredJobs.push({ job: job, error: error.toString() });
-                }
-              )
-            ),
+          DataFeed: {
+            ShopInfo: {
+              ShopID: bodyshops_by_pk.claimscorpid,
+              ShopName: bodyshops_by_pk.shopname,
+              RO: jobs.map((j) =>
+                CreateRepairOrderTag(
+                  { ...j, bodyshop: bodyshops_by_pk },
+                  function ({ job, error }) {
+                    erroredJobs.push({ job: job, error: error.toString() });
+                  }
+                )
+              ),
+            },
           },
         };
 
@@ -100,9 +102,9 @@ exports.default = async (req, res) => {
           .end({ allowEmptyTags: true });
 
         allxmlsToUpload.push({
-          count: claimsCorpObject.ClaimsCorpExport.RO.length,
+          count: claimsCorpObject.DataFeed.ShopInfo.RO.length,
           xml: ret,
-          filename: `${bodyshop.claimscorpid}-MIS-${moment().format(
+          filename: `${bodyshop.claimscorpid}-${moment().format(
             "YYYYMMDDTHHMMss"
           )}.xml`,
         });
@@ -243,7 +245,7 @@ const CreateRepairOrderTag = (job, errorCallback) => {
 
   try {
     const ret = {
-      RONumber: job.ro_number,
+      RoNumber: job.ro_number,
       Customer: {
         CustomerZip: (job.ownr_zip && job.ownr_zip.substring(0, 3)) || "",
         CustomerState: job.ownr_st || "",
@@ -261,8 +263,8 @@ const CreateRepairOrderTag = (job, errorCallback) => {
         VIN: job.v_vin || "",
       },
       Carrier: {
-        InsuranceCo: job.ins_co_nm || "",
-        CompanyName: job.ins_co_nm || "",
+        UniqueID: job.ins_co_nm || "",
+        InsuranceCompany: job.ins_co_nm || "",
       },
       Claim: job.clm_no || "",
       Contacts: {
@@ -279,7 +281,7 @@ const CreateRepairOrderTag = (job, errorCallback) => {
           : "",
         Phone1: "",
         Phone2: "",
-        EstimatorName: `${job.est_ct_ln ? job.est_ct_ln : ""}${
+        Estimator: `${job.est_ct_ln ? job.est_ct_ln : ""}${
           job.est_ct_ln ? ", " : ""
         }${job.est_ct_fn ? job.est_ct_fn : ""}`,
         BodyTechnician: job.employee_body_rel
@@ -310,7 +312,7 @@ const CreateRepairOrderTag = (job, errorCallback) => {
           (job.date_estimated &&
             moment(job.date_estimated).format(AhDateFormat)) ||
           "",
-        DateofLoss:
+        DateLoss:
           (job.loss_date && moment(job.loss_date).format(AhDateFormat)) || "",
         DateFNOL: "",
         DateContact: "",
@@ -337,7 +339,7 @@ const CreateRepairOrderTag = (job, errorCallback) => {
               .tz(job.bodyshop.timezone)
               .format(AhDateFormat)) ||
           "",
-        StartDate: job.date_repairstarted
+        DateStart: job.date_repairstarted
           ? (job.date_repairstarted &&
               moment(job.date_repairstarted)
                 .tz(job.bodyshop.timezone)
@@ -382,7 +384,7 @@ const CreateRepairOrderTag = (job, errorCallback) => {
           "",
         BilledDate: "",
         PaidInFullDate: "",
-        RoStatus: job.tlos_ind
+        ROStatus: job.tlos_ind
           ? "TOT"
           : StatusMapping(job.status, job.bodyshop.md_ro_statuses),
       },
@@ -392,14 +394,10 @@ const CreateRepairOrderTag = (job, errorCallback) => {
           .add(Dinero(job.job_totals.rates.lad.total))
           .add(Dinero(job.job_totals.rates.las.total))
           .toFormat(CCDineroFormat),
-        Refinish: Dinero(job.job_totals.rates.lar.total).toFormat(
-          CCDineroFormat
-        ),
+        Paint: Dinero(job.job_totals.rates.lar.total).toFormat(CCDineroFormat),
         Prep: Dinero().toFormat(CCDineroFormat),
         Frame: Dinero(job.job_totals.rates.laf.total).toFormat(CCDineroFormat),
-        Mechanical: Dinero(job.job_totals.rates.lam.total).toFormat(
-          CCDineroFormat
-        ),
+        Mech: Dinero(job.job_totals.rates.lam.total).toFormat(CCDineroFormat),
         Glass: Dinero(job.job_totals.rates.lag.total).toFormat(CCDineroFormat),
         Elec: Dinero(job.job_totals.rates.lae.total).toFormat(CCDineroFormat),
         Detail: detailAdjustments.amount.toFormat(CCDineroFormat),
@@ -446,6 +444,7 @@ const CreateRepairOrderTag = (job, errorCallback) => {
         Towing: Dinero(job.job_totals.additional.towing).toFormat(
           CCDineroFormat
         ),
+        Storage: "0.00",
         Rental:
           job.job_totals.additional.additionalCostItems.includes(
             "ATS Amount"
@@ -480,17 +479,17 @@ const CreateRepairOrderTag = (job, errorCallback) => {
           .filter((line) => repairOpCodes.includes(line.lbr_op))
           .reduce((acc, val) => acc + val.mod_lb_hrs, 0)
           .toFixed(2),
-        BodyReplaceHours: job.joblines
+        BodyReplacehours: job.joblines
           .filter((line) => replaceOpCodes.includes(line.lbr_op))
           .reduce((acc, val) => acc + val.mod_lb_hrs, 0)
           .toFixed(2),
         Paint: job.job_totals.rates.lar.hours.toFixed(2),
         Prep: "0.00",
-        FrameHours: job.job_totals.rates.laf.hours.toFixed(2),
-        MechanicalHours: job.job_totals.rates.lam.hours.toFixed(2),
-        GlassHours: job.job_totals.rates.lag.hours.toFixed(2),
-        ElectricalHours: job.job_totals.rates.lae.hours.toFixed(2),
-        DetailHours: detailAdjustments.hours,
+        Frame: job.job_totals.rates.laf.hours.toFixed(2),
+        Mech: job.job_totals.rates.lam.hours.toFixed(2),
+        Glass: job.job_totals.rates.lag.hours.toFixed(2),
+        Elec: job.job_totals.rates.lae.hours.toFixed(2),
+        Detail: detailAdjustments.hours,
         Reassem: "0.00",
         Other: (
           job.job_totals.rates.la1.hours +
@@ -522,7 +521,7 @@ const CreateRepairOrderTag = (job, errorCallback) => {
         AM: repairCosts.PartsAMCost.toFormat(CCDineroFormat),
         MechParts: Dinero().toFormat(CCDineroFormat),
         OtherParts: Dinero().toFormat(CCDineroFormat), //Check Synergy
-        OtherCosts: repairCosts.PartsOtherCost.toFormat(CCDineroFormat),
+        OtherCost: repairCosts.PartsOtherCost.toFormat(CCDineroFormat),
         Sublet: repairCosts.SubletTotalCost.toFormat(CCDineroFormat),
         Towing: repairCosts.TowingTotalCost.toFormat(CCDineroFormat),
         Storage: repairCosts.StorageTotalCost.toFormat(CCDineroFormat),