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 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
|
$informations = strtolower(@$_GET['informations']);
$informations = str_replace(", ", " ", trim($informations));
$informations = str_replace(",", " ", $informations);
$informations = str_replace("; ", " ", $informations);
$informations = str_replace(";", " ", $informations);
$informations = str_replace("+", " ", $informations);
$informations = str_replace("\"", " ", $informations);
$informations = str_replace(":", " ", $informations);
$tab=explode(" " , $informations);
if ($tab[0] != '' || $tab[1] != '' || $tab[2] != '') {
if (ereg ("([0-9]{5})", $tab[0])) {
$val1 = $tab[0];
} else {
$val_mini1 = "00000";
$val_maxi1 = "99999";
}
if (ereg ("([0-9]{5})", $tab[1])) {
$val2 = $tab[1];
} else {
$val_mini2 = "00000";
$val_maxi2 = "99999";
}
if (ereg ("([0-9]{5})", $tab[2])) {
$val3 = $tab[2];
} else {
$val_mini3 = "00000";
$val_maxi3 = "99999";
}
$fourchette = '100';
$fourchette = intval(substr($fourchette,0,3));
$val1 = intval($val1);
$val2 = intval($val2);
$val3 = intval($val3);
if ($val1 < 0) $val1 = -$val1;
if ($val2 < 0) $val2 = -$val2;
if ($val3 < 0) $val3 = -$val3;
$departm1 = intval($val1/1000);
$departm2 = intval($val2/1000);
$departm3 = intval($val3/1000);
$departm_mini1 = 1000*$departm1;
$departm_mini2 = 1000*$departm2;
$departm_mini3 = 1000*$departm3;
$departm_maxi1 = $departm_mini1 + 999;
$departm_maxi2 = $departm_mini2 + 999;
$departm_maxi3 = $departm_mini3 + 999;
$val_mini1 = $val1-$fourchette;
$val_mini2 = $val2-$fourchette;
$val_mini3 = $val3-$fourchette;
$val_maxi1 = $val1+$fourchette;
$val_maxi2 = $val2+$fourchette;
$val_maxi3 = $val3+$fourchette;
if ($val_mini1 < $departm_mini1) $val_mini1 = $departm_mini1;
if ($val_mini2 < $departm_mini2) $val_mini2 = $departm_mini2;
if ($val_mini3 < $departm_mini3) $val_mini3 = $departm_mini3;
if ($val_maxi1 > $departm_maxi1) $val_maxi1 = $departm_maxi1;
if ($val_maxi2 > $departm_maxi2) $val_maxi2 = $departm_maxi2;
if ($val_maxi3 > $departm_maxi3) $val_maxi3 = $departm_maxi3;
$query_search .= "
AND ((products.codepostal BETWEEN '$val_mini1' AND '$val_maxi1')
OR (products.codepostal BETWEEN '$val_mini2' AND '$val_maxi2')
OR (products.codepostal BETWEEN '$val_mini3' AND '$val_maxi3')
OR (products.departement = '$tab[0]') OR (products.ville = '$tab[0]') OR (products.codepostal = '$tab[0]')
OR (products.departement = '$tab[1]') OR (products.ville = '$tab[1]') OR (products.codepostal = '$tab[1]')
OR (products.departement = '$tab[2]') OR (products.ville = '$tab[2]') OR (products.codepostal = '$tab[2]'))";
} |
Partager