public function categoryAction()
{
$modelTransaction = new Application_Model_Transaction();
$modelCategory = new Application_Model_Category();
$this->view->categories = $modelCategory->getAll();
if ($this->getRequest()->isPost()) {
$category = $this->getRequest()->getPost('category', null);
$this->view->category = $category;
$this->view->sumCategory = $modelTransaction->getForGraphByCategory($category, date("Y"));
$budgetCategory = $modelTransaction->getBudgetForGraphByCategory($category, date("Y"));
$budgetCategoryFormated = array_fill(1, 12, 0);
foreach ($budgetCategory as $category) {
$budgetCategoryFormated[$category->month] = $category->maximum;
}
$this->view->budgetCategory = $budgetCategoryFormated;
$this->view->months = array(1 => 'Janvier', 2 => 'Février', 3 => 'Mars', 4 => 'Avril', 5 => 'Mai', 6 => 'Juin', 7 => 'Juillet', 8 => 'Août', 9 => 'Septembre', 10 => 'Octobre', 11 => 'Novembre', 12 => 'Décembre');
}
}
public function editAction()
{
$modelCategory = new Application_Model_Category();
$this->view->categories = $modelCategory->getAll();
$id = $this->getRequest()->getParam("id");
$date = $this->getRequest()->getParam("date");
$modelUserCategory = new Application_Model_UserCategory();
$session = new Zend_Session_Namespace('Zend_auth');
if (isset($id) && isset($date)) {
$this->view->category = $modelUserCategory->getByUserCategoryDate($session->user, $id, $date);
}
if ($this->getRequest()->isPost()) {
$category = $this->getRequest()->getPost('category', null);
$maximum = $this->getRequest()->getPost('maximum', null);
$date = $this->getRequest()->getPost('date', date('Y-m-t'));
if ($maximum == 0) {
$this->view->error = "Le montant de la transaction est vide";
}
if (!isset($this->view->error)) {
$data_transaction = array('maximum' => $maximum, 'date' => $date, 'id_category' => $category, 'id_user' => $session->user);
if (!isset($id)) {
$verifyCategory = $modelUserCategory->getById($session->user, $category, $date);
if (!isset($verifyCategory->id_user)) {
$modelUserCategory->insertUserCategory($data_transaction);
} else {
if ($verifyCategory->is_deleted == 1) {
$data_transaction['is_deleted'] = 0;
$modelUserCategory->updateUserCategory($data_transaction, $session->user, $category, $date);
} else {
$this->view->error = "Un budget pour cette catégorie est déjà existant.";
}
}
} else {
$modelUserCategory->updateUserCategory($data_transaction, $session->user, $id, $date);
}
$this->_redirect('budget/');
}
}
}
public function categoryAction()
{
$session = new Zend_Session_Namespace('Zend_auth');
$user = $session->user;
$modelCategory = new Application_Model_Category();
$this->view->categories = $modelCategory->getAll();
$modelTransaction = new Application_Model_Transaction();
$category = $this->getRequest()->getPost('category', null);
if ($category != null) {
$transactions = $modelTransaction->getByCategory($category, $user);
$this->view->transactions = $transactions;
$this->view->category = $category;
}
}
