1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| $annee = date("Y");
$mois = date("m");
$jour = date("d");
$date_du_jour = date("Y-m-d");
$un_trim = mktime(0,0,0,01,01,$annee);
$deux_trim = mktime(0,0,0,04,01,$annee);
$trois_trim = mktime(0,0,0,07,01,$annee);
$quatre_trim = mktime(0,0,0,10,01,$annee);
$time_jour = mktime(0,0,0,$mois,$jour,$annee);
if($time_jour == $un_trim || $time_jour == $deux_trim ||$time_jour == $trois_trim ||$time_jour == $quatre_trim){
$sql = "SELECT * FROM mailing_parcauto WHERE trimestre='$date_du_jour'";
$req = mysql_query($sql);
$nbr = mysql_fetch_row($req);
if($nbr == 0){
cree_releve();//on lance le traitement.
//on insère dans la table pour stocker que l'envoie pour ce jour est fait.
$sql2 = "INSERT INTO mailing_parcauto (idmailing_parcauto,trimestre) VALUES ('','$date_du_jour')";
mysql_query($sql2);
}
} |
Partager