/**
* Returns a new DetallePedidoProveedorQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param DetallePedidoProveedorQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return DetallePedidoProveedorQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof DetallePedidoProveedorQuery) {
return $criteria;
}
$query = new DetallePedidoProveedorQuery();
if (null !== $modelAlias) {
$query->setModelAlias($modelAlias);
}
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
/**
* Removes this object from datastore and sets delete attribute.
*
* @param PropelPDO $con
* @return void
* @throws PropelException
* @throws Exception
* @see BaseObject::setDeleted()
* @see BaseObject::isDeleted()
*/
public function delete(PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("This object has already been deleted.");
}
if ($con === null) {
$con = Propel::getConnection(DetallePedidoProveedorPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = DetallePedidoProveedorQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
// symfony_behaviors behavior
foreach (sfMixer::getCallables('BaseDetallePedidoProveedor:delete:pre') as $callable) {
if (call_user_func($callable, $this, $con)) {
$con->commit();
return;
}
}
if ($ret) {
$deleteQuery->delete($con);
$this->postDelete($con);
// symfony_behaviors behavior
foreach (sfMixer::getCallables('BaseDetallePedidoProveedor:delete:post') as $callable) {
call_user_func($callable, $this, $con);
}
$con->commit();
$this->setDeleted(true);
} else {
$con->commit();
}
} catch (Exception $e) {
$con->rollBack();
throw $e;
}
}
/**
* If this collection has already been initialized with
* an identical criteria, it returns the collection.
* Otherwise if this PedidoProveedor is new, it will return
* an empty collection; or if this PedidoProveedor has previously
* been saved, it will retrieve related DetallePedidoProveedors from storage.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in PedidoProveedor.
*
* @param Criteria $criteria optional Criteria object to narrow the query
* @param PropelPDO $con optional connection object
* @param string $join_behavior optional join type to use (defaults to Criteria::LEFT_JOIN)
* @return PropelObjectCollection|DetallePedidoProveedor[] List of DetallePedidoProveedor objects
*/
public function getDetallePedidoProveedorsJoinProducto($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$query = DetallePedidoProveedorQuery::create(null, $criteria);
$query->joinWith('Producto', $join_behavior);
return $this->getDetallePedidoProveedors($query, $con);
}
public function executeEdita(sfWebRequest $request)
{
$this->id = $request->getParameter('id');
$iddet = $request->getParameter('det');
$dets = DetallePedidoProveedorQuery::create()->filterById($iddet)->findOne();
$this->form = new IngresoDetallePedidoProveedorForm(array("Producto" => $dets->getProducto(), "Cantidad" => $dets->getCantidad(), "Precio" => $dets->getPrecio()));
if ($request->isMethod('POST')) {
$this->form->bind($request->getParameter('ingreso_detpedprov'));
if ($this->form->isValid()) {
$valores = $this->form->getValues();
$BitacoraCambios = new BitacoraCambios();
$BitacoraCambios->setModelo('Detalle Pedido Proveedores');
$BitacoraCambios->setDescripcion('Edicion de Detalle de Pedido a Proveedor con id :' . $iddet);
$BitacoraCambios->setIp($request->getRemoteAddress());
$pedido = $dets;
$Usuario = UsuarioQuery::create()->findOneById(sfContext::getInstance()->getUser()->getAttribute('usuario', null, 'seguridad'));
$pedido->setProductoId($valores['Producto']);
$pedido->setCantidad($valores['Cantidad']);
$pedido->setPrecio($valores['Precio']);
$pedido->save();
$url = 'pedido_proveedor/detalle?id=' . $this->id;
$this->redirect($url);
}
}
}
