<?php 
include 'dheader.php'; 
?>
	<div class="modal fade hidden-print" id="myModal" tabindex="-1" role="dialog" aria-hidden="true"></div>
	<div class="wrapper ">
		<?php include 'leftbar.php'; ?>
		<!-- left-bar -->
		<?php include 'topbar.php'; ?>
			<!-- top-bar -->
			<div class="main-content">

<form action="" method="get">
<div class="manage_buttons hidden-print">
	<div class="row">
	<div class="col-md-3">
			<div class="input-group input-daterange" id="reportrange2">	
                <span class="input-group-addon bg">Type</span>
                <select name="type" class=" form-control" id="search-select">
                	<option value="All" <?php echo ($_GET['type'] == 'All') ? 'selected':''; ?>>All</option>
                	<option value="Sale" <?php echo ($_GET['type'] == 'Sale') ? 'selected':''; ?>>Sale</option>
                	<option value="Purchase" <?php echo ($_GET['type'] == 'Purchase') ? 'selected':''; ?>>Purchase</option>
                	<option value="Return" <?php echo ($_GET['type'] == 'Return') ? 'selected':''; ?>>Return</option>
                	<option value="Misc" <?php echo ($_GET['type'] == 'Misc') ? 'selected':''; ?>>Misc</option>
                </select>
            </div>
		</div>

		<div class="col-md-3">
			<div class="input-group input-daterange" id="reportrange2">	
                <span class="input-group-addon bg">By</span>
                <select name="by" class=" form-control" id="search-select">
                	<option value="All" <?php echo ($_GET['by'] == 'All') ? 'selected':''; ?>>All</option>
                	<option value="Credit" <?php echo ($_GET['by'] == 'Credit') ? 'selected':''; ?>>Credit</option>
                	<option value="Cash" <?php echo ($_GET['by'] == 'Cash') ? 'selected':''; ?>>Cash</option>
                </select>
            </div>
		</div>

		<div class="col-md-2">
			<div class="input-group input-daterange" id="reportrange">
                <span class="input-group-addon bg">
                   From					                       	</span>
                <input type="text" class="form-control start_date datepicker" value="<?php echo $_GET['sdate']; ?>" name="sdate" id="sdate">
            </div>
		</div>
		<div class="col-md-2">
			<div class="input-group input-daterange" id="reportrange1">
                <span class="input-group-addon bg">
                    To			                                </span>
                <input type="text" value="<?php echo $_GET['edate']; ?>" class="form-control end_date datepicker" name="edate" id="edate">
            </div>	
		</div>
		<div class="col-md-2">
			<div class="input-group input-daterange" id="reportrange1">
		<button type="submit" title="Submit" class="btn btn-success">Submit</button>
			</div>
		</div>	
	</div>
</div>

</form>
	<div class="container-fluid">
		<div class="row manage-table">

	
			<div class="panel panel-piluku">
				<div class="panel-heading">
				<h3 class="panel-title">
				<?php
				if (isset($_GET['sdate'])) {
				
					$sdate = $_GET['sdate'];
					$scus_date = explode('/', $sdate);
					$sget_sdate = $scus_date[1].'/'.$scus_date[0].'/'.$scus_date[2];

					// End date
	             	$edate = $_GET['edate'];
					$ecus_date = explode('/', $edate);
					$get_edate = $ecus_date[1].'/'.$ecus_date[0].'/'.$ecus_date[2];
				}
				?>
					Reports - Sales Report	<?php echo @$sget_sdate; ?>-<?php echo @$get_edate; ?>		
					<span class="panel-options custom">
											</span>
				</h3>
			</div>
				<div class="panel-body nopadding table_holder table-responsive" >
					<table class="tablesorter table  table-hover" id="sortable_table">
						<thead>
							<tr>
								<th>Date</th>
								<th>Name</th>
								<th>User</th>
								<th>Invoice#</th>
								<th>Sale Type</th>
								<th>Pay Type</th>
								<th>Subtotal</th>
								<th>Received</th>
								<th>Grand Total</th>
								<th>Transport</th>
								<th>Remaining</th>
								<th>Profit</th>
								
							</tr>
						</thead>
						<tbody>
						<?php 
						if (isset($_GET['sdate'])) {
						?>
						<?php
							// Start date
							$sdate = $_GET['sdate'];
							$scus_date = explode('/', $sdate);
							$get_sdate = $scus_date[2].'/'.$scus_date[0].'/'.$scus_date[1];

							// End date
			             	$edate = $_GET['edate'];
							$ecus_date = explode('/', $edate);
							$get_edate = $ecus_date[2].'/'.$ecus_date[0].'/'.$ecus_date[1];

							// DISTINCT INVOICES
							$disInv = "SELECT DISTINCT invoiceNo FROM customerinvoice WHERE php_date BETWEEN '".$get_sdate."' AND '".$get_edate."' AND payment_type != 'Opening Balance'";
							if ($_GET['by'] == 'All') {
								$disInv .= "AND payment_type IN ('Credit', 'Cash') ";
							}else{
								$disInv .= "AND payment_type = '".$_GET['by']."' ";
							}
							if ($_GET['type'] == 'All') {
								$disInv .= "AND sale_type IN ('Sale', 'Return', 'Purchase', 'Misc')";
							}else{
								$disInv .= "AND sale_type = '".$_GET['type']."'";
							}

							$disInv = $db->query($disInv);

							$i = 0;
							$invoices = 0;
							$grandtotal = 0;
								$totalprofit = 0;
							while($fInv = $disInv->fetchArray()){ 
							$i++;
		            		$invoices = $i;
							
							$sql = "SELECT * FROM customerinvoice WHERE invoiceNo = '".$fInv['invoiceNo']."' AND php_date BETWEEN '".$get_sdate."' AND '".$get_edate."' AND payment_type != 'Opening Balance'";
							if ($_GET['by'] == 'All') {
								$sql .= "AND payment_type IN ('Credit', 'Cash') ";
							}else{
								$sql .= "AND payment_type = '".$_GET['by']."' ";
							}
							if ($_GET['type'] == 'All') {
								$sql .= "AND sale_type IN ('Sale', 'Return')";
							}else{
								$sql .= "AND sale_type = '".$_GET['type']."'";
							}
							
		            		$run = $db->query($sql);
		            		
		            		$row = $run->fetchArray(); 
		            		$grandtotal += $row['grand_total'];

		            		$sql2 = $db->query("SELECT * FROM customerinvoice WHERE invoiceNo = '".$fInv['invoiceNo']."' AND payment_type != 'Opening Balance'");
		            		$profit = 0;
						
		            		while($row2 = $sql2->fetchArray()){
		            			$profit += (($row2['sell'] - $row2['purchase']) * $row2['qty']) - $row2['discount_rs'] ;
		            		}
		            		$totalprofit += $profit;
		            		@$totalRemaining += $row['remaining'];
			            ?>    
			            	<tr>
			            		<td><?php echo $row['show_date']; ?></td>
			            		<td><?php echo $row['name_word']; ?></td>
			            		<td><?php echo $row['user_name']; ?></td>
			            		<td><?php echo $row['invoiceNo']; ?></td>
			            		<td><?php echo $row['sale_type']; ?></td>
			            		<td><?php echo $row['payment_type']; ?></td>
			            		<td><?php echo $row['subtotal']; ?></td>
			            		<td><?php echo ($row['received']) ? $row['received'] : 0; ?></td>
			            		<td><?php echo $row['grand_total']; ?></td>
			            		<td><?php echo ($row['transport_expense']) ? $row['transport_expense'] : 0; ?></td>
			            		<td><?php echo $row['remaining']; ?></td>
			            		<td><?php echo $profit; ?></td>
			            		
			            	</tr>


			            <?php } }?>

			            <?php
				            $sql2 = "SELECT * FROM other_accounts ";
				            $sql2 .= "WHERE title = 'Maal Khareed Cash' AND php_date BETWEEN '".$get_sdate."' AND '".$get_edate."' ";
				            $sql2 .= "ORDER BY php_date, id";
				            $run2 = $db->query($sql2);
				            while($row2 = $run2->fetchArray()){
				            	if ($row2['receive'] > 0) {
				            		$grandtotal -= $row2['receive'];
				            	}else{
				            		$grandtotal += $row2['payment'];
				            	}
				            	$cashPaid += $row2['payment'];
							?>	
								<tr>
										
									<td><?php echo $row2['show_date']; ?></td>
									<td><?php echo 'Other Account'; ?></td>
									<td><?php echo '-'; ?></td>
									<td><?php echo $row2['id']; ?></td>
				                    <td><?php echo $row2['description']; ?></td>
				                    <td><?php echo '-'; ?></td>
				                    <td><?php echo '-'; ?></td>
				                    <td><?php echo '-'; ?></td>
				                    <td><?php echo '-'; ?></td>
				                	<td><?php echo $row2['receive']; ?></td>
				                    <td><?php echo $row2['payment']; ?></td>
				      
				         
				                </tr>
				            <?php  } ?>

				            <?php if($_GET['type'] == 'Sale'){ ?>
			            	<tr>
								<td colspan="11" align="center" style="color: green;">Total Invoices : <?php echo $invoices; ?> & Total <?php echo $_GET['type']; ?> amount : <?php echo $grandtotal; ?></td>
							</tr>
							<?php } ?>
							<?php if($_GET['type'] == 'Purchase'){ ?>
							<tr>
								<td colspan="11" align="center" style="color: green;">Total Purchase Amount : <?php echo $totalRemaining; ?>
							</tr>
							<tr>
								<td colspan="11" align="center" style="color: green;">Maal Khareed Cash : <?php echo $cashPaid; ?>
							</tr>
							<tr>
								<td colspan="11" align="center" style="color: green;">Total Grand : <?php echo $totalRemaining + $cashPaid; ?>
							</tr>
							<?php } ?>
							</tbody>
						</table>			
				</div>	
		</div>	
				</div>
	</div>
</div>

			
<?php include 'dfooter.php'; ?>