Panos Papadatos's Replies | eduTrac SIS Support Center

[Panos Papadatos]

Hi again,

in such a way how can I create a custom footer..

For example I don’ t want the classic line with page number but a date and a small logo…

Thanks in advance

Panos

 

[Panos Papadatos]

Yes finally that’s the solution …

 

I’m totally missed it ..

 

Thank you Joshua ..

Panos

[Panos Papadatos]

In  final-grade.php ?

[Panos Papadatos]

With more details … (these are the 3 steps)

1. The database field is      sect_grade_month     DATE

2. In gradebook.router.php i change the code to this

$app->match(‘GET|POST’, ‘/sect/final-grade/(\d+)/’, function ($id) use($app, $css, $js, $logger, $flashNow) {

if ($app->req->isPost()) {
$size = count($_POST[‘stuID’]);
$i = 0;
while ($i < $size) {
if (acadCredGradePoints($_POST[‘grade’][$i], $_POST[‘attCredit’]) > 0) {
$compCred = $_POST[‘attCredit’];
} else {
$compCred = ‘0’;
}

$gr = $app->db->stu_acad_cred();
$gr->grade = $_POST[‘grade’][$i];
$gr->gradePoints = acadCredGradePoints($_POST[‘grade’][$i], $_POST[‘attCredit’]);
///PANOS
$gr->sect_grade_month = $_POST[‘sect_grade_month’][$i];
error_log($_POST[‘sect_grade_month’][$i]);
$gr->compCred = $compCred;
$gr->where(‘courseSecID = ?’, $id)
->_and_()
->where(‘stuID = ?’, $_POST[‘stuID’][$i]);
if ($gr->update()) {
$app->flash(‘success_message’, $flashNow->notice(200));
}
$logger->setLog(‘Update Record’, ‘Final Grade’, get_name($_POST[‘stuID’][$i]) . ‘ (‘ . $_POST[‘courseSection’] . ‘)’, get_persondata(‘uname’));
++$i;
}
redirect($app->req->server[‘HTTP_REFERER’]);
}

$grade = $app->db->stu_acad_cred()
->setTableAlias(‘a’)
->select(‘a.stuID,a.courseSecCode,a.termCode,a.courseSection’)
//PANOS
->select(‘a.grade,b.secShortTitle,b.minCredit,b.courseSecID, a.sect_grade_month’)
->_join(‘course_sec’, ‘a.courseSecID = b.courseSecID’, ‘b’)
->where(‘a.courseSecID = ?’, $id)
->_and_()
->where(‘b.facID = ?’, get_persondata(‘personID’));
$q = $grade->find(function ($data) {
$array = [];
foreach ($data as $d) {
$array[] = $d;
}
return $array;
});

/**
* If the database table doesn’t exist, then it
* is false and a 404 should be sent.
*/
if ($q == false) {

$app->view->display(‘error/404’, [
‘title’ => ‘404 Error’
]);
} /**
* If the query is legit, but there
* is no data in the table, then 404
* will be shown.
*/ elseif (empty($q) == true) {

$app->view->display(‘error/404’, [
‘title’ => ‘404 Error’
]);
} /**
* If data is zero, 404 not found.
*/ elseif (count($q[0][‘courseSecID’]) <= 0) {

$app->view->display(‘error/404’, [
‘title’ => ‘404 Error’
]);
} /**
* If we get to this point, the all is well
* and it is ok to process the query and print
* the results in a html format.
*/ else {

$app->view->display(‘section/final-grade’, [
‘title’ => $q[0][‘courseSection’],
‘cssArray’ => $css,
‘jsArray’ => $js,
‘sect’ => $q
]);
}
});

 

 

 

3. and in final-grade.php i create another field after grade

<tr class=”gradeX”>
<td class=”text-center”><?=_h($v[‘courseSection’]);?></td>
<td class=”text-center”>
<?=get_name(_h($v[‘stuID’]));?>
<input type=”hidden” name=”stuID[]” value=”<?=_h($v[‘stuID’]);?>” />
</td>
<td class=”text-center”>
<?=grading_scale(_h($v[‘grade’]));?>
</td>
<td style=”display:none;”>
<input type=”hidden” name=”courseSecID” value=”<?=_h($v[‘courseSecID’]);?>” />
<input type=”hidden” name=”termCode” value=”<?=_h($v[‘termCode’]);?>” />
</td>
<td width=”15%” class=”text-center”>

<input class=”form-control” type=”text” name=”sect_grade_month” value=”<?=_h($v[‘sect_grade_month’]);?>” />

</td>
</tr>

 

 

I believe that something missed and cannot pass the variable value to router to save it…

Perhaps something in final-grade.php

 

Thanks in advance

Panos

[Panos Papadatos]

Hi Joshua

Yes.. in the table where the final grade has to be written..

 

Panos.

[Panos Papadatos]

I found a partial error I didn’t put in person.router.php the code for the new form …

 

But know in the final execution i have a little bug…

 

I cannot view / display the record.

If i click SAVE then everything i have inserted SAVED succesfully but cannot display the record …

Does anyone know where must i put the code to display the record ???

In person.router.php or elsewhere ?

 

Thanks in advance

Panos

 

[Panos Papadatos]

Hi Joshua,

finally after a lot of searching the reason was PROXY server …

For some reason when trying to connect outside (for gravatar or amazon) take too long to respond… After disabling for the server to connect to internet through proxy everything was fine..

And much more fast without outside connections for update and gravatar..

 

Thanks for your help.

Panos

 

[Panos Papadatos]

Is it possible to give me any hints how to disable looking for gravatars ???

To check if it is the reason ??

Panos

[Panos Papadatos]

Nothing happened …

Only the message disappeared …

 

If you want to simulate the situation you must put a invalid IP for DNS in SERVER’s network setting. So server do not have internet connection … and after that

eduTrac SIS Fully Loaded time is something between 15 and 20

 

In my case client has Internet and works fine with following parameters

IP 192.168.1.5

MASK 255.255.255.0

GATEWAY 192.168.1.1

DNS 192.168.1.1

 

Server has local network but no INternet bacuse of wrong DNS

IP 192.168.1.7

MASK 255.255.255.0

GATEWAY 192.168.1.1

DNS 192.168.1.99  ****

 

In that case we have delays in every screen TERM, SEMESTER, PERSON etc

 

if i change DNS on SERVER to 192.168.1.1 then works fine … again…

 

PANOS

[Panos Papadatos]

I think that you don’t understand exactly …

 

I believe that because every time trying to connect to

http://etsis.s3.amazonnaws.com/core/1.1/update-check/update.json

to check for an auto update and because of a possible problem in my DNS server

that procedure takes too long to return and after that i have a delay in every screen

This is the bench marking result of selecting Term screen ..
<table>
<thead>
<tr>
<td>Time (s)</td>
<td>Memory (mb)</td>
<td>Files</td>
<td class=”align-right”>Classes</td>
<td class=”align-right”>%</td>
</tr>
</thead>
<tbody>
<tr>
<td>Start</td>
<td>0</td>
<td>1.41</td>
<td>110</td>
<td class=”align-right”>170</td>
<td class=”align-right”>0%</td>
</tr>
<tr>
<td>eduTrac SIS Loaded</td>
<td>0.2571</td>
<td>1.556</td>
<td>9</td>
<td class=”align-right”>3</td>
<td class=”align-right”>1% (1%)</td>
</tr>
<tr>
<td>eduTrac SIS Fully Loaded</td>
<td>25.4109</td>
<td>1.85</td>
<td>25</td>
<td class=”align-right”>23</td>
<td class=”align-right”>98% (97%)</td>
</tr>
<tr>
<td>Finish</td>
<td>25.6686</td>
<td>1.8431</td>
<td>149</td>
<td class=”align-right”>19</td>
</tr>
</tbody>
</table>
Panos

[Panos Papadatos]

A little help on that

“I believe you can use a filter to override it and turn it off.”

 

you mean filter on the files to see in which of them there is such a call ?

Panos

 

[Panos Papadatos]

the only thing that log says is – in every menu click ..

cannot connect to s3.amazon (i have no connection right now to the server) to get a json file with the latest updates … And of course cannot display the message in the bottom of menu “eduTrac SIS release 6.3.2 is available for download/upgrade. Before upgrading, make sure to backup your system.”

 

Do you believe that perhaps that’s the reason for the delay … ??

 

Regards

Panos

[Panos Papadatos]

Is there any possibility in every screen trying to connect to an external URL and this is the reason why takes time to respond ??

 

you mean to app/tmp/logs????

 

Regards

Panos

[Panos Papadatos]

Yes STTR screen in SPRO..

 

In addition with that (finding the current term of the student), I would like to ask why a student on his Dashboard (the Home Page of the Edutrac SIS) can see all the courses (even from different programs….) although he is already a part of specific program …

 

by mistake he can choose a wrong course to register !!!!

 

Panos

[Panos Papadatos]

In which file is this code that present the recent news from edutracsis ??