Development Layout Based Visit Form

robert.down · June 2, 2017, 11:58pm

Here is a SQL file which will add a new Layout Based Visit form that contains one of every datatype. I had to make it to work on the bootstrap conversion and thought it may be useful.

gist.github.com

https://gist.github.com/robertdown/17e548c595bbd116ae6ce69f79bb06d9

test_form_every_datatype.sql

# Will need to change the datababase name if needed
INSERT INTO openemr.list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype, edit_options, timestamp) VALUES ('lbfnames', 'LBFfull_lbv_form', 'Full LBV Form', 0, 0, 0, '', '{}', '', 0, 0, 1, '', 1, '2017-06-02 17:43:59');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Allergies', '2Group 2', 'Allergies', 140, 24, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'BillingCodes', '2Group 2', 'Billing Codes', 80, 15, 1, 20, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Checkbox', '2Group 2', 'Checkbox', 110, 21, 1, 1, 0, 'yesno', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'chk_with_text', '2Group 2', 'Checkbox with text', 150, 25, 1, 20, 0, 'boolean', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'ExamResults', '2Group 2', 'Exam Results', 130, 23, 1, 20, 0, 'reaction', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Facilities', '2Group 2', 'Facilities', 230, 35, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'image', '2Group 2', 'Image Canvas', 250, 40, 1, 20, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');
INSERT INTO openemr.layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows, list_backup_id, source, conditions, validation) VALUES ('LBFfull_lbv_form', 'Insurances', '2Group 2', 'Insurances', 90, 16, 1, 0, 0, '', 1, 1, '', '', '', 0, '', 'F', '', '');

This file has been truncated. show original