@Override
public void prepare() throws Exception {
user = (Users) this.getSession().get(APConstants.SESSION_USER);
idEntSystem = UsersDao.getEntitySystem(user.getIdUsr());
usrDao = new UsersDao();
idUsrSystem = user.getIdUsr();
}
@Override
public void prepare() throws Exception {
user = (Users) ActionContext.getContext().getSession().get(APConstants.SESSION_USER);
// user = (Users) this.getSession().get(APConstants.SESSION_USER);
idEntSystem = UsersDao.getEntitySystem(user.getIdUsr());
EntitiesDao entDao = new EntitiesDao();
Entities entTemp = entDao.findById(idEntSystem);
typeEnt = entTemp.getEntitiesTypes().getIdEntTyp();
if (entTemp.getEntitiesTypes().getIdEntTyp() == 2) {
ProducersDao proDao = new ProducersDao();
Producers proTemp = new Producers();
proTemp = proDao.objectByEntityId(idEntSystem);
if (proTemp != null) {
idProducer = proTemp.getIdPro();
name_producer = entTemp.getNameEnt();
}
}
this.setDepartment_property(new DepartmentsDao().findAll());
usrDao = new UsersDao();
idUsrSystem = user.getIdUsr();
List<Municipalities> mun = new ArrayList<Municipalities>();
mun.add(new Municipalities());
this.setCity_property(mun);
assDao = new AssociationDao();
// HashMap route = new HashMap();
// route.put("getting", getText("email.from"));
// listRoute.add(route);
// route = new HashMap();
//// String val = getText('text.title.farm');
// route.put("listFarm", getText("email.from"));
// listRoute.add(route);
}
public String getReport() throws Exception {
if (!usrDao.getPrivilegeUser(idUsrSystem, "farm/list")) {
return BaseAction.NOT_AUTHORIZED;
}
String selAll = "false";
if (selectAllname_agronomist != null) {
selAll = "true";
}
HashMap findParams = new HashMap();
findParams.put("selAll", selAll);
findParams.put("selItem", selectItemname_agronomist);
Integer entTypeId = new EntitiesDao().getEntityTypeId(user.getIdUsr());
findParams.put("entType", entTypeId);
findParams.put("idEntUser", idEntSystem);
String fileName = "" + getText("file.docfarm");
// String fileName = "farmsInfo.csv";
farDao.getFarms(findParams, fileName);
File f = new File(fileName);
inputStream = new FileInputStream(f);
return "OUTPUTCSV";
}
/**
* Encargado de guardar la informacion suministrada por el usuario para un riego
*
* @return Estado del proceso
*/
public String saveData() {
if (!usrDao.getPrivilegeUser(idUsrSystem, "crop/create")
|| !usrDao.getPrivilegeUser(idUsrSystem, "crop/modify")) {
return BaseAction.NOT_AUTHORIZED;
}
String action = "";
// System.out.println("Entre a guardar la info");
/*
* Se evalua dependiendo a la accion realizada:
* 1) create: Al momento de guardar un registro por primera ves
* 2) modify: Al momento de modificar un registro
* 3) delete: Al momento de borrar un registro
*/
if (actExe.equals("create")) {
action = "C";
} else if (actExe.equals("modify")) {
action = "M";
}
SessionFactory sessions = HibernateUtil.getSessionFactory();
Session session = sessions.openSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
String dmy = new SimpleDateFormat("yyyy-MM-dd").format(irr.getDateIrr());
Date dateIrr = new SimpleDateFormat("yyyy-MM-dd").parse(dmy);
irr.setUseIrrigationIrr(true);
irr.setProductionEvents(new ProductionEvents(idCrop));
irr.setDateIrr(dateIrr);
// if (sowing.getChemicalsSowing().getIdCheSow()==-1) {
// sowing.setChemicalsSowing(null);
// }
//
// if (sowing.getDoseUnits().getIdDosUni()==-1) {
// sowing.setDoseUnits(null);
// }
irr.setStatus(true);
session.saveOrUpdate(irr);
LogEntities log = new LogEntities();
log.setIdLogEnt(null);
log.setIdEntityLogEnt(idEntSystem);
log.setIdObjectLogEnt(irr.getIdIrr());
log.setTableLogEnt("irrigation");
log.setDateLogEnt(new Date());
log.setActionTypeLogEnt(action);
session.saveOrUpdate(log);
tx.commit();
state = "success";
if (action.equals("C")) {
info = "El riego ha sido agregado con exito";
// return "list";
} else if (action.equals("M")) {
info = "El riego ha sido modificado con exito";
// return "list";
}
HashMap prod = cropDao.findById(idCrop);
Integer tyCro = Integer.parseInt(String.valueOf(prod.get("typeCrop")));
SfGuardUserDao sfDao = new SfGuardUserDao();
SfGuardUser sfUser = sfDao.getUserByLogin(user.getCreatedBy(), user.getNameUserUsr(), "");
GlobalFunctions.sendInformationCrop(idCrop, tyCro, sfUser.getId());
} catch (HibernateException e) {
if (tx != null) {
tx.rollback();
}
e.printStackTrace();
// System.out.println("error->"+e.getMessage());
state = "failure";
info = "Fallo al momento de agregar un riego";
} catch (ParseException e) {
} finally {
session.close();
}
// return ERROR;
return "states";
}
/**
* Encargado de guardar la informacion suministrada por el usuario para una siembra
*
* @return Estado del proceso
*/
public String saveData() {
if (!usrDao.getPrivilegeUser(idUsrSystem, "crop/create")
|| !usrDao.getPrivilegeUser(idUsrSystem, "crop/modify")) {
return BaseAction.NOT_AUTHORIZED;
}
String action = "";
// System.out.println("Entre a guardar la info");
/*
* Se evalua dependiendo a la accion realizada:
* 1) create: Al momento de guardar un registro por primera ves
* 2) modify: Al momento de modificar un registro
* 3) delete: Al momento de borrar un registro
*/
if (actExe.equals("create")) {
action = "C";
} else if (actExe.equals("modify")) {
action = "M";
}
SessionFactory sessions = HibernateUtil.getSessionFactory();
Session session = sessions.openSession();
Transaction tx = null;
// info = "La siembra ha sido modificado con exito";
try {
tx = session.beginTransaction();
String dmy = new SimpleDateFormat("yyyy-MM-dd").format(sowing.getDateSow());
Date dateSow = new SimpleDateFormat("yyyy-MM-dd").parse(dmy);
// event.setFields(event.getFields());
// event.setCropsTypes(new CropsTypes(2));
// event.setIdProjectProEve(event.getIdProjectProEve());
// event.setStatus(event.isStatus());
session.saveOrUpdate(event);
if (sowing.getIdSow() == null) {
Sowing sowTemp = sowDao.objectById(idCrop);
if (sowTemp != null) {
sowing.setIdSow(sowTemp.getIdSow());
}
}
sowing.setProductionEvents(new ProductionEvents(idCrop));
sowing.setDateSow(dateSow);
if (sowing.getChemicalsSowing().getIdCheSow() == -1) {
sowing.setChemicalsSowing(null);
}
if (sowing.getDoseUnits() != null
&& (sowing.getDoseUnits().getIdDosUni() == -1
|| sowing.getChemicalsSowing().getIdCheSow() == 3)) {
sowing.setDoseUnits(null);
}
// sowing.setSowingTypes(new SowingTypes(idCrop));
sowing.setStatus(true);
session.saveOrUpdate(sowing);
Maize maizeOld = maizeDao.objectById(this.getIdCrop());
if (maizeOld != null) session.delete(maizeOld);
Beans beansOld = beansDao.objectById(this.getIdCrop());
if (beansOld != null) session.delete(beansOld);
if (typeCrop == 1) {
maize.setProductionEvents(new ProductionEvents(idCrop));
maize.setStatus(true);
session.saveOrUpdate(maize);
} else if (typeCrop == 2) {
beans.setSeedsTypes(null);
beans.setProductionEvents(new ProductionEvents(idCrop));
beans.setStatus(true);
session.saveOrUpdate(beans);
} else if (typeCrop == 3) {
// Cassavas ca = new Cassavas();
// ca.setIdCas(null);
// ca.setProductionEvents(pro);
}
LogEntities log = new LogEntities();
log.setIdLogEnt(null);
log.setIdEntityLogEnt(idEntSystem);
log.setIdObjectLogEnt(sowing.getIdSow());
log.setTableLogEnt("sowing");
log.setDateLogEnt(new Date());
log.setActionTypeLogEnt(action);
session.saveOrUpdate(log);
tx.commit();
state = "success";
if (action.equals("C")) {
info = "La siembra ha sido agregada con exito";
// return "list";
} else if (action.equals("M")) {
info = "La siembra ha sido modificada con exito";
// return "list";
}
SfGuardUserDao sfDao = new SfGuardUserDao();
SfGuardUser sfUser = sfDao.getUserByLogin(user.getCreatedBy(), user.getNameUserUsr(), "");
GlobalFunctions.sendInformationCrop(idCrop, typeCrop, sfUser.getId());
} catch (HibernateException e) {
if (tx != null) {
tx.rollback();
}
e.printStackTrace();
// System.out.println("error->"+e.getMessage());
state = "failure";
info = "Fallo al momento de agregar una siembra";
} catch (ParseException e) {
} finally {
session.close();
}
// return ERROR;
return "states";
}
/**
* Encargado de guardar la informacion suministrada por el usuario para una finca
*
* @return Estado del proceso
*/
public String saveData() throws SQLException {
if (!usrDao.getPrivilegeUser(idUsrSystem, "farm/create")
|| !usrDao.getPrivilegeUser(idUsrSystem, "farm/modify")) {
return BaseAction.NOT_AUTHORIZED;
}
String action = "";
/*
* Se evalua dependiendo a la accion realizada:
* 1) create: Al momento de guardar un registro por primera ves
* 2) modify: Al momento de modificar un registro
* 3) delete: Al momento de borrar un registro
*/
if (actExe.equals("create")) {
action = "C";
} else if (actExe.equals("modify")) {
action = "M";
}
ProducersDao proDao = new ProducersDao();
SessionFactory sessions = HibernateUtil.getSessionFactory();
Session session = sessions.openSession();
Transaction tx = null;
HashMap proData = proDao.findById(idProducer);
Double altPro = Double.parseDouble(altitude_property.replace(',', '.'));
Double latPro = Double.parseDouble(latitude_property.replace(',', '.'));
Double lonPro = Double.parseDouble(length_property.replace(',', '.'));
// Double altPro = Double.parseDouble(altitude_property);
// Double latPro = Double.parseDouble(latitude_property);
// Double lonPro = Double.parseDouble(length_property);
if (option_geo == 2) {
latPro = (latitude_minutes_property / 60) + (latitude_seconds_property / 3600);
latPro =
(latitude_degrees_property < 0)
? ((Math.abs(latitude_degrees_property)) + latPro) * -1
: (latitude_degrees_property + latPro);
lonPro = (length_minutes_property / 60) + (length_seconds_property / 3600);
lonPro =
(length_degrees_property < 0)
? ((Math.abs(length_degrees_property)) + lonPro) * -1
: (length_degrees_property + lonPro);
}
try {
tx = session.beginTransaction();
SfGuardUserDao sfDao = new SfGuardUserDao();
SfGuardUser sfUser = sfDao.getUserByLogin(user.getCreatedBy(), user.getNameUserUsr(), "");
Farms far = null;
int idProOld = 0;
if (idFarm <= 0) {
far = new Farms();
far.setIdFar(null);
far.setGeorefFar(true);
far.setIdProjectFar("1");
far.setStatus(true);
} else {
HashMap fieldInfo = farDao.findById(idFarm);
idProOld = Integer.parseInt(String.valueOf(fieldInfo.get("id_producer")));
far = farDao.objectById(idFarm);
}
far.setNameFar(name_property);
far.setAddressFar(direction_property);
far.setLatitudeFar(latPro);
far.setLongitudeFar(lonPro);
far.setAltitudeFar(altPro);
far.setNameCommuneFar(lane_property);
far.setMunicipalities(new Municipalities(Integer.parseInt(cityFar)));
Integer idUserMobile = null;
if (sfUser != null) {
idUserMobile = sfUser.getId().intValue();
}
far.setCreatedBy(idUserMobile);
session.saveOrUpdate(far);
depFar = String.valueOf(MunicipalitiesDao.getDepartmentId(Integer.parseInt(cityFar)));
// farDao.save(far);
// System.out.println("valId->"+far.getIdFar());
if (far.getIdFar() > 0 && action.equals("M")) {
if (idProOld != idProducer) {
FarmsProducers farTemp = farDao.checkFarmProducer(far.getIdFar(), idProOld);
session.delete(farTemp);
}
// System.out.println("id field->"+fiePro.getFields().getIdFie());
// fiePro = new FieldsProducers();
// fiePro.setId(new FieldsProducersId(lot.getIdFie(), idProducer));
// fiePro.setFields(lot);
// fiePro.setProducers(proDao.objectById(idProducer));
// fiePro.setFieldTypes(new FieldTypes(typeLot));
// session.saveOrUpdate(fiePro);
}
if (idProOld != idProducer) {
FarmsProducers farPro = new FarmsProducers();
farPro.setId(new FarmsProducersId(far.getIdFar(), idProducer));
farPro.setFarms(far);
farPro.setProducers(proDao.objectById(idProducer));
session.saveOrUpdate(farPro);
}
/*LogEntities log = new LogEntities();
log.setIdLogEnt(null);
log.setIdEntityLogEnt(idEntSystem); //Colocar el usuario registrado en el sistema
log.setIdObjectLogEnt(far.getIdFar());
log.setTableLogEnt("farms");
log.setDateLogEnt(new Date());
log.setActionTypeLogEnt(action);
session.saveOrUpdate(log);*/
// logDao.save(log);
/*
"102": "Nombre de la finca" => nameFarm
"103": "-30.98664622,-64.10017675,601" Capturar posicion => lat, lng, alt
"105": "Vereda" => district
"108": "Indicación (como llegar)" => address
"241": "Seleccione el productor asociado" => Seleccion (solo dato seleccionado) => prodId
"336": "Departamento" => department
"338": "Municipio (Amazonas)" => municipality
*/
// Manejo para ingresar datos en MongoDB
HashMap valInfo = new HashMap();
valInfo.put("farmId", far.getIdFar());
valInfo.put("nameFarm", far.getNameFar());
valInfo.put("prodId", idProducer);
valInfo.put("nameProd", proData.get("name"));
valInfo.put("district", far.getNameCommuneFar());
valInfo.put("address", far.getAddressFar());
valInfo.put("lat", latPro);
valInfo.put("lng", lonPro);
valInfo.put("alt", altPro);
valInfo.put("department", depFar);
valInfo.put("municipality", cityFar);
valInfo.put("userMobileId", idUserMobile);
// System.out.println("valInfo=>"+valInfo);
BasicDBObject query = new BasicDBObject();
query.put("InsertedId", "" + far.getIdFar());
query.put("form_id", "3");
MongoClient mongo = null;
try {
mongo = new MongoClient("localhost", 27017);
} catch (UnknownHostException ex) {
Logger.getLogger(ActionField.class.getName()).log(Level.SEVERE, null, ex);
}
DB db = mongo.getDB("ciat");
DBCollection col = db.getCollection("log_form_records");
DBCursor cursor = col.find(query);
WriteResult result = null;
BasicDBObject jsonField = GlobalFunctions.generateJSONFarm(valInfo);
if (cursor.count() > 0) {
System.out.println("actualizo mongo");
result = col.update(query, jsonField);
} else {
System.out.println("inserto mongo");
result = col.insert(jsonField);
}
if (result.getError() != null) {
throw new HibernateException("");
}
mongo.close();
tx.commit();
state = "success";
if (action.equals("C")) {
info = "La finca ha sido agregada con exito";
// return "list";
} else if (action.equals("M")) {
info = "La finca ha sido modificada con exito";
}
} catch (HibernateException e) {
if (tx != null) {
tx.rollback();
}
e.printStackTrace();
state = "failure";
info = "Fallo al momento de agregar una finca";
} finally {
session.close();
}
return "states";
// return ERROR;
}
/**
* Encargado de buscar las coincidencias de un formulario de busqueda, para cada una de las fincas
* registradas a un usuario
*
* @param valName: Nombre del valor a buscar
* @param valId: Identificacion del valor a buscar
* @param selected: Valor seleccionado
* @return lista de fincas
*/
public String search() {
if (!usrDao.getPrivilegeUser(idUsrSystem, "farm/list")) {
// if (!false) {
return BaseAction.NOT_AUTHORIZED;
}
valName = (String) (this.getRequest().getParameter("valName"));
valId = (String) (this.getRequest().getParameter("valId"));
selected = (String) (this.getRequest().getParameter("selected"));
viewInfo = (String) (this.getRequest().getParameter("viewInfo"));
String selAll = "false";
if (selected == null) {
selected = "property";
selAll = "true";
}
if (selectAllname_agronomist != null) {
selAll = "true";
}
additionals = new HashMap();
additionals.put("selected", selected);
HashMap findParams = new HashMap();
findParams.put("selAll", selAll);
findParams.put("selItem", selectItemname_agronomist);
Integer entTypeId = new EntitiesDao().getEntityTypeId(user.getIdUsr());
findParams.put("entType", entTypeId);
list_agronomist = assDao.gelAllAgronomist(idEntSystem);
if (searchFromFarm != null && searchFromFarm == 2) {
search_farm = "";
}
// fardParams.put("nameProperty", this.getName_property());
// System.out.println("this.getAltitude_property()->"+this.getAltitude_property());
findParams.put("idEntUser", idEntSystem);
findParams.put("search_farm", search_farm);
findParams.put("name_producer", name_producer);
findParams.put("name_property", name_property);
findParams.put("depFar", depFar);
findParams.put("cityFar", cityFar);
findParams.put("lane_property", lane_property);
findParams.put("altitude_property", altitude_property);
findParams.put("latitude_property", latitude_property);
findParams.put("length_property", length_property);
int pageReq;
if (this.getRequest().getParameter("page") == null) {
pageReq = this.getPage();
} else {
pageReq = Integer.parseInt(StringUtils.trim(this.getRequest().getParameter("page")));
}
findParams.put("pageNow", pageReq);
findParams.put("maxResults", this.getMaxResults());
FarmsDao farmDao = new FarmsDao();
// System.out.println("entreeee");
listProperties = farmDao.findByParams(findParams);
// this.setCountTotal(100);
// System.out.println("entreeee->"+listProperties.get(0).get("countTotal"));
this.setCountTotal(Integer.parseInt(String.valueOf(listProperties.get(0).get("countTotal"))));
this.setPage(page);
listProperties.remove(0);
// System.out.println("countTotal->"+this.getCountTotal());
return SUCCESS;
}