/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
// var_dump(Input::All());
// die;
//
// 'categorias_id' => 'exists:rubros,id'
$rules = ['articulo' => 'required', 'copete' => 'required', 'texto' => 'required'];
if (!Articulo::isValid(Input::all(), $rules)) {
return Redirect::back()->withInput()->withErrors(Articulo::$errors);
}
$articulo = new Articulo();
$articulo->users_id = Sentry::getUser()->id;
$articulo->articulo = Input::get('articulo');
$articulo->copete = Input::get('copete');
$articulo->texto = Input::get('texto');
$articulo->tipo = Input::get('tipo');
$articulo->categorias_id = Input::get('categorias_id');
$url_seo = Input::get('articulo');
$articulo->estado = 'nuevo';
//$url_seo = $this->url_slug($url_seo) . implode("-",getdate());
$url_seo = $this->url_slug($url_seo) . date('ljSFY');
$articulo->url_seo = $url_seo;
$articulo->save();
return Redirect::to('/articulos/ver');
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aArticulo !== null) {
if ($this->aArticulo->isModified() || $this->aArticulo->isNew()) {
$affectedRows += $this->aArticulo->save($con);
}
$this->setArticulo($this->aArticulo);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
} else {
$this->doUpdate($con);
}
$affectedRows += 1;
$this->resetModified();
}
if ($this->articulovariantevalorsScheduledForDeletion !== null) {
if (!$this->articulovariantevalorsScheduledForDeletion->isEmpty()) {
ArticulovariantevalorQuery::create()->filterByPrimaryKeys($this->articulovariantevalorsScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->articulovariantevalorsScheduledForDeletion = null;
}
}
if ($this->collArticulovariantevalors !== null) {
foreach ($this->collArticulovariantevalors as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->propiedadvalorsScheduledForDeletion !== null) {
if (!$this->propiedadvalorsScheduledForDeletion->isEmpty()) {
PropiedadvalorQuery::create()->filterByPrimaryKeys($this->propiedadvalorsScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->propiedadvalorsScheduledForDeletion = null;
}
}
if ($this->collPropiedadvalors !== null) {
foreach ($this->collPropiedadvalors as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aArticulo !== null) {
if ($this->aArticulo->isModified() || $this->aArticulo->isNew()) {
$affectedRows += $this->aArticulo->save($con);
}
$this->setArticulo($this->aArticulo);
}
if ($this->aArticulovariante !== null) {
if ($this->aArticulovariante->isModified() || $this->aArticulovariante->isNew()) {
$affectedRows += $this->aArticulovariante->save($con);
}
$this->setArticulovariante($this->aArticulovariante);
}
if ($this->aPropiedad !== null) {
if ($this->aPropiedad->isModified() || $this->aPropiedad->isNew()) {
$affectedRows += $this->aPropiedad->save($con);
}
$this->setPropiedad($this->aPropiedad);
}
if ($this->aPropiedadvalor !== null) {
if ($this->aPropiedadvalor->isModified() || $this->aPropiedadvalor->isNew()) {
$affectedRows += $this->aPropiedadvalor->save($con);
}
$this->setPropiedadvalor($this->aPropiedadvalor);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
} else {
$this->doUpdate($con);
}
$affectedRows += 1;
$this->resetModified();
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
public function store()
{
$data = Input::all();
$rules = array('req_id' => 'required|numeric', 'articulo' => 'required', 'cantidad' => 'required|numeric', 'unidad' => 'required');
$validator = Validator::make($data, $rules);
if ($validator->passes()) {
$articulo = new Articulo();
$articulo->req_id = Input::get('req_id');
$articulo->articulo = Input::get('articulo');
$articulo->cantidad = Input::get('cantidad');
$articulo->unidad = Input::get('unidad');
$articulo->save();
return Redirect::action('RequisicionController@show', array(Input::get('req_id')));
} else {
return Redirect::action('ArticulosController@create', array(Input::get('req_id')))->withErrors($validator)->withInput();
}
}
public function importarOcNuevas()
{
$oc_externas = $this->consultarOcExternas();
if (count($oc_externas) > 0) {
foreach ($oc_externas as $oc_nueva) {
$proveedor = new ProveedorController();
$proveedor_id = $proveedor->getProveedorId($oc_nueva->benef_id);
if ($proveedor_id !== false) {
$oc = new Oc();
$oc->oc = $oc_nueva->oc;
$oc->fecha_oc = $oc_nueva->fecha_oc;
$oc->req = $oc_nueva->req;
$oc->db_origen = 'sgf14';
$oc->proveedor_id = $proveedor_id;
$oc->urg_id = '';
$oc->estatus = '';
$oc->save();
//Insetar artículos @articulos
$articulosExternos = $this->getArticulosExternos($oc_nueva->oc);
foreach ($articulosExternos as $articuloExterno) {
$articulo = new Articulo();
$articulo->articulo = $articuloExterno->art . ' ' . $articuloExterno->esp;
$articulo->unidad = $articuloExterno->unidad;
$articulo->rubro_id = 0;
$articulo->save();
//Insertar artículos @oc_articulos
$oc_art = new OcArticulo();
$oc_art->oc()->associate($oc);
$oc_art->articulo()->associate($articulo);
$oc_art->art_count = $articuloExterno->art_count;
$oc_art->esp = $articuloExterno->art . ' ' . $articuloExterno->esp;
$oc_art->cantidad = $articuloExterno->cantidad;
$oc_art->costo = $articuloExterno->costo;
$oc_art->impuesto = $articuloExterno->impuesto;
$oc_art->unidad = $articuloExterno->unidad;
$oc_art->save();
}
}
}
}
}
public function post_nuevo()
{
$inputs = Input::all();
$reglas = array('nombre' => 'required|max:50', 'descripcion' => 'required|max:50', 'alto' => 'required', 'largo' => 'required', 'ancho_prof' => 'required', 'rubro' => 'required|integer', 'sucursal' => 'required', 'stock' => 'required|integer', 'prec_compra' => 'required', 'proveedor' => 'required');
$mensajes = array('required' => 'Campo Obligatorio');
$validar = Validator::make($inputs, $reglas);
if ($validar->fails()) {
Input::flash();
return Redirect::back()->withInput()->withErrors($validar);
} else {
try {
DB::beginTransaction();
$articulo = new Articulo();
$articulo->nombre = Input::get('nombre');
$articulo->descripcion = Input::get('descripcion');
$articulo->alto = Input::get('alto');
$articulo->largo = Input::get('largo');
$articulo->ancho_prof = Input::get('ancho_prof');
$articulo->id_rubro = Input::get('rubro');
$articulo->precio_compra = Input::get('prec_compra');
$articulo->id_proveedor = Input::get('proveedor');
$articulo->save();
$insertedId = $articulo->id_articulo;
$stock = new Stock();
$stock->id_articulo = $insertedId;
$stock->id_sucursal = Input::get('sucursal');
$stock->cantidad = Input::get('stock');
$stock->save();
DB::commit();
$articulos = DB::table('articulos')->join('rubros', 'articulos.id_rubro', '=', 'rubros.id_rubro')->join('proveedores', 'articulos.id_proveedor', '=', 'proveedores.id_proveedor')->join('stock', 'articulos.id_articulo', '=', 'stock.id_articulo')->join('sucursales', 'stock.id_sucursal', '=', 'sucursales.id_sucursal')->select('articulos.id_articulo', 'rubros.rubro', 'articulos.nombre', 'articulos.descripcion', 'articulos.alto', 'articulos.largo', 'articulos.ancho_prof', 'articulos.precio_compra', 'rubros.id_rubro', 'proveedores.nom_raz', 'stock.cantidad', 'sucursales.nombre as sucursal')->orderby('articulos.nombre', 'asc')->paginate(100);
return View::make('lista_articulos')->with('articulos', $articulos)->with('error', 'El Artículo ha sido cargado con Éxito');
} catch (Exception $ex) {
DB::rollBack();
echo $ex->getMessage();
}
}
}
