<form method="post"  enctype="multipart/form-data">
 
 <div class="form-group">
                <label for="m11">upload :</label>
                <input type="file" id="pdf_upload"  accept="image/*"  name="image" class="form-control"    style="height:40px;font-size:15px;color:#000000" required>
               <div class="help-block with-errors"></div>
              </div>
              <input type="submit" name="button_action" id="button_action" class="btn btn-success btn-sm" style="font-weight:bold" value="Add" />
</form>
<script>
            $.ajax({
                url:"ajax_action.php",
                method:"POST",
                data:$(this).serialize(),
                dataType:"json",
                beforeSend:function(){
                 
                },
                success:function(data)
                {
                    if(data.success)
                    {
                                        Swal.fire({
                                      title: "true",
                                      icon: "success",
                                      text: " ",
                                        showConfirmButton: false,
                                        timer: 1500
                                       
                                    });
                    }
                   else
                   {
                        Swal.fire({
                                      title: "false",
                                      icon: "error",
                                      text: " ",
                                        showConfirmButton: false,
                                        timer: 1500
                                       
                                    });
                   }
                }
            });
    </script>

<?php
 
       if (isset($_FILES['image']) ) {
    $title = trim($_POST['title']);
 
    // File metadata
    $file = $_FILES['image'];
    $fileName = $file['name'];
    $fileTmpName = $file['tmp_name'];
    $fileError = $file['error'];
    $fileSize = $file['size'];
 
    // Define allowed extensions and MIME types for safety
    $allowedExtensions = ['jpg', 'jpeg', 'png', 'webp'];
    $fileExt = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
 
    // Basic Validation
    if ($fileError !== 0) {
        die("Error uploading file.");
    }
 
    if (!in_array($fileExt, $allowedExtensions)) {
        die("Invalid file type. Only JPG, JPEG, PNG, and WEBP are allowed.");
    }
 
    if ($fileSize > 5 * 1024 * 1024) { // 5MB Limit
        die("File is too large. Maximum size is 5MB.");
    }
 
    // Generate a unique file name to prevent overriding existing files
    $newFileName = uniqid('IMG_', true) . '.' . $fileExt;
    $uploadFolder = 'pdf/';
    $targetFilePath = $uploadFolder . $newFileName;
 
    // 3. Move the file to the target directory and update the database
    if (move_uploaded_file($fileTmpName, $targetFilePath)) {
 
              $exam->data = array(
                ':id'               =>   $_SESSION['user_id'],
 
                ':filename' =>    $fileName
 
 
            );
 
                $exam->query = "
            INSERT INTO tableimages                                  
            (id,filename)
             
            VALUES (:id,:filename)
            ";
 
            $exam->execute_query();
 
 
            $output = array(
                'success'   =>   'add'
            );
 
            echo json_encode($output);
 
 
         }
        else
 
            {
                    $output = array(
                'er'    =>   'no add'
                );
 
               echo json_encode($output);
 
            }
 
 
        }
?>

$req=$bdd->prepare('SELECT name FROM user LIMIT :offset, :nbUser');
$req->bindParam('offset', $offset, PDO::PARAM_INT);
$req->bindParam('nbUser', $nbUser, PDO::PARAM_INT);
$req->execute();

$req=$bdd->prepare('SELECT name FROM user LIMIT :offset, :nbUser');
$req->execute(array('offset'=>$offset,'nbUser'=>$nbUser));

$sql_select ='SELECT fi.id_field, fi.field_name, st.id_station, st.station_name, st.station_longname, st.station_archive, st.station_active, sty.stations_type_awe, st.stations_types_id_stations_type, st.station_lat, st.station_lng, st.station_alt, st.alarm_is_enabled, sty.stations_type_name, se.id_sensor, se.sensor_active, se.sensor_name, se.sensor_longname, se.chart_borderWidth, se.chart_pointRadius, se.chart_pointHoverRadius, se.chart_showLine, se.chart_fill, sey.id_sensor_type, sey.sensor_type_name, sey.sensor_type_longname, sey.sensor_type_awe, sey.measure_unit, cs.chart_style_name, uf.roles_id_role, sndbu.notification_disabled, sndbu.sndbu_onesignalExtId,
			cp.chart_pointStyle_value, th.threshold_max, th.threshold_min, th.threshold_operator,
			col_bg.color_name as bg_color_name, 
			col_bg.color_value as bg_color_value,
			col_bd.color_name as bd_color_name, 
			col_bd.color_value as bd_color_value
			FROM fields AS fi
			INNER JOIN users_has_fields AS uf ON fi.id_field = uf.fields_id_field
			RIGHT JOIN stations AS st ON fi.id_field = st.fields_id_field
 
		LEFT JOIN stations_notification_disable_by_user AS sndbu ON st.id_station = sndbu.stations_id_station
 
			INNER JOIN sensors AS se ON st.id_station = se.stations_id_station
			INNER JOIN stations_types as sty ON st.stations_types_id_stations_type = sty.id_stations_type
			INNER JOIN chart_backgroundColor AS cbgc on cbgc.id_chart_backgroundColor=se.chart_backgroundColor_id_chart_backgroundColor
			INNER JOIN colors AS col_bg on cbgc.colors_id_colors=col_bg.id_colors
			INNER JOIN chart_borderColor AS cbdc on cbdc.id_chart_borderColor=se.chart_borderColor_id_chart_borderColor
			INNER JOIN colors AS col_bd on cbdc.colors_id_colors=col_bd.id_colors
			INNER JOIN chart_style as cs ON se.chart_style_id_chart_style = cs.id_chart_style
			INNER JOIN chart_pointStyle AS cp on se.chart_pointStyle_id_chart_pointStyle = cp.id_chart_pointStyle
			INNER JOIN sensor_types as sey ON se.sensor_types_id_sensor_type = sey.id_sensor_type
			LEFT JOIN thresholds as th ON se.id_sensor = th.sensors_id_sensor
			WHERE '.$whereFieldId.' st.station_active = 1 AND st.map = 1 AND fi.field_active = 1 AND uf.users_id_user = '.$user_id.' AND se.sensor_active = 1
			ORDER BY sty.stations_type_name ASC, fi.id_field ASC, st.station_longname ASC, se.sensor_longname ASC';
 
		$sql_result = $connect->query($sql_select);

 
$sql_delete ='DELETE FROM sensor_mute_by_user WHERE mute_until < "'.$response['now'].'"';
 
    $connect->query($sql_delete);
    $nb = $connect->affected_rows;
    if($nb > 0){
		echo 'delete '.$nb.' row';
    }
    else{
    	echo 'not delete';
    }

// $content
Array
(
    [0] => Array
        (
            [id_collection] => 309001
            [id_station] => 43
            [id_sensor] => 154
            [messageFR_db] => [1: 15cm] La mesure 24kPa doit se situer entre 30.00kPa et 60.00kPa
            [messageEN_db] => [1: 15cm] The measure 24kPa must be between  30.00kPa and 60.00kPa
            [messageFR] => La sonde [1: 15cm] est déclenchée
            [messageEN] => the sensor [1: 15cm] is trigged
            [operator] => <>
        )
 
    [1] => Array
        (
            [id_collection] => 309001
            [id_station] => 43
            [id_sensor] => 155
            [messageFR_db] => [2: 25cm] La mesure 17kPa ne doit pas se situer entre 10.00kPa et 60.00kPa
            [messageEN_db] => [2: 25cm] The measure 17kPa must not be between 10.00kPa and 60.00kPa
            [messageFR] => La sonde [2: 25cm] est déclenchée
            [messageEN] => the sensor [2: 25cm] is trigged
            [operator] => ><
        )
 
    [2] => Array
        (
            [id_collection] => 309001
            [id_station] => 43
            [id_sensor] => 158
            [messageFR_db] => [Pluie] la mesure 0mm est en dessous du seuil 30.00mm
            [messageEN_db] => [Pluie] The measure 0mm is below the thresold  30.00mm
            [messageFR] => La sonde [Pluie] est déclenchée
            [messageEN] => the sensor [Pluie] is trigged
            [operator] => >
        )
 
)

if(count($content) > 0){
 
                /* 
                * SAVE ALARM INTO THE notifications TABLE 
                */
 
                foreach($content) as $k => $v{
                    // Prepare the MySQL request
                    $sql_insert_notifications = 'INSERT into notifications (
                        id_notification,
                        stations_id_station, 
                        sensors_id_sensor,
                        collections_id_collection,
                        notification_date,
                        notification_message_fr,
                        notification_message_en
 
                    ) VALUES (
                        "",
                        "'.$v['id_station'].'",
                        "'.$v['id_sensor'].'",
                        "'.$v['id_collection'].'",
                        "'.gmdate("Y-m-d H:i:s").'",
                        "'.$v['messageFR_db'].'",
                        "'.$v['messageEN_db'].'"
                    )';
 
                    if (!$_connect->query($sql_insert_notifications) )
                    {
                        if($debug) printf("Erreur : %s\n", $connect->error);
                    }else{
                        if($debug) echo "<p>Alarm inserted</p>";
                    }
 
 
                }
}

$sql_insert_notifications = "INSERT INTO notifications (
                    id_notification,
                    stations_id_station, 
                    sensors_id_sensor,
                    collections_id_collection,
                    notification_date,
                    notification_message_fr,
                    notification_message_en
                ) VALUES
                    ('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en'),
                    ('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en'),
                    ('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en' )";
 
 
                if ($_connect->multi_query($sql_insert_notifications) === TRUE) {
                  echo "New records inserted successfully";
                } else {
                  echo "Error: " . $sql . "<br>" . $conn->error;

('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en'),
                    ('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en'),
                    ('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en' )

VALUES
                    ('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en'),
                    ('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en'),
                    ('', 'stations_id_station', 'sensors_id_sensor', 'collections_id_collection', 'notification_date', 'notification_message_fr','notification_message_en' )"

 
            if(!(is_numeric($score)) && (strlen($score) > 4) && (empty($score)) && ($score > 212)){
                $this->addFlash('error','Problème de donnée dans le champ "Score"');
                return $this->redirectToRoute('signalement.upload');  
            }

 
	$sql = '
/*création table global*/
DROP TABLE IF EXISTS `global`;
CREATE TABLE global ( `id` int NOT NULL, `sem` int NOT NULL, `l` int NOT NULL, `j` int NOT NULL);
/*création table temporaire semaine*/	
CREATE TEMPORARY TABLE semaine ( `sem` int NOT NULL, `total_l` int NOT NULL, `total_j` int NOT NULL);
/*insersion des valeurs*/
INSERT INTO semaine SELECT WEEK(`date`,4) AS `sem` , SUM(`nbre`) AS `total_l`, 0 as `total_j` 
FROM `presence` INNER JOIN `guides` ON `presence`.`id_guide` = `guides`.`id_guide` WHERE DAYOFWEEK( `date` ) = 2 AND `date` > '.$periode[1].' AND `date` < '.$periode[2].' GROUP BY `date` ORDER BY `date`;
INSERT INTO semaine SELECT WEEK(`date`,4) AS `sem` , 0 as `total_l`, SUM(`nbre`) AS `total_j` 
FROM `presence` INNER JOIN `guides` ON `presence`.`id_guide` = `guides`.`id_guide` WHERE DAYOFWEEK( `date` ) = 5 AND `date` > '.$periode[1].' AND `date` < '.$periode[2].' GROUP BY `date` ORDER BY `date`;
/*ajout index*/
ALTER TABLE `semaine` ADD `id` INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`); 
/*recopie des données*/
INSERT INTO `global` SELECT MIN(id) as id, sem, SUM(COALESCE(total_l, 0)) AS l, SUM(COALESCE(total_j, 0)) AS j FROM  semaine GROUP BY sem ORDER BY id;';
	$pdo->query($sql);
//extraction des données	
	$stmt = $pdo->query('SELECT * FROM `global`');
	foreach($stmt AS $row)
		{//concaténation des données
		$data .= '[\''.$row['sem'].'\','.$row['l'].','.$row['j'].'],';}

                $sql = 'SELECT departement, COUNT(*) as total FROM article GROUP BY departement';
                $query = mysqli_query($conn,$sql) or die;
				while($tableau = mysqli_fetch_array($query)){
 
                    echo "<table> \n";
                    echo "<tr> \n";
                    echo "<tr> \n";
                    echo "<td>".$tableau["departement"]."</td> \n";
                    echo "<td>".$tableau["total"]."</td> \n";
                    echo "</tr> \n";
                    echo "</table> \n";
				}

 
Array
(
)
<br />
<b>Warning</b>:  Undefined array key "pdf" in <b>C:\xampp\htdocs\marche\gpx\ressources\serveur\FonctionsServeur.php</b> on line <b>25</b><br />
<br />
<b>Warning</b>:  Undefined array key "pdf" in <b>C:\xampp\htdocs\marche\gpx\ressources\serveur\FonctionsServeur.php</b> on line <b>26</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>C:\xampp\htdocs\marche\gpx\ressources\serveur\FonctionsServeur.php</b> on line <b>26</b><br />
<br />
<b>Warning</b>:  Undefined array key "pdf" in <b>C:\xampp\htdocs\marche\gpx\ressources\serveur\FonctionsServeur.php</b> on line <b>27</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>C:\xampp\htdocs\marche\gpx\ressources\serveur\FonctionsServeur.php</b> on line <b>27</b><br />
<br />
<b>Deprecated</b>:  move_uploaded_file(): Passing null to parameter #1 ($from) of type string is deprecated in <b>C:\xampp\htdocs\marche\gpx\ressources\serveur\FonctionsServeur.php</b> on line <b>28</b><br />

 
Array ( [pdf] => Array ( [name] => poeme_hewaien.pdf [full_path] => poeme_hewaien.pdf [type] => application/pdf [tmp_name] => C:\xampp\tmp\phpFBFA.tmp [error] => 0 [size] => 1384535 ) )
 Array ( [name] => poeme_hewaien.pdf [full_path] => poeme_hewaien.pdf [type] => application/pdf [tmp_name] => C:\xampp\tmp\phpFBFA.tmp [error] => 0 [size] => 1384535 )

 
//Téléchargement fichier
function upload($path,$type){
	if($type == 'gpx' || $type == 'png' || $type == 'pdf' || $type == 'xlsx'){
		print_r($_FILES);
		print_r($_FILES[$type]);
		$fichier = $_FILES[$type]['name'];
		$temp_name = $_FILES[$type]['tmp_name'];
		if(move_uploaded_file($temp_name, $path."/".$fichier)){
			rename($path."/".$fichier, str_replace("_","-",$path."/".$fichier));
			$info = "Fichier enregistré:".$fichier;
		}else{
			$info = "Enregistrement Nok";}
	}
	else{
		$info = "Enregistrement Nok";}
return $info;
}