function createStoreAccount()
 {
     $store = new StorePortal();
     foreach ($store->getAll() as $obj) {
         $acc = new Account();
         $acc->admin_nama_depan = $obj->STORE_NAME;
         $acc->admin_username = $obj->Site;
         $acc->admin_role = $this::DEFAULT_ROLE;
         $acc->admin_password = $this::DEFAULT_PASSWORD;
         $acc->admin_type = $this::DEFAULT_TYPE;
         $acc->admin_aktiv = 1;
         $acc->save();
     }
     print_r('done');
 }
    function map()
    {
        ?>
        <script>
            var locations = [];
        </script>
        <?php 
        $storePortal = new StorePortal();
        $storePortal->default_read_coloms = "*";
        $arr = $storePortal->getAll();
        for ($i = 0; $i < count($arr); $i++) {
            $store = $arr[$i];
            ?>
            <script>
                var storeName = "<?php 
            echo $store->STORE_NAME;
            ?>
";
                var email = "<?php 
            echo $store->Email;
            ?>
";
                var phone = "<?php 
            echo $store->PHONE;
            ?>
";
                var latitude = "<?php 
            echo $store->Latitude;
            ?>
";
                var longitude = "<?php 
            echo $store->Longitude;
            ?>
";

                var info = "";
                if (storeName)
                    info = info + storeName;
                if (email)
                    info = info + "<br/>" + email;
                if (phone)
                    info = info + "<br/>" + phone;

                locations.push([latitude, longitude, info]);
            </script>
            <?php 
        }
        ?>
        <!-- Google Map -->
        <script src="https://maps.googleapis.com/maps/api/js"></script>
        <script>
            var map = null;
            var marker = null;
            var zoom = 13;

            google.maps.event.addDomListener(window, 'load', initialize);

            function initialize() {
                var myOptions = {
                    center: new google.maps.LatLng(33.890542, 151.274856),
                    zoom: 8,
                    mapTypeId: google.maps.MapTypeId.ROADMAP

                };
                var mapCanvas = document.getElementById('map-canvas');
                var mapOptions = {
                    center: new google.maps.LatLng(-2.548926, 118.0148634),
                    zoom: 4,
                    mapTypeId: google.maps.MapTypeId.ROADMAP
                }

                map = new google.maps.Map(mapCanvas, mapOptions);
                setMarkers(map, locations);
            }


            function setMarkers(map, locations) {
                var marker, i
                for (i = 0; i < locations.length; i++) {
                    var lat = locations[i][0]
                    var long = locations[i][1]
                    var add = locations[i][2]

                    latlngset = new google.maps.LatLng(lat, long);
                    var marker = new google.maps.Marker({
                        map: map, title: add, position: latlngset
                    });

                    var content = add;

                    var infowindow = new google.maps.InfoWindow();

                    google.maps.event.addListener(marker, 'click', (function (marker, content, infowindow) {
                        return function () {
                            infowindow.setContent(content);
                            infowindow.open(map, marker);
                        };
                    })(marker, content, infowindow));

                }
            }
        </script>
        <div class="postcontent" style="margin-top: 20px;">
            <div class="col-md-12" style="margin-top: 20px; padding-bottom: 20px;">
                <script>
                    setMarkers(map, locations);
                </script>
                <div>
                    <div id="map-canvas"
                         style="width: 100%; height: 300px;"></div>
                    <div id="storecontainer"></div>
                </div>
            </div>
        </div>
        <?php 
    }