PHP JDatabaseQuery::clear方法代码示例

	/**
	 * Test for the clear method (clearing each query type).
	 *
	 * @return  void
	 *
	 * @covers  JDatabaseQuery::clear
	 * @since   11.1
	 */
	public function testClear_type()
	{
		$types = array(
			'select',
			'delete',
			'update',
			'insert',
			'union',
		);

		$clauses = array(
			'from',
			'join',
			'set',
			'where',
			'group',
			'having',
			'order',
			'columns',
			'values',
		);

		// Set the clauses.
		foreach ($clauses as $clause)
		{
			$this->_instance->$clause = $clause;
		}

		// Check that all properties have been cleared
		foreach ($types as $type)
		{
			// Set the type.
			$this->_instance->$type = $type;

			// Clear the type.
			$this->_instance->clear($type);

			// Check the type has been cleared.
			$this->assertThat(
				$this->_instance->type,
				$this->equalTo(null)
			);

			$this->assertThat(
				$this->_instance->get($type),
				$this->equalTo(null)
			);

			// Now check the claues have not been affected.
			foreach ($clauses as $clause)
			{
				$this->assertThat(
					$this->_instance->get($clause),
					$this->equalTo($clause)
				);
			}
		}
	}

 /**
  * Clear data from the query or a specific clause of the query.
  *
  * @param   string  $clause  Optionally, the name of the clause to clear, or nothing to clear the whole query.
  *
  * @return  void
  *
  * @since   11.3
  */
 public function clear($clause = null)
 {
     switch ($clause) {
         case 'limit':
             $this->limit = null;
             break;
         case 'offset':
             $this->offset = null;
             break;
         case 'forUpdate':
             $this->forUpdate = null;
             break;
         case 'forShare':
             $this->forShare = null;
             break;
         case 'noWait':
             $this->noWait = null;
             break;
         case 'returning':
             $this->returning = null;
             break;
         case 'select':
         case 'update':
         case 'delete':
         case 'insert':
         case 'from':
         case 'join':
         case 'set':
         case 'where':
         case 'group':
         case 'having':
         case 'order':
         case 'columns':
         case 'values':
             parent::clear($clause);
             break;
         default:
             $this->type = null;
             $this->limit = null;
             $this->offset = null;
             $this->forUpdate = null;
             $this->forShare = null;
             $this->noWait = null;
             $this->returning = null;
             parent::clear($clause);
             break;
     }
     return $this;
 }

 /**
  * Run all active cron jobs
  *
  * @return void
  */
 protected function doCron()
 {
     $app = JFactory::getApplication();
     $mailer = JFactory::getMailer();
     $config = JFactory::getConfig();
     $input = $app->input;
     if ($app->isAdmin() || $input->get('option') == 'com_acymailing') {
         return;
     }
     // $$$ hugh - don't want to run on things like AJAX calls
     if ($input->get('format', '') == 'raw') {
         return;
     }
     // Get all active tasks
     $this->db = FabrikWorker::getDbo(true);
     $this->query = $this->db->getQuery(true);
     $now = $input->get('fabrikcron_run', false);
     $this->log = FabTable::getInstance('Log', 'FabrikTable');
     if (!$now) {
         /* $$$ hugh - changed from using NOW() to JFactory::getDate(), to avoid time zone issues, see:
          * http://fabrikar.com/forums/showthread.php?p=102245#post102245
          * .. which seems reasonable, as we use getDate() to set 'lastrun' to at the end of this func
          */
         $nextRun = "CASE " . "WHEN unit = 'second' THEN DATE_ADD( lastrun, INTERVAL frequency SECOND )\n" . "WHEN unit = 'minute' THEN DATE_ADD( lastrun, INTERVAL frequency MINUTE )\n" . "WHEN unit = 'hour' THEN DATE_ADD( lastrun, INTERVAL frequency HOUR )\n" . "WHEN unit = 'day' THEN DATE_ADD( lastrun, INTERVAL frequency DAY )\n" . "WHEN unit = 'week' THEN DATE_ADD( lastrun, INTERVAL frequency WEEK )\n" . "WHEN unit = 'month' THEN DATE_ADD( lastrun, INTERVAL frequency MONTH )\n" . "WHEN unit = 'year' THEN DATE_ADD( lastrun, INTERVAL frequency YEAR ) END";
         $this->query->select("id, plugin, lastrun, unit, frequency, " . $nextRun . " AS nextrun")->from('#__{package}_cron')->where("published = '1'")->where("{$nextRun} < '" . JFactory::getDate()->toSql() . "'");
     } else {
         $this->query->select('id, plugin')->from("#__{package}_cron WHERE published = '1'");
     }
     $this->db->setQuery($this->query);
     $rows = $this->db->loadObjectList();
     if (empty($rows)) {
         return;
     }
     // register our shutdownHandler(), so we can re-publish and reschedule the event if the script errors out
     register_shutdown_function(array($this, 'shutdownHandler'));
     $this->log->message = '';
     JModelLegacy::addIncludePath(JPATH_SITE . '/components/com_fabrik/models');
     /** @var FabrikFEModelPluginmanager $pluginManager */
     $pluginManager = JModelLegacy::getInstance('Pluginmanager', 'FabrikFEModel');
     $listModel = JModelLegacy::getInstance('list', 'FabrikFEModel');
     foreach ($rows as $row) {
         // assign $row to $this->row, as we may need it in shutdown handling
         $this->row = $row;
         // Load in the plugin
         $this->pluginModel = $pluginManager->getPluginFromId($this->row->id, 'Cron');
         $params = $this->pluginModel->getParams();
         $this->log->message = '';
         $this->log->id = null;
         $this->log->referring_url = '';
         $this->log->message_type = 'plg.cron.' . $this->row->plugin;
         if (!$this->pluginModel->queryStringActivated()) {
             continue;
         }
         if ($this->pluginModel->doRunGating()) {
             $this->query->clear()->update('#__{package}_cron')->set('published = 0')->where('id = ' . $this->db->quote($this->row->id));
             $this->db->setQuery($this->query);
             $this->db->execute();
         }
         $tid = (int) $params->get('table');
         $thisListModel = clone $listModel;
         if ($tid !== 0) {
             $thisListModel->setId($tid);
             $this->log->message .= "\n\n" . $this->row->plugin . "\n listid = " . $thisListModel->getId();
             if ($this->pluginModel->requiresTableData()) {
                 //$table = $thisListModel->getTable();
                 //$total = $thisListModel->getTotalRecords();
                 //$nav = $thisListModel->getPagination($total, 0, $total);
                 $cron_row_limit = (int) $params->get('cron_row_limit', 100);
                 $thisListModel->setLimits(0, $cron_row_limit);
                 $thisListModel->getPagination(0, 0, $cron_row_limit);
                 $data = $thisListModel->getData();
                 // for some reason this hoses up next query
                 //$this->log->message .= "\n" . $thisListModel->buildQuery();
             }
         } else {
             $data = array();
         }
         $this->pluginModel->process($data, $thisListModel);
         $this->log->message = $this->pluginModel->getLog() . "\n\n" . $this->log->message;
         $this->reschedule();
         // Log if asked for
         if ($params->get('log', 0) == 1) {
             $this->log->store();
         }
         // Email log message
         $recipient = explode(',', $params->get('log_email', ''));
         if (!FArrayHelper::emptyish($recipient)) {
             $subject = $config->get('sitename') . ': ' . $this->row->plugin . ' scheduled task';
             $mailer->sendMail($config->get('mailfrom'), $config->get('fromname'), $recipient, $subject, $this->log->message, true);
         }
     }
 }