public static function getFieldValue($fieldId, $configId) { $c = new Criteria(); $c->add(FieldValuePeer::FIELD_ID, $fieldId); $c->add(FieldValuePeer::CONFIG_ID, $configId); if ($value = FieldValuePeer::doSelectOne($c)) { return $value; } else { $value = new FieldValue(); $value->setFieldId($fieldId); $value->setConfigId($configId); return $value; } }
public function __construct($node, $parent) { parent::__construct($node, $parent); self::$possible_attributes = array_merge(parent::$possible_attributes, self::$possible_attributes); self::$required_attributes = array_merge(parent::$required_attributes, self::$required_attributes); self::$possible_children = array_merge(parent::$possible_children, self::$possible_children); self::$required_children = array_merge(parent::$required_children, self::$required_children); }
public function execute($request) { //get params $this->brand = $this->getRequestParameter('brand'); $this->series = $this->getRequestParameter('series'); $this->model = $this->getRequestParameter('model'); $this->configId = $this->getRequestParameter('config_id'); //get image files $this->mainImage = $this->getRequest()->getFiles('main_image'); $this->otherImages = $this->getRequest()->getFiles('other_images'); //print_r($this->otherImages); //exit (); //load/create series and model if (SeriesPeer::isNew($this->series)) { //create new series $seriesObj = new Series(); $seriesObj->setSeriesName($this->series); $seriesObj->setBrandId($this->brand); $seriesObj->save(); //create new model $modelObj = new Model(); $modelObj->setModelName($this->model); $modelObj->setSeries($seriesObj); $modelObj->save(); } else { //load series object $seriesObj = SeriesPeer::getSeriesByName($this->series); if (ModelPeer::isNew($this->model)) { //create new model $modelObj = new Model(); $modelObj->setModelName($this->model); $modelObj->setSeries($seriesObj); $modelObj->save(); } else { $modelObj = ModelPeer::getModelByName($this->model); } } ////////////////////// if (($this->isNew = $this->getRequestParameter('is_new')) == 'true') { //create new config $config = new Config(); $config->setConfigName($this->getRequestParameter('name')); $config->setModel($modelObj); $config->save(); //load config fields $configFields = ConfigFieldPeer::doSelect(new Criteria()); foreach ($configFields as $configField) { //get param if ($this->hasRequestParameter("field_" . $configField->getId())) { //if (strlen($this->getRequestParameter("field_".$configField->getId())) > 0 ) //{ $fieldValue = new FieldValue(); $fieldValue->setConfig($config); $fieldValue->setFieldId($configField->getId()); $fieldValue->setValue($this->getRequestParameter("field_" . $configField->getId())); $fieldValue->save(); //} } } } else { //load config $config = ConfigPeer::retrieveByPK($this->configId); //$config->setConfigName($this->getRequestParameter('name')); $config->setModel($modelObj); $config->save(); //load config fields $configFields = ConfigFieldPeer::doSelect(new Criteria()); foreach ($configFields as $configField) { //get param if ($this->hasRequestParameter("field_" . $configField->getId())) { //if (strlen($this->getRequestParameter("field_".$configField->getId())) > 0 ) //{ $fieldValue = FieldValuePeer::getFieldValue($configField->getId(), $config->getId()); $fieldValue->setValue($this->getRequestParameter("field_" . $configField->getId())); $fieldValue->save(); //} } } } //save main image MediaPeer::saveMedia($this->mainImage, $modelObj->getId(), MediaPeer::IMAGE, 'Model', true); //save other images foreach ($this->otherImages as $image) { MediaPeer::saveMedia($image, $modelObj->getId(), MediaPeer::IMAGE, 'Model', false); } if (($saveAndNew = $this->getRequestParameter('save_and_new')) == 'true') { $this->redirect('config/newconfig'); } else { $this->redirect('config/editconfig?id=' . $config->getId()); } }
public function run() { DB::table('fieldvalues')->delete(); // Valores de Voleibol - Rama FieldValue::create(array('idSportField' => '1', 'description' => 'Femenil')); FieldValue::create(array('idSportField' => '1', 'description' => 'Varonil')); // Valores de Voleibol - Escolaridad FieldValue::create(array('idSportField' => '2', 'description' => 'Primaria')); FieldValue::create(array('idSportField' => '2', 'description' => 'Secundaria')); FieldValue::create(array('idSportField' => '2', 'description' => 'Preparatoria')); FieldValue::create(array('idSportField' => '2', 'description' => 'Universidad')); // Valores de Voleibol - Categoría FieldValue::create(array('idSportField' => '3', 'description' => 'Infantil Mayor Sub 15')); FieldValue::create(array('idSportField' => '3', 'description' => 'Juvenil Menor Sub 17')); FieldValue::create(array('idSportField' => '3', 'description' => 'Juvenil Mayor Sub 19')); FieldValue::create(array('idSportField' => '3', 'description' => 'Juvenil Superior Sub 21')); // Valores de Voleibol - Posición FieldValue::create(array('idSportField' => '4', 'description' => 'Libero')); FieldValue::create(array('idSportField' => '4', 'description' => 'Central')); FieldValue::create(array('idSportField' => '4', 'description' => 'Opuesto')); FieldValue::create(array('idSportField' => '4', 'description' => 'Colocador')); FieldValue::create(array('idSportField' => '4', 'description' => 'Cuatro')); // Valores de Clavados - Rama FieldValue::create(array('idSportField' => '5', 'description' => 'Femenil')); FieldValue::create(array('idSportField' => '5', 'description' => 'Varonil')); // Valores de Clavados - Escolaridad FieldValue::create(array('idSportField' => '6', 'description' => 'Primaria')); FieldValue::create(array('idSportField' => '6', 'description' => 'Secundaria')); FieldValue::create(array('idSportField' => '6', 'description' => 'Preparatoria')); // Valores de Clavados - Categoría FieldValue::create(array('idSportField' => '7', 'description' => 'Grupo D (9-11)')); FieldValue::create(array('idSportField' => '7', 'description' => 'Grupo C (12-13)')); FieldValue::create(array('idSportField' => '7', 'description' => 'Grupo B (14-15)')); FieldValue::create(array('idSportField' => '7', 'description' => 'Grupo A (16-18)')); // Valores de Ciclismo - Escolaridad FieldValue::create(array('idSportField' => '8', 'description' => 'Primaria')); FieldValue::create(array('idSportField' => '8', 'description' => 'Secundaria')); FieldValue::create(array('idSportField' => '8', 'description' => 'Preparatoria')); FieldValue::create(array('idSportField' => '8', 'description' => 'Universidad')); // Valores de Ciclismo - Competencias o pruebas FieldValue::create(array('idSportField' => '9', 'description' => 'Ruta')); FieldValue::create(array('idSportField' => '9', 'description' => 'Montaña')); FieldValue::create(array('idSportField' => '9', 'description' => 'Pista')); FieldValue::create(array('idSportField' => '9', 'description' => 'Contrarreloj')); FieldValue::create(array('idSportField' => '9', 'description' => 'Velocidad individual : 200 metros y 500 metros')); FieldValue::create(array('idSportField' => '9', 'description' => 'Velocidad por equipos')); FieldValue::create(array('idSportField' => '9', 'description' => 'Kilómetro contrarreloj: 1000 metros varonil 500 metros femenil')); FieldValue::create(array('idSportField' => '9', 'description' => 'Persecución individual: 4000 metros varonil y 3000 metros femenil')); FieldValue::create(array('idSportField' => '9', 'description' => 'Persecución por equipos ')); FieldValue::create(array('idSportField' => '9', 'description' => 'Carrera por puntos')); FieldValue::create(array('idSportField' => '9', 'description' => 'Keirin')); FieldValue::create(array('idSportField' => '9', 'description' => 'Scratch')); FieldValue::create(array('idSportField' => '9', 'description' => 'Ómnium')); FieldValue::create(array('idSportField' => '9', 'description' => 'Eliminación')); FieldValue::create(array('idSportField' => '9', 'description' => 'Madison')); // Valores Ciclismo - Categoria FieldValue::create(array('idSportField' => '10', 'description' => 'Juvenil A')); FieldValue::create(array('idSportField' => '10', 'description' => 'Juvenil B')); FieldValue::create(array('idSportField' => '10', 'description' => 'Juvenil C')); FieldValue::create(array('idSportField' => '10', 'description' => 'Juvenil superior')); // Valores de Tiro con Arco - Categoria FieldValue::create(array('idSportField' => '11', 'description' => 'Infantil')); FieldValue::create(array('idSportField' => '11', 'description' => 'Juvenil menor A')); FieldValue::create(array('idSportField' => '11', 'description' => 'Juvenil menor B')); FieldValue::create(array('idSportField' => '11', 'description' => 'Juvenil superior')); FieldValue::create(array('idSportField' => '11', 'description' => 'Juvenil Mayor')); // Valores de Tiro con Arco - Prueba FieldValue::create(array('idSportField' => '12', 'description' => 'Recurvo')); FieldValue::create(array('idSportField' => '12', 'description' => 'Compuesto')); // Valores de Esgrima - Categoria FieldValue::create(array('idSportField' => '13', 'description' => 'Infantil')); FieldValue::create(array('idSportField' => '13', 'description' => 'Cadete menor')); FieldValue::create(array('idSportField' => '13', 'description' => 'Cadete mayor')); FieldValue::create(array('idSportField' => '13', 'description' => 'Juvenil Superior')); FieldValue::create(array('idSportField' => '13', 'description' => 'Open')); // Valores de Esgrima - Prueba FieldValue::create(array('idSportField' => '14', 'description' => 'Sable')); FieldValue::create(array('idSportField' => '14', 'description' => 'Espada')); FieldValue::create(array('idSportField' => '14', 'description' => 'Florete')); // Valores de Canotaje - Categoria FieldValue::create(array('idSportField' => '15', 'description' => 'Infantil mayor sub 15')); FieldValue::create(array('idSportField' => '15', 'description' => 'Infantil mayor sub 17')); FieldValue::create(array('idSportField' => '15', 'description' => 'Infantil mayor sub 19')); FieldValue::create(array('idSportField' => '15', 'description' => 'Juvenil superior')); // Valores de Canotaje - Prueba FieldValue::create(array('idSportField' => '16', 'description' => 'Kayak')); FieldValue::create(array('idSportField' => '16', 'description' => 'Canoa')); // Tiro deportivo - Escolaridad FieldValue::create(array('idSportField' => '17', 'description' => 'Primaria')); FieldValue::create(array('idSportField' => '17', 'description' => 'Secundaria')); FieldValue::create(array('idSportField' => '17', 'description' => 'Preparatoria')); FieldValue::create(array('idSportField' => '17', 'description' => 'Universidad')); // Tiro deportivo - Categoría FieldValue::create(array('idSportField' => '18', 'description' => 'Pre juvenil')); FieldValue::create(array('idSportField' => '18', 'description' => 'Juvenil menor')); FieldValue::create(array('idSportField' => '18', 'description' => 'Juvenil A')); FieldValue::create(array('idSportField' => '18', 'description' => 'Juvenil B')); // Tiro deportivo - Prueba FieldValue::create(array('idSportField' => '19', 'description' => 'Tiro olímpico rifle match')); FieldValue::create(array('idSportField' => '19', 'description' => 'Tiro olímpico pistola')); FieldValue::create(array('idSportField' => '19', 'description' => 'Tiro olímpico rifle de quebrar')); // Badminton - Escolaridad FieldValue::create(array('idSportField' => '20', 'description' => 'Primaria')); FieldValue::create(array('idSportField' => '20', 'description' => 'Secundaria')); FieldValue::create(array('idSportField' => '20', 'description' => 'Preparatoria')); FieldValue::create(array('idSportField' => '20', 'description' => 'Universidad')); // Badminton - Categoria FieldValue::create(array('idSportField' => '21', 'description' => 'Juvenil menor sub 15')); FieldValue::create(array('idSportField' => '21', 'description' => 'Juvenil mayor sub 15')); FieldValue::create(array('idSportField' => '21', 'description' => 'Juvenil menor sub 17')); FieldValue::create(array('idSportField' => '21', 'description' => 'Juvenil mayor sub 17')); FieldValue::create(array('idSportField' => '21', 'description' => 'Juvenil menor sub 19')); FieldValue::create(array('idSportField' => '21', 'description' => 'Juvenil mayor sub 19')); // Badminton - Competencias FieldValue::create(array('idSportField' => '22', 'description' => 'Individual')); FieldValue::create(array('idSportField' => '22', 'description' => 'Equipos')); // Natacion - Categoria FieldValue::create(array('idSportField' => '23', 'description' => 'Infantil B (11-12)')); FieldValue::create(array('idSportField' => '23', 'description' => 'Juvenil A (13-14)')); FieldValue::create(array('idSportField' => '23', 'description' => 'Juvenil B (15-16)')); FieldValue::create(array('idSportField' => '23', 'description' => 'Primera fuerza (17-18)')); // Natacion - Estilo principal FieldValue::create(array('idSportField' => '24', 'description' => 'Libre (Crawl)')); FieldValue::create(array('idSportField' => '24', 'description' => 'Dorso')); FieldValue::create(array('idSportField' => '24', 'description' => 'Pecho')); FieldValue::create(array('idSportField' => '24', 'description' => 'Mariposa')); // Natacion - Tipo de pruebas FieldValue::create(array('idSportField' => '25', 'description' => 'Super velocidad')); FieldValue::create(array('idSportField' => '25', 'description' => 'Velocidad')); FieldValue::create(array('idSportField' => '25', 'description' => 'Medio fondo')); FieldValue::create(array('idSportField' => '25', 'description' => 'Fondo')); FieldValue::create(array('idSportField' => '25', 'description' => 'Aguas abiertas')); // Tae Kwon Do - Modalidades FieldValue::create(array('idSportField' => '26', 'description' => 'Formas')); FieldValue::create(array('idSportField' => '26', 'description' => 'Combate')); // Tae Kwon Do - Categoria FieldValue::create(array('idSportField' => '27', 'description' => 'Infantil menor')); FieldValue::create(array('idSportField' => '27', 'description' => 'Infantil mayor')); FieldValue::create(array('idSportField' => '27', 'description' => 'Juvenil menor')); FieldValue::create(array('idSportField' => '27', 'description' => 'Juvenil mayor')); // Judo - Categoria FieldValue::create(array('idSportField' => '28', 'description' => 'Infantil mayor')); FieldValue::create(array('idSportField' => '28', 'description' => 'Juvenil menor')); FieldValue::create(array('idSportField' => '28', 'description' => 'Juvenil mayor')); FieldValue::create(array('idSportField' => '28', 'description' => 'Juvenil superior')); }
public function saveProfile() { if (Request::ajax()) { $data = Input::all(); $user = null; if (Session::has('athleteEmail')) { $userEmail = Session::get('athleteEmail'); $user = User::where("email", "=", $userEmail)->first(); } else { $user = Auth::user(); } if ($user != null) { $createNew = $user->lastProfile->hasTests(); // Crear nuevo registro de perfil para mantener el actual como historial if ($createNew) { // Nuevo Perfil $profile = new Profile(); $profile->idSport = Input::get('sport'); $profile->idRole = Role::where("description", "=", "Deportista")->first()->idRole; $profile->idCity = Input::get('city'); $profile->save(); if (Input::has("values")) { // Nuevos valores de Perfil foreach (Input::get('values') as $value) { $fieldValue = FieldValue::find($value); $fieldValue->load('field'); $profileValue = new ProfileValue(); $profileValue->idFieldValue = $fieldValue->idFieldValue; $profileValue->idSportField = $fieldValue->field->idSportField; $profile->profileValues()->save($profileValue); } } // Attach del nuevo Perfil $user->idLastProfile = $profile->idProfile; $user->save(); } else { // Actualización de datos $profile = $user->lastProfile; $profile->idSport = Input::get('sport'); $profile->idRole = Role::where("description", "=", "Deportista")->first()->idRole; $profile->idCity = Input::get('city'); $profile->save(); // Elminación de ProfileValues $profile->profileValues()->delete(); // Inserción de nuevos values if (Input::has("values")) { // Nuevos valores de Perfil foreach (Input::get('values') as $value) { $fieldValue = FieldValue::find($value); $fieldValue->load('field'); $profileValue = new ProfileValue(); $profileValue->idFieldValue = $fieldValue->idFieldValue; $profileValue->idSportField = $fieldValue->field->idSportField; $profile->profileValues()->save($profileValue); } } } } } }
public function executeProcessConfigForm(sfWebRequest $request) { $data = $request->getGetParameters(); $config = new Config(); if ($data['cid'] == '-1') { // New Config $config->setModelId($data['mid']); $config->save(); foreach ($data as $field => $value) { if ($field != 'cid' && $field != 'mid') { $fv = new FieldValue(); $fv->setConfigId($config->getId()); $fv->setFieldId(intval($field)); $fv->setValue($value); //echo intval($field)."\n"; $fv->save(); } } } else { $config = ConfigPeer::retrieveByPK($data['cid']); foreach ($data as $field => $value) { if ($field != 'cid' && $field != 'mid') { $c = new Criteria(); $c->add(FieldValuePeer::FIELD_ID, intval($field)); $c->add(FieldValuePeer::CONFIG_ID, $config->getId()); $fv = FieldValuePeer::doSelectOne($c); if (!is_object($fv)) { $fv = new FieldValue(); $fv->setConfigId($config->getId()); $fv->setFieldId(intval($field)); } $fv->setValue($value); //echo intval($fv->getValue())."#"; //print_r($fv, FALSE); $fv->save(); } } } $this->res = $config->getId(); }
/** * Adds an object to the instance pool. * * Propel keeps cached copies of objects in an instance pool when they are retrieved * from the database. In some cases -- especially when you override doSelect*() * methods in your stub classes -- you may need to explicitly add objects * to the cache in order to ensure that the same objects are always returned by doSelect*() * and retrieveByPK*() calls. * * @param FieldValue $value A FieldValue object. * @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally). */ public static function addInstanceToPool(FieldValue $obj, $key = null) { if (Propel::isInstancePoolingEnabled()) { if ($key === null) { $key = (string) $obj->getId(); } // if key === null self::$instances[$key] = $obj; } }
/** * Inserta un campo con su rango de valores * * @param array $array referencia al arreglo al cual agregar el campo * @param SportField $field Instancia de la pregunta o campo actual * @param FieldValue $selected Instancia del valor seleccionado en el <select> * @param FieldValue $parentOfSelected Instancia padre del valor seleccionado */ static function addField(&$array, $field, $selected, $parentOfSelected) { $level = $selected->level(); $array[] = array('name' => $field->name, 'id' => 'valueOf-' . $field->idSportField . '-' . $level, 'selected' => $selected->idFieldValue, 'values' => $field->getValuesFromSameLevel($parentOfSelected)->lists('description', 'idFieldValue'), 'isTopLevel' => $parentOfSelected == null); }