cld/protected/class/receipt.func.php

<?php
/**
 * 获得借款单详情
 */
function _getReceiptLoanHtml($receiptDetail,$verifylist,$extendHtml='') {
	$receiptDetail ['loanItem'] = json_decode ( $receiptDetail ['loanItem'], true );
	$receiptDetail ['sumCN'] = num_to_rmb ( $receiptDetail ['sum'] );
	$receiptDetail ['loanSumCN'] = num_to_rmb ( $receiptDetail ['loanSum'] );
	$receiptDetail ['amountCN'] = num_to_rmb ( $receiptDetail ['amount'] );
	
	$executeCopy=getExecuteStaff($receiptDetail);
	//print_r ( $executeCopy );
	
	$html = '<div class="saeaList">
							<div class="entry loan-list" style="margin-bottom: 50px">
								<div class="seal"></div>
								<div class="seTable">
									<table class="table table-bordered table-condensed table-hover">
										<tbody>
											<tr>
												<th colspan="2" class="taC">借款费用</th>
											</tr>
											<tr>
												<th>借款费用</th>
												<td class="taR" width="140">￥' . $receiptDetail ['loanItem'] ['借款费用'] [0] ['price'] . '</td>
											</tr>
											
											<tr>
												<th class="taC" colspan="2">产生费用所在办事处</th>
											</tr>
											<tr>
												<th style="text-align: center" colspan="2">' . $receiptDetail ['category'] [0] ['title'] . '</th>
											</tr>
											<tr>
												<th colspan="2" class="taC">汇款信息</th>
											</tr>
											<tr>
												<th>汇款人户名</th>
												<td>' . $receiptDetail ['remittanceName'] . '</td>
											</tr>
											<tr>
												<th>汇款银行</th>';
	
	if ($receiptDetail ['remittanceBankType'] == 0)
		$html .= '<td>广发银行</td>';
	elseif ($receiptDetail ['remittanceBankType'] == 1)
		$html .= '<td>其他</td>';
	
	$html .= '</tr>
											<tr>
												<th>汇款开户银行名称</th>
												<td>' . $receiptDetail ['bankName'] . '</td>
											</tr>
											<tr>
												<th>汇款帐号</th>
												<td>' . $receiptDetail ['bankNumber'] . '</td>
											</tr>';
	if ($receiptDetail ['remittanceBankType'] == 1)
		$html .= '<tr>
												<th>联行号</th>
												<td>' . $receiptDetail ['coupletNumber'] . '</td>
											</tr>';
	
	$html .= '<tr>
												<th class="taC" colspan="2">费用说明</th>
											</tr>
											<tr>
												<td colspan="2">' . $receiptDetail ['explanation'] . '</td>
											</tr>
											
											<tr class="warning">
												<td class="taR"><b>（' . $receiptDetail ['receiptOrder'] . '）本次费用合计</b></td>
												<td class="taR"><b style="font-size: 24px">￥' . $receiptDetail ['sum'] . '</b><br>' . $receiptDetail ['sumCN'] . '</td>
											</tr>
											<tr class="warning">
												<td class="taR"><b>汇款金额</b></td>
												<td class="taR" width="140"><b style="font-size: 24px">￥' . $receiptDetail ['amount'] . '</b><br>' . $receiptDetail ['amountCN'] . '</td>
											</tr>
										</tbody>
									</table>
								</div>
								<div class="seCensor loan-censor">
									<div class="title">' . $receiptDetail ['receiptOrder'] . '</div>
									<div class="censorList clearfix censorHeight" style="height: 548px;">
										<ul>
											<li class="post">
												<div class="avtra">
													<img src="' . $receiptDetail ['staffDetail']['avatar'] . '_2.jpg" width="32">
												</div>
												<div class="comment">
													<p>
														<span class="fR">' . $receiptDetail ['date'] . '</span>' . $receiptDetail ['staffDetail']['username'] . '
													</p>
													<p>提交审批</p>
												</div>
											</li>';
											foreach ($verifylist as $key=>$value){
											$html.='<li ';
											if ($value['status']==1){
												$html.='class="done"';
											}elseif($value['status']==3){
												$html.='class="undone"';
											}
											$html.='>
												<div class="avtra">
													<img src="'.$value[2].'_2.jpg" width="32">
												</div>
												<div class="comment">
													<p class="colGray">
														<span class="fR">'.$value['date'].'</span>'.$value[1].'';
											if(isset($value['rolename'])){
												$html.='（'.$value['rolename'].'）';
											}
													$html.='</p>
													<p>'.$value['opinion'].'</p>
												</div>
											</li>';
											}
											
											foreach ($executeCopy as $key=>$value){
											$html.='<li ';
											if ($value['status']==1){
												$html.='class="done"';
											}elseif($value['status']==3){
												$html.='class="undone"';
											}	
											$html.='>
												<div class="avtra">
													<img src="'.$value[2].'_2.jpg" width="32">
												</div>
												<div class="comment">
													<p class="colGray">
														<span class="fR">'.$value['date'].'</span>'.$value[1].'（费用执行）
													</p>
													<p>'.$value['opinion'].'</p>
												</div>
											</li>';
											}
										$html.='
										</ul>
									</div>
								</div>
							</div>
												
							'.$extendHtml.'
							
			</div>';
	return $html;
}
function _getPaymentsCollectPayByYearHtml($statisticsPay = array()) {
	$html = '';
	$subtotalSum = array (
			1 => 0,
			2 => 0,
			3 => 0,
			4 => 0,
			5 => 0,
			6 => 0,
			7 => 0,
			8 => 0,
			9 => 0,
			10 => 0,
			11 => 0,
			12 => 0 
	);
	for($i = 1; $i <= 15; $i ++) {
		
		if ($i == 1) {
			
			$html = '<tr><th colspan="2" >银行手续费</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '' && $value ['month'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotalSum [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colRed">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 2) {
			
			$html .= '<tr><th colspan="2" >总部电话费</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '' && $value ['month'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotalSum [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colRed">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 3) {
			
			$subtotal = array (
					1 => 0,
					2 => 0,
					3 => 0,
					4 => 0,
					5 => 0,
					6 => 0,
					7 => 0,
					8 => 0,
					9 => 0,
					10 => 0,
					11 => 0,
					12 => 0 
			);
			$html .= '<tr><th rowspan="4" width="90">缴税</th>';
			$html .= '<th width="90">增值税</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '增值税' && $value ['month'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotal [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">税金附加</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '税金附加' && $value ['month'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotal [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">企业所得税</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '企业所得税' && $value ['month'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotal [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90" class="colRed">小计</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$sum += $subtotal [$month];
				$subtotalSum [$month] += $subtotal [$month];
				
				if (! empty ( $subtotal [$month] ))
					$html .= '<td class="taR colRed">￥' . $subtotal [$month] . '</td>';
				else
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colRed">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 5) {
			
			$html .= '<tr><th colspan="2" >保证金</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '' && $value ['month'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . abs ( $value ['payPrice'] ) . '</td>';
						$sum += abs ( $value ['payPrice'] );
						$subtotalSum [$month] += abs ( $value ['payPrice'] );
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colRed">￥' . $sum . '</td>';
			$html .= '</tr>';
		}
	}
	
	$html .= '<tr><th class="taR" colspan="2">合计</th>';
	$sum = 0;
	foreach ( $subtotalSum as $key => $value ) {
		$sum += $value;
		if (! empty ( $value ))
			$html .= '<td class="taR colGreen">￥' . $value . '</td>';
		else
			$html .= '<td class="taR">-</td>';
	}
	$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
	$html .= '</tr>';
	$html .= '<tr class="warning"><td class="taR" colspan="2"><b>全年合计</b></td>
	  						<td class="colGreed taR" colspan="14"><b style="font-size:24px">￥' . $sum . '</b></td></tr>';
	
	return array (
			'html' => $html,
			'sum' => $sum 
	);
}

/**
 * 获得汇总 日常收支年
 * @param array $statisticsIncome
 * @return string
 */
function _getPaymentsCollectByYearHtml($statisticsIncome = array()) {
	$html = '';
	$subtotalSum = array (
			1 => 0,
			2 => 0,
			3 => 0,
			4 => 0,
			5 => 0,
			6 => 0,
			7 => 0,
			8 => 0,
			9 => 0,
			10 => 0,
			11 => 0,
			12 => 0 
	);
	for($i = 1; $i <= 15; $i ++) {
		
		if ($i == 1) {
			$subtotal = array (
					1 => 0,
					2 => 0,
					3 => 0,
					4 => 0,
					5 => 0,
					6 => 0,
					7 => 0,
					8 => 0,
					9 => 0,
					10 => 0,
					11 => 0,
					12 => 0 
			);
			$html .= '<tr><th rowspan="4" width="90">利息收入</th>';
			$html .= '<th width="90">银行存款</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '银行存款' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">活期理财收益</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '活期理财收益' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">固定理财收益</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '固定理财收益' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">个人借款</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '个人借款' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90" class="colGreen">小计</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$sum += $subtotal [$month];
				$subtotalSum [$month] += $subtotal [$month];
				
				if (! empty ( $subtotal [$month] ))
					$html .= '<td class="taR colGreen">￥' . $subtotal [$month] . '</td>';
				else
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 2) {
			
			$subtotal = array (
					1 => 0,
					2 => 0,
					3 => 0,
					4 => 0,
					5 => 0,
					6 => 0,
					7 => 0,
					8 => 0,
					9 => 0,
					10 => 0,
					11 => 0,
					12 => 0 
			);
			$html .= '<tr><th rowspan="3" width="90">补贴收入</th>';
			$html .= '<th width="90">社保</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '社保' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">财政</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '财政' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90" class="colGreen">小计</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$sum += $subtotal [$month];
				$subtotalSum [$month] += $subtotal [$month];
				if (! empty ( $subtotal [$month] ))
					$html .= '<td class="taR colGreen">￥' . $subtotal [$month] . '</td>';
				else
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 3) {
			
			$html .= '<tr><th colspan="2" >纵横知道</th>';
			
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotalSum [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 4) {
			
			$subtotal = array (
					1 => 0,
					2 => 0,
					3 => 0,
					4 => 0,
					5 => 0,
					6 => 0,
					7 => 0,
					8 => 0,
					9 => 0,
					10 => 0,
					11 => 0,
					12 => 0 
			);
			$html .= '<tr><th rowspan="3" width="90">借款收回</th>';
			$html .= '<th width="90">备用金</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '备用金' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">私人借款</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '私人借款' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90" class="colGreen">小计</th>';
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$sum += $subtotal [$month];
				$subtotalSum [$month] += $subtotal [$month];
				if (! empty ( $subtotal [$month] ))
					$html .= '<td class="taR colGreen">￥' . $subtotal [$month] . '</td>';
				else
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 5) {
			
			$html .= '<tr><th colspan="2" >退汇</th>';
			
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotalSum [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 6) {
			
			$html .= '<tr><th colspan="2" >其他</th>';
			
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotalSum [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 8) {
			
			$html .= '<tr><th colspan="2" >保证金</th>';
			
			$sum = 0;
			for($month = 1; $month <= 12; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '' && $value ['month'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotalSum [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		}
	}
	
	$html .= '<tr><th class="taR" colspan="2">合计</th>';
	$sum = 0;
	foreach ( $subtotalSum as $key => $value ) {
		$sum += $value;
		if (! empty ( $value ))
			$html .= '<td class="taR colGreen">￥' . $value . '</td>';
		else
			$html .= '<td class="taR">-</td>';
	}
	$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
	$html .= '</tr>';
	$html .= '<tr class="warning"><td class="taR" colspan="2"><b>全年合计</b></td>
	  						<td class="colGreed taR" colspan="14"><b style="font-size:24px">￥' . $sum . '</b></td></tr>';
	
	return array (
			'html' => $html,
			'sum' => $sum 
	);
}

/**
 * 获得汇总 日常收支年
 * @param array $statisticsIncome
 * @return string
 */
function _getPaymentsCollectByDayHtml($statisticsIncome = array(), $day = 0) {
	$html = '<tr><th class="taC" colspan="2">日常收入</th>';
	
	for($d = 1; $d <= $day; $d ++) {
		$subtotalSum [$d] = 0;
		$html .= '<th class="taC" width="80">' . $d . '日</th>';
	}
	$html .= '<th class="taC" width="110">总计</th></tr>';
	
	for($i = 1; $i <= 15; $i ++) {
		
		if ($i == 1) {
			
			for($d = 1; $d <= $day; $d ++) {
				$subtotal [$d] = 0;
			}
			
			// $subtotal = array (
			// 1 => 0,
			// 2 => 0,
			// 3 => 0,
			// 4 => 0,
			// 5 => 0,
			// 6 => 0,
			// 7 => 0,
			// 8 => 0,
			// 9 => 0,
			// 10 => 0,
			// 11 => 0,
			// 12 => 0
			// );
			$html .= '<tr><th rowspan="4" width="90">利息收入</th>';
			$html .= '<th width="90">银行存款</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '银行存款' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">理财收益</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '理财收益' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">个人借款</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '个人借款' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90" class="colGreen">小计</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$sum += $subtotal [$month];
				$subtotalSum [$month] += $subtotal [$month];
				
				if (! empty ( $subtotal [$month] ))
					$html .= '<td class="taR colGreen">￥' . $subtotal [$month] . '</td>';
				else
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 2) {
			
			for($d = 1; $d <= $day; $d ++) {
				$subtotal [$d] = 0;
			}
			$html .= '<tr><th rowspan="3" width="90">补贴收入</th>';
			$html .= '<th width="90">社保</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '社保' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">财政</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '财政' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90" class="colGreen">小计</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$sum += $subtotal [$month];
				$subtotalSum [$month] += $subtotal [$month];
				if (! empty ( $subtotal [$month] ))
					$html .= '<td class="taR colGreen">￥' . $subtotal [$month] . '</td>';
				else
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 3) {
			
			$html .= '<tr><th colspan="2" >纵横知道</th>';
			
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotalSum [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 4) {
			
			for($d = 1; $d <= $day; $d ++) {
				$subtotal [$d] = 0;
			}
			$html .= '<tr><th rowspan="3" width="90">借款收回</th>';
			$html .= '<th width="90">备用金</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '备用金' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">私人借款</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '私人借款' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotal [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90" class="colGreen">小计</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$sum += $subtotal [$month];
				$subtotalSum [$month] += $subtotal [$month];
				if (! empty ( $subtotal [$month] ))
					$html .= '<td class="taR colGreen">￥' . $subtotal [$month] . '</td>';
				else
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 5) {
			
			$html .= '<tr><th colspan="2" >退汇</th>';
			
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotalSum [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 6) {
			
			$html .= '<tr><th colspan="2" >其他</th>';
			
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotalSum [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 8) {
			
			$html .= '<tr><th colspan="2" >保证金</th>';
			
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsIncome as $key => $value ) {
					if ($value ['accountMsg'] == '' && $value ['day'] == $month && $value ['accountType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['inComePrice'] . '</td>';
						$sum += $value ['inComePrice'];
						$subtotalSum [$month] += $value ['inComePrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
			$html .= '</tr>';
		}
	}
	
	$html .= '<tr><th class="taR" colspan="2">合计</th>';
	$sum = 0;
	foreach ( $subtotalSum as $key => $value ) {
		$sum += $value;
		if (! empty ( $value ))
			$html .= '<td class="taR colGreen">￥' . $value . '</td>';
		else
			$html .= '<td class="taR">-</td>';
	}
	$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
	$html .= '</tr>';
	$colspan = $day + 1;
	$html .= '<tr class="warning"><td class="taR" colspan="2"><b>全月合计</b></td>
	  						<td class="colGreed taR" colspan="' . $colspan . '"><b style="font-size:24px">￥' . $sum . '</b></td></tr>';
	
	return array (
			'html' => $html,
			'sum' => $sum 
	);
}
function _getPaymentsCollectPayByDayHtml($statisticsPay = array(), $day = 0) {
	$html = '<tr><th class="taC" colspan="2">日常支出</th>';
	
	for($d = 1; $d <= $day; $d ++) {
		$subtotalSum [$d] = 0;
		$html .= '<th class="taC" width="80">' . $d . '日</th>';
	}
	$html .= '<th class="taC" width="110">总计</th></tr>';
	
	for($i = 1; $i <= 15; $i ++) {
		
		if ($i == 1) {
			
			$html .= '<tr><th colspan="2" >银行手续费</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '' && $value ['day'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotalSum [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colRed">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 2) {
			
			$html .= '<tr><th colspan="2" >总部电话费</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '' && $value ['day'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotalSum [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colRed">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 3) {
			
			for($d = 1; $d <= $day; $d ++) {
				$subtotal [$d] = 0;
			}
			$html .= '<tr><th rowspan="4" width="90">缴税</th>';
			$html .= '<th width="90">增值税</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '增值税' && $value ['day'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotal [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">税金附加</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '税金附加' && $value ['day'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotal [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90">企业所得税</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '企业所得税' && $value ['day'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . $value ['payPrice'] . '</td>';
						$sum += $value ['payPrice'];
						$subtotal [$month] += $value ['payPrice'];
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR">￥' . $sum . '</td>';
			$html .= '</tr>';
			
			$html .= '<th width="90" class="colRed">小计</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$sum += $subtotal [$month];
				$subtotalSum [$month] += $subtotal [$month];
				
				if (! empty ( $subtotal [$month] ))
					$html .= '<td class="taR colRed">￥' . $subtotal [$month] . '</td>';
				else
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colRed">￥' . $sum . '</td>';
			$html .= '</tr>';
		} elseif ($i == 5) {
			
			$html .= '<tr><th colspan="2" >保证金</th>';
			$sum = 0;
			for($month = 1; $month <= $day; $month ++) {
				$falg = true;
				foreach ( $statisticsPay as $key => $value ) {
					if ($value ['expenditureMsg'] == '' && $value ['day'] == $month && $value ['expenditureType'] == $i) {
						$html .= '<td class="taR">￥' . abs ( $value ['payPrice'] ) . '</td>';
						$sum += abs ( $value ['payPrice'] );
						$subtotalSum [$month] += abs ( $value ['payPrice'] );
						$falg = false;
						break;
					}
				}
				if ($falg)
					$html .= '<td class="taR">-</td>';
			}
			if ($sum == 0)
				$html .= '<td class="taR">-</td>';
			else
				$html .= '<td class="taR colRed">￥' . $sum . '</td>';
			$html .= '</tr>';
		}
	}
	
	$html .= '<tr><th class="taR" colspan="2">合计</th>';
	$sum = 0;
	foreach ( $subtotalSum as $key => $value ) {
		$sum += $value;
		if (! empty ( $value ))
			$html .= '<td class="taR colGreen">￥' . $value . '</td>';
		else
			$html .= '<td class="taR">-</td>';
	}
	$html .= '<td class="taR colGreen">￥' . $sum . '</td>';
	$html .= '</tr>';
	$colspan = $day + 1;
	$html .= '<tr class="warning"><td class="taR" colspan="2"><b>全月合计</b></td>
	  						<td class="colGreed taR" colspan="' . $colspan . '"><b style="font-size:24px">￥' . $sum . '</b></td></tr>';
	
	return array (
			'html' => $html,
			'sum' => $sum 
	);
}

function getExecuteStaff($receiptDetail){
	// 费用执行人相关数据
	$executeCopy = json_decode ( $receiptDetail ['executeCopy'], true );
	$executeStaff = json_decode ( $receiptDetail ['executeStaff'], true );
	foreach ( $executeCopy as $k => $v ) {
		$executeCopy [$k] ['date'] = '';
		$executeCopy [$k] ['opinion'] = '';
		$executeCopy [$k] ['status'] = '';
		if (! empty ( $executeStaff ))
			foreach ( $executeStaff as $m => $u ) {
				if ($v [0] == $m) {
					$executeCopy [$k] ['date'] = $u ['date'];
					$executeCopy [$k] ['opinion'] = $u ['opinion'];
					$executeCopy [$k] ['status'] = $u ['status'];
					break;
				}
			}
	}
	$receiptDetail ['executeCopy'] = $executeCopy;
	return $receiptDetail['executeCopy'];
}

function num_to_rmb($num) {
	$c1 = "零壹贰叁肆伍陆柒捌玖";
	$c2 = "分角元拾佰仟万拾佰仟亿";
	// 精确到分后面就不要了，所以只留两个小数位
	$num = round ( $num, 2 );
	// 将数字转化为整数
	$num = $num * 100;
	if (strlen ( $num ) > 10) {
		return "金额太大，请检查";
	}
	$i = 0;
	$c = "";
	while ( 1 ) {
		if ($i == 0) {
			// 获取最后一位数字
			$n = substr ( $num, strlen ( $num ) - 1, 1 );
		} else {
			$n = $num % 10;
		}
		// 每次将最后一位数字转化为中文
		$p1 = substr ( $c1, 3 * $n, 3 );
		$p2 = substr ( $c2, 3 * $i, 3 );
		
		if ($n != '0' || ($n == '0' && ($p2 == '亿' || $p2 == '万' || $p2 == '元'))) {
			$c = $p1 . $p2 . $c;
		} else {
			$c = $p1 . $c;
		}
		$i = $i + 1;
		// 去掉数字最后一位了
		
		$num = $num / 10;
		// echo $num.'</br>';
		$num = ( int ) $num;
		// $num =floor($num);
		// $num = round ( $num, 0, PHP_ROUND_HALF_DOWN );
		// echo $num.'</br>';
		// 结束循环
		if ($num == 0) {
			break;
		}
	}
	// echo $c.'</br>';
	$j = 0;
	$slen = strlen ( $c );
	while ( $j < $slen ) {
		// utf8一个汉字相当3个字符
		$m = substr ( $c, $j, 6 );
		// 处理数字中很多0的情况,每次循环去掉一个汉字“零”
		if ($m == '零元' || $m == '零万' || $m == '零亿' || $m == '零零') {
			$left = substr ( $c, 0, $j );
			$right = substr ( $c, $j + 3 );
			$c = $left . $right;
			$j = $j - 3;
			$slen = $slen - 3;
		}
		$j = $j + 3;
	}
	// 这个是为了去掉类似23.0中最后一个“零”字
	if (substr ( $c, strlen ( $c ) - 3, 3 ) == '零') {
		$c = substr ( $c, 0, strlen ( $c ) - 3 );
	}
	// 将处理的汉字加上“整”
	if (empty ( $c )) {
		return "零元整";
	} else {
		return $c . "整";
	}
}

/**
 * 数据导出
 * @param array $title 标题行名称
 * @param array $data 导出数据
 * @param string $fileName 文件名
 * @param string $savePath 保存路径
 * @param $type 是否下载 false--保存 true--下载
 * @return string 返回文件全路径
 * @throws PHPExcel_Exception
 * @throws PHPExcel_Reader_Exception @exportExcel(array('姓名','年龄'), array(array('a',21),array('b',23)), '档案', './', true);
 */
function exportExcel($title = array(), $data = array(), $fileName = '', $savePath = './', $isDown = false) {
	Doo::loadClass ( 'PHPExcel1.7.9/PHPExcel' );
	$obj = new PHPExcel ();
	
	// 横向单元格标识
	$cellName = array (
			'A',
			'B',
			'C',
			'D',
			'E',
			'F',
			'G',
			'H',
			'I',
			'J',
			'K',
			'L',
			'M',
			'N',
			'O',
			'P',
			'Q',
			'R',
			'S',
			'T',
			'U',
			'V',
			'W',
			'X',
			'Y',
			'Z',
			'AA',
			'AB',
			'AC',
			'AD',
			'AE',
			'AF',
			'AG',
			'AH',
			'AI',
			'AJ',
			'AK',
			'AL',
			'AM',
			'AN',
			'AO',
			'AP',
			'AQ',
			'AR',
			'AS',
			'AT',
			'AU',
			'AV',
			'AW',
			'AX',
			'AY',
			'AZ' 
	);
	
	$obj->getActiveSheet ( 0 )->setTitle ( 'sheet名称' ); // 设置sheet名称
	$_row = 0; // 设置纵向单元格标识
	if ($title) {
		$_cnt = count ( $title );
		// $obj->getActiveSheet(0)->mergeCells('A'.$_row.':'.$cellName[$_cnt-1].$_row); //合并单元格
		// $obj->setActiveSheetIndex(0)->setCellValue('A'.$_row, '数据导出：'.date('Y-m-d H:i:s')); //设置合并后的单元格内容
		$_row ++;
		$i = 0;
		foreach ( $title as $v ) { // 设置列标题
			$obj->setActiveSheetIndex ( 0 )->setCellValue ( $cellName [$i] . $_row, $v );
			$i ++;
		}
		$_row ++;
	}
	;
	// html_entity_decode("&iuml;&raquo;&iquest;".$value['order_id']);
	
	// 填写数据
	if ($data) {
		$i = 0;
		foreach ( $data as $_v ) {
			$j = 0;
			foreach ( $_v as $_cell ) {
				$obj->getActiveSheet ( 0 )->setCellValueExplicit ( $cellName [$j] . ($i + $_row), $_cell, PHPExcel_Cell_DataType::TYPE_STRING );
				$j ++;
			}
			$i ++;
		}
	}
	
	// 文件名处理
	if (! $fileName) {
		$fileName = uniqid ( time (), true );
	}
	
	$objWrite = PHPExcel_IOFactory::createWriter ( $obj, 'Excel2007' );
	
	if ($isDown) { // 网页下载
		header ( 'pragma:public' );
		header ( "Content-Disposition:attachment;filename=$fileName.xls" );
		header ( 'Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' );
		$objWrite->save ( 'php://output' );
		exit ();
	}
	
	$_fileName = iconv ( "utf-8", "gb2312", $fileName ); // 转码
	$_savePath = $savePath . $_fileName . '.xlsx';
	$objWrite->save ( $_savePath );
	
	return $savePath . $fileName . '.xlsx';
}

?>