PHP Classes

File: actions.class.php

Recommend this page to a friend!
  Classes of Ersin Güvenç  >  PHP Cat Nested Model Category Class  >  actions.class.php  >  Download  
File: actions.class.php
Role: Class source
Content type: text/plain
Description: mysql actions
Class: PHP Cat Nested Model Category Class
Manage an hierarchy of categories stored in MySQL
Author: By
Last change: -seo.actions and actions.class joined in one class.
Date: 13 years ago
Size: 11,563 bytes
 

Contents

Class file image Download
<?php if (realpath(__FILE__) == realpath($_SERVER['SCRIPT_FILENAME'])) {exit('No direct access!');} /************************************** * @filename: actions.class.php * @author: Ersin Güvenç * This class is part of the php_cat class. */ //Purely static class... class Actions extends php_cat { static $instance; public function __construct() {} //this object can not copy except getInstance() method. private function __clone() {} //prevent duplication of memory using by Singleton Pattern. public static function getInstance() { if(! (self::$instance instanceof self)) { self::$instance = new self(); } return self::$instance; } //set php_cat construct parameters public function set_params($params){ $this->seo = $params['seo']; //.. } /** * * @Method: id_exists * @Access: protected * @Parameters: 1 * @Param-1: data['cat_id'] * @Description: Check id exist or not exist in database. */ protected function id_exists($cat_id){ $sql = sprintf("SELECT %s FROM %s WHERE %s='%d'",CAT_NAME,TABLE_NAME,CAT_ID,$cat_id); $query = mysql_query($sql); if(!$query) throw new cat_Exception(mysql_error()); if(mysql_num_rows($query) == 0): return false; else: return true; endif; } ###################### # ADD CATEGORY SQL # You can create data store procudure from original sql. ###################### /* INSERT INTO category (cat_name,parent_id,dsc,cat_link,lft,rgt) VALUES ('%s','%d','%s','%s','1','2'); */ /* LOCK TABLE category WRITE; SELECT @myRight := rgt FROM category WHERE cat_id = '$cat_id'; UPDATE category SET rgt = rgt + 2 WHERE rgt > @myRight; UPDATE category SET lft = lft + 2 WHERE lft > @myRight; INSERT INTO category(cat_name,parent_id,dsc,cat_link,lft,rgt) VALUES('$new_catname','0','$dsc','$link', @myRight + 1,@myRight + 2); UNLOCK TABLES; */ /** * * @Method: add_cat * @Access: public * @Parameters: 1 * @Param-1: data - array - cat_id,new_name,parent_id * @Description: Add New Category (add a not existing category). */ public function add_cat($data) { if(!array_key_exists('new_name',$data)) throw new cat_Exception("Please provide a associative array that contain new category name (new_name)."); if(!array_key_exists('cat_id',$data)) throw new cat_Exception("Please provide cat_id!"); if(!array_key_exists('parent_id',$data)) throw new cat_Exception("Please provide parent_id!"); $parent = (int)$data['cat_id']; $constant = "CAT_ID"; $level = $this->depth(array('cat_id'=>$parent)); //if cat_id level (depth) == 0 parent_id must be = 0 //print_r($level); if($level['depth'] == 0){ $parent_id = 0; }else{ $parent_id = $data['parent_id']; } switch ($this->seo) { case 0: $link = ""; //seo false. break; case 1: //seo true. #### create seo insert link. $seo = Seo::getInstance(); $link = $seo->insert($data['new_name']); #### create seo insert link. break; } //if no any record in database ! if($this->fetch_num() == 0){ $FIRST_CAT = sprintf("INSERT INTO %s (%s,%s,%s,%s,%s,%s) VALUES ('%s','%d','%s','%s','1','2')", TABLE_NAME,CAT_NAME,PARENT_ID,DSC,CAT_LINK,LEFT,RIGHT,$data['new_name'],0,$data['dsc'],$link); $query = mysql_query($FIRST_CAT); if(!$query) throw new cat_Exception(mysql_error()); }else{ $LOCK_TABLE = sprintf("LOCK TABLE %s WRITE ",TABLE_NAME); //lock tables in current mysql user session. $SELECT = sprintf("SELECT @myRight := %s FROM %s WHERE %s = '%s'",RIGHT,TABLE_NAME,constant($constant),$parent); $UPDATE_RIGTH = sprintf("UPDATE %s SET %s = %s + 2 WHERE %s > @myRight",TABLE_NAME,RIGHT,RIGHT,RIGHT); $UPDATE_LEFT = sprintf("UPDATE %s SET %s = %s + 2 WHERE %s > @myRight",TABLE_NAME,LEFT,LEFT,LEFT); $INSERT = sprintf("INSERT INTO %s (%s,%s,%s,%s,%s,%s) VALUES ('%s','%d','%s','%s',@myRight + 1,@myRight + 2)",TABLE_NAME, CAT_NAME,PARENT_ID,DSC,CAT_LINK,LEFT,RIGHT,$data['new_name'],$parent_id,$data['dsc'],$link); $UNLOCK_TABLE = "UNLOCK TABLES"; //echo $SELECT."\n".$UPDATE_RIGTH."\n".$UPDATE_LEFT."\n".$INSERT."\n"; //echo $INSERT; if(!mysql_query($LOCK_TABLE)) throw new cat_Exception(mysql_error()); if(!mysql_query($SELECT)) throw new cat_Exception(mysql_error()); if(!mysql_query($UPDATE_RIGTH)) throw new cat_Exception(mysql_error()); if(!mysql_query($UPDATE_LEFT)) throw new cat_Exception(mysql_error()); if(!mysql_query($INSERT)) throw new cat_Exception(mysql_error()); if(!mysql_query($UNLOCK_TABLE)) throw new cat_Exception(mysql_error()); } feedback::add('New category added!'); } ###################### # ADD SUB CATEGORY SQL # You can create data store procudure from original sql. ###################### /* LOCK TABLE category WRITE; SELECT @myLeft := lft FROM category WHERE name = '$cat_name'; UPDATE category SET rgt = rgt + 2 WHERE rgt > @myLeft; UPDATE category SET lft = lft + 2 WHERE lft > @myLeft; INSERT INTO category(cat_name, parent_id, lft, rgt) VALUES('$new_cat_name', parent_id, @myLeft + 1, @myLeft + 2); UNLOCK TABLES; */ /** * * @Method: add_subcat * @Access: public * @Parameters: 1 * @Param-1: data - array - pointer .. new_name,cat_id * @Description: Add sub category inside a existing category.if category has no children use add_subcat */ public function add_subcat($data) { if(!array_key_exists('new_name',$data)) throw new cat_Exception("Please provide a associative array that contain new category name (new_name)."); if(!array_key_exists('cat_id',$data)) throw new cat_Exception("Please provide cat_id!"); //if(!array_key_exists('parent_id',$data)) throw new cat_Exception("Please provide parent_id!"); $parent = (int)$data['cat_id']; $constant = "CAT_ID"; switch ($this->seo) { case 0: $link = ""; //seo false. break; case 1: //seo true. #### create seo insert link. $seo = Seo::getInstance(); $link = $seo->insert($data['new_name']); #### create seo insert link. break; } $LOCK_TABLE = sprintf("LOCK TABLE %s WRITE",TABLE_NAME); //lock tables in current user session. $SELECT = sprintf("SELECT @myLeft := %s FROM %s WHERE %s = '%s'",LEFT,TABLE_NAME,constant($constant),$parent); $UPDATE_RIGTH = sprintf("UPDATE %s SET %s = %s + 2 WHERE %s > @myLeft",TABLE_NAME,RIGHT,RIGHT,RIGHT); $UPDATE_LEFT = sprintf("UPDATE %s SET %s = %s + 2 WHERE %s > @myLeft",TABLE_NAME,LEFT,LEFT,LEFT); $INSERT = sprintf("INSERT INTO %s (%s,%s,%s,%s,%s,%s) VALUES ('%s','%s','%s','%s',@myLeft + 1,@myLeft + 2)", TABLE_NAME,CAT_NAME,PARENT_ID,DSC,CAT_LINK,LEFT,RIGHT,$data['new_name'],$parent,$data['dsc'],$link); $UNLOCK_TABLE = "UNLOCK TABLES"; if(!mysql_query($LOCK_TABLE)) throw new cat_Exception(mysql_error()); if(!mysql_query($SELECT)) throw new cat_Exception(mysql_error()); if(!mysql_query($UPDATE_RIGTH)) throw new cat_Exception(mysql_error()); if(!mysql_query($UPDATE_LEFT)) throw new cat_Exception(mysql_error()); if(!mysql_query($INSERT)) throw new cat_Exception(mysql_error()); if(!mysql_query($UNLOCK_TABLE)) throw new cat_Exception(mysql_error()); feedback::add('New Subcategory added!'); } ###################### # UPDATE CATEGORY SQL ###################### /* UPDATE category SET cat_name='$new_name',dsc='$dsc',cat_link='$link' WHERE cat_id='$current_id' */ /** * * @Method: update_cat * @Access: public * @Parameters: 1 * @Param-1: data - array - pointer .. WHERE = 'cat_name' or cat_id * @Description: Update cat_name,dsc,cat_link fields on current category. */ public function update_cat($data) { //print_r($data); if(!array_key_exists('new_name',$data)) throw new cat_Exception("Please provide a new category name (new_name)."); if(!array_key_exists('cat_id',$data)) throw new cat_Exception('Please provide a cat_id !'); $current_id = (int)$data['cat_id']; $constant = "CAT_ID"; //if not exist id in database. if(!$this->id_exists($data['cat_id'])) throw new cat_Exception("This category ID not found in database!"); switch ($this->seo) { case 0: $link = ""; //seo false. break; case 1: //seo true. #### create seo update link. $seo = Seo::getInstance(); $link = $seo->update($data['new_name'],$current_id); #### create seo update link. break; } //echo $link; $UPDATE = sprintf("UPDATE %s SET %s='%s',%s='%s',%s='%s' WHERE %s='%s'", TABLE_NAME,CAT_NAME,$data['new_name'],DSC,$data['dsc'],CAT_LINK,$link,constant($constant),$current_id); if(!mysql_query($UPDATE)) throw new cat_Exception(mysql_error()); feedback::add('Category updated!'); } /** * * @Method: del_cat * @Access: public * @Parameters: 1 * @Param-1: data - array - pointer .. WHERE = 'cat_name' or cat_id * @Description: Delete current category and their children. */ ###################### # DELETE CATEGORY SQL # You can create data store procudure from original sql. ###################### /* LOCK TABLE category WRITE; SELECT @myLeft := lft, @myRight := rgt, @myWidth := rgt - lft + 1 FROM category WHERE name = 'TELEVISIONS'; DELETE FROM category WHERE lft BETWEEN @myLeft AND @myRight; UPDATE category SET rgt = rgt - @myWidth WHERE rgt > @myRight; UPDATE category SET lft = lft - @myWidth WHERE lft > @myRight; UNLOCK TABLES; */ public function del_cat($data) { if(!array_key_exists('cat_id',$data)) throw new cat_Exception('Please provide a cat_id !'); $parent = (int)$data['cat_id']; $constant = "CAT_ID"; //if not exist id in database. if(!$this->id_exists($data['cat_id'])) throw new cat_Exception("This category ID not found in database!"); $LOCK_TABLE = sprintf("LOCK TABLE %s WRITE",TABLE_NAME); //lock tables in current user session. $SELECT = sprintf("SELECT @myLeft := %s, @myRight := %s, @myWidth := %s - %s + 1 FROM %s WHERE %s = '%s'", LEFT,RIGHT,RIGHT,LEFT,TABLE_NAME,constant($constant),$parent); $DELETE = sprintf("DELETE FROM %s WHERE %s BETWEEN @myLeft AND @myRight",TABLE_NAME,LEFT); $UPDATE_RIGTH = sprintf("UPDATE %s SET %s = %s - @myWidth WHERE %s > @myRight",TABLE_NAME,RIGHT,RIGHT,RIGHT); $UPDATE_LEFT = sprintf("UPDATE %s SET %s = %s - @myWidth WHERE %s > @myRight",TABLE_NAME,LEFT,LEFT,LEFT); $UNLOCK_TABLE = "UNLOCK TABLES"; //echo $LOCK_TABLE.$SELECT.$DELETE.$UPDATE_RIGTH.$UPDATE_LEFT.$UNLOCK_TABLE; if(!mysql_query($LOCK_TABLE)) throw new cat_Exception(mysql_error()); if(!mysql_query($SELECT)) throw new cat_Exception(mysql_error()); if(!mysql_query($DELETE)) throw new cat_Exception(mysql_error()); if(!mysql_query($UPDATE_RIGTH)) throw new cat_Exception(mysql_error()); if(!mysql_query($UPDATE_LEFT)) throw new cat_Exception(mysql_error()); if(!mysql_query($UNLOCK_TABLE)) throw new cat_Exception(mysql_error()); feedback::add('Category deleted!'); } } // end class.. ?>