function reportListadodebases($smarty, $module_name, $local_templates_dir, &$pDB, $arrConf)
{
$pListadodebases = new paloSantoClientesManuales($pDB);
$filter_field = getParameter("filter_field");
$filter_value = getParameter("filter_value");
//begin grid parameters
$oGrid = new paloSantoGrid($smarty);
$oGrid->setTitle(_tr("Clientes manuales"));
$oGrid->pagingShow(true);
// show paging section.
$oGrid->enableExport();
// enable export.
$oGrid->setNameFile_Export(_tr("Clientes manuales"));
$url = array("menu" => $module_name, "filter_field" => $filter_field, "filter_value" => $filter_value);
$oGrid->setURL($url);
$arrColumns = array(_tr("CI"), _tr("Nombre"), _tr("Apellido"), _tr("Provincia"), _tr("Ciudad"), _tr("Nacimiento"), _tr("Correo personal"), _tr("Correo trabajo"), _tr("Estado civil"), _tr("Origen"), _tr("Acción"));
$oGrid->setColumns($arrColumns);
$total = $pListadodebases->getNumListadodebases($filter_field, $filter_value);
$arrData = null;
if ($oGrid->isExportAction()) {
$limit = $total;
// max number of rows.
$offset = 0;
// since the start.
} else {
//$limit = 20;
$limit = 200;
$oGrid->setLimit($limit);
$oGrid->setTotal($total);
$offset = $oGrid->calculateOffset();
}
$arrResult = $pListadodebases->getListadodebases($limit, $offset, $filter_field, $filter_value);
if (is_array($arrResult) && $total > 0) {
foreach ($arrResult as $key => $value) {
$arrTmp[0] = $value['ci'];
$arrTmp[1] = $value['nombre'];
$arrTmp[2] = $value['apellido'];
$arrTmp[3] = $value['provincia'];
$arrTmp[4] = $value['ciudad'];
$arrTmp[5] = $value['nacimiento'];
$arrTmp[6] = $value['correo_personal'];
$arrTmp[7] = $value['correo_trabajo'];
$arrTmp[8] = $value['estado_civil'];
$arrTmp[9] = $value['origen'];
$arrTmp[10] = "<a href=index.php?menu={$module_name}&action=agregar&ci={$value['ci']}>Agregar a campaña</a><br><a href='?menu=hispana_clientes_datosbasicos&ci=" . $value['ci'] . "'>Editar</a>";
$arrData[] = $arrTmp;
}
}
$oGrid->setData($arrData);
//begin section filter
$oFilterForm = new paloForm($smarty, createFieldFilter());
$smarty->assign("SHOW", _tr("Show"));
$htmlFilter = $oFilterForm->fetchForm("{$local_templates_dir}/filter.tpl", "", $_POST);
//end section filter
$oGrid->showFilter(trim($htmlFilter));
$content = $oGrid->fetchGrid();
//end grid parameters
return $content;
}
<?php
include_once "/var/www/html/libs/paloSantoDB.class.php";
include_once "/var/www/html/modules/hispana_clientes_manuales/configs/default.conf.php";
include_once "/var/www/html/modules/hispana_clientes_manuales/libs/paloSantoClientesManuales.class.php";
/* Just for test
$_POST['action'] = 'mostrarAgentes';
$_POST['clase'] = 1;*/
if (isset($_POST['action'])) {
$pDB = new paloDB($arrConfModule['dsn_conn_database']);
$pClientes = new paloSantoClientesManuales($pDB);
switch ($_POST['action']) {
case 'mostrarAgentes':
if (!isset($_POST['clase']) || empty($_POST['clase'])) {
$content = "<option value=0>Seleccione una campaña</option>";
break;
}
$arrOptions = $pClientes->getAgentesCampania($_POST['clase']);
if (sizeof($arrOptions) > 0) {
$content = crearOption($arrOptions);
} else {
$content = "";
}
break;
default:
$content = 'vacio';
break;
}
echo $content;
return $content;
}
