EVOLUTION-NINJA

Edit File: reminders.php

<?php echo view('includes/header');?>

<h1> Reminders </h1>

</section>

<table class="table table-striped table-hover reminder_table" style="">
            <thead>
              <tr class="default" >                  
                <th class="col-xs-2">Project</th>
                <th class="col-xs-1">Site</th>
                <th class="col-xs-1">Customer</th>
                <th class="col-xs-1">Mobile</th>
                <th class="col-xs-3">Dates</th>	
                <th class="col-xs-3">Amount</th>	
              </tr>
            </thead>

</table>

<?php
	$date  = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
	$today = $date->format('Y-m-d');

$date  = new DateTime($today);
	$date->sub(new DateInterval('P3D'));
	$three_days_prior = $date->format('Y-m-d');
?>

$(document).ready(function(){
	GetAllReminders();
	var today             = '<?php echo $today ?>';

//-----------------------Example code------------------------------------------------------------------------------------------------------//
	var todayTimeStamp    = +new Date("2017-05-29"); // Unix timestamp in milliseconds
	var threeDayTimeStamp = 1000 * 60 * 60 * 72; // Milliseconds in a day
	var diff              = todayTimeStamp - threeDayTimeStamp;
	var yesterdayDate     = new Date(diff);
	var three_days_prior  = yesterdayDate.getFullYear() + '-' + ("0"+(yesterdayDate.getMonth() + 1)).slice(-2) + '-' + yesterdayDate.getDate();
	//------------------------------------------------------------------------------------------------------------------------------------------//
	
//	GetAllReminders();

function GetAllReminders()
	{
		$.ajax({

type : 'get',
                url  : '<?php echo site_url("get-all-reminders")?>',
                                          
                  success:function(response){
                  response=jQuery.parseJSON(response);
                  console.log(response);

if(response.result==1)
                    {	
                    	var sl = 1;
                    	var table_content = "";

$.each(response.reminders,function(key,val){
			
                    	 	table_content += '<tr>';
	                		table_content += '<td>'+val.project_name+'</td>';
	                		table_content += '<td>'+val.site_number+'</td>';
							table_content += '<td>'+val.customer_name+'</td>';
							table_content += '<td>'+val.mobile+'</td>';
							table_content += '<td>';
							
							if(val.agmnt == "NOTAVAILABLE")
							{
								if(val.sales_agreement_due_date > "0000-00-00")
								{

var date  = new Date(val.sales_agreement_due_date);
			                        var Month = new Array("01", "02", "03","04", "05", "06", "07", "08", "09", "10", "11", "12");
			                        var day   = ("0" + date.getDate()).slice(-2);
			                        var month = date.getMonth();
			                        var year  = date.getFullYear();
			                        var sales_agreement_due_date = day+"-"+Month[month]+"-"+year;

var startDay = new Date(val.sales_agreement_due_date);
									var endDay   = new Date(today);
									var millisecondsPerDay = 1000 * 60 * 60 * 24;

var millisBetween = startDay.getTime() - endDay.getTime();
									var days = millisBetween / millisecondsPerDay;

// Round down.
									var num_of_days = Math.floor(days);
									if(num_of_days <= 3)
									{
										table_content += '<p style="background-color:red;color:white;width: 223px;">Agreement due date :'+sales_agreement_due_date+'</p>';
									}
								}	
							}
							if(val.instl == "NOTAVAILABLE")
							{
								if(val.installment_due_date > "0000-00-00")
								{
									
									var date  = new Date(val.installment_due_date);
			                        var Month = new Array("01", "02", "03","04", "05", "06", "07", "08", "09", "10", "11", "12");		                      
			                        var day   = ("0" + date.getDate()).slice(-2);
			                        var month = date.getMonth();
			                        var year  = date.getFullYear();
			                        var installment_due_date = day+"-"+Month[month]+"-"+year;

table_content += '<p style="background-color:red;color:white;width: 223px;">Installment due date :'+installment_due_date+'</p>';
									
									
								}

}
							if(val.regn == "NOTAVAILABLE")

{
								if(val.reg_date_type == 'date')
								{
								if(val.registration_due_date > "0000-00-00")
								{
									
									var date  = new Date(val.registration_due_date);
			                        var Month = new Array("01", "02", "03","04", "05", "06", "07", "08", "09", "10", "11", "12");                      
			                        var day   = ("0" + date.getDate()).slice(-2);
			                        var month = date.getMonth();
			                        var year  = date.getFullYear();
			                        var registration_due_date = day+"-"+Month[month]+"-"+year;

var startDay = new Date(val.registration_due_date);
									var endDay   = new Date(today);
									var millisecondsPerDay = 1000 * 60 * 60 * 24;

var millisBetween = startDay.getTime() - endDay.getTime();
									var days = millisBetween / millisecondsPerDay;

// Round down.
									var num_of_days = Math.floor(days);
					                if(num_of_days <= 6 )
					                { 
										table_content += '<p style="background-color:red;color:white;width: 223px;">Registration due date :'+registration_due_date+'</p>';
									}
								}
							}
								else if(val.reg_date_type == 'unspecified')
								{
									
									var date  = new Date(val.registration_due_date);
			                        var Month = new Array("01", "02", "03","04", "05", "06", "07", "08", "09", "10", "11", "12");                      
			                        var day   = ("0" + date.getDate()).slice(-2);
			                        var month = date.getMonth();
			                        var year  = date.getFullYear();
			                        var registration_due_date = day+"-"+Month[month]+"-"+year;

//table_content += '<p style="background-color:red;color:white;width: 223px;">Registration due date :'+val.reg_date_type+'</p>';
								
									
								}
							}
							
						
							
                    	 	table_content += '</td>';

//--------------Amount------------------------------------------------------------------------------------------------------//

table_content += '<td>';

if(val.agmnt == "NOTAVAILABLE")
							{

if(val.sales_agreement_due_date != "0000-00-00")
								{  	
										var sales_agreement_due_amount = val.sales_agreement_due_amount;
					                    x=sales_agreement_due_amount.toString();
					                    var lastThree = x.substring(x.length-3);
					                    var otherNumbers = x.substring(0,x.length-3);
					                    if(otherNumbers != '')
					                        lastThree = ',' + lastThree;
					                    var sales_agreement_due_amount_res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
										//---------------------------date------------------------------//
					                    var date  = new Date(val.sales_agreement_due_date);
				                        var Month = new Array("01", "02", "03","04", "05", "06", "07", "08", "09", "10", "11", "12");
				                        var day   = ("0" + date.getDate()).slice(-2);
				                        var month = date.getMonth();
				                        var year  = date.getFullYear();
				                        var sales_agreement_due_date = day+"-"+Month[month]+"-"+year;

var startDay = new Date(val.sales_agreement_due_date);
										var endDay   = new Date(today);
										var millisecondsPerDay = 1000 * 60 * 60 * 24;

var millisBetween = startDay.getTime() - endDay.getTime();
										var days = millisBetween / millisecondsPerDay;

// Round down.
										var num_of_days = Math.floor(days);
									if(num_of_days <= 3)
									{
										table_content += '<p style="background-color:red;color:white;width: 223px;">Due amount :'+sales_agreement_due_amount_res+'</p>';
									}
								}
							}

if(val.instl == "NOTAVAILABLE")
							{
								if(val.installment_due_date != "0000-00-00")
								{
									
									/*var date  = new Date(val.installment_due_date);
			                        var Month = new Array("01", "02", "03","04", "05", "06", "07", "08", "09", "10", "11", "12");		                      
			                         var day   = ("0" + date.getDate()).slice(-2);
			                        var month = date.getMonth();
			                        var year  = date.getFullYear();
			                        var installment_due_date = day+"-"+Month[month]+"-"+year;*/

var installment_due_amount = val.installment_due_amount;
				                    x=installment_due_amount.toString();
				                    var lastThree = x.substring(x.length-3);
				                    var otherNumbers = x.substring(0,x.length-3);
				                    if(otherNumbers != '')
				                        lastThree = ',' + lastThree;
				                    var installment_due_amount_res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
									table_content += '<p style="background-color:red;color:white;width: 223px;">Due amount :'+installment_due_amount_res+'</p>';
									
								}
							}

if(val.regn == "NOTAVAILABLE")
							{
								if(val.reg_date_type == 'date')
								{
									if(val.registration_due_date != "0000-00-00")
									{
										var registration_due_amount = val.registration_due_amount;
					                    x=registration_due_amount.toString();
					                    var lastThree = x.substring(x.length-3);
					                    var otherNumbers = x.substring(0,x.length-3);
					                    if(otherNumbers != '')
					                        lastThree = ',' + lastThree;
					                    var registration_due_amount_res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
										
					                    //------------------------------date----------------------------------//
										
						                var date  = new Date(val.registration_due_date);
				                        var Month = new Array("01", "02", "03","04", "05", "06", "07", "08", "09", "10", "11", "12");                      
				                        var day   = ("0" + date.getDate()).slice(-2);
				                        var month = date.getMonth();
				                        var year  = date.getFullYear();
				                        var registration_due_date = day+"-"+Month[month]+"-"+year;

var startDay = new Date(val.registration_due_date);
										var endDay   = new Date(today);
										var millisecondsPerDay = 1000 * 60 * 60 * 24;

var millisBetween = startDay.getTime() - endDay.getTime();
										var days = millisBetween / millisecondsPerDay;

// Round down.
										var num_of_days = Math.floor(days);
					                	if(num_of_days <= 6 )
					                	{
											table_content += '<p style="background-color:red;color:white;width: 223px;">Due amount :'+registration_due_amount_res+'</p>';
										}
									}
								}

else if(val.reg_date_type == 'unspecified')
								{
									
									/*var date  = new Date(val.registration_due_date);
			                        var Month = new Array("01", "02", "03","04", "05", "06", "07", "08", "09", "10", "11", "12");                      
			                        var day   = ("0" + date.getDate()).slice(-2);
			                        var month = date.getMonth();
			                        var year  = date.getFullYear();
			                        var registration_due_date = day+"-"+Month[month]+"-"+year;*/

var registration_due_amount = val.registration_due_amount;
				                     x=registration_due_amount.toString();
				                    var lastThree = x.substring(x.length-3);
				                    var otherNumbers = x.substring(0,x.length-3);
				                    if(otherNumbers != '')
				                        lastThree = ',' + lastThree;
				                    var registration_due_amount_res = otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + lastThree; 
									//table_content += '<p style="background-color:red;color:white;width: 223px;">Due amount :'+registration_due_amount_res+'</p>';
								
									
								}
							}

table_content += '</td>';
                    	 	table_content += '</tr>';

sl++;
                    	});

$("#table_body").html(table_content);

$("tr").each(function(){
						    if($(this).find("td:last").is(":empty"))
						        $(this).hide();
						});
                    }                  
                }
                
         });
	}

});
</script>
	
<?php echo view('includes/footer');?>