| @@ 1185-1201 (lines=17) @@ | ||
| 1182 | * @param string $sessionID |
|
| 1183 | * @return bool |
|
| 1184 | */ |
|
| 1185 | protected function checkKlarnaOrderExistsBySession($sessionID) |
|
| 1186 | { |
|
| 1187 | $sql = ' |
|
| 1188 | SELECT * FROM s_order |
|
| 1189 | WHERE userID=? |
|
| 1190 | '; |
|
| 1191 | ||
| 1192 | $order = Shopware()->Db()->fetchAll($sql, [ |
|
| 1193 | $sessionID, |
|
| 1194 | ]); |
|
| 1195 | ||
| 1196 | $orderExists = (empty($order)) ? false : true; |
|
| 1197 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsBySession:", 3); |
|
| 1198 | if ($orderExists) { |
|
| 1199 | $this->plugin->klarnaLog( |
|
| 1200 | "Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsBySession: Order Found: ", |
|
| 1201 | 3, |
|
| 1202 | $order |
|
| 1203 | ); |
|
| 1204 | } |
|
| @@ 1215-1231 (lines=17) @@ | ||
| 1212 | * @return bool |
|
| 1213 | * @internal param string $transactionId |
|
| 1214 | */ |
|
| 1215 | protected function checkKlarnaOrderExistsByReference($paymentUniqueId) |
|
| 1216 | { |
|
| 1217 | $sql = ' |
|
| 1218 | SELECT * FROM s_order |
|
| 1219 | WHERE temporaryID=? |
|
| 1220 | '; |
|
| 1221 | ||
| 1222 | $order = Shopware()->Db()->fetchAll($sql, [ |
|
| 1223 | $paymentUniqueId, |
|
| 1224 | ]); |
|
| 1225 | ||
| 1226 | $orderExists = (empty($order)) ? false : true; |
|
| 1227 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReference:", 3); |
|
| 1228 | if ($orderExists) { |
|
| 1229 | $this->plugin->klarnaLog( |
|
| 1230 | "Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReference: Order Found: ", |
|
| 1231 | 3, |
|
| 1232 | $order |
|
| 1233 | ); |
|
| 1234 | } |
|
| @@ 1245-1261 (lines=17) @@ | ||
| 1242 | * @return bool |
|
| 1243 | * @internal param string $paymentUniqueId |
|
| 1244 | */ |
|
| 1245 | protected function checkKlarnaOrderExistsByReservation($transactionId) |
|
| 1246 | { |
|
| 1247 | $sql = ' |
|
| 1248 | SELECT * FROM s_order |
|
| 1249 | WHERE transactionID=? |
|
| 1250 | '; |
|
| 1251 | ||
| 1252 | $order = Shopware()->Db()->fetchAll($sql, [ |
|
| 1253 | $transactionId, |
|
| 1254 | ]); |
|
| 1255 | ||
| 1256 | $orderExists = (empty($order)) ? false : true; |
|
| 1257 | $this->plugin->klarnaLog( |
|
| 1258 | "Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReservation:", |
|
| 1259 | 3 |
|
| 1260 | ); |
|
| 1261 | if ($orderExists) { |
|
| 1262 | $this->plugin->klarnaLog( |
|
| 1263 | "Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReservation: Order Found: ", |
|
| 1264 | 3, |
|
| @@ 1304-1321 (lines=18) @@ | ||
| 1301 | * @param string $sessionID |
|
| 1302 | * @return bool |
|
| 1303 | */ |
|
| 1304 | protected function checkKlarnaOrderDetailsBySession($sessionID) |
|
| 1305 | { |
|
| 1306 | $sql = ' |
|
| 1307 | SELECT * FROM s_order |
|
| 1308 | LEFT JOIN s_order_details ON s_order.id = s_order_details.orderID |
|
| 1309 | WHERE userID=? |
|
| 1310 | '; |
|
| 1311 | ||
| 1312 | $orderDetails = Shopware()->Db()->fetchAll($sql, [ |
|
| 1313 | $sessionID, |
|
| 1314 | ]); |
|
| 1315 | ||
| 1316 | $orderExists = (empty($orderDetails)) ? false : true; |
|
| 1317 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderDetailsBySession:", 3); |
|
| 1318 | if ($orderExists) { |
|
| 1319 | $this->plugin->klarnaLog( |
|
| 1320 | "Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderDetailsBySession: OrderDetails Found: ", |
|
| 1321 | 3, |
|
| 1322 | $orderDetails |
|
| 1323 | ); |
|
| 1324 | } |
|