cesarockstar1985

        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 ");

cesarockstar1985

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);

cesarockstar1985

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;

cesarockstar1985

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));

cesarockstar1985

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

cesarockstar1985

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

cesarockstar1985

//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;

cesarockstar1985

//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;

cesarockstar1985

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,

cesarockstar1985

//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;