<?php
/**
 * 888888ba                 dP  .88888.                    dP                
 * 88    `8b                88 d8'   `88                   88                
 * 88aaaa8P' .d8888b. .d888b88 88        .d8888b. .d8888b. 88  .dP  .d8888b. 
 * 88   `8b. 88ooood8 88'  `88 88   YP88 88ooood8 88'  `"" 88888"   88'  `88 
 * 88     88 88.  ... 88.  .88 Y8.   .88 88.  ... 88.  ... 88  `8b. 88.  .88 
 * dP     dP `88888P' `88888P8  `88888'  `88888P' `88888P' dP   `YP `88888P' 
 *
 *                          m a g n a l i s t e r
 *                                      boost your Online-Shop
 *
 * -----------------------------------------------------------------------------
 * $Id$
 *
 * (c) 2010 - 2013 RedGecko GmbH -- http://www.redgecko.de
 *     Released under the MIT License (Expat)
 * -----------------------------------------------------------------------------
 */

defined('_VALID_XTC') or die('Direct Access to this location is not allowed.');

class HoodErrorView {
	
	private $errorLog;
	private $settings = array();
	private $sort = array();
	private $currentPage = 1;
	private $pages = 1;
	private $url = array();
	private $mpID = '';
	
	public function __construct($settings = array()) {
		global $_MagnaSession, $_url;
		
		$this->mpID = $_MagnaSession['mpID'];
		
		$this->settings = array_merge(array(
			'maxTitleChars' => 300,
			'itemLimit' => 50
		), $settings);
		
		$this->url         = $_url;
		$this->url['view'] = 'failed';
		
		/* Download new Error Messages */
		
		$beginTimeFromTimeStamp = MagnaDB::gi()->fetchOne('
		    SELECT timestamp 
		      FROM ' . TABLE_MAGNA_CS_ERRORLOG . '
		     WHERE mpID="' . $this->mpID . '"
		  ORDER BY timestamp DESC
		     LIMIT 1
		');
		
		$this->deleteFromLog();
		$beginTimeFromConfig = getDBConfigValue('hood.errorlog.lastdate', $_MagnaSession['mpID'], $beginTimeFromTimeStamp);
		
		if ($beginTimeFromConfig === false) {
			$beginTime = time() - 60 * 60 * 24 * 12;
		} else {
			$beginTime = strtotime($beginTimeFromConfig . ' +0000') + 1;
		}
		$begin = gmdate('Y-m-d H:i:s', max($beginTime, time() - 60 * 60 * 24 * 12));
		
		$request = array(
			'ACTION' => 'GetErrorLogForDateRange',
			'BEGIN' => $begin,
			'OFFSET' => array(
				'COUNT' => 1000,
				'START' => 0
			)
		);
		#echo print_m($request, '$request');
		try {
			$result = MagnaConnector::gi()->submitRequest($request);
		}
		catch (MagnaException $e) {
			$result['DATA'] = array();
		}
		#echo print_m($result, '$result');
		#return;
		$newbegin = '';
		if (array_key_exists('DATA', $result) && !empty($result['DATA'])) {
			foreach ($result['DATA'] as $item) {
				$sku = isset($item['ErrorData']['MasterSKU']) ? $item['ErrorData']['MasterSKU'] : $item['ErrorData']['SKU'];
				$pID = magnaSKU2pID($sku);
				
				$data = array(
					'mpID' => $this->mpID,
					'products_id' => $pID,
					'products_model' => MagnaDB::gi()->fetchOne('SELECT products_model FROM ' . TABLE_PRODUCTS . ' WHERE products_id="' . $pID . '"'),
					'product_details' => serialize($item),
					'errormessage' => $item['ErrorMessage'],
					'timestamp' => $item['DateAdded']
				);
				if ($begin < $item['DateAdded']) {
					$begin = $item['DateAdded'];
				}
				MagnaDB::gi()->insert(TABLE_MAGNA_CS_ERRORLOG, $data);
				$newbegin = $item['DateAdded'];
			}
		}
		if (!empty($newbegin)) {
			setDBConfigValue('hood.errorlog.lastdate', $this->mpID, $newbegin, true);
		}
		
		if (isset($_GET['sorting'])) {
			$sorting = $_GET['sorting'];
		} else {
			$sorting = 'blabla'; // fallback for default
		}
		
		switch ($sorting) {
			case 'errormessage':
				$this->sort['order'] = 'errormessage';
				$this->sort['type']  = 'ASC';
				break;
			case 'errormessage-desc':
				$this->sort['order'] = 'errormessage';
				$this->sort['type']  = 'DESC';
				break;
			case 'timestamp':
				$this->sort['order'] = 'timestamp';
				$this->sort['type']  = 'ASC';
				break;
			case 'timestamp-desc':
			default:
				$this->sort['order'] = 'timestamp';
				$this->sort['type']  = 'DESC';
				break;
		}
		
		$this->numberofitems = (int) MagnaDB::gi()->fetchOne('
			SELECT DISTINCT count(id)
			  FROM ' . TABLE_MAGNA_CS_ERRORLOG . '
			 WHERE mpID = '.$this->mpID.'
		');
		$this->pages         = ceil($this->numberofitems / $this->settings['itemLimit']);
		$this->currentPage   = 1;
		
		if (isset($_GET['page']) && ctype_digit($_GET['page']) && (1 <= (int) $_GET['page']) && ((int) $_GET['page'] <= $this->pages)) {
			$this->currentPage = (int) $_GET['page'];
		}
		
		$this->offset = ($this->currentPage - 1) * $this->settings['itemLimit'];
		
		$artNr          = getDBConfigValue('general.keytype', '0') == 'artNr';
		$this->errorLog = MagnaDB::gi()->fetchArray('
		    SELECT cse.id, ' . ($artNr ? 'p.products_id' : 'cse.products_id') . ', cse.errormessage, 
		           cse.timestamp AS date, timestamp , product_details as additionaldata
		      FROM ' . TABLE_MAGNA_CS_ERRORLOG . ' cse,
		           ' . ($artNr ? TABLE_PRODUCTS . ' p, ' : '') .'
		           ' . TABLE_PRODUCTS_DESCRIPTION . ' pd
		     WHERE cse.mpID="' . $this->mpID . '"
		           AND ' . ($artNr 
		                ? 'cse.products_model=p.products_model AND p.products_id=pd.products_id' 
		                : 'cse.products_id=pd.products_id'
		           ) . '
		           AND pd.language_id = "' . $_SESSION['languages_id'] . '"
		  ORDER BY `' . $this->sort['order'] . '` ' . $this->sort['type'] . ' 
		     LIMIT ' . $this->offset . ',' . $this->settings['itemLimit']
		);
		if (!empty($this->errorLog)) {
			foreach ($this->errorLog as &$item) {
				$additionalArray        = @unserialize($item['additionaldata']);
				$item['additionaldata'] = $additionalArray['ErrorData'];
			}
		}
	}
	
	private function deleteFromLog() {
		/* Delete selected Error Messages */
		if (isset($_POST['errIDs']) && isset($_POST['action']) && ($_POST['action'] == 'delete')) {
			foreach ($_POST['errIDs'] as $errID) {
				if (ctype_digit($errID)) {
					MagnaDB::gi()->delete(TABLE_MAGNA_CS_ERRORLOG, array(
						'id' => (int) $errID
					));
				}
			}
		}
		if (isset($_POST['deleteall'])) {
			MagnaDB::gi()->delete(TABLE_MAGNA_CS_ERRORLOG, array(
				'mpID' => $this->mpID
			));
		}
	}
	
	private function processAdditonalData($data) {
		if (isset($data['HoodOrderID'])) {
			$o = MagnaDB::gi()->fetchOne('
				SELECT data FROM ' . TABLE_MAGNA_ORDERS . '
				 WHERE special="' . MagnaDB::gi()->escape($data['HoodOrderID']) . '"
			');
			if ($o === false)
				return;
			$o = @unserialize($o);
			if (!is_array($o)) {
				$o = array();
			}
			$o['ML_ERROR_LABEL'] = 'ML_HOOD_ERROR_ORDERSYNC_FAILED';
			#echo print_m($o);
			$o = serialize($o);
			MagnaDB::gi()->update(TABLE_MAGNA_ORDERS, array(
				'data' => $o
			), array(
				'special' => $data['HoodOrderID']
			));
		}
	}
	
	private function sortByType($type) {
		return '
			<span class="nowrap">
				<a href="' . toURL($this->url, array(
					'sorting' => $type . ''
				)) . '" title="' . ML_LABEL_SORT_ASCENDING . '" class="sorting">
					<img alt="' . ML_LABEL_SORT_ASCENDING . '" src="' . DIR_MAGNALISTER_WS_IMAGES . 'sort_up.png" />
				</a>
				<a href="' . toURL($this->url, array(
					'sorting' => $type . '-desc'
				)) . '" title="' . ML_LABEL_SORT_DESCENDING . '" class="sorting">
					<img alt="' . ML_LABEL_SORT_DESCENDING . '" src="' . DIR_MAGNALISTER_WS_IMAGES . 'sort_down.png" />
				</a>
			</span>';
	}
	
	public function renderActionBox() {
		$left  = '<input type="button" class="ml-button" value="' . ML_BUTTON_LABEL_DELETE . '" id="errorLogDelete" name="errorLog[delete]"/>';
		$right = '<input type="submit" class="ml-button" value="' . ML_BUTTON_LABEL_DELETE_COMPLETE_LOG . '" name="deleteall"/>';
		
		ob_start();
		?><script type="text/javascript">/*<![CDATA[*/
			$(document).ready(function () {
				$('#errorLogDelete').click(function () {
					if (($('#errorlog input[type="checkbox"]:checked').length > 0) &&
						confirm(unescape(<?php echo "'".html2url(ML_GENERIC_DELETE_ERROR_MESSAGES)."'"; ?>))
					) {
						$('#action').val('delete');
						$(this).parents('form').submit();
					}
				});
			});
		/*]]>*/</script><?php
		// Durch aufrufen der Seite wird automatisch ein Aktualisierungsauftrag gestartet
		$js = ob_get_contents();
		ob_end_clean();
		
		return '
			<input type="hidden" id="action" name="action" value="">
			<input type="hidden" name="timestamp" value="' . time() . '">
			<table class="actions">
				<thead><tr><th>' . ML_LABEL_ACTIONS . '</th></tr></thead>
				<tbody><tr><td>
					<table><tbody><tr>
						<td class="firstChild">' . $left . '</td>
						<td class="lastChild">' . $right . '</td>
					</tr></tbody></table>
				</td></tr></tbody>
			</table>
			' . $js;
	}
	
	private function renderAdditionalData($data) {
		if (empty($data)) {
			return '&nbsp;';
		}
		$html = '<table class="nostyle addData fullWidth"><tbody>';
		foreach ($data as $key => $item) {
			$html .= '
				<tr>
					<th>' . str_replace(' ', '&nbsp;', $key) . '</th>
					<td>' . $item . '</td>
				</tr>';
		}
		return $html . '</tbody></table>';
	}
	
	private function additionalDataHandler($data) {
		$fData = array();
		if (array_key_exists('SKU', $data) && !empty($data['SKU'])) {
			$fData['SKU'] = htmlspecialchars($data['SKU']);
			$pID          = magnaSKU2pID($data['SKU']);
			
			$title = MagnaDB::gi()->fetchOne('
				SELECT products_name
				  FROM ' . TABLE_PRODUCTS_DESCRIPTION . ' 
				 WHERE products_id="' . (string) $pID . '" 
				       AND language_id = "' . $_SESSION['languages_id'] . '"
			');
			if (!empty($title)) {
				$fData[ML_LABEL_SHOP_TITLE] = '<a title="' . ML_LABEL_EDIT . '" ' . 'target="_blank" href="categories.php?pID=' . $pID . '&action=new_product">' . $title . '</a>';
			}
		} else if (array_key_exists('HoodOrderID', $data)) {
			if (!empty($data['HoodOrderID'])) {
				$fData['HoodOrderID'] = $data['HoodOrderID'];
				$oID = MagnaDB::gi()->fetchOne('
					SELECT orders_id FROM ' . TABLE_MAGNA_ORDERS . '
					 WHERE special="' . $data['HoodOrderID'] . '"
				');
				if (!empty($oID)) {
					$fData[ML_LABEL_ORDER_ID] = '<a title="' . ML_LABEL_EDIT . '" ' . 'target="_blank" href="orders.php?oID=' . $oID . '&action=edit">' . $oID . '</a>';
				}
			}
		} else if (!array_key_exists('SKU', $data)) {
			$fData = $data;
		}
		return $this->renderAdditionalData($fData);
	}
	
	public function renderView() {
		$html = '';
		if (empty($this->errorLog)) {
			return '<table class="magnaframe"><tbody><tr><td>' . ML_GENERIC_NO_ERRORS_YET . '</td></tr></tbody></table>';
		}
		
		$tmpURL = $this->url;
		if (isset($_GET['sorting'])) {
			$tmpURL['sorting'] = $_GET['sorting'];
		}
		
		$html .= '
			<form action="' . toURL($this->url) . '" method="POST">
				<table class="listingInfo"><tbody><tr>
					<td class="ml-pagination">
						<span class="bold">' . ML_LABEL_CURRENT_PAGE . ' &nbsp;&nbsp; ' . $this->currentPage . '</span>
					</td>
					<td class="textright">
						' . renderPagination($this->currentPage, $this->pages, $tmpURL) . '
					</td>
				</tr></tbody></table>
				<table class="datagrid" id="errorlog">
					<thead><tr>
						<td class="nowrap"><input type="checkbox" id="selectAll"/><label for="selectAll">' . ML_LABEL_CHOICE . '</label></td>
						<td>' . ML_AMAZON_LABEL_ADDITIONAL_DATA . '</td>
						<td>' . ML_GENERIC_ERROR_MESSAGES . '&nbsp;' . $this->sortByType('errormessage') . '</td>
						<td>' . ML_GENERIC_COMMISSIONDATE . '&nbsp;' . $this->sortByType('commissiondate') . '</td>
					</tr></thead>
					<tbody>';
		$oddEven          = false;
		$batchErrorlogURL = array(
			'ID' => '',
			'URL' => ''
		);
		foreach ($this->errorLog as $item) {
			$item['errormessage'] = fixHTMLUTF8Entities($item['errormessage']);
			$timestamp            = strtotime($item['timestamp']);
			$hdate                = date("d.m.Y", $timestamp) . ' &nbsp;&nbsp;<span class="small">' . date("H:i", $timestamp) . '</span>';
			$shortMessage         = ((strlen($item['errormessage']) > $this->settings['maxTitleChars'] + 2) ? (substr($item['errormessage'], 0, $this->settings['maxTitleChars'])) : false);
			$html .= '
						<tr class="' . (($oddEven = !$oddEven) ? 'odd' : 'even') . '">
							<td><input type="checkbox" name="errIDs[]" value="' . $item['id'] . '"></td>							
							<td class="nopadding" style="width: 1px">' . $this->additionalDataHandler($item['additionaldata']) . '</td>
							<td class="errormessage">' . (($shortMessage !== false) ? $shortMessage . '&hellip;<span>' . $item['errormessage'] . '</span>' : $item['errormessage']) . '</td>
							<td>' . $hdate . '</td>
						</tr>';
		}
		$html .= '
					</tbody>
				</table>
				<div id="errordetails" class="dialog2" title="' . ML_GENERIC_ERROR_DETAILS . '"></div>';
		ob_start();
		?><script type="text/javascript">/*<![CDATA[*/
			$(document).ready(function () {
				$('table#errorlog tbody td.errormessage').click(function () {
					if ($('span', this).length == 0)
						return;
					$('#errordetails').html($('span', this).html()).jDialog();
				});
			
				$('#selectAll').click(function () {
					state = $(this).attr('checked');
					$('#errorlog input[type="checkbox"]:not([disabled])').each(function () {
						$(this).attr('checked', state);
					});
				});
			});
		/*]]>*/</script><?php
		$html .= ob_get_contents();
		ob_end_clean();
		$html .= $this->renderActionBox() . '
			</form>';
		return $html;
	}
	
}