$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('

'); } // 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'));