186 lines
4.3 KiB
PHP
186 lines
4.3 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
include_once "class_radcodes.php";
|
||
|
|
|
||
|
|
class rc_page extends rc_model
|
||
|
|
{
|
||
|
|
var $table = 'se_pages';
|
||
|
|
var $pk = 'page_id';
|
||
|
|
var $_join_query = "LEFT JOIN se_pagecats ON page_pagecat_id = pagecat_id";
|
||
|
|
|
||
|
|
function get_records($criteria=null,$key=false)
|
||
|
|
{
|
||
|
|
// date_default_timezone_set('America/Phoenix');
|
||
|
|
$rows = array();
|
||
|
|
$index = 0;
|
||
|
|
$res = $this->db->database_query($this->_build_get_records_query($criteria));
|
||
|
|
while($row = $this->db->database_fetch_assoc($res)) {
|
||
|
|
$row['page_updated_ts'] = strtotime($row['page_updated_at']);
|
||
|
|
|
||
|
|
$row['page_content_body'] = nl2br($row['page_desc']);
|
||
|
|
|
||
|
|
if ($key) {
|
||
|
|
$rows[$row[$this->pk]] = $row;
|
||
|
|
}
|
||
|
|
else {
|
||
|
|
$rows[$index++] = $row;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
return $rows;
|
||
|
|
}
|
||
|
|
|
||
|
|
function clean_data($data) {
|
||
|
|
$keys = array('page_id','page_name','page_key','page_type','page_status','page_content','page_updated_at','page_script','page_levels','page_pagecat_id','page_desc',
|
||
|
|
'page_subnets','page_include_header','page_include_footer'
|
||
|
|
);
|
||
|
|
foreach ($data as $k=>$v) {
|
||
|
|
if (!in_array($k, $keys)) {
|
||
|
|
unset($data[$k]);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
return $data;
|
||
|
|
}
|
||
|
|
|
||
|
|
function insert($data)
|
||
|
|
{
|
||
|
|
if (!$data['page_key']) {
|
||
|
|
$data['page_key'] = rc_toolkit::strip_text($data['page_name']);
|
||
|
|
}
|
||
|
|
$data['page_updated_at'] = rc_toolkit::db_to_datetime();
|
||
|
|
$data = $this->clean_data($data);
|
||
|
|
return parent::insert($data);
|
||
|
|
}
|
||
|
|
|
||
|
|
function update($id, $data)
|
||
|
|
{
|
||
|
|
$data['page_updated_at'] = rc_toolkit::db_to_datetime();
|
||
|
|
|
||
|
|
$data = $this->clean_data($data);
|
||
|
|
|
||
|
|
return parent::update($id, $data);
|
||
|
|
}
|
||
|
|
|
||
|
|
function get_page_by_key($key)
|
||
|
|
{
|
||
|
|
return $this->get_record_by_criteria("page_key = '$key'");
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
function clear_quick_pages_cache() {
|
||
|
|
if (class_exists('SESession')) {
|
||
|
|
$session_object =& SESession::getInstance();
|
||
|
|
$session_object->clear('rc_page_menu_pages');
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
function get_quick_pages() {
|
||
|
|
|
||
|
|
if (class_exists('SESession')) {
|
||
|
|
$session_object =& SESession::getInstance();
|
||
|
|
$items = $session_object->get('rc_page_menu_pages');
|
||
|
|
}
|
||
|
|
|
||
|
|
if ($items === null) {
|
||
|
|
$items = array();
|
||
|
|
$query = "SELECT page_id, page_name, page_key FROM se_pages ORDER BY page_name ASC";
|
||
|
|
//rc_toolkit::debug($query,"sql");
|
||
|
|
$res = $this->db->database_query($query);
|
||
|
|
while ($r = $this->db->database_fetch_assoc($res)) {
|
||
|
|
$items[$r['page_id']] = $r;
|
||
|
|
}
|
||
|
|
if ($session_object) {
|
||
|
|
$session_object->set('rc_page_menu_pages', $items);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
//rc_toolkit::debug($items);
|
||
|
|
return $items;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
function get_menu_pages($pids) {
|
||
|
|
global $setting;
|
||
|
|
static $items;
|
||
|
|
|
||
|
|
$items = $this->get_quick_pages();
|
||
|
|
|
||
|
|
$pages = array();
|
||
|
|
|
||
|
|
if (!is_array($pids)) {
|
||
|
|
$pids = explode(",", str_replace(" ","",$pids));
|
||
|
|
}
|
||
|
|
|
||
|
|
foreach ($pids as $pid) {
|
||
|
|
$pages[$pid] = $items[$pid];
|
||
|
|
}
|
||
|
|
|
||
|
|
return $pages;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
function get_usermenu_items()
|
||
|
|
{
|
||
|
|
global $setting;
|
||
|
|
return $this->get_menu_pages($setting['setting_page_usermenu_ids']);
|
||
|
|
}
|
||
|
|
|
||
|
|
function get_topmenu_items()
|
||
|
|
{
|
||
|
|
global $setting;
|
||
|
|
return $this->get_menu_pages($setting['setting_page_topmenu_ids']);
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
function get_bottommenu_items()
|
||
|
|
{
|
||
|
|
global $setting;
|
||
|
|
return $this->get_menu_pages($setting['setting_page_bottommenu_ids']);
|
||
|
|
}
|
||
|
|
|
||
|
|
function page_categories()
|
||
|
|
{
|
||
|
|
static $cats;
|
||
|
|
|
||
|
|
if ($cats === null) {
|
||
|
|
$field = new se_field("page");
|
||
|
|
$field->cat_list();
|
||
|
|
$cats = $field->cats;
|
||
|
|
}
|
||
|
|
return $cats;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
function page_cat_languages()
|
||
|
|
{
|
||
|
|
global $database;
|
||
|
|
static $cats;
|
||
|
|
|
||
|
|
if (!is_array($cats)) {
|
||
|
|
|
||
|
|
$cs = $this->page_categories();
|
||
|
|
|
||
|
|
//rc_toolkit::debug($cs,'cs');
|
||
|
|
|
||
|
|
foreach ($cs as $c) {
|
||
|
|
$cats[$c['cat_id']] = $c['cat_title'];
|
||
|
|
foreach ($c['subcats'] as $s) {
|
||
|
|
$cats[$s['subcat_id']] = $s['subcat_title'];
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
//rc_toolkit::debug($cats,'cats');
|
||
|
|
|
||
|
|
foreach ($cats as $id => $title) {
|
||
|
|
SELanguage::_preload($title);
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
return $cats;
|
||
|
|
}
|
||
|
|
// page_cat_languages
|
||
|
|
|
||
|
|
|
||
|
|
}
|