/**
* Returns a new CategoriagastoQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param CategoriagastoQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return CategoriagastoQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof CategoriagastoQuery) {
return $criteria;
}
$query = new CategoriagastoQuery(null, null, $modelAlias);
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
public function editarAction()
{
//ID ENTIDAD
$id = $this->params()->fromRoute('id');
$request = $this->getRequest();
if ($request->isPost()) {
$post_data = $request->getPost();
//INSTANCIAMOS NUESTRA ENTIDAD
$entity = \GastofacturacionQuery::create()->findPk($id);
//SETIAMOS NUESTROS DATOS CON EXCEPCIONES
foreach ($post_data as $key => $value) {
if (\GastofacturacionPeer::getTableMap()->hasColumn($key)) {
$entity->setByName($key, $value, \BasePeer::TYPE_FIELDNAME);
}
}
//SETIAMOS EL IVA
$entity->setGastofacturacionIva($post_data['gastofacturacion_iva']);
$entity->save();
//Agregamos un mensaje
$this->flashMessenger()->addSuccessMessage('Registro guardado exitosamente!');
//REDIRECCIONAMOS A LA ENTIDAD QUE ACABAMOS DE CREAR
return $this->redirect()->toRoute('admin/catalogo/gastos', array('action' => 'editar', 'id' => $entity->getIdgastofacturacion()));
}
$exist = \GastofacturacionQuery::create()->filterByIdgastofacturacion($id)->exists();
if ($exist) {
$entity = \GastofacturacionQuery::create()->findPk($id);
//LE DAMOS FORMATO A LAS CATEGORIAS DE GASTOS
$categorias_gastos = \CategoriagastoQuery::create()->find();
$categorias_gastos_array = array();
foreach ($categorias_gastos as $categoria_gasto) {
$idcategoriagasto = $categoria_gasto->getIdcategoriagasto();
$categorias_gastos_array[$idcategoriagasto] = $categoria_gasto->getCategoriagastoNombre();
}
//INSTANCIAMOS NUESTRO FORMULARIO
$form = new \Catalogo\Form\GastoForm($categorias_gastos_array);
$form->setData($entity->toArray(\BasePeer::TYPE_FIELDNAME));
//RETORNAMOS A NUESTRA VISTA
$view_model = new ViewModel();
$view_model->setTemplate('admin/catalogo/gastos/editar');
$view_model->setVariables(array('entity' => json_encode($entity->toArray(\BasePeer::TYPE_FIELDNAME)), 'successMessages' => json_encode($this->flashMessenger()->getSuccessMessages()), 'form' => $form));
return $view_model;
} else {
return $this->redirect()->toRoute('admin/catalogo/gastos', array('action' => 'index'));
}
}
/**
* 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(CategoriagastoPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = CategoriagastoQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
if ($ret) {
$deleteQuery->delete($con);
$this->postDelete($con);
$con->commit();
$this->setDeleted(true);
} else {
$con->commit();
}
} catch (Exception $e) {
$con->rollBack();
throw $e;
}
}
/**
* Get the associated Categoriagasto object
*
* @param PropelPDO $con Optional Connection object.
* @param $doQuery Executes a query to get the object if required
* @return Categoriagasto The associated Categoriagasto object.
* @throws PropelException
*/
public function getCategoriagasto(PropelPDO $con = null, $doQuery = true)
{
if ($this->aCategoriagasto === null && $this->idcategoriagasto !== null && $doQuery) {
$this->aCategoriagasto = CategoriagastoQuery::create()->findPk($this->idcategoriagasto, $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->aCategoriagasto->addGastofacturacions($this);
*/
}
return $this->aCategoriagasto;
}
public function eliminarAction()
{
$request = $this->getRequest();
if ($request->isPost()) {
$id = $request->getPost('id');
$entity = \CategoriagastoQuery::create()->findPk($id);
$entity->delete();
//Agregamos un mensaje
$this->flashMessenger()->addSuccessMessage('Registro eliminado exitosamente!');
if ($entity->isDeleted()) {
return $this->getResponse()->setContent(json_encode(true));
}
}
$id = $this->params()->fromQuery('id');
$viewModel = new ViewModel();
$viewModel->setTerminal(true);
$viewModel->setTemplate('admin/catalogo/categoriasgastos/eliminar');
return $viewModel;
}
public function editarcargoAction()
{
$request = $this->getRequest();
$idgasto = $this->params()->fromQuery('id');
$entity = \ExpedientegastoQuery::create()->findPk($idgasto);
if ($request->isPost()) {
$post_data = $request->getPost();
$post_files = $request->getFiles();
$auth = new \Shared\Session\AouthSession();
$auth = $auth->getData();
$entity = \ExpedientegastoQuery::create()->findPk($post_data['idexpedientegasto']);
foreach ($post_data as $key => $value) {
if (\ExpedientegastoPeer::getTableMap()->hasColumn($key) && !empty($value) && $key != 'expedientegasto_fecha') {
$entity->setByName($key, $value, \BasePeer::TYPE_FIELDNAME);
}
}
//LA FECHA
$expedientegasto_fecha = \DateTime::createFromFormat('d/m/Y', $post_data['expedientegasto_fecha']);
$entity->setExpedientegastoFecha($expedientegasto_fecha);
$entity->setIdempleado($auth['idempleado']);
$entity->save();
//El comprobante
if (!empty($post_files['expedientegasto_comprobante']['name'])) {
$target_path = "/files/expedientesgastos/";
$target_path = $target_path . $entity->getIdexpedientegasto() . '_' . basename($post_files['expedientegasto_comprobante']['name']);
if (move_uploaded_file($_FILES['expedientegasto_comprobante']['tmp_name'], $_SERVER['DOCUMENT_ROOT'] . $target_path)) {
$entity->setExpedientegastoComprobante($target_path);
$entity->save();
}
}
$this->flashMessenger()->addSuccessMessage('Registro guardado exitosamente!');
//REDIRECCIONAMOS A LA ENTIDAD QUE ACABAMOS DE CREAR
return $this->redirect()->toUrl('/clientes/ver/' . $entity->getExpediente()->getIdcliente() . '/expedientes/ver/' . $entity->getIdexpediente());
}
//LAS CATEGORIAS DE NUESTROS GASTOS
$categoriasgasto = \CategoriagastoQuery::create()->find();
$categoriasgasto_array = array();
foreach ($categoriasgasto as $categoriagastos) {
$id = $categoriagastos->getIdcategoriagasto();
$categoriasgasto_array[$id] = $categoriagastos->getCategoriagastoNombre();
}
//LOS PROVEEDORES
$proveedores = \ProveedoritradeQuery::create()->filterByIdproveedoritrade(1, \Criteria::NOT_EQUAL)->find();
$proveedores_array = array();
foreach ($proveedores as $proveedor) {
$id = $proveedor->getIdproveedoritrade();
$proveedores_array[$id] = $proveedor->getProveedoritradeNombre();
}
//gastos de facturacion
$gastos_facturacion = \GastofacturacionQuery::create()->filterByIdcategoriagasto($entity->getGastofacturacion()->getIdcategoriagasto())->find();
$gastos_facturacion_array = array();
foreach ($gastos_facturacion as $gasto_facturacion) {
$id = $gasto_facturacion->getIdgastofacturacion();
$gastos_facturacion_array[$id] = $gasto_facturacion->getGastofacturacionNombre();
}
//INSTANCIAMOS NUESTRO FORMULARIO
$form = new \Admin\Clientes\Form\ExpedientegastoForm($entity->getIdexpediente(), $categoriasgasto_array, $proveedores_array, $entity->getExpedientegastoMoneda(), $gastos_facturacion_array);
//Ponemos nuetros datos al formulario....
$form->setData($entity->toArray(\BasePeer::TYPE_FIELDNAME));
$form->get('expedientegasto_fecha')->setValue($entity->getExpedientegastoFecha('d/m/Y'));
$form->get('idcategoriagasto')->setValue($entity->getGastofacturacion()->getIdcategoriagasto());
$form->get('idgastofacturacion')->setValue($entity->getIdgastofacturacion());
$form->get('idgastofacturacion')->setAttribute('disabled', false);
//Enviamos a la vista
$view_model = new ViewModel();
$view_model->setTerminal(true)->setVariable('form', $form)->setVariable('entity', $entity)->setTemplate('/clientes/expedientes/modal/editarcargo');
return $view_model;
}
