Created
May 22, 2014 12:51
-
-
Save omostan/2dd017f8817d8dde431f to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/** | |
* @version 1.0.0 | |
* @package com_COMPONENTNAME | |
* @copyright Copyright (C) 2012. All rights reserved. | |
* @license GNU General Public License version 2 or later; see LICENSE.txt | |
* @author TCM Services <admin@tcmsvc.net> - http://www.tcmsvc.net | |
*/ | |
// No direct access | |
defined('_JEXEC') or die; | |
/** | |
* contractor Table class | |
*/ | |
class COMPONENTNAMETableTABLENAME extends JTable | |
{ | |
/** | |
* Constructor | |
* | |
* @param JDatabase A database connector object | |
*/ | |
public function __construct(&$db) | |
{ | |
parent::__construct('#__COMPONENTNAME_TABLENAME', 'id', $db); | |
} | |
/** | |
* Overloaded bind function to pre-process the params. | |
* | |
* @param array Named array | |
* @return null|string null is operation was satisfactory, otherwise returns an error | |
* @see JTable:bind | |
* @since 1.5 | |
*/ | |
public function bind($array, $ignore = '') | |
{ | |
if (isset($array['params']) && is_array($array['params'])) { | |
$registry = new JRegistry(); | |
$registry->loadArray($array['params']); | |
$array['params'] = (string) $registry; | |
} | |
if (isset($array['metadata']) && is_array($array['metadata'])) { | |
$registry = new JRegistry(); | |
$registry->loadArray($array['metadata']); | |
$array['metadata'] = (string) $registry; | |
} | |
//Bind the rules for ACL where supported. | |
if (isset($array['rules']) && is_array($array['rules'])) { | |
$rules = new JRules($array['rules']); | |
$this->setRules($rules); | |
} | |
return parent::bind($array, $ignore); | |
} | |
/** | |
* Overloaded check function | |
*/ | |
public function check() | |
{ | |
//If there is an ordering column and this is a new row then get the next ordering value | |
if (property_exists($this, 'ordering') && $this->id == 0) { | |
$this->ordering = self::getNextOrder(); | |
} | |
return parent::check(); | |
} | |
/** | |
* Method to set the publishing state for a row or list of rows in the database | |
* table. The method respects checked out rows by other users and will attempt | |
* to checkin rows that it can after adjustments are made. | |
* | |
* @param mixed An optional array of primary key values to update. If not | |
* set the instance property value is used. | |
* @param integer The publishing state. eg. [0 = unpublished, 1 = published] | |
* @param integer The user id of the user performing the operation. | |
* @return boolean True on success. | |
* @since 1.0.4 | |
*/ | |
public function publish($pks = null, $state = 1, $userId = 0) | |
{ | |
// Initialise variables. | |
$k = $this->_tbl_key; | |
// Sanitize input. | |
JArrayHelper::toInteger($pks); | |
$userId = (int) $userId; | |
$state = (int) $state; | |
// If there are no primary keys set check to see if the instance key is set. | |
if (empty($pks)) { | |
if ($this->$k) { | |
$pks = array($this->$k); | |
} | |
// Nothing to set publishing state on, return false. | |
else { | |
$this->setError(JText::_('JLIB_DATABASE_ERROR_NO_ROWS_SELECTED')); | |
return false; | |
} | |
} | |
// Build the WHERE clause for the primary keys. | |
$where = $k . '=' . implode(' OR ' . $k . '=', $pks); | |
// Determine if there is checkin support for the table. | |
if (!property_exists($this, 'checked_out') || !property_exists($this, 'checked_out_time')) { | |
$checkin = ''; | |
} else { | |
$checkin = ' AND (checked_out = 0 OR checked_out = ' . (int) $userId . ')'; | |
} | |
// Update the publishing state for rows with the given primary keys. | |
$this->_db->setQuery( | |
'UPDATE `' . $this->_tbl . '`' . | |
' SET `state` = ' . (int) $state . | |
' WHERE (' . $where . ')' . | |
$checkin | |
); | |
$this->_db->query(); | |
// Check for a database error. | |
if ($this->_db->getErrorNum()) { | |
$this->setError($this->_db->getErrorMsg()); | |
return false; | |
} | |
// If checkin is supported and all rows were adjusted, check them in. | |
if ($checkin && (count($pks) == $this->_db->getAffectedRows())) { | |
// Checkin each row. | |
foreach ($pks as $pk) { | |
$this->checkin($pk); | |
} | |
} | |
// If the JTable instance value is in the list of primary keys that were set, set the instance. | |
if (in_array($this->$k, $pks)) { | |
$this->state = $state; | |
} | |
$this->setError(''); | |
return true; | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment