.-.-.-.-.-

<?php
$title= "All Task";
include 'header.php';
include_once('lib/ps_pagination.php');
$param = '';
$param .= isset($_GET['status']) && $_GET['status']!='' ? "&amp;status=".$_GET['status'] : '';
$param .= isset($_GET['login_id']) && $_GET['login_id']!='' ? "&amp;login_id=".$_GET['login_id'] : '';
$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['page_title']) && $_GET['page_title']!='' ? "&amp;page_title=".$_GET['page_title'] : '';
$query = "SELECT t1.*, t2.name as name, t2.login_id as login_id FROM campaign t1 INNER JOIN user t2 ON t1.create_by = t2.uid WHERE id !=0 ";
$query .= isset($_GET['status']) && $_GET['status']!='' ? " AND t1.status ='".$_GET['status']."'" : '';
$query .= isset($_GET['login_id']) && $_GET['login_id']!='' ? " AND login_id='".$_GET['login_id']."'" : '';
$query .= isset($_GET['from_date']) && $_GET['from_date']!='' && isset($_GET['to_date']) && $_GET['to_date']!='' ? " AND date(datetime) BETWEEN '".$_GET['from_date']."' AND '".$_GET['to_date']."')" : '';
$query .= isset($_GET['page_title']) && $_GET['page_title']!='' ? " AND page_title LIKE '%".$_GET['page_title']."%'" : '';

$query .= " ORDER BY datetime DESC ";
?>
    <h1>All Task</h1>
    <h3><a href="campaign_add.php">New Task</a></h3>
    
    <?php echo getMessage();?>
    <section >
        <form action="" method="get">
          <p>
              
              <select name="status">
                  <option value="" >All</option>
                  <option value="1" <?php echo isset($_GET['status']) && $_GET['status']==1 ? 'selected=""':'';?> >Active</option>
                  <option value="0" <?php echo isset($_GET['status']) && $_GET['status']==0 ? 'selected=""':'';?> >Inactive</option>
              </select>
              <input style="float: left;" type="text" name="login_id" value="<?php if(isset($_GET['login_id'])){echo $_GET['login_id'];}?>" placeholder="Search by User Id" />
              <input type="text" name="from_date" value="<?php if(isset($_GET['from_date'])){echo $_GET['from_date'];}?>" class="datepicker" placeholder="From Date" />
              <input  type="text" name="to_date" value="<?php if(isset($_GET['to_date'])){echo $_GET['to_date'];}?>" class="datepicker" placeholder="To Date" />
              <input  type="text" name="page_title" value="<?php if(isset($_GET['page_title'])){echo $_GET['page_title'];}?>" placeholder="Search by page title" />
              <input type="submit" id="submit" value="Search">
          </p>
        </form>
    </section>
    <section >
        <form action="campaign_approve_model.php" method="post">
        <table style="width: 100%;">
          <thead>
            <tr>
                <th>Make Enable</th>
                <th>Make Disable</th>
              <th>S. No.</th>
              <th>Page title</th>
              <th>Page url</th>
              <th>User</th>
              <th>Page Description</th>
              <th>Date</th>
              <th>Status</th>
              <th>Action</th>
            </tr>
          </thead>
          <tbody>
            <?php 
            $pager = new PS_Pagination($connection, $query, 200, 5, $param);
            $pager->setDebug(true);
            $result = $pager->paginate();
            if($result){
                if(!isset($_GET['page'])){ $i=1; }else{ $i=(($_GET['page']-1)*200)+1; }
                while ($row = mysqli_fetch_object($result)){
            ?>
            <tr <?php if($i%2){echo "class='light'";}else{echo "class='dark'";}?>>
                <td><input type="checkbox" class="id_list" name="id_list[]" value="<?php echo $row->id;?>" <?php echo $row->status==1 ? 'disabled="disabled"':'';?> style="width: auto;" /></td>
                <td><input type="checkbox" class="id_list" name="id_list_disable[]" value="<?php echo $row->id;?>" <?php echo $row->status==0 ? 'disabled="disabled"':'';?> style="width: auto;" /></td>
               <td><?php echo $i;?></td>
              <td><?php echo $row->page_title;?></td>
              <td> <a href="<?php echo $row->page_url;?>" target="_blank"><?php echo $row->page_url;?></a> </td>
              <td><?php echo $row->name." ($row->login_id)";?></td>
              <td><?php echo $row->page_description;?></td>
              <td><?php echo date("d/m/Y", strtotime($row->datetime));?></td>
              <td>
                <?php echo $row->status==1 ? 'Active' : "Not active ".'<a href="campaign_delete.php?id='.$row->id.' " >Delete</a>'; ?>
              </td>
              <td><a href="campaign_edit.php?campaign_id=<?php echo $row->id?>" >Edit</a></td>
            </tr>
            <?php 
            $i++;}
            }?>
          </tbody>
        </table>
            <?php echo $pager->renderFullNav();?>
            <div class="row">
                <a href="javascript:;" onclick="$('.id_list').attr({'checked':true})">Select All</a>
                <input type="submit" name="submit" value="Approve Selected campaigns" class="btn btn-success" />
        </div>
            </form>
    </section>
   
<?php include 'footer.php';?>

/home2/wtmwscom/public_html/js/../mail/../admin/campaign_report.php