interface/modules/zend_modules/module/Multipledb/src/Multipledb/Model/MultipledbTable.php

   1 <?php
   2
   3 /* +-----------------------------------------------------------------------------+
   4 * Copyright 2016 matrix israel
   5 * LICENSE: This program is free software; you can redistribute it and/or
   6 * modify it under the terms of the GNU General Public License
   7 * as published by the Free Software Foundation; either version 3
   8 * of the License, or (at your option) any later version.
   9 * This program is distributed in the hope that it will be useful,
  10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  12 * GNU General Public License for more details.
  13 * You should have received a copy of the GNU General Public License
  14 * along with this program. If not, see
  15 * http://www.gnu.org/licenses/licenses.html#GPL
  16 *    @author  Oshri Rozmarin <oshri.rozmarin@gmail.com>
  17 * +------------------------------------------------------------------------------+
  18  *
  19  */
  20
  21 namespace Multipledb\Model;
  22 use Zend\Db\Sql\Expression;
  23 use Zend\Db\TableGateway\TableGateway;
  24 use Zend\Db\Sql\Predicate;
  25 use \Application\Model\ApplicationTable;
  26 use Zend\Db\Adapter\Adapter;
  27 class MultipledbTable
  28 {
  29
  30     protected $tableGateway;
  31     protected $adapter;
  32
  33
  34     /**
  35      * MultipledbTable constructor.
  36      * @param TableGateway $tableGateway
  37      */
  38     public function __construct(TableGateway $tableGateway)
  39     {
  40         $this->tableGateway = $tableGateway;
  41         $adapter = \Zend\Db\TableGateway\Feature\GlobalAdapterFeature::getStaticAdapter();
  42         $this->adapter = $adapter;
  43     }
  44
  45     public function fetchAll()
  46     {
  47         /* $resultSet = $this->tableGateway->select();
  48          return $resultSet;*/
  49
  50         $rsArray = array();
  51         $rs = $this->tableGateway->select();
  52         foreach ($rs as $r) {
  53             $rsArray[] = get_object_vars($r);
  54         }
  55
  56         return $rsArray;
  57     }
  58
  59
  60     public function storeMultipledb($id = 0,$db = array()){
  61
  62         if($db['password']){
  63             $db['password'] = my_encrypt($db['password']);
  64         }else{
  65             unset($db['password']);
  66         }
  67
  68         if($id){
  69             $this->tableGateway->update($db, array('id' => $id));
  70         }else{
  71             $this->tableGateway->insert($db);
  72         }
  73
  74     }
  75
  76     public function deleteMultidbById($id){
  77         $this->tableGateway->delete(array('id' => (int)$id));
  78     }
  79
  80     public function getMultipledbById($id){
  81
  82         $rowset = $this->tableGateway->select(array('id' => $id));
  83         $row = $rowset->current();
  84         if (!$row) {
  85             return false;
  86             //throw new \Exception("Could not find row $serial_no");
  87         }
  88
  89         return $row;
  90     }
  91
  92
  93     public function randomSafeKey() {
  94         $alphabet = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890$%&#@(){}[]<>~=?.*+-!';
  95         $pass = array(); //remember to declare $pass as an array
  96         $alphaLength = strlen($alphabet) - 1; //put the length -1 in cache
  97         for ($i = 0; $i < 32; $i++) {
  98             $n = mt_rand(0, $alphaLength);
  99             $pass[] = $alphabet[$n];
 100         }
 101         return implode($pass); //turn the array into a string
 102     }
 103 }