public static function printArray($array, $fields = array(), $fileName = "") { Csv::heades($fileName); $i = 0; foreach ($array as $item) { if (!$i) { $temp = array(); foreach ($item as $k => $v) { $temp[] = __($k); } echo implode(',', $temp) . "\r\n"; unset($temp, $k, $v); } $temp = array(); foreach ($item as $v) { $data = str_replace(",", ";", $v); array_push($temp, $data); } echo implode(',', $temp) . "\r\n"; $i++; } die; }
public function getCsv($fields = null, $method = 'csvSelect') { $db = self::$_msql; if ($this->searchFields) { $this->createFilter(); } if ($this->_where) { $where = implode(' ', $this->_where); } else { $where = ''; } if ($fields && is_array($fields)) { $selectFields = implode(',', $fields); } else { $selectFields = '*'; } $sql = $this->{$method}($selectFields, $where, $this->join); $result = $db->query($sql); $filename = $this->modelName; Csv::heades($filename); $i = 0; $model = new $this->modelName(); $fieldsLable = $model->attributeLabels(); while ($res = $db->fetch($result)) { if (!$i) { $temp = array(); foreach ($res as $key => $value) { $nkey = isset($fieldsLable[$key]) ? $fieldsLable[$key] : $key; $temp[$nkey] = $value; } echo implode(',', array_keys($temp)) . "\r\n"; } echo implode(',', $res) . "\r\n"; $i++; } die; }
private function csvReport($dataProvider, $reportName, $headers = array()) { Csv::heades($reportName); if ($headers) { echo implode(',', array_keys($headers)) . "\r\n"; } foreach ($dataProvider as $dp) { echo implode(',', $dp) . "\r\n"; } die; }