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
| if ($csv = fopen('./file_upload/monfichier.csv', "r"))
{
$row = 1;
fgetcsv($csv);
$i = 0;
while (($data = fgetcsv($csv, 1555, ";"))) {
$id_coursier = intval($data[3]);
$date_engagement = date('Y-m-d', strtotime(str_replace('/', '-', $data[13])));
$date_insert = date('Y-m-d', strtotime(str_replace('/', '-', $data[15])));
$numero_sim = trim($data[1],"/'");
$numero_ligne = trim($data[4],"/'");
$req_data = "SELECT numero_ligne FROM lignes_telephoniques where numero_ligne = " . $numero_ligne . " ;";
$res_data = $db->getAll($req_data);
if(isset($res_data) && !empty($res_data)) {echo "IF <br><br>";
$info_ligne = "UPDATE lignes_telephoniques
SET
numero_sim = '$data[1]',
agence = '$data[2]',
id_coursier = '$id_coursier',
numero_ligne = '$data[4]',
tel_fixe = '$data[5]',
groupe_vpn = '$data[6]',
data = '$data[7]',
sms = '$data[8]',
num_speciaux = '$data[9]',
commentaire = '$data[10]',
operateur = '$data[11]',
forfait = '$data[12]',
date_engagement = '$date_engagement',
duree = '$data[14]',
date_insert = '$date_insert',
stock = '$data[16]',
date_inactivite = '$date_inactivite',
appel_international = '$data[18]',
blockage_appel_sortant = '$data[19]',
ligne_supprime = '$data[20]',
num_court = '$data[21]'
WHERE
numero_ligne = $numero_ligne";
}
$result_info = $db->execute($info_ligne);
$i++;
}
fclose($csv);
} |
