<?
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
//emable CORES headers
// Allow from any origin
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Credentials: true");
header("Access-Control-Max-Age: 1000");
header("Access-Control-Allow-Headers: X-Requested-With, Content-Type, Origin, Cache-Control, Pragma, Authorization, Accept, Accept-Encoding");
header("Access-Control-Allow-Methods: PUT, POST, GET, OPTIONS, DELETE");

//include and initialise Database PHPMaker libraries
require_once '../db.php';

//***********************GET VALUES FROM API CALL******************************************///
if((isset( $_GET['api'])) || (isset($_GET['tool'])) || (isset($_GET['model'])) || (isset($_GET['modelID']))){
$api='';
if(isset( $_GET['api'])){
$api = $_GET['api'];
}
$tool='';
if(isset( $_GET['tool'])){
$tool = $_GET['tool'];
}
$model='';
if(isset( $_GET['model'])){
$model = $_GET['model'];
}
$modelID='';
if(isset( $_GET['modelID'])){
$modelID = $_GET['modelID'];
}	
$lang='';
if(isset( $_GET['lang'])){
$lang = $_GET['lang'];
}
}


switch($api){
	case 'equipmentTech':
		getEquipmentTech($tool,$lang);
		$conn->close();	
	break;
		
	case 'toolID':
		echo(getToolID($tool));
		$conn->close();	
	break;
		
	/*case 'techdata':
		getTechDataTable($toolID);
	break;*/
		
	case 'modelID':
		echo(getModelID(getToolID($tool),$model));
		$conn->close();
	break;
		
	case 'toolModels':
		getToolModels(getToolID($tool));
		$conn->close();
	break;
		
	case 'toolModelsWithChart':
		getToolModelsWithChart(getToolID($tool));
	break;
		
	case 'modelsTargetTorque':
		getToolModelTargetTorque($modelID);
	break;
		
	case 'modelTargetTorque':
		if(isset($_GET['psi'])){
			$psi = $_GET['psi'];
		}else{
			$psi = '';
		}
		getToolModelTargetTorque($modelID,$psi);
	break;
}

/***********************GET TOOL ID ********************************************************///
function getToolID($toolName){
	$sql = "SELECT toolID from `hytorc_torcsafe_equipmgt`.`tools` where toolName LIKE '%$toolName%' limit 1";
	global $conn;
	$result = $conn->query($sql);
	$toolName;
	while($row = $result->fetch_assoc()) {
	$toolName= $row['toolID'];
	}
	return($toolName);
}

//**********************GET POWER SOURCE FOR SPECIFIC TOOL*********************************///
function getEquipmentTech($toolName,$lang){
	$sql = "SELECT `Tool_EquipmentTech_Info`.`toolID`, `Tool_EquipmentTech_Info`.`toolName`,`Tool_EquipmentTech_Info`.`equipmentTechID`,`Tool_EquipmentTech_Info`.`equipmentTech`,`equipmentTechTranslations`.`translation` from `hytorc_torcsafe_equipmgt`.`Tool_EquipmentTech_Info` INNER JOIN `hytorc_torcsafe_equipmgt`.`equipmentTechTranslations` ON `Tool_EquipmentTech_Info`.`equipmentTechID` = `equipmentTechTranslations`.`equipmentTechID` where `Tool_EquipmentTech_Info`.`toolName` LIKE '%$toolName%' and language = '$lang' limit 1  ";
	global $conn;
	$result = $conn->query($sql);
	if($result && $result->num_rows == 0){
		$sql = "SELECT * from `hytorc_torcsafe_equipmgt`.`Tool_EquipmentTech_Info` where toolName LIKE '%$toolName%' limit 1";	
		$result = $conn->query($sql);
	}
	$techTable = array();
	while($row = $result->fetch_assoc()) {
    $techTable[] = $row;
	}
	print_r(json_encode($techTable));
}

//******************* GET THE MODEL ID ********************************************************///
function getModelID($toolID,$model){
	$sql = "SELECT modelID FROM `hytorc_torcsafe_equipmgt`.`toolModel` WHERE toolID = '$toolID' AND toolName LIKE '%$model%' AND toolName NOT LIKE '%LINK' limit 1";
	global $conn;
	$result = $conn->query($sql);
	$modelID;
	while($row = $result->fetch_assoc()) {
	$modelID = $row['modelID'];
	}
	return($modelID);
}

//********************** GET ALL TOOL MODELS FOR A SPECIFIC TOOL *************************************///
function getToolModels($toolID){
	$sql = "SELECT toolID, modelID, toolName FROM `hytorc_torcsafe_equipmgt`.`toolModel` WHERE toolID = '$toolID' AND exclude = 'N' order by toolOrder";
	global $conn;
	$result = $conn->query($sql);
	$modelNames = array();
	while($row = $result->fetch_assoc()) {
    $modelNames[] = $row;
	}
	print_r(json_encode($modelNames));
}

//********************* GET ALL TOOL MODELS FOR A SPECIFIC TOOL ONLY IF TORQUE CHARD DATA EXISTS *******///
function getToolModelsWithChart($toolID){
	$sql = "SELECT DISTINCT modelName, toolID, modelID FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_Torque_Chart` WHERE toolID = '$toolID' AND exclude = 'N'";
	global $conn;
	$result = $conn->query($sql);
	$modelNames = array();
	while($row = $result->fetch_assoc()) {
    $modelNames[] = $row;
	}
	print_r(json_encode($modelNames));
}

//********************* GET Target torque when completing a calibration from the torque chart with all PSI values ********************/
function getToolModelTargetTorque($modelID,$psi){
	if($psi!=''){
	$sql = "SELECT `pressPSI`,`ft-lbs` as targetTorque FROM hytorc_torcsafe_torqueCharts.hydraulic where modelID = '$modelID' and pressPSI = '$psi'";
	}else{
	$sql = "SELECT `pressPSI`,`ft-lbs` as targetTorque FROM hytorc_torcsafe_torqueCharts.hydraulic where modelID = '$modelID'";
	}
	global $conn;
	$result = $conn->query($sql);
	$targetTorque = array();
	while($row = $result->fetch_assoc()) {
    $targetTorque[] = $row;
	}
	print_r(json_encode($targetTorque));
}
?><?
//include universal functions
require_once('functions.php');

/**************************************************************/
//API source file for all hydraulic torque chart data returns.


$tool;
$chart;
if(!empty($_GET) ){
$tool = '';
if(isset( $_GET['tool'])){
$tool = $_GET['tool'];
}
$chart='';
if(isset( $_GET['chart'])){
$chart = $_GET['chart'];
}
$modelID='';
if(isset( $_GET['modelID'])){
$modelID = $_GET['modelID'];
}

if( ($tool!=null) && ($chart!=null)){
	$toolID = (getToolID($tool));
	switch($chart){
		case 'techdata':
			getTechDataTable($toolID,'imp');
			$conn->close();	
		break;
			
		case 'techdataMet':
			getTechDataTable($toolID,'met');
			$conn->close();	
		break;
			
		case 'techdataVariant':
			getTechDataTableVariant($modelID);
			$conn->close();	
		break;
		
		case 'maxAllTorque':
			getMaxTorque();
			$conn->close();	
		break;
		
		case 'maxToolTorque':
			getMaxToolTorque($toolID,'imp');
			$conn->close();	
		break;
			
		case 'maxToolTorqueMet':
			getMaxToolTorque($toolID,'met');
			$conn->close();	
		break;
			
		case 'minToolTorque':
			getMinToolTorque($toolID,'imp');
			$conn->close();	
		break;
		
		case 'minToolTorqueMet':
			getMinToolTorque($toolID,'met');
			$conn->close();	
		break;
			
		case 'torqueRange':
			getTorqueRange($toolID,'imp');
			$conn->close();	
		break;
			
		case 'torqueRangeMet':
			getTorqueRange($toolID,'met');
			$conn->close();	
		break;
			
		case 'radiusRange':
			getRadiusRange($toolID,'imp');
			$conn->close();	
		break;
		
		case 'radiusRangeMet':
			getRadiusRange($toolID,'met');
			$conn->close();	
		break;
			
		case 'driveSizeRange':
			getDriveSizeRange($toolID);
			$conn->close();	
		break;
			
		case 'weightRange':
			getWeightRange($toolID,'imp');
			$conn->close();	
		break;
			
		case 'weightRangeMet':
			getWeightRange($toolID,'met');
			$conn->close();	
		break;
			
		case 'torqueChart':
			//model must me set for specific torque chart
			if(isset($_GET['model'])){
			$model = $_GET['model'];
			getTorqueChart(getModelID($toolID,$model));
			}
			$conn->close();	
		break;	
	}
	
}else{
	//return(error('get'));
}
}
//********************** GET TECH DATA FOR WEB DISPLAY *************************************///
function getTechDataTable($toolID,$units){
	if($units == 'imp'){
	$sql = "SELECT toolID,modelID,toolOrder,toolName,modelName,drawing,height,width,length, radius, drive,weight, FORMAT(ROUND(minTorq),0) as minTorq, FORMAT(ROUND(maxTorq),0) as maxTorq from `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID' order by toolOrder";
		global $conn;
		$result = $conn->query($sql);
		$techTable = array();
		while($row = $result->fetch_assoc()) {
		$techTable[] = $row;
		}
		print_r(json_encode($techTable));
	}else{
	$sql = "SELECT toolID,modelID,toolOrder,toolName,modelName,drawing, ROUND((height*25.4),0) as height, ROUND((width*25.4),0) as width, ROUND((length*25.4),0) as length, radius, drive, ROUND((weight*0.45359237),0) as weight, ROUND((minTorq*1.3556),0) as minTorq, ROUND((maxTorq*1.3556),0) as maxTorq from `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID' order by toolOrder";	
		global $conn;
		$result = $conn->query($sql);
		$techTable = array();
		while($row = $result->fetch_assoc()) {
		$techTable[] = $row;
		}
		//$techTable = json_decode($techTable, true);
		//$techDecode['radius'];
		$i=0;
		foreach($techTable as $item) { 
			$metRadius = getMetRadius($item['radius']);
			
			//insert converted values back into json feed
			$techTable[$i]['radius'] = $metRadius;
			$i++;
			
		}
		$techTable = json_encode($techTable, true);
		echo($techTable);
	}
	
	//print_r($techDecode[0]['radius']);
	
	//
}
//********************** GET TECH DATA FOR TOOL VARIANT *********************************/
function getTechDataTableVariant($modelID){
	$sql = "select toolModelVariant.modelID,toolModelVariant.squareDrive, toolModelVariant.weight from hytorc_torcsafe_equipmgt.toolModelVariant
inner join hytorc_torcsafe_equipmgt.toolModel on toolModel.modelID = toolModelVariant.modelID
where toolModelVariant.modelID = '$modelID'";
	global $conn;
		$result = $conn->query($sql);
		$techTable = array();
		while($row = $result->fetch_assoc()) {
		$techTable[] = $row;
		}
		$techTable = json_encode($techTable, true);
		echo($techTable);
}


//********************** GET MAX TORQUE VALUE FOR ALL TOOLS********************************///
function getMaxTorque(){
	$sql = "SELECT toolID, toolName, max(maxTorq) as maxTorq FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` GROUP by toolID";
	global $conn;
	$result = $conn->query($sql);
	$maxTable = array();
	while($row = $result->fetch_assoc()) {
	$maxTable[] = $row;
	}
	print_r(json_encode($maxTable));
}

//********************** GET MAX TORQUE VALUE FOR SPECIFC TOOL*****************************///
function getMaxToolTorque($toolID,$units){
	if($units == 'imp'){
	$sql = "SELECT toolName, max(maxTorq) as maxTorq FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";
	}else{
	$sql = "SELECT toolName, ROUND((max(maxTorq)*1.3556),0) as maxTorq FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";
	}
	global $conn;
	$result = $conn->query($sql);
	$maxTable = array();
	while($row = $result->fetch_assoc()) {
	$maxTable[] = $row;
	}
	print_r(json_encode($maxTable));
}

//*********************** GET MIN TORQUE VALUE FOR SPECIFIC TOOL *******************************///
function getMinToolTorque($toolID,$units){
	if($units == 'imp'){
	$sql = "SELECT toolName, min(minTorq) as minTorq FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";
	}else{
	$sql = "SELECT toolName, ROUND((min(minTorq)*1.3556),0) as minTorq FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";	
	}
	global $conn;
	$result = $conn->query($sql);
	$minTable = array();
	while($row = $result->fetch_assoc()) {
	$minTable[] = $row;
	}
	print_r(json_encode($minTable));
}

//************************* GET TORQUE RANGE MIN AND MAX FOR SPECIFIC TOOL ****************************///
function getTorqueRange($toolID,$units){
	if($units == 'imp'){
	$sql = "SELECT toolName, min(minTorq) as minTorq, max(maxTorq) as maxTorq FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";
	}else{
	$sql = "SELECT toolName, ROUND((min(minTorq)*1.3556),0) as minTorq, ROUND((max(maxTorq)*1.3556),0) as maxTorq FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";	
	}
	global $conn;
	$result = $conn->query($sql);
	$minTable = array();
	while($row = $result->fetch_assoc()) {
	$minTable[] = $row;
	}
	print_r(json_encode($minTable));
}

//************************** GET RADIUS RANGE FOR SPECIFIC TOOL *********************************///
function getRadiusRange($toolID,$units){
	if($units == 'imp'){
	$sql = "SELECT toolName, min(radius) as minRadius, max(radius) as maxRadius FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";
	}else{
	$sql = "SELECT toolName, ROUND((min(radius)*25.4),0) as minRadius, ROUND((max(radius)*25.4),0) as maxRadius FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";	
	}
	global $conn;
	$result = $conn->query($sql);
	$minTable = array();
	while($row = $result->fetch_assoc()) {
	$minTable[] = $row;
	}
	print_r(json_encode($minTable));
}

//************************** GET DRIVE SIZE RANGE FOR SPECIFIC TOOL **************************///
function getDriveSizeRange($toolID){
	$sql = "SELECT toolName, min(drive) as minDrive, max(drive) as maxDrive FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";
	global $conn;
	$result = $conn->query($sql);
	$driveRange = array();
	while($row = $result->fetch_assoc()) {
	$driveRange[] = $row;
	}
	print_r(json_encode($driveRange));
}

//************************** GET WEIGHT RANGE FOR SPECIFIC TOOL ******************************//
function getWeightRange($toolID,$units){
	if($units == 'imp'){
	$sql = "SELECT toolName, min(weight) as minWeight, max(weight) as maxWeight FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";
	}else{
	$sql = "SELECT toolName, ROUND((min(weight)*0.45359237),0) as minWeight, ROUND((max(weight)*0.45359237),0) as maxWeight FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_TechData_By_Tool` where toolID = '$toolID'";
	}
	global $conn;
	$result = $conn->query($sql);
	$weightRange = array();
	while($row = $result->fetch_assoc()) {
	$weightRange[] = $row;
	}
	print_r(json_encode($weightRange));
}

//************************* GET RADIUS BREAK APART STRING AND CONVERT TO METRIC******************//
function getMetRadius($radius){
	//if contains "to" 
	if (strpos($radius, 'to') !== false) {
		$parts = explode('to', $radius);
		$metConverted;
		$i;
		foreach ($parts as &$value) {
			$i++;
			$value = round($value*25.4,1);
			$metConverted .= $value;
			if($i == 1){
				$metConverted .= ' to ';
			}
		}
		return($metConverted);
	}else{
	$radius = round($radius*25.4,1);
	return($radius);
	}
}
						   
//******************************* GET TORQUE CHART FOR SPECIFIC TOOL MODEL *********************//
function getTorqueChart($modelID){
	$sql = "SELECT * FROM `hytorc_torcsafe_torqueCharts`.`Hydraulic_Torque_Chart` where modelID = '$modelID'";
	global $conn;
	$result = $conn->query($sql);
	$torqueChart = array();
	while($row = $result->fetch_assoc()) {
	$torqueChart[] = $row;
	}
	print_r(json_encode($torqueChart));
}


//*********************** ERROR MESSAGE ****************************************************///
function error($param){
	switch($param){
		case 'get':
			echo('Error: Missing GET parameter');
		break;	
	}
}

?>