function updatesellplanmainfahuo($dingdanid)
{
$sellplaninfo = returntablefield("sellplanmain", "billid", $dingdanid, "fahuostate,totalmoney,ifpay,huikuanjine,oddment,fahuojine,kaipiaostate,kaipiaojine,user_flag,billtype");
$fahuojine = $sellplaninfo['fahuojine'];
$fahuostate = $sellplaninfo['fahuostate'];
$totalmoney = $sellplaninfo['totalmoney'];
$sql = "select sum(jine) as tuihuojine from sellplanmain_detail where num<0 and mainrowid={$dingdanid}";
$rs = $this->db->Execute($sql);
$rs_a = $rs->GetArray();
if ($rs_a[0]['tuihuojine'] < 0) {
$totalmoney = $totalmoney - $rs_a[0]['tuihuojine'];
}
if ($fahuostate > -1) {
if ($totalmoney == $fahuojine) {
$fahuostate = 4;
} else {
$billid = returntablefield("stockoutmain", "dingdanbillid", $dingdanid, "billid", "state", "未出库");
if ($billid != '') {
$fahuostate = 1;
} else {
$billid = returntablefield("fahuodan", "dingdanbillid", $dingdanid, "billid", "state", "未发货");
if ($billid != '') {
$fahuostate = 2;
} else {
if ($fahuojine != 0) {
$fahuostate = 3;
} else {
$fahuostate = 0;
}
}
}
}
}
$sql = "update sellplanmain set fahuostate={$fahuostate} where billid={$dingdanid}";
$this->db->Execute($sql);
$CaiWu = new CaiWu($this->db);
$CaiWu->updatesellplanmainFlag($dingdanid);
}
