<?php /** * This is the model class for table "food". * * The followings are the available columns in table 'food': * @property integer $id * @property string $name * @property integer $type_id * @property string $image * @property string $status * @property integer $price */ class Food extends CActiveRecord { /** * @return string the associated database table name */ public function tableName() { return 'food'; } /** * @return array validation rules for model attributes. */ public function rules() { // NOTE: you should only define rules for those attributes that // will receive user inputs. return array( // array('name, type_id, image, status, price', 'required'), // array('type_id, price', 'numerical', 'integerOnly'=>true), // array('name', 'length', 'max'=>55), // array('image', 'length', 'max'=>255), // array('status', 'length', 'max'=>3), // // The following rule is used by search(). // // @todo Please remove those attributes that should not be searched. // array('id, name, type_id, image, status, price', 'safe', 'on'=>'search'), ); } /** * @return array relational rules. */ public function relations() { // NOTE: you may need to adjust the relation name and the related // class name for the relations automatically generated below. return array( 'typefood'=>array(self::BELONGS_TO, 'Typefood','type_id'), 'orders'=>array(self::BELONGS_TO, 'Orders','food_id') ); } /** * @return array customized attribute labels (name=>label) */ public function attributeLabels() { return array( 'id' => 'รหัสอาหาร', 'name' => 'ชื่ออาหาร', 'type_id' => 'ประเภทอาหาร', 'image' => 'รูปอาหาร', 'status' => 'สถานะ', 'price' => 'ราคา', 'detail'=>'รายละเอียด' ); } /** * Retrieves a list of models based on the current search/filter conditions. * * Typical usecase: * - Initialize the model fields with values from filter form. * - Execute this method to get CActiveDataProvider instance which will filter * models according to data in model fields. * - Pass data provider to CGridView, CListView or any similar widget. * * @return CActiveDataProvider the data provider that can return the models * based on the search/filter conditions. */ public function search() { // @todo Please modify the following code to remove attributes that should not be searched. $criteria=new CDbCriteria; $criteria->compare('id',$this->id); $criteria->compare('name',$this->name,true); $criteria->compare('type_id',$this->type_id); $criteria->compare('image',$this->image,true); $criteria->compare('status',$this->status,true); $criteria->compare('price',$this->price); $criteria->compare('detail',$this->detail,true); return new CActiveDataProvider($this, array( 'criteria'=>$criteria, )); } static function getStatus($data) { if ($data == 'on') { return 'เปิดใช้งาน'; } else { return 'ปิด'; } } static function getStatusLink($data) { if ($data == 'on') { return 'ปิด'; } else { return 'เปิด'; } } /** * Returns the static model of the specified AR class. * Please note that you should have this exact method in all your CActiveRecord descendants! * @param string $className active record class name. * @return Food the static model class */ public static function model($className=__CLASS__) { return parent::model($className); } }