public static function SheetAppend(Ab_Database $db, $d)
{
$a = array(30, 30, 40);
$typeSheet = $d->typeSheet;
if ($typeSheet === 3 || $typeSheet === 4 || $d->isPractic) {
$a[0] = 0;
$a[1] = 0;
$a[2] = 100;
}
$sql = "\n\t\t\tINSERT INTO " . $db->prefix . "rb_sheet (subjectid, groupid, firstattproc, secondattproc, thirdattproc, date, type, teacherid)\n\t\t\tVALUES (\n\t\t\t\t\t" . bkint($d->idSubject) . ",\n\t\t\t\t\t" . bkint($d->groupid) . ",\n\t\t\t\t\t\t" . $a[0] . ",\n\t\t\t\t\t\t" . $a[1] . ",\n\t\t\t\t\t\t" . $a[2] . ",\t\t\n\t\t\t\t\t" . bkint($d->date) . ",\n\t\t\t\t\t" . bkint($typeSheet) . ",\n\t\t\t\t\t" . bkint($d->teacherid) . "\n\t\t\t)\n\t\t";
$db->query_write($sql);
$idSheet = $db->insert_id();
$arrStud = array();
$valIns = "";
if ($d->typeSheet === 2 || $d->typeSheet === 4) {
$arrStud = $d->arrStudId;
$arrCount = count($arrStud);
} else {
$sql = "\n \t\t\t\tSELECT id\n \t\t\t\tFROM " . $db->prefix . "rb_students\n \t\t\t\tWHERE groupid=" . bkint($d->groupid) . " AND transferal = 0\n \t\t\t";
$rows = $db->query_read($sql);
while ($d = $db->fetch_row($rows)) {
array_push($arrStud, $d[0]);
}
$arrCount = count($arrStud);
}
if ($arrCount === 0) {
return false;
}
RecordBookQuery::AppendMarks($db, $arrStud, $idSheet);
}
