| Server IP : 104.21.37.246 / Your IP : 104.23.243.32 [ Web Server : Apache System : Linux cpanel01wh.bkk1.cloud.z.com 2.6.32-954.3.5.lve1.4.59.el6.x86_64 #1 SMP Thu Dec 6 05:11:00 EST 2018 x86_64 User : cp648411 ( 1354) PHP Version : 7.2.34 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home2/cp648411/public_html/simded.com/class2/ |
Upload File : |
<?php
class Util extends Connect
{
public function l($th,$ch)
{
if($_SESSION["lang"] == 'ch')
{
return $ch;
}
else
{
return $th;
}
}
/*public function l($th,$ch,$en)
{
if($_SESSION["lang"] == 'ch')
{
return $ch;
}
else if($_SESSION["lang"] == 'en')
{
return $en;
}
else
{
return $th;
}
}*/
public function day_m_th($var)//in:2012-06-03 05:24:40 //out:03 มิถุนายน 2555 05:24:40
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$month_thai = array('1'=>"มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
for($i=1;$i<=12;$i++)
{
if($date[1] == $i)
{
$m = $month_thai[$i];
}
}
$y = $date[0] + 543;
$txt = $date[2]." ".$m." ".$y ." " . $txt_date[1];
return $txt;
}
public function day_m_th_2($var)//in:2012-06-03 05:24:40 //out:03 มิถุนายน 2555
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$month_thai = array('1'=>"มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
for($i=1;$i<=12;$i++)
{
if($date[1] == $i)
{
$m = $month_thai[$i];
}
}
$y = $date[0] + 543;
$txt = $date[2]." ".$m." ".$y;
return $txt;
}
public function day_m_th_re($var)//in:2012-06-03 05:24:40 //out:03 มิ.ย. 2555 05:24:40
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$month_thai = array('1'=>"ม.ค.","ก.พ","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
for($i=1;$i<=12;$i++)
{
if($date[1] == $i)
{
$m = $month_thai[$i];
}
}
$y = $date[0] + 543;
$txt = $date[2]." ".$m." ".$y ." " . $txt_date[1];
return $txt;
}
public function day_m_th_re2($var)//in:2012-06-03 05:24:40 //out:03 มิ.ย. 2555
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$month_thai = array('1'=>"ม.ค.","ก.พ","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
for($i=1;$i<=12;$i++)
{
if($date[1] == $i)
{
$m = $month_thai[$i];
}
}
$y = $date[0] + 543;
$txt = $date[2]." ".$m." ".$y;
return $txt;
}
public function day_th_re($var)//in:2012-06-03 //out:03 มิ.ย. 2555
{
$date = explode("-",$var);
$month_thai = array('1'=>"ม.ค.","ก.พ","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
for($i=1;$i<=12;$i++)
{
if($date[1] == $i)
{
$m = $month_thai[$i];
}
}
$y = $date[0] + 543;
$txt = $date[2]." ".$m." ".$y ." " . $txt_date[1];
return $txt;
}
public function day_num($var)//in:2012-06-03 05:24:40 //out: 03.06.2012
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$txt = $date[2].".".$date[1].".".$date[0];
return $txt;
}
public function day_num2($var)//in:2012-06-03 05:24:40 //out: 03/06/2012
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$txt = $date[2]."/".$date[1]."/".$date[0];
return $txt;
}
public function day_num2_th($var)//in:2012-06-03 05:24:40 //out: 03/06/2012
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$y=$date[0]+543;
$txt = $date[2]."/".$date[1]."/".$y;
return $txt;
}
public function day_num3($var)//in:2012-06-03 //out: 03/06/2012
{
$date = explode("-",$var);
$txt = $date[2]."/".$date[1]."/".$date[0];
return $txt;
}
public function day_num3_db($var)//in:03/06/2012 //out:2012-06-03
{
$date = explode("/",$var);
$txt = $date[2]."-".$date[1]."-".$date[0];
return $txt;
}
public function day_num3_th($var)//in:2012-06-03 //out: 03/06/2012
{
$date = explode("-",$var);
$y=$date[0]+543;
$txt = $date[2]."/".$date[1]."/".$y;
return $txt;
}
public function day_num4($var)//in:2012-06-03 05:24:40 //out: 2012-06-03
{
$txt_date = explode(" ",$var);
return $txt_date[0];
}
public function sub_str($var,$num)
{
$var = strip_tags($var);
$num_var = strlen($var);
$txt = $var;
if($num_var > $num)
{
$txt = iconv_substr($var,0,$num,'UTF-8');
$txt = $txt . "...";
}
return $txt;
}
public function sub_str_2($var,$num)
{
$var = strip_tags($var);
$num_var = strlen($var);
$txt = $var;
if($num_var > $num)
{
$txt = iconv_substr($var,0,$num,'UTF-8');
}
return $txt;
}
public function sub_str3($var,$num)
{
$var = strip_tags($var);
$num_var = strlen($var);
$txt = $var;
if($num_var > $num)
{
$txt = iconv_substr($var,0,$num,'UTF-8');
if($num_var <= $num){$txt = $txt . "...";}
}
return $txt;
}
public function m_th_re($var)//in:06 //out:มิ.ย
{
//$month_thai = array('1'=>"มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
$month_thai = array('1'=>"ม.ค.","ก.พ","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
for($i=1;$i<=12;$i++)
{
if($var == $i)
{
$m = $month_thai[$i];
}
}
return $m;
}
public function time_h_s($var)//in:2012-06-03 05:24:40 //out: 05:24
{
$txt_date = explode(" ",$var);
$time = explode(":",$txt_date[1]);
$h_s = $time[0].':'.$time[1];
return $h_s;
}
public function day_dm_ti($var)//in :2017-07-27 16:24:10 //out: 27/07 16:24
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$time = explode(":",$txt_date[1]);
$h_s = $time[0].':'.$time[1];
$txt = $date[2]."/".$date[1] .' '. $h_s;
return $txt;
}
public function day_dmy_ti($var)//in :2017-07-27 16:24:10 //out: 27 07 60 / 16:24
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$time = explode(":",$txt_date[1]);
$h_s = $time[0].':'.$time[1];
$y = $date[0] + 543;
$txt = $date[2]." ".$date[1] ." ".substr($y, 2, 2) .' / '. $h_s;
return $txt;
}
public function timedmy_th($var)//in :2017-07-27 16:24:10 //out: 27 07 60 / 16:24
{
$txt_date = explode(" ",$var);
$date = explode("-",$txt_date[0]);
$time = $txt_date[1];
$y = $date[0] + 543;
$month_thai = array('1'=>"ม.ค.","ก.พ","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
for($i=1;$i<=12;$i++)
{
if($date[1] == $i)
{
$m = $month_thai[$i];
}
}
$txt = $time .' '. $date[2]." ". $m ." ".$y;
return $txt;
}
public function day_Ymd($var)//in :08/01/2017 //out: 2017-08-01
{
$date = explode("/",$var);
$txt = $date[2]. '-' .$date[1] . '-' .$date[0];
return $txt;
}
public function day_Ymd2($var)//in :08-01-2017 //out: 2017-08-01
{
$date = explode("-",$var);
$txt = $date[2]. '-' .$date[1] . '-' .$date[0];
return $txt;
}
public function day_Ymdtime($var)//in :08/01/2017 13:57:58 //out: 2017-08-01 13:57:58
{
$date2 = explode(" ",$var);
$date = explode("/",$date2[0]);
$txt = $date[2]. '-' .$date[1] . '-' .$date[0] .' '. $date2[1];
return $txt;
}
public function review_star_m($sumreview)
{
$sumreview = (int)$sumreview;
$review = 5;
for($i=1;$i<=$sumreview;$i++)
{
$txt = $txt . ' <img src="../images/icon_star1.png" width="16" height="16">';
}
$review = $review - $sumreview;
for($i=1;$i<=$review;$i++)
{
$txt2 = $txt2 . ' <img src="../images/icon_star2.png" width="16" height="16">';
}
$text = $txt.$txt2;
return $text;
}
public function review_star($sumreview)
{
$sumreview = (int)$sumreview;
$review = 5;
for($i=1;$i<=$sumreview;$i++)
{
$txt = $txt . ' <img src="../../control/images/icon_star1.png" width="16" height="16">';
}
$review = $review - $sumreview;
for($i=1;$i<=$review;$i++)
{
$txt2 = $txt2 . ' <img src="../../control/images/icon_star2.png" width="16" height="16">';
}
$text = $txt.$txt2;
return $text;
}
public function reviews_countscore($id,$score)
{
$this->setconnect();
$sql = "SELECT COUNT(id) AS idnum FROM reviews WHERE id_shop = '".$id."' AND score = '".$score."'";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$count = $row['idnum'];
return $count;
}
public function reviews_score($id)
{
$this->setconnect();
$sql = "SELECT SUM(score) AS sumreview FROM reviews WHERE id_shop = '".$id."' ";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$sumreview = $row['sumreview'];
$sql = "SELECT COUNT(id) AS idnum FROM reviews WHERE id_shop = '".$id."' ";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$totalscore = $row['idnum']*5;
//$score = ($sumreview * 5)/$totalscore;
$score = $sumreview/$row['idnum'];
return $score;
}
public function reviews_countpeople($id,$score)
{
$this->setconnect();
$sql = "SELECT COUNT(score) AS countscore FROM reviews WHERE id_shop = '".$id."' AND score = '".$score."'";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$countscore = $row['countscore'];
$sql = "SELECT COUNT(id) AS totalscore FROM reviews WHERE id_shop = '".$id."' ";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$totalscore = $row['totalscore'];
$percent = ($countscore * 100)/$totalscore;
return $percent;
}
public function viewber_count($id)
{
$this->setconnect();
$sql = "SELECT * FROM phonenumber WHERE id = '".$id."'";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$score = $row['view']+$row['view_mobile'];
return $score;
}
public function view_professor($id)
{
$this->setconnect();
$sql = "SELECT * FROM professor WHERE id = '".$id."'";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$score = $row['view']+1;
$sql2 = "UPDATE professor SET view = '".$score."' WHERE id = '".$id."'" ;
$result2 = mysqli_query($this->setconnect(), $sql2);
return $score;
}
public function view_teller($id)
{
$this->setconnect();
$sql = "SELECT * FROM leavenumber WHERE id = '".$id."'";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$score = $row['view']+1;
$sql2 = "UPDATE leavenumber SET view = '".$score."' WHERE id = '".$id."'" ;
$result2 = mysqli_query($this->setconnect(), $sql2);
return $score;
}
public function reply_teller($id)
{
$this->setconnect();
$sql = "SELECT * FROM leavenumber WHERE id = '".$id."'";
//$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$score = $row['reply']+1;
$sql2 = "UPDATE leavenumber SET reply = '".$score."' WHERE id = '".$id."'" ;
$result2 = mysqli_query($this->setconnect(), $sql2);
return $score;
}
public function countber($id)
{
$this->setconnect();
$sql = "SELECT COUNT(id) AS countber FROM phonenumber WHERE id_shop = '".$id."'";
// $result = mysql_query($sql) or die('Query failed: ' . mysql_error());
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
$text = $row['countber'];
return $text;
}
public function DateDiff($strDate1,$strDate2)
{
return (strtotime($strDate2) - strtotime($strDate1))/ ( 60 * 60 * 24 ); // 1 day = 60*60*24
}
public function TimeDiff($strTime1,$strTime2)
{
return (strtotime($strTime2) - strtotime($strTime1))/ ( 60 * 60 ); // 1 Hour = 60*60
}
public function DateTimeDiff($strDateTime1,$strDateTime2)
{
return (strtotime($strDateTime2) - strtotime($strDateTime1))/ ( 60 * 60 ); // 1 Hour = 60*60
}
public function ck_expired_shop($id)
{
$this->setconnect();
$sql = "SELECT * FROM shop WHERE id = '".$id."'";
//$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
/*if( date("Y-m-d") > $row['package_expired'])
{
$urlshop = '../shop/'.$row['codeshop'];
}
else
{
if($row['urldomain'] == ''){$urlshop = '../shop/'.$row['codeshop'];}
else{ $urlshop = $row['urldomain']; }
}*/
if($row['urldomain'] == ''){$urlshop = '../shop/'.$row['codeshop'];}
else{ $urlshop = $row['urldomain']; }
return $urlshop;
}
public function BK_ck_expired_shop($id)
{
$this->setconnect();
$sql = "SELECT * FROM shop WHERE id = '".$id."'";
$result = mysqli_query($this->setconnect(), $sql);
$row = mysqli_fetch_assoc($result);
if( date("Y-m-d") > $row['package_expired'])
{
$urlshop = '../../shop/'.$row['codeshop'];
}
else
{
if($row['urldomain'] == ''){$urlshop = '../../shop/'.$row['codeshop'];}
else{ $urlshop = $row['urldomain']; }
}
return $urlshop;
}
}
?>