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