/trunk/applications/jrest/services/OdsObservation.php |
---|
37,6 → 37,27 |
} |
private function getAnneeMinimumObservation() { |
$requete_annee_min_obs = 'SELECT MIN(YEAR(oo_date)) as min_annee FROM ods_observations '. |
'WHERE oo_date != "0000-00-00"'; |
$resultat_min_annee_obs = $this->executerRequete($requete_annee_min_obs); |
return !empty($resultat_min_annee_obs) ? $resultat_min_annee_obs[0]['min_annee'] : Date('Y'); |
} |
private function getAnneesAyantObservations() { |
$requete_annee_min_obs = 'SELECT DISTINCT YEAR(oo_date) as annee FROM ods_observations '. |
'WHERE oo_date != "0000-00-00" AND YEAR(oo_date) <= "'.date('Y').'" '. |
'ORDER BY annee DESC'; |
$resultat_annees_ayant_obs = $this->executerRequete($requete_annee_min_obs); |
$annees_ayant_obs = []; |
foreach($resultat_annees_ayant_obs as $res_annee_ayant_obs) { |
$annees_ayant_obs[] = $res_annee_ayant_obs['annee']; |
} |
return $annees_ayant_obs; |
} |
private function getObservationsPourStation($params) { |
$id_station = isset($params[0]) ? $params[0] : ''; |
234,7 → 255,7 |
$requete_suppression_observation = 'DELETE FROM ods_observations '. |
'WHERE oo_id_observation = '.$this->proteger($donnees_obs_a_inserer['id_observation']).' '. |
'AND oo_absence_evenement = 1'; |
$this->executerRequeteSimple($requete_suppression_observation); |
} else { |
$requete_modification_observation = 'UPDATE ods_observations '. |
/trunk/applications/jrest/services/OdsMarqueur.php |
---|
5,64 → 5,65 |
* To change the template for this generated file go to |
* Window - Preferences - PHPeclipse - PHP - Code Templates |
*/ |
class OdsMarqueur extends JRestService { |
public function getElement() { |
if(isset($_GET['couleurs'])) { |
$couleurs = explode(',',$_GET['couleurs']); |
$couleurs = strtoupper(urldecode($_GET['couleurs'])); |
$couleurs = explode(',', $couleurs); |
} |
$taille = 15; |
if(isset($_GET['taille'])) { |
$taille = $_GET['taille']; |
} |
$image = imagecreatetruecolor($taille,$taille); |
$faux_noir = imagecolorallocate($image, 64, 64, 64); |
$noir = imagecolorallocate($image, 0, 0, 0); |
if(count($couleurs) <= 0) { |
return; |
} |
//$couleurs = array_unique($couleurs); |
sort($couleurs); |
$pas_angle = 360/count($couleurs); |
$angle = 0; |
foreach($couleurs as $couleur_html) { |
$couleur_rgb = $this->html2rgb($couleur_html); |
$couleur_allouee = imagecolorallocate($image, $couleur_rgb[0], $couleur_rgb[1], $couleur_rgb[2]); |
$couleur_allouee = imagecolorallocate($image, $couleur_rgb[0], $couleur_rgb[1], $couleur_rgb[2]); |
imagefilledarc($image, $taille/2, $taille/2, |
$taille, $taille-1, |
$angle, $angle+$pas_angle, |
$taille, $taille-1, |
$angle, $angle+$pas_angle, |
$couleur_allouee, IMG_ARC_PIE); |
$angle = $angle+$pas_angle; |
} |
imagefilledarc($image, $taille/2, $taille/2, |
$taille, $taille, |
0, 360, |
$taille, $taille, |
0, 360, |
$faux_noir, IMG_ARC_NOFILL); |
imagecolortransparent($image, $noir); |
header('Content-type: image/png'); |
imagepng($image); |
imagedestroy($image); |
} |
} |
function html2rgb($color) |
{ |
if ($color[0] == '#') |
$color = substr($color, 1); |
if (strlen($color) == 6) |
list($r, $g, $b) = array($color[0].$color[1], |
$color[2].$color[3], |
71,10 → 72,10 |
list($r, $g, $b) = array($color[0].$color[0], $color[1].$color[1], $color[2].$color[2]); |
else |
return false; |
$r = hexdec($r); $g = hexdec($g); $b = hexdec($b); |
return array($r, $g, $b); |
} |
} |
} |
?> |
/trunk/applications/jrest/services/OdsExport.php |
---|
240,7 → 240,7 |
break; |
case 'region' : |
$requete_association_region .= 'SELECT * FROM ods_triples WHERE ot_ce_parent = 36 AND ot_valeur = '.$valeur; |
$requete_association_region = 'SELECT * FROM ods_triples WHERE ot_ce_parent = 36 AND ot_valeur = '.$valeur; |
$listeAssociationRegions = $this->executerRequete($requete_association_region); |
$departements = array(); |
foreach ($listeAssociationRegions as $associationRegion) { |