send_driving_habits_resume_per_trip
2026-04-20 09:07:26: 28147459
SELECT DISTINCT(msg_type) FROM holcim_sap_log WHERE cve_vehicle = '100361' AND trip_id = '28147459'
2026-04-20 09:13:36: 28148588
SELECT DISTINCT(msg_type) FROM holcim_sap_log WHERE cve_vehicle = '108854' AND trip_id = '28148588'
SELECT SUM(alert_duration) AS alert_duration FROM holcim_sap_log WHERE cve_vehicle = '108854' AND trip_id = '28148588' AND msg_type = 'EV0749'
+holcim_send_sap_close_trip_events
SELECT * FROM `holcim_sap_log` WHERE origin_adm = '1165' AND cve_vehicle = '108854' AND cve_main_panel = '2678' AND msg_type = 'EV0749' AND send_time = '2026-04-20 09:13:36' AND code = '800'
INSERT INTO `holcim_sap_log`
            (`origin_adm`, cve_vehicle, `cve_main_panel`, `msg_type`, `event_type`, `country`, `vehicle_driver`, `send_time`, `code`, `trip_id`, `desc_origin_trip`, `panel_name`, `alert_lat`, `alert_lon`, `folio_alert`, `speed`, `link_video`, `url`, alert_duration)
            VALUES
            ('1165', '108854', '2678', 'EV0749', '0', 'MX', 'MHEMO83081', '2026-04-20 09:13:36', '800', '28148588', 'AAP0', 'Exceso de velocidad > 80 km/hr', '0', '0', '0', '0', '', 'https://integration.cloud-ops.biz/XISOAPAdapter/MessageServlet?senderParty=PEGASUS_GPS&senderService=PEGASUS&receiverParty=&receiverService=&interface=CreateDriverPenaltyDetail_OB_SYNC&interfaceNamespace=urn:com:lh:logistics:la:pegasus:gps', '840');
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:com:lh:logistics:la:pegasus:gps">
                <soapenv:Header/>
                    <soapenv:Body>
                    <urn:SendDriverPenaltyDetailRequest>
                        <CHECK_DUPLI>X</CHECK_DUPLI>
                        <IDENT>X</IDENT>
                        <ZESD_INFRA>
                            <LAND1>MX</LAND1>
                            <LIFNR>MHEMO83081</LIFNR>
                            <PARVW>MO</PARVW>
                            <DATA>2026-04-20</DATA>
                            <HORA>03:13:36</HORA>
                            <ZCODCAT>800</ZCODCAT>
                            <UNAME>SIST GPS</UNAME>
                            <TKNUM>28148588</TKNUM>
                            <LOCL>AAP0</LOCL>
                            <ZOBSINFRA>Exceso de velocidad > 80 km/hr</ZOBSINFRA>
                        </ZESD_INFRA>
                        <DET_INFRACAO>
                            <ITEM>
                                <TIPO>KEY_ORI</TIPO>
                                <VALOR>MX|MHEMO83081|20260420|031336|800</VALOR>
                                <DETALHE></DETALHE>
                            </ITEM>
                            <ITEM>
                                <TIPO>EXVELO</TIPO>
                                <VALOR>840</VALOR>
                                <DETALHE>SEGUNDOS</DETALHE>
                            </ITEM>
                        </DET_INFRACAO>
                    </urn:SendDriverPenaltyDetailRequest>
                    </soapenv:Body>
                </soapenv:Envelope>
<SOAP:Envelope xmlns:SOAP='http://schemas.xmlsoap.org/soap/envelope/'><SOAP:Header/><SOAP:Body><ns1:SendDriverPenaltyDetailResponse xmlns:ns1='urn:com:lh:logistics:la:pegasus:gps'><EX_OK>X</EX_OK><DET_INFRA_RET><RETURN><SEQNR>0001</SEQNR><TIPO>KEY_ORI</TIPO><OK>X</OK><MSG>Éxito</MSG></RETURN><RETURN><SEQNR>0002</SEQNR><TIPO>EXVELO</TIPO><OK>X</OK><MSG>Éxito</MSG></RETURN></DET_INFRA_RET></ns1:SendDriverPenaltyDetailResponse></SOAP:Body></SOAP:Envelope>
UPDATE `holcim_sap_log` SET post = ' soapenv Envelope xmlns soapenv  http   schemas.xmlsoap.org soap envelope   xmlns urn  urn com lh logistics la pegasus gps                    soapenv Header                        soapenv Body                       urn SendDriverPenaltyDetailRequest                           CHECK DUPLI X  CHECK DUPLI                           IDENT X  IDENT                           ZESD INFRA                               LAND1 MX  LAND1                               LIFNR MHEMO83081  LIFNR                               PARVW MO  PARVW                               DATA 2026-04-20  DATA                               HORA 03 13 36  HORA                               ZCODCAT 800  ZCODCAT                               UNAME SIST GPS  UNAME                               TKNUM 28148588  TKNUM                               LOCL AAP0  LOCL                               ZOBSINFRA Exceso de velocidad   80 km hr  ZOBSINFRA                            ZESD INFRA                           DET INFRACAO                               ITEM                                   TIPO KEY ORI  TIPO                                   VALOR MX MHEMO83081 20260420 031336 800  VALOR                                   DETALHE   DETALHE                                ITEM                               ITEM                                   TIPO EXVELO  TIPO                                   VALOR 840  VALOR                                   DETALHE SEGUNDOS  DETALHE                                ITEM                            DET INFRACAO                        urn SendDriverPenaltyDetailRequest                        soapenv Body                    soapenv Envelope ', response = ' SOAP Envelope xmlns SOAP  http   schemas.xmlsoap.org soap envelope    SOAP Header   SOAP Body  ns1 SendDriverPenaltyDetailResponse xmlns ns1  urn com lh logistics la pegasus gps   EX OK X  EX OK  DET INFRA RET  RETURN  SEQNR 0001  SEQNR  TIPO KEY ORI  TIPO  OK X  OK  MSG   xito  MSG   RETURN  RETURN  SEQNR 0002  SEQNR  TIPO EXVELO  TIPO  OK X  OK  MSG   xito  MSG   RETURN   DET INFRA RET   ns1 SendDriverPenaltyDetailResponse   SOAP Body   SOAP Envelope ', ack = 'X' WHERE origin_adm = '1165' AND cve_vehicle = '108854' AND cve_main_panel = '2678' AND msg_type = 'EV0749' AND send_time = '2026-04-20 09:13:36' AND code = '800'
+Completado
2026-04-20 09:16:36: 28146996
SELECT DISTINCT(msg_type) FROM holcim_sap_log WHERE cve_vehicle = '94087' AND trip_id = '28146996'
+Completado