app\views\classroom\_form.php(165):turn about br.tag HOT 1 CLOSED

commented on June 12, 2024

app\views\classroom\_form.php(165):turn

from br.tag.

Comments (1)

franciscocabral commented on June 12, 2024

Já existe. Só precisa definir onde ficará a seguinte tela:
http://tag/wizard/configuration/school
Ela é quem cuida da definição de horário padrão dos turnos.

Este SQL pode resolver isso facilmente, definindo um padrão para a tabela.

ALTER TABLE `br.org.ipti.tag`.`school_configuration` 
ADD UNIQUE INDEX `school_inep_id_fk_UNIQUE` (`school_inep_id_fk` ASC);

ALTER TABLE `br.org.ipti.tag`.`school_configuration` 
CHANGE COLUMN `morning_initial` `morning_initial` TIME NULL DEFAULT "07:00:00" ,
CHANGE COLUMN `morning_final` `morning_final` TIME NULL DEFAULT "12:00:00" ,
CHANGE COLUMN `afternoom_initial` `afternoom_initial` TIME NULL DEFAULT "14:00:00" ,
CHANGE COLUMN `afternoom_final` `afternoom_final` TIME NULL DEFAULT "18:00:00" ,
CHANGE COLUMN `night_initial` `night_initial` TIME NULL DEFAULT "17:00:00" ,
CHANGE COLUMN `night_final` `night_final` TIME NULL DEFAULT "22:00:00" ,
CHANGE COLUMN `allday_initial` `allday_initial` TIME NULL DEFAULT "07:00:00" ,
CHANGE COLUMN `allday_final` `allday_final` TIME NULL DEFAULT "18:00:00" ;

INSERT INTO `br.org.ipti.tag`.`school_configuration` (`school_inep_id_fk`,`morning_initial`,`morning_final`,`afternoom_initial`,`afternoom_final`,`night_initial`,`night_final`,`allday_initial`,`allday_final`)
SELECT inep_id, '07:00:00', '12:00:00', '14:00:00', '18:00:00', '17:00:00', '22:00:00', '07:00:00', '18:00:00' FROM school_identification
ON DUPLICATE key update school_inep_id_fk = school_inep_id_fk;