+# Generated by Django 3.2.5 on 2021-07-19 08:11

+

+from django.db import migrations, models

+import django.db.models.deletion

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('backend', '0023_place'),

+    ]

+

+    operations = [

+        migrations.CreateModel(

+            name='Points',

+            fields=[

+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),

+                ('dest', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='dest', to='backend.place')),

+                ('src', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='src', to='backend.place')),

+            ],

+        ),

+    ]

+# Generated by Django 3.2.5 on 2021-07-21 04:45

+

+from django.db import migrations

+import django_google_maps.fields

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('backend', '0024_points'),

+    ]

+

+    operations = [

+        migrations.RemoveField(

+            model_name='points',

+            name='src',

+        ),

+        migrations.AddField(

+            model_name='points',

+            name='address',

+            field=django_google_maps.fields.AddressField(max_length=200, null=True),

+        ),

+        migrations.AddField(

+            model_name='points',

+            name='geolocation',

+            field=django_google_maps.fields.GeoLocationField(max_length=100, null=True),

+        ),

+    ]

+# Generated by Django 3.2.5 on 2021-07-21 05:18

+

+from django.db import migrations, models

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('backend', '0025_auto_20210721_1145'),

+    ]

+

+    operations = [

+        migrations.AddField(

+            model_name='points',

+            name='distance',

+            field=models.DecimalField(blank=True, decimal_places=2, max_digits=7, null=True),

+        ),

+        migrations.AddField(

+            model_name='points',

+            name='duration',

+            field=models.CharField(blank=True, max_length=200, null=True),

+        ),

+    ]

+# Generated by Django 3.2.5 on 2021-07-21 05:51

+

+from django.db import migrations, models

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('backend', '0026_auto_20210721_1218'),

+    ]

+

+    operations = [

+        migrations.AddField(

+            model_name='points',

+            name='directions',

+            field=models.JSONField(blank=True, null=True),

+        ),

+        migrations.AlterField(

+            model_name='points',

+            name='distance',

+            field=models.DecimalField(blank=True, decimal_places=2, max_digits=7, null=True, verbose_name='Distance (km)'),

+        ),

+    ]

+# Generated by Django 3.2.5 on 2021-07-21 10:11

+

+from django.db import migrations, models

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('backend', '0027_auto_20210721_1251'),

+    ]

+

+    operations = [

+        migrations.AddField(

+            model_name='place',

+            name='title',

+            field=models.CharField(blank=True, max_length=200, null=True),

+        ),

+    ]

+# Generated by Django 3.2.5 on 2021-07-22 08:04

+

+from django.db import migrations, models

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('backend', '0028_place_title'),

+    ]

+

+    operations = [

+        migrations.CreateModel(

+            name='ImportFile',

+            fields=[

+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),

+                ('hospital_file', models.FileField(blank=True, upload_to='uploads/%Y/%m/%d/', verbose_name='Hospital (csv)')),

+            ],

+        ),

+    ]

+import googlemaps

+from django.contrib.gis.geos import fromstr

+

+from django.conf import settings

+import csv

+

+gmaps = googlemaps.Client(key=settings.GOOGLE_MAPS_API_KEY)

+        #self.nearby()

+

+    def nearby(self):

+        r = gmaps.places_nearby(location=(self.geolocation.lat, self.geolocation.lon), type="hospital", radius=10000)

+        bd = ""

+        for r0 in r['results']:

+            openh = "-"

+            if 'opening_hours' in r0:

+                openh = r0['opening_hours']['open_now']

+            else:

+                openh = "-"

+

+            bd += f"<tr><td>{r0['name']}</td><td>{openh}</td><td>{r0['vicinity']}</td></tr>"

+

+        rt = f'''

+<br>

+        <table><thead><tr><th>Name</th><th>Opening Hours</th><th>Vicinity</th></tr></thead>

+        <tbody>

+            {bd}

+        </tbody>

+        </table>

+        '''

+        return rt

+

+

+

+class ImportFile(models.Model):

+    hospital_file  = models.FileField(upload_to="uploads/%Y/%m/%d/", blank=True, verbose_name="Hospital (csv)")

+

+    def save(self, *args, **kwargs):

+        super(ImportFile, self).save(*args, **kwargs)

+

+        with self.hospital_file.open('r') as csv_file:

+            csv_reader = csv.reader(csv_file, delimiter=',')

+            Hospital.objects.all().delete()

+            line_count = 0

+

+            for r in csv_reader:

+                if line_count > 0:

+                    print(r)

+                    print(f"{r[7]},{r[6]}")

+                    try:

+                        gp = map_fields.GeoPt(lat=float(r[6]), lon=float(r[7]))

+

+                        location = fromstr(f'POINT({r[7]} {r[6]})', srid=4326)

+                        print(location)

+                        h = Hospital(title=r[3], address_text=r[5], geolocation=gp, address=r[3])

+                        h.save()

+                    except Exception as e:

+                        print(e)

+

+                line_count += 1

+

+

+

+    #title  = models.Char

+    title = models.CharField(max_length=200, blank=True, null=True)

+    def __str__(self):

+        return f"{self.address} ({self.geolocation})"

+class Points(models.Model):

+    #src  = models.ForeignKey(Place, on_delete=models.SET_NULL, null=True, blank=False, related_name='src')

+    dest  = models.ForeignKey(Place, on_delete=models.SET_NULL, null=True, blank=False, related_name='dest')

+    address = map_fields.AddressField(max_length=200, null=True)

+    geolocation = map_fields.GeoLocationField(max_length=100, null=True)

+

+    distance = models.DecimalField(null=True, blank=True, decimal_places=2, max_digits=7, verbose_name="Distance (km)")

+    duration = models.CharField(max_length=200, null=True, blank=True)

+

+    directions  = models.JSONField(null=True, blank=True)

+

+    def save(self, *args, **kwargs):

+        geocode_result = gmaps.geocode('1600 Amphitheatre Parkway, Mountain View, CA')

+        print(geocode_result)

+        print(self.geolocation)

+        origin = [(self.geolocation.lat, self.geolocation.lon)]

+        dest = [(self.dest.geolocation.lat, self.dest.geolocation.lon)]

+        dst = gmaps.distance_matrix(origin, dest)

+        dirs = gmaps.directions(origin[0], dest[0])

+        self.directions = dirs

+        print(dirs)

+        self.distance = dst['rows'][0]['elements'][0]['distance']['value'] / 1000

+        self.duration = dst['rows'][0]['elements'][0]['duration']['text']

+        print(dst)

+        super(Points, self).save(*args, **kwargs)

+

+

+

+

+

+{% extends "base.html" %}

+

+{% block title %}My amazing blog{% endblock %}

+

+{% block content %}

+Import File

+{% endblock %}

+{% extends "base.html" %}

+

+{% block title %}My amazing blog{% endblock %}

+

+{% block content %}

+Hello world

+<a href="{% url "import_file" %}">Import</a>

+{% endblock %}

+    path('import_file', views.import_file, name='import_file'),

+from django.shortcuts import render

+

+# Create your views here.

+from django.http import HttpResponse

+

+

+def index(request):

+    return render(request, 'backend/index.html')

+

+def import_file(request):

+    return render(request, 'backend/import_file.html')

+django-import-export

+    'django.contrib.staticfiles',

+    'import_export',

+        'DIRS': [os.path.join(BASE_DIR, 'templates')],

+] + static(settings.STATIC_URL, document_root=settings.STATIC_ROOT)