//遍历此单产品 $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(); ?>