Esempio n. 1
0
 function init()
 {
     parent::init();
     $this->hasOne('Session_Current', 'session_id');
     $this->addCondition('session_id', $this->add('Model_Session_Current')->dsql()->field('id'));
     $this->join('scholars_master', 'scholar_id');
     $this->_dsql()->order(array('class_id', 'fname'));
 }
Esempio n. 2
0
 function init()
 {
     parent::init();
     $this->addCondition('ishostler', true);
     $raj = $this->join('hostel_allotement.student_id', 'id');
     $rj = $raj->join('rooms.id', 'room_id');
     $bj = $rj->join('hostel_master.id', 'hostel_id');
     $rj->addField('room_no');
     $bj->addField('building_name');
     $this->addField('is_present')->type('boolean')->defaultValue(false);
     $this->hasMany('Item_Issue', 'student_id');
     $this->hasMany('Students_Disease', 'student_id');
     // $this->addExpression('father_name')->set(function($m,$q){
     // 	return $m->refSQL('scholar_id')->fieldQuery('father_name');
     // });
     $this->addExpression('attendance_status')->set(function ($m, $q) {
         return $m->refSQL('Students_Movement')->fieldQuery('purpose')->limit(1)->order('date', 'desc')->where('purpose', 'in', array('inward', 'outward'));
     })->display('attendance');
     $this->addExpression('image_url')->set(function ($m, $q) {
         return $m->refSQL('scholar_id')->fieldQuery('image_url');
     })->display('picture');
 }
Esempio n. 3
0
 function init()
 {
     parent::init();
     $this->addCondition('session_id', $this->add('Model_Sessions_Current')->tryLoadAny()->get('id'));
 }
Esempio n. 4
0
 function init()
 {
     parent::init();
     $this->hasOne('Session_Current', 'student.session_id', 'session_master.id');
     $this->hasOne('Class', 'student.class_id', 'class_master.id');
 }