|
2
|
1 // Filename : marksheet.cpp
|
|
4
|
2 // Last Change: 11-Sep-2013.
|
|
2
|
3 //
|
|
|
4
|
|
|
5 #include "common.h"
|
|
|
6 #include "marksheet.h"
|
|
|
7
|
|
|
8 bool IsBlack( int r, int g, int b )
|
|
|
9 {
|
|
|
10 if ( r == 0 && g == 0 && b == 0 ) {
|
|
|
11 return true;
|
|
|
12 }
|
|
|
13 return false;
|
|
|
14 }
|
|
|
15
|
|
|
16 wxString GuessHhs( wxString& file )
|
|
|
17 {
|
|
|
18 wxString hhs;
|
|
|
19 wxImage img( file, wxBITMAP_TYPE_JPEG );
|
|
|
20 int sx = 1800; // start x
|
|
|
21 int sy = 315;; // start y
|
|
|
22 int bw = 60; // block width
|
|
|
23 int bh = 50; // block height
|
|
|
24 int area = bw * bh;
|
|
|
25 int black = 0;
|
|
|
26 int x, y;
|
|
|
27 unsigned char r, g, b;
|
|
|
28
|
|
|
29 int max_n;
|
|
|
30 float max;
|
|
|
31 float bk;
|
|
|
32 for ( int c=0; c<10; c++ ) {
|
|
|
33 max = 0.0;
|
|
|
34 max_n = -1;
|
|
|
35 for ( int n=0; n<10; n++ ) {
|
|
|
36
|
|
|
37 for ( x=sx+bw*c; x<sx+bw*(c+1); x++ ) {
|
|
|
38 for ( y=sy+bh*n; y<sy+bh*(n+1); y++ ) {
|
|
|
39 r = img.GetRed( x, y );
|
|
|
40 g = img.GetGreen( x, y );
|
|
|
41 b = img.GetBlue( x, y );
|
|
|
42 if( IsBlack( (int)r, (int)g, (int)b ) ) black++;
|
|
|
43 }
|
|
|
44 }
|
|
|
45
|
|
|
46 bk = (float)black / area;
|
|
|
47 if ( max < bk ) {
|
|
|
48 max = bk;
|
|
|
49 max_n = n;
|
|
|
50 }
|
|
|
51 //wxPuts(wxString::Format(wxT("%d %f"),n,bk));
|
|
|
52 black = 0;
|
|
|
53 }
|
|
|
54 hhs.Append( wxString::Format( wxT("%d"), max_n ) );
|
|
|
55 }
|
|
|
56
|
|
|
57 return hhs;
|
|
|
58 }
|
|
|
59
|
|
4
|
60 bool IsMarksheet( wxString& file, double zmin, double zmax, long lmin, long lmax )
|
|
2
|
61 {
|
|
|
62 wxImage img( file, wxBITMAP_TYPE_JPEG );
|
|
|
63 int black = 0;
|
|
|
64 int x = 2465;
|
|
|
65 int h = 3500;
|
|
|
66 unsigned char r, g, b;
|
|
|
67
|
|
|
68 for ( int y=0; y<h; y++ ) {
|
|
|
69 r = img.GetRed( x, y );
|
|
|
70 g = img.GetGreen( x, y );
|
|
|
71 b = img.GetBlue( x, y );
|
|
|
72 if( IsBlack( (int)r, (int)g, (int)b ) ) black++;
|
|
|
73 }
|
|
|
74 float z = (float)black / h;
|
|
|
75
|
|
|
76 wxFile f( file );
|
|
|
77 long l = f.Length();
|
|
|
78
|
|
4
|
79 //wxPuts(wxString::Format(wxT("z = %f, len = %d"),z,l));
|
|
2
|
80 if ( zmin < z && z < zmax
|
|
|
81 && lmin < l && l < lmax ) {
|
|
|
82 return true;
|
|
|
83 }
|
|
|
84 return false;
|
|
|
85 }
|
|
|
86
|
|
|
87
|
|
|
88 wxString GetHhsName( wxString& hhsno )
|
|
|
89 {
|
|
|
90 wxString name;
|
|
|
91
|
|
|
92 wxString gszFile = wxGetCwd() + wxFILE_SEP_PATH + wxT("db") + wxFILE_SEP_PATH + wxT("hhs.db");
|
|
|
93 wxSQLite3Database hhsdb;
|
|
|
94 hhsdb.Open( gszFile );
|
|
|
95
|
|
|
96 wxSQLite3Statement stmt = hhsdb.PrepareStatement("SELECT name FROM hhs_master WHERE hhsno = ?");
|
|
|
97 stmt.Bind( 1, hhsno );
|
|
|
98 wxSQLite3ResultSet q = stmt.ExecuteQuery();
|
|
|
99 if ( !q.IsNull(0) ) {
|
|
|
100 while ( q.NextRow() ) {
|
|
|
101 name = q.GetString(0);
|
|
|
102 }
|
|
|
103 }
|
|
|
104 stmt.Finalize();
|
|
|
105 hhsdb.Close();
|
|
|
106
|
|
|
107 return name;
|
|
|
108 }
|
|
|
109
|
|
|
110 int IsHhsno( wxString& hhsno, wxString& name )
|
|
|
111 {
|
|
|
112 wxRegEx reHhs(wxT("^0[1238][0-9]{8}$")); // 被保番チェック
|
|
|
113
|
|
|
114 if ( reHhs.Matches( hhsno) ) {
|
|
|
115 name = GetHhsName( hhsno );
|
|
|
116 if ( name.IsEmpty() ) { // DBにない
|
|
|
117 return 1;
|
|
|
118 }
|
|
|
119 return 2;
|
|
|
120 }
|
|
|
121 else {
|
|
|
122 return 0;
|
|
|
123 }
|
|
|
124 }
|
|
|
125
|
|
|
126 int GetMarksheetVersion( wxString file )
|
|
|
127 {
|
|
|
128 wxImage img( file, wxBITMAP_TYPE_JPEG );
|
|
|
129 int black = 0;
|
|
|
130 int x = 2465;
|
|
|
131 int h = 3500;
|
|
|
132 unsigned char r, g, b;
|
|
|
133
|
|
|
134 for ( int y=0; y<h; y++ ) {
|
|
|
135 r = img.GetRed( x, y );
|
|
|
136 g = img.GetGreen( x, y );
|
|
|
137 b = img.GetBlue( x, y );
|
|
|
138 if( IsBlack( (int)r, (int)g, (int)b ) ) black++;
|
|
|
139 }
|
|
|
140 float z = (float)black / h;
|
|
|
141
|
|
|
142 if ( z > 0.120 ) {
|
|
|
143 return 2; // 0.130 - 0.140
|
|
|
144 }
|
|
|
145 else {
|
|
|
146 return 1; // 0.099 - 0.110
|
|
|
147 }
|
|
|
148 }
|
|
|
149
|
