public function getCalls() { $sql = sprintf("SELECT * FROM %s.%s AS a RIGHT JOIN %s AS b ON (a.contact_id = b.id_contact)", DB_CTCRM, 'calls', 'contacts'); $calls = $this->handler->getAll($sql); $callDtoArray = array(); foreach ($calls as $call) { $contact = new ContactDto(); $contact->setId($call['contact_id']); $contact->setCompanyId($call['company_id']); $contact->setContactGroupId($call['contact_group_id']); $contact->setContactTitleId($call['contact_title_id']); $contact->setFirstName($call['first_name']); $contact->setLastName($call['last_name']); $contact->setEmail($call['email']); $contact->setInfo($call['info']); $callDto = new CallDto(); $callDto->setId($call['id']); $callDto->setContact($contact); $callDto->setDirection($call['direction']); $callDto->setNumberId($call['number_id']); $callDto->setState($call['state']); $callDto->setTimestamp($call['timestamp']); $callDto->setNote($call['note']); $callDtoArray[] = $callDto; } return json_encode($callDtoArray, JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT); }
private function createContactDto(array $contact, $numbersList) { $contactDto = new ContactDto(); $contactDto->setId($contact['id']); $contactDto->setContactTitleId($contact['contact_title_id']); $contactDto->setFirstName($contact['first_name']); $contactDto->setLastName($contact['last_name']); $contactDto->setEmail($contact['email']); $contactDto->setContactGroupId($contact['contact_group_id']); $contactDto->setCompanyId($contact['company_name']); $contactDto->setInfo($contact['info']); $contactDto->setNumberList($numbersList); return $contactDto; }
public function jsonSerialize() { return array('id' => $this->id, 'number_id' => $this->numberId, 'company_id' => $this->companyId, 'timestamp' => $this->timestamp, 'duration' => $this->duration, 'note' => $this->note, 'state' => $this->state, 'direction' => $this->direction, 'contact' => array('id' => $this->contact->getId(), 'company_id' => $this->contact->getCompanyId(), 'contact_group_id' => $this->contact->getContactGroupId(), 'contact_title_id' => $this->contact->getContactTitleId(), 'email' => $this->contact->getEmail(), 'first_name' => $this->contact->getFirstName(), 'info' => $this->contact->getInfo(), 'number_list' => $this->contact->getNumberList(), 'last_name' => $this->contact->getLastName())); }