public function render($tpl = null) { $app = JFactory::getApplication(); $document = JFactory::getDocument(); //event model $model = new EventModel(); $view = $app->input->get('view'); $layout = $this->getLayout(); switch ($layout) { case 'event_dock': break; case 'edit_event': case 'edit_task': break; case 'default': default: $event_id = $app->input->get('id'); if ($app->input->get('loc')) { $events = $model->getEvents($app->input->get('loc'), null, $app->input->get($app->input->get('loc') . '_id')); } else { $events = $model->getEvents(); } $state = $model->getState(); $this->event_statuses = EventHelper::getEventStatuses(); $this->event_types = EventHelper::getEventTypes(); $this->event_categories = EventHelper::getCategories(TRUE); $this->event_due_dates = EventHelper::getEventDueDates(); $this->event_associations = EventHelper::getEventAssociations(); $this->event_users = UsersHelper::getUsers(NULL, TRUE); $this->event_teams = UsersHelper::getTeams(); $this->dataTableColumns = $model->getDataTableColumns(); $document->addScriptDeclaration("\n loc = 'events';\n order_url = 'index.php?view=events&layout=list&format=raw&tmpl=component';\n order_dir = '" . $state->get('Event.' . $view . '_' . $layout . '_' . 'filter_order_Dir') . "';\n order_col = '" . $state->get('Event.' . $view . '_' . $layout . '_' . 'filter_order') . "';\n var dataTableColumns = " . json_encode($this->dataTableColumns) . ";"); $this->state = $state; break; } if ($layout != 'edit_task' || $layout != "edit_event") { if (TemplateHelper::isMobile()) { $model->set('current_events', true); $document->addScriptDeclaration('loc="events";'); } } if (TemplateHelper::isMobile() && isset($event_id)) { $person_model = new PeopleModel(); $person_model->set('event_id', $event_id); $person_model->set('recent', false); $person_model->set('_id', null); $this->people = $person_model->getPeople(); } $document->addScriptDeclaration('var layout="' . $layout . '"'); //assign results to view $this->events = $events; $this->member_role = UsersHelper::getRole(); $this->user_id = UsersHelper::getUserId(); $this->team_id = UsersHelper::getTeamId(); //display return parent::render(); }
public function execute() { //open model $model = new PeopleModel(); //retrieve all people $people = $model->getPeopleList(); //return results as json object echo json_encode($people); }
public function execute() { $person_name = $this->getInput()->getString('person_name'); $personModel = new PeopleModel(); $existingPerson = $personModel->checkPersonName($person_name); if ($existingPerson != "") { echo json_encode(array('success' => true, 'person_id' => $existingPerson, 'message' => "")); } else { echo json_encode(array('success' => true, 'message' => ucwords(TextHelper::_('COBALT_PERSON_WILL_BE_CREATED')))); } }
public function execute() { //set view $view = ViewHelper::getView('people', 'raw'); $view->setLayout('list'); //get deals $model = new PeopleModel(); $people = $model->getPeople(); //assign references $view->people = $people; //display echo $view->render(); }
public function execute() { //grab people $model = new PeopleModel(); $people = $model->getPeopleList(); //grab deals $model = new DealModel(); $deals = $model->getDealList(); //grab notes categories $model = new NoteModel(); $categories = $model->getNoteCategories(); //construct data obj $data = array('people' => $people, 'deals' => $deals, 'categories' => $categories); //encode and return results echo json_encode($data); }
public function execute() { //parameters $person_id = $this->getInput()->get("person_id"); $company_id = $this->getInput()->get('company_id'); //construct data $data = array('id' => $person_id, 'company_id' => $company_id); //load model and save $model = new PeopleModel(); if ($model->store($data)) { $success = true; } else { $success = false; } //return json echo json_encode(array('success' => $success)); }
public function render($tpl = null) { $app = JFactory::getApplication(); $deal_id = $app->input->get('deal_id'); $event_id = $app->input->get('event_id'); $companyId = $app->input->get('company_id'); $model = new PeopleModel(); $model->set('deal_id', $deal_id); $model->set('event_id', $event_id); $model->set('company_id', $companyId); $contacts = $model->getContacts(); $this->contacts = $contacts; if ($deal_id) { $primary_contact_id = DealHelper::getPrimaryContact($deal_id); $this->primary_contact_id = $primary_contact_id; } //display view echo parent::render(); }
public function render($tpl = null) { //get model and retrieve info $model = new EventModel(); if (TemplateHelper::isMobile()) { $model->set('current_events', true); } $events = $model->getEvents(); $eventDock = ViewHelper::getView('events', 'dashboard_event_dock', 'phtml', array('events' => $events)); $dealModel = new DealModel(); $dealModel->set('_view', 'dashboard'); $dealModel->set('recent', true); $dealModel->set('archived', 0); $recentDeals = $dealModel->getDeals(); $doc = JFactory::getDocument(); //get data for sales graphs $model = new GraphsModel(); $graph_data = $model->getGraphData(); $activityHelper = new ActivityHelper(); $activity = $activityHelper->getActivity(); //assign results to view $this->eventDock = $eventDock; $this->graph_data = $graph_data; $this->recentDeals = $recentDeals; $this->activity = $activity; $json = TRUE; $peopleModel = new PeopleModel(); if (TemplateHelper::isMobile()) { $dealModel->set('recent', false); $totalDeals = $dealModel->getTotal(); $peopleModel->set('type', 'leads'); $totalLeads = $peopleModel->getTotal(); $peopleModel->set('type', 'not_leads'); $totalContacts = $peopleModel->getTotal(); $companyModel = new CompanyModel(); $totalCompanies = $companyModel->getTotal(); $user = UsersHelper::getLoggedInUser(); $this->first_name = $user->first_name; $this->numEvents = count($events); $this->numDeals = $totalDeals; $this->numLeads = $totalLeads; $this->numContacts = $totalContacts; $this->numCompanies = $totalCompanies; } $peopleNames = $peopleModel->getPeopleNames($json); $doc->addScriptDeclaration("var people_names=" . $peopleNames . ";"); $dealModel = new DealModel(); $dealNames = $dealModel->getDealNames($json); $doc->addScriptDeclaration("var deal_names=" . $dealNames . ";"); /** get latest activities **/ $this->latest_activities = ViewHelper::getView('dashboard', 'latest_activities', 'phtml'); $this->latest_activities->activity = $activity; $activityHelper = new ActivityHelper(); $activity = $activityHelper->getActivity(); //display return parent::render(); }
public function execute() { //open model $model = new PeopleModel(); //retrieve all people $people = $model->getPeopleList(); if (count($people)) { foreach ($people as $index => $row) { $people[$index]['type'] = "person"; $people[$index]['association_link'] = RouteHelper::_('index.php?view=people&layout=person&id=' . $row['id']); } } //open model $model = new DealModel(); //retrieve all people $deals = $model->getDealList(); if (count($deals)) { foreach ($deals as $index => $row) { $deals[$index]['type'] = 'deal'; $deals[$index]['association_link'] = RouteHelper::_('index.php?view=deals&layout=deal&id=' . $row['id']); } } //open model $model = new CompanyModel(); //retrieve all people $companies = $model->getCompanyList(); if (count($companies)) { foreach ($companies as $index => $row) { $companies[$index]['type'] = 'company'; $companies[$index]['association_link'] = RouteHelper::_('index.php?view=companies&layout=company&id=' . $row['id']); } } //merge our results to a grand object $results = array_merge($people, $deals, $companies); //return results as json object echo json_encode($results); }
public function render() { $app = JFactory::getApplication(); $document = JFactory::getDocument(); $id = $app->input->get('id') ? $app->input->get('id') : null; $company_id = $app->input->get('company_id'); //retrieve people from model $model = new PeopleModel(); $model->set('company_id', $company_id); $layout = $this->getLayout(); $this->total = $model->getTotal(); $this->pagination = $model->getPagination(); //assign refs switch ($layout) { case "entry": $this->k = 0; $this->person = $model->getPerson(); break; case "add": case "edit": $this->person = $model->getPerson(); $this->edit_custom_fields_view = ViewHelper::getView('custom', 'edit', 'phtml', array('type' => 'people', 'item' => $this->person)); $companyModel = new CompanyModel(); $json = TRUE; $companyNames = $companyModel->getCompanyNames($json); $document->addScriptDeclaration("var company_names=" . $companyNames . ";"); break; case "people_dock_list": $people = $model->getPeople($id); $this->people = $people; break; default: $people = $model->getPeople($id); $this->people = $people; $this->state = $model->getState(); break; } //display view echo parent::render(); }
public function execute() { //get post data $data = $this->getInput()->getArray(array('association_id' => 'int', 'association_type' => 'string', 'person_id' => 'int')); //get db Object $db = $this->container->fetch('db'); $query = $db->getQuery(true); $table = $this->getInput()->getCmd('table'); $loc = $this->getInput()->getCmd('loc'); unset($data['table']); unset($data['loc']); if (empty($data['person_id'])) { unset($data['person_id']); } //write to tables if there is no association already in cf tables $query->select('* FROM #__' . $table . '_cf'); //loop to see if we have matches in database $overrides = array('tmpl'); foreach ($data as $key => $value) { if (!in_array($key, $overrides)) { $query->where($key . " = '" . $value . "'"); } } $db->setQuery($query); $results = $db->loadAssocList(); $response = new \stdClass(); //determine if we found any results if (count($results) == 0) { $query->insert('#__' . $table . '_cf'); //timestamp $data['created'] = date('Y-m-d H:i:s'); $date = DateHelper::formatDBDate(date('Y-m-d H:i:s')); //loop through data to get query string foreach ($data as $key => $value) { if (!in_array($key, $overrides)) { // determine key and key values $query->set($key . " = '" . $value . "'"); } } $db->setQuery($query)->execute(); //if return data requested if ($table == 'people') { //determine which page we want are wanting to send information back to if ($loc == 'deal') { $model = new PeopleModel(); $return = $model->getPerson($data['person_id']); $response->alert = new \stdClass(); $response->alert->message = \JText::_('DEAL_CONTACT_ADDED_SUCCESS'); $response->alert->type = 'success'; $response->item = $return; $response->reload = 2000; } if ($loc == 'person') { $model = new DealModel(); $return = $model->getDeals(array_key_exists('deal_id', $data) ? $data['deal_id'] : ""); $return = $return[0]; $response->alert = new \stdClass(); $response->alert->message = $return; $response->alert->type = 'success'; } } } else { $response->alert = new \stdClass(); $response->alert->message = \JText::_('DEAL_CONTACT_ERROR_FAILURE_ADD_PERSON'); $response->alert->type = 'error'; } //return json data echo json_encode($response); }
public function getCompanies($id = null, $type = null, $user = null, $team = null) { $app = \Cobalt\Container::fetch('app'); $this->_id = $id; $this->_type = $type; $this->_user = $user; $this->_team = $team; //get query string $query = $this->_buildQuery(); /** ------------------------------------------ * Set query limits and load results */ if (!TemplateHelper::isMobile()) { $limit = $this->getState($this->_view . '_limit'); $limitStart = $this->getState($this->_view . '_limitstart'); if (!$this->_id && $limit != 0) { if ($limitStart >= $this->getTotal()) { $limitStart = 0; $limit = 10; $limitStart = $limit != 0 ? floor($limitStart / $limit) * $limit : 0; $this->state->set($this->_view . '_limit', $limit); $this->state->set($this->_view . '_limitstart', $limitStart); } $query .= " LIMIT " . $limit . " OFFSET " . $limitStart; } } //run query and grab results of companies $companies = $this->db->setQuery($query)->loadAssocList(); //generate query to join people if (count($companies)) { $export = $app->input->get('export'); if (!$export) { foreach ($companies as $key => $company) { /* Tweets */ if ($company['twitter_user'] != "" && $company['twitter_user'] != " ") { $companies[$key]['tweets'] = TweetsHelper::getTweets($company['twitter_user']); } //generate people query $peopleModel = new People(); $peopleModel->set('company_id', $company['id']); $companies[$key]['people'] = $peopleModel->getContacts(); //generate deal query $dealModel = new Deal(); $dealModel->set('company_id', $company['id']); $deals = $dealModel->getDeals(); $companies[$key]['pipeline'] = 0; $companies[$key]['won_deals'] = 0; for ($i = 0; $i < count($deals); $i++) { $deal = $deals[$i]; $companies[$key]['pipeline'] += $deal->amount; if ($deal->percent == 100) { $companies[$key]['won_deals'] += $deal->amount; } } $companies[$key]['deals'] = $deals; //Get Associated Notes $notesModel = new Note(); $companies[$key]['notes'] = $notesModel->getNotes($company['id'], 'company'); // Get Associated Documents $documentModel = new Document(); $documentModel->set('company_id', $company['id']); $companies[$key]['documents'] = $documentModel->getDocuments(); $companies[$key]['address_formatted'] = strlen($company['address_1']) > 0 ? $company['address_1'] . $company['address_2'] . ", " . $company['address_city'] . ' ' . $company['address_state'] . ', ' . $company['address_zip'] . ' ' . $company['address_country'] : ""; } } } //$app->triggerEvent('onCompanyLoad',array(&$companies)); return $companies; }
/** * Read a CSV File * @param [String] $file * @return [Mixed] $data */ public function readCSVFile($file, $table = null) { $app = \Cobalt\Container::fetch('app'); ini_set("auto_detect_line_endings", "1"); $data = array(); $line = 1; $headers = array(); $i = -2; $db = JFactory::getDBO(); $table = $db->getTableColumns("#__" . $app->input->get('import_type', $table)); $special_headers = array('company_id', 'company_name', 'stage_name', 'source_name', 'status_name', 'primary_contact_name', 'assignee_name', 'type'); if (($handle = fopen($file, "r")) !== false) { while (($read = fgetcsv($handle, 1000, ",")) !== false) { $i++; $num = count($read); if ($line == 1) { $headers = $read; $data['headers'] = $headers; } else { $line_data = array(); for ($c = 0; $c < $num; $c++) { $header_name = array_key_exists($c, $headers) ? $headers[$c] : false; if ($header_name) { if (in_array($header_name, $special_headers)) { $read[$c] = utf8_encode($read[$c]); switch ($header_name) { case "company_id": $model = new Company(); $new_header = "company_id"; $company_name = $model->getCompanyName($read[$c]); $name = "name=\"import_id[" . $i . "][" . $new_header . "]\""; if ($company_name != "") { $name = $company_name; } else { $name = ""; } $special_data = array('label' => $read[$c], 'value' => $name); break; case "company_name": $model = new Company(); $new_header = "company_id"; $company_id = $model->getCompanyList($read[$c]); $name = "name=\"import_id[" . $i . "][" . $new_header . "]\""; if (count($company_id) > 0) { $name = $company_id[0]['name']; } else { $name = $read[$c]; } $special_data = array('label' => $read[$c], 'value' => utf8_encode($name)); break; case "stage_name": $new_header = "stage_id"; $stage_id = DealHelper::getStages($read[$c]); $name = "name=\"import_id[" . $i . "][" . $new_header . "]\""; if (count($stage_id)) { $keys = array_keys($stage_id); $stage_id = $keys[0]; } $special_data = array('dropdown' => DropdownHelper::generateDropdown('stage', $stage_id, $name)); break; case "source_name": $new_header = "source_id"; $source_id = DealHelper::getSources($read[$c]); $name = "name=\"import_id[" . $i . "][" . $new_header . "]\""; if (count($source_id)) { $keys = array_keys($source_id); $source_id = $keys[0]; } $special_data = array('dropdown' => DropdownHelper::generateDropdown('source', $source_id, $name)); break; case "status_name": $new_header = "status_id"; $status_id = DealHelper::getStatuses($read[$c]); $name = "name=\"import_id[" . $i . "][" . $new_header . "]\""; if (count($status_id)) { $keys = array_keys($status_id); $status_id = $keys[0]; } $special_data = array('dropdown' => DropdownHelper::generateDropdown('deal_status', $status_id, $name)); break; case "primary_contact_name": $new_header = "primary_contact_id"; $model = new People(); $contact = $model->searchForContact($read[$c]); if ($contact) { $special_data = array('label' => $contact[0]->label, 'value' => $contact[0]->value); } else { $special_data = array(); } break; case "assignee_name": $new_header = "assignee_id"; $model = new People(); $contact = $model->searchForContact($read[$c]); break; case "type": $new_header = "type"; $special_data = array('dropdown' => ucwords(DropdownHelper::getContactTypes($read[$c]))); break; } $line_data[$new_header] = $special_data; } else { if (array_key_exists($header_name, $table)) { $line_data[$header_name] = utf8_encode($read[$c]); } } } } if (count($line_data) > 0) { $data[] = $line_data; } } $line++; } fclose($handle); } return $data; }
public static function getPeopleList() { //open model $model = new PeopleModel(); //retrieve all people $people = $model->getPeopleList(); $people_list = array(); if (count($people)) { foreach ($people as $index => $row) { $people_list[$row['id']] = $row['first_name'] . ' ' . $row['last_name']; } } return $people_list; }
public function render() { $app = \Cobalt\Container::fetch('app'); //retrieve deal list from model $model = new DealModel(); $state = $model->getState(); $dealList = array(); $deal = array(); $doc = JFactory::getDocument(); //session info $session = JFactory::getSession(); $member_role = UsersHelper::getRole(); $user_id = UsersHelper::getUserId(); $team_id = UsersHelper::getTeamId(); //determine if we are requesting a specific deal or all deals //if id requested if ($app->input->get('id')) { $model->set('_id', $app->input->get('id')); $dealList = $model->getDeals(); if (is_null($dealList[0]->id)) { $app->redirect(RouteHelper::_('index.php?view=deals'), TextHelper::_('COBALT_NOT_AUTHORIZED')); } //display remove and assign primary contact to deal $app->input->set('loc', 'deal'); } else { //else load all deals if ($app->input->get('layout') != 'edit') { if (TemplateHelper::isMobile()) { $model->set('ordering', 'd.name ASC'); } $dealList = $model->getDeals(); } } //determine if we are editing an existing deal entry if (count($dealList) == 1) { //grab deal object $deal = $dealList[0]; $deal->header = ucwords(TextHelper::_('COBALT_DEAL_EDIT')); } else { //else we are creating a new entry $deal = new \stdClass(); $deal->name = ""; $deal->summary = ""; $deal->company_id = $app->input->get('company_id') ? $app->input->get('company_id') : null; $deal->person_id = $app->input->get('person_id') ? $app->input->get('person_id') : null; //get company name to prefill data and hidden fields if ($deal->company_id) { $company = CompanyHelper::getCompany($deal->company_id); $deal->company_name = $company[0]['name']; $deal->company_id = $company[0]['id']; } //if a person is specified prefill data if ($deal->person_id) { $person = PeopleHelper::getPerson($deal->person_id); $deal->person_name = $person[0]['last_name'] . ', ' . $person[0]['first_name']; $deal->person_id = $person[0]['id']; //assign company if person is associated with company if ($person[0]['company_id']) { $deal->company_id = $person[0]['company_id']; $deal->company_name = $person[0]['company_name']; } } //assign rest of null data $deal->amount = ""; $deal->stage_id = 0; $deal->source_id = 0; $deal->probability = 0; $deal->status_id = 0; $deal->expected_close = ""; $deal->header = ucwords(TextHelper::_('COBALT_DEAL_HEADER')); } //load javalibs if (!TemplateHelper::isMobile()) { $doc->addScript(JURI::base() . 'src/Cobalt/media/js/deal_manager.js'); } //dropdown info //get deal type filters $deal_types = DealHelper::getDealTypes(); $deal_type_name = $session->get('deal_type_filter'); $deal_type_name = array_key_exists($deal_type_name, $deal_types) ? $deal_types[$deal_type_name] : $deal_types['']; //get column filters $column_filters = DealHelper::getColumnFilters(); $selected_columns = DealHelper::getSelectedColumnFilters(); //get member access info $teams = UsersHelper::getTeams(); $users = UsersHelper::getUsers(); $stages = DealHelper::getStages(); //get deal stage filters $stage_name = $session->get('deal_stage_filter'); $stage_name = $stage_name ? $stages[$stage_name] : $stages['all']; //get session data to prefill filters $user_filter = $session->get('deal_user_filter'); $team_filter = $session->get('deal_team_filter'); if ($user_filter == "all" && $user_filter != $user_id) { $user_name = TextHelper::_('COBALT_ALL_USERS'); } elseif ($user_filter == "all") { $user_name = TextHelper::_('COBALT_ME'); } elseif ($user_filter and $user_filter != $user_id and $user_filter != 'all') { $user_info = UsersHelper::getUsers($user_filter); $user_info = $user_info[0]; $user_name = $user_info['first_name'] . " " . $user_info['last_name']; } elseif ($team_filter) { $team_info = UsersHelper::getTeams($team_filter); $team = $team_info[0]; $user_name = $team['team_name'] . TextHelper::_('COBALT_TEAM_APPEND'); } else { $user_name = TextHelper::_('COBALT_ME'); } //get closing time filters $closing_names = DealHelper::getClosing(); $closing_name = $session->get('deal_close_filter'); $closing_name = $closing_name ? $closing_names[$closing_name] : $closing_names['all']; //get total deals associated with user $total_deals = UsersHelper::getDealCount($user_id, $team_id, $member_role); //Load Events & Tasks for person $layout = $this->getLayout(); if ($layout == "deal") { $model = new EventModel(); $events = $model->getEvents("deal", null, $app->input->get('id')); $this->event_dock = ViewHelper::getView('events', 'event_dock', 'phtml', array('events' => $events)); $primary_contact_id = DealHelper::getPrimaryContact($dealList[0]->id); $this->contact_info = ViewHelper::getView('contacts', 'default', 'phtml', array('contacts' => $dealList[0]->people, 'primary_contact_id' => $primary_contact_id)); $this->document_list = ViewHelper::getView('documents', 'list', 'phtml', array('documents' => $deal->documents, 'total' => $total, 'pagination' => $pagination)); //$this->document_list = ViewHelper::getView('documents','document_row','phtml',array('documents'=>$deal->documents)); $this->custom_fields_view = ViewHelper::getView('custom', 'default', 'phtml', array('type' => 'deal', 'item' => $dealList[0])); } if ($layout == "default") { $this->dataTableColumns = $model->getDataTableColumns(); $pagination = $model->getPagination(); $total = $model->getTotal(); $this->deal_list = ViewHelper::getView('deals', 'list', 'phtml', array('dealList' => $dealList, 'total' => $total, 'pagination' => $pagination)); $this->state = $state; $doc->addScriptDeclaration("\n loc = 'deals';\n order_url = 'index.php?view=deals&layout=list&format=raw&tmpl=component';\n order_dir = '" . $state->get('Deal.filter_order_Dir') . "';\n order_col = '" . $state->get('Deal.filter_order') . "';\n var dataTableColumns = " . json_encode($this->dataTableColumns) . ";"); $deal_name = $state->get('Deal.deals_name'); $this->deal_filter = $deal_name; } if (TemplateHelper::isMobile()) { $this->add_note = ViewHelper::getView('note', 'edit', 'phtml'); $this->add_task = ViewHelper::getView('events', 'edit_task', 'phtml', array('association_type' => 'deal', 'assocation_id' => $app->input->get('id'))); } if ($layout == "edit") { $item = $app->input->get('id') && array_key_exists(0, $dealList) ? $dealList[0] : array('id' => ''); $this->edit_custom_fields_view = ViewHelper::getView('custom', 'edit', 'phtml', array('type' => 'deal', 'item' => $item)); $json = TRUE; $companyModel = new CompanyModel(); $companyNames = $companyModel->getCompanyNames($json); $doc->addScriptDeclaration("var company_names=" . $companyNames . ";"); $peopleModel = new PeopleModel(); $peopleNames = $peopleModel->getPeopleNames($json); $doc->addScriptDeclaration("var people_names=" . $peopleNames . ";"); } $closed_stages = DealHelper::getClosedStages(); //assign results to view $this->closed_stages = $closed_stages; $this->dealList = $dealList; $this->totalDeals = $total_deals; $this->deal = $deal; $this->deal_types = $deal_types; $this->deal_type_name = $deal_type_name; $this->user_id = $user_id; $this->member_role = $member_role; $this->teams = $teams; $this->users = $users; $this->stages = $stages; $this->stage_name = $stage_name; $this->user_name = $user_name; $this->closing_names = $closing_names; $this->closing_name = $closing_name; $this->state = $state; $this->column_filters = $column_filters; $this->selected_columns = $selected_columns; //display return parent::render(); }
/** * Add Cobalt People to Acymailing Lists */ public static function addMailingList($data) { $person_id = $data['person_id']; $listid = $data['listid']; $db = \Cobalt\Container::fetch('db'); $query = $db->getQuery(true); $peopleModel = new PeopleModel(); $person = $peopleModel->getPerson($person_id); $person = $person[0]; $time = time(); $query->select("subid")->from("#__acymailing_subscriber")->where("email='" . $person['email'] . "'"); $db->setQuery($query); $subid = $db->loadResult(); if ($subid) { $query->clear(); $query->update("#__acymailing_listsub")->set(array("subdate={$time}", "status=1"))->where("subid=" . $subid)->where("listid=" . $listid); $db->setQuery($query); $db->query(); } else { $query->insert("#__acymailing_subscriber")->columns("email,name,created,confirmed,enabled,accept,html")->values($db->Quote($person['email']) . ',' . $db->Quote($person['first_name'] . ' ' . $person['last_name']) . ',' . $time . ',' . '1,1,1,1'); $db->setQuery($query); $db->query(); $subid = $db->insertid(); $query->clear(); $query->insert("#__acymailing_listsub")->columns("listid,subid,subdate,status")->values($listid . ',' . $subid . ',' . $time . ',1'); $db->setQuery($query); $db->query(); } return true; }
public function render() { $app = JFactory::getApplication(); ///retrieve task list from model $model = new PeopleModel(); $state = $model->getState(); //session data $session = JFactory::getSession(); $user_id = UsersHelper::getUserId(); $team_id = UsersHelper::getTeamId(); $member_role = UsersHelper::getRole(); $people_type_name = $session->get('people_type_filter'); $user = $session->get('people_user_filter'); $team = $session->get('people_team_filter'); $stage = $session->get('people_stage_filter'); $tag = $session->get('people_tag_filter'); $status = $session->get('people_status_filter'); //load java $document = JFactory::getDocument(); $document->addScript(JURI::base() . 'src/Cobalt/media/js/people_manager.js'); //get list of people $people = $model->getPeople(); $person = array(); //Pagination $this->pagination = $model->getPagination(); //determine if we are editing an existing person entry if ($app->input->get('id')) { //grab deal object $person = $people[0]; if (is_null($person['id'])) { $app->redirect(RouteHelper::_('index.php?view=people'), TextHelper::_('COBALT_NOT_AUTHORIZED')); } $person['header'] = TextHelper::_('COBALT_EDIT') . ' ' . $person['first_name'] . ' ' . $person['last_name']; } else { //else we are creating a new entry $person = array(); $person['id'] = ''; $person['first_name'] = ""; $person['last_name'] = ""; $person['company_id'] = $app->input->get('company_id') ? $app->input->get('company_id') : null; $person['deal_id'] = $app->input->get('deal_id') ? $app->input->get('deal_id') : null; //get company name to prefill data on page and hidden fields if ($person['company_id']) { $company = CompanyHelper::getCompany($person['company_id']); $person['company_name'] = $company[0]['name']; $person['company_id'] = $company[0]['id']; } //get deal name to prefill data on page and hidden fields if ($person['deal_id']) { $deal = DealHelper::getDeal($person['deal_id']); $person['deal_name'] = $deal[0]['name']; $person['deal_id'] = $deal[0]['id']; } $person['position'] = ""; $person['phone'] = ""; $person['email'] = ""; $person['type'] = ''; $person['source_id'] = null; $person['status_id'] = null; $person['header'] = TextHelper::_('COBALT_PERSON_ADD'); } //get total people associated with users account $total_people = UsersHelper::getPeopleCount($user_id, $team_id, $member_role); //get filter types $people_types = PeopleHelper::getPeopleTypes(); $people_type_name = $people_type_name && array_key_exists($people_type_name, $people_types) ? $people_types[$people_type_name] : $people_types['all']; //get column filters $column_filters = PeopleHelper::getColumnFilters(); $selected_columns = PeopleHelper::getSelectedColumnFilters(); //get user filter //get associated users//teams $teams = UsersHelper::getTeams(); $users = UsersHelper::getUsers(); if ($user and $user != $user_id and $user != 'all') { $user_info = UsersHelper::getUsers($user); $user_info = $user_info[0]; $user_name = $user_info['first_name'] . " " . $user_info['last_name']; } elseif ($team) { $team_info = UsersHelper::getTeams($team); $team_info = $team_info[0]; $user_name = $team_info['team_name'] . TextHelper::_('COBALT_TEAM_APPEND'); } elseif ($user == 'all') { $user_name = TextHelper::_('COBALT_ALL_USERS'); } else { $user_name = TextHelper::_('COBALT_ME'); } //get stage filter $stages = PeopleHelper::getStages(); $stages_name = $stage ? $stages[$stage] : $stages['past_thirty']; //get tag filter $tag_list = PeopleHelper::getTagList(); for ($i = 0; $i < count($tag_list); $i++) { if ($tag_list[$i]['id'] == $tag and $tag != 'any') { $tag_name = $tag_list[$i]['name']; break; } } $tag_name = ($tag and $tag != 'any') ? $tag_name : 'all tags'; //get status filter $status_list = PeopleHelper::getStatusList(); for ($i = 0; $i < count($status_list); $i++) { if ($status_list[$i]['id'] == $status and $status != 'any') { $status_name = $status_list[$i]['name']; break; } } $status_name = ($status and $status != 'any') ? $status_name : 'any status'; $dropdowns = $model->getDropdowns(); //Load Events & Tasks for person $layout = $this->getLayout(); if ($layout == "person") { $model = new EventModel(); $events = $model->getEvents("person", null, $app->input->get('id')); $this->event_dock = ViewHelper::getView('events', 'event_dock', 'phtml', array('events' => $events)); $this->deal_dock = ViewHelper::getView('deals', 'deal_dock', 'phtml', array('deals' => $person['deals'])); $this->document_list = ViewHelper::getView('documents', 'document_row', 'phtml', array('documents' => $person['documents'])); $this->custom_fields_view = ViewHelper::getView('custom', 'default', 'phtml', array('type' => 'people', 'item' => $person)); } if ($layout == "default") { $total = $model->getTotal(); $pagination = $model->getPagination(); $this->people_list = ViewHelper::getView('people', 'list', 'phtml', array('people' => $people, 'total' => $total, 'pagination' => $pagination)); $this->people_filter = $state->get('Deal.people_name'); $this->dataTableColumns = $model->getDataTableColumns(); JFactory::getDocument()->addScriptDeclaration("\n var loc = 'people';\n var order_dir = '" . $state->get('People.filter_order_Dir') . "';\n var order_col = '" . $state->get('People.filter_order') . "';\n var dataTableColumns = " . json_encode($this->dataTableColumns) . ";"); } if ($layout == "edit") { $item = $app->input->get('id') && array_key_exists(0, $people) ? $people[0] : array('id' => ''); $this->edit_custom_fields_view = ViewHelper::getView('custom', 'edit', 'phtml', array('type' => 'people', 'item' => $item)); $companyModel = new CompanyModel(); $json = TRUE; $companyNames = $companyModel->getCompanyNames($json); $document->addScriptDeclaration("var company_names=" . $companyNames . ";"); } if (TemplateHelper::isMobile() && $app->input->get('id')) { $this->add_note = ViewHelper::getView('note', 'edit', 'phtml', array('add_note' => $add_note)); $this->add_task = ViewHelper::getView('events', 'edit_task', 'phtml', array('association_type' => 'person', 'assocation_id' => $app->input->get('id'))); } //assign results to view $this->people = $people; $this->person = $person; $this->totalPeople = $total_people; $this->people_type_name = $people_type_name; $this->people_types = $people_types; $this->user_id = $user_id; $this->team_id = $team_id; $this->member_role = $member_role; $this->user_name = $user_name; $this->teams = $teams; $this->users = $users; $this->stages = $stages; $this->stages_name = $stages_name; $this->tag_list = $tag_list; $this->tag_name = $tag_name; $this->status_list = $status_list; $this->status_name = $status_name; $this->state = $state; $this->column_filters = $column_filters; $this->selected_columns = $selected_columns; $this->dropdown = $dropdowns; //display return parent::render(); }
/** * Generate vcards for people * @return [type] [description] */ public function getVcard() { $app = \Cobalt\Container::fetch('app'); $person_id = $app->input->get('person_id'); $model = new People(); $person = $model->getPerson($person_id); $person = $person[0]; $str = ""; $str .= "BEGIN:VCARD\r\n"; $str .= "VERSION:4.0\r\n"; $str .= "N:" . $person['last_name'] . ";" . $person['first_name'] . ";;;\r\n"; $str .= "FN: " . $person['first_name'] . " " . $person['last_name'] . "\r\n"; $str .= "ORG:" . $person['company_name'] . "\r\n"; $str .= "TITLE:" . $person['position'] . "\r\n"; $str .= 'TEL;TYPE="work,voice";VALUE=uri:tel:+' . $person['phone'] . "\r\n"; $str .= 'TEL;TYPE="mobile,voice";VALUE=uri:tel:+' . $person['mobile_phone'] . "\r\n"; $str .= 'ADR;TYPE=work:;;' . $person['work_address_1'] . " " . $person['work_address_2'] . ';' . $person['work_city'] . ';' . $person['work_state'] . ';' . $person['work_zip'] . ';' . $person['work_country'] . "\r\n"; $str .= "EMAIL:" . $person['email'] . "\r\n"; $str .= "END:VCARD\r\n"; return $str; }
public function getDealDetails(&$deal) { $closed_stages = DealHelper::getClosedStages(); $deal->closed = in_array($deal->stage_id, $closed_stages) ? TRUE : FALSE; $deal_id = $deal->id; /** ------------------------------------------ * Join contacts */ $peopleModel = new People(); $peopleModel->set('deal_id', $deal_id); $people = $peopleModel->getContacts(); //assign results to company $deal->people = $people; /** ------------------------------------------ * Join conversations */ $convoModel = new Conversation(); $convoModel->set('deal_id', $deal_id); $conversations = $convoModel->getConversations(); $deal->conversations = $conversations; /** ------------------------------------------ * Join notes */ $notesModel = new Note(); $deal->notes = $notesModel->getNotes($deal_id, 'deal'); /** ------------------------------------------ * Join documents */ $docModel = new Document(); $docModel->set('deal_id', $deal_id); $deal->documents = $docModel->getDocuments(); /** ------------------------------------------ * Join tasks & events */ $eventModel = new Event(); $eventModel->set('deal_id', $deal_id); $events = $eventModel->getEvents(); $deal->events = $events; }
/** * Method to store a record * * @return boolean True on success */ public function store($data = null) { $app = \Cobalt\Container::fetch('app'); //Load Tables $row = new NoteTable(); $oldRow = new NoteTable(); if ($data == null) { $data = $app->input->getArray(array('note' => 'string', 'deal_id' => 'int', 'person_id' => 'int', 'name' => 'string', 'category_id' => 'int', 'company_id' => 'int', 'note_id' => 'int', 'event_id' => 'int')); } if (array_key_exists('note_id', $data)) { $data['id'] = $data['note_id']; } if (array_key_exists('is_email', $data)) { $model = new Mail(); $email = $model->getEmail($data['email_id']); $data['note'] = $email; } /** check for and automatically associate and create primary contacts or people **/ if (array_key_exists('person_name', $data) && $data['person_name'] != "") { $peopleModel = new People(); $existingPerson = $peopleModel->checkPersonName($data['person_name']); if ($existingPerson == "") { $pdata = array(); $name = explode(" ", $data['person_name']); $pdata['first_name'] = array_key_exists(0, $name) ? $name[0] : ""; $pdata['last_name'] = array_key_exists(1, $name) ? $name[1] : ""; $data['person_id'] = $peopleModel->store($pdata); } else { $data['person_id'] = $existingPerson; } } /** check for and automatically associate and create deals **/ if (array_key_exists('deal_name', $data) && $data['deal_name'] != "" && (!array_key_exists('deal_id', $data) || empty($data['deal_id']) || $data['deal_id'] == 0)) { $dealModel = new Deal(); $existingDeal = $dealModel->checkDealName($data['deal_name']); if ($existingDeal == "") { $pdata = array(); $pdata['name'] = $data['deal_name']; $data['deal_id'] = $dealModel->store($pdata); } else { $data['deal_id'] = $existingDeal; } } //date generation $date = DateHelper::formatDBDate(date('Y-m-d H:i:s')); if (!array_key_exists('id', $data)) { $data['created'] = $date; $status = "created"; } else { $row->load($data['id']); $oldRow->load($data['id']); $status = "updated"; } $data['modified'] = $date; $data['owner_id'] = UsersHelper::getUserId(); // Bind the form fields to the table if (!$row->bind($data)) { $this->setError($this->db->getErrorMsg()); return false; } //$app->triggerEvent('onBeforeNoteSave', array(&$row)); // Make sure the record is valid if (!$row->check()) { $this->setError($this->db->getErrorMsg()); return false; } // Store the web link table to the database if (!$row->store()) { $this->setError($this->db->getErrorMsg()); return false; } if (array_key_exists('id', $data) && intval($data['id'])) { $id = $data['id']; } else { $id = $this->db->insertId(); } ActivityHelper::saveActivity($oldRow, $row, 'note', $status); //Store email attachments if (array_key_exists('is_email', $data)) { $model = new CobaltModelMail(); $model->storeAttachments($data['email_id'], $data['person_id']); } //$app->triggerEvent('onAfterNoteSave', array(&$row)); return $id; }