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;
}
