<?php
class Viewdata extends Connect
{
			public function view($param)//$param = ตัวแปร array
			{

				$varibles = array_keys($param);
				$table = @$param['table'];
				$where = @$param['where'];
				$order = @$param['order'];
				$limit = @$param['limit'];
				$count = @$param['count'];
				$txt_where = "";
				$txt_order = "";
				$txt_limit = "";
				$txt_count = "*";
				if($where)
				{
					$txt_where = "WHERE " . $where;
				}
				if($order)
				{
					$txt_order = $order;
				}
				if($limit)
				{
					$txt_limit = "LIMIT ".$limit;
				}
				if($count)
				{
					$txt_count = $count;
				}
				$sql = "SELECT $txt_count FROM $table $txt_where $txt_order $txt_limit";



				return $sql;

			}
			public function q($query)
			{
				$result = mysqli_query($this->setconnect(),$query);
				@$row = mysqli_fetch_assoc($result);
				return $row;
			}
			public function q_re($query)
			{
				$result = mysqli_query($this->setconnect(),$query);
				return $result;
			}
			public function q_ro($result)
			{
				$row = mysqli_fetch_assoc($result);
				return $row;
			}
			public function q_nr($result)
			{
				$row = mysqli_num_rows($result);
				return $row;
			}
			public function phonenumber($var)//in:1234567891  //out:  123-456-7891
			{
				$phone = substr($var,0,3).'-'. substr($var,3,3).'-'. substr($var,6,4);
				return $phone;
			}
			public function banknumber($var)//in:1234567891  //out:  123-xxx-xxx-1
			{
				$phone = substr($var,0,3).'-xxx-xxx-'. substr($var,8,9);
				return $phone;
			}
			public function banknumberShow($var)//in:1234567891  //out:  123-xxx-xxx-1
			{
				$phone = substr($var,0,3).'-'.substr($var,3,3).'-'.substr($var,6,3).'-'. substr($var,8,9);
				return $phone;
			}

			function page_news1($page_number,$respons_pages){
				$url='';$get='';
						$data =  '<ul class="pagination justify-content-end mb-0">';
				if($respons_pages >= 7)
				{
					$n = $page_number-1;
						if($n < 0){$n = 0;}
						$data .= '<li class="page-item';
				if($page_number == 0){$s='disabled'; }
						$data .= $s.'">
						<a href="'.$url.'?page_number=0'.$get.'" class="page-link"
							<i class="fas fa-angle-double-left"></i>
							</a>
							<span class="sr-only">First</span>
						</li>';
					}
						$data .= '<li class="page-item ';
						if($page_number == 0){ $s2 = 'disabled';}
						$pp = $page_number-1;
						$data .= $s2.'"> <a href="'.$url.'?page_number='.$pp.$get.'" class="page-link"
									<i class="fas fa-angle-left"></i>
								</a>
								<span class="sr-only">Previous</span>
							</li>';
				if($respons_pages >= 7)
					{
						$p_end = $respons_pages - 3;
						if($page_number > 3 && $page_number <  $p_end)
						{
							$lop_p = $page_number+3;
							$start_p = $page_number-3;
						}elseif($page_number >=  $p_end ){
							$lop_p = $respons_pages-0;
							$start_p = $p_end-3;
						}
						else{

							if($page_number < 4){
								$start_p = 0;
								$lop_p = 7;

							}else{
								$start_p = $page_number-3;
								$lop_p = $page_number+3;
							}
						}
					}else{
						$lop_p = $respons_pages - 1;
						$start_p = 0;
					}

					for($a=$start_p;$a<=$lop_p;++$a)
					{
					$b = $a + 1 ;

						$data .='<li class="page-item';
						if($page_number == $a){$s3='active';}
						$data .=$a.$get.'" class="page-link">'.$b.'
								<span class="sr-only">page</span>
							</a>
						</li>';

						}
						if($respons_pages >= 7)
						{
							$s4='';
							$p = $page_number+1;
							if($p >= $respons_pages){$p = $respons_pages;}
							$data .= '<li class="page-item';
							if($page_number == $respons_pages){$s4='disabled';}
							$pp2 =$page_number+1;
							$data .= $s4.$get.'" class="page-link"> <a href="'.$url.'?page_number='.$pp2.$get.
							'" class="page-link">
									<i class="fas fa-angle-right"></i>
									<span class="sr-only">Next</span>
								</a>
							</li>';


						}
						if($respons_pages > 0){
							$data .= '<li class="page-item';
							if($page_number == $respons_pages){$s5='disabled';}
							$data .= '"> <a href="'.$url.'?page_number='. $respons_pages.$get.
							' class="page-link">
								<i class="fas fa-angle-double-right"></i>
								<span class="sr-only">Last</span>
							</a>
						</li>';
					}
					$data .= '</ul>';
				}

}
?>