adverts.php

  		  <table class="table table-sm"style="width:100%;">
		  <thead>
		    <?php
		    $company=$_REQUEST['user'];
		    $dbh = Db::db_connect();
		    $vacancies= ApiData::getData('getAdverts', $company);		   
		    $clicks= ApiData::getData('getAdverts', $company);
		   if($vacancies=='error found' and $clicks=='error found')
		    {
		       echo'<div class="card col-12 justify-content-center">
			  <div class="card-body">An error has occured Please cleck your connection and refresh page
			  </div>
			  </div>
			 ';
		    }else{ 
		     ?>
		   <tr>
		      <th scope="col"></th>					
			<th scope="col"colspan="4"style="text-align:right;">  
			<a href="make_pdf.php?user=<?php echo $_REQUEST['user'];?>" target="_blank"  class="btn btn-sm btn-primary me-1">Advert Clicks</a>		
			<div class="btn-group pull-right">
				  <button type="button" class="btn btn-info">Action</button>
				  <button type="button" class="btn btn-info dropdown-toggle" data-toggle="dropdown">
				    <span class="caret"></span>
				    <span class="sr-only">Toggle Dropdown</span>
				  </button>
				  <ul class="dropdown-menu" role="menu" id="export-menu">
				    <li id="export-to-excel"><a href="#">Export to excel</a></li>
				    <li id="export-to-csv"><a href="#">Export to csv</a></li>
				  </ul>
			</div>
			<form action="export_data.php" method="post" id="export-form">
				<input type="hidden" value='' id='hidden-type' name='ExportType'/>
				<input type="hidden" value='<?php echo $_REQUEST['user'];?>' id='user' name='user'/>
			</form>
			
			</th>
		    </tr>
		  
		     <tr>
		      <th scope="col"></th>					
			<th scope="col"></th>					
			<th scope="col"></th>
			<th scope="col"></th>
			<th scope="col"style="text-align:center">  
			</th>
		    </tr>
		    <tr>
			<th scope="col">Vacancy Ref</th>					
			<th scope="col">Job Title</th>					
			<th scope="col"style="text-align:center">Salary</th>
			<th scope="col">ExpiryDate</th>
			<th scope="col"style="text-align:center">Views</th>
		    </tr>
		  </thead>
		  <tbody>
		    <tr>
		    <?php
		    /*
		    $company=$_REQUEST['user'];
		    $dbh = Db::db_connect();
		    $vacancies= ApiData::getData('getAdverts', $company);		   
		    $clicks= ApiData::getData('getAdverts', $company);
		   if($vacancies=='error found' and $clicks=='error found')
		    {
		       echo'<div class="card justify-content-center">
			  <div class="card-body">An error has occured Please cleck your connection
			  </div>
			  </div>
			 ';
		
		    }else{
		    */
		     for($x = 0; $x < count($vacancies); $x++){
			$clicks= Clicks::getClicks2($dbh,$vacancies[$x]->vacancy_ref);
			     ?>
			      <td><?php echo $vacancies[$x]->vacancy_ref; ?> </td>
			      <td><?php echo $vacancies[$x]->job_title;  ?></td>
			      <td align="center">
			     <?php 
				$min=substr($vacancies[$x]->salary_min,0,1)=='R' ? substr($vacancies[$x]->salary_min,1,20):$vacancies[$x]->salary_min;
				$max=substr($vacancies[$x]->salary_max,0,1)=='R' ? substr($vacancies[$x]->salary_max,1,20):$vacancies[$x]->salary_max;
			       if(!empty($min)){$min='R'.trim($min);} 
			       if(!empty($max)){$max='R'.trim($max);} 
			       echo $min.' -  '.$max; 
			       ?>
			     </td>
			      <td><?php echo $vacancies[$x]->expiry_date;  ?></td>
			      <td style="text-align:center">
					<?php echo $clicks['clicks'];?>
			      </td>
			    </tr>
			   <?php 
			} 
		    }
		   ?>
		  </tbody>
		</table>