/**
* Deletes all show instances of current show after a
* certain date.
*
* @param string $p_date
* The date which to delete after, if null deletes from the current timestamp.
*/
public function removeAllInstancesFromDate($p_date = null)
{
global $CC_DBC;
$date = new DateHelper();
$timestamp = $date->getTimestamp();
if (is_null($p_date)) {
$date = new DateHelper();
$p_date = $date->getDate();
}
$showId = $this->getId();
$sql = "DELETE FROM cc_show_instances " . " WHERE date(starts) >= DATE '{$p_date}'" . " AND starts > TIMESTAMP '{$timestamp}'" . " AND show_id = {$showId}";
$CC_DBC->query($sql);
/*
CcShowInstancesQuery::create()
->filterByDbShowId($showId)
->filterByDbStartTime($p_date, Criteria::GREATER_EQUAL)
->delete();
*/
}
public static function getDateTime($ts)
{
return DateHelper::getDate($ts) . " " . DateHelper::getTime($ts);
}
