<?php

namespace MGModule\DNSManager2\models\testGroup\testItem;
use MGModule\DNSManager2 as main;
use MGModule\DNSManager2\mgLibs;
use MGModule\DNSManager2\models\testGroup\simpleItem\SimpleItem;

/**
 * Example Item Class
 * 
 * @Table(name=test_item)
 * @author Michal Czech <michael@modulesgarden.com>
 */
class testItem extends main\mgLibs\models\orm{
    static $avaibleOptionsA = array(
        1   => 'Option1'
        ,2  => 'Option2'
        ,3  => 'Option3'
    );
    
    static $avaibleOptionsB = array(1,2,3,4);
    static $avaibleOptionsC = array(1,2,3,4,5,6,7,8,9,10);
    /**
     * ID field
     * 
     * @Column(id)
     * @var int 
     */
    public $id;
    
    /**
     * Text Field
     * 
     * @Column(varchar=512,name=text_field)
     * @Validation(notEmpty)
     * @var string 
     */
    public $textField;
    
    /**
     * Text2 Field
     * 
     * @Column(varchar=256)
     * @Validation(notEmpty)
     * @var string 
     */
    public $text2;
    
    /**
     * Checkbox Value
     * 
     * @Column(text,as=checkboxSerialized)
     * @var array 
     */
    public $checkbox;
    
    /**
     * Boolean Field
     * 
     * @Column(boolean)
     * @var boolean 
     */
    public $onoff;
    
    /**
     * Value
     * 
     * @Column(smallint)
     * @var int 
     */
    public $radio;
    
    /**
     * @Column(int)
     * @var int 
     */
    public $option;
    
    /**
     *  Number of relations
     * 
     * @var int 
     */
    public $simpleNum;
    
    /**
     * Multi Value
     * 
     * @Column(text,as=option2Serialized)
     * @Validation(notEmpty)
     * @var array 
     */
    public $option2;
    
    /**
     * Password
     * 
     * @Column(varchar=32,as=passwordEncrypted)
     * @var string 
     */
    public $password;
    
    function __construct($id = false, $data = array()) {
        if($id !== false && empty($data))
        {
            $sql = "
                SELECT
                    ".mgLibs\MySQL\query::formatSelectFields(testItem::fieldDeclaration(),'B')."
                    ,count(S.".  SimpleItem::getProperyColumn('id').") as simpleNum
                FROM
                    ".testItem::tableName()." B
                JOIN
                    ".SimpleItem::tableName()." S
                WHERE
                    B.id = :id
                GROUP BY 
                    B.id
            ";

            $data = main\mgLibs\MySQL\query::query($sql,array('id'=>$id))->fetch();
            
            if(empty($data))
            {
                throw new main\mgLibs\exceptions\system('Unable to find Element with ID:'.$id);
            }
        }
        
        if($data)
        {
            $data['checkbox'] = unserialize(base64_decode($data['checkboxSerialized'])); 
            $data['option2'] = unserialize(base64_decode($data['option2Serialized'])); 
            $data['password'] = $this->decrypt($data['passwordEncrypted']);
        }
        
        parent::__construct(false, $data);
    }
    
    function save(){
        $data = array(
            'text_field'        => $this->textField
            ,'text2'            => $this->text2
            ,'checkbox'         => base64_encode(serialize($this->checkbox))
            ,'onoff'            => (bool)$this->onoff
            ,'radio'            => $this->radio
            ,'option'           => $this->option
            ,'option2'          => base64_encode(serialize($this->option2))
            ,'password'         => $this->encrypt($this->password)
        );

        if($this->id)
        {
            main\mgLibs\MySQL\query::update(
                    self::tableName()
                    , $data
                    , array(
                        'id'    => $this->id
                    )
            );
        }
        else
        {
            $this->id = main\mgLibs\MySQL\query::insert(
                    self::tableName()
                    , $data
            );
        }
    }
}