<?php
use_class('orders');
$class_o = new orders();
//AJAX ACTION
if (isset($_POST['me_action']) && $_POST['me_action'] != '') {
if ($_POST['me_action'] == 'LOADRETDETAIL') {
$detail_id = tep_db_prepare_input($_POST['detail_id']);
$det = explode('-', $detail_id);
$return_id = $det[1];
$return = $class_o->retrieveReturnDetail($return_id);
$result = array();
$result['detail_id'] = $detail_id;
$result['return_comment'] = $return['return_comment'];
$result['return_request'] = $class_o->productReturnRequestText($return['return_type']);
$result['email_last_sent'] = $return['email_last_sent'] == '' ? 'N/A' : date('d M Y', strtotime($return['email_last_sent']));
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'SEARCHRETURNS') {
$period1 = tep_db_prepare_input($_POST['period1']);
$period2 = tep_db_prepare_input($_POST['period2']);
$search_field = tep_db_prepare_input($_POST['search_field']);
$search_keywords = tep_db_prepare_input(utf8_decode($_POST['search_keywords']));
$p1 = explode('.', $period1);
$date1 = date('Y-m-d', strtotime($p1[2] . '-' . $p1[1] . '-' . $p1[0]));
$p2 = explode('.', $period2);
$date2 = date('Y-m-d', strtotime($p2[2] . '-' . $p2[1] . '-' . $p2[0]));
$searchfilter = " DATE(opr.return_date)>=DATE('{$date1}')";
$searchfilter .= " AND DATE(opr.return_date)<=DATE('{$date2}')";
if ($search_keywords != '') {
switch ($search_field) {
