private function setDataBase() { if (empty($this->conn)) { $dbhost = app_importer_lib_Config::getInstance()->get_dbhost(); $dbuser = app_importer_lib_Config::getInstance()->get_dbuser(); $dbpassword = app_importer_lib_Config::getInstance()->get_dbpassword(); $dbname = app_importer_lib_Config::getInstance()->get_dbname(); $this->conn = NewADOConnection(app_importer_lib_Config::getInstance()->get_dbdriver()); $this->conn->Connect($dbhost, $dbuser, $dbpassword, $dbname); $this->conn->EXECUTE("set names 'utf8'"); $this->conn->debug = app_importer_lib_Config::getInstance()->get_dbdebug(); } }
public static function getInstance() { if (!isset(self::$instance)) { self::$instance = new self(); } self::$instance->dbhost = "localhost"; self::$instance->dbuser = "******"; self::$instance->dbpassword = "******"; self::$instance->dbname = "cmsptmp"; self::$instance->dbdebug = false; self::$instance->dbdriver = 'mysqli'; self::$instance->timezone = 'America/Sao_Paulo'; date_default_timezone_set(self::$instance->timezone); return self::$instance; }
public static function fixData($str) { $str = (string) $str; $str = trim($str); $str = empty($str) ? "0000-00-00" : $str; $str = str_replace("/", "-", $str); $str = str_replace(",", "-", $str); $str = str_replace(".", "-", $str); $str = str_replace(" ", "-", $str); try { $date = DateTime::createFromFormat("Y-m-d", $str, new DateTimeZone(app_importer_lib_Config::getInstance()->get_timezone())); } catch (Exception $e) { echo "\n" . $e->getMessage() . "\n"; $date = new DateTime('01-01-1800'); } $str = $date->format('d/m/Y'); return $str; }