<?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);