/**
* If this collection has already been initialized with
* an identical criteria, it returns the collection.
* Otherwise if this Proveedor is new, it will return
* an empty collection; or if this Proveedor has previously
* been saved, it will retrieve related PedidoProveedors 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 Proveedor.
*
* @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|PedidoProveedor[] List of PedidoProveedor objects
*/
public function getPedidoProveedorsJoinUsuario($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$query = PedidoProveedorQuery::create(null, $criteria);
$query->joinWith('Usuario', $join_behavior);
return $this->getPedidoProveedors($query, $con);
}
/**
* Executes index action
*
* @param sfRequest $request A request object
*/
public function executeIndex(sfWebRequest $request)
{
$defaults = array('Inicio' => date('d/m/Y'), 'Fin' => date('d/m/Y'));
$this->form = new ReporteForm($defaults);
$html = '';
$datos = array();
if ($request->isMethod('POST')) {
$this->form->bind($request->getParameter('reporte'));
if ($this->form->isValid()) {
$valores = $this->form->getValues();
$inicio = $valores['Inicio'];
$inicio = explode('/', $inicio);
$inicio = $inicio[2] . '-' . $inicio[1] . '-' . $inicio[0];
$fin = $valores['Fin'];
$fin = explode('/', $fin);
$fin = $fin[2] . '-' . $fin[1] . '-' . $fin[0];
switch ($valores['Tipo']) {
case '0':
$string = 'Estado Actual de Producto';
$datos = ProductoQuery::create()->find();
$html = $this->getPartial('reporte/reporteCero', array('datos' => $datos));
break;
case '1':
$string = 'Productos por Debajo de Minimo';
$productos = ProductoQuery::create()->find();
$datos = new PropelArrayCollection();
foreach ($productos as $fila) {
if ($fila->getCantidadMinima() >= Producto::obtenerExistencia($fila->getId())) {
$datos[] = $fila;
}
}
$html = $this->getPartial('reporte/reporteUno', array('datos' => $datos));
break;
case '2':
$string = '5 Maximos Clientes';
$listadoUno = array();
$listadoDos = array();
$listadoTres = array();
$MasCompras = FacturaDetalleQuery::create()->useFacturaQuery()->where("created_at <= '{$fin} 23:59:59' and created_at >= '{$inicio} 00:00:00'")->groupByClienteId()->endUse()->withColumn('Count(*)', 'Contador')->orderBy('Contador', 'Desc')->limit(5)->find();
foreach ($MasCompras as $mc) {
if ($mc->getFactura()) {
$Cliente = ClienteQuery::create()->findOneById($mc->getFactura()->getClienteId());
$fila = array();
$fila['Maximo'] = $mc->getContador();
$fila['Cliente'] = $Cliente->getNombre();
$listadoUno[] = $fila;
}
}
//
$masFacturas = FacturaQuery::create()->where("created_at <= '{$fin} 23:59:59' and created_at >= '{$inicio} 00:00:00'")->groupByClienteId()->withColumn('Count(*)', 'Contador')->orderBy('Contador', 'Desc')->limit(5)->find();
foreach ($masFacturas as $mc) {
$fila = array();
$fila['Maximo'] = $mc->getContador();
$fila['Cliente'] = $mc->getCliente()->getNombre();
$listadoDos[] = $fila;
}
//
$monto = FacturaDetalleQuery::create()->withColumn('SUM(cantidad * precio_unitario)', 'Total')->useFacturaQuery()->groupByClienteId()->where("created_at <= '{$fin} 23:59:59' and created_at >= '{$inicio} 00:00:00'")->endUse()->orderBy('Total', 'Desc')->limit(5)->find();
foreach ($monto as $mc) {
$fila = array();
$Cliente = ClienteQuery::create()->findOneById($mc->getFactura()->getClienteId());
$fila['Monto'] = $mc->getTotal();
$fila['Cliente'] = $Cliente->getNombre();
$listadoTres[] = $fila;
}
$datos['listadoUno'] = $listadoUno;
$datos['listadoDos'] = $listadoDos;
$datos['listadoTres'] = $listadoTres;
$html = $this->getPartial('reporte/reporteDos', array('listadoUno' => $listadoUno, 'listadoDos' => $listadoDos, 'listadoTres' => $listadoTres));
break;
case '3':
$Proveedores = MovimientoQuery::create()->where("fecha <= '{$fin}' and fecha >= '{$inicio}'")->filterByTipoMovimiento('+')->groupByProveedorId()->withColumn('count(id)', 'Total')->orderBy('Total')->limit(5)->find();
$string = 'Reporte de Proveedores';
$html = $this->getPartial('reporte/reporteTres', array('datos' => $Proveedores));
break;
case '4':
$movimientos = MovimientoQuery::create()->where("fecha <= '{$fin}' and fecha >= '{$inicio}'")->filterByTipoMovimiento('-')->groupByProductoId()->withColumn('count(cantidad)', 'Total')->orderBy('Total')->limit(5)->find();
$string = 'Reporte de Productos mas Vendidos';
$html = $this->getPartial('reporte/reporteCuatro', array('datos' => $movimientos));
break;
case '5':
$movimientos = MovimientoQuery::create()->where("fecha <= '{$fin}' and fecha >= '{$inicio}'")->filterByTipoMovimiento('-')->groupByProductoId()->withColumn('count(cantidad)', 'Total')->orderBy('Total', 'desc')->limit(5)->find();
$string = 'Reporte de Productos menos Vendidos';
$html = $this->getPartial('reporte/reporteCinco', array('datos' => $movimientos));
break;
case '6':
$Facturas = FacturaQuery::create()->where("created_at <= '{$fin} 23:59:59' and created_at >= '{$inicio} 00:00:00'")->groupByCreatedBy()->withColumn('count(id)', 'Suma')->orderBy('Suma')->limit(1)->find();
$string = 'Empleado con mas Venta';
$html = $this->getPartial('reporte/reporteSeis', array('datos' => $Facturas));
break;
case '7':
$Facturas = FacturaQuery::create()->where("created_at <= '{$fin} 23:59:59' and created_at >= '{$inicio} 00:00:00'")->groupByCreatedBy()->withColumn('count(id)', 'Suma')->orderBy('Suma')->find();
$string = 'Empleados con mas Ventas';
$html = $this->getPartial('reporte/reporteSeis', array('datos' => $Facturas));
break;
case '8':
$Producto = MovimientoQuery::create()->where("fecha <= '{$fin}' and fecha >= '{$inicio}'")->groupByProductoId()->withColumn('count(id)', 'Suma')->find();
$Marca = MovimientoQuery::create()->joinWith('Producto')->joinWith('Producto.Marca')->where("movimiento.fecha <= '{$fin}' and movimiento.fecha >= '{$inicio}'")->withColumn('count(marca.id)', 'Suma')->find();
$tipo = MovimientoQuery::create()->joinWith('Producto')->joinWith('Producto.TipoProducto')->where("movimiento.fecha <= '{$fin}' and movimiento.fecha >= '{$inicio}'")->withColumn('count(TipoProducto.id)', 'Suma')->find();
$presentacion = MovimientoQuery::create()->joinWith('Producto')->joinWith('Producto.TipoPresentacion')->where("movimiento.fecha <= '{$fin}' and movimiento.fecha >= '{$inicio}'")->withColumn('count(TipoPresentacion.id)', 'Suma')->find();
$string = 'Resumen de Ventas';
$html = $this->getPartial('reporte/reporteOcho', array('productos' => $Producto, 'marcas' => $Marca, 'tipos' => $tipo, 'presentacion' => $presentacion));
break;
case '9':
$Pedido = PedidoProveedorQuery::create()->where("estado <> 'Entregado' ")->find();
$string = 'Pedidos en Transito';
$html = $this->getPartial('reporte/reporteNueve', array('datos' => $Pedido));
break;
}
if ($request->hasParameter('pdf')) {
$htmlBase = '<img src="/vendor/dist/img/logo_farmacia.png" style="width:150px"/><br/><h3>' . $string . '</h3><br/>';
$html = $htmlBase . $html;
$pdf = new TCPDF("P", "mm", "Letter");
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('SALUD_INTEGRAL');
$pdf->SetTitle('Reporte');
$pdf->SetSubject('Reporte');
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
$pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);
$pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
$pdf->SetHeaderMargin(0.1);
$pdf->SetFooterMargin(0.1);
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetFont('dejavusans', '', 7);
$pdf->AddPage();
$pdf->writeHTML($html);
$pdf->Output('Reporte.pdf', 'D');
die;
}
}
}
$this->html = $html;
}
/**
* Get the associated PedidoProveedor object
*
* @param PropelPDO $con Optional Connection object.
* @return PedidoProveedor The associated PedidoProveedor object.
* @throws PropelException
*/
public function getPedidoProveedor(PropelPDO $con = null)
{
if ($this->aPedidoProveedor === null && $this->pedido_proveedor_id !== null) {
$this->aPedidoProveedor = PedidoProveedorQuery::create()->findPk($this->pedido_proveedor_id, $con);
/* The following can be used additionally to
guarantee the related object contains a reference
to this object. This level of coupling may, however, be
undesirable since it could result in an only partially populated collection
in the referenced object.
$this->aPedidoProveedor->addDetallePedidoProveedors($this);
*/
}
return $this->aPedidoProveedor;
}
/**
* 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(PedidoProveedorPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = PedidoProveedorQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
// symfony_behaviors behavior
foreach (sfMixer::getCallables('BasePedidoProveedor: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('BasePedidoProveedor: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;
}
}
/**
* Returns a new PedidoProveedorQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param PedidoProveedorQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return PedidoProveedorQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof PedidoProveedorQuery) {
return $criteria;
}
$query = new PedidoProveedorQuery();
if (null !== $modelAlias) {
$query->setModelAlias($modelAlias);
}
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
public function executeDetalle(sfWebRequest $request)
{
$this->id = $request->getParameter('id');
$cabecera = PedidoProveedorQuery::create()->findOneById($this->id);
$this->estado = $cabecera->getEstado();
$this->form = new IngresoDetallePedidoProveedorForm();
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('Ingreso de Detalle de Pedido a Proveedor con id :' . $this->id);
$BitacoraCambios->setIp($request->getRemoteAddress());
$pedido = new DetallePedidoProveedor();
$Usuario = UsuarioQuery::create()->findOneById(sfContext::getInstance()->getUser()->getAttribute('usuario', null, 'seguridad'));
$pedido->setProductoId($valores['Producto']);
$pedido->setCantidad($valores['Cantidad']);
$pedido->setPrecio($valores['Precio']);
$pedido->setPedidoProveedorId($this->id);
$pedido->save();
$url = 'pedido_proveedor/detalle?id=' . $this->id;
$this->redirect($url);
}
} else {
$accion = $request->getParameter("accion");
$iddetalle = $request->getParameter("det");
if ($accion == "Elimina") {
$det = DetallePedidoProveedorQuery::create()->filterById($iddetalle)->delete();
}
}
$this->detalles = DetallePedidoProveedorQuery::create()->filterByPedidoProveedorId($this->id)->orderById('Desc')->find();
}
