function GetPIDOfLaspedContract($days = '')
{
global $db;
$rep_obj = new report();
$tmp_reporting_table_1 = $rep_obj->SetReportingLink('care_tz_insurance', 'PID', 'care_person', 'pid');
$tmp_reporting_table_2 = $rep_obj->TMP_GroupBy($tmp_reporting_table_1, 'care_tz_insurance_PID');
$rep_obj->DisconnectReportingTable($tmp_reporting_table_1);
$now = time();
$seconds = $days * 24 * 60;
$asked_time = $now - $seconds;
$this->setTable($tmp_reporting_table_2);
$this->sql = "SELECT selian_pid, date_reg, name_first, name_2, name_3, name_middle, name_last, name_maiden, name_others FROM {$this->coretable} WHERE end_date < {$asked_time}";
$mysql_ptr = $db->Execute($this->sql);
}
/**
* Contructor.
*
* @param string $id An identifier for this table (optional).
* @retrn none
*/
function curriculareport($id = '')
{
parent::report($id);
$this->type = 'class';
$this->title = get_string('reportcurricula', 'block_curr_admin');
$this->fileformats = array('pdf' => 'PDF', 'csv' => 'CSV', 'excel' => 'Excel');
}
/**
* Contructor.
*
* @param string $id An identifier for this table (optional).
* @retrn none
*/
function enrolreport($id = '')
{
parent::report($id);
$this->type = 'class';
$this->title = 'Enrolment Report';
$this->fileformats = array('pdf' => 'PDF', 'csv' => 'CSV', 'excel' => 'Excel');
}
/**
* Contructor.
*
* @param string $id An identifier for this table (optional).
* @retrn none
*/
function reclocreport($id = '')
{
parent::report($id);
$this->loc = '';
$this->usrid = 0;
$this->type = 'recloc';
$this->fileformats = array('pdf' => 'PDF', 'csv' => 'CSV', 'excel' => 'Excel');
}
function _constructor($options)
{
if (isset($options['id'])) {
parent::_construct($options['id']);
} else {
parent::_construct();
}
}
/**
* Contructor.
*
* @param string $id An identifier for this table (optional).
* @retrn none
*/
function induserreport($id = '')
{
parent::report($id);
$this->usrid = 0;
$this->hideins = false;
$this->type = 'induser';
$this->fileformats = array('pdf' => 'PDF', 'csv' => 'CSV', 'excel' => 'Excel');
}
/**
* Contructor.
*
* @param string $id An identifier for this table (optional).
* @retrn none
*/
function transcriptreport($id = '')
{
parent::report($id);
$this->usrid = 0;
$this->hideins = false;
$this->type = 'induser';
$this->title = get_string('user_transcript', 'block_curr_admin');
$this->fileformats = array('pdf' => 'PDF', 'csv' => 'CSV', 'excel' => 'Excel');
}
/**
* Contructor.
*
* @param string $id An identifier for this table (optional).
* @retrn none
*/
function classrosterreport($id = '')
{
parent::report($id);
$this->clsid = 0;
$this->hideins = false;
$this->hidestu = false;
$this->hidesyl = false;
$this->type = 'classroster';
$this->fileformats = array('pdf' => 'PDF', 'csv' => 'CSV', 'excel' => 'Excel');
}
public static function get_list_with_session($session_id)
{
$session = session::get_session($session_id);
if ($session != null && $session->is_valid()) {
$user_group = new user_group();
$report_privileg_list = array();
$user_group_list = $user_group->get_list(array("user_id"), array($session->user_id));
for ($i = 0; $i < count($user_group_list); $i++) {
$report_privileg = new report_privileg();
$report_privileg_list = array_merge($report_privileg_list, $report_privileg->get_list(array("group_id", "privileg_id"), array($user_group_list[$i]->group_id, report_privileg::PRIVILEG_ID_ACCESS)));
}
$report_list = array();
$report = new report();
for ($i = 0; $i < count($report_privileg_list); $i++) {
array_push($report_list, $report->get($report_privileg_list[$i]->report_id));
}
$session->update();
return $report_list;
}
return array();
}
public static function load_structur_with_session($id, $session_id)
{
global $dbconnection;
$object = new report();
$reportlist = $object->get_list_with_session($session_id);
$found = false;
for ($i = 0; $i < count($reportlist); $i++) {
if ($reportlist[$i]->id * 1 === $id * 1) {
$object = $reportlist[$i];
$found = true;
}
}
if ($found === false) {
return null;
}
$rw = new report_wrapper();
$rw->id = $object->id;
$rw->name = $object->name;
$rw->report_element_list = ormlib::get_list_from_instance(new report_element(), array("report_id"), array($id));
for ($i = 0; $i < count($rw->report_element_list); $i++) {
$rw->report_element_field_list = array_merge($rw->report_element_field_list, ormlib::get_list_from_instance(new report_element_field(), array("report_element_id"), array($rw->report_element_list[$i]->id)));
}
for ($i = 0; $i < count($rw->report_element_field_list); $i++) {
$rw->report_element_metadata_mapping[] = ormlib::get_from_instance(new metadata_field(), array("id"), array($rw->report_element_field_list[$i]->metadata_field_id));
}
$help = ormlib::get_list_from_instance(new report_metadata_condition(), array("report_id"), array($rw->id));
for ($i = 0; $i < count($help); $i++) {
$rw->report_metadata_field_condition[] = ormlib::get_from_instance(new metadata_field(), array("id"), array($help[$i]->metadata_field_id));
$table = ormlib::get_from_instance(new metadata_table(), array("id"), array($rw->report_metadata_field_condition[$i]->metadata_table_id));
$values = array();
if ($rw->report_metadata_field_condition[$i]->type * 1 === 1) {
$result = $dbconnection->do_query_data_response("select " . $rw->report_metadata_field_condition[$i]->name_in_table . " from " . $table->name . " group by " . $rw->report_metadata_field_condition[$i]->name_in_table);
while ($myrow = mysql_fetch_array($result)) {
$values[] = $myrow[0];
}
}
$rw->report_values[$rw->report_metadata_field_condition[$i]->name] = $values;
}
return $rw;
}
function test_makeSqlFilter()
{
$this->assertEquals('select * from table where (1 = 1) AND (NPNr = 13)', report::_makeSqlFilter('select * from table where 1=1', 'NPNr = 13'), 'Test1a');
$this->assertEquals('select * from table where (1 = 1) AND (NPNr = 13)', report::_makeSqlFilter('select * from table where 1=1;', 'NPNr = 13'), 'Test1b');
// No semicolon
$this->assertEquals('select * from table where (1 = 1) AND (NPNr = 13) group by NPNR', report::_makeSqlFilter('select * from table where 1=1 group by NPNR', 'NPNr = 13'), 'Test2a');
// One semicolon
$this->assertEquals('select * from table where (1 = 1) AND (NPNr = 13) group by NPNR', report::_makeSqlFilter('select * from table where 1=1 group by NPNR;', 'NPNr = 13'), 'Test2a');
// Two semicolons
$this->assertEquals('select * from table where (1 = 1) AND (NPNr = 13) group by NPNR', report::_makeSqlFilter('select * from table where 1=1 group by NPNR;;', 'NPNr = 13'), 'Test2c');
// Two semicolons separated by a blank
$this->assertEquals('select * from table where (1 = 1) AND (NPNr = 13) group by NPNR', report::_makeSqlFilter('select * from table where 1=1 group by NPNR; ;', 'NPNr = 13'), 'Test2d');
// Invalid statement but has to be parsed and modified as expected
// 1. all semicolons and whitespaces at the end have to be removed
// 2. semicolon in the middle must remain
$this->assertEquals('select * from table where (; a) AND (NPNr = 13)', report::_makeSqlFilter('select * from table where ; a ;;; ;;;', 'NPNr = 13'), 'Test3a');
}
public static function get_structur_with_session($session_id)
{
$report_list = report::get_list_with_session($session_id);
if (count($report_list) > 0) {
$rn = new report_navigation();
$report_nav_list = $rn->get_list();
//Turn Report Navigation List into Report Navigation Structur List
$rns_list = array();
for ($i = 0; $i < count($report_nav_list); $i++) {
$rns_list[] = $report_nav_list[$i]->to_report_navigation_structur();
}
//Create Structur
for ($i = 0; $i < count($rns_list); $i++) {
$rns = $rns_list[$i];
for ($j = 0; $j < count($rns_list); $j++) {
if ($i != $j) {
if ($rns->add_navigation($rns_list[$j])) {
array_splice($rns_list, $j, 1);
$j--;
}
}
}
}
$rnr = new report_navigation_report();
$rnr_list = $rnr->get_list();
for ($i = 0; $i < count($rnr_list); $i++) {
for ($j = 0; $j < count($report_list); $j++) {
if ($report_list[$j]->id === $rnr_list[$i]->report_id) {
for ($k = 0; $k < count($rns_list); $k++) {
$rns_list[$k]->add_navigation(new report_navigation_structur(0, $report_list[$j]->name, $rnr_list[$i]->report_navigation_id, $report_list[$j]->id, $report_list[$j]->description));
}
$j = count($report_list);
}
}
}
return $rns_list;
} else {
return null;
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$insert = $request->all();
$safeName = false;
//upload image
if ($file = Input::file('image')) {
$fileName = $file->getClientOriginalName();
$extension = $file->getClientOriginalExtension() ?: 'png';
$folderName = '/uploads/';
$destinationPath = Config::get('app.path') . $folderName;
$safeName = time() . "_" . str_random(10) . '.' . $extension;
$file->move($destinationPath, $safeName);
$insert['image'] = $safeName ? $folderName . $safeName : '';
}
if (isset(Report::$boolean)) {
foreach (report::$boolean as $field) {
if (isset($insert[$field]) && $insert[$field] == "on") {
$insert[$field] = 1;
}
}
}
report::create($insert);
return redirect('admin/reports')->with('success', Lang::get('message.success.create'));
}
public function allDateReports()
{
/*** Instantiate a new Report model ***/
$model = new report();
/*** set a template variable ***/
$this->registry->template->welcome = 'All Summaries By Date';
/*** Get all Summaries ***/
//Breaks it up into different sections on the screen for reporting
//These functions are in applicationModel with descriptions within it
//** Start Section for States ** //
// Assigns $allstate
$this->registry->template->alldatestate = $model->allDateStates();
//** Start Section for Boat Types ** //
// Assigns $allboat
$this->registry->template->alldateboat = $model->allDateBoatTypes();
//** Start Section for all Previous Interactions ** //
// Assigns $allprev
$this->registry->template->alldateprev = $model->allDatePreviousInteractions();
//** Start Section for allDrained ** //
// Assigns $alldrained
$this->registry->template->alldatedrained = $model->allDateDrained();
//** Start Section for allRinsed ** //
// Assigns $allrinsed
$this->registry->template->alldaterinsed = $model->allDateRinsed();
//** Start Section for allDried ** //
// Assigns $alldried
$this->registry->template->alldatedried = $model->allDateDried();
//** Start Section for allAwareness ** //
// Assigns $allaware
$this->registry->template->alldateaware = $model->allDateAwareness();
//** Start Section for allSpeciesFound ** //
// Assigns $allfound
$this->registry->template->alldatefound = $model->allDateSpeciesFound();
//** Start Section for allSpecimenSent ** //
// Assigns $allsent
$this->registry->template->alldatesent = $model->allDateSpecimenSent();
/*** load the view***/
$this->registry->template->show($this->name, 'allDateReports');
}
* php detect_big_differences.php 1231231231231 1231231231232 1231231231233
*/
include __DIR__ . '/inc.php';
// Removing the script name.
array_shift($argv);
if (empty($argv)) {
echo 'Error: You need to specify the runs filenames without their .php sufix.' . PHP_EOL;
exit(1);
}
if (count($argv) == 1) {
echo 'Error: You should specify, at least, two runs to compare.' . PHP_EOL;
exit(1);
}
// The filename without .php.
$timestamps = $argv;
$report = new report();
if (!$report->parse_runs($timestamps)) {
echo 'Error: The selected runs are not comparable.' . PHP_EOL;
foreach ($report->get_errors() as $var => $error) {
echo $var . ': ' . $error . PHP_EOL;
}
exit(1);
}
// Uses the thresholds specified in the .properties files.
if (!$report->calculate_big_differences()) {
echo 'Error: No way to get the default thresholds...' . PHP_EOL;
exit(1);
}
$branches = $report->get_big_differences();
// Report changes.
$exitcode = 0;
if ($ret) {
$this->title['host'][$target_id] = $ret['host_name'];
}
}
return $this->title['host'][$target_id];
break;
case 'host-instance':
if (empty($this->title['instance'][$target_id])) {
$ret = pdo_get_instance_byid($this->pdo, $target_id);
if ($ret) {
$this->title['instance'][$target_id] = $ret['service_name'] . ':' . $ret['port_num'];
}
}
return $this->title['instance'][$target_id];
break;
case 'global':
return 'global';
break;
}
}
private function get_color($i)
{
$lib = array('#333333', '#ff6600', '#fcd202', '#b0de09', '#0d8ecf', '#21CF12', '#666699', '#003333', '#990066', '#009966', '#EB2D2D', '#4A57E9', '#2B0EA0', '#587A01');
return !empty($lib[$i]) ? $lib[$i] : $lib[$i % 10];
}
}
$param = json_decode($params['param'], true);
$r = new report();
$r->_init_($cfg['alert'], $pdo_log, $pdo);
$ret = $r->start($param);
require_once SC_PATH . '/ajax/report.phtml';
function print_a_type()
{
report::print_a_type();
}
<?php
//****************************************************************************************
//Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com
//Cobalt developed by JV Roig (jvroig@jvroig.com)
//****************************************************************************************
require 'path.php';
init_cobalt('Add report');
require 'components/get_listview_referrer.php';
if (xsrf_guard()) {
init_var($_POST['btn_cancel']);
init_var($_POST['btn_submit']);
require 'components/query_string_standard.php';
require 'subclasses/report.php';
$dbh_report = new report();
$object_name = 'dbh_report';
require 'components/create_form_data.php';
extract($arr_form_data);
if ($_POST['btn_cancel']) {
log_action('Pressed cancel button');
redirect("listview_report.php?{$query_string}");
}
if ($_POST['btn_submit']) {
log_action('Pressed submit button');
$message .= $dbh_report->sanitize($arr_form_data)->lst_error;
extract($arr_form_data);
if ($dbh_report->check_uniqueness($arr_form_data)->is_unique) {
//Good, no duplicate in database
} else {
$message = "Record already exists with the same primary identifiers!";
}
public function order_report()
{
$seller_id = $this->seller['seller_id'];
$search = IFilter::act(IReq::get('search'));
/* //必须为已支付状态
$search['pay_status='] = 1;
//必须为未发货状态
$search['distribution_status='] = 0; */
$condition = Util::search($search);
$where = "go.seller_id = " . $seller_id;
$where .= $condition ? " and " . $condition : "";
//拼接sql
$orderHandle = new IQuery('order_goods as og');
$orderHandle->order = "o.id desc";
$orderHandle->fields = "o.*,p.name as payment_name";
$orderHandle->join = "left join goods as go on go.id=og.goods_id left join order as o on o.id=og.order_id left join payment as p on p.id = o.pay_type";
$orderHandle->where = $where;
$orderList = $orderHandle->find();
//pr($orderList);
//对订单进行重构
if (empty($orderList)) {
IError::show(403, "数据为空");
exit;
} else {
$addrObj = new IModel("address");
foreach ($orderList as $k => $v) {
if ($v['address_id']) {
$order_addr = explode(',', $v['address_id']);
$count = count($order_addr);
for ($i = 0; $i < $count; $i++) {
$new = $v;
$new['old_book_count'] = $count;
$new['one_book_price'] = round($new['order_amount'] / $count, 2);
$addr_detil = $this->getAddr($addrObj, $order_addr[$i]);
if ($addr_detil) {
$new['accept_name'] = $addr_detil['accept_name'];
$new['province_val'] = $addr_detil['province_val'];
$new['city_val'] = $addr_detil['city_val'];
$new['area_val'] = $addr_detil['area_val'];
$new['address'] = $addr_detil['address'];
$new['school'] = $addr_detil['school'];
$new['grade'] = $addr_detil['grade'];
$new['class'] = $addr_detil['class'];
$new['mobile'] = $addr_detil['mobile'];
$new['telphone'] = $addr_detil['telphone'];
} else {
$new['province_val'] = '';
$new['city_val'] = '';
$new['area_val'] = '';
$new['school'] = '';
$new['grade'] = '';
$new['class'] = '';
}
$new_order[] = $new;
}
}
}
}
//pr($new_order);
//构建 Excel table
$strTable = '<table width="500" border="1">';
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;width:120px;">订单编号</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="100">下单日期</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">收货人</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">省</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">市</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">区</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">学校</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">年级</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">班级</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">电话</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">订单金额</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">原有本数</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">单本金额</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">支付方式</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">支付状态</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">支付时间</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">发货状态</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">商品信息</td>';
$strTable .= '</tr>';
foreach ($new_order as $k => $val) {
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;"> ' . $val['order_no'] . '</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['create_time'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['accept_name'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['province_val'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['city_val'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['area_val'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['school'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['grade'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['class'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;"> ' . $val['telphone'] . ' ' . $val['mobile'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['order_amount'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['old_book_count'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['one_book_price'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['payment_name'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . Order_Class::getOrderPayStatusText($val) . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['pay_time'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . Order_Class::getOrderDistributionStatusText($val) . ' </td>';
$orderGoods = Order_class::getOrderGoods($val['id']);
$strGoods = "";
foreach ($orderGoods as $good) {
$strGoods .= "商品编号：" . $good->goodsno . " 商品名称：" . $good->name;
if ($good->value != '') {
$strGoods .= " 规格：" . $good->value;
}
$strGoods .= "<br />";
}
unset($orderGoods);
$strTable .= '<td style="text-align:left;font-size:12px;">' . $strGoods . ' </td>';
$strTable .= '</tr>';
}
$strTable .= '</table>';
//输出成EXcel格式文件并下载
$reportObj = new report();
$reportObj->setFileName('order');
$reportObj->toDownload($strTable);
exit;
}
function operation($id, $operation, $returl)
{
global $_CAMILA;
if ($operation == 'delete') {
require_once CAMILA_DIR . 'datagrid/form.class.php';
require_once CAMILA_DIR . 'datagrid/elements/form/hidden.php';
$form3 = new phpform('camila', 'cf_worktable_admin.php');
$form3->submitbutton = camila_get_translation('camila.worktable.delete');
$form3->drawrules = false;
new form_hidden($form3, 'custom', $id);
new form_hidden($form3, 'worktable_op', $operation);
if ($returl != '') {
new form_hidden($form3, 'returl', $returl);
}
if ($form3->process()) {
$result = $_CAMILA['db']->Execute('select tablename,scriptname from ' . CAMILA_TABLE_WORKT . ' where id=' . $_CAMILA['db']->qstr($id));
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
$table = $result->fields['tablename'];
$script = $result->fields['scriptname'];
$result = $_CAMILA['db']->Execute('delete from ' . CAMILA_TABLE_WORKT . ' where id=' . $_CAMILA['db']->qstr($id));
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
$result = $_CAMILA['db']->Execute('delete from ' . CAMILA_TABLE_WORKC . ' where (wt_id=' . $_CAMILA['db']->qstr($id) . ' and is_deleted<>' . $_CAMILA['db']->qstr('y') . ')');
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
$stmt = sprintf($_CAMILA['db']->_dropSeqSQL, $table);
$result = $_CAMILA['db']->Execute($stmt);
//if ($result === false)
// camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
$record = array();
$record['visible'] = 'no';
$record['active'] = 'no';
$updateSQL = $_CAMILA['db']->AutoExecute(CAMILA_TABLE_PAGES, $record, 'UPDATE', 'url=' . $_CAMILA['db']->qstr($script));
//if (!$updateSQL) {
// camila_information_text(camila_get_translation('camila.worktable.db.error'));
// $success3 = false;
//}
} else {
camila_information_text(camila_get_translation('camila.worktable.delete.areyousure'));
$result = $_CAMILA['db']->Execute('select short_title from ' . CAMILA_TABLE_WORKT . ' where id=' . $_CAMILA['db']->qstr($id));
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
$name = $result->fields['short_title'];
$myText = new CHAW_text($name, HAW_TEXTFORMAT_BOLD);
$myText->set_br(2);
$_CAMILA['page']->add_text($myText);
$form3->draw();
$success = false;
}
} elseif ($operation == 'rebuild') {
require_once CAMILA_DIR . 'datagrid/form.class.php';
require_once CAMILA_DIR . 'datagrid/elements/form/hidden.php';
$form3 = new phpform('camila', 'cf_worktable_admin.php');
$form3->submitbutton = camila_get_translation('camila.worktable.delete');
$form3->drawrules = false;
new form_hidden($form3, 'custom', $id);
new form_hidden($form3, 'worktable_op', $operation);
if ($returl != '') {
new form_hidden($form3, 'returl', $returl);
}
if ($form3->process()) {
$this->configure_table($id, true, $returl);
} else {
camila_information_text(camila_get_translation('camila.worktable.rebuild.areyousure'));
$result = $_CAMILA['db']->Execute('select short_title from ' . CAMILA_TABLE_WORKT . ' where id=' . $_CAMILA['db']->qstr($id));
if ($result === false) {
camila_error_page(camila_get_translation('camila.sqlerror') . ' ' . $_CAMILA['db']->ErrorMsg());
}
$name = $result->fields['short_title'];
$myText = new CHAW_text($name, HAW_TEXTFORMAT_BOLD);
$myText->set_br(2);
$_CAMILA['page']->add_text($myText);
$form3->draw();
$success = false;
}
} elseif ($operation == 'showtemplatefields') {
$stmt = "select wt_id,name,name_abbrev,col_name as colname_form, col_name as colname_table from " . CAMILA_TABLE_WORKC . ' where (wt_id=' . $_CAMILA['db']->qstr($id) . ' and is_deleted<>' . $_CAMILA['db']->qstr('y') . ') order by name';
require_once CAMILA_DIR . 'datagrid/report.class.php';
$report = new report($stmt);
$report->mapping = camila_get_translation('camila.worktable.mapping.worktable');
$report->process();
$report->fields['colname_form']->onprint = camila_configurator_template_fieldname_form;
$report->fields['colname_form']->dummy = true;
$report->fields['colname_form']->orderable = false;
$report->fields['colname_table']->onprint = camila_configurator_template_fieldname_table;
$report->fields['colname_table']->dummy = true;
$report->fields['colname_table']->orderable = false;
$report->fields['wt_id']->print = false;
$report->fields['name']->orderable = false;
$report->fields['name_abbrev']->orderable = false;
$report->drawfilterbox = false;
$report->drawnavigationbox = false;
$report->draw();
}
if ($success) {
$myText = new CHAW_text(camila_get_translation('camila.worktable.db.importok'));
$_CAMILA['page']->add_text($myText);
}
}
if (isset($_REQUEST['camila_rest'])) {
$report_fields = str_replace('cf_bool_is_special,', '', $report_fields);
$report_fields = str_replace('cf_bool_is_selected,', '', $report_fields);
$default_fields = $report_fields;
}
if ($_CAMILA['page']->camila_exporting()) {
$mapping = 'created=Data creazione#last_upd=Ultimo aggiornamento#last_upd_by=Utente ult. agg.#last_upd_src=Sorgente Ult. agg.#last_upd_by_name=Nome Utente ult. agg.#last_upd_by_surname=Cognome Utente ult. agg.#mod_num=Num. mod.#id=Cod. riga#created_by=Utente creaz.#created_src=Sorgente creaz.#created_by_surname=Cognome Utente creaz.#created_by_name=Nome Utente creaz.#cf_bool_is_special=contrassegnati come speciali#cf_bool_is_selected=selezionati#data1=Data#richiedente=Richiedente#richiesta=Richiesta#tiporichiesta=Tipo Richiesta#priorit=Priorità#assegnatariorichiesta=Assegnatario richiesta#stato=Stato#note=Note';
} else {
$mapping = 'created=Data creazione#last_upd=Ultimo aggiornamento#last_upd_by=Utente ult. agg.#last_upd_src=Sorgente Ult. agg.#last_upd_by_name=Nome Utente ult. agg.#last_upd_by_surname=Cognome Utente ult. agg.#mod_num=Num. mod.#id=Cod. riga#created_by=Utente creaz.#created_src=Sorgente creaz.#created_by_surname=Cognome Utente creaz.#created_by_name=Nome Utente creaz.#cf_bool_is_special=contrassegnati come speciali#cf_bool_is_selected=selezionati#data1=Data#richiedente=Richiedente#richiesta=Richiesta#tiporichiesta=Tipo Richiesta#priorit=Priorità#assegnatariorichiesta=Assegnatario rich.#stato=Stato#note=Note';
}
$filter = '';
if ($_CAMILA['user_visibility_type'] == 'personal') {
$filter = ' where created_by=' . $_CAMILA['db']->qstr($_CAMILA['user']);
}
$stmt = 'select ' . $report_fields . ' from worktable_worktable2';
$report = new report($stmt . $filter, '', 'data1', 'asc', $mapping, null, 'id', 'cf_bool_is_special,cf_bool_is_selected,data1,richiedente,richiesta,tiporichiesta,priorit,assegnatariorichiesta,stato,note', '', isset($_REQUEST['camila_rest']) ? false : true, isset($_REQUEST['camila_rest']) ? false : true);
if (true && !isset($_REQUEST['camila_rest'])) {
$report->additional_links = array(camila_get_translation('camila.report.insertnew') => basename($_SERVER['PHP_SELF']) . '?camila_update=new');
$myImage1 = new CHAW_image(CAMILA_IMG_DIR . 'wbmp/add.wbmp', CAMILA_IMG_DIR . 'png/add.png', '-');
$report->additional_links_images = array(camila_get_translation('camila.report.insertnew') => $myImage1);
if ($_CAMILA['adm_user_group'] == CAMILA_ADM_USER_GROUP || CAMILA_WORKTABLE_IMPORT_ENABLED) {
$report->additional_links[camila_get_translation('camila.worktable.import')] = 'cf_worktable_wizard_step4.php?camila_custom=' . $wt_id . '&camila_returl=' . urlencode($_SERVER['PHP_SELF']);
}
}
if ($_CAMILA['adm_user_group'] == CAMILA_ADM_USER_GROUP) {
$report->additional_links[camila_get_translation('camila.worktable.rebuild')] = 'cf_worktable_admin.php?camila_custom=' . $wt_id . '&camila_worktable_op=rebuild' . '&camila_returl=' . urlencode($_SERVER['PHP_SELF']);
$report->additional_links[camila_get_translation('camila.worktable.reconfig')] = 'cf_worktable_wizard_step2.php?camila_custom=' . $wt_id . '&camila_returl=' . urlencode($_SERVER['PHP_SELF']);
}
if (CAMILA_WORKTABLE_CONFIRM_VIA_MAIL_ENABLED) {
$report->additional_links[camila_get_translation('camila.worktable.confirm')] = basename($_SERVER['PHP_SELF']) . '?camila_visible_cols_only=y&camila_worktable_export=dataonly&camila_pagnum=-1&camila_export_filename=WORKTABLE&camila_export_action=sendmail&hidden=camila_xls&camila_export_format=camila_xls&camila_xls=Esporta';
$myImage1 = new CHAW_image(CAMILA_IMG_DIR . 'wbmp/accept.wbmp', CAMILA_IMG_DIR . 'png/accept.png', '-');
<?php
$PAGE = "S_REPORT_WEEKLY_EDIT";
require_once '../_init_auth.php';
require_once 'report/class.Report.php';
try {
$report = new report($request);
$param['page'] = $PAGE;
//日付取得
if (isset($request['target_date']) && !empty($request['target_date'])) {
//サブメニューから遷移
$date = date('Ymd', strtotime($request['target_date']));
$termid = getTermId($date);
$param['date'] = $date;
$year = getYear($request['target_date']);
$month = getMonth($request['target_date']);
$param['target_date'] = $date;
} else {
$param['errors'][] = "システムエラーが発生しました。";
renderTemplate('error.tpl', $param);
exit;
}
$authority = $_SESSION[SESSION_GROUP_CD];
if (isset($request['id']) && !empty($request['id'])) {
$staff_id = $request['id'];
}
//新入社員情報取得
if (isset($request['id'])) {
$employee = $report->getEmpData($request['id']);
}
if (!isset($request['id']) || !$employee) {
<?php
include __DIR__ . '/compare/inc.php';
$report = new report();
if (!empty($_GET['timestamps'])) {
// Create the report.
$report->make($_GET['timestamps'], $_GET['threadgroupname']);
}
// Render it.
$renderer = new report_renderer($report);
$renderer->render();
public function goods_report()
{
//搜索条件
$search = IFilter::act(IReq::get('search'), 'strict');
//条件筛选处理
list($join, $where) = goods_class::getSearchCondition($search);
//拼接sql
$goodsHandle = new IQuery('goods as go');
$goodsHandle->order = "go.sort asc,go.id desc";
$goodsHandle->distinct = "go.id";
$goodsHandle->fields = "go.id, go.name,go.sell_price,go.store_nums,go.sale,go.is_del,go.create_time,seller.true_name";
$goodsHandle->join = $join;
$goodsHandle->where = $where;
$goodsHandle->limit = 'all';
$goodsList = $goodsHandle->find();
//构建 Excel table;
$strTable = '<table width="500" border="1">';
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">商品名称</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="160">分类</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">售价</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">库存</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">销量</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">发布时间</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">状态</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="60">隶属商户</td>';
$strTable .= '</tr>';
foreach ($goodsList as $k => $val) {
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;"> ' . $val['name'] . '</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . goods_class::getGoodsCategory($val['id']) . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['sell_price'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['store_nums'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['sale'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['create_time'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . goods_class::statusText($val['is_del']) . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['true_name'] . ' </td>';
$strTable .= '</tr>';
}
$strTable .= '</table>';
unset($goodsList);
$reportObj = new report();
$reportObj->setFileName('goods');
$reportObj->toDownload($strTable);
exit;
}
</td>
</tr>
<table>
</FORM>
<?php
$v0 = $_POST['empresalist'];
if (isset($_POST['empresalist']) && $_POST['empresalist'] != "" && isset($_POST['buscar']) && isset($_POST['fechaInicio']) && $_POST['fechaInicio'] != "" && isset($_POST['fechaFin']) && $_POST['fechaFin'] != "") {
$fechaInicio = $_POST['fechaInicio'];
$fechaFin = $_POST['fechaFin'];
$empresalist = $_POST['empresalist'];
$centro = $_POST['centro'];
$usuariolist = $_POST['usuariolist'];
$concepto = $_POST['concepto'];
$reporte = new report();
$datos = $reporte->Reporte_Gastos($fechaInicio, $fechaFin, $empresalist, $usuariolist, $centro, $concepto);
$aux = "";
$aux .= "<html>";
$aux .= "<table align='center' cellspacing='4' cellpadding='4' >";
$aux .= "<td style=\"font-size: 12px;\"><br><br><strong>Empresa</strong></td>";
$aux .= "<td style=\"font-size: 12px;\"><br><br><strong>Departamento</strong></td>";
$aux .= "<td style=\"font-size: 12px;\"><br><br><strong>Usuario</strong></td>";
$aux .= "<td style=\"font-size: 12px;\"><br><br><strong>Concepto</strong></td>";
$aux .= "<td style=\"font-size: 12px;\"><br><br><strong>Total Aprobado</strong></td>";
$suma = 0;
foreach ($datos as $fila) {
$aux .= "<tr>";
$aux .= "<td style=\"font-size: 10px;\" align='left'>{$fila['e_codigo']}</td>";
$aux .= "<td style=\"font-size: 10px;\" align='left'>{$fila['cc_centrocostos']}</td>";
$aux .= "<td style=\"font-size: 10px;\" align='left'>{$fila['u_nombre']}</td>";
$log->Fatal("Error: " . $text . " (File: " . $_SERVER['PHP_SELF'] . ")");
die;
}
// Get/Set Task ID - as sent from cronjob when this script is called and is stored in DB.nodes table also
$tid = $_GET['id'];
// get task details from DB
$taskResult = $db->q("SELECT * FROM tasks WHERE id = {$tid} AND status = '1'");
$taskRow = mysql_fetch_assoc($taskResult);
$command = $taskRow['catCommand'];
$taskname = $taskRow['taskname'];
// create connection report file
$reportFilename = 'compareReport' . $date . '.html';
$reportDirectory = 'compareReports';
$serverIp = getHostByName(getHostName());
// get server IP address for CLI scripts
$report = new report($config_reports_basedir, $reportFilename, $reportDirectory, $serverIp);
$report->createFile();
$title = "rConfig Report - " . $taskname;
$report->header($title, $title, basename($_SERVER['PHP_SELF']), $tid, $startTime);
$reportFail = '<font color="red">Fail</font>';
$reportPass = '******';
// Get active nodes for a given task ID
// Query to retireve row for given ID (tidxxxxxx is stored in nodes and is generated when task is created)
$getNodesSql = "SELECT id, deviceName, deviceIpAddr, deviceUsername, devicePassword, deviceEnableMode, deviceEnablePassword, nodeCatId, deviceAccessMethodId, connPort FROM nodes WHERE taskId" . $tid . " = 1 AND status = 1";
if ($result = $db->q($getNodesSql)) {
// push rows to $devices array
$devices = array();
while ($row = mysql_fetch_assoc($result)) {
array_push($devices, $row);
}
foreach ($devices as $device) {
<?php
include __DIR__ . '/webapp/inc.php';
$report = new report();
if (!empty($_GET['timestamps'])) {
// Create the report.
$report->make($_GET['timestamps']);
}
// Render it.
$renderer = new report_renderer($report);
$renderer->render();
<?php
$PAGE = "S_REPORT_DAILY_EDIT";
require_once '../_init_auth.php';
require_once 'report/class.Report.php';
require_once 'report/class.Edit.php';
try {
$param['page'] = $PAGE;
$edit = new edit($request);
$report = new report($request);
$error = false;
//日付取得
if (isset($request['target_date']) && !empty($request['target_date'])) {
//サブメニューから遷移
$date = date('Ymd', strtotime($request['target_date']));
// $date = 20140101;
$termid = getTermId($date);
$year = getYear($request['target_date']);
$month = getMonth($request['target_date']);
// $preg = '%02d%02d';
// $date = sprintf('%04d', substr($date, 4, 4));
// $param['target_date'] = $date;
} else {
$param['errors'][] = "システムエラーが発生しました。";
renderTemplate('error.tpl', $param);
exit;
}
//新入社員情報取得
$authority = $_SESSION[SESSION_GROUP_CD];
//新入社員以外エラー
if (in_array(ACCOUNT_NEW_EMP, $_SESSION[SESSION_GROUP_CD])) {
/**
* Performs the report function.
*
* @param array $formdata the form data
* @param int $type the report type
* @param string $saveto File to save the pdf report to.
* @return bool False on failure
* @uses $CFG, $DB
*/
function report_ncccscensus_generate_report($formdata, $type = REPORT_NCCCSCENSUS_ACTION_VIEW, $saveto = false)
{
global $CFG, $DB;
require_once $CFG->libdir . '/moodlelib.php';
$reportname = 'report_ncccscensus';
$cid = $formdata->id;
// In case the form is hacked, set a default startdate to today at midnight.
if (empty($formdata->startdate)) {
$formdata->startdate = usergetmidnight(time(), get_user_timezone());
}
// In case the form is hacked, set a default enddate to today at midnight.
if (empty($formdata->enddate)) {
$formdata->enddate = $formdata->startdate;
}
// Advance enddate to tomorrow's midnight.
$formdata->enddate += DAYSECS - 1;
// This flag determines if we should display grouped users or not.
$nogroups = isset($formdata->disablegroups) ? true : false;
if ($nogroups) {
$group = false;
} else {
// If group specified, do some validation.
$group = isset($formdata->group) ? $formdata->group : false;
// In case the form is hacked, the group could be invalid.
if ($group === false || $group < 0) {
throw new report_ncccscensus_exception('cannotfindgroup');
}
if ($group > 0) {
// Validate the group ID.
if (!groups_group_exists($group)) {
throw new report_ncccscensus_exception('cannotfindgroup');
}
// Validate the group ID with respect to the course ID.
$groupdata = groups_get_course_data($cid);
$groupfound = false;
foreach ($groupdata->groups as $groupobject) {
if ($groupobject->id == $group) {
$groupfound = true;
break;
}
}
if (!$groupfound) {
throw new report_ncccscensus_exception('invalidgroupid');
}
// User could still hack form to view a group that they don't have the capability to see.
$context = context_course::instance($cid);
if (has_capability('moodle/site:accessallgroups', $context)) {
$userid = 0;
} else {
if (has_capability('moodle/course:managegroups', $context)) {
$userid = $USER->id;
} else {
$userid = false;
}
}
if ($userid === false) {
throw new report_ncccscensus_exception('invalidgroupid');
}
if ($userid != 0) {
$grouprecs = groups_get_all_groups($course->id, $userid, 0, 'g.id, g.name');
$groupnotfound = true;
foreach ($grouprecs as $grouprec) {
if ($grouprec->id == $group) {
$groupnotfound = false;
break;
}
}
if ($groupnotfound) {
throw new report_ncccscensus_exception('invalidgroupid');
}
}
}
}
$users = array();
if ($nogroups) {
$users = report_ncccscensus_get_users($cid, REPORT_NCCCSCENSUS_EXCLUDE_GROUP_MEMBERS);
} else {
if ($group > 0) {
$users = report_ncccscensus_get_users($cid, $group);
} else {
$users = report_ncccscensus_get_users($cid);
}
}
$results = report_ncccscensus_build_grades_array($cid, $users, $formdata->startdate, $formdata->enddate);
if (empty($results)) {
return false;
}
if ($type == REPORT_NCCCSCENSUS_ACTION_VIEW) {
$headers = array('student' => get_string('studentfullnamehtml', $reportname));
$showstudentid = report_ncccscensus_check_field_status('showstudentid', 'html');
} else {
if ($type == REPORT_NCCCSCENSUS_ACTION_CSV) {
$headers = array('student' => get_string('studentfullnamecsv', $reportname));
$showstudentid = report_ncccscensus_check_field_status('showstudentid', 'csv');
} else {
$headers = array('student' => get_string('studentfullnamepdf', $reportname));
$showstudentid = report_ncccscensus_check_field_status('showstudentid', 'pdf');
}
}
if ($showstudentid) {
$headers['studentid'] = get_string('studentid', $reportname);
}
$headers['activity'] = get_string('activityname', $reportname);
$headers['module'] = get_string('activitymodule', $reportname);
$headers['status'] = get_string('submissionstatus', $reportname);
$headers['datesubmitted'] = get_string('submissiondate', $reportname);
$headers['grade'] = get_string('grade', $reportname);
$headers['gradedate'] = get_string('gradedate', $reportname);
$context = context_course::instance($cid);
$namesarrayview = array();
$namesarraypdf = array();
$instructors = ' - ';
$viewlink = ': <a href="' . $CFG->wwwroot . '/user/view.php?id=';
if (!empty($CFG->coursecontact)) {
$coursecontactroles = explode(',', $CFG->coursecontact);
sort($coursecontactroles);
// If a user has multiple roles, we do not want to show user multiple times as a contact.
$teachers = array();
foreach ($coursecontactroles as $roleid) {
$roleid = (int) $roleid;
if ($users = get_role_users($roleid, $context, true)) {
$role = $DB->get_record('role', array('id' => $roleid));
$rolename = format_string(role_get_name($role, $context));
foreach ($users as $teacher) {
// The $teachers array tracks whether a user is already a course contact.
if (!isset($teachers[$teacher->id])) {
$teachers[$teacher->id] = true;
$fullname = fullname($teacher, has_capability('moodle/site:viewfullnames', $context));
$namesarrayview[] = $rolename . $viewlink . $teacher->id . '&course=' . SITEID . '">' . $fullname . '</a>';
$namesarraycsv[] = $rolename . ': ' . $fullname;
$namesarraypdf[] = $rolename . ': ' . $fullname;
}
}
}
}
}
if ($type != REPORT_NCCCSCENSUS_ACTION_PDF) {
if ($type == REPORT_NCCCSCENSUS_ACTION_VIEW) {
// Create legend for HTML view.
$legend = new html_table();
$legend->head = array(get_string('legend', $reportname));
$legend->headspan = array(2);
$legendrow1colour = new html_table_cell();
$legendrow1colour->style = 'width: 50px; background-color: ' . get_config('report_ncccscensus', 'gradeoverridecolour');
$legendrow1[] = $legendrow1colour;
$legendrow1[] = get_string('legendgradeoverride', $reportname);
$legendrow2colour = new html_table_cell();
$legendrow2colour->style = 'width: 50px; background-color: ' . get_config('report_ncccscensus', 'gradenogradecolour');
$legendrow2[] = $legendrow2colour;
$legendrow2[] = get_string('legendnograde', $reportname);
$legend->data = array($legendrow1, $legendrow2);
$legendalign = array('center', 'left');
$legend->align = $legendalign;
}
$table = new html_table();
$table->head = $headers;
$align = array('left');
$numheaders = count($headers);
for ($i = 1; $i < $numheaders; $i++) {
$align[] = 'center';
}
$table->align = $align;
$table->data = array();
foreach ($results as $result) {
$datum = array();
$datum[] = $result->student;
if ($showstudentid) {
$datum[] = $result->studentid;
}
$datum[] = $result->activity;
$datum[] = $result->module;
$status = $result->status;
$grade = $result->grade;
if ($type == REPORT_NCCCSCENSUS_ACTION_VIEW && $grade == get_string('nograde', $reportname)) {
$specialstatus = new html_table_cell($status);
$specialstatus->style = 'background-color: ' . get_config('report_ncccscensus', 'gradenogradecolour');
$status = $specialstatus;
} else {
if ($type == REPORT_NCCCSCENSUS_ACTION_VIEW && $result->overridden) {
$specialstatus = new html_table_cell($status);
$specialstatus->style = 'background-color: ' . get_config('report_ncccscensus', 'gradeoverridecolour');
$status = $specialstatus;
}
}
$datum[] = $status;
$datum[] = $result->submitdate;
if ($type == REPORT_NCCCSCENSUS_ACTION_VIEW && $grade == get_string('nograde', $reportname)) {
$nograde = new html_table_cell($grade);
$nograde->style = 'background-color: ' . get_config('report_ncccscensus', 'gradenogradecolour');
$grade = $nograde;
} else {
if ($type == REPORT_NCCCSCENSUS_ACTION_VIEW && $result->overridden) {
$overriddengrade = new html_table_cell($grade);
$overriddengrade->style = 'background-color: ' . get_config('report_ncccscensus', 'gradeoverridecolour');
$grade = $overriddengrade;
}
}
$datum[] = $grade;
$datum[] = $result->date;
$table->data[] = $datum;
}
}
$course = $DB->get_record('course', array('id' => $cid));
if ($group > 0) {
$groupname = groups_get_group_name($group);
}
$datestring = 'n/j/y';
$reportrange = date($datestring, $formdata->startdate) . ' - ' . date($datestring, $formdata->enddate);
if ($type != REPORT_NCCCSCENSUS_ACTION_VIEW) {
$date = usergetdate(time(), get_user_timezone());
$filename = 'CensusRpt2_';
$filename .= date('MdY_Hi', mktime($date['hours'], $date['minutes'], 0, $date['mon'], $date['mday'], $date['year']));
}
if ($type == REPORT_NCCCSCENSUS_ACTION_VIEW) {
if (report_ncccscensus_check_field_status('showcoursename', 'html')) {
echo '<b>' . get_string('coursetitle', $reportname) . ':</b> ' . $course->fullname . '<br>';
}
if (report_ncccscensus_check_field_status('showcoursecode', 'html')) {
echo '<b>' . get_string('coursecode', $reportname) . ':</b> ' . $course->shortname . '<br>';
}
// Only show course ID if present.
if (report_ncccscensus_check_field_status('showcourseid', 'html') && $course->idnumber !== '') {
echo '<b>' . get_string('courseid', $reportname) . ':</b> ' . $course->idnumber . '<br>';
}
if (report_ncccscensus_check_field_status('showteachername', 'html')) {
if (!empty($namesarrayview)) {
$instructors = implode(', ', $namesarrayview);
echo '<b>' . get_string('instructor', $reportname) . ':</b> ' . $instructors . '<br>';
}
}
echo '<b>' . get_string('reportrange', $reportname) . ':</b> ' . $reportrange . '<br>';
if (isset($groupname)) {
echo '<b>' . get_string('section', $reportname) . ':</b> ' . $groupname . '<br>';
} else {
echo '<b>' . get_string('section', $reportname) . ':</b> ' . get_string('allgroupspdf', $reportname) . '<br>';
}
echo '<br>';
echo html_writer::table($table);
echo '<div id="studentfootnote" style="font-size:10px;">' . get_string('studentfootnote', $reportname) . '</div>';
echo '<br>';
echo html_writer::table($legend);
echo '<br><div align="center"><a href="' . $CFG->wwwroot . '/report/ncccscensus/index.php?id=' . $formdata->id . '">';
echo get_string('backtoreport', 'report_ncccscensus') . '</a></div>';
} else {
if ($type == REPORT_NCCCSCENSUS_ACTION_PDF) {
$topheaders = array();
$topheaders['student'] = get_string('student', $reportname);
$topheaders['activity'] = get_string('activity', $reportname);
$topheaders['submission'] = get_string('submission', $reportname);
$topheaders['grade'] = get_string('grade', $reportname);
$bottomheaders = array();
$bottomheaders['student'] = array('fullname' => get_string('studentfullnamepdf', $reportname));
$showstudentid = report_ncccscensus_check_field_status('showstudentid', 'pdf');
if ($showstudentid) {
$bottomheaders['student']['id'] = get_string('studentidpdf', $reportname);
}
$bottomheaders['activity'] = array('name' => get_string('activityname', $reportname), 'module' => get_string('activitymodule', $reportname));
$bottomheaders['submission'] = array('status' => get_string('submissionstatus', $reportname), 'date' => get_string('submissiondate', $reportname));
$bottomheaders['grade'] = array('grade' => get_string('grade', $reportname), 'date' => get_string('gradedatepdf', $reportname));
require_once 'report.class.php';
$censusreport = new report();
$censusreport->topheaders = $topheaders;
$censusreport->bottomheaders = $bottomheaders;
$censusreport->data = array();
foreach ($results as $result) {
$fieldarray = array();
$fieldarray['studentfullname'] = $result->student;
if ($showstudentid) {
$fieldarray['studentid'] = $result->studentid;
}
$fieldarray['activityname'] = $result->activity;
$fieldarray['activitymodule'] = $result->module;
$fieldarray['submissionstatus'] = $result->status;
$fieldarray['submissiondate'] = $result->submitdate;
$fieldarray['gradegrade'] = $result->grade;
$fieldarray['gradedate'] = $result->date;
$censusreport->data[] = array('data' => $fieldarray, 'override' => $result->overridden != 0 ? true : false, 'nograde' => $result->grade == get_string('nograde', $reportname) ? true : false);
}
$censusreport->filename = $filename . '.pdf';
if (report_ncccscensus_check_field_status('showcoursename', 'pdf')) {
$censusreport->top[] = array(get_string('coursetitlepdf', $reportname) . ':', $course->fullname);
}
if (report_ncccscensus_check_field_status('showcoursecode', 'pdf')) {
$censusreport->top[] = array(get_string('coursecodepdf', $reportname) . ':', $course->shortname);
}
if (report_ncccscensus_check_field_status('showcourseid', 'pdf') && $course->idnumber !== '') {
$censusreport->top[] = array(get_string('courseid', $reportname) . ':', $course->idnumber);
}
if (report_ncccscensus_check_field_status('showteachername', 'pdf')) {
if (!empty($namesarrayview)) {
$instructors = implode(', ', $namesarrayview);
}
$censusreport->top[] = array(get_string('instructor', $reportname) . ':', strip_tags($instructors));
}
$censusreport->top[] = array(get_string('reportrangepdf', $reportname) . ':', $reportrange);
if (isset($groupname)) {
$censusreport->top[] = array(get_string('group', $reportname) . ':', $groupname);
} else {
if ($group !== false) {
$censusreport->top[] = array(get_string('group', $reportname) . ':', get_string('allgroupspdf', $reportname));
}
}
if (report_ncccscensus_check_field_status('showsignatureline', 'pdf')) {
$censusreport->signatureline = true;
}
if (report_ncccscensus_check_field_status('showdateline', 'pdf')) {
$censusreport->dateline = true;
}
if ($footermessage = get_config('report_ncccscensus', 'footermessage')) {
$censusreport->bottom .= $footermessage;
}
$censusreport->download($saveto);
return true;
} else {
if ($type == REPORT_NCCCSCENSUS_ACTION_CSV) {
if (!empty($_SERVER['HTTP_USER_AGENT']) && strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') !== false) {
header('Expires: 0');
header('Cache-Control: private, pre-check=0, post-check=0, max-age=0, must-revalidate');
header('Connection: Keep-Alive');
header('Content-Language: ' . current_language());
header('Keep-Alive: timeout=5, max=100');
header('Pragma: no-cache');
header('Pragma: expires');
header('Expires: Mon, 20 Aug 1969 09:23:00 GMT');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
}
header('Content-Transfer-Encoding: ascii');
header('Content-Disposition: attachment; filename=' . $filename . '.csv');
header('Content-Type: text/comma-separated-values');
$output = fopen('php://output', 'w');
fputcsv($output, array(get_string('ncccscensusreport_title', 'report_ncccscensus')));
fputcsv($output, array());
if (report_ncccscensus_check_field_status('showcoursename', 'csv')) {
fputcsv($output, array(get_string('coursetitle', $reportname), $course->fullname));
}
if (report_ncccscensus_check_field_status('showcoursecode', 'csv')) {
fputcsv($output, array(get_string('coursecode', $reportname), $course->shortname));
}
if (report_ncccscensus_check_field_status('showcourseid', 'csv') && $course->idnumber !== '') {
fputcsv($output, array(get_string('courseid', $reportname), $course->idnumber));
}
if (!empty($namesarrayview) && report_ncccscensus_check_field_status('showteachername', 'csv')) {
fputcsv($output, array_merge(array(get_string('instructor', $reportname)), $namesarraycsv));
}
fputcsv($output, array(get_string('reportrange', $reportname), $reportrange));
if (isset($groupname)) {
fputcsv($output, array(get_string('section', $reportname), $groupname));
} else {
fputcsv($output, array(get_string('section', $reportname), get_string('allgroups', $reportname)));
}
fputcsv($output, array());
fputcsv($output, $table->head);
foreach ($table->data as $row) {
fputcsv($output, $row);
}
$showsignatureline = report_ncccscensus_check_field_status('showsignatureline', 'csv');
$showdateline = report_ncccscensus_check_field_status('showdateline', 'csv');
if ($showsignatureline || $showdateline) {
fputcsv($output, array());
if ($showsignatureline) {
fputcsv($output, array(get_string('certified', $reportname)));
fputcsv($output, array(get_string('signature', $reportname) . get_string('underscores', $reportname)));
}
if ($showdateline) {
fputcsv($output, array(get_string('date') . get_string('underscores', 'report_ncccscensus')));
}
}
fclose($output);
}
}
}
}
<?php
$PAGE = "S_REPORT_MONTHLY_EDIT";
require_once '../_init_auth.php';
require_once 'report/class.Report.php';
require_once 'target/class.Target.php';
try {
$param['page'] = $PAGE;
$report = new report($request);
$target = new target($request);
//日付取得
if (isset($request['target_date']) && !empty($request['target_date'])) {
//サブメニューから遷移
$date = date('Ymd', strtotime($request['target_date']));
$termid = getTermId($date);
$param['date'] = $date;
$year = getYear($request['target_date']);
$month = getMonth($request['target_date']);
$month = sprintf('%01d', $month);
$param['target_date'] = $date;
} else {
$param['errors'][] = "システムエラーが発生しました。";
renderTemplate('error.tpl', $param);
exit;
}
//新入社員情報取得
if (isset($request['id'])) {
$employee = $report->getEmpData($request['id']);
} else {
$param['errors'][] = "システムエラーが発生しました。";
renderTemplate('error.tpl', $param);
