Example #1
0
        ?>
" alt="<?php 
        echo $item['name'];
        ?>
">
                                        <?php 
    }
    ?>
                                    </a>
                                </div>
                            </div>
                            <div class="clearfix"></div>
                            <h2 class="text-center">
                                <a href="/zhenshchinam/<?php 
    if (isset($item['meh-shuby'][0])) {
        echo Request::str2url($item['meh-shuby'][0]['value']);
        ?>
/<?php 
    }
    echo $item['url'];
    ?>
.html">
                                    <?php 
    if (isset($item['meh-shuby'][0])) {
        ?>
                                        Шуба из <?php 
        echo Text::getSuffix(Arr::get($item['meh-shuby'][0], 'value'));
        ?>
                                    <?php 
    }
    ?>
Example #2
0
                            <div class="col-lg-12">
                                <?php 
            if (isset($item['meh-shuby'][0])) {
                ?>
                                    <a href="/shuby/<?php 
                echo Request::str2url($item['meh-shuby'][0]['value']);
                ?>
/<?php 
                echo $item['url'];
                ?>
.html">
                                <?php 
            } elseif (isset($item['type'][0])) {
                ?>
                                    <a href="/zhenshchinam/<?php 
                echo Request::str2url(Text::getSuffix($item['type'][0]['value']));
                ?>
/<?php 
                echo $item['url'];
                ?>
.html">
                                <?php 
            } else {
                ?>
                                    <a href="/<?php 
                echo Arr::get($item, 'node');
                ?>
/<?php 
                echo Arr::get($item, 'url');
                ?>
.html">
Example #3
0
                        <td>
                            Город
                        </td>
                        <td>
                            <?php 
    echo $fields['city'][0];
    ?>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            Жилой комплекс
                        </td>
                        <td>
                            <a target="_blank" href="/objects/<?php 
    echo Request::str2url($fields['object'][0]);
    ?>
.html"><?php 
    echo $fields['object'][0];
    ?>
 <sup title="откроется в новом окне"><span class="glyphicon glyphicon-new-window"></span></sup></a>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            Этаж
                        </td>
                        <td>
                            <?php 
    echo $fields['floor'];
    ?>
Example #4
0
 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++;
     }
 }
Example #5
0
                                    </li>
                                    <li>
                                        <div class="vz-icon vz-icon-1-bed" title="Одноместных кроватей"><div><?php 
        echo $item['double_beds'];
        ?>
</div></div>
                                    </li>
                                    <?php 
        foreach ($item['facilities'] as $item_facility) {
            ?>
                                        <li>
                                            <div title="<?php 
            echo $item_facility;
            ?>
" class="vz-big-icon vz-icon-<?php 
            echo Request::str2url($item_facility);
            ?>
"></div>
                                        </li>
                                    <?php 
        }
        ?>
                                </ul>
                            </div>
                            <div class="row">
                                <div class="vz-price col-sm-9">
                                    <div class="vz-price-weekend">
                                        <?php 
        echo $item['price'];
        ?>
 Р/сутки                    </div>
Example #6
0
        ?>
" alt="<?php 
        echo $item['name'];
        ?>
">
                                        <?php 
    }
    ?>
                                    </a>
                                </div>
                            </div>
                            <div class="clearfix"></div>
                            <h2 class="text-center">
                                <a href="/zhenshchinam/<?php 
    if (isset($item['type'][0])) {
        echo Request::str2url($item['type'][0]['value']);
        ?>
/<?php 
    }
    echo $item['url'];
    ?>
.html">
                                    <?php 
    if (isset($item['meh-shuby'][0])) {
        ?>
                                        Шуба из <?php 
        echo Text::getSuffix(Arr::get($item['meh-shuby'][0], 'value'));
        ?>
                                    <?php 
    }
    ?>
Example #7
0
 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>';
         }
     }
 }
Example #8
0
                        <div class="tab-pane fade in active" id="<?php 
            echo Request::str2url($file['title']);
            ?>
">
                            <p>
                                <iframe src="http://docs.google.com/viewer?url=<?php 
            echo Kohana::$base_url . $file['value'];
            ?>
&amp;embedded=true&amp;" height="780" style="border: none;" class="col-sm-12 col-xs-12"></iframe>
                            </p>
                        </div>
                    <?php 
        } else {
            ?>
                        <div class="tab-pane fade" id="<?php 
            echo Request::str2url($file['title']);
            ?>
">
                            <p>
                                <iframe src="http://docs.google.com/viewer?url=<?php 
            echo Kohana::$base_url . $file['value'];
            ?>
&amp;embedded=true&amp;" height="780" style="border: none;" class="col-sm-12 col-xs-12"></iframe>
                            </p>
                        </div>
                    <?php 
        }
        ?>

                <?php 
    }