Releases: LightSys/midwife-EMR
Releases · LightSys/midwife-EMR
0.2.31
Changes in this release
- Added progress notes feature.
- Refactored prenatal/progress notes in summary report.
Upgrade instructions
- Run the following SQL.
CREATE TABLE IF NOT EXISTS `pregnoteType` (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20) NOT NULL,
description VARCHAR(250) NULL,
UNIQUE(name)
);
CREATE TABLE IF NOT EXISTS `pregnote` (
id INT AUTO_INCREMENT PRIMARY KEY,
pregnoteType INT NOT NULL,
noteDate DATE NOT NULL,
note TEXT NULL,
updatedBy INT NOT NULL,
updatedAt DATETIME NOT NULL,
supervisor INT NULL,
pregnancy_id INT NOT NULL,
FOREIGN KEY (pregnancy_id) REFERENCES pregnancy (id) ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (pregnoteType) REFERENCES pregnoteType (id) ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (updatedBy) REFERENCES user (id) ON DELETE NO ACTION ON UPDATE NO ACTION
);
INSERT INTO `pregnoteType`
(name, description)
VALUES
('prenatalProgress', 'Progress notes for prenatal exams.');
- Run grunt after installing code.
grunt
0.2.30
0.2.29
Changes
- Implemented transfer of care feature.
- Scheduled chart on home page does not include transferred out patients.
- Enabled search for transferred patients with date range options.
Upgrade instructions
- Run the following SQL
ALTER TABLE pregnancy ADD COLUMN transferOfCare DATETIME NULL AFTER philHealthApproved;
ALTER TABLE pregnancy ADD COLUMN transferOfCareNote VARCHAR(1000) NULL DEFAULT '' AFTER transferOfCare;
ALTER TABLE pregnancyLog ADD COLUMN transferOfCare DATETIME NULL AFTER philHealthApproved;
ALTER TABLE pregnancyLog ADD COLUMN transferOfCareNote VARCHAR(1000) NULL DEFAULT '' AFTER transferOfCare;
DELIMITER $$
DROP TRIGGER IF EXISTS pregnancy_after_insert;
CREATE TRIGGER pregnancy_after_insert AFTER INSERT ON pregnancy
FOR EACH ROW
BEGIN
INSERT INTO pregnancyLog
(id, firstname, lastname, maidenname, nickname, religion, maritalStatus, telephone, work, education, clientIncome, clientIncomePeriod, address1, address2, address3, address4, city, state, postalCode, country, gravidaNumber, lmp, sureLMP, warning, riskNote, alternateEdd, useAlternateEdd, doctorConsultDate, dentistConsultDate, mbBook, whereDeliver, fetuses, monozygotic, pregnancyEndDate, pregnancyEndResult, iugr, note, numberRequiredTetanus, invertedNipples, hasUS, wantsUS, gravida, stillBirths, abortions, living, para, term, preterm, philHealthMCP, philHealthNCP, philHealthID, philHealthApproved, transferOfCare, transferOfCareNote, currentlyVomiting, currentlyDizzy, currentlyFainting, currentlyBleeding, currentlyUrinationPain, currentlyBlurryVision, currentlySwelling, currentlyVaginalPain, currentlyVaginalItching, currentlyNone, useIodizedSalt, takingMedication, planToBreastFeed, birthCompanion, practiceFamilyPlanning, practiceFamilyPlanningDetails, familyHistoryTwins, familyHistoryHighBloodPressure, familyHistoryDiabetes, familyHistoryHeartProblems, familyHistoryTB, familyHistorySmoking, familyHistoryNone, historyFoodAllergy, historyMedicineAllergy, historyAsthma, historyHeartProblems, historyKidneyProblems, historyHepatitis, historyGoiter, historyHighBloodPressure, historyHospitalOperation, historyBloodTransfusion, historySmoking, historyDrinking, historyNone, questionnaireNote, partnerFirstname, partnerLastname, partnerAge, partnerWork, partnerEducation, partnerIncome, partnerIncomePeriod, updatedBy, updatedAt, supervisor, patient_id, op, replacedAt)
VALUES (NEW.id, NEW.firstname, NEW.lastname, NEW.maidenname, NEW.nickname, NEW.religion, NEW.maritalStatus, NEW.telephone, NEW.work, NEW.education, NEW.clientIncome, NEW.clientIncomePeriod, NEW.address1, NEW.address2, NEW.address3, NEW.address4, NEW.city, NEW.state, NEW.postalCode, NEW.country, NEW.gravidaNumber, NEW.lmp, NEW.sureLMP, NEW.warning, NEW.riskNote, NEW.alternateEdd, NEW.useAlternateEdd, NEW.doctorConsultDate, NEW.dentistConsultDate, NEW.mbBook, NEW.whereDeliver, NEW.fetuses, NEW.monozygotic, NEW.pregnancyEndDate, NEW.pregnancyEndResult, NEW.iugr, NEW.note, NEW.numberRequiredTetanus, NEW.invertedNipples, NEW.hasUS, NEW.wantsUS, NEW.gravida, NEW.stillBirths, NEW.abortions, NEW.living, NEW.para, NEW.term, NEW.preterm, NEW.philHealthMCP, NEW.philHealthNCP, NEW.philHealthID, NEW.philHealthApproved, NEW.transferOfCare, NEW.transferOfCareNote, NEW.currentlyVomiting, NEW.currentlyDizzy, NEW.currentlyFainting, NEW.currentlyBleeding, NEW.currentlyUrinationPain, NEW.currentlyBlurryVision, NEW.currentlySwelling, NEW.currentlyVaginalPain, NEW.currentlyVaginalItching, NEW.currentlyNone, NEW.useIodizedSalt, NEW.takingMedication, NEW.planToBreastFeed, NEW.birthCompanion, NEW.practiceFamilyPlanning, NEW.practiceFamilyPlanningDetails, NEW.familyHistoryTwins, NEW.familyHistoryHighBloodPressure, NEW.familyHistoryDiabetes, NEW.familyHistoryHeartProblems, NEW.familyHistoryTB, NEW.familyHistorySmoking, NEW.familyHistoryNone, NEW.historyFoodAllergy, NEW.historyMedicineAllergy, NEW.historyAsthma, NEW.historyHeartProblems, NEW.historyKidneyProblems, NEW.historyHepatitis, NEW.historyGoiter, NEW.historyHighBloodPressure, NEW.historyHospitalOperation, NEW.historyBloodTransfusion, NEW.historySmoking, NEW.historyDrinking, NEW.historyNone, NEW.questionnaireNote, NEW.partnerFirstname, NEW.partnerLastname, NEW.partnerAge, NEW.partnerWork, NEW.partnerEducation, NEW.partnerIncome, NEW.partnerIncomePeriod, NEW.updatedBy, NEW.updatedAt, NEW.supervisor, NEW.patient_id, "I", NOW());
END;$$
DELIMITER ;
DELIMITER $$
DROP TRIGGER IF EXISTS pregnancy_after_update;
CREATE TRIGGER pregnancy_after_update AFTER UPDATE ON pregnancy
FOR EACH ROW
BEGIN
INSERT INTO pregnancyLog
(id, firstname, lastname, maidenname, nickname, religion, maritalStatus, telephone, work, education, clientIncome, clientIncomePeriod, address1, address2, address3, address4, city, state, postalCode, country, gravidaNumber, lmp, sureLMP, warning, riskNote, alternateEdd, useAlternateEdd, doctorConsultDate, dentistConsultDate, mbBook, whereDeliver, fetuses, monozygotic, pregnancyEndDate, pregnancyEndResult, iugr, note, numberRequiredTetanus, invertedNipples, hasUS, wantsUS, gravida, stillBirths, abortions, living, para, term, preterm, philHealthMCP, philHealthNCP, philHealthID, philHealthApproved, transferOfCare, transferOfCareNote, currentlyVomiting, currentlyDizzy, currentlyFainting, currentlyBleeding, currentlyUrinationPain, currentlyBlurryVision, currentlySwelling, currentlyVaginalPain, currentlyVaginalItching, currentlyNone, useIodizedSalt, takingMedication, planToBreastFeed, birthCompanion, practiceFamilyPlanning, practiceFamilyPlanningDetails, familyHistoryTwins, familyHistoryHighBloodPressure, familyHistoryDiabetes, familyHistoryHeartProblems, familyHistoryTB, familyHistorySmoking, familyHistoryNone, historyFoodAllergy, historyMedicineAllergy, historyAsthma, historyHeartProblems, historyKidneyProblems, historyHepatitis, historyGoiter, historyHighBloodPressure, historyHospitalOperation, historyBloodTransfusion, historySmoking, historyDrinking, historyNone, questionnaireNote, partnerFirstname, partnerLastname, partnerAge, partnerWork, partnerEducation, partnerIncome, partnerIncomePeriod, updatedBy, updatedAt, supervisor, patient_id, op, replacedAt)
VALUES (NEW.id, NEW.firstname, NEW.lastname, NEW.maidenname, NEW.nickname, NEW.religion, NEW.maritalStatus, NEW.telephone, NEW.work, NEW.education, NEW.clientIncome, NEW.clientIncomePeriod, NEW.address1, NEW.address2, NEW.address3, NEW.address4, NEW.city, NEW.state, NEW.postalCode, NEW.country, NEW.gravidaNumber, NEW.lmp, NEW.sureLMP, NEW.warning, NEW.riskNote, NEW.alternateEdd, NEW.useAlternateEdd, NEW.doctorConsultDate, NEW.dentistConsultDate, NEW.mbBook, NEW.whereDeliver, NEW.fetuses, NEW.monozygotic, NEW.pregnancyEndDate, NEW.pregnancyEndResult, NEW.iugr, NEW.note, NEW.numberRequiredTetanus, NEW.invertedNipples, NEW.hasUS, NEW.wantsUS, NEW.gravida, NEW.stillBirths, NEW.abortions, NEW.living, NEW.para, NEW.term, NEW.preterm, NEW.philHealthMCP, NEW.philHealthNCP, NEW.philHealthID, NEW.philHealthApproved, NEW.transferOfCare, NEW.transferOfCareNote, NEW.currentlyVomiting, NEW.currentlyDizzy, NEW.currentlyFainting, NEW.currentlyBleeding, NEW.currentlyUrinationPain, NEW.currentlyBlurryVision, NEW.currentlySwelling, NEW.currentlyVaginalPain, NEW.currentlyVaginalItching, NEW.currentlyNone, NEW.useIodizedSalt, NEW.takingMedication, NEW.planToBreastFeed, NEW.birthCompanion, NEW.practiceFamilyPlanning, NEW.practiceFamilyPlanningDetails, NEW.familyHistoryTwins, NEW.familyHistoryHighBloodPressure, NEW.familyHistoryDiabetes, NEW.familyHistoryHeartProblems, NEW.familyHistoryTB, NEW.familyHistorySmoking, NEW.familyHistoryNone, NEW.historyFoodAllergy, NEW.historyMedicineAllergy, NEW.historyAsthma, NEW.historyHeartProblems, NEW.historyKidneyProblems, NEW.historyHepatitis, NEW.historyGoiter, NEW.historyHighBloodPressure, NEW.historyHospitalOperation, NEW.historyBloodTransfusion, NEW.historySmoking, NEW.historyDrinking, NEW.historyNone, NEW.questionnaireNote, NEW.partnerFirstname, NEW.partnerLastname, NEW.partnerAge, NEW.partnerWork, NEW.partnerEducation, NEW.partnerIncome, NEW.partnerIncomePeriod, NEW.updatedBy, NEW.updatedAt, NEW.supervisor, NEW.patient_id, "U", NOW());
END;$$
DELIMITER ;
DELIMITER $$
DROP TRIGGER IF EXISTS pregnancy_after_delete;
CREATE TRIGGER pregnancy_after_delete AFTER DELETE ON pregnancy
FOR EACH ROW
BEGIN
INSERT INTO pregnancyLog
(id, firstname, lastname, maidenname, nickname, religion, maritalStatus, telephone, work, education, clientIncome, clientIncomePeriod, address1, address2, address3, address4, city, state, postalCode, country, gravidaNumber, lmp, sureLMP, warning, riskNote, alternateEdd, useAlternateEdd, doctorConsultDate, dentistConsultDate, mbBook, whereDeliver, fetuses, monozygotic, pregnancyEndDate, pregnancyEndResult, iugr, note, numberRequiredTetanus, invertedNipples, hasUS, wantsUS, gravida, stillBirths, abortions, living, para, term, preterm, philHealthMCP, philHealthNCP, philHealthID, philHealthApproved, transferOfCare, transferOfCareNote, currentlyVomiting, currentlyDizzy, currentlyFainting, currentlyBleeding, currentlyUrinationPain, currentlyBlurryVision, currentlySwelling, currentlyVaginalPain, currentlyVaginalItching, currentlyNone, useIodizedSalt, takingMedication, planToBreastFeed, birthCompanion, practiceFamilyPlanning, practiceFamilyPlanningDetails, familyHistoryTwins, familyHistoryHighBloodPressure, familyHistoryDiabetes, familyHistoryHeartProblems, familyHistoryTB, familyHistorySmoking, familyHistoryNone, historyFoodAllergy, historyMedicineAllergy, historyAsthma, historyHeartProblems, historyKidneyProblems, historyHepatitis, historyGoiter, historyHighBloodPressure, historyHospitalOperation, historyBloodTransfusion, historySmoking, historyDrinking, historyNone, questionnaireNote, partnerFirstname, partnerLastname, partnerAge, partnerWork, partnerEducation, partnerIncome, partnerIncomePeriod, updatedBy, updatedAt, supervisor, patient_id, op, replacedAt)
VALUES (OLD.id, OLD.firstname, OLD.lastname, OLD.maidenname, OLD.nickname, OL...
0.2.28
Changes in this release
- Updated acceptable lab values for Epithelial Cells-Urine.
- Show prenatal exam note field on prenatal summary page.
- Do not retrieve all related tables in ORM except when needed.
- Added history of examiners to prenatal summary on prenatal page.
- Fixed logic for creating new pregnancy record.
Upgrade instructions (after installing the new code)
- Run this SQL.
INSERT INTO `labTestValue`
(value, labTest_id, updatedBy, updatedAt)
VALUES
('Few', (SELECT id FROM labTest WHERE abbrev = 'Epithelial Cells-Urine'), 1, NOW()),
('Moderate', (SELECT id FROM labTest WHERE abbrev = 'Epithelial Cells-Urine'), 1, NOW()),
('Many', (SELECT id FROM labTest WHERE abbrev = 'Epithelial Cells-Urine'), 1, NOW());
- Run grunt in the top-level directory
grunt
0.2.27
Changes in this release
- Fixed spelling error on labs page.
- Allow adding multiple medications on one screen.
- Fixed log errors when reports run with incomplete params.
- Refactored takingMedication/planToBreastFeed to Y/N/? fields.
Upgrade instructions after updating code
- Backup the database.
- Run grunt on the command-line in the top-level directory.
- Run the following SQL against the database to upgrade.
ALTER TABLE pregnancy ADD COLUMN takingMedication2 CHAR(1) NOT NULL DEFAULT "" AFTER takingMedication;
ALTER TABLE pregnancy ADD COLUMN planToBreastFeed2 CHAR(1) NOT NULL DEFAULT "" AFTER planToBreastFeed;
UPDATE pregnancy
SET takingMedication2 = 'N'
WHERE takingMedication = 0;
UPDATE pregnancy
SET takingMedication2 = 'Y'
WHERE takingMedication = 1;
UPDATE pregnancy
SET planToBreastFeed2 = 'N'
WHERE planToBreastFeed = 0;
UPDATE pregnancy
SET planToBreastFeed2 = 'Y'
WHERE planToBreastFeed = 1;
ALTER TABLE pregnancy DROP COLUMN takingMedication;
ALTER TABLE pregnancy DROP COLUMN planToBreastFeed;
ALTER TABLE pregnancy CHANGE takingMedication2 takingMedication CHAR(1) NOT NULL DEFAULT "";
ALTER TABLE pregnancy CHANGE planToBreastFeed2 planToBreastFeed CHAR(1) NOT NULL DEFAULT "";
ALTER TABLE pregnancyLog ADD COLUMN takingMedication2 CHAR(1) NOT NULL DEFAULT "" AFTER takingMedication;
ALTER TABLE pregnancyLog ADD COLUMN planToBreastFeed2 CHAR(1) NOT NULL DEFAULT "" AFTER planToBreastFeed;
UPDATE pregnancyLog
SET takingMedication2 = 'N'
WHERE takingMedication = 0;
UPDATE pregnancyLog
SET takingMedication2 = 'Y'
WHERE takingMedication = 1;
UPDATE pregnancyLog
SET planToBreastFeed2 = 'N'
WHERE planToBreastFeed = 0;
UPDATE pregnancyLog
SET planToBreastFeed2 = 'Y'
WHERE planToBreastFeed = 1;
ALTER TABLE pregnancyLog DROP COLUMN takingMedication;
ALTER TABLE pregnancyLog DROP COLUMN planToBreastFeed;
ALTER TABLE pregnancyLog CHANGE takingMedication2 takingMedication CHAR(1) NOT NULL DEFAULT "";
ALTER TABLE pregnancyLog CHANGE planToBreastFeed2 planToBreastFeed CHAR(1) NOT NULL DEFAULT "";