private function saveRightForIdRole($idRole, $listRight)
{
$sql = "DELETE FROM role_right WHERE id_role = :idRole";
$params[':idRole'] = $idRole;
$result = $this->daoTemplate->queryForUpdate($sql, $params);
foreach ($listRight as $right) {
$sql = "INSERT INTO role_right SET id_role = ?, code_right = ?";
$params = array();
$params[] = $idRole;
$params[] = $right;
$result = $this->daoTemplate->queryForUpdate($sql, $params);
}
}
public function save(UserDto $user)
{
if ($user->id > 0) {
$sql[] = "UPDATE user";
} else {
$sql[] = "INSERT INTO user";
}
$sql[] = " SET name = :name,";
$sql[] = " login = :login,";
$sql[] = " password = :password,";
$sql[] = " email = :email";
if ($user->id == 0) {
$sql[] = " , date_creation = :date_creation";
$params[':date_creation'] = time();
} else {
$sql[] = "WHERE id=:id";
$params[':id'] = $user->id;
}
$params[':name'] = $user->userName;
$params[':login'] = $user->login;
$params[':password'] = $user->password;
$params[':email'] = $user->email;
$result = $this->daoTemplate->queryForUpdate(implode("\n", $sql), $params);
if ($user->id == 0) {
$user->id = $this->daoTemplate->getLastInsertId();
}
return $result;
}
public function save($cat)
{
if ($cat->id > 0) {
$sql[] = "UPDATE category";
} else {
$sql[] = "INSERT INTO category";
}
$sql[] = " SET title = :title,";
$sql[] = " description = :description";
if ($cat->id > 0) {
$sql[] = "WHERE id=:id";
$params[':id'] = $cat->id;
}
$params[':title'] = $cat->title;
$params[':description'] = $cat->description;
$result = $this->daoTemplate->queryForUpdate(implode("\n", $sql), $params);
if ($cat->id == 0) {
$cat->id = $this->daoTemplate->getLastInsertId();
}
return $result;
}
