Ejemplo n.º 1
0
 if ($maxjine > 0 && $shoukuan + $oddment > $maxjine) {
     throw new Exception("本次付款和去零合计不能大于{$maxjine}");
 }
 if ($maxjine < 0 && $shoukuan + $oddment < $maxjine) {
     throw new Exception("本次付款和去零合计不能小于{$maxjine}");
 }
 if ($shoukuan + $oddment == 0) {
     throw new Exception("本次付款+去零合计不能为0");
 }
 //开启事务
 //$db->debug=1;
 $CaiWu = new CaiWu($db);
 $db->StartTrans();
 //插入付款记录
 $accesstype = "货款支付";
 $CaiWu->insertFukuanReocord($_POST['supplyid'], $_POST['caigoubillid'], $shoukuan, $accountid, $_SESSION['LOGIN_USER_ID'], $accesstype, $oddment, $_POST['qici'], $_POST['beizhu'], $_POST['guanlianplanid']);
 //付款计划
 if ($_POST['guanlianplanid'] != '') {
     $sql = "update fukuanplan set ifpay='已付款' where id=" . $_POST['guanlianplanid'];
     $db->Execute($sql);
 }
 $db->CompleteTrans();
 //是否事务出现错误
 page_css("付款记录");
 if ($db->HasFailedTrans()) {
     throw new Exception($db->ErrorMsg());
 } else {
     $return = $_POST['url'];
     $return = $return . "?" . FormPageAction("action", "init_default");
     print_infor("付款记录已生成", 'trip', "location='?{$return}'", "{$return}", 0);
 }
Ejemplo n.º 2
0
    try {
        if ($totalmoney > 0 && $totalmoney < $oddment + $realmoney) {
            throw new Exception("去零加已付金额不能大于总金额 {$totalmoney}");
        }
        if ($totalmoney < 0 && $totalmoney > $oddment + $realmoney) {
            throw new Exception("去零加已付金额不能小于总金额 {$totalmoney}");
        }
        //开启事务
        $db->StartTrans();
        $billid = returnAutoIncrement("billid", "buyplanmain");
        //插入新纪录
        $sql = "insert into buyplanmain (billid,zhuti,supplyid,linkman,caigoudate,daohuodate,createman,createtime,totalmoney,\n\t\toddment,paymoney,accountid,guanliandingdan,guanliankehu,beizhu,user_flag) values({$billid},'" . $_POST['zhuti'] . "','{$supplyid}',\n\t\t'{$linkman}','{$caigoudate}','{$daohuodate}','{$createman}','{$createtime}',{$totalmoney},0,0,{$accountid},\n\t\t'" . $_POST['guanliandingdan'] . "','" . $_POST['guanliankehu'] . "','" . $_POST['beizhu'] . "',1)";
        $db->Execute($sql);
        $CaiWu = new CaiWu($db);
        if ($realmoney != 0) {
            $CaiWu->insertFukuanReocord($supplyid, $billid, $realmoney, $accountid, $createman, '货款支付', $oddment, '', '', '');
        }
        //是否事务出现错误
        page_css();
        $db->CompleteTrans();
        if ($db->HasFailedTrans()) {
            throw new Exception($db->ErrorMsg());
        } else {
            $return = FormPageAction("action", "init_default");
            print_infor("采购单已生成,请录入明细", 'trip', "location='?{$return}'", "?{$return}", 0);
        }
    } catch (Exception $e) {
        print "<script language=javascript>alert('错误:" . $e->getMessage() . "');window.history.back(-1);</script>";
    }
    exit;
}