EVOLUTION-NINJA

Edit File: region_wise_sales.php

<?php $this->load->view('includes/admin_header');?>

<h4>Folder</h4>

</div>

<li>

</li>

<li class=""><a href="<?php echo base_url('other-account');?>">Individual sales </a></li>

<li class=""><a href="<?php echo base_url('sales-pipeline-and-trend');?>"> Sales pipeline and trend </a></li>

<li class=""><a href="<?php echo base_url('industry-wise-sales');?>"> Industry wise sales </a></li>

<li class=""><a href="<?php echo base_url('region-wise-sales');?>"> Region wise sales </a></li>

<li class=""><a href="<?php echo base_url('employee-activity');?>"> Employee Activity </a></li>

</ul>

</div>

<h4>Region wise sales</h4>

</div>

<select theme="dark" width="220px" height="auto ! important" style="" placeholder="Select Your Favorite" data-search="true" id="region_wise" name="region_wise" class="data_filter">
				<option value=" ">Select</option>
				<?php foreach($get_all_roles_region as $value){ if($value->zone !=""){ ?>
					<option value="<?php echo $value->role_id; ?>"><?php echo $value->zone; ?></option>
				<?php } }?>
			</select>

</div>

</div>

</div>

<div>

<thead>

<th>Account Owner</th>

<th>Account Name</th>

<th>Sales Amount</th>

</tr>

</thead>

<tbody  id="filer_data">
											
											<?php $grand_total=0; foreach($region_wise_sales as $value){ ?>
											<tr>
												<td><?php echo $value->user_name; ?></td>
												<td><a href="<?php echo site_url("account-info/$value->account_id");?>">									<?php echo $value->account_name;?></a></td>
													
													<?php $grand_total=$grand_total + $value->amount; ?>

<td><?php echo $value->amount; ?></td>
											</tr>
											<?php } ?>

</tbody>

</table>

</div>

</div>

</div>

</div>

</div>

<label> Total Amount</label>

</div>

<input type="text" class="quot_number" id="grand_total" name="amount" value="<?php echo $grand_total; ?> " style="width:50%;border:none !important;border-bottom:1px solid #ddd !important" required="required"></input>

</div>

</div>

<a href="">&nbsp;Kaaryaka</a>

</div>

</a>

</div>

</body>

</html>

$(document).ready(function(){

var datatable;

var tbody = $('#table_body');

datatable = $('.table').DataTable({

});

});
  
</script>

$("#grand_total").val('');

var region_wise=$('#region_wise').val();

var from_date=$("#from_date").val();

var to_date=$("#to_date").val();

$.ajax({
			type:"POST",
			
			url:"<?php echo site_url('yaskawa/region_wise_filter'); ?>",
			
			data:{'region_wise':region_wise,'from_date':from_date,'to_date':to_date},

success : function(response){

var res=jQuery.parseJSON(response);

console.log(response);

var content='';

if(res.result==1)

{

var grand_total = 0;	
						$.each(res.date_result,function(idx,vx)

{

content+='<tr>';

content+='<td>'+vx.account_owner+'</td>';

content+='<td><a href="<?php echo site_url();?>/account-info/'+vx.account_id+'">'+vx.account_name+' '+vx.name_type+'</a></td>';

content+='<td>'+vx.amount+'</td>';

grand_total = parseInt(grand_total)+parseInt(vx.amount);

content+='</tr>';

$("#filer_data").html(content);

$("#grand_total").val(grand_total);

});

}

else if(res.result==0)

{

//alert("Date not found");

$("#filer_data").empty();

}

});
		
	});
</script>

$("#from_date").datepicker({

format: "dd-mm-yyyy",

}).on('changeDate', function(ev){

$('#from_date').datepicker('hide');

});

$("#to_date").datepicker({

format: "dd-mm-yyyy",

}).on('changeDate', function(ev){

$('#to_date').datepicker('hide');

});

});
</script>

$(document).on("change","#report_value",function(e)

{

var report_id = [];

var report_val = $('#report_value').val();

$(".move_reports:checked").each(function()

{

report_id.push($(this).attr('id'));

});

$.ajax({

type   : 'post',

url    : '<?php echo site_url("move-reports")?>',

data   : {"report_id":report_id,"report_val":report_val},

success:function(response){

response=jQuery.parseJSON(response);

console.log(response);

if(response.result==1)

{

alert("Reports Moved");

//location.reload();

}

else

{

alert("Reports did not moved");

}

});

</script>

function setLocally (el)

{

el.previousElementSibling.classList.toggle('yellow');

}

$(document).on("click",".report",function(){

var acc_report_id = $(this).attr('id');

$.ajax({

type   : 'post',

url    : '<?php echo site_url("acc-update-favorite-reports")?>',

data   : {"acc_report_id":acc_report_id},

success:function(response){

response=jQuery.parseJSON(response);

console.log(response);

if(response.result==1)

{

alert("Reports Added to Favorite List");

//location.reload();

}

else

{

alert("Reports already added to your favorite list");

}

});

</script>

$(document).ready(function()

{

$('#remove_records').click(function(){

var id=[];

$(".move_reports:checked").each(function(i) {

var acc_report_id = $(this).attr('id');

id.push(acc_report_id);

});

test(id);

});

function test(id)

{

$.ajax({

type:"POST",

url:'<?php echo site_url('yaskawa/acc_remove_records');?>',

data:{'report_ids':id},

success:function(response){

response=jQuery.parseJSON(response);

console.log(response);

if(response.result==1)

{

alert("Deleted Successfully");

location.reload();

}

else

{

alert("Something went wrong..Try again");

}

});

}

});

</script>

.hoverr:hover .addd {

display:block;

}

.addd{

display:none;

}

.add_more {

padding: 0px 7px !important;

font-size: 12px !important;

}

#block{display:none;padding-left:10px;}

.pd-7{

padding-right:7px !important;

padding-left:7px !important;

}

.pd-9{

padding:2px 9px !important;

}

</style>

$('#cbxShowHide').click(function(){

this.checked?$('#block').show():$('#block').hide();

});

</script>

$(function() {

$('#popup-datepic').datepicker({

//..

});

</script>

$('#calendar').datepicker({

});

!function ($) {

$(document).on("click","ul.nav li.parent > a > span.icon", function(){

$(this).find('em:first').toggleClass("glyphicon-minus");

});

$(".sidebar span.icon").find('em:first').addClass("glyphicon-plus");

}(window.jQuery);

$(window).on('resize', function () {

if ($(window).width() > 768) $('#sidebar-collapse').collapse('show')

})

$(window).on('resize', function () {

if ($(window).width() <= 767) $('#sidebar-collapse').collapse('hide')

})
		
		$('#from_date').on('change', function(){
    var date = $(this).val();
    $('#to_date').datepicker({
    	dateFormat: 'dd-mm-yy',
    	minDate: date,
    });  
});

</script>

<style>

.favourite_icon {

color: white

}

.favourite_icon2 {

color: black

}

.favourite_icon.yellow {

color: #438EB9

}

</style>