public function execute() { $this->init(); $this->reader->seek(max(0, waRequest::request('row', 0, waRequest::TYPE_INT))); $limit = max(1, waRequest::request('limit', 50, waRequest::TYPE_INT)); $this->reader->columns(array(array('shopCsvProductviewController', 'tableRowHandler'), array(__CLASS__, 'columns'))); $n = 0; $this->response['tbody'] = ''; while (++$n <= $limit && $this->reader->next()) { $this->response['tbody'] .= $this->reader->getTableRow(); } $this->response['rows_count'] = $this->reader->count(); $this->response['current'] = $this->reader->key(); }
protected function info() { $interval = 0; if (!empty($this->data['timestamp'])) { $interval = time() - $this->data['timestamp']; } $response = array('time' => sprintf('%d:%02d:%02d', floor($interval / 3600), floor($interval / 60) % 60, $interval % 60), 'processId' => $this->processId, 'progress' => 0.0, 'ready' => $this->isDone(), 'count' => empty($this->data['count']) ? false : $this->data['count'], 'memory' => sprintf('%0.2fMByte', $this->data['memory'] / 1048576), 'memory_avg' => sprintf('%0.2fMByte', $this->data['memory_avg'] / 1048576)); $stage_count = 0; //count($this->data['current']); foreach ($this->data['current'] as $stage => $current) { if ($this->data['count'][$stage]) { if ($stage == self::STAGE_SKU) { if ($this->data['drection'] == 'import') { $response['progress'] += 100.0 * (1.0 * $current / $this->data['count'][$stage] - 1.0) / $this->data['count'][self::STAGE_PRODUCT]; } } else { ++$stage_count; $response['progress'] += 100.0 * (1.0 * $current / $this->data['count'][$stage]); } } } $response['progress'] = sprintf('%0.3f%%', $response['progress'] / max(1, $stage_count)); $response['stage_count'] = $stage_count; $response['current_count'] = $this->data['current']; $response['processed_count'] = $this->data['processed_count']; $this->getResponse()->addHeader('Content-type', 'application/json'); $this->getResponse()->sendHeaders(); if ($this->writer) { $response['file'] = urlencode(basename($this->writer->file())); } if ($response['ready']) { $response['report'] = $this->report(); if (!empty($this->data['emulate'])) { $callback = create_function('$a', 'return count($a)>1;'); $emulate = array(); foreach ($this->data['emulate'] as $row => $key) { if (!isset($emulate[$key])) { $emulate[$key] = array(); } $emulate[$key][] = $row; } $params = array(); if ($collision = array_filter($emulate, $callback)) { $response['collision'] = array(); foreach ($collision as $key => $rows) { $rows = array_map('intval', $rows); asort($rows); $response['collision'][] = array('key' => $key, 'rows' => $rows); $params[$key] = $rows; } } else { $response['collision'] = true; } if (!empty($this->reader)) { $response['rows_count'] = $this->reader->count(); shopCsvReader::snapshot($this->reader, $params); unset($params); } } } echo $this->json($response); }
protected function save(waRequestFile $file) { $path = wa()->getTempPath('csv/upload/'); waFiles::create($path); $original_name = $file->name; if ($name = tempnam($path, 'csv')) { unlink($name); if (($ext = pathinfo($original_name, PATHINFO_EXTENSION)) && preg_match('/^\\w+$/', $ext)) { $name .= '.' . $ext; } $file->moveTo($name); } else { throw new waException(_w('Error file upload')); } $encoding = waRequest::post('encoding', 'UTF-8'); $delimiter = waRequest::post('delimiter'); try { $this->reader = new shopCsvReader($name, $delimiter, $encoding); $delimiters = array(';', ',', 'tab'); $used_delimiters = array($delimiter); while (count($this->reader->header()) < 2 && ($delimiter = array_diff($delimiters, $used_delimiters))) { $delimiter = reset($delimiter); $used_delimiters[] = $delimiter; $this->reader->delete(); $this->reader = new shopCsvReader($name, $delimiter, $encoding); } if (count($this->reader->header()) < 2) { $this->reader->delete(); $delimiter = waRequest::post('delimiter'); $this->reader = new shopCsvReader($name, $delimiter, $encoding); } $encodings = array('UTF-8', 'Windows-1251', 'ISO-8859-1'); $used_encodings = array($encoding); while (in_array(false, (array) $this->reader->header(), true) && ($encoding = array_diff($encodings, $used_encodings))) { $encoding = reset($encoding); $used_encodings[] = $encoding; $this->reader->delete(); $this->reader = new shopCsvReader($name, $delimiter, $encoding); } if (in_array(false, (array) $this->reader->header(), true) || count($this->reader->header()) < 2) { throw new waException($this->reader->header() ? _w('No data columns were located in the uploaded file. Make sure right separator and encoding were chosen for this upload.') : _w('Unsupported CSV file structure')); } $profile_helper = new shopImportexportHelper('csv:product:import'); $profile = $profile_helper->getConfig(); $profile['config'] += array('encoding' => $encoding, 'delimiter' => ';', 'map' => array()); $params = array(); $params['id'] = 'csvproducts'; $params['title_wrapper'] = '%s'; $params['description_wrapper'] = '<br><span class="hint">%s</span>'; $params['control_wrapper'] = '<div class="field"><div class="name">%s</div><div class="value">%s %s</div></div>'; $params['options'] = $this->options(); $control = true ? shopCsvReader::TABLE_CONTROL : shopCsvReader::MAP_CONTROL; switch ($control) { case shopCsvReader::TABLE_CONTROL: $params['preview'] = 50; $params['columns'] = array(array('shopCsvProductviewController', 'tableRowHandler'), ' '); $params['control_wrapper'] = '<div class="field"><div class="value" style="overflow-x:auto;margin-left:0;">%s %s</div></div>'; $params['title_wrapper'] = false; $params['row_handler'] = 'csv_product/rows/'; $params['row_handler_string'] = true; $params['autocomplete_handler'] = 'csv_product/autocomplete/reset/'; break; case shopCsvReader::MAP_CONTROL: default: $control = shopCsvReader::MAP_CONTROL; break; } return array('name' => htmlentities(basename($this->reader->file()), ENT_QUOTES, 'utf-8'), 'original_name' => htmlentities(basename($original_name), ENT_QUOTES, 'utf-8'), 'size' => waFiles::formatSize($this->reader->size()), 'original_size' => waFiles::formatSize($file->size), 'controls' => waHtmlControl::getControl($control, 'csv_map', $params), 'control' => $control, 'header' => $this->reader->header(), 'columns_offset' => count(ifset($params['columns'], array())), 'delimiter' => $delimiter, 'encoding' => $encoding); } catch (waException $ex) { if ($this->reader) { $this->reader->delete(true); } throw $ex; } }