Пример #1
0
function dataDeal_add()
{
    global $_SESSION, $_GET, $_POST, $db;
    $tablename = "stockoutmain";
    $childtablename = "stockoutdetail";
    $Columns = returntablecolumn($tablename);
    $ChildColumns = returntablecolumn($childtablename);
    //print_R($ChildColumns);print "<HR>";
    //print_R($Columns);print "<HR>";
    $sql = "";
    $FieldArray = array();
    $ValueArray = array();
    for ($i = 0; $i < sizeof($Columns); $i++) {
        $Element = $Columns[$i];
        $Value = $_POST[$Element];
        if ($Value != "") {
            array_push($FieldArray, $Element);
            switch ($Element) {
                case 'amt':
                case 'payamt':
                case 'factpayamt':
                case 'noFaxAmt':
                    $Value = ereg_replace(',', '', $Value);
                    $Value = (double) $Value;
                    break;
            }
            array_push($ValueArray, $Value);
        }
    }
    //print_R($FieldArray);
    //单据不流转时,采用的方法
    global $SYSTEM_STOP_FLOW;
    if ($SYSTEM_STOP_FLOW == 1) {
        array_push($FieldArray, "flowState");
        array_push($ValueArray, 1);
    }
    //print_R($FieldArray);
    $FieldText = join(',', $FieldArray);
    $ValueText = join("','", $ValueArray);
    //形成主表SQL插入
    $sql = "insert into {$tablename} ( {$FieldText} ) values ( '" . $ValueText . "' );";
    $rs = $db->Execute($sql);
    $MainID = $db->Insert_ID();
    ////print $sql."<BR>";
    //print_R($Columns);
    //#########################################################################
    //从表字段插入SQL语句形成##################################################
    //#########################################################################
    $sql = "";
    $MaxValue = 10;
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 20;
    }
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 30;
    }
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 40;
    }
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 50;
    }
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 60;
    }
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 70;
    }
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 80;
    }
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 90;
    }
    if ($_POST['productid_id_' . $MaxValue] != "") {
        $MaxValue = 100;
    }
    //明细列表
    //$MainID = 9;//主键值
    for ($m = 0; $m < $MaxValue; $m++) {
        $FieldArray = array();
        $ValueArray = array();
        //明细单项判断
        if ($_POST['productid_id_' . $m] != "") {
            //明细SQL语句形成
            for ($i = 0; $i < sizeof($ChildColumns); $i++) {
                $Element = TRIM($ChildColumns[$i]);
                if ($Element == "productid") {
                    $Element = "productid_id";
                }
                if ($m == 0) {
                    $Value = $_POST[$Element];
                } else {
                    if ($Element == "stockoutfactnum") {
                        $Value = $_POST["plannum_" . $m];
                    } else {
                        $Value = $_POST[$Element . "_" . $m];
                    }
                }
                if ($Value != "") {
                    array_push($FieldArray, $ChildColumns[$i]);
                    array_push($ValueArray, $Value);
                }
            }
            $FieldText = join(',', $FieldArray);
            $ValueText = join("','", $ValueArray);
            //形成主表SQL插入
            $sql = "insert into {$childtablename} ( " . $FieldText . ",mainrowid ) values ( '" . $ValueText . "','" . $MainID . "' );";
            $rs = $db->Execute($sql);
            ////print $sql."<BR>";
        }
    }
    //print_R($FieldArray);
    //流转操作自动化
    global $SYSTEM_STOP_FLOW;
    if ($SYSTEM_STOP_FLOW == 1 && $MainID != "") {
        StockOutToStore($MainID, 1);
    }
}
<?php

require_once 'lib.inc.php';
$sessionkey = returnSessKey();
$GLOBAL_SESSION = returnsession();
$SUNSHINE_USER_NAME = $_SESSION['SUNSHINE_USER_NAME'];
$SUNSHINE_USER_NAME = 'admin';
if ($_GET['action'] == "edit_default2") {
    //print_R($_GET);
    //StockOutToStore($_GET['ROWID'],$_POST['flowState']);
}
if ($_GET['action'] == "edit_default2_data") {
    //print_R($_POST);print_R($_GET);
    StockOutToStore($_GET['ROWID'], $_POST['flowState']);
    //exit;
}
//默认操作
$filetablename = 'stockoutmain';
$parse_filename = 'stockoutmainflow';
require_once 'include.inc.php';
systemhelpContent("出库操作管理说明", '100%');
//功能函数区
//第一:把入库单据转换为库存
function StockOutToStore($Rowid, $flowState)
{
    global $db;
    if ($Rowid == "") {
        exit;
    }
    $MainTable = "stockoutmain";
    $DetailTable = "stockoutdetail";