PNG  IHDR* pHYs+ IDATx]n#; cdLb Ǚ[at¤_:uP}>!Usă cag޿ ֵNu`ݼTâabO7uL&y^wFٝA"l[|ŲHLN밪4*sG3|Dv}?+y߉{OuOAt4Jj.u]Gz*҉sP'VQKbA1u\`& Af;HWj hsO;ogTu uj7S3/QzUr&wS`M$X_L7r2;aE+ώ%vikDA:dR+%KzƉo>eOth$z%: :{WwaQ:wz%4foɹE[9<]#ERINƻv溂E%P1i01 |Jvҗ&{b?9g=^wζXn/lK::90KwrюO\!ջ3uzuGv^;騢wq<Iatv09:tt~hEG`v;3@MNZD.1]L:{ծI3`L(÷ba")Y.iljCɄae#I"1 `3*Bdz>j<fU40⨬%O$3cGt]j%Fߠ_twJ;ABU8vP3uEԑwQ V:h%))LfraqX-ۿX]v-\9I gl8tzX ]ecm)-cgʒ#Uw=Wlێn(0hPP/ӨtQ“&J35 $=]r1{tLuǮ*i0_;NƝ8;-vݏr8+U-kruȕYr0RnC]*ެ(M:]gE;{]tg(#ZJ9y>utRDRMdr9㪩̞zֹb<ģ&wzJM"iI( .ꮅX)Qw:9,i좜\Ԛi7&N0:asϓc];=ΗOӣ APqz93 y $)A*kVHZwBƺnWNaby>XMN*45~ղM6Nvm;A=jֲ.~1}(9`KJ/V F9[=`~[;sRuk]rєT!)iQO)Y$V ی ۤmzWz5IM Zb )ˆC`6 rRa}qNmUfDsWuˤV{ Pݝ'=Kֳbg,UҘVz2ﴻnjNgBb{? ߮tcsͻQuxVCIY۠:(V뺕 ٥2;t`@Fo{Z9`;]wMzU~%UA蛚dI vGq\r82iu +St`cR.6U/M9IENDB` REDROOM
REDROOM
PHP 5.6.40
Preview: kasa_rapor.php Size: 29.34 KB
/home/ankaservis/azad.ankaservis.com/muhasebe/kasa_rapor.php
 <?php          @session_start();
				@ob_start();
				
				if(!isset($_SESSION["giris"]))
				{
				echo "<meta http-equiv='refresh' content='0;URL=giris.php'>";
				return;
				 }else{
	
?>
<? require_once("sistem/ayarlar.php"); ?>
<? require_once("sistem/fonksiyon.php"); ?>
<!DOCTYPE html>
<html lang="tr">
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
        <meta name="description" content="">
        <meta name="author" content="">

        

        <link href="css/style.default.css" rel="stylesheet">
        <link href="css/morris.css" rel="stylesheet">
        <link href="css/select2.css" rel="stylesheet" />
		<script type="text/javascript" src="jquery-1.9.0.js"></script>
		<script type="text/javascript" src="jquery-ui-1.10.0.custom.js"></script>

<link rel="stylesheet" href="jquery-ui-1.10.0.custom.min.css" />
		<script type="text/javascript">
	$(function() {
	
		$( "#sorgu1" ).datepicker({
			dateFormat: "dd.mm.yy",//tarih formatı yy=yıl mm=ay dd=gün
			changeMonth: true,//ayı elle seçmeyi aktif eder
			changeYear: true,//yılı elee seçime izin verir
			dayNames:[ "pazar", "pazartesi", "salı", "çarşamba", "perşembe", "cuma", "cumartesi" ],//günlerin adı
			dayNamesMin: [ "pa", "pzt", "sa", "çar", "per", "cum", "cmt" ],//kısaltmalar
			defaultDate: 0,//takvim açılınca seçili olanı bu günden 10 gün sonra olsun dedik
			/*isRTL: true//takvimi ters çevirir garip bi özellik :D*/
			maxDate: "+2y+1m +2w",//ileri göre bilme zamanını 2 yıl 1 ay 2 hafta yaptık
			minDate: "-1y-1m -2w",//geriyi göre bilme alanını 1 yıl 1 ay 2 hafta yaptık.bunu istediğiniz gibi ayarlaya bilirsiniz
			monthNamesShort: [ "Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran", "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık" ],//ay seçim alanın düzenledik
			nextText: "İleri",//ileri butonun türkçeleştirdik
			prevText: "Geri",//buda geri butonu için
			showAnim: "slide",//takvim açılım animasyonu alta tüm animasyon isimleri yazdım 
			/*fold-blind-bounce-clip-drop-explode-fade-highlight-puff-pulsate-scale-shake-slide-size-transfer*/
			
		});
		$( "#sorgu2" ).datepicker({
			dateFormat: "dd.mm.yy",//tarih formatı yy=yıl mm=ay dd=gün
			changeMonth: true,//ayı elle seçmeyi aktif eder
			changeYear: true,//yılı elee seçime izin verir
			dayNames:[ "pazar", "pazartesi", "salı", "çarşamba", "perşembe", "cuma", "cumartesi" ],//günlerin adı
			dayNamesMin: [ "pa", "pzt", "sa", "çar", "per", "cum", "cmt" ],//kısaltmalar
			defaultDate: 0,//takvim açılınca seçili olanı bu günden 10 gün sonra olsun dedik
			/*isRTL: true//takvimi ters çevirir garip bi özellik :D*/
			maxDate: "+2y+1m +2w",//ileri göre bilme zamanını 2 yıl 1 ay 2 hafta yaptık
			minDate: "-1y-1m -2w",//geriyi göre bilme alanını 1 yıl 1 ay 2 hafta yaptık.bunu istediğiniz gibi ayarlaya bilirsiniz
			monthNamesShort: [ "Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran", "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık" ],//ay seçim alanın düzenledik
			nextText: "İleri",//ileri butonun türkçeleştirdik
			prevText: "Geri",//buda geri butonu için
			showAnim: "slide",//takvim açılım animasyonu alta tüm animasyon isimleri yazdım 
			/*fold-blind-bounce-clip-drop-explode-fade-highlight-puff-pulsate-scale-shake-slide-size-transfer*/
			
		});
		
	});
</script>
		
		
<? require_once("blok/ustic.php"); ?>
        
        <section>
            <div class="mainwrapper">
               <!--Sol -->
			   <? require_once("blok/sol.php"); ?>
			   <!-- sol bitiş -->
                
                <div class="mainpanel">
                   
                    
                    <div class="contentpanel">
					<div class="col-md-12">
                                <div class="panel panel-default">
                                    <div class="panel-heading">
                                       
                                        <h4 class="panel-title"><b>İKİ TARİH ARASI SORGULA</b></h4>
                                        
                                    </div><!-- panel-heading -->
                                    <div class="panel-body">
                                        <div class="row">
										<form id="basicForm" method="GET" action="kasa_rapor_sorgu.php">
									
										<div class="col-sm-3">
										<input type="text" id="sorgu1" name="gun" placeholder="İlk Tarih" class="form-control" required >
										</div>	
										
										<div class="col-sm-3">
										<input type="text" id="sorgu2" name="ile" placeholder="Son Tarih" class="form-control" required >
										</div>	
										
									
										
										
										<div class="col-sm-2">
										<button class="btn btn-success mr5">Sorgula</button>

										</div>							
                                            
										</form>
                                        </div><!-- row -->
                                       
                                    </div><!-- panel-body -->
                                   
                                </div><!-- panel -->
                                
                            </div><!-- col-md-6 -->
						<!--grafik-->
						<div class="col-md-6">
						<div class="panel panel-default">
						<div class="panel-body">
						<div class="row">
						<div class="col-md-12 mb30">
                                        <h5 class="lg-title mb10">Teknik Personel İş Yoğunluğu</h5>
                                        <div id="donut-kullanici" class="height300"></div>
                        </div>
						</div><!-- row -->
						</div><!-- panel-body -->
						</div><!-- panel -->
						</div>

						<div class="col-md-6 mb30" style="display:none">
						<h5 class="lg-title mb10">Teknik Personel servis Yüzdesi</h5>						
						<div id="piechart" class="flotGraph"></div>
						</div>
						
						<div class="col-md-6">
						<div class="panel panel-default">
						<div class="panel-body">
						<div class="row">
						<div class="col-md-12 mb30">
						<h5 class="lg-title mb10">30 Günlük Servis Girişi Çizelgesi</h5>
						<div id="line-servis" class="height300"></div>
						</div>
						</div><!-- row -->
						</div><!-- panel-body -->
						</div><!-- panel -->
						</div>
						
						<div class="col-md-6">
						<div class="panel panel-default">
						<div class="panel-body">
						<div class="row">
						<div class="col-md-12 mb30">
                                        <h5 class="lg-title mb10">Ürün Cinsine Göre Servis Yoğunluğu</h5>
                                        <div id="donut-chart2" class="height300"></div>
                        </div>
						</div><!-- row -->
						</div><!-- panel-body -->
						</div><!-- panel -->
						</div>
						
						<div class="col-md-6">
						<div class="panel panel-default">
						<div class="panel-body">
						<div class="row">
						<div class="col-md-12 mb30">
                                        <h5 class="lg-title mb10">Markaya Göre Servis Yoğunluğu</h5>
                                        <div id="donut-marka" class="height300"></div>
                        </div>
						</div><!-- row -->
						</div><!-- panel-body -->
						</div><!-- panel -->
						</div>
						
						<!--grafik -->	
		
						
						<!--grafik -->	
						
						
						<div class="col-sm-6 col-md-12">
						<div class="panel panel-default">
						<div class="panel-body">
						<div class="row">
						<div class="col-md-12 mb30">
						<h5 class="lg-title mb10">30 Günlük Alış Ve Satış Çizelgesi</h5>
						<div id="line-chart" class="height300"></div>
						</div>
						</div><!-- row -->
						</div><!-- panel-body -->
						</div><!-- panel -->
						</div>
						<!--grafik BİTİŞ-->
				
						
							<div class="col-md-12">
							<hr>
							</div>
							
                        
                    </div><!-- contentpanel -->
                    
                </div><!-- mainpanel -->
            </div><!-- mainwrapper -->
        </section>


        
     
			<script src="js/jquery-1.11.1.min.js"></script>
		<script src="js/jquery-migrate-1.2.1.min.js"></script>
		<script src="js/jquery-ui-1.10.3.min.js"></script>
		<script src="js/bootstrap.min.js"></script>
		<script src="js/modernizr.min.js"></script>
		<script src="js/pace.min.js"></script>
		<script src="js/retina.min.js"></script>
		<script src="js/jquery.cookies.js"></script>
		<script src="js/jquery.tagsinput.min.js"></script>
		<script src="js/select2.min.js"></script>
		<script src="js/jquery.validate.min.js"></script>
		<script src="js/jquery.maskedinput.min.js"></script>

		<script src="js/jquery.autogrow-textarea.js"></script>
		<script src="js/jquery.mousewheel.js"></script>
		<script src="js/toggles.min.js"></script>
		<script src="js/bootstrap-timepicker.min.js"></script>
		<script src="js/colorpicker.js"></script>
		<script src="js/dropzone.min.js"></script>
		<script src="js/wysihtml5-0.3.0.min.js"></script>
		<script src="js/bootstrap-wysihtml5.js"></script>
		<script src="js/jquery.dataTables.min.js"></script>
		<script src="js/dataTables.bootstrap.js"></script>
		<script src="js/dataTables.responsive.js"></script>
		<script src="js/ckeditor/ckeditor.js"></script>
		<script src="js/ckeditor/adapters/jquery.js"></script>
		<script src="js/jquery.prettyPhoto.js"></script>





			<script src="js/flot/jquery.flot.min.js"></script>
        <script src="js/flot/jquery.flot.resize.min.js"></script>
        <script src="js/flot/jquery.flot.symbol.min.js"></script>
        <script src="js/flot/jquery.flot.crosshair.min.js"></script>
        <script src="js/flot/jquery.flot.categories.min.js"></script>
        <script src="js/flot/jquery.flot.pie.min.js"></script>
        <script src="js/morris.min.js"></script>
        <script src="js/raphael-2.1.0.min.js"></script>
        <script src="js/jquery.sparkline.min.js"></script>






		<script src="js/custom.js"></script>
		        <script>
            jQuery(document).ready(function(){
                
                jQuery('#basicTable').DataTable({
                    responsive: true
                });
                
                var shTable = jQuery('#shTable').DataTable({
                    "fnDrawCallback": function(oSettings) {
                        jQuery('#shTable_paginate ul').addClass('pagination-active-dark');
                    },
                    responsive: true
                });
                
                // Show/Hide Columns Dropdown
                jQuery('#shCol').click(function(event){
                    event.stopPropagation();
                });
                
                jQuery('#shCol input').on('click', function() {

                    // Get the column API object
                    var column = shTable.column($(this).val());
 
                    // Toggle the visibility
                    if ($(this).is(':checked'))
                        column.visible(true);
                    else
                        column.visible(false);
                });
                
                var exRowTable = jQuery('#exRowTable').DataTable({
                    responsive: true,
                    "fnDrawCallback": function(oSettings) {
                        jQuery('#exRowTable_paginate ul').addClass('pagination-active-success');
                    },
                    "ajax": "ajax/objects.txt",
                    "columns": [
                        {
                            "class":          'details-control',
                            "orderable":      false,
                            "data":           null,
                            "defaultContent": ''
                        },
                        { "data": "name" },
                        { "data": "position" },
                        { "data": "office" },
                        { "data": "salary" }
                    ],
                    "order": [[1, 'asc']] 
                });
                
                // Add event listener for opening and closing details
                jQuery('#exRowTable tbody').on('click', 'td.details-control', function () {
                    var tr = $(this).closest('tr');
                    var row = exRowTable.row( tr );
             
                    if ( row.child.isShown() ) {
                        // This row is already open - close it
                        row.child.hide();
                        tr.removeClass('shown');
                    }
                    else {
                        // Open this row
                        row.child( format(row.data()) ).show();
                        tr.addClass('shown');
                    }
                });
               
                
                // DataTables Length to Select2
                jQuery('div.dataTables_length select').removeClass('form-control input-sm');
                jQuery('div.dataTables_length select').css({width: '60px'});
                jQuery('div.dataTables_length select').select2({
                    minimumResultsForSearch: -1
                });
    
            });
            
            function format (d) {
                // `d` is the original data object for the row
                return '<table class="table table-bordered nomargin">'+
                    '<tr>'+
                        '<td>Full name:</td>'+
                        '<td>'+d.name+'</td>'+
                    '</tr>'+
                    '<tr>'+
                        '<td>Extension number:</td>'+
                        '<td>'+d.extn+'</td>'+
                    '</tr>'+
                    '<tr>'+
                        '<td>Extra info:</td>'+
                        '<td>And any further details here (images etc)...</td>'+
                    '</tr>'+
                '</table>';
            }
        </script>
		 <script>
		
		
		
		jQuery(document).ready(function() {
    
    "use strict";
    
    function showTooltip(x, y, contents) {
	jQuery('<div id="tooltip" class="tooltipflot">' + contents + '</div>').css( {
	    position: 'absolute',
	    display: 'none',
	    top: y + 5,
	    left: x + 5
	}).appendTo("body").fadeIn(200);
    }
    
    /*****SIMPLE CHART*****/
    


		

    
    
    /***** USING OTHER SYMBOLS *****/
    

		

		

    
    /***** TRACKING WITH CROSSHAIR *****/
 





	 var updateLegendTimeout = null;
	 var latestPosition = null;

	 function updateLegend() {

		  updateLegendTimeout = null;

		  var pos = latestPosition;

		  var axes = plot3.getAxes();
		  if (pos.x < axes.xaxis.min || pos.x > axes.xaxis.max ||
				pos.y < axes.yaxis.min || pos.y > axes.yaxis.max) {
				return;
		  }

		  var i, j, dataset = plot3.getData();
		  for (i = 0; i < dataset.length; ++i) {

				var series = dataset[i];

				// Find the nearest points, x-wise
				for (j = 0; j < series.data.length; ++j) {
					if (series.data[j][0] > pos.x) {
                    break;
					}
				}

				// Now Interpolate
				var y,
					p1 = series.data[j - 1],
					p2 = series.data[j];

				if (p1 == null) {
					y = p2[1];
				} else if (p2 == null) {
					y = p1[1];
				} else {
					y = p1[1] + (p2[1] - p1[1]) * (pos.x - p1[0]) / (p2[0] - p1[0]);
				}

				legends.eq(i).text(series.label.replace(/=.*/, "= " + y.toFixed(2)));
		  }
	 }


    
    
    /***** REAL TIME UPDATES *****/
  
    
    
    /***** BAR CHART *****/
    

    
    
        /***** PIE CHART *****/
    
    var piedata = [
	<?php 
		$sql = "select * from yonetici where durum='6' and pasif='0' ";
		$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($musterigetir = mysql_fetch_array($musteri)){ 
		$say=$musterigetir["id"];
		$omer[] = $musterigetir["adi"];
		$rand = array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f');
    $color = '#'.$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)];
		

		?>
		<?
				$teslim = mysql_num_rows(mysql_query("select * from girisler where yeni_personel='$say' "));
			
				?>
        { label: "<?php echo $musterigetir['kadi']; ?> <?php echo $teslim; ?>", data: [[1,<?php echo $teslim; ?>]], color: '<?php echo $color; ?>'},
		<?php } ?>
		
		
	 ];
    
    jQuery.plot('#piechart', piedata, {
        series: {
            pie: {
                show: true,
                radius: 1,
                label: {
                    show: true,
                    radius: 2/3,
                    formatter: labelFormatter,
                    threshold: 0.1
                }
            }
        },
        grid: {
            hoverable: true,
            clickable: true
        }
    });
    
    function labelFormatter(label, series) {
		return "<div style='font-size:8pt; text-align:center; padding:2px; color:white;'>" + label + "<br/>" + Math.round(series.percent) + "%</div>";
	}

   
   
   /***** MORRIS CHARTS *****/
   
   var m1 = new Morris.Line({
        // ID of the element in which to draw the chart.
        element: 'line-chart',
        // Chart data records -- each entry in this array corresponds to a point on
        // the chart.
        data: [
		<?php 
	
		$bu	=date("Y-m-d");
		$NewDates = strtotime('-31 day', strtotime($bu));
					$tarih = date('Y-m-d', $NewDates);
		
	
		for ( $i = 1; $i <= 29; $i++ ){
	
					
					$attir = $i + 1 ;
					$taksitsay	= $i;
					$NewDate = strtotime($attir.' day', strtotime($tarih));
					
					$tarih_artir = date('Y-m-d', $NewDate); 
					$ytt = date('d-m-Y', $NewDate); 
					
					
					 
					$borclar = mysql_query("SELECT SUM(toplam) as toplam FROM stokfishareketi WHERE tarih='$tarih_artir' and tur='2'");
										$rowborclar = mysql_fetch_array($borclar); 
										$alacaklar = mysql_query("SELECT SUM(toplam) as toplam FROM stokfishareketi WHERE tarih='$tarih_artir' and tur='1'");
										$rowalacaklar = mysql_fetch_array($alacaklar); 
										$tahsil=$rowalacaklar["toplam"];
										
										$rowalacaklartoplami=number_format($tahsil, 2, '.', '');
										
										$alacaz=$rowborclar["toplam"];
										
										$rowborclartoplami=number_format($alacaz, 2, '.', '');
										
									
						?>

		
            { y: '<?php echo $tarih_artir;  ?>', a:' <?php echo $rowborclartoplami; ?> ', b:  '<?php echo $rowalacaklartoplami; ?> TL' },
          
           
		<?php }	?>
		<?php
		$bugunual	=date("Y-m-d");
		$borclart = mysql_query("SELECT SUM(toplam) as toplam FROM stokfishareketi WHERE tarih='$bugunual' and tur='2'");
										$rowborclart = mysql_fetch_array($borclart); 
										$alacaklart = mysql_query("SELECT SUM(toplam) as toplam FROM stokfishareketi WHERE tarih='$bugunual' and tur='1'");
										$rowalacaklart = mysql_fetch_array($alacaklart); 
										$tahsilt=$rowalacaklart["toplam"];
										
										$rowalacaklartoplamit=number_format($tahsilt, 2, '.', '');
										
										$alacazt=$rowborclart["toplam"];
										
										$rowborclartoplamit=number_format($alacazt, 2, '.', '');
										?>
		 { y: '<?php echo $bugunual;  ?>', a:' <?php echo $rowborclartoplamit; ?> ', b:  '<?php echo $rowalacaklartoplamit; ?> TL' }
		
		
        ],
        xkey: 'y',
        ykeys: ['a', 'b'],
        labels: ['Alışlar', 'Satışlar'],
        lineColors: ['#D9534F', '#428BCA'],
        lineWidth: '2px',
        hideHover: 'auto',
	resize: true
    });
	
	
	   var m1 = new Morris.Line({
        // ID of the element in which to draw the chart.
        element: 'line-servis',
        // Chart data records -- each entry in this array corresponds to a point on
        // the chart.
        data: [
		<?php 
	
		$bu	=date("Y-m-d");
		$NewDates = strtotime('-31 day', strtotime($bu));
					$tarih = date('Y-m-d', $NewDates);
		
	
		for ( $i = 1; $i <= 29; $i++ ){
	
					
					$attir = $i + 1 ;
					$taksitsay	= $i;
					$NewDate = strtotime($attir.' day', strtotime($tarih));
					
					$tarih_artir = date('Y-m-d', $NewDate); 
					$ytt = date('d-m-Y', $NewDate); 
					
					$girishesapla = mysql_num_rows(mysql_query("select * from girisler where tarihi='$tarih_artir' "));
				$girislerini_yaz	= $girishesapla;
					$cikishesapla = mysql_num_rows(mysql_query("select * from girisler where tarihi='$tarih_artir' and Gdurum='48' "));
				$cikislariniy_yaz	= $cikishesapla;
				
				$islemsonlari = mysql_num_rows(mysql_query("select * from girisler where tarihi='$tarih_artir' and Gdurum='54' "));
				$islemsonlari_yaz	= $islemsonlari;
				$yerindeonrt = mysql_num_rows(mysql_query("select * from girisler where tarihi='$tarih_artir' and Gdurum='47' "));
				$yerindeonrtyt	= $yerindeonrt;
				
										
										
									
						?>

		
            { y: '<?php echo $tarih_artir;  ?>', a:' <?php echo $girislerini_yaz; ?> ', b:  '<?php echo $islemsonlari_yaz; ?> ', c:  '<?php echo $cikislariniy_yaz; ?> ', d:  '<?php echo $yerindeonrtyt; ?> ' },
          
           
		<?php }	?>
		<?php
		$bugunual	=date("Y-m-d");
		$girishesaplat = mysql_num_rows(mysql_query("select * from girisler where tarihi='$bugunual' "));
				$girislerini_yazt	= $girishesaplat;
					$cikishesaplat = mysql_num_rows(mysql_query("select * from girisler where tarihi='$bugunual' and Gdurum='48' "));
				$cikislariniy_yazt	= $cikishesaplat;
				$islemsonlarit = mysql_num_rows(mysql_query("select * from girisler where tarihi='$bugunual' and Gdurum='54' "));
				$islemsonlari_yazt	= $islemsonlarit;
				$yerindeonr = mysql_num_rows(mysql_query("select * from girisler where tarihi='$bugunual' and Gdurum='47' "));
				$yerindeonrty	= $yerindeonr;
										?>
		  { y: '<?php echo $bugunual;  ?>', a:' <?php echo $girislerini_yazt; ?> ' }
		
		
        ],
        xkey: 'y',
        ykeys: ['a'],
        labels: ['Servis Girişi'],
        lineColors: ['#368c2e', '#ff002b', '#ff00f7', '#006aa3'],
        lineWidth: '2px',
        hideHover: 'auto',
	resize: true
    });
   

    
  
    


    var m6 = new Morris.Donut({
        element: 'donut-chart2',
        data: [
		<?php 
		$sql = "select * from urunturu order by turu asc";
		$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($musterigetir = mysql_fetch_array($musteri)){ 
		$say=$musterigetir["id"];
		$omer[] = $musterigetir["turu"];

		?>
		<?
				$teslim = mysql_num_rows(mysql_query("select * from girisler where turu='$say' "));
			if($teslim>0){
				?>
          {label: "<?php echo $musterigetir['turu']; ?>", value: <?php echo $teslim; ?>},
			<?php } } ?>
        ],
		
        colors: [
		<?php 
		$sql = "select * from urunturu order by turu asc";
		$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($musterigetir = mysql_fetch_array($musteri)){ 
		$rand = array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f');
    $color = '#'.$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)];
		

		?>
		'<?php echo $color ; ?>',<?php } ?>]
    });
	
	
	 var m6 = new Morris.Donut({
        element: 'donut-marka',
        data: [
		<?php 
		$sql = "select * from marka order by marka asc";
		$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($musterigetir = mysql_fetch_array($musteri)){ 
		$say=$musterigetir["id"];
		$omer[] = $musterigetir["marka"];

		?>
		<?
				$teslim = mysql_num_rows(mysql_query("select * from girisler where marka='$say' "));
			if($teslim>0){
				?>
          {label: "<?php echo $musterigetir['marka']; ?>", value: <?php echo $teslim; ?>},
		<?php }} ?>
        ],
		
        colors: [
		<?php 
		$sql = "select * from urunturu order by turu asc";
		$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($musterigetir = mysql_fetch_array($musteri)){ 
		$rand = array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f');
    $color = '#'.$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)].$rand[rand(0,15)];
		

		?>
		'<?php echo $color ; ?>',<?php } ?>]
    });
	
	
	
		 var m6 = new Morris.Donut({
        element: 'donut-kullanici',
        data: [
			<?php 
		$sql = "select * from yonetici where durum='6' and pasif='0' order by adi asc";
		$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($musterigetir = mysql_fetch_array($musteri)){ 
		$say=$musterigetir["id"];
		$omer[] = $musterigetir["adi"];
		

		?>
		<?
				$teslim = mysql_num_rows(mysql_query("select * from girisler where yeni_personel='$say' "));
			

				?>
          {label: "<?php echo $musterigetir['adi']; ?>", value: <?php echo $teslim; ?>},
		<?php } ?>
        ],
		
        colors: [
		<?php 
		$sql = "select * from yonetici where durum='6' and pasif='0' ";
		$musteri = mysql_query($sql, $baglanti) or die(mysql_error());
		while ($musterigetir = mysql_fetch_array($musteri)){ 
		$randcolor = array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f');
    $color_teknik = '#'.$randcolor[rand(0,15)].$randcolor[rand(0,15)].$randcolor[rand(0,15)].$randcolor[rand(0,15)].$randcolor[rand(0,15)].$randcolor[rand(0,15)];
		

		?>
		'<?php echo $color_teknik ; ?>',<?php } ?>]
    });



    
    /***** SPARKLINE CHARTS *****/
    
  
    
    
    var delay = (function() {
	var timer = 0;
	return function(callback, ms) {
	    clearTimeout(timer);
	    timer = setTimeout(callback, ms);
	};
    })();

    jQuery(window).resize(function() {
	delay(function() {
	    m1.redraw();
	    m2.redraw();
	    m3.redraw();
	    m4.redraw();
	    m5.redraw();
	    m6.redraw();
	}, 200);
    }).trigger('resize');
  
});

		</script>


		        <script>
            jQuery(document).ready(function(){
                
                jQuery('#basicTable').DataTable({
                    responsive: true
                });
                
                var shTable = jQuery('#shTable').DataTable({
                    "fnDrawCallback": function(oSettings) {
                        jQuery('#shTable_paginate ul').addClass('pagination-active-dark');
                    },
                    responsive: true
                });
                
                // Show/Hide Columns Dropdown
                jQuery('#shCol').click(function(event){
                    event.stopPropagation();
                });
                
                jQuery('#shCol input').on('click', function() {

                    // Get the column API object
                    var column = shTable.column($(this).val());
 
                    // Toggle the visibility
                    if ($(this).is(':checked'))
                        column.visible(true);
                    else
                        column.visible(false);
                });
                
                var exRowTable = jQuery('#exRowTable').DataTable({
                    responsive: true,
                    "fnDrawCallback": function(oSettings) {
                        jQuery('#exRowTable_paginate ul').addClass('pagination-active-success');
                    },
                    "ajax": "ajax/objects.txt",
                    "columns": [
                        {
                            "class":          'details-control',
                            "orderable":      false,
                            "data":           null,
                            "defaultContent": ''
                        },
                        { "data": "name" },
                        { "data": "position" },
                        { "data": "office" },
                        { "data": "salary" }
                    ],
                    "order": [[1, 'asc']] 
                });
                
                // Add event listener for opening and closing details
                jQuery('#exRowTable tbody').on('click', 'td.details-control', function () {
                    var tr = $(this).closest('tr');
                    var row = exRowTable.row( tr );
             
                    if ( row.child.isShown() ) {
                        // This row is already open - close it
                        row.child.hide();
                        tr.removeClass('shown');
                    }
                    else {
                        // Open this row
                        row.child( format(row.data()) ).show();
                        tr.addClass('shown');
                    }
                });
               
                
                // DataTables Length to Select2
                jQuery('div.dataTables_length select').removeClass('form-control input-sm');
                jQuery('div.dataTables_length select').css({width: '60px'});
                jQuery('div.dataTables_length select').select2({
                    minimumResultsForSearch: -1
                });
    
            });
			// Input Masks
                jQuery("#date").mask("99/99/9999");
                jQuery("#gsm").mask("(999) 999-9999");
				jQuery("#fax").mask("(999) 999-9999");
				jQuery("#sabittel").mask("(999) 999-9999");
                jQuery("#ssn").mask("999-99-9999");
				jQuery("#vergino").mask("9999999999");
            
            function format (d) {
                // `d` is the original data object for the row
                return '<table class="table table-bordered nomargin">'+
                    '<tr>'+
                        '<td>Full name:</td>'+
                        '<td>'+d.name+'</td>'+
                    '</tr>'+
                    '<tr>'+
                        '<td>Extension number:</td>'+
                        '<td>'+d.extn+'</td>'+
                    '</tr>'+
                    '<tr>'+
                        '<td>Extra info:</td>'+
                        '<td>And any further details here (images etc)...</td>'+
                    '</tr>'+
                '</table>';
            }
        </script>
	

		

    </body>
</html>
<? } ?>

Directory Contents

Dirs: 21 × Files: 125
Name Size Perms Modified Actions
ajax DIR
- drwxr-xr-x 2025-01-09 06:49:12
Edit Download
barkod DIR
- drwxr-xr-x 2025-01-09 06:49:14
Edit Download
blok DIR
- drwxr-xr-x 2025-01-09 06:49:14
Edit Download
css DIR
- drwxr-xr-x 2025-01-09 06:49:14
Edit Download
db DIR
- drwxr-xr-x 2025-01-09 06:49:14
Edit Download
dist DIR
- drwxr-xr-x 2025-01-09 06:49:18
Edit Download
Excel DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
font DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
fonts DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
giris DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
holder.js DIR
- drwxr-xr-x 2025-01-09 06:49:22
Edit Download
images DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
img DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
js DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
Pager DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
scopbin DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
sf DIR
- drwxr-xr-x 2025-01-09 06:49:24
Edit Download
sistem DIR
- drwxr-xr-x 2025-01-09 06:49:26
Edit Download
Sorgula DIR
- drwxr-xr-x 2025-01-09 06:49:30
Edit Download
yedekle_Xc DIR
- drwxr-xr-x 2025-01-09 06:49:30
Edit Download
yuklenen DIR
- drwxr-xr-x 2025-01-09 06:49:30
Edit Download
.htaccess
1.33 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
30ustu.php
9.25 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
ajax-loader.gif
3.41 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ara.php
4.12 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
arafatura.php
985 B lrw-r--r-- 2017-05-21 19:35:00
Edit Download
aramasonuc.php
18.62 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
aramatel.php
18.62 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
araseri.php
975 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
aratakip.php
993 B lrw-r--r-- 2017-05-21 19:35:00
Edit Download
ay.php
9.25 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ayarlar.php
17.22 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
carihareket_yazdir.php
9.55 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
cari_tarih_sorgu.php
10.89 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
class.phpmailer.php
88.75 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
class.smtp.php
30.33 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
config.inc.php
508 B lrw-r--r-- 2023-01-20 08:58:08
Edit Download
deftergiris.php
27.25 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
deftersorgu.php
28.51 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
depo.php
12.88 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
depo_analiz.php
12.88 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
depo_hareketleri.php
22.62 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
depo_hareketleri_sorgu.php
23.71 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
depo_nakil.php
22.48 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
depo_stok_kodu_sorgu.php
23.19 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
error_log
153 B lrw-r--r-- 2025-01-09 10:13:36
Edit Download
faturam.php
22.76 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
fetch_pages.php
5.08 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
fetch_pagesarama.php
6.06 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
fetch_pages_tumu.php
4.96 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
fis.php
6.03 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
formhesap.php
3.51 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
formhesap2.php
4.04 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
giris.php
4.46 KB lrw-r--r-- 2024-07-31 10:29:22
Edit Download
girisler.php
20.38 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
girisler_sorgu.php
24.71 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
gorusmeekle.php
1.02 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
hafta.php
9.25 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
hatirlatmalar.php
16.59 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
hatirlatma_duzen.php
14.07 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
hesap_nakil.php
2.79 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
hesap_nakil_personel.php
2.67 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
index.php
18.53 KB lrw-r--r-- 2024-07-31 11:02:08
Edit Download
islem.php
253 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jquery-1.9.0.js
261.05 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jquery-ui-1.10.0.custom.js
422.49 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jquery-ui-1.10.0.custom.min.css
26.42 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jsDatePick.css
8.21 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
jsDatePick.min.1.1.js
27.95 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
kasadefteri.php
26.70 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
kasa_defteri_ajax1.php
7.11 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
kasa_hareketleri.php
27.98 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
kasa_rapor.php
29.34 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
kasa_rapor_sorgu.php
30.18 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
lisans.php
466 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
markaListele.php
9.61 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
mesajlarim.php
6.55 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
mesaj_oku.php
7.25 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
mesaj_yaz.php
6.92 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
Musteri.php
81.68 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
MusteriEkle.php
23.05 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
Musteriler.php
15.92 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
Musterilerajax.php
18.04 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
Musteriler_tumu.php
18.06 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
Musteri_borc.php
17.80 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
musteri_exel.php
1.01 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ORNEK_MUSTERI_SABLONU.xls
19.50 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ORNEK_STOK_SABLONU.xls
19.00 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
parcamodul.php
53.08 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
perListele.php
10.65 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personelis.php
10.53 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personelis_yazdir.php
8.84 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personel_defter_sorgu.php
29.72 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
personel_excel.php
17.39 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
personel_kasa.php
33.75 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
personel_kasa_getir.php
17.15 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personel_kasa_giris.php
39.56 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
personel_kasa_onaysiz.php
33.47 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
personel_kasa_yazdir.php
11.15 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
pesin_satis.php
18.70 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
profil_resmim.php
7.23 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rapor_aylik_alislar.php
25.79 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rapor_aylik_satislar.php
25.81 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rapor_gunluk.php
27.80 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rapor_tarih_kasa.php
28.12 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
refresh.png
832 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rehberduzen.php
19.24 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
rehberekle.php
18.41 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
resimyukle.php
3.58 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
resimyukleser.php
3.59 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
security.php
879 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
serinoListele.php
6.16 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
serinosorgula.php
7.90 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
seri_liste.php
9.53 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ServisDuzen.php
21.54 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
ServisDuzenpersonel.php
13.70 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
servisekle.php
11.84 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
sifre_degistir.php
7.05 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
sortable.js
187.39 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokalis_satis.php
20.05 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stokfis_list.php
23.75 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stokfis_list_personel.php
22.43 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stokguruplari.php
12.89 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokhareket.php
56.47 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartduzenle.php
27.42 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartekle.php
22.12 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartiara.php
21.65 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartlari.php
21.35 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartlari_depo.php
21.34 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stokkartlari_kritik.php
20.87 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_alis.php
19.71 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_excel.php
3.01 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stok_fatura.php
23.47 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_fis_sorgu.php
26.82 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_fis_sorgu_personel.php
25.67 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
stok_hareketleri.php
25.08 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_hareketleri_sorgu.php
26.52 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_kodu_sorgu.php
24.86 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
stok_satis.php
19.71 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
turListele.php
9.57 KB lrw-r--r-- 2017-05-21 19:35:00
Edit Download
veri_kontrol.php
239 B lrw-r--r-- 2017-05-21 19:35:02
Edit Download
vt_yedekleme_Xc.php
11.27 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
xls.php
18.01 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
xls_stok.php
17.00 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
yazdir.php
7.42 KB lrw-r--r-- 2024-04-11 01:54:26
Edit Download
yedekle_Xc.php
1.15 KB lrw-r--r-- 2017-05-21 19:35:02
Edit Download
If ZipArchive is unavailable, a .tar will be created (no compression).
© 2026 REDROOM — Secure File Manager. All rights reserved. Built with ❤️ & Red Dark UI