Beispiel #1
0
 private function getReturnsPolicy()
 {
     $exists = Db::getInstance()->getValue('SELECT COUNT(*) AS nb FROM ' . _DB_PREFIX_ . 'ebay_returns_policy');
     if ($exists > 0) {
         return Db::getInstance()->ExecuteS('SELECT * FROM ' . _DB_PREFIX_ . 'ebay_returns_policy');
     } else {
         $eBay = new eBayRequest();
         $location = $eBay->getReturnsPolicy();
         $exists = Db::getInstance()->getValue('SELECT COUNT(*) AS nb FROM ' . _DB_PREFIX_ . 'ebay_returns_policy');
         if ($exists > 0) {
             return Db::getInstance()->ExecuteS('SELECT * FROM ' . _DB_PREFIX_ . 'ebay_returns_policy');
         } else {
             foreach ($location as $key => $value) {
                 foreach ($value as $keyfield => $fieldValue) {
                     $value[$keyfield] = pSQL($fieldValue);
                 }
                 Db::getInstance()->autoExecute(_DB_PREFIX_ . 'ebay_returns_policy', $value, 'INSERT');
             }
             return $location;
         }
     }
 }