/exchange/code/trunk/administrator/components/com_exchange/models/transforms/deleterecords.php

<?php
/**
 * @version		$Id: deleterecords.php 280 2010-09-18 02:14:15Z eddieajau $
 * @package		NewLifeInIT
 * @subpackage	com_exchange
 * @copyright	Copyright 2005 - 2010 New Life in IT Pty Ltd. All rights reserved.
 * @license		GNU General Public License version 2 or later.
 * @link		http://www.theartofjoomla.com
 */

// no direct access
defined('_JEXEC') or die;

/**
 * @package		NewLifeInIT
 * @subpackage	com_exchange
 */
class XMLTransformDeleteRecords extends XMLIterator
{
	/**
	 * Evaluates an expression
	 *
	 * @param	object	The tag node
	 * @param	mixed	The value of the field
	 * @return	mixed	The result of the expression
	 */
	function iterate(&$node /*, $obj, $fieldName*/)
	{
		$model		= &$this->getModel();
		$logQueries	= $model->getOption('log_queries');
		$db			= &$model->getDestDBO();
		$sets		= array();

		// get the source data
		$data		= $this->parent->getSourceData();

		$n			= count($data);
		$test		= $model->getOption('test_mode', XMLHelper::isBool((string) $node['test']));
		$replace	= XMLHelper::isBool((string) $node['replace']);
		$unique		= (string) $node['unique'];
		$uniques	= array();

		// Loop through each data record
		for ($i = 0; $i < $n; $i++)
		{
			$isInsert	= true;
			$item		= &$data[$i];
			if ($unique)
			{
				if (in_array($item[$unique], $uniques)) {
					continue;
				}
			}
			if ($fields = parent::iterate($node, $item))
			{
				// $fields[0] = field name
				// $fields[1] = field value
				// $fields[2] = field value only if required attribute is true
				// get the field values
				$temp	= array();
				foreach ($fields as $field) {
					$temp[]	= $db->nameQuote($field[0]).'='.$db->Quote($field[1]);
				}
				$sets[] = '('.implode(" AND \n", $temp).')';
			}
		}

		if ($sets)
		{
			// do the extended insert
			$dest	= $db->nameQuote('#__'.$this->parent->dest);
			$query	= 'DELETE FROM '.$dest.' WHERE '.implode(" OR \n", $sets);
			$db->setQuery($query);
//			echo $query;die;
//			exit('<br><br><h1>exit</h1> at ' . __FILE__ . ' (' . __LINE__ . ') '. __METHOD__ . "<br>");

			if ($logQueries) {
				ExchangeLog::add(0, $db->getQuery());
			}
			if (!$test)
			{
				if (!$db->query()) {
					ExchangeLog::add(500, ' '.$db->getErrorMsg());
				}
			}
		}
	}
}