.-.-.-.-.-

<?php
$title= "Promotion History";
include 'header.php';
include_once('lib/ps_pagination.php');
$uid = $_SESSION['userid'];

$param = '';
$param .= isset($_GET['from_date']) && $_GET['from_date']!='' ? "&amp;from_date=".$_GET['from_date'] : '';
$param .= isset($_GET['to_date']) && $_GET['to_date']!='' ? "&amp;to_date=".$_GET['to_date'] : '';
$param .= isset($_GET['status']) && $_GET['status']!='' ? "&amp;status=".$_GET['status'] : '';
$query = "SELECT e1.id AS campaign_user_id, e1.uid as uid, e1.status as status, e1.datetime AS datetime, e2.page_title as page_title,"
        . " e2.page_url as page_url, e2.page_description as page_description FROM campaign_user e1 INNER JOIN campaign e2 ON e1.campaign_id = e2.id WHERE e1.uid = '$uid' ";
$query .= isset($_GET['from_date']) && $_GET['from_date']!='' && isset($_GET['to_date']) && $_GET['to_date']!='' ? " AND (date(e1.datetime) BETWEEN '".$_GET['from_date']."' AND '".$_GET['to_date']."')" : '';
$query .= isset($_GET['status']) && $_GET['status']!='' ? " AND e1.status LIKE '%".$_GET['status']."%'" : '';
?>
    <h1>All Promotion History</h1>
    <?php echo getMessage();?>
    <section id="comments">
        <form action="" method="get">
          <p>
              <input style="float: left;" type="text" name="from_date" value="<?php if(isset($_GET['from_date'])){echo $_GET['from_date'];}?>" class="datepicker" placeholder="From Date" />
              <input style="float: left;" type="text" name="to_date" value="<?php if(isset($_GET['to_date'])){echo $_GET['to_date'];}?>" class="datepicker" placeholder="To Date" />
              <select name="status" style="float: left;">
                  <option value="">Select</option>
                  <option value="0">Pending</option>
                  <option value="1">Viewed</option>
                  <option value="2">Skipped</option>
              </select>
              <input type="submit" id="submit" value="Search">
          </p>
        </form>
    </section>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>Page Title</th>
              <th>Date</th>
              <th>Status</th>
            </tr>
          </thead>
          <tbody>
            <?php 
            $pager = new PS_Pagination($link, $query, 50, 5, $param);
            $pager->setDebug(true);
            $result = $pager->paginate();
            if($result){
                if(!isset($_GET['page'])){ $i=1; }else{ $i=(($_GET['page']-1)*50)+1; }
                while ($row = mysqli_fetch_object($result)){
            ?>
            <tr <?php if($i%2){echo "class='light'";}else{echo "class='dark'";}?>>
              <td><?php echo $i;?></td>
              <td><?php echo $row->page_title;?></td>
              <td><?php echo date("d/m/Y", strtotime($row->datetime));?></td>
              <td>
               <?php if($row->status == 0) echo "Pending";elseif($row->status == 1) echo "Viewed";elseif($row->status == 2) echo "Skipped"; ?>
              </td>

            </tr>
            <?php 
            $i++;}
            }?>
          </tbody>
        </table>
            <?php echo $pager->renderFullNav();

?>
    </section>
    
<?php include 'footer.php';?>

/home2/wtmwscom/www/nbproject/../member/task_report.php