<?php
/* $Id: index.php 6941 2014-10-26 23:18:08Z daintree $*/
error_reporting(E_ALL & ~E_NOTICE);
$PageSecurity=0;

include('includes/session.inc');
$Title=_('ERP Home');
include('includes/newheader.php');
$userid = $_SESSION['UserID'];


$userid = $_SESSION['UserID'];
if ($userid =='admin'||$userid =='maazil'||$userid =='mosheed'|| $userid =='zubia' || $userid =='nitika'|| $userid =='ravinesh' || $userid =='sharukh'|| $userid =='ravneet' || $userid =='mere' || $userid =='schand' || $userid =='ilimo' || $userid =='riga' || $userid =='mike' || $userid =='stephanie' || $userid =='losa'|| $userid =='nisha' || $userid =='waqa'){
 

?>


      <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.10.16/b-1.5.1/b-flash-1.5.1/b-html5-1.5.1/b-print-1.5.1/datatables.min.css"/>
 <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.1/css/buttons.dataTables.min.css"/>
 <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css"/>
 
   <script type="text/javascript" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script>
	<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.flash.min.js"></script>
	<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.print.min.js"></script>
     
		<script language="JavaScript" type="text/javascript"src="js/Chart.js"></script>
 <!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">



<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
<h4 class="m-widget24__title">
<?php
	
  $month = date("M"); $currentyear = date("Y"); echo "Dashboard for: - ".$month.'-'.$currentyear; 
	$monthTotal = date("M");
	
	
	
													$currentmonth = date("m");
													$currentyear = date("Y");
													$currentdate = $currentyear.'-'.$currentmonth.'-1';
														$currentdate2 = $currentyear.'-'.$currentmonth.'-31';
	                                                   // $last2months = $currentyear.'-'.$currentmonth.'-62';
	
	$lastmonth = $currentmonth - 1;
	
	$lastmonthd= '0'.$lastmonth;
	
	$currentdate3 = $currentyear.'-'.$lastmonthd.'-1';
	
	?> </h4>
 				

	
	<?php 
	
//all
	
	
		$query6 = "SELECT SUM(debtortrans.ovamount + debtortrans.ovgst) AS receipt, department.departmentname
		 
					
		 
				   			  
		          FROM  debtortrans
				
				  INNER JOIN department on department.departmentid= debtortrans.department
				  WHERE debtortrans.type = '10'
				  AND debtortrans.trandate between '" . $currentdate. "' AND '" . $currentdate2. "'
					AND debtortrans.cancelled = '0'			 
				  GROUP BY department.departmentname
				
				  ";
		
		$result6 = DB_query($query6);
	
	while ($myrow6 = DB_fetch_array($result6)) {
		
		$yaxis = ($myrow6['receipt']);
		$jsonxaxis[]= $myrow6['departmentname'];
		$jsonyaxis[]= $yaxis;
		
	}
//	echo json_encode($jsonstock);
//echo json_encode($jsonqty);
	

//installs
	
			$query7 = "SELECT SUM(debtortrans.ovamount + debtortrans.ovgst) AS receipt, department.departmentname
		 
					
		 
				   			  
		          FROM  debtortrans
				
				  INNER JOIN department on department.departmentid=debtortrans.department
				  WHERE debtortrans.type = '10'
				  AND YEAR(debtortrans.trandate) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)
                  AND MONTH(debtortrans.trandate) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)
	              AND debtortrans.cancelled = '0'
			
				  GROUP BY department.departmentname
				
				  ";
		
		$result7 = DB_query($query7);
	
	while ($myrow7 = DB_fetch_array($result7)) {
		
		$yaxis1 = ($myrow7['receipt']);
		$jsonxaxis1[]= $myrow7['departmentname'];
		$jsonyaxis1[]= $yaxis1;
		
	}


		

			$query71 = "SELECT SUM(debtortrans.ovamount + debtortrans.ovgst) AS sales, Monthname(trandate) as monthname,Month(trandate) as month
					
		 
				   			  
		          FROM  debtortrans
				  
				  WHERE debtortrans.type = '10'
				  AND debtortrans.trandate >= '2021-01-01'
					
				  AND debtortrans.cancelled = '0'	
				  GROUP BY monthname
				  Order by month ASC
				  ";
		
		$result71 = DB_query($query71);
	
	while ($myrow71 = DB_fetch_array($result71)) {
		
		
		
		$jsonxaxis2[]= $myrow71['monthname'];
		$jsonyaxis2[]= $myrow71['sales'];
		
	}


		
			$query711 = "SELECT SUM(debtortrans.ovamount + debtortrans.ovgst) AS sales, Monthname(trandate) as monthname,Month(trandate) as month
					
		 
				   			  
		          FROM  debtortrans
				  
				  WHERE debtortrans.type = '10'
				  AND debtortrans.trandate between '2020-01-01' AND '2021-01-01'
					
				  AND debtortrans.cancelled = '0'	
				  GROUP BY monthname
				  Order by month ASC
				  ";
		
		$result711 = DB_query($query711);
	
	while ($myrow711 = DB_fetch_array($result711)) {
		
		
		
		$jsonxaxis3[]= $myrow711['monthname'];
		$jsonyaxis3[]= $myrow711['sales'];
		
	}




	?>
     
   								<div class="row">
									
																		
<div class="col-sm-6">
	<h4 class="m-widget24__title">
		
		Sales(VIP) this month based on departments.
	</h4>
	<canvas id="myChart1"></canvas>

	
	<script >
	
	
	var ctx = document.getElementById('myChart1').getContext('2d');
var chart = new Chart(ctx, {
    // The type of chart we want to create
    type: 'doughnut',

    // The data for our dataset
    data: {
        labels: <?php echo json_encode($jsonxaxis);?>,
        datasets: [{
            label: 'My First dataset',
             backgroundColor: ['rgb(255, 99, 132)', 'rgba(255, 159, 64, 0.2)', 'rgba(54, 162, 235, 0.2)','rgba(75, 192, 192, 0.2)','rgba(123, 239, 178, 1)','rgb(191, 85, 236)','rgb(34, 167, 240)', 'rgb(247, 202, 24)','rgb(241, 130, 141)','rgb(255, 148, 120)','rgb(172, 171, 84),rgb(238, 195, 214),rgb(169, 52, 105  ),rgb(188, 223, 246),rgb(98, 211, 68),rgb(245, 212, 103)'],
            
            data: <?php echo json_encode($jsonyaxis);?>
        },
	]
    },

    // Configuration options go here
    options: {}
});
	</script>
	
	
	
	
	
									</div>
	
	
	<div class="col-sm-6">
	<h4 class="m-widget24__title">
		
		Last months Sales(VIP) based on departments
	</h4>
	<canvas id="myChart"></canvas>

	
	<script >
	
	
	var ctx = document.getElementById('myChart').getContext('2d');
var chart = new Chart(ctx, {
    // The type of chart we want to create
    type: 'doughnut',

    // The data for our dataset
    data: {
        labels: <?php echo json_encode($jsonxaxis1);?>,
        datasets: [{
            label: 'My First dataset',
                       backgroundColor: ['rgba(255, 99, 132,0.2)', 'rgba(255, 159, 64, 0.2)', 'rgba(54, 162, 235, 0.2)','rgba(75, 192, 192, 0.2)','rgba(123, 239, 178, 1)','rgba(191, 85, 236,0.2)','rgba(34, 167, 240,0.2)', 'rgba(247, 202, 24,0.2)','rgba(241, 130, 141,0.2)','rgba(255, 148, 120,0.2)','rgba(172, 171, 84,0.2)','rgba(235, 214, 238)','rgba(238, 214, 217,0.2 )','rgba(188, 223, 246,0.2)','rgba(98, 211, 68,0.2)','rgba(245, 212, 103,0.2)'],

            data: <?php echo json_encode($jsonyaxis1);?>
        },
	]
    },

    // Configuration options go here
    options: {}
});
	</script>
	
	
	
	</br></br>
	
									</div>
	

	
									
							
									

			
	
		<div class="col-sm-6">
	<h4 class="m-widget24__title">
		
		Monthly Total Sales Snapshot for this year
	</h4>
	<canvas id="finalchart"></canvas>

	
	<script >
	
	
	var ctx = document.getElementById('finalchart').getContext('2d');
var chart = new Chart(ctx, {
    // The type of chart we want to create
    type: 'bar',

    // The data for our dataset
    data: {
        labels: <?php echo json_encode($jsonxaxis2);?>,
        datasets: [{
            
                      backgroundColor: ['rgba(255, 99, 132,0.2)', 'rgba(255, 159, 64, 0.2)', 'rgba(54, 162, 235, 0.2)','rgba(75, 192, 192, 0.2)','rgba(123, 239, 178, 1)','rgba(191, 85, 236,0.2)','rgba(34, 167, 240,0.2)', 'rgba(247, 202, 24,0.2)','rgba(241, 130, 141,0.2)','rgba(255, 148, 120,0.2)','rgba(172, 171, 84,0.2)','rgba(235, 214, 238)','rgba(238, 214, 217,0.2 )','rgba(188, 223, 246,0.2)','rgba(98, 211, 68,0.2)','rgba(245, 212, 103,0.2)'],


            
            data: <?php echo json_encode($jsonyaxis2);?>
        },
	    
	 
	]
    },

    // Configuration options go here
    options: {
      indexAxis: 'y'
    }
});
		
	
	</script>
	
	
	</br></br>
	
									</div>
											
	
		<div class="col-sm-6">
	<h4 class="m-widget24__title">
		
		Monthly Total Sales Snapshot for last year
	</h4>
	<canvas id="finalchart1"></canvas>

	
	<script >
	
	
	var ctx = document.getElementById('finalchart1').getContext('2d');
var chart = new Chart(ctx, {
    // The type of chart we want to create
    type: 'bar',

    // The data for our dataset
    data: {
        labels: <?php echo json_encode($jsonxaxis3);?>,
        datasets: [{
            
             backgroundColor: ['rgba(255, 99, 132,0.2)', 'rgba(255, 159, 64, 0.2)', 'rgba(54, 162, 235, 0.2)','rgba(75, 192, 192, 0.2)','rgba(123, 239, 178, 1)','rgba(191, 85, 236,0.2)','rgba(34, 167, 240,0.2)', 'rgba(247, 202, 24,0.2)','rgba(241, 130, 141,0.2)','rgba(255, 148, 120,0.2)','rgba(172, 171, 84,0.2)','rgba(235, 214, 238)','rgba(238, 214, 217,0.2 )','rgba(188, 223, 246,0.2)','rgba(98, 211, 68,0.2)','rgba(245, 212, 103,0.2)'],




            
            data: <?php echo json_encode($jsonyaxis3);?>
        },
	    
	 
	]
    },

    // Configuration options go here
    options: {
      indexAxis: 'y'
    }
});
		
	
	</script>
	
	
	</br></br>
	
									</div>
								
	<?php


echo '<div class="col-sm-12">';
					

	 
	
									
									
									
									
									
									
echo '</div>';
echo '</div>';

echo '</div>';


}
else{
	
	echo "you dont have permission to access this section";
	
}

			  
 	echo '</div >';
											  



	?>


		
		</div>



				
					
					

						<!--end:: Widgets/Stats-->

						<!--Begin::Section-->
						

		<!-- end::Quick Sidebar -->

		<!-- begin::Scroll Top -->
		<div id="m_scroll_top" class="m-scroll-top">
			<i class="la la-arrow-up"></i>
		</div>

		<!-- end::Scroll Top -->

		<!-- begin::Quick Nav -->
		

		<!-- begin::Quick Nav -->
<script src="includes/vendors/owl.carousel/dist/owl.carousel.js" type="text/javascript"></script>

		<!--end::Page Scripts -->
	</body>

	<!-- end::Body -->
</html>
 
      
<?php



/*The module link codes are hard coded in a switch statement below to determine the options to show for each tab */
include('includes/MainMenuLinksArray.php');

if (isset($SupplierLogin) AND $SupplierLogin==1){
	echo '<table class="table_index">
			<tr>
			<td class="menu_group_item">
				<p>&bull; <a href="' . $RootPath . '/SupplierTenders.php?TenderType=1">' . _('View or Amend outstanding offers') . '</a></p>
			</td>
			</tr>
			<tr>
			<td class="menu_group_item">
				<p>&bull; <a href="' . $RootPath . '/SupplierTenders.php?TenderType=2">' . _('Create a new offer') . '</a></p>
			</td>
			</tr>
			<tr>
			<td class="menu_group_item">
				<p>&bull; <a href="' . $RootPath . '/SupplierTenders.php?TenderType=3">' . _('View any open tenders without an offer') . '</a></p>
			</td>
			</tr>
		</table>';
	include('includes/footer.inc');
	exit;
} elseif (isset($CustomerLogin) AND $CustomerLogin==1){
	echo '<table class="table_index">
			<tr>
			<td class="menu_group_item">
				<p>&bull; <a href="' . $RootPath . '/CustomerInquiry.php?CustomerID=' . $_SESSION['CustomerID'] . '">' . _('Account Status') . '</a></p>
			</td>
			</tr>
			<tr>
			<td class="menu_group_item">
				<p>&bull; <a href="' . $RootPath . '/SelectOrderItems.php?NewOrder=Yes">' . _('Place An Order') . '</a></p>
			</td>
			</tr>
			<tr>
			<td class="menu_group_item">
				<p>&bull; <a href="' . $RootPath . '/SelectCompletedOrder.php?SelectedCustomer=' . $_SESSION['CustomerID'] . '">' . _('Order Status') . '</a></p>
			</td>
			</tr>
		</table>';

	include('includes/footer.inc');
	exit;
}

if (isset($_GET['Application'])){ /*This is sent by this page (to itself) when the user clicks on a tab */
	$_SESSION['Module'] = $_GET['Application'];
}








//include('includes/footer.inc');

function GetRptLinks($GroupID) {
/*
This function retrieves the reports given a certain group id as defined in /reports/admin/defaults.php
in the acssociative array $ReportGroups[]. It will fetch the reports belonging solely to the group
specified to create a list of links for insertion into a table to choose a report. Two table sections will
be generated, one for standard reports and the other for custom reports.
*/
	global $db, $RootPath, $ReportList;
	require_once('reportwriter/languages/en_US/reports.php');
	require_once('reportwriter/admin/defaults.php');
	$GroupID=$ReportList[$GroupID];
	$Title= array(_('Custom Reports'), _('Standard Reports and Forms'));

	$sql= "SELECT id,
				reporttype,
				defaultreport,
				groupname,
				reportname
			FROM reports
			ORDER BY groupname,
					reportname";
	$Result=DB_query($sql,'','',false,true);
	$ReportList = '';
	while ($Temp = DB_fetch_array($Result)) $ReportList[] = $Temp;

	$RptLinks = '';
	for ($Def=1; $Def>=0; $Def--) {
        $RptLinks .= '<li class="menu_group_headers">';
        $RptLinks .= '<b>' .  $Title[$Def] . '</b>';
        $RptLinks .= '</li>';
		$NoEntries = true;
		if ($ReportList) { // then there are reports to show, show by grouping
			foreach ($ReportList as $Report) {
				if ($Report['groupname']==$GroupID AND $Report['defaultreport']==$Def) {
                    $RptLinks .= '<li class="menu_group_item">';
					$RptLinks .= '<p>&bull; <a href="' . $RootPath . '/reportwriter/ReportMaker.php?action=go&amp;reportid=' . $Report['id'] . '">' . _($Report['reportname']) . '</a></p>';
					$RptLinks .= '</li>';
					$NoEntries = false;
				}
			}
			// now fetch the form groups that are a part of this group (List after reports)
			$NoForms = true;
			foreach ($ReportList as $Report) {
				$Group=explode(':',$Report['groupname']); // break into main group and form group array
				if ($NoForms AND $Group[0]==$GroupID AND $Report['reporttype']=='frm' AND $Report['defaultreport']==$Def) {
                    $RptLinks .= '<li class="menu_group_item">';
					$RptLinks .= '<img src="' . $RootPath . '/css/' . $_SESSION['Theme'] . '/images/folders.gif" width="16" height="13" alt="" />&nbsp;';
					$RptLinks .= '<p>&bull; <a href="' . $RootPath . '/reportwriter/FormMaker.php?id=' . $Report['groupname'] . '"></p>';
					$RptLinks .= $FormGroups[$Report['groupname']] . '</a>';
					$RptLinks .= '</li>';
					$NoForms = false;
					$NoEntries = false;
				}
			}
		}
		if ($NoEntries) $RptLinks .= '<li class="menu_group_item">' . _('There are no reports to show!') . '</li>';
	}
	return $RptLinks;
}
	
?>


<script>$(document).ready(function() {
   var table = $('#projectreport').DataTable( {
        dom: 'Bfrtip',
	    order: [[ 3, 'desc' ]],
        buttons: [
           
		{
                extend: 'pdfHtml5',
                orientation: 'portrait',
			pageSize: 'A4',
			
			
                customize: function(doc) {
      doc.defaultStyle.fontSize = 12; //<-- set fontsize to 16 instead of 10 
					  
   }  
            },
			{
                extend: 'excelHtml5'},
			
			{
                extend: 'copyHtml5'}
			
			
		],
	   
	   
	   
	   
    } );
		
		
		 
    $('#projectreport tbody').on('click', 'tr', function () {
        $(this).toggleClass('selected');
		  

		
    } );
		   $('#pdfprint').click( function () {
		   
		   var data = table.row( '.selected' ).data();
			//   window.open('PrintStatements.php?FromCust='+data[0]+'&accountnumber='+data[2]);
			   
   		window.location.href = "PrintStatements.php?FromCust="+data[0]+"&accountnumber="+data[2];
 
    } );
		
		 $('#email').click( function () {
		   
		   var data = table.row( '.selected' ).data();
			   
			   $.ajax({
      url:'debtors/EmailStatementsSingle.php',
      method:"POST",
      data:{FromCust:data[2]}
		 
	
     }) 

	  

    } );
		
			 $('#trans').click( function () {
		   
		   var data = table.row( '.selected' ).data();
			   
			   $.ajax({
      url:'debtors/OutstandingTrans.php',
      method:"POST",
      data:{FromCust:data[2]},
		 dataType: 'JSON', 
		
      success:function(response)
     {
		  
	  
		 var len = response.length;
            for(var i=0; i<len; i++){
                var Type = response[i].Type;
                var No = response[i].No;
                var Date = response[i].Date;
                var TotalInvoice= response[i].TotalInvoice;
				
				 var Outstanding= response[i].Outstanding;

                var tr_str = "<tr>" +
                  
                    "<td align='center'>" + Type + "</td>" +
                    "<td align='center'>" + No + "</td>" +
                    "<td align='center'>" + Date + "</td>" +
					 "<td align='center'>" + TotalInvoice + "</td>" +
					 "<td align='center'>" + Outstanding + "</td>" +
                    "</tr>";

                $("#userTable tbody").append(tr_str);
            }

		 
    
      }
     }) 

	   $('#modelWindow').modal('show');

    } );
		   
				 $('#alltrans').click( function () {
		   
		   var data = table.row( '.selected' ).data();
			   
			   $.ajax({
      url:'debtors/AllTrans.php',
      method:"POST",
      data:{FromCust:data[2]},
		 dataType: 'JSON', 
		
      success:function(response)
     {
		  
	  
		 var len = response.length;
            for(var i=0; i<len; i++){
                var Type = response[i].Type;
                var No = response[i].No;
                var Date = response[i].Date;
                var TotalInvoice= response[i].TotalInvoice;
				
				 var Outstanding= response[i].Outstanding;

                var tr_str = "<tr>" +
                  
                    "<td align='center'>" + Type + "</td>" +
                    "<td align='center'>" + No + "</td>" +
                    "<td align='center'>" + Date + "</td>" +
					 "<td align='center'>" + TotalInvoice + "</td>" +
					 "<td align='center'>" + Outstanding + "</td>" +
                    "</tr>";

                $("#userTable tbody").append(tr_str);
            }

		 
    
      }
     }) 

	   $('#modelWindow').modal('show');

    } );
		 $('#close').click( function () {
			 
			 $('#userTable tbody').empty();
		 })
		
		 $('#close1').click( function () {
			 
			 $('#userTable tbody').empty();
		 })
} );
	
	</script>


