PHP Requirement::model方法代码示例

 public function actionIndex()
 {
     Yii::beginProfile('requirements');
     $criteria = RequirementApi::getCriteriaObjectForUser(Yii::app()->user->id);
     $totalRequirements = Requirement::model()->count($criteria);
     $pages = new CPagination($totalRequirements);
     $pages->pageSize = Yii::app()->params['resultsPerPage'];
     $pages->applyLimit($criteria);
     $requirements = RequirementApi::searchMyRequirementWithCriteria($criteria);
     //$requirements=RequirementApi::getRequirementByUserId(Yii::app()->user->id);
     $this->render('index', array('requirements' => $requirements, 'pages' => $pages, 'totalRequirements' => $totalRequirements));
     Yii::endProfile('requirements');
 }

function requirement_row($req, $indentation, TableCreator $table_creator, $filter_cat, $filter_pri)
{
    $ret = "";
    if ((!is_numeric($filter_cat) || $req->category == $filter_cat) && (!is_numeric($filter_pri) || $req->priority == $filter_pri)) {
        $pkg_name = array();
        foreach ($req->classes as $c) {
            array_push($pkg_name, $table_creator->link($c->full_name(), $c->name));
        }
        array_unique($pkg_name);
        sort($pkg_name);
        $cells = array($table_creator->child_indentation($indentation), $table_creator->link($req->public_id(), $req->public_id()), implode("\n\n", $pkg_name));
        $ret .= $table_creator->row($cells);
    }
    $nested = Requirement::model()->with('classes')->findAll("t.parent=:parent", array(':parent' => $req->id_requirement));
    foreach ($nested as $nreq) {
        $ret .= requirement_row($nreq, $indentation + 1, $table_creator, $filter_cat, $filter_pri);
    }
    return $ret;
}

 public function actionRequirementHandle()
 {
     if (parent::_ajax_acl('evaluate_update')) {
         $id = Yii::app()->request->getPost('id');
         $requirement = Requirement::model()->findByPk($id);
         if (!empty($requirement)) {
             $requirement->status = 1;
             if ($requirement->save()) {
                 AdminLogger::_create(array('catalog' => 'update', 'intro' => '更新学区专栏房源需求处理状态，ID:' . $requirement->id));
                 echo CJSON::encode(array('success' => true, 'msg' => '需求处理成功'));
             } else {
                 echo CJSON::encode(array('success' => false, 'msg' => '操作失败，请联系管理员'));
             }
         } else {
             echo CJSON::encode(array('success' => false, 'msg' => '此需求不存在'));
         }
     } else {
         echo CJSON::encode(array('success' => false, 'msg' => '当前角色组无权限进行此操作，请联系管理员授权'));
     }
 }

function requirement_row($req, $indentation, TableCreator $table_creator, $filter_cat, $filter_pri)
{
    $ret = "";
    if ((!is_numeric($filter_cat) || $req->category == $filter_cat) && (!is_numeric($filter_pri) || $req->priority == $filter_pri)) {
        $source_desc = array();
        foreach ($req->sources as $rc) {
            $rc->with('useCase', 'externalSource');
            if (isset($rc->useCase)) {
                array_push($source_desc, $table_creator->link($rc->useCase->public_id(), $rc->useCase->public_id()));
            } else {
                array_push($source_desc, $rc->externalSource->description);
            }
        }
        sort($source_desc);
        $cells = array($table_creator->child_indentation($indentation), $table_creator->anchor($req->public_id(), $req->public_id()), $req->category0->name . "\n\n" . $req->priority0->name, $req->description, implode("\n\n", $source_desc));
        $ret .= $table_creator->row($cells);
    }
    $nested = Requirement::model()->with('sources', 'category0', 'priority0')->findAll("t.parent=:parent", array(':parent' => $req->id_requirement));
    foreach ($nested as $nreq) {
        $ret .= requirement_row($nreq, $indentation + 1, $table_creator, $filter_cat, $filter_pri);
    }
    return $ret;
}

 /**
  * This method gets userId and array of data from user. 
  * Returns model if update successful
  * Returns null if creation fails
  ** Data arrary should have the following Hash keys
  *  string $i_want_to
  *  string $description
  *  double $covered_area_from
  *  double $covered_area_to
  *  double $plot_area_from
  *  double $plot_area_to
  *  double $min_price
  *  double $max_price
  *
  * @param int $userId,array $data
  * @return model|false
  */
 public static function updateRequirement($userId, $data)
 {
     $specialist = Requirement::model()->find('user_id=:userId', array(':userId' => $userId));
     if ($specialist) {
         $specialist->attributes = $data;
         $specialist->save();
         return $specialist;
     } else {
         return false;
     }
 }

<?php

$cats = RequirementCategory::model()->findAll();
$pris = RequirementPriority::model()->findAll();
$titles = array("Categoria");
foreach ($pris as $p) {
    array_push($titles, $p->name);
}
$table = $table_creator->begin_table(count($pris) + 1) . $table_creator->heading_row($titles);
foreach ($cats as $c) {
    $row = array($c->name);
    foreach ($pris as $p) {
        array_push($row, Requirement::model()->count("priority=:p and category=:c", array("p" => $p->id_priority, "c" => $c->id_category)));
    }
    $table .= $table_creator->row($row);
}
$table .= $table_creator->caption("Riepilogo requisiti") . $table_creator->end_table();
if ($table_creator->id() != 'html' && !$raw) {
    echo CodeGen::generic_render_code($table, 'latex', true);
} else {
    echo $table;
}

    echo CHtml::dropDownList("priority", $filter_pri, $pris);
    echo "<br/>";
    echo CHtml::submitButton("Filter");
    echo "</form></div>";
    echo "<hr/>";
}
function test_row(Requirement $req, $indentation, TableCreator $table_creator, $filter_cat, $filter_pri)
{
    $test = $req->with('system_test')->system_test;
    $ret = "";
    if (isset($req->system_test) && (!is_numeric($filter_cat) || $req->category == $filter_cat) && (!is_numeric($filter_pri) || $req->priority == $filter_pri)) {
        $test->with('test');
        $ret .= $table_creator->row(array($test->public_id(), $test->test->description, 'success', $table_creator->anchor($req->public_id(), $req->public_id())));
    }
    $nested = $req->with('requirements')->requirements;
    foreach ($nested as $nreq) {
        $ret .= test_row($nreq, $indentation + 1, $table_creator, $filter_cat, $filter_pri);
    }
    return $ret;
}
$table = $table_creator->begin_table("|l|p{6cm}|l|l|") . $table_creator->heading_row(array("Test", "Descrizione", "Stato", "Requisito"));
$toplevel = Requirement::model()->with('sources')->findAll("t.parent is null");
foreach ($toplevel as $req) {
    $table .= test_row($req, 0, $table_creator, $filter_cat, $filter_pri);
}
$table .= $table_creator->caption("Tabella di tracciamento test di sistema / requisiti") . $table_creator->end_table();
if ($table_creator->id() != 'html' && !$raw) {
    echo CodeGen::generic_render_code($table, 'latex', true);
} else {
    echo $table;
}

<?php

/// @warning HARD CODED DB PK!!!!!!!!!!!
$reqs = Requirement::model()->findAll("category != 4 and priority != 4");
$table = $table_creator->begin_table("|m{3cm}|m{6cm}|m{4cm}|") . $table_creator->heading_row(array("Id", "Descrizione", "Implementazione"));
foreach ($reqs as $r) {
    $id = $r->public_id();
    $app = $r->apported;
    $strapp = "";
    if ($app) {
        $strapp = "\\color{dkgreen}{Implementato}";
    } else {
        $strapp = "\\color{dkred}{Non implementato}";
    }
    $table .= $table_creator->row(array($id, $r->description, $strapp));
}
$table .= $table_creator->caption("Tabella implementazione requisiti opzionali e desiderabili") . $table_creator->end_table();
if ($table_creator->id() != 'html' && !$raw) {
    echo CodeGen::generic_render_code($table, 'latex', true);
} else {
    echo $table;
}

 /**
  * 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)
 {
     $model = Requirement::model()->findByPk($id);
     $model->with('category0', 'priority0', 'parent0', 'sources', 'validation0', 'system_test');
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }

 /**
  * 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)
 {
     $model = Requirement::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }

<?php

function req_row(Requirement $req, $indentation, TableCreator $table_creator)
{
    $req->with('validationTest', 'requirements');
    $ret = "";
    $ret .= $table_creator->row(array($table_creator->child_indentation($indentation), $req->public_id(), $req->validationTest == null ? '' : $req->validationTest->public_id()));
    $nested = $req->requirements;
    foreach ($nested as $c) {
        $ret .= req_row($c, $indentation + 1, $table_creator);
    }
    return $ret;
}
$toplevel = Requirement::model()->findAll("t.parent is null");
$table = $table_creator->begin_table("|r l|l|") . $table_creator->heading_row(array("Requisito" => 2, "Validazione"));
foreach ($toplevel as $req) {
    $table .= req_row($req, 0, $table_creator);
}
$table .= $table_creator->caption("Tabella requisiti / test validazione") . $table_creator->end_table();
if ($table_creator->id() != 'html' && !$raw) {
    echo CodeGen::generic_render_code($table, 'latex', true);
} else {
    echo $table;
}