/**
* Get the mapping data: methods of payment
*
* @return array
*/
public function getMethodOfPayment()
{
// s_core_tax
$rows = Shopware()->Db()->query('
SELECT
C.id, C.description name,
IFNULL(PMC.plentyID, -1) plentyID
FROM s_core_paymentmeans C
LEFT JOIN plenty_mapping_method_of_payment PMC
ON PMC.shopwareID = C.id
WHERE active = 1
ORDER BY C.name
')->fetchAll();
$plentyShipping = PlentymarketsImportController::getMethodOfPaymentList();
foreach ($rows as &$row) {
if ($row['plentyID'] >= 0) {
$row['plentyName'] = $plentyShipping[$row['plentyID']]['name'];
} else {
if ($this->auto) {
foreach ($plentyShipping as $plentyData) {
$distance = levenshtein($row['name'], $plentyData['name']);
if ($distance <= 2 || strstr($plentyData['name'], $row['name'])) {
$row['plentyName'] = $plentyData['name'];
$row['plentyID'] = $plentyData['id'];
PlentymarketsMappingController::addMethodOfPayment($row['id'], $plentyData['id']);
if ($distance == 0) {
break;
}
}
}
} else {
$row['plentyName'] = '';
}
}
}
return $rows;
}
