Exemplo n.º 1
0
 protected function validateUniqueValue()
 {
     if (!isset($this->form->saveresult) || $this->form->saveresult != 1) {
         return true;
     }
     //validate unique field value in database
     if (isset($this->field->uniquevaluesonly) && $this->field->uniquevaluesonly == 1) {
         //get values of all recordsets in datatable
         $details = array();
         $db = JFactory::getDbO();
         if (isset($this->field->id) && is_numeric($this->field->id)) {
             $query = ' SELECT F' . $this->field->id . ' FROM #__visforms_' . $this->form->id;
             $db->setQuery($query);
             $details = $db->loadColumn();
         }
         //check if there is a match
         if (in_array($this->field->dbValue, $details)) {
             $this->field->isValid = false;
             $app = JFactory::getApplication();
             $app->enqueueMessage(JText::sprintf('COM_VISFORMS_UNIQUE_VALUE_REQUIRED', $this->field->label, $this->field->dbValue));
             return false;
         }
     }
     return true;
 }
Exemplo n.º 2
0
 public static function getPriceDisplayMethod($group_id)
 {
     if (!isset(JeproshopGroupModelGroup::$group_price_display_method[$group_id])) {
         $db = JFactory::getDbO();
         $query = "SELECT " . $db->quoteName('price_display_method') . " FROM " . $db->quoteName('#__jeproshop_group');
         $query .= " WHERE " . $db->quoteName('group_id') . " = " . (int) $group_id;
         $db->setQuery($query);
         self::$group_price_display_method[$group_id] = $db->loadResult();
     }
     return self::$group_price_display_method[$group_id];
 }
Exemplo n.º 3
0
 /**
  * Method to get the form
  * @return object with data
  * @since        Joomla 1.6
  */
 function getForm()
 {
     $db = JFactory::getDbO();
     $query = ' SELECT * FROM #__visforms ' . '  WHERE id = ' . $this->_id;
     $db->setQuery($query);
     $form = $db->loadObject();
     $registry = new JRegistry();
     //Convert frontendsettings field to an array
     $registry->loadString($form->frontendsettings);
     $form->frontendsettings = $registry->toArray();
     foreach ($form->frontendsettings as $name => $value) {
         //make names shorter and set all frontendsettings as properties of form object
         $form->{$name} = $value;
     }
     return $form;
 }
Exemplo n.º 4
0
 /**
  * TuiyoModelProfile::getUserAvatars()
  * [OBSULATE!!]
  * @return
  */
 public function getUserAvatars()
 {
     $user = JFactory::getUser();
     $dbo = JFactory::getDbO();
     $query = "SELECT r.resourceID as id, r.url, r.fileTitle as title" . "\nFROM #__tuiyo_resources r" . "\nWHERE r.contentType='AVATAR' AND r.userID =" . $dbo->Quote((int) $user->id);
     $dbo->setQuery($query);
     //echo $dbo->getQuery();
     return (array) $dbo->loadAssocList();
 }