202 lines
8.1 KiB
PHP
Executable File
202 lines
8.1 KiB
PHP
Executable File
<?php $this->load->view('header');?>
|
||
|
||
<script type="text/javascript">
|
||
var DOMAIN = document.domain;
|
||
var WDURL = "";
|
||
var SCHEME= "<?php echo sys_skin()?>";
|
||
try{
|
||
document.domain = '<?php echo base_url()?>';
|
||
}catch(e){
|
||
}
|
||
//ctrl+F5 增加版本号来清空iframe的缓存的
|
||
$(document).keydown(function(event) {
|
||
/* Act on the event */
|
||
if(event.keyCode === 116 && event.ctrlKey){
|
||
var defaultPage = Public.getDefaultPage();
|
||
var href = defaultPage.location.href.split('?')[0] + '?';
|
||
var params = Public.urlParam();
|
||
params['version'] = Date.parse((new Date()));
|
||
for(i in params){
|
||
if(i && typeof i != 'function'){
|
||
href += i + '=' + params[i] + '&';
|
||
}
|
||
}
|
||
defaultPage.location.href = href;
|
||
event.preventDefault();
|
||
}
|
||
});
|
||
</script>
|
||
|
||
<link rel="stylesheet" href="<?php echo base_url()?>statics/css/report.css" />
|
||
<style>
|
||
#filter-menu .calGrossProfit-wrap{width:85px;}
|
||
#matchCon { width: 280px; margin-right:10px; }
|
||
.mod-report{position: relative;*zoom: 1;padding:66px 0 0 18px;}
|
||
.mod-report .search-wrap{position: fixed;left: 0;top: 0;width: 100%;_position:absolute;_left:expression
|
||
(eval(document.documentElement.scrollLeft));_top:expression(eval(document.documentElement.scrollTop)
|
||
);background: #f5f5f5;}
|
||
.mod-report .search-wrap .s-inner{padding: 18px;}
|
||
.mod-report .search-wrap strong.tit{font-size:14px;line-height: 30px;}
|
||
.mod-report .search-wrap .txt{display: inline-block;*display: inline;*zoom: 1;font-size: 14px;line-height
|
||
: 30px;}
|
||
|
||
.mod-report .grid-wrap:after{content: '.';display: block;clear: both;visibility: hidden;overflow: hidden
|
||
;height: 0;}
|
||
.mod-report .grid-wrap{*zoom: 1;}
|
||
.mod-report .grid-wrap .grid{float: left;padding: 18px;border:1px solid #cfcfcf;background: #fff;box-shadow
|
||
:0 1px 3px rgba(0,0,0,0.2);}
|
||
.mod-report .grid-wrap .H{font-size:24px;font-weight:bold;text-align: center;}
|
||
.mod-report .grid-wrap .R{text-align: right;}
|
||
.mod-report .grid-wrap .B{font-weight: bold;}
|
||
.mod-report .grid-wrap table{border-collapse:collapse;}
|
||
.mod-report .grid-wrap table.caption{margin-bottom: 5px;}
|
||
.mod-report .grid-wrap table.list{border:1px solid #666;}
|
||
.mod-report .grid-wrap table.list td{padding: 5px 5px;border:1px solid #666;}
|
||
.mod-report .grid-wrap table.list thead td{text-align: center;font-weight: bold;}
|
||
.link{ cursor:pointer; }
|
||
.tr-hover{ background:#f8ff94;}
|
||
|
||
#filter-menu .mod-choose-input{position: relative;*zoom: 1;}
|
||
#filter-menu .mod-choose-input .ui-input{padding-right: 25px;width:226px; font-family:"宋体";}
|
||
#filter-menu .ui-datepicker-input{width:105px; font-family:"宋体";}
|
||
.ui-icon-ellipsis{ right:3px; }
|
||
|
||
thead{word-break: keep-all;white-space:nowrap;}
|
||
|
||
@media print{
|
||
body{background: #fff;}
|
||
.mod-report{padding: 0;}
|
||
.mod-report .search-wrap{display: none;}
|
||
.mod-report .grid-wrap .grid{float: none;padding: 0;border:none;background: none;box-shadow:none;}
|
||
.mod-report .grid-wrap table.caption{margin-bottom: 0;}
|
||
.mod-report .grid-wrap table.list{width:100% !important;}
|
||
.mod-report .grid-wrap table.list td{padding: 1px;}
|
||
}
|
||
</style>
|
||
</head>
|
||
<body>
|
||
<div class="mod-report">
|
||
<div class="search-wrap" id="report-search">
|
||
<div class="s-inner cf">
|
||
<div class="fl">
|
||
<ul class="ul-inline">
|
||
<li>
|
||
<input type="text" id="matchCon" class="ui-input" value="请输入客户、供应商或编号查询">
|
||
<input type="checkbox" id="customer" class="vm" />
|
||
<label for="customer" class="f14 vm">客户</label>
|
||
<input type="checkbox" id="supplier" class="vm" />
|
||
<label for="supplier" class="f14 vm">供应商</label>
|
||
</li>
|
||
<li><a class="ui-btn mrb" id="search">查询</a><!-- <a class="ui-btn ui-btn-refresh" id="refresh"
|
||
title="刷新"><b></b></a> --></li>
|
||
</ul>
|
||
</div>
|
||
<div class="fr"><a href="#" class="ui-btn ui-btn-sp mrb fl" id="btn-print">打印</a><a href="#"
|
||
class="ui-btn fl" id="btn-export">导出</a></div>
|
||
|
||
<!-- <div class="fl"> <strong class="tit mrb fl">查询条件</strong>
|
||
<div class="ui-btn-menu fl" id="filter-menu"> <span class="ui-btn menu-btn"> <strong id="selected-period"
|
||
>请选择查询条件</strong><b></b> </span>
|
||
<div class="con">
|
||
<ul class="filter-list">
|
||
<li>
|
||
<label class="tit">日期:</label>
|
||
<input type="text" value="" class="ui-input ui-datepicker-input" name="filter-fromDate"
|
||
id="filter-fromDate" />
|
||
<span>至</span>
|
||
<input type="text" value="" class="ui-input ui-datepicker-input" name="filter-toDate"
|
||
id="filter-toDate" />
|
||
</li>
|
||
</ul>
|
||
<ul class="filter-list" id="more-conditions">
|
||
<li style="height:60px; ">
|
||
<label class="tit">商品:</label>
|
||
<span class="mod-choose-input" id="filter-goods"><input type="text" class="ui-input"
|
||
id="goodsAuto"/><span class="ui-icon-ellipsis"></span></span>
|
||
<p style="color:#999; padding:3px 0 0 0; ">（可用,分割多个编码如1001,1008,2001，或直接输入编码段如1001-1009
|
||
查询）</p>
|
||
</li>
|
||
<li>
|
||
<label class="tit">仓库:</label>
|
||
<span class="mod-choose-input" id="filter-storage"><input type="text" class="ui-input"
|
||
id="storageAuto"/><span class="ui-icon-ellipsis"></span></span>
|
||
</li>
|
||
<li>
|
||
<label class="tit">排序规则:</label>
|
||
<input id="salesQty" type="radio" value="0" name="sort-rule" /><label for="salesQty"
|
||
class="vm">按销售数量</label>
|
||
<input id="salesIncome" type="radio" value="1" name="sort-rule" /><label for="salesIncome"
|
||
class="vm">按销售收入</label>
|
||
</li>
|
||
<li class="chk-list" id="profit-wrap">
|
||
<label class="chk">
|
||
<input type="checkbox" value="1" name="profit" />
|
||
计算毛利</label>
|
||
</li>
|
||
</ul>
|
||
<div class="btns"> <a href="#" id="conditions-trigger" class="conditions-trigger" tabindex
|
||
="-1">更多条件<b></b></a> <a class="ui-btn ui-btn-sp" id="filter-submit" href="#">确定</a> <a class="ui-btn"
|
||
id="filter-reset" href="#" tabindex="-1">重置</a> </div>
|
||
</div>
|
||
</div>
|
||
<a id="refresh" class="ui-btn ui-btn-refresh fl mrb"><b></b></a> <span class="txt fl" id="cur-search-tip"
|
||
></span> </div>
|
||
<div class="fr"><a href="#" class="ui-btn ui-btn-sp mrb fl" id="btn-print">打印</a><a href="#" class
|
||
="ui-btn fl" id="btn-export">导出</a></div>
|
||
--> </div>
|
||
</div>
|
||
<div class="grid-wrap">
|
||
<div class="grid">
|
||
<table width=100% class="caption">
|
||
<tr><td class='H'>往来单位欠款表</td></tr>
|
||
</table>
|
||
<table width="1128px" class="list">
|
||
<thead>
|
||
<tr>
|
||
<td>行号</td>
|
||
<td>往来单位编号</td>
|
||
<td>名称</td>
|
||
<td>往来单位性质</td>
|
||
<td>应收款余额</td>
|
||
<td>应付款余额</td>
|
||
</tr>
|
||
</thead>
|
||
<tbody>
|
||
<?php
|
||
$i = 1;
|
||
$amount1 = 0;
|
||
$amount2 = 0;
|
||
foreach($list as $arr=>$row){
|
||
?>
|
||
<tr>
|
||
<td><?php echo $i?></td>
|
||
<td><?php echo $row['number']?></td>
|
||
<td><?php echo $row['name']?></td>
|
||
<td><?php echo $row['billType']=='SALE' ? '客户' : '供应商'?></td>
|
||
<td class="R"><?php echo $row['billType']=='SALE' ? $row['amount'] : ''?></td>
|
||
<td class="R"><?php echo $row['billType']=='SALE' ? '' : $row['amount']?></td>
|
||
</tr>
|
||
<?php
|
||
$amount1 += $row['billType']=='SALE' ? $row['amount'] : 0;
|
||
$amount2 += $row['billType']=='SALE' ? 0 : $row['amount'];
|
||
$i++;
|
||
}
|
||
?>
|
||
|
||
|
||
<tr>
|
||
<td colspan="4" class="R B">合计：</td>
|
||
<td class="R B"><?php echo $amount1?></td>
|
||
<td class="R B"><?php echo $amount2?></td>
|
||
</tr>
|
||
</tbody>
|
||
</table>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
<script src="<?php echo base_url()?>statics/js/dist/contact-debt.js?ver=20140430"></script>
|
||
</body>
|
||
</html>
|
||
|
||
|
||
|