• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

PHP to_MDY函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了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;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP to_YMD函数代码示例发布时间:2022-05-23
下一篇:
PHP toUpper函数代码示例发布时间:2022-05-23
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap