Package net.datacrow.core.objects

Examples of net.datacrow.core.objects.DcField

479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
      addEntries(sql, module);
      return sql.toString();
    }
   
    public String toSQL(int[] fields, boolean order, boolean includeMod) {
        DcField field;
       
        DcModule m = DcModules.get(getModule());
        int[] queryFields = fields == null || fields.length == 0 ? m.getFieldIndices() : fields;
       
        Collection<DcModule> modules = new ArrayList<DcModule>();
        if (m.isAbstract())
          modules.addAll(DcModules.getPersistentModules(m));
        else
          modules.add(m);
       
        StringBuffer sql = new StringBuffer();
       
        int columnCounter = 0;
        int moduleCounter = 0;
        if (m.isAbstract()) {
          sql.append("SELECT MODULEIDX");
          for (int idx : queryFields) {
        field = m.getField(idx);
        if (!field.isUiOnly()) {
          sql.append(", ");
          sql.append(field.getDatabaseFieldName());
          columnCounter++;
        }
      }
         
          sql.append(" FROM (");
        }
       
        for (DcModule module : modules) {
          columnCounter = 0;
          if (moduleCounter > 0)
        sql.append(" UNION ");
     
        sql.append(" SELECT ");
           
           if (m.isAbstract() || includeMod) {
            sql.append(module.getIndex());
            sql.append(" AS MODULEIDX ");
            columnCounter++;
          }
     
      if (m.isAbstract()) {
        for (DcField abstractField : m.getFields()) {
          if (!abstractField.isUiOnly()) {
            if (columnCounter > 0) sql.append(", ");
            sql.append(abstractField.getDatabaseFieldName());
            columnCounter++;
          }
        }
      } else {
        for (int idx : queryFields) {
          field = m.getField(idx);
          if (!field.isUiOnly()) {
            if (columnCounter > 0) sql.append(", ");
            sql.append(field.getDatabaseFieldName());
            columnCounter++;
          }
        }
      }
     
View Full Code Here
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
    Object value;
        int operator;
        int counter2;
        int counter = 0;
        String queryValue = null;
        DcField field;
       
        DcModule m = DcModules.get(getModule());
       
        for (DataFilterEntry entry : getEntries()) {
         
          if (!m.isAbstract()) {
            entryModule = DcModules.get(entry.getModule());
              if (entry.getModule() != getModule()) {
                  childEntries.add(entry);
                  continue;
              }
          } else {
            entryModule = module;
          }
           
            field = entryModule.getField(entry.getField());
           
            if (    field.isUiOnly() &&
                    field.getValueType() != DcRepository.ValueTypes._DCOBJECTCOLLECTION &&
                    field.getValueType() != DcRepository.ValueTypes._PICTURE)
                continue;
           
            hasConditions = true;
           
            operator = entry.getOperator().getIndex();
            value = entry.getValue() != null ? Utilities.getQueryValue(entry.getValue(), field) : null;
           
            if (value != null) {
                queryValue = String.valueOf(value);
                if (field.getValueType() == DcRepository.ValueTypes._DATE ||
                    field.getValueType() == DcRepository.ValueTypes._STRING) {
                    queryValue = queryValue.replaceAll("\'", "''");
                }
            }
           
            if (counter > 0) sql.append(entry.isAnd() ? " AND " : " OR ");
           
            if (counter == 0) sql.append(" WHERE ");
           
           
            boolean useUpper = field.getValueType() == DcRepository.ValueTypes._STRING &&
                field.getIndex() != DcObject._ID &&
                field.getValueType() != DcRepository.ValueTypes._DCOBJECTREFERENCE &&
                field.getValueType() != DcRepository.ValueTypes._DCPARENTREFERENCE &&
                field.getValueType() != DcRepository.ValueTypes._DCOBJECTCOLLECTION;
           
            if (field.getValueType() == DcRepository.ValueTypes._STRING) {
                if (useUpper) sql.append("UPPER(");
                sql.append(field.getDatabaseFieldName());
                if (useUpper) sql.append(")");
            } else if (field.getValueType() == DcRepository.ValueTypes._DCOBJECTCOLLECTION ||
                       field.getValueType() == DcRepository.ValueTypes._PICTURE) {
                sql.append("ID");
            } else {
                sql.append(field.getDatabaseFieldName());
            }
           
            if (field.getValueType() == DcRepository.ValueTypes._PICTURE) {
               
                if (operator == Operator.IS_EMPTY.getIndex())
                    sql.append(" NOT");
               
                DcModule picModule = DcModules.get(DcModules._PICTURE);
                sql.append(" IN (SELECT OBJECTID FROM " + picModule.getTableName() +
                           " WHERE " + picModule.getField(Picture._B_FIELD).getDatabaseFieldName() +
                           " = '" + field.getDatabaseFieldName() + "')");
               
            } else if ( operator == Operator.CONTAINS.getIndex() ||
                        operator == Operator.DOES_NOT_CONTAIN.getIndex() ||
                       (operator == Operator.EQUAL_TO.getIndex() && field.getValueType() == DcRepository.ValueTypes._DCOBJECTCOLLECTION) ||
                       (operator == Operator.NOT_EQUAL_TO.getIndex() && field.getValueType() == DcRepository.ValueTypes._DCOBJECTCOLLECTION)) {

                if (field.getValueType() == DcRepository.ValueTypes._DCOBJECTCOLLECTION) {
                    if (operator == Operator.DOES_NOT_CONTAIN.getIndex() ||
                        operator == Operator.NOT_EQUAL_TO.getIndex())
                        sql.append(" NOT");

                    sql.append(" IN (");
                   
                    DcModule mapping = DcModules.get(DcModules.getMappingModIdx(entryModule.getIndex(), field.getReferenceIdx(), field.getIndex()));
                  sql.append("SELECT ");
                    sql.append(mapping.getField(DcMapping._A_PARENT_ID).getDatabaseFieldName());
                    sql.append(" FROM ");
                    sql.append(mapping.getTableName());
                    sql.append(" WHERE ");
View Full Code Here
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
   
    private void addOrderBy(StringBuffer sql) {
      int counter = 0;
        DcModule module = DcModules.get(getModule());
        DcModule referenceMod;
        DcField field = module.getField(module.getDefaultSortFieldIdx());
        if (order != null && order.length > 0) {
            for (DcField orderOn : order) {
                if (orderOn != null) {
                  sql.append(counter == 0 ? " ORDER BY " : ", ");
                  if (orderOn.getValueType() == DcRepository.ValueTypes._DCOBJECTREFERENCE ||
                      orderOn.getValueType() == DcRepository.ValueTypes._DCOBJECTCOLLECTION) {

                      referenceMod = DcModules.get(orderOn.getReferenceIdx());
                        sql.append(referenceMod.getTableName());
                        sql.append(".");
                        sql.append(referenceMod.getField(referenceMod.getSystemDisplayFieldIdx()).getDatabaseFieldName());
                  } else if (!orderOn.isUiOnly() && orderOn.getDatabaseFieldName() != null) {
                      sql.append(orderOn.getDatabaseFieldName());
                  }
                  counter++;
                }
            }
           
            if (counter > 0)
              sql.append(getSortOrder() == _SORTORDER_ASCENDING ? "" : " DESC");
           
        } else if (field != null && !field.isUiOnly()) {
            sql.append(" ORDER BY ");
            sql.append(module.getField(module.getDefaultSortFieldIdx()).getDatabaseFieldName());
        }
    }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
  }
 
  public void save() {
    int[] picOrder = new int[table.getRowCount()];
    for (int i = 0; i < table.getRowCount(); i++) {
      DcField field = (DcField) table.getValueAt(i, 0);
      picOrder[i] = field.getIndex();
    }
    DcModules.get(module).setSetting(DcRepository.ModuleSettings.stCardViewPictureOrder, picOrder);
  }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
                GridBagConstraints.CENTER, GridBagConstraints.NONE,
                new Insets(0, 5, 5, 5), 0, 0));
       
        Collection<DcField> fields = new ArrayList<DcField>();
        for (int fieldIdx : DcModules.get(module).getSettings().getIntArray(DcRepository.ModuleSettings.stCardViewPictureOrder)) {
            DcField field = DcModules.get(module).getField(fieldIdx);
            if (field.getValueType() == DcRepository.ValueTypes._PICTURE && !fields.contains(field))
                fields.add(field);
        }

        for (DcField field : DcModules.get(module).getFields()) {
            if (field.getValueType() == DcRepository.ValueTypes._PICTURE && !fields.contains(field))
                fields.add(field);
        }
       
        for (DcField field : fields)
            table.addRow(new Object[] {field});
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
        if (order == _SORTORDER_DESCENDING) {
            o1 = dco2.getValue(field);
            o2 = dco1.getValue(field);
        }
       
        DcField fld = dco1.getField(field);
        if (o1 instanceof Number && o2 instanceof Number &&
            fld.getValueType() == DcRepository.ValueTypes._BIGINTEGER ||
            fld.getValueType() == DcRepository.ValueTypes._DOUBLE ||
            fld.getValueType() == DcRepository.ValueTypes._LONG) {
       
            Number n1 = (Number) o1;
            Number n2 = (Number) o2;
           
            return (int) (n1.longValue() - n2.longValue());

        } else if (fld.getValueType() == DcRepository.ValueTypes._DATE) {
            Date d1 = (Date) o1;
            Date d2 = (Date) o2;
       
            return d1.compareTo(d2);
View Full Code Here
326
327
328
329
330
331
332
333
334
335
336
       
        if (module.getChildIndex() > -1)
            setChild(module.getChildIndex());
       
        for (XmlField xmlField : module.getFields())
            addField(new DcField(xmlField, getIndex()));
       
        initializeFields();
        initializeMultiReferenceFields();
        initializeSettings();
        initializeProperties();
View Full Code Here
849
850
851
852
853
854
855
856
    /**
     * Retrieves the field definition for the given index.
     * @param index The field index.
     */
    public DcField getField(int index) {
        DcField field = fields.get(index);
        return field == null ? getSystemField(index) : field;
    }
View Full Code Here
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
     * Applies the field settings on this module.
     */
    public void applySettings() {
        try {
            for (DcFieldDefinition definition : getFieldDefinitions().getDefinitions()) {
               DcField field = getField(definition.getIndex());
   
               field.setRequired(definition.isRequired());
               field.setEnabled(definition.isEnabled());
           }
        } catch (Exception e) {
            logger.error("Error while applying settings on module " + getName(), e);
        }
    }   
View Full Code Here
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
        for (DcField field : getFields()) {
           
            if (field.getValueType() != DcRepository.ValueTypes._DCOBJECTCOLLECTION)
                continue;
           
            DcField fld = new DcField(
                    field.getIndex() + 100000000,
                    field.getModule(),
                    field.getSystemName() + "_persist",
                    false,
                    false,
View Full Code Here
TOP

Related Classes of net.datacrow.core.objects.DcField

  • net.datacrow.console.components.lists.elements.DcFilterEntryListElement
  • net.datacrow.console.components.panels.ChartPanel
  • net.datacrow.console.components.panels.ChartPanel$BarChartBuilder
  • net.datacrow.console.components.panels.ChartPanel$PieChartBuilder
  • net.datacrow.console.components.panels.FieldSelectionPanel
  • net.datacrow.console.components.panels.FieldSelectionPanel$ListMouseListener
  • net.datacrow.console.components.panels.tree.FieldTreePanel
  • net.datacrow.console.components.panels.tree.FieldTreePanel$TreeHugger
  • net.datacrow.console.menu.DcQuickFilterToolBar
  • net.datacrow.console.menu.ViewPopupMenu
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.