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 81 82 83 84 85
| <?php
declare(strict_types=1);
use Classes\olivier\Site; //pareil
use Classes\olivier\User; //pareil
use Classes\olivier\Country; //pareil
use Classes\olivier\Priority; //pareil
use Classes\olivier\Status; //pareil
use Classes\olivier\Organization; //pareil
use Classes\olivier\IncidentType; //pareil
use Classes\olivier\ReportedSource; //pareil
use Classes\olivier\CSVUpload; //que dans modif
use Classes\olivier\CSVFile; //que dans modif
use Classes\olivier\CSVParser; //que dans modif
use Classes\olivier\CSVinBDD; //que dans modif
use Classes\olivier\Ticket; //pareil
use Classes\olivier\utilFct;
use vendor\PhpEcho\PhpEcho;
use vendor\rawsrc\Request;
use classes\MYPDO; //to use class MYPDO
//include "menu.html";
// display of the menu
$page = new PhpEcho([DIR_ROOT, 'view Layout.php']);
$body = new PhpEcho([DIR_ROOT, 'menu.php'], [
'action1' => 'view',
'action2' => 'controller']);
$page['body'] = $body;
// on renvoie au navigateur la page assemblée
echo $page;
$CSV_file1=new CSVUpload(); // upload of the file
$CSV_file1->formCsvARMToDb();
$CSV_file_check1=new CSVFile();
$ret=$CSV_file_check1->checkFile(); // to check if it is well a CSV file
if ($ret) {
$csv_parser = new CSVParser($_FILES['file2']);
$founded=$CSV_file_check1->checkAlreadyBDD($csv_parser); //to check if the file is already registered
//var_dump($founded);
if ($founded)
{ // faire update
$val=$csv_parser->parse($_FILES['file2']);
//var_dump($val);
if (isset($val['content_array']))
{
$CSV_in_bdd=new CSVInBDD();
$ret=$CSV_in_bdd->updateBdd($val['content_array'],$val['type_csv'],$val['id']); // update
}
$body = new PhpEcho('', ['msg_end' => $_FILES['file2']['name']." was already in the bdd. Update is done"]);
$body->setCode('<p>'.$body('msg_end').'</p>');
echo $body;
}
else
{
$val=$csv_parser->parse($_FILES['file2']);
//var_dump($val['error']);
if ($val['error'])
{
$body = new PhpEcho('', ['msg_error' => "error of format: ".$val['error']]);
$body->setCode('<p>'.$body('msg_error').'</p>');
echo $body;
}
else if (isset($val['content']))
{//var_dump($val);
$CSV_in_bdd=new CSVInBDD();
//var_dump($val['content']);
$ret=$CSV_in_bdd->createBdd($val['content'],$val['type_csv']); // insert
if ($ret)
{
$body = new PhpEcho('', ['msg_end' => $_FILES['file2']['name']." fully processed, without errors."]);
$body->setCode('<p>'.$body('msg_end').'</p>');
echo $body;
}
else{
$body = new PhpEcho('', ['msg_error' => $_FILES['file2']['name']." has not been put in BDD."]);
$body->setCode('<p>'.$body('msg_error').'</p>');
echo $body;
}
}
}
} |
Partager