/** * @param form_persistentdocument_form $document * @return void */ protected function preDelete($document) { parent::preDelete($document); if ($document->getResponseCount()) { $responses = $this->pp->createQuery('modules_form/response')->add(Restrictions::eq('parentForm.id', $document->getId()))->find(); foreach ($responses as $response) { $response->delete(); } } }
/** * @param form_persistentdocument_form $form * @return Integer */ public function fileForForm($form) { $count = 0; $responses = $this->createQuery()->add(Restrictions::eq('parentForm.id', $form->getId()))->add(Restrictions::published())->find(); foreach ($responses as $response) { $this->file($response->getId()); $count++; } return $count; }
public function _execute($context, $request) { $form = $request->getAttribute('form'); $this->setAttribute('form', $form); $domDoc = new DOMDocument(); $fieldNames = array('creationdate' => f_Locale::translate('&modules.form.bo.actions.SendDate;')); $query = f_persistentdocument_PersistentProvider::getInstance()->createQuery('modules_form/response')->add(Restrictions::eq('parentForm.id', $form->getId()))->addOrder(Order::desc('document_creationdate')); if ($request->getAttribute('all') != 'all') { $query->add(Restrictions::published()); } $responses = $query->find(); $responsesAttribute = array(); foreach ($responses as $response) { $domDoc->loadXML($response->getContents()); $xpath = new DOMXPath($domDoc); $fieldList = $xpath->query('/response/field'); $fields = array('creationdate' => $response->getUICreationdate()); for ($i = 0; $i < $fieldList->length; $i++) { $fieldNode = $fieldList->item($i); $fieldName = $fieldNode->getAttribute('name'); $fieldLabel = $fieldNode->getAttribute('label'); $fieldType = $fieldNode->getAttribute('type'); $fieldValue = $fieldNode->nodeValue; if ($fieldType == 'file') { $fieldValue = intval($fieldNode->nodeValue); if ($fieldValue > 0) { $fieldValue = MediaHelper::getUrl($fieldValue); } else { $fieldValue = ''; } } else { if ($fieldType == 'list' && $fieldNode->hasAttribute('mailValue')) { $fieldValue = $fieldNode->getAttribute('mailValue'); } } if (!isset($fieldNames[$fieldName])) { $fieldNames[$fieldName] = $fieldLabel; } $fields[$fieldName] = $fieldValue; } $responsesAttribute[] = $fields; } $fileName = "export_formulaire_" . f_util_FileUtils::cleanFilename($form->getLabel()) . '_' . date('Ymd_His') . '.csv'; $options = new f_util_CSVUtils_export_options(); $options->separator = ";"; $csv = f_util_CSVUtils::export($fieldNames, $responsesAttribute, $options); header("Content-type: text/comma-separated-values"); header('Content-length: ' . strlen($csv)); header('Content-disposition: attachment; filename="' . $fileName . '"'); echo $csv; exit; }
public function _execute($context, $request) { $this->setTemplateName('Form-Responses', K::HTML); $form = $request->getAttribute('form'); $this->setAttribute('form', $form); $query = form_ResponseService::getInstance()->createQuery()->add(Restrictions::eq('parentForm', $form))->addOrder(Order::desc('document_creationdate')); if ($request->getAttribute('all') != 'all') { $query->add(Restrictions::published()); } $responses = $query->find(); $this->setAttribute('responsesCount', count($responses)); $responsesInfos = array(); foreach ($responses as $response) { $responsesInfos[] = $response->getResponseInfos(); } $this->setAttribute('responses', $responsesInfos); }
$criteria->find($alumnoGuardar); $alumnoGuardar->lista = $i++; $criteria->merge($alumnoGuardar); } moveLocationFast("UTP-listaCurso.php?curso=" . $curso . "&exito=exito"); } } $orden_alfabetico = false; if (isset($_POST['buscar'])) { if ($_POST['buscar'] == "orden_alfabetico") { $smarty->assign("warning", "Para que la lista quede guardada debe presionar el botón guardar"); $orden_alfabetico = true; } } $criteria->createCriteria($alumno); $criteria->add(Restrictions::eq("curso", $curso)); if (!$orden_alfabetico) { $criteria->addOrder(Order::asc("lista")); } else { $criteria->addOrder(Order::asc("apellidop, apellidom, nombres")); } $listAlumnos = $criteria->lista(); $smarty->assign("listAlumnos", $listAlumnos); $smarty->assign("titulo_principal", mostrar_curso($curso, true)); $smarty->assign("title", "UTP: Modificar Cursos"); $smarty->assign("titulo_secundario", "Listado Alumnos"); $menu[] = array("img" => "", "url" => "modificar_cursos.php", "text" => "Volver", "title" => "Volver", "alt" => "Volver"); $menu[] = array("img" => "", "url" => "#", "text" => "Lista Alumnos", "title" => "Lista Alumnos", "alt" => "Lista Alumnos", "id" => "", "class" => "current_page_item"); $smarty->assign("menu", $menu); $smarty->assign("file_content", "utp/UTP-listaCurso.tpl"); $smarty->display('layout/main.tpl');
/** * @param form_persistentdocument_field $field * @param integer $parentNodeId * @throws form_FormException When $field is not inside a form * @throws form_FieldAlreadyExistsException When the name of $field is not available */ public function checkFieldNameAvailable($field, $parentNodeId) { $fieldName = $field->getFieldName(); $parent = DocumentHelper::getDocumentInstance($parentNodeId); if ($parent instanceof form_persistentdocument_baseform) { $form = $parent; } else { $form = $this->getAncestorFormByDocument($parent); if ($form === null) { throw new form_FormException("Field \"" . $field->__toString() . "\" is not inside a form."); } } $query = $this->getPersistentProvider()->createQuery('modules_form/field'); $query->add(Restrictions::descendentOf($form->getId())); $query->add(Restrictions::eq('fieldName', $fieldName)); $result = $query->findUnique(); if ($result !== null && $result->getId() != $field->getId()) { throw new form_FieldAlreadyExistsException(f_Locale::translate('&modules.form.bo.errors.Field-name-alreay-used;', array('fieldName' => $fieldName))); } }
$bloques_horario = $class_horario->generarBloques(); $smarty->assign("bloques_horario", $bloques_horario); $horario->FK_personal_pers_ID = $personal->pers_ID; $horario->hrs_anio = $_SESSION['base_datos']->anio; $criteria->find($horario); $valores_horario['lunes'] = explode(";", $horario->hrs_lunes); $valores_horario['martes'] = explode(";", $horario->hrs_martes); $valores_horario['miercoles'] = explode(";", $horario->hrs_miercoles); $valores_horario['jueves'] = explode(";", $horario->hrs_jueves); $valores_horario['viernes'] = explode(";", $horario->hrs_viernes); $valores_horario['sabado'] = explode(";", $horario->hrs_sabado); $smarty->assign("valores_horario", $valores_horario); $criteria->createCriteria($observacion); $criteria->addOrder(Order::desc("obs_ID")); $criteria->add(Restrictions::eq("FK_persona_per_ID", $persona->per_ID)); $criteria->add(Restrictions::eq("obs_anio", $_SESSION['base_datos']->anio)); $listObservaciones = $criteria->lista(); $smarty->assign("listObservaciones", $listObservaciones); } if (isset($_GET['exito']) && !isset($_POST['guardar'])) { if ($_GET['exito'] == "exito") { $smarty->assign("exito", "La información se ha guardado exitosamente"); } } if (isset($_POST['guardar']) && postForm($_POST['postID'])) { if ($_POST['guardar'] == "Enviar Foto") { if ($persona->per_ID) { subirFotoAlumno($per_ID); } } if ($_POST['guardar'] == "guardar_persona") {
recursiveDelete(CRITERIA_PATH_RELATIVE . "generation"); mkdir(CRITERIA_PATH_RELATIVE . "generation", 0755); echo "<hr>Entitades en la carpeta generation:<hr>"; $criteriaDBDefault = $_POST["database"]; $criteriaGenerate = new CriteriaGenerate($criteriaDBDefault); $criteriaGenerate->generateEntity(); listar_directorios_ruta(CRITERIA_PATH_RELATIVE . "generation"); break; case "CARGAR_PRUEBAS": echo "Cargando Pruebas"; require_once 'generation/EntityBecas.php'; // require_once 'generation/EntityArancel.php'; $criteria = new Criteria(); $becas = new EntityBecas(); $criteria->createCriteria($becas); $criteria->add(Restrictions::eq("beca_anio", "2011")); $criteria->add(Restrictions::between("beca_ID", 4, 9)); $criteria->addOrder(Order::desc("beca_ID")); //$criteria-> dprCriteria($criteria->getSQL()); $lol = $criteria->lista(); dprCriteria($lol); //$criteria->add($restrictions); // $filial = new EntityCCA_FILIAL(); // $filial->ID_FILIAL = 1; // $criteria->find($filial); // dpr($filial); // $filial->APLICACION_ACTUALIZACION = "PruebMerg2"; // $criteria->merge($filial); // $filial->ID_FILIAL = null; // $filial->APLICACION_ACTUALIZACION = "Persist";