public function update(Teacher $object) { $q = "UPDATE " . self::TABLE . " SET `name`='" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "' WHERE teacherId='" . addslashes($object->getTeacherId()) . "'"; $pk = $object->getTeacherId(); 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->getTeacherId()) . "', '" . Singleton::create("NullConverter")->fromDOMtoDB($object->getName()) . "')"; } } $this->db->updateQuery($q); if (empty($pk)) { $pk = $this->db->selectQuery("SELECT teacherId from " . self::TABLE . " ORDER BY teacherId DESC limit 1")->getSingleton(); } $result = $this->findByPrimaryKey($pk); parent::$dbCache->resetEntity("Teacher"); parent::$dbCache->setSingle("Teacher", $pk, $result); return $result; }
public function makepdf() { global $user; // Get required files. require_once 'others/fpdf/fpdf.php'; // Set some document variables $author = "eduCloud"; $x = 35; $text = <<<EOT Hello EOT; // Create fpdf object $pdf = new FPDF('P', 'pt', 'Letter'); // Set base font to start $pdf->SetFont('Arial', 'B', 16); // Add a new page to the document $pdf->addPage(); $pdf->setLeftMargin($x); //page border $pdf->Line(35, 30, 35, 750); $pdf->Line(35, 30, 575, 30); $pdf->Line(575, 30, 575, 750); $pdf->Line(575, 750, 35, 750); //end of page border // Set the x,y coordinates of the cursor $pdf->SetXY($x + 20, 40); // Write 'Simple PDF' with a line height of 1 at the current position $pdf->Write(25, 'Employee Details'); $pdf->Image($_SERVER['DOCUMENT_ROOT'] . '/cloud/images/school_logo.jpg', 500, 35, 50, 50, 'JPG'); // Reset the font // Reset font, color, and coordinates $pdf->SetFont('Arial', '', 12); $pdf->SetTextColor(0, 0, 0); $pdf->SetLeftMargin($x + 50); $pdf->setXY($x + 50, 90); global $objPDO; require_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/teacher_class.php'; $record = new Teacher($objPDO); if ($user->checkAdmin()) { $eid = $_GET['uid']; } else { $student = new Student($objPDO, $user->getuserId()); $eid = $student->getID(); } $record->loadByUserId($eid); // Write out a long text blurb. //$array=$record->getAsArray(); //$x=0; /* TEMPLATE 1 DESIGN*/ $pdf->SetFont('Arial', '', 8); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, 'Employee Id (reference) : ' . $record->getTeacherId(), 0, 1, 'L', true); $pdf->SetFont('Arial', '', 12); $pdf->setFillColor(50, 50, 50); $pdf->setTextColor(255, 255, 255); $pdf->cell(450, 20, 'Employee Details', 0, 1, 'C', true); $pdf->setTextColor(0, 0, 0); $pdf->setFillColor(221, 221, 221); $pdf->cell(200, 20, 'Employee Name', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getName(), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, 'Qualification', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getQualification(), 0, 1, 'C', true); require_once $_SERVER['DOCUMENT_ROOT'] . '/cloud/model/subject_class.php'; $subject_id = new Subject($objPDO); $subject_id->setID($record->getSubjectId()); $pdf->setFillColor(221, 221, 221); $pdf->cell(200, 20, 'Subject', 0, 0, 'C', true); $pdf->cell(250, 20, $subject_id->getName(), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, 'Date Of Birth', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getDateOfBirth(), 0, 1, 'C', true); $pdf->setFillColor(221, 221, 221); $pdf->cell(200, 20, 'Gender', 0, 0, 'C', true); $pdf->cell(250, 20, ucfirst($record->getGender()), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, 'Blood Group', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getBloodGroup(), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, '', 0, 0, 'C', true); $pdf->cell(250, 20, '', 0, 1, 'C', true); $pdf->setFillColor(50, 50, 50); $pdf->setTextColor(255, 255, 255); $pdf->cell(450, 20, 'Contact Details', 0, 1, 'C', true); $pdf->setTextColor(0, 0, 0); $pdf->setFillColor(221, 221, 221); $pdf->cell(200, 20, 'Correspondence Address', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getCorrespondenceAddressLine1(), 0, 1, 'C', true); $pdf->cell(200, 20, '', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getCorrespondenceAddressLine2(), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, 'City', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getCorrespondenceCity(), 0, 1, 'C', true); $pdf->setFillColor(221, 221, 221); $pdf->cell(200, 20, 'State', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getCorrespondenceState(), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, 'Pincode', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getCorrespondencePincode(), 0, 1, 'C', true); $pdf->setFillColor(221, 221, 221); $pdf->cell(200, 20, 'Phone', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getPhone(), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, 'Mobile', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getMobile(), 0, 1, 'C', true); $pdf->setFillColor(221, 221, 221); $pdf->cell(200, 20, 'Email', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getEmail(), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(450, 20, '', 0, 1, 'C', true); $pdf->setFillColor(50, 50, 50); $pdf->setTextColor(255, 255, 255); $pdf->cell(450, 20, 'Login Details', 0, 1, 'C', true); $pdf->setTextColor(0, 0, 0); $pdf->setFillColor(221, 221, 221); $pdf->cell(200, 20, 'Employee Id *', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getTeacherId(), 0, 1, 'C', true); $pdf->setFillColor(255, 255, 255); $pdf->cell(200, 20, 'Temporary Password **', 0, 0, 'C', true); $pdf->cell(250, 20, $record->getTempPass(), 0, 1, 'C', true); /* TEMPLATE 1 DESIGN END*/ $pdf->SetFont('Arial', '', 10); $pdf->SetXY($x + 100, 620); $pdf->write(15, 'Employee\'s Signature'); $pdf->SetXY($x + 350, 620); $pdf->write(15, 'Admin\'s Signature'); $pdf->SetFont('Arial', '', 8); $pdf->SetXY($x + 20, 710); $pdf->write(15, '* Employee Id may be Temporary , ** Please Change the Password for Security Reasons'); $pdf->SetXY($x + 20, 720); $pdf->write(15, 'This is a Computer Generated Form. If any Discrepancy Contact Admin : eduCloud Reference Number ' . $user->getuserId()); // Close the document and save to the filesystem with the name simple.pdf $pdf->Output('generated_files/enroll' . $record->getUserId() . '.pdf', 'F'); header('Location:http://localhost/cloud/generated_files/enroll' . $record->getUserId() . '.pdf'); }