×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
publish_down field
Rob
Nouveau membre
Posts: 3
il y a 10 ans 6 mois #44
par Rob
publish_down field a été créé par Rob
Perhaps I have missed it, is there currently a Field Type similar to the "Finish Publishing" on basic Joomla articles?
Connexion ou Créer un compte pour participer à la conversation.
Gordon
Membre junior
Posts: 23
il y a 10 ans 6 mois - il y a 10 ans 6 mois #47
par Gordon
Never doubt that a small group of committed people can change the world. Indeed, it is the only thing that ever has... Margaret Mead
Gordon Wright
Old fart developer
Réponse de Gordon sur le sujet publish_down field
Just a normal calendar field but you have to code it into your component. Best way is to modify the SQL that delivers the content with a WHERE/AND statement so the result is less than the finishing date.
Joomla Articles (in the front end do it via the content model...
if ((!$user->authorise('core.edit.state', 'com_content')) && (!$user->authorise('core.edit', 'com_content'))) {
// Filter by start and end dates.
$nullDate = $db->quote($db->getNullDate());
$date = JFactory::getDate();
$nowDate = $db->quote($date->toSql());
$query->where('(a.publish_up = ' . $nullDate . ' OR a.publish_up <= ' . $nowDate . ')')
->where('(a.publish_down = ' . $nullDate . ' OR a.publish_down >= ' . $nowDate . ')');
}Never doubt that a small group of committed people can change the world. Indeed, it is the only thing that ever has... Margaret Mead
Gordon Wright
Old fart developer
Dernière édition: il y a 10 ans 6 mois par Gordon.
Les utilisateur(s) suivant ont remercié: Søren Beck Jensen, Andres Maeso, RIP Graphics
Connexion ou Créer un compte pour participer à la conversation.
Rob
Nouveau membre
Posts: 3
il y a 10 ans 6 mois #48
par Rob
Réponse de Rob sur le sujet publish_down field
Thanks. I'll give it a whirl.
Connexion ou Créer un compte pour participer à la conversation.
Temps de génération de la page : 0.074 secondes