Search in sources :

Example 11 with Note

use of org.kuali.kfs.krad.bo.Note in project cu-kfs by CU-CommunityApps.

the class CuB2BPurchaseOrderSciquestServiceImpl method getCxml.

public String getCxml(PurchaseOrderDocument purchaseOrder, String requisitionInitiatorPrincipalId, String password, ContractManager contractManager, String contractManagerEmail, String vendorDuns, boolean includeNewFields) {
    WorkflowDocument workFlowDocument = purchaseOrder.getDocumentHeader().getWorkflowDocument();
    String documentType = workFlowDocument.getDocumentTypeName();
    // KFSUPGRADE-1458 complete the potransmission enhancement
    int disbMethod = 0;
    String poTransmissionCode = purchaseOrder.getPurchaseOrderTransmissionMethodCode();
    if (PurapConstants.POTransmissionMethods.FAX.equalsIgnoreCase(poTransmissionCode)) {
        // fax
        disbMethod = FAX;
    } else if (CUPurapConstants.POTransmissionMethods.EMAIL.equalsIgnoreCase(poTransmissionCode)) {
        // email
        disbMethod = EMAIL;
    } else if (CUPurapConstants.POTransmissionMethods.CONVERSION.equalsIgnoreCase(poTransmissionCode)) {
        // conversion
        disbMethod = CONVERSION;
    } else {
        // manual
        disbMethod = MANUAL;
    }
    StringBuffer cxml = new StringBuffer();
    List<Note> notesToSendToVendor = getNotesToSendToVendor(purchaseOrder);
    // comment out for investigation
    if (CollectionUtils.isNotEmpty(notesToSendToVendor)) {
        cxml.append("--" + CUPurapConstants.MIME_BOUNDARY_FOR_ATTACHMENTS + "\r\n");
        cxml.append("Content-Type: application/xop+xml;\r\n");
        cxml.append("        charset=\"UTF-8\";\r\n");
        cxml.append("        type=\"text/xml\"\r\n");
        cxml.append("Content-Transfer-Encoding: 8bit\r\n");
        cxml.append("Content-ID: <1222711868656.6893160141700477326@sciquest.com>\r\n");
        // blank line before part
        cxml.append("\r\n");
    }
    cxml.append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");
    cxml.append("<!DOCTYPE PurchaseOrderMessage SYSTEM \"PO.dtd\">\n");
    cxml.append("<PurchaseOrderMessage version=\"2.0\">\n");
    cxml.append("  <Header>\n");
    // MessageId - can be whatever you would like it to be. Just make it unique.
    cxml.append("    <MessageId>KFS_cXML_PO</MessageId>\n");
    // Timestamp - it doesn't matter what's in the timezone, just that it's there (need "T" space between date/time)
    Date d = SpringContext.getBean(DateTimeService.class).getCurrentDate();
    SimpleDateFormat date = PurApDateFormatUtils.getSimpleDateFormat(PurapConstants.NamedDateFormats.CXML_SIMPLE_DATE_FORMAT);
    SimpleDateFormat time = PurApDateFormatUtils.getSimpleDateFormat(PurapConstants.NamedDateFormats.CXML_SIMPLE_TIME_FORMAT);
    cxml.append("    <Timestamp>").append(date.format(d)).append("T").append(time.format(d)).append("+05:30").append("</Timestamp>\n");
    cxml.append("    <Authentication>\n");
    // Cu is using useragent
    // cxml.append("      <Identity>").append(getB2bPurchaseOrderIdentity()).append("</Identity>\n");
    cxml.append("      <Identity>").append(getB2bUserAgent()).append("</Identity>\n");
    cxml.append("      <SharedSecret>").append(password).append("</SharedSecret>\n");
    cxml.append("    </Authentication>\n");
    cxml.append("  </Header>\n");
    cxml.append("  <PurchaseOrder>\n");
    // void = VOPE      ammend = CGIN ?   ammend should =
    if (StringUtils.equals(workFlowDocument.getApplicationDocumentStatus(), PurapConstants.PurchaseOrderStatuses.APPDOC_PENDING_VOID) || documentType.equalsIgnoreCase(PurapConstants.PurchaseOrderDocTypes.PURCHASE_ORDER_VOID_DOCUMENT)) {
        cxml.append("    <POHeader type=\"cancel\">\n");
        // KFSPTS-1458 -- otherwise distribute revision tag needs to be true (for "Fax", "Email", and "US Mail"=manual mopot).
        if (disbMethod == CONVERSION) {
            cxml.append("    <DistributeRevision>false</DistributeRevision>\n");
        } else {
            // FAX, EMAIL, MANUAL=US Mail
            cxml.append("    <DistributeRevision>true</DistributeRevision>\n");
        }
    } else if (documentType.equals(PurapConstants.PurchaseOrderDocTypes.PURCHASE_ORDER_AMENDMENT_DOCUMENT)) {
        cxml.append("    <POHeader type=\"update\">\n");
        // KFSPTS-1458 -- otherwise distribute revision tag needs to be true (for "Fax", "Email", and "US Mail"=manual mopot).
        if (disbMethod == CONVERSION) {
            cxml.append("    <DistributeRevision>false</DistributeRevision>\n");
        } else {
            // FAX, EMAIL, MANUAL=US Mail
            cxml.append("    <DistributeRevision>true</DistributeRevision>\n");
        }
    } else {
        cxml.append("    <POHeader>\n");
    }
    cxml.append("      <PONumber>").append(purchaseOrder.getPurapDocumentIdentifier()).append("</PONumber>\n");
    cxml.append("      <Requestor>\n");
    cxml.append("        <UserProfile username=\"").append(requisitionInitiatorPrincipalId.toUpperCase()).append("\">\n");
    cxml.append("        </UserProfile>\n");
    cxml.append("      </Requestor>\n");
    cxml.append("      <Priority>High</Priority>\n");
    cxml.append("      <AccountingDate>").append(purchaseOrder.getPurchaseOrderCreateTimestamp()).append("</AccountingDate>\n");
    // Provide DUNS number and SupplierNumber if vendor is B2B
    if (purchaseOrder.getVendorContract() != null && purchaseOrder.getVendorContract().getVendorB2bIndicator() && disbMethod != CONVERSION) {
        /**
         *** SUPPLIER SECTION ****
         */
        cxml.append("      <Supplier>\n");
        cxml.append("        <DUNS>").append(vendorDuns).append("</DUNS>\n");
        cxml.append("        <SupplierNumber>").append(purchaseOrder.getVendorNumber()).append("</SupplierNumber>\n");
        // Type attribute is required. Valid values: main and technical. Only main will be considered for POImport.
        cxml.append("        <ContactInfo type=\"main\">\n");
        // TelephoneNumber is required. With all fields, only numeric digits will be stored. Non-numeric characters are allowed, but
        // will be stripped before storing.
        cxml.append("          <Phone>\n");
        cxml.append("            <TelephoneNumber>\n");
        cxml.append("              <CountryCode>1</CountryCode>\n");
        if (contractManager.getContractManagerPhoneNumber().length() > 4) {
            cxml.append("              <AreaCode>").append(contractManager.getContractManagerPhoneNumber().substring(0, 3)).append("</AreaCode>\n");
            cxml.append("              <Number>").append(contractManager.getContractManagerPhoneNumber().substring(3)).append("</Number>\n");
        } else {
            LOG.error("getCxml() The phone number is invalid for this contract manager: " + contractManager.getContractManagerUserIdentifier() + " " + contractManager.getContractManagerName());
            cxml.append("              <AreaCode>555</AreaCode>\n");
            cxml.append("              <Number>").append(contractManager.getContractManagerPhoneNumber()).append("</Number>\n");
        }
        cxml.append("            </TelephoneNumber>\n");
        cxml.append("          </Phone>\n");
        cxml.append("        </ContactInfo>\n");
        cxml.append("      </Supplier>\n");
    // Only pass address and distribution method if vendor is non-B2B
    } else {
        /**
         *** SUPPLIER SECTION ****
         */
        cxml.append("      <Supplier>\n");
        cxml.append("        <Name><![CDATA[").append(purchaseOrder.getVendorName()).append("]]></Name>\n");
        // Type attribute is required. Valid values: main and technical. Only main will be considered for POImport.
        cxml.append("        <ContactInfo type=\"main\">\n");
        // TelephoneNumber is required. With all fields, only numeric digits will be stored. Non-numeric characters are allowed, but
        // will be stripped before storing.
        cxml.append("          <Phone>\n");
        cxml.append("            <TelephoneNumber>\n");
        cxml.append("              <CountryCode>1</CountryCode>\n");
        if (StringUtils.isNotEmpty(purchaseOrder.getVendorPhoneNumber()) && purchaseOrder.getVendorPhoneNumber().length() > 4) {
            cxml.append("              <AreaCode>").append(purchaseOrder.getVendorPhoneNumber().substring(0, 3)).append("</AreaCode>\n");
            cxml.append("              <Number>").append(purchaseOrder.getVendorPhoneNumber().substring(3)).append("</Number>\n");
        } else {
            cxml.append("              <AreaCode>000</AreaCode>\n");
            cxml.append("              <Number>-000-0000</Number>\n");
        }
        cxml.append("            </TelephoneNumber>\n");
        cxml.append("          </Phone>\n");
        cxml.append("          <ContactAddress>\n");
        if (StringUtils.isNotEmpty(purchaseOrder.getVendorLine1Address())) {
            cxml.append("          <AddressLine label=\"Street1\" linenumber=\"1\"><![CDATA[").append(purchaseOrder.getVendorLine1Address()).append("]]></AddressLine>\n");
        }
        if (StringUtils.isNotEmpty(purchaseOrder.getVendorLine2Address())) {
            cxml.append("          <AddressLine label=\"Street2\" linenumber=\"2\"><![CDATA[").append(purchaseOrder.getVendorLine2Address()).append("]]></AddressLine>\n");
        }
        if (StringUtils.isNotEmpty(purchaseOrder.getVendorStateCode())) {
            cxml.append("          <State>").append(purchaseOrder.getBillingStateCode()).append("</State>\n");
        }
        if (StringUtils.isNotEmpty(purchaseOrder.getVendorPostalCode())) {
            cxml.append("          <PostalCode>").append(purchaseOrder.getBillingPostalCode()).append("</PostalCode>\n");
        }
        if (StringUtils.isNotEmpty(purchaseOrder.getVendorCountryCode())) {
            cxml.append("          <Country isocountrycode=\"").append(purchaseOrder.getBillingCountryCode()).append("\">").append(purchaseOrder.getBillingCountryCode()).append("</Country>\n");
        }
        cxml.append("          </ContactAddress>\n");
        cxml.append("        </ContactInfo>\n");
        cxml.append("      </Supplier>\n");
        /**
         *** DISTRIBUTION SECTION ***
         */
        VendorAddress vendorAddress = SpringContext.getBean(VendorService.class).getVendorDefaultAddress(purchaseOrder.getVendorDetail().getVendorAddresses(), VendorConstants.AddressTypes.PURCHASE_ORDER, purchaseOrder.getDeliveryCampusCode());
        cxml.append("      <OrderDistribution>\n");
        // first take fax from PO, if empty then get fax number for PO default vendor address
        String vendorFaxNumber = purchaseOrder.getVendorFaxNumber();
        if (StringUtils.isBlank(vendorFaxNumber) && vendorAddress != null) {
            vendorFaxNumber = vendorAddress.getVendorFaxNumber();
        }
        // KFSPTS-1458 -- code existing prior to this change is commented out below.
        // KFSPTS-1458 -- new code should model how fax number is determined:
        // KFSPTS-1458 -- first take vendor email address from PO, if empty then get vendor email address from PO default vendor address
        // String emailAddress = "";
        // if (vendorAddress != null) {
        // emailAddress = vendorAddress.getVendorAddressEmailAddress();
        // }
        String emailAddress = purchaseOrder.getVendorEmailAddress();
        if (StringUtils.isBlank(emailAddress) && vendorAddress != null) {
            emailAddress = vendorAddress.getVendorAddressEmailAddress();
        }
        // Distribution Method
        switch(disbMethod) {
            case FAX:
                // fax
                cxml.append("        <DistributionMethod type=\"fax\">\n");
                cxml.append("          <Fax>\n");
                cxml.append("            <TelephoneNumber>\n");
                cxml.append("              <CountryCode>1</CountryCode>\n");
                cxml.append("              <AreaCode>").append(vendorFaxNumber.substring(0, 3)).append("</AreaCode>\n");
                cxml.append("              <Number>").append(vendorFaxNumber.substring(3)).append("</Number>\n");
                cxml.append("            </TelephoneNumber>\n");
                cxml.append("          </Fax>\n");
                break;
            case EMAIL:
                // email
                cxml.append("        <DistributionMethod type=\"html_email_attachments\">\n");
                cxml.append("          <Email><![CDATA[").append(emailAddress).append("]]></Email>\n");
                break;
            case CONVERSION:
                // conversion
                // KFSPTS-1458 : removed logic that was temp mopot for conversion.
                // /**
                // * Temporary method of distribution for PO conversion effort.  Will be short-lived, so we
                // * didn't bother setting up constants and parameters to store the email, but rather hard-
                // * coded the email address.
                // */
                // cxml.append("        <DistributionMethod type=\"html_email_attachments\">\n");
                // cxml.append("          <Email><![CDATA[").append("db18@cornell.edu").append("]]></Email>\n");
                // 
                // KFSPTS-1458: replaced temp logic with distribution method type of manual
                cxml.append("        <DistributionMethod type=\"manual\">\n");
                break;
            default:
                // manual
                // KFSPTS-1458 removed: cxml.append("        <DistributionMethod type=\"manual\">\n");
                // 
                // KFSPTS-1458: US Mail = manual should be sent to EGA email address
                // KFSPTS-1458: Replaced hard coded email address with parameterized email address.
                cxml.append("        <DistributionMethod type=\"html_email_attachments\">\n");
                cxml.append("          <Email><![CDATA[").append(this.getMethodOfPOTransmissionConversionEmail()).append("]]></Email>\n");
                break;
        }
        cxml.append("        </DistributionMethod>\n");
        cxml.append("      </OrderDistribution>\n");
    }
    /**
     *** BILL TO SECTION ****
     */
    cxml.append("      <BillTo>\n");
    cxml.append("        <Address>\n");
    cxml.append("          <TemplateName>Bill To</TemplateName>\n");
    cxml.append("          <AddressCode>").append(purchaseOrder.getDeliveryCampusCode()).append("</AddressCode>\n");
    // Contact - There can be 0-5 Contact elements. The label attribute is optional.
    // TODO : this may cause sequence error from SQ if email is empty, then it will send sequence of 1,2,3,5.
    // in CU 3.0.1, it only sends billingphone#
    // cxml.append("          <Contact label=\"FirstName\" linenumber=\"1\"><![CDATA[Accounts]]></Contact>\n");
    // cxml.append("          <Contact label=\"LastName\" linenumber=\"2\"><![CDATA[Payable]]></Contact>\n");
    // cxml.append("          <Contact label=\"Company\" linenumber=\"3\"><![CDATA[").append(purchaseOrder.getBillingName().trim()).append("]]></Contact>\n");
    // // since email address is not required, we need to check whether its empty; if yes, don't add it
    // if (!StringUtils.isEmpty(purchaseOrder.getBillingEmailAddress())) {
    // cxml.append("          <Contact label=\"Email\" linenumber=\"4\"><![CDATA[").append(purchaseOrder.getBillingEmailAddress().trim()).append("]]></Contact>\n");
    // }
    // since phone number is not required, we need to check whether its empty; if yes, don't add it
    // if (!StringUtils.isEmpty(purchaseOrder.getBillingPhoneNumber())) {
    // cxml.append("          <Contact label=\"Phone\" linenumber=\"5\"><![CDATA[").append(purchaseOrder.getBillingPhoneNumber().trim()).append("]]></Contact>\n");
    cxml.append("          <Contact label=\"Phone\" linenumber=\"1\"><![CDATA[").append(purchaseOrder.getBillingPhoneNumber().trim()).append("]]></Contact>\n");
    // }
    // There must be 1-5 AddressLine elements. The label attribute is optional.
    cxml.append("          <AddressLine label=\"Street1\" linenumber=\"1\"><![CDATA[").append(purchaseOrder.getBillingLine1Address()).append("]]></AddressLine>\n");
    cxml.append("          <AddressLine label=\"Street2\" linenumber=\"2\"><![CDATA[").append(purchaseOrder.getBillingLine2Address()).append("]]></AddressLine>\n");
    // Required.
    cxml.append("          <City><![CDATA[").append(purchaseOrder.getBillingCityName()).append("]]></City>\n");
    cxml.append("          <State>").append(purchaseOrder.getBillingStateCode()).append("</State>\n");
    // Required.
    cxml.append("          <PostalCode>").append(purchaseOrder.getBillingPostalCode()).append("</PostalCode>\n");
    cxml.append("          <Country isocountrycode=\"").append(purchaseOrder.getBillingCountryCode()).append("\">").append(purchaseOrder.getBillingCountryCode()).append("</Country>\n");
    cxml.append("        </Address>\n");
    cxml.append("      </BillTo>\n");
    /**
     *** SHIP TO SECTION ****
     */
    cxml.append("      <ShipTo>\n");
    cxml.append("        <Address>\n");
    cxml.append("          <TemplateName>Ship To</TemplateName>\n");
    // AddressCode. A code to identify the address, that is sent to the supplier.
    cxml.append("          <AddressCode>").append(purchaseOrder.getDeliveryBuildingCode()).append("</AddressCode>\n");
    cxml.append("          <Contact label=\"Name\" linenumber=\"1\"><![CDATA[").append(purchaseOrder.getDeliveryToName().trim()).append("]]></Contact>\n");
    cxml.append("          <Contact label=\"PurchasingEmail\" linenumber=\"2\"><![CDATA[").append(contractManagerEmail).append("]]></Contact>\n");
    if (ObjectUtils.isNotNull(purchaseOrder.getInstitutionContactEmailAddress())) {
        cxml.append("          <Contact label=\"ContactEmail\" linenumber=\"3\"><![CDATA[").append(purchaseOrder.getInstitutionContactEmailAddress()).append("]]></Contact>\n");
    } else {
        cxml.append("          <Contact label=\"ContactEmail\" linenumber=\"3\"><![CDATA[").append(purchaseOrder.getRequestorPersonEmailAddress()).append("]]></Contact>\n");
    }
    if (ObjectUtils.isNotNull(purchaseOrder.getInstitutionContactPhoneNumber())) {
        cxml.append("          <Contact label=\"Phone\" linenumber=\"4\"><![CDATA[").append(purchaseOrder.getInstitutionContactPhoneNumber().trim()).append("]]></Contact>\n");
    } else {
        cxml.append("          <Contact label=\"Phone\" linenumber=\"4\"><![CDATA[").append(purchaseOrder.getRequestorPersonPhoneNumber()).append("]]></Contact>\n");
    }
    // check indicator to decide if receiving or delivery address should be sent to the vendor
    if (purchaseOrder.getAddressToVendorIndicator()) {
        // use receiving address
        cxml.append("          <AddressLine label=\"Street1\" linenumber=\"1\"><![CDATA[").append(purchaseOrder.getReceivingName().trim()).append("]]></AddressLine>\n");
        cxml.append("          <AddressLine label=\"Street2\" linenumber=\"2\"><![CDATA[").append(purchaseOrder.getReceivingLine1Address().trim()).append("]]></AddressLine>\n");
        if (ObjectUtils.isNull(purchaseOrder.getReceivingLine2Address())) {
            cxml.append("          <AddressLine label=\"Street3\" linenumber=\"3\"><![CDATA[").append(" ").append("]]></AddressLine>\n");
        } else {
            cxml.append("          <AddressLine label=\"Street3\" linenumber=\"3\"><![CDATA[").append(purchaseOrder.getReceivingLine2Address()).append("]]></AddressLine>\n");
        }
        cxml.append("          <City><![CDATA[").append(purchaseOrder.getReceivingCityName().trim()).append("]]></City>\n");
        cxml.append("          <State>").append(purchaseOrder.getReceivingStateCode()).append("</State>\n");
        cxml.append("          <PostalCode>").append(purchaseOrder.getReceivingPostalCode()).append("</PostalCode>\n");
        cxml.append("          <Country isocountrycode=\"").append(purchaseOrder.getReceivingCountryCode()).append("\">").append(purchaseOrder.getReceivingCountryCode()).append("</Country>\n");
    } else {
        // use final delivery address
        /* replaced this with getBuildingLine so institutions can customize what info they need on this line
            if (StringUtils.isNotEmpty(purchaseOrder.getDeliveryBuildingName())) {
                cxml.append("          <Contact label=\"Building\" linenumber=\"5\"><![CDATA[").append(purchaseOrder.getDeliveryBuildingName()).append(" (").append(purchaseOrder.getDeliveryBuildingCode()).append(")]]></Contact>\n");
            }
            */
        cxml.append(getBuildingLine(purchaseOrder));
        cxml.append("          <AddressLine label=\"Street1\" linenumber=\"1\"><![CDATA[").append(purchaseOrder.getDeliveryBuildingLine1Address().trim()).append("]]></AddressLine>\n");
        cxml.append("          <AddressLine label=\"Street2\" linenumber=\"2\"><![CDATA[Room #").append(purchaseOrder.getDeliveryBuildingRoomNumber().trim()).append("]]></AddressLine>\n");
        cxml.append("          <AddressLine label=\"Company\" linenumber=\"4\"><![CDATA[").append(purchaseOrder.getBillingName().trim()).append("]]></AddressLine>\n");
        if (ObjectUtils.isNull(purchaseOrder.getDeliveryBuildingLine2Address())) {
            cxml.append("          <AddressLine label=\"Street3\" linenumber=\"3\"><![CDATA[").append(" ").append("]]></AddressLine>\n");
        } else {
            cxml.append("          <AddressLine label=\"Street3\" linenumber=\"3\"><![CDATA[").append(purchaseOrder.getDeliveryBuildingLine2Address()).append("]]></AddressLine>\n");
        }
        cxml.append("          <City><![CDATA[").append(purchaseOrder.getDeliveryCityName().trim()).append("]]></City>\n");
        cxml.append("          <State>").append(purchaseOrder.getDeliveryStateCode()).append("</State>\n");
        cxml.append("          <PostalCode>").append(purchaseOrder.getDeliveryPostalCode()).append("</PostalCode>\n");
        cxml.append("          <Country isocountrycode=\"").append(purchaseOrder.getDeliveryCountryCode()).append("\">").append(purchaseOrder.getDeliveryCountryCode()).append("</Country>\n");
    }
    cxml.append("        </Address>\n");
    cxml.append("      </ShipTo>\n");
    // KFSUPGRADE-408
    // Get payment terms for the PO
    String payTermCode = purchaseOrder.getVendorPaymentTermsCode();
    if (StringUtils.isBlank(payTermCode)) {
        // Retrieve the vendor and pull the payment terms from the vendor record if the PO terms are null
        VendorDetail poVendor = SpringContext.getBean(VendorService.class).getByVendorNumber(purchaseOrder.getVendorNumber());
        payTermCode = poVendor.getVendorPaymentTermsCode();
    }
    PaymentTermType payTerm = SpringContext.getBean(BusinessObjectService.class).findBySinglePrimaryKey(PaymentTermType.class, payTermCode);
    cxml.append("      <PaymentInfo>\n");
    cxml.append("        <Terms>\n");
    if (payTerm.getVendorPaymentTermsPercent().doubleValue() > 0.0) {
        cxml.append("          <Discount>").append(payTerm.getVendorPaymentTermsPercent()).append("</Discount>\n");
    }
    if (payTerm.getVendorDiscountDueNumber().doubleValue() > 0.0) {
        cxml.append("          <Days>").append(payTerm.getVendorDiscountDueNumber()).append("</Days>\n");
    }
    cxml.append("          <Net>").append(payTerm.getVendorNetDueNumber()).append("</Net>\n");
    cxml.append("        </Terms>\n");
    cxml.append("      </PaymentInfo>\n");
    // List<Note> notesToSendToVendor = getNotesToSendToVendor(purchaseOrder);
    if (!notesToSendToVendor.isEmpty()) {
        String allNotes = "";
        String allNotesNoAttach = "";
        String vendorNoteText = purchaseOrder.getVendorNoteText();
        if (ObjectUtils.isNotNull(vendorNoteText)) {
            allNotesNoAttach = vendorNoteText;
        }
        cxml.append("      <ExternalInfo>\n");
        for (int i = 0; i < notesToSendToVendor.size(); i++) {
            Note note = notesToSendToVendor.get(i);
            Attachment attachment = SpringContext.getBean(AttachmentService.class).getAttachmentByNoteId(note.getNoteIdentifier());
            if (ObjectUtils.isNotNull(attachment)) {
                allNotes = allNotes + "\n(" + (i + 1) + ") " + note.getNoteText() + "  ";
            } else {
                allNotesNoAttach = allNotesNoAttach + "          " + note.getNoteText() + "          ";
            }
        }
        cxml.append("          <Note><![CDATA[" + allNotesNoAttach + "          " + allNotes + "]]></Note>\n");
        cxml.append("        <Attachments xmlns:xop = \"http://www.w3.org/2004/08/xop/include/\" >\n");
        for (int i = 0; i < notesToSendToVendor.size(); i++) {
            Note note = notesToSendToVendor.get(i);
            Attachment attachment = SpringContext.getBean(AttachmentService.class).getAttachmentByNoteId(note.getNoteIdentifier());
            if (ObjectUtils.isNotNull(attachment)) {
                cxml.append("          <Attachment id=\"" + attachment.getAttachmentIdentifier() + "\" type=\"file\">\n");
                cxml.append("            <AttachmentName><![CDATA[" + attachment.getAttachmentFileName() + "]]></AttachmentName>\n");
                cxml.append("            <AttachmentURL>http://usertest.sciquest.com/apps/Router/ReqAttachmentDownload?AttachmentId=" + attachment.getAttachmentIdentifier() + "&amp;DocId=" + purchaseOrder.getPurapDocumentIdentifier() + "&amp;OrgName=SQSupportTest&amp;AuthMethod=Local</AttachmentURL>\n");
                cxml.append("            <AttachmentSize>" + attachment.getAttachmentFileSize() / 1024 + "</AttachmentSize>\n");
                cxml.append("            <xop:Include href=\"cid:" + attachment.getAttachmentIdentifier() + "@sciquest.com\" />\n");
                cxml.append("          </Attachment>\n");
            }
        }
        cxml.append("        </Attachments>\n");
        cxml.append("      </ExternalInfo>\n");
    } else {
        String vendorNoteText = purchaseOrder.getVendorNoteText();
        if (ObjectUtils.isNotNull(vendorNoteText)) {
            cxml.append("      <ExternalInfo>\n");
            cxml.append("        <Note><![CDATA[").append(vendorNoteText).append("]]></Note>\n");
            cxml.append("      </ExternalInfo>\n");
        }
    }
    /*KFSPTS-794: End new code: Define the attachments */
    cxml.append("      <CustomFieldValueSet label=\"Contact Name\" name=\"InitiatorName\">\n");
    cxml.append("        <CustomFieldValue>\n");
    if (ObjectUtils.isNotNull(purchaseOrder.getInstitutionContactName())) {
        cxml.append("          <Value><![CDATA[").append(purchaseOrder.getInstitutionContactName()).append("]]></Value>\n");
    } else {
        cxml.append("          <Value><![CDATA[").append(purchaseOrder.getRequestorPersonName()).append("]]></Value>\n");
    }
    cxml.append("         </CustomFieldValue>\n");
    cxml.append("      </CustomFieldValueSet>\n");
    cxml.append("      <CustomFieldValueSet label=\"Supplier Address\" name=\"SupplierAddress1\">\n");
    cxml.append("        <CustomFieldValue>\n");
    cxml.append("          <Value><![CDATA[").append(purchaseOrder.getVendorLine1Address()).append("]]></Value>\n");
    cxml.append("         </CustomFieldValue>\n");
    cxml.append("      </CustomFieldValueSet>\n");
    cxml.append("      <CustomFieldValueSet label=\"Supplier City State Zip\" name=\"SupplierCityStateZip\">\n");
    cxml.append("        <CustomFieldValue>\n");
    cxml.append("          <Value><![CDATA[").append(purchaseOrder.getVendorCityName()).append(", ").append(purchaseOrder.getVendorStateCode()).append(" ").append(purchaseOrder.getVendorPostalCode()).append("]]></Value>\n");
    cxml.append("         </CustomFieldValue>\n");
    cxml.append("      </CustomFieldValueSet>\n");
    String deliveryInstructionText = purchaseOrder.getDeliveryInstructionText();
    if (ObjectUtils.isNotNull(deliveryInstructionText)) {
        cxml.append("      <CustomFieldValueSet label=\"Delivery Instructions\" name=\"Delivery Instructions\">\n");
        cxml.append("        <CustomFieldValue>\n");
        cxml.append("          <Value><![CDATA[").append(deliveryInstructionText).append("]]></Value>\n");
        cxml.append("         </CustomFieldValue>\n");
        cxml.append("      </CustomFieldValueSet>\n");
    }
    // KFSUPGRADE-583
    if (purchaseOrder.getDocumentFundingSourceCode().equalsIgnoreCase(CUPurapConstants.PurapFundingSources.FEDERAL_FUNDING_SOURCE)) {
        cxml.append("      <CustomFieldValueSet label=\"Funding\" name=\"Funding\">\n");
        cxml.append("        <CustomFieldValue>\n");
        cxml.append("          <Value><![CDATA[" + FEDERAL_FUNDING_TEXT + "]]></Value>\n");
        cxml.append("         </CustomFieldValue>\n");
        cxml.append("      </CustomFieldValueSet>\n");
    }
    // do we have to check if field is empty or null ?
    if (includeNewFields) {
        cxml.append(addCustomFieldValueSet("DeliveryPhone", "Delivery Phone", purchaseOrder.getDeliveryToPhoneNumber()));
        cxml.append(addCustomFieldValueSet("DeliveryEmail", "Delivery Email", purchaseOrder.getDeliveryToEmailAddress()));
        cxml.append(addCustomFieldValueSet("ShipPayTerms", "Ship Pay Termse", getVendorShipPayTerms(purchaseOrder)));
        cxml.append(addCustomFieldValueSet("SupplierAddress2", "Supplier Address 2", purchaseOrder.getVendorLine2Address()));
        cxml.append(addCustomFieldValueSet("SupplierCountry", "Supplier Country", getVendorCountry(purchaseOrder)));
    }
    // end KFSUPGRADE-400 KFSPTS-427 fields
    cxml.append("    </POHeader>\n");
    /**
     *** Items Section ****
     */
    List detailList = purchaseOrder.getItems();
    for (Iterator iter = detailList.iterator(); iter.hasNext(); ) {
        PurchaseOrderItem poi = (PurchaseOrderItem) iter.next();
        if ((ObjectUtils.isNotNull(poi.getItemType())) && poi.getItemType().isLineItemIndicator()) {
            // KFSUPGRADE-406
            String uom = poi.getItemUnitOfMeasureCode();
            KualiDecimal quantity = poi.getItemQuantity();
            // Pass in value of 1 for quantity if no quantity provided. This helps handle non-quantity orders in SciQuest. KFSPTS-792
            if (quantity == null || quantity.isZero()) {
                quantity = new KualiDecimal(1);
                uom = NON_QUANTITY_UOM;
            }
            // ==== CU Customization: Use quantity of zero for inactive PO items, allowing SciQuest to cancel them properly. ====
            if (!poi.isItemActiveIndicator()) {
                quantity = new KualiDecimal(0);
            }
            // ==== End CU Customization ====
            cxml.append("    <POLine linenumber=\"").append(poi.getItemLineNumber()).append("\">\n");
            cxml.append("      <Item>\n");
            // CatalogNumber - This is a string that the supplier uses to identify the item (i.e., SKU). Optional.
            cxml.append("        <CatalogNumber><![CDATA[").append(poi.getItemCatalogNumber()).append("]]></CatalogNumber>\n");
            if (ObjectUtils.isNotNull(poi.getItemAuxiliaryPartIdentifier())) {
                cxml.append("        <AuxiliaryCatalogNumber><![CDATA[").append(poi.getItemAuxiliaryPartIdentifier()).append("]]></AuxiliaryCatalogNumber>\n");
            }
            // Required.
            cxml.append("        <Description><![CDATA[").append(poi.getItemDescription()).append("]]></Description>\n");
            cxml.append("        <ProductUnitOfMeasure type=\"supplier\"><Measurement><MeasurementValue><![CDATA[").append(uom).append("]]></MeasurementValue></Measurement></ProductUnitOfMeasure>\n");
            cxml.append("        <ProductUnitOfMeasure type=\"system\"><Measurement><MeasurementValue><![CDATA[").append(uom).append("]]></MeasurementValue></Measurement></ProductUnitOfMeasure>\n");
            // ProductReferenceNumber - Unique id for hosted products in SelectSite
            if (poi.getExternalOrganizationB2bProductTypeName().equals("Punchout")) {
                cxml.append("        <ProductReferenceNumber>null</ProductReferenceNumber>\n");
            } else {
                cxml.append("        <ProductReferenceNumber>").append(poi.getExternalOrganizationB2bProductReferenceNumber()).append("</ProductReferenceNumber>\n");
            }
            // ProductType - Describes the type of the product or service. Valid values: Catalog, Form, Punchout. Mandatory.
            if (PurapConstants.RequisitionSources.B2B.equals(purchaseOrder.getRequisitionSourceCode())) {
                cxml.append("        <ProductType>").append(poi.getExternalOrganizationB2bProductTypeName()).append("</ProductType>\n");
            } else {
                cxml.append("        <ProductType>").append("Form").append("</ProductType>\n");
            }
            cxml.append("      </Item>\n");
            cxml.append("      <Quantity>").append(quantity).append("</Quantity>\n");
            // LineCharges - All the monetary charges for this line, including the price, tax, shipping, and handling.
            // Required.
            cxml.append("      <LineCharges>\n");
            cxml.append("        <UnitPrice>\n");
            cxml.append("          <Money currency=\"USD\">").append(poi.getItemUnitPrice()).append("</Money>\n");
            cxml.append("        </UnitPrice>\n");
            cxml.append("      </LineCharges>\n");
            cxml.append("    </POLine>\n");
        }
    }
    cxml.append("  </PurchaseOrder>\n");
    cxml.append("</PurchaseOrderMessage>\r\n");
    LOG.debug("getCxml(): cXML for po number " + purchaseOrder.getPurapDocumentIdentifier() + ":\n" + cxml.toString());
    // *****************************************************************************************************************
    if (!notesToSendToVendor.isEmpty()) {
        // cxml.append("\r\n");
        for (int i = 0; i < notesToSendToVendor.size(); i++) {
            Note note = notesToSendToVendor.get(i);
            try {
                Attachment poAttachment = SpringContext.getBean(AttachmentService.class).getAttachmentByNoteId(note.getNoteIdentifier());
                if (ObjectUtils.isNotNull(poAttachment)) {
                    // cxml.append("\r\n"); // blank line.  This extra blank line cause first word doc has format issue
                    cxml.append("--" + CUPurapConstants.MIME_BOUNDARY_FOR_ATTACHMENTS + "\r\n");
                    cxml.append("Content-Type: application/octet-stream\r\n");
                    // cxml.append("Content-Type: application/pdf\r\n");
                    cxml.append("Content-Transfer-Encoding: binary\r\n");
                    cxml.append("Content-ID: <" + poAttachment.getAttachmentIdentifier() + "@sciquest.com>\r\n");
                    cxml.append("Content-Disposition: attachment; filename=\"" + poAttachment.getAttachmentFileName() + "\"" + "\r\n\r\n");
                    InputStream attInputStream = poAttachment.getAttachmentContents();
                    ByteArrayOutputStream buffer = new ByteArrayOutputStream();
                    int c;
                    while ((c = attInputStream.read()) != -1) buffer.write(c);
                    String binaryStream = new String(buffer.toByteArray(), "ISO-8859-1");
                    cxml.append(binaryStream + "\r\n");
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        // signals this is the last MIME boundary
        cxml.append("--" + CUPurapConstants.MIME_BOUNDARY_FOR_ATTACHMENTS + "--\r\n");
    } else {
    // cxml.append("\n\n--" + CUPurapConstants.MIME_BOUNDARY_FOR_ATTACHMENTS + "--\n");
    }
    return cxml.toString();
}
Also used : WorkflowDocument(org.kuali.rice.kew.api.WorkflowDocument) InputStream(java.io.InputStream) Attachment(org.kuali.kfs.krad.bo.Attachment) ByteArrayOutputStream(java.io.ByteArrayOutputStream) IOException(java.io.IOException) PaymentTermType(org.kuali.kfs.vnd.businessobject.PaymentTermType) Date(java.util.Date) BusinessObjectService(org.kuali.kfs.krad.service.BusinessObjectService) VendorService(org.kuali.kfs.vnd.document.service.VendorService) VendorDetail(org.kuali.kfs.vnd.businessobject.VendorDetail) PurchaseOrderItem(org.kuali.kfs.module.purap.businessobject.PurchaseOrderItem) Note(org.kuali.kfs.krad.bo.Note) Iterator(java.util.Iterator) KualiDecimal(org.kuali.rice.core.api.util.type.KualiDecimal) ArrayList(java.util.ArrayList) List(java.util.List) DateTimeService(org.kuali.rice.core.api.datetime.DateTimeService) SimpleDateFormat(java.text.SimpleDateFormat) VendorAddress(org.kuali.kfs.vnd.businessobject.VendorAddress) AttachmentService(org.kuali.kfs.krad.service.AttachmentService)

Example 12 with Note

use of org.kuali.kfs.krad.bo.Note in project cu-kfs by CU-CommunityApps.

the class CuCreditMemoServiceImpl method resetExtractedCreditMemo.

/**
 * @see org.kuali.kfs.module.purap.document.service.CreditMemoService#resetExtractedCreditMemo(org.kuali.kfs.module.purap.document.CreditMemoDocument,
 *      java.lang.String)
 */
@Override
public void resetExtractedCreditMemo(VendorCreditMemoDocument cmDocument, String note) {
    LOG.debug("resetExtractedCreditMemo() started");
    if (CreditMemoStatuses.CANCELLED_STATUSES.contains(cmDocument.getApplicationDocumentStatus())) {
        LOG.debug("resetExtractedCreditMemo() ended");
        return;
    }
    cmDocument.setExtractedTimestamp(null);
    cmDocument.setCreditMemoPaidTimestamp(null);
    Note noteObj;
    try {
        noteObj = documentService.createNoteFromDocument(cmDocument, note);
        cmDocument.addNote(noteObj);
    } catch (Exception e) {
        throw new RuntimeException(e.getMessage());
    }
    purapService.saveDocumentNoValidation(cmDocument);
    // force reindexing
    reIndexDocument(cmDocument);
    if (LOG.isDebugEnabled()) {
        LOG.debug("resetExtractedCreditMemo() CM " + cmDocument.getPurapDocumentIdentifier() + " Cancelled Without Workflow");
    }
    LOG.debug("resetExtractedCreditMemo() ended");
}
Also used : Note(org.kuali.kfs.krad.bo.Note) WorkflowException(org.kuali.rice.kew.api.exception.WorkflowException)

Example 13 with Note

use of org.kuali.kfs.krad.bo.Note in project cu-kfs by CU-CommunityApps.

the class CuPaymentRequestServiceImpl method resetExtractedPaymentRequest.

/**
 * @see org.kuali.kfs.module.purap.document.service.PaymentRequestService#resetExtractedPaymentRequest(org.kuali.kfs.module.purap.document.PaymentRequestDocument,
 *      java.lang.String)
 */
@Override
@NonTransactional
public void resetExtractedPaymentRequest(PaymentRequestDocument paymentRequest, String note) {
    LOG.debug("resetExtractedPaymentRequest() started");
    if (PaymentRequestStatuses.CANCELLED_STATUSES.contains(paymentRequest.getApplicationDocumentStatus())) {
        LOG.debug("resetExtractedPaymentRequest() ended");
        return;
    }
    paymentRequest.setExtractedTimestamp(null);
    paymentRequest.setPaymentPaidTimestamp(null);
    String noteText = "This Payment Request is being reset for extraction by PDP " + note;
    try {
        Note resetNote = documentService.createNoteFromDocument(paymentRequest, noteText);
        paymentRequest.addNote(resetNote);
        noteService.save(resetNote);
    } catch (Exception e) {
        throw new RuntimeException(PurapConstants.REQ_UNABLE_TO_CREATE_NOTE + " " + e);
    }
    purapService.saveDocumentNoValidation(paymentRequest);
    if (LOG.isDebugEnabled()) {
        LOG.debug("resetExtractedPaymentRequest() PREQ " + paymentRequest.getPurapDocumentIdentifier() + " Reset from Extracted status");
    }
    // force reindexing
    reIndexDocument(paymentRequest);
}
Also used : Note(org.kuali.kfs.krad.bo.Note) NonTransactional(org.kuali.kfs.sys.service.NonTransactional)

Example 14 with Note

use of org.kuali.kfs.krad.bo.Note in project cu-kfs by CU-CommunityApps.

the class CuPaymentRequestServiceImpl method removeRequestCancelOnPaymentRequest.

/**
 * @see org.kuali.kfs.module.purap.document.service.PaymentRequestService#removeHoldOnPaymentRequest(org.kuali.kfs.module.purap.document.PaymentRequestDocument)
 */
@Override
@NonTransactional
public void removeRequestCancelOnPaymentRequest(PaymentRequestDocument document, String note) throws Exception {
    // save the note
    Note noteObj = documentService.createNoteFromDocument(document, note);
    document.addNote(noteObj);
    noteService.save(noteObj);
    clearRequestCancelFields(document);
    purapService.saveDocumentNoValidation(document);
    // force reindexing
    reIndexDocument(document);
}
Also used : Note(org.kuali.kfs.krad.bo.Note) NonTransactional(org.kuali.kfs.sys.service.NonTransactional)

Example 15 with Note

use of org.kuali.kfs.krad.bo.Note in project cu-kfs by CU-CommunityApps.

the class CuPaymentRequestServiceImpl method cancelExtractedPaymentRequest.

@Override
@NonTransactional
public void cancelExtractedPaymentRequest(PaymentRequestDocument paymentRequest, String note) {
    LOG.debug("cancelExtractedPaymentRequest() started");
    if (PaymentRequestStatuses.CANCELLED_STATUSES.contains(paymentRequest.getApplicationDocumentStatus())) {
        LOG.debug("cancelExtractedPaymentRequest() ended");
        return;
    }
    try {
        Note cancelNote = documentService.createNoteFromDocument(paymentRequest, note);
        paymentRequest.addNote(cancelNote);
        noteService.save(cancelNote);
    } catch (Exception e) {
        throw new RuntimeException(PurapConstants.REQ_UNABLE_TO_CREATE_NOTE, e);
    }
    // cancel extracted should not reopen PO
    paymentRequest.setReopenPurchaseOrderIndicator(false);
    // Performs save, so
    getAccountsPayableService().cancelAccountsPayableDocument(paymentRequest, "");
    // is necessary
    if (LOG.isDebugEnabled()) {
        LOG.debug("cancelExtractedPaymentRequest() PREQ " + paymentRequest.getPurapDocumentIdentifier() + " Cancelled Without Workflow");
        LOG.debug("cancelExtractedPaymentRequest() ended");
    }
    // force reindexing
    reIndexDocument(paymentRequest);
}
Also used : Note(org.kuali.kfs.krad.bo.Note) NonTransactional(org.kuali.kfs.sys.service.NonTransactional)

Aggregations

Note (org.kuali.kfs.krad.bo.Note)76 Attachment (org.kuali.kfs.krad.bo.Attachment)14 WorkflowException (org.kuali.rice.kew.api.exception.WorkflowException)12 IOException (java.io.IOException)9 FileNotFoundException (java.io.FileNotFoundException)7 ArrayList (java.util.ArrayList)7 NoteService (org.kuali.kfs.krad.service.NoteService)7 FileInputStream (java.io.FileInputStream)6 KualiDocumentFormBase (org.kuali.kfs.kns.web.struts.form.KualiDocumentFormBase)6 NonTransactional (org.kuali.kfs.sys.service.NonTransactional)6 File (java.io.File)5 Iterator (java.util.Iterator)5 DocumentService (org.kuali.kfs.krad.service.DocumentService)5 Person (org.kuali.rice.kim.api.identity.Person)5 NoteExtendedAttribute (edu.cornell.kfs.sys.businessobject.NoteExtendedAttribute)4 SimpleDateFormat (java.text.SimpleDateFormat)4 Document (org.kuali.kfs.krad.document.Document)4 PurchaseOrderDocument (org.kuali.kfs.module.purap.document.PurchaseOrderDocument)4 HashMap (java.util.HashMap)3 List (java.util.List)3