|
@@ 1040-1056 (lines=17) @@
|
| 1037 |
|
* @param string $sessionID |
| 1038 |
|
* @return bool |
| 1039 |
|
*/ |
| 1040 |
|
protected function checkKlarnaOrderExistsBySession($sessionID) { |
| 1041 |
|
$sql = ' |
| 1042 |
|
SELECT * FROM s_order |
| 1043 |
|
WHERE userID=? |
| 1044 |
|
'; |
| 1045 |
|
|
| 1046 |
|
$order = Shopware()->Db()->fetchAll($sql, array( |
| 1047 |
|
$sessionID |
| 1048 |
|
)); |
| 1049 |
|
|
| 1050 |
|
$orderExists = (empty($order)) ? false : true; |
| 1051 |
|
$this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsBySession:",3); |
| 1052 |
|
if ($orderExists){ |
| 1053 |
|
$this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsBySession: Order Found: ",3, $order); |
| 1054 |
|
} |
| 1055 |
|
return $orderExists; |
| 1056 |
|
} |
| 1057 |
|
|
| 1058 |
|
/** |
| 1059 |
|
* Method checks if certain klarna order exists or not |
|
@@ 1065-1081 (lines=17) @@
|
| 1062 |
|
* @param string $paymentUniqueId |
| 1063 |
|
* @return bool |
| 1064 |
|
*/ |
| 1065 |
|
protected function checkKlarnaOrderExistsByReference($paymentUniqueId) { |
| 1066 |
|
$sql = ' |
| 1067 |
|
SELECT * FROM s_order |
| 1068 |
|
WHERE temporaryID=? |
| 1069 |
|
'; |
| 1070 |
|
|
| 1071 |
|
$order = Shopware()->Db()->fetchAll($sql, array( |
| 1072 |
|
$paymentUniqueId |
| 1073 |
|
)); |
| 1074 |
|
|
| 1075 |
|
$orderExists = (empty($order)) ? false : true; |
| 1076 |
|
$this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReference:",3); |
| 1077 |
|
if ($orderExists){ |
| 1078 |
|
$this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReference: Order Found: ",3, $order); |
| 1079 |
|
} |
| 1080 |
|
return $orderExists; |
| 1081 |
|
} |
| 1082 |
|
|
| 1083 |
|
/** |
| 1084 |
|
* Method checks if certain klarna order exists or not |
|
@@ 1090-1106 (lines=17) @@
|
| 1087 |
|
* @param string $paymentUniqueId |
| 1088 |
|
* @return bool |
| 1089 |
|
*/ |
| 1090 |
|
protected function checkKlarnaOrderExistsByReservation($transactionId) { |
| 1091 |
|
$sql = ' |
| 1092 |
|
SELECT * FROM s_order |
| 1093 |
|
WHERE transactionID=? |
| 1094 |
|
'; |
| 1095 |
|
|
| 1096 |
|
$order = Shopware()->Db()->fetchAll($sql, array( |
| 1097 |
|
$transactionId |
| 1098 |
|
)); |
| 1099 |
|
|
| 1100 |
|
$orderExists = (empty($order)) ? false : true; |
| 1101 |
|
$this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReservation:",3); |
| 1102 |
|
if ($orderExists){ |
| 1103 |
|
$this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReservation: Order Found: ",3, $order); |
| 1104 |
|
} |
| 1105 |
|
return $orderExists; |
| 1106 |
|
} |
| 1107 |
|
|
| 1108 |
|
/** |
| 1109 |
|
* Method checks if certain klarna order exists or not |
|
@@ 1140-1157 (lines=18) @@
|
| 1137 |
|
* @param string $sessionID |
| 1138 |
|
* @return bool |
| 1139 |
|
*/ |
| 1140 |
|
protected function checkKlarnaOrderDetailsBySession($sessionID) { |
| 1141 |
|
$sql = ' |
| 1142 |
|
SELECT * FROM s_order |
| 1143 |
|
LEFT JOIN s_order_details ON s_order.id = s_order_details.orderID |
| 1144 |
|
WHERE userID=? |
| 1145 |
|
'; |
| 1146 |
|
|
| 1147 |
|
$orderDetails = Shopware()->Db()->fetchAll($sql, array( |
| 1148 |
|
$sessionID |
| 1149 |
|
)); |
| 1150 |
|
|
| 1151 |
|
$orderExists = (empty($orderDetails)) ? false : true; |
| 1152 |
|
$this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderDetailsBySession:",3); |
| 1153 |
|
if ($orderExists){ |
| 1154 |
|
$this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderDetailsBySession: OrderDetails Found: ",3, $orderDetails); |
| 1155 |
|
} |
| 1156 |
|
return $orderExists; |
| 1157 |
|
} |
| 1158 |
|
|
| 1159 |
|
/** |
| 1160 |
|
* Method checks if certain klarna order exists or not |