public function readUnits()
{
$con = self::openConnection();
$currencies = new Currencies();
mysqli_begin_transaction($con);
$sql = "SELECT * FROM currency WHERE 1";
$res = mysqli_query($con, $sql);
while ($arrRes = mysqli_fetch_assoc($res)) {
$currency = new Currency();
$currency->setId($arrRes['id']);
$currency->setCode($arrRes['code']);
$currencies->setUnit($currency);
}
return $currencies;
}
public function parseCurrencies()
{
$currencies = new Currencies();
$keyParams = array();
foreach ($this->xmlProducts as $product) {
$cur = $product->getCurrency();
if (!empty($cur) && !in_array($cur, $keyParams)) {
array_push($keyParams, $cur);
$currency = new Currency();
$currency->setCode($cur);
$currencies->setUnit($currency);
}
}
$currencyDAO = new CurrencyDAO();
$currencyDAO->insertUnits($currencies);
$currencies = $currencyDAO->readUnits();
return $currencies;
}
