public function saveUniversList($con = null)
{
if (!$this->isValid()) {
throw $this->getErrorSchema();
}
if (!isset($this->widgetSchema['univers_list'])) {
// somebody has unset this widget
return;
}
if (null === $con) {
$con = $this->getConnection();
}
$existing = $this->object->Univers->getPrimaryKeys();
$values = $this->getValue('univers_list');
if (!is_array($values)) {
$values = array();
}
$unlink = array_diff($existing, $values);
if (count($unlink)) {
$this->object->unlink('Univers', array_values($unlink));
// trace for synchro
$delete_log = new DeleteLog();
$delete_log->setGuid(Guid::generate());
$delete_log->setExtra('medaille_id: "' . $this->getObject()->getGuid() . '"|univers_id: "' . implode('", "', array_values($unlink)) . '"');
$delete_log->setModelName('UniversMedaille');
$delete_log->save();
}
$link = array_diff($values, $existing);
if (count($link)) {
$this->object->link('Univers', array_values($link));
}
}
public function configure()
{
$this->setValidator('guid', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('guid', Guid::generate());
$this->setWidget('visiteur_id', new sfWidgetFormInputText());
unset($this['updated_at'], $this['created_at']);
}
protected function doSave()
{
$this->object->setGuid(Guid::generate());
$this->object->save();
$this->output = $this->getSerializer()->serialize($this->object->getGuid());
return sfView::SUCCESS;
}
public function saveLangueList($con = null)
{
if (!$this->isValid()) {
throw $this->getErrorSchema();
}
if (!isset($this->widgetSchema['langue_list'])) {
// somebody has unset this widget
return;
}
if (null === $con) {
$con = $this->getConnection();
}
$existing = $this->object->Langue->getPrimaryKeys();
$values = $this->getValue('langue_list');
if (!is_array($values)) {
$values = array();
}
$unlink = array_diff($existing, $values);
if (count($unlink)) {
$this->object->unlink('Langue', array_values($unlink));
$delete_log = new DeleteLog();
$delete_log->setGuid(Guid::generate());
$delete_log->setExtra('exposition_visiteurneeds_id: "' . $this->getObject()->getGuid() . '"|langue_id: "' . implode('", "', array_values($unlink)) . '"');
$delete_log->setModelName('LangueExpositionVisiteurNeeds');
$delete_log->save();
}
$link = array_diff($values, $existing);
if (count($link)) {
$this->object->link('Langue', array_values($link));
}
}
public function save(Doctrine_Connection $conn = null)
{
if (empty($this->guid)) {
$this->set('guid', Guid::generate());
}
$this->setIsTosync(1);
parent::save($conn);
}
public function configure()
{
$this->setValidator('guid', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('guid', Guid::generate());
$this->setWidget('visiteur_id', new sfWidgetFormInputText());
$this->getWidget('typologie_id')->setOption('order_by', array('libelle', 'asc'));
unset($this['updated_at'], $this['created_at']);
}
public function __call($method, $arguments)
{
if ($method == 'setGuid') {
return $this->set('guid', Guid::generate());
} else {
return parent::__call($method, $arguments);
}
}
public static function createXp($typologie_id, $visiteur_id, $score)
{
$xp = new Xp();
$xp->setGuid(Guid::generate());
$xp->setTypologieId($typologie_id);
$xp->setScore($score);
$xp->setVisiteurId($visiteur_id);
$xp->save();
return $xp->getGuid();
}
public function configure()
{
$this->validatorSchema->setOption('allow_extra_fields', true);
//$this->validatorSchema->setOption('filter_extra_fields', false);
$this->setValidator('guid', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('guid', Guid::generate());
unset($this['updated_at'], $this['created_at'], $this['is_tosync']);
$this->widgetSchema['contexte_creation_id'] = new sfWidgetFormDoctrineChoice(array('model' => "Contexte", 'add_empty' => false));
$this->validatorSchema['contexte_creation_id'] = new sfValidatorDoctrineChoice(array('model' => "Contexte", 'required' => false));
}
public static function createVisiteurMedaille($visiteur_id, $medaille_id, $univers_id, $contexte_id)
{
$new_visiteur_medaille = new VisiteurMedaille();
$new_visiteur_medaille->setGuid(Guid::generate());
$new_visiteur_medaille->setVisiteurId($visiteur_id);
$new_visiteur_medaille->setUniversId($univers_id);
$new_visiteur_medaille->setMedailleId($medaille_id);
$new_visiteur_medaille->setContexteId($contexte_id);
$new_visiteur_medaille->save();
return $new_visiteur_medaille->getGuid();
}
public function executeCopy(sfWebRequest $request)
{
$parcours = $this->getRoute()->getObject();
$interactifs = $parcours->Interactif->getPrimaryKeys();
$parcours_copy = $parcours->copy();
$parcours_copy->setGuid(Guid::generate());
$parcours_copy->setLibelle($parcours->getLibelle() . "-copie");
$parcours_copy->setCreatedAt(date('Y-m-d H:i:s'));
$parcours_copy->setUpdatedAt(date('Y-m-d H:i:s'));
$parcours_copy->link('Interactif', array_values($interactifs));
$parcours_copy->save();
return $this->redirect($this->getController()->genUrl('parcours/edit?guid=' . $parcours_copy->getGuid()));
}
public function configure()
{
$this->setValidator('guid', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('guid', Guid::generate());
$this->setWidget('date_naissance', new sfWidgetFormJqueryDateVip(array('empty_values' => array('year' => '', 'month' => '', 'day' => ''), 'can_be_empty' => true, 'date_range' => array('min' => date('Y') - 100, 'max' => date('Y')))));
$this->getWidget('preference_media_list')->setOption('renderer_class', 'sfWidgetFormSelectDoubleList');
$this->getWidget('preference_media_list')->setOption('renderer_options', array('label_unassociated' => 'Disponibles', 'label_associated' => 'Séléctionnés'));
$this->setDefault('langue_id', '');
$this->getWidget('langue_id')->setOption('add_empty', true);
$this->setValidator('password_son', new sfValidatorString(array('max_length' => 255, 'required' => true)));
$this->setValidator('pseudo_son', new sfValidatorString(array('max_length' => 255, 'required' => true)));
$this->setValidator('email', new sfValidatorEmail(array('max_length' => 255, 'required' => true)));
unset($this['updated_at'], $this['created_at'], $this['is_tosync']);
}
public function configure()
{
$this->setValidator('guid', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('guid', Guid::generate());
$this->getWidget('flotte_id')->setOption('order_by', array('libelle', 'asc'));
//$this->setWidget('start_at',new sfWidgetFormI18nDateTime(array('culture' => 'fr')));
$this->setWidget('interactif_id', new sfWidgetFormDoctrineChoice(array('model' => $this->getRelatedModelName('Interactif'), 'add_empty' => false, 'order_by' => array('libelle', 'asc'))));
///^[0-9]+$/
//$this->validatorSchema['adresse_mac'] = new sfValidatorRegex(array('pattern' => '/^([0-9A-F]{2}[:-]){5}([0-9A-F]{2})$/'));
$this->validatorSchema['adresse_mac'] = new sfValidatorString(array('required' => true));
$this->validatorSchema['adresse_ip'] = new sfValidatorRegex(array('pattern' => '/^\\b(?:\\d{1,3}\\.){3}\\d{1,3}\\b$/', 'required' => false));
/* ^([0-9A-F]{2}[:-]){5}([0-9A-F]{2})$ */
unset($this['updated_at'], $this['created_at']);
}
public function executeCopy(sfWebRequest $request)
{
$exposition = $this->getRoute()->getObject();
$parcours = $exposition->Parcours->getPrimaryKeys();
$exposition_copy = $exposition->copy();
$exposition_copy->setGuid(Guid::generate());
$exposition_copy->setLibelle($exposition->getLibelle() . '-COPY');
$exposition_copy->setCreatedAt(date('Y-m-d H:i:s'));
$exposition_copy->setUpdatedAt(date('Y-m-d H:i:s'));
$exposition_copy->setOrganisateurDiffuseurId(null);
$exposition_copy->setContexteId(null);
$exposition_copy->link('Parcours', array_values($parcours));
$exposition_copy->save();
return $this->redirect($this->getController()->genUrl('exposition/edit?guid=' . $exposition_copy->getGuid()));
}
/**
* Initialise la syncro
* Récupération de la dernière date de synchro + création dateNowSync + génération Guid synchro
* - Récupération de la dernière date de synchro dans le modèle syncLog
* - On fige une date de synchro courante
* - On génére un guid de synchro qui sera servira d'identifiant au modèle syncLog et de nom de fichier du dump
* - Insère en BDD les paramètres de syncho dans le modèle syncLog
* @param sfApplicationConfiguration $configuration
* @param SyncLog $sync_log
* @param string $type
*/
public function __construct($configuration, $sync_log = null, $type = 'intranet')
{
if (!$sync_log) {
$this->log("Contruction des paramètres de la synchro {$type}");
$this->sync_log = new SyncLog();
$this->sync_log->setGuid(Guid::generate());
$this->sync_log->setOrigin(sfConfig::get('app_sync_name'));
$this->sync_log->setFromDatetimeSync($this->getLastSyncDate());
$this->sync_log->setToDatetimeSync(date('Y-m-d H:i:s'));
$this->log("Date du " . $this->getLastSyncDate() . " au " . $this->sync_log->getToDatetimeSync());
} else {
$this->sync_log = $sync_log;
}
$this->type = $type;
$this->configuration = $configuration;
}
public function configure()
{
$permissions = Doctrine_Core::getTable('sfGuardPermission')->findAll();
$choices = array();
foreach ($permissions as $permission) {
$choices[$permission->getId()] = $permission->getName();
}
$this->setWidget('permissions', new sfWidgetFormSelectRadio(array('choices' => $choices)));
$this->setValidator('permissions', new sfValidatorChoice(array('choices' => array_keys($choices))));
$this->setValidator('id', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('id', Guid::generateId());
$this->setWidget('exposition_list', new sfWidgetFormDoctrineChoice(array('multiple' => true, 'model' => 'Exposition', 'renderer_class' => 'sfWidgetFormSelectDoubleList')));
$this->getWidget('exposition_list')->setOption('renderer_options', array('label_unassociated' => 'Disponibles', 'label_associated' => 'Séléctionnés'));
$this->getWidgetSchema()->moveField('exposition_list', sfWidgetFormSchema::AFTER, 'permissions');
unset($this['updated_at'], $this['created_at'], $this['last_login'], $this['groups_list'], $this['permissions_list'], $this['is_super_admin'], $this['algorithm'], $this['salt'], $this['is_tosync']);
}
/**
* Send notification through websocket server
*
* @param $type string
* @param $dest array array of notification's recipients (visiteur:<guid> ,visite:<guid>, exposition:<guid>, parcours:<guid>)
* @param $options array array of notification's parameters
* @param $model array -> array('model' => '', 'model_id' => '')
*/
public function sendNotification($type, $dest, $options, $model = null)
{
// This is our new stuff
$context = new \ZMQContext();
$socket = $context->getSocket(\ZMQ::SOCKET_PUSH, 'ServerVip pusher');
$socket->connect($this->uri);
$vars = array();
$explode1 = explode(",", $dest);
foreach ($explode1 as $values) {
$data = explode(":", $values);
$key = trim($data[0]);
$value = trim($data[1]);
$vars[$key] = $value;
}
if (isset($vars['visiteur']) && trim($vars['visiteur']) != '') {
$visiteur_id = $vars['visiteur'];
} else {
throw new sfException('You must specify visiteur.');
$visiteur_id = 'NULL';
}
if (isset($vars['visite'])) {
$visite_id = $vars['visite'];
} else {
$visite_id = 'NULL';
}
if ($visiteur_id && strpos($option, 'stdClass') === false) {
$notif = new Notification();
$notif->setGuid(Guid::generate());
$notif->setLibelle($options['title']);
$notif->setVisiteurId($visiteur_id);
$notif->setVisiteId($visite_id);
if (isset($model['model'])) {
$notif->setFromModel($model['model']);
}
if (isset($model['model_id'])) {
$notif->setFromModelId($model['model_id']);
}
$notif->setParameter(json_encode((array) $options));
$notif->save();
}
$socket->send(json_encode(array('command' => 'notification.send', 'data' => array('dest' => $dest, 'type' => $type, 'options' => $options, 'model' => $model))));
}
public static function setNewVisiteurUniversStatus($new_univers_status, $univers_id, $visiteur_id, $gain_id = null, $gain_expiration_days = 0, $contexte_id = null)
{
$new_visiteur_status = new VisiteurUniversStatusGain();
$new_visiteur_status->setGuid(Guid::generate());
$new_visiteur_status->setUniversStatusId($new_univers_status);
$new_visiteur_status->setVisiteurId($visiteur_id);
$new_visiteur_status->setGainId($gain_id);
$new_visiteur_status->setUniversId($univers_id);
$new_visiteur_status->setContexteId($contexte_id);
if ($gain_expiration_days === 0) {
$new_visiteur_status->setStatusGain(null);
$new_visiteur_status->setExpirationGainDate(null);
} else {
$new_visiteur_status->setStatusGain('waiting');
$date = date_create(date('Y-m-d'));
date_add($date, date_interval_create_from_date_string($gain_expiration_days . ' days'));
$new_visiteur_status->setExpirationGainDate(date_format($date, 'Y-m-d'));
}
$new_visiteur_status->save();
}
public function save(Doctrine_Connection $conn = null)
{
if ($this->isNew()) {
$this->createDataFolder();
if ($this->getGuid() == null && $this->getLibelle() != '') {
$this->setGuid(Guid::generate());
/*
if($this->getLibelle() == ''){
$referer = $_SERVER["HTTP_REFERER"];
$request = ($_SERVER['REQUEST_URI']);
$get = print_r($_GET, true);
$post = print_r($_POST, true);
//die("referer=".$referer."\n<br/>"."request=".$request."\n<br/>"."get=".$get."\n<br/>"."post=".$post);
mail('sredeuil@clever-age.com;s.etheve@cap-sciences.net', '[SERVERVIP] interactif null', "referer=".$referer."\n<br/>"."request=".$request."get=".$get."\n<br/>"."post=".$post);
}
*/
}
}
$this->setIsTosync(1);
parent::save($conn);
}
public function configure()
{
unset($this['updated_at'], $this['created_at'], $this['visiteur_list'], $this['is_tosync']);
$this->validatorSchema->setOption('allow_extra_fields', true);
$this->validatorSchema->setOption('filter_extra_fields', false);
$this->setValidator('guid', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('guid', Guid::generate());
$this->getValidator('libelle')->setOption('required', true);
$count = '';
if ($this->isNew()) {
$univers = Doctrine_Query::create()->from('Univers')->limit(1)->orderBy('libelle asc')->fetchOne();
if ($univers) {
$count = $univers->getMedaille()->count();
}
} else {
if ($this->getObject()->getUniversId()) {
$count = $this->getObject()->getUnivers()->getMedaille()->count();
}
}
$this->setWidget('gain_id', new sfWidgetFormDoctrineChoice(array('model' => 'Gain', 'order_by' => array('libelle', 'asc'), 'add_empty' => true)));
$this->getWidgetSchema()->moveField('gain_id', sfWidgetFormSchema::AFTER, 'univers_id');
$this->setValidator('gain_id', new sfValidatorDoctrineChoice(array('model' => 'Gain', 'column' => 'guid', 'required' => false)));
$this->getWidget('univers_id')->setOption('order_by', array('libelle', 'asc'));
$this->getWidget('level')->setDefault('1');
$this->getWidget('level')->setAttribute('style', 'width:40px');
$this->getWidget('nb_medaille')->setAttribute('style', 'width:40px');
if (!$this->isNew()) {
$this->widgetSchema['image1'] = new sfWidgetFormInputFileEditable(array('label' => 'Image 1', 'delete_label' => 'Supprimer le fichier ?', 'file_src' => '/univers_status/' . $this->getObject()->getImage1(), 'is_image' => true, 'edit_mode' => !$this->isNew(), 'template' => '<div>%file%<br />%input%<br />%delete_label% %delete%</div>'));
$this->validatorSchema['image1'] = new sfValidatorFile(array('required' => false, 'path' => sfConfig::get('sf_web_dir') . "/univers_status/", 'mime_types' => array('image/jpeg', 'image/png', 'image/jpg')), array('invalid' => 'Please select only a jpeg or png file for upload.', 'required' => 'Select a file to upload.', 'mime_types' => 'The file must be a png / jpeg file .'));
$this->widgetSchema['image2'] = new sfWidgetFormInputFileEditable(array('label' => 'Image 2', 'delete_label' => 'Supprimer le fichier ?', 'file_src' => '/univers_status/' . $this->getObject()->getImage2(), 'is_image' => true, 'edit_mode' => !$this->isNew(), 'template' => '<div>%file%<br />%input%<br />%delete_label% %delete%</div>'));
$this->validatorSchema['image2'] = new sfValidatorFile(array('required' => false, 'path' => sfConfig::get('sf_web_dir') . "/univers_status/", 'mime_types' => array('image/jpeg', 'image/png', 'image/jpg')), array('invalid' => 'Please select only a jpeg or png file for upload.', 'required' => 'Select a file to upload.', 'mime_types' => 'The file must be a png / jpeg file .'));
$this->widgetSchema['image3'] = new sfWidgetFormInputFileEditable(array('label' => 'Image 3', 'delete_label' => 'Supprimer le fichier ?', 'file_src' => '/univers_status/' . $this->getObject()->getImage3(), 'is_image' => true, 'edit_mode' => !$this->isNew(), 'template' => '<div>%file%<br />%input%<br />%delete_label% %delete%</div>'));
$this->validatorSchema['image3'] = new sfValidatorFile(array('required' => false, 'path' => sfConfig::get('sf_web_dir') . "/univers_status/", 'mime_types' => array('image/jpeg', 'image/png', 'image/jpg')), array('invalid' => 'Please select only a jpeg or png file for upload.', 'required' => 'Select a file to upload.', 'mime_types' => 'The file must be a png / jpeg file .'));
} else {
unset($this->widgetSchema['image1']);
unset($this->widgetSchema['image2']);
unset($this->widgetSchema['image3']);
}
}
public static function createLogVisite($visiteur_id, $score, $contexte_id, $visite_id = null, $interactif_id = null, $exposition_id = null)
{
$log_visite = new LogVisite();
$log_visite->setGuid(Guid::generate());
$log_visite->setVisiteurId($visiteur_id);
$log_visite->setContexteId($contexte_id);
if ($interactif_id != null) {
$log_visite->setInteractifId($interactif_id);
} else {
$log_visite->setInteractif(null);
$log_visite->setInteractifId(null);
}
if ($visite_id != null) {
$log_visite->setVisiteId($visite_id);
}
if ($exposition_id != null) {
$log_visite->setExpositionId($exposition_id);
}
$log_visite->setScore($score);
$log_visite->save();
return $log_visite->getGuid();
}
public function configure()
{
$this->validatorSchema->setOption('allow_extra_fields', true);
$this->validatorSchema->setOption('filter_extra_fields', false);
unset($this['updated_at'], $this['created_at'], $this['is_tosync'], $this['visiteur_list']);
$this->setValidator('guid', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('guid', Guid::generate());
$this->setWidget('start_at', new sfWidgetFormJqueryDateVip(array('empty_values' => array('year' => '', 'month' => '', 'day' => ''), 'can_be_empty' => true)));
$this->setWidget('end_at', new sfWidgetFormJqueryDateVip(array('empty_values' => array('year' => '', 'month' => '', 'day' => ''), 'can_be_empty' => true)));
$this->validatorSchema->setPostValidator(new sfValidatorOr(array(new sfValidatorAnd(array(new sfValidatorSchemaCompare('start_at', sfValidatorSchemaCompare::NOT_EQUAL, null), new sfValidatorSchemaCompare('end_at', sfValidatorSchemaCompare::EQUAL, null))), new sfValidatorSchemaCompare('start_at', sfValidatorSchemaCompare::LESS_THAN_EQUAL, 'end_at', array('throw_global_error' => false), array('invalid' => 'The start date ("%left_field%") must be before the end date ("%right_field%")')))));
if (!$this->isNew()) {
$this->widgetSchema['image'] = new sfWidgetFormInputFileEditable(array('label' => 'Image', 'delete_label' => 'Supprimer le fichier ?', 'file_src' => '/gain/' . $this->getObject()->getImage(), 'is_image' => true, 'edit_mode' => !$this->isNew(), 'template' => '<div>%file%<br />%input%<br />%delete_label% %delete%</div>'));
$this->validatorSchema['image'] = new sfValidatorFile(array('required' => false, 'path' => sfConfig::get('sf_web_dir') . "/gain/", 'mime_types' => array('image/jpeg', 'image/png', 'image/jpg')), array('invalid' => 'Please select only a jpeg or png file for upload.', 'required' => 'Select a file to upload.', 'mime_types' => 'The file must be a png / jpeg file .'));
//$this->widgetSchema['image_delete'] = new sfWidgetFormInputCheckbox(array('value_attribute_value'=> 'on') );
//$this->validatorSchema['image_delete'] = new sfValidatorString();
} else {
unset($this->widgetSchema['image']);
}
$this->setWidget('send_email_visiteur_template_id', new sfWidgetFormDoctrineChoice(array('model' => 'TemplateMail', 'order_by' => array('key_search', 'asc'), 'add_empty' => true)));
$this->setWidget('send_email_admin_template_id', new sfWidgetFormDoctrineChoice(array('model' => 'TemplateMail', 'order_by' => array('key_search', 'asc'), 'add_empty' => true)));
$this->setValidator('send_email_visiteur_template_id', new sfValidatorDoctrineChoice(array('model' => 'TemplateMail', 'column' => 'guid', 'required' => false)));
$this->setValidator('send_email_admin_template_id', new sfValidatorDoctrineChoice(array('model' => 'TemplateMail', 'column' => 'guid', 'required' => false)));
}
protected function doSave()
{
if ($this->object->getGuid() == "" || $this->object->getGuid() == null) {
$this->object->setGuid(Guid::generate());
}
$this->object->save();
Resque::enqueue('default', 'Job_Typologie', array("visiteur_id" => $this->object->getVisiteurId()));
$this->getRequest()->setParameter('visiteur_id', $this->object->getVisiteurId());
$this->getRequest()->setParameter('typologie_id', $this->object->getTypologieId());
$this->getRequest()->setMethod("GET");
//return $this->redirect($this->getController()->genUrl('?visiteur_id='.$this->object->getVisiteurId()."&typologie_id=".$this->object->getTypologieId()));
return $this->forward("xp", "index");
}
protected function createObject()
{
$object = new $this->model();
$object->setGuid(Guid::generate());
return $object;
}
/**
* Constructor for Territories
*/
public function __construct($uri = "")
{
$this->_objectID = Guid::NewGuid();
$this->_baseURI = $uri;
$this->_entityMap['Region'] = 'Region';
$this->_entityMap['Employees'] = 'Employees';
$this->_entityKey[] = 'TerritoryID';
$this->Region = array();
$this->Employees = array();
}
public function Tables($uri = "")
{
$this->_objectID = Guid::NewGuid();
$this->_baseURI = $uri;
}
function createGuid()
{
$guid = new Guid();
return $guid->toString();
}
/**
* PrinceObject constructor.
* @param $guid
*/
public function __construct()
{
$this->guid = Guid::generate();
}
public function configure()
{
unset($this['updated_at'], $this['created_at'], $this['is_tosync']);
$this->setValidator('guid', new sfValidatorString(array('max_length' => 255, 'required' => false)));
$this->setDefault('guid', Guid::generate());
}
/**
* Constructor for sysdiagrams
*/
public function __construct($uri = "")
{
$this->_objectID = Guid::NewGuid();
$this->_baseURI = $uri;
$this->_entityKey[] = 'diagram_id';
}
