[20/01/25 13:17:04]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1797', bon = '', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '121', fk_zone = '1', fk_capacite = '5', fk_capacite_cmd = '5', fk_regular = '0', fk_coutype = '0', exped = 'MOTER SAS - ETS MERIGNAC', desti = '', fk_type = '5', communee = '0', communed = '0', datenl = '2024-12-02', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '610.000', punetliv = '610.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '22', hexploit = '', obs = '', ref_commande = '', sendstate = '9', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'DEMANDER LE CODE CHANTIER AU CHEF ET LE MARQUER SUR LA LETTRE DE VOITURE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:30', hfin = '15:30', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '3',fk_type_benne = '', postem = 'admin', datmod = '2025-01-20', heumod = '13:17:04', chantier1 = 'CHARGER A GUYENNE ENROBE', chantier2 = 'VIDER SITE SOLVALOR, LIEU DIT GRAULIN', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'MERIGNAC', CPChantier2 = '', VilleChantier2 = 'MERIGNAC', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '610.000', contact = 'FABRICE NAJDA 0612486077', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55255 [20/01/25 13:17:08]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1641', bon = '', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '616', fk_zone = '1', fk_capacite = '22', fk_capacite_cmd = '22', fk_regular = '0', fk_coutype = '0', exped = 'OSTREA', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2024-12-03', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '900.000', punetliv = '900.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '259', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = 'PR2410-0438', obsexp = 'DEMANDER LE CODE CHANTIER AU CHEF ET LE MARQUER SUR LA LETTRE DE VOITURE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '16:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '2',fk_type_benne = '', postem = 'admin', datmod = '2025-01-20', heumod = '13:17:08', chantier1 = '14-20 PLACE GAMBETTA', chantier2 = '', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'LA TESTE DE BUCH', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '900.000', contact = 'JONATHAN BERNARD 0681279012', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55275 [22/01/25 08:36:22]UPDATE llx_tr_courses SET entity = '1', fk_soc = '2047', bon = '', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '59', fk_zone = '1', fk_capacite = '7', fk_capacite_cmd = '7', fk_regular = '0', fk_coutype = '0', exped = 'BOTTE FONDATIONS', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-01-06', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '780.000', punetliv = '500.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '220', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'DEMANDER LE CODE CHANTIER AU CHEF ET LE MARQUER SUR LA LETTRE DE VOITURE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '2',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '08:36:22', chantier1 = 'ANGLE RUE CAMILLE MAUMEY ET RESIDENCE LES LIERRES', chantier2 = '', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'BRUGES', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '780.000', contact = 'SMAIL GHARBI 0603493396', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55847 [22/01/25 08:36:52]UPDATE llx_tr_courses SET entity = '1', fk_soc = '2047', bon = '123456', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '59', fk_zone = '1', fk_capacite = '7', fk_capacite_cmd = '7', fk_regular = '0', fk_coutype = '0', exped = 'BOTTE FONDATIONS', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-01-06', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '780.000', punetliv = '500.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '220', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'DEMANDER LE CODE CHANTIER AU CHEF ET LE MARQUER SUR LA LETTRE DE VOITURE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-01-06', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '08:36:52', postel = 'remi', datctr = '2025-01-22', heuctr = '08:36:52', chantier1 = 'ANGLE RUE CAMILLE MAUMEY ET RESIDENCE LES LIERRES', chantier2 = '', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'BRUGES', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '780.000', contact = 'SMAIL GHARBI 0603493396', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55847 [22/01/25 08:38:33]UPDATE llx_tr_courses SET entity = '1', fk_soc = '2047', bon = '123456', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '59', fk_zone = '1', fk_capacite = '7', fk_capacite_cmd = '7', fk_regular = '0', fk_coutype = '0', exped = 'BOTTE FONDATIONS', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-01-06', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '780.000', punetliv = '500.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '0', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'DEMANDER LE CODE CHANTIER AU CHEF ET LE MARQUER SUR LA LETTRE DE VOITURE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-01-06', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '08:38:33', chantier1 = 'ANGLE RUE CAMILLE MAUMEY ET RESIDENCE LES LIERRES', chantier2 = '', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'BRUGES', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '780.000', contact = 'SMAIL GHARBI 0603493396', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55847 [22/01/25 14:16:25]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1630', bon = '16023', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '15', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = 'EUROVIA GIRONDE AGENCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2024-12-11', heuenl = '', km = '', ei = 'I', qte = '10.00', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '140', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2024-12-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '18:00', coupure = '00:01:', duree = '10.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '14:16:25', chantier1 = 'CHARGER A GUYENNE ENROBE', chantier2 = 'VIDER CHEMIN DE JARRY', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'MERIGNAC', CPChantier2 = '', VilleChantier2 = 'CESTAS', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'REX Jessic', montant = '0.000', contact = 'JEAN MARIE LATOUR 0610604374', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55566 [22/01/25 14:16:53]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1630', bon = '16023', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '7', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = 'EUROVIA GIRONDE AGENCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2024-12-11', heuenl = '', km = '', ei = 'I', qte = '10.00', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '89', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2024-12-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '18:00', coupure = '00:01:', duree = '10.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '14:16:53', chantier1 = 'CHARGER A GUYENNE ENROBE', chantier2 = 'VIDER CHEMIN DE JARRY', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'MERIGNAC', CPChantier2 = '', VilleChantier2 = 'CESTAS', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'CHAGNEAU', montant = '0.000', contact = 'JEAN MARIE LATOUR 0610604374', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55566 [22/01/25 14:22:45]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1630', bon = '16023', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '7', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = 'EUROVIA GIRONDE AGENCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2024-12-11', heuenl = '', km = '', ei = 'I', qte = '10.00', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '89', hexploit = '', obs = '', ref_commande = '12345677889', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2024-12-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '18:00', coupure = '00:01:', duree = '10.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '14:22:45', chantier1 = 'CHARGER A GUYENNE ENROBE', chantier2 = 'VIDER CHEMIN DE JARRY', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'MERIGNAC', CPChantier2 = '', VilleChantier2 = 'CESTAS', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'CHAGNEAU', montant = '0.000', contact = 'JEAN MARIE LATOUR 0610604374', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55566 [22/01/25 14:23:12]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1630', bon = '16023', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '413', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = 'EUROVIA GIRONDE AGENCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2024-12-11', heuenl = '', km = '', ei = 'I', qte = '10.00', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '11', hexploit = '', obs = '', ref_commande = '12345677889', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2024-12-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '18:00', coupure = '00:01:', duree = '10.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '14:23:12', chantier1 = 'CHARGER A GUYENNE ENROBE', chantier2 = 'VIDER CHEMIN DE JARRY', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'MERIGNAC', CPChantier2 = '', VilleChantier2 = 'CESTAS', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'MENCO AZOU', montant = '0.000', contact = 'JEAN MARIE LATOUR 0610604374', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55566 [22/01/25 14:23:59]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1621', bon = '11733', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '14', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = 'A24115', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2024-12-09', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '590.000', punetliv = '590.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '45', hexploit = '', obs = '', ref_commande = 'C509497257', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2024-12-09', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '05:30', hfin = '14:30', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '14:23:59', chantier1 = 'CHARGER A ENROBE ROCHEFORTAIS', chantier2 = 'VIDER RUE DU 19 MARS', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '17780', VilleChantier1 = 'SOUBISE', CPChantier2 = '', VilleChantier2 = 'CADILLAC', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LAFFORGUE', montant = '590.000', contact = 'FLORENT HABADJOU 0763100894', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55496 [22/01/25 14:24:23]UPDATE llx_tr_courses SET fk_livreur = '367', punetliv = '0.000', autol = '0.00', ref_commande = '111111111111111111111', note = '' WHERE idcourse=55588 [22/01/25 14:24:34]UPDATE llx_tr_courses SET fk_livreur = '318', punetliv = '0.000', autol = '0.00', ref_commande = '111111111111111111111', note = '' WHERE idcourse=55588 [22/01/25 14:28:08]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1797', bon = '', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '498', fk_zone = '1', fk_capacite = '5', fk_capacite_cmd = '5', fk_regular = '0', fk_coutype = '0', exped = 'MOTER SAS - ETS MERIGNAC', desti = '', fk_type = '5', communee = '0', communed = '0', datenl = '2024-12-02', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '610.000', punetliv = '630.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '99', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = 'toto', obsexp = 'DEMANDER LE CODE CHANTIER AU CHEF ET LE MARQUER SUR LA LETTRE DE VOITURE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2024-12-02', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:30', hfin = '15:30', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '3',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '14:28:08', chantier1 = 'CHARGER A GUYENNE ENROBEzerezr', chantier2 = 'VIDER SITE SOLVALOR, LIEU DIT GRAULIN', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'MERIGNAC', CPChantier2 = '', VilleChantier2 = 'MERIGNAC', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '610.000', contact = 'FABRICE NAJDA 0612486077', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55228 [22/01/25 14:28:34]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1797', bon = '11', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '498', fk_zone = '1', fk_capacite = '5', fk_capacite_cmd = '5', fk_regular = '0', fk_coutype = '0', exped = 'MOTER SAS - ETS MERIGNAC', desti = '', fk_type = '5', communee = '0', communed = '0', datenl = '2024-12-02', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '6', punet = '610.000', punetliv = '630.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '99', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = 'toto', obsexp = 'DEMANDER LE CODE CHANTIER AU CHEF ET LE MARQUER SUR LA LETTRE DE VOITURE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2024-12-02', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:30', hfin = '15:30', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '14:28:34', chantier1 = 'CHARGER A GUYENNE ENROBEzerezr', chantier2 = 'VIDER SITE SOLVALOR, LIEU DIT GRAULIN', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'MERIGNAC', CPChantier2 = '', VilleChantier2 = 'MERIGNAC', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '610.000', contact = 'FABRICE NAJDA 0612486077', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55228 [22/01/25 14:42:15]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1621', bon = '15770', fk_propal = '0', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '590', fk_zone = '1', fk_capacite = '6', fk_capacite_cmd = '6', fk_regular = '0', fk_coutype = '0', exped = 'A18451 BEGUEY LE CLOS DE L\'ALISIER', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2024-12-04', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '500', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '4', hexploit = '', obs = '', ref_commande = 'C509474017', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'CHARGER UN COMPLET EN CAILLOUX', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2024-12-04', journee = '', email = '', conf_auto = '', non_facturer = '1', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '14:42:15', chantier1 = 'CHARGER 8 CHEMIN DE BOISSON', chantier2 = 'VIDER RUE DES ECOLES', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'BEGUEY', CPChantier2 = '', VilleChantier2 = 'BEGUEY', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '500', contact = 'KEVIN GESTAS 0669232885', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55347 [22/01/25 16:52:17]UPDATE llx_tr_courses SET entity = '1', fk_soc = '2047', bon = '123456', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '59', fk_zone = '1', fk_capacite = '7', fk_capacite_cmd = '7', fk_regular = '0', fk_coutype = '0', exped = 'BOTTE FONDATIONS', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-01-06', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '780.000', punetliv = '500.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '0', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'DEMANDER LE CODE CHANTIER AU CHEF ET LE MARQUER SUR LA LETTRE DE VOITURE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-01-06', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'remi', datmod = '2025-01-22', heumod = '16:52:17', chantier1 = 'ANGLE RUE CAMILLE MAUMEY ET RESIDENCE LES LIERRES', chantier2 = '', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = 'BRUGES', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '780.000', contact = 'SMAIL GHARBI 0603493396', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=55847 [10/03/25 14:37:18]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '121212', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-10', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '600', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '08:00', coupure = '00:01:', duree = '7.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-10', heumod = '14:37:18', postel = 'olivia', datctr = '2025-03-10', heuctr = '14:37:18', chantier1 = 'PEZENAS', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '600', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'RASOANARIVO VINCENT 06 69 19 89 11', emailbl = 'vincent.rasoanarivo@colas.com', nature = '', poidsnet = '' WHERE idcourse=2 [10/03/25 14:38:57]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '8888', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-10', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '900.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '4545454', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'faire signer le bon', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-10', heumod = '14:38:57', postel = 'olivia', datctr = '2025-03-10', heuctr = '14:38:57', chantier1 = 'pezenas', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LANET REMY', montant = '900.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'RASOANARIVO VINCENT 06 69 19 89 11', emailbl = 'vincent.rasoanarivo@colas.com', nature = '', poidsnet = '' WHERE idcourse=1 [10/03/25 14:52:36]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '121212', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-10', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '500', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-03-10', journee = '', email = '', conf_auto = '', non_facturer = '1', hdebut = '00:00', hfin = '08:00', coupure = '00:01:', duree = '7.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-10', heumod = '14:52:36', chantier1 = 'PEZENAS', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '500', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'RASOANARIVO VINCENT 06 69 19 89 11', emailbl = 'vincent.rasoanarivo@colas.com', nature = '', poidsnet = '' WHERE idcourse=2 [10/03/25 14:59:37]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '999', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-10', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '900.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '123', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'faire signer le bon', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-10', heumod = '14:59:37', chantier1 = 'pezenas', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LANET REMY', montant = '900.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'RASOANARIVO VINCENT 06 69 19 89 11', emailbl = 'vincent.rasoanarivo@colas.com', nature = '', poidsnet = '' WHERE idcourse=6 [10/03/25 14:59:55]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '121212', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-10', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '500.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '123', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-03-10', journee = '', email = '', conf_auto = '', non_facturer = '1', hdebut = '00:00', hfin = '08:00', coupure = '00:01:', duree = '7.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-10', heumod = '14:59:55', chantier1 = 'PEZENAS', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '500.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'RASOANARIVO VINCENT 06 69 19 89 11', emailbl = 'vincent.rasoanarivo@colas.com', nature = '', poidsnet = '' WHERE idcourse=2 [10/03/25 15:00:02]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '8888', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-10', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '900.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '456', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'faire signer le bon', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-03-10', journee = '', email = '', conf_auto = '', non_facturer = '1', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-10', heumod = '15:00:02', chantier1 = 'pezenas', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LANET REMY', montant = '900.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'RASOANARIVO VINCENT 06 69 19 89 11', emailbl = 'vincent.rasoanarivo@colas.com', nature = '', poidsnet = '' WHERE idcourse=1 [11/03/25 08:17:46]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '111', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '5', fk_capacite_cmd = '5', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '80.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '4', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '03:00', hfin = '12:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-11', heumod = '08:17:46', postel = 'olivia', datctr = '2025-03-11', heuctr = '08:17:46', chantier1 = 'CHANTIER', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LANET REMY', montant = '80.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=7 [11/03/25 08:17:53]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '333', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '5', fk_capacite_cmd = '5', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-12', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '80.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '4', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '03:00', hfin = '12:00', coupure = '00:01:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-11', heumod = '08:17:53', postel = 'olivia', datctr = '2025-03-11', heuctr = '08:17:53', chantier1 = 'CHANTIER', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LANET REMY', montant = '80.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=9 [11/03/25 08:18:01]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '99', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '6', fk_capacite_cmd = '6', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '8', communee = '0', communed = '0', datenl = '2025-03-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '50.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '6', hexploit = '', obs = 'ENGINS CHANTIER', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '12:00', coupure = '00:00:', duree = '4.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-11', heumod = '08:18:01', postel = 'olivia', datctr = '2025-03-11', heuctr = '08:18:01', chantier1 = '', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = 'DEPOT', AdresseLivTransf = 'PEZENAS', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '1', fk_VoiturePilote = '0', livinterim = '', montant = '50.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=8 [11/03/25 08:58:04]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1', bon = '1234', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '12', fk_coutype = '0', exped = 'WININFO', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-13', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '550.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '3', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '04:00', hfin = '13:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-11', heumod = '08:58:04', postel = 'olivia', datctr = '2025-03-11', heuctr = '08:58:04', chantier1 = '', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '550.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=16 [11/03/25 08:59:28]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1', bon = '456', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '12', fk_coutype = '0', exped = 'WININFO', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '550.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '3', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '16:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-11', heumod = '08:59:28', postel = 'olivia', datctr = '2025-03-11', heuctr = '08:59:28', chantier1 = '', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '550.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=12 [11/03/25 09:00:15]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1', bon = '789', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'WININFO', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-12', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '550.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '3', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '16:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-11', heumod = '09:00:15', postel = 'olivia', datctr = '2025-03-11', heuctr = '09:00:15', chantier1 = '', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '550.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=14 [11/03/25 09:16:30]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '250', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = 'INTEMPERIES', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '456', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'faire signer le bon', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '2',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-11', heumod = '09:16:30', chantier1 = 'pezenas', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LANET REMY', montant = '250', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'RASOANARIVO VINCENT 06 69 19 89 11', emailbl = 'vincent.rasoanarivo@colas.com', nature = '', poidsnet = '' WHERE idcourse=5 [11/03/25 09:18:06]UPDATE llx_tr_courses SET entity = '1', fk_soc = '3', bon = '12125', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '2', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = 'COLAS FRANCE', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '250.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = 'INTEMPERIES', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '456', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'faire signer le bon', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-03-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '08:00', hfin = '17:00', coupure = '00:01:', duree = '8.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'olivia', datmod = '2025-03-11', heumod = '09:18:06', postel = 'olivia', datctr = '2025-03-11', heuctr = '09:18:06', chantier1 = 'pezenas', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LANET REMY', montant = '250.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'RASOANARIVO VINCENT 06 69 19 89 11', emailbl = 'vincent.rasoanarivo@colas.com', nature = '', poidsnet = '' WHERE idcourse=5 [12/03/25 13:32:08]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1', bon = '132', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '0', fk_regular = '0', fk_coutype = '0', exped = 'WININFO', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-03-12', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '100.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-03-12', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '00:00', coupure = '00:00:', duree = '0.00', sms = '',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-03-12', heumod = '13:32:08', postel = 'admin', datctr = '2025-03-12', heuctr = '13:32:08', chantier1 = 'test', chantier2 = '', latitude_enl = '45.974808000', longitude_enl = '6.217744000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '74570', VilleChantier1 = 'Fillière', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'TEST', montant = '100.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=1 [12/03/25 15:56:33]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1', bon = '456', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = 'WININFO', desti = '', fk_type = '8', communee = '0', communed = '0', datenl = '2025-03-12', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '60', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '1', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-03-12', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '00:00', coupure = '00:00:', duree = '0.00', sms = '',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-03-12', heumod = '15:56:33', postel = 'admin', datctr = '2025-03-12', heuctr = '15:56:33', chantier1 = '', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = 'ssssssssssss', AdresseLivTransf = 'tttttttttt', CPChantier1 = '', VilleChantier1 = '', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '33470', VilleEnlevTransf = 'gujan', CPLivTransf = '33000', VilleLivTransf = 'bordeaux', PositionTournee = '0', fk_VoiturePilote = '0', livinterim = 'TEST', montant = '60', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=2 [11/07/25 09:06:32]UPDATE llx_tr_courses SET fk_livreur = '8', punetliv = '0.000', autol = '0.00', ref_commande = '123', note = '' WHERE idcourse=10085 [11/07/25 09:28:07]UPDATE llx_tr_courses SET fk_livreur = '8', punetliv = '0.000', autol = '0.00', ref_commande = '123', note = '' WHERE idcourse=10085 [11/07/25 09:44:26]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1624', bon = '00984', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '5', fk_zone = '6', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-01', heuenl = '', km = '', ei = 'I', qte = '24.90', picod = '3', punet = '34.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '50', fk_truck = '13', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-07-01', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '16:00', coupure = '00:00:', duree = '9.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '09:44:26', chantier1 = 'GIUSEPPE NUTARELLI', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '', longitude_liv = '', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '55047', VilleChantier1 = 'QUERCETA ITALIE', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'DEL BIANCO Jérome', montant = '846.600', contact = 'THIERRY SEGUIN 0607510272', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'THIERRY SEGUIN 0607510272', emailbl = 'demotransvarois@orange.fr', nature = '', poidsnet = '' WHERE idcourse=10011 [11/07/25 09:45:44]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1624', bon = '00984', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '5', fk_zone = '6', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '6', communee = '0', communed = '0', datenl = '2025-07-01', heuenl = '', km = '', ei = 'I', qte = '24.90', picod = '3', punet = '34.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '50', fk_truck = '13', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-07-01', journee = '', email = '', conf_auto = '', non_facturer = '1', hdebut = '07:00', hfin = '16:00', coupure = '00:00:', duree = '9.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '09:45:44', chantier1 = 'GIUSEPPE NUTARELLI', chantier2 = '', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '55047', VilleChantier1 = 'QUERCETA ITALIE', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'DEL BIANCO Jérome', montant = '846.600', contact = 'THIERRY SEGUIN 0607510272', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'THIERRY SEGUIN 0607510272', emailbl = 'demotransvarois@orange.fr', nature = '', poidsnet = '' WHERE idcourse=10011 [11/07/25 12:37:57]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1706', bon = '0710269', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '2', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = 'ETUDES', ar = '', fk_remorque = '0', fk_truck = '16', hexploit = '', obs = '', ref_commande = '121124441121', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'Demander Valérie sur le chantier Tel 05.56.22.32.11', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '03:00', hfin = '07:00', coupure = '00:01:', duree = '3.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '12:37:57', postel = 'admin', datctr = '2025-07-11', heuctr = '12:37:57', chantier1 = '1 Rue Colbert', chantier2 = '19 Rue Penicaud', latitude_enl = '50.627113000', longitude_enl = '3.048432000', latitude_liv = '44.855602000', longitude_liv = '-0.570473000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '59800', VilleChantier1 = 'Lille', CPChantier2 = '33300', VilleChantier2 = 'Bordeaux', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '0.000', contact = 'JEFF 0665460693', fk_qualite = '', faafacturer = '0', contact_enl = 'M. GARRIDO Fernand', divers_address1 = 'BASCULE VAUVERT', emailbl = 'hotline@wininfo.fr', nature = '', poidsnet = '' WHERE idcourse=10269 [11/07/25 12:38:39]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1706', bon = '0710269', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '2', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = 'ETUDES', ar = '', fk_remorque = '0', fk_truck = '16', hexploit = '', obs = '', ref_commande = '121124441121', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'Demander Valérie sur le chantier Tel 05.56.22.32.11', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-07-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '03:00', hfin = '07:00', coupure = '00:01:', duree = '3.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '12:38:39', chantier1 = '1 Rue Colbert', chantier2 = '19 Rue Penicaud', latitude_enl = '50.627113000', longitude_enl = '3.048432000', latitude_liv = '44.855602000', longitude_liv = '-0.570473000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '59800', VilleChantier1 = 'Lille', CPChantier2 = '33300', VilleChantier2 = 'Bordeaux', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '0.000', contact = 'JEFF 0665460693', fk_qualite = '', faafacturer = '0', contact_enl = 'M. GARRIDO Fernand', divers_address1 = 'BASCULE VAUVERT', emailbl = 'hotline@wininfo.fr', nature = '', poidsnet = '' WHERE idcourse=10269 [11/07/25 12:42:21]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1451', bon = '', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '17', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '29', fk_truck = '2', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:00', hfin = '17:00', coupure = '00:01:', duree = '11.00', sms = '0',fk_etat = '2',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '12:42:21', chantier1 = 'Adresse 1', chantier2 = 'Rue Renè Wind', latitude_enl = '43.525717000', longitude_enl = '5.676667000', latitude_liv = '48.750370000', longitude_liv = '6.198566000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '13114', VilleChantier1 = 'Puyloubier', CPChantier2 = '54690', VilleChantier2 = 'Lay-Saint-Christophe', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'PETIT Denis', montant = '0.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=10270 [11/07/25 12:45:53]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1451', bon = '', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '17', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '29', fk_truck = '2', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-07-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:00', hfin = '17:00', coupure = '00:01:', duree = '11.00', sms = '0',fk_etat = '2',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '12:45:53', chantier1 = 'Adresse 1', chantier2 = 'Rue Renè Wind', latitude_enl = '43.525717000', longitude_enl = '5.676667000', latitude_liv = '48.750370000', longitude_liv = '6.198566000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '13114', VilleChantier1 = 'Puyloubier', CPChantier2 = '54690', VilleChantier2 = 'Lay-Saint-Christophe', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'PETIT Denis', montant = '0.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=10270 [11/07/25 12:46:22]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1451', bon = '', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '17', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '29', fk_truck = '2', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-07-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:00', hfin = '17:00', coupure = '00:01:', duree = '11.00', sms = '0',fk_etat = '2',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '12:46:22', chantier1 = 'Adresse 1', chantier2 = 'Rue Renè Wind', latitude_enl = '43.525717000', longitude_enl = '5.676667000', latitude_liv = '48.750370000', longitude_liv = '6.198566000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '13114', VilleChantier1 = 'Puyloubier', CPChantier2 = '54690', VilleChantier2 = 'Lay-Saint-Christophe', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'PETIT Denis', montant = '0.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=10270 [11/07/25 12:48:16]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1451', bon = '', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '17', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '0', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '29', fk_truck = '2', hexploit = '', obs = '', ref_commande = '', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-07-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:00', hfin = '17:00', coupure = '00:01:', duree = '11.00', sms = '0',fk_etat = '2',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '12:48:16', chantier1 = 'Adresse 1', chantier2 = 'Rue Renè Wind', latitude_enl = '43.525717000', longitude_enl = '5.676667000', latitude_liv = '48.750370000', longitude_liv = '6.198566000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '13114', VilleChantier1 = 'Puyloubier', CPChantier2 = '54690', VilleChantier2 = 'Lay-Saint-Christophe', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'PETIT Denis', montant = '0.000', contact = '', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', poidsnet = '' WHERE idcourse=10270 [11/07/25 15:23:36]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1469', bon = '0710275', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '2', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '200.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '16', hexploit = '', obs = '', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'test', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '02:00', coupure = '00:01:', duree = '2.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '15:23:36', postel = 'admin', datctr = '2025-07-11', heuctr = '15:23:36', chantier1 = 'Lahas', chantier2 = '', latitude_enl = '43.645815000', longitude_enl = '1.077743000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '32600', VilleChantier1 = 'L\'Isle-Jourdain', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '200.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10275 [11/07/25 15:24:32]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1469', bon = '0710275', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '2', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '200.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '16', hexploit = '', obs = '', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'test', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-07-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '02:00', coupure = '00:01:', duree = '2.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '15:24:32', chantier1 = 'Lahas', chantier2 = '', latitude_enl = '43.645815000', longitude_enl = '1.077743000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '32600', VilleChantier1 = 'L\'Isle-Jourdain', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '200.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10275 [11/07/25 15:24:53]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1469', bon = '0710275', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '2', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '200.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '16', hexploit = '', obs = '', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'test', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-07-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '02:00', coupure = '00:01:', duree = '2.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '15:24:53', chantier1 = 'Lahas', chantier2 = '', latitude_enl = '43.645815000', longitude_enl = '1.077743000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '32600', VilleChantier1 = 'L\'Isle-Jourdain', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '200.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10275 [11/07/25 15:25:27]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1469', bon = '0710275', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '2', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '200.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '16', hexploit = '', obs = '', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'test', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-07-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '02:00', coupure = '00:01:', duree = '2.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '15:25:27', chantier1 = 'Lahas', chantier2 = '', latitude_enl = '43.645815000', longitude_enl = '1.077743000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '32600', VilleChantier1 = 'L\'Isle-Jourdain', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '200.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10275 [11/07/25 15:26:12]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1469', bon = '0710275', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '2', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-11', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '200.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '16', hexploit = '', obs = '', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'test', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-07-11', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '02:00', coupure = '00:01:', duree = '2.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '15:26:12', chantier1 = 'Lahas', chantier2 = '', latitude_enl = '43.645815000', longitude_enl = '1.077743000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '32600', VilleChantier1 = 'L\'Isle-Jourdain', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '200.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10275 [11/07/25 15:38:34]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1820', bon = '10038', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '3', fk_zone = '6', fk_capacite = '3', fk_capacite_cmd = '3', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-02', heuenl = '', km = '', ei = 'I', qte = '29.95', picod = '3', punet = '19.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '57', fk_truck = '19', hexploit = '', obs = '', ref_commande = 'Affretement 6103241236', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'CHARGEMENT SABLE CDE 1293241', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-07-02', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:00', hfin = '14:00', coupure = '00:00:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '15:38:34', chantier1 = 'USINE DE BEDOIN', chantier2 = 'MAPPEI', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '84410', VilleChantier1 = 'Bedoin', CPChantier2 = '01150', VilleChantier2 = 'St-Vulbas', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BESLIN Patrice', montant = '569.050', contact = 'ISABELLE MAHY 0490659167', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'ISABELLE MAHY 0490659167', emailbl = 'expedition.bedoin@sibelco.com', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10038 [11/07/25 15:39:45]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1820', bon = '10038', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '3', fk_zone = '6', fk_capacite = '3', fk_capacite_cmd = '3', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-02', heuenl = '', km = '', ei = 'I', qte = '29.95', picod = '3', punet = '19.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '57', fk_truck = '19', hexploit = '', obs = '', ref_commande = 'Affretement 6103241236', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'CHARGEMENT SABLE CDE 1293241', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-07-02', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:00', hfin = '14:00', coupure = '00:00:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '15:39:45', chantier1 = 'USINE DE BEDOIN', chantier2 = 'MAPPEI', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '84410', VilleChantier1 = 'Bedoin', CPChantier2 = '01150', VilleChantier2 = 'St-Vulbas', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BESLIN Patrice', montant = '569.050', contact = 'ISABELLE MAHY 0490659167', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'ISABELLE MAHY 0490659167', emailbl = 'expedition.bedoin@sibelco.com', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10038 [11/07/25 15:40:54]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1820', bon = '10038', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '3', fk_zone = '6', fk_capacite = '3', fk_capacite_cmd = '3', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-02', heuenl = '', km = '', ei = 'I', qte = '29.95', picod = '3', punet = '19.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '57', fk_truck = '19', hexploit = '', obs = '', ref_commande = 'Affretement 6103241236', sendstate = '1', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'CHARGEMENT SABLE CDE 1293241', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-07-02', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '06:00', hfin = '14:00', coupure = '00:00:', duree = '8.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-11', heumod = '15:40:54', chantier1 = 'USINE DE BEDOIN', chantier2 = 'MAPPEI', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '84410', VilleChantier1 = 'Bedoin', CPChantier2 = '01150', VilleChantier2 = 'St-Vulbas', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BESLIN Patrice', montant = '569.050', contact = 'ISABELLE MAHY 0490659167', fk_qualite = '', faafacturer = '', contact_enl = '', divers_address1 = 'ISABELLE MAHY 0490659167', emailbl = 'expedition.bedoin@sibelco.com', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10038 [21/07/25 07:36:39]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1523', bon = '0710307', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '15', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2025-07-17', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '750.000', punetliv = '750.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '15', hexploit = '', obs = '', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '02:00', coupure = '00:01:', duree = '1.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-21', heumod = '07:36:39', postel = 'admin', datctr = '2025-07-21', heuctr = '07:36:39', chantier1 = 'Carrié du Cémélaïre', chantier2 = '', latitude_enl = '42.821810000', longitude_enl = '1.996197000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '11340', VilleChantier1 = 'Roquefeuil', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '750.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10307 [21/07/25 07:40:46]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1807', bon = '0710261', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '7', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-09', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '338.000', punetliv = '338.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '39', fk_truck = '8', hexploit = '', obs = '', ref_commande = '3389700/3514264', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'CHARGEMENT TERRE POLLUEE ATTENTION EPI OBLIGATOIRE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '01:00', hfin = '06:00', coupure = '00:00:', duree = '5.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-21', heumod = '07:40:46', postel = 'admin', datctr = '2025-07-21', heuctr = '07:40:46', chantier1 = 'ESSO RAFFINERIE', chantier2 = 'SARPI ROUTE DE ST GILLES', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '34110', VilleChantier1 = 'Frontignan', CPChantier2 = '30127', VilleChantier2 = 'Bellegarde', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LAURENT Denise', montant = '338.000', contact = 'LORY FLIGEAT 06.78.41.36.06', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = 'LORY FLIGEAT 06.78.41.36.06', emailbl = 'hotline@wininfo.fr', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10261 [21/07/25 07:41:19]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1807', bon = '0710261', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '1', fk_zone = '7', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2025-07-09', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '338.000', punetliv = '338.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '39', fk_truck = '8', hexploit = '', obs = '', ref_commande = '3389700/3514264', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = 'CHARGEMENT TERRE POLLUEE ATTENTION EPI OBLIGATOIRE', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-07-09', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '01:00', hfin = '06:00', coupure = '00:00:', duree = '5.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-21', heumod = '07:41:19', chantier1 = 'ESSO RAFFINERIE', chantier2 = 'SARPI ROUTE DE ST GILLES', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '34110', VilleChantier1 = 'Frontignan', CPChantier2 = '30127', VilleChantier2 = 'Bellegarde', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'LAURENT Denise', montant = '338.000', contact = 'LORY FLIGEAT 06.78.41.36.06', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = 'LORY FLIGEAT 06.78.41.36.06', emailbl = 'hotline@wininfo.fr', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10261 [23/07/25 08:43:21]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1519', bon = '0710327', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '18', fk_zone = '6', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-23', heuenl = '', km = '', ei = 'I', qte = '121.12', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '0', fk_truck = '5', hexploit = '', obs = '', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '02:00', hfin = '07:00', coupure = '00:00:', duree = '5.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-23', heumod = '08:43:21', postel = 'admin', datctr = '2025-07-23', heuctr = '08:43:21', chantier1 = 'Carré', chantier2 = 'Rue Renè Wind', latitude_enl = '48.385859000', longitude_enl = '-2.195752000', latitude_liv = '48.750370000', longitude_liv = '6.198566000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '22980', VilleChantier1 = 'Languédias', CPChantier2 = '54690', VilleChantier2 = 'Lay-Saint-Christophe', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '0', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '0', poidsnet = '' WHERE idcourse=10327 [29/07/25 08:29:16]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1724', bon = '0710317', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '2', fk_zone = '5', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '1', communee = '0', communed = '0', datenl = '2025-07-21', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '46', fk_truck = '16', hexploit = '', obs = '', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '11:00', hfin = '21:00', coupure = '00:00:', duree = '10.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-07-29', heumod = '08:29:16', postel = 'admin', datctr = '2025-07-29', heuctr = '08:29:16', chantier1 = 'Chantiers Ostréicoles Pors Trez', chantier2 = '', latitude_enl = '48.665096000', longitude_enl = '-3.900588000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '29660', VilleChantier1 = 'Carantec', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'BERTIN Mickael', montant = '0.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10317 [1/08/25 12:42:46]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1527', bon = '0710263', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '13', fk_zone = '1', fk_capacite = '1', fk_capacite_cmd = '1', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2025-07-09', heuenl = '', km = '', ei = 'I', qte = '1.00', picod = '3', punet = '0.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '39', fk_truck = '10', hexploit = '', obs = '', ref_commande = '', sendstate = '9', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '00:00', hfin = '01:00', coupure = '00:01:', duree = '0.00', sms = '1',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-08-01', heumod = '12:42:46', postel = 'admin', datctr = '2025-08-01', heuctr = '12:42:46', chantier1 = 'Carrière', chantier2 = '', latitude_enl = '43.236566000', longitude_enl = '1.186905000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '31310', VilleChantier1 = 'Rieux-Volvestre', CPChantier2 = '', VilleChantier2 = '', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = '', montant = '0.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = '', emailbl = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=10263 [30/10/25 17:13:25]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1724', bon = '1011827', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '5', fk_zone = '6', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2025-10-30', heuenl = '', km = '', ei = 'I', qte = '7.00', picod = '3', punet = '13.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '49', fk_truck = '4', hexploit = '', obs = 'GRAVE', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '17:00', coupure = '00:00:', duree = '10.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-10-30', heumod = '17:13:25', postel = 'admin', datctr = '2025-10-30', heuctr = '17:13:25', chantier1 = 'LRM', chantier2 = 'LRM', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '34400', VilleChantier1 = 'Lunel', CPChantier2 = '34400', VilleChantier2 = 'Lunel', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'DEL BIANCO Jérome', montant = '91.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = 'EMILIE 0674987805', emailbl = '', maildes = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=11827 [30/10/25 17:13:52]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1724', bon = '1011827', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '5', fk_zone = '6', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2025-10-30', heuenl = '', km = '', ei = 'I', qte = '7.00', picod = '3', punet = '13.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '49', fk_truck = '4', hexploit = '', obs = 'GRAVE', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-10-30', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '17:00', coupure = '00:00:', duree = '10.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-10-30', heumod = '17:13:52', chantier1 = 'LRM', chantier2 = 'LRM', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '34400', VilleChantier1 = 'Lunel', CPChantier2 = '34400', VilleChantier2 = 'Lunel', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'DEL BIANCO Jérome', montant = '91.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = 'EMILIE 0674987805', emailbl = '', maildes = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=11827 [30/10/25 17:25:06]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1724', bon = '1011827', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '5', fk_zone = '6', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2025-10-30', heuenl = '', km = '', ei = 'I', qte = '7.00', picod = '3', punet = '13.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '49', fk_truck = '4', hexploit = '', obs = 'GRAVE', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-10-30', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '17:00', coupure = '00:00:', duree = '10.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-10-30', heumod = '17:25:06', chantier1 = 'LRM', chantier2 = 'LRM', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '34400', VilleChantier1 = 'Lunel', CPChantier2 = '34400', VilleChantier2 = 'Lunel', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'DEL BIANCO Jérome', montant = '91.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = 'EMILIE 0674987805', emailbl = '', maildes = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=11827 [30/10/25 17:55:34]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1724', bon = '1011827', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '5', fk_zone = '6', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2025-10-30', heuenl = '', km = '', ei = 'I', qte = '7.00', picod = '3', punet = '13.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '49', fk_truck = '4', hexploit = '', obs = 'GRAVE', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '2025-10-30', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '17:00', coupure = '00:00:', duree = '10.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-10-30', heumod = '17:55:34', chantier1 = 'LRM', chantier2 = 'LRM', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '34400', VilleChantier1 = 'Lunel', CPChantier2 = '34400', VilleChantier2 = 'Lunel', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'DEL BIANCO Jérome', montant = '91.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = 'EMILIE 0674987805', emailbl = '', maildes = '', nature = '', forfait_tournee = '', btournee = '1', poidsnet = '' WHERE idcourse=11827 [30/10/25 18:17:11]UPDATE llx_tr_courses SET entity = '1', fk_soc = '1724', bon = '1011827', fk_propal = '', prix_decharge = '0.00', prix_decharge2 = '0.00', prix_decharge3 = '0.00', prix_cubage = '0.00', nb_tour = '0', fk_livreur = '5', fk_zone = '6', fk_capacite = '1', fk_capacite_cmd = '2', fk_regular = '0', fk_coutype = '0', exped = '', desti = '', fk_type = '2', communee = '0', communed = '0', datenl = '2025-10-30', heuenl = '', km = '', ei = 'I', qte = '7.00', picod = '3', punet = '13.000', punetliv = '0.000', autoc = '0.00', autocttc = '0.00', autol = '0.00', service = '', ar = '', fk_remorque = '49', fk_truck = '4', hexploit = '', obs = 'GRAVE', ref_commande = '', sendstate = '2', sendedi = '', classe = '', onu = '', emballage = '', poids = '', fraiscr = '', note = '', obsexp = '', obsdes = '', addressexp = '', addressdes = '', heuliv = '', datliv = '--2025-10-30', journee = '', email = '', conf_auto = '', non_facturer = '', hdebut = '07:00', hfin = '17:00', coupure = '00:00:', duree = '10.00', sms = '0',fk_etat = '4',fk_type_benne = '', postem = 'admin', datmod = '2025-10-30', heumod = '18:17:11', chantier1 = 'LRM', chantier2 = 'LRM', latitude_enl = '0.000000000', longitude_enl = '0.000000000', latitude_liv = '0.000000000', longitude_liv = '0.000000000', AdresseEnlevTransf = '', AdresseLivTransf = '', CPChantier1 = '34400', VilleChantier1 = 'Lunel', CPChantier2 = '34400', VilleChantier2 = 'Lunel', CPEnlevTransf = '', VilleEnlevTransf = '', CPLivTransf = '', VilleLivTransf = '', PositionTournee = '', fk_VoiturePilote = '', livinterim = 'DEL BIANCO Jérome', montant = '91.000', contact = '', fk_qualite = '', faafacturer = '0', contact_enl = '', divers_address1 = 'EMILIE 0674987805', emailbl = '', maildes = '', nature = '', forfait_tournee = '', btournee = '1', fk_specification = '4', poidsnet = '' WHERE idcourse=11827