| <#-- |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, |
| software distributed under the License is distributed on an |
| "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| KIND, either express or implied. See the License for the |
| specific language governing permissions and limitations |
| under the License. |
| --> |
| |
| <script language="JavaScript" type="text/javascript"> |
| <!-- // |
| function lookupInventory() { |
| document.lookupinventory.submit(); |
| } |
| // --> |
| </script> |
| <div class="screenlet"> |
| <div class="screenlet-title-bar"> |
| <ul> |
| <li class="h3">${uiLabelMap.PageTitleFindInventoryEventPlan}</li> |
| </ul> |
| <br class="clear"/> |
| </div> |
| <div class="screenlet-body"> |
| <form method="post" name="lookupinventory" action="<@ofbizUrl>FindInventoryEventPlan</@ofbizUrl>"> |
| <input type="hidden" name="lookupFlag" value="Y"/> |
| <input type="hidden" name="hideFields" value="Y"/> |
| <table class="basic-table" cellspacing="0"> |
| <tr> |
| <td width='100%'> |
| <table class="basic-table" cellspacing="0"> |
| <tr> |
| <td></td> |
| <td align='right'> |
| <p> |
| <#if requestParameters.hideFields?default("N") == "Y"> |
| <a href="<@ofbizUrl>FindInventoryEventPlan?hideFields=N${paramList}</@ofbizUrl>" class="smallSubmit">${uiLabelMap.CommonShowLookupFields}</a> |
| <#else> |
| <#if inventoryList??> |
| <a href="<@ofbizUrl>FindInventoryEventPlan?hideFields=Y${paramList}</@ofbizUrl>" class="smallSubmit">${uiLabelMap.CommonHideFields}</a> |
| </#if> |
| </#if> |
| </p> |
| </td> |
| </tr> |
| </table> |
| <#if requestParameters.hideFields?default("N") != "Y"> |
| <table class="basic-table" cellspacing="0"> |
| <tr> |
| <td align='center' width='100%'> |
| <table class="basic-table" cellspacing="0"> |
| <tr> |
| <td width='20%' align='right' class="label">${uiLabelMap.ManufacturingProductId}</td> |
| <td width='5%'> </td> |
| <td> |
| <span> |
| <@htmlTemplate.lookupField value='${requestParameters.productId!}' formName="lookupinventory" name="productId" id="productId" fieldFormName="LookupProduct"/> |
| </span> |
| </td> |
| </tr> |
| <tr> |
| <td width='20%' align='right' class="label">${uiLabelMap.CommonFromDate}</td> |
| <td width='5%'> </td> |
| <td> |
| <@htmlTemplate.renderDateTimeField name="eventDate" event="" action="" className="" alert="" title="Format: yyyy-MM-dd HH:mm:ss.SSS" value="${requestParameters.eventDate!nowTimestamp}" size="25" maxlength="30" id="fromDate_2" dateType="date" shortDateInput=false timeDropdownParamName="" defaultDateTimeString="" localizedIconTitle="" timeDropdown="" timeHourName="" classString="" hour1="" hour2="" timeMinutesName="" minutes="" isTwelveHour="" ampmName="" amSelected="" pmSelected="" compositeType="" formName=""/> |
| </td> |
| </tr> |
| <tr> |
| <td width="20%" align="center" valign="top"> </td> |
| <td width="5%"> </td> |
| <td width="75%"> <a href="javascript:lookupInventory();" class="smallSubmit"> ${uiLabelMap.CommonFind} </a></td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| </table> |
| </#if> |
| </td> |
| </tr> |
| </table> |
| </form> |
| </div> |
| </div> |
| |
| <#if requestParameters.hideFields?default("N") != "Y"> |
| <script language="JavaScript" type="text/javascript"> |
| <!--// |
| document.lookupinventory.productId.focus(); |
| //--> |
| </script> |
| </#if> |
| <#if requestParameters.lookupFlag?default("N") == "Y"> |
| <table class="basic-table" cellspacing="0"> |
| <tr> |
| <td width='100%'> |
| <#if inventoryList?has_content> |
| <#assign rowClass = "alternate-row"> |
| <table class="basic-table" cellspacing="0"> |
| <tr> |
| <td width="50%" class="boxhead">${uiLabelMap.CommonElementsFound}</td> |
| <td width="50%"> |
| <div class="boxhead" align="right"> |
| |
| <#if 0 < viewIndex> |
| <a href="<@ofbizUrl>FindInventoryEventPlan?VIEW_SIZE=${viewSize}&VIEW_INDEX=${viewIndex-1}&hideFields=${requestParameters.hideFields?default("N")}${paramList}</@ofbizUrl>" class="submenutext">${uiLabelMap.CommonPrevious}</a> |
| <#else> |
| <span class="submenutextdisabled">${uiLabelMap.CommonPrevious}</span> |
| </#if> |
| <#if 0 < listSize> |
| <span class="submenutextinfo">${lowIndex+1} - ${highIndex} ${uiLabelMap.CommonOf} ${listSize}</span> |
| </#if> |
| <#if highIndex < listSize> |
| <a href="<@ofbizUrl>FindInventoryEventPlan?VIEW_SIZE=${viewSize}&VIEW_INDEX=${viewIndex+1}&hideFields=${requestParameters.hideFields?default("N")}${paramList}</@ofbizUrl>" class="submenutextright">${uiLabelMap.CommonNext}</a> |
| <#else> |
| <span class="submenutextrightdisabled">${uiLabelMap.CommonNext}</span> |
| </#if> |
| |
| |
| </div> |
| </td> |
| </tr> |
| </table> |
| |
| <table class="basic-table" cellspacing="0"> |
| <tr class="header-row"> |
| <td>${uiLabelMap.CommonType}</td> |
| <td align="center"> </td> |
| <td>${uiLabelMap.CommonDescription}</td> |
| <td>${uiLabelMap.CommonDate}</td> |
| <td align="center"> </td> |
| <td align="right">${uiLabelMap.CommonQuantity}</td> |
| <td align="right">${uiLabelMap.ManufacturingTotalQuantity}</td> |
| </tr> |
| <tr> |
| <td colspan="7"><hr /></td> |
| </tr> |
| <#assign count = lowIndex> |
| <#assign productTmp = ""> |
| <#list inventoryList[lowIndex..highIndex-1] as inven> |
| <#assign product = inven.getRelatedOne("Product", false)> |
| <#if facilityId?has_content> |
| </#if> |
| <#if ! product.equals( productTmp )> |
| <#assign quantityAvailableAtDate = 0> |
| <#assign errorEvents = delegator.findByAnd("MrpEvent", Static["org.apache.ofbiz.base.util.UtilMisc"].toMap("mrpEventTypeId", "ERROR", "productId", inven.productId), null, false)> |
| <#assign qohEvents = delegator.findByAnd("MrpEvent", Static["org.apache.ofbiz.base.util.UtilMisc"].toMap("mrpEventTypeId", "INITIAL_QOH", "productId", inven.productId), null, false)> |
| <#assign additionalErrorMessage = ""> |
| <#assign initialQohEvent = ""> |
| <#assign productFacility = ""> |
| <#if qohEvents?has_content> |
| <#assign initialQohEvent = Static["org.apache.ofbiz.entity.util.EntityUtil"].getFirst(qohEvents)> |
| </#if> |
| <#if initialQohEvent?has_content> |
| <#if initialQohEvent.quantity?has_content> |
| <#assign quantityAvailableAtDate = initialQohEvent.quantity> |
| </#if> |
| <#if initialQohEvent.facilityId?has_content> |
| <#assign productFacility = delegator.findOne("ProductFacility", Static["org.apache.ofbiz.base.util.UtilMisc"].toMap("facilityId", initialQohEvent.facilityId, "productId", inven.productId), false)!> |
| </#if> |
| <#else> |
| <#assign additionalErrorMessage = "No QOH information found, assuming 0."> |
| </#if> |
| <tr bgcolor="lightblue"> |
| <th> |
| <b>[${inven.productId}]</b> ${product.internalName!} |
| </th> |
| <td> |
| <#if productFacility?has_content> |
| <div> |
| <b>${uiLabelMap.ProductFacility}:</b> ${productFacility.facilityId!} |
| </div> |
| <div> |
| <b>${uiLabelMap.ProductMinimumStock}:</b> ${productFacility.minimumStock!} |
| </div> |
| <div> |
| <b>${uiLabelMap.ProductReorderQuantity}:</b> ${productFacility.reorderQuantity!} |
| </div> |
| <div> |
| <b>${uiLabelMap.ProductDaysToShip}:</b> ${productFacility.daysToShip!} |
| </div> |
| </#if> |
| </td> |
| <td colspan="5" align="right"> |
| <big><b>${quantityAvailableAtDate}</b></big> |
| </td> |
| </tr> |
| <#if additionalErrorMessage?has_content> |
| <tr> |
| <th colspan="7"><font color="red">${additionalErrorMessage}</font></th> |
| </tr> |
| </#if> |
| <#list errorEvents as errorEvent> |
| <tr> |
| <th colspan="7"><font color="red">${errorEvent.eventName!}</font></td> |
| </tr> |
| </#list> |
| </#if> |
| <#assign quantityAvailableAtDate = quantityAvailableAtDate?default(0) + inven.getBigDecimal("quantity")> |
| <#assign productTmp = product> |
| <#assign MrpEventType = inven.getRelatedOne("MrpEventType", false)> |
| <tr class="${rowClass}"> |
| <td>${MrpEventType.get("description",locale)}</td> |
| <td> </td> |
| <td>${inven.eventName!}</td> |
| <td><font <#if inven.isLate?default("N") == "Y">color='red'</#if>>${inven.getString("eventDate")}</font></td> |
| <td> </td> |
| <td align="right">${inven.getString("quantity")}</td> |
| <td align="right">${quantityAvailableAtDate!}</td> |
| </tr> |
| <#assign count=count+1> |
| </#list> |
| |
| </table> |
| <#else> |
| <br /> |
| <div align="center">${uiLabelMap.CommonNoElementFound}</div> |
| <br /> |
| </#if> |
| </td> |
| </tr> |
| </table> |
| </#if> |
