/**
*
* @param integer $user_id - Id del usuario para obtener los folios correspondientes
* @return boolean
* true - si se ha actualizado el folio <br>
* false - Si no se actualizó el folio
*/
public function updateFolio()
{
$folio = $this->createQuery()->from('folio')->where('user_id = ?', sfCOntext::getInstance()->getUser()->getGuardUser()->getId())->andWhere('status = ?', 'active')->execute()->getFirst();
if ($folio->count() > 0) {
if ($folio['start'] >= $folio['end']) {
$folio['status'] = "suspended";
$folio['available'] = 0;
$folio->save();
} else {
$folio['start'] = $folio['start'] + 1;
$folio['used'] = $folio['used'] + 1;
$folio['available'] = $folio['end'] - $folio['used'];
$folio->save();
}
return true;
} else {
return false;
}
}
public function getInvoiceByUser($folio)
{
$result = $this->createQuery()->from('invoice')->where('user_id = ?', sfCOntext::getInstance()->getUser()->getGuardUser()->getId())->andWhere('folio = ?', $folio)->execute();
return $result->getFirst();
}
public function getConceptsbyuser()
{
$result = Doctrine_query::create()->from('concept')->where('user_id = ?', sfCOntext::getInstance()->getUser()->getGuardUser()->getId())->addWhere('status = "1"')->execute();
return $result;
}
