public function findPerPage($A_limit)
{
$I_firstOfPage = $A_limit['firstOfPage'];
$I_perPage = $A_limit['perPage'];
$S_sql = 'SELECT id, label, model, reference, description, lifetime, control_cycle, notice,
`procedure`, image, size, color, category_epi_id
FROM label_epi LIMIT ' . $I_firstOfPage . ', ' . $I_perPage;
$O_connection = new Connection();
if ($A_data = $O_connection->requestDb($S_sql, null, self::CLASS_NAME)) {
$A_labels = null;
foreach ($A_data as $O_label) {
if (!is_null($O_label->getCategoryEpiId())) {
try {
$O_categoryMapper = new CategoryMapper();
$O_category = $O_categoryMapper->findById($O_label->getCategoryEpiId());
$O_label->setCategory($O_category);
} catch (Exception $e) {
//On récupère le message de l'exception
echo 'L\'erreur suivante s\'est produite : ' . $e->getMessage();
}
}
$A_labels[] = $O_label;
}
return $A_labels;
} else {
throw new Exception("Une erreur s'est produite");
}
}
public function newAction()
{
$this->haveAccess();
$O_categoryMapper = new CategoryMapper();
$O_category = $O_categoryMapper->findAll();
Buffer::flushBuffer('label/new', array('category' => $O_category));
}
public function paginateAction($I_pageNumber)
{
// On vérifie si l'utilisateur connecté est bien un admin
$this->haveAccess();
$O_categoryMapper = new CategoryMapper();
$O_pagination = new Pagination($O_categoryMapper);
$A_limit = $O_pagination->paginate($I_pageNumber);
$I_nbPage = $A_limit['nbPage'];
$A_categorys = $O_categoryMapper->findPerPage($A_limit);
Buffer::flushBuffer('category/list', array('categorys' => $A_categorys, 'nbPage' => $I_nbPage, 'pageNumber' => $I_pageNumber));
}
public function defaultAction()
{
$O_epiMapper = new EpiMapper();
$I_nbrEpi = $O_epiMapper->countId();
$I_nbrEpiByUser = $O_epiMapper->countEpiByUser(Session::getSession('user')->getId());
$I_nbrEpiNextCheckByUser = $O_epiMapper->countEpiNextCheckByUser(Session::getSession('user')->getId());
$O_labelMapper = new LabelMapper();
$I_nbrLabel = $O_labelMapper->countId();
$O_categoryMapper = new CategoryMapper();
$I_nbrCategory = $O_categoryMapper->countId();
$O_checkMapper = new CheckMapper();
$I_nbrCheck = $O_checkMapper->countId();
$I_nbrCheckedByUser = $O_checkMapper->countEpiCheckedByUser(Session::getSession('user')->getId());
Buffer::flushBuffer('epi/default', array('nbrEpi' => $I_nbrEpi, 'nbrLabel' => $I_nbrLabel, 'nbrCategory' => $I_nbrCategory, 'nbrCheck' => $I_nbrCheck, 'nbrEpiByUser' => $I_nbrEpiByUser, 'nbrEpiNextCheckByUser' => $I_nbrEpiNextCheckByUser, 'nbrCheckedByUser' => $I_nbrCheckedByUser));
}
/**
* Returns an singleton instance of this class
* @return
*/
public static function getInstance()
{
if (self::$instance == null) {
self::$instance = new CategoryMapper();
}
return self::$instance;
}
/**
* Initializes DB mappers
*
* @param object $config
* @param object $args
* @return
*/
function __construct($config, $args)
{
$this->mapper = CategoryMapper::getInstance();
$this->config = $config;
$this->args = $args;
$this->categoryHierarchyManager = CategoryHierarchyManager::getInstance($this->config, $this->args);
$this->initCache();
}
public function route()
{
$request = trim(parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH), '/');
$request_arr = explode('/', $request);
if ($request == '') {
$controller = new IndexController($this->service);
$controller->indexAction();
} elseif ($request == 'basket') {
$controller = new BasketController($this->service);
$controller->indexAction();
} elseif ($request == 'auth') {
$controller = new AuthController($this->service);
$controller->indexAction();
} elseif ($request == 'reg') {
$controller = new RegController($this->service);
$controller->indexAction();
} elseif ($request == 'admin') {
$controller = new AdminController($this->service);
$controller->indexAction();
} elseif ($request == 'admin/additem') {
$controller = new AdminController($this->service);
$controller->additemAction();
} elseif ($request == 'admin/category') {
$controller = new AdminController($this->service);
$controller->categoryAction();
} elseif ($request == 'admin/catalog') {
$controller = new AdminController($this->service);
$controller->catalogAction();
} elseif ($request == 'admin/orders') {
$controller = new AdminController($this->service);
$controller->ordersAction();
} elseif ($request = 'cat/' . $request_arr[1]) {
$category_mapper = new CategoryMapper($this->service->get('db'));
if (!$category_mapper->getCategoryFromCode($request_arr[1])) {
$this->get404();
} else {
$controller = new CatController($this->service);
$controller->categoryAction($request_arr[1]);
}
} else {
$this->get404();
}
}
protected function initSearchValues($searchArgs)
{
if (!empty($searchArgs['category']) && !empty($searchArgs['property'])) {
$this->category = array('leisureProperty' => CategoryMapper::getLeisurePropertiesFromSearchCategory($searchArgs['category']), 'value' => $searchArgs['property']);
} else {
$this->category = array();
}
unset($searchArgs['category']);
unset($searchArgs['property']);
$include = array('priceFrom', 'priceTo', 'startDate', 'endDate', 'organization', 'country', 'location', 'description');
foreach ($searchArgs as $key => $val) {
if (in_array($key, $include)) {
$this->{$key} = $val;
}
}
}
