public function update(Student $object)
{
$q = "UPDATE " . self::TABLE . " SET `name`='" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "' WHERE studentId='" . addslashes($object->getStudentId()) . "'";
$pk = $object->getStudentId();
if ($object->isNew()) {
if (empty($pk)) {
$q = "INSERT INTO " . self::TABLE . " (`name`) VALUES ('" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "')";
} else {
$q = "INSERT INTO " . self::TABLE . " (`name`) VALUES ('" . Singleton::create("NullConverter")->fromDOMtoDB($object->getStudentId()) . "', '" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "')";
}
}
$this->db->updateQuery($q);
if (empty($pk)) {
$pk = $this->db->selectQuery("SELECT studentId from " . self::TABLE . " ORDER BY studentId DESC limit 1")->getSingleton();
}
$result = $this->findByPrimaryKey($pk);
parent::$dbCache->resetEntity("Student");
parent::$dbCache->setSingle("Student", $pk, $result);
return $result;
}
function testFind()
{
//arrange
$student_name = "Chemistry";
$student_id = 1;
$student_number = "2015-12-12";
$test_student = new Student($student_name, $student_number, $student_id);
$test_student->save();
$student_name2 = "Underwater Basketweaving";
$student_id2 = 2;
$student_number2 = "2015-12-12";
$test_student2 = new Student($student_name2, $student_number2, $student_id2);
$test_student2->save();
//act
$result = Student::find($test_student->getStudentId());
//assert
$this->assertEquals($test_student, $result);
}
$datos = explode("|", $linea);
switch ($opcion) {
case 1:
$student = new Student($db);
$id_student = $student->getStudentId($datos[1]);
$debt_share = new DebtShare($db);
$data = array(1, $id_student, $datos[0], $datos[3], $datos[4], $datos[5]);
$id = $debt_share->insertDebtShare($data, $idTransaction);
//adicionar la confirmacion o error del insert
//adicionar registro de los logs
$res = $id;
//resultado final
break;
case 2:
$student = new Student($db);
$id_student = $student->getStudentId($datos[0]);
$debt_share = new DebtShare($db);
$data = array(2, $id_student, $datos[0], $datos[3], $datos[4], $datos[5]);
//corregir esto la estructura de la tabla es diferente
$id = $debt_share->insertDebtShare($data, $idTransaction);
//adicionar la confirmacion o error del insert
//adicionar registro de los logs
$res = $id;
//resultado final
break;
}
$contador = $contador + 1;
}
if ($res > 0) {
$msg = "<br>Total Registros Cargados: " . $contador;
Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_UPLOAD"], $v_label["DETAIL_MESSAGE_OK_UPLOAD"] . $msg);
/**
* @param Student $Student
*/
public function setStudent($Student)
{
$this->Student = $Student;
$this->student_id = $Student->getStudentId();
}
<input id="firstN" size="30" maxlength="50" type="text" name="firstN" required value=<?php
echo $student->getFirstName();
?>
>
</div>
<div class="field">
<label for="lastN">Last Name</label>
<input id="lastN" size="30" maxlength="50" type="text" name="lastN" required value=<?php
echo $student->getLastName();
?>
>
</div>
<div class="field">
<label for="studID">Student ID</label>
<input id="studID" size="30" maxlength="7" type="text" pattern="[A-Za-z]{2}[0-9]{5}" title="AB12345" name="studID" disabled value=<?php
echo $student->getStudentId();
?>
>
</div>
<div class="field">
<label for="email">E-mail</label>
<input id="email" size="30" maxlength="255" type="email" name="email" required value=<?php
echo $student->getEmail();
?>
>
</div>
<div class="field">
<label for="major">Major</label>
<select id="major" name = "major">
<option <?php
if ($student->getMajor() == 'CMPE') {
