controller、indexctp、lon・latを整える

DBの用意が出来たので、controllerから作っていきます。mysqlからselectする際に時差を計算してあげます。
WorldwidesController.php

<?php

namespace App\Controller;

use Cake\ORM\TableRegistry;  

class WorldwidesController extends AppController
{	
	public function initialize()
    {
         parent::initialize();
         $this->Londons = TableRegistry::get('londons');
         $this->Moscows = TableRegistry::get('moscows');
         $this->Cairos = TableRegistry::get('cairos');
         $this->Capetowns = TableRegistry::get('capetowns');
         $this->Beijings = TableRegistry::get('beijings');
         $this->Jakartas = TableRegistry::get('jakartas');
         $this->Marunouchis = TableRegistry::get('marunouchis');
         $this->Sydneys = TableRegistry::get('sydneys');
         $this->Losangeles = TableRegistry::get('losangeles');
         $this->Newyorks = TableRegistry::get('newyorks');
         $this->Limas = TableRegistry::get('limas');
         $this->Saopaulos = TableRegistry::get('saopaulos');
    }

	public function index()
	{
		$this->viewBuilder()->layout('my_layout');
		$now1 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-9hour'));
		$param1 = array(
		    'conditions' => array(
		        'forecast >' => $now1, 
		    ),
		);
		$londons = $this->Londons->find('all', $param1)->limit(8);
		$now2 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-6hour'));
		$param2 = array(
		    'conditions' => array(
		        'forecast >' => $now2, 
		    ),
		);
		$moscows = $this->Moscows->find('all', $param2)->limit(8);
		$now3 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-8hour'));
		$param3 = array(
		    'conditions' => array(
		        'forecast >' => $now3, 
		    ),
		);
		$cairos = $this->Cairos->find('all', $param3)->limit(8);
		$capetowns = $this->Capetowns->find('all', $param3)->limit(8);
		$now4 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-1hour'));
		$param4 = array(
		    'conditions' => array(
		        'forecast >' => $now4, 
		    ),
		);
		$beijings = $this->Beijings->find('all', $param4)->limit(8);
		$now5 = date("Y-m-d H:i:s");
		$param5 = array(
		    'conditions' => array(
		        'forecast >' => $now5, 
		    ),
		);
		$marunouchis = $this->Marunouchis->find('all', $param5)->limit(8);
		$now6 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-2hour'));
		$param6 = array(
		    'conditions' => array(
		        'forecast >' => $now6, 
		    ),
		);
		$jakartas = $this->Jakartas->find('all', $param6)->limit(8);
		$now7 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '+3hour'));
		$param7 = array(
		    'conditions' => array(
		        'forecast >' => $now7, 
		    ),
		);
		$sydneys = $this->Sydneys->find('all', $param7)->limit(8);
		$now8 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-16hour'));
		$param8 = array(
		    'conditions' => array(
		        'forecast >' => $now8, 
		    ),
		);
		$losangeles = $this->Losangeles->find('all', $param8)->limit(8);
		$now9 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-13hour'));
		$param9 = array(
		    'conditions' => array(
		        'forecast >' => $now9, 
		    ),
		);
		$newyorks = $this->Newyorks->find('all', $param9)->limit(8);
		$now10 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-14hour'));
		$param10 = array(
		    'conditions' => array(
		        'forecast >' => $now10, 
		    ),
		);
		$limas = $this->Limas->find('all', $param10)->limit(8);
		$now11 = date("Y-m-d H:i:s", strtotime(date(DATE_RFC2822) . '-12hour'));
		$param11 = array(
		    'conditions' => array(
		        'forecast >' => $now11, 
		    ),
		);
		$saopaulos = $this->Saopaulos->find('all', $param11)->limit(8);
		$this->set(compact('londons'));
		$this->set(compact('moscows'));
		$this->set(compact('cairos'));
		$this->set(compact('capetowns'));
		$this->set(compact('beijings'));	
		$this->set(compact('marunouchis'));
		$this->set(compact('jakartas'));
		$this->set(compact('sydneys'));
		$this->set(compact('losangeles'));
		$this->set(compact('newyorks'));
		$this->set(compact('limas'));
		$this->set(compact('saopaulos'));
	}
}
?>

緯度経度を追記します。

var markerData = [ 
  {
       name: 'ロンドン',
       lat: 51.507351,
        lng: -0.127758,
        icon: icon[0]
 }, {
 	name: 'モスクワ',
       lat: 55.755826,
        lng: 37.6173,
        icon: icon[1]
 }, {
 	name: 'カイロ',
       lat: 30.0444196,
        lng: 31.2357116,
        icon: icon[2]
 }, {
 	name: 'ケープタウン',
       lat:  -33.924869,
        lng: 18.424055,
        icon: icon[3]
 }, {
 	name: '北京',
       lat: 39.9042,
        lng: 116.407396,
        icon: icon[4]
 }, {
 	name: '東京',
       lat: 35.681167,
        lng: 139.767052,
        icon: icon[5]
 }, {
        name: 'ジャカルタ',
     	lat:  -6.17511,
        lng: 106.86504,
        icon: icon[6]
 }, {
 	name: 'シドニー',
       lat:　-33.86882,
        lng: 151.209296,
        icon: icon[7]
 }, {
 	name: 'ロサンゼルス',
       lat: 34.052234,
        lng: -118.243685,
        icon: icon[8]
 }, {
 	name: 'ニューヨーク',
       lat: 40.712775,
        lng: -74.005973,
        icon: icon[9]
 }, {
 	name: 'リマ',
       lat: -12.046373,
        lng: -77.042754,
        icon: icon[10]
 }, {
 	name: 'サンパウロ',
       lat: -23.55052,
        lng: -46.633309,
        icon: icon[11]
 }
];

思ってたより簡単にできましたね。