Yii models & AR extending

Archives Yii 1.0.x Discussions
1

Hello,

I’ve been using CodeIgniter for almost 6 months but now i’m changing to Yii framework. I’m figuring out the models and AR out for some time, i can’t seem to get used to it. In fact i think that i’m screwing up with the AR models.

Can someone please explain me the right way to extend the AR models with my own function that i can use in the controllers, it’s because I basically have many actions that repeat themselves and in the tutorials I only see a query being executed in a controller.

Please help me.

Thanks,

Tim

2

in CI you often have something like this:


<?php


class Mregisters extends Model

{


	private $data;

    /**

     * Mregisters::Mregisters()

     * 

     * @return

     */

    function Mregisters()

    {

        parent::Model();

    }

	

    /**

     * Mregisters::get_all()

     * 

     * @param mixed $user_id

     * @return

     */

    function get_all($user_id)

    {

        $this->db->select("*");

        $this->db->from("registers");

        $this->db->where("user_id", $user_id);

        $Q = $this->db->get();


        if ($Q->num_rows() == 0)

            return false;

        else 

		{

            foreach ($Q->result_array() as $row) 

			{

                $data[] = array("id" => $row['id'], "register_name" => $row['register_name']);

            }

            $Q->free_result();

            return $data;

        }

    }


    function get_register_name($id)

    {

        $this->db->select("register_name");

        $this->db->from("registers");

        $this->db->where("id", $id);

        $Q = $this->db->get();


        if ($Q->num_rows() == 0)

            return false;

        else

		{

		    $row = $Q->row_array();

            return $row['register_name'];

        }

    }

}

Can I do this in Yii without problem, are there rules to consider or is there a better way? What’s the best practice for doing this in Yii?

3

I can’t tell if this is the best way to do it, it may be.

This nearly minimal model is extended with a lookup method:




class Temp extends CActiveRecord

{

  public static function model($className=__CLASS__) {

    return parent::model($className);

  }


  public function tableName() {

    return 'Temp';

  }


  public function rules() {

    return array();

  }


  public function relations() {

    return array();

  }


  public function attributeLabels() {

    return array();

  }


  public function lookup($id=0) {

    if($id != 0)

      $ar = Temp::model()->findbyPk($id);

    else

      $ar = Temp::model()->findAll();

    if (!isset($ar))

      throw new CHttpException(500,'The requested items does not exist.');

    return $ar;

  }

}

The call in the controller:




$temp = Temp::model()->lookup();
4

Thanks, i think this gives me a fair idea of how to do it.

5

Little addition: As long as you call your custom methods with Temp::model()…; You can also use $this in these methods:


public function findAllActiveUsers()

{

    // Just an example. Could also be solved with a named scope. 

    return $this->findAllByAttributes(array('active'=>1));

}
6

Mike & tri,

Thanks guys,

it helps out really well in my authentication system at the moment.