function reportContact($smarty, $module_name, $local_templates_dir, &$pDB, $arrConf)
{
global $arrCredentials;
$coreContact = new coreContact($pDB);
$jsonObject = new PaloSantoJSON();
//obtener los parametros del filtro
$filters['ftype_contacto'] = getParameter('ftype_contacto');
$filters['filter'] = getParameter('filter');
$filters['filter_value'] = getParameter('filter_value');
$validatedfilters = $coreContact->validatedFilters($filters);
$total = $coreContact->getTotalContactsByFilter($validatedfilters);
if ($total === false) {
$total = 0;
$smarty->assign("MSG_ERROR_FIELD", _tr("Error en database"));
$jsonObject->set_error($coreContact->sqlContact->getErrorMsg());
return $jsonObject->createJSON();
}
$limit = 7;
$oGrid = new paloSantoGrid($smarty);
$oGrid->setLimit($limit);
$oGrid->setTotal($total);
$offset = $oGrid->calculateOffset();
$end = $offset + $limit <= $total ? $offset + $limit : $total;
$oGrid->setStart($total == 0 ? 0 : $offset + 1);
$oGrid->setEnd($end);
$currentPage = $oGrid->calculateCurrentPage();
$numPage = $oGrid->calculateNumPage();
$url['menu'] = $module_name;
$url['ftype_contacto'] = $filters['ftype_contacto'];
$url['filter'] = $filters['filter'];
$url['filter_value'] = $filters['filter_value'];
$oGrid->setTitle(_tr('Contacts List'));
$oGrid->setURL($url);
$oGrid->enableExport();
// enable export.
$oGrid->setNameFile_Export(_tr("ContactsExport"));
$arrColumn = array();
if ($oGrid->isExportAction()) {
// arreglo de columnas para mostrar en los archivos de exportacion
$arrColumn[] = 'Name';
//if($validatedfilters['table']=="internal"){
if ($validatedfilters['table'] == "internal") {
$arrColumn[] = 'Ext';
} else {
$arrColumn[] = 'Phone';
}
$arrColumn[] = 'Email';
$arrColumn[] = 'Type Contact';
} else {
//arreglo de columnas para mostrar en la grilla
$arrColumn[] = "<span class='glyphicon glyphicon-check'></span>";
$arrColumn[] = _tr('Picture');
$arrColumn[] = _tr('Name');
//if($validatedfilters['table']=="internal"){
$arrColumn[] = _tr('Ext / Phone');
$arrColumn[] = _tr('Email');
$arrColumn[] = _tr('Call');
$arrColumn[] = _tr('Transfer');
$arrColumn[] = _tr('Type Contact');
}
$oGrid->setColumns($arrColumn);
$validatedfilters = $coreContact->validatedFilters($filters);
//enviamos como parametros limit, offset y los filtros validados
$contacts = $coreContact->getContacts($limit, $offset, $validatedfilters);
$arrDatosGrid = array();
if ($contacts === false) {
$smarty->assign("MSG_ERROR_FIELD", $coreContact->getErrorMsg());
$jsonObject->set_error($coreContact->getErrorMsg());
return $jsonObject->createJSON();
} else {
if ($oGrid->isExportAction()) {
// data para exportar en los archivos
foreach ($contacts as $value) {
$tmp = array();
$tmp[] = $value['name'];
if (empty($value['work_phone'])) {
$tmp[] = "N/A";
} else {
$tmp[] = $value['work_phone'];
}
if (!empty($value['username'])) {
$tmp[] = $value['username'];
} else {
$tmp[] = "N/A";
}
if ($validatedfilters['table'] != "internal") {
if ($value['status'] == "isPrivate") {
$tmp[] = _tr('Private');
} else {
$tmp[] = _tr('Public');
}
} else {
$tmp[] = _tr('Public');
}
$arrDatosGrid[] = $tmp;
}
} else {
//data para mostrar en las grillas
foreach ($contacts as $value) {
$tmp = array();
if ($validatedfilters['table'] == "internal") {
$tmp[] = "<input type='checkbox' name='checkContacts' id='{$value['id']}' disabled >";
} else {
if ($arrCredentials['idUser'] == $value['iduser']) {
$tmp[] = "<input type='checkbox' name='checkContacts' id='{$value['id']}'>";
} else {
$tmp[] = "<input type='checkbox' name='checkContacts' id='{$value['id']}' disabled >";
}
}
if ($validatedfilters['table'] == "internal") {
$tmp[] = "<img id='img-users' width='16' height='16' alt='image' src='index.php?menu=_elastixutils&action=getImage&ID={$value['id']}&rawmode=yes'/>";
} else {
$tmp[] = "<img id='img-users' width='16' height='16' alt='image' src='index.php?menu={$module_name}&action=getImageExtContact&image={$value['picture']}&rawmode=yes'/>";
}
if ($validatedfilters['table'] == "internal") {
$tmp[] = htmlentities($value['name'], ENT_QUOTES, "UTF-8");
} else {
if ($arrCredentials['idUser'] == $value['iduser']) {
$tmp[] = "<a href='#' onclick='editContact({$value['id']})'>" . htmlentities($value['name'], ENT_QUOTES, "UTF-8") . "</a>";
} else {
$tmp[] = htmlentities($value['name'], ENT_QUOTES, "UTF-8");
}
}
if ($validatedfilters['table'] == "internal") {
$tmp[] = htmlentities($value['extension'], ENT_QUOTES, "UTF-8");
} else {
if (empty($value['work_phone'])) {
$tmp[] = "N/A";
} else {
$tmp[] = htmlentities($value['work_phone'], ENT_QUOTES, "UTF-8");
}
}
if (!empty($value['username'])) {
$tmp[] = htmlentities($value['username'], ENT_QUOTES, "UTF-8");
} else {
$tmp[] = "N/A";
}
//$tmp[]="<span class='glyphicon glyphicon-earphone'></span>";
$tmp[] = "<a href='#' onclick='callContact({$value['id']})'><span class='glyphicon glyphicon-earphone'></span></a>";
if ($validatedfilters['table'] == "internal") {
//$tmp[]=_tr('Transfer');
$tmp[] = "<a href='#' onclick='transferCall({$value['id']})'>" . _tr('Transfer') . "</a>";
} else {
$tmp[] = "N/A";
}
if ($validatedfilters['table'] != "internal") {
if ($value['status'] == "isPrivate") {
$tmp[] = _tr('Private');
} else {
$tmp[] = _tr('Public');
}
} else {
$tmp[] = _tr('Public');
}
$arrDatosGrid[] = $tmp;
}
}
}
$action = getParameter('action');
if ($action == 'search') {
$arrData['url'] = $oGrid->getURL();
$arrData['url'] = str_replace('&', '&', $arrData['url']);
$arrData['numPage'] = $numPage;
$arrData['currentPage'] = $currentPage;
$arrData['content'] = $arrDatosGrid;
$jsonObject->set_message($arrData);
return $jsonObject->createJSON();
}
$oGrid->addButtonAction("new_contact", "<span class='glyphicon glyphicon-user'></span> New Contact", "", "newContact()");
$oGrid->addButtonAction("remove_contact", "<span class='glyphicon glyphicon-remove'></span> Delete Contacts", "", "deleteContacts('" . _tr("Are you sure you wish to delete the contact.") . "')");
$oGrid->addButtonAction("elx_upload_file", "<span class='glyphicon glyphicon-upload'></span> Upload from CSV", "", "");
$oGrid->addButtonAction("elx_export_data", "<span class='glyphicon glyphicon-download'></span>", "", "");
$oGrid->addButtonAction("elx_show_filter", "<span class='glyphicon glyphicon-filter'></span> Show filter", "", "");
$arrayData = array();
$arrFormFilter = createFilterForm();
$oFilterForm = new paloForm($smarty, $arrFormFilter);
$htmlFilter = $oFilterForm->fetchForm("{$local_templates_dir}/filter.tpl", _tr('extension'), $arrayData);
$oGrid->showFilter(trim($htmlFilter));
$contenidoModulo = actionsReport($arrDatosGrid, $oGrid);
return $contenidoModulo;
}
