public function getUrlId($requestUri, $referer)
{
$select = new Select();
$select->from('log_url_info')->where->equalTo('url', $requestUri);
if (is_null($referer)) {
$select->where->isNull('referer');
} else {
$select->where->equalTo('referer', $referer);
}
$urlInfo = $this->fetchRow($select);
if (!empty($urlInfo['id'])) {
$urlId = $urlInfo['id'];
} else {
$insert = new Insert();
$insert->into('log_url_info')->values(array('url' => $requestUri, 'referer' => $referer));
$this->execute($insert);
$urlId = $this->getLastInsertId('log_url_info');
}
return $urlId;
}