Controller - Dsoledispa/Documentacion-DAW2 GitHub Wiki

Transactions

DB::beginTransaction();
try {
  DB::commit();
} catch (\Exception $e) {
  DB::rollback();
  return $e->getMessage();
}

Transaction compleja

DB::beginTransaction();
try {
  $payment = Payment::find($id_payment);
  $payment->id_status = 13;
  $payment->save();
  $card_payment = PaymentCard::find($payment->id_card_payment);
  $card_payment->id_status = 25;
  $card_payment->save();
  DB::commit();
} catch (\Exception $e) {
  DB::rollback();
  return $e->getMessage();
}

JSON compleja

return response()->json(array(
            'datos' => $datos,
            'datos_categoria' => $datos_categoria,

        ));

mod/eliminar

try {
            return response()->json(array('resultado'=> 'OK'));
        } catch (\Throwable $th) {
            return response()->json(array('resultado'=> 'NOK: '.$th->getMessage()));
        }

guardar imagenes

$path=$req->file('foto')->store('uploads','public');

para usar consultas complejas he cambiado en config/database.php una configuracion de mysql, cambiado de strict => true a false

consulta compleja

SELECT r.*, nt.*, GROUP_CONCAT(t.categoria) FROM  `tbl_restaurante` r
                LEFT JOIN `tbl_num_tipos` nt on r.id=nt.id_restaurante
                LEFT JOIN `tbl_tipo` t on nt.id_tipo=t.id
                GROUP BY r.id
                HAVING COUNT(r.id)>1;