Resolve Report Center Issue.

(cherry picked from commit 76ea8ca2ed)

.gitignore

@@ -112,3 +112,4 @@ firebase/.env
 .elasticbeanstalk/*
 !.elasticbeanstalk/*.cfg.yml
 !.elasticbeanstalk/*.global.yml
+logs/oAuthClient-log.log

.platform/nginx/conf.d/proxy.conf

@@ -1 +1 @@
-client_max_body_size 15M;
+client_max_body_size 50M;

_reference/OEC/Audatex.xsl

@@ -0,0 +1,586 @@
+<?xml version="1.0" ?>
+<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" >
+    <xsl:template match="/">
+        <xsl:for-each select="//TranslatedData">
+            <xsl:element name="TranslatedData">
+                <xsl:attribute name="TranslationOutputFile">
+                    <xsl:value-of select="@TranslationOutputFile"/>
+                </xsl:attribute>
+                <xsl:choose>
+                    <xsl:when test="Details/@PrgID">
+                        <xsl:copy-of select="Details" />
+                    </xsl:when>
+                    <xsl:otherwise>
+                        <xsl:element name="Details">
+                            <xsl:attribute name="PrgID">OECTrans.ImportTrans</xsl:attribute>
+                            <xsl:for-each select="Details/@*">
+                                <xsl:copy-of select="." />
+                            </xsl:for-each>
+                            <xsl:for-each select="Details/*">
+                                <xsl:copy-of select="." />
+                            </xsl:for-each>
+                        </xsl:element>
+                    </xsl:otherwise>
+                </xsl:choose>
+                <xsl:element name="Header">
+                    <xsl:attribute name="RONum">
+                        <xsl:value-of select="//Envelope/@RONum" />
+                    </xsl:attribute>
+                    <xsl:attribute name="OwnerFName">
+                        <xsl:value-of select="//Admin/@OwnerF"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="OwnerLName">
+                        <xsl:value-of select="//Admin/@OwnerL"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="VIN">
+                        <xsl:value-of select="//Vehicle/@TransVIN" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Mileage">
+                        <xsl:value-of select="//Vehicle/@TransMileage" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Year">
+                        <xsl:value-of select="//Vehicle/@TransYear" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Make">
+                        <xsl:if test="//Vehicle/@ManufName[. != '']" >
+                            <xsl:choose>
+                                <xsl:when test="//Vehicle/@ManufName[. = 'Geo']">CHEV</xsl:when>
+                                <xsl:when test="//Vehicle/@ManufName[. = 'Chev-GMC Truck']">CHEV</xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Vehicle/@ManufName" />
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:if>
+                        <xsl:if test="//Vehicle/@ManufName[. = '']" >
+                            <xsl:value-of select="//Vehicle/@ManufCode" />
+                        </xsl:if>
+                    </xsl:attribute>
+                    <xsl:attribute name="Model">
+                        <xsl:value-of select="//Vehicle/@TransModel" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Description">
+                        <xsl:value-of select="//Vehicle/@TransYear" />
+                        <xsl:text> </xsl:text>
+                        <xsl:value-of select="//Vehicle/@ManufName" />
+                        <xsl:text> </xsl:text>
+                        <xsl:value-of select="//Vehicle/@TransModel" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LastSupplLevel">
+                        <xsl:choose>
+                            <xsl:when test="//Envelope/@TransactionType = 'E'">0</xsl:when>
+                            <xsl:when test="substring(//Envelope/@SupplementNum, 1, 1) = 'S'">
+                                <xsl:value-of select="substring(//Envelope/@SupplementNum, 2)" />
+                            </xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                </xsl:element>
+                <xsl:apply-templates select="PartsList" />
+                <xsl:element name="Envelope">
+                    <xsl:element name="Software">
+                        <xsl:attribute name="Manifest">Audatex.xml</xsl:attribute>
+                        <xsl:attribute name="Descriptor">Audatex.xsl</xsl:attribute>
+                        <xsl:attribute name="System">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Version">
+                            <xsl:value-of select="//Envelope/@SoftwareVersion"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="SystemName">
+                            <xsl:value-of select="//Envelope/@SystemName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateFileID">
+                            <xsl:value-of select="//Envelope/@EstimateFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="UniqueFileID">
+                            <xsl:value-of select="//Envelope/@UniqueFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateID">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>-<xsl:value-of select="//Envelope/@SoftwareVersion"/>-<xsl:value-of select="//Envelope/@UniqueFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateIDv2">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>-<xsl:value-of select="//Envelope/@UniqueFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateFormatVersion">
+                            <xsl:value-of select="//Envelope/@EMSVersion"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                </xsl:element>
+                <xsl:element name="Totals">
+                  <xsl:attribute name="GrandTotalAmount">
+                    <xsl:value-of select="//Total/@GrandTotalAmount"/>
+                  </xsl:attribute>
+                </xsl:element>
+                <xsl:element name="Administrative">
+                    <xsl:element name="Owner">
+                        <xsl:attribute name="FName">
+                            <xsl:value-of select="//Admin/@OwnerF"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="LName">
+                            <xsl:value-of select="//Admin/@OwnerL"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Company">
+                            <!--<xsl:value-of select="//Admin/@OwnerCompanyName"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <!--<xsl:value-of select="//Admin/@OwnerAddr1"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <!--<xsl:value-of select="//Admin/@OwnerAddr2"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <!--<xsl:value-of select="//Admin/@OwnerCity"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin/@OwnerState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <!--<xsl:choose>
+                                <xsl:when test="contains(//Admin/@OwnerZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin/@OwnerZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin/@OwnerZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin/@OwnerZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@OwnerZip)=9">
+                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin/@OwnerZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@OwnerZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <!--<xsl:value-of select="//Admin/@OwnerCountry"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerPhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerPhone1"/>&#32;x<xsl:value-of select="//Admin/@OwnerPhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerPhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerPhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerPhone2"/>&#32;x<xsl:value-of select="//Admin/@OwnerPhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerPhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerFax"/>&#32;x<xsl:value-of select="//Admin/@OwnerFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <!--<xsl:value-of select="//Admin/@OwnerEmail"/>-->
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="InsuranceCompany">
+                        <xsl:attribute name="Id">
+                            <xsl:value-of select="//Admin/@InsuranceCompanyID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Name">
+                            <xsl:value-of select="//Admin/@InsuranceCompanyName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <xsl:value-of select="//Admin/@InsuranceAddr1"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <xsl:value-of select="//Admin/@InsuranceAddr2"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <xsl:value-of select="//Admin/@InsuranceCity"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin/@InsuranceState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <xsl:choose>
+                                <xsl:when test="contains(//Admin/@InsuranceZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin/@InsuranceZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin/@InsuranceZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin/@InsuranceZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@InsuranceZip)=9">
+                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin/@InsuranceZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@InsuranceZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <xsl:value-of select="//Admin/@InsuranceCountry"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsurancePhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@InsurancePhone1"/>&#32;x<xsl:value-of select="//Admin/@InsurancePhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsurancePhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsurancePhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@InsurancePhone2"/>&#32;x<xsl:value-of select="//Admin/@InsurancePhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsurancePhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsuranceFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin/@InsuranceFax"/>&#32;x<xsl:value-of select="//Admin/@InsuranceFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsuranceFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <xsl:value-of select="//Admin/@InsuranceEmail"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Insured">
+                        <xsl:attribute name="LastName">
+                            <xsl:value-of select="//Admin/@InsuranceLName" />
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Claim">
+                        <xsl:attribute name="Number">
+                            <xsl:value-of select="//Admin/@ClaimNumber"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Estimator">
+                        <xsl:attribute name="FName">
+                            <xsl:value-of select="//Admin2/@EstimatorF"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="LName">
+                            <xsl:value-of select="//Admin2/@EstimatorL"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Company">
+                            <xsl:value-of select="//Admin2/@EstimatorCompanyName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="BodyShopCity">
+                            <xsl:value-of select="//Admin2/@BodyShopCity"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="BodyShopName">
+                            <xsl:value-of select="//Admin2/@BodyShopName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <xsl:value-of select="//Admin2/@EstimatorAddr1"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <xsl:value-of select="//Admin2/@EstimatorAddr2"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <xsl:value-of select="//Admin2/@EstimatorCity"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin2/@EstimatorState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <xsl:choose>
+                                <xsl:when test="contains(//Admin2/@EstimatorZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin2/@EstimatorZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin2/@EstimatorZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin2/@EstimatorZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin2/@EstimatorZip)=9">
+                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin2/@EstimatorZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin2/@EstimatorZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <xsl:value-of select="//Admin2/@EstimatorCountry"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorPhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone1"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorPhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorPhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone2"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorPhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorFax"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <xsl:value-of select="//Admin2/@EstimatorEmail"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="RepairInformation">
+                        <xsl:attribute name="VehicleDateIn">
+                            <xsl:if test="string-length(//Admin2/@VehicleInDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@VehicleInDate, ' ')"/>
+                                <xsl:if test="string-length(//Admin2/@VehicleInTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@VehicleInTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@VehicleInTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimatedVehicleDateOut">
+                            <xsl:if test="string-length(//Admin2/@TargetVehicleOutDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@TargetVehicleOutDate,' ')"/>
+                                <xsl:if test="string-length(//Admin2/@TargetVehicleOutTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@TargetVehicleOutTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@TargetVehicleOutTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                        <xsl:attribute name="VehicleDateOut">
+                            <xsl:if test="string-length(//Admin2/@VehicleOutDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@VehicleOutDate, ' ')"/>
+                                <xsl:if test="string-length(//Admin2/@VehicleOutTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@VehicleOutTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@VehicleOutTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                    </xsl:element>
+                </xsl:element>
+            </xsl:element>
+        </xsl:for-each>
+    </xsl:template>
+    <xsl:template match="PartsList">
+        <xsl:element name="PartsList" >
+            <xsl:for-each select="Part">
+                <xsl:element name="Part" >
+                    <!-- Part number translation rules -->
+                    <xsl:variable name="OEMPartNumber">
+                        <xsl:if test="substring(@TDPartNum, string-length(@TDPartNum) - 7) != ' GM PART'">
+                            <xsl:value-of select="@TDPartNum" />
+                        </xsl:if>
+                        <xsl:if test="substring(@TDPartNum, string-length(@TDPartNum) - 7) = ' GM PART'">
+                            <xsl:value-of select="substring-before(@TDPartNum,' GM PART')" />
+                        </xsl:if>
+                    </xsl:variable>
+                    <xsl:variable name="AltPartNumber">
+                        <xsl:value-of select="@AltPartNum"/>
+                    </xsl:variable>
+                    <xsl:variable name="PrimaryPartType">
+                        <xsl:value-of select="@PartType"/>
+                    </xsl:variable>
+                    <xsl:variable name="PrimaryPartNumber">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAN' or @PartType='PAG'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                            <xsl:when test="@PartType!='PAN' and @PartType!='PAG'">
+                                <xsl:choose>
+                                    <xsl:when test="$AltPartNumber!=''">
+                                        <xsl:value-of select="$AltPartNumber"/>
+                                    </xsl:when>
+                                    <xsl:when test="$OEMPartNumber!=''">
+                                        <xsl:value-of select="$OEMPartNumber"/>
+                                    </xsl:when>
+                                    <xsl:otherwise>Salvage or Assembly</xsl:otherwise>
+                                </xsl:choose>
+                            </xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:variable name="SecondaryPartNumber">
+                        <xsl:choose>
+                            <xsl:when test="@PartType!='PAN'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:variable name="SecondaryPartType">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAA'">PAN</xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:attribute name="TDPartNum">
+                        <xsl:value-of select="$PrimaryPartNumber"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="AltPartNum">
+                        <xsl:value-of select="$SecondaryPartNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="ExternalPartType">
+                        <xsl:value-of select="$PrimaryPartType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="ExternalAltPartType">
+                        <xsl:value-of select="$SecondaryPartType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartType">
+                        <xsl:choose>
+                            <xsl:when test="$PrimaryPartType='PAN' or $PrimaryPartType='PAP'">1</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAA' or $PrimaryPartType='PATR'">2</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAL'">3</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAM' or $PrimaryPartType='PAC' or $PrimaryPartType='PAR'">4</xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="AltPartType">
+                        <xsl:choose>
+                            <xsl:when test="$SecondaryPartType='PAN'">1</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAA' or $SecondaryPartType='PATR'">2</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAL'">3</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAM' or $SecondaryPartType='PAC' or $SecondaryPartType='PAR'">4</xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartDesc">
+                        <xsl:value-of select="@TDPartDesc" />
+                    </xsl:attribute>
+                    <xsl:attribute name="TDEstimate">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAN'">
+                                <xsl:value-of select="@TDEstimate" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAM'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAA'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAL'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:otherwise>
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartQty">
+                        <xsl:value-of select="@TDPartQty" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LineNumber">
+                        <xsl:value-of select="@LineNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="SequenceNumber">
+                        <xsl:value-of select="@SequenceNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="SupplLevel">
+                        <xsl:choose>
+                            <xsl:when test="@SupplementLevel = 'E'">0</xsl:when>
+                            <xsl:when test="substring(@SupplementLevel, 1, 1) = 'S'">
+                                <xsl:value-of select="substring(@SupplementLevel, 2)" />
+                            </xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="LaborType">
+                        <xsl:value-of select="@LaborType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LaborHours">
+                      <xsl:value-of select="@LaborHours" />
+                    </xsl:attribute>
+                    <xsl:attribute name="OperationCode">
+                        <xsl:value-of select="@LaborOp" />
+                    </xsl:attribute>
+                    <xsl:attribute name="PriceIncluded">
+                        <xsl:value-of select="@PriceIncluded" />
+                    </xsl:attribute>
+                    <xsl:attribute name="MarkUp">
+                        <xsl:value-of select="@MarkUp" />
+                    </xsl:attribute>
+                    <xsl:attribute name="CLPart">
+                        <!-- CLPart is false if TRAN_CODE == 2 or TRAN_CODE == 3                           -->
+                        <!-- CLPart is false if PartType is not 'PAN','PAP','PAL','PAG', 'PAM', or 'PAA', or 'PAC' or 'PATR'  -->
+                        <!-- CLPart is false if LaborCode is only labor                                    -->
+                        <!-- CLPart is false if OpCode is not "Remove/Replace" or "Remove/Replace Partial" -->
+                        <!-- If LaborOp is OP1, then allow the part to import CP 12/28/08 for Shop Client Release 4.1.4 -->
+                        <xsl:choose>
+                            <xsl:when test="@TransactionCode='3'">False</xsl:when>
+                            <xsl:when test="@TransactionCode='1' or @TransactionCode=' ' or @TransactionCode='' or @TransactionCode='2'">
+                                <xsl:choose>
+                                    <xsl:when test="@PartType='PAN' or @PartType='PAG' or @PartType='PAM' or @PartType='PAP' or @PartType='PAL' or @PartType='PAA' or @PartType='PAC' or @PartType='PATR'">
+                                        <xsl:choose>
+                                            <xsl:when test="@LaborType='LAD' or @LaborType='LAE' or @LaborType='LAU' or @LaborType='LAT'">False</xsl:when>
+                                            <xsl:otherwise>
+                                                <xsl:choose>
+                                                    <!--xsl:when test="@LaborOp='OP0'">False</xsl:when -->
+                                                    <xsl:when test="@LaborOp='OP1'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP2'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP3'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP4'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP5'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP6'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP7'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP8'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP9'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP10'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP13'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP14'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP15'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP16'">False</xsl:when>
+                                                    <xsl:otherwise>True</xsl:otherwise>
+                                                </xsl:choose>
+                                            </xsl:otherwise>
+                                        </xsl:choose>
+                                    </xsl:when>
+                                    <xsl:otherwise>False</xsl:otherwise>
+                                </xsl:choose>
+                            </xsl:when>
+                            <xsl:otherwise>False</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                </xsl:element>
+            </xsl:for-each>
+        </xsl:element>
+    </xsl:template>
+</xsl:stylesheet>

_reference/OEC/AudatexMapping.xml

@@ -0,0 +1,131 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<TranslationDescriptor>
+    <FileTranslations FormatName="ADP EMS" ElementName="Estimate" Description="Translation Descriptor for a ADP ShopLink Estimate, Version EMS 2.0">
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.env">
+            <DBFFileTranslation ID="ID1" ElementName="Envelope" Description="Envelope Table">
+                <DBFFieldSpec FieldName="RO_ID" Form="attribute" Name="RONum" FieldType="" Description="RO Number"/>
+                <DBFFieldSpec FieldName="UNQFILE_ID" Form="attribute" Name="UniqueFileID" FieldType="" Description="Unique File Identifier"/>
+                <DBFFieldSpec FieldName="ESTFILE_ID" Form="attribute" Name="EstimateFileID" FieldType="" Description="Estimate File Identifier"/>
+                <DBFFieldSpec FieldName="INCL_ADMIN" Form="attribute" Name="IncludesAdminInfo" FieldType="Boolean" Description="Includes Admin Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_VEH" Form="attribute" Name="IncludesVehicleInfo" FieldType="Boolean" Description="Includes Vehicle Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_EST" Form="attribute" Name="IncludesEstimateInfo" FieldType="Boolean" Description="Includes Estimate Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_PROFL" Form="attribute" Name="IncludesProfileInfo" FieldType="Boolean" Description="Includes Profile Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_TOTAL" Form="attribute" Name="IncludesTotalsInfo" FieldType="Boolean" Description="Includes Totals Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_VENDR" Form="attribute" Name="IncludesVendorInfo" FieldType="Boolean" Description="Includes Vendor Info Flag"/>
+                <DBFFieldSpec FieldName="EMS_VER" Form="attribute" Name="EMSVersion" FieldType="" Description="EMS Version Number"/>
+                <DBFFieldSpec FieldName="SUPP_NO" Form="attribute" Name="SupplementNum" FieldType="" Description="Supplement Number"/>
+                <DBFFieldSpec FieldName="TRANS_TYPE" Form="attribute" Name="TransactionType" FieldType="" Description="Transaction Type"/>
+                <DBFFieldSpec FieldName="EST_SYSTEM" Form="attribute" Name="EstimatingSystem" FieldType="" Description="Estimating System Software"/>
+                <DBFFieldSpec FieldName="SW_VERSION" Form="attribute" Name="SoftwareVersion" FieldType="" Description="Software Version Identifier"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.LIN">
+            <DBFFileTranslation ID="ID2" ElementSetName="PartsList" ElementName="Part" Description="Parts List Table">
+                <DBFFieldSpec FieldName="OEM_PARTNO" Form="attribute" Name="TDPartNum" FieldType="" Description="Part Number"/>
+                <DBFFieldSpec FieldName="ALT_PARTNO" Form="attribute" Name="AltPartNum" FieldType="" Description="Alternate Part Number"/>
+                <DBFFieldSpec FieldName="ACT_PRICE" Form="attribute" Name="ActPrice" FieldType="" Description="Actual Part Price"/>
+                <DBFFieldSpec FieldName="LINE_DESC" Form="attribute" Name="TDPartDesc" FieldType="" Description="Part Description"/>
+                <DBFFieldSpec FieldName="DB_PRICE" Form="attribute" Name="TDEstimate" FieldType="" Description="DB_Price"/>
+                <DBFFieldSpec FieldName="PART_QTY" Form="attribute" Name="TDPartQty" FieldType="" Description="Part Quantity"/>
+                <DBFFieldSpec FieldName="PART_TYPE" Form="attribute" Name="PartType" FieldType="" Description="Part Type"/>
+                <DBFFieldSpec FieldName="MOD_LBR_TY" Form="attribute" Name="LaborType" FieldType="" Description="Labor Type"/>
+                <DBFFieldSpec FieldName="MOD_LB_HRS" Form="attribute" Name="LaborHours" FieldType="" Description="Labor Hours"/>
+                <DBFFieldSpec FieldName="LBR_OP" Form="attribute" Name="LaborOp" FieldType="" Description="Labor Op"/>
+                <DBFFieldSpec FieldName="LINE_NO" Form="attribute" Name="LineNumber" FieldType="" Description="Line number"/>
+                <DBFFieldSpec FieldName="UNQ_SEQ" Form="attribute" Name="SequenceNumber" FieldType="" Description=""/>
+                <DBFFieldSpec FieldName="LINE_IND" Form="attribute" Name="SupplementLevel" FieldType="" Description="Supplement Level"/>
+                <DBFFieldSpec FieldName="TRAN_CODE" Form="attribute" Name="TransactionCode" FieldType="" Description="Transaction Code"/>
+                <DBFFieldSpec FieldName="PRICE_INC" Form="attribute" Name="PriceIncluded" FieldType="" Description="Price Included"/>
+                <DBFFieldSpec FieldName="PRT_DSMK_P" Form="attribute" Name="MarkUp" FieldType="" Description="Price Mark up for non OEM parts"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.VEH">
+            <DBFFileTranslation ID="ID3" ElementName="Vehicle" Description="Vehicle Table">
+                <DBFFieldSpec FieldName="V_VIN" Form="attribute" Name="TransVIN" FieldType="" Description=""/>
+                <DBFFieldSpec FieldName="V_MODEL_YR" Form="attribute" Name="TransYear" FieldType="" Description="V_MODEL_YR"/>
+                <DBFFieldSpec FieldName="V_MAKEDESC" Form="attribute" Name="ManufName" FieldType="" Description="V_MAKEDESC"/>
+                <DBFFieldSpec FieldName="V_MAKECODE" Form="attribute" Name="ManufCode" FieldType="" Description="V_MAKECODE"/>
+                <DBFFieldSpec FieldName="V_MODEL" Form="attribute" Name="TransModel" FieldType="" Description="V_MODEL"/>
+                <DBFFieldSpec FieldName="V_MILEAGE" Form="attribute" Name="TransMileage" FieldType="" Description="V_MILEAGE"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.AD1">
+            <DBFFileTranslation ID="ID4" ElementName="Admin" Description="Administrative information">
+                <DBFFieldSpec FieldName="OWNR_LN" Form="attribute" Name="OwnerL" FieldType="" Description="Owner Lastname"/>
+                <DBFFieldSpec FieldName="OWNR_FN" Form="attribute" Name="OwnerF" FieldType="" Description="Owner Firstname"/>
+                <DBFFieldSpec FieldName="OWNR_CO_NM" Form="attribute" Name="OwnerCompanyName" FieldType="" Description="Owner Company Name"/>
+                <DBFFieldSpec FieldName="OWNR_TITLE" Form="attribute" Name="OwnerTitle" FieldType="" Description="Owner Title"/>
+                <DBFFieldSpec FieldName="OWNR_ADDR1" Form="attribute" Name="OwnerAddr1" FieldType="" Description="Owner Address Line 1"/>
+                <DBFFieldSpec FieldName="OWNR_ADDR2" Form="attribute" Name="OwnerAddr2" FieldType="" Description="Owner Address Line 2"/>
+                <DBFFieldSpec FieldName="OWNR_CITY" Form="attribute" Name="OwnerCity" FieldType="" Description="Owner City"/>
+                <DBFFieldSpec FieldName="OWNR_ST" Form="attribute" Name="OwnerState" FieldType="" Description="Owner State"/>
+                <DBFFieldSpec FieldName="OWNR_ZIP" Form="attribute" Name="OwnerZip" FieldType="" Description="Owner Zip"/>
+                <DBFFieldSpec FieldName="OWNR_CTRY" Form="attribute" Name="OwnerCountry" FieldType="" Description="Owner Country"/>
+                <DBFFieldSpec FieldName="OWNR_PH1" Form="attribute" Name="OwnerPhone1" FieldType="" Description="Owner Primary Phone"/>
+                <DBFFieldSpec FieldName="OWNR_PH1X" Form="attribute" Name="OwnerPhone1Ext" FieldType="" Description="Owner Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="OWNR_PH2" Form="attribute" Name="OwnerPhone2" FieldType="" Description="Owner Secondary Phone"/>
+                <DBFFieldSpec FieldName="OWNR_PH2X" Form="attribute" Name="OwnerPhone2Ext" FieldType="" Description="Owner Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="OWNR_FAX" Form="attribute" Name="OwnerFax" FieldType="" Description="Owner Fax"/>
+                <DBFFieldSpec FieldName="OWNR_FAXX" Form="attribute" Name="OwnerFaxExt" FieldType="" Description="Owner Fax Extension"/>
+                <DBFFieldSpec FieldName="OWNR_EA" Form="attribute" Name="OwnerEmail" FieldType="" Description="Owner Email Address"/>
+                <DBFFieldSpec FieldName="INS_CO_NM" Form="attribute" Name="InsuranceCompanyName" FieldType="" Description="Insurance Company Name"/>
+                <DBFFieldSpec FieldName="INS_CO_ID" Form="attribute" Name="InsuranceCompanyID" FieldType="" Description="Insurance Company Identifier"/>
+                <DBFFieldSpec FieldName="INS_ADDR1" Form="attribute" Name="InsuranceAddr1" FieldType="" Description="Insurance Address Line 1"/>
+                <DBFFieldSpec FieldName="INS_ADDR2" Form="attribute" Name="InsuranceAddr2" FieldType="" Description="Insurance Address Line 2"/>
+                <DBFFieldSpec FieldName="INS_CITY" Form="attribute" Name="InsuranceCity" FieldType="" Description="Insurance City"/>
+                <DBFFieldSpec FieldName="INS_ST" Form="attribute" Name="InsuranceState" FieldType="" Description="Insurance State"/>
+                <DBFFieldSpec FieldName="INS_ZIP" Form="attribute" Name="InsuranceZip" FieldType="" Description="Insurance Zip"/>
+                <DBFFieldSpec FieldName="INS_CTRY" Form="attribute" Name="InsuranceCountry" FieldType="" Description="Insurance Country"/>
+                <DBFFieldSpec FieldName="INS_PH1" Form="attribute" Name="InsurancePhone1" FieldType="" Description="Insurance Primary Phone"/>
+                <DBFFieldSpec FieldName="INS_PH1X" Form="attribute" Name="InsurancePhone1Ext" FieldType="" Description="Insurance Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="INS_PH2" Form="attribute" Name="InsurancePhone2" FieldType="" Description="Insurance Secondary Phone"/>
+                <DBFFieldSpec FieldName="INS_PH2X" Form="attribute" Name="InsurancePhone2Ext" FieldType="" Description="Insurance Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="INS_FAX" Form="attribute" Name="InsuranceFax" FieldType="" Description="Insurance Fax"/>
+                <DBFFieldSpec FieldName="INS_FAXX" Form="attribute" Name="InsuranceFaxExt" FieldType="" Description="Insurance Fax Extension"/>
+                <DBFFieldSpec FieldName="INS_EA" Form="attribute" Name="InsuranceEmail" FieldType="" Description="Insurance Email Address"/>
+                <DBFFieldSpec FieldName="INSD_LN" Form="attribute" Name="InsuranceLName" FieldType="" Description="Insurance Last Name"/>
+                <DBFFieldSpec FieldName="CLM_NO" Form="attribute" Name="ClaimNumber" FieldType="" Description="Claim Number"/>
+
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.AD2">
+            <DBFFileTranslation ID="ID5" ElementName="Admin2" Description="Administrative information2">
+                <DBFFieldSpec FieldName="EST_CT_LN" Form="attribute" Name="EstimatorL" FieldType="" Description="Estimator Lastname"/>
+                <DBFFieldSpec FieldName="EST_CT_FN" Form="attribute" Name="EstimatorF" FieldType="" Description="Estimator Firstname"/>
+                <DBFFieldSpec FieldName="EST_CO_NM" Form="attribute" Name="EstimatorCompanyName" FieldType="" Description="Estimator Company Name"/>
+                <DBFFieldSpec FieldName="EST_CO_ID" Form="attribute" Name="EstimatorCompanyID" FieldType="" Description="Estimator Company Identifier"/>
+                <DBFFieldSpec FieldName="EST_ADDR1" Form="attribute" Name="EstimatorAddr1" FieldType="" Description="Estimator Address1"/>
+                <DBFFieldSpec FieldName="EST_ADDR2" Form="attribute" Name="EstimatorAddr2" FieldType="" Description="Estimator Address2"/>
+                <DBFFieldSpec FieldName="EST_CITY" Form="attribute" Name="EstimatorCity" FieldType="" Description="Estimator City"/>
+                <DBFFieldSpec FieldName="EST_ST" Form="attribute" Name="EstimatorState" FieldType="" Description="Estimator State"/>
+                <DBFFieldSpec FieldName="EST_ZIP" Form="attribute" Name="EstimatorZip" FieldType="" Description="Estimator Zip"/>
+                <DBFFieldSpec FieldName="EST_CTRY" Form="attribute" Name="EstimatorCountry" FieldType="" Description="Estimator Country"/>
+                <DBFFieldSpec FieldName="EST_PH1" Form="attribute" Name="EstimatorPhone1" FieldType="" Description="Estimator Primary Phone"/>
+                <DBFFieldSpec FieldName="EST_PH1X" Form="attribute" Name="EstimatorPhone1Ext" FieldType="" Description="Estimator Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="EST_PH2" Form="attribute" Name="EstimatorPhone2" FieldType="" Description="Estimator Secondary Phone"/>
+                <DBFFieldSpec FieldName="EST_PH2X" Form="attribute" Name="EstimatorPhone2Ext" FieldType="" Description="Estimator Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="EST_FAX" Form="attribute" Name="EstimatorFax" FieldType="" Description="Estimator Fax"/>
+                <DBFFieldSpec FieldName="EST_FAXX" Form="attribute" Name="EstimatorFaxExt" FieldType="" Description="Estimator Fax Extension"/>
+                <DBFFieldSpec FieldName="EST_EA" Form="attribute" Name="EstimatorEmail" FieldType="" Description="Estimator Email Address"/>
+                <DBFFieldSpec FieldName="EST_LIC_NO" Form="attribute" Name="EstimatorLicenseNumber" FieldType="" Description="Estimator License Number"/>
+                <DBFFieldSpec FieldName="EST_FILENO" Form="attribute" Name="EstimatorFileNumber" FieldType="" Description="Estimator File Number"/>
+                <DBFFieldSpec FieldName="RO_IN_DATE" Form="attribute" Name="VehicleInDate" FieldType="" Description="Date arrived in shop"/>
+                <DBFFieldSpec FieldName="RO_IN_TIME" Form="attribute" Name="VehicleInTime" FieldType="" Description="Time arrived in shop"/>
+                <DBFFieldSpec FieldName="TAR_DATE" Form="attribute" Name="TargetVehicleOutDate" FieldType="" Description="Target date to be completed"/>
+                <DBFFieldSpec FieldName="TAR_TIME" Form="attribute" Name="TargetVehicleOutTime" FieldType="" Description="Target time to be completed"/>
+                <DBFFieldSpec FieldName="RO_CMPDATE" Form="attribute" Name="VehicleOutDate" FieldType="" Description="Date completed"/>
+                <DBFFieldSpec FieldName="RO_CMPTIME" Form="attribute" Name="VehicleOutTime" FieldType="" Description="Time completed"/>
+                <DBFFieldSpec FieldName="RF_CITY" Form="attribute" Name="BodyShopCity" FieldType="" Description="Body Shop City"/>
+                <DBFFieldSpec FieldName="RF_CO_NM" Form="attribute" Name="BodyShopName" FieldType="" Description="Body Shop Name"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.TTL">
+          <DBFFileTranslation ID="ID6" ElementName="Total" Description="Total Table">
+            <DBFFieldSpec FieldName="G_TTL_AMT" Form="attribute" Name="GrandTotalAmount" FieldType="" Description=""/>
+          </DBFFileTranslation>
+        </FileTranslation>
+    </FileTranslations>
+    <StyleSheetTranslation>
+        <StyleSheetURL>Audatex.xsl</StyleSheetURL>
+    </StyleSheetTranslation>
+</TranslationDescriptor>

_reference/OEC/CCC.xsl

@@ -0,0 +1,607 @@
+
+<?xml version="1.0" ?>
+<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" >
+    <xsl:template match="/">
+        <xsl:for-each select="//TranslatedData">
+            <xsl:element name="TranslatedData">
+                <xsl:attribute name="TranslationOutputFile">
+                    <xsl:value-of select="@TranslationOutputFile"/>
+                </xsl:attribute>
+                <xsl:choose>
+                    <xsl:when test="Details/@PrgID">
+                        <xsl:copy-of select="Details" />
+                    </xsl:when>
+                    <xsl:otherwise>
+                        <xsl:element name="Details">
+                            <xsl:attribute name="PrgID">OECTrans.ImportTrans</xsl:attribute>
+                            <xsl:for-each select="Details/@*">
+                                <xsl:copy-of select="." />
+                            </xsl:for-each>
+                            <xsl:for-each select="Details/*">
+                                <xsl:copy-of select="." />
+                            </xsl:for-each>
+                        </xsl:element>
+                    </xsl:otherwise>
+                </xsl:choose>
+                <xsl:element name="Header">
+                    <xsl:attribute name="RONum">
+                        <xsl:value-of select="//Envelope/@RONum" />
+                    </xsl:attribute>
+                    <xsl:attribute name="OwnerFName">
+                        <xsl:value-of select="//Admin/@OwnerF"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="OwnerLName">
+                        <xsl:value-of select="//Admin/@OwnerL"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="VIN">
+                        <xsl:value-of select="//Vehicle/@TransVIN" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Mileage">
+                        <xsl:value-of select="//Vehicle/@TransMileage" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Year">
+                        <xsl:value-of select="//Vehicle/@TransYear" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Make">
+                        <xsl:if test="//Vehicle/@ManufName[. != '']" >
+                            <xsl:value-of select="//Vehicle/@ManufName" />
+                        </xsl:if>
+                        <xsl:if test="//Vehicle/@ManufName[. = '']" >
+                            <xsl:value-of select="//Vehicle/@ManufCode" />
+                        </xsl:if>
+                    </xsl:attribute>
+                    <xsl:attribute name="Model">
+                        <xsl:value-of select="//Vehicle/@TransModel" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Description">
+                        <xsl:value-of select="//Vehicle/@TransYear" />
+                        <xsl:text> </xsl:text>
+                        <xsl:value-of select="//Vehicle/@ManufName" />
+                        <xsl:text> </xsl:text>
+                        <xsl:value-of select="//Vehicle/@TransModel" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LastSupplLevel">
+                        <xsl:choose>
+                            <xsl:when test="//Envelope/@TransactionType = 'E'">0</xsl:when>
+                            <xsl:when test="//Envelope/@TransactionType = 'S'">
+                                <xsl:value-of select="substring(//Envelope/@SupplementNum, 2)" />
+                            </xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                </xsl:element>
+                <xsl:apply-templates select="PartsList" />
+                <xsl:element name="Envelope">
+                    <xsl:element name="Software">
+                        <xsl:attribute name="Manifest">CCC.xml</xsl:attribute>
+                        <xsl:attribute name="Descriptor">CCC.xsl</xsl:attribute>
+                        <xsl:attribute name="System">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Version">
+                            <xsl:value-of select="//Envelope/@SoftwareVersion"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="SystemName">
+                            <xsl:value-of select="//Envelope/@SystemName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateFileID">
+                            <xsl:value-of select="//Envelope/@EstimateFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="UniqueFileID">
+                            <xsl:value-of select="//Envelope/@UniqueFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateID">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>-<xsl:value-of select="//Envelope/@SoftwareVersion"/>-<xsl:value-of select="//Envelope/@UniqueFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateIDv2">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>-<xsl:value-of select="//Envelope/@UniqueFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateFormatVersion">
+                            <xsl:value-of select="//Envelope/@EMSVersion"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                </xsl:element>
+                <xsl:element name="Totals">
+                  <xsl:attribute name="GrandTotalAmount">
+                    <xsl:value-of select="//Total/@GrandTotalAmount"/>
+                  </xsl:attribute>
+                </xsl:element>
+                <xsl:element name="Administrative">
+                    <xsl:element name="Owner">
+                        <xsl:attribute name="FName">
+                            <xsl:value-of select="//Admin/@OwnerF"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="LName">
+                            <xsl:value-of select="//Admin/@OwnerL"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Company">
+                            <!--<xsl:value-of select="//Admin/@OwnerCompanyName"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <!--<xsl:value-of select="//Admin/@OwnerAddr1"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <!--<xsl:value-of select="//Admin/@OwnerAddr2"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <!--<xsl:value-of select="//Admin/@OwnerCity"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin/@OwnerState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <!--<xsl:choose>
+                                <xsl:when test="contains(//Admin/@OwnerZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin/@OwnerZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin/@OwnerZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin/@OwnerZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@OwnerZip)=9">
+                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin/@OwnerZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@OwnerZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <!--<xsl:value-of select="//Admin/@OwnerCountry"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerPhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerPhone1"/>&#32;x<xsl:value-of select="//Admin/@OwnerPhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerPhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerPhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerPhone2"/>&#32;x<xsl:value-of select="//Admin/@OwnerPhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerPhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerFax"/>&#32;x<xsl:value-of select="//Admin/@OwnerFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <!--<xsl:value-of select="//Admin/@OwnerEmail"/>-->
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="InsuranceCompany">
+                        <xsl:attribute name="Id">
+                            <xsl:value-of select="//Admin/@InsuranceCompanyID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Name">
+                            <xsl:value-of select="//Admin/@InsuranceCompanyName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <xsl:value-of select="//Admin/@InsuranceAddr1"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <xsl:value-of select="//Admin/@InsuranceAddr2"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <xsl:value-of select="//Admin/@InsuranceCity"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin/@InsuranceState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <xsl:choose>
+                                <xsl:when test="contains(//Admin/@InsuranceZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin/@InsuranceZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin/@InsuranceZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin/@InsuranceZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@InsuranceZip)=9">
+                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin/@InsuranceZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@InsuranceZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <xsl:value-of select="//Admin/@InsuranceCountry"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsurancePhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@InsurancePhone1"/>&#32;x<xsl:value-of select="//Admin/@InsurancePhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsurancePhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsurancePhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@InsurancePhone2"/>&#32;x<xsl:value-of select="//Admin/@InsurancePhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsurancePhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsuranceFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin/@InsuranceFax"/>&#32;x<xsl:value-of select="//Admin/@InsuranceFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsuranceFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <xsl:value-of select="//Admin/@InsuranceEmail"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Insured">
+                        <xsl:attribute name="LastName">
+                            <xsl:value-of select="//Admin/@InsuranceLName" />
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Claim">
+                        <xsl:attribute name="Number">
+                            <xsl:value-of select="//Admin/@ClaimNumber"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Estimator">
+                        <xsl:attribute name="FName">
+                            <xsl:value-of select="//Admin2/@EstimatorF"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="LName">
+                            <xsl:value-of select="//Admin2/@EstimatorL"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Company">
+                            <xsl:value-of select="//Admin2/@EstimatorCompanyName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <xsl:value-of select="//Admin2/@EstimatorAddr1"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <xsl:value-of select="//Admin2/@EstimatorAddr2"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <xsl:value-of select="//Admin2/@EstimatorCity"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin2/@EstimatorState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <xsl:choose>
+                                <xsl:when test="contains(//Admin2/@EstimatorZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin2/@EstimatorZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin2/@EstimatorZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin2/@EstimatorZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin2/@EstimatorZip)=9">
+                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin2/@EstimatorZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin2/@EstimatorZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <xsl:value-of select="//Admin2/@EstimatorCountry"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorPhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone1"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorPhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorPhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone2"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorPhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorFax"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <xsl:value-of select="//Admin2/@EstimatorEmail"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="RepairInformation">
+                        <xsl:attribute name="VehicleDateIn">
+                            <xsl:if test="string-length(//Admin2/@VehicleInDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@VehicleInDate, ' ')"/>
+                                <xsl:if test="string-length(//Admin2/@VehicleInTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@VehicleInTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@VehicleInTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimatedVehicleDateOut">
+                            <xsl:if test="string-length(//Admin2/@TargetVehicleOutDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@TargetVehicleOutDate,' ')"/>
+                                <xsl:if test="string-length(//Admin2/@TargetVehicleOutTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@TargetVehicleOutTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@TargetVehicleOutTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                        <xsl:attribute name="VehicleDateOut">
+                            <xsl:if test="string-length(//Admin2/@VehicleOutDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@VehicleOutDate, ' ')"/>
+                                <xsl:if test="string-length(//Admin2/@VehicleOutTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@VehicleOutTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@VehicleOutTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                    </xsl:element>
+                </xsl:element>
+            </xsl:element>
+        </xsl:for-each>
+    </xsl:template>
+    <xsl:template match="PartsList">
+        <xsl:element name="PartsList" >
+            <xsl:for-each select="Part">
+                <xsl:element name="Part" >
+                    <!-- Part number translation rules -->
+                    <xsl:variable name="OEMPartNumber">
+                        <xsl:if test="substring(@TDPartNum, string-length(@TDPartNum) - 7) != ' GM PART'">
+                            <xsl:value-of select="@TDPartNum" />
+                        </xsl:if>
+                        <xsl:if test="substring(@TDPartNum, string-length(@TDPartNum) - 7) = ' GM PART'">
+                            <xsl:value-of select="substring-before(@TDPartNum,' GM PART')" />
+                        </xsl:if>
+                    </xsl:variable>
+                    <xsl:variable name="AltPartNumber">
+                        <xsl:value-of select="@AltPartNum"/>
+                    </xsl:variable>
+                    <xsl:variable name="PrimaryPartType">
+                        <!-- RoseP modified to convert PAP to PAN -->
+                        <!--<xsl:value-of select="@PartType"/>-->
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAP'">PAN</xsl:when>
+                            <xsl:otherwise>
+                                <xsl:value-of select="@PartType"/>
+                            </xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:variable name="PrimaryPartNumber">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAN'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAA'">
+                                <xsl:value-of select="$AltPartNumber"/>
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAL'">
+                                <xsl:choose>
+                                    <xsl:when test="$AltPartNumber!=''">
+                                        <xsl:value-of select="$AltPartNumber"/>
+                                    </xsl:when>
+                                    <xsl:when test="$OEMPartNumber!=''">
+                                        <xsl:value-of select="$OEMPartNumber"/>
+                                    </xsl:when>
+                                    <xsl:otherwise>Salvage or Assembly</xsl:otherwise>
+                                </xsl:choose>
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAG'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                            <!-- RoseP added Dec 08, 06 -->
+                            <xsl:when test="@PartType='PAP'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAM'">
+                                <xsl:choose>
+                                    <xsl:when test="$AltPartNumber!=''">
+                                        <xsl:value-of select="$AltPartNumber"/>
+                                    </xsl:when>
+                                    <xsl:otherwise>
+                                        <xsl:value-of select="$OEMPartNumber"/>
+                                    </xsl:otherwise>
+                                </xsl:choose>
+                            </xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:variable name="SecondaryPartNumber">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAA'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAM'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:variable name="SecondaryPartType">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAA'">PAN</xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:attribute name="TDPartNum">
+                        <xsl:value-of select="$PrimaryPartNumber"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="AltPartNum">
+                        <xsl:value-of select="$SecondaryPartNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="ExternalPartType">
+                        <xsl:value-of select="$PrimaryPartType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="ExternalAltPartType">
+                        <xsl:value-of select="$SecondaryPartType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartType">
+                        <xsl:choose>
+                            <xsl:when test="$PrimaryPartType='PAN'">1</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAA'">2</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAL'">3</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAM'">4</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAR'">4</xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="AltPartType">
+                        <xsl:choose>
+                            <xsl:when test="$SecondaryPartType='PAN'">1</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAA'">2</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAL'">3</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAM'">4</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAR'">4</xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartDesc">
+                        <xsl:value-of select="@TDPartDesc" />
+                    </xsl:attribute>
+                    <xsl:attribute name="TDLineRef">
+                        <xsl:value-of select="@TDLineRef" />
+                    </xsl:attribute>
+                    <xsl:attribute name="TDEstimate">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAN'">
+                                <xsl:value-of select="@TDEstimate" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAM'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAA'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAL'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:otherwise>
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartQty">
+                        <xsl:value-of select="@TDPartQty" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LineNumber">
+                        <xsl:value-of select="@LineNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="SequenceNumber">
+                        <xsl:value-of select="@SequenceNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="SupplLevel">
+                        <xsl:choose>
+                            <xsl:when test="@SupplementLevel = 'E01'">0</xsl:when>
+                            <xsl:when test="substring(@SupplementLevel, 1, 1) = 'S'">
+                                <xsl:value-of select="substring(@SupplementLevel, 2)" />
+                            </xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="LaborType">
+                        <xsl:value-of select="@LaborType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LaborHours">
+                      <xsl:value-of select="@LaborHours" />
+                    </xsl:attribute>
+                    <xsl:attribute name="OperationCode">
+                        <xsl:value-of select="@LaborOp" />
+                    </xsl:attribute>
+                    <xsl:attribute name="CLPart">
+                        <!-- CLPart is false if TRAN_CODE == 2 or TRAN_CODE == 3                           -->
+                        <!-- CLPart is false if PartType is not 'PAN','PAP','PAL','PAG', 'PAM', 'PAA', 'PAO', 'PAR', or ''   -->
+                        <!-- CLPart is false if LaborCode is only labor                                    -->
+                        <!-- CLPart is false if OpCode is not "Remove/Replace" or "Remove/Replace Partial" or "Repair, Partial" -->
+                        <xsl:choose>
+                            <xsl:when test="@TransactionCode='3'">False</xsl:when>
+                            <xsl:when test="@TransactionCode='1' or @TransactionCode ='2'">
+                                <xsl:choose>
+                                    <xsl:when test="@PartType='PAN' or @PartType='PAG' or @PartType='PAM' or @PartType='PAP' or @PartType='PAL' or @PartType='PAA' or @PartType='PAO' or @PartType='PAR' or @PartType=''" >
+                                        <!-- we now handle blank part types-->
+                                        <xsl:choose>
+                                            <xsl:when test="@LaborType='LAD' or @LaborType='LAE' or @LaborType='LAU' or @LaborType='LAT'">False</xsl:when>
+                                            <xsl:otherwise>
+                                                <xsl:choose>
+                                                    <xsl:when test="@LaborOp=''">False</xsl:when>
+                                                    <!--Needed for Blank Part Type-->
+                                                    <xsl:when test="@LaborOp='OP0'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP1'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP2'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP3'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP4'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP5'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP6'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP7'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP8'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP9'">False</xsl:when>
+                                                    <!-- RoseP removed OP10 Dec 08, 06 -->
+                                                    <!-- <xsl:when test="@LaborOp='OP10'">False</xsl:when> -->
+                                                    <xsl:when test="@LaborOp='OP13'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP14'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP15'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP16'">False</xsl:when>
+                                                    <xsl:otherwise>True</xsl:otherwise>
+                                                </xsl:choose>
+                                            </xsl:otherwise>
+                                        </xsl:choose>
+                                    </xsl:when>
+                                    <xsl:otherwise>False</xsl:otherwise>
+                                </xsl:choose>
+                            </xsl:when>
+                            <xsl:otherwise>False</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                </xsl:element>
+            </xsl:for-each>
+        </xsl:element>
+    </xsl:template>
+</xsl:stylesheet>

_reference/OEC/CCCMapping.xml

@@ -0,0 +1,129 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<TranslationDescriptor>
+    <FileTranslations FormatName="CCC" ElementName="Estimate" Description="Translation Descriptor for a CCC Estimate, Version 2.0">
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.env">
+            <DBFFileTranslation ID="ID1" ElementName="Envelope" Description="Envelope Table">
+                <DBFFieldSpec FieldName="RO_ID" Form="attribute" Name="RONum" FieldType="" Description="RO Number"/>
+                <DBFFieldSpec FieldName="UNQFILE_ID" Form="attribute" Name="UniqueFileID" FieldType="" Description="Unique File Identifier"/>
+                <DBFFieldSpec FieldName="ESTFILE_ID" Form="attribute" Name="EstimateFileID" FieldType="" Description="Estimate File Identifier"/>
+                <DBFFieldSpec FieldName="INCL_ADMIN" Form="attribute" Name="IncludesAdminInfo" FieldType="Boolean" Description="Includes Admin Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_VEH" Form="attribute" Name="IncludesVehicleInfo" FieldType="Boolean" Description="Includes Vehicle Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_EST" Form="attribute" Name="IncludesEstimateInfo" FieldType="Boolean" Description="Includes Estimate Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_PROFL" Form="attribute" Name="IncludesProfileInfo" FieldType="Boolean" Description="Includes Profile Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_TOTAL" Form="attribute" Name="IncludesTotalsInfo" FieldType="Boolean" Description="Includes Totals Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_VENDR" Form="attribute" Name="IncludesVendorInfo" FieldType="Boolean" Description="Includes Vendor Info Flag"/>
+                <DBFFieldSpec FieldName="EMS_VER" Form="attribute" Name="EMSVersion" FieldType="" Description="EMS Version Number"/>
+                <DBFFieldSpec FieldName="SUPP_NO" Form="attribute" Name="SupplementNum" FieldType="" Description="Supplement Number"/>
+                <DBFFieldSpec FieldName="TRANS_TYPE" Form="attribute" Name="TransactionType" FieldType="" Description="Transaction Type"/>
+                <DBFFieldSpec FieldName="EST_SYSTEM" Form="attribute" Name="EstimatingSystem" FieldType="" Description="Estimating System Software"/>
+                <DBFFieldSpec FieldName="SW_VERSION" Form="attribute" Name="SoftwareVersion" FieldType="" Description="Software Version Identifier"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.LIN">
+            <DBFFileTranslation ID="ID2" ElementSetName="PartsList" ElementName="Part" Description="Parts List Table">
+                <DBFFieldSpec FieldName="OEM_PARTNO" Form="attribute" Name="TDPartNum" FieldType="" Description="Part Number"/>
+                <DBFFieldSpec FieldName="ALT_PARTNO" Form="attribute" Name="AltPartNum" FieldType="" Description="Alternate Part Number"/>
+                <DBFFieldSpec FieldName="ACT_PRICE" Form="attribute" Name="ActPrice" FieldType="" Description="Actual Part Price"/>
+                <DBFFieldSpec FieldName="LINE_DESC" Form="attribute" Name="TDPartDesc" FieldType="" Description="Part Description"/>
+                <DBFFieldSpec FieldName="DB_PRICE" Form="attribute" Name="TDEstimate" FieldType="" Description="DB_Price"/>
+                <DBFFieldSpec FieldName="PART_QTY" Form="attribute" Name="TDPartQty" FieldType="" Description="PART_QTY"/>
+                <DBFFieldSpec FieldName="LINE_NO" Form="attribute" Name="LineNumber" FieldType="" Description=""/>
+                <DBFFieldSpec FieldName="UNQ_SEQ" Form="attribute" Name="SequenceNumber" FieldType="" Description=""/>
+                <DBFFieldSpec FieldName="PART_TYPE" Form="attribute" Name="PartType" FieldType="" Description="Part Type"/>
+                <DBFFieldSpec FieldName="MOD_LBR_TY" Form="attribute" Name="LaborType" FieldType="" Description="Labor Type"/>
+                <DBFFieldSpec FieldName="MOD_LB_HRS" Form="attribute" Name="LaborHours" FieldType="" Description="Labor Hours"/>
+                <DBFFieldSpec FieldName="LBR_OP" Form="attribute" Name="LaborOp" FieldType="" Description="Labor Op"/>
+                <DBFFieldSpec FieldName="LINE_IND" Form="attribute" Name="SupplementLevel" FieldType="" Description="Supplement Level"/>
+                <DBFFieldSpec FieldName="TRAN_CODE" Form="attribute" Name="TransactionCode" FieldType="" Description="Transaction Code"/>
+                <DBFFieldSpec FieldName="LINE_REF" Form="attribute" Name="TDLineRef" FieldType="" Description="Line Reference Number"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.VEH">
+            <DBFFileTranslation ID="ID3" ElementName="Vehicle" Description="Vehicle Table">
+                <DBFFieldSpec FieldName="V_VIN" Form="attribute" Name="TransVIN" FieldType="" Description="V_VIN"/>
+                <DBFFieldSpec FieldName="V_MODEL_YR" Form="attribute" Name="TransYear" FieldType="" Description="V_MODEL_YR"/>
+                <DBFFieldSpec FieldName="V_MAKEDESC" Form="attribute" Name="ManufName" FieldType="" Description="V_MAKEDESC"/>
+                <DBFFieldSpec FieldName="V_MAKECODE" Form="attribute" Name="ManufCode" FieldType="" Description="V_MAKECODE"/>
+                <DBFFieldSpec FieldName="V_MODEL" Form="attribute" Name="TransModel" FieldType="" Description="V_MODEL"/>
+                <DBFFieldSpec FieldName="V_MILEAGE" Form="attribute" Name="TransMileage" FieldType="" Description="V_MILEAGE"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.AD1">
+            <DBFFileTranslation ID="ID4" ElementName="Admin" Description="Administrative information">
+                <DBFFieldSpec FieldName="OWNR_LN" Form="attribute" Name="OwnerL" FieldType="" Description="Owner Lastname"/>
+                <DBFFieldSpec FieldName="OWNR_FN" Form="attribute" Name="OwnerF" FieldType="" Description="Owner Firstname"/>
+                <DBFFieldSpec FieldName="OWNR_CO_NM" Form="attribute" Name="OwnerCompanyName" FieldType="" Description="Owner Company Name"/>
+                <DBFFieldSpec FieldName="OWNR_TITLE" Form="attribute" Name="OwnerTitle" FieldType="" Description="Owner Title"/>
+                <DBFFieldSpec FieldName="OWNR_ADDR1" Form="attribute" Name="OwnerAddr1" FieldType="" Description="Owner Address Line 1"/>
+                <DBFFieldSpec FieldName="OWNR_ADDR2" Form="attribute" Name="OwnerAddr2" FieldType="" Description="Owner Address Line 2"/>
+                <DBFFieldSpec FieldName="OWNR_CITY" Form="attribute" Name="OwnerCity" FieldType="" Description="Owner City"/>
+                <DBFFieldSpec FieldName="OWNR_ST" Form="attribute" Name="OwnerState" FieldType="" Description="Owner State"/>
+                <DBFFieldSpec FieldName="OWNR_ZIP" Form="attribute" Name="OwnerZip" FieldType="" Description="Owner Zip"/>
+                <DBFFieldSpec FieldName="OWNR_CTRY" Form="attribute" Name="OwnerCountry" FieldType="" Description="Owner Country"/>
+                <DBFFieldSpec FieldName="OWNR_PH1" Form="attribute" Name="OwnerPhone1" FieldType="" Description="Owner Primary Phone"/>
+                <DBFFieldSpec FieldName="OWNR_PH1X" Form="attribute" Name="OwnerPhone1Ext" FieldType="" Description="Owner Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="OWNR_PH2" Form="attribute" Name="OwnerPhone2" FieldType="" Description="Owner Secondary Phone"/>
+                <DBFFieldSpec FieldName="OWNR_PH2X" Form="attribute" Name="OwnerPhone2Ext" FieldType="" Description="Owner Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="OWNR_FAX" Form="attribute" Name="OwnerFax" FieldType="" Description="Owner Fax"/>
+                <DBFFieldSpec FieldName="OWNR_FAXX" Form="attribute" Name="OwnerFaxExt" FieldType="" Description="Owner Fax Extension"/>
+                <DBFFieldSpec FieldName="OWNR_EA" Form="attribute" Name="OwnerEmail" FieldType="" Description="Owner Email Address"/>
+                <DBFFieldSpec FieldName="INS_CO_NM" Form="attribute" Name="InsuranceCompanyName" FieldType="" Description="Insurance Company Name"/>
+                <DBFFieldSpec FieldName="INS_CO_ID" Form="attribute" Name="InsuranceCompanyID" FieldType="" Description="Insurance Company Identifier"/>
+                <DBFFieldSpec FieldName="INS_ADDR1" Form="attribute" Name="InsuranceAddr1" FieldType="" Description="Insurance Address Line 1"/>
+                <DBFFieldSpec FieldName="INS_ADDR2" Form="attribute" Name="InsuranceAddr2" FieldType="" Description="Insurance Address Line 2"/>
+                <DBFFieldSpec FieldName="INS_CITY" Form="attribute" Name="InsuranceCity" FieldType="" Description="Insurance City"/>
+                <DBFFieldSpec FieldName="INS_ST" Form="attribute" Name="InsuranceState" FieldType="" Description="Insurance State"/>
+                <DBFFieldSpec FieldName="INS_ZIP" Form="attribute" Name="InsuranceZip" FieldType="" Description="Insurance Zip"/>
+                <DBFFieldSpec FieldName="INS_CTRY" Form="attribute" Name="InsuranceCountry" FieldType="" Description="Insurance Country"/>
+                <DBFFieldSpec FieldName="INS_PH1" Form="attribute" Name="InsurancePhone1" FieldType="" Description="Insurance Primary Phone"/>
+                <DBFFieldSpec FieldName="INS_PH1X" Form="attribute" Name="InsurancePhone1Ext" FieldType="" Description="Insurance Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="INS_PH2" Form="attribute" Name="InsurancePhone2" FieldType="" Description="Insurance Secondary Phone"/>
+                <DBFFieldSpec FieldName="INS_PH2X" Form="attribute" Name="InsurancePhone2Ext" FieldType="" Description="Insurance Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="INS_FAX" Form="attribute" Name="InsuranceFax" FieldType="" Description="Insurance Fax"/>
+                <DBFFieldSpec FieldName="INS_FAXX" Form="attribute" Name="InsuranceFaxExt" FieldType="" Description="Insurance Fax Extension"/>
+                <DBFFieldSpec FieldName="INS_EA" Form="attribute" Name="InsuranceEmail" FieldType="" Description="Insurance Email Address"/>
+                <DBFFieldSpec FieldName="INSD_LN" Form="attribute" Name="InsuranceLName" FieldType="" Description="Insurance Last Name"/>
+                <DBFFieldSpec FieldName="CLM_NO" Form="attribute" Name="ClaimNumber" FieldType="" Description="Claim Number"/>
+
+
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.AD2">
+            <DBFFileTranslation ID="ID5" ElementName="Admin2" Description="Administrative information2">
+                <DBFFieldSpec FieldName="EST_CT_LN" Form="attribute" Name="EstimatorL" FieldType="" Description="Estimator Lastname"/>
+                <DBFFieldSpec FieldName="EST_CT_FN" Form="attribute" Name="EstimatorF" FieldType="" Description="Estimator Firstname"/>
+                <DBFFieldSpec FieldName="EST_CO_NM" Form="attribute" Name="EstimatorCompanyName" FieldType="" Description="Estimator Company Name"/>
+                <DBFFieldSpec FieldName="EST_CO_ID" Form="attribute" Name="EstimatorCompanyID" FieldType="" Description="Estimator Company Identifier"/>
+                <DBFFieldSpec FieldName="EST_ADDR1" Form="attribute" Name="EstimatorAddr1" FieldType="" Description="Estimator Address1"/>
+                <DBFFieldSpec FieldName="EST_ADDR2" Form="attribute" Name="EstimatorAddr2" FieldType="" Description="Estimator Address2"/>
+                <DBFFieldSpec FieldName="EST_CITY" Form="attribute" Name="EstimatorCity" FieldType="" Description="Estimator City"/>
+                <DBFFieldSpec FieldName="EST_ST" Form="attribute" Name="EstimatorState" FieldType="" Description="Estimator State"/>
+                <DBFFieldSpec FieldName="EST_ZIP" Form="attribute" Name="EstimatorZip" FieldType="" Description="Estimator Zip"/>
+                <DBFFieldSpec FieldName="EST_CTRY" Form="attribute" Name="EstimatorCountry" FieldType="" Description="Estimator Country"/>
+                <DBFFieldSpec FieldName="EST_PH1" Form="attribute" Name="EstimatorPhone1" FieldType="" Description="Estimator Primary Phone"/>
+                <DBFFieldSpec FieldName="EST_PH1X" Form="attribute" Name="EstimatorPhone1Ext" FieldType="" Description="Estimator Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="EST_PH2" Form="attribute" Name="EstimatorPhone2" FieldType="" Description="Estimator Secondary Phone"/>
+                <DBFFieldSpec FieldName="EST_PH2X" Form="attribute" Name="EstimatorPhone2Ext" FieldType="" Description="Estimator Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="EST_FAX" Form="attribute" Name="EstimatorFax" FieldType="" Description="Estimator Fax"/>
+                <DBFFieldSpec FieldName="EST_FAXX" Form="attribute" Name="EstimatorFaxExt" FieldType="" Description="Estimator Fax Extension"/>
+                <DBFFieldSpec FieldName="EST_EA" Form="attribute" Name="EstimatorEmail" FieldType="" Description="Estimator Email Address"/>
+                <DBFFieldSpec FieldName="EST_LIC_NO" Form="attribute" Name="EstimatorLicenseNumber" FieldType="" Description="Estimator License Number"/>
+                <DBFFieldSpec FieldName="EST_FILENO" Form="attribute" Name="EstimatorFileNumber" FieldType="" Description="Estimator File Number"/>
+                <DBFFieldSpec FieldName="RO_IN_DATE" Form="attribute" Name="VehicleInDate" FieldType="" Description="Date arrived in shop"/>
+                <DBFFieldSpec FieldName="RO_IN_TIME" Form="attribute" Name="VehicleInTime" FieldType="" Description="Time arrived in shop"/>
+                <DBFFieldSpec FieldName="TAR_DATE" Form="attribute" Name="TargetVehicleOutDate" FieldType="" Description="Target date to be completed"/>
+                <DBFFieldSpec FieldName="TAR_TIME" Form="attribute" Name="TargetVehicleOutTime" FieldType="" Description="Target time to be completed"/>
+                <DBFFieldSpec FieldName="RO_CMPDATE" Form="attribute" Name="VehicleOutDate" FieldType="" Description="Date completed"/>
+                <DBFFieldSpec FieldName="RO_CMPTIME" Form="attribute" Name="VehicleOutTime" FieldType="" Description="Time completed"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.TTL">
+          <DBFFileTranslation ID="ID6" ElementName="Total" Description="Total Table">
+            <DBFFieldSpec FieldName="G_TTL_AMT" Form="attribute" Name="GrandTotalAmount" FieldType="" Description=""/>
+          </DBFFileTranslation>
+        </FileTranslation>
+    </FileTranslations>
+    <StyleSheetTranslation>
+        <StyleSheetURL>ccc.xsl</StyleSheetURL>
+    </StyleSheetTranslation>
+</TranslationDescriptor>

_reference/OEC/Mitchell.xsl

@@ -0,0 +1,580 @@
+<?xml version="1.0" ?>
+<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" >
+
+    <xsl:template match="/">
+        <xsl:for-each select="//TranslatedData">
+            <xsl:element name="TranslatedData">
+                <xsl:attribute name="TranslationOutputFile">
+                    <xsl:value-of select="@TranslationOutputFile"/>
+                </xsl:attribute>
+                <xsl:choose>
+                    <xsl:when test="Details/@PrgID">
+                        <xsl:copy-of select="Details" />
+                    </xsl:when>
+                    <xsl:otherwise>
+                        <xsl:element name="Details">
+                            <xsl:attribute name="PrgID">OECTrans.ImportTrans</xsl:attribute>
+                            <xsl:for-each select="Details/@*">
+                                <xsl:copy-of select="." />
+                            </xsl:for-each>
+                            <xsl:for-each select="Details/*">
+                                <xsl:copy-of select="." />
+                            </xsl:for-each>
+                        </xsl:element>
+                    </xsl:otherwise>
+                </xsl:choose>
+                <xsl:element name="Header">
+                    <xsl:attribute name="RONum">
+                        <xsl:value-of select="//Envelope/@RONum" />
+                    </xsl:attribute>
+                    <xsl:attribute name="OwnerFName">
+                        <xsl:value-of select="//Admin/@OwnerF"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="OwnerLName">
+                        <xsl:value-of select="//Admin/@OwnerL"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="VIN">
+                        <xsl:value-of select="//Vehicle/@TransVIN" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Mileage">
+                        <xsl:value-of select="//Vehicle/@TransMileage" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Year">
+                        <xsl:value-of select="//Vehicle/@TransYear" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Make">
+                        <xsl:if test="//Vehicle/@ManufName[. != '']" >
+                            <xsl:value-of select="//Vehicle/@ManufName" />
+                        </xsl:if>
+                        <xsl:if test="//Vehicle/@ManufName[. = '']" >
+                            <xsl:value-of select="//Vehicle/@ManufCode" />
+                        </xsl:if>
+                    </xsl:attribute>
+                    <xsl:attribute name="Model">
+                        <xsl:value-of select="//Vehicle/@TransModel" />
+                    </xsl:attribute>
+                    <xsl:attribute name="Description">
+                        <xsl:value-of select="//Vehicle/@TransYear" />
+                        <xsl:text> </xsl:text>
+                        <xsl:value-of select="//Vehicle/@ManufName" />
+                        <xsl:text> </xsl:text>
+                        <xsl:value-of select="//Vehicle/@TransModel" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LastSupplLevel">
+                        <xsl:choose>
+                            <xsl:when test="string-length(//Envelope/@SupplementNum) > 0">
+                                <xsl:value-of select="//Envelope/@SupplementNum" />
+                            </xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                </xsl:element>
+                <xsl:apply-templates select="PartsList" />
+                <xsl:element name="Envelope">
+                    <xsl:element name="Software">
+                        <xsl:attribute name="Manifest">Mitchell.xml</xsl:attribute>
+                        <xsl:attribute name="Descriptor">Mitchell.xsl</xsl:attribute>
+                        <xsl:attribute name="System">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Version">
+                            <xsl:value-of select="//Envelope/@SoftwareVersion"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="SystemName">
+                            <xsl:value-of select="//Envelope/@SystemName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateFileID">
+                            <xsl:value-of select="//Envelope/@EstimateFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="UniqueFileID">
+                            <xsl:value-of select="//Envelope/@UniqueFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateID">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>-<xsl:value-of select="//Envelope/@SoftwareVersion"/>-<xsl:value-of select="//Envelope/@EstimateFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateIDv2">
+                            <xsl:value-of select="//Envelope/@EstimatingSystem"/>-<xsl:value-of select="//Envelope/@EstimateFileID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimateFormatVersion">
+                            <xsl:value-of select="//Envelope/@EMSVersion"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                </xsl:element>
+                <xsl:element name="Totals">
+                    <xsl:attribute name="GrandTotalAmount">
+                      <xsl:value-of select="//Total/@GrandTotalAmount"/>
+                    </xsl:attribute>
+                </xsl:element>
+                <xsl:element name="Administrative">
+                    <xsl:element name="Owner">
+                        <xsl:attribute name="FName">
+                            <xsl:value-of select="//Admin/@OwnerF"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="LName">
+                            <xsl:value-of select="//Admin/@OwnerL"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Company">
+                            <!--<xsl:value-of select="//Admin/@OwnerCompanyName"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <!--<xsl:value-of select="//Admin/@OwnerAddr1"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <!--<xsl:value-of select="//Admin/@OwnerAddr2"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <!--<xsl:value-of select="//Admin/@OwnerCity"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin/@OwnerState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <!--<xsl:choose>
+                                <xsl:when test="contains(//Admin/@OwnerZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin/@OwnerZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin/@OwnerZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin/@OwnerZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@OwnerZip)=9">
+                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin/@OwnerZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@OwnerZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin/@OwnerZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <!--<xsl:value-of select="//Admin/@OwnerCountry"/>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerPhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerPhone1"/>&#32;x<xsl:value-of select="//Admin/@OwnerPhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerPhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerPhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerPhone2"/>&#32;x<xsl:value-of select="//Admin/@OwnerPhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerPhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <!--<xsl:choose>
+                                <xsl:when test="//Admin/@OwnerFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin/@OwnerFax"/>&#32;x<xsl:value-of select="//Admin/@OwnerFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@OwnerFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>-->
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <!--<xsl:value-of select="//Admin/@OwnerEmail"/>-->
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="InsuranceCompany">
+                        <xsl:attribute name="Id">
+                            <xsl:value-of select="//Admin/@InsuranceCompanyID"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Name">
+                            <xsl:value-of select="//Admin/@InsuranceCompanyName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <xsl:value-of select="//Admin/@InsuranceAddr1"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <xsl:value-of select="//Admin/@InsuranceAddr2"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <xsl:value-of select="//Admin/@InsuranceCity"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin/@InsuranceState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <xsl:choose>
+                                <xsl:when test="contains(//Admin/@InsuranceZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin/@InsuranceZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin/@InsuranceZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin/@InsuranceZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@InsuranceZip)=9">
+                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin/@InsuranceZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin/@InsuranceZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin/@InsuranceZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <xsl:value-of select="//Admin/@InsuranceCountry"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsurancePhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@InsurancePhone1"/>&#32;x<xsl:value-of select="//Admin/@InsurancePhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsurancePhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsurancePhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin/@InsurancePhone2"/>&#32;x<xsl:value-of select="//Admin/@InsurancePhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsurancePhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <xsl:choose>
+                                <xsl:when test="//Admin/@InsuranceFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin/@InsuranceFax"/>&#32;x<xsl:value-of select="//Admin/@InsuranceFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin/@InsuranceFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <xsl:value-of select="//Admin/@InsuranceEmail"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Insured">
+                        <xsl:attribute name="LastName">
+                            <xsl:value-of select="//Admin/@InsuranceLName"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Claim">
+                        <xsl:attribute name="Number">
+                            <xsl:value-of select="//Admin/@ClaimNumber"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="Estimator">
+                        <xsl:attribute name="FName">
+                            <xsl:value-of select="//Admin2/@EstimatorF"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="LName">
+                            <xsl:value-of select="//Admin2/@EstimatorL"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Company">
+                            <xsl:value-of select="//Admin2/@EstimatorCompanyName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="BodyShopName">
+                            <xsl:value-of select="//Admin2/@BodyShopName"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address">
+                            <xsl:value-of select="//Admin2/@EstimatorAddr1"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Address2">
+                            <xsl:value-of select="//Admin2/@EstimatorAddr2"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="City">
+                            <xsl:value-of select="//Admin2/@EstimatorCity"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="State">
+                            <xsl:value-of select="//Admin2/@EstimatorState"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Zip">
+                            <xsl:choose>
+                                <xsl:when test="contains(//Admin2/@EstimatorZip, '-')">
+                                    <xsl:choose>
+                                        <xsl:when test="string-length(substring-before(//Admin2/@EstimatorZip, '-'))=5">
+                                            <xsl:choose>
+                                                <xsl:when test="string-length(substring-after(//Admin2/@EstimatorZip, '-'))=4">
+                                                    <xsl:value-of select="//Admin2/@EstimatorZip"/>
+                                                </xsl:when>
+                                                <xsl:otherwise>
+                                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>
+                                                </xsl:otherwise>
+                                            </xsl:choose>
+                                        </xsl:when>
+                                    </xsl:choose>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin2/@EstimatorZip)=9">
+                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>-<xsl:value-of select="substring(//Admin2/@EstimatorZip, 6, 4)"/>
+                                </xsl:when>
+                                <xsl:when test="string-length(//Admin2/@EstimatorZip)&gt;4">
+                                    <xsl:value-of select="substring(//Admin2/@EstimatorZip, 1, 5)"/>
+                                </xsl:when>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Country">
+                            <xsl:value-of select="//Admin2/@EstimatorCountry"/>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorPhone1Ext[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone1"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorPhone1Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone1"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Phone2">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorPhone2Ext[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone2"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorPhone2Ext"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorPhone2"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Fax">
+                            <xsl:choose>
+                                <xsl:when test="//Admin2/@EstimatorFaxExt[. != '']">
+                                    <xsl:value-of select="//Admin2/@EstimatorFax"/>&#32;x<xsl:value-of select="//Admin2/@EstimatorFaxExt"/>
+                                </xsl:when>
+                                <xsl:otherwise>
+                                    <xsl:value-of select="//Admin2/@EstimatorFax"/>
+                                </xsl:otherwise>
+                            </xsl:choose>
+                        </xsl:attribute>
+                        <xsl:attribute name="Email">
+                            <xsl:value-of select="//Admin2/@EstimatorEmail"/>
+                        </xsl:attribute>
+                    </xsl:element>
+                    <xsl:element name="RepairInformation">
+                        <xsl:attribute name="VehicleDateIn">
+                            <xsl:if test="string-length(//Admin2/@VehicleInDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@VehicleInDate, ' ')"/>
+                                <xsl:if test="string-length(//Admin2/@VehicleInTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@VehicleInTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@VehicleInTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                        <xsl:attribute name="EstimatedVehicleDateOut">
+                            <xsl:if test="string-length(//Admin2/@TargetVehicleOutDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@TargetVehicleOutDate,' ')"/>
+                                <xsl:if test="string-length(//Admin2/@TargetVehicleOutTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@TargetVehicleOutTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@TargetVehicleOutTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                        <xsl:attribute name="VehicleDateOut">
+                            <xsl:if test="string-length(//Admin2/@VehicleOutDate)&gt;6">
+                                <xsl:value-of select="substring-before(//Admin2/@VehicleOutDate, ' ')"/>
+                                <xsl:if test="string-length(//Admin2/@VehicleOutTime)=4">
+                                    &#32;<xsl:value-of select="substring(//Admin2/@VehicleOutTime, 1, 2)"/>:<xsl:value-of select="substring(//Admin2/@VehicleOutTime, 3, 2)"/>
+                                </xsl:if>
+                            </xsl:if>
+                        </xsl:attribute>
+                    </xsl:element>
+                </xsl:element>
+            </xsl:element>
+        </xsl:for-each>
+    </xsl:template>
+    <xsl:template match="PartsList">
+        <xsl:element name="PartsList" >
+            <xsl:for-each select="Part">
+                <xsl:element name="Part" >
+                    <!-- Part number translation rules -->
+                    <xsl:variable name="OEMPartNumber">
+                        <xsl:if test="substring(@TDPartNum, string-length(@TDPartNum) - 7) != ' GM PART'">
+                            <xsl:value-of select="@TDPartNum" />
+                        </xsl:if>
+                        <xsl:if test="substring(@TDPartNum, string-length(@TDPartNum) - 7) = ' GM PART'">
+                            <xsl:value-of select="substring-before(@TDPartNum,' GM PART')" />
+                        </xsl:if>
+                    </xsl:variable>
+                    <xsl:variable name="AltPartNumber">
+                        <xsl:value-of select="@AltPartNum"/>
+                    </xsl:variable>
+                    <xsl:variable name="PrimaryPartType">
+                        <xsl:value-of select="@PartType"/>
+                    </xsl:variable>
+                    <xsl:variable name="PrimaryPartNumber">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAN'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                            <xsl:when test="@PartType!='PAN'">
+                                <xsl:choose>
+                                    <xsl:when test="$AltPartNumber!=''">
+                                        <xsl:value-of select="$AltPartNumber"/>
+                                    </xsl:when>
+                                    <xsl:when test="$OEMPartNumber!=''">
+                                        <xsl:value-of select="$OEMPartNumber"/>
+                                    </xsl:when>
+                                    <xsl:otherwise>Salvage or Assembly</xsl:otherwise>
+                                </xsl:choose>
+                            </xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:variable name="SecondaryPartNumber">
+                        <xsl:choose>
+                            <xsl:when test="@PartType!='PAN'">
+                                <xsl:value-of select="$OEMPartNumber"/>
+                            </xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:variable name="SecondaryPartType">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAA'">PAN</xsl:when>
+                        </xsl:choose>
+                    </xsl:variable>
+                    <xsl:attribute name="TDPartNum">
+                        <xsl:value-of select="$PrimaryPartNumber"/>
+                    </xsl:attribute>
+                    <xsl:attribute name="AltPartNum">
+                        <xsl:value-of select="$SecondaryPartNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="ExternalPartType">
+                        <xsl:value-of select="$PrimaryPartType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="ExternalAltPartType">
+                        <xsl:value-of select="$SecondaryPartType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartType">
+                        <xsl:choose>
+                            <xsl:when test="$PrimaryPartType='PAN'">1</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAA'">2</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAL'">3</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAM'">4</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAR'">4</xsl:when>
+                            <xsl:when test="$PrimaryPartType='PAC'">4</xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="AltPartType">
+                        <xsl:choose>
+                            <xsl:when test="$SecondaryPartType='PAN'">1</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAA'">2</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAL'">3</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAM'">4</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAC'">4</xsl:when>
+                            <xsl:when test="$SecondaryPartType='PAR'">4</xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartDesc">
+                        <xsl:value-of select="@TDPartDesc" />
+                    </xsl:attribute>
+                    <xsl:attribute name="TDEstimate">
+                        <xsl:choose>
+                            <xsl:when test="@PartType='PAN'">
+                                <xsl:value-of select="@TDEstimate" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAM'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAA'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:when test="@PartType='PAL'">
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:when>
+                            <xsl:otherwise>
+                                <xsl:value-of select="@ActPrice" />
+                            </xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="TDPartQty">
+                        <xsl:value-of select="@TDPartQty" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LineNumber">
+                        <xsl:value-of select="@LineNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="SequenceNumber">
+                        <xsl:value-of select="@SequenceNumber" />
+                    </xsl:attribute>
+                    <xsl:attribute name="SupplLevel">
+                        <xsl:choose>
+                            <xsl:when test="@SupplementLevel = 'E'">0</xsl:when>
+                            <xsl:when test="substring(@SupplementLevel, 1, 1) = 'S'">
+                                <xsl:value-of select="substring(@SupplementLevel, 2)" />
+                            </xsl:when>
+                            <xsl:otherwise>0</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                    <xsl:attribute name="LaborType">
+                        <xsl:value-of select="@LaborType" />
+                    </xsl:attribute>
+                    <xsl:attribute name="LaborHours">
+                      <xsl:value-of select="@LaborHours" />
+                    </xsl:attribute>
+                    <xsl:attribute name="OperationCode">
+                        <xsl:value-of select="@LaborOp" />
+                    </xsl:attribute>
+                    <xsl:attribute name="GlassFlag">
+                        <xsl:value-of select="@GlassFlag" />
+                    </xsl:attribute>
+                    <xsl:attribute name="MarkUp">
+                        <xsl:value-of select="@MarkUp" />
+                    </xsl:attribute>
+                    <xsl:attribute name="CLPart">
+                        <!-- CLPart is false if TRAN_CODE == 2 or TRAN_CODE == 3                           -->
+                        <!-- CLPart is false if PartType is not 'PAN','PAP','PAL','PAG', 'PAM', or 'PAA' or 'PAC' or 'PAR'  -->
+                        <!-- CLPart is false if LaborCode is only labor                                    -->
+                        <!-- CLPart is false if OpCode is not "Remove/Replace" or "Remove/Replace Partial" -->
+                        <xsl:choose>
+                            <xsl:when test="@TransactionCode='3'">False</xsl:when>
+                            <xsl:when test="@TransactionCode='1' or @TransactionCode='2'">
+                                <xsl:choose>
+                                    <xsl:when test="@PartType='PAN' or @PartType='PAG' or @PartType='PAM' or @PartType='PAP' or @PartType='PAL' or @PartType='PAA' or @PartType='PAR' or @PartType='PAC'">
+                                        <xsl:choose>
+                                            <xsl:when test="@LaborType='LAD' or @LaborType='LAE' or @LaborType='LAU' or @LaborType='LAT'">False</xsl:when>
+                                            <xsl:otherwise>
+                                                <xsl:choose>
+                                                    <xsl:when test="@LaborOp='OP0'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP1'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP2'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP3'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP4'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP5'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP6'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP7'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP8'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP9'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP10'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP13'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP14'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP15'">False</xsl:when>
+                                                    <xsl:when test="@LaborOp='OP16'">False</xsl:when>
+                                                    <xsl:otherwise>True</xsl:otherwise>
+                                                </xsl:choose>
+                                            </xsl:otherwise>
+                                        </xsl:choose>
+                                    </xsl:when>
+                                    <xsl:otherwise>False</xsl:otherwise>
+                                </xsl:choose>
+                            </xsl:when>
+                            <xsl:otherwise>False</xsl:otherwise>
+                        </xsl:choose>
+                    </xsl:attribute>
+                </xsl:element>
+            </xsl:for-each>
+        </xsl:element>
+    </xsl:template>
+</xsl:stylesheet>

_reference/OEC/MitchellMapping.xml

@@ -0,0 +1,132 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<TranslationDescriptor>
+    <FileTranslations FormatName="Mitchell" ElementName="Estimate" Description="Translation Descriptor for a Mitchell Estimate, Version EMS 2.0">
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.env">
+            <DBFFileTranslation ID="ID1" ElementName="Envelope" Description="Envelope Table">
+                <DBFFieldSpec FieldName="RO_ID" Form="attribute" Name="RONum" FieldType="" Description="RO Number"/>
+                <DBFFieldSpec FieldName="UNQFILE_ID" Form="attribute" Name="UniqueFileID" FieldType="" Description="Unique File Identifier"/>
+                <DBFFieldSpec FieldName="ESTFILE_ID" Form="attribute" Name="EstimateFileID" FieldType="" Description="Estimate File Identifier"/>
+                <DBFFieldSpec FieldName="INCL_ADMIN" Form="attribute" Name="IncludesAdminInfo" FieldType="Boolean" Description="Includes Admin Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_VEH" Form="attribute" Name="IncludesVehicleInfo" FieldType="Boolean" Description="Includes Vehicle Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_EST" Form="attribute" Name="IncludesEstimateInfo" FieldType="Boolean" Description="Includes Estimate Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_PROFL" Form="attribute" Name="IncludesProfileInfo" FieldType="Boolean" Description="Includes Profile Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_TOTAL" Form="attribute" Name="IncludesTotalsInfo" FieldType="Boolean" Description="Includes Totals Info Flag"/>
+                <DBFFieldSpec FieldName="INCL_VENDR" Form="attribute" Name="IncludesVendorInfo" FieldType="Boolean" Description="Includes Vendor Info Flag"/>
+                <DBFFieldSpec FieldName="EMS_VER" Form="attribute" Name="EMSVersion" FieldType="" Description="EMS Version Number"/>
+                <DBFFieldSpec FieldName="SUPP_NO" Form="attribute" Name="SupplementNum" FieldType="" Description="Supplement Number"/>
+                <DBFFieldSpec FieldName="TRANS_TYPE" Form="attribute" Name="TransactionType" FieldType="" Description="Transaction Type"/>
+                <DBFFieldSpec FieldName="EST_SYSTEM" Form="attribute" Name="EstimatingSystem" FieldType="" Description="Estimating System Software"/>
+                <DBFFieldSpec FieldName="SW_VERSION" Form="attribute" Name="SoftwareVersion" FieldType="" Description="Software Version Identifier"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.LIN">
+            <DBFFileTranslation ID="ID2" ElementSetName="PartsList" ElementName="Part" Description="Parts List Table">
+                <DBFFieldSpec FieldName="OEM_PARTNO" Form="attribute" Name="TDPartNum" FieldType="" Description="Part Number"/>
+                <DBFFieldSpec FieldName="ALT_PARTNO" Form="attribute" Name="AltPartNum" FieldType="" Description="Alternate Part Number"/>
+                <DBFFieldSpec FieldName="ACT_PRICE" Form="attribute" Name="ActPrice" FieldType="" Description="Actual Part Price"/>
+                <DBFFieldSpec FieldName="LINE_DESC" Form="attribute" Name="TDPartDesc" FieldType="" Description="Part Description"/>
+                <DBFFieldSpec FieldName="DB_PRICE" Form="attribute" Name="TDEstimate" FieldType="" Description="DB_Price"/>
+                <DBFFieldSpec FieldName="PART_QTY" Form="attribute" Name="TDPartQty" FieldType="" Description="Part Quantity"/>
+                <DBFFieldSpec FieldName="LINE_NO" Form="attribute" Name="LineNumber" FieldType="" Description=""/>
+                <DBFFieldSpec FieldName="UNQ_SEQ" Form="attribute" Name="SequenceNumber" FieldType="" Description=""/>
+                <DBFFieldSpec FieldName="PART_TYPE" Form="attribute" Name="PartType" FieldType="" Description="Part Type"/>
+                <DBFFieldSpec FieldName="MOD_LBR_TY" Form="attribute" Name="LaborType" FieldType="" Description="Labor Type"/>
+                <DBFFieldSpec FieldName="MOD_LB_HRS" Form="attribute" Name="LaborHours" FieldType="" Description="Labor Hours"/>
+                <DBFFieldSpec FieldName="LBR_OP" Form="attribute" Name="LaborOp" FieldType="" Description="Labor Op"/>
+                <DBFFieldSpec FieldName="LINE_IND" Form="attribute" Name="SupplementLevel" FieldType="" Description="Supplement Level"/>
+                <DBFFieldSpec FieldName="TRAN_CODE" Form="attribute" Name="TransactionCode" FieldType="" Description="Transaction Code"/>
+                <DBFFieldSpec FieldName="GLASS_FLAG" Form="attribute" Name="GlassFlag" FieldType="" Description="Glass Flag"/>
+                <DBFFieldSpec FieldName="PRT_DSMK_M" Form="attribute" Name="MarkUp" FieldType="" Description="Price Mark up for non OEM parts"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.VEH">
+            <DBFFileTranslation ID="ID3" ElementName="Vehicle" Description="Vehicle Table">
+                <DBFFieldSpec FieldName="V_VIN" Form="attribute" Name="TransVIN" FieldType="" Description=""/>
+                <DBFFieldSpec FieldName="V_MODEL_YR" Form="attribute" Name="TransYear" FieldType="" Description="V_MODEL_YR"/>
+                <DBFFieldSpec FieldName="V_MAKEDESC" Form="attribute" Name="ManufName" FieldType="" Description="V_MAKEDESC"/>
+                <DBFFieldSpec FieldName="V_MAKECODE" Form="attribute" Name="ManufCode" FieldType="" Description="V_MAKECODE"/>
+                <DBFFieldSpec FieldName="V_MODEL" Form="attribute" Name="TransModel" FieldType="" Description="V_MODEL"/>
+                <DBFFieldSpec FieldName="V_MILEAGE" Form="attribute" Name="TransMileage" FieldType="" Description="V_MILEAGE"/>
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.AD1">
+            <DBFFileTranslation ID="ID4" ElementName="Admin" Description="Administrative information">
+                <DBFFieldSpec FieldName="OWNR_LN" Form="attribute" Name="OwnerL" FieldType="" Description="Owner Lastname"/>
+                <DBFFieldSpec FieldName="OWNR_FN" Form="attribute" Name="OwnerF" FieldType="" Description="Owner Firstname"/>
+                <DBFFieldSpec FieldName="OWNR_CO_NM" Form="attribute" Name="OwnerCompanyName" FieldType="" Description="Owner Company Name"/>
+                <DBFFieldSpec FieldName="OWNR_TITLE" Form="attribute" Name="OwnerTitle" FieldType="" Description="Owner Title"/>
+                <DBFFieldSpec FieldName="OWNR_ADDR1" Form="attribute" Name="OwnerAddr1" FieldType="" Description="Owner Address Line 1"/>
+                <DBFFieldSpec FieldName="OWNR_ADDR2" Form="attribute" Name="OwnerAddr2" FieldType="" Description="Owner Address Line 2"/>
+                <DBFFieldSpec FieldName="OWNR_CITY" Form="attribute" Name="OwnerCity" FieldType="" Description="Owner City"/>
+                <DBFFieldSpec FieldName="OWNR_ST" Form="attribute" Name="OwnerState" FieldType="" Description="Owner State"/>
+                <DBFFieldSpec FieldName="OWNR_ZIP" Form="attribute" Name="OwnerZip" FieldType="" Description="Owner Zip"/>
+                <DBFFieldSpec FieldName="OWNR_CTRY" Form="attribute" Name="OwnerCountry" FieldType="" Description="Owner Country"/>
+                <DBFFieldSpec FieldName="OWNR_PH1" Form="attribute" Name="OwnerPhone1" FieldType="" Description="Owner Primary Phone"/>
+                <DBFFieldSpec FieldName="OWNR_PH1X" Form="attribute" Name="OwnerPhone1Ext" FieldType="" Description="Owner Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="OWNR_PH2" Form="attribute" Name="OwnerPhone2" FieldType="" Description="Owner Secondary Phone"/>
+                <DBFFieldSpec FieldName="OWNR_PH2X" Form="attribute" Name="OwnerPhone2Ext" FieldType="" Description="Owner Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="OWNR_FAX" Form="attribute" Name="OwnerFax" FieldType="" Description="Owner Fax"/>
+                <DBFFieldSpec FieldName="OWNR_FAXX" Form="attribute" Name="OwnerFaxExt" FieldType="" Description="Owner Fax Extension"/>
+                <DBFFieldSpec FieldName="OWNR_EA" Form="attribute" Name="OwnerEmail" FieldType="" Description="Owner Email Address"/>
+                <DBFFieldSpec FieldName="INS_CO_NM" Form="attribute" Name="InsuranceCompanyName" FieldType="" Description="Insurance Company Name"/>
+                <DBFFieldSpec FieldName="INS_CO_ID" Form="attribute" Name="InsuranceCompanyID" FieldType="" Description="Insurance Company Identifier"/>
+                <DBFFieldSpec FieldName="INS_ADDR1" Form="attribute" Name="InsuranceAddr1" FieldType="" Description="Insurance Address Line 1"/>
+                <DBFFieldSpec FieldName="INS_ADDR2" Form="attribute" Name="InsuranceAddr2" FieldType="" Description="Insurance Address Line 2"/>
+                <DBFFieldSpec FieldName="INS_CITY" Form="attribute" Name="InsuranceCity" FieldType="" Description="Insurance City"/>
+                <DBFFieldSpec FieldName="INS_ST" Form="attribute" Name="InsuranceState" FieldType="" Description="Insurance State"/>
+                <DBFFieldSpec FieldName="INS_ZIP" Form="attribute" Name="InsuranceZip" FieldType="" Description="Insurance Zip"/>
+                <DBFFieldSpec FieldName="INS_CTRY" Form="attribute" Name="InsuranceCountry" FieldType="" Description="Insurance Country"/>
+                <DBFFieldSpec FieldName="INS_PH1" Form="attribute" Name="InsurancePhone1" FieldType="" Description="Insurance Primary Phone"/>
+                <DBFFieldSpec FieldName="INS_PH1X" Form="attribute" Name="InsurancePhone1Ext" FieldType="" Description="Insurance Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="INS_PH2" Form="attribute" Name="InsurancePhone2" FieldType="" Description="Insurance Secondary Phone"/>
+                <DBFFieldSpec FieldName="INS_PH2X" Form="attribute" Name="InsurancePhone2Ext" FieldType="" Description="Insurance Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="INS_FAX" Form="attribute" Name="InsuranceFax" FieldType="" Description="Insurance Fax"/>
+                <DBFFieldSpec FieldName="INS_FAXX" Form="attribute" Name="InsuranceFaxExt" FieldType="" Description="Insurance Fax Extension"/>
+                <DBFFieldSpec FieldName="INS_EA" Form="attribute" Name="InsuranceEmail" FieldType="" Description="Insurance Email Address"/>
+                <DBFFieldSpec FieldName="INSD_LN" Form="attribute" Name="InsuranceLName" FieldType="" Description="Insurance Last Name"/>
+                <DBFFieldSpec FieldName="CLM_NO" Form="attribute" Name="ClaimNumber" FieldType="" Description="Claim Number"/>
+
+
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.AD2">
+            <DBFFileTranslation ID="ID5" ElementName="Admin2" Description="Administrative information2">
+                <DBFFieldSpec FieldName="EST_CT_LN" Form="attribute" Name="EstimatorL" FieldType="" Description="Estimator Lastname"/>
+                <DBFFieldSpec FieldName="EST_CT_FN" Form="attribute" Name="EstimatorF" FieldType="" Description="Estimator Firstname"/>
+                <DBFFieldSpec FieldName="EST_CO_NM" Form="attribute" Name="EstimatorCompanyName" FieldType="" Description="Estimator Company Name"/>
+                <DBFFieldSpec FieldName="EST_CO_ID" Form="attribute" Name="EstimatorCompanyID" FieldType="" Description="Estimator Company Identifier"/>
+                <DBFFieldSpec FieldName="EST_ADDR1" Form="attribute" Name="EstimatorAddr1" FieldType="" Description="Estimator Address1"/>
+                <DBFFieldSpec FieldName="EST_ADDR2" Form="attribute" Name="EstimatorAddr2" FieldType="" Description="Estimator Address2"/>
+                <DBFFieldSpec FieldName="EST_CITY" Form="attribute" Name="EstimatorCity" FieldType="" Description="Estimator City"/>
+                <DBFFieldSpec FieldName="EST_ST" Form="attribute" Name="EstimatorState" FieldType="" Description="Estimator State"/>
+                <DBFFieldSpec FieldName="EST_ZIP" Form="attribute" Name="EstimatorZip" FieldType="" Description="Estimator Zip"/>
+                <DBFFieldSpec FieldName="EST_CTRY" Form="attribute" Name="EstimatorCountry" FieldType="" Description="Estimator Country"/>
+                <DBFFieldSpec FieldName="EST_PH1" Form="attribute" Name="EstimatorPhone1" FieldType="" Description="Estimator Primary Phone"/>
+                <DBFFieldSpec FieldName="EST_PH1X" Form="attribute" Name="EstimatorPhone1Ext" FieldType="" Description="Estimator Primary Phone Extension"/>
+                <DBFFieldSpec FieldName="EST_PH2" Form="attribute" Name="EstimatorPhone2" FieldType="" Description="Estimator Secondary Phone"/>
+                <DBFFieldSpec FieldName="EST_PH2X" Form="attribute" Name="EstimatorPhone2Ext" FieldType="" Description="Estimator Secondary Phone Extension"/>
+                <DBFFieldSpec FieldName="EST_FAX" Form="attribute" Name="EstimatorFax" FieldType="" Description="Estimator Fax"/>
+                <DBFFieldSpec FieldName="EST_FAXX" Form="attribute" Name="EstimatorFaxExt" FieldType="" Description="Estimator Fax Extension"/>
+                <DBFFieldSpec FieldName="EST_EA" Form="attribute" Name="EstimatorEmail" FieldType="" Description="Estimator Email Address"/>
+                <DBFFieldSpec FieldName="EST_LIC_NO" Form="attribute" Name="EstimatorLicenseNumber" FieldType="" Description="Estimator License Number"/>
+                <DBFFieldSpec FieldName="EST_FILENO" Form="attribute" Name="EstimatorFileNumber" FieldType="" Description="Estimator File Number"/>
+                <DBFFieldSpec FieldName="RO_IN_DATE" Form="attribute" Name="VehicleInDate" FieldType="" Description="Date arrived in shop"/>
+                <DBFFieldSpec FieldName="RO_IN_TIME" Form="attribute" Name="VehicleInTime" FieldType="" Description="Time arrived in shop"/>
+                <DBFFieldSpec FieldName="TAR_DATE" Form="attribute" Name="TargetVehicleOutDate" FieldType="" Description="Target date to be completed"/>
+                <DBFFieldSpec FieldName="TAR_TIME" Form="attribute" Name="TargetVehicleOutTime" FieldType="" Description="Target time to be completed"/>
+                <DBFFieldSpec FieldName="RO_CMPDATE" Form="attribute" Name="VehicleOutDate" FieldType="" Description="Date completed"/>
+                <DBFFieldSpec FieldName="RO_CMPTIME" Form="attribute" Name="VehicleOutTime" FieldType="" Description="Time completed"/>
+                <DBFFieldSpec FieldName="RF_CO_NM" Form="attribute" Name="BodyShopName" FieldType="" Description="Body Shop Name"/>
+
+            </DBFFileTranslation>
+        </FileTranslation>
+        <FileTranslation TranslatorID="OECImportEngine.DBFTranslator" FileNameMask="*.TTL">
+          <DBFFileTranslation ID="ID6" ElementName="Total" Description="Total Table">
+            <DBFFieldSpec FieldName="G_TTL_AMT" Form="attribute" Name="GrandTotalAmount" FieldType="" Description=""/>
+          </DBFFileTranslation>
+        </FileTranslation>
+    </FileTranslations>
+    <StyleSheetTranslation>
+        <StyleSheetURL>Mitchell.xsl</StyleSheetURL>
+    </StyleSheetTranslation>
+</TranslationDescriptor>

client/craco.config.js

@@ -1,9 +1,25 @@
 // craco.config.js
 const TerserPlugin = require("terser-webpack-plugin");
 const CracoLessPlugin = require("craco-less");
+const SentryWebpackPlugin = require("@sentry/webpack-plugin");
 
 module.exports = {
   plugins: [
+    {
+      plugin: SentryWebpackPlugin,
+      options: {
+        // sentry-cli configuration
+        authToken:
+          "6b45b028a02342db97a9a2f92c0959058665443d379d4a3a876430009e744260",
+        org: "snapt-software",
+        project: "imexonline",
+        release: process.env.REACT_APP_GIT_SHA,
+
+        // webpack-specific configuration
+        include: ".",
+        ignore: ["node_modules", "webpack.config.js"],
+      },
+    },
     {
       plugin: CracoLessPlugin,
       options: {
@@ -53,4 +69,5 @@ module.exports = {
       },
     }),
   },
+  devtool: "source-map",
 };

client/package.json

@@ -2,83 +2,90 @@
   "name": "bodyshop",
   "version": "0.1.1",
   "private": true,
-  "proxy": "http://localhost:5000",
+  "proxy": "http://localhost:4000",
   "dependencies": {
-    "@apollo/client": "^3.3.17",
-    "@craco/craco": "^5.9.0",
-    "@fingerprintjs/fingerprintjs": "^3.1.2",
-    "@lourenci/react-kanban": "^2.1.0",
-    "@sentry/react": "^6.3.6",
-    "@sentry/tracing": "^6.3.6",
-    "@stripe/react-stripe-js": "^1.4.0",
-    "@stripe/stripe-js": "^1.14.0",
-    "@tanem/react-nprogress": "^3.0.65",
-    "antd": "^4.15.5",
+    "@apollo/client": "^3.5.5",
+    "@asseinfo/react-kanban": "^2.2.0",
+    "@craco/craco": "^6.4.2",
+    "@fingerprintjs/fingerprintjs": "^3.3.0",
+    "@openreplay/tracker": "^3.4.10",
+    "@openreplay/tracker-assist": "^3.4.9",
+    "@openreplay/tracker-graphql": "^3.0.0",
+    "@openreplay/tracker-redux": "^3.4.8",
+    "@sentry/react": "^6.15.0",
+    "@sentry/tracing": "^6.15.0",
+    "@splitsoftware/splitio-react": "^1.3.0",
+    "@stripe/react-stripe-js": "^1.6.0",
+    "@stripe/stripe-js": "^1.21.2",
+    "@tanem/react-nprogress": "^3.0.82",
+    "antd": "^4.17.3",
     "apollo-link-logger": "^2.0.0",
-    "axios": "^0.21.1",
-    "craco-less": "^1.17.1",
-    "dinero.js": "^1.8.1",
-    "dotenv": "^9.0.2",
+    "axios": "^0.24.0",
+    "craco-less": "^1.20.0",
+    "dinero.js": "^1.9.1",
+    "dotenv": "^10.0.0",
     "enquire-js": "^0.2.1",
     "env-cmd": "^10.1.0",
-    "exifr": "^7.0.0",
-    "firebase": "^8.6.0",
-    "graphql": "^15.5.0",
-    "i18next": "^20.2.2",
-    "i18next-browser-languagedetector": "^6.1.1",
-    "jsoneditor": "^9.4.1",
+    "exifr": "^7.1.3",
+    "firebase": "^9.6.0",
+    "graphql": "^16.0.1",
+    "i18next": "^21.5.4",
+    "i18next-browser-languagedetector": "^6.1.2",
+    "jsoneditor": "^9.5.7",
     "jsreport-browser-client-dist": "^1.3.0",
-    "libphonenumber-js": "^1.9.17",
-    "logrocket": "^1.2.0",
-    "markerjs2": "^2.8.1",
+    "libphonenumber-js": "^1.9.44",
+    "logrocket": "^2.1.2",
+    "markerjs2": "^2.17.2",
     "moment-business-days": "^1.2.0",
-    "phone": "^2.4.21",
+    "phone": "^3.1.10",
     "preval.macro": "^5.0.0",
     "prop-types": "^15.7.2",
-    "query-string": "^7.0.0",
-    "rc-queue-anim": "^1.8.5",
+    "query-string": "^7.0.1",
+    "rc-queue-anim": "^2.0.0",
     "rc-scroll-anim": "^2.7.6",
     "react": "^17.0.1",
-    "react-big-calendar": "^0.33.2",
+    "react-big-calendar": "^0.38.1",
     "react-color": "^2.19.3",
+    "react-cookie": "^4.1.1",
     "react-dom": "^17.0.1",
     "react-drag-listview": "^0.1.8",
     "react-grid-gallery": "^0.5.5",
-    "react-grid-layout": "^1.2.5",
-    "react-i18next": "^11.8.15",
-    "react-icons": "^4.2.0",
-    "react-number-format": "^4.5.5",
-    "react-redux": "^7.2.4",
-    "react-resizable": "^3.0.1",
-    "react-router-dom": "^5.2.0",
+    "react-grid-layout": "^1.3.0",
+    "react-i18next": "^11.14.3",
+    "react-icons": "^4.3.1",
+    "react-number-format": "^4.8.0",
+    "react-redux": "^7.2.6",
+    "react-resizable": "^3.0.4",
+    "react-router-dom": "^5.3.0",
     "react-scripts": "^4.0.3",
     "react-sublime-video": "^0.2.5",
     "react-virtualized": "^9.22.3",
-    "recharts": "^2.0.7",
-    "redux": "^4.1.0",
+    "recharts": "^2.1.6",
+    "redux": "^4.1.2",
     "redux-persist": "^6.0.0",
     "redux-saga": "^1.1.3",
     "redux-state-sync": "^3.1.2",
-    "reselect": "^4.0.0",
-    "sass": "^1.32.13",
-    "socket.io-client": "^4.1.2",
-    "styled-components": "^5.3.0",
-    "subscriptions-transport-ws": "^0.9.18",
-    "web-vitals": "^1.1.2",
-    "workbox-background-sync": "^6.1.5",
-    "workbox-broadcast-update": "^6.1.5",
-    "workbox-cacheable-response": "^6.1.5",
-    "workbox-core": "^6.1.5",
-    "workbox-expiration": "^6.1.5",
-    "workbox-google-analytics": "^6.1.5",
-    "workbox-navigation-preload": "^6.1.5",
-    "workbox-precaching": "^6.1.5",
-    "workbox-range-requests": "^6.1.5",
-    "workbox-routing": "^6.1.5",
-    "workbox-strategies": "^6.1.5",
-    "workbox-streams": "^6.1.5"
+    "reselect": "^4.1.5",
+    "sass": "^1.44.0",
+    "socket.io-client": "^4.4.0",
+    "styled-components": "^5.3.3",
+    "subscriptions-transport-ws": "^0.11.0",
+    "web-vitals": "^2.1.2",
+    "workbox-background-sync": "^6.4.2",
+    "workbox-broadcast-update": "^6.4.2",
+    "workbox-cacheable-response": "^6.4.2",
+    "workbox-core": "^6.4.2",
+    "workbox-expiration": "^6.4.2",
+    "workbox-google-analytics": "^6.4.2",
+    "workbox-navigation-preload": "^6.4.2",
+    "workbox-precaching": "^6.4.2",
+    "workbox-range-requests": "^6.4.2",
+    "workbox-routing": "^6.4.2",
+    "workbox-strategies": "^6.4.2",
+    "workbox-streams": "^6.4.2"
   },
   "scripts": {
+    "postinstall": "patch-package",
     "analyze": "source-map-explorer 'build/static/js/*.js'",
     "start": "craco start",
     "build": "REACT_APP_GIT_SHA=`git rev-parse --short HEAD` craco build",
@@ -108,6 +115,8 @@
     ]
   },
   "devDependencies": {
+    "@sentry/webpack-plugin": "^1.18.3",
+    "patch-package": "^6.4.7",
     "redux-logger": "^3.0.6",
     "source-map-explorer": "^2.5.2"
   }

client/src/App/App.container.jsx

@@ -1,4 +1,8 @@
 import { ApolloProvider } from "@apollo/client";
+//import trackerRedux from "@openreplay/tracker-redux";
+import Tracker from "@openreplay/tracker";
+import trackerGraphQL from "@openreplay/tracker-graphql";
+import { SplitFactory, SplitSdk } from "@splitsoftware/splitio-react";
 import { ConfigProvider } from "antd";
 import enLocale from "antd/es/locale/en_US";
 import LogRocket from "logrocket";
@@ -6,12 +10,40 @@ import moment from "moment";
 import React from "react";
 import { useTranslation } from "react-i18next";
 import GlobalLoadingBar from "../components/global-loading-bar/global-loading-bar.component";
+//import trackerAssist from "@openreplay/tracker-assist";
+import { getCurrentUser } from "../firebase/firebase.utils";
 import client from "../utils/GraphQLClient";
 import App from "./App";
+
 moment.locale("en-US");
 
+export const tracker = new Tracker({
+  projectKey: "trDmOZlEXUpjGsMtHroA",
+  ingestPoint: "https://replay.imex.online/ingest",
+  ...(process.env.NODE_ENV === null || process.env.NODE_ENV === "development"
+    ? { __DISABLE_SECURE_MODE: true }
+    : {}),
+  // beaconSize: 10485760,
+  onStart: async ({ sessionID }) => {
+    const user = await getCurrentUser();
+    if (user) tracker.setUserID(user.email);
+  },
+});
+
+// tracker.use(
+//   trackerAssist({ confirmText: "Technical support is about to assist you." })
+// ); // check the list of available options below
+export const recordGraphQL = tracker.use(trackerGraphQL());
+//tracker.start();
 if (process.env.NODE_ENV === "production") LogRocket.init("gvfvfw/bodyshopapp");
 
+export const factory = SplitSdk({
+  core: {
+    authorizationKey: process.env.REACT_APP_SPLIT_API,
+    key: "anon",
+  },
+});
+
 export default function AppContainer() {
   const { t } = useTranslation();
 
@@ -29,7 +61,9 @@ export default function AppContainer() {
         }}
       >
         <GlobalLoadingBar />
-        <App />
+        <SplitFactory factory={factory}>
+          <App />
+        </SplitFactory>
       </ConfigProvider>
     </ApolloProvider>
   );

client/src/App/App.jsx

@@ -53,7 +53,6 @@ export function App({ checkUserSession, currentUser, online, setOnline }) {
   const { t } = useTranslation();
 
   window.addEventListener("offline", function (e) {
-    console.log("Internet connection lost.");
     setOnline(false);
   });
 

client/src/App/App.styles.scss

@@ -124,3 +124,13 @@
     z-index: 2 !important;
   }
 }
+
+.react-kanban-column {
+  background-color: #ddd !important;
+}
+
+.production-list-table {
+  td.ant-table-column-sort {
+    background: unset;
+  }
+}

client/src/components/_test/test.component.jsx

@@ -1,25 +1,9 @@
-import Axios from "axios";
 import React from "react";
+import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
 export default function Test() {
-  const handleQbSignIn = async () => {
-    const result = await Axios.post("/qbo/authorize", { userId: "1234" });
-    console.log("handleQbSignIn -> result", result.data);
-    // window.open(result.data, "_blank", "toolbar=0,location=0,menubar=0");
-
-    var parameters = "location=1,width=800,height=650";
-    parameters +=
-      ",left=" +
-      (window.screen.width - 800) / 2 +
-      ",top=" +
-      (window.screen.height - 650) / 2;
-
-    // Launch Popup
-    window.open(result.data, "connectPopup", parameters);
-  };
-
   return (
     <div>
-      <button onClick={handleQbSignIn}>Sign Into Qb.</button>
+      <QboAuthorizeComponent />
     </div>
   );
 }

client/src/components/accounting-payables-table/accounting-payables-table.component.jsx

@@ -9,8 +9,25 @@ import PayableExportAll from "../payable-export-all-button/payable-export-all-bu
 import { DateFormatter } from "../../utils/DateFormatter";
 import queryString from "query-string";
 import { logImEXEvent } from "../../firebase/firebase.utils";
+import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { selectBodyshop } from "../../redux/user/user.selectors";
 
-export default function AccountingPayablesTableComponent({ loading, bills }) {
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
+
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(AccountingPayablesTableComponent);
+
+export function AccountingPayablesTableComponent({ bodyshop, loading, bills }) {
   const { t } = useTranslation();
   const [selectedBills, setSelectedBills] = useState([]);
   const [transInProgress, setTransInProgress] = useState(false);
@@ -109,6 +126,17 @@ export default function AccountingPayablesTableComponent({ loading, bills }) {
         <Checkbox disabled checked={record.is_credit_memo} />
       ),
     },
+    {
+      title: t("exportlogs.labels.attempts"),
+      dataIndex: "attempts",
+      key: "attempts",
+
+      render: (text, record) => {
+        const success = record.exportlogs.filter((e) => e.successful).length;
+        const attempts = record.exportlogs.length;
+        return `${success}/${attempts}`;
+      },
+    },
     {
       title: t("general.labels.actions"),
       dataIndex: "actions",
@@ -121,6 +149,7 @@ export default function AccountingPayablesTableComponent({ loading, bills }) {
             billId={record.id}
             disabled={transInProgress || !!record.exported}
             loadingCallback={setTransInProgress}
+            setSelectedBills={setSelectedBills}
           />
         </div>
       ),
@@ -154,6 +183,9 @@ export default function AccountingPayablesTableComponent({ loading, bills }) {
             loadingCallback={setTransInProgress}
             completedCallback={setSelectedBills}
           />
+          {bodyshop.accountingconfig && bodyshop.accountingconfig.qbo && (
+            <QboAuthorizeComponent />
+          )}
           <Input
             value={state.search}
             onChange={handleSearch}

client/src/components/accounting-payments-table/accounting-payments-table.component.jsx

@@ -8,8 +8,26 @@ import { DateFormatter, DateTimeFormatter } from "../../utils/DateFormatter";
 import { alphaSort, dateSort } from "../../utils/sorters";
 import PaymentExportButton from "../payment-export-button/payment-export-button.component";
 import PaymentsExportAllButton from "../payments-export-all-button/payments-export-all-button.component";
+import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { selectBodyshop } from "../../redux/user/user.selectors";
 
-export default function AccountingPayablesTableComponent({
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
+
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(AccountingPayablesTableComponent);
+
+export function AccountingPayablesTableComponent({
+  bodyshop,
   loading,
   payments,
 }) {
@@ -108,7 +126,17 @@ export default function AccountingPayablesTableComponent({
         <DateTimeFormatter>{record.exportedat}</DateTimeFormatter>
       ),
     },
+    {
+      title: t("exportlogs.labels.attempts"),
+      dataIndex: "attempts",
+      key: "attempts",
 
+      render: (text, record) => {
+        const success = record.exportlogs.filter((e) => e.successful).length;
+        const attempts = record.exportlogs.length;
+        return `${success}/${attempts}`;
+      },
+    },
     {
       title: t("general.labels.actions"),
       dataIndex: "actions",
@@ -120,6 +148,7 @@ export default function AccountingPayablesTableComponent({
           paymentId={record.id}
           disabled={transInProgress || !!record.exportedat}
           loadingCallback={setTransInProgress}
+          setSelectedPayments={setSelectedPayments}
         />
       ),
     },
@@ -152,6 +181,9 @@ export default function AccountingPayablesTableComponent({
             loadingCallback={setTransInProgress}
             completedCallback={setSelectedPayments}
           />
+          {bodyshop.accountingconfig && bodyshop.accountingconfig.qbo && (
+            <QboAuthorizeComponent />
+          )}
           <Input
             value={state.search}
             onChange={handleSearch}

client/src/components/accounting-receivables-table/accounting-receivables-table.component.jsx

@@ -8,7 +8,26 @@ import { alphaSort } from "../../utils/sorters";
 import JobExportButton from "../jobs-close-export-button/jobs-close-export-button.component";
 import JobsExportAllButton from "../jobs-export-all-button/jobs-export-all-button.component";
 
-export default function AccountingReceivablesTableComponent({ loading, jobs }) {
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { selectBodyshop } from "../../redux/user/user.selectors";
+import QboAuthorizeComponent from "../qbo-authorize/qbo-authorize.component";
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(AccountingReceivablesTableComponent);
+
+export function AccountingReceivablesTableComponent({
+  bodyshop,
+  loading,
+  jobs,
+}) {
   const { t } = useTranslation();
   const [selectedJobs, setSelectedJobs] = useState([]);
   const [transInProgress, setTransInProgress] = useState(false);
@@ -114,17 +133,28 @@ export default function AccountingReceivablesTableComponent({ loading, jobs }) {
         );
       },
     },
+    {
+      title: t("exportlogs.labels.attempts"),
+      dataIndex: "attempts",
+      key: "attempts",
+
+      render: (text, record) => {
+        const success = record.exportlogs.filter((e) => e.successful).length;
+        const attempts = record.exportlogs.length;
+        return `${success}/${attempts}`;
+      },
+    },
     {
       title: t("general.labels.actions"),
       dataIndex: "actions",
       key: "actions",
-      sorter: (a, b) => a.clm_total - b.clm_total,
 
       render: (text, record) => (
         <Space wrap>
           <JobExportButton
             jobId={record.id}
             disabled={!!record.date_exported}
+            setSelectedJobs={setSelectedJobs}
           />
           <Link to={`/manage/jobs/${record.id}/close`}>
             <Button>{t("jobs.labels.viewallocations")}</Button>
@@ -169,12 +199,17 @@ export default function AccountingReceivablesTableComponent({ loading, jobs }) {
     <Card
       extra={
         <Space wrap>
-          <JobsExportAllButton
-            jobIds={selectedJobs}
-            disabled={transInProgress || selectedJobs.length === 0}
-            loadingCallback={setTransInProgress}
-            completedCallback={setSelectedJobs}
-          />
+          {!bodyshop.cdk_dealerid && !bodyshop.pbs_serialnumber && (
+            <JobsExportAllButton
+              jobIds={selectedJobs}
+              disabled={transInProgress || selectedJobs.length === 0}
+              loadingCallback={setTransInProgress}
+              completedCallback={setSelectedJobs}
+            />
+          )}
+          {bodyshop.accountingconfig && bodyshop.accountingconfig.qbo && (
+            <QboAuthorizeComponent />
+          )}
           <Input.Search
             value={state.search}
             onChange={handleSearch}

client/src/components/bill-detail-edit/bill-detail-edit.container.jsx

@@ -26,6 +26,8 @@ import BillReeportButtonComponent from "../bill-reexport-button/bill-reexport-bu
 import { connect } from "react-redux";
 import { createStructuredSelector } from "reselect";
 import { setModalContext } from "../../redux/modals/modals.actions";
+import { insertAuditTrail } from "../../redux/application/application.actions";
+import AuditTrailMapping from "../../utils/AuditTrailMappings";
 
 const mapStateToProps = createStructuredSelector({
   //currentUser: selectCurrentUser
@@ -33,6 +35,8 @@ const mapStateToProps = createStructuredSelector({
 const mapDispatchToProps = (dispatch) => ({
   setPartsOrderContext: (context) =>
     dispatch(setModalContext({ context: context, modal: "partsOrder" })),
+  insertAuditTrail: ({ jobid, operation }) =>
+    dispatch(insertAuditTrail({ jobid, operation })),
 });
 
 export default connect(
@@ -40,7 +44,10 @@ export default connect(
   mapDispatchToProps
 )(BillDetailEditcontainer);
 
-export function BillDetailEditcontainer({ setPartsOrderContext }) {
+export function BillDetailEditcontainer({
+  setPartsOrderContext,
+  insertAuditTrail,
+}) {
   const search = queryString.parse(useLocation().search);
   const history = useHistory();
   const { t } = useTranslation();
@@ -134,6 +141,12 @@ export function BillDetailEditcontainer({ setPartsOrderContext }) {
     });
     await Promise.all(updates);
 
+    insertAuditTrail({
+      jobid: bill.jobid,
+      billid: search.billid,
+      operation: AuditTrailMapping.billupdated(bill.invoice_number),
+    });
+
     await refetch();
     form.setFieldsValue(transformData(data));
     form.resetFields();

client/src/components/bill-enter-modal/bill-enter-modal.container.jsx

@@ -11,13 +11,17 @@ import {
   QUERY_JOB_LBR_ADJUSTMENTS,
   UPDATE_JOB,
 } from "../../graphql/jobs.queries";
+import { insertAuditTrail } from "../../redux/application/application.actions";
 import { toggleModalVisible } from "../../redux/modals/modals.actions";
 import { selectBillEnterModal } from "../../redux/modals/modals.selectors";
 import {
   selectBodyshop,
   selectCurrentUser,
 } from "../../redux/user/user.selectors";
+import confirmDialog from "../../utils/asyncConfirm";
+import AuditTrailMapping from "../../utils/AuditTrailMappings";
 import BillFormContainer from "../bill-form/bill-form.container";
+import { CalculateBillTotal } from "../bill-form/bill-form.totals.utility";
 import { handleUpload } from "../documents-upload/documents-upload.utility";
 
 const mapStateToProps = createStructuredSelector({
@@ -27,6 +31,8 @@ const mapStateToProps = createStructuredSelector({
 });
 const mapDispatchToProps = (dispatch) => ({
   toggleModalVisible: () => dispatch(toggleModalVisible("billEnter")),
+  insertAuditTrail: ({ jobid, operation }) =>
+    dispatch(insertAuditTrail({ jobid, operation })),
 });
 
 function BillEnterModalContainer({
@@ -34,6 +40,7 @@ function BillEnterModalContainer({
   toggleModalVisible,
   bodyshop,
   currentUser,
+  insertAuditTrail,
 }) {
   const [form] = Form.useForm();
   const { t } = useTranslation();
@@ -43,7 +50,31 @@ function BillEnterModalContainer({
   const [loading, setLoading] = useState(false);
   const client = useApolloClient();
 
+  const formValues = useMemo(() => {
+    return {
+      ...billEnterModal.context.bill,
+      jobid:
+        (billEnterModal.context.job && billEnterModal.context.job.id) || null,
+      federal_tax_rate:
+        (bodyshop.bill_tax_rates && bodyshop.bill_tax_rates.federal_tax_rate) ||
+        0,
+      state_tax_rate:
+        (bodyshop.bill_tax_rates && bodyshop.bill_tax_rates.state_tax_rate) ||
+        0,
+      local_tax_rate:
+        (bodyshop.bill_tax_rates && bodyshop.bill_tax_rates.local_tax_rate) ||
+        0,
+    };
+  }, [billEnterModal, bodyshop]);
+
   const handleFinish = async (values) => {
+    let totals = CalculateBillTotal(values);
+    if (totals.discrepancy.getAmount() !== 0) {
+      if (!(await confirmDialog(t("bills.labels.savewithdiscrepancy")))) {
+        return;
+      }
+    }
+
     setLoading(true);
     const { upload, location, ...remainingValues } = values;
 
@@ -81,8 +112,9 @@ function BillEnterModalContainer({
           },
         ],
       },
+      refetchQueries: ["QUERY_PARTS_BILLS_BY_JOBID"],
     });
-    console.log("adjustmentsToInsert", adjustmentsToInsert);
+
     const adjKeys = Object.keys(adjustmentsToInsert);
     if (adjKeys.length > 0) {
       //Query the adjustments, merge, and update them.
@@ -115,7 +147,12 @@ function BillEnterModalContainer({
             message: JSON.stringify(jobUpdate.errors),
           }),
         });
+        return;
       }
+      insertAuditTrail({
+        jobid: values.jobid,
+        operation: AuditTrailMapping.jobmodifylbradj(),
+      });
     }
 
     if (!!r1.errors) {
@@ -171,9 +208,15 @@ function BillEnterModalContainer({
     });
     if (billEnterModal.actions.refetch) billEnterModal.actions.refetch();
 
+    insertAuditTrail({
+      jobid: values.jobid,
+      billid: billId,
+      operation: AuditTrailMapping.billposted(remainingValues.invoice_number),
+    });
+
     if (enterAgain) {
       form.resetFields();
-      form.setFieldsValue({ billlines: [] });
+      form.setFieldsValue({ ...form.getFieldsValue(), billlines: [] });
     } else {
       toggleModalVisible();
     }
@@ -191,23 +234,6 @@ function BillEnterModalContainer({
     if (enterAgain) form.submit();
   }, [enterAgain, form]);
 
-  const formValues = useMemo(() => {
-    return {
-      ...billEnterModal.context.bill,
-      jobid:
-        (billEnterModal.context.job && billEnterModal.context.job.id) || null,
-      federal_tax_rate:
-        (bodyshop.bill_tax_rates && bodyshop.bill_tax_rates.federal_tax_rate) ||
-        0,
-      state_tax_rate:
-        (bodyshop.bill_tax_rates && bodyshop.bill_tax_rates.state_tax_rate) ||
-        0,
-      local_tax_rate:
-        (bodyshop.bill_tax_rates && bodyshop.bill_tax_rates.local_tax_rate) ||
-        0,
-    };
-  }, [billEnterModal, bodyshop]);
-
   useEffect(() => {
     if (billEnterModal.visible) {
       form.setFieldsValue(formValues);
@@ -225,7 +251,10 @@ function BillEnterModalContainer({
       keyboard="false"
       onOk={() => form.submit()}
       onCancel={handleCancel}
-      afterClose={() => form.resetFields()}
+      afterClose={() => {
+        form.resetFields();
+        setLoading(false);
+      }}
       footer={
         <Space>
           <Button onClick={handleCancel}>{t("general.actions.cancel")}</Button>

client/src/components/bill-form/bill-form.component.jsx

@@ -1,6 +1,8 @@
-import { UploadOutlined } from "@ant-design/icons";
+import Icon, { UploadOutlined } from "@ant-design/icons";
 import { useApolloClient } from "@apollo/client";
+import { MdOpenInNew } from "react-icons/md";
 import {
+  Alert,
   Divider,
   Form,
   Input,
@@ -13,6 +15,7 @@ import {
 import React, { useEffect, useState } from "react";
 import { useTranslation } from "react-i18next";
 import { connect } from "react-redux";
+import { Link } from "react-router-dom";
 import { createStructuredSelector } from "reselect";
 import { CHECK_BILL_INVOICE_NUMBER } from "../../graphql/bills.queries";
 import { selectBodyshop } from "../../redux/user/user.selectors";
@@ -132,6 +135,30 @@ export function BillFormComponent({
           />
         </Form.Item>
       </LayoutFormRow>
+      {job &&
+        job.ious &&
+        job.ious.length > 0 &&
+        job.ious.map((iou) => (
+          <Alert
+            key={iou.id}
+            type="warning"
+            message={
+              <Space>
+                {t("bills.labels.iouexists")}
+                <Link
+                  target="_blank"
+                  rel="noopener noreferrer"
+                  to={`/manage/jobs/${iou.id}?tab=repairdata`}
+                >
+                  <Space>
+                    {iou.ro_number}
+                    <Icon component={MdOpenInNew} />
+                  </Space>
+                </Link>
+              </Space>
+            }
+          />
+        ))}
       <LayoutFormRow>
         <Form.Item
           label={t("bills.fields.invoice_number")}
@@ -337,6 +364,7 @@ export function BillFormComponent({
         responsibilityCenters={responsibilityCenters}
         disabled={disabled}
       />
+
       <Form.Item
         name="upload"
         label="Upload"

client/src/components/bill-form/bill-form.lines.component.jsx

@@ -7,13 +7,14 @@ import {
   Select,
   Space,
   Switch,
-  Table,
+  Table
 } from "antd";
 import React from "react";
 import { useTranslation } from "react-i18next";
 import { connect } from "react-redux";
 import { createStructuredSelector } from "reselect";
 import { selectBodyshop } from "../../redux/user/user.selectors";
+import CiecaSelect from "../../utils/Ciecaselect";
 import BillLineSearchSelect from "../bill-line-search-select/bill-line-search-select.component";
 import CurrencyInput from "../form-items-formatted/currency-form-item.component";
 
@@ -72,9 +73,13 @@ export function BillEnterModalLinesComponent({
                         quantity: opt.part_qty || 1,
                         actual_price: opt.cost,
                         cost_center: opt.part_type
-                          ? responsibilityCenters.defaults.costs[
-                              opt.part_type
-                            ] || null
+                          ? bodyshop.pbs_serialnumber || bodyshop.cdk_dealerid
+                            ? opt.part_type
+                            : responsibilityCenters.defaults &&
+                              (responsibilityCenters.defaults.costs[
+                                opt.part_type
+                              ] ||
+                                null)
                           : null,
                       };
                     }
@@ -154,18 +159,7 @@ export function BillEnterModalLinesComponent({
               setFieldsValue({
                 billlines: getFieldsValue("billlines").billlines.map(
                   (item, idx) => {
-                    console.log("Checking", index, idx);
                     if (idx === index) {
-                      console.log(
-                        "Found and setting.",
-                        !!item.actual_cost
-                          ? item.actual_cost
-                          : Math.round(
-                              (parseFloat(e.target.value) * (1 - discount) +
-                                Number.EPSILON) *
-                                100
-                            ) / 100
-                      );
                       return {
                         ...item,
                         actual_cost: !!item.actual_cost
@@ -233,6 +227,7 @@ export function BillEnterModalLinesComponent({
             key: `${field.index}cost_center`,
             name: [field.name, "cost_center"],
             label: t("billlines.fields.cost_center"),
+            valuePropName: "value",
             rules: [
               {
                 required: true,
@@ -242,10 +237,12 @@ export function BillEnterModalLinesComponent({
           };
         },
         formInput: (record, index) => (
-          <Select style={{ minWidth: "3rem" }} disabled={disabled}>
-            {responsibilityCenters.costs.map((item) => (
-              <Select.Option key={item.name}>{item.name}</Select.Option>
-            ))}
+          <Select showSearch style={{ minWidth: "3rem" }} disabled={disabled}>
+            {bodyshop.cdk_dealerid || bodyshop.pbs_serialnumber
+              ? CiecaSelect(true, false)
+              : responsibilityCenters.costs.map((item) => (
+                  <Select.Option key={item.name}>{item.name}</Select.Option>
+                ))}
           </Select>
         ),
       },
@@ -500,9 +497,9 @@ const EditableCell = ({
             labelCol={{ span: 0 }}
             {...(formItemProps && formItemProps(record))}
           >
-            {(formInput && formInput(record, record.key)) || children}
+            {(formInput && formInput(record, record.name)) || children}
           </Form.Item>
-          {additional && additional(record, record.key)}
+          {additional && additional(record, record.name)}
         </Space>
       </td>
     );
@@ -514,7 +511,7 @@ const EditableCell = ({
         name={dataIndex}
         {...(formItemProps && formItemProps(record))}
       >
-        {(formInput && formInput(record, record.key)) || children}
+        {(formInput && formInput(record, record.name)) || children}
       </Form.Item>
     </td>
   );

client/src/components/bill-form/bill-form.totals.utility.js

@@ -1,13 +1,8 @@
 import Dinero from "dinero.js";
 
 export const CalculateBillTotal = (invoice) => {
-  const {
-    total,
-    billlines,
-    federal_tax_rate,
-    local_tax_rate,
-    state_tax_rate,
-  } = invoice;
+  const { total, billlines, federal_tax_rate, local_tax_rate, state_tax_rate } =
+    invoice;
 
   //TODO Determine why this recalculates so many times.
   let subtotal = Dinero({ amount: 0 });
@@ -20,8 +15,7 @@ export const CalculateBillTotal = (invoice) => {
   billlines.forEach((i) => {
     if (!!i) {
       const itemTotal = Dinero({
-        amount:
-          Math.round(((i.actual_cost || 0) * 100 + Number.EPSILON) * 100) / 100,
+        amount: Math.round((i.actual_cost || 0) * 100),
       }).multiply(i.quantity || 1);
 
       subtotal = subtotal.add(itemTotal);

client/src/components/bill-line-search-select/bill-line-search-select.component.jsx

@@ -12,7 +12,18 @@ const BillLineSearchSelect = ({ options, disabled, ...restProps }, ref) => {
       disabled={disabled}
       ref={ref}
       showSearch
-      optionFilterProp="line_desc"
+      //  optionFilterProp="line_desc"
+      filterOption={(inputValue, option) => {
+        return (
+          (option.line_desc &&
+            option.line_desc
+              .toLowerCase()
+              .includes(inputValue.toLowerCase())) ||
+          (option.oem_partno &&
+            option.oem_partno.toLowerCase().includes(inputValue.toLowerCase()))
+        );
+      }}
+      notFoundContent={"Removed."}
       {...restProps}
     >
       <Select.Option key={null} value={"noline"} cost={0} line_desc={""}>
@@ -21,14 +32,19 @@ const BillLineSearchSelect = ({ options, disabled, ...restProps }, ref) => {
       {options
         ? options.map((item) => (
             <Option
+              disabled={item.removed}
               key={item.id}
               value={item.id}
               cost={item.act_price ? item.act_price : 0}
               part_type={item.part_type}
               line_desc={item.line_desc}
               part_qty={item.part_qty}
+              oem_partno={item.oem_partno}
+              style={{
+                ...(item.removed ? { textDecoration: "line-through" } : {}),
+              }}
             >
-              {`${item.line_desc}${
+              {`${item.removed ? `(REMOVED) ` : ""}${item.line_desc}${
                 item.oem_partno ? ` - ${item.oem_partno}` : ""
               }`}
             </Option>

client/src/components/bills-list-table/bills-list-table.component.jsx

@@ -5,6 +5,7 @@ import { useTranslation } from "react-i18next";
 import { connect } from "react-redux";
 import { createStructuredSelector } from "reselect";
 import { setModalContext } from "../../redux/modals/modals.actions";
+import { selectBodyshop } from "../../redux/user/user.selectors";
 import CurrencyFormatter from "../../utils/CurrencyFormatter";
 import { DateFormatter } from "../../utils/DateFormatter";
 import { alphaSort, dateSort } from "../../utils/sorters";
@@ -14,6 +15,7 @@ import PrintWrapperComponent from "../print-wrapper/print-wrapper.component";
 
 const mapStateToProps = createStructuredSelector({
   //jobRO: selectJobReadOnly,
+  bodyshop: selectBodyshop,
 });
 
 const mapDispatchToProps = (dispatch) => ({
@@ -26,6 +28,7 @@ const mapDispatchToProps = (dispatch) => ({
 });
 
 export function BillsListTableComponent({
+  bodyshop,
   job,
   billsQuery,
   handleOnRowClick,
@@ -52,7 +55,9 @@ export function BillsListTableComponent({
       )}
       <BillDeleteButton bill={record} />
       <Button
-        disabled={record.is_credit_memo}
+        disabled={
+          record.is_credit_memo || record.vendorid === bodyshop.inhousevendorid
+        }
         onClick={() =>
           setPartsOrderContext({
             actions: {},

client/src/components/chat-conversation-list/chat-conversation-list.component.jsx

@@ -8,6 +8,7 @@ import { selectSelectedConversation } from "../../redux/messaging/messaging.sele
 import PhoneFormatter from "../../utils/PhoneFormatter";
 import "./chat-conversation-list.styles.scss";
 import { useTranslation } from "react-i18next";
+import { TimeAgoFormatter } from "../../utils/DateFormatter";
 
 const mapStateToProps = createStructuredSelector({
   selectedConversation: selectSelectedConversation,
@@ -60,13 +61,18 @@ export function ChatConversationListComponent({
             ) : (
               <PhoneFormatter>{item.phone_num}</PhoneFormatter>
             )}
-            {item.job_conversations.length > 0
-              ? item.job_conversations.map((j, idx) => (
-                  <Tag key={idx} className="ro-number-tag">
-                    {j.job.ro_number}
-                  </Tag>
-                ))
-              : null}
+            <div sryle={{ display: "inline-block" }}>
+              <div>
+                {item.job_conversations.length > 0
+                  ? item.job_conversations.map((j, idx) => (
+                      <Tag key={idx} className="ro-number-tag">
+                        {j.job.ro_number}
+                      </Tag>
+                    ))
+                  : null}
+              </div>
+              <TimeAgoFormatter>{item.updated_at}</TimeAgoFormatter>
+            </div>
             <Badge count={item.messages_aggregate.aggregate.count || 0} />
           </List.Item>
         )}

client/src/components/chat-messages-list/chat-message-list.component.jsx

@@ -1,4 +1,5 @@
 import Icon from "@ant-design/icons";
+import { Tooltip } from "antd";
 import i18n from "i18next";
 import moment from "moment";
 import React, { useEffect, useRef } from "react";
@@ -9,6 +10,7 @@ import {
   CellMeasurerCache,
   List,
 } from "react-virtualized";
+import { DateTimeFormatter } from "../../utils/DateFormatter";
 import "./chat-message-list.styles.scss";
 
 export default function ChatMessageListComponent({ messages }) {
@@ -85,17 +87,22 @@ export default function ChatMessageListComponent({ messages }) {
 
 const MessageRender = (message) => {
   return (
-    <div>
-      {message.image_path &&
-        message.image_path.map((i, idx) => (
-          <div key={idx} style={{ display: "flex", justifyContent: "center" }}>
-            <a href={i} target="__blank">
-              <img alt="Received" className="message-img" src={i} />
-            </a>
-          </div>
-        ))}
-      <div>{message.text}</div>
-    </div>
+    <Tooltip title={DateTimeFormatter({ children: message.created_at })}>
+      <div>
+        {message.image_path &&
+          message.image_path.map((i, idx) => (
+            <div
+              key={idx}
+              style={{ display: "flex", justifyContent: "center" }}
+            >
+              <a href={i} target="__blank">
+                <img alt="Received" className="message-img" src={i} />
+              </a>
+            </div>
+          ))}
+        <div>{message.text}</div>
+      </div>
+    </Tooltip>
   );
 };
 

client/src/components/chat-new-conversation/chat-new-conversation.component.jsx

@@ -20,7 +20,6 @@ export function ChatNewConversation({ openChatByPhone }) {
   const { t } = useTranslation();
   const [form] = Form.useForm();
   const handleFinish = (values) => {
-    console.log("values :>> ", values);
     openChatByPhone({ phone_num: values.phoneNumber });
     form.resetFields();
   };

client/src/components/chat-popup/chat-popup.component.jsx

@@ -1,5 +1,5 @@
-import { ShrinkOutlined } from "@ant-design/icons";
-import { Col, Row, Typography } from "antd";
+import { ShrinkOutlined, InfoCircleOutlined } from "@ant-design/icons";
+import { Col, Row, Tooltip, Typography } from "antd";
 import React from "react";
 import { useTranslation } from "react-i18next";
 import { connect } from "react-redux";
@@ -31,6 +31,9 @@ export function ChatPopupComponent({
           {t("messaging.labels.messaging")}
         </Typography.Title>
         <ChatNewConversation />
+        <Tooltip title={t("messaging.labels.recentonly")}>
+          <InfoCircleOutlined />
+        </Tooltip>
       </div>
       <ShrinkOutlined
         onClick={() => toggleChatVisible()}

client/src/components/contract-convert-to-ro/contract-convert-to-ro.component.jsx

@@ -53,6 +53,7 @@ export function ContractConvertToRo({
     const billingLines = [];
     if (contractLength > 0)
       billingLines.push({
+        manual_line:true,
         unq_seq: 1,
         line_no: 1,
         line_ref: 1,
@@ -70,6 +71,7 @@ export function ContractConvertToRo({
       contract.kmend - contract.kmstart - contract.dailyfreekm * contractLength;
     if (mileageDiff > 0) {
       billingLines.push({
+        manual_line:true,
         unq_seq: 2,
         line_no: 2,
         line_ref: 2,
@@ -86,6 +88,7 @@ export function ContractConvertToRo({
 
     if (values.refuelqty > 0) {
       billingLines.push({
+        manual_line:true,
         unq_seq: 3,
         line_no: 3,
         line_ref: 3,
@@ -101,6 +104,7 @@ export function ContractConvertToRo({
     }
     if (values.applyCleanupCharge) {
       billingLines.push({
+        manual_line:true,
         unq_seq: 4,
         line_no: 4,
         line_ref: 4,
@@ -117,6 +121,7 @@ export function ContractConvertToRo({
     if (contract.damagewaiver) {
       //Add for cleanup fee.
       billingLines.push({
+        manual_line:true,
         unq_seq: 5,
         line_no: 5,
         line_ref: 5,

client/src/components/contract-form/contract-form.component.jsx

@@ -42,7 +42,6 @@ export default function ContractFormComponent({
             <ContractStatusSelector />
           </Form.Item>
         )}
-
         <Form.Item
           label={t("contracts.fields.start")}
           name="start"

client/src/components/contracts-list/contracts-list.component.jsx

@@ -83,8 +83,10 @@ export function ContractsList({
       render: (text, record) => (
         <Link to={`/manage/courtesycars/${record.courtesycar.id}`}>{`${
           record.courtesycar.year
-        } ${record.courtesycar.make} ${record.courtesycar.model} ${
-          record.courtesycar.plate ? `(${record.courtesycar.plate})` : ""
+        } ${record.courtesycar.make} ${record.courtesycar.model}${
+          record.courtesycar.plate ? ` (${record.courtesycar.plate})` : ""
+        }${
+          record.courtesycar.fleetnumber ? ` (${record.courtesycar.fleetnumber})` : ""
         }`}</Link>
       ),
     },

client/src/components/courtesy-car-status-select/courtesy-car-status-select.component.jsx

@@ -31,6 +31,9 @@ const CourtesyCarStatusComponent = ({ value, onChange }, ref) => {
       <Option value="courtesycars.status.out">
         {t("courtesycars.status.out")}
       </Option>
+      <Option value="courtesycars.status.sold">
+        {t("courtesycars.status.sold")}
+      </Option>
     </Select>
   );
 };

client/src/components/courtesy-cars-list/courtesy-cars-list.component.jsx

@@ -45,6 +45,10 @@ export default function CourtesyCarsList({ loading, courtesycars, refetch }) {
           text: t("courtesycars.status.out"),
           value: "courtesycars.status.out",
         },
+        {
+          text: t("courtesycars.status.sold"),
+          value: "courtesycars.status.sold",
+        },
       ],
       onFilter: (value, record) => value.includes(record.status),
       sortOrder:

client/src/components/dashboard-components/monthly-revenue-graph/monthly-revenue-graph.component.jsx

@@ -34,7 +34,9 @@ export default function DashboardMonthlyRevenueGraph({ data, ...cardProps }) {
     let dailySales;
     if (!!jobsByDate[val]) {
       dailySales = jobsByDate[val].reduce((dayAcc, dayVal) => {
-        return dayAcc.add(Dinero(dayVal.job_totals.totals.subtotal));
+        return dayAcc.add(
+          Dinero((dayVal.job_totals && dayVal.job_totals.totals.subtotal) || 0)
+        );
       }, Dinero());
     } else {
       dailySales = Dinero();

client/src/components/dashboard-components/pojected-monthly-sales/projected-monthly-sales.component.jsx

@@ -13,7 +13,14 @@ export default function DashboardProjectedMonthlySales({ data, ...cardProps }) {
   const dollars =
     data.projected_monthly_sales &&
     data.projected_monthly_sales.reduce(
-      (acc, val) => acc.add(Dinero(val.job_totals.totals.subtotal)),
+      (acc, val) =>
+        acc.add(
+          Dinero(
+            val.job_totals &&
+              val.job_totals.totals &&
+              val.job_totals.totals.subtotal
+          )
+        ),
       Dinero()
     );
   return (

client/src/components/dashboard-components/total-production-dollars/total-production-dollars.component.jsx

@@ -14,7 +14,8 @@ export default function DashboardTotalProductionDollars({
   const dollars =
     data.production_jobs &&
     data.production_jobs.reduce(
-      (acc, val) => acc.add(Dinero(val.job_totals.totals.subtotal)),
+      (acc, val) =>
+        acc.add(Dinero(val.job_totals && val.job_totals.totals.subtotal)),
       Dinero()
     );
 

client/src/components/dashboard-grid/dashboard-grid.component.jsx

@@ -86,10 +86,7 @@ export function DashboardGridComponent({ currentUser, bodyshop }) {
   const handleRemoveComponent = (key) => {
     logImEXEvent("dashboard_remove_component", { name: key });
     const idxToRemove = state.items.findIndex((i) => i.i === key);
-    console.log(
-      "🚀  ~ file: dashboard-grid.component.jsx  ~ line 81  ~ idxToRemove",
-      idxToRemove
-    );
+
     const items = _.cloneDeep(state.items);
 
     items.splice(idxToRemove, 1);
@@ -244,7 +241,7 @@ const componentList = {
     h: 3,
   },
   MonthlyPartsSales: {
-    label: i18next.t("dashboard.titles.productiondollars"),
+    label: i18next.t("dashboard.titles.monthlypartssales"),
     component: DashboardMonthlyPartsSales,
     gqlFragment: null,
     minW: 2,
@@ -253,7 +250,7 @@ const componentList = {
     h: 2,
   },
   MonthlyLaborSales: {
-    label: i18next.t("dashboard.titles.monthlypartssales"),
+    label: i18next.t("dashboard.titles.monthlylaborsales"),
     component: DashboardMonthlyLaborSales,
     gqlFragment: null,
     minW: 2,

client/src/components/dms-allocations-summary/dms-allocations-summary.component.jsx

@@ -0,0 +1,138 @@
+import { Button, Card, Table, Typography } from "antd";
+import React, { useState, useEffect } from "react";
+import { useTranslation } from "react-i18next";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { selectBodyshop } from "../../redux/user/user.selectors";
+import Dinero from "dinero.js";
+import { SyncOutlined } from "@ant-design/icons";
+
+const mapStateToProps = createStructuredSelector({
+  //currentUser: selectCurrentUser
+  bodyshop: selectBodyshop,
+});
+
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(DmsAllocationsSummary);
+
+export function DmsAllocationsSummary({ socket, bodyshop, jobId, title }) {
+  const { t } = useTranslation();
+  const [allocationsSummary, setAllocationsSummary] = useState([]);
+
+  useEffect(() => {
+    if (socket.connected) {
+      socket.emit("cdk-calculate-allocations", jobId, (ack) => {
+        setAllocationsSummary(ack);
+        socket.allocationsSummary = ack;
+      });
+    }
+  }, [socket, socket.connected, jobId]);
+
+  const columns = [
+    {
+      title: t("jobs.fields.dms.center"),
+      dataIndex: "center",
+      key: "center",
+    },
+    {
+      title: t("jobs.fields.dms.sale"),
+      dataIndex: "sale",
+      key: "sale",
+      render: (text, record) => Dinero(record.sale).toFormat(),
+    },
+    {
+      title: t("jobs.fields.dms.cost"),
+      dataIndex: "cost",
+      key: "cost",
+      render: (text, record) => Dinero(record.cost).toFormat(),
+    },
+    {
+      title: t("jobs.fields.dms.sale_dms_acctnumber"),
+      dataIndex: "sale_dms_acctnumber",
+      key: "sale_dms_acctnumber",
+      render: (text, record) =>
+        record.profitCenter && record.profitCenter.dms_acctnumber,
+    },
+    {
+      title: t("jobs.fields.dms.cost_dms_acctnumber"),
+      dataIndex: "cost_dms_acctnumber",
+      key: "cost_dms_acctnumber",
+      render: (text, record) =>
+        record.costCenter && record.costCenter.dms_acctnumber,
+    },
+    {
+      title: t("jobs.fields.dms.dms_wip_acctnumber"),
+      dataIndex: "dms_wip_acctnumber",
+      key: "dms_wip_acctnumber",
+      render: (text, record) =>
+        record.costCenter && record.costCenter.dms_wip_acctnumber,
+    },
+  ];
+
+  return (
+    <Card
+      title={title}
+      extra={
+        <Button
+          onClick={() => {
+            socket.emit("cdk-calculate-allocations", jobId, (ack) =>
+              setAllocationsSummary(ack)
+            );
+          }}
+        >
+          <SyncOutlined />
+        </Button>
+      }
+    >
+      <Table
+        pagination={{ position: "top", defaultPageSize: 50 }}
+        columns={columns}
+        rowKey="center"
+        dataSource={allocationsSummary}
+        locale={{ emptyText: t("dms.labels.refreshallocations") }}
+        summary={() => {
+          const totals =
+            allocationsSummary &&
+            allocationsSummary.reduce(
+              (acc, val) => {
+                return {
+                  totalSale: acc.totalSale.add(Dinero(val.sale)),
+                  totalCost: acc.totalCost.add(Dinero(val.cost)),
+                };
+              },
+              {
+                totalSale: Dinero(),
+                totalCost: Dinero(),
+              }
+            );
+
+          return (
+            <Table.Summary.Row>
+              <Table.Summary.Cell>
+                <Typography.Title level={4}>
+                  {t("general.labels.totals")}
+                </Typography.Title>
+              </Table.Summary.Cell>
+              <Table.Summary.Cell>
+                {totals && totals.totalSale.toFormat()}
+              </Table.Summary.Cell>
+              <Table.Summary.Cell>
+                {
+                  //  totals.totalCost.toFormat()
+                }
+              </Table.Summary.Cell>
+              <Table.Summary.Cell></Table.Summary.Cell>
+              <Table.Summary.Cell></Table.Summary.Cell>
+            </Table.Summary.Row>
+          );
+        }}
+      />
+    </Card>
+  );
+}

client/src/components/dms-cdk-makes/dms-cdk-makes.component.jsx

@@ -0,0 +1,105 @@
+import { useLazyQuery } from "@apollo/client";
+import { Button, Input, Modal, Table } from "antd";
+import React, { useState } from "react";
+import { useTranslation } from "react-i18next";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { SEARCH_DMS_VEHICLES } from "../../graphql/dms.queries";
+import { selectBodyshop } from "../../redux/user/user.selectors";
+import AlertComponent from "../alert/alert.component";
+
+const mapStateToProps = createStructuredSelector({
+  //currentUser: selectCurrentUser
+  bodyshop: selectBodyshop,
+});
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+export default connect(mapStateToProps, mapDispatchToProps)(DmsCdkVehicles);
+
+export function DmsCdkVehicles({ bodyshop, form, socket, job }) {
+  const [visible, setVisible] = useState(false);
+  const [selectedModel, setSelectedModel] = useState(null);
+  const { t } = useTranslation();
+
+  const [callSearch, { loading, error, data }] =
+    useLazyQuery(SEARCH_DMS_VEHICLES);
+  const columns = [
+    {
+      title: t("vehicles.fields.v_make_desc"),
+      dataIndex: "make",
+      key: "make",
+    },
+    {
+      title: t("vehicles.fields.v_model_desc"),
+      dataIndex: "model",
+      key: "model",
+    },
+    {
+      title: t("jobs.fields.dms.dms_make"),
+      dataIndex: "makecode",
+      key: "makecode",
+    },
+    {
+      title: t("jobs.fields.dms.dms_model"),
+      dataIndex: "modelcode",
+      key: "modelcode",
+    },
+  ];
+
+  return (
+    <>
+      <Modal
+        width={"90%"}
+        visible={visible}
+        onCancel={() => setVisible(false)}
+        onOk={() => {
+          form.setFieldsValue({
+            dms_make: selectedModel.makecode,
+            dms_model: selectedModel.modelcode,
+          });
+          setVisible(false);
+        }}
+      >
+        {error && <AlertComponent error={error.message} />}
+        <Table
+          title={() => (
+            <Input.Search
+              onSearch={(val) => callSearch({ variables: { search: val } })}
+              placeholder={t("general.labels.search")}
+            />
+          )}
+          columns={columns}
+          loading={loading}
+          rowKey="id"
+          dataSource={data ? data.search_dms_vehicles : []}
+          onRow={(record) => {
+            return {
+              onClick: () => setSelectedModel(record),
+            };
+          }}
+          rowSelection={{
+            onSelect: (record) => {
+              setSelectedModel(record);
+            },
+
+            type: "radio",
+            selectedRowKeys: [selectedModel && selectedModel.id],
+          }}
+        />
+      </Modal>
+      <Button
+        onClick={() => {
+          setVisible(true);
+          callSearch({
+            variables: {
+              search: job && job.v_model_desc && job.v_model_desc.substr(0, 3),
+            },
+          });
+        }}
+      >
+        {t("jobs.actions.dms.findmakemodelcode")}
+      </Button>
+    </>
+  );
+}

client/src/components/dms-cdk-makes/dms-cdk-makes.refetch.component.jsx

@@ -0,0 +1,40 @@
+import { Button } from "antd";
+import axios from "axios";
+import React, { useState } from "react";
+import { useTranslation } from "react-i18next";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import {
+  selectBodyshop,
+  selectCurrentUser,
+} from "../../redux/user/user.selectors";
+const mapStateToProps = createStructuredSelector({
+  currentUser: selectCurrentUser,
+  bodyshop: selectBodyshop,
+});
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+export default connect(mapStateToProps, mapDispatchToProps)(DmsCdkMakesRefetch);
+
+export function DmsCdkMakesRefetch({ currentUser, bodyshop, form, socket }) {
+  const [loading, setLoading] = useState(false);
+  const { t } = useTranslation();
+
+  if (!currentUser.email.includes("@imex.")) return null;
+
+  const handleRefetch = async () => {
+    setLoading(true);
+    await axios.post("/cdk/getvehicles", {
+      cdk_dealerid: bodyshop.cdk_dealerid,
+      bodyshopid: bodyshop.id,
+    });
+
+    setLoading(false);
+  };
+  return (
+    <Button loading={loading} onClick={handleRefetch}>
+      {t("jobs.actions.dms.refetchmakesmodels")}
+    </Button>
+  );
+}

client/src/components/dms-customer-selector/dms-customer-selector.component.jsx

@@ -1,77 +1,161 @@
-import { Button, Table } from "antd";
+import { Button, Table, Col, Checkbox } from "antd";
 import React, { useState } from "react";
 import { useTranslation } from "react-i18next";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
 import { socket } from "../../pages/dms/dms.container";
-import PhoneFormatter from "../../utils/PhoneFormatter";
+import { selectBodyshop } from "../../redux/user/user.selectors";
 import { alphaSort } from "../../utils/sorters";
-export default function DmsCustomerSelector() {
+
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(DmsCustomerSelector);
+
+export function DmsCustomerSelector({ bodyshop }) {
   const { t } = useTranslation();
   const [customerList, setcustomerList] = useState([]);
   const [visible, setVisible] = useState(false);
   const [selectedCustomer, setSelectedCustomer] = useState(null);
+  const [dmsType, setDmsType] = useState("cdk");
 
   socket.on("cdk-select-customer", (customerList, callback) => {
     setVisible(true);
+    setDmsType("cdk");
+    setcustomerList(customerList);
+  });
+  socket.on("pbs-select-customer", (customerList, callback) => {
+    setVisible(true);
+    setDmsType("pbs");
     setcustomerList(customerList);
   });
 
-  const onOk = () => {
+  const onUseSelected = () => {
     setVisible(false);
-    socket.emit("cdk-selected-customer", selectedCustomer);
+    socket.emit(`${dmsType}-selected-customer`, selectedCustomer);
+    setSelectedCustomer(null);
   };
 
-  const columns = [
+  const onUseGeneric = () => {
+    setVisible(false);
+    socket.emit(
+      `${dmsType}selected-customer`,
+      bodyshop.cdk_configuration.generic_customer_number
+    );
+    setSelectedCustomer(null);
+  };
+
+  const onCreateNew = () => {
+    setVisible(false);
+    socket.emit(`${dmsType}-selected-customer`, null);
+    setSelectedCustomer(null);
+  };
+
+  const cdkColumns = [
     {
-      title: t("dms.fields.name1"),
+      title: t("jobs.fields.dms.id"),
+      dataIndex: ["id", "value"],
+      key: "id",
+    },
+    {
+      title: t("jobs.fields.dms.vinowner"),
+      dataIndex: "vinOwner",
+      key: "vinOwner",
+      render: (text, record) => <Checkbox disabled checked={record.vinOwner} />,
+    },
+    {
+      title: t("jobs.fields.dms.name1"),
       dataIndex: ["name1", "fullName"],
       key: "name1",
-      sorter: (a, b) => alphaSort(a.name1?.fullName, b.name1?.fullName),
+      sorter: (a, b) =>
+        alphaSort(a.name1 && a.name1.fullName, b.name1 && b.name1.fullName),
     },
+
     {
-      title: t("dms.fields.name2"),
-      dataIndex: ["name2", "fullName"],
-      key: "name2",
-      sorter: (a, b) => alphaSort(a.name2?.fullName, b.name2?.fullName),
-    },
-    {
-      title: t("dms.fields.phone"),
-      dataIndex: ["contactInfo", "mainTelephoneNumber", "value"],
-      key: "phone",
-      render: (record, value) => (
-        <PhoneFormatter>
-          {record.contactInfo?.mainTelephoneNumber?.value}
-        </PhoneFormatter>
-      ),
-    },
-    {
-      title: t("dms.fields.address"),
+      title: t("jobs.fields.dms.address"),
       //dataIndex: ["name2", "fullName"],
       key: "address",
       render: (record, value) =>
-        `${record.address?.addressLine[0]}, ${record.address?.city} ${record.address?.stateOrProvince} ${record.address?.postalCode}`,
+        `${
+          record.address &&
+          record.address.addressLine &&
+          record.address.addressLine[0]
+        }, ${record.address && record.address.city} ${
+          record.address && record.address.stateOrProvince
+        } ${record.address && record.address.postalCode}`,
     },
   ];
 
-  if (!visible) return <></>;
+  const pbsColumns = [
+    {
+      title: t("jobs.fields.dms.id"),
+      dataIndex: "ContactId",
+      key: "ContactId",
+    },
+    {
+      title: t("jobs.fields.dms.name1"),
+      key: "name1",
+      sorter: (a, b) => alphaSort(a.LastName, b.LastName),
+      render: (text, record) =>
+        `${record.FirstName || ""} ${record.LastName || ""}`,
+    },
+
+    {
+      title: t("jobs.fields.dms.address"),
+      key: "address",
+      render: (record, value) =>
+        `${record.Address}, ${record.City} ${record.State} ${record.ZipCode}`,
+    },
+  ];
+
+  if (!visible) return null;
   return (
-    <Table
-      title={() => (
-        <div>
-          <Button onClick={onOk}>Select</Button>
-        </div>
-      )}
-      pagination={{ position: "top" }}
-      columns={columns}
-      rowKey={(record) => record.id.value}
-      dataSource={customerList}
-      //onChange={handleTableChange}
-      rowSelection={{
-        onSelect: (props) => {
-          setSelectedCustomer(props.id.value);
-        },
-        type: "radio",
-        selectedRowKeys: [selectedCustomer],
-      }}
-    />
+    <Col span={24}>
+      <Table
+        title={() => (
+          <div>
+            <Button onClick={onUseSelected} disabled={!selectedCustomer}>
+              {t("jobs.actions.dms.useselected")}
+            </Button>
+            <Button
+              onClick={onUseGeneric}
+              disabled={
+                !(
+                  bodyshop.cdk_configuration &&
+                  bodyshop.cdk_configuration.generic_customer_number
+                )
+              }
+            >
+              {t("jobs.actions.dms.usegeneric")}
+            </Button>
+            <Button onClick={onCreateNew}>
+              {t("jobs.actions.dms.createnewcustomer")}
+            </Button>
+          </div>
+        )}
+        pagination={{ position: "top" }}
+        columns={dmsType === "cdk" ? cdkColumns : pbsColumns}
+        rowKey={(record) =>
+          dmsType === "cdk" ? record.id.value : record.ContactId
+        }
+        dataSource={customerList}
+        //onChange={handleTableChange}
+        rowSelection={{
+          onSelect: (record) => {
+            setSelectedCustomer(
+              dmsType === "cdk" ? record.id.value : record.ContactId
+            );
+          },
+          type: "radio",
+          selectedRowKeys: [selectedCustomer],
+        }}
+      />
+    </Col>
   );
 }

client/src/components/dms-log-events/dms-log-events.component.jsx

@@ -0,0 +1,57 @@
+import { Divider, Space, Tag, Timeline } from "antd";
+import moment from "moment";
+import React from "react";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import {
+  setBreadcrumbs,
+  setSelectedHeader,
+} from "../../redux/application/application.actions";
+import { selectBodyshop } from "../../redux/user/user.selectors";
+
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
+
+const mapDispatchToProps = (dispatch) => ({
+  setBreadcrumbs: (breadcrumbs) => dispatch(setBreadcrumbs(breadcrumbs)),
+  setSelectedHeader: (key) => dispatch(setSelectedHeader(key)),
+});
+
+export default connect(mapStateToProps, mapDispatchToProps)(DmsLogEvents);
+
+export function DmsLogEvents({ socket, logs, bodyshop }) {
+  return (
+    <Timeline pending
+    reverse={true}
+    >
+      {logs.map((log, idx) => (
+        <Timeline.Item key={idx} color={LogLevelHierarchy(log.level)}>
+          <Space wrap align="start" style={{}}>
+            <Tag color={LogLevelHierarchy(log.level)}>{log.level}</Tag>
+            <span>{moment(log.timestamp).format("MM/DD/YYYY HH:mm:ss")}</span>
+            <Divider type="vertical" />
+            <span>{log.message}</span>
+          </Space>
+        </Timeline.Item>
+      ))}
+    </Timeline>
+  );
+}
+
+function LogLevelHierarchy(level) {
+  switch (level) {
+    case "TRACE":
+      return "pink";
+    case "DEBUG":
+      return "orange";
+    case "INFO":
+      return "blue";
+    case "WARNING":
+      return "yellow";
+    case "ERROR":
+      return "red";
+    default:
+      return 0;
+  }
+}

client/src/components/dms-post-form/dms-post-form.component.jsx

@@ -0,0 +1,395 @@
+import { DeleteFilled, DownOutlined } from "@ant-design/icons";
+import {
+  Button,
+  Card,
+  Divider,
+  Dropdown,
+  Form,
+  Input,
+  InputNumber,
+  Menu,
+  Select,
+  Space,
+  Statistic,
+  Typography,
+} from "antd";
+import Dinero from "dinero.js";
+import React from "react";
+import { useTranslation } from "react-i18next";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { determineDmsType } from "../../pages/dms/dms.container";
+import { selectBodyshop } from "../../redux/user/user.selectors";
+import DmsCdkMakes from "../dms-cdk-makes/dms-cdk-makes.component";
+import DmsCdkMakesRefetch from "../dms-cdk-makes/dms-cdk-makes.refetch.component";
+import CurrencyInput from "../form-items-formatted/currency-form-item.component";
+import LayoutFormRow from "../layout-form-row/layout-form-row.component";
+
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+export default connect(mapStateToProps, mapDispatchToProps)(DmsPostForm);
+
+export function DmsPostForm({ bodyshop, socket, job, logsRef }) {
+  const [form] = Form.useForm();
+  const { t } = useTranslation();
+
+  const handlePayerSelect = (value, index) => {
+    form.setFieldsValue({
+      payers: form.getFieldValue("payers").map((payer, mapIndex) => {
+        if (index !== mapIndex) return payer;
+        const cdkPayer =
+          bodyshop.cdk_configuration.payers &&
+          bodyshop.cdk_configuration.payers.find((i) => i.name === value);
+
+        if (!cdkPayer) return payer;
+
+        return {
+          ...cdkPayer,
+          dms_acctnumber: cdkPayer.dms_acctnumber,
+          controlnumber: job && job[cdkPayer.control_type],
+        };
+      }),
+    });
+  };
+
+  const handleFinish = (values) => {
+    socket.emit(`${determineDmsType(bodyshop)}-export-job`, {
+      jobid: job.id,
+      txEnvelope: values,
+    });
+    console.log(logsRef);
+    if (logsRef) {
+      console.log("executing", logsRef);
+      logsRef.curent &&
+        logsRef.current.scrollIntoView({
+          behavior: "smooth",
+        });
+    }
+  };
+
+  return (
+    <Card title={t("jobs.labels.dms.postingform")}>
+      <Form
+        form={form}
+        layout="vertical"
+        onFinish={handleFinish}
+        initialValues={{
+          story: t("jobs.labels.dms.defaultstory", {
+            ro_number: job.ro_number,
+            area_of_damage: job.area_of_damage && job.area_of_damage.impact1,
+          }).substr(0, 239),
+        }}
+      >
+        <LayoutFormRow grow>
+          <Form.Item
+            name="journal"
+            label={t("jobs.fields.dms.journal")}
+            initialValue={
+              bodyshop.cdk_configuration &&
+              bodyshop.cdk_configuration.default_journal
+            }
+            rules={[
+              {
+                required: true,
+                //message: t("general.validation.required"),
+              },
+            ]}
+          >
+            <Input />
+          </Form.Item>
+          <Form.Item
+            name="kmin"
+            label={t("jobs.fields.kmin")}
+            initialValue={job && job.kmin}
+            rules={[
+              {
+                required: true,
+                //message: t("general.validation.required"),
+              },
+            ]}
+          >
+            <InputNumber disabled />
+          </Form.Item>
+          <Form.Item
+            name="kmout"
+            label={t("jobs.fields.kmout")}
+            initialValue={job && job.kmout}
+            rules={[
+              {
+                required: true,
+                //message: t("general.validation.required"),
+              },
+            ]}
+          >
+            <InputNumber disabled />
+          </Form.Item>
+        </LayoutFormRow>
+
+        {bodyshop.cdk_dealerid && (
+          <div>
+            <LayoutFormRow style={{ justifyContent: "center" }} grow>
+              <Form.Item
+                name="dms_make"
+                label={t("jobs.fields.dms.dms_make")}
+                rules={[
+                  {
+                    required: true,
+                  },
+                ]}
+              >
+                <Input disabled />
+              </Form.Item>
+              <Form.Item
+                name="dms_model"
+                label={t("jobs.fields.dms.dms_model")}
+                rules={[
+                  {
+                    required: true,
+                  },
+                ]}
+              >
+                <Input disabled />
+              </Form.Item>
+            </LayoutFormRow>
+            <Space>
+              <DmsCdkMakes form={form} socket={socket} job={job} />
+              <DmsCdkMakesRefetch />
+            </Space>
+          </div>
+        )}
+        <Form.Item
+          name="story"
+          label={t("jobs.fields.dms.story")}
+          rules={[
+            {
+              required: true,
+            },
+          ]}
+        >
+          <Input.TextArea maxLength={240} />
+        </Form.Item>
+
+        <Divider />
+        <Form.List name={["payers"]}>
+          {(fields, { add, remove }) => {
+            return (
+              <div>
+                {fields.map((field, index) => (
+                  <Form.Item key={field.key}>
+                    <Space wrap>
+                      <Form.Item
+                        label={t("jobs.fields.dms.payer.name")}
+                        key={`${index}name`}
+                        name={[field.name, "name"]}
+                        rules={[
+                          {
+                            required: true,
+                          },
+                        ]}
+                      >
+                        <Select
+                          style={{ minWidth: "15rem" }}
+                          onSelect={(value) => handlePayerSelect(value, index)}
+                        >
+                          {bodyshop.cdk_configuration &&
+                            bodyshop.cdk_configuration.payers &&
+                            bodyshop.cdk_configuration.payers.map((payer) => (
+                              <Select.Option key={payer.name}>
+                                {payer.name}
+                              </Select.Option>
+                            ))}
+                        </Select>
+                      </Form.Item>
+
+                      <Form.Item
+                        label={t("jobs.fields.dms.payer.dms_acctnumber")}
+                        key={`${index}dms_acctnumber`}
+                        name={[field.name, "dms_acctnumber"]}
+                        rules={[
+                          {
+                            required: true,
+                          },
+                        ]}
+                      >
+                        <Input disabled />
+                      </Form.Item>
+
+                      <Form.Item
+                        label={t("jobs.fields.dms.payer.amount")}
+                        key={`${index}amount`}
+                        name={[field.name, "amount"]}
+                        rules={[
+                          {
+                            required: true,
+                          },
+                        ]}
+                      >
+                        <CurrencyInput min={0} />
+                      </Form.Item>
+
+                      <Form.Item
+                        label={
+                          <div>
+                            {t("jobs.fields.dms.payer.controlnumber")}{" "}
+                            <Dropdown
+                              overlay={
+                                <Menu>
+                                  {bodyshop.cdk_configuration.controllist &&
+                                    bodyshop.cdk_configuration.controllist.map(
+                                      (key, idx) => (
+                                        <Menu.Item
+                                          key={idx}
+                                          onClick={() => {
+                                            form.setFieldsValue({
+                                              payers: form
+                                                .getFieldValue("payers")
+                                                .map((row, mapIndex) => {
+                                                  if (index !== mapIndex)
+                                                    return row;
+
+                                                  return {
+                                                    ...row,
+                                                    controlnumber:
+                                                      key.controlnumber,
+                                                  };
+                                                }),
+                                            });
+                                          }}
+                                        >
+                                          {key.name}
+                                        </Menu.Item>
+                                      )
+                                    )}
+                                </Menu>
+                              }
+                            >
+                              <a href=" #" onClick={(e) => e.preventDefault()}>
+                                <DownOutlined />
+                              </a>
+                            </Dropdown>
+                          </div>
+                        }
+                        key={`${index}controlnumber`}
+                        name={[field.name, "controlnumber"]}
+                        rules={[
+                          {
+                            required: true,
+                          },
+                        ]}
+                      >
+                        <Input />
+                      </Form.Item>
+
+                      <Form.Item shouldUpdate>
+                        {() => {
+                          const payers = form.getFieldValue("payers");
+
+                          const row = payers && payers[index];
+
+                          const cdkPayer =
+                            bodyshop.cdk_configuration.payers &&
+                            bodyshop.cdk_configuration.payers.find(
+                              (i) => i && row && i.name === row.name
+                            );
+
+                          return (
+                            <div>
+                              {cdkPayer &&
+                                t(`jobs.fields.${cdkPayer.control_type}`)}
+                            </div>
+                          );
+                        }}
+                      </Form.Item>
+
+                      <DeleteFilled
+                        onClick={() => {
+                          remove(field.name);
+                        }}
+                      />
+                    </Space>
+                  </Form.Item>
+                ))}
+                <Form.Item>
+                  <Button
+                    disabled={!(fields.length < 3)}
+                    onClick={() => {
+                      if (fields.length < 3) add();
+                    }}
+                    style={{ width: "100%" }}
+                  >
+                    {t("jobs.actions.dms.addpayer")}
+                  </Button>
+                </Form.Item>
+              </div>
+            );
+          }}
+        </Form.List>
+        <Form.Item shouldUpdate>
+          {() => {
+            //Perform Calculation to determine discrepancy.
+            let totalAllocated = Dinero();
+
+            const payers = form.getFieldValue("payers");
+            payers &&
+              payers.forEach((payer) => {
+                totalAllocated = totalAllocated.add(
+                  Dinero({ amount: Math.round((payer?.amount || 0) * 100) })
+                );
+              });
+
+            const totals =
+              socket.allocationsSummary &&
+              socket.allocationsSummary.reduce(
+                (acc, val) => {
+                  return {
+                    totalSale: acc.totalSale.add(Dinero(val.sale)),
+                    totalCost: acc.totalCost.add(Dinero(val.cost)),
+                  };
+                },
+                {
+                  totalSale: Dinero(),
+                  totalCost: Dinero(),
+                }
+              );
+            const discrep = totals
+              ? totals.totalSale.subtract(totalAllocated)
+              : Dinero();
+            return (
+              <Space size="large" wrap align="center">
+                <Statistic
+                  title={t("jobs.labels.subtotal")}
+                  value={(totals ? totals.totalSale : Dinero()).toFormat()}
+                />
+                <Typography.Title>-</Typography.Title>
+                <Statistic
+                  title={t("jobs.labels.dms.totalallocated")}
+                  value={totalAllocated.toFormat()}
+                />
+                <Typography.Title>=</Typography.Title>
+                <Statistic
+                  title={t("jobs.labels.dms.notallocated")}
+                  valueStyle={{
+                    color: discrep.getAmount() === 0 ? "green" : "red",
+                  }}
+                  value={discrep.toFormat()}
+                />
+                <Button
+                  disabled={
+                    !socket.allocationsSummary || discrep.getAmount() !== 0
+                  }
+                  htmlType="submit"
+                >
+                  {t("jobs.actions.dms.post")}
+                </Button>
+              </Space>
+            );
+          }}
+        </Form.Item>
+      </Form>
+    </Card>
+  );
+}

client/src/components/document-editor/document-editor.component.jsx

@@ -58,11 +58,9 @@ export function DocumentEditorComponent({ currentUser, bodyshop, document }) {
     if (imgRef.current !== null) {
       // create a marker.js MarkerArea
       markerArea.current = new markerjs2.MarkerArea(imgRef.current);
-      console.log(`markerArea.current`, markerArea.current);
+
       // attach an event handler to assign annotated image back to our image element
-      markerArea.current.addCloseEventListener((closeEvent) => {
-        console.log("Close Event", closeEvent);
-      });
+      markerArea.current.addCloseEventListener((closeEvent) => {});
 
       markerArea.current.addRenderEventListener((dataUrl) => {
         imgRef.current.src = dataUrl;

client/src/components/documents-upload/documents-upload.utility.js

@@ -14,8 +14,6 @@ var cleanAxios = axios.create();
 cleanAxios.interceptors.request.eject(axiosAuthInterceptorId);
 
 export const handleUpload = (ev, context) => {
-  console.log("Handling Upload", ev);
-
   logImEXEvent("document_upload", { filetype: ev.file.type });
 
   const { onError, onSuccess, onProgress } = ev;
@@ -61,7 +59,7 @@ export const uploadToCloudinary = async (
   //  let eager = process.env.REACT_APP_CLOUDINARY_THUMB_TRANSFORMATIONS;
 
   //Get the signed url.
-  console.log("fileType", fileType);
+
   const upload_preset = fileType.startsWith("video")
     ? "incoming_upload_video"
     : "incoming_upload";
@@ -74,7 +72,6 @@ export const uploadToCloudinary = async (
   });
 
   if (signedURLResponse.status !== 200) {
-    console.log("Error Getting Signed URL", signedURLResponse.statusText);
     if (!!onError) onError(signedURLResponse.statusText);
     notification["error"]({
       message: i18n.t("documents.errors.getpresignurl", {
@@ -113,13 +110,8 @@ export const uploadToCloudinary = async (
       ...options,
     }
   );
-  console.log("Upload Response", cloudinaryUploadResponse.data);
 
   if (cloudinaryUploadResponse.status !== 200) {
-    console.log(
-      "Error uploading to cloudinary.",
-      cloudinaryUploadResponse.statusText
-    );
     if (!!onError) onError(cloudinaryUploadResponse.statusText);
     notification["error"]({
       message: i18n.t("documents.errors.insert", {

client/src/components/email-documents/email-documents.component.jsx

@@ -35,10 +35,6 @@ export function EmailDocumentsComponent({
     },
     skip: !emailConfig.jobid,
   });
-  console.log(
-    "🚀  ~ file: email-documents.component.jsx  ~ line 38  ~ emailConfig",
-    emailConfig
-  );
 
   return (
     <div>

client/src/components/email-overlay/email-overlay.component.jsx

@@ -1,15 +1,71 @@
-import { UploadOutlined } from "@ant-design/icons";
-import { Divider, Form, Input, Select, Tabs, Upload } from "antd";
+import { UploadOutlined, UserAddOutlined } from "@ant-design/icons";
+import {
+  Divider,
+  Form,
+  Input,
+  Select,
+  Tabs,
+  Upload,
+  Space,
+  Menu,
+  Dropdown,
+} from "antd";
 import React from "react";
 import { useTranslation } from "react-i18next";
 import EmailDocumentsComponent from "../email-documents/email-documents.component";
+import _ from "lodash";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { selectBodyshop } from "../../redux/user/user.selectors";
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(EmailOverlayComponent);
 
-export default function EmailOverlayComponent({ form, selectedMediaState }) {
+export function EmailOverlayComponent({ form, selectedMediaState, bodyshop }) {
   const { t } = useTranslation();
+  const handleClick = ({ item, key, keyPath }) => {
+    const email = item.props.value;
+    form.setFieldsValue({ to: _.uniq([...form.getFieldValue("to"), email]) });
+  };
+
+  const menu = (
+    <div>
+      <Menu onClick={handleClick}>
+        {bodyshop.employees
+          .filter((e) => e.user_email)
+          .map((e, idx) => (
+            <Menu.Item value={e.user_email} key={idx}>
+              {`${e.first_name} ${e.last_name}`}
+            </Menu.Item>
+          ))}
+      </Menu>
+    </div>
+  );
+
   return (
     <div>
       <Form.Item
-        label={t("emails.fields.to")}
+        label={
+          <Space>
+            {t("emails.fields.to")}
+            <Dropdown overlay={menu}>
+              <a
+                className="ant-dropdown-link"
+                href=" #"
+                onClick={(e) => e.preventDefault()}
+              >
+                <UserAddOutlined />
+              </a>
+            </Dropdown>
+          </Space>
+        }
         name="to"
         rules={[
           {
@@ -37,6 +93,8 @@ export default function EmailOverlayComponent({ form, selectedMediaState }) {
       </Form.Item>
 
       <Divider>{t("emails.labels.preview")}</Divider>
+      <strong>{t("emails.labels.pdfcopywillbeattached")}</strong>
+
       <Form.Item shouldUpdate>
         {() => {
           return (

client/src/components/email-overlay/email-overlay.container.jsx

@@ -43,11 +43,17 @@ export function EmailOverlayContainer({
   const [loading, setLoading] = useState(false);
   const [sending, setSending] = useState(false);
   const [rawHtml, setRawHtml] = useState("");
+  const [pdfCopytoAttach, setPdfCopytoAttach] = useState({
+    filename: null,
+    pdf: null,
+  });
   const [selectedMedia, setSelectedMedia] = useState([]);
 
   const defaultEmailFrom = {
     from: {
-      name: `${currentUser.displayName} @ ${bodyshop.shopname}`,
+      name: currentUser.displayName
+        ? `${currentUser.displayName} @ ${bodyshop.shopname}`
+        : bodyshop.shopname,
       address: EmailSettings.fromAddress,
     },
     ReplyTo: {
@@ -59,17 +65,17 @@ export function EmailOverlayContainer({
   const handleFinish = async (values) => {
     logImEXEvent("email_send_from_modal");
 
-    const attachments = [];
+    //const attachments = [];
 
-    if (values.fileList)
-      await asyncForEach(values.fileList, async (f) => {
-        const t = {
-          ContentType: f.type,
-          Filename: f.name,
-          Base64Content: (await toBase64(f.originFileObj)).split(",")[1],
-        };
-        attachments.push(t);
-      });
+    // if (values.fileList)
+    //   await asyncForEach(values.fileList, async (f) => {
+    //     const t = {
+    //       ContentType: f.type,
+    //       Filename: f.name,
+    //       Base64Content: (await toBase64(f.originFileObj)).split(",")[1],
+    //     };
+    //     attachments.push(t);
+    //   });
 
     setSending(true);
     try {
@@ -77,18 +83,34 @@ export function EmailOverlayContainer({
         ...defaultEmailFrom,
         ...values,
         html: rawHtml,
-        attachments:
-          values.fileList &&
-          (await Promise.all(
-            values.fileList.map(async (f) => await toBase64(f.originFileObj))
-          )),
+        attachments: [
+          ...(values.fileList
+            ? await Promise.all(
+                values.fileList.map(async (f) => {
+                  return {
+                    filename: f.name,
+                    path: await toBase64(f.originFileObj),
+                  };
+                })
+              )
+            : []),
+          ...(pdfCopytoAttach.pdf
+            ? [
+                {
+                  path: pdfCopytoAttach.pdf,
+                  filename:
+                    pdfCopytoAttach.filename &&
+                    `${pdfCopytoAttach.filename}.pdf`,
+                },
+              ]
+            : []),
+        ],
         media: selectedMedia.filter((m) => m.isSelected).map((m) => m.src),
         //attachments,
       });
       notification["success"]({ message: t("emails.successes.sent") });
       toggleEmailOverlayVisible();
     } catch (error) {
-      console.log(JSON.stringify(error));
       notification["error"]({
         message: t("emails.errors.notsent", { message: error.message }),
       });
@@ -99,13 +121,22 @@ export function EmailOverlayContainer({
   const render = async () => {
     logImEXEvent("email_render_template", { template: emailConfig.template });
     setLoading(true);
-    let html = await RenderTemplate(emailConfig.template, bodyshop, true);
+    let { html, pdf, filename } = await RenderTemplate(
+      emailConfig.template,
+      bodyshop,
+      true
+    );
 
     const response = await axios.post("/render/inlinecss", {
       html: html,
       url: `${window.location.protocol}://${window.location.host}/`,
     });
     setRawHtml(response.data);
+
+    if (pdf) {
+      setPdfCopytoAttach({ pdf, filename });
+    }
+
     form.setFieldsValue({
       ...emailConfig.messageOptions,
       cc:
@@ -117,6 +148,18 @@ export function EmailOverlayContainer({
       html: response.data,
       fileList: [],
     });
+
+    if (
+      bodyshop.md_email_cc[emailConfig.template.name] &&
+      bodyshop.md_email_cc[emailConfig.template.name].length > 0
+    ) {
+      form.setFieldsValue({
+        cc: [
+          ...(form.getFieldValue("cc") || []),
+          ...bodyshop.md_email_cc[emailConfig.template.name],
+        ],
+      });
+    }
     setLoading(false);
   };
 
@@ -166,8 +209,8 @@ const toBase64 = (file) =>
     reader.onerror = (error) => reject(error);
   });
 
-const asyncForEach = async (array, callback) => {
-  for (let index = 0; index < array.length; index++) {
-    await callback(array[index], index, array);
-  }
-};
+// const asyncForEach = async (array, callback) => {
+//   for (let index = 0; index < array.length; index++) {
+//     await callback(array[index], index, array);
+//   }
+// };

client/src/components/email-test/email-test-component.jsx

@@ -7,10 +7,12 @@ import { selectCurrentUser } from "../../redux/user/user.selectors";
 import { GenerateDocument } from "../../utils/RenderTemplate";
 import DateTimePicker from "../form-date-time-picker/form-date-time-picker.component";
 import LayoutFormRow from "../layout-form-row/layout-form-row.component";
+import moment from "moment";
 
 const mapStateToProps = createStructuredSelector({
   currentUser: selectCurrentUser,
 });
+
 const mapDispatchToProps = (dispatch) => ({
   setEmailOptions: (e) => dispatch(setEmailOptions(e)),
 });
@@ -19,14 +21,24 @@ export function EmailTestComponent({ currentUser, setEmailOptions }) {
   const [form] = Form.useForm();
 
   const handleFinish = (values) => {
-    console.log("values", values);
     GenerateDocument(
       {
         name: values.key,
         variables: {
+          ...(values.start
+            ? {
+                start: moment(values.start).startOf("day").format("YYYY-MM-DD"),
+              }
+            : {}),
+          ...(values.end
+            ? { end: moment(values.end).endOf("day").format("YYYY-MM-DD") }
+            : {}),
+          ...(values.start
+            ? { starttz: moment(values.start).startOf("day") }
+            : {}),
+          ...(values.end ? { endtz: moment(values.end).endOf("day") } : {}),
+
           ...(values.id ? { id: values.id } : {}),
-          ...(values.start ? { start: values.start } : {}),
-          ...(values.end ? { end: values.end } : {}),
         },
       },
       {

client/src/components/error-boundary/error-boundary.component.jsx

@@ -9,6 +9,7 @@ import {
   selectBodyshop,
   selectCurrentUser,
 } from "../../redux/user/user.selectors";
+import { tracker } from "../../App/App.container";
 
 const mapStateToProps = createStructuredSelector({
   currentUser: selectCurrentUser,
@@ -36,6 +37,7 @@ class ErrorBoundary extends React.Component {
   componentDidCatch(error, info) {
     console.log("Exception Caught by Error Boundary.", error, info);
     this.setState({ ...this.state, error, info });
+    tracker.event("error_boundary", error, true);
   }
 
   handleErrorSubmit = () => {

client/src/components/fcm-notification/fcm-notification.component.jsx

@@ -2,7 +2,7 @@ import { withApollo } from "@apollo/client/react/hoc";
 import React, { Component } from "react";
 import { connect } from "react-redux";
 import { createStructuredSelector } from "reselect";
-import { logImEXEvent, messaging } from "../../firebase/firebase.utils";
+//import { logImEXEvent, messaging } from "../../firebase/firebase.utils";
 import { selectCurrentUser } from "../../redux/user/user.selectors";
 
 const mapStateToProps = createStructuredSelector({
@@ -15,21 +15,20 @@ const mapDispatchToProps = (dispatch) => ({
 class FcmNotificationComponent extends Component {
   async componentDidMount() {
     //const { client, currentUser } = this.props;
-    if (!!!messaging) return; //Skip all of the notification functionality if the firebase SDK could not start.
-
-    messaging
-      .requestPermission()
-      .then(async function () {
-        // const token = await messaging.getToken();
-        // client.mutate({
-        //   mutation: UPDATE_FCM_TOKEN,
-        //   variables: { authEmail: currentUser.email, token: { [token]: true } },
-        // });
-      })
-      .catch(function (err) {
-        console.log("Unable to get permission to notify.", err);
-        logImEXEvent("fcm_permission_denied", { message: err });
-      });
+    // if (!!!messaging) return; //Skip all of the notification functionality if the firebase SDK could not start.
+    // messaging
+    //   .requestPermission()
+    //   .then(async function () {
+    //     // const token = await messaging.getToken();
+    //     // client.mutate({
+    //     //   mutation: UPDATE_FCM_TOKEN,
+    //     //   variables: { authEmail: currentUser.email, token: { [token]: true } },
+    //     // });
+    //   })
+    //   .catch(function (err) {
+    //     console.log("Unable to get permission to notify.", err);
+    //     logImEXEvent("fcm_permission_denied", { message: err });
+    //   });
   }
 
   render() {

client/src/components/form-items-formatted/phone-form-item.component.jsx

@@ -21,7 +21,7 @@ export const PhoneItemFormatterValidation = (getFieldValue, name) => ({
       return Promise.resolve();
     } else {
       const p = parsePhoneNumber(value, "CA");
-      if (p.isValid()) {
+      if (p && p.isValid()) {
         return Promise.resolve();
       } else {
         return Promise.reject(i18n.t("general.validation.invalidphone"));

client/src/components/global-search/global-search.component.jsx

@@ -45,7 +45,7 @@ export default function GlobalSearch() {
                     <span>{`${job.v_model_yr || ""} ${job.v_make_desc || ""} ${
                       job.v_model_desc || ""
                     }`}</span>
-                    <span>{`${job.clm_no}`}</span>
+                    <span>{`${job.clm_no || ""}`}</span>
                   </Space>
                 </Link>
               ),
@@ -62,13 +62,16 @@ export default function GlobalSearch() {
               }`,
               label: (
                 <Link to={`/manage/owners/${owner.id}`}>
-                  <Space size="small" split={<Divider type="vertical" />}>
+                  <Space size="small" split={<Divider type="vertical" />} wrap>
                     <span>{`${owner.ownr_fn || ""} ${owner.ownr_ln || ""} ${
                       owner.ownr_co_nm || ""
                     }`}</span>
                     <PhoneNumberFormatter>
                       {owner.ownr_ph1}
                     </PhoneNumberFormatter>
+                    <PhoneNumberFormatter>
+                      {owner.ownr_ph2}
+                    </PhoneNumberFormatter>
                   </Space>
                 </Link>
               ),
@@ -91,8 +94,8 @@ export default function GlobalSearch() {
                         vehicle.v_make_desc || ""
                       } ${vehicle.v_model_desc || ""}`}
                     </span>
-                    <span>{vehicle.plate_no}</span>
-                    <span> {vehicle.v_vin}</span>
+                    <span>{vehicle.plate_no || ""}</span>
+                    <span> {vehicle.v_vin || ""}</span>
                   </Space>
                 </Link>
               ),
@@ -108,10 +111,11 @@ export default function GlobalSearch() {
               label: (
                 <Link to={`/manage/jobs/${payment.job.id}`}>
                   <Space size="small" split={<Divider type="vertical" />}>
+                    <span>{payment.paymentnum}</span>
                     <span>{payment.job.ro_number}</span>
-                    <span>{payment.job.memo}</span>
-                    <span>{payment.job.amount}</span>
-                    <span>{payment.job.transactionid}</span>
+                    <span>{payment.memo || ""}</span>
+                    <span>{payment.amount || ""}</span>
+                    <span>{payment.transactionid || ""}</span>
                   </Space>
                 </Link>
               ),
@@ -167,7 +171,6 @@ export default function GlobalSearch() {
     <AutoComplete
       options={options}
       onSearch={handleSearch}
-      allowClear
       placeholder={t("general.labels.globalsearch")}
     >
       <Input.Search loading={loading} />

client/src/components/header/header.component.jsx

@@ -46,12 +46,16 @@ import {
 } from "../../redux/application/application.selectors";
 import { setModalContext } from "../../redux/modals/modals.actions";
 import { signOutStart } from "../../redux/user/user.actions";
-import { selectCurrentUser } from "../../redux/user/user.selectors";
+import {
+  selectBodyshop,
+  selectCurrentUser,
+} from "../../redux/user/user.selectors";
 
 const mapStateToProps = createStructuredSelector({
   currentUser: selectCurrentUser,
   recentItems: selectRecentItems,
   selectedHeader: selectSelectedHeader,
+  bodyshop: selectBodyshop,
 });
 
 const mapDispatchToProps = (dispatch) => ({
@@ -69,6 +73,7 @@ const mapDispatchToProps = (dispatch) => ({
 function Header({
   handleMenuClick,
   currentUser,
+  bodyshop,
   selectedHeader,
   signOutStart,
   setBillEnterContext,
@@ -237,16 +242,26 @@ function Header({
                 {t("menus.header.accounting-receivables")}
               </Link>
             </Menu.Item>
-            <Menu.Item key="payables">
-              <Link to="/manage/accounting/payables">
-                {t("menus.header.accounting-payables")}
-              </Link>
-            </Menu.Item>
-            <Menu.Item key="payments">
-              <Link to="/manage/accounting/payments">
-                {t("menus.header.accounting-payments")}
-              </Link>
-            </Menu.Item>
+            {!(
+              (bodyshop && bodyshop.cdk_dealerid) ||
+              (bodyshop && bodyshop.pbs_serialnumber)
+            ) && (
+              <Menu.Item key="payables">
+                <Link to="/manage/accounting/payables">
+                  {t("menus.header.accounting-payables")}
+                </Link>
+              </Menu.Item>
+            )}
+            {!(
+              (bodyshop && bodyshop.cdk_dealerid) ||
+              (bodyshop && bodyshop.pbs_serialnumber)
+            ) && (
+              <Menu.Item key="payments">
+                <Link to="/manage/accounting/payments">
+                  {t("menus.header.accounting-payments")}
+                </Link>
+              </Menu.Item>
+            )}
             <Menu.Item key="export-logs">
               <Link to="/manage/accounting/exportlogs">
                 {t("menus.header.export-logs")}

client/src/components/help-rescue/help-rescue.component.jsx

@@ -10,15 +10,11 @@ export default function HelpRescue() {
     var bodyFormData = new FormData();
     bodyFormData.append("Code", code);
     bodyFormData.append("hostederrorhandling", 1);
-    const res1 = await fetch(
-      "https://secure.logmeinrescue.com/Customer/Code.aspx",
-      {
-        mode: "no-cors",
-        method: "POST",
-        body: bodyFormData,
-      }
-    );
-    console.log("handleClick -> res1", await res1.text());
+    await fetch("https://secure.logmeinrescue.com/Customer/Code.aspx", {
+      mode: "no-cors",
+      method: "POST",
+      body: bodyFormData,
+    });
   };
 
   return (
@@ -40,7 +36,6 @@ export default function HelpRescue() {
           method="post"
           id="logmeinsupport"
           onSubmit={(...props) => {
-            console.log(`props`, props);
             alert();
           }}
         >

client/src/components/job-3rd-party-modal/job-3rd-party-modal.component.jsx

@@ -44,7 +44,7 @@ export function Jobd3RdPartyModal({ bodyshop, jobId }) {
   };
   const handleFinish = (values) => {
     const { sendtype, ...restVals } = values;
-    console.log(restVals);
+
     GenerateDocument(
       {
         name: TemplateList("job_special").thirdpartypayer.key,
@@ -161,7 +161,7 @@ export function Jobd3RdPartyModal({ bodyshop, jobId }) {
               <Input />
             </Form.Item>
             <Form.Item
-              label={t("printcenter.jobs.3rdpartyfields.ponumber")}
+              label={t("printcenter.jobs.3rdpartyfields.refnumber")}
               name="ponumber"
             >
               <Input />

client/src/components/job-at-change/schedule-event.color.component.jsx

@@ -56,7 +56,7 @@ export function ScheduleEventColor({ bodyshop, event }) {
       <Menu.Item key={"null"}>{t("general.actions.clear")}</Menu.Item>
     </Menu>
   );
-  console.log(`event`, event);
+
   return (
     <Dropdown overlay={menu}>
       <a href=" #" onClick={(e) => e.preventDefault()}>

client/src/components/job-at-change/schedule-event.component.jsx

@@ -1,24 +1,50 @@
-import { Button, Popover, Space } from "antd";
+import { AlertFilled } from "@ant-design/icons";
+import {
+  Button,
+  Divider,
+  Dropdown,
+  Menu,
+  notification,
+  Popover,
+  Space,
+} from "antd";
+import parsePhoneNumber from "libphonenumber-js";
+import moment from "moment";
+import queryString from "query-string";
 import React, { useState } from "react";
 import { useTranslation } from "react-i18next";
 import { connect } from "react-redux";
 import { Link, useHistory, useLocation } from "react-router-dom";
+import { createStructuredSelector } from "reselect";
+import {
+  openChatByPhone,
+  setMessage,
+} from "../../redux/messaging/messaging.actions";
 import { setModalContext } from "../../redux/modals/modals.actions";
+import { selectBodyshop } from "../../redux/user/user.selectors";
 import CurrencyFormatter from "../../utils/CurrencyFormatter";
-import PhoneFormatter from "../../utils/PhoneFormatter";
 import { GenerateDocument } from "../../utils/RenderTemplate";
 import { TemplateList } from "../../utils/TemplateConstants";
+import ChatOpenButton from "../chat-open-button/chat-open-button.component";
 import DataLabel from "../data-label/data-label.component";
 import ScheduleAtChange from "./job-at-change.component";
 import ScheduleEventColor from "./schedule-event.color.component";
-import queryString from "query-string";
+import ScheduleEventNote from "./schedule-event.note.component";
 
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
 const mapDispatchToProps = (dispatch) => ({
   setScheduleContext: (context) =>
     dispatch(setModalContext({ context: context, modal: "schedule" })),
+  openChatByPhone: (phone) => dispatch(openChatByPhone(phone)),
+  setMessage: (text) => dispatch(setMessage(text)),
 });
 
 export function ScheduleEventComponent({
+  bodyshop,
+  setMessage,
+  openChatByPhone,
   event,
   refetch,
   handleCancel,
@@ -38,7 +64,7 @@ export function ScheduleEventComponent({
   );
 
   const popoverContent = (
-    <div>
+    <div style={{ maxWidth: "40vw" }}>
       {!event.isintake ? (
         <strong>{event.title}</strong>
       ) : (
@@ -75,17 +101,25 @@ export function ScheduleEventComponent({
             {(event.job && event.job.ownr_ea) || ""}
           </DataLabel>
           <DataLabel label={t("jobs.fields.ownr_ph1")}>
-            <PhoneFormatter>
-              {(event.job && event.job.ownr_ph1) || ""}
-            </PhoneFormatter>
+            <ChatOpenButton
+              phone={event.job && event.job.ownr_ph1}
+              jobid={event.job.id}
+            />
+          </DataLabel>
+          <DataLabel label={t("jobs.fields.ownr_ph2")}>
+            <ChatOpenButton
+              phone={event.job && event.job.ownr_ph2}
+              jobid={event.job.id}
+            />
           </DataLabel>
           <DataLabel label={t("jobs.fields.alt_transport")}>
             {(event.job && event.job.alt_transport) || ""}
             <ScheduleAtChange job={event && event.job} />
           </DataLabel>
+          <ScheduleEventNote event={event} />
         </div>
       ) : null}
-
+      <Divider />
       <Space wrap>
         {event.job ? (
           <Link to={`/manage/jobs/${event.job && event.job.id}`}>
@@ -106,23 +140,62 @@ export function ScheduleEventComponent({
             {t("appointments.actions.preview")}
           </Button>
         ) : null}
-        <Button
-          onClick={() => {
-            const Template = TemplateList("job").appointment_reminder;
-            GenerateDocument(
-              {
-                name: Template.key,
-                variables: { id: event.job.id },
-              },
-              { to: event.job && event.job.ownr_ea, subject: Template.subject },
-              "e",
-              event.job && event.job.id
-            );
-          }}
-          disabled={event.arrived}
+
+        <Dropdown
+          overlay={
+            <Menu>
+              <Menu.Item
+                onClick={() => {
+                  const Template = TemplateList("job").appointment_reminder;
+                  GenerateDocument(
+                    {
+                      name: Template.key,
+                      variables: { id: event.job.id },
+                    },
+                    {
+                      to: event.job && event.job.ownr_ea,
+                      subject: Template.subject,
+                    },
+                    "e",
+                    event.job && event.job.id
+                  );
+                }}
+                disabled={event.arrived}
+              >
+                {t("general.labels.email")}
+              </Menu.Item>
+              <Menu.Item
+                onClick={() => {
+                  const p = parsePhoneNumber(event.job.ownr_ph1, "CA");
+                  if (p && p.isValid()) {
+                    openChatByPhone({
+                      phone_num: p.formatInternational(),
+                      jobid: event.job.id,
+                    });
+                    setMessage(
+                      t("appointments.labels.reminder", {
+                        shopname: bodyshop.shopname,
+                        date: moment(event.start).format("MM/DD/YYYY"),
+                        time: moment(event.start).format("HH:mm a"),
+                      })
+                    );
+                    setVisible(false);
+                  } else {
+                    notification["error"]({
+                      message: t("messaging.error.invalidphone"),
+                    });
+                  }
+                }}
+                disabled={event.arrived || !bodyshop.messagingservicesid}
+              >
+                {t("general.labels.sms")}
+              </Menu.Item>
+            </Menu>
+          }
         >
-          {t("appointments.actions.sendreminder")}
-        </Button>
+          <Button>{t("appointments.actions.sendreminder")}</Button>
+        </Dropdown>
+
         <Button onClick={() => handleCancel(event.id)} disabled={event.arrived}>
           {t("appointments.actions.cancel")}
         </Button>
@@ -136,6 +209,9 @@ export function ScheduleEventComponent({
                 jobId: event.job.id,
                 job: event.job,
                 previousEvent: event.id,
+                color: event.color,
+                alt_transport: event.job && event.job.alt_transport,
+                note: event.note,
               },
             });
           }}
@@ -161,6 +237,7 @@ export function ScheduleEventComponent({
   const RegularEvent = event.isintake ? (
     <div style={{ display: "flex", flexWrap: "wrap" }}>
       <Space>
+        {event.note && <AlertFilled className="production-alert" />}
         <strong>{`${event.job.ro_number || t("general.labels.na")}`}</strong>
         <span>{`${(event.job && event.job.ownr_fn) || ""} ${
           (event.job && event.job.ownr_ln) || ""
@@ -202,4 +279,7 @@ export function ScheduleEventComponent({
     </Popover>
   );
 }
-export default connect(null, mapDispatchToProps)(ScheduleEventComponent);
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(ScheduleEventComponent);

client/src/components/job-at-change/schedule-event.note.component.jsx

@@ -0,0 +1,74 @@
+import { EditFilled, SaveFilled } from "@ant-design/icons";
+import { useMutation } from "@apollo/client";
+import { Button, Input, notification, Space } from "antd";
+import React, { useState } from "react";
+import { useTranslation } from "react-i18next";
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { UPDATE_APPOINTMENT } from "../../graphql/appointments.queries";
+import { selectBodyshop } from "../../redux/user/user.selectors";
+import DataLabel from "../data-label/data-label.component";
+
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+});
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+
+export function ScheduleEventNote({ event }) {
+  const [editing, setEditing] = useState(false);
+  const [note, setNote] = useState(event.note || "");
+  const [loading, setLoading] = useState(false);
+  const [updateAppointment] = useMutation(UPDATE_APPOINTMENT);
+  const { t } = useTranslation();
+
+  const toggleEdit = async () => {
+    if (editing) {
+      //Await the update
+      setLoading(true);
+      const result = await updateAppointment({
+        variables: {
+          appid: event.id,
+          app: { note },
+        },
+      });
+
+      if (!!!result.errors) {
+        //  notification["success"]({ message: t("appointments.successes.saved") });
+      } else {
+        notification["error"]({
+          message: t("jobs.errors.saving", {
+            error: JSON.stringify(result.errors),
+          }),
+        });
+      }
+
+      setEditing(false);
+    } else {
+      setEditing(true);
+    }
+    setLoading(false);
+  };
+
+  return (
+    <DataLabel label={t("appointments.fields.note")}>
+      <Space flex>
+        {!editing ? (
+          event.note || ""
+        ) : (
+          <Input.TextArea
+            rows={3}
+            value={note}
+            onChange={(e) => setNote(e.target.value)}
+            style={{ maxWidth: "8vw" }}
+          />
+        )}
+        <Button onClick={toggleEdit} loading={loading}>
+          {editing ? <SaveFilled /> : <EditFilled />}
+        </Button>
+      </Space>
+    </DataLabel>
+  );
+}
+export default connect(mapStateToProps, mapDispatchToProps)(ScheduleEventNote);

client/src/components/job-audit-trail/job-audit-trail.component.jsx

@@ -0,0 +1,46 @@
+import { useQuery } from "@apollo/client";
+import { Card, Table } from "antd";
+import React from "react";
+import { useTranslation } from "react-i18next";
+import { QUERY_AUDIT_TRAIL } from "../../graphql/audit_trail.queries";
+import { DateTimeFormatter } from "../../utils/DateFormatter";
+
+export default function JobAuditTrail({ jobId }) {
+  const { t } = useTranslation();
+  const { loading, data } = useQuery(QUERY_AUDIT_TRAIL, {
+    variables: { jobid: jobId },
+    skip: !jobId,
+  });
+
+  const columns = [
+    {
+      title: t("audit.fields.created"),
+      dataIndex: "created",
+      key: "created",
+      render: (text, record) => (
+        <DateTimeFormatter>{record.created}</DateTimeFormatter>
+      ),
+    },
+    {
+      title: t("audit.fields.useremail"),
+      dataIndex: "useremail",
+      key: "useremail",
+    },
+    {
+      title: t("audit.fields.operation"),
+      dataIndex: "operation",
+      key: "operation",
+    },
+  ];
+
+  return (
+    <Card title={t("jobs.labels.audit")}>
+      <Table
+        loading={loading}
+        columns={columns}
+        rowKey="id"
+        dataSource={data ? data.audit_trail : []}
+      />
+    </Card>
+  );
+}

client/src/components/job-bills-total/job-bills-total.component.jsx

@@ -55,7 +55,6 @@ export default function JobBillsTotalComponent({
         );
       }
       if (il.deductedfromlbr) {
-        console.log(i, "Deducting from labor.");
         lbrAdjustments = lbrAdjustments.add(
           Dinero({
             amount: Math.round((il.actual_price || 0) * 100),

client/src/components/job-checklist/components/job-checklist-form/job-checklist-form.component.jsx

@@ -16,16 +16,21 @@ import {
 import ConfigFormComponents from "../../../config-form-components/config-form-components.component";
 import DateTimePicker from "../../../form-date-time-picker/form-date-time-picker.component";
 import moment from "moment-business-days";
+import { insertAuditTrail } from "../../../../redux/application/application.actions";
+import AuditTrailMapping from "../../../../utils/AuditTrailMappings";
+import { UPDATE_OWNER } from "../../../../graphql/owners.queries";
 
 const mapStateToProps = createStructuredSelector({
   bodyshop: selectBodyshop,
   currentUser: selectCurrentUser,
 });
 const mapDispatchToProps = (dispatch) => ({
-  //setUserLanguage: language => dispatch(setUserLanguage(language))
+  insertAuditTrail: ({ jobid, operation }) =>
+    dispatch(insertAuditTrail({ jobid, operation })),
 });
 
 export function JobChecklistForm({
+  insertAuditTrail,
   formItems,
   bodyshop,
   currentUser,
@@ -37,6 +42,8 @@ export function JobChecklistForm({
   const [intakeJob] = useMutation(UPDATE_JOB);
   const [loading, setLoading] = useState(false);
   const [markAptArrived] = useMutation(MARK_LATEST_APPOINTMENT_AS_ARRIVED);
+  const [updateOwner] = useMutation(UPDATE_OWNER);
+
   const { jobId } = useParams();
   const history = useHistory();
   const search = queryString.parse(useLocation().search);
@@ -57,8 +64,16 @@ export function JobChecklistForm({
           ...(type === "intake" && { actual_in: new Date() }),
           ...(type === "intake" && {
             production_vars: {
-              ...job.production_vars,
-              ...values.production_vars,
+              ...(job ? job.production_vars : {}),
+
+              note:
+                values.production_vars &&
+                values.production_vars.note &&
+                values.production_vars.note !== ""
+                  ? values &&
+                    values.production_vars &&
+                    values.production_vars.note
+                  : job && job.production_vars && job.production_vars.note,
             },
           }),
           ...(type === "intake" && {
@@ -104,11 +119,40 @@ export function JobChecklistForm({
         });
       }
     }
+    if (type === "intake" && job.owner && job.owner.id) {
+      //Updae Owner Allow to Text
+      const updateOwnerResult = await updateOwner({
+        variables: {
+          ownerId: job.owner.id,
+          owner: { allow_text_message: values.allow_text_message },
+        },
+      });
+
+      if (!!updateOwnerResult.errors) {
+        notification["error"]({
+          message: t("checklist.errors.complete", {
+            error: JSON.stringify(result.errors),
+          }),
+        });
+      }
+    }
+
     setLoading(false);
 
     if (!!!result.errors) {
       notification["success"]({ message: t("checklist.successes.completed") });
       history.push(`/manage/jobs/${jobId}`);
+
+      insertAuditTrail({
+        jobid: jobId,
+        operation: AuditTrailMapping.jobchecklist(
+          type,
+          (type === "deliver" && values.removeFromProduction && false) ||
+            (type === "intake" && values.addToProduction),
+          (type === "intake" && bodyshop.md_ro_statuses.default_arrived) ||
+            (type === "deliver" && bodyshop.md_ro_statuses.default_delivered)
+        ),
+      });
     } else {
       notification["error"]({
         message: t("checklist.errors.complete", {
@@ -123,7 +167,11 @@ export function JobChecklistForm({
       title={t("checklist.labels.checklist")}
       extra={
         !readOnly && (
-          <Button loading={loading} onClick={() => form.submit()}>
+          <Button
+            loading={loading}
+            type="primary"
+            onClick={() => form.submit()}
+          >
             {t("general.actions.submit")}
           </Button>
         )
@@ -135,14 +183,17 @@ export function JobChecklistForm({
         initialValues={{
           ...(type === "intake" && {
             addToProduction: true,
+            allow_text_message: job.owner && job.owner.allow_text_message,
             scheduled_completion:
               (job && job.scheduled_completion) ||
-              moment().businessAdd(
-                (job.labhrs.aggregate.sum.mod_lb_hrs +
-                  job.larhrs.aggregate.sum.mod_lb_hrs) /
-                  bodyshop.target_touchtime,
-                "days"
-              ),
+              (job.labbrs && job.larhrs
+                ? moment().businessAdd(
+                    (job.labhrs.aggregate.sum.mod_lb_hrs +
+                      job.larhrs.aggregate.sum.mod_lb_hrs) /
+                      bodyshop.target_touchtime,
+                    "days"
+                  )
+                : null),
             scheduled_delivery: job && job.scheduled_delivery,
           }),
           ...(type === "deliver" && {
@@ -170,6 +221,14 @@ export function JobChecklistForm({
             >
               <Switch disabled={readOnly} />
             </Form.Item>
+            <Form.Item
+              name="allow_text_message"
+              valuePropName="checked"
+              label={t("checklist.labels.allow_text_message")}
+              disabled={readOnly}
+            >
+              <Switch disabled={readOnly} />
+            </Form.Item>
             <Form.Item
               name="scheduled_completion"
               label={t("jobs.fields.scheduled_completion")}
@@ -194,6 +253,7 @@ export function JobChecklistForm({
               name={["production_vars", "note"]}
               label={t("jobs.fields.production_vars.note")}
               disabled={readOnly}
+              trigger="onChange"
             >
               <Input.TextArea rows={3} disabled={readOnly} />
             </Form.Item>

client/src/components/job-checklist/components/job-checklist-template-list/job-checklist-template-list.component.jsx

@@ -34,7 +34,7 @@ export default function JobIntakeTemplateList({ templates }) {
   const renderAllTemplates = async () => {
     logImEXEvent("checklist_render_all_templates");
     setLoading(true);
-    console.log("templates :>> ", templates);
+
     await GenerateDocuments(
       templates.map((key) => {
         return { name: key, variables: { id: jobId } };

client/src/components/job-costing-modal/job-costing-modal.container.jsx

@@ -35,7 +35,7 @@ export function JobCostingModalContainer({
     async function getData() {
       if (jobId && visible) {
         const { data } = await axios.post("/job/costing", { jobid: jobId });
-        console.log(data);
+
         setCostingData(data);
       }
     }

client/src/components/job-costing-parts-table/job-costing-parts-table.component.jsx

@@ -77,7 +77,6 @@ export default function JobCostingPartsTable({ data, summaryData }) {
             .includes(searchText.toLowerCase())
         );
 
-  console.log("data :>> ", data);
   return (
     <div>
       <Table

client/src/components/job-create-iou/job-create-iou.component.jsx

@@ -0,0 +1,95 @@
+import { useApolloClient } from "@apollo/client";
+import { useTreatments } from "@splitsoftware/splitio-react";
+import { Button, notification, Popconfirm } from "antd";
+import React, { useState } from "react";
+import { useTranslation } from "react-i18next";
+import { connect } from "react-redux";
+import { useHistory } from "react-router";
+import { createStructuredSelector } from "reselect";
+import { UPDATE_JOB_LINES_IOU } from "../../graphql/jobs-lines.queries";
+import {
+  selectBodyshop,
+  selectCurrentUser,
+} from "../../redux/user/user.selectors";
+import { CreateIouForJob } from "../jobs-detail-header-actions/jobs-detail-header-actions.duplicate.util";
+const mapStateToProps = createStructuredSelector({
+  bodyshop: selectBodyshop,
+  currentUser: selectCurrentUser,
+});
+const mapDispatchToProps = (dispatch) => ({
+  //setUserLanguage: language => dispatch(setUserLanguage(language))
+});
+export default connect(mapStateToProps, mapDispatchToProps)(JobCreateIOU);
+
+export function JobCreateIOU({
+  bodyshop,
+  currentUser,
+  jobid,
+  selectedJobLines,
+}) {
+  const { t } = useTranslation();
+  const [loading, setLoading] = useState(false);
+  const client = useApolloClient();
+  const history = useHistory();
+
+  const { IOU_Tracking } = useTreatments(
+    ["IOU_Tracking"],
+    {},
+    bodyshop.imexshopid
+  );
+  if (IOU_Tracking.treatment !== "on") return null;
+
+  const handleCreateIou = async () => {
+    setLoading(true);
+    //Query all of the job details to recreate.
+    const iouId = await CreateIouForJob(
+      client,
+      jobid,
+      {
+        status: bodyshop.md_ro_statuses.default_open,
+        bodyshopid: bodyshop.id,
+        useremail: currentUser.email,
+      },
+      selectedJobLines
+    );
+    notification.open({
+      type: "success",
+      message: t("jobs.successes.ioucreated"),
+      onClick: () => history.push(`/manage/jobs/${iouId}`),
+    });
+    const selectedJobLinesIds = selectedJobLines.map((l) => l.id);
+    await client.mutate({
+      mutation: UPDATE_JOB_LINES_IOU,
+      variables: { ids: selectedJobLinesIds },
+      update(cache) {
+        cache.modify({
+          id: cache.identify(jobid),
+          fields: {
+            joblines(existingJobLines, { readField }) {
+              return existingJobLines.map((a) => {
+                if (!selectedJobLinesIds.includes(a.id)) return a;
+                return { ...a, ioucreated: true };
+              });
+            },
+          },
+        });
+      },
+    });
+
+    setLoading(false);
+  };
+
+  return (
+    <Popconfirm
+      title={t("jobs.labels.createiouwarning")}
+      onConfirm={handleCreateIou}
+    >
+      <Button
+        loading={loading}
+        disabled={!selectedJobLines || selectedJobLines.length === 0}
+      >
+        {t("jobs.actions.createiou")}
+      </Button>
+    </Popconfirm>
+  );
+}

client/src/components/job-detail-cards/job-detail-cards.component.jsx

@@ -112,60 +112,46 @@ export function JobDetailCards({ setPrintCenterContext }) {
           <Divider type="horizontal" />
           <Row gutter={[16, 16]}>
             <Col {...span}>
-              <Card.Grid style={{ width: "100%", height: "100%" }}>
-                <JobDetailCardsInsuranceComponent
-                  loading={loading}
-                  data={data ? data.jobs_by_pk : null}
-                />
-              </Card.Grid>
+              <JobDetailCardsInsuranceComponent
+                loading={loading}
+                data={data ? data.jobs_by_pk : null}
+              />
             </Col>
             <Col {...span}>
-              <Card.Grid style={{ width: "100%", height: "100%" }}>
-                <JobDetailCardsTotalsComponent
-                  loading={loading}
-                  data={data ? data.jobs_by_pk : null}
-                />
-              </Card.Grid>
+              <JobDetailCardsTotalsComponent
+                loading={loading}
+                data={data ? data.jobs_by_pk : null}
+              />
             </Col>
             <Col {...span}>
-              <Card.Grid style={{ width: "100%", height: "100%" }}>
-                <JobDetailCardsDatesComponent
-                  loading={loading}
-                  data={data ? data.jobs_by_pk : null}
-                />
-              </Card.Grid>
+              <JobDetailCardsDatesComponent
+                loading={loading}
+                data={data ? data.jobs_by_pk : null}
+              />
             </Col>
             <Col {...span}>
-              <Card.Grid style={{ width: "100%", height: "100%" }}>
-                <JobDetailCardsPartsComponent
-                  loading={loading}
-                  data={data ? data.jobs_by_pk : null}
-                />
-              </Card.Grid>
+              <JobDetailCardsPartsComponent
+                loading={loading}
+                data={data ? data.jobs_by_pk : null}
+              />
             </Col>
             <Col {...span}>
-              <Card.Grid style={{ width: "100%", height: "100%" }}>
-                <JobDetailCardsNotesComponent
-                  loading={loading}
-                  data={data ? data.jobs_by_pk : null}
-                />
-              </Card.Grid>
+              <JobDetailCardsNotesComponent
+                loading={loading}
+                data={data ? data.jobs_by_pk : null}
+              />
             </Col>
             <Col {...span}>
-              <Card.Grid style={{ width: "100%", height: "100%" }}>
-                <JobDetailCardsDocumentsComponent
-                  loading={loading}
-                  data={data ? data.jobs_by_pk : null}
-                />
-              </Card.Grid>
+              <JobDetailCardsDocumentsComponent
+                loading={loading}
+                data={data ? data.jobs_by_pk : null}
+              />
             </Col>
             <Col {...span}>
-              <Card.Grid style={{ width: "100%", height: "100%" }}>
-                <JobDetailCardsDamageComponent
-                  loading={loading}
-                  data={data ? data.jobs_by_pk : null}
-                />
-              </Card.Grid>
+              <JobDetailCardsDamageComponent
+                loading={loading}
+                data={data ? data.jobs_by_pk : null}
+              />
             </Col>
           </Row>
         </Card>

client/src/components/job-detail-cards/job-detail-cards.dates.component.jsx

@@ -1,7 +1,7 @@
 import { Timeline } from "antd";
 import React from "react";
 import { useTranslation } from "react-i18next";
-import { DateFormatter } from "../../utils/DateFormatter";
+import { DateTimeFormatter } from "../../utils/DateFormatter";
 import CardTemplate from "./job-detail-cards.template.component";
 
 export default function JobDetailCardsDatesComponent({ loading, data }) {
@@ -26,80 +26,86 @@ export default function JobDetailCardsDatesComponent({ loading, data }) {
           ) ? (
             <div>{t("jobs.errors.nodates")}</div>
           ) : null}
+          {data.date_last_contacted ? (
+            <Timeline.Item>
+              <label>{t("jobs.fields.date_last_contacted")}: </label>
+              <DateTimeFormatter>{data.date_last_contacted}</DateTimeFormatter>
+            </Timeline.Item>
+          ) : null}
           {data.date_open ? (
             <Timeline.Item>
               <label>{t("jobs.fields.date_open")}: </label>
-              <DateFormatter>{data.date_open}</DateFormatter>
+              <DateTimeFormatter>{data.date_open}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.date_estimated ? (
             <Timeline.Item>
               <label>{t("jobs.fields.date_estimated")}: </label>
-              <DateFormatter>{data.date_estimated}</DateFormatter>
+              <DateTimeFormatter>{data.date_estimated}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.date_scheduled ? (
             <Timeline.Item>
               <label>{t("jobs.fields.date_scheduled")}: </label>
-              <DateFormatter>{data.date_scheduled}</DateFormatter>
+              <DateTimeFormatter>{data.date_scheduled}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.scheduled_in ? (
             <Timeline.Item>
               <label>{t("jobs.fields.scheduled_in")}: </label>
-              <DateFormatter>{data.scheduled_in}</DateFormatter>
+              <DateTimeFormatter>{data.scheduled_in}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.actual_in ? (
             <Timeline.Item>
               <label>{t("jobs.fields.actual_in")}: </label>
-              <DateFormatter>{data.actual_in}</DateFormatter>
+              <DateTimeFormatter>{data.actual_in}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.scheduled_completion ? (
             <Timeline.Item>
               <label>{t("jobs.fields.scheduled_completion")}: </label>
-              <DateFormatter>{data.scheduled_completion}</DateFormatter>
+              <DateTimeFormatter>{data.scheduled_completion}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.actual_completion ? (
             <Timeline.Item>
               <label>{t("jobs.fields.actual_completion")}: </label>
-              <DateFormatter>{data.actual_completion}</DateFormatter>
+              <DateTimeFormatter>{data.actual_completion}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.scheduled_delivery ? (
             <Timeline.Item>
               <label>{t("jobs.fields.scheduled_delivery")}: </label>
-              <DateFormatter>{data.scheduled_delivery}</DateFormatter>
+              <DateTimeFormatter>{data.scheduled_delivery}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.actual_delivery ? (
             <Timeline.Item>
               <label>{t("jobs.fields.actual_delivery")}: </label>
-              <DateFormatter>{data.actual_delivery}</DateFormatter>
+              <DateTimeFormatter>{data.actual_delivery}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.date_invoiced ? (
             <Timeline.Item>
               <label>{t("jobs.fields.date_invoiced")}: </label>
-              <DateFormatter>{data.date_invoiced}</DateFormatter>
+              <DateTimeFormatter>{data.date_invoiced}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
 
           {data.date_exported ? (
             <Timeline.Item>
               <label>{t("jobs.fields.date_exported")}: </label>
-              <DateFormatter>{data.date_exported}</DateFormatter>
+              <DateTimeFormatter>{data.date_exported}</DateTimeFormatter>
             </Timeline.Item>
           ) : null}
         </Timeline>

client/src/components/job-detail-cards/job-detail-cards.documents.component.jsx

@@ -1,8 +1,8 @@
 import { Carousel } from "antd";
 import React from "react";
 import { useTranslation } from "react-i18next";
+import { GenerateThumbUrl } from "../jobs-documents-gallery/job-documents.utility";
 import CardTemplate from "./job-detail-cards.template.component";
-import { DetermineFileType } from "../documents-upload/documents-upload.utility";
 export default function JobDetailCardsDocumentsComponent({ loading, data }) {
   const { t } = useTranslation();
 
@@ -22,15 +22,7 @@ export default function JobDetailCardsDocumentsComponent({ loading, data }) {
       {data.documents.length > 0 ? (
         <Carousel autoplay>
           {data.documents.map((item) => (
-            <img
-              key={item.id}
-              src={`${
-                process.env.REACT_APP_CLOUDINARY_ENDPOINT
-              }/${DetermineFileType(item.type)}/upload/${
-                process.env.REACT_APP_CLOUDINARY_THUMB_TRANSFORMATIONS
-              }/${item.key}`}
-              alt={item.name}
-            />
+            <img key={item.id} src={GenerateThumbUrl(item)} alt={item.name} />
           ))}
         </Carousel>
       ) : (

client/src/components/job-detail-cards/job-detail-cards.template.component.jsx

@@ -12,11 +12,13 @@ export default function JobDetailCardTemplate({
   if (extraLink) extra = { extra: <Link to={extraLink}>More</Link> };
   return (
     <Card
-      size='small'
-      className='job-card'
+      size="small"
+      className="job-card"
       title={title}
       loading={loading}
-      {...extra}>
+      style={{ height: "100%" }}
+      {...extra}
+    >
       {otherProps.children}
     </Card>
   );

client/src/components/job-detail-lines/job-lines.component.jsx

@@ -36,6 +36,8 @@ import JobLinesBillRefernece from "../job-lines-bill-reference/job-lines-bill-re
 // import AllocationsBulkAssignmentContainer from "../allocations-bulk-assignment/allocations-bulk-assignment.container";
 // import AllocationsEmployeeLabelContainer from "../allocations-employee-label/allocations-employee-label.container";
 import PartsOrderModalContainer from "../parts-order-modal/parts-order-modal.container";
+import _ from "lodash";
+import JobCreateIOU from "../job-create-iou/job-create-iou.component";
 
 const mapStateToProps = createStructuredSelector({
   //currentUser: selectCurrentUser
@@ -161,7 +163,11 @@ export function JobLinesComponent({
       ellipsis: true,
       render: (text, record) => (
         <>
-          <CurrencyFormatter>{record.act_price}</CurrencyFormatter>
+          <CurrencyFormatter>
+            {record.db_ref === "900510" || record.db_ref === "900511"
+              ? record.prt_dsmk_m
+              : record.act_price}
+          </CurrencyFormatter>
           {record.prt_dsmk_p && record.prt_dsmk_p !== 0 ? (
             <span
               style={{ marginLeft: ".2rem" }}
@@ -297,7 +303,6 @@ export function JobLinesComponent({
                     variables: { joblineId: record.id },
                     update(cache) {
                       cache.modify({
-                        id: cache.identify(job),
                         fields: {
                           joblines(existingJobLines, { readField }) {
                             return existingJobLines.filter(
@@ -334,10 +339,12 @@ export function JobLinesComponent({
       const markedTypes = [e.key];
       if (e.key === "PAN") markedTypes.push("PAP");
       if (e.key === "PAS") markedTypes.push("PASL");
-      setSelectedLines([
-        ...selectedLines,
-        ...jobLines.filter((item) => markedTypes.includes(item.part_type)),
-      ]);
+      setSelectedLines(
+        _.uniq([
+          ...selectedLines,
+          ...jobLines.filter((item) => markedTypes.includes(item.part_type)),
+        ])
+      );
     }
   };
 
@@ -400,7 +407,7 @@ export function JobLinesComponent({
                 setState({
                   ...state,
                   filteredInfo: {
-                    part_type: ["PAN,PAC,PAR,PAL,PAA,PAM,PAP,PAS,PASL"],
+                    part_type: ["PAN,PAC,PAR,PAL,PAA,PAM,PAP,PAS,PASL,PAG"],
                   },
                 });
               }}
@@ -421,6 +428,7 @@ export function JobLinesComponent({
             >
               {t("joblines.actions.new")}
             </Button>
+            <JobCreateIOU jobid={job.id} selectedJobLines={selectedLines} />
             <Input.Search
               placeholder={t("general.labels.search")}
               onChange={(e) => {
@@ -435,7 +443,7 @@ export function JobLinesComponent({
         columns={columns}
         rowKey="id"
         loading={loading}
-        pagination={{ position: "top", defaultPageSize: 50 }}
+        pagination={false}
         dataSource={jobLines}
         onChange={handleTableChange}
         scroll={{

client/src/components/job-employee-assignments/job-employee-assignments.component.jsx

@@ -37,8 +37,8 @@ export function JobEmployeeAssignments({
   });
   const [visibility, setVisibility] = useState(false);
 
-  const onChange = (e) => {
-    setAssignment({ ...assignment, employeeid: e });
+  const onChange = (value, option) => {
+    setAssignment({ ...assignment, employeeid: value, name: option.name });
   };
 
   const popContent = (
@@ -56,7 +56,11 @@ export function JobEmployeeAssignments({
           }
         >
           {bodyshop.employees.map((emp) => (
-            <Select.Option value={emp.id} key={emp.id}>
+            <Select.Option
+              value={emp.id}
+              key={emp.id}
+              name={`${emp.first_name} ${emp.last_name}`}
+            >
               {`${emp.first_name} ${emp.last_name}`}
             </Select.Option>
           ))}

client/src/components/job-employee-assignments/job-employee-assignments.container.jsx

@@ -6,14 +6,34 @@ import { logImEXEvent } from "../../firebase/firebase.utils";
 import { UPDATE_JOB_ASSIGNMENTS } from "../../graphql/jobs.queries";
 import JobEmployeeAssignmentsComponent from "./job-employee-assignments.component";
 
-export default function JobEmployeeAssignmentsContainer({ job, refetch }) {
+import { connect } from "react-redux";
+import { createStructuredSelector } from "reselect";
+import { insertAuditTrail } from "../../redux/application/application.actions";
+import AuditTrailMapping from "../../utils/AuditTrailMappings";
+const mapStateToProps = createStructuredSelector({
+  //currentUser: selectCurrentUser
+});
+const mapDispatchToProps = (dispatch) => ({
+  insertAuditTrail: ({ jobid, operation }) =>
+    dispatch(insertAuditTrail({ jobid, operation })),
+});
+export default connect(
+  mapStateToProps,
+  mapDispatchToProps
+)(JobEmployeeAssignmentsContainer);
+
+export function JobEmployeeAssignmentsContainer({
+  job,
+  refetch,
+  insertAuditTrail,
+}) {
   const { t } = useTranslation();
   const [updateJob] = useMutation(UPDATE_JOB_ASSIGNMENTS);
   const [loading, setLoading] = useState(false);
 
   const handleAdd = async (assignment) => {
     setLoading(true);
-    const { operation, employeeid } = assignment;
+    const { operation, employeeid, name } = assignment;
     logImEXEvent("job_assign_employee", { operation });
 
     let empAssignment = determineFieldName(operation);
@@ -23,6 +43,11 @@ export default function JobEmployeeAssignmentsContainer({ job, refetch }) {
     });
     if (refetch) refetch();
 
+    insertAuditTrail({
+      jobid: job.id,
+      operation: AuditTrailMapping.jobassignmentchange(operation, name),
+    });
+
     if (!!result.errors) {
       notification["error"]({
         message: t("jobs.errors.assigning", {
@@ -48,6 +73,10 @@ export default function JobEmployeeAssignmentsContainer({ job, refetch }) {
         }),
       });
     }
+    insertAuditTrail({
+      jobid: job.id,
+      operation: AuditTrailMapping.jobassignmentremoved(operation),
+    });
     setLoading(false);
   };
 

client/src/components/job-line-note-popup/job-line-note-popup.component.jsx

@@ -1,5 +1,6 @@
 import React, { useState, useEffect } from "react";
-import { Input, notification } from "antd";
+import { Input, notification, Space } from "antd";
+import { FieldTimeOutlined } from "@ant-design/icons";
 import LoadingSpinner from "../loading-spinner/loading-spinner.component";
 import { useMutation } from "@apollo/client";
 import { UPDATE_JOB_LINE } from "../../graphql/jobs-lines.queries";
@@ -59,6 +60,12 @@ export default function JobLineNotePopup({ jobline, disabled }) {
       style={{ width: "100%", minHeight: "2rem", cursor: "pointer" }}
       onClick={() => !disabled && setEditing(true)}
     >
+      {jobline.ioucreated && (
+        <Space>
+          <FieldTimeOutlined />
+          {t("joblines.labels.ioucreated")}
+        </Space>
+      )}
       {jobline.notes}
     </div>
   );

client/src/components/job-line-status-popup/job-line-status-popup.component.jsx

@@ -72,7 +72,7 @@ export function JobLineStatusPopup({ bodyshop, jobline, disabled }) {
     );
   return (
     <div
-      style={{ width: "100%", minHeight: "2rem", cursor: "pointer" }}
+      style={{ width: "100%", minHeight: "1rem", cursor: "pointer" }}
       onClick={() => !disabled && setEditing(true)}
     >
       {jobline.status}

client/src/components/job-lines-upsert-modal/job-lines-upsert-modal.component.jsx

@@ -1,4 +1,4 @@
-import { Form, Input, InputNumber, Modal, Select } from "antd";
+import { Form, Input, InputNumber, Modal, Select, Switch } from "antd";
 import React, { useEffect } from "react";
 import { useTranslation } from "react-i18next";
 import InputCurrency from "../form-items-formatted/currency-form-item.component";
@@ -115,18 +115,18 @@ export default function JobLinesUpsertModalComponent({
           <Form.Item
             label={t("joblines.fields.mod_lb_hrs")}
             name="mod_lb_hrs"
-            // rules={[
-            //   ({ getFieldValue }) => ({
-            //     validator(rule, value) {
-            //       if (!!getFieldValue("mod_lbr_ty") === !!value) {
-            //         return Promise.resolve();
-            //       }
-            //       return Promise.reject(
-            //         t("joblines.validations.hrsrequirediflbrtyp")
-            //       );
-            //     },
-            //   }),
-            // ]}
+            rules={[
+              ({ getFieldValue }) => ({
+                validator(rule, value) {
+                  if (!!getFieldValue("mod_lbr_ty") === !!value) {
+                    return Promise.resolve();
+                  }
+                  return Promise.reject(
+                    t("joblines.validations.hrsrequirediflbrtyp")
+                  );
+                },
+              }),
+            ]}
           >
             <InputNumber precision={1} />
           </Form.Item>
@@ -169,49 +169,49 @@ export default function JobLinesUpsertModalComponent({
           <Form.Item
             label={t("joblines.fields.part_qty")}
             name="part_qty"
-            // rules={[
-            //   ({ getFieldValue }) => ({
-            //     validator(rule, value) {
-            //       if (!!getFieldValue("part_type") === !!value) {
-            //         return Promise.resolve();
-            //       }
-            //       return Promise.reject(
-            //         t("joblines.validations.requiredifparttype")
-            //       );
-            //     },
-            //   }),
-            // ]}
+            rules={[
+              ({ getFieldValue }) => ({
+                validator(rule, value) {
+                  if (!!getFieldValue("part_type") === !!value) {
+                    return Promise.resolve();
+                  }
+                  return Promise.reject(
+                    t("joblines.validations.requiredifparttype")
+                  );
+                },
+              }),
+            ]}
           >
             <InputNumber precision={0} min={0} />
           </Form.Item>
-          <Form.Item label={t("joblines.fields.db_price")} name="db_price">
+          {/* <Form.Item label={t("joblines.fields.db_price")} name="db_price">
             <InputCurrency precision={2} min={0} />
-          </Form.Item>
+          </Form.Item> */}
           <Form.Item
             label={t("joblines.fields.act_price")}
             name="act_price"
-            // rules={[
-            //   ({ getFieldValue }) => ({
-            //     validator(rule, value) {
-            //       if (!value || getFieldValue("part_type") !== "PAE") {
-            //         return Promise.resolve();
-            //       }
-            //       return Promise.reject(
-            //         t("joblines.validations.zeropriceexistingpart")
-            //       );
-            //     },
-            //   }),
-            //   ({ getFieldValue }) => ({
-            //     validator(rule, value) {
-            //       if (!!getFieldValue("part_type") === !!value) {
-            //         return Promise.resolve();
-            //       }
-            //       return Promise.reject(
-            //         t("joblines.validations.requiredifparttype")
-            //       );
-            //     },
-            //   }),
-            // ]}
+            rules={[
+              ({ getFieldValue }) => ({
+                validator(rule, value) {
+                  if (!value || getFieldValue("part_type") !== "PAE") {
+                    return Promise.resolve();
+                  }
+                  return Promise.reject(
+                    t("joblines.validations.zeropriceexistingpart")
+                  );
+                },
+              }),
+              ({ getFieldValue }) => ({
+                validator(rule, value) {
+                  if (!!getFieldValue("part_type") === !!value) {
+                    return Promise.resolve();
+                  }
+                  return Promise.reject(
+                    t("joblines.validations.requiredifparttype")
+                  );
+                },
+              }),
+            ]}
           >
             <InputCurrency precision={2} min={0} />
           </Form.Item>
@@ -222,6 +222,14 @@ export default function JobLinesUpsertModalComponent({
           >
             <InputNumber precision={0} min={0} max={100} />
           </Form.Item>
+          <Form.Item
+            label={t("joblines.fields.tax_part")}
+            name="tax_part"
+            valuePropName="checked"
+            initialValue={true}
+          >
+            <Switch />
+          </Form.Item>
         </LayoutFormRow>
       </Form>
     </Modal>

client/src/components/job-lines-upsert-modal/job-lines-upsert-modal.container.jsx

@@ -44,6 +44,7 @@ function JobLinesUpsertModalContainer({
             },
           ],
         },
+        refetchQueries: ["GET_LINE_TICKET_BY_PK"],
       });
       if (!r.errors) {
         await Axios.post("/job/totalsssu", {
@@ -69,6 +70,7 @@ function JobLinesUpsertModalContainer({
           lineId: jobLineEditModal.context.id,
           line: values,
         },
+        refetchQueries: ["GET_LINE_TICKET_BY_PK"],
       });
       if (!r.errors) {
         notification["success"]({

client/src/components/job-payments/job-payments.component.jsx

@@ -1,4 +1,5 @@
 import { Button, Card, Space, Table } from "antd";
+import { EditFilled } from "@ant-design/icons";
 import Dinero from "dinero.js";
 import React, { useMemo, useState } from "react";
 import { useTranslation } from "react-i18next";
@@ -115,16 +116,29 @@ export function JobPayments({
       dataIndex: "actions",
       key: "actions",
       render: (text, record) => (
-        <PrintWrapperComponent
-          templateObject={{
-            name: TemplateList("payment").payment_receipt.key,
-            variables: { id: record.id },
-          }}
-          messageObject={{
-            to: job.ownr_ea,
-          }}
-          id={job.id}
-        />
+        <Space wrap>
+          <Button
+            disabled={record.exportedat}
+            onClick={() => {
+              setPaymentContext({
+                actions: { refetch: refetch },
+                context: record,
+              });
+            }}
+          >
+            <EditFilled />
+          </Button>
+          <PrintWrapperComponent
+            templateObject={{
+              name: TemplateList("payment").payment_receipt.key,
+              variables: { id: record.id },
+            }}
+            messageObject={{
+              to: job.ownr_ea,
+            }}
+            id={job.id}
+          />
+        </Space>
       ),
     },
   ];

client/src/components/job-reconciliation-bills-table/job-reconciliation-bills-table.component.jsx

@@ -1,4 +1,4 @@
-import { Checkbox, PageHeader, Table } from "antd";
+import { Checkbox, Table, Typography } from "antd";
 import React, { useState } from "react";
 import { useTranslation } from "react-i18next";
 import CurrencyFormatter from "../../utils/CurrencyFormatter";
@@ -21,6 +21,8 @@ export default function JobReconciliationBillsTable({
       title: t("billlines.fields.line_desc"),
       dataIndex: "line_desc",
       key: "line_desc",
+      ellipsis: true,
+      minWidth: "65rem",
       sorter: (a, b) => alphaSort(a.line_desc, b.line_desc),
       sortOrder:
         state.sortedInfo.columnKey === "line_desc" && state.sortedInfo.order,
@@ -29,6 +31,8 @@ export default function JobReconciliationBillsTable({
       title: t("billlines.labels.from"),
       dataIndex: "from",
       key: "from",
+
+      ellipsis: true,
       render: (text, record) =>
         `${record.bill.vendor && record.bill.vendor.name} / ${
           record.bill.invoice_number
@@ -39,6 +43,7 @@ export default function JobReconciliationBillsTable({
       dataIndex: "actual_price",
       key: "actual_price",
       sorter: (a, b) => a.actual_price - b.actual_price,
+      width: "7rem",
       sortOrder:
         state.sortedInfo.columnKey === "actual_price" && state.sortedInfo.order,
       render: (text, record) => (
@@ -50,6 +55,7 @@ export default function JobReconciliationBillsTable({
       dataIndex: "actual_cost",
       key: "actual_cost",
       sorter: (a, b) => a.actual_cost - b.actual_cost,
+      width: "7rem",
       sortOrder:
         state.sortedInfo.columnKey === "actual_cost" && state.sortedInfo.order,
       render: (text, record) => (
@@ -57,10 +63,11 @@ export default function JobReconciliationBillsTable({
       ),
     },
     {
-      title: t("billlines.fields.quantity"),
+      title: t("joblines.fields.part_qty"),
       dataIndex: "quantity",
       key: "quantity",
       sorter: (a, b) => a.quantity - b.quantity,
+      width: "4rem",
       sortOrder:
         state.sortedInfo.columnKey === "quantity" && state.sortedInfo.order,
     },
@@ -69,9 +76,11 @@ export default function JobReconciliationBillsTable({
       dataIndex: "is_credit_memo",
       key: "is_credit_memo",
       sorter: (a, b) => a.bill.is_credit_memo - b.bill.is_credit_memo,
+      width: "8rem",
       sortOrder:
         state.sortedInfo.columnKey === "is_credit_memo" &&
         state.sortedInfo.order,
+
       render: (text, record) => (
         <Checkbox disabled checked={record.bill.is_credit_memo} />
       ),
@@ -86,10 +95,12 @@ export default function JobReconciliationBillsTable({
   };
 
   return (
-    <PageHeader title={t("bills.labels.bills")}>
+    <div>
+      <Typography.Title level={4}>{t("bills.labels.bills")}</Typography.Title>
       <Table
         pagination={false}
-        scroll={{ y: "40vh", x: true }}
+        size="small"
+        scroll={{ y: "60vh" }}
         columns={columns}
         rowKey="id"
         dataSource={invoiceLineData}
@@ -97,8 +108,11 @@ export default function JobReconciliationBillsTable({
         rowSelection={{
           onChange: handleOnRowClick,
           selectedRowKeys: selectedLines,
+          getCheckboxProps: (record) => {
+            return { disabled: record.deductedfromlbr };
+          },
         }}
       />
-    </PageHeader>
+    </div>
   );
 }

client/src/components/job-reconciliation-modal/job-reconciliation-modal.component.jsx

@@ -22,21 +22,23 @@ export default function JobReconciliationModalComponent({ job, bills }) {
   );
 
   return (
-    <div>
-      <Row gutter={[16, 16]}>
-        <Col span={12}>
-          <JobReconciliationPartsTable
-            jobLineData={jobLineData}
-            jobLineState={jobLineState}
-          />
-        </Col>
-        <Col span={12}>
-          <JobReconciliationBillsTable
-            invoiceLineData={invoiceLineData}
-            billLineState={billLineState}
-          />
-        </Col>
-      </Row>
+    <div style={{ flex: 1, display: "flex", flexDirection: "column" }}>
+      <div style={{ flex: 1 }}>
+        <Row gutter={8}>
+          <Col span={12}>
+            <JobReconciliationPartsTable
+              jobLineData={jobLineData}
+              jobLineState={jobLineState}
+            />
+          </Col>
+          <Col span={12}>
+            <JobReconciliationBillsTable
+              invoiceLineData={invoiceLineData}
+              billLineState={billLineState}
+            />
+          </Col>
+        </Row>
+      </div>
       <Row>
         <JobReconciliationTotals
           jobLines={jobLineData}

client/src/components/job-reconciliation-modal/job-reconciliation-modal.styles.scss

@@ -0,0 +1,12 @@
+.imex-reconciliation-modal {
+  top: 20px;
+  // .ant-modal-content {
+  //   height: 95vh;
+  //   display: flex;
+  //   flex-direction: column;
+  //   .ant-modal-body {
+  //     display: flex;
+  //     flex: 1;
+  //   }
+  // }
+}

client/src/components/job-reconciliation-modal/job-reconciliation.modal.container.jsx

@@ -10,6 +10,7 @@ import { selectReconciliation } from "../../redux/modals/modals.selectors";
 import JobReconciliationModalComponent from "./job-reconciliation-modal.component";
 import LoadingSpinner from "../loading-spinner/loading-spinner.component";
 import AlertComponent from "../alert/alert.component";
+import "./job-reconciliation-modal.styles.scss";
 
 const mapStateToProps = createStructuredSelector({
   reconciliationModal: selectReconciliation,
@@ -38,23 +39,23 @@ function JobReconciliationModalContainer({
   return (
     <Modal
       title={t("jobs.labels.reconciliationheader")}
-      width={"90%"}
+      width={"95%"}
       visible={visible}
       okText={t("general.actions.close")}
       onOk={handleCancel}
       onCancel={handleCancel}
       cancelButtonProps={{ display: "none" }}
       destroyOnClose
+      className="imex-reconciliation-modal"
     >
-      <LoadingSpinner loading={loading}>
-        {error && <AlertComponent message={error.message} type="error" />}
-        {data && (
-          <JobReconciliationModalComponent
-            job={data && data.jobs_by_pk}
-            bills={data && data.bills}
-          />
-        )}
-      </LoadingSpinner>
+      {loading && <LoadingSpinner loading={loading} />}
+      {error && <AlertComponent message={error.message} type="error" />}
+      {data && (
+        <JobReconciliationModalComponent
+          job={data && data.jobs_by_pk}
+          bills={data && data.bills}
+        />
+      )}
     </Modal>
   );
 }