Beispiel #1
0
function drawCircles($image)
{
    $max = 12;
    $min = 2;
    $gap = $max - $min;
    $total = getTotalElements();
    $result = getCoords();
    foreach ($result as $row) {
        drawCircle($image, $row['x'], $row['y'], $min + $gap * ($row['total'] / $total));
    }
}
Beispiel #2
0
 public function siren($siren)
 {
     require_once APPLICATION_PATH . DS . '..' . '/public/vendeur/lib/simple_html_dom.php';
     set_time_limit(0);
     $key = 'siren.' . $siren;
     $cached = redis()->get($key);
     if (empty($cached)) {
         $html = dwn("http://www.societe.com/cgi-bin/fiche?rncs={$siren}&mode=prt");
         redis()->set($key, $html);
     } else {
         $html = $cached;
     }
     $html = utf8_encode($html);
     $infos = [];
     $html = str_get_html($html);
     $table = $html->find('table[id=rensjur]', 0);
     if (is_object($table)) {
         $trs = $table->find('tr');
         foreach ($trs as $tr) {
             $tds = $tr->find('td');
             $first = true;
             foreach ($tds as $td) {
                 if ($first) {
                     $attribute = Inflector::urlize($td->innertext, '_');
                 } else {
                     $value = $td->innertext;
                 }
                 $first = false;
             }
             $attribute = str_replace(['denomination', 'description_de_l_activite_de_l_entreprise', 'siret_siege', 'tranche_d_effectif'], ['raison_sociale', 'activite', 'siret', 'effectif'], $attribute);
             if ($attribute == 'activite') {
                 continue;
             }
             $infos[$attribute] = $value;
         }
     }
     $table = $html->find('table[id=rensjurcomplete]', 0);
     if (is_object($table)) {
         $trs = $table->find('tr');
         foreach ($trs as $tr) {
             $tds = $tr->find('td');
             $first = true;
             foreach ($tds as $td) {
                 if ($first) {
                     $attribute = Inflector::urlize($td->innertext, '_');
                 } else {
                     $value = $td->innertext;
                 }
                 $first = false;
             }
             $attribute = str_replace(['denomination', 'description_de_l_activite_du_siege', 'description_de_l_activite_de_l_entreprise', 'siret_siege', 'tranche_d_effectif', 'code_ape_naf_de_l_entreprise', 'code_ape_naf_du_siege', 'n_dossier'], ['raison_sociale', 'activite_siege', 'activite_entreprise', 'siret', 'effectif', 'naf_entrprise', 'naf_siege', 'numero_dossier'], $attribute);
             $infos[$attribute] = $value;
         }
         if (isset($infos['adresse_rcs'])) {
             $infos['adresse'] = $infos['adresse_rcs'];
         }
         if (isset($infos['adresse_insee'])) {
             $infos['adresse'] = $infos['adresse_insee'];
         }
         if (isset($infos['complement_nom_adressage'])) {
             $infos['nom_commercial'] = $infos['complement_nom_adressage'];
             unset($infos['complement_nom_adressage']);
         }
         $infos['code_postal'] = $infos['code_postal'];
         $infos['department_code'] = substr($infos['code_postal'], 0, 2);
         $department = Model::Department()->where(['code', '=', (string) $infos['department_code']])->first(true);
         if ($department) {
             $infos['department_id'] = $department->id;
             $infos['department'] = $department->name;
             $region = $department->region(true);
             if ($region) {
                 $infos['region_id'] = $region->id;
                 $infos['region'] = $region->name;
             }
         }
         if (isset($infos['adresse'])) {
             $coords = getCoords($infos['adresse'] . ' ' . $infos['code_postal'] . ' ' . $infos['ville']);
             $lat = isAke($coords, 'lat', false);
             $lng = isAke($coords, 'lng', false);
             if (false !== $lat) {
                 $infos['lat'] = $lat;
             }
             if (false !== $lng) {
                 $infos['lng'] = $lng;
             }
             $infos['coords'] = $coords;
         }
     }
     unset($infos['adresse_rcs'], $infos['nom_adressage'], $infos['adresse_insee']);
     return $infos;
 }
Beispiel #3
0
</li>
					<?php 
}
?>
				</ol>
					</marquee>
			</div>
		
			
			<div class="stat">
				<p><strong>Top 5 Blocked Countries:</strong></p>
				<ol>
					<?php 
$top_countries = topXCountries(5);
foreach ($top_countries as $country => $count) {
    $iso_details = getCoords($country);
    ?>
						<li><img src="images/flags/<?php 
    echo $country;
    ?>
.png" alt="<?php 
    echo $iso_details["name"];
    ?>
" title="<?php 
    echo $iso_details["name"];
    ?>
" /> <?php 
    echo $iso_details["name"] . " (" . $count . ")";
    ?>
</li>
						
/**
 * [getLines description]
 * @param  [type] $buffer [description]
 * @return [type]         [description]
 */
function getLines($buffer)
{
    $lines = new SplFixedArray($buffer->count());
    for ($buffer->rewind(); $buffer->valid(); $buffer->next()) {
        $lines[$buffer->key()] = getCoords($buffer->current());
    }
    return $lines;
}
Beispiel #5
0
        deletePersonne($_GET);
        break;
    case "updatepersonne":
        updatePersonne($_GET);
        break;
    case "getpersonne":
        getPersonne();
        break;
    case "auth":
        auth($_GET);
        break;
    case "document":
        getDoc();
        break;
    case "coords":
        getCoords($_GET["idDoc"]);
        break;
    default:
        break;
}
function createScore($data)
{
    global $conn;
    $sql = "INSERT INTO scores (id_doc, id_perso, distance, maj)\n\tVALUES (" . $data["id_doc"] . ", " . $data["id_perso"] . ", " . $data["distance"] . ",NOW())";
    //echo $sql;
    if ($conn->query($sql) === TRUE) {
        echo "New record created successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}
Beispiel #6
0
$surp = $_POST['surprise'];
$sad = $_POST['sadness'];
$dis = $_POST['disgust'];
$anger = $_POST['anger'];
$ant = $_POST['anticipation'];
// Check connection
if ($sql->connect_error) {
    die("Connection failed: " . $sql->connect_error);
}
$query = "UPDATE artisan SET joy = joy + {$joy},trust = trust + {$trust},fear = fear \r\n+ {$fear}, surprise= surprise + {$surp},sadness = sadness + {$sad},disgust = disgust + {$dis},anger = anger \r\n+ {$anger},anticipation=anticipation + {$ant}, count = count + 1 WHERE title ='{$title}'";
mysqli_query($sql, $query);
$query2 = "SELECT count,joy,trust,fear,surprise,sadness,disgust,anger,anticipation,x,y,rgb FROM artisan WHERE title='{$title}'";
$result = mysqli_query($sql, $query2);
$row = mysqli_fetch_assoc($result);
$count = $row['count'];
unset($row['count']);
foreach ($row as $k => $v) {
    if (is_numeric($v) && $k != "x" && $k != "y" && $k != "rgb") {
        $row[$k] = round($v / $count, 2);
    }
}
$coords = getCoords($row);
$good = json_decode($coords, true);
$x = $good['x'];
$y = $good['y'];
$query3 = "UPDATE artisan SET x ={$x}, y={$y} WHERE title ='{$title}'";
mysqli_query($sql, $query3);
$row['x'] = $x;
$row['y'] = $y;
echo json_encode($row);
mysqli_close($sql);
Beispiel #7
0
function collectCoordinates()
{
    $organisms = getAllUpdates();
    for ($a = 0; $a < count($organisms); $a++) {
        $larr = explode(",", $organisms[$a]['LATITUDE']);
        $lorr = explode(",", $organisms[$a]['LONGITUDE']);
        array_shift($larr);
        array_shift($lorr);
        $coords[$a] = getCoords($larr, $lorr);
    }
    return $coords;
}
//please note, the php object returned from openCage class differs by country
//the following function works for USA addresses
function getCoords($query, $zip, $mykey)
{
    $geocoder = new OpenCage\Geocoder($mykey);
    $result = $geocoder->geocode($query);
    $empty[0] = "";
    if (empty($result['results'][0])) {
        array_push($empty, $result);
    } else {
        $jsst = '{"lat":' . ($latlng['lat'] = $result['results'][0]['geometry']['lat']);
        $jsst .= ', "long":' . ($latlng['lng'] = $result['results'][0]['geometry']['lng']);
        $jsst .= ', "zip":' . $zip . '}, ';
    }
    if (empty($latlng['lat'])) {
        return;
    } else {
        return $jsst;
    }
}
$work[1251] = [' 480 NORTH WOLF ROAD NORTHLAKE IL 60164', '60164 '];
$work[1252] = [' 48d0 NORTH WOLF ROAD NORTHLAKE IL 60164', '60164 '];
header('Content-type: text/html; charset=utf-8');
print_r("[");
foreach ($work as &$value) {
    print_r(getCoords($value[0], $value[1], $key));
    flush();
}
print_r("{}]");
//my ugly way of dealing with trailing comma, since PHP has no nice way to get last index.
//{"lat": 38.7603106, "long": -121.2946768, "zip" : "95678"},
             $fname = $sql->real_escape_string($_POST['fname']);
             $lname = $sql->real_escape_string($_POST['lname']);
             $title = $sql->real_escape_string($_POST['title']);
             $joy = $_POST['joy'];
             $trust = $_POST['trust'];
             $fear = $_POST['fear'];
             $surp = $_POST['surprise'];
             $sad = $_POST['sadness'];
             $dis = $_POST['disgust'];
             $anger = $_POST['anger'];
             $ant = $_POST['anticipation'];
             $rgb = $_POST['rgb'];
             $avg = $_POST['avg'];
             $rat = $_POST['ratio'];
             $pal = $_POST['palette'];
             $coords = getCoords($_POST);
             // Call to xycoord.php returns x and y coordinates
             $good = json_decode($coords, true);
             //(central emotion) of artwork
             $x = $good['x'];
             $y = $good['y'];
             if ($sql->connect_error) {
                 die("Connection failed: " . $sql->connect_error);
             }
             $query = "INSERT INTO artisan (firstname, lastname, title,joy,trust,\r\n\t\t\t\tfear,surprise,sadness,disgust,anger,anticipation,rgb,x,y,ratio,palette,imgpath,rgbavg)\r\n\t\t\t\tVALUES ('{$fname}', '{$lname}', '{$title}','{$joy}','{$trust}','{$fear}','{$surp}',\r\n\t\t\t\t'{$sad}','{$dis}','{$anger}','{$ant}','{$rgb}','{$x}','{$y}','{$rat}','{$pal}','{$targetPath}','{$avg}')";
             mysqli_query($sql, $query);
             mysqli_close($sql);
             echo json_encode(array("rgb" => $rgb, "title" => $title, "imgpath" => $targetPath, "x" => $x, "y" => $y, "ratio" => $rat, "palette" => $pal, "avg" => $avg));
         }
     }
 } else {
/**
 * Draws a canvas of the result if we're debugging
 * @param  array  $circle The circle description
 * @param  array  $lines  The lines used to describe it
 * @param  string $id     The ID to use for the canvas
 * @return null
 */
function drawResult($circle, $lines, $id)
{
    global $debug;
    if ($debug) {
        $arc = implode("\n", array_map(function ($a) {
            return "    " . $a;
        }, explode("\n", generateGcodeArc($circle, $lines))));
        $height = 500;
        $width = 500;
        $scale = 2;
        echo createCanvas($id, $height, $width);
        $canvasPoints = array();
        foreach ($lines as $line) {
            $canvasPoints[] = array('X' => $line['X'] * $scale, 'Y' => $line['Y'] * $scale);
        }
        // echo "<pre>";var_dump($canvasPoints);echo "</pre>";
        echo drawCanvasPoints($id, $canvasPoints);
        $line = 0;
        echo writeOnCanvas($id, "Number of nodes: " . $lines->count(), 5, $height - $line++ * 15);
        $ccenter = $circle['center'];
        echo pointOnCanvas($id, $ccenter['X'] * $scale, $ccenter['Y'] * $scale);
        echo writeOnCanvas($id, sprintf("%.1f, %.1f", $ccenter['X'], $ccenter['Y']), $ccenter['X'] * $scale, $ccenter['Y'] * $scale, 10, '#FF0000', 'true');
        // echo circleOnCanvas($id, $ccenter['X']*$scale, $ccenter['Y']*$scale, $circle['radius']*$scale, '#00FF00');
        // echo circleOnCanvas($id, $ccenter['X']*$scale, $ccenter['Y']*$scale, ($circle['radius']+max($circle['errors']))*2, '#FF0000');
        // echo circleOnCanvas($id, $ccenter['X']*$scale, $ccenter['Y']*$scale, ($circle['radius']-max($circle['errors']))*2, '#0000FF');
        $arcCoords = getCoords($arc);
        $endAngle = angleBetween(array('X' => $ccenter['X'] * $scale, 'Y' => $ccenter['Y'] * $scale), array('X' => $canvasPoints[0]['X'], 'Y' => $canvasPoints[0]['Y']));
        $startAngle = angleBetween(array('X' => $ccenter['X'] * $scale, 'Y' => $ccenter['Y'] * $scale), array('X' => $canvasPoints[count($canvasPoints) - 1]['X'], 'Y' => $canvasPoints[count($canvasPoints) - 1]['Y']));
        echo arcOnCanvas($id, $ccenter['X'] * $scale, $ccenter['Y'] * $scale, $circle['radius'] * $scale, $startAngle, $endAngle, '#FF0000');
        $arc = "GCODE:\n" . $arc . "\n---------------";
        $line += substr_count($arc, "\n") - 1;
        echo writeOnCanvas($id, $arc, 5, $height - $line * 15);
        // $pc = print_r($circle,true);
        // $line += substr_count($pc, "\n")-1;
        // echo writeOnCanvas($id, '$circle = '.$pc, 5, $height-($line*9.1), 8);
    }
}