}
echo "Processing the table " . $tableName . "\n";
$filePath = "seed/" . snake_to_camel($tableName) . "TableSeeder.php";
$file = fopen($filePath, "w");
$firstRow = ignore_timestamps(mysql_fetch_assoc($result));
$truncate = isset($opts['t']) ? true : false;
fwrite($file, get_head($tableName, $truncate));
if ($firstRow) {
print_comparison(array_keys($firstRow), $columns);
mysql_data_seek($result, 0);
while ($row = ignore_timestamps(mysql_fetch_assoc($result))) {
$newRow = [];
foreach ($columns as $field) {
$newRow[$field] = isset($row[$field]) ? $row[$field] : "";
}
$line = format_row($newRow);
fwrite($file, $line);
}
}
fwrite($file, get_tail());
echo "File " . $filePath . " created\n";
fclose($file);
}
}
mysql_close($conn);
function print_comparison($array1, $array2)
{
$result = "[";
$ignored = array_diff($array1, $array2);
foreach ($ignored as $field) {
$result .= "[31m-" . $field . ",";
function format_row_duration($col, &$def, &$data)
{
if (isset($data['LASTCHANGE']) && $data['LASTCHANGE'] == 0) {
echo '<span>—</span>';
return;
}
return format_row($col, $def, $data);
}
function format_table(&$osv)
{
$rows = $osv['text'];
$b = array();
$c = array();
$d = array();
getBalls($osv['results'], $b, $c, $d);
//===begin table===
$result = '<table border="1">';
//===head===
$result .= '<thead><tr><th>Фамилия, имя</th>';
$res = mysql_query("select problem.name from mdl_problemstatement problemstatement join mdl_problemstatement_problem problem on (problem.id=problemstatement.problem_id) order by problemstatement.id");
// where course=...
if (!$res) {
print mysql_error();
}
while ($row = mysql_fetch_assoc($res)) {
$result .= '<th>' . $row['name'] . '</th>';
}
$result .= '<th>Количество решенных задач</th><th>Баллы за решение задач</th></tr></thead>';
//===foot===
$result .= '<tfoot><tr><td>Количество верных решений</td>';
$res = mysql_query("select id,name from mdl_problemstatement order by id");
//where course=...
if (!$res) {
print mysql_error();
}
while ($problemstatementrow = mysql_fetch_assoc($res)) {
$problemstatementid = $problemstatementrow['id'];
$i = 0;
$res1 = mysql_query("select id,deleted from mdl_user where id>25 and deleted=0");
// where group = ...
if (!$res1) {
print mysql_error();
}
while ($users = mysql_fetch_assoc($res1)) {
$userid = $users['id'];
$res2 = mysql_query("select count(submissions.succeeded) from mdl_problemstatement_submissions submissions where (submissions.problemstatement={$problemstatementid}) and (submissions.userid={$userid}) and (submissions.succeeded=1) and (submissions.processed=1)");
if (!$res2) {
print mysql_error();
}
$count = mysql_fetch_row($res2);
$count = $count[0];
if ($count > 0) {
++$i;
}
}
$result .= '<td>' . $i . '</td>';
}
$result .= '<td></td><td></td></tr>';
$result .= '<tr><td>Баллы за задачу</td>';
foreach ($b as $id => $ball) {
$result .= "<td>{$ball}</td>";
}
$result .= '<td></td><td></td></tr>';
$result .= '</tfoot>';
//===content===
$result .= '<tbody>';
foreach ($rows as $key => $row) {
if ($row) {
$result .= '<tr>' . format_row($row) . "<td>" . $c[$key] . "</td>" . '</tr>';
}
}
//===end table===
$result .= '</tbody></table>';
$d2 = array();
$max_key = max(array_keys($d));
for ($i = 0; $i <= $max_key; ++$i) {
if (array_key_exists($i, $d)) {
$d2[$i] = $d[$i];
} else {
$d2[$i] = 0;
}
}
$str = implode(';', $d2);
global $grsize;
$result .= '<p><font size="6"><strong>Распределение баллов</strong></font></p>';
$result .= "<img src='histogram.php?grsize={$grsize}&vals={$str}'></img>";
return $result;
}
