本文整理汇总了PHP中showPhoneNumber函数的典型用法代码示例。如果您正苦于以下问题:PHP showPhoneNumber函数的具体用法?PHP showPhoneNumber怎么用?PHP showPhoneNumber使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了showPhoneNumber函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: createFormRowTextField
}
</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>
示例2: showPhoneNumber
</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>
示例3: createDeleteIcon
<?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>
示例4:
</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>";
}
示例5: validateForm
</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>
示例6: to_MDY
<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 "
示例7:
</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>
示例8: printImgLink
</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>
示例9:
}
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>
示例10: createDeleteIcon
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>
示例11: showPhoneNumber
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>
示例12: printTuple
<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>
示例13: showPhoneNumber
<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>
示例14: using
$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>";
示例15: createFormRowTextField
$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>