$csql->setquery("select * from #@__mainkc where p_id='" . $row['productid'] . "'");
$csql->execute();
$totalrec = $csql->gettotalrow();
if ($totalrec == 0) {
$csql->executenonequery("insert into #@__mainkc(p_id,l_id,number) values('" . $row['productid'] . "','" . $row['labid'] . "','" . $row['number'] . "')");
} else {
$csql->executenonequery("update #@__mainkc set number=number+" . $row['number'] . " where p_id='" . $row['productid'] . "'");
}
}
$csql->close();
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
WriteNote('入库单' . $r_dh . '成功保存', $logindate, $loginip, $username);
$newsql = new dedesql(false);
$newsql->executenonequery("insert into #@__reportrk(r_dh,r_people,r_date,r_status) values('" . $r_dh . "','" . $r_people . "','" . $r_date . "','1')");
//写入财务记录
$newsql->executenonequery("insert into #@__accounts(atype,amoney,abank,dtime,apeople,atext) values('支出','" . $money . "','" . BANKID . "','" . $r_date . "','" . $r_people . "','进货支出金额，对应入库单号为：" . $r_dh . "')");
//更新银行金额
$newsql->executenonequery("update #@__bank set bank_money=bank_money-" . $money . " where id='" . BANKID . "'");
$newsql->close();
ShowMsg('产品信息已写入库存表', 'system_rk.php');
$bsql->close();
exit;
}
} else {
if ($action == 'seek') {
//列表
?>
<body>
<table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0">
$money += $row['number'] * getsale($row['productid']);
$csql = new dedesql(false);
$csql->setquery("select * from #@__mainkc where p_id='" . $row['productid'] . "'");
$csql->execute();
$totalrec = $csql->gettotalrow();
if ($totalrec != 0) {
$csql->executenonequery("update #@__mainkc set number=number-" . $row['number'] . " where p_id='" . $row['productid'] . "'");
}
}
$csql->close();
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
WriteNote('退货单' . $r_dh . '成功保存', $logindate, $loginip, $username);
$newsql = new dedesql(false);
$newsql->executenonequery("insert into #@__reportsale(r_dh,r_people,r_date,r_status,r_adid) values('" . $r_dh . "','" . $r_people . "','" . $r_date . "','1','" . $staff . "')");
//写入财务记录
$newsql->executenonequery("insert into #@__accounts(atype,amoney,abank,dtime,apeople,atext) values('收入','" . $money . "','" . BANKID . "','" . $r_date . "','" . $r_people . "','销售产品收入现金，对应销售单号为：" . $r_dh . "')");
//更新银行金额
$newsql->executenonequery("update #@__bank set bank_money=bank_money+" . $money . " where id='" . BANKID . "'");
$newsql->close();
ShowMsg('产品已销售,系统自动跳转到打印界面.', 'sale.php');
$bsql->close();
exit;
}
} else {
if ($action == 'seek') {
//列表
?>
<body>
<table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0">
if ($totalrec != 0) {
$err = $csql->getone();
if ($err['number'] - $row['number'] <= 0) {
$csql->executenonequery("update #@__mainkc set number=0 where p_id='" . $row['productid'] . "'");
} else {
$csql->executenonequery("update #@__mainkc set number=number-" . $row['number'] . " where p_id='" . $row['productid'] . "'");
}
}
}
$csql->close();
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
WriteNote('退货单' . $r_dh . '成功保存', $logindate, $loginip, $username);
$newsql = new dedesql(false);
$newsql->executenonequery("insert into #@__reportbackgys(r_dh,r_people,r_date,r_status) values('" . $r_dh . "','" . $r_people . "','" . $r_date . "','1')");
//写入财务记录
$newsql->executenonequery("insert into #@__accounts(atype,amoney,abank,dtime,apeople,atext) values('收入','" . $money . "','" . BANKID . "','" . $r_date . "','" . $r_people . "','退回供应商返回金额，对应退单号为：" . $r_dh . "')");
//更新银行金额
$newsql->executenonequery("update #@__bank set bank_money=bank_money+" . $money . " where id='" . BANKID . "'");
$newsql->close();
ShowMsg('库存表产品信息已修改', 'system_gys_back.php');
$bsql->close();
exit;
}
} else {
if ($action == 'seek') {
//列表
?>
<body>
<table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0">
