Single Model Class For Dynamic Tables

kokilaperera · July 22, 2014, 9:07am

I have been working on a project to develop MIS for university academic staff

I want to use seperate tables for each academic year to store lecture details (lecturers assigned to each subject)

I have develop the model class as follows

Troble is with tableName;

following works well

new Assignment('2012/2013)->tableName();//output:lecture2012_2013 :correct

But

Assignment::model(‘2012/2013’)->find()->tableName();

//output:lecture2013_2014 :default name

//:wrong, but correctly fetches data

Can anybody help … please?

5770

Assignment.php

part of the model class:

/* start_of_dynamic_tables_code */

private &#036;tableName = 'lecture'; // &lt;=default value


private static &#036;_models = array();


private &#036;_md;





public function __construct(&#036;tableName = null, &#036;scenario = 'insert') {


    if (&#036;tableName === null || &#036;tableName === '') {


        &#036;criteria = new CDbCriteria();


        &#036;criteria-&gt;select = 'MAX(Year) as Year';


        &#036;tableName = AcademicCalendar::model()-&gt;find(&#036;criteria)-&gt;Year;


        &#036;this-&gt;tableName = &#036;this-&gt;tableName . &#036;tableName;


    }


    else{


        &#036;tableName=str_replace('lecture','',&#036;tableName);


        &#036;this-&gt;tableName ='lecture'.&#036;tableName;


    }


    &#036;this-&gt;tableName=  str_replace('/', '_', &#036;this-&gt;tableName);


    parent::__construct(&#036;scenario);


}





public static function model(&#036;tableName = false, &#036;className = __CLASS__) {


    &#036;tableName=  str_replace('/', '_', &#036;tableName);


    &#036;tableName=str_replace('lecture','',&#036;tableName);


    


    if (&#036;tableName === null)


        &#036;className = null;


    // this string will save internal CActiveRecord functionality


    if (&#33;&#036;tableName)


        return parent::model(&#036;className);


    if(&#036;tableName&#33;==null || &#036;tableName){


        &#036;tableName ='lecture'.&#036;tableName;


    }


    if (isset(self::&#036;_models[&#036;tableName . &#036;className]))


        return self::&#036;_models[&#036;tableName . &#036;className];


    else {


        &#036;model = self::&#036;_models[&#036;tableName . &#036;className] = new &#036;className(null);


        //&#036;model = parent::model();


        &#036;model-&gt;tableName = &#036;tableName;





        &#036;model-&gt;_md = new CActiveRecordMetaData(&#036;model);


        &#036;model-&gt;attachBehaviors(&#036;model-&gt;behaviors());





        return &#036;model;


    }


}





public function tableName() {


    return &#036;this-&gt;tableName;


}





/**


 * Returns the meta-data for this AR


 * @return CActiveRecordMetaData the meta for this AR class.


 */


public function getMetaData() {


    if (&#036;this-&gt;_md === null)


        &#036;this-&gt;_md = new CActiveRecordMetaData(&#036;this);


    return &#036;this-&gt;_md;


}





public function refreshMetaData() {


    &#036;finder = static::model(&#036;this-&gt;tableName());


    &#036;finder-&gt;_md = new CActiveRecordMetaData(&#036;finder);


    if (&#036;this &#33;== &#036;finder)


        &#036;this-&gt;_md = &#036;finder-&gt;_md;


}





/* end_of_dynamic_tables_code */

kokilaperera · July 22, 2014, 3:04pm

Actually the trouble is when I call

Assignment::model(‘2012/2013’)->find();

this create an Assignment object by calling ‘new Assignment()’; without parameters

so… it get default table name

Can i change this?

Can I make find() to create objects giving parameters? if so how?