class.ilShopVats.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */
 
include_once 'Services/Payment/exceptions/class.ilShopException.php';
include_once 'Services/Payment/classes/class.ilShopUtils.php';
 
class ilShopVats
{               
        private $id = 0;
        private $title = '';
        private $rate = 0;
        
        public function __construct($a_vat_id = 0)
        {
                global $ilDB, $lng;
 
                $this->db = $ilDB;
                $this->lng = $lng;
                
                if((int)$a_vat_id && $a_vat_id > 0)
                {
                        $this->id = $a_vat_id;
                        $this->read();
                }
        }
        
        private function read()
        {
                if((int)$this->id)
                {
        
                        $res = $this->db->queryf('SELECT * FROM payment_vats 
                                                WHERE vat_id = %s',
                        array('integer'), array($this->id) );   
                        
                        while($row = $this->db->fetchObject($res))
                        {               
                                $this->setTitle($row->vat_title);
                                $this->setRate($row->vat_rate); 
                                
                                return true;    
                        }
 
                        throw new ilShopException($this->lng->txt('payment_cannot_find_vat'));
                }
                
                throw new ilShopException($this->lng->txt('payment_cannot_read_nonexisting_vat'));
        }
 
        public function reloadFromDatabase()
        {
                $this->read();
                
                return $this;
        }
        
        public function update()
        {
                if((int)$this->id)
                {
                        if(ilShopVatsList::_isVATAlreadyCreated($this->rate, $this->id))
                        {
                                throw new ilShopException($this->lng->txt('payment_vat_already_created'));
                        }
                        
                                   
                        $this->db->manipulatef('                        
                                        UPDATE payment_vats
                                        SET vat_title = %s,
                                                vat_rate = %s
                                        WHERE vat_id = %s',
                                        array('text', 'float', 'integer'),
                                        array($this->getTitle(),$this->getRate(),$this->getId())
                                );
                                   
                        return true;
                }
                
                throw new ilShopException($this->lng->txt('payment_cannot_update_nonexisting_vat'));
        }
        
        public function save()
        {
                if(!(int)$this->id)
                {
                        if(ilShopVatsList::_isVATAlreadyCreated($this->rate))
                        {
                                throw new ilShopException($this->lng->txt('payment_vat_already_created'));
                        }
 
                        $next_id = $this->db->nextId('payment_vats');
                
                        $this->db->manipulateF('
                                INSERT INTO payment_vats
                                (vat_id, vat_title, vat_rate)
                                VALUES (%s,%s,%s)',
                                array('integer', 'text', 'float'),
                                array($next_id, $this->getTitle(), $this->getRate())
                        );              
                        return true;
                }
                
                throw new ilShopException($this->lng->txt('payment_cannot_save_existing_vat'));
        }
        
        public function delete()
        {
                if((int)$this->id)
                {
                        $result = $this->db->queryF('
                                SELECT * FROM payment_objects 
                                WHERE vat_id = %s',
                                array('integer'),
                                array($this->getId())
                        );
 
                        while($row = $this->db->fetchObject($result))
                        {
                                throw new ilShopException(sprintf($this->lng->txt('paya_vat_not_deleted'), $this->title));
                        }               
                
                        $this->db->manipulateF('
                                DELETE FROM payment_vats
                                WHERE vat_id = %s',
                                array('integer'),
                                array($this->getId())
                                
                        );
                        return true;    
                }
 
                throw new ilShopException($this->lng->txt('payment_cannot_delete_nonexisting_vat'));
        }
        
        public function setTitle($a_title)
        {
                $this->title = $a_title;
                
                return $this;
        }
        public function getTitle()
        {
                return $this->title;    
        }
        public function setId($a_id)
        {
                $this->id = $a_id;
                
                return $this;
        }
        public function getId()
        {
                return $this->id;
        }
        public function setRate($a_rate)
        {
                $this->rate = $a_rate;
                
                return $this;
        }
        public function getRate()
        {
                return $this->rate;
        }
 
        public static function _readAllVats()
        {
                global $ilDB;
 
                $vats = array();
                $res = $ilDB->query('SELECT * FROM payment_vats');
                while($row = $ilDB->fetchAssoc($res))
                {
                        $vats[] = $row;
                }
                return $vats;
        }
 
}
 
?>