Index: openacs-4/packages/cards/cards.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cards/cards.info,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cards/cards.info 10 Jun 2005 08:26:55 -0000 1.1
+++ openacs-4/packages/cards/cards.info 22 Jun 2006 10:49:20 -0000 1.2
@@ -8,17 +8,23 @@
f
cards
-
+
Francisco Soler
-
+ 2006-06-22
+ 0
+
-
-
-
-
-
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/cards/catalog/cards.ca_ES.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cards/catalog/cards.ca_ES.ISO-8859-1.xml,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cards/catalog/cards.ca_ES.ISO-8859-1.xml 10 Jun 2005 08:26:55 -0000 1.1
+++ openacs-4/packages/cards/catalog/cards.ca_ES.ISO-8859-1.xml 22 Jun 2006 10:49:22 -0000 1.2
@@ -1,63 +1,131 @@
- Fitxes
+ Adre�a
+ Avaluar Alumnes
+ Mitja
+ Per afegir tasques primer necessites crear blocs d'avaluaci�
Accepta
- Alumne
- Alumnes
- Anotaci�
- Anotacions
- Aprovat
+ Acci�
+ Activa
+ Afegir anotaci�
+ Adre�a
+ Permetre als alumnes l'acc�s a les seues notes
+ Nota mitjana
+ Torna
+ B�sica
Bloc
- Elimina
+ Nom de bloc
Cancel�la
Comentari
- Comentaris de l'estudiant al professor
- Comentaris del professor a l'estudiant
- Configura avaluaci�
+ Tipus de dades
+ Data
+ L\'eliminaci� del bloc
+ implica el esborrat de totes les seues anotaciones i la p�rdua de les notes dels alumnes. �Est� segur?
+ L\'eliminaci� de l\'anotaci�
+ implica la p�rdua d\'eixa nota dels alumnes. �Est� segur?
+ Elimina
Correu electr�nic
- Dades personals
- Adre�a
Edita
- Data
- Fitxes d'estudiants
- Gestiona anotacions
- Llista d'anotacions
Llista blocs d'avaluaci�
+ Nota final
+ Nota
+ Notes
Llista de notes
+ Dades no v�lides. Revisa els camps marcats.
+ Valor incorrecte a
+ . Sols valors sensers entre 0 i
+ Comentaris del professor a l'estudiant
+ Gestiona tasques
+ Anotacions no disponinles
No presentats
+ Suspensos
+ Anotaci�
+ Llista d'anotacions
Nom anotaci�
- Nom de bloc
- Nota
- Nota final
- Nota mitjana
- Notes
+ Anotacions
+ Orla
+ Aprovat
+ Dades personals
+ Tel�fon
+ Reutilitzar fitxes i notes del curs pare
+ Selecionable
+ Configura avaluaci�
Opcions de configuraci�
+ Alumne
+ Comentaris de l'estudiant al professor
+ Fitxes d'estudiants
+ Alumnes
+ ASSIGNATURA
+ Tasca
+ Bloc
+ Nota M�xima
+ Nom de la Prova
+ Tipus d'anotacions
+ Llista de proves / tasques
+ Text
+ Total assignat
P�gina web
- Permet acc�s als alumnes
Sense validesa acad�mica
- Suspensos
- Tel�fon
- Tipus de dades
- Total assignat
- Torna
- Orla
- Valor incorrecte a
- . Sols valors sensers entre 0 i
- Dades no v�lides. Revisa els camps marcats.
- ASSIGNATURA
- Text
- B�sica
- Selecionable
- Afegir anotaci�
- Activa
- Anotacions no disponinles
- L\'eliminaci� del bloc
- implica el esborrat de totes les seues anotaciones i la p�rdua de les notes dels alumnes. �Est� segur?
- L\'eliminaci� de l\'anotaci�
- implica la p�rdua d\'eixa nota dels alumnes. �Est� segur?
-
-
+ Canvia Foto
+ Comentaris privats
+ Comunicaci�
+ Correu electr�nic
+ Aquesta utilitat permet importar les notes des d'una tasca del m�dul Activitats cap a una tasca del m�dul Fitxes d'estudiants. Per tant les dues tasques han d'estar creades i la del m�dul Activitats ha de estar avaluada. Cal tindre en compte que no es guarda cap relaci� entre les tasques i si canvien les notes al m�dul Activitats hauriem de tornar a importar les notes per reflectir el canvis a les Fitxes
+ DES DE ACTIVITATS
+ Generar arxiu CSV
+ AV�S: La nota final mostrada es correspon amb la nota acumulada fins el moment, no t� perqu� ser la nota definitiva
+ P�gina web
+ Importar Notes
+ IMPORTAR NOTES
+ Les notes de la tasca de Fitxes seleccionada seran actualitzades amb les notes de la tasca d\'Activitats seleccionada. Est� segur?
+ IMPORTAR NOTES DES DE ACTIVITATS A FITXES
+ Llistat de notas per imprimir
+ M�xim
+ car�cters. Queden:
+ No
+ Foto no disponible
+ Cap actualitzaci� realitzada. La tasca seleccionada encara no t� notes.
+ No n'hi han tasques en Activitats o en Fitxes. Per poder importar les notes ha d'estar creada la tasca en Activitats i en Fitxes
+ Percentatge
+ Tel�fons
+ Fitxes
+ Versi� per imprimir
+ Comentaris Privats: l'estudiant mai podr� vore aquests comentaris
+ Restricci� major o igual que
+ Selecciona una tasca del m�dul Fitxes
+ Selecciona una tasca del m�dul Activitats
+ ENVIAR AVALUACI�
+ Comentaris Del Estudiant
+ You are in subcommunity sharing parent's community cards. To import grades, please go to the parent community
+ Taula que mostra els blocs d'avaluaci� de la assignatura amb el seus par�metres: nom, tipus, percentatge i restricci�. Tamb� permet crear un nou bloc, editar i borrar un ja existent.
+ Tabla que ens mostra les notes de l'estudiant agrupades per blocks
+ Llistat del nom, cognoms i mail del alumnat amb enlla�os a les fitxes
+ Taula que mostra els comentaris privats del profesor sobre l'alumne, els quals no podran ser vistos per l'alumne.
+ Taula que mostra les tasques associades als blocs de la assigantura amb el seus par�metres: nom, bloc, percentatge i nota m�xima. Tamb� permet crear una nova tasca, editar i borrar una ja existent.
+ AVALUAR:
+ NOTES ACTUALITZADES
+ Comentaris Del Professor
+ Afegir un nou bloc
+ Afegir un comentari privat sobre l'alumne
+ Afegir una nova tasca al bloc seleccionat
+ Bloc de la tasca
+ Llistat de notes en format CSV
+ Tipus d'anotacions o tasques que contindr� el bloc i que afectara a la forma de realitzar la mitja del bloc.
+ Borrar el registre seleccionat. Vaja amb compte!
+ Descartar canvis
+ Editar el registre seleccionat
+ Importar notes des d'una tasca del m�dul Avaluaci� a una tasca del m�dul fitxes
+ Avaluar aquesta tasca per a tots els estudiants
+ Llistats de les notes detallades del alumnat
+ Orla de l'alumnat del grup
+ Llistat de notes per imprimir
+ Creaci� de tasques per als blocs disponibles
+ Nota m�xima al evaluar la tasca
+ Orderar per camp ascendent
+ Orderar per camp descendent
+ Guardar canvis
+ Creaci� de blocs amb els seus percentatges
+ Pujar Foto
+ Si
-
-
Index: openacs-4/packages/cards/catalog/cards.en_US.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cards/catalog/cards.en_US.ISO-8859-1.xml,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cards/catalog/cards.en_US.ISO-8859-1.xml 10 Jun 2005 08:26:55 -0000 1.1
+++ openacs-4/packages/cards/catalog/cards.en_US.ISO-8859-1.xml 22 Jun 2006 10:49:22 -0000 1.2
@@ -1,60 +1,131 @@
- Cards
+ Address
+ Evaluate Students
+ Average
+ To add tasks you need create evaluation blocks first
Accept
- Student
- Students
- Note
- Notes
- Passed
+ Action
+ Active
+ Add note
+ Address
+ Allow the students access to its grades
+ Average grade
+ Back
+ Basic
Block
- Delete
+ Block name
Cancel
- Comment
- Student's comments to lecturer
- Lecturer's comments to student
- Setup evaluation
+ Comment
+ Data type
+ Date
+ Deleting the bloc
+ involves to delete all its notes and the loss of its students\' grades. Are you sure?
+ Deleting the note
+ involves the loss of these student\' grades. �Are you sure?
+ Delete
E-mail
- Personal info
- Address
Edit
- Date
- Student's records
- Manage notes
- Note list
Evaluation blocks list
+ Final grade
+ Grade
+ Grades
Grades list
+ Invalid Data. Review marked fields
+ Incorrect value on
+ . Values between 0 and
+ Lecturer's comments to student
+ Manage tasks
+ Notes not availble
Not done
+ Not passed
+ Note
+ Note list
Note name
- Block name
- Grade
- Final grade
- Average grade
- Grades
+ Notes
+ Orla
+ Passed
+ Personal info
+ Phone
+ Reuse cards and grades of the parent course
+ selectionable
+ Setup evaluation
Setup options
+ Student
+ Student's comments to lecturer
+ Student's records
+ Students
+ SUBJECT
+ Task
+ Block
+ Max. Grade
+ Task name
+ Note types
+ Tasks list
+ Text
+ Total assigned
Web Page
- Allow students' access
Without academic validity
- Not passed
- Phone
- Data type
- Total assigned
- Back
- Orla
- Incorrect value on
- . Values between 0 and
- Invalid Data. Review marked fields
- SUBJECT
- Text
- Basic
- selectionable
- Add note
- Active
- Action
- Notes not availble
- Deleting the bloc
- involves to delete all its notes and the loss of its students\' grades. Are you sure?
- Deleting the note
- involves the loss of these student\' grades. �Are you sure?
+ Change Photo
+ Private Comments
+ Comunication
+ E-mail
+ This utility allow to import the "Cards" task grades from the "Evaluation" task grades. The two tasks must be created and the one of evaluation graded. There is no relation between two tasks and to udpate any change of evaluation grades it's needed to import the grades again.
+ FROM EVALUATION
+ Generate CSV file
+ NOTE: The shown final grade corresponds with the accumulated grade until this moment, does not have because to be the final grade
+ Web
+ Import Grades
+ IMPORT GRADES
+ The grades of Card's task selected will be updated with grades of Evaluation's task selected. Are you sure?
+ IMPORT GRADES FROM EVALUATION TO CARDS
+ Printable list notesListado de notas para imprimir
+ Max.
+ characters. Rest:
+ No
+ photo nonavailable
+ No made change. The selected task hasn't grades
+ There aren't tasks in Evaluation or Cards. To import grades the tasks in Evaluation and Cards are needed.
+ Percentatge
+ Phones
+ Cards
+ Printable version
+ Private Coments: the students will not be able to read this comments
+ Restriction more or equal than
+ Select a Card task
+ Select an Evaluation task
+ SEND EVALUATION
+ Student Comments
+ Est�s en una subcomunitat compartint les fitxes de la comunitat pare. Per importar notes cal fer-ho des de el grup pare
+ Table that shows the assignment types (blocks) of the community with its parameters: name, type, percent and restriction. Also it allows create a new assignment type, edit and delete an existing one.
+ Table that shows the student's grades group by blocks
+ List of the name, last names and mail of the students with links to its cards
+ Table that shows teacher's private comments about the student which could not be seen by the student
+ Table that shows the assignment tasks of the group with its parameters: name, assignment type, percent and max grade. Also it allows to create a new task, edit and delete an existing one.
+ EVALUATION:
+ GRADES UPDATED
+ Teacher Comments
+ Add new assignment type (block)
+ Add new private comment
+ Add new task to selected assignment type (block)
+ Task's block/assignment
+ List grades in CSV format
+ Type of the block's tasks which will affect the form to calculate the average of this block
+ Delete selected register. Be careful!
+ Discard changes
+ Edit selected register
+ Import the grades from an evaluation task to student card task
+ Evaluate this task to all students
+ List of students detailed grades
+ Page with students photos
+ List grades to print
+ Create tasks for the available assignment types
+ Max grade to evaluate this task
+ Order by field ascending
+ Order by field descending
+ Save changes
+ Create assignment types (bloks) with its percent values
+ Upload Photo
+ Yes
Index: openacs-4/packages/cards/catalog/cards.es_ES.ISO-8859-1.xml
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cards/catalog/cards.es_ES.ISO-8859-1.xml,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cards/catalog/cards.es_ES.ISO-8859-1.xml 10 Jun 2005 08:26:55 -0000 1.1
+++ openacs-4/packages/cards/catalog/cards.es_ES.ISO-8859-1.xml 22 Jun 2006 10:49:22 -0000 1.2
@@ -1,62 +1,131 @@
- Fichas
+ Direcci�n
+ Evaluar Alumnos
+ Media
+ Para a�adir tareas es necesario crea bloques primero
Aceptar
- Alumno
- Alumnos
- Anotaci�n
- Anotaciones
- Aprobados
+ Acci�n
+ Activa
+ A�adir anotaci�n
+ Direcci�n
+ Permitir a los alumnos acceder a sus notas
+ Nota Media
+ Volver
+ B�sica
Bloque
- Borrar
+ Nombre Bloques
Cancelar
Comentario
- Comentarios del estudiante al profesor
- Comentarios del profesor al estudiante
- Configurar Evaluaci�n
+ Tipo de datos
+ Fecha
+ El borrado del bloque
+ implica el borrado de todas sus anotaciones y la p�rdida de esas notas de los alumnos. �Est� seguro?
+ El borrado de la anotaci�n
+ implica la perdida de esa nota de los alumnos. �Est� seguro?
+ Borrar
Correo electr�nico
- Datos Personales
- Direcci�n
Editar
- Fecha
- Fichas de estudiantes
- Gestionar Anotaciones
- Listado anotaciones
Listado de Bloques
+ Nota Final
+ Nota
+ Notas
Listado Notas
+ Datos no v�lidos. Revisa los campos marcados.
+ Valor incorrecto en
+ . Solo valores enteros entre 0 y
+ Comentarios del profesor al estudiante
+ Gestionar Tareas
+ Anotaciones no disponibles
No presentados
+ Suspensos
+ Anotaci�n
+ Listado anotaciones
Nombre
- Nombre Bloques
- Nota
- Nota Final
- Nota Media
- Notas
+ Anotaciones
+ Orla
+ Aprobados
+ Datos Personales
+ Tel�fono
+ Reutilizar fichas y notas del curso padre
+ Selecionable
+ Configurar Evaluaci�n
Opciones de configuraci�n
+ Alumno
+ Comentarios del estudiante al profesor
+ Fichas de estudiantes
+ Alumnos
+ ASIGNATURA
+ Tarea
+ Bloque
+ Nota M�xima
+ Nombre de la Prueba
+ Tipo de anotaciones
+ Lista de pruebas / tareas
+ Texto
+ Total asignado
P�gina web
- Permitir acceso alumnos
Sin validez acad�mica
- Suspensos
- Tel�fono
- Tipo de datos
- Total asignado
- Volver
- Orla
- Valor incorrecto en
- . Solo valores enteros entre 0 y
- Datos no v�lidos. Revisa los campos marcados.
- ASIGNATURA
- Texto
- B�sica
- Selecionable
- A�adir anotaci�n
- Activa
- Acci�n
- Anotaciones no disponibles
- El borrado del bloque
- implica el borrado de todas sus anotaciones y la p�rdida de esas notas de los alumnos. �Est� seguro?
- El borrado de la anotaci�n
- implica la perdida de esa nota de los alumnos. �Est� seguro?
-
-
+ Cambiar Foto
+ Comentarios privados
+ Comunicaci�n
+ Correo electr�nico
+ Esta utilidad permite importar las notas de una tarea del m�dulo Fichas desde una tarea del m�dulo Actividades. Por tanto, las dos tareas deben estar creadas y la de Actividades evaluada. Hay que tener en cuenta que no se guarda ninguna relaci�n entre las tareas y que para reflejar en Fichas cualquier cambio producido en las notas de Actividades hay que volver a importar las notas.
+ DESDE ACTIVIDADES
+ Generar archivo CSV
+ AVISO: La nota se corresponde con la nota acumulada hasta el momento, no tiene porque ser la nota definitiva
+ P�gina web
+ Importar Notas
+ IMPORTAR NOTAS
+ Las notas de la tarea de Fichas seleccionada ser�n actualizadas con las notas de la tarea de Actividades seleccionada. Est� seguro?
+ IMPORTAR NOTAS DESDE ACTIVIDADES A FICHAS
+ Listado de notas para imprimir
+ M�ximo
+ car�cteres. Quedan:
+ No
+ Foto no disponible
+ Ning�n cambio realizado. La tarea seleccionada no tiene notas.
+ No hay tareas en Actividades o en Fichas. Para poder importar las notas debe estar creada la tarea en Actividades y en Fichas
+ Porcentaje
+ Tel�fonos
+ Fichas
+ Versi�n para imprimir
+ Comentarios Privados: el estudiante nunca podr� ver estos comentarios
+ Restricci�n mayor o igual que
+ Selecciona una tarea del m�dulo Fichas
+ Selecciona una tarea del m�dulo Actividades
+ ENVIAR EVALUACI�N
+ Comentarios Del Estudiante
+ Est�s en un subgrupo compartiendo las fichas de estudiantes con el grupo padre. Para importar notas desde hacerlo desde el grupo
+ Tabla que muestra los bloques de evaluci�n de la asignatura con sus par�metros: nombre, tipo, porcentaje y restricci�n. Tambi�n permite crear un nuevo bloque, editar y borrar uno ya existente.
+ Tabla que nos muestra las notas del estudiante agrupadas por bloques
+ Listado del nombre, apellidos y mail de los alumnos con enlaces a su ficha
+ Tabla que muestra los comentarios privados del profesor sobre el alumno, los cuales no podr�n ser vistos por el alumno
+ Tabla que muestra las tareas asociadas a los bloques de la asigantura con sus par�metres: nombre, bloque, porcentaje y nota m�xima. Tambi�n permite crear una nueva tarea, editar y borrar una ya existente.
+ EVALUAR:
+ NOTAS MODIFICADAS
+ Comentarios Del Profesor
+ A�adir un nuevo bloque
+ A�adir un comentario privado sobre el alumno
+ A�adir una nueva tarea en el bloque seleccionado
+ Bloque de la tarea
+ Listado de notas en formato CSV
+ Tipos de anotaciones o tareas que contindr� el bloque y que afectaran a la forma de realitzar la media del bloque
+ Borrar el registro seleccionado. Tenga cuidado!
+ Descartar cambios
+ Editar el registro seleccionado
+ Importar notas desde una tarea del m�dulo Evaluaci�n a una tarea del m�dulo Fichas
+ Evaluar esta tarea a todos los estudiantes
+ Listado de las notas detalladas del alumnado
+ Orla del alumnado del grupo
+ Listado de notas para imprimir
+ Creaci�n de tareas para los bloques disponibles
+ Nota m�xima al evaluar la tarea
+ Orderar por campo ascendente
+ Orderar por campo descendente
+ Guardar cambios
+ Creaci�n de bloques con sus porcentajes
+ Subir Foto
+ Si
Index: openacs-4/packages/cards/sql/postgresql/cards-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cards/sql/postgresql/cards-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cards/sql/postgresql/cards-create.sql 10 Jun 2005 08:26:55 -0000 1.1
+++ openacs-4/packages/cards/sql/postgresql/cards-create.sql 22 Jun 2006 10:49:22 -0000 1.2
@@ -1,82 +1,73 @@
-- TABLE UV_CARD -------------------------------------------------------------
-create sequence uv_card_sequence start 1;
-create table uv_card (
- id_card integer primary key default nextval ('uv_card_sequence'),
- ref_community_id integer not null,
- ref_user_id integer not null,
+create sequence card_sequence start 1;
+create table card (
+ card_id integer primary key default nextval ('card_sequence'),
+ ref_community integer not null,
+ ref_user integer not null,
comm_student varchar (1000),
comm_teacher varchar (1000),
+ closed boolean default 'f',
address varchar (300),
- phone1 varchar (30),
- phone2 varchar (30)
+ phone1 varchar (60),
+ grade varchar (30)
);
-create unique index uv_card_idx on uv_card (ref_community_id, ref_user_id);
+create unique index card_idx on card (ref_community, ref_user);
-
--- TABLE UV_CARD_BASE_NOTE -------------------------------------------------------------
-create table uv_card_base_note (
- community_id integer primary key,
- base_note integer not null default 100,
- alum_view integer default 0
-);
-
--- TABLE UV_CARD_BASETYPE_NOTE -------------------------------------------------------------
-create table uv_card_basetype_note (
- id_basetype integer primary key,
- name_basetype varchar (30),
- info_basetype varchar (300),
- is_numeric boolean default true
+-- TABLE CARD_PERCENT -------------------------------------------------------------
+create sequence card_percent_sequence start 1;
+create table card_percent (
+ percent_id integer primary key default nextval('card_percent_sequence'),
+ ref_community integer not null,
+ percent_name varchar (50),
+ type integer not null,
+ percent double precision default 0,
+ rvalor double precision default 0.0
);
+create index card_percent_comm_idx on card_percent (ref_community);
--- TABLE UV_CARD_XCENT_NOTE -------------------------------------------------------------
-create sequence uv_card_xcent_note_sequence start 1;
-create table uv_card_xcent_note (
- id_xcent integer primary key default nextval('uv_card_xcent_note_sequence'),
- ref_community_id integer not null,
- ref_basetype integer not null,
- name_xcent varchar (50),
- xcent double precision default 0,
- allow_act boolean default false,
- rvalor double precision default 0.0,
- np boolean default false,
- constraint ref_basetype_fk foreign key (ref_basetype) references uv_card_basetype_note (id_basetype)
+-- TABLE CARD_TASK -------------------------------------------------------------
+create sequence card_task_sequence start 1;
+create table card_task (
+ task_id integer primary key default nextval('card_task_sequence'),
+ ref_community integer not null,
+ ref_percent integer not null,
+ task_name varchar (50),
+ task_percent double precision default 0.00,
+ max_grade double precision not null default 10.00,
+ constraint ref_percent_fk foreign key (ref_percent) references card_percent (percent_id)
);
-create index uv_card_xcent_comm_idx on uv_card_xcent_note (ref_community_id);
+create index card_task_comm_idx on card_task (ref_community);
+create index card_task_percent_idx on card_task (ref_percent);
--- TABLE UV_CARD_SUBTYPE_NOTE -------------------------------------------------------------
-create sequence uv_card_subtype_note_sequence start 1;
-create table uv_card_subtype_note (
- id_subtype integer primary key default nextval('uv_card_subtype_note_sequence'),
- ref_community_id integer not null,
- ref_xcent integer not null,
- sub_xcent double precision default 0.00,
- name_subtype varchar (50),
- constraint ref_xcent_fk foreign key (ref_xcent) references uv_card_xcent_note (id_xcent)
+-- TABLE CARD_NOTE -------------------------------------------------------------
+create sequence card_note_sequence start 1;
+create table card_note (
+ note_id integer primary key default nextval('card_note_sequence'),
+ ref_card integer not null,
+ ref_community integer not null,
+ ref_task integer not null,
+ date timestamptz default current_timestamp not null,
+ date_mod timestamptz default current_timestamp not null,
+ grade numeric(4,2) default 0.00,
+ note_comment varchar (400),
+ is_active boolean default true,
+ constraint ref_task_fk foreign key (ref_task) references card_task (task_id),
+ constraint ref_id_cards_fk foreign key (ref_card) references card (card_id)
);
-create index uv_card_subtype_comm_idx on uv_card_subtype_note (ref_community_id);
-create index uv_card_subtype_xcent_idx on uv_card_subtype_note (ref_xcent);
+create index card_note_comm_idx on card_note (ref_community);
+create index card_note_task_idx on card_note (ref_task);
--- TABLE UV_CARD_NOTES -------------------------------------------------------------
-create sequence uv_card_notes_sequence start 1;
-create table uv_card_notes (
- id_card_notes integer primary key default nextval('uv_card_notes_sequence'),
- ref_id_card integer not null,
- note_datetime timestamptz default current_timestamp not null,
- ref_subtype integer not null,
- value_n numeric(4,2) default 0.00,
- value_s varchar (300),
- is_public boolean default false,
- is_active boolean default true,
- r_community_id integer not null,
- constraint ref_subtype_fk foreign key (ref_subtype) references uv_card_subtype_note(id_subtype),
- constraint ref_id_cards_fk foreign key (ref_id_card) references uv_card(id_card)
-);
-create index uv_card_notes_comm_idx on uv_card_notes (r_community_id);
-create index uv_card_notes_subtype_idx on uv_card_notes (ref_subtype);
--- INICIALIZACI�N DE DATOS -------------------------------------------------------------
-insert into uv_card_basetype_note (id_basetype, name_basetype, info_basetype, is_numeric) values (1,'B�sico', 'Anotaciones sencillas: pr�cticas, tareas, trabajos, actividades, ...','t');
-insert into uv_card_basetype_note (id_basetype, name_basetype, info_basetype, is_numeric) values (2,'Seleccionable', 'Anotaciones que permiten selecci�n: ex�menes','t');
-insert into uv_card_basetype_note (id_basetype, name_basetype, info_basetype, is_numeric) values (3,'Texto', 'Anotaciones sin asignaci�n de nota: comentarios','f');
-
+-- TABLE CARD_COMMENTS -------------------------------------------------------------
+create sequence card_comment_sequence start 1;
+create table card_comment (
+ comment_id integer primary key default nextval('card_comment_sequence'),
+ ref_card integer not null,
+ ref_community integer not null,
+ date timestamptz default current_timestamp not null,
+ date_mod timestamptz default current_timestamp not null,
+ comment varchar (400),
+ constraint ref_id_cards_fk foreign key (ref_card) references card(card_id)
+);
+create index card_comment_comm_idx on card_comment (ref_community);
Index: openacs-4/packages/cards/sql/postgresql/cards-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cards/sql/postgresql/cards-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cards/sql/postgresql/cards-drop.sql 10 Jun 2005 08:26:55 -0000 1.1
+++ openacs-4/packages/cards/sql/postgresql/cards-drop.sql 22 Jun 2006 10:49:22 -0000 1.2
@@ -1,23 +1,21 @@
+drop sequence card_note_sequence;
+drop index card_note_comm_idx;
+drop index card_note_task_idx;
+drop table card_note;
-drop sequence uv_card_notes_sequence;
-drop index uv_card_notes_comm_idx;
-drop index uv_card_notes_subtype_idx;
-drop table uv_card_notes;
+drop sequence card_task_sequence;
+drop index card_task_comm_idx;
+drop index card_task_percent_idx;
+drop table card_task;
-drop sequence uv_card_subtype_note_sequence;
-drop index uv_card_subtype_comm_idx;
-drop index uv_card_subtype_xcent_idx;
-drop table uv_card_subtype_note;
+drop sequence card_percent_sequence;
+drop index card_percent_comm_idx;
+drop table card_percent;
-drop sequence uv_card_xcent_note_sequence;
-drop index uv_card_xcent_comm_idx;
-drop table uv_card_xcent_note;
+drop sequence card_comment_sequence;
+drop index card_comment_comm_idx;
+drop table card_comment;
-drop table uv_card_basetype_note;
-
-drop table uv_card_base_note;
-
-drop sequence uv_card_sequence;
-drop index uv_card_idx;
-drop table uv_card;
-
+drop sequence card_sequence;
+drop index card_idx;
+drop table card;
\ No newline at end of file
Index: openacs-4/packages/cards/www/cards.css
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cards/www/cards.css,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/cards/www/cards.css 10 Jun 2005 08:26:55 -0000 1.1
+++ openacs-4/packages/cards/www/cards.css 22 Jun 2006 10:49:23 -0000 1.2
@@ -1,42 +1,208 @@
-/* CSS CARDS PACKAGE - UVEG - fransola@uv.es */
-a.t:hover {background:#ffcc00;padding-top:5px;padding-bottom:2px;}
-a.button1 {font: 85% arial; border: solid 1px black; background-color: #99ccff; text-align: center; padding: 2px; padding-left: 8px; padding-right: 8px; color: black; text-decoration: none; white-space: nowrap;}
-
-a{color:#0048AF}
-a:visited{color:#0048AF}
-a.link1 {background:#FFFFE0;color:#383C93;font-weight:bold}
-a.link1:visited{background:#FFFFE0;color:#383C93;font-weight:bold}
-a.link1:hover {background:#FAC328;color:#383C93;font-weight:bold}
-img {border:0px}
-
-
-form {font-size:11px;color:#003366}
-input {font-size:11px;color:#003366}
-select {font-size:11px;color:#003366}
-textarea {font-size:11px;color:#003366}
-
-.list_c {padding:4px;border-right:1px solid #A0BDEB;padding-left:5px}
-.list_h { background:#6186b0;border-bottom: 3px solid #A0BDEB;color:white;text-align:left}
-
-th.list_c { border-bottom: 3px solid #A0BDEB;}
-
-tr.list_c_sel { border-right:1px solid #A0BDEB;border-bottom: 1px solid #A0BDEB;background:#e0e0e0;}
-tr.list-odd_c {padding:4px;border-right:1px solid #A0BDEB;background-color: #EAF2FF;}
-tr.list-even_c {padding:4px;border-right:1px solid #A0BDEB;background-color: white;}
-
-td.list_c { border-bottom: 1px solid #A0BDEB;}
-td.list_c_sel { border-right:1px solid #A0BDEB;border-bottom: 1px solid #A0BDEB;background:#e0e0e0;}
-td.list_sel {padding:4px;border-right:1px solid #A0BDEB;padding-left:5px;background:#e0e0e0;}
-td.list-button-bar {padding-top: 3px; font-size: 115%;}
-td.orla {width:85px;height:85px;border: 1px solid #6186B0;font-size:9px;}
-td.orla:hover {width:85px;height:85px;border: 1px solid #FAC328;font-size:9px;}
-
-div.volver {background:#6186b0;color:#ffffff;padding-top:5px;padding-bottom:2px;display:inline}
-
-
-
-
-
-
-
-
+/* CSS CARDS PACKAGE - UVEG - fransola@uv.es
+a.t:hover {background:#ffcc00;padding-top:5px;padding-bottom:2px;}
+a.button1 {font: 100% arial; border: solid 1px black; background-color: #99ccff; text-align: center; padding: 2px; padding-left: 8px; padding-right: 8px; color: black; text-decoration: none; white-space: nowrap;}
+
+a.button { font: 100% arial; border: solid 1px black; background-color: #e1e1e1;
+ text-align: center; padding: 1px; padding-left: 8px; padding-right: 8px; color: black;
+ text-decoration: none; white-space: nowrap;
+}
+
+
+a {color:#0048AF; border:0px solid red}
+a:visited{color:#0048AF}
+a.link1 {background:#FFFFE0;color:#383C93;font-weight:bold}
+a.link1:visited{background:#FFFFE0;color:#383C93;font-weight:bold}
+a.link1:hover {background:#FAC328;color:#383C93;font-weight:bold}
+a.order {color:red;text-decoration: none}
+img {border:0px}
+
+
+form {font-size:11px;color:#003366}
+input {font-size:11px;color:#003366}
+select {font-size:11px;color:#003366}
+textarea {font-size:11px;color:#003366}
+pre {font: 95% arial}
+
+.list_c {padding:4px;border-right:1px solid #A0BDEB;padding-left:5px}
+.list_h { background:#6186b0;border-bottom: 3px solid #A0BDEB;
+ padding-top: 3px; padding-bottom: 3px;color:white;text-align:left; }
+
+th.list_c { border-bottom: 3px solid #A0BDEB;}
+
+tr.list_c_sel { border-right:10px solid #A0BDEB;border-bottom: 10px solid #A0BDEB;}
+tr.list-odd_c {padding:4px;border-right:1px solid #A0BDEB;background-color: #EAF2FF;}
+tr.list-even_c {padding:4px;border-right:1px solid #A0BDEB;background-color: white;}
+
+table.list_to_print {
+ font-family: tahoma, verdana, helvetica;
+ border-collapse: collapse;
+ font-size: 70%;
+}
+th.list_to_print {font-size:80% arial; padding-left: 0.5em; padding-right: 0.5em; border-bottom: 3px solid #A0BDEB;}
+td.list_to_print {font-size:80% arial; padding-left: 0.5em; padding-right: 0.5em; border-bottom: 1px solid #A0BDEB;}
+td.list_c { border-bottom: 1px solid #A0BDEB;}
+td.list_c_sel { border-right:1px solid #A0BDEB;border-bottom: 1px solid #A0BDEB;background:#e0e0e0;}
+td.list_sel {padding:4px;border-right:1px solid #A0BDEB;padding-left:5px;background:#e0e0e0;}
+td.list-button-bar {padding-top: 3px; font-size: 115%;}
+td.orla {width:85px;height:85px;border: 1px solid #6186B0;font-size:9px;}
+td.orla:hover {width:85px;height:85px;border: 1px solid #FAC328;font-size:9px;}
+
+div.volver {background:#6186b0;color:#ffffff;padding-top:5px;padding-bottom:2px;display:inline}
+.volver {background:#6186b0;color:#ffffff;padding-top:5px;padding-bottom:2px;display:inline}
+
+.t_asig {background:#5C81B7;color:#ffffff;font-weight:bold;padding-top:5px;padding-bottom:2px;display:inline}
+.t_nota {border:2px solid orange; color:#5C81B7;font-weight:bold;padding-top:5px;padding-bottom:2px;display:inline}
+
+a.t_volver {background:#5C81B7;color:#ffffff;font-weight:bold;padding-top:5px;padding-bottom:2px;display:inline}
+a.t_volver:hover {background:#ffcc00;}
+.t_nom {color:#003E76;font: 125% arial; font-weight:bold}
+
+.t_grade { color:#003E76;border:2px solid orange; margin:5px; padding-bottom:5px; padding-top: 5px; font: 115% arial;font-weight:bold}
+
+
+
+*/
+
+/* NUEVOS ESTILOS -- MAS ACCESIBLES
+
+div.w100 {width:100%; margin-bottom:1em}
+div.container { width:auto; text-align:left;}
+div.float { float: left; padding:0.5em; }
+div.float p { text-align: center; }
+div.menu_item {float:left;padding-right: 0.5em;}
+
+
+tr.uv_list_sel { background:#e0e0e0}
+td.uv_list_selected {
+ font: 1.0em Arial;
+ padding: 0.3em 1em; margin:2.5em; border-bottom: 3px solid #A0BDEB;}
+
+.list_c {padding:0.5em;border-right:1px solid #A0BDEB;padding-left:0.5em}
+
+.edit {font: 1.2em Arial;}
+
+p.photo_text {width:72px; display:block;} */
+
+/*** FORMULARIOS
+form {font-size:1em;color:#003366}
+input {font-size:1em;color:#003366}
+select {font-size:1em;color:#003366}
+textarea {font-size:1em;color:#003366}
+pre {font: 95% arial}
+***/
+
+
+/****************************************************************************************************/
+
+/*** AREAS ***/
+div.all {width:100%; margin:0em; padding:0em; border:0em; }
+
+div.spacer { clear: both; font: 0.4em arial; border:0px solid red }
+div.comm {background:#6186b0;color:#ffffff;
+ padding:0.3em; float:left;
+ font: 1.2em arial; font-weight: bold}
+div.back {background:#6186b0;color:#ffffff;
+ float:right; padding-top:0.3em; padding-bottom:0.3em; }
+
+div.back_l {background:#6186b0;color:#ffffff;
+ padding-top:0.3em; padding-bottom:0.3em; float:left }
+
+div.container { width:auto; text-align:left;}
+div.float { float: left; padding:0.5em; }
+div.float p { text-align: center; }
+p.photo_text {width:72px; display:block;}
+
+div.form {float:left; background:white; padding: 0em 1em; display:table; overflow:hidden}
+p.form {background:#CCDDFF; border-bottom:1px solid #ffffff;padding-left:0.2em 0.5em:}
+p.form1 {background:#ffffff;border-bottom:1px solid #5C81B7; padding-left:0.2em 0.5em;}
+
+
+div.photo {float:left; background:#ffffff;}
+div.white {width:100%; background:#ffffff}
+
+/*** LINKS ***/
+a { text-decoration:none;padding:0px; margin:0px; border:0px}
+a.noline {text-decoration:none;padding:0px; margin:0px; border:0px}
+a.noline:hover {text-decoration:underline}
+a.back, a.back:visited {color:#ffffff; font-weight: bold; padding:0.5em; border:0px}
+a.back:hover {background:#ffcc00; color:#ffffff; font-weight: bold; text-decoration: underline }
+
+a.button_item, a.button_item:visited{
+ font: 1.0em arial; text-align: center;text-decoration: none; white-space: nowrap;
+ background-color: #e1e1e1;color: black; border: solid 1px black;
+ float:left; padding: 2px 0.6em; margin: 0.5em 0em; margin-right: 0.5em;
+ }
+
+a.button_item:hover { background:#cccccc; text-decoration:underline;}
+
+a.alum , a.alum:visited, a.csv, a.csv:visited {text-decoration:none; border-bottom:0px}
+a.alum:hover, a.csv:hover {text-decoration:underline; border-bottom:0px}
+
+a.orderby {margin-left:1em; border:0px}
+
+
+/*** TABLE ***/
+table.uv_list {border-collapse:collapse}
+caption.uv_list { font:1.2em Arial;font-weight:bold;padding:0.5em 1em}
+tr.uv_list_header {background:#ffffff; padding:10px 0px}
+th.uv_list {
+ text-align:left; font: 1.0em Arial; font-weight:bold;
+ padding: 0.3em 1em; border-bottom: 3px solid #A0BDEB;}
+td.uv_list {
+ font: 1.0em Arial;
+ padding: 0.3em 1em; margin: 2.5em; border-bottom: 1px solid #A0BDEB;}
+
+table.uv_table { width:100%;border-collapse:collapse; border:1px solid #A0BDEB; padding:0px; padding:0px}
+table.uv_table1 { width:100%;border-collapse:collapse; border:0px solid #A0BDEB; padding:0px; padding:0px}
+caption.uv_table, div.title {font:1.2em Arial;font-weight:bold;padding:0.5em 1em}
+tr.uv_table_header {background:#ffffff; padding:10px 0px}
+tr.uv_cell_insert {background:#e0e0e0;}
+th.uv_cell {
+ font: 1.0em Arial; font-weight:bold; text-align:left;
+ padding: 0.3em 1em; border-bottom: 3px solid #A0BDEB;
+ border-right: 1px solid #A0BDEB;}
+td.uv_cell {
+ font: 1.0em Arial; padding: 0.0em 1em; margin: 2.5em;
+ border-bottom: 1px solid #A0BDEB;border-right: 1px solid #A0BDEB;}
+td.uv_cell_insert {
+ font: 1.0em Arial; padding: 0.0em 1em; margin: 2.5em;
+ border-bottom: 1px solid #A0BDEB;border-right: 1px solid #A0BDEB;}
+
+table.form {background:#ffffff; margin:3px}
+caption.form {font:1.2em Arial;font-weight:bold;text-align:left}
+tr.form {}
+th.form {margin-bottom:3px;font-weight:bold; background:#CCDDFF; text-align:left; padding:3px; padding-left:5px}
+td.form { background:#ffffff; border:1px solid #A0BDEB; padding:3px; padding-left:5px}
+td.photo { background:#ffffff; vertical-align:middle; padding:3px; padding-left:5px}
+
+th.final_grade {color:#003E76;border:2px solid orange; margin:5px; padding-bottom:5px; padding-top: 5px; font: 115% arial;font-weight:bold;}
+th.no_border {border:0px}
+th.block {background:#6186b0;color:#ffffff; font-weight: bold; text-align:left; padding:2px}
+th.block_avg {background:#6186b0;color:#ffffff; font-weight: bold; text-align:right; padding:2px}
+
+
+/*** IMAGES ***/
+img {border:0px;padding:0px; margin:0px;text-decoration:none}
+
+
+/**** VARIOS *******/
+
+h4.total {display:block; width: 100%; color:#6186b0; font-family:Arial; text-align:right}
+h3.black {display:block; width: 100%; color:#000000; font:1.2em Arial; text-align:left}
+span.alert {color:red;}
+span.big {font-weight:bold; font-size:1.5em}
+span.small {font-weight:normal; font-size:0.7em}
+span.yes {font-weight:bold; font-size:1.0em}
+span.student {font: 1.2em Arial}
+span.underline {font: 1em Arial;text-decoration: underline}
+span.bold {font: 1em Arial;font-weight:bold}
+span.cursive {font: 1em Arial; font-style: italic}
+span.notes {font: 0.8em Courier}
+span.char {font-size:80%}
+li.config_item{font-family:Arial; padding-bottom:0.4em}
+pre {font: 90% Arial}
+p {font: 1em arial}
+textarea {font: 1.2em Arial}
+
+
+#white {background:#ffffff}