/**
* Fetches count of results in mm_seo table for given cluster identifier and (if provided) application identifier
* @param MMDB $db
* @param $clusterIdentifier
* @param string $applicationIdentifier
* @return int
*/
function fetchSeoResultsCount(MMDB $db, $clusterIdentifier, $applicationIdentifier = null)
{
$query = <<<SQL
SELECT COUNT(*) AS count FROM mm_seo WHERE cluster_identifier = '{$clusterIdentifier}'
SQL;
if (!empty($applicationIdentifier)) {
$query .= " AND application_identifier = '{$applicationIdentifier}';";
}
$result = $db->arrayQuery($query);
return intval($result[0]['count']);
}
function getFeedId($cli, MMDB $db, $clusterIdentifier, $typeId)
{
$sql = sprintf("SELECT na.feed_id
FROM mm_feed f
INNER JOIN mm_newsletter_application na on na.feed_id = f.id
INNER JOIN mm_newsletter_type nt on nt.id = f.newsletter_type_id
INNER JOIN mm_application_localized al on al.id = na.application_localized_id
WHERE al.cluster_identifier = '%s'
AND newsletter_type_id = %d",
$clusterIdentifier, $typeId);
$rows = $db->arrayQuery($sql);
if(!$rows)
{
$db->beginQuery();
$db->query(sprintf("INSERT INTO mm_feed (newsletter_type_id, cluster_identifier) VALUES (%d, '%s')", $typeId, $clusterIdentifier));
$feedId = $db->lastSerialID("mm_feed");
$db->commitQuery();
$cli->output( "New feed {$feedId}" );
return $feedId;
}
return $rows[0]["feed_id"];
}
