本文整理汇总了PHP中to_MDY函数的典型用法代码示例。如果您正苦于以下问题：PHP to_MDY函数的具体用法？PHP to_MDY怎么用？PHP to_MDY使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了to_MDY函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: mysql_fetch_assoc
<th width='15%'>Start </th>
<th width='15%'>End</th>
<th class='last' width='19%'>Total</th>
</tr>
<tbody>
";
$colorFlag=true;
while($invoice = mysql_fetch_assoc($invoices)){
if($colorFlag){echo "<tr id='invoice".$invoice['invoiceId']."'>";}
else{echo "<tr class='bg' id='invoice".$invoice['invoiceId']."'>";}
!$colorFlag;
echo "<td class='first style2' width='7%'>".$invoice['projectId']."</td>";
echo "<td width='29%'>".$invoice['projectName']."</td>";
echo "<td width='15%'>".to_MDY($invoice['invoiceDate'])."</td>";
echo "<td width='15%'>".to_MDY($invoice['invoiceStartDate'])."</td>";
echo "<td width='15%'>".to_MDY($invoice['invoiceEndDate'])."</td>";
echo "<td width='19%'>$".decimalPad($invoice['invoiceTotal'])."</td>";
echo "</tr>";
}echo "</tbody></table>";
}
?>
</div>
<?
/*
$queryContacts = "select * from item order by itemId desc limit 5";
$terms = mysql_query($queryContacts,$conexion);
$numTerms = mysql_num_rows($terms);
if($numTerms>0)
{
echo "<div class='table'>";
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:31，代码来源:LPC-662.php
示例2: decimalPad
} else {
$totalChequeAmount = decimalPad($chequeInfo['customerSuperCheckAmount']);
$totalChequeSum = decimalPad($chequeInfo['total']);
if ($totalChequeSum == $totalChequeAmount) {
$totalSum = $totalChequeSum;
} else {
if ($totalChequeAmount < $totalChequeSum) {
$totalSum = "<span style='color:red;'>{$totalChequeSum}</span>";
} else {
$totalSum = "<span style='color:green;'>{$totalChequeSum}</span>";
}
}
}
$tableHolder .= "<tr>";
$tableHolder .= "<td rowspan='{$rowspan}'>" . $chequeInfo['receiptchequeNumber'] . "</td>";
$tableHolder .= "<td rowspan='{$rowspan}'>" . to_MDY($chequeInfo['receiptchequesDate']) . "</td>";
$tableHolder .= "<td rowspan='{$rowspan}'>" . $totalChequeAmount . "</td>";
$tableHolder .= "<td rowspan='{$rowspan}'>" . $totalSum . "</td>";
$first = true;
$chequesGroupQuery = "SELECT * FROM receiptcheques JOIN invoice USING (invoiceId) JOIN project USING (projectId) WHERE receiptchequeNumber = '" . $chequeInfo['receiptchequeNumber'] . "' ORDER BY invoiceId asc";
//echo $chequesGroupQuery."<br/>";
$chequesGroup = mysql_query($chequesGroupQuery, $conexion);
while ($cheque = mysql_fetch_assoc($chequesGroup)) {
if ($first) {
$first = false;
} else {
$tableHolder .= "</tr><tr>\n";
}
$tableHolder .= "<td>" . decimalPad($cheque['receiptchequesAmount']) . "</td>";
$tableHolder .= "<td>" . $cheque['invoiceId'] . "</td>";
$tableHolder .= "<td>" . $cheque['projectName'] . "</td>";
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:31，代码来源:showCustomerChequesReport.php
示例3: mysql_query
<?php
include "../conexion.php";
include "../commons.php";
include "../password.php";
#################
$title = "Edit";
#################
$subtitle = "Driver";
$description = "Driver Information.";
###############News section###############
$queryNews = "SELECT \r\n\t\t*\r\n\tFROM\r\n\t\tnews\r\n\tORDER BY\r\n\t\tnewsDate desc\r\n\tLIMIT\r\n\t\t1";
$news = mysql_query($queryNews, $conexion);
$lastNew = mysql_fetch_assoc($news);
$lastNew = $lastNew["newsComment"] . " -" . to_MDY($lastNew["newsDate"]);
##########################################
if (isset($_GET['i'])) {
###############To Edit###############
$queryLast = "SELECT \r\n\t\t* \r\n\tFROM\r\n \t\tdriver\r\n \tJOIN (select brokerName, brokerPid, brokerId from broker) as b using (brokerId)\r\n\tJOIN address USING (addressId)\r\n\tJOIN term USING (termId)\r\n\tLEFT JOIN carrier USING (carrierId)\r\n\tLEFT JOIN ethnic USING (ethnicId)\r\n\tLEFT JOIN work USING (workId)\r\n\tWHERE\r\n\t\tdriverId=" . $_GET['i'];
$Last = mysql_query($queryLast, $conexion);
$lastVal = mysql_fetch_assoc($Last);
##########################################
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title><?echo$title." -".$subtitle;?></title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link rel="shortcut icon" href="/trucking/img/favicon.ico" type="image/x-icon" />
<style media="all" type="text/css">@import "../../css/all.css";</style>
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:31，代码来源:editDriver.php
示例4: mysql_query
<tr>
<th class='first'>Ticket MFI</th>
<th>Dump ticket</th>
<th>Date</th>
<th>Truck</th>
<th>Amount</th>
<th class='last'>Broker Amount</th>
</tr>
<?
$ticketsWithItem = mysql_query("select * from ticket JOIN item using (itemId) JOIN truck using (truckId) JOIN broker using (brokerId) where itemId = ".$lastVal['itemId'],$conexion);
$flag = true;
while($ticket = mysql_fetch_assoc($ticketsWithItem)){
echo "<tr ".($flag?"class='bg'":"")." ticketId='".$ticket['ticketId']."' class='lookable'>";
echo "<td>".$ticket['ticketMfi']."</td>";
echo "<td>".$ticket['ticketNumber']."</td>";
echo "<td>".to_MDY($ticket['ticketDate'])."</td>";
echo "<td>".$ticket['brokerPid']."-".$ticket['truckNumber']."</td>";
echo "<td>".decimalPad($ticket['ticketAmount'] * $ticket['itemCustomerCost'])."</td>";
echo "<td>".decimalPad($ticket['ticketBrokerAmount'] * $ticket['itemBrokerCost'])."</td>";
echo "</tr>";
}
?>
</table>
</div>
<?
}
else
{
?>
<div class='table' id='searchBar'>
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:31，代码来源:viewItem.php
示例5: mysql_query
<table class='listing form' cellpadding='0' cellspacing='0' id='searchResultsTable'>
<thead>
<tr class='bg'>
<th>Cheque Number</th>
<th>Date</th>
<th>Amount</th>
<th>Remove</th>
</tr>
</thead>
<tbody>
<?
$superchecks = mysql_query("select * from customer_super_check order by customerSuperCheckId limit 40", $conexion);
while($check = mysql_fetch_assoc($superchecks)){
echo "<tr class='editable' id='paymentRow".$check['customerSuperCheckId']."' superCheckId='".$check['customerSuperCheckId']."' >";
echo "<td>".$check['customerSuperCheckNumber']."</td>";
echo "<td>".to_MDY($check['customerSuperCheckDate'])."</td>";
echo "<td>".decimalPad($check['customerSuperCheckAmount'])."</td>";
echo "<td><img src='/trucking/img/118.png' width='20px' height='20px' class='removablePayment' /></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
<?
}
?>
</div>
<div id="right-column">
<strong class="h">INFO</strong>
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:31，代码来源:editCustomer_Payment.php
示例6: mysql_query
?>
<div class="table" id="oldFuelLoads">
<table class="listing form" cellpadding="0" cellspacing="0">
<tr>
<th class="full" colspan="8">Older Elements</th>
</tr>
<tr>
<th>Date</th>
<th>Broker</th>
<th>Truck</th>
<th>Driver</th>
<th>Start</th>
<th>Finish</th>
<th>Registered</th>
<th>Miles</th>
</tr>
<?php
$fuels = mysql_query("SELECT * FROM fuel_load JOIN broker ON (broker.brokerId = fuel_load.brokerId) JOIN truck USING (truckId) order by fuelLoadId", $conexion);
while ($fuel = mysql_fetch_assoc($fuels)) {
echo "<tr class='doubleClickable' fuelLoadId='" . $fuel['fuelLoadId'] . "'>\n\t\t\t\t\t<td>" . to_MDY($fuel['fuelLoadDate']) . "</td>\n\t\t\t\t\t<td>" . $fuel['brokerName'] . "</td>\n\t\t\t\t\t<td>" . $fuel['brokerPid'] . "-" . $fuel['truckNumber'] . "</td>\n\t\t\t\t\t<td>" . $fuel['fuelLoadCommet'] . "</td>\n\t\t\t\t\t<td>" . $fuel['fuelLoadStart'] . "</td>\n\t\t\t\t\t<td>" . $fuel['fuelLoadFinish'] . "</td>\n\t\t\t\t\t<td>" . $fuel['fuelLoadRegistered'] . "</td>\n\t\t\t\t\t<td>" . $fuel['fuelLoadMileage'] . "</td>\n\t\t\t\t</tr>";
}
?>
</table>
</div>
</div>
<?include_once '../news.php';?>
</div>
<?
include_once '../app_footer.php';
?>
开发者ID:jscasca，项目名称:mfrogs_mfi，代码行数:30，代码来源:newFuelLoad.php
示例7: mysql_query
<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='4'>Pay Cheques for Supplier Invoice [<?php
echo $supplierInvoice['supplierInvoiceNumber'];
?>
]</th>
</tr>
<tr>
<th>Number</th>
<th>Date</th>
<th>Amount</th>
<th>Remove</th>
</tr>
<?php
$cheques = mysql_query("select * from suppliercheque where supplierInvoiceId = {$reportId}", $conexion);
//Truck
$flag = true;
while ($cheque = mysql_fetch_assoc($cheques)) {
$flag = !$flag;
echo "<tr " . ($flag ? "class='bg'" : "") . " id='paycheque" . $cheque['supplierchequeId'] . "'>";
echo "<td>" . $cheque['supplierchequeNumber'] . "</td>";
echo "<td>" . to_MDY($cheque['supplierchequeDate']) . "</td>";
echo "<td>" . decimalPad($cheque['supplierchequeAmount']) . "</td>";
echo "<td>" . createActionIcon(IMG_DELETE, '', 'Delete Payment', '../submit/deleteSupplierCheck.php', 'chequeId=' . $cheque['supplierchequeId'], 'delete', " width='22' height='22'") . "</td>";
echo "</tr>";
}
?>
</table>
</div>
开发者ID:jscasca，项目名称:mfrogs_mfi，代码行数:30，代码来源:manageSupplierInvoice.php
示例8: printImgLink
<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);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Check Number', $customerSuperCheckInfo['customerSuperCheckNumber']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Check Date', to_MDY($customerSuperCheckInfo['customerSuperCheckDate']));
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Check Registration', to_MDY($customerSuperCheckInfo['customerSuperCheckCreationDate']));
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Check Amount', "\$ " . decimalPad($customerSuperCheckInfo['customerSuperCheckAmount']));
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Check Note', $customerSuperCheckInfo['customerSuperCheckNote']);
$flag = !$flag;
echo printTuple($flag ? '' : "class='bg'", 'Credit', "\$ " . decimalPad($customerSuperCheckInfo['checkCredit']));
$flag = !$flag;
?>
</table>
</div>
<?php
if (mysql_num_rows($payments) > 0) {
?>
<div id='formDiv' class='table'>
开发者ID:jscasca，项目名称:mfrogs_mfi，代码行数:31，代码来源:viewCustomerSuperCheck.php
示例9: strtotime
if($paidTotal == null || $paidTotal <= 0 ){ $paid = 'Unpaid';if($paidR)continue;}
if($paidTotal != null && $paidTotal >= $reportTotal && $paidTotal != 0){ $paid = 'Paid'; if($unpaidR)continue;}
if($paidTotal != null && $paidTotal > 0 && $paidTotal < $reportTotal){ $paid = 'Warning';if($paidR)continue;}
if($paidTotal != null && $paidTotal > $reportTotal){ $paid = 'Overpaid'; if($unpaid)continue;}
if($colorFlag){$tbody.= "<tr class='even".$paid." printable' id='report".$invoice['reportId']."' invoice='".$invoice['reportId']."'>";}
else{$tbody.= "<tr class='odd".$paid." printable' id='report".$invoice['reportId']."' invoice='".$invoice['reportId']."'>";}
$colorFlag=!$colorFlag;
$tbody.= "<td>".$invoice['reportId']."</td>";
$tbody.= "<td>".$invoice['brokerPid']."</td>";
$tbody.= "<td>".($invoice['driverFirstName']==null?'----':$invoice['driverLastName'].", ".$invoice['driverFirstName'])."</td>";
$tbody.= "<td>".to_MDY($invoice['reportDate'])."</td>";
$tbody.= "<td>".to_MDY($invoice['reportStartDate'])."</td>";
$tbody.= "<td>".to_MDY($invoice['reportEndDate'])."</td>";
$tbody.= "<td>".(date('m/d/Y', strtotime('+'.$invoice['termValue'].' days', strtotime($invoice['reportEndDate']))))."</td>";
$tbody.= "<td>".decimalPad($reportTotal)."</td>";
$tbody.= "<td>".decimalPad($paidTotal)."</td>";
$tbody.= "<td>".decimalPad($reportTotal - $paidTotal)."</td>";
if($paid == "Overpaid" || $paid == "Paid")$tbody.="<td></td>";
else $tbody.="<td>".createActionIcon(IMG_PAY,'pay'.$invoice['reportId'],'Pay Report','../nyros/payBrokerInvoice.php','reportId='.$invoice['reportId'],'show'," width='22' height='22'")."</td>";
if($paid == "Unpaid") {
$tbody.= "<td>".createActionIcon(IMG_DELETE,'delete'.$invoice['reportId'],'Delete Invoice','../submit/deleteBrokerInvoice.php','reportId='.$invoice['reportId'],'delete'," width='22' height='22'")."</td>";
} else {
$tbody.="<td>".createActionIcon(IMG_MNG,'','Manage Invoice','../nyros/manageBrokerInvoice.php','reportId='.$invoice['reportId'],'show'," width='22' height='22'")."</td>";
}
$tbody.="</tr>";
}
开发者ID:jscasca，项目名称:mfrogs_mfi，代码行数:30，代码来源:getBrokerInvoicesInteractive.php
示例10: mysql_fetch_assoc
if($num_dispatch>0){
while($dispatch = mysql_fetch_assoc($dispatches)){
if($dispatch['truckCount']==$dispatch['dispatchCount']){
$tbody.= "<tr>";
}else
$tbody.= "<tr>";
$tbody.="<td id='dispatch".$dispatch['dispatchId']."' >";
$tbody.= $dispatch['projectName']." <Strong><label id='count".$dispatch['dispatchId']."'>".($dispatch['truckCount']==null?"0":$dispatch['truckCount'])."</label>/<label id='max".$dispatch['dispatchCount']."' >".$dispatch['dispatchCount']."</label></Strong>";
$tbody.="</td>";
$tbody.= "</tr>";
}
}
$tbody.="</tbody>";
$response['tbody']=$tbody;
$response['currentDate']=to_MDY($currentDay);
echo json_encode($response);
}
/*
For Log Actions:
1 -> New (insert into)
2 -> Edit (update from)
3 -> Delete (delete from)
*/
mysql_close();
?>
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:30，代码来源:getDispatch.php
示例11: decimalPad
$paidTotal = decimalPad($paidInfo['totalPaid'] == null ? 0 : $paidInfo['totalPaid']);
$chequeTotal = $paidInfo['number'] == null ? 0 : $paidInfo['number'];
$reportTotal = decimalPad($invoice['supplierInvoiceAmount'] );
if($paidTotal == null || $paidTotal <= 0 || $chequeTotal == 0 ) $paid = 'Unpaid';
if($paidTotal != null && $paidTotal >= $reportTotal && $chequeTotal != 0) $paid = 'Paid';
if($paidTotal != null && $paidTotal > 0 && $paidTotal < $reportTotal) $paid = 'Warning';
if($paidTotal != null && $paidTotal > $reportTotal) $paid = 'Overpaid';
if($colorFlag){$tbody.= "<tr class='even".$paid."' id='invoice".$invoice['supplierInvoiceId']."'>";}
else{$tbody.= "<tr class='odd".$paid."' id='invoice".$invoice['supplierInvoiceId']."'>";}
$colorFlag=!$colorFlag;
$tbody.= "<td>".$invoice['supplierName']."</td>";
$tbody.= "<td>".$invoice['supplierInvoiceNumber']."</td>";
$tbody.= "<td>".to_MDY($invoice['supplierInvoiceDate'])."</td>";
$tbody.= "<td>".decimalPad($reportTotal)."</td>";
$tbody.= "<td>".decimalPad($reportTotal - $paidTotal)."</td>";
$tbody.= "<td>".decimalPad($paidTotal)."</td>";
if($paid == 'Unpaid' || $paid == 'Warning') $tbody.= "<td class='number' ><img src='/trucking/img/87.png' width='24' height='22' class='payable' supplierInvoiceId='".$invoice['supplierInvoiceId']."' /></td>";
else $tbody.= "<td></td>";
if($paid == 'Unpaid')$tbody.= "<td><img src='/trucking/img/118.png' width='20' height='20' class='deletable' supplierInvoiceId='".$invoice['supplierInvoiceId']."' supplierInvoiceNumber='".$invoice['supplierInvoiceNumber']."' /></td>";
else $tbody.= "<td><img src='/trucking/img/2.png' width='24' height='22' class='managable' supplierInvoiceId='".$invoice['supplierInvoiceId']."' /></td>";
$tbody.= "</tr>";
}
}
$tbody.= "</tbody>";
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:30，代码来源:getSupplierReports.php
示例12: mysql_fetch_assoc
$firstBroker = false;
$reportPaid = mysql_fetch_assoc(mysql_query("select * from report JOIN broker using (brokerId) where reportId = " . $payment['reportId'], $conexion));
$tableHolder .= "<td rowspan='" . $reportInfo['totalCheques'] . "'>" . $reportPaid['brokerName'] . "</td>";
} else {
$tableHolder .= "</tr><tr>\n";
}
$tableHolder .= "<td>" . $payment['reportId'] . "</td>";
$tableHolder .= "<td>" . decimalPad($reportTotal) . "</td>";
}
$tableHolder .= "</tr>\n";
} else {
//just one report
$reportPaid = mysql_fetch_assoc(mysql_query("select * from report JOIN broker using (brokerId) where reportId = " . $reportInfo['reportId'], $conexion));
$reportTotal = getReportTotal($reportInfo['reportId'], $conexion);
$tableHolder .= "<tr>";
$tableHolder .= "<td>" . to_MDY($reportInfo['paidchequesDate']) . "</td>";
$tableHolder .= "<td>" . $reportInfo['paidchequeNumber'] . "</td>";
$tableHolder .= "<td align='right'>" . decimalPad($reportInfo['totalPaid']) . "</td>";
$tableHolder .= "<td>" . $reportPaid['brokerName'] . "</td>";
$tableHolder .= "<td>" . $reportPaid['reportId'] . "</td>";
$tableHolder .= "<td align='rigth'>" . decimalPad($reportTotal) . "</td>";
$tableHolder .= "</tr>\n";
}
$globalTotal += $reportInfo['totalPaid'];
}
echo "<tr><td colspan='2'></td><td align='right'>" . decimalPad($globalTotal) . "</td><td colspan='3'></td></tr>";
?>
<tr>
<th>Date</th>
<th>Cheque #</th>
<th>Amount</th>
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:31，代码来源:showChequeReport.php
示例13: mysql_query
if(isset($_GET['materialId'])&&isset($_GET['supplierId']))
{
$queryMaterials =
"SELECT
*
FROM
suppliermaterial
WHERE
materialId = '".$_GET['materialId']."' and
supplierId = '".$_GET['supplierId']."'";
$result = mysql_query($queryMaterials,$conexion);
while($row = mysql_fetch_assoc($result)){
//$jsondata[$row['materialId']]=$row['materialName']."~".$row['supplierMaterialPrice']."~".$row['supplierMaterialLastModified'];
$jsondata['price']=decimalPad($row['supplierMaterialPrice']);
$jsondata['lastModified']=to_MDY($row['supplierMaterialLastModified']);
}
echo json_encode($jsondata);
}
/*
For Log Actions:
1 -> New (insert into)
2 -> Edit (update from)
3 -> Delete (delete from)
*/
mysql_close();
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:29，代码来源:getPrice.php
示例14: mysql_fetch_assoc
$invoices5Info = mysql_fetch_assoc($invoices5);
$queryInvoice6 = "\nSELECT \n\ttruckId, truckNumber\nFROM\n\ttruck\nWHERE\n\ttruckId=" . $invoices3Info['truckId'] . "\n\tORDER BY truckNumber\n\t";
$invoices6 = mysql_query($queryInvoice6, $conexion);
$invoices6Info = mysql_fetch_assoc($invoices6);
$queryInvoice7 = "\nSELECT \n\t*\nFROM\n\tproject JOIN address using (addressId)\nWHERE\n\tprojectId=" . $invoices4Info['projectId'];
$invoices7 = mysql_query($queryInvoice7, $conexion);
$invoices7Info = mysql_fetch_assoc($invoices7);
$queryInvoice8 = "\nSELECT \n\tcustomerId, customerName\nFROM\n\tcustomer\nWHERE\n\tcustomerId=" . $invoices7Info['customerId'];
$invoices8 = mysql_query($queryInvoice8, $conexion);
$invoices8Info = mysql_fetch_assoc($invoices8);
if ($invoices7Info['projectUnder'] == ILLINOIS_PW_ACT || $invoices7Info['projectUnder'] == DAVIS_BACON_ACT) {
$projectsInAct[$invoices7Info['projectName'] . " " . $invoices7Info['addressLine1']] = $invoices7Info['projectUnder'];
}
$row = "";
$row .= "<tr>";
$row .= "<td>" . to_MDY($invoices3Info['ticketDate'], true) . "</td>";
$row .= "<td>" . $invoices8Info['customerName'] . "</td>";
$row .= "<td>" . $projectInfo2['brokerPid'] . "-" . $invoices6Info['truckNumber'] . "</td>";
$row .= "<td align=left >" . $invoices3Info['ticketMfi'];
if ($invoices3Info['ticketNumber'] != "") {
$row .= "/" . $invoices3Info['ticketNumber'];
}
$row .= "</td>";
$row .= "<td align=left>" . $invoices4Info['itemDisplayFrom'] . "</td>";
$row .= "<td align=left>" . $invoices4Info['itemDisplayTo'] . "</td>";
$row .= "<td >" . decimalPad($invoices3Info['ticketBrokerAmount'], 2);
$row .= "</td>";
$row .= "<td align=right >" . decimalPad($invoices4Info['itemBrokerCost'], 2);
$row .= "</td>";
$row .= "<td align=right >" . decimalPad($invoices3Info['ticketBrokerAmount'] * $invoices4Info['itemBrokerCost'], 2);
$row .= "</td>";
开发者ID:jscasca，项目名称:mfrogs_mfi，代码行数:31，代码来源:showBrokerInvoice.php
示例15: strtotime
$startingDate = strtotime($invoice['invoiceDate']);
$dateDiff = $now - $startingDate;
$daysOff = floor($dateDiff / (60 * 60 * 24));
$dueDate = date('Y-m-d', strtotime($invoice['invoiceDate'] . " +" . $termValue . " days"));
$customerTotalAmount += $invoiceAmount;
$lastProjectAmount += $invoiceAmount;
$totalAmount += $invoiceAmount;
$customerTotalBalance += $invoiceBalance;
$lastProjectBalance += $invoiceBalance;
$totalBalance += $invoiceBalance;
$tmpHolder .= "<tr>";
$tmpHolder .= "<td></td>";
$tmpHolder .= "<td>" . $invoice['invoiceId'] . "</td>";
$tmpHolder .= "<td>" . to_MDY($invoice['invoiceDate']) . "</td>";
$tmpHolder .= "<td>" . $daysOff . "</td>";
$tmpHolder .= "<td>" . to_MDY($dueDate) . "</td>";
$tmpHolder .= "<td align='right'>" . $invoiceAmount . "</td>";
$tmpHolder .= "<td align='right'>" . $invoiceBalance . "</td>";
$tmpHolder .= "</tr>\n";
}
$tmpHolder .= "<tr><td colspan='5'></td><td align='right'>" . decimalPad($lastProjectAmount) . "</td><td align='right'>" . decimalPad($lastProjectBalance) . "</td></tr>";
$tmpHolder .= "<tr><td colspan='5'></td><th class='total' align='right'>" . decimalPad($customerTotalAmount) . "</th><th class='total' align='right'>" . decimalPad($customerTotalBalance) . "</th></tr>";
if ($shouldAdd) {
$tableHolder .= $tmpHolder;
}
}
}
echo "<tr><td colspan='5'></td><td align='right'>" . decimalPad($totalAmount) . "</td><td align='right'>" . decimalPad($totalBalance) . "</td></tr>";
?>
<tr>
<th></th>
开发者ID:jscasca，项目名称:mfrogs_mfi，代码行数:31，代码来源:showCustomerBalance.php
示例16: to_MDY
</tr>
<tr class='bg' >
<td>Date:</td>
<td>Broker:</td>
<td>Truck:</td>
<td>Driver:</td>
<td>Start</td>
<td>Finish</td>
<td>Total</td>
<td>Registered</td>
<td>Miles</td>
<td></td>
</tr>
<tr>
<td><input type='text' size='6px' id='fuelDate' name='fuelDate' value='<?echo to_MDY($lastVal['fuelLoadDate']);?>' /></td>
<td colspan='2'>
<?
echo "<select name='brokerId' id='brokerId' style='font-family:verdana;font-size:8pt'>";
echo "<option selected='selected' value='0' >--Select Broker--</option>";
$queryBroker = "SELECT * FROM broker where brokerStatus=1 order by brokerName";
$brokers = mysql_query($queryBroker,$conexion);
while($broker=mysql_fetch_assoc($brokers)){
if($lastVal['brokerId']==$broker['brokerId'])
echo "<option selected='selected' value='".$broker['brokerId']."' >".$broker['brokerName']."</option>";
else
echo "<option value='".$broker['brokerId']."' >".$broker['brokerName']."</option>";
}
echo "</select>";
?><span style="color:red;">*</span>
<br/>
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:31，代码来源:editFuel.php
示例17: while
$count = 0;
while ($ticket = mysql_fetch_assoc($invoices)) {
$queryInvoice1 = "\nSELECT \n\t*\nFROM\n\tticket\nWHERE\n\tticketId=" . $ticket['ticketId'];
$invoices1 = mysql_query($queryInvoice1, $conexion);
if (mysql_num_rows($invoices1) == 0) {
continue;
}
$invoiceInfo1 = mysql_fetch_assoc($invoices1);
$queryInvoice2 = "\nSELECT \n\t*\nFROM\n\titem\nJOIN material using (materialId)\nWHERE\n\titemId=" . $invoiceInfo1['itemId'];
$invoices2 = mysql_query($queryInvoice2, $conexion);
$invoiceInfo2 = mysql_fetch_assoc($invoices2);
$queryInvoice3 = "\nSELECT\n\t\ttruckId,\n\t\ttruckNumber,\n\t\tbrokerPid\n\tFROM\n\t\ttruck\n\tJOIN broker using(brokerId)\nWHERE\n\ttruckId=" . $invoiceInfo1['truckId'];
$invoices3 = mysql_query($queryInvoice3, $conexion);
$invoiceInfo3 = mysql_fetch_assoc($invoices3);
echo "<tr>";
echo "<td>" . to_MDY($invoiceInfo1['ticketDate']) . "</td>";
echo "<td>" . $invoiceInfo3['brokerPid'] . "-" . $invoiceInfo3['truckNumber'] . "</td>";
echo "<td align=left >" . $invoiceInfo1['ticketMfi'];
if ($invoiceInfo1['ticketNumber'] != "" && $invoiceInfo1['ticketNumber'] != $invoiceInfo1['ticketMfi']) {
echo "/" . $invoiceInfo1['ticketNumber'];
}
echo "</td>";
echo "<td align=left>" . $invoiceInfo2['materialName'] . "</td>";
echo "<td align=left>" . $invoiceInfo2['itemDisplayFrom'] . "</td>";
echo "<td align=left>" . $invoiceInfo2['itemDisplayTo'] . "</td>";
echo "<td >" . decimalPad($invoiceInfo1['ticketAmount']);
echo "</td>";
echo "<td align=right >" . decimalPad($invoiceInfo2['itemCustomerCost']);
echo "</td>";
echo "<td align=right >" . decimalPad($invoiceInfo1['ticketAmount'] * $invoiceInfo2['itemCustomerCost']);
echo "</td>";
开发者ID:jscasca，项目名称:mfrogs_mfi，代码行数:31，代码来源:showCustomerInvoice.php
示例18:
if($colorFlag){ $tdClass=""; }
else{ $tdClass=" class='bg' "; }
switch($actual){
case 0:
$colorFlag=!$colorFlag;
echo "<tr>";
echo "<td width='6%'".$tdClass." >".to_MDY($ticket['ticketDate'])."</td>";
echo "<td size='8px' width='6%'".$tdClass." id='ticket".$ticket['ticketId']."' >".$ticket['ticketMfi']."</td>";
echo "<td width='6%'".$tdClass." >".$ticket['ticketNumber']."</td>";
echo "<td width='6%'".$tdClass." >".$invoiceId."</td>";
//echo "<td width='6%'".$tdClass." >".$reportId."</td>";
//echo "<td width='6%'".$tdClass." >".$snvoiceId."</td>";
$actual++;
break;
case 1:
echo "<td width='6%'".$tdClass." >".to_MDY($ticket['ticketDate'])."</td>";
echo "<td size='8px' width='6%'".$tdClass." id='ticket".$ticket['ticketId']."' >".$ticket['ticketMfi']."</td>";
echo "<td width='6%'".$tdClass." >".$ticket['ticketNumber']."</td>";
echo "<td width='6%'".$tdClass." >".$invoiceId."</td>";
//echo "<td width='6%'".$tdClass." >".$reportId."</td>";
//echo "<td width='6% class='last' ".$tdClass." >".$snvoiceId."</td>";
echo "</tr>";
$actual=0;
break;
}
}
switch($actual){
case 0:break;
case 1:echo"<td ".$tdClass." colspan='7'></td></tr>";break;
#case 2:echo"<td ".$tdClass." colspan='6'></td></tr>";break;
}
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:31，代码来源:viewTicket.php
示例19: using
</td>
</tr>
</table>
<br>
<table align="center" class="report" width="100%" cellspacing="0" >
<?php
$tableHolder = "";
$ticketsQuery = "\r\n\tSELECT\r\n\t\t*\r\n\tFROM\r\n\t\tticket\r\n\t\tJOIN item using (itemId)\r\n\t\tJOIN project using (projectId)\r\n\t\tJOIN customer using (customerId)\r\n\t\tJOIN truck using (truckId)\r\n\t\tJOIN broker using (brokerId)\r\n\t\tLEFT JOIN reportticket using (ticketId)\r\n\tWHERE\r\n\t\treportId is null AND\r\n\t\tticketDate >= '" . ($fromDate == "" ? "0000-00-00" : to_YMD($fromDate)) . "' \r\n\t\t" . ($toDate == "" ? "" : " AND ticketDate < '" . to_YMD($toDate) . "' ") . "\r\n\t\t" . ($filter == 0 ? "" : " AND brokerId = " . $filter) . "\r\n\tORDER BY\r\n\t\tticketDate asc\r\n";
//echo $ticketsQuery;
$tickets = mysql_query($ticketsQuery, $conexion);
while ($ticket = mysql_fetch_assoc($tickets)) {
$tableHolder .= "<tr>";
$tableHolder .= "<td>" . to_MDY($ticket['ticketDate']) . "</td>";
$tableHolder .= "<td>" . $ticket['ticketMfi'] . ($ticket['ticketNumber'] == "" ? "" : "/" . $ticket['ticketNumber']) . "</td>";
$tableHolder .= "<td>" . $ticket['customerName'] . "</td>";
$tableHolder .= "<td>" . $ticket['projectName'] . "</td>";
$tableHolder .= "<td>" . $ticket['brokerPid'] . "-" . $ticket['truckNumber'] . "</td>";
$tableHolder .= "</tr>";
}
?>
<tr>
<th >Date</th>
<th >Ticket</th>
<th >Customer</th>
<th >Project</th>
<th >Truck</th>
</tr>
开发者ID:jscasca，项目名称:mfrogs_trucking，代码行数:29，代码来源:showUnreportedTickets.php
示例20: switch
<?php
include_once '../function_header.php';
$objectId = $_REQUEST['objectId'];
$additionalId = $_REQUEST['additionalId'];
$infoNeed = $_REQUEST['type'];
$response['type'] = $infoNeed;
//type = projectInfo | supplierInfo | materialPrice
switch ($infoNeed) {
case 'projectInfo':
$projectInfo = getProjectInfo($conexion, $objectId);
$response['displayFrom'] = $projectInfo['projectName'] . " @ " . $projectInfo['addressLine1'];
break;
case 'supplierInfo':
$supplierInfo = getSupplierInfo($conexion, $objectId);
$response['displayTo'] = $supplierInfo['supplierName'] . " @ " . $supplierInfo['addressLine1'];
break;
case 'materialPrice':
//echo "SELECT * FROM suppliermaterial WHERE materialId = '$objectId' AND supplierId = '$additionalId'";
$materialInfo = mysql_fetch_assoc(mysql_query("SELECT * FROM suppliermaterial WHERE materialId = '{$objectId}' AND supplierId = '{$additionalId}'", $conexion));
$response['materialPrice'] = $materialInfo['supplierMaterialPrice'];
$response['materialLast'] = to_MDY($materialInfo['supplierMaterialLastModified']);
break;
}
echo json_encode($response);
开发者ID:jscasca，项目名称:mfrogs_mfi，代码行数:25，代码来源:getItemAdditionalInfo.php
注：本文中的to_MDY函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论