You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
463 lines
14 KiB
463 lines
14 KiB
<?php |
|
|
|
class Faster { |
|
|
|
const VERSION = '0.5'; |
|
|
|
public $tdir = NULL; |
|
private $session = NULL; |
|
|
|
/** |
|
* @var AVE_DB |
|
*/ |
|
public $db = FALSE; |
|
|
|
/** |
|
* @var AVE_Template |
|
*/ |
|
public $template = FALSE; |
|
protected $datadir = 'data'; |
|
|
|
public function __construct($tpl_dir) { |
|
|
|
global $AVE_DB, $AVE_Template; |
|
$this->db = $AVE_DB; |
|
$this->template = $AVE_Template; |
|
$this->tdir = $tpl_dir; |
|
$this->datadir = BASE_DIR . '/modules/faster/' . $this->datadir . '/'; |
|
$this->session = $this->template->get_template_vars('sess'); |
|
} |
|
|
|
/* -------------- |
|
Actions |
|
---------------- */ |
|
/* |
|
* Стартовая страница |
|
*/ |
|
|
|
public function show_import() { |
|
|
|
$d['files'] = $this->get_data_files(); |
|
|
|
$d['rubrics'] = $this->get_rubrics(); |
|
|
|
$d['sysblocks'] = $this->get_sys_blocks(); |
|
|
|
$this->template->assign('content', $this->view('import', $d)); |
|
} |
|
|
|
public function ajax_rub_delete() { |
|
|
|
/* $this->is_ajax() OR exit('no ajax'); |
|
!empty($_POST['file']) OR exit('post empty'); |
|
file_exists($this->datadir.$_POST['file'].'.php') OR exit('file not found'); */ |
|
|
|
if ($this->is_ajax() AND !empty($_POST['file']) AND file_exists($this->datadir . $_POST['file'] . '.php')) { |
|
|
|
if (unlink($this->datadir . $_POST['file'] . '.php')) |
|
$this->send_json(array('type' => 'success', 'message' => 'Файл конфигурации удален')); |
|
else |
|
$this->send_json(array('type' => 'error', 'message' => 'Файл найден но не может быть удален.')); |
|
} |
|
else |
|
$this->send_json(array('type' => 'error', 'message' => 'Файл не найден или не получен параметр.')); |
|
} |
|
|
|
public function ajax_rub_export() { |
|
|
|
if (!empty($_POST['rubs']) AND is_array($_POST['rubs'])) { |
|
|
|
$c = 0; |
|
foreach ($_POST['rubs'] as $id) { |
|
|
|
if ($this->export_rubric($id)) |
|
$c++; |
|
} |
|
} |
|
|
|
if ($this->is_ajax()) |
|
return $this->send_json(array('type' => 'success', 'message' => 'Экспортировано: ' . $c)); |
|
|
|
header('Location: ' . $this->uri('1', TRUE)); |
|
} |
|
|
|
public function ajax_rub_import() { |
|
|
|
$req = (empty($_POST['with_req'])) ? FALSE : TRUE; |
|
|
|
if (!empty($_POST['files']) AND is_array($_POST['files'])) { |
|
$c = 0; |
|
foreach($_POST['files'] as $file){ |
|
|
|
if($this->import_rubric($file, $req)) $c++; |
|
} |
|
header('Location: ' . $this->uri('1', TRUE)); |
|
} |
|
|
|
if($this->is_ajax() AND !empty($_POST['filenames'])){ |
|
//$this->send_json(array('type' => 'success', 'message' => var_export($_POST['filenames'][0]['value'], TRUE))); |
|
$c = 0; |
|
foreach($_POST['filenames'] as $file){ |
|
|
|
if($this->import_rubric($file['value'], $req)) $c++; |
|
} |
|
return $this->send_json(array('type' => 'success', 'message' => 'Импортировано: ' . $c)); |
|
} |
|
|
|
return $this->send_json(array('type' => 'error', 'message' => 'Выберите рубрики для импорта в систему')); |
|
} |
|
|
|
public function ajax_sys_import() { |
|
|
|
if(!empty($_POST['sys_blocks']) AND $this->is_ajax()){ |
|
|
|
$c = 0; |
|
foreach($_POST['sys_blocks'] as $file){ |
|
|
|
if($this->import_sysblock($file['value'])) $c++; |
|
} |
|
return $this->send_json(array('type' => 'success', 'message' => 'Импортировано: ' . $c)); |
|
} |
|
|
|
return $this->send_json(array('type' => 'error', 'message' => 'Выберите системные блоки для импорта в систему')); |
|
} |
|
|
|
/* ---------------- |
|
Methods |
|
------------------ */ |
|
|
|
/** |
|
* Экспортируем рубрику+поля рубрики+запросы |
|
* (пока без условий в запросах) |
|
* @param type $rub_id |
|
* @param type $filename |
|
* @return boolean |
|
*/ |
|
public function export_rubric($rub_id) { |
|
|
|
$rub_id = (int) $rub_id; |
|
$file['r_self'] = $this->db->Query('SELECT |
|
rubric_title, |
|
rubric_alias, |
|
rubric_template, |
|
rubric_template_id, |
|
rubric_author_id, |
|
rubric_created, |
|
rubric_docs_active, |
|
rubric_code_start, |
|
rubric_code_end, |
|
rubric_teaser_template, |
|
rubric_admin_teaser_template, |
|
rubric_header_template, |
|
rubric_linked_rubric, |
|
rubric_description, |
|
rubric_position |
|
FROM ' . PREFIX . '_rubrics WHERE Id = ' . $rub_id)->FetchAssocArray(); |
|
|
|
if (!empty($file['r_self'])) { |
|
|
|
$file['rub_export_id'] = $rub_id; |
|
$file['title'] = $file['r_self']['rubric_title']; |
|
$file['desc'] = $file['r_self']['rubric_description']; |
|
|
|
$file['r_fields'] = $this->query('SELECT |
|
Id as old_id, |
|
rubric_field_alias, |
|
rubric_field_template, |
|
rubric_field_template_request, |
|
rubric_field_title, |
|
rubric_field_type, |
|
rubric_field_position, |
|
rubric_field_default |
|
FROM ' . PREFIX . '_rubric_fields WHERE rubric_id = ' . $rub_id); |
|
|
|
$file['r_requests'] = $this->query('SELECT |
|
request_items_per_page, |
|
request_title, |
|
request_template_item, |
|
request_template_main, |
|
request_order_by, |
|
request_order_by_nat, |
|
request_author_id, |
|
request_created, |
|
request_description, |
|
request_asc_desc, |
|
request_show_pagination, |
|
request_where_cond, |
|
request_cache_lifetime, |
|
request_lang |
|
FROM ' . PREFIX . '_request WHERE rubric_id = ' . $rub_id); |
|
|
|
$filename = md5(serialize($file['r_fields']).$rub_id); //имя файла по набору полей |
|
//var_export($file); |
|
return file_put_contents($this->datadir . $filename . '.php', serialize($file)); |
|
} |
|
|
|
return FALSE; |
|
} |
|
|
|
/** |
|
* Импортируем рубрику из указанного файла (без расширения) |
|
* @param type $filename |
|
* @return boolean |
|
*/ |
|
public function import_rubric($filename, $req_import = TRUE) { |
|
|
|
$file = $this->datadir . $filename . '.php'; |
|
|
|
if (file_exists($file)) { |
|
|
|
$file = file_get_contents($file); |
|
$file = @unserialize($file); |
|
|
|
//array |
|
if (!empty($file['r_self']) ) { |
|
|
|
$file['r_self'] = $this->text_fields($file['r_self'], array( |
|
'rubric_title', |
|
'rubric_alias', |
|
'rubric_template', |
|
'rubric_code_start', |
|
'rubric_code_end', |
|
'rubric_teaser_template', |
|
'rubric_admin_teaser_template', |
|
'rubric_header_template', |
|
'rubric_linked_rubric', |
|
'rubric_description' |
|
)); |
|
$fields = implode(',', array_keys($file['r_self'])); |
|
$values = implode(',', array_values($file['r_self'])); |
|
// импортируем рубрику |
|
$this->db->Query('INSERT INTO ' . PREFIX . '_rubrics (' . $fields . ') VALUES (' . $values . ')'); |
|
$new_id = $this->db->InsertId(); |
|
|
|
// импортируем поля, запоминаем связи старых и новых |
|
$fields = ''; |
|
if (count($file['r_fields']) AND !empty($file['r_fields'][0]) AND is_array($file['r_fields'][0])) { |
|
|
|
$replace = array(); |
|
foreach ($file['r_fields'] as &$frow) { |
|
$frow = $this->text_fields($frow, array( |
|
'rubric_field_alias', |
|
'rubric_field_title', |
|
'rubric_field_type', |
|
'rubric_field_default', |
|
'rubric_field_template', |
|
'rubric_field_template_request' |
|
)); |
|
$frow['rubric_id'] = $new_id; //new rubric id |
|
$old_id = $frow['old_id']; unset($frow['old_id']); |
|
$fields = implode(',', array_keys($frow)); // из за лишнего старого old_id |
|
$values = '(' . implode(',', array_values($frow)) . ')'; |
|
$this->db->Query('INSERT INTO ' . PREFIX . '_rubric_fields (' . $fields . ') VALUES ' .$values); |
|
$f_id = $this->db->InsertId(); |
|
$replace['tag:fld:'.$old_id] = 'tag:fld:'.$f_id; // для шаблона рубрики |
|
$replace['tag:rfld:'.$old_id] = 'tag:rfld:'.$f_id; // для шаблонов запросов |
|
} |
|
// переписываем шаблон рубрики с новыми полями |
|
if(count($replace)) $template = str_replace(array_keys($replace), array_values($replace), $file['r_self']['rubric_template']); |
|
|
|
$this->db->Query('UPDATE '.PREFIX.'_rubrics SET rubric_template = '.$template.' WHERE Id = '.$new_id.' LIMIT 1'); |
|
} |
|
|
|
// импортируем запросы. переписываем поля в шаблонах |
|
$fields = ''; |
|
if (count($file['r_requests']) AND !empty($file['r_requests'][0]) AND is_array($file['r_requests'][0]) AND $req_import === TRUE) { |
|
|
|
$values = array(); |
|
foreach ($file['r_requests'] as &$rrow) { |
|
$rrow = $this->text_fields($rrow, array( |
|
'request_title', |
|
'request_template_item', |
|
'request_template_main', |
|
'request_order_by', |
|
'request_description', |
|
'request_asc_desc', |
|
'request_show_pagination', |
|
'request_where_cond', |
|
'request_lang' |
|
)); |
|
$rrow['rubric_id'] = $new_id; //new rubric id |
|
if(count($replace)) $rrow['request_template_item'] = str_replace(array_keys($replace), array_values($replace), $rrow['request_template_item']); |
|
$values[] = '(' . implode(',', array_values($rrow)) . ')'; |
|
} |
|
$fields = implode(',', array_keys($file['r_requests'][0])); |
|
$this->db->Query('INSERT INTO ' . PREFIX . '_request (' . $fields . ') VALUES ' . implode(',', $values)); |
|
} |
|
|
|
if ($new_id) |
|
return TRUE; |
|
} |
|
|
|
return FALSE; |
|
} |
|
|
|
return FALSE; |
|
} |
|
|
|
public function import_sysblock($filename) { |
|
|
|
$filename = $this->datadir.'sysblocks/'.$filename.'.php'; |
|
|
|
if(file_exists($filename)){ |
|
|
|
$filename = (array) require_once $filename; |
|
|
|
if(!empty($filename['db_name']) AND !empty($filename['db_text'])){ |
|
$values = array($filename['db_name'], $filename['db_text'], time()); |
|
$values = $this->text_fields($values, array(0,1)); |
|
|
|
$this->db->Query('INSERT INTO '.PREFIX.'_sysblocks (sysblock_name, sysblock_text, sysblock_created) VALUES ('.implode(',', $values).')'); |
|
return TRUE; |
|
|
|
} else return $this->send_json(array('type' => 'error', 'message' => 'Обнаружены пустые данные в системном блоке!')); |
|
} else return $this->send_json(array('type' => 'error', 'message' => 'Удален файл из списка. Обновите страницу!')); |
|
|
|
return FALSE; |
|
} |
|
|
|
/* |
|
* Получаем данные по рубрикам (рубрика + колво полей + колво запросов) |
|
*/ |
|
|
|
public function get_rubrics() { |
|
|
|
$rubric_fields = $this->query('SELECT ' . PREFIX . '_rubrics.Id as rub_id, rubric_title, rubric_alias, rubric_description, COUNT(rubric_id) as count_fields |
|
FROM ' . PREFIX . '_rubrics |
|
JOIN ' . PREFIX . '_rubric_fields ON ' . PREFIX . '_rubrics.Id = ' . PREFIX . '_rubric_fields.rubric_id |
|
GROUP BY rubric_id |
|
'); |
|
$count_req = $this->query('SELECT rubric_id, COUNT(Id) as count_req FROM ' . PREFIX . '_request GROUP BY rubric_id'); |
|
$result = array(); |
|
foreach ($rubric_fields as &$row) { |
|
if (empty($row['rubric_description'])) |
|
$row['rubric_description'] = '#Нет описания#'; |
|
$result[$row['rub_id']] = $row; |
|
$result[$row['rub_id']]['count_req'] = 0; |
|
} |
|
foreach ($count_req as $row) { |
|
if (isset($result[$row['rubric_id']])) |
|
$result[$row['rubric_id']]['count_req'] = $row['count_req']; |
|
} |
|
|
|
return $result; |
|
} |
|
|
|
/* |
|
* Получаем данные из файлов и формируем массив для вывода |
|
*/ |
|
|
|
public function get_data_files() { |
|
|
|
$files = array(); |
|
$id = 1; |
|
foreach (glob($this->datadir . '/*.php') as $file) { |
|
|
|
$f = file_get_contents($file); |
|
$f = @unserialize($f); |
|
$nfile = str_replace('.php', '', basename($file)); |
|
$files[$nfile] = array( |
|
'id' => $id++, |
|
'filename' => $nfile, |
|
'title' => $f['title'], |
|
'desc' => $f['desc'], |
|
'path' => $file |
|
); |
|
} |
|
|
|
return $files; |
|
} |
|
|
|
public function get_sys_blocks() { |
|
|
|
$files = array(); |
|
foreach(glob($this->datadir . 'sysblocks/sb_*.php') as $file){ |
|
|
|
$nfile = str_replace('.php', '', basename($file)); |
|
$files[$nfile] = (array) require_once $file; |
|
} |
|
|
|
return $files; |
|
} |
|
|
|
/* |
|
* Собираем УРЛ |
|
*/ |
|
|
|
public function uri($modact = FALSE, $inside = FALSE) { |
|
|
|
$build_with[] = 'do=modules'; |
|
if ($inside === TRUE) { |
|
$build_with[] = 'action=modedit'; |
|
$build_with[] = 'mod=faster'; |
|
} |
|
if ($modact) |
|
$build_with[] = 'moduleaction=' . $modact; |
|
$build_with[] = 'cp=' . $this->session; |
|
|
|
return '/admin/index.php?' . implode('&', $build_with); |
|
} |
|
|
|
/* Ассоциативный массив записей */ |
|
|
|
private function query($query) { |
|
|
|
$q = $this->db->Query($query); |
|
|
|
$result = array(); |
|
while ($row = $q->FetchAssocArray()) { |
|
|
|
$result[] = $row; |
|
} |
|
|
|
unset($q); |
|
return $result; |
|
} |
|
|
|
/* Отображение из папки templates (без шаблонизатора) */ |
|
|
|
private function view($name, $data = array()) { |
|
|
|
if (!empty($data) AND is_array($data)) |
|
extract($data); |
|
|
|
ob_start(); |
|
require $this->tdir . $name . '.php'; |
|
$view = ob_get_clean(); |
|
|
|
return $view; |
|
} |
|
|
|
/* Чтобы собрать запрос по ассоциативному массиву через функцию implode |
|
* нужно обернуть текстовые поля в кавычки и поставить слэши, иначе error |
|
* Особенно полезна для полей с PHP кодом |
|
*/ |
|
private function text_fields($cur_row, $tfields = array()) { |
|
|
|
$cur_row = (array) $cur_row; |
|
foreach ($cur_row as $f => &$v) { |
|
|
|
if (in_array($f, $tfields)) |
|
$v = "'" . addslashes($v) . "'"; |
|
} |
|
|
|
return $cur_row; |
|
} |
|
|
|
// проверяем что к нам пришел АЯКС запрос |
|
public function is_ajax() { |
|
|
|
return isset($_SERVER['HTTP_X_REQUESTED_WITH']) AND |
|
strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) === 'xmlhttprequest'; |
|
} |
|
|
|
// отправляем формат json |
|
public function send_json($data) { |
|
|
|
header('Content-Type: application/json'); |
|
exit(json_encode($data)); |
|
} |
|
|
|
} |
|
|
|
?>
|