<?php
include_once '../function_header.php';
$objectId = $_REQUEST['objectId'];
$additionalId = $_REQUEST['additionalId'];
$infoNeed = $_REQUEST['type'];
$response['type'] = $infoNeed;
//type = projectInfo | supplierInfo | materialPrice
switch ($infoNeed) {
case 'projectInfo':
$projectInfo = getProjectInfo($conexion, $objectId);
$response['displayFrom'] = $projectInfo['projectName'] . " @ " . $projectInfo['addressLine1'];
break;
case 'supplierInfo':
$supplierInfo = getSupplierInfo($conexion, $objectId);
$response['displayTo'] = $supplierInfo['supplierName'] . " @ " . $supplierInfo['addressLine1'];
break;
case 'materialPrice':
//echo "SELECT * FROM suppliermaterial WHERE materialId = '$objectId' AND supplierId = '$additionalId'";
$materialInfo = mysql_fetch_assoc(mysql_query("SELECT * FROM suppliermaterial WHERE materialId = '{$objectId}' AND supplierId = '{$additionalId}'", $conexion));
$response['materialPrice'] = $materialInfo['supplierMaterialPrice'];
$response['materialLast'] = to_MDY($materialInfo['supplierMaterialLastModified']);
break;
}
echo json_encode($response);
$project = 0;
$material = 0;
$displayFrom = "";
$displayTo = "";
$materialPrice = "";
if (isset($_GET['customerId'])) {
$customer = $_GET['customerId'];
}
if (isset($_GET['projectId'])) {
$project = $_GET['projectId'];
$projectInfo = getProjectInfo($conexion, $project);
$displayFrom = $projectInfo['projectName'] . " @ " . $projectInfo['addressLine1'];
}
if (isset($_GET['supplierId'])) {
$supplier = $_GET['supplierId'];
$supplierInfo = getSupplierInfo($conexion, $supplier);
$displayTo = $supplierInfo['supplierName'] . " @ " . $supplierInfo['addressLine1'];
}
if (isset($_GET['materialId']) && isset($_GET['supplierId'])) {
$material = $_GET['materialId'];
$materialInfo = mysql_fetch_assoc(mysql_query("SELECT * FROM suppliermaterial WHERE materialId = '{$material}' AND supplierId = '{$supplier}'", $conexion));
$materialPrice = decimalPad($materialInfo['supplierMaterialPrice']);
}
/*
switch($infoNeed) {
case 'projectInfo':
$projectInfo = getProjectInfo($conexion,$objectId);
$response['displayFrom'] = $projectInfo['projectName']." @ ".$projectInfo['addressLine1'];
break;
case 'supplierInfo':
$supplierInfo = getSupplierInfo($conexion,$objectId);
