Subversion Repositories bacoAlunos

package pt.estgp.estgweb.services.sigesimports;

import jomm.dao.impl.AbstractDao;
import org.hibernate.Query;
import pt.estgp.estgweb.domain.CourseUnit;
import pt.estgp.estgweb.domain.dao.DaoFactory;

import java.util.Iterator;

/**
 * Created by jorgemachado on 01/12/15.
 */
public class CleanCourseUnitsZeroStudents
{
    public static void main(1.5.0/docs/api/java/lang/String.html">String[] args)
    {
        AbstractDao.getCurrentSession().beginTransaction();


        1.5.0/docs/api/javax/management/Query.html">Query q = AbstractDao.getCurrentSession().createQuery("select c.id from c in class " + CourseUnit.class.getName() +
        " where size(c.students) = 0 and (c.importYear = '201415' or c.importYear='201516') order by c.importYear, c.semestre, c.code");
        1.5.0/docs/api/java/util/Iterator.html">Iterator iter = q.iterate();
        1.5.0/docs/api/java/lang/System.html">System.out.println("ANO;SEMESTRE;CODIGO;NOME;CODIGOCURSO;NOMECURSO");
        while(iter.hasNext())
        {

            1.5.0/docs/api/java/lang/Long.html">Long id = (1.5.0/docs/api/java/lang/Long.html">Long) iter.next();
            CourseUnit cu = DaoFactory.getCourseUnitDaoImpl().load(id);
            1.5.0/docs/api/java/lang/System.html">System.out.println(cu.getImportYear() + ";" + cu.getSemestre() + ";" + cu.getCode() + ";" + cu.getName() + ";" + cu.getCourseCode() + ";"  +cu.getCourseName());
            boolean alert = false;
            if(cu.getAnnouncements() != null && cu.getAnnouncements().size() > 0)
            {
                1.5.0/docs/api/java/lang/System.html">System.out.println("ALERT - Tem Announcements");
            }
            if(cu.getAssignements() != null && cu.getAssignements().size() > 0)
            {
                1.5.0/docs/api/java/lang/System.html">System.out.println("ALERT - Tem Assignements");
            }
            if(cu.getBlogs() != null && cu.getBlogs().size() > 0)
            {
                1.5.0/docs/api/java/lang/System.html">System.out.println("ALERT - Tem BLOGS");
            }
            if(cu.getCourseUnitEvaluation() != null)
            {
                1.5.0/docs/api/java/lang/System.html">System.out.println("ALERT - Tem Evaluation");
                alert = true;
            }
            if(cu.getCourseUnitProgram() != null)
            {
                1.5.0/docs/api/java/lang/System.html">System.out.println("ALERT - Tem program");
                alert = true;
            }
            if(cu.getSummaries() != null && cu.getSummaries().size() > 0)
            {
                1.5.0/docs/api/java/lang/System.html">System.out.println("ALERT - Tem SUMMARIES");
            }
            if(alert)
            {
                1.5.0/docs/api/java/lang/System.html">System.out.println(">>>>>>>>>>>>>>NAO APAGA");
            }
            else
            {
                1.5.0/docs/api/java/lang/System.html">System.out.println("+++++++++++++++CANDIDATA A APAGAR");
            }

        }



        AbstractDao.getCurrentSession().getTransaction().commit();
    }
}