/**
* Validate a slug
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 4.0
*/
private function _validateSlug()
{
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
// Create the slug
$this->slug = Com_virtuemart::createSlug($this->category_name);
// Check if the slug exists
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('COUNT(' . $db->Quote($this->_tbl_key) . ')');
$query->from($this->_tbl);
$query->where($db->quoteName('slug') . ' = ' . $db->Quote($this->slug));
$db->setQuery($query);
$slugs = $db->loadResult();
$csvilog->addDebug(JText::_('COM_CSVI_CHECK_CATGEGORY_SLUG'), true);
if ($slugs > 0) {
$jdate = JFactory::getDate();
$this->slug .= $jdate->format("Y-m-d-h-i-s") . mt_rand();
}
}
/**
* Create a slug if needed and store the product
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 4.0
*/
public function store()
{
if (empty(${$this}->_tbl_key)) {
// Create the slug
$this->slug = Com_virtuemart::createSlug($this->mf_category_name);
}
return parent::store();
}
/**
* Validate a slug
*
* @copyright
* @author RolandD
* @todo
* @see
* @access public
* @param
* @return
* @since 4.0
*/
public function createSlug()
{
$jinput = JFactory::getApplication()->input;
$csvilog = $jinput->get('csvilog', null, null);
// Create the slug
$this->slug = Com_virtuemart::createSlug($this->product_name);
// Check if the slug exists
$db = JFactory::getDbo();
$query = $db->getQuery(true)->select('COUNT(' . $db->qn($this->_tbl_key) . ')')->from($this->_tbl)->where($db->qn('slug') . ' = ' . $db->q($this->slug))->where($db->qn($this->_tbl_key) . ' != ' . $db->q($this->virtuemart_product_id));
$db->setQuery($query);
$slugs = $db->loadResult();
$csvilog->addDebug(JText::_('COM_CSVI_CHECK_PRODUCT_SLUG'), true);
if ($slugs > 0) {
$jdate = JFactory::getDate();
$this->slug .= $jdate->format("Y-m-d-h-i-s") . mt_rand();
}
}
