1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
|
//*****************************************************
// Отображение на экране
void visible() {
fill(255);
rect(tablo[0], tablo[1], tablo[2], tablo[3] + 20);
for (TableRow row : table.rows()) {
if (count == select-1) {
index = row.getInt(2);
println(index);
}
fill(#F0FFFF);
if (select == count + 1) fill(#00FF00);
rect(tablo[0], tablo[1] + h * count, tablo[2], h);
rect(tablo[0] + tabloW[1], tablo[1] + h * count, tabloW[2] - tabloW[1], h);
rect(tablo[0] + tabloW[2], tablo[1] + h * count, tabloW[3] - tabloW[2], h);
rect(tablo[0] + tabloW[3], tablo[1] + h * count, tabloW[4] - tabloW[3], h);
rect(tablo[0] + tabloW[4], tablo[1] + h * count, tabloW[5] - tabloW[4], h);
rect(tablo[0] + tabloW[5], tablo[1] + h * count, tabloW[6] - tabloW[5], h);
rect(tablo[0] + tabloW[6], tablo[1] + h * count, tabloW[7] - tabloW[6], h);
rect(tablo[0] + tabloW[7], tablo[1] + h * count, tabloW[8] - tabloW[7], h);
rect(tablo[0] + tabloW[8], tablo[1] + h * count, tabloW[9] - tabloW[8], h);
rect(tablo[0] + tabloW[9], tablo[1] + h * count, tabloW[10] - tabloW[9], h);
rect(tablo[0] + tabloW[10], tablo[1] + h * count, tabloW[11] - tabloW[10], h);
rect(tablo[0] + tabloW[11], tablo[1] + h * count, tabloW[12] - tabloW[11], h);
rect(tablo[0] + tabloW[12], tablo[1] + h * count, tabloW[13] - tabloW[12], h);
rect(tablo[0] + tabloW[13], tablo[1] + h * count, tabloW[14] - tabloW[13], h);
rect(tablo[0] + tabloW[14], tablo[1] + h * count, tabloW[15] - tabloW[14], h);
rect(tablo[0] + tabloW[15], tablo[1] + h * count, tabloW[16] - tabloW[15], h);
rect(tablo[0] + tabloW[16], tablo[1] + h * count, tablo[2] - tabloW[16], h);
fill(0);
int hCode = row.getInt(0);
int hCode1 = row.getInt(9)*2 + row.getInt(10)*2 + row.getInt(12)*2 +
row.getInt(13)*2 + row.getInt(14)*2 + row.getInt(15)*2;
println(hCode + " - " + hCode1);
if (hCode != hCode1) fill(#FF0000);
textSize(11);
textAlign(RIGHT);
text(count + 1, tablo[1] + shift, tablo[1] + otH + h * (count));
text(row.getString(3), tabloW[2] - shift + tablo[0], tablo[1] + otH + h * (count));
text(row.getString(4), tabloW[3] - shift + tablo[0], tablo[1] + otH + h * (count));
text(printData(row.getString(6)), tabloW[4] - shift + tablo[0], tablo[1] + otH + h * (count));
text(row.getString(7), tabloW[5] - shift + tablo[0], tablo[1] + otH + h * (count));
text(printData(str(row.getInt(9))), tabloW[6] - shift + tablo[0], tablo[1] + otH + h * (count));
String q = (row.getInt(10) == 0) ? "" : row.getString(10);
text(q, tabloW[7] - shift + tablo[0], tablo[1] + otH + h * (count));
text(printData(row.getString(12)), tabloW[8] - shift + tablo[0], tablo[1] + otH + h * (count));
String w = (row.getInt(13) == 0) ? "" : row.getString(13);
text(w, tabloW[9] - shift + tablo[0], tablo[1] + otH + h * (count));
String e = (row.getInt(14) == 0) ? "" : row.getString(14);
text(printData(e), tabloW[10] - shift + tablo[0], tablo[1] + otH + h * (count));
String r = (row.getInt(15) == 0) ? "" : row.getString(15);
text(printData(r), tabloW[11] - shift + tablo[0], tablo[1] + otH + h * (count));
textAlign(LEFT);
String g;
if (row.getInt(17) != 0) {
g = "[" + row.getFloat(17) / 1000 + "] ";
} else {
g = "";
}
text(g + row.getString(5), tabloW[11] + shift + tablo[0], tablo[1] + otH + h * (count));
textAlign(RIGHT);
//int n1 = row.getInt(9) - row.getInt(10) - row.getInt(12) + row.getInt(13);
//text(printData(str(n1)), tabloW[13] - shift + tablo[0], tablo[1] + otH + h * (count));
//int n = row.getInt(9) - row.getInt(12) + row.getInt(17) / 2;
//text(printData(str(n)), tabloW[14] - shift + tablo[0], tablo[1] + otH + h * (count));
int chist = int(row.getInt(9) - row.getInt(12) - (row.getInt(9) - row.getInt(12)) / 100.0 *
row.getInt(7) - row.getInt(15) + row.getInt(17) / 2);
text(printData(str(int(chist))), tabloW[15] - shift + tablo[0], tablo[1] + otH + h * (count));
int sum = chist * row.getInt(6) / 1000;
text(printData(str(sum)), tabloW[16] - shift + tablo[0], tablo[1] + otH + h * (count));
text(row.getString(11), tabloW[17] - shift + tablo[0], tablo[1] + otH + h * (count));
int sum1 = chist * row.getInt(6) / 1000 - row.getInt(14);
text(printData(str(sum1)), tabloW[13] - shift + tablo[0], tablo[1] + otH + h * (count));
//sumN1 += n1;
//sumN += n;
sumChist += chist;
sumArenda += row.getInt(14);
sumDopSor += row.getInt(15);
sumSum += sum;
count++;
}
//String[] kamazy = loadStrings(filePath1 + "kamazy.txt");
//println("File 'kamazy.txt' found !");
//int sumKamazy = 0;
//int sumKamEach = 0;
//for (int k = 0; k < kamazy.length; ++k) {
// for (TableRow row : table.findRows(kamazy[k], "nomer")) {
// sumKamEach += row.getInt(9) - row.getInt(12) - int((row.getInt(9) -
// row.getInt(12)) / 100.0 * row.getInt(7)) - row.getInt(15) + row.getInt(17);
// }
// sumKamazy += sumKamEach;
// sumKamEach = 0;
//}
fill(#FFF0F5);
rect(tablo[0] + tabloW[0], tablo[1] - 30, tabloW[1] - tabloW[0], h + shift);
rect(tablo[0] + tabloW[1], tablo[1] - 30, tabloW[2] - tabloW[1], h + shift);
rect(tablo[0] + tabloW[2], tablo[1] - 30, tabloW[3] - tabloW[2], h + shift);
rect(tablo[0] + tabloW[3], tablo[1] - 30, tabloW[4] - tabloW[3], h + shift);
rect(tablo[0] + tabloW[4], tablo[1] - 30, tabloW[5] - tabloW[4], h + shift);
rect(tablo[0] + tabloW[5], tablo[1] - 30, tabloW[6] - tabloW[5], h + shift);
rect(tablo[0] + tabloW[6], tablo[1] - 30, tabloW[7] - tabloW[6], h + shift);
rect(tablo[0] + tabloW[7], tablo[1] - 30, tabloW[8] - tabloW[7], h + shift);
rect(tablo[0] + tabloW[8], tablo[1] - 30, tabloW[9] - tabloW[8], h + shift);
rect(tablo[0] + tabloW[9], tablo[1] - 30, tabloW[10] - tabloW[9], h + shift);
rect(tablo[0] + tabloW[10], tablo[1] - 30, tabloW[11] - tabloW[10], h + shift);
rect(tablo[0] + tabloW[11], tablo[1] - 30, tabloW[12] - tabloW[11], h + shift);
rect(tablo[0] + tabloW[12], tablo[1] - 30, tabloW[13] - tabloW[12], h + shift);
rect(tablo[0] + tabloW[13], tablo[1] - 30, tabloW[14] - tabloW[13], h + shift);
rect(tablo[0] + tabloW[14], tablo[1] - 30, tabloW[15] - tabloW[14], h + shift);
rect(tablo[0] + tabloW[15], tablo[1] - 30, tabloW[16] - tabloW[15], h + shift);
rect(tablo[0] + tabloW[16], tablo[1] - 30, tablo[2] - tabloW[16], h + shift);
textSize(14);
//rect(tablo[0] + tabloW[8], tablo[1] + h * count, tabloW[9] - tabloW[8], h * 2);
rect(tablo[0] + tabloW[9], tablo[1] + h * count, tabloW[10] - tabloW[9], h * 2);
rect(tablo[0] + tabloW[10], tablo[1] + h * count, tabloW[11] - tabloW[10], h * 2);
rect(tablo[0] + tabloW[11], tablo[1] + h * count, tabloW[12] - tabloW[11], h * 2);
rect(tablo[0] + tabloW[12], tablo[1] + h * count, tabloW[13] - tabloW[12], h * 2);
rect(tablo[0] + tabloW[13], tablo[1] + h * count, tabloW[14] - tabloW[13], h * 2);
rect(tablo[0] + tabloW[14], tablo[1] + h * count, tabloW[15] - tabloW[14], h * 2);
rect(tablo[0] + tabloW[15], tablo[1] + h * count, tabloW[16] - tabloW[15], h * 2);
rect(tablo[0] + tabloW[16], tablo[1] + h * count, tablo[2] - tabloW[16], h * 2);
fill(0);
rect(tabloW[17] - 30, tablo[1] + tablo[3] - 8, 30, 20);
fill(0);
textSize(14);
textAlign(LEFT);
text("№", tabloW[0] + tablo[0] + shift + 5, tablo[1] - otH);
text("Номер", tabloW[1] + tablo[0] + shift + 15, tablo[1] - otH);
text("Клиент", tabloW[2] + tablo[0] + shift + 30, tablo[1] - otH);
text("Цена", tabloW[3] + tablo[0] + shift + 5, tablo[1] - otH);
text("%", tabloW[4] + tablo[0] + shift + 5, tablo[1] - otH);
text("Вес 1", tabloW[5] + tablo[0] + shift + 5, tablo[1] - otH);
text("z21", tabloW[6] + tablo[0] + shift + 10, tablo[1] - otH);
text("Вес 2", tabloW[7] + tablo[0] + shift + 5, tablo[1] - otH);
text("z22", tabloW[8] + tablo[0] + shift + 10, tablo[1] - otH);
text("Камаз", tabloW[9] + tablo[0] + shift, tablo[1] - otH);
text("ДС", tabloW[10] + tablo[0] + shift + 8, tablo[1] - otH);
text("Объект", tabloW[11] + tablo[0] + shift + 60, tablo[1] - otH);
text("К выдаче", tabloW[12] + tablo[0] + shift, tablo[1] - otH);
//text("H1", tabloW[12] + tablo[0] + shift * 3, tablo[1] - otH);
//text("Н", tabloW[13] + tablo[0] + shift * 3, tablo[1] - otH);
text("Чистый", tabloW[14] + tablo[0] + shift + 5, tablo[1] - otH);
text("Сумма", tabloW[15] + tablo[0] + shift + 10, tablo[1] - otH);
text("Время 2", tabloW[16] + tablo[0] + shift + 5, tablo[1] - otH);
textAlign(RIGHT);
//text("" + workNumber(sumKamazy / 1000.0), tabloW[9] + shift - 5, tablo[1] + h * count + 25);
text("" + workNumber(sumArenda / 1000.0), tabloW[10] + shift - 5, tablo[1] + h * count + 25);
text("" + workNumber(sumDopSor / 1000.0), tabloW[11] + shift - 5, tablo[1] + h * count + 25);
textAlign(LEFT);
//float w = workNumber((sumN1 - sumChist) / float(sumN1) * 10000 / 100.0);
//float w1 = workNumber((sumN - sumChist - sumDopSor) / float(sumN) * 100);
//text(" " + w1 + " / " + workNumber((sumN1 - sumN) / 1000.0) + " / " + w, tabloW[11] +
//shift * 2, tablo[1] + h * count + 25);
textAlign(RIGHT);
//text("" + (sumN1) / 1000.0, tabloW[13] + shift - 5, tablo[1] + h * count + 25);
//text("" + (sumN) / 1000.0, tabloW[14] + shift - 5, tablo[1] + h * count + 25);
text("" + int(sumChist / 1000.0 * 100) / 100.0, tabloW[15] + shift - 5, tablo[1] + h * count + 25);
text("" + int(sumSum / 1000.0 * 100) / 100.0, tabloW[16] + shift - 5, tablo[1] + h * count + 25);
text("" + printData(str(int(float(sumSum) / sumChist * 1000))), tabloW[17] - 10, tablo[1] + h * count + 25);
if (select != 0) {
fill(#F0FFF0);
if (selectDataEdit == 1) fill(#1E90FF);
rect(tablo[0] + tabloW[1], s, tabloW[0] - tabloW[1], h + shift);
fill(#F0FFF0);
if (selectDataEdit == 4) fill(#1E90FF);
rect(tablo[0] + tabloW[2], s, tabloW[3] - tabloW[2], h + shift);
fill(#F0FFF0);
if (selectDataEdit == 6) fill(#1E90FF);
rect(tablo[0] + tabloW[3], s, tabloW[4] - tabloW[3], h + shift);
fill(#F0FFF0);
if (selectDataEdit == 7) fill(#1E90FF);
rect(tablo[0] + tabloW[4], s, tabloW[5] - tabloW[4], h + shift);
fill(#F0FFF0);
if (selectDataEdit == 14) fill(#1E90FF);
rect(tablo[0] + tabloW[9], s, tabloW[10] - tabloW[9], h + shift);
fill(#F0FFF0);
if (selectDataEdit == 15) fill(#1E90FF);
rect(tablo[0] + tabloW[10], s, tabloW[11] - tabloW[10], h + shift);
fill(#F0FFF0);
if (selectDataEdit == 5) fill(#1E90FF);
rect(tablo[0] + tabloW[11], s, tabloW[12] - tabloW[11], h + shift);
fill(#FF3030);
rect(tablo[0] + tabloW[13], s, tabloW[16] - tabloW[13], h + shift);
fill(#FF0000);
textSize(14);
TableRow row = table.getRow(index-1);
if (selectDataEdit == 4) {
text(inputData, tabloW[3] - shift + tablo[0], s + shift * 2);
} else {
text(row.getString(4), tabloW[3] - shift + tablo[0], s + shift * 2);
}
if (selectDataEdit == 6) {
text(inputData, tabloW[4] - shift + tablo[0], s + shift * 2);
} else {
text(row.getString(6), tabloW[4] - shift + tablo[0], s + shift * 2);
}
if (selectDataEdit == 7) {
text(inputData, tabloW[5] - shift + tablo[0], s + shift * 2);
} else {
text(row.getString(7), tabloW[5] - shift + tablo[0], s + shift * 2);
}
if (selectDataEdit == 14) {
text(inputData, tabloW[10] - shift + tablo[0], s + shift * 2);
} else {
text(row.getInt(14), tabloW[10] - shift + tablo[0], s + shift * 2);
}
if (selectDataEdit == 15) {
text(inputData, tabloW[11] - shift + tablo[0], s + shift * 2);
} else {
text(row.getInt(15), tabloW[11] - shift + tablo[0], s + shift * 2);
}
textAlign(LEFT);
if (selectDataEdit == 5) {
text(inputData, tabloW[11] + shift + tablo[0], s + shift * 2);
} else {
text(row.getString(5), tabloW[11] + shift + tablo[0], s + shift * 2);
}
fill(255);
text("ОТВЕС", tabloW[13] + shift * 9 + tablo[0], s + shift * 2);
}
millisOld = millis();
}
//*****************************************************
|
