<?php
// setup environment
include_once('_environment.inc.php');

// page settings
define('PAGE_TITLE', 'Get In Touch');
define('SELECTED_LEFT_NAV', '');
define('PAGE_KEYWORDS', 'contact, php, site, script, web, development, website, file, image, hosting, sharing, upload, storage, service, short, link, url, shortener, user, management, s3, amazon, mfscripts, Yetishare, reservo, wurlie');
define('PAGE_DESCRIPTION', 'Contact us for more information on our web based php scripts.');
define('SELECTED_NAV_ITEM', 'contact');

// get release information
$stmt           = $db->query('SELECT DISTINCT version_number FROM release_history ORDER BY version_number DESC LIMIT 30');
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$releaseHistory = array();
while ($row            = $stmt->fetch())
{
    $releaseHistory[] = $row['version_number'];
}

// handle success
$emailSent = false;
if(isset($_GET['s']))
{
    $emailSent = true;
}

$emailAdd  = '';
$queryType = '';
$yourName  = '';
$comments  = '';
$website   = '';
$version   = '';
$purchase_code = '';
if (isset($_REQUEST['query_type']))
{
    $queryType = $_REQUEST['query_type'];
}
if (isset($_REQUEST['yourName']))
{
    $yourName = $_REQUEST['yourName'];
}
if (isset($_REQUEST['comments']))
{
    $comments = $_REQUEST['comments'];
}
if (isset($_SESSION['email']))
{
    $emailAdd  = $_SESSION['email'];
    $queryType = 'Technical Support';
}
if (isset($_REQUEST['version']))
{
    $version  = $_REQUEST['version'];
}
if (isset($_REQUEST['envato_item_id']))
{
    $queryType = 'CodeCanyon Support';
	$script = 'uCloud';
}

// if the form is submitted
$error = '';
if (isset($_POST['submitted']))
{
    // captcha variables
    $url = 'https://www.google.com/recaptcha/api/siteverify';
    $privatekey = RECAPTCHA_SECRET_KEY;
    $response = file_get_contents($url."?secret=".$privatekey."&response=".$_POST['g-recaptcha-response']."&remoteip=".$_SERVER[REMOTE_ADDR]);
    $data = json_decode($response);
    if(isset($data->success) AND $data->success==true)
	{
		// pickup variables
		$yourName = trim($_POST['yourName']);
		$emailAdd = trim(strtolower($_POST['emailAdd']));
		$queryType = trim($_POST['query_type']);
		$comments = trim($_POST['comments']);
		$website = isset($_POST['website'])?strtolower(trim($_POST['website'])):'';
		$script = isset($_POST['script'])?trim($_POST['script']):'';
		$version = isset($_POST['version'])?trim($_POST['version']):'';
		$purchase_code = isset($_POST['purchase_code'])?strtolower(trim($_POST['purchase_code'])):'';
		if (function_exists('stripslashes'))
		{
			$comments = stripslashes($comments);
		}
		
		// check to make sure that the name field is not empty
		if (strlen($yourName) == 0)
		{
			$error = 'You forgot to enter your first name.';
		}
		// check to make sure sure that a valid email address is submitted
		elseif (strlen($emailAdd) == 0)
		{
			$error = 'You forgot to enter your email address.';
		}
		else if (!eregi("^[A-Z0-9._%-]+@[A-Z0-9._%-]+\.[A-Z]{2,4}$", $emailAdd))
		{
			$error = 'You entered an invalid email address.';
		}
		elseif(strlen($queryType) == 0)
		{
			$error = "Please select the type of query from the drop-down list.";
		}
		// check to make sure comments were entered
		elseif (strlen($comments) == 0)
		{
			$error = 'You forgot to enter your query.';
		}
		
		// if there is no error, check for a valid email address
		if (strlen($error) == 0)
		{
			if($_REQUEST['query_type'] == 'Technical Support')
			{
				// lookup account details based on email
				$stmt = $db->prepare('SELECT id FROM tblusers WHERE emailadd = :emailadd LIMIT 1');
				$stmt->bindParam(':emailadd', $emailAdd, PDO::PARAM_STR);
				$stmt->execute();
				$stmt->setFetchMode(PDO::FETCH_ASSOC);
				$row  = $stmt->fetch();
				if (!$row)
				{
					$error = "Could not find email, please ensure you submit support requests from your account registered email address.";
				}
			}
			elseif($_REQUEST['query_type'] == 'CodeCanyon Support')
			{
				if(strlen($purchase_code) == 0)
				{
					$error = "Please enter your purchase code.";
				}
				elseif(strlen($website) == 0)
				{
					$error = "Please enter your installation url.";
				}
			}
		}

		// if there is no error, send the email
		if (strlen($error) == 0)
		{
			$emailTo = 'sales@mfscripts.com';
			if(($queryType == 'Technical Support') || ($queryType == 'CodeCanyon Support'))
			{
				$emailTo = 'support@mfscripts.com';
			}

			$subject  = ucfirst(strtolower($queryType)).' mfscripts.com contact from ' . $yourName;
			$body     = "Name: $yourName  <br/>";
			$body .= "Email: $emailAdd  <br/>";
			if(strlen($queryType))
			{
				$body .= "Type: " . $queryType . " <br/>";
			}
			$body .= "Script: " . $script . " <br/>";
			if(strlen($website))
			{
				$body .= "Website: " . $website . " <br/>";
			}
			if(strlen($version))
			{
				$body .= "Version: " . $version . " <br/>";
			}
			if(strlen($purchase_code))
			{
				$body .= "Purchase Code: " . $purchase_code . " <br/>";
			}
			$body .= "Comments:<br/><br/>".nl2br($comments)."<br/><br/>";
			$body .= "*******************************************************<br/>";
			$body .= "IP: " . getUserIpAddress()."<br/><br/>";
		
			// lookup account details based on email
			$stmt = $db->prepare('SELECT id FROM tblusers WHERE emailadd = :emailadd LIMIT 1');
			$stmt->bindParam(':emailadd', $_REQUEST['email'], PDO::PARAM_STR);
			$stmt->execute();
			$stmt->setFetchMode(PDO::FETCH_ASSOC);
			$row  = $stmt->fetch();
			if ($row)
			{
				$userId = (int)$row['id'];
				
				// load orders and their state
				$stmt  = $db->query('SELECT tblorderitems.support_end, tblsalesitems.type, tblsalesitems.itemgroup, tblorders.id AS order_id, tblsalesitems.filepath, tblorderitems.id AS order_item_id, tblorders.totalvalue AS order_total, tblorders.paymenttracker, orderdate, tblorderitems.description, tblorderitems.price, tblorders.status, tblsalesitems.script_id FROM tblorders LEFT JOIN tblorderitems ON tblorders.id = tblorderitems.orderid LEFT JOIN tblsalesitems ON tblorderitems.salesitemid = tblsalesitems.id WHERE tblorders.userid=' . (int)$userId . ' ORDER BY tblorders.orderdate DESC');
				$stmt->setFetchMode(PDO::FETCH_ASSOC);
				$faq   = array();
				$body .= "ORDER HISTORY:<br/>";
				while ($row2   = $stmt->fetch())
				{
					$body .= "#".$row2['order_id'].", ".$row2['orderdate'].", ".$row2['status'].", ".$row2['description']."<br/>";
				}
			}
			
			// send email
			sendEmail($subject, $body, $emailTo, $emailAdd, $yourName);

			// redirect to clear post
			redirect(SITE_URL.'/contact.html?s=1');
		}
	}
    else 
	{
        $error = "You entered the captcha incorrectly!";
    }
}

// include header section
include_once('_header.inc.php');
?>

<script>
    $(document).ready(function()
    {
        selectTypeItem();
    });

    function selectTypeItem()
    {
        $('.supportWrapper').hide();
		$('.codeCanyonWrapper').hide();
        if ($('#query_type').val() == 'Technical Support')
        {
            $('.supportWrapper').show();
        }
		else if ($('#query_type').val() == 'CodeCanyon Support')
        {
            $('.codeCanyonWrapper').show();
			$('#script').val('uCloud');
        }
    }
	
	function toggleContactType() {
		if($('#script').val() == 'uCloud' && $('#query_type').val() == 'Technical Support') {
			$('#query_type').val('CodeCanyon Support');
			selectTypeItem();
		}
	}
</script>


<ol class="breadcrumb">
	<li><a href="index.html">Home</a></li>
	<li class="active"><?php echo PAGE_TITLE; ?></li>
</ol>

<div class="row">
	<div class="col-md-8">
		<section class="no-border no-padding margin-bottom-20">
            <div class="title">
                <h3 class="headline margin-bottom-10"><?php echo PAGE_TITLE; ?></h3>
            </div>
			
            <?php
                if ($emailSent == true)
                {
                    $success = 'Your message has been sent to MFScripts. You should expect a response within 24 hours. Please note, our office times are 9.00am - 5.00pm (GMT) Monday to Friday.';
                    echo compileSuccess($success, 'margin-bottom-10');
                    ?>
                    <p class="margin-top-20">
						<a class="btn btn-default" type="button" href="<?php echo SITE_URL; ?>/index.html">Return Home</a>
					</p>
                    <?php
                }
                else
                {
                    echo '<p>Use the following form to get in contact with us about any pre/post sales questions on our PHP website scripts.</p>';
                    
            		if (strlen($error))
            		{
            			echo compileError($error, 'margin-bottom-10');
            		}
            ?>
        
            <form id="contactForm" action="contact.html" class="responsive-no-side-padding" method="POST" role="form">
                <div class="row margin-top-15">	
                    <div class="control-group responsive-no-side-padding col-md-6">
                        <input id="yourName" name="yourName" value="<?php echo safeOutputToScreen($yourName); ?>" placeholder="Full Name" type="text" class="form-control responsive-form-spacing" required="required"/>
                    </div>
                    
                    <div class="control-group responsive-no-side-padding col-md-6">
                        <input id="emailAdd" name="emailAdd" value="<?php echo safeOutputToScreen($emailAdd); ?>" placeholder="Email Address" type="text" class="form-control responsive-form-spacing" required="required"/>
                    </div>
                </div>
        
                <div class="row margin-top-15">	
                    <div class="responsive-no-side-padding col-md-12">
                        <select id="query_type" name="query_type" class="form-control responsive-form-spacing" onChange="selectTypeItem(); return false;" required="required">
                            <option value="">Contact Type...</option>
                            <option value="Pre-Sales Questions" <?php if ($queryType == 'Pre-Sales Questions') echo 'SELECTED'; ?>>Pre-Sales Questions</option>
							<option value="Technical Support" <?php if ($queryType == 'Technical Support') echo 'SELECTED'; ?>>Technical Support (if you've already purchased directly from us)</option>
							<option value="CodeCanyon Support" <?php if ($queryType == 'CodeCanyon Support') echo 'SELECTED'; ?>>CodeCanyon Support (for uCloud)</option>
                        </select>
                    </div>
                </div>
        
                <div class="row margin-top-15">
                    <div class="control-group responsive-no-side-padding col-md-12">
                        <select id="script" name="script" class="form-control responsive-form-spacing" onchange="toggleContactType(); return false;">
                            <option value="None" <?php if ($script == 'None') echo 'SELECTED'; ?>>Select Script...</option>
							<option value="Yetishare - File Hosting Script" <?php if ($script == 'Yetishare - File Hosting Script') echo 'SELECTED'; ?>>Yetishare - File Hosting Script</option>
							<option value="Reservo - Image Hosting Script" <?php if ($script == 'Reservo - Image Hosting Script') echo 'SELECTED'; ?>>Reservo - Image Hosting Script</option>
                            <option value="Wurlie - Short Url Script" <?php if ($script == 'Wurlie - Short Url Script') echo 'SELECTED'; ?>>Wurlie - Short Url Script</option>
                            <option value="Font Site Script" <?php if ($script == 'Font Site Script') echo 'SELECTED'; ?>>Font Site Script</option>
							<option value="S3 Backup WHM" <?php if ($script == 'S3 Backup WHM') echo 'SELECTED'; ?>>S3 Backup WHM</option>
                            <option value="User Management Script" <?php if ($script == 'User Management Script') echo 'SELECTED'; ?>>User Management Script</option>
							<option value="uCloud" <?php if ($script == 'uCloud') echo 'SELECTED'; ?>>uCloud</option>
                        </select>
                    </div>
                </div>

                <div class="row margin-top-15 supportWrapper responsive-no-side-padding" style="display: none;">
                    <div class="control-group col-md-9 responsive-no-side-padding">
                        <input id="website" class="form-control responsive-form-spacing" name="website" value="<?php echo safeOutputToScreen($_REQUEST['website']); ?>" type="text" placeholder='Your Website Url'/>
                    </div>
                    
                    <div class="control-group col-md-3 responsive-no-side-padding">
                        <select id="version" name="version" class="form-control responsive-form-spacing">
                            <option value="">- Script Version -</option>
                            <?php
                            foreach ($releaseHistory AS $releaseHistoryItem)
                            {
                                echo '<option value="v' . $releaseHistoryItem . '"';
                                if('v'.$releaseHistoryItem == $version)
                                {
                                    echo ' SELECTED';
                                }
                                echo '>v' . $releaseHistoryItem . '</option>';
                            }
                            ?>
                            <option value="Other">Other</option>
                        </select>
                    </div>
                </div>
				
				<div class="row margin-top-15 codeCanyonWrapper responsive-no-side-padding" style="display: none;">
                    <div class="control-group col-md-6 responsive-no-side-padding">
                        <input id="website" class="form-control responsive-form-spacing" name="website" value="<?php echo safeOutputToScreen($_REQUEST['website']); ?>" type="text" placeholder='Your Install Url'/>
                    </div>
                    
                    <div class="control-group col-md-6 responsive-no-side-padding">
                        <input id="purchase_code" class="form-control responsive-form-spacing" name="purchase_code" value="<?php echo safeOutputToScreen($_REQUEST['purchase_code']); ?>" type="text" placeholder='Your CodeCanyon Purchase Code'/>
                    </div>
                </div>
        
                <div class="row margin-top-15">
                    <div class="control-group responsive-no-side-padding col-md-12">
                        <textarea rows="10" class="form-control" cols="99" id="comments" name="comments" placeholder='Your Query...' required="required"><?php echo safeOutputToScreen($comments); ?></textarea>
                    </div>
                </div>
        
                <input name="submitted" type="hidden" value="1"/>
                
                <div class="control-group col-md-12 no-padding margin-top-15 supportWrapper" style="display: none;">
                    <div class="controls">
                        <div class="title">
                            <h3 class="headline margin-bottom-10 margin-top-10">Important</h3>
                        </div>
                        <ul class="listing-style">
                            <li>
                                Please raise support requests from your account registered email address. We can not offer support unless we find your email address in our system.
                            </li>
                            <li>
                                Please include as much information as possible in your support request so we can provide a quick resolution.
                            </li>
                            <li>
                                If you have an issue which requires a login to your site, please include access details so we can reproduce the issue.
                            </li>
                        </ul>
                     </div>
                </div>
				<div class="control-group col-md-12 no-padding margin-top-15 codeCanyonWrapper" style="display: none;">
                    <div class="controls">
                        <div class="title">
                            <h3 class="headline margin-bottom-10 margin-top-10">Important</h3>
                        </div>
                        <ul class="listing-style">
                            <li>
                                Please ensure you include your CodeCanyon purchase within the above request. We can not offer support unless we can verify your support period for the script.
                            </li>
                            <li>
                                Please include as much information as possible in your support request so we can provide a quick resolution.
                            </li>
                            <li>
                                If you have an issue which requires a login to your site, please include access details so we can reproduce the issue.
                            </li>
                        </ul>
                     </div>
                </div>
                <div class="clear"></div>
                <div style="margin-top:15px;" class="g-recaptcha" data-sitekey="<?php echo RECAPTCHA_SITE_KEY; ?>"></div>
                <div class="clear"></div>
                <div>
                    <button type="submit" class="btn btn-info pull-left margin-top-15"><i class="ion-android-checkmark"></i>&nbsp;&nbsp;Send Query</button>
                </div>	
            </form>
            <?php
            }
            ?>
            
		</section>
	</div>

	<div class="col-md-4">
		<section class="no-padding-top no-border no-margin">
            <div class="title">
                <h3 class="headline margin-bottom-10">Company Details</h3>
            </div>
			<p>We are a real business with full time staff and offices in the south of the UK:</p>
            <img src="<?php echo SITE_URL; ?>/assets/img/wessex-house.jpg" class="img-thumbnail" alt="MFScripts Wessex House"/>
			<address class="margin-top-30">
                <div class="title">
                    <h3 class="headline margin-bottom-10">Office Address</h3>
                </div>
				<p><strong>MFScripts.com c/o Mellow Fish Ltd</strong><br/>Wessex House<br/>Eastleigh<br/>Hampshire<br/>SO50 9FD<br/>United Kingdom<br/><br/>
                <strong>Co. Number:</strong> 06362139</p>
			</address>
		</section>
     	</div>
	</div>

<?php
// include header section
include_once('_footer.inc.php');
?>