function build_csv_from_contact(Contact $contact, $checked) { $str = ''; if (isset($checked['first_name']) && $checked['first_name'] == 'checked') $str .= self::build_csv_field($contact->getFirstName()); if (isset($checked['surname']) && $checked['surname'] == 'checked') $str .= self::build_csv_field($contact->getSurname()); if (isset($checked['email']) && $checked['email'] == 'checked') $str .= self::build_csv_field($contact->getEmailAddress('personal')); if (isset($checked['company_id']) && $checked['company_id'] == 'checked') $str .= self::build_csv_field($contact->getCompany() ? $contact->getCompany()->getObjectName() : ""); if (isset($checked['w_web_page']) && $checked['w_web_page'] == 'checked') $str .= self::build_csv_field($contact->getWebPageUrl('work')); $work_address = $contact->getAddress('work'); if ($work_address){ if (isset($checked['w_address']) && $checked['w_address'] == 'checked') $str .= self::build_csv_field($work_address->getStreet()); if (isset($checked['w_city']) && $checked['w_city'] == 'checked') $str .= self::build_csv_field($work_address->getStreet()); if (isset($checked['w_state']) && $checked['w_state'] == 'checked') $str .= self::build_csv_field($work_address->getState()); if (isset($checked['w_zipcode']) && $checked['w_zipcode'] == 'checked') $str .= self::build_csv_field($work_address->getZipcode()); if (isset($checked['w_country']) && $checked['w_country'] == 'checked') $str .= self::build_csv_field($work_address->getCountryName()); } if (isset($checked['w_phone_number']) && $checked['w_phone_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('work',true)); if (isset($checked['w_phone_number2']) && $checked['w_phone_number2'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('work')); if (isset($checked['w_fax_number']) && $checked['w_fax_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('fax',true)); if (isset($checked['w_assistant_number']) && $checked['w_assistant_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('assistant')); if (isset($checked['w_callback_number']) && $checked['w_callback_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('callback')); if (isset($checked['h_web_page']) && $checked['h_web_page'] == 'checked') $str .= self::build_csv_field($contact->getWebPageUrl('personal')); $home_address = $contact->getAddress('home'); if ($home_address){ if (isset($checked['h_address']) && $checked['h_address'] == 'checked') $str .= self::build_csv_field($home_address->getStreet()); if (isset($checked['h_city']) && $checked['h_city'] == 'checked') $str .= self::build_csv_field($home_address->getCity()); if (isset($checked['h_state']) && $checked['h_state'] == 'checked') $str .= self::build_csv_field($home_address->getState()); if (isset($checked['h_zipcode']) && $checked['h_zipcode'] == 'checked') $str .= self::build_csv_field($home_address->getZipcode()); if (isset($checked['h_country']) && $checked['h_country'] == 'checked') $str .= self::build_csv_field($home_address->getCountryName()); } if (isset($checked['h_phone_number']) && $checked['h_phone_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('home',true)); if (isset($checked['h_phone_number2']) && $checked['h_phone_number2'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('home')); if (isset($checked['h_fax_number']) && $checked['h_fax_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('fax')); if (isset($checked['h_mobile_number']) && $checked['h_mobile_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('mobile')); if (isset($checked['h_pager_number']) && $checked['h_pager_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('pager')); if (isset($checked['o_web_page']) && $checked['o_web_page'] == 'checked') $str .= self::build_csv_field($contact->getWebPageUrl('other')); $other_address = $contact->getAddress('other'); if ($other_address){ if (isset($checked['o_address']) && $checked['o_address'] == 'checked') $str .= self::build_csv_field($other_address->getStreet()); if (isset($checked['o_city']) && $checked['o_city'] == 'checked') $str .= self::build_csv_field($other_address->getCity()); if (isset($checked['o_state']) && $checked['o_state'] == 'checked') $str .= self::build_csv_field($other_address->getState()); if (isset($checked['o_zipcode']) && $checked['o_zipcode'] == 'checked') $str .= self::build_csv_field($other_address->getZipcode()); if (isset($checked['o_country']) && $checked['o_country'] == 'checked') $str .= self::build_csv_field($other_address->getCountryName()); } if (isset($checked['o_phone_number']) && $checked['o_phone_number'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('other',true)); if (isset($checked['o_phone_number2']) && $checked['o_phone_number2'] == 'checked') $str .= self::build_csv_field($contact->getPhoneNumber('other')); if (isset($checked['o_birthday']) && $checked['o_birthday'] == 'checked') $str .= self::build_csv_field($contact->getBirthday()); $personal_emails = $contact->getContactEmails('personal'); if (isset($checked['email2']) && $checked['email2'] == 'checked' && !is_null($personal_emails) && isset($personal_emails[0])) $str .= self::build_csv_field($personal_emails[0]->getEmailAddress()); if (isset($checked['email3']) && $checked['email3'] == 'checked' && !is_null($personal_emails) && isset($personal_emails[1])) $str .= self::build_csv_field($personal_emails[1]->getEmailAddress()); if (isset($checked['job_title']) && $checked['job_title'] == 'checked') $str .= self::build_csv_field($contact->getJobTitle()); if (isset($checked['department']) && $checked['department'] == 'checked') $str .= self::build_csv_field($contact->getDepartment()); $str = str_replace(array(chr(13).chr(10), chr(13), chr(10)), ' ', $str); //remove line breaks return $str; }
public function updateContact(Contact $contact) { if ($contact != null && ($contact->getId() == null || $contact->getId() == -1)) { return false; } try { if ($contact->getAddress() != null && $contact->getAddress()->getId() != null && $contact->getAddress()->getId() != -1) { $this->addressService->updateAddress($contact->getAddress()); } if (!parent::getBdd()->inTransaction()) { parent::getBdd()->beginTransaction(); } $query = "UPDATE CONTACT SET firstName = :fName, name = :name, mail = :mail,\n phone = :phone, phone2 = :phone2, phone3 = :phone3, company = :company, type = :type, exchangeId = :exchangeId\n WHERE id = :id"; $request = parent::getBdd()->prepare($query); $request->bindParam(':id', $contact->getId()); if ($contact->getFirstName() != null) { $request->bindParam(':fName', $contact->getFirstName()); } else { $request->bindValue(':fName', null); } if ($contact->getName() != null) { $request->bindParam(':name', $contact->getName()); } else { $request->bindValue(':name', null); } if ($contact->getMail() != null) { $request->bindParam(':mail', $contact->getMail()); } else { $request->bindValue(':mail', null); } if ($contact->getPhone() != null) { $request->bindParam(':phone', $contact->getPhone()); } else { $request->bindValue(':phone', null); } if ($contact->getPhone2() != null) { $request->bindParam(':phone2', $contact->getPhone2()); } else { $request->bindValue(':phone2', null); } if ($contact->getPhone3() != null) { $request->bindParam(':phone3', $contact->getPhone3()); } else { $request->bindValue(':phone3', null); } if ($contact->getCompany() != null) { $request->bindParam(':company', $contact->getCompany()); } else { $request->bindValue(':company', null); } if ($contact->getType() != null && $contact->getType()->getId() != null && $contact->getType()->getId() != -1) { $request->bindParam(':type', $contact->getType()->getId()); } elseif ($contact->getType() != null && ($contact->getType()->getId() == null || $contact->getType()->getId() == -1) && $contact->getType()->getLabel() != null) { $typeId = $this->typeService->getTypeIdByLabel($contact->getType()->getLabel()); if ($typeId != -1) { $request->bindParam(':type', $typeId); } else { $request->bindValue(':type', null); } } else { $request->bindValue(':type', null); } if ($contact->getExchangeId() != null) { $request->bindParam(':exchangeId', $contact->getExchangeId()); } else { $request->bindValue(':exchangeId', null); } $request->execute(); parent::getBdd()->commit(); $request->closeCursor(); return true; } catch (Exception $e) { error_log($e->getMessage()); } return false; }
public function addContact(Contact $c) { try { $request = new EWSType_CreateItemType(); $contact = new EWSType_ContactItemType(); if ($c->getFirstName() != null) { $contact->GivenName = $c->getFirstName(); } if ($c->getType() != null) { $contact->Surname = $c->getName() . ' -- ' . $c->getType()->getLabel(); } else { $contact->Surname = $c->getName(); } if ($c->getMail() != null) { $email = new EWSType_EmailAddressDictionaryEntryType(); $email->Key = new EWSType_EmailAddressKeyType(); $email->Key->_ = EWSType_EmailAddressKeyType::EMAIL_ADDRESS_1; $email->_ = $c->getMail(); $contact->EmailAddresses = new EWSType_EmailAddressDictionaryType(); $contact->EmailAddresses->Entry[] = $email; } if ($c->getCompany() != null) { $contact->CompanyName = $c->getCompany(); } $addr = $c->getAddress(); if ($addr != null) { $address = new EWSType_PhysicalAddressDictionaryEntryType(); $address->Key = new EWSType_PhysicalAddressKeyType(); $address->Key->_ = EWSType_PhysicalAddressKeyType::BUSINESS; if ($addr->getLine1() != null) { if ($addr->getLine2() != null) { $address->Street = $addr->getLine1() . ' ' . $addr->getLine2(); } else { $address->Street = $addr->getLine1(); } } if ($addr->getCity() != null) { $address->City = $addr->getCity(); } if ($addr->getZipCode() != null) { $address->PostalCode = $addr->getZipCode(); } $contact->PhysicalAddresses = new EWSType_PhysicalAddressDictionaryType(); $contact->PhysicalAddresses->Entry[] = $address; } if ($c->getPhone() != null) { $phone = new EWSType_PhoneNumberDictionaryEntryType(); $phone->Key = new EWSType_PhoneNumberKeyType(); $phone->Key->_ = EWSType_PhoneNumberKeyType::BUSINESS_PHONE; $phone->_ = $c->getPhone(); $contact->PhoneNumbers->Entry[] = $phone; } if ($c->getPhone2() != null) { $phone = new EWSType_PhoneNumberDictionaryEntryType(); $phone->Key = new EWSType_PhoneNumberKeyType(); $phone->Key->_ = EWSType_PhoneNumberKeyType::BUSINESS_PHONE_2; $phone->_ = $c->getPhone2(); if ($contact->PhoneNumbers == null) { $contact->PhoneNumbers = new EWSType_PhoneNumberDictionaryType(); } $contact->PhoneNumbers->Entry[] = $phone; } if ($c->getPhone3() != null) { $phone = new EWSType_PhoneNumberDictionaryEntryType(); $phone->Key = new EWSType_PhoneNumberKeyType(); $phone->Key->_ = EWSType_PhoneNumberKeyType::OTHER_PHONE; $phone->_ = $c->getPhone3(); if ($contact->PhoneNumbers == null) { $contact->PhoneNumbers = new EWSType_PhoneNumberDictionaryType(); } $contact->PhoneNumbers->Entry[] = $phone; } $contact->FileAsMapping = new EWSType_FileAsMappingType(); //? $contact->FileAsMapping->_ = EWSType_FileAsMappingType::FIRST_SPACE_LAST; $request->Items->Contact[] = $contact; $result = parent::getEws()->CreateItem($request); if ($result->ResponseMessages->CreateItemResponseMessage->Items->Contact->ItemId->Id != null) { $c->setExchangeId($result->ResponseMessages->CreateItemResponseMessage->Items->Contact->ItemId->Id); } return true; } catch (Exception $e) { error_log($e->getMessage()); } return false; }
private function disapproveContact($id) { $id = (int) $id; $contact = new Contact($id); $db = \Database::newDB(); $tbl = $db->addTable('prop_contacts'); $tbl->addFieldConditional('id', $id); $db->delete(); $vars = array('first_name' => $contact->getFirstName(), 'last_name' => $contact->getLastName(), 'site_title' => \Layout::getPageTitle(true), 'site_address' => \PHPWS_Core::getHomeHttp(true), 'email_address' => \PHPWS_Settings::get('properties', 'email')); $template = new \Template($vars); $template->setModuleTemplate('properties', 'disapprovalLetter.html'); $content = $template->get(); $this->emailInfo('Manager account not approved', $content, $contact->getEmailAddress()); }
} $app = new Silex\Application(); $app->register(new Silex\Provider\TwigServiceProvider(), array('twig.path' => __DIR__ . '/../views')); //home page $app->get("/", function () use($app) { return $app['twig']->render('address_book.html.twig', array('contacts' => Contact::getAll())); }); //created a contact page $app->post("/create_contact", function () use($app) { $contact = new Contact($_POST['first_name'], $_POST['last_name'], $_POST['image_path'], new Address($_POST['street'], $_POST['city'], $_POST['state'], $_POST['zip']), $_POST['phone'], $_POST['email']); $contact->save(); return $app['twig']->render('created_contact.html.twig', array('newcontact' => $contact)); }); //view results of search page $app->get("/results", function () use($app) { $user_contact = strtolower($_GET['user_contact']); $contacts = $_SESSION['list_of_contacts']; $contacts_match = $_SESSION['matching_contacts']; foreach ($contacts as $contact) { if ($user_contact == strtolower($contact->getFirstName())) { array_push($contacts_match, $contact); } } return $app['twig']->render('matching_contacts.html.twig', array('matching_contacts' => $contacts_match)); }); //delete all contacts page $app->post("/delete_contacts", function () use($app) { Contact::deleteAll(); return $app['twig']->render('delete_contacts.html.twig'); }); return $app;