public function action_index()
{
$id = $this->request->param('id');
if ($id == 'export') {
$query = 'SELECT * FROM vz_catalog ORDER BY act DESC LIMIT 700, 100';
$result = DB::query(Database::SELECT, $query)->execute()->as_array();
$types = array('', 'База отдыха', 'Загородный отель', 'Санаторий', 'Кемпинг', 'Гостиница', 'Конно - спортивный клуб', 'Коттедж');
$region = array('0' => '', '66' => 'Свердловская область', '74' => 'Челябинская область', '72' => 'Тюменская область', '59' => 'Пермский край', '2' => 'Башкортостан');
$facialities = array('0' => '', '1' => 'Баня', '3' => 'Баня, Бассейн', '4' => 'Бильярд', '5' => 'Баня, Бильярд', '7' => 'Баня, Бассейн, Бильярд', '9' => 'Баня, Лес', '11' => 'Баня, Бассейн, Лес', '13' => 'Баня, Бильярд, Лес', '15' => 'Баня, Бассейн, Бильярд, Лес', '17' => 'Баня, Водоем', '20' => 'Бильярд, Водоем', '21' => 'Баня, Бильярд, Водоем', '23' => 'Баня, Бассейн, Бильярд, Водоем', '24' => 'Лес, Водоем', '25' => 'Баня, Лес, Водоем', '27' => 'Баня, Бассейн, Лес, Водоем', '29' => 'Баня, Бильярд, Лес, Водоем', '31' => 'Баня, Бассейн, Бильярд, Лес, Водоем', '33' => 'Баня, Питание', '35' => 'Баня, Бассейн, Питание', '37' => 'Баня, Бильярд, Питание', '39' => 'Баня, Бассейн, Бильярд, Питание', '40' => 'Лес, Питание', '41' => 'Баня, Лес, Питание', '43' => 'Баня, Бассейн, Лес, Питание', '44' => 'Бильярд, Лес, Питание', '45' => 'Баня, Биллиард, Лес, Питание', '47' => 'Баня, Бассейн, Бильярд, Лес, Питание', '49' => 'Баня, Лес, Питание', '51' => 'Баня, Бассейн, Лес, Питание', '53' => 'Баня, Бильярд, Лес, Питание', '56' => 'Лес, Водоем, Питание', '57' => 'Баня, Лес, Водоем, Питание', '58' => 'Бассейн, Лес, Водоем, Питание', '59' => 'Баня, Бассейн, Лес, Водоем, Питание', '60' => 'Бильярд, Лес, Водоем, Питание', '61' => 'Баня, Бильярд, Лес, Водоем, Питание', '63' => 'Баня, Бассейн, Бильярд, Лес, Водоем, Питание', '65' => 'Баня, Бассейн, Бильярд, Лес, Водоем, Питание');
$base = new Model_Base();
$material = new Model_Material('group');
$counter = 0;
foreach ($result as $item) {
$photos = array();
$dates = array();
$faciality = array();
$dquery = 'SELECT busy_date FROM vz_calendar WHERE cottage_id =' . $item['id'];
$dresult = DB::query(Database::SELECT, $dquery)->execute()->as_array();
if (isset($facialities[$item['opt']])) {
$ifaciality = explode(',', $facialities[$item['opt']]);
} else {
$ifaciality = array();
}
foreach ($ifaciality as $fitem) {
$faciality[] = trim($fitem);
}
foreach ($dresult as $date) {
$dates[] = $date['busy_date'];
}
$pquery = 'SELECT id, title FROM vz_images WHERE top = ' . $item['id'] . ' ORDER by ord';
$presult = DB::query(Database::SELECT, $pquery)->execute()->as_array();
foreach ($presult as $pitem) {
$id = intval($pitem['id']);
if ($id < 1000) {
$folder = 0;
}
if ($id > 999 && $id < 10000) {
$folder = substr($id, 0, 1);
}
if ($id > 9999) {
$folder = substr($id, 0, 2);
}
$photos[] = '/img/user/catalog/' . $folder . '/' . $pitem['id'] . 'b.jpg';
}
if ($item['act'] == 1) {
$sleep = 0;
} else {
$sleep = 1;
}
$insert = array('title' => $item['name'], 'url' => $base->str2url($item['name']), 'description' => $item['description'], 'sleep' => $sleep, 'date_241' => $dates, 'select_223' => array($types[$item['object_type']]), 'chars_224' => $item['pagetitle'], 'chars_225' => $item['spec_offer'], 'chars_226' => $item['spec_price'], 'chars_227' => $item['city'], 'select_228' => array($region[$item['region']]), 'chars_229' => $item['len'], 'chars_230' => $item['path'], 'select_231' => $faciality, 'chars_232' => $item['bad1'], 'chars_233' => $item['bad2'], 'chars_234' => $item['rooms'], 'price_235' => $item['cost'], 'chars_236' => $item['dayprice'], 'chars_237' => $item['people'], 'chars_238' => $item['mincapacity'], 'chars_239' => $item['capacity'], 'photoalbum_243' => $photos, 'texts_242' => $item['content']);
$res = $material->newMaterial($insert, '33', array(), TRUE);
if ($res) {
++$counter;
} else {
$this->data['errors'][] = 'Материал ' . $item['name'] . ' не был добавлен';
}
//
// echo '<pre>';
// var_dump($insert);
// echo '<pre>';
}
$this->data['messages'][] = 'Добавлено ' . $counter . ' материалов';
} elseif ($id == 'comments') {
//перебираем все отзывы
$query = 'SELECT a.*, b.name AS obj_name FROM vz_reviews a, vz_catalog b WHERE a.object_id = b.id ORDER BY object_id DESC LIMIT 0, 1000';
$result = DB::query(Database::SELECT, $query)->execute()->as_array();
$cnt = 0;
foreach ($result as $comment) {
$q = 'SELECT id FROM materials WHERE name =\'' . $comment['obj_name'] . '\'';
$res = DB::query(Database::SELECT, $q)->execute()->current();
if ($res) {
$q1 = "UPDATE vz_reviews SET object_id = " . $res['id'] . ' WHERE id =' . $comment['id'];
$res1 = DB::query(Database::UPDATE, $q1)->execute();
if (!$res1) {
$this->data['errors'][] = $q1;
} else {
++$cnt;
}
}
}
$this->data['messages'][] = 'Обновлено ' . $cnt . ' комментариев';
} elseif ($id == 'update_id') {
$cnt = 0;
//ПЕРЕБИРАЕМ ВСЕ КОТТЕДЖИ
$query = 'SELECT * FROM vz_catalog WHERE act!=0 ORDER BY act DESC LIMIT 0, 500';
$result = DB::query(Database::SELECT, $query)->execute()->as_array();
foreach ($result as $item) {
//делаем запрос по названию
$q = 'UPDATE materials SET old_id = ' . $item['id'] . ' WHERE name = \'' . $item['name'] . '\'';
$res = DB::query(Database::UPDATE, $q)->execute();
if (!$res) {
$this->data['errors'][] = $q;
} else {
++$cnt;
}
}
}
$this->template->content = View::factory('admin/admScripts', array('data' => $this->data, 'user' => $this->user));
}
public function action_load_price()
{
// Получение значения ячейки
function get_cell_value($worksheet, $cell)
{
return $worksheet->getCell($cell)->getValue();
}
// Преобразование числового значения столбца в символьное
function col_n2str($col_n)
{
return PHPExcel_Cell::stringFromColumnIndex($col_n - 1);
}
// Преобразование символьного значения столбца в числовое
function col_str2n($col)
{
return PHPExcel_Cell::columnIndexFromString($col);
}
// Узнать уровень вложенности строки
function get_level($worksheet, $row)
{
return $worksheet->getRowDimension($row)->getOutlineLevel();
}
$objPHPExcel = PHPExcel_IOFactory::load(DOCROOT . "/price.xls");
$structure = array("name" => array("index" => "A", "type" => "chars", "title" => "Наименование", "ordering" => 1), "ed_izm" => array("index" => "N", "type" => "select", "title" => "Единица измерения", "ordering" => 2), "price" => array("index" => "O", "type" => "price", "title" => "Цена", "ordering" => 3));
$num_structure = array_values($structure);
$categories = array(array("id" => 0, "level" => -1, "name" => "root"));
$materials = array();
$category_id_counter = 1;
// Счётчик для id категории
$parent_category_id = 0;
// id родительской категории
//echo '<table border>';
//echo "<tr><td>Id категории<td>Уровень<td>id родительской категории<td>Название категории</tr>";
// Проход по листам
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
$worksheet_title = $worksheet->getTitle();
$max_row = $worksheet->getHighestRow();
// максимальная строка
$max_col = $worksheet->getHighestColumn();
// максимальный столбец (буква)
$max_col = col_str2n($max_col);
// максимальный столбец (цифра)
//echo "<p>Максимальная строка: " . $max_row . "</p>";
//echo "<p>Максимальный столбец: " . $max_col . " (" . col_n2str($max_col) . ")</p>";
$start_row = 12;
// С какой строки начинаем?
// Перебор строк
for ($row = $start_row; $row <= $max_row; $row++) {
$level = get_level($worksheet, $row);
// Уровень вложенности
// Строка является заголовком?
if (!get_cell_value($worksheet, $num_structure[1]["index"] . $row)) {
$current_cell = "A" . $row;
// Адрес ячейки
$value = get_cell_value($worksheet, $current_cell);
// Название категории
$categories[$category_id_counter] = array("id" => $category_id_counter, "level" => $level, "name" => $value);
// Поиск родителя
for ($i = $category_id_counter; $i >= 0; $i--) {
if ($categories[$i]["level"] == $level - 1) {
$parent_category_id = $categories[$i]["id"];
break;
}
}
//echo "<tr><td>" . $category_id_counter . "<td>" . $level . "<td>" . $parent_category_id . "<td>" . $value;
$categories[$category_id_counter]["parent"] = $parent_category_id;
$category_id_counter++;
} else {
//echo '<tr><td colspan="4"><table style="width:100%;" border><tr>';
foreach ($structure as $name => $el) {
$current_cell = $el["index"] . $row;
// Адрес ячейки
$value = get_cell_value($worksheet, $current_cell);
$material_data[$name] = $value;
//echo '<td>' . $value;
}
//echo "</table>";
$category_id = $category_id_counter - 1;
$material_data["category_id"] = $category_id;
if (!isset($categories[$category_id]["materials"])) {
$categories[$category_id]["materials"] = array();
}
$categories[$category_id]["materials"][] = $material_data;
$materials[] = $material_data;
}
}
//echo "</table>";
//var_dump($categories);
//var_dump($materials);
//echo "<hr>";
}
$gid = 1218;
// id группы
$model_material = new Model_Material('groups');
$model_base = new Model_Base();
$group = $model_material->getGroup($gid);
$categories[0]["db_id"] = $gid;
$categories[0]["name"] = $group["name"];
$parent_id = 0;
$insertdata = array();
$fieldset = $model_material->getFieldsSet($gid);
//$insert_categories = array();
$current_level = 0;
while (true) {
$search_level_status = false;
foreach ($categories as $category_id => $category_data) {
if ($category_data["level"] == $current_level) {
$search_level_status = true;
// Поиск родителя
for ($i = $category_id; $i >= 0; $i--) {
if ($categories[$i]["level"] == $current_level - 1) {
$parent_id = $categories[$i]["db_id"];
break;
}
}
$insert_group_id = $model_material->groupInsert($parent_id, $parent_id, array('name' => $category_data["name"]));
$group_params = array();
foreach ($structure as $name => $param) {
$param_data = array_merge($param, array("name" => $name, "gid" => $insert_group_id));
$model_material->addParam($param_data);
}
$category_data["db_id"] = $insert_group_id;
if (isset($category_data["materials"])) {
$fieldset = $model_material->getFieldsSet($insert_group_id);
//var_dump($fieldset);
// Проход по материалам
foreach ($category_data["materials"] as $material) {
//var_dump($material);
$insertdata = array();
$insertdata['title'] = Request::clearText($material["name"]);
$insertdata['url'] = Request::str2url($material["name"]);
$insertdata['description'] = Request::clearText($material["name"]);
// Проход по параметрам
foreach ($fieldset as $field) {
if (isset($structure[$field["name"]])) {
$insertdata[$field["type"] . '_' . $field["id"]] = $material[$field["name"]];
switch ($field["type"]) {
case "files":
$insertdata[$field["type"] . '_' . $field["id"]] = array($material[$field["name"]]);
break;
case "photoalbum":
$insertdata[$field["type"] . '_' . $field["id"]] = array($material[$field["name"]]);
break;
case "select":
$insertdata[$field["type"] . '_' . $field["id"]] = array($material[$field["name"]]);
break;
}
// Наценка 30%
/*if ($field["type"] == "price") {
$insertdata[$field["type"].'_'.$field["id"]] = $material[$field["name"]] * 1.3;
}*/
}
}
echo "<pre>";
var_dump($insertdata);
echo "</pre>";
$result = $model_material->newMaterial($insertdata, $insert_group_id, TRUE);
}
}
//var_dump($category_data);
echo "<hr>";
$categories[$category_id] = $category_data;
}
}
if (!$search_level_status) {
break;
}
$current_level++;
}
}
public function action_new()
{
$fieldset = array();
$group = new Model_Material('groups');
$data['groups'] = $group->getTree();
$gid = $this->request->param('id');
if ($gid != NULL) {
$fields = $group->getParams($gid);
foreach ($fields as $field) {
//генерируем код для каждого поля
//если поле - список выбора
if ($field['type'] == 'select') {
$values = $group->getSelectValues($field['id']);
$field['myValues'] = $values;
}
$fieldset[] = View::factory('admin/fields/' . $field['type'])->bind('data', $field)->render();
}
$data['fieldset'] = $fieldset;
}
if (isset($_POST['new_material'])) {
$res = $group->newMaterial($_POST, $gid, $_FILES);
if ($res) {
Controller::redirect('admin/materials/' . $gid);
} else {
$data['errors'] = $group->getErrors();
}
}
$wpm['status'] = Cookie::get('wpm', FALSE);
$wpm['folder'] = Cookie::get('wpm_folder', '');
$folders = $this->getFolders();
$pictures = $this->action_pictures($wpm['folder']);
$this->template->content = View::factory('admin/admMaterials', array('data' => $data, 'folders' => $folders, 'pictures' => $pictures, 'wpm' => $wpm, 'user' => $this->user));
}
public function action_new()
{
$fieldset = array();
$folders = $this->getFolders();
$group = new Model_Material('groups');
$data['groups'] = $group->getTree();
$gid = $this->request->param('id');
if ($gid != NULL) {
$fields = $group->getParams($gid);
foreach ($fields as $field) {
//генерируем код для каждого поля
//если поле - список выбора
if ($field['type'] == 'select') {
$values = $group->getSelectValues($field['id']);
$field['myValues'] = $values;
}
if ($field['type'] == 'photoalbum') {
$base = new Model_Base();
$options = $base->getOptions();
$field['photos_base_path'] = $options['photos_base_path'];
}
if ($field['type'] == 'files') {
$base = new Model_Base();
$options = $base->getOptions();
$field['files_base_path'] = $options['files_base_path'];
}
$fieldset[] = View::factory('admin/fields/' . $field['type'])->bind('data', $field)->bind('folders', $folders)->bind('multiselect', $field['multiselect'])->bind('user', $this->user)->render();
}
$data['fieldset'] = $fieldset;
}
if (isset($_POST['new_material'])) {
//PC::debug($_POST);
//var_dump($_POST);
$res = $group->newMaterial($_POST, $gid, $_FILES);
if ($res) {
Controller::redirect('admin/materials/' . $gid);
} else {
$data['errors'] = $group->getErrors();
}
}
if (isset($_POST['save_selects'])) {
$selects = new Model_Params_Selects();
$values = $_POST;
unset($values['save_selects']);
$selects->saveSelectsValues($values, $_POST['save_selects']);
}
if (isset($_POST['save_param'])) {
$selects = new Model_Selects();
$values = $_POST;
unset($values['save_param']);
$selects->saveSelectsParam($values, $_POST['save_param'], $_FILES);
}
$wpm['status'] = Cookie::get('wpm', FALSE);
$wpm['folder'] = Cookie::get('wpm_folder', '');
$pictures = $this->action_pictures($wpm['folder']);
$this->template->content = View::factory('admin/admMaterials', array('data' => $data, 'folders' => $folders, 'pictures' => $pictures, 'wpm' => $wpm, 'user' => $this->user));
}
public function load_xls($files = NULL, $gid, $offset = 11, $limit = 20)
{
$material = new Model_Material('groups');
$base = new Model_Base();
$group = $material->getGroup($gid);
$insertdata = array();
$fieldset = $material->getFieldsSet($gid);
if (is_array($files)) {
if (isset($files) && count($files) > 0) {
$files_size = $files['xls_price']['size'];
} else {
$files_size = $_GET['files_size'];
}
if (isset($files) && count($files) > 0) {
$temp = $files['xls_price']['name'];
} else {
$temps = explode('_', $_GET['files_name']);
$temp = implode(' ', $temps);
}
$name_arr = explode('.', $temp);
$ext = array_pop($name_arr);
if (isset($files) && count($files) > 0) {
$tmp_name = $_FILES['xls_price']['tmp_name'];
} else {
$tmp_name = $_GET['files_tmp'];
}
} else {
$files_size = filesize($files);
$ext = pathinfo($files, PATHINFO_EXTENSION);
$loadedfilename = $files;
}
$create_categories = TRUE;
$load_data = TRUE;
if ($create_categories == TRUE) {
if ($files_size > 0 && ($ext == 'xls' || $ext == 'xlsx')) {
//echo $files['xls_price']['size'];
//get upload file
if (!isset($loadedfilename)) {
$uploadfile = $this->uploads_dir() . $temp;
} else {
$uploadfile = $loadedfilename;
$tmp_name = $loadedfilename;
}
//if lile moved
if (move_uploaded_file($tmp_name, $uploadfile) || isset($_GET['files_name']) || isset($loadedfilename)) {
//load file
$objPHPExcel = PHPExcel_IOFactory::load($uploadfile);
//foreach pages
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// например, 10
$highestColumn = $worksheet->getHighestColumn();
// например, 'F'
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$nrColumns = ord($highestColumn) - 64;
//получаем все поля для группы
//$fieldset = $material->getFieldsSet($gid);
//перебираем страницы файла
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
$fields_index = array();
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// например, 10
$highestColumn = $worksheet->getHighestColumn();
// например, 'F'
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$nrColumns = ord($highestColumn) - 64;
if ($highestRow > $limit) {
$highestRow = $offset + $limit;
}
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
for ($row = $offset; $row <= $highestRow; ++$row) {
$group_name = Arr::get($group, 'title_field', 'A') . $row;
$group_nameCell = $worksheet->getCell($group_name);
$insertdata[$row]['group_name'] = $group_nameCell->getValue();
$title = 'D' . $row;
$titleCell = $worksheet->getCell($title);
$insertdata[$row]['title'] = $titleCell->getValue();
$insertdata[$row]['url'] = Request::str2url($insertdata[$row]['title']);
$insertdata[$row]['description'] = $insertdata[$row]['title'];
$article = 'B' . $row;
$articleCell = $worksheet->getCell($article);
$insertdata[$row]['article'] = array($articleCell->getValue());
$count = 'P' . $row;
$countCell = $worksheet->getCell($count);
$insertdata[$row]['count'] = array($countCell->getValue());
$made_in = 'E' . $row;
$made_inCell = $worksheet->getCell($made_in);
$insertdata[$row]['madein'] = array($made_inCell->getValue());
$trademark = 'F' . $row;
$trademarkCell = $worksheet->getCell($trademark);
$insertdata[$row]['trademark'] = array($trademarkCell->getValue());
$photos = 'G' . $row;
$photosCell = $worksheet->getCell($photos)->getHyperlink()->getUrl();
$insertdata[$row]['photos'] = array($photosCell);
$price = 'S' . $row;
$priceCell = $worksheet->getCell($price);
$insertdata[$row]['price'] = $priceCell->getOldCalculatedValue();
}
}
}
}
// echo '<pre>';
// var_dump($insertdata);
// echo '</pre>';
$params = array(0 => array('type' => 'select', 'title' => 'Страна производителя', 'name' => 'madein', 'ordering' => '3'), 1 => array('type' => 'select', 'title' => 'Торговая марка', 'name' => 'trademark', 'ordering' => '4'), 2 => array('type' => 'photoalbum', 'title' => 'Фото', 'name' => 'photos', 'ordering' => '1'), 3 => array('type' => 'price', 'title' => 'Цена', 'name' => 'price', 'ordering' => '2'));
foreach ($insertdata as $id => $group) {
$names = Arr::get($group, 'group_name');
$groupnames = explode('\\', $names);
$parent = '602';
$groupnames = array_reverse($groupnames);
$i = 1;
foreach ($groupnames as $name) {
if ($name != '') {
$groups = new Model_Material('groups');
if ($parent) {
//проверяем наличие такой группы у родителя
$res = $groups->getGroupChildren($parent, $name);
if (!$res) {
//если нет создаем
//$newGroupId = $groups->groupInsert($parent, $parent, array('name' => $name));
//$parent = $newGroupId;
} else {
if ($load_data == TRUE) {
//загружаем данные в группу при условии, что это последняя группа
if ($i == count($groupnames)) {
// $fieldset = $material->getFieldsSet($res['id']);
$result = $material->unique_url($group['url'], $res['id']);
// foreach($fieldset as $field)
// {
// if(isset($group[$field['name']]))
// {
// $gname = $field['type'].'_'.$field['id'];
// $gvalue = $group[$field['name']];
// $group[$gname] = $gvalue;
// unset($group[$field['name']]);
// }
// }
//
// echo "<pre>";
// var_dump($group);
// echo "</pre>";
if ($result) {
$fieldset = $material->getFieldsSet($res['id']);
foreach ($fieldset as $field) {
if (isset($group[$field['name']])) {
$gname = $field['type'] . '_' . $field['id'];
$gvalue = $group[$field['name']];
$group[$gname] = $gvalue;
unset($group[$field['name']]);
}
}
unset($group['group_name']);
$result = $material->newMaterial($group, $res['id'], TRUE, TRUE);
}
// if(!$res)
// {
// $group['mid'] = $material->getMaterialIdByUrl($group['url'], $res['id']);
// if(isset($group['sleep']))
// unset($group['sleep']);
//
// $result = $material->saveMaterial($group, $res['id'], TRUE, TRUE);
// }
// else
// {
// $result = $material->newMaterial($group, $res['id'], TRUE, TRUE);
// }
}
}
$parent = $res['id'];
}
}
}
//создаем стандартный набор параметров
if ($i == count($groupnames)) {
foreach ($params as $param) {
$param['gid'] = $parent;
//получаем параметры группы
$groups->addParam($param);
}
}
++$i;
}
}
// if(is_array($insertdata))
// {
// foreach($insertdata as $item)
// {
// $id = $material->unique_url($item['url'], $gid);
// if(!$id)
// {
// $item['mid'] = $material->getMaterialIdByUrl($item['url'], $gid);
// if(isset($item['sleep']))
// unset($item['sleep']);
//
// $result = $material->saveMaterial($item, $gid, TRUE);
// }
// else
// {
// $result = $material->newMaterial($item, $gid, TRUE);
// }
// }
// }
}
} else {
echo '<div class="error_box">Не выбран файл или он неверного формата</div>';
}
} else {
if ($files_size > 0 && ($ext == 'xls' || $ext == 'xlsx')) {
//echo $files['xls_price']['size'];
//get upload file
$uploadfile = $this->uploads_dir() . $temp;
//if lile moved
if (move_uploaded_file($tmp_name, $uploadfile) || isset($_GET['files_name'])) {
//load file
$objPHPExcel = PHPExcel_IOFactory::load($uploadfile);
//foreach pages
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// например, 10
$highestColumn = $worksheet->getHighestColumn();
// например, 'F'
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$nrColumns = ord($highestColumn) - 64;
//получаем все поля для группы
$fieldset = $material->getFieldsSet($gid);
//перебираем страницы файла
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
$fields_index = array();
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// например, 10
$highestColumn = $worksheet->getHighestColumn();
// например, 'F'
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$nrColumns = ord($highestColumn) - 64;
foreach ($fieldset as $field) {
if ($worksheetTitle === $field['xls_page']) {
$fields_index[$field['xls_col']] = $field['type'] . '_' . $field['id'];
}
}
for ($row = Arr::get($group, 'first_row', 0); $row <= $highestRow; ++$row) {
//формируем заголовоки массива
$title = Arr::get($group, 'title_field', 'А') . $row;
$titleCell = $worksheet->getCell($title);
$desc = Arr::get($group, 'desc_field', 'А') . $row;
$descCell = $worksheet->getCell($desc);
$insertdata[$row]['title'] = Request::clearText($titleCell->getValue());
// $insertdata[$row]['title'] = $streetCell->getValue().' '.$houseCell->getValue().$korpus.$liter;
$insertdata[$row]['url'] = Request::str2url($insertdata[$row]['title']);
$insertdata[$row]['description'] = Request::clearText($descCell->getValue());
foreach ($fields_index as $key => $value) {
$cell = $worksheet->getCell($key . $row);
$ftype = explode('_', $value);
if (Arr::get($ftype, 0) == 'chars' || Arr::get($ftype, 0) == 'texts') {
$insertdata[$row][$value] = strval($cell->getValue());
} elseif (Arr::get($ftype, 0) == 'select' || Arr::get($ftype, 0) == 'date' || Arr::get($ftype, 0) == 'files' || Arr::get($ftype, 0) == 'photoalbum') {
$param = $material->getParam(Arr::get($ftype, 1));
if ($param && isset($param['delimetr']) && $param['delimetr'] != '') {
$arr = explode($param['delimetr'], strval($cell->getValue()));
$arr = array_map('trim', $arr);
$insertdata[$row][$value] = $arr;
} else {
$insertdata[$row][$value] = array(strval($cell->getValue()));
}
} elseif (Arr::get($ftype, 0) == 'price') {
$insertdata[$row][$value] = round($cell->getValue(), 2);
}
}
}
}
}
// echo '<pre>';
// var_dump($insertdata);
// echo '</pre>';
if (is_array($insertdata)) {
foreach ($insertdata as $item) {
$id = $material->unique_url($item['url'], $gid);
if (!$id) {
$item['mid'] = $material->getMaterialIdByUrl($item['url'], $gid);
if (isset($item['sleep'])) {
unset($item['sleep']);
}
$result = $material->saveMaterial($item, $gid, TRUE);
} else {
$result = $material->newMaterial($item, $gid, TRUE);
}
}
}
}
} else {
echo '<div class="error_box">Не выбран файл или он неверного формата</div>';
}
}
}
