GA-ERP-SYS-APP/GA_sqlcon.php

<?php
function SQL_系統版本號驗證(){
	$sql="SELECT 手機認證版本號 FROM 版本號管理";
	return $sql;
}
function SQL_送審版本號驗證IOS(){
	$sql="SELECT IOS送審版本號 FROM 版本號管理";
	return $sql;
}
function SQL_系統版本號驗證IOS(){
	$sql="SELECT IOS認證版本號 FROM 版本號管理";
	return $sql;
}
function  SQL_帳密比對($帳號,$密碼){
	$sql="SELECT 姓名,CC44 FROM 使用者權限管理表 WHERE 帳號 = '".$帳號."' and 密碼 = '".$密碼."'";
	return $sql;
}
function  SQL_帳密比對1($帳號){
	$sql="SELECT * FROM 使用者權限管理表 WHERE 帳號 = '".$帳號."' ";
	return $sql;
}
function SQL_使用者資料($PA){
	$sql="SELECT 姓名, 帳號, 密碼 FROM 使用者權限管理表 WHERE (姓名 = '" .$PA. "')";
	return $sql;
}
function SQL_密碼修改($PA,$PA1){
	$sql="UPDATE 使用者權限管理表 SET 密碼 = '" .$PA. "' WHERE (姓名 = '" .$PA1. "')";
	return $sql;
}
function SQL_日期清單(){
	$sql="SELECT TOP (62) 開始日期 AS 資料, 開始日期, 結束日期 FROM 後台彙總存檔 WHERE (週日月 Like '天') GROUP BY 開始日期, 結束日期 ORDER BY 開始日期 DESC";
	return $sql;
}
function SQL_IP(){
	$sql = "SELECT 資料庫, IP位置, 帳號, 密碼 FROM 客戶資料表 WHERE 客戶 = N'KU01'";
	return $sql;
}
function SQL_後台彙總讀取2($PA,$PA1,$PA2){
	$sql="SELECT     後台彙總存檔.商品 AS 項次, 後台彙總存檔.商品 AS 網址, 後台彙總存檔.商品, 後台彙總存檔.系統, 後台彙總存檔.商品 AS 帳號, 
                           SUM(CAST(後台彙總存檔.虛量 AS money)) AS 虛量, SUM(CAST(後台彙總存檔.實量 AS money)) AS 實量, 
                           SUM(CAST(後台彙總存檔.退水 AS money)) AS 退水, SUM(CAST(後台彙總存檔.中獎 AS money)) AS 中獎, 
                           SUM(CAST(後台彙總存檔.輸贏 AS money)) AS 輸贏, SUM(CAST(後台彙總存檔.貢獻額 AS money)) AS 貢獻額, 
                           CAST(SUM(CAST(後台彙總存檔.大總監 AS money)) AS nvarchar(50)) AS 結果, 
                           SUM(CAST(後台彙總存檔.移轉 AS money)) AS 移轉, SUM(後台彙總存檔.排序) AS 排序, SUM(後台彙總存檔.調退實佔) AS 調退實佔, 
                           後台彙總存檔.類別
                FROM       後台彙總存檔 LEFT OUTER JOIN 後台商客基本資料表 ON 後台彙總存檔.帳號 = 後台商客基本資料表.帳號 AND 
                           後台彙總存檔.商品 = 後台商客基本資料表.商品
                WHERE     (後台彙總存檔.週日月 LIKE '天') AND (後台彙總存檔.開始日期 BETWEEN '" .$PA. "' AND '" .$PA1. "') " .$PA2. " GROUP BY   後台彙總存檔.商品, 後台彙總存檔.系統, 後台彙總存檔.類別 ORDER BY   後台彙總存檔.商品, 後台彙總存檔.類別";
	return $sql;
}
function SQL_後台彙總讀取1($PA,$PA1,$PA2){
	$sql="SELECT     後台彙總存檔.商品 AS 項次, 後台彙總存檔.商品 AS 網址, 後台彙總存檔.商品, 後台彙總存檔.系統, 
                           後台彙總存檔.商品 AS 帳號, SUM(CAST(後台彙總存檔.虛量 AS money)) AS [總量-日], 
                           SUM(CAST(後台彙總存檔.實量 AS money)) AS [結果-日], SUM(CAST(後台彙總存檔.退水 AS money)) AS [539-日], 
                           SUM(CAST(後台彙總存檔.中獎 AS money)) AS [加州彩-日], SUM(CAST(後台彙總存檔.輸贏 AS money)) AS [六合彩-日], 
                           SUM(CAST(後台彙總存檔.貢獻額 AS money)) AS [大樂透-日], SUM(後台彙總存檔.排序) AS 排序
                FROM       後台彙總存檔 LEFT OUTER JOIN
                           後台商客基本資料表 ON 後台彙總存檔.帳號 = 後台商客基本資料表.帳號 AND 
                           後台彙總存檔.商品 = 後台商客基本資料表.商品
                WHERE     (後台彙總存檔.週日月 LIKE '天') AND (後台彙總存檔.開始日期 BETWEEN '" .$PA. "' AND '" .$PA1. "') " .$PA2. "
                GROUP BY   後台彙總存檔.商品, 後台彙總存檔.商品, 後台彙總存檔.系統
                ORDER BY   後台彙總存檔.商品";
	return $sql;
}
function SQL_後台彙總讀取3($PA,$PA1,$PA2){
	$sql="SELECT      後台彙總存檔.商品 AS 項次, 後台彙總存檔.商品, 後台彙總存檔.系統, SUM(CAST(後台彙總存檔.虛量 AS money)) 
                            AS [總量-周], SUM(CAST(後台彙總存檔.實量 AS money)) AS [結果-周], SUM(CAST(後台彙總存檔.退水 AS money)) 
                            AS [539-周], SUM(CAST(後台彙總存檔.中獎 AS money)) AS [加州彩-周], SUM(CAST(後台彙總存檔.輸贏 AS money)) 
                            AS [六合彩-周], SUM(CAST(後台彙總存檔.貢獻額 AS money)) AS [大樂透-周], SUM(後台彙總存檔.排序) AS 排序
                FROM        後台彙總存檔 LEFT OUTER JOIN
                            後台商客基本資料表 ON 後台彙總存檔.帳號 = 後台商客基本資料表.帳號 AND 
                            後台彙總存檔.商品 = 後台商客基本資料表.商品
                WHERE      (後台彙總存檔.週日月 LIKE '天') AND (後台彙總存檔.開始日期 BETWEEN '" .$PA. "' AND '" .$PA1. "') " .$PA2. "
                GROUP BY    後台彙總存檔.商品, 後台彙總存檔.系統
                ORDER BY    項次";
	return $sql;
}
function SQL_後台彙總讀取4($PA,$PA1,$PA2){
	$sql="SELECT      後台彙總存檔.商品 AS 項次, 後台彙總存檔.商品, 後台彙總存檔.系統, SUM(CAST(後台彙總存檔.虛量 AS money)) 
                            AS [總量-月], SUM(CAST(後台彙總存檔.實量 AS money)) AS [結果-月], SUM(CAST(後台彙總存檔.退水 AS money)) 
                            AS [539-月], SUM(CAST(後台彙總存檔.中獎 AS money)) AS [加州彩-月], SUM(CAST(後台彙總存檔.輸贏 AS money)) 
                            AS [六合彩-月], SUM(CAST(後台彙總存檔.貢獻額 AS money)) AS [大樂透-月], SUM(後台彙總存檔.排序) AS 排序
                FROM        後台彙總存檔 LEFT OUTER JOIN
                            後台商客基本資料表 ON 後台彙總存檔.帳號 = 後台商客基本資料表.帳號 AND 
                            後台彙總存檔.商品 = 後台商客基本資料表.商品
                WHERE      (後台彙總存檔.週日月 LIKE '天') AND (後台彙總存檔.開始日期 BETWEEN '" .$PA. "' AND '" .$PA1. "') " .$PA2. "
                GROUP BY    後台彙總存檔.商品, 後台彙總存檔.系統
                ORDER BY    項次";
	return $sql;
}
function SQL_後台彙總讀取5($PA,$PA1,$PA2){
	$sql="SELECT      後台彙總存檔.商品 AS 項次, 後台彙總存檔.商品 AS [商品 (元)], 後台彙總存檔.系統, 後台彙總存檔.商品 AS [貢獻度-日], 後台彙總存檔.商品 AS [結果-日], 
                            後台彙總存檔.商品 AS [貢獻度-周], 後台彙總存檔.商品 AS [結果-周], 後台彙總存檔.商品 AS [貢獻度-月], 後台彙總存檔.商品 AS [結果-月], 
                            後台彙總存檔.商品 AS [貢獻度-年], 後台彙總存檔.商品 AS [結果-年], SUM(CAST(後台彙總存檔.排序 AS money)) AS [貢獻度-日1], 
                            SUM(CAST(後台彙總存檔.排序 AS money)) AS [結果-日1], SUM(CAST(後台彙總存檔.排序 AS money)) AS [貢獻度-周1], 
                            SUM(CAST(後台彙總存檔.排序 AS money)) AS [結果-周1], SUM(CAST(後台彙總存檔.排序 AS money)) AS [貢獻度-月1], 
                            SUM(CAST(後台彙總存檔.排序 AS money)) AS [結果-月1], SUM(CAST(後台彙總存檔.貢獻額 AS money)) AS [貢獻度-年1], 
                            SUM(CAST(後台彙總存檔.排序 AS money)) AS [結果-年1]
                FROM        後台彙總存檔 LEFT OUTER JOIN
                            後台商客基本資料表 ON 後台彙總存檔.帳號 = 後台商客基本資料表.帳號 AND 
                            後台彙總存檔.商品 = 後台商客基本資料表.商品
                WHERE      (後台彙總存檔.週日月 LIKE '天') AND (後台彙總存檔.開始日期 BETWEEN '" .$PA. "' AND '" .$PA1. "') " .$PA2. "
                GROUP BY    後台彙總存檔.商品, 後台彙總存檔.系統
                ORDER BY    項次";
	return $sql;
}
?>