$config = new Config(); $webPage = new PJSWebPage($config->getTitle() . "Contacts - Add Contact"); $body = ''; $act = Tools::Param('act'); if ("Add Contact" === $act) { $model = new ContactModel(); $model->populateFromForm(); if (!$model->validateForAdd()) { $view = new ContactFormView('Add Contact', $model); $body = "<h2>Invalid data</h2>\n" . $view->getForm(); } else { $contactController = new ContactController(); $newId = $contactController->add($model); if ($newId > 0) { $body = "Added contact # " . $newId . "<br />\n"; } } } else { $body = ""; $contactModel = new ContactModel(); $companyId = '' === Tools::param('contactCompanyId') ? 0 : Tools::param('contactCompanyId'); $contactModel->setContactCompanyId($companyId); $contactModel->setContactName(Tools::param('contactName')); $contactModel->setContactEmail(Tools::param('contactEmail')); $contactModel->setContactPhone(Tools::param('contactPhone')); $contactModel->setContactAlternatePhone(Tools::param('contactAlternatePhone')); $view = new ContactFormView("Add Contact", $contactModel); $body = $view->getForm(); } $webPage->setBody($body); $webPage->displayPage();
exit(0); // Should never get here but just in case... } $companyId = Tools::param('contactCompanyId'); $name = Tools::param('contactName'); $email = Tools::param('contactEmail'); $phone = Tools::param('contactPhone'); $alternatePhone = Tools::param('contactAlternatePhone'); $rowId = Tools::param('rowId'); $result = 'OK'; $contactId = ''; $newContactModel = null; try { $contactModel = new ContactModel(); $contactModel->setContactCompanyId($companyId); $contactModel->setContactName($name); $contactModel->setContactEmail($email); $contactModel->setContactPhone($phone); $contactModel->setContactAlternatePhone($alternatePhone); $contactController = new ContactController(); $contactId = $contactController->add($contactModel); if (!($contactId > 0)) { throw new ControllerException("Add failed."); } $newContactModel = $contactController->get($contactId); $contactRowView = new ContactListView(); $row = $contactRowView->displayContactRow($newContactModel, 'list'); } catch (ControllerException $e) { $contactRowView = new ContactListView('html', null); $contactModel->setId($rowId); $row = $contactRowView->displayContactRow($contactModel, 'add', 'Add Contact record failed. ' . $e->getMessage());
/** * @see ControllerBase::getSome() */ public function getSome($whereClause = '1 = 1') { $sql = <<<SQL SELECT id , contactCompanyId , contactName , contactEmail , contactPhone , contactAlternatePhone , created , updated FROM contact WHERE {$whereClause} ORDER BY contactName SQL; $stmt = $this->_dbh->prepare($sql); if (!$stmt) { throw new ControllerException('Failed to prepare SELECT statement. (' . $this->_dbh->error . ')'); } if (!$stmt->execute()) { throw new ControllerException('Failed to execute SELECT statement. (' . $this->_dbh->error . ')'); } $stmt->bind_result($id, $contactCompanyId, $contactName, $contactEmail, $contactPhone, $contactAlternatePhone, $created, $updated); $models = array(); while ($stmt->fetch()) { $model = new ContactModel(); $model->setId($id); $model->setContactCompanyId($contactCompanyId); $model->setContactName($contactName); $model->setContactEmail($contactEmail); $model->setContactPhone($contactPhone); $model->setContactAlternatePhone($contactAlternatePhone); $model->setCreated($created); $model->setUpdated($updated); $models[] = $model; } return $models; }