source: extensions/MyPiwiShop/admin/product.php @ 27781

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

// delete option
  if(isset($_POST['check'])) {
  
   foreach($_POST['check'] AS $delete_id) {
   
    pwg_query('
    DELETE FROM '.MPS_PRODUCT_TABLE.' 
    WHERE id = '.$delete_id.'
    ;');
   
    pwg_query('
    DELETE FROM '.MPS_PROD_OPT_TABLE.' 
    WHERE product_id = '.$delete_id.'
    ;');
   }   
   
   $page['infos']=l10n('deleted');
  }   

//Add/Edit product
  if(isset($_POST['product_add'])) {
  
  //Add product
    if (empty($_POST['id'])) {
        
         $order = array();
         $query ='
         SELECT `order`
         FROM '.MPS_PRODUCT_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;
         }
        
         $product       = $_POST['product'];
         $noteAdmin     = $_POST['noteAdmin'];
         $price         = $_POST['price'];

        
     pwg_query('
         INSERT into '.MPS_PRODUCT_TABLE.' (`order`,`product`,`noteAdmin`,`price`) 
         VALUE (\''.$order.'\',\''.$product.'\',\''.$noteAdmin.'\',\''.$price.'\');
         ');
         $prod = pwg_db_insert_id();
   
     if(isset($_POST['opt'])) {
          $opt = $_POST['opt'];
      $inserts = array();
          
      foreach ($opt as $opt_id) {
       $inserts[] = array(
        'opt_id' => $opt_id,
        'product_id' => $prod,
       );
      }
          
      mass_inserts(
      MPS_PROD_OPT_TABLE,
      array_keys($inserts[0]),
      $inserts
      );
     }
         
         $page['infos']=l10n('Product registered');
    }
        
  //Edit product        
    if(!empty($_POST['id'])) {
        
         $id            = $_POST['id'];
         $product       = $_POST['product'];
         $noteAdmin     = $_POST['noteAdmin'];
         $price         = $_POST['price'];

         pwg_query('
         UPDATE '.MPS_PRODUCT_TABLE.' 
         SET product = \''.$product.'\',noteAdmin = \''.$noteAdmin.'\',price=\''.$price.'\'
         WHERE id = '.$id.'
         ;');
   
     pwg_query('
         DELETE FROM '.MPS_PROD_OPT_TABLE.' 
         WHERE `product_id` IN ('.$id.')
         ;');
        
         if(isset($_POST['opt'])) {
          $opt          = $_POST['opt'];
      $inserts  = array();
          
      foreach ($opt as $opt_id) {
       $inserts[] = array(
        'opt_id'         => $opt_id,
        'product_id' => $id,
       );
      }
          
     mass_inserts(
     MPS_PROD_OPT_TABLE,
     array_keys($inserts[0]),
     $inserts
     );
     }

    $page['infos']=l10n('Edit');
    }

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

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

if (isset($_POST['option_add'])) {
         $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;
         }
        
         pwg_query('
         INSERT into '.MPS_OPTION_TABLE.' (`name`,`type`,`titre`,`requi`,`order`) 
         VALUE (\''.$name.'\',\''.$type.'\',\''.$title.'\',\''.$requi.'\',\''.$order.'\')
         ;');
   
         $select_id = pwg_db_insert_id();                       
                        
         if(isset($_POST['val'])) {
         $val           = $_POST['val'];
         
      foreach($val as $val_ele) {
           pwg_query('
           INSERT into '.MPS_OPT_VAL_TABLE.' (`val` , `select_id`) 
           VALUE (\''.$val_ele.'\',\''.$select_id.'\')
           ;');
      }
          
         }
        
        echo('<div><div id="idlastopt" data-idlo="'.$select_id.'"></div></div>');
  }

// set product    
  $query='
  SELECT p.id, p.order, p.product, p.noteAdmin, p.price, o.name 
  FROM '.MPS_PRODUCT_TABLE.' AS p
  LEFT JOIN '.MPS_PROD_OPT_TABLE.' AS op ON op.product_id = p.id
  LEFT JOIN '.MPS_OPTION_TABLE.' AS o ON o.id = op.opt_id
  ORDER BY p.order
  ;';
  $result = pwg_query($query);
  
  while($row = pwg_db_fetch_assoc($result)) {
  
   if (!isset($products[ $row['id']])) {
        $products[$row['id']] = array(
         'id'        => $row['id'],
     'product'   => $row['product'],
     'noteAdmin' => $row['noteAdmin'],
     'price'     => $row['price'],
          );
   }
   
   $products[$row['id']]['option'][]=$row['name'];
  }

  $query='
  SELECT `id`, `name`
  FROM '.MPS_OPTION_TABLE.' 
  ;';
  $result = pwg_query($query);
  $option = array();
  
  while($row = pwg_db_fetch_assoc($result)) {
   $option[$row['id']] = $row['name'];
  }
  
  $select_type_opt=array(
   'select'   =>'select',
   'radio'    =>'radio',
   'text'     =>'text',
   'textarea' =>'textarea',
   'checkbox' =>'checkbox',
  );
  
//template assign
  $template->assign(array(
   'mps_product'         => $products,  
   'mps_option'          => $option,
   'mps_type_opt' => $select_type_opt,
  ));
  
  $template->set_filename('mps_content', realpath(MPS_PATH . 'admin/template/product.tpl'));