| /* |
| * 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. |
| */ |
| |
| import java.util.* |
| import java.sql.Timestamp |
| import org.apache.ofbiz.entity.* |
| import org.apache.ofbiz.base.util.* |
| import org.apache.ofbiz.entity.util.* |
| |
| module = "FindOrders.groovy" |
| |
| // get the order types |
| orderTypes = from("OrderType").orderBy("description").queryList() |
| context.orderTypes = orderTypes |
| |
| // get the role types |
| roleTypes = from("RoleType").orderBy("description").queryList() |
| context.roleTypes = roleTypes |
| |
| // get the order statuses |
| orderStatuses = from("StatusItem").where("statusTypeId", "ORDER_STATUS").orderBy("sequenceId", "description").queryList() |
| context.orderStatuses = orderStatuses |
| |
| // get websites |
| websites = from("WebSite").orderBy("siteName").queryList() |
| context.webSites = websites |
| |
| // get the stores |
| stores = from("ProductStore").orderBy("storeName").queryList() |
| context.productStores = stores |
| |
| // get the channels |
| channels = from("Enumeration").where("enumTypeId", "ORDER_SALES_CHANNEL").orderBy("sequenceId").queryList() |
| context.salesChannels = channels |
| |
| // get the Shipping Methods |
| carrierShipmentMethods = from("CarrierShipmentMethod").queryList() |
| context.carrierShipmentMethods = carrierShipmentMethods |
| |
| // get the Payment Status |
| paymentStatusList = from("StatusItem").where("statusTypeId", "PAYMENT_PREF_STATUS").orderBy("description").queryList() |
| context.paymentStatusList = paymentStatusList |
| |
| // get the good identification types |
| goodIdentificationTypes = from("GoodIdentificationType").orderBy("goodIdentificationTypeId", "description").queryList() |
| context.goodIdentificationTypes = goodIdentificationTypes |
| |
| // current role type |
| currentRoleTypeId = request.getParameter("roleTypeId") |
| if (currentRoleTypeId) { |
| currentRole = from("RoleType").where("roleTypeId", currentRoleTypeId).cache(true).queryOne() |
| context.currentRole = currentRole |
| } |
| |
| // current selected type |
| currentTypeId = request.getParameter("orderTypeId") |
| if (currentTypeId) { |
| currentType = from("OrderType").where("orderTypeId", currentTypeId).cache(true).queryOne() |
| context.currentType = currentType |
| } |
| // current selected status |
| currentStatusIds = request.getParameter("orderStatusId") |
| context.currentStatuses = currentStatusIds |
| |
| // current website |
| currentWebSiteId = request.getParameter("orderWebSiteId") |
| if (currentWebSiteId) { |
| currentWebSite = from("WebSite").where("webSiteId", currentWebSiteId).cache(true).queryOne() |
| context.currentWebSite = currentWebSite |
| } |
| |
| // current store |
| currentProductStoreId = request.getParameter("productStoreId") |
| if (currentProductStoreId) { |
| currentProductStore = from("ProductStore").where("productStoreId", currentProductStoreId).cache(true).queryOne() |
| context.currentProductStore = currentProductStore |
| } |
| |
| // current Shipping Method |
| shipmentMethod = request.getParameter("shipmentMethod") |
| if (shipmentMethod) { |
| carrierPartyId = shipmentMethod.substring(0, shipmentMethod.indexOf("@")) |
| shipmentMethodTypeId = shipmentMethod.substring(shipmentMethod.indexOf("@")+1) |
| if (carrierPartyId && shipmentMethodTypeId) { |
| currentCarrierShipmentMethod = from("CarrierShipmentMethod").where("partyId", carrierPartyId, "shipmentMethodTypeId", shipmentMethodTypeId).queryFirst() |
| context.currentCarrierShipmentMethod = currentCarrierShipmentMethod |
| } |
| } |
| |
| // current channel |
| currentSalesChannelId = request.getParameter("salesChannelEnumId") |
| if (currentSalesChannelId) { |
| currentSalesChannel = from("Enumeration").where("enumId", currentSalesChannelId).queryOne() |
| context.currentSalesChannel = currentSalesChannel |
| } |
| |
| // current good identification type |
| currentGoodIdentificationTypeId = request.getParameter("goodIdentificationTypeId") |
| if (currentGoodIdentificationTypeId) { |
| currentGoodIdentificationType = from("GoodIdentificationType").where("goodIdentificationTypeId", currentGoodIdentificationTypeId).queryOne() |
| context.currentGoodIdentificationType = currentGoodIdentificationType |
| } |
| |
| // create the fromDate for calendar |
| fromCal = Calendar.getInstance() |
| fromCal.setTime(new java.util.Date()) |
| fromCal.set(Calendar.DAY_OF_WEEK, fromCal.getActualMinimum(Calendar.DAY_OF_WEEK)) |
| fromCal.set(Calendar.HOUR_OF_DAY, fromCal.getActualMinimum(Calendar.HOUR_OF_DAY)) |
| fromCal.set(Calendar.MINUTE, fromCal.getActualMinimum(Calendar.MINUTE)) |
| fromCal.set(Calendar.SECOND, fromCal.getActualMinimum(Calendar.SECOND)) |
| fromCal.set(Calendar.MILLISECOND, fromCal.getActualMinimum(Calendar.MILLISECOND)) |
| fromTs = new Timestamp(fromCal.getTimeInMillis()) |
| fromStr = fromTs.toString() |
| fromStr = fromStr.substring(0, fromStr.indexOf('.')) |
| context.fromDateStr = fromStr |
| |
| // create the thruDate for calendar |
| toCal = Calendar.getInstance() |
| toCal.setTime(new java.util.Date()) |
| toCal.set(Calendar.DAY_OF_WEEK, toCal.getActualMaximum(Calendar.DAY_OF_WEEK)) |
| toCal.set(Calendar.HOUR_OF_DAY, toCal.getActualMaximum(Calendar.HOUR_OF_DAY)) |
| toCal.set(Calendar.MINUTE, toCal.getActualMaximum(Calendar.MINUTE)) |
| toCal.set(Calendar.SECOND, toCal.getActualMaximum(Calendar.SECOND)) |
| toCal.set(Calendar.MILLISECOND, toCal.getActualMaximum(Calendar.MILLISECOND)) |
| toTs = new Timestamp(toCal.getTimeInMillis()) |
| toStr = toTs.toString() |
| context.thruDateStr = toStr |
| |
| // set the page parameters |
| viewIndex = request.getParameter("viewIndex") ? Integer.valueOf(request.getParameter("viewIndex")) : 1 |
| context.viewIndex = viewIndex |
| |
| viewSize = request.getParameter("viewSize") ? Integer.valueOf(request.getParameter("viewSize")) : |
| EntityUtilProperties.getPropertyValue("widget", "widget.form.defaultViewSize", "20", delegator) |
| context.viewSize = viewSize |
| |
| // get the lookup flag |
| lookupFlag = request.getParameter("lookupFlag") |
| |
| // fields from the service call |
| paramList = request.getAttribute("paramList") ?: "" |
| context.paramList = paramList |
| |
| if (paramList) { |
| paramIds = paramList.split("&") |
| context.paramIdList = Arrays.asList(paramIds) |
| } |
| |
| orderList = request.getAttribute("orderList") |
| context.orderList = orderList |
| |
| orderListSize = request.getAttribute("orderListSize") |
| context.orderListSize = orderListSize |
| |
| context.filterInventoryProblems = request.getAttribute("filterInventoryProblemsList") |
| context.filterPOsWithRejectedItems = request.getAttribute("filterPOsWithRejectedItemsList") |
| context.filterPOsOpenPastTheirETA = request.getAttribute("filterPOsOpenPastTheirETAList") |
| context.filterPartiallyReceivedPOs = request.getAttribute("filterPartiallyReceivedPOsList") |
| |
| lowIndex = request.getAttribute("lowIndex") |
| context.lowIndex = lowIndex |
| |
| highIndex = request.getAttribute("highIndex") |
| context.highIndex = highIndex |
