Files
Testing/include/class_page.php

186 lines
4.3 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?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
}