protected CapitalAssetSystem getCapitalAssetSystemForIndividual(
Integer poId, PurApItem purApItem) {
List<PurchasingCapitalAssetItem> capitalAssetItems =
this.getPurchaseOrderService().retrieveCapitalAssetItemsForIndividual(poId);
if (capitalAssetItems == null || capitalAssetItems.isEmpty()) {
return null;
}
Integer purchaseOrderItemIdentifier = null;
PurchaseOrderItem poi = null;
if (purApItem instanceof PaymentRequestItem) {
poi = ((PaymentRequestItem) purApItem).getPurchaseOrderItem();
} else if (purApItem instanceof CreditMemoItem) {
poi = getPurchaseOrderItemfromCreditMemoItem((CreditMemoItem) purApItem);
}
if (poi != null) {
purchaseOrderItemIdentifier = poi.getItemIdentifier();
}
for (PurchasingCapitalAssetItem capitalAssetItem : capitalAssetItems) {
if (capitalAssetItem.getItemIdentifier().equals(purchaseOrderItemIdentifier)) {
return capitalAssetItem.getPurchasingCapitalAssetSystem();
}
}
return null;
}
/**
* Set CAB line item information from PurAp PaymentRequestItem or CreditMemoItem.
*
* @param purchasingAccountsPayableItemAsset
* @param docTypeCode
*/
public void setAccountsPayableItemsFromPurAp(
PurchasingAccountsPayableItemAsset purchasingAccountsPayableItemAsset, String docTypeCode) {
Map<String, Object> pKeys = new HashMap<String, Object>();
pKeys.put(
PurapPropertyConstants.ITEM_IDENTIFIER,
purchasingAccountsPayableItemAsset.getAccountsPayableLineItemIdentifier());
// Access PurAp data based on item type(PREQ or CM).
if (CabConstants.PREQ.equalsIgnoreCase(docTypeCode)) {
// for PREQ document
PaymentRequestItem item =
(PaymentRequestItem)
businessObjectService.findByPrimaryKey(PaymentRequestItem.class, pKeys);
if (ObjectUtils.isNull(item)) {
throw new PurApDocumentUnavailableException(
"PaymentRequestItem with id = "
+ purchasingAccountsPayableItemAsset.getAccountsPayableLineItemIdentifier()
+ " doesn't exist in table.");
}
purchasingAccountsPayableItemAsset.setItemLineNumber(item.getItemLineNumber());
if (item.getItemType() != null) {
purchasingAccountsPayableItemAsset.setAdditionalChargeNonTradeInIndicator(
item.getItemType().isAdditionalChargeIndicator()
& !CabConstants.TRADE_IN_TYPE_CODE.equalsIgnoreCase(item.getItemTypeCode()));
purchasingAccountsPayableItemAsset.setTradeInAllowance(
item.getItemType().isAdditionalChargeIndicator()
& CabConstants.TRADE_IN_TYPE_CODE.equalsIgnoreCase(item.getItemTypeCode()));
purchasingAccountsPayableItemAsset.setItemTypeCode(item.getItemTypeCode());
}
purchasingAccountsPayableItemAsset.setItemAssignedToTradeInIndicator(
item.getItemAssignedToTradeInIndicator());
// PurchaseOrderItemIdentifier will be used when populate PurAp asset data
PurchaseOrderItem poi = item.getPurchaseOrderItem();
if (poi != null) {
purchasingAccountsPayableItemAsset.setPurchaseOrderItemIdentifier(poi.getItemIdentifier());
}
} else {
// for CM document
CreditMemoItem item =
(CreditMemoItem) businessObjectService.findByPrimaryKey(CreditMemoItem.class, pKeys);
if (ObjectUtils.isNull(item)) {
throw new PurApDocumentUnavailableException(
"CreditMemoItem with id = "
+ purchasingAccountsPayableItemAsset.getAccountsPayableLineItemIdentifier()
+ " doesn't exist in table.");
}
purchasingAccountsPayableItemAsset.setItemLineNumber(item.getItemLineNumber());
if (item.getItemType() != null) {
purchasingAccountsPayableItemAsset.setAdditionalChargeNonTradeInIndicator(
item.getItemType().isAdditionalChargeIndicator()
& !CabConstants.TRADE_IN_TYPE_CODE.equalsIgnoreCase(item.getItemTypeCode()));
purchasingAccountsPayableItemAsset.setTradeInAllowance(
item.getItemType().isAdditionalChargeIndicator()
& CabConstants.TRADE_IN_TYPE_CODE.equalsIgnoreCase(item.getItemTypeCode()));
purchasingAccountsPayableItemAsset.setItemTypeCode(item.getItemTypeCode());
}
purchasingAccountsPayableItemAsset.setItemAssignedToTradeInIndicator(
item.getItemAssignedToTradeInIndicator());
// PurchaseOrderItemIdentifier will be used when populate PurAp asset data
PurchaseOrderItem poi = getPurchaseOrderItemfromCreditMemoItem(item);
if (poi != null) {
purchasingAccountsPayableItemAsset.setPurchaseOrderItemIdentifier(poi.getItemIdentifier());
}
// if PREQ Credit Memo document
VendorCreditMemoDocument cmDoc = (VendorCreditMemoDocument) item.getPurapDocument();
if (ObjectUtils.isNotNull(cmDoc) && cmDoc.isSourceDocumentPaymentRequest()) {
purchasingAccountsPayableItemAsset.setPaymentRequestIdentifier(
cmDoc.getPaymentRequestIdentifier());
}
}
}
/**
* Create a PDF using the given input parameters.
*
* @param po The PurchaseOrderDocument to be used to create the pdf.
* @param poqv The PurchaseOrderVendorQuote to be used to generate the pdf.
* @param campusName The campus name to be used to generate the pdf.
* @param contractManagerCampusCode The contract manager campus code to be used to generate the
* pdf.
* @param logoImage The logo image file name to be used to generate the pdf.
* @param document The pdf document whose margins have already been set.
* @param writer The PdfWriter to write the pdf document into.
* @param environment The current environment used (e.g. DEV if it is a development environment).
* @throws DocumentException
*/
private void createPOQuotePdf(
PurchaseOrderDocument po,
PurchaseOrderVendorQuote poqv,
String campusName,
String contractManagerCampusCode,
String logoImage,
Document document,
PdfWriter writer,
String environment)
throws DocumentException {
if (LOG.isDebugEnabled()) {
LOG.debug("createQuotePdf() started for po number " + po.getPurapDocumentIdentifier());
}
// These have to be set because they are used by the onOpenDocument() and onStartPage() methods.
this.campusName = campusName;
this.po = po;
this.logoImage = logoImage;
this.environment = environment;
NumberFormat numberFormat = NumberFormat.getCurrencyInstance(Locale.US);
// Date format pattern: MM-dd-yyyy
SimpleDateFormat sdf =
PurApDateFormatUtils.getSimpleDateFormat(
PurapConstants.NamedDateFormats.KUALI_SIMPLE_DATE_FORMAT_2);
CampusParameter campusParameter = getCampusParameter(contractManagerCampusCode);
String purchasingAddressFull = getPurchasingAddressFull(campusParameter);
// Turn on the page events that handle the header and page numbers.
PurchaseOrderQuotePdf events = new PurchaseOrderQuotePdf().getPageEvents();
writer.setPageEvent(this); // Passing in "this" lets it know about the po, campusName, etc.
document.open();
PdfPCell cell;
Paragraph p = new Paragraph();
// ***** Info table (address, vendor, other info) *****
LOG.debug("createQuotePdf() info table started.");
float[] infoWidths = {0.45f, 0.55f};
PdfPTable infoTable = new PdfPTable(infoWidths);
infoTable.setWidthPercentage(100);
infoTable.setHorizontalAlignment(Element.ALIGN_CENTER);
infoTable.setSplitLate(false);
p = new Paragraph();
ContractManager contractManager = po.getContractManager();
p.add(new Chunk("\n Return this form to:\n", ver_8_bold));
p.add(new Chunk(purchasingAddressFull + "\n", cour_10_normal));
p.add(new Chunk("\n", cour_10_normal));
p.add(new Chunk(" Fax #: ", ver_6_normal));
p.add(new Chunk(contractManager.getContractManagerFaxNumber() + "\n", cour_10_normal));
p.add(new Chunk(" Contract Manager: ", ver_6_normal));
p.add(
new Chunk(
contractManager.getContractManagerName()
+ " "
+ contractManager.getContractManagerPhoneNumber()
+ "\n",
cour_10_normal));
p.add(new Chunk("\n", cour_10_normal));
p.add(new Chunk(" To:\n", ver_6_normal));
StringBuffer vendorInfo = new StringBuffer();
if (StringUtils.isNotBlank(poqv.getVendorAttentionName())) {
vendorInfo.append(" ATTN: " + poqv.getVendorAttentionName().trim() + "\n");
}
vendorInfo.append(" " + poqv.getVendorName() + "\n");
if (StringUtils.isNotBlank(poqv.getVendorLine1Address())) {
vendorInfo.append(" " + poqv.getVendorLine1Address() + "\n");
}
if (StringUtils.isNotBlank(poqv.getVendorLine2Address())) {
vendorInfo.append(" " + poqv.getVendorLine2Address() + "\n");
}
if (StringUtils.isNotBlank(poqv.getVendorCityName())) {
vendorInfo.append(" " + poqv.getVendorCityName());
}
if ((StringUtils.isNotBlank(poqv.getVendorStateCode()))
&& (!poqv.getVendorStateCode().equals("--"))) {
vendorInfo.append(", " + poqv.getVendorStateCode());
}
if (StringUtils.isNotBlank(poqv.getVendorAddressInternationalProvinceName())) {
vendorInfo.append(", " + poqv.getVendorAddressInternationalProvinceName());
}
if (StringUtils.isNotBlank(poqv.getVendorPostalCode())) {
vendorInfo.append(" " + poqv.getVendorPostalCode() + "\n");
} else {
vendorInfo.append("\n");
}
if (!KFSConstants.COUNTRY_CODE_UNITED_STATES.equalsIgnoreCase(poqv.getVendorCountryCode())
&& poqv.getVendorCountryCode() != null) {
vendorInfo.append(" " + poqv.getVendorCountry().getName() + "\n\n");
} else {
vendorInfo.append(" \n\n");
}
p.add(new Chunk(vendorInfo.toString(), cour_10_normal));
cell = new PdfPCell(p);
cell.setHorizontalAlignment(Element.ALIGN_LEFT);
infoTable.addCell(cell);
p = new Paragraph();
p.add(new Chunk("\n R.Q. Number: ", ver_8_bold));
p.add(new Chunk(po.getPurapDocumentIdentifier() + "\n", cour_10_normal));
java.sql.Date requestDate = getDateTimeService().getCurrentSqlDate();
if (poqv.getPurchaseOrderQuoteTransmitTimestamp() != null) {
try {
requestDate =
getDateTimeService().convertToSqlDate(poqv.getPurchaseOrderQuoteTransmitTimestamp());
} catch (ParseException e) {
throw new RuntimeException(
"ParseException thrown when trying to convert from Timestamp to SqlDate.", e);
}
}
p.add(new Chunk(" R.Q. Date: ", ver_8_bold));
p.add(new Chunk(sdf.format(requestDate) + "\n", cour_10_normal));
p.add(new Chunk(" RESPONSE MUST BE RECEIVED BY: ", ver_8_bold));
if (po.getPurchaseOrderQuoteDueDate() != null) {
p.add(new Chunk(sdf.format(po.getPurchaseOrderQuoteDueDate()) + "\n\n", cour_10_normal));
} else {
p.add(new Chunk("N/A\n\n", cour_10_normal));
}
// retrieve the quote stipulations
StringBuffer quoteStipulations = getPoQuoteLanguage();
p.add(new Chunk(quoteStipulations.toString(), ver_6_normal));
p.add(new Chunk("\n ALL QUOTES MUST BE TOTALED", ver_12_normal));
cell = new PdfPCell(p);
infoTable.addCell(cell);
document.add(infoTable);
// ***** Notes and Stipulations table *****
// The notes and stipulations table is type Table instead of PdfPTable
// because Table has the method setCellsFitPage and I can't find an equivalent
// in PdfPTable. Long notes or stipulations would break to the next page, leaving
// a large white space on the previous page.
PdfPTable notesStipulationsTable = new PdfPTable(1);
notesStipulationsTable.setWidthPercentage(100);
notesStipulationsTable.setSplitLate(false);
p = new Paragraph();
p.add(new Chunk(" Vendor Stipulations and Information\n\n", ver_6_normal));
if ((po.getPurchaseOrderBeginDate() != null) && (po.getPurchaseOrderEndDate() != null)) {
p.add(
new Chunk(
" Order in effect from "
+ sdf.format(po.getPurchaseOrderBeginDate())
+ " to "
+ sdf.format(po.getPurchaseOrderEndDate())
+ ".\n",
cour_10_normal));
}
Collection<PurchaseOrderVendorStipulation> vendorStipulationsList =
po.getPurchaseOrderVendorStipulations();
if (vendorStipulationsList.size() > 0) {
StringBuffer vendorStipulations = new StringBuffer();
for (PurchaseOrderVendorStipulation povs : vendorStipulationsList) {
vendorStipulations.append(" " + povs.getVendorStipulationDescription() + "\n");
}
p.add(new Chunk(" " + vendorStipulations.toString(), cour_10_normal));
}
PdfPCell tableCell = new PdfPCell(p);
tableCell.setHorizontalAlignment(Element.ALIGN_LEFT);
tableCell.setVerticalAlignment(Element.ALIGN_TOP);
notesStipulationsTable.addCell(tableCell);
document.add(notesStipulationsTable);
// ***** Items table *****
LOG.debug("createQuotePdf() items table started.");
float[] itemsWidths = {0.07f, 0.1f, 0.07f, 0.50f, 0.13f, 0.13f};
PdfPTable itemsTable = new PdfPTable(6);
// itemsTable.setCellsFitPage(false); With this set to true a large cell will
// skip to the next page. The default Table behaviour seems to be what we want:
// start the large cell on the same page and continue it to the next.
itemsTable.setWidthPercentage(100);
itemsTable.setWidths(itemsWidths);
itemsTable.setSplitLate(false);
tableCell =
createCell("Item\nNo.", false, false, false, false, Element.ALIGN_CENTER, ver_6_normal);
itemsTable.addCell(tableCell);
tableCell =
createCell("Quantity", false, false, false, false, Element.ALIGN_CENTER, ver_6_normal);
itemsTable.addCell(tableCell);
tableCell = createCell("UOM", false, false, false, false, Element.ALIGN_CENTER, ver_6_normal);
itemsTable.addCell(tableCell);
tableCell =
createCell("Description", false, false, false, false, Element.ALIGN_CENTER, ver_6_normal);
itemsTable.addCell(tableCell);
tableCell =
createCell(
"Unit Cost\n(Required)",
false,
false,
false,
false,
Element.ALIGN_CENTER,
ver_6_normal);
itemsTable.addCell(tableCell);
tableCell =
createCell(
"Extended Cost\n(Required)",
false,
false,
false,
false,
Element.ALIGN_CENTER,
ver_6_normal);
itemsTable.addCell(tableCell);
if (StringUtils.isNotBlank(po.getPurchaseOrderQuoteVendorNoteText())) {
// Vendor notes line.
itemsTable.addCell(" ");
itemsTable.addCell(" ");
itemsTable.addCell(" ");
tableCell =
createCell(
po.getPurchaseOrderQuoteVendorNoteText(),
false,
false,
false,
false,
Element.ALIGN_LEFT,
cour_10_normal);
itemsTable.addCell(tableCell);
itemsTable.addCell(" ");
itemsTable.addCell(" ");
}
for (PurchaseOrderItem poi : (List<PurchaseOrderItem>) po.getItems()) {
if ((poi.getItemType() != null)
&& (StringUtils.isNotBlank(poi.getItemDescription()))
&& (poi.getItemType().isLineItemIndicator()
|| poi.getItemTypeCode()
.equals(PurapConstants.ItemTypeCodes.ITEM_TYPE_SHIP_AND_HAND_CODE)
|| poi.getItemTypeCode().equals(PurapConstants.ItemTypeCodes.ITEM_TYPE_FREIGHT_CODE)
|| poi.getItemTypeCode()
.equals(PurapConstants.ItemTypeCodes.ITEM_TYPE_ORDER_DISCOUNT_CODE)
|| poi.getItemTypeCode()
.equals(PurapConstants.ItemTypeCodes.ITEM_TYPE_TRADE_IN_CODE))) {
// "ITEM"s display the line number; other types don't.
String description = "";
description =
(StringUtils.isNotBlank(poi.getItemCatalogNumber()))
? poi.getItemCatalogNumber().trim() + " - "
: "";
description =
description
+ ((StringUtils.isNotBlank(poi.getItemDescription()))
? poi.getItemDescription().trim()
: "");
// If this is a full order discount item or trade in item, we add the
// itemType description and a dash to the purchase order item description.
if (StringUtils.isNotBlank(poi.getItemDescription())) {
if (poi.getItemTypeCode()
.equals(PurapConstants.ItemTypeCodes.ITEM_TYPE_ORDER_DISCOUNT_CODE)
|| poi.getItemTypeCode()
.equals(PurapConstants.ItemTypeCodes.ITEM_TYPE_TRADE_IN_CODE)) {
description = poi.getItemType().getItemTypeDescription() + " - " + description;
}
}
// We can do the normal table now because description is not too long.
String itemLineNumber = new String();
if (poi.getItemType().isLineItemIndicator()) {
itemLineNumber = poi.getItemLineNumber().toString();
} else {
itemLineNumber = "";
}
tableCell =
createCell(
itemLineNumber, false, false, false, false, Element.ALIGN_CENTER, cour_10_normal);
itemsTable.addCell(tableCell);
String quantity = (poi.getItemQuantity() != null) ? poi.getItemQuantity().toString() : " ";
tableCell =
createCell(quantity, false, false, false, false, Element.ALIGN_CENTER, cour_10_normal);
itemsTable.addCell(tableCell);
tableCell =
createCell(
poi.getItemUnitOfMeasureCode(),
false,
false,
false,
false,
Element.ALIGN_CENTER,
cour_10_normal);
itemsTable.addCell(tableCell);
tableCell =
createCell(description, false, false, false, false, Element.ALIGN_LEFT, cour_10_normal);
itemsTable.addCell(tableCell);
itemsTable.addCell(" ");
itemsTable.addCell(" ");
}
}
// Blank line before totals
createBlankRowInItemsTable(itemsTable);
// Totals line.
itemsTable.addCell(" ");
itemsTable.addCell(" ");
itemsTable.addCell(" ");
tableCell =
createCell("Total: ", false, false, false, false, Element.ALIGN_RIGHT, ver_10_normal);
itemsTable.addCell(tableCell);
itemsTable.addCell(" ");
itemsTable.addCell(" ");
// Blank line after totals
createBlankRowInItemsTable(itemsTable);
document.add(itemsTable);
LOG.debug("createQuotePdf() vendorFillsIn table started.");
float[] vendorFillsInWidths = {0.50f, 0.50f};
PdfPTable vendorFillsInTable = new PdfPTable(vendorFillsInWidths);
vendorFillsInTable.setWidthPercentage(100);
vendorFillsInTable.setHorizontalAlignment(Element.ALIGN_CENTER);
vendorFillsInTable.setSplitLate(false);
vendorFillsInTable.getDefaultCell().setBorderWidth(0);
vendorFillsInTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_CENTER);
vendorFillsInTable.getDefaultCell().setVerticalAlignment(Element.ALIGN_CENTER);
// New row
String important =
new String(
"\nIMPORTANT: The information and signature below MUST BE COMPLETED or your offer may be rejected.\n");
cell = createCell(important, true, false, false, false, Element.ALIGN_LEFT, ver_8_normal);
cell.setColspan(2);
vendorFillsInTable.addCell(cell);
// New row
String cashDiscount =
new String("Terms of Payment: Cash discount_________%_________Days-Net________Days\n");
cell = createCell(cashDiscount, true, false, false, false, Element.ALIGN_LEFT, ver_8_normal);
cell.setColspan(2);
vendorFillsInTable.addCell(cell);
// New row
String fob = new String(" FOB: __ Destination (Title)\n");
cell = createCell(fob, true, false, false, false, Element.ALIGN_LEFT, ver_8_normal);
vendorFillsInTable.addCell(cell);
String freightVendor = new String(" __ Freight Vendor Paid (Allowed)\n");
cell = createCell(freightVendor, true, false, false, false, Element.ALIGN_LEFT, ver_8_normal);
vendorFillsInTable.addCell(cell);
// New row
String shipping = new String(" __ Shipping Point (Title)\n");
cell = createCell(shipping, true, false, false, false, Element.ALIGN_LEFT, ver_8_normal);
vendorFillsInTable.addCell(cell);
String freightPrepaid = new String(" __ Freight Prepaid & Added Amount $_________\n");
cell = createCell(freightPrepaid, true, false, false, false, Element.ALIGN_LEFT, ver_8_normal);
vendorFillsInTable.addCell(cell);
// New row
String commonCarrier =
new String(" If material will ship common carrier, please provide the following:\n");
cell = createCell(commonCarrier, true, false, false, false, Element.ALIGN_LEFT, ver_8_bold);
cell.setColspan(2);
vendorFillsInTable.addCell(cell);
// New row
String origin =
new String(
" Point of origin and zip code: ______________________ Weight: _________ Class: _________\n");
cell = createCell(origin, true, false, false, false, Element.ALIGN_LEFT, ver_8_bold);
cell.setColspan(2);
vendorFillsInTable.addCell(cell);
// New row
p = new Paragraph();
p.add(new Chunk(" Unless otherwise stated, all material to be shipped to ", ver_8_normal));
String purchasingAddressPartial;
if (po.getAddressToVendorIndicator()) {
purchasingAddressPartial =
po.getReceivingCityName()
+ ", "
+ po.getReceivingStateCode()
+ " "
+ po.getReceivingPostalCode();
} else {
purchasingAddressPartial =
po.getDeliveryCityName()
+ ", "
+ po.getDeliveryStateCode()
+ " "
+ po.getDeliveryPostalCode();
}
p.add(new Chunk(purchasingAddressPartial + "\n", cour_10_normal));
cell = new PdfPCell(p);
cell.setColspan(2);
cell.setHorizontalAlignment(Element.ALIGN_LEFT);
cell.setBorderWidth(0);
vendorFillsInTable.addCell(cell);
// New row
String offerEffective = new String(" Offer effective until (Date):_____________\n");
cell = createCell(offerEffective, true, false, false, false, Element.ALIGN_LEFT, ver_8_normal);
vendorFillsInTable.addCell(cell);
String deliverBy = new String(" Delivery can be made by (Date):_____________\n");
cell = createCell(deliverBy, true, false, false, false, Element.ALIGN_LEFT, ver_8_normal);
vendorFillsInTable.addCell(cell);
// New row
String sign = new String(" SIGN HERE:____________________________\n");
cell = createCell(sign, true, false, false, false, Element.ALIGN_RIGHT, ver_10_bold);
vendorFillsInTable.addCell(cell);
String date = new String(" DATE:____________________________\n");
cell = createCell(date, true, false, false, false, Element.ALIGN_RIGHT, ver_10_bold);
vendorFillsInTable.addCell(cell);
// New row
String name = new String(" PRINT NAME:____________________________\n");
cell = createCell(name, true, false, false, false, Element.ALIGN_RIGHT, ver_10_bold);
vendorFillsInTable.addCell(cell);
String phone = new String(" PHONE:____________________________\n");
cell = createCell(phone, true, false, false, false, Element.ALIGN_RIGHT, ver_10_bold);
vendorFillsInTable.addCell(cell);
// New row
String company = new String(" COMPANY:____________________________\n");
cell = createCell(company, true, false, false, false, Element.ALIGN_RIGHT, ver_10_bold);
vendorFillsInTable.addCell(cell);
String fax = new String(" FAX:____________________________\n");
cell = createCell(fax, true, false, false, false, Element.ALIGN_RIGHT, ver_10_bold);
vendorFillsInTable.addCell(cell);
document.add(vendorFillsInTable);
document.close();
LOG.debug("createQuotePdf()pdf document closed.");
} // End of createQuotePdf()