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');
 }
 public function renew()
 {
     //echo  "in";
     $data = file_get_contents($this->url);
     $data = json_decode($data, true);
     //pr($data);
     foreach ($data['results'] as $r) {
         $store = new StorePortal();
         $store->getByID($r['No']);
         if ($store->Site == "") {
             $store->load = 0;
         }
         $store->fill($r);
         //pr($store);
         echo $store->Site . " : " . $store->save() . "<br>";
         //exit();
     }
 }
    public static function portalIndex()
    {
        // self::loadHybris();
        self::hybriscarousel();
        $setting = new Efiwebsetting();
        $setting = $setting->getWhere("set_id = 'MapZoom'");
        if ($setting) {
            $zoomDefault = $setting[0]->set_value;
        }
        ?>
		<style>
			.storeheader {
				padding          : 8px;
				background-color : #efefef;
				font-size        : 17px;
				font-weight      : bold;
				margin-bottom    : 10px;
			}
		</style>
		<!--<img src="<?php 
        echo _SPPATH;
        ?>
props/4.jpg" width="100%">-->
		<div class="storeheader"><?php 
        echo Lang::t('Store Location');
        ?>
</div>
		<div class="col-md-3">
			<div style="padding: 10px; background-color: #efefef; border-radius: 5px;">
				<?php 
        $sp = new StorePortal();
        $areas = $sp->selectDistinctArea();
        ?>
				<div class="form-group">
					<label for="area-select"><?php 
        echo Lang::t('Choose your area');
        ?>
</label>
					<select id="area-select"
					        class="form-control">
						<option value=""></option>
						<?php 
        foreach ($areas as $ar) {
            ?>
							<option value="<?php 
            echo base64_encode($ar->AREA);
            ?>
"><?php 
            echo $ar->AREA;
            ?>
</option>
						<?php 
        }
        ?>
					</select>
					<script>
						$('#area-select').change(function () {
							var slc = $('#area-select').val();
							$("#storecontainer").empty();
							$("#storespicker").load("<?php 
        echo _SPPATH;
        ?>
StorePortalWeb/storepicker?area=" + slc);
						});
					</script>
				</div>
				<div id="storespicker">

				</div>
			</div>
		</div>
		<div class="col-md-9">
			<div style="padding-left: 20px;">

				<!-- Google Map -->
				<script src="https://maps.googleapis.com/maps/api/js"></script>
				<script>
					var map = null;
					var marker = null;
					var zoom = <?php 
        echo $zoomDefault;
        ?>
;

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

					function initialize() {
						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);
						loadAllStores();
					}

					function addMarker(lat, long, info) {
						if (!lat || !long) {
							return;
						}

						// Clear previous marker
						if (marker != null) {
							marker.setMap(null);
						}

						// Define marker
						marker = new google.maps.Marker({
							position: new google.maps.LatLng(lat, long)
						});

						// Click - open details
						if (info) {
							var infowindow = new google.maps.InfoWindow({
								content: info
							});
							google.maps.event.addListener(marker, 'click', function () {
								infowindow.open(map, marker);
							});
						}

						// Click - zoom
						map.setZoom(zoom);
						map.setCenter(marker.getPosition());

						marker.setMap(map);
					}
				</script>

				<div id="map-canvas"
				     style="width: 100%; height: 300px;"></div>
				<div id="storecontainer"></div>
			</div>
		</div>

	<?php 
    }
    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 
    }