ftl

1.在ftl中调用服务

<#assign result=dispatcher.runSync("服务名",Static["org.ofbiz.base.util.UtilMisc"].toMap(key,value))>


2.在ftl中查询实体
<#assign  statusItemGen=delegator.findByPrimaryKey("StatusItem",Static["org.ofbiz.base.util.UtilMisc"].toMap("statusId",facc.statusId?if_exists))>


3.在groovy中如何获取应用中的某个文件
fileUrl=new ComponentLocationResolver().resolveLocation("component://应用名/目录/");
file=new File(fileUrl.getPath()+文件名);


或者
String fileName="文件名";
String location="component:////应用名/目录/";
URL locationUrl=FlexibleLocation.resolveLocation(location+fileName);



4.jdbc查询
public BigDecimal getOrderReceivedPaymentTotal(String orderId) {
//    String helperName = delegator.getGroupHelperName("org.ofbiz");
//    Connection conn =null;
//    Statement statement = null;
//    ResultSet rs = null;
//    BigDecimal db = null;
//    try {
//     conn = ConnectionFactory.getConnection(helperName);
//     statement = conn.createStatement();
//     statement.execute("SELECT sum(MAX_AMOUNT) FROM ORDER_PAYMENT_PREF_AND_PAYMENT where order_id='"+
//     orderId+"' and status_Id='PAYMENT_RECEIVED' and paymentStatusId='PMNT_RECEIVED'");
//     rs = statement.getResultSet();
//     if(rs.next()) {
//     db = rs.getBigDecimal(1);
//     }
//    } catch(Exception e) {
//    System.out.println(e);
//    } finally {
//    try {
//     if(rs != null) {
//     rs.close();
//     }
//     if(statement != null) {
//     statement.close();
//     }
//     if(conn != null) {
//     conn.close();
//     }
//    } catch(Exception e) {
//    System.out.println(e);
//    }
//    }
//        return db;
//    }



5.条件查询
exprList = [EntityCondition.makeCondition("partyId", EntityOperator.EQUALS, userLogin.partyId),
        EntityCondition.makeCondition("shoppingListTypeId", EntityOperator.EQUALS, "SLT_WISH_LIST"),
EntityCondition.makeCondition("listName", EntityOperator.NOT_EQUAL, "Auto Suggestions")];
condition = EntityCondition.makeCondition(exprList, EntityOperator.AND);
allShoppingLists = delegator.findList("ShoppingList", condition, null, ["createdStamp DESC"], null, false);

例如查询一个时间段
exprList = [EntityCondition.makeCondition("createdByUserLogin", EntityOperator.EQUALS, userLogin.userLoginId),
EntityCondition.makeCondition("createdDate", EntityOperator.BETWEEN, [UtilDateTime.getDayStart(UtilDateTime.nowTimestamp()),UtilDateTime.getDayEnd(UtilDateTime.nowTimestamp())])];
condition = EntityCondition.makeCondition(exprList, EntityOperator.AND);
productPromoCodes=delegator.findByCondition("ProductPromoCode",condition,null,null);

多种条件的组合
exprList = [EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, "PARTY_DISABLED")
            , EntityCondition.makeCondition("statusId", EntityOperator.NOT_EQUAL, null)];
CondList = EntityCondition.makeCondition(exprList, EntityOperator.AND);
CondList1 = EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, null);
statusPartyDisable = EntityCondition.makeCondition([CondList1, CondList], EntityOperator.OR);
entityConditionList = null;
if (prepareResult.entityConditionList != null) {
    ConditionList = [ prepareResult.entityConditionList, statusPartyDisable ];
    entityConditionList = EntityCondition.makeCondition(ConditionList);
} else if (context.noConditionFind == "Y") {
    entityConditionList = statusPartyDisable;
}

6.读取配置文件
currencyUom = UtilProperties.getPropertyValue("general.properties", "currency.uom.id.default", "CNY");

7.对查询的结果过滤
supProduct = EntityUtil.filterByDate(supProduct, UtilDateTime.nowTimestamp(), "availableFromDate", "availableThruDate", true);

8.更新记录
GenericValue pref = delegator.findByPrimaryKey("OrderPaymentPreference", UtilMisc.toMap("orderPaymentPreferenceId", prefId));
                pref.set("securityCode", securityCode);
                pref.store();

9.distinct语句的查询
List<EntityCondition> conditionList = UtilMisc.toList(
                        EntityCondition.makeCondition("contactListId", EntityOperator.EQUALS, contactList.get("contactListId")),
                        EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "CLPT_ACCEPTED"),
                        EntityCondition.makeCondition("preferredContactMechId", EntityOperator.NOT_EQUAL, null),
                        EntityUtil.getFilterByDateExpr(), EntityUtil.getFilterByDateExpr("contactFromDate", "contactThruDate")
                        );
            List<String> fieldsToSelect = UtilMisc.toList("infoString");

            EntityCondition conditions = EntityCondition.makeCondition(conditionList, EntityOperator.AND);
            List<GenericValue> sendToEmails = delegator.findByCondition("ContactListPartyAndContactMech", conditions,  null, fieldsToSelect, null,
                    new EntityFindOptions(true, EntityFindOptions.TYPE_SCROLL_INSENSITIVE, EntityFindOptions.CONCUR_READ_ONLY, true));