public function fromtoday(Request $request)
 {
     $date = $request->input('submit');
     $branchid = $request->input('branchid');
     $fromdate = CommonController::date_format($request->input('fromdate'));
     $todate = CommonController::date_format($request->input('todate'));
     if ($date == 'today') {
         $date = Combo::callcombo('currentdate');
         //print_r($date);
         foreach ($date as $d) {
             $curdate = $d->curdate;
         }
         $fromdate = CommonController::date_format($curdate);
         $todate = CommonController::date_format($curdate);
         $fromdate = date("Y-m-d");
         $todate = date("Y-m-d");
         $factioyitems = DB::table('factioyitems')->join('users', 'users.id', '=', 'factioyitems.userid')->join('items', 'items.id', '=', 'factioyitems.itemsid')->whereBetween('factioyitems.created_at', array($fromdate, $todate))->where('factioyitems.userid', $branchid)->select('users.name as branchname', 'items.name as itemsname', 'factioyitems.slno')->get();
         return view('factorystockview', compact('value', 'value1', 'fromdate', 'todate', 'factioyitems'));
     } else {
         if ($date == 'fromdate') {
             $fromdate = CommonController::date_format($request->input('fromdate'));
             $todate = CommonController::date_format($request->input('todate'));
             $factioyitems = DB::table('factioyitems')->join('users', 'users.id', '=', 'factioyitems.userid')->join('items', 'items.id', '=', 'factioyitems.itemsid')->whereBetween('factioyitems.created_at', array($fromdate, $todate))->where('factioyitems.userid', $branchid)->select('users.name as branchname', 'items.name as itemsname', 'factioyitems.slno')->get();
             return view('factorystockview', compact('value', 'value1', 'fromdate', 'todate', 'factioyitems'));
         }
     }
 }
 public function today(Request $request)
 {
     $date = Combo::callcombo('currentdate');
     //print_r($date);
     foreach ($date as $d) {
         $curdate = $d->curdate;
     }
     $fromdate = CommonController::date_format($curdate);
     $todate = CommonController::date_format($curdate);
     $var = array($fromdate, $todate);
     $spname = "rptsales";
     $value = Info::callinfo($var, $spname);
     //print_r($value);
     return view('reportsaleview', compact('value', 'fromdate', 'todate'));
 }
Exemple #3
0
    public function printcollection()
    {
        $profile = Companyprofile::get();
        foreach ($profile as $com) {
            $id = $com->id;
            $cname = $com->name;
            $address = $com->address;
            $tele = $com->telephone;
            $mobile = $com->mobile;
            $email = $com->email;
            $url = $com->url;
            $file = $com->file;
        }
        $spname = "todaycollection";
        $c = Combo::callcombo($spname);
        $spname3 = "todaycash";
        $c5 = Combo::callcombo($spname3);
        $spname4 = "todaybankcollection";
        $c6 = Combo::callcombo($spname4);
        $spname5 = "todaycashcollection";
        $c7 = Combo::callcombo($spname5);
        $spname6 = "todaybkashcollection";
        $c8 = Combo::callcombo($spname6);
        $spsap = "todaysapcollection";
        $csap = Combo::callcombo($spsap);
        $spkcs = "todaykcscollection";
        $ckcs = Combo::callcombo($spkcs);
        $spmbank = "todaymbankcollection";
        $cmbank = Combo::callcombo($spmbank);
        foreach ($c6 as $cc) {
            $totalbankcash = $cc->cash;
        }
        foreach ($c7 as $ccc) {
            $totalhandcash = $ccc->cash;
        }
        foreach ($c8 as $ccc) {
            $totalbkash = $ccc->cash;
        }
        foreach ($csap as $ccc) {
            $totalsap = $ccc->cash;
        }
        foreach ($ckcs as $ccc) {
            $totalkcs = $ccc->cash;
        }
        foreach ($cmbank as $ccc) {
            $totalmbank = $ccc->cash;
        }
        $sum = 0;
        foreach ($c as $p) {
            $a = $p->amount;
            $sum = $sum + $a;
        }
        PDF::AddPage('L');
        $html1 = '
			<p></p>
				<div>
					<table>
						<tr>
							<td style="width:20%">
								<img src="uploads/' . $file . '" alt="logo" height="150";>
							</td>
							<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $address . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
							</td>
						</tr>

					</table>	
				</div>
						
						<h2>
					    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						<u>Statement of Daily Collection</u></h2><h4><br>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						Date: ' . date("d/m/Y") . '  To  ' . date("d/m/Y") . '</h4>
						</div>
						
				<table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
					<tr>
						<th style="width:3%;">SL</th>
						<th style="width:10%;">Name</th>
						<th style="width:12%;">Present Address</th>
						<th>Amount</th>
						<th style="width:7%;">Voucher No.</th>
						<th>Bank Amount</th>
						<th>Cash</th>
						<th>BKash</th>
						<th>SAP</th>
						<th>KCS</th>
						<th>MBank</th>
						<th>Total</th>
					</tr>';
        $html2 = '';
        $i = 1;
        $sum = 0;
        foreach ($c as $p) {
            if ($p->type == 3) {
                $bankamount = $p->amount;
                $cashamount = '';
                $bkash = '';
                $sap = '';
                $kcs = '';
                $mbank = '';
            } else {
                if ($p->type == 4) {
                    $bankamount = '';
                    $cashamount = $p->amount;
                    $bkash = '';
                    $sap = '';
                    $kcs = '';
                    $mbank = '';
                } else {
                    if ($p->type == 6) {
                        $bankamount = '';
                        $cashamount = '';
                        $bkash = $p->amount;
                        $sap = '';
                        $kcs = '';
                        $mbank = '';
                    } else {
                        if ($p->type == 7) {
                            $bankamount = '';
                            $cashamount = '';
                            $bkash = '';
                            $sap = $p->amount;
                            $kcs = '';
                            $mbank = '';
                        } else {
                            if ($p->type == 8) {
                                $bankamount = '';
                                $cashamount = '';
                                $bkash = '';
                                $sap = '';
                                $kcs = $p->amount;
                                $mbank = '';
                            } else {
                                if ($p->type == 9) {
                                    $bankamount = '';
                                    $cashamount = '';
                                    $bkash = '';
                                    $sap = '';
                                    $kcs = '';
                                    $mbank = $p->amount;
                                }
                            }
                        }
                    }
                }
            }
            $html = '<tr><td style="background-color:#ffffff;">' . $i . '</td>
				<td style="background-color:#ffffff;">' . $p->name . '</td>
				<td style="background-color:#ffffff;">' . $p->preaddress . '</td>
				<td style="background-color:#ffffff;">' . $p->amount . '</td>
				<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $p->id . '/' . $p->type . '"   target="_blank">' . $p->vnno . '</a></td>					
				<td style="background-color:#ffffff;">' . $bankamount . '</td>
				<td style="background-color:#ffffff;">' . $cashamount . '</td>
				<td style="background-color:#ffffff;">' . $bkash . '</td>
				<td style="background-color:#ffffff;">' . $sap . '</td>
				<td style="background-color:#ffffff;">' . $kcs . '</td>
				<td style="background-color:#ffffff;">' . $mbank . '</td>
				<td style="background-color:#ffffff;">' . $p->amount . '</td>
				</tr>';
            $html2 = $html2 . $html;
            $i++;
            $sum = $sum + $p->amount;
        }
        $html3 = '<tr><td colspan="5" align="right" style="background-color:#ffffff;">';
        $html4 = '';
        $html5 = 'Total:</td>
				<td style="background-color:#ffffff;">' . $totalbankcash . '</td>
				<td style="background-color:#ffffff;">' . $totalhandcash . '</td>
				<td style="background-color:#ffffff;">' . $totalbkash . '</td>
				<td style="background-color:#ffffff;">' . $totalsap . '</td>
				<td style="background-color:#ffffff;">' . $totalkcs . '</td>
				<td style="background-color:#ffffff;">' . $totalmbank . '</td>
				<td style="background-color:#ffffff;">' . number_format($sum, 2, '.', '') . '</td></tr>';
        $html6 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord(number_format($sum, 2, '.', '')) . ' Taka Only</h4></div>
						<div>
					
						</div>
						<div class="col-md-12"  style=" background-color: #ffffff;color:#000000;">
						<h3>&nbsp;&nbsp;&nbsp; Prepared By
		                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;						
						  Checked By
						  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


						Approved By
						  </h3>
						
						
							
						</div>';
        $html = $html1 . $html2 . $html3 . $html4 . $html5 . $html6;
        PDF::writeHTML($html, true, false, true, false, '');
        PDF::Output('vp.pdf');
    }
    public function printpdf(Request $request)
    {
        $profile = Companyprofile::get();
        foreach ($profile as $com) {
            $cid = $com->id;
            $cname = $com->name;
            $aaddress = $com->address;
            $tele = $com->telephone;
            $mobile = $com->mobile;
            $email = $com->email;
            $url = $com->url;
            $file = $com->file;
        }
        $date = $request->input('submit');
        $id = $request->input('id');
        //return '44444';
        if ($date == 'today') {
            $date = Combo::callcombo('currentdate');
            //print_r($date);
            foreach ($date as $d) {
                $curdate = $d->curdate;
            }
            $fromdate = CommonController::date_format($curdate);
            $todate = CommonController::date_format($curdate);
            $fromdate = date("Y-m-d");
            $todate = date("Y-m-d");
            $var = array($id, $fromdate, $todate);
            if ($id == 2) {
                $spname = "sub_ledger_voucher";
                $value = Info::callinfo($var, $spname);
                //print_r($value); die();
                if ($value == NULL) {
                    echo '<h1>Data not found</h1>';
                    die;
                }
                foreach ($value as $valu) {
                    $opbalance = $valu->openbalance;
                }
                $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                $previousbalance = DB::table('voucher')->where('type', 4)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                // echo $previousbalance; die();
                $openbalance = $opbalance + $previousbalance;
                $fdate = date_create($curdate);
                $tdate = date_create($curdate);
                PDF::AddPage();
                $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Cash Collection A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			 ';
                $html2 = '';
                $total = 0.0;
                foreach ($value as $valu) {
                    $id = $valu->id;
                    $amount = $valu->amount;
                    $vnno = $valu->vnno;
                    $name = $valu->name;
                    $dc = $valu->dc;
                    $vdate = $valu->vdate;
                    $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                    $html2 = $html2 . $ht;
                    $total = $total + $amount;
                }
                $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                $html5 = '';
                $html6 = '</table>';
                $html = $html1 . $html2 . $html3 . $html5 . $html6;
                PDF::writeHTML($html, true, false, true, false, '');
                PDF::Output('subledgerentry.pdf');
            } else {
                if ($id == 3) {
                    $spname = "sub_ledger_voucher";
                    $value = Info::callinfo($var, $spname);
                    //print_r($value); die();
                    if ($value == NULL) {
                        echo '<h1>Data not found</h1>';
                        die;
                    }
                    foreach ($value as $valu) {
                        $opbalance = $valu->openbalance;
                    }
                    $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                    $previousbalance = DB::table('voucher')->where('type', 2)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                    // echo $previousbalance; die();
                    $openbalance = $opbalance + $previousbalance;
                    $fdate = date_create($curdate);
                    $tdate = date_create($curdate);
                    PDF::AddPage();
                    $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Cash Payment A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  ';
                    $html2 = '';
                    $total = 0.0;
                    foreach ($value as $valu) {
                        $id = $valu->id;
                        $amount = $valu->amount;
                        $vnno = $valu->vnno;
                        $name = $valu->name;
                        $dc = $valu->dc;
                        $vdate = $valu->vdate;
                        $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                        $html2 = $html2 . $ht;
                        $total = $total + $amount;
                    }
                    $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                    $html5 = '';
                    $html6 = '</table>';
                    $html = $html1 . $html2 . $html3 . $html5 . $html6;
                    PDF::writeHTML($html, true, false, true, false, '');
                    PDF::Output('subledgerentry.pdf');
                } else {
                    if ($id == 4) {
                        $spname = "sub_ledger_voucher";
                        $value = Info::callinfo($var, $spname);
                        //print_r($value); die();
                        if ($value == NULL) {
                            echo '<h1>Data not found</h1>';
                            die;
                        }
                        foreach ($value as $valu) {
                            $opbalance = $valu->openbalance;
                        }
                        $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                        $previousbalance = DB::table('voucher')->where('type', 6)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                        // echo $previousbalance; die();
                        $openbalance = $opbalance + $previousbalance;
                        $fdate = date_create($curdate);
                        $tdate = date_create($curdate);
                        PDF::AddPage();
                        $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Bkash A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                        $html2 = '';
                        $total = $openbalance;
                        foreach ($value as $valu) {
                            $id = $valu->id;
                            $amount = $valu->amount;
                            $vnno = $valu->vnno;
                            $name = $valu->name;
                            $dc = $valu->dc;
                            $vdate = $valu->vdate;
                            $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                            $html2 = $html2 . $ht;
                            $total = $total + $amount;
                        }
                        $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                        $html5 = '';
                        $html6 = '</table>';
                        $html = $html1 . $html2 . $html3 . $html5 . $html6;
                        PDF::writeHTML($html, true, false, true, false, '');
                        PDF::Output('subledgerentry.pdf');
                    } else {
                        if ($id == 5) {
                            $spname = "sub_ledger_voucher";
                            $value = Info::callinfo($var, $spname);
                            //print_r($value); die();
                            if ($value == NULL) {
                                echo '<h1>Data not found</h1>';
                                die;
                            }
                            foreach ($value as $valu) {
                                $opbalance = $valu->openbalance;
                            }
                            $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                            $previousbalance = DB::table('voucher')->where('type', 7)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                            // echo $previousbalance; die();
                            $openbalance = $opbalance + $previousbalance;
                            $fdate = date_create($curdate);
                            $tdate = date_create($curdate);
                            PDF::AddPage();
                            $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									SAP A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                            $html2 = '';
                            $total = $openbalance;
                            foreach ($value as $valu) {
                                $id = $valu->id;
                                $amount = $valu->amount;
                                $vnno = $valu->vnno;
                                $name = $valu->name;
                                $dc = $valu->dc;
                                $vdate = $valu->vdate;
                                $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                $html2 = $html2 . $ht;
                                $total = $total + $amount;
                            }
                            $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                            $html5 = '';
                            $html6 = '</table>';
                            $html = $html1 . $html2 . $html3 . $html5 . $html6;
                            PDF::writeHTML($html, true, false, true, false, '');
                            PDF::Output('subledgerentry.pdf');
                        } else {
                            if ($id == 6) {
                                $spname = "sub_ledger_voucher";
                                $value = Info::callinfo($var, $spname);
                                //print_r($value); die();
                                if ($value == NULL) {
                                    echo '<h1>Data not found</h1>';
                                    die;
                                }
                                foreach ($value as $valu) {
                                    $opbalance = $valu->openbalance;
                                }
                                $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                $previousbalance = DB::table('voucher')->where('type', 8)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                // echo $previousbalance; die();
                                $openbalance = $opbalance + $previousbalance;
                                $fdate = date_create($curdate);
                                $tdate = date_create($curdate);
                                PDF::AddPage();
                                $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									KCS A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                $html2 = '';
                                $total = $openbalance;
                                foreach ($value as $valu) {
                                    $id = $valu->id;
                                    $amount = $valu->amount;
                                    $vnno = $valu->vnno;
                                    $name = $valu->name;
                                    $dc = $valu->dc;
                                    $vdate = $valu->vdate;
                                    $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                    $html2 = $html2 . $ht;
                                    $total = $total + $amount;
                                }
                                $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                $html5 = '';
                                $html6 = '</table>';
                                $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                PDF::writeHTML($html, true, false, true, false, '');
                                PDF::Output('subledgerentry.pdf');
                            } else {
                                if ($id == 7) {
                                    $spname = "sub_ledger_voucher";
                                    $value = Info::callinfo($var, $spname);
                                    //print_r($value); die();
                                    if ($value == NULL) {
                                        echo '<h1>Data not found</h1>';
                                        die;
                                    }
                                    foreach ($value as $valu) {
                                        $opbalance = $valu->openbalance;
                                    }
                                    $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                    $previousbalance = DB::table('voucher')->where('type', 9)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                    // echo $previousbalance; die();
                                    $openbalance = $opbalance + $previousbalance;
                                    $fdate = date_create($curdate);
                                    $tdate = date_create($curdate);
                                    PDF::AddPage();
                                    $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									MBank A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                    $html2 = '';
                                    $total = $openbalance;
                                    foreach ($value as $valu) {
                                        $id = $valu->id;
                                        $amount = $valu->amount;
                                        $vnno = $valu->vnno;
                                        $name = $valu->name;
                                        $dc = $valu->dc;
                                        $vdate = $valu->vdate;
                                        $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                        $html2 = $html2 . $ht;
                                        $total = $total + $amount;
                                    }
                                    $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                    $html5 = '';
                                    $html6 = '</table>';
                                    $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                    PDF::writeHTML($html, true, false, true, false, '');
                                    PDF::Output('subledgerentry.pdf');
                                } else {
                                    if ($id == 8) {
                                        $spname = "sub_ledger_voucher";
                                        $value = Info::callinfo($var, $spname);
                                        //print_r($value); die();
                                        if ($value == NULL) {
                                            echo '<h1>Data not found</h1>';
                                            die;
                                        }
                                        foreach ($value as $valu) {
                                            $opbalance = $valu->openbalance;
                                        }
                                        $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                        $previousbalance = DB::table('voucher')->where('type', 3)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                        // echo $previousbalance; die();
                                        $openbalance = $opbalance + $previousbalance;
                                        $fdate = date_create($curdate);
                                        $tdate = date_create($curdate);
                                        PDF::AddPage();
                                        $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Bank Collection A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                        $html2 = '';
                                        $total = $openbalance;
                                        foreach ($value as $valu) {
                                            $id = $valu->id;
                                            $amount = $valu->amount;
                                            $vnno = $valu->vnno;
                                            $name = $valu->name;
                                            $dc = $valu->dc;
                                            $vdate = $valu->vdate;
                                            $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                            $html2 = $html2 . $ht;
                                            $total = $total + $amount;
                                        }
                                        $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                        $html5 = '';
                                        $html6 = '</table>';
                                        $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                        PDF::writeHTML($html, true, false, true, false, '');
                                        PDF::Output('subledgerentry.pdf');
                                    } else {
                                        if ($id == 9) {
                                            $spname = "sub_ledger_voucher";
                                            $value = Info::callinfo($var, $spname);
                                            //print_r($value); die();
                                            if ($value == NULL) {
                                                echo '<h1>Data not found</h1>';
                                                die;
                                            }
                                            foreach ($value as $valu) {
                                                $opbalance = $valu->openbalance;
                                            }
                                            $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                            $previousbalance = DB::table('voucher')->where('type', 1)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                            // echo $previousbalance; die();
                                            $openbalance = $opbalance + $previousbalance;
                                            $fdate = date_create($curdate);
                                            $tdate = date_create($curdate);
                                            PDF::AddPage();
                                            $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Bank Payment A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                            $html2 = '';
                                            $total = $openbalance;
                                            foreach ($value as $valu) {
                                                $id = $valu->id;
                                                $amount = $valu->amount;
                                                $vnno = $valu->vnno;
                                                $name = $valu->name;
                                                $dc = $valu->dc;
                                                $vdate = $valu->vdate;
                                                $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                $html2 = $html2 . $ht;
                                                $total = $total + $amount;
                                            }
                                            $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                            $html5 = '';
                                            $html6 = '</table>';
                                            $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                            PDF::writeHTML($html, true, false, true, false, '');
                                            PDF::Output('subledgerentry.pdf');
                                        } else {
                                            if ($id == 11) {
                                                $spname = "sub_ledger_voucher";
                                                $value = Info::callinfo($var, $spname);
                                                //print_r($value);
                                                if ($value == NULL) {
                                                    echo '<h1>Data not found</h1>';
                                                    die;
                                                }
                                                foreach ($value as $valu) {
                                                    $opbalance = $valu->openbalance;
                                                }
                                                $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                                $previousbalance = DB::table('sales')->where('status', 1)->where('created_at', '<', $previousdate)->sum('gamount');
                                                // echo $previousbalance; die();
                                                $openbalance = $opbalance + $previousbalance;
                                                $fdate = date_create($curdate);
                                                $tdate = date_create($curdate);
                                                PDF::AddPage();
                                                $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Sales A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Invoice No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . $openbalance . '</th>
				<th></th>
			  </tr>';
                                                $html2 = '';
                                                $total = $openbalance;
                                                foreach ($value as $valu) {
                                                    $amount = $valu->gamount;
                                                    $salesname = $valu->salesname;
                                                    $name = $valu->cname;
                                                    $dc = $valu->dc;
                                                    $vdate = $valu->salesdate;
                                                    $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/physicalsales/print/' . $valu->id . '"   target="_blank">' . $salesname . '</a></td>

					
					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                    $html2 = $html2 . $ht;
                                                    $total = $total + $amount;
                                                }
                                                $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                $html5 = '';
                                                $html6 = '</table>';
                                                $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                PDF::writeHTML($html, true, false, true, false, '');
                                                PDF::Output('subledgerentry.pdf');
                                            } else {
                                                if ($id == 12) {
                                                    $spname = "sub_ledger_voucher";
                                                    $value = Info::callinfo($var, $spname);
                                                    //print_r($value);
                                                    if ($value == NULL) {
                                                        echo '<h1>Data not found</h1>';
                                                        die;
                                                    }
                                                    foreach ($value as $valu) {
                                                        $opbalance = $valu->openbalance;
                                                    }
                                                    $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                                    $previousbalance = DB::table('purchase')->where('status', 1)->where('created_at', '<', $previousdate)->sum('gross_total');
                                                    // echo $previousbalance; die();
                                                    $openbalance = $opbalance + $previousbalance;
                                                    $fdate = date_create($curdate);
                                                    $tdate = date_create($curdate);
                                                    PDF::AddPage();
                                                    $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Purchase A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Purchase No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . $openbalance . '</th>
				<th></th>
			  </tr>';
                                                    $html2 = '';
                                                    $total = $openbalance;
                                                    foreach ($value as $valu) {
                                                        $purchasename = $valu->purchasename;
                                                        $purchasedate = $valu->purchasedate;
                                                        $gross_total = $valu->gross_total;
                                                        $dc = $valu->dc;
                                                        $sname = $valu->sname;
                                                        $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $purchasedate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $sname . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/purchase/pdf/' . $valu->id . '"   target="_blank">' . $purchasename . '</a></td>
					
					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $gross_total . '</td>
				</tr>';
                                                        $html2 = $html2 . $ht;
                                                        $total = $total + $gross_total;
                                                    }
                                                    $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                    $html5 = '';
                                                    $html6 = '</table>';
                                                    $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                    PDF::writeHTML($html, true, false, true, false, '');
                                                    PDF::Output('subledgerentry.pdf');
                                                } else {
                                                    if ($id == 13) {
                                                        $spname = "sub_ledger_voucher";
                                                        $value = Info::callinfo($var, $spname);
                                                        //	print_r($value);
                                                        if ($value == NULL) {
                                                            echo '<h1>Data not found</h1>';
                                                            die;
                                                        }
                                                        foreach ($value as $valu) {
                                                            $opbalance = $valu->openbalance;
                                                        }
                                                        $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                                        $previousbalance = DB::table('employeesal')->where('created_at', '<', $previousdate)->sum('amount');
                                                        // echo $previousbalance; die();
                                                        $openbalance = $opbalance + $previousbalance;
                                                        $fdate = date_create($curdate);
                                                        $tdate = date_create($curdate);
                                                        PDF::AddPage();
                                                        $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Salary A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Employee Name</th>
				<th>Description</th>
				
				<th >&nbsp;Particulars</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th>
 				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . $openbalance . '</th>
				<th></th>
			  </tr>';
                                                        $html2 = '';
                                                        $total = $openbalance;
                                                        foreach ($value as $valu) {
                                                            $employeename = $valu->employeename;
                                                            $amount = $valu->amount;
                                                            $particularsname = $valu->particularsname;
                                                            $vdate = $valu->vdate;
                                                            $description = $valu->description;
                                                            $dc = $valu->dc;
                                                            $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $employeename . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $description . '</td>
					<td style="background-color:#ffffff;">' . $particularsname . '</td>
					
					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                            $html2 = $html2 . $ht;
                                                            $total = $total + $amount;
                                                        }
                                                        $html3 = '<tr><td colspan="5" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                        $html5 = '';
                                                        $html6 = '</table>';
                                                        $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                        PDF::writeHTML($html, true, false, true, false, '');
                                                        PDF::Output('subledgerentry.pdf');
                                                    } else {
                                                        //print_r($value);
                                                        $spname = "generalledger";
                                                        $value = Info::callinfo($var, $spname);
                                                        //print_r($value);die();
                                                        if ($value == NULL) {
                                                            echo '<h1>Data not found</h1>';
                                                            die;
                                                        }
                                                        foreach ($value as $valu) {
                                                            $id = $valu->id;
                                                            $amount = $valu->amount;
                                                            $description = $valu->description;
                                                            $name = $valu->name;
                                                            $dc = $valu->dc;
                                                            $created_at = $valu->created_at;
                                                            $openbalance = $valu->openbalance;
                                                        }
                                                        $fdate = date_create($fromdate);
                                                        $tdate = date_create($todate);
                                                        PDF::AddPage();
                                                        $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Ledger Account</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
								<div>

								 <table border="1" style="width:100%; padding:20px;">
									
									<tr>
										
										<td  style="width:20%">Accounts of:</td>
										
										<td  style="width:80%">' . $name . '</td>
										
									</tr>
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . $openbalance . '</th>
				<th></th>
			  </tr>';
                                                        $html2 = '';
                                                        $total = $openbalance;
                                                        foreach ($value as $valu) {
                                                            $id = $valu->id;
                                                            $amount = $valu->amount;
                                                            $description = $valu->description;
                                                            $name = $valu->name;
                                                            $dc = $valu->dc;
                                                            $created_at = $valu->created_at;
                                                            $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $created_at . '</td>
					<td style="background-color:#ffffff;">' . $description . '</td>

					<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/ledgerentry/pdf/' . $valu->id . '"   target="_blank">' . $id . '</a></td>
					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                            $html2 = $html2 . $ht;
                                                            $total = $total + $amount;
                                                        }
                                                        $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                        $html5 = '';
                                                        $html6 = '</table></div>';
                                                        $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                        PDF::writeHTML($html, true, false, true, false, '');
                                                        PDF::Output('subledgerentry.pdf');
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        } else {
            if ($date == 'fromdate') {
                $fromdate = CommonController::date_format($request->input('fromdate'));
                $todate = CommonController::date_format($request->input('todate'));
                $var = array($id, $fromdate, $todate);
                if ($id == 2) {
                    $spname = "sub_ledger_voucher";
                    $value = Info::callinfo($var, $spname);
                    //print_r($value); die();
                    if ($value == NULL) {
                        echo '<h1>Data not found</h1>';
                        die;
                    }
                    foreach ($value as $valu) {
                        $opbalance = $valu->openbalance;
                    }
                    $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                    $previousbalance = DB::table('voucher')->where('type', 4)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                    // echo $previousbalance; die();
                    $openbalance = $opbalance + $previousbalance;
                    $fdate = date_create($fromdate);
                    $tdate = date_create($todate);
                    PDF::AddPage();
                    $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Cash Collection A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                    $html2 = '';
                    $total = $openbalance;
                    foreach ($value as $valu) {
                        $id = $valu->id;
                        $amount = $valu->amount;
                        $vnno = $valu->vnno;
                        $name = $valu->name;
                        $dc = $valu->dc;
                        $vdate = $valu->vdate;
                        $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                        $html2 = $html2 . $ht;
                        $total = $total + $amount;
                    }
                    $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                    $html5 = '';
                    $html6 = '</table>';
                    $html = $html1 . $html2 . $html3 . $html5 . $html6;
                    PDF::writeHTML($html, true, false, true, false, '');
                    PDF::Output('subledgerentry.pdf');
                } else {
                    if ($id == 3) {
                        $spname = "sub_ledger_voucher";
                        $value = Info::callinfo($var, $spname);
                        //print_r($value);
                        if ($value == NULL) {
                            echo '<h1>Data not found</h1>';
                            die;
                        }
                        foreach ($value as $valu) {
                            $opbalance = $valu->openbalance;
                        }
                        $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                        $previousbalance = DB::table('voucher')->where('type', 2)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                        // echo $previousbalance; die();
                        $openbalance = $opbalance + $previousbalance;
                        $fdate = date_create($fromdate);
                        $tdate = date_create($todate);
                        PDF::AddPage();
                        $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Cash Payment A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                        $html2 = '';
                        $total = $openbalance;
                        foreach ($value as $valu) {
                            $amount = $valu->amount;
                            $vnno = $valu->vnno;
                            $name = $valu->name;
                            $dc = $valu->dc;
                            $vdate = $valu->vdate;
                            $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                            $html2 = $html2 . $ht;
                            $total = $total + $amount;
                        }
                        $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                        $html5 = '';
                        $html6 = '</table>';
                        $html = $html1 . $html2 . $html3 . $html5 . $html6;
                        PDF::writeHTML($html, true, false, true, false, '');
                        PDF::Output('subledgerentry.pdf');
                    } else {
                        if ($id == 4) {
                            $spname = "sub_ledger_voucher";
                            $value = Info::callinfo($var, $spname);
                            //print_r($value);
                            if ($value == NULL) {
                                echo '<h1>Data not found</h1>';
                                die;
                            }
                            foreach ($value as $valu) {
                                $opbalance = $valu->openbalance;
                            }
                            $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                            $previousbalance = DB::table('voucher')->where('type', 6)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                            // echo $previousbalance; die();
                            $openbalance = $opbalance + $previousbalance;
                            $fdate = date_create($fromdate);
                            $tdate = date_create($todate);
                            PDF::AddPage();
                            $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Bkash A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                            $html2 = '';
                            $total = $openbalance;
                            foreach ($value as $valu) {
                                $amount = $valu->amount;
                                $vnno = $valu->vnno;
                                $name = $valu->name;
                                $dc = $valu->dc;
                                $vdate = $valu->vdate;
                                $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                $html2 = $html2 . $ht;
                                $total = $total + $amount;
                            }
                            $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                            $html5 = '';
                            $html6 = '</table>';
                            $html = $html1 . $html2 . $html3 . $html5 . $html6;
                            PDF::writeHTML($html, true, false, true, false, '');
                            PDF::Output('subledgerentry.pdf');
                        } else {
                            if ($id == 5) {
                                $spname = "sub_ledger_voucher";
                                $value = Info::callinfo($var, $spname);
                                //print_r($value);
                                if ($value == NULL) {
                                    echo '<h1>Data not found</h1>';
                                    die;
                                }
                                foreach ($value as $valu) {
                                    $opbalance = $valu->openbalance;
                                }
                                $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                $previousbalance = DB::table('voucher')->where('type', 7)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                // echo $previousbalance; die();
                                $openbalance = $opbalance + $previousbalance;
                                $fdate = date_create($fromdate);
                                $tdate = date_create($todate);
                                PDF::AddPage();
                                $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									SAP A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                $html2 = '';
                                $total = $openbalance;
                                foreach ($value as $valu) {
                                    $amount = $valu->amount;
                                    $vnno = $valu->vnno;
                                    $name = $valu->name;
                                    $dc = $valu->dc;
                                    $vdate = $valu->vdate;
                                    $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                    $html2 = $html2 . $ht;
                                    $total = $total + $amount;
                                }
                                $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                $html5 = '';
                                $html6 = '</table>';
                                $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                PDF::writeHTML($html, true, false, true, false, '');
                                PDF::Output('subledgerentry.pdf');
                            } else {
                                if ($id == 6) {
                                    $spname = "sub_ledger_voucher";
                                    $value = Info::callinfo($var, $spname);
                                    //print_r($value);
                                    if ($value == NULL) {
                                        echo '<h1>Data not found</h1>';
                                        die;
                                    }
                                    foreach ($value as $valu) {
                                        $opbalance = $valu->openbalance;
                                    }
                                    $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                    $previousbalance = DB::table('voucher')->where('type', 8)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                    // echo $previousbalance; die();
                                    $openbalance = $opbalance + $previousbalance;
                                    $fdate = date_create($fromdate);
                                    $tdate = date_create($todate);
                                    PDF::AddPage();
                                    $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									KCS A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                    $html2 = '';
                                    $total = $openbalance;
                                    foreach ($value as $valu) {
                                        $amount = $valu->amount;
                                        $vnno = $valu->vnno;
                                        $name = $valu->name;
                                        $dc = $valu->dc;
                                        $vdate = $valu->vdate;
                                        $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                        $html2 = $html2 . $ht;
                                        $total = $total + $amount;
                                    }
                                    $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                    $html5 = '';
                                    $html6 = '</table>';
                                    $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                    PDF::writeHTML($html, true, false, true, false, '');
                                    PDF::Output('subledgerentry.pdf');
                                } else {
                                    if ($id == 7) {
                                        $spname = "sub_ledger_voucher";
                                        $value = Info::callinfo($var, $spname);
                                        //print_r($value);
                                        if ($value == NULL) {
                                            echo '<h1>Data not found</h1>';
                                            die;
                                        }
                                        foreach ($value as $valu) {
                                            $opbalance = $valu->openbalance;
                                        }
                                        $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                        $previousbalance = DB::table('voucher')->where('type', 9)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                        // echo $previousbalance; die();
                                        $openbalance = $opbalance + $previousbalance;
                                        $fdate = date_create($fromdate);
                                        $tdate = date_create($todate);
                                        PDF::AddPage();
                                        $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									MBank A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                        $html2 = '';
                                        $total = $openbalance;
                                        foreach ($value as $valu) {
                                            $amount = $valu->amount;
                                            $vnno = $valu->vnno;
                                            $name = $valu->name;
                                            $dc = $valu->dc;
                                            $vdate = $valu->vdate;
                                            $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                            $html2 = $html2 . $ht;
                                            $total = $total + $amount;
                                        }
                                        $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                        $html5 = '';
                                        $html6 = '</table>';
                                        $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                        PDF::writeHTML($html, true, false, true, false, '');
                                        PDF::Output('subledgerentry.pdf');
                                    } else {
                                        if ($id == 8) {
                                            $spname = "sub_ledger_voucher";
                                            $value = Info::callinfo($var, $spname);
                                            //print_r($value);
                                            if ($value == NULL) {
                                                echo '<h1>Data not found</h1>';
                                                die;
                                            }
                                            foreach ($value as $valu) {
                                                $opbalance = $valu->openbalance;
                                            }
                                            $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                            $previousbalance = DB::table('voucher')->where('type', 3)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                            // echo $previousbalance; die();
                                            $openbalance = $opbalance + $previousbalance;
                                            $fdate = date_create($fromdate);
                                            $tdate = date_create($todate);
                                            PDF::AddPage();
                                            $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Bank Collection A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                            $html2 = '';
                                            $total = $openbalance;
                                            foreach ($value as $valu) {
                                                $id = $valu->id;
                                                $amount = $valu->amount;
                                                $vnno = $valu->vnno;
                                                $name = $valu->name;
                                                $dc = $valu->dc;
                                                $vdate = $valu->vdate;
                                                $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                $html2 = $html2 . $ht;
                                                $total = $total + $amount;
                                            }
                                            $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                            $html5 = '';
                                            $html6 = '</table>';
                                            $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                            PDF::writeHTML($html, true, false, true, false, '');
                                            PDF::Output('subledgerentry.pdf');
                                        } else {
                                            if ($id == 9) {
                                                $spname = "sub_ledger_voucher";
                                                $value = Info::callinfo($var, $spname);
                                                //print_r($value);
                                                if ($value == NULL) {
                                                    echo '<h1>Data not found</h1>';
                                                    die;
                                                }
                                                foreach ($value as $valu) {
                                                    $opbalance = $valu->openbalance;
                                                }
                                                $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                                $previousbalance = DB::table('voucher')->where('type', 1)->where('vstatus', 1)->where('created_at', '<', $previousdate)->sum('amount');
                                                // echo $previousbalance; die();
                                                $openbalance = $opbalance + $previousbalance;
                                                $fdate = date_create($fromdate);
                                                $tdate = date_create($todate);
                                                PDF::AddPage();
                                                $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Bank Payment A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                                $html2 = '';
                                                $total = $openbalance;
                                                foreach ($value as $valu) {
                                                    $amount = $valu->amount;
                                                    $vnno = $valu->vnno;
                                                    $name = $valu->name;
                                                    $dc = $valu->dc;
                                                    $vdate = $valu->vdate;
                                                    $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type . '"   target="_blank">' . $vnno . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                    $html2 = $html2 . $ht;
                                                    $total = $total + $amount;
                                                }
                                                $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                $html5 = '';
                                                $html6 = '</table>';
                                                $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                PDF::writeHTML($html, true, false, true, false, '');
                                                PDF::Output('subledgerentry.pdf');
                                            } else {
                                                if ($id == 11) {
                                                    $spname = "sub_ledger_voucher";
                                                    $value = Info::callinfo($var, $spname);
                                                    //print_r($value);
                                                    if ($value == NULL) {
                                                        echo '<h1>Data not found</h1>';
                                                        die;
                                                    }
                                                    foreach ($value as $valu) {
                                                        $opbalance = $valu->openbalance;
                                                    }
                                                    $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                                    $previousbalance = DB::table('sales')->where('status', 1)->where('created_at', '<', $previousdate)->sum('gamount');
                                                    // echo $previousbalance; die();
                                                    $openbalance = $opbalance + $previousbalance;
                                                    $fdate = date_create($fromdate);
                                                    $tdate = date_create($todate);
                                                    PDF::AddPage();
                                                    $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Sales A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Invoice No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                                    $html2 = '';
                                                    $total = $openbalance;
                                                    foreach ($value as $valu) {
                                                        $amount = $valu->gamount;
                                                        $salesname = $valu->salesname;
                                                        $name = $valu->cname;
                                                        $dc = $valu->dc;
                                                        $vdate = $valu->salesdate;
                                                        $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $name . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/physicalsales/print/' . $valu->id . '"   target="_blank">' . $salesname . '</a></td>
					
					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                        $html2 = $html2 . $ht;
                                                        $total = $total + $amount;
                                                    }
                                                    $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                    $html5 = '';
                                                    $html6 = '</table>';
                                                    $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                    PDF::writeHTML($html, true, false, true, false, '');
                                                    PDF::Output('subledgerentry.pdf');
                                                } else {
                                                    if ($id == 12) {
                                                        $spname = "sub_ledger_voucher";
                                                        $value = Info::callinfo($var, $spname);
                                                        //print_r($value);
                                                        if ($value == NULL) {
                                                            echo '<h1>Data not found</h1>';
                                                            die;
                                                        }
                                                        foreach ($value as $valu) {
                                                            $opbalance = $valu->openbalance;
                                                        }
                                                        $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                                        $previousbalance = DB::table('purchase')->where('status', 1)->where('created_at', '<', $previousdate)->sum('gross_total');
                                                        // echo $previousbalance; die();
                                                        $openbalance = $opbalance + $previousbalance;
                                                        $fdate = date_create($fromdate);
                                                        $tdate = date_create($todate);
                                                        PDF::AddPage();
                                                        $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Purchase A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
							

								 <table border="1" style="width:100%; padding:20px;">
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Purchase No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                                        $html2 = '';
                                                        $total = $openbalance;
                                                        foreach ($value as $valu) {
                                                            $purchasename = $valu->purchasename;
                                                            $purchasedate = $valu->purchasedate;
                                                            $gross_total = $valu->gross_total;
                                                            $dc = $valu->dc;
                                                            $sname = $valu->sname;
                                                            $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $purchasedate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $sname . '</td>
					<td style="background-color:#ffffff;"><a href="http://192.168.1.8/IMS/purchase/pdf/' . $valu->id . '"   target="_blank">' . $purchasename . '</a></td>

					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $gross_total . '</td>
				</tr>';
                                                            $html2 = $html2 . $ht;
                                                            $total = $total + $gross_total;
                                                        }
                                                        $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                        $html5 = '';
                                                        $html6 = '</table>';
                                                        $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                        PDF::writeHTML($html, true, false, true, false, '');
                                                        PDF::Output('subledgerentry.pdf');
                                                    } else {
                                                        if ($id == 13) {
                                                            $spname = "sub_ledger_voucher";
                                                            $value = Info::callinfo($var, $spname);
                                                            //	print_r($value);
                                                            if ($value == NULL) {
                                                                echo '<h1>Data not found</h1>';
                                                                die;
                                                            }
                                                            foreach ($value as $valu) {
                                                                $opbalance = $valu->openbalance;
                                                            }
                                                            $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                                                            $previousbalance = DB::table('employeesal')->where('created_at', '<', $previousdate)->sum('amount');
                                                            // echo $previousbalance; die();
                                                            $openbalance = $opbalance + $previousbalance;
                                                            $fdate = date_create($fromdate);
                                                            $tdate = date_create($todate);
                                                            PDF::AddPage();
                                                            $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Salary A/C</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							

								 <table border="1" style="width:100%; padding:20px;">
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Employee Name</th>
				<th>Description</th>
				
				<th >&nbsp;Particulars</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th>
 				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                                            $html2 = '';
                                                            $total = $openbalance;
                                                            foreach ($value as $valu) {
                                                                $employeename = $valu->employeename;
                                                                $amount = $valu->amount;
                                                                $particularsname = $valu->particularsname;
                                                                $vdate = $valu->vdate;
                                                                $description = $valu->description;
                                                                $dc = $valu->dc;
                                                                $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $vdate . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $employeename . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $description . '</td>
					<td style="background-color:#ffffff;">' . $particularsname . '</td>
					
					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                                $html2 = $html2 . $ht;
                                                                $total = $total + $amount;
                                                            }
                                                            $html3 = '<tr><td colspan="5" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                            $html5 = '';
                                                            $html6 = '</table>';
                                                            $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                            PDF::writeHTML($html, true, false, true, false, '');
                                                            PDF::Output('subledgerentry.pdf');
                                                        } else {
                                                            //print_r($var);
                                                            $spname = "generalledger";
                                                            $value = Info::callinfo($var, $spname);
                                                            //print_r($value);
                                                            //die();
                                                            if ($value == NULL) {
                                                                echo '<h1>Data not found</h1>';
                                                                die;
                                                            }
                                                            //print_r($value);die();
                                                            foreach ($value as $valu) {
                                                                $id = $valu->id;
                                                                $amount = $valu->amount;
                                                                $description = $valu->description;
                                                                $name = $valu->name;
                                                                $dc = $valu->dc;
                                                                $created_at = $valu->created_at;
                                                                $openbalance = $valu->openbalance;
                                                            }
                                                            $fdate = date_create($fromdate);
                                                            $tdate = date_create($todate);
                                                            PDF::AddPage();
                                                            $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									Sub Ledger</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
					&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Ledger Account</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								From&nbsp;' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
								<div>

								 <table border="1" style="width:100%; padding:20px;">
									
									<tr>
										
										<td  style="width:20%">Accounts of:</td>
										
										<td  style="width:80%">' . $name . '</td>
										
									</tr>
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>

				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;Debit/Credit</th>
			
				<th>&nbsp;&nbsp;Amount</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</th>
				<th></th>
			  </tr>';
                                                            $html2 = '';
                                                            $total = $openbalance;
                                                            foreach ($value as $valu) {
                                                                $id = $valu->id;
                                                                $amount = $valu->amount;
                                                                $description = $valu->description;
                                                                $name = $valu->name;
                                                                $dc = $valu->dc;
                                                                $created_at = $valu->created_at;
                                                                $ht = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $created_at . '</td>
					<td style="background-color:#ffffff;">' . $description . '</td>

					<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/ledgerentry/pdf/' . $valu->id . '"   target="_blank">' . $id . '</a></td>
					<td style="background-color:#ffffff;">&nbsp;' . $dc . '</td>
					<td style="background-color:#ffffff;">&nbsp;' . $amount . '</td>
				</tr>';
                                                                $html2 = $html2 . $ht;
                                                                $total = $total + $amount;
                                                            }
                                                            $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td>&nbsp;' . number_format($total, 2, '.', '') . '</td></tr>';
                                                            $html5 = '';
                                                            $html6 = '</table></div>';
                                                            $html = $html1 . $html2 . $html3 . $html5 . $html6;
                                                            PDF::writeHTML($html, true, false, true, false, '');
                                                            PDF::Output('subledgerentry.pdf');
                                                        }
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
    public function fromtoday(Request $request)
    {
        $profile = Companyprofile::get();
        //print_r($profile);
        foreach ($profile as $com) {
            $id = $com->id;
            $coname = $com->name;
            $address = $com->address;
            $tele = $com->telephone;
            $mobile = $com->mobile;
            $email = $com->email;
            $url = $com->url;
            $file = $com->file;
        }
        $date = $request->input('submit');
        $cid = $request->input('sid');
        if ($date == 'today') {
            $date = Combo::callcombo('currentdate');
            //print_r($date);
            foreach ($date as $d) {
                $curdate = $d->curdate;
            }
            $fromdate = CommonController::date_format($curdate);
            $todate = CommonController::date_format($curdate);
            $fromdate = date("Y-m-d");
            $todate = date("Y-m-d");
            $var = array($cid, $fromdate, $todate);
            //print_r($var);
            if ($cid == 0) {
                $spname = "suppliersledgerall";
            } else {
                $spname = "suppliersledger";
            }
            $value = Info::callinfo($var, $spname);
            //print_r($value);
            //die();
            foreach ($value as $valu) {
                $ccode = $valu->scode;
                $cname = $valu->sname;
            }
            //print_r($value);die();
            $fdate = date_create($fromdate);
            $tdate = date_create($todate);
            if ($value != NULL) {
                $date = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                $v = array($cid, $date);
                $s = "customerbalance";
                $cvalue = Info::callinfo($v, $s);
                //print_r($cvalue);
                if ($cvalue != NULL) {
                    //print_r($cvalue);
                }
                if ($cid == 0) {
                    $openbalance = DB::table('suppliers')->sum('openbalance');
                    $cname = 'All Suppliers A/C';
                    // echo $openbalance;
                } else {
                    $suppliers = DB::table('suppliers')->where('id', $cid)->first();
                    $openbalance = $suppliers->openbalance;
                }
                PDF::AddPage('A4');
                $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $coname . '</h2>
								
								' . $address . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									SUPPLIER A/C</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Ledger Account</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								' . date_format($fdate, "d-M-Y") . '&nbsp;&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
								<div>

								 <table border="1" style="width:100%; padding:20px;">
									<tr>
										
										<td style="width:20%">Accounts Code:</td>
										
										<td style="width:80%">' . $ccode . '</td>
										
									</tr>
									<tr>
										
										<td  style="width:20%">Accounts of:</td>
										
										<td  style="width:80%">' . $cname . '</td>
										
									</tr>
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>
				
				<th >&nbsp;Voucher Type</th>
				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Debit</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Credit</th>
				<th>&nbsp;&nbsp;Balance</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;" colspan="3">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . $openbalance . '</th>
				<th></th>
			  </tr>';
                $html2 = '';
                $i = 1;
                $sum = 0;
                $credit = 0;
                $debit = 0;
                $ob = $openbalance;
                $ctotal = 0;
                $dtotal = 0;
                foreach ($value as $valu) {
                    if ($valu->vstatus == 1 or $valu->pustatus == 1) {
                        if ($valu->vid != NULL) {
                            if ($valu->vtype == 1) {
                                $acc = 'By BANK A/C';
                            } else {
                                if ($valu->vtype == 2) {
                                    $acc = 'By CASH A/C';
                                }
                            }
                        } else {
                            if ($valu->sid != NULL) {
                                $acc = 'To PURCHASE A/C';
                            }
                        }
                        $html = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $valu->created_at . '</td>
					<td style="background-color:#ffffff;">' . $acc . '</td>
					';
                        if ($valu->pavoucher != NULL) {
                            $h6 = '<td style="background-color:#ffffff;">Payment</td>';
                        } else {
                            $h6 = '<td style="background-color:#ffffff;">Purchase</td>';
                        }
                        if ($valu->pavoucher != NULL) {
                            $h5 = '<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->vid . '/' . $valu->vtype . '"   target="_blank">' . $valu->pavoucher . '</a></td>';
                        } else {
                            $h5 = '<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/purchase/pdf/' . $valu->puid . '"   target="_blank">' . $valu->puvoucher . '</a></td>';
                        }
                        if ($valu->puvoucher != NULL) {
                            $credit = $valu->amount;
                            //$dtotal=$dtotal+$debit;
                            $ctotal = $ctotal + $credit;
                            $debit = 0.0;
                            $h1 = '<td style="background-color:#ffffff;">&nbsp;</td>
					<td style="background-color:#ffffff;">&nbsp;' . $credit . '</td>';
                            //$debit=$debit+$valu->amount;
                        }
                        if ($valu->pavoucher != NULL) {
                            $debit = $valu->amount;
                            //$ctotal=$ctotal+$credit;
                            $dtotal = $dtotal + $debit;
                            $credit = 0.0;
                            $h1 = '<td style="background-color:#ffffff;">&nbsp;' . $debit . '</td>
					<td style="background-color:#ffffff;">&nbsp;</td>';
                            //$credit=$credit+$valu->amount;
                        }
                        $ob = $ob + $credit - $debit;
                        $h3 = '<td>' . number_format($ob, 2, '.', '') . '</td></tr>';
                        $htmll = $html . $h6 . $h5 . $h1 . $h3;
                        $html2 = $html2 . $htmll;
                    }
                    $i++;
                    $sum = $sum + $valu->amount;
                }
                $subtotal = $openbalance + $ctotal - $dtotal;
                $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;"></td><td>' . number_format($dtotal, 2, '.', '') . '</td><td>' . $ctotal . '</td><td>' . number_format($subtotal, 2, '.', '') . '</td></tr>';
                $html5 = '<tr><td colspan="6" align="right" style="background-color:#ffffff;">Closing Balance:</td><td>&nbsp;&nbsp;' . number_format($ob, 2, '.', '') . '</td></tr>';
                $html6 = '</table></div>';
                //$html4='DEBIT:'.$debit.'CRedit:'.$credit.'';
                $html = $html1 . $html2 . $html3 . $html5 . $html6;
                PDF::writeHTML($html, true, false, true, false, '');
                PDF::Output('suppliersledger.pdf');
            } else {
                echo '<h1 style="color:red;">No data found<h1>';
            }
        } else {
            if ($date == 'fromdate') {
                //echo $cid; die();
                $fromdate = CommonController::date_format($request->input('fromdate'));
                $todate = CommonController::date_format($request->input('todate'));
                //$fromdate=date("Y-m-d");
                //$todate=date("Y-m-d");
                $var = array($cid, $fromdate, $todate);
                //print_r($var);
                if ($cid == 0) {
                    $spname = "suppliersledgerall";
                } else {
                    $spname = "suppliersledger";
                }
                $value = Info::callinfo($var, $spname);
                //print_r($value);
                //die();
                foreach ($value as $valu) {
                    $ccode = $valu->scode;
                    $cname = $valu->sname;
                }
                //print_r($value);die();
                $fdate = date_create($fromdate);
                $tdate = date_create($todate);
                if ($value != NULL) {
                    $date = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                    $v = array($cid, $date);
                    $s = "customerbalance";
                    $cvalue = Info::callinfo($v, $s);
                    //print_r($cvalue);
                    if ($cvalue != NULL) {
                        //print_r($cvalue);
                    }
                    if ($cid == 0) {
                        $openbalance = DB::table('suppliers')->sum('openbalance');
                        $cname = 'All Suppliers A/C';
                        // echo $openbalance;
                    } else {
                        $suppliers = DB::table('suppliers')->where('id', $cid)->first();
                        $openbalance = $suppliers->openbalance;
                    }
                    PDF::AddPage('A4');
                    $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $coname . '</h2>
								
								' . $address . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									SUPPLIER A/C</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Ledger Account</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
								' . date_format($fdate, "d-M-Y") . '&nbsp;&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
								<div>

								 <table border="1" style="width:100%; padding:20px;">
									<tr>
										
										<td style="width:20%">Accounts Code:</td>
										
										<td style="width:80%">' . $ccode . '</td>
										
									</tr>
									<tr>
										
										<td  style="width:20%">Accounts of:</td>
										
										<td  style="width:80%">' . $cname . '</td>
										
									</tr>
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>
				
				<th >&nbsp;Voucher Type</th>
				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Debit</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Credit</th>
				<th>&nbsp;&nbsp;Balance</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;" colspan="3">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . $openbalance . '</th>
				<th></th>
			  </tr>';
                    $html2 = '';
                    $i = 1;
                    $sum = 0;
                    $credit = 0;
                    $debit = 0;
                    $ob = $openbalance;
                    $ctotal = 0;
                    $dtotal = 0;
                    foreach ($value as $valu) {
                        if ($valu->vstatus == 1 or $valu->pustatus == 1) {
                            if ($valu->vid != NULL) {
                                if ($valu->vtype == 1) {
                                    $acc = 'By BANK A/C';
                                } else {
                                    if ($valu->vtype == 2) {
                                        $acc = 'By CASH A/C';
                                    }
                                }
                            } else {
                                if ($valu->sid != NULL) {
                                    $acc = 'To PURCHASE A/C';
                                }
                            }
                            $html = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $valu->created_at . '</td>
					<td style="background-color:#ffffff;">' . $acc . '</td>
					';
                            if ($valu->pavoucher != NULL) {
                                $h6 = '<td style="background-color:#ffffff;">Payment</td>';
                            } else {
                                $h6 = '<td style="background-color:#ffffff;">Purchase</td>';
                            }
                            if ($valu->pavoucher != NULL) {
                                $h5 = '<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->vid . '/' . $valu->vtype . '"   target="_blank">' . $valu->pavoucher . '</a></td>';
                            } else {
                                $h5 = '<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/purchase/pdf/' . $valu->puid . '"   target="_blank">' . $valu->puvoucher . '</a></td>';
                            }
                            if ($valu->puvoucher != NULL) {
                                $credit = $valu->amount;
                                //$dtotal=$dtotal+$debit;
                                $ctotal = $ctotal + $credit;
                                $debit = 0.0;
                                $h1 = '<td style="background-color:#ffffff;">&nbsp;</td>
					<td style="background-color:#ffffff;">&nbsp;' . $credit . '</td>';
                                //$debit=$debit+$valu->amount;
                            }
                            if ($valu->pavoucher != NULL) {
                                $debit = $valu->amount;
                                //$ctotal=$ctotal+$credit;
                                $dtotal = $dtotal + $debit;
                                $credit = 0.0;
                                $h1 = '<td style="background-color:#ffffff;">&nbsp;' . $debit . '</td>
					<td style="background-color:#ffffff;">&nbsp;</td>';
                                //$credit=$credit+$valu->amount;
                            }
                            $ob = $ob + $credit - $debit;
                            $h3 = '<td>' . number_format($ob, 2, '.', '') . '</td></tr>';
                            $htmll = $html . $h6 . $h5 . $h1 . $h3;
                            $html2 = $html2 . $htmll;
                        }
                        $i++;
                        $sum = $sum + $valu->amount;
                    }
                    $subtotal = $openbalance + $ctotal - $dtotal;
                    $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;"></td><td>' . number_format($dtotal, 2, '.', '') . '</td><td>' . $ctotal . '</td><td>' . number_format($subtotal, 2, '.', '') . '</td></tr>';
                    $html5 = '<tr><td colspan="6" align="right" style="background-color:#ffffff;">Closing Balance:</td><td>&nbsp;&nbsp;' . number_format($ob, 2, '.', '') . '</td></tr>';
                    $html6 = '</table></div>';
                    //$html4='DEBIT:'.$debit.'CRedit:'.$credit.'';
                    $html = $html1 . $html2 . $html3 . $html5 . $html6;
                    PDF::writeHTML($html, true, false, true, false, '');
                    PDF::Output('suppliersledger.pdf');
                } else {
                    echo '<h1 style="color:red;">No data found<h1>';
                }
            }
        }
    }
    public function fromtoday(Request $request)
    {
        $profile = Companyprofile::get();
        //print_r($profile);
        foreach ($profile as $com) {
            $id = $com->id;
            $coname = $com->name;
            $address = $com->address;
            $tele = $com->telephone;
            $mobile = $com->mobile;
            $email = $com->email;
            $url = $com->url;
            $file = $com->file;
        }
        $date = $request->input('submit');
        $cid = $request->input('cid');
        if ($date == 'today') {
            $date = Combo::callcombo('currentdate');
            //print_r($date);
            foreach ($date as $d) {
                $curdate = $d->curdate;
            }
            $fromdate = CommonController::date_format($curdate);
            $todate = CommonController::date_format($curdate);
            $fromdate = date("Y-m-d");
            $todate = date("Y-m-d");
            $var = array($cid, $fromdate, $todate);
            //print_r($var);
            //die();
            if ($cid == 0) {
                $spname = "customersledgerall";
            } else {
                $spname = "customersledger";
            }
            $value = Info::callinfo($var, $spname);
            /*if($value==NULL)
            		   echo "No data found";
            	   else
            		print_r($value);
            		die();
            		*/
            //$value=Info::callinfo($var,$spname);
            //print_r($value);
            $c = DB::table('customers')->where('id', $cid)->first();
            //$c = DB::table('customersledger')->where('id',$cid)->first();
            $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
            $debitbalance = DB::table('customersledger')->select('customersledger.id', 'customersledger.rv', 'customersledger.sv', 'customers.name as cname', 'customers.code as ccode', 'customersledger.amount', 'customersledger.created_at')->join('customers', 'customersledger.cid', '=', 'customers.id')->where('customersledger.rv', '<>', 0)->where('customersledger.cid', $cid)->where('customersledger.created_at', '<=', $previousdate)->sum('customersledger.amount');
            //->get();
            //print_r($debitbalance);
            $creditbalance = DB::table('customersledger')->select('customersledger.id', 'customersledger.rv', 'customersledger.sv', 'customers.name as cname', 'customers.code as ccode', 'customersledger.amount', 'customersledger.created_at')->join('customers', 'customersledger.cid', '=', 'customers.id')->where('customersledger.sv', '<>', 0)->where('customersledger.cid', $cid)->where('customersledger.created_at', '<=', $previousdate)->sum('customersledger.amount');
            //->get();
            //print_r($creditbalance);
            $openbalance = $c->openbalance + $debitbalance - $creditbalance;
            //echo $openbalance;
            //$bid=$b->bankid;
            $name_code = DB::table('customersledger')->select('customers.name as cname', 'customers.code as ccode', 'customersledger.created_at', 'voucher.vstatus', 'voucher.vnno as rvoucher', 'voucher.type as vtype', 'sales.status as sstatus', 'sales.name as svoucher')->join('customers', 'customersledger.cid', '=', 'customers.id')->join('voucher', 'customersledger.rv', '=', 'voucher.id')->join('sales', 'customersledger.sv', '=', 'sales.id')->where('customersledger.cid', $cid)->where('sales.customerid', $cid)->where('voucher.cid', $cid)->where('customersledger.created_at', $todate)->get();
            foreach ($name_code as $valu) {
                $ccode = $valu->ccode;
                $cname = $valu->cname;
            }
            foreach ($value as $valu) {
                $ccode = $valu->ccode;
                $cname = $valu->cname;
            }
            /*
            			if($name_code==null)
            echo "Data Not Found";
            			else
            			print_r($name_code);
            			
            			die();
            */
            PDF::AddPage('A4');
            $html1 = ' 
								<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $coname . '</h2>
								
								' . $address . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									CUSTOMER A/C</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Ledger Account</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				
								</h4>
								 
							</div>
							
								<div>

								 <table border="1" style="width:100%; padding:20px;">
									<tr>
										
										<td style="width:20%">Accounts Code:</td>
										
										<td style="width:80%">' . $ccode . '</td>
										
									</tr>
									<tr>
										
										<td  style="width:20%">Accounts of:</td>
										
										<td  style="width:80%">' . $cname . '</td>
										
									</tr>
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>
				
				<th >&nbsp;Voucher Type</th>
				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Debit</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Credit</th>
				<th>&nbsp;&nbsp;Balance</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;" colspan="3">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . $openbalance . '</th>
				<th></th>
			  </tr>';
            $html2 = '';
            $i = 1;
            foreach ($value as $valu) {
                if ($valu->vstatus == 1 or $valu->sstatus == 1) {
                    if ($valu->vid != NULL) {
                        if ($valu->vtype == 3) {
                            $acc = 'By BANK A/C';
                        } else {
                            if ($valu->vtype == 4) {
                                $acc = 'By CASH A/C';
                            } else {
                                if ($valu->vtype == 6) {
                                    $acc = 'By BKash';
                                } else {
                                    if ($valu->vtype == 7) {
                                        $acc = 'By SAP';
                                    } else {
                                        if ($valu->vtype == 8) {
                                            $acc = 'By KCS';
                                        } else {
                                            if ($valu->vtype == 9) {
                                                $acc = 'By MBank';
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    } else {
                        if ($valu->sid != NULL) {
                            $acc = 'To SALES A/C';
                        }
                    }
                    $html = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $valu->created_at . '</td>
					<td style="background-color:#ffffff;">' . $acc . '</td>
				';
                    if ($valu->rvoucher != NULL) {
                        $h6 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Receipt</td>';
                    } else {
                        $h6 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sales</td>';
                    }
                    if ($valu->rvoucher != NULL) {
                        $h5 = '<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->vid . '/' . $valu->vtype . '"   target="_blank">' . $valu->rvoucher . '</a></td>';
                    } else {
                        $h5 = '<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/physicalsales/print/' . $valu->sid . '"   target="_blank">' . $valu->svoucher . '</a></td>';
                    }
                    if ($valu->svoucher != NULL) {
                        $debit = $valu->amount;
                        $h1 = '<td style="background-color:#ffffff;">&nbsp;' . $debit . '</td>
					<td style="background-color:#ffffff;">&nbsp;</td>';
                        //$debit=$debit+$valu->amount;
                    }
                    if ($valu->rvoucher != NULL) {
                        $credit = $valu->amount;
                        $h1 = '<td style="background-color:#ffffff;">&nbsp;</td>
					<td style="background-color:#ffffff;">&nbsp;' . $credit . '</td>';
                        //$credit=$credit+$valu->amount;
                    }
                    $h3 = '<td>' . number_format($openbalance, 2, '.', '') . '</td></tr>';
                    $htmll = $html . $h6 . $h5 . $h1 . $h3;
                    $html2 = $html2 . $htmll;
                }
                $i++;
                //$sum=$sum+$valu->amount;
            }
            //$subtotal=($openbalance+$dtotal)-$ctotal;
            $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;"></td><td>' . number_format($debitbalance, 2, '.', '') . '</td><td>' . number_format($creditbalance, 2, '.', '') . '</td><td>subtotal</td></tr>';
            $html5 = '<tr><td colspan="6" align="right" style="background-color:#ffffff;">Closing Balance:</td><td>&nbsp;&nbsp;</td></tr>';
            $html6 = '</table></div>';
            //$html4='DEBIT:'.$debit.'CRedit:'.$credit.'';
            $html = $html1 . $html2 . $html3 . $html5 . $html6;
            PDF::writeHTML($html, true, false, true, false, '');
            PDF::Output('customersledger.pdf');
        } else {
            if ($date == 'fromdate') {
                //echo $cid; die();
                $fromdate = CommonController::date_format($request->input('fromdate'));
                $todate = CommonController::date_format($request->input('todate'));
                $var = array($cid, $fromdate, $todate);
                //print_r($var);
                if ($cid == 0) {
                    $spname = "customersledgerall";
                } else {
                    $spname = "customersledger";
                }
                $value = Info::callinfo($var, $spname);
                //print_r($value);
                //die();
                foreach ($value as $valu) {
                    $ccode = $valu->ccode;
                    $cname = $valu->cname;
                }
                //print_r($value);die();
                $fdate = date_create($fromdate);
                $tdate = date_create($todate);
                if ($value != NULL) {
                    $date = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                    $v = array($cid, $date);
                    $s = "customerbalance";
                    $cvalue = Info::callinfo($v, $s);
                    //print_r($cvalue);
                    if ($cvalue != NULL) {
                        //print_r($cvalue);
                    }
                    if ($cid == 0) {
                        $openbalance = DB::table('customers')->sum('openbalance');
                        $cname = 'All Customers A/C';
                        // echo $openbalance;
                    } else {
                        $customers = DB::table('customers')->where('id', $cid)->first();
                        $openbalance = $customers->openbalance;
                    }
                    PDF::AddPage('A4');
                    $html1 = ' 
								<p></p><p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $coname . '</h2>
								
								' . $address . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
					<div>

					   <h2>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									CUSTOMER A/C</h2>
						 <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
									Ledger Account</h4>	
                         <h4>
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				
								' . date_format($fdate, "d-M-Y") . '&nbsp;&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
							</div>
							
								<div>

								 <table border="1" style="width:100%; padding:20px;">
									<tr>
										
										<td style="width:20%">Accounts Code:</td>
										
										<td style="width:80%">' . $ccode . '</td>
										
									</tr>
									<tr>
										
										<td  style="width:20%">Accounts of:</td>
										
										<td  style="width:80%">' . $cname . '</td>
										
									</tr>
									
									
								</table>
					
		
						
			 <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Month & Date</th>
				<th>Particulars</th>
				
				<th >&nbsp;Voucher Type</th>
				<th >&nbsp;Voucher No.</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Debit</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Credit</th>
				<th>&nbsp;&nbsp;Balance</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;" colspan="3">Opening Balance</th>
                <th style="background-color:#ffffff;"></th> 				
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;">' . $openbalance . '</th>
				<th></th>
			  </tr>';
                    $html2 = '';
                    $i = 1;
                    $sum = 0;
                    $credit = 0;
                    $debit = 0;
                    $ob = $openbalance;
                    $dtotal = 0;
                    $ctotal = 0;
                    foreach ($value as $valu) {
                        if ($valu->vstatus == 1 or $valu->sstatus == 1) {
                            if ($valu->vid != NULL) {
                                if ($valu->vtype == 3) {
                                    $acc = 'By BANK A/C';
                                } else {
                                    if ($valu->vtype == 4) {
                                        $acc = 'By CASH A/C';
                                    } else {
                                        if ($valu->vtype == 6) {
                                            $acc = 'By BKash';
                                        } else {
                                            if ($valu->vtype == 7) {
                                                $acc = 'By SAP';
                                            } else {
                                                if ($valu->vtype == 8) {
                                                    $acc = 'By KCS';
                                                } else {
                                                    if ($valu->vtype == 9) {
                                                        $acc = 'By MBank';
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                            } else {
                                if ($valu->sid != NULL) {
                                    $acc = 'To SALES A/C';
                                }
                            }
                            $html = '<tr>
					<td style="background-color:#ffffff;">&nbsp;' . $valu->created_at . '</td>
					<td style="background-color:#ffffff;">' . $acc . '</td>
					';
                            if ($valu->rvoucher != NULL) {
                                $h6 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Receipt</td>';
                            } else {
                                $h6 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sales</td>';
                            }
                            if ($valu->rvoucher != NULL) {
                                $h5 = '<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $valu->vid . '/' . $valu->vtype . '"   target="_blank">' . $valu->rvoucher . '</a></td>';
                            } else {
                                $h5 = '<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/physicalsales/print/' . $valu->sid . '"   target="_blank">' . $valu->svoucher . '</a></td>';
                            }
                            if ($valu->svoucher != NULL) {
                                $debit = $valu->amount;
                                $dtotal = $dtotal + $debit;
                                $credit = 0.0;
                                $h1 = '<td style="background-color:#ffffff;">&nbsp;' . $debit . '</td>
					<td style="background-color:#ffffff;">&nbsp;</td>';
                                //$debit=$debit+$valu->amount;
                            }
                            if ($valu->rvoucher != NULL) {
                                $credit = $valu->amount;
                                $ctotal = $ctotal + $credit;
                                $debit = 0.0;
                                $h1 = '<td style="background-color:#ffffff;">&nbsp;</td>
					<td style="background-color:#ffffff;">&nbsp;' . $credit . '</td>';
                                //$credit=$credit+$valu->amount;
                            }
                            $ob = $ob + $debit - $credit;
                            $h3 = '<td>' . number_format($ob, 2, '.', '') . '</td></tr>';
                            $htmll = $html . $h6 . $h5 . $h1 . $h3;
                            $html2 = $html2 . $htmll;
                        }
                        $i++;
                        $sum = $sum + $valu->amount;
                    }
                    $subtotal = $openbalance + $dtotal - $ctotal;
                    $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;"></td><td>' . number_format($dtotal, 2, '.', '') . '</td><td>' . number_format($ctotal, 2, '.', '') . '</td><td>' . number_format($subtotal, 2, '.', '') . '</td></tr>';
                    $html5 = '<tr><td colspan="6" align="right" style="background-color:#ffffff;">Closing Balance:</td><td>&nbsp;&nbsp;' . number_format($subtotal, 2, '.', '') . '</td></tr>';
                    $html6 = '</table></div>';
                    //$html4='DEBIT:'.$debit.'CRedit:'.$credit.'';
                    $html = $html1 . $html2 . $html3 . $html5 . $html6;
                    PDF::writeHTML($html, true, false, true, false, '');
                    PDF::Output('customersledger.pdf');
                } else {
                    echo '<h1 style="color:red;">No data found<h1>';
                }
            }
        }
    }
    public function today(Request $request)
    {
        $profile = Companyprofile::get();
        foreach ($profile as $com) {
            $cid = $com->id;
            $cname = $com->name;
            $aaddress = $com->address;
            $tele = $com->telephone;
            $mobile = $com->mobile;
            $email = $com->email;
            $url = $com->url;
            $file = $com->file;
        }
        //print_r($trialbalance);
        //die();
        $date = Combo::callcombo('currentdate');
        //print_r($date);
        foreach ($date as $d) {
            $curdate = $d->curdate;
        }
        $fromdate = CommonController::date_format($curdate);
        $todate = CommonController::date_format($curdate);
        $var = array($fromdate, $todate);
        $fdate = date_create($fromdate);
        $tdate = date_create($todate);
        PDF::AddPage();
        $html1 = '<p></p>
				<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>
				</div>
			
					
					<div>
					             <h2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						<u>Balance Sheet</u></h2>
						<h4>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
								' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
								 
							</div>

			<table border="0" style="background-color:#FFFFFF; padding:20px;">	
			  <tr><td>				
			  	<table border="0" style="background-color:#FFFFFF; padding:20px;">	
				  <tr>
				    <th><b>&nbsp;&nbsp;Liabilities</b></th>  
				   	
					<th style></th>
				   </tr>';
        $trialbalance = DB::table('coa')->join('coatype', 'coatype.id', '=', 'coa.coatypeid')->select('coa.id as id', 'coa.name as coaname', 'coa.coatypeid', 'coatype.name as coatypename', 'coa.increasetypeid as inid')->orderBy('coa.coatypeid', 'asc')->get();
        $html2 = '';
        $coatypeid_cur = -1;
        $total_debit = 0;
        foreach ($trialbalance as $t) {
            if ($t->inid == 1) {
                $var = array($t->id, $fromdate, $todate);
                $spname = "todaypettycash";
                $value = Info::callinfo($var, $spname);
                foreach ($value as $valu) {
                    //$debit='Debit';
                    $debit = $valu->cash;
                    $credit = NULL;
                }
                $total_debit = $total_debit + $debit;
            } else {
                if ($t->inid == 3) {
                    $var = array($t->id, $fromdate, $todate);
                    $spname = "todaypettycash";
                    $value = Info::callinfo($var, $spname);
                    $debit = NULL;
                    $credit = NULL;
                    $debitCredit = 'cebit Credit';
                }
            }
            if ($t->inid == 1 || $t->inid == 3) {
                if ($debit == NULL && $credit == NULL) {
                    $h = '';
                } else {
                    if ($coatypeid_cur != $t->coatypeid) {
                        $debit_total_head = 0;
                        // $credit_total_head = 0;
                        foreach ($trialbalance as $tr) {
                            if ($tr->coatypeid == $t->coatypeid) {
                                if ($tr->inid == 1) {
                                    $var = array($tr->id, $fromdate, $todate);
                                    $spname = "todaypettycash";
                                    $value = Info::callinfo($var, $spname);
                                    foreach ($value as $valu) {
                                        //$debit='Debit';
                                        $debit_head = $valu->cash;
                                        $credit_head = NULL;
                                    }
                                    $debit_total_head = $debit_total_head + $debit_head;
                                } else {
                                    if ($tr->inid == 3) {
                                        $var = array($tr->id, $fromdate, $todate);
                                        $spname = "todaypettycash";
                                        $value = Info::callinfo($var, $spname);
                                        $debit_head = NULL;
                                        $credit_head = NULL;
                                        $debitCredit = 'cebit Credit';
                                    }
                                }
                            }
                        }
                        // $var = array($t->coatypeid,$fromdate,$todate);
                        // $spname="totalpettycash";
                        // $value=Info::callinfo($var,$spname);
                        // foreach($value as $vs){
                        // 	$amount=$vs->cash;
                        // }
                        // if($t->inid==1){
                        $html2 = $html2 . '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . $t->coatypename . '</b></td><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . number_format($debit_total_head, 2, '.', '') . '</b></td></tr>';
                        // }else{
                        // $html2 = $html2.'<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>'.$t->coatypename.'</b></td><td></td><td><b>'.$amount.'</b></td></tr>';
                        // }
                    }
                    $coatypeid_cur = $t->coatypeid;
                    $h = '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;' . $t->coaname . '</td><td>' . $debit . '</td></tr>';
                }
                $html2 = $html2 . $h;
            }
        }
        $html4 = '</table></td>';
        $html = $html1 . $html2 . $html4;
        $html1 = $html . '<td>				
			  	<table border="0" style="background-color:#FFFFFF; padding:20px;">	
				  <tr>
				    <th>&nbsp;&nbsp;<b>Assets</b></th> 
					<th style></th>
				   </tr>';
        $trialbalance = DB::table('coa')->join('coatype', 'coatype.id', '=', 'coa.coatypeid')->select('coa.id as id', 'coa.name as coaname', 'coa.coatypeid', 'coatype.name as coatypename', 'coa.increasetypeid as inid')->orderBy('coa.coatypeid', 'asc')->get();
        $html2 = '';
        $coatypeid_cur = -1;
        $total_credit = 0;
        foreach ($trialbalance as $t) {
            if ($t->inid == 2) {
                $var = array($t->id, $fromdate, $todate);
                $spname = "todaypettycash";
                $value = Info::callinfo($var, $spname);
                foreach ($value as $valu) {
                    $debit = NULL;
                    //$credit='Credit';
                    $credit = $valu->cash;
                }
                $total_credit = $total_credit + $credit;
            } else {
                if ($t->inid == 3) {
                    $var = array($t->id, $fromdate, $todate);
                    $spname = "todaypettycash";
                    $value = Info::callinfo($var, $spname);
                    $debit = NULL;
                    $credit = NULL;
                    $debitCredit = 'cebit Credit';
                }
            }
            if ($t->inid == 2 || $t->inid == 3) {
                if ($debit == NULL && $credit == NULL) {
                    $h = '';
                } else {
                    if ($coatypeid_cur != $t->coatypeid) {
                        // $debit_total_head = 0;
                        $credit_total_head = 0;
                        foreach ($trialbalance as $tr) {
                            if ($tr->coatypeid == $t->coatypeid) {
                                if ($tr->inid == 2) {
                                    $var = array($tr->id, $fromdate, $todate);
                                    $spname = "todaypettycash";
                                    $value = Info::callinfo($var, $spname);
                                    foreach ($value as $valu) {
                                        $debit_head = NULL;
                                        //$credit='Credit';
                                        $credit_head = $valu->cash;
                                    }
                                    $credit_total_head = $credit_total_head + $credit_head;
                                } else {
                                    if ($tr->inid == 3) {
                                        $var = array($tr->id, $fromdate, $todate);
                                        $spname = "todaypettycash";
                                        $value = Info::callinfo($var, $spname);
                                        $debit_head = NULL;
                                        $credit_head = NULL;
                                        $debitCredit = 'cebit Credit';
                                    }
                                }
                            }
                        }
                        // $var = array($t->coatypeid,$fromdate,$todate);
                        // $spname="totalpettycash";
                        // $value=Info::callinfo($var,$spname);
                        // foreach($value as $vs){
                        // 	$amount=$vs->cash;
                        // }
                        //  if($t->inid==1){
                        $html2 = $html2 . '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . $t->coatypename . '</b></td><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . number_format($credit_total_head, 2, '.', '') . '</b></td></tr>';
                        // }else{
                        // $html2 = $html2.'<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>'.$t->coatypename.'</b></td><td></td></tr>';
                        // }
                    }
                    $coatypeid_cur = $t->coatypeid;
                    $h = '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;' . $t->coaname . '</td><td>' . $credit . '</td></tr>';
                }
                $html2 = $html2 . $h;
            }
        }
        $html4 = '</table></td></tr>';
        $html5 = '<tr>
 					<td>
 					<table>';
        if ($total_debit < $total_credit) {
            $html5 = $html5 . '
 						<tr>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>Diff. in Opening Balances</b></td>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . number_format($total_credit - $total_debit, 2, '.', '') . '</b></td>
 						</tr>
 						<tr>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>Total</b></td>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . number_format($total_credit, 2, '.', '') . '</b></td>
 						</tr>';
        } else {
            $html5 = $html5 . '
 						<tr>
 							<td></td>
 							<td></td>
 						</tr>
 						<tr>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>Total</b></td>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . number_format($total_debit, 2, '.', '') . '</b></td>
 						</tr>';
        }
        $html5 = $html5 . '</table>
 					</td>
 					<td>
 					<table>';
        if ($total_debit > $total_credit) {
            $html5 = $html5 . '
 						<tr>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>Diff. in Opening Balances</b></td>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . number_format($total_debit - $total_credit, 2, '.', '') . '</b></td>
 						</tr>
 						<tr>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>Total</b></td>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . number_format($total_debit, 2, '.', '') . '</b></td>
 						</tr>';
        } else {
            $html5 = $html5 . '
 						<tr>
 							<td></td>
 							<td></td>
 						</tr>
 						<tr>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>Total</b></td>
 							<td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . number_format($total_credit, 2, '.', '') . '</b></td>
 						</tr>';
        }
        $html5 = $html5 . '</table>
 					</td>
 				  </tr>
 				  
 				</table>';
        $html = $html1 . $html2 . $html4 . $html5;
        PDF::writeHTML($html, true, false, true, false, '');
        PDF::Output('balancesheet.pdf');
    }
    public function today(Request $request)
    {
        /* $coatype= DB::table('coatype')->get();
                 foreach($coatype as $ctype){
        			echo '<b>'.$ctype->name.'</b><br>'; 
        			$coa= DB::table('coa')->where('coatypeid',$ctype->id)->get();
        			foreach($coa as $c){
        				echo $c->name.'<br>'; 
        			}
        		 }
        		 */
        /* PDF::AddPage('L');
        	  $coatype= DB::table('coatype')->get();
        	  $html='';
        	  foreach($coatype as $ctype){
        		  $html1='<b>'.$ctype->name.'</b><br>';
        		  $coa= DB::table('coa')->where('coatypeid',$ctype->id)->get();
        		  $html2='';
        		  foreach($coa as $c){
        			$html3='<span style="width:100px;">'.$c->name.'</span>total<br>';
                       $html2=$html2.$html3;				
        		  }
        		  $html=$html.$html1.$html2;
        	  }
        	  PDF::writeHTML($html, true, false, true, false, '');
        	  PDF::Output('trailbalance.pdf');
                die(); 
                 */
        $profile = Companyprofile::get();
        foreach ($profile as $com) {
            $cid = $com->id;
            $cname = $com->name;
            $aaddress = $com->address;
            $tele = $com->telephone;
            $mobile = $com->mobile;
            $email = $com->email;
            $url = $com->url;
            $file = $com->file;
        }
        //print_r($trialbalance);
        //die();
        $date = Combo::callcombo('currentdate');
        //print_r($date);
        foreach ($date as $d) {
            $curdate = $d->curdate;
        }
        $fromdate = CommonController::date_format($curdate);
        $todate = CommonController::date_format($curdate);
        $var = array($fromdate, $todate);
        $fdate = date_create($curdate);
        $tdate = date_create($curdate);
        PDF::AddPage();
        $html1 = '<p></p>
				<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $aaddress . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>
				</div>
			
					
					<div>
					             <h2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
						<u>Trail Balance</u></h2>
						<h4>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						
						
						
								' . date_format($fdate, "d-M-Y") . '&nbsp;To&nbsp;' . date_format($tdate, "d-M-Y") . '</h4>
								 
								 
							</div>

		  <div>
		  <table border="" style="background-color:#FFFFFF; width:100%; padding:20px;">	
			  <tr>
			    <th>&nbsp;&nbsp;Particulars</th> 
			   	
				<th style>Debit</th>
				<th style>Credit</th>
			   </tr>';
        $trialbalance = DB::table('coa')->join('coatype', 'coatype.id', '=', 'coa.coatypeid')->select('coa.id as id', 'coa.name as coaname', 'coa.coatypeid', 'coatype.name as coatypename', 'coa.increasetypeid as inid')->where('coa.id', '<>', 14)->where('coa.id', '<>', 15)->orderBy('coa.coatypeid', 'asc')->get();
        $html2 = '';
        $coatypeid_cur = -1;
        $totaldebit = 0;
        $totalcredit = 0;
        foreach ($trialbalance as $t) {
            //$instatus=DB::table('coa')->
            if ($t->inid == 1) {
                $var = array($t->id, $fromdate, $todate);
                $spname = "todaypettycash";
                $value = Info::callinfo($var, $spname);
                foreach ($value as $valu) {
                    //$debit='Debit';
                    $debit = $valu->cash;
                    $credit = NULL;
                }
            } else {
                if ($t->inid == 2) {
                    $var = array($t->id, $fromdate, $todate);
                    $spname = "todaypettycash";
                    $value = Info::callinfo($var, $spname);
                    foreach ($value as $valu) {
                        $debit = NULL;
                        //$credit='Credit';
                        $credit = $valu->cash;
                    }
                } else {
                    if ($t->inid == 3) {
                        //$instatus=DB::table('coa')->
                        $var = array($t->id, $fromdate, $todate);
                        $spname = "todaypettycash";
                        $value = Info::callinfo($var, $spname);
                        $debit = NULL;
                        $credit = NULL;
                        $debitCredit = 'cebit Credit';
                    }
                }
            }
            if ($debit == NULL && $credit == NULL) {
                $h = '';
            } else {
                if ($coatypeid_cur != $t->coatypeid) {
                    $debit_total_head = 0;
                    $credit_total_head = 0;
                    foreach ($trialbalance as $tr) {
                        if ($tr->coatypeid == $t->coatypeid) {
                            if ($tr->inid == 1) {
                                $var = array($tr->id, $fromdate, $todate);
                                $spname = "todaypettycash";
                                $value = Info::callinfo($var, $spname);
                                foreach ($value as $valu) {
                                    //$debit='Debit';
                                    $debit_head = $valu->cash;
                                    $credit_head = NULL;
                                }
                                $debit_total_head = $debit_total_head + $debit_head;
                            } else {
                                if ($tr->inid == 2) {
                                    $var = array($tr->id, $fromdate, $todate);
                                    $spname = "todaypettycash";
                                    $value = Info::callinfo($var, $spname);
                                    foreach ($value as $valu) {
                                        $debit_head = NULL;
                                        //$credit='Credit';
                                        $credit_head = $valu->cash;
                                    }
                                    $credit_total_head = $credit_total_head + $credit_head;
                                } else {
                                    if ($tr->inid == 3) {
                                        $var = array($tr->id, $fromdate, $todate);
                                        $spname = "todaypettycash";
                                        $value = Info::callinfo($var, $spname);
                                        $debit_head = NULL;
                                        $credit_head = NULL;
                                        $debitCredit = 'cebit Credit';
                                    }
                                }
                            }
                            // if($debit==NULL && $credit==NULL){
                            // 	$h='';
                            // }else{
                            // }
                        }
                    }
                    // if($t->inid==1){
                    // $html2 = $html2.'<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>'.$t->coatypename.'</b></td><td><b></b></td><td></td></tr>';
                    // }else{
                    // $html2 = $html2.'<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>'.$t->coatypename.'</b></td><td></td><td><b></b></td></tr>';
                    // }
                    if ($t->inid == 1 || $t->inid == 2) {
                        if ($debit_total_head == 0) {
                            $html2 = $html2 . '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . $t->coatypename . '</b></td><td style="background-color:#ffffff;">&nbsp;&nbsp;</td><td style="background-color:#ffffff;"><b>' . number_format($credit_total_head, 2, '.', '') . '</b></td></tr>';
                        } else {
                            if ($credit_total_head == 0) {
                                $html2 = $html2 . '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>' . $t->coatypename . '</b></td><td style="background-color:#ffffff;"><b>' . number_format($debit_total_head, 2, '.', '') . '</b></td><td style="background-color:#ffffff;">&nbsp;&nbsp;</td></tr>';
                            }
                        }
                    }
                    // if($t->inid==1){
                    // $html2 = $html2.'<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>'.$t->coatypename.'</b></td><td><b></b></td><td></td></tr>';
                    // }elseif ($t->inid==2){
                    // $html2 = $html2.'<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b>'.$t->coatypename.'</b></td><td></td><td><b></b></td></tr>';
                    // }elseif ($t->inid==3){
                    // $html2 = $html2.'<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;<b></b></td><td></td><td><b></b></td></tr>';
                    // }
                }
                $coatypeid_cur = $t->coatypeid;
                $h = '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;' . $t->coaname . '</td><td>' . $debit . '</td><td>' . $credit . '</td></tr>';
            }
            $html2 = $html2 . $h;
            $totaldebit = $totaldebit + $debit;
            $totalcredit = $totalcredit + $credit;
        }
        if ($totaldebit > $totalcredit) {
            $difftotal = $totaldebit - $totalcredit;
            $tdebit = $totaldebit;
            $tcredit = number_format($totalcredit + $difftotal, 2, '.', '');
            $h4 = '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;Diff in opening balance</td><td></td><td>' . number_format($difftotal, 2, '.', '') . '</td></tr>';
        } else {
            if ($totaldebit < $totalcredit) {
                $difftotal = $totalcredit - $totaldebit;
                $tcredit = $totalcredit;
                $tdebit = number_format($totaldebit + $difftotal, 2, '.', '');
                $h4 = '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;Diff in opening balance</td><td>' . number_format($difftotal, 2, '.', '') . '</td><td></td></tr>';
            } else {
                if ($totaldebit == $totalcredit) {
                    $h4 = '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;Diff in opening balance</td><td></td><td></td></tr>';
                }
            }
        }
        $h3 = '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;Grand Total</td><td>' . number_format($tdebit, 2, '.', '') . '</td><td>' . number_format($tcredit, 2, '.', '') . '</td>
					</tr>';
        $html4 = '</table>';
        $html = $html1 . $html2 . $h4 . $h3 . $html4;
        PDF::writeHTML($html, true, false, true, false, '');
        PDF::Output('trailbalance.pdf');
    }
    public function bankbook(Request $request)
    {
        $profile = Companyprofile::get();
        foreach ($profile as $com) {
            $cid = $com->id;
            $cname = $com->name;
            $address = $com->address;
            $tele = $com->telephone;
            $mobile = $com->mobile;
            $email = $com->email;
            $url = $com->url;
            $file = $com->file;
        }
        $date = $request->input('submit');
        $baccid = $request->input('baccid');
        if ($date == 'today') {
            $date = Combo::callcombo('currentdate');
            //print_r($date);
            foreach ($date as $d) {
                $curdate = $d->curdate;
            }
            $fromdate = CommonController::date_format($curdate);
            $todate = CommonController::date_format($curdate);
            $fromdate = date("Y-m-d");
            $todate = date("Y-m-d");
            $var = array($baccid, $fromdate, $todate);
            //print_r($var);
            $spname = "bankbook";
            $value = Info::callinfo($var, $spname);
            //print_r($value);die();
            $b = DB::table('bankaccount')->where('id', $baccid)->first();
            //$openbalance=$b->openbalance;
            $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
            $debitbalance = DB::table('bankbook')->join('voucher', 'voucher.id', '=', 'bankbook.vid')->where('bankbook.dc', 1)->where('voucher.vstatus', 1)->where('bankbook.baccid', $baccid)->where('bankbook.created_at', '<=', $previousdate)->sum('bankbook.amount');
            //echo $debitbalance; die();
            $creditbalance = DB::table('bankbook')->join('voucher', 'voucher.id', '=', 'bankbook.vid')->where('bankbook.dc', 0)->where('voucher.vstatus', 1)->where('bankbook.baccid', $baccid)->where('bankbook.created_at', '<=', $previousdate)->sum('bankbook.amount');
            $openbalance = $b->openbalance + $debitbalance - $creditbalance;
            $bid = $b->bankid;
            $bank = DB::table('bankinfo')->where('id', $bid)->first();
            PDF::AddPage('A4');
            $html1 = '
			<p></p>
							<div>
					<table>
						<tr>
							<td style="width:20%">
								<img src="uploads/' . $file . '" alt="logo" height="150";>
							</td>
							<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $address . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
							</td>
						</tr>

					</table>	
				</div>
				<div>
					
					             <h2>
						
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									<u>Account Statement</u></h2>
								 <table border="0" style="width:100%">
								 <tr>
										
										<td>Bank Name:' . $bank->name . '</td>
										<td></td>
										<td>Opening Date:' . $b->opendate . '</td>
										
									</tr>
									<tr>
									
										<td>Current Deposite:' . $b->openbalance . '</td>
										<td></td>
										<td>Expire Date:' . $b->exdate . '</td>
										
									</tr>
									<tr>
									
										<td>A/C Number:' . $b->name . '</td>
										<td></td>
										<td>Interest Rate:' . $b->rate . '</td>
										
									</tr>
									<tr>
									
										<td>From:' . $fromdate . ' To ' . $todate . '</td>
										<td></td>
										<td>Currency:BDT</td>
										
									</tr>
									
									
								
								</table> 
							</div>
						
						<div>

								 <table border="1" style="width:100%; padding:20px;">
									<tr>
										
										<td style="width:20%">Accounts Code:</td>
										
										<td style="width:80%">' . $b->code . '</td>
										
									</tr>
									<tr>
										
										<td  style="width:20%">Accounts of:</td>
										
										<td  style="width:80%">' . $b->name . '(' . $bank->name . ')</td>
										
									</tr>
									
									
								</table> 

		  <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Date</th>
				<th>Particulars</th>
				<th >&nbsp;Supplier Name</th>
				<th >&nbsp;Customer Name</th>
				<th >&nbsp;Voucher No</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Debit</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Credit</th>
				<th>&nbsp;&nbsp;Balance</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Balance B/F</th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th>&nbsp;&nbsp;' . number_format($openbalance, 2, '.', '') . '</th>
			  </tr>';
            $html2 = '';
            $balance = $openbalance;
            $debit = $balance;
            $credit = 0;
            foreach ($value as $v) {
                if ($v->type == 5) {
                    $h1 = '<tr>
				<td style="background-color:#ffffff;">&nbsp;' . $v->created_at . '</td>
				<td style="background-color:#ffffff;"></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->sname . '</a></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->cname . '</a></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '/' . $v->status . '">' . $v->vnno . '</a></td>';
                } else {
                    $h1 = '<tr>
				<td style="background-color:#ffffff;">&nbsp;' . $v->created_at . '</td>
				<td style="background-color:#ffffff;"></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->sname . '</a></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->cname . '</a></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->vnno . '</a></td>';
                }
                if ($v->type == 1) {
                    $balance = $balance - $v->amount;
                    //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                    $h2 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;</td>
					<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                    $credit = $credit + $v->amount;
                } else {
                    if ($v->type == 3) {
                        $balance = $balance + $v->amount;
                        //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                        $h2 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					<td style="background-color:#ffffff;">&nbsp;&nbsp;</td>
					
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                        $debit = $debit + $v->amount;
                    } else {
                        if ($v->type == 5) {
                            if ($v->status == 1) {
                                $balance = $balance + $v->amount;
                                //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                                $h2 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					<td style="background-color:#ffffff;">&nbsp;&nbsp;</td>
					
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                                $debit = $debit + $v->amount;
                            } else {
                                if ($v->status == 2) {
                                    $balance = $balance - $v->amount;
                                    //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                                    $h2 = '
					<td style="background-color:#ffffff;">&nbsp;&nbsp;</td>
					<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                                    $credit = $credit + $v->amount;
                                } else {
                                    if ($v->status == 3) {
                                        //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                                        if ($v->dc == 1) {
                                            $balance = $balance + $v->amount;
                                            $h2 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
						<td style="background-color:#ffffff;"></td>
						<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
						</tr>';
                                        } else {
                                            if ($v->dc == 0) {
                                                $balance = $balance - $v->amount;
                                                $h2 = '<td style="background-color:#ffffff;"></td>
						<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
						<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
						</tr>';
                                            }
                                        }
                                        $debit = $debit + $v->amount;
                                    }
                                }
                            }
                        }
                    }
                }
                $h = $h1 . $h2;
                $html2 = $html2 . $h;
            }
            $total = $debit - $credit;
            $h3 = '';
            $html2 = $html2 . $h3;
            $html3 = '</table></div>
						<div>
					
						</div>';
            $html = $html1 . $html2 . $html3;
            PDF::writeHTML($html, true, false, true, false, '');
            PDF::Output('vbp.pdf');
        } else {
            if ($date == 'fromdate') {
                $fromdate = CommonController::date_format($request->input('fromdate'));
                $todate = CommonController::date_format($request->input('todate'));
                $var = array($baccid, $fromdate, $todate);
                $spname = "bankbook";
                $value = Info::callinfo($var, $spname);
                $b = DB::table('bankaccount')->where('id', $baccid)->first();
                $openbalance = $b->openbalance;
                $previousdate = date('Y-m-d', strtotime($fromdate . " - 1 day"));
                $debitbalance = DB::table('bankbook')->join('voucher', 'voucher.id', '=', 'bankbook.vid')->where('bankbook.dc', 1)->where('voucher.vstatus', 1)->where('bankbook.baccid', $baccid)->where('bankbook.created_at', '<=', $previousdate)->sum('bankbook.amount');
                //echo $debitbalance; die();
                $creditbalance = DB::table('bankbook')->join('voucher', 'voucher.id', '=', 'bankbook.vid')->where('bankbook.dc', 0)->where('voucher.vstatus', 1)->where('bankbook.baccid', $baccid)->where('bankbook.created_at', '<=', $previousdate)->sum('bankbook.amount');
                $openbalance = $b->openbalance + $debitbalance - $creditbalance;
                $bid = $b->bankid;
                $bank = DB::table('bankinfo')->where('id', $bid)->first();
                PDF::AddPage('A4');
                $html1 = '
			<p></p>
							<div>
					<table>
						<tr>
							<td style="width:20%">
								<img src="uploads/' . $file . '" alt="logo" height="150";>
							</td>
							<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $address . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
							</td>
						</tr>

					</table>	
				</div>
				<div>
					
					                <h2>
						
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
									<u>Account Statement</u></h2>
								 <table border="0" style="width:100%">
								 <tr>
										
										<td>Bank Name:' . $bank->name . '</td>
										<td></td>
										<td>Opening Date:' . $b->opendate . '</td>
										
									</tr>
									<tr>
									
										<td>Current Deposite:' . $b->openbalance . '</td>
										<td></td>
										<td>Expire Date:' . $b->exdate . '</td>
										
									</tr>
									<tr>
									
										<td>A/C Number:' . $b->name . '</td>
										<td></td>
										<td>Interest Rate:' . $b->rate . '</td>
										
									</tr>
									<tr>
									
										<td>From:' . $fromdate . ' To ' . $todate . '</td>
										<td></td>
										<td>Currency:BDT</td>
										
									</tr>
									
									
								
								</table> 
							</div>
						
						<div>

								 <table border="1" style="width:100%; padding:20px;">
									<tr>
										
										<td style="width:20%">Accounts Code:</td>
										
										<td style="width:80%">' . $b->code . '</td>
										
									</tr>
									<tr>
										
										<td  style="width:20%">Accounts of:</td>
										
										<td  style="width:80%">' . $b->name . '(' . $bank->name . ')</td>
										
									</tr>
									
									
								</table> 

		  <table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th >&nbsp;Date</th>
				<th>Particulars</th>
				<th >&nbsp;Supplier Name</th>
				<th >&nbsp;Customer Name</th>
				<th >&nbsp;Voucher No</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Debit</th>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Credit</th>
				<th>&nbsp;&nbsp;Balance</th>
			  </tr>
			  <tr>
				<th style="background-color:#ffffff;">&nbsp;' . date('Y-m-d', strtotime($fromdate . " - 1 day")) . '</th>
				<th style="background-color:#ffffff;">Balance B/F</th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th style="background-color:#ffffff;"></th>
				<th>&nbsp;&nbsp;' . number_format($openbalance, 2, '.', '') . '</th>
			  </tr>';
                $html2 = '';
                $balance = $openbalance;
                $debit = $balance;
                $credit = 0;
                foreach ($value as $v) {
                    if ($v->type == 5) {
                        $h1 = '<tr>
				<td style="background-color:#ffffff;">&nbsp;' . $v->created_at . '</td>
				<td style="background-color:#ffffff;"></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->sname . '</a></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->cname . '</a></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '/' . $v->status . '">' . $v->vnno . '</a></td>';
                    } else {
                        $h1 = '<tr>
				<td style="background-color:#ffffff;">&nbsp;' . $v->created_at . '</td>
				<td style="background-color:#ffffff;"></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->sname . '</a></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->cname . '</a></td>
				<td style="background-color:#ffffff;">&nbsp;<a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->vnno . '</a></td>';
                    }
                    if ($v->type == 1) {
                        $balance = $balance - $v->amount;
                        if ($balance == NULL) {
                            echo "<h1>No Data Found</h1>";
                            die;
                        } else {
                            //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                            $h2 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;</td>
					<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                            $credit = $credit + $v->amount;
                        }
                    } else {
                        if ($v->type == 3) {
                            $balance = $balance + $v->amount;
                            if ($balance == NULL) {
                                echo "<h1>No Data Found</h1>";
                                die;
                            } else {
                                //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                                $h2 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					<td style="background-color:#ffffff;">&nbsp;&nbsp;</td>
					
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                                $debit = $debit + $v->amount;
                            }
                        } else {
                            if ($v->type == 5) {
                                if ($v->status == 1) {
                                    $balance = $balance + $v->amount;
                                    if ($balance == NULL) {
                                        echo "<h1>No Data Found</h1>";
                                        die;
                                    } else {
                                        //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                                        $h2 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					<td style="background-color:#ffffff;">&nbsp;&nbsp;</td>
					
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                                        $debit = $debit + $v->amount;
                                    }
                                } else {
                                    if ($v->status == 2) {
                                        $balance = $balance - $v->amount;
                                        if ($balance == NULL) {
                                            echo "<h1>No Data Found</h1>";
                                            die;
                                        } else {
                                            //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                                            $h2 = '
					<td style="background-color:#ffffff;">&nbsp;&nbsp;</td>
					<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                                            $credit = $credit + $v->amount;
                                        }
                                    } else {
                                        if ($v->status == 3) {
                                            $balance = $balance + $v->amount;
                                            if ($balance == NULL) {
                                                echo "<h1>No Data Found</h1>";
                                                die;
                                            } else {
                                                //$s = DB::table('suppliers')->where('id',$v->sid)->first();
                                                $h2 = '<td style="background-color:#ffffff;">&nbsp;&nbsp;' . $v->amount . '</td>
					<td style="background-color:#ffffff;"></td>
					<td>&nbsp;&nbsp;' . number_format($balance, 2, '.', '') . '</td>
					</tr>';
                                                $debit = $debit + $v->amount;
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                    $h = $h1 . $h2;
                    $html2 = $html2 . $h;
                }
                $total = $debit - $credit;
                $h3 = '<tr>
				<td  colspan="5" align="right"  style="background-color:#ffffff;">Total</td>
				<td    style="background-color:#ffffff;">' . number_format($debit, 2, '.', '') . '</td>
				<td    style="background-color:#ffffff;">&nbsp;&nbsp;' . number_format($credit, 2, '.', '') . '</td>
				<td    style="background-color:#ffffff;">&nbsp;&nbsp;' . number_format($total, 2, '.', '') . '</td>
				</tr>';
                $html2 = $html2 . $h3;
                $html3 = '</table></div>
						<div>
					
						</div>';
                $html = $html1 . $html2 . $html3;
                PDF::writeHTML($html, true, false, true, false, '');
                PDF::Output('vbp.pdf');
            }
        }
    }
Exemple #10
0
    public function today(Request $request)
    {
        $profile = Companyprofile::get();
        foreach ($profile as $com) {
            $cid = $com->id;
            $cname = $com->name;
            $address = $com->address;
            $tele = $com->telephone;
            $mobile = $com->mobile;
            $email = $com->email;
            $url = $com->url;
            $file = $com->file;
        }
        $date = Combo::callcombo('currentdate');
        //print_r($date);
        foreach ($date as $d) {
            $curdate = $d->curdate;
        }
        $fromdate = CommonController::date_format($curdate);
        $todate = CommonController::date_format($curdate);
        $fromdate = date("Y-m-d");
        $todate = date("Y-m-d");
        $var = array($fromdate, $todate);
        $spname = "rptcash";
        $value = Info::callinfo($var, $spname);
        //print_r($value);
        //die();
        foreach ($value as $valu) {
            $id = $valu->id;
            $amount = $valu->amount;
        }
        //print_r($value);die();
        $var1 = array($todate);
        //print_r($var1);die();
        $spname1 = "totalcashcollection";
        $value1 = Info::callinfo($var1, $spname1);
        //print_r($value1);die();
        foreach ($value1 as $valu) {
            //$id=$valu->id;
            $opening_balance = $valu->cash;
        }
        $coa = DB::table('coa')->where('id', 1)->first();
        $coabalance = $coa->openbalance;
        //echo $coabalance;
        $openbalance = $opening_balance + $coabalance;
        PDF::AddPage('A4');
        $html1 = '
			
			<p></p>
					<div>
						<table>
							<tr>
								<td style="width:20%">
									<img src="uploads/' . $file . '" alt="logo" height="150";>
								</td>
								<td style="width:85% font-size:30%">
								<h2>' . $cname . '</h2>
								
								' . $address . '
									<br>Tel:' . $tele . ',Mobile:' . $mobile . '
									<br>E-mail:' . $email . '
									<br>' . $url . '
								 
								</td>
							</tr>

						</table>	
					</div>
			

<div>

<h3>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<u>Cash A/C Book</h3></u></div>
<div><strong> From Date:' . $fromdate . ' &nbsp;&nbsp;&nbsp;&nbsp; To Date:' . $todate . ' </strong></div></div>
<table border="1" style="background-color:lightblue; width:100%; padding:20px;">	
			  <tr>
				<th>&nbsp;&nbsp;&nbsp;&nbsp;Date</th>
				<th>Particulars</th>
				<th>Vch Type</th>
				<th>Vch No</th>
				<th>Debit</th>
				<th>Credit</th>
			  </tr>
			  <tr>
				<td style="background-color:#ffffff;"></td>
				<td colspan="3" style="background-color:#ffffff;">Opening Balance</td>
				<td style="background-color:#ffffff;">' . number_format($openbalance, 2, '.', '') . '</td>
				<td style="background-color:#ffffff;"></td>
			  </tr>';
        $html2 = '';
        $i = 1;
        $dtotal = $openbalance;
        $ctotal = 0;
        foreach ($value as $valu) {
            if (substr($valu->vnno, 0, 1) == 'v') {
                //$vnno='Voucher';
                $voucher = DB::table('voucher')->where('id', $valu->id)->first();
                if ($voucher->type == 2) {
                    $vnno = 'Cash Payment A/C';
                    $type = 'Payment';
                    $damount = NULL;
                    $camount = $valu->amount;
                    $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                } else {
                    if ($voucher->type == 4) {
                        $vnno = 'Cash Collection A/C';
                        $type = 'Receipt';
                        $damount = $valu->amount;
                        $camount = NULL;
                        $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                    } else {
                        if ($voucher->type == 5) {
                            if ($voucher->status == 1) {
                                $vnno = 'Cash Contra  A/C';
                                $type = 'Receipt Contra';
                                $damount = $valu->amount;
                                $camount = NULL;
                                $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                            } else {
                                if ($voucher->status == 2) {
                                    $vnno = 'Bank Contra A/C';
                                    $type = 'Payment Contra';
                                    $damount = NULL;
                                    $camount = $valu->amount;
                                    $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                }
                            }
                        } else {
                            if ($voucher->type == 6) {
                                $vnno = 'bKash Collection A/C';
                                $coa = DB::table('coa')->where('id', 4)->first();
                                if ($coa->increasetypeid == 1) {
                                    $type = 'Receipt';
                                    $damount = $valu->amount;
                                    $camount = NULL;
                                    $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                } else {
                                    if ($coa->increasetypeid == 2) {
                                        $type = 'Payment';
                                        $damount = NULL;
                                        $camount = $valu->amount;
                                        $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                    }
                                }
                            } else {
                                if ($voucher->type == 7) {
                                    $vnno = 'SAP Collection A/C';
                                    $coa = DB::table('coa')->where('id', 5)->first();
                                    if ($coa->increasetypeid == 1) {
                                        $type = 'Receipt';
                                        $damount = $valu->amount;
                                        $camount = NULL;
                                        $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                    } else {
                                        if ($coa->increasetypeid == 2) {
                                            $type = 'Payment';
                                            $damount = NULL;
                                            $camount = $valu->amount;
                                            $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                        }
                                    }
                                } else {
                                    if ($voucher->type == 8) {
                                        $vnno = 'KCS Collection A/C';
                                        $coa = DB::table('coa')->where('id', 6)->first();
                                        if ($coa->increasetypeid == 1) {
                                            $type = 'Receipt';
                                            $damount = $valu->amount;
                                            $camount = NULL;
                                            $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                        } else {
                                            if ($coa->increasetypeid == 2) {
                                                $type = 'Payment';
                                                $camount = $valu->amount;
                                                $damount = NULL;
                                                $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                            }
                                        }
                                    } else {
                                        if ($voucher->type == 9) {
                                            $vnno = 'MBank Collection A/C';
                                            $coa = DB::table('coa')->where('id', 7)->first();
                                            if ($coa->increasetypeid == 1) {
                                                $type = 'Receipt';
                                                $damount = $valu->amount;
                                                $camount = NULL;
                                                $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                            } else {
                                                if ($coa->increasetypeid == 2) {
                                                    $type = 'Payment';
                                                    $camount = $valu->amount;
                                                    $damount = NULL;
                                                    $link = 'http://192.168.1.8/IMS/voucher/pdf/' . $valu->id . '/' . $valu->type;
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            } else {
                $pettycash = DB::table('pettycash')->where('id', $valu->id)->first();
                $coa = DB::table('coa')->where('id', $pettycash->particular)->first();
                $vnno = $coa->name;
                if ($coa->increasetypeid == 1) {
                    $type = 'Receipt';
                    $damount = $valu->amount;
                    $camount = NULL;
                } else {
                    if ($coa->increasetypeid == 2) {
                        $type = 'Payment';
                        $damount = NULL;
                        $camount = $valu->amount;
                    }
                }
                $link = 'http://192.168.1.8/IMS/ledgerentry/pdf/' . $valu->id;
            }
            $html = '<tr><td style="background-color:#ffffff;">&nbsp;&nbsp;&nbsp;&nbsp;' . $valu->created_at . '</td>
			    <td style="background-color:#ffffff;">' . $vnno . '</td>
				<td style="background-color:#ffffff;">' . $type . '</td>
				<td style="background-color:#ffffff;"><a href="' . $link . '">' . $valu->vnno . '</a></td>
				<td style="background-color:#ffffff;">' . $damount . '</td>
				<td style="background-color:#ffffff;">' . $camount . '</td>
				</tr>';
            $html2 = $html2 . $html;
            $i++;
            $dtotal = $dtotal + $damount;
            $ctotal = $ctotal + $camount;
        }
        $html3 = '<tr>
				<td></td>
				<td colspan="3" >Total</td>
				<td>' . number_format($dtotal, 2, '.', '') . '</td>
				<td>' . number_format($ctotal, 2, '.', '') . '</td>
			  </tr>
			  <tr>
				<td style="background-color:#ffffff;"></td>
				<td colspan="4" style="background-color:#ffffff;">Closing Balance</td>
				<td style="background-color:#ffffff;">' . number_format($dtotal - $ctotal, 2, '.', '') . '</td>
			  </tr>
			  <tr>
				<td></td>
				<td colspan="3" >Sub Total</td>
				<td>' . number_format($dtotal, 2, '.', '') . '</td>
				<td>' . number_format($ctotal + $dtotal - $ctotal, 2, '.', '') . '</td>
			  </tr>
		</table></div>';
        $html = $html1 . $html2 . $html3;
        PDF::writeHTML($html, true, false, true, false, '');
        PDF::Output('cash.pdf');
    }