getDatabaseConnection()->exec_SELECTgetRows( 'uid, name', 'tx_t3omembership_domain_model_membership', 'NOT hidden AND NOT deleted' ); foreach ($membershipRecords as $membershipRecord) { $this->memberships[$membershipRecord['name']] = $membershipRecord['uid']; } // does the import file exist? $importFile = $this->getImportFile(); if (!t3lib_div::isAbsPath($importFile)) { $importFile = t3lib_div::getFileAbsFileName($importFile); } if (!file_exists($importFile)) { t3lib_div::devLog('[tx_scheduler_ImportMember]: no importfile - given value: ' . $importFile, 't3o_membership', 0); return false; } else { $this->getDatabaseConnection()->exec_TRUNCATEquery('tx_t3omembership_domain_model_member'); $fileData = file($importFile); array_shift($fileData); foreach ($fileData as $key => $line) { $fields = t3lib_div::trimExplode("\t", $line); $endTime = strtotime($fields[15]); $member = array( 'name' => $fields[6], 'external_id' => (int)$fields[0], 'address' => $fields[7] !== '' ? $fields[7] : $fields[8], 'zip' => $fields[10], 'city' => $fields[11], 'country' => $fields[13], 'end_date' => $endTime, 'endtime' => $endTime, 'starttime' => strtotime(date('d.m.Y', $endTime) . ' -1 year'), 'membership' => $this->getMembershipUid($fields[12]), 'pid' => $this->getMembershipStoragePid(), 'crdate' => time(), 'tstamp' => time(), 'invoice_email' => $fields[84], 'email' => $fields[79], 'url' => $fields[80], 'firstname' => $fields[82], 'lastname' => $fields[83] ); $resource = $this->getDatabaseConnection()->exec_INSERTquery( 'tx_t3omembership_domain_model_member', $member ); $this->getDatabaseConnection()->sql_free_result($resource); } } return true; } /** * @param string $membershipName * @return integer */ protected function getMembershipUid($membershipName) { $membershipName = trim(str_replace('Membership', '', $membershipName)); return $this->memberships[$membershipName]; } /** * Gets importFile * * @return string */ public function getImportFile() { return $this->importFile; } /** * Sets importFile * * @param string $importFile */ public function setImportFile($importFile) { $this->importFile = $importFile; } /** * Gets membershipStoragePid * * @return int */ public function getMembershipStoragePid() { return $this->membershipStoragePid; } /** * Sets membershipStoragePid * * @param int $membershipStoragePid */ public function setMembershipStoragePid($membershipStoragePid) { $this->membershipStoragePid = $membershipStoragePid; } /** * @return t3lib_DB */ protected function getDatabaseConnection() { return $GLOBALS['TYPO3_DB']; } }