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);
} |
Partager