/
import_work.php
296 lines (282 loc) · 14.9 KB
/
import_work.php
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
245
246
247
248
249
250
251
252
253
254
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
284
285
286
287
288
289
290
291
292
293
294
295
296
<?php
require_once 'function.php';
require_once 'process_all.php';
require_once 'class/Database.class.php';
$paramsWork = array(
'server' => 'localhost',
'username' => 'root',
'password' => '',
'database' => 'management',
'table' => 'work',
);
$paramsUser = array(
'server' => 'localhost',
'username' => 'root',
'password' => '',
'database' => 'management',
'table' => 'user',
);
$paramsProject = array(
'server' => 'localhost',
'username' => 'root',
'password' => '',
'database' => 'management',
'table' => 'project_type',
);
$databaseWork = new Database($paramsWork);
$databaseUser = new Database($paramsUser);
$databaseProject = new Database($paramsProject);
$queryUser = 'SELECT * FROM user';
$queryProject = 'SELECT * FROM project_type';
$arrayUser = $databaseUser->listRecord($databaseUser->query($queryUser));
$arrayProject = $databaseProject->listRecord($databaseProject->query($queryProject));
//Import Maintenance Data
if(!empty($arrayMaintenance)) {
foreach($arrayMaintenance['Maintenance'] as $key => $value) {
if(empty($arrayMaintenance['Maintenance'][$key])) {
unset($arrayMaintenance['Maintenance'][$key]);
} else {
$arrayMaintenance['Maintenance'][$key] = array_change_key_case($arrayMaintenance['Maintenance'][$key], CASE_LOWER);
foreach($arrayUser as $k => $v) {
if($arrayMaintenance['Maintenance'][$key]['user'] == $arrayUser[$k]['nickname']) {
$arrayMaintenance['Maintenance'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach($arrayProject as $e => $q) {
if($arrayMaintenance['Maintenance'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayMaintenance['Maintenance'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//echo $databaseWork->checkExistRow($arrayMaintenance['Maintenance'][$key]) . '<br />';
$arrayToSelect['project_no'] = $arrayMaintenance['Maintenance'][$key]['project_no'];
$arrayToSelect['project_type'] = $arrayMaintenance['Maintenance'][$key]['project_type'];
$arrayToSelect['project_name'] = $arrayMaintenance['Maintenance'][$key]['project_name'];
$arrayToSelect['work_date'] = $arrayMaintenance['Maintenance'][$key]['work_date'];
//$arrayToSelect['user'] = $arrayMaintenance['Maintenance'][$key]['user'];
if($databaseWork->checkExistRow($arrayToSelect) == 1) {
$arrayIdMaintenance = $databaseWork->returnID($arrayToSelect);
if(!empty($arrayIdMaintenance)) {
$databaseWork->update($arrayMaintenance['Maintenance'][$key], array(array('id', $arrayIdMaintenance[0]['id'], null)));
}
} else {
$databaseWork->insert($arrayMaintenance['Maintenance'][$key]);
}
}
}
}
//Import Newton Data
if(!empty($arrayNewton)) {
foreach($arrayNewton['Newton'] as $key => $value) {
if(empty($arrayNewton['Newton'][$key])) {
unset($arrayNewton['Newton'][$key]);
} else {
$arrayNewton['Newton'][$key] = array_change_key_case($arrayNewton['Newton'][$key], CASE_LOWER);
foreach($arrayUser as $k => $v) {
if($arrayNewton['Newton'][$key]['user'] == $arrayUser[$k]['nickname']) {
$arrayNewton['Newton'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach($arrayProject as $e => $q) {
if($arrayNewton['Newton'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayNewton['Newton'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//$databaseWork->insert($arrayNewton['Newton'][$key]);
$arrayNewtonToSelect['project_no'] = $arrayNewton['Newton'][$key]['project_no'];
$arrayNewtonToSelect['project_type'] = $arrayNewton['Newton'][$key]['project_type'];
$arrayNewtonToSelect['project_name'] = $arrayNewton['Newton'][$key]['project_name'];
$arrayNewtonToSelect['work_date'] = $arrayNewton['Newton'][$key]['work_date'];
//$arrayNewtonToSelect['user'] = $arrayNewton['Newton'][$key]['user'];
$arrayNewtonToSelect['type'] = $arrayNewton['Newton'][$key]['type'];
if($databaseWork->checkExistRow($arrayNewtonToSelect) == 1) {
$arrayIdNewton = $databaseWork->returnID($arrayNewtonToSelect);
if(!empty($arrayIdNewton)) {
$databaseWork->update($arrayNewton['Newton'][$key], array(array('id', $arrayIdNewton[0]['id'], null)));
}
} else {
$databaseWork->insert($arrayNewton['Newton'][$key]);
}
}
}
}
//Import Domestic Data
if(!empty($arrayDomestic)) {
foreach($arrayDomestic['Domestic'] as $key => $value) {
if(empty($arrayDomestic['Domestic'][$key])) {
unset($arrayDomestic['Domestic'][$key]);
} else {
$arrayDomestic['Domestic'][$key] = array_change_key_case($arrayDomestic['Domestic'][$key], CASE_LOWER);
foreach($arrayUser as $k => $v) {
if($arrayDomestic['Domestic'][$key]['user'] == $arrayUser[$k]['nickname']) {
$arrayDomestic['Domestic'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach($arrayProject as $e => $q) {
if($arrayDomestic['Domestic'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayDomestic['Domestic'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//$databaseWork->insert($arrayDomestic['Domestic'][$key]);
$arrayDomesticToSelect['project_name'] = $arrayDomestic['Domestic'][$key]['project_name'];
$arrayDomesticToSelect['project_type'] = $arrayDomestic['Domestic'][$key]['project_type'];
$arrayDomesticToSelect['user'] = $arrayDomestic['Domestic'][$key]['user'];
$arrayDomesticToSelect['work_date'] = $arrayDomestic['Domestic'][$key]['work_date'];
$arrayDomesticToSelect['work_content'] = $arrayDomestic['Domestic'][$key]['work_content'];
$arrayDomesticToSelect['type'] = $arrayDomestic['Domestic'][$key]['type'];
$arrayDomesticToSelect['status'] = $arrayDomestic['Domestic'][$key]['status'];
$arrayDomesticToSelect['start'] = $arrayDomestic['Domestic'][$key]['start'];
$arrayDomesticToSelect['end'] = $arrayDomestic['Domestic'][$key]['end'];
if($databaseWork->checkExistRow($arrayDomesticToSelect) == 1) {
$arrayIdDomestic = $databaseWork->returnID($arrayDomesticToSelect);
if(!empty($arrayIdDomestic)) {
$databaseWork->update($arrayDomestic['Domestic'][$key], array(array('id', $arrayIdDomestic[0]['id'], null)));
}
} else {
$databaseWork->insert($arrayDomestic['Domestic'][$key]);
}
}
}
}
//Import FC Data
if(!empty($arrayFc)) {
foreach($arrayFc['FC'] as $key => $value) {
if(empty($arrayFc['FC'][$key])) {
unset($arrayFc['FC'][$key]);
} else {
$arrayFc['FC'][$key] = array_change_key_case($arrayFc['FC'][$key], CASE_LOWER);
foreach($arrayUser as $k => $v) {
if($arrayFc['FC'][$key]['user'] == $arrayUser[$k]['nickname']) {
$arrayFc['FC'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach($arrayProject as $e => $q) {
if($arrayFc['FC'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayFc['FC'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//$databaseWork->insert($arrayFc['FC'][$key]);
$arrayFcToSelect['project_no'] = $arrayFc['FC'][$key]['project_no'];
$arrayFcToSelect['project_type'] = $arrayFc['FC'][$key]['project_type'];
//$arrayFcToSelect['project_name'] = $arrayFc['FC'][$key]['project_name'];
$arrayFcToSelect['work_date'] = $arrayFc['FC'][$key]['work_date'];
$arrayFcToSelect['user'] = $arrayFc['FC'][$key]['user'];
$arrayFcToSelect['type'] = $arrayFc['FC'][$key]['type'];
$arrayFcToSelect['page_name'] = $arrayFc['FC'][$key]['page_name'];
if($databaseWork->checkExistRow($arrayFcToSelect) == true) {
$arrayIdFC = $databaseWork->returnID($arrayFcToSelect);
if(!empty($arrayIdFC)) {
$databaseWork->update($arrayFc['FC'][$key], array(array('id', $arrayIdFC[0]['id'], null)));
}
} else {
$databaseWork->insert($arrayFc['FC'][$key]);
}
}
}
}
// Other Data
if(!empty($arrayOther)) {
foreach($arrayOther['Other'] as $key => $value) {
if(empty($arrayOther['Other'][$key])) {
unset($arrayOther['Other'][$key]);
} else {
$arrayOther['Other'][$key] = array_change_key_case($arrayOther['Other'][$key], CASE_LOWER);
foreach($arrayUser as $k => $v) {
if($arrayOther['Other'][$key]['user'] == $arrayUser[$k]['nickname']) {
$arrayOther['Other'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach($arrayProject as $e => $q) {
if($arrayOther['Other'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayOther['Other'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//$databaseWork->insert($arrayOther['Other'][$key]);
$arrayOtherToSelect['project_name'] = $arrayOther['Other'][$key]['project_name'];
$arrayOtherToSelect['project_type'] = $arrayOther['Other'][$key]['project_type'];
$arrayOtherToSelect['user'] = $arrayOther['Other'][$key]['user'];
$arrayOtherToSelect['work_date'] = $arrayOther['Other'][$key]['work_date'];
if($databaseWork->checkExistRow($arrayOtherToSelect) == true) {
$arrayIdOther = $databaseWork->returnID($arrayOtherToSelect);
if(!empty($arrayIdOther)) {
$databaseWork->update($arrayOther['Other'][$key], array(array('id', $arrayIdOther[0]['id'], null)));
}
} else {
$databaseWork->insert($arrayOther['Other'][$key]);
}
}
}
}
// Research Data
if(!empty($arrayResearch)) {
foreach($arrayResearch['Research'] as $key => $value) {
if(empty($arrayResearch['Research'][$key])) {
unset($arrayResearch['Research'][$key]);
} else {
$arrayResearch['Research'][$key] = array_change_key_case($arrayResearch['Research'][$key], CASE_LOWER);
foreach($arrayUser as $k => $v) {
if($arrayResearch['Research'][$key]['user'] == $arrayUser[$k]['nickname']) {
$arrayResearch['Research'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach($arrayProject as $e => $q) {
if($arrayResearch['Research'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayResearch['Research'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//$databaseWork->insert($arrayResearch['Research'][$key]);
$arrayResearchToSelect['project_type'] = $arrayResearch['Research'][$key]['project_type'];
$arrayResearchToSelect['project_name'] = $arrayResearch['Research'][$key]['project_name'];
$arrayResearchToSelect['user'] = $arrayResearch['Research'][$key]['user'];
$arrayResearchToSelect['work_date'] = $arrayResearch['Research'][$key]['work_date'];
if($databaseWork->checkExistRow($arrayResearchToSelect) == true) {
/* $arrayIdResearch = $databaseWork->returnID($arrayResearch['Research'][$key]);
foreach($arrayIdResearch as $key => $value) {
$arrayResearchWhere[] = array('id',$value['id'], null);
}
@$databaseWork->update($arrayResearch['Research'][$key], $arrayResearchWhere); */
$arrayIdResearch = $databaseWork->returnID($arrayResearchToSelect);
if(!empty($arrayIdResearch)) {
$databaseWork->update($arrayResearch['Research'][$key], array(array('id', $arrayIdResearch[0]['id'], null)));
}
} else {
$databaseWork->insert($arrayResearch['Research'][$key]);
}
}
}
}
// New Coding
if(!empty($arrayNewCoding)) {
foreach($arrayNewCoding['NewCoding'] as $key => $value) {
if(empty($arrayNewCoding['NewCoding'][$key])) {
unset($arrayNewCoding['NewCoding'][$key]);
} else {
$arrayNewCoding['NewCoding'][$key] = array_change_key_case($arrayNewCoding['NewCoding'][$key], CASE_LOWER);
foreach($arrayUser as $k => $v) {
if($arrayNewCoding['NewCoding'][$key]['user'] == $arrayUser[$k]['nickname']) {
$arrayNewCoding['NewCoding'][$key]['user'] = $arrayUser[$k]['id'];
}
}
foreach($arrayProject as $e => $q) {
if($arrayNewCoding['NewCoding'][$key]['project_type'] == $arrayProject[$e]['project_type']) {
$arrayNewCoding['NewCoding'][$key]['project_type'] = $arrayProject[$e]['id'];
}
}
//$databaseWork->insert($arrayNewCoding['New Coding'][$key]);
$arrayNewCodingToSelect['project_no'] = $arrayNewCoding['NewCoding'][$key]['project_no'];
$arrayNewCodingToSelect['project_name'] = $arrayNewCoding['NewCoding'][$key]['project_name'];
$arrayNewCodingToSelect['project_type'] = $arrayNewCoding['NewCoding'][$key]['project_type'];
$arrayNewCodingToSelect['work_date'] = $arrayNewCoding['NewCoding'][$key]['work_date'];
$arrayNewCodingToSelect['user'] = $arrayNewCoding['NewCoding'][$key]['user'];
$arrayNewCodingToSelect['work_content'] = $arrayNewCoding['NewCoding'][$key]['work_content'];
//if($databaseWork->checkExistRow($arrayNewCoding['NewCoding'][$key]) == true) {
if($databaseWork->checkExistRow($arrayNewCodingToSelect) == true) {
$arrayIdCoding = $databaseWork->returnID($arrayNewCodingToSelect);
if(!empty($arrayIdCoding)) {
$databaseWork->update($arrayNewCoding['NewCoding'][$key], array(array('id', $arrayIdCoding[0]['id'], null)));
}
} else {
$databaseWork->insert($arrayNewCoding['NewCoding'][$key]);
}
}
}
}