Beispiel #1
0
 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);
 }