@@ -52,7 +52,7 @@ discard block |
||
52 | 52 | $pos = 1; |
53 | 53 | foreach ($this->columns as $column) { |
54 | 54 | $sub_data = (in_array($column["type"], $this->notTrimTypes)) ? substr($data, $pos, $column["length"]) : trim(substr($data, $pos, $column["length"])); |
55 | - switch($column["type"]) { |
|
55 | + switch ($column["type"]) { |
|
56 | 56 | case "F": |
57 | 57 | case "N": |
58 | 58 | $record[$column["name"]] = (is_numeric($sub_data)) ? (($column["decimal"]) ? (float) $sub_data : (int) $sub_data) : null; |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | $record[$column["name"]] = empty($sub_data) ? null : $sub_data; |
72 | 72 | break; |
73 | 73 | case "L": |
74 | - $record[$column["name"]] = ($sub_data == "?" || empty($sub_data)) ? null : (in_array(strtolower($sub_data), $this->logicals)); |
|
74 | + $record[$column["name"]] = ($sub_data == "?" || empty($sub_data)) ? null : (in_array(strtolower($sub_data), $this->logicals)); |
|
75 | 75 | break; |
76 | 76 | case "C": |
77 | 77 | $record[$column["name"]] = $this->convertChar($sub_data); |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | case "M": |
80 | 80 | case "P": |
81 | 81 | case "G": |
82 | - $sub_data = (strlen($sub_data) == 4) ? unpack("L", $sub_data)[1] : (int)$sub_data; |
|
82 | + $sub_data = (strlen($sub_data) == 4) ? unpack("L", $sub_data)[1] : (int) $sub_data; |
|
83 | 83 | if (!$sub_data) { |
84 | 84 | $record[$column["name"]] = ""; |
85 | 85 | } else { |
@@ -23,8 +23,7 @@ |
||
23 | 23 | $this->headers = $data->getHeaders(); |
24 | 24 | $this->columns = $data->getColumns(); |
25 | 25 | $this->fp = $data->getData(); |
26 | - } |
|
27 | - else { |
|
26 | + } else { |
|
28 | 27 | if (is_null($headers) || is_null($columns)) { |
29 | 28 | throw new \Exception('Not correct data in Record class'); |
30 | 29 | } |
@@ -45,23 +45,23 @@ discard block |
||
45 | 45 | |
46 | 46 | private $charsets = [ |
47 | 47 | 0 => 866, //If charset not defined |
48 | - 1 => 437, 2 => 850, 3 => 1252, 4 => 10000, 8 => 865, |
|
49 | - 9 => 437, 10 => 850, 11 => 437, 13 => 437, 14 => 850, |
|
50 | - 15 => 437, 16 => 850, 17 => 437, 18 => 850, 19 => 932, |
|
51 | - 20 => 850, 21 => 850, 22 => 437, 23 => 850, 24 => 437, |
|
52 | - 25 => 437, 26 => 850, 27 => 437, 28 => 863, 29 => 850, |
|
53 | - 31 => 852, 34 => 852, 35 => 852, 36 => 860, 37 => 850, |
|
54 | - 38 => 866, 55 => 850, 64 => 852, 77 => 936, 78 => 949, |
|
55 | - 79 => 950, 80 => 874, 88 => 1252, 89 => 1252, 100 => 852, |
|
56 | - 101 => 866, 102 => 865, 103 => 861, 104 => 895, 105 => 866, |
|
57 | - 106 => 737, 107 => 857, 108 => 863, 120 => 950, 121 => 949, |
|
58 | - 122 => 936, 123 => 932, 124 => 874, 134 => 737, 135 => 852, |
|
59 | - 136 => 857, 150 => 10007, 151 => 10029, 152 => 10006, 200 => 1250, |
|
60 | - 201 => 1251, 202 => 1254, 203 => 1253, 204 => 1257 |
|
48 | + 1 => 437, 2 => 850, 3 => 1252, 4 => 10000, 8 => 865, |
|
49 | + 9 => 437, 10 => 850, 11 => 437, 13 => 437, 14 => 850, |
|
50 | + 15 => 437, 16 => 850, 17 => 437, 18 => 850, 19 => 932, |
|
51 | + 20 => 850, 21 => 850, 22 => 437, 23 => 850, 24 => 437, |
|
52 | + 25 => 437, 26 => 850, 27 => 437, 28 => 863, 29 => 850, |
|
53 | + 31 => 852, 34 => 852, 35 => 852, 36 => 860, 37 => 850, |
|
54 | + 38 => 866, 55 => 850, 64 => 852, 77 => 936, 78 => 949, |
|
55 | + 79 => 950, 80 => 874, 88 => 1252, 89 => 1252, 100 => 852, |
|
56 | + 101 => 866, 102 => 865, 103 => 861, 104 => 895, 105 => 866, |
|
57 | + 106 => 737, 107 => 857, 108 => 863, 120 => 950, 121 => 949, |
|
58 | + 122 => 936, 123 => 932, 124 => 874, 134 => 737, 135 => 852, |
|
59 | + 136 => 857, 150 => 10007, 151 => 10029, 152 => 10006, 200 => 1250, |
|
60 | + 201 => 1251, 202 => 1254, 203 => 1253, 204 => 1257 |
|
61 | 61 | ]; |
62 | 62 | private $dbase7 = false, $v_foxpro = false; |
63 | 63 | |
64 | - public function __construct($dbPath, $charset = null){ |
|
64 | + public function __construct($dbPath, $charset = null) { |
|
65 | 65 | $this->db = $dbPath; |
66 | 66 | if (!is_null($charset)) { |
67 | 67 | if (!is_numeric($charset)) { |
@@ -233,16 +233,16 @@ discard block |
||
233 | 233 | |
234 | 234 | private function fileExists($fileName) { |
235 | 235 | |
236 | - if(file_exists($fileName)) { |
|
236 | + if (file_exists($fileName)) { |
|
237 | 237 | return $fileName; |
238 | 238 | } |
239 | 239 | |
240 | 240 | // Handle case insensitive requests |
241 | 241 | $directoryName = dirname($fileName); |
242 | - $fileArray = glob($directoryName . '/*', GLOB_NOSORT); |
|
242 | + $fileArray = glob($directoryName.'/*', GLOB_NOSORT); |
|
243 | 243 | $fileNameLowerCase = strtolower($fileName); |
244 | - foreach($fileArray as $file) { |
|
245 | - if(strtolower($file) == $fileNameLowerCase) { |
|
244 | + foreach ($fileArray as $file) { |
|
245 | + if (strtolower($file) == $fileNameLowerCase) { |
|
246 | 246 | return $file; |
247 | 247 | } |
248 | 248 | } |
@@ -132,20 +132,17 @@ discard block |
||
132 | 132 | if ($this->headers["checks"][0] != 0) { |
133 | 133 | $this->error = true; |
134 | 134 | $this->error_info = "Not correct DBF file by headers"; |
135 | - } |
|
136 | - else { |
|
135 | + } else { |
|
137 | 136 | $this->headers["charset_name"] = "cp".$this->charsets[$this->headers["charset"]]; |
138 | 137 | |
139 | 138 | if (in_array("dBASE 7", $this->versions[$this->headers["version"]])) { |
140 | 139 | $this->dbase7 = true; |
141 | 140 | $this->headers["columns"] = ($this->headers["header_length"] - 68) / 48; |
142 | - } |
|
143 | - elseif (in_array("Visual FoxPro", $this->versions[$this->headers["version"]])) { |
|
141 | + } elseif (in_array("Visual FoxPro", $this->versions[$this->headers["version"]])) { |
|
144 | 142 | $this->v_foxpro = true; |
145 | 143 | $this->headers["memo"] = (in_array($this->headers["mdx_flag"], [2, 3, 6, 7])); |
146 | 144 | $this->headers["columns"] = ($this->headers["header_length"] - 296) / 32; |
147 | - } |
|
148 | - else { |
|
145 | + } else { |
|
149 | 146 | $this->headers["columns"] = ($this->headers["header_length"] - 33) / 32; |
150 | 147 | } |
151 | 148 | |
@@ -178,8 +175,7 @@ discard block |
||
178 | 175 | "mdx_flag" => unpack("C", $data[37])[1], |
179 | 176 | "auto_increment" => unpack("L", substr($data, 40, 4))[1] |
180 | 177 | ]; |
181 | - } |
|
182 | - else { |
|
178 | + } else { |
|
183 | 179 | $this->columns[$i] = [ |
184 | 180 | "name" => strtolower(trim(substr($data, 0, 11))), |
185 | 181 | "type" => $data[11], |
@@ -196,8 +192,7 @@ discard block |
||
196 | 192 | $this->columns[$i]["auto_increment_next"] = unpack("L", substr($data, 19, 4))[1]; |
197 | 193 | $this->columns[$i]["auto_increment_step"] = unpack("C", $data[23])[1]; |
198 | 194 | } |
199 | - } |
|
200 | - else { |
|
195 | + } else { |
|
201 | 196 | $this->columns[$i]["mdx_flag"] = unpack("C", $data[31])[1]; |
202 | 197 | } |
203 | 198 | } |