$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);