Nuevo en Odoo, estoy tratando de crear un servicio web en Java, cargando datos en Odoo, en particular, en los modelos product.template y technical.sheet, un modelo personalizado que creé. Para un producto puede haber 0 o muchas hojas técnicas y para una hoja técnica: un producto. En el modelo technical.sheet creé un campo x_product_id, el tipo - many2one y la relación de objeto - product.tamplate. En product.template creo el mismo campo, x_product_id, pero el tipo es one2many, la relación de objeto - technical.sheet y la relación de campo x_product_id (technical.sheet). Logré cargar los productos y las hojas técnicas, pero cuando intento configurar los campos relacionales, obtengo errores. ¿Alguien tiene un ejemplo o una idea de cómo configurar campos de tipo one2many, many2one y many2many, utilizando la API externa de Odoo? ¡Gracias! Esta es la pieza de código:

Para (Artículo artículo: artículos.valores ()) {

if(article.getTechSheets().size()>0){
        technicalSheetsMap.put(article.getMfsIdentifier(), article.getTechSheets());
}

ArrayList<Integer> techSheetsIds = new ArrayList<>();

for(TechnicalSheet sh: article.getTechSheets()){
    techSheetsIds.add(Integer.valueOf(sh.getId()));
}

ArrayList<Integer> arrids = new ArrayList<Integer>();
arrids.add(Integer.valueOf(article.getMfsIdentifier()));

/* Load of the article into model product.tamplate of the odoo database */
final Integer id = (Integer)models.execute("execute_kw", Arrays.asList(
           db, uid, password,"product.template", "create",
                 Arrays.asList(new HashMap() {{ 
                                               put("is_published", true);
                                               put("active", true);
                                               put("x_standartization_level", article.getStandartizationLevel());
                                               put("id", Integer.valueOf(article.getMfsIdentifier()));
                                               put("default_code", article.getCode());
                                               put("name", article.getLabelEn());
                                               put("x_msf_identifier", article.getMfsIdentifier());
                                               put("display_name", article.getLabelEn());
                                               put("x_label_en", article.getLabelEn());
                                               put("x_oca", article.isOca());
                                               put("x_ocb", article.isOcb());
                                               put("x_ocba", article.isOcba());
                                               put("x_ocg", article.isOcg());
                                               put("x_ocp", article.isOcp());
                                               put("x_cold_chain_group", article.getTermosensitive());
                                               put("x_justification_id", article.getJustificationId());
                                               put("x_transport_un_code_id", article.getTransportUnCodeId());
                                               put("x_picture_content", article.getPictureNb());
                                               put("x_picture_label", article.getPictureLabel());
                                               put("x_controlled_substance", article.getControlledSubstance());
                                               put("x_medical_device_class", article.getMedicalDeviceClass());
                                               put("x_code", article.getCode());
                                               put("x_type", article.getType());
                                               put("x_family_id", article.getFamilyId());
                                               put("x_group_id", article.getGroupId());
                                               put("x_who_id", article.getWhoIds());
                                               put("x_product_id", Integer.valueOf(article.getMfsIdentifier()));
                                                       }})

                  ));



                  for(TechnicalSheet sheet: article.getTechSheets()){


                          final Integer idsh = (Integer)models.execute("execute_kw", Arrays.asList(
                                 db, uid, password,
                               "x_product.technical_sheet", 
                               "create",
                               Arrays.asList(new HashMap(){{    
                                                             put("id", sheet.getId());
                                                             put("x_name", sheet.getLabelEn());
                                                             put("x_description", sheet.getDefinition());
                                                             put("display_name", sheet.getLabelEn());
                                                             put("x_product_id", Integer.valueOf(article.getMfsIdentifier()));
                                                             put("x_norms", sheet.getNorms());
                                                             put("x_precat", sheet.getPrecat());
                                                           }})
                         ));

                  }

          }
0
user13332980 16 abr. 2020 a las 21:04

2 respuestas

La mejor respuesta

Para rellenar o manipular one2many o many2many field con los valores (registros) correspondientes, debe usar comandos especiales.

En el siguiente ejemplo, agregamos una nueva línea de pedido (order_line One2many):

main.models.execute("execute_kw", Arrays.asList(
            main.db, uid, main.password,
            "sale.order", "write",
            Arrays.asList(
                Arrays.asList(20),
                new HashMap() {{ 
                        put("order_line", 
                             Arrays.asList(
                                 Arrays.asList(0, 0, 
                                    new HashMap() {{
                                        put("product_id", 3);
                                    }}
                                 )
                             )
                        ); 
                }}
            )
        ));
0
Kenly 18 abr. 2020 a las 03:08

Este código funcionó. Creé una lista de artículos (product.template), cada artículo está relacionado con cero o muchas hojas técnicas (un modelo personalizado que creé en odoo), relación - one2many.

Artículos HashMap = (HashMap) globalMap.get ("artículos");

          String username = "****";
          String password = "****";
          String db = "****";
          String url ="****";

          try{

          final XmlRpcClient authClient = new XmlRpcClient();
          final XmlRpcClientConfigImpl authStartConfig = new XmlRpcClientConfigImpl();
          authStartConfig.setServerURL(new URL(String.format("%s/xmlrpc/2/common", url)));

          List configList = new ArrayList();
          Map paramMap = new HashMap(); 

          configList.add(db);
          configList.add(username);
          configList.add(password);
          configList.add(paramMap);

          int uid = (int)authClient.execute(authStartConfig, "authenticate", configList);

          final XmlRpcClient models = new XmlRpcClient() {{
                      setConfig(new XmlRpcClientConfigImpl() {{
                          setServerURL(new URL(String.format("%s/xmlrpc/2/object", url)));
                      }});
          }};

          /* Loop all the articles */
          for(Article article: articles.values()) {

                  if(article.getTechSheets().size()>0){
                      technicalSheetsMap.put(article.getMfsIdentifier(), article.getTechSheets());
                  }


                  ArrayList<Integer> techSheetsIds = new ArrayList<>();
                  for(TechnicalSheet sh: article.getTechSheets()){
                     techSheetsIds.add(Integer.valueOf(sh.getId()));
                  }


                  ArrayList<Integer> arrids = new ArrayList<Integer>();
                  arrids.add(Integer.valueOf(article.getMfsIdentifier()));

                  /* Load of the articles into model product.template of the odoo database */

                  final Integer id = (Integer)models.execute("execute_kw", Arrays.asList(
                        db, uid, password,
                        "product.template", "create",
                        Arrays.asList(new HashMap() {{ 
                                                       put("is_published", true);
                                                       put("active", true);
                                                       put("x_standartization_level", article.getStandartizationLevel());
                                                       put("id", Integer.valueOf(article.getMfsIdentifier()));
                                                       put("default_code", article.getCode());
                                                       put("name", article.getLabelEn());
                                                       put("x_msf_identifier", article.getMfsIdentifier());
                                                       put("display_name", article.getLabelEn());
                                                       put("x_label_en", article.getLabelEn());
                                                       put("x_oca", article.isOca());
                                                       put("x_ocb", article.isOcb());
                                                       put("x_ocba", article.isOcba());
                                                       put("x_ocg", article.isOcg());
                                                       put("x_ocp", article.isOcp());
                                                       put("x_cold_chain_group", article.getTermosensitive());
                                                       put("x_justification_id", article.getJustificationId());
                                                       put("x_transport_un_code_id", article.getTransportUnCodeId());
                                                       put("x_picture_content", article.getPictureNb());
                                                       put("x_picture_label", article.getPictureLabel());
                                                       put("x_controlled_substance", article.getControlledSubstance());
                                                       put("x_medical_device_class", article.getMedicalDeviceClass());
                                                       put("x_code", article.getCode());
                                                       put("x_type", article.getType());
                                                       put("x_family_id", article.getFamilyId());
                                                       put("x_group_id", article.getGroupId());
                                                       put("x_who_id", article.getWhoIds());

                                                       /* Set Technical Sheets*/
                                                       if(article.getTechSheets().size()>0){
                                                           put("x_product_id", 
                                                               Arrays.asList(
                                                                    Arrays.asList(
                                                                       0, 
                                                                       0, 
                                                                       new HashMap(){{
                                                                                      for(TechnicalSheet sheet: article.getTechSheets()){
                                                                                          put("id", sheet.getId());
                                                                                          put("x_name", sheet.getLabelEn());
                                                                                          put("x_description", sheet.getDefinition());
                                                                                          put("display_name", sheet.getLabelEn());
                                                                                          put("x_product_id", article.getMfsIdentifier());
                                                                                          put("x_norms", sheet.getNorms());
                                                                                          put("x_precat", sheet.getPrecat());
                                                                                        }
                                                                                        }}
                                                                                        )));
                                                       }}})

                  ));

          }

          }catch(MalformedURLException e){
              System.out.print("MalformedURLException: "+e.toString()+" "+e.getStackTrace());
          }
          catch(XmlRpcException e){
              System.out.print("XmlRpcException: "+e.toString()+" "+e.getStackTrace());
          }  
0
user13332980 20 abr. 2020 a las 07:26