PHP~~分析資料輸入欄位，並轉成 SQL 查詢字句

function parse_shop_string($shops) {
	if(empty($shops))
		return "";
/*
分離 單店 與 區間 表示。
s1 = 單店
s2 = 區間

ex: shops = "000,003-005, 010 020, 230-240 301"

s1 = Array ( [0] => 000 [1] => 010 [2] => 020 [3] => 301 )
s2 = Array ( [0] => BW_003_005_END [1] => BW_230_240_END [2] => )

query_string = "(_TABLE.shop = '000' or _TABLE.shop = '010' or _TABLE.shop = '020' or _TABLE.shop = '301' or _TABLE.shop between '003' and '005' or _TABLE.shop between '230' and '240')";

*/
	$s = preg_replace("/[a-z']/i", "", $s);
	 /*移除非預期字元，即英文字母及單引號(single quote)*/

	$s1 = preg_split("/(\s|,)+/",preg_replace("/(\d+)-(\d+)/", "", $shops));
	$s2 = preg_split("/\s+/",preg_replace("/(\d+(\s|,)+)|(\d+$)|(,+)/" ,"",
		 preg_replace("/(\d+)-(\d+)/", "BW_\$1_\$2_END ", $shops)));

	$query_string_s1 = "";
	$shop = current($s1);
	do {
		if(!empty($shop)) {
			if(empty($query_string_s1))
				$query_string_s1 = "_TABLE.shop = '". $shop ."'";
			else
				$query_string_s1 = $query_string_s1 . " or _TABLE.shop = '{$shop}'";
		}
	} while($shop = next($s1));

	$query_string_s2 = "";
	$shop = current($s2);
	do {
		if(!empty($shop)) {
			if(empty($query_string_s2))
				$query_string_s2 = "_TABLE.shop ".
					preg_replace("/BW_(\d+)_(\d+)_END/","between '\$1' and '\$2' ",$shop);
			else
				$query_string_s2 = $query_string_s2 . " or _TABLE.shop ".
					preg_replace("/BW_(\d+)_(\d+)_END/","between '\$1' and '\$2' ",$shop);
		}
	} while($shop = next($s2));

	if(empty($query_string_s1))
		$query_string = $query_string_s2;
	elseif(empty($query_string_s2))
		$query_string = $query_string_s1;
	else
		$query_string = $query_string_s1 ." or " . $query_string_s2;

	return ("(". $query_string .")");
}


$grade_date = "2006-02-20";
$args['shop_query_string'] = parse_shop_string($_POST['shops']);

$products_stock_query_string = " and ". preg_replace("/_TABLE.shop /", "product_stock.shop ", $args['shop_query_string']);

$sql_query_string = "select product_stock.* from product_stock where grade_date='{$grade_date}' {$products_stock_query_string}";