<?php require_once "Cloth.php"; //print_r($_POST); // Read POST data if (isset($_POST["id"]) && isset($_POST["comment"])) { $id = $_POST["id"]; $comment = $_POST["comment"]; // Create new Transaction and load it by ID $cloth = new Cloth(); $cloth->loadById($id); // Change status $cloth->comment = $comment; // Store to DB $cloth->saveTransactionData(); echo "successfully stored {$id} with new comment: {$comment}"; } else { echo "error no POST data"; }
public function loadById($transactionId) { //echo "tid= $transactionId"; // CONNECT /*require_once('dblogin.php'); $mysqli = new mysqli($db_server ,$db_user, $db_password, $db_name); //$mysqli = new mysqli($db_server,$db_user, $db_password, $db_name); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } // QUERY - Transaction $query = "SELECT * FROM Transactions WHERE Id=$transactionId"; //echo $query;*/ include 'dblogin.php'; $mysqli = new mysqli($db_server, $db_user, $db_password, $db_name); //$mysqli = new mysqli($db_server,$db_user, $db_password, $db_name); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } // QUERY - Transaction $query = "SELECT * FROM Transactions WHERE Id={$transactionId}"; $result = $mysqli->query($query) or die($mysqli->error . __LINE__); //$result = $mysqli->query($query) or die($mysqli->error.__LINE__); //echo "5 <br />"; // GOING THROUGH THE DATA if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $this->id = $transactionId; $this->status = $row['Status']; $this->StatusDate = $row['StatusDate']; $this->OrderDate = $row['OrderDate']; $this->ReceptionDate = $row['ReceptionDate']; $this->ProcessedDate = $row['ProcessedDate']; $this->PaymentDate = $row['PaymentDate']; $this->FinishedDate = $row['FinishedDate']; $this->fname = $row['FirstName']; $this->lname = $row['LastName']; $this->email = $row['Email']; $this->street = $row['street']; $this->streetNr = $row['streetNr']; $this->plz = $row['plz']; $this->city = $row['city']; $this->payment = $row['Payment']; $this->PaypalMail = $row['PaypalMail']; $this->BankNr = $row['BankNr']; $this->AccountNr = $row['AccountNr']; $this->finalToPay = $row['FinalToPay']; $this->RejectOption = $row['RejectOption']; $this->language = $row['language']; break; } } else { return $this->loadResult = "error"; } // QUERY - Related Clothes $query = "SELECT Id FROM Transactions_Clothes WHERE fk_Transactions={$transactionId}"; $result = $mysqli->query($query) or die($mysqli->error . __LINE__); // GOING THROUGH THE DATA if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $cloth = new Cloth(); $cloth->loadById($row['Id']); $this->clothes[] = $cloth; } } else { //echo "No Clothes exist for this Transaction: $transactionId ! <br />"; } // SET TRANSACTION STATUS NUMBER $stateNumber; switch (strtolower($this->status)) { case "confirmed": $stateNumber = 1; break; case "received": $stateNumber = 2; break; case "processed": $stateNumber = 3; break; case "waiting for customer": $stateNumber = 3; break; case "donate": $stateNumber = 3; break; case "return": $stateNumber = 3; break; case "waiting for payment": $stateNumber = 4; break; case "payment": $stateNumber = 3; break; case "canceled": $stateNumber = 5; break; case "finished": $stateNumber = 5; break; default: $stateNumber = 0; } $this->statusNumber = $stateNumber; $this->acceptedItems = $this->countAcceptedItems(); $this->rejectedItems = $this->countRejectedItems(); $this->missingItems = $this->countMissingItems(); $this->accountNrMasked = $this->getAccountNr(); $this->sumAccepted = $this->getSumAccepted(); }