source: extensions/MyPiwiShop/admin/options.php @ 27743

<?php
defined('MPS_PATH') or die('Hacking attempt!');


  $select_type_opt=array(
  'select'   =>'select',
  'radio'    =>'radio',
  'text'     =>'text',
  'textarea' =>'textarea',
  'checkbox' =>'checkbox',
  );
  
  if(isset($_POST['check'])){
   foreach($_POST['check'] AS $delete_id){
   
   $query='DELETE FROM '.MPS_OPTION_TABLE.' 
   WHERE id = '.$delete_id.';';
   pwg_query($query);
   
    $query='DELETE FROM '.MPS_PROD_OPT_TABLE.' 
   WHERE opt_id = '.$delete_id.';';
   pwg_query($query);
  
   $query='DELETE FROM '.MPS_OPT_VAL_TABLE.' 
   WHERE select_id = '.$delete_id.';';
   pwg_query($query);
   $page['infos']=l10n('deleted');
   }
   }   

if (isset($_POST['option_add']))
{
if(empty($_POST['id']))
        {
        
        $order = array();
        $query ='SELECT * FROM '.MPS_OPTION_TABLE.';';
        $result = pwg_query($query);
        while($row = pwg_db_fetch_assoc($result)){
        $order[] = $row['order'];
        }
        if (count($order) == 0) {
        $order = 1;
        }else{
        $order = max($order)+1;
        }
        
        $name           = $_POST['name'];
    $type               = $_POST['type'];
    $title              = $_POST['title'];
        
        if(isset($_POST['requi'])){
         $requi = $_POST['requi'];
         }else{
         $requi = 0;
         }
        
        
        $query='INSERT into '.MPS_OPTION_TABLE.' (`name`,`type`,`titre`,`requi`,`order`) 
                        values (\''.$name.'\',\''.$type.'\',\''.$title.'\',\''.$requi.'\',\''.$order.'\');';
   
        pwg_query($query);              
        $select_id = pwg_db_insert_id();                        
                        
        if(isset($_POST['val'])){
        $val            = $_POST['val'];


    foreach($val as $val_ele)
    {
         $query='INSERT into '.MPS_OPT_VAL_TABLE.' (val,select_id) 
                        values (\''.$val_ele.'\',\''.$select_id.'\');';
         $result = pwg_query($query);
    }
        if($result==1)
        $page['infos']=l10n('Option registered');
        else
        $page['errors']=l10n('Error');
        }
        }

if(!empty($_POST['id']))
        {

        $name           = $_POST['name'];
    $type               = $_POST['type'];
    $title              = $_POST['title'];
        $id                     = $_POST['id'];
        
        if(isset($_POST['requi'])){
         $requi = $_POST['requi'];
         }else{
         $requi = 0;
         }

        $query='UPDATE '.MPS_OPTION_TABLE.' 
        SET name = \''.$name.'\', type = \''.$type.'\', titre = \''.$title.'\', requi = \''.$requi.'\'
        WHERE id = '.$id.'
        ;';
    pwg_query($query);
        
        $query='DELETE FROM '.MPS_OPT_VAL_TABLE.' 
        WHERE select_id =  '.$id.'
        ;';
        pwg_query($query);
   
        if(isset($_POST['val'])){
        $val            = $_POST['val'];

    foreach($val as $val_ele)
    {
        
         $query='INSERT into '.MPS_OPT_VAL_TABLE.' (val,select_id) 
                        values (\''.$val_ele.'\',\''.$id.'\');';
         $result = pwg_query($query);
    }
        }
   $page['infos']=l10n('Option registered');

        }

}

if(isset($_POST['newOrder']))
        {
        $newOrder = explode(",", $_POST['newOrder']);
        $ex = array_pop($newOrder);
        
        foreach( $newOrder as $order => $id )
        {
        $order = $order +1;

      $query='UPDATE '.MPS_OPTION_TABLE.' SET `order` = \''.$order.'\' WHERE id = '.$id.';';
        $result = pwg_query($query);
    
    $page['infos']=l10n('the order is changed');

    }
}

  $query='
  SELECT *  FROM '.MPS_OPTION_TABLE.' ORDER BY `order` ;';

  $option = array();
  $result = pwg_query($query);
  while($row = pwg_db_fetch_assoc($result)){
         $query='
         SELECT *
         FROM '.MPS_OPT_VAL_TABLE.' 
     WHERE select_id = '.$row['id'].'
         ;';
        $val = array(); 
        $res = pwg_query($query);
         while($row1 = pwg_db_fetch_assoc($res)){
         $val[]= $row1['val'];
         }
        $opt = array("id"        =>$row['id'],
                                 "title" =>$row['titre'],
                                 "name"  =>$row['name'],
                                 "type"  =>$row['type'],
                                 "requi" =>$row['requi'],
                                 "val"   =>$val
                                        );
        $option[$row['id']] = $opt;
        
 }              


   $template->assign(array(
         'mps_option'   => $option,
         'mps_type_opt' => $select_type_opt
         ));


$template->set_filename('mps_content', realpath(MPS_PATH . 'admin/template/options.tpl'));