starwisp.scm 48.3 KB
Newer Older
Dave Griffiths's avatar
Dave Griffiths committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
;; Starwisp Copyright (C) 2013 Dave Griffiths
;;
;; This program is free software: you can redistribute it and/or modify
;; it under the terms of the GNU Affero General Public License as
;; published by the Free Software Foundation, either version 3 of the
;; License, or (at your option) any later version.
;;
;; This program is distributed in the hope that it will be useful,
;; but WITHOUT ANY WARRANTY; without even the implied warranty of
;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
;; GNU Affero General Public License for more details.
;;
;; You should have received a copy of the GNU Affero General Public License
;; along with this program.  If not, see <http://www.gnu.org/licenses/>.

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; strings


;; colours
21
(msg "starting up....")
Dave Griffiths's avatar
Dave Griffiths committed
22
23

(define trans-col (list 0 0 0 0))
24
25
(define colour-one (list 0 0 255 100))
(define colour-two (list  127 127 255 100))
Dave Griffiths's avatar
Dave Griffiths committed
26
27
28
29

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; persistent database

30
(define db "/sdcard/symbai/local-symbai.db")
Dave Griffiths's avatar
Dave Griffiths committed
31
32
33
34
35
36
37
38
39
40
(db-open db)
(setup db "local")
(setup db "sync")
(setup db "stream")

(insert-entity-if-not-exists
 db "local" "app-settings" "null" 1
 (list
  (ktv "user-id" "varchar" "No name yet...")))

Dave Griffiths's avatar
Dave Griffiths committed
41
(define entity-types (list "village"))
42

Dave Griffiths's avatar
Dave Griffiths committed
43
;;(display (db-all db "local" "app-settings"))(newline)
Dave Griffiths's avatar
Dave Griffiths committed
44

Dave Griffiths's avatar
Dave Griffiths committed
45
46
47
48
(define tribes-list '(khasi other))
(define subtribe-list '(khynriam pnar bhoi war other))
(define education-list   '(illiterate literate primary middle high secondary university))
(define married-list '(ever-married currently-married currently-single seperated))
Dave Griffiths's avatar
Dave Griffiths committed
49

Dave Griffiths's avatar
Dave Griffiths committed
50
51
52
53
(define social-relationship-list '(mother father sister brother spouse children co-wife spouse-mother spouse-father spouse-brother-wife spouse-sister-husband friend neighbour other))
(define social-residence-list '(same other))
(define social-strength-list '(daily weekly monthly less))

Dave Griffiths's avatar
Dave Griffiths committed
54
55
56
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; user interface abstraction

57
58
59
60
61
;;;;;;;;;;;;; i18n ;;;;;;;;;;;;;;;;;;;;;;


(define i18n-text
  (list
Dave Griffiths's avatar
Dave Griffiths committed
62
   (list 'test-num (list "1.0000000" "1.0000000" "1.0000000"))
63
64
65
66
67
68
   (list 'test-text (list "I am test text" "I am test text" "I am test text"))
   (list 'one (list "one"))
   (list 'two (list "two"))
   (list 'three (list "three"))
   (list 'village (list "Village"))
   (list 'household (list "Household"))
69
   (list 'households (list "Households"))
70
   (list 'individual (list "Individual"))
71
   (list 'individuals (list "Individuals"))
72

73
   (list 'add-item-to-list (list "+"))
74
   (list 'default-village-name (list "New village"))
Dave Griffiths's avatar
Dave Griffiths committed
75

76
77
78
79
80
81
   (list 'title (list "Symbai" "Symbai" "Symbai"))
   (list 'sync (list "Sync" "Sync" "Sync"))
   (list 'languages (list "Choose language" "Choose language" "Choose language"))
   (list 'english (list "English" "English" "English"))
   (list 'khasi (list "Khasi" "Khasi" "Khasi"))
   (list 'hindi (list "Hindi" "Hindi" "Hindi"))
Dave Griffiths's avatar
Dave Griffiths committed
82
   (list 'user-id (list "Your user ID" "User ID" "User ID"))
83
84
85
   (list 'save (list "Save" "Save" "Save"))
   (list 'back (list "Back" "Back" "Back"))
   (list 'off (list "Off" "Off" "Off"))
Dave Griffiths's avatar
Dave Griffiths committed
86
   (list 'villages (list "Villages" "Villages" "Villages"))
87
88
89
90
   (list 'list-empty (list "List empty"))
   (list 'delete (list "Delete"))
   (list 'delete-are-you-sure (list "Are you sure you want to delete this?"))
   (list 'save-are-you-sure (list "Are you sure you want to save changes?"))
Dave Griffiths's avatar
Dave Griffiths committed
91

92
93
94
   ;; individual filter
   (list 'quick-name (list "New person name"))
   (list 'quick-add (list "Quick add"))
95
96
97
98
99
   (list 'find-individual (list "Find individual"))
   (list 'filter (list "Filter"))
   (list 'off (list "Off" "Off" "Off"))
   (list 'name (list "Name"))

100
101
102
103
104
105
106
107
108
109
110
   ;; sync
   (list 'sync-all (list "Sync me!"))
   (list 'sync-syncall (list "Sync everything"))
   (list 'export-data (list "Exporting data"))
   (list 'sync-download (list "Download main DB"))
   (list 'sync-export (list "Email main DB"))
   (list 'email-local (list "Email local DB"))
   (list 'debug (list "Debug"))
   (list 'sync-back (list "Back"))
   (list 'sync-prof (list "Profile"))

Dave Griffiths's avatar
Dave Griffiths committed
111
   ;; village screen
112
   (list 'village-name (list "Village name" "Village name" "Village name"))
Dave Griffiths's avatar
Dave Griffiths committed
113
114
115
116
117
118
119
   (list 'block (list "Block" "Block" "Block"))
   (list 'district (list "District" "District" "District"))
   (list 'car (list "Accessible by car"))
   (list 'household-list (list "Household list"))
   (list 'amenities (list "Amenities"))
   (list 'school (list "School"))
   (list 'present (list "Present"))
Dave Griffiths's avatar
Dave Griffiths committed
120
   (list 'closest-access (list "Closest place of access"))
Dave Griffiths's avatar
Dave Griffiths committed
121
122
   (list 'house-gps (list "GPS"))
   (list 'toilet-gps (list "GPS"))
Dave Griffiths's avatar
Dave Griffiths committed
123
124
125
126
127
128
129
130
131
132
   (list 'school (list "School"))
   (list 'hospital (list "Hospital/Health care centre"))
   (list 'post-office (list "Post Office"))
   (list 'railway-station (list "Railway station"))
   (list 'state-bus-service (list "Inter-state bus service"))
   (list 'district-bus-service (list "Inter-village/district bus service"))
   (list 'panchayat (list "Village Panchayat Office"))
   (list 'NGO (list "Presence of NGO's working with them"))
   (list 'market (list "Market"))

133
   ;; household
Dave Griffiths's avatar
Dave Griffiths committed
134
135
   (list 'household-name (list "Household name"))
   (list 'default-household-name (list "A household"))
136
137
138
139
140
141
142
143
144
145
146
   (list 'location (list "House location"))
   (list 'elevation (list "Elevation"))
   (list 'toilet-location (list "Toilet location"))
   (list 'children (list "Children"))
   (list 'male (list "Male"))
   (list 'female (list "Female"))
   (list 'num-pots (list "Number of pots"))
   (list 'adults (list "Adults"))
   (list 'add-individual (list "Add individual"))

   ;; individual
Dave Griffiths's avatar
Dave Griffiths committed
147
148
149
   (list 'default-individual-name (list "A person"))
   (list 'default-family-name (list "A family"))
   (list 'default-photo-id (list "???"))
Dave Griffiths's avatar
Dave Griffiths committed
150
151
152
153
154
155
156
157
158
159
   (list 'name-display (list "Name"))
   (list 'photo-id-display (list "Photo ID"))
   (list 'family-display (list "Family"))
   (list 'details-button (list "Details"))
   (list 'family-button (list "Family"))
   (list 'migration-button (list "Migration"))
   (list 'income-button (list "Income"))
   (list 'geneaology-button (list "Geneaology"))
   (list 'social-button (list "Social"))
   (list 'agreement-button (list "Agreement"))
160
   (list 'is-a-child (list "Child"))
161
162
163

   ;; details
   (list 'change-photo (list "Change photo"))
Dave Griffiths's avatar
Dave Griffiths committed
164
165
166
   (list 'details-name (list "Name"))
   (list 'details-photo-id (list "Photo ID"))
   (list 'details-family (list "Family"))
167
168
   (list 'tribe (list "Tribe"))
   (list 'sub-tribe (list "Sub tribe"))
Dave Griffiths's avatar
Dave Griffiths committed
169
170
171
172
173
   (list 'khasi (list "Khasi"))
   (list 'khynriam (list "Khynriam"))
   (list 'pnar (list "Pnar"))
   (list 'bhoi (list "Bhoi"))
   (list 'war (list "War"))
174
175
176
177
   (list 'other (list "Other"))
   (list 'age (list "Age"))
   (list 'gender (list "Gender"))
   (list 'education (list "Education"))
Dave Griffiths's avatar
Dave Griffiths committed
178
179
180
181
182
183
184
185
   (list 'illiterate (list "Illiterate"))
   (list 'literate (list "Literate"))
   (list 'primary (list "Primary 1-5"))
   (list 'middle (list "Middle 6-8"))
   (list 'high (list "High 9-10"))
   (list 'secondary (list "Higher Secondary"))
   (list 'university (list "University"))

186
187
188

   ;; family
   (list 'spouse (list "Spouse"))
Dave Griffiths's avatar
Dave Griffiths committed
189
   (list 'change-id (list "Change"))
190
191
192
193
194
195
196
197
   (list 'head-of-house (list "Head of house"))
   (list 'marital-status (list "Marital status"))
   (list 'ever-married (list "Ever married"))
   (list 'currently-married (list "Currently married"))
   (list 'currently-single (list "Currently single"))
   (list 'seperated (list "Seperated/divorced"))
   (list 'times-married (list "How many times married"))
   (list 'change-spouse (list "Change/add spouse"))
Dave Griffiths's avatar
Dave Griffiths committed
198
199
200
201
   (list 'children-living (list "Living"))
   (list 'children-dead (list "Dead"))
   (list 'children-together (list "Living together"))
   (list 'children-apart (list "Living apart"))
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
   (list 'residence-after-marriage (list "Residence after marriage"))
   (list 'birthplace (list "Birthplace"))
   (list 'spouse-village (list "Spouses natal village"))
   (list 'num-siblings (list "Number of living siblings of the same sex born from same mother"))
   (list 'birth-order (list "Birth order amoung currently living same sex siblings born from same mother"))

   ;; migration
   (list 'length-time (list "Length of time lived in this village (years)"))
   (list 'place-of-birth (list "Place of birth"))
   (list 'num-residence-changes (list "Number of time place of residence changed since birth"))
   (list 'village-visits-month (list "Number of times you have visited another village in the last month"))
   (list 'village-visits-year (list "Number of times you have visited another village in the last year (i.e. betwen last summer and this summer)"))

   ;; income
   (list 'occupation (list "Occupation"))
   (list 'occupation (list "Occupation"))
   (list 'agriculture (list "Agriculture"))
   (list 'gathering (list "Gathering"))
   (list 'labour (list "Labour"))
   (list 'cows (list "Cows"))
   (list 'fishing (list "Fishing"))
Dave Griffiths's avatar
Dave Griffiths committed
223
224
225
226
227
   (list 'num-people-in-house (list "People living in house"))
   (list 'contribute (list "Contribute to family earnings?"))
   (list 'own-land (list "Own land?"))
   (list 'rent-land (list "Rent out your land?"))
   (list 'hire-land (list "Hire land?"))
228
229
230
231
232
233
234
235
236
237
238
   (list 'crops (list "Crops"))
   (list 'crop (list "Crop"))
   (list 'unit (list "Unit"))
   (list 'quantity (list "Quantity"))
   (list 'used-or-eaten (list "Used/Eaten"))
   (list 'sold (list "Sold"))
   (list 'seed (list "Seed (hybrid/local)"))
   (list 'house-type (list "House type"))
   (list 'concrete (list "Concrete"))
   (list 'tin (list "Tin"))
   (list 'thatched (list "Thatched"))
Dave Griffiths's avatar
Dave Griffiths committed
239
240
   (list 'loan (list "Outstanding loans"))
   (list 'earning (list "One day's earnings"))
241
242
243
244
   (list 'in-the-home (list "In the home"))
   (list 'radio (list "Radio"))
   (list 'tv (list "TV"))
   (list 'mobile (list "Mobile phone"))
Dave Griffiths's avatar
Dave Griffiths committed
245
246
   (list 'visit-market (list "Tribal market visits"))
   (list 'town-sell (list "Town or city visits"))
247
248
249
250
251
252
253
254

   ;; geneaology
   (list 'mother (list "Mother"))
   (list 'father (list "Father"))
   (list 'change-mother (list "Change mother"))
   (list 'change-father (list "Change father"))
   (list 'alive (list "Alive"))
   (list 'sex (list "Sex"))
Dave Griffiths's avatar
Dave Griffiths committed
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283

   ;; social
   (list 'social-one (list "One"))
   (list 'social-two (list "Two"))
   (list 'social-three (list "Three"))
   (list 'social-four (list "Four"))
   (list 'social-five (list "Five"))
   (list 'social-relationship (list "Relationship"))
   (list 'social-residence (list "Residence"))
   (list 'social-strength (list "Strength"))
   (list 'mother (list "Mother"))
   (list 'father (list "Father"))
   (list 'sister (list "Sister"))
   (list 'brother (list "Brother"))
   (list 'spouse (list "Spouse"))
   (list 'children (list "Children"))
   (list 'co-wife (list "Co-wife"))
   (list 'spouse-mother (list "Spouse's mother"))
   (list 'spouse-father (list "Spouse's father"))
   (list 'spouse-brother-wife (list "Spouse's brother's wife"))
   (list 'spouse-sister-husband (list "Spouse's sister's husband"))
   (list 'friend (list "Friend"))
   (list 'neighbour (list "Neighbour"))
   (list 'same (list "Same"))
   (list 'daily (list "Daily"))
   (list 'weekly (list "Weekly"))
   (list 'monthly (list "Monthly"))
   (list 'less (list "Less"))

284
285
   ))

286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
(define individual-ktvlist
  (list
   (ktv-create "name" "varchar" (mtext-lookup 'default-individual-name))
   (ktv-create "family" "varchar" (mtext-lookup 'default-family-name))
   (ktv-create "photo-id" "varchar" (mtext-lookup 'default-photo-id))
   (ktv-create "photo" "file" "none")
   (ktv-create "tribe" "varchar" "none")
   (ktv-create "subtribe" "varchar" "none")
   (ktv-create "child" "int" 0)
   (ktv-create "age" "int" 0)
   (ktv-create "gender" "varchar" "Female")
   (ktv-create "education" "varchar" "none")
   (ktv-create "head-of-house" "varchar" "none")
   (ktv-create "marital-status" "varchar" "none")
   (ktv-create "times-married" "int" 0)
   (ktv-create "id-spouse" "varchar" "none")
   (ktv-create "children-living" "int" 0)
   (ktv-create "children-dead" "int" 0)
   (ktv-create "children-together" "int" 0)
   (ktv-create "children-apart" "int" 0)
   (ktv-create "residence-after-marriage" "varchar" "none")
   (ktv-create "num-siblings" "int" 0)
   (ktv-create "birth-order" "int" 0)
   (ktv-create "length-time" "int" 0)
   (ktv-create "place-of-birth" "varchar" "none")
   (ktv-create "num-residence-changes" "int" 0)
   (ktv-create "village-visits-month" "int" 0)
   (ktv-create "village-visits-year" "int" 0)
   (ktv-create "occupation" "varchar" "none")
   (ktv-create "contribute" "int" 0)
   (ktv-create "own-land" "int" 0)
   (ktv-create "rent-land" "int" 0)
   (ktv-create "hire-land" "int" 0)
   (ktv-create "house-type" "varchar" "none")
   (ktv-create "loan" "int" 0)
   (ktv-create "earning" "int" 0)
   (ktv-create "radio" "int" 0)
   (ktv-create "tv" "int" 0)
   (ktv-create "mobile" "int" 0)
   (ktv-create "visit-market" "int" 0)
   (ktv-create "town-sell" "int" 0)
   ))
Dave Griffiths's avatar
Dave Griffiths committed
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;;

(define (debug! txt)
  (set-current! 'debug-text (string-append txt "\n" (get-current 'debug-text ""))))

(define (update-debug)
  (update-widget 'debug-text-view (get-id "sync-debug") 'text
                 (get-current 'debug-text "")))

(define (debug-timer-cb)
  (append
   (cond
    ((get-current 'sync-on #f)
     (set-current! 'upload 0)
     (set-current! 'download 0)
     (connect-to-net
      (lambda ()
Dave Griffiths's avatar
Dave Griffiths committed
347
        (msg "connected, going in...")
Dave Griffiths's avatar
Dave Griffiths committed
348
349
350
351
352
353
        (append
         (list (toast "sync-cb"))
         (upload-dirty db)
         (suck-new db "sync")))))
    (else '()))
   (list
Dave Griffiths's avatar
Dave Griffiths committed
354
    (delayed "debug-timer" (+ 10000 (random 5000)) debug-timer-cb)
Dave Griffiths's avatar
Dave Griffiths committed
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
    (update-debug))))


(define pf-length 20) ;; minutes...

(define (timer-cb)
  (set-current!
   'timer-seconds
   (- (get-current 'timer-seconds 59) 1))
  (append
   (cond
    ((< (get-current 'timer-seconds 59) 0)
     (set-current! 'timer-minutes (- (get-current 'timer-minutes pf-length) 1))
     (set-current! 'timer-seconds 59)
     (cond ((< (get-current 'timer-minutes pf-length) 1)
            (list
             (alert-dialog
              "pup-focal-end"
              "Pup focal time is up, have you finished?"
              (lambda (v)
                (cond
                 ((eqv? v 1)
                  (list (finish-activity 1)))
                 (else
                  (set-current! 'timer-minutes 1)
                  (list)))))))
           (else
            (list (replace-fragment (get-id "pf-top") "pf-scan1")))))
    (else '()))
   (list
    (delayed "timer" 1000 timer-cb)
    (update-widget
     'text-view (get-id "pf-timer-time-minutes") 'text
     (string-append (number->string (get-current 'timer-minutes pf-length))))
    (update-widget
     'text-view (get-id "pf-timer-time") 'text
     (string-append (number->string (get-current 'timer-seconds 59))))
    )))


(define (force-pause)
  (list
   (delayed "timer" 1000 (lambda () '()))
   (update-widget 'toggle-button (get-id "pf-pause") 'checked 1)))

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; fragments

(define-fragment-list

  (fragment
406
407
   "top"
   (horiz
Dave Griffiths's avatar
Dave Griffiths committed
408
    (image-view 0 "face" (layout 48 64 -1 'centre 0))
409
    (text-view (make-id "title") "" 30
410
411
412
413
               (layout 'fill-parent 'fill-parent 0.25 'centre 10))

    (linear-layout
     0 'vertical
Dave Griffiths's avatar
Dave Griffiths committed
414
     (layout 'fill-parent 'wrap-content 0.75 'centre 0)
415
416
417
418
     (list 0 0 0 0)

     (list
      (text-view (make-id "") 'name 20
Dave Griffiths's avatar
Dave Griffiths committed
419
                 (layout 'fill-parent 'wrap-content 1 'centre 0))
420
      (text-view (make-id "") 'photo-id 20
Dave Griffiths's avatar
Dave Griffiths committed
421
                 (layout 'fill-parent 'wrap-content 1 'centre 0)))))
Dave Griffiths's avatar
Dave Griffiths committed
422
423
424
   (lambda (fragment arg)
     (activity-layout fragment))
   (lambda (fragment arg)
425
426
427
     (list
      (update-widget 'text-view (get-id "title") 'text
                     (get-current 'activity-title "Title not set"))))
Dave Griffiths's avatar
Dave Griffiths committed
428
429
430
431
432
433
   (lambda (fragment) '())
   (lambda (fragment) '())
   (lambda (fragment) '())
   (lambda (fragment) '()))


434
435
436
437
  (fragment
   "bottom"
   (linear-layout
    0 'horizontal
Dave Griffiths's avatar
Dave Griffiths committed
438
    (layout 'fill-parent 'fill-parent 1 'centre 0)
439
440
    (list 0 0 0 0)
    (list
441
     (mbutton-scale
442
      'save
443
444
445
446
      (lambda ()
        (list
         (alert-dialog
          "ok-check"
447
          (mtext-lookup 'save-are-you-sure)
448
449
450
451
          (lambda (v)
            (cond
             ((eqv? v 1)
              (entity-update-values!)
452
              (list))
453
454
             (else
              (list))))))))
455
     (mbutton-scale 'back (lambda () (list (finish-activity 1))))))
456
457
458
459
460
461
462
463
   (lambda (fragment arg)
     (activity-layout fragment))
   (lambda (fragment arg)
     (list))
   (lambda (fragment) '())
   (lambda (fragment) '())
   (lambda (fragment) '())
   (lambda (fragment) '()))
Dave Griffiths's avatar
Dave Griffiths committed
464
465
466
467
468
469


  )

(msg "one")

Dave Griffiths's avatar
Dave Griffiths committed
470
471
472
473
(define (build-activity . contents)
  (vert-fill
   (relative
    '(("parent-top"))
474
    colour-one ;;(list 100 100 255 127)
Dave Griffiths's avatar
Dave Griffiths committed
475
476
477
478
479
480
481
482
483
    (build-fragment "top" (make-id "top") fillwrap))

   (scroll-view-vert
    0 (layout 'fill-parent 'fill-parent 1 'centre 0)
    (list
     (apply vert-fill contents)))

   (relative
    '(("parent-bottom"))
484
    colour-one
Dave Griffiths's avatar
Dave Griffiths committed
485
486
487
488
    (vert
     (spacer 5)
     (build-fragment "bottom" (make-id "bottom") fillwrap)))))

489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521

(define (grid-ify widgets n)
  (map
   (lambda (w)
     (linear-layout
      0 'horizontal
      (layout 'wrap-content 'wrap-content 1 'left 0)
      (list 0 0 0 0)
      w))
   (chop widgets n)))

(define (filter-set! l)
  (set-current! 'individual-filter l))

(define (filter-clear!)
  (filter-set! '()))

(define (filter-add! f)
  (set-current!
   'individual-filter
   (merge-filter f (get-current 'individual-filter '()))))

(define (filter-remove! key)
  (set-current!
   'individual-filter
   (delete-filter key (get-current 'individual-filter '()))))

(define (filter-get)
  (get-current 'individual-filter '()))

(define button-size (list (inexact->exact (round (* 192 0.9)))
                          (inexact->exact (round (* 256 0.9)))))

522

523
524
525
526
527
528
529
530
(define (update-individual-filter)
  (update-widget
   'linear-layout (get-id "choose-pics") 'contents
   (grid-ify
    (map
     (lambda (e)
       (let* ((id (ktv-get e "unique_id"))
              (image-name (ktv-get e "photo"))
531
              (image (if (image-invalid? image-name)
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
                         "face" (string-append "/sdcard/symbai/files/" image-name))))
         (if (equal? image "face")
             (button
              (make-id (string-append "chooser-" id))
              (ktv-get e "name") 30 (layout (car button-size) (cadr button-size) 1 'centre 5)
              (lambda ()
                (set-current! 'choose-result id)
                (list (finish-activity 0))))
             (image-button
              (make-id (string-append "chooser-" id))
              image (layout (car button-size) (cadr button-size) 1 'centre 5)
              (lambda ()
                (set-current! 'choose-result id)
                (list (finish-activity 0)))))))
     (db-filter db "sync" "individual" (filter-get)))
    3)))

549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
(define (image-from-unique-id db table unique-id)
  (let ((e (get-entity-by-unique db table unique-id)))
    (ktv-get e "photo")))

(define (build-person-selector id key filter request-code)
  (vert
   (mtitle id)
   (image-view (make-id (string-append (symbol->string id) "-image"))
               "face" (layout 240 320 -1 'centre 0))
   (button
    (make-id (string-append "change-" (symbol->string id)))
    (mtext-lookup 'change-id)
    40 (layout 'fill-parent 'wrap-content -1 'centre 5)
    (lambda ()
      (filter-set! filter)
      (list (start-activity "individual-chooser" request-code ""))))))

Dave Griffiths's avatar
Dave Griffiths committed
566
567
568
569
570
571
572
573
574
575
576
577
578
579
(define (build-small-person-selector id key filter request-code)
  (vert
   (mtitle id)
   (image-view (make-id (string-append (symbol->string id) "-image"))
               "face" (layout 120 160 -1 'centre 0))
   (button
    (make-id (string-append "change-" (symbol->string id)))
    (mtext-lookup 'change-id)
    40 (layout 'fill-parent 'wrap-content -1 'centre 5)
    (lambda ()
      (filter-set! filter)
      (list (start-activity "individual-chooser" request-code ""))))))


580
581
582
583
;; from activity on result with request id: choose-code
;; todo determine *which* selector this came from...
(define (person-selector-return request-code key choose-code)
  (when (eqv? request-code choose-code)
584
        (entity-set-value! key "varchar" (get-current 'choose-result "not set"))))
585
586
587
588
589
590
591
592
593
594
595
596
597

;; need to load from across entities, so need db, table
(define (update-person-selector db table id key)
  (msg "update-person-selector" key)
  (let ((entity-id (entity-get-value key)))
    (msg "entity-id is" entity-id)
    (let ((image-name (image-from-unique-id db table entity-id))
          (id (get-id (string-append (symbol->string id) "-image"))))
      (msg "image-name is" image-name)
      (if (image-invalid? image-name)
          (update-widget 'image-view id 'image "face")
          (update-widget 'image-view id 'external-image (string-append dirname "files/" image-name))))))

Dave Griffiths's avatar
Dave Griffiths committed
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
(define (build-social-connection id key type request-code)
  (let ((id-text (string-append (symbol->string id))))
    (horiz
     (build-small-person-selector id key (list) request-code)
     (mspinner-other-vert
      (string->symbol (string-append id-text "-relationship"))
      'social-relationship
      social-relationship-list
      (lambda (v)
        (entity-set-value! (string-append key "-relationship") "varchar" v) '()))
     (mspinner-other-vert
      (string->symbol (string-append id-text "-residence"))
      'social-residence
      social-residence-list
      (lambda (v)
        (entity-set-value! (string-append key "-residence") "varchar" v) '()))
     (vert
      (text-view 0 (mtext-lookup 'social-strength)
                 30 (layout 'wrap-content 'wrap-content 1 'centre 10))
      (spinner
       (make-id (dbg (string-append id-text "-strength")))
       (map mtext-lookup  social-strength-list)
       (layout 'wrap-content 'wrap-content 1 'centre 0)
       (lambda (v)
         (entity-set-value! (string-append key "-strength") "varchar" v) '()))))))

(define (social-connection-return request-code key choose-code)
  (when (eqv? request-code choose-code)
        (entity-set-value! key "varchar" (get-current 'choose-result "not set"))))

(define (update-social-connection db table id key type request-code)
  (let ((id-text (string-append (symbol->string id))))
    (list
     ;;(update-person-selector db table id key)
     (mupdate-spinner-other
      (string->symbol (string-append id-text "-relationship"))
      (string-append key "-relationship")
      social-relationship-list)
;     (mupdate-spinner-other
;      (string->symbol (string-append id-text "-residence"))
;      (string-append key "-residence")
;      social-residence-list)
;     (mupdate-spinner
;      (string->symbol (dbg (string-append id-text "-strength")))
;      (string-append key "-strength")
;      social-strength-list)
     )))

Dave Griffiths's avatar
Dave Griffiths committed
646
647
648
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; activities

649
(define photo-code 999)
650
(define choose-code 998)
651
652
653
(define spouse-request-code 997)
(define mother-request-code 996)
(define father-request-code 995)
Dave Griffiths's avatar
Dave Griffiths committed
654

Dave Griffiths's avatar
Dave Griffiths committed
655
656
657
658
659
660
(define social-request-code-one 994)
(define social-request-code-two 993)
(define social-request-code-three 992)
(define social-request-code-four 991)
(define social-request-code-five 990)

Dave Griffiths's avatar
Dave Griffiths committed
661
662
663
664
(define-activity-list

  (activity
   "main"
665
666
667
668
   (build-activity
    (mtitle 'title)
    (horiz
     (medit-text 'user-id "normal" (lambda () (list)))
669
     (mbutton-scale 'sync (lambda () (list (start-activity "sync" 0 "")))))
670

671
672
673
    (horiz
     (mspinner 'languages (list 'english 'khasi 'hindi) (lambda (c) (list)))
     (mbutton-scale 'find-individual (lambda () (list (start-activity "individual-chooser" choose-code "")))))
674
    (build-list-widget
Dave Griffiths's avatar
Dave Griffiths committed
675
     db "sync" 'villages "village" "village" (lambda () #f)
676
     (list
677
678
679
680
      (ktv-create "name" "varchar" (mtext-lookup 'default-village-name))
      (ktv-create "block" "varchar" "")
      (ktv-create "district" "varchar" "test")
      (ktv-create "car" "int" 0))))
681

682
   (lambda (activity arg)
683
     (set-current! 'activity-title "Main screen")
684
685
     (activity-layout activity))
   (lambda (activity arg)
Dave Griffiths's avatar
Dave Griffiths committed
686
687
688
689
690
691
692
     (list
      (gps-start "gps" (lambda (loc)
                         (set-current! 'location loc)
                         (list (toast (string-append
                                       (number->string (car loc)) ", "
                                       (number->string (cadr loc)))))))
      (update-list-widget db "sync" "village" "village" #f)))
693
694
695
696
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
697
698
   (lambda (activity requestcode resultcode)
     (cond
699
700
      ((eqv? requestcode choose-code)
       (list (start-activity "individual" 0 (get-current 'choose-result 0))))
701
702
703
704
705
706
707
      ((eqv? requestcode photo-code)
       (msg "camera returned" resultcode)
       (list (update-widget
              'image-view (get-id "image")
              'external-image (string-append dirname "photo.jpg"))))
      (else
       '()))))
708
709
710
711


  (activity
   "village"
Dave Griffiths's avatar
Dave Griffiths committed
712
713
714
   (let ((place-widgets
          (lambda (id shade)
            (horiz-colour
715
             (if shade colour-one colour-two)
Dave Griffiths's avatar
Dave Griffiths committed
716
717
718
             (mtoggle-button-scale id (lambda (v) '()))
             (medit-text-scale 'closest-access "normal" (lambda (v) '()))
             (vert
Dave Griffiths's avatar
Dave Griffiths committed
719
              (mbutton-scale 'gps (lambda ()  '()))
720
721
              (mtext-small 'test-num)
              (mtext-small 'test-num))))))
Dave Griffiths's avatar
Dave Griffiths committed
722
723
     (build-activity
      (horiz
724
725
       (medit-text 'village-name "normal" (lambda (v) (entity-set-value! "name" "varchar" v) '()))
       (medit-text 'block "normal" (lambda (v) (entity-set-value! "block" "varchar" v) '())))
Dave Griffiths's avatar
Dave Griffiths committed
726
      (horiz
727
728
       (medit-text 'district "normal" (lambda (v) (entity-set-value! "district" "varchar" v) '()))
       (mtoggle-button-scale 'car (lambda (v) (entity-set-value! "car" "int" v) '())))
729

Dave Griffiths's avatar
Dave Griffiths committed
730
731
732
733
      (mbutton 'household-list
               (lambda ()
                 (list (start-activity "household-list" 0
                                       (get-current 'village #f)))))
734

Dave Griffiths's avatar
Dave Griffiths committed
735
736
737
738
739
740
741
742
743
      (mtitle 'amenities)
      (place-widgets 'school #t)
      (place-widgets 'hospital #f)
      (place-widgets 'post-office #t)
      (place-widgets 'railway-station #f)
      (place-widgets 'state-bus-service #t)
      (place-widgets 'district-bus-service #f)
      (place-widgets 'panchayat #t)
      (place-widgets 'NGO #f)
744
745
      (place-widgets 'market #t)
      (delete-button)))
Dave Griffiths's avatar
Dave Griffiths committed
746
   (lambda (activity arg)
747
     (set-current! 'activity-title "Village")
Dave Griffiths's avatar
Dave Griffiths committed
748
749
     (activity-layout activity))
   (lambda (activity arg)
750
     (entity-init! db "sync" "village" (get-entity-by-unique db "sync" arg))
751
     (set-current! 'village arg)
752
753
754
755
     (list
      (mupdate 'edit-text 'village-name "name")
      (mupdate 'edit-text 'block "block")
      (mupdate 'edit-text 'district "district")
Dave Griffiths's avatar
Dave Griffiths committed
756
      (mupdate 'toggle-button 'car "car")))
Dave Griffiths's avatar
Dave Griffiths committed
757
758
759
760
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
Dave Griffiths's avatar
Dave Griffiths committed
761
   (lambda (activity requestcode resultcode) '()))
Dave Griffiths's avatar
Dave Griffiths committed
762

Dave Griffiths's avatar
Dave Griffiths committed
763
764
765
766

  (activity
   "household-list"
   (build-activity
767
    (build-list-widget
Dave Griffiths's avatar
Dave Griffiths committed
768
     db "sync" 'households "household" "household" (lambda () (get-current 'village #f))
769
     (list
770
771
772
773
774
775
      (ktv-create "name" "varchar" (mtext-lookup 'default-household-name))
      (ktv-create "num-pots" "int" 0)
      (ktv-create "house-lat" "real" 0) ;; get from current location?
      (ktv-create "house-lon" "real" 0)
      (ktv-create "toilet-lat" "real" 0)
      (ktv-create "toilet-lon" "real" 0))))
Dave Griffiths's avatar
Dave Griffiths committed
776
   (lambda (activity arg)
777
     (set-current! 'activity-title "Household List")
Dave Griffiths's avatar
Dave Griffiths committed
778
     (activity-layout activity))
779
   (lambda (activity arg)
Dave Griffiths's avatar
Dave Griffiths committed
780
     (msg "rebuilding household list with" arg)
Dave Griffiths's avatar
Dave Griffiths committed
781
782
     (list (update-list-widget
            db "sync" "household" "household" arg)))
Dave Griffiths's avatar
Dave Griffiths committed
783
784
785
786
787
788
789
790
791
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity requestcode resultcode) '()))

  (activity
   "household"
   (build-activity
792
    (horiz
793
794
     (medit-text 'household-name "normal" (lambda (v) (entity-set-value! "name" "varchar" v) '()))
     (medit-text 'num-pots "numeric" (lambda (v) (entity-set-value! "num-pots" "int" v) '())))
795
796
    (horiz
     (vert
Dave Griffiths's avatar
Dave Griffiths committed
797
798
799
800
      (mtext 'location)
      (mbutton 'house-gps (lambda () (do-gps 'house "house")))
      (mtext-small 'house-lat)
      (mtext-small 'house-lon))
801
     (vert
Dave Griffiths's avatar
Dave Griffiths committed
802
803
804
805
806
      (mtext 'toilet-location)
      (mbutton 'toilet-gps (lambda () (do-gps 'toilet "toilet")))
      (mtext-small 'toilet-lat)
      (mtext-small 'toilet-lon)))

807
808

    (build-list-widget
Dave Griffiths's avatar
Dave Griffiths committed
809
810
     db "sync" 'individuals "individual" "individual"
     (lambda () (get-current 'household #f))
811
     individual-ktvlist)
Dave Griffiths's avatar
Dave Griffiths committed
812

Dave Griffiths's avatar
Dave Griffiths committed
813
    (delete-button))
Dave Griffiths's avatar
Dave Griffiths committed
814
   (lambda (activity arg)
815
     (set-current! 'activity-title "Household")
Dave Griffiths's avatar
Dave Griffiths committed
816
     (activity-layout activity))
817
818
819
   (lambda (activity arg)
     (entity-init! db "sync" "household" (get-entity-by-unique db "sync" arg))
     (set-current! 'household arg)
Dave Griffiths's avatar
Dave Griffiths committed
820
821
822
823
824
825
826
     (append
      (list
       (update-list-widget db "sync" "individual" "individual" arg)
       (mupdate 'edit-text 'household-name "name")
       (mupdate 'edit-text 'num-pots "num-pots"))
      (mupdate-gps 'house "house")
      (mupdate-gps 'toilet "toilet")))
827

Dave Griffiths's avatar
Dave Griffiths committed
828
829
830
831
832
833
834
835
836
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity requestcode resultcode) '()))

  (activity
   "individual"
   (build-activity
837
838
839
    (horiz
     (image-view (make-id "photo") "face" (layout 240 320 -1 'centre 10))
     (vert
Dave Griffiths's avatar
Dave Griffiths committed
840
      (mtext 'name-display)
841
      (spacer 20)
Dave Griffiths's avatar
Dave Griffiths committed
842
      (mtext 'family-display)
843
      (spacer 20)
844
845
846
847
      (mtext 'photo-id-display)
      (spacer 20)
      (mtoggle-button-scale 'is-a-child (lambda (v) (entity-set-value! "child" "int" v) '()))
      ))
848
    (mbutton 'agreement-button (lambda () (list (start-activity "agreement" 0 ""))))
849
    (horiz
Dave Griffiths's avatar
Dave Griffiths committed
850
851
     (mbutton-scale 'details-button (lambda () (list (start-activity "details" 0 ""))))
     (mbutton-scale 'family-button (lambda () (list (start-activity "family" 0 "")))))
852
    (horiz
Dave Griffiths's avatar
Dave Griffiths committed
853
854
     (mbutton-scale 'migration-button (lambda () (list (start-activity "migration" 0 ""))))
     (mbutton-scale 'income-button (lambda () (list (start-activity "income" 0 "")))))
855
    (horiz
Dave Griffiths's avatar
Dave Griffiths committed
856
857
     (mbutton-scale 'geneaology-button (lambda () (list (start-activity "geneaology" 0 ""))))
     (mbutton-scale 'social-button (lambda () (list (start-activity "social" 0 "")))))
858
    (spacer 20)
Dave Griffiths's avatar
Dave Griffiths committed
859
    (delete-button))
860

Dave Griffiths's avatar
Dave Griffiths committed
861
   (lambda (activity arg)
862
     (set-current! 'activity-title "Individual")
Dave Griffiths's avatar
Dave Griffiths committed
863
     (activity-layout activity))
Dave Griffiths's avatar
Dave Griffiths committed
864
865
866
867
   (lambda (activity arg)
     (entity-init! db "sync" "individual" (get-entity-by-unique db "sync" arg))
     (set-current! 'individual arg)
     (list
Dave Griffiths's avatar
Dave Griffiths committed
868
869
870
      (mupdate 'text-view 'name-display "name")
      (mupdate 'text-view 'family-display "family")
      (mupdate 'text-view 'photo-id-display "photo-id")
871
872
      (mupdate 'image-view 'photo "photo")
      (mupdate 'toggle-button 'is-a-child "child")))
Dave Griffiths's avatar
Dave Griffiths committed
873
874
875
876
877
878
879
880
881
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity requestcode resultcode) '()))

  (activity
   "details"
   (build-activity
882
    (horiz
Dave Griffiths's avatar
Dave Griffiths committed
883

884
     (vert
Dave Griffiths's avatar
Dave Griffiths committed
885
      (image-view (make-id "photo") "face" (layout 240 320 -1 'centre 10))
886
887
888
      (mbutton
       'change-photo
       (lambda ()
889
890
         (set-current!
          'photo-name (string-append (entity-get-value "unique_id") "-" (get-unique "p") "-face.jpg"))
Dave Griffiths's avatar
Dave Griffiths committed
891
         (list
892
          (take-photo (string-append dirname "files/" (get-current 'photo-name "")) photo-code))
Dave Griffiths's avatar
Dave Griffiths committed
893
894
         )))

895
     (vert
896
897
898
899
900
      (medit-text 'details-name "normal" (lambda (v) (entity-set-value! "name" "varchar" v) '()))
      (medit-text 'details-family "normal" (lambda (v) (entity-set-value! "family" "varchar" v) '()))
      (medit-text 'details-photo-id "normal" (lambda (v) (entity-set-value! "photo-id" "varchar" v) '()))))
    (mspinner-other 'tribe tribes-list (lambda (v) (msg "tribe now:" v) (entity-set-value! "tribe" "varchar" v) '()))
    (mspinner-other 'sub-tribe subtribe-list (lambda (v) (entity-set-value! "subtribe" "varchar" v) '()))
901
    (horiz
902
903
904
     (medit-text 'age "numeric" (lambda (v) (entity-set-value! "age" "int" v) '()))
     (mspinner 'gender '(male female) (lambda (v) (entity-set-value! "gender" "varchar" v) '()))
     (mspinner 'education education-list (lambda (v) (entity-set-value! "education" "varchar" v) '())))
Dave Griffiths's avatar
Dave Griffiths committed
905
906
    )
   (lambda (activity arg)
907
     (set-current! 'activity-title "Individual details")
Dave Griffiths's avatar
Dave Griffiths committed
908
     (activity-layout activity))
Dave Griffiths's avatar
Dave Griffiths committed
909
910
911
912
913
   (lambda (activity arg)
     (list
      (mupdate 'edit-text 'details-name "name")
      (mupdate 'edit-text 'details-family "family")
      (mupdate 'edit-text 'details-photo-id "photo-id")
914
      (mupdate 'image-view 'photo "photo")
Dave Griffiths's avatar
Dave Griffiths committed
915
916
      (mupdate-spinner-other 'tribe "tribe" tribes-list)
      (mupdate-spinner-other 'sub-tribe "subtribe" subtribe-list)
917
918
      (mupdate 'edit-text 'age "age")
      (mupdate-spinner 'gender "gender" '(male female))
Dave Griffiths's avatar
Dave Griffiths committed
919
      (mupdate-spinner 'education "education" education-list)
Dave Griffiths's avatar
Dave Griffiths committed
920
      ))
Dave Griffiths's avatar
Dave Griffiths committed
921
922
923
924
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
Dave Griffiths's avatar
Dave Griffiths committed
925
926
927
928
929
930
931
   (lambda (activity requestcode resultcode)
     (msg "back from camera")
     (cond
      ((eqv? requestcode photo-code)
       ;; todo: means we save when the camera happens
       ;; need to do this before init is called again in on-start,
       ;; which happens next
932
       (let ((unique-id (entity-get-value "unique_id")))
933
         (entity-set-value! "photo" "file" (get-current 'photo-name "error no photo name!!"))
934
935
936
         (entity-update-values!)
         ;; need to reset the individual from the db now (as update reset it)
         (entity-init! db "sync" "individual" (get-entity-by-unique db "sync" unique-id)))
Dave Griffiths's avatar
Dave Griffiths committed
937
938
939
940
       (list
        (mupdate 'image-view 'photo "photo")))
      (else
       '()))))
Dave Griffiths's avatar
Dave Griffiths committed
941
942
943
944

  (activity
   "family"
   (build-activity
945
946
    (horiz
     (vert
947
948
949
      (mspinner 'head-of-house '(male female) (lambda (v) (entity-set-value! "head-of-house" "varchar" v) '()))
      (mspinner 'marital-status married-list (lambda (v) (entity-set-value! "marital-status" "varchar" v) '()))
      (medit-text 'times-married "numeric" (lambda (v) (entity-set-value! "times-married" "int" v) '())))
950
951
952

     (build-person-selector 'spouse "id-spouse" (list) spouse-request-code)
     )
953
954
955

    (mtitle 'children)
    (horiz
956
957
     (medit-text 'children-living "numeric" (lambda (v) (entity-set-value! "children-living" "int" v) '()))
     (medit-text 'children-dead "numeric" (lambda (v) (entity-set-value! "children-dead" "int" v) '())))
958
    (horiz
959
960
     (medit-text 'children-together "numeric" (lambda (v) (entity-set-value! "children-together" "int" v) '()))
     (medit-text 'children-apart "numeric" (lambda (v) (entity-set-value! "children-apart" "int" v) '())))
961
    (mspinner-other 'residence-after-marriage '(birthplace spouse-village) (lambda (v) '()))
962
963
    (medit-text 'num-siblings "numeric" (lambda (v) (entity-set-value! "num-siblings" "int" v) '()))
    (medit-text 'birth-order "numeric" (lambda (v) (entity-set-value! "birth-order" "int" v) '())))
Dave Griffiths's avatar
Dave Griffiths committed
964
   (lambda (activity arg)
965
     (set-current! 'activity-title "Individual family")
966
      (activity-layout activity))
Dave Griffiths's avatar
Dave Griffiths committed
967
968
   (lambda (activity arg)
     (list
969
      (update-person-selector db "sync" 'spouse "id-spouse")
Dave Griffiths's avatar
Dave Griffiths committed
970
971
972
973
974
975
976
977
978
979
980
      (mupdate-spinner 'head-of-house "head-of-house" '(male female))
      (mupdate-spinner 'marital-status "marital-status" married-list)
      (mupdate 'edit-text 'times-married "times-married")
      ;;(mupdate 'id-spouse "id-spouse")
      (mupdate 'edit-text 'children-living "children-living")
      (mupdate 'edit-text 'children-dead "children-dead")
      (mupdate 'edit-text 'children-together "children-together")
      (mupdate 'edit-text 'children-apart "children-apart")
      (mupdate-spinner 'residence-after-marriage "residence-after-marriage" '(birthplace spouse-village))
      (mupdate 'edit-text 'num-siblings "num-siblings")
      (mupdate 'edit-text 'birth-order "birth-order")))
Dave Griffiths's avatar
Dave Griffiths committed
981
982
983
984
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
985
986
   (lambda (activity requestcode resultcode)
     (person-selector-return requestcode "id-spouse" spouse-request-code)
987
988
989
990
991

     ;; intercept a spouse setting and set the other individual
     ;; BIDIRECTIONAL AUTOSPOUSE
     (when (and (eqv? requestcode spouse-request-code)
                (get-current 'choose-result #f))
Dave Griffiths's avatar
Dave Griffiths committed
992
           (update-entity db "sync" (entity-id-from-unique db "sync" (get-current 'choose-result #f))
993
994
995
996
997
998
999
1000
1001
                          (list (ktv "id-spouse" "varchar" (entity-get-value "unique_id"))))
           (msg "done..."))

     ;; save and reinit otherwise we can get out of sync here with the spouse :/
     (let ((unique-id (entity-get-value "unique_id")))
       (entity-update-values!)
       ;; need to reset the individual from the db now (as update reset it)
       (entity-init! db "sync" "individual" (get-entity-by-unique db "sync" unique-id)))

1002
     '()))
Dave Griffiths's avatar
Dave Griffiths committed
1003
1004
1005
1006
1007


  (activity
   "migration"
   (build-activity
1008
1009
1010
1011
1012
    (medit-text 'length-time "numeric" (lambda (v) (entity-set-value! "length-time" "int" v) '()))
    (medit-text 'place-of-birth "normal" (lambda (v) (entity-set-value! "place-of-birth" "varchar" v) '()))
    (medit-text 'num-residence-changes "numeric" (lambda (v) (entity-set-value! "num-residence-changes" "int" v) '()))
    (medit-text 'village-visits-month "numeric" (lambda (v) (entity-set-value! "village-visits-month" "int" v) '()))
    (medit-text 'village-visits-year "numeric" (lambda (v) (entity-set-value! "village-visits-year" "int" v) '()))
Dave Griffiths's avatar
Dave Griffiths committed
1013
1014
    )
   (lambda (activity arg)
1015
     (set-current! 'activity-title "Individual migration")
Dave Griffiths's avatar
Dave Griffiths committed
1016
     (activity-layout activity))
Dave Griffiths's avatar
Dave Griffiths committed
1017
1018
1019
1020
1021
1022
1023
   (lambda (activity arg)
     (list
      (mupdate 'edit-text 'length-time "length-time")
      (mupdate 'edit-text 'place-of-birth "place-of-birth")
      (mupdate 'edit-text 'num-residence-changes "num-residence-changes")
      (mupdate 'edit-text 'village-visits-month "village-visits-month")
      (mupdate 'edit-text 'village-visits-year "village-visits-year")))
Dave Griffiths's avatar
Dave Griffiths committed
1024
1025
1026
1027
1028
1029
1030
1031
1032
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity requestcode resultcode) '()))

  (activity
   "income"
   (build-activity
Dave Griffiths's avatar
Dave Griffiths committed
1033
    (mspinner 'occupation '(agriculture gathering labour cows fishing other)
1034
              (lambda (v) (entity-set-value! "occupation" "varchar" v) '()))
1035
    (horiz
1036
1037
     (mtoggle-button-scale 'contribute (lambda (v) (entity-set-value! "contribute" "int" v) '()))
     (mtoggle-button-scale 'own-land (lambda (v) (entity-set-value! "own-land" "int" v) '())))
1038
    (horiz
1039
1040
     (mtoggle-button-scale 'rent-land (lambda (v) (entity-set-value! "rent-land" "int" v) '()))
     (mtoggle-button-scale 'hire-land (lambda (v) (entity-set-value! "hire-land" "int" v) '())))
1041
    (mtitle 'crops)
Dave Griffiths's avatar
Dave Griffiths committed
1042
1043
1044
1045
    ;; todo ->
    ;;    (horiz
    ;;     (mtext-scale 'crop) (mtext-scale 'unit) (mtext-scale 'quantity)
    ;;     (mtext-scale 'used-or-eaten) (mtext-scale 'sold) (mtext-scale 'seed))
1046
1047
    (mspinner-other 'house-type '(concrete tin thatched) (lambda (v) '()))
    (horiz
1048
1049
     (medit-text 'loan "numeric" (lambda (v) (entity-set-value! "loan" "int" v) '()))
     (medit-text 'earning "numeric" (lambda (v) (entity-set-value! "earning" "int" v) '())))
1050
1051
    (mtext 'in-the-home)
    (horiz
1052
1053
1054
     (mtoggle-button-scale 'radio (lambda (v) (entity-set-value! "radio" "int" v) '()))
     (mtoggle-button-scale 'tv (lambda (v) (entity-set-value! "tv" "int" v) '()))
     (mtoggle-button-scale 'mobile (lambda (v) (entity-set-value! "mobile" "int" v) '())))
1055
    (horiz
1056
1057
     (medit-text 'visit-market "numeric" (lambda (v) (entity-set-value! "visit-market" "int" v) '()))
     (medit-text 'town-sell "numeric" (lambda (v) (entity-set-value! "town-sell" "int" v) '())))
Dave Griffiths's avatar
Dave Griffiths committed
1058
1059
    )
   (lambda (activity arg)
1060
     (set-current! 'activity-title "Individual income")
Dave Griffiths's avatar
Dave Griffiths committed
1061
     (activity-layout activity))
Dave Griffiths's avatar
Dave Griffiths committed
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
   (lambda (activity arg)
     (list
      (mupdate-spinner 'occupation "occupation" '(agriculture gathering labour cows fishing other))
      (mupdate 'toggle-button 'contribute "contribute")
      (mupdate 'toggle-button 'own-land "own-land")
      (mupdate 'toggle-button 'rent-land "rent-land")
      (mupdate 'toggle-button 'hire-land "hire-land")
      (mupdate-spinner-other 'house-type "house-type" '(concrete tin thatched))
      (mupdate 'edit-text 'loan "loan")
      (mupdate 'edit-text 'earning "earning")
      (mupdate 'toggle-button 'radio "radio")
      (mupdate 'toggle-button 'tv "tv")
      (mupdate 'toggle-button 'mobile "mobile")
      (mupdate 'edit-text 'visit-market "visit-market")
      (mupdate 'edit-text 'town-sell "town-sell")))
Dave Griffiths's avatar
Dave Griffiths committed
1077
1078
1079
1080
1081
1082
1083
1084
1085
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity requestcode resultcode) '()))

  (activity
   "geneaology"
   (build-activity
1086
    (horiz
1087
1088
     (build-person-selector 'mother "id-mother" (list) mother-request-code)
     (build-person-selector 'father "id-father" (list) father-request-code))
1089
1090
1091
1092
1093
1094
    (mtitle 'children)
    (horiz
     (medit-text 'name "normal" (lambda (v) '()))
     (mtoggle-button-scale 'alive (lambda (v) '()))
     (mspinner 'sex '(female male) (lambda (v) '()))
     (medit-text 'age "numeric" (lambda (v) '())))
Dave Griffiths's avatar
Dave Griffiths committed
1095
1096
    )
   (lambda (activity arg)
1097
     (set-current! 'activity-title "Individual geneaology")
Dave Griffiths's avatar
Dave Griffiths committed
1098
     (activity-layout activity))
1099
1100
1101
1102
   (lambda (activity arg)
     (list
      (update-person-selector db "sync" 'mother "id-mother")
      (update-person-selector db "sync" 'father "id-father")))
Dave Griffiths's avatar
Dave Griffiths committed
1103
1104
1105
1106
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
1107
1108
1109
1110
1111
   (lambda (activity requestcode resultcode)
     (msg requestcode)
     (person-selector-return requestcode "id-mother" mother-request-code)
     (person-selector-return requestcode "id-father" father-request-code)
     '()))
Dave Griffiths's avatar
Dave Griffiths committed
1112
1113
1114
1115

  (activity
   "social"
   (build-activity
Dave Griffiths's avatar
Dave Griffiths committed
1116
1117
1118
1119
1120
    (build-social-connection 'social-one "social-one" "friend" social-request-code-one)
    (build-social-connection 'social-two "social-two" "friend" social-request-code-two)
    (build-social-connection 'social-three "social-three" "friend" social-request-code-three)
    (build-social-connection 'social-four "social-four" "friend" social-request-code-four)
    (build-social-connection 'social-five "social-five" "friend" social-request-code-five)
Dave Griffiths's avatar
Dave Griffiths committed
1121
1122
    )
   (lambda (activity arg)
1123
     (set-current! 'activity-title "Individual social network")
Dave Griffiths's avatar
Dave Griffiths committed
1124
     (activity-layout activity))
Dave Griffiths's avatar
Dave Griffiths committed
1125
1126
1127
1128
1129
1130
1131
   (lambda (activity arg)
     (append
      (update-social-connection db "sync" 'social-one "social-one" "friend" social-request-code-one)
      (update-social-connection db "sync" 'social-two "social-two" "friend" social-request-code-two)
      (update-social-connection db "sync" 'social-three "social-three" "friend" social-request-code-three)
      (update-social-connection db "sync" 'social-four "social-four" "friend" social-request-code-four)
      (update-social-connection db "sync" 'social-five "social-five" "friend" social-request-code-five)))
Dave Griffiths's avatar
Dave Griffiths committed
1132
1133
1134
1135
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
Dave Griffiths's avatar
Dave Griffiths committed
1136
1137
1138
1139
1140
1141
1142
   (lambda (activity requestcode resultcode)
     (social-connection-return requestcode "social-one" social-request-code-one)
     (social-connection-return requestcode "social-two" social-request-code-two)
     (social-connection-return requestcode "social-three" social-request-code-three)
     (social-connection-return requestcode "social-four" social-request-code-four)
     (social-connection-return requestcode "social-five" social-request-code-five)
     '()))
Dave Griffiths's avatar
Dave Griffiths committed
1143
1144
1145
1146
1147
1148

  (activity
   "agreement"
   (build-activity
    )
   (lambda (activity arg)
1149
     (set-current! 'activity-title "Individual agreement")
Dave Griffiths's avatar
Dave Griffiths committed
1150
1151
1152
1153
1154
1155
     (activity-layout activity))
   (lambda (activity arg) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
Dave Griffiths's avatar
Dave Griffiths committed
1156
1157
   (lambda (activity requestcode resultcode)
     '()))
Dave Griffiths's avatar
Dave Griffiths committed
1158
1159
1160
1161

  (activity
   "individual-chooser"
   (build-activity
1162
    (vert
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
     (horiz
      (medit-text 'quick-name "normal" (lambda (v) (set-current! 'chooser-quick-name v) '()))
      (mbutton-scale
       'quick-add
       (lambda ()
         (list
          (alert-dialog
           "quick-add-check"
           (mtext-lookup 'add-are-you-sure)
           (lambda (v)
             (cond
              ((eqv? v 1)
               (set-current!
                'choose-result
                (entity-create!
                 db "sync" "individual"
                 (ktvlist-merge
                  individual-ktvlist
                  (list
                   (ktv "name" "varchar" (get-current 'chooser-quick-name (mtext-lookup 'no-name)))
                   (ktv "parent" "varchar" (get-current 'household #f))))))
               (list (finish-activity 0))))))))))


1187
1188
1189
1190
1191
     (linear-layout
      (make-id "choose-pics") 'vertical
      (layout 'fill-parent 'wrap-content 0.75 'centre 0)
      (list 0 0 0 0)
      (list))
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
     (mtitle 'filter)
     (horiz
      (mspinner 'gender '(off female male)
                (lambda (v)
                  (if (equal? v (mtext-lookup 'off))
                      (filter-remove! "gender")
                      (filter-add! (make-filter "gender" "varchar" "=" v)))
                  (list (update-individual-filter))
                  ))
      (medit-text
       'name "normal"
       (lambda (v)
         (if (equal? v "")
             (filter-remove! "name")
             (filter-add! (make-filter "name" "varchar" "like" (string-append v "%"))))
         (list (update-individual-filter))
         ))
      )))
Dave Griffiths's avatar
Dave Griffiths committed
1210
   (lambda (activity arg)
1211
     (set-current! 'activity-title "Individual chooser")
Dave Griffiths's avatar
Dave Griffiths committed
1212
     (activity-layout activity))
1213
   (lambda (activity arg)
1214
     (list (update-individual-filter (list))))
Dave Griffiths's avatar
Dave Griffiths committed
1215
1216
1217
1218
1219
1220
1221
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity) '())
   (lambda (activity requestcode resultcode) '()))


1222
1223
1224
  (activity
   "sync"
   (vert
1225
1226
1227
    (text-view (make-id "sync-title") "Sync database" 40 fillwrap)
    (mtext 'sync-dirty "...")
    (horiz
Dave Griffiths's avatar
Dave Griffiths committed
1228
     (mtoggle-button-scale 'sync-all (lambda (v) (set-current! 'sync-on v) '()))
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
     (mbutton-scale 'sync-syncall
               (lambda ()
                 (let ((r (append
                           (spit db "sync" (dirty-and-all-entities db "sync"))
                           (spit db "stream" (dirty-and-all-entities db "stream")))))
                   (cons (toast "Uploading data...") r)))))
    (mtitle 'export-data)
    (horiz
     (mbutton-scale 'sync-download
               (lambda ()
                 (debug! (string-append "Downloading whole db"))
                 (append
                 (foldl
                  (lambda (e r)
                    (debug! (string-append "Downloading /sdcard/symbai/" e ".csv"))
                    (cons
                     (http-download
                      (string-append "getting-" e)
                      (string-append url "fn=entity-csv&table=stream&type=" e)
                      (string-append "/sdcard/mongoose/" e ".csv"))
                     r))
                  (list
                   (http-download
                    "getting-db"
                    "http://192.168.2.1:8889/symbai.db"
                    (string-append "/sdcard/symbai/symbai.db"))
                   )
                  entity-types)
                 (list))))
     (mbutton-scale 'sync-export
               (lambda ()
                 (debug! "Sending mail")
                 (list
                  (send-mail
                   ""
                   "From Symbai" "Please find attached your mongoose data"
                   (cons
                    "/sdcard/symbai/symbai.db"
                    (map
                     (lambda (e)
                       (string-append "/sdcard/symbai/" e ".csv"))
                     entity-types))))))
     (mbutton-scale 'email-local
               (lambda ()
                 (debug! "Sending mail")
                 (list
                  (send-mail
                   ""
                   "From symbai" "Please find attached your local data"
                   (list "/sdcard/symbai/local-symbai.db")))))
     )
    (spacer 10)
    (mtitle 'debug)
    (scroll-view-vert
     0 (layout 'fill-parent 200 1 'left 0)
     (list
      (vert
       (debug-text-view (make-id "sync-debug") "..." 15 (layout 'fill-parent 400 1 'left 0)))))
    (spacer 10)
    (horiz
     (mbutton-scale 'sync-back (lambda () (list (finish-activity 1))))
     (mbutton-scale 'sync-prof (lambda () (prof-print) (list))))
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
    )

   (lambda (activity arg)
     (activity-layout activity))
   (lambda (activity arg)
     (set-current! 'sync-on #f)
     (append
      (debug-timer-cb)
      (list
       (update-widget 'debug-text-view (get-id "sync-debug") 'text (get-current 'debug-text ""))
1301
       (update-widget 'text-view (get-id "sync-dirty") 'text (build-dirty db))
1302
1303
1304
1305
1306
1307
       )))
   (lambda (activity) '())
   (lambda (activity) (list (delayed "debug-timer" 1000 (lambda () '()))))
   (lambda (activity) (list (delayed "debug-timer" 1000 (lambda () '()))))
   (lambda (activity) '())
   (lambda (activity requestcode resultcode) '()))
Dave Griffiths's avatar
Dave Griffiths committed
1308

Dave Griffiths's avatar
Dave Griffiths committed
1309
1310


1311
1312
1313



Dave Griffiths's avatar
Dave Griffiths committed
1314
  )