public function importCustomerTitle()
{
$con = Propel::getConnection(CustomerTitleTableMap::DATABASE_NAME);
$con->beginTransaction();
try {
CustomerTitleQuery::create()->deleteAll();
$hdl = $this->t1db->query("select * from raison order by classement");
while ($hdl && ($raison = $this->t1db->fetch_object($hdl))) {
$ct = new CustomerTitle();
$descs = $this->t1db->query_list("select * from raisondesc where raison = ? order by lang asc", array($raison->id));
foreach ($descs as $desc) {
$lang = $this->getT2Lang($desc->lang);
$ct->setLocale($lang->getLocale())->setByDefault($raison->defaut ? true : false)->setPosition($raison->classement)->setLong($desc->long)->setShort($desc->court)->save();
}
}
$con->commit();
} catch (\Exception $ex) {
$con->rollBack();
Tlog::getInstance()->error("Failed to import Thelia 1 customer titles (not a problem for Thelia 1.4.x). Cause: " . $ex->getMessage());
}
}
