qianshou.php

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

<?php

$t_AUTOID=$_GET[AUTOID];
if (empty($t_AUTOID)){$t_AUTOID=0;};

 include ("../inc/db.php");
 include ("../inc/phpmkrfn.php");
 include ("../yinshou/yinshou.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 =" SHM12 ='1',";
	$FIELDSTR .=" DT999 = now()  ";

if (phpmkr_num_rows($rs) > 0){
	$uSql  = "update $m_tablename set ";
	$uSql .=$FIELDSTR;
	$uSql .=" where AUTOID =$t_AUTOID";

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

//新增应收帐款
$row  = mysql_fetch_array($rs, MYSQL_ASSOC);
$ys_ac=$row[SHM02]; //客户编号
$ys_id=$row[SHMID]; //送货单号
$ys_ty="SHD";		//送货单

$m_tablename="shddelt";
$desSql = "select * from $m_tablename where SHDID ='$ys_id'";
$ders   = phpmkr_query($desSql,$conn) or die("a Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);


    while ($row = mysql_fetch_array($ders, MYSQL_ASSOC)) {

		$ys_num =$row[SHD05];
		yinshou_new($ys_ac,$ys_id,$ys_ty,$ys_num);

	}
}


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