Viewing file:  salesteam.php (10.82 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include 'index_Include.php';
$_SESSION['page'] = 'salesteam.php';
if (isset($_GET[salesteam_id])&&trim($_GET[salesteam_id])) {
$salesteam_id = trim($_GET[salesteam_id]);
$salesteam_SL = " SELECT * FROM salesteam WHERE salesteam_id = '$salesteam_id'";
$salesteam_QR = mysqli_query($con,$salesteam_SL);
$salesteam = mysqli_fetch_array($salesteam_QR);
$salesteam_name = $salesteam[salesteam_name];
?>
<!DOCTYPE html>
<html lang='en'>
<head>
<title> <? echo $salesteam[salesteam_name]; ?> </title>
<meta name="keywords" content=" <? echo $salesteam[salesteam_name]; ?>">
<meta name="description" content=" <? echo $salesteam[salesteam_detail]; ?> ">
<meta name="author" content=" <? echo $salesteam[salesteam_name]; ?>">
<? include 'index_head.php'; ?>
<meta property="og:image" content="http://<? echo $fixed[fixed_website]; ?>/Files/salesteam_photo/<? echo $salesteam[salesteam_photo]; ?>" />
<meta property="og:title" content="<? echo $salesteam[salesteam_name]; ?>" />
<meta property="og:description"content="<? echo $salesteam[salesteam_detail]; ?>"/>
</head>
<body>
<? include 'index_navbar.php'; ?>
<div style="background-color: #f0f0f0;">
<div class="container between20">
<div class="row">
<div class="col-md-12 text-center">
<span class="page-topic color1 ">
<? echo $salesteam[salesteam_name]; ?>
</span>
</div>
</div>
</div>
</div>
<div class="container between20">
<div class="row">
<div class="col-md-8">
<div class="row margintop15">
<div class="col-md-12">
<?
if (isset($salesteam[salesteam_photo])&&trim($salesteam[salesteam_photo])) {
?>
<img class="img-responsive" src="Files/salesteam_photo/<?php echo $salesteam[salesteam_photo]; ?>" >
<?
}
else{
?>
<div class="img50 bg1" >
<div style="position: absolute;top: 45%;text-align: center; -webkit-text-stroke: 0.5px white;color: white;font-size: 40px;width: 100%;">
<?if($_SESSION[Language]== "Thailand"){ echo $salesteam[salesteam_name]; } else if($salesteam[salesteam_name_eng]!=''){ echo $salesteam[salesteam_name_eng]; }else{ echo $salesteam[salesteam_name];} ?>
</div>
</div>
<?
}
?>
<h2 class="hide2 color1 marginbottom4">
<? echo $salesteam[salesteam_name]; ?>
</h2>
<h3>
<? echo $salesteam[salesteam_detail]; ?>
</h3>
<h3 class="text-black">
<? $salesteam_tel= str_replace("-","",$salesteam[salesteam_tel]); ?>
<a target="_blank" href="tel:<? echo $salesteam_tel; ?>">
<span class="glyphicon glyphicon-earphone"></span> <? echo $salesteam[salesteam_tel]; ?>
</a>
</h3>
</div>
</div>
<div class="row">
<div class="col-md-12 Review">
<?php echo $salesteam[salesteam_review]; ?>
</div>
</div>
<?
$portfolio_SL = " SELECT * FROM portfolio WHERE salesteam_id = '$salesteam[salesteam_id]' ORDER BY RAND() ";
$portfolio_QR = mysqli_query($con,$portfolio_SL);
$portfolio_ROW = mysqli_num_rows($portfolio_QR);
if ($portfolio_ROW > 0 ) {
?>
<div class="margintop15">
<div class="row">
<div class="col-md-12">
<p class="page-topic">
ผลงาน
</p>
</div>
</div>
<?
$Ac_i=1;
while ($portfolio = mysqli_fetch_array($portfolio_QR)) {
if ($Ac_i==1) {
?>
<div class="row">
<?
}
?>
<div class="col-md-8">
<? include 'index_panel_portfolio.php'; ?>
</div>
<?
if ($Ac_i==1) {
$Ac_i=0;
?>
</div>
<?
}
$Ac_i++;
}
if ($Ac_i!=1) {
echo "</div>";
}
?>
</div>
<?
}
?>
<?
$product_SL = " SELECT * FROM product WHERE salesteam_id = '$salesteam[salesteam_id]' ORDER BY RAND() ";
$product_QR = mysqli_query($con,$product_SL);
$product_ROW = mysqli_num_rows($product_QR);
if ($product_ROW > 0 ) {
?>
<div class="margintop15">
<div class="row">
<div class="col-md-12">
<p class="page-topic">
อสังหาริมทรัพย์
</p>
</div>
</div>
<?
$Ac_i=1;
while ($product = mysqli_fetch_array($product_QR)) {
if ($Ac_i==1) {
?>
<div class="row">
<?
}
?>
<div class="col-md-4">
<? include 'index_panel_product.php'; ?>
</div>
<?
if ($Ac_i==3) {
$Ac_i=0;
?>
</div>
<?
}
$Ac_i++;
}
if ($Ac_i!=1) {
echo "</div>";
}
?>
</div>
<?
}
?>
</div>
<!-- 9 -->
<div class="col-md-4">
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-md-12 paddingbottom15">
<div class="col-md-12 ">
<p class="font1 size20 margintop15">
สนใจสอบถามรายละเอียด
</p>
<?
$social_SL = " SELECT * FROM social ORDER BY social_sort ASC ";
$social_QR = mysqli_query($con,$social_SL);
while ($social = mysqli_fetch_array($social_QR)) {
?>
<p class="hide1" title="<?php echo $social[social_name]; ?>">
<?
if (isset($social[social_link])&&$social[social_link]!='') {
if ($social[social_type]=='Tel') {
?>
<a style="text-align: left;" class="padding5 size17 text-black" href="tel:<?php echo $social[social_link]; ?>" target="_blank">
<?
if (isset($social[social_photo])&&$social[social_photo]!='') {
?>
<img style="max-height:28px;" src="Files/social_photo/<?php echo $social[social_photo]; ?>" />
<?
}
else{
echo $social[social_type]." : ";
}
?>
<?php echo $social[social_name]; ?>
</a>
<?
}
else{
?>
<a style="text-align: left;" class="padding5 size17 text-black" href="http://<?php echo $social[social_link]; ?>" target="_blank">
<?
if (isset($social[social_photo])&&$social[social_photo]!='') {
?>
<img style="max-height:28px;" src="Files/social_photo/<?php echo $social[social_photo]; ?>" />
<?
}
else{
echo $social[social_type]." : ";
}
?>
<?php echo $social[social_name]; ?>
</a>
<?
}
}
else{
?>
<a style="text-align: left;" class="padding5 size17 text-black">
<?
if (isset($social[social_photo])&&$social[social_photo]!='') {
?>
<img style="max-height:28px;" src="Files/social_photo/<?php echo $social[social_photo]; ?>" />
<?
}
else{
echo $social[social_type]." : ";
}
?>
<?php echo $social[social_name]; ?>
</a>
<?
}
?>
</p>
<?
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="row hidden-sm hidden-xs" >
<div class="col-md-4">
<ul class="breadcrumb no-radius" style="margin-bottom: 0px;">
<li><a href="index.php">หน้าแรก</a></li>
<li><a href="salesteam.php"> ทีมงานขาย </a></li>
<li class="active">
<?php echo $salesteam_name; ?>
</li>
</ul>
</div>
</div>
</div>
<!-- container -->
<? include 'index_footer.php'; ?>
</body>
</html>
<?
}
else{
$Q = 1;
$Row = "SELECT * FROM salesteam ";
$RowQuery = mysqli_query($con,$Row);
$Num_Rows = mysqli_num_rows($RowQuery);
$Per_page = 20;
$page = $_GET["page"];
if(!$_GET["page"]){
$page=1;
}
$Prev_page = $page-1;
$Next_page = $page+1;
$page_Start = (($Per_page*$page)-$Per_page);
if($Num_Rows<=$Per_page){
$Num_pages =1;
}
else if(($Num_Rows % $Per_page)==0){
$Num_pages =($Num_Rows/$Per_page) ;
}
else{
$Num_pages =($Num_Rows/$Per_page)+1;
$Num_pages = (int)$Num_pages;
}
$i=$page_Start+1;
$salesteam_SL = $Row . " ORDER BY salesteam_sort asc LIMIT $page_Start , $Per_page ";
$salesteam_QR = mysqli_query($con,$salesteam_SL);
?>
<!DOCTYPE html>
<html lang='en'>
<head>
<title> ทีมงานขาย | <? echo $fixed[fixed_topic]; ?> | <? echo $fixed[fixed_website]; ?> </title>
<meta name="description" content="<? echo $fixed[fixed_company]; ?> <? echo $fixed[fixed_topic]; ?>">
<meta name="keywords" content="ทีมงานขาย - <? echo $fixed[fixed_topic]; ?>">
<meta name="author" content="<? echo $fixed[fixed_topic]; ?>">
<? include 'index_head.php'; ?>
</head>
<body>
<? include 'index_navbar.php'; ?>
<div style="background-color: #f0f0f0;">
<div class="container between20">
<div class="row">
<div class="col-md-12 text-center">
<span class="page-topic color1 ">
ทีมงานขาย
<?
if ($Num_Rows=='0') { echo " (ไม่พบข้อมูล)"; }
else{
?>
<span class="size16 text-muted">
<? echo number_format($Num_Rows); ?> รายการ
</span>
<?
}
?>
</span>
</div>
</div>
</div>
</div>
<div class="container between20">
<?
$Ac_i = 1;
while ($salesteam = mysqli_fetch_array($salesteam_QR)) {
if ($Ac_i==1) {
?>
<div class="row">
<?php
}
?>
<div class="col-lg-1"></div>
<div class="col-lg-10">
<? include 'index_panel_salesteam.php'; ?>
</div>
<div class="col-lg-1"></div>
<?php
if ($Ac_i==1) {
$Ac_i=0;
?>
</div>
<?
}
$Ac_i++;
}
if ($Ac_i!=1) {
echo "</div>";
}
?>
<div class="row">
<div class="col-md-12 text-center">
<? include 'index_pagenum.php'; ?>
</div>
</div>
<div class="row hidden-sm hidden-xs margintop30" >
<div class="col-md-4">
<ul class="breadcrumb no-radius" style="margin-bottom: 0px;">
<li><a href="index.php">หน้าแรก</a></li>
<li>
<a onclick="goBack();" href="#">
กลับ
</a>
</li>
<li class="active"> ทีมงานขาย </li>
</ul>
</div>
</div>
</div>
<? include 'index_footer.php'; ?>
</body>
</html>
<?
}
?>
|