public function save() { $databaseHelper = new DatabaseHelper(); if ((int) $this->id > 0) { $query = "UPDATE\n `receipt`\n SET \n `employee` = '" . $this->employee . "',\n `priceInVat` = '" . $this->priceInVat . "',\n `priceExVat` = '" . $this->priceExVat . "'\n WHERE\n `receipt`.`id` =" . (int) $this->id . ";"; $databaseHelper->query($query); } else { $query = "INSERT INTO\n `receipt` (\n `employee`,\n `timestamp`,\n `priceInVat`,\n `priceExVat`\n ) VALUES (\n '" . $this->employee . "', \n CURRENT_TIMESTAMP,\n '" . $this->priceInVat . "',\n '" . $this->priceExVat . "'\n );"; $databaseHelper->query($query); $this->id = $databaseHelper->returnLastInsertId(); } return $this->id; }
public function save() { $databaseHelper = new DatabaseHelper(); if ($this->getId() > 0) { $query = "\n UPDATE \n `receipt_product`\n SET\n `productId` = '" . $this->getProductId() . "',\n `receiptId` = '" . $this->getReceiptId() . "',\n `label` = '" . $this->getLabel() . "',\n `priceInVat` = '" . $this->getPriceInVat() . "',\n `priceExVat` = '" . $this->getPriceExVat() . "',\n `amount` = '" . $this->getAmount() . "',\n `totalPriceInVat` = '" . $this->getTotalPriceInVat() . "',\n `totalPriceExVat` = '" . $this->getTotalPriceExVat() . "' \n WHERE \n `receipt_product`.`id` =" . $this->getId() . ";\n "; } else { $query = "\n INSERT INTO \n `receipt_product` (\n `productId` ,\n `receiptId` ,\n `label` ,\n `priceInVat` ,\n `priceExVat` ,\n `amount` ,\n `totalPriceInVat` ,\n `totalPriceExVat`\n ) VALUES (\n '" . $this->getProductId() . "',\n '" . $this->getReceiptId() . "',\n '" . $this->getLabel() . "',\n '" . $this->getPriceInVat() . "',\n '" . $this->getPriceExVat() . "',\n '" . $this->getAmount() . "',\n '" . $this->getTotalPriceInVat() . "',\n '" . $this->getTotalPriceExVat() . "'\n ); \n "; } $databaseHelper->query($query); $this->id = $databaseHelper->returnLastInsertId(); return $this->id; }