001/* 002 * Copyright 2020 Anyware Services 003 * 004 * Licensed under the Apache License, Version 2.0 (the "License"); 005 * you may not use this file except in compliance with the License. 006 * You may obtain a copy of the License at 007 * 008 * http://www.apache.org/licenses/LICENSE-2.0 009 * 010 * Unless required by applicable law or agreed to in writing, software 011 * distributed under the License is distributed on an "AS IS" BASIS, 012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 013 * See the License for the specific language governing permissions and 014 * limitations under the License. 015 */ 016package org.ametys.odf.ose.export.impl.odf.db; 017 018import java.sql.Types; 019import java.util.ArrayList; 020import java.util.HashSet; 021import java.util.List; 022import java.util.Optional; 023import java.util.Set; 024 025import org.apache.commons.lang3.tuple.Pair; 026 027import org.ametys.odf.coursepart.CoursePart; 028import org.ametys.odf.ose.db.ParameterizableQuery; 029import org.ametys.odf.ose.db.column.Column; 030import org.ametys.odf.ose.db.column.DefaultColumn; 031import org.ametys.odf.ose.db.column.ForeignKeyColumn; 032import org.ametys.odf.ose.db.column.SourceIdColumn; 033import org.ametys.odf.ose.db.parameter.QueryParameter; 034import org.ametys.odf.ose.db.parameter.ValuedQueryParameter; 035import org.ametys.odf.ose.export.ExportUtils; 036import org.ametys.runtime.model.ModelHelper; 037 038/** 039 * Helper to build queries to manage the VOLUME_HORAIRE_ENS table. 040 */ 041public final class VolumeHoraireEnsHelper 042{ 043 private static final String __TABLE_NAME = "VOLUME_HORAIRE_ENS"; 044 045 private VolumeHoraireEnsHelper() 046 { 047 // Helper 048 } 049 050 /** 051 * Queries to create the table and associated view. 052 * @return List of queries for table and view creation 053 */ 054 public static List<ParameterizableQuery> initialize() 055 { 056 Set<Column> columns = new HashSet<>(); 057 columns.add(new DefaultColumn("ID", "VARCHAR2(100 CHAR)", false, "SOURCE_CODE")); 058 columns.add(new DefaultColumn("HEURES", "FLOAT", false)); 059 columns.add(new ForeignKeyColumn("ELEMENT_PEDAGOGIQUE_ID", "VARCHAR2(100 CHAR)", false, Pair.of("ELEMENT_PEDAGOGIQUE", "SOURCE_CODE"), true)); 060 columns.add(new ForeignKeyColumn("TYPE_INTERVENTION_ID", "VARCHAR2(10 CHAR)", false, Pair.of("TYPE_INTERVENTION", "CODE"), false)); 061 columns.add(new DefaultColumn("GROUPES", "FLOAT", true)); 062 columns.add(new DefaultColumn("ANNEE_ID", "NUMBER(38, 0)", false)); 063 columns.add(new SourceIdColumn()); 064 return ExportUtils.initializeTableAndView(__TABLE_NAME, columns); 065 } 066 067 /** 068 * Query to delete all lines from the table. 069 * @return The query for deletion 070 */ 071 public static ParameterizableQuery deleteFrom() 072 { 073 return ExportUtils.deleteFromAmetys(__TABLE_NAME); 074 } 075 076 /** 077 * Query to insert a line in the table. 078 * @param coursePart The course part 079 * @param coursePartCode The course part code 080 * @param coursePartNature The course part nature 081 * @param oseCatalog The OSE catalog 082 * @param courseLink the course link 083 * @return The query to insert values in the table 084 */ 085 public static ParameterizableQuery insertInto(CoursePart coursePart, String coursePartCode, String coursePartNature, Long oseCatalog, String courseLink) 086 { 087 List<QueryParameter> parameters = new ArrayList<>(); 088 parameters.add(new ValuedQueryParameter("ID", coursePartCode, Types.VARCHAR)); 089 parameters.add(new ValuedQueryParameter("HEURES", coursePart.getNumberOfHours(), Types.FLOAT)); 090 parameters.add(new ValuedQueryParameter("ELEMENT_PEDAGOGIQUE_ID", courseLink, Types.VARCHAR)); 091 parameters.add(new ValuedQueryParameter("TYPE_INTERVENTION_ID", coursePartNature, Types.VARCHAR)); 092 parameters.add(new ValuedQueryParameter("GROUPES", _getGroups(coursePart), Types.FLOAT)); 093 parameters.add(new ValuedQueryParameter("ANNEE_ID", oseCatalog, Types.NUMERIC)); 094 return ExportUtils.insertIntoAmetys(__TABLE_NAME, parameters); 095 } 096 097 private static Double _getGroups(CoursePart coursePart) 098 { 099 Long groups = null; 100 if (ModelHelper.hasModelItem("calculatedGroups", coursePart.getModel())) 101 { 102 groups = coursePart.getValue("calculatedGroups"); 103 if (groups == null) 104 { 105 groups = coursePart.getValue("groupsToOpen"); 106 } 107 } 108 return Optional.ofNullable(groups) 109 .map(Long::doubleValue) 110 .orElse(null); 111 } 112}