public function editAction()
{
list(, , , $id) = explode('/', $this->getURI());
if (!($report = Report::find(intval($id)))) {
return $this->alert('找不到', '/');
}
$this->view->report = $report;
if ($_POST) {
if ($_POST['sToken'] != Helper::getStoken()) {
return $this->alert('sToken 錯誤', '/');
}
if ($_POST['delete']) {
if (!strval($_POST['deleted_reason'])) {
return $this->alert('請輸入刪除原因', '/index/edit/' . $report->id);
}
}
try {
$this->_checkReportData($_POST);
} catch (Exception $e) {
return $this->alert($e->getMessage(), '/');
}
$old_values = $report->toArray();
$now = time();
$report->update(array('news_title' => strval($_POST['news_title']), 'news_link' => strval($_POST['news_link']), 'report_title' => strval($_POST['report_title']), 'report_link' => strval($_POST['report_link']), 'updated_at' => $now, 'deleted_at' => intval($_POST['delete']) ? $now : 0));
$new_values = $report->toArray();
if ($_POST['delete']) {
$new_values['deleted_reason'] = strval($_POST['deleted_reason']);
}
if ($new_values != $old_values) {
ReportChangeLog::insert(array('report_id' => $report->id, 'updated_at' => $now, 'updated_from' => intval(ip2long($_SERVER['REMOTE_ADDR'])), 'updated_by' => strval($this->view->user->user_id), 'old_values' => json_encode($old_values), 'new_values' => json_encode($new_values)));
}
return $this->alert('修改成功', '/index/log/' . $report->id);
}
}
/**
* lrs/{id}/reporting/create
*
* This test case create new reporting and run report
*
* It is ensure reporting work correctly.
* */
public function testRouterReportCreate()
{
for ($i = 0; $i < 7; $i++) {
$vs = $this->defaultStatment();
$this->statements[] = $this->createStatement($vs, $this->lrs);
}
$data = array('description' => \app\locker\helpers\Helpers::getRandomValue(), 'name' => '', 'lrs' => $this->lrs->_id, 'query' => array('statement.actor.mbox' => array("mailto:duy.nguyen@go1.com.au"), 'statement.verb.id' => array("http://adlnet.gov/expapi/verbs/experienced")));
//lrs input validation
$rules['name'] = 'required|alpha_spaces';
$rules['description'] = 'alpha_spaces';
$validator = Validator::make($data, $rules);
$this->assertTrue($validator->fails());
$data['name'] = 'reportabcd';
$data['description'] = 'reportabcd description';
$validator = Validator::make($data, $rules);
$this->assertTrue($validator->passes());
// create report.
$report = new Report();
$report->lrs = $data['lrs'];
$report->query = $data['query'];
$report->name = $data['name'];
$report->description = $data['description'];
$save = $report->save();
$this->assertTrue($save);
// Ensure report show in reporting page.
$crawler = $this->client->request('GET', "/lrs/{$this->lrs->_id}/reporting");
$this->assertGreaterThan(0, $crawler->filter('html:contains("reportabcd")')->count());
$this->assertGreaterThan(0, $crawler->filter('html:contains("reportabcd description")')->count());
$crawler = $this->client->request('GET', "/lrs/{$this->lrs->_id}/reporting/show/{$report->_id}");
$this->assertGreaterThan(0, $crawler->filter('html:contains("Number of statements")')->count());
$this->assertGreaterThan(0, $crawler->filter('html:contains("7")')->count());
// Delete report by router.
$crawler = $this->client->request('DELETE', "/lrs/{$this->lrs->_id}/reporting/delete/{$report->_id}");
$this->assertEquals(Report::find($report->_id), NULL);
}
/**
** Function to plot graphs
***/
public function index()
{
if (isset($_POST) && !empty($_POST['datepickerfrom']) && !empty($_POST['datepickerto'])) {
$datefrom = $_POST['datepickerfrom'];
$dateto = $_POST['datepickerto'];
}
$projectsArray = Project::all();
/**Get all projects from databa se */
$result_array = Report::all();
if (!empty($result_array)) {
foreach ($result_array as $key => $res) {
$project[$key]['name'] = $res['name'];
$projects[$key]['id'] = $res['id'];
}
} else {
echo '<p class="error_msg">No data available in this range</p> <p>Please click <a href="?controller=pages&action=reportdata">Report</a> to select another range</p>';
exit;
}
$date_range = $this->getDatesFromRange($datefrom, $dateto);
$xaxis_data = json_encode($date_range);
for ($rs = 0; $rs < count($project); $rs++) {
foreach ($date_range as $dt) {
$bugs[$rs] = Report::find($projects[$rs]['id'], $dt);
$project[$rs]['data'][] = intval($bugs[$rs][$projects[$rs]['id']]['bugs']);
}
}
$result_array = json_encode($project);
require_once 'views/reports/index.php';
}
public function initialize()
{
$this->add(new Text('code', array('maxlength' => 100, 'required' => 'required', 'autofocus' => 'autofocus', 'class' => 'form-control')));
$this->add(new Text('name', array('maxlength' => 100, 'required' => 'required', 'class' => 'form-control')));
$this->add(new TextArea('description', array('maxlength' => 400, 'required' => 'required', 'class' => 'form-control')));
$this->add(new Check('status', array('type' => 'checkbox', 'class' => 'bootstrap-switch')));
$this->add(new Select('reports[]', Report::find(), array('using' => array('idReport', 'name'), 'multiple' => 'multiple', 'class' => 'select2')));
}
public function action_do_update()
{
$report = Report::find(Input::get('report_id'));
$v = Report::validate(Input::all());
if ($v->fails()) {
return Redirect::to_route('update_report', Input::get('report_id'))->with('user', Auth::user())->with_errors($v)->with_input();
}
$report->date = Input::get('date');
$report->description = Input::get('description');
$report->time_spent = Input::get('time_spent');
$report->project_id = Input::get('project_id');
$report->save();
return Redirect::to_route('update_report', array(Input::get('report_id')));
}
public function getReports()
{
return Report::find(['conditions' => ['did' => $this->getId()]]);
}
if ($round == null) {
App::abort(404);
} else {
return $round;
}
});
Route::bind('scenario', function ($key, $route) {
$round = Scenario::find($key);
if ($round == null) {
App::abort(404);
} else {
return $round;
}
});
Route::bind('report', function ($key, $route) {
$report = Report::find($key);
if ($report == null) {
App::abort(404);
} else {
return $report;
}
});
Route::group(array('before' => 'auth'), function () {
Route::get('logout', 'UsersController@logout');
Route::get('tournaments/create', 'TournamentsController@getCreate');
Route::post('tournaments/create', 'TournamentsController@postCreate');
Route::post('tournaments/{tournament}/update', 'TournamentsController@postUpdate');
Route::get('tournaments/{tournament}/delete', 'TournamentsController@delete');
Route::get('maps', 'MapsController@listing');
Route::get('maps/create', 'MapsController@getCreate');
Route::post('maps/create', 'MapsController@postCreate');
public function editAction($id)
{
$payment = Paymentplan::findFirst(array("conditions" => "idPaymentplan = ?1", "bind" => array(1 => $id)));
if (!$payment) {
$this->flashSession->warning('El plan de pago que desea editar no existe, por favor valide la información');
return $this->response->redirect('Paymentplan');
}
$form = new PaymentplanForm($payment);
$pxr = Pxr::findByIdPaymentplan($payment->idPaymentplan);
if ($this->request->isPost()) {
$form->bind($this->request->getPost(), $payment);
$reports = $form->getValue('reports');
if ($this->validateReports($reports)) {
$status = $form->getValue('status');
$status = trim($status);
try {
$this->db->begin();
$payment->status = empty($status) || !$status ? 0 : 1;
$payment->updated = time();
if ($form->isValid() && $payment->save()) {
if ($this->deletePxr($pxr)) {
if ($this->savePxr($payment)) {
$this->db->commit();
$this->flashSession->success('Se ha editado el plan de pago exitosamente');
return $this->response->redirect("Paymentplan");
}
}
}
foreach ($payment->getMessages() as $msg) {
$this->flashSession->error($msg)->getMessage();
}
} catch (Exception $ex) {
$this->db->rollback();
$this->logger->log("Exception while creatin payment plan... {$ex}");
$this->flashSession->error("Ha ocurrido un error, por favor contacte al administrador");
}
}
}
$reports = Report::find();
$this->view->PaymentplanForm = $form;
$this->view->setVar("payment", $payment);
$this->view->setVar("reports", $reports);
$this->view->setVar("pxr", $pxr);
}
function adminreportimagesAction()
{
$this->_helper->layout->setLayout("layout_admin");
if ($this->_request->getParam('report')) {
$this->_helper->layout->disableLayout();
$reportModel = new Report();
$report = $reportModel->find($this->_request->getParam('report'))->current();
//get new report
$config = Zend_Registry::get('config');
$url = $config->indicate2->home . "/report/showAnswer/accessCode/" . $report['accesscode'];
$this->view->url = $url;
$this->view->url = $url;
die($url);
} else {
$campaignModel = new Campaign();
$campaigns = $campaignModel->fetchAll();
$campaignsArray = array();
foreach ($campaigns as $val) {
$campaignsArray[$val->id] = $val->name;
}
$db = Zend_Registry::get('db');
$select = $db->select();
$select->from('report_images', array('report_images.name as images'));
$select->join('report', 'report.id = report_images.report', array('report.campaign_id as campaign', 'report.id as report'));
$select->join('consumer', 'consumer.id = report_images.consumer', array('consumer.name', 'consumer.email', 'consumer.phone'));
$select->order('report.campaign_id desc');
$this->view->reportImages = $db->fetchAll($select);
$this->view->campaigns = $campaignsArray;
}
}
public function populate()
{
$reportID = Input::get('reportID');
$editReport = Report::find($reportID);
return $editReport->toJson();
}
/**
* Get all Law Report types in the System
* @return array
*/
public function reports()
{
return Report::find()->toArray();
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$value = json_decode(Report::find($id)->value);
echo Form::open(array("url" => url("reports/download"), "class" => "form-horizontal", "id" => 'formms'));
foreach ($value as $key => $val) {
?>
<input type="hidden" name="<?php
echo $key;
?>
" value="<?php
echo $val;
?>
"
xmlns="http://www.w3.org/1999/html">
<?php
}
?>
<div class="col-xs-12" style="margin-top: 5px">
<div style="margin: 10px;margin-left: 0px" class="col-md-1 btn btn-default btn-sm" id="records"><img src="<?php
echo asset('table.png');
?>
" style="height: 20px;width: 20px" /> Records</div>
<div style="margin: 10px" class="col-md-1 btn btn-default btn-sm" id="table"><img src="<?php
echo asset('table.png');
?>
" style="height: 20px;width: 20px" /> Table</div>
<div style="margin: 10px" class="col-md-1 btn btn-default btn-sm" id="bar"><img src="<?php
echo asset('bar.png');
?>
" style="height: 20px;width: 20px" /> Bar</div>
<div style="margin: 10px" class="col-md-1 btn btn-default btn-sm" id="line"><img src="<?php
echo asset('line.png');
?>
" style="height: 20px;width: 20px" /> Line</div>
<div style="margin: 10px" class="col-md-1 btn btn-default btn-sm" id="column"><img src="<?php
echo asset('column.png');
?>
" style="height: 20px;width: 20px" /> Column</div>
<div style="margin: 10px" class="col-md-1 btn btn-default btn-sm" id="combined"><img src="<?php
echo asset('combined.jpg');
?>
" style="height: 20px;width: 20px" /> Combined</div>
<button name="records" style="margin: 10px" type="submit" class="col-md-1 btn btn-default btn-sm"><img src="<?php
echo asset('cvs.jpg');
?>
" style="height: 20px;width: 20px" /> Records</button>
<button name='reports' style="margin: 10px" type="submit" class="col-md-1 btn btn-default btn-sm"><img src="<?php
echo asset('cvs.jpg');
?>
" style="height: 20px;width: 20px" /> Reports</button>
</div>
</form>
<div id="chartarea" class="col-xs-12" style="margin-top: 10px"></div>
<script>
//managing chats buttons
$("#table").unbind("click").click(function(){
$(".btn").removeClass("btn-info")
$(this).addClass("btn-info")
$("#chartarea").html("<h3><i class='fa fa-spin fa-spinner '></i><span>Loading...</span><h3>");
$("#formms").ajaxSubmit({
url:"<?php
echo url('report/general/table');
?>
",
target: '#chartarea',
data: {chat:'table'},
success: afterSuccess
});
});
$("#table").trigger("click");
$("#pie").unbind("click").click(function(){
$(".btn").removeClass("btn-info")
$(this).addClass("btn-info")
$("#chartarea").html("<h3><i class='fa fa-spin fa-spinner '></i><span>Loading...</span><h3>");
$("#formms").ajaxSubmit({
url:"<?php
echo url('report/general/pie');
?>
",
target: '#chartarea',
data: {chat:'table'},
success: afterSuccess
});
});
$("#bar").unbind("click").click(function(){
$(".btn").removeClass("btn-info")
$(this).addClass("btn-info")
$("#chartarea").html("<h3><i class='fa fa-spin fa-spinner '></i><span>Loading...</span><h3>");
$("#formms").ajaxSubmit({
url:"<?php
echo url('report/general/bar');
?>
",
target: '#chartarea',
data: {chat:'table'},
success: afterSuccess
});
});
$("#combined").unbind("click").click(function(){
$(".btn").removeClass("btn-info")
$(this).addClass("btn-info")
$("#chartarea").html("<h3><i class='fa fa-spin fa-spinner '></i><span>Loading...</span><h3>");
$("#formms").ajaxSubmit({
url:"<?php
echo url('report/general/combined');
?>
",
target: '#chartarea',
data: {chat:'table'},
success: afterSuccess
});
});
$("#records").unbind("click").click(function(){
$(".btn").removeClass("btn-info")
$(this).addClass("btn-info")
$("#chartarea").html("<h3><i class='fa fa-spin fa-spinner '></i><span>Loading...</span><h3>");
$("#formms").ajaxSubmit({
url:"<?php
echo url('report/general/records');
?>
",
target: '#chartarea',
data: {chat:'table'},
success: afterSuccess
});
});
$("#excel").unbind("click").click(function(){
$(".btn").removeClass("btn-info")
$(this).addClass("btn-info")
$("#chartarea").html("<h3><i class='fa fa-spin fa-spinner '></i><span>Loading...</span><h3>");
$("#formms").ajaxSubmit({
url:"<?php
echo url('reports/download');
?>
",
target: '#chartarea',
data: {chat:'table'},
success: afterSuccess
});
});
$("#column").unbind("click").click(function(){
$(".btn").removeClass("btn-info")
$(this).addClass("btn-info")
$("#chartarea").html("<h3><i class='fa fa-spin fa-spinner '></i><span>Loading...</span><h3>");
$("#formms").ajaxSubmit({
url:"<?php
echo url('report/general/column');
?>
",
target: '#chartarea',
data: {chat:'table'},
success: afterSuccess
});
});
$("#line").unbind("click").click(function(){
$(".btn").removeClass("btn-info")
$(this).addClass("btn-info")
$("#chartarea").html("<h3><i class='fa fa-spin fa-spinner '></i><span>Loading...</span><h3>");
$("#formms").ajaxSubmit({
url:"<?php
echo url('report/general/line');
?>
",
target: '#chartarea',
data: {chat:'table'},
success: afterSuccess
});
});
function afterSuccess(){
}
</script>
<?php
}
private function sendStats()
{
$stats = array();
// Website
$stats['Website']['url'] = Router::url('/', true);
$stats['Website']['version'] = Configure::read('mushraider.version');
$stats['Website']['php'] = phpversion();
$stats['Website']['lang'] = Configure::read('Settings.language');
// Events
App::uses('Event', 'Model');
$EventModel = new Event();
$params = array();
$params['recursive'] = -1;
$params['order'] = array('time_start ASC');
if ($firstEvent = $EventModel->find('first', $params)) {
$stats['Event']['first'] = $firstEvent['Event']['time_start'];
} else {
$stats['Event']['first'] = null;
}
$params['conditions']['time_start <='] = date('Y-m-d');
$params['order'] = array('time_start DESC');
if ($lastEvent = $EventModel->find('first', $params)) {
$stats['Event']['last'] = $lastEvent['Event']['time_start'];
} else {
$stats['Event']['last'] = null;
}
$params = array();
$params['recursive'] = -1;
$params['conditions']['time_start <='] = date('Y-m-d');
$countEvents = $EventModel->find('count', $params);
$stats['Event']['total'] = $countEvents;
// Reports
App::uses('Report', 'Model');
$ReportModel = new Report();
$params = array();
$params['recursive'] = -1;
$countReports = $ReportModel->find('count', $params);
$stats['Report']['total'] = $countReports;
// Users
App::uses('User', 'Model');
$UserModel = new User();
$params = array();
$params['recursive'] = -1;
$countUsers = $UserModel->find('count', $params);
$stats['User']['total'] = $countUsers;
// Characters
App::uses('Character', 'Model');
$CharacterModel = new Character();
$params = array();
$params['recursive'] = -1;
$countCharacters = $CharacterModel->find('count', $params);
$stats['Character']['total'] = $countCharacters;
// Games
App::uses('Game', 'Model');
$GameModel = new Game();
$params = array();
$params['recursive'] = -1;
if ($games = $GameModel->find('all', $params)) {
foreach ($games as $game) {
$stats['Game'][$game['Game']['slug']]['title'] = $game['Game']['title'];
$stats['Game'][$game['Game']['slug']]['imported'] = $game['Game']['import_modified'] > 0 ? 1 : 0;
$params = array();
$params['recursive'] = -1;
$params['conditions']['game_id'] = $game['Game']['id'];
$params['group'] = array('user_id');
$countCharacters = $CharacterModel->find('count', $params);
$stats['Game'][$game['Game']['slug']]['players'] = $countCharacters;
}
}
// Bridge
$bridgeSetting = json_decode($this->SettingModel->getOption('bridge'));
$stats['Bridge']['enabled'] = !empty($bridgeSetting) && $bridgeSetting->enabled ? 1 : 0;
// Widgets
App::uses('Widget', 'Model');
$WidgetModel = new Widget();
$params = array();
$params['recursive'] = -1;
if ($widgets = $WidgetModel->find('all', $params)) {
foreach ($widgets as $widget) {
if (!isset($stats['Widget'][$widget['Widget']['controller']])) {
$stats['Widget'][$widget['Widget']['controller']]['total'] = 1;
} else {
$stats['Widget'][$widget['Widget']['controller']]['total']++;
}
}
}
App::uses('HttpSocket', 'Network/Http');
$this->http = new HttpSocket();
$this->http->post('http://stats.mushraider.com/acquire', $stats);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$this->report->find($id)->delete();
return Redirect::route('reports.index');
}
