Пример #1
0
$rs->close();
if ($action == 'save') {
    //保存退货单及记录
    $bsql = new Dedesql(false);
    $query = "select * from #@__sale where rdh='{$r_dh}'";
    //遍历此单产品
    $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);