Перелік іспитів

Повернутися

З  По Іспити Навчання Всі

№ пп П.І.Б Дата Результат Назва дисципліни

“;

if($testmode==’1′)
{ $all_results = $wpdb->get_results($wpdb->prepare(“SELECT a.id,a.dateres,a.user_login,a.testmode,a.correctq,a.totalq,a.percent,a.testtime,a.testname,a.hesh,b.name,b.id_kod, c.user_lastname, c.user_name, c.user_middlename FROM testresults a,{$wpdb->prefix}mtouchquiz_quiz b, wpdn_users c WHERE a.testmode=1 and a.testname=b.id_kod and a.user_login=c.user_login AND (DATE(a.dateres)>= ‘$startdate’ AND DATE(a.dateres)<='$enddate' ) ORDER BY a.dateres DESC")); } if($testmode=='2') { $all_results = $wpdb->get_results($wpdb->prepare(“SELECT a.id,a.dateres,a.user_login,a.testmode,a.correctq,a.totalq,a.percent,a.testtime,a.testname,a.hesh,b.name,b.id_kod, c.user_lastname, c.user_name, c.user_middlename FROM testresults a,{$wpdb->prefix}mtouchquiz_quiz b, wpdn_users c WHERE a.testmode=0 and a.testname=b.id_kod and a.user_login=c.user_login AND (DATE(a.dateres)>= ‘$startdate’ AND DATE(a.dateres)<='$enddate' ) ORDER BY a.dateres DESC")); } if($testmode=='3') { $all_results = $wpdb->get_results($wpdb->prepare(“SELECT a.id,a.dateres,a.user_login,a.testmode,a.correctq,a.totalq,a.percent,a.testtime,a.testname,a.hesh,b.name,b.id_kod, c.user_lastname, c.user_name, c.user_middlename FROM testresults a,{$wpdb->prefix}mtouchquiz_quiz b, wpdn_users c WHERE a.testname=b.id_kod and a.user_login=c.user_login AND (DATE(a.dateres)>= ‘$startdate’ AND DATE(a.dateres)<='$enddate' ) ORDER BY a.dateres DESC")); } $i=1; $b_body=""; $N_teach=0; $N_test=0; $P_teach=0; $P_test=0; $T_teach=0; $T_test=0; foreach ($all_results as $data) { if($data->testmode==’1′) $b_body.=’

‘.$i.’

‘;
else $b_body.=’

‘.$i.’

‘;
//if($data->testmode==’1′)
$b_body.=’

‘.$data->percent.’ %

‘;
else $b_body.=’

‘.$data->percent.’ %

‘;
$N_teach++;
$P_teach=$P_teach+$data->percent;
$T_teach=$T_teach+$data->testtime;
}

$b_body.=’

‘.$data->name.’

‘;
$b_body.=’

‘;
$i++;
}
echo $b_body;
echo “

“;
if($N_test!=0) { $P_test=$P_test/$N_test; $T_test=$T_test/$N_test; }
if($N_teach!=0) { $P_teach=$P_teach/$N_teach; $T_teach=$T_teach/$N_teach; }
echo “

Статистика

“;
echo ‘НАВЧАННЯ:
‘;
echo ‘Кількість: ‘.$N_teach.’
‘;
echo ‘Успішність: ‘.$P_teach.’ %
‘;
echo ‘Тривалість: ‘.$T_teach.’ хвил.
‘;
echo ‘Іспит:
‘;
echo ‘Кількість: ‘.$N_test.’
‘;
echo ‘Успішність: ‘.$P_test.’ %
‘;
echo ‘Тривалість: ‘.$T_test.’ хвил.
‘;
?>