-- ---------------------------------------------------------------
-- Insertion des opérations de régul transactions cartes
-- ---------------------------------------------------------------
insert into operation_regul(
version,statut,montant_transaction,operation_id,type,date_transaction,numero_operation)
select 0,'SA',a.montant_transaction,a.id,'C',a.date_transaction,a.numero_operation
from operation a left outer join carte b on a.carte_emettrice_id=b.id
where a.id not in (select b.operation_id from ecriture b) 
and a.date_transaction >= '2021-01-01'
and a.ticket_carburant_id is  null
and a.id not in (select operation_id from operation_regul)
and a.statut = 'VA'
order by a.date_transaction ;

-- ---------------------------------------------------------------
-- Insertion des opérations de régul transactions tickets
-- ---------------------------------------------------------------
insert into operation_regul(
version,statut,montant_transaction,operation_id,type,date_transaction,numero_operation)
select 0,'SA',a.montant_transaction,a.id,'T',a.date_transaction,a.numero_operation
from operation a left outer join carte b on a.carte_emettrice_id=b.id
where a.id not in (select b.operation_id from ecriture b) 
and a.date_transaction >= '2021-01-01'
and a.ticket_carburant_id is not null
and a.id not in (select operation_id from operation_regul)
and a.statut = 'VA'
order by a.date_transaction ;