コード例 #1
0
function update_erpcusfk($cusid, $fkmoney, $year, $month)
{
    //取得最新订单所属的配送中心
    $db = new DB_test();
    $query = "select fd_order_sdcrid,fd_organmem_cusname from tb_order \n\t            left join tb_organmem on fd_organmem_id = fd_order_memeberid\n\t            where fd_organmem_cusid = '{$cusid}' order by fd_order_date desc";
    $db->query($query);
    if ($db->nf()) {
        $db->next_record();
        $sdcrid = $db->f(fd_order_sdcrid);
        $cusname = $db->f(fd_organmem_cusname);
        if ($sdcrid == 1) {
            $mscompanyid = 1;
            //广州市明盛物流有限公司
        } else {
            if ($sdcrid == 2) {
                $mscompanyid = 4;
                //上海粤琳珠物流有限公司
            } else {
                if ($sdcrid == 3) {
                    $mscompanyid = 13;
                    //廊坊市明盛纸业有限公司
                } else {
                    if ($sdcrid == 4) {
                        $mscompanyid = 9;
                    } else {
                        if ($sdcrid == 5) {
                            $mscompanyid = 11;
                        }
                    }
                }
            }
        }
        $db_erp = new DB_erp();
        //自动生成单据单据编号
        $listno = listnumber_update();
        $query = "insert into tb_wzfkfy  (\n                fd_wzfkfy_no         , fd_wzfkfy_cusid            , fd_wzfkfy_money       ,\n                fd_wzfkfy_date       , fd_wzfkfy_year             , fd_wzfkfy_month       ,\n                fd_wzfkfy_sdcrid     , fd_wzfkfy_organid   \n                )values( \n                '{$listno}'            , '{$cusid}'                   , '{$fkmoney}'            ,\n                now()                , '{$year}'                    , '{$month}'              ,\n                '{$sdcrid}'            , '1'                 \n                )";
        $db_erp->query($query);
        $listid = $db_erp->insert_id();
        //更新应收款
        if ($fkmoney != 0) {
            changemoney(1, $cusid, $fkmoney, 1, 1, $sdcrid, $mscompanyid, 1);
            //第四位0代表正,1代表负数
            //生成总部往来对帐单
            $ctatmemo = "应付" . $cusname . "客户" . $fkmoney . "元";
            $cactlisttype = "115";
            $addmoney = 0;
            $lessenmoney = $fkmoney;
            $date = date("Y-m-d", mktime("0", "0", "0", date("m", mktime()), date("d", mktime()), date("Y", mktime())));
            zbcurrentaccount(1, $cusid, $addmoney, $lessenmoney, $ctatmemo, $cactlisttype, '网站自动生成', $listid, $listno, $date, $sdcrid, $mscompanyid);
            //------------------插入网站返款费用科目--------------------------
            $listtype = "115";
            //单据类型
            $flstno = "4030313-a001";
            updatesubject($listtype, $listid, $flstno, $fkmoney, 0, 1);
            //0代表正,1代表负数
        }
    }
}
コード例 #2
0
function sc_sjstockorder($orderid)
{
    $dbshop = new DB_shop();
    $db = new DB_test();
    $dberp = new DB_erp();
    $query = "select * from web_order where fd_order_id = '{$orderid}'";
    $dbshop->query($query);
    if ($dbshop->nf()) {
        $dbshop->next_record();
        $memeberid = $dbshop->f(fd_order_memeberid);
        $ishaveinvoice = $dbshop->f(fd_order_isfp);
        $wlyf = $dbshop->f(fd_order_wlfy);
        $wlzftype = $dbshop->f(fd_order_wlzftype);
        $shopid = $dbshop->f(fd_order_shopid);
        $sjallmoney = $dbshop->f(fd_order_sjallmoney);
        $allmoney = $dbshop->f(fd_order_allmoney);
        $mscompanyid = $dbshop->f(fd_order_mscid);
        $srmoney = $allmoney - $sjallmoney;
    }
    if ($ishaveinvoice == 0) {
        $ishaveinvoice = 1;
    } else {
        $ishaveinvoice = 0;
    }
    if (empty($mscompanyid)) {
        $mscompanyid = 2;
    }
    //查找对应供应商
    $query = "select * from tb_mscompany where fd_msc_id = '{$mscompanyid}'";
    $dberp->query($query);
    if ($dberp->nf()) {
        $dberp->next_record();
        $msc_sdcrid = $dberp->f(fd_msc_sdcrid);
    }
    $query = "select * from tb_organmem where fd_organmem_id  = '{$memeberid}' and fd_organmem_isms = 1";
    $db->query($query);
    if ($db->nf()) {
        $db->next_record();
        $cusid = $db->f(fd_organmem_cusid);
        $query = "select * from tb_customer  where fd_cus_id = '{$cusid}'";
        $dberp->query($query);
        if ($dberp->nf()) {
            $dberp->next_record();
            $sdcrid = $dberp->f(fd_cus_wgsdcrid);
            $owlid = $dberp->f(fd_cus_id);
            $owlname = $dberp->f(fd_cus_allname);
            $owlno = $dberp->f(fd_cus_no);
            $wgmscid = $dberp->f(fd_cus_wgmscid);
            $otype = 1;
        }
        //查找对应供应商
        $query = "select * from tb_mscompany where fd_msc_id = '{$mscompanyid}'";
        $dberp->query($query);
        if ($dberp->nf()) {
            $dberp->next_record();
            $msc_sdcrid = $dberp->f(fd_msc_sdcrid);
        }
        //查找对应供应商
        $query = "select * from tb_supplier  where fd_supp_mscid = '{$mscompanyid}'";
        $dberp->query($query);
        if ($dberp->nf()) {
            $dberp->next_record();
            $suppid = $dberp->f(fd_supp_id);
            $suppno = $dberp->f(fd_supp_no);
            $suppname = $dberp->f(fd_supp_allname);
        }
        //插入采购订单主表
        $stockorderno = listnumber_update(65);
        $memo_z = "网购采购(商家)";
        $syear = date("Y", mktime());
        $smonth = date("n", mktime());
        $query = "insert into tb_stockorder(\n\t              fd_skor_listno      ,   fd_skor_suppid     , fd_skor_suppno        ,\n\t              fd_skor_suppname    ,   fd_skor_organid    , fd_skor_lddate        , \n\t              fd_skor_memo        ,   fd_skor_cgmscid    , fd_skor_sdcrid        ,\n\t              fd_skor_fkqx        ,   fd_skor_year       , fd_skor_month         ,\n\t              fd_skor_yjfhdate    ,   fd_skor_yjshdate   , fd_skor_stocktype     ,\n\t              fd_skor_paymodel    ,   fd_skor_gdr        , fd_skor_ishaveinvoice ,\n\t              fd_skor_ldr         ,   fd_skor_suplinkid  , fd_skor_suplinkname   ,\n\t              fd_skor_cgfanli     ,   fd_skor_wftpzx     , fd_skor_transporttype ,\n\t              fd_skor_state      \n\t              )values(\n\t              '{$stockorderno}'     ,   '{$suppid}'          , '{$suppno}'             ,\n\t              '{$suppname}'         ,   '1'                , now()                 ,\n\t              '{$memo_z}'           ,   '{$wgmscid}'         , '{$sdcrid}'             ,\n\t              '0'                 ,   '{$syear}'           , '{$smonth}'             ,\n\t              now()               ,   now()              , '1'                   ,\n\t              '0'                 ,   ''                 , '{$ishaveinvoice}'      ,\n\t              '{$loginstaname}'     ,   ''                 , ''                    ,\n\t              ''                  ,   ''                 , ''                    ,\n\t              '6'\n\t              )";
        $dberp->query($query);
        //插入单据资料
        $stockorderid = $dberp->insert_id();
        //插入明细表
        $query = "select * from web_orderdetail   \n                where fd_orderdetail_orderid  = '{$orderid}'";
        $dbshop->query($query);
        if ($dbshop->nf()) {
            while ($dbshop->next_record()) {
                $commid = $dbshop->f(fd_orderdetail_productid);
                $commbar = $dbshop->f(fd_orderdetail_barcode);
                $commname = $dbshop->f(fd_orderdetail_productname);
                $unitname = $dbshop->f(fd_orderdetail_unit);
                $price = $dbshop->f(fd_orderdetail_price);
                $quantity = $dbshop->f(fd_orderdetail_quantity);
                unset($comm_str);
                $comm_str = explode("@@@", readproduct($commid));
                $tmpralation = $comm_str[5];
                //对应关系3
                $dunquantity = changekg3($tmpralation, $unitname, $quantity);
                //吨数量
                if ($unitname == "令") {
                    $unit = 20;
                } else {
                    $unit = 21;
                }
                $alldunquantity += $dunquantity;
                //$allmoney += $price*$quantity;
                $query = "insert into tb_stockorderdetail(\n\t                    fd_skdrdetail_skorid    ,  fd_skdrdetail_commid       ,  fd_skdrdetail_isorgan       ,\n\t                    fd_skdrdetail_commname  ,  fd_skdrdetail_commbar      ,  fd_skdrdetail_unit          ,\n\t                    fd_skdrdetail_quantity  ,  fd_skdrdetail_price        ,  fd_skdrdetail_memo          ,\n\t                    fd_skdrdetail_organid   ,  fd_skdrdetail_dyj          \n\t                    )values(\n\t                    '{$stockorderid}'         ,  '{$commid}'                  ,  '0'                         ,\n\t                    '{$commname}'             ,  '{$commbar}'                 ,  '{$unit}'                     ,\n\t                    '{$quantity}'             ,  '{$price}'                   ,  '{$memo}'                     ,\n\t                    '{$sdcrid}'               ,  '{$dyj}'                    \n\t                    )";
                $dberp->query($query);
            }
        }
        if ($wlzftype == 2) {
            $dyj = $wlyf / $alldunquantity;
            //$allmoney = $allmoney+$wlyf;
            $query = "update tb_stockorderdetail set fd_skdrdetail_dyj = '{$dyj}' where fd_skdrdetail_skorid = '{$stockorderid}'";
            $dberp->query($query);
        }
        $query = "update tb_stockorder set fd_skor_allmoney = '{$allmoney}',fd_skor_alldunquantity = '{$alldunquantity}'\n                where fd_skor_id = '{$stockorderid}'\n               ";
        $dberp->query($query);
    } else {
        $query = "select * from tb_organmem where fd_organmem_id  = '{$memeberid}'";
        $db->query($query);
        if ($db->nf()) {
            $db->next_record();
            $cusid = $db->f(fd_organmem_cusid);
            $query = "select * from tb_mscompany where fd_msc_id = '{$mscompanyid}'";
            $dberp->query($query);
            if ($dberp->nf()) {
                $dberp->next_record();
                $sdcrid = $dberp->f(fd_msc_sdcrid);
            }
            $query = "select * from tb_customer where fd_cus_id = '{$cusid}'";
            $dberp->query($query);
            if ($dberp->nf()) {
                $dberp->next_record();
                //$sdcrid  = 1;
                $owlid = $dberp->f(fd_cus_id);
                $owlname = $dberp->f(fd_cus_allname);
                $owlno = $dberp->f(fd_cus_no);
                $otype = 1;
            }
        }
    }
    //生成应收应付转移
    //搜索对应供应商
    $query = "select * from tb_supplier where fd_supp_shopid = '{$shopid}'";
    $dberp->query($query);
    if ($dberp->nf()) {
        $dberp->next_record();
        $iwlid = $dberp->f(fd_supp_id);
        $iwlno = $dberp->f(fd_supp_no);
        $iwlname = $dberp->f(fd_supp_allname);
        $itype = 2;
        $ysyfzyno = listnumber_update(101);
        $memo_z = "网站客户应收款转移到商家应收款";
        $money = -$sjallmoney;
        $query = "insert into tb_ysyfwlzy(\n                fd_ysyfwlzy_listno    ,  fd_ysyfwlzy_owlid   , fd_ysyfwlzy_otype   ,\n                fd_ysyfwlzy_owlname   ,  fd_ysyfwlzy_owlno   , fd_ysyfwlzy_iwlid   , \n                fd_ysyfwlzy_iwlno     ,  fd_ysyfwlzy_iwlname , fd_ysyfwlzy_itype   , \n                fd_ysyfwlzy_listdate  ,  fd_ysyfwlzy_memo    , fd_ysyfwlzy_organid ,      \n                fd_ysyfwlzy_sdcrid    ,  fd_ysyfwlzy_mscid   , fd_ysyfwlzy_sqman   ,\n                fd_ysyfwlzy_money\n                )values(\n                '{$ysyfzyno}'           , '{$owlid}'             , '{$otype}'            ,\n                '{$owlname}'            , '{$owlno}'             , '{$iwlid}'            ,\n                '{$iwlno}'              , '{$iwlname}'           , '{$itype}'            ,\n                now()                 , '{$memo_z}'            , '1'                 ,\n                '{$msc_sdcrid}'         , '{$mscompanyid}'       , '{$loginstaname}'     ,\n                '{$money}'\n                )";
        $dberp->query($query);
        $listid = $dberp->insert_id();
        $query = "update tb_ysyfwlzy set fd_ysyfwlzy_state = '3' ,fd_ysyfwlzy_gzdate = now() where fd_ysyfwlzy_id = '{$listid}'";
        $dberp->query($query);
        //修改
        $query = "select * from tb_ysyfwlzy where fd_ysyfwlzy_id = '{$listid}' ";
        $dberp->query($query);
        if ($dberp->nf()) {
            $dberp->next_record();
            $listno = $dberp->f(fd_ysyfwlzy_listno);
            $owlid = $dberp->f(fd_ysyfwlzy_owlid);
            $owlno = $dberp->f(fd_ysyfwlzy_owlno);
            $owlname = $dberp->f(fd_ysyfwlzy_owlname);
            $otype = $dberp->f(fd_ysyfwlzy_otype);
            $iwlid = $dberp->f(fd_ysyfwlzy_iwlid);
            $iwlno = $dberp->f(fd_ysyfwlzy_iwlno);
            $iwlname = $dberp->f(fd_ysyfwlzy_iwlname);
            $itype = $dberp->f(fd_ysyfwlzy_itype);
            $listdate = $dberp->f(fd_ysyfwlzy_listdate);
            $money = $dberp->f(fd_ysyfwlzy_money);
            $sdcrid = $dberp->f(fd_ysyfwlzy_sdcrid);
            //配送中心id号
            $mscompanyid = $dberp->f(fd_ysyfwlzy_mscid);
            $addmoney = -$money;
            $lessenmoney = 0;
            //生成客户往来对帐单
            $ctatmemo = "应收应付款往来转移应付减少" . -$money . "元";
            $cactlisttype = "101";
            zbcurrentaccount($otype, $owlid, $addmoney, $lessenmoney, $ctatmemo, $cactlisttype, $loginstaname, $listid, $listno, $listdate, $sdcrid, $mscompanyid);
            changemoney($otype, $owlid, $money, 1, 1, $sdcrid, $mscompanyid, 1);
            //修改应付应付款函数,0代表正,1代表负数
            //--------------------转到往来单位--------------------------------
            $addmoney = 0;
            $lessenmoney = -$money;
            //生成客户往来对帐单
            $ctatmemo = "应收应付款往来转移应付增加" . -$money . "元";
            $cactlisttype = "101";
            zbcurrentaccount($itype, $iwlid, $addmoney, $lessenmoney, $ctatmemo, $cactlisttype, $loginstaname, $listid, $listno, $listdate, $sdcrid, $mscompanyid);
            changemoney($itype, $iwlid, $money, 0, 1, $sdcrid, $mscompanyid, 1);
            //修改应付应付款函数,0代表正,1代表负数
        }
    }
    //生成收入
    $memo_z = "网站会员向商家采购抵扣运费,提成,返利收入";
    $fkdno = listnumber_update(9);
    $query = "insert into tb_paymoneylist(\n              fd_pymylt_no          ,  fd_pymylt_clientid    , fd_pymylt_type         ,\n              fd_pymylt_clientname  ,  fd_pymylt_staid       , fd_pymylt_money        ,  \n              fd_pymylt_date        ,  fd_pymylt_memo        , fd_pymylt_organid      , \n              fd_pymylt_clientno    ,  fd_pymylt_sdcrid      , fd_pymylt_mscompanyid  ,\n              fd_pymylt_state       ,  fd_pymylt_paymscid\n              )values(\n              '{$fkdno}'              ,  '{$owlid}'              , '1'                    ,\n              '{$owlname}'            ,  '{$loginstaid}'         , '{$srmoney}'             ,\n              now()                 ,  '{$memo_z}'             , '1'                    ,  \n              '{$cusno}'              ,  '1'                   , '2'                    ,\n              '1'                   ,  '{$mscompanyid}'\n              )";
    $dberp->query($query);
    //插入付款单
    $fkdid = $dberp->insert_id();
    //生成客户往来对帐单
    $addmoney = $srmoney;
    $lessenmoney = 0;
    $ctatmemo = "抵扣运费,提成,返利收入,应付减少" . $srmoney . "元";
    $cactlisttype = "9";
    zbcurrentaccount(1, $owlid, $addmoney, $lessenmoney, $ctatmemo, $cactlisttype, $loginstaname, $fkdid, $fkdno, $listdate, 1, 2);
    changemoney($otype, $owlid, $srmoney, 0, 1, 1, 2, 1);
    //修改应付应付款函数,0代表正,1代表负数
    //其他收入
    $query = "select * from tb_othercompany where fd_orcy_izwz = 1";
    if ($dberp->nf()) {
        $dberp->next_record();
        $companyid = $dberp->f(fd_orcy_id);
        $company = $dberp->f(fd_orcy_allname);
    }
    $srdno = listnumber_update(13);
    $memo_z = "网站会员向商家采购运费,提成,返利收入";
    $query = "insert into tb_incomelist(\n\t            fd_incomelist_no          ,   fd_incomelist_date         ,   fd_incomelist_company      ,\n\t            fd_incomelist_staid       ,   fd_incomelist_memo         ,   fd_incomelist_organid      , \n\t            fd_incomelist_mscompanyid ,   fd_incomelist_sdcrid       ,   fd_incomelist_companyid    ,\n\t            fd_incomelist_state       ,   fd_incomelist_allmoney     ,   fd_incomelist_datetime\n\t            )values(\n\t            '{$srdno}'                  ,   now()                      ,  '{$company}'                  ,\n\t            '{$loginstaid}'             ,   '{$memo_z}'                  ,   '1'                        , \n\t            '2'                       ,   '1'                        ,   '{$companyid}'               ,\n\t            '2'                       ,   '{$srmoney}'                 ,   now() \n\t            )";
    $dberp->query($query);
    //插入单据资料
    $listid = $dberp->insert_id();
    //取出刚插入的记录的主关键值的id
    $query = "insert into tb_incomelistdetail(\n\t       \t       fd_ieltdl_incomelistid  ,  fd_ieltdl_ptteid  ,  fd_ieltdl_cost  , \n\t       \t       fd_ieltdl_memo\n\t       \t       )values(\n\t       \t       '{$listid}'               ,  '30'              ,  '{$srmoney}'         ,\n\t       \t       '{$memo}' \n\t       \t       )";
    $dberp->query($query);
    $listtype = "13";
    //单据类型
    $oppositecode = "30301-a001";
    updatesubject($listtype, $listid, $oppositecode, $cost, 0, 1);
    //0代表正,1代表负数
}
コード例 #3
0
ファイル: wgsalegz.php プロジェクト: Xiaoyuyexi/client-server
function wgsalegz($listid)
{
    $db = new DB_erp();
    $db1 = new DB_erp();
    $dberp = new DB_test();
    $organtype = 1;
    $organno = "a001";
    $query = "select * from tb_salelist_2010 \n          where fd_selt_id = '{$listid}' and fd_selt_state = '92'\n         ";
    $db->query($query);
    if ($db->nf()) {
        $query = "select fd_selt_historymemo,fd_selt_ldr,fd_selt_weborderid from tb_salelist_2010 where fd_selt_id = '{$listid}'";
        $db->query($query);
        if ($db->nf()) {
            $db->next_record();
            $historymemo = $db->f(fd_selt_historymemo);
            $ldrname = $db->f(fd_selt_ldr);
            $weborderid = $db->f(fd_selt_weborderid);
        }
        $liststate = 1;
        $query = "update tb_salelist_2010 set fd_selt_memo  = ''     , fd_selt_state   = '{$liststate}' ,  \n                   fd_selt_cwspdate  = now() \n            where fd_selt_id = '{$listid}' ";
        $db->query($query);
        //修改单据资料
        //更新订单状态
        $query = "update web_order set fd_order_state = '7',fd_order_gzdate = now()  where fd_order_id = '{$weborderid}'";
        $dberp->query($query);
        $query = "select * from web_order where fd_order_id = '{$weborderid}'";
        $dberp->query($query);
        if ($dberp->nf()) {
            $dberp->next_record();
            $memeberid = $dberp->f(fd_order_memeberid);
            $gdr = $dberp->f(fd_order_ddclr);
            //激活会员卡
            $query = "update tb_organmem set fd_organmem_active = '1'  where fd_organmem_id = '{$memeberid}'";
            $dberp->query($query);
            $query = "update web_salercard  set fd_salercard_opendate = now()  where fd_salercard_memberid  = '{$memeberid}' and fd_salercard_opendate = '0000-00-00'";
            $dberp->query($query);
        }
        $query = "select * from tb_salelist_2010 where fd_selt_id = '{$listid}'";
        $db->query($query);
        if ($db->nf()) {
            $db->next_record();
            $listid_2010 = $db->f(fd_selt_id);
            $listno = $db->f(fd_selt_no);
            //单据编号
            $cusid = $db->f(fd_selt_cusid);
            //客户id号
            $cusno = $db->f(fd_selt_cusno);
            //客户编号
            $cusname = $db->f(fd_selt_cusname);
            //客户名称
            $sendcenterid = $db->f(fd_selt_sdcrid);
            //配送中心id号
            $mscompanyid = $db->f(fd_selt_mscompanyid);
            //所属公司id号
            $memo = $db->f(fd_selt_memo);
            $iswebsale = $db->f(fd_selt_iswebsale);
            $ishavetax = $db->f(fd_selt_ishavetax);
            $ishavetax = $db->f(fd_selt_ishavetax);
            $skfs = $db->f(fd_selt_skfs);
            $jhcldate = $db->f(fd_selt_jhcldate);
            $cwspdate = $db->f(fd_selt_cwspdate);
            $ckchdate = $db->f(fd_selt_ckchdate);
            $ckqrdate = $db->f(fd_selt_ckqrdate);
            $zjlspdate = $db->f(fd_selt_zjlspdate);
            $ldr = $db->f(fd_selt_ldr);
            $historymemo = $db->f(fd_selt_historymemo);
            $shplace = $db->f(fd_selt_shplace);
            $consignee = $db->f(fd_selt_consignee);
            $webpaymoney = $db->f(fd_selt_webpaymoney);
            $weborderid = $db->f(fd_selt_weborderid);
            $weborderno = $db->f(fd_selt_weborderno);
            $date = $db->f(fd_selt_date);
            $trafficmodel = $db->f(fd_selt_trafficmodel);
            $cardid = $db->f(fd_selt_cardid);
            $wlyf = $db->f(fd_selt_wlyf);
            //物流运费
            $wlzftype = $db->f(fd_selt_wlzftype);
            //物流运费支付类型
            $ysgsid = $db->f(fd_selt_ysgsid);
        }
        $query = "select fd_selt_id from tb_salelist where fd_selt_salelistid = '{$listid}' and fd_selt_no = '{$listno}'";
        $db->query($query);
        if ($db->nf()) {
            $db->next_record();
            $listid = $db->f(fd_selt_id);
        } else {
            $query = "insert into tb_salelist (\n              fd_selt_no           , fd_selt_cusid              , fd_selt_cusno       ,\n              fd_selt_cusname      , fd_selt_accountid          , \n              fd_selt_sdcrid       , fd_selt_mscompanyid        , fd_selt_date        ,\n              fd_selt_organid      , fd_selt_datetime           , fd_selt_memo        , \n              fd_selt_iswebsale    , fd_selt_ishavetax          , fd_selt_trafficmodel, \n              fd_selt_skfs         , fd_selt_jhcldate           , fd_selt_zjlspdate   , \n              fd_selt_cwspdate     , fd_selt_ckchdate           , fd_selt_ckqrdate    ,\n              fd_selt_ldr          , fd_selt_historymemo        , fd_selt_state       ,\n              fd_selt_consignee    , fd_selt_shplace            , fd_selt_webpaymoney ,\n              fd_selt_weborderid   , fd_selt_weborderno         , fd_selt_salelistid  ,\n              fd_selt_cardid       , fd_selt_wlyf               , fd_selt_wlzftype    ,\n              fd_selt_ysgsid \n              )values( \n              '{$listno}'            , '{$cusid}'                   , '{$cusno}'            ,\n              '{$cusname}'           , '{$accountid}'               ,\n              '{$sendcenterid}'      , '{$mscompanyid}'             , '{$date}'             ,\n              '1'                  , now()                      , '{$memo}'             , \n              '{$iswebsale}'         , '{$ishavetax}'               , '{$trafficmodel}'     , \n              '{$skfs}'              ,'{$jhcldate}'                 , '{$zjlspdate}'        , \n              '{$cwspdate}'          , '{$ckchdate}'                , '{$ckqrdate}'         ,\n              '{$ldr}'               , '{$historymemo}'             , '1'                 ,    \n              '{$consignee}'         , '{$shplace}'                 , '{$webpaymoney}'      ,                     \n              '{$weborderid}'        , '{$weborderno}'              , '{$listid}'           ,\n              '{$cardid}'            , '{$wlyf}'                    , '{$wlzftype}'         ,\n              '{$ysgsid}'\n              )";
            $db->query($query);
            $listid = $db->insert_id();
            //取出刚插入的记录的主关键值的id
            //------------------------------插入采购单--------------------------------
            $cg_listid = 0;
            $query = "select fd_cus_linkorganid from tb_customer where fd_cus_id = '{$cusid}' ";
            $db1->query($query);
            if ($db1->nf()) {
                $db1->next_record();
                $linkorganid = $db1->f(fd_cus_linkorganid);
                $msc_name = "";
                $query = "select fd_msc_name from tb_mscompany where fd_msc_id = '{$mscompanyid}' ";
                $db1->query($query);
                if ($db1->nf()) {
                    $db1->next_record();
                    $msc_name = $db1->f(fd_msc_name);
                }
                $suppid = "";
                $suppno = "";
                $suppname = "";
                $query = "select fd_supp_id , fd_supp_no  from tb_supplier \n    \t          where fd_supp_allname = '{$msc_name}' and fd_supp_organid = '{$linkorganid}' ";
                $db1->query($query);
                if ($db1->nf()) {
                    $db1->next_record();
                    $suppid = $db1->f(fd_supp_id);
                    $suppno = $db1->f(fd_supp_no);
                    $suppname = $msc_name;
                } else {
                    $suppno = changepinyin($msc_name) . "-" . $linkorganid;
                    $suppname = $msc_name;
                    $query = "insert into tb_supplier(\n    \t            fd_supp_no , fd_supp_allname  , fd_supp_organid\n    \t            )values(\n    \t            '{$suppno}'  , '{$suppname}'      , '{$linkorganid}'\n    \t            )";
                    $db1->query($query);
                    $suppid = $db1->insert_id();
                    //取出刚插入的记录的主关键值的id
                }
                $cg_memo_z = "网购销售单自动生成到分行的进货单";
                $cg_listno = listnumber_update(1);
                //保存单据
                $query = "insert into tb_stock(\n                fd_stock_no          ,   fd_stock_suppid        , fd_stock_suppno           ,\n                fd_stock_suppname    ,   fd_stock_organid       , fd_stock_date             , \n                fd_stock_memo        ,   fd_stock_staid         , fd_stock_sdcrid           ,\n                fd_stock_dealwithman ,   fd_stock_dyj           , fd_stock_paymentdate      \n                {$fieldsql}\n                )values(\n                '{$cg_listno}'        ,   '{$suppid}'          , '{$suppno}'             ,\n                '{$suppname}'         ,   '{$linkorganid}'     , now()                 ,\n                '{$cg_memo_z}'        ,   '0'                , '0'                   ,\n                ''                  ,   '0'                , now()                 \n                )";
                $db->query($query);
                //插入单据资料
                $cg_listid = $db->insert_id();
                //取出刚插入的记录的主关键值的id
            }
        }
        //更新客户的往来单据时间
        $query = "update tb_customer set fd_cus_newdatetime = now(),fd_cus_newlistid = '{$listid}',\n            fd_cus_newlisttype = '1'\n            where fd_cus_id = '{$cusid}'";
        $db->query($query);
        //插入销售细节表的商品数据
        $query = "select * from tb_salelistdetail_2010 where fd_stdetail_seltid = '{$listid_2010}' ";
        $db->query($query);
        if ($db->nf()) {
            while ($db->next_record()) {
                $v_stdetailid = $db->f(fd_stdetail_id);
                $v_storageid = $db->f(fd_stdetail_storageid);
                $v_commid = $db->f(fd_stdetail_commid);
                $v_commbar = $db->f(fd_stdetail_commbar);
                $v_commname = $db->f(fd_stdetail_commname);
                $v_unit = $db->f(fd_stdetail_unit);
                $v_quantity = $db->f(fd_stdetail_quantity);
                $v_price = $db->f(fd_stdetail_price);
                $v_memo = $db->f(fd_stdetail_memo);
                $query = "select * from tb_salelistdetail where fd_stdetail_stdetailid = '{$v_stdetailid}' and fd_stdetail_seltid = '{$listid}' ";
                $db1->query($query);
                if ($db1->nf()) {
                } else {
                    $query = "insert into tb_salelistdetail (\n  \t\t               fd_stdetail_seltid        , fd_stdetail_storageid , fd_stdetail_commid  , \n  \t\t               fd_stdetail_commbar       , fd_stdetail_commname  , fd_stdetail_unit    ,\n  \t\t               fd_stdetail_quantity      , fd_stdetail_price     , fd_stdetail_memo          \n  \t\t               )values(\n  \t\t               '{$listid}'                 , '{$v_storageid}'        , '{$v_commid}'         ,\n  \t\t               '{$v_commbar}'              , '{$v_commname}'         , '{$v_unit}'           ,\n  \t\t               '{$v_quantity}'             , '{$v_price}'            , '{$v_memo}'             \n  \t\t               )";
                    $db1->query($query);
                    if ($cg_listid > 0) {
                        $query = "insert into tb_stockdetail(\n  \t                     fd_skdetail_stockid  ,  fd_skdetail_commid  ,  fd_skdetail_storageid ,\n  \t                     fd_skdetail_commname ,  fd_skdetail_commbar ,  fd_skdetail_unit      ,\n  \t                     fd_skdetail_quantity ,  fd_skdetail_price   ,  fd_skdetail_memo    \n  \t                     )values(\n  \t                     '{$cg_listid}'         ,  '{$v_commid}'         ,  '0'                   ,\n  \t                     '{$v_commname}'        ,  '{$v_commbar}'        ,  '{$v_unit}'             ,\n  \t                     '{$v_quantity}'        ,  '{$v_price}'          ,  '{$v_memo}'          \n  \t                     )";
                        $db1->query($query);
                        //插入细节表 数据
                    }
                }
            }
        }
        $allmoney = 0;
        $alldunquantity = 0;
        $alldunmoney = 0;
        $allstoragecost = 0;
        $query = "select * from tb_salelistdetail \n            left join tb_produre on fd_produre_id = fd_stdetail_commid\n            where fd_stdetail_seltid = '{$listid}'";
        $db->query($query);
        if ($db->nf()) {
            while ($db->next_record()) {
                $commid = $db->f(fd_stdetail_commid);
                $quantity = $db->f(fd_stdetail_quantity);
                $tmpsbdetailid = $db->f(fd_stdetail_id);
                $price = $db->f(fd_stdetail_price);
                //单价
                $tmpunit = $db->f(fd_stdetail_unit);
                $tmpcost = $db->f(fd_stdetail_tmpcost);
                $tmpralation = $db->f(fd_produre_relation3);
                //对应关系3
                $storageid = $db->f(fd_stdetail_storageid);
                //仓库ID
                $dunquantity = changekg($tmpralation, $tmpunit, $quantity);
                //吨数量
                $alldunquantity += $dunquantity;
                if (empty($sendcenterid)) {
                    $sendcenterid = 0;
                    //配送中心id
                }
                //查找库存是否有数量
                $flagquantity = 0;
                $query = "select * from tb_stockquantity where fd_skqy_organid = '1' \n                   and fd_skqy_commid = '{$commid}' and fd_skqy_sdcrid = '{$sendcenterid}'";
                $db1->query($query);
                if ($db1->nf()) {
                    while ($db1->next_record()) {
                        if ($db1->f(fd_skqy_quantity) != 0) {
                            $flagquantity = 1;
                        }
                    }
                }
                //查找是否有库存成本价
                $query = "select * from tb_storagecost where fd_sect_organid = '1'\n  \t\t             and fd_sect_commid = '{$commid}' and fd_sect_sdcrid = '{$sendcenterid}'";
                $db1->query($query);
                if ($db1->nf()) {
                    $db1->next_record();
                    $storagecost = $db1->f(fd_sect_cost);
                    if ($storagecost == 0 and $flagquantity == 0) {
                        //如果库存单价为0时,就修改库存单价
                        $query = "update tb_storagecost set fd_sect_cost = '{$tmpcost}'\n                       where fd_sect_organid = '1'  and fd_sect_sdcrid = '{$sendcenterid}'\n                       and fd_sect_commid = '{$commid}'";
                        $db1->query($query);
                    }
                } else {
                    //如果没有库存成本记录
                    $storagecost = 0;
                    if ($flagquantity == 0) {
                        $query = "insert into tb_storagecost(\n                       fd_sect_cost    ,  fd_sect_commid , fd_sect_organid ,\n                       fd_sect_sdcrid  \n                       )values(\n                       '{$tmpcost}'      ,  '{$commid}'      , '1'  ,\n                       '{$sendcenterid}'\n                       )";
                        $db1->query($query);
                    }
                }
                if ($storagecost == 0 and $flagquantity == 0) {
                    $storagecost = $tmpcost;
                }
                //修改仓库的数量和成本价
                updatestorage($commid, $quantity, $storagecost, $storageid, 1, $sendcenterid, 1);
                //0代表正、1代表负
                $query = "update tb_salelistdetail set fd_stdetail_cost = '{$storagecost}'\n                   where fd_stdetail_id = '{$tmpsbdetailid}'  ";
                $db1->query($query);
                //修改商品的库存成本价
                $allstoragecost += $storagecost * $quantity;
                //销售成本价
                //商品流水帐
                $cogememo = "商品销售减少";
                $cogelisttype = "3";
                $cogetype = 1;
                //0为增加 , 1为减少
                commglide($storageid, $commid, $quantity, $cogememo, $cogelisttype, $gdr, $listid, $listno, $cogetype, $date);
                $allmoney += $quantity * $price;
                //销售总额
                /*
                  		   //记录该商品卖给该客户的最近销售价
                  		   $query = "select * from tb_savesalepirce where fd_ssp_cusid = '$cusid' and fd_ssp_commid = '$commid'";
                  		   $db1->query($query);
                  		   if($db1->nf()){
                  		   	$query = "update tb_savesalepirce set fd_ssp_price = '$price' 
                  		   	          where fd_ssp_cusid = '$cusid' and fd_ssp_commid = '$commid'";
                  		   	$db1->query($query);
                  		   }else{
                  		     $query = "insert into tb_savesalepirce(
                  		               fd_ssp_cusid  , fd_ssp_commid  , fd_ssp_price
                  		               )values(
                  		               '$cusid'   ,  '$commid'  , '$price'
                  		               )";
                  		     $db1->query($query);
                }
                */
            }
        }
        /*
        //查询即时的应收应付款
        if($organtype==1){
        	$ysyf_sqlwhere = " and fd_ysyfm_mscompanyid = '$mscompanyid'";
        }else{
          $ysyf_sqlwhere = "";
        }
        
        
        $query = "select * from tb_ysyfmoney where fd_ysyfm_organid = '1'
                  and fd_ysyfm_type = '1' and fd_ysyfm_companyid = '$cusid'
                  $ysyf_sqlwhere ";
        $db->query($query);
        if($db->nf()){
        	$db->next_record();
          $nowysyfmoney = $db->f(fd_ysyfm_money);
        }
        */
        //修改应收金额
        if ($wlzftype == 2) {
            $allmoney = $allmoney + $wlyf;
        }
        $allysmoney = $allmoney;
        //生成总部往来对帐单
        $ctatmemo = "应收" . $cusname . "客户" . $allysmoney . "元";
        $cactlisttype = "3";
        $addmoney = $allmoney;
        $lessenmoney = $paymoney;
        zbcurrentaccount(1, $cusid, $addmoney, $lessenmoney, $ctatmemo, $cactlisttype, $gdr, $listid, $listno, $date, $sendcenterid, $mscompanyid);
        if ($allysmoney != 0) {
            changemoney(1, $cusid, $allysmoney, 0, 1, $sendcenterid, $mscompanyid, $organtype);
            //第四位0代表正,1代表负数
        }
        /*
        //读取客户应收款
        $query = "select * from tb_ysyfmoney 
                   where fd_ysyfm_type =1 and fd_ysyfm_companyid = '$cusid'";
        $db->query($query);
        if($db->nf()){
          while($db->next_record()){
               $yfk += $db->f(fd_ysyfm_money)+0;      
          }  
        }
        	     
        //-------------------------------------------------------
        if($allysmoney>=0){  //判断应收款是否增加或者减少。
        	 if($nowysyfmoney>=0){   //如果往来单位欠我们的款,就直接在应收款科目上增加应收的金额
        	 	  //------------------插入应收款类别科目--------------------------
              $listtype = "3";    //单据类型
              $flstno = "105-".$organno;
              updatesubject($listtype , $listid , $flstno,$allysmoney,0 , 1);  //0代表正,1代表负数 	
        	 }else{ //如果欠往来单位的
        	    $tmpnowysyfmoney = -$nowysyfmoney;
              $discrepantmoeny = $allysmoney - $tmpnowysyfmoney;
              if($discrepantmoeny>0){  //如果应收金额比现在的应付款还大,那就应收款科目增加超出部分金额
              	 $listtype = "3";    //单据类型
                 $flstno = "105-".$organno;
              	 updatesubject($listtype , $listid , $flstno , $discrepantmoeny,0 , 1);  //0代表正,1代表负数
              	  
              	 $listtype = "3";    //单据类型
                 $flstno = "201-".$organno;
                 updatesubject($listtype , $listid , $flstno , $tmpnowysyfmoney,1 , 1);  //0代表正,1代表负数
              }else{  //如果应付款比单据的金额还大,那应付款科目直接减少。
                $listtype = "3";    //单据类型
                $flstno = "201-".$organno;
                updatesubject($listtype , $listid , $flstno , $allysmoney,1 , 1);  //0代表正,1代表负数
             }
        	 }
        }else{
           //多出来的款项目,做成应收款。
           $i_yfmoney = $paymoney - $allmoney ;
           $discrepantmoeny = $i_yfmoney - $nowysyfmoney;
           if($discrepantmoeny>0){  //如果收款金额比应收款的金额还大,那就把超出部分做应付款。
           	 if($nowysyfmoney>=0){  //如果之前应收该往来单位,那就应收款科目就平掉该往来单位的应收款,剩余的部分做到应付款科目里
           	 	  //------------------插入应付款科目--------------------------
                $listtype = "3";    //单据类型
                $flstno = "201-".$organno;
                updatesubject($listtype , $listid , $flstno , $discrepantmoeny,0 , 1);  //0代表正,1代表负数
                
                //------------------插入应收款科目--------------------------
                $listtype = "3";    //单据类型
                $flstno = "105-".$organno;
           	    updatesubject($listtype , $listid , $flstno , $nowysyfmoney,1 , 1);  //0代表正,1代表负数
           	 }else{  //如果之前是应付该往来单位的,应付款科目就增加收取的金额。
           	    //------------------插入应付款科目--------------------------
                $listtype = "3";    //单据类型
                $flstno = "201-".$organno;
                updatesubject($listtype , $listid , $flstno , $i_yfmoney,0 , 1);  //0代表正,1代表负数
           	 }
           	 
           }else{
              //------------------插入应收款科目--------------------------
             $listtype = "3";    //单据类型
             $flstno = "105-".$organno;
           	 updatesubject($listtype , $listid , $flstno , $i_yfmoney,1 , 1);  //0代表正,1代表负数
           }
        }//--------------------------------------------------
         	  
        	  
        //------------------插入库存商品类别科目--------------------------
        $listtype = "3";    //单据类型
        $flstno = "101-".$organno;
        updatesubject($listtype , $listid , $flstno,$allstoragecost,1 , 1);  //0代表正,1代表负数
        */
        //------------------插入销售收入类别科目--------------------------
        $listtype = "3";
        //单据类型
        $flstno = "301-" . $organno;
        updatesubject($listtype, $listid, $flstno, $allnoyfmoney, 0, 1);
        //0代表正,1代表负数
        //------------------插入销售成本类别科目--------------------------
        $listtype = "3";
        //单据类型
        $flstno = "401-" . $organno;
        updatesubject($listtype, $listid, $flstno, $allstoragecost, 0, 1);
        //0代表正,1代表负数
        $query = "update tb_salelist set fd_selt_allmoney = '{$allmoney}'  , fd_selt_allcost = '{$allstoragecost}'  ,\n            fd_selt_alldunshu = '{$alldunquantity}'   , fd_selt_isch = 1 , fd_selt_chdate = now()                 \n            where fd_selt_id = '{$listid}'";
        $db->query($query);
        //修改单据金额
        $query = "update tb_customer set fd_cus_iswebwl = 1 where fd_cus_id = '{$cusid}'";
        $db->query($query);
        //更新订单状态
        $query = "update web_order set fd_order_alldunshu = '{$alldunquantity}',fd_order_allmoney= '{$allmoney}',  \n            fd_order_allcost = '{$allstoragecost}' ,fd_order_state = '7'\n            where fd_order_id = '{$weborderid}'";
        $dberp->query($query);
        $query = "select fd_order_memeberid from web_order where fd_order_id = '{$weborderid}'";
        $dberp->query($query);
        if ($dberp->nf()) {
            $dberp->next_record();
            $memid = $dberp->f(fd_order_memeberid);
        }
        $query = "select max(fd_order_date) as lastbuy,sum(fd_order_allmoney) as allmoney from web_order where (fd_order_state = 6 or fd_order_state = 7) and fd_order_zf = 0 and fd_order_memeberid = '{$memid}' group by fd_order_memeberid";
        $dberp->query($query);
        if ($dberp->nf()) {
            $dberp->next_record();
            $lastbuy = $dberp->f(lastbuy);
            $allmoney = $dberp->f(allmoney);
            $query = "update tb_organmem set fd_organmem_lastsaletime = '{$lastbuy}' , fd_organmem_allmoney = '{$allmoney}' where fd_organmem_id = '{$memid}'";
            $dberp->query($query);
        }
        //更新抢注会员会员卡
        $query = "select * from tb_organmem where fd_organmem_id = '{$memid}'";
        $dberp->query($query);
        $dberp->next_record();
        $getstate = $dberp->f(fd_organmem_getstate);
        $getsalerid = $dberp->f(fd_organmem_getsalerid);
        if ($getstate == 1 and $getsalerid > 0) {
            //检测是否同一网导
            $query = "select * from tb_organmem\n left join web_salercard on fd_salercard_id = fd_organmem_mcardid\n where fd_organmem_id = '{$memid}' and fd_salercard_salerid = '{$getsalerid}'\n ";
            $dberp->query($query);
            if ($dberp->nf() == 0) {
                //选取会员卡
                $query = "select* from web_salercard where fd_salercard_salerid = '{$getsalerid}' and fd_salercard_state =1 and fd_salercard_memberid =0 and fd_salercard_zf =0 limit 0,1";
                $dberp->query($query);
                if ($dberp->nf()) {
                    $dberp->next_record();
                    $mcardid = $dberp->f(fd_salercard_id);
                    //绑定会员卡
                    $query = "update tb_organmem set fd_organmem_mcardid = '{$mcardid}',fd_organmem_getstate=0,fd_organmem_getsalerid=0,fd_organmem_getmemdate='' where fd_organmem_id = '{$memid}'";
                    $dberp->query($query);
                    $query = "update web_salercard set fd_salercard_memberid = '{$memid}',fd_salercard_opendate = now() where fd_salercard_id = '{$mcardid}'";
                    $dberp->query($query);
                    $query = "update tb_salelist set fd_selt_cardid = '{$mcardid}'      \n            where fd_selt_id = '{$listid}'";
                    $db->query($query);
                    //清除抢注资料
                    $query = "delete from  web_getmemcd where fd_getmemcd_salerid = '{$getsalerid}' and fd_getmemcd_memid = '{$memid}'";
                    $dberp->query($query);
                }
            }
        }
        /*
        if($type == "wy"){
          $gotourl = "http://www.ms56.net/mssale/order_zszfcg.php?orderid=".$weborderid;
        }else{
          $gotourl = "http://www.ms56.net/mssale/admin/order/tb_ordercl.php";
        }  
        echo "<script>location='".$gotourl."'</script>";
        */
        //Header("Location: $gotourl");
    }
}