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; }