/**
* get nb comment for an id and a type
* @param string $id identifiant
* @param string $type
*/
function getNbComment($id, $type)
{
$query = 'select count(id_cmt) as nbComment from "comment" where id_cmt=\'' . $id . '\' and type_cmt=\'' . $type . '\'';
$dbWidget =& CopixDBFactory::getDbWidget();
$count = $dbWidget->fetchFirst($query);
$toReturn = $count->nbComment;
return $toReturn;
}
function findAll()
{
$dbWidget =& CopixDBFactory::getDbWidget();
return $dbWidget->fetchAllUsing($this->_selectQuery, 'CompiledDAORecordContract');
}
/**
* Updates the users informations
* @param string $login the login
* @param array $informations the informations to update
* @return boolean
*/
function updateInformations($login, $informations)
{
$ct =& CopixDBFactory::getConnection();
//Creating hash table to get field names from properties
foreach ($this->fieldPropList as $key => $value) {
$hashProperties[$value] = $key;
}
$toUpdate = array();
foreach ($informations as $name => $value) {
if (isset($hashProperties[$name])) {
$toUpdate[$hashProperties[$name]] = $ct->quote($value);
}
}
if (count($toUpdate)) {
$dbw = CopixDBFactory::getDbWidget();
return $dbw->doUpdate($this->userTable, $toUpdate, $condition);
}
return false;
}
/**
* Creates a user.
*/
function createUser($informations)
{
$ct =& CopixDBFactory::getConnection();
//Creating hash table to get field names from properties
foreach ($this->fieldPropList as $key => $value) {
$hashProperties[$value] = $key;
}
$toInsert = array();
foreach (get_object_vars($informations) as $name => $value) {
if (isset($hashProperties[$name])) {
$toInsert[$hashProperties[$name]] = $ct->quote($value);
}
}
$toInsert[$this->passwordField] = $ct->quote($this->cryptPassword($informations->password));
if (count($toInsert)) {
$dbw = CopixDBFactory::getDbWidget();
return $dbw->doInsert($this->userTable, $toInsert);
}
return false;
}
