/**
* Check, if current url has old format - execute 301 redirect to correct address
* @param $params
*/
protected function _checkRedirect($params)
{
// get vars
$segments = $params['segments'];
$segCout = count($segments);
// item url
if ('item' == $segments[0] && 2 == $segCout) {
$itemId = $this->_aliasItem->translateAliasToID($segments[1]);
$item = $this->_itemTable->get((int) $itemId);
$newUrl = $this->_getUrl($item, 'item');
$this->_redirect($newUrl);
}
// for excess get param category_id
if ($this->_config->get('fix_category_id', 0)) {
$reg = '#' . $segments[0] . '\\?category_id=\\d*$#i';
$curUrl = $this->app->jbenv->getCurrentUrl();
if (preg_match($reg, $curUrl, $matches)) {
$itemId = $this->_aliasItem->translateAliasToID($segments[0]);
$item = $this->_itemTable->get((int) $itemId);
$newUrl = $this->_getUrl($item, 'item');
$this->_redirect($newUrl);
}
}
// category url
if ('category' == $segments[0] && (2 == $segCout || 3 == $segCout)) {
// simple variant
if (2 == $segCout) {
$catId = $this->_aliasCat->translateAliasToID($segments[1]);
$category = $this->_catTable->get((int) $catId);
$newUrl = $this->_getUrl($category, 'category');
$this->_redirect($newUrl);
} else {
if (3 == $segCout) {
// with pagination
$catId = $this->_aliasCat->translateAliasToID($segments[1]);
$category = $this->_catTable->get((int) $catId);
$newUrl = $this->_getUrl($category, 'category') . (int) $segments[2];
$this->_redirect($newUrl);
}
}
}
// feed
if ('feed' == $segments[0] && ('rss' == $segments[1] || 'atom' == $segments[1]) && (3 == $segCout || 4 == $segCout)) {
$appId = $this->_aliasApp->translateAliasToID($segments[2]);
if ($appId) {
if (isset($segments[3])) {
$categoryId = $this->_aliasCat->translateAliasToID($segments[3]);
$category = $this->_catTable->get($categoryId);
} else {
$category = $this->app->object->create('category');
$category->id = 0;
$category->name = 'ROOT';
$category->alias = '_root';
}
$newUrl = $this->_getUrl($category, 'feed', $segments[1]);
$this->_redirect($newUrl);
}
}
}
public static function has_role($catid, $userinfo)
{
$category = CategoryTable::getInstance()->find($catid);
foreach ($userinfo['role'] as $role) {
$roles[] = $role['id'];
}
$cat_roles = array_filter(explode(',', $category->manager));
foreach ($cat_roles as $r) {
if (in_array($r, $roles)) {
return $category;
}
}
return false;
}
public function index($id_or_alias)
{
parent::load('model', 'system/contrib/auth');
parent::load('model', 'articles');
$articles = Article::get_by_category($id_or_alias);
import('system/share/web/paginator');
$paginator = new Paginator($articles, $_GET['page'], 10);
$category = CategoryTable::getInstance()->findByAlias($id_or_alias);
$smarty = parent::load('smarty');
$smarty->assign('category', $category[0]);
$smarty->assign('paginator', $paginator->output());
$smarty->assign('page_title', $category[0]->name);
$smarty->display('article/list');
}
/**
* Remove all catagories
* @param int $appId
* @param array $exclude
* @return bool
*/
public function removeAll($appId, $exclude = array())
{
if (!(int) $appId) {
return false;
}
$conditions = array('application_id = ' . (int) $appId);
if (!empty($exclude)) {
$conditions[] = ' AND id NOT IN (' . implode(', ', $exclude) . ')';
}
$categories = $this->_table->all(compact('conditions'));
foreach ($categories as $category) {
$this->_table->delete($category);
$this->_table->unsetObject($category->id);
unset($category);
}
return true;
}
$quantity = floor($quantity / $row["rounding_factor"]) * $row["rounding_factor"];
}
}
echo ' <td>' . $row["item_name"] . '</td>
<td>' . $row["unit"] . '</td>
<td>' . $row["quantity"] . '</td>
<td class="quantity_required">' . $quantity . '</td>
<td>
<textarea name="" id="" rows="2" onchange=updateNotes(this) value="' . $row["notes"] . '">' . $row["notes"] . '</textarea>
<input type="hidden" value="' . $row["item_id"] . '">
</td>
</tr>';
}
}
if (isset($_POST["getPrintPreviewTimeslots"])) {
$result = CategoryTable::get_print_preview_timeslots($_POST["date"], $_POST["timeSlotName"]);
$current_category = null;
while ($row = $result->fetch_assoc()) {
if ($row["category_name"] != $current_category and $row["category_name"] != null) {
$current_category = $row["category_name"];
echo '<tbody class="print_tbody" id="print_tbody">
<tr id="category"><td colspan="5" class="table_heading"><h4 class="none">' . $row["category_name"] . '</h4></td></tr>
<tr id="category_columns">
<th>Item</th>
<th>Unit</th>
<th>Quantity Present</th>
<th>Quantity Required</th>
<th>Notes</th>
</tr>';
}
echo '<tr id="column_data" class="row">';
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<link href='https://fonts.googleapis.com/css?family=Roboto' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="styles.css">
</head>
<body>
<div class="main_iframe">
<div class="div_category">
<h4>Categories</h4><hr>
<div class="div_list_category">
<ul class="category_list" id="category_list" >
<?php
$result = CategoryTable::get_categories($date = date('Y-m-d'));
?>
<?php
while ($row = $result->fetch_assoc()) {
?>
<li id="<?php
echo $row['id'];
?>
" class="list_category_li" onclick=categorySelect(this)>
<div class="handle_delete"><img src="images/delete.png" alt="" width="30px" height="30px"></div>
<span><?php
echo $row["name"];
?>
</span>
<form action="edit_categories.php" method="post">
<input type="hidden" name="delete_id" value="<?php
function get_by_id($id)
{
$cateTab = new CategoryTable();
return $cateTab->get_by_id($id);
}
public function category_edit($id)
{
parent::load('model', 'articles');
parent::load('model', 'system/contrib/auth');
$category = CategoryTable::getInstance()->find($id);
if (!$category) {
HTTPRedirect::flash_to('manager/article_categories', '分类不存在', $this->smarty);
}
$roles = RoleTable::getInstance()->findAll();
$roles_cleaned = array();
foreach ($roles as $role) {
$roles_cleaned[$role['id']] = $role['name'];
}
$this->smarty->assign('roles', $roles_cleaned);
$this->smarty->assign('checked', array_filter(explode(',', $category['manager'])));
$this->smarty->assign('category', $category);
if ($this->is_post()) {
$category->name = trim(strip_tags($_POST['name']));
$category->manager = sprintf(',%s,', implode(',', $_POST['roles']));
$category->save();
HTTPRedirect::flash_to('manager/article_categories', '修改分类成功', $this->smarty);
}
$this->smarty->display('manager/article/category_edit');
}
public function executeCatalog(sfWebRequest $request)
{
$this->catList = CategoryTable::getInstance()->getMainPageList();
}
<link rel="stylesheet" href="styles.css">
</head>
<body class="overflow_hidden">
<?php
$page = "home";
include_once "new_nav.php";
?>
<div class="main">
<div class="div_category" id="home_list">
<ul class="category_list">
<h4><?php
echo date('D, M d Y', strtotime($_SESSION["date"]));
?>
</h4><hr>
<?php
$result = CategoryTable::get_categories($_SESSION["date"]);
while ($row = $result->fetch_assoc()) {
?>
<li class="list_category_li">
<span><?php
echo $row["name"];
?>
</span>
<input type="hidden" id="category_id" name="category_id" value="<?php
echo $row['id'];
?>
">
<span class="item_counter" id="total"><?php
echo ItemTable::get_total_items($row['id'], $_SESSION["date"]);
?>
</span>
