aboutsummaryrefslogtreecommitdiffstats
path: root/Controller.php
diff options
context:
space:
mode:
Diffstat (limited to 'Controller.php')
-rw-r--r--Controller.php415
1 files changed, 0 insertions, 415 deletions
diff --git a/Controller.php b/Controller.php
deleted file mode 100644
index 2534397..0000000
--- a/Controller.php
+++ /dev/null
@@ -1,415 +0,0 @@
-<?php
-
-/**
- * main/Controller.php
- * "VC" version of Beof
- * @TODO: transfer boeuf.php here
- */
-
-class Controller
-{
- public $view; // Where to store the data to be rendered
- public $pageTitle = ""; // Title of the rendered page
- public $defaultAction = ""; // Method to run when none specified
-
- const OrderBy = "";
- const HasMany = "";
- const TableName = "";
- const ManyToMany = "";
- const ForeignKey = "";
- const TableSelect = "";
-
- function __construct($id = null)
- {
- // Child classes should always have the same name as their tables
- $this->class = get_class($this);
- $this->table = eval("return {$this->class}::TableName;");
-
- $this->view = new MainView();
-
- // Table name not defined, default to class name
- if (!$this->table) {
- $this->table = strtolower($this->class);
- }
-
- $this->result = null;
-
- if ($id) {
- return $this->get($id);
- }
-
- return $this;
-
- }
-
- /**
- * Get One Thing
- */
- public function get($where)
- {
- if (!is_array($where)) {
- $where = array('id' => $where);
- }
-
- $this->find($where);
- return current($this->data);
-
- }
-
- public function db()
- {
- return Db::getInstance();
- }
-
- /**
- * The New Find
- */
- public function find($where = null, $sort = false, $limit = false)
- {
- $select = "*"; $q = "";
-
- // Allow custom queries
- if (is_array($where))
- {
- foreach ($where as $k => $v)
- {
- $values[] = $v;
- $args = explode(" ", $k);
- $col = array_shift($args);
- $op = implode(" ", $args);
-
- // No column name given, default to "id"
- if (empty($col)) {
- $col = "id";
- }
-
- // No operator given, default to "="
- if (empty($op)) {
- $op = "=";
- }
-
- $tmp = (empty($q)) ? ' WHERE ' : ' AND ';
- $q .= $tmp . "`{$col}`" . ' ' . $op . ' ?';
-
- }
- } else {
- $q = "WHERE `{$this->table}`.`id` = ?";
- $values = array($where);
- }
-
- if ($where == null) {
- $q = "WHERE ?";
- $values = array(1);
- }
-
-// $schema = App::conf('tables');
-// $this->schema = $schema[$this->table];
-
- // Ugly hack until PHP 5.3
- $i_sort = eval("return {$this->class}::OrderBy;");
- $i_fk = eval("return {$this->class}::ForeignKey;");
- $i_mtm = eval("return {$this->class}::ManyToMany;");
- $i_select = eval("return {$this->class}::TableSelect;");
-
-// $orderBy = ($sort) ? $sort :
-
- if ($sort) {
- list($col, $dir) = explode(' ', $sort);
- $sort = "ORDER BY `{$this->table}`.`$col` $dir";
- }
-
- if (!$sort && $i_sort) {
- $sort = "ORDER BY `{$this->table}`.{$i_sort}";
- }
-
- if ($i_select) {
- list($select_col, $args) = explode(",", $i_select);
- $select .= ", $args AS `{$select_col}`";
- }
-
- $sql = "SELECT $select FROM `{$this->table}` $q $sort";
-
- if ($limit) {
- $sql .= " LIMIT $limit";
- }
-
- $result = Db::fetch($sql, $values);
-
- if (empty($result)) {
- $this->data = false;
- return;
- }
-
- for ($i=0; $i < count($result); $i++)
- {
- $row = $result[$i];
- $this->data[$i] = $row;
- $this->find_parent($row, $i);
-// $this->find_children($row, $i);
- }
-
- return $this;
-
- }
-
- /**
- * Find all child rows for this row
- * @return void
- */
- private function find_children($row, $i)
- {
- $id = $row['id']; // ID of the parent
- $fk = explode(",", eval("return $this->class::HasMany;"));
-
- if (empty($fk[0])) {
- return false;
- }
-
- foreach ($fk as $child)
- {
- $sql = "SELECT * FROM `$child` WHERE `{$this->table}_id` = ?";
-
- $ref_schema = App::conf('tables');
- $ref_schema = $ref_schema[$child];
-
- if (@in_array($this->table, $ref_schema['belongsToMany'])) // m/n
- {
- $sql = "SELECT `{$child}`.*, `{$child}_{$this->table}`.*,
- `{$child}_{$this->table}`.id AS {$child}_{$this->table}_id,
- `{$child}`.*
- FROM `{$child}_{$this->table}`, `{$this->table}`, `$child`
- WHERE `{$child}_{$this->table}`.`{$this->table}_id` = `$this->table`.id AND
- `{$child}_{$this->table}`.`{$child}_id` = `$child`.id AND
- `{$this->table}`.id = ?
- ORDER BY `{$child}`.{$ref_schema['orderBy']}";
- } else if (@in_array ($table, $ref_schema['belongsTo'])) { // 1/m
- $sql = "SELECT * FROM `$ref` WHERE `$ref`.`{$table}_id` = ?";
- }
-
- $stmt = DB::query($sql, array($id));
- $this->data[$i][$child] = $stmt->fetchAll(PDO::FETCH_ASSOC);
-
- }
- }
-
- /**
- * Find all rows for this row
- */
- private function find_parent($row, $i)
- {
- $select = "*";
- $fk = explode(",", eval("return {$this->class}::ForeignKey;"));
-
- // No parents defined
- if (empty($fk[0])) {
- return false;
- }
-
- foreach ($fk as $parent)
- {
- $fkey = 'id';
- $lkey = "{$parent}_id";
- /*
- if ($this->schema['foreignKey'][$parent])
- {
- list($lkey, $fkey) = explode("|", $this->schema['foreignKey'][$parent]);
- }
- */
- $parent_id = $row[$lkey];
-
-// $ref_schema = App::conf('tables');
-// $ref_schema = $ref_schema[$parent];
- $ref_schema = $fk[''];
-
- if ($ref_schema['select'])
- {
- foreach ($ref_schema['select'] as $a => $b)
- {
- $select .= ", $b AS `{$a}`";
- }
- }
-
- $sql = "SELECT $select FROM `{$parent}` WHERE `{$fkey}` = ?";
-
- $stmt = DB::query($sql, array($parent_id));
- $this->data[$i][$parent] = $stmt->fetchAll(PDO::FETCH_ASSOC);
-
- }
-
- }
-
- private function find_parents()
- {
-
- }
-
- /**
- * Insert this thing in the DB and return inserted
- * Thing
- */
- public function insert($data)
- {
- if (empty($data)) {
- return App::error('Cannot insert emptiness');
- }
-
- $insert = '';
- $values = array();
-
- foreach($data as $k => $v)
- {
- $insert .= "`{$k}`, ";
- $values[":{$k}"] = $v;
- }
-
- $insert = rtrim($insert, ', ');
- $val = implode(', ', array_keys($values));
- $sql = "INSERT INTO `{$this->table}` ({$insert}) VALUES ({$val})";
-
- return DB::query($sql, $values);
-
- }
-
- /**
- * Delete This Thing
- */
- protected function delete($where, $limit = '')
- {
- if (empty($where)) {
- return App::error('Cannot delete without arguments');
- }
-
- list($key, $value) = each($where);
-
- if ($limit) {
- $limit = " LIMIT $limit";
- }
-
- $data = array(":{$key}" => $value);
- $sql = "DELETE FROM `{$this->table}` WHERE `{$key}` = :{$key} $limit";
-
- return Db::query($sql, $data);
-
- }
-
- /**
- * Update this Thing
- * We keep this in the Controller since it might know
- * more about the topmost class
- */
- protected function update($data, $where = null)
- {
- if (!is_array($data)) {
- return App::error('Cannot update without parameters');
- }
-
- if (empty($where)) {
- $where = array('id' => 'id');
- }
-
- $query = ""; $values = array();
- list($col, $val) = each($where);
-
- if (!isset($data[$col])) {
- $data = array_merge($data, $where);
- }
-
- foreach ($data as $k => $v) {
- $query .= "`$k` = :$k, ";
- $values[":{$k}"] = $v;
- }
-
- $query = rtrim($query, ", ");
- $sql = "UPDATE `{$this->table}` SET $query WHERE `$col` = :$col";
-
- return Db::query($sql, $values);
-
- }
-
- /**
- * Render a view
- */
- public function render($data = null, $view = null)
- {
- // Default to the same view as the method
- if (!$view) {
- $bt = debug_backtrace();
- $view = $bt[1]['function'];
- }
-
- if (!$view) {
- $view = $this->defaultAction;
- }
-
- if (!$data) {
- $data = $this->view;
- }
-
- $type = App::type();
- // @very temporary hack?
- $tpl = (App::url(0) == "admin") ? "admin" : "default";
- $template = "../system/views/{$tpl}.{$type}";
- $file = "../system/views/{$this->table}/{$view}.{$type}";
-
- if (!is_file($file)) {
- return App::error("{$this->table}_{$view}_{$type}: no such view");
- }
-
- if ($data) {
- foreach ($data as $k => $v) {
- $$k = $v;
- }
- }
-
- // Capture view
- ob_start();
- include $file;
- $view_contents = ob_get_contents();
- ob_end_clean();
-
- // Capture template
- ob_start();
- include $template;
- $tpl_contents = ob_get_contents();
- ob_end_clean();
-
- $title = ($this->pageTitle) ? $this->pageTitle : App::conf("defaults.title");
- $tpl_contents = preg_replace(
- '/<title>.*?<\/title>/', "<title>{$title}</title>", $tpl_contents
- );
-
- echo str_replace('%%page_content%%', $view_contents, $tpl_contents);
-
- }
-
- public function match($cols, $match)
- {
- foreach ($cols as $col) {
- $sql .= "`{$col}`,";
- }
-
- $sql = rtrim($sql, ",");
- $sql = "SELECT * FROM `{$this->table}` WHERE MATCH($sql) AGAINST('{$match}')";
-
- return App::db()->query($sql);
-
- }
-
- /**
- * Insert or update
- */
- public function upsert($data, $where = null)
- {
- if(!$this->get($where)) {
- $out = $this->insert($data);
- } else {
- $out = $this->update($data, $where);
- }
-// App::log($out);
- return $out;
-
- }
-
-}
-
-?>
generated by cgit v1.2.3 (git 2.25.1) at 2024-11-25 01:19:36 +0000