public function actionProfile() { $fams = Families::model()->findAll(); $ppl = People::model()->findAll(); $baptised = People::model()->getBaptised(); $confirmed = People::model()->getConfirmed(); $married = People::model()->getMarried(); $this->render('profile', array('families' => count($fams), 'members' => count($ppl), 'baptised' => count($baptised), 'confirmed' => count($confirmed), 'married' => count($married))); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate($id) { $model = new MembershipCertificate(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['MembershipCertificate'])) { $model->attributes = $_POST['MembershipCertificate']; if ($model->save()) { $this->redirect(array('view', 'id' => $model->id)); } } $rec = People::model()->findByPk($id); $model->cert_dt = Yii::app()->dateFormatter->formatDateTime(time(), 'short', null); $this->render('create', array('model' => $model, 'member' => $rec)); }
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)); }
public function actionIndex() { $peoples = People::model()->findAll(); $this->render('index', array('peoples' => $peoples)); }
public function actionDependents($id) { $model = $this->loadModel($id); if (isset($_POST['People']['dependent'])) { for ($i = 0; $i < 10; ++$i) { if (isset($_POST['People']['dependent'][$i])) { if ($pid = $_POST['People']['dependent'][$i]['id']) { $p = People::model()->findByPk($pid); } else { $p = new People(); } $p->attributes = $_POST['People']['dependent'][$i]; $p->family_id = $model->id; $p->role = 'dependent'; $p->save(); } } } $ppl_ac = People::getAutoCompleteFields(); $this->render('dependents', array('model' => $model, 'ppl_ac' => $ppl_ac)); }
if ($wedding == 0) { define('FAM_ID', $fam_id); ?> <div class="form"> <?php $form = $this->beginWidget('CActiveForm', array('id' => 'create-wedding')); ?> <?php echo $form->labelEx($model, 'wedding'); ?> <?php echo $form->dropDownList($model, 'wedding', CHtml::listData(People::model()->findAll(), 'id', function ($data) { $name = $data['f_name'] . ' ' . $data['l_name']; $data['wedding'] > 0 ? $name .= ' (в браке)' : ''; $data['family_id'] == FAM_ID ? $name .= ' (в одной семье)' : ($name .= ' (разные семьи)'); return $name; }), array('empty' => 'Выберите пару')); ?> <?php echo $form->error($model, 'wedding'); ?> <div class="clearfix"></div> <div class="btn-group">
public static function getAutoCompleteFields() { $people = People::model()->findAll(); $specialSkills = array(); $professions = array(); $occupations = array(); $churches = array(); $baptism_places = array(); $cemetery_churches = array(); foreach ($people as $p) { if (!isset($specialSkills[$p->special_skill])) { $specialSkills[$p->special_skill] = 1; } if (!isset($professions[$p->profession])) { $professions[$p->profession] = 1; } if (!isset($occupations[$p->occupation])) { $occupations[$p->occupation] = 1; } if (!isset($baptism_churches[$p->baptism_church])) { $churches[$p->baptism_church] = 1; } if (!isset($baptism_places[$p->baptism_place])) { $baptism_places[$p->baptism_place] = 1; } if (!isset($cemetery_churches[$p->cemetery_church])) { $cemetery_churches[$p->cemetery_church] = 1; } } $families = Families::model()->findAll(); foreach ($families as $fam) { if (!isset($churches[$fam->marriage_church])) { $churches[$fam->marriage_church] = 1; } } return array('special_skills' => array_keys($specialSkills), 'professions' => array_keys($professions), 'occupations' => array_keys($occupations), 'churches' => array_keys($churches), 'baptism_places' => array_keys($baptism_places), 'cemetery_churches' => array_keys($cemetery_churches)); }
/** * 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 People the loaded model * @throws CHttpException */ public function loadModel($id) { $model = People::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function bride() { $bp = $this->bride_parish; if (ctype_digit($bp)) { return People::model()->findByPk($bp); } else { return null; } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new BannsRecord(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['BannsRecord'])) { $model->attributes = $_POST['BannsRecord']; if ($model->save()) { if (Yii::app()->getUser()->hasState('local')) { Yii::app()->getUser()->setState('local', null); } $this->redirect(array('view', 'id' => $model->id)); } } elseif (isset($_GET['local'])) { $local = $_GET['local']; if (!Yii::app()->getUser()->hasState('local')) { Yii::trace('Setting session var local', 'application.controllers.BannsRecordsController'); Yii::app()->getUser()->setState('local', $local); } $sex = 'bride' == $local ? 2 : 1; if (isset($_POST['member'])) { $mid = $_POST['member']; Yii::trace("Got member {$mid}", 'application.controllers.BannsRecordsController'); if ('both' == Yii::app()->getUser()->getState('local')) { if ('both' == $local) { Yii::app()->getUser()->setState('groom', $mid); Yii::trace("local = {$local}. Going to redirect", 'application.controllers.BannsRecordsController'); $this->redirect(array('create', 'local' => 'bride')); } else { $gid = Yii::app()->getUser()->getState('groom'); $groom = People::model()->findByPk($gid); $bride = People::model()->findByPk($mid); $this->render('create', array('model' => $model, 'local' => 'both', 'groom' => $groom, 'bride' => $bride)); } } else { $member = People::model()->findByPk($mid); $this->render('create', array('model' => $model, 'local' => $local, $local => $member)); } } else { $members = new CActiveDataProvider('People', array('criteria' => array('condition' => "sex = {$sex} and role != 'husband' and role != 'wife'"))); $this->render('create', array('model' => $model, 'members' => $members)); } return; } else { Yii::app()->getUser()->setState('local', null); } $this->render('create', array('model' => $model)); }
public static function getAutoCompleteFields() { $families = Families::model()->findAll(); $areas = array(); $pincodes = array(); foreach ($families as $fam) { if (!isset($areas[$fam->addr_area])) { $areas[$fam->addr_area] = 1; } if (!isset($pincodes[$fam->addr_pin])) { $pincodes[$fam->addr_pin] = 1; } } $people = People::model()->findAll(); $pincodekeys = array_keys($pincodes); return array('areas' => array_keys($areas), 'pincodes' => array_map('strval', array_keys($pincodes))); }