johannaand / CHTMLTable

src/DatabaseModel/CDatabaseModel.php

Indentation +174 added lines, -174 removed lines

@@ -10,71 +10,71 @@ 
 {
     use \Anax\DI\TInjectable;
  
-  public $id;
+    public $id;
     
     
-   /**
-   * Get the table name.
-   *
-   * @return string with the table name.
-   */
-  public function getSource()
-  {
-      return strtolower(implode('', array_slice(explode('\\', get_class($this)), -1)));
-  }  
+    /**
+     * Get the table name.
+     *
+     * @return string with the table name.
+     */
+    public function getSource()
+    {
+        return strtolower(implode('', array_slice(explode('\\', get_class($this)), -1)));
+    }  
   
-  /**
-   * Find and return all.
-   *
-   * @return array
-   */
-  public function findAll()
-  {
-      $this->db->select()
-               ->from($this->getSource());
+    /**
+     * Find and return all.
+     *
+     * @return array
+     */
+    public function findAll()
+    {
+        $this->db->select()
+                ->from($this->getSource());
    
-      $this->db->execute();
-      $this->db->setFetchModeClass(__CLASS__);
-      return $this->db->fetchAll();
-  }
+        $this->db->execute();
+        $this->db->setFetchModeClass(__CLASS__);
+        return $this->db->fetchAll();
+    }
   
-  /**
-   * Get object properties.
-   *
-   * @return array with object properties.
-   */
-  public function getProperties()
-  {
-      $properties = get_object_vars($this);
-      unset($properties['di']);
-      unset($properties['db']);
+    /**
+     * Get object properties.
+     *
+     * @return array with object properties.
+     */
+    public function getProperties()
+    {
+        $properties = get_object_vars($this);
+        unset($properties['di']);
+        unset($properties['db']);
    
-      return $properties;
-  }
+        return $properties;
+    }
   
   
-  /**
-   * Find and return specific.
-   *
-   * @return this
-   */
-  public function find($id)
-  {
+    /**
+     * Find and return specific.
+     *
+     * @return this
+     */
+    public function find($id)
+    {
     $this->db->select()
-             ->from($this->getSource())
-             ->where("id = ?");
+                ->from($this->getSource())
+                ->where("id = ?");
  
     $this->db->execute([$id]);
     return $this->db->fetchInto($this);
-  }
+    }
   
-  /**
-   * Save current object/row.
-   *
-   * @param array $values key/values to save or empty to use object properties.
-   *
-   * @return boolean true or false if saving went okey.
-   */
+    /**
+     * Save current object/row.
+     *
+     * @param array $values key/values to save or empty to use object properties.
+     *
+     * @return boolean true or false if saving went okey.
+     */
     public function save($values = [])
     {
 
@@ -86,151 +86,151 @@ 
     } else {
         return $this->create($values);
     }
-  }
+    }
   
-  /**
-   * Set object properties.
-   *
-   * @param array $properties with properties to set.
-   *
-   * @return void
-   */
-  public function setProperties($properties)
-  {
-      // Update object with incoming values, if any
-      if (!empty($properties)) {
-          foreach ($properties as $key => $val) {
-              $this->$key = $val;
-          }
-      }
-  }
+    /**
+     * Set object properties.
+     *
+     * @param array $properties with properties to set.
+     *
+     * @return void
+     */
+    public function setProperties($properties)
+    {
+        // Update object with incoming values, if any
+        if (!empty($properties)) {
+            foreach ($properties as $key => $val) {
+                $this->$key = $val;
+            }
+        }
+    }
   
-  /**
-   * Create new row.
-   *
-   * @param array $values key/values to save.
-   *
-   * @return boolean true or false if saving went okey.
-   */
-  public function create($values)
-  {
-      $keys   = array_keys($values);
-      $values = array_values($values);
+    /**
+     * Create new row.
+     *
+     * @param array $values key/values to save.
+     *
+     * @return boolean true or false if saving went okey.
+     */
+    public function create($values)
+    {
+        $keys   = array_keys($values);
+        $values = array_values($values);
    
-      $this->db->insert(
-          $this->getSource(),
-          $keys
-      );
+        $this->db->insert(
+            $this->getSource(),
+            $keys
+        );
    
-      $res = $this->db->execute($values);
+        $res = $this->db->execute($values);
    
-      $this->id = $this->db->lastInsertId();
+        $this->id = $this->db->lastInsertId();
    
-      return $res;
-  }
+        return $res;
+    }
   
   
-  /**
-   * Update row.
-   *
-   * @param array $values key/values to save.
-   *
-   * @return boolean true or false if saving went okey.
-   */
-  public function update($values)
-  {
+    /**
+     * Update row.
+     *
+     * @param array $values key/values to save.
+     *
+     * @return boolean true or false if saving went okey.
+     */
+    public function update($values)
+    {
 	  
-	  $keys   = array_keys($values);
-      $values = array_values($values);
+        $keys   = array_keys($values);
+        $values = array_values($values);
    
-      // Its update, remove id and use as where-clause
-      unset($keys['id']);
+        // Its update, remove id and use as where-clause
+        unset($keys['id']);
       
-      $values[] = $this->id;
+        $values[] = $this->id;
       
-      $this->db->update(
-          $this->getSource(),
-          $keys,
-          "id = ?"
-      );
+        $this->db->update(
+            $this->getSource(),
+            $keys,
+            "id = ?"
+        );
    
-      return $this->db->execute($values);
-  }
+        return $this->db->execute($values);
+    }
   
-  /**
-   * Delete row.
-   *
-   * @param integer $id to delete.
-   *
-   * @return boolean true or false if deleting went okey.
-   */
-  public function delete($id)
-  {
-      $this->db->delete(
-          $this->getSource(),
-          'id = ?'
-      );
+    /**
+     * Delete row.
+     *
+     * @param integer $id to delete.
+     *
+     * @return boolean true or false if deleting went okey.
+     */
+    public function delete($id)
+    {
+        $this->db->delete(
+            $this->getSource(),
+            'id = ?'
+        );
    
-      return $this->db->execute([$id]);
-  }
+        return $this->db->execute([$id]);
+    }
   
   
-  /**
-   * Build a select-query.
-   *
-   * @param string $columns which columns to select.
-   *
-   * @return $this
-   */
-  public function query($columns = '*')
-  {
-      $this->db->select($columns)
-               ->from($this->getSource());
+    /**
+     * Build a select-query.
+     *
+     * @param string $columns which columns to select.
+     *
+     * @return $this
+     */
+    public function query($columns = '*')
+    {
+        $this->db->select($columns)
+                ->from($this->getSource());
    
-      return $this;
-  }
+        return $this;
+    }
  
-  /**
-   * Build the where part.
-   *
-   * @param string $condition for building the where part of the query.
-   *
-   * @return $this
-   */
-  public function where($condition)
-  {
-      $this->db->where($condition);
+    /**
+     * Build the where part.
+     *
+     * @param string $condition for building the where part of the query.
+     *
+     * @return $this
+     */
+    public function where($condition)
+    {
+        $this->db->where($condition);
    
-      return $this;
-  }  
+        return $this;
+    }  
     
-  /**
-   * Build the where part.
-   *
-   * @param string $condition for building the where part of the query.
-   *
-   * @return $this
-   */
-  public function andWhere($condition)
-  {
-      $this->db->andWhere($condition);
+    /**
+     * Build the where part.
+     *
+     * @param string $condition for building the where part of the query.
+     *
+     * @return $this
+     */
+    public function andWhere($condition)
+    {
+        $this->db->andWhere($condition);
    
-      return $this;
-  }  
+        return $this;
+    }  
   
-  /**
-   * Execute the query built.
-   *
-   * @param array $params 
-   *
-   * @return $this
-   */
-  public function execute($params = [])
-  {
-      $this->db->execute($this->db->getSQL(), $params);
-      $this->db->setFetchModeClass(__CLASS__);
+    /**
+     * Execute the query built.
+     *
+     * @param array $params 
+     *
+     * @return $this
+     */
+    public function execute($params = [])
+    {
+        $this->db->execute($this->db->getSQL(), $params);
+        $this->db->setFetchModeClass(__CLASS__);
    
-      return $this->db->fetchAll();
-  }
+        return $this->db->fetchAll();
+    }
 
 }