org.semanticwb.portal.db.SWBRecHits Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of SWBPortal Show documentation
Show all versions of SWBPortal Show documentation
SemanticWebBuilder Portal API components and utilities
The newest version!
/*
* SemanticWebBuilder es una plataforma para el desarrollo de portales y aplicaciones de integración,
* colaboración y conocimiento, que gracias al uso de tecnología semántica puede generar contextos de
* información alrededor de algún tema de interés o bien integrar información y aplicaciones de diferentes
* fuentes, donde a la información se le asigna un significado, de forma que pueda ser interpretada y
* procesada por personas y/o sistemas, es una creación original del Fondo de Información y Documentación
* para la Industria INFOTEC, cuyo registro se encuentra actualmente en trámite.
*
* INFOTEC pone a su disposición la herramienta SemanticWebBuilder a través de su licenciamiento abierto al público (‘open source’),
* en virtud del cual, usted podrá usarlo en las mismas condiciones con que INFOTEC lo ha diseñado y puesto a su disposición;
* aprender de él; distribuirlo a terceros; acceder a su código fuente y modificarlo, y combinarlo o enlazarlo con otro software,
* todo ello de conformidad con los términos y condiciones de la LICENCIA ABIERTA AL PÚBLICO que otorga INFOTEC para la utilización
* del SemanticWebBuilder 4.0.
*
* INFOTEC no otorga garantía sobre SemanticWebBuilder, de ninguna especie y naturaleza, ni implícita ni explícita,
* siendo usted completamente responsable de la utilización que le dé y asumiendo la totalidad de los riesgos que puedan derivar
* de la misma.
*
* Si usted tiene cualquier duda o comentario sobre SemanticWebBuilder, INFOTEC pone a su disposición la siguiente
* dirección electrónica:
* http://www.semanticwebbuilder.org
*/
package org.semanticwb.portal.db;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.GregorianCalendar;
import java.util.Iterator;
import java.util.List;
import org.semanticwb.Logger;
import org.semanticwb.SWBUtils;
import org.semanticwb.model.SWBContext;
// TODO: Auto-generated Javadoc
/** Objeto: Almacena resumenes de hits diarios:
*
* Se tienen 6 tipos de reportes diarios con la siguiente informacion:
*
* ---------- date, hits_modelid, hits_objid, hits, hits_type --------------------
*
* tipo
* 0 registro diario global, hits_objid=_
* 1 registro diario por dispositivo, hits_objid=disp, ejemplo: web
* 2 registro diario por lenguaje, hits_objid=lang, ejemplo: en
* 3 registro diario por topico hits_objid=topicid, ejemplo: Egobierno
* 4 registro diario por tipousu hits_objid=tipousu, ejemplo: estudiante, si es nulo=_
* 5 registro diario num sesiones hits_modelid=repid hits_objid=_
* 6 registro diario login hits_modelid=repid hits_objid=_
* 7 registro diario login unicos hits_modelid=repid hits_objid=_
*
* Object: It stores daily summaries of hits:
*
* 6 types of daily reports with the following information are had.
*
*
*
* @author Javier Solis Gonzalez
* @version 1.1
*/
public class SWBRecHits //implements AFAppObject, AFObserver
{
/** The log. */
private static Logger log = SWBUtils.getLogger(SWBRecHits.class);
/** The instance. */
static private SWBRecHits instance;
/**
* Instantiates a new sWB rec hits.
*/
private SWBRecHits() {
}
/**
* Destroy.
*/
public void destroy() {
instance=null;
}
/**
* Gets the single instance of SWBRecHits.
*
* @return single instance of SWBRecHits
*/
static synchronized public SWBRecHits getInstance() {
if (instance == null) {
instance = new SWBRecHits();
instance.init();
}
return instance;
}
/**
* Inits the.
*/
public void init() {
}
/**
* Gets the res global hits log.
*
* @param hits_modelid the hits_modelid
* @return the res global hits log
*/
public Iterator getResGlobalHitsLog(String hits_modelid) {
Iterator ret = new ArrayList().iterator();
// Connection con = SWBUtils.DB.getDefaultConnection();
// if (con != null)
// {
// try
// {
// String query = "select * from swb_reshits where hits_modelid=? and hits_type=0";
// PreparedStatement st = con.prepareStatement(query);
// st.setString(1, hits_modelid);
// ResultSet rs = st.executeQuery();
// ret = new IterResHits(con, st, rs);
// } catch (Exception e)
// {
// log.error("Error DBResHits_getResGlobalHitsLog_getLogerror", e);
// }
// } else
// {
// //tira una exception
// }
return ret;
}
/**
* Gets the res hits log.
*
* @param modelid the modelid
* @param objid the objid
* @param type the type
* @return the res hits log
* @return
*/
public List getResHitsLog(String modelid, String objid, int type) {
List resumeRecHits = new ArrayList();
StringBuilder query = new StringBuilder();
Connection con = SWBUtils.DB.getDefaultConnection();
if(con != null) {
try {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_type=?");
if(objid != null) {
query.append(" and hits_objid=?");
}
query.append(" order by hits_date");
PreparedStatement st = con.prepareStatement(query.toString());
st.setString(1, modelid);
st.setInt(2, type);
if(objid != null) {
st.setString(3, objid);
}
ResultSet rs = st.executeQuery();
SWBRecHit detail;
while(rs.next()) {
detail = new SWBRecHit(rs.getTimestamp("hits_date"),rs.getString("hits_modelid"),rs.getString("hits_objid"),rs.getInt("hits_type"),rs.getLong("hits"));
resumeRecHits.add(detail);
}
}catch (Exception e) {
log.error("Error DBResHits_getResHitsLog_getLogError", e);
}finally {
try {
if(con!=null){ con.close();}
}catch(SQLException e) {
}
}
}else {
//tira una exception
}
return resumeRecHits;
}
/**
* Gets the res hits log.
*
* @param modelid the modelid
* @param type the type
* @return the res hits log
* @return
*/
public Iterator getResHitsLog(String modelid, int type) {
Iterator ret = new ArrayList().iterator();
// Connection con = SWBUtils.DB.getDefaultConnection();
// if (con != null) {
// try {
// String query = "select hits_date,hits_modelid,hits_objid, sum(hits) hits,hits_type from swb_reshits where hits_modelid=? and hits_type=? group by hits_objid order by hits_date";
// PreparedStatement st = con.prepareStatement(query);
// st.setString(1, hits_modelid);
// st.setInt(2, hits_type);
// ResultSet rs = st.executeQuery();
// ret = new IterResHits(con, st, rs);
// }catch (Exception e) {
// log.error("Error DBResHits_getResHitsLog_getLogError", e);
// }finally {
// try {
// if(con!=null){ con.close();}
// }catch(SQLException e) {
// }
// }
// }else {
// //tira una exception
// }
return ret;
}
/**
* Gets the res hits log.
*
* @param modelid the modelid
* @param objid the objid
* @param type the type
* @param year the year
* @param month the month
* @param day the day
* @return the res hits log
* @return
*/
public List getResHitsLog(String modelid, String objid, int type, int year, int month, int day) {
List resumeRecHits = new ArrayList();
StringBuilder query = new StringBuilder();
Timestamp fecha = null;
Timestamp fecha2 = null;
PreparedStatement st = null;
ResultSet rs = null;
GregorianCalendar date;
if(year > 0) {
if(month > 0) {
if(day > 0) {
//para cuando envian year,month y day
date = new GregorianCalendar(year,month-1,day,0,0,0);
fecha = new Timestamp(date.getTimeInMillis());
date = new GregorianCalendar(year,month-1,day,23,59,59);
fecha2 = new Timestamp(date.getTimeInMillis());
}
if(fecha == null) {
//para cuando envian year y month
date = new GregorianCalendar(year,month-1,1,0,0,0);
fecha = new Timestamp(date.getTimeInMillis());
date = new GregorianCalendar(year,month,1,0,0,0);
fecha2 = new Timestamp(date.getTimeInMillis());
}
}
if(fecha == null) {
//para cuando envian solamente year
date = new GregorianCalendar(year,0,1,0,0,0);
fecha = new Timestamp(date.getTimeInMillis());
date = new GregorianCalendar(year+1,0,1,0,0,0);
fecha2 = new Timestamp(date.getTimeInMillis());
}
}
Connection con = SWBUtils.DB.getDefaultConnection();
if (con != null) {
try {
if(objid != null) {
if (year > 0 && month > 0 && day > 0) {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_objid=? and hits_type=? and (hits_date>=? and hits_date<=?) order by hits_date");
}else {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_objid=? and hits_type=? and (hits_date>=? and hits_date 0 && month > 0 && day > 0) {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_type=? and (hits_date>=? and hits_date<=?) order by hits_date");
}else {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_type=? and (hits_date>=? and hits_date=? and hits_date<=?)");
if(objid != null) {
query.append(" and hits_objid=?");
}
query.append(" order by hits_date");
st = con.prepareStatement(query.toString());
st.setString(1, modelid);
st.setInt(2, type);
date = new GregorianCalendar(year1, month1-1, day1, 0, 0, 0);
st.setTimestamp(3, new Timestamp(date.getTimeInMillis()));
date = new GregorianCalendar(year2, month2-1, day2, 23, 59, 59);
st.setTimestamp(4, new Timestamp(date.getTimeInMillis()));
if(objid != null) {
st.setString(5, objid);
}
rs = st.executeQuery();
SWBRecHit detail;
rs = st.executeQuery();
while(rs.next()){
detail = new SWBRecHit(rs.getTimestamp("hits_date"),rs.getString("hits_modelid"),rs.getString("hits_objid"),rs.getInt("hits_type"),rs.getLong("hits"));
resumeRecHits.add(detail);
}
}catch (Exception e) {
log.error("Error DBResHits_getResHitsLog_getLogError", e);
}finally {
try {
if(con!=null){ con.close();}
}catch(SQLException e){
}
}
}else {
//tira una exception
}
return resumeRecHits;
}
/**
* Gets the res hits log.
*
* @param modelid the modelid
* @param type the type
* @param year1 the year1
* @param month1 the month1
* @param day1 the day1
* @param year2 the year2
* @param month2 the month2
* @param day2 the day2
* @return the res hits log
* @return
*/
public Iterator getResHitsLog(String modelid, int type, int year1, int month1, int day1, int year2, int month2, int day2) {
Timestamp fecha = null;
Timestamp fecha2 = null;
/*fecha = new Timestamp(year1 - 1900, month1 - 1, day1, 00, 00, 00, 00);
fecha2 = new Timestamp(year2 - 1900, month2 - 1, day2, 00, 00, 00, 00);*/
Iterator ret = new ArrayList().iterator();
// Connection con = SWBUtils.DB.getDefaultConnection();
// if(con != null) {
// try {
// String query = "select hits_date,hits_modelid,hits_objid, sum(hits) hits,hits_type from swb_reshits where hits_modelid=? and hits_type=? and (hits_date>=? and hits_date<=?) group by hits_objid order by hits_date";
// PreparedStatement st = con.prepareStatement(query);
// st.setString(1, hits_modelid);
// st.setInt(2, hits_type);
// st.setTimestamp(3, fecha);
// st.setTimestamp(4, fecha2);
// ResultSet rs = st.executeQuery();
// ret = new IterResHits(con, st, rs);
// }catch (Exception e) {
// log.error("Error DBResHits_getResHitsLog_getLogError", e);
// }finally {
// try {
// if(con!=null){ con.close();}
// }catch(SQLException e){
// }
// }
// }else {
// //tira una exception
// }
return ret;
}
/**
* Refresh.
*/
public void refresh() {
}
/**
* Avisa al observador de que se ha producido un cambio.
*
* @param s the s
* @param obj the obj
*/
public void sendDBNotify(String s, Object obj) {
if (s.equals("remove")) {
}
if (s.equals("create")) {
}
}
/**
* Gets the res hits log.
*
* @param modelid the modelid
* @param objid the objid
* @param type the type
* @param year the year
* @return the res hits log
* @return
*/
public List getResHitsLog(String modelid, String objid, int type, int year) {
List resumeRecHits = new ArrayList();
PreparedStatement st = null;
ResultSet rs = null;
int mi=0, mf=0;
if (year > 0) {
GregorianCalendar gcf = new GregorianCalendar();
gcf.set(GregorianCalendar.YEAR, year);
mi = gcf.getActualMinimum(GregorianCalendar.MONTH);
mf = gcf.getActualMaximum(GregorianCalendar.MONTH);
}
Connection con = SWBUtils.DB.getDefaultConnection();
if(con != null) {
try {
GregorianCalendar date;
if(objid != null) {
String query = "select hits_modelid,hits_objid,hits_type,sum(hits) as hits from swb_reshits where hits_modelid=? and hits_objid=? and hits_type=? and (hits_date>=? and hits_date=? and hits_date 0) {
GregorianCalendar gcf = new GregorianCalendar();
gcf.set(GregorianCalendar.YEAR, year);
mi = gcf.getActualMinimum(GregorianCalendar.MONTH);
mf = gcf.getActualMaximum(GregorianCalendar.MONTH);
}
Connection con = SWBUtils.DB.getDefaultConnection();
if(con != null) {
try {
GregorianCalendar date;
if(objid != null) {
String query = "select hits_modelid,hits_objid,hits_type,sum(hits) as hits from swb_reshits where hits_modelid=? and hits_objid=? and hits_type=? and (hits_date>=? and hits_date=? and hits_date=? and hits_date<=?) order by hits_date");
st = con.prepareStatement(query.toString());
st.setString(1, modelid);
st.setString(2, objid);
st.setInt(3, type);
date = new GregorianCalendar(year,month-1,day,0,0,0);
st.setTimestamp(4, new Timestamp(date.getTimeInMillis()));
date = new GregorianCalendar(year,month-1,day,23,59,59);
st.setTimestamp(5, new Timestamp(date.getTimeInMillis()));
}else {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_type=? and (hits_date>=? and hits_date<=?) order by hits_date");
st = con.prepareStatement(query.toString());
st.setString(1, modelid);
st.setInt(2, type);
date = new GregorianCalendar(year,month-1,day,0,0,0);
st.setTimestamp(3, new Timestamp(date.getTimeInMillis()));
date = new GregorianCalendar(year,month-1,day,23,59,59);
st.setTimestamp(4, new Timestamp(date.getTimeInMillis()));
}
if(st != null) {
rs = st.executeQuery();
SWBRecHit detail;
while(rs.next()) {
detail = new SWBRecHit(rs.getTimestamp("hits_date"),rs.getString("hits_modelid"),rs.getString("hits_objid"),rs.getInt("hits_type"),rs.getLong("hits"));
detail.setItem(item);
resumeRecHits.add(detail);
}
}
}catch (Exception e) {
log.error("Error DBResHits_getResHitsLog_getLogError", e);
}finally {
try {
if(con!=null){ con.close();}
}catch(SQLException e){
}
}
}else {
//tira una exception
}
return resumeRecHits;
}
/**
* Gets the res hits log.
*
* @param modelid the modelid
* @param objid the objid
* @param type the type
* @param year1 the year1
* @param month1 the month1
* @param day1 the day1
* @param year2 the year2
* @param month2 the month2
* @param day2 the day2
* @param item the item
* @return the res hits log
* @return
*/
public List getResHitsLog(String modelid, String objid, int type, int year1, int month1, int day1, int year2, int month2, int day2, String item) {
List resumeRecHits = new ArrayList();
StringBuilder query = new StringBuilder();
ResultSet rs = null;
PreparedStatement st = null;
Connection con = SWBUtils.DB.getDefaultConnection();
if(con != null) {
try {
GregorianCalendar date;
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_type=? and (hits_date>=? and hits_date<=?)");
if(objid != null) {
query.append(" and hits_objid=?");
}
query.append(" order by hits_date");
st = con.prepareStatement(query.toString());
st.setString(1, modelid);
st.setInt(2, type);
date = new GregorianCalendar(year1, month1-1, day1, 0, 0, 0);
st.setTimestamp(3, new Timestamp(date.getTimeInMillis()));
date = new GregorianCalendar(year2, month2-1, day2, 23, 59, 59);
st.setTimestamp(4, new Timestamp(date.getTimeInMillis()));
if(objid != null) {
st.setString(5, objid);
}
SWBRecHit detail;
rs = st.executeQuery();
while(rs.next()) {
detail = new SWBRecHit(rs.getTimestamp("hits_date"),rs.getString("hits_modelid"),rs.getString("hits_objid"),rs.getInt("hits_type"),rs.getLong("hits"));
detail.setItem(rs.getString("hits_objid"));
resumeRecHits.add(detail);
}
}catch (Exception e) {
log.error("Error DBResHits_getResHitsLog_getLogError", e);
}finally {
try {
if(con!=null){ con.close();}
}catch(SQLException e){
}
}
}else {
//tira una exception
}
return resumeRecHits;
}
/**
* Gets the res hits log.
*
* @param modelid the modelid
* @param objid the objid
* @param type the type
* @param item the item
* @param iditem the iditem
* @return the res hits log
*/
public List getResHitsLog(String modelid, String objid, int type, String item, int iditem) {
List resumeRecHits = new ArrayList();
StringBuilder query = new StringBuilder();
Connection con = SWBUtils.DB.getDefaultConnection();
if(con != null) {
try {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_type=?");
if(objid != null) {
query.append(" and hits_objid=?");
}
query.append(" order by hits_date");
PreparedStatement st = con.prepareStatement(query.toString());
st.setString(1, modelid);
st.setInt(2, type);
if(objid != null) {
st.setString(3, objid);
}
ResultSet rs = st.executeQuery();
SWBRecHit detail;
while(rs.next()){
detail = new SWBRecHit(rs.getTimestamp("hits_date"),rs.getString("hits_modelid"),rs.getString("hits_objid"),rs.getInt("hits_type"),rs.getLong("hits"));
detail.setItem(item);
detail.setIditem(iditem);
resumeRecHits.add(detail);
}
}catch (Exception e) {
log.error("Error DBResHits_getResHitsLog_getLogError", e);
}finally {
try {
if(con!=null){ con.close();}
}catch(SQLException e){
}
}
}else {
//tira una exception
}
return resumeRecHits;
}
/**
* Gets the res hits log.
*
* @param modelid the modelid
* @param objid the objid
* @param type the type
* @param year the year
* @param item the item
* @param iditem the iditem
* @return the res hits log
*/
public List getResHitsLog(String modelid, String objid, int type, int year, String item, int iditem) {
List resumeRecHits = new ArrayList();
PreparedStatement st = null;
ResultSet rs = null;
int mi=0, mf=0;
if(year > 0) {
GregorianCalendar gcf = new GregorianCalendar();
gcf.set(GregorianCalendar.YEAR, year);
mi = gcf.getActualMinimum(GregorianCalendar.MONTH);
mf = gcf.getActualMaximum(GregorianCalendar.MONTH);
}
Connection con = SWBUtils.DB.getDefaultConnection();
if(con != null) {
try {
GregorianCalendar date;
if(objid != null) {
String query = "select hits_modelid,hits_objid,hits_type,sum(hits) as hits from swb_reshits where hits_modelid=? and hits_objid=? and hits_type=? and (hits_date>=? and hits_date=? and hits_date 0) {
if(month > 0) {
if(day > 0) {
//para cuando envian year,month y day
date = new GregorianCalendar(year,month-1,day,0,0,0);
fecha = new Timestamp(date.getTimeInMillis());
date = new GregorianCalendar(year,month-1,day,23,59,59);
fecha2 = new Timestamp(date.getTimeInMillis());
}
if(fecha == null) {
//para cuando envian year y month
date = new GregorianCalendar(year,month-1,1,0,0,0);
fecha = new Timestamp(date.getTimeInMillis());
date = new GregorianCalendar(year,month,1,0,0,0);
fecha2 = new Timestamp(date.getTimeInMillis());
}
}
if(fecha == null) {
//para cuando envian solamente year
date = new GregorianCalendar(year,0,1,0,0,0);
fecha = new Timestamp(date.getTimeInMillis());
date = new GregorianCalendar(year+1,0,1,0,0,0);
fecha2 = new Timestamp(date.getTimeInMillis());
}
}else {
date = new GregorianCalendar(2000,0,1,0,0,0);
fecha = new Timestamp(date.getTimeInMillis());
date = new GregorianCalendar(2022,0,1,0,0,0);
fecha2 = new Timestamp(date.getTimeInMillis());
}
Connection con = SWBUtils.DB.getDefaultConnection();
if (con != null) {
try {
if(objid != null) {
if(year > 0 && month > 0 && day > 0) {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_objid=? and hits_type=? and (hits_date>=? and hits_date<=?) order by hits_date");
}else {
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_objid=? and hits_type=? and (hits_date>=? and hits_date 0 && month > 0 && day > 0)
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_type=? and (hits_date>=? and hits_date<=?) order by hits_date");
else
query.append("select hits_date,hits_modelid,hits_objid,hits_type,hits from swb_reshits where hits_modelid=? and hits_type=? and (hits_date>=? and hits_date=? and hits_date<=?)");
if(objid != null) {
query.append(" and hits_objid=?");
}
query.append(" order by hits_date");
st = con.prepareStatement(query.toString());
st.setString(1, modelid);
st.setInt(2, type);
date = new GregorianCalendar(year1, month1-1, day1, 0, 0, 0);
st.setTimestamp(3, new Timestamp(date.getTimeInMillis()));
date = new GregorianCalendar(year2, month2-1, day2, 23, 59, 59);
st.setTimestamp(4, new Timestamp(date.getTimeInMillis()));
if(objid != null)
st.setString(5, objid);
SWBRecHit detail;
rs = st.executeQuery();
while(rs.next()){
detail = new SWBRecHit(rs.getTimestamp("hits_date"),rs.getString("hits_modelid"),rs.getString("hits_objid"),rs.getInt("hits_type"),rs.getLong("hits"));
detail.setItem(item);
detail.setIditem(iditem);
resumeRecHits.add(detail);
}
}catch (Exception e) {
log.error("Error DBResHits_getResHitsLog_getLogError", e);
}finally {
try {
if(con!=null) con.close();
}catch(SQLException e){
}
}
}else {
//tira una exception
}
return resumeRecHits;
}
}