//遍历此单产品
$bsql->SetQuery($query);
$bsql->Execute();
$rowcount = $bsql->GetTotalRow();
if ($rowcount == 0) {
ShowMsg('非法参数或没有要销售的产品!', '-1');
exit;
} else {
checkbank();
$money = 0;
while ($row = $bsql->getArray()) {
$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 . "'");
function getbank($id)
{
$banksql = new dedesql(false);
$banksql->SetQuery("select * from #@__bank where id='{$id}'");
$banksql->Execute();
$bankr = $banksql->gettotalrow();
if ($bankr == 1) {
$rs = $banksql->getone();
return $rs['bank_name'];
} else {
return "<font color=red>已删除银行</font>";
}
$banksql->close();
}
<td bgcolor="#FFFFFF"><form action="add_money.php?action=save" method="post">
<table width="100%" cellspacing="0" cellpadding="0" border="0" id="table_border">
<tr>
<td id="row_style"> 科目:</td>
<td>
<select name="atype"><option value="收入">收入</option><option value="支出">支出</option></select>
</td>
</tr>
<tr>
<td id="row_style"> 银行:</td>
<td>
<?php
$bank = new dedesql(false);
$bank->setquery("select * from #@__bank");
$bank->execute();
$r = $bank->gettotalrow();
if ($r == 0) {
echo "没有银行供选择,请先<a href='bank.php?action=new'>添加</a>";
} else {
echo "<select name='abank'>";
while ($row = $bank->getArray()) {
if ($row['bank_default'] == 1) {
echo "<option selected value='" . $row['id'] . "'>" . $row['bank_name'] . "</option>";
} else {
echo "<option value='" . $row['id'] . "'>" . $row['bank_name'] . "</option>";
}
}
echo "</select>";
}
$bank->close();
?>
