org.turro.publication.util.PublicationCategories Class Reference

Static Public Member Functions
static List< Publication >	getPublicationsBy (int max, long group, long category, String idContact, boolean accepted)
static List< Publication >	getPublicationsBy (int max, long group, long category, IContact contact, boolean accepted)
static List< Publication >	getPublicationsBy (int max, long group, long category, String idContact, boolean accepted, String extraSql)
static List< Publication >	getPublicationsBy (int max, long group, long category, IContact contact, boolean accepted, String extraSql)
static Collection< PublicationCategory >	getPublicCategories ()
static Collection< PublicationCategory >	getPublicCategories (String idContact)
static Collection< PublicationCategory >	getPublicCategories (IContact contact)
static Collection< PublicationCategory >	getSubscribedPrivateCategories (String idContact)
static Collection< PublicationCategory >	getSubscribedPrivateCategories (IContact contact)
static Collection< PublicationCategory >	getPrivateCategories ()
static Collection<? extends PublicationCategory >	getPrivateBloggerCategories (IContact contact)
static List< Publication >	getNotSentPublications (long categoryID)
static void	markAsSentPublications (long categoryID)
static List< PublicationCategory >	getPublicationCategories ()
static List< PublicationGroup >	getPublicationGroups ()

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 42 of file PublicationCategories.java.

Member Function Documentation

getNotSentPublications()

static List<Publication> org.turro.publication.util.PublicationCategories.getNotSentPublications ( long  categoryID )

static

Definition at line 186 of file PublicationCategories.java.

                                                                          {
    WhereClause wc = new WhereClause();
    wc.addClause("select publication from Publication publication");
    wc.addClause("where publication.sent = FALSE");
    wc.addClause("and publication.accepted = TRUE");
    wc.addClause("and (retainTill is null or retainTill <= :now)");
    wc.addNamedValue("now", new Date());
    if(categoryID != 0) {
      wc.addClause("and publication.publicationCategory.id = :category");
      wc.addNamedValue("category", categoryID);
    }
    wc.addClause("order by publication.date DESC");
    
    return new PublicationPU().getResultList(wc);
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getPrivateBloggerCategories()

static Collection<? extends PublicationCategory> org.turro.publication.util.PublicationCategories.getPrivateBloggerCategories ( IContact  contact )

static

Definition at line 173 of file PublicationCategories.java.

                                                                                                        {
    if(contact != null && contact.isWebUser()) {
      WhereClause wc = new WhereClause();
      wc.addClause("select b.publicationCategory from PublicationBlogger b");
      wc.addClause("where b.idContact = :idContact");
      wc.addNamedValue("idContact", contact.getId());
      wc.addClause("and b.publicationCategory.publishable = FALSE");
      return new PublicationPU().getResultList(wc);
    } else {
      return Collections.EMPTY_LIST;
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getPrivateCategories()

static Collection<PublicationCategory> org.turro.publication.util.PublicationCategories.getPrivateCategories ( )

static

Definition at line 166 of file PublicationCategories.java.

                                                                       {
    return SqlClause.select("c").from("PublicationCategory c")
            .where().isFalse("c.publishable")
            .dao(new PublicationPU())
            .resultList(PublicationCategory.class);
  }

Here is the caller graph for this function:

getPublicationCategories()

static List<PublicationCategory> org.turro.publication.util.PublicationCategories.getPublicationCategories ( )

static

Definition at line 217 of file PublicationCategories.java.

                                                                     {
    return new PublicationPU().getResultList(
            "select pc from PublicationCategory pc order by name");
  }

Here is the caller graph for this function:

getPublicationGroups()

static List<PublicationGroup> org.turro.publication.util.PublicationCategories.getPublicationGroups ( )

static

Definition at line 222 of file PublicationCategories.java.

                                                              {
    return new PublicationPU().getResultList(
            "select pg from PublicationGroup pg order by name");
  }

getPublicationsBy() [1/4]

static List<Publication> org.turro.publication.util.PublicationCategories.getPublicationsBy ( int  max, long  group, long  category, IContact  contact, boolean  accepted  )

static

Definition at line 49 of file PublicationCategories.java.

                                              {
    return getPublicationsBy(max, group, category, contact, accepted, null);
  }

Here is the call graph for this function:

getPublicationsBy() [2/4]

static List<Publication> org.turro.publication.util.PublicationCategories.getPublicationsBy ( int  max, long  group, long  category, IContact  contact, boolean  accepted, String  extraSql  )

static

Definition at line 59 of file PublicationCategories.java.

                                                               {
    return SqlClause.select("publication").from("Publication publication")
            .where().equal("accepted", accepted)
            .startIf(group != 0)
            .and().equal("publication.publicationGroup.id", group)
            .endIf()
            .startIf(category != 0)
            .and().equal("publication.publicationCategory.id", category)
            .endIf()
            .startIf(category == 0 || group == 0)
            .and().isTrue("publication.publicationGroup.publishable")
            .endIf()
            .startIf(contact != null && contact.isWebUser())
            .and().equal("publication.idContact", contact.getId())
            .endIf()
            .startIf(!Strings.isBlank(extraSql))
            .append(extraSql)
            .endIf()
            .orderBy("publication.date DESC")
            .dao(new PublicationPU())
            .max(max)
            .resultList(Publication.class)
            .stream()
            .filter(p -> {
              if(category == 0) {
                return p.getPublicationCategory().strongBond(ConstraintKeys.from(contact));
              } else {
                return true;
              }
            })
            .toList();            
//    WhereClause wc = new WhereClause();
//    wc.addClause("select publication from Publication publication");
//    wc.addClause("where publication.accepted = :accepted");
//    wc.addNamedValue("accepted", accepted);
//    if(group != 0) {
//      wc.addClause("and publication.publicationGroup.id = :group");
//      wc.addNamedValue("group", group);
//    } else {
//      wc.addClause("and publication.publicationGroup.publishable = TRUE");
//    }
//    if(category != 0) {
//      wc.addClause("and publication.publicationCategory.id = :category");
//      wc.addNamedValue("category", category);
//    } else {
//      wc.addClause("and publication.publicationCategory.publishable = TRUE");
//      if(contact != null && contact.isWebUser()) {
//        wc.addClause("and (");
//        wc.addClause("publication.publicationCategory.conditionedBy in :syndications");
//        wc.addNamedValue("syndications", contact.getSyndications());
//        wc.addClause("or (publication.publicationCategory.conditionedBy is null or trim(publication.publicationCategory.conditionedBy) = '')");
//        wc.addClause(")");
//      } else {
//        wc.addClause("and (publication.publicationCategory.conditionedBy is null or trim(publication.publicationCategory.conditionedBy) = '')");
//      }
//    }
//    if(contact != null && contact.isWebUser()) {
//      wc.addClause("and publication.idContact = :idContact");
//      wc.addNamedValue("idContact", contact.getId());
//    }
//    if(!Strings.isBlank(extraSql)) {
//      wc.addClause(extraSql);
//    }
//    wc.addClause("order by publication.date DESC");
//
//    return new PublicationPU().getResultList(wc, max);
  }

Here is the call graph for this function:

getPublicationsBy() [3/4]

static List<Publication> org.turro.publication.util.PublicationCategories.getPublicationsBy ( int  max, long  group, long  category, String  idContact, boolean  accepted  )

static

Definition at line 44 of file PublicationCategories.java.

                                              {
    return getPublicationsBy(max, group, category, idContact, accepted, null);
  }

Here is the caller graph for this function:

getPublicationsBy() [4/4]

static List<Publication> org.turro.publication.util.PublicationCategories.getPublicationsBy ( int  max, long  group, long  category, String  idContact, boolean  accepted, String  extraSql  )

static

Definition at line 54 of file PublicationCategories.java.

                                                               {
    return getPublicationsBy(max, group, category, Contacts.getContactById(idContact), accepted, extraSql);
  }

Here is the call graph for this function:

getPublicCategories() [1/3]

static Collection<PublicationCategory> org.turro.publication.util.PublicationCategories.getPublicCategories ( )

static

Definition at line 128 of file PublicationCategories.java.

                                                                      {
    return getPublicCategories((IContact) null);
  }

Here is the caller graph for this function:

getPublicCategories() [2/3]

static Collection<PublicationCategory> org.turro.publication.util.PublicationCategories.getPublicCategories ( IContact  contact )

static

Definition at line 136 of file PublicationCategories.java.

                                                                                      {
    return SqlClause.select("c").from("PublicationCategory c")
            .where().isTrue("c.publishable")
            .dao(new PublicationPU())
            .resultList(PublicationCategory.class)
            .stream()
            .filter(pc -> {
              if(contact != null && contact.isWebUser()) {
                return pc.strongBond(ConstraintKeys.from(contact));
              }
              return !pc.isRestricted();
            })
            .toList();
  }

Here is the call graph for this function:

getPublicCategories() [3/3]

static Collection<PublicationCategory> org.turro.publication.util.PublicationCategories.getPublicCategories ( String  idContact )

static

Definition at line 132 of file PublicationCategories.java.

                                                                                      {
    return getPublicCategories(Contacts.getContactById(idContact));
  }

Here is the call graph for this function:

getSubscribedPrivateCategories() [1/2]

static Collection<PublicationCategory> org.turro.publication.util.PublicationCategories.getSubscribedPrivateCategories ( IContact  contact )

static

Definition at line 155 of file PublicationCategories.java.

                                                                                                 {
    ArrayList<PublicationCategory> list = new ArrayList<>();
    for(PublicationCategory category : getPrivateCategories()) {
      QueueManager qm = new QueueManager();
      if(qm.contactWants(contact, PublicationElephantNotification.convertId(category))) {
        list.add(category);
      }
    }
    return list;
  }

Here is the call graph for this function:

getSubscribedPrivateCategories() [2/2]

static Collection<PublicationCategory> org.turro.publication.util.PublicationCategories.getSubscribedPrivateCategories ( String  idContact )

static

Definition at line 151 of file PublicationCategories.java.

                                                                                                 {
    return getSubscribedPrivateCategories(Contacts.getContactById(idContact));
  }

Here is the call graph for this function:

markAsSentPublications()

static void org.turro.publication.util.PublicationCategories.markAsSentPublications ( long  categoryID )

static

Definition at line 202 of file PublicationCategories.java.

                                                             {
    WhereClause wc = new WhereClause();
    wc.addClause("update Publication publication");
    wc.addClause("set publication.sent = TRUE");
    wc.addClause("where publication.accepted = TRUE");
    wc.addClause("and (publication.retainTill is null or publication.retainTill <= :now)");
    wc.addNamedValue("now", new Date());
    if(categoryID != 0) {
      wc.addClause("and publication.publicationCategory.id = :category");
      wc.addNamedValue("category", categoryID);
    }
    
    new PublicationPU().executeUpdate(wc);
  }

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• PublicationCategories.java