<?php

class tbNewsbook extends CActiveRecord {
    
    public static function model($className = __CLASS__) {
        return parent::model($className);
    }
    
    public function tableName() {
        return 'tb_newsbook';
    }
    
    public function attributeLabels() {
        return array(
            'id' => 'ID',
            'nb_name' => 'เรื่อง',
            'nb_number' => 'เลขที่หนังสือ',
            'nb_date_start' => 'วันที่ลง',
            'nb_date_end' => 'วันที่หมดอายุ',
            'nb_status' => 'สถานะ',
            'nb_tag_view' => 'หน่วยงานที่เข้ามาดู',
        );
    }
    
    public function rules() {
        return array(
            array('nb_name, nb_number, nb_date_start, nb_date_end', 'required', 'message'=>'{attribute} ## ห้ามเป็นข้อมูลว่าง.'),
            array('nb_name', 'unique', 'message'=>'{attribute} ## ห้ามซ้ำกัน.'),
            // array('nb_name', 'match', 'pattern'=>'/^[ก-ฮะ-์เ A-Za-z0-9]+$/', 'message'=>'{attribute} ## ต้องเป็น ภาษาไทย, ภาษาอังกฤษ, ตัวเลข และ ช่องว่างเท่านั้น.'),
            
            array('id, nb_status', 'safe'),
        );
    }
    
    public function relations() {
        return array(
            'tbNewsbookFile' => array(self::HAS_MANY, 'tbNewsbookFile', 'tb_newsbook_id'),
            'tbNewsbookGroup' => array(self::HAS_MANY, 'tbNewsbookGroup', 'tb_newsbook_id'),
        );
    }
    
    public function statusThai($data, $row) {
        return OtherFunction::statusThai($data->nb_status);
    }
    
    public function beforeSave() {
        if ($this->nb_date_start) {
            $this->nb_date_start = date('Y-m-d', strtotime($this->nb_date_start));
        }
        
        if ($this->nb_date_end) {
            $this->nb_date_end = date('Y-m-d', strtotime($this->nb_date_end));
        }
        
        return parent::beforesave();
    }
    
    public function afterFind() {
        if ($this->nb_date_start) {
            $this->nb_date_start = date('d-m-Y', strtotime($this->nb_date_start));
        }
        
        if ($this->nb_date_end) {
            $this->nb_date_end = date('d-m-Y', strtotime($this->nb_date_end));
        }
        
        return parent::afterFind();
    }
    
    public function search() {
        $criteria = new CDbCriteria;
        
        $criteria->with = array('tbNewsbookGroup'=> array(
            'select' => 'tb_newsbook_member_id',
        ));
        $criteria->together = true;
        
        $criteria->compare("nb_name", $this->nb_name, true);
        $criteria->compare('tb_newsbook_member_id', Yii::app()->session['newsbook_member_id'], true);
        $criteria->order = "t.id DESC";

        return new CActiveDataProvider($this, array(
            "criteria" => $criteria,
            'pagination' => array('pageSize'=>10),
        ));
    }
    
    public function dateThaiStart($data, $row) {
        return OtherFunction::DateThai($data->nb_date_start);
    }
    
    public function dateThaiEnd($data, $row) {
        return OtherFunction::DateThai($data->nb_date_end);
    }
}
?>