Historique de la page
Quotidien à 7h : Dénomination du fichier : MAT_EP_AGENT / MAT_EP_KPI
Liens IT : Scripts génériques epptf
Exemple de prod
...
3.2 Modalité d'alimentation des indicateurs
mysql $MYSQL -e"select
CONCAT_WS(';','02',c1.account_id, c1.name, 'NBCLIAGENT', count(distinct c2.siret), 'Q')
from EPDATAP.MERCHANT_CONTRACT c1, EPDATAP.MERCHANT_CONTRACT c2
where c1.TOP_AGENT='1'
and c2.TOP_AGENT ='2'
and c2.SIRET_AGENT =c1.siret
and c1.CASHOUT =1
and c2.CASHOUT =1
and DATE_FORMAT(c2.CREATION_DATE, '%Y-%m-%d-%T') <= date_format(ADDDATE( LAST_DAY(SYSDATE()), INTERVAL -2 MONTH), '%Y-%m-%d-23:59:59')
and (c2.DATE_RESILIATION is NULL or (DATE_FORMAT(c2.DATE_RESILIATION, '%Y-%m-%d') > date_format(ADDDATE( sysdate(), INTERVAL -2 MONTH), '%Y-%m-31')))
-- and c2.CREATION_DATE < '$annee-$mois-$jour'
-- and (c2.DATE_RESILIATION is null or c2.DATE_RESILIATION > '$annee-$mois-$jour')
group by c1.name, c1.account_id
;Cf la prod