Sh-To-ERP-SYS-APP/apk/shto_main.php

<?php
	include	'shto_sqlcon.php';
	$comm = @$_GET['comm'];
	$se=@$_GET['se'];
	$帳號=@$_GET['帳號'];
	$密碼=@$_GET['密碼'];
	$PA=@$_GET['PA'];
	$PA1=@$_GET['PA1'];
	$PA2=@$_GET['PA2'];
	$PA3=@$_GET['PA3'];
	$PA4=@$_GET['PA4'];
	$PA5=@$_GET['PA5'];
	$PA6=@$_GET['PA6'];
	$PA7=@$_GET['PA7'];
	$PA8=@$_GET['PA8'];
	$PA9=@$_GET['PA9'];

	if($se=='test'){
		require_once('shto_sql.php');
	}else if($se=='official'){
		require_once('shto_sqlb.php');
	}

	if($comm=='讀取'){
		$sql=SQL_帳密比對($帳號,$密碼);
		$result=sqlsrv_query($conn,$sql);
		$row=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC);
		$json_data = json_encode($row);		
		echo $json_data;
		sqlsrv_close($conn);
	}else if($comm=='測驗'){
		$sql=SQL_測驗();
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='電簽流水查詢'){
		$sql=SQL_電簽流水查詢();
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$圖片流水號=$row['圖片流水號'];
		}
		sqlsrv_close($conn);
		if(isset($圖片流水號)==1){
			echo $圖片流水號;
		}else{
			echo 'n';
		}
	}else if($comm=='電簽清單'){
		$sql=SQL_電簽清單();
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
		while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
			$imageData = $row['電子簽章圖片'];
    		$base64 = base64_encode($imageData);
    		$row['電子簽章圖片'] = $base64;
			array_push($rows, $row);
		}
		sqlsrv_free_stmt($stmt);
		sqlsrv_close($conn);
		echo json_encode($rows);
	}else if($comm=='使用者資料'){
		$sql=SQL_使用者資料($PA);
		$result=sqlsrv_query($conn,$sql);
		$row=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC);
		$json_data = json_encode($row);		
		echo $json_data;
		sqlsrv_close($conn);
	}else if($comm=='密碼修改'){
		$sql=SQL_密碼修改($PA,$PA1,$PA2);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='點名主表'){
		$sql=SQL_點名主表($PA,$PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='點名明細'){
		$sql=SQL_點名明細($PA);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='點名明細1'){
		$sql=SQL_點名明細1($PA1);
		$result=sqlsrv_query($conn,$sql);
		$row=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC);
		$json_data = json_encode($row);		
		echo $json_data;
		sqlsrv_close($conn);
	}else if($comm=='主管簽名檔清單'){
		$sql=SQL_主管簽名檔清單();
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
		while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
			array_push($rows, $row);
		}
		sqlsrv_free_stmt($stmt);
		sqlsrv_close($conn);
		echo json_encode($rows);
	}else if($comm=='員工清單'){
		$sql=SQL_員工清單();
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=="點名查找當日日期"){
		$sql=SQL_點名查找當日日期($PA);
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$日期=$row['日期'];
		}
		sqlsrv_close($conn);
		if(isset($日期)==1){
			echo '有';
		}else{
			echo '無';
		}
	}else if($comm=="點名流水號查詢"){
		$sql=SQL_點名流水號查詢($PA);
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$流水號=$row['流水號'];
		}
		sqlsrv_close($conn);
		if(isset($流水號)==1){
			echo $流水號;
		}else{
			echo 'n';
		}
	}else if($comm=='查找點名最後一筆流水號'){
		$sql=SQL_查找點名最後一筆流水號();
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$流水號=$row['流水號'];
		}
		sqlsrv_close($conn);
		if(isset($流水號)==1){
			echo $流水號;
		}else{
			echo 'n';
		}
	}else if($comm=='新增點名控制表資料'){
		$sql=SQL_新增點名控制表資料($PA1,$PA2,$PA3,$PA4,$PA5,$PA6,$PA7);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='新增點名明細表資料'){
		$sql=SQL_新增點名明細表資料($PA1,$PA2,$PA3,$PA4);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='修改點名控制表資料'){
		$sql=SQL_修改點名控制表資料($PA1,$PA2,$PA3,$PA4);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='修改點名明細表資料'){
		$sql=SQL_修改點名明細表資料($PA1,$PA2,$PA3,$PA4);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='修改點名控制表簽名總'){
		$sql=SQL_修改點名控制表簽名總($PA1,$PA2,$PA3);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='修改點名控制表簽名副'){
		$sql=SQL_修改點名控制表簽名副($PA1,$PA2,$PA3);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='修改點名控制表簽名廠'){
		$sql=SQL_修改點名控制表簽名廠($PA1,$PA2,$PA3);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='修改點名控制表簽名'){
		$sql=SQL_修改點名控制表簽名($PA1,$PA2,$PA3,$PA4,$PA5,$PA6,$PA7);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='庫存明細表'){
		$sql=SQL_庫存明細表($PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='生產排程明細表'){
		$sql=SQL_生產排程明細表();
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='出貨排程明細表'){
		$sql=SQL_出貨排程明細表();
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='生產日報表清單'){
		$sql=SQL_生產日報表清單($PA,$PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='生產日報表明細'){
		$sql=SQL_生產日報表明細($PA,$PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='出貨日報表清單'){
		$sql=SQL_出貨日報表清單($PA,$PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='出貨日報表明細'){
		$sql=SQL_出貨日報表明細($PA2);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='盤營盤損流水號最後一比'){
		$sql=SQL_盤營盤損流水號最後一比();
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$流水號=$row['流水號'];
		}
		sqlsrv_close($conn);
		if(isset($流水號)==1){
			echo $流水號;
		}else{
			echo 'n';
		}
	}else if($comm=="庫存盤點人讀取"){
		$sql=SQL_庫存盤點人讀取();
		$result=sqlsrv_query($conn,$sql);
		$names = array();
		while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
			array_push($names, $row['姓名']);
		}
		echo json_encode($names);
		sqlsrv_close($conn);
	}else if($comm=='盤點申請控制表新增'){
		$sql=SQL_盤點申請控制表新增($PA1,$PA2,$PA3,$PA4,$PA5);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤點申請控制表修改'){
		$sql=SQL_盤點申請控制表修改($PA1,$PA2,$PA3,$PA4,$PA5);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='起始刪除'){
		$sql=SQL_起始刪除();
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=="群組碼清單"){
		$sql=SQL_群組碼清單();
		$result=sqlsrv_query($conn,$sql);
		$names = array();
		while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
			array_push($names, $row['群組']);
		}
		echo json_encode($names);
		sqlsrv_close($conn);
	}else if($comm=='物料清單'){
		$sql=SQL_物料清單($PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='物料明細清單'){
		$sql=SQL_物料明細清單($PA1,$PA2);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='物料明細讀取'){
		$sql=SQL_物料明細讀取($PA1,$PA2);
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$料號=$row['料號'];
		}
		sqlsrv_close($conn);
		if(isset($料號)==1){
			echo $料號;
		}else{
			echo 'n';
		}
	}else if($comm=='盤營盤損明細流水號最後一比'){
		$sql=SQL_盤營盤損明細流水號最後一比();
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$流水號=$row['流水號'];
		}
		sqlsrv_close($conn);
		if(isset($流水號)==1){
			echo $流水號;
		}else{
			echo 'n';
		}
	}else if($comm=='盤點申請明細表新增'){
		$sql=SQL_盤點申請明細表新增($PA1,$PA2,$PA3,$PA4,$PA5);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='選定物料庫存量讀取'){
		$sql=SQL_選定物料庫存量讀取($PA1);
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$庫存=$row['庫存'];
		}
		sqlsrv_close($conn);
		if(isset($庫存)==1){
			echo $庫存;
		}else{
			echo 'n';
		}
	}else if($comm=='庫存盤點申請明細表讀取'){
		$sql=SQL_庫存盤點申請明細表讀取($PA1,$PA2);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='庫存盤點申請明細表讀取1'){
		$sql=SQL_庫存盤點申請明細表讀取1($PA1,$PA2);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='庫存盤點申請明細表刪除'){
		$sql=SQL_庫存盤點申請明細表刪除($PA1);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤點申請明細表儲存'){
		$sql=SQL_盤點申請明細表儲存($PA1,$PA2,$PA3,$PA4,$PA5,$PA6);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤營盤損排程流水號最後一比'){
		$sql=SQL_盤營盤損排程流水號最後一比();
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$流水號=$row['流水號'];
		}
		sqlsrv_close($conn);
		if(isset($流水號)==1){
			echo $流水號;
		}else{
			echo 'n';
		}
	}else if($comm=='盤點申請排程明細表新增'){
		$sql=SQL_盤點申請排程明細表新增($PA1,$PA2,$PA3,$PA4,$PA5,$PA6,$PA7,$PA8,$PA9);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤營盤損歷表本'){
		$sql=SQL_盤營盤損歷表本($PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='盤營盤損歷表非本'){
		$sql=SQL_盤營盤損歷表非本($PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='盤營盤損排程流水號刪除'){
		$sql=SQL_盤營盤損排程流水號刪除($PA1);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤營盤損明細表排程流水號修改'){
		$sql=SQL_盤營盤損明細表排程流水號修改($PA1);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤營盤損明細表複點修改'){
		$sql=SQL_盤營盤損明細表複點修改($PA1,$PA2);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤營盤損控制表狀況修改'){
		$sql=SQL_盤營盤損控制表狀況修改($PA1,$PA2);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤營盤損審核'){
		$sql=SQL_盤營盤損審核($PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='盤營盤損未審'){
		$sql=SQL_盤營盤損未審($PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='盤營盤損已審'){
		$sql=SQL_盤營盤損已審($PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='修改盤營盤損控制表簽名'){
		$sql=SQL_修改盤營盤損控制表簽名($PA1,$PA2,$PA3);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='盤點審核排程明細表修改'){
		$sql=SQL_盤點審核排程明細表修改($PA1,$PA2);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='庫存表物料明細'){
		$sql=SQL_庫存表物料明細($PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='生產排程表修改'){
		$sql=SQL_生產排程表修改($PA1,$PA2,$PA3);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='出貨排程表修改'){
		$sql=SQL_出貨排程表修改($PA1,$PA2,$PA3);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='查詢出貨控制表日期'){
		$sql=SQL_查詢出貨控制表日期($PA1);
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$值=$row[''];
		}
		sqlsrv_close($conn);
		echo $值;
	}else if($comm=='查找出貨日報最後流水號'){
		$sql=SQL_查找出貨日報最後流水號();
		$result=sqlsrv_query($conn,$sql);
		while($row=sqlsrv_fetch_array($result)){
			$流水號=$row['流水號'];
		}
		sqlsrv_close($conn);
		if(isset($流水號)==1){
			echo $流水號;
		}else{
			echo 'n';
		}
	}else if($comm=='新增出貨日報表日期'){
		$sql=SQL_新增出貨日報表日期($PA1,$PA2,$PA3);
		sqlsrv_query($conn,$sql);
		sqlsrv_close($conn);
	}else if($comm=='生產日報表加班明細'){
		$sql=SQL_生產日報表加班明細($PA,$PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}else if($comm=='考勤日期查詢清單'){
		$sql=SQL_考勤日期查詢清單($PA,$PA1);
		$stmt=sqlsrv_query($conn,$sql);
		$rows = array();
    	while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
        	array_push($rows, $row);
    	}
    	sqlsrv_free_stmt($stmt);
    	sqlsrv_close($conn);
    	echo json_encode($rows);
	}
?>