function init() { parent::init(); // $st = $this->join('student.scholar_id'); $q = $this->dsql(); // $st = $this->join('student.scholar_id', // $q->andExpr()->where('s.scholar_id',$q->getField('id'))->where('s.session_id',$this->add('Model_Sessions_Current')->tryLoadAny()->get('id')) // ,null,'s'); // $st = $this->join('student',$this->dsql()->expr('_s.scholar_id = ' . $this->dsql()->getField('id'). " and _s.session_id = " . $this->add('Model_Sessions_Current')->tryLoadAny()->get('id') )); $st = $this->join('student.scholar_id'); $st->hasOne('Class', 'class_id'); $st->addField('ishostler')->type('boolean'); $st->addField('isScholared')->type('boolean')->caption('Hostler As Scholared'); $st->addField('bpl')->type('boolean')->caption('BPL'); $st->addField('roll_no'); $st->addField('session_id'); $this->addCondition('session_id', $this->add('Model_Sessions_Current')->tryLoadAny()->get('id')); // $st->hasOne('Sessions_Current', 'session_id'); //$g = $st->join('scholar_guardian.scholar_id', null, 'left'); // $this->addCondition('session_id', $this->add('Model_Sessions_Current')->tryLoadAny()->get('id')); // $this->_dsql()->order(array('class_id','fname')); $this->_dsql()->order('class_id', 'asc'); // $st->_dsql()->order('fname','asc'); // $this->debug(); $this->addHook('beforeSave', $this); }
function init() { parent::init(); // $this->hasOne('Student_Current','scholars_master.id','student.scholar_id'); $st = $this->join('student.scholar_id'); $st->addField('isScholared')->type('boolean'); $st->hasOne('Class', 'class_id'); $st->hasOne('Session_Current', 'session_id'); $this->addCondition('session_id', $this->add('Model_Session_Current')->dsql()->field('id')); }
function init() { parent::init(); $st = $this->join('student.scholar_id'); $st->hasOne('Class', 'class_id'); $st->addField('ishostler')->type('boolean'); $st->addField('isScholared')->type('boolean')->caption('Hostler As Scholared'); $st->addField('bpl')->type('boolean')->caption('BPL'); $st->hasOne('Session_Current', 'session_id'); //$g = $st->join('scholar_guardian.scholar_id', null, 'left'); $this->addCondition('session_id', $this->add('Model_Session_Current')->dsql()->field('id')); // $this->_dsql()->order(array('class_id','fname')); }
function init() { parent::init(); $this->addCondition('active_in_session', false); }