public static List<String> typesList() {
List<String> theList = new ArrayList<String>();
for (IdentityDocType type : all()) {
theList.add(type.identityDocTypeName);
}
return theList;
}
public static List<String> fioList() {
List<String> theList = new ArrayList<String>();
for (Doctor doctor : allDoctors()) {
theList.add(doctor.getFullName());
}
return theList;
}
public static Result start() {
java.util.Map<String, String[]> map = request().body().asFormUrlEncoded();
List<String> terms = new ArrayList<>(map.size());
for (int i = 0; i < map.size(); i++) {
String key = "terms[" + i + "]";
if (map.containsKey(key)) {
String[] values = map.get(key);
if ((values != null) && (values.length >= 1)) {
terms.add(values[0]);
}
}
}
StreamConfig config = getConfig();
config.putTerms(terms);
config.update();
StringBuilder sb = new StringBuilder();
for (String t : terms) {
sb.append(t);
sb.append(", ");
}
sb.delete(sb.length() - 2, sb.length());
try {
startStream(terms);
flash("success", "Twitter stream started (" + sb.toString() + ")");
} catch (TwitterException e) {
Logger.info("Error starting twitter stream", e);
flash("error", "Error starting Twitter stream" + e.getMessage());
}
return redirect(routes.Streams.listAll());
}
public static List<String> fioSQLListByType(String doctorTypeName) {
// TODO: check this statement at latest version of PostgreSQL
List<String> theList = new ArrayList<String>();
String sql =
"SELECT concat(surname, ' ', name, ' ', patronymic) as fio FROM DOCTOR LEFT JOIN DOCTOR_TYPE ON DOCTOR_TYPE.ID = DOCTOR.DOCTOR_TYPE_ID WHERE DOCTOR_TYPE_NAME=:DOCTOR_TYPE_NAME";
SqlQuery sqlQuery = Ebean.createSqlQuery(sql).setParameter("DOCTOR_TYPE_NAME", doctorTypeName);
List<SqlRow> rows = sqlQuery.findList();
// List<SqlRow> rows = Doctor.fioSQLListByType("Терапевт");
for (SqlRow row : rows) {
// Logger.info("row: "+ row);
theList.add(row.getString("fio"));
}
return theList;
}
// TODO: repair choosing doctor by typename
public static List<String> fioListByType(String doctorTypeName) {
/*String query = "find doctor fetch doctor_type.doctor_type_id";
List<Doctor> doctors = Ebean.find(Doctor.class)
.setQuery(query)
.setParameter("doctor_type_id", new Long(1))
.findList(); */
String sql =
"SELECT * FROM DOCTOR LEFT JOIN DOCTOR_TYPE ON DOCTOR_TYPE.ID = DOCTOR.DOCTOR_TYPE_ID";
SqlQuery sqlQuery = Ebean.createSqlQuery(sql);
List<SqlRow> list = sqlQuery.findList();
/*RawSql rawSql = RawSqlBuilder.parse(sql).create();
javax.persistence.Query<Doctor> query = Ebean.find(Doctor.class);
query.setRawSql(rawSql);
//.columnMapping("id", "doctor.id")
//.columnMapping("name", "doctor.name")
//.columnMapping("surname", "doctor.surname")
//.columnMapping("patronymic", "doctor.patronymic")
//.columnMapping("patronymic", "doctor_type.doctor_type_name");
List<Doctor> doctors = query.findList(); */
// List<Doctor> doctors = Ebean.find(Doctor.class)
// .fetch("doctor_type","doctor.doctor_type_id")
// .findList();
// List<Doctor> doctors = find.fetch("doctor_type")
// .where().eq("doctor.doctor_type_name", doctorTypeName)
// .findList();
/*com.avaje.ebean.Query q = Ebean.createQuery(Doctor.class);
q.join("doctor_type");
final List<Doctor> eventList = q.findList();*/
List<Doctor> doctors = find.where().eq("doctor_type_id", new Long(1)).findList();
List<String> theList = new ArrayList<String>();
for (Doctor doctor : doctors) {
theList.add(doctor.getFullName());
}
return theList;
}
