function createFieldForm($pDB) { $pCrearCampaign = new paloSantoCrearcampaña($pDB); /* $arrTmp = $pCrearCampaign->getForms(); if(count($arrTmp)>0){ foreach($arrTmp as $form){ $arrFormOptions[$form['id']] = $form['nombre']; } }else{ return "No existen formularios."; } */ /* if(getParameter("action")!="view_edit"){ $arrTmp = $pCrearCampaign->getBases(); if(count($arrTmp)>0){ foreach($arrTmp as $base){ $arrBaseOptions[$base['id']] = $base['nombre']; } }else{ return "No existen bases de clientes."; } $pDB = new paloDB("sqlite3:////var/www/db/acl.db"); // me cambio temporalmente a Sqlite $pCrearCampaign = new paloSantoCrearcampaña($pDB); $arrTmp = $pCrearCampaign->getUsuarios("Agente"); // pido los usuarios del rol Agente if(count($arrTmp)>0){ foreach($arrTmp as $base){ $arrAgentesNoElegidos[$base['name']] = $base['description'] . " - Ext: " . $base['extension']; } }else{ return "No existen agentes."; } }else */ if (getParameter("action") == "view_edit") { // Bases $arrTmp = $pCrearCampaign->getBasesCampania(getParameter('id')); if (count($arrTmp) > 0) { foreach ($arrTmp as $base) { $arrBasesElegidas[$base['id']] = $base['nombre']; } } if (sizeof($arrBasesElegidas) > 0) { $arrTmp = $pCrearCampaign->getOtrasBases($arrBasesElegidas); } else { $arrTmp = $pCrearCampaign->getBases(); } if (count($arrTmp) > 0) { foreach ($arrTmp as $base) { $arrBaseOptions[$base['id']] = $base['nombre']; } } //Calltypes $arrTmp = $pCrearCampaign->getCalltypes(getParameter('id'), getParameter('clase_calltype')); if (count($arrTmp) > 0) { foreach ($arrTmp as $calltype) { $arrCalltypes[$calltype['id']] = $calltype['descripcion']; } } else { return "No existen calltypes."; } // Agentes $arrTmp = $pCrearCampaign->getAgentesCampania(getParameter('id')); if (count($arrTmp) > 0) { foreach ($arrTmp as $agente) { $arrAgentesElegidos[$agente['id_agente']] = $agente['id_agente']; } } $pDB = new paloDB("sqlite3:////var/www/db/acl.db"); // me cambio temporalmente a Sqlite $pCrearCampaign = new paloSantoCrearcampaña($pDB); $arrTmp = $pCrearCampaign->getUsuariosElegidos("Agente", $arrAgentesElegidos); // pido los usuarios del rol Agente que estén en arreglo $rrAgentesElegidos unset($arrAgentesElegidos); if (count($arrTmp) > 0) { foreach ($arrTmp as $agente) { $arrAgentesElegidos[$agente['name']] = $agente['description'] . " - Ext: " . $agente['extension']; } } if (sizeof($arrAgentesElegidos) > 0) { $arrTmp = $pCrearCampaign->getUsuariosElegidos("Agente", $arrAgentesElegidos, "not"); // pido los usuarios del rol Agente que estén en arreglo $rrAgentesElegidos } else { $arrTmp = $pCrearCampaign->getUsuarios("Agente"); } if (count($arrTmp) > 0) { foreach ($arrTmp as $agente) { $arrAgentesNoElegidos[$agente['name']] = $agente['description'] . " - Ext: " . $agente['extension']; } } } // por default $arrSelect está vacío, debe tener algo cuando la campaña está siendo editada $arrSelected = array(); $arrFields = array("nombre" => array("LABEL" => _tr("Nombre"), "REQUIRED" => "yes", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => "", "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "base" => array("LABEL" => _tr("Base"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrBaseOptions, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "10"), "bases_elegidas" => array("LABEL" => _tr("Base"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrBasesElegidas, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "10"), "agente" => array("LABEL" => _tr("Agente"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrAgentesNoElegidos, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "5"), "agentes_elegidos" => array("LABEL" => _tr("Agente"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrAgentesElegidos, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "5"), "calltypes" => array("LABEL" => _tr("Call types"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrCalltypes, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "5"), "calltypes_elegidos" => array("LABEL" => _tr("Call types"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrSelected, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "5")); return $arrFields; }
function createFieldForm($pDB) { $pCrearCampaign = new paloSantoCrearcampaña($pDB); $arrTmp = $pCrearCampaign->getForms(); if (count($arrTmp) > 0) { foreach ($arrTmp as $form) { $arrFormOptions[$form['id']] = $form['nombre']; } } else { return "No existen formularios."; } if ($_GET['action'] != "view_edit") { $arrTmp = $pCrearCampaign->getBases(); if (count($arrTmp) > 0) { foreach ($arrTmp as $base) { $arrBaseOptions[$base['id']] = $base['nombre']; } } else { return "No existen bases de clientes."; } $pDB = new paloDB("sqlite3:////var/www/db/acl.db"); // me cambio temporalmente a Sqlite $pCrearCampaign = new paloSantoCrearcampaña($pDB); $arrTmp = $pCrearCampaign->getUsuarios("Agente"); // pido los usuarios del rol Agente if (count($arrTmp) > 0) { foreach ($arrTmp as $base) { $arrAgentesNoElegidos[$base['name']] = $base['description'] . " - Ext: " . $base['extension']; } } else { return "No existen agentes."; } } elseif ($_GET['action'] == "view_edit") { // Bases $arrTmp = $pCrearCampaign->getBasesCampania($_GET['id']); if (count($arrTmp) > 0) { foreach ($arrTmp as $base) { $arrBasesElegidas[$base['id']] = $base['nombre']; } } if (sizeof($arrBasesElegidas) > 0) { $arrTmp = $pCrearCampaign->getOtrasBases($arrBasesElegidas); } else { $arrTmp = $pCrearCampaign->getBases(); } if (count($arrTmp) > 0) { foreach ($arrTmp as $base) { $arrBaseOptions[$base['id']] = $base['nombre']; } } // Agentes $arrTmp = $pCrearCampaign->getAgentesCampania($_GET['id']); if (count($arrTmp) > 0) { foreach ($arrTmp as $agente) { $arrAgentesElegidos[$agente['id_agente']] = $agente['id_agente']; } } $pDB = new paloDB("sqlite3:////var/www/db/acl.db"); // me cambio temporalmente a Sqlite $pCrearCampaign = new paloSantoCrearcampaña($pDB); $arrTmp = $pCrearCampaign->getUsuariosElegidos("Agente", $arrAgentesElegidos); // pido los usuarios del rol Agente que estén en arreglo $rrAgentesElegidos unset($arrAgentesElegidos); if (count($arrTmp) > 0) { foreach ($arrTmp as $agente) { $arrAgentesElegidos[$agente['name']] = $agente['description'] . " - Ext: " . $agente['extension']; } } if (sizeof($arrAgentesElegidos) > 0) { $arrTmp = $pCrearCampaign->getUsuariosElegidos("Agente", $arrAgentesElegidos, "not"); // pido los usuarios del rol Agente que estén en arreglo $rrAgentesElegidos } else { $arrTmp = $pCrearCampaign->getUsuarios("Agente"); } if (count($arrTmp) > 0) { foreach ($arrTmp as $agente) { $arrAgentesNoElegidos[$agente['name']] = $agente['description'] . " - Ext: " . $agente['extension']; } } } // por default $arrSelect está vacío, debe tener algo cuando la campaña está siendo editada $arrSelected = array(); $arrFields = array("nombre" => array("LABEL" => _tr("Nombre"), "REQUIRED" => "yes", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => "", "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "id_form" => array("LABEL" => _tr("Form"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrFormOptions, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si"), "base" => array("LABEL" => _tr("Base"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrBaseOptions, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "10"), "bases_elegidas" => array("LABEL" => _tr("Base"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrBasesElegidas, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "10"), "agente" => array("LABEL" => _tr("Agente"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrAgentesNoElegidos, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "5"), "agentes_elegidos" => array("LABEL" => _tr("Agente"), "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrAgentesElegidos, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "", "EDITABLE" => "si", "MULTIPLE" => true, "SIZE" => "5"), "fecha_inicio" => array("LABEL" => _tr("Fecha Inicio"), "REQUIRED" => "yes", "INPUT_TYPE" => "DATE", "INPUT_EXTRA_PARAM" => array("TIME" => false, "FORMAT" => "%Y-%m-%d"), "VALIDATION_TYPE" => 'text'), "fecha_fin" => array("LABEL" => _tr("Fecha Fin"), "REQUIRED" => "no", "REQUIRED" => "yes", "INPUT_TYPE" => "DATE", "INPUT_EXTRA_PARAM" => array("TIME" => false, "FORMAT" => "%Y-%m-%d"), "VALIDATION_TYPE" => 'text'), "script" => array("LABEL" => _tr("Script"), "REQUIRED" => "no", "INPUT_TYPE" => "TEXTAREA", "INPUT_EXTRA_PARAM" => "", "VALIDATION_TYPE" => "text", "EDITABLE" => "si", "COLS" => "50", "ROWS" => "20", "VALIDATION_EXTRA_PARAM" => "")); return $arrFields; }