コード例 #1
0
ファイル: archive.php プロジェクト: Fredus14/minoTour
         }
     }
     //var_dump($resultarray);
     //echo json_encode($resultarray);
     $jsonstring = "";
     $jsonstring = $jsonstring . "[\n";
     foreach ($resultarray as $key => $value) {
         $jsonstring = $jsonstring . "{\n";
         $jsonstring = $jsonstring . "\"name\" : \"{$key}\", \n";
         $jsonstring = $jsonstring . "\"borderWidth\": 1,\n";
         $jsonstring = $jsonstring . "\"data\": [";
         for ($i = 1; $i <= 512; $i++) {
             if (array_key_exists($i, $resultarray[$key])) {
                 $jsonstring = $jsonstring . "[" . getx($i) . "," . gety($i) . "," . $resultarray[$key][$i] . "],\n";
             } else {
                 $jsonstring = $jsonstring . "[" . getx($i) . "," . gety($i) . ",0],\n";
             }
         }
         $jsonstring = $jsonstring . "],\n\"dataLabels\": {\n                \"enabled\": true,\n                \"color\":\"black\",\n                \"style\": {\n                    \"textShadow\": \"none\"\n                }\n            }\t";
         $jsonstring = $jsonstring . "},\n";
     }
     $jsonstring = $jsonstring . "]\n";
     if ($_GET["prev"] == 1) {
         include 'savejson.php';
     }
 }
 $sqlcheck = "insert into jsonstore (name,json) VALUES ('do_not_delete','1');";
 //echo $sqlcheck;
 $sqlchecksecurity = $mindb_connection->query($sqlcheck);
 $drop1 = "drop table last_align_basecalled_template;";
 $drop2 = "drop table last_align_basecalled_complement;";
コード例 #2
0
function readsperpore($jobname, $currun)
{
    $checkvar = $currun . $jobname;
    $checkrunning = $currun . $jobname . "status";
    global $memcache;
    global $mindb_connection;
    global $reflength;
    //$jsonstring = $memcache->get("$checkvar");
    $checkingrunning = $memcache->get("{$checkrunning}");
    if ($checkingrunning === "No" || $checkingrunning === FALSE) {
        $memcache->set("{$checkrunning}", "YES", 0, 0);
        $checkrow = "select name,json from jsonstore where name = '" . $jobname . "' ;";
        $checking = $mindb_connection->query($checkrow);
        if ($checking->num_rows == 1) {
            //echo "We have already run this!";
            foreach ($checking as $row) {
                $jsonstring = $row['json'];
            }
        } else {
            $sql_template = "select count(*) as count, channel from basecalled_template inner join config_general using (basename_id) group by channel order by channel;";
            $resultarray;
            $template = $mindb_connection->query($sql_template);
            if ($template->num_rows >= 1) {
                foreach ($template as $row) {
                    $resultarray['template'][$row['channel']] = $row['count'];
                }
            }
            //var_dump($resultarray);
            //echo json_encode($resultarray);
            $jsonstring;
            $jsonstring = $jsonstring . "[\n";
            foreach ($resultarray as $key => $value) {
                $jsonstring = $jsonstring . "{\n";
                $jsonstring = $jsonstring . "\"name\" : \"{$key}\", \n";
                $jsonstring = $jsonstring . "\"borderWidth\": 1,\n";
                $jsonstring = $jsonstring . "\"data\": [";
                for ($i = 1; $i <= 512; $i++) {
                    if (array_key_exists($i, $resultarray[$key])) {
                        $jsonstring = $jsonstring . "[" . getx($i) . "," . gety($i) . "," . $resultarray[$key][$i] . "],\n";
                    } else {
                        $jsonstring = $jsonstring . "[" . getx($i) . "," . gety($i) . ",0],\n";
                    }
                }
                $jsonstring = $jsonstring . "],\n\"dataLabels\": {\n                \"enabled\": true,\n                \"color\":\"black\",\n                \"style\": {\n                    \"textShadow\": \"none\"\n                }\n            }\t";
                $jsonstring = $jsonstring . "},\n";
            }
            $jsonstring = $jsonstring . "]\n";
            if ($_GET["prev"] == 1) {
                include 'savejson.php';
            }
        }
        $memcache->set("{$checkvar}", $jsonstring);
    } else {
        $jsonstring = $memcache->get("{$checkvar}");
    }
    // cache for 2 minute as we want yield to update semi-regularly...
    $memcache->delete("{$checkrunning}");
    return $jsonstring;
}