<?php
include_once '../nyro_header.php';
$ticketId = $_GET['ticketId'];
$ticketInfo = objectQuery($conexion, '*', $ticketExtendedTables, 'ticketId = ' . $ticketId);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
/*echo createEditIcon('editTicket','../nyros/editTicket.php',"ticketId=$ticketId", "Ticket");*/
?>
<?php
echo createDeleteIcon('deleteTicket', '../submit/deleteTicket.php', "ticketId={$ticketId}", "Ticket");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Ticket Information</th>
</tr>
<?php
$flag = true;
$projectLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_PROJECT, createGenericNyroableAttributesSmall($ticketInfo['projectId'], 'project'));
$customerLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_CUSTOMER, createGenericNyroableAttributesSmall($ticketInfo['customerId'], 'customer'));
$itemLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_ITEM, createGenericNyroableAttributesSmall($ticketInfo['itemId'], 'item'));
<?php
include_once '../nyro_header.php';
$projectId = $_GET['projectId'];
$projectInfo = objectQuery($conexion, '*', $projectExtendedTables, 'projectId = ' . $projectId);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
echo createActionIcon(IMG_NEW_ITEM_PROPOSAL, 'addItemProposal', 'Add Item Proposal', '../nyros/newItemProposal.php', "projectId=" . $projectId . "&customerId=" . $projectInfo['customerId'], 'show');
?>
<?php
echo createActionIcon(IMG_NEW_ITEM, 'addItem', 'Add Item', '../nyros/newItem.php', "projectId=" . $projectId . "&customerId=" . $projectInfo['customerId'], 'show');
?>
<?php
echo createEditIcon('editProject', '../nyros/editProject.php', "projectId={$projectId}", "Project");
?>
<?php
echo createDeleteIcon('deleteProject', '../submit/deleteProject.php', "projectId={$projectId}", "Project");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Project Information</th>
<?php
include_once '../nyro_header.php';
$itemId = $_GET['proposalId'];
$itemInfo = objectQuery($conexion, $itemExtendedSelect, 'fakeitem JOIN fakeproject USING (fakeprojectId) JOIN supplier USING (supplierId) JOIN vendor USINg (vendorId) JOIN material USING (materialId)', 'fakeitemId = ' . $itemId);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
/*echo createEditIcon('editTruck','../nyros/editTruck.php',"truckId=$truckId", "Truck");*/
?>
<?php
echo createDeleteIcon('deleteProposal', '../submit/deleteProposal.php', "proposalId={$itemId}", "Proposal");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Item Information</th>
</tr>
<?php
$flag = true;
$estimateLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_ESTIMATE, createGenericNyroableAttributesSmall($itemInfo['fakeprojectId'], 'estimate'));
$customerLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_CUSTOMER, createGenericNyroableAttributesSmall($itemInfo['customerId'], 'customer'));
$supplierLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_SUPPLIER, createGenericNyroableAttributesSmall($itemInfo['supplierId'], 'supplier'));
<th width="5%" >L/T/H</th>
<th width="6%" >Rate</th>
<th width="8%" >Amount</th>
<th width="5%" >%</th>
<th width="8%" >Total</th>
</tr>
<?php
$queryInvoice = "\nSELECT \n\t*\nFROM\n\tticket\n\tJOIN item using (itemId)\n\tJOIN material using (materialId)\n\tJOIN truck using (truckId)\n\tLEFT JOIN reportticket using (ticketId)\nWHERE\n\treportId IS NULL\n\tAND brokerId=" . $broker . " " . ($isDriver ? " AND driverId = " . $driver : "") . "\n\tAND ticketDate BETWEEN '" . $fromDate . "' AND '" . $toDate . "' \nORDER BY\n\tticketDate, ticketId\n";
$invoices = mysql_query($queryInvoice, $conexion);
mysql_close();
$total = 0;
$count = 0;
$subtotal = 0;
while ($ticket = mysql_fetch_assoc($invoices)) {
$customerInfo = objectQuery($conexion, '*', 'project JOIN customer using (customerId)', "projectId = " . $ticket['projectId']);
echo "<tr>";
echo "<td>" . to_MDY($ticket['ticketDate']) . "</td>";
echo "<td>" . $customerInfo['customerName'] . "</td>";
echo "<td>" . $brokerInfo['brokerPid'] . "-" . $ticket['truckNumber'] . "</td>";
echo "<td align=left >" . $ticket['ticketMfi'];
if ($ticket['ticketNumber'] != "") {
echo "/" . $ticket['ticketNumber'];
}
echo "</td>";
echo "<td align=left>" . $ticket['itemDisplayFrom'] . "</td>";
echo "<td align=left>" . $ticket['itemDisplayTo'] . "</td>";
echo "<td >" . decimalPad($ticket['ticketBrokerAmount']);
echo "</td>";
echo "<td align=right >" . decimalPad($ticket['itemBrokerCost']);
echo "</td>";
<?php
include_once '../function_header.php';
include '../common_server_functions.php';
//print_r($_REQUEST);
$responseCode = 0;
$name = $_REQUEST['name'];
if ($name == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Vendor Name', 'newVendorName'));
}
$existingVendor = objectQuery($conexion, '*', 'vendor', "vendorName = '{$name}'");
if ($existingVendor != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The name '{$name}' is already in use by another vendor [" . $existingVendor['vendorName'] . "] with ID [" . $existingVendor['vendorId'] . "]", 'newVendorName'));
}
$info = $_REQUEST['info'];
$comment = $_REQUEST['comment'];
$tel = $_REQUEST['tel'];
$fax = $_REQUEST['fax'];
$line1 = $_REQUEST['line1'];
$line2 = $_REQUEST['line2'];
$city = $_REQUEST['city'];
$state = $_REQUEST['state'];
$zip = $_REQUEST['zip'];
$box = $_REQUEST['box'];
//die(wrapError(-2,'Feature not ready'));
$vendorId = saveNewVendor($conexion, $name, $info, $comment, $tel, $fax, $line1, $line2, $city, $state, $zip, $box);
echo wrapSubmitResponse(SUCCESS_CODE, $vendorId);
<?php
include_once '../nyro_header.php';
$customerSuperCheckId = $_GET['customerSuperCheckId'];
$customerSuperCheckInfo = objectQuery($conexion, "*, COALESCE(customerCreditAmount, '0') as checkCredit", 'customer_super_check JOIN customer USING (customerId) LEFT JOIN customer_credit USING (customerSuperCheckId)', 'customerSuperCheckId = ' . $customerSuperCheckId);
$payments = mysql_query("SELECT * FROM receiptcheques WHERE customerSuperCheckId = '{$customerSuperCheckId}' ORDER BY invoiceId desc", $conexion);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
/*echo createEditIcon('editSupplier','../nyros/editCustomerSuperCheck.php',"customerSuperCheckId=$customerSuperCheckId", "Supplier");*/
?>
<?php
echo createDeleteIcon('deleteSupplier', '../submit/deleteCustomerSuperCheck.php', "customerSuperCheckId={$customerSuperCheckId}", "Supplier");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Customer Check Information</th>
</tr>
<?php
$flag = true;
$customerLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_VENDOR, createGenericNyroableAttributesSmall($customerSuperCheckInfo['customerId'], 'customer'));
echo printTuple($flag ? '' : "class='bg'", 'Customer', $customerSuperCheckInfo['customerName'], $customerLink);
<?php
include_once '../nyro_header.php';
$supplierId = $_GET['supplierId'];
$supplierInfo = objectQuery($conexion, '*', 'supplier JOIN address ON (supplier.addressId = address.addressId)
JOIN vendor USING (vendorId)', 'supplierId = ' . $supplierId);
?>
<script type="text/javascript">
$(document).ready(function() {
//$('#submitButton').click(function() {
$(document).off('click', '#submitEditSupplierButton')
$(document).on('click', '#submitEditSupplierButton', function() {
//closeNM();
submitEditSupplier();
});
});
function submitEditSupplier() {
disableButton()
var data = getEditSupplierParams();
var url = '../submit/submitEditSupplier.php';
submitNewObject(url, data);
}
function disableButton() {
$('#submitButton').attr('disabled','disabled');
}
function enableButton() {
<?php
include_once '../function_header.php';
include '../common_server_functions.php';
//print_r($_REQUEST);
$responseCode = 0;
$name = $_REQUEST['name'];
if ($name == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Customer Name', 'newCustomerName'));
}
$existingCustomer = objectQuery($conexion, '*', 'customer', "customerName = '{$name}'");
if ($existingCustomer != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The name '{$name}' is already in use by another customer [" . $existingCustomer['customerName'] . "] with ID [" . $existingCustomer['customerId'] . "]", 'newCustomerName'));
}
$term = $_REQUEST['term'];
if ($term == '0') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Customer Pay Terms', 'newCustomerTerm'));
}
$web = $_REQUEST['web'];
$tel = $_REQUEST['tel'];
$fax = $_REQUEST['fax'];
$line1 = $_REQUEST['line1'];
$line2 = $_REQUEST['line2'];
$city = $_REQUEST['city'];
$state = $_REQUEST['state'];
$zip = $_REQUEST['zip'];
$box = $_REQUEST['box'];
//die(wrapError(-2,'Feature not ready'));
$customerId = saveNewCustomer($conexion, $name, $tel, $fax, $web, $term, $line1, $line2, $city, $state, $zip, $box);
echo wrapSubmitResponse(SUCCESS_CODE, $customerId);
<?php
include_once '../function_header.php';
include '../common_server_functions.php';
//print_r($_REQUEST);
$response = array();
$report = $_REQUEST['reportId'];
if ($report == '') {
die(wrapError(ERROR_CODE_FIVE, 'INTERNAL ERROR'));
}
$number = $_REQUEST['number'];
if ($number == '') {
die(wrapError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Check Number'));
}
if ($number != 'cash') {
$existingNumber = objectQuery($conexion, '*', 'suppliercheque', "supplierchequeNumber = '{$number}'");
if ($existingNumber != null) {
die(wrapError(ERROR_CODE_DUPLICATE, 'Number is used by a different check'));
}
}
$date = $_REQUEST['date'];
$amount = $_REQUEST['amount'];
if ($amount <= 0) {
die(wrapError(ERROR_CODE_INVALID_VALUE, 'The amount must be a value greater than "0".'));
}
//die(wrapError(-2,'Feature not ready'));
$checkId = saveSupplierCheck($conexion, $report, $number, $amount, $date);
if ($checkId != null && $checkId > 0) {
echo wrapSubmitResponse(SUCCESS_CODE, $checkId);
} else {
echo wrapError(ERROR_CODE_INTERNAL_ERROR, 'There was an error inserting the check. Please contact the administrator.');
<?php
include_once '../nyro_header.php';
$driverId = $_GET['driverId'];
$driverInfo = objectQuery($conexion, '*', $driverExtendedTables, 'driverId = ' . $driverId);
$brokerInfo = objectQuery($conexion, '*', 'broker', 'brokerId = ' . $driverInfo['brokerId']);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
echo createEditIcon('editDriver', '../nyros/editDriver.php', "driverId={$driverId}", "Driver");
?>
<?php
echo createDeleteIcon('deleteDriver', '../submit/deleteDriver.php', "driverId={$driverId}", "Driver");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Driver Information</th>
</tr>
<?php
$flag = true;
$brokerLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_BROKER, createGenericNyroableAttributesSmall($driverInfo['brokerId'], 'broker'));
echo printTuple($flag ? '' : "class='bg'", 'Driver Name', $driverInfo['driverFirstName'] . " " . $driverInfo['driverLastName']);
$materialPrice = $_REQUEST['materialPrice'];
if ($materialPrice == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a material price', 'newItemMaterialPrice'));
}
$brokerCost = $_REQUEST['brokerCost'];
if ($brokerCost == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a broker cost', 'newItemBrokerCost'));
}
$customerCost = $_REQUEST['customerCost'];
if ($customerCost == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a customer cost', 'newItemCustomerCost'));
}
$type = $_REQUEST['type'];
if ($type == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a type', 'type'));
}
$description = $_REQUEST['description'];
$existing = objectQuery($conexion, '*', 'fakeitem', "fakeprojectId = '{$project}' AND supplierId = '{$supplier}' AND materialId = '{$material}' AND itemType = '{$type}' AND itemMaterialPrice = '{$materialPrice}' AND itemBrokerCost = '{$brokerCost}' AND itemCustomerCost = '{$customerCost}'");
if ($existing != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The proposal already exists"));
}
$number = "0";
$last = objectQuery($conexion, '*', 'fakeitem', "fakeprojectId = '{$project}' ORDER BY itemNumber desc limit 1");
if ($last != null) {
$number = $last['itemNumber'] + 1;
} else {
$number = "1";
}
//die(wrapError(-2,'Feature not ready'));
$itemId = saveNewProposal($conexion, $number, $project, $supplier, $material, 0, 0, $fromText, $toText, $materialPrice, $brokerCost, $customerCost, $type, $description);
echo wrapSubmitResponse(SUCCESS_CODE, $itemId);
<?php include_once '../nyro_header.php'; $customerId = $_GET['customerId']; $customerInfo = objectQuery($conexion, '*', $customerExtendedTables, 'customerId = ' . $customerId); ?> <div id='formDiv' class='table'> <img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" /> <img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" /> <table class="listing form" cellpadding="0" cellspacing="0"> <tr> <th colspan='2'>Customer Information</th> </tr> <?php $flag = true; echo printTuple($flag ? '' : "class='bg'", 'Customer Id', $customerInfo['customerId']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Customer Name', $customerInfo['customerName']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Customer Telephone', showPhoneNumber($customerInfo['customerTel'])); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Customer Fax', showPhoneNumber($customerInfo['customerFax'])); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'WebSite', $customerInfo['customerWebsite']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Address', $customerInfo['addressLine1']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Address', $customerInfo['addressCity'] . ", " . $customerInfo['addressState'] . " " . $customerInfo['addressZip']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'P.O. Box', $customerInfo['addressPOBox']); $flag = !$flag;
if ($amount == '' || $amount == '0') {
die(wrapFormError(ERROR_CODE_DUPLICATE, "Please type a valid amount", 'newTicketAmount'));
}
$brokerAmount = $_REQUEST['brokerAmount'];
if ($brokerAmount == '' || $brokerAmount == '0') {
die(wrapFormError(ERROR_CODE_DUPLICATE, "Please type a valid broker amount", 'newTicketBrokerAmount'));
}
$existing = objectQuery($conexion, '*', 'ticket', "ticketMfi = '{$mfi}' AND ticketNumber = '{$number}'");
if ($existing != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The number '{$number}' with ticket '{$mfi}' is already in use by another ticket with ID [" . $existing['ticketId'] . "]", 'newTicketNumber'));
}
//die(wrapError(-2,'Feature not ready'));
$ticketId = saveNewTicket($conexion, $item, $truck, $driver, $date, $amount, $brokerAmount, $number, $mfi);
$response['code'] = 0;
$response['created'] = $ticketId;
$response['newMfi'] = $mfi + 1;
$ticket = objectQuery($conexion, '*', 'ticket JOIN truck USING (truckId) JOIN broker USING (brokerId) JOIN item USING (itemId) JOIN material USING (materialId)', "ticketId = '{$ticketId}'");
$response['newLine'] = "<tr class='doubleClickable' ticketId='" . $ticket['ticketId'] . "'>\n\t\t<td>" . to_MDY($ticket['ticketDate']) . "</td>\n\t\t<td>" . $ticket['projectId'] . "</td>\n\t\t<td>" . $ticket['brokerPid'] . "-" . $ticket['truckNumber'] . "</td>\n\t\t<td>" . $ticket['materialName'] . "</td>\n\t\t<td>" . $ticket['itemDisplayFrom'] . "</td>\n\t\t<td>" . $ticket['itemDisplayTo'] . "</td>\n\t\t<td>" . $ticket['ticketMfi'] . "</td>\n\t\t<td>" . $ticket['ticketNumber'] . "</td>\n\t</tr>";
/*
* echo "<tr class='doubleClickable' ticketId='".$ticket['ticketId']."'>
<td>".to_MDY($ticket['ticketDate'])."</td>
<td>".$ticket['projectId']."</td>
<td>".$ticket['brokerPid']."-".$ticket['truckNumber']."</td>
<td>".$ticket['materialName']."</td>
<td>".$ticket['itemDisplayFrom']."</td>
<td>".$ticket['itemDisplayTo']."</td>
<td>".$ticket['ticketMfi']."</td>
<td>".$ticket['ticketNumber']."</td>
</tr>";
*/
echo json_encode($response);
include '../common_server_functions.php';
//print_r($_REQUEST);
$responseCode = 0;
$truckId = $_REQUEST['truckId'];
if ($truckId == 0 || $truckId == '') {
die(wrapError(ERROR_CODE_FIVE, 'INTERNAL ERROR'));
}
$broker = $_REQUEST['broker'];
if ($broker == 0 || $broker == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a broker', 'brokerId'));
}
$number = $_REQUEST['number'];
if ($number == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please type the truck number', 'truckNumber'));
}
$existingTruck = objectQuery($conexion, '*', 'truck', "truckNumber = '{$number}' AND brokerId = '{$broker}' AND truckId <> '{$truckId}'");
if ($existingTruck != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The number '{$number}' is already in use by another truck with ID [" . $existingTruck['truckId'] . "]", 'truckNumber'));
}
$driver = $_REQUEST['driver'];
$plates = $_REQUEST['plates'];
$info = $_REQUEST['addinfo'];
$brand = $_REQUEST['brand'];
$year = $_REQUEST['year'];
$serial = $_REQUEST['serial'];
$tire = $_REQUEST['tire'];
$features = $_REQUEST['features'];
$line1 = $_REQUEST['line1'];
$line2 = $_REQUEST['line2'];
$city = $_REQUEST['city'];
$state = $_REQUEST['state'];
<?php
include_once '../function_header.php';
include '../common_server_functions.php';
//print_r($_REQUEST);
$responseCode = 0;
$vendor = $_REQUEST['vendor'];
if ($vendor == '' || $vendor == '0') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Vendor', 'newVendorId'));
}
$name = $_REQUEST['name'];
if ($name == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Supplier Name', 'newSupplierName'));
}
$existingSupplier = objectQuery($conexion, '*', 'supplier', "supplierName = '{$name}' AND vendorId = '{$vendor}'");
if ($existingSupplier != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The name '{$name}' is already in use by another supplier [" . $existingSupplier['supplierName'] . "] with ID [" . $existingSupplier['supplierId'] . "]", 'newSupplierName'));
}
$info = $_REQUEST['info'];
$dumptime = $_REQUEST['dumptime'];
$tel = $_REQUEST['tel'];
$fax = $_REQUEST['fax'];
$line1 = $_REQUEST['line1'];
$line2 = $_REQUEST['line2'];
$city = $_REQUEST['city'];
$state = $_REQUEST['state'];
$zip = $_REQUEST['zip'];
$box = $_REQUEST['box'];
//die(wrapError(-2,'Feature not ready'));
$supplierId = saveNewSupplier($conexion, $vendor, $name, $tel, $fax, $info, $dumptime, $line1, $line2, $city, $state, $zip, $box);
echo wrapSubmitResponse(SUCCESS_CODE, $supplierId);
<?php
include_once '../nyro_header.php';
$fuelLoadId = $_GET['fuelLoadId'];
$fuelLoadInfo = objectQuery($conexion, '*', 'fuel_load JOIN broker ON (broker.brokerId = fuel_load.brokerId) LEFT JOIN truck USING (truckId)', 'fuelLoadId = ' . $fuelLoadId);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
echo createEditIcon('editFuelLoad', '../nyros/editFuelLoad.php', "fuelLoadId={$fuelLoadId}", "FuelLoad");
?>
<?php
echo createDeleteIcon('deleteFuelLoad', '../submit/deleteFuelLoad.php', "fuelLoadId={$fuelLoadId}", "FuelLoad");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>FuelLoad Information</th>
</tr>
<?php
$flag = true;
$brokerLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_BROKER, createGenericNyroableAttributesSmall($fuelLoadInfo['brokerId'], 'broker'));
echo printTuple($flag ? '' : "class='bg'", 'Fuel Load Id', $fuelLoadInfo['fuelLoadId']);
$flag = !$flag;
if ($material == 0 || $material == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a material', 'newItemMaterialId'));
}
$fromId = $_REQUEST['fromId'];
$toId = $_REQUEST['toId'];
$fromText = $_REQUEST['fromDisplay'];
$toText = $_REQUEST['toDisplay'];
$materialPrice = $_REQUEST['materialPrice'];
if ($materialPrice == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a material price', 'newItemMaterialPrice'));
}
$brokerCost = $_REQUEST['brokerCost'];
if ($brokerCost == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a broker cost', 'newItemBrokerCost'));
}
$customerCost = $_REQUEST['customerCost'];
if ($customerCost == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a customer cost', 'newItemCustomerCost'));
}
$type = $_REQUEST['type'];
if ($type == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a type', 'type'));
}
$description = $_REQUEST['description'];
$existing = objectQuery($conexion, '*', 'item_proposal', "projectId = '{$project}' AND supplierId = '{$supplier}' AND materialId = '{$material}' AND itemProposalType = '{$type}' AND itemProposalMaterialPrice = '{$materialPrice}' AND itemProposalBrokerCost = '{$brokerCost}' AND itemProposalCustomerCost = '{$customerCost}'");
if ($existing != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The proposal already exists"));
}
//die(wrapError(-2,'Feature not ready'));
$itemProposalId = saveNewItemProposal($conexion, $project, $supplier, $material, $fromId, $toId, $fromText, $toText, $material, $broker, $customer, $type, $description);
echo wrapSubmitResponse(SUCCESS_CODE, $itemProposalId);
function getAddressInfo($handler, $addressId)
{
return objectQuery($handler, '*', 'address', 'addressId = ' . $addressId);
}
<?php
include_once '../nyro_header.php';
$vendorId = $_GET['vendorId'];
$vendorInfo = objectQuery($conexion, '*', $vendorExtendedTables, 'vendorId = ' . $vendorId);
?>
<script type="text/javascript">
$(document).ready(function() {
//$('#submitButton').click(function() {
$(document).off('click', '#submitEditVendor');
$(document).on('click', '#submitEditVendor', function() {
//closeNM();
submitEditVendor();
});
});
function submitEditVendor() {
disableButton()
var data = getEditParams();
var url = '../submit/submitEditVendor.php';
submitNewObject(url, data);
}
function disableButton() {
$('#submitButton').attr('disabled','disabled');
}
function enableButton() {
$('#submitButton').removeAttr('disabled');
<?php
include_once '../function_header.php';
include '../common_server_functions.php';
//print_r($_REQUEST);
$response = array();
$report = $_REQUEST['reportId'];
if ($report == '') {
die(wrapError(ERROR_CODE_FIVE, 'INTERNAL ERROR'));
}
$number = $_REQUEST['number'];
if ($number == '') {
die(wrapError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Check Number'));
}
if ($number != 'cash') {
$existingNumber = objectQuery($conexion, '*', 'paidcheques', "paidchequeNumber = '{$number}'");
if ($existingNumber != null) {
die(wrapError(ERROR_CODE_DUPLICATE, 'Number is used by a different check'));
}
}
$date = $_REQUEST['date'];
$amount = $_REQUEST['amount'];
if ($amount <= 0) {
die(wrapError(ERROR_CODE_INVALID_VALUE, 'The amount must be a value greater than "0".'));
}
//die(wrapError(-2,'Feature not ready'));
$checkId = saveBrokerCheck($conexion, $report, $number, $amount, $date);
if ($checkId != null && $checkId > 0) {
echo wrapSubmitResponse(SUCCESS_CODE, $checkId);
} else {
echo wrapError(ERROR_CODE_INTERNAL_ERROR, 'There was an error inserting the check. Please contact the administrator.');
<?php
include_once '../function_header.php';
include '../common_server_functions.php';
//print_r($_REQUEST);
$responseCode = 0;
$customer = $_REQUEST['customer'];
if ($customer == '0' || $customer == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Customer', 'newEstimateCustomer'));
}
$name = $_REQUEST['name'];
if ($name == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Estimate Name', 'newEstimateName'));
}
$existingEstimate = objectQuery($conexion, '*', 'fakeproject', "customerId = '{$customer}' AND fakeprojectName = '{$name}'");
if ($existingEstimate != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The name '{$name}' is already in use by another estimate [" . $existingEstimate['fakeprojectName'] . "] with ID [" . $existingEstimate['fakeprojectIdId'] . "]", 'newEstimateName'));
}
$line1 = $_REQUEST['line1'];
$line2 = $_REQUEST['line2'];
$city = $_REQUEST['city'];
$state = $_REQUEST['state'];
$zip = $_REQUEST['zip'];
$box = $_REQUEST['box'];
//die(wrapError(-2,'Feature not ready'));
$estimateId = saveNewEstimate($conexion, $name, $customer, $line1, $line2, $city, $state, $zip, $box);
echo wrapSubmitResponse(SUCCESS_CODE, $estimateId);
include '../common_server_functions.php';
//print_r($_REQUEST);
$responseCode = 0;
$pid = $_REQUEST['pid'];
if ($pid == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing PID', 'brokerPid'));
}
$existingBroker = objectQuery($conexion, '*', 'broker', "brokerPid = '{$pid}'");
if ($existingBroker != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The PID '{$pid}' is already in use by another broker [" . $existingBroker['brokerName'] . "]", 'editBrokerPid'));
}
$name = $_REQUEST['name'];
if ($name == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Broker Name', 'brokerName'));
}
$existingBroker = objectQuery($conexion, '*', 'broker', "brokerName = '{$name}'");
if ($existingBroker != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The name '{$name}' is already in use by another broker [" . $existingBroker['brokerName'] . "] with PID [" . $existingBroker['brokerPid'] . "]", 'editBrokerName'));
}
$contact = $_REQUEST['contact'];
$tax = $_REQUEST['tax'];
$tel = $_REQUEST['tel'];
$fax = $_REQUEST['fax'];
$radio = $_REQUEST['radio'];
$mobile = $_REQUEST['mobile'];
$carrier = $_REQUEST['carrier'];
$email = $_REQUEST['email'];
$line1 = $_REQUEST['line1'];
$line2 = $_REQUEST['line2'];
$city = $_REQUEST['city'];
$state = $_REQUEST['state'];
if ($driverId == 0 || $driverId == '') {
die(wrapError(ERROR_CODE_FIVE, 'INTERNAL ERROR'));
}
$broker = $_REQUEST['broker'];
if ($broker == 0 || $broker == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please select a broker', 'brokerId'));
}
$first = $_REQUEST['first'];
if ($first == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please type the driver first name', 'firstName'));
}
$last = $_REQUEST['last'];
if ($last == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please type the driver last name', 'lastName'));
}
$existingDriver = objectQuery($conexion, '*', 'driver', "driverFirstName like '{$first}' AND driverLastName like '{$last}' AND brokerId = '{$broker}' AND driverId<>'{$driverId}'");
if ($existingDriver != null) {
die(wrapFormError(ERROR_CODE_DUPLICATE, "The driver name '{$first} {$last}' already exists with ID [" . $existingDriver['driverId'] . "]", 'firstName'));
}
$ssn = $_REQUEST['ssn'];
if ($ssn == '') {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Please type the driver SSN', 'ssn'));
}
$tel = $_REQUEST['tel'];
$mobile = $_REQUEST['mobile'];
$carrier = $_REQUEST['carrier'];
$email = $_REQUEST['email'];
$term = $_REQUEST['term'];
if ($term == 0) {
die(wrapFormError(ERROR_CODE_MISSING_PARAMETERS, 'Missing Driver Terms', 'termId'));
}
<?php
include_once '../nyro_header.php';
$itemId = $_GET['itemProposalId'];
$itemInfo = objectQuery($conexion, $itemProposalExtendedSelect, $itemProposalExtendedTables, 'itemProposalId = ' . $itemId);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
/*echo createEditIcon('editTruck','../nyros/editTruck.php',"truckId=$truckId", "Truck");*/
?>
<?php
echo createDeleteIcon('deleteItemProposal', '../submit/deleteItemProposal.php', "itemProposalId={$itemId}", "ItemProposal");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Item Information</th>
</tr>
<?php
$flag = true;
$projectLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_PROJECT, createGenericNyroableAttributesSmall($itemInfo['projectId'], 'project'));
$customerLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_CUSTOMER, createGenericNyroableAttributesSmall($itemInfo['customerId'], 'customer'));
$supplierLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_SUPPLIER, createGenericNyroableAttributesSmall($itemInfo['supplierId'], 'supplier'));
<?php
include_once '../nyro_header.php';
$estimateId = $_GET['estimateId'];
$estimateInfo = objectQuery($conexion, '*', $estimateExtendedTables, 'fakeprojectId = ' . $estimateId);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
echo createActionIcon(IMG_NEW_ITEM_PROPOSAL, 'addProposal', 'Add Proposal', '../nyros/newProposal.php', "estimateId=" . $estimateId . "&customerId=" . $estimateInfo['customerId'], 'show');
?>
<?php
/*echo createEditIcon('editProject','../nyros/editProject.php',"projectId=$projectId", "Project");*/
?>
<?php
echo createDeleteIcon('deleteProject', '../submit/deleteEstimate.php', "estimateId={$estimateId}", "Estimate");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Estimate Information</th>
</tr>
<?php
$flag = true;
<?php
include_once '../nyro_header.php';
$truckId = $_GET['truckId'];
$truckInfo = objectQuery($conexion, '*', 'truck JOIN address ON (truck.addressId = address.addressId)
JOIN broker USING (brokerId)', 'truckId = ' . $truckId);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
echo createEditIcon('editTruck', '../nyros/editTruck.php', "truckId={$truckId}", "Truck");
?>
<?php
echo createDeleteIcon('deleteTruck', '../submit/deleteTruck.php', "truckId={$truckId}", "Truck");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Driver Information</th>
</tr>
<?php
$flag = true;
$brokerLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_BROKER, createGenericNyroableAttributesSmall($truckInfo['brokerId'], 'broker'));
echo printTuple($flag ? '' : "class='bg'", 'Truck Number', $truckInfo['brokerPid'] . " " . $truckInfo['truckNumber']);
<?php
include_once '../nyro_header.php';
$driverId = $_GET['driverId'];
$driverInfo = objectQuery($conexion, '*', 'driver JOIN address ON (driver.addressId = address.addressId)
JOIN broker USING (brokerId)', 'driverId = ' . $driverId);
?>
<script type="text/javascript">
$(document).ready(function() {
//$('#submitButton').click(function() {
$(document).one('click', '#submitEditDriverButton', function() {
//closeNM();
submitEditDriver();
});
});
function submitEditDriver() {
disableButton()
var data = getEditDriverParams();
var url = '../submit/submitEditDriver.php';
submitNewObject(url, data);
}
function disableButton() {
$('#submitButton').attr('disabled','disabled');
}
function enableButton() {
$('#submitButton').removeAttr('disabled');
<?php
include_once '../nyro_header.php';
$brokerId = $_GET['brokerId'];
$brokerInfo = objectQuery($conexion, '*', $brokerExtendedTables, 'brokerId = ' . $brokerId);
?>
<script type="text/javascript">
function deleteSuccess() {
closeNM();
}
</script>
<div id='actions' class="top-bar">
<?php
echo createEditIcon('editBroker', '../nyros/editBroker.php', "brokerId={$brokerId}", "Broker");
?>
<?php
echo createDeleteIcon('deleteBroker', '../submit/deleteBroker.php', "brokerId={$brokerId}", "Broker");
?>
</div>
<div id='formDiv' class='table'>
<img src="/mfi/img/bg-th-left.gif" width="8" height="7" alt="" class="left" />
<img src="/mfi/img/bg-th-right.gif" width="7" height="7" alt="" class="right" />
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th colspan='2'>Broker Information</th>
</tr>
<?php
$flag = true;
echo printTuple($flag ? '' : "class='bg'", 'Broker Name', $brokerInfo['brokerName']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Broker PID', $brokerInfo['brokerPid']);
<?php
include_once '../nyro_header.php';
$supplierId = $_GET['supplierId'];
$supplierInfo = objectQuery($conexion, '*', $supplierExtendedTables, 'supplierId = ' . $supplierId);
?>
<script type="text/javascript">
var supplier = '<?php
echo $supplierId;
?>
';
$(document).ready(function() {
$('#saveNewPriceList').click(function() {
saveNewPriceList();
});
$('#vendorId').change(function() {
getSuppliersOptions('supplierId',$(this).val());
$('#previewButton').removeAttr('disabled');
});
});
function saveNewPriceList() {
var data = getNewPriceParams();
var url = '../submit/submitSupplierMaterial.php';
submitNewPrice(url, data);
}
function getNewPriceParams() {
var dataArray = new Array();
<?php
include_once '../nyro_header.php';
$fuelLoadId = $_GET['fuelLoadId'];
$fuelLoadInfo = objectQuery($conexion, '*', 'fuel_load', 'fuelLoadId = ' . $fuelLoadId);
?>
<script type="text/javascript">
$(document).ready(function() {
//$('#submitButton').click(function() {
$(document).one('click', '#submitEditFuelLoadButton', function() {
console.log("algo");
//closeNM();
submitEditFuelLoad();
});
});
function submitEditFuelLoad() {
disableButton()
var data = getEditFuelLoadParams();
var url = '../submit/submitEditFuelLoad.php';
submitNewObject(url, data);
}
function disableButton() {
$('#submitButton').attr('disabled','disabled');
}
function enableButton() {
$('#submitButton').removeAttr('disabled');
