/** * Method to get the next ordering value for a group of rows defined by an SQL WHERE clause. * This is useful for placing a new item last in a group of items in the table. * * @param string $where WHERE clause to use for selecting the MAX(ordering) for the table. * * @return mixed Boolean false an failure or the next ordering value as an integer. * * @link http://docs.joomla.org/JTable/getNextOrder * @since 11.1 */ public function getNextOrder($where = '') { // If there is no ordering field set an error and return false. if (!property_exists($this, 'ordering')) { $e = new JException(JText::sprintf('JLIB_DATABASE_ERROR_CLASS_DOES_NOT_SUPPORT_ORDERING', get_class($this))); $this->setError($e); return false; } // Get the largest ordering value for a given where clause. $query = $this->_db->getQuery(true); $query->select('MAX(ordering)'); $query->from($this->_tbl); if ($where) { $query->where($where); } $this->_db->setQuery($query); $max = (int) $this->_db->loadResult(); // Check for a database error. if ($this->_db->getErrorNum()) { $e = new JException(JText::sprintf('JLIB_DATABASE_ERROR_GET_NEXT_ORDER_FAILED', get_class($this), $this->_db->getErrorMsg())); $this->setError($e); return false; } // Return the largest ordering value + 1. return $max + 1; }
/** * Count items. * * @return int */ public function count() { $query = clone $this->query; $this->build($query); $query->select('COUNT(*)'); $this->db->setQuery($query); $count = (int) $this->db->loadResult(); KunenaError::checkDatabaseError(); return $count; }
/** * Returns the ordering value to place a new item last in its group * * @access public * @param string query WHERE clause for selecting MAX(ordering). */ function getNextOrder($where = '') { if (!in_array('ordering', array_keys($this->getProperties()))) { $this->setError(get_class($this) . ' does not support ordering'); return false; } $query = 'SELECT MAX(ordering)' . ' FROM ' . $this->_tbl . ($where ? ' WHERE ' . $where : ''); $this->_db->setQuery($query); $maxord = $this->_db->loadResult(); if ($this->_db->getErrorNum()) { $this->setError($this->_db->getErrorMsg()); return false; } return $maxord + 1; }
/** * Controlla l'esistenza di un indice in una tabella * @param string $tablename * @param string indexname * @return boolean TRUE se esiste, FALSE se non esiste */ public function indexExists($tablename, $indexname) { $q = "SHOW INDEX FROM `" . $this->replacePrefix($tablename) . "` WHERE Key_name='" . $indexname . "'"; $this->db->setQuery($q); return $this->db->loadResult() != null; }
/** * This method loads the first field of the first row returned by the query. * * @return string|null The value returned in the query or null if the query failed. * * @throws \RuntimeException */ public function loadResult() { return $this->_db->loadResult(); }
public function getPagination($total = null) { if (empty($total)) { $this->db->setQuery('SELECT count(*)' . ' FROM #__acctexp_' . $this->table . $this->getConstraints()); $total = $this->db->loadResult(); } return new bsPagination($total, $this->state->limitstart, $this->state->limit); }
/** * Execute a query to the database and load the result returned * * The result returned by this method is the same as the one returned by JDatabase::loadResult() * Basically, it returns the result (single field) of a database operation * Generally used for SELECT field operations * * @param string $query The query to be executed * * @return mixed The result of the query * * @throws RuntimeException * * @since 1.0.0 */ public function queryResult($query) { // query database table $this->_database->setQuery($query); return $this->_database->loadResult(); }
public function listRecords() { JToolBarHelper::title('<img src="'. JURI::root() . 'administrator/components/com_breezingforms/libraries/jquery/themes/easymode/i/logo-breezingforms.png'.'" align="top"/>'); JToolBarHelper::custom('exportPdf', 'ff_download', 'ff_download_f2', BFText::_('COM_BREEZINGFORMS_PDF'), false); JToolBarHelper::custom('exportCsv', 'ff_download', 'ff_download_f2', BFText::_('COM_BREEZINGFORMS_CSV'), false); JToolBarHelper::custom('exportXml', 'ff_download', 'ff_download_f2', BFText::_('COM_BREEZINGFORMS_XML'), false); JToolBarHelper::custom('remove', 'delete.png', 'delete_f2.png', BFText::_('COM_BREEZINGFORMS_TOOLBAR_DELETE'), false); JToolBarHelper::custom('all', 'ff_switch', 'ff_switch_f2', BFText::_('COM_BREEZINGFORMS_ALL'), false); JToolBarHelper::custom('viewed', 'ff_switch', 'ff_switch_f2', BFText::_('COM_BREEZINGFORMS_TOOLBAR_VIEWED'), false); JToolBarHelper::custom('exported', 'ff_switch', 'ff_switch_f2', BFText::_('COM_BREEZINGFORMS_TOOLBAR_EXPORTED'), false); JToolBarHelper::custom('archived', 'ff_switch', 'ff_switch_f2', BFText::_('COM_BREEZINGFORMS_TOOLBAR_ARCHIVED'), false); JFactory::getDocument()->addStyleDeclaration( ' .icon-32-ff_switch { background-image:url(components/com_breezingforms/images/icons/switch.png); } .icon-32-ff_switch_f2 { background-image:url(components/com_breezingforms/images/icons/switch_f2.png); } .icon-32-ff_download { background-image:url(components/com_breezingforms/images/icons/download.png); } .icon-32-ff_download_f2 { background-image:url(components/com_breezingforms/images/icons/download_f2.png); } ' ); //print_r($_REQUEST); $ids = JRequest::getVar('ids', array()); $offset = JRequest::getInt('limitstart', 0); $limit = JRequest::getInt('mylimit', 20); if(JRequest::getVar('task','') == 'all') { JFactory::getSession()->set('bfStatus', ''); } else if(JRequest::getVar('task','')=='exported') { JFactory::getSession()->set('bfStatus', 'exported'); } else if(JRequest::getVar('task','')=='archived') { JFactory::getSession()->set('bfStatus', 'archived'); } else if(JRequest::getVar('task','')=='viewed') { JFactory::getSession()->set('bfStatus', 'viewed'); } else if(JRequest::getVar('task','')=='remove') { $size = count($ids); for($i = 0; $i < $size; $i++) { $this->db->setQuery("Delete From #__facileforms_records Where id = " . $this->db->Quote($ids[$i])); $this->db->query(); $this->db->setQuery("Delete From #__facileforms_subrecords Where record = " . $this->db->Quote($ids[$i])); $this->db->query(); //echo $this->db->getQuery() . '<br/>'; } } else if(JRequest::getVar('task','')=='save') { $id = JRequest::getInt('record_id', 0); $updates = JRequest::getVar('update', array()); foreach($updates As $update) { $this->db->setQuery("Update #__facileforms_subrecords Set value = ".$this->db->Quote(JRequest::getVar('ff_nm_'.$update,''))." Where name = ".$this->db->Quote($update)." And record = " . $id); $this->db->query(); } } else if(JRequest::getVar('task','')=='exportXml' && JRequest::getInt('exportt',0) == 1) { $this->expxml($ids); } else if(JRequest::getVar('task','')=='exportCsv' && JRequest::getInt('exportt',0) == 1) { $this->expcsv($ids); } else if(JRequest::getVar('task','')=='exportPdf' && JRequest::getInt('exportt',0) == 1) { $this->exppdf($ids); } if(JRequest::getInt('status_update',0) == 1) { $offset = 0; $limit = 20; JRequest::setVar('limitstart', 0); JRequest::setVar('mylimit', 20); } if(JRequest::getInt('id', 0) != '' && JRequest::getInt('viewed', -1) != -1) { $value = 1; if(JRequest::getInt('viewed', -1) == 1) { $value = 0; } $this->db->setQuery("Update #__facileforms_records Set viewed = ".$value." Where id = " . JRequest::getInt('id', 0)); $this->db->query(); } if(JRequest::getInt('id', 0) != '' && JRequest::getInt('exported', -1) != -1) { $value = 1; if(JRequest::getInt('exported', -1) == 1) { $value = 0; } $this->db->setQuery("Update #__facileforms_records Set exported = ".$value." Where id = " . JRequest::getInt('id', 0)); $this->db->query(); } if(JRequest::getInt('id', 0) != '' && JRequest::getInt('archived', -1) != -1) { $value = 1; if(JRequest::getInt('archived', -1) == 1) { $value = 0; } $this->db->setQuery("Update #__facileforms_records Set archived = ".$value." Where id = " . JRequest::getInt('id', 0)); $this->db->query(); } if(JRequest::getInt('status_update',0) == 1 && JRequest::getVar('write_status','') != '') { $in = ''; if(is_array($ids) && count($ids) != 0) { $status = ''; if(JFactory::getSession()->get('bfStatus', '') == 'exported') { $status = "exported = ".(JRequest::getVar('write_status','') == 'set' ? 1 : 0); } else if(JFactory::getSession()->get('bfStatus', '') == 'archived') { $status = "archived = ".(JRequest::getVar('write_status','') == 'set' ? 1 : 0); } else if(JFactory::getSession()->get('bfStatus', '') == 'viewed') { $status = "viewed = ".(JRequest::getVar('write_status','') == 'set' ? 1 : 0); } if($status != '' ) { $size = count($ids); for($i = 0; $i < $size; $i++) { $this->db->setQuery("Update #__facileforms_records Set $status Where id = " . $this->db->Quote($ids[$i])); $this->db->query(); //echo $this->db->getQuery() . '<br/>'; } } } } $ands = ''; $subs = ''; if(JRequest::getVar('search','') != '') { //echo JRequest::getVar('txtsearch','false'); if(JRequest::getVar('txtsearch','false')=='true') { $subs .= ', #__facileforms_subrecords As subrecord'; $ands .= 'subrecord.value Like ' . $this->db->Quote('%'.JRequest::getVar('search','').'%') . ' And record.id = subrecord.record And '; } $headerSearch = ''; if(is_numeric(JRequest::getVar('search',''))) { $headerSearch .= 'record.id = ' . intval(JRequest::getVar('search','')) . ' Or '; } $ex = explode('-', JRequest::getVar('search','')); //print_r($ex); if(count($ex) == 3 && checkdate($ex[1], $ex[2], $ex[0])) { $headerSearch .= "record.submitted Between '" . $ex[0] . '-' . $ex[1] . '-' . $ex[2] . " 00:00:00' And '" . $ex[0] . '-' . $ex[1] . '-' . $ex[2] . " 23:59:59' Or "; $headerSearch .= "record.paypal_payment_date Between '" . $ex[0] . '-' . $ex[1] . '-' . $ex[2] . " 00:00:00' And '" . $ex[0] . '-' . $ex[1] . '-' . $ex[2] . " 23:59:59' Or "; } if(is_ip(JRequest::getVar('search',''))) { $headerSearch .= 'record.ip = ' . $this->db->Quote(JRequest::getVar('search','')) . ' Or '; } if(substr(trim(JRequest::getVar('search','')), 0,4) == 'tx: ') { $text = trim(JRequest::getVar('search','')); $text = substr($text, 3,strlen($text)); $headerSearch .= 'record.paypal_tx_id Like ' . $this->db->Quote('%'.$text) . ' Or '; } if($headerSearch == '' && JRequest::getVar('txtsearch','false')!='true') { $headerSearch .= 'record.`name` Like ' . $this->db->Quote('%'.trim(JRequest::getVar('search','')).'%') . ' Or '; } if($headerSearch != '') { $headerSearch = substr($headerSearch,0,strlen($headerSearch)-4); $ands .= "(".$headerSearch.") And "; } } if(JRequest::getInt('form',0) != 0) { $ands .= 'record.form = ' . $this->db->Quote(JRequest::getInt('form',0)) . ' And '; } if(JFactory::getSession()->get('bfStatus', '') == 'exported') { $ands .= "record.exported = 1 And"; } else if(JFactory::getSession()->get('bfStatus', '') == 'archived') { $ands .= "record.archived = 1 And"; } else if(JFactory::getSession()->get('bfStatus', '') == 'viewed') { $ands .= "record.viewed = 1 And"; } if($ands != '') { $ands = 'Where ' . substr($ands,0,strlen($ands)-4); } $limiter = " Limit $offset, $limit"; if($limit == 0) { $limiter = ''; } $this->db->setQuery("Select Distinct SQL_CALC_FOUND_ROWS record.* From #__facileforms_records As record $subs $ands Order By record.".JRequest::getWord('orderBy','submitted')." ".(JRequest::getWord('order','DESC') == 'DESC' ? 'ASC' : 'DESC').$limiter); $rows = $this->db->loadObjectList(); //echo $this->db->getQuery(); $this->db->setQuery("SELECT FOUND_ROWS();"); $foundRows = $this->db->loadResult(); jimport('joomla.html.pagination'); $pagination = new JPagination($foundRows, $offset, $limit); $this->db->setQuery("Select Distinct form As id, `name`, title From #__facileforms_records Order By title"); $forms = $this->db->loadObjectList(); $size = count($forms); $formsArray = array(); for($i = 0;$i < $size;$i++) { if(!isset($formsArray['_'.$forms[$i]->id])){ $formsArray['_'.$forms[$i]->id] = $forms[$i]; } } $forms = $formsArray; ?> <script type="text/javascript"> var bf_submitbutton = function(pressbutton) { var form = document.adminForm; switch (pressbutton) { case 'remove': case 'exportCsv': case 'exportXls': case 'exportPdf': case 'exportXml': if (form.boxchecked.value==0) { alert("<?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_PLSSELECTRECS'); ?>"); return; } // if form.exportt.value = 1; break; case 'viewed': case 'exported': case 'archived': var writeStatus = false; for(var i = 0; i < form.write_status.length; i++) { if(form.write_status[i].checked && (form.write_status[i].value == 'set' || form.write_status[i].value == 'unset')) { writeStatus = true; break; } } if (writeStatus && form.boxchecked.value==0) { alert("<?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_PLSSELECTRECS'); ?>"); return; } // if form.status_update.value = 1; break; default: break; } // switch switch (pressbutton) { case 'remove': if (!confirm("<?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_ASKDELETE'); ?>")) return; break; default: break; } // switch submitform(pressbutton); form.exportt.value = 0; }; // submitbutton if(typeof Joomla != "undefined"){ Joomla.submitbutton = bf_submitbutton; }else{ submitbutton = bf_submitbutton; } function bf_listItemTask( id, task ) { var f = document.adminForm; cb = eval( 'f.' + id ); if (cb) { for (i = 0; true; i++) { cbx = eval('f.cb'+i); if (!cbx) break; cbx.checked = false; } // for cb.checked = true; f.boxchecked.value = 1; submitbutton(task); } return false; } // listItemTask </script> <form action="index.php" method="post" name="adminForm"> <div id="editcell"> <table class="adminlist"> <thead> <tr> <td valign="top" colspan="1000"> <table class="adminlist" width="100%"> <thead> <tr> <td> <?php echo BFText::_('COM_BREEZINGFORMS_FILTER'); ?>: <input type="text" name="search" value="<?php echo htmlentities(JRequest::getVar('search',''),ENT_QUOTES, 'UTF-8'); ?>" onchange="form.status_update.value = 1;document.adminForm.submit()"/> <?php echo BFText::_('COM_BREEZINGFORMS_TEXT'); ?>: <input type="checkbox" name="txtsearch" onclick="form.status_update.value = 1;document.adminForm.submit()" value="true"<?php echo JRequest::getWord('txtsearch','false') == 'true' ? ' checked="checked"' : ''; ?>/> <select name="form" onchange="form.status_update.value = 1;document.adminForm.submit()"> <option value=""><?php echo BFText::_('COM_BREEZINGFORMS_ALL'); ?></option> <?php foreach($forms As $form) { if(trim($form->name) != '') { echo '<option value="'.$form->id.'"'.(JRequest::getInt('form',0) == $form->id ? ' selected="selected"' : '').'>'.htmlentities($form->title, ENT_QUOTES, 'UTF-8').' ('.htmlentities($form->name, ENT_QUOTES, 'UTF-8').')</option>'."\n"; } } ?> </select> </td> <td align="right" valign="top"> <?php echo BFText::_('COM_BREEZINGFORMS_WRITE_STATUS'); ?>: <input type="radio" name="write_status" value=""<?php echo JRequest::getVar('write_status','') == '' ? ' checked="checked"' : ''; ?>/> <?php echo BFText::_('COM_BREEZINGFORMS_NONE'); ?> <input type="radio" name="write_status" value="unset"<?php echo JRequest::getVar('write_status','') == 'unset' ? ' checked="checked"' : ''; ?>/> <?php echo BFText::_('COM_BREEZINGFORMS_UNSET'); ?> <input type="radio" name="write_status" value="set"<?php echo JRequest::getVar('write_status','') == 'set' ? ' checked="checked"' : ''; ?>/> <?php echo BFText::_('COM_BREEZINGFORMS_SET'); ?> </td> </tr> </thead> </table> </td> </tr> <tr> <th nowrap align="center"><input type="checkbox" name="toggle" value="" onclick="checkAll(<?php echo count($rows); ?>);" /></th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=id"><?php echo BFText::_('COM_BREEZINGFORMS_ID'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=submitted"><?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_SUBMITTED'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=ip"><?php echo BFText::_('COM_BREEZINGFORMS_IP'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=provider"><?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_PROVIDER'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=title"><?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_TITLE'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=name"><?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_NAME'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=paypal_tx_id"><?php echo BFText::_('COM_BREEZINGFORMS_PAYMENT_TX_ID'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=paypal_payment_date"><?php echo BFText::_('COM_BREEZINGFORMS_PAYMENT_TX_DATE'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=paypal_testaccount"><?php echo BFText::_('COM_BREEZINGFORMS_PAYMENT_TESTACCOUNT'); ?></a> </th> <th> <a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&order=<?php echo JRequest::getVar('order', 'DESC') == 'DESC' ? 'ASC' : 'DESC'; ?>&orderBy=paypal_download_tries"><?php echo BFText::_('COM_BREEZINGFORMS_PAYMENT_DOWNLOAD_TRIES'); ?></a> </th> <th nowrap align="center"><?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_VIEWED'); ?></th> <th nowrap align="center"><?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_EXPORTED'); ?></th> <th nowrap align="center"><?php echo BFText::_('COM_BREEZINGFORMS_RECORDS_ARCHIVED'); ?></th> </tr> </thead> <?php $k = 0; $cnt = count( $rows ); for ($i=0; $i < $cnt; $i++) { $row = $rows[$i]; if ($row->viewed) $view_src = "components/com_breezingforms/images/icons/publish_g.png"; else $view_src = "components/com_breezingforms/images/icons/publish_x.png"; if ($row->exported) $exp_src = "components/com_breezingforms/images/icons/publish_g.png"; else $exp_src = "components/com_breezingforms/images/icons/publish_x.png"; if ($row->archived) $arch_src = "components/com_breezingforms/images/icons/publish_g.png"; else $arch_src = "components/com_breezingforms/images/icons/publish_x.png"; ?> <tr class="<?php echo "row$k"; ?>"> <td nowrap align="center"><input type="checkbox" id="cb<?php echo $i; ?>" name="ids[]" value="<?php echo $row->id; ?>" onclick="isChecked(this.checked);" /></td> <td nowrap align="left"><a href="#" onclick="return listItemTask('cb<?php echo $i; ?>','edit')"><?php echo $row->id; ?></a></td> <td nowrap align="left"><a href="#" onclick="return listItemTask('cb<?php echo $i; ?>','edit')"><?php echo $row->submitted; ?></a></td> <td nowrap align="left"><?php echo $row->ip; ?></td> <td nowrap align="left"><?php echo $row->provider; ?></td> <td nowrap align="left"><?php echo $row->title; ?></td> <td nowrap align="left"><?php echo $row->name; ?></td> <td nowrap align="left"><?php echo $row->paypal_tx_id; ?></td> <td nowrap align="left"><?php echo $row->paypal_payment_date; ?></td> <td nowrap align="left"><?php echo $row->paypal_testaccount ? BFText::_('COM_BREEZINGFORMS_YES') : BFText::_('COM_BREEZINGFORMS_NO'); ?></td> <td nowrap align="left"><?php echo $row->paypal_download_tries; ?></td> <td nowrap align="center"><a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&id=<?php echo $row->id ?>&viewed=<?php echo $row->viewed ?>&order=<?php echo JRequest::getWord('order','DESC') ?>&orderBy=<?php echo JRequest::getWord('orderBy','submitted') ?>"><img src="<?php echo $view_src; ?>" alt="+" border="0" /></a></td> <td nowrap align="center"><a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&id=<?php echo $row->id ?>&exported=<?php echo $row->exported ?>&order=<?php echo JRequest::getWord('order','DESC') ?>&orderBy=<?php echo JRequest::getWord('orderBy','submitted') ?>"><img src="<?php echo $exp_src; ?>" alt="+" border="0" /></a></td> <td nowrap align="center"><a href="index.php?option=com_breezingforms&act=recordmanagement&txtsearch=<?php echo JRequest::getWord('txtsearch','false'); ?>&search=<?php echo htmlentities(JRequest::getVar('search',''), ENT_QUOTES, 'UTF-8'); ?>&form=<?php echo htmlentities(JRequest::getVar('form',''), ENT_QUOTES, 'UTF-8'); ?>&task=<?php echo JRequest::getVar('task',''); ?>&limitstart=<?php echo JRequest::getInt('limitstart',0); ?>&mylimit=<?php echo JRequest::getInt('mylimit',20); ?>&id=<?php echo $row->id ?>&archived=<?php echo $row->archived ?>&order=<?php echo JRequest::getWord('order','DESC') ?>&orderBy=<?php echo JRequest::getWord('orderBy','submitted') ?>"><img src="<?php echo $arch_src; ?>" alt="+" border="0" /></a></td> </tr> <?php $k = 1 - $k; } ?> </table> </div> <input type="hidden" name="boxchecked" value="0" /> <input type="hidden" name="option" value="com_breezingforms" /> <input type="hidden" id="task" name="task" value="<?php echo JRequest::getVar('task',''); ?>" /> <input type="hidden" name="act" value="recordmanagement" /> <input type="hidden" name="status_update" value="0" /> <input type="hidden" name="order" value="<?php echo JRequest::getWord('order','DESC') ?>" /> <input type="hidden" name="orderBy" value="<?php echo JRequest::getWord('orderBy','submitted') ?>" /> <input type="hidden" id="limitstart" name="limitstart" value="<?php echo JRequest::getInt('limitstart',0); ?>" /> <input type="hidden" id="mylimit" name="mylimit" value="<?php echo JRequest::getInt('mylimit',20); ?>" /> <input type="hidden" id="exportt" name="exportt" value="0" /> </form> <table class="adminlist"> <tfoot> <tr> <td colspan="14"> <form action="#"> <?php echo $pagination->getListFooter() ?> </form> </td> </tr> </tfoot> </table> <script> // fixing limit, since it seems not to be available through JRequest or even $_POST/$_GET/$_REQUEST document.getElementById('limit').onchange = function(){ document.getElementById('mylimit').value = document.getElementById('limit').options[document.getElementById('limit').selectedIndex].value; document.adminForm.submit(); }; </script> <?php }
/** * Inserts a new row if id is zero or updates an existing row in the database table * * Can be overloaded/supplemented by the child class * * @access public * @param boolean If false, null object variables are not updated * @return null|string null if successful otherwise returns and error message */ function store($updateNulls = true) { $k = $this->_tbl_key; $wheres = array(); // execute query and retrieve result $query = $this->_db->getQuery(true); $query->select(' 1 '); $query->from(' ' . $this->_db->quoteName($this->_tbl) . ' '); // check whether all fields are filled and build where statement for ($i = 0; $i < count($k); $i++) { if ($this->{$k}[$i] === null) { $this->setError(get_class($this) . '::store failed - primary key ' . $this->{$k} . ' is empty (null)'); return false; } else { $wheres[] = ' ' . $this->_db->quoteName($k[$i]) . ' = ' . $this->_db->Quote($this->{$k}[$i]) . ' '; } } foreach ($wheres as $where) { $query->where($where); } $this->_db->setQuery($query); $result = $this->_db->loadResult(); // if query has no result, record does not exists yet and is added here // if query has result, record exists and is updated here if (!$result) { $ret = $this->_db->insertObject($this->_tbl, $this); } else { $query->clear(); $query->update($this->_db->quoteName($this->_tbl)); $sets = array(); foreach ($this->getProperties() as $name => $value) { if (is_array($value) or is_object($value) or $name[0] == '_') { // internal or NA field continue; } if (in_array($name, $k)) { // PK not to be updated continue; } if ($value === null) { if ($updateNulls) { $val = 'NULL'; } else { continue; } } else { //$val = $this->_db->isQuoted( $name ) ? $this->_db->Quote( $value ) : (int) $value; $val = $this->_db->Quote($value); } $sets[] = $this->_db->quoteName($name) . '=' . $val; } if (count($sets) > 0) { foreach ($sets as $set) { $query->set($set); } foreach ($wheres as $where) { $query->where($where); } $this->_db->setQuery($query); $ret = $this->_db->query(); } else { $ret = true; } } if (!$ret) { $this->setError(get_class($this) . '::store failed - ' . $this->_db->getErrorMsg()); return false; } else { return true; } }