public function getPastors() { $pastors = Pastors::model()->findAll(); $pData = array(); foreach ($pastors as $p) { $pData[$p->id] = $p->getFullname(); } return $pData; }
public function actionParishProfile() { $fams = Families::model()->findAll(); $ppl = People::model()->findAll(); $baptised1 = BaptismRecord::model()->findAll('baptism_dt > NOW() - INTERVAL 1 YEAR AND dob > NOW() - INTERVAL 1 YEAR'); $baptised7 = BaptismRecord::model()->findAll('baptism_dt > NOW() - INTERVAL 1 YEAR AND dob BETWEEN NOW() - INTERVAL 7 YEAR AND NOW() - INTERVAL 1 YEAR'); $baptised7p = BaptismRecord::model()->findAll('baptism_dt > NOW() - INTERVAL 1 YEAR AND dob < NOW() - INTERVAL 7 YEAR'); $baptised = BaptismRecord::model()->findAll(); $confirmed = ConfirmationRecord::model()->findAll('confirmation_dt > NOW() - INTERVAL 1 YEAR '); $firstComm = FirstCommunionRecord::model()->findAll('communion_dt > NOW() - INTERVAL 1 YEAR '); $married = MarriageRecord::model()->findAll('marriage_dt > NOW() - INTERVAL 1 YEAR'); $married_cath = MarriageRecord::model()->findAll('marriage_dt > NOW() - INTERVAL 1 YEAR AND marriage_type <= 2'); $married_nc = MarriageRecord::model()->findAll('marriage_dt > NOW() - INTERVAL 1 YEAR AND marriage_type > 2'); $schedule = MassSchedule::model()->findAll(array('order' => 'day, time')); $pp = Pastors::model()->find('role = 1'); $apps = Pastors::model()->findAll('role != 1'); $this->render('parish-profile', array('families' => count($fams), 'members' => count($ppl), 'baptised' => count($baptised), 'baptised1' => count($baptised1), 'baptised7' => count($baptised7), 'baptised7p' => count($baptised7p), 'confirmed' => count($confirmed), 'firstComm' => count($firstComm), 'married' => count($married), 'married_nc' => count($married_nc), 'married_cath' => count($married_cath), 'pp' => $pp, 'apps' => $apps, 'schedule' => $schedule)); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Pastors the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Pastors::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
# # Alive Parish - software to manage tomorrow's parish # Copyright (C) 2013 Redemptorist Media Center # # Alive Parish Software is free software: you can redistribute it # and/or modify it under the terms of the GNU General Public License as # published by the Free Software Foundation, either version 3 of the # License, or (at your option) any later version. # # Alive Parish Software is distributed in the hope that it will # be useful, but WITHOUT ANY WARRANTY; without even the implied warranty # of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program. If not, see <http://www.gnu.org/licenses/>. # /* @var $this VisitController */ /* @var $model Visits */ $this->breadcrumbs = array('Visits' => array('index'), $model->id); $this->menu = array(array('label' => 'List Visits', 'url' => array('index')), array('label' => 'Create Visits', 'url' => array('create')), array('label' => 'Update Visits', 'url' => array('update', 'id' => $model->id)), array('label' => 'Delete Visits', 'url' => '#', 'linkOptions' => array('submit' => array('delete', 'id' => $model->id), 'confirm' => 'Are you sure you want to delete this item?')), array('label' => 'Manage Visits', 'url' => array('admin'))); ?> <h1>View Visits #<?php echo $model->id; ?> </h1> <?php $this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('id', array('label' => 'Pastor', 'name' => 'pastor_id', 'value' => Pastors::model()->findByPk($model->pastor_id)->fullname), 'visit_dt', array('label' => 'Purpose', 'name' => 'purpose', 'value' => FieldNames::value('visit_purpose', $model->purpose))))); echo CHtml::link('View Family', array('/family/view', 'id' => $model->family_id));