public function testDepths()
{
$project_data = new ProjectData();
$depths = $project_data->getDepths(1);
$this->assertNotNull($depths);
print_r($depths);
}
public function excelExport($project_id)
{
PHPExcel_CachedObjectStorageFactory::cache_in_memory_serialized;
$objPHPExcel = new PHPExcel();
$objPHPExcel->createSheet(0);
$objPHPExcel->setActiveSheetIndex(0);
//设置第一个内置表
$objActSheet = $objPHPExcel->getActiveSheet();
// 获取当前活动的表
$objActSheet->setTitle('项目总体数据表');
//获取项目下的所有成员id
$examinee = $this->modelsManager->createBuilder()->columns(array('number', 'id', 'state', 'name'))->from('Examinee')->where('Examinee.type = 0 AND Examinee.project_id = ' . $project_id)->getQuery()->execute()->toArray();
//异常处理
if (empty($examinee)) {
throw new Exception('项目的被试人数为0,无法进行项目数据表生成');
}
$members_not_finished = array();
foreach ($examinee as $value) {
if ($value['state'] < 4) {
$members_not_finished[$value['number']] = $value['name'];
}
}
if (!empty($members_not_finished)) {
$list = '项目中部分成员未完成测评过程，如下:<br/>';
foreach ($members_not_finished as $key => $value) {
$list .= $key . '：' . $value . '<br/>';
}
throw new Exception(print_r($list, true));
}
$i = 0;
$result = new ProjectData();
$start_column = 'D';
$last = 'D';
$last_data = null;
foreach ($examinee as $examinee_info) {
$data = array();
$data = $result->getindividualComprehensive($examinee_info['id']);
if ($i === 0) {
$this->makeTable($data, $objActSheet);
}
$last = $start_column;
$last_data = $data;
$this->joinTable($data, $objActSheet, $start_column++, $examinee_info['number']);
$i++;
}
// 计算平均值
$this->joinAvg($objActSheet, $last_data, 'D', $last);
//根据项目第一人成绩统计打表
//循环写入每个人的成绩
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
$file_name = './tmp/' . $project_id . '_project_data.xls';
$objWriter->save($file_name);
return $file_name;
}
function indexAction()
{
$view = $this->getView();
$view->assign('home', true);
$view->assign('site_title', 'CalPalyn: Quaternary Paleoecology Lab');
// call project model
$rows = Project::Q()->exec();
//Not the most efficient but since there are handful of users
$users = User::Q()->exec();
foreach ($users as $user) {
$u[$user->id] = array('email' => $user->email, 'first_name' => $user->first_name);
}
error_log(print_r($rows, true));
foreach ($rows as $row) {
$d[] = array('id' => $row->id, 'name' => $row->name, 'user_info' => "<a class='tip' name='#'>" . $u[$row->created_by]['first_name'] . "<span>" . $u[$row->created_by]['email'] . "</span></a>", 'desc' => $row->description);
$p[$row->id] = array('name' => $row->name, 'description' => $row->description);
error_log(print_r($d, true));
}
$view->assign('projects', $d);
$view->assign('projects_info', $p);
// Get list of taxons
Pfw_Loader::loadModel('Taxon');
$txs = Taxon::Q()->exec();
//objp($txs);
foreach ($txs as $t) {
$taxons[$t->type] = $t->name;
}
//objp($taxons);
error_log("Taxons are " . print_r($taxons, true));
$view->assign('taxons', $taxons);
if (isset($_REQUEST['pid']) and !empty($_REQUEST['pid'])) {
Pfw_Loader::loadModel('ProjectData');
$key_data = ProjectData::Q()->getKeyValuesForProject($_REQUEST['pid']);
$chart_data = $key_data['chart_data'];
foreach ($chart_data as $cdk => $cdv) {
$depth_values = array_keys($cdv);
$taxon_values = array_values($cdv);
$chart_values[$cdk] = array('depth_min' => min($depth_values), 'depth_max' => max($depth_values), 'taxon_min' => min($taxon_values), 'taxon_max' => max($taxon_values), 'depths' => self::_extendedEncode($depth_values, max($depth_values)), 'taxon_values' => self::_extendedEncode($taxon_values, max($taxon_values)));
}
#objp($chart_values);
$view->assign('chart_data', $chart_values);
$view->assign('field_names', $key_data['field_names']);
$view->assign('project_data', $key_data['data']);
$view->assign('project_id', $_REQUEST['pid']);
$view->assign('depths', $key_data['depths']);
$view->assign('debug', print_r($view->get_template_vars(), true));
}
$view->display(array('layout' => 'layouts/main.tpl', 'body' => 'home/index.tpl'));
}
public function getProject()
{
return ProjectData::getById($this->project_id);
}
<?php
$category = ProjectData::getById($_GET["id"]);
$category->del();
Core::redir("./index.php?view=projects");
<?php
$pacients = ProjectData::getAll();
$medics = CategoryData::getAll();
?>
<div class="row">
<div class="col-md-10">
<h1>Nueva Tarea</h1>
<form class="form-horizontal" role="form" method="post" action="./?action=addtask">
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">Titulo</label>
<div class="col-lg-10">
<input type="text" name="title" required class="form-control" id="inputEmail1" placeholder="Titulo">
</div>
</div>
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">Descripcion</label>
<div class="col-lg-10">
<textarea class="form-control" rows="5" name="description" placeholder="Descripcion"></textarea>
</div>
</div>
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">Proyecto</label>
<div class="col-lg-4">
<select name="project_id" class="form-control">
<option value="">-- SELECCIONE --</option>
<?php
foreach ($pacients as $p) {
?>
<?php
$user = ProjectData::getById($_GET["id"]);
?>
<div class="row">
<div class="col-md-12">
<h1>Editar Ministerio</h1>
<br>
<form class="form-horizontal" method="post" id="addproduct" action="index.php?view=updateproject" role="form">
<div class="form-group">
<label for="inputEmail1" class="col-lg-2 control-label">Nombre*</label>
<div class="col-md-6">
<input type="text" name="name" value="<?php
echo $user->name;
?>
" class="form-control" id="name" placeholder="Nombre">
</div>
</div>
<div class="form-group">
<div class="col-lg-offset-2 col-lg-10">
<input type="hidden" name="user_id" value="<?php
echo $user->id;
?>
">
<button type="submit" class="btn btn-primary">Actualizar Proyecto</button>
</div>
</div>
</form>
<div class="row">
<div class="col-md-12">
<div class="btn-group pull-right">
<a href="index.php?view=newproject" class="btn btn-default"><i class='fa fa-th-list'></i> Nuevo Ministerio</a>
</div>
<h1>Ministerios</h1>
<br>
<?php
$users = ProjectData::getAll();
if (count($users) > 0) {
// si hay usuarios
?>
<table class="table table-bordered table-hover">
<thead>
<th>Nombre</th>
<th>Opciones</th>
</thead>
<?php
foreach ($users as $user) {
?>
<tr>
<td><?php
echo $user->name . " " . $user->lastname;
?>
</td>
<td style="width:190px;"><a href="index.php?view=projecthistory&id=<?php
echo $user->id;
?>
" class="btn btn-default btn-xs">Historial</a> <a href="index.php?view=editproject&id=<?php
echo $user->id;
<?php
$pacient = ProjectData::getById($_GET["id"]);
?>
<div class="row">
<div class="col-md-12">
<div class="btn-group pull-right">
<!--<div class="btn-group pull-right">
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
<i class="fa fa-download"></i> Descargar <span class="caret"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a href="report/clients-word.php">Word 2007 (.docx)</a></li>
</ul>
</div>
-->
</div>
<h1>Historial de Eventos</h1>
<h4>Ministerio: <?php
echo $pacient->name;
?>
</h4>
<br>
<?php
$users = EventData::getAllByProjectId($_GET["id"]);
if (count($users) > 0) {
// si hay usuarios
?>
<table class="table table-bordered table-hover">
<thead>
<?php
if (count($_POST) > 0) {
$user = ProjectData::getById($_POST["user_id"]);
$user->name = $_POST["name"];
$user->update();
print "<script>window.location='index.php?view=projects';</script>";
}
<?php
if (count($_POST) > 0) {
$user = new ProjectData();
$user->name = $_POST["name"];
$user->add();
print "<script>window.location='index.php?view=projects';</script>";
}
public function __construct($directory, $cli, $regex)
{
parent::__construct($directory, $cli, $regex);
$this->_regex = $regex;
}
