function updatebuyplanmainfahuo($caigoudanid) { $buyplaninfo = returntablefield("buyplanmain", "billid", $caigoudanid, "state,totalmoney,ifpay,rukumoney,shoupiaostate,user_flag"); $fahuostate = $buyplaninfo['state']; $ifpay = $buyplaninfo['ifpay']; $kaipiaostate = $buyplaninfo['shoupiaostate']; $rukumoney = $buyplaninfo['rukumoney']; $totalmoney = $buyplaninfo['totalmoney']; $user_flag = $buyplaninfo['user_flag']; if ($totalmoney == $rukumoney) { $fahuostate = 5; } else { $billid = returntablefield("stockinmain", "caigoubillid", $caigoudanid, "billid", "state", "未入库", "intype", "采购入库"); $billid1 = returntablefield("stockoutmain", "dingdanbillid", $caigoudanid, "billid", "state", "未出库", "outtype", "返厂出库"); if ($rukumoney != 0 && $billid == '' && $billid1 == '') { $fahuostate = 4; } else { if ($billid != '' || $billid1 != '') { $fahuostate = 3; } else { $id = returntablefield("buyplanmain_detail", "mainrowid", $caigoudanid, "id"); if ($id != '') { $fahuostate = 2; } else { $fahuostate = 1; } //需要 } } } $sql = "update buyplanmain set state={$fahuostate} where billid={$caigoudanid}"; $this->db->Execute($sql); $CaiWu = new CaiWu($this->db); $CaiWu->updatebuyplanmainFlag($caigoudanid); }