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