/**
* Displays a particular model.
* @param integer $id the ID of the model to be displayed
*/
public function actionView($id)
{
$step = $this->loadModel($id);
$issue = null;
if (isset($_GET['issueId'])) {
if ($_GET['issueId'] != '') {
$issue = Issue::model()->find('id=' . $_GET['issueId']);
}
if ($issue) {
if ($issue->status == 0) {
$this->layout = "//layouts/column1";
}
}
}
if (isset($_POST['position'])) {
$step->sortElement($_POST['position']);
exit("ok");
}
$comment = $this->createComment($step, $issue);
$element = $this->createElement($step);
$text = $this->createText($step);
$subStepModel = $this->createSubStep($step);
$file = $this->createFile($step);
$link = $this->createLink($step);
$this->render('view', array('model' => $step, 'comment' => $comment, 'element' => $element, 'file' => $file, 'link' => $link, 'text' => $text, 'subStepModel' => $subStepModel, 'issue' => $issue));
}
public function loadIssue($id)
{
$model = Issue::model()->find("id = {$id}");
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function testGetTypes()
{
$options = Issue::model()->typeOptions;
$this->assertTrue(is_array($options));
$this->assertTrue(3 == count($options));
$this->assertTrue(in_array('Bug', $options));
$this->assertTrue(in_array('Feature', $options));
$this->assertTrue(in_array('Task', $options));
}
public function testGetStatus()
{
$options = Issue::model()->statusOptions;
$this->assertTrue(is_array($options));
$this->assertTrue(3 == count($options));
$this->assertTrue(in_array('Not yet started', $options));
$this->assertTrue(in_array('Started', $options));
$this->assertTrue(in_array('Finished', $options));
}
public function actionDelete($id)
{
// make sure we have that id
$issue = Issue::model()->findByPk($id);
if (!$issue) {
$this->sendError("Sorry, That issue was not found.");
}
$issue->delete();
$this->send("");
}
public function getTravelersList()
{
$new = Yii::t('default', 'New Version Pending');
$travelerId = Issue::model()->findColumn('travelerId', 'equipmentId = ' . $this->id);
$notIn = "";
if ($travelerId) {
$ids = '';
foreach ($travelerId as $id) {
$traveler = Traveler::model()->findByPk($id);
if ($traveler->parentId) {
$ids .= $traveler->parentId . ',';
} else {
$ids .= $traveler->id . ',';
}
}
if ($ids != '') {
$ids = substr($ids, 0, -1);
$notIn = "AND (parentId NOT IN ({$ids}) OR parentId IS NULL)";
//exit($notIn);
}
}
$criteria = new CDbCriteria();
/*$criteria->select = array("CASE status WHEN 0 THEN name+' (v'+CAST(revision as varchar)+')' ELSE name+' (v'+CAST(revision as varchar)+') -> !!$new' END as name", "id"); ORACLE*/
$criteria->select = array("CASE status WHEN 0 THEN CONCAT(name, ' (v', revision, ')') ELSE CONCAT(name, ' (v', revision, ') -> !!{$new}') END as name", "id");
$criteria->condition = "componentId = {$this->componentId} AND status < 1 {$notIn}";
$criteria->addNotInCondition('id', $travelerId);
$travelers = Traveler::model()->findAll($criteria);
if ($travelers) {
return CHtml::listData($travelers, 'id', 'name');
} else {
return false;
}
}
/**
* 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.
*/
public function loadModel($withComments=false)
{
if($this->_model===null)
{
if(isset($_GET['id']))
{
if($withComments)
{
$this->_model=Issue::model()->with(array(
'comments'=>array('with'=>'author')))->findbyPk($_GET['id']);
}
else
{
$this->_model=Issue::model()->findbyPk($_GET['id']);
}
}
if($this->_model===null)
throw new CHttpException(404,'The requested page does not exist.');
}
return $this->_model;
}
<?php
/* @var $this StaffController */
/* @var $model Staff */
$this->breadcrumbs = array('Staff' => array('index'), $model->id);
$this->menu = array(array('label' => 'List Staff', 'url' => array('index')), array('label' => 'Create Staff', 'url' => array('create')), array('label' => 'Update Staff', 'url' => array('update', 'id' => $model->id)), array('label' => 'Delete Staff', 'url' => '#', 'linkOptions' => array('submit' => array('delete', 'id' => $model->id), 'confirm' => 'Are you sure you want to delete this item?')), array('label' => 'Manage Staff', 'url' => array('admin')));
?>
<h1>View Staff #<?php
echo $model->id;
?>
</h1>
<?php
$this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('id', 'fullName', 'usrName', 'email', 'locationname', 'payrollNo')));
?>
<?php
$query = Issue::model()->findAllByAttributes(array('fk_staff' => $model->id));
$dataProvider = new CArrayDataProvider($rawData = $query);
$this->widget('zii.widgets.grid.CGridView', array('dataProvider' => $dataProvider, 'columns' => array(array('name' => 'id', 'header' => 'ID'), array('name' => 'componenttag', 'header' => 'Device TagNo'), array('name' => 'dateIssued', 'header' => 'Date Issued'), array('name' => 'dateReturned', 'header' => 'Date Returned'), array('name' => 'locationname', 'header' => 'Location'), array('name' => 'hostname', 'header' => 'HostName'))));
public function getIssueByPkFk($travelerId, $equipmentId)
{
$issue = Issue::model()->find("travelerId = {$travelerId} AND equipmentId = {$equipmentId}");
if ($issue) {
return $issue;
} else {
return null;
}
}
public function setLinks()
{
if ($this->deviceStatus == 'In Store') {
return CHtml::link("Issue", array("Issue/create", "fk_componentDetail" => $this->id));
} else {
if ($this->deviceStatus == 'In Use') {
$criteria = new CDbCriteria();
$criteria->condition = "fk_componentDetail = " . $this->id;
$criteria->order = "id desc";
$criteria->limit = 1;
$issue = Issue::model()->findAll($criteria);
if ($issue) {
return CHtml::link("Return", array("Issue/update", "id" => $issue[0]['id']));
}
} else {
return "";
}
}
}
public function getTravelerName($id)
{
$id = (int) $id;
$criteria = new CDbCriteria();
$criteria->condition = "id={$id}";
$issue = Issue::model()->find($criteria);
//$issue= Issue::model()->findByPk($id); doesnt work!why?
$traveler = Traveler::model()->findByPk($issue->travelerId);
return $traveler->name;
}
/**
* Lists all models.
*/
public function actionIndex()
{
$this->layout = "//layouts/column1";
if (isset($_GET['issueId'])) {
$issue = Issue::model()->find("id = " . $_GET['issueId']);
$dataProvider = new CActiveDataProvider('Discrepancy', array('criteria' => array('condition' => "issueId = {$issue->id}")));
$this->render('index', array('dataProvider' => $dataProvider, 'issue' => $issue));
} else {
$model = new Discrepancy('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Discrepancy'])) {
$model->attributes = $_GET['Discrepancy'];
}
$this->render('admin', array('model' => $model));
}
}
<div class="view">
<?php
$issue = Issue::model()->getIssueByPkFk($data->id, $equipmentId);
$issueId = $issue->id;
$progress = $issue->progressText;
?>
<?php
echo CHtml::link(CHtml::encode($data->name) . " (v{$data->revision})", array('issue/view', 'id' => $issueId)) . " <b>({$progress})</b>";
?>
</div>
/**
* 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 the ID of the model to be loaded
*/
public function loadModel($id, $withComments = false)
{
if ($withComments) {
$model = Issue::model()->with(array('comments' => array('with' => 'author')))->findByPk($id);
} else {
$model = Issue::model()->findByPk($id);
}
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* Remove an issue assignment for this event.
*
* @param $name
*
* @return bool
*/
public function deleteIssue($name)
{
if (!($issue = Issue::model()->find('name=?', array($name)))) {
return false;
}
foreach (EventIssue::model()->findAll('event_id=? and issue_id = ?', array($this->id, $issue->id)) as $event_issue) {
$event_issue->delete();
}
return true;
}
public function actionCloseout($id)
{
$model = $this->loadModel($id);
$model->status = 0;
$model->scenario = 'closeout';
$issue = Issue::model()->find("id =" . $model->issueId);
if (!$issue) {
throw new CHttpException(404, 'The requested page does not exist.');
}
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Nonconformity'])) {
$model->attributes = $_POST['Nonconformity'];
$model->closedById = Yii::app()->user->id;
$model->closedTime = new CDbExpression('NOW()');
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('closeout', array('model' => $model, 'issue' => $issue));
}
<?php
/* @var $this LocationController */
/* @var $model Location */
$this->breadcrumbs = array('Locations' => array('index'), $model->name);
$this->menu = array(array('label' => 'List Location', 'url' => array('index')), array('label' => 'Create Location', 'url' => array('create')), array('label' => 'Update Location', 'url' => array('update', 'id' => $model->id)), array('label' => 'Delete Location', 'url' => '#', 'linkOptions' => array('submit' => array('delete', 'id' => $model->id), 'confirm' => 'Are you sure you want to delete this item?')), array('label' => 'Manage Location', 'url' => array('admin')));
?>
<h1>View Location #<?php
echo $model->id;
?>
</h1>
<?php
$this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('id', 'name')));
?>
<?php
$query = Issue::model()->findAllByAttributes(array('fk_location' => $model->id));
$dataProvider = new CArrayDataProvider($rawData = $query);
$this->widget('zii.widgets.grid.CGridView', array('dataProvider' => $dataProvider, 'columns' => array(array('name' => 'id', 'header' => 'ID'), array('name' => 'componenttag', 'header' => 'Device TagNo'), array('name' => 'staffname', 'header' => 'Staff Name'), array('name' => 'dateIssued', 'header' => 'Date Issued'), array('name' => 'dateReturned', 'header' => 'Date Returned'), array('name' => 'hostname', 'header' => 'HostName'))));
<?php
/* @var $this ComponentdetailController */
/* @var $model Componentdetail */
$this->breadcrumbs = array('Component Details' => array('index'), $model->id);
$this->menu = array(array('label' => 'List Component Details', 'url' => array('index')), array('label' => 'Create Component Details', 'url' => array('create')), array('label' => 'Update Component Details', 'url' => array('update', 'id' => $model->id)), array('label' => 'Delete Component Details', 'url' => '#', 'linkOptions' => array('submit' => array('delete', 'id' => $model->id), 'confirm' => 'Are you sure you want to delete this item?')), array('label' => 'Manage Component Details', 'url' => array('admin')));
?>
<h1>View Componentdetail #<?php
echo $model->id;
?>
</h1>
<?php
$this->widget('zii.widgets.CDetailView', array('data' => $model, 'attributes' => array('id', 'componenttypename', 'tagNo', 'serialNo', 'description', 'project', 'suppliername', 'lpoNo', 'purchaseDate', 'purchaseValue', 'deviceStatus', 'comment', 'note')));
?>
<?php
$query = Issue::model()->findAllByAttributes(array('fk_componentDetail' => $model->id));
$dataProvider = new CArrayDataProvider($rawData = $query);
$this->widget('zii.widgets.grid.CGridView', array('dataProvider' => $dataProvider, 'columns' => array(array('name' => 'id', 'header' => 'ID'), array('name' => 'staffname', 'header' => 'Staff Name'), array('name' => 'dateIssued', 'header' => 'Date Issued'), array('name' => 'dateReturned', 'header' => 'Date Returned'), array('name' => 'locationname', 'header' => 'Location'), array('name' => 'hostname', 'header' => 'HostName'))));
public function init()
{
$this->issues = Issue::model()->findmyIssues();
}
/**
* Gets Previous Minutes.
*/
private function getPreviousMinutes($id_rapat)
{
$criteria = new CDbCriteria();
$criteria->params = array(':userName' => $value1, ':email' => $value2);
$usermodel = User::model()->find($criteria);
$criteria = new CDbCriteria();
$criteria->join = 'inner join agenda_rapat on agenda.id=id_agenda';
$criteria->condition = "status='IPG' OR status='OPN' OR status='PND' AND ";
$models = Issue::model()->with('subjects', 'voteCount')->findAll($criteria);
$prevMinutes = AgendaRapat::model()->findAllByAttributes(array('id_rapat' => $id_rapat));
return $prevMinutes;
}
public function getEquipment()
{
return Issue::model()->find("id = {$this->issueId}")->equipment;
}
?>
<ul>
<?php
}
?>
<li><span class='equipment'><?php
echo CHtml::link($ename, array('view', 'id' => $eid));
?>
</span>
<?php
if ($travelers) {
echo "<ul>";
foreach ($travelers as $traveler) {
$issue = Issue::model()->getIssueByPkFk($traveler->id, $eid);
$issueId = $issue->id;
?>
<li><span class='file'><?php
echo CHtml::link(CHtml::encode($traveler->name) . " (v{$traveler->revision})", array('issue/view', 'id' => $issueId));
?>
</span></li>
<?php
}
echo "</ul>";
}
?>
</li>
<?php
$componentId = $cid;
$ul = "</ul></li>";
/**
* Lists all models.
*/
public function actionIndex()
{
$this->layout = "//layouts/column1";
$issue = null;
if (isset($_GET['issueId'])) {
$issueId = $_GET['issueId'];
$issue = Issue::model()->find("id = {$issueId}");
} else {
throw new CHttpException(404, 'The requested page does not exist.');
}
$dataProvider = new CActiveDataProvider('Comment', array('criteria' => array('condition' => "issueId = {$issueId}", 'order' => 'stepId')));
$this->render('index', array('dataProvider' => $dataProvider, 'issue' => $issue));
}
/**
* 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));
}
