晋太元中,武陵人捕鱼为业。缘溪行,忘路之远近。忽逢桃花林,夹岸数百步,中无杂树,芳草鲜美,落英缤纷。渔人甚异之,复前行,欲穷其林。 林尽水源,便得一山,山有小口,仿佛若有光。便舍船,从口入。初极狭,才通人。复行数十步,豁然开朗。土地平旷,屋舍俨然,有良田、美池、桑竹之属。阡陌交通,鸡犬相闻。其中往来种作,男女衣着,悉如外人。黄发垂髫,并怡然自乐。 见渔人,乃大惊,问所从来。具答之。便要还家,设酒杀鸡作食。村中闻有此人,咸来问讯。自云先世避秦时乱,率妻子邑人来此绝境,不复出焉,遂与外人间隔。问今是何世,乃不知有汉,无论魏晋。此人一一为具言所闻,皆叹惋。余人各复延至其家,皆出酒食。停数日,辞去。此中人语云:“不足为外人道也。”(间隔 一作:隔绝) 既出,得其船,便扶向路,处处志之。及郡下,诣太守,说如此。太守即遣人随其往,寻向所志,遂迷,不复得路。 南阳刘子骥,高尚士也,闻之,欣然规往。未果,寻病终。后遂无问津者。
|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/public_html/crm/modules/Import/readers/ |
Upload File : |
<?php
/*+***********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*************************************************************************************/
ini_set("auto_detect_line_endings", true);
class Import_CSVReader_Reader extends Import_FileReader_Reader {
public function arrayCombine($key, $value) {
$combine = array();
$dup = array();
for($i=0;$i<count($key);$i++) {
if(array_key_exists($key[$i], $combine)){
if(!$dup[$key[$i]]) $dup[$key[$i]] = 1;
$key[$i] = $key[$i]."(".++$dup[$key[$i]].")";
}
$combine[$key[$i]] = $value[$i];
}
return $combine;
}
public function getFirstRowData($hasHeader=true) {
global $default_charset;
$fileHandler = $this->getFileHandler();
$headers = array();
$firstRowData = array();
$currentRow = 0;
while($data = fgetcsv($fileHandler, 0, $this->request->get('delimiter'), "\"", "\"")) {
if($currentRow == 0 || ($currentRow == 1 && $hasHeader)) {
if($hasHeader && $currentRow == 0) {
foreach($data as $key => $value) {
$headers[$key] = trim($this->convertCharacterEncoding(strip_tags(decode_html($value)), $this->request->get('file_encoding'), $default_charset));
}
} else {
foreach($data as $key => $value) {
$firstRowData[$key] = trim($this->convertCharacterEncoding(strip_tags(decode_html($value)), $this->request->get('file_encoding'), $default_charset));
}
break;
}
}
$currentRow++;
}
if($hasHeader) {
$noOfHeaders = count($headers);
$noOfFirstRowData = count($firstRowData);
// Adjust first row data to get in sync with the number of headers
if($noOfHeaders > $noOfFirstRowData) {
$firstRowData = array_merge($firstRowData, array_fill($noOfFirstRowData, $noOfHeaders-$noOfFirstRowData, ''));
} elseif($noOfHeaders < $noOfFirstRowData) {
$firstRowData = array_slice($firstRowData, 0, count($headers), true);
}
$rowData = $this->arrayCombine($headers, $firstRowData);
} else {
$rowData = $firstRowData;
}
unset($fileHandler);
return $rowData;
}
public function read() {
global $default_charset;
$fileHandler = $this->getFileHandler();
$status = $this->createTable();
if(!$status) {
return false;
}
$fieldMapping = $this->request->get('field_mapping');
$delimiter = $this->request->get('delimiter');
$hasHeader = $this->request->get('has_header');
$fileEncoding = $this->request->get('file_encoding');
// NOTE: Retaining row-read and insert as LOAD DATA command is being disabled by default.
$i = -1;
while($data = fgetcsv($fileHandler, 0, $delimiter)) {
$i++;
if($hasHeader && $i == 0) continue;
$mappedData = array();
$allValuesEmpty = true;
foreach($fieldMapping as $fieldName => $index) {
$fieldValue = $data[$index];
$mappedData[$fieldName] = $fieldValue;
if($fileEncoding != $default_charset) {
$mappedData[$fieldName] = $this->convertCharacterEncoding($fieldValue, $fileEncoding, $default_charset);
}
if(!empty($fieldValue)) $allValuesEmpty = false;
}
if($allValuesEmpty) continue;
$fieldNames = array_keys($mappedData);
$fieldValues = array_values($mappedData);
$this->addRecordToDB($fieldNames, $fieldValues);
}
unset($fileHandler);
}
}
?>