/**
* Associate fields between database and csv file
*/
public function csvAction()
{
$this->view->breadcrumb = Snep_Breadcrumb::renderPath(array($this->view->translate("Manage"), $this->view->translate("Contacts"), $this->view->translate("Import CSV"), $this->view->translate("Column Association")));
$adapter = new Zend_File_Transfer_Adapter_Http();
$this->view->url = $this->getFrontController()->getBaseUrl() . '/' . $this->getRequest()->getControllerName();
if (!$adapter->isValid()) {
$this->view->invalid = true;
} else {
$this->view->invalid = false;
$adapter->receive();
$fileName = $adapter->getFileName();
$handle = fopen($fileName, "r");
$csv = array();
$row_number = 2;
$first_row = explode(",", str_replace("\n", "", fgets($handle, 4096)));
$column_count = count($first_row);
$csv[] = $first_row;
while (!feof($handle)) {
$line = fgets($handle, 4096);
if (strpos($line, ",")) {
$row = explode(",", $line);
if (count($row) != $column_count) {
throw new ErrorException($this->view->translate("Invalid column count on line %d", $row_number));
}
$csv[] = $row;
$row_number++;
}
}
fclose($handle);
$standard_fields = array("discard" => $this->view->translate("Discard"), "ds_name" => $this->view->translate("Name"), "ds_address" => $this->view->translate("Address"), "ds_city" => $this->view->translate("City"), "ds_state" => $this->view->translate("State"), "ds_cep" => $this->view->translate("Zip Code"), "ds_phone" => $this->view->translate("Phone"), "ds_cell_phone" => $this->view->translate("Cellphone"));
$session = new Zend_Session_Namespace('csv');
$session->data = $csv;
$group = new Snep_ContactGroups_Manager();
$_allGroups = $group->fetchAll();
foreach ($_allGroups as $group) {
$allGroups[$group['id_contact_group']] = $group['ds_name'];
}
if (!count($_allGroups) > 0) {
$this->view->error = $this->view->translate('There is no contacts group registered.');
}
$this->view->csvprocess = array_slice($csv, 0, 10);
$this->view->fields = $standard_fields;
isset($allGroups) ? $this->view->group = $allGroups : ($this->view->group = false);
}
}
/**
* Migrate contacts to other Contact Group
*/
public function migrationAction()
{
$this->view->breadcrumb = Snep_Breadcrumb::renderPath(array($this->view->translate("Manage"), $this->view->translate("Contact Group"), $this->view->translate("Migrate Contacts")));
$id = $this->_request->getParam('id');
$groupAll = new Snep_ContactGroups_Manager();
$_allGroups = $groupAll->fetchAll();
foreach ($_allGroups as $group) {
if ($group['id_contact_group'] != $id) {
$allGroups[$group['id_contact_group']] = $group['ds_name'];
}
}
Zend_Registry::set('cancel_url', $this->getFrontController()->getBaseUrl() . '/' . $this->getRequest()->getControllerName() . '/index');
$form = new Snep_Form(new Zend_Config_Xml("modules/default/forms/contact_groups_migration.xml"));
$form->setAction($this->getFrontController()->getBaseUrl() . '/contact-groups/migration/stage/2');
if (isset($allGroups)) {
$form->getElement('group')->setMultiOptions($allGroups);
$form->getElement('option')->setMultiOptions(array('migrate' => 'migrate contacts to group', 'remove' => 'remove all'))->setValue('migrate');
} else {
$form->removeElement('group');
$form->getElement('option')->setMultiOptions(array('remove' => 'remove all'));
}
$this->view->message = $this->view->translate("The excluded group has associated contacts.");
$form->getElement('id')->setValue($id);
$stage = $this->_request->getParam('stage');
if (isset($stage['stage']) && $id) {
if ($_POST['option'] == 'migrate') {
$obj = new Snep_Contacts_Manager();
$select = $obj->select()->where('id_contact_group = ?', $id);
$contacts = $obj->fetchAll($select)->toarray();
$idGroup = $_POST['group'];
$dadosUpdate = array('id_contact_group' => $idGroup);
foreach ($contacts as $contactselect) {
$idContact = $contactselect['id_contact'];
$obj->update($dadosUpdate, "id_contact = {$idContact}");
}
$groupAll->delete("id_contact_group ={$id}");
} elseif ($_POST['option'] == 'remove') {
$obj = new Snep_Contacts_Manager();
$select = $obj->select()->where('id_contact_group = ?', $id);
$contacts = $obj->fetchAll($select)->toArray();
foreach ($contacts as $contact) {
$idContact = $contact['id_contact'];
$obj->delete("id_contact = {$idContact}");
}
$groupAll->delete("id_contact_group ={$id}");
}
$this->_redirect($this->getRequest()->getControllerName());
}
$this->view->form = $form;
}
