function getList()
{
$q = "SELECT * FROM view_score INNER JOIN view_student ON view_student.id=view_score.student WHERE 1=1";
if (!option('class') && !option('grade')) {
$manage_class = $this->db->query("SELECT id,grade FROM class WHERE class_teacher='{$this->user->id}'")->row_array();
if ($manage_class) {
//将班主任的视图定位到自己班级
option('class', $manage_class['id']);
option('grade', $manage_class['grade']);
} else {
//默认显示的年级
option('grade', $this->school->highest_grade);
}
}
$q = $this->addCondition($q, array('class' => 'view_student.class', 'grade' => 'view_student.grade'), array('grade' => array('class', 'exam')));
if (!option('exam')) {
option('exam', db_fetch_field("SELECT id FROM exam WHERE grade='" . option('grade') . "' ORDER BY id DESC LIMIT 1"));
}
$q = $this->addCondition($q, array('exam' => 'view_score.exam'));
$q = $this->search($q, array('view_student.name' => '学生'));
$q = $this->orderby($q, 'view_student.num');
$q = $this->pagination($q);
return $this->db->query($q)->result_array();
}
function cw_query_hash($query, $column = false, $is_multirow = true, $only_first = false)
{
$result = array();
$is_multicolumn = false;
if ($p_result = db_query($query)) {
if ($column === false) {
# Get first field name
$c = db_fetch_field($p_result);
$column = $c->name;
} elseif (is_array($column)) {
if (count($column) == 1) {
$column = current($column);
} else {
$is_multicolumn = true;
}
}
while ($row = db_fetch_array($p_result)) {
# Get key(s) column value and remove this column from row
if ($is_multicolumn) {
$keys = array();
foreach ($column as $c) {
$keys[] = $row[$c];
cw_unset($row, $c);
}
$keys = implode('"]["', $keys);
} else {
$key = $row[$column];
cw_unset($row, $column);
}
if ($only_first) {
$row = array_shift($row);
}
if ($is_multicolumn) {
# If keys count > 1
if ($is_multirow) {
eval('$result["' . $keys . '"][] = $row;');
} else {
eval('$is = isset($result["' . $keys . '"]);');
if (!$is) {
eval('$result["' . $keys . '"] = $row;');
}
}
} elseif ($is_multirow) {
$result[$key][] = $row;
} elseif (!isset($result[$key])) {
$result[$key] = $row;
}
}
db_free_result($p_result);
}
return $result;
}
function getManager($staff = NULL)
{
if (is_null($staff)) {
$staff = $this->user->id;
}
$query = "SELECT SUM(score) AS score FROM evaluation_score WHERE quarter={$this->date->quarter} AND staff='" . $staff . "' AND uid = (SELECT manager FROM manager_staff WHERE staff = '" . $staff . "')";
return round(db_fetch_field($query), 2);
}
}
}
}
if (!$duplicateFound) {
//-------------------------update record
reset($_POST);
$_SESSION['holdingVaribles'] = false;
$fieldProperties = array();
$recordFields = array();
$formFields = array();
$formValues = array();
$form = formFields($formID);
$dq = '"';
// get all fields used on this form
$t = nuRunQuery("SELECT * FROM {$form->sfo_table} WHERE FALSE");
while ($f = db_fetch_field($t)) {
$recordFields[] = $f->name;
}
// get formatting properties for this form's fields
$t = nuRunQuery("SELECT sob_all_name, sob_text_format FROM zzsys_object WHERE sob_all_type = 'text' AND sob_zzsys_form_id = '{$formID}'");
while ($r = db_fetch_object($t)) {
$fieldProperties[$r->sob_all_name] = $r->sob_text_format;
}
while (list($key, $value) = each($_POST)) {
if (in_array($key, $recordFields)) {
$formFields[] = $key;
$formValues[] = reformatField($value, $fieldProperties[$key]);
}
}
reset($_POST);
// if the following fields are in the table they will be updated
<?php
include "../../include.php";
$r = db_grab("SELECT \n\t\t\t\tq.query, \n\t\t\t\tq.name,\n\t\t\t\td.dbname\n\t\t\tFROM queries q\n\t\t\tJOIN queries_databases d ON q.databaseID = d.id\n\t\t\tWHERE q.id = " . $_GET["id"]);
db_switch($r["dbname"]);
if (!($result = db_query($r["query"], false, true))) {
url_change("./query_edit.php?id=" . $_GET["id"], true);
}
$filename = $r["name"];
$num_columns = db_num_fields($result);
$num_rows = 0;
$fields = array();
//get header row
for ($i = 0; $i < $num_columns; $i++) {
$name = db_fetch_field($result, $i);
array_push($fields, $name->name . "|||" . db_field_type($result, $i));
}
$return = '
<table border="1">
<tr bgcolor="#fffceo">';
foreach ($fields as $field) {
list($name, $datatype) = explode("|||", $field);
$return .= '
<td><b>' . trim(str_replace("_", " ", $name)) . '</b></td>
';
}
$return .= '</tr>';
while ($r = db_fetch($result)) {
$return .= '<tr>';
reset($fields);
foreach ($fields as $field) {
