save.php

开源的 库存管理系统 www.minierp.cn php+ mysql

<?php

$t_AUTOID=$_GET[AUTOID];
if (empty($t_AUTOID)){$t_AUTOID=0;};
$gshmid=$_GET[shno]; 		//送货单号
$gshm01=$_GET[shdate]; 		//送货日期
$gshm02=$_GET[shdw];		//收货单位
$gshm03=$_GET[pshm03];		//送货人
$gshm04=$_GET[pshm04];		//开单人 
$gshm05=$_GET[pshm05];		//收货人
$gshm06=$_GET[SubTotal];	//总金额
$gshm07=$_GET[RmbTotal];  	//人民币汇总
$gshm08=$_GET[pmemo];		//说明
$gshm09=$_GET[pshm09];		//说明
$gshm10=$_GET[pshm10];		//付款方式代码  0:月结，　1:现金
$gshm11=$_GET[pshm11];		//付款方式

$stat=0;  // 0　更新  1 新增
$rowCnt=$_GET[totalProductCount];	//明细数量

 include ("../inc/db.php");
 include ("../inc/phpmkrfn.php");
 include ("../kuchen/kuchen.php");

$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);

$m_tablename="shdmast";
	
	$sSql = "select * from $m_tablename where autoid =$t_AUTOID";
	
	$rs   = phpmkr_query($sSql,$conn) or die("a Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);

    
	$FIELDSTR  =" shmid ='$gshmid',";
	$FIELDSTR .=" shm01 ='$gshm01',";
	$FIELDSTR .=" shm02 ='$gshm02',";
	$FIELDSTR .=" shm03 ='$gshm03',";
	$FIELDSTR .=" shm04 ='$gshm04',";
	$FIELDSTR .=" shm05 ='$gshm05',";
	$FIELDSTR .=" shm06 ='$gshm06',";
	$FIELDSTR .=" shm07 ='$gshm07',";
	$FIELDSTR .=" shm08 ='$gshm08',";
	$FIELDSTR .=" shm09 ='$gshm09',";
	$FIELDSTR .=" shm10 ='$gshm10',";
	$FIELDSTR .=" shm11 ='$gshm11',";
	$FIELDSTR .=" dt999 = now()  ";

if (phpmkr_num_rows($rs) > 0){
	$uSql  = "update $m_tablename set ";
	$uSql .=$FIELDSTR;
	$uSql .=" where autoid =$t_AUTOID";
}
else
{
	$uSql = "INSERT INTO $m_tablename set ";
	$uSql .=$FIELDSTR;	
}
$rs   = phpmkr_query($uSql,$conn) or die("b Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $uSql);
//********************************************************************
//2.删除明细项目未能处理			2006-02-20  ElvenHu
//***************************送货单从表更新***************************

/*
$dautoid=$_GET[auto1];		//明细序号
$gshd01=$_GET[hpshd011];	//产品编号
$gshd02=$_GET[pshd021];  	//产品名称规格
$gshd03=$_GET[pshd031];		//数量
$gshd04=$_GET[pshd041];		//单价
$gshd05=$_GET[pshd051];		//金额
$gshd06=$_GET[pshd061];		//产品单位
$gstatu=$_GET[hdnRowStatus1];	//明细状态　0 不用处理　1 修改 2 增加
$gcount=$_GET[totalProductCount];  //明细数量
*/

$gcount=$_GET[totalProductCount];

$m_tablename="shddelt";

for ($i =1;$i<=$gcount;++$i ){
   
   if ($gstatu= 0) {}

    $dautoid=$_GET[auto.$i];
   if (empty($dautoid)){$dautoid=0;};

   	$sSql = "select * from $m_tablename where AUTOID =$dautoid";
	$drs   = phpmkr_query($sSql,$conn) or die(" c Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);

	$t_SHD01=$_GET[x_SHD01.$i];
	$t_SHD02=$_GET[pshd02.$i]; 
	$t_SHD03=$_GET[pshd03.$i];	
	$t_SHD04=$_GET[pshd04.$i];	
	$t_SHD05=$_GET[pshd05.$i];	
	$t_SHD06=$_GET[pshd06.$i];
	$t_SHD07=$_GET[x_SHD07.$i];
	$t_SHD08=$_GET[x_SHD08.$i];
	$t_SHD09=$_GET[x_SHD09.$i];

	$FIELDSTR  =" SHDID ='$gshmid',";
	$FIELDSTR .=" SHD01 ='$t_SHD01',";
	$FIELDSTR .=" SHD02 ='$t_SHD02',";
	$FIELDSTR .=" SHD03 ='$t_SHD03',";
	$FIELDSTR .=" SHD04 ='$t_SHD04',";
	$FIELDSTR .=" SHD05 ='$t_SHD05',";
	$FIELDSTR .=" SHD06 ='$t_SHD06',";
	$FIELDSTR .=" SHD07 ='$t_SHD07',";
	$FIELDSTR .=" SHD08 ='$t_SHD08',";
	$FIELDSTR .=" SHD09 ='$t_SHD09',";
	$FIELDSTR .=" DT999 = now()  ";

 if (phpmkr_num_rows($drs) > 0){
	$row  = mysql_fetch_array($drs, MYSQL_ASSOC);
	$O_num =$row[SHD03]; //数量
	$O_pid =$row[SHD01]; //产品编号
	$O_psn =$row[SHD08]; //序号
	$O_pph =$row[SHD07]; //批号
	
	if (($t_SHD01<>$O_pid) or ($t_SHD08<>$O_psn) or ($t_SHD07<>$O_pph)){
		updatekuchen($O_pid,$O_psn,$O_pph,0-$O_num);	//修改之前的库存
		$p_num = $t_SHD03;
	  } else {
	    $p_num = $t_SHD03 - $O_num ;
	   };

	$uSql  = "update $m_tablename set ";
	$uSql .= $FIELDSTR;
	$uSql .= " where autoid =$dautoid";
    }
   else {
	$uSql  = "INSERT INTO $m_tablename set ";
	$uSql .= $FIELDSTR;
	$p_num = $t_SHD03 ;
    }

	$drs   = phpmkr_query($uSql,$conn) or die("d Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $uSql);

	updatekuchen($t_SHD01,$t_SHD08,$t_SHD07,$p_num);
//	updatekuchen($p_id,$p_sn,$p_ph,$p_num)
 
}

header("location:list.php");
?>