$db->query($query);
$query = "delete from tb_salelist_tmp where fd_tmpsale_seltid = '{$checkid[$i]}' and fd_tmpsale_type='stockback'";
$db->query($query);
}
}
if ($skdetail_paycardid) {
$arr_skdetail_paycardid = explode(",", $skdetail_paycardid);
changepaycardstate($arr_skdetail_paycardid, '1');
}
countallbackpaycard($listid);
//统计刷卡器数量,金额
echo "<script>alert('删除成功!');location.href='jxcstockback.php?listid={$listid}';</script>";
break;
case "del_one":
//删除细节表数据
$old_paycardid = getdatepaycard("tb_paycardstockbackdetail", "skdetail", $delskdetailid);
foreach ($old_paycardid as $value) {
if ($value != $delpaycard) {
if ($del_paycardid) {
$del_paycardid .= "," . $value;
} else {
$del_paycardid = $value;
}
}
}
$arr_num = explode(",", $del_paycardid);
$paycardnum = count($arr_num);
$query = "update tb_paycardstockbackdetail set fd_skdetail_paycardid='{$del_paycardid}', fd_skdetail_quantity='{$paycardnum}' where fd_skdetail_id = '{$delskdetailid}'";
$db->query($query);
$query = "update tb_salelist_tmp set fd_tmpsale_paycardid='{$del_paycardid}' where fd_tmpsale_seltid = '{$delskdetailid}' and fd_tmpsale_type='stockback'";
$db->query($query);
$query = "delete from tb_salelistdetail where fd_stdetail_id = '{$checkid[$i]}'";
$db->query($query);
$query = "delete from tb_salelist_tmp where fd_tmpsale_seltid = '{$checkid[$i]}' and fd_tmpsale_type='sale'";
$db->query($query);
}
}
if ($stdetail_paycardid) {
$arr_stdetail_paycardid = explode(",", $stdetail_paycardid);
changepaycardstate($arr_stdetail_paycardid, '1');
}
countallsalepaycard($listid, 'tb_salelist', 'tb_salelistdetail');
echo "<script>alert('删除成功!');location.href='jxcsale.php?listid={$listid}';</script>";
break;
case "del_one":
//删除细节表数据
$old_paycardid = getdatepaycard("tb_salelistdetail", "stdetail", $delseltid);
foreach ($old_paycardid as $value) {
if ($value != $delpaycard) {
if ($del_paycardid) {
$del_paycardid .= "," . $value;
} else {
$del_paycardid = $value;
}
}
}
$arr_num = explode(",", $del_paycardid);
$paycardnum = count($arr_num);
$query = "update tb_salelistdetail set fd_stdetail_paycardid='{$del_paycardid}', fd_stdetail_quantity='{$paycardnum}' where fd_stdetail_id = '{$delseltid}'";
$db->query($query);
$query = "update tb_salelist_tmp set fd_tmpsale_paycardid='{$del_paycardid}' where fd_tmpsale_seltid = '{$delseltid}' and fd_tmpsale_type='sale'";
$db->query($query);
