public function pdf(Request $request, $pid) { $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; } $var = array($pid); $spname = "viewpurchase"; $value = Info::callinfo($var, $spname); foreach ($value as $valu) { $pname = $valu->pname; $purchasedate = $valu->purchasedate; $sname = $valu->sname; $address = $valu->address; $challanno = $valu->challanno; $suppliersbillno = $valu->suppliersbillno; $suppliersbilldate = $valu->suppliersbilldate; $discount = $valu->discount; $others_exp = $valu->others_exp; $gross_total = $valu->gross_total; $status = $valu->status; } $pdate = date_create($purchasedate); $sdate = date_create($suppliersbilldate); $spname1 = "purchasedetailsview"; $value1 = Info::callinfo($var, $spname1); $sum = 0; foreach ($value1 as $valu) { $a = $valu->amount; $sum = $sum + $a; } 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>'; $hst = '<h2> <u>PURCHASE VOUCHER</u></h2>'; $hex = '<table border="0" style="width:100%"> <tr> <td>Supplier Name:' . $sname . '</td> <td></td> <td>Voucher No:' . $pname . '</td> </tr> <tr> <td>Bill No:' . $suppliersbillno . '</td> <td></td> <td>Challan No:' . $challanno . '</td> </tr> <tr> <td>Address:' . $address . '</td> <td></td> <td>Purchase Date:' . date_format($pdate, "d/m/Y") . '</td> </tr> </table> </div> <div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th>Item Name</th> <th>Quantity</th> <th>Measurement Unit</th> <th>Rate</th> <th>Amount</th> </tr>'; $html1 = $html1 . $hst . $hex; $html2 = ''; foreach ($value1 as $valu) { $html = '<tr><td style="background-color:#ffffff;">' . $valu->iname . '</td> <td style="background-color:#ffffff;">' . $valu->quantity . '</td> <td style="background-color:#ffffff;">' . $valu->mname . '</td> <td style="background-color:#ffffff;">' . $valu->rate . '</td> <td style="background-color:#ffffff;">' . $valu->amount . '</td></tr>'; $html2 = $html2 . $html; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">'; $html4 = ''; $html5 = 'Sub Total:</td><td style="background-color:#ffffff;">' . number_format($sum, 2, '.', '') . '</td></tr>'; $html6 = ' <tr><td colspan="4" align="right" style="background-color:#ffffff;">Discount:</td><td style="background-color:#ffffff;">' . number_format($discount, 2, '.', '') . '</td></tr>'; $html7 = ' <tr><td colspan="4" align="right" style="background-color:#ffffff;">Others Exp.:</td><td style="background-color:#ffffff;">' . number_format($others_exp, 2, '.', '') . '</td></tr>'; $html8 = ' <tr><td colspan="4" align="right" style="background-color:#ffffff;">Gross Total:</td><td style="background-color:#ffffff;">' . number_format($gross_total, 2, '.', '') . '</td></tr>'; $html9 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord(number_format($gross_total, 2, '.', '')) . ' Taka Only</h4></div> <div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3 . $html4 . $html5 . $html6 . $html7 . $html8 . $html9; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('purchase.pdf'); }
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> <u>Statement of Daily Collection</u></h2><h4><br> 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> Prepared By Checked By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3 . $html4 . $html5 . $html6; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vp.pdf'); }
public function pdf(Request $request, $id) { $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; } $var = array($id); $spname = "ledgerentry"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $valu) { $id = $valu->id; $amount = $valu->amount; $description = $valu->description; $name = $valu->name; $code = $valu->code; $created_at = $valu->created_at; } $date = date_create($created_at); 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> <u>Ledger Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Accounts Name:' . $name . '</td> <td></td> <td>Manual V. No:7</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $created_at . '</td> </tr> <tr> <td>Description:' . $description . '</td> <td></td> <td></td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:35%;"> Head of Accounts</th> <th style="width:15%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $coa = DB::table('coa')->where('id', 1)->first(); $html2 = ' <tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $name . '</td> <td style="background-color:#ffffff;">' . $code . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $coa->name . '</td> <td style="background-color:#ffffff;">' . $coa->code . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div> </div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('ledgerentry.pdf'); }
public function pdf(Request $request, $id, $type, $status) { //echo $id.$type.$status; $voucher = DB::table('voucher')->where('id', $id)->first(); //print_r($voucher); $vnno = $voucher->vnno; $amount = $voucher->amount; $sid = $voucher->sid; $cid = $voucher->cid; $type = $voucher->type; $vdate = $voucher->vdate; //echo '<br>'; $vouchercontra = DB::table('vouchercontra')->where('vid', $voucher->id)->first(); //print_r($vouchercontra); $vid = $vouchercontra->vid; $baccid = $vouchercontra->baccid; $checkno = $vouchercontra->checkno; $cashid = $vouchercontra->cashid; $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; } if ($status == 1) { $date = date_create($vdate); PDF::AddPage(); $bname = DB::table('bankinfo')->where('id', $baccid)->first(); $brancename = DB::table('bankaccount')->where('id', $baccid)->first(); $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> <u>Cash Contra</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vnno . '</td> <td></td> <td>Manual V. No:' . $type . '</td> </tr> <tr> <td>Bank Name:</td> <td></td> <td>Branch Name:' . $brancename->branchname . '</td> </tr> <tr> <td>A/C No.' . $brancename->name . '</td> <td></td> <td>Check No.' . $checkno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:35%;"> Head of Accounts</th> <th style="width:15%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $bname = DB::table('bankaccount')->where('id', $baccid)->pluck('name'); $coa = DB::table('coa')->where('id', 1)->first(); $bcode = DB::table('bankaccount')->where('id', $baccid)->pluck('code'); $html2 = ' <tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $coa->name . '</td> <td style="background-color:#ffffff;"> ' . $coa->code . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $bname . '</td> <td style="background-color:#ffffff;"> ' . $bcode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('contravouchar.pdf'); } else { if ($status == 2) { $date = date_create($vdate); PDF::AddPage(); $bname = DB::table('bankinfo')->where('id', $baccid)->first(); $brancename = DB::table('bankaccount')->where('id', $baccid)->first(); $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> <u>Bank Contra</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vnno . '</td> <td></td> <td>Manual V. No:' . $type . '</td> </tr> <tr> <td>Bank Name:</td> <td></td> <td>Branch Name:' . $brancename->branchname . '</td> </tr> <tr> <td>A/C No.' . $brancename->name . '</td> <td></td> <td>Check No.' . $checkno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:35%;"> Head of Accounts</th> <th style="width:15%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $bname = DB::table('bankaccount')->where('id', $baccid)->pluck('name'); $coa = DB::table('coa')->where('id', 1)->first(); $bcode = DB::table('bankaccount')->where('id', $baccid)->pluck('code'); $html2 = ' <tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $bname . '</td> <td style="background-color:#ffffff;"> ' . $bcode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $coa->name . '</td> <td style="background-color:#ffffff;"> ' . $coa->code . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('contravouchar.pdf'); } else { if ($status == 3) { $date = date_create($vdate); PDF::AddPage(); $bname = DB::table('bankinfo')->where('id', $baccid)->first(); $brancename = DB::table('bankaccount')->where('id', $baccid)->first(); $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> <u>Bank To Bank Contra</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vnno . '</td> <td></td> <td>Manual V. No:' . $type . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:35%;"> Head of Accounts</th> <th style="width:15%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $bname = DB::table('bankaccount')->where('id', $baccid)->pluck('name'); $cash = DB::table('bankaccount')->where('id', $cashid)->pluck('name'); $ccode = DB::table('bankaccount')->where('id', $cashid)->pluck('code'); $bcode = DB::table('bankaccount')->where('id', $baccid)->pluck('code'); $html2 = ' <tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $bname . '</td> <td style="background-color:#ffffff;"> ' . $bcode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $cash . '</td> <td style="background-color:#ffffff;"> ' . $ccode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('contravouchar.pdf'); } } } }
public function pdf(Request $request, $id, $type) { //echo $id.$type; $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; } if ($type == 1) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $bname = $v->bname; $branchname = $v->branchname; $accno = $v->accno; $checkno = $v->checkno; $vdate = $v->vdate; $baid = $v->baid; $sid = $v->sid; $bacode = $v->bacode; $scode = $v->scode; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>Bank Payment Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Bank Name:' . $bname . '</td> <td></td> <td>Branch Name:' . $branchname . '</td> </tr> <tr> <td>A/C No.' . $accno . '</td> <td></td> <td>Check No.' . $checkno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $sname = DB::table('suppliers')->where('id', $sid)->pluck('name'); $bname = DB::table('bankaccount')->where('id', $baid)->pluck('name'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $sname . '</td> <td style="background-color:#ffffff;">' . $scode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $bname . '</td> <td style="background-color:#ffffff;"> ' . $bacode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbp.pdf'); } else { if ($type == 2) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $sid = $v->sid; $scode = $v->scode; $vdate = $v->vdate; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>Payment Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Unit/Place:</td> <td></td> <td>Manual V. No.</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $sname = DB::table('suppliers')->where('id', $sid)->pluck('name'); $cashname = DB::table('coa')->where('id', 1)->pluck('name'); $cashcode = DB::table('coa')->where('id', 1)->pluck('code'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $sname . '</td> <td style="background-color:#ffffff;">' . $scode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $cashname . '</td> <td style="background-color:#ffffff;">' . $cashcode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbpp.pdf'); } else { if ($type == 3) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $bname = $v->bname; $branchname = $v->branchname; $accno = $v->accno; $checkno = $v->checkno; $vdate = $v->vdate; $baid = $v->baid; $cid = $v->cid; $bacode = $v->bacode; $ccode = $v->ccode; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>Bank Receive Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Bank Name:' . $bname . '</td> <td></td> <td>Branch Name:' . $branchname . '</td> </tr> <tr> <td>A/C No.' . $accno . '</td> <td></td> <td>Check No.' . $checkno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $cname = DB::table('customers')->where('id', $cid)->pluck('name'); $bname = DB::table('bankaccount')->where('id', $baid)->pluck('name'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $bname . '</td> <td style="background-color:#ffffff;">' . $bacode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $cname . '</td> <td style="background-color:#ffffff;">' . $ccode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbp.pdf'); } else { if ($type == 4) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $cid = $v->cid; $ccode = $v->ccode; $vdate = $v->vdate; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>Receive Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $cname = DB::table('customers')->where('id', $cid)->pluck('name'); $cashname = DB::table('coa')->where('id', 1)->pluck('name'); $cashcode = DB::table('coa')->where('id', 1)->pluck('code'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $cashname . '</td> <td style="background-color:#ffffff;">' . $cashcode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $cname . '</td> <td style="background-color:#ffffff;"> ' . $ccode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbpp.pdf'); } else { if ($type == 5) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $bname = $v->bname; $baname = $v->baname; $branchname = $v->branchname; $checkno = $v->checkno; $vdate = $v->vdate; $baid = $v->baid; $bacode = $v->bacode; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>Contra Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Bank Name:' . $bname . '</td> <td></td> <td>Branch Name:' . $branchname . '</td> </tr> <tr> <td>A/C No.' . $baname . '</td> <td></td> <td>Check No.' . $checkno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $cashname = DB::table('coa')->where('id', 1)->pluck('name'); $cashcode = DB::table('coa')->where('id', 1)->pluck('code'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $cashname . '</td> <td style="background-color:#ffffff;">' . $cashcode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $baname . '</td> <td style="background-color:#ffffff;">' . $bacode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbp.pdf'); } else { if ($type == 6) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $cid = $v->cid; $ccode = $v->ccode; $vdate = $v->vdate; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>bKash Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $cname = DB::table('customers')->where('id', $cid)->pluck('name'); $cashname = DB::table('coa')->where('id', 1)->pluck('name'); $cashcode = DB::table('coa')->where('id', 1)->pluck('code'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $cashname . '</td> <td style="background-color:#ffffff;">' . $cashcode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $cname . '</td> <td style="background-color:#ffffff;"> ' . $ccode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbpp.pdf'); } else { if ($type == 7) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $cid = $v->cid; $ccode = $v->ccode; $vdate = $v->vdate; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>SAP Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $cname = DB::table('customers')->where('id', $cid)->pluck('name'); $cashname = DB::table('coa')->where('id', 1)->pluck('name'); $cashcode = DB::table('coa')->where('id', 1)->pluck('code'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $cashname . '</td> <td style="background-color:#ffffff;">' . $cashcode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $cname . '</td> <td style="background-color:#ffffff;"> ' . $ccode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbpp.pdf'); } else { if ($type == 8) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $cid = $v->cid; $ccode = $v->ccode; $vdate = $v->vdate; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>KCS Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $cname = DB::table('customers')->where('id', $cid)->pluck('name'); $cashname = DB::table('coa')->where('id', 1)->pluck('name'); $cashcode = DB::table('coa')->where('id', 1)->pluck('code'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $cashname . '</td> <td style="background-color:#ffffff;">' . $cashcode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $cname . '</td> <td style="background-color:#ffffff;"> ' . $ccode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbpp.pdf'); } else { if ($type == 9) { $var = array($id, $type); $spname = "voucher"; $value = Info::callinfo($var, $spname); //print_r($value); foreach ($value as $v) { $vrno = $v->vrno; $mvno = $v->mvno; $amount = $v->amount; $cid = $v->cid; $ccode = $v->ccode; $vdate = $v->vdate; } $date = date_create($vdate); 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>MBank Voucher</u></h2> <table border="0" style="width:100%"> <tr> <td>Voucher No:' . $vrno . '</td> <td></td> <td>Manual V. No:' . $mvno . '</td> </tr> <tr> <td>Month:' . date_format($date, " F,Y") . '</td> <td></td> <td>Date:' . $vdate . '</td> </tr> </table> </div> <div> </div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:10%;"> SL</th> <th style="width:30%;"> Head of Accounts</th> <th style="width:20%"> A/C Code</th> <th> DR(BDT)</th> <th> CR(BDT)</th> </tr>'; $cname = DB::table('customers')->where('id', $cid)->pluck('name'); $cashname = DB::table('coa')->where('id', 1)->pluck('name'); $cashcode = DB::table('coa')->where('id', 1)->pluck('code'); $html2 = '<tr> <td style="background-color:#ffffff;"> 1</td> <td style="background-color:#ffffff;"> ' . $cashname . '</td> <td style="background-color:#ffffff;">' . $cashcode . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"></td> </tr> <tr> <td style="background-color:#ffffff;"> 2</td> <td style="background-color:#ffffff;"> ' . $cname . '</td> <td style="background-color:#ffffff;">' . $ccode . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr> <tr> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> Total:</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html3 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($amount) . ' Taka Only</h4></div> <div></div> <div></div><div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('vbpp.pdf'); } } } } } } } } } }
public function pdf(Request $request, $pid) { $profile = Companyprofile::get(); //print_r($profile); 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; } $var = array($pid); $spname = "viewsales"; $value = Info::callinfo($var, $spname); foreach ($value as $valu) { $id = $valu->id; $sailname = $valu->sname; $salesdate = $valu->salesdate; $cusname = $valu->cname; $phone = $valu->phone; $preaddress = $valu->preaddress; } //$pdate=date_create($purchasedate); //$sdate=date_create($suppliersbilldate); $spname1 = "salesdetailsview"; $value1 = Info::callinfo($var, $spname1); $sum = 0; foreach ($value1 as $valu) { $a = $valu->amount; $sum = $sum + $a; } 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div><div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th>SI No</th> <th>Item Name</th> <th>Quantity</th> <th>Measurement Unit</th> <th>Rate</th> <th>Amount</th> </tr>'; $html2 = ''; $i = 1; $sum = 0; foreach ($value1 as $valu) { $html = '<tr><td>' . $i . '</td> <td style="background-color:#ffffff;">' . $valu->iname . '</td> <td style="background-color:#ffffff;">' . $valu->quantity . '</td> <td style="background-color:#ffffff;">' . $valu->mname . '</td> <td style="background-color:#ffffff;">' . $valu->rate . '</td> <td style="background-color:#ffffff;">' . $valu->amount . '</td></tr>'; $html2 = $html2 . $html; $i++; $sum = $sum + $valu->amount; } $html3 = '<tr><td colspan="5" align="right">'; $html4 = ''; $html5 = 'Total:</td><td style="background-color:#ffffff;">' . number_format($sum, 2, '.', '') . '</td></tr>'; $html6 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord($sum) . ' Taka Only</h4></div> <div></div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3 . $html4 . $html5 . $html6; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('sales.pdf'); }
public function challan(Request $request, $pid) { $profile = Companyprofile::get(); //print_r($profile); 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; } $var = array($pid); $spname = "viewsales"; $value = Info::callinfo($var, $spname); foreach ($value as $valu) { $id = $valu->id; $sailname = $valu->sname; $salesdate = $valu->salesdate; $cusname = $valu->cname; $phone = $valu->phone; $preaddress = $valu->preaddress; } //$pdate=date_create($purchasedate); //$sdate=date_create($suppliersbilldate); $spname1 = "salesdetailsview"; $value1 = Info::callinfo($var, $spname1); $spname2 = "challanitem"; $value2 = Info::callinfo($var, $spname2); $value3 = Info::callinfo($var, $spname2); //print_r($var); die(); $sum = 0; foreach ($value1 as $valu) { $a = $valu->amount; $sum = $sum + $a; } 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> ' . $address . ' <br>Tel:' . $tele . ',Mobile:' . $mobile . ' <br>E-mail:' . $email . ' <br>' . $url . ' </td> </tr> </table> </div> <div> <h2> <u>CHALLAN</u></h2> <table border="0" style="width:100%"> <tr> <td>Customer Name:' . $cusname . '</td> <td></td> <td>Voucher No:' . $sailname . '</td> </tr> <tr> <td>Address:' . $preaddress . '</td> <td></td> <td>Date:' . $salesdate . '</td> </tr> <tr> <td>Mobile No:' . $phone . '</td> <td></td> <td></td> </tr> </table> </div> <div> <table border="1 solid" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th style="width:15%;"> SI No</th> <th> Code</th> <th style="width:30%;"> Description</th> <th> Quantity</th> </tr>'; $html2 = ''; $i = 1; $total = 0; foreach ($value1 as $valu) { $html = '<tr><td style="background-color:#ffffff;"> ' . $i . '</td> <td style="background-color:#ffffff;"> ' . $valu->icode . '</td> <td style="background-color:#ffffff;"> ' . $valu->iname . '</td> <td style="background-color:#ffffff;"> ' . $valu->quantity . '</td> </tr>'; $html2 = $html2 . $html; $i++; $total = $total + $valu->quantity; } $html3 = '<tr><td colspan="3" align="right" style="background-color:#ffffff;">'; $html4 = ''; $html5 = 'Total:</td><td style="background-color:#ffffff;"> ' . $total . '</td></tr>'; $html6 = '<tr><td colspan="4">'; $html7 = ''; foreach ($value3 as $v) { $factioyitems = DB::table('factioyitems')->where('itemsid', $v->id)->where('salesid', $id)->get(); //print_r($factioyitems); $h = '<span style="color:green;">' . $id . $v->id . $v->name . '</span>('; $h1 = ''; foreach ($factioyitems as $f) { $h2 = '' . $f->slno . ','; $h1 = $h1 . $h2; } $h3 = ')<br>'; $html = $h . $h1 . $h3; $html7 = $html7 . $html; } $html8 = '</td></tr>'; $html9 = '</table><h4>Amount in word:' . CommonController::convertNumberToWord(number_format($total, 2, '.', '')) . ' Pcs Only</h4></div> <div> </div> <div class="col-md-12" style=" background-color: #ffffff;color:#000000;"> <h3> Received By Prepared By Approved By </h3> </div>'; $html = $html1 . $html2 . $html3 . $html4 . $html5 . $html6 . $html7 . $html8 . $html9; PDF::writeHTML($html, true, false, true, false, ''); PDF::Output('challan.pdf'); }