bool EpgSearchFilter::FilterEntry(const CEpgInfoTag &tag) const
{
if (m_iGenreType != -1)
{
if (tag.GenreType() != m_iGenreType &&
(!m_bIncludeUnknownGenres &&
((tag.GenreType() < EVCONTENTMASK_USERDEFINED || tag.GenreType() >= EVCONTENTMASK_MOVIEDRAMA))))
{
return false;
}
}
if (m_iMinimumDuration != -1)
{
if (tag.GetDuration() < (m_iMinimumDuration*60))
return false;
}
if (m_iMaximumDuration != -1)
{
if (tag.GetDuration() > (m_iMaximumDuration*60))
return false;
}
int timeTag = (tag.Start().GetHour()*60 + tag.Start().GetMinute());
if (timeTag < (m_startTime.wHour*60 + m_startTime.wMinute))
return false;
if (timeTag > (m_endTime.wHour*60 + m_endTime.wMinute))
return false;
if (tag.Start() < m_startDate)
return false;
if (tag.Start() > m_endDate)
return false;
if (m_strSearchTerm != "")
{
cTextSearch search(tag.Title(), m_strSearchTerm, m_bIsCaseSensitive);
if (!search.DoSearch())
{
if (m_bSearchInDescription)
{
search.SetText(tag.PlotOutline(), m_strSearchTerm, m_bIsCaseSensitive);
if (!search.DoSearch())
{
search.SetText(tag.Plot(), m_strSearchTerm, m_bIsCaseSensitive);
if (!search.DoSearch())
return false;
}
}
else
return false;
}
}
return true;
}
bool CEpg::FixOverlappingEvents(bool bStore /* = true */)
{
bool bReturn = false;
CEpgDatabase *database = NULL;
if (bStore)
{
database = g_EpgContainer.GetDatabase();
if (!database || !database->Open())
{
CLog::Log(LOGERROR, "EPG - %s - could not open the database", __FUNCTION__);
return bReturn;
}
}
bReturn = true;
CEpgInfoTag *previousTag = NULL;
CSingleLock lock(m_critSection);
for (unsigned int ptr = 0; ptr < size(); ptr++)
{
/* skip the first entry or if previousTag is NULL */
if (previousTag == NULL)
{
previousTag = at(ptr);
continue;
}
CEpgInfoTag *currentTag = at(ptr);
/* the previous tag ends after the current tag starts.
* the start time of the current tag is leading, so change the time of the previous tag
*/
if (previousTag->End() > currentTag->Start())
{
CLog::Log(LOGDEBUG, "EPG - %s - event '%s' ends after event '%s' starts. changing the end time of '%s' to the start time of '%s': '%s'",
__FUNCTION__, previousTag->Title().c_str(), currentTag->Title().c_str(),
previousTag->Title().c_str(), currentTag->Title().c_str(),
currentTag->Start().GetAsLocalizedDateTime(false, false).c_str());
previousTag->SetEnd(currentTag->Start());
if (bStore)
bReturn = previousTag->Persist(false, false) && bReturn;
}
previousTag = at(ptr);
}
return bReturn;
}
bool CEpg::UpdateEntry(const CEpgInfoTag &tag, bool bUpdateDatabase /* = false */)
{
bool bReturn = false;
/* XXX tags aren't always fetched correctly here */
CEpgInfoTag *InfoTag = (CEpgInfoTag *) this->InfoTag(tag.UniqueBroadcastID(), tag.Start());
/* create a new tag if no tag with this ID exists */
if (!InfoTag)
{
CSingleLock lock(m_critSection);
InfoTag = CreateTag();
InfoTag->SetUniqueBroadcastID(tag.UniqueBroadcastID());
push_back(InfoTag);
}
InfoTag->m_Epg = this;
InfoTag->Update(tag);
Sort();
if (bUpdateDatabase)
bReturn = InfoTag->Persist();
else
bReturn = true;
return bReturn;
}
const CEpgInfoTag *CEpg::InfoTag(int uniqueID, const CDateTime &StartTime) const
{
CEpgInfoTag *returnTag = NULL;
CSingleLock locka(m_critSection);
/* try to find the tag by UID */
if (uniqueID > 0)
{
for (unsigned int iEpgPtr = 0; iEpgPtr < size(); iEpgPtr++)
{
CEpgInfoTag *tag = at(iEpgPtr);
if (tag->UniqueBroadcastID() == uniqueID)
{
returnTag = tag;
break;
}
}
}
/* if we haven't found it, search by start time */
if (!returnTag)
{
for (unsigned int iEpgPtr = 0; iEpgPtr < size(); iEpgPtr++)
{
CEpgInfoTag *tag = at(iEpgPtr);
if (tag->Start() == StartTime)
{
returnTag = tag;
break;
}
}
}
return returnTag;
}
const CEpgInfoTag *CEpg::InfoTagAround(CDateTime Time) const
{
CEpgInfoTag *returnTag = NULL;
CSingleLock lock(m_critSection);
for (unsigned int iTagPtr = 0; iTagPtr < size(); iTagPtr++)
{
CEpgInfoTag *tag = at(iTagPtr);
if ((tag->Start() <= Time) && (tag->End() >= Time))
{
returnTag = tag;
break;
}
}
return returnTag;
}
const CEpgInfoTag *CEpg::InfoTagBetween(CDateTime BeginTime, CDateTime EndTime) const
{
CEpgInfoTag *returnTag = NULL;
CSingleLock lock(m_critSection);
for (unsigned int iTagPtr = 0; iTagPtr < size(); iTagPtr++)
{
CEpgInfoTag *tag = at(iTagPtr);
if (tag->Start() >= BeginTime && tag->End() <= EndTime)
{
returnTag = tag;
break;
}
}
return returnTag;
}
const CEpgInfoTag *CEpg::InfoTagNow(void) const
{
CSingleLock lock(m_critSection);
if (!m_nowActive || !m_nowActive->IsActive())
{
CDateTime now = CDateTime::GetCurrentDateTime();
/* one of the first items will always match if the list is sorted */
for (unsigned int iTagPtr = 0; iTagPtr < size(); iTagPtr++)
{
CEpgInfoTag *tag = at(iTagPtr);
if (tag->Start() <= now && tag->End() > now)
{
m_nowActive = tag;
break;
}
}
}
return m_nowActive;
}
int CEpgDatabase::Persist(const CEpgInfoTag &tag, bool bSingleUpdate /* = true */, bool bLastUpdate /* = false */)
{
int iReturn = -1;
const CEpg *epg = tag.GetTable();
if (!epg || epg->EpgID() <= 0)
{
CLog::Log(LOGERROR, "%s - tag '%s' does not have a valid table", __FUNCTION__, tag.Title().c_str());
return iReturn;
}
time_t iStartTime, iEndTime, iFirstAired;
tag.Start().GetAsTime(iStartTime);
tag.End().GetAsTime(iEndTime);
tag.FirstAired().GetAsTime(iFirstAired);
int iEpgId = epg->EpgID();
int iBroadcastId = tag.BroadcastId();
if (iBroadcastId <= 0)
{
CStdString strWhereClause;
if (tag.UniqueBroadcastID() > 0)
{
strWhereClause = FormatSQL("(iBroadcastUid = '%u' OR iStartTime = %u) AND idEpg = %u",
tag.UniqueBroadcastID(), iStartTime, iEpgId);
}
else
{
strWhereClause = FormatSQL("iStartTime = %u AND idEpg = '%u'",
iStartTime, iEpgId);
}
CStdString strValue = GetSingleValue("epgtags", "idBroadcast", strWhereClause);
if (!strValue.IsEmpty())
iBroadcastId = atoi(strValue);
}
CStdString strQuery;
if (iBroadcastId < 0)
{
strQuery = FormatSQL("INSERT INTO epgtags (idEpg, iStartTime, "
"iEndTime, sTitle, sPlotOutline, sPlot, iGenreType, iGenreSubType, "
"iFirstAired, iParentalRating, iStarRating, bNotify, iSeriesId, "
"iEpisodeId, iEpisodePart, sEpisodeName, iBroadcastUid) "
"VALUES (%u, %u, %u, '%s', '%s', '%s', %i, %i, %u, %i, %i, %i, %i, %i, %i, '%s', %i);",
iEpgId, iStartTime, iEndTime,
tag.Title().c_str(), tag.PlotOutline().c_str(), tag.Plot().c_str(), tag.GenreType(), tag.GenreSubType(),
iFirstAired, tag.ParentalRating(), tag.StarRating(), tag.Notify(),
tag.SeriesNum(), tag.EpisodeNum(), tag.EpisodePart(), tag.EpisodeName().c_str(),
tag.UniqueBroadcastID());
}
else
{
strQuery = FormatSQL("REPLACE INTO epgtags (idEpg, iStartTime, "
"iEndTime, sTitle, sPlotOutline, sPlot, iGenreType, iGenreSubType, "
"iFirstAired, iParentalRating, iStarRating, bNotify, iSeriesId, "
"iEpisodeId, iEpisodePart, sEpisodeName, iBroadcastUid, idBroadcast) "
"VALUES (%u, %u, %u, '%s', '%s', '%s', %i, %i, %u, %i, %i, %i, %i, %i, %i, '%s', %i, %i);",
iEpgId, iStartTime, iEndTime,
tag.Title().c_str(), tag.PlotOutline().c_str(), tag.Plot().c_str(), tag.GenreType(), tag.GenreSubType(),
tag.FirstAired().GetAsDBDateTime().c_str(), tag.ParentalRating(), tag.StarRating(), tag.Notify(),
tag.SeriesNum(), tag.EpisodeNum(), tag.EpisodePart(), tag.EpisodeName().c_str(),
tag.UniqueBroadcastID(), iBroadcastId);
}
if (bSingleUpdate)
{
if (ExecuteQuery(strQuery))
iReturn = m_pDS->lastinsertid();
}
else
{
QueueInsertQuery(strQuery);
if (bLastUpdate)
CommitInsertQueries();
iReturn = 0;
}
return iReturn;
}
