function updatesave($pararray, $listarray, $menu, $show, $chkpreis, $menugrp)
{
echo "<a href='showtab.php?menu=" . $menu . "&menugrp=" . $menugrp . "' class='btn btn-primary btn-sm active' role='button'>Liste</a>";
$db = dbopen('../', '../data/mysqlitesync.db');
$sql = "UPDATE " . $pararray['dbtable'] . " SET ";
$strfld = "";
$strval = "";
foreach ($listarray as $arrelement) {
if ($arrelement['fieldsave'] != "NO") {
if ($strfld == "") {
$strfld = $arrelement['dbfield'];
$strval = "'" . $_POST[$arrelement['dbfield']] . "'";
} else {
if ($arrelement['type'] != "icon") {
$strfld = $strfld . "," . $arrelement['dbfield'];
$strval = $strval . ",'" . $_POST[$arrelement['dbfield']] . "'";
}
}
switch ($arrelement['type']) {
case 'text':
$sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', ";
break;
case 'JN':
$sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', ";
break;
case 'zahl':
$sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', ";
break;
case 'selectid':
$wert = $_POST[$arrelement['name']];
if ($wert == "(ohne)") {
$wert = 0;
}
$sql = $sql . $arrelement['dbfield'] . "='" . $wert . "', ";
break;
case 'select':
$sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['name']] . "', ";
break;
case 'time':
$sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', ";
break;
case 'date':
$sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', ";
break;
case 'calc':
$sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', ";
break;
case 'proz':
$sql = $sql . $arrelement['dbfield'] . "='" . $_POST[$arrelement['dbfield']] . "', ";
break;
case 'timestamp':
$sql = $sql . $arrelement['dbfield'] . "=CURRENT_TIMESTAMP, ";
break;
case 'prozref':
$sqlfil = "SELECT * FROM tblfilter WHERE fldtablename='tblorte' AND fldfeld='fldid_suchobj'";
echo $sqlfil . "<br>";
$resfil = $db->query($sqlfil);
if ($rowfil = $resfil->fetchArray()) {
if ($rowfil['fldwert'] != "(ohne)") {
$sqlsuch = "SELECT * FROM tblsuchobj WHERE fldbez='" . $rowfil['fldwert'] . "'";
$ressuch = $db->query($sqlsuch);
if ($rowsuch = $ressuch->fetchArray()) {
$refwhere = "fldid_suchobj=" . $rowsuch['fldindex'] . " AND fldid_orte=" . $_POST['id'];
$sqlref = "SELECT * FROM tblrefsuchobj WHERE " . $refwhere;
$resref = $db->query($sqlref);
if ($rowref = $resref->fetchArray()) {
$sqlupdref = "UPDATE tblrefsuchobj SET " . $arrelement['dbfield'] . "=" . $_POST[$arrelement['dbfield']] . ",fldtyp='" . $arrelement['reftyp'] . "',fldid_moebel=" . $_POST['moebel'] . ",fldid_zimmer=" . $_POST['zimmer'] . " AND fldid_etage=" . $_POST['etage'] . " WHERE " . $refwhere;
} else {
$sqlupdref = "INSERT INTO tblrefsuchobj (fldid_suchobj,fldid_orte," . $arrelement['dbfield'] . ",fldtyp) VALUES(" . $rowsuch['fldindex'] . "," . $_POST['id'] . ",'" . $_POST[$arrelement['dbfield']] . "','" . $arrelement['reftyp'] . "')";
}
echo "<div class='alert alert-success'>";
echo $sqlupdref . "=prozref";
echo "</div>";
//$reserr = $db->exec($sqlupdref);
}
}
}
break;
}
}
}
$sql = substr($sql, 0, -2);
$sql = $sql . " WHERE fldindex=" . $_POST['id'];
$query = $db->exec($sql);
if ($pararray['chkpreis'] == "J") {
if ($chkpreis == "preis") {
$rowid = $_POST['id'];
updatepreis($rowid, $show);
}
}
$dscopy = $_POST['dscopy'];
//echo $dscopy."=dscopy?<br>";
if ($dscopy == "dscopy") {
$qrycopy = "INSERT INTO " . $pararray['dbtable'] . " (" . $strfld . ") VALUES(" . $strval . ") ";
echo "<div class='alert alert-success'>";
echo $qrycopy . "<br>";
echo "</div>";
$query = $db->exec($qrycopy);
//mysql_query($qrycopy) or die("Error using mysql_query($qrycopy): ".mysql_error());
}
if ($show == "anzeigen") {
echo "<div class='alert alert-success'>";
echo $db->lastErrorMsg() . "<br>";
echo $sql . "<br>";
echo "</div>";
}
$fldbez = "fldbez";
if ($pararray['fldbez'] != "") {
$fldbez = $pararray['fldbez'];
}
echo "<div class='alert alert-success'>";
echo "Daten '" . $_POST[$fldbez] . "' aktualisiert.";
echo "</div>";
}
function insertsave($pararray, $listarray, $menu, $show, $autoinc_step, $autoinc_start, $menugrp)
{
echo "<a href='showtab.php?menu=" . $menu . "&menugrp=" . $menugrp . "' class='btn btn-primary btn-sm active' role='button'>Liste</a>";
$db = dbopen('../', '../data/mysqlitesync.db');
// echo $db->lastErrorMsg()."<br>";
//$sqlid = "select ".$pararray['fldindex']." from ".$pararray['dbtable']." order by ".$pararray['fldindex']." desc limit 1";
$sqlid = "SELECT * FROM tblindex WHERE fldtable='" . $pararray['dbtable'] . "'";
$results = $db->query($sqlid);
if ($row = $results->fetchArray()) {
$newrowid = $row['fldid'] + $autoinc_step;
//echo $newrowid."=newrowid<br>";
} else {
$newrowid = $autoinc_start;
}
$prozref = "N";
$dbtable = $pararray['dbtable'];
$sql = "INSERT INTO " . $dbtable . " (" . $pararray['fldindex'] . ",";
foreach ($listarray as $arrelement) {
if ($arrelement['fieldsave'] != "NO") {
switch ($arrelement['type']) {
case 'text':
$sql = $sql . $arrelement['dbfield'] . ",";
break;
case 'select':
$sql = $sql . $arrelement['dbfield'] . ",";
break;
case 'selectid':
$sql = $sql . $arrelement['dbfield'] . ",";
break;
case 'time':
$sql = $sql . $arrelement['dbfield'] . ",";
break;
case 'date':
$sql = $sql . $arrelement['dbfield'] . ",";
break;
case 'calc':
$sql = $sql . $arrelement['dbfield'] . ",";
break;
case 'timestamp':
$sql = $sql . $arrelement['dbfield'] . ",";
break;
}
}
}
$sql = substr($sql, 0, -1) . ") VALUES (" . $newrowid . ",";
foreach ($listarray as $arrelement) {
if ($arrelement['fieldsave'] != "NO") {
switch ($arrelement['type']) {
case 'text':
$sql = $sql . "'" . $_POST[$arrelement['dbfield']] . "',";
break;
case 'selectid':
$sql = $sql . "'" . $_POST[$arrelement['name']] . "',";
break;
case 'select':
$sql = $sql . "'" . $_POST[$arrelement['name']] . "',";
break;
case 'time':
$sql = $sql . "'" . $_POST[$arrelement['dbfield']] . "',";
break;
case 'date':
$sql = $sql . "'" . $_POST[$arrelement['dbfield']] . "',";
break;
case 'calc':
$sql = $sql . "'" . $_POST[$arrelement['dbfield']] . "',";
break;
case 'timestamp':
$sql = $sql . "CURRENT_TIMESTAMP,";
break;
case 'prozref':
$prozref = "J";
$dbfield = $arrelement['dbfield'];
break;
}
}
}
$sql = substr($sql, 0, -1) . ")";
//echo $sql."<br>";
$db->exec($sql);
$sqlid = "SELECT last_insert_rowid() as lastid FROM " . $pararray['dbtable'];
$results = $db->query($sqlid);
if ($row = $results->fetchArray()) {
$rowid = $row[0];
//echo $rowid."=rowid<br>";
}
if ($show == "anzeigen") {
echo "<div class='alert alert-success'>";
echo $sql . "<br>";
echo $db->lastErrorMsg() . "<br>";
echo "</div>";
}
if ($prozref == "J") {
$sqlfil = "SELECT * FROM tblfilter WHERE fldtablename='tblorte' AND fldfeld='fldid_suchobj'";
$resfil = $db->query($sqlfil);
if ($rowfil = $resfil->fetchArray()) {
if ($rowfil['fldwert'] != "(ohne)") {
$sqlsuch = "SELECT * FROM tblsuchobj WHERE fldbez='" . $rowfil['fldwert'] . "'";
$ressuch = $db->query($sqlsuch);
if ($rowsuch = $ressuch->fetchArray()) {
$refwhere = "fldid_suchobj=" . $rowsuch['fldindex'] . " AND fldid_orte=" . $rowid;
$sqlref = "SELECT * FROM tblrefsuchobj WHERE " . $refwhere;
$resref = $db->query($sqlref);
if ($rowref = $resref->fetchArray()) {
$sqlupdref = "UPDATE tblrefsuchobj SET " . $dbfield . "=" . $_POST[$dbfield] . " WHERE " . $refwhere;
} else {
$sqlupdref = "INSERT INTO tblrefsuchobj (fldid_suchobj,fldid_orte," . $dbfield . ") VALUES(" . $rowsuch['fldindex'] . "," . $rowid . ",'" . $_POST[$dbfield] . "')";
}
}
}
}
echo "<div class='alert alert-success'>";
echo $sqlupdref . "=prozref";
echo "</div>";
$reserr = $db->exec($sqlupdref);
}
if ($newrowid == $autoinc_start) {
$sqlupd = "INSERT INTO tblindex (fldtable,fldid) VALUES('" . $pararray['dbtable'] . "'," . $newrowid . ")";
} else {
$sqlupd = "UPDATE tblindex SET fldid=" . $newrowid . " WHERE fldtable='" . $pararray['dbtable'] . "'";
}
//echo $sqlupd."<br>";
$resupd = $db->exec($sqlupd);
$db->close();
//echo $pararray['chkpreis']."=chkpreis<br>";
if ($pararray['chkpreis'] == "J") {
updatepreis($rowid);
}
echo "<div class='alert alert-success'>";
echo "Daten '" . $_POST['fldBez'] . "' mit rowid=" . $rowid . " eingefügt.";
echo "</div>";
}
