/**
* @param ModuleMresource_EntityMresource $oMresource
*
* @return int|bool
*/
public function Add($oMresource)
{
$aParams = array(':date_add' => F::Now(), ':user_id' => $oMresource->GetUserId(), ':link' => $oMresource->IsLink() ? 1 : 0, ':type' => $oMresource->GetType(), ':path_url' => $oMresource->GetPathUrl(), ':path_file' => $oMresource->GetPathFile(), ':hash_url' => $oMresource->GetHashUrl(), ':hash_file' => $oMresource->GetHashFile(), ':storage' => $oMresource->GetStorage(), ':uuid' => $oMresource->GetUuid());
$sql = "\n SELECT mresource_id\n FROM ?_mresource\n WHERE\n storage = ?:storage AND uuid = ?:uuid\n LIMIT 1\n ";
$nId = $this->oDb->sqlSelectCell($sql, $aParams);
if (!$nId) {
$sql = "\n INSERT INTO ?_mresource\n (\n date_add,\n user_id,\n link,\n type,\n path_url,\n path_file,\n hash_url,\n hash_file,\n storage,\n uuid\n )\n VALUES (\n ?:date_add,\n ?d:user_id,\n ?d:link,\n ?d:type,\n ?:path_url,\n ?:path_file,\n ?:hash_url,\n ?:hash_file,\n ?:storage,\n ?:uuid\n )\n ";
$nId = $this->oDb->sqlQuery($sql, $aParams);
}
return $nId ? $nId : false;
}
