PHP Category::getAllCategories方法代码示例

function getAllCategoriesDT()
{
    global $bdd, $_TABLES;
    if (!is_null($bdd) && !is_null($_TABLES)) {
        $content = '<thead>';
        $content .= '<tr>';
        $content .= '<th>Id</th>';
        $content .= '<th>Category</th>';
        $content .= '<th>Action</th>';
        $content .= '</tr>';
        $content .= '</thead>';
        $content .= '<tbody>';
        $objCategory = new Category($bdd, $_TABLES);
        $items = $objCategory->getAllCategories();
        if ($items) {
            foreach ($items as $key => $item) {
                $content .= '<tr categoryId=' . $item->id . '>';
                $content .= '<td>' . $item->id . '</td>';
                $content .= '<td><input type="text" class="input_dt input_dt_category" value="' . $item->category . '" /></td>';
                $content .= "<td><input type='button' class='edit edit_category_dt' value='Save' />\n\t\t\t\t    <input type='button' class='delete delete_category_dt' value='Supprimer' /></td>";
                $content .= '</tr>';
            }
        }
        $content .= '</tbody>';
        return $content;
    } else {
        error_log("BDD ERROR : " . json_encode($bdd));
        error_log("TABLES ERROR : " . json_encode($_TABLES));
    }
}

 public static function getCategory($categoryid)
 {
     $categoryarray = Category::getAllCategories();
     if (array_key_exists($categoryid, $categoryarray)) {
         //get Key from array
         $name = $categoryarray[$categoryid];
         return $name;
     } else {
         return FALSE;
     }
 }

    public function actionList()
    {
        $categories = Category::getAllCategories();
        if (isset($_GET['cat'])) {
            $cat = $_GET['cat'];
            //$shops=Blogshop::model()->with(array('categories'=>array('condition'=>'name="'.$cat.'"')))->findAll();
            $page = 0;
            if (isset($_GET['page'])) {
                $page = $_GET['page'];
            }
            $limit = $this->global_limit;
            $offset = $page * $limit;
            $shops_count = Blogshop::model()->countBySql('SELECT count(*) FROM blogshop, category, blogshop_categories 
			WHERE blogshop.id = blogshop_categories.blogshopid 
			AND category.id = blogshop_categories.categoryid 
			AND category.name = :cat', array(":cat" => $cat));
            $shops = Blogshop::model()->findAllBySql('SELECT * FROM blogshop, category, blogshop_categories 
			WHERE blogshop.id = blogshop_categories.blogshopid 
			AND category.id = blogshop_categories.categoryid 
			AND category.name = :cat 
			limit :limit offset :offset', array(":cat" => $cat, ":limit" => (int) $limit, ':offset' => (int) $offset));
            /*
            $pages_count=ceil($shops_count/$limit);
            
            $front_page_limit=$this->getFrontLimitPage($pages_count,$page,5);
            $back_page_limit=$this->getBackLimitPage($pages_count,$page,5);									
            
            $this->render('list',array('categories'=>$categories,
            					'shops'=>$shops,								
            					'page'=>$page,								
            					'front_limit_pages'=>$front_page_limit,
            					'back_limit_pages'=>$back_page_limit));
            */
            $viewArray = $this->getViewArray($shops_count, $limit, $page, 5);
            $viewArray['shops'] = $shops;
            $viewArray['categories'] = $categories;
            $this->render('list', $viewArray);
            return;
        }
        $this->render('list', array('categories' => $categories, 'shops' => array(), 'front_limit_pages' => 0, 'back_limit_pages' => 0, 'page' => 0));
    }

function getAllWebsiteCategoriesDT()
{
    global $bdd, $_TABLES;
    if (!is_null($bdd) && !is_null($_TABLES)) {
        $content = '<thead>';
        $content .= '<tr>';
        $content .= '<th>Id</th>';
        $content .= '<th>Category</th>';
        $content .= '<th>Website</th>';
        $content .= '<th>Website Category</th>';
        $content .= '<th>Url</th>';
        $content .= '<th>Use Url</th>';
        $content .= '<th>Url Pagination</th>';
        $content .= '<th>Use Pagination</th>';
        $content .= '<th>Action</th>';
        $content .= '</tr>';
        $content .= '</thead>';
        $content .= '<tbody>';
        $objWebsiteCategory = new WebsiteCategory($bdd, $_TABLES);
        $items = $objWebsiteCategory->getAllWebsiteCategories();
        if ($items) {
            foreach ($items as $key => $item) {
                $content .= '<tr website_category_id=' . $item->id . '>';
                $content .= '<td>' . $item->id . '</td>';
                $content .= '<td><select class="select_dt select_dt_category_id">';
                $objCategory = new Category($bdd, $_TABLES);
                $categories_items = $objCategory->getAllCategories();
                if ($categories_items) {
                    foreach ($categories_items as $key_c => $category_item) {
                        $temp_content = '';
                        $temp_content .= '<option value="' . $category_item->id . '" ';
                        if ($category_item->id == $item->category_id) {
                            $temp_content .= 'selected>';
                        } else {
                            $temp_content .= '>';
                        }
                        $temp_content .= $category_item->category . '</option>';
                        $content .= $temp_content;
                    }
                }
                $content .= '</select></td>';
                $content .= '<td><select class="select_dt select_dt_website_id">';
                $objWebsite = new Website($bdd, $_TABLES);
                $websites_items = $objWebsite->getAllWebsites();
                if ($websites_items) {
                    foreach ($websites_items as $key_w => $website_item) {
                        $temp_content = '';
                        $temp_content .= '<option value="' . $website_item->id . '" ';
                        if ($website_item->id == $item->website_id) {
                            $temp_content .= 'selected>';
                        } else {
                            $temp_content .= '>';
                        }
                        $temp_content .= $website_item->website . '</option>';
                        $content .= $temp_content;
                    }
                }
                $content .= '</select></td>';
                $content .= '<td><input type="text" class="input_dt input_dt_website_category" value="' . $item->category . '" /></td>';
                $content .= '<td><input type="text" class="input_dt input_dt_url" value="' . $item->url . '" /></td>';
                $content .= '<td><input type="checkbox" class="input_dt input_dt_use_url" value="' . $item->use_url . '"></input></td>';
                $content .= '<td><input type="text" class="input_dt input_dt_url_pagination" value="' . $item->url_pagination . '" /></td>';
                $content .= '<td><input type="checkbox" class="input_dt input_dt_use_pagination" value="' . $item->use_pagination . '"></input></td>';
                $content .= "<td><input type='button' class='edit edit_website_category_dt' value='Save' />\n\t\t\t\t    <input type='button' class='delete delete_website_category_dt' value='Supprimer' /></td>";
                $content .= '</tr>';
            }
        }
        $content .= '</tbody>';
        return $content;
    } else {
        error_log("BDD ERROR : " . json_encode($bdd));
        error_log("TABLES ERROR : " . json_encode($_TABLES));
    }
}

        }
    } else {
        //不能删除
        admin_redirect('category.php', $res);
    }
} elseif ($act == 'edit') {
    //删除商品分类
    //获取要删除商品分类id
    $c_id = isset($_GET['id']) ? $_GET['id'] : 0;
    $category = new Category();
    $res = $category->getCategoryById($c_id);
    if (!$res) {
        //没有获取到数据
        admin_redirect('category.php', '获取商品信息失败');
    }
    $categories = $category->getAllCategories($res['c_id']);
    //加载编辑表单
    include_once ADMIN_TEMP . '/category_edit.html';
} elseif ($act == 'update') {
    //更新商品分类
    //接受商品分类数据
    $c_name = isset($_POST['category_name']) ? $_POST['category_name'] : '';
    $c_parent_id = isset($_POST['parent_id']) ? $_POST['parent_id'] : 0;
    $c_sort = isset($_POST['sort_order']) ? $_POST['sort_order'] : 50;
    $c_id = isset($_POST['c_id']) ? $_POST['c_id'] : 0;
    //数据合法性验证
    if (empty($c_id)) {
        admin_redirect('category.php', '没有要更新的商品分类信息');
    }
    if (empty($c_name)) {
        admin_redirect("category.php?act=edit&id={$c_id}", '商品名不能为空');

<?php

include 'includes/header.php';
$db = new Database();
$ca = new Category();
$st = new Story();
$categories = $db->select($ca->getAllCategories());
if (isset($_POST['submit'])) {
    //assign post variables
    $title = mysqli_real_escape_string($db->link, $_POST['title']);
    $body = mysqli_real_escape_string($db->link, $_POST['body']);
    $category = mysqli_real_escape_string($db->link, $_POST['category']);
    $author = mysqli_real_escape_string($db->link, $_POST['author']);
    // simple validation
    if ($title == '' || $body == '' || $category == '' || $author == '') {
        // set error
        $error = 'Please fill out all required fields.';
    } else {
        $insert_row = $db->insert($st->setStory($submitter, $category, $title, $author, $body));
    }
}
?>

<h2 class="page-header">Add Story</h2>
<form method="post" action="add_story.php">
  <div class="form-group">
    <label>Story Title</label>
    <input name="title" type="text" class="form-control" placeholder="Enter title">
  </div>
  <div class="form-group">
    <label>Story Body</label>

     }
     array_push($users_array, $avail_user);
 }
 // We need to set a form value for the current department so that
 // it can be pre-selected on the form
 $avail_departments = Department::getAllDepartments($pdo);
 $departments_array = array();
 foreach ($avail_departments as $avail_department) {
     if ($avail_department['id'] == $current_user_dept) {
         $avail_department['selected'] = 'selected';
     } else {
         $avail_department['selected'] = '';
     }
     array_push($departments_array, $avail_department);
 }
 $avail_categories = Category::getAllCategories($pdo);
 $cats_array = array();
 foreach ($avail_categories as $avail_category) {
     array_push($cats_array, $avail_category);
 }
 //////Populate department perm list/////////////////
 $dept_perms_array = array();
 foreach ($departments_array as $dept) {
     $avail_dept_perms['name'] = $dept['name'];
     $avail_dept_perms['id'] = $dept['id'];
     array_push($dept_perms_array, $avail_dept_perms);
 }
 $allDepartments = Department::getAllDepartments($pdo);
 $GLOBALS['smarty']->assign('allDepartments', $allDepartments);
 $GLOBALS['smarty']->assign('current_user_dept', $current_user_dept);
 $GLOBALS['smarty']->assign('t_name', $t_name);

    }
    //删除操作
    $goods = new Goods();
    if ($goods->deleteGoodsById($g_id)) {
        //成功
        admin_redirect('goods.php?act=trash', '商品删除成功！', 2);
    } else {
        //失败
        admin_redirect('goods.php?act=trash', '商品删除失败！', 3);
    }
} elseif ($act == 'add') {
    //新增商品
    //获取所有的商品分类
    $category = new Category();
    //当前项目比较简单，获取全部之后，全部类别都可以使用。
    $categories = $category->getAllCategories();
    //添加模板
    include_once ADMIN_TEMP . '/goods_add.html';
} elseif ($act == 'insert') {
    //保存商品信息
    //接收数据
    $goodsinfo['g_name'] = isset($_POST['goods_name']) ? $_POST['goods_name'] : '';
    $goodsinfo['g_sn'] = isset($_POST['goods_sn']) ? $_POST['goods_sn'] : '';
    $goodsinfo['c_id'] = isset($_POST['category_id']) ? $_POST['category_id'] : 0;
    $goodsinfo['g_price'] = isset($_POST['shop_price']) ? $_POST['shop_price'] : 0;
    $goodsinfo['g_desc'] = isset($_POST['goods_desc']) ? $_POST['goods_desc'] : '';
    $goodsinfo['g_inv'] = isset($_POST['goods_number']) ? $_POST['goods_number'] : 0;
    $goodsinfo['g_is_pro'] = isset($_POST['is_promote']) ? $_POST['is_promote'] : 0;
    $goodsinfo['g_is_new'] = isset($_POST['is_new']) ? $_POST['is_new'] : 0;
    $goodsinfo['g_is_hot'] = isset($_POST['is_hot']) ? $_POST['is_hot'] : 0;
    $goodsinfo['g_is_sale'] = isset($_POST['is_on_sale']) ? $_POST['is_on_sale'] : 0;

require_once './lib/alert.class.php';
require_once './lib/user.class.php';
require_once './lib/category.class.php';
$db = new MySQLi($config['database']['host'], $config['database']['username'], $config['database']['password'], $config['database']['database']);
if ($db->connect_errno) {
    die('Ei tietokantayhteyttä.');
}
$alertClass = new Alert();
$userClass = new User($db);
if (!$userClass->isLoggedIn()) {
    $alertClass->addAlert('Sinun täytyy olla kirjautuneen sisään katsellaksesi kategorioita', 'error');
    $alertClass->redirect('/login.php');
}
$user = $userClass->getCurrentUser();
$categoryClass = new Category($db);
$categories = $categoryClass->getAllCategories($user['id']);
$active = 'categories';
require_once 'header.php';
?>

		<table class="table">
			<thead>
				<tr>
					<th>ID</th>
					<th>Nimi</th>
					<th>Kokonaissumma</th>
					<th></th>
				</tr>
			</thead>
			<tbody>
				<?php 

             admin_redirect('category.php', '删除失败!' . $res, 3);
         }
     } else {
         admin_redirect('category.php', '不能删除商品分类！因为' . $res, 3);
     }
 } else {
     if ($act == 'edit') {
         $c_id = isset($_GET['id']) ? $_GET['id'] : 0;
         if ($c_id == 0) {
             admin_redirect('category.php', '没有要编辑的商品分类！', 3);
         }
         $category = new Category();
         if (!($cat = $category->getCategoryByParentId($c_id))) {
             admin_redirect('category.php', '编辑失败！', 3);
         }
         $categories = $category->getAllCategories($c_id);
         include_once ADMIN_TEMP . '/category_edit.html';
     } else {
         if ($act = 'update') {
             $c_name = isset($POST['category_name']) ? $_POST['category_name'] : '';
             $c_parent_id = isset($POST['c_parent_id']) ? $_POST['c_parent_id'] : 0;
             $c_sort = isset($POST['c_sort']) ? $_POST['c_sort'] : 50;
             $c_id = isset($POST['c_id']) ? $_POST['c_id'] : 0;
             if ($c_id == 0) {
                 //没有要更新的数据
                 admin_redirect('category.php', '没有要更新的商品分类信息！', 3);
             }
             if (empty($c_name)) {
                 //商品分类的名字不能为空
                 admin_redirect('category.php?act=edit&id=' . $c_id, '商品分类名字不能为空！', 3);
             }

 $query = "SELECT table_name FROM {$GLOBALS['CONFIG']['db_prefix']}udf WHERE field_type = '4'";
 $result = mysql_query($query) or die("Error in query163: {$query}. " . mysql_error());
 $num_rows = mysql_num_rows($result);
 $t_name = array();
 $i = 0;
 while ($data = mysql_fetch_array($result)) {
     $explode_v = explode('_', $data['table_name']);
     $t_name = $explode_v[2];
     $i++;
 }
 // For the User dropdown
 $avail_users = $user_perms_obj->user_obj->getAllUsers();
 // We need to set a form value for the current department so that
 // it can be pre-selected on the form
 $avail_departments = Department::getAllDepartments();
 $avail_categories = Category::getAllCategories();
 $cats_array = array();
 foreach ($avail_categories as $avail_category) {
     array_push($cats_array, $avail_category);
 }
 //////Populate department perm list/////////////////
 $dept_perms_array = array();
 foreach ($avail_departments as $dept) {
     $avail_dept_perms['name'] = $dept['name'];
     $avail_dept_perms['id'] = $dept['id'];
     $avail_dept_perms['rights'] = $filedata->getDeptRights($dept['id']);
     array_push($dept_perms_array, $avail_dept_perms);
 }
 //////Populate users perm list/////////////////
 $user_perms_array = array();
 foreach ($avail_users as $user) {

 function getAllCategories()
 {
     $result = $this->Category->getAllCategories();
     return $result;
 }

function getAllCategoryPreferencesDT()
{
    global $bdd, $_TABLES;
    if (!is_null($bdd) && !is_null($_TABLES)) {
        $content = '<thead>';
        $content .= '<tr>';
        $content .= '<th>Id</th>';
        $content .= '<th>User</th>';
        $content .= '<th>Category</th>';
        $content .= '<th>Action</th>';
        $content .= '</tr>';
        $content .= '</thead>';
        $content .= '<tbody>';
        $objCategoryPreference = new CategoryPreference($bdd, $_TABLES);
        $category_preferences = $objCategoryPreference->getAllCategoryPreferences();
        if ($category_preferences) {
            foreach ($category_preferences as $key => $category_preference) {
                $content .= '<tr category_preference_id=' . $category_preference->id . '>';
                $content .= '<td>' . $category_preference->id . '</td>';
                $content .= '<td><select class="select_dt select_dt_user_id">';
                $objUser = new User($bdd, $_TABLES);
                $users_items = $objUser->getAllUsers();
                if ($users_items) {
                    foreach ($users_items as $key_u => $user_item) {
                        $temp_content = '';
                        $temp_content .= '<option value="' . $user_item->id . '" ';
                        if ($user_item->id == $category_preference->user_id) {
                            $temp_content .= 'selected>';
                        } else {
                            $temp_content .= '>';
                        }
                        $temp_content .= $user_item->name . '</option>';
                        $content .= $temp_content;
                    }
                }
                $content .= '</select></td>';
                $content .= '<td><select class="select_dt select_dt_category_id">';
                $objCategory = new Category($bdd, $_TABLES);
                $categories_items = $objCategory->getAllCategories();
                if ($categories_items) {
                    foreach ($categories_items as $key_u => $category_item) {
                        $temp_content = '';
                        $temp_content .= '<option value="' . $category_item->id . '" ';
                        if ($category_item->id == $category_preference->category_id) {
                            $temp_content .= 'selected>';
                        } else {
                            $temp_content .= '>';
                        }
                        $temp_content .= $category_item->category . '</option>';
                        $content .= $temp_content;
                    }
                }
                $content .= '</select></td>';
                $content .= "<td><input type='button' class='edit edit_category_preference_dt' value='Save' />\n\t\t\t\t    <input type='button' class='delete delete_category_preference_dt' value='Supprimer' /></td>";
                $content .= '</tr>';
            }
        }
        $content .= '</tbody>';
        return $content;
    } else {
        error_log("BDD ERROR : " . json_encode($bdd));
        error_log("TABLES ERROR : " . json_encode($_TABLES));
    }
}