Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure	[ DIR ]	drwxr-xr-x
admin	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
assets-new	[ DIR ]	drwxr-xr-x
font	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
model	[ DIR ]	drwxr-xr-x
1Head.php	6.88 KB	-rw-r--r--
2HeadMenu.php	11.58 KB	-rw-r--r--
3Footer.php	6.72 KB	-rw-r--r--
4End.php	581 B	-rw-r--r--
BannerCoverAll.php	1.83 KB	-rw-r--r--
aboutus.php	2.18 KB	-rw-r--r--
contact-us.php	2.49 KB	-rw-r--r--
content.php	4.77 KB	-rw-r--r--
detail.php	699 B	-rw-r--r--
detail_RecommendedProjects.php	5.09 KB	-rw-r--r--
detail_about.php	1.8 KB	-rw-r--r--
detail_banner.php	3.66 KB	-rw-r--r--
detail_consult.php	2.43 KB	-rw-r--r--
detail_news.php	5.29 KB	-rw-r--r--
detail_ourteam.php	2.96 KB	-rw-r--r--
detail_product.php	9.33 KB	-rw-r--r--
index.php	156 B	-rwxr-xr-x
news.php	3.68 KB	-rw-r--r--
our-services.php	3.84 KB	-rw-r--r--
package.json	14.21 KB	-rw-r--r--
product-detail.php	7.41 KB	-rw-r--r--
project-detail.php	17.72 KB	-rw-r--r--
project.php	3.68 KB	-rw-r--r--
properties.php	17.79 KB	-rw-r--r--
properties_detail.php	2.16 KB	-rw-r--r--
search.php	9.99 KB	-rw-r--r--

Code Editor : properties.php

<?PHP
include '1Head.php';
include '2HeadMenu.php';

$CategoryContent_ID = 57;
$CategoryContentLanguage_ID = 114;
$ContentID = 339;
include 'BannerCoverAll.php';

$StatusNearby = "";
$CHK_SQL_ProductTag_Nearby  = "";

if (empty($_GET['keyword'])) {
	$keyword  = 0;
	$CHK_SQL_keyword = "";
} else {
	$keyword = trim($_GET['keyword']);
	$CHK_SQL_keyword = "AND product.Product_Name LIKE '%$keyword%'";
}

if (empty($_GET['Category1'])) {
	$Category1  = 0;
	$CHK_SQL_Category1 = "";
} else {
	$Category1 = trim($_GET['Category1']);
	$CHK_SQL_Category1 = "AND product.ProductCategory_ID = $Category1";
}

if (empty($_GET['Category2'])) {
	$Category2  = 0;
	$CHK_SQL_Category2 = "WHERE product_tag.Product_ID = 0";
	$CHK_SQL_ProductTag = "";
} else {
	$Category2 = trim($_GET['Category2']);
	$CHK_SQL_Category2 = "WHERE product_tag.ProductCategory2_ID = $Category2";
}

// 0 = 0 ทั้งหมด
// 1 = น้ายกว่า 1,000,000
// 2 = 1,000,001 - 3,000,000
// 3 = 3,000,001 - 5,000,000
// 4 = 5,000,001 - 10,000,000
// 5 = 10,000,001 - 30,000,000
// 6 = 30,000,001 - 50,000,000
// 7 = มากกว่า 50,000,0001

if (empty($_GET['CategoryPrice'])) {
	$CategoryPrice  = 0;
	$CHK_SQL_CategoryPrice = "";
} else {
	$CategoryPrice = trim($_GET['CategoryPrice']);

if ($CategoryPrice == 0) {
		$CHK_SQL_CategoryPrice = "";
	} else if ($CategoryPrice == 1) {
		$CHK_SQL_CategoryPrice = "AND product.Product_Price BETWEEN 0 AND 1000000";
	} else if ($CategoryPrice == 2) {
		$CHK_SQL_CategoryPrice = "AND product.Product_Price BETWEEN 1000001 AND 3000000";
	} else if ($CategoryPrice == 3) {
		$CHK_SQL_CategoryPrice = "AND product.Product_Price BETWEEN 3000001 AND 5000000";
	} else if ($CategoryPrice == 4) {
		$CHK_SQL_CategoryPrice = "AND product.Product_Price BETWEEN 5000001 AND 10000000";
	} else if ($CategoryPrice == 5) {
		$CHK_SQL_CategoryPrice = "AND product.Product_Price BETWEEN 10000001 AND 30000000";
	} else if ($CategoryPrice == 6) {
		$CHK_SQL_CategoryPrice = "AND product.Product_Price BETWEEN 30000001 AND 50000000";
	} else {
		$CHK_SQL_CategoryPrice = "AND product.Product_Price >= 50000001";
	}
}

if (empty($_GET['CategoryNearby160'])) {
	$CategoryNearby160  = 0;
	$CHK_SQL_Nearby160 = "";
} else {
	$CategoryNearby160 = trim($_GET['CategoryNearby160']);
	$CHK_SQL_Nearby160 = "AND product_tag.ProductCategory2_ID = $CategoryNearby160";
	$StatusNearby = "Nearby";
}

if (empty($_GET['CategoryNearby161'])) {
	$CategoryNearby161  = 0;
	$CHK_SQL_Nearby161 = "";
} else {
	$CategoryNearby161 = trim($_GET['CategoryNearby161']);
	$CHK_SQL_Nearby161 = "OR product_tag.ProductCategory2_ID = $CategoryNearby161";
	$StatusNearby = "Nearby";
}

if (empty($_GET['CategoryNearby162'])) {
	$CategoryNearby162  = 0;
	$CHK_SQL_Nearby162 = "";
} else {
	$CategoryNearby162 = trim($_GET['CategoryNearby162']);
	$CHK_SQL_Nearby162 = "AND product_tag.ProductCategory2_ID = $CategoryNearby162";
	$StatusNearby = "Nearby";
}

<?PHP

if ($StatusNearby == "Nearby") {

$sql_CHK_ProductTag = "
						SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, 
						product_category2.ProductCategory2_Name, product_tag.ProductTag_Date, 
						product_tag.ProductTag_Time , product_category2.ProductCategory_ID , 
						product_tag.Product_ID
						FROM product_tag 
						INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
						INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
						WHERE product_tag.StatusProductTag_ID = 1
						$CHK_SQL_Nearby160
						$CHK_SQL_Nearby161
						$CHK_SQL_Nearby162
						GROUP BY product_tag.Product_ID
						";
						$objQuery_CHK_ProductTag = $objConnect->query($sql_CHK_ProductTag);

while ($objResult_CHK_ProductTag = mysqli_fetch_array($objQuery_CHK_ProductTag)) {
							$CHKTag_ProductID = $objResult_CHK_ProductTag["Product_ID"];

$CHK_SQL_ProductTag_Nearby = " AND product.Product_ID = $CHKTag_ProductID";

$SQL_Product = "		
							SELECT product.Product_ID, product.ProductCategory_ID, product_category.ProductCategory_Name,
							product.ProductCategory2_ID, product.ProductCategory3_ID, product.StatusProduct_ID,product.Member_ID,
							status_product.StatusProduct_Name, member.Member_ID, member.Member_NameEN, member.Position_ID, 
							product.Product_Name, product.Product_Num, product.Product_Unit, product.Product_Price, 
							product.Product_Detail, product.Product_PVScore, product.Product_Img, product.Product_Time,
							product.Product_Date, product.Product_Visitors, product.Product_Detail2, product.Product_Detail3, 
							product.Product_Color , product.Product_Sort
							FROM product
							INNER JOIN product_category ON product.ProductCategory_ID = product_category.ProductCategory_ID
							INNER JOIN status_product ON product.StatusProduct_ID = status_product.StatusProduct_ID
							INNER JOIN member ON product.Member_ID = member.Member_ID
							WHERE product.StatusProduct_ID = 1 
							$CHK_SQL_keyword
							$CHK_SQL_Category1
							$CHK_SQL_ProductTag
							$CHK_SQL_CategoryPrice
							$CHK_SQL_ProductTag_Nearby
							ORDER BY product.Product_Sort 
							";
							$objQuery_Product = $objConnect->query($SQL_Product);
							$CountProduct = mysqli_num_rows($objQuery_Product);

while ($objResult_Categorys = mysqli_fetch_array($objQuery_Product)) {

$ProductID = $objResult_Categorys["Product_ID"];
								$ProductName = $objResult_Categorys["Product_Name"];
								$ProductImg = $objResult_Categorys["Product_Img"];
								$ProductPrice = $objResult_Categorys["Product_Price"];
								$ProductCategoryID = $objResult_Categorys["ProductCategory_ID"];
								$ProductCategoryName = $objResult_Categorys["ProductCategory_Name"];
								$ProductDetail = $objResult_Categorys["Product_Detail"];
								$ProductDetail2 = $objResult_Categorys["Product_Detail2"];
								$ProductDetail3 = $objResult_Categorys["Product_Detail3"];
								$ProductUnit = $objResult_Categorys["Product_Unit"];
								$ProductDate = $objResult_Categorys["Product_Date"];
								$date = date_create($ProductDate);
								$New_ProductDate = date_format($date, "F d , Y");
								$date_srt = date_format($date, "Y-m-d");
								$Newformat_ProductPrice = number_format($ProductPrice);

$ProductName = urldecode($ProductName);
								$ProductDetail = urldecode($ProductDetail);
								$ProductDetail2 = urldecode($ProductDetail2);
								$ProductDetail3 = urldecode($ProductDetail3);

$xmasnow = date("Y-m-d");
								$xmasnow = date_create($xmasnow);

$diff = $date->diff($xmasnow);
								$CountDiffDate = intval($diff->format("%d"));
								$int_CountDiffDate = intval($CountDiffDate);

$sql_string_producttag2 = "
								SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, product_category2.ProductCategory2_Name, product_tag.ProductTag_Date, product_tag.ProductTag_Time , product_category2.ProductCategory_ID
								FROM product_tag 
								INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
								INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
								WHERE product_tag.Product_ID = $ProductID AND product_category2.ProductCategory_ID = 39
								";
								$objQuery_producttag2 = $objConnect->query($sql_string_producttag2);

$sql_string_producttag = "
								SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, product_category2.ProductCategory2_Name, product_tag.ProductTag_Date, product_tag.ProductTag_Time , product_category2.ProductCategory_ID
								FROM product_tag 
								INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
								INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
								WHERE product_tag.Product_ID = $ProductID AND product_category2.ProductCategory_ID = 40
								";
								$objQuery_producttag = $objConnect->query($sql_string_producttag);

include 'properties_detail.php';
							}

}

} else { //CHK Nearby

if (empty($_GET['Category2'])) { //0

$SQL_Product = "		
							SELECT product.Product_ID, product.ProductCategory_ID, product_category.ProductCategory_Name,
							product.ProductCategory2_ID, product.ProductCategory3_ID, product.StatusProduct_ID,product.Member_ID,
							status_product.StatusProduct_Name, member.Member_ID, member.Member_NameEN, member.Position_ID, 
							product.Product_Name, product.Product_Num, product.Product_Unit, product.Product_Price, 
							product.Product_Detail, product.Product_PVScore, product.Product_Img, product.Product_Time,
							product.Product_Date, product.Product_Visitors, product.Product_Detail2, product.Product_Detail3, 
							product.Product_Color , product.Product_Sort
							FROM product
							INNER JOIN product_category ON product.ProductCategory_ID = product_category.ProductCategory_ID
							INNER JOIN status_product ON product.StatusProduct_ID = status_product.StatusProduct_ID
							INNER JOIN member ON product.Member_ID = member.Member_ID
							WHERE product.StatusProduct_ID = 1 
							$CHK_SQL_keyword
							$CHK_SQL_Category1
							$CHK_SQL_CategoryPrice
							ORDER BY product.Product_Sort 
							";
							$objQuery_Product = $objConnect->query($SQL_Product);
							$CountProduct = mysqli_num_rows($objQuery_Product);

while ($objResult_Categorys = mysqli_fetch_array($objQuery_Product)) {

$ProductName = urldecode($ProductName);
								$ProductDetail = urldecode($ProductDetail);
								$ProductDetail2 = urldecode($ProductDetail2);
								$ProductDetail3 = urldecode($ProductDetail3);

// $xmasDay = new DateTime(''."$date_srt".' + 5 day');
								// $xmasDay->format('Y-m-d');

$xmasnow = date("Y-m-d");
								$xmasnow = date_create($xmasnow);

$diff = $date->diff($xmasnow);
								$CountDiffDate = intval($diff->format("%d"));
								$int_CountDiffDate = intval($CountDiffDate);

$sql_string_producttag2 = "
							SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, product_category2.ProductCategory2_Name, product_tag.ProductTag_Date, product_tag.ProductTag_Time , product_category2.ProductCategory_ID
							FROM product_tag 
							INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
							INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
							WHERE product_tag.Product_ID = $ProductID AND product_category2.ProductCategory_ID = 39
							";
								$objQuery_producttag2 = $objConnect->query($sql_string_producttag2);

include 'properties_detail.php';
							}
						} else {

$sql_CHK_ProductTag = "
							SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, 
							product_category2.ProductCategory2_Name, product_tag.ProductTag_Date, 
							product_tag.ProductTag_Time , product_category2.ProductCategory_ID , 
							product_tag.Product_ID
							FROM product_tag 
							INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
							INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
							$CHK_SQL_Category2 
							";
							$objQuery_CHK_ProductTag = $objConnect->query($sql_CHK_ProductTag);

while ($objResult_CHK_ProductTag = mysqli_fetch_array($objQuery_CHK_ProductTag)) {
								$CHKTag_ProductID = $objResult_CHK_ProductTag["Product_ID"];

if (empty($_GET['Category2'])) {
									$CHK_SQL_ProductTag = "";
								} else {
									$CHK_SQL_ProductTag = " AND product.Product_ID = $CHKTag_ProductID";
								}

$SQL_Product = "		
								SELECT product.Product_ID, product.ProductCategory_ID, product_category.ProductCategory_Name,
								product.ProductCategory2_ID, product.ProductCategory3_ID, product.StatusProduct_ID,product.Member_ID,
								status_product.StatusProduct_Name, member.Member_ID, member.Member_NameEN, member.Position_ID, 
								product.Product_Name, product.Product_Num, product.Product_Unit, product.Product_Price, 
								product.Product_Detail, product.Product_PVScore, product.Product_Img, product.Product_Time,
								product.Product_Date, product.Product_Visitors, product.Product_Detail2, product.Product_Detail3, 
								product.Product_Color , product.Product_Sort
								FROM product
								INNER JOIN product_category ON product.ProductCategory_ID = product_category.ProductCategory_ID
								INNER JOIN status_product ON product.StatusProduct_ID = status_product.StatusProduct_ID
								INNER JOIN member ON product.Member_ID = member.Member_ID
								WHERE product.StatusProduct_ID = 1 
								$CHK_SQL_keyword
								$CHK_SQL_Category1
								$CHK_SQL_ProductTag
								$CHK_SQL_CategoryPrice
								ORDER BY product.Product_Sort 
								";
								$objQuery_Product = $objConnect->query($SQL_Product);
								$CountProduct = mysqli_num_rows($objQuery_Product);

while ($objResult_Categorys = mysqli_fetch_array($objQuery_Product)) {

$ProductID = $objResult_Categorys["Product_ID"];
									$ProductName = $objResult_Categorys["Product_Name"];
									$ProductImg = $objResult_Categorys["Product_Img"];
									$ProductPrice = $objResult_Categorys["Product_Price"];
									$ProductCategoryID = $objResult_Categorys["ProductCategory_ID"];
									$ProductCategoryName = $objResult_Categorys["ProductCategory_Name"];
									$ProductDetail = $objResult_Categorys["Product_Detail"];
									$ProductDetail2 = $objResult_Categorys["Product_Detail2"];
									$ProductDetail3 = $objResult_Categorys["Product_Detail3"];
									$ProductUnit = $objResult_Categorys["Product_Unit"];
									$ProductDate = $objResult_Categorys["Product_Date"];
									$date = date_create($ProductDate);
									$New_ProductDate = date_format($date, "F d , Y");
									$date_srt = date_format($date, "Y-m-d");
									$Newformat_ProductPrice = number_format($ProductPrice);

$ProductName = urldecode($ProductName);
									$ProductDetail = urldecode($ProductDetail);
									$ProductDetail2 = urldecode($ProductDetail2);
									$ProductDetail3 = urldecode($ProductDetail3);

// $xmasDay = new DateTime(''."$date_srt".' + 5 day');
									// $xmasDay->format('Y-m-d');

$xmasnow = date("Y-m-d");
									$xmasnow = date_create($xmasnow);

$diff = $date->diff($xmasnow);
									$CountDiffDate = intval($diff->format("%d"));
									$int_CountDiffDate = intval($CountDiffDate);

$sql_string_producttag2 = "
							SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, product_category2.ProductCategory2_Name, product_tag.ProductTag_Date, product_tag.ProductTag_Time , product_category2.ProductCategory_ID
							FROM product_tag 
							INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
							INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
							WHERE product_tag.Product_ID = $ProductID AND product_category2.ProductCategory_ID = 39
							";
									$objQuery_producttag2 = $objConnect->query($sql_string_producttag2);

$sql_string_producttag = "
						SELECT product_tag.ProductTag_ID, product_tag.ProductCategory2_ID, product_category2.ProductCategory2_Name, product_tag.ProductTag_Date, product_tag.ProductTag_Time , product_category2.ProductCategory_ID
						FROM product_tag 
						INNER JOIN product_category2 ON product_tag.ProductCategory2_ID = product_category2.ProductCategory2_ID
						INNER JOIN product_category ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
						WHERE product_tag.Product_ID = $ProductID AND product_category2.ProductCategory_ID = 40
						";
									$objQuery_producttag = $objConnect->query($sql_string_producttag);

include 'properties_detail.php';
								}
							}
						}
					} //CHK Nearby
					?>

</div>
			</div>
		</div>
	</div>
</div>

<?PHP

include '3Footer.php';
include '4End.php';
?>

${this.title}

Code Editor : properties.php