<?php

  if (isset($_GET["mode"])){$mode=$_GET["mode"];}
    else{$mode="view";}

  if (isset($_GET["groopa_id"]) and $_GET["str"]=="groopa")
    {
        $groopa = new groopa($_GET["groopa_id"]);
    }else
    {
        $groopa = new groopa("");
    } 
    
    if ($mode=="del" and isset($_GET["groopa_id"]) and $_GET["str"]=="groopa" and isset($_GET["ok"]))
    {

        $groopa->del();

    } 
    else if($mode=="edit" and isset($_GET["groopa_id"]) and $_GET["str"]=="groopa" and isset($_GET["ok"]))
    { 
 
        $groopa->name = $_POST["name"];
                                                  



        $groopa->edit();  

    }    
    else if ($mode=="new" and $_GET["str"]=="groopa" and isset($_GET["ok"]))
    {    
        $groopa->name = $_POST["name"]; 
        $groopa->save();
    }


       if ($mode=='view' and !isset($_GET['groopa_id'])  and $_GET["str"]=="groopa")
    {
        ShowListgroopa();
    }  
    else if ($mode=='edit' and isset($_GET['groopa_id'])  and $_GET["str"]=="groopa")
    {
        $groopa->ShowEdit();
    }   
        else if($mode=='show' and isset($_GET["groopa_id"])  and $_GET["str"]=="groopa")
    {
        $groopa->show(); 

    }  
    else if ($mode=='del' and isset($_GET['groopa_id'])  and $_GET["str"]=="groopa")
    {
        $groopa->del();   
    }   
    else if ($mode=='new'  and $_GET["str"]=="groopa")
    {
        $groopa->ShowNew();
    }          
 ?>

<?php
require_once '../system/global.php';
class groopa{

    

var $id;
var $name;
 
    

 function groopa($id)
        {
            if($id=="")
            {
                $this->name="";

            }
            else
            {
                $query = "select *
                    from `".BCRM."groopa`
                    where id='".$id."' 
                    order by name ASC";
                $sql = mysql_query($query) or die(mysql_error());
                if (mysql_numrows($sql) == 1)
                {
                    $row = mysql_fetch_array($sql);
                    $this->id=$id;
                $this->name=$row['name'];
         
                }  
            }  
        }    
    
    
    
    

//edit
function ShowEdit(){

 
       echo'
       <form name="groopaedit'.$this->id.'" action="?str=groopa&mode=edit&groopa_id='.$this->id.'&ok" method="post">
       
Имя <input name="name" value="'.$this->name.'"><br>  

      <a href="#" onclick="javascript: document.groopaedit'.$this->id.'.submit(); return false;">Сохранить</a>  <a href="?mode=view">Отмена</a><br>
      </form>';    
  
}
 //add
 function ShowNew(){
     
           echo'
       <form name="groopasave'.$this->id.'" action="?str=groopa&mode=new&ok" method="post">
           
Имя <input name="name" value="'.$this->name.'"><br>  
 
      <a href="#" onclick="javascript: document.groopasave'.$this->id.'.submit(); return false;">Сохранить</a>  <a href="?mode=view">Отмена</a><br>
      </form>';    
}
//del
function del(){

    $query = "delete from `".BCRM."groopa` WHERE `id`='".$this->id."'";
            $sql = mysql_query($query) or die(mysql_error());   

}
//save
  function save()                            
        {  
       

              
                 
            $query = "insert into `".BCRM."groopa`( 
  `name`)
                values('".$this->name."')";
                    //echo $query; exit();
            $sql = mysql_query($query) or die(mysql_error());

        }



        function edit()
        {
   $query = "update `".BCRM."groopa` set 
            `name`='".$this->name."'
                        where `id`='".$_GET['groopa_id']."'";
                         //  print_r($query); 
            //echo $query;
            $sql = mysql_query($query) or die(mysql_error());

        } 
        } 
        
        
        
        
        
        
function ShowListgroopa(){

       $i='0';      
    
echo'
    <a href="?str=groopa&mode=new">Добавить</a>
<table class="vivod" border="1" cellspacing="0" align="center" width="100%">
<tr>  <td>Имя</td><td>Изменить</td>  <td>Удалить</td> </tr>';   
  $query = "SELECT *
   FROM `".BCRM."groopa` name by por ASC";   
                  //     print_r($query);
                $sql = mysql_query($query) or die(mysql_error());
                  while ($row=mysql_fetch_array($sql)) 
                  
        {      
    
   echo'<tr ';if($i < '1'){  $i++; echo'style=" background: #99CCFF; "';}else{ $i='0'; }echo'> 
   <td> '.$row['name'].' </td>
  
     <td><a href="?mode=edit&str=groopa&groopa_id='.$row['id'].'">Изменить</a></td>  <td><a href="?mode=del&str=groopa&groopa_id='.$row['id'].'">Удалить</a></td> </tr>'; 
    
        }   
}
 ?>