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 edit(Request $request, $id) { if ($request->method() == 'POST') { $id = $request->input('id'); $m = Employeeinfo::find($id); $m->name = $request->input('name'); $m->designation = $request->input('designation'); $m->joindate = CommonController::date_format($request->input('joindate')); $m->preaddress = $request->input('preaddress'); $m->peraddress = $request->input('peraddress'); $m->salary = $request->input('salary'); $m->employeetype = $request->input('employeetype'); $m->uid = $request->input('uid'); if (Input::file('file')->isValid()) { $d = 'uploads'; $e = Input::file('file')->getClientOriginalExtension(); $f = rand(11111, 99999) . '.' . $e; Input::file('file')->move($d, $f); } $m->file = $f; $m->userid = $request->input('userid'); $m->save(); return Redirect('employee'); } $data['employee'] = Employeeinfo::find($id); return view('editemployee', $data); }
public function fromtoday(Request $request) { $fromdate = CommonController::date_format($request->input('fromdate')); $todate = CommonController::date_format($request->input('todate')); $var = array($fromdate, $todate); //print_r($var); $spname = "rptsales"; $value = Info::callinfo($var, $spname); //print_r($value); return view('reportsaleview', compact('value', 'fromdate', 'todate')); }
public function edit(Request $request, $id) { if ($request->method() == 'POST') { $id = $request->input('id'); $b = Employeesalary::find($id); $b->eid = $request->input('ename'); $b->pid = $request->input('pname'); $b->amount = $request->input('amount'); $b->vdate = CommonController::date_format($request->input('vdate')); $b->description = $request->input('description'); $b->save(); return Redirect('employeesal'); } $data['employeesal'] = Employeesalary::find($id); return view('editemployeesal', $data); }
public function edit(Request $request, $id) { if ($request->method() == 'POST') { $id = $request->input('id'); $b = Bankaccount::find($id); $b->code = $request->input('code'); $b->name = $request->input('name'); $b->accotitle = $request->input('accotitle'); $b->bankid = $request->input('bankid'); $b->branchname = $request->input('branchname'); $b->opendate = CommonController::date_format($request->input('opendate')); $b->exdate = CommonController::date_format($request->input('exdate')); $b->rate = $request->input('rate'); $b->openbalance = $request->input('openbalance'); $b->save(); return Redirect('bankaccount'); } $data['bankaccount'] = Bankaccount::find($id); $ba = Bankinfo::get(); return view('editbankaccount', $data)->with('bankinfo', $ba); }
public function edit(Request $request, $pid = NULL) { if ($request->method() == 'POST') { $edit_purchase = Purchase::find($request->input('purchase_id')); if (!empty($request->input('purchase_date'))) { $edit_purchase->purchasedate = CommonController::date_format($request->input('purchase_date')); } if (!empty($request->input('supplier_bill_date'))) { $edit_purchase->suppliersbilldate = CommonController::date_format($request->input('supplier_bill_date')); } $edit_purchase->suppliersbillno = $request->input('supplier_bill_no'); $edit_purchase->challanno = $request->input('supplier_challan_no'); $edit_purchase->sub_total = $request->input('sub_total'); $edit_purchase->discount = $request->input('discount'); $edit_purchase->others_exp = $request->input('others_exp'); $edit_purchase->gross_total = $request->input('gross_total'); $edit_purchase->save(); $purchase_detail_id = $request->input('purchase_detail_id'); $qnt = $request->input('qnt'); // $measurementid=$request->input('measurementid'); $rate = $request->input('rate'); $amount = $request->input('amount'); // $sum=0; foreach ($purchase_detail_id as $item => $value) { if ($qnt[$item] != '' && $rate[$item] != '') { $u = Purchasedetails::find($value); $u->quantity = $qnt[$item]; $u->rate = $rate[$item]; $u->amount = $amount[$item]; $u->save(); } } DB::table('suppliersledger')->where('puv', $request->input('purchase_id'))->update(['amount' => $request->input('gross_total')]); return Redirect('purchase'); } $var = array($pid); $spname = "viewpurchase"; $data['purchase_info'] = Info::callinfo($var, $spname); $spname1 = "purchasedetailsview"; $data['invoice_info'] = Info::callinfo($var, $spname1); $data['purchase'] = Purchase::find($pid); return view('edit_purchase', $data); }
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> Sub Ledger</h2> <h4> Cash Collection A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Cash Payment A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Bkash A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> SAP A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> KCS A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> MBank A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Bank Collection A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Bank Payment A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Sales A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Invoice No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Purchase A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Purchase No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $purchasedate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $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> ' . 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> Sub Ledger</h2> <h4> Salary A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Employee Name</th> <th>Description</th> <th > Particulars</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $employeename . '</td> <td style="background-color:#ffffff;"> ' . $description . '</td> <td style="background-color:#ffffff;">' . $particularsname . '</td> <td style="background-color:#ffffff;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="5" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Ledger Account</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $created_at . '</td> <td style="background-color:#ffffff;">' . $description . '</td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/ledgerentry/pdf/' . $valu->id . '" target="_blank">' . $id . '</a></td> <td style="background-color:#ffffff;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Cash Collection A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Cash Payment A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Bkash A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> SAP A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> KCS A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> MBank A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Bank Collection A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Bank Payment A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Sales A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Invoice No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Purchase A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Purchase No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $purchasedate . '</td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $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> ' . 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> Sub Ledger</h2> <h4> Salary A/C</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Employee Name</th> <th>Description</th> <th > Particulars</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $vdate . '</td> <td style="background-color:#ffffff;"> ' . $employeename . '</td> <td style="background-color:#ffffff;"> ' . $description . '</td> <td style="background-color:#ffffff;">' . $particularsname . '</td> <td style="background-color:#ffffff;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="5" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> Sub Ledger</h2> <h4> Ledger Account</h4> <h4> From ' . date_format($fdate, "d-M-Y") . ' To ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher No.</th> <th> Debit/Credit</th> <th> Amount</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $created_at . '</td> <td style="background-color:#ffffff;">' . $description . '</td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/ledgerentry/pdf/' . $valu->id . '" target="_blank">' . $id . '</a></td> <td style="background-color:#ffffff;"> ' . $dc . '</td> <td style="background-color:#ffffff;"> ' . $amount . '</td> </tr>'; $html2 = $html2 . $ht; $total = $total + $amount; } $html3 = '<tr><td colspan="4" align="right" style="background-color:#ffffff;">Total:</td><td> ' . 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> SUPPLIER A/C</h2> <h4> Ledger Account</h4> <h4> ' . date_format($fdate, "d-M-Y") . ' ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher Type</th> <th > Voucher No.</th> <th> Debit</th> <th> Credit</th> <th> Balance</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $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;"> <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;"> <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;"> </td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $debit . '</td> <td style="background-color:#ffffff;"> </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> ' . 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> SUPPLIER A/C</h2> <h4> Ledger Account</h4> <h4> ' . date_format($fdate, "d-M-Y") . ' ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher Type</th> <th > Voucher No.</th> <th> Debit</th> <th> Credit</th> <th> Balance</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $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;"> <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;"> <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;"> </td> <td style="background-color:#ffffff;"> ' . $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;"> ' . $debit . '</td> <td style="background-color:#ffffff;"> </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> ' . 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 banktobankregister(Request $request) { $v = new Voucher(); $v->vnno = $request->input('vnno'); $v->vdate = CommonController::date_format($request->input('vdate')); $v->status = 3; $v->type = 5; $v->amount = $request->input('amount'); $v->userid = $request->input('userid'); $v->save(); $LastInsertId = $v->id; //echo $LastInsertId; if ($LastInsertId != NULL) { $b = new Vouchercontra(); $b->vid = $LastInsertId; $b->baccid = $request->input('baccid'); $b->cashid = $request->input('cashid'); $b->checkno = $request->input('checkno'); $b->userid = $request->input('userid'); $b->save(); $b = new Bankbook(); $b->vid = $LastInsertId; $b->baccid = $request->input('baccid'); $b->dc = 1; $b->amount = $request->input('amount'); //$b->sid = $request->input('sid'); $b->checkno = $request->input('checkno'); $b->userid = $request->input('userid'); $b->save(); $b1 = new Bankbook(); $b1->vid = $LastInsertId; $b1->baccid = $request->input('cashid'); $b1->dc = 0; $b1->amount = $request->input('amount'); //$b->sid = $request->input('sid'); $b1->checkno = $request->input('checkno'); $b1->userid = $request->input('userid'); $b1->save(); } return redirect('contravoucher'); }
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> CUSTOMER A/C</h2> <h4> Ledger Account</h4> <h4> </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 > Month & Date</th> <th>Particulars</th> <th > Voucher Type</th> <th > Voucher No.</th> <th> Debit</th> <th> Credit</th> <th> Balance</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $valu->created_at . '</td> <td style="background-color:#ffffff;">' . $acc . '</td> '; if ($valu->rvoucher != NULL) { $h6 = '<td style="background-color:#ffffff;"> Receipt</td>'; } else { $h6 = '<td style="background-color:#ffffff;"> Sales</td>'; } if ($valu->rvoucher != NULL) { $h5 = '<td style="background-color:#ffffff;"> <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;"> <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;"> ' . $debit . '</td> <td style="background-color:#ffffff;"> </td>'; //$debit=$debit+$valu->amount; } if ($valu->rvoucher != NULL) { $credit = $valu->amount; $h1 = '<td style="background-color:#ffffff;"> </td> <td style="background-color:#ffffff;"> ' . $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> </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> CUSTOMER A/C</h2> <h4> Ledger Account</h4> <h4> ' . date_format($fdate, "d-M-Y") . ' ' . 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 > Month & Date</th> <th>Particulars</th> <th > Voucher Type</th> <th > Voucher No.</th> <th> Debit</th> <th> Credit</th> <th> Balance</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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;"> ' . $valu->created_at . '</td> <td style="background-color:#ffffff;">' . $acc . '</td> '; if ($valu->rvoucher != NULL) { $h6 = '<td style="background-color:#ffffff;"> Receipt</td>'; } else { $h6 = '<td style="background-color:#ffffff;"> Sales</td>'; } if ($valu->rvoucher != NULL) { $h5 = '<td style="background-color:#ffffff;"> <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;"> <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;"> ' . $debit . '</td> <td style="background-color:#ffffff;"> </td>'; //$debit=$debit+$valu->amount; } if ($valu->rvoucher != NULL) { $credit = $valu->amount; $ctotal = $ctotal + $credit; $debit = 0.0; $h1 = '<td style="background-color:#ffffff;"> </td> <td style="background-color:#ffffff;"> ' . $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> ' . 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 fromtoday(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; } $fromdate = CommonController::date_format($request->input('fromdate')); $todate = CommonController::date_format($request->input('todate')); $var = array($fromdate, $todate); // $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> <u>Balance Sheet</u></h2> <h4> ' . date_format($fdate, "d-M-Y") . ' To ' . 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>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_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;"><b>' . $t->coatypename . '</b></td><td style="background-color:#ffffff;"><b>' . number_format($debit_total_head, 2, '.', '') . '</b></td></tr>'; // }else{ // $html2 = $html2.'<tr><td style="background-color:#ffffff;"> <b>'.$t->coatypename.'</b></td><td></td><td><b>'.$amount.'</b></td></tr>'; // } } $coatypeid_cur = $t->coatypeid; $h = '<tr><td style="background-color:#ffffff;">' . $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> <b>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(); //print_r($trialbalance); /// die(); $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==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; // } 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;"> <b>' . $t->coatypename . '</b></td><td style="background-color:#ffffff;"> <b>' . number_format($credit_total_head, 2, '.', '') . '</b></td></tr>'; // }else{ // $html2 = $html2.'<tr><td style="background-color:#ffffff;"> <b>'.$t->coatypename.'</b></td><td></td></tr>'; // } } $coatypeid_cur = $t->coatypeid; $h = '<tr><td style="background-color:#ffffff;"> ' . $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;"> <b>Diff. in Opening Balances</b></td> <td style="background-color:#ffffff;"> <b>' . number_format($total_credit - $total_debit, 2, '.', '') . '</b></td> </tr> <tr> <td style="background-color:#ffffff;"> <b>Total</b></td> <td style="background-color:#ffffff;"> <b>' . number_format($total_credit, 2, '.', '') . '</b></td> </tr>'; } else { $html5 = $html5 . ' <tr> <td></td> <td></td> </tr> <tr> <td style="background-color:#ffffff;"> <b>Total</b></td> <td style="background-color:#ffffff;"> <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;"> <b>Diff. in Opening Balances</b></td> <td style="background-color:#ffffff;"> <b>' . number_format($total_debit - $total_credit, 2, '.', '') . '</b></td> </tr> <tr> <td style="background-color:#ffffff;"> <b>Total</b></td> <td style="background-color:#ffffff;"> <b>' . number_format($total_debit, 2, '.', '') . '</b></td> </tr>'; } else { $html5 = $html5 . ' <tr> <td></td> <td></td> </tr> <tr> <td style="background-color:#ffffff;"> <b>Total</b></td> <td style="background-color:#ffffff;"> <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 registermbank(Request $request) { $v = new Voucher(); $v->vnno = $request->input('vnno'); $v->vdate = CommonController::date_format($request->input('vdate')); $v->amount = $request->input('amount'); $v->amount = $request->input('camount'); $v->status = 1; $v->type = 9; $v->cid = $request->input('cid'); $v->userid = $request->input('userid'); $v->save(); $LastInsertId = $v->id; if ($LastInsertId != NULL) { $m = new Vouchermbank(); $m->vid = $LastInsertId; $m->mbankno = $request->input('mbankno'); $m->cid = $request->input('cid'); $m->userid = $request->input('userid'); $m->save(); } $c = new Customersledger(); $c->rv = $LastInsertId; $c->cid = $request->input('cid'); $c->amount = $request->input('camount'); $c->save(); return redirect('voucher'); }
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> <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 > Date</th> <th>Particulars</th> <th > Supplier Name</th> <th > Customer Name</th> <th > Voucher No</th> <th> Debit</th> <th> Credit</th> <th> Balance</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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> ' . 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;"> ' . $v->created_at . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->sname . '</a></td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->cname . '</a></td> <td style="background-color:#ffffff;"> <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;"> ' . $v->created_at . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->sname . '</a></td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->cname . '</a></td> <td style="background-color:#ffffff;"> <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;"> </td> <td style="background-color:#ffffff;"> ' . $v->amount . '</td> <td> ' . 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;"> ' . $v->amount . '</td> <td style="background-color:#ffffff;"> </td> <td> ' . 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;"> ' . $v->amount . '</td> <td style="background-color:#ffffff;"> </td> <td> ' . 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;"> </td> <td style="background-color:#ffffff;"> ' . $v->amount . '</td> <td> ' . 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;"> ' . $v->amount . '</td> <td style="background-color:#ffffff;"></td> <td> ' . 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;"> ' . $v->amount . '</td> <td> ' . 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> <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 > Date</th> <th>Particulars</th> <th > Supplier Name</th> <th > Customer Name</th> <th > Voucher No</th> <th> Debit</th> <th> Credit</th> <th> Balance</th> </tr> <tr> <th style="background-color:#ffffff;"> ' . 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> ' . 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;"> ' . $v->created_at . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->sname . '</a></td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/contravoucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->cname . '</a></td> <td style="background-color:#ffffff;"> <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;"> ' . $v->created_at . '</td> <td style="background-color:#ffffff;"></td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->sname . '</a></td> <td style="background-color:#ffffff;"> <a href="http://192.168.1.8/IMS/voucher/pdf/' . $v->vid . '/' . $v->type . '">' . $v->cname . '</a></td> <td style="background-color:#ffffff;"> <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;"> </td> <td style="background-color:#ffffff;"> ' . $v->amount . '</td> <td> ' . 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;"> ' . $v->amount . '</td> <td style="background-color:#ffffff;"> </td> <td> ' . 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;"> ' . $v->amount . '</td> <td style="background-color:#ffffff;"> </td> <td> ' . 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;"> </td> <td style="background-color:#ffffff;"> ' . $v->amount . '</td> <td> ' . 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;"> ' . $v->amount . '</td> <td style="background-color:#ffffff;"></td> <td> ' . 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;"> ' . number_format($credit, 2, '.', '') . '</td> <td style="background-color:#ffffff;"> ' . 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'); } } }
public function register(Request $request) { $invoice_info = Session::get('physcl_sale_invoice_info'); $grosstotal = $request->input('gross_total'); $salesamount = DB::table('sales')->where('customerid', $request->input('customersid'))->where('status', 1)->sum('gamount'); $receiveamount = DB::table('voucher')->where('cid', $request->input('customersid'))->where('vstatus', 1)->whereIn('type', [3, 4, 6, 7, 8, 9])->sum('amount'); $creditlimit = DB::table('customers')->where('id', $request->input('customersid'))->first(); $closebalance = $creditlimit->openbalance + $receiveamount - $salesamount; //$total=$closebalance+$grosstotal; //echo $closebalance; //die(); // echo 'C-'.$creditlimit->creditlimit.'T-'.$total; die(); //if($closebalance<=$creditlimit->creditlimit){ //save sales $qnt = $request->input('qnt'); $rate = $request->input('rate'); $count_row = 0; foreach ($qnt as $key => $value) { if ($value != '' && $rate[$key] != '') { $count_row++; } } if ($count_row > 0) { $customer = Customer::find($request->input('customersid')); $serial_no = $request->input('serial_no'); $discount = $request->input('discount'); $u = new Physicalsale(); /* $customer = Customer::find($sales->customerid); if($customer->lastdue==0){ $sales->previousdue=$customer->openbalance; }else{ $sales->previousdue=$customer->lastdue; } $sales->presentbalance=$sales->gamount+$sales->previousdue; $customer->lastdue = $sales->presentbalance; $customer->save(); */ $u->name = $request->input('name'); $u->salesdate = CommonController::date_format($request->input('sales_date')); $u->customerid = $request->input('customersid'); $u->discount = $request->input('discount'); $u->userid = $request->input('userid'); if ($customer->bstatus == 0) { $u->previousdue = $customer->openbalance; } else { $u->previousdue = $customer->lastdue; } $u->presentbalance = $grosstotal + $u->previousdue; $u->save(); $customer->lastdue = $u->presentbalance; $customer->bstatus = 1; $customer->save(); $LastInsertId = $u->id; //echo $LastInsertId; if ($LastInsertId != NULL) { // //echo $LastInsertId.'<br>'; $itemid = $request->input('itemid'); $qnt = $request->input('qnt'); $measurementid = $request->input('measurementid'); $rate = $request->input('rate'); $amount = $request->input('amount'); $sum = 0; foreach ($itemid as $item => $value) { if ($qnt[$item] != '' && $rate[$item] != '') { $u = new Salesdetails(); $u->salesid = $LastInsertId; $u->itemid = $value; $u->quantity = $qnt[$item]; $u->mesid = $measurementid[$item]; $u->rate = $rate[$item]; $u->amount = $amount[$item]; $u->userid = $request->input('userid'); $u->save(); $sum = $sum + $amount[$item]; if ($invoice_info[$item]->serial_no_exist == 1) { foreach ($invoice_info[$item]->product_slno as $slno_id) { $factory_item = Factoryitem::find($slno_id); $factory_item->salesid = $LastInsertId; $factory_item->sale_product = 1; $factory_item->save(); } } else { $sale_product_item = Item::find($value); $sale_product_item->quantity = $sale_product_item->quantity - $qnt[$item]; $sale_product_item->save(); } // $factory_items = Factoryitem::where('itemsid', $value) // ->where('status', 1) // ->where('sale_product', 0) // ->orderBy('id', 'asc') // ->take($qnt[$item]) // ->get(); // foreach ($factory_items as $fac_item) { // $fac_item->salesid = $LastInsertId; // $fac_item->sale_product = 1; // $fac_item->save(); // } } } $dis = $sum - $discount; $c = new Customersledger(); $c->sv = $LastInsertId; $c->cid = $request->input('customersid'); $c->amount = $dis; $c->dc = 0; $c->save(); Physicalsale::where('id', $LastInsertId)->update(array('gamount' => $dis)); } if (Session::has('physcl_sale_invoice_info')) { Session::forget('physcl_sale_invoice_info'); Session::forget('physcl_sale_sub_total'); Session::forget('physcl_sale_discount'); Session::forget('physcl_sale_gross_total'); Session::forget('physcl_sale_serial_no'); Session::forget('physcl_sale_sales_date'); Session::forget('physcl_sale_customer'); } } else { return Redirect('physicalsales/addnew'); } return Redirect('physicalsales'); //save sales //}else{ //echo '-S'.$salesamount.'-R'.$receiveamount.'-C'.$creditlimit->creditlimit.'-O'.$creditlimit->openbalance.'<br>'; // echo 'Total'.$closebalance.'<br>'; // echo 'Your Credit is'.$creditlimit->creditlimit; // } /* */ }
public function fromtoday(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; } $fromdate = CommonController::date_format($request->input('fromdate')); $todate = CommonController::date_format($request->input('todate')); $var = array($fromdate, $todate); // $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($fromdate); //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; } $fdate = date_create($fromdate); $tdate = date_create($todate); $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> <u>Cash A/C Book</h3></u></div> <div><strong>From ' . date_format($fdate, "d-M-Y") . ' To ' . date_format($tdate, "d-M-Y") . ' </strong></div></div> <table border="1" style="background-color:lightblue; width:100%; padding:20px;"> <tr> <th> 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;"> ' . $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'); }