public DataPoint[] GeraGraficoEstudoMes(String Situacao, String idTema){
int i=0;
String wSql = " SELECT strftime(''%d'',data) AS DIA, Count(1) AS TOTAL_ACERTO FROM CRTGRAFICOESTUDO " +
" WHERE ACERTOU='" + Situacao + "'" +
" AND strftime(''%Y'',data)=strftime(''%Y'',''now'') " +
" AND strftime(''%m'',data)=strftime(''%m'',''now'') ";
if (!idTema.isEmpty()) {
wSql = wSql + " AND TAB_TEMA_ID=" + idTema;
}
wSql = wSql + " GROUP BY strftime(''%d'',data) ";
wSql = wSql + " ORDER BY strftime(''%d'',data) ";
openDataBase();
Cursor cs = mSQSqLiteDatabase.rawQuery(wSql, null);
DataPoint[] points = new DataPoint[cs.getCount()];
if (cs.getCount() > 0) {
if (cs.moveToFirst()) {
while (!cs.isAfterLast()) {
points[i] = new DataPoint(cs.getInt(0), cs.getInt(1));
cs.moveToNext();
}
}
}
cs.close();
closeDataBase();
return points;
}
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.