<?php
include('install_lang_japanese.php');
include('functions.php');


if (phpversion() >='4.1.0') {
	include_once('vars4.1.0.php');
}else {
	include_once('vars4.0.6.php');
}

//connect to database
$dbc=mysql_connect(_SRV,_ACCID,_PWD) or die(_ERROR15.": ".mysql_error());
$db=mysql_select_db("QPL",$dbc) or die(_ERROR17.": ".mysql_error());


$target_path = "data/";

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);
//print_r($_FILES);
        if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
                echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded";
                }
        else{
                echo "There was an error uploading the file, please try again!";
                }

switch(postVar('action')) {
	case 'oqcdata' :
		oqcdata(postVar('mod'),postVar('no'),postVar('lotno'),postVar('date'),
                postVar('sym'),postVar('coz'),postVar('stat'),postVar('cm'),postVar('detail'));
		break;
}

function oqcdata($mod,$no,$lotno,$date,$sym,$coz,$stat,$cm,$detail) {

	$Model        	= mysql_real_escape_string($mod);
        $Serial 	= mysql_real_escape_string($no);
	$Lot          	= mysql_real_escape_string($lotno);
	$Date    	= mysql_real_escape_string($date);
	$Sym      	= mysql_real_escape_string($sym);
	$Coz       	= mysql_real_escape_string($coz);
	$Stat        	= mysql_real_escape_string($stat);
        $CM	        = mysql_real_escape_string($cm);
	$Detail		= mysql_real_escape_string($detail);
	$Model        	= strtoupper($Model);
	$Serial 	= strtoupper($Serial);
	$Lot         	= strtoupper($Lot);
	$Sym		= stripcslashes($Sym);
	$Coz            = stripcslashes($Coz);
	$Stat           = stripcslashes($Stat);

//build query
  $sql = "INSERT INTO OQC ";
  $sql.= "(Model, Serial, Lotno, Date, Symptom, Cause, Status, CM,Detail) ";
  $sql.= "VALUES ('";
  $sql.= $Model."','".$Serial."','".$Lot."','".$Date."','".$Sym."','".$Coz."','";
  $sql.= $Stat."','".$CM."','".$Detail."')";
echo $sql;
$result=mysql_query($sql) or die(_ERROR26.": ".mysql_error());
echo $result;
mysql_close($dbc);
}

?>