From 4f84eb2b09bf51eabdc29b5eeec101e0260b1cb7 Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Thu, 28 Jul 2016 09:37:48 +0200
Subject: Braintree integration: first version

---
 install/index.php   |  6 +++++-
 install/upgrade.php | 18 +++++++++++++++---
 2 files changed, 20 insertions(+), 4 deletions(-)

(limited to 'install')

diff --git a/install/index.php b/install/index.php
index dbea375..d40959f 100644
--- a/install/index.php
+++ b/install/index.php
@@ -81,7 +81,8 @@ if (isset($_GET['create_tables'])) {
 			  `end_date` date NOT NULL,
 			  `invoice_date` date NOT NULL,
 			  `accepted` tinyint(1) unsigned NOT NULL DEFAULT '0',
-			  `invoice_fileId` smallint(5) unsigned DEFAULT NULL,
+				`invoice_fileId` smallint(5) unsigned DEFAULT NULL,
+				`payment_key` varchar(63) DEFAULT NULL,
 			  PRIMARY KEY (`id`),
 			  UNIQUE KEY `invoice_fileId` (`invoice_fileId`),
 			  KEY `contactId` (`contactId`),
@@ -93,6 +94,8 @@ if (isset($_GET['create_tables'])) {
 				`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
 				`offerId` smallint(5) unsigned NOT NULL,
 				`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+				`braintree_id` varchar(36) DEFAULT NULL,
+				`braintree_status` varchar(63) DEFAULT NULL,
 				PRIMARY KEY (`id`)
 			) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
 
@@ -116,6 +119,7 @@ if (isset($_GET['create_tables'])) {
 			  ADD CONSTRAINT `offer_ibfk_1` FOREIGN KEY (`invoice_fileId`) REFERENCES `".Constants::db_prefix."file` (`id`),
 			  ADD CONSTRAINT `offer_ibfk_2` FOREIGN KEY (`contactId`) REFERENCES `".Constants::db_prefix."contact` (`id`)");
 
+		$_pdo->query("CREATE UNIQUE INDEX `payment_uniq_1` ON `".Constants::db_prefix."payment` (`offerId`);");
 		$_pdo->query("ALTER TABLE `payment`
 				ADD CONSTRAINT `payment_ibfk_1` FOREIGN KEY (`offerId`) REFERENCES `offer` (`id`);");
 
diff --git a/install/upgrade.php b/install/upgrade.php
index aea97ce..8ead230 100644
--- a/install/upgrade.php
+++ b/install/upgrade.php
@@ -97,9 +97,8 @@ if (isset($_GET['upgrade'])) {
 			$offers = $_pdo->query("SELECT `id`,`payment_received` FROM `".Constants::db_prefix."offer` WHERE `payment_received` IS NOT NULL");
 			$offers = $offers->fetchAll(PDO::FETCH_ASSOC);
 			foreach ($offers as $offer) {
-				$received = $offer['payment_received'];
-				$offer = new Offer($_pdo, $offer['id']);
-				$offer->createPayment($received);
+				$stmt = $_pdo->prepare("INSERT IGNORE INTO `".Constants::db_prefix."payment` (`offerId`,`date`) VALUES (?,?)");
+				$stmt->execute($offer['id'], $offer['payment_received']);
 			}
 
 			$_pdo->query("ALTER TABLE `".Constants::db_prefix."offer` DROP `payment_received`;");
@@ -108,6 +107,19 @@ if (isset($_GET['upgrade'])) {
 		}
 	}
 
+	if (lower_version($_GET['upgrade'], '0.5')) {
+		try {
+			$_pdo->query("ALTER TABLE `".Constants::db_prefix."offer`
+				ADD `payment_key` VARCHAR(63) DEFAULT NULL;");
+			$_pdo->query("ALTER TABLE `".Constants::db_prefix."payment`
+				ADD `braintree_id` VARCHAR(36) DEFAULT NULL,
+				ADD `braintree_status` VARCHAR (63) NULL DEFAULT NULL;");
+			$_pdo->query("CREATE UNIQUE INDEX `payment_uniq_1` ON `".Constants::db_prefix."payment` (`offerId`);");
+		} catch (PDOException $e) {
+			echo "Altering the database structure failed with a PDOException ({$e->getCode()}): {$e->getMessage()}<br/>" . $e->getTraceAsString();
+		}
+	}
+
 	echo "<br/>All done.";
 }
 ?>
-- 
cgit v1.2.3