public function SetReadChat($id)
{
$id_user = Session::GetSession("login", "id");
$query = "SELECT id_submensajeria as 'id_sub' FROM lieisoft_submensajeria \n WHERE lieisoft_submensajeria.id_usuario \n NOT LIKE '{$id_user}' \n AND id_mensajeria LIKE {$id}\n AND lieisoft_submensajeria.leido LIKE 0\n ORDER BY fecha DESC , hora ASC";
$result = parent::RawQuery($query);
foreach ($result as $value) {
$id_sub = $value['id_sub'];
$query = "UPDATE lieisoft_submensajeria" . " SET lieisoft_submensajeria.leido = 1" . " WHERE id_submensajeria LIKE {$id_sub} ";
parent::beginTransaction();
parent::exec($query);
parent::commit();
}
}
