/** * Get timestamp * @param String value * @param String dateFormat * @return String */ function getTimeStamp($value, $dateFormat) { $refinedDateFormat = getRefinedDateFormat($dateFormat); return strtotime(localdatetime2db($value, $refinedDateFormat)); }
/** * Import data form a file to db * @param String filePath * @param Array &importData * @return Array */ public function ImportFromFile($filePath, &$importData) { $fieldsData = $this->refineImportFielsData($importData["importFieldsData"]); $dateFormat = getRefinedDateFormat($this->getImportDateFormat($importData["dateFormat"])); if ($importData["CSV"]) { $metaData = $this->importFromCSV($filePath, $fieldsData, $importData["useHeadersLine"], $importData["delimiter"], $dateFormat); } else { $metaData = $this->importFromExcel($filePath, $fieldsData, $importData["useHeadersLine"], $dateFormat); } $resultData = array(); $resultData["reportText"] = $this->getBasicReportText($metaData["totalRecords"], $metaData["addedRecords"], $metaData["updatedRecords"]); $resultData["unprocessedRecordsNumber"] = count($metaData["errorMessages"]); // prepare a report file $reportFileText = $this->getBasicReportText($metaData["totalRecords"], $metaData["addedRecords"], $metaData["updatedRecords"], false, "\r\n", $metaData["errorMessages"], $metaData["unprocessedData"]); $logFilePath = getabspath("templates_c/" . $this->getImportLogFileName() . ".txt"); runner_save_file($logFilePath, $reportFileText); $resultData["logFilePath"] = $logFilePath; if (count($metaData["unprocessedData"])) { // prepare an unprocessed data log $unprocFilePath = getabspath("templates_c/" . $this->getUnprocessedDataFileName() . ".csv"); $unprocContent = $this->getUnprocessedDataContent($metaData["unprocessedData"]); runner_save_file($unprocFilePath, $unprocContent); $resultData["unprocessedFilePath"] = $unprocFilePath; } return $resultData; }