| TXLCode |
OL1 |
OL2 |
OW1 |
OW2 |
R11 |
R12 |
R13 |
R21 |
R22 |
R23 |
R31 |
R32 |
R33 |
R41 |
R42 |
R43 |
LW |
CW |
MessDate |
RauDate |
InfoMessComm |
InfoRauComm |
Lieferbox |
query($sql3040);
$result3030 = $db->query($sql3030);
$result2121 = $db->query($sql2121);
$result2121C = $db->query($sql2121C);
$results3040 = array();
$results3030 = array();
$results2121 = array();
$results2121C = array();
$row3040Cnt = 0;
$row3030Cnt = 0;
$row2121Cnt = 0;
$row2121CCnt = 0;
if ($result3040->num_rows > 0) {
while($row = $result3040->fetch_row()) {
$results3040[$row3040Cnt] = $row;
$row3040Cnt++;
}
} else {
echo mysqli_error($db);
$db->close();
//echo '{ "nu":"ll" }';
return;
}
if ( $result3030->num_rows > 0) {
while($row = $result3030->fetch_row()) {
$results3030[$row3030Cnt] = $row; $row3030Cnt++;
}
} else {
echo mysqli_error($db); $db->close(); return;
}
if ( $result2121->num_rows > 0) {
while($row = $result2121->fetch_row()) {
$results2121[$row2121Cnt] = $row;
$row2121Cnt++;
}
} else {
echo mysqli_error($db); $db->close(); return;
}
if ( $result2121C->num_rows > 0) {
while($row = $result2121C->fetch_row()) {
$results2121C[$row2121CCnt] = $row;
$row2121CCnt++;
}
} else {
echo mysqli_error($db); $db->close(); return;
}
$db->close();
//echo json_encode($results);
foreach($results3040 as $result) {
$txlcode = $result[0];
$OL1 = $result[1];
$OL2 = $result[2];
$OW1 = $result[3];
$OW2 = $result[4];
$R11 = $result[5];
$R12 = $result[6];
$R13 = $result[7];
$R21 = $result[8];
$R22 = $result[9];
$R23 = $result[10];
$R31 = $result[11];
$R32 = $result[12];
$R33 = $result[13];
$R41 = $result[14];
$R42 = $result[15];
$R43 = $result[16];
$LW = $result[17];
$CW = $result[18];
$MessComm = $result[19];
$RauComm = $result[20];
$InfoMessComm = $result[21];
$InfoRauComm = $result[22];
$Lieferbox = $result[23];
echo "
| $txlcode |
$OL1 |
$OL2 |
$OW1 |
$OW2 |
$R11 |
$R12 |
$R13 |
$R21 |
$R22 |
$R23 |
$R31 |
$R32 |
$R33 |
$R41 |
$R42 |
$R43 |
$LW |
$CW |
$MessComm |
$RauComm |
$InfoMessComm |
$InfoRauComm |
$Lieferbox |
";
}
foreach($results3030 as $result) {
$txlcode = $result[0];
$OL1 = $result[1]; $OL2 = $result[2];
$OW1 = $result[3]; $OW2 = $result[4];
$R11 = $result[5]; $R12 = $result[6]; $R13 = $result[7];
$R21 = $result[8]; $R22 = $result[9]; $R23 = $result[10];
$R31 = $result[11]; $R32 = $result[12]; $R33 = $result[13];
$R41 = $result[14]; $R42 = $result[15]; $R43 = $result[16];
$LW = $result[17]; $CW = $result[18];
$MessComm = $result[19]; $RauComm = $result[20];
$InfoMessComm = $result[21]; $InfoRauComm = $result[22];
$Lieferbox = $result[23];
echo "
| $txlcode |
$OL1 |
$OL2 |
$OW1 |
$OW2 |
$R11 |
$R12 |
$R13 |
$R21 |
$R22 |
$R23 |
$R31 |
$R32 |
$R33 |
$R41 |
$R42 |
$R43 |
$LW |
$CW |
$MessComm |
$RauComm |
$InfoMessComm |
$InfoRauComm |
$Lieferbox |
";
}
foreach($results2121 as $result) {
$txlcode = $result[0];
$OL1 = $result[1]; $OL2 = "0";
$OW1 = $result[2]; $OW2 = "0";
$R11 = $result[3]; $R12 = $result[4]; $R13 = "0";
$R21 = $result[5]; $R22 = $result[6]; $R23 = "0";
$R31 = $result[7]; $R32 = $result[8]; $R33 = "0";
$R41 = $result[9]; $R42 = $result[10]; $R43 = "0";
$LW = $result[11]; $CW = $result[12];
$MessComm = $result[13]; $RauComm = $result[14];
$InfoMessComm = $result[15]; $InfoRauComm = $result[16];
$Lieferbox = $result[17];
echo "
| $txlcode |
$OL1 |
$OL2 |
$OW1 |
$OW2 |
$R11 |
$R12 |
$R13 |
$R21 |
$R22 |
$R23 |
$R31 |
$R32 |
$R33 |
$R41 |
$R42 |
$R43 |
$LW |
$CW |
$MessComm |
$RauComm |
$InfoMessComm |
$InfoRauComm |
$Lieferbox |
";
}
foreach($results2121C as $result) {
$txlcode = $result[0];
$OL1 = $result[1]; $OL2 = "0";
$OW1 = $result[2]; $OW2 = "0";
$R11 = $result[3]; $R12 = $result[4]; $R13 = "0";
$R21 = $result[5]; $R22 = $result[6]; $R23 = "0";
$R31 = $result[7]; $R32 = $result[8]; $R33 = "0";
$R41 = $result[9]; $R42 = $result[10]; $R43 = "0";
$LW = $result[11]; $CW = $result[12];
$MessComm = $result[13]; $RauComm = $result[14];
$InfoMessComm = $result[15]; $InfoRauComm = $result[16];
$Lieferbox = $result[17];
echo "
| $txlcode |
$OL1 |
$OL2 |
$OW1 |
$OW2 |
$R11 |
$R12 |
$R13 |
$R21 |
$R22 |
$R23 |
$R31 |
$R32 |
$R33 |
$R41 |
$R42 |
$R43 |
$LW |
$CW |
$MessComm |
$RauComm |
$InfoMessComm |
$InfoRauComm |
$Lieferbox |
";
}
function getNewDateTimeString($type, $str){
$messDateTimeArr = array();
if ($type == 1) {
// Z:KundenTrixellProjekte3040MessdatenMessdaten nach dem Schneidenimportedold2newTrixell3040_Messwerteerfassung_ab20131104.xls importiert am 08.04.2014 09:39:44
// Z:KundenTrixellProjekte3040MessdatenMessdaten nach dem Schneidenimportedold2newTrixell3040_Messwerteerfassung_bis20130516.xls importiert am 08.04.2014 09:40:38
$messDateTimeArr = explode(" am ", $str);
$messDateTimeArr = explode(" ", $messDateTimeArr[1]);
}
if ($type == 2) {
// Vorabeintrag Messmaske3040 27.05.2014 08:45:47
$messDateTimeArr = explode("3040 ", $str);
$messDateTimeArr = explode(" ", $messDateTimeArr[1]);
}
if ($type == 2.1) {
// Vorabeintrag Messmaske3040 27.05.2014 08:45:47
$messDateTimeArr = explode("2121 ", $str);
$messDateTimeArr = explode(" ", $messDateTimeArr[1]);
}
if ($type == 2.2) {
// Vorabeintrag Messmaske3040 27.05.2014 08:45:47
$messDateTimeArr = explode("2121C ", $str);
$messDateTimeArr = explode(" ", $messDateTimeArr[1]);
}
if ($type == 3) {
// TME2: 21.01.2016 06:47:10
$messDateTimeArr = explode("2: ", $str);
$messDateTimeArr = explode(" ", $messDateTimeArr[1]);
}
if ($type == 4) {
// Z:\Kunden\Trixell\Projekte\3040\Messdaten\Messdaten nach dem Schneiden\Trixell3040_Messwerteerfassung_ab20140211_2.xls importiert am 05.06.2014 14:14:20 / Hand-Import am 05.06.2014 OBK
$messDateTimeArr = explode(" am ", $str);
$messDateTimeArr = explode(" / ", $messDateTimeArr[1]);
$messDateTimeArr = explode(" ", $messDateTimeArr[0]);
}
if ($type == 5) {
return "1979-04-18 20:16:00";
}
$messDate = $messDateTimeArr[0];
$messTime = $messDateTimeArr[1];
$messDateArr = explode(".", $messDate);
$messDate = $messDateArr[2] ."-". $messDateArr[1] ."-". $messDateArr[0];
return $messDate ." ". $messTime;
}
?>