PHP asoabo Contribution::where Beispiele

Beispiel #1

Datei: ReportController.php Projekt: luigilapa/sapeap

 public function postPayments(Requests\DefaultRequest $request)
 {
     $identification = str_replace(' ', '', $request['identification']);
     $lawyers = Lawyer::where('identification', '=', $identification)->get();
     if ($lawyers->count() == 0) {
         $errors = array("0" => 'No se encontró registro con la cédula ingresada!');
         return $request->response($errors);
     }
     $contributions = Contribution::where('lawyer_id', '=', $lawyers[0]->id)->where('year', '=', $request['year'])->orderBy('month')->get();
     if ($contributions->count() == 0) {
         $errors = array("0" => 'No hay registro de pago!');
         return $request->response($errors);
     }
     $lawyer = $lawyers[0];
     $month = array('enero', 'febrero', 'marzo', 'abril', 'mayo', 'junio', 'julio', 'agosto', 'septiembre', 'octubre', 'noviembre', 'diciembre');
     $rows = "";
     $cont = 0;
     foreach ($contributions as $item) {
         $cont++;
         $mod = $cont % 2 == 0;
         if ($mod == 1) {
             $rows .= '<tr>' . '<td style="background: #E8EDFF; color: #1E252B; font-size: 12px; text-align: left;">' . $month[$item->month - 1] . '</td>' . '<td style="background: #E8EDFF; color: #1E252B; font-size: 12px; text-align: center;">' . $item->amount . '</td>' . '<td style="background: #E8EDFF; color: #1E252B; font-size: 12px; text-align: left; width: 400px;">' . $item->description . '</td>' . '</tr>';
         } else {
             $rows .= '<tr>' . '<td style="background: #F5F5F5; color: #1E252B; font-size: 12px; text-align: left;">' . $month[$item->month - 1] . '</td>' . '<td style="background: #F5F5F5; color: #1E252B; font-size: 12px; text-align: center;">' . $item->amount . '</td>' . '<td style="background: #F5F5F5; color: #1E252B; font-size: 12px; text-align: left; width: 400px;">' . $item->description . '</td>' . '</tr>';
         }
     }
     $html = '<p><b style="color:#2254AD; font-size:14px; text-align:left;">Ab .' . $lawyer->first_name . ' ' . $lawyer->last_name . '</b></p>' . '<p>A&#241;o: ' . $request->year . '</p>' . '<div>' . '<table style="width:100%;">' . '<thead style="">' . '<tr>' . '<th style="background: #D0DAFD; color: #2355AE; font-size: 14px;">Mes</th>' . '<th style="background: #D0DAFD; color: #2355AE; font-size: 14px;">Monto</th>' . '<th style="background: #D0DAFD; color: #2355AE; font-size: 14px; width: 400px;">Nota</th>' . '</tr>' . '</thead>' . '<tbody style="">' . $rows . '</tbody>' . '</table>' . '</div>';
     $header = '<header>' . '<div>' . '<h1 style="color:#2254AD; font-size:16px; text-align:left;">Asociaci&#243;n de Abogados de Manta</h1>' . '<h2 style="color:#1E252B; font-size:12px; text-align:left;">Aportaciones</h2>' . '</div>' . '<div style="position:absolute; width: 55px; margin-top:-65px; margin-left:600px;">' . '<img src="assets/image/logo.jpg" alt="" style="width: 50px; height: 50px;">' . '</div>' . '</header>' . '<hr/>';
     $footer = '<footer>' . '<hr/>' . '<div style="text-align:right;"><p>{PAGENO}</p></div>' . '</footer>';
     $mpdf = new \mPDF('utf-8', 'A4', '', '', '15', '15', '28', '18');
     $mpdf->SetHTMLHeader($header);
     $mpdf->SetHTMLFooter($footer);
     $mpdf->WriteHTML($html);
     $mpdf->Output('aportaciones.pdf', 'D');
 }

Beispiel #2

Datei: ContributionsController.php Projekt: luigilapa/sapeap

 public function postEdit(ContributionEditRequest $request)
 {
     $contribution = Contribution::find($request['id']);
     $exists = Contribution::where('lawyer_id', '=', $contribution->lawyer_id)->where('year', '=', $request['year'])->where('month', '=', $request['month'])->where('id', '<>', $contribution->id)->get();
     if ($exists->count() > 0) {
         $errors = array("0" => 'Ya existe un registro con el mismo A&#241;o-Mes');
         return $request->response($errors);
     }
     $contribution->fill($request->all());
     $contribution->save();
     return redirect()->route('contribution_view')->with('message', 'editok');
 }