有时候希望一个表格当内容超出了之后,有滑动条,并且希望在滑动的时候某几列固定不动,下面介绍一种利用jquery动态修改列的属性的方法实现的冻结列(固定列)功能:
<!DOCTYPE html>
<html>
<head>
<title></title>
<meta charset="UTF-8">
<link href="/public/static/web_new/css/purchase-jxc.css?v=201903151103" rel="stylesheet" type="text/css">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="hotkeys" content="exit,add,help">
<script type="text/javascript" src="/public/static/web_new/js/jquery.min.js"></script>
<script type="text/javascript" src="WEB_NEW_JS/jquery.hotkeys.js"></script>
<script type="text/javascript" src="WEB_NEW_JS/common.hotkey.js?v=201911061324"></script>
<script type="text/javascript" src="/public/static/web_new/js/common.js"></script>
<script type="text/javascript" src="/public/static/web_new/js/common_set.js"></script>
<script src="/public/static/web_new/js/colResizable-1.3.min.js"></script>
<script src="WEB_NEW_JS/layer/layer.js"></script>
<script type="text/javascript" src="WEB_NEW_JS/common.ajax.js"></script>
<script type="text/javascript" src="WEB_NEW_JS/common.input.js"></script>
<style type="text/css">
.goods-info{
width: 250px;
position: absolute;
background-color: #fff;
border:1px solid #999;
z-index: 999;
padding: 10px;
display: none;
font-size: 13px;
}
.goods-img{
width: 250px;
height: 250px;
position: absolute;
background-color: #fff;
border:1px solid #999;
z-index: 999;
padding: 10px;
top:50%;
margin-top: -125px;
left: 50%;
margin-left: -125px;
text-align: center;
display: none;
}
.goods-img img{
max-height: 240px;
}
</style>
</head>
<body >
<div class="goods-img">
<img src="">
</div>
<div class="goods-info">
<div>
<span>商品全称:</span>
<span id="gi_name"></span>
</div>
<div>
<span>规 格:</span>
<span id="gi_spec"></span>
</div>
<div>
<span>型 号:</span>
<span id="gi_model"></span>
</div>
<div>
<span>单 价:</span>
<span id="gi_ph_price"></span>
</div>
<div>
<span>单位数量:</span>
<span id="gi_count"></span>
</div>
<div id="gi_store"></div>
<div>
<span>备 注:</span>
<span id="gi_marks"></span>
</div>
</div>
<div style="margin: 10px">
<!--内容标题-->
<div class="clearfix">
<div class="fl purchase-cnt-title">商品列表</div>
<div class="fr purchase-cnt-right">
<form action="" method="get" id="search" class="fl">
<input type="radio" name="store_type" id="" value="0" checked>全部
<input type="radio" name="store_type" id="" {if !empty($store_type)} checked {/if} value="1" >有库存
<input type="hidden" name='gc_id' {if !empty($gc_id)} value="{$gc_id}" {/if}></input>
<input type="hidden" name='brand_id' {if !empty($brand_id)} value="{$brand_id}" {/if}></input>
<input type="hidden" name="sort" value="{$sort}">
<input type="hidden" name="field" value="{$field}">
<input placeholder="请输入关键字/助记码" class="sets_section-shuru" name="search" value="{$search}" autocomplete="off" data-cdt="1,1" />
<img src="/public/static/web_new/images/bumen_sousuo.png" class="sets_section-sou" id="sub" />
</form>
<input type="button" value="导出Excel表格" class="fl jicheng-btn" style="margin: 2px 0 0 10px;padding:3px 6px;cursor: pointer;" onclick="export_excel()" />
<script type="text/javascript">
function export_excel()
{
var store_type = $('input[name=store_type]:checked').val();
downLoadImage('./export_goods_list?store_type='+store_type+'&gc_id='+$("input[name=gc_id]").val()+'&brand_id='+$("input[name=brand_id]").val()+'&search='+$("input[name=search]").val());
}
</script>
<input type="button" value="下载商品导入模板" class="fl jicheng-btn" style="margin: 2px 0 0 10px;padding:3px 6px;cursor: pointer;" onclick="downLoadImage('/web_new/excel/create_goods_excel2?v=20200228')" />
<input type="button" value="导入数据" class="fl jicheng-btn" style="margin: 2px 0 0 10px;padding:3px 6px;cursor: pointer;" onclick="select_excel()" />
<input type="file" id="excel_input" name="excel_input" style="display:none" accept=".xls, .xlsx,.csv,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel" onchange="upload_excel(this)">
</div>
</div>
<!--内容表格-->
<div class="table_title" >
<table id="table_title" width="200%" border="0" cellpadding="0" cellspacing="0">
<tr>
<th width="45px" style="z-index:9999" >行号1</th>
<th width="50px" style="z-index:9999" >图片</th>
<th width="200px" style="z-index:9999" data-field="goods_name" onclick ="sort(this)" {if !empty($field) && $field=="goods_name" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>商品全称</th>
<th width="150px" style="z-index:9999" data-field="goods_spec" onclick ="sort(this)" {if !empty($field) && $field=="goods_spec" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>规格</th>
<th width="150px" style="z-index:9999" data-field="goods_model" onclick ="sort(this)" {if !empty($field) && $field=="goods_model" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>型号</th>
<th width="60px">单位</th>
<th width="80px" data-field="goods_ph_price" onclick ="sort(this)" {if !empty($field) && $field=="goods_ph_price" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>单价</th>
<th width="100px" data-field="goods_average_in_price" onclick ="sort(this)" {if !empty($field) && $field=="goods_average_in_price" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>进货均价</th>
<th width="100px" data-field="goods_count" onclick ="sort(this)" {if !empty($field) && $field=="goods_count" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>单位数量</th>
<th width="60px">副单位</th>
<th width="70px">单位关系</th>
<th width="80px">副单价</th>
<th width="100px">副单位1数量</th>
<th width="100px">副单位2数量</th>
<th width="120px">金额</th>
{foreach name="store_list" item="vo"}
<th width="100px">{$vo['store_name']}</th>
<th width="100px">{$vo['store_name']} 副数量1</th>
<th width="100px">{$vo['store_name']} 副数量2</th>
{/foreach}
<th width="80px" data-field="supplier_name" onclick ="sort(this)" {if !empty($field) && $field=="supplier_name" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>供应商</th>
<th width="60px">仓库</th>
<th width="60px">货位</th>
<th width="100px" data-field="goods_price1" onclick ="sort(this)" {if !empty($field) && $field=="goods_price1" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>预设售价1</th>
<th width="100px" data-field="goods_price2" onclick ="sort(this)" {if !empty($field) && $field=="goods_price2" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>预设售价2</th>
<th width="100px" data-field="goods_price3" onclick ="sort(this)" {if !empty($field) && $field=="goods_price3" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>预设售价3</th>
<th width="100px" data-field="goods_price" onclick ="sort(this)" {if !empty($field) && $field=="goods_price" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>零售价</th>
<th width="120px">零售金额</th>
<th width="100px" data-field="goods_alliance_price" onclick ="sort(this)" {if !empty($field) && $field=="goods_alliance_price" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>联盟价格</th>
<th width="120px" data-field="goods_is_alliance" onclick ="sort(this)" {if !empty($field) && $field=="goods_is_alliance" && $sort=="asc" } class="sort sort_up" data-sort="desc" {else} class="sort sort_down" data-sort="asc" {/if}>加入联盟商品</th>
<th width="100px">单位体积(M³)</th>
<th width="140px">备注</th>
<th></th>
</tr>
</table>
</div>
<div class="center">
<table id="sample2" width="200%" border="0" cellpadding="0" cellspacing="0" style="margin-top: -21px;">
<tr>
<th width="45px">行号</th>
<th width="50px" >图片</th>
<th width="200px">商品全称</th>
<th width="150px">规格</th>
<th width="150px">型号</th>
<th width="60px">单位</th>
<th width="80px">单价</th>
<th width="100px">进货均价</th>
<th width="100px">单位数量</th>
<th width="60px">副单位</th>
<th width="70px">单位关系</th>
<th width="80px">副单价</th>
<th width="100px">副单位1数量</th>
<th width="100px">副单位2数量</th>
<th width="120px">金额</th>
{foreach name="store_list" item="vo"}
<th width="100px">{$vo['store_name']}</th>
<th width="100px">{$vo['store_name']} 副数量1</th>
<th width="100px">{$vo['store_name']} 副数量2</th>
{/foreach}
<th width="80px">供应商</th>
<th width="60px">仓库</th>
<th width="60px">货位</th>
<th width="100px">预设售价1</th>
<th width="100px">预设售价2</th>
<th width="100px">预设售价3</th>
<th width="100px">零售价</th>
<th width="120px">零售金额</th>
<th width="100px">联盟价格</th>
<th width="120px">加入联盟商品</th>
<th width="100px">单位体积(M³)</th>
<th width="140px">备注</th>
<th></th>
</tr>
{foreach name="goods_list" item="vo" key='i'}
<tr data-bill_count="{$vo['bill_count']}" value="{$vo['goods_id']}" data-store="{$vo['store_info']}" ondblclick="ondblclick_table()">
<td value="{$vo['goods_id']}" style="z-index:9999" >{$i+1}</td>
<td value="{$vo['goods_id']}" style="text-align: center;z-index:9999">
{if !empty($vo['goods_img'])}
<img style="height: 22px;cursor: pointer;" name="goods_img" src="{$vo['goods_img']}" >
{/if}
</td>
<td value="{$vo['goods_id']}" style="z-index:9999" data-type="goods_name">{$vo['goods_name']}</td>
<td value="{$vo['goods_id']}" style="z-index:9999" data-type="goods_spec">{$vo['goods_spec']}</td>
<td value="{$vo['goods_id']}" style="z-index:9999" data-type="goods_model">{$vo['goods_model']}</td>
<td value="{$vo['goods_id']}" >{$vo['goods_unit']}</td>
<td value="{$vo['goods_id']}" data-type="goods_ph_price">
<input type="text" input_type='input_float' id="goods_ph_price_{$i}" value="{$vo['goods_ph_price']!=0?$vo['goods_ph_price']:''}" onchange="update_price({$i},'goods','goods_id','{$vo['goods_id']}','goods_ph_price',this.value)" autocomplete='off' data-cdt="1,{$i+2}"/>
</td>
<td value="{$vo['goods_id']}">{$vo['goods_average_in_price']}</td>
<td value="{$vo['goods_id']}" data-type="goods_count">
<input type="text" input_type='input_float' id="goods_count_{$i}" value="{$vo['goods_count']!=0?$vo['goods_count']:''}" readonly onchange="update_price({$i},'goods','goods_id','{$vo['goods_id']}','goods_count',this.value)" />
</td>
<td value="{$vo['goods_id']}">{$vo['goods_sub_unit']}</td>
<td value="{$vo['goods_id']}">
<input type="text" input_type='input_float' id="goods_unit_relation_{$i}" value="{$vo['goods_unit_relation']!=0?$vo['goods_unit_relation']*1:''}" onchange="update_price({$i},'goods','goods_id','{$vo['goods_id']}','goods_unit_relation',this.value)" autocomplete='off' data-cdt="2,{$i+2}"/>
</td>
<td value="{$vo['goods_id']}" id="goods_ph_sub_price_{$i}">{if $vo['goods_ph_price']*$vo['goods_unit_relation']>0}{$vo['goods_ph_price']*$vo['goods_unit_relation']}{/if}</td>
<td value="{$vo['goods_id']}" id="goods_sub_count_{$i}">{if $vo['goods_unit_relation']>0}<?php echo round($vo['goods_count']/ $vo['goods_unit_relation'],2);?>{/if}</td>
<td>
{$vo['goods_unit_count2']}
</td>
<td value="{$vo['goods_id']}">{if !empty($vo['goods_store_amount'])}{$vo['goods_store_amount']}{/if}</td>
{foreach name="store_list" item="v"}
<td value="{$vo['goods_id']}">
{if !empty($vo[$v['store_id']]['goods_count'])}{$vo[$v['store_id']]['goods_count']}{/if}
</td>
<td>
{if !empty($vo[$v['store_id']]['goods_count1'])}{$vo[$v['store_id']]['goods_count1']}{/if}
</td>
<td>
{if !empty($vo[$v['store_id']]['goods_count2'])}{$vo[$v['store_id']]['goods_count2']}{/if}
</td>
{/foreach}
<td value="{$vo['goods_id']}">{$vo['supplier_name']}</td>
<td value="{$vo['goods_id']}">{$vo['store_names']}</td>
<td value="{$vo['goods_id']}">{$vo['site_numbers']}</td>
<td value="{$vo['goods_id']}"><input type="text" value="{$vo['goods_price1']!=0?$vo['goods_price1']:''}" input_type='input_float'onchange="update_table_field('goods','goods_id','{$vo['goods_id']}','goods_price1',this.value)" autocomplete='off' data-cdt="3,{$i+2}"/></td>
<td value="{$vo['goods_id']}"><input type="text" input_type='input_float'value="{$vo['goods_price2']!=0?$vo['goods_price2']:''}" onchange="update_table_field('goods','goods_id','{$vo['goods_id']}','goods_price2',this.value)" autocomplete='off' data-cdt="4,{$i+2}"/></td>
<td value="{$vo['goods_id']}"><input type="text" input_type='input_float'value="{$vo['goods_price3']!=0?$vo['goods_price3']:''}" onchange="update_table_field('goods','goods_id','{$vo['goods_id']}','goods_price3',this.value)" autocomplete='off' data-cdt="5,{$i+2}"/></td>
<td value="{$vo['goods_id']}"><input type="text" input_type='input_float' value="{$vo['goods_price']!=0?$vo['goods_price']:''}" onchange="update_table_field('goods','goods_id','{$vo['goods_id']}','goods_price',this.value)" autocomplete='off' data-cdt="6,{$i+2}"/></td>
<td>
{$vo['retail_amount']}
</td>
<td><input type="text" input_type='input_float' value="{$vo['goods_alliance_price']!=0?$vo['goods_alliance_price']:''}" onchange="update_table_field('goods','goods_id','{$vo['goods_id']}','goods_alliance_price',this.value)" autocomplete='off' data-cdt="7,{$i+2}"/></td>
<td value="{$vo['goods_id']}" datatype="goods_is_alliance">
<input type='checkbox' value="{$vo['goods_id']!=0?$vo['goods_id']:''}" {if $vo['goods_is_alliance']==1} checked {/if} onchange="update_alliance_status(this,{$vo['goods_id']},{$i})" class="input_check" id="alliance_status_{$i}"><label for="alliance_status_{$i}"></label>
</td>
<td value="{$vo['goods_id']}">{$vo['goods_volume']}</td>
<td value="{$vo['goods_id']}" data-type="goods_marks"><input type="text" value="{$vo['goods_marks']}" /></td>
<td value="{$vo['goods_id']}"></td>
</tr>
{/foreach}
{for start="$goods_list|count" end="$Think.PAGE_SIZE"}
<tr>
<td style="z-index:9999">{$i+1}</td>
<td style="z-index:9999"> </td>
<td style="z-index:9999"></td>
<td style="z-index:9999"></td>
<td style="z-index:9999"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
{foreach name="store_list" item="v"}
<td></td>
<td></td>
<td></td>
{/foreach}
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
{/for}
<tr class="last">
<td style="z-index:9999">合计</td>
<td style="z-index:9999"></td>
<td style="z-index:9999"></td>
<td style="z-index:9999"></td>
<td style="z-index:9999"></td>
<td></td>
<td></td>
<td></td>
<td id="total_count">{$total_count}</td>
<td></td>
<td></td>
<td></td>
<td id="total_sub_count">{$total_sub_count}</td>
<td id="total_sub_count2">{$total_sub_count2}</td>
<td id="total_amount">{$total_amount}</td>
{foreach name="store_list" item="v"}
<td >{$v['total_count']}</td>
<td>{$v['total_count1']}</td>
<td>{$v['total_count2']}</td>
{/foreach}
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>{$total_retail_amount}</td>
<td></td>
<td></td>
<td>{$total_volume}</td>
<td></td>
<td></td>
</tr>
</table>
</div>
{include file="/common/layout_page"}
</div>
<script type="text/javascript">
$(".center").height(($(document).height()-250));
</script>
<script type="text/javascript">
$(".center").scroll(function(){
var left=$(".center").scrollLeft();
var trs=$(".center table tr");
trs.each(function(i){
$(this).children().eq(0).css({"position":"relative","top":"0px","left":left});
$(this).children().eq(1).css({"position":"relative","top":"0px","left":left,"background-color":"white"});
$(this).children().eq(2).css({"position":"relative","top":"0px","left":left,"background-color":"white"});
$(this).children().eq(3).css({"position":"relative","top":"0px","left":left,"background-color":"white"});
$(this).children().eq(4).css({"position":"relative","top":"0px","left":left,"background-color":"white"});
});
var trs=$(".table_title table tr");
trs.each(function(i){
$(this).children().eq(0).css({"position":"relative","top":"0px","left":left});
$(this).children().eq(1).css({"position":"relative","top":"0px","left":left});
$(this).children().eq(2).css({"position":"relative","top":"0px","left":left});
$(this).children().eq(3).css({"position":"relative","top":"0px","left":left});
$(this).children().eq(4).css({"position":"relative","top":"0px","left":left});
});
});
var perm_update=$("#perm_update",parent.document).val();
var perm_delete=$("#perm_delete",parent.document).val();
$("#but_add_goods",parent.document).click(function(){
if($(this).attr('class')=='xinzeng')
{
var iframeIndex=top.getIframeIndex(parent.document.location.href);
top.open_window('新增商品','800px','43rem','web_new/goods/sets_goodslist_add?iframeIndex='+iframeIndex);
}
})
$("#but_update",parent.document).click(function(){
if(perm_update=="true" && $(this).attr('class')=='xiugai' && $updata_id>0){
var iframeIndex=top.getIframeIndex(parent.document.location.href);
top.open_window('修改商品','770px','43rem','web_new/goods/sets_goodslist_update?goods_id='+$updata_id+'&iframeIndex='+iframeIndex,function() {
window.location.reload();
});
}
});
$("#but_copy_goods",parent.document).click(function(){
if(perm_update=="true" && $(this).attr('class')=='xinzeng' && $updata_id>0){
var iframeIndex=top.getIframeIndex(parent.document.location.href);
top.open_window('复制新增商品','770px','43rem','web_new/goods/copy_goods?goods_id='+$updata_id+'&iframeIndex='+iframeIndex,function() {
window.location.reload();
});
}
});
$("#but_open_bill",parent.document).click(function(){
if($(this).attr('class')=='diaoyuedanju' && $updata_id>0){
var iframeIndex=top.getIframeIndex(parent.document.location.href);
parent.document.location.href='/web_new/goods_turnover/goods_bill_list?goods_id='+$updata_id+'&iframeIndex='+iframeIndex;
}
})
$("#setting",parent.document).click(function(){
var iframeIndex=top.getIframeIndex(parent.document.location.href);
parent.document.location.href='/web_new/goods/sets_goods_store?iframeIndex='+iframeIndex;
})
$("#but_relate",parent.document).click(function(){
if($(this).attr('class')=='setting' && $updata_id>0){
var iframeIndex=top.getIframeIndex(parent.document.location.href);
top.open_window('组合套件','950px','600px','web_new/goods_relate/goods_list?goods_id='+$updata_id+'&iframeIndex='+iframeIndex);
}
})
$('#del',parent.document).click(function(){
if ($updata_id>0 && perm_delete=="true" && $(this).attr('class')=='shanchu') {
/*弹出提示*/
top.layer.confirm('确认删除?', {
btn: ['确认', '取消'] //可以无限个按钮
}, function(index, layero){
top.layer.close(index);
$.getJSON('goods_delete',{goods_id:$updata_id},function(data){
$res=$.parseJSON(data);
if ($res.status!=0) {
top.layer.msg($res.messg);
if ($res.status>0) {
window.location.reload();
}
}
});
}, function(index){
});
}
});
$('#del_page',parent.document).click(function(){
if(perm_delete==false)
{
return;
}
/*弹出提示*/
top.layer.confirm('<font color="red">警告:确认删除当前页全部数据?</font>', {btn: ['确认', '取消']}, function(index, layero){
var goods_ids=[];
$("#sample2").find("tr").each(function(){
var id=$(this).attr("value");
if(id>0 && !($(this).attr("data-bill_count")>0))
{
goods_ids.push(id);
}
});
goods_ids=goods_ids.join(",");
top.layer.close(index);
index=top.layer.load(1, {
shade: [0.1,'#fff'], //0.1透明度的白色背景
});
$.getJSON('goods_delete_by_ids',{goods_ids:goods_ids},function(data){
top.layer.close(index);
$res=$.parseJSON(data);
top.layer.msg($res.messg);
if ($res.status==1) {
window.location.reload();
}
});
}, function(index){
});
});
function ondblclick_table(){
$("#but_update",parent.document).click();
}
set_table_null('sample2');
function select_excel() {
$('#excel_input').click();
}
function upload_excel(obj){
$file=$(obj)[0].files[0];
if($(obj).val()=='undefined' || $(obj).val()==''){
top.layer.msg('请选择文件!');
return false
}
var formData = new FormData();
formData.append("excel_file",$file);
var index=top.layer.load(1, {
shade: [0.1,'#fff'], //0.1透明度的白色背景
});
$.ajax({
url: './export_goods',
type: 'POST',
data: formData,
processData: false,//用于对data参数进行序列化处理 这里必须false
contentType: false, //必须
})
.done(function(data) {
data=$.parseJSON(data);
top.layer.msg(data.msg);
if(data.status==1){
top.topManager.reloadPage();
}
})
.fail(function() {
top.layer.msg('上传失败!');
})
.always(function() {
$(obj).val('');
top.layer.close(index);
});
}
function update_shop_status(obj,goods_id) {
var goods_state=0;
if($(obj).is(':checked'))
{
goods_state=1;
}
$.ajax({
type:'get',
url:'set_shop_status',
data:{goods_id:goods_id,goods_state:goods_state},
dataType: 'json',
success:function(data){
if(data.status!=1){
top.layer.msg(data.msg);
if(goods_state==1)
{
$(obj).attr("checked",false);
}
}
},
error:function(){
top.layer.msg('网络连接失败!');
},
complete:function(){
}
});
}
function update_alliance_status(obj,goods_id,i) {
var goods_is_alliance=0;
if($(obj).is(':checked'))
{
goods_is_alliance=1;
}
$.ajax({
type:'get',
url:'set_alliance_status',
data:{goods_id:goods_id,goods_is_alliance:goods_is_alliance},
dataType: 'json',
success:function(data){
if(data.status!=1){
top.layer.msg(data.msg);
if(goods_is_alliance==1)
{
$(obj).attr("checked",false);
}
else
{
$(obj).attr("checked",true);
}
}
else
{
if(goods_is_alliance==1)
{
$("#shop_status_"+i).attr("checked",true);
}
else
{
$("#shop_status_"+i).attr("checked",false);
}
}
},
error:function(){
top.layer.msg('网络连接失败!');
},
complete:function(){
}
});
}
function update_price(i,table,key_field,key_value,field,value) {
// body...
var goods_ph_price=$('#goods_ph_price_'+i).val();
var goods_count=$('#goods_count_'+i).val();
var goods_unit_relation=$('#goods_unit_relation_'+i).val();
var goods_ph_sub_price=goods_ph_price*goods_unit_relation;
$('#goods_ph_sub_price_'+i).html(goods_ph_sub_price==0?'':goods_ph_sub_price.toFixed(2));
var goods_sub_count=goods_count/goods_unit_relation;
$('#goods_sub_count_'+i).html(goods_sub_count==0?'':goods_sub_count.toFixed(2));
update_table_field(table,key_field,key_value,field,value);
}
</script>
<script>
$updata_id=0;
$("tr:nth-of-type(n+1) td:first-child").click(function(){
$("td:nth-of-type(n+2)").css("background","none").find("input").css("background","none");
$("td:nth-of-type(1)").css("background","#bdd9ed");
$(this).parent("tr").find("td:nth-of-type(-n+5),input").css("background","#7c99b7");
$(this).css("background","#7c99b7 url(WEB_NEW_IAMGE/xuanzhonghang.png) no-repeat 35px 5px");
$updata_id=$(this).attr('value');
})
$(".center tr:nth-of-type(n+1) td:nth-of-type(n+1)").click(function(){
$updata_id=$(this).attr('value');
})
// 点击表格
var index = $(".last td:last-child").index();
$("td:nth-of-type(n+2):nth-of-type(-n+"+index+")").click(function(){
$("td:nth-of-type(n+2)").css("background","none").css("color","black").find("input").css("background","none").css("color","black");
$("td:nth-of-type(1),.last td:nth-of-type(-n+"+index+")").css("background","#bdd9ed").css("color","black");
$(this).css("background","#7c99b7").css("color","white").find("input").css("color","white");
$(this).parent("tr").find($("td:first-child")).css("background","#bdd9ed url(/public/static/web_new/images/xuanzhonghang.png) no-repeat 7px 7px");
if( $(this).parent().find("td:nth-of-type(n+2)").text().length!=0){
var bill_count= $(this).parent().data('bill_count');
if(perm_delete=="true" && bill_count==0 && $updata_id>0){
$("#del",parent.document).removeClass("non-shanchu").addClass("shanchu");
}
else{
$("#del",parent.document).removeClass("shanchu").addClass("non-shanchu");
}
if(perm_update=="true" && $updata_id>0){
$("#but_update",parent.document).removeClass("non-xiugai").addClass("xiugai");
$("#but_copy_goods",parent.document).removeClass("non-xinzeng").addClass("xinzeng");
$("#but_open_bill",parent.document).removeClass("non-diaoyuedanju").addClass("diaoyuedanju");
$("#but_relate",parent.document).removeClass("non-setting").addClass("setting");
}
}else{
$("#del",parent.document).removeClass("shanchu").addClass("non-shanchu");
$("#but_update",parent.document).removeClass("xiugai").addClass("non-xiugai");
$("#but_open_bill",parent.document).removeClass("diaoyuedanju").addClass("non-diaoyuedanju");
$("#but_relate",parent.document).removeClass("setting").addClass("non-setting");
}
})
$("tr:nth-of-type(n+1) td").click(function(){
$("td:nth-of-type(n+2)").css("background","none").css("color","black").find("input").css("background","none").css("color","black");
$("td:nth-of-type(1),.last td:nth-of-type(-n+"+index+")").css("background","#bdd9ed").css("color","black");
$(this).parent("tr").find("td:nth-of-type(-n+"+index+"),input").css("background","#7c99b7").css("color","white");
$(this).parent("tr").find($("td:first-child")).css("color","black").css("background","#bdd9ed url(/public/static/web_new/images/xuanzhonghang.png) no-repeat 7px 7px");
if( $(this).parent().find($("td:nth-of-type(n+1)")).text().length!=0){
var bill_count= $(this).parent().data('bill_count');
if(perm_delete=="true" && bill_count==0 && $updata_id>0){
$("#del",parent.document).removeClass("non-shanchu").addClass("shanchu");
}
else{
$("#del",parent.document).removeClass("shanchu").addClass("non-shanchu");
}
if(perm_update=="true" && $updata_id>0){
$("#but_update",parent.document).removeClass("non-xiugai").addClass("xiugai");
$("#but_copy_goods",parent.document).removeClass("non-xinzeng").addClass("xinzeng");
$("#but_open_bill",parent.document).removeClass("non-diaoyuedanju").addClass("diaoyuedanju");
$("#but_relate",parent.document).removeClass("non-setting").addClass("setting");
}
else{
$("#but_update",parent.document).removeClass("xiugai").addClass("non-xiugai");
$("#but_open_bill",parent.document).removeClass("diaoyuedanju").addClass("non-diaoyuedanju");
$("#but_relate",parent.document).removeClass("setting").addClass("non-etting");
}
}else{
$("#del",parent.document).removeClass("shanchu").addClass("non-shanchu");
$("#but_update",parent.document).removeClass("xiugai").addClass("non-xiugai");
$("#but_open_bill",parent.document).removeClass("diaoyuedanju").addClass("non-diaoyuedanju");
$("#but_relate",parent.document).removeClass("setting").addClass("non-setting");
}
})
$("td:last-child").click(function(){
$(this).css("background","none");
})
function sort(obj) {
$("input[name=field]").val($(obj).data("field"));
$("input[name=sort]").val($(obj).data("sort"));
$('#search').submit();
}
$('input[name=store_type]').click(function(){
$('#search').submit();
})
$("#sub").click(function(){
$('input[name=store_type]:checked').val(0)
$('#search').submit();
})
//
var isShow = true;
$("tr").mouseleave(function(event){
$(".goods-info").hide();
});
$("tr").mouseenter(function(event){
if(isShow==false)
{
return;
}
setTimeout(function(){isShow=true},"100");
isShow=false;
var id=$(this).attr("value");
if(id>0)
{
$("#gi_name").html($(this).find("[data-type=goods_name]").html());
$("#gi_spec").html($(this).find("[data-type=goods_spec]").html());
$("#gi_model").html($(this).find("[data-type=goods_model]").html());
$("#gi_count").html($(this).find("[data-type=goods_count]").find('input').val());
$("#gi_ph_price").html($(this).find("[data-type=goods_ph_price]").find('input').val());
$("#gi_marks").html($(this).find("[data-type=goods_marks]").find('input').val());
//
$("#gi_store").html("");
var store=$(this).data("store");
if(store.length==0)
{
store="[]";
}
store=store.replace(/'/g,'"');
var store_list=JSON.parse(store);
var gi_store="";
for (var i = 0; i <store_list.length; i++) {
if(store_list[i].site_number!=null && store_list[i].site_number!="")
gi_store+="<div><span>"+store_list[i].store_name+"(货位:"+store_list[i].site_number+")"+":</span><span>"+handle_goods_count(store_list[i].store_g_count)+"</span></div>";
else
gi_store+="<div><span>"+store_list[i].store_name+":</span><span>"+handle_goods_count(store_list[i].store_g_count)+"</span></div>";
}
$("#gi_store").html(gi_store);
//
$(".goods-info").css("top",(event.clientY- event.offsetY+$(this).height()-1));
$(".goods-info").css("left",event.clientX);
$(".goods-info").show();
}
});
</script>
<script type="text/javascript" src="WEB_NEW_JS/common_button.js"></script>
<script type="text/javascript" src="WEB_NEW_JS/common.move.js?v=1"></script>
</body>
<script type="text/javascript">
$("[name=goods_img]").click(function(e) {
$(".goods-img").show();
$(".goods-img").find("img").attr("src",$(this).attr("src"));
return false;
});
$(document).click(function () {
$(".goods-img").hide();
});
</script>