| /* |
| * 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.math.BigDecimal |
| import java.util.* |
| import java.sql.Timestamp |
| import org.apache.ofbiz.entity.* |
| import org.apache.ofbiz.entity.condition.* |
| import org.apache.ofbiz.entity.util.* |
| import org.apache.ofbiz.base.util.* |
| |
| BigDecimal calcItemTotal(List headers) { |
| BigDecimal total = BigDecimal.ZERO |
| headers.each { header -> |
| total = total.plus(header.grandTotal ?: BigDecimal.ZERO) |
| } |
| return total |
| } |
| |
| double calcItemCount(List items) { |
| double count = 0.00 |
| items.each { item -> |
| count += item.quantity ?: 0.00 |
| } |
| return count |
| } |
| |
| dayBegin = UtilDateTime.getDayStart(nowTimestamp, timeZone, locale) |
| weekBegin = UtilDateTime.getWeekStart(nowTimestamp, timeZone, locale) |
| monthBegin = UtilDateTime.getMonthStart(nowTimestamp, timeZone, locale) |
| yearBegin = UtilDateTime.getYearStart(nowTimestamp, timeZone, locale) |
| |
| dayEnd = UtilDateTime.getDayEnd(nowTimestamp, timeZone, locale) |
| weekEnd = UtilDateTime.getWeekEnd(nowTimestamp, timeZone, locale) |
| monthEnd = UtilDateTime.getMonthEnd(nowTimestamp, timeZone, locale) |
| yearEnd = UtilDateTime.getYearEnd(nowTimestamp, timeZone, locale) |
| |
| // order status report |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("orderItemSeqId", EntityOperator.EQUALS, null), |
| EntityCondition.makeCondition("orderPaymentPreferenceId", EntityOperator.EQUALS, null), |
| EntityCondition.makeCondition("statusDatetime", EntityOperator.GREATER_THAN_EQUAL_TO, dayBegin), |
| EntityCondition.makeCondition("statusDatetime", EntityOperator.LESS_THAN_EQUAL_TO, dayEnd)], |
| EntityOperator.AND) |
| dayList = from("OrderStatus").where(ecl).queryList() |
| context.dayOrder = EntityUtil.filterByAnd(dayList, [statusId : "ORDER_CREATED"]) |
| context.dayApprove = EntityUtil.filterByAnd(dayList, [statusId : "ORDER_APPROVED"]) |
| context.dayComplete = EntityUtil.filterByAnd(dayList, [statusId : "ORDER_COMPLETED"]) |
| context.dayCancelled = EntityUtil.filterByAnd(dayList, [statusId : "ORDER_CANCELLED"]) |
| context.dayRejected = EntityUtil.filterByAnd(dayList, [statusId : "ORDER_REJECTED"]) |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("orderItemSeqId", EntityOperator.EQUALS, null), |
| EntityCondition.makeCondition("orderPaymentPreferenceId", EntityOperator.EQUALS, null), |
| EntityCondition.makeCondition("statusDatetime", EntityOperator.GREATER_THAN_EQUAL_TO, weekBegin), |
| EntityCondition.makeCondition("statusDatetime", EntityOperator.LESS_THAN_EQUAL_TO, weekEnd)], |
| EntityOperator.AND) |
| weekList = from("OrderStatus").where(ecl).queryList() |
| context.weekOrder = EntityUtil.filterByAnd(weekList, [statusId : "ORDER_CREATED"]) |
| context.weekApprove = EntityUtil.filterByAnd(weekList, [statusId: "ORDER_APPROVED"]) |
| context.weekComplete = EntityUtil.filterByAnd(weekList, [statusId : "ORDER_COMPLETED"]) |
| context.weekCancelled = EntityUtil.filterByAnd(weekList, [statusId : "ORDER_CANCELLED"]) |
| context.weekRejected = EntityUtil.filterByAnd(weekList, [statusId : "ORDER_REJECTED"]) |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("orderItemSeqId", EntityOperator.EQUALS, null), |
| EntityCondition.makeCondition("orderPaymentPreferenceId", EntityOperator.EQUALS, null), |
| EntityCondition.makeCondition("statusDatetime", EntityOperator.GREATER_THAN_EQUAL_TO, monthBegin), |
| EntityCondition.makeCondition("statusDatetime", EntityOperator.LESS_THAN_EQUAL_TO, monthEnd)], |
| EntityOperator.AND) |
| monthList = from("OrderStatus").where(ecl).queryList() |
| context.monthOrder = EntityUtil.filterByAnd(monthList, [statusId : "ORDER_CREATED"]) |
| context.monthApprove = EntityUtil.filterByAnd(monthList, [statusId : "ORDER_APPROVED"]) |
| context.monthComplete = EntityUtil.filterByAnd(monthList, [statusId : "ORDER_COMPLETED"]) |
| context.monthCancelled = EntityUtil.filterByAnd(monthList, [statusId : "ORDER_CANCELLED"]) |
| context.monthRejected = EntityUtil.filterByAnd(monthList, [statusId : "ORDER_REJECTED"]) |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("orderItemSeqId", EntityOperator.EQUALS, null), |
| EntityCondition.makeCondition("orderPaymentPreferenceId", EntityOperator.EQUALS, null), |
| EntityCondition.makeCondition("statusDatetime", EntityOperator.GREATER_THAN_EQUAL_TO, yearBegin), |
| EntityCondition.makeCondition("statusDatetime", EntityOperator.LESS_THAN_EQUAL_TO, yearEnd)], |
| EntityOperator.AND) |
| yearList = from("OrderStatus").where(ecl).queryList() |
| context.yearOrder = EntityUtil.filterByAnd(yearList, [statusId : "ORDER_CREATED"]) |
| context.yearApprove = EntityUtil.filterByAnd(yearList, [statusId : "ORDER_APPROVED"]) |
| context.yearComplete = EntityUtil.filterByAnd(yearList, [statusId : "ORDER_COMPLETED"]) |
| context.yearCancelled = EntityUtil.filterByAnd(yearList, [statusId : "ORDER_CANCELLED"]) |
| context.yearRejected = EntityUtil.filterByAnd(yearList, [statusId : "ORDER_REJECTED"]) |
| |
| // order totals and item counts |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("itemStatusId", EntityOperator.NOT_EQUAL, "ITEM_REJECTED"), |
| EntityCondition.makeCondition("itemStatusId", EntityOperator.NOT_EQUAL, "ITEM_CANCELLED"), |
| EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, dayBegin), |
| EntityCondition.makeCondition("orderDate", EntityOperator.LESS_THAN_EQUAL_TO, dayEnd), |
| EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, "SALES_ORDER")], |
| EntityOperator.AND) |
| dayItems = from("OrderHeaderAndItems").where(ecl).queryList() |
| dayItemsPending = EntityUtil.filterByAnd(dayItems, [itemStatusId : "ITEM_ORDERED"]) |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "ORDER_REJECTED"), |
| EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "ORDER_CANCELLED"), |
| EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, dayBegin), |
| EntityCondition.makeCondition("orderDate", EntityOperator.LESS_THAN_EQUAL_TO, dayEnd), |
| EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, "SALES_ORDER")], |
| EntityOperator.AND) |
| dayHeaders = from("OrderHeader").where(ecl).queryList() |
| dayHeadersPending = EntityUtil.filterByAnd(dayHeaders, [statusId : "ORDER_CREATED"]) |
| |
| dayItemTotal = calcItemTotal(dayHeaders) |
| dayItemCount = calcItemCount(dayItems) |
| dayItemTotalPending = calcItemTotal(dayHeadersPending) |
| dayItemCountPending = calcItemCount(dayItemsPending) |
| dayItemTotalPaid = dayItemTotal - dayItemTotalPending |
| dayItemCountPaid = dayItemCount - dayItemCountPending |
| context.dayItemTotal = dayItemTotal |
| context.dayItemCount = dayItemCount |
| context.dayItemTotalPending = dayItemTotalPending |
| context.dayItemCountPending = dayItemCountPending |
| context.dayItemTotalPaid = dayItemTotalPaid |
| context.dayItemCountPaid = dayItemCountPaid |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("itemStatusId", EntityOperator.NOT_EQUAL, "ITEM_REJECTED"), |
| EntityCondition.makeCondition("itemStatusId", EntityOperator.NOT_EQUAL, "ITEM_CANCELLED"), |
| EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, weekBegin), |
| EntityCondition.makeCondition("orderDate", EntityOperator.LESS_THAN_EQUAL_TO, weekEnd), |
| EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, "SALES_ORDER")], |
| EntityOperator.AND) |
| weekItems = from("OrderHeaderAndItems").where(ecl).queryList() |
| weekItemsPending = EntityUtil.filterByAnd(weekItems, [itemStatusId : "ITEM_ORDERED"]) |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "ORDER_REJECTED"), |
| EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "ORDER_CANCELLED"), |
| EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, weekBegin), |
| EntityCondition.makeCondition("orderDate", EntityOperator.LESS_THAN_EQUAL_TO, weekEnd), |
| EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, "SALES_ORDER")], |
| EntityOperator.AND) |
| weekHeaders = from("OrderHeader").where(ecl).queryList() |
| weekHeadersPending = EntityUtil.filterByAnd(weekHeaders, [statusId : "ORDER_CREATED"]) |
| |
| weekItemTotal = calcItemTotal(weekHeaders) |
| weekItemCount = calcItemCount(weekItems) |
| weekItemTotalPending = calcItemTotal(weekHeadersPending) |
| weekItemCountPending = calcItemCount(weekItemsPending) |
| weekItemTotalPaid = weekItemTotal - weekItemTotalPending |
| weekItemCountPaid = weekItemCount - weekItemCountPending |
| context.weekItemTotal = weekItemTotal |
| context.weekItemCount = weekItemCount |
| context.weekItemTotalPending = weekItemTotalPending |
| context.weekItemCountPending = weekItemCountPending |
| context.weekItemTotalPaid = weekItemTotalPaid |
| context.weekItemCountPaid = weekItemCountPaid |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("itemStatusId", EntityOperator.NOT_EQUAL, "ITEM_REJECTED"), |
| EntityCondition.makeCondition("itemStatusId", EntityOperator.NOT_EQUAL, "ITEM_CANCELLED"), |
| EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, monthBegin), |
| EntityCondition.makeCondition("orderDate", EntityOperator.LESS_THAN_EQUAL_TO, monthEnd), |
| EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, "SALES_ORDER")], |
| EntityOperator.AND) |
| monthItems = from("OrderHeaderAndItems").where(ecl).queryList() |
| monthItemsPending = EntityUtil.filterByAnd(monthItems, [itemStatusId : "ITEM_ORDERED"]) |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "ORDER_REJECTED"), |
| EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "ORDER_CANCELLED"), |
| EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, monthBegin), |
| EntityCondition.makeCondition("orderDate", EntityOperator.LESS_THAN_EQUAL_TO, monthEnd), |
| EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, "SALES_ORDER")], |
| EntityOperator.AND) |
| monthHeaders = from("OrderHeader").where(ecl).queryList() |
| monthHeadersPending = EntityUtil.filterByAnd(monthHeaders, [statusId : "ORDER_CREATED"]) |
| |
| monthItemTotal = calcItemTotal(monthHeaders) |
| monthItemCount = calcItemCount(monthItems) |
| monthItemTotalPending = calcItemTotal(monthHeadersPending) |
| monthItemCountPending = calcItemCount(monthItemsPending) |
| monthItemTotalPaid = monthItemTotal - monthItemTotalPending |
| monthItemCountPaid = monthItemCount - monthItemCountPending |
| context.monthItemTotal = monthItemTotal |
| context.monthItemCount = monthItemCount |
| context.monthItemTotalPending = monthItemTotalPending |
| context.monthItemCountPending = monthItemCountPending |
| context.monthItemTotalPaid = monthItemTotalPaid |
| context.monthItemCountPaid = monthItemCountPaid |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("itemStatusId", EntityOperator.NOT_EQUAL, "ITEM_REJECTED"), |
| EntityCondition.makeCondition("itemStatusId", EntityOperator.NOT_EQUAL, "ITEM_CANCELLED"), |
| EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, yearBegin), |
| EntityCondition.makeCondition("orderDate", EntityOperator.LESS_THAN_EQUAL_TO, yearEnd), |
| EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, "SALES_ORDER")], |
| EntityOperator.AND) |
| yearItems = from("OrderHeaderAndItems").where(ecl).queryList() |
| yearItemsPending = EntityUtil.filterByAnd(yearItems, [itemStatusId : "ITEM_ORDERED"]) |
| |
| ecl = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "ORDER_REJECTED"), |
| EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "ORDER_CANCELLED"), |
| EntityCondition.makeCondition("orderDate", EntityOperator.GREATER_THAN_EQUAL_TO, yearBegin), |
| EntityCondition.makeCondition("orderDate", EntityOperator.LESS_THAN_EQUAL_TO, yearEnd), |
| EntityCondition.makeCondition("orderTypeId", EntityOperator.EQUALS, "SALES_ORDER")], |
| EntityOperator.AND) |
| yearHeaders = from("OrderHeader").where(ecl).queryList() |
| yearHeadersPending = EntityUtil.filterByAnd(yearHeaders, [statusId : "ORDER_CREATED"]) |
| |
| yearItemTotal = calcItemTotal(yearHeaders) |
| yearItemCount = calcItemCount(yearItems) |
| yearItemTotalPending = calcItemTotal(yearHeadersPending) |
| yearItemCountPending = calcItemCount(yearItemsPending) |
| yearItemTotalPaid = yearItemTotal - yearItemTotalPending |
| yearItemCountPaid = yearItemCount - yearItemCountPending |
| context.yearItemTotal = yearItemTotal |
| context.yearItemCount = yearItemCount |
| context.yearItemTotalPending = yearItemTotalPending |
| context.yearItemCountPending = yearItemCountPending |
| context.yearItemTotalPaid = yearItemTotalPaid |
| context.yearItemCountPaid = yearItemCountPaid |
| |
| // order state report |
| waitingPayment = from("OrderHeader").where("statusId", "ORDER_CREATED", "orderTypeId", "SALES_ORDER").queryList() |
| context.waitingPayment = waitingPayment.size() |
| |
| waitingApproval = from("OrderHeader").where("statusId", "ORDER_PROCESSING", "orderTypeId", "SALES_ORDER").queryList() |
| context.waitingApproval = waitingApproval.size() |
| |
| waitingComplete = from("OrderHeader").where("statusId", "ORDER_APPROVED", "orderTypeId", "SALES_ORDER").queryList() |
| context.waitingComplete = waitingComplete.size() |
