}
</script>
<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'>Edit Vendor</th>
</tr>
<?php
$flag = true;
echo createFormRowTextField('Vendor Name', 'editVendorName', $flag ? 'class="bg"' : '', true, "size='14px' value='" . $vendorInfo['vendorName'] . "'");
$flag = !$flag;
echo createFormRowTextField('Vendor Phone', 'editVendorTel', $flag ? 'class="bg"' : '', false, "size='14px' value='" . showPhoneNumber($vendorInfo['vendorTel']) . "'");
$flag = !$flag;
echo createFormRowTextField('Vendor Fax', 'editVendorFax', $flag ? 'class="bg"' : '', false, "size='14px' value='" . showPhoneNumber($vendorInfo['vendorFax']) . "'");
$flag = !$flag;
echo createFormRowTextField('Address', 'editVendorAddressLine1', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $vendorInfo['addressLine1'] . "'");
$flag = !$flag;
echo createFormRowTextField('Address Line 2', 'editVendorAddressLine2', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $vendorInfo['addressLine2'] . "'");
$flag = !$flag;
echo createFormRowTextField('City', 'editVendorAddressCity', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $vendorInfo['addressCity'] . "'");
$flag = !$flag;
echo createFormRow('State', $flag ? 'class="bg"' : '', false, createStateSelect($conexion, 'editVendorAddressState', $vendorInfo['addressState']));
$flag = !$flag;
echo createFormRowTextField('Zip', 'editVendorAddressZip', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $vendorInfo['addressZip'] . "'");
$flag = !$flag;
echo createFormRowTextField('P.O.Box', 'editVendorAddressBox', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $vendorInfo['addressPOBox'] . "'");
$flag = !$flag;
?>
</table>
</tr> <tr> <td class="first" width="172"><strong>Name:</strong><span style="color:red;">*</span></td> <td class="last"> <?if(isset($lastVal['contactName']))echo$lastVal['contactName'];?></td> </tr> <tr class="bg"> <td class="first"><strong>Phone:</strong></td> <td class="last"><?if(isset($lastVal['contactTel']))echo showPhoneNumber($lastVal['contactTel']);?> </td> </tr> <tr> <td class="first" width="172"><strong>Fax:</strong></td> <td class="last"> <?if(isset($lastVal['contactFax']))echo showPhoneNumber($lastVal['contactFax']);?> </td> </tr> <tr class="bg"> <td class="first"><strong>Mobile:</strong></td> <td class="last"><?if(isset($lastVal['contactMobil']))echo showPhoneNumber($lastVal['contactMobil']);?> </td> </tr> <tr> <td class="first" width="172"><strong>Mail:</strong></td> <td class="last"> <?if(isset($lastVal['contactMail']))echo $lastVal['contactMail'];?> </td> </tr> <tr class="bg"> <td class="first"><strong>Address Line:</strong></td> <td class="last"> <?if(isset($lastVal['addressLine1']))echo$lastVal['addressLine1'];?> </td> </tr> <tr> <td class="first" width="172"><strong>Line 2:</strong></td> <td class="last"> <?if(isset($lastVal['addressLine2']))echo$lastVal['addressLine2'];?></td> </tr> <tr class="bg"> <td class="first"><strong>City:</strong></td>
<?php
echo createDeleteIcon('deleteVendor', '../submit/deleteVendor.php', "vendorId={$vendorId}", "Vendor");
?>
</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'>Vendor Information</th>
</tr>
<?php
$flag = true;
echo printTuple($flag ? '' : "class='bg'", 'Vendor Name', $vendorInfo['vendorName']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Vendor Information', $vendorInfo['vendorInfo']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Vendor Telephone', showPhoneNumber($vendorInfo['vendorTel']));
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Vendor Fax', showPhoneNumber($vendorInfo['vendorFax']));
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Address', $vendorInfo['addressLine1']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Address', $vendorInfo['addressCity'] . ", " . $vendorInfo['addressState'] . " " . $vendorInfo['addressZip']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Comment', $vendorInfo['vendorInfo']);
$flag = !$flag;
?>
</table>
</div>
</tr>
<tr class="bg">
<td class="first"><strong>Phone:</strong></td>
<td class="last"><input type="text" class="text" id='brokerTel' name='brokerTel' <?if(isset($lastVal['brokerTel']))echo"value='".showPhoneNumber($lastVal['brokerTel'])."'";?> /></td>
</tr>
<tr>
<td class="first" width="172"><strong>Fax:</strong></td>
<td class="last"><input type="text" class="text" id='brokerFax' name='brokerFax' <?if(isset($lastVal['brokerFax']))echo"value='".showPhoneNumber($lastVal['brokerFax'])."'";?> /></td>
</tr>
<tr class="bg">
<td class="first"><strong>Radio:</strong></td>
<td class="last"><input type="text" class="text" id='brokerRadio' name='brokerRadio' <?if(isset($lastVal['brokerRadio']))echo"value='".$lastVal['brokerRadio']."'";?> /></td>
</tr>
<tr>
<td class="first" width="172"><strong>Mobile:</strong></td>
<td class="last"><input type="text" class="text" id='brokerMobile' name='brokerMobile' <?if(isset($lastVal['brokerMobile']))echo"value='".showPhoneNumber($lastVal['brokerMobile'])."'";?> /></td>
</tr>
<tr class="bg">
<td class="first"><strong>Carrier:</strong></td>
<td class="last">
<?
$queryCarrier = "select * from carrier";
$carriers = mysql_query($queryCarrier,$conexion);
echo "<select name='carrierId' id='carrierId' style='font-family:verdana;font-size:8pt'>";
if(!(isset($lastVal['carrierName'])&&$lastVal['carrierName']!=null))
{
echo "<option selected='selected'>--Select Carrier--</option>";
while($carrier=mysql_fetch_assoc($carriers))
{
echo "<option value='{$carrier['carrierId']}'>{$carrier['carrierName']}</option>";
}
</div> <div class="table"> <form id="formValidate" name="formValidate" method="POST" action="submitMFI.php?i=<?echo$lastVal['addressId'];?>" onsubmit="return validateForm();" > <img src="/trucking/img/bg-th-left.gif" width="8" height="7" alt="" class="left" /> <img src="/trucking/img/bg-th-right.gif" width="7" height="7" alt="" class="right" /> <table class="listing form" cellpadding="0" cellspacing="0"> <tr> <th class="full" colspan="2">Martinez Frogs Inc. Info</th> </tr> <tr> <td class="first" width="172"><strong>Phone Number:</strong></td> <td class="last"><input <?if(isset($lastVal['mfiTel']))echo"value='".showPhoneNumber($lastVal['mfiTel'])."'";?> type="text" class="text" id='mfiTel' name='mfiTel'/></td> </tr> <tr class="bg"> <td class="first"><strong>Fax Number</strong></td> <td class="last"><input <?if(isset($lastVal['mfiFax']))echo"value='".showPhoneNumber($lastVal['mfiFax'])."'";?> type="text" class="text" id='mfiFax' name='mfiFax' /></td> </tr> <tr> <td class="first" width="172"><strong>E-mail address</strong></td> <td class="last"><input <?if(isset($lastVal['mfiMail']))echo"value='".$lastVal['mfiMail']."'";?> type="text" class="text" id='mfiMail' name='mfiMail'/></td> </tr> <tr class="bg"> <td class="first"><strong>Password:</strong></td> <td class="last"><input <?if(isset($lastVal['mfiPass']))echo"value='".$lastVal['mfiPass']."'";?> type="password" class="text" id='mfiPass' name='mfiPass' /></td> </tr> <tr> <td class="first" width="172"><strong>Password Confirm:</strong></td> <td class="last"><input <?if(isset($lastVal['mfiPass']))echo"value='".$lastVal['mfiPass']."'";?> type="password" class="text" id='mfiPassConfirm' name='mfiPassConfirm'/></td> </tr> <tr class="bg"> <td class="first"><strong>Address Line:</strong></td>
<tr><th>Date</th><th>Invoice #</th></tr> <tr><td><? echo to_MDY($projectInfo['invoiceDate']);?></td><td class="invoiceTd" ><? echo $projectInfo['invoiceId'];?></td></tr> <tr><th>Terms</th><th>Due Date</th></tr> <tr><td><? echo $projectInfo2['termName'];?></td><td><? echo $dueDate;?></td></tr> </table> </td> </tr> <tr> <td> <table class="billinfo"> <th width="90%">Bill To</th> <tr><td width='177' ><? echo $projectInfo2['customerName']; ?></td></tr> <tr><td><? echo $projectInfo2['customerAddress']==""?"P.O. Box: ".$projectInfo2['customerBox'] :$projectInfo2['customerAddress'] ; ?></td></tr> <tr><td><? echo $projectInfo2['customerCity'].", ".$projectInfo2['customerState']." ".$projectInfo2['customerZip']; ?></td></tr> <tr><td><? echo "Ph # ".showPhoneNumber($projectInfo2['customerTel']); ?></td></tr> <tr><td><? echo "Fax # ".showPhoneNumber($projectInfo2['customerFax']); ?></td></tr> </table> </td> <td> </td> <td> <table class="proinfo"> <tr><th>Project</th><td><? echo $projectInfo1['projectName'] ?></td></tr> <tr><th>Address</th><td><? echo $projectInfo1['projectAddress']." ".$projectInfo1['projectCity'].", ".$projectInfo1['projectState']; ?></th></tr> </table> </td> </tr> </table> <? if($projectInfo['invoiceComment']!="")echo "
</tr> <tr> <td class="first" width="172"><strong>Name:</strong><span style="color:red;">*</span></td> <td class="last"><input type="text" class="text" id='contactName' name='contactName' <?if(isset($lastVal['contactName']))echo"value='".$lastVal['contactName']."'";?> /></td> </tr> <tr class="bg"> <td class="first"><strong>Phone:</strong></td> <td class="last"><input type="text" class="text" id='contactTel' name='contactTel' <?if(isset($lastVal['contactTel']))echo"value='".showPhoneNumber($lastVal['contactTel'])."'";?> /></td> </tr> <tr> <td class="first" width="172"><strong>Fax:</strong></td> <td class="last"><input type="text" class="text" id='contactFax' name='contactFax' <?if(isset($lastVal['contactFax']))echo"value='".showPhoneNumber($lastVal['contactFax'])."'";?> /></td> </tr> <tr class="bg"> <td class="first"><strong>Mobile:</strong></td> <td class="last"><input type="text" class="text" id='contactMobil' name='contactMobil' <?if(isset($lastVal['contactMobil']))echo"value='".showPhoneNumber($lastVal['contactMobil'])."'";?> /></td> </tr> <tr> <td class="first" width="172"><strong>E-Mail:</strong></td> <td class="last"><input type="text" class="text" id='contactMail' name='contactMail' <?if(isset($lastVal['contactMail']))echo"value='".$lastVal['contactMail']."'";?> /></td> </tr> <tr class="bg"> <td class="first"><strong>Address Line:</strong></td> <td class="last"><input type="text" class="text" id='addressLine1' name='addressLine1' <?if(isset($lastVal['addressLine1']))echo"value='".$lastVal['addressLine1']."'";?> /></td> </tr> <tr> <td class="first" width="172"><strong>Line 2:</strong></td> <td class="last"><input type="text" class="text" id='addressLine2' name='addressLine2' <?if(isset($lastVal['addressLine2']))echo"value='".$lastVal['addressLine2']."'";?> /></td> </tr> <tr class="bg"> <td class="first"><strong>City:</strong></td>
</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'>Supplier Information</th> </tr> <?php $flag = true; $vendorLink = printImgLink(IMG_VIEW, NYRO_CLASS, TITLE_VIEW_VENDOR, createGenericNyroableAttributesSmall($supplierInfo['vendorId'], 'vendor')); echo printTuple($flag ? '' : "class='bg'", 'Supplier Name', $supplierInfo['supplierName']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Supplier Telephone', showPhoneNumber($supplierInfo['supplierTel'])); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Supplier Fax', showPhoneNumber($supplierInfo['supplierFax'])); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Supplier Info', $supplierInfo['supplierInfo']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Address', $supplierInfo['addressLine1']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Address', $supplierInfo['addressCity'] . ", " . $supplierInfo['addressState'] . " " . $supplierInfo['addressZip']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Supplier Dumptime', $supplierInfo['supplierDumptime']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Vendor', $supplierInfo['vendorName'], $vendorLink); $flag = !$flag; ?> </table> </div>
} echo "</select>"; ?></td> </tr> <tr> <td class="first" width="172"><strong>Name:</strong><span style="color:red;">*</span></td> <td class="last"><input type="text" class="text" id='supplierName' name='supplierName' <?if(isset($lastVal['supplierName']))echo"value='".$lastVal['supplierName']."'";?> /></td> </tr> <tr class="bg"> <td class="first"><strong>Phone:</strong></td> <td class="last"><input type="text" class="text" id='supplierTel' name='supplierTel' <?if(isset($lastVal['supplierTel']))echo"value='".showPhoneNumber($lastVal['supplierTel'])."'";?> /></td> </tr> <tr> <td class="first" width="172"><strong>Fax:</strong></td> <td class="last"><input type="text" class="text" id='supplierFax' name='supplierFax' <?if(isset($lastVal['supplierFax']))echo"value='".showPhoneNumber($lastVal['supplierFax'])."'";?> /></td> </tr> <tr class="bg"> <td class="first"><strong>Address Line:</strong></td> <td class="last"><input type="text" class="text" id='addressLine1' name='addressLine1' <?if(isset($lastVal['addressLine1']))echo"value='".$lastVal['addressLine1']."'";?> /></td> </tr> <tr> <td class="first" width="172"><strong>Line 2:</strong></td> <td class="last"><input type="text" class="text" id='addressLine2' name='addressLine2' <?if(isset($lastVal['addressLine2']))echo"value='".$lastVal['addressLine2']."'";?> /></td> </tr> <tr class="bg"> <td class="first"><strong>City:</strong></td> <td class="last"><input type="text" class="text" id='addressCity' name='addressCity' <?if(isset($lastVal['addressCity']))echo"value='".$lastVal['addressCity']."'";?> /></td> </tr> <tr> <td class="first" width="172"><strong>State:</strong></td>
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']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Broker', $brokerInfo['brokerName'], $brokerLink);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Driver SSN', $driverInfo['driverSSN']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Driver Telephone', showPhoneNumber($driverInfo['driverTel']));
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Driver Info', $driverInfo['driverInfo']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Address', $driverInfo['addressLine1']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Address', $driverInfo['addressCity'] . ", " . $driverInfo['addressState'] . " " . $driverInfo['addressZip']);
$flag = !$flag;
?>
</table>
</div>
echo " <a href='/trucking/php/view/viewBroker.php?i=".$lastVal['brokerId']."'><img src='/trucking/img/16.png' width='16' height='16' /></a>"; } ?> </td> </tr> <tr> <td class="first" width="172"><strong>Number:</strong><span style="color:red;">*</span></td> <td class="last"> <?if(isset($lastVal['truckNumber']))echo$lastVal['truckNumber'];?></td> </tr> <tr class="bg"> <td class="first"><strong>Driver:</strong></td> <td class="last"><?if(isset($lastVal['truckDriver']))echo showPhoneNumber($lastVal['truckDriver']);?> </td> </tr> <tr> <td class="first" width="172"><strong>Plates:</strong></td> <td class="last"> <?if(isset($lastVal['truckPlates']))echo showPhoneNumber($lastVal['truckPlates']);?> </td> </tr> <tr class="bg"> <td class="first"><strong>Address Line:</strong></td> <td class="last"> <?if(isset($lastVal['addressLine1']))echo$lastVal['addressLine1'];?> </td> </tr> <tr> <td class="first" width="172"><strong>Line 2:</strong></td> <td class="last"> <?if(isset($lastVal['addressLine2']))echo$lastVal['addressLine2'];?></td> </tr> <tr class="bg"> <td class="first"><strong>City:</strong></td> <td class="last"> <?if(isset($lastVal['addressCity']))echo$lastVal['addressCity'];?> </td> </tr> <tr> <td class="first" width="172"><strong>State:</strong></td>
<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; echo printTuple($flag ? '' : "class='bg'", 'Terms', $customerInfo['termName']); $flag = !$flag; ?> </table> </div>
<td class="last"><?if(isset($lastVal['driverFirstName']))echo$lastVal['driverFirstName']." ".$lastVal['driverLastName'];?></td> </tr> <tr class="bg"> <td class="first"><strong>Phone:</strong></td> <td class="last"><?if(isset($lastVal['driverTel']))echo showPhoneNumber($lastVal['driverTel']);?></td> </tr> <tr> <td class="first" width="172"><strong>Mobile:</strong></td> <td class="last"><?if(isset($lastVal['driverMobile']))echo showPhoneNumber($lastVal['driverMobile']);?></td> </tr> <tr class="bg"> <td class="first"><strong>Carrier:</strong></td> <td class="last"> <? if(isset($lastVal['carrierName'])&&$lastVal['carrierName']!=null) echo showPhoneNumber($lastVal['driverTel']); else echo "<span style='color:red;'>A carrier is not set</span>" ?> </td> </tr> <tr> <td class="first" width="172"><strong>E-mail:</strong></td> <td class="last"><?if(isset($lastVal['driverMail']))echo$lastVal['driverMail'];?></td> </tr> <tr class="bg"> <td class="first"><strong>Address Line:</strong></td> <td class="last"> <?if(isset($lastVal['addressLine1']))echo$lastVal['addressLine1'];?> </td> </tr> <tr> <td class="first" width="172"><strong>Line 2:</strong></td>
$invoiceId = $_GET['i'];
$queryMfi = "\r\nSELECT\r\n\t*,\r\n\tCURDATE()\r\nFROM\r\n\tmfiInfo\r\nJOIN address using (addressId)\r\n";
$frogsInfo = mysql_query($queryMfi, $conexion);
$mfiInfo = mysql_fetch_assoc($frogsInfo);
$queryInfo = "\r\nSELECT\r\n\t*\r\nFROM\r\n\tinvoice\r\nJOIN project using (projectId)\r\nJOIN (select addressId, addressLine1 as projectAddress, addressCity as projectCity, addressState as projectState from address) as pA using (addressId)\r\nJOIN (\r\n\t\tSELECT\r\n\t\t\t*\r\n\t\tFROM\r\n\t\t\tcustomer\r\n\t\tJOIN term using (termId)\r\n\t\tJOIN (select addressId, addressLine1 as customerAddress, addressCity as customerCity, addressState as customerState, addressZip as customerZip from address) as cA using (addressId)\r\n\t\t ) as C using (customerId)\r\nWHERE\r\n\tinvoiceId=" . $invoiceId;
$reg = mysql_query($queryInfo, $conexion);
$projectInfo = mysql_fetch_assoc($reg);
$dueDate = 0 + $projectInfo['termValue'];
$queryInvoice = "\r\nSELECT \r\n\t*\r\nFROM\r\n\tinvoice\r\nJOIN invoiceTicket using (invoiceId)\r\nJOIN ticket using (ticketId)\r\nJOIN (\r\n\tSELECT \r\n\t\t*\r\n\tFROM\r\n\t\titem\r\n\tJOIN material using (materialId)\r\n\tJOIN (select addressId as fromAddressId, addressLine1 as fromAddress from address) as fA using (fromAddressId)\r\n\tJOIN (select addressId as toAddressId, addressLine1 as toAddress from address) as tA using (toAddressId)\r\n\t) as I using(itemId)\r\nJOIN (\r\n\tSELECT\r\n\t\ttruckId,\r\n\t\ttruckNumber,\r\n\t\tbrokerPid\r\n\tFROM\r\n\t\ttruck\r\n\tJOIN broker using(brokerId)\r\n\t) T using(truckId)\r\nWHERE\r\n\tinvoiceId=" . $invoiceId;
$invoices = mysql_query($queryInvoice, $conexion);
$dueDate = date("m/d/Y", strtotime(date("m/d/Y", strtotime($projectInfo['invoiceEndDate'])) . " +" . $projectInfo['termValue'] . " days"));
$date = to_MDY($mfiInfo['CURDATE()']);
$customerFax = showPhoneNumber($projectInfo['customerFax']);
$customerTel = showPhoneNumber($projectInfo['customerTel']);
$mfiTel = showPhoneNumber($mfiInfo['mfiTel']);
$mfiFax = showPhoneNumber($mfiInfo['mfiFax']);
$total = 0;
$count = 0;
$body = "<tr>\r\n\t<th width='10%' >Date</th>\r\n\t<th width='7%' >Truck</th>\r\n\t<th width='13%' >Ticket #</th>\r\n\t<th width='14%' >Material</th>\r\n\t<th width='23%' >From</th>\r\n\t<th width='23%' >To</th>\r\n\t<th width='5%' >L/T/H</th>\r\n\t<th width='10%' >Cost</th>\r\n\t<th width='10%' >Amount</th>\r\n</tr>";
while ($ticket = mysql_fetch_assoc($invoices)) {
$body .= "<tr>";
$body .= "<td>" . to_MDY($ticket['ticketDate']) . "</td>";
$body .= "<td>" . $ticket['brokerPid'] . "-" . $ticket['truckNumber'] . "</td>";
$body .= "<td align=left >" . $ticket['ticketMfi'];
if ($ticket['ticketNumber'] != "") {
$body .= "/" . $ticket['ticketNumber'];
}
$body .= "</td>";
$body .= "<td align=left>" . $ticket['materialName'] . "</td>";
$body .= "<td align=left>" . $ticket['fromAddress'] . "</td>";
$body .= "<td align=left>" . $ticket['toAddress'] . "</td>";
$flag = !$flag;
//parking address
echo createFormRowTextField('Parking Address', 'editSupplierAddressLine1', $flag ? 'class="bg"' : '', false, "size='25px' value='" . $supplierInfo['addressLine1'] . "'");
$flag = !$flag;
echo createFormRowTextField('Address Line 2', 'editSupplierAddressLine2', $flag ? 'class="bg"' : '', false, "size='25px' value='" . $supplierInfo['addressLine2'] . "'");
$flag = !$flag;
echo createFormRowTextField('City', 'editSupplierAddressCity', $flag ? 'class="bg"' : '', false, "size='25px' value='" . $supplierInfo['addressCity'] . "'");
$flag = !$flag;
//state
echo createFormRow('State', $flag ? 'class="bg"' : '', false, createStateSelect($conexion, 'editSupplierAddressState', $supplierInfo['addressState']));
$flag = !$flag;
echo createFormRowTextField('Zip', 'editSupplierAddressZip', $flag ? 'class="bg"' : '', false, "size='25px' value='" . $supplierInfo['addressZip'] . "'");
$flag = !$flag;
echo createFormRowTextField('P.O.Box', 'editSupplierAddressBox', $flag ? 'class="bg"' : '', false, "size='25px' value='" . $supplierInfo['addressPOBox'] . "'");
$flag = !$flag;
echo createFormRowTextField('Dumptime', 'editSupplierDumptime', $flag ? 'class="bg"' : '', false, "size=25px value='" . showPhoneNumber($supplierInfo['supplierDumptime']) . "'");
$flag = !$flag;
echo createFormRow('Additional Information', $flag ? 'class="bg"' : '', false, createInputTextArea('editSupplierInfo', '', 'rows="3" cols="32"', $supplierInfo['supplierInformation']));
$flag = !$flag;
?>
</table>
<table>
<tr>
<td><?php
echo createSimpleButton('submitEditSupplierButton', 'Submit');
?>
</td>
</tr>
</table>
</div>
<caption><?echo $materialInfo['materialName']." for ".$projectInfo['projectName'];?></caption> <tr><th>Date</th><td><? echo to_MDY($mfiInfo['CURDATE()']);?></td></tr> <tr><th>From</th><td><? echo $startDate;?></td></tr> <tr><th>To</th><td><? echo $endDate;?></td></tr> </table> </td> </tr> <tr> <td> <table class="billinfo"> <th width="90%">Customer Info</th> <tr><td width='177' ><? echo $customerInfo['customerName']; ?></td></tr> <tr><td><? echo $customerInfo['addressLine1']; ?></td></tr> <tr><td><? echo $customerInfo['addressCity'].", ".$customerInfo['addressState']." ".$customerInfo['addressZip']; ?></td></tr> <tr><td><? echo "Ph # ".showPhoneNumber($customerInfo['customerTel']); ?></td></tr> <tr><td><? echo "Fax # ".showPhoneNumber($customerInfo['customerFax']); ?></td></tr> </table> </td> <td> </td> <td> </td> </tr> </table> <br> <table align="center" class="report" width="100%" cellspacing="0" > <tr> <th >Date</th> <th >ticket #</th>
</tr> <tr class="bg"> <td class="first"><strong>Additional Information:</strong></td> <td class="last"><?if(isset($lastVal['vendorInfo']))echo $lastVal['vendorInfo'];?> </td> </tr> <tr> <td class="first" width="172"><strong>Comments:</strong></td> <td class="last"> <?if(isset($lastVal['vendorComment']))echo$lastVal['vendorComment'];?></td> </tr> <tr class="bg"> <td class="first"><strong>Phone:</strong></td> <td class="last"> <?if(isset($lastVal['vendorTel']))echo showPhoneNumber($lastVal['vendorTel']);?> </td> </tr> <tr> <td class="first" width="172"><strong>Fax:</strong></td> <td class="last"> <?if(isset($lastVal['vendorFax']))echo showPhoneNumber($lastVal['vendorFax']);?></td> </tr> <tr class="bg"> <td class="first"><strong>Address Line:</strong></td> <td class="last"> <?if(isset($lastVal['addressLine1']))echo$lastVal['addressLine1'];?> </td> </tr> <tr> <td class="first" width="172"><strong>Line 2:</strong></td> <td class="last"> <?if(isset($lastVal['addressLine2']))echo$lastVal['addressLine2'];?></td> </tr> <tr class="bg"> <td class="first"><strong>City:</strong></td> <td class="last"> <?if(isset($lastVal['addressCity']))echo$lastVal['addressCity'];?> </td> </tr> <tr> <td class="first" width="172"><strong>State:</strong></td>
<tbody>
<?
$brokers = mysql_query("select * from broker order by brokerPid asc",$conexion);
$numBrokers=mysql_num_rows($brokers);
$actual=true;
$colorFlag=true;
$tdClass="";
if($numBrokers>0)
{
while($broker=mysql_fetch_assoc($brokers))
{
echo "<tr>";
echo "<td ".$tdClass.">".$broker['brokerPid']."</td>";
echo "<td ".$tdClass." id='broker".$broker['brokerId']."'>".$broker['brokerName']."</td>";
echo "<td ".$tdClass.">".showPhoneNumber($broker['brokerTel'])."</td>";
echo "<td ".$tdClass.">".showPhoneNumber($broker['brokerMobile'])."</td>";
$colorFlag=!$colorFlag;
if($colorFlag)$tdClass="";
else $tdClass="class='bg'";echo "</tr>";
}
}
?>
</tbody>
</table>
</div>
<?
}
?>
</div>
<div id="right-column">
<th colspan='2'>Edit Driver</th>
</tr>
<?php
//Driver
$flag = true;
echo createFormRow('Broker', $flag ? 'class="bg"' : '', true, arrayToSelect(brokersArray($conexion), $driverInfo['brokerId'], 'editDriverBrokerId', 'Broker'));
$flag = !$flag;
echo createFormRowTextField('First Name', 'editDriverFirstName', $flag ? 'class="bg"' : '', true, "size='10px' value='" . $driverInfo['driverFirstName'] . "'");
$flag = !$flag;
echo createFormRowTextField('Last Name', 'editDriverLastName', $flag ? 'class="bg"' : '', true, "size='10px' value='" . $driverInfo['driverLastName'] . "'");
$flag = !$flag;
echo createFormRowTextField('SSN', 'editDriverSsn', $flag ? 'class="bg"' : '', true, "size='10px' value='" . $driverInfo['driverSSN'] . "'");
$flag = !$flag;
echo createFormRowTextField('Phone', 'editDriverTel', $flag ? 'class="bg"' : '', false, "size='10px' value='" . showPhoneNumber($driverInfo['driverTel']) . "'");
$flag = !$flag;
echo createFormRowTextField('Mobile', 'editDriverMobile', $flag ? 'class="bg"' : '', false, "size='10px' value='" . showPhoneNumber($driverInfo['driverMobile']) . "'");
$flag = !$flag;
echo createFormRow('Carrier', $flag ? 'class="bg"' : '', false, createCarrierSelect($conexion, 'editDriverCarrierId'));
$flag = !$flag;
echo createFormRowTextField('E-mail', 'editDriverMail', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $driverInfo['driverMail'] . "'");
$flag = !$flag;
//parking address
echo createFormRowTextField('Parking Address', 'editDriverAddressLine1', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $driverInfo['addressLine1'] . "'");
$flag = !$flag;
echo createFormRowTextField('Address Line 2', 'editDriverAddressLine2', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $driverInfo['addressLine2'] . "'");
$flag = !$flag;
echo createFormRowTextField('City', 'editDriverAddressCity', $flag ? 'class="bg"' : '', false, "size='10px' value='" . $driverInfo['addressCity'] . "'");
$flag = !$flag;
//state
echo createFormRow('State', $flag ? 'class="bg"' : '', false, createStateSelect($conexion, 'editDriverAddressState', $driverInfo['addressState']));
$flag = !$flag;
?> </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']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Broker Contact', $brokerInfo['brokerContactName']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Broker Telephone', showPhoneNumber($brokerInfo['brokerTel'])); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Broker Fax', showPhoneNumber($brokerInfo['brokerFax'])); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Broker Mobile', showPhoneNumber($brokerInfo['brokerMobile'])); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Address', $brokerInfo['addressLine1']); $flag = !$flag; echo printTuple($flag ? '' : "class='bg'", 'Address', $brokerInfo['addressCity'] . ", " . $brokerInfo['addressState'] . " " . $brokerInfo['addressZip']); $flag = !$flag; ?> </table> </div>
if ($_GET['toDate'] == '') {
$toDate = date("Y-m-d");
} else {
$toDate = to_YMD(mysql_real_escape_string($_GET['toDate']));
}
?>
<table class="topt" align="center" >
<tr>
<td width="30%" align="left" >
<table class="invinfo" width='100%'>
<caption>Martinez Frogs Inc.</caption>
<tr><td width='177'><?echo$mfiInfo['addressLine1'];?></td></tr>
<tr><td><?echo$mfiInfo['addressCity'].", ".$mfiInfo['addressState'].". ".$mfiInfo['addressZip'];?></td></tr>
<tr><td><? echo "Ph # ".showPhoneNumber($mfiInfo['mfiTel']); ?></td></tr>
<tr><td><? echo "Fax # ".showPhoneNumber($mfiInfo['mfiFax']); ?></td></tr>
</table>
</td>
<td width="30%" align="center" >
<img src='/mfi/img/logo2print.gif' width="140" height="100" />
</td>
<td width="30%" align="right" >
<table class="invinfo">
<tr><th>Date</th><td><? echo to_MDY($mfiInfo['CURDATE()']);?></td></tr>
</table>
</td>
</tr>
</table>
<table align="center" class="report" width="100%" cellspacing="0" >
<?php
</tr>
<?php
$flag = true;
echo createFormRowTextField('Pid (Short Name)', 'editBrokerPid', $flag ? 'class="bg"' : '', true, "size='14px' value='" . $brokerInfo['brokerPid'] . "'");
$flag = !$flag;
echo createFormRowTextField('Broker Name', 'editBrokerName', $flag ? 'class="bg"' : '', true, "size='14px' value='" . $brokerInfo['brokerName'] . "'");
$flag = !$flag;
echo createFormRowTextField('Contact Name', 'editBrokerContact', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $brokerInfo['brokerContact'] . "'");
$flag = !$flag;
echo createFormRowTextField('Broker Phone', 'editBrokerTel', $flag ? 'class="bg"' : '', false, "size='14px' value='" . showPhoneNumber($brokerInfo['brokerTel']) . "'");
$flag = !$flag;
echo createFormRowTextField('Broker Fax', 'editBrokerFax', $flag ? 'class="bg"' : '', false, "size='14px' value='" . showPhoneNumber($brokerInfo['brokerFax']) . "'");
$flag = !$flag;
echo createFormRowTextField('Broker Radio', 'editBrokerRadio', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $brokerInfo['brokerRadio'] . "'");
$flag = !$flag;
echo createFormRowTextField('Broker Mobile', 'editBrokerMobile', $flag ? 'class="bg"' : '', false, "size='14px' value='" . showPhoneNumber($brokerInfo['brokerMobile']) . "'");
$flag = !$flag;
echo createFormRow('Carrier', $flag ? 'class="bg"' : '', false, createCarrierSelect($conexion, 'editBrokerCarrierId', $brokerInfo['carrierId']));
$flag = !$flag;
echo createFormRowTextField('Broker Email', 'editBrokerMail', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $brokerInfo['brokerEmail'] . "'");
$flag = !$flag;
echo createFormRowTextField('Address', 'editBrokerAddressLine1', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $brokerInfo['addressLine1'] . "'");
$flag = !$flag;
echo createFormRowTextField('Address Line 2', 'editBrokerAddressLine2', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $brokerInfo['addressLine2'] . "'");
$flag = !$flag;
echo createFormRowTextField('City', 'editBrokerAddressCity', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $brokerInfo['addressCity'] . "'");
$flag = !$flag;
echo createFormRow('State', $flag ? 'class="bg"' : '', false, createStateSelect($conexion, 'editBrokerAddressState', $brokerInfo['addressState']));
$flag = !$flag;
echo createFormRowTextField('Zip', 'editBrokerAddressZip', $flag ? 'class="bg"' : '', false, "size='14px' value='" . $brokerInfo['addressZip'] . "'");
$flag = !$flag;
