def gooboard_patients():
colNames = [
"ClinicDate", "IsDirect", "IsScreened", "ScreenDate", "IsSurgical",
"AppropriatenessScore", "ComplexityScore", "ValueScore", "Location",
"Diagnosis", "ReferringDoctor", "Practice", "Insurance", "IsMedicaid"
]
filehand = "ServerDatafiles/mainSelect.sql"
allPatients_googleData = surgDB.getGoogleFormattedData(filehand, colNames)
return jsonify(allPatients_googleData)
def gooboard_patientCount():
startDate = ""
endDate = ""
colNames = ["NumPatients"]
filehand = "ServerDatafiles/overallPatientCount.sql"
#print('Start Date: ' + startDate)
#print('End Date: ' + endDate)
print(request.args['startDate'])
print(request.args['endDate'])
allPatients_googleData = surgDB.getGoogleFormattedData(filehand, colNames)
return jsonify(allPatients_googleData)
def gooboard_DateVSurg():
colNames = ["ClinicMonth", "NumSurgeries", "NumNonSurgeries"]
filehand = "ServerDatafiles/totalsSurgByDate.sql"
allPatients_googleData = surgDB.getGoogleFormattedData(filehand, colNames)
return jsonify(allPatients_googleData)
def gooboard_surgRatio():
colNames = ["isSurgical", "NumPatients"]
filehand = "ServerDatafiles/SurgicalRatio.sql"
allPatients_googleData = surgDB.getGoogleFormattedData(filehand, colNames)
return jsonify(allPatients_googleData)
def gooboard_insuranceCount():
colNames = ["NumInsurances"]
filehand = "ServerDatafiles/overallInsurancesCount.sql"
allPatients_googleData = surgDB.getGoogleFormattedData(filehand, colNames)
return jsonify(allPatients_googleData)
def gooboard_refDocCount():
colNames = ["NumRefDocs"]
filehand = "ServerDatafiles/overallRefDocsCount.sql"
allPatients_googleData = surgDB.getGoogleFormattedData(filehand, colNames)
return jsonify(allPatients_googleData)
def gooboard_PracVSurg():
colNames = ["Practice", "NumSurgeries", "NumNonSurgeries"]
filehand = "ServerDatafiles/totalsSurgByPractice.sql"
allPatients_googleData = surgDB.getGoogleFormattedData(filehand, colNames)
return jsonify(allPatients_googleData)