MAINHACK

Viewing / Editing File: recent_renewal.php

<?php include'header.php';

function dateDiffInDays($date1,$date2) {
  
    // Calculating the difference in timestamps
    $diff = strtotime($date2) - strtotime($date1);

// 1 day = 24 hours
    // 24 * 60 * 60 = 86400 seconds
    return abs(round($diff / 86400));
}
?>

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">Recent Renewals (30 days)</h4>
						
					</div>
					<div class="row">
						<div class="col-md-12">
							<div class="card">
							
								<div class="card-body">
									<div class="table-responsive">
					            <table id="basic-datatables" class="display table table-striped table-hover">
                                        <thead>
                                            <th>ID</th>
                                           <th>Renewal Date</th>
                                            <th>Project Date</th>
                                            <th>Days Remaining</th>
                                          <th>Project Type</th>
                                           <th>Title</th>
                                           <th>Contact Person</th>
                                          <th>Final Cost</th>
                                           <th>Note</th>
                                            <th>Action</th>
                                            
                                            
                                        </thead>
<tbody>
		
<?php
$count=1;
$sr='project';
$date=date('Y-m-d');
//$stmt =$show->readwithdata($sr,'status','Project Confirmed');
$s1="select *,DATEDIFF(renewal_date,'$date') as dif from project group by project.project_id";//echo $s1;
$stmt=$con->prepare($s1);
$stmt->execute();
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $id=$row['id'];   
//echo $row['dif'];
if($row['dif']<=30){ //echo $row['dif'];echo "<br>";

// echo $usr_p;

echo "<tr>
							    <td>$count</td>
								<td>".date('d-m-Y',strtotime($row['renewal_date']))."</td>
								<td>".date('d-m-Y',strtotime($row['date']))."</td>
								<td><span style='color:blue;font-weight:600'>".$row['dif']." Days</span></td>
								<td>".$row['project_type']."</td>
								<td>".$row['title']."</td>
								<td>".$row['customer_id']."<br>".$row['customer_name']."<br>".$row['customer_phone']."</td>
								<td>".$row['final_cost']."</td>
								<td><span style='color:red'>".$row['note']."</span></td>
							
								";
								?>
		
                                <?php echo "<td>
								<a href='show_project.php?id=".$row['project_id']."&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-info'>Show</a>
								<a href='edit_project.php?id=".$row['project_id']."&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-default'>Edit</a>
								<a href='delete.php?id=$id&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-danger' onclick='return send();'>Delete</a>
								</td>
								</tr>";

++$count;
 }
        }
}

?>							
</tbody>
                                    </table>

</div>
				
									</div>
								</div>
							</div>
						</div>

</div>
				</div>
			</div>
			
		</div>

$('#multi-filter-select').DataTable( {
				"pageLength": 5,
				initComplete: function () {
					this.api().columns().every( function () {
						var column = this;
						var select = $('<select class="form-control"><option value=""></option></select>')
						.appendTo( $(column.footer()).empty() )
						.on( 'change', function () {
							var val = $.fn.dataTable.util.escapeRegex(
								$(this).val()
								);

column
							.search( val ? '^'+val+'$' : '', true, false )
							.draw();
						} );

column.data().unique().sort().each( function ( d, j ) {
							select.append( '<option value="'+d+'">'+d+'</option>' )
						} );
					} );
				}
			});

// Add Row
			$('#add-row').DataTable({
				"pageLength": 5,
			});

var action = '<td> <div class="form-button-action"> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-primary btn-lg" data-original-title="Edit Task"> <i class="la la-edit"></i> </button> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove"> <i class="la la-times"></i> </button> </div> </td>';

$('#addRowButton').click(function() {
				$('#add-row').dataTable().fnAddData([
					$("#addName").val(),
					$("#addPosition").val(),
					$("#addOffice").val(),
					action
					]);
				$('#addRowModal').modal('hide');

});
		});
	</script>
<?php include'footer.php';?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: recent_renewal.php

Server Info

System Features

User Info