def create_test_uom():
records = [
{"doctype": "Lab Test UOM", "name": "umol/L", "test_uom": "umol/L", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "mg/L", "test_uom": "mg/L", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "mg / dl", "test_uom": "mg / dl", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "pg / ml", "test_uom": "pg / ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "U/ml", "test_uom": "U/ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "/HPF", "test_uom": "/HPF", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Million Cells / cumm", "test_uom": "Million Cells / cumm", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Lakhs Cells / cumm", "test_uom": "Lakhs Cells / cumm", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "U / L", "test_uom": "U / L", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "g / L", "test_uom": "g / L", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "IU / ml", "test_uom": "IU / ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "gm %", "test_uom": "gm %", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Microgram", "test_uom": "Microgram", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Micron", "test_uom": "Micron", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Cells / cumm", "test_uom": "Cells / cumm", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "%", "test_uom": "%", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "mm / dl", "test_uom": "mm / dl", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "mm / hr", "test_uom": "mm / hr", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "ulU / ml", "test_uom": "ulU / ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "ng / ml", "test_uom": "ng / ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "ng / dl", "test_uom": "ng / dl", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "ug / dl", "test_uom": "ug / dl", "uom_description": None }
]
insert_record(records)
def create_academic_sessions():
data = [{
"doctype": "Academic Year",
"academic_year_name": "2015-16"
}, {
"doctype": "Academic Year",
"academic_year_name": "2016-17"
}, {
"doctype": "Academic Year",
"academic_year_name": "2017-18"
}, {
"doctype": "Academic Year",
"academic_year_name": "2018-19"
}, {
"doctype": "Academic Term",
"academic_year": "2016-17",
"term_name": "Semester 1"
}, {
"doctype": "Academic Term",
"academic_year": "2016-17",
"term_name": "Semester 2"
}, {
"doctype": "Academic Term",
"academic_year": "2017-18",
"term_name": "Semester 1"
}, {
"doctype": "Academic Term",
"academic_year": "2017-18",
"term_name": "Semester 2"
}]
insert_record(data)
def create_duration():
records = [
{"doctype": "Prescription Duration", "name": "3 Month", "number": "3", "period": "Month" },
{"doctype": "Prescription Duration", "name": "2 Month", "number": "2", "period": "Month" },
{"doctype": "Prescription Duration", "name": "1 Month", "number": "1", "period": "Month" },
{"doctype": "Prescription Duration", "name": "12 Hour", "number": "12", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "11 Hour", "number": "11", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "10 Hour", "number": "10", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "9 Hour", "number": "9", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "8 Hour", "number": "8", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "7 Hour", "number": "7", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "6 Hour", "number": "6", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "5 Hour", "number": "5", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "4 Hour", "number": "4", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "3 Hour", "number": "3", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "2 Hour", "number": "2", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "1 Hour", "number": "1", "period": "Hour" },
{"doctype": "Prescription Duration", "name": "5 Week", "number": "5", "period": "Week" },
{"doctype": "Prescription Duration", "name": "4 Week", "number": "4", "period": "Week" },
{"doctype": "Prescription Duration", "name": "3 Week", "number": "3", "period": "Week" },
{"doctype": "Prescription Duration", "name": "2 Week", "number": "2", "period": "Week" },
{"doctype": "Prescription Duration", "name": "1 Week", "number": "1", "period": "Week" },
{"doctype": "Prescription Duration", "name": "6 Day", "number": "6", "period": "Day" },
{"doctype": "Prescription Duration", "name": "5 Day", "number": "5", "period": "Day" },
{"doctype": "Prescription Duration", "name": "4 Day", "number": "4", "period": "Day" },
{"doctype": "Prescription Duration", "name": "3 Day", "number": "3", "period": "Day" },
{"doctype": "Prescription Duration", "name": "2 Day", "number": "2", "period": "Day" },
{"doctype": "Prescription Duration", "name": "1 Day", "number": "1", "period": "Day" }
]
insert_record(records)
def create_duration():
records = [
{"doctype": "Prescription Duration", "name": "3 Month", "number": "3", "period": "Month"},
{"doctype": "Prescription Duration", "name": "2 Month", "number": "2", "period": "Month"},
{"doctype": "Prescription Duration", "name": "1 Month", "number": "1", "period": "Month"},
{"doctype": "Prescription Duration", "name": "12 Hour", "number": "12", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "11 Hour", "number": "11", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "10 Hour", "number": "10", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "9 Hour", "number": "9", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "8 Hour", "number": "8", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "7 Hour", "number": "7", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "6 Hour", "number": "6", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "5 Hour", "number": "5", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "4 Hour", "number": "4", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "3 Hour", "number": "3", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "2 Hour", "number": "2", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "1 Hour", "number": "1", "period": "Hour"},
{"doctype": "Prescription Duration", "name": "5 Week", "number": "5", "period": "Week"},
{"doctype": "Prescription Duration", "name": "4 Week", "number": "4", "period": "Week"},
{"doctype": "Prescription Duration", "name": "3 Week", "number": "3", "period": "Week"},
{"doctype": "Prescription Duration", "name": "2 Week", "number": "2", "period": "Week"},
{"doctype": "Prescription Duration", "name": "1 Week", "number": "1", "period": "Week"},
{"doctype": "Prescription Duration", "name": "6 Day", "number": "6", "period": "Day"},
{"doctype": "Prescription Duration", "name": "5 Day", "number": "5", "period": "Day"},
{"doctype": "Prescription Duration", "name": "4 Day", "number": "4", "period": "Day"},
{"doctype": "Prescription Duration", "name": "3 Day", "number": "3", "period": "Day"},
{"doctype": "Prescription Duration", "name": "2 Day", "number": "2", "period": "Day"},
{"doctype": "Prescription Duration", "name": "1 Day", "number": "1", "period": "Day"},
]
insert_record(records)
def add_healthcare_service_unit_tree_root():
record = [{
"doctype": "Healthcare Service Unit",
"healthcare_service_unit_name": "All Healthcare Service Units",
"is_group": 1
}]
insert_record(record)
def create_lab_test_uom():
records = [
{"doctype": "Lab Test UOM", "name": "umol/L", "lab_test_uom": "umol/L", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "mg/L", "lab_test_uom": "mg/L", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "mg / dl", "lab_test_uom": "mg / dl", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "pg / ml", "lab_test_uom": "pg / ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "U/ml", "lab_test_uom": "U/ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "/HPF", "lab_test_uom": "/HPF", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Million Cells / cumm", "lab_test_uom": "Million Cells / cumm", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Lakhs Cells / cumm", "lab_test_uom": "Lakhs Cells / cumm", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "U / L", "lab_test_uom": "U / L", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "g / L", "lab_test_uom": "g / L", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "IU / ml", "lab_test_uom": "IU / ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "gm %", "lab_test_uom": "gm %", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Microgram", "lab_test_uom": "Microgram", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Micron", "lab_test_uom": "Micron", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "Cells / cumm", "lab_test_uom": "Cells / cumm", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "%", "lab_test_uom": "%", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "mm / dl", "lab_test_uom": "mm / dl", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "mm / hr", "lab_test_uom": "mm / hr", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "ulU / ml", "lab_test_uom": "ulU / ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "ng / ml", "lab_test_uom": "ng / ml", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "ng / dl", "lab_test_uom": "ng / dl", "uom_description": None },
{"doctype": "Lab Test UOM", "name": "ug / dl", "lab_test_uom": "ug / dl", "uom_description": None }
]
insert_record(records)
def create_healthcare_item_groups():
records = [
{'doctype': 'Item Group', 'item_group_name': _('Laboratory'),
'is_group': 0, 'parent_item_group': _('All Item Groups') },
{'doctype': 'Item Group', 'item_group_name': _('Drug'),
'is_group': 0, 'parent_item_group': _('All Item Groups') }
]
insert_record(records)
def create_healthcare_item_groups():
records = [
{'doctype': 'Item Group', 'item_group_name': _('Laboratory'),
'is_group': 0, 'parent_item_group': _('All Item Groups')},
{'doctype': 'Item Group', 'item_group_name': _('Drug'),
'is_group': 0, 'parent_item_group': _('All Item Groups')}
]
insert_record(records)
def add_healthcare_service_unit_tree_root():
record = [
{
"doctype": "Healthcare Service Unit",
"healthcare_service_unit_name": "All Healthcare Service Units",
"is_group": 1
}
]
insert_record(record)
def create_sensitivity():
records = [
{"doctype": "Sensitivity", "sensitivity": _("Low Sensitivity")},
{"doctype": "Sensitivity", "sensitivity": _("High Sensitivity")},
{"doctype": "Sensitivity", "sensitivity": _("Moderate Sensitivity")},
{"doctype": "Sensitivity", "sensitivity": _("Susceptible")},
{"doctype": "Sensitivity", "sensitivity": _("Resistant")},
{"doctype": "Sensitivity", "sensitivity": _("Intermediate")}
]
insert_record(records)
def create_sensitivity():
records = [
{"doctype": "Sensitivity", "sensitivity": _("Low Sensitivity")},
{"doctype": "Sensitivity", "sensitivity": _("High Sensitivity")},
{"doctype": "Sensitivity", "sensitivity": _("Moderate Sensitivity")},
{"doctype": "Sensitivity", "sensitivity": _("Susceptible")},
{"doctype": "Sensitivity", "sensitivity": _("Resistant")},
{"doctype": "Sensitivity", "sensitivity": _("Intermediate")}
]
insert_record(records)
def create_academic_sessions():
data = [
{"doctype": "Academic Year", "academic_year_name": "2015-16"},
{"doctype": "Academic Year", "academic_year_name": "2016-17"},
{"doctype": "Academic Year", "academic_year_name": "2017-18"},
{"doctype": "Academic Year", "academic_year_name": "2018-19"},
{"doctype": "Academic Term", "academic_year": "2016-17", "term_name": "Semester 1"},
{"doctype": "Academic Term", "academic_year": "2016-17", "term_name": "Semester 2"},
{"doctype": "Academic Term", "academic_year": "2017-18", "term_name": "Semester 1"},
{"doctype": "Academic Term", "academic_year": "2017-18", "term_name": "Semester 2"}
]
insert_record(data)
def create_healthcare_item_groups():
records = [
{
"doctype": "Item Group",
"item_group_name": _("Laboratory"),
"is_group": 0,
"parent_item_group": _("All Item Groups"),
},
{
"doctype": "Item Group",
"item_group_name": _("Drug"),
"is_group": 0,
"parent_item_group": _("All Item Groups"),
},
]
insert_record(records)
def create_dosage():
records = [
{"doctype": "Prescription Dosage", "name": "1-1-1-1", "dosage": "1-1-1-1", "dosage_strength":
[{"strength": "1.0", "strength_time": "9:00:00"}, {"strength": "1.0", "strength_time": "13:00:00"}, {
"strength": "1.0", "strength_time": "17:00:00"}, {"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "0-0-1", "dosage": "0-0-1", "dosage_strength":
[{"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "1-0-0", "dosage": "1-0-0", "dosage_strength":
[{"strength": "1.0", "strength_time": "9:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "0-1-0", "dosage": "0-1-0", "dosage_strength":
[{"strength": "1.0", "strength_time": "14:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "1-1-1", "dosage": "1-1-1", "dosage_strength":
[{"strength": "1.0", "strength_time": "9:00:00"}, {"strength": "1.0",
"strength_time": "14:00:00"}, {"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "1-0-1", "dosage": "1-0-1", "dosage_strength":
[{"strength": "1.0", "strength_time": "9:00:00"}, {
"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "Once Bedtime", "dosage": "Once Bedtime", "dosage_strength":
[{"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "5 times a day", "dosage": "5 times a day", "dosage_strength":
[{"strength": "1.0", "strength_time": "5:00:00"}, {"strength": "1.0", "strength_time": "9:00:00"}, {"strength": "1.0",
"strength_time": "13:00:00"}, {"strength": "1.0", "strength_time": "17:00:00"}, {"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "QID", "dosage": "QID", "dosage_strength":
[{"strength": "1.0", "strength_time": "9:00:00"}, {"strength": "1.0", "strength_time": "13:00:00"}, {
"strength": "1.0", "strength_time": "17:00:00"}, {"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "TID", "dosage": "TID", "dosage_strength":
[{"strength": "1.0", "strength_time": "9:00:00"}, {"strength": "1.0",
"strength_time": "14:00:00"}, {"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "BID", "dosage": "BID", "dosage_strength":
[{"strength": "1.0", "strength_time": "9:00:00"}, {
"strength": "1.0", "strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "Once Daily", "dosage": "Once Daily", "dosage_strength":
[{"strength": "1.0", "strength_time": "9:00:00"}]
}
]
insert_record(records)
def create_lab_test_template():
records = [
{"doctype": "Lab Test Template", "name": "MCH","test_name": "MCH","test_code": "MCH",
"test_group": _("Laboratory"),"department": _("Haematology"),"item": "MCH",
"test_template_type": "Single","is_billable": 1,"test_rate": 0.0,"test_uom": "Microgram",
"test_normal_range": "27 - 32 Microgram",
"sensitivity": 0,"test_description": "Mean Corpuscular Hemoglobin"},
{"doctype": "Lab Test Template", "name": "LDL","test_name": "LDL (Serum)","test_code": "LDL",
"test_group": _("Laboratory"),"department": _("Biochemistry"),
"item": "LDL","test_template_type": "Single",
"is_billable": 1,"test_rate": 0.0,"test_uom": "mg / dl","test_normal_range": "70 - 160 mg/dlLow-density Lipoprotein (LDL)",
"sensitivity": 0,"test_description": "Low-density Lipoprotein (LDL)"},
{"doctype": "Lab Test Template", "name": "GTT","test_name": "GTT","test_code": "GTT",
"test_group": _("Laboratory"),"department": _("Haematology"),
"item": "GTT","test_template_type": "Single",
"is_billable": 1,"test_rate": 0.0,"test_uom": "mg / dl","test_normal_range": "Less than 85 mg/dl",
"sensitivity": 0,"test_description": "Glucose Tolerance Test"},
{"doctype": "Lab Test Template", "name": "HDL","test_name": "HDL (Serum)","test_code": "HDL",
"test_group": _("Laboratory"),"department": _("Biochemistry"),
"item": "HDL","test_template_type": "Single",
"is_billable": 1,"test_rate": 0.0,"test_uom": "mg / dl","test_normal_range": "35 - 65 mg/dl",
"sensitivity": 0,"test_description": "High-density Lipoprotein (HDL)"},
{"doctype": "Lab Test Template", "name": "BILT","test_name": "Bilirubin Total","test_code": "BILT",
"test_group": _("Laboratory"),"department": _("Biochemistry"),
"item": "BILT","test_template_type": "Single",
"is_billable": 1,"test_rate": 0.0,"test_uom": "mg / dl","test_normal_range": "0.2 - 1.2 mg / dl",
"sensitivity": 0,"test_description": "Bilirubin Total"},
{"doctype": "Lab Test Template", "name": "BILD","test_name": "Bilirubin Direct","test_code": "BILD",
"test_group": _("Laboratory"),"department": _("Biochemistry"),
"item": "BILD","test_template_type": "Single",
"is_billable": 1,"test_rate": 0.0,"test_uom": "mg / dl","test_normal_range": "0.4 mg / dl",
"sensitivity": 0,"test_description": "Bilirubin Direct"},
{"doctype": "Lab Test Template", "name": "BP","test_name": "Bile Pigment","test_code": "BP",
"test_group": _("Laboratory"),"department": _("Pathology"),
"item": "BP","test_template_type": "Single",
"is_billable": 1,"test_rate": 0.0,"test_uom": "","test_normal_range": "",
"sensitivity": 0,"test_description": "Bile Pigment"},
{"doctype": "Lab Test Template", "name": "BS","test_name": "Bile Salt","test_code": "BS",
"test_group": _("Laboratory"),"department": _("Pathology"),
"item": "BS","test_template_type": "Single",
"is_billable": 1,"test_rate": 0.0,"test_uom": "","test_normal_range": "",
"sensitivity": 0,"test_description": "Bile Salt"}
]
insert_record(records)
def create_lab_test_items():
records = [
{"doctype": "Item", "item_code": "MCH", "item_name": "MCH", "item_group": _("Laboratory"),
"stock_uom": _("Unit"), "is_stock_item": 0, "is_purchase_item": 0, "is_sales_item": 1},
{"doctype": "Item", "item_code": "LDL", "item_name": "LDL", "item_group": _("Laboratory"),
"stock_uom": _("Unit"), "is_stock_item": 0, "is_purchase_item": 0, "is_sales_item": 1},
{"doctype": "Item", "item_code": "GTT", "item_name": "GTT", "item_group": _("Laboratory"),
"stock_uom": _("Unit"), "is_stock_item": 0, "is_purchase_item": 0, "is_sales_item": 1},
{"doctype": "Item", "item_code": "HDL", "item_name": "HDL", "item_group": _("Laboratory"),
"stock_uom": _("Unit"), "is_stock_item": 0, "is_purchase_item": 0, "is_sales_item": 1},
{"doctype": "Item", "item_code": "BILT", "item_name": "BILT", "item_group": _("Laboratory"),
"stock_uom": _("Unit"), "is_stock_item": 0, "is_purchase_item": 0, "is_sales_item": 1},
{"doctype": "Item", "item_code": "BILD", "item_name": "BILD", "item_group": _("Laboratory"),
"stock_uom": _("Unit"), "is_stock_item": 0, "is_purchase_item": 0, "is_sales_item": 1},
{"doctype": "Item", "item_code": "BP", "item_name": "BP", "item_group": _("Laboratory"),
"stock_uom": _("Unit"), "is_stock_item": 0, "is_purchase_item": 0, "is_sales_item": 1},
{"doctype": "Item", "item_code": "BS", "item_name": "BS", "item_group": _("Laboratory"),
"stock_uom": _("Unit"), "is_stock_item": 0, "is_purchase_item": 0, "is_sales_item": 1}
]
insert_record(records)
def create_dosage():
records = [
{"doctype": "Prescription Dosage", "name": "1-1-1-1", "dosage": "1-1-1-1","dosage_strength":
[{"strength": "1.0","strength_time": "9:00:00"}, {"strength": "1.0","strength_time": "13:00:00"},{"strength": "1.0","strength_time": "17:00:00"},{"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "0-0-1", "dosage": "0-0-1","dosage_strength":
[{"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "1-0-0", "dosage": "1-0-0","dosage_strength":
[{"strength": "1.0","strength_time": "9:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "0-1-0", "dosage": "0-1-0","dosage_strength":
[{"strength": "1.0","strength_time": "14:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "1-1-1", "dosage": "1-1-1","dosage_strength":
[{"strength": "1.0","strength_time": "9:00:00"}, {"strength": "1.0","strength_time": "14:00:00"},{"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "1-0-1", "dosage": "1-0-1","dosage_strength":
[{"strength": "1.0","strength_time": "9:00:00"}, {"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "Once Bedtime", "dosage": "Once Bedtime","dosage_strength":
[{"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "5 times a day", "dosage": "5 times a day","dosage_strength":
[{"strength": "1.0","strength_time": "5:00:00"}, {"strength": "1.0","strength_time": "9:00:00"}, {"strength": "1.0","strength_time": "13:00:00"},{"strength": "1.0","strength_time": "17:00:00"},{"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "QID", "dosage": "QID","dosage_strength":
[{"strength": "1.0","strength_time": "9:00:00"}, {"strength": "1.0","strength_time": "13:00:00"},{"strength": "1.0","strength_time": "17:00:00"},{"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "TID", "dosage": "TID","dosage_strength":
[{"strength": "1.0","strength_time": "9:00:00"}, {"strength": "1.0","strength_time": "14:00:00"},{"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "BID", "dosage": "BID","dosage_strength":
[{"strength": "1.0","strength_time": "9:00:00"}, {"strength": "1.0","strength_time": "21:00:00"}]
},
{"doctype": "Prescription Dosage", "name": "Once Daily", "dosage": "Once Daily","dosage_strength":
[{"strength": "1.0","strength_time": "9:00:00"}]
}
]
insert_record(records)
def after_install():
forms = {
"Restaurant Room": dict(doc_type='Restaurant Object'),
"Restaurant Table": dict(doc_type='Restaurant Object'),
"Restaurant Production Center": dict(doc_type='Restaurant Object'),
"Restaurant Order": dict(doc_type='Table Order'),
"Order Item Note": dict(doc_type='Order Entry Item'),
"Customer Edit": dict(doc_type='Customer'),
"Payment Order": dict(doc_type='Table Order'),
}
for form in forms:
if frappe.db.count("CETI Form", {"route": to_route(form)}) == 0:
insert_record([
dict(
doctype="CETI Form",
doc_type=forms[form]["doc_type"],
title=form,
route=to_route(form),
is_standard=1,
published=1,
login_required=1,
allow_edit=1,
)
])
fields = [{
"name": "\"10f8717de4\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 8,
"fieldname": "section_break_10",
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"11556cdd28\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 6,
"fieldname": "column_break_4",
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"140da7de0e\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 4,
"fieldname": "section_break_2",
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"14444cfc7b\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 5,
"fieldname": "description",
"fieldtype": "Data",
"label": "Description",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"154459dd75\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 2,
"fieldname": "column_break_2",
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"1f208950c5\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 4,
"fieldname": None,
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"2008102660\"",
"creation": "2020-07-26 02:20:21.865901",
"modified": "2020-07-26 02:20:21.865901",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "customer-edit",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 4,
"fieldname": "salutation",
"fieldtype": "Link",
"label": "Salutation",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Salutation",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"29edd6e874\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 11,
"fieldname": "color",
"fieldtype": "Color",
"label": "Color",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"2a65925790\"",
"creation": "2020-07-26 02:20:21.865901",
"modified": "2020-07-26 02:20:21.865901",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "customer-edit",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 5,
"fieldname": "is_frozen",
"fieldtype": "Check",
"label": "Is Frozen",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": "0"
}, {
"name": "\"2b6bc5e29b\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 8,
"fieldname": None,
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"2b7f19f306\"",
"creation": "2020-07-26 02:20:21.914657",
"modified": "2020-07-26 02:20:21.914657",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-room",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 1,
"fieldname": "restaurant",
"fieldtype": "Link",
"label": "Restaurant",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Restaurant",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"34d2e9818f\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 10,
"fieldname": "column_break_8",
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"3bd2015379\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 7,
"fieldname": None,
"fieldtype": "HTML",
"label": "Num Pad",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"3da6bca99f\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 9,
"fieldname": None,
"fieldtype": "Currency",
"label": "Total Payment",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 1,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"3f381ba796\"",
"creation": "2020-07-26 02:20:21.962812",
"modified": "2020-07-26 02:20:21.962812",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "order-item-note",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 1,
"fieldname": "notes",
"fieldtype": "Text",
"label": "Notes",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"47ec1b6f4b\"",
"creation": "2020-07-26 02:20:21.865901",
"modified": "2020-07-26 02:20:21.865901",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "customer-edit",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 2,
"fieldname": "tax_id",
"fieldtype": "Data",
"label": "Tax ID",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"49efb44075\"",
"creation": "2020-07-26 02:20:22.115430",
"modified": "2020-07-26 02:20:22.115430",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 3,
"fieldname": "dinners",
"fieldtype": "Int",
"label": "Dinners",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"4ce3ef329b\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 13,
"fieldname": "amount",
"fieldtype": "Currency",
"label": "Amount",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 1,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"4d3700b543\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 2,
"fieldname": None,
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"54ea575355\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 10,
"fieldname": "section_break_12",
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"59dbe96de7\"",
"creation": "2020-07-26 02:20:22.115430",
"modified": "2020-07-26 02:20:22.115430",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 2,
"fieldname": None,
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"5d8d9e374b\"",
"creation": "2020-07-26 02:20:21.865901",
"modified": "2020-07-26 02:20:21.865901",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "customer-edit",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 1,
"fieldname": "customer_name",
"fieldtype": "Data",
"label": "Full Name",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"64d423e5ce\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 6,
"fieldname": "column_break_8",
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"6ce99fe2bf\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 11,
"fieldname": None,
"fieldtype": "Currency",
"label": "Change Amount",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 1,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"7a953266bc\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 1,
"fieldname": "type",
"fieldtype": "Select",
"label": "Type",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options":
"Room\nTable\nProduction Center\nTemporary Room\nDecorative",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"7cde57d087\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 3,
"fieldname": "room",
"fieldtype": "Link",
"label": "Room",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Restaurant Object",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"8c663028bf\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 8,
"fieldname": "section_break_6",
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"8db910a9df\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 3,
"fieldname": "room",
"fieldtype": "Link",
"label": "Room",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Restaurant Object",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"904b09fa0c\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 3,
"fieldname": None,
"fieldtype": "HTML",
"label": "Dinners Number",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"975f138388\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 15,
"fieldname": None,
"fieldtype": "HTML",
"label": "Payment Button",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"9904a6d2ca\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 2,
"fieldname": "column_break_2",
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"9a8e228917\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 6,
"fieldname": None,
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"9d99fc0d1b\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 5,
"fieldname": "no_of_seats",
"fieldtype": "Int",
"label": "No of Seats",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"a6690a925d\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 1,
"fieldname": "customer",
"fieldtype": "Link",
"label": "Customer",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Customer",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"a7f64072ed\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 12,
"fieldname": None,
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"ab319ac10f\"",
"creation": "2020-07-26 02:20:21.865901",
"modified": "2020-07-26 02:20:21.865901",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "customer-edit",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 3,
"fieldname": "credit_limits",
"fieldtype": "Table",
"label": "Credit Limit",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Customer Credit Limit",
"max_length": 0,
"max_value": 0,
"description": None,
"default": "0"
}, {
"name": "\"b2b23b396e\"",
"creation": "2020-07-26 02:20:21.914657",
"modified": "2020-07-26 02:20:21.914657",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-room",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 3,
"fieldname": "type",
"fieldtype": "Select",
"label": "Type",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options":
"Room\nTable\nProduction Center\nTemporary Room\nDecorative",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"b48b712ae4\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 5,
"fieldname": None,
"fieldtype": "HTML",
"label": "Payment Methods",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"bd67ef6b6a\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 7,
"fieldname": "minimum_seating",
"fieldtype": "Int",
"label": "Minimum Seating",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": "1"
}, {
"name": "\"c024414ff7\"",
"creation": "2020-07-26 02:20:21.914657",
"modified": "2020-07-26 02:20:21.914657",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-room",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 5,
"fieldname": "description",
"fieldtype": "Data",
"label": "Description",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"c66674ad38\"",
"creation": "2020-07-26 02:20:21.914657",
"modified": "2020-07-26 02:20:21.914657",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-room",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 2,
"fieldname": None,
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"ca190f61fb\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 14,
"fieldname": None,
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"cf0c848a33\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 9,
"fieldname": "description",
"fieldtype": "Data",
"label": "Description",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"d00aedf95c\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 4,
"fieldname": "section_break_2",
"fieldtype": "Section Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"d056ae6b28\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 9,
"fieldname": "status_managed",
"fieldtype": "Table",
"label": "Status Managed",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Status Managed Production Center",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"d74db69328\"",
"creation": "2020-07-26 02:20:22.115430",
"modified": "2020-07-26 02:20:22.115430",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 1,
"fieldname": "customer",
"fieldtype": "Link",
"label": "Customer",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Customer",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"de3749484e\"",
"creation": "2020-07-26 02:20:21.576334",
"modified": "2020-07-26 02:20:21.576334",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "payment-order",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 10,
"fieldname": None,
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"df042f17d2\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 7,
"fieldname": "color",
"fieldtype": "Color",
"label": "Color",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"fa67198cf4\"",
"creation": "2020-07-26 02:20:21.914657",
"modified": "2020-07-26 02:20:21.914657",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-room",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 4,
"fieldname": None,
"fieldtype": "Column Break",
"label": None,
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": None,
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"fbb8484e19\"",
"creation": "2020-07-26 02:20:22.006061",
"modified": "2020-07-26 02:20:22.006061",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-table",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 1,
"fieldname": "type",
"fieldtype": "Select",
"label": "Type",
"allow_read_on_all_link_options": 0,
"reqd": 1,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options":
"Room\nTable\nProduction Center\nTemporary Room\nDecorative",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}, {
"name": "\"ff9061396e\"",
"creation": "2020-07-26 02:20:22.059834",
"modified": "2020-07-26 02:20:22.059834",
"modified_by": "Administrator",
"owner": "Administrator",
"docstatus": 0,
"parent": "restaurant-production-center",
"parentfield": "ceti_form_fields",
"parenttype": "CETI Form",
"idx": 11,
"fieldname": "production_center_group",
"fieldtype": "Table",
"label": "Item Group",
"allow_read_on_all_link_options": 0,
"reqd": 0,
"depends_on": None,
"read_only": 0,
"show_in_filter": 0,
"hidden": 0,
"options": "Production Center Group",
"max_length": 0,
"max_value": 0,
"description": None,
"default": None
}]
for form in forms:
cf = frappe.get_doc("CETI Form", {"route": to_route(form)})
cf.ceti_form_fields = []
for f in fields:
field = f
if field["parent"] == to_route(form):
cf.append(
"ceti_form_fields",
dict(idx=field["idx"],
fieldname=field["fieldname"],
fieldtype=field["fieldtype"],
label=field["label"],
allow_read_on_all_link_options=1,
reqd=field["reqd"],
depends_on=field["depends_on"],
read_only=field["read_only"],
hidden=field["hidden"],
options=field["options"],
description=field["description"],
default=field["default"]))
cf.save()
def create_lab_test_template():
records = [{
"doctype": "Lab Test Template",
"name": "MCH",
"test_name": "MCH",
"test_code": "MCH",
"test_group": _("Laboratory"),
"department": _("Haematology"),
"item": "MCH",
"test_template_type": "Single",
"is_billable": 1,
"test_rate": 0.0,
"test_uom": "Microgram",
"test_normal_range": "27 - 32 Microgram",
"sensitivity": 0,
"test_description": "Mean Corpuscular Hemoglobin"
}, {
"doctype": "Lab Test Template",
"name": "LDL",
"test_name": "LDL (Serum)",
"test_code": "LDL",
"test_group": _("Laboratory"),
"department": _("Biochemistry"),
"item": "LDL",
"test_template_type": "Single",
"is_billable": 1,
"test_rate": 0.0,
"test_uom": "mg / dl",
"test_normal_range": "70 - 160 mg/dlLow-density Lipoprotein (LDL)",
"sensitivity": 0,
"test_description": "Low-density Lipoprotein (LDL)"
}, {
"doctype": "Lab Test Template",
"name": "GTT",
"test_name": "GTT",
"test_code": "GTT",
"test_group": _("Laboratory"),
"department": _("Haematology"),
"item": "GTT",
"test_template_type": "Single",
"is_billable": 1,
"test_rate": 0.0,
"test_uom": "mg / dl",
"test_normal_range": "Less than 85 mg/dl",
"sensitivity": 0,
"test_description": "Glucose Tolerance Test"
}, {
"doctype": "Lab Test Template",
"name": "HDL",
"test_name": "HDL (Serum)",
"test_code": "HDL",
"test_group": _("Laboratory"),
"department": _("Biochemistry"),
"item": "HDL",
"test_template_type": "Single",
"is_billable": 1,
"test_rate": 0.0,
"test_uom": "mg / dl",
"test_normal_range": "35 - 65 mg/dl",
"sensitivity": 0,
"test_description": "High-density Lipoprotein (HDL)"
}, {
"doctype": "Lab Test Template",
"name": "BILT",
"test_name": "Bilirubin Total",
"test_code": "BILT",
"test_group": _("Laboratory"),
"department": _("Biochemistry"),
"item": "BILT",
"test_template_type": "Single",
"is_billable": 1,
"test_rate": 0.0,
"test_uom": "mg / dl",
"test_normal_range": "0.2 - 1.2 mg / dl",
"sensitivity": 0,
"test_description": "Bilirubin Total"
}, {
"doctype": "Lab Test Template",
"name": "BILD",
"test_name": "Bilirubin Direct",
"test_code": "BILD",
"test_group": _("Laboratory"),
"department": _("Biochemistry"),
"item": "BILD",
"test_template_type": "Single",
"is_billable": 1,
"test_rate": 0.0,
"test_uom": "mg / dl",
"test_normal_range": "0.4 mg / dl",
"sensitivity": 0,
"test_description": "Bilirubin Direct"
}, {
"doctype": "Lab Test Template",
"name": "BP",
"test_name": "Bile Pigment",
"test_code": "BP",
"test_group": _("Laboratory"),
"department": _("Pathology"),
"item": "BP",
"test_template_type": "Single",
"is_billable": 1,
"test_rate": 0.0,
"test_uom": "",
"test_normal_range": "",
"sensitivity": 0,
"test_description": "Bile Pigment"
}, {
"doctype": "Lab Test Template",
"name": "BS",
"test_name": "Bile Salt",
"test_code": "BS",
"test_group": _("Laboratory"),
"department": _("Pathology"),
"item": "BS",
"test_template_type": "Single",
"is_billable": 1,
"test_rate": 0.0,
"test_uom": "",
"test_normal_range": "",
"sensitivity": 0,
"test_description": "Bile Salt"
}]
insert_record(records)
def create_agriculture_data():
records = [
dict(
doctype="Item Group",
item_group_name="Fertilizer",
is_group=0,
parent_item_group=_("All Item Groups"),
),
dict(doctype="Item Group",
item_group_name="Seed",
is_group=0,
parent_item_group=_("All Item Groups")),
dict(
doctype="Item Group",
item_group_name="By-product",
is_group=0,
parent_item_group=_("All Item Groups"),
),
dict(
doctype="Item Group",
item_group_name="Produce",
is_group=0,
parent_item_group=_("All Item Groups"),
),
dict(
doctype="Agriculture Analysis Criteria",
title="Nitrogen Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Phosphorous Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Potassium Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Calcium Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Sulphur Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Magnesium Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Iron Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Copper Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Zinc Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Boron Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Manganese Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Chlorine Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Molybdenum Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Sodium Content",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Humic Acid",
standard=1,
linked_doctype="Fertilizer",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Fulvic Acid",
standard=1,
linked_doctype="Fertilizer",
),
dict(doctype="Agriculture Analysis Criteria",
title="Inert",
standard=1,
linked_doctype="Fertilizer"),
dict(doctype="Agriculture Analysis Criteria",
title="Others",
standard=1,
linked_doctype="Fertilizer"),
dict(
doctype="Agriculture Analysis Criteria",
title="Nitrogen",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Phosphorous",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Potassium",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Calcium",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Magnesium",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Sulphur",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Boron",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Copper",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Iron",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Manganese",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Zinc",
standard=1,
linked_doctype="Plant Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Depth (in cm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Soil pH",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Salt Concentration (%)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Organic Matter (%)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="CEC (Cation Exchange Capacity) (MAQ/100mL)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Potassium Saturation (%)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Calcium Saturation (%)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Manganese Saturation (%)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Nirtogen (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Phosphorous (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Potassium (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Calcium (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Magnesium (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Sulphur (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Copper (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Iron (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Manganese (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Zinc (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Aluminium (ppm)",
standard=1,
linked_doctype="Soil Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Water pH",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Conductivity (mS/cm)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Hardness (mg/CaCO3)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Turbidity (NTU)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Odor",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Color",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Nitrate (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Nirtite (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Calcium (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Magnesium (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Sulphate (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Boron (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Copper (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Iron (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Manganese (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Zinc (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Chlorine (mg/L)",
standard=1,
linked_doctype="Water Analysis",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Bulk Density",
standard=1,
linked_doctype="Soil Texture",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Field Capacity",
standard=1,
linked_doctype="Soil Texture",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Wilting Point",
standard=1,
linked_doctype="Soil Texture",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Hydraulic Conductivity",
standard=1,
linked_doctype="Soil Texture",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Organic Matter",
standard=1,
linked_doctype="Soil Texture",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Temperature High",
standard=1,
linked_doctype="Weather",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Temperature Low",
standard=1,
linked_doctype="Weather",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Temperature Average",
standard=1,
linked_doctype="Weather",
),
dict(doctype="Agriculture Analysis Criteria",
title="Dew Point",
standard=1,
linked_doctype="Weather"),
dict(
doctype="Agriculture Analysis Criteria",
title="Precipitation Received",
standard=1,
linked_doctype="Weather",
),
dict(doctype="Agriculture Analysis Criteria",
title="Humidity",
standard=1,
linked_doctype="Weather"),
dict(doctype="Agriculture Analysis Criteria",
title="Pressure",
standard=1,
linked_doctype="Weather"),
dict(
doctype="Agriculture Analysis Criteria",
title="Insolation/ PAR (Photosynthetically Active Radiation)",
standard=1,
linked_doctype="Weather",
),
dict(
doctype="Agriculture Analysis Criteria",
title="Degree Days",
standard=1,
linked_doctype="Weather",
),
]
insert_record(records)
def create_agriculture_data():
records = [
dict(
doctype='Item Group',
item_group_name='Fertilizer',
is_group=0,
parent_item_group=_('All Item Groups')),
dict(
doctype='Item Group',
item_group_name='Seed',
is_group=0,
parent_item_group=_('All Item Groups')),
dict(
doctype='Item Group',
item_group_name='By-product',
is_group=0,
parent_item_group=_('All Item Groups')),
dict(
doctype='Item Group',
item_group_name='Produce',
is_group=0,
parent_item_group=_('All Item Groups')),
dict(
doctype='Agriculture Analysis Criteria',
title='Nitrogen Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Phosphorous Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Potassium Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Calcium Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Sulphur Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Magnesium Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Iron Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Copper Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Zinc Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Boron Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Manganese Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Chlorine Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Molybdenum Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Sodium Content',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Humic Acid',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Fulvic Acid',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Inert',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Others',
standard=1,
linked_doctype='Fertilizer'),
dict(
doctype='Agriculture Analysis Criteria',
title='Nitrogen',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Phosphorous',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Potassium',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Calcium',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Magnesium',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Sulphur',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Boron',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Copper',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Iron',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Manganese',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Zinc',
standard=1,
linked_doctype='Plant Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Depth (in cm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Soil pH',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Salt Concentration (%)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Organic Matter (%)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='CEC (Cation Exchange Capacity) (MAQ/100mL)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Potassium Saturation (%)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Calcium Saturation (%)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Manganese Saturation (%)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Nirtogen (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Phosphorous (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Potassium (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Calcium (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Magnesium (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Sulphur (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Copper (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Iron (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Manganese (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Zinc (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Aluminium (ppm)',
standard=1,
linked_doctype='Soil Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Water pH',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Conductivity (mS/cm)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Hardness (mg/CaCO3)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Turbidity (NTU)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Odor',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Color',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Nitrate (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Nirtite (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Calcium (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Magnesium (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Sulphate (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Boron (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Copper (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Iron (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Manganese (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Zinc (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Chlorine (mg/L)',
standard=1,
linked_doctype='Water Analysis'),
dict(
doctype='Agriculture Analysis Criteria',
title='Bulk Density',
standard=1,
linked_doctype='Soil Texture'),
dict(
doctype='Agriculture Analysis Criteria',
title='Field Capacity',
standard=1,
linked_doctype='Soil Texture'),
dict(
doctype='Agriculture Analysis Criteria',
title='Wilting Point',
standard=1,
linked_doctype='Soil Texture'),
dict(
doctype='Agriculture Analysis Criteria',
title='Hydraulic Conductivity',
standard=1,
linked_doctype='Soil Texture'),
dict(
doctype='Agriculture Analysis Criteria',
title='Organic Matter',
standard=1,
linked_doctype='Soil Texture'),
dict(
doctype='Agriculture Analysis Criteria',
title='Temperature High',
standard=1,
linked_doctype='Weather'),
dict(
doctype='Agriculture Analysis Criteria',
title='Temperature Low',
standard=1,
linked_doctype='Weather'),
dict(
doctype='Agriculture Analysis Criteria',
title='Temperature Average',
standard=1,
linked_doctype='Weather'),
dict(
doctype='Agriculture Analysis Criteria',
title='Dew Point',
standard=1,
linked_doctype='Weather'),
dict(
doctype='Agriculture Analysis Criteria',
title='Precipitation Received',
standard=1,
linked_doctype='Weather'),
dict(
doctype='Agriculture Analysis Criteria',
title='Humidity',
standard=1,
linked_doctype='Weather'),
dict(
doctype='Agriculture Analysis Criteria',
title='Pressure',
standard=1,
linked_doctype='Weather'),
dict(
doctype='Agriculture Analysis Criteria',
title='Insolation/ PAR (Photosynthetically Active Radiation)',
standard=1,
linked_doctype='Weather'),
dict(
doctype='Agriculture Analysis Criteria',
title='Degree Days',
standard=1,
linked_doctype='Weather')
]
insert_record(records)
def create_lab_test_items():
records = [{
"doctype": "Item",
"item_code": "MCH",
"item_name": "MCH",
"item_group": _("Laboratory"),
"stock_uom": _("Unit"),
"is_stock_item": 0,
"is_purchase_item": 0,
"is_sales_item": 1
}, {
"doctype": "Item",
"item_code": "LDL",
"item_name": "LDL",
"item_group": _("Laboratory"),
"stock_uom": _("Unit"),
"is_stock_item": 0,
"is_purchase_item": 0,
"is_sales_item": 1
}, {
"doctype": "Item",
"item_code": "GTT",
"item_name": "GTT",
"item_group": _("Laboratory"),
"stock_uom": _("Unit"),
"is_stock_item": 0,
"is_purchase_item": 0,
"is_sales_item": 1
}, {
"doctype": "Item",
"item_code": "HDL",
"item_name": "HDL",
"item_group": _("Laboratory"),
"stock_uom": _("Unit"),
"is_stock_item": 0,
"is_purchase_item": 0,
"is_sales_item": 1
}, {
"doctype": "Item",
"item_code": "BILT",
"item_name": "BILT",
"item_group": _("Laboratory"),
"stock_uom": _("Unit"),
"is_stock_item": 0,
"is_purchase_item": 0,
"is_sales_item": 1
}, {
"doctype": "Item",
"item_code": "BILD",
"item_name": "BILD",
"item_group": _("Laboratory"),
"stock_uom": _("Unit"),
"is_stock_item": 0,
"is_purchase_item": 0,
"is_sales_item": 1
}, {
"doctype": "Item",
"item_code": "BP",
"item_name": "BP",
"item_group": _("Laboratory"),
"stock_uom": _("Unit"),
"is_stock_item": 0,
"is_purchase_item": 0,
"is_sales_item": 1
}, {
"doctype": "Item",
"item_code": "BS",
"item_name": "BS",
"item_group": _("Laboratory"),
"stock_uom": _("Unit"),
"is_stock_item": 0,
"is_purchase_item": 0,
"is_sales_item": 1
}]
insert_record(records)