Na}{

Path: ~/home/caratcollect/domains/24caratcollection.com/private_html/Demo/TEST/

File Content: `incomesReportExcel.php`

<?php
	include("library.php");
	$output = '';
	if(isset($_POST["export"]))
	{
	        if(!empty($_REQUEST['searchBy']))
			{
			  if($userType=='subscription')
			  {
				   if(!empty($_REQUEST['all']))
					{
					  $search=$_REQUEST['searchBy'];
					  $result=$mysql->m_Query("select * from income where (name Like '%$search%' OR amount Like '%$search%' OR category Like '%$search%' OR payment Like '%$search%' OR incomeDate Like '%$search%') && (clientId=$userId and status='Approved' && userType='subscription') order by incomeDate desc");
					}
					elseif(!empty($_REQUEST['date1']))
					{
					 $search=$_REQUEST['searchBy'];
					 $date1=$_REQUEST['date1'];
					 $result=$mysql->m_Query("select * from income where (name Like '%$search%' OR amount Like '%$search%' OR category Like '%$search%' OR payment Like '%$search%' OR incomeDate Like '%$search%') && (clientId=$userId && incomeDate='$date1' and status='Approved' && userType='subscription') order by incomeDate desc");
					}
					elseif(!empty($_REQUEST['month']))
					{
					  $search=$_REQUEST['searchBy'];
					  $month= $_REQUEST['month'];
					  $result=$mysql->m_Query("select * from income where (name Like '%$search%' OR amount Like '%$search%' OR category Like '%$search%' OR payment Like '%$search%' OR incomeDate Like '%$search%') and (clientId=$userId && Month(incomeDate)='$month' and status='Approved' && userType='subscription') order by incomeDate desc");
					}
				}
				elseif($userType=='trial')
				{
					if(!empty($_REQUEST['all']))
					{
					  $search=$_REQUEST['searchBy'];
					  $result=$mysql->m_Query("select * from income where (name Like '%$search%' OR amount Like '%$search%' OR category Like '%$search%' OR payment Like '%$search%' OR incomeDate Like '%$search%') && (userType='trial' and status='Approved') order by incomeDate desc");
					}
					elseif(!empty($_REQUEST['date1']))
					{
					 $search=$_REQUEST['searchBy'];
					 $date1=$_REQUEST['date1'];
					 $result=$mysql->m_Query("select * from income where (name Like '%$search%' OR amount Like '%$search%' OR category Like '%$search%' OR payment Like '%$search%' OR incomeDate Like '%$search%') && (userType='trial' && incomeDate='$date1' and status='Approved') order by incomeDate desc");
					}
					elseif(!empty($_REQUEST['month']))
					{
					  $search=$_REQUEST['searchBy'];
					  $month= $_REQUEST['month'];
					  $result=$mysql->m_Query("select * from income where (name Like '%$search%' OR amount Like '%$search%' OR category Like '%$search%' OR payment Like '%$search%' OR incomeDate Like '%$search%') and (userType='trial' && Month(incomeDate)='$month' and status='Approved') order by incomeDate desc");
					}
				}
			    $output .= '
	   			<table class="table" border="1">  
	  					 <tr><th colspan=6><h2 align=center border="1">INCOME STATEMENT</h1></th></tr>
						<tr>  
							 <th>S.No</th>
							 <th>Date</th>    
							 <th>Name</th>  
							 <th>Category</th>  
							 <th>Amount</th>
							 <th>Payment</th>
							
						</tr>';				$i=1;
						
							
							
							while($row=$mysql->m_FetchArray())
							{ 
								$date=date('d-m-Y',strtotime($row[incomeDate]));
								
								$output .= '
								<tr>
								 <td align=center>'.$i.'</td>  
								  <td align=right>'.$date.'</td> 
								 <td align=left>'.$row["name"].'</td>  
								 <td align=center>'.$row["category"].'</td>  
								 <td align=center>'.$row["amount"].'</td>  
								 <td align=center>'.$row["payment"].'</td>  
								  
								   
								</tr>
						   ';
						   $i++;
					   }
	  $output .= '</table>';
	 header('Content-Type: application/xls');
	 header('Content-Disposition: attachment; filename=download.xls');
	  echo $output;
	 }
	
	 
	 elseif(empty($_REQUEST['searchBy']))
			{
			  if($userType=='subscription')
			  {
			   if(!empty($_REQUEST['all']))
				{
				  
				  $result=$mysql->m_Query("select * from income where clientId=$userId and status='Approved' && userType='subscription' order by incomeDate desc");
				}
				elseif(!empty($_REQUEST['date1']))
				{
				
				 $date1=$_REQUEST['date1'];
				 $result=$mysql->m_Query("select * from income where clientId=$userId && incomeDate='$date1' and status='Approved' && userType='subscription' order by incomeDate desc");
				}
				elseif(!empty($_REQUEST['month']))
				{
				  
				  $month= $_REQUEST['month'];
				  $result=$mysql->m_Query("select * from income where clientId=$userId && Month(incomeDate)='$month' and status='Approved' && userType='subscription' order by incomeDate desc");
				}
			 }
			 elseif($userType=='trial')	
			 {
			 	 if(!empty($_REQUEST['all']))
				{
				  
				  $result=$mysql->m_Query("select * from income where userType='trial' and status='Approved' order by incomeDate desc");
				}
				elseif(!empty($_REQUEST['date1']))
				{
				
				 $date1=$_REQUEST['date1'];
				 $result=$mysql->m_Query("select * from income where userType='trial' && incomeDate='$date1' and status='Approved' order by incomeDate desc");
				}
				elseif(!empty($_REQUEST['month']))
				{
				  
				  $month= $_REQUEST['month'];
				  $result=$mysql->m_Query("select * from income where userType='trial' && Month(incomeDate)='$month' and status='Approved' order by incomeDate desc");
				}
			 }
			    $output .= '
	   			<table class="table" border="1">  
	  					 <tr><th colspan=6><h2 align=center border="1">INCOME STATEMENT</h1></th></tr>
						<tr>  
							 <th>S.No</th>
							 <th>Date</th>    
							 <th>Name</th>  
							 <th>Category</th>  
							 <th>Amount</th>
							 <th>Payment</th>
							
						</tr>';				$i=1;
						
							
							
							while($row=$mysql->m_FetchArray())
							{ 
								$date=date('d-m-Y',strtotime($row[incomeDate]));
								
								$output .= '
								<tr>
								 <td align=center>'.$i.'</td>  
								  <td align=right>'.$date.'</td> 
								 <td align=left>'.$row["name"].'</td>  
								 <td align=center>'.$row["category"].'</td>  
								 <td align=center>'.$row["amount"].'</td>  
								 <td align=center>'.$row["payment"].'</td>  
								  
								   
								</tr>
						   ';
						   $i++;
					   }
	  $output .= '</table>';
	 header('Content-Type: application/xls');
	 header('Content-Disposition: attachment; filename=download.xls');
	  echo $output;
	 }
	 
	}
?>

Edit Rename Chmod Delete

FILE FOLDER

Name	Size	Permission
Category	---	0755
PDF	---	0755
ajax	---	0755
assets	---	0755
barcodegen	---	0755
code	---	0755
css	---	0755
css1	---	0755
db-connect	---	0755
font-awesome	---	0755
fpdf	---	0755
img	---	0755
include	---	0755
js	---	0755
lib	---	0755
logincss	---	0755
upload	---	0755
Master-CMS.php	10170 bytes	0644
Master-Discount.php	4925 bytes	0644
Master-Expense.php	4608 bytes	0644
Master-Expenses.php	10961 bytes	0644
Master-Product.php	9087 bytes	0644
Master-Transpoter.php	9982 bytes	0644
Master-Vendor.php	9969 bytes	0644
Report-Account.php	10747 bytes	0644
Report-DateWiseExpense.php	7490 bytes	0644
Report-DateWiseExpenses.php	8076 bytes	0644
Report-Datewise.php	6753 bytes	0644
Report-DatewiseGST.php	7994 bytes	0644
Report-DatewiseGSTS.php	7429 bytes	0644
Report-Datewises.php	10563 bytes	0644
Report-LowStock.php	5746 bytes	0644
Report-PaymentMode.php	10139 bytes	0644
Report-Purchase.php	10743 bytes	0644
Report-Sale.php	10729 bytes	0644
Report-Stock.php	7119 bytes	0644
Report-TotalSale.php	12355 bytes	0644
Report-TotalSales.php	8346 bytes	0644
SearchAccount.php	9052 bytes	0644
SearchAccountGST.php	8106 bytes	0644
SearchAccountGSTs.php	5371 bytes	0644
SearchAccountold.php	9003 bytes	0644
accountStatment.php	6336 bytes	0644
accountstatements.php	9456 bytes	0644
activitylog.php	7178 bytes	0644
allMemberAccountExcel.php	1800 bytes	0644
allMemberReport.php	5358 bytes	0644
bill	11024 bytes	0644
bill - Copy.php	7314 bytes	0644
bill.php	6952 bytes	0644
billDetail - Copy (2).php	13781 bytes	0644
billDetail - Copy.php	13880 bytes	0644
billDetail.php	14851 bytes	0644
billDetailgst.php	10803 bytes	0644
billDetailold.php	13455 bytes	0644
billExcel.php	11066 bytes	0644
billHotel.php	7231 bytes	0644
billList.php	6034 bytes	0644
billListGST.php	5777 bytes	0644
billReport.php	22668 bytes	0644
billReport1.php	16948 bytes	0644
billgst.php	7455 bytes	0644
billpdf.php	6444 bytes	0644
challan.php	19095 bytes	0644
changePassword.php	5849 bytes	0644
client.php	9671 bytes	0644
clientExcel.php	1717 bytes	0644
clientMaster.php	8259 bytes	0644
clientPDF.php	1594 bytes	0644
clientReport.php	15622 bytes	0644
code.php	2732 bytes	0644
codes.png	46222 bytes	0644
collections.php	4825 bytes	0644
collectionss.php	4824 bytes	0644
conn.php	310 bytes	0644
convert.php	1873 bytes	0644
dashboardAdminMiddle.php	3646 bytes	0644
dashboardAdminTop.php	4735 bytes	0644
dashboardGraph.php	756 bytes	0644
dashboardMiddle.php	681 bytes	0644
dashboardTop.php	348 bytes	0644
dashboarduserDeactive.php	1871 bytes	0644
dateReport.php	5168 bytes	0644
draft.php	4879 bytes	0644
editDetails.php	5156 bytes	0644
epoll.png	40709 bytes	0644
excelprintbarcode.php	2432 bytes	0644
expense-Category.php	4941 bytes	0644
expense.php	10145 bytes	0644
expenseExcel.php	1300 bytes	0644
expenseReport.php	17628 bytes	0644
expenseReportExcel.php	5987 bytes	0644
expenseReportPDF.php	5867 bytes	0644
expensepdf.php	1250 bytes	0644
expensesReport.php	19961 bytes	0644
expensesReportExcel.php	6540 bytes	0644
expensesReportPDF.php	6429 bytes	0644
footer.php	806 bytes	0644
forget.php	3558 bytes	0644
gstRate-Category.php	4766 bytes	0644
headerpdf.php	362 bytes	0644
help.php	1781 bytes	0644
home.php	35491 bytes	0644
homecode.php	619 bytes	0644
income-Category.php	4914 bytes	0644
income-expenseReport.php	10350 bytes	0644
incomeExcel.php	1297 bytes	0644
incomeReport - Copy.php	16202 bytes	0644
incomeReportExcel.php	5968 bytes	0644
incomeReportPDF.php	5847 bytes	0644
incomepdf.php	1247 bytes	0644
incomesReport - Copy.php	15565 bytes	0644
incomesReport.php	19904 bytes	0644
incomesReportExcel.php	6499 bytes	0644
incomesReportPDF.php	6397 bytes	0644
index.php	2727 bytes	0644
invoice - Copy.php	11329 bytes	0644
invoice.php	18456 bytes	0644
invoice1.php	7780 bytes	0644
invoicePurchase.php	10155 bytes	0644
invoicegst.php	14556 bytes	0644
invoicegstjjj.php	8718 bytes	0644
invoices.php	2884 bytes	0644
invoicesgst.php	1170 bytes	0644
library.php	2399 bytes	0644
logincode - Copy.php	18484 bytes	0644
logincode.php	48629 bytes	0644
logincode.phpkk	38599 bytes	0644
logout.php	787 bytes	0644
master.php	761 bytes	0644
masters.php	642 bytes	0644
message.php	1544 bytes	0644
otp.php	3237 bytes	0644
overDue.php	11928 bytes	0644
overDue30days.php	11984 bytes	0644
overDue45days.php	12006 bytes	0644
overDue60days.php	12009 bytes	0644
overDued.php	11848 bytes	0644
pay.jpg	19656 bytes	0644
payment-Category.php	4806 bytes	0644
pays.png	175238 bytes	0644
pdf.php	1218 bytes	0644
pricing.php	4585 bytes	0644
print.php	4643 bytes	0644
print1.php	2120 bytes	0644
printCodes - Copy.php	6829 bytes	0644
printCodes.php	6899 bytes	0644
printCodesod.php	6831 bytes	0644
printCodesuu.php	6899 bytes	0644
prints.php	4675 bytes	0644
purchase.php	4352 bytes	0644
purchaseDetail - Copy (2).php	13710 bytes	0644
purchaseDetail - Copy.php	12127 bytes	0644
purchaseDetail.php	16612 bytes	0644
purchaseDetailsOLD.php	10395 bytes	0644
purchaselist.php	5669 bytes	0644
purchases.php	6289 bytes	0644
purchasesOLD.php	6474 bytes	0644
purchasetotal.php	6338 bytes	0644
recyclebill.php	6059 bytes	0644
recyclechallan.php	6032 bytes	0644
recycleclientaccount.php	8107 bytes	0644
recyclevendoraccount.php	8110 bytes	0644
report-purchaselist.php	7009 bytes	0644
sale.php	6256 bytes	0644
sales.php	6188 bytes	0644
setPassword.php	3871 bytes	0644
settings.php	4263 bytes	0644
signup-bg.jpg	57237 bytes	0644
stock.php	5526 bytes	0644
subscription.php	9136 bytes	0644
subscriptionReportExcel.php	5684 bytes	0644
subscriptionReportPDF.php	4914 bytes	0644
subscriptions - Copy.php	8515 bytes	0644
subscriptions.php	12262 bytes	0644
topHeader.php	2891 bytes	0644
transaction.php	11403 bytes	0644
transactionExcel.php	3995 bytes	0644
transactionPDF.php	3908 bytes	0644
transactionReport.php	10865 bytes	0644
transactions - Copy.php	12412 bytes	0644
transactions.php	16767 bytes	0644
transactions1.php	12447 bytes	0644
transactionsPDF.php	1564 bytes	0644
transactionsclient.php	17162 bytes	0644
trial.php	8883 bytes	0644
trialExcel.php	1699 bytes	0644
trialPDF.php	1503 bytes	0644
update.php	1972 bytes	0644
updateBill.php	8577 bytes	0644
updateClient.php	7248 bytes	0644
updateExpense.php	6178 bytes	0644
updateIncome.php	5806 bytes	0644
updatePTrans.php	5373 bytes	0644
updateProduct.php	35 bytes	0644
updateProducts.php	4516 bytes	0644
updateTrial.php	5901 bytes	0644
updateUser.php	7248 bytes	0644
updateVendor.php	4897 bytes	0644
updateVendor.phpd	4897 bytes	0644
updateVendors.php	120 bytes	0644
userDeactive.php	5901 bytes	0644
view-Client.php	5063 bytes	0644
view-Transactions.php	26489 bytes	0644
view-Transactions.phpjj	20390 bytes	0644
view-Transactions25-07-2023.php	17406 bytes	0644
view-Transactionsold.php	17729 bytes	0644
viewBill.php	10853 bytes	0644

File Content: incomesReportExcel.php

File Content: `incomesReportExcel.php`