Skip to content

Instantly share code, notes, and snippets.

try {
StringBuilder querySb = new StringBuilder();
querySb.append(" SELECT c.name as company, u.username, u.full_name, u.document_type, ");
querySb.append(" u.document_number, u.nationality, u.code, p.name as position, u.email, ");
querySb.append(" CASE u.self_assign_pod WHEN 'true' THEN 'Si' ELSE 'No' END self_assign_pod, ");
querySb.append(" CASE u.active WHEN 'true' THEN 'Si' ELSE 'No' END active, ");
querySb.append(" STRING_AGG(DISTINCT CASE WHEN lsz.active = TRUE THEN lsz.description END, ',') AS user_sub_zones ");
querySb.append(" FROM users u ");
querySb.append(" LEFT JOIN company c ON c.id = u.company_id ");
querySb.append(" LEFT JOIN position p ON p.id = u.position_id ");
private boolean isHarbor(String pointOfDeliveryPlantNumber) {
DataSource dataSourceExternalDS1 = null;
Connection connectionExternalDS1 = null;
String unit_type = DEFAULT_JIRA_ACCOUNT_ID;
PreparedStatement ps = null;
ResultSet rs = null;
boolean ret = false;
try {
dataSourceExternalDS1 = (DataSource) appContext.getBean(DataBaseHelper.EXTERNAL_DS1);
connectionExternalDS1 = DataSourceUtils.getConnection(dataSourceExternalDS1);
package cast.com.py.castmobile3.jsinterface;
import android.content.Context;
import android.graphics.*;
import android.graphics.drawable.Drawable;
import android.support.v4.graphics.drawable.DrawableCompat;
import android.text.TextPaint;
import android.util.DisplayMetrics;
import android.util.Log;
import cast.com.py.castmobile3.CastMobileActivity;
function cm_getPolygonsForRoute(routeId) {
var polygonList = [];
try {
if (routeId != null) {
var sql = "SELECT zone_code, zone_color, zone_coordinates, zone_name FROM route_zone WHERE route_id = ?";
var whereValues = [routeId];
var sqls = [];
sqls.push(cm_createSql("routeZone", sql, whereValues));
var result = JSInterface.executeSqls(JSON.stringify(sqls));
2025-02-07 15:38:22.378 INFO 93 --- [pool-107-thread-1] p.c.c.t.e.DynamicImporterExecutor : - - - - - Importador importer.subject Finished - - - - -
2025-02-07 15:38:22.540 INFO 93 --- [pool-107-thread-3] py.com.cast.srv.ImporterService : Fusion entre prospecto con id 2721525187|595986175463|1732644565574|
1524499249 y cliente con codigo temporal -1732644565540
2025-02-07 15:38:22.540 INFO 93 --- [pool-107-thread-3] py.com.cast.srv.ImporterService : Fusion entre prospecto con id 9905395102|595986737528|1726066858984|
493728621 y cliente con codigo temporal -1726066858881
2025-02-07 15:38:22.547 INFO 93 --- [pool-107-thread-3] py.com.cast.srv.ImporterService : Fusion entre prospecto con id 2213847981|595994806073|1731506546919|
746854784 y cliente con codigo temporal -1731506546844
2025-02-07 15:38:22.561 INFO 93 --- [pool-107-thread-3] py.com.cast.srv.ImporterService : Fusion entre prospecto con id 1422420908|595971633958|1738846884203|
208320403 y cliente con c
2025-02-07 08:12:30.169 INFO 93 --- [RE:oaimport|oaimport|oaimport] py.com.cast.datagw.MessageService : createMessage for oaimport|1738926750167|858355113 in 2 ms.
2025-02-07 08:12:30.169 INFO 93 --- [SE:oaimport|oaimport|oaimport] py.com.cast.datagw.NetworkConnection : Message To Send: RRX Msg Id oaimport|1738926750167|858355113 -> 2213847981|595994806073|1738926749197|467266879
2025-02-07 08:12:30.549 INFO 93 --- [pool-107-thread-1] py.com.cast.helper.ImporterHelper : Load Subject Aditional Data STARTED
2025-02-07 08:12:31.120 INFO 93 --- [pool-107-thread-1] py.com.cast.helper.ImporterHelper : Load Subject Aditional Data Quantity Found: 52447
2025-02-07 08:12:31.261 INFO 93 --- [NC:oaimport|oaimport] py.com.cast.datagw.NetworkConnection : Message Received: ACK Msg Id castGateway|1738926750358|303148046 -> oaimport|1738926750167|858355113
2025-02-07 08:12:31.261 INFO 93 --- [APT:oaimport|oaimport|oaimport] py.com.cast.datagw.AckProcessThread : ACK to process: castGatew
//package cast.backend.migrator.autopiezas; //TODO: comentar
import cast.portal.core.srv.CommandService;
import cast.portal.iface.srv.DeviceInfoService;
import cast.portal.monitor.dto.DeviceInfoEventDTO;
import cast.portal.security.ent.User;
import cast.portal.util.DataBaseHelper;
import com.sun.org.apache.xml.internal.security.utils.Base64;
import grails.plugin.mail.MailService;
import org.apache.log4j.Logger;
//COMANDO DE VENTAS CAST_SI2
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.List;
import javax.sql.DataSource;
WITH RECURSIVE split(testing_no_performed_according_protocol_reason, rest) AS
(SELECT '',
testing_no_performed_according_protocol_reason||';'
FROM impl_recurrent_visit WHERE route_detail_id = 'monsanto|1734177726753|1251712363|172' AND cast_draft_status = 10
UNION ALL SELECT substr(rest, 0, instr(rest, ';')),
substr(rest, instr(rest, ';')+1)
FROM SPLIT
WHERE rest!='' )
SELECT
a.description,
//package cast.sn.superindustrial;
import grails.converters.JSON;
import grails.plugin.mail.MailService;
import java.io.*;
import java.net.HttpURLConnection;
import java.net.Socket;
import java.net.URL;
import java.security.KeyManagementException;