johannaand / CHTMLTable

src/DatabaseModel/CDatabaseModel.php

Indentation +174 added lines, -174 removed lines

@@ -10,71 +10,71 @@ 
 {
     use \Anax\DI\TInjectable;
  
-  //private $id;
+    //private $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 = [])
     {
 
@@ -87,149 +87,149 @@ 
     } 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);
    
-      $id = $this->db->lastInsertId();
+        $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)
-  {
-	  $keys   = array_keys($values);
-      $values = array_values($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);
    
-      // Its update, remove id and use as where-clause
-      unset($keys['id']);
-      $values[] = $this->id;
+        // Its update, remove id and use as where-clause
+        unset($keys['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();
+    }
 
 }

src/HTMLTable/TableController.php

Indentation +39 added lines, -39 removed lines

@@ -12,61 +12,61 @@
     
     private $model;
       
-   /**
-   * Lists all instances of the model, (databasetable) except for noListing.
-   *
-   * @param $noListing params not to be listed
-   * @param $model model object to list (create an html table from) 
-   *
-   * @return void
-   */
-  public function listAction($noListing = NULL, $model)
-  {
+    /**
+     * Lists all instances of the model, (databasetable) except for noListing.
+     *
+     * @param $noListing params not to be listed
+     * @param $model model object to list (create an html table from) 
+     *
+     * @return void
+     */
+    public function listAction($noListing = NULL, $model)
+    {
 
-      $this->model = $model;
-      $this->model->setDI($this->di);
+        $this->model = $model;
+        $this->model->setDI($this->di);
    
-      $all = $this->model->findAll();
+        $all = $this->model->findAll();
       
-      $aContent = array();
+        $aContent = array();
       
-      //gör om arrayen av objekt till en array av arrayer
-      foreach ($all as $key1=>$value) {
+        //gör om arrayen av objekt till en array av arrayer
+        foreach ($all as $key1=>$value) {
         foreach ($value as $key2=>$v){
-          if (!in_array($key2, $noListing)) { //$noListing, parametrar som inte ska vara med
-              $aContent[$key1][$key2] = $v;
-          }
+            if (!in_array($key2, $noListing)) { //$noListing, parametrar som inte ska vara med
+                $aContent[$key1][$key2] = $v;
+            }
+        }
         }
-      }
      
       
-      $aHeading = [];
-      //hittar objektens parametrar/tabellens kolumnnamn och skapar
-      //en ny array av rubriker
-      foreach ($all as $key1=>$value) {
+        $aHeading = [];
+        //hittar objektens parametrar/tabellens kolumnnamn och skapar
+        //en ny array av rubriker
+        foreach ($all as $key1=>$value) {
         foreach ($value as $key2=>$v){
-          if (!in_array($key2, $noListing)) { //$noListing, parametrar som inte ska vara med
-              $aHeading[] = $key2;
-          }
+            if (!in_array($key2, $noListing)) { //$noListing, parametrar som inte ska vara med
+                $aHeading[] = $key2;
+            }
         }
         break;  
-      }
+        }
       
-      $chtml = new \Jovis\HTMLTable\CHTMLTable($aHeading, $aContent);
+        $chtml = new \Jovis\HTMLTable\CHTMLTable($aHeading, $aContent);
       
-      $htmltable = $chtml->getTable();
-      $source = $this->model->getSource();
+        $htmltable = $chtml->getTable();
+        $source = $this->model->getSource();
       
    
-      $this->theme->setTitle("Visa alla användare");
-      $this->views->add('table/list-all', [
-          'title' => $source,
-          'htmltable' => $htmltable,
-      ]);
-  }
+        $this->theme->setTitle("Visa alla användare");
+        $this->views->add('table/list-all', [
+            'title' => $source,
+            'htmltable' => $htmltable,
+        ]);
+    }
   
-   public function initAction($model){ //används för att befolka databasen, bara för att testa
+    public function initAction($model){ //används för att befolka databasen, bara för att testa
     $model->setDI($this->di);
     $model->init();
-  }
+    }
 }