I need to combine these 2 Functions so I can press one button and it does both.
function approve()
{
/* Ðó÷íîå äîáîâëåíèå (îäîáðåíèå) çàêàçà, ãëàâíîå ÷òî áû ñòàòóñ èìåë 'pending' çíà÷åíèå
*/
JRequest::checkToken() or jexit( 'Invalid Token' );
/* Ïîëó÷àåì ìàññèâ ñî çíà÷åíèÿìè
*/
$cid = JRequest::getVar( 'cid', array(), 'post', 'array' );
/* Ïðîâåðÿåì ÷òî ìàññèâ íå ïóñòîé
*/
if(empty($cid))
{
return JError::raiseWarning( 500, JText::_( 'No items selected' ) );
}
JArrayHelper::toInteger( $cid );
$cids = implode( ',', $cid );
/* Ïîëó÷àåì ìàññèâ èç âûáðàííûõ ïóíêòîâ
*/
$this->_db->setQuery( "SELECT * FROM #__roxsuite_membership_history WHERE `published` = '0' AND `status` = 'pending' AND `id` IN (". $cids .")" );
$data = $this->_db->loadObjectList();
/* Ïðîâåðÿåì ÷òî ìàññèâ íå ïóñòîé
*/
if(is_array($data) and count($data))
{
/* Ïîäêëþ÷àåì êëàññ äëÿ îòïðàâêè ñîîáùåíèÿ
*/
include_once ( JPATH_COMPONENT . DS .'helpers'. DS .'sendmail.php' );
$sendmail = new RoxSuiteMembershipSendMail();
foreach($data as $row)
{
/* Îòïðàâëÿåì ñîîáùåíèå î ïðîâåðêå ïîêóïêè
*/
$sendmail->sendMessage($row, 'approval');
/* Îäîáðÿåì ïîêóïêó
*/
$this->_db->setQuery( "UPDATE #__roxsuite_membership_history SET `status` = 'complete', `block` = '0' WHERE `id` = '". $row->id ."'" );
$this->_db->query();
}
}
$this->setMessage( JText::_( 'Items approved' ) );
$this->setRedirect( 'index.php?option=com_roxsuite_membership&view=transactions' );
}
function enable()
{
/* Ðó÷íîå âêëþ÷åíèå çàêàçà, ãëàâíîå ÷òî áû ñòàòóñ èìåë 'complete' çíà÷åíèå
*/
JRequest::checkToken() or jexit( 'Invalid Token' );
/* Ïîëó÷àåì ìàññèâ ñî çíà÷åíèÿìè
*/
$cid = JRequest::getVar( 'cid', array(), 'post', 'array' );
/* Ïðîâåðÿåì ÷òî ìàññèâ íå ïóñòîé
*/
if(empty($cid))
{
return JError::raiseWarning( 500, JText::_( 'No items selected' ) );
}
JArrayHelper::toInteger( $cid );
$cids = implode( ',', $cid );
/* Ïîëó÷àåì ìàññèâ èç âûáðàííûõ ïóíêòîâ
*/
$this->_db->setQuery( "SELECT * FROM #__roxsuite_membership_history WHERE `block` = '1' AND `status` = 'complete' AND `id` IN (". $cids .")" );
$data = $this->_db->loadObjectList();
/* Ïðîâåðÿåì ÷òî ìàññèâ íå ïóñòîé
*/
if(is_array($data) and count($data))
{
foreach($data as $row)
{
/* Èçìåíÿåì çíà÷åíèÿ
*/
$this->_db->setQuery( "UPDATE #__roxsuite_membership_history SET `block` = '0' WHERE `id` = '". $row->id ."'" );
$this->_db->query();
}
}
$this->setRedirect( 'index.php?option=com_roxsuite_membership&view=transactions' );
}
I also need it to call to a different table and update a value there as well.
I assume it would be this:
$this->_db->setQuery( "UPDATE #__jrleech SET `published` = '1' WHERE `id` = '". $row->id ."'" );