<?php
$base_url = "https://www.omvparts.com/operations";
//$base_url = "http://localhost:8888/vehicleduty/public/operations";
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head profile="http://www.w3.org/2005/10/profile"><link rel="icon" type="image/png" href="images/favicon.png" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="cache-control" content="no-cache, must-revalidate, post-check=0, pre-check=0">
<meta http-equiv="expires" content="Sat, 31 Oct 2014 00:00:00 GMT">
<meta http-equiv="pragma" content="no-cache">

<title>Operations</title>
<script src="scripts/jquery.js"></script>
<script  type="text/javascript">
function runScript(id){
	if(confirm("CONFIRM EXECUTION\nThe selected Script is about to be run")){
		$("#bod>ol>li#"+id+" form").submit();

		/*var dstFrame = document.getElementById('resf');
		var dstDoc = dstFrame.contentDocument || dstFrame.contentWindow.document;
		dstDoc.write("Script is starting...");
		dstDoc.close()*/
		//$("iframe#resf").html("Script is starting...");
	}
}
function expandItem(id){
	$("#bod>ol>li table").hide();
	$("#bod>ol>li#"+id+" table").show();
}

function hL(n){
	var p = n.indexOf('_'); p = n.substring(0,p);
	$("li#"+p+" input[type=text]").css("border","2px solid rgba(0,0,0,0)");
	$("li#"+p+" input[title="+n+"]").css("border","2px solid #000");
}

function unHL(){
	$("input[type=text]").css("border","2px solid rgba(0,0,0,0)");
}

function selectFolder(e) {
	var folder = e.target.files[0].webkitRelativePath.split("/")[0];
	$("input#path_to_folder").val(folder);
	$("#bod>ol>li#removewithparen form").submit();
	/*var load = [];
	for (var i = 0; i < e.target.files.length; i++) {
		load.push(e.target.files[i].name);
	}
	alert(JSON.stringify(load));*/
	/*for (var i = 0; i < e.target.files.length; i++) {
      var s = e.target.files[i].name + '\n';
      s += e.target.files[i].size + ' Bytes\n';
      s += e.target.files[i].type;
      alert(s);
	}*/
}
/*function runScript(nam,loc){
	nam = nam.toUpperCase();
	if(confirm("Please confirm! The following Script is about to be run\n\n"+nam+"\n"+loc)){
		location = loc;
		document.getElementById('bod').innerHTML = "Script is Starting...";
	}
}*//*function valueOf(id){ return document.getElementById(id).value; }onclick="runScript('findrepl_form')"*/
</script>
<style>
/*** FONTS ***/
@font-face {
    font-family: 'greatvibes-regular';
    src: url('/assets/fonts/greatvibes-regular-webfont.woff2') format('woff2'),
         url('/assets/fonts/greatvibes-regular-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'fjalla_oneregular';
    src: url('/assets/fonts/fjallaone-regular-webfont.woff2') format('woff2'),
         url('/assets/fonts/fjallaone-regular-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}

@font-face {
    font-family: 'sharebold';
    src: url('/assets/fonts/share-bold-webfont.woff2') format('woff2'),
         url('/assets/fonts/share-bold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'sharebold_italic';
    src: url('/assets/fonts/share-bolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/share-bolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'shareitalic';
    src: url('/assets/fonts/share-italic-webfont.woff2') format('woff2'),
         url('/assets/fonts/share-italic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'shareregular';
    src: url('/assets/fonts/share-regular-webfont.woff2') format('woff2'),
         url('/assets/fonts/share-regular-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}

@font-face {
    font-family: 'noto_sansbold';
    src: url('/assets/fonts/notosans-bold-webfont.woff2') format('woff2'),
         url('/assets/fonts/notosans-bold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'noto_sansbold_italic';
    src: url('/assets/fonts/notosans-bolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/notosans-bolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'noto_sansitalic';
    src: url('/assets/fonts/notosans-italic-webfont.woff2') format('woff2'),
         url('/assets/fonts/notosans-italic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'noto_sansregular';
    src: url('/assets/fonts/notosans-regular-webfont.woff2') format('woff2'),
         url('/assets/fonts/notosans-regular-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsitalic';
    src: url('/assets/fonts/poppins-italic-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-italic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sansbold';
    src: url('/assets/fonts/opensans-bold-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-bold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sansbold_italic';
    src: url('/assets/fonts/opensans-bolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-bolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sansextrabold';
    src: url('/assets/fonts/opensans-extrabold-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-extrabold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sansextrabold_italic';
    src: url('/assets/fonts/opensans-extrabolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-extrabolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sansitalic';
    src: url('/assets/fonts/opensans-italic-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-italic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sanslight';
    src: url('/assets/fonts/opensans-light-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-light-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sanslight_italic';
    src: url('/assets/fonts/opensans-lightitalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-lightitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sansregular';
    src: url('/assets/fonts/opensans-regular-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-regular-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sanssemibold';
    src: url('/assets/fonts/opensans-semibold-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-semibold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'open_sanssemibold_italic';
    src: url('/assets/fonts/opensans-semibolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/opensans-semibolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsthin';
    src: url('assets/fonts/poppins-thin-webfont.woff2') format('woff2'),
         url('assets/fonts/poppins-thin-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsthin_italic';
    src: url('assets/fonts/poppins-thinitalic-webfont.woff2') format('woff2'),
         url('assets/fonts/poppins-thinitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsextralight';
    src: url('/assets/fonts/poppins-extralight-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-extralight-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsextralight_italic';
    src: url('/assets/fonts/poppins-extralightitalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-extralightitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinslight';
    src: url('assets/fonts/poppins-light-webfont.woff2') format('woff2'),
         url('assets/fonts/poppins-light-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinslight_italic';
    src: url('assets/fonts/poppins-lightitalic-webfont.woff2') format('woff2'),
         url('assets/fonts/poppins-lightitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsregular';
    src: url('assets/fonts/poppins-regular-webfont.woff2') format('woff2'),
         url('assets/fonts/poppins-regular-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsmedium';
    src: url('assets/fonts/poppins-medium-webfont.woff2') format('woff2'),
         url('assets/fonts/poppins-medium-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsmedium_italic';
    src: url('/assets/fonts/poppins-mediumitalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-mediumitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinssemibold';
    src: url('/assets/fonts/poppins-semibold-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-semibold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinssemibold_italic';
    src: url('/assets/fonts/poppins-semibolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-semibolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsbold';
    src: url('/assets/fonts/poppins-bold-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-bold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsbold_italic';
    src: url('/assets/fonts/poppins-bolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-bolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsextrabold';
    src: url('/assets/fonts/poppins-extrabold-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-extrabold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsextrabold_italic';
    src: url('/assets/fonts/poppins-extrabolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-extrabolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsblack';
    src: url('assets/fonts/poppins-black-webfont.woff2') format('woff2'),
         url('assets/fonts/poppins-black-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}
@font-face {
    font-family: 'poppinsblack_italic';
    src: url('/assets/fonts/poppins-blackitalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/poppins-blackitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;
}

@font-face {
    font-family: 'robotobold';
    src: url('/assets/fonts/roboto-bold-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-bold-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotoblack_italic';
    src: url('/assets/fonts/roboto-blackitalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-blackitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotoblack';
    src: url('/assets/fonts/roboto-black-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-black-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotobold_italic';
    src: url('/assets/fonts/roboto-bolditalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-bolditalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotomedium_italic';
    src: url('/assets/fonts/roboto-mediumitalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-mediumitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotomedium';
    src: url('assets/fonts/roboto-medium-webfont.woff2') format('woff2'),
         url('assets/fonts/roboto-medium-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotoitalic';
    src: url('/assets/fonts/roboto-italic-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-italic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotoregular';
    src: url('/assets/fonts/roboto-regular-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-regular-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotolight_italic';
    src: url('/assets/fonts/roboto-lightitalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-lightitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotolight';
    src: url('assets/fonts/roboto-light-webfont.woff2') format('woff2'),
         url('assets/fonts/roboto-light-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotothin_italic';
    src: url('/assets/fonts/roboto-thinitalic-webfont.woff2') format('woff2'),
         url('/assets/fonts/roboto-thinitalic-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}
@font-face {
    font-family: 'robotothin';
    src: url('assets/fonts/roboto-thin-webfont.woff2') format('woff2'),
         url('assets/fonts/roboto-thin-webfont.woff') format('woff');
    font-weight: normal;
    font-style: normal;

}

iframe html{ color:#FFF; }

body{ background:#e1f5fe; font-family: poppinsregular; font-size: 15px; }
table tr td{ padding-right:20px; }
table tr td.p{ font-family:poppinsthin; font-size: 17px;color:#000; padding-bottom:20px; }

table tr td.blabel{ font-family: poppinsmedium; padding: 0px 20px 0px 0; font-size: 18px; }
table tr td.blabel input[type=text]{
	width:100%; padding:12px; font-family: poppinsmedium; font-size:18px;
	height: 34px; border-radius:0px; border:2px solid rgba(0,0,0,0);
}

table tr td.slabel{ font-family: poppinslight; padding:0px 20px 0px 0; }
table tr td.tlabel{ font-family: poppinslight; font-size: 14px; padding:0px 20px 0px 0; }

table tr td input[type=text].table{ width:250px; color:#222; background:#FFF }
table tr td input[type=text].match{
	width:100%; padding:12px; font-family: poppinslight; font-size:18px; color: #000;
	height: 34px; border-radius:0px; border:2px solid rgba(0,0,0,0); background: #d1eefc;
}
table tr td input[type=text].action{
	width:100%; padding:12px; font-family: poppinslight; font-size:18px; color: #000;
	height: 34px; border-radius:0px; border:2px solid rgba(0,0,0,0); background: #b3e5fc;
}
table tr td input[type=text].special{
	width:100%; padding:12px; font-family: poppinslight; font-size:18px; color: #000;
	height: 34px; border-radius:0px; border:2px solid rgba(0,0,0,0); background: #a5d6a7;
}
table tr td input[type=text].idrange{
	width:80px; padding:12px; font-family: poppinsmedium; font-size:14px; color: #03A9F4;
	height: 24px; border-radius:0px; border:2px solid rgba(0,0,0,0); background: #e1f5fe;
}

table tr td input[type=text].action2{
	border-radius:0; padding:12px; font-size:13px; color:#000; background:#e1f5fe;
	font-family: poppinsregular; border: none;
}

table tr td input[type=button].action{
	display:inline-block; text-align:center; width:auto; padding:3px 15px 4px 15px; height:34px;
	cursor:pointer; background-color:#111; border:1px solid #000; font-size: 18px; font-family: poppinslight; color:#FFF; margin:0px;
	background-color:#000; border:none;
}

table tr td select{
	display:inline-block; text-align:center; width:auto; padding:10px; font-size:24px;
	border-radius:4px; cursor:pointer; border:1px solid #111; color:#FFF; margin:0px;
	background-color:#456; border:none;
}

#bod>ol>li table{ display:none; padding-left:0px }
/*h2{ margin-top:30px; cursor:pointer; font-weight:normal }
#bod hr{ border:none; height:1px; border-top:1px dashed #111 }
#bod>ol>li b.biga{ display:inline-block; margin-right:1px; font-weight:normal; color:orange }*/
</style>
</head>

<body>

<div style='width:66%; display:inline-block; vertical-align:top' align="center"><div align="left" style='width:90%'>
	<br /><span style='font-family:poppinsmedium; font-size:32px'>Select Operation</span><br />
	<div id='bod'>
	<ol>


    <li id='t0'>
    <h2 style='font-weight:normal; font-family: poppinsregular; font-size:24px; margin-bottom: 0; cursor:pointer' onclick="expandItem('t0')">Find & Replace</h2>
    <form action="<?php echo $base_url; ?>/ops_engines/find_and_replace.php" method="post" target="resframe">
    <table cellpadding="0px" cellspacing="0px" style="font-size:18px">
    <tr><td class='p' colspan="2">Values will be picked from the 'Replace' Column(s) of 'Table 1' and substituted in the 'Replace' Column(s) of 'Table 2' where the 'Match' Column(s) of both tables agree.</td></tr>
    <tr>
        <td class='blabel' style='width:20%'><b>Table 1</b></td>
        <td class='blabel' style='width:80%'><input type="text" title="t0_1" onfocus="hL('t0_1')" class="table" name="t1_name" value="find_table" /></td>
    </tr>
    <tr>
        <td class='slabel'>Match</td>
        <td><input type="text" title="t0_2" onfocus="hL('t0_2')" class="match" name="t1_match_cols" /></td>
    </tr>
    <tr>
        <td class='slabel'>Replace</td>
        <td><input type="text" title="t0_3" onfocus="hL('t0_3')" class="action" name="t1_replace_cols" /></td>
    </tr>
    <tr>
        <td class='slabel'>ID from</td>
        <td><input type="text" class="action2" name="id_from" value="1" /></td>
    </tr>
    <tr>
        <td class='slabel'>ID to</td>
        <td><input type="text" class="action2" name="id_to" value="End" /></td>
    </tr>
    <tr><td colspan="2">&nbsp;</td></tr>
    <tr>
        <td class='blabel'><b>Table 2</b></td>
        <td class='blabel'><input type="text" title="t0_1" onfocus="hL('t0_1')" class="t1_1 table" name="t2_name" value="replace_table" /></td>
    </tr>
    <tr>
        <td class='slabel'>Match</td>
        <td><input type="text" title="t0_2" onfocus="hL('t0_2')" class="t0_2 match" name="t2_match_cols" /></td>
    </tr>
    <tr>
        <td class='slabel'>Replace</td>
        <td><input type="text" title="t0_3" onfocus="hL('t0_3')" class="t0_3 action" name="t2_replace_cols" /></td>
    </tr>
    <tr><td colspan="2"><br /></td></tr>
    <tr>
        <td>&nbsp;</td>
        <td><input class='action' type="button" value="Execute" onclick="runScript('t0')" /></td>
    </tr>
    </table>
    </form>
    </li>



	<li id='t1'>
	<h2 style='font-weight:normal; font-family: poppinsregular; font-size:24px; margin-bottom: 0; cursor:pointer' onclick="expandItem('t1')">Pick & Replace Sequencial</h2>
	<form action="<?php echo $base_url; ?>/ops_engines/pick_and_replace.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr><td class='p' colspan="2">A find and replace that additionally matches the available Sequential Column number(s) before replacing.</td></tr>
	<tr>
		<td class='blabel' style='width:20%'>Table 1</td>
		<td class='blabel' style='width:80%'><input type="text" title="t1_1" onfocus="hL('t1_1')" class="table" name="t1_name" value="pick_table" /></td>
	</tr>
	<tr>
		<td class='slabel'>Find</td>
		<td><input type="text" title="t1_2" onfocus="hL('t1_2')" class="match" name="t1_find" value="find" /></td>
	</tr>
	<tr>
		<td class='slabel'>Replace</td>
		<td><input type="text" title="t1_3" onfocus="hL('t1_3')" class="action" name="t1_replace" value="replace" /></td>
	</tr>
	<!-- <tr>
		<td class='tlabel' style='font-family:poppinsmedium; color:#03A9F4'>ID Range</td>
		<td><input class='idrange' type="text" name="id_from" value="1" onfocus="unHL()" /> <span style='font-size: 14px; font-family:poppinsmedium; color:#03A9F4'>&nbsp;&nbsp;to&nbsp;&nbsp;</span> <input class='idrange' type="text" name="id_to" value="End" onfocus="unHL()" /></td>
	</tr> -->
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td class='blabel'>Table 2</td>
		<td class='blabel'><input type="text" title="t1_1" onfocus="hL('t1_1')" class="t1_1 table" name="t2_name" value="replace_table" /></td>
	</tr>
	<tr>
		<td class='slabel'>Find</td>
		<td><input type="text" title="t1_2" onfocus="hL('t1_2')" class="t1_2 match" name="t2_find" value="find" /></td>
	</tr>
	<tr>
		<td class='slabel'>Replace</td>
		<td><input type="text" title="t1_3" onfocus="hL('t1_3')" class="t1_3 action" name="t2_replace" value="replace" /></td>
	</tr>
	<tr>
		<td class='slabel'>Sequential</td>
		<td><input class='special' type="text" name="t2_sequencial" onfocus="unHL()" value="unique" /></td>
	</tr>
	<tr><td colspan="2"><br /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input class='action' type="button" value="Execute" onclick="runScript('t1')" /></td>
	</tr>
	</table><br /><br />
	</form>
	</li>

	<!--<li id='pstyleclean'>
	<h2 onclick="expandItem('pstyleclean')">Clean Table (Prefixes Style)</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/prefixes_oriented_cleaning.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td>Source to Clean</td>
		<td><input type="text" name="source_t" value='' /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('pstyleclean')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='removewithparen'>
	<h2 onclick="expandItem('removewithparen')">Remove By Parenthesis in File Name</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/remove_withparenthesis.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td>Parent Folder</td>
		<td><input class='action' type="file" onchange="selectFolder(event);" webkitdirectory mozdirectory msdirectory odirectory directory multiple="multiple" style="width:800px" /><input type="hidden" name="path_to_folder" id="path_to_folder" value='' /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('removewithparen')" /></td>
	</tr>
	</table>
	</form>
	</li>
	
	<li id='val_gam'>
	<h2 onclick="expandItem('val_gam')">Gambia Valuation Audit</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/valuation_gha.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Duty calculation will be done for each row in the provided data source table.</td></tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 10px 0; font-size:13px; width:20%'><b>Data Source Table</b></td>
	</tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 4px 0; font-size:13px; width:80%'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" class="table" name="t1_name" value="audit_gambia" /></td>
	</tr>
	<tr>
		<td colspan='2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px; width:80px'><span style='display:inline-block; width:100px'>ID from</span> <input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_from" value="1" /></td>
	</tr>
	<tr>
		<td colspan='2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px; width:80px'><span style='display:inline-block; width:100px'>ID to</span> <input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_to" value="10" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('val_gam')" /></td>
	</tr>
	</table>
	</form>
	</li>



	<li id='val_gha'>
	<h2 onclick="expandItem('val_gha')">Ghana Valuation Audit</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/valuation_gha.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Duty calculation will be done for each row in the provided data source table.</td></tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 10px 0; font-size:13px; width:20%'><b>Data Source Table</b></td>
	</tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 4px 0; font-size:13px; width:80%'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" class="table" name="t1_name" value="audit_ghana" /></td>
	</tr>
	<tr>
		<td colspan='2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px; width:80px'><span style='display:inline-block; width:100px'>ID from</span> <input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_from" value="1" /></td>
	</tr>
	<tr>
		<td colspan='2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px; width:80px'><span style='display:inline-block; width:100px'>ID to</span> <input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_to" value="10" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('val_gha')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='val_nig'>
	<h2 onclick="expandItem('val_nig')">Nigeria Valuation Audit</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/valuation_nig.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Duty calculation will be done for each row in the provided data source table.</td></tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 10px 0; font-size:13px; width:20%'><b>Data Source Table</b></td>
	</tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 4px 0; font-size:13px; width:80%'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" class="table" name="t1_name" value="nigeria_audit" /></td>
	</tr>
	<tr>
		<td colspan='2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px; width:80px'><span style='display:inline-block; width:100px'>ID from</span> <input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_from" value="1" /></td>
	</tr>
	<tr>
		<td colspan='2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px; width:80px'><span style='display:inline-block; width:100px'>ID to</span> <input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_to" value="End" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('val_nig')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='rstatrepl'>
	<h2 onclick="expandItem('rstatrepl')">Recalc. UNDER / OVER / NORM Placement</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/rstatus_placement.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Assigns '<b>under</b>', '<b>over</b>' or '<b>norm</b>' to recalculated rows for reporting purposes.</td></tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 0px 0; font-size:13px; width:80%'><select style='width:200px; height:50px; padding:5px 12px 5px 12px; font-size:19px; background:#bfebfa; color:#000; border:none' class="table" name="t1_name">
			<option>- Select table -</option>
            <option>rc_uscars</option>
            <option>rc_jacars</option>
            <option>rc_eucars</option>
            <option>rc_aecars</option>
            <option>rc_eutrucks</option>
            <option>rc_heavyequip</option>
            <option>rc_motorbikes</option>
		</select></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>ID from</td>
		<td style='padding:1px 20px 1px 0px; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_from" value="1" /></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>ID to</td>
		<td style='padding:1px 20px 1px 0; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_to" value="End" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('rstatrepl')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='spanyears'>
	<h2 onclick="expandItem('spanyears')">Span Years</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/spanyears.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2"></td></tr>
	<tr>
		<td style='padding:0px 20px 0px 0; font-size:13px; width:20%'><b>Table Name</b></td>
		<td style='padding:0px 20px 0px 0; font-size:13px; width:80%'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" class="table" name="t1_name" value="" /></td>
	</tr>
	<tr>
		<td style='padding:0px 20px 0px 0; font-size:13px'>Match Column</td>
		<td style='padding:0px 20px 0px 0; font-size:13px'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" class="match" name="t1_match_col" value="" /></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>Year-Begin Column</td>
		<td style='padding:1px 20px 1px 0px; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:160px' type="text" class="action2" name="year_from" /></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>Year-End Column</td>
		<td style='padding:1px 20px 1px 0; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:160px' type="text" class="action2" name="year_to" /></td>
	</tr>
	<tr>
		<td colspan="2"><b>Note :</b> A table, named in the format <i>"1_MOYD_YEARS_DDMMYY"</i>, will be created to hold the results.<br />If such a table already exists, it will be replaced.</td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	//<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('spanyears')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='recalc'>
	<h2 onclick="expandItem('recalc')">Recalculation</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/recalculation.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Duty calculation will be done for each row in the provided data source table.</td></tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 10px 0; font-size:13px; width:20%'><b>Data Source Table</b></td>
	</tr>
	<tr>
		<td colspan='2' style='padding:0px 20px 4px 0; font-size:13px; width:80%'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" class="table" name="t1_name" value="" /></td>
	</tr>
	<tr>
		<td colspan='2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px; width:80px'><span style='display:inline-block; width:100px'>ID from</span> <input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_from" value="1" /></td>
	</tr>
	<tr>
		<td colspan='2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px; width:80px'><span style='display:inline-block; width:100px'>ID to</span> <input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_to" value="End" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('recalc')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='t1'>
	<h2 onclick="expandItem('t1')">Find & Replace Column(s)</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/find_and_replace.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Values will be picked from the 'Replace Column(s)' of 'Table 1' and substituted in the 'Replace Column(s)' of 'Table 2' where the 'Match Column(s)' of both tables agree.</td></tr>
	<tr>
		<td style='padding:0px 20px 0px 0; font-size:13px; width:20%'><b>Table 1</b></td>
		<td style='padding:0px 20px 0px 0; font-size:13px; width:80%'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" title="t1_1" onfocus="hL('t1_1')" class="table" name="t1_name" value="temp_find" /></td>
	</tr>
	<tr>
		<td style='padding:0px 20px 0px 0; font-size:13px'>Match Column(s)</td>
		<td style='padding:0px 20px 0px 0; font-size:13px'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" title="t1_2" onfocus="hL('t1_2')" class="match" name="t1_match_cols" value="find" /></td>
	</tr>
	<tr>
		<td style='padding:0px 20px 0px 0px; font-size:13px'>Replace Column(s)</td>
		<td style='padding:0px 20px 0px 0; font-size:13px'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" title="t1_3" onfocus="hL('t1_3')" class="action" name="t1_replace_cols" value="replace" /></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>ID from</td>
		<td style='padding:1px 20px 1px 0px; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_from" value="1" /></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>ID to</td>
		<td style='padding:1px 20px 1px 0; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:60px' type="text" class="action2" name="id_to" value="End" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table 2</b></td>
		<td><input type="text" title="t1_1" onfocus="hL('t1_1')" class="t1_1 table" name="t2_name" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" title="t1_2" onfocus="hL('t1_2')" class="t1_2 match" name="t2_match_cols" /></td>
	</tr>
	<tr>
		<td>Replace Column(s)</td>
		<td><input type="text" title="t1_3" onfocus="hL('t1_3')" class="t1_3 action" name="t2_replace_cols" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('t1')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='expansyear'>
	<h2 onclick="expandItem('expansyear')">Prefixing</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/expansion_years.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Expands the rows of 'Payload Table' into automatically created 'Results Table' using 'Guide Table' as the guide.</td></tr>
	<tr>
		<td><b>Guide Table</b></td>
		<td><input type="text" class="table" name="t1_name" value="moyd_years" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" value="code, year" name="t1_match_cols" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Payload Table</b></td>
		<td><input type="text" class="table" name="t2_name" value="prefixing_base" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" value="symbol, year" name="t2_match_cols" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td>Radius</td>
		<td><input style='width:50px' type="text" class="match" name="radius" value="10" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td colspan="2"><b>Note :</b> A table, named in the format <i>"1_prefixing_DDMMYY"</i>, will be created to hold the results.<br />If such a table already exists, it will be replaced.</td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('expansyear')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='prefixselector'>
	<h2 onclick="expandItem('prefixselector')">Prefix Selector</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/prefix_selector.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Runs the Prefix Selector</td></tr>
	<tr>
		<td><b>Table Name</b></td>
		<td><input type="text" class="table" name="t1_name" value="prefix_selector" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('prefixselector')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='years_minmax'>
	<h2 onclick="expandItem('years_minmax')"><b class='biga'>Yrs</b>: Cars Year From / To</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/min_and_max.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Retrieves the Minimum and the Maximum value in range and updates as specified.</td></tr>
	<tr>
		<td><b>Table of Match-Column</b></td>
		<td><input type="text" class="table" name="col_to_match_t" value="yeartable" /></td>
	</tr>
	<tr>
		<td>Match-Column</td>
		<td><input type="text" class="match" name="col_to_match" value="vdsplus" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Focus-Columns</b></td>
		<td><input type="text" class="table" name="col_to_focus_on_t" value="yeartable" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Min</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_min" value="year" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Max</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_max" value="year" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Update-Columns</b></td>
		<td><input type="text" class="table" name="col_to_update_t" value="yeartable" /></td>
	</tr>
	<tr>
		<td>Update-Column for Min</td>
		<td><input type="text" class="action" name="col_to_update_with_min" value="vin_from" /></td>
	</tr>
	<tr>
		<td>Update-Column for Max</td>
		<td><input type="text" class="action" name="col_to_update_with_max" value="vin_to" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('years_minmax')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='yearsbz_minmax'>
	<h2 onclick="expandItem('yearsbz_minmax')"><b class='biga'>Yrs</b>: Benz Year From / To</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/min_and_max.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td><b>Table of Match-Column</b></td>
		<td><input type="text" class="table" name="col_to_match_t" value="yeartable_benz" /></td>
	</tr>
	<tr>
		<td>Match-Column</td>
		<td><input type="text" class="match" name="col_to_match" value="vdsplus" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Focus-Columns</b></td>
		<td><input type="text" class="table" name="col_to_focus_on_t" value="yeartable_benz" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Min</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_min" value="year" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Max</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_max" value="year" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Update-Columns</b></td>
		<td><input type="text" class="table" name="col_to_update_t" value="yeartable_benz" /></td>
	</tr>
	<tr>
		<td>Update-Column for Min</td>
		<td><input type="text" class="action" name="col_to_update_with_min" value="vin_from" /></td>
	</tr>
	<tr>
		<td>Update-Column for Max</td>
		<td><input type="text" class="action" name="col_to_update_with_max" value="vin_to" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('yearsbz_minmax')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='yearsjp_minmax'>
	<h2 onclick="expandItem('yearsjp_minmax')"><b class='biga'>Yrs</b>: Japan Year From / To</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/min_and_max.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td><b>Table of Match-Column</b></td>
		<td><input type="text" class="table" name="col_to_match_t" value="yeartable_jp" /></td>
	</tr>
	<tr>
		<td>Match-Column</td>
		<td><input type="text" class="match" name="col_to_match" value="platform3" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Focus-Columns</b></td>
		<td><input type="text" class="table" name="col_to_focus_on_t" value="yeartable_jp" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Min</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_min" value="year" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Max</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_max" value="year" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Update-Columns</b></td>
		<td><input type="text" class="table" name="col_to_update_t" value="yeartable_jp" /></td>
	</tr>
	<tr>
		<td>Update-Column for Min</td>
		<td><input type="text" class="action" name="col_to_update_with_min" value="vin_from" /></td>
	</tr>
	<tr>
		<td>Update-Column for Max</td>
		<td><input type="text" class="action" name="col_to_update_with_max" value="vin_to" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('yearsjp_minmax')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='t1_type2'>
	<h2 onclick="expandItem('t1_type2')">Find & Replace Column(s) Type 2</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/find_and_replace_type_2.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Values will be picked from the 'Replace Column(s)' of 'Table 1' and substituted in the 'Replace Column(s)' of 'Table 2' where the 'Match Column(s)' of both tables agree.</td></tr>
	<tr>
		<td><b>Table 1</b></td>
		<td><input type="text" class="table" name="t1_name" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t1_match_cols" /></td>
	</tr>
	<tr>
		<td>Replace Column(s)</td>
		<td><input type="text" class="action" name="t1_replace_cols" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table 2</b></td>
		<td><input type="text" class="table" name="t2_name" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t2_match_cols" /></td>
	</tr>
	<tr>
		<td>Replace Column(s)</td>
		<td><input type="text" class="action" name="t2_replace_cols" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('t1_type2')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='fnr_wupd'>
	<h2 onclick="expandItem('fnr_wupd')">US_VINPrefixes: Find & Replace Column(s) With Update</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/find_and_replace_wupd.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Values will be picked from the 'Replace Column(s)' of 'Table 1' and substituted in the 'Replace Column(s)' of 'Table 2' where the 'Match Column(s)' of both tables agree.</td></tr>
	<tr>
		<td><b>Table 1</b></td>
		<td><input type="text" class="table" name="t1_name" value="vinprefixes_feeder" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t1_match_cols" value="vdsplus" /></td>
	</tr>
	<tr>
		<td>Replace Column(s)</td>
		<td><input type="text" class="action" name="t1_replace_cols" value="vin" /></td>
	</tr>
	<tr>
		<td></td>
		<td>On failure, replace <input style='border:1px dashed #567; border-radius:4px; width:200px; height:20px; font-size:16px' type="text" class="match" name="fnr_updt_col" value="unmatched" /> with <input style='border:1px dashed #567; border-radius:4px; width:50px; height:20px; font-size:16px' type="text" class="match" name="fnr_updt_val" value="*" /></td>
	</tr>

	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table 2</b></td>
		<td><input type="text" class="table" name="t2_name" value="us_vinprefixes_new" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t2_match_cols" value="vdsplus" /></td>
	</tr>
	<tr>
		<td>Replace Column(s)</td>
		<td><input type="text" class="action" name="t2_replace_cols" value="vin" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('fnr_wupd')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='t3'>
	<h2 onclick="expandItem('t3')">Find & Load Column(s)</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/find_and_load.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Values will be picked from the 'Load Column(s)' of 'Table 2' and substituted in the 'Load Column(s)' of 'Table 1' where the 'Match Column(s)' of both tables agree.</td></tr>
	<tr>
		<td><b>Table 1</b></td>
		<td><input type="text" class="table" name="t1_name" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t1_match_cols" /></td>
	</tr>
	<tr>
		<td>Load Column(s)</td>
		<td><input type="text" class="action" name="t1_insert_cols" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table 2</b></td>
		<td><input type="text" class="table" name="t2_name" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t2_match_cols" /></td>
	</tr>
	<tr>
		<td>Load Column(s)</td>
		<td><input type="text" class="action" name="t2_pick_cols" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('t3')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='mapt_mtfnl'>
	<h2 onclick="expandItem('mapt_mtfnl')">Find & Load Column(s) :MatchThrough</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/matchthrough_find_and_load.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Values will be picked from the 'Load Column(s)' of 'Table 2' and substituted in the 'Indicator Column(s)' of 'Table 1' where ANY of the 'Match Column(s)' of both tables agree. Where 'Filter Condition' is provided, only rows matching it will be considered. For each 'Match Column' of 'Table 1' there should be an extra column with same name but appended with '_mt' for placing the matched items where available.</td></tr>
	<tr>
		<td><b>Table 1</b></td>
		<td><input type="text" class="table" name="t1_name" value="" /><input type="text" class="action" name="t1_filter_cond" value="" style="width:524px; background:none; color:#888" placeholder="filter condition" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t1_match_cols" value="" /></td>
	</tr>
	<tr>
		<td>Load Column(s)</td>
		<td><input type="text" class="action" name="t1_insert_cols" value="" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table 2</b></td>
		<td><input type="text" class="table" name="t2_name" value="" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t2_match_cols" value="" /></td>
	</tr>
	<tr>
		<td>Load Column(s)</td>
		<td><input type="text" class="action" name="t2_pick_cols" value=""/></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('mapt_mtfnl')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='insert_wunava'>
	<h2 onclick="expandItem('insert_wunava')">Insert Where Unavailable</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/insert_where_unavailable.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Fills in the 'Destination Table' with Rows from the 'Source Table' where a match is not found.</td></tr>
	<tr>
		<td><b>Source Table</b></td>
		<td><input type="text" class="table" name="source_t" value="" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="source_t_match_cols" value="" /></td>
	</tr>
	<tr>
		<td>Pick Column(s)</td>
		<td><input type="text" class="action" name="source_t_pick_cols" value="" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Destination Table</b></td>
		<td><input type="text" class="table" name="destination_t" value="" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="destination_t_match_cols" value="" /></td>
	</tr>
	<tr>
		<td>Insert Column(s)</td>
		<td><input type="text" class="action" name="destination_t_insert_cols" value="" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('insert_wunava')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='trim_cols'>
	<h2 onclick="expandItem('trim_cols')">Trim and Clean Columns</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/trim_and_clean_columns.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Trims and Cleans the Specified Columns.</td></tr>
	<tr>
		<td><b>Source Table</b></td>
		<td><input type="text" class="table" name="source_t" value="" /></td>
	</tr>
	<tr>
		<td>Column(s)</td>
		<td><input type="text" class="action" name="source_t_match_cols" value="" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr><td colspan="2"><label><input type="checkbox" name="doclean" value="yes" /> <b>Clean the Column(s) as well</b></label></td></tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td>Replace these</td>
		<td><input type="text" style="width:250px" class="match" name="find_chars" value="" /></td>
	</tr>
	<tr>
		<td>With</td>
		<td><input type="text" style="width:250px" class="match" name="replace_chars" value="" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('trim_cols')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='mapt_minmax'>
	<h2 onclick="expandItem('mapt_minmax')"><b class='biga'>&lrarr; MTest</b>: MAYDCARS Step 2 | Min and Max Years</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/min_and_max.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Retrieves the Minimum and the Maximum value in range and updates as specified.</td></tr>
	<tr>
		<td><b>Table of Match-Column</b></td>
		<td><input type="text" class="table" name="col_to_match_t" value="maptest_mayd_cars" /></td>
	</tr>
	<tr>
		<td>Match-Column</td>
		<td><input type="text" class="match" name="col_to_match" value="vdsplus" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Focus-Columns</b></td>
		<td><input type="text" class="table" name="col_to_focus_on_t" value="yeartable" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Min</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_min" value="year" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Max</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_max" value="year" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Update-Columns</b></td>
		<td><input type="text" class="table" name="col_to_update_t" value="maptest_mayd_cars" /></td>
	</tr>
	<tr>
		<td>Update-Column for Min</td>
		<td><input type="text" class="action" name="col_to_update_with_min" value="yearbegin" /></td>
	</tr>
	<tr>
		<td>Update-Column for Max</td>
		<td><input type="text" class="action" name="col_to_update_with_max" value="yearend" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('mapt_minmax')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='minmax_loose_match'>
	<h2 onclick="expandItem('minmax_loose_match')">Min and Max Loose Match</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/min_and_max_loose_match.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Retrieves the Minimum and the Maximum value in range and updates as specified.</td></tr>
	<tr>
		<td><b>Table of Match-Column</b></td>
		<td><input type="text" class="table" name="col_to_match_t" value="" /></td>
	</tr>
	<tr>
		<td>Match-Column</td>
		<td><input type="text" class="match" name="col_to_match" value="" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Focus-Columns</b></td>
		<td><input type="text" class="table" name="col_to_focus_on_t" value="" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Min</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_min" value="" /></td>
	</tr>
	<tr>
		<td>Focus-Column for Max</td>
		<td><input type="text" class="match" name="col_to_focus_on_for_max" value="" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table of Update-Columns</b></td>
		<td><input type="text" class="table" name="col_to_update_t" value="" /></td>
	</tr>
	<tr>
		<td>Update-Column for Min</td>
		<td><input type="text" class="action" name="col_to_update_with_min" value="" /></td>
	</tr>
	<tr>
		<td>Update-Column for Max</td>
		<td><input type="text" class="action" name="col_to_update_with_max" value="" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('minmax_loose_match')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='mapt_t3'>
	<h2 onclick="expandItem('mapt_t3')"><b class='biga'>&lrarr; MTest</b>: MAYDCARS Step 3 | Complete Matches</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/find_and_load.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Values will be picked from the 'Load Column(s)' of 'Table 2' and substituted in the 'Load Column(s)' of 'Table 1' where the 'Match Column(s)' of both tables agree.</td></tr>
	<tr>
		<td><b>Table 1</b></td>
		<td><input type="text" class="table" name="t1_name" value="maptest_benzmodule" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t1_match_cols" value="model_level_one, body_code, fuel_type, capacity, doors, mid_year" /></td>
	</tr>
	<tr>
		<td>Load Column(s)</td>
		<td><input type="text" class="action" name="t1_insert_cols" value="mapping" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table 2</b></td>
		<td><input type="text" class="table" name="t2_name" value="europe_car_trims" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t2_match_cols" value="linktomodellevelone, bodycode_national, fueltype, technicalcapacityinCCM, doors, importsalestart2-importsaleend2" /></td>
	</tr>
	<tr>
		<td>Load Column(s)</td>
		<td><input type="text" class="action" name="t2_pick_cols" value="linktomodel" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('mapt_t3')" /></td>
	</tr>
	</table>
	</form>
	</li>


	<li id='mtfnl'>
	<h2 onclick="expandItem('mtfnl')"><b class='biga'>&lrarr; MTest</b>: MAYDCARS Step 4 | Incomplete Matches</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/matchthrough_find_and_load.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2">Values will be picked from the 'Load Column(s)' of 'Table 2' and substituted in the 'Indicator Column(s)' of 'Table 1' where ANY of the 'Match Column(s)' of both tables agree. Where 'Filter Condition' is provided, only rows matching it will be considered. For each 'Match Column' of 'Table 1' there should be an extra column with same name but appended with '_mt' for placing the matched items where available.</td></tr>
	<tr>
		<td><b>Table 1</b></td>
		<td><input type="text" class="table" name="t1_name" value="maptest_mayd_cars" /><input type="text" class="action" name="t1_filter_cond" value="audit=''" style="width:524px; background:none; color:#888" placeholder="filter condition" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t1_match_cols" value="model_level_one, body_code, fuel_type, capacity, doors, transmission, yearbegin, yearend" /></td>
	</tr>
	<tr>
		<td>Load Column(s)</td>
		<td><input type="text" class="action" name="t1_insert_cols" value="atm_import_start, atm_import_end" /></td>
	</tr>
	<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td><b>Table 2</b></td>
		<td><input type="text" class="table" name="t2_name" value="europe_car_trims" /></td>
	</tr>
	<tr>
		<td>Match Column(s)</td>
		<td><input type="text" class="match" name="t2_match_cols" value="model_level_one, body_code, fuel_type, capacity, doors, transmission, yearbegin_start-yearbegin_end, yearend_start-yearend_end" /></td>
	</tr>
	<tr>
		<td>Load Column(s)</td>
		<td><input type="text" class="action" name="t2_pick_cols" value="atm_import_start, atm_import_end" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('mtfnl')" /></td>
	</tr>
	</table>
	</form>
	</li>




	
	<li id='mptt'>
	<h2 onclick="expandItem('mptt')">Mapping Test</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/mapping_test.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td>VIN Source Table</td>
		<td><input type="text" class="table" name="t_name" value="" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('mptt')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='rfn'>
	<h2 onclick="expandItem('rfn')">Read File Names</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/file_names_reader.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td>Path to Folder</td>
		<td><input class='action' type="text" style="width:800px" name="path_to_folder" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('rfn')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='rdupfiles'>
	<h2 onclick="expandItem('rdupfiles')" style='font-weight:bold'>Photo Duplicate Remover</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/photo_duplicate_remover.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td style='width:150px'>Enter Folder Path</td>
		<td style='width:700px'><input style='color:#000' class='action' type="text" style="width:100%" name="path_to_folder" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Remove Duplicates" onclick="runScript('rdupfiles')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='renamefiles'>
	<h2 onclick="expandItem('renamefiles')" style='font-weight:bold'>MBS Photo Renaming</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/photo_renamer.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td style='width:150px'>Enter Folder Path</td>
		<td style='width:700px'><input style='color:#000' class='action' type="text" style="width:100%" name="path_to_folder" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Start Renaming" onclick="runScript('renamefiles')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='reffiller'>
	<h2 onclick="expandItem('reffiller')" style='font-weight:bold'>References Filler</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/fill_references.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td style='width:150px'>Enter Table Name</td>
		<td style='width:700px'><input style='color:#000' class='action' type="text" style="width:100%" name="t1_name" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Fill References" onclick="runScript('reffiller')" /></td>
	</tr>
	</table>
	</form>
	</li>



	<li id='yearspan_enumerator'>
	<h2 onclick="expandItem('yearspan_enumerator')">Year-Span Enumerator</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/year_span_enumerator.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr class='p'><td colspan="2"></td></tr>
	<tr>
		<td style='padding:0px 20px 0px 0; font-size:13px; width:20%'><b>Table Name</b></td>
		<td style='padding:0px 20px 0px 0; font-size:13px; width:80%'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" class="table" name="t1_name" value="" /></td>
	</tr>
	<tr>
		<td style='padding:0px 20px 0px 0; font-size:13px'>Match Column</td>
		<td style='padding:0px 20px 0px 0; font-size:13px'><input style='padding:5px 12px 5px 12px; font-size:15px' type="text" class="match" name="t1_match_col" value="" /></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>Year-Begin Column</td>
		<td style='padding:1px 20px 1px 0px; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:160px' type="text" class="action2" name="year_from" /></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>Year End Column</td>
		<td style='padding:1px 20px 1px 0; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:160px' type="text" class="action2" name="year_to" /></td>
	</tr>
	<tr>
		<td class='action2' style='border-radius:4px 0 0 4px; padding:1px 20px 1px 20px; font-size:13px'>Specific Year Column</td>
		<td style='padding:1px 20px 1px 0; font-size:13px'><input style='border-radius:0 4px 4px 0; padding:5px 12px 5px 12px; font-size:15px; width:160px' type="text" class="action2" name="year" /></td>
	</tr>
	<tr>
		<td colspan="2"><b>Note :</b> A table, named in the format <i>"1_enum_years_DDMMYY"</i>, will be created to hold the results.<br />If such a table already exists, it will be replaced.</td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	//<tr><td colspan="2">&nbsp;</td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Execute" onclick="runScript('yearspan_enumerator')" /></td>
	</tr>
	</table>
	</form>
	</li>
	<li id='seqsplit'>
	<h2 onclick="expandItem('seqsplit')" style='font-weight:bold'>References Filler</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/sequence_splitter.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td style='width:150px'>Raw String</td>
		<td style='width:700px'><input style='color:#000' class='action' type="text" style="width:100%" name="rawstring" /></td>
	</tr>
	<tr>
		<td style='width:150px'>Sequence Length</td>
		<td style='width:70px'><input style='color:#000' class='action' type="text" style="width:100%" name="rawstring" /></td>
	</tr>
	<tr>
		<td style='width:150px'>Delimiter</td>
		<td style='width:70px'><input style='color:#000' class='action' type="text" style="width:100%" name="rawstring" /></td>
	</tr>
	<tr><td colspan="2"><hr /></td></tr>
	<tr>
		<td>&nbsp;</td>
		<td><input type="button" value="Sequence Split" onclick="runScript('seqsplit')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='genmisc'>
	<h2 onclick="expandItem('genmisc')">NHTSA Program</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/scriptapi.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td>NHTSA Program</td>
		<td><input type="button" value="Execute" onclick="runScript('genmisc')" /></td>
	</tr>
	</table>
	</form>
	</li>

	<li id='refnocreator'>
	<h2 onclick="expandItem('refnocreator')">Reference Master</h2>
	<form action="http://localhost/malgo/MY_OPS/ops_engines/refnocreator.php" method="post" target="resframe">
	<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	<tr>
		<td><b>Table to Use</b></td>
		<td style='width:170px'><input style='color:#000' class='action' type="text" style="width:100%" placeholder="Table name" name="table" /></td>
	</tr>
	<tr>
		<td>Focus Column</td>
		<td style='width:170px'><input style='color:#000' type="text" style="width:100%" placeholder="Focus-Col name" name="focuscolumn" /></td>
	</tr>
	<tr>
		<td>Update Column</td>
		<td style='width:170px'><input style='color:#000' type="text" style="width:100%" placeholder="Update-Col name" name="updatecolumn" /></td>
	</tr>
	<tr>
		<td>Ref to Increment</b></td>
		<td style='width:170px'><input style='color:#000' type="text" style="width:100%" placeholder="Ref" name="reference" /></td>
	</tr>
	<tr>
		<td colspan="2"><input type="button" value="Execute" onclick="runScript('refnocreator')" /></td>
	</tr>
	</table>
	</form>
	</li>
	//<li id='genmisc'>
	//<h2 onclick="expandItem('genmisc')">General</h2>
	//<form action="http://localhost/malgo/MY_OPS/ops_engines/misc.php" method="post">
	//<table cellpadding="0px" cellspacing="0px" style="font-size:18px">
	//<tr>
	//	<td>Misc Program</td>
	//	<td><input type="button" value="Execute" onclick="runScript('genmisc')" /></td>
	//</tr>
	//</table>
	//</form>
	//</li> -->
	</ul>

	</div>

</div></div>
<div style='position:fixed; height:600px; width:28%; vertical-align:top; display:inline-block; border:4px solid #000; border-radius:18px; background:#000; padding:6px 10px 6px 10px; margin-top:40px'>
	<iframe id='resf' style='color:#FFF; border:none; width:100%; height:100%' name="resframe" src="<?php echo $base_url; ?>/ops_engines/nothing.php"></iframe>
</div>


</body>
</html>