| /* |
| * 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 org.ofbiz.base.util.*; |
| import org.ofbiz.entity.util.*; |
| import java.text.SimpleDateFormat; |
| import java.util.List; |
| import java.util.Set; |
| import org.ofbiz.entity.condition.EntityCondition; |
| import org.ofbiz.entity.condition.EntityOperator; |
| import org.ofbiz.entity.util.EntityFindOptions |
| |
| def limit = 13 // set number of days |
| def sdf = new SimpleDateFormat("EEEE yyyy-MM-dd 00:00:00.000") |
| def sdf2 = new SimpleDateFormat("EEEE dd/MM/yyyy") |
| def sdfTime = new SimpleDateFormat("HH:mm") |
| def today = new Date() |
| |
| for(i in 0..limit){ |
| def date1 = sdf.format(today-i) |
| def date2 = sdf.format(today-i+1) |
| def parseDate1 = sdf.parse(date1) |
| def parseDate2 = sdf.parse(date2) |
| def timeStampDate1 = UtilDateTime.toTimestamp(parseDate1) |
| def timeStampDate2 = UtilDateTime.toTimestamp(parseDate2) |
| // make condition for distinct productId |
| def exprs = [] |
| exprs.add(EntityCondition.makeCondition("productContentTypeId",EntityOperator.EQUALS, "IMAGE")) |
| exprs.add(EntityCondition.makeCondition("statusId",EntityOperator.EQUALS, "IM_APPROVED")) |
| exprs.add(EntityCondition.makeCondition("purchaseFromDate", EntityOperator.GREATER_THAN_EQUAL_TO, timeStampDate1)) |
| exprs.add(EntityCondition.makeCondition("purchaseFromDate", EntityOperator.LESS_THAN, timeStampDate2)) |
| def fieldsToSelect = UtilMisc.toSet("productId") |
| def findOptions = new EntityFindOptions() |
| findOptions.setDistinct(true) |
| // query result |
| def productContentAndInfoList = delegator.findList("ProductContentAndInfo", EntityCondition.makeCondition(exprs, EntityOperator.AND), fieldsToSelect, null, findOptions, false) |
| |
| // finding time |
| def orderBy = UtilMisc.toList("productId") |
| def timeList = delegator.findList("ProductContentAndInfo", EntityCondition.makeCondition(exprs, EntityOperator.AND), null, orderBy, null, false) |
| def groupByTimeList = timeList.groupBy{it.productId} |
| def tempTimeList = [] |
| groupByTimeList.each() { |
| key,value -> tempTimeList.add(value.purchaseFromDate) |
| } |
| |
| def time = [] |
| if(tempTimeList.size > 0){ |
| for(j in 0..tempTimeList.size-1){ |
| time.add(sdfTime.format(tempTimeList.get(j).get(0))) |
| } |
| } |
| def showDate = sdf2.format(today-i) |
| |
| switch (i) { |
| case 0: context.approved_0 = productContentAndInfoList; context.time_0 = time; context.date0 = showDate; |
| context.timeStampDate1_0 = timeStampDate1; context.timeStampDate2_0 = timeStampDate2; break; |
| case 1: context.approved_1 = productContentAndInfoList; context.time_1 = time; context.date1 = showDate; |
| context.timeStampDate1_1 = timeStampDate1; context.timeStampDate2_1 = timeStampDate2; break; |
| case 2: context.approved_2 = productContentAndInfoList; context.time_2 = time; context.date2 = showDate; |
| context.timeStampDate1_2 = timeStampDate1; context.timeStampDate2_2 = timeStampDate2; break; |
| case 3: context.approved_3 = productContentAndInfoList; context.time_3 = time; context.date3 = showDate; |
| context.timeStampDate1_3 = timeStampDate1; context.timeStampDate2_3 = timeStampDate2; break; |
| case 4: context.approved_4 = productContentAndInfoList; context.time_4 = time; context.date4 = showDate; |
| context.timeStampDate1_4 = timeStampDate1; context.timeStampDate2_4 = timeStampDate2; break; |
| case 5: context.approved_5 = productContentAndInfoList; context.time_5 = time; context.date5 = showDate; |
| context.timeStampDate1_5 = timeStampDate1; context.timeStampDate2_5 = timeStampDate2; break; |
| case 6: context.approved_6 = productContentAndInfoList; context.time_6 = time; context.date6 = showDate; |
| context.timeStampDate1_6 = timeStampDate1; context.timeStampDate2_6 = timeStampDate2; break; |
| case 7: context.approved_7 = productContentAndInfoList; context.time_7 = time; context.date7 = showDate; |
| context.timeStampDate1_7 = timeStampDate1; context.timeStampDate2_7 = timeStampDate2; break; |
| case 8: context.approved_8 = productContentAndInfoList; context.time_8 = time; context.date8 = showDate; |
| context.timeStampDate1_8 = timeStampDate1; context.timeStampDate2_8 = timeStampDate2; break; |
| case 9: context.approved_9 = productContentAndInfoList; context.time_9 = time; context.date9 = showDate; |
| context.timeStampDate1_9 = timeStampDate1; context.timeStampDate2_9 = timeStampDate2; break; |
| case 10: context.approved_10 = productContentAndInfoList; context.time_10 = time; context.date10 = showDate; |
| context.timeStampDate1_10 = timeStampDate1; context.timeStampDate2_10 = timeStampDate2; break; |
| case 11: context.approved_11 = productContentAndInfoList; context.time_11 = time; context.date11 = showDate; |
| context.timeStampDate1_11 = timeStampDate1; context.timeStampDate2_11 = timeStampDate2; break; |
| case 12: context.approved_12 = productContentAndInfoList; context.time_12 = time; context.date12 = showDate; |
| context.timeStampDate1_12 = timeStampDate1; context.timeStampDate2_12 = timeStampDate2; break; |
| case 13: context.approved_13 = productContentAndInfoList; context.time_13 = time; context.date13 = showDate; |
| context.timeStampDate1_13 = timeStampDate1; context.timeStampDate2_13 = timeStampDate2; break; |
| default: context.error = "error"; |
| } |
| } |
