|
41
|
1 package main
|
|
|
2
|
|
|
3 import (
|
|
|
4 "flag"
|
|
|
5 "compress/gzip"
|
|
|
6 "encoding/csv"
|
|
|
7 "fmt"
|
|
|
8 "html/template"
|
|
|
9 "io/ioutil"
|
|
|
10 "log"
|
|
|
11 "os"
|
|
|
12 "strings"
|
|
|
13 "sort"
|
|
|
14 "time"
|
|
|
15
|
|
|
16 "golang.org/x/text/encoding/japanese"
|
|
|
17 "golang.org/x/text/transform"
|
|
|
18 )
|
|
|
19
|
|
|
20 var debug_log bool
|
|
|
21
|
|
|
22 // Constants
|
|
42
|
23 const version = "0.3"
|
|
41
|
24 const default_dbfile = "ikenshoirai.db"
|
|
|
25 const default_csvfile = "ikenshoirai.csv"
|
|
|
26
|
|
|
27 const tpl = `
|
|
|
28 <!DOCTYPE html> <html>
|
|
|
29 <head>
|
|
|
30 <style type="text/css">
|
|
|
31 body { font-size: 9pt; margin-left: 0px;}
|
|
|
32 h2 { font-size: 11pt; margin-bottom: 1px; background-color: #ccccff; padding-left: 5px; }
|
|
|
33 h3 { font-size: 11pt; margin-bottom: 1px; background-color: #f0a8a8; padding-left: 10px; }
|
|
|
34 table, th, td { border: 0.3px #c0c0c0 solid; border-collapse:collapse; }
|
|
|
35 table { margin-bottom: 5px; margin-left: 15px; }
|
|
|
36 th { background-color: #ccffcc; }
|
|
|
37 hr { page-break-before: always; }
|
|
|
38 </style>
|
|
|
39 <title> - </title>
|
|
|
40 </head>
|
|
|
41 <body>
|
|
|
42
|
|
|
43 <h2> List <small>( Date = {{.Ymd}} / N = {{.NHhs}} / Dr = {{.NDr}} )</small> </h2>
|
|
|
44 {{range .Doctors}}
|
|
|
45 <h3>{{.Name}}<small> ..... {{.Hp}}:{{.Senmon}}</small></h3>
|
|
|
46 {{range .Clients}}
|
|
|
47 <table>
|
|
|
48 <tr>
|
|
|
49 <td width=140 style="background-color: #98f0f0; padding-left: 10px;">{{.Name}}</td>
|
|
|
50 <td width=120 align=center>{{.Kubun}} {{.Ymd}}</td>
|
|
|
51 <td width=480 style="padding-left: 10px;">
|
|
|
52
|
|
|
53 {{if .Prev.Ymd}}
|
|
|
54 {{if eq .DrId .Prev.DrId}}
|
|
|
55 {{str2cp932 "★ 継続 -"}} {{.Prev.Ymd}}
|
|
|
56 {{else}}
|
|
|
57 {{.Prev.Dr}} {{.Prev.Ymd}}
|
|
|
58 {{end}}
|
|
|
59 {{else}}
|
|
|
60 New !
|
|
|
61 {{end}}
|
|
|
62
|
|
|
63 </td>
|
|
|
64 <td width=80 align=center>{{.Hhsno}}</td>
|
|
|
65 </tr>
|
|
|
66 <tr>
|
|
|
67 <td colspan=4 style="font-family: serif; font-size: 8pt; padding-left: 10px;">{{.Biko}}</td>
|
|
|
68 </tr>
|
|
|
69
|
|
|
70 </table>
|
|
|
71 {{end}}
|
|
|
72 {{end}}
|
|
|
73
|
|
|
74 <hr />
|
|
|
75 {{$hpno := 0}}
|
|
|
76 <h2> N by Hp </h2>
|
|
|
77 <table>
|
|
|
78 <tr> <th> no </th> <th> hp </th> <th width=60> n </th> </tr>
|
|
|
79 {{range $hp, $n := .Hp}}
|
|
|
80 <tr>
|
|
|
81 {{$hpno = add1 $hpno}}
|
|
|
82 <td align=right style="padding-right: 5px;"> {{$hpno}} </td>
|
|
|
83 <td style="padding-left: 5px;"> {{$hp}} </td>
|
|
|
84 <td align=right style="padding-right: 5px;"> {{$n}} </td>
|
|
|
85 </tr>
|
|
|
86 {{end}}
|
|
|
87 <tr> <td></td> <td align=right> sum > > ></td> <td align=right style="padding-right: 5px;"> <b> {{.HpSum}} </b> </td> </tr>
|
|
|
88 </table>
|
|
|
89 </body>
|
|
|
90 </html>`
|
|
|
91
|
|
|
92
|
|
|
93 // Define Types
|
|
|
94 type PrevSinsei struct {
|
|
|
95 Biko string
|
|
|
96 DrId string
|
|
|
97 Dr string
|
|
|
98 IraiYmd string
|
|
|
99 Ymd string
|
|
|
100 Kubun string
|
|
|
101 }
|
|
|
102
|
|
|
103 type Sinsei struct {
|
|
|
104 Hhsno string
|
|
|
105 Name string
|
|
|
106 Biko string
|
|
|
107 DrId string
|
|
|
108 Dr string
|
|
|
109 DrKana string
|
|
|
110 Hp string
|
|
|
111 IraiYmd string
|
|
|
112 Ymd string
|
|
|
113 Kubun string
|
|
|
114 Senmon string
|
|
|
115 Prev PrevSinsei
|
|
|
116 }
|
|
|
117
|
|
|
118 func (s *Sinsei) SetPrev(prev PrevSinsei) {
|
|
|
119 s.Prev = prev
|
|
|
120 }
|
|
|
121
|
|
|
122 func (s Sinsei) String() string {
|
|
|
123 return strings.Join([]string{s.Hhsno, s.Name, s.Ymd, s.Kubun, s.Dr, s.Hp, s.Senmon, s.IraiYmd, s.Biko}, ",")
|
|
|
124 }
|
|
|
125
|
|
|
126 func (s *Sinsei) Humanize() {
|
|
|
127 var buf string
|
|
|
128
|
|
|
129 switch s.Kubun {
|
|
|
130 case "01":
|
|
|
131 buf = "新規"
|
|
|
132 case "02":
|
|
|
133 buf = "更新"
|
|
|
134 case "10":
|
|
|
135 buf = "支介"
|
|
|
136 case "05":
|
|
|
137 buf = "区変"
|
|
|
138 case "03":
|
|
|
139 buf = "転入"
|
|
|
140 case "09":
|
|
|
141 buf = "証交"
|
|
|
142 }
|
|
|
143 s.Kubun, _, _ = transform.String(japanese.ShiftJIS.NewEncoder(), buf)
|
|
|
144
|
|
|
145 s.Ymd = strings.Join([]string{s.Ymd[4:6], s.Ymd[6:8]}, ".")
|
|
|
146 }
|
|
|
147
|
|
|
148 type Doctor struct {
|
|
|
149 Id string
|
|
|
150 Name string
|
|
|
151 Kana string
|
|
|
152 Hp string
|
|
|
153 Senmon string
|
|
|
154 Clients []Sinsei
|
|
|
155 }
|
|
|
156
|
|
|
157 func (d *Doctor) AddClient(sinsei Sinsei) {
|
|
|
158 d.Clients = append(d.Clients, sinsei)
|
|
|
159 }
|
|
|
160
|
|
|
161 func (d Doctor) String() string {
|
|
|
162 return d.Name
|
|
|
163 }
|
|
|
164
|
|
|
165 // Main
|
|
|
166 func main() {
|
|
|
167 var csvfile, dbfile, date string
|
|
|
168
|
|
|
169 today := time.Now().Format("20060102")
|
|
|
170
|
|
|
171 flag.StringVar(&csvfile, "c", default_csvfile, "csv file")
|
|
|
172 flag.StringVar(&dbfile, "b", default_dbfile, "db file")
|
|
|
173 flag.StringVar(&date, "r", today, "Ikensho Irai YMD")
|
|
|
174 flag.BoolVar(&debug_log, "d", false, "print debug-log (stderr)")
|
|
|
175 flag.Parse()
|
|
|
176
|
|
|
177 csvdata, hhshash, err := getdata_fromCSV(csvfile, date)
|
|
|
178 if err != nil {
|
|
|
179 log.Fatal(err)
|
|
|
180 }
|
|
|
181 print_debug_log(fmt.Sprintf("csvdata: n=%d", len(csvdata))) //
|
|
|
182 print_debug_log(fmt.Sprintf("hhshash: n=%d", len(hhshash))) //
|
|
|
183
|
|
|
184 dbdata, err := getdata_fromDB(dbfile, hhshash)
|
|
|
185 if err != nil {
|
|
|
186 log.Fatal(err)
|
|
|
187 }
|
|
|
188 print_debug_log(fmt.Sprintf("dbdata: n=%d", len(dbdata))) //
|
|
|
189
|
|
|
190 dbdata = append(dbdata, csvdata...)
|
|
|
191 print_debug_log(fmt.Sprintf("dbdata: n=%d", len(dbdata))) //
|
|
|
192
|
|
|
193 sort.Slice(dbdata, func(i, j int) bool {
|
|
|
194 if dbdata[i].Hhsno != dbdata[j].Hhsno {
|
|
|
195 return dbdata[i].Hhsno < dbdata[j].Hhsno
|
|
|
196 }
|
|
|
197 if dbdata[i].Ymd != dbdata[j].Ymd {
|
|
|
198 return dbdata[i].Ymd > dbdata[j].Ymd
|
|
|
199 }
|
|
|
200 return false
|
|
|
201 })
|
|
|
202
|
|
|
203 var recentdata []Sinsei
|
|
|
204 prevhash := make(map[string]PrevSinsei)
|
|
|
205 hhscnt := make(map[string]int)
|
|
|
206 for _, ss := range dbdata {
|
|
|
207 ss.Humanize()
|
|
42
|
208 switch hhscnt[ss.Hhsno] {
|
|
|
209 case 0:
|
|
|
210 recentdata = append(recentdata, ss)
|
|
|
211 hhscnt[ss.Hhsno]++;
|
|
|
212 case 1:
|
|
41
|
213 prevhash[ss.Hhsno] = PrevSinsei{
|
|
|
214 Biko: ss.Biko,
|
|
|
215 DrId: ss.DrId,
|
|
|
216 Dr: ss.Dr + "(" + ss.Hp + ":" + ss.Senmon + ")",
|
|
|
217 IraiYmd: ss.IraiYmd,
|
|
|
218 Ymd: ss.Ymd,
|
|
|
219 Kubun: ss.Kubun,
|
|
|
220 }
|
|
|
221 }
|
|
|
222 }
|
|
|
223 print_debug_log(fmt.Sprintf("recentdata: n=%d", len(recentdata))) //
|
|
|
224
|
|
|
225 doctorhash := make(map[string]Doctor)
|
|
|
226 hpcnt := make(map[string]int)
|
|
|
227 var hpcntsum int
|
|
|
228 for _, ss := range recentdata {
|
|
|
229 ss.SetPrev(prevhash[ss.Hhsno])
|
|
|
230 if d, ok := doctorhash[ss.DrId]; !ok {
|
|
|
231 doctorhash[ss.DrId] = Doctor{
|
|
|
232 Id: ss.DrId,
|
|
|
233 Name: ss.Dr,
|
|
|
234 Kana: ss.DrKana,
|
|
|
235 Hp: ss.Hp,
|
|
|
236 Senmon: ss.Senmon,
|
|
|
237 Clients: []Sinsei{ss},
|
|
|
238 }
|
|
|
239 } else {
|
|
|
240 d.AddClient(ss)
|
|
|
241 doctorhash[ss.DrId] = d
|
|
|
242 }
|
|
|
243 hpcnt[ss.Hp]++
|
|
|
244 hpcntsum++
|
|
|
245 }
|
|
|
246
|
|
|
247 var doctors []Doctor
|
|
|
248 for _, dr := range doctorhash {
|
|
|
249 doctors = append(doctors, dr)
|
|
|
250 }
|
|
|
251 sort.Slice(doctors, func(i, j int) bool {
|
|
42
|
252 if doctors[i].Kana != doctors[j].Kana {
|
|
|
253 return doctors[i].Kana < doctors[j].Kana
|
|
|
254 }
|
|
|
255 if doctors[i].Id != doctors[j].Id {
|
|
|
256 return doctors[i].Id < doctors[j].Id
|
|
|
257 }
|
|
|
258 return false
|
|
41
|
259 })
|
|
|
260
|
|
|
261 irai := struct {
|
|
|
262 Ymd string
|
|
|
263 NHhs int
|
|
|
264 NSinsei int
|
|
|
265 NDr int
|
|
|
266 Doctors []Doctor
|
|
|
267 Hp map[string]int
|
|
|
268 HpSum int
|
|
|
269 }{
|
|
|
270 Ymd: strings.Join([]string{date[0:4], date[4:6], date[6:8]}, "."),
|
|
|
271 NHhs: len(hhshash),
|
|
|
272 NSinsei: len(dbdata),
|
|
|
273 NDr: len(doctors),
|
|
|
274 Doctors: doctors,
|
|
|
275 Hp: hpcnt,
|
|
|
276 HpSum: hpcntsum,
|
|
|
277 }
|
|
|
278
|
|
|
279 funcmap := template.FuncMap{
|
|
|
280 "shorten": shorten,
|
|
|
281 "str2cp932": str2cp932,
|
|
|
282 "add1": func(a int) int { return a + 1 },
|
|
|
283 }
|
|
|
284
|
|
|
285 t, err := template.New("webpage").Funcs(funcmap).Parse(tpl)
|
|
|
286 if err != nil {
|
|
|
287 log.Fatal(err)
|
|
|
288 }
|
|
|
289
|
|
|
290 err = t.Execute(os.Stdout, irai)
|
|
|
291 if err != nil {
|
|
|
292 log.Fatal(err)
|
|
|
293 }
|
|
|
294 }
|
|
|
295
|
|
|
296 // Utility functions
|
|
|
297 func csv2sinsei(record []string) Sinsei {
|
|
|
298 return Sinsei{
|
|
|
299 Hhsno: strings.TrimSpace(record[0]),
|
|
|
300 Name: strings.TrimSpace(record[1]),
|
|
|
301 Biko: strings.TrimSpace(record[2]),
|
|
|
302 DrId: strings.TrimSpace(record[3]),
|
|
|
303 Dr: strings.TrimSpace(record[4]),
|
|
|
304 DrKana: strings.TrimSpace(record[5]),
|
|
|
305 Hp: strings.TrimSpace(record[6]),
|
|
|
306 IraiYmd: strings.TrimSpace(record[7]),
|
|
|
307 Ymd: strings.TrimSpace(record[8]),
|
|
|
308 Kubun: strings.TrimSpace(record[9]),
|
|
|
309 Senmon: strings.TrimSpace(record[10]),
|
|
|
310 }
|
|
|
311 }
|
|
|
312
|
|
|
313 func getdata_fromCSV(file, date string) (sinsei []Sinsei, hhshash map[string]bool, err error) {
|
|
|
314 hhshash = make(map[string]bool)
|
|
|
315
|
|
|
316 data, err := ioutil.ReadFile(file)
|
|
|
317 if err != nil {
|
|
|
318 return sinsei, hhshash, err
|
|
|
319 }
|
|
|
320
|
|
|
321 r := csv.NewReader(strings.NewReader(string(data)))
|
|
|
322 records, err := r.ReadAll()
|
|
|
323 if err != nil {
|
|
|
324 return sinsei, hhshash, err
|
|
|
325 }
|
|
|
326
|
|
|
327 for _, record := range records {
|
|
|
328 ss := csv2sinsei(record)
|
|
42
|
329 if ss.IraiYmd == date {
|
|
|
330 hhshash[ss.Hhsno] = true
|
|
41
|
331 }
|
|
42
|
332 }
|
|
|
333
|
|
|
334 for _, record := range records {
|
|
|
335 ss := csv2sinsei(record)
|
|
|
336 if _, ok := hhshash[ss.Hhsno]; ok {
|
|
|
337 sinsei = append(sinsei, ss)
|
|
|
338 }
|
|
41
|
339 }
|
|
|
340
|
|
|
341 return sinsei, hhshash, nil
|
|
|
342 }
|
|
|
343
|
|
|
344 func getdata_fromDB(file string, hhshash map[string]bool) (sinsei []Sinsei, err error) {
|
|
|
345 f, err := os.Open(file)
|
|
|
346 if err != nil {
|
|
|
347 return sinsei, err
|
|
|
348 }
|
|
|
349 defer f.Close()
|
|
|
350
|
|
|
351 zr, err := gzip.NewReader(f)
|
|
|
352 if err != nil {
|
|
|
353 return sinsei, err
|
|
|
354 }
|
|
|
355
|
|
|
356 data, err := ioutil.ReadAll(zr)
|
|
|
357 if err != nil {
|
|
|
358 return sinsei, err
|
|
|
359 }
|
|
|
360
|
|
|
361 if err := zr.Close(); err != nil {
|
|
|
362 return sinsei, err
|
|
|
363 }
|
|
|
364
|
|
|
365 r := csv.NewReader(strings.NewReader(string(data)))
|
|
|
366 records, err := r.ReadAll()
|
|
|
367 if err != nil {
|
|
|
368 return sinsei, err
|
|
|
369 }
|
|
|
370
|
|
|
371 for _, record := range records {
|
|
|
372 hno := strings.TrimSpace(record[0])
|
|
|
373 if _, ok := hhshash[hno]; ok {
|
|
|
374 sinsei = append(sinsei, csv2sinsei(record))
|
|
|
375 }
|
|
|
376 }
|
|
|
377
|
|
|
378 return sinsei, nil
|
|
|
379 }
|
|
|
380
|
|
|
381 func shorten(msg string, length int) string {
|
|
|
382 if len(msg) > length {
|
|
|
383 msg = msg[0:length] + "..."
|
|
|
384 }
|
|
|
385 return msg
|
|
|
386 }
|
|
|
387
|
|
|
388 func str2cp932(s string) string {
|
|
|
389 s, _, _ = transform.String(japanese.ShiftJIS.NewEncoder(), s)
|
|
|
390 return s
|
|
|
391 }
|
|
|
392
|
|
|
393 func print_debug_log(msg string) {
|
|
|
394 if debug_log {
|
|
|
395 fmt.Fprintf(os.Stderr, "%s\n", msg)
|
|
|
396 }
|
|
|
397 }
|
|
|
398
|
