<!-- /.category -->
 <div class="container mt-5 mt-md-0 px-lg-5 px-3">
    <div class="row px-md-5 mb-3 ">
      <div class="col-md-12 px-md-2 d-flex justify-content-between align-baseline" >
          <div class="">
            <h2 class="pb-0 mb-0 border-kai-bottom-light fw-loungethbold">เบอร์ตองมงคล</h2>
            <!--<hr class="line1 my-1">-->
          </div>
          <a href="../home/search.php?set=triple" class="text-decoration-none text-kai-link">ดูเพิ่มเติม</a>
      </div>
    </div>
    <?php  ?>
<style media="screen">

</style>
    <div class="row px-md-5">
      <?php
      $search = 'status = "1" AND status_number = "1" AND ';
      $search .= '(phonenumber LIKE "%000%" OR phonenumber LIKE "%111%" OR phonenumber LIKE "%222%" OR phonenumber LIKE "%333%" OR phonenumber LIKE "%444%" OR phonenumber LIKE "%555%" OR phonenumber LIKE "%666%" OR phonenumber LIKE "%777%" OR phonenumber LIKE "%888%" OR phonenumber LIKE "%999%" )';
      $list_phl = array('table'=>'phonenumber','where'=>$search,'order'=> "ORDER BY id DESC LIMIT 20");
      $view_phl = $view_db->view($list_phl);
      $result_phl = $view_db->q_re($view_phl);
      /*
      echo "<pre>";
      print_r($view_phl);
      echo "</pre>";
      */
      while($row_phl = $view_db->q_ro($result_phl))
      {
        $arr_P3_all=array();
        $pass3_all_n2=array();
        $output='';
        $Fullscore_p=0;
        $TotalScore_plus=0;
        $TotalScore_delete=0;
        $percent_number=0;
        $phonenumber = $row_phl['phonenumber'];
        include('perl2.php');

        $Fullscore_p = 100 * count($pass3_all_n2);
        $percent_number = (($TotalScore_plus - abs($TotalScore_delete))*100)/$Fullscore_p;
    /*

        $total_read = '';

        $arrnum = $Phone_class->readingber($phonenumber);
        $Fullscore = 100 * count($arrnum);

        $arrnum_un = array_unique ($arrnum);

  		  foreach( $arrnum_un as $value )
  		  {
  				$list = array('table'=>'meaningnumber2','where'=>'number LIKE "%'.$value.'%"');
  				$view = $view_db->view($list);
  				$row = $view_db->q($view);

  				$total_read =  $total_read + $row['score'];
  				$detail = $detail . '<p style="">'.$row['detail'].'</p>';

  				$arr_score[$value] = $row['score'];
  		  }
  		  foreach( $arrnum as $value )
  		  {
  				$list_cs = array('table'=>'category_score','where'=>'number = "'.$value.'"');
  				$view_cs = $view_db->view($list_cs);
  				$row_cs = $view_db->q($view_cs);

  				$arr_cs['lucky'] =  $arr_cs['lucky'] + $row_cs['lucky'];
  				$arr_cs['work'] =  $arr_cs['work'] + $row_cs['work'];
  				$arr_cs['love'] =  $arr_cs['love'] + $row_cs['love'];
  				$arr_cs['money'] =  $arr_cs['money'] + $row_cs['money'];
  				$arr_cs['education'] =  $arr_cs['education'] + $row_cs['education'];
  				$arr_cs['health'] =  $arr_cs['health'] + $row_cs['health'];


  		  }
  			 $num_arrnum =  count($arrnum);

         $num_arrnum2 =  count($arrnum_un);

  			 $Fullscore_p = 100 * $num_arrnum2;
  			 $sum = ($total_read*100)/$Fullscore_p;

         $percent_number =  $sum;
*/
        $list_phln = array('table'=>'mobilenetwork','where'=>'id = "'.$row_phl['mobilenetwork'].'"','order'=> "ORDER BY id DESC LIMIT 0 , 1");
        $view_phln = $view_db->view($list_phln);
        $row_phln = $view_db->q($view_phln);

        $se2 = explode(',',$row_phl['category']);
        $list_phlc = array('table'=>'category','where'=>'id = "'.$se2[0].'"','order'=> "ORDER BY id DESC LIMIT 0 , 1");
        $view_phlc = $view_db->view($list_phlc);
        $row_phlc = $view_db->q($view_phlc);

        $list_phle = array('table'=>'element','where'=>'id = "'.$row_phl['element_id'].'"','order'=> "ORDER BY id DESC LIMIT 0 , 1");
        $view_phle = $view_db->view($list_phle);
        $row_phle = $view_db->q($view_phle);
        $cate_imgl='';
        $network_imgl='';

        $short_number2 = $Phone_class->catshort_number2('',$phonenumber);
        $short_number2_t = $Phone_class->catshort_number($short_number2,$phonenumber);

/*
        if($row_phlc['id']==7){$cate_imgl='icon-01-love.png';}
        if($row_phlc['id']==8){$cate_imgl='icon-02-office.png';}
        if($row_phlc['id']==10){$cate_imgl='icon-05-foster.png';}
        if($row_phlc['id']==11){$cate_imgl='icon-04-money.png';}
        if($row_phlc['id']==12){$cate_imgl='icon-03-family.png';}
        if($row_phlc['id']==13){$cate_imgl='icon-07-chat.png';}
        if($row_phlc['id']==16){$cate_imgl='icon-06-health.png';}
        if($row_phlc['id']==17){$cate_imgl='icon-08-avoid.png';}
        */
        if($short_number2==7){$cate_imgl='icon-01-love.png';}
        if($short_number2==8){$cate_imgl='icon-02-office.png';}
        if($short_number2==10){$cate_imgl='icon-05-foster.png';}
        if($short_number2==11){$cate_imgl='icon-04-money.png';}
        if($short_number2==12){$cate_imgl='icon-03-family.png';}
        if($short_number2==13){$cate_imgl='icon-07-chat.png';}
        if($short_number2==16){$cate_imgl='icon-06-health.png';}
        if($short_number2==17){$cate_imgl='icon-08-avoid.png';}

        if($row_phl['mobilenetwork']==1){$network_imgl='0222- ais.png';}
        if($row_phl['mobilenetwork']==2){$network_imgl='01- ddd.png';}
        if($row_phl['mobilenetwork']==3){$network_imgl='03- true.png';}
        if($row_phl['mobilenetwork']==8){$network_imgl='05- yyyy.png';}
        $dpr2 = 0;
        $dpr2 = $percent_number*1.67;
        $dpr2 = 440 -$dpr2;
        ?>
      <div class="col-12 col-sm-6 col-md-6 col-lg-4 col-xxl-3 px-1 mb-3" onclick="location.href='../reading/detail.php?phonenumber=<?php echo $row_phl['phonenumber']; ?>'">
        <div class="border-kai2 px-3 py-2 text-center cursor-pointer">
          <h2 class="pb-1 mb-0 border-kai-bottom mb-2 pt-1" style="font-size: 31px;">
            <?php echo $Phone_class->phonenumber($row_phl['phonenumber']);?>
          </h2>

          <div class="row">
            <div class="col-3 p-0">
                <div class="container__progressbars" >
                  <div class="progressbar">
                    <svg class="progressbar__svg">
                      <circle cx="23" cy="26" r="27" class="progressbar__svg-circle circle-html shadow-html"
                      style="stroke-dashoffset: <?php echo $dpr2; ?>;"> </circle>
                    </svg>
                    <span class="progressbar__text shadow-html">
                      <!--<img src="../redbag/category/icon-01-love.png" alt="" class="w-100" >-->
                      <img src="../redbag/category/<?php echo $cate_imgl; ?>" alt="" class="w-100" >
                    </span>
                  </div>
                  <small class="progressbar_text2 fix-s" style="top: 9px"> <?php echo number_format($percent_number,2); ?>%</small>
                </div>
            </div>
            <div class="col-6 px-0">
              <div class="border-kai-bottom w-100">
                <!--<small class="small-kai"><?php echo $row_phlc['name']; ?></small>-->
                <label  style="<?php if(strlen($short_number2_t)>=51){echo 'font-size: 20px;padding-bottom: 2px;';} ?>">
                  <?php echo $short_number2_t; ?></label>

              </div>
              <div class="border-kai-bottom w-100">
                <img src="../redbag/mobilenetwork/<?php echo $network_imgl; ?>" alt="" height="33" >
              </div>
              <!--<small class="small-kai"><?php echo $row_phl['price']; ?>-</small>-->
              <label style="top: 5px;position: relative;"><?php echo $row_phl['price']; ?>-</small>

            </div>
            <div class="col-3 p-0 border-kai-left pe-2" >
              <div class="py-0 pe-1">
                <div class="border-kai-bottom w-100">
                  <label class="fix-l" >ผลรวม</label>
                  <h1 class="ps-2 p-0 m-0 fix-h1"><?php echo $row_phl['sum_number']; ?></h1>
                </div>
                <small class="fix-s">ธาตุ<?php echo $row_phle['name']; ?></small>
              </div>
            </div>
          </div>
        </div>
      </div>
      <?php } ?>



    </div>

</div>