This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 "); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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; |
NewerOlder