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]'))";
} |
