diff --git a/modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/ManualDataSourceForSelector.java b/modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/ManualDataSourceForSelector.java new file mode 100644 --- /dev/null +++ b/modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/ManualDataSourceForSelector.java @@ -0,0 +1,104 @@ +/* + ************************************************************************* + * The contents of this file are subject to the Openbravo Public License + * Version 1.1 (the "License"), being the Mozilla Public License + * Version 1.1 with a permitted attribution clause; you may not use this + * file except in compliance with the License. You may obtain a copy of + * the License at http://www.openbravo.com/legal/license.html + * Software distributed under the License is distributed on an "AS IS" + * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the + * License for the specific language governing rights and limitations + * under the License. + * The Original Code is Openbravo ERP. + * The Initial Developer of the Original Code is Openbravo SLU + * All portions are Copyright (C) 2010-2014 Openbravo SLU + * All Rights Reserved. + * Contributor(s): ______________________________________. + ************************************************************************ + */ +package org.openbravo.service.datasource; + +import java.util.ArrayList; +import java.util.List; +import java.util.Map; + +import org.codehaus.jettison.json.JSONArray; +import org.codehaus.jettison.json.JSONException; +import org.codehaus.jettison.json.JSONObject; +import org.hibernate.criterion.Restrictions; +import org.openbravo.dal.service.OBCriteria; +import org.openbravo.dal.service.OBDal; +import org.openbravo.model.common.businesspartner.BusinessPartner; +import org.openbravo.service.json.JsonConstants; + +public class ManualDataSourceForSelector extends BaseDataSourceService { + + @Override + public String add(Map parameters, String content) { + throw new UnsupportedOperationException( + "This operation is not supported by this data source implementation"); + } + + @Override + public String fetch(Map parameters) { + System.out.println("where_clause: " + parameters.get(JsonConstants.WHERE_PARAMETER)); + List businessPartners = getBusinessPartners(); + return getJSONResponse(businessPartners); + + } + + private List getBusinessPartners() { + OBCriteria criteria = OBDal.getInstance() + .createCriteria(BusinessPartner.class); + criteria.setMaxResults(100); + criteria.add(Restrictions.eq(BusinessPartner.PROPERTY_CUSTOMER, true)); + return criteria.list(); + } + + private String getJSONResponse(List businessPartners) { + final JSONObject jsonResult = new JSONObject(); + final JSONObject jsonResponse = new JSONObject(); + try { + jsonResponse.put(JsonConstants.RESPONSE_STATUS, JsonConstants.RPCREQUEST_STATUS_SUCCESS); + jsonResponse.put(JsonConstants.RESPONSE_STARTROW, 0); + jsonResponse.put(JsonConstants.RESPONSE_ENDROW, businessPartners.size() - 1); + jsonResponse.put(JsonConstants.RESPONSE_TOTALROWS, businessPartners.size()); + jsonResponse.put(JsonConstants.RESPONSE_DATA, new JSONArray( + convertToJSONObjects(businessPartners))); + jsonResult.put(JsonConstants.RESPONSE_RESPONSE, jsonResponse); + } catch (JSONException e) { + } + + return jsonResult.toString(); + } + + private List convertToJSONObjects(List businessPartners) { + final List jsonObjects = new ArrayList(); + for (BusinessPartner businessPartner : businessPartners) { + jsonObjects.add(convertToJSONObject(businessPartner)); + } + return jsonObjects; + } + + private JSONObject convertToJSONObject(BusinessPartner businessPartner) { + final JSONObject jsonObject = new JSONObject(); + try { + jsonObject.put("id", businessPartner.getId()); + jsonObject.put("name", businessPartner.getName()); + } catch (JSONException e) { + } + return jsonObject; + } + + @Override + public String remove(Map parameters) { + throw new UnsupportedOperationException( + "This operation is not supported by this data source implementation"); + } + + @Override + public String update(Map parameters, String content) { + throw new UnsupportedOperationException( + "This operation is not supported by this data source implementation"); + } +} diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml +++ b/src-db/database/sourcedata/AD_COLUMN.xml @@ -43122,8 +43122,8 @@ - - + + diff --git a/src-db/database/sourcedata/AD_REFERENCE.xml b/src-db/database/sourcedata/AD_REFERENCE.xml --- a/src-db/database/sourcedata/AD_REFERENCE.xml +++ b/src-db/database/sourcedata/AD_REFERENCE.xml @@ -6416,6 +6416,18 @@ + + + + + + + + + + + + diff --git a/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml b/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml --- a/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml +++ b/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml @@ -66,6 +66,20 @@ + + + + + + + + + + + + + + diff --git a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml @@ -201,6 +201,24 @@ + + + + + + + + + + + + + + + + + + diff --git a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml @@ -1470,6 +1470,25 @@ + + + + + + + + + + + + + + + + + + + @@ -1707,6 +1726,25 @@ + + + + + + + + + + + + + + + + + + +