PHP CaiWu示例

示例#1

文件： v_feiyong_sq_newai.php 项目： shesai0519/sunshineCRM

<?php

ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
validateMenuPriv("报销单审核");
if ($_GET['action'] == "shenhedan") {
    $CaiWu = new CaiWu($db);
    $db->StartTrans();
    $billid = $_GET['单号'];
    $feiyonginfo = returntablefield("v_feiyong_sq", "单号", $billid, "金额,费用类型");
    $jine = $feiyonginfo['金额'];
    $fytype = $feiyonginfo['费用类型'];
    $sql = "update crm_feiyong_sq set 是否审核='4',出纳员='" . $_SESSION['LOGIN_USER_ID'] . "',支付时间=now() where 单号='{$billid}'";
    $rs = $db->Execute($sql);
    $CaiWu->insertFeiYongAccount($fytype, $jine, 1, $_SESSION['LOGIN_USER_ID'], -1);
    //是否事务出现错误
    if ($db->HasFailedTrans()) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
    } else {
        page_css("报销单审核");
        $return = $return . "?" . FormPageAction("action", "init_default");
        print_infor("已报销", 'trip', "location='?{$return}'", "{$return}", 0);
    }
    $db->CompleteTrans();
    exit;
}
addShortCutByDate("创建时间", "申请时间");
$filetablename = 'v_feiyong_sq';

示例#2

文件： kaipiaorecord_newai.php 项目： shesai0519/sunshineCRM

        $return = FormPageAction("action", "init_default");
        print_infor("新增开票记录成功", 'trip', "location='?{$return}'", "?{$return}", 0);
    }
    $db->CompleteTrans();
    exit;
} else {
    if ($_GET['action'] == "delete_array") {
        $selectid = $_GET['selectid'];
        $selectid = explode(",", $selectid);
        //开启事务
        global $db;
        //$db->debug=1;
        $db->StartTrans();
        for ($i = 0; $i < sizeof($selectid); $i++) {
            if ($selectid[$i] != "") {
                $CaiWu = new CaiWu($db);
                $CaiWu->deleteKaiPiao($selectid[$i]);
            }
        }
        //是否事务出现错误
        if ($db->HasFailedTrans()) {
            print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
        } else {
            page_css("开票记录");
            $return = FormPageAction("action", "init_default");
            print_infor("开票记录已成功删除", 'trip', "location='?{$return}'", "?{$return}", 0);
        }
        $db->CompleteTrans();
        exit;
    }
}

示例#3

文件： fukuanrecord_newai.php 项目： shesai0519/sunshineCRM

            $return = $_POST['url'];
            $return = $return . "?" . FormPageAction("action", "init_default");
            print_infor("付款记录已生成", 'trip', "location='?{$return}'", "{$return}", 0);
        }
    } catch (Exception $e) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $e->getMessage()) . "');window.history.back(-1);</script>";
    }
    exit;
}
//撤销付款
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    try {
        //开启事务
        $CaiWu = new CaiWu($db);
        //$db->debug=1;
        $db->StartTrans();
        for ($i = 0; $i < sizeof($selectid); $i++) {
            if ($selectid[$i] != "") {
                $fukuaninfo = returntablefield("fukuanrecord", "id", $selectid[$i], "id,supplyid,caigoubillid,jine,oddment,accountid,guanlianplanid");
                $caigoubillid = $fukuaninfo['caigoubillid'];
                $fukuan = $fukuaninfo['jine'];
                $oddment = $fukuaninfo['oddment'];
                $planid = $fukuaninfo['guanlianplanid'];
                //删除回款记录
                $CaiWu->deleteFukuanReocord($selectid[$i]);
                //回款计划
                if ($planid != '') {
                    $sql = "update fukuanplan set ifpay='未付款' where id=" . $planid;
                    $db->Execute($sql);

示例#4

文件： shoupiaorecord_newai.php 项目： shesai0519/sunshineCRM

        }
    } catch (Exception $e) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $e->getMessage()) . "');window.history.back(-1);</script>";
    }
    exit;
} else {
    if ($_GET['action'] == "delete_array") {
        $selectid = $_GET['selectid'];
        $selectid = explode(",", $selectid);
        //开启事务
        global $db;
        //$db->debug=1;
        $db->StartTrans();
        for ($i = 0; $i < sizeof($selectid); $i++) {
            if ($selectid[$i] != "") {
                $CaiWu = new CaiWu($db);
                $CaiWu->deleteShouPiao($selectid[$i]);
            }
        }
        $db->CompleteTrans();
        page_css("开票记录");
        //是否事务出现错误
        if ($db->HasFailedTrans()) {
            print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
        } else {
            $return = FormPageAction("action", "init_default");
            print_infor("开票记录已成功删除", 'trip', "location='?{$return}'", "?{$return}", 0);
        }
        exit;
    }
}

示例#5

文件： bankzhuru_newai.php 项目： shesai0519/sunshineCRM

    //是否事务出现错误
    if ($db->HasFailedTrans()) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
    } else {
        page_css("资金注入抽取");
        $return = FormPageAction("action", "init_default");
        print_infor("新增资金注入抽取单成功", 'trip', "location='?{$return}'", "?{$return}", 0);
    }
    $db->CompleteTrans();
    exit;
}
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    global $db;
    $CaiWu = new CaiWu($db);
    for ($i = 0; $i < sizeof($selectid); $i++) {
        if ($selectid[$i] != "") {
            $CaiWu->deleteBankZhuruAccount($selectid[$i]);
        }
    }
    //是否事务出现错误
    if ($db->HasFailedTrans()) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
    } else {
        page_css("资金注入抽取");
        $return = FormPageAction("action", "init_default");
        print_infor("删除资金注入抽取单成功", 'trip', "location='?{$return}'", "?{$return}", 0);
    }
    $db->CompleteTrans();
    exit;

示例#6

文件： fahuodan_newai.php 项目： shesai0519/sunshineCRM

            print "\n<script type=\"text/javascript\" language=\"javascript\" src=\"" . ROOT_DIR . "general/ERP/Enginee/jquery/jquery.js\"></script>\n";
            print "<script type=\"text/javascript\" language=\"javascript\">\n\t\t\t\$.post('../Framework/sms_getContents.php?action=send', {\n\t\t\t    mobiles:'" . $rs_a[0][tel] . "',\n\t\t\t    msg:'" . cutStr($message, 70) . "'\n\t\t\t}, function(data) {\t\n\t\t\t});\n\t\t</script>";
        }
        page_css("确认发货");
        if ($return == '') {
            $return = FormPageAction("action", "init_default");
        }
        print_infor("发货单确认成功", 'trip', "location='?{$return}'", "?{$return}", 0);
    }
    $db->CompleteTrans();
    exit;
}
//撤销发货
if ($_GET['action'] == "chexiao") {
    $Store = new Store($db);
    $CaiWu = new CaiWu($db);
    $db->StartTrans();
    $fahuoinfo = returntablefield("fahuodan", "billid", $_GET['billid'], "yunfei,jiesuantype,dingdanbillid");
    $yunfei = $fahuoinfo['yunfei'];
    $jiesuantype = $fahuoinfo['jiesuantype'];
    $dingdanbillid = $fahuoinfo['dingdanbillid'];
    //撤销运费
    if ($yunfei != 0 && $jiesuantype == 1) {
        $CaiWu->insertFeiYongAccount(6, -$yunfei, 1, $_SESSION['LOGIN_USER_ID'], -1);
    }
    //撤销发货
    $Store->cancelFaHuo($_GET['billid']);
    //是否事务出现错误
    if ($db->HasFailedTrans()) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
    } else {

示例#7

文件： sellonemain_newai.php 项目： shesai0519/sunshineCRM

 $customerid = $billinfo['supplyid'];
 $shouhuoren = returntablefield("linkman", "rowid", $billinfo['linkman'], "linkmanname");
 $address = $billinfo['address'];
 $mobile = $billinfo['mobile'];
 $fapiaoneirong = $billinfo['fapiaoneirong'];
 $fapiaotype = $billinfo['fapiaotype'];
 $fapiaono = $billinfo['fapiaono'];
 try {
     if ($user_flag > 0) {
         throw new Exception("此单已执行过，不能重复执行");
     }
     //开启事务
     global $db;
     //$db->debug=1;
     $db->StartTrans();
     $CaiWu = new CaiWu($db);
     $Store = new Store($db);
     //出库
     $chukubillid = $Store->insertSellOneChuKu($billid, $zhuti, $storeid);
     //付款
     $accountid = $_POST['accountid'];
     $oddment = floatval($_POST['quling']);
     $shoukuan = floatval($_POST['shoukuan']);
     $opertype = '';
     if ($_POST['ifpay'] == 1) {
         //付全款
         $opertype = '货款收取';
     } else {
         //付押金
         $opertype = '收押金';
     }

示例#8

文件： Store.php 项目： shesai0519/sunshineCRM

 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);
 }

示例#9

文件： accesspreshou_newai.php 项目： shesai0519/sunshineCRM

    } else {
        page_css("预收款记录");
        $return = $_POST['url'];
        $return = $return . "?" . FormPageAction("action", "init_default");
        print_infor("预收款记录已生成", 'trip', "location='?{$return}'", "{$return}", 0);
    }
    $db->CompleteTrans();
    exit;
}
//撤销付款
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    try {
        //开启事务
        $CaiWu = new CaiWu($db);
        //$db->debug=1;
        $db->StartTrans();
        for ($i = 0; $i < sizeof($selectid); $i++) {
            if ($selectid[$i] != "") {
                $CaiWu->deleteYuShoukuanReocord($selectid[$i]);
            }
        }
        //是否事务出现错误
        if ($db->HasFailedTrans()) {
            print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
        } else {
            page_css("预收款记录");
            $return = FormPageAction("action", "init_default");
            print_infor("预收款记录已成功删除", 'trip', "location='?{$return}'", "?{$return}", 0);
        }

示例#10

文件： v_shoururecord_newai.php 项目： shesai0519/sunshineCRM

    //是否事务出现错误
    if ($db->HasFailedTrans()) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
    } else {
        page_css("其他收入单");
        $return = FormPageAction("action", "init_default");
        print_infor("其他收入单增加成功", 'trip', "location='?{$return}'", "?{$return}", 0);
    }
    $db->CompleteTrans();
    exit;
}
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    //开启事务
    $CaiWu = new CaiWu($db);
    $db->StartTrans();
    for ($i = 0; $i < sizeof($selectid); $i++) {
        if ($selectid[$i] != "") {
            $CaiWu->deleteFeiYongAccount($selectid[$i]);
        }
    }
    //是否事务出现错误
    if ($db->HasFailedTrans()) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
    } else {
        page_css("其他收入单");
        $return = FormPageAction("action", "init_default");
        print_infor("其他收入单删除成功", 'trip', "location='?{$return}'", "?{$return}", 0);
    }
    $db->CompleteTrans();

示例#11

文件： buyplanmain_newai.php 项目： shesai0519/sunshineCRM

        } 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;
}
//撤销采购订单
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    try {
        //开启事务
        $CaiWu = new CaiWu($db);
        $db->StartTrans();
        for ($i = 0; $i < sizeof($selectid); $i++) {
            if ($selectid[$i] != "") {
                $billid = $selectid[$i];
                $sql = "update buyplanmain set user_flag=-1 where billid={$billid} and user_flag>-1";
                $rs = $db->Execute($sql);
                if ($rs === false) {
                    throw new Exception("不存在此记录");
                }
                $CaiWu->deleteFukuanReocordByBillid($billid);
                $CaiWu->deleteshoupiaoByBillid($billid);
            }
        }
        $db->CompleteTrans();
        page_css("");

示例#12

文件： caigouorder_newai.php 项目： shesai0519/sunshineCRM

 //开启事务
 $CaiWu = new CaiWu($db);
 //$db->debug=1;
 $db->StartTrans();
 for ($i = 0; $i < sizeof($selectid); $i++) {
     if ($selectid[$i] != "") {
         $caigouinfo = returntablefield("caigouorder", "billid", $selectid[$i], "billid,supplyid,accountid,totalmoney,oddment,realmoney");
         $billid = $caigouinfo['billid'];
         $realmoney = $caigouinfo['realmoney'];
         $oddment = $caigouinfo['oddment'];
         $accountid = $caigouinfo['accountid'];
         $supplyid = $caigouinfo['supplyid'];
         $sql = "update caigouorder set state=-1 where billid={$billid} and state>-1";
         $rs = $db->Execute($sql);
         print_r($rs);
         $CaiWu = new CaiWu($db);
         if ($accountid > 0) {
             $CaiWu->operateAccount($accountid, -$realmoney, '采购订金', $billid);
         } else {
             $CaiWu->operatePrepay($supplyid, -$realmoney, '采购订金', $billid);
         }
         if ($oddment != 0) {
             $CaiWu->insertFeiYong(1, -$oddment, $accountid, $_SESSION['LOGIN_USER_ID'], 1, $billid, '');
         }
     }
 }
 //是否事务出现错误
 if ($db->HasFailedTrans()) {
     print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
 } else {
     page_css("");

示例#13

文件： v_feiyongrecord_newai.php 项目： shesai0519/sunshineCRM

<?php

ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
error_reporting(E_WARNING | E_ERROR);
require_once 'lib.inc.php';
$GLOBAL_SESSION = returnsession();
validateMenuPriv("费用支出单");
if ($_GET['action'] == "add_default_data") {
    global $db;
    //开启事务
    $db->StartTrans();
    $CaiWu = new CaiWu($db);
    $CaiWu->insertFeiYongAccount($_POST['typeid'], $_POST['jine'], $_POST['accountid'], $_SESSION['LOGIN_USER_ID'], $_POST['kind'], $_POST['chanshengdate'], $_POST['beizhu']);
    //是否事务出现错误
    if ($db->HasFailedTrans()) {
        print "<script language=javascript>alert('错误：" . str_replace("'", "\\'", $db->ErrorMsg()) . "');window.history.back(-1);</script>";
    } else {
        page_css("费用支出单");
        $return = FormPageAction("action", "init_default");
        print_infor("费用支出单增加成功", 'trip', "location='?{$return}'", "?{$return}", 0);
    }
    $db->CompleteTrans();
    exit;
}
if ($_GET['action'] == "delete_array") {
    $selectid = $_GET['selectid'];
    $selectid = explode(",", $selectid);
    //开启事务
    $db->StartTrans();
    for ($i = 0; $i < sizeof($selectid); $i++) {