PHP DatsoCategories::checkの例

コード例 #1

ファイル: datso.usercategory.php プロジェクト: j0rg3m414/centerar

function saveCatg()
{
    require JPATH_COMPONENT_ADMINISTRATOR . DS . 'config.datsogallery.php';
    $is_admin = array(7, 8);
    $db = JFactory::getDBO();
    $user = JFactory::getUser();
    $userGroups = JAccess::getGroupsByUser($user->id, true);
    $post = JRequest::get('post');
    //$post['description'] = JRequest::getVar('description', '', 'post', 'string', JREQUEST_ALLOWRAW);
    $row = new DatsoCategories($db);
    if (!array_intersect($is_admin, $userGroups)) {
        $category = explode(',', $ad_category);
        $getfirst = array_shift($category);
        $db->setQuery('SELECT cid' . ' FROM #__datsogallery_catg' . ' WHERE user_id = ' . (int) $user->id . ' AND parent = ' . $ad_category);
        $result = $db->loadResult();
        $row->parent = $result ? $result : $ad_category;
        $row->ordering = $row->getNextOrder('parent = ' . $row->parent);
    } else {
        $row->ordering = $row->getNextOrder('parent = 0');
    }
    $row->user_id = $user->id;
    $row->approved = !$user_categories_approval || array_intersect($is_admin, $userGroups) ? 1 : 0;
    $row->published = 1;
    jimport('joomla.utilities.date');
    $dtz = new DateTimeZone(JFactory::getApplication()->getCfg('offset'));
    $date = new JDate($row->date);
    $date->setTimezone($dtz);
    $row->date = $date->toMySQL(true);
    if (!$row->bind($post)) {
        JError::raiseError(500, $row->getError());
    }
    if (!$row->check()) {
        JError::raiseError(500, $row->getError());
    }
    if (!$row->store()) {
        JError::raiseError(500, $row->getError());
    }
    if ($ad_category_notify && !array_intersect($is_admin, $userGroups)) {
        categoryNotify($user->username, $post['name']);
    }
}

コード例 #2

ファイル: admin.datsogallery.php プロジェクト: j0rg3m414/centerar

function saveCatg()
{
    $app = JFactory::getApplication('administrator');
    $db = JFactory::getDBO();
    $user = JFactory::getUser();
    $post = JRequest::get('post');
    $query = 'SELECT ordering, user_id, date' . ' FROM #__datsogallery_catg' . ' WHERE cid = ' . $post['cid'];
    $db->setQuery($query);
    $obj = $db->loadObject();
    $post['description'] = JRequest::getVar('description', '', 'post', 'string', JREQUEST_ALLOWRAW);
    $row = new DatsoCategories($db);
    if (!$post['cid'] || $obj->ordering == 0) {
        $row->ordering = $row->getNextOrder('parent = ' . $post['parent']);
        $row->approved = 1;
    }
    if ($obj->user_id == 0) {
        $row->user_id = $user->id;
    }
    if (!$obj->date) {
        jimport('joomla.utilities.date');
        $dtz = new DateTimeZone(JFactory::getApplication()->getCfg('offset'));
        $date = new JDate($row->date);
        $date->setTimezone($dtz);
        $row->date = $date->toMySQL(true);
    }
    if (!$row->bind($post)) {
        JError::raiseError(500, $row->getError());
    }
    if (!$row->check()) {
        JError::raiseError(500, $row->getError());
    }
    if (!$row->store()) {
        JError::raiseError(500, $row->getError());
    }
    $app->redirect("index.php?option=com_datsogallery&task=showcatg");
}

コード例 #3

ファイル: datso.functions.php プロジェクト: j0rg3m414/centerar

function createNewMemberAlbum()
{
    require JPATH_COMPONENT_ADMINISTRATOR . DS . 'config.datsogallery.php';
    $is_admin = array(7, 8);
    $db = JFactory::getDBO();
    $user = JFactory::getUser();
    $userGroups = JAccess::getGroupsByUser($user->id, true);
    $row = new DatsoCategories($db);
    if (!array_intersect($is_admin, $userGroups) && $user_categories) {
        $db->setQuery('SELECT cid' . ' FROM #__datsogallery_catg' . ' WHERE user_id = ' . $user->id . ' AND parent = ' . $ad_category);
        $result = $db->loadResult();
        if (!$result) {
            $row->name = $user->name;
            $row->description = JText::sprintf('COM_DATSOGALLERY_NEW_ALBUM_DESC', $user->name);
            $row->parent = $ad_category;
            $row->ordering = $row->getNextOrder('parent = ' . $row->parent);
            $row->user_id = $user->id;
            $row->approved = 1;
            $row->published = 1;
            jimport('joomla.utilities.date');
            $dtz = new DateTimeZone(JFactory::getApplication()->getCfg('offset'));
            $date = new JDate($row->date);
            $date->setTimezone($dtz);
            $row->date = $date->toMySQL(true);
            if (!$row->check()) {
                JError::raiseError(500, $row->getError());
            }
            if (!$row->store()) {
                JError::raiseError(500, $row->getError());
            }
        }
    }
}