PHP Payment::all方法代码示例

 /**
  * 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);
 }