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); }