コード例 #1
0
<?php

require_once "Cloth.php";
print_r($_POST);
// Read POST data
if (isset($_POST["id"]) && isset($_POST["accepted"])) {
    $id = $_POST["id"];
    $accepted = $_POST["accepted"];
    // Create new Transaction and load it by ID
    $cloth = new Cloth();
    $cloth->loadById($id);
    // Change status
    $cloth->accepted = $accepted;
    // Store to DB
    $cloth->save();
    echo "successfully stored {$id} with new accepted: {$accepted}";
} else {
    echo "error no POST data";
}
コード例 #2
0
<?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";
}
コード例 #3
0
ファイル: Transaction.php プロジェクト: JiaoMing/Kleiderkuh
 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();
 }