public function init() { $this->discrepancies = Nonconformity::model()->findOpenDiscrepancies(); }
<?php /* @var $this NonconformityController */ /* @var $model Nonconformity */ $this->breadcrumbs = array(Yii::t('default', 'Nonconformities')); $this->menu = array(array('label' => 'List Nonconformity', 'url' => array('index')), array('label' => 'Create Nonconformity', 'url' => array('create'))); ?> <h1><?php echo Yii::t('default', 'List of Nonconformity'); ?> </h1> <div class="search-form" style="display:none"> <?php $this->renderPartial('_search', array('model' => $model)); ?> </div><!-- search-form --> <?php $this->widget('zii.widgets.grid.CGridView', array('id' => 'nonconformity-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'selectableRows' => 1, 'selectionChanged' => 'function(id){ location.href = "' . $this->createUrl('view') . '/id/"+$.fn.yiiGridView.getSelection(id);}', 'columns' => array(array('header' => Yii::t('default', 'Step'), 'name' => 'id', 'filter' => CHtml::listData(Nonconformity::model()->travelerStepList, 'id', 'travelerStep', 'group'), 'value' => 'Nonconformity::Model()->FindByPk($data->id)->travelerStep'), array('name' => 'originatorId', 'filter' => CHtml::listData(Nonconformity::model()->users, 'originatorId', 'username'), 'value' => 'User::Model()->FindByPk($data->originatorId)->username'), array('name' => 'importance', 'filter' => CHtml::activeDropDownList($model, 'importance', $model->importanceOptions, array('prompt' => Yii::t('default', ''))), 'value' => '$data->getImportanceText()'), array('name' => 'status', 'filter' => CHtml::activeDropDownList($model, 'status', $model->statusOptions, array('prompt' => Yii::t('default', ''))), 'value' => '$data->getStatusText()'))));
/** * 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 Nonconformity the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Nonconformity::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
protected function beforeDelete() { foreach (Nonconformity::model()->findAll("issueId = {$this->id}") as $discrepancy) { $discrepancy->delete(); } foreach (Comment::model()->findAll("issueId = {$this->id}") as $comment) { $comment->delete(); } foreach (Result::model()->findAll("issueId = {$this->id}") as $result) { $result->delete(); } return parent::beforeDelete(); }
/** * Lists all models. */ public function actionIndex() { $discrepancyId = null; if (isset($_GET['discrepancyId'])) { $discrepancyId = $_GET['discrepancyId']; $discrepancy = Nonconformity::model()->findByPk($discrepancyId); $issue = Issue::model()->find("id = {$discrepancy->issueId}"); $step = $discrepancy->step; } else { throw new CHttpException(404, 'The requested page does not exist.'); } if (!$discrepancy->visible) { $this->layout = "//layouts/column1"; } $dataProvider = new CActiveDataProvider('File', array('criteria' => array('condition' => "discrepancyId={$discrepancyId}"))); $this->render('index', array('dataProvider' => $dataProvider, 'step' => $step, 'issue' => $issue, 'discrepancy' => $discrepancy)); }
public function getNumberDiscrepancies($issueId = null) { if (is_null($issueId)) { $nbDiscrepancies = 0; foreach ($this->steps as $value) { if ($value->discrepancyId) { if (is_null($value->discrepancy->issueId)) { $nbDiscrepancies++; } } } return $nbDiscrepancies; } else { $result = Nonconformity::model()->findAll("issueId = {$issueId}"); return count($result); } }
public function getDiscrepancy($issueId = null) { if ($issueId) { $discrepancy = Nonconformity::model()->find("issueId = {$issueId} and stepId = {$this->id}"); if ($discrepancy) { return $discrepancy; } } return false; }