1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
|
select D.idclient, D.domaine, date_format(D.date_sous,'%d/%m/%Y') as date_sous,
date_format(D.date_sous,'%Y-%m-%d') as souscription_ordre, D.num_dossier,
C.societe, C.contact, C.etat, C.charge_affaire, O.societe as operateur, P.raison,
IF(C.rappel_on,date_format(C.rappel,'%d/%m/%Y %H:%i'),'') as rappel,
IF(C.rappel_on,date_format(C.rappel,'%Y-%m-%d %H:%i'),'') as rappel_ordre
FROM [color=red]tfp_demande_tf[/color] D,
tfp_client C
left join tfp_operateur as O on D.idop_fixe=O.idop
left join presc_lien as L on L.code=substring(D.idprescripteur,1,6)
left join presc_data as P on P.iddata=L.iddata
WHERE D.idclient>0
AND C.etat="$ref_etat"
AND C.rappel_on='1'
AND C.charge_affaire like '%$ref_charge_affaire%'
AND D.domaine=$ref_domaine
AND C.societe like '%$ref_societe%'
AND C.contact like '%$ref_contact%'
AND C.rappel>='$ref_da-$ref_dm-$ref_dj' and C.rappel<='$ref_fa-$ref_fm-$ref_fj 23:59:59'
and D.idclient=C.idclient
select D.idclient, D.domaine, date_format(D.date_sous,'%d/%m/%Y') as date_sous,
date_format(D.date_sous,'%Y-%m-%d') as souscription_ordre, D.num_dossier,
C.societe, C.contact, C.etat, C.charge_affaire, O.societe as operateur, P.raison,
IF(C.rappel_on,date_format(C.rappel,'%d/%m/%Y %H:%i'),'') as rappel,
IF(C.rappel_on,date_format(C.rappel,'%Y-%m-%d %H:%i'),'') as rappel_ordre
FROM [color=red]tfp_demande_tm[/color] D,
tfp_client C
left join tfp_operateur as O on D.idop_fixe=O.idop
left join presc_lien as L on L.code=substring(D.idprescripteur,1,6)
left join presc_data as P on P.iddata=L.iddata
WHERE D.idclient>0
AND C.etat="$ref_etat"
AND C.rappel_on='1'
AND C.charge_affaire like '%$ref_charge_affaire%'
AND D.domaine=$ref_domaine
AND C.societe like '%$ref_societe%'
AND C.contact like '%$ref_contact%'
AND C.rappel>='$ref_da-$ref_dm-$ref_dj' and C.rappel<='$ref_fa-$ref_fm-$ref_fj 23:59:59'
and D.idclient=C.idclient |
Partager