public function fetchAll()
{
$this->buildStart();
$this->build();
$this->buildStat();
$results = array();
while ($data = $this->stat->fetch()) {
$importURL = new ImportURLModel();
$importURL->setFromDataBaseRow($data);
$results[] = $importURL;
}
return $results;
}
public function loadClashForImportUrl(ImportURLModel $importURL)
{
global $DB;
$sql = "SELECT import_url_information.* FROM import_url_information WHERE " . "is_enabled='1' AND expired_at IS NULL AND site_id=:site_id AND url_canonical=:url_canonical ";
$params = array('site_id' => $importURL->getSiteId(), 'url_canonical' => $importURL->getUrlCanonical());
if ($importURL->getId()) {
$sql .= " AND id != :id";
$params['id'] = $importURL->getId();
}
$stat = $DB->prepare($sql);
$stat->execute($params);
if ($stat->rowCount() > 0) {
$iurl = new ImportURLModel();
$iurl->setFromDataBaseRow($stat->fetch());
return $iurl;
}
}
