<?php
	header('Content-type: text/html; charset=utf-8');
	require_once('connDB.php');
	
	if(!isset($_SESSION)){
		session_start();
	}
	
	$id = " ";
	$custid= " ";
	$skuid= " ";
	$skucn= " ";
	$skuen= " ";
	$customs= " ";
	$uom= " ";
	$nw = " ";
	$unit= " ";
	$custm= " ";
	$jgtj= " ";
	$custn= " ";
	$sbys= " ";
	$remark= " "; 
	
	if(isset($_GET['custList'])){
		//echo 'custList';
		$sql = "SELECT `custid`,`custcn` FROM `cust` ORDER BY `id` DESC";
		$result = mysql_query($sql,$dbc);
		
		$arr1=Array();
		while($row_Rec = mysql_fetch_assoc($result)){
			$arr2=array("id"=>$row_Rec['custid'],
				"text"=>$row_Rec['custcn']);
			array_push($arr1,$arr2);
		}
		echo json_encode($arr1);
		return;
	}
	
	
	
	if(isset($_POST['add1'])){
		//addnew
		/*
		*确认新添加的数据，并最终添加进数据库。
		*/
		
		//echo 'ok';
		$custid=$_POST['custid'];
		$skuid= $_POST['skuid'];
		$skucn= $_POST['skucn']=""?" ":$_POST['skucn'];
		$skuen= $_POST['skuen']=""?" ":$_POST['skuen'];
		$customs= $_POST['customs']=""?" ":$_POST['customs'];
		$uom= $_POST['uom']=""?" ":$_POST['uom'];
		$nw = $_POST['nw']=""?" ":$_POST['nw'];
		$unit= $_POST['unit']=""?" ":$_POST['unit'];
		$custm= $_POST['custm']=""?" ":$_POST['custm'];
		$jgtj= $_POST['jgtj']=""?" ":$_POST['jgtj'];
		$custn= $_POST['custn']=""?" ":$_POST['custn'];
		$sbys= $_POST['sbys']=""?" ":$_POST['sbys'];
		$remark= $_POST['remark']=""?" ":$_POST['remark'];
		
		$sql = "INSERT INTO sku (id ,custid ,skuid ,skucn ,skuen ,customs ,".
		"uom ,nw ,unit ,custm ,jgtj ,custn ,sbys ,remark ".
		")VALUES (".
		"NULL ,  '$custid',  '$skuid', '$skucn' , '$skuen' , '$customs' , ".
		"'$uom' , '$nw' , '$unit' , '$custm' , '$jgtj' , '$custn' , '$sbys' , '$remark' );";
		echo $sql;
		//goto loop;
		
		mysql_query($sql,$dbc);
		mysql_close($dbc);
		header("Location:"."sku2.php");
		return;
		
	}

	if(isset($_POST['update1'])){
		//update
		 
		echo 'ok';
		$id = $_POST['id'];
		$custid=$_POST['custid'];
		$skuid= $_POST['skuid'];
		$skucn= $_POST['skucn']=""?" ":$_POST['skucn'];
		$skuen= $_POST['skuen']=""?" ":$_POST['skuen'];
		$customs= $_POST['customs']=""?" ":$_POST['customs'];
		$uom= $_POST['uom']=""?" ":$_POST['uom'];
		$nw = $_POST['nw']=""?" ":$_POST['nw'];
		$unit= $_POST['unit']=""?" ":$_POST['unit'];
		$custm= $_POST['custm']=""?" ":$_POST['custm'];
		$jgtj= $_POST['jgtj']=""?" ":$_POST['jgtj'];
		$custn= $_POST['custn']=""?" ":$_POST['custn'];
		$sbys= $_POST['sbys']=""?" ":$_POST['sbys'];
		$remark= $_POST['remark']=""?" ":$_POST['remark'];
		
		$sql="UPDATE  webwms.sku SET  custid =  '$custid', ".
			"skuid =  '$skuid', ".
			"skucn =  '$skucn', ".
			"skuen =  '$skuen', ".
			"customs =  '$customs', ".
			"uom =  '$uom', ".
			"nw =  '$nw', ".
			"unit =  '$unit', ".
			"custm =  '$custm', ".
			"jgtj =  '$jgtj', ".
			"custn =  '$custn', ".
			"sbys =  '$sbys', ".
			"remark =  '$remark' ".
			"WHERE  sku.id = $id; ";
		
		echo $sql;
		
		mysql_query($sql,$dbc);
		mysql_close($dbc);
		header("Location:"."sku2.php"); 
		 
		return;
		
	}
	
	if(isset($_POST['delete1'])){
		//delete1
		
		$id = $_POST['id'];
		$sql = "DELETE FROM sku WHERE sku.id = $id ";
		
		echo $sql;
		mysql_query($sql,$dbc);
		mysql_close($dbc);
		header("Location:"."shu1.php");
		return;
	}
	
	if(isset($_POST['search1'])){
		//search
		
		
	}
	
?>