REDROOM

Navigation

Breadcrumbs

/ / home / urbanman / roadkaraja.in / manager

Create

Create File | Create Folder | Upload Files | Run Command

Edit File Size: 9.03 KB

/home/urbanman/roadkaraja.in/manager/vcusreporting.php

Text Base64

<?php 
error_reporting(0);
include("common.php"); 
include("config.php"); 
		
?>

<div class="row">
                    <div class="col-12 mt-3">
                        <div class="card">
                            <div class="card-header  justify-content-between align-items-center"> 
<?php                              $dte = date("Y/m/d");
										$b = $_SESSION['branch'];
										
										$vnumber  = $_GET[vnumber];
									
                             $que5 = sprintf("SELECT * from  customer WHERE vehicle_number = '$vnumber'");
                               if(!($res5=mysql_query($que5))){echo mysql_error($que5); exit;}
                                  $customerdata=mysql_fetch_assoc($res5);
                                 
								    $ccid =  $customerdata[id];

//$query="select * from record where purchased='$sdte' or purchased='$edte'  and branch='$b' order by id asc";
									 $query="SELECT * FROM record WHERE cid='$ccid' and branch='$b' order by id desc";
									 
    if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
   $eprorecord=mysql_fetch_assoc($result);
		$count ++;
		$que = sprintf("SELECT * from  customer WHERE id = '%s' ",$eprorecord['cid']);
                               if(!($res=mysql_query($que))){echo mysql_error($que); exit;}
                                  $customer_data=mysql_fetch_assoc($res);
								   $quepoint = sprintf("SELECT * from  customer_product_point WHERE cid = '%s' ",$eprorecord['cid']);
                               if(!($res4=mysql_query($quepoint))){echo mysql_error($quepoint); exit;}
                                  $customer_pointdata=mysql_fetch_assoc($res4);
								  
								  
								   $que4 = sprintf("SELECT * from  customer_product_point WHERE cid = '%s' ",$eprorecord['cid']);
                               if(!($res4=mysql_query($que4))){echo mysql_error($que4); exit;}
                                  $customer_pointdata=mysql_fetch_assoc($res4);
	?>									
                              <h6>  <font color="blue"><b>Sell Report Details  : <?php echo $_GET[mobile];?></b></font><br><br>
								<b>Customer Name : <?php echo ucwords($customerdata[customer_name]);?> ( <?php echo strtoupper($customerdata[vehicle_number]);?> )   </b> <br>
								<br>
									<b><button type="button" class="btnPoint"><b>Balance Point : <font size="6px"> <?php echo $customer_pointdata[point];?></font></b></button></b>
												</h6>
				<div style="float:right;"> <a href="customerstatement-record.php"><button type="button" class="btn7"> Back & New Customer</button></a> </div>
                            </div>
							
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example" class="display table dataTable table-striped table-bordered" >
                                        <thead>
                                            <tr>
											 <th>Date </th> 
											 <th>Vehicle Number </th> 
										 <th>Narration </th> 
										 <th>Debit</th>
                                            <th>Credit</th>
										   <th> Balance</th>
										    
										  
										    <th> </th>
											
                                            </tr>
                                        </thead>
                                        <tbody>
										<?php
										error_reporting(0);
										include("config.php");
										$dte = date("Y/m/d");
										$b = $_SESSION['branch'];
										
										$mobile = $_GET[mobile];
										
	
   // $query="SELECT * FROM record WHERE mobile='$mobile' and branch='$b' order by id ASC";
	
	  $query="SELECT * FROM record WHERE cid='$ccid'  order by id ASC";  
    if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
    while($eprorecord=mysql_fetch_assoc($result)){
		$count ++;
		
		                       $que = sprintf("SELECT * from  customer WHERE id = '%s' order by id ASC",$eprorecord['cid']);
                               if(!($res=mysql_query($que))){echo mysql_error($que); exit;}
                                  $customer_data=mysql_fetch_assoc($res);
                                  $i=0;
                                
		                         $previous_balance22 = $eprorecord['price'] ;
		                         $previous_balance1 = $eprorecord['debit'] ;
		 
		                                  
		                                  $total = $eprorecord['price'] ;
                                          $balance;
									      $balance = ($previous_balance22 + $balance)- $previous_balance1 ;
		
	?>
                     <tr>
					<td><?php echo date('d-m-Y',strtotime($eprorecord['purchased'])); ?></td>
										
					<td><?php echo strtoupper($customer_data[vehicle_number]);?></td>
                   <td><?php echo $eprorecord[narration];?> </td>	 	
				<td><?php if($eprorecord[debit]==''){?> 0 <?php } else {?> <?php echo  $eprorecord[debit];?>   <?php } ?></b></td>
				 <td><?php if($eprorecord[price]==''){?> 0 <?php } else {?><?php echo $eprorecord[price];?>   <?php } ?>  </b></td>
				<td> <b> <?php if($eprorecord[price]=='0'){?> 
				
				<font color="blue"><?php echo $balance;?> </font>
				
				<?php } else {?>
				
				<?php echo $balance;?> 
				
				<?php } ?>
				</b></td>	
												    
<td>
<?php if($eprorecord[price]=='0'){?> <?php } else {?>
<a class="btn2" title="edit" href="edit-report.php?flag=edit&id=<?php echo $eprorecord[id];?>&point=<?php echo $customer_pointdata[point];?>">
                <i class="fa fa-edit icon-white"></i>
<?php } ?>
				</td>	
       </tr>
  			
	 <?php $i++; } ?>
                                          
                                           
                                        </tbody>
                            
                                    </table>
                                </div>
                            </div>
                        </div>

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

<a href="#" class="scrollup text-center"> 
            <i class="icon-arrow-up"></i>
        </a>

<script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
        <script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
        <script src="dist/vendors/moment/moment.js"></script>
            
        <script src="dist/vendors/slimscroll/jquery.slimscroll.min.js"></script>
        <script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script> 
        
        
        
        <script src="dist/js/app.js"></script>

<script src="dist/vendors/datatable/js/jquery.dataTables.min.js"></script> 
        <script src="dist/vendors/datatable/js/dataTables.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/jszip/jszip.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/pdfmake.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/vfs_fonts.js"></script>
        <script src="dist/vendors/datatable/buttons/js/dataTables.buttons.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.colVis.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.flash.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.html5.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.print.min.js"></script>

<script src="dist/js/datatable.script.js"></script>
		<style>
		
		.btn7{
			padding:4px;
			background-color:#669b29;
			color:#fff;
			border-radius:20px;
			padding-left:10px;padding-right:10px;
			border:2px solid #669b29;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:240px;
		}
		.btnPoint{
			padding:4px;
			background-color:green;
			color:#fff;
			border-radius:2px;
			padding-left:1px;padding-right:1px;
			border:2px solid green;
			box-shadow:0 4px 4px 0 rgba(0,0,0,0.1);
			width:180px;
		}
		</style>
		
    </body>
   
</html>

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Directory Contents

Dirs: 5 × Files: 59

Sort:

Enable drag-to-move

Name	Size	Perms	Modified	Actions
css DIR	-	drwxrwxrwx	2026-07-14 05:46:15	Edit Download recursive recursive
dist DIR	-	drwxrwxrwx	2026-07-14 05:46:15	Edit Download recursive recursive
img DIR	-	drwxrwxrwx	2026-07-14 05:46:15	Edit Download recursive recursive
upload DIR	-	drwxrwxrwx	2026-07-14 05:46:15	Edit Download recursive recursive
_dist DIR	-	drwxrwxrwx	2026-07-14 05:46:15	Edit Download recursive recursive
activecustomer.php	6.40 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
add-adv.php	5.85 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
add-discount.php	7.74 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
add-employee.php	4.79 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
add-fuel-rate.php	8.76 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
add-manager.php	4.78 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
approve-member.php	639 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
approve.php	643 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
approved-list.php	5.41 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
birthday-list.php	4.92 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
common.php	7.23 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
config.php	366 B	lrw-rw-rw-	2026-07-06 11:04:01	Edit Download recursive recursive
cusreporting.php	8.72 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
customer-gift-list.php	6.67 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
customer-list.php	6.36 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
customerstatement-record.php	5.01 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
dashboard.php	8.99 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
del-adevertisement.php	396 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
del-customer.php	694 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
del-employee.php	393 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
del-manager.php	391 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
ecommerce-cart.php	12.07 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
edit-customer.php	8.94 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
edit-discount.php	7.79 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
edit-employee.php	5.41 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
edit-fuel-rate.php	5.24 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
edit-manager.php	5.41 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
edit-report-record.php	7.09 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
edit-report.php	8.72 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
employee-list.php	6.93 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
eproduct-list.php	6.66 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
exit.html	0 B	lrw-r--r--	2026-07-14 06:20:46	Edit Download recursive recursive
gift-approve.php	1.26 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
gift-list.php	6.80 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
inactivecustomer.php	6.11 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
index.php	5.81 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
logout.php	215 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
manager-list.php	6.80 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
points.php	5.65 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
product-list.php	8.62 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
re-update-stock.php	603 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
record.php	6.38 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
report-list.php	9.98 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
reporting.php	7.77 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-adv.php	1.75 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-customer.php	1.63 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-discount.php	1.03 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-employee.php	1.06 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-login.php	977 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-manager.php	1.07 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-rate.php	885 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-uprecord-record.php	608 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-uprecord.php	2.27 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
submit-withdrawal.php	577 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
success.php	4.44 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
txets.php	1 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
update-stock.php	628 B	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
vcusreporting.php	9.03 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive
welcome.php	15.77 KB	lrw-rw-rw-	2026-07-06 10:38:25	Edit Download recursive recursive