| 1 |
<?php |
| 2 |
/** |
| 3 |
* @deprecated |
| 4 |
*/ |
| 5 |
|
| 6 |
/** |
| 7 |
* No direct access. |
| 8 |
*/ |
| 9 |
defined('ABSPATH') or die("Access denied"); |
| 10 |
|
| 11 |
// CJTTable class. |
| 12 |
require_once CJTOOLBOX_FRAMEWORK . '/db/mysql/table.inc.php'; |
| 13 |
|
| 14 |
/** |
| 15 |
* |
| 16 |
* @deprecated Use CJTBlockTable instead! |
| 17 |
*/ |
| 18 |
class CJTBlocksTable extends CJTTable { |
| 19 |
|
| 20 |
/** */ |
| 21 |
const BLOCK_META_BOX_ID_META_NAME = '__CJT-BLOCK-ID'; |
| 22 |
|
| 23 |
/** */ |
| 24 |
const BLOCK_META_BOX_STATUS_META_NAME = '__CJT-BLOCK-STATUS'; |
| 25 |
|
| 26 |
/** |
| 27 |
* put your comment there... |
| 28 |
* |
| 29 |
*/ |
| 30 |
public function __construct(&$dbDriver) { |
| 31 |
// Inirialize parent class. |
| 32 |
parent::__construct($dbDriver, cssJSToolbox::$config->database->tables->blocks); |
| 33 |
} |
| 34 |
|
| 35 |
/** |
| 36 |
* put your comment there... |
| 37 |
* |
| 38 |
* @param mixed $ids |
| 39 |
*/ |
| 40 |
public function delete($ids = array()) { |
| 41 |
$where = ''; |
| 42 |
if (!empty($ids)) { |
| 43 |
$where = ' WHERE `id` IN (' . implode(',', ((array) $ids)) . ')'; |
| 44 |
} |
| 45 |
$query = "DELETE FROM {$this->table}{$where};"; |
| 46 |
$this->dbDriver->delete($query); |
| 47 |
} |
| 48 |
|
| 49 |
/** |
| 50 |
* put your comment there... |
| 51 |
* |
| 52 |
* @param mixed $ids |
| 53 |
* @param mixed $fields |
| 54 |
* @param mixed $filters |
| 55 |
* @deprecated @param mixed $returnType |
| 56 |
* @param mixed $orderBy |
| 57 |
*/ |
| 58 |
public function get($ids = array(), $fields = array('*'), $filters = array(), $returnType = OBJECT_K, $orderBy = array(), $useDefaultBackupFltr = true) { |
| 59 |
// Warn if $returnTypes is used |
| 60 |
if ($returnType != OBJECT_K) { |
| 61 |
die('Warning! Using $returnType with value other than OBJECT_K from the caller!!!'); |
| 62 |
} |
| 63 |
$blocks = array(); |
| 64 |
$where = array(); |
| 65 |
// Query block ids. |
| 66 |
$ids = (array) $ids; // $ids may be single integer. |
| 67 |
if (!empty($ids)) { |
| 68 |
$ids = implode(',', $ids); |
| 69 |
$where[] = " `id` IN ({$ids})"; |
| 70 |
} |
| 71 |
// Filter by backup name. |
| 72 |
if ($useDefaultBackupFltr) { |
| 73 |
$where[] = (!isset($filters['backupId']) ? ' `backupId` IS NULL' : " `backupId` = {$filters['backupId']}"); |
| 74 |
unset($filters['backupId']); |
| 75 |
} |
| 76 |
// Filter by parent. |
| 77 |
if (isset($filters['parent'])) { |
| 78 |
$filters['parent'] = implode(',', ((array) $filters['parent'])); |
| 79 |
$where[] = " `parent` IN ({$filters['parent']})"; |
| 80 |
unset($filters['parent']); |
| 81 |
} |
| 82 |
// Types filter. |
| 83 |
if (isset($filters['types'])) { |
| 84 |
$types = '"' . implode('", "', $filters['types']) . '"'; |
| 85 |
$where[] = " `type` IN ({$types})"; |
| 86 |
unset($filters['types']); |
| 87 |
} |
| 88 |
// Do other filters as standard where opertions nothing specific here. |
| 89 |
$where = array_merge($where, $this->prepareQueryParameters($filters)); |
| 90 |
// Build where clause if there. |
| 91 |
if (!empty($where)) { |
| 92 |
$where = ' WHERE ' . implode(' AND ', $where); |
| 93 |
} |
| 94 |
// Order by Clause. |
| 95 |
$orderBy = empty($orderBy) ? '' : (" ORDER BY " . implode(',', $orderBy)); |
| 96 |
// Build fields list. |
| 97 |
$fields = implode(',', $fields); |
| 98 |
// Build full query. |
| 99 |
$query = "SELECT {$fields} FROM {$this->table}{$where}{$orderBy};"; |
| 100 |
$resultSet = $this->dbDriver->select($query, OBJECT); |
| 101 |
// Use block id as key. |
| 102 |
foreach($resultSet as $block) { |
| 103 |
$blocks[$block->id] = $block; |
| 104 |
} |
| 105 |
return $blocks; |
| 106 |
} |
| 107 |
|
| 108 |
/** |
| 109 |
* Override Parent::getNextId(). |
| 110 |
*/ |
| 111 |
public function getNextId($offset = 0) { |
| 112 |
// Get post meta table name. |
| 113 |
$postMetaTable = $this->dbDriver->getTableName('postmeta'); |
| 114 |
// Get all reserved blocks/metaboxes id associated with posts. |
| 115 |
$postMetaName = self::BLOCK_META_BOX_ID_META_NAME; |
| 116 |
$query = "SELECT meta_value as `value` |
| 117 |
FROM {$postMetaTable} |
| 118 |
WHERE meta_key = '{$postMetaName}';"; |
| 119 |
// Get all ids. |
| 120 |
$reservedIds = array_keys($this->dbDriver->select($query, OBJECT_K)); |
| 121 |
// Find a unique Id for the new block. |
| 122 |
do { |
| 123 |
// Increase by one until finding new unique id. |
| 124 |
$nextId = parent::getNextId($offset++); |
| 125 |
} while(in_array($nextId, $reservedIds)); |
| 126 |
// Return new id. |
| 127 |
return $nextId; |
| 128 |
} |
| 129 |
|
| 130 |
/** |
| 131 |
* put your comment there... |
| 132 |
* |
| 133 |
*/ |
| 134 |
public function insert($data) { |
| 135 |
// Prepare New Record data. |
| 136 |
$data = $this->prepareQueryParameters($data); |
| 137 |
$data = implode(',', $data); |
| 138 |
// Insert statement. |
| 139 |
$query = "INSERT INTO {$this->table} SET {$data};"; |
| 140 |
$this->dbDriver->insert($query); |
| 141 |
} |
| 142 |
|
| 143 |
/** |
| 144 |
* put your comment there... |
| 145 |
* |
| 146 |
* @param mixed $data |
| 147 |
*/ |
| 148 |
public function update($block) { |
| 149 |
// Get block id copy. |
| 150 |
$id = $block['id']; |
| 151 |
// Don't update id field. |
| 152 |
unset($block['id']); |
| 153 |
if (!empty($block)) { |
| 154 |
// Prepare New Record data. |
| 155 |
$block = $this->prepareQueryParameters($block); |
| 156 |
$block = implode(',', $block); |
| 157 |
// Insert statement. |
| 158 |
$query = "UPDATE {$this->table} SET {$block} WHERE `id` = {$id};"; |
| 159 |
$this->dbDriver->update($query); |
| 160 |
} |
| 161 |
return $this; |
| 162 |
} |
| 163 |
|
| 164 |
} // End class. |
