/** * Display a listing of payments * * @return Response */ public function index() { $payments = Payment::all(); $erporders = Erporder::all(); $erporderitems = Erporderitem::all(); return View::make('payments.index', compact('payments', 'erporderitems', 'erporders')); }
public function payments() { $payments = Payment::all(); $erporders = Erporder::all(); $erporderitems = Erporderitem::all(); $organization = Organization::find(1); $pdf = PDF::loadView('erpreports.paymentsReport', compact('payments', 'erporders', 'erporderitems', 'organization'))->setPaper('a4')->setOrientation('potrait'); return $pdf->stream('Payment List.pdf'); }
public function filters($offset = 0) { $this->load->helpers('date'); $string = '%' . $this->input->post('estudiante') . '%'; $usuario = $this->input->post('user_id'); $fecha_desde = $this->input->post('fecha_desde'); $fecha_hasta = $this->input->post('fecha_hasta'); $condiciones = 'anulado = ?'; $valores[] = 0; if ($string != '%%') { $condiciones .= " AND CONCAT(students.apellido,' ', students.nombre) LIKE ?"; $valores[] = $string; } if ($usuario > 0) { /*if($condiciones != ''){ $condiciones .= " AND "; }*/ $condiciones .= " AND user_id = ?"; $valores[] = $usuario; } if ($fecha_desde != '') { $fecha_desde = mdate('%Y-%m-%d', normal_to_unix($fecha_desde)); if ($fecha_hasta != '') { $fecha_hasta = mdate('%Y-%m-%d', normal_to_unix($fecha_hasta)); } else { $fecha_hasta = date('Y-m-d'); } /*if($condiciones != ''){ $condiciones .= " AND "; }*/ $condiciones .= " AND fecha BETWEEN ? AND ?"; $valores[] = $fecha_desde; $valores[] = $fecha_hasta; } $conditions = array_merge(array($condiciones), $valores); $config['base_url'] = site_url('pagos/index'); $config['total_rows'] = Payment::count(array('joins' => array('student'), 'conditions' => $conditions)); $config['per_page'] = '10'; $config['num_links'] = '10'; $config['first_link'] = '← primero'; $config['last_link'] = 'último →'; $this->load->library('pagination', $config); $pagos = array(); $pagos = Payment::all(array('joins' => array('student'), 'conditions' => $conditions, 'limit' => $config['per_page'], 'offset' => $offset)); $this->table->set_heading('Fecha', 'Nro Comprobante', 'Estudiante', 'Importe', 'Usuario', 'Acciones'); foreach ($pagos as $pago) { $this->table->add_row($pago->fecha->format('d/m/Y'), $pago->nro_comprobante, $pago->student->apellido . ' ' . $pago->student->nombre, $pago->importe, $pago->user->apellido . ' ' . $pago->user->nombre, anchor('pagos/ver/' . $pago->id, img('static/img/icon/doc_lines.png'), 'class="tipwe" title="Ver detalles pago"') . ' ' . anchor('pagos/editar/' . $pago->id, img('static/img/icon/pencil.png'), 'class="tipwe" title="Editar pago"') . ' ' . anchor('pagos/eliminar/' . $pago->id, img('static/img/icon/trash.png'), 'class="tipwe eliminar" title="Eliminar pago"')); } echo $this->table->generate(); echo '<div class="pagination">'; echo $this->pagination->create_links(); echo '</div>'; }
/** * Display a listing of payments * * @return Response */ public function index() { /* $payments = DB::table('payments') ->join('erporders', 'payments.erporder_id', '=', 'erporders.id') ->join('erporderitems', 'payments.erporder_id', '=', 'erporderitems.erporder_id') ->join('clients', 'erporders.client_id', '=', 'clients.id') ->join('items', 'erporderitems.item_id', '=', 'items.id') ->select('clients.name as client','items.name as item','payments.amount_paid as amount','payments.date as date','payments.erporder_id as erporder_id','payments.id as id','erporders.order_number as order_number') ->get(); */ $erporders = Erporder::all(); $erporderitems = Erporderitem::all(); $paymentmethods = Paymentmethod::all(); $payments = Payment::all(); return View::make('payments.index', compact('payments', 'erporderitems', 'erporders', 'paymentmethods')); }
public function getPaymentsList() { $data = Input::all(); // dd($data); if (Input::get('search')) { $validator = Validator::make($data, array('from_date' => 'required|date', 'to_date' => 'required|date')); if ($validator->fails()) { return Redirect::back()->with($validator->errors()); } $from = Input::get('from_date'); $to = Input::get('to_date'); $payments = Payment::where('payment_date_time', '>=', $from)->where('payment_date_time', '<=', $to)->get(); // dd($payments); } else { $payments = Payment::all(); } return View::make('payments.index', compact('payments', 'from', 'to')); }
/** * @before _secure */ public function affiliates() { $this->seo(array("title" => "Billing")); $view = $this->getActionView(); $start = RM::get("start", date("Y-m-d", strtotime('-60 day'))); $end = RM::get("end", date("Y-m-d", strtotime('now'))); $query = ['utype' => 'publisher', 'org_id' => $this->org->_id]; $payments = \Payment::all($query); $page = RM::get("page", 1); $limit = RM::get("limit", 10); $property = RM::get("property"); $value = RM::get("value"); if ($property) { $query["{$property} = ?"] = $value; } else { $query['created'] = Db::dateQuery($start, $end); } $invoices = \Invoice::all($query); $view->set('invoices', $invoices)->set('payments', $payments)->set('active', Invoice::count(['utype' => 'publisher', 'org_id' => $this->org->_id, "live = ?" => 1]))->set('inactive', Invoice::count(['utype' => 'publisher', 'org_id' => $this->org->_id, "live = ?" => 0]))->set('start', $start)->set('end', $end); }
/** * Display a listing of payments * * @return Response */ public function index() { $payments = Payment::all(); return View::make('payments.index', compact('payments')); }
/** * @before _secure */ public function account() { $this->seo(array("title" => "Account")); $view = $this->getActionView(); $invoices = \Invoice::all(['user_id = ?' => $this->user->_id], ['start', 'end', 'amount', 'live', 'created']); $payments = \Payment::all(['user_id = ?' => $this->user->_id], ['type', 'amount', 'meta', 'live', 'created']); $user = $this->user; $view->set("errors", []); if (RM::type() == 'POST') { $action = RM::post('action', ''); switch ($action) { case 'account': $fields = ['name', 'phone', 'currency', 'username']; foreach ($fields as $f) { $user->{$f} = RM::post($f); } $user->save(); $view->set('message', 'Account Info updated!!'); break; case 'password': $old = RM::post('password'); $new = RM::post('npassword'); $view->set($user->updatePassword($old, $new)); break; case 'bank': $user->getMeta()['bank'] = ['name' => RM::post('account_bank', ''), 'ifsc' => RM::post('account_code', ''), 'account_no' => RM::post('account_number', ''), 'account_owner' => RM::post('account_owner', '')]; $user->save(); $view->set('message', 'Bank Info Updated!!'); break; case 'payout': $user->getMeta()['payout'] = ['paypal' => RM::post('paypal', ''), 'payquicker' => RM::post('payquicker', ''), 'payoneer' => RM::post('payoneer', ''), 'paytm' => RM::post('paytm', ''), 'mobicash' => RM::post('mobicash', ''), 'easypaisa' => RM::post('easypaisa', '')]; $user->save(); $view->set('message', 'Payout Info Updated!!'); break; case 'custom': $output = Shared\Services\User::customFields($user, $this->org); if (!$output['success']) { return $view->set($output); } $user->save(); $view->set('user', $user); $view->set('message', 'Custom field updated!!'); break; default: $this->_postback('add'); break; } $this->setUser($user); } if (RM::type() === 'DELETE') { $this->_postback('delete'); } $this->_postback('show'); $afields = Meta::search('customField', $this->org); $view->set('afields', $afields)->set("invoices", $invoices)->set("payments", $payments); }